Thanks, Adrian, that did the trick. Not sure why, but I always forget about those underused square brackets.
Pete On Wed, 23 Feb 2005 15:39:25 -0500, Pete Ruckelshaus <[EMAIL PROTECTED]> wrote: > Believe it or not, the database doesn't support making aliases. If > you're curious, the database is a horrible nightmare called > "ApogeeSQL" that was developed by the company that originally wrote > the application that I am rewriting. ApogeeSQL has a barely first-gen > ODBC driver that is so flakey it isn't even funny...the SQL options > that are available to me when getting data out of this database are > severely limited. To give you an idea, queries fail if I put a cr-lf > in them, you can't query on NULL objects (which isn't surprising, > since the DB has no concept of null values anyway). Suffice it to > say, this is my hair shirt...but at least I'm being paid to wear it. > > Pete > > > On Wed, 23 Feb 2005 15:26:45 -0500, Matthew Small <[EMAIL PROTECTED]> wrote: > > What's the query? If it's possible, alias the column. > > > > - Matt Small > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196186 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
