1. 'X' is a string, 0 is a number. The value you use must match Field1's
datatype.
2. In Access, both the "+" and "&" are concatenation operators; they
differ in that the "+" will *add* values if either operand is numeric.
Perhaps ODBC uses only the "+" for concatenation?
-David
On Thu, 28 Dec 2000 22:06:40 -0500 "Christopher P. Maher"
<[EMAIL PROTECTED]> writes:
> I'm setting up a new computer (Win 2K Professional) and some queries
> that
> work on other computers do not work on this one. The problem queries
> involve
> concatenation or setting constants in the query. The problem happens
> with
> Access 97 and 2000 databases. Running CF 4.5.1 Professional.
>
> Select Field1 + Field2 as Field3....
> Select 'X' as Field1..... (but Select 0 as Field1 works)
> Select Field1 & Field2 as Field3...
>
> All of the queries work in Access, just not in <CFQuery>. All the
> queries
> work on my old Win NT computer which is basically running the same
> software
> and they work on another Windows 2000 computer.
>
> What is happening is that the browser just hangs when the query is
> run. I
> have to hit stop on the browser and then stop/start the CF service.
>
> Any ideas would be appreciated.
~~~~~~~~~~~~~ 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
