I've done several searches here and couldn't find the proper tutorial or same problem that people are having.

I have a dynamic drop-down list and once user selects 'submit' i want it to go to a detail page where it'll query the selection.

I'm able to setup a dynamic query and link to detail page, but can't find any clues as how to do it as a dynamic list.

i've tried the dynamic list, but i always get no record found, or it queries blank.

i did noticed that the detail page "url parameter" is different way of sending the variables compared to drop down list.

a tutorial link or some clues would be nice.

thanks in advance!

?

let me see if i understand what you're asking, your menu is populated but the detail page is not ?

If that is true then you need to change where your recordset gets it's parameters from, it is now probably set to url parameter and you want form parameters, or you can switch the action type of your form from post to get so that your detail page has a url parameter.

here's more on URL parameters:
www.macromedia.com/support/ultradev/content/url_parameters/

HTH

with regards,

Dennis van Galen
Webmaster KPN Telecom Holland
Financial & Information Services

Studio MX / CFMX PRO / SQL 2000 / NT4 AND win2kPRO / IIS5

yes, it's a drop down list dynamic menu form, once they select something i want it to go to a detail page. then query the selected data from the form.

for some reason the detail page is not getting the proper variables.

I've looked at the tutorial, but it's not a dynamic list.

for some reason, once i click on submit the detail page doesn't know how to interpret the variable beeing sent.

/result05.asp?select=BYE+BYE+LOVE&Submit=Submit

it keeps pulling out the first data on the field.


thanks in advance!

hmmm, what have you filled in in the recordset window on your detail page ?
and why are the + signs in the url string ?
do you have + signs in your database or are they spaces in your database ?

does the lower filter part look something like this ?
<img src="www.dmxzone.com/Downloads/Tutorial_ContractTutorial.ZIP/Screengrabs/detailQuery.gif" border=0>

with regards,

Dennis van Galen
Webmaster KPN Telecom Holland
Financial & Information Services

Studio MX / CFMX PRO / SQL 2000 / NT4 AND win2kPRO / IIS5

oh, i just found your other thread.

are you still using this ?

&lt;%
Dim AVC__MMColParam
AVC__MMColParam = "1"
If (Request.QueryString("AVCTITLE" &lt;&gt; "" Then
AVC__MMColParam = Request.QueryString("AVCTITLE"
End If
%&gt;

if so then i found your problem, your page wants a querystring "AVCTITLE" and now the page is receiving a querystring "select".

easy fix and there's two options, you can change the name of your listbox to AVCTITLE or you can change the reference in the code of the detail page.
i think this is your problem because you mentioned record 1 is always returned and this code basically does tell the server value is 1 and replaces 1 if the expected querystring exists.

i would change the name of the list, looks nicer for your visitors <img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle>
oh and do get rid of the submit string by leaving the name of the button element empty.

let me know if that fixes your headache, please.

with regards,

Dennis van Galen
Webmaster KPN Telecom Holland
Financial & Information Services

Studio MX / CFMX PRO / SQL 2000 / NT4 AND win2kPRO / IIS5

thank you!

for a week I've been pondering on this and can't figure it out.

now, select drop down list then to detail page, and it SHOWS UP!

I guess I'll be getting some sleep tonight thanks to you!!!!

thank you, sir!

you're welcome.
next time, don't be afraid to ask, there's always someone around.

with kind regards,

Dennis van Galen
DMXzone.com Manager
Tutorials, FAQ and Extension Manager


weird, 2 signatures...

Edited by - djvgalen on 15 Feb 2003 01:08:39