RE: Varaible Names with "-"

2001-01-17 Thread Katrina Chapman
Merry Meet Troy, Have you tried aliasing the column name. IE: SELECT `column-name` as column_name FROM foo WHERE bar = 'bar' That usually works for me. Just make sure that you use ` (on the same key as the tilde) and not ' (single quote). Blessed Be, --Katrina -Original Message- Fro

RE: Varaible Names with "-"

2001-01-17 Thread Warrick, Mark
This probably isn't the answer you're looking for, but you should rename the column. That's just plain bad database design to begin with. And there's no need to add on another layer of unnecessary programming when all you've gotta do is rename the field. ---mark

RE: Varaible Names with "-"

2001-01-18 Thread Scott, Andrew
- From: Warrick, Mark [mailto:[EMAIL PROTECTED]] Sent: 18 January 2001 10:09 To: CF-Talk Subject: RE: Varaible Names with "-" This probably isn't the answer you're looking for, but you should rename the column. That's just plain bad database design to begin with.