Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_databases thread: Different ways of retrieving data from a database


Message #1 by "Valentino Osterwalder" <valentino@t...> on Mon, 19 Aug 2002 20:34:35
I have another problem retrieving different kind of fields from a database 
and shwo them in a changeable field on the web page. The data retrieved 
from the text field are well displayed in the "INPUT TYPE=Text". On the 
other line the data should be retrieved from a Memo field and displayed 
as "TEXTAREA", but nothing shows up! The code below is exactly as it is in 
my ASP page. What is wrong?
Thanks for any help!

Valentino
 
<TR>
 <TD WIDTH="35%" VALIGN="top">Piatto preferito:</TD>
 <TD WIDTH="60%" VALIGN="top"><INPUT TYPE="Text" 
NAME="PiattoPreferitoSocio" VALUE="<%=objRSSoci("PiattoPreferito")%>" 
SIZE="35"></TD>
 <TD WIDTH="5%">&nbsp;</TD>
</TR>
<TR>
 <TD WIDTH="35%" VALIGN="top">Altri Sport:</TD>
 <TD WIDTH="60%" VALIGN="top"><TEXTAREA NAME="AltriSportSocio" VALUE="<%
=objRSSoci("AltriSport")%>" ROWS="3" COLS="27" SIZE="35"></TEXTAREA></TD>
 <TD WIDTH="5%">&nbsp;</TD>
</TR>
Message #2 by "Peter Foti (PeterF)" <PeterF@S...> on Mon, 19 Aug 2002 15:37:18 -0400
Change your textarea code to this:

<TEXTAREA NAME="AltriSportSocio" ROWS="3" COLS="27"
SIZE="35"><%=objRSSoci("AltriSport")%></TEXTAREA>



> -----Original Message-----
> From: Valentino Osterwalder [mailto:valentino@t...]
> Sent: Monday, August 19, 2002 8:35 PM
> To: ASP Databases
> Subject: [asp_databases] Different ways of retrieving data from a
> database
> 
> 
> I have another problem retrieving different kind of fields 
> from a database 
> and shwo them in a changeable field on the web page. The data 
> retrieved 
> from the text field are well displayed in the "INPUT 
> TYPE=Text". On the 
> other line the data should be retrieved from a Memo field and 
> displayed 
> as "TEXTAREA", but nothing shows up! The code below is 
> exactly as it is in 
> my ASP page. What is wrong?
> Thanks for any help!
> 
> Valentino
>  
> <TR>
>  <TD WIDTH="35%" VALIGN="top">Piatto preferito:</TD>
>  <TD WIDTH="60%" VALIGN="top"><INPUT TYPE="Text" 
> NAME="PiattoPreferitoSocio" VALUE="<%=objRSSoci("PiattoPreferito")%>" 
> SIZE="35"></TD>
>  <TD WIDTH="5%">&nbsp;</TD>
> </TR>
> <TR>
>  <TD WIDTH="35%" VALIGN="top">Altri Sport:</TD>
>  <TD WIDTH="60%" VALIGN="top"><TEXTAREA 
> NAME="AltriSportSocio" VALUE="<%
> =objRSSoci("AltriSport")%>" ROWS="3" COLS="27" 
> SIZE="35"></TEXTAREA></TD>
>  <TD WIDTH="5%">&nbsp;</TD>
> </TR>
> 
Message #3 by "Roy, Siddarth S" <sroy@b...> on Mon, 19 Aug 2002 15:32:01 -0400
Did u try response.write the database values on the page

well if u are getting the value then putting the value in the different 
variable

hope this helps
sid =09

-----Original Message-----
From: Valentino Osterwalder [mailto:valentino@t...]
Sent: Monday, August 19, 2002 4:35 PM
To: ASP Databases
Subject: [asp_databases] Different ways of retrieving data from a
database


I have another problem retrieving different kind of fields from a 
database
and shwo them in a changeable field on the web page. The data retrieved
from the text field are well displayed in the "INPUT TYPE=3DText". On 
the
other line the data should be retrieved from a Memo field and displayed
as "TEXTAREA", but nothing shows up! The code below is exactly as it is 
in
my ASP page. What is wrong?
Thanks for any help!

Valentino

<TR>
 <TD WIDTH=3D"35%" VALIGN=3D"top">Piatto preferito:</TD>
 <TD WIDTH=3D"60%" VALIGN=3D"top"><INPUT TYPE=3D"Text"
NAME=3D"PiattoPreferitoSocio" 
VALUE=3D"<%=3DobjRSSoci("PiattoPreferito")%>"
SIZE=3D"35"></TD>
 <TD WIDTH=3D"5%">&nbsp;</TD>
</TR>
<TR>
 <TD WIDTH=3D"35%" VALIGN=3D"top">Altri Sport:</TD>
 <TD WIDTH=3D"60%" VALIGN=3D"top"><TEXTAREA NAME=3D"AltriSportSocio" 
VALUE=3D"<%
=3DobjRSSoci("AltriSport")%>" ROWS=3D"3" COLS=3D"27" 
SIZE=3D"35"></TEXTAREA></TD>
 <TD WIDTH=3D"5%">&nbsp;</TD>
</TR>
Message #4 by "Chetan Kelkar" <chetan@c...> on Tue, 20 Aug 2002 08:53:22 +0530
hi

i am sure you must have had problems in retrieving values in the following
code (i mean the textarea)

"><TEXTAREA NAME="AltriSportSocio" VALUE="<%
=objRSSoci("AltriSport")%>" ROWS="3" COLS="27" SIZE="35"></TEXTAREA

even i have had the similar problem and after much of hassles i left it
unsolved !!!

anyone can help ?

chetan
----- Original Message -----
From: "Valentino Osterwalder" <valentino@t...>
To: "ASP Databases" <asp_databases@p...>
Sent: Monday, August 19, 2002 8:34 PM
Subject: [asp_databases] Different ways of retrieving data from a database


> I have another problem retrieving different kind of fields from a database
> and shwo them in a changeable field on the web page. The data retrieved
> from the text field are well displayed in the "INPUT TYPE=Text". On the
> other line the data should be retrieved from a Memo field and displayed
> as "TEXTAREA", but nothing shows up! The code below is exactly as it is in
> my ASP page. What is wrong?
> Thanks for any help!
>
> Valentino
>
> <TR>
>  <TD WIDTH="35%" VALIGN="top">Piatto preferito:</TD>
>  <TD WIDTH="60%" VALIGN="top"><INPUT TYPE="Text"
> NAME="PiattoPreferitoSocio" VALUE="<%=objRSSoci("PiattoPreferito")%>"
> SIZE="35"></TD>
>  <TD WIDTH="5%">&nbsp;</TD>
> </TR>
> <TR>
>  <TD WIDTH="35%" VALIGN="top">Altri Sport:</TD>
>  <TD WIDTH="60%" VALIGN="top"><TEXTAREA NAME="AltriSportSocio" VALUE="<%
> =objRSSoci("AltriSport")%>" ROWS="3" COLS="27" SIZE="35"></TEXTAREA></TD>
>  <TD WIDTH="5%">&nbsp;</TD>
> </TR>
>

Message #5 by "Chetan Kelkar" <chetan@c...> on Tue, 20 Aug 2002 08:59:57 +0530
hi
i tried similarly earlier and even now, doesnt work !!!!

here is what i did

<textarea><%=rs("firstname")%></textarea>

:o(

----- Original Message -----
From: "Peter Foti (PeterF)" <PeterF@S...>
To: "ASP Databases" <asp_databases@p...>
Sent: Tuesday, August 20, 2002 1:07 AM
Subject: [asp_databases] RE: Different ways of retrieving data from a data
base


> Change your textarea code to this:
>
> <TEXTAREA NAME="AltriSportSocio" ROWS="3" COLS="27"
> SIZE="35"><%=objRSSoci("AltriSport")%></TEXTAREA>
>
>
>
> > -----Original Message-----
> > From: Valentino Osterwalder [mailto:valentino@t...]
> > Sent: Monday, August 19, 2002 8:35 PM
> > To: ASP Databases
> > Subject: [asp_databases] Different ways of retrieving data from a
> > database
> >
> >
> > I have another problem retrieving different kind of fields
> > from a database
> > and shwo them in a changeable field on the web page. The data
> > retrieved
> > from the text field are well displayed in the "INPUT
> > TYPE=Text". On the
> > other line the data should be retrieved from a Memo field and
> > displayed
> > as "TEXTAREA", but nothing shows up! The code below is
> > exactly as it is in
> > my ASP page. What is wrong?
> > Thanks for any help!
> >
> > Valentino
> >
> > <TR>
> >  <TD WIDTH="35%" VALIGN="top">Piatto preferito:</TD>
> >  <TD WIDTH="60%" VALIGN="top"><INPUT TYPE="Text"
> > NAME="PiattoPreferitoSocio" VALUE="<%=objRSSoci("PiattoPreferito")%>"
> > SIZE="35"></TD>
> >  <TD WIDTH="5%">&nbsp;</TD>
> > </TR>
> > <TR>
> >  <TD WIDTH="35%" VALIGN="top">Altri Sport:</TD>
> >  <TD WIDTH="60%" VALIGN="top"><TEXTAREA
> > NAME="AltriSportSocio" VALUE="<%
> > =objRSSoci("AltriSport")%>" ROWS="3" COLS="27"
> > SIZE="35"></TEXTAREA></TD>
> >  <TD WIDTH="5%">&nbsp;</TD>
> > </TR>
> >
>
>

Message #6 by arshad siddiqui <ash_arshad@y...> on Tue, 20 Aug 2002 03:42:04 -0700 (PDT)
Hi,
Display values in the text are it is something
different from the <input type=text>
Try out this one:

<TEXTAREA  NAME="AltriSportSocio" ROWS="3" COLS="27" 
SIZE="35"><%=objRSSoci("AltriSport")%></TEXTAREA>

Hope this solves your purpose

Any other problem let me know
Thanx
Regards
--Arshad--




====================================================
--- "Roy, Siddarth S" <sroy@b...> wrote:
> Did u try response.write the database values on the
> page 
> 
> well if u are getting the value then putting the
> value in the different variable 
> 
> hope this helps 
> sid 	
> 
> -----Original Message-----
> From: Valentino Osterwalder
> [mailto:valentino@t...]
> Sent: Monday, August 19, 2002 4:35 PM
> To: ASP Databases
> Subject: [asp_databases] Different ways of
> retrieving data from a
> database
> 
> 
> I have another problem retrieving different kind of
> fields from a database 
> and shwo them in a changeable field on the web page.
> The data retrieved 
> from the text field are well displayed in the "INPUT
> TYPE=Text". On the 
> other line the data should be retrieved from a Memo
> field and displayed 
> as "TEXTAREA", but nothing shows up! The code below
> is exactly as it is in 
> my ASP page. What is wrong?
> Thanks for any help!
> 
> Valentino
>  
> <TR>
>  <TD WIDTH="35%" VALIGN="top">Piatto preferito:</TD>
>  <TD WIDTH="60%" VALIGN="top"><INPUT TYPE="Text" 
> NAME="PiattoPreferitoSocio"
> VALUE="<%=objRSSoci("PiattoPreferito")%>" 
> SIZE="35"></TD>
>  <TD WIDTH="5%">&nbsp;</TD>
> </TR>
> <TR>
>  <TD WIDTH="35%" VALIGN="top">Altri Sport:</TD>
>  <TD WIDTH="60%" VALIGN="top"><TEXTAREA
> NAME="AltriSportSocio" VALUE="<%
> =objRSSoci("AltriSport")%>" ROWS="3" COLS="27"
> SIZE="35"></TEXTAREA></TD>
>  <TD WIDTH="5%">&nbsp;</TD>
> </TR>
> 


__________________________________________________
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com

  Return to Index