D
DVan
I have read what this error means, you have invalid column names from the
select statement, misspelling etc.
Here is an excerpt from both my pages, not sure why I am getting this error
still.
----------------------------------------------------------------------------
-
strsql = "select * from Printers where PrinterName <> 'N/A'"
Set Conn = Server.CreateObject("ADODB.Connection")
DSNtest="DRIVER={Microsoft Access Driver (*.mdb)}; "
DSNtest=dsntest & "DBQ=" & Server.MapPath("/database/sa inventory.mdb")
Conn.Open DSNtest
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open strsql, conn, 3,3
----------------------------------------------------------------------------
-
I then send this data to the npResults2 page
response.write "<TD BORDER=1 ALIGN=CENTER WIDTH=50>" & vbcrlf
response.write "<A target='myNewWin' HREF='npResults2.asp?pn=" &
rs("PrinterName")& "'>Edit</a>"
response.write "</TD>" & vbcrlf
----------------------------------------------------------------------------
-
iSerial = Request.QueryString("pn")
strSQL = "SELECT * FROM printers WHERE PrinterName=" & iSerial & ";"
Set Conn = Server.CreateObject("ADODB.Connection")
DSNtest="DRIVER={Microsoft Access Driver (*.mdb)}; "
DSNtest=dsntest & "DBQ=" & Server.MapPath("/database/sa inventory.mdb")
Conn.Open DSNtest
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open strsql, conn, 3,3
Any help is much appreciated.
select statement, misspelling etc.
Here is an excerpt from both my pages, not sure why I am getting this error
still.
----------------------------------------------------------------------------
-
strsql = "select * from Printers where PrinterName <> 'N/A'"
Set Conn = Server.CreateObject("ADODB.Connection")
DSNtest="DRIVER={Microsoft Access Driver (*.mdb)}; "
DSNtest=dsntest & "DBQ=" & Server.MapPath("/database/sa inventory.mdb")
Conn.Open DSNtest
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open strsql, conn, 3,3
----------------------------------------------------------------------------
-
I then send this data to the npResults2 page
response.write "<TD BORDER=1 ALIGN=CENTER WIDTH=50>" & vbcrlf
response.write "<A target='myNewWin' HREF='npResults2.asp?pn=" &
rs("PrinterName")& "'>Edit</a>"
response.write "</TD>" & vbcrlf
----------------------------------------------------------------------------
-
iSerial = Request.QueryString("pn")
strSQL = "SELECT * FROM printers WHERE PrinterName=" & iSerial & ";"
Set Conn = Server.CreateObject("ADODB.Connection")
DSNtest="DRIVER={Microsoft Access Driver (*.mdb)}; "
DSNtest=dsntest & "DBQ=" & Server.MapPath("/database/sa inventory.mdb")
Conn.Open DSNtest
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open strsql, conn, 3,3
Any help is much appreciated.