Signup · Login
Stardeveloper.com  
Home · Tutorials · Forums · Web Hosting Plans · Faisal Khan's Blog · Contact
Forums : ASP : ADO/ODBC : Having problem when inserting a sql statement Signup · Login
Author Thread
Having problem when inserting a sql statement
Posted in tutorial: Using ASP pages to page through Recordsets
·  gilgalbiblewheel
User
Joined: 8 Jul 2004
Total Posts: 6
Having problem when inserting a sql statement
Posted: 17 Oct 2004
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.

Users Who Have Visited This Thread In Last 24 Hours
3 Visitors

Login
UserName Or Email Address:       Password:       Auto-Login:    
· Create New User Account
· Send Forgotten Password by Email
 
© 1999 - 2009 Stardeveloper.com, All Rights Reserved.