ASP querystring database query

[pritsey]

Hi all,

After some help please with asp pages and query string. I have an access db on my server which I want to be able to query using an A-Z list at top of a page. This is where you click on A (for example) and then the asp page will query the database using 'A' as the driver (eg WHERE field LIKE 'A%' etc)...

Instead of creating 26 different pages with a slightly different query in each, I'd like to pass a variable from the initial page to a single search asp page and the query takes the variable from the querystring - hope this is making sense!!!

Basically, I know what I want to do, but not quite sure how to accomplish it.

My code looks like the below at present:

<%
accessdb=server.mappath("\private\Courses.mdb")
mySQL="SELECT Courses.Company, Courses.[Address 1] FROM Courses WHERE Company LIKE 'A%'"

strconn="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE="
strconn=strconn & accessDB & ";"
'strconn=strconn & "USER ID=;PASSWORD=;"

call query2table(mySQL,strconn)
%>

Many thanks in advance!

[yamangman]

So basically you want to know how to pass a variable between pages? Really this is the first thing you should have learned how to do before starting on database processing (and understood the difference between get and post).

What you want is to pass the clicked letter to your search page, and from there execute your sql query, substituting the correct letter in your query string.

(Please bear in mind there are different ways of acheiving this, this isn't meant to be thourough as there is a horde of information on the net).

Inside your master page:

<a href="details.asp?letter=a">A</a>
<a href="details.asp?letter=b">B</a>
<a href="details.asp?letter=c">C</a>
'etc etc....

Inside your details page:

Dim sqlLetter

sqlLetter = CStr(Request("letter"))

'Now use your SQL code and replace the letter constant with the above sqlLetter variable

All from memory, so if it don't work....

[pritsey]

Thanks yamangman,

Code I ended up using was ("course" is variable passed from prev page):

mySQL="SELECT Courses.Company, Courses.[Address 1] FROM Courses WHERE Company LIKE '" & Request.QueryString("course") & "%'"