Chris,
This works for me, using CF Express 4.0 and with an ODBC MS Access
datasource:
<cfquery name="qDirector" datasource="Vid">
select FirstName+' '+LastName as Name
from...
<cfquery>
I was thinking of an insert statement when I wrote that the value must
match the db field datatype. Sorry about that.
-David
On Fri, 29 Dec 2000 09:39:44 -0500 "Christopher P. Maher"
<[EMAIL PROTECTED]> writes:
> > 1. 'X' is a string, 0 is a number. The value you use must match
> Field1's
> > datatype.
>
> Field1 is a field I'm defining in the query. It does not exist in
> the
> database.
>
> > 2. In Access, both the "+" and "&" are concatenation operators;
> they
> > differ in that the "+" will *add* values if either operand is
> numeric.
>
> Fields involved are all text.
>
> > Perhaps ODBC uses only the "+" for concatenation?
>
> Neither "&" or "+" work through ODBC - at least for me.
~~~~~~~~~~~~~ Paid Sponsorship ~~~~~~~~~~~~~
Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free
Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support
Visit SoloServer, https://secure.irides.com/clientsetup.cfm.
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
