badjao
|
| Posted: 06/27/2003, 1:33 AM |
|
is it possible to do this SELECT * FROM couneduc
WHERE PID IN (#PreserveSingleQuotes(FORM.S_PID)#) with code charge and coldfusion?
i have a form with checkboxes i want my grid to return all the rows that match the PID's of the values in checkbox and send a request like this one.
http://localhost/phil/?S_pid='023100000','021500000'
|
|
|
 |
rrodgers
|
| Posted: 06/27/2003, 3:06 PM |
|
You don't say what you are using.
In CCS/ASP I add an code to the event BeforeBuildSelect
dim s
s = PlayerSearch.s_TeamSysID.Datasource.Where
If Len(Trim(s)) > 0 Then
s = "(" & s & ") AND "
End IF
s = s & " Mycolumn in ( " & xInStmt & ")"
PlayerSearch.s_TeamSysID.Datasource.Where = s
|
|
|
|
badjao
|
| Posted: 06/29/2003, 7:29 PM |
|
i'm using coldfusion can anyone help me out?
|
|
|
|
|
