Invalid column name

[GeorgeBC]

Hi,

I'm receiving this error:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'false'.
/root/program.asp, line 26

My code:

<%Dim con
Set con = CreateObject("ADODB.Connection")
con.Open strDB

' Our Recordset Object
Dim rs
Set rs = CreateObject("ADODB.Recordset")
rSQL = "Select * from all_pages where active<>false and id = "& Request.QueryString("id")
Rs.Open rSQL, Con, 1, 3
%>

This code was work MS Access Database system.
What can I do?

Thank you.

 

[DotNetGnat]

try this:

rSQL = "Select * from all_pages where active<>'false' and id = "& Request.QueryString("id")

-DNG

 

[GeorgeBC]

Thank you, it is working fine.

 

[DotNetGnat]

no problem...glad to help...

-DNG