Skip to main content
Inspiring
October 3, 2006
Answered

Why a syntax error?

  • October 3, 2006
  • 2 replies
  • 455 views
Okay, it's stupid time. Why does the following give me a syntax error in UPDATE statement?

<CFQUERY NAME="updateInfo" DATASOURCE="gph">
UPDATE eventpics set
eventname = '#form.eventname#',
pictext = '#form.pictext#',
WHERE picpath = '#form.picpath#'
</CFQUERY>


This topic has been closed for replies.
Correct answer Dan_Bracuk
take away the 2nd comma

2 replies

ghouserAuthor
Inspiring
October 3, 2006
DOH! I stared at it way too long. That's what I get for sleeping only 2 hrs. a night to work on this project. Thanks Dan.
Dan_BracukCorrect answer
Inspiring
October 3, 2006
take away the 2nd comma