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.
------------------------------------
Christopher P. Maher
Maher Associates, Inc.
Actuarial and Computer Consulting
[EMAIL PROTECTED]
http://www.maherassociates.com
~~~~~~~~~~~~~ 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
