I'm new to UltraDev, but have used other
tools and hand coded ASP for a long time. I
have created a lookup page passing in a
single parameter to a SQL statement that
then opens a single record. All the data
from the record is visible and populated inthe form, but when I submit the changes, I get the following error:


Technical Information (for support personnel)

Error Type:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)


[Microsoft][ODBC Microsoft Access Driver]
Syntax error in UPDATE statement.

/ClientEdit.asp, line 89

Browser Type:

Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)

Page:

POST 494 bytes to /ClientEdit.asp

POST Data:

CompanyName=DNS+Computing+Services&ContactFirstName=Steve
&ContactLastName=Stark&CompanyOrDepartment=&BillingAddress=
1485+Mataoka+Street&City=Mt+Pleasant&StateOrProvince=SC
&PostalCode=29464&CountryRegi . . .



Time:

Friday, December 07, 2001, 3:37:55 PM





More information:

Microsoft Support



The update form was created using the
UltraDev Update Record function in the live
object palette. Can anyone advise?



Thanks in advance


Steve




Edited by - lostinUltraDev on 07 Dec 2001 22:19:52

Most likely cause is trying update a Numeric database field with Text, check your column names data types etc.

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

Check all fields in both database as well as form...All text.

Did notice the post string was truncated. Also notice in the code it has a variable defined as QueryString. This would be the get method and would truncate the data to 255 characters, If my memory serves me correctly.

Is there a configuration parameter where I can define the form method as "POST"?


Thanks in advance

Steve

The form method is set in the properties pallette (Ctrl+F3).

Place the cursor within the form on the page then click on the <Forrm> tag at the bottom left of the page design window.

Alternatively change it directly in the code view:

<form name="formName" method="post" action="YourResultsPage.asp">

On page page defined as the forms action make sure that you are not using Requets.QueryString("formElement" this will only pick up things passed as a URL parameter, use Request or Request.Form("formElement"

One other thing that has occured to me, are you trying to insert a text string into a database field that is too small, ie. trying to insert a 200 character string into a text field with a Field Size of 50 characters. In addition remember that the maximum size for an Access Text field is 255 characters, if you need to store anything longer than this set the fields Data Type to Memo.

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

Thank you very much. That was thje problem and now all is well.

One more question, can I post an unlimited text field to a memo field in teh database. Are there any restrictions if I use the POST method?

Thanks again.

Steve

An Access Database Text field can hold up to 64,000 characters, so pretty big but yiu can't hold War & Peace in on cell.

Can't find any refernce to maximum amount of data you can POST but you could take a look at:

www.jmarshall.com/easy/cgi/cgi_footnotes.html#getvspost

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

I found my own solution. I was working on web pages that pass software names to a detials page. My pronblem was there were apersands (& in the descriptions being passed and the descriptions were being truncated. Replacing them with 'and' fixed them