|
| |
|
|
JohnS
Posts: 5
Joined: 6/5/2002
From:
Status: offline
 |
Using FP to Submit TextArea to Access DB - 6/5/2002 13:38:00
I have created a form that contains text input fields and a textarea. The text input fields get saved to my Access database with no problem but I can't get the textarea to save.
When I use the Form Properties Options panel to link the form fields to the database fields I get the message "The type of field 'jDescription' does not match the type of the column 'jobDescription' in the database. Modify the field mapping or change the validation settings on the form field."
I have not been able to resolve this issue and when I use the form I get all the input text saved to the database and an error: "Error Description: Multiple-step OLE DB operation generated errors Check each OLE DB status value, if available. No work was done. Error Number: -2147217887 Error Source: Microsoft OLE DB Provider for ODBC Drivers"
How do I save this textarea to the Access Database??
Help!!
Thanks!!
|
|
|
|
rdouglass
Posts: 9272
From: Biddeford, ME USA
Status: offline
|
RE: Using FP to Submit TextArea to Access DB - 6/5/2002 15:22:16
Just a quick thing to check: is jobDescription field in DB a memo field???
| |
|
|
|
JohnS
Posts: 5
Joined: 6/5/2002
From:
Status: offline
|
RE: Using FP to Submit TextArea to Access DB - 6/5/2002 15:39:14
JobDescription is a text field in the Access database. Required = No. Zero Length = Yes. Indexed = No. Unicode = No. IME Mode = No Control. IME Sentence Mode = None.
| |
|
|
|
alveyuk
Posts: 80
Joined: 4/4/2002
From: Lincs United Kingdom
Status: offline
|
RE: Using FP to Submit TextArea to Access DB - 6/5/2002 19:10:44
I have had something similar problems feeding into an Informix database and the problem there was the ODBC connection cannot handle text fields greater than 255 characters. It is OK with memo fields and text fields less than this but not the big text fields.
The database could handle it and FrontPage could handle it but the ODBC driver could not.
This may be similar to your problem?
Ken Alvey
| |
|
|
|
JohnS
Posts: 5
Joined: 6/5/2002
From:
Status: offline
|
RE: Using FP to Submit TextArea to Access DB - 6/5/2002 20:13:46
Access has the limit of 255 characters also. I've limited the field to as little as 50 characters and tested it with as few as 3 or 4 with the same results. the problem actually starts with FP claiming the type mismatch. If I change the field to an input field with type="text" the problem disappears but I need the convenience the textarea tag offers.
Thanks anyway.
| |
|
|
|
rdouglass
Posts: 9272
From: Biddeford, ME USA
Status: offline
|
RE: Using FP to Submit TextArea to Access DB - 6/6/2002 12:47:41
IIRC, you'll need to 'map' textareas to Access memo fields and not text fields reguardless of size. Can you change your Access text field to a memo field and try that??
| |
|
|
|
JohnS
Posts: 5
Joined: 6/5/2002
From:
Status: offline
|
RE: Using FP to Submit TextArea to Access DB - 6/6/2002 15:00:03
Thanks! I misunderstood your first posting, but that did it.
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
