I have a record with a field containing "2h", another record containing 2h Sa , I would like to search for all records, where the field contains the text 2h.
If I choose "in" as fixed operator and 2h in the search form field 1, I only get those records containing exact 2h. If I use the Fix operator "on one them" or "Like" and still 2h in the form field 1, I get NOTHING!
'**************************
' Advanced Search
' http://www.DwZone-it.com
' Version: 2.0.21
'**************************
dim dwzSearch_1
set dwzSearch_1 = new dwzSearch
dwzSearch_1.Init
dwzSearch_1.SetFormName "form1"
dwzSearch_1.SetSubmitName "knp_vis"
dwzSearch_1.SetBooleanValue "1 / 0"
dwzSearch_1.SetJollyChar "*_@@_None_@@_true"
dwzSearch_1.AddFilter "hold1", "In", "", "var_klasse", "", "S", "0"
dwzSearch_1.AddFilter "afrejsedag", "Between", "", "var_start", "var_til ", "S", "0"
dwzSearch_1.SetRecordset rs_pris
dwzSearch_1.SetCommand rs_pris_cmd
dwzSearch_1.Create()
if dwzSearch_1.HasFilter() then
dwzSearch_1.FilterRecordset rs_pris
end if
'**************************
' Advanced Search
' End code
'**************************
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Login
Unread message![Read message [popular]](http://forum.dwzone-it.com/template/subSilver/images/folder_hot.gif)
Read message [popular] ![Unread message [popular]](http://forum.dwzone-it.com/template/subSilver/images/folder_new_hot.gif)
Unread message [popular]![Read message [locked]](http://forum.dwzone-it.com/template/subSilver/images/folder_lock.gif)
Read message [locked] ![Unread message [locked]](http://forum.dwzone-it.com/template/subSilver/images/folder_lock_new.gif)
Unread message [locked]