[thelist] SQL: Can you spot the error?

Anthony Baratta Anthony at Baratta.com
Tue Jul 15 00:23:05 CDT 2003

At 10:04 PM 7/14/2003, Casey Crookston wrote:
>I keep getting a syntax error for this statement:
>UPDATE news SET title = 'Krispy Kreme in Maple Grove Completed.f', date =
>'7/14/2003', active = 1, article ='The new Krispy Kreme in xxxxx is now open
>for business! xxxxx was awarded a sub-contract in the construction of the
>popular doughnut franchise, and is currently in negations to help construct
>a restaurant in xxxx.' WHERE news_id = 3

What error are you getting? What SQL DB are you using? What Language are 
you using? Does the target table have all the columns you are attempting to 
update? Are the columns long enough to support the text lengths? is 
"active" a numeric column?

Inquiring minds want to know. ;-)

Anthony Baratta
Keyboard Jockeys

"Conformity is the refuge of the unimaginative."

More information about the thelist mailing list