Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access_asp thread: reteriving data from access to asp form


Message #1 by "Rinku Kadakia" <rinku.kadakia@p...> on Wed, 4 Dec 2002 21:16:29
Hello, Can some one please help.

I am trying to reterive data from an access database and store the value 
in text box.
<input type="text" name="txtusecasenum" size="20" value=<%=objRS
("usecasename")%>>

usecasename = "Name is ADI" <== following data is stored in database field.

When i reterive this data all i can see is "Name".

=ANOTHER PROBLEM
Also data does not show at all if the form has textarea.

Thanks for your help.

Rinku
Message #2 by "Leon Tunctson" <Leon.Tunctson@d...> on Wed, 04 Dec 2002 17:09:04 -0500
Try displaying the field to verify that the data is coming into the ASP pag
e correctly. Insert this line in your ASP page then run the page

e.g. response.write objRS("usecasename")

If your data is correct, then check the field HTML width on the page.



>>> rinku.kadakia@p... 12/04/02 09:16PM >>>
Hello, Can some one please help.

I am trying to reterive data from an access database and store the value
in text box.
<input type=3D"text" name=3D"txtusecasenum" size=3D"20" value=3D<%=3DobjRS
("usecasename")%>>

usecasename =3D "Name is ADI" <=3D=3D following data is stored in database 
field.

When i reterive this data all i can see is "Name".

=3DANOTHER PROBLEM=3D
Also data does not show at all if the form has textarea.

Thanks for your help.

Rinku


************************************************************
Scanned by net.work.Maryland Antivirus Service...
the Backbone of eMaryland, the Digital State.
************************************************************

Message #3 by Paul Bucknell <paul@d...> on Thu, 05 Dec 2002 19:52:49 +0000
This happened to me using Netscape as the browser. Make sure you put quotes 
around the value
i.e. value="<%=objRS("usecasename")%>">

Paul

At 17:09 04/12/02 -0500, you wrote:
>Try displaying the field to verify that the data is coming into the ASP 
>page correctly. Insert this line in your ASP page then run the page
>
>e.g. response.write objRS("usecasename")
>
>If your data is correct, then check the field HTML width on the page.
>
>
>
> >>> rinku.kadakia@p... 12/04/02 09:16PM >>>
>Hello, Can some one please help.
>
>I am trying to reterive data from an access database and store the value
>in text box.
><input type="text" name="txtusecasenum" size="20" value=<%=objRS
>("usecasename")%>>
>
>usecasename = "Name is ADI" <== following data is stored in database field.
>
>When i reterive this data all i can see is "Name".
>
>=ANOTHER PROBLEM
>Also data does not show at all if the form has textarea.
>
>Thanks for your help.
>
>Rinku
>
>
>************************************************************
>Scanned by net.work.Maryland Antivirus Service...
>the Backbone of eMaryland, the Digital State.
>************************************************************
>
>

Message #4 by "Rinku Kadakia" <rinku.kadakia@p...> on Fri, 6 Dec 2002 18:13:21
Thanks for your help as it works now.
Rinku
---------------------------------------------------
> Hello, Can some one please help.

> I am trying to reterive data from an access database and store the value 
i> n text box.
<> input type="text" name="txtusecasenum" size="20" value=<%=objRS
(> "usecasename")%>>

> usecasename = "Name is ADI" <== following data is stored in database 
field.

> When i reterive this data all i can see is "Name".

> =ANOTHER PROBLEM
A> lso data does not show at all if the form has textarea.

> Thanks for your help.

> Rinku

  Return to Index