p2p.wrox.com: Archives - asp

asp_databases thread: Help !! simple ASP - Access but I dont know what is wrong..

Message #1 by "Handy" <handymulia@h...> on Mon, 25 Feb 2002 13:47:39

Hi ! I need a help from more advanced ASP programmers...pls help !!



The purpose of this code is to edit customer information, and I tried to 

get the information from database (Access) using : 

<% =record("name") %>

"name" is a field in the database. 

Actually I can get the name, but only the first word !! the second word 

is lost. I'm confused with this..

So lets say the actual data is "jim smith"

but what is displayed is "jim"



So, there's no syntax error or connection error..

This is the code..







<FORM METHOD = "post" ACTION = "editprocess.asp" name="formAdd"> 

   <TABLE width=100%>

     <TR> 

      <TH width="156">

      <p align="left"><span style="font-weight: 400">

      <font face="Arial Narrow" size="4">Name </font></span></TH> 

      <TD width="500">

      <INPUT TYPE = "text" NAME = "name" value = <% =record("name") %>

         SIZE = maxlength>

      </TD>

   </TR>

   .

   .

   .



anybody know how to solve it?



Thanks alot!

Message #2 by Sam Clohesy <sam@e...> on Mon, 25 Feb 2002 13:43:50 -0000

Try to avoid using Name it is a reserved word. Try calling the dbase field

'FullName' or somthing then try again





-----Original Message-----

From: Handy [mailto:handymulia@h...]

Sent: 25 February 2002 13:48

To: ASP Databases

Subject: [asp_databases] Help !! simple ASP - Access but I dont know

what is wrong..





Hi ! I need a help from more advanced ASP programmers...pls help !!



The purpose of this code is to edit customer information, and I tried to 

get the information from database (Access) using : 

<% =record("name") %>

"name" is a field in the database. 

Actually I can get the name, but only the first word !! the second word 

is lost. I'm confused with this..

So lets say the actual data is "jim smith"

but what is displayed is "jim"



So, there's no syntax error or connection error..

This is the code..







<FORM METHOD = "post" ACTION = "editprocess.asp" name="formAdd"> 

   <TABLE width=100%>

     <TR> 

      <TH width="156">

      <p align="left"><span style="font-weight: 400">

      <font face="Arial Narrow" size="4">Name </font></span></TH> 

      <TD width="500">

      <INPUT TYPE = "text" NAME = "name" value = <% =record("name") %>

         SIZE = maxlength>

      </TD>

   </TR>

   .

   .

   .



anybody know how to solve it?



Thanks alot!








$subst('Email.Unsub').

Message #3 by Colin.Montgomery@C... on Mon, 25 Feb 2002 13:52:24 -0000

I think it may be the MAXLENGTH attribute of the INPUT tag which is causing

u probs (along with Sam's suggestion). 



I'm unsure why you've got:

SIZE=maxlength in the INPUT tag - try this:



<INPUT TYPE ="text" NAME ="name" value =<%=record("name")%> SIZE="30"

MAXLENGTH="30">



HTH,

Col



-----Original Message-----

From: Handy [mailto:handymulia@h...]

Sent: 25 February 2002 13:48

To: ASP Databases

Subject: [asp_databases] Help !! simple ASP - Access but I dont know

what is wrong..





Hi ! I need a help from more advanced ASP programmers...pls help !!



The purpose of this code is to edit customer information, and I tried to 

get the information from database (Access) using : 

<% =record("name") %>

"name" is a field in the database. 

Actually I can get the name, but only the first word !! the second word 

is lost. I'm confused with this..

So lets say the actual data is "jim smith"

but what is displayed is "jim"



So, there's no syntax error or connection error..

This is the code..







<FORM METHOD = "post" ACTION = "editprocess.asp" name="formAdd"> 

   <TABLE width=100%>

     <TR> 

      <TH width="156">

      <p align="left"><span style="font-weight: 400">

      <font face="Arial Narrow" size="4">Name </font></span></TH> 

      <TD width="500">

      <INPUT TYPE = "text" NAME = "name" value = <% =record("name") %>

         SIZE = maxlength>

      </TD>

   </TR>

   .

   .

   .



anybody know how to solve it?



Thanks alot!








$subst('Email.Unsub').





*******



This message and any attachment are confidential and may be privileged or otherwise protected from disclosure.  If you are not the
intended recipient, please telephone or email the sender and delete this message and any attachment from your system.  If you are
not the intended recipient you must not copy this message or attachment or disclose the contents to any other person.



For further information about Clifford Chance please see our website at http://www.cliffordchance.com or refer to any Clifford
Chance office.

Message #4 by ReddySri@c... on Mon, 25 Feb 2002 08:20:04 -0600

Include <% =record("name") %> in the double quotes.

eg : value = "<% =record("name") %>"



HTH.



-----Original Message-----

From: Handy [mailto:handymulia@h...]

Sent: Monday, February 25, 2002 8:48 AM

To: ASP Databases

Subject: [asp_databases] Help !! simple ASP - Access but I dont know

what is wrong..





Hi ! I need a help from more advanced ASP programmers...pls help !!



The purpose of this code is to edit customer information, and I tried to 

get the information from database (Access) using : 

<% =record("name") %>

"name" is a field in the database. 

Actually I can get the name, but only the first word !! the second word 

is lost. I'm confused with this..

So lets say the actual data is "jim smith"

but what is displayed is "jim"



So, there's no syntax error or connection error..

This is the code..







<FORM METHOD = "post" ACTION = "editprocess.asp" name="formAdd"> 

   <TABLE width=100%>

     <TR> 

      <TH width="156">

      <p align="left"><span style="font-weight: 400">

      <font face="Arial Narrow" size="4">Name </font></span></TH> 

      <TD width="500">

      <INPUT TYPE = "text" NAME = "name" value = <% =record("name") %>

         SIZE = maxlength>

      </TD>

   </TR>

   .

   .

   .



anybody know how to solve it?



Thanks alot!








$subst('Email.Unsub').

Message #5 by imran.saleem@b... on Mon, 25 Feb 2002 14:38:50 -0000

enclose '' around the field name



-----Original Message-----

From: ReddySri@c... [mailto:ReddySri@c...]

Sent: Monday, February 25, 2002 2:20 PM

To: ASP Databases

Subject: [asp_databases] RE: Help !! simple ASP - Access but I dont know

what is wrong..





Include <% =record("name") %> in the double quotes.

eg : value = "<% =record("name") %>"



HTH.



-----Original Message-----

From: Handy [mailto:handymulia@h...]

Sent: Monday, February 25, 2002 8:48 AM

To: ASP Databases

Subject: [asp_databases] Help !! simple ASP - Access but I dont know

what is wrong..





Hi ! I need a help from more advanced ASP programmers...pls help !!



The purpose of this code is to edit customer information, and I tried to 

get the information from database (Access) using : 

<% =record("name") %>

"name" is a field in the database. 

Actually I can get the name, but only the first word !! the second word 

is lost. I'm confused with this..

So lets say the actual data is "jim smith"

but what is displayed is "jim"



So, there's no syntax error or connection error..

This is the code..







<FORM METHOD = "post" ACTION = "editprocess.asp" name="formAdd"> 

   <TABLE width=100%>

     <TR> 

      <TH width="156">

      <p align="left"><span style="font-weight: 400">

      <font face="Arial Narrow" size="4">Name </font></span></TH> 

      <TD width="500">

      <INPUT TYPE = "text" NAME = "name" value = <% =record("name") %>

         SIZE = maxlength>

      </TD>

   </TR>

   .

   .

   .



anybody know how to solve it?



Thanks alot!








$subst('Email.Unsub').






$subst('Email.Unsub').

Message #6 by "Handy" <handymulia@h...> on Tue, 26 Feb 2002 04:40:27

Hey ReddySri !!!



Thanks alot man !! it's now solved !

yeah ASP requires these kinds of little things to be spotted...



Thank you too for all who had answered my question !!

Return to Index

P2P Archives