Skip to main content
D
David Mainstreet
Inspiring
November 16, 2008
Answered

old syntax?

  • November 16, 2008
  • 2 replies
  • 353 views
Is it possible that my host has a newer version of ColdFusion that no longer likes my syntax? (I haven't heard back from them yet.)

About 5 or 6 years ago, I learned just enough ColdFusion to build an art gallery for my brother.

If we're remembering correctly, when using an artwork information edit page that I built, he could leave the dimension and price fields blank, but now any one of those fields without a number gives an error message:


Error Executing Database Query.

Data truncated for column 'price' at row 1

The error occurred inD: \artist6_uploadProcess.cfm: line 122
120 : itemID = '#form.itemID#'
121 :
122 : WHERE productID = #form.productID#
123 : </cfquery>
124 :
SQLSTATE 01000
SQL UPDATE products SET price = '', priceFramed = '', productHeight = '', measureSymbolHeight = 'inches', productWidth = '', measureSymbolWidth = 'inches', productDepth = '', measureSymbolDepth = '', productMaterials = '', productInfo = '', itemID = '550' WHERE productID = 387
VENDORERRORCODE 1265


    This topic has been closed for replies.
    Correct answer David Mainstreet
    Thank you so much for replying to my question. After much back and forth with my host, it turned out that the problem I described and many others that developed (the entire site eventually turned into a blank page!) were all the fault of their server. They fixed the problem and all is well (except that they still haven't explained what went wrong in the first place).

    2 replies

    D
    David MainstreetAuthorCorrect answer
    Inspiring
    January 8, 2009
    Thank you so much for replying to my question. After much back and forth with my host, it turned out that the problem I described and many others that developed (the entire site eventually turned into a blank page!) were all the fault of their server. They fixed the problem and all is well (except that they still haven't explained what went wrong in the first place).
    N
    Newsgroup_User
    Inspiring
    November 17, 2008
    nothing to do with cf syntax - your problem is in your db.
    what data type is the PRICE field in your PRODUCTS table?
    is it numeric or text type?
    is it set up to allow NULL values?
    does it have a default value?

    Azadi Saryev
    Sabai-dee.com
    http://www.sabai-dee.com/
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices