query or new field

Results 1 to 3 of 3

Thread: query or new field

  1. #1
    Gabo Guest

    Default query or new field

    I'm displaying names from a db onto an ASP but I want to be able to display beside each name how many messages they have. Do I need to create a new field in my db to count the messages for each person or can I use a query in the code?

  2. #2
    Medieval Dude Guest

    Default RE: query or new field

    This sounds like something you could do within the query, depending on how yer data is setup. COUNT(*) will work if yer using SQL Server.

  3. #3
    Join Date
    Dec 1969

    Default RE: query or new field

    If you are grabbing all the data with a GetRows you could do a Ubound(myArray,2) to get the number of items in the array.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts