Added: December/28/2005 at 4:07am | IP Logged

HI,

Trying to connect to a Point of Sale Retail system for our company, so to create a couple of reports.

The problem is that the table within the database we want to access uses a name of "POS HISTORY HEADER". As a result, there is a syntex error in the from clause.  How do I overcome this issue? Theres Not a hope of editing any names in the table.

Below is what I have to start with:

<%

FileName="Connection_ado_conn_string.htm"

 ' Type="ADO" ' DesigntimeType="ADO"

' HTTP="false" ' Catalog="" ' Schema="" Dim MM_classifieds_STRING 'MM_classifieds_STRING = "Driver={Microsoft Access Driver (*.mdb)};DBQ=f:\data2000R.mdb"

MM_classifieds_STRING = "Driver={Microsoft Access Driver (*.mdb)};DBQ=f:\data2000R.mdb"

'MM_classifieds_STRING = "dsn=classifieds411;"

%>

<%

set rsResult = Server.CreateObject("ADODB.Recordset") rsResult.ActiveConnection = MM_classifieds_STRING rsResult.Source = "SELECT * FROM POS HISTORY HEADER"

rsResult.CursorType = 0

rsResult.CursorLocation = 2 rsResult.LockType = 3

rsResult.Open()

rsResult_numRows = 0

%>

Added: December/28/2005 at 8:18pm | IP Logged

bad database design whoever did that...

basically in your sql statement POS HISTORY HEADER has to be surrounded by something... brackets maybe [] ? quotes '' ?

I forget but something like that

Doing a google search on sql statements and table names with spaces should bring up something on it...

or any good SQL book/documentation