Links

Lists

Latest Updates

Ruby On Rails List
Python list
Advanced Java
The JavaScript List
Apache Users
Full Disclosure
Linux Security

Search the archives!


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

jdbc: tables/columns with hypens?


  • From: mail21193@xxxxxxx (Joel Riedesel)
  • Subject: jdbc: tables/columns with hypens?
  • Date: Mon, 30 Aug 1999 08:15:47 -0600

(Couldn't find a jdbc list real quick, if there is one, please
point me toward it.)

Is it legal to have table or column names with hypens in them?

And if so, how does one reliably generate a query for them:

  select foo-1.customer from foo-1

I don't think hyphens are generally a good thing in SQL names, but
I've run into this particular problem when using MS Access.
(Trying to use a '\' to quote the hyphen seems to only generate a syntax
error as well...)

Thanks.

-- 
Joel Riedesel
Jnana Technologies Corporation
mailto:jriedese@xxxxxxxxx
303 805 8275