Added: June/30/2004 at 8:59am | IP Logged

i hav a problem to display records in a table, the problem is it's not a normal display. look at the following:

myRS.Open .....
myRS.Find("Codes LIKE '*CR21*'")

the find function finds the necessary records but as soon as i try to display them in the table it only displays one record. now let's say that the find returned 7 records found, it sould display only those 7 records. my problem is to display all 7?

Added: June/30/2004 at 11:05am | IP Logged

It's normal for it to only show the 1st result.

You have to make a while/wend loop.. with a movenext command

If you want to see more than one record..

Like in this example

http://www.powerasp.com/content/database/select_loop.asp

Now, peronsally I have never used that find command like you are doing so I dont know about that. I always do all of that right in the SQL statement..

Added: July/01/2004 at 3:11am | IP Logged

thnx chris, but my problem was quite simple. to display only the records the "find" function found i had to loop them out, which is quite correct. but instead it displays all the records in the table, and that's not what i wanted.

so what i did was to "Filter" the specific records out using the "While Not .. Wend" statement, which solved my problem. thnx for the help anyways.