Forma ASP kai database

Από {dayrise.gr}

well, enwsh twn pediwn ginetai etsi
srch1 = Replace(Request.Form("D1"), "'", "''") & Replace(Request.Form("D2"), "'", "''") & Replace(Request.Form("D3"), "'", "''")

Twra exw allh erwthsh....

thelw na elegxo ena checkbox an einai checked h oxi kai me vash me auto na ektelw mia h allh erwthsh SQL

'pairnoume stoixeia apo to checkbox
srch4 = Replace(Request.Form("srch4"), "'", "''")

'Έλεγχος για την επιλογή του checkbox. Αν ναι τότε ψάχνουμε όλα τα πεδία...
If oRS("srch4") = 1 Then
SQL = "Select * From flights Where City1 Like '%"&srch&"%' AND City2 Like '%"&srch2&"%'"
Else
SQL = "Select * From flights Where City1 Like '%"&srch&"%' AND City2 Like '%"&srch2&"%' AND Date Like '%"&srch3&"%'"
End If

Den douleuei omws... Uparxei kanena lathos se ola ta parapanw?