You can't use []? Hm. Your syntax looks right to me, if you need to get " in there. But, do you really want to have a space before and after Item DB?
sSQL = "SELECT * FROM ""ITEM DB"" WHERE...." perhaps? Ray at work > -----Original Message----- > From: [email protected] > [mailto:[EMAIL PROTECTED] On Behalf Of > Mills, Andy R. (Regency) > Sent: Wednesday, May 11, 2005 10:24 AM > 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 > > > > > > > --------------------------------------------------------------------- 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/
