Thanks! And yes, I'm totally anal retentive when it comes to writing code, too! ;-)
But more importantly, much of what I do is code that is sold to clients in the end in open format so they can learn and enhance in the future if they want. So I have to add a lot of detailed comments and have to avoid lots of shortcuts as part of the training process is that newbies will need to read, understand and learn from what I've written. Dian ~ -----Original Message----- From: David Smart [mailto:[EMAIL PROTECTED] Sent: Saturday, March 19, 2005 8:25 PM To: [email protected] Subject: Re: [ASP] Arrgghhh...quotes again! Yeah make that 1,000,001 style rules you're now remembering. :-) I quite like the end effect of doing this in SQL anyway. It emphasises where the field names are - as distinct from the data - particularly as the bozos that designed the SQL statement syntax couldn't arrive at a consistent format (compare the insert statement field/data list to the update statement field/data list for a "hmmm" moment). I place huge emphasis on having and using a consistent programming style. It probably means that I don't write code as quickly as some, but I sure debug it faster than anyone else I know (partly because my code is readable and laid out carefully, and partly because I create fewer bugs in the first place). Dave S ----- Original Message ----- From: "Dian D. Chapman" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Sunday, March 20, 2005 12:41 PM Subject: RE: [ASP] Arrgghhh...quotes again! > > Thanks, David...good idea...I'll do that. (What's one more syntax > consideration at this point, eh?<g>) > > Dian ~ > > > > > -----Original Message----- > From: David Smart [mailto:[EMAIL PROTECTED] > Sent: Friday, March 18, 2005 3:39 AM > To: [email protected] > Subject: Re: [ASP] Arrgghhh...quotes again! > > > Square brackets. > > Actually, you should be using them around every field name, whether it has > spaces or not. It's a good habit to get into. As well as spaces, it'll > protect you against problems where field names are the same as keywords. > > > gstrSQLQuery = "SELECT * FROM [tbl_client] WHERE [Client Last Name] = '" & > > strLName & "'" > > > Dave S > > ----- Original Message ----- > From: "Dian D. Chapman" <[EMAIL PROTECTED]> > To: "Group - ASP" <[email protected]> > Sent: Friday, March 18, 2005 6:08 PM > Subject: [ASP] Arrgghhh...quotes again! > > > > > > 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 ~ > > > > > > --------------------------------------------------------------------- > Home : http://groups.yahoo.com/group/active-server-pages > --------------------------------------------------------------------- > Post : [email protected] > Subscribe : [EMAIL PROTECTED] > Unsubscribe: [EMAIL PROTECTED] > --------------------------------------------------------------------- > Yahoo! Groups Links > > > > > > > > > -- > No virus found in this incoming message. > Checked by AVG Anti-Virus. > Version: 7.0.308 / Virus Database: 266.7.3 - Release Date: 3/15/2005 > > > -- > 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 > > > > > > > > --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [email protected] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.3 - Release Date: 3/15/2005 -- 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 <*> 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/
