TallyList : mailing list management, archiving, and analysis

Archive of:
CF-Talk
Cold Fusion - Technical

home
24 hour view
quick stats
weekly updates

all tallylists
corporate solutions
archive your favorite
help / feedback

About Cold Fusion :
product's home
product's list home

Archived TallyList / CF-Talk:
Subject: RE: stored procedure problem

Larry Juncker (65p/+0r) Posted: Thursday 10 May 2001
This post: 39 views, +0 rating

Rename the column in your query as so:

SELECT A OR B as A_OR_B

Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc.

-----Original Message----- From: Greg Jordan [mailto:gjordan@uhsweb.com] Sent: Thursday, May 10, 2001 10:44 AM To: CF-Talk Subject: stored procedure problem

Our previous DBA created a table and used (gasp) spaces in the field names (believe or don't, this person did it more than once and used ALL KINDS of naming conventions). When I called the SP, the #columnList# lists a field that looks like this:

A OR B

We've got some VB developers who can deal with it by using brackets around the field name in their client/sever apps, which is why no one has bothered to change the field names. Does anyone know a way in CF to work around this?

Similar Subject Line Posts (+/- two weeks of this post)

RE: stored procedure problem	10 May 2001	(28 v/ +0 r)
RE: stored procedure problem	10 May 2001	(27 v/ +0 r)
RE: stored procedure problem	10 May 2001 (this post)	(39 v/ +0 r)
RE: stored procedure problem	10 May 2001	(43 v/ +0 r)
RE: stored procedure problem	10 May 2001	(22 v/ +0 r)
stored procedure problem	10 May 2001	(24 v/ +0 r)

Send a reply to the CF-Talk list!
	NOTE: Many lists will reject your post unless you have already registered with them. Also - don't forget the right account to send from (for those with multiple emails!)