Re: [saxon] SQL extension: querying tables with bad defined names
|
From: Huditsch, Roman \(LNG-VIE\) <Roman.Huditsch@le...> - 2009-04-27 14:53:25
|
Hi michael, Thanks a lot for the hint with the square brackets. I'll try to find out about the jdbc treatment of those tables tomorrow morning. Thanks, Roman -------------------------- Sent from my BlackBerry Wireless Device ----- Originalnachricht ----- Von: Michael Kay <mike@...> An: 'Mailing list for the SAXON XSLT and XQuery processor' <saxon-help@...> Gesendet: Mon Apr 27 16:32:38 2009 Betreff: Re: [saxon] SQL extension: querying tables with bad defined names I don't know what JDBC does with such table names. IIRC the convention in MS Access is to enclose the name between square brackets. If you can find out how JDBC handles it, it should be easy enough to work out how to deal with it at the Saxon level. Michael Kay http://www.saxonica.com/ > Mag. (FH) Roman Huditsch Teamleader XSLT-Development Tel.: +43 (1) 534 52 - 1514 Fax: +43 (1) 534 52 - 146 Roman.Huditsch@... LexisNexis Verlag ARD Orac GmbH & Co KG Marxergasse 25, 1030 Wien FN 8333f, Handelsgericht Wien http://www.lexisnexis.at/ -----Original Message----- > From: Huditsch, Roman (LNG-VIE) [mailto:Roman.Huditsch@...] > Sent: 27 April 2009 15:03 > To: Mailing list for SAXON XSLT queries > Subject: [saxon] SQL extension: querying tables with bad defined names > > Hi, > > I need to do set up a connection to an Access database in my > stylesheet, which works fine. > Querying the database with > > <sql:query connection="$connection" table="'Grundtabelle mit > Primärschlüssel'" column="*" where="'az zusammen' LIKE '%{.}%'"/> > > gives me the error "syntax error in query. The query is > incomplete" (free translation ;)) > > I suppose that there is an issue with the spaces in the col > and table name. > Omitting the '' in @table results in an "error in FROM > clause" error, which seems logical to me. > > Unfortunately, I can't alter the names of this - in my > opinion badly designed - db. > > Is there a way to get my query to work as expected? > > Thanks, > Roman > > Mag. (FH) Roman Huditsch > Teamleader XSLT-Development > > Tel.: +43 (1) 534 52 - 1514 > Fax: +43 (1) 534 52 - 146 > > Roman.Huditsch@... > > LexisNexis Verlag ARD Orac GmbH & Co KG > Marxergasse 25, 1030 Wien > FN 8333f, Handelsgericht Wien > http://www.lexisnexis.at/ > > > > > > -------------------------------------------------------------- > ---------------- > Crystal Reports - New Free Runtime and 30 Day Trial Check > out the new simplified licensign option that enables > unlimited royalty-free distribution of the report engine > for externally facing server and web deployment. > http://p.sf.net/sfu/businessobjects > _______________________________________________ > saxon-help mailing list archived at > http://saxon.markmail.org/ saxon-help@... > https://lists.sourceforge.net/lists/listinfo/saxon-help ------------------------------------------------------------------------------ Crystal Reports - New Free Runtime and 30 Day Trial Check out the new simplified licensign option that enables unlimited royalty-free distribution of the report engine for externally facing server and web deployment. http://p.sf.net/sfu/businessobjects _______________________________________________ saxon-help mailing list archived at http://saxon.markmail.org/ saxon-help@... https://lists.sourceforge.net/lists/listinfo/saxon-help |