asp_web_howto thread: Sessions
Message #1 by "Katawonga Kizzy" <katawonga@y...> on Thu, 22 Mar 2001 14:00:20
|
|
I'm trying to pass session variables to my SQL statements to get data
specific to my user who logged in but failing. It seems the variables
arent passed to the sql and I end up with errors EOF or BOF
Message #2 by "Craig Flannigan" <ckf@k...> on Thu, 22 Mar 2001 14:14:56 -0000
|
|
Let's see your code, and I'll try and help you.
-----Original Message-----
From: Katawonga Kizzy [mailto:katawonga@y...]
Sent: 22 March 2001 02:00 PM
To: ASP Web HowTo
Subject: [asp_web_howto] Sessions
I'm trying to pass session variables to my SQL statements to
get data
specific to my user who logged in but failing. It seems the
variables
arent passed to the sql and I end up with errors EOF or BOF
Message #3 by Scott Watermasysk <swatermasysk@C...> on Thu, 22 Mar 2001 09:15:05 -0500
|
|
What does your code look like?
-----Original Message-----
From: Katawonga Kizzy [mailto:katawonga@y...]
Sent: Thursday, March 22, 2001 9:00 AM
To: ASP Web HowTo
Subject: [asp_web_howto] Sessions
I'm trying to pass session variables to my SQL statements to get data
specific to my user who logged in but failing. It seems the variables
arent passed to the sql and I end up with errors EOF or BOF
Message #4 by "TomMallard" <mallard@s...> on Thu, 22 Mar 2001 13:08:41 -0800
|
|
Test them first...
if not isnull(sVar) and not isempty(sVar) then
...process...
else
...error routine...
end
Also, response.write'ing the sql before you send it during testing helps a
lot...
tom mallard
seattle
----- Original Message -----
From: "Katawonga Kizzy" <katawonga@y...>
To: "ASP Web HowTo" <asp_web_howto@p...>
Sent: Thursday, March 22, 2001 2:00 PM
Subject: [asp_web_howto] Sessions
> I'm trying to pass session variables to my SQL statements to get data
> specific to my user who logged in but failing. It seems the variables
> arent passed to the sql and I end up with errors EOF or BOF
>
|
View Cart
