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 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196181 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
