Title: RE: [Jdbforms-developers] searchfields

Hi all,

That looks really good..  I played around with some older search code that was for dbforms that had the same basic ideas, but this looks much better.  What I would love to see is some good sample code when you commit to CVS...

+1

Eric Pugh

-----Original Message-----
From: Henner Kollmann [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 16, 2002 3:42 AM
To: [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: [Jdbforms-developers] searchfields


Hi all,

Let' s start the discussion about extending the search fields!

I have made the following extensions:

1. SQL like is not allowed for others than char fields. So i disable
SEARCH_ALGO_WEAK for other fields.
2. Extend the searching in not char fields with:
    != value            results in   where fieldname <> value
    <> value            results in   where fieldname <> value   
    < value             results in   where fieldname < value    
    <= value            results in   where fieldname <= value   
    > value             results in   where fieldname > value     
    >= value            results in   where fieldname >= value       
    value1-value2       results in   where (fieldname >= value1) and
(fieldname <= value2)
    value1-             results in   where (fieldname >= value1)
          -value2       results in   where (fieldname <= value2)  
   This works for numeric, date, timestamp fields!

Any suggestions?
Should i submit this changes to the CVS?


Regards,
Henner Kollmann



-------------------------------------------------------
This sf.net email is sponsored by: viaVerio will pay you up to
$1,000 for every account that you consolidate with us.
http://ad.doubleclick.net/clk;4749864;7604308;v?
http://www.viaverio.com/consolidator/osdn.cfm
_______________________________________________
Jdbforms-developers mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jdbforms-developers

Reply via email to