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

 

[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.

 

[Lucas Tam]

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.