Professional Web Applications Themes

Checkout Problems - Macromedia ColdFusion

The below is to error I am receiving when I attempt to checkout? Any ideas on how to resolve? Syntax error or access violation: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 10 Text...

  1. #1

    Default Checkout Problems

    The below is to error I am receiving when I attempt to checkout? Any ideas on
    how to resolve?

    Syntax error or access violation: You have an error in your SQL syntax; check
    the manual that corresponds to your MySQL server version for the right syntax
    to use near ')' at line 10 Text

    Frustrated in Philly Guest

  2. #2

    Default Re: Checkout Problems

    Frustrated, You need a lot more information in your description. But, I will
    assume you get this error during a checkout of a shopping cart in a commerce
    application. Turn on verbose debugging in cfadmin. Then do another checkout.
    You should see the specific template and line that cause the problem. Review
    the code and fix. If necessary create the error again. The debug output
    should even contain the specific SQL that was sent. Copy that SQL. Now run
    this SQL outside of ColdFusion in a query tool. What error does MySQL return.
    Fix that error. Post the specifics here if you cannot figure it out.
    Hopefully a forum user can. HTH.

    ksmith Guest

Similar Threads

  1. Question checkin/checkout
    By vinu in forum Brainstorming Area
    Replies: 0
    Last Post: April 25th, 05:54 AM
  2. can you please checkout these urls
    By j2eesatish in forum Macromedia Flex General Discussion
    Replies: 1
    Last Post: August 3rd, 07:37 PM
  3. What point did they checkout?
    By barbedwire103 in forum Dreamweaver AppDev
    Replies: 0
    Last Post: April 27th, 09:34 PM
  4. Trying to develop an equipment checkout app
    By Kaye in forum Dreamweaver AppDev
    Replies: 0
    Last Post: April 18th, 08:31 PM
  5. checkout my new pics
    By Jeffrey Stetz in forum Photography
    Replies: 3
    Last Post: July 16th, 06:54 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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139