How to create this simple string?

[Miguel Dias Moura]

Hello,

I am working on ASP.NET/VB. I have this string:
Dim keywords() As String =
Request.QueryString("search").Split(CChar(""))

Now I want to define a new string like this:
keywordsSQL = CONTAINS (*, 'keyword(1)') AND CONTAINS (*, 'keyword(2)')
AND ... CONTAINS (*, 'keyword(i)')

keyword(1) and keyword(i) are the first and last values in keywords().

How can I do this?

Thanks,
Miguel

[Jiri Zidek]

dim first as string = keywords(0)
dim last as string = keywords( keywords.Length - 1)

just an idea

Pazu

"Miguel Dias Moura" <md*REMOVE*moura@*NOSPAM*gmail.com> píse v diskusním
príspevku news:%2****************@TK2MSFTNGP15.phx.gbl...

Hello,

I am working on ASP.NET/VB. I have this string:
Dim keywords() As String = Request.QueryString("search").Split(CChar(""))

Now I want to define a new string like this:
keywordsSQL = CONTAINS (*, 'keyword(1)') AND CONTAINS (*, 'keyword(2)')
AND ... CONTAINS (*, 'keyword(i)')

keyword(1) and keyword(i) are the first and last values in keywords().

How can I do this?

Thanks,
Miguel

[Kevin Spencer]

You're creating an array of keywords. You want to concatentate conditions
into your SQL with them, so, you need to create a loop that loops through
the array ands adds conditions to the string.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Neither a follower
nor a lender be.

"Miguel Dias Moura" <md*REMOVE*moura@*NOSPAM*gmail.com> wrote in message
news:#z**************@TK2MSFTNGP15.phx.gbl...

Hello,

I am working on ASP.NET/VB. I have this string:
Dim keywords() As String =
Request.QueryString("search").Split(CChar(""))

Now I want to define a new string like this:
keywordsSQL = CONTAINS (*, 'keyword(1)') AND CONTAINS (*, 'keyword(2)')
AND ... CONTAINS (*, 'keyword(i)')

keyword(1) and keyword(i) are the first and last values in keywords().

How can I do this?

Thanks,
Miguel

[Lucas Tam]

"Miguel Dias Moura" <md*REMOVE*moura@*NOSPAM*gmail.com> wrote in news:
#z**************@TK2MSFTNGP15.phx.gbl:

I am working on ASP.NET/VB. I have this string:
Dim keywords() As String =
Request.QueryString("search").Split(CChar(""))

Now I want to define a new string like this:
keywordsSQL = CONTAINS (*, 'keyword(1)') AND CONTAINS (*, 'keyword(2)')
AND ... CONTAINS (*, 'keyword(i)')

keyword(1) and keyword(i) are the first and last values in keywords().

How can I do this?

Take a look at SQL Parameters... they're great for what you're doing.

--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/