p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

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




  Return to Index