Problem with the empty space into Session variables

[Yury]

Hi,

I have a web page that displays records from tables in a database. It
is designed to store field's value into Session variables before it
displays into a text box. This record can be edited and/or deleted.
The problem arises when one of the fields contains spaces between the
letters. When it stores into the database, after editing, the space
stores as a some unrecognizable format. These characters can only be
seen
using web interface on my main computer as question marks. The only
way to see them from any other computer would be to use non-web
application. Why do I get
those question marks?

Any suggestions would be greatly appreciated.

Thanks in advance
Yury.

[Atrax]

not quite seeing what you mean here - got any more info?






________________________________________
Atrax. MVP, IIS
[url]http://rtfm.atrax.co.uk/[/url]

newsflash : Atrax.Richedit 1.0 now released.
[url]http://rtfm.atrax.co.uk/infinitemonkeys/components/Atrax.RichEdit/[/url]

*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[Yury]

The problem is that during passing a value that contain an empty space
from the database through session variable to text box and then
execute update record command; there is no empty space anymore.

On Fri, 18 Jul 2003 01:07:41 -0700, Atrax <atrax@dontspamatrax.co.uk>
wrote:

>not quite seeing what you mean here - got any more info?
>
>
>
>
>
>
>________________________________________
>Atrax. MVP, IIS
>[url]http://rtfm.atrax.co.uk/[/url]
>
>newsflash : Atrax.Richedit 1.0 now released.
>[url]http://rtfm.atrax.co.uk/infinitemonkeys/components/Atrax.RichEdit/[/url]
>
>*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
>Don't just participate in USENET...get rewarded for it!

[Bob Barrows]

Instead of explaining, SHOW us what happens.

Bob
Yury wrote:

> The problem is that during passing a value that contain an empty space
> from the database through session variable to text box and then
> execute update record command; there is no empty space anymore.
>
> On Fri, 18 Jul 2003 01:07:41 -0700, Atrax <atrax@dontspamatrax.co.uk>
> wrote:
>

>> not quite seeing what you mean here - got any more info?
>>
>>
>>
>>
>>
>>
>> ________________________________________
>> Atrax. MVP, IIS
>> [url]http://rtfm.atrax.co.uk/[/url]
>>
>> newsflash : Atrax.Richedit 1.0 now released.
>> [url]http://rtfm.atrax.co.uk/infinitemonkeys/components/Atrax.RichEdit/[/url]
>>
>> *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
>> Don't just participate in USENET...get rewarded for it!

[Yury]

To run this app I use .ASP page and .INC
Here is a shortened version of the call flow

rsMY.Open stSQL,Connect, adOpenDynamic, adLockOptimistic

Session("TANKNBR") =rsMY("SOMENBR")
Session("TANKDESC")=rsMY("SOMEDESC")

<table>
<tr><th align=left><INPUT name=SOMENBR
value=<%=Session("SOMENBR")%>></th>
<th align=left><INPUT name=SOMEDESC
value=<%=Session("SOMEDESC")%>></th>
</tr>
</table>

FOR UPDATES I use
qSQL = "INSERT INTO Inventory (SOMENBR,SOMEDESC) " & _
"VALUES('" & trim(Request.Form("SOMENBR")) & "','" & _
trim(Request.Form("SOMEDESC")) & "')"
TO ADD I use
qSQL = "INSERT INTO Inventory (SOMENBR,SOMEDESC) " & _
"VALUES('" & trim(Request.Form("SOMENBR")) & "','" & _
trim(Request.Form("SOMEDESC")) & "')"

Connect.Execute stSQL

If I use ADD statement it can place empty space, but if I use
Update statement the problem happened.
It does not matter which field I modified. If there were empty space
into SOMEDESC field there will be no empty space anymore. Besides
if I modify SOMEDESC so I add another empty space new empty space will
store but old one will not.

I hope it will help you to understand the problem and help me with
this.
Thank you for your respond.
Yury.



On Fri, 18 Jul 2003 08:34:00 -0400, "Bob Barrows"
<reb_01501@yahoo.com> wrote:

>Instead of explaining, SHOW us what happens.
>
>Bob
>Yury wrote:

>> The problem is that during passing a value that contain an empty space
>> from the database through session variable to text box and then
>> execute update record command; there is no empty space anymore.
>>
>> On Fri, 18 Jul 2003 01:07:41 -0700, Atrax <atrax@dontspamatrax.co.uk>
>> wrote:
>>

>>> not quite seeing what you mean here - got any more info?
>>>
>>>
>>>
>>>
>>>
>>>
>>> ________________________________________
>>> Atrax. MVP, IIS
>>> [url]http://rtfm.atrax.co.uk/[/url]
>>>
>>> newsflash : Atrax.Richedit 1.0 now released.
>>> [url]http://rtfm.atrax.co.uk/infinitemonkeys/components/Atrax.RichEdit/[/url]
>>>
>>> *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
>>> Don't just participate in USENET...get rewarded for it!

>
>

[Bob Barrows]

You misunderstood. It's good that you show us the code. However, you still
haven't shown us what happens that's not supposed to happen! You're
explanation about "empty space" may be perfectly clear to you, but it's
going right over my head. Show us what you are talking about instead of
trying to describe it. In other words, show us what you mean by "empty
space". It sounds as if there is some text involved. Show us an example of
the text, and then show us what happens to the text.

Bob Barrows
PS. As I look briefly at your code, I have to wonder why you are using
session variables. They certainly do not seem to be needed for the tasks you
have shown us.

Yury wrote:

> To run this app I use .ASP page and .INC
> Here is a shortened version of the call flow
>
> rsMY.Open stSQL,Connect, adOpenDynamic, adLockOptimistic
>
> Session("TANKNBR") =rsMY("SOMENBR")
> Session("TANKDESC")=rsMY("SOMEDESC")
>
> <table>
> <tr><th align=left><INPUT name=SOMENBR
> value=<%=Session("SOMENBR")%>></th>
> <th align=left><INPUT name=SOMEDESC
> value=<%=Session("SOMEDESC")%>></th>
> </tr>
> </table>
>
> FOR UPDATES I use
> qSQL = "INSERT INTO Inventory (SOMENBR,SOMEDESC) " & _
> "VALUES('" & trim(Request.Form("SOMENBR")) & "','" & _
> trim(Request.Form("SOMEDESC")) & "')"
> TO ADD I use
> qSQL = "INSERT INTO Inventory (SOMENBR,SOMEDESC) " & _
> "VALUES('" & trim(Request.Form("SOMENBR")) & "','" & _
> trim(Request.Form("SOMEDESC")) & "')"
>
> Connect.Execute stSQL
>
> If I use ADD statement it can place empty space, but if I use
> Update statement the problem happened.
> It does not matter which field I modified. If there were empty space
> into SOMEDESC field there will be no empty space anymore. Besides
> if I modify SOMEDESC so I add another empty space new empty space will
> store but old one will not.
>
> I hope it will help you to understand the problem and help me with
> this.
> Thank you for your respond.
> Yury.
>
>
>
> On Fri, 18 Jul 2003 08:34:00 -0400, "Bob Barrows"
> <reb_01501@yahoo.com> wrote:
>

>> Instead of explaining, SHOW us what happens.
>>
>> Bob
>> Yury wrote:

>>> The problem is that during passing a value that contain an empty
>>> space from the database through session variable to text box and
>>> then execute update record command; there is no empty space anymore.
>>>
>>> On Fri, 18 Jul 2003 01:07:41 -0700, Atrax
>>> <atrax@dontspamatrax.co.uk> wrote:
>>>
>>>> not quite seeing what you mean here - got any more info?
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> ________________________________________
>>>> Atrax. MVP, IIS
>>>> [url]http://rtfm.atrax.co.uk/[/url]
>>>>
>>>> newsflash : Atrax.Richedit 1.0 now released.
>>>> [url]http://rtfm.atrax.co.uk/infinitemonkeys/components/Atrax.RichEdit/[/url]
>>>>
>>>> *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
>>>> Don't just participate in USENET...get rewarded for it!

[Mark Schupp]

the input tab value attribute will truncate the data at the first blank if
you do not enclose the data in quotes.

value=<%=Session("SOMEDESC")%>

s/b

value="<%=Server.HTMLEncode(Session("SOMEDESC"))%> ">

--
Mark Schupp
--
Head of Development
Integrity eLearning
Online Learning Solutions Provider
[email]mschupp@ielearning.com[/email]
[url]http://www.ielearning.com[/url]
714.637.9480 x17


"Yury" <y_luchko@hotmail.com> wrote in message
news:3f18264a.22690367@nntp...

> To run this app I use .ASP page and .INC
> Here is a shortened version of the call flow
>
> rsMY.Open stSQL,Connect, adOpenDynamic, adLockOptimistic
>
> Session("TANKNBR") =rsMY("SOMENBR")
> Session("TANKDESC")=rsMY("SOMEDESC")
>
> <table>
> <tr><th align=left><INPUT name=SOMENBR
> value=<%=Session("SOMENBR")%>></th>
> <th align=left><INPUT name=SOMEDESC
> value=<%=Session("SOMEDESC")%>></th>
> </tr>
> </table>
>
> FOR UPDATES I use
> qSQL = "INSERT INTO Inventory (SOMENBR,SOMEDESC) " & _
> "VALUES('" & trim(Request.Form("SOMENBR")) & "','" & _
> trim(Request.Form("SOMEDESC")) & "')"
> TO ADD I use
> qSQL = "INSERT INTO Inventory (SOMENBR,SOMEDESC) " & _
> "VALUES('" & trim(Request.Form("SOMENBR")) & "','" & _
> trim(Request.Form("SOMEDESC")) & "')"
>
> Connect.Execute stSQL
>
> If I use ADD statement it can place empty space, but if I use
> Update statement the problem happened.
> It does not matter which field I modified. If there were empty space
> into SOMEDESC field there will be no empty space anymore. Besides
> if I modify SOMEDESC so I add another empty space new empty space will
> store but old one will not.
>
> I hope it will help you to understand the problem and help me with
> this.
> Thank you for your respond.
> Yury.
>
>
>
> On Fri, 18 Jul 2003 08:34:00 -0400, "Bob Barrows"
> <reb_01501@yahoo.com> wrote:
>

> >Instead of explaining, SHOW us what happens.
> >
> >Bob
> >Yury wrote:

> >> The problem is that during passing a value that contain an empty space
> >> from the database through session variable to text box and then
> >> execute update record command; there is no empty space anymore.
> >>
> >> On Fri, 18 Jul 2003 01:07:41 -0700, Atrax <atrax@dontspamatrax.co.uk>
> >> wrote:
> >>
> >>> not quite seeing what you mean here - got any more info?
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>> ________________________________________
> >>> Atrax. MVP, IIS
> >>> [url]http://rtfm.atrax.co.uk/[/url]
> >>>
> >>> newsflash : Atrax.Richedit 1.0 now released.
> >>> [url]http://rtfm.atrax.co.uk/infinitemonkeys/components/Atrax.RichEdit/[/url]
> >>>
> >>> *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
> >>> Don't just participate in USENET...get rewarded for it!

> >
> >

>

[Yury]

Thank you for your help. The problem was solved by placing
Session variables in quotes.

Yury.

On Fri, 18 Jul 2003 11:16:19 -0700, "Mark Schupp"
<mschupp@ielearning.com> wrote:

>the input tab value attribute will truncate the data at the first blank if
>you do not enclose the data in quotes.
>
>value=<%=Session("SOMEDESC")%>
>
>s/b
>
>value="<%=Server.HTMLEncode(Session("SOMEDESC"))% >">
>
>--
>Mark Schupp
>--
>Head of Development
>Integrity eLearning
>Online Learning Solutions Provider
>mschupp@ielearning.com
>[url]http://www.ielearning.com[/url]
>714.637.9480 x17
>
>
>"Yury" <y_luchko@hotmail.com> wrote in message
>news:3f18264a.22690367@nntp...

>> To run this app I use .ASP page and .INC
>> Here is a shortened version of the call flow
>>
>> rsMY.Open stSQL,Connect, adOpenDynamic, adLockOptimistic
>>
>> Session("TANKNBR") =rsMY("SOMENBR")
>> Session("TANKDESC")=rsMY("SOMEDESC")
>>
>> <table>
>> <tr><th align=left><INPUT name=SOMENBR
>> value=<%=Session("SOMENBR")%>></th>
>> <th align=left><INPUT name=SOMEDESC
>> value=<%=Session("SOMEDESC")%>></th>
>> </tr>
>> </table>
>>
>> FOR UPDATES I use
>> qSQL = "INSERT INTO Inventory (SOMENBR,SOMEDESC) " & _
>> "VALUES('" & trim(Request.Form("SOMENBR")) & "','" & _
>> trim(Request.Form("SOMEDESC")) & "')"
>> TO ADD I use
>> qSQL = "INSERT INTO Inventory (SOMENBR,SOMEDESC) " & _
>> "VALUES('" & trim(Request.Form("SOMENBR")) & "','" & _
>> trim(Request.Form("SOMEDESC")) & "')"
>>
>> Connect.Execute stSQL
>>
>> If I use ADD statement it can place empty space, but if I use
>> Update statement the problem happened.
>> It does not matter which field I modified. If there were empty space
>> into SOMEDESC field there will be no empty space anymore. Besides
>> if I modify SOMEDESC so I add another empty space new empty space will
>> store but old one will not.
>>
>> I hope it will help you to understand the problem and help me with
>> this.
>> Thank you for your respond.
>> Yury.
>>
>>
>>
>> On Fri, 18 Jul 2003 08:34:00 -0400, "Bob Barrows"
>> <reb_01501@yahoo.com> wrote:
>>

>> >Instead of explaining, SHOW us what happens.
>> >
>> >Bob
>> >Yury wrote:
>> >> The problem is that during passing a value that contain an empty space
>> >> from the database through session variable to text box and then
>> >> execute update record command; there is no empty space anymore.
>> >>
>> >> On Fri, 18 Jul 2003 01:07:41 -0700, Atrax <atrax@dontspamatrax.co.uk>
>> >> wrote:
>> >>
>> >>> not quite seeing what you mean here - got any more info?
>> >>>
>> >>>
>> >>>
>> >>>
>> >>>
>> >>>
>> >>> ________________________________________
>> >>> Atrax. MVP, IIS
>> >>> [url]http://rtfm.atrax.co.uk/[/url]
>> >>>
>> >>> newsflash : Atrax.Richedit 1.0 now released.
>> >>> [url]http://rtfm.atrax.co.uk/infinitemonkeys/components/Atrax.RichEdit/[/url]
>> >>>
>> >>> *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
>> >>> Don't just participate in USENET...get rewarded for it!
>> >
>> >

>>

>
>