Update query fails in CFMX - Is it a CF BUG???

[Jath Mama]

Hi,

I have a update query in coldfusion page. Even though it works in cf5 it
fails in CFMX. My query is some thing like (I have put a CF output before
executing the query).

UPDATE mytable
SET myfield = 'blah blah SELECT blah blah'

If I change the query like,
UPDATE mytable SET myfield = 'blah blah blah blah'
it is working

This is failing!!!! Strange though... Please guide me if you have a work
around..

Macro media., please wake up ;-)

Regards,
Amjath



:D

[Jath Mama]

For example, the following query is the only statement in a cfm page. It will
fail.

<cfquery name="UpdatemyTable" datasource="#application.datasource#">
Update mytable set myfiedl = 'SELECT SELECT SELECT'
</cfquery>