This is a forum where members new and old can come to ask questions and get info and opinions. It is not a place to advertise your business or have other forms of advertising, whether it be in your posts or signature.

All links in the forum will not be indexed by Search Engines and any unapproved forms of advertising or spam will be dealt with accordingly, deleted, and that member's account banned.

Forums

Overview » Dreamweaver » Error during Update

Error during Update
Steve Stark Member Since: 04 Dec 2001 Posts: 5	Posted 07 Dec 2001 22:12:15 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 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

Error during Update

Steve Stark
Member

Since: 04 Dec 2001
Posts: 5

Posted 07 Dec 2001 22:12:15

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

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

Owen Eastwick lost Member Since: 10 May 2001 Posts: 748	Replied 07 Dec 2001 22:41:07 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

Steve Stark Locked Member Since: 04 Dec 2001 Posts: 5	Replied 08 Dec 2001 20:29:35 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

Owen Eastwick lost Member Since: 10 May 2001 Posts: 748	Replied 08 Dec 2001 22:26:30 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

Steve Stark Locked Member Since: 04 Dec 2001 Posts: 5	Replied 08 Dec 2001 23:02:55 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

Owen Eastwick lost Member Since: 10 May 2001 Posts: 748	Replied 09 Dec 2001 01:03:31 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

Tony Barkdull Member Since: 04 Nov 2007 Posts: 2	Replied 15 Jan 2008 22:40:14 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