Data retrieve problem. 1

[webgs]

When I call up a record to edit, one of the fields, in this case "Media Contact" which is made up of a first and last name, returns only the first name. I know! It's bad DB design to combine the fields but the client wanted a single field to fill in and they are paying the bill. I have deduced that it returns everything before the space that sperates the first and last names. The code I use to retrieve the data is:

<input type=&quot;text&quot; name=&quot;Media_Contact&quot; value=<%=rec(&quot;Media_Contact&quot%>>

The data type I have set in my SQL DB is &quot;text&quot; with a lenght of &quot;16&quot;. I've also tried setting the data type to &quot;varchar&quot; and &quot;char&quot; with no luck. I'm not an SQL or ASP guru and I appreciate any help I can get from you experts!!

 

[ehsant]

Hi ...
It's very easy ...
your code was this :
<input type=&quot;text&quot; name=&quot;Media_Contact&quot; value=<%=rec(&quot;Media_Contact&quot%>>
and you have to try this :
<input type=&quot;text&quot; name=&quot;Media_Contact&quot; value=&quot;<%=rec(&quot;Media_Contact&quot%>&quot;>
----
TNX.
E.T.

 

[webgs]

So easy that it's stupid!! I often get railroded by the dreaded quotes!! Thank you very much!