What is wrong? I got an error

[ClueLess]

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]

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

[ClueLess]

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

[Spookster]

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]

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"