[DB-SIG] RE: SQL Query Help

Ryan Weisenberger ryanw@inktomi.com
Thu, 08 Mar 2001 10:52:06 -0800

Thanks everyone for your replies!  The double quotes did the trick.

- Ryan

>Does anyone know how to get at tables with spaces in the name?  The 
>Microsoft SQL Server 2000 demo database is loaded with tables with names 
>like "Order Details".
>I've tried a few combinations:
>c.execute("select * from order details")
>c.execute("select * from order-details")
>c.execute("select * from order_details")
>c.execute("select * from 'order details'")
>c.execute("select * from order%20details")
>All of these return a syntax error from the SQL parser.
>Does anyone know the correct syntax for this?
>- Ryan