Hi All,
Have run across a VERY STRANGE behaviour in CF 8.01 / mySQL 5.0
I've got a code snippet to modify vaules in an enum field in our database.
<cfset my_new_list ="'A','B','C','D'">
<cfquery datasource="#APPLICATION.dsn#" name="test">
ALTER TABLE the_table MODIFY the_field ENUM(#my_new_list#) NOT NULL;
;
</cfquery>
Results in an CF/mySQL error... for SOME reason my_new_list when inside the
<cfquery> gets transformed to
"A","B","C","D".. which mySQL does not like.
I have found that if use:
<cfset my_new_list = "A,B,C,D">
ALTER TABLE the_table MODIFY the_field
ENUM('#ListChangeDelims(my_new_list,"','")#') NOT NULL;
Things work...
Anyone have a reason why the first does not work.. and I hope this saves
someone some grief!
Cheers,
Matts
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311494
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
