Thanks for the help.
> 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>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
