-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
All,
I have inherited the support/debug/function enhancement work on an
application a previous developer built (yippee!). There are a number
of queries on various pages (.cfm) of the app that use what looks to
be valid SQL (although my SQL is adequate at best). Problem is, on
my setup (Win2K Pro, CF Server 4.5.1, CF Studio 4.5.1) the SQL craps
out and kills CF Server every time it encounters the code in the form
shown below. The code works fine on another couple of machines
(WinNT4, CF Server 4.5, CF Studio 4.0.1 and Win2K Adv Server, CF
Server 4.5). The problem appears to be with the concatenation of
several fields into an alias. For example:
<cfquery name="type_query" datasource="CVCOOOS">
SELECT type_id, type_id & ' (' & description & ')' AS temp
FROM CallTypes
WHERE new
ORDER BY sequence
</cfquery>
Like I said, the code kills CF Server on my setup, and works on
others. Even running it within the Studio Query Builder, the query
returns no result...
I'm baffled. Any and all advice, even that pointing out how dopey I
am for missing something obvious, will be happily received.
Steve
________________________________________________________________
| Stephen Collins |
| Consultant - Australian Corporate Information Solutions |
| GPO Box 2962 CANBERRA ACT 2601 Australia |
| Ph +61 2 62822662 Fax +61 2 62824328 Cel +61 410 680722 |
| [EMAIL PROTECTED] [EMAIL PROTECTED] |
| http://www.acis.com.au |
|~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~oOo~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
| Before I got into triathlon, I was a normal person. |
|________________________________________________________________|
-----BEGIN PGP SIGNATURE-----
Version: PGP Personal Privacy 6.5.3
iQA/AwUBObQ6rdBcRJfAaSYUEQL2cwCfRFWgfP4ZdqoS/GqTcqmELb9ceK8AoNnW
5SbnTA+oJmyiBnEnJoESMLQ5
=7lgQ
-----END PGP SIGNATURE-----
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
