How to get rid of this comma!!?!

gilgalbiblewheel · August 4th, 2005, 11:54 PM

Ok now, what's wrong with this?

Code:

<td>
<%
TheString = rs("text_data")
ArrayTemp = split(TheString, " ")
NumberOfWords = UBound(ArrayTemp) + 1

Response.Write "<P><i>Number of words:</i>" & NumberOfWords & "</br>"
i=0

   For Each Word In ArrayTemp
   Response.Write "<input type=""checkbox"" value=""" & Trim(ArrayTemp(i)) & """ name=""Keywordh"">" & word & "</br>"
i=i+1
  next
  Response.Write "</br>"

%>
</td>

response page:

Code:

     If Keywordh <> "" Then
            ArrayTemp = split(Keywordh," ")
                whereclause = whereclause + " text_data LIKE '" & Trim(ArrayTemp(0)) & "'"
                i=i+1
            for i=1 to ubound(ArrayTemp)
                whereclause = whereclause + " AND text_data LIKE '" & Trim(ArrayTemp(i)) & "'"
            next
         SQL = SQL & whereclause
    End If

It's able to search:

Quote:

quote:SELECT * FROM bible WHERE text_data LIKE 'after,' AND text_data LIKE 'death,' AND text_data LIKE 'Moses,' AND text_data LIKE 'servant,' AND text_data LIKE 'LORD'

but says

Quote:

quote:We did not find a match of "after, death, Moses, servant, LORD"!

Martial Law 9/11 Rise of the Police State is now available! Visit our Martial Law movie section for complete info (click here), or order now by clicking the button below or by calling 888-253-3139
http://www.infowars.com/martial_law_911.htm

rstelma · August 5th, 2005, 09:00 AM

You still have the comma in the search. Please split that comma out of there.

split(Keywordh,",")

I don't see what your i = i + 1 is supposed be doing. I could be wrong but unless you use 'for i = 0 ubound(myarray)' you won't get the first array value 'myarray(0)'.

Also, if you want to use LIKE you're going to have to program in the wild card, '%':

SELECT * from bible where text_data LIKE '%after%' AND text_data LIKE '%death%';

Try this out in Query Analyzer and see what kind of output you get. Once you get your SQL statement correct then you can just program it into the app.

Fudd

gilgalbiblewheel · August 8th, 2005, 10:50 AM

OK. Now, how do you get rid of punctuation from within sql? Because I did the split function on the space bar to separate the words but the punctuation remains.

Martial Law 9/11 Rise of the Police State is now available! Visit our Martial Law movie section for complete info (click here), or order now by clicking the button below or by calling 888-253-3139
http://www.infowars.com/martial_law_911.htm

rstelma · August 8th, 2005, 01:31 PM

If you split(myarray, ",") then you take the comma out, then you can use Trim to take of the leading and ending spaces.

gilgalbiblewheel · August 8th, 2005, 04:58 PM

what about "; : , . ? "

Martial Law 9/11 Rise of the Police State is now available! Visit our Martial Law movie section for complete info (click here), or order now by clicking the button below or by calling 888-253-3139
http://www.infowars.com/martial_law_911.htm

rstelma · August 8th, 2005, 06:41 PM

Replace(Replace(Replace(Replace(Replace(Replace(my array(i),";",""),":",""),",",""),".",""),"?","")," '","''")

This may not be the best way, but it will work. You may want to write a 'strip' function to get the same results that way you can use it on multiple variables.