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.
I'm assuming this is a script problem more than an Access problem since
the data is there.
Thanks so much!
Randy S.
[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/
