databind to a dropdown list

[dazza12345]

Hi all, what im looking to do is create a data function that will traverse through a database and collect values of 1 column in the database for a certain user (i.e. WHERE UserID = 1).

Has any1 got an example data function that I could use, that will output the colum of data that I require into an array then databind this array to the drop down list.

Cheers

 

[ca8msm]

Just use a SQL statement with the WHERE clause that you have specified above. You can loop through the results by using one of the methods from faq855-5662.


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.