old syntax?

[David Mainstreet]

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

[Newsgroup_User]

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/

[David Mainstreet · Accepted solution]

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).