DwZone Forum DwZone Forum
Welcome to the DwZone-it Forum
 
  FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups  
    RegisterRegister -->   LoginLogin  
Advanced Search  
DwZone Forum Index -> Advanced Search
.
Moderators: AdministratorsModerators 
Hint: For improved responsiveness, use Internet Explorer 4 (or above) with Javascript enabled, choose 'Dynamic' from the View dropdown and hit 'Set Options' to save your changes.
New Topic Search for
 View     Per page     Messages Since 
Messages 11 to 20 of 40 (Total: 40) First |  Prev |  Next |  Last  
 Subject Author Date  
   Re: Advanced search and PHP Import Export  
View this persons public profile  Randy   8:17 20 Dec 2016  
   Re: Advanced search and PHP Import Export  
View this persons public profile  Gianluigi   10:03 20 Dec 2016  
   Re: Advanced search and PHP Import Export  
View this persons public profile  Randy   10:09 20 Dec 2016  
   can't get a void recordset to show  
View this persons public profile  Randy   19:11 15 Dec 2016  
   Re: can't get a void recordset to show  
View this persons public profile  Gianluigi   10:05 16 Dec 2016  
   On void result display custom message  
View this persons public profile  KamleshPanchal   22:10 29 Aug 2016  
   Re: On void result display custom message  
View this persons public profile  KamleshPanchal   2:02 30 Aug 2016  
   Re: On void result display custom message  
View this persons public profile  Gianluigi   11:02 30 Aug 2016  
    find part of a text in a field  
View this persons public profile  Johnny Odgaard   3:36 18 Jul 2016  
 
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
'**************************

 
Reply to this current thread  View this persons public profile  Send Private Message
   Re: find part of a text in a field  
View this persons public profile  Gianluigi   9:45 18 Jul 2016  
Last Visit: Saturday 20 Apr, 2024 8:57 am First |  Prev |  Next |  Last  
 Login
Username:  Password:    
Read Message Read Message   Unread message Unread message
Read message [popular] Read message [popular]   Unread message [popular] Unread message [popular]
Read message [locked] Read message [locked]   Unread message [locked] Unread message [locked]
All times are GMT-2

Jump to: