proasp_codeclinic thread: using whitespace in table names in SQL select statements
1. never SELECT *
-list out the field names
2. use  around your table/fieldnames
sql = "select [fld1] from [Breast Surgery]"
At 08:01 AM 12/26/2001 +0000, you wrote:
>Need a present for your favorite programmer?
>E-Documents from Amazon.com at http://p2p.wrox.com/edocs.asp
>I'm using this query string
>mySqlQuery = "SELECT * FROM 'Breast Surgery'";
>to access the data in a table called Breast Surgery - with whitespace.
>Its throwing an error though, and I don't know why
>Can anyone help out?
Author and Developer