|
 |
asp_databases thread: using whitespace in table names in SQL statements
Message #1 by "Ken Shaw" <kenprogac@h...> on Wed, 26 Dec 2001 07:54:00
|
|
Hi,
my SQL query is
mySqlQuery = "SELECT * FROM 'Breast Surgery'"; and this is returning an
error. I'm just wondering why this is?
Cheers,
Ken Shaw Jnr
Message #2 by Kyle Burns <kburns@c...> on Wed, 26 Dec 2001 07:36:56 -0500
|
|
Try using SELECT * FROM [Breast Surgery]. This should clear the error.
=================================
Kyle M. Burns, MCSD, MCT
ECommerce Technology Manager
Centra Credit Union
kburns@c...
>> -----Original Message-----
>> From: Ken Shaw [mailto:kenprogac@h...]
>> Sent: Wednesday, December 26, 2001 2:54 AM
>> To: ASP Databases
>> Subject: [asp_databases] using whitespace in table names in SQL
>> statements
>>
>>
>> ---
>> Need a present for your favorite programmer?
>> E-Documents from Amazon.com at http://p2p.wrox.com/edocs.asp
>> ---
>> Hi,
>> my SQL query is
>> mySqlQuery = "SELECT * FROM 'Breast Surgery'"; and this is
>> returning an
>> error. I'm just wondering why this is?
>>
>> Cheers,
>>
>> Ken Shaw Jnr
>> $subst('Email.Unsub').
>>
Message #3 by "Drew, Ron" <RDrew@B...> on Wed, 26 Dec 2001 10:09:23 -0500
|
|
Try
mySqlQuery =3D "SELECT * FROM [Breast Surgery];"
-----Original Message-----
From: Ken Shaw [mailto:kenprogac@h...]
Sent: Wednesday, December 26, 2001 2:54 AM
To: ASP Databases
Subject: [asp_databases] using whitespace in table names in SQL
statements
---
Need a present for your favorite programmer?
E-Documents from Amazon.com at http://p2p.wrox.com/edocs.asp
---
Hi,
my SQL query is
mySqlQuery =3D "SELECT * FROM 'Breast Surgery'"; and this is returning
an
error. I'm just wondering why this is?
Cheers,
Ken Shaw Jnr
$subst('Email.Unsub').
Message #4 by "tan siewwei" <swtan78@h...> on Thu, 27 Dec 2001 02:28:24
|
|
I think it cannot have space between the table name ... or u can use the
underscore to join the two words. ... hope it is correct ... ok
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.
Message #5 by "Kim Iwan Hansen" <kimiwan@k...> on Thu, 27 Dec 2001 09:06:07 +0100
|
|
you *can* have spaces in the table and field names, you just need to put []
around them in your queries.
-Kim
> -----Original Message-----
> From: tan siewwei [mailto:swtan78@h...]
> Sent: 27. december 2001 02:28
> To: ASP Databases
> Subject: [asp_databases] Re: using whitespace in table names in SQL
> statements
>
> I think it cannot have space between the table name ... or u can use the
> underscore to join the two words. ... hope it is correct ... ok
|
|
|
View Cart
