what's wrong with the pageing?

gilgalbiblewheel · August 11th, 2004, 08:44 PM

what's wrong with the pageing?

when I click next page it says:

SELECT * FROM bible WHERE

Quote:

quote:Microsoft OLE DB Provider for ODBC Driverserror '80040e14'

Quote:

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

rajanikrishna · August 11th, 2004, 11:07 PM

From your select statement it seems you have'nt given any condition in where clause. If not, check your condition.

Fieldname is correct or not, datatype
Otherwise you response.write the sql statement and see how it was formed.

gilgalbiblewheel · August 12th, 2004, 10:20 AM

yes but aren't the conditions stated in the ifs?

Code:

  SQL = "SELECT * FROM bible WHERE "
    strConn = GetConnectionString()
                    Response.Write request.QueryString("book")
    If   request.QueryString("book")="Book" then

      Sql = Sql & "book LIKE '%" & Keyword & "%'"

      iCounter = iCounter + 1

    end if

    If   request.QueryString("book_spoke")="Book_Spoke" then

      If iCounter > 0 Then
        Sql = Sql & " AND "
      End If

      Sql = Sql & "book_spoke LIKE '%" & Keyword & "%'"

      iCounter = iCounter + 1

    end if

    If   request.QueryString("book_title")="Book_Title" then

      If iCounter > 0 Then
        Sql = Sql & " AND "
      End If

      Sql = Sql & "book_title LIKE '%" & Keyword & "%'"

      iCounter = iCounter + 1

    end if

    If   request.QueryString("chapter")="Chapter" then

      If iCounter > 0 Then
        Sql = Sql & " AND "
      End If

      Sql = Sql & "chapter LIKE '%" & Keyword & "%'"

      iCounter = iCounter + 1

    end if


    If   request.QueryString("chapter_spoke")="Chapter_Spoke" then

      If iCounter > 0 Then
        Sql = Sql & " AND "
      End If

      Sql = Sql & "chapter_spoke LIKE '%" & Keyword & "%'"

      iCounter = iCounter + 1

    end if

    If   request.QueryString("verse")="Verse" then

      If iCounter > 0 Then
        Sql = Sql & " AND "
      End If

      Sql = Sql & "verse LIKE '%" & Keyword & "%'"

      iCounter = iCounter + 1

    end if

    If   request.QueryString("verse_spoke")="Verse_Spoke" then

      If iCounter > 0 Then
        Sql = Sql & " AND "
      End If

      Sql = Sql & "verse_spoke LIKE '%" & Keyword & "%'"

      iCounter = iCounter + 1

    end if

    If   request.QueryString("text_data")="Text" then

      If iCounter > 0 Then
        Sql = Sql & " AND "
      End If

      Sql = Sql & "text_data LIKE '%" & Keyword & "%'"

      iCounter = iCounter + 1

    end if
    If Trim(Request.QueryString("recordType")) <> "" Then


  aRecTypes = Split(Request.QueryString("recordType"), ",")

  If IsArray(aRecTypes) Then 'This is a bit redundant, but it can't hurt
    SQL = SQL & " AND ("



    For iLoopCount = 0 To UBound(aRecTypes)
      If iLoopCount <> 0 Then
        SQL = SQL & " OR "
      End If

      SQL = SQL & " recordType = '" & trim(aRecTypes(iLoopCount)) & "'"
    Next
  End If
  SQL = SQL & ")"
End If

bmains · August 12th, 2004, 07:05 PM

Hey,

Yes in theory, but that error would mean that none of your ifs are being hit. Try adding the where to each of these clauses, or have a separate where SQL variable and if it isn't empty, append it to the SQL variable.

Brian

rajanikrishna · August 12th, 2004, 08:22 PM

Hi,

May be none of your IF conditions are being satisfied as the earlier post said. You try response.write sql statement before executing and see how it was formed.