Re: Error: SQL not supported

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 37358
interpreted = N
texte = I can see you have not provided a username in the code snippet. Any reason for that?>Hi > >I 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/-- -- Bjørn Are Solstad - Web developer SYSteam Norge as - http://www.systeam.noDir. Tel.: 23 17 29 81. Mob.: 40 40 11 05WebCatalog development and hosting. ------------------------------------------------------------- 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)
I can see you have not provided a username in the code snippet. Any reason for that?>Hi > >I 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/-- -- Bjørn Are Solstad - Web developer SYSteam Norge as - http://www.systeam.noDir. Tel.: 23 17 29 81. Mob.: 40 40 11 05WebCatalog development and hosting. ------------------------------------------------------------- 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/ Bjørn Are Solstad

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:

Browser Info.txt (1997) New to WebCat, Help. (1998) can WC render sites out? (1997) P1: How to make webcatalog more stable. - LONG (1999) WebCat2_Mac RETURNs in .db (1997) OT: Please set your computer's clock (1997) [format 40s]text[/format] doesn't work (1997) headers (2000) [WebDNA] macOS 10.13.3 and WebDNA Mac Server 8.5.1 - hick-up (2019) Stopping bad HTML propagation ? (1997) sort problems....bug or brain fart? (1997) Form Variables (2000) Large databases in WebCat (1997) read and write you own cookies with webcat (1997) Stupid question (2003) emailer (1997) search for all (1998) About the cache management in Webstar V, under OS X (2002) WebCat2b12 - nesting [tags] (1997) Applescript, WebDNA, and PDF (1997)