asp_web_howto thread: Problems with update procedure
Message #1 by "Jonathan Marshall" <jdmarsh2g@h...> on Thu, 06 Dec 2001 21:34:04 +0000
|
|
<html><div style='background-color:'><DIV>Problem im having is with the input fields
of a form. How can i get information from a database to be entered into a form correctly or from a passed querystring. I get only up
to an space inside the input box. If there is a space it doesn't grab the rest of the information. Also how do I get information
passed into a text area this doesn't even occur when placing the value as <input type=text name=whatever value="
& objRS("fieldname") > </DIV>
<DIV> </DIV>
<DIV>if i remove the spaces from the data it gets entered into the input forms to edit and update the database. But i would
prefer the data to be entered into the form as from the database for from the querystring. if anyone has any insight on this it
would be greatly appreciated. <BR>JDM</DIV></div><br clear=all><hr>Get your FREE download of MSN
Explorer at <a href='http://go.msn.com/bql/hmtag_itl_EN.asp'>http://explorer.msn.com</a><br></html>
Message #2 by "Jason Salas" <jason@k...> on Fri, 7 Dec 2001 20:37:54 +1000
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0038_01C17F5F.0BF04180
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
This way would be a bit easier:
<% Dim name
name =3D objRS("fieldname")
%>
<input type=3D"text" name=3D"whatever" value=3D"<%=3D name %>">
HTH,
Jason
----- Original Message -----
From: Jonathan Marshall
To: ASP Web HowTo
Sent: Friday, December 07, 2001 7:34 AM
Subject: [asp_web_howto] Problems with update procedure
Problem im having is with the input fields of a form. How can i get
information from a database to be entered into a form correctly or from
a passed querystring. I get only up to an space inside the input box. If
there is a space it doesn't grab the rest of the information. Also how
do I get information passed into a text area this doesn't even occur
when placing the value as <input type=3Dtext name=3Dwhatever value=3D"
& objRS("fieldname") >
if i remove the spaces from the data it gets entered into the input
forms to edit and update the database. But i would prefer the data to be
entered into the form as from the database for from the querystring. if
anyone has any insight on this it would be greatly appreciated.
JDM
-------------------------------------------------------------------------
-----
Get your FREE download of MSN Explorer at http://explorer.msn.com
$subst('Email.Unsub').
Message #3 by "Ken Schaefer" <ken@a...> on Fri, 7 Dec 2001 14:29:23 +1100
|
|
You need quotes around your values:
<input type="text" name="txtName" value="<%=objRS("Field")%>">
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Jonathan Marshall" <jdmarsh2g@h...>
Subject: [asp_web_howto] Problems with update procedure
: Problem im having is with the input fields of a form. How can i get
information from a database to be entered into a form correctly or from a
passed querystring. I get only up to an space inside the input box. If there
is a space it doesn't grab the rest of the information. Also how do I get
information passed into a text area this doesn't even occur when placing the
value as <input type=text name=whatever value=" & objRS("fieldname") >
:
: if i remove the spaces from the data it gets entered into the input forms
to edit and update the database. But i would prefer the data to be entered
into the form as from the database for from the querystring. if anyone has
any insight on this it would be greatly appreciated.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|