> I have an bit of code to update an edited record. I'm getting the error "[Oracle]ORA-00927: missing equal sign" in the line WHERE ce_email = '#Form.ce_email#'.
> I can't spot the error. Any suggestions?
>
> <CFQUERY NAME="makeEdit" DATASOURCE="dpch">
> update careerexpo2004
> set ce_orgname = '#Form.ce_orgname#',
> ce_street = '#Form.ce_street#',
> ce_city = '#Form.ce_city#',
> ce_state = #Form.ce_state#,
> ce_zip= #Form.ce_zip#,
> ce_phone = '#Form.ce_phone#',
> ce_fax = #Form.ce_fax#,
> ce_email = #Form.ce_email#,
> ce_repfname = #Form.ce_repfname#
> ce_replname = '#Form.ce_replname#',
> ce_contactfname = '#Form.ce_contactfname#',
> ce_contactlname = '#Form.ce_contactlname#',
> ce_datesubmitted = '#Form.ce_datesubmitted#'
> WHERE ce_email = '#Form.ce_email#'
> </CFQUERY>
Are state, fax, email, repfname, replname numbers (I'm guessing not)?
You'll need single quotes around each value. Further, your issue is
eliminated entirely if you use the cfqueryparam tag, as it'll handle
the quotes for you.
Regards,
Dave.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
