p2p.wrox.com: Archives - asp

asp_databases thread: Help me - My variables are dissappearing!

Message #1 by "Brian" <gemynd@h...> on Fri, 7 Dec 2001 02:02:27

I'm pulling my hair out here! I have an ASP page with a database 

connection. The connection works great (always has), however, I'm having 

an instance where one of my variables have dissappeared in MID PAGE!



I have copied the text below to illustrate my point.



<P>String1 Length = <%=Len(BB("String1"))%></P>

<P>String2 Length = <%=Len(BB("String2"))%></P>

<DIV align="center"><CENTER><table border="1" width="100%">

<TR><TD valign="top" width="50%"><FONT size="2" 

face="Arial"><B>Lists</B></FONT>

<P>String1 Length = <%=Len(BB("String1"))%></P>

<P>String2 Length = <%=Len(BB("String2"))%></P>



BB is my recordset and String1 & String2 are two strings which are NEVER 

NULL. However, the above lines report the proper length prior to the DIV 

statement. After the DIV statement, somehow, the length of String2 is NULL.



How in the world can this happen? Believe me - there are NO LINES between 

the above example which have been left out.



I do not update anywhere in the code, so how does my database value turn 

NULL?



Please help me, this has been driving me insane!



-Brian

Message #2 by "Ken Schaefer" <ken@a...> on Fri, 7 Dec 2001 14:15:33 +1100

What datatypes are "string1" and "string2"?

What type of recordset are you using (cursor type, locktype, cursor

location)



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: "Brian" <gemynd@h...>

Subject: [asp_databases] Help me - My variables are dissappearing!





: I'm pulling my hair out here! I have an ASP page with a database

: connection. The connection works great (always has), however, I'm having

: an instance where one of my variables have dissappeared in MID PAGE!

:

: I have copied the text below to illustrate my point.

:

: <P>String1 Length = <%=Len(BB("String1"))%></P>

: <P>String2 Length = <%=Len(BB("String2"))%></P>

: <DIV align="center"><CENTER><table border="1" width="100%">

: <TR><TD valign="top" width="50%"><FONT size="2"

: face="Arial"><B>Lists</B></FONT>

: <P>String1 Length = <%=Len(BB("String1"))%></P>

: <P>String2 Length = <%=Len(BB("String2"))%></P>

:

: BB is my recordset and String1 & String2 are two strings which are NEVER

: NULL. However, the above lines report the proper length prior to the DIV

: statement. After the DIV statement, somehow, the length of String2 is

NULL.

:

: How in the world can this happen? Believe me - there are NO LINES between

: the above example which have been left out.

:

: I do not update anywhere in the code, so how does my database value turn

: NULL?

:

: Please help me, this has been driving me insane!



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

.

Message #3 by "Michael Kent Simmons" <msimmons@u...> on Fri, 7 Dec 2001 13:34:41 -0200

Brian:



What kind of cursor does the rs have? Are String1 and String2 fields in the

rs, or sourced otherwise?



Mike

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

----- Original Message -----

From: "Brian" <gemynd@h...>

To: "ASP Databases" <asp_databases@p...>

Sent: Friday, December 07, 2001 2:02 AM

Subject: [asp_databases] Help me - My variables are dissappearing!





> I'm pulling my hair out here! I have an ASP page with a database

> connection. The connection works great (always has), however, I'm having

> an instance where one of my variables have dissappeared in MID PAGE!

>

> I have copied the text below to illustrate my point.

>

> <P>String1 Length = <%=Len(BB("String1"))%></P>

> <P>String2 Length = <%=Len(BB("String2"))%></P>

> <DIV align="center"><CENTER><table border="1" width="100%">

> <TR><TD valign="top" width="50%"><FONT size="2"

> face="Arial"><B>Lists</B></FONT>

> <P>String1 Length = <%=Len(BB("String1"))%></P>

> <P>String2 Length = <%=Len(BB("String2"))%></P>

>

> BB is my recordset and String1 & String2 are two strings which are NEVER

> NULL. However, the above lines report the proper length prior to the DIV

> statement. After the DIV statement, somehow, the length of String2 is

NULL.

>

> How in the world can this happen? Believe me - there are NO LINES between

> the above example which have been left out.

>

> I do not update anywhere in the code, so how does my database value turn

> NULL?

>

> Please help me, this has been driving me insane!

>

> -Brian

>




$subst('Email.Unsub')

>




$subst('Email.Unsub').

>

Message #4 by "Brian" <gemynd@h...> on Fri, 7 Dec 2001 18:08:19

The cursor type is defaulted, and String1 and String2 are both text fields 

(identical except for values), and are both in the recordset.



I found the following article...



http://www.aspfaq.com/plain.asp?id=2188 



...which seems to answer my question though. Thank you.



-Brian



> Brian:

> 

> What kind of cursor does the rs have? Are String1 and String2 fields in 

the

> rs, or sourced otherwise?

> 

> Mike

> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

> ----- Original Message -----

> From: "Brian" <gemynd@h...>

> To: "ASP Databases" <asp_databases@p...>

> Sent: Friday, December 07, 2001 2:02 AM

> Subject: [asp_databases] Help me - My variables are dissappearing!

> 

> 

> > I'm pulling my hair out here! I have an ASP page with a database

> > connection. The connection works great (always has), however, I'm 

having

> > an instance where one of my variables have dissappeared in MID PAGE!

> >

> > I have copied the text below to illustrate my point.

> >

> > <P>String1 Length = <%=Len(BB("String1"))%></P>

> > <P>String2 Length = <%=Len(BB("String2"))%></P>

> > <DIV align="center"><CENTER><table border="1" width="100%">

> > <TR><TD valign="top" width="50%"><FONT size="2"

> > face="Arial"><B>Lists</B></FONT>

> > <P>String1 Length = <%=Len(BB("String1"))%></P>

> > <P>String2 Length = <%=Len(BB("String2"))%></P>

> >

> > BB is my recordset and String1 & String2 are two strings which are 

NEVER

> > NULL. However, the above lines report the proper length prior to the 

DIV

> > statement. After the DIV statement, somehow, the length of String2 is

> NULL.

> >

> > How in the world can this happen? Believe me - there are NO LINES 

between

> > the above example which have been left out.

> >

> > I do not update anywhere in the code, so how does my database value 

turn

> > NULL?

> >

> > Please help me, this has been driving me insane!

> >

> > -Brian

> >




> $subst('Email.Unsub')

> >




> $subst('Email.Unsub').

> >

>

Return to Index

P2P Archives