error when looping database table

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

error when looping database table

Logged in as: Guest

arrSession:exec spGetSession 2,3,3134

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> ASP >> error when looping database table
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

error when looping database table - 5/26/2005 3:19:47 PM

KiReSt

Posts: 3
Score: 0
Joined: 1/20/2005
From: Norway
Status: offline

hello, i cant figure out whats wrong in this code, im totally clueless.. but do you mind to help me?

..the error is when it check the database
if there exists a 'raceID' equal to the 'race'
from the QueryString. and if it does exist
then 'RaceExists' will be "yes" but in
someway that wont happend even if the 'raceID'
do exists. do you have any clues?

Thanks KiReSt

_____________________________

huh?

Post #: 1

Re: error when looping database table - 5/27/2005 1:14:11 AM

acowboi

Posts: 6
Score: 0
Joined: 5/26/2005
From: Canada
Status: offline

Hi,

Try:
1. Convert race to int...eg race = Cint(request.QueryString("race"))
2. Ensure you intialize RaceExists = "No" before do while statement

Regards,

Andrew

(in reply to KiReSt)

Post #: 2

Re: error when looping database table - 5/28/2005 2:35:02 AM

VBS

Posts: 110
Score: 0
Joined: 3/2/2005
From: Lebanon
Status: offline

Dear KiReSt,
If what acowboi had said didn't work, try doing the following:

Hope this helps

Best Regards
Firas S Assaad

(in reply to KiReSt)

Post #: 3

Re: error when looping database table - 5/29/2005 4:16:42 PM

KiReSt

Posts: 3
Score: 0
Joined: 1/20/2005
From: Norway
Status: offline

quote:
Originally posted by VBS

Dear KiReSt,
If what acowboi had said didn't try doing the following:

if request("race") = rsCommon.fields("RaceID") then RaceExists = "Yes" end if

Hope this helps

Best Regards
Firas S Assaad