ASP search script

[JynX78]

Can anyone point me in the direction of an asp search that searches sql databases? I'm looking for one uses two mandatory and one optional text field and returns the results.

[steelhand]

<%

Dim connectionSQL

Dim recordsetSQL

Dim strinSQL

stringSQL = "SELECT * " & _

"FROM [table] " & _

"WHERE [column1] = '" & Request.Form("textbox1"' " & _

"AND [column2] = '" & Request.Form("textbox2"' "

If Request.Form("textbox3 "" Then

stringSQL = stringSQL & "AND [column3] = '" & Request.Form("textbox3"' "

End If

Set connectionSQL = Server.CreateObject("ADODB.Connection")

connecSQL.Open "some connection string"

Set recordsetSQL = connectionSQL.Execute(stringSQL)

%>

[JynX78]

  steelhand said:

<%

Dim connectionSQL

Dim recordsetSQL

Dim strinSQL

stringSQL = "SELECT * " & _

? ? ? ? ? ? ? ? ? ? ? "FROM [table] " & _

? ? ? ? ? ? ? ? ? ? ? "WHERE [column1] = '" & Request.Form("textbox1"' " & _

? ? ? ? ? ? ? ? ? ? ? "AND [column2] = '" & Request.Form("textbox2"' "

If Request.Form("textbox3 "" Then

? ? ? stringSQL = stringSQL & "AND [column3] = '" & Request.Form("textbox3"' "

End If

Set connectionSQL = Server.CreateObject("ADODB.Connection")

connecSQL.Open "some connection string"

Set recordsetSQL = connectionSQL.Execute(stringSQL)

%>

585238334[/snapback]

can this be used with a udl

[steelhand]

Yes the connection is irrelevant really. As long as you instantiate the connection object it's fine.