ODBiC Discussion Board


Question with OPTION Lists

by Frank Wagoner, March 19, 2005 18:33

I have several drop-downs that contain the same information pulled from a table. An example is below:

<SELECT NAME="Wheel_Choice_1"> <!--SQL SELECT Brand, Model, Size, FROM Wheels ORDER BY 1, 2, 3 --> <!--EACHROW--> <OPTION>$Brand$ $Model$ $Size$ <!--ENDROW--> </SELECT> <SELECT NAME="Wheel_Choice_2"> <!--SQL SELECT Brand, Model, Size, FROM Wheels ORDER BY 1, 2, 3 --> <!--EACHROW--> <OPTION>$Brand$ $Model$ $Size$ <!--ENDROW--> </SELECT>

I was wondering if there was any way I could store the first SELECT statement results so that I wouldn't have to query the "Wheels" table again for the same results.

Thanks for any suggestions! Frank :)


Replies:


Post Your Reply:

Name   
E-mail  optional
Topic  
Message:

HTTP Link: 
Link text: 

          


Copyright ©1997-2003, Roger Harris. All rights reserved.