i need a bit of help getting the ?blah= command working

As in how to read things back from the querystring or how to put things in there?

i wanna know how to read the bit after that and pass it through to the code

php.

no asp cause i don't wanna do php

In ASP you use the Request.QueryString collection to access arguments in the querystring (the bits after the ?)

Say the url was http://www.blah.com/default.asp?Test1=blah&Test2=blah

You could access the value of test1 by doing something along the lines of

SomeVariable = Request.QueryString("Test1")

cool ta i couldn't remember

still having problems can you icq me plz khel

No icq access where I am atm...

s*** s*** s*** s*** s*** s*** s*** s*** s*** s***

ok what i want is
its retail.asp?product=whatver
nmy variable is thingo (great names yes)
i want
select * from thingo to happen
can you help me with that?

What are you using for your db access, ADO?

The general way to do something like that is to get the variable from the querystring, create the sql query in a string, then pass that string to the execute or open method of your recordset. Using ADO and VBScript it would be something like this.

dim SqlQry
dim rs

thingo = Request.QueryString("product")
SqlQry = "SELECT * FROM " & thingo
Set rs = CreateObject("adodb.Recordset")
rs.Open SqlQry, dbConn


dbConn is a reference to a database connection object that you should have already opened previously. If you aren't using ADO that exact syntax wont work, but thats the basic idea behind it :)

its a dsn-less connection no ado

good stuff man i only needed one line outta that code you wrote and it worked
thanks :P

FYI there's some really good ASP help sites out there on the Web. I use ASP 101, ASP Toolbox, The ASP Resource Index and good ole' Microsoft's ASP reference. And if I have questions The FAQTS Knowledge Base is pretty handy too.

Enjoy.

Oops I stuffed up the Microsoft link. It should be http://msdn.microsoft.com/workshop/server/asp/ASPover.asp

yeah i know but this site is a pain in the ass
brinkster