No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
|
Re:
<cfquery> Error
Hello Friends I ran into a syntax error updating a form, I have added a comment to the line below, Please could anyone tell me what I did wrong!!!! [code]<cfquery name="update student" datasource="#Request.super#"> UPDATE student SET studentfirstname='#Trim(Form.studentfirstname)#',. studentlastname='#Trim(Form.studentlastname)#',. address='#Trim(Form.address)#',. city='#Trim(Form.city)#',. state='#Trim(Form.state)#',. studentage='#Trim(Form.studentage)#',. studentclass='#Trim(Form.studentclass)#',. studentstartdate='#Trim(Form.studentstartdate)#',. studentgraduationdate='#Trim(Form.studentgraduationdate)#',. comments= <cfif Len(Trim(Form.comments)) GT 0> …
|