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 whichI 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 aclient on it I can read and write to the database as expected - again so farso good.I tried to get WebCatalog to extract some data from the FileMaker databaseusing the SQL commands as per attached and I get an error saying Error:SQLnot 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 byFileMaker)[SQL dsn=AsylumFM&password=mypassword&statement=SELECT * from WWWJOB]Found [NumFound] items
[FoundItems][Division], [Location], [Job_Id]
[/FoundItems][/SQL]Thanks========================================Steve Craig - Asylum Interactive LtdTel +44 1224 642960 Fax +44 1224 642962========================================http://www.asylumweb.comEmail: 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:
HiI have set up a machine running FileMaker5.5 on a Mac as a data source whichI 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 aclient on it I can read and write to the database as expected - again so farso good.I tried to get WebCatalog to extract some data from the FileMaker databaseusing the SQL commands as per attached and I get an error saying Error:SQLnot 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 byFileMaker)[SQL dsn=AsylumFM&password=mypassword&statement=SELECT * from WWWJOB]Found [NumFound] items
[founditems][Division], [Location], [Job_Id]
[/FoundItems][/SQL]Thanks========================================Steve Craig - Asylum Interactive LtdTel +44 1224 642960 Fax +44 1224 642962========================================http://www.asylumweb.comEmail: 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)