----- Original Message ----- From: "Jillian Carroll" <[EMAIL PROTECTED]> > Can anybody please help me with this page? I've been fooling around > with it forever and I'm just not having any luck. > > There are two things that I need help with: > > 1. Why aren't my dropdowns working properly? They should be pulling > the data from the database and displaying it when possible. As it > stands, they just look like regular drop-downs, no matter what value is > in the db. This code has worked for me on other forms, but for some > reason I must have done something different here.
What's happening with the drop-downs? Not sure I understand from this. Is there no data returned by the queries that populate them? If there is data returned, is it not being output correctly in the drop-down? In what way is are the drop-downs not working? As you say you've been fooling around with them a lot, I assume you've done the usual routine of paring your code down in a test page to the bare minimum that's needed to causes the error, and carry on paring until the error doesn't appear... Not sure about multiple INSERTs, though I'm certain this is a topic that you'll find some coverage of in the list archives. I think as far as SQL syntax goes, it's one INSERT at a time. HTH, Gyrus [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://norlonto.net PGP key available ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
