I wanted to use the pageing (or paging) sample and insert a query statement. The statement is from another code which worked. But when I insert it it says:
SELECT * FROM bible WHERE text_data LIKE '%artaxerxes%' AND text_data LIKE '%%' AND text_data LIKE '%%'
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause.
/wheelofgod/kjvresp2.asp, line 218
Some suggested to remove the additional text_datas. But when I left only "SELECT * FROM bible" removing everything else the same problem occured.