ASP dummy needs help

[Bluelude1]

I have found this forum very helpful before especially Dave Clark .....and was wondering if someone could help me with this thing... basically i would like to add an option to the ASP database query

The addition is in red below

http://www.boostdriven.com/productlist.asp?cat=8&Manu=Eibach&car=1&code=1D&year=1999

Basically so i can sort by manufacturer when I need to.

Thanks
Dane

[Ribeyed]

hi,
do you mean add an option to a querystring?

if so they what you have done should work.

[Bluelude1]

ya add an option but dont u have to set the database to know what ur talking about when u add that option to the database

Dane

[Ribeyed]

hi,
well you need to post that code

[Bluelude1]

Dave - My question is how I set the code :) someone else did my ASP setup for me

[SWR]Ribeyed - What might that code be titled? like i said im a tru newbie to ASP :D

[sdonato]

i would think an easy fix would be to add and IF.. ELSE.. Then statement to your asp code on your page

you will need to ftp to your site download the page you want to change and use an editor like notepad to modify the code if this sounds like what you want to do let me know.

-sdonato

[Bluelude1]

I attached a sample of the Excel format that was imported into MS SQL below ( the manufacturers section is highlighted in red)

http://www.boostdriven.com/sample.jpg

are you talking about how to build the SQL string that will retrieve the records according to the query string selections?

Ya i believe thats what im trying to do ... basically add another option the query string

Sorry its hard to explain something u dont really know a whole lot about

Thanks
Dane