Hi Try [Client Last Name]
HTH Chamindu --- "Dian D. Chapman" <[EMAIL PROTECTED]> wrote: > > Would someone please be so kind to tell me how to > handle a field name with > spaces!<sigh> > > I'm trying to connect to a client's DB and they used > spaces in their field > names. I've tried a dozen combinations and I keep > getting a syntax error. > > gstrSQLQuery = "SELECT * FROM tbl_client WHERE > Client Last Name = '" & > strLName & "'" > > I end up with > > Run-time error '-2147217900 (80040e14)': > > Syntax error (missing operator) in query > expression 'Client Last Name = > 'chapman''. > > I've tried quotes all over the place and can't get > the @#$%^! thing right. > > TIA... > Dian ~ > > > > -- > This email scanned and certified clean by AVG! > Checked by AVG Anti-Virus. > Version: 7.0.308 / Virus Database: 266.7.3 - Release > Date: 3/15/2005 > > > > > --------------------------------------------------------------------- > > Home : > http://groups.yahoo.com/group/active-server-pages > --------------------------------------------------------------------- > Post : [email protected] > Subscribe : > [EMAIL PROTECTED] > Unsubscribe: > [EMAIL PROTECTED] > --------------------------------------------------------------------- > > Yahoo! Groups Links > > http://groups.yahoo.com/group/active-server-pages/ > > [EMAIL PROTECTED] > > > > > > __________________________________ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/ --------------------------------------------------------------------- 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/
