11 : 12 : 13 : -------------------------------------------------------------------------------- SQL update TailorC set BILLNO= (param 1) ,DATE= (param 2) ,AMOUNT= (param 3) ,LNAME= (param 4) ,FNAME= (param 5) where TailoringID= (param 6) DATASOURCE crown VENDORERRORCODE -3503 SQLSTATE 42000 Please try the following: Check the ColdFusion documentation to verify that you are using the correct syntax. Search the Knowledge Base to find a solution to your problem. Browser Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; YPC 3.2.0; SV1; ..NET CLR 1.0.3705) Remote Address 127.0.0.1 I want help solve my edit /update and add new data. A have date and $ fields in this database [allowsmilie] => 1 [showsignature] => 0 [ipaddress] => [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 1 [msgid] => [ref] => [htmlstate] => on_nl2br [postusername] => ysurati01 [ip] => webforumsuser@m [isdeleted] => 0 [usergroupid] => [membergroupids] => [displaygroupid] => [password] => [passworddate] => [email] => [styleid] => [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => [showbirthday] => [usertitle] => [customtitle] => [joindate] => [daysprune] => [lastvisit] => [lastactivity] => [lastpost] => [lastpostid] => [posts] => [reputation] => [reputationlevelid] => [timezoneoffset] => [pmpopup] => [avatarid] => [avatarrevision] => [profilepicrevision] => [sigpicrevision] => [options] => [akvbghsfs_optionsfield] => [birthday] => [birthday_search] => [maxposts] => [startofweek] => [referrerid] => [languageid] => [emailstamp] => [threadedmode] => [autosubscribe] => [pmtotal] => [pmunread] => [salt] => [ipoints] => [infractions] => [warnings] => [infractiongroupids] => [infractiongroupid] => [adminoptions] => [profilevisits] => [friendcount] => [friendreqcount] => [vmunreadcount] => [vmmoderatedcount] => [socgroupinvitecount] => [socgroupreqcount] => [pcunreadcount] => [pcmoderatedcount] => [gmmoderatedcount] => [assetposthash] => [fbuserid] => [fbjoindate] => [fbname] => [logintype] => [fbaccesstoken] => [newrepcount] => [vbseo_likes_in] => [vbseo_likes_out] => [vbseo_likes_unread] => [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [avwidth] => [avheight] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 1 [islastshown] => [isfirstshown] => 1 [attachments] => [allattachments] => ) --> No edit/Update - Coldfusion Database Access

No edit/Update - Coldfusion Database Access

Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. The error occurred in C:\CFusionMX7\wwwroot\Crown\Tailor_process.cfm: line 11 9 : <CFIF IsDefined("FORM.TailoringID")> 10 : <!--- Update movie ---> 11 : <CFUPDATE DATASOURCE="crown" TABLENAME="TailorC"> 12 : <CFELSE> 13 : <!--- Add movie ---> -------------------------------------------------------------------------------- SQL update TailorC set BILLNO= (param 1) ,DATE= (param 2) ,AMOUNT= (param 3) ,LNAME= (param 4) ,FNAME= (param 5) where TailoringID= (param 6) DATASOURCE crown VENDORERRORCODE -3503 SQLSTATE 42000 Please try the following: Check the ColdFusion doentation to verify that you are using the correct syntax. Search the Knowledge Base to find ...

  1. #1

    Default No edit/Update

    Error Executing Database Query.
    [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
    Access Driver] Syntax error in UPDATE statement.

    The error occurred in C:\CFusionMX7\wwwroot\Crown\13\Tailor_process.cfm: line
    11

    9 : <CFIF IsDefined("FORM.TailoringID")>
    10 : <!--- Update movie --->
    11 : <CFUPDATE DATASOURCE="crown" TABLENAME="TailorC">
    12 : <CFELSE>
    13 : <!--- Add movie --->




    --------------------------------------------------------------------------------

    SQL update TailorC set BILLNO= (param 1) ,DATE= (param 2) ,AMOUNT= (param 3)
    ,LNAME= (param 4) ,FNAME= (param 5) where TailoringID= (param 6)
    DATASOURCE crown
    VENDORERRORCODE -3503
    SQLSTATE 42000

    Please try the following:
    Check the ColdFusion doentation to verify that you are using the correct
    syntax.
    Search the Knowledge Base to find a solution to your problem.


    Browser Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; YPC 3.2.0; SV1;
    ..NET CLR 1.0.3705)
    Remote Address 127.0.0.1

    I want help solve my edit /update and add new data.
    A have date and $ fields in this database

    ysurati01 Guest

  2. #2

    Default Re: No edit/Update

    DATE is a reserved word so don't use it as a field/column name. Rename it.
    HTH,
    Tim
    --
    Tim Carley
    [url]www.recfusion.com[/url]
    [email]infoNOSPAMINGrecfusion.com[/email]
    Mountain Lover Guest

Similar Threads

  1. Edit Sites Bug after installing MX 6.1 Update
    By earthpigz in forum Macromedia Exchange Dreamweaver Extensions
    Replies: 0
    Last Post: May 27th, 02:39 PM
  2. Update and Cancel events fire as Edit
    By Steve in forum ASP.NET Data Grid Control
    Replies: 3
    Last Post: February 26th, 10:21 PM
  3. Select, Edit, Update Issue
    By Michael D. Murphy in forum ASP.NET Data Grid Control
    Replies: 0
    Last Post: January 29th, 09:52 PM
  4. dynamically adding edit cancel update
    By Tomk20 in forum ASP.NET Data Grid Control
    Replies: 0
    Last Post: September 29th, 03:53 PM
  5. 6.1 Update on Mac OS X - Edit Site?
    By Ryan B webforumsuser@macromedia.com in forum Macromedia Dreamweaver
    Replies: 0
    Last Post: July 29th, 01:21 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •