Oh yeah. C#. Ignore my post please. Ray at work
> -----Original Message----- > From: [email protected] > [mailto:[EMAIL PROTECTED] On Behalf Of > Adrian Forbes - ITD > Sent: Wednesday, May 11, 2005 10:29 AM > To: [email protected] > Subject: RE: [ASP] Double Quotes > > > 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 > > > > > > > --------------------------------------------------------------------- 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/
