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=foo&returnformat=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" wrote: > > This has been driving me crazy for two days and I GIVE UP! AHH! > > > If I create this variable in application.cfc: > > /> > > > and use it in news.cfc like this: > > > > > > > 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'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" 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: >> >> >> >> 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, >> >> > >>'#application.temp_images_directory#\#newImageFileName#_400.#originalImag >>eExt#' /> >> >> then, just returning the struct to the calling page: >> >> >> >> 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 >> wrote: >> >>> >>> If I use this on a test page: >>> >>> #application.temp_images_directory# >>> >>> 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 >>>>>> wrote: >>> >>>> >>>> This has been driving me crazy for two days and I GIVE UP! AHH! >>>> >>>> >>>> If I create this variable in application.cfc: >>>> >>>> >> 'e:\inetpub\webroot\tempImages' >>>> /> >>>> >>>> >>>> and use it in news.cfc like this: >>>> >>>> >>>> >>>> >>>'#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
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" 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: >> >> >> >> 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, >> >> > >>'#application.temp_images_directory#\#newImageFileName#_400.#originalImag >>eExt#' /> >> >> then, just returning the struct to the calling page: >> >> >> >> 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 >> wrote: >> >>> >>> If I use this on a test page: >>> >>> #application.temp_images_directory# >>> >>> 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 >>>>>> wrote: >>> >>>> >>>> This has been driving me crazy for two days and I GIVE UP! AHH! >>>> >>>> >>>> If I create this variable in application.cfc: >>>> >>>> >> 'e:\inetpub\webroot\tempImages' >>>> /> >>>> >>>> >>>> and use it in news.cfc like this: >>>> >>>> >>>> >>>> >>>'#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??????
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: > > > > 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, > > '#application.temp_images_directory#\#newImageFileName#_400.#originalImageExt#' > /> > > then, just returning the struct to the calling page: > > > > 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 > wrote: > >> >> If I use this on a test page: >> >> #application.temp_images_directory# >> >> 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 >> wrote: >> >>> >>> This has been driving me crazy for two days and I GIVE UP! AHH! >>> >>> >>> If I create this variable in application.cfc: >>> >>> > 'e:\inetpub\webroot\tempImages' >>> /> >>> >>> >>> and use it in news.cfc like this: >>> >>> >>> >>> >>> >>> >>> 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: Why is this happening??????
Thanks for the tip, Dave, but when I set up the application variables using forward slashes, as in: 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: > > > and use it in news.cfc like this: > > > > 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??????
The application.temp_images_directory is being set in application.cfc: 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, then, just returning the struct to the calling page: 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 wrote: > > If I use this on a test page: > > #application.temp_images_directory# > > 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 >wrote: > > > > > This has been driving me crazy for two days and I GIVE UP! AHH! > > > > > > If I create this variable in application.cfc: > > > > 'e:\inetpub\webroot\tempImages' > > /> > > > > > > and use it in news.cfc like this: > > > > > > > > > > > > > > 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??????
> If I create this variable in application.cfc: > > > and use it in news.cfc like this: > > > > 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??????
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" wrote: > >This has been driving me crazy for two days and I GIVE UP! AHH! > > >If I create this variable in application.cfc: > >'e:\inetpub\webroot\tempImages' /> > > >and use it in news.cfc like this: > > > > > > >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??????
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 wrote: > > If I use this on a test page: > > #application.temp_images_directory# > > 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 >wrote: > > > > > This has been driving me crazy for two days and I GIVE UP! AHH! > > > > > > If I create this variable in application.cfc: > > > > 'e:\inetpub\webroot\tempImages' > > /> > > > > > > and use it in news.cfc like this: > > > > > > > > > > > > > > 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??????
If I use this on a test page: #application.temp_images_directory# 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 wrote: > > This has been driving me crazy for two days and I GIVE UP! AHH! > > > If I create this variable in application.cfc: > > /> > > > and use it in news.cfc like this: > > > > > > > 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??????
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" wrote: > >This has been driving me crazy for two days and I GIVE UP! AHH! > > >If I create this variable in application.cfc: > >'e:\inetpub\webroot\tempImages' /> > > >and use it in news.cfc like this: > > > > > > >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??????
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 wrote: > > This has been driving me crazy for two days and I GIVE UP! AHH! > > > If I create this variable in application.cfc: > > /> > > > and use it in news.cfc like this: > > > > > > > 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?
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. > > > > > 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#'); > > > > 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: > > > > > > 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#'); > > > > > > > > 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=lists&body=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=lists&body=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=lists&body=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=lists&body=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=lists&body=lists/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. 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#'); 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: > > > 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#'); > > > > 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=lists&body=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=lists&body=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=lists&body=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=lists&body=lists/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: 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#'); 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=lists&body=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?sidebarRsts&bodyRsts/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=lists&body=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?sidebarRsts&bodyRsts/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: > > > 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#'); > > > > 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=lists&body=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=lists&body=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=lists&body=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: 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#'); 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=lists&body=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=lists&body=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: > > >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#'); > > > >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=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.