Re: Why is this happening??????
I didn't see in the thread and you state the structure is the return value. How are you accessing the results from news.cfc? Anything like... Http://localhost/news.cfc?method=fooreturnformat=json What happens if you cflog the variable right before the return? Byron Mann Lead Engineer Architect HostMySite.com On Mar 13, 2013 9:25 PM, Rick Faircloth r...@whitestonemedia.com wrote: This has been driving me crazy for two days and I GIVE UP! AHH! If I create this variable in application.cfc: cfset application.temp_images_directory = 'e:\inetpub\webroot\tempImages' / and use it in news.cfc like this: cfset saveNewsItemStruct = structNew() cfset saveNewsItemStruct.ATID = '#application.temp_images_directory#' / why in the WORLD would I get this: e:\\inetpub\\webroot\\tempImages when I return the struct and display saveNewsItemsStruct.ATID? Why are the path lines doubling? I don't think I've seen this in 15 years of CF programming! (I'm getting too old for all this aggravation...) Thanks for any help! Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355022 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Why is this happening??????
I guess you had no luck finding an instance of jsStringFormat(). Does the value ever hit a scope covered by global script protection before it gets set to the app scope? You could easily rule it out by making sure it is off or turning it off long enough to test. On 3/14/13 12:25 AM, Kym Kovan dev-li...@mbcomms.net.au wrote: Rick, how are you returning this structure? You haven't got some funny format turning on as the return from the CFC function by accident have you? Kym On 14/03/2013 15:49, Rick Faircloth wrote: The application.temp_images_directory is being set in application.cfc: cfset application.temp_images_directory = 'e:\tempImages' / The last part of the example below, the #newImageFileName#.#originalImageExt# is being set in news.cfc, after an image has been uploaded. It's done this way to be able to manipulate the filename part before the extension, such as: #newImageFileName#_400.#originalImageExt# I'm checking it right now by setting struct variables in a cfc such as, cfset saveNewsItemStruct.APPTEMP = '#application.temp_images_directory#\#newImageFileName#_400.#originalImag eExt#' / then, just returning the struct to the calling page: cfreturn saveNewsItemStruct / The saveNewsItemStruct.APPTEMP would end up looking like: e:\\temp_images\\duck_400.jpg And when I tried Dave's solution of using forward slashes, /, instead of back slashes, I'd end up with: e:\/temp_images\/duck_400.jpg I'm not sure what is inserting the backslashes. I don't believe I've ever run into this before. Rick -Original Message- From: Jerry Milo Johnson [mailto:jmi...@gmail.com] Sent: Wednesday, March 13, 2013 10:18 PM To: cf-talk Subject: Re: Why is this happening?? how are you displaying it when the \ are appearing doubled? (something like a js alert, or a cfoutput to an html page, or some other mechanism?) On Wed, Mar 13, 2013 at 10:08 PM, Rick Faircloth r...@whitestonemedia.comwrote: If I use this on a test page: cfoutput#application.temp_images_directory#/cfoutput it comes out fine: e:\inetpub\webroot\tempImages I just don't see why (or how) it could be happening. Thanks for the feedback! Rick -Original Message- From: Jerry Milo Johnson [mailto:jmi...@gmail.com] Sent: Wednesday, March 13, 2013 9:34 PM To: cf-talk Subject: Re: Why is this happening?? what happens if you display the value INSIDE the cfc before you return it? what happens if you set the same variable OUTSIDE the cfc and display it? On Wed, Mar 13, 2013 at 9:23 PM, Rick Faircloth r...@whitestonemedia.com wrote: This has been driving me crazy for two days and I GIVE UP! AHH! If I create this variable in application.cfc: cfset application.temp_images_directory = 'e:\inetpub\webroot\tempImages' / and use it in news.cfc like this: cfset saveNewsItemStruct = structNew() cfset saveNewsItemStruct.ATID = '#application.temp_images_directory#' / why in the WORLD would I get this: e:\\inetpub\\webroot\\tempImages when I return the struct and display saveNewsItemsStruct.ATID? Why are the path lines doubling? I don't think I've seen this in 15 years of CF programming! (I'm getting too old for all this aggravation...) Thanks for any help! Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355016 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Why is this happening??????
I'm not aware of any jsStringFormat() at work and no global script protection, either. -Original Message- From: Bobby [mailto:bo...@acoderslife.com] Sent: Thursday, March 14, 2013 10:00 AM To: cf-talk Subject: Re: Why is this happening?? I guess you had no luck finding an instance of jsStringFormat(). Does the value ever hit a scope covered by global script protection before it gets set to the app scope? You could easily rule it out by making sure it is off or turning it off long enough to test. On 3/14/13 12:25 AM, Kym Kovan dev-li...@mbcomms.net.au wrote: Rick, how are you returning this structure? You haven't got some funny format turning on as the return from the CFC function by accident have you? Kym On 14/03/2013 15:49, Rick Faircloth wrote: The application.temp_images_directory is being set in application.cfc: cfset application.temp_images_directory = 'e:\tempImages' / The last part of the example below, the #newImageFileName#.#originalImageExt# is being set in news.cfc, after an image has been uploaded. It's done this way to be able to manipulate the filename part before the extension, such as: #newImageFileName#_400.#originalImageExt# I'm checking it right now by setting struct variables in a cfc such as, cfset saveNewsItemStruct.APPTEMP = '#application.temp_images_directory#\#newImageFileName#_400.#originalImag eExt#' / then, just returning the struct to the calling page: cfreturn saveNewsItemStruct / The saveNewsItemStruct.APPTEMP would end up looking like: e:\\temp_images\\duck_400.jpg And when I tried Dave's solution of using forward slashes, /, instead of back slashes, I'd end up with: e:\/temp_images\/duck_400.jpg I'm not sure what is inserting the backslashes. I don't believe I've ever run into this before. Rick -Original Message- From: Jerry Milo Johnson [mailto:jmi...@gmail.com] Sent: Wednesday, March 13, 2013 10:18 PM To: cf-talk Subject: Re: Why is this happening?? how are you displaying it when the \ are appearing doubled? (something like a js alert, or a cfoutput to an html page, or some other mechanism?) On Wed, Mar 13, 2013 at 10:08 PM, Rick Faircloth r...@whitestonemedia.comwrote: If I use this on a test page: cfoutput#application.temp_images_directory#/cfoutput it comes out fine: e:\inetpub\webroot\tempImages I just don't see why (or how) it could be happening. Thanks for the feedback! Rick -Original Message- From: Jerry Milo Johnson [mailto:jmi...@gmail.com] Sent: Wednesday, March 13, 2013 9:34 PM To: cf-talk Subject: Re: Why is this happening?? what happens if you display the value INSIDE the cfc before you return it? what happens if you set the same variable OUTSIDE the cfc and display it? On Wed, Mar 13, 2013 at 9:23 PM, Rick Faircloth r...@whitestonemedia.com wrote: This has been driving me crazy for two days and I GIVE UP! AHH! If I create this variable in application.cfc: cfset application.temp_images_directory = 'e:\inetpub\webroot\tempImages' / and use it in news.cfc like this: cfset saveNewsItemStruct = structNew() cfset saveNewsItemStruct.ATID = '#application.temp_images_directory#' / why in the WORLD would I get this: e:\\inetpub\\webroot\\tempImages when I return the struct and display saveNewsItemsStruct.ATID? Why are the path lines doubling? I don't think I've seen this in 15 years of CF programming! (I'm getting too old for all this aggravation...) Thanks for any help! Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355020 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Why is this happening??????
This has been driving me crazy for two days and I GIVE UP! AHH! If I create this variable in application.cfc: cfset application.temp_images_directory = 'e:\inetpub\webroot\tempImages' / and use it in news.cfc like this: cfset saveNewsItemStruct = structNew() cfset saveNewsItemStruct.ATID = '#application.temp_images_directory#' / why in the WORLD would I get this: e:\\inetpub\\webroot\\tempImages when I return the struct and display saveNewsItemsStruct.ATID? Why are the path lines doubling? I don't think I've seen this in 15 years of CF programming! (I'm getting too old for all this aggravation...) Thanks for any help! Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354998 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Why is this happening??????
what happens if you display the value INSIDE the cfc before you return it? what happens if you set the same variable OUTSIDE the cfc and display it? On Wed, Mar 13, 2013 at 9:23 PM, Rick Faircloth r...@whitestonemedia.comwrote: This has been driving me crazy for two days and I GIVE UP! AHH! If I create this variable in application.cfc: cfset application.temp_images_directory = 'e:\inetpub\webroot\tempImages' / and use it in news.cfc like this: cfset saveNewsItemStruct = structNew() cfset saveNewsItemStruct.ATID = '#application.temp_images_directory#' / why in the WORLD would I get this: e:\\inetpub\\webroot\\tempImages when I return the struct and display saveNewsItemsStruct.ATID? Why are the path lines doubling? I don't think I've seen this in 15 years of CF programming! (I'm getting too old for all this aggravation...) Thanks for any help! Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354999 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Why is this happening??????
That is the equivalent of what you would see if you ran that variable through jsStringFormat() somewhere. I'd run a quick search for that. I'd start in the app.cfc with that search to make sure you don't have a routine somewhere that cleans' your variables for you. On 3/13/13 8:23 PM, Rick Faircloth r...@whitestonemedia.com wrote: This has been driving me crazy for two days and I GIVE UP! AHH! If I create this variable in application.cfc: cfset application.temp_images_directory = 'e:\inetpub\webroot\tempImages' / and use it in news.cfc like this: cfset saveNewsItemStruct = structNew() cfset saveNewsItemStruct.ATID = '#application.temp_images_directory#' / why in the WORLD would I get this: e:\\inetpub\\webroot\\tempImages when I return the struct and display saveNewsItemsStruct.ATID? Why are the path lines doubling? I don't think I've seen this in 15 years of CF programming! (I'm getting too old for all this aggravation...) Thanks for any help! Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355000 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Why is this happening??????
If I use this on a test page: cfoutput#application.temp_images_directory#/cfoutput it comes out fine: e:\inetpub\webroot\tempImages I just don't see why (or how) it could be happening. Thanks for the feedback! Rick -Original Message- From: Jerry Milo Johnson [mailto:jmi...@gmail.com] Sent: Wednesday, March 13, 2013 9:34 PM To: cf-talk Subject: Re: Why is this happening?? what happens if you display the value INSIDE the cfc before you return it? what happens if you set the same variable OUTSIDE the cfc and display it? On Wed, Mar 13, 2013 at 9:23 PM, Rick Faircloth r...@whitestonemedia.comwrote: This has been driving me crazy for two days and I GIVE UP! AHH! If I create this variable in application.cfc: cfset application.temp_images_directory = 'e:\inetpub\webroot\tempImages' / and use it in news.cfc like this: cfset saveNewsItemStruct = structNew() cfset saveNewsItemStruct.ATID = '#application.temp_images_directory#' / why in the WORLD would I get this: e:\\inetpub\\webroot\\tempImages when I return the struct and display saveNewsItemsStruct.ATID? Why are the path lines doubling? I don't think I've seen this in 15 years of CF programming! (I'm getting too old for all this aggravation...) Thanks for any help! Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355001 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Why is this happening??????
how are you displaying it when the \ are appearing doubled? (something like a js alert, or a cfoutput to an html page, or some other mechanism?) On Wed, Mar 13, 2013 at 10:08 PM, Rick Faircloth r...@whitestonemedia.comwrote: If I use this on a test page: cfoutput#application.temp_images_directory#/cfoutput it comes out fine: e:\inetpub\webroot\tempImages I just don't see why (or how) it could be happening. Thanks for the feedback! Rick -Original Message- From: Jerry Milo Johnson [mailto:jmi...@gmail.com] Sent: Wednesday, March 13, 2013 9:34 PM To: cf-talk Subject: Re: Why is this happening?? what happens if you display the value INSIDE the cfc before you return it? what happens if you set the same variable OUTSIDE the cfc and display it? On Wed, Mar 13, 2013 at 9:23 PM, Rick Faircloth r...@whitestonemedia.com wrote: This has been driving me crazy for two days and I GIVE UP! AHH! If I create this variable in application.cfc: cfset application.temp_images_directory = 'e:\inetpub\webroot\tempImages' / and use it in news.cfc like this: cfset saveNewsItemStruct = structNew() cfset saveNewsItemStruct.ATID = '#application.temp_images_directory#' / why in the WORLD would I get this: e:\\inetpub\\webroot\\tempImages when I return the struct and display saveNewsItemsStruct.ATID? Why are the path lines doubling? I don't think I've seen this in 15 years of CF programming! (I'm getting too old for all this aggravation...) Thanks for any help! Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355002 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Why is this happening??????
That gives me an idea about what might be going on. I'll check into that tomorrow and let you know what I find. Thanks! Rick -Original Message- From: Bobby [mailto:bo...@acoderslife.com] Sent: Wednesday, March 13, 2013 10:57 PM To: cf-talk Subject: Re: Why is this happening?? That is the equivalent of what you would see if you ran that variable through jsStringFormat() somewhere. I'd run a quick search for that. I'd start in the app.cfc with that search to make sure you don't have a routine somewhere that cleans' your variables for you. On 3/13/13 8:23 PM, Rick Faircloth r...@whitestonemedia.com wrote: This has been driving me crazy for two days and I GIVE UP! AHH! If I create this variable in application.cfc: cfset application.temp_images_directory = 'e:\inetpub\webroot\tempImages' / and use it in news.cfc like this: cfset saveNewsItemStruct = structNew() cfset saveNewsItemStruct.ATID = '#application.temp_images_directory#' / why in the WORLD would I get this: e:\\inetpub\\webroot\\tempImages when I return the struct and display saveNewsItemsStruct.ATID? Why are the path lines doubling? I don't think I've seen this in 15 years of CF programming! (I'm getting too old for all this aggravation...) Thanks for any help! Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355003 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Why is this happening??????
If I create this variable in application.cfc: cfset application.temp_images_directory = 'e:\inetpub\webroot\tempImages' / and use it in news.cfc like this: cfset saveNewsItemStruct = structNew() cfset saveNewsItemStruct.ATID = '#application.temp_images_directory#' / why in the WORLD would I get this: e:\\inetpub\\webroot\\tempImages when I return the struct and display saveNewsItemsStruct.ATID? Why are the path lines doubling? I don't think I've seen this in 15 years of CF programming! (I'm getting too old for all this aggravation...) I don't know what's causing this specific problem, but you can work around it pretty easily by using forward slashes instead of backslashes. Forward slashes work fine with file paths on Windows, when used from CF. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355005 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Why is this happening??????
The application.temp_images_directory is being set in application.cfc: cfset application.temp_images_directory = 'e:\tempImages' / The last part of the example below, the #newImageFileName#.#originalImageExt# is being set in news.cfc, after an image has been uploaded. It's done this way to be able to manipulate the filename part before the extension, such as: #newImageFileName#_400.#originalImageExt# I'm checking it right now by setting struct variables in a cfc such as, cfset saveNewsItemStruct.APPTEMP = '#application.temp_images_directory#\#newImageFileName#_400.#originalImageExt#' / then, just returning the struct to the calling page: cfreturn saveNewsItemStruct / The saveNewsItemStruct.APPTEMP would end up looking like: e:\\temp_images\\duck_400.jpg And when I tried Dave's solution of using forward slashes, /, instead of back slashes, I'd end up with: e:\/temp_images\/duck_400.jpg I'm not sure what is inserting the backslashes. I don't believe I've ever run into this before. Rick -Original Message- From: Jerry Milo Johnson [mailto:jmi...@gmail.com] Sent: Wednesday, March 13, 2013 10:18 PM To: cf-talk Subject: Re: Why is this happening?? how are you displaying it when the \ are appearing doubled? (something like a js alert, or a cfoutput to an html page, or some other mechanism?) On Wed, Mar 13, 2013 at 10:08 PM, Rick Faircloth r...@whitestonemedia.comwrote: If I use this on a test page: cfoutput#application.temp_images_directory#/cfoutput it comes out fine: e:\inetpub\webroot\tempImages I just don't see why (or how) it could be happening. Thanks for the feedback! Rick -Original Message- From: Jerry Milo Johnson [mailto:jmi...@gmail.com] Sent: Wednesday, March 13, 2013 9:34 PM To: cf-talk Subject: Re: Why is this happening?? what happens if you display the value INSIDE the cfc before you return it? what happens if you set the same variable OUTSIDE the cfc and display it? On Wed, Mar 13, 2013 at 9:23 PM, Rick Faircloth r...@whitestonemedia.com wrote: This has been driving me crazy for two days and I GIVE UP! AHH! If I create this variable in application.cfc: cfset application.temp_images_directory = 'e:\inetpub\webroot\tempImages' / and use it in news.cfc like this: cfset saveNewsItemStruct = structNew() cfset saveNewsItemStruct.ATID = '#application.temp_images_directory#' / why in the WORLD would I get this: e:\\inetpub\\webroot\\tempImages when I return the struct and display saveNewsItemsStruct.ATID? Why are the path lines doubling? I don't think I've seen this in 15 years of CF programming! (I'm getting too old for all this aggravation...) Thanks for any help! Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355008 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Why is this happening??????
Thanks for the tip, Dave, but when I set up the application variables using forward slashes, as in: cfset application.temp_images_directory = 'e:/inetpub/webroot/tempImages' / When I use that variable with a variable for a file in the news.cfc, like this: #application.temp_images_directory#.#newFileName#.#originalFileExt# I'd end up with: e:\/inetpub\/webroot\/tempImages\/duck.jpg instead of the usual: e:\\inetpub\\webroot\\tempImages\\duck.jpg if I used forward slashes when the path variable is created. Just doesn't make sense. Can't figure out where the extra \ is being inserted. If I create this variable in application.cfc: cfset application.temp_images_directory = 'e:\inetpub\webroot\tempImages' / and use it in news.cfc like this: cfset saveNewsItemStruct = structNew() cfset saveNewsItemStruct.ATID = '#application.temp_images_directory#' / why in the WORLD would I get this: e:\\inetpub\\webroot\\tempImages when I return the struct and display saveNewsItemsStruct.ATID? Why are the path lines doubling? I don't think I've seen this in 15 years of CF programming! (I'm getting too old for all this aggravation...) I don't know what's causing this specific problem, but you can work around it pretty easily by using forward slashes instead of backslashes. Forward slashes work fine with file paths on Windows, when used from CF. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355009 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Why is this happening??????
Rick, how are you returning this structure? You haven't got some funny format turning on as the return from the CFC function by accident have you? Kym On 14/03/2013 15:49, Rick Faircloth wrote: The application.temp_images_directory is being set in application.cfc: cfset application.temp_images_directory = 'e:\tempImages' / The last part of the example below, the #newImageFileName#.#originalImageExt# is being set in news.cfc, after an image has been uploaded. It's done this way to be able to manipulate the filename part before the extension, such as: #newImageFileName#_400.#originalImageExt# I'm checking it right now by setting struct variables in a cfc such as, cfset saveNewsItemStruct.APPTEMP = '#application.temp_images_directory#\#newImageFileName#_400.#originalImageExt#' / then, just returning the struct to the calling page: cfreturn saveNewsItemStruct / The saveNewsItemStruct.APPTEMP would end up looking like: e:\\temp_images\\duck_400.jpg And when I tried Dave's solution of using forward slashes, /, instead of back slashes, I'd end up with: e:\/temp_images\/duck_400.jpg I'm not sure what is inserting the backslashes. I don't believe I've ever run into this before. Rick -Original Message- From: Jerry Milo Johnson [mailto:jmi...@gmail.com] Sent: Wednesday, March 13, 2013 10:18 PM To: cf-talk Subject: Re: Why is this happening?? how are you displaying it when the \ are appearing doubled? (something like a js alert, or a cfoutput to an html page, or some other mechanism?) On Wed, Mar 13, 2013 at 10:08 PM, Rick Faircloth r...@whitestonemedia.comwrote: If I use this on a test page: cfoutput#application.temp_images_directory#/cfoutput it comes out fine: e:\inetpub\webroot\tempImages I just don't see why (or how) it could be happening. Thanks for the feedback! Rick -Original Message- From: Jerry Milo Johnson [mailto:jmi...@gmail.com] Sent: Wednesday, March 13, 2013 9:34 PM To: cf-talk Subject: Re: Why is this happening?? what happens if you display the value INSIDE the cfc before you return it? what happens if you set the same variable OUTSIDE the cfc and display it? On Wed, Mar 13, 2013 at 9:23 PM, Rick Faircloth r...@whitestonemedia.com wrote: This has been driving me crazy for two days and I GIVE UP! AHH! If I create this variable in application.cfc: cfset application.temp_images_directory = 'e:\inetpub\webroot\tempImages' / and use it in news.cfc like this: cfset saveNewsItemStruct = structNew() cfset saveNewsItemStruct.ATID = '#application.temp_images_directory#' / why in the WORLD would I get this: e:\\inetpub\\webroot\\tempImages when I return the struct and display saveNewsItemsStruct.ATID? Why are the path lines doubling? I don't think I've seen this in 15 years of CF programming! (I'm getting too old for all this aggravation...) Thanks for any help! Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355010 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Can anyone suggest why this is happening?
Dave, Thats what I am thinking, but I can't seem to find out. And the answer is no, I log in as the administrator through a Remote Desktop connection when I test it from the command line. Which made me think last night on the way home that it might still be a permission problem. Regards Andrew Scott Technical Consultant NuSphere Pty Ltd Level 2/33 Bank Street South Melbourne, Victoria, 3205 Phone: 03 9686 0485-Fax: 03 9699 7976 _ From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, 10 June 2004 3:56 PM To: CF-Talk Subject: RE: Can anyone suggest why this is happening? Now I thought that it might have something to do with permissions but to be, thought it might be a problem with the jvm well not sure on this as I have a main class file that I call from the command prompt and it opens the image just not in CFMX through a CFX tag on this one server. When you call it from the command prompt, are you logged in as the same user as the CF service runs as? If not, it may still be a permissions problem. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Can anyone suggest why this is happening?
Thats what I am thinking, but I can't seem to find out. And the answer is no, I log in as the administrator through a Remote Desktop connection when I test it from the command line. Which made me think last night on the way home that it might still be a permission problem. You can easily test this using the RUNAS command. When you log in, open a command shell and from that, use RUNAS to open another command shell running as the CF server user account. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Can anyone suggest why this is happening?
The other thing I should mention is that the page it is called from sits in an internal loop or something, because if I try to browse that page again, it never displays. For example I have a page based on an action passed to it but it also calls this CFX tag, if I pass the right option it runs the tag (well sort of because it hangs). If I cancel and hit any other page in the site it will display go back to this page with no options (not to run the tag) and it has hung will not display that page. I am at my wits on this one, the file permissions all look the same as each machine it is running on. The CF Service on each machine uses the same account to run under and only 1 machine is having this problem:-( Anyone know why? Regards Andrew Scott Technical Consultant NuSphere Pty Ltd Level 2/33 Bank Street South Melbourne, Victoria, 3205 Phone: 03 9686 0485-Fax: 03 9699 7976 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Can anyone suggest why this is happening?
The server with the problem is running as local account, which account would that be:-) Regards Andrew Scott Technical Consultant NuSphere Pty Ltd Level 2/33 Bank Street South Melbourne, Victoria, 3205 Phone: 03 9686 0485-Fax: 03 9699 7976 _ From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, 11 June 2004 6:35 AM To: CF-Talk Subject: RE: Can anyone suggest why this is happening? Thats what I am thinking, but I can't seem to find out. And the answer is no, I log in as the administrator through a Remote Desktop connection when I test it from the command line. Which made me think last night on the way home that it might still be a permission problem. You can easily test this using the RUNAS command. When you log in, open a command shell and from that, use RUNAS to open another command shell running as the CF server user account. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Can anyone suggest why this is happening?
I have tried running CF as an administrator with the same results. Regards Andrew Scott Technical Consultant NuSphere Pty Ltd Level 2/33 Bank Street South Melbourne, Victoria, 3205 Phone: 03 9686 0485-Fax: 03 9699 7976 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Can anyone suggest why this is happening?
The server with the problem is running as local account, which account would that be:-) CF runs as SYSTEM by default. However, SYSTEM isn't a user account that you'll be able to log in as. If CF is running as SYSTEM, and the files in question are on a local filesystem, it probably isn't a permissions issue, since SYSTEM usually has full control over files in general. There may be other account-related problems, though. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Can anyone suggest why this is happening?
Oh, And I forgot to mention that if I comment the code that tries to open the image out... The CFXtag actually does run, which is why I didn't think it was a permission problem to start with. This tag is an image resize tag and returns info as well as other details about an image. It works on uploading an image via the browser and then this tag will do what you ask it to do. If as I said comment that call out of the CFX tag (written in java) it works fine runs displays debug information that I put in there. But as soon as I try to open the image this is what I get a system that hangs a template? Regards Andrew Scott Technical Consultant NuSphere Pty Ltd Level 2/33 Bank Street South Melbourne, Victoria, 3205 Phone: 03 9686 0485-Fax: 03 9699 7976 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Can anyone suggest why this is happening?
Futher Info, Not 100% sure, but I went to the server and did 2 things and since then it has been working ever since. Issue 1) When I switched the monitor on I had a DirecDraw error about something not being in 256 colour mode. Issue 2) Stopped the virus protector. Issue 1 I thin its due to another application, but hey you never know. And issue 2 well its not the first time this damn thing has stopped coldfusion in its tracks... Regards Andrew Scott Technical Consultant NuSphere Pty Ltd Level 2/33 Bank Street South Melbourne, Victoria, 3205 Phone: 03 9686 0485-Fax: 03 9699 7976 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Can anyone suggest why this is happening?
Hi All, A little about the problem first: I have 3 servers one is a live production server and the other is a development server, and I also have a development server running 2003. All running cfmx 6.1... Now I have a java tag that I wrote that is not working on the development server, it runs great on the production server and the 2003 server but will not run on this on server. The java tag is a cfx tag, and I have traced it down to opening an image. Now I thought that it might have something to do with permissions but to be, thought it might be a problem with the jvm well not sure on this as I have a main class file that I call from the command prompt and it opens the image just not in CFMX through a CFX tag on this one server. Can anyone shed some light on this, run into the problem and maybe guide me into were I might or should be looking to solve this problem. Regards Andrew Scott Technical Consultant NuSphere Pty Ltd Level 2/33 Bank Street South Melbourne, Victoria, 3205 Phone: 03 9686 0485-Fax: 03 9699 7976 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Can anyone suggest why this is happening?
Is the directory mapped in CF? At 10:31 PM 6/9/04, Andrew wrote: Now I have a java tag that I wrote that is not working on the development server, it runs great on the production server and the 2003 server but will not run on this on server. The java tag is a cfx tag, and I have traced it down to opening an image. Now I thought that it might have something to do with permissions but to be, thought it might be a problem with the jvm well not sure on this as I have a main class file that I call from the command prompt and it opens the image just not in CFMX through a CFX tag on this one server. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Can anyone suggest why this is happening?
No and it doesn't need to be mapped, I am using the full system path and the code is not running in CF so a mapping will not be the solution. Regards Andrew Scott Technical Consultant NuSphere Pty Ltd Level 2/33 Bank Street South Melbourne, Victoria, 3205 Phone: 03 9686 0485-Fax: 03 9699 7976 _ From: Maureen [mailto:[EMAIL PROTECTED] Sent: Thursday, 10 June 2004 12:49 PM To: CF-Talk Subject: Re: Can anyone suggest why this is happening? Is the directory mapped in CF? At 10:31 PM 6/9/04, Andrew wrote: Now I have a java tag that I wrote that is not working on the development server, it runs great on the production server and the 2003 server but will not run on this on server. The java tag is a cfx tag, and I have traced it down to opening an image. Now I thought that it might have something to do with permissions but to be, thought it might be a problem with the jvm well not sure on this as I have a main class file that I call from the command prompt and it opens the image just not in CFMX through a CFX tag on this one server. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Can anyone suggest why this is happening?
Now I thought that it might have something to do with permissions but to be, thought it might be a problem with the jvm well not sure on this as I have a main class file that I call from the command prompt and it opens the image just not in CFMX through a CFX tag on this one server. When you call it from the command prompt, are you logged in as the same user as the CF service runs as? If not, it may still be a permissions problem. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: why is this happening?
Thanks to all who responded this issue. Debugging showed that the query would choke on one record contained single quotes. I escaped those, and it works fine. Since all the records previous to the corrupted one were ok, they were saved to the table. Commas are handled with no problem, however. Doug Jordon [EMAIL PROTECTED] wrote: It shouldn't matter what kind of field it is in the database. You need to escape your comma's. Try this. cfset message_body = Replace(query.BODY, ",", "Chr(44)", "ALL") cfquery datasource="datasourcename" insert into emails(SUBJECT, FROMX, TO, DATEX, BODY, ATTACHMENTS, CC, MESSAGENUMBER, ATTACHMENTFILES, REPLYTO, HEADER, TIMEx) values ( '#query.SUBJECT#', '#FROMX#', '#query.TO#', #DATEy#, '#message_body#', '#ATTACHMENTSX#', '#query.CC#', '#query.MESSAGENUMBER#', '#ATTACHMENTFILESX#', '#query.REPLYTO#', '#query.HEADER#', '#TIMEx#'); /cfquery Then when you output it you do the opposite. --K Katrina Chapman Consultant Ameriquest Mortgage Douglas Jordon [EMAIL PROTECTED] 07/12/00 09:49 AM Please respond to cf-talk To: [EMAIL PROTECTED] cc: Subject:Re: why is this happening? That's interesting, because I had narrowed the fields down to one: the body field which of course contains commas(the data is email). How do I get around this? It's an Access database memo field. DJ "Dempsey, Timothy F." wrote: Doug, Could one of you values have a comma in it? That might make the database think it has more values than you intend. -- Tim Dempsey -Original Message- From: Douglas Jordon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 12, 2000 11:06 AM To: Cold Fusion List Subject: why is this happening? Why would this query: cfquery datasource="datasourcename" insert into emails(SUBJECT, FROMX, TO, DATEX, BODY, ATTACHMENTS, CC, MESSAGENUMBER, ATTACHMENTFILES, REPLYTO, HEADER, TIMEx) values ( '#query.SUBJECT#', '#FROMX#', '#query.TO#', #DATEy#, '#query.BODY#', '#ATTACHMENTSX#', '#query.CC#', '#query.MESSAGENUMBER#', '#ATTACHMENTFILESX#', '#query.REPLYTO#', '#query.HEADER#', '#TIMEx#'); /cfquery return this error?: ODBC Error Code = 21S01 (Insert value list does not match column list) [Microsoft][ODBC Microsoft Access 97 Driver] Number of query values and destination fields aren't the same. What's also odd is that the data is being saved to the table. TIA, Doug Jordon -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
why is this happening?
Why would this query: cfquery datasource="datasourcename" insert into emails(SUBJECT, FROMX, TO, DATEX, BODY, ATTACHMENTS, CC, MESSAGENUMBER, ATTACHMENTFILES, REPLYTO, HEADER, TIMEx) values ( '#query.SUBJECT#', '#FROMX#', '#query.TO#', #DATEy#, '#query.BODY#', '#ATTACHMENTSX#', '#query.CC#', '#query.MESSAGENUMBER#', '#ATTACHMENTFILESX#', '#query.REPLYTO#', '#query.HEADER#', '#TIMEx#'); /cfquery return this error?: ODBC Error Code = 21S01 (Insert value list does not match column list) [Microsoft][ODBC Microsoft Access 97 Driver] Number of query values and destination fields aren't the same. What's also odd is that the data is being saved to the table. TIA, Doug Jordon -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: why is this happening?
At 11:05 12/07/00 -0400 Douglas Jordon said Could be the ; at the end of '#TIMEx#') Gordon Why would this query: cfquery datasource="datasourcename" insert into emails(SUBJECT, FROMX, TO, DATEX, BODY, ATTACHMENTS, CC, MESSAGENUMBER, ATTACHMENTFILES, REPLYTO, HEADER, TIMEx) values ( '#query.SUBJECT#', '#FROMX#', '#query.TO#', #DATEy#, '#query.BODY#', '#ATTACHMENTSX#', '#query.CC#', '#query.MESSAGENUMBER#', '#ATTACHMENTFILESX#', '#query.REPLYTO#', '#query.HEADER#', '#TIMEx#'); /cfquery return this error?: ODBC Error Code = 21S01 (Insert value list does not match column list) [Microsoft][ODBC Microsoft Access 97 Driver] Number of query values and destination fields aren't the same. What's also odd is that the data is being saved to the table. TIA, Doug Jordon --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_t alk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: why is this happening?
Doug, Could one of you values have a comma in it? That might make the database think it has more values than you intend. -- Tim Dempsey -Original Message- From: Douglas Jordon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 12, 2000 11:06 AM To: Cold Fusion List Subject: why is this happening? Why would this query: cfquery datasource="datasourcename" insert into emails(SUBJECT, FROMX, TO, DATEX, BODY, ATTACHMENTS, CC, MESSAGENUMBER, ATTACHMENTFILES, REPLYTO, HEADER, TIMEx) values ( '#query.SUBJECT#', '#FROMX#', '#query.TO#', #DATEy#, '#query.BODY#', '#ATTACHMENTSX#', '#query.CC#', '#query.MESSAGENUMBER#', '#ATTACHMENTFILESX#', '#query.REPLYTO#', '#query.HEADER#', '#TIMEx#'); /cfquery return this error?: ODBC Error Code = 21S01 (Insert value list does not match column list) [Microsoft][ODBC Microsoft Access 97 Driver] Number of query values and destination fields aren't the same. What's also odd is that the data is being saved to the table. TIA, Doug Jordon -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: why is this happening?
That's interesting, because I had narrowed the fields down to one: the body field which of course contains commas(the data is email). How do I get around this? It's an Access database memo field. DJ "Dempsey, Timothy F." wrote: Doug, Could one of you values have a comma in it? That might make the database think it has more values than you intend. -- Tim Dempsey -Original Message- From: Douglas Jordon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 12, 2000 11:06 AM To: Cold Fusion List Subject: why is this happening? Why would this query: cfquery datasource="datasourcename" insert into emails(SUBJECT, FROMX, TO, DATEX, BODY, ATTACHMENTS, CC, MESSAGENUMBER, ATTACHMENTFILES, REPLYTO, HEADER, TIMEx) values ( '#query.SUBJECT#', '#FROMX#', '#query.TO#', #DATEy#, '#query.BODY#', '#ATTACHMENTSX#', '#query.CC#', '#query.MESSAGENUMBER#', '#ATTACHMENTFILESX#', '#query.REPLYTO#', '#query.HEADER#', '#TIMEx#'); /cfquery return this error?: ODBC Error Code = 21S01 (Insert value list does not match column list) [Microsoft][ODBC Microsoft Access 97 Driver] Number of query values and destination fields aren't the same. What's also odd is that the data is being saved to the table. TIA, Doug Jordon -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: why is this happening
Ok first order of the day: Get Novell Groupwise off my computer, the email program on it IMHO sucks, attempting to type the body of my message in the subject, not very intuitive...and people wonder why MS Outlook dominates the market *sigh* Anyways, a partial insert is impossible the query would have simply aborted on this error message, this was just simploy a typo that stopped the query in its tracks. Gregory Harris Los Angeles ITA Dept. [EMAIL PROTECTED] [EMAIL PROTECTED] 07/12 9:06 AM Quite simple, count the amount of Fields, and the amount of values, and they aren't consistent you have 11 fields and 12 values, re-tool and try again! What was throwing me is that the data he had *right* was still being saved. I've been fortunate(?) to work with native drivers instead of ODBC, and this (or any other failure) would simply have discarded the whole query and inserted nothing - is this 'partial insert' a common behavior of ODBC drivers? Brandon Whitaker [EMAIL PROTECTED] --- "It'll get used by the same people using Opera. People dressed in black wearing berets." - Dave Watts, on Mozilla "It makes you feel so welcome to have a greeter like Papa Dave at the door. Kind of like what Wal-Mart wishes it could do." - John Allred, on Dave Watts "The net interprets censorship as damage and routes around it." - John Gilmore -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: why is this happening?
Why partial data would be saved to the table is beyond me though. Maybe you weren't running things in a transaction and there was no rollback? Another query doing an insert? Gregory Harris Los Angeles ITA Dept. [EMAIL PROTECTED] [EMAIL PROTECTED] 07/12 8:05 AM Why would this query: cfquery datasource="datasourcename" insert into emails(SUBJECT, FROMX, TO, DATEX, BODY, ATTACHMENTS, CC, MESSAGENUMBER, ATTACHMENTFILES, REPLYTO, HEADER, TIMEx) values ( '#query.SUBJECT#', '#FROMX#', '#query.TO#', #DATEy#, '#query.BODY#', '#ATTACHMENTSX#', '#query.CC#', '#query.MESSAGENUMBER#', '#ATTACHMENTFILESX#', '#query.REPLYTO#', '#query.HEADER#', '#TIMEx#'); /cfquery return this error?: ODBC Error Code = 21S01 (Insert value list does not match column list) [Microsoft][ODBC Microsoft Access 97 Driver] Number of query values and destination fields aren't the same. What's also odd is that the data is being saved to the table. TIA, Doug Jordon -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: why is this happening?
It shouldn't matter what kind of field it is in the database. You need to escape your comma's. Try this. cfset message_body = Replace(query.BODY, ",", "Chr(44)", "ALL") cfquery datasource="datasourcename" insert into emails(SUBJECT, FROMX, TO, DATEX, BODY, ATTACHMENTS, CC, MESSAGENUMBER, ATTACHMENTFILES, REPLYTO, HEADER, TIMEx) values ( '#query.SUBJECT#', '#FROMX#', '#query.TO#', #DATEy#, '#message_body#', '#ATTACHMENTSX#', '#query.CC#', '#query.MESSAGENUMBER#', '#ATTACHMENTFILESX#', '#query.REPLYTO#', '#query.HEADER#', '#TIMEx#'); /cfquery Then when you output it you do the opposite. --K Katrina Chapman Consultant Ameriquest Mortgage Douglas Jordon [EMAIL PROTECTED] 07/12/00 09:49 AM Please respond to cf-talk To: [EMAIL PROTECTED] cc: Subject:Re: why is this happening? That's interesting, because I had narrowed the fields down to one: the body field which of course contains commas(the data is email). How do I get around this? It's an Access database memo field. DJ "Dempsey, Timothy F." wrote: Doug, Could one of you values have a comma in it? That might make the database think it has more values than you intend. -- Tim Dempsey -Original Message- From: Douglas Jordon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 12, 2000 11:06 AM To: Cold Fusion List Subject: why is this happening? Why would this query: cfquery datasource="datasourcename" insert into emails(SUBJECT, FROMX, TO, DATEX, BODY, ATTACHMENTS, CC, MESSAGENUMBER, ATTACHMENTFILES, REPLYTO, HEADER, TIMEx) values ( '#query.SUBJECT#', '#FROMX#', '#query.TO#', #DATEy#, '#query.BODY#', '#ATTACHMENTSX#', '#query.CC#', '#query.MESSAGENUMBER#', '#ATTACHMENTFILESX#', '#query.REPLYTO#', '#query.HEADER#', '#TIMEx#'); /cfquery return this error?: ODBC Error Code = 21S01 (Insert value list does not match column list) [Microsoft][ODBC Microsoft Access 97 Driver] Number of query values and destination fields aren't the same. What's also odd is that the data is being saved to the table. TIA, Doug Jordon -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.