Re: / disappears on insert mySQL
Dwayne Cole wrote: when i insert a value like: resources\images\testing.jpg into my mySQL database, the \ disappears. It worked fine in access. You have not enabled the NO_BACKSLASH_ESCAPES SQL mode. (While you are at it, go for full ANSI mode.) ps the field type is mySQL text field. In Access the field type was memo. i'm not using a cfqueryparam Using cfqueryparam would fix this too. Jochem ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269880 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: / disappears on insert mySQL
Jochem I almost directed this post to you specifically. You have got to been some sort of black-belt database guru. OK how do you enable NO_BACKSLASH_ESCAPES and what would be the impact of me switching to ANSI mode. Frankly, not sure what mode I'm working in but I am loving mySQL. It took me 5 years to make the switch, and last month I did, and I am satisfied, but certainly not optimized. I will use cfqueryparam. -- Original Message -- From: Jochem van Dieten [EMAIL PROTECTED] Reply-To: cf-talk@houseoffusion.com Date: Thu, 15 Feb 2007 08:26:13 -0400 Dwayne Cole wrote: when i insert a value like: resources\images\testing.jpg into my mySQL database, the \ disappears. It worked fine in access. You have not enabled the NO_BACKSLASH_ESCAPES SQL mode. (While you are at it, go for full ANSI mode.) ps the field type is mySQL text field. In Access the field type was memo. i'm not using a cfqueryparam Using cfqueryparam would fix this too. Jochem ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269893 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: / disappears on insert mySQL
Dwayne Cole wrote: OK how do you enable NO_BACKSLASH_ESCAPES and what would be the impact of me switching to ANSI mode. http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html Jochem ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269961 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4