[thelist] SQL: Can you spot the error?

[Anthony Baratta]

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
President
Keyboard Jockeys

"Conformity is the refuge of the unimaginative."