On Tue 14 Dec 2004 18:21, Ricardo SIGNES <[EMAIL PROTECTED]> wrote:
> * "H.Merijn Brand" <[EMAIL PROTECTED]> [2004-12-14T11:28:19]
> > About spaces, another thing springs to mind, for which I would gladly kill
> > the
> > responsible people to allow it (I bet M$ was the first to push it): Spaces
> > in
> > database table and field names. DON'T! NEVER! Once you start it, you will
> > never be able to escape the quicksands of (incompatible) quotation and
> > unportability of your scripts, be that in sql, sh, perl/dbi, hli, or e/sql
>
> SELECT rsUniqueId
> FROM [SQL-ABCdatabase2K]..tblsTABLE as t
> JOIN [SQL-ABCdatabase2K]..tblwPRODUCT p ON p."ABC P/N" = t.rsProductCode
> WHERE p.id IN (SELECT ItemIdentifier FROM tblSomeIds)
Just only today I hit an M$Access database with a table named
`./onderw`.`"Bus"; "Taxi"; "Auto"`
Ahhhhhhrg!
/me runs for cover!
--
H.Merijn Brand Amsterdam Perl Mongers (http://amsterdam.pm.org/)
using perl-5.6.1, 5.8.5, & 5.9.x, and 809 on HP-UX 10.20 & 11.00, 11i,
AIX 4.3, AIX 5.2, SuSE 9.1, and Win2k. http://www.cmve.net/~merijn/
http:[EMAIL PROTECTED]/ [EMAIL PROTECTED]
send smoke reports to: [EMAIL PROTECTED], QA: http://qa.perl.org
