I've found the problem as to why text fields were only displaying the
first word. I didn't include the single quote after the value = and
before the >.
<%= "<input name='specialty' type='text' size='20' maxlength='50' value
= " & objRS("Specialty") & ">" %>
Dumb, dumb dumb...
Randy
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of
Randy Schirmer
Sent: Friday, May 20, 2005 12:08 PM
To: [email protected]
Subject: RE: [asp] ASP Script Problem with text fields in Access
Sure, it's a but long but I did comment where the problem is. The data
enters the record fine. Getting it out is the problem. One person who
tested it got al l blanks where the data was supposed to display. I
could use the variables but wanted to actually show the data in the
record.
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of
Moshe Tapnack
Sent: Thursday, May 19, 2005 9:39 AM
To: [email protected]
Subject: RE: [asp] ASP Script Problem with text fields in Access
Can you show the code?
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of
Randy
Schirmer
Sent: Thursday, May 19, 2005 3:16 PM
To: [email protected]
Subject: [asp] ASP Script Problem with text fields in Access
Hi All,
This is slightly OT because I'm asking about pulling data from an Access
database but I am using an ASP script. This is something I haven't
encountered before so I'm sitting here wondering why this would behave
this way.
The set up is simple. I have a form and a submission page that does the
validation routines and then enters the data into a new record. That's
fine. But I like to use a confirmation screen where I rebuild the page
using the data taken from the data fields. I could use the variables but
I'm confirming the data that actually is in the record. But text field
data only shows the first word of the field. For example, the data field
Address1 will have "413 West 5th Ave" but objRS("Address1") will only
display "413". The quotes are only here for clarity. They aren't in the
record. Memo fields show everything. I have a drop down list of states
and states like New York show up fine as well. I looked at the record
itself and the data is all there. I've done this before but either I'm
doing something different or this version of Access behaves differently.
It only happens with text fields.
[Non-text portions of this message have been removed]
ASP Resources www.asp-dev.com
============================================================
Learn over lunch. Get the developerWorks newsletter and
enjoy tools, code, and tutorials, along with your sandwich.
XML, Linux, Web services, Java -- and peanut butter!
http://www.topica.com/partner/AP-1RMZ49/partners/ibm/aff_landing.html
============================================================
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/asp/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
