What is wrong? I got an error

ClueLess

11-25-2002, 04:09 PM

strsql = "SELECT LPNum, LPName, LPAddress, LPCity, LPState, LPZip5, LPZip4, LoanNumber, Action " & _
"FROM " & InfoB & _
" WHERE PolicyCSPNum = " & "'" & PolicyCSPNum & "'" & " VehicleNum = " & "'" & strVehicleNum & "'" & " AND Action = 'A'" & _
" ORDER BY LPNum"

Spookster

11-25-2002, 04:34 PM

What was the error and what server-side language are you interfacing with the database with?

ClueLess

11-25-2002, 05:11 PM

It's complaining about the syntax. ...I don't see any wrong on that one

Spookster

11-25-2002, 07:23 PM

I see several potential problems but I would still like to know what server-side language you are using and specifically what the error stated before I point out what I think is wrong.

rcreyes

11-26-2002, 05:37 AM

You are missing the KEYWORD 'AND" between WHERE clause, below is the corrected SQL statement.

strsql = "SELECT LPNum, LPName, LPAddress, LPCity, LPState, LPZip5, LPZip4, LoanNumber, Action " & _
"FROM " & InfoB & _
" WHERE PolicyCSPNum = " & "'" & PolicyCSPNum & "'" & " AND VehicleNum = " & "'" & strVehicleNum & "'" & " AND Action = 'A'" & _
" ORDER BY LPNum"