|
 |
asp_databases thread: Missing Data
Message #1 by wiz2@h... on Sat, 30 Jun 2001 06:32:19
|
|
I have a table with an entry: Location as a text field.
One of the records hold: New Orleans, La.
I can open a recordset and read everything in normaly. If I assign that
field to a variable and display it it shows with no problem. If I assign
it to a text input box I only get: New
I tried replacing the space but that didn't work.
place=oRSp("Location")
<p><font face="Courier New">Birth Place: </font><input
type="text" Value=<%response.write place %> name="Birth_Place"
size="50"> </p>
Message #2 by "Dallas Martin" <dmartin@z...> on Sat, 30 Jun 2001 08:44:20 -0400
|
|
Put the value with-in quotes:
value="<%=response.write place%>"
----- Original Message -----
From: <wiz2@h...>
To: "ASP Databases" <asp_databases@p...>
Sent: Saturday, June 30, 2001 6:32 AM
Subject: [asp_databases] Missing Data
> I have a table with an entry: Location as a text field.
>
> One of the records hold: New Orleans, La.
>
> I can open a recordset and read everything in normaly. If I assign that
> field to a variable and display it it shows with no problem. If I assign
> it to a text input box I only get: New
>
> I tried replacing the space but that didn't work.
>
>
> place=oRSp("Location")
>
> <p><font face="Courier New">Birth Place: </font><input
> type="text" Value=<%response.write place %> name="Birth_Place"
> size="50"> </p>
Message #3 by "Simon Scheurer" <simon.scheurer@u...> on Sat, 30 Jun 2001 14:57:38 +0200
|
|
ASP Sometimes behaves weird when using with textfield, depending on which
cursor type you use. Try the following
code to retrieve the dataset:
set db = server.createobject("ADODB.Connection")
db.open dsn, user, pw
set rs = server.createObject("ADODB.Recordset")
db.open sql, db, 1, 1
place = rs("Location")
Like this it should work without problem
Message #4 by "Randy" <rannyman@s...> on Sat, 30 Jun 2001 07:24:53 -0600
|
|
You need to put quotes around the value
Like:
<input type="text" Value="<%response.write place %>" name="Birth_Place"
size="50">
-----Original Message-----
From: wiz2@h... [mailto:wiz2@h...]
Sent: Saturday, June 30, 2001 6:32 AM
To: ASP Databases
Subject: [asp_databases] Missing Data
I have a table with an entry: Location as a text field.
One of the records hold: New Orleans, La.
I can open a recordset and read everything in normaly. If I assign that
field to a variable and display it it shows with no problem. If I assign
it to a text input box I only get: New
I tried replacing the space but that didn't work.
place=oRSp("Location")
<p><font face="Courier New">Birth Place: </font><input
type="text" Value=<%response.write place %> name="Birth_Place"
size="50"> </p>
|
|
|
View Cart
