You show a quote literal by \" sSQL = "SELECT * FROM \"Item DB\" WHERE Item = '" + sItemNumber + "'";
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Mills, Andy R. (Regency) Sent: 11 May 2005 3:24 To: '[email protected]' Subject: [ASP] Double Quotes Hello Guys: I need to get double quotes around Item DB, but just can't get the syntax correct. I am using C# in an ASPX page. I know: shouldn't use spaces in a database table name, but unfortunately: I inherited this application. Because it is an ASCII / Pervasive connection, I can't use the traditional [ ] around Item DB. sSQL = "SELECT * FROM "" Item DB "" WHERE Item = '" + sItemNumber + "'"; Thanks Andy Mills Programmer Regency Thermographers 717-765-3572 <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] http://www.regencythermo.com <http://www.regencythermo.com/> [Non-text portions of this message have been removed] --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [email protected] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links The contents of this email and any attachments are sent for the personal attention of the addressee(s) only and may be confidential. If you are not the intended addressee, any use, disclosure or copying of this email and any attachments is unauthorised - please notify the sender by return and delete the message. Any representations or commitments expressed in this email are subject to contract. ntl Group Limited --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [email protected] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
