Dan No problem from windows. Are you sure it is not a timestamp? I searched a timestamp with no problem.
I also tested a 350000 record database and searched for a date field with no problem either. You can contact me off line if you want more info or need help. I only did windows testing. on 3/28/06 3:57, Dan Urlich at [EMAIL PROTECTED] wrote: > I gave up on JDBC and am now connecting via ODBC ... > > The main problem I have now is that any dates fields seem to cause an > SQL error when searching. If I change the date fields to text > everything is OK. > > Has anyone been able to search on date fields with Filemaker 8 > Advanced Server and Witango 5.0? > > For now I have created a calculation field that I can use to sort by: > Year ( insert_date ) & "-" & Month ( insert_date ) & "-" & Day ( > insert_date ) > > (Witango server - MacOSX Server 10.3.9) > > cheers, > > dan > > > At 15:20 -0500 14.03.2006, John May wrote: >> I know I've gotten JDBC and ODBC connections to FMSA on OS X before, >> though I don't have time to re-work out the specifics right now. >> >> - John >> >>> Dan is there a reason you can't use ODBC? At least I have seen that one work >>> although then you will want 10.4 or at least to install the latest drivers. >>> >>> >>> So far no takers on people using JDBC from the FSA list I'll try my FMI SE >>> see if he has any ideas. >>> >>> on 3/14/06 10:56, Dan Urlich at [EMAIL PROTECTED] wrote: >>> >>>> >>>> Hi Dan, >>>> At 10:46 -0500 14.03.2006, Dan Stein wrote: >>>>> Dan, >>>>> >>>>> I will try and get you definitive install instructions. I think you will >>>>> find this would work better on 10.4x but I will check for you. >>>> >>>> Great - looking forward to that. >>>> >>>>> >>>>> As I have said before this is all much much easier to do on a Windows box >>>>> then Mac. You FMSA comes with both licenses so you should at least think >>>>> about it. >>>>> >>>>> The setup speed and functionality is just plain better on windows Server >>>>> 2003 >>>> >>>> I have no choice but to use the MacOS X 10.3.9 server at the moment >>>> and we only have a Mac Witango server license. >>>> >>>> Cheers, >>>> >>>> Dan >>>> >>>>> >>>>> >>>>> on 3/14/06 10:27, Dan Urlich at [EMAIL PROTECTED] wrote: >>>>> >>>>>> Hi, >>>>>> >>>>>> I am trying for the first time to connect to Filemaker 8 Server >>>>>> Advanced via JDBC. Testing with MacOS X 10.4.5 client but I will >>>>>> deploy on 10.3.9 Server. I have installed the JDBC Client Driver >>>>>> into "/Library/Java/Extensions/". >>>>>> >>>>>> I get a "No suitable driver" error message. >>>>>> >>>>>> Any ideas? >>>>>> >>>>>> Thanks, >>>>>> >>>>>> Dan >>>>>> >>>>>> >>>>>> >>>>>> ________________________________________________________________________ >>>>>> TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf >>>>>> >>>>> >>>>> -- >>>>> Dan Stein >>>>> FileMaker 7 Certified Developer >>>>> Digital Software Solutions >>>>> 799 Evergreen Circle >>>>> Telford PA 18969 >>>>> Land: 215-799-0192 >>>>> Cell: 610-256-2843 >>>>> Fax 413-410-9682 >>>>> FMP, WiTango, EDI,SQL 2000, MySQL, CWP >>>>> [EMAIL PROTECTED] >>>>> www.dss-db.com >>>>> >>>>> >>>>> "There is a larger frame to the painting than the one that bounds our >>>>> life's events." >> >> -- >> >> ------------------------------------------------------------------- >> John May : President <http://www.pointinspace.com> >> Point In Space Internet Solutions [EMAIL PROTECTED] >> >> Professional Lasso / PHP / MySQL / FileMaker Pro Hosting >> >> ________________________________________________________________________ >> TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > -- Dan Stein FileMaker 7 Certified Developer Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Cell: 610-256-2843 Fax 413-410-9682 FMP, WiTango, EDI,SQL 2000, MySQL, CWP [EMAIL PROTECTED] www.dss-db.com 'I wonder why we say that people are of different "races". It seems to me, we're all running at the same speed and heading towards the same destination. The only "winners" are the ones who've made the world a better place for having been here.' >From for Better or Worse 2/28/2006 ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
