DWMX help needed Select Menu and Request.QueryString

[am7555]

Hi All,
I'm Working with Dreamweaver 8, ASP Classic.

I have an Insert Record form. The form has a Select menu, with categories,below there are text fields for content.
when the form is sunmitted it reloads to the same page with an empty form, to input another record.

My problem:
I want to be able to select a category from my menu, fill the text field and submit and when the page loads again my previous selection should stays the same, unless I decide to change it.

I did something like this but with a text field on a search form.
Any help will be very much appreciated. I'll say you uncle.

Javier

 

[lebisol]

I want to be able to select a category from my menu"
---------------------------------------------------
logic goes:
1. pull the recordset (table/querry) that contains field holdig the category name or id (whichever you are trying to insert)
2.use the recordset field value as a dynamic value of the form menu
3. proceed with record insertion

"...and when the page loads again my previous selection should stays the same"
---------------------------------------------------
at this point you have inserted the records and probably should use different page.asp just to keep the code simple but it is Not necessary.

4. pull the recordset that is now filtered by a form field(s) you used to enter ('better' way would be using a session ID or auto increment ID see:

http://www.drdev.net/article08.htm

or

http://www.drdev.net/article06.htm)

and show your 'results'...you can stick them back into form fields if you need to add or continue inserting additional info.
DW 'builtin' functions have to concept marked "insert record" and "go to details page"

Hope it helps....sometimes I miss webdev.
All the best!

:--------------------------------------:

All around in my home town,
They tryin' to track me down...

 

[lebisol]

and to match your topic title...you can (step 4) filter the recordset by a querry string as well.
Either way...kill your session vars quickly and don't forget about sql injection.

:--------------------------------------:

All around in my home town,
They tryin' to track me down...

 

[am7555]

Thanks for your suggestion lebisol. As I'm not really a coder it will take me a little while to figure the Article links you sent. In the meantime I am working on a work around.

Thanks. Uncle