Search multiple subtrings return results

TheMSsForum.com: The Microsoft Software Forum

I am trying to code a search action for an asp page
this will search an mdb memo field for occurrences of
each substring from a form field that can have multiple
values

for example in the form field name "keywords"
the user could input per following example

one flesh, marriage, women

the keywords I want to contain phrases as well
as individual words. Each value or substr of the field
will be separated with commas.

Question how can I extract the substrings and
create variables holding each substring encountered
Is this possible and if so how?
Top

Re: Search multiple subtrings return results by Bruce

Bruce
Tue Jun 22 12:25:28 CDT 2004

How about using SPLIT to create an array of keywords?

dim sMemo, aKeywords
' code here to get memo field contents into sMemo
aKeywords = split(sMemo, ",")

"Rev. Michael Kujawa" <sdkngfksdnf> wrote in message
news:uDz5PJGWEHA.2176@TK2MSFTNGP11.phx.gbl...
> I am trying to code a search action for an asp page
> this will search an mdb memo field for occurrences of
> each substring from a form field that can have multiple
> values
>
> for example in the form field name "keywords"
> the user could input per following example
>
> one flesh, marriage, women
>
> the keywords I want to contain phrases as well
> as individual words. Each value or substr of the field
> will be separated with commas.
>
> Question how can I extract the substrings and
> create variables holding each substring encountered
> Is this possible and if so how?
>
>


Top

Re: Search multiple subtrings return results by Rev

Rev
Tue Jun 22 15:23:14 CDT 2004

Thanks,
using split worked fine
now what I want to do is highlight or bold the expressions found in the
result
the search is complete and you can see it at
http://www.kujawas.net/study/bible/bible.html

So any ideas on highlighting the keywords in the result?


"Bruce Hensley" <dummy@nowhere> wrote in message
news:O%23Ctr3HWEHA.2444@TK2MSFTNGP11.phx.gbl...
> How about using SPLIT to create an array of keywords?
>
> dim sMemo, aKeywords
> ' code here to get memo field contents into sMemo
> aKeywords = split(sMemo, ",")
>
> "Rev. Michael Kujawa" <sdkngfksdnf> wrote in message
> news:uDz5PJGWEHA.2176@TK2MSFTNGP11.phx.gbl...
> > I am trying to code a search action for an asp page
> > this will search an mdb memo field for occurrences of
> > each substring from a form field that can have multiple
> > values
> >
> > for example in the form field name "keywords"
> > the user could input per following example
> >
> > one flesh, marriage, women
> >
> > the keywords I want to contain phrases as well
> > as individual words. Each value or substr of the field
> > will be separated with commas.
> >
> > Question how can I extract the substrings and
> > create variables holding each substring encountered
> > Is this possible and if so how?
> >
> >
>
>


Top

Re: Search multiple subtrings return results by Rev

Rev
Tue Jun 22 18:12:25 CDT 2004

Never mind figured out the formatting procedure


Top

Re: Search multiple subtrings return results by Devapriya

Devapriya
Wed Jun 23 08:46:45 CDT 2004

Hi,

I was just going through your page and got the following error when I
entered the following text in the search.
one flesh, marriage, women


Microsoft VBScript runtime error '800a01a8'
Object required: ''

/study/bible/biblesearch/Biblesearch.asp, line 88

Hope this information will help you.



"Rev. Michael Kujawa" <sdkngfksdnf> wrote in message
news:ukrKl4KWEHA.3472@TK2MSFTNGP09.phx.gbl...
> Never mind figured out the formatting procedure
>
>


Top

Re: Search multiple subtrings return results by Rev

Rev
Wed Jun 23 10:05:40 CDT 2004

Very strange
I did the same thing and received no error
did you hit the enter key instead of clicking
the submit button?

maybe I have to place a tag inside the submit
button to trap an enter key
Which I don't know how to do


"Devapriya De Silva" <ddesilva@qa-software.com> wrote in message
news:Oriy7hSWEHA.2340@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> I was just going through your page and got the following error when I
> entered the following text in the search.
> one flesh, marriage, women
>
>
> Microsoft VBScript runtime error '800a01a8'
> Object required: ''
>
> /study/bible/biblesearch/Biblesearch.asp, line 88
>
> Hope this information will help you.
>
>
>
> "Rev. Michael Kujawa" <sdkngfksdnf> wrote in message
> news:ukrKl4KWEHA.3472@TK2MSFTNGP09.phx.gbl...
> > Never mind figured out the formatting procedure
> >
> >
>
>


Top

Re: Search multiple subtrings return results by Rev

Rev
Wed Jun 23 11:07:13 CDT 2004

Yup....
it was the enter key

I added an
onKeypress="if (event.keyCode==13) event.returnValue = false;"
inside the field tag and now there is no error




"Rev. Michael Kujawa" <sdkngfksdnf> wrote in message
news:OPYyPNTWEHA.2928@tk2msftngp13.phx.gbl...
> Very strange
> I did the same thing and received no error
> did you hit the enter key instead of clicking
> the submit button?
>
> maybe I have to place a tag inside the submit
> button to trap an enter key
> Which I don't know how to do
>
>
> "Devapriya De Silva" <ddesilva@qa-software.com> wrote in message
> news:Oriy7hSWEHA.2340@TK2MSFTNGP09.phx.gbl...
> > Hi,
> >
> > I was just going through your page and got the following error when I
> > entered the following text in the search.
> > one flesh, marriage, women
> >
> >
> > Microsoft VBScript runtime error '800a01a8'
> > Object required: ''
> >
> > /study/bible/biblesearch/Biblesearch.asp, line 88
> >
> > Hope this information will help you.
> >
> >
> >
> > "Rev. Michael Kujawa" <sdkngfksdnf> wrote in message
> > news:ukrKl4KWEHA.3472@TK2MSFTNGP09.phx.gbl...
> > > Never mind figured out the formatting procedure
> > >
> > >
> >
> >
>
>


Top