How would you approach this? Shared Calender? Any volunteers?
I created a group of 50 brain tumor organizations and need to create a calender that each member can insert into their own website, but takes the data from my website.. I see a lot of sample code out there for creating the actual calander, but I am thinking about how to actually implement it to make it easy for people to put into their own websites.. what would be best and easiest for the members? Maybe use an iframe with the source being the calander on my website? maybe a flash or flex applet? I could do the iframe with a standard cf page myself.. but I never used flex and just basic stuff with flash. Anyone want to volunteer to help on this? Contact me privately muse...@virtualtrials.com Al ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323262 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
pagination of record
Ok this is kind of a different pagination they have tried before. I have a page that displays an image. I need to paginate from image 1 - 3 in a dataset. So say I go get all the images and I have a query that comes back with PhotoID 2,14,15. Currently the image being viewed it PhotoID 14. I need pagination that says You are viewing photo 2 of 3 with Next and Previous buttons. I thought about using valuesList() to convert the query record to a list and using ListFind() to find the position. How do I do the Next and Previous? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323263 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Image killing server
Hey all, got a bit of a strange one here. A user is uploading an image which GIMP is reporting to have an embedded colour profile of . When I use any of the image functions on this image, CF dies. I posted a while ago but because it was only one user we converted it manually and re-uploaded, now we're getting more of them. Could I ask for a sanity check by someone confirming that this image is killing their server too? http://www.halestorm.co.uk/images/killer.jpg Download it, create a .cfm page and do ImageRead(ExpandPath(./killer.jpg)) I get a blank page back then on refresh a message saying CF is starting up. I'm on the bug report page at the moment but I thought I would get someone else to test this also. Thanks. Adrian Lynch | www.halestorm.co.uk ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323264 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
re: Image killing server
Just looking at the link you sent in a browser, the image is nearly all black, which makes me think it's a CMYK jpeg, instead of an RGB jpeg. Browsers and the Adobe image engine can't handle the CMYK ... that's my guess. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323265 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Image killing server
Hey, thanks Jason, I did the blackout myself. It's an image for an awards show so I thought it best to mask it. It is RGB, CMYK was our first thought too. Adrian -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: 09 June 2009 15:54 To: cf-talk Subject: re: Image killing server Just looking at the link you sent in a browser, the image is nearly all black, which makes me think it's a CMYK jpeg, instead of an RGB jpeg. Browsers and the Adobe image engine can't handle the CMYK ... that's my guess. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323266 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: pagination of record
why don't you implement some lightbox clone instead? (PS: in most cases you do not show thumbnails if you do not want to - you can just display links to images as plain old text links) http://fancy.klade.lv/example http://leandrovieira.com/projects/jquery/lightbox/ http://plugins.jquery.com/project/galleryview http://www.no-margin-for-errors.com/projects/prettyPhoto-jquery-lightbox-clone/ http://www.no-margin-for-errors.com/projects/prettyGallery/ Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ On 09/06/2009 21:37, Chad Gray wrote: Ok this is kind of a different pagination they have tried before. I have a page that displays an image. I need to paginate from image 1 - 3 in a dataset. So say I go get all the images and I have a query that comes back with PhotoID 2,14,15. Currently the image being viewed it PhotoID 14. I need pagination that says You are viewing photo 2 of 3 with Next and Previous buttons. I thought about using valuesList() to convert the query record to a list and using ListFind() to find the position. How do I do the Next and Previous? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323267 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Image killing server
I did the blackout myself. Yes, but that also means you altered the image and we're no longer looking at the image you have a problem with. Did you verify the CF function fails on this version of the image? Robert B. Harrison Director of Interactive Services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged __ Information from ESET Smart Security, version of virus signature database 4141 (20090609) __ The message was checked by ESET Smart Security. http://www.eset.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323268 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Image killing server
Of course ;O) Still kills our servers. Has anyone witnessed it yet? -Original Message- From: Robert Harrison [mailto:rob...@austin-williams.com] Sent: 09 June 2009 16:15 To: cf-talk Subject: RE: Image killing server I did the blackout myself. Yes, but that also means you altered the image and we're no longer looking at the image you have a problem with. Did you verify the CF function fails on this version of the image? Robert B. Harrison Director of Interactive Services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged __ Information from ESET Smart Security, version of virus signature database 4141 (20090609) __ The message was checked by ESET Smart Security. http://www.eset.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323269 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Image killing server
hmm... worked just fine on my dev server... cfset myimage = ImageRead(ExpandPath(./killer.jpg)) cfdump var=#myimage# format=text dumped me this nice struct: struct colormodel: [struct] alpha_channel_support: NO alpha_premultiplied: NO bits_component_1: 8 bits_component_2: 8 bits_component_3: 8 colormodel_type: ComponentColorModel colorspace: Any of the family of RGB color spaces num_color_components: 3 num_components: 3 pixel_size: 24 transparency: OPAQUE height: 768 source: ...\killer.jpg width: 1024 NOTE: my dev server *DOES NOT* have the 71557 cfimage hotfix installed (http://www.adobe.com/go/kb403411) Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ On 09/06/2009 21:59, Adrian Lynch wrote: Hey, thanks Jason, I did the blackout myself. It's an image for an awards show so I thought it best to mask it. It is RGB, CMYK was our first thought too. Adrian -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: 09 June 2009 15:54 To: cf-talk Subject: re: Image killing server Just looking at the link you sent in a browser, the image is nearly all black, which makes me think it's a CMYK jpeg, instead of an RGB jpeg. Browsers and the Adobe image engine can't handle the CMYK ... that's my guess. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323270 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How would you approach this? Shared Calender? Any volunteers?
How about pushing your data in to Google Calendar. They have a nice API, and you can easily embed the calendar with a snippet of html/js. Additionally end users can embed your events into their own personal Google Calendar to easily keep track of events. If you don't want to go that route, just give them a snippet of html/js or an iframe that pulls the calendar in from your site. Then you have full control over it and will never have an issue of getting all the other sites to update to the latest calendar code or whatever. -Ryan Al Musella, DPM wrote: I created a group of 50 brain tumor organizations and need to create a calender that each member can insert into their own website, but takes the data from my website.. I see a lot of sample code out there for creating the actual calander, but I am thinking about how to actually implement it to make it easy for people to put into their own websites.. what would be best and easiest for the members? Maybe use an iframe with the source being the calander on my website? maybe a flash or flex applet? I could do the iframe with a standard cf page myself.. but I never used flex and just basic stuff with flash. Anyone want to volunteer to help on this? Contact me privately muse...@virtualtrials.com Al ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323271 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Image killing server
Ah, interesting! -Original Message- From: Azadi Saryev [mailto:az...@sabai-dee.com] Sent: 09 June 2009 16:24 To: cf-talk Subject: Re: Image killing server hmm... worked just fine on my dev server... cfset myimage = ImageRead(ExpandPath(./killer.jpg)) cfdump var=#myimage# format=text dumped me this nice struct: struct colormodel: [struct] alpha_channel_support: NO alpha_premultiplied: NO bits_component_1: 8 bits_component_2: 8 bits_component_3: 8 colormodel_type: ComponentColorModel colorspace: Any of the family of RGB color spaces num_color_components: 3 num_components: 3 pixel_size: 24 transparency: OPAQUE height: 768 source: ...\killer.jpg width: 1024 NOTE: my dev server *DOES NOT* have the 71557 cfimage hotfix installed (http://www.adobe.com/go/kb403411) Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ On 09/06/2009 21:59, Adrian Lynch wrote: Hey, thanks Jason, I did the blackout myself. It's an image for an awards show so I thought it best to mask it. It is RGB, CMYK was our first thought too. Adrian -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: 09 June 2009 15:54 To: cf-talk Subject: re: Image killing server Just looking at the link you sent in a browser, the image is nearly all black, which makes me think it's a CMYK jpeg, instead of an RGB jpeg. Browsers and the Adobe image engine can't handle the CMYK ... that's my guess. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323272 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Image killing server
Adrian, What version, what build and what platform (Linux, windows, etc)? -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Adrian Lynch [mailto:cont...@adrianlynch.co.uk] Sent: Tuesday, June 09, 2009 9:43 AM To: cf-talk Subject: Image killing server Hey all, got a bit of a strange one here. A user is uploading an image which GIMP is reporting to have an embedded colour profile of . When I use any of the image functions on this image, CF dies. I posted a while ago but because it was only one user we converted it manually and re-uploaded, now we're getting more of them. Could I ask for a sanity check by someone confirming that this image is killing their server too? http://www.halestorm.co.uk/images/killer.jpg Download it, create a .cfm page and do ImageRead(ExpandPath(./killer.jpg)) I get a blank page back then on refresh a message saying CF is starting up. I'm on the bug report page at the moment but I thought I would get someone else to test this also. Thanks. Adrian Lynch | www.halestorm.co.uk ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323273 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Image killing server
Adrian, I verified your results on an 8.01 dev server running on my local XP box. Sure enough the service restarts. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Adrian Lynch [mailto:cont...@adrianlynch.co.uk] Sent: Tuesday, June 09, 2009 9:43 AM To: cf-talk Subject: Image killing server Hey all, got a bit of a strange one here. A user is uploading an image which GIMP is reporting to have an embedded colour profile of . When I use any of the image functions on this image, CF dies. I posted a while ago but because it was only one user we converted it manually and re-uploaded, now we're getting more of them. Could I ask for a sanity check by someone confirming that this image is killing their server too? http://www.halestorm.co.uk/images/killer.jpg Download it, create a .cfm page and do ImageRead(ExpandPath(./killer.jpg)) I get a blank page back then on refresh a message saying CF is starting up. I'm on the bug report page at the moment but I thought I would get someone else to test this also. Thanks. Adrian Lynch | www.halestorm.co.uk ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323274 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Image killing server
Follow up: I can verify the image is able to be previewed and edited using fireworks. I can't see anything unusual about it. I have to say if it's a something that is reproducible, it's going to be an attack vector. I can think of 3 or 4 servers I manage that need a fix for this pretty quickly if it becomes common knowledge. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Mark Kruger [mailto:mkru...@cfwebtools.com] Sent: Tuesday, June 09, 2009 10:27 AM To: cf-talk Subject: RE: Image killing server Adrian, I verified your results on an 8.01 dev server running on my local XP box. Sure enough the service restarts. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Adrian Lynch [mailto:cont...@adrianlynch.co.uk] Sent: Tuesday, June 09, 2009 9:43 AM To: cf-talk Subject: Image killing server Hey all, got a bit of a strange one here. A user is uploading an image which GIMP is reporting to have an embedded colour profile of . When I use any of the image functions on this image, CF dies. I posted a while ago but because it was only one user we converted it manually and re-uploaded, now we're getting more of them. Could I ask for a sanity check by someone confirming that this image is killing their server too? http://www.halestorm.co.uk/images/killer.jpg Download it, create a .cfm page and do ImageRead(ExpandPath(./killer.jpg)) I get a blank page back then on refresh a message saying CF is starting up. I'm on the bug report page at the moment but I thought I would get someone else to test this also. Thanks. Adrian Lynch | www.halestorm.co.uk ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323275 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
(ot) Little help with IIS URL Rewrite..
I'm trying to see if there's a way to basically set up one rule to run the site... So, I'm looking at URLs like: www.mysite.com/wagons/red/small Below works: Rule: ^com/([_0-9a-z-]+)/([_0-9a-z-]+)/([_0-9a-z-]+) ...or, a little more open ended: ^([^/]+)/([^/]+)/([^/]+)/?$ Map either to and it works: www.mysite.com/test.cfm?var1={R:1}var2={R:2}var3={R:3} Here's where my head starts to hurt though... 1. {R1} will always be a specific section (folder) for the site and always exist. No big deal. 2. {R2} and {R3} could be anything - work, date, whatever - depending on the section {R1}. No problem here either. 3. Here's my problem. {R2} and {R3} may or may NOT always exist. So, we could have www.mysite.com/wagons/red/ or www.mysite.com/wagons/. Current rules above will error with either of these because the patter no longer matches. I see how to do this with three rules, but that seems stupid to do. 4. If there's a .cfm (which makes this sorta no too bad off-topic) extension anywhere, ignore the whole thing. Can one rule do this? I'm still reading regex/IIS rewrite stuff on blogs and such. If anybody has a good reference for my specific instance above I'd appreciate it! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323276 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Image killing server
Thanks Mark. You're right, I'm beginning to think I shouldn't have posted it on here now. I've submitted a bug report to Adobe. When I open it in GIMP I get told The image 'killer.jpg' has an embedded colour profile: eciRGB v2 ICCv4. cftry/cfcatch doesn't help so the only way I can think of to spot this prior to using ImageRead() etc. is to read the file in with cffile and look for eciRGB v2 ICCv4. But who's to say that will cover all the bases? Adrian -Original Message- From: Mark Kruger [mailto:mkru...@cfwebtools.com] Sent: 09 June 2009 16:32 To: cf-talk Subject: RE: Image killing server Follow up: I can verify the image is able to be previewed and edited using fireworks. I can't see anything unusual about it. I have to say if it's a something that is reproducible, it's going to be an attack vector. I can think of 3 or 4 servers I manage that need a fix for this pretty quickly if it becomes common knowledge. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Mark Kruger [mailto:mkru...@cfwebtools.com] Sent: Tuesday, June 09, 2009 10:27 AM To: cf-talk Subject: RE: Image killing server Adrian, I verified your results on an 8.01 dev server running on my local XP box. Sure enough the service restarts. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Adrian Lynch [mailto:cont...@adrianlynch.co.uk] Sent: Tuesday, June 09, 2009 9:43 AM To: cf-talk Subject: Image killing server Hey all, got a bit of a strange one here. A user is uploading an image which GIMP is reporting to have an embedded colour profile of . When I use any of the image functions on this image, CF dies. I posted a while ago but because it was only one user we converted it manually and re-uploaded, now we're getting more of them. Could I ask for a sanity check by someone confirming that this image is killing their server too? http://www.halestorm.co.uk/images/killer.jpg Download it, create a .cfm page and do ImageRead(ExpandPath(./killer.jpg)) I get a blank page back then on refresh a message saying CF is starting up. I'm on the bug report page at the moment but I thought I would get someone else to test this also. Thanks. Adrian Lynch | www.halestorm.co.uk ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323277 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Image killing server
Adrian, FYI: CF 9 and Ralio handle this file ok (according to my friend and colleague Ryan Stille). I don't know what to make of that embedded color profile information. I wouldn't worry about posting it - get it out in the open and let's deal with it :) -Mark -Original Message- From: Adrian Lynch [mailto:cont...@adrianlynch.co.uk] Sent: Tuesday, June 09, 2009 10:49 AM To: cf-talk Subject: RE: Image killing server Thanks Mark. You're right, I'm beginning to think I shouldn't have posted it on here now. I've submitted a bug report to Adobe. When I open it in GIMP I get told The image 'killer.jpg' has an embedded colour profile: eciRGB v2 ICCv4. cftry/cfcatch doesn't help so the only way I can think of to spot this prior to using ImageRead() etc. is to read the file in with cffile and look for eciRGB v2 ICCv4. But who's to say that will cover all the bases? Adrian -Original Message- From: Mark Kruger [mailto:mkru...@cfwebtools.com] Sent: 09 June 2009 16:32 To: cf-talk Subject: RE: Image killing server Follow up: I can verify the image is able to be previewed and edited using fireworks. I can't see anything unusual about it. I have to say if it's a something that is reproducible, it's going to be an attack vector. I can think of 3 or 4 servers I manage that need a fix for this pretty quickly if it becomes common knowledge. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Mark Kruger [mailto:mkru...@cfwebtools.com] Sent: Tuesday, June 09, 2009 10:27 AM To: cf-talk Subject: RE: Image killing server Adrian, I verified your results on an 8.01 dev server running on my local XP box. Sure enough the service restarts. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Adrian Lynch [mailto:cont...@adrianlynch.co.uk] Sent: Tuesday, June 09, 2009 9:43 AM To: cf-talk Subject: Image killing server Hey all, got a bit of a strange one here. A user is uploading an image which GIMP is reporting to have an embedded colour profile of . When I use any of the image functions on this image, CF dies. I posted a while ago but because it was only one user we converted it manually and re-uploaded, now we're getting more of them. Could I ask for a sanity check by someone confirming that this image is killing their server too? http://www.halestorm.co.uk/images/killer.jpg Download it, create a .cfm page and do ImageRead(ExpandPath(./killer.jpg)) I get a blank page back then on refresh a message saying CF is starting up. I'm on the bug report page at the moment but I thought I would get someone else to test this also. Thanks. Adrian Lynch | www.halestorm.co.uk ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323278 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Miles per gallon...
After speaking with John Henderson and Josh Wolter, here's what we think might be the best approach. 1) We receive data for MPG from JATO and/or the dealerships. a) If the dealer sends us data we dump that into the mpg column. b) if they do not send us data, we use whatever JATO sends us 2) We add MPG as a selectable field for listings pages. The data would display on listings pages (sortable, and filterable), but there would be no fuel pump icon. 3) We add MPG as a selectable field for details pages. If enabled, we display the fuel pump icon along with the data. 4) In our disclaimers some of the things we need to address are: a) MPG differences based on different engine, transmission, or other options. b) do we allow dealers to display MPG for used cars, or do we just make sure our disclaimer covers when this car was manfactured, the MPG was...? 5) For JATO data, this is the format (on the listings pages) that we were thinking of using: city: 23 / hwy: 29 are there any objections to that? As an aside, I just spot-checked sites from dealer.com, clickmotive, and reyrey and none of them showed MPG on listings pages. Reyrey sites didn't even show MPG on the details page. andy -Original Message- From: Chris Redmond [mailto:credm...@dealerskins.com] Sent: Monday, June 08, 2009 4:56 PM To: 'Andy Matthews' Cc: 'Eric Brown' Subject: RE: Miles per gallon... 1) We receive MPG (split between city and state) from JATO. We also have the ability to receive MPG data directly from dealers. We need to decide which data takes precedence. Dealer should override but the jato info should be standard... 2) Displaying the fuel pump icon on the details page is relatively straightforward. There were rumors though that we also wanted to display the fuel pump icon at a smaller size on the listings page. If this is true, then that's going to be more difficult and time consuming. The fuel pump is kind of the standard... it draws attention to it. 3) We need a disclaimer added to the default copy regarding MPG display, I'd assume this would come from Anne. Just need to see if California has any weird rules... Chris R. Redmond Regional Sales Manager Cell: 704.307.0797 Fax: 704.973.0853 ch...@dealerskins.com www.dealerskins.com -Original Message- From: Andy Matthews [mailto:amatth...@dealerskins.com] Sent: Monday, June 08, 2009 5:47 PM To: 'Eric Brown' Cc: 'Chris Redmond'; Aaron West Subject: RE: Miles per gallon... Roger that. Chris/Eric...let me run a few things past you so that I know how to proceed. We have two main locations we want to display the MPG; listings pages, and details pages. The simplest way for us to get this into Autobahn would be to treat MPG as any other piece of inventory data. This would allow MPG to appear as a column in the listings page, it could be sorted, filtered, and would be easy to display. For the details page, we would prominently display the fuel pump icon, along with the data received. We have a few challenges though. 1) We receive MPG (split between city and state) from JATO. We also have the ability to receive MPG data directly from dealers. We need to decide which data takes precedence. 2) Displaying the fuel pump icon on the details page is relatively straightforward. There were rumors though that we also wanted to display the fuel pump icon at a smaller size on the listings page. If this is true, then that's going to be more difficult and time consuming. 3) We need a disclaimer added to the default copy regarding MPG display, I'd assume this would come from Anne. Andy Matthews Senior Web Developer www.dealerskins.com Total customer satisfaction is my number 1 priority! If you are not completely satisfied with the service I have provided, please let me know right away so I can correct the problem, or notify my manager Aaron West at aw...@dealerskins.com. -Original Message- From: Eric Brown [mailto:ebr...@dealerskins.com] Sent: Monday, June 08, 2009 4:15 PM To: Andy Matthews Cc: Chris Redmond Subject: Re: Miles per gallon... Actually Chris Redmond is best here...he has dealt with a number of dealers who have requested...but of course I'll be by to offer my two cents worth..eric On 6/8/09 4:03 PM, Andy Matthews amatth...@dealerskins.com wrote: Eric... Could I have a few minutes of your time to discuss MPG? I'm tasked with including it into Autobahn and I'd like to see if you have any specific input as to where (or how) it should appear. I'm planning on making it available for dealers to include in listings pages, and the details page. Andy Matthews Senior Web Developer www.dealerskins.com P Please consider the environment before printing this e-mail. Total customer satisfaction is my number 1 priority! If you are not completely satisfied with the service I have provided, please let me know right away so I can correct the problem, or notify my
RE: Miles per gallon...
Hey, that sounds great How can we help :) Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Andy Matthews [mailto:amatth...@dealerskins.com] Sent: Tuesday, June 09, 2009 11:44 AM To: cf-talk Subject: RE: Miles per gallon... After speaking with John Henderson and Josh Wolter, here's what we think might be the best approach. 1) We receive data for MPG from JATO and/or the dealerships. a) If the dealer sends us data we dump that into the mpg column. b) if they do not send us data, we use whatever JATO sends us 2) We add MPG as a selectable field for listings pages. The data would display on listings pages (sortable, and filterable), but there would be no fuel pump icon. 3) We add MPG as a selectable field for details pages. If enabled, we display the fuel pump icon along with the data. 4) In our disclaimers some of the things we need to address are: a) MPG differences based on different engine, transmission, or other options. b) do we allow dealers to display MPG for used cars, or do we just make sure our disclaimer covers when this car was manfactured, the MPG was...? 5) For JATO data, this is the format (on the listings pages) that we were thinking of using: city: 23 / hwy: 29 are there any objections to that? As an aside, I just spot-checked sites from dealer.com, clickmotive, and reyrey and none of them showed MPG on listings pages. Reyrey sites didn't even show MPG on the details page. andy -Original Message- From: Chris Redmond [mailto:credm...@dealerskins.com] Sent: Monday, June 08, 2009 4:56 PM To: 'Andy Matthews' Cc: 'Eric Brown' Subject: RE: Miles per gallon... 1) We receive MPG (split between city and state) from JATO. We also have the ability to receive MPG data directly from dealers. We need to decide which data takes precedence. Dealer should override but the jato info should be standard... 2) Displaying the fuel pump icon on the details page is relatively straightforward. There were rumors though that we also wanted to display the fuel pump icon at a smaller size on the listings page. If this is true, then that's going to be more difficult and time consuming. The fuel pump is kind of the standard... it draws attention to it. 3) We need a disclaimer added to the default copy regarding MPG display, I'd assume this would come from Anne. Just need to see if California has any weird rules... Chris R. Redmond Regional Sales Manager Cell: 704.307.0797 Fax: 704.973.0853 ch...@dealerskins.com www.dealerskins.com -Original Message- From: Andy Matthews [mailto:amatth...@dealerskins.com] Sent: Monday, June 08, 2009 5:47 PM To: 'Eric Brown' Cc: 'Chris Redmond'; Aaron West Subject: RE: Miles per gallon... Roger that. Chris/Eric...let me run a few things past you so that I know how to proceed. We have two main locations we want to display the MPG; listings pages, and details pages. The simplest way for us to get this into Autobahn would be to treat MPG as any other piece of inventory data. This would allow MPG to appear as a column in the listings page, it could be sorted, filtered, and would be easy to display. For the details page, we would prominently display the fuel pump icon, along with the data received. We have a few challenges though. 1) We receive MPG (split between city and state) from JATO. We also have the ability to receive MPG data directly from dealers. We need to decide which data takes precedence. 2) Displaying the fuel pump icon on the details page is relatively straightforward. There were rumors though that we also wanted to display the fuel pump icon at a smaller size on the listings page. If this is true, then that's going to be more difficult and time consuming. 3) We need a disclaimer added to the default copy regarding MPG display, I'd assume this would come from Anne. Andy Matthews Senior Web Developer www.dealerskins.com Total customer satisfaction is my number 1 priority! If you are not completely satisfied with the service I have provided, please let me know right away so I can correct the problem, or notify my manager Aaron West at aw...@dealerskins.com. -Original Message- From: Eric Brown [mailto:ebr...@dealerskins.com] Sent: Monday, June 08, 2009 4:15 PM To: Andy Matthews Cc: Chris Redmond Subject: Re: Miles per gallon... Actually Chris Redmond is best here...he has dealt with a number of dealers who have requested...but of course I'll be by to offer my two cents worth..eric On 6/8/09 4:03 PM, Andy Matthews amatth...@dealerskins.com wrote: Eric... Could I have a few minutes of your time to discuss MPG? I'm tasked with including it into Autobahn and I'd like to see if you have any specific input as to where (or how) it should appear. I'm planning on making it available for dealers to include in listings pages, and the details page. Andy
RE: Miles per gallon...
Wrong email address...apologies. -Original Message- From: Andy Matthews [mailto:amatth...@dealerskins.com] Sent: Tuesday, June 09, 2009 11:44 AM To: cf-talk Subject: RE: Miles per gallon... After speaking with John Henderson and Josh Wolter, here's what we think might be the best approach. 1) We receive data for MPG from JATO and/or the dealerships. a) If the dealer sends us data we dump that into the mpg column. b) if they do not send us data, we use whatever JATO sends us 2) We add MPG as a selectable field for listings pages. The data would display on listings pages (sortable, and filterable), but there would be no fuel pump icon. 3) We add MPG as a selectable field for details pages. If enabled, we display the fuel pump icon along with the data. 4) In our disclaimers some of the things we need to address are: a) MPG differences based on different engine, transmission, or other options. b) do we allow dealers to display MPG for used cars, or do we just make sure our disclaimer covers when this car was manfactured, the MPG was...? 5) For JATO data, this is the format (on the listings pages) that we were thinking of using: city: 23 / hwy: 29 are there any objections to that? As an aside, I just spot-checked sites from dealer.com, clickmotive, and reyrey and none of them showed MPG on listings pages. Reyrey sites didn't even show MPG on the details page. andy -Original Message- From: Chris Redmond [mailto:credm...@dealerskins.com] Sent: Monday, June 08, 2009 4:56 PM To: 'Andy Matthews' Cc: 'Eric Brown' Subject: RE: Miles per gallon... 1) We receive MPG (split between city and state) from JATO. We also have the ability to receive MPG data directly from dealers. We need to decide which data takes precedence. Dealer should override but the jato info should be standard... 2) Displaying the fuel pump icon on the details page is relatively straightforward. There were rumors though that we also wanted to display the fuel pump icon at a smaller size on the listings page. If this is true, then that's going to be more difficult and time consuming. The fuel pump is kind of the standard... it draws attention to it. 3) We need a disclaimer added to the default copy regarding MPG display, I'd assume this would come from Anne. Just need to see if California has any weird rules... Chris R. Redmond Regional Sales Manager Cell: 704.307.0797 Fax: 704.973.0853 ch...@dealerskins.com www.dealerskins.com -Original Message- From: Andy Matthews [mailto:amatth...@dealerskins.com] Sent: Monday, June 08, 2009 5:47 PM To: 'Eric Brown' Cc: 'Chris Redmond'; Aaron West Subject: RE: Miles per gallon... Roger that. Chris/Eric...let me run a few things past you so that I know how to proceed. We have two main locations we want to display the MPG; listings pages, and details pages. The simplest way for us to get this into Autobahn would be to treat MPG as any other piece of inventory data. This would allow MPG to appear as a column in the listings page, it could be sorted, filtered, and would be easy to display. For the details page, we would prominently display the fuel pump icon, along with the data received. We have a few challenges though. 1) We receive MPG (split between city and state) from JATO. We also have the ability to receive MPG data directly from dealers. We need to decide which data takes precedence. 2) Displaying the fuel pump icon on the details page is relatively straightforward. There were rumors though that we also wanted to display the fuel pump icon at a smaller size on the listings page. If this is true, then that's going to be more difficult and time consuming. 3) We need a disclaimer added to the default copy regarding MPG display, I'd assume this would come from Anne. Andy Matthews Senior Web Developer www.dealerskins.com Total customer satisfaction is my number 1 priority! If you are not completely satisfied with the service I have provided, please let me know right away so I can correct the problem, or notify my manager Aaron West at aw...@dealerskins.com. -Original Message- From: Eric Brown [mailto:ebr...@dealerskins.com] Sent: Monday, June 08, 2009 4:15 PM To: Andy Matthews Cc: Chris Redmond Subject: Re: Miles per gallon... Actually Chris Redmond is best here...he has dealt with a number of dealers who have requested...but of course I'll be by to offer my two cents worth..eric On 6/8/09 4:03 PM, Andy Matthews amatth...@dealerskins.com wrote: Eric... Could I have a few minutes of your time to discuss MPG? I'm tasked with including it into Autobahn and I'd like to see if you have any specific input as to where (or how) it should appear. I'm planning on making it available for dealers to include in listings pages, and the details page. Andy Matthews Senior Web Developer www.dealerskins.com P Please consider the environment before printing this e-mail. Total
RE: Image killing server
Adrian, I'm working through this problem on another list and I'll try to keep you up to date. I found the following exception in the *-out.log along with a good deal more detail in an hs_err log. You might look for those - although I'm not sure they will tell you anything. -Mark # # An unexpected error has been detected by Java Runtime Environment: # # EXCEPTION_ACCESS_VIOLATION (0xc005) at pc=0x7c910f1e, pid=4948, tid=5340 # # Java VM: Java HotSpot(TM) Server VM (10.0-b19 mixed mode windows-x86) # Problematic frame: # C [ntdll.dll+0x10f1e] # # An error report file with more information is saved as: # C:\ColdFusion8\runtime\bin\hs_err_pid4948.log # # If you would like to submit a bug report, please visit: # http://java.sun.com/webapps/bugreport/crash.jsp # The crash happened outside the Java Virtual Machine in native code. # See problematic frame for where to report the bug. # Starting Macromedia JRun 4.0 (Build 108673), coldfusion server ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323282 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SOA Coldfusion best practices
That was actually pretty funny, but yes I have done searches on the subject and come back a lot of info. I guess I was hoping to find out which approach people leaned towards and it there were any pitfalls people have run into. Tim I hate to do this, but, did you try http://tinyurl.com/nx44fe ? nathan strutz [Blog and Family @ http://www.dopefly.com/] [AZCFUG Manager @ http://www.azcfug.org/] [Twitter @nathanstrutz] Are there any good sites or presentations that people can recommend for best practices when implementing a SOA architecture using ColdFusion? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323283 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOA Coldfusion best practices
That was actually pretty funny, but yes I have done searches on the subject and come back a lot of info. I guess I was hoping to find out which approach people leaned towards and it there were any pitfalls people have run into. Tim I hate to do this, but, did you try http://tinyurl.com/nx44fe ? nathan strutz [Blog and Family @ http://www.dopefly.com/] [AZCFUG Manager @ http://www.azcfug.org/] [Twitter @nathanstrutz] Are there any good sites or presentations that people can recommend for best practices when implementing a SOA architecture using ColdFusion? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323284 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOA Coldfusion best practices
Who are you kidding, you loved doing that. Like and Rodgers and Hammerstein put it These are a few of my favorite things For what it is worth. There is also a segment on the lynda.comColdfusion 8 beyond the basics video tutes that deals with packaging data for web services such that it is cross platform. Basically a how-to for creating and consuming web services using arrays of structures, which is a really handy way package cfquery record sets. G! On Mon, Jun 8, 2009 at 6:27 PM, David McGuigan davidmcgui...@gmail.comwrote: Who are you kidding, you loved doing that. On Mon, Jun 8, 2009 at 4:14 PM, Nathan Strutz str...@gmail.com wrote: I hate to do this, but, did you try http://tinyurl.com/nx44fe ? -- Gerald Guido http://www.myinternetisbroken.com http://www.cfsimple.org/ To invent, you need a good imagination and a pile of junk. -- Thomas A. Edison ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323285 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SOA Coldfusion best practices
In all reality, the best thing I've seen on the subject is Sean Corfield's PDF preso - the first result in that google search. As far as getting into it and engaging in discussions and asking am I doing this right? type questions, you can ask here, but the ColdSpring mailing list is probably a better resource for that (http://coldspringframework.org). nathan strutz [Blog and Family @ http://www.dopefly.com/] [AZCFUG Manager @ http://www.azcfug.org/] [Twitter @nathanstrutz] On Tue, Jun 9, 2009 at 9:55 AM, Tim Oommen toom...@duoconsulting.comwrote: That was actually pretty funny, but yes I have done searches on the subject and come back a lot of info. I guess I was hoping to find out which approach people leaned towards and it there were any pitfalls people have run into. Tim I hate to do this, but, did you try http://tinyurl.com/nx44fe ? nathan strutz [Blog and Family @ http://www.dopefly.com/] [AZCFUG Manager @ http://www.azcfug.org/] [Twitter @nathanstrutz] Are there any good sites or presentations that people can recommend for best practices when implementing a SOA architecture using ColdFusion? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323286 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Send a textbox value to an object
I have an object in ColdFusion that post message to twitter. It works well when I write my message in â â like line below. cfset twitterObj.postToTwitter My Message / But I need to have a textbox, and type my message in textbox. Iâm not sure how can get my textbox value here instead of this message, every think I tried give me an error. Can anybody help? This is my code. BODY form action=Form.cfm method=post input type=text name=twittMessage input type=Submit name=SubmitForm value=Submit to Twitter cfif IsDefined(Form.twittMessage) br cfoutputYour message postet to twitter/cfoutput /cfif /form !--- call the init() method --- cfset twitterObj = createObject('component', 'twitterCFC').init ('username','password') / !--- Post to twitter --- //here is problem - How I can get the value of textbox here instead of (My message to poet is here) for example I thought it's Form.twittMessage but it doesnât work. * cfset twitterObj.postToTwitter (My message to poet is here)/ ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323287 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOA Coldfusion best practices
I'd suggest the CFCDev Google groups mailing list as well. It is kind of a higher-level best practices in Object Oriented development list. On Tue, Jun 9, 2009 at 11:16 AM, Nathan Strutzstr...@gmail.com wrote: In all reality, the best thing I've seen on the subject is Sean Corfield's PDF preso - the first result in that google search. As far as getting into it and engaging in discussions and asking am I doing this right? type questions, you can ask here, but the ColdSpring mailing list is probably a better resource for that (http://coldspringframework.org). nathan strutz [Blog and Family @ http://www.dopefly.com/] [AZCFUG Manager @ http://www.azcfug.org/] [Twitter @nathanstrutz] On Tue, Jun 9, 2009 at 9:55 AM, Tim Oommen toom...@duoconsulting.comwrote: That was actually pretty funny, but yes I have done searches on the subject and come back a lot of info. I guess I was hoping to find out which approach people leaned towards and it there were any pitfalls people have run into. Tim I hate to do this, but, did you try http://tinyurl.com/nx44fe ? nathan strutz [Blog and Family @ http://www.dopefly.com/] [AZCFUG Manager @ http://www.azcfug.org/] [Twitter @nathanstrutz] Are there any good sites or presentations that people can recommend for best practices when implementing a SOA architecture using ColdFusion? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323288 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: (ot) Little help with IIS URL Rewrite..
Try this: ^com/([_0-9a-z-]+)(?:/([_0-9a-z-]+)(?:/([_0-9a-z-]+))?)?/?$ It uses non-capturing groups and the optional quantifier to allow but not require the final two parts. And of course the less restrictive one is the same: ^com/([^/]+)(?:/([^/]+)(?:/([^/]+))?)?/?$ ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323289 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Sitewide Error Handler and IFrames
Is there a reason why the iframe would not pick up the sitewide error handler in the iframe and display the user friendly error page and instead just display a standard CF error? There's nothing about iframes specifically that would cause this, no. Perhaps there's an error in your error page when invoked from the iframe? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323290 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Sitewide Error Handler and IFrames
I am not seeing signs of that Dave. That is what is odd. One would think that the iframe would be treated the same as any other window. Usually when there is an error in the handler or in any associated pages to it, you get the error that triggered the handler in the fiorst place and then underneath that you get a message saying that there was an internal error...makes for a real PIA to debug. That was one of the first things I looked for when our team leader pointed that out. You get the same error page that you would get if the site wide handler was not specified. Eric On Tue, Jun 9, 2009 at 3:45 PM, Dave Watts dwa...@figleaf.com wrote: Is there a reason why the iframe would not pick up the sitewide error handler in the iframe and display the user friendly error page and instead just display a standard CF error? There's nothing about iframes specifically that would cause this, no. Perhaps there's an error in your error page when invoked from the iframe? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323291 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Sitewide Error Handler and IFrames
Is the site-wide error template displayed when you hit the URL of the iframe directly? Francois Levesque http://blog.critical-web.com/ On Tue, Jun 9, 2009 at 4:53 PM, Eric Roberts ow...@threeravensconsulting.com wrote: I am not seeing signs of that Dave. That is what is odd. One would think that the iframe would be treated the same as any other window. Usually when there is an error in the handler or in any associated pages to it, you get the error that triggered the handler in the fiorst place and then underneath that you get a message saying that there was an internal error...makes for a real PIA to debug. That was one of the first things I looked for when our team leader pointed that out. You get the same error page that you would get if the site wide handler was not specified. Eric On Tue, Jun 9, 2009 at 3:45 PM, Dave Watts dwa...@figleaf.com wrote: Is there a reason why the iframe would not pick up the sitewide error handler in the iframe and display the user friendly error page and instead just display a standard CF error? There's nothing about iframes specifically that would cause this, no. Perhaps there's an error in your error page when invoked from the iframe? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323292 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Sitewide Error Handler and IFrames
hmmm...let me see if i can do that On Tue, Jun 9, 2009 at 3:55 PM, Francois Levesque cfab...@gmail.com wrote: Is the site-wide error template displayed when you hit the URL of the iframe directly? Francois Levesque http://blog.critical-web.com/ On Tue, Jun 9, 2009 at 4:53 PM, Eric Roberts ow...@threeravensconsulting.com wrote: I am not seeing signs of that Dave. That is what is odd. One would think that the iframe would be treated the same as any other window. Usually when there is an error in the handler or in any associated pages to it, you get the error that triggered the handler in the fiorst place and then underneath that you get a message saying that there was an internal error...makes for a real PIA to debug. That was one of the first things I looked for when our team leader pointed that out. You get the same error page that you would get if the site wide handler was not specified. Eric On Tue, Jun 9, 2009 at 3:45 PM, Dave Watts dwa...@figleaf.com wrote: Is there a reason why the iframe would not pick up the sitewide error handler in the iframe and display the user friendly error page and instead just display a standard CF error? There's nothing about iframes specifically that would cause this, no. Perhaps there's an error in your error page when invoked from the iframe? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323293 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Sitewide Error Handler and IFrames
No it doesn't. I am getting a QonQ runtime error...could that be why the sitewide handler is not catching it? Eric On Tue, Jun 9, 2009 at 4:00 PM, Eric Roberts ow...@threeravensconsulting.com wrote: hmmm...let me see if i can do that On Tue, Jun 9, 2009 at 3:55 PM, Francois Levesque cfab...@gmail.comwrote: Is the site-wide error template displayed when you hit the URL of the iframe directly? Francois Levesque http://blog.critical-web.com/ On Tue, Jun 9, 2009 at 4:53 PM, Eric Roberts ow...@threeravensconsulting.com wrote: I am not seeing signs of that Dave. That is what is odd. One would think that the iframe would be treated the same as any other window. Usually when there is an error in the handler or in any associated pages to it, you get the error that triggered the handler in the fiorst place and then underneath that you get a message saying that there was an internal error...makes for a real PIA to debug. That was one of the first things I looked for when our team leader pointed that out. You get the same error page that you would get if the site wide handler was not specified. Eric On Tue, Jun 9, 2009 at 3:45 PM, Dave Watts dwa...@figleaf.com wrote: Is there a reason why the iframe would not pick up the sitewide error handler in the iframe and display the user friendly error page and instead just display a standard CF error? There's nothing about iframes specifically that would cause this, no. Perhaps there's an error in your error page when invoked from the iframe? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323294 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Send a textbox value to an object
cfset twitterObj.postToTwitter(FORM.twittMessage) Adrian -Original Message- From: nikoo m [mailto:nikou...@yahoo.com] Sent: 09 June 2009 19:40 To: cf-talk Subject: Send a textbox value to an object I have an object in ColdFusion that post message to twitter. It works well when I write my message in ââ¬Å ââ¬Å like line below. cfset twitterObj.postToTwitter My Message / But I need to have a textbox, and type my message in textbox. Iââ¬â¢m not sure how can get my textbox value here instead of this message, every think I tried give me an error. Can anybody help? This is my code. BODY form action=Form.cfm method=post input type=text name=twittMessage input type=Submit name=SubmitForm value=Submit to Twitter cfif IsDefined(Form.twittMessage) br cfoutputYour message postet to twitter/cfoutput /cfif /form !--- call the init() method --- cfset twitterObj = createObject('component', 'twitterCFC').init ('username','password') / !--- Post to twitter --- //here is problem - How I can get the value of textbox here instead of (My message to poet is here) for example I thought it's Form.twittMessage but it doesnââ¬â¢t work. * cfset twitterObj.postToTwitter (My message to poet is here)/ ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323295 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Sitewide Error Handler and IFrames
I think I found the culprit...damn cftry blocks... Eric On Tue, Jun 9, 2009 at 4:10 PM, Eric Roberts ow...@threeravensconsulting.com wrote: No it doesn't. I am getting a QonQ runtime error...could that be why the sitewide handler is not catching it? Eric On Tue, Jun 9, 2009 at 4:00 PM, Eric Roberts ow...@threeravensconsulting.com wrote: hmmm...let me see if i can do that On Tue, Jun 9, 2009 at 3:55 PM, Francois Levesque cfab...@gmail.comwrote: Is the site-wide error template displayed when you hit the URL of the iframe directly? Francois Levesque http://blog.critical-web.com/ On Tue, Jun 9, 2009 at 4:53 PM, Eric Roberts ow...@threeravensconsulting.com wrote: I am not seeing signs of that Dave. That is what is odd. One would think that the iframe would be treated the same as any other window. Usually when there is an error in the handler or in any associated pages to it, you get the error that triggered the handler in the fiorst place and then underneath that you get a message saying that there was an internal error...makes for a real PIA to debug. That was one of the first things I looked for when our team leader pointed that out. You get the same error page that you would get if the site wide handler was not specified. Eric On Tue, Jun 9, 2009 at 3:45 PM, Dave Watts dwa...@figleaf.com wrote: Is there a reason why the iframe would not pick up the sitewide error handler in the iframe and display the user friendly error page and instead just display a standard CF error? There's nothing about iframes specifically that would cause this, no. Perhaps there's an error in your error page when invoked from the iframe? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323296 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Image killing server (RESOLVED)
Adrian, I have an explanation and a resolution for you. The problem is a buffer overrun in the ICC parser (a bit of color correction meta data that ships with the image). To resolve it I upgraded my JVM from 1.6.0_04 to 1.6.0_14 ... But _05 or above would do the trick I think. I'll write a blog on it and give a more thorough explanation - but meanwhile, I found my best clues by looking not for ColdFusion related image issues, but javax.imagaio related image issues. I found this post: http://www.securiteam.com/securitynews/5SP0E1PNQA.htm Which lead me more closely examine the update (build) number of my JVM install. I hope this helps you! -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Adrian Lynch [mailto:cont...@adrianlynch.co.uk] Sent: Tuesday, June 09, 2009 10:49 AM To: cf-talk Subject: RE: Image killing server Thanks Mark. You're right, I'm beginning to think I shouldn't have posted it on here now. I've submitted a bug report to Adobe. When I open it in GIMP I get told The image 'killer.jpg' has an embedded colour profile: eciRGB v2 ICCv4. cftry/cfcatch doesn't help so the only way I can think of to spot this prior to using ImageRead() etc. is to read the file in with cffile and look for eciRGB v2 ICCv4. But who's to say that will cover all the bases? Adrian -Original Message- From: Mark Kruger [mailto:mkru...@cfwebtools.com] Sent: 09 June 2009 16:32 To: cf-talk Subject: RE: Image killing server Follow up: I can verify the image is able to be previewed and edited using fireworks. I can't see anything unusual about it. I have to say if it's a something that is reproducible, it's going to be an attack vector. I can think of 3 or 4 servers I manage that need a fix for this pretty quickly if it becomes common knowledge. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Mark Kruger [mailto:mkru...@cfwebtools.com] Sent: Tuesday, June 09, 2009 10:27 AM To: cf-talk Subject: RE: Image killing server Adrian, I verified your results on an 8.01 dev server running on my local XP box. Sure enough the service restarts. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Adrian Lynch [mailto:cont...@adrianlynch.co.uk] Sent: Tuesday, June 09, 2009 9:43 AM To: cf-talk Subject: Image killing server Hey all, got a bit of a strange one here. A user is uploading an image which GIMP is reporting to have an embedded colour profile of . When I use any of the image functions on this image, CF dies. I posted a while ago but because it was only one user we converted it manually and re-uploaded, now we're getting more of them. Could I ask for a sanity check by someone confirming that this image is killing their server too? http://www.halestorm.co.uk/images/killer.jpg Download it, create a .cfm page and do ImageRead(ExpandPath(./killer.jpg)) I get a blank page back then on refresh a message saying CF is starting up. I'm on the bug report page at the moment but I thought I would get someone else to test this also. Thanks. Adrian Lynch | www.halestorm.co.uk ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323297 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFLOOP inside a CFQuery
Hello all, I have a dynamically generated form that I need to figure out how to get the data from that form in to our database. Here is the way it works. First the client types in the number of machines they have and the form generates the correct number of rows so that the info about each machine is located on a separate row. That all works well until they hit submit (or will hit submit if I figure out the next part). How do I create a cfquery that has the correct number of values so that each machines data is stored correctly? For example I will have row one with lets say three fields (Type, number, issue). Lets say a client has a problem with 10 machines. The form now has 10 rows with 3 columns in each. Each field in row one is named type1, number1, issue1 and row two is type2, number2, issue2, etc.. The number next to the name is placed there by putting the index of the loop in the name field. So this is where I was going to use a CFLOOP inside a CFquery to create field names dynamically. I can get it to repeate the information correctly, however the problem is the index of the loop does not seem to get attached to the form value I am putting into the database. I am doing something like: cfquery datasource=#request.datasource# INSERT into tbl_ballotOrder (type, number, issue) Values ( cfloop from=1 to=#rows# step=1 index=LoopCount '#FORM.type##LoopCount#', '#FORM.number##LoopCount#', '#FORM.issue##LoopCount#' /cfloop ) /cfquery /cfif ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323298 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFLOOP inside a CFQuery
Check the following link might help... http://tutorial431.easycfm.com/ Hello all, I have a dynamically generated form that I need to figure out how to get the data from that form in to our database. Here is the way it works. First the client types in the number of machines they have and the form generates the correct number of rows so that the info about each machine is located on a separate row. That all works well until they hit submit (or will hit submit if I figure out the next part). How do I create a cfquery that has the correct number of values so that each machines data is stored correctly? For example I will have row one with lets say three fields (Type, number, issue). Lets say a client has a problem with 10 machines. The form now has 10 rows with 3 columns in each. Each field in row one is named type1, number1, issue1 and row two is type2, number2, issue2, etc.. The number next to the name is placed there by putting the index of the loop in the name field. So this is where I was going to use a CFLOOP inside a CFquery to create field names dynamically. I can get it to repeate the information correctly, however the problem is the index of the loop does not seem to get attached to the form value I am putting into the database. I am doing something like: cfquery datasource=#request.datasource# INSERT into tbl_ballotOrder (type, number, issue) Values ( cfloop from=1 to=#rows# step=1 index=LoopCount '#FORM.type##LoopCount#', '#FORM.number##LoopCount#', '#FORM. issue##LoopCount#' /cfloop ) /cfquery /cfif ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323299 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFLOOP inside a CFQuery[RESOLVED]
Check the following link might help... http://tutorial431.easycfm.com/ Thank you! I was thinking I had to do something like this to get it to work. I just did not know exactly what it was I needed to do so searching for it was difficult. Thanks again! Will ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323300 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFLOOP inside a CFQuery
I agree with NK pay attention to the evaluate function. It works like a charm for dynamically created form variables. I use it often. :) -- Ryan LeTulle On Tue, Jun 9, 2009 at 6:30 PM, N K neetukais...@gmail.com wrote: Check the following link might help... http://tutorial431.easycfm.com/ Hello all, I have a dynamically generated form that I need to figure out how to get the data from that form in to our database. Here is the way it works. First the client types in the number of machines they have and the form generates the correct number of rows so that the info about each machine is located on a separate row. That all works well until they hit submit (or will hit submit if I figure out the next part). How do I create a cfquery that has the correct number of values so that each machines data is stored correctly? For example I will have row one with lets say three fields (Type, number, issue). Lets say a client has a problem with 10 machines. The form now has 10 rows with 3 columns in each. Each field in row one is named type1, number1, issue1 and row two is type2, number2, issue2, etc.. The number next to the name is placed there by putting the index of the loop in the name field. So this is where I was going to use a CFLOOP inside a CFquery to create field names dynamically. I can get it to repeate the information correctly, however the problem is the index of the loop does not seem to get attached to the form value I am putting into the database. I am doing something like: cfquery datasource=#request.datasource# INSERT into tbl_ballotOrder (type, number, issue) Values ( cfloop from=1 to=#rows# step=1 index=LoopCount '#FORM.type##LoopCount#', '#FORM.number##LoopCount#', '#FORM. issue##LoopCount#' /cfloop ) /cfquery /cfif ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323301 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFLOOP inside a CFQuery
You don't need evaluate for dynamically created form variables, in almost all cases the struct syntax #form['type'idx]# will suffice and is more efficient. For this particular scenario, evaluate is an unnecessary overhead and should be avoided. cfquery datasource=#request.datasource# cfloop from=1 to=#rows# index=idx INSERT INTO tbl_ballotOrder ( type, number, issue ) VALUES ( cfqueryparam value=#form['type'idx]# cfsqltype=cf_sql_varchar /, cfqueryparam value=#form['number'idx]# cfsqltype=cf_sql_integer /, cfqueryparam value=#form['issue'idx]# cfsqltype=cf_sql_varchar / ) /cfloop /cfquery May I also point out the use of CFQUERYPARAM. It's basic principles; unless you've got a damn fine reason not to, always use cfqueryparam. Protect yourself from SQL injection attacks, make your life easier. No offence intended, but Will I urge you to ignore the 'evaluate' based advice. Cheers, Gabriel -Original Message- From: Ryan Letulle [mailto:bayous...@gmail.com] Sent: Wednesday, 10 June 2009 10:25 AM To: cf-talk Subject: Re: CFLOOP inside a CFQuery I agree with NK pay attention to the evaluate function. It works like a charm for dynamically created form variables. I use it often. :) -- Ryan LeTulle On Tue, Jun 9, 2009 at 6:30 PM, N K neetukais...@gmail.com wrote: Check the following link might help... http://tutorial431.easycfm.com/ Hello all, I have a dynamically generated form that I need to figure out how to get the data from that form in to our database. Here is the way it works. First the client types in the number of machines they have and the form generates the correct number of rows so that the info about each machine is located on a separate row. That all works well until they hit submit (or will hit submit if I figure out the next part). How do I create a cfquery that has the correct number of values so that each machines data is stored correctly? For example I will have row one with lets say three fields (Type, number, issue). Lets say a client has a problem with 10 machines. The form now has 10 rows with 3 columns in each. Each field in row one is named type1, number1, issue1 and row two is type2, number2, issue2, etc.. The number next to the name is placed there by putting the index of the loop in the name field. So this is where I was going to use a CFLOOP inside a CFquery to create field names dynamically. I can get it to repeate the information correctly, however the problem is the index of the loop does not seem to get attached to the form value I am putting into the database. I am doing something like: cfquery datasource=#request.datasource# INSERT into tbl_ballotOrder (type, number, issue) Values ( cfloop from=1 to=#rows# step=1 index=LoopCount '#FORM.type##LoopCount#', '#FORM.number##LoopCount#', '#FORM. issue##LoopCount#' /cfloop ) /cfquery /cfif ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323302 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFLOOP inside a CFQuery
Interesting I've never seen any noticeable hit using evaluate but I have heard it should be avoided. (chose to ignore) I'll look into your suggestion though. I guess the question why even make evaluate available comes to mind if you should never use it? -- Ryan LeTulle On Tue, Jun 9, 2009 at 7:58 PM, Gabriel coldfus...@evolution7.com wrote: You don't need evaluate for dynamically created form variables, in almost all cases the struct syntax #form['type'idx]# will suffice and is more efficient. For this particular scenario, evaluate is an unnecessary overhead and should be avoided. cfquery datasource=#request.datasource# cfloop from=1 to=#rows# index=idx INSERT INTO tbl_ballotOrder ( type, number, issue ) VALUES ( cfqueryparam value=#form['type'idx]# cfsqltype=cf_sql_varchar /, cfqueryparam value=#form['number'idx]# cfsqltype=cf_sql_integer /, cfqueryparam value=#form['issue'idx]# cfsqltype=cf_sql_varchar / ) /cfloop /cfquery May I also point out the use of CFQUERYPARAM. It's basic principles; unless you've got a damn fine reason not to, always use cfqueryparam. Protect yourself from SQL injection attacks, make your life easier. No offence intended, but Will I urge you to ignore the 'evaluate' based advice. Cheers, Gabriel -Original Message- From: Ryan Letulle [mailto:bayous...@gmail.com] Sent: Wednesday, 10 June 2009 10:25 AM To: cf-talk Subject: Re: CFLOOP inside a CFQuery I agree with NK pay attention to the evaluate function. It works like a charm for dynamically created form variables. I use it often. :) -- Ryan LeTulle On Tue, Jun 9, 2009 at 6:30 PM, N K neetukais...@gmail.com wrote: Check the following link might help... http://tutorial431.easycfm.com/ Hello all, I have a dynamically generated form that I need to figure out how to get the data from that form in to our database. Here is the way it works. First the client types in the number of machines they have and the form generates the correct number of rows so that the info about each machine is located on a separate row. That all works well until they hit submit (or will hit submit if I figure out the next part). How do I create a cfquery that has the correct number of values so that each machines data is stored correctly? For example I will have row one with lets say three fields (Type, number, issue). Lets say a client has a problem with 10 machines. The form now has 10 rows with 3 columns in each. Each field in row one is named type1, number1, issue1 and row two is type2, number2, issue2, etc.. The number next to the name is placed there by putting the index of the loop in the name field. So this is where I was going to use a CFLOOP inside a CFquery to create field names dynamically. I can get it to repeate the information correctly, however the problem is the index of the loop does not seem to get attached to the form value I am putting into the database. I am doing something like: cfquery datasource=#request.datasource# INSERT into tbl_ballotOrder (type, number, issue) Values ( cfloop from=1 to=#rows# step=1 index=LoopCount '#FORM.type##LoopCount#', '#FORM.number##LoopCount#', '#FORM. issue##LoopCount#' /cfloop ) /cfquery /cfif ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323303 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFLOOP inside a CFQuery
@gabrieldoes the cfqueryparam matter or can you just use #form['type'idx]# in any way? -- Ryan LeTulle On Tue, Jun 9, 2009 at 7:58 PM, Gabriel coldfus...@evolution7.com wrote: You don't need evaluate for dynamically created form variables, in almost all cases the struct syntax #form['type'idx]# will suffice and is more efficient. For this particular scenario, evaluate is an unnecessary overhead and should be avoided. cfquery datasource=#request.datasource# cfloop from=1 to=#rows# index=idx INSERT INTO tbl_ballotOrder ( type, number, issue ) VALUES ( cfqueryparam value=#form['type'idx]# cfsqltype=cf_sql_varchar /, cfqueryparam value=#form['number'idx]# cfsqltype=cf_sql_integer /, cfqueryparam value=#form['issue'idx]# cfsqltype=cf_sql_varchar / ) /cfloop /cfquery May I also point out the use of CFQUERYPARAM. It's basic principles; unless you've got a damn fine reason not to, always use cfqueryparam. Protect yourself from SQL injection attacks, make your life easier. No offence intended, but Will I urge you to ignore the 'evaluate' based advice. Cheers, Gabriel -Original Message- From: Ryan Letulle [mailto:bayous...@gmail.com] Sent: Wednesday, 10 June 2009 10:25 AM To: cf-talk Subject: Re: CFLOOP inside a CFQuery I agree with NK pay attention to the evaluate function. It works like a charm for dynamically created form variables. I use it often. :) -- Ryan LeTulle On Tue, Jun 9, 2009 at 6:30 PM, N K neetukais...@gmail.com wrote: Check the following link might help... http://tutorial431.easycfm.com/ Hello all, I have a dynamically generated form that I need to figure out how to get the data from that form in to our database. Here is the way it works. First the client types in the number of machines they have and the form generates the correct number of rows so that the info about each machine is located on a separate row. That all works well until they hit submit (or will hit submit if I figure out the next part). How do I create a cfquery that has the correct number of values so that each machines data is stored correctly? For example I will have row one with lets say three fields (Type, number, issue). Lets say a client has a problem with 10 machines. The form now has 10 rows with 3 columns in each. Each field in row one is named type1, number1, issue1 and row two is type2, number2, issue2, etc.. The number next to the name is placed there by putting the index of the loop in the name field. So this is where I was going to use a CFLOOP inside a CFquery to create field names dynamically. I can get it to repeate the information correctly, however the problem is the index of the loop does not seem to get attached to the form value I am putting into the database. I am doing something like: cfquery datasource=#request.datasource# INSERT into tbl_ballotOrder (type, number, issue) Values ( cfloop from=1 to=#rows# step=1 index=LoopCount '#FORM.type##LoopCount#', '#FORM.number##LoopCount#', '#FORM. issue##LoopCount#' /cfloop ) /cfquery /cfif ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323304 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFLOOP inside a CFQuery
Ryan, You'll note that I said almost always and I never said never use it. There are times that I have had no choice but to use evaluate, but the scenarios involved were far more complex and generally involve dynamic cfc function calls. It's up to you whether you use it or not, but why make your (coding) life harder than it needs to be? I find the alternative far easier to write, read and maintain than the evaluate alternative. Cheers, Gabriel R -Original Message- From: Ryan Letulle [mailto:bayous...@gmail.com] Sent: Wednesday, 10 June 2009 11:04 AM To: cf-talk Subject: Re: CFLOOP inside a CFQuery Interesting I've never seen any noticeable hit using evaluate but I have heard it should be avoided. (chose to ignore) I'll look into your suggestion though. I guess the question why even make evaluate available comes to mind if you should never use it? -- Ryan LeTulle On Tue, Jun 9, 2009 at 7:58 PM, Gabriel coldfus...@evolution7.com wrote: You don't need evaluate for dynamically created form variables, in almost all cases the struct syntax #form['type'idx]# will suffice and is more efficient. For this particular scenario, evaluate is an unnecessary overhead and should be avoided. cfquery datasource=#request.datasource# cfloop from=1 to=#rows# index=idx INSERT INTO tbl_ballotOrder ( type, number, issue ) VALUES ( cfqueryparam value=#form['type'idx]# cfsqltype=cf_sql_varchar /, cfqueryparam value=#form['number'idx]# cfsqltype=cf_sql_integer /, cfqueryparam value=#form['issue'idx]# cfsqltype=cf_sql_varchar / ) /cfloop /cfquery May I also point out the use of CFQUERYPARAM. It's basic principles; unless you've got a damn fine reason not to, always use cfqueryparam. Protect yourself from SQL injection attacks, make your life easier. No offence intended, but Will I urge you to ignore the 'evaluate' based advice. Cheers, Gabriel ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323305 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFLOOP inside a CFQuery
Repost/Edit: apparently msoft forefront exchange server thinks I was being profane. You don't need evaluate for dynamically created form variables, in almost all cases the struct syntax #form['type'idx]# will suffice and is more efficient. For this particular scenario, evaluate is an unnecessary overhead and should be avoided. cfquery datasource=#request.datasource# cfloop from=1 to=#rows# index=idx INSERT INTO tbl_ballotOrder ( type, number, issue ) VALUES ( cfqueryparam value=#form['type'idx]# cfsqltype=cf_sql_varchar /, cfqueryparam value=#form['number'idx]# cfsqltype=cf_sql_integer /, cfqueryparam value=#form['issue'idx]# cfsqltype=cf_sql_varchar / ) /cfloop /cfquery May I also point out the use of CFQUERYPARAM. It's basic principles; unless you've got a *very* fine reason not to, always use cfqueryparam. Protect yourself from SQL injection attacks, make your life easier. No offence intended, but Will I urge you to ignore the 'evaluate' based advice. Cheers, Gabriel -Original Message- From: Ryan Letulle [mailto:bayous...@gmail.com] Sent: Wednesday, 10 June 2009 10:25 AM To: cf-talk Subject: Re: CFLOOP inside a CFQuery I agree with NK pay attention to the evaluate function. It works like a charm for dynamically created form variables. I use it often. :) -- Ryan LeTulle On Tue, Jun 9, 2009 at 6:30 PM, N K neetukais...@gmail.com wrote: Check the following link might help... http://tutorial431.easycfm.com/ Hello all, I have a dynamically generated form that I need to figure out how to get the data from that form in to our database. Here is the way it works. First the client types in the number of machines they have and the form generates the correct number of rows so that the info about each machine is located on a separate row. That all works well until they hit submit (or will hit submit if I figure out the next part). How do I create a cfquery that has the correct number of values so that each machines data is stored correctly? For example I will have row one with lets say three fields (Type, number, issue). Lets say a client has a problem with 10 machines. The form now has 10 rows with 3 columns in each. Each field in row one is named type1, number1, issue1 and row two is type2, number2, issue2, etc.. The number next to the name is placed there by putting the index of the loop in the name field. So this is where I was going to use a CFLOOP inside a CFquery to create field names dynamically. I can get it to repeate the information correctly, however the problem is the index of the loop does not seem to get attached to the form value I am putting into the database. I am doing something like: cfquery datasource=#request.datasource# INSERT into tbl_ballotOrder (type, number, issue) Values ( cfloop from=1 to=#rows# step=1 index=LoopCount '#FORM.type##LoopCount#', '#FORM.number##LoopCount#', '#FORM. issue##LoopCount#' /cfloop ) /cfquery /cfif ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323306 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFLOOP inside a CFQuery
Ryan, You can use #form['string'var]# anywhere, including form['string'var] = x. CfQueryParam is a separate issue relating purely to Will's SQL and it's vulnerability to SQL injection attack. Cheers, Gabriel -Original Message- From: Ryan Letulle [mailto:bayous...@gmail.com] Sent: Wednesday, 10 June 2009 11:11 AM To: cf-talk Subject: Re: CFLOOP inside a CFQuery @gabrieldoes the cfqueryparam matter or can you just use #form['type'idx]# in any way? -- Ryan LeTulle On Tue, Jun 9, 2009 at 7:58 PM, Gabriel coldfus...@evolution7.com wrote: You don't need evaluate for dynamically created form variables, in almost all cases the struct syntax #form['type'idx]# will suffice and is more efficient. For this particular scenario, evaluate is an unnecessary overhead and should be avoided. cfquery datasource=#request.datasource# cfloop from=1 to=#rows# index=idx INSERT INTO tbl_ballotOrder ( type, number, issue ) VALUES ( cfqueryparam value=#form['type'idx]# cfsqltype=cf_sql_varchar /, cfqueryparam value=#form['number'idx]# cfsqltype=cf_sql_integer /, cfqueryparam value=#form['issue'idx]# cfsqltype=cf_sql_varchar / ) /cfloop /cfquery May I also point out the use of CFQUERYPARAM. It's basic principles; unless you've got a *very* fine reason not to, always use cfqueryparam. Protect yourself from SQL injection attacks, make your life easier. No offence intended, but Will I urge you to ignore the 'evaluate' based advice. Cheers, Gabriel -Original Message- From: Ryan Letulle [mailto:bayous...@gmail.com] Sent: Wednesday, 10 June 2009 10:25 AM To: cf-talk Subject: Re: CFLOOP inside a CFQuery I agree with NK pay attention to the evaluate function. It works like a charm for dynamically created form variables. I use it often. :) -- Ryan LeTulle On Tue, Jun 9, 2009 at 6:30 PM, N K neetukais...@gmail.com wrote: Check the following link might help... http://tutorial431.easycfm.com/ Hello all, I have a dynamically generated form that I need to figure out how to get the data from that form in to our database. Here is the way it works. First the client types in the number of machines they have and the form generates the correct number of rows so that the info about each machine is located on a separate row. That all works well until they hit submit (or will hit submit if I figure out the next part). How do I create a cfquery that has the correct number of values so that each machines data is stored correctly? For example I will have row one with lets say three fields (Type, number, issue). Lets say a client has a problem with 10 machines. The form now has 10 rows with 3 columns in each. Each field in row one is named type1, number1, issue1 and row two is type2, number2, issue2, etc.. The number next to the name is placed there by putting the index of the loop in the name field. So this is where I was going to use a CFLOOP inside a CFquery to create field names dynamically. I can get it to repeate the information correctly, however the problem is the index of the loop does not seem to get attached to the form value I am putting into the database. I am doing something like: cfquery datasource=#request.datasource# INSERT into tbl_ballotOrder (type, number, issue) Values ( cfloop from=1 to=#rows# step=1 index=LoopCount '#FORM.type##LoopCount#', '#FORM.number##LoopCount#', '#FORM. issue##LoopCount#' /cfloop ) /cfquery /cfif ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323307 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFLOOP inside a CFQuery
I tend to agree if that syntax works in all situations for dynamic form variables and I'm not doing something that works sometimes and I'm not sure exactly when. -- Ryan LeTulle On Tue, Jun 9, 2009 at 8:14 PM, Gabriel coldfus...@evolution7.com wrote: Repost/Edit: apparently msoft forefront exchange server thinks I was being profane. You don't need evaluate for dynamically created form variables, in almost all cases the struct syntax #form['type'idx]# will suffice and is more efficient. For this particular scenario, evaluate is an unnecessary overhead and should be avoided. cfquery datasource=#request.datasource# cfloop from=1 to=#rows# index=idx INSERT INTO tbl_ballotOrder ( type, number, issue ) VALUES ( cfqueryparam value=#form['type'idx]# cfsqltype=cf_sql_varchar /, cfqueryparam value=#form['number'idx]# cfsqltype=cf_sql_integer /, cfqueryparam value=#form['issue'idx]# cfsqltype=cf_sql_varchar / ) /cfloop /cfquery May I also point out the use of CFQUERYPARAM. It's basic principles; unless you've got a *very* fine reason not to, always use cfqueryparam. Protect yourself from SQL injection attacks, make your life easier. No offence intended, but Will I urge you to ignore the 'evaluate' based advice. Cheers, Gabriel -Original Message- From: Ryan Letulle [mailto:bayous...@gmail.com] Sent: Wednesday, 10 June 2009 10:25 AM To: cf-talk Subject: Re: CFLOOP inside a CFQuery I agree with NK pay attention to the evaluate function. It works like a charm for dynamically created form variables. I use it often. :) -- Ryan LeTulle On Tue, Jun 9, 2009 at 6:30 PM, N K neetukais...@gmail.com wrote: Check the following link might help... http://tutorial431.easycfm.com/ Hello all, I have a dynamically generated form that I need to figure out how to get the data from that form in to our database. Here is the way it works. First the client types in the number of machines they have and the form generates the correct number of rows so that the info about each machine is located on a separate row. That all works well until they hit submit (or will hit submit if I figure out the next part). How do I create a cfquery that has the correct number of values so that each machines data is stored correctly? For example I will have row one with lets say three fields (Type, number, issue). Lets say a client has a problem with 10 machines. The form now has 10 rows with 3 columns in each. Each field in row one is named type1, number1, issue1 and row two is type2, number2, issue2, etc.. The number next to the name is placed there by putting the index of the loop in the name field. So this is where I was going to use a CFLOOP inside a CFquery to create field names dynamically. I can get it to repeate the information correctly, however the problem is the index of the loop does not seem to get attached to the form value I am putting into the database. I am doing something like: cfquery datasource=#request.datasource# INSERT into tbl_ballotOrder (type, number, issue) Values ( cfloop from=1 to=#rows# step=1 index=LoopCount '#FORM.type##LoopCount#', '#FORM.number##LoopCount#', '#FORM. issue##LoopCount#' /cfloop ) /cfquery /cfif ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323308 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFLOOP inside a CFQuery
thx for the form info, on a side note: became very aware of the value of cfqueryparam last year during the chinese et al sql injection attacks -- Ryan LeTulle On Tue, Jun 9, 2009 at 8:17 PM, Gabriel coldfus...@evolution7.com wrote: Ryan, You can use #form['string'var]# anywhere, including form['string'var] = x. CfQueryParam is a separate issue relating purely to Will's SQL and it's vulnerability to SQL injection attack. Cheers, Gabriel -Original Message- From: Ryan Letulle [mailto:bayous...@gmail.com] Sent: Wednesday, 10 June 2009 11:11 AM To: cf-talk Subject: Re: CFLOOP inside a CFQuery @gabrieldoes the cfqueryparam matter or can you just use #form['type'idx]# in any way? -- Ryan LeTulle On Tue, Jun 9, 2009 at 7:58 PM, Gabriel coldfus...@evolution7.com wrote: You don't need evaluate for dynamically created form variables, in almost all cases the struct syntax #form['type'idx]# will suffice and is more efficient. For this particular scenario, evaluate is an unnecessary overhead and should be avoided. cfquery datasource=#request.datasource# cfloop from=1 to=#rows# index=idx INSERT INTO tbl_ballotOrder ( type, number, issue ) VALUES ( cfqueryparam value=#form['type'idx]# cfsqltype=cf_sql_varchar /, cfqueryparam value=#form['number'idx]# cfsqltype=cf_sql_integer /, cfqueryparam value=#form['issue'idx]# cfsqltype=cf_sql_varchar / ) /cfloop /cfquery May I also point out the use of CFQUERYPARAM. It's basic principles; unless you've got a *very* fine reason not to, always use cfqueryparam. Protect yourself from SQL injection attacks, make your life easier. No offence intended, but Will I urge you to ignore the 'evaluate' based advice. Cheers, Gabriel -Original Message- From: Ryan Letulle [mailto:bayous...@gmail.com] Sent: Wednesday, 10 June 2009 10:25 AM To: cf-talk Subject: Re: CFLOOP inside a CFQuery I agree with NK pay attention to the evaluate function. It works like a charm for dynamically created form variables. I use it often. :) -- Ryan LeTulle On Tue, Jun 9, 2009 at 6:30 PM, N K neetukais...@gmail.com wrote: Check the following link might help... http://tutorial431.easycfm.com/ Hello all, I have a dynamically generated form that I need to figure out how to get the data from that form in to our database. Here is the way it works. First the client types in the number of machines they have and the form generates the correct number of rows so that the info about each machine is located on a separate row. That all works well until they hit submit (or will hit submit if I figure out the next part). How do I create a cfquery that has the correct number of values so that each machines data is stored correctly? For example I will have row one with lets say three fields (Type, number, issue). Lets say a client has a problem with 10 machines. The form now has 10 rows with 3 columns in each. Each field in row one is named type1, number1, issue1 and row two is type2, number2, issue2, etc.. The number next to the name is placed there by putting the index of the loop in the name field. So this is where I was going to use a CFLOOP inside a CFquery to create field names dynamically. I can get it to repeate the information correctly, however the problem is the index of the loop does not seem to get attached to the form value I am putting into the database. I am doing something like: cfquery datasource=#request.datasource# INSERT into tbl_ballotOrder (type, number, issue) Values ( cfloop from=1 to=#rows# step=1 index=LoopCount '#FORM.type##LoopCount#', '#FORM.number##LoopCount#', '#FORM. issue##LoopCount#' /cfloop ) /cfquery /cfif ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323309 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFLOOP inside a CFQuery
WOW! Thanks for all the feedback! One question about CFQUERYPARAM, I use this when I accept anything that is available to the general public, but is it necessary to use this when the form is only accessible via username/password? Is there ever a reason not to use CFQUERYPARAM? Thanks everyone! You don't need evaluate for dynamically created form variables, in almost all cases the struct syntax #form['type'idx]# will suffice and is more efficient. For this particular scenario, evaluate is an unnecessary overhead and should be avoided. cfquery datasource=#request.datasource# cfloop from=1 to=#rows# index=idx INSERT INTO tbl_ballotOrder ( type, number, issue ) VALUES ( cfqueryparam value=#form['type'idx]# cfsqltype=cf_sql_varchar /, cfqueryparam value=#form['number'idx]# cfsqltype=cf_sql_integer /, cfqueryparam value=#form['issue'idx]# cfsqltype=cf_sql_varchar / ) /cfloop /cfquery May I also point out the use of CFQUERYPARAM. It's basic principles; unless you've got a damn fine reason not to, always use cfqueryparam. Protect yourself from SQL injection attacks, make your life easier. No offence intended, but Will I urge you to ignore the 'evaluate' based advice. Cheers, Gabriel I agree with NK pay attention to the evaluate function. It works like a charm for dynamically created form variables. I use it often. :) -- Ryan LeTulle part). ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323310 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFLOOP inside a CFQuery
WOW! Thanks for all the feedback! One question about CFQUERYPARAM, I use this when I accept anything that is available to the general public, but is it necessary to use this when the form is only accessible via username/password? I would use it regardless of who is going to be hitting those queries. You never know when some nefarious person is going to break into an admin account and start probing around. Is there ever a reason not to use CFQUERYPARAM? Before ColdFusion 8 was released, you could not use CFQUERYPARAM in conjunction with a cached query. CF8 now allows that (yea!). -Justin ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323311 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFLOOP inside a CFQuery
Will, Justin is right, just because your form is behind a username/password it by no means guarantees that the people accessing that form aren't malicious. As for whether there are scenarios where you shouldn't use queryparam? That's probably open for debate (it's certainly been debated before), however I've not come across a situation (except the caching issue as mentioned) where it's been of any benefit to NOT use queryparam. - Gabriel -Original Message- From: Justin Scott [mailto:jscott-li...@gravityfree.com] Sent: Wednesday, 10 June 2009 12:42 PM To: cf-talk Subject: RE: CFLOOP inside a CFQuery WOW! Thanks for all the feedback! One question about CFQUERYPARAM, I use this when I accept anything that is available to the general public, but is it necessary to use this when the form is only accessible via username/password? I would use it regardless of who is going to be hitting those queries. You never know when some nefarious person is going to break into an admin account and start probing around. Is there ever a reason not to use CFQUERYPARAM? Before ColdFusion 8 was released, you could not use CFQUERYPARAM in conjunction with a cached query. CF8 now allows that (yea!). -Justin ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323312 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFLOOP inside a CFQuery
After seeing how malicious and how effective hackers were with automated sql injection last year I vowed to never leave an integer field unturned without using cfqueryparameters it's just too easy to use it and the benefit is unquestionable especially for integer fields. I am also seeing some addtl benefits with other field types now as well but integers are required. -- Ryan LeTulle On Tue, Jun 9, 2009 at 9:51 PM, Gabriel coldfus...@evolution7.com wrote: Will, Justin is right, just because your form is behind a username/password it by no means guarantees that the people accessing that form aren't malicious. As for whether there are scenarios where you shouldn't use queryparam? That's probably open for debate (it's certainly been debated before), however I've not come across a situation (except the caching issue as mentioned) where it's been of any benefit to NOT use queryparam. - Gabriel -Original Message- From: Justin Scott [mailto:jscott-li...@gravityfree.com] Sent: Wednesday, 10 June 2009 12:42 PM To: cf-talk Subject: RE: CFLOOP inside a CFQuery WOW! Thanks for all the feedback! One question about CFQUERYPARAM, I use this when I accept anything that is available to the general public, but is it necessary to use this when the form is only accessible via username/password? I would use it regardless of who is going to be hitting those queries. You never know when some nefarious person is going to break into an admin account and start probing around. Is there ever a reason not to use CFQUERYPARAM? Before ColdFusion 8 was released, you could not use CFQUERYPARAM in conjunction with a cached query. CF8 now allows that (yea!). -Justin ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323313 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: (ot) Little help with IIS URL Rewrite..
Try this: ^com/([_0-9a-z-]+)(?:/([_0-9a-z-]+)(?:/([_0-9a-z-]+))?)?/?$ Hmmm I can get the rule to work like this: ^testpage/([_0-9a-z-]+)(?:/([_0-9a-z-]+)(?:/([_0-9a-z-]+))?)?/?$ So this URL will work: http://mysite-test.myhost.net/testpage/wagon/red/small But, I think the way the server might be configured is causing trouble for me.. I need the testpage gone though. If I try the rule as: ^net/([_0-9a-z-]+)(?:/([_0-9a-z-]+)(?:/([_0-9a-z-]+))?)?/?$ It will validate correctly when I check the syntax, but 404 when I try to browse to the URL: http://mysite-test.myhost.net/wagon/red/small Error message: Requested URL http://mysite-test.myhost.net:80/wagon/red/small/ Physical Path C:\inetpub\wwwroot2\mysite\wagon\red\small\ Anybody have any ideas? I have complete access to the IIS Admin on the machine in question, though I only know just enough to be dangerous... ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323314 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
How can I make this work with expandPath?
Hi, all... I'm running a query that uses load data infile 'd:/inetpub/webroot/real_estate_data/smlc/daily_downloads/text_files/#today#/#name#' The / have to be backwards to work in this case. If they are turned around as \ in the path, they get deleted in the translation...haven't figured that one out... Anyway, I wanted to use: load data infile #expandPath('/real_estate_data/smlc/daily_downloads/text_files/#today#/#name#')# That works except for the fact that all the / get translated into \ by expandPath and then are deleted from the resulting path, leaving it invalid. How can I code this to make it work with expandPath? Nothing I've tried causes a correct path to be translated by CF. Thanks for any feedback... Rick *Ninety percent of the politicians give the other ten percent a bad reputation.* Henry Kissinger ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323315 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: How can I make this work with expandPath?
Rick, #replace(stringVar, '\', '/', 'all')# should give you the string as you need it, though I'd be more worried about why the \'s are being deleted during whatever operation you're trying to perform. - Gabriel -Original Message- From: Rick Faircloth [mailto:r...@whitestonemedia.com] Sent: Wednesday, 10 June 2009 1:45 PM To: cf-talk Subject: How can I make this work with expandPath? Hi, all... I'm running a query that uses load data infile 'd:/inetpub/webroot/real_estate_data/smlc/daily_downloads/text_files/#today# /#name#' The / have to be backwards to work in this case. If they are turned around as \ in the path, they get deleted in the translation...haven't figured that one out... Anyway, I wanted to use: load data infile #expandPath('/real_estate_data/smlc/daily_downloads/text_files/#today#/#nam e#')# That works except for the fact that all the / get translated into \ by expandPath and then are deleted from the resulting path, leaving it invalid. How can I code this to make it work with expandPath? Nothing I've tried causes a correct path to be translated by CF. Thanks for any feedback... Rick *Ninety percent of the politicians give the other ten percent a bad reputation.* Henry Kissinger ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323316 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How can I make this work with expandPath?
MySQL uses the backslash as an escape character. So after you use expandPath, use replace to double them up. That should take care of it. Cheers, Barneyb --- Barney Boisvert bboisv...@gmail.com http://www.barneyb.com On Jun 9, 2009, at 8:45 PM, Rick Faircloth r...@whitestonemedia.com wrote: Hi, all... I'm running a query that uses load data infile 'd:/inetpub/webroot/real_estate_data/smlc/daily_downloads/text_files/ #today#/#name#' The / have to be backwards to work in this case. If they are turned around as \ in the path, they get deleted in the translation...haven't figured that one out... Anyway, I wanted to use: load data infile #expandPath('/real_estate_data/smlc/daily_downloads/text_files/ #today#/#name#')# That works except for the fact that all the / get translated into \ by expandPath and then are deleted from the resulting path, leaving it invalid. How can I code this to make it work with expandPath? Nothing I've tried causes a correct path to be translated by CF. Thanks for any feedback... Rick --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- -- *Ninety percent of the politicians give the other ten percent a bad reputation.* Henry Kissinger ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323317 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How can I make this work with expandPath?
Thanks, Gabriel...I'll see if I can make that work. To your question about why the \'s are being deleted...below the entire query. It's always run fine since I was using the hardcoded path. I have no idea why the path would end up like dinetpubwebroot eal_estate_datasmlcdaily_downloadstext_files2006_0609MF20060609_07114_ACR_1.txt Never seen that happen before... cfquery name=load_data datasource=#application.dsn2# load data infile 'd:/inetpub/webroot/real_estate_data/smlc/daily_downloads/text_files/#today#/#name#' cfif #name# contains ACR *into* *table* smlc_acr_temp cfelseif #name# contains COM *into* *table* smlc_com_temp cfelseif #name# contains LOT *into* *table* smlc_lots_temp cfelseif #name# contains MUL *into* *table* smlc_mul_temp cfelseif #name# contains OFF *into* *table* smlc_off_temp cfelseif #name# contains REN *into* *table* smlc_ren_temp cfelseif #name# contains RES *into* *table* smlc_res_temp /cfif fields terminated *by* '|' lines terminated *by* '\r\n' /cfquery On Wed, Jun 10, 2009 at 12:21 AM, Gabriel coldfus...@evolution7.com wrote: Rick, #replace(stringVar, '\', '/', 'all')# should give you the string as you need it, though I'd be more worried about why the \'s are being deleted during whatever operation you're trying to perform. - Gabriel -Original Message- From: Rick Faircloth [mailto:r...@whitestonemedia.com] Sent: Wednesday, 10 June 2009 1:45 PM To: cf-talk Subject: How can I make this work with expandPath? Hi, all... I'm running a query that uses load data infile 'd:/inetpub/webroot/real_estate_data/smlc/daily_downloads/text_files/#today# /#name#' The / have to be backwards to work in this case. If they are turned around as \ in the path, they get deleted in the translation...haven't figured that one out... Anyway, I wanted to use: load data infile #expandPath('/real_estate_data/smlc/daily_downloads/text_files/#today#/#nam e#')# That works except for the fact that all the / get translated into \ by expandPath and then are deleted from the resulting path, leaving it invalid. How can I code this to make it work with expandPath? Nothing I've tried causes a correct path to be translated by CF. Thanks for any feedback... Rick *Ninety percent of the politicians give the other ten percent a bad reputation.* Henry Kissinger ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323318 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How can I make this work with expandPath?
Rick, Is it a mysql db? If so, see Barney's reply. Cheers, Gabriel -Original Message- From: Rick Faircloth [mailto:r...@whitestonemedia.com] Sent: Wednesday, 10 June 2009 2:34 PM To: cf-talk Subject: Re: How can I make this work with expandPath? Thanks, Gabriel...I'll see if I can make that work. To your question about why the \'s are being deleted...below the entire query. It's always run fine since I was using the hardcoded path. I have no idea why the path would end up like dinetpubwebroot eal_estate_datasmlcdaily_downloadstext_files2006_0609MF20060609_07114_ACR_1. txt Never seen that happen before... cfquery name=load_data datasource=#application.dsn2# load data infile 'd:/inetpub/webroot/real_estate_data/smlc/daily_downloads/text_files/#today# /#name#' cfif #name# contains ACR *into* *table* smlc_acr_temp cfelseif #name# contains COM *into* *table* smlc_com_temp cfelseif #name# contains LOT *into* *table* smlc_lots_temp cfelseif #name# contains MUL *into* *table* smlc_mul_temp cfelseif #name# contains OFF *into* *table* smlc_off_temp cfelseif #name# contains REN *into* *table* smlc_ren_temp cfelseif #name# contains RES *into* *table* smlc_res_temp /cfif fields terminated *by* '|' lines terminated *by* '\r\n' /cfquery On Wed, Jun 10, 2009 at 12:21 AM, Gabriel coldfus...@evolution7.com wrote: Rick, #replace(stringVar, '\', '/', 'all')# should give you the string as you need it, though I'd be more worried about why the \'s are being deleted during whatever operation you're trying to perform. - Gabriel -Original Message- From: Rick Faircloth [mailto:r...@whitestonemedia.com] Sent: Wednesday, 10 June 2009 1:45 PM To: cf-talk Subject: How can I make this work with expandPath? Hi, all... I'm running a query that uses load data infile 'd:/inetpub/webroot/real_estate_data/smlc/daily_downloads/text_files/# today# /#name#' The / have to be backwards to work in this case. If they are turned around as \ in the path, they get deleted in the translation...haven't figured that one out... Anyway, I wanted to use: load data infile #expandPath('/real_estate_data/smlc/daily_downloads/text_files/#today #/#nam e#')# That works except for the fact that all the / get translated into \ by expandPath and then are deleted from the resulting path, leaving it invalid. How can I code this to make it work with expandPath? Nothing I've tried causes a correct path to be translated by CF. Thanks for any feedback... Rick -- -- *Ninety percent of the politicians give the other ten percent a bad reputation.* Henry Kissinger ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323319 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How can I make this work with expandPath?
So, the long version would be: #replace(expandPath('/real_estate_data/smlc/daily_downloads/text_files/#today#/#name#'), \, all)# Right? Gabriel's var version: cfset filePath = expandPath('/real_estate_data/smlc/daily_downloads/text_files/#today#/#name#') #replace(filePath, \, all)# Correct? Rick On Wed, Jun 10, 2009 at 12:24 AM, Barney Boisvert bboisv...@gmail.comwrote: MySQL uses the backslash as an escape character. So after you use expandPath, use replace to double them up. That should take care of it. Cheers, Barneyb --- Barney Boisvert bboisv...@gmail.com http://www.barneyb.com On Jun 9, 2009, at 8:45 PM, Rick Faircloth r...@whitestonemedia.com wrote: Hi, all... I'm running a query that uses load data infile 'd:/inetpub/webroot/real_estate_data/smlc/daily_downloads/text_files/ #today#/#name#' The / have to be backwards to work in this case. If they are turned around as \ in the path, they get deleted in the translation...haven't figured that one out... Anyway, I wanted to use: load data infile #expandPath('/real_estate_data/smlc/daily_downloads/text_files/ #today#/#name#')# That works except for the fact that all the / get translated into \ by expandPath and then are deleted from the resulting path, leaving it invalid. How can I code this to make it work with expandPath? Nothing I've tried causes a correct path to be translated by CF. Thanks for any feedback... Rick --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- -- *Ninety percent of the politicians give the other ten percent a bad reputation.* Henry Kissinger ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323320 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How can I make this work with expandPath?
yes, mysql 5.1... On Wed, Jun 10, 2009 at 12:37 AM, Gabriel coldfus...@evolution7.com wrote: Rick, Is it a mysql db? If so, see Barney's reply. Cheers, Gabriel -Original Message- From: Rick Faircloth [mailto:r...@whitestonemedia.com] Sent: Wednesday, 10 June 2009 2:34 PM To: cf-talk Subject: Re: How can I make this work with expandPath? Thanks, Gabriel...I'll see if I can make that work. To your question about why the \'s are being deleted...below the entire query. It's always run fine since I was using the hardcoded path. I have no idea why the path would end up like dinetpubwebroot eal_estate_datasmlcdaily_downloadstext_files2006_0609MF20060609_07114_ACR_1. txt Never seen that happen before... cfquery name=load_data datasource=#application.dsn2# load data infile 'd:/inetpub/webroot/real_estate_data/smlc/daily_downloads/text_files/#today# /#name#' cfif #name# contains ACR *into* *table* smlc_acr_temp cfelseif #name# contains COM *into* *table* smlc_com_temp cfelseif #name# contains LOT *into* *table* smlc_lots_temp cfelseif #name# contains MUL *into* *table* smlc_mul_temp cfelseif #name# contains OFF *into* *table* smlc_off_temp cfelseif #name# contains REN *into* *table* smlc_ren_temp cfelseif #name# contains RES *into* *table* smlc_res_temp /cfif fields terminated *by* '|' lines terminated *by* '\r\n' /cfquery On Wed, Jun 10, 2009 at 12:21 AM, Gabriel coldfus...@evolution7.com wrote: Rick, #replace(stringVar, '\', '/', 'all')# should give you the string as you need it, though I'd be more worried about why the \'s are being deleted during whatever operation you're trying to perform. - Gabriel -Original Message- From: Rick Faircloth [mailto:r...@whitestonemedia.com] Sent: Wednesday, 10 June 2009 1:45 PM To: cf-talk Subject: How can I make this work with expandPath? Hi, all... I'm running a query that uses load data infile 'd:/inetpub/webroot/real_estate_data/smlc/daily_downloads/text_files/# today# /#name#' The / have to be backwards to work in this case. If they are turned around as \ in the path, they get deleted in the translation...haven't figured that one out... Anyway, I wanted to use: load data infile #expandPath('/real_estate_data/smlc/daily_downloads/text_files/#today #/#nam e#')# That works except for the fact that all the / get translated into \ by expandPath and then are deleted from the resulting path, leaving it invalid. How can I code this to make it work with expandPath? Nothing I've tried causes a correct path to be translated by CF. Thanks for any feedback... Rick -- -- *Ninety percent of the politicians give the other ten percent a bad reputation.* Henry Kissinger ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323321 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How can I make this work with expandPath?
Rick, As Barney says that mysql uses '\' as an escape char, you'd need to replace '\' with '\\'. Check the docs on the replace function, the syntax would be: #replace(expandPath('\real_estate_data\smlc\daily_downloads\text_files\#toda y#\#name#'), \, \\, all)# Replace(originalString, substringToReplace, stringReplacement, [scope]) - Gabriel -Original Message- From: Rick Faircloth [mailto:r...@whitestonemedia.com] Sent: Wednesday, 10 June 2009 2:41 PM To: cf-talk Subject: Re: How can I make this work with expandPath? yes, mysql 5.1... On Wed, Jun 10, 2009 at 12:37 AM, Gabriel coldfus...@evolution7.com wrote: Rick, Is it a mysql db? If so, see Barney's reply. Cheers, Gabriel -Original Message- From: Rick Faircloth [mailto:r...@whitestonemedia.com] Sent: Wednesday, 10 June 2009 2:34 PM To: cf-talk Subject: Re: How can I make this work with expandPath? Thanks, Gabriel...I'll see if I can make that work. To your question about why the \'s are being deleted...below the entire query. It's always run fine since I was using the hardcoded path. I have no idea why the path would end up like dinetpubwebroot eal_estate_datasmlcdaily_downloadstext_files2006_0609MF20060609_07114_ACR_1. txt Never seen that happen before... cfquery name=load_data datasource=#application.dsn2# load data infile 'd:/inetpub/webroot/real_estate_data/smlc/daily_downloads/text_files/# today# /#name#' cfif #name# contains ACR *into* *table* smlc_acr_temp cfelseif #name# contains COM *into* *table* smlc_com_temp cfelseif #name# contains LOT *into* *table* smlc_lots_temp cfelseif #name# contains MUL *into* *table* smlc_mul_temp cfelseif #name# contains OFF *into* *table* smlc_off_temp cfelseif #name# contains REN *into* *table* smlc_ren_temp cfelseif #name# contains RES *into* *table* smlc_res_temp /cfif fields terminated *by* '|' lines terminated *by* '\r\n' /cfquery On Wed, Jun 10, 2009 at 12:21 AM, Gabriel coldfus...@evolution7.com wrote: Rick, #replace(stringVar, '\', '/', 'all')# should give you the string as you need it, though I'd be more worried about why the \'s are being deleted during whatever operation you're trying to perform. - Gabriel -Original Message- From: Rick Faircloth [mailto:r...@whitestonemedia.com] Sent: Wednesday, 10 June 2009 1:45 PM To: cf-talk Subject: How can I make this work with expandPath? Hi, all... I'm running a query that uses load data infile 'd:/inetpub/webroot/real_estate_data/smlc/daily_downloads/text_files /# today# /#name#' The / have to be backwards to work in this case. If they are turned around as \ in the path, they get deleted in the translation...haven't figured that one out... Anyway, I wanted to use: load data infile #expandPath('/real_estate_data/smlc/daily_downloads/text_files/#tod ay #/#nam e#')# That works except for the fact that all the / get translated into \ by expandPath and then are deleted from the resulting path, leaving it invalid. How can I code this to make it work with expandPath? Nothing I've tried causes a correct path to be translated by CF. Thanks for any feedback... Rick -- -- *Ninety percent of the politicians give the other ten percent a bad reputation.* Henry Kissinger ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323322 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How can I make this work with expandPath?
On my phone so excuse the brevity: P = expandPath(...); P = replace(P, /, \, all); P = replace(P, \, \\, all); Load data infile '#P#' Cheers, Barneyb --- Barney Boisvert bboisv...@gmail.com http://www.barneyb.com On Jun 9, 2009, at 9:40 PM, Rick Faircloth r...@whitestonemedia.com wrote: So, the long version would be: #replace(expandPath('/real_estate_data/smlc/daily_downloads/ text_files/#today#/#name#'), \, all)# Right? Gabriel's var version: cfset filePath = expandPath('/real_estate_data/smlc/daily_downloads/text_files/ #today#/#name#') #replace(filePath, \, all)# Correct? Rick On Wed, Jun 10, 2009 at 12:24 AM, Barney Boisvert bboisv...@gmail.comwrote: MySQL uses the backslash as an escape character. So after you use expandPath, use replace to double them up. That should take care of it. Cheers, Barneyb --- Barney Boisvert bboisv...@gmail.com http://www.barneyb.com On Jun 9, 2009, at 8:45 PM, Rick Faircloth r...@whitestonemedia.com wrote: Hi, all... I'm running a query that uses load data infile 'd:/inetpub/webroot/real_estate_data/smlc/daily_downloads/ text_files/ #today#/#name#' The / have to be backwards to work in this case. If they are turned around as \ in the path, they get deleted in the translation...haven't figured that one out... Anyway, I wanted to use: load data infile #expandPath('/real_estate_data/smlc/daily_downloads/text_files/ #today#/#name#')# That works except for the fact that all the / get translated into \ by expandPath and then are deleted from the resulting path, leaving it invalid. How can I code this to make it work with expandPath? Nothing I've tried causes a correct path to be translated by CF. Thanks for any feedback... Rick --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- *Ninety percent of the politicians give the other ten percent a bad reputation.* Henry Kissinger ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323323 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How can I make this work with expandPath?
Thanks for the clarification, Garbriel. Tomorrow I'll have a go at getting this working. I actually tried a variation of the escape character, as I thought that might be what was happening, but I wasn't using replace at the time. Hopefully, this will work...I'll post back about it. Thanks, again... Rick On Wed, Jun 10, 2009 at 12:49 AM, Gabriel coldfus...@evolution7.com wrote: Rick, As Barney says that mysql uses '\' as an escape char, you'd need to replace '\' with '\\'. Check the docs on the replace function, the syntax would be: #replace(expandPath('\real_estate_data\smlc\daily_downloads\text_files\#toda y#\#name#'), \, \\, all)# Replace(originalString, substringToReplace, stringReplacement, [scope]) - Gabriel -Original Message- From: Rick Faircloth [mailto:r...@whitestonemedia.com] Sent: Wednesday, 10 June 2009 2:41 PM To: cf-talk Subject: Re: How can I make this work with expandPath? yes, mysql 5.1... On Wed, Jun 10, 2009 at 12:37 AM, Gabriel coldfus...@evolution7.com wrote: Rick, Is it a mysql db? If so, see Barney's reply. Cheers, Gabriel -Original Message- From: Rick Faircloth [mailto:r...@whitestonemedia.com] Sent: Wednesday, 10 June 2009 2:34 PM To: cf-talk Subject: Re: How can I make this work with expandPath? Thanks, Gabriel...I'll see if I can make that work. To your question about why the \'s are being deleted...below the entire query. It's always run fine since I was using the hardcoded path. I have no idea why the path would end up like dinetpubwebroot eal_estate_datasmlcdaily_downloadstext_files2006_0609MF20060609_07114_ACR_1. txt Never seen that happen before... cfquery name=load_data datasource=#application.dsn2# load data infile 'd:/inetpub/webroot/real_estate_data/smlc/daily_downloads/text_files/# today# /#name#' cfif #name# contains ACR *into* *table* smlc_acr_temp cfelseif #name# contains COM *into* *table* smlc_com_temp cfelseif #name# contains LOT *into* *table* smlc_lots_temp cfelseif #name# contains MUL *into* *table* smlc_mul_temp cfelseif #name# contains OFF *into* *table* smlc_off_temp cfelseif #name# contains REN *into* *table* smlc_ren_temp cfelseif #name# contains RES *into* *table* smlc_res_temp /cfif fields terminated *by* '|' lines terminated *by* '\r\n' /cfquery On Wed, Jun 10, 2009 at 12:21 AM, Gabriel coldfus...@evolution7.com wrote: Rick, #replace(stringVar, '\', '/', 'all')# should give you the string as you need it, though I'd be more worried about why the \'s are being deleted during whatever operation you're trying to perform. - Gabriel -Original Message- From: Rick Faircloth [mailto:r...@whitestonemedia.com] Sent: Wednesday, 10 June 2009 1:45 PM To: cf-talk Subject: How can I make this work with expandPath? Hi, all... I'm running a query that uses load data infile 'd:/inetpub/webroot/real_estate_data/smlc/daily_downloads/text_files /# today# /#name#' The / have to be backwards to work in this case. If they are turned around as \ in the path, they get deleted in the translation...haven't figured that one out... Anyway, I wanted to use: load data infile #expandPath('/real_estate_data/smlc/daily_downloads/text_files/#tod ay #/#nam e#')# That works except for the fact that all the / get translated into \ by expandPath and then are deleted from the resulting path, leaving it invalid. How can I code this to make it work with expandPath? Nothing I've tried causes a correct path to be translated by CF. Thanks for any feedback... Rick -- -- *Ninety percent of the politicians give the other ten percent a bad reputation.* Henry Kissinger ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323324 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How can I make this work with expandPath?
Thanks for the info, Barney. I can't understand why it works like this: load data infile d:/inetpub/webroot/real_estate_data/text_files/#today#/#name# Seems like MySQL would turn that into: d:inetpubwebrootreal_estate_datatext_files2006_06092006060901_acr_1.txt But for some reason, with the normal \ turned around as /, it works find in the query. Seems like I would have to write: d:/\inetpub/\webroot/\real_estate_data/\text_files/\#today#/\#name# ??? Rick On Wed, Jun 10, 2009 at 12:52 AM, Barney Boisvert bboisv...@gmail.comwrote: On my phone so excuse the brevity: P = expandPath(...); P = replace(P, /, \, all); P = replace(P, \, \\, all); Load data infile '#P#' Cheers, Barneyb --- Barney Boisvert bboisv...@gmail.com http://www.barneyb.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323325 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How can I make this work with expandPath?
Because \ is the escape character, not /. / is valid and doesn't get interpreted as something else. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/6/10 Rick Faircloth r...@whitestonemedia.com: Thanks for the info, Barney. I can't understand why it works like this: load data infile d:/inetpub/webroot/real_estate_data/text_files/#today#/#name# Seems like MySQL would turn that into: d:inetpubwebrootreal_estate_datatext_files2006_06092006060901_acr_1.txt But for some reason, with the normal \ turned around as /, it works find in the query. Seems like I would have to write: d:/\inetpub/\webroot/\real_estate_data/\text_files/\#today#/\#name# ??? Rick On Wed, Jun 10, 2009 at 12:52 AM, Barney Boisvert bboisv...@gmail.comwrote: On my phone so excuse the brevity: P = expandPath(...); P = replace(P, /, \, all); P = replace(P, \, \\, all); Load data infile '#P#' Cheers, Barneyb --- Barney Boisvert bboisv...@gmail.com http://www.barneyb.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323326 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How can I make this work with expandPath?
So...in Barney's example: P = expandPath(...); P = replace(P, /, \, all); P = replace(P, \, \\, all); I would have / in the first line above. Then, end up with \ in the second. And, \\ in the third. Or, is that right? In the first line, would the expandPath operate on the path before the P is set, thereby creating P = d:\inetpub\webroot\filePath\fileName or is P set to equal a non-translated string, expandPath('/filePath/fileName') It can't be the second result, because that would create expandPath('\filePath\fileName'), after Barney's second function above is run...which wouldn't work with the \ instead of /, right? Hmmm...guess I need to write some test code... On Wed, Jun 10, 2009 at 1:09 AM, James Holmes james.hol...@gmail.comwrote: Because \ is the escape character, not /. / is valid and doesn't get interpreted as something else. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/6/10 Rick Faircloth r...@whitestonemedia.com: ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323327 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4