access_asp thread: Text boxes and white spaces in data..how to solve?
Message #1 by "Jim Losi" <jlosi1@t...> on Wed, 5 Sep 2001 21:24:23
|
|
ok.. I'm still new to this and catching on fast .. what's the deal with
pulling data to a text box. I have data that has spaces between the words.
i.e. "New York" when I query the DB for it and have it show in text box
all i get is "New". can someone point me in the right direction on how to
get around this?
Thanks
Jim
Message #2 by "sahas lad" <sahas_lad@h...> on Thu, 06 Sep 2001 08:02:40 +0000
|
|
hi
firstly check the field size which u have alloted to the field name in case
of Ms Access database.
then u can run this code and check...
<%
set rs=myconn.execute("adodb.connection")
myconn.open "database name"
%>
<%
myconn.execute("select * from tablename")
xyz=server.urlencode(rs("fieldname"))
response.write(xyz)
%>
I think this can solve ur problem
Try and let me know ............
>From: "Jim Losi" <jlosi1@t...>
>Reply-To: "Access ASP" <access_asp@p...>
>To: "Access ASP" <access_asp@p...>
>Subject: [access_asp] Text boxes and white spaces in data..how to solve?
>Date: Wed, 5 Sep 2001 21:24:23
>
>ok.. I'm still new to this and catching on fast .. what's the deal with
>pulling data to a text box. I have data that has spaces between the words.
>i.e. "New York" when I query the DB for it and have it show in text box
>all i get is "New". can someone point me in the right direction on how to
>get around this?
>Thanks
>Jim
>
Message #3 by "Jim Losi" <jlosi1@t...> on Thu, 6 Sep 2001 08:04:33 -0400
|
|
actually, i had to enclose my statement in apostrophe's like so. Thanks for
your repsonse though =)
"<td width=165 height=25><input type=text name=""State"" value='"&
RS("State")&"' >State</td>"&_
----- Original Message -----
From: "sahas lad" <sahas_lad@h...>
To: "Access ASP" <access_asp@p...>
Sent: Thursday, September 06, 2001 4:02 AM
Subject: [access_asp] Re: Text boxes and white spaces in data..how to solve?
> hi
>
> firstly check the field size which u have alloted to the field name in
case
> of Ms Access database.
> then u can run this code and check...
> <%
> set rs=myconn.execute("adodb.connection")
> myconn.open "database name"
> %>
> <%
> myconn.execute("select * from tablename")
> xyz=server.urlencode(rs("fieldname"))
> response.write(xyz)
> %>
>
> I think this can solve ur problem
> Try and let me know ............
>
>
>
|
View Cart
