> I have a list of check boxes that when checked passes the resultsID
> from the database to another template. Then in the template I want to
> query the database again and based on the resultsID(s) grab the other
> fields from the database.
>
You need a WHERE x IN list on your select, so :
SELECT ResultsID, User, Admin
FROM tblResults
WHERE ResultsID IN (#form.resultsID#)
If your list were a set of alphabetic values then you would need to make
sure that the each item in the list has quotes around it.
Hope this helps
Regards
Stephen
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
