Wrox Home  
Search P2P Archive for: Go

  Return to Index  

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&nbsp; &lt;input type=text name=whatever value="
&amp; objRS("fieldname") &gt; </DIV>

<DIV>&nbsp;</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.



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




  Return to Index