what's wrong with the pageing?

[gilgalbiblewhee]

what's wrong with the pageing?

when I click next page it says:


SELECT * FROM bible WHERE

Microsoft OLE DB Provider for ODBC Driverserror '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error in WHERE clause. /bible7.asp, line 473

[Daniel T]

Well, I have no knowledge of ASP whatsoever, but I'll take a stab at it based on what the problem would be had I been using a MySQL database with PHP, as it may help.

Could it be that there is no `` around the table name?
SELECT * FROM `bible` WHERE

[gilgalbiblewhee]

I've never seen in the tutorials and guidance to put '' around the tablename. But thanks for the help.

Here is the correct attachment.

[buntine]

Ok, some of your code is redundant. The root cause of the problem is the fact that your SQL query is only half done. You need to check for a condition when using the WHERE clause.

It seems the list of If Statements are not returning true, and thus your SQL string is not being completed. Do some debugging by writing the value of your queryString members to the page.

For example, see what this prints out:

Response.Write (Request.QueryString("verse_spoke"))

Regards.