Hi

I'm updating a site I did a year ago and within certain pages it has to update 2 records in the same table so in the old version the code went like this:



if Request("selected" <> "" then
rsQualifier.Update
rsQualifier("DepAirportChoice"=Request("DepAirportChoice"
rsQualifier("ExtensionReq"=Request("ExtensionReq"
rsQualifier("ExtensionDetails"=Request("ExtensionDetails"
rsQualifier("CCName"=Request("CCName"
rsQualifier("FreqFlyerAF"=Request("FreqFlyerAF"
rsQualifier("FreqFlyerBA"=Request("FreqFlyerBA"
rsQualifier("FreqFlyerCont"=Request("FreqFlyerCont"
rsQualifier("SeatPref"=Request("SeatPref"
rsQualifier.Update
If Not rsQualifier2.EOF Or Not rsQualifier2.BOF Then
rsQualifier2.Update
rsQualifier2("DepAirportChoice"=Request("gDepAirportChoice"
rsQualifier2("ExtensionReq"=Request("gExtensionReq"
rsQualifier2("ExtensionDetails"=Request("gExtensionDetails"
rsQualifier2("FreqFlyerAF"=Request("gFreqFlyerAF"
rsQualifier2("FreqFlyerBA"=Request("gFreqFlyerBA"
rsQualifier2("FreqFlyerCont"=Request("gFreqFlyerCont"
rsQualifier2("SeatPref"=Request("gSeatPref"
rsQualifier2.Update
End If
Response.Redirect("reg_flight_test.asp"
end if


Now the MSSQL database is on a new server (and a newer version as well, or so I am told) and it returns the following error:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'Confirmation'.
/work/equant_2005/reg_flight.asp, line 944

where line 944 is the second rsQualifier.Update line in the code above.

anyone any ideas?