Hi there

I've got an update statement which is throwing up an error on line 7. I'm hoping someone can help me with it - here is the code - any help would be greatly appreciated.

<%
    set con = server.createobject("ADODB.Connection")
    con.open Application("hp_ConnectionString")

    SQLUpdate = "UPDATE TVListings SET TVTime = " & request("ProgTime") & " AND TVDate = " & request.Form("ProgDate") & " AND Title = " & request.Form("ProgTitle") & " AND Channel = " & request.Form("ProgChannel")

    con.execute(SQLUpdate)

    response.redirect("listings.asp?ListingsID="& request("ListingsID") &"&cache="&server.URLEncode(Now))
%>

Line 7 is the code: con.execute(SQLUpdate)

The error that it gives me is:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '00'.

/secure/Listings/process_edit.asp, line 7


thanks in anticipation

Adam

I see two problems.

First you need quotes around your date and string values.

for example:
Secondly, the first AND should be a WHERE.

It's always helpful when debugging SQL statements to include a statement before the execute. This will help you more easily see the syntax errors.

Bruce Luckcuck
Director, Applications & Support Services
Wiley Publishing, Inc.

Adam,
In UPDATE statement you have to use "," instead of AND, and be sure that you have quoted all string and date values:
SQLUpdate = "UPDATE TVListings SET TVTime = '" & request("ProgTime") & "',TVDate = '" & request.Form("ProgDate") & "',Title = " & request.Form("ProgTitle") & ",Channel = " & request.Form("ProgChannel")

...but the Soon is eclipsed by the Moon