Could this be the !CST error? I don't use Mac for witango so not sure. What happens if you query just a plain date field don't try to do any formating of the query jsut let it run as is. What is the field name? What version of FMSA? ---- <[email protected]> wrote: > > Hi, > > At 11:00 -0500 28.03.2006, Dan Stein wrote: > >Dan No problem from windows. Are you sure it is not a timestamp? I searched > >a timestamp with no problem. > > [DataDirect][ODBC SequeLink driver]Unable to convert column 9. Cannot > convert from SQL type 91 to C type 9. > 07006 > > COLUMN 9 is a date field %d.%m.%Y > > Cheers, > > dan > > > > > >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 > > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > >
-- Dan Stein MSN Certified FileMaker 7 Developer Digital Software Solution, LLC 799 Evergreen Circle 215-799-0192 610-256-2843 ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
