You could print the Query before execution, that would be better to look at.
Tom
PCGUY <pcguy_at_lucent.com> wrote in message
news:8e4m3g$a53_at_nntpa.cb.lucent.com...
> I'm using ASP to run a query against an oracle database, but it reports an
> invalid column name...typically I know this is usually a misspelling or
> something...But I wanted to verify that you can do a JOIN with other
> criteria in the WHERE clause with an UPDATE query...
>
> So is this query properly structured? Thanks in advance!
>
> SQLStmt = "update repair "
>
> SQLStmt = SQLStmt & "set repair_action_code = '" & action & "', "
>
> SQLStmt = SQLStmt & "repair_cause_code = '" & cause & "', "
>
> SQLStmt = SQLStmt & "part_number = '" & part & "', "
>
> SQLStmt = SQLStmt & "reference_designator = '" & reference & "' "
>
>
> SQLStmt = SQLStmt & "where product_event.event_id = " &
> session("event_id_repair") & " "
>
> SQLStmt = SQLStmt & "and product_event.assembly_serial_number = '" &
> session("serial_number_repair") & "' "
>
>
> SQLStmt = SQLStmt & "and product_event.event_id = repair.event_id "
>
>
> SQLStmt = SQLStmt & "and repair.repair_action_code = '" & old_action & "'
"
>
> SQLStmt = SQLStmt & "and repair.repair_cause_code = '" & old_cause & "' "
>
> SQLStmt = SQLStmt & "and repair.part_number = '" & old_part & "' "
>
> SQLStmt = SQLStmt & "and repair.reference_designator = '" & old_refdes &
"'
> "
>
> Set RS = Connection.Execute(SQLStmt)
>
>
>
Received on Wed Apr 26 2000 - 00:00:00 CDT
