Forums
This topic is locked
Request.form variable in sql statement
08 Feb 2008 23:48:58 TJ Cole posted:
I've been working on this problem for 2 days now and have tried everythign I can think of to fix it with no results.I have a listbox that is populated by a database. I want to retrieve data from database in sql statement using the value of the listbox (depending on what the user pics).
I've set up recordset in dreamweaver that says:
select Price from Table where Categories = MMColParam
The problem is that the sql statement is being executed when the page first opens and is being given default value. I would like to be able to tell the sql statement when to fire. Is this possible?
Ideal I'd like to call function on change of listbox and fire the sql statement from there, Again is this possible???
Please help.
Thanks
Replies
Replied 09 Feb 2008 07:46:18
09 Feb 2008 07:46:18 Javier Castro replied:
can you post the rest of your code?
What do you have under parameters?
Javier
"I'm a slow learner and I forget fast" grandpa
DW | FW | ASP | HTML | CSS
What do you have under parameters?
Javier
"I'm a slow learner and I forget fast" grandpa
DW | FW | ASP | HTML | CSS