Error: SQL not supported

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 37325
interpreted = N
texte = HiI have set up a machine running FileMaker5.5 on a Mac as a data source which I can now read and write to via ODBC from my PC - so far so good.I have set up a DSN on my web server which is a Mac and using FileMaker as a client on it I can read and write to the database as expected - again so far so good.I tried to get WebCatalog to extract some data from the FileMaker database using the SQL commands as per attached and I get an error saying Error:SQL not supported. Am I doing this all wrong, have I missed something?Any help much appreciated - my code is as follows (no user name is needed by FileMaker)[SQL dsn=AsylumFM&password=mypassword&statement=SELECT * from WWWJOB] Found [NumFound] items
[FoundItems] [Division], [Location], [Job_Id]
[/FoundItems] [/SQL]Thanks ======================================== Steve Craig - Asylum Interactive Ltd Tel +44 1224 642960 Fax +44 1224 642962 ======================================== http://www.asylumweb.com Email: steve@asylumweb.com ======================================== ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. ODBC Error: SQL not supported ( Alexander Kulak 2005)
  2. Re: Error: SQL not supported (Bjørn Are Solstad 2001)
  3. Error: SQL not supported (Steve Craig 2001)
HiI have set up a machine running FileMaker5.5 on a Mac as a data source which I can now read and write to via ODBC from my PC - so far so good.I have set up a DSN on my web server which is a Mac and using FileMaker as a client on it I can read and write to the database as expected - again so far so good.I tried to get WebCatalog to extract some data from the FileMaker database using the SQL commands as per attached and I get an error saying Error:SQL not supported. Am I doing this all wrong, have I missed something?Any help much appreciated - my code is as follows (no user name is needed by FileMaker)[SQL dsn=AsylumFM&password=mypassword&statement=SELECT * from WWWJOB] Found [NumFound] items
[founditems] [Division], [Location], [Job_Id]
[/FoundItems] [/SQL]Thanks ======================================== Steve Craig - Asylum Interactive Ltd Tel +44 1224 642960 Fax +44 1224 642962 ======================================== http://www.asylumweb.com Email: steve@asylumweb.com ======================================== ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Steve Craig

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

Add a Blog to your site. (2002) PIXO support (1997) date formatting for CC card expiration date check (1998) WebCatalog NT beta 18 now available (1997) [WebDNA] User sessions - cookies only or cookies and a sessions.db? (2016) chat opinion ... (2002) Unique SKU Numbers (2000) Snake Bites (1997) Fixed: Problem getting shipping to calculate (2003) Replace context (1998) FORMS: Returning a specific page (1997) Searching multiple Databases (1997) WebCat2 beta 11 - new prefs ... (1997) Pithy questions on webcommerce & siteedit (1997) WebCat2.0 [format thousands .0f] no go (1997) WebCat2: Items xx to xx shown, etc. (1997) popups, netscape vs explorer (1997) I am sorry for always being such an a## (2004) WC TableGrinder (1997) Replace Statement (1997)