I am trying to find info on how to build sql on th
I need to have a series of combo boxes that will build a sql statement on the fly....such as one for "select" and a bunch for "order by" <BR><BR>any help in this matter will be greatly apreciated..<BR><BR>thanks,<BR><BR>J
Jees buddy testy? <BR><BR>usually I post a question and someone points me toward a FAQ or tutorial encapsulating the main idea of my problem....<BR><BR>So, does anybody know where I can find info on achieving SQL on the fly?<BR><BR>thank you as always,<BR>J
Write code for each of your form options - if a selection was made, append to the SQL statement. If not selection was made, then don't.<BR><BR>Keep in mind that you need to end up with a valid SQL statement.<BR><BR>Search the messageboard for examples. I know this has been talked about repeatedly.