I am trying to make a list of names load by the first letter in that name based on the letter clicked.
So far I can load the Data like this
sSQL = "SELECT BandName, Genre, City, State, URL, Factoid, ID FROM Bands Where BandName Like 'A%'"
sSQL = sSQL & " ORDER BY BandName ASC "

This lists all Names starting with A

I want to Make it that the A would be passed in a variable.
Like the link would be something like this.
<a href=http://mydomain.com/alph.asp?vLET=A>A</a>
the variable letter would then be A
vLET=A

This is where I can't figure it out. The way of telling the page to do it.
sSQL = "SELECT BandName, Genre, City, State, URL, Factoid, ID FROM Bands Where BandName Like '&vLET%'"
sSQL = sSQL & " ORDER BY BandName ASC "

I need help with this.
By The Way this is and ASP page on Brinkster.

Jeff Henderson
President-Worship Loud
http://www.worshiploud.com

__________________
Jeff Henderson
President-Worship Loud
http://www.worshiploud.com

sSQL = "SELECT BandName, Genre, City, State, URL, Factoid, ID"
sSQL = sSQL & " FROM Bands Where BandName Like '" & vLET & "%'"
sSQL = sSQL & " ORDER BY BandName ASC "

Use a case statement

Case A
vlet=A
Case B
vlet=B
and so on
Then pass the value of vlet to the query string

John

Hello For of all I don't understand this.
Second I tried this
sSQL = "SELECT BandName, Genre, City, State, URL, Factoid, ID"
sSQL = sSQL & " FROM Bands Where BandName Like '" & vLET & "%'"
sSQL = sSQL & " ORDER BY BandName ASC "

And it displayed all records.
It works fine on my test site but not on the live site it's on Brinkster.


Jeff Henderson
President-Worship Loud
http://www.worshiploud.com

Try LIKE ' & vLet & "*"' as the search criteria

As for the letters to search on try using an option list instead of letters to click on. Set the value of the option list to vLet and pass it to the querystring.

The code to create the option list would be something like this

<SELECT Name="vLet">
<%
Dim intLetter, strChar
For intLetter 1-26
strChar=Chr(intLetter+64)
Response.Write "<OPTION VALUE= " & strChar & ">" & strChar & "</OPTION>
Next
%>
</SELECT>

This will allow a sort of dynamic string to pass to the URL ref

So what's it do on the live site?

Not having more of the code posted, I kind of assumed that you were retrieving the value from the querystring for the letter you want to search on. You can't just implicitly use a variable name that matches a querystring argument name, you have to get it from the querystring collection:

vLET = Request.QueryString("vLET")

sSQL = "SELECT BandName, Genre, City, State, URL, Factoid, ID"
sSQL = sSQL & " FROM Bands Where BandName Like '" & vLET & "%'"
sSQL = sSQL & " ORDER BY BandName ASC "

The reason it returns everything is because if vLET isn't set to anything the query will search on "%" which will match everything.

Peter
------------------------------------------------------
Work smarter, not harder.