Forums

This topic is locked

Request.form variable in sql statement

Posted 08 Feb 2008 23:48:58
1
has voted
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

Reply to this topic