> 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 ce_state, ce_zip, ce_fax or ce_repfname really numeric fields? They
probably shouldn't be, if they are.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
