you should be able to do the same thing. It's not the VB that interprets
the brackets it's the SQL itself. I assume you are passing in a field list
into a SP as a param so you know what fields to update?....just put brackets
around the field names.
A
P.S. shoot your DBA......before he goes contracting!
------------------------------------------------------------------
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
------------------------------------------------------------------
United Kingdom
http://www.thoughtbubble.co.uk/
Tel: +44 (0) 20 7387 8890
------------------------------------------------------------------
New Zealand
http://www.thoughtbubble.co.nz/
Tel: +64 (0) 9 488 9131
------------------------------------------------------------------
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.
-----Original Message-----
From: Greg Jordan [mailto:[EMAIL PROTECTED]]
Sent: 10 May 2001 16:44
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?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
