When I do a cfdump, I get:

8 testing testing *boom!* 1 
9 Excellent! Made #3 Active 1 
11 humdedum 1 

I shouldn't have been using commentID#i# anyway, as that's already a
unique identifier.  Fixing that doesn't resolve the issue and I'm still
seeing this error:

 Syntax error in UPDATE statement.  
  
The error occurred in
C:\Inetpub\wwwroot\blinktag\mod\comments\commentUpdate.cfm: line 15
 
13 :
commentActive=#Evaluate("FORM.commentActive#i#")#
14 :    WHERE   commentID=#FORM.commentID#
15 :    </cfquery>
16 : </cfloop>
17 : 

 


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

                                Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
                                

Reply via email to