Hi,
This is going to seem trivial for all of you, but I hope you can spare me a
min.
I have a page, in which I want it to modify a SQL query depending on a
users' selection. For exampls, the following SQL:
SELECT * FROM advert_details WHERE county = 'berks'
What I need to do is have a Select drop down box, which I have dynamically
populated, as a second option - "To filter data, please choose a category" -
then that would modify the SQL,hopefully, to read:
SELECT * FROM advert_details WHERE county = 'berks' and category = 143
How can I do this?
Thanks,
Will
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.