Sending variable to top of page?

MagSafe · 2 Apr 2007 at 09:35

Hi there,

After searching/looping through a database and bringing back x amount of results, i'd like the x variable to appear at the top of the page after it has finished searching ... is this possible?

Cheers,

Steven.

Augmented · 2 Apr 2007 at 09:48

Using which language?

MagSafe · 2 Apr 2007 at 13:16

ASP / VBScript

GravyMonster · 2 Apr 2007 at 13:26

all you need to do is run your query at the top of the page, and then loop around the resulting recordset afterward. a bit of psuedocode...

SQL = "SELECT * FROM Wherever WHERE Whatever LIKE '%Something%'"
create RS from SQL
x = RS.Recordcount

<html>Your search returned X results...

RS.loop
display results
RS.close

</html>

Hope this helps

roboffer · 2 Apr 2007 at 13:33

If I remember correctly, its a little awkward to get the recordcount from a results set, you need to specify certina options in the record set when you open it

MagSafe · 2 Apr 2007 at 13:46

Spunkey said:
all you need to do is run your query at the top of the page, and then loop around the resulting recordset afterward. a bit of psuedocode...

SQL = "SELECT * FROM Wherever WHERE Whatever LIKE '%Something%'"
create RS from SQL
x = RS.Recordcount

<html>Your search returned X results...

RS.loop
display results
RS.close

</html>

Hope this helps

yeah, but i'm doing a few if statements within a couple of loops as well, and i need the variable that appears at the bottom of the page to somehow appear at the top :confused:

cheers for the comments so far

Conrad11 · 2 Apr 2007 at 13:57

I may be missing the point, but surely you would just construct the html first and then output it.

EDIT:

Do sql statement that counts the number of returned records?