display data on the Fly

rodmcleay · June 23rd, 2003, 07:53 PM

Jeff,

I'm glad you got it Jeff, but I don't know how that code could have worked.

I thought you would need to assign the request variable to the variable BID.

Code:

Dim BID
BID = request("BID") 'otherwise BID would be and empty string ""
sSQL = "SELECT Name, Info, Bio, URL FROM Table1 WHERE ID = " & BID

worshiploud · June 24th, 2003, 03:29 PM

You are correct, I left off the Request.Querystring in the posting
here because that I assumeb we all know had to be included.

One More Question
I have two pages

Page One Has a Link
<a href=alph.asp?LET=#039;A#037;#039;>A</a>
which looks like
alph.asp?LET='A&%'
when it is passed through the browser
So LET is defined as 'A%'
Page Two Requests the querystring
DIM LET

LET = Request.QueryString("LET")
sSQL = "SELECT * FROM Bands Where BandName Like " & LET

I just want the page alph.asp to display records that start
with A if I click A on Page One or records that start with
B when I click B on Page One

Is my url written wrong?
Is the Select line wrong?

I did this same think with the BID and it worked fine
Then again I was looking for one record and not a
bunch that start with one letter.

I tested this with
sSQL = "SELECT * FROM Bands Where BandName Like 'A%' "
This worked.
So how do I tell the second page what letter to put 'HERE%'
And allow the second page to accept it?

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

rodmcleay · June 24th, 2003, 07:41 PM

The easiest way is to do string formatting on the second page and just pass the letter in the query string.

Code:

<a href="alph.asp?LET=A">A</a>

'on your second page the string would be built as

sSQL = "SELECT * FROM Bands Where BandName Like '" & LET & "%'"

The problem with the way you were doing it is probably has to do with the way the browser encripts the caracters ',& and %.
You can response.write the SQL string to see what is being produced by your code before it goes to SQL Server.

worshiploud · June 24th, 2003, 11:03 PM

On a normal server setup that would work.
I am on Brinkster. Normal things don't work
on Brinkster.I will keep at it.
The way I figured out the earlier problem
was by adding or removing things.
Like " or ' or %
This is probably the same thing.

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

rodmcleay · June 24th, 2003, 11:16 PM

If

Code:

sSQL = "SELECT * FROM Bands Where BandName Like 'A%' "

works then

Code:

sSQL = "SELECT * FROM Bands Where BandName Like '" & request("LET") & "%' "

Also would work!
This is fundamental ASP Code, I am sure brinkster would support this.

You should try this again.
Remove the special caracters from your tag on the first page so it looks like.

Code:

<a href="alph.asp?LET=A">A</a>

and change your query string to look like this.

Code:

sSQL = "SELECT * FROM Bands Where BandName Like '" & request("LET") & "%' "

worshiploud · June 25th, 2003, 07:03 PM

I think that the issue is Brinkster.
For instance,
<a href="alph.asp?A">A</A>
only works like
<a href=alph.asp?A>A</A>

In addition to that remember earlier in this string where
someone had posted this line
strSQL = "select BIO from BANDS where ID = " & request("BID")
well that line did not work on Brinkster but this did
sSQL = "SELECT Name, Info, Bio, URL FROM Table1 WHERE ID = " & BID

That is why I was thinking maybe the syntax is not
compatable with Brinkster.

Your suggestion did not work. I don't get why.
I understand that it should work, but it does not.

That is why I tried to embed the entire thing in the Link.

I will continue to work on it.

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