how to remove the query statement?

gilgalbiblewheel · September 10th, 2004, 08:50 PM

I have this on top of my ASP response page:

Code:

SELECT * FROM bible WHERE text_data LIKE '%%' AND text_data LIKE '%%' AND text_data LIKE '%%' AND ( recordType = 'ju')

How can I remove it?

Snib · September 10th, 2004, 08:53 PM

What is the code for your page?

-Snib <><
http://www.snibworks.com/

rajanikrishna · September 11th, 2004, 12:14 AM

Do you have any Response.write sql

where sql="select * from bible ..."

if so, remove it

gilgalbiblewheel · September 11th, 2004, 09:25 AM

This is what I have:

Code:

SQL = "SELECT * FROM bible WHERE "
    strConn = GetConnectionString()

    ' Let's see what page are we looking at right now
    nPage = CLng(Request.QueryString("Page"))

    ' Let's see what user wants to search for today :)
    Keyword = Trim(Request.QueryString("Keyword"))
    spoke = Request.Querystring("spoke")
    number = Request.QueryString("number")
    Keywordb = Request.QueryString("Keywordb")
    Keywordc = Request.QueryString("Keywordc")

'Set conn = Server.CreateObject("ADODB.Connection")  
'conn.Open(GetConnectionString)              

iCounter = 0

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

  SQL = SQL & "text_data LIKE '%" & Keyword & "%' AND "  
  SQL = SQL & "text_data LIKE '%" & Keywordb & "%' AND "
  SQL = SQL & "text_data LIKE '%" & Keywordc & "%'"

  iCounter = iCounter + 1

end if


If   request.QueryString("book")="yes" then

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

  SQL = SQL & "book LIKE '" & number & "'"

  iCounter = iCounter + 1

end if


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

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

  SQL = SQL & "book_title LIKE '%" & number & "%'"

  iCounter = iCounter + 1

end if

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

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

  SQL = SQL & "chapter LIKE '%" & number & "%'"

  iCounter = iCounter + 1

end if

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

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

  SQL = SQL & "verse LIKE '%" & number & "%'"

  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 = '" & spoke & "'"

  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 = '" & spoke & "'"

  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 = '" & spoke & "'"

  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

happygv · September 11th, 2004, 09:29 AM

Is this the code of entire page that shows up on the browser or you include this on another page?

_________________________
- Vijay G
Strive for Perfection

gilgalbiblewheel · September 11th, 2004, 10:38 AM

Well that's the ASP code (part of), the part which I think is concerned. The actual statement is somthing like this:
SELECT * FROM bible WHERE text_data LIKE '%ezra%' AND text_data LIKE '%%' AND text_data LIKE '%%'

As you see, whatever is included in the "", from "Select to the IFs

happygv · September 11th, 2004, 10:41 AM

So, I am sure you have used Response.write SQL somewhere on that page. Not within the part of code that you pasted. Search for it and remove.

Hint: It is adviced to search below this part of code for response.write.;)

_________________________
- Vijay G
Strive for Perfection

gilgalbiblewheel · September 11th, 2004, 10:55 AM

Bingo. It was above. There were codes along with it that I didn't understand, so I was afraid to remove it. Thanks.

happygv · September 11th, 2004, 11:10 AM

Wondering, how you would get this sql statement, if that was written above the definition part? So you might have posted the wrong block of code.

_________________________
- Vijay G
Strive for Perfection