SP doesn't return SessionID

Dev Articles Community Forums Sponsor:

SlickEdit: Code in over 40 languages across 7 platforms. SlickEdit’s unmatched power, speed, and flexibility allows even the most accomplished developers to write better code faster. Download a free trial today!

June 19th, 2003, 09:32 AM

LenM22z

Junior Member

Join Date: Jun 2003

Posts: 2

Time spent in forums: < 1 sec
Reputation Power: 0

SP doesn't return SessionID

I set this all up and tried logging in.
If the login is incorrect I get -1 back from the checkLogin sp as expected, but if its correct I get an error on this line of 'login.asp':

sSessionID = oRs.Fields(0).Value

Error: Object can't be found in collection requested by name or ordinal.

I ran the checkLogin sp in the query analyzer and it works right.

What do you think?

Also I was wondering why you run the LCase() function on the user id before passing it to the sp?

Thanks
Len

June 19th, 2003, 07:49 PM

stumpy

May contain nuts.

Dev Articles Regular (2000 - 2499 posts)

Join Date: Aug 2002

Location: Sydney, AU

Posts: 2,058

Time spent in forums: 5 h 6 m 11 sec
Reputation Power: 8

You need to click on the link @ the end of the article, so we know what you are talking about!

or just post the link in your next post

__________________
DevArticles Moderator
BlueSix - Web Development and Consulting

June 19th, 2003, 10:33 PM

nicat23

Addicted to Chaos..

Join Date: Jan 2003

Location: Ft. Worth, TX

Posts: 653

Time spent in forums: 1 h 47 m 52 sec
Reputation Power: 0

Re: SP doesn't return SessionID

Quote:

Originally posted by LenM22z
I set this all up and tried logging in.
If the login is incorrect I get -1 back from the checkLogin sp as expected, but if its correct I get an error on this line of 'login.asp':

sSessionID = oRs.Fields(0).Value

Error: Object can't be found in collection requested by name or ordinal.

I ran the checkLogin sp in the query analyzer and it works right.

What do you think?

Also I was wondering why you run the LCase() function on the user id before passing it to the sp?

Thanks
Len

Well I can answer the part about the LCase() function... you run this so that it doesn't matter what the user typed in, it will always be lowercase, it eliminates the problem of case sensitivity.. it also limits the userid to be only assigned to one person..

ie:

Nicat23 couldn't also be nicat23 (notice the difference in the cases?) if you dont use the lcase() function it can allow duplicate instances depending on how you do your coding..

Hope that helps...

June 19th, 2003, 10:47 PM