RE: RegEx help
Thanks for the help, Jason and Andy. Turns out the character apparently isn't a tab though. Viewing it in WireShark, it looks like there is a carriage return (0d), a line feed (0a) and a space (20) between the age and gender strings. Sorry to be so dumb, but I've managed to avoid regular expressions for the most part, so I'm really clueless now that I need it. I've tried reading through the documentation but it all seems like Greek to me. How can I test for the combination of those three characters? Deb -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: Monday, June 07, 2010 4:27 PM To: cf-talk Subject: RE: RegEx help Assuming that those are tabs between the elements, the following will expand on Andy's suggestion. cfset testString = Case Information Problem:diff breathing Patients:1 Four commandment Information Age:2 months Gender:Female Conscious:Yes Brea / cfset test = reFind(Age:([0-9a-zA-Z ]+)\t, testString, 1, true) / cfoutput#mid(testString, test.pos[2], test.len[2])#/cfoutput From: Andy Matthews li...@commadelimited.com Sent: Monday, June 07, 2010 3:32 PM To: cf-talk cf-talk@houseoffusion.com Subject: RE: RegEx help If you can always depend on Age: before the desired string, and what looks like a tab afterwards, then it's trivial: Age:[0-9a-Z]+\t That assumes that the age will be any combination of letters and numbers, and also allows for upper and lower case. andy -Original Message- From: Debbie Morris [mailto:ddicker...@macromedia.com] Sent: Monday, June 07, 2010 1:51 PM To: cf-talk Subject: RegEx help I need to extract a particular piece of data from one of my query fields and I'm not sure how to go about it. We have incidents in one table that can have comments in another table associated with them. Here's an example of one of the comments in my query results that I need to grab data from: Case Information Problem:diff breathing Patients:1 Four commandment Information Age:2 months Gender:Female Conscious:Yes Brea I need to get the Age information for any comments that contain it. The Age field always begins as shown above and the Gender field always immediately follows it, so I'm assuming I can work from that, but I just don't know how to go about writing it. Any thoughts would be greatly appreciated!! Deb ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334360 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: RegEx help
If you mean test for that exact order of those three characters, you don't really need a regex for that. It is just a constant string. I believe it would be #Chr(13) chr(10) ' '# .:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Debbie Morris [mailto:dmor...@sussexcountyde.gov] Sent: Tuesday, June 08, 2010 10:23 AM To: cf-talk Subject: RE: RegEx help Thanks for the help, Jason and Andy. Turns out the character apparently isn't a tab though. Viewing it in WireShark, it looks like there is a carriage return (0d), a line feed (0a) and a space (20) between the age and gender strings. Sorry to be so dumb, but I've managed to avoid regular expressions for the most part, so I'm really clueless now that I need it. I've tried reading through the documentation but it all seems like Greek to me. How can I test for the combination of those three characters? Deb -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: Monday, June 07, 2010 4:27 PM To: cf-talk Subject: RE: RegEx help Assuming that those are tabs between the elements, the following will expand on Andy's suggestion. cfset testString = Case Information Problem:diff breathing Patients:1 Four commandment Information Age:2 months Gender:Female Conscious:Yes Brea / cfset test = reFind(Age:([0-9a-zA-Z ]+)\t, testString, 1, true) / cfoutput#mid(testString, test.pos[2], test.len[2])#/cfoutput From: Andy Matthews li...@commadelimited.com Sent: Monday, June 07, 2010 3:32 PM To: cf-talk cf-talk@houseoffusion.com Subject: RE: RegEx help If you can always depend on Age: before the desired string, and what looks like a tab afterwards, then it's trivial: Age:[0-9a-Z]+\t That assumes that the age will be any combination of letters and numbers, and also allows for upper and lower case. andy -Original Message- From: Debbie Morris [mailto:ddicker...@macromedia.com] Sent: Monday, June 07, 2010 1:51 PM To: cf-talk Subject: RegEx help I need to extract a particular piece of data from one of my query fields and I'm not sure how to go about it. We have incidents in one table that can have comments in another table associated with them. Here's an example of one of the comments in my query results that I need to grab data from: Case Information Problem:diff breathing Patients:1 Four commandment Information Age:2 months Gender:Female Conscious:Yes Brea I need to get the Age information for any comments that contain it. The Age field always begins as shown above and the Gender field always immediately follows it, so I'm assuming I can work from that, but I just don't know how to go about writing it. Any thoughts would be greatly appreciated!! Deb ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334361 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: RegEx help
I think he wants to make it part of the t-sql code. Do you really need to test for all three of these? Will there ever be a carriage return in the Age value that's valid? If not why not just test for the carriage return alone as the end part of your regex? On Tue, Jun 8, 2010 at 11:01 AM, Bobby Hartsfield bo...@acoderslife.comwrote: If you mean test for that exact order of those three characters, you don't really need a regex for that. It is just a constant string. I believe it would be #Chr(13) chr(10) ' '# .:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Debbie Morris [mailto:dmor...@sussexcountyde.gov] Sent: Tuesday, June 08, 2010 10:23 AM To: cf-talk Subject: RE: RegEx help Thanks for the help, Jason and Andy. Turns out the character apparently isn't a tab though. Viewing it in WireShark, it looks like there is a carriage return (0d), a line feed (0a) and a space (20) between the age and gender strings. Sorry to be so dumb, but I've managed to avoid regular expressions for the most part, so I'm really clueless now that I need it. I've tried reading through the documentation but it all seems like Greek to me. How can I test for the combination of those three characters? Deb -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: Monday, June 07, 2010 4:27 PM To: cf-talk Subject: RE: RegEx help Assuming that those are tabs between the elements, the following will expand on Andy's suggestion. cfset testString = Case Information Problem:diff breathing Patients:1 Four commandment Information Age:2 months Gender:Female Conscious:Yes Brea / cfset test = reFind(Age:([0-9a-zA-Z ]+)\t, testString, 1, true) / cfoutput#mid(testString, test.pos[2], test.len[2])#/cfoutput From: Andy Matthews li...@commadelimited.com Sent: Monday, June 07, 2010 3:32 PM To: cf-talk cf-talk@houseoffusion.com Subject: RE: RegEx help If you can always depend on Age: before the desired string, and what looks like a tab afterwards, then it's trivial: Age:[0-9a-Z]+\t That assumes that the age will be any combination of letters and numbers, and also allows for upper and lower case. andy -Original Message- From: Debbie Morris [mailto:ddicker...@macromedia.com] Sent: Monday, June 07, 2010 1:51 PM To: cf-talk Subject: RegEx help I need to extract a particular piece of data from one of my query fields and I'm not sure how to go about it. We have incidents in one table that can have comments in another table associated with them. Here's an example of one of the comments in my query results that I need to grab data from: Case Information Problem:diff breathing Patients:1 Four commandment Information Age:2 months Gender:Female Conscious:Yes Brea I need to get the Age information for any comments that contain it. The Age field always begins as shown above and the Gender field always immediately follows it, so I'm assuming I can work from that, but I just don't know how to go about writing it. Any thoughts would be greatly appreciated!! Deb ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334362 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: RegEx help
Oh. I never saw mention of that... and I think it's a she ;-) .:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Michael Grant [mailto:mgr...@modus.bz] Sent: Tuesday, June 08, 2010 11:06 AM To: cf-talk Subject: Re: RegEx help I think he wants to make it part of the t-sql code. Do you really need to test for all three of these? Will there ever be a carriage return in the Age value that's valid? If not why not just test for the carriage return alone as the end part of your regex? On Tue, Jun 8, 2010 at 11:01 AM, Bobby Hartsfield bo...@acoderslife.comwrote: If you mean test for that exact order of those three characters, you don't really need a regex for that. It is just a constant string. I believe it would be #Chr(13) chr(10) ' '# .:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Debbie Morris [mailto:dmor...@sussexcountyde.gov] Sent: Tuesday, June 08, 2010 10:23 AM To: cf-talk Subject: RE: RegEx help Thanks for the help, Jason and Andy. Turns out the character apparently isn't a tab though. Viewing it in WireShark, it looks like there is a carriage return (0d), a line feed (0a) and a space (20) between the age and gender strings. Sorry to be so dumb, but I've managed to avoid regular expressions for the most part, so I'm really clueless now that I need it. I've tried reading through the documentation but it all seems like Greek to me. How can I test for the combination of those three characters? Deb -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: Monday, June 07, 2010 4:27 PM To: cf-talk Subject: RE: RegEx help Assuming that those are tabs between the elements, the following will expand on Andy's suggestion. cfset testString = Case Information Problem:diff breathing Patients:1 Four commandment Information Age:2 months Gender:Female Conscious:Yes Brea / cfset test = reFind(Age:([0-9a-zA-Z ]+)\t, testString, 1, true) / cfoutput#mid(testString, test.pos[2], test.len[2])#/cfoutput From: Andy Matthews li...@commadelimited.com Sent: Monday, June 07, 2010 3:32 PM To: cf-talk cf-talk@houseoffusion.com Subject: RE: RegEx help If you can always depend on Age: before the desired string, and what looks like a tab afterwards, then it's trivial: Age:[0-9a-Z]+\t That assumes that the age will be any combination of letters and numbers, and also allows for upper and lower case. andy -Original Message- From: Debbie Morris [mailto:ddicker...@macromedia.com] Sent: Monday, June 07, 2010 1:51 PM To: cf-talk Subject: RegEx help I need to extract a particular piece of data from one of my query fields and I'm not sure how to go about it. We have incidents in one table that can have comments in another table associated with them. Here's an example of one of the comments in my query results that I need to grab data from: Case Information Problem:diff breathing Patients:1 Four commandment Information Age:2 months Gender:Female Conscious:Yes Brea I need to get the Age information for any comments that contain it. The Age field always begins as shown above and the Gender field always immediately follows it, so I'm assuming I can work from that, but I just don't know how to go about writing it. Any thoughts would be greatly appreciated!! Deb ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334363 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: RegEx help
I'm wrong. I re-read it and it says query fields which when I first read I took as database column. My mistake. And sorry Debbie. She, not he. *_* On Tue, Jun 8, 2010 at 11:18 AM, Bobby Hartsfield bo...@acoderslife.comwrote: Oh. I never saw mention of that... and I think it's a she ;-) .:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Michael Grant [mailto:mgr...@modus.bz] Sent: Tuesday, June 08, 2010 11:06 AM To: cf-talk Subject: Re: RegEx help I think he wants to make it part of the t-sql code. Do you really need to test for all three of these? Will there ever be a carriage return in the Age value that's valid? If not why not just test for the carriage return alone as the end part of your regex? On Tue, Jun 8, 2010 at 11:01 AM, Bobby Hartsfield bo...@acoderslife.comwrote: If you mean test for that exact order of those three characters, you don't really need a regex for that. It is just a constant string. I believe it would be #Chr(13) chr(10) ' '# .:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Debbie Morris [mailto:dmor...@sussexcountyde.gov] Sent: Tuesday, June 08, 2010 10:23 AM To: cf-talk Subject: RE: RegEx help Thanks for the help, Jason and Andy. Turns out the character apparently isn't a tab though. Viewing it in WireShark, it looks like there is a carriage return (0d), a line feed (0a) and a space (20) between the age and gender strings. Sorry to be so dumb, but I've managed to avoid regular expressions for the most part, so I'm really clueless now that I need it. I've tried reading through the documentation but it all seems like Greek to me. How can I test for the combination of those three characters? Deb -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: Monday, June 07, 2010 4:27 PM To: cf-talk Subject: RE: RegEx help Assuming that those are tabs between the elements, the following will expand on Andy's suggestion. cfset testString = Case Information Problem:diff breathing Patients:1 Four commandment Information Age:2 months Gender:Female Conscious:Yes Brea / cfset test = reFind(Age:([0-9a-zA-Z ]+)\t, testString, 1, true) / cfoutput#mid(testString, test.pos[2], test.len[2])#/cfoutput From: Andy Matthews li...@commadelimited.com Sent: Monday, June 07, 2010 3:32 PM To: cf-talk cf-talk@houseoffusion.com Subject: RE: RegEx help If you can always depend on Age: before the desired string, and what looks like a tab afterwards, then it's trivial: Age:[0-9a-Z]+\t That assumes that the age will be any combination of letters and numbers, and also allows for upper and lower case. andy -Original Message- From: Debbie Morris [mailto:ddicker...@macromedia.com] Sent: Monday, June 07, 2010 1:51 PM To: cf-talk Subject: RegEx help I need to extract a particular piece of data from one of my query fields and I'm not sure how to go about it. We have incidents in one table that can have comments in another table associated with them. Here's an example of one of the comments in my query results that I need to grab data from: Case Information Problem:diff breathing Patients:1 Four commandment Information Age:2 months Gender:Female Conscious:Yes Brea I need to get the Age information for any comments that contain it. The Age field always begins as shown above and the Gender field always immediately follows it, so I'm assuming I can work from that, but I just don't know how to go about writing it. Any thoughts would be greatly appreciated!! Deb ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334364 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: RegEx help
How about something like this: cfset arFound = refindnocase(Age:([^\r\n|\r|\n]*)[\r\n|\r|\n],thestring,1,true) / cfoutput#mid(thestring,arFound[pos][1],arFound[len][1])#/cfoutput Cheers, Kris ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334365 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: RegEx help
Rather, that would be, if you don't want the label of the field: cfoutput#mid(thestring,arFound[pos][2],arFound[len][2])#/cfoutput Cheers, Kris On Tue, Jun 8, 2010 at 11:43 AM, Kris Jones kris.jon...@verizon.net wrote: How about something like this: cfset arFound = refindnocase(Age:([^\r\n|\r|\n]*)[\r\n|\r|\n],thestring,1,true) / cfoutput#mid(thestring,arFound[pos][1],arFound[len][1])#/cfoutput ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334366 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: RegEx help
Debbie, Where 'testString' is your content, try this: cfset test = reFind(Age:([0-9a-zA-Z ]+)\s*\n, testString, 1, true) / cfoutput#mid(testString, test.pos[2], test.len[2])#/cfoutput From: Debbie Morris dmor...@sussexcountyde.gov Sent: Tuesday, June 08, 2010 10:24 AM To: cf-talk cf-talk@houseoffusion.com Subject: RE: RegEx help Thanks for the help, Jason and Andy. Turns out the character apparently isn't a tab though. Viewing it in WireShark, it looks like there is a carriage return (0d), a line feed (0a) and a space (20) between the age and gender strings. Sorry to be so dumb, but I've managed to avoid regular expressions for the most part, so I'm really clueless now that I need it. I've tried reading through the documentation but it all seems like Greek to me. How can I test for the combination of those three characters? Deb -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: Monday, June 07, 2010 4:27 PM To: cf-talk Subject: RE: RegEx help Assuming that those are tabs between the elements, the following will expand on Andy's suggestion. cfset testString = Case Information Problem:diff breathing Patients:1 Four commandment Information Age:2 months Gender:Female Conscious:Yes Brea / cfset test = reFind(Age:([0-9a-zA-Z ]+)\t, testString, 1, true) / cfoutput#mid(testString, test.pos[2], test.len[2])#/cfoutput From: Andy Matthews li...@commadelimited.com Sent: Monday, June 07, 2010 3:32 PM To: cf-talk cf-talk@houseoffusion.com Subject: RE: RegEx help If you can always depend on Age: before the desired string, and what looks like a tab afterwards, then it's trivial: Age:[0-9a-Z]+\t That assumes that the age will be any combination of letters and numbers, and also allows for upper and lower case. andy -Original Message- From: Debbie Morris [mailto:ddicker...@macromedia.com] Sent: Monday, June 07, 2010 1:51 PM To: cf-talk Subject: RegEx help I need to extract a particular piece of data from one of my query fields and I'm not sure how to go about it. We have incidents in one table that can have comments in another table associated with them. Here's an example of one of the comments in my query results that I need to grab data from: Case Information Problem:diff breathing Patients:1 Four commandment Information Age:2 months Gender:Female Conscious:Yes Brea I need to get the Age information for any comments that contain it. The Age field always begins as shown above and the Gender field always immediately follows it, so I'm assuming I can work from that, but I just don't know how to go about writing it. Any thoughts would be greatly appreciated!! Deb ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334367 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Development Server Installation Scenario
Since moving images to the Amazon cloud will take significant reprogramming, I think I want to go ahead with my proposal if it seems like a good one. In that regard, is there anything in particular I should be aware of in terms of potential problems and pitfalls as outlined? Many thanks. I'd consider moving the 90% - 270GB (images) to amazon S3. Joe Danziger has an Amazon S3 Rest wrapper (cfc) that could assist: http://www.ajaxcf.com/blog/index.cfm/2006/9/7/Amazon-S3-REST-Wrapper and Railo have just an annouced a free S3 extension: http://www.railo.ch/blog/index. c fm/2010/5/27/Paid-Railo-Extension-Amazon-S3-now-free-moves-to-the-core. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334368 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: RegEx help
Thank you (and everyone else)!! This one did the trick! Now I just need to finish the logic around it so that it doesn't break when there aren't any comments that match, and I can get this off my plate before I leave for vacation! Thanks again! Deb -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: Tuesday, June 08, 2010 11:40 AM To: cf-talk Subject: RE: RegEx help Debbie, Where 'testString' is your content, try this: cfset test = reFind(Age:([0-9a-zA-Z ]+)\s*\n, testString, 1, true) / cfoutput#mid(testString, test.pos[2], test.len[2])#/cfoutput From: Debbie Morris dmor...@sussexcountyde.gov Sent: Tuesday, June 08, 2010 10:24 AM To: cf-talk cf-talk@houseoffusion.com Subject: RE: RegEx help Thanks for the help, Jason and Andy. Turns out the character apparently isn't a tab though. Viewing it in WireShark, it looks like there is a carriage return (0d), a line feed (0a) and a space (20) between the age and gender strings. Sorry to be so dumb, but I've managed to avoid regular expressions for the most part, so I'm really clueless now that I need it. I've tried reading through the documentation but it all seems like Greek to me. How can I test for the combination of those three characters? Deb -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: Monday, June 07, 2010 4:27 PM To: cf-talk Subject: RE: RegEx help Assuming that those are tabs between the elements, the following will expand on Andy's suggestion. cfset testString = Case Information Problem:diff breathing Patients:1 Four commandment Information Age:2 months Gender:Female Conscious:Yes Brea / cfset test = reFind(Age:([0-9a-zA-Z ]+)\t, testString, 1, true) / cfoutput#mid(testString, test.pos[2], test.len[2])#/cfoutput From: Andy Matthews li...@commadelimited.com Sent: Monday, June 07, 2010 3:32 PM To: cf-talk cf-talk@houseoffusion.com Subject: RE: RegEx help If you can always depend on Age: before the desired string, and what looks like a tab afterwards, then it's trivial: Age:[0-9a-Z]+\t That assumes that the age will be any combination of letters and numbers, and also allows for upper and lower case. andy -Original Message- From: Debbie Morris [mailto:ddicker...@macromedia.com] Sent: Monday, June 07, 2010 1:51 PM To: cf-talk Subject: RegEx help I need to extract a particular piece of data from one of my query fields and I'm not sure how to go about it. We have incidents in one table that can have comments in another table associated with them. Here's an example of one of the comments in my query results that I need to grab data from: Case Information Problem:diff breathing Patients:1 Four commandment Information Age:2 months Gender:Female Conscious:Yes Brea I need to get the Age information for any comments that contain it. The Age field always begins as shown above and the Gender field always immediately follows it, so I'm assuming I can work from that, but I just don't know how to go about writing it. Any thoughts would be greatly appreciated!! Deb ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334369 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: RegEx help
Vaca... vacati... hmmm, I'm not sure I'm familiar with that word. :-P .:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Debbie Morris [mailto:dmor...@sussexcountyde.gov] Sent: Tuesday, June 08, 2010 12:45 PM To: cf-talk Subject: RE: RegEx help Thank you (and everyone else)!! This one did the trick! Now I just need to finish the logic around it so that it doesn't break when there aren't any comments that match, and I can get this off my plate before I leave for vacation! Thanks again! Deb -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: Tuesday, June 08, 2010 11:40 AM To: cf-talk Subject: RE: RegEx help Debbie, Where 'testString' is your content, try this: cfset test = reFind(Age:([0-9a-zA-Z ]+)\s*\n, testString, 1, true) / cfoutput#mid(testString, test.pos[2], test.len[2])#/cfoutput From: Debbie Morris dmor...@sussexcountyde.gov Sent: Tuesday, June 08, 2010 10:24 AM To: cf-talk cf-talk@houseoffusion.com Subject: RE: RegEx help Thanks for the help, Jason and Andy. Turns out the character apparently isn't a tab though. Viewing it in WireShark, it looks like there is a carriage return (0d), a line feed (0a) and a space (20) between the age and gender strings. Sorry to be so dumb, but I've managed to avoid regular expressions for the most part, so I'm really clueless now that I need it. I've tried reading through the documentation but it all seems like Greek to me. How can I test for the combination of those three characters? Deb -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: Monday, June 07, 2010 4:27 PM To: cf-talk Subject: RE: RegEx help Assuming that those are tabs between the elements, the following will expand on Andy's suggestion. cfset testString = Case Information Problem:diff breathing Patients:1 Four commandment Information Age:2 months Gender:Female Conscious:Yes Brea / cfset test = reFind(Age:([0-9a-zA-Z ]+)\t, testString, 1, true) / cfoutput#mid(testString, test.pos[2], test.len[2])#/cfoutput From: Andy Matthews li...@commadelimited.com Sent: Monday, June 07, 2010 3:32 PM To: cf-talk cf-talk@houseoffusion.com Subject: RE: RegEx help If you can always depend on Age: before the desired string, and what looks like a tab afterwards, then it's trivial: Age:[0-9a-Z]+\t That assumes that the age will be any combination of letters and numbers, and also allows for upper and lower case. andy -Original Message- From: Debbie Morris [mailto:ddicker...@macromedia.com] Sent: Monday, June 07, 2010 1:51 PM To: cf-talk Subject: RegEx help I need to extract a particular piece of data from one of my query fields and I'm not sure how to go about it. We have incidents in one table that can have comments in another table associated with them. Here's an example of one of the comments in my query results that I need to grab data from: Case Information Problem:diff breathing Patients:1 Four commandment Information Age:2 months Gender:Female Conscious:Yes Brea I need to get the Age information for any comments that contain it. The Age field always begins as shown above and the Gender field always immediately follows it, so I'm assuming I can work from that, but I just don't know how to go about writing it. Any thoughts would be greatly appreciated!! Deb ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334370 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Development Server Installation Scenario
I would incorporate source control in there somehow. Maybe leave the images be served from your dev server and let the devs run the code local via SVN. -- Greg On Tue, Jun 8, 2010 at 12:12 PM, Richard Steele r...@photoeye.com wrote: Since moving images to the Amazon cloud will take significant reprogramming, I think I want to go ahead with my proposal if it seems like a good one. In that regard, is there anything in particular I should be aware of in terms of potential problems and pitfalls as outlined? Many thanks. I'd consider moving the 90% - 270GB (images) to amazon S3. Joe Danziger has an Amazon S3 Rest wrapper (cfc) that could assist: http://www.ajaxcf.com/blog/index.cfm/2006/9/7/Amazon-S3-REST-Wrapper and Railo have just an annouced a free S3 extension: http://www.railo.ch/blog/index. c fm/2010/5/27/Paid-Railo-Extension-Amazon-S3-now-free-moves-to-the-core. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334371 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
How do I solve this path issue for components?
Hi, all. I've started using two different folders on my servers for each site. The first is for viewing a site online during development and the second folder is for production. That is creating path issues with my component path notation. If a path is on the index.cfm in the root of a site, I can use: components.myComponent The path above works for both development and production sites since the component directory is always directly under the root. However, on all other pages, such as .cfm pages within a cfm directory, I have been just specifying my webroot in the path to make it work: mySite.components.myComponent But with different root directories for development and production, that won't work. Locally, I have this directory structure: (Typically, I just mirror this structure on my production site, so there haven't been any problems) mySite.components.myComponent However, now I'm using SVN to automatically FTP changes on commit to the following structure for the development version of the site: mySite-dev.components.myComponent On my server, the production site is under: mySite.components.myComponent So, I have two sites online that I need to use depending on whether I want to publish to the development version or the production version. How can I work my paths so they function under each situation? Thanks! Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334372 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How do I solve this path issue for components?
There are a lot of different ways to solve this problem, but here are a couple. 1. Use a variable to denote your CFC root. For instance, you could set request.pathRoot or something. So in development you'd have request.pathRoot = mySite-dev; and in production it would be request.pathRoot = mySite. Then when you create an object, do something like myComponent = createObject(component, #request.pathRoot#.myComponent); 2. Use a factory object, or a façade, or whatever you want to call it, to create your other objects. You still have to create your façade object, but for example, you could have request.facade with a function like returnObject() or something like that. Then in your code you'd do myComponent = request.facade.returnObject(myComponent); There are lots of frameworks that essentially do this in more complicated fashions, but by doing something like this you aren't leaving all the code across your site reliant on the existence of request.pathRoot. You can keep the logic for where your components are located in just Application.cfc and Facade.cfc (or wherever). This isn't really a factory or a façade, per se, but I'm not really sure what the best term would be. You can learn as much about Inversion of Control (I'm explaining a simplified version of it in #2) by checking out the ColdBox or ColdSpring frameworks. - Andrew. On 2010-06-08, at 16:03, Rick Faircloth wrote: Hi, all. I've started using two different folders on my servers for each site. The first is for viewing a site online during development and the second folder is for production. That is creating path issues with my component path notation. If a path is on the index.cfm in the root of a site, I can use: components.myComponent The path above works for both development and production sites since the component directory is always directly under the root. However, on all other pages, such as .cfm pages within a cfm directory, I have been just specifying my webroot in the path to make it work: mySite.components.myComponent But with different root directories for development and production, that won't work. Locally, I have this directory structure: (Typically, I just mirror this structure on my production site, so there haven't been any problems) mySite.components.myComponent However, now I'm using SVN to automatically FTP changes on commit to the following structure for the development version of the site: mySite-dev.components.myComponent On my server, the production site is under: mySite.components.myComponent So, I have two sites online that I need to use depending on whether I want to publish to the development version or the production version. How can I work my paths so they function under each situation? Thanks! Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334373 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How do I solve this path issue for components?
Why not use per-application mappings? In Application.cfc, you can set this.mappings[ '/mysite' ] to either the production or dev CFC root as needed... On Tue, Jun 8, 2010 at 1:03 PM, Rick Faircloth r...@whitestonemedia.com wrote: Hi, all. I've started using two different folders on my servers for each site. The first is for viewing a site online during development and the second folder is for production. That is creating path issues with my component path notation. If a path is on the index.cfm in the root of a site, I can use: components.myComponent The path above works for both development and production sites since the component directory is always directly under the root. However, on all other pages, such as .cfm pages within a cfm directory, I have been just specifying my webroot in the path to make it work: mySite.components.myComponent But with different root directories for development and production, that won't work. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334374 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: How do I solve this path issue for components?
+1 for per-application mappings. You can even get fancy and set it it based on cgi.server_name or path_info so you don't have to change the code between dev and production. Note, for this to work, dev and production need to be in their OWN application. A better solution would be to actually have a dedicated box for your dev server so you can do testing there without fear of ruining your production server's stability. There are also settings I enable on a production server like Trusted Cache that you wouldn't be able to use for a dev server. If you can't spare a separate box, AT LEAST create different sites for dev and production on your server with their own completely separate web root. www.mysite.com and devwww.mysite.com. If you are running CF Enterprise in multi-server mode you can actually have separate instances for dev and production which is the next best thing to a different physical server. Ok, actually a VM is the next best thing to that, but I digress... ~Brad Original Message Subject: Re: How do I solve this path issue for components? From: Sean Corfield seancorfi...@gmail.com Date: Tue, June 08, 2010 3:34 pm To: cf-talk cf-talk@houseoffusion.com Why not use per-application mappings? In Application.cfc, you can set this.mappings[ '/mysite' ] to either the production or dev CFC root as needed... On Tue, Jun 8, 2010 at 1:03 PM, Rick Faircloth r...@whitestonemedia.com wrote: Hi, all. I've started using two different folders on my servers for each site. The first is for viewing a site online during development and the second folder is for production. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334375 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: How do I solve this path issue for components?
Thanks, Andrew... I'll have a go at some of that! Rick -Original Message- From: Andrew Clarke [mailto:s...@clarke.ca] Sent: Tuesday, June 08, 2010 4:16 PM To: cf-talk Subject: Re: How do I solve this path issue for components? There are a lot of different ways to solve this problem, but here are a couple. 1. Use a variable to denote your CFC root. For instance, you could set request.pathRoot or something. So in development you'd have request.pathRoot = mySite-dev; and in production it would be request.pathRoot = mySite. Then when you create an object, do something like myComponent = createObject(component, #request.pathRoot#.myComponent); 2. Use a factory object, or a façade, or whatever you want to call it, to create your other objects. You still have to create your façade object, but for example, you could have request.facade with a function like returnObject() or something like that. Then in your code you'd do myComponent = request.facade.returnObject(myComponent); There are lots of frameworks that essentially do this in more complicated fashions, but by doing something like this you aren't leaving all the code across your site reliant on the existence of request.pathRoot. You can keep the logic for where your components are located in just Application.cfc and Facade.cfc (or wherever). This isn't really a factory or a façade, per se, but I'm not really sure what the best term would be. You can learn as much about Inversion of Control (I'm explaining a simplified version of it in #2) by checking out the ColdBox or ColdSpring frameworks. - Andrew. On 2010-06-08, at 16:03, Rick Faircloth wrote: Hi, all. I've started using two different folders on my servers for each site. The first is for viewing a site online during development and the second folder is for production. That is creating path issues with my component path notation. If a path is on the index.cfm in the root of a site, I can use: components.myComponent The path above works for both development and production sites since the component directory is always directly under the root. However, on all other pages, such as .cfm pages within a cfm directory, I have been just specifying my webroot in the path to make it work: mySite.components.myComponent But with different root directories for development and production, that won't work. Locally, I have this directory structure: (Typically, I just mirror this structure on my production site, so there haven't been any problems) mySite.components.myComponent However, now I'm using SVN to automatically FTP changes on commit to the following structure for the development version of the site: mySite-dev.components.myComponent On my server, the production site is under: mySite.components.myComponent So, I have two sites online that I need to use depending on whether I want to publish to the development version or the production version. How can I work my paths so they function under each situation? Thanks! Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334376 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: How do I solve this path issue for components?
Thanks for the tip, Brad... I decided to go with use of the cgi.server_name variable. Fast and easy. I just wanted to make sure some super-slick way of doing this hadn't come out lately. And, yes, the development and production sites are completely separate with their own webroot. So, unless I crash the server with something (which is not out of the realm of possibility) I should be ok. Two VPS's would be nice, but one's enough to pay for. :oP Rick -Original Message- From: b...@bradwood.com [mailto:b...@bradwood.com] Sent: Tuesday, June 08, 2010 4:46 PM To: cf-talk Subject: RE: How do I solve this path issue for components? +1 for per-application mappings. You can even get fancy and set it it based on cgi.server_name or path_info so you don't have to change the code between dev and production. Note, for this to work, dev and production need to be in their OWN application. A better solution would be to actually have a dedicated box for your dev server so you can do testing there without fear of ruining your production server's stability. There are also settings I enable on a production server like Trusted Cache that you wouldn't be able to use for a dev server. If you can't spare a separate box, AT LEAST create different sites for dev and production on your server with their own completely separate web root. www.mysite.com and devwww.mysite.com. If you are running CF Enterprise in multi-server mode you can actually have separate instances for dev and production which is the next best thing to a different physical server. Ok, actually a VM is the next best thing to that, but I digress... ~Brad ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334377 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: How do I solve this path issue for components?
I'll probably go with the mappings on my next project, but for now I'll have to go with something like cgi.server_name. I've made the transition to application.cfc's instead of .cfm's, but for some reason, which I couldn't figure out after an entire day of trying, the application I'm working on was defining the wrong database. I couldn't figure out where is was coming from. It was happening during some (and *only* some) ajax transactions. Never could track it down even after stripping down the application.cfc. I finally just gave up and went to an application.cfm so I could get some work done. Perhaps after getting past the initial phase of development on this current site, I'll revisit the issue of the application.cfc defining the wrong database for the site. Weird... Rick -Original Message- From: Sean Corfield [mailto:seancorfi...@gmail.com] Sent: Tuesday, June 08, 2010 4:34 PM To: cf-talk Subject: Re: How do I solve this path issue for components? Why not use per-application mappings? In Application.cfc, you can set this.mappings[ '/mysite' ] to either the production or dev CFC root as needed... ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334378 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How do I solve this path issue for components?
And, yes, the development and production sites are completely separate with their own webroot. So, unless I crash the server with something (which is not out of the realm of possibility) I should be ok. 0_0 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334379 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
coldfusion and dynamic query columns
I have a query which has static as well as dynamic columns. something like below: cfset vMarks = marks1, marks2, marks3 cfquery name=querymarks datasource = abc SELECT firstname, lastname, cfloop from=1 to=listlen(vMarks) index=index marks_#index# cfif #index# NEQ listlen(vMarks),/cfif /cfloop /cfquery The query result set will look like below: firstname lastname marks1 marks2 marks3 ... abc abc 112113114 def def 121122123 So when I am using coldfusion to display the above resultset I am doing the below: table tr tdFIRST NAME/td tdFIRST NAME/td tdFIRST NAME/td /tr cfoutput query=querymarks tr tdquerymarks.firstname/td tdquerymarks.lastname/td cfloop from=1 to=listlen(vMarks) index=index tdquerymarks.marks_#index#/td /cfloop /tr /cfoutput /table The number of marks column is dynamic but I have a variable which stores the list of marks. I am facing problem in displaying the marks with coldfusion. Can anyone let me know if this can be done? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334380 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
How to find base URL of an application?
In my Application.cfc's init code, I'm trying to set a variable in the application scope that is the base URL for the pages in the app. I need this to overcome some issues later with relative and absolute paths (using CF7 so app-specific mappings not possible). I'm having some trouble calculating this robustly and I wonder if I'm overlooking something simple. It's easy to get the base file path. I just use: this.rootFilePath = GetDirectoryFromPath(GetCurrentTemplatePath()); But then I want to calc this.rootURLPath. So if the application is located in the docroot (e.g. d:/inetpub/mysite/), I'd just get '/'. If it were located elsewhere (e.g. d:/inetpub/mysite/a/b/c/), I'd get '/a/b/c/'. I can't use any of the CGI variables because at this point, we're not in the middle of an HTTP request. What I want is the string overlap between rootFilePath and CGI.script_name. Any ideas? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334381 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
reading dynamic sql columns in coldfusion
I have a query which has static as well as dynamic columns. something like below: cfset vMarks = marks1, marks2, marks3 cfquery name=querymarks datasource = abc SELECT firstname, lastname, cfloop from=1 to=listlen(vMarks) index=index marks_#index# cfif #index# NEQ listlen(vMarks),/cfif /cfloop /cfquery The query result set will look like below: firstname lastname marks1 marks2 marks3 ... abcabc 112113114 defdef 121122123 So when I am using coldfusion to display the above resultset I am doing the below: table tr tdFIRST NAME/td tdFIRST NAME/td tdFIRST NAME/td /tr cfoutput query=querymarks tr tdquerymarks.firstname/td tdquerymarks.lastname/td cfloop from=1 to=listlen(vMarks) index=index tdquerymarks.marks_#index#/td /cfloop /tr /cfoutput /table The number of marks column is dynamic but I have a variable which stores the list of marks. I am facing problem in displaying the marks with coldfusion. Can anyone let me know if this can be done? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334382 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Problems with CF9 Web Server Install
Trying to do a first-time install of CF9 on Windows Server 2008 using IIS. Unfortunately, when the installer asks you to select a web server, it just shows Apache and Sun web servers, NONE of which are installed on this machine. What gives? Please advise. TNX. Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334383 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: reading dynamic sql columns in coldfusion
I have a query which has static as well as dynamic columns. something like below: cfset vMarks = marks1, marks2, marks3 cfquery name=querymarks datasource = abc SELECT firstname, lastname, cfloop from=1 to=listlen(vMarks) index=index marks_#index# cfif #index# NEQ listlen(vMarks),/cfif /cfloop /cfquery The query result set will look like below: firstname lastname marks1 marks2 marks3 ... abc abc 112 113 114 def def 121 122 123 This is a denormalized (and therefore usually bad) database schema. You should have a separate table for marks, and join that to people. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334384 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Problems with CF9 Web Server Install
Trying to do a first-time install of CF9 on Windows Server 2008 using IIS. Unfortunately, when the installer asks you to select a web server, it just shows Apache and Sun web servers, NONE of which are installed on this machine. Is the machine running a 64-bit version of Windows? If so, are you using a 64-bit CF installer? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334385 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: coldfusion and dynamic query columns
Try changing your loop to: cfloop list=#variables.vMarks# index=index td#index#/td /cfloop HTH, Carl ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334386 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: reading dynamic sql columns in coldfusion
Try this table tr tdFIRST NAME/td tdFIRST NAME/td tdFIRST NAME/td /tr cfoutput query=querymarks tr tdquerymarks.firstname/td tdquerymarks.lastname/td cfloop from=1 to=listlen(vMarks) index=index td#querymarks[marks_ index]#/td /cfloop /tr /cfoutput /table ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334387 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: coldfusion and dynamic query columns
Wow, I botched that big time!!! Try this instead: cfloop list=#variables.vMarks# index=index tdquerymarks[index]/td /cfloop Carl Try changing your loop to: cfloop list=#variables.vMarks# index=index td#index#/td /cfloop HTH, Carl ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334388 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Problems with CF9 Web Server Install
Actually, I was using the wrong login, which was causing the problem. However, here is another one. Trying to configure the web server, I get an error message while trying to add the IIS7 server: cannot find file \wsconfig\1\jrun_iis6_wildcard.dll problem is that: (1) there is no 1 folder and (2) there is no file with that name. Please help. I have spent hours this afternoon trying to get this damn thing running ... rick. On 6/8/2010 3:43 PM, Dave Watts wrote: Trying to do a first-time install of CF9 on Windows Server 2008 using IIS. Unfortunately, when the installer asks you to select a web server, it just shows Apache and Sun web servers, NONE of which are installed on this machine. Is the machine running a 64-bit version of Windows? If so, are you using a 64-bit CF installer? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334389 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Problems with CF9 Web Server Install
I don't know that particular error, but I believe that CF requires you to have IIS6 Compatibility extensions installed for IIS so it can use its old scripting components, that may be a problem as it seems to be trying to install its wildcard ISAPI extension there. Judah On Tue, Jun 8, 2010 at 4:32 PM, Rick Colman rcol...@cox.net wrote: Actually, I was using the wrong login, which was causing the problem. However, here is another one. Trying to configure the web server, I get an error message while trying to add the IIS7 server: cannot find file \wsconfig\1\jrun_iis6_wildcard.dll problem is that: (1) there is no 1 folder and (2) there is no file with that name. Please help. I have spent hours this afternoon trying to get this damn thing running ... rick. On 6/8/2010 3:43 PM, Dave Watts wrote: Trying to do a first-time install of CF9 on Windows Server 2008 using IIS. Unfortunately, when the installer asks you to select a web server, it just shows Apache and Sun web servers, NONE of which are installed on this machine. Is the machine running a 64-bit version of Windows? If so, are you using a 64-bit CF installer? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334390 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Problems with CF9 Web Server Install
Trying to configure the web server, I get an error message while trying to add the IIS7 server: cannot find file \wsconfig\1\jrun_iis6_wildcard.dll problem is that: (1) there is no 1 folder and (2) there is no file with that name. Please help. I have spent hours this afternoon trying to get this damn thing running ... Did you install the IIS 6 compatibility layer? http://help.adobe.com/en_US/ColdFusion/9.0/Installing/WSc3ff6d0ea77859461172e0811cdec18a15-7ffb.html http://www.codecurry.com/2009/09/installing-coldfusion-on-iis-7.html Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334391 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Problems with CF9 Web Server Install
I _just_ did this install, and had problems. This video was **extremely** helpful: http://blog.kukiel.net/2009/07/installing-coldfusion-8-9-on-vista-and.html ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334392 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How to find base URL of an application?
Try this (you don't need the middle bit if you never use SSL): cfset rootFilePath = http / cfif len(cgi.https_on) cfset rootFilePath = rootFilePath s / /cfif cfset rootFilePath = rootFilePath :// cgi.server_name / On 6/8/2010 6:28 PM, Dave Burns wrote: In my Application.cfc's init code, I'm trying to set a variable in the application scope that is the base URL for the pages in the app. I need this to overcome some issues later with relative and absolute paths (using CF7 so app-specific mappings not possible). I'm having some trouble calculating this robustly and I wonder if I'm overlooking something simple. It's easy to get the base file path. I just use: this.rootFilePath = GetDirectoryFromPath(GetCurrentTemplatePath()); But then I want to calc this.rootURLPath. So if the application is located in the docroot (e.g. d:/inetpub/mysite/), I'd just get '/'. If it were located elsewhere (e.g. d:/inetpub/mysite/a/b/c/), I'd get '/a/b/c/'. I can't use any of the CGI variables because at this point, we're not in the middle of an HTTP request. What I want is the string overlap between rootFilePath and CGI.script_name. Any ideas? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334393 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How to find base URL of an application?
Jason - Thanks but I need it to be more than just the server name. I need it to figure out where it is even if it's a few directories down from the root. In the end, what I decided to do what move my logic out of the init code for application.cfc and into the OnApplicationStart code where I have access to the CGI structure. I then do this: application.rootURLPath = GetDirectoryFromPath(CGI.SCRIPT_NAME); It seems to work so far. Curious if anyone sees any gotchas. Thanks, Dave ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334394 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Problems with CF9 Web Server Install
It was a compatibility layer, and the video was very helpful. Why can't adobe do something like that ??? too simple, I guess. On 6/8/2010 4:48 PM, Dave Watts wrote: Trying to configure the web server, I get an error message while trying to add the IIS7 server: cannot find file \wsconfig\1\jrun_iis6_wildcard.dll problem is that: (1) there is no 1 folder and (2) there is no file with that name. Please help. I have spent hours this afternoon trying to get this damn thing running ... Did you install the IIS 6 compatibility layer? http://help.adobe.com/en_US/ColdFusion/9.0/Installing/WSc3ff6d0ea77859461172e0811cdec18a15-7ffb.html http://www.codecurry.com/2009/09/installing-coldfusion-on-iis-7.html Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334395 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
How to loop over a dataset twice.
I am trying to loop over a dataset twice. I am trying using CFLOOP but the 2nd CFLOOP will not process. cfquery dataset=mydsn name=dset select first,last from name /cfquery //loop through DataSet 1st time cfloop query=dset /cfloop //Now I want to loop through the DataSet a 2nd time cfloop query=dset . /cfloop How do I get the 2nd cfloop to loop over the DataSet without calling the query again? Thanks, Dave ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334396 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How to loop over a dataset twice.
What you have spelled out is very vague and may or may not be possible without knowing more about the functions you are trying to perform. Please provide more information on what you are trying to do. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334397 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: How to loop over a dataset twice.
We will need to see more of the code. If the second loop doesn't work then there is probably something in the code that is stopping your action. Once the query has been created, it will persist until it is erased by the code. -Original Message- From: Dave Hatz daveh...@hatzventures.org Sent: Tuesday, June 08, 2010 5:45 PM To: cf-talk cf-talk@houseoffusion.com Subject: How to loop over a dataset twice. I am trying to loop over a dataset twice. I am trying using CFLOOP but the 2nd CFLOOP will not process. cfquery dataset=mydsn name=dset select first,last from name /cfquery //loop through DataSet 1st time cfloop query=dset /cfloop //Now I want to loop through the DataSet a 2nd time cfloop query=dset . /cfloop How do I get the 2nd cfloop to loop over the DataSet without calling the query again? Thanks, Dave ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334398 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How to loop over a dataset twice.
Have to agree with everyone else, we need to see more of the code. If you have gotten a query from a datasource, the only thing that would stop you from looping over the datasource query a second time is if you are trashing that variable. On Wed, Jun 9, 2010 at 10:45 AM, Dave Hatz daveh...@hatzventures.orgwrote: I am trying to loop over a dataset twice. I am trying using CFLOOP but the 2nd CFLOOP will not process. cfquery dataset=mydsn name=dset select first,last from name /cfquery //loop through DataSet 1st time cfloop query=dset /cfloop //Now I want to loop through the DataSet a 2nd time cfloop query=dset . /cfloop How do I get the 2nd cfloop to loop over the DataSet without calling the query again? Thanks, Dave ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334399 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How to loop over a dataset twice.
You don't have to call the query again. You can just do this: cfquery dataset=mydsn name=dset select first,last from name /cfquery cfoutput query=dset ..do something /cfoutput cfoutput query=dset ..do something else /cfoutput On Tue, Jun 8, 2010 at 5:45 PM, Dave Hatz daveh...@hatzventures.org wrote: I am trying to loop over a dataset twice. I am trying using CFLOOP but the 2nd CFLOOP will not process. cfquery dataset=mydsn name=dset select first,last from name /cfquery //loop through DataSet 1st time cfloop query=dset /cfloop //Now I want to loop through the DataSet a 2nd time cfloop query=dset . /cfloop How do I get the 2nd cfloop to loop over the DataSet without calling the query ag ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334400 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How to loop over a dataset twice.
I want to thank you all for the replies. I went through the code 1 more time and found that inside the 1st cfloop, the query variable was getting trashed. I should have seen that 1st time around...thank you all, I appreciate your help. Dave ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334401 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How to loop over a dataset twice.
As a matter of course, I name query variables with a q_ prefix. Then I am not likely to accidentally overwrite them. On Tue, Jun 8, 2010 at 8:58 PM, Dave Hatz daveh...@hatzventures.org wrote: I want to thank you all for the replies. I went through the code 1 more time and found that inside the 1st cfloop, the query variable was getting trashed. I should have seen that 1st time around...thank you all, I appreciate your hel ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334402 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Looking for Cold Fusion Dev - Chandler AZ
This full-time position will be responsible for the performance of any/all functions involved in the development and maintenance of e-commerce websites. This position will require you to work from our Chandler office in a fast paced, demanding and challenging environment. ⢠You should have a minimum 3 years Cold Fusion experience. ⢠MS SQL experience is required. ⢠Prior experience working on internet websites; 'Intranet sites' will not be considered. ⢠Versed in CSS, DHTML and JavaScript. ⢠Must be organized, fast and accurate. When responding, please include a list of internet sites that you've worked on, salary expectation, and availability to start. Please respond by emailing: warren...@gmail.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-jobs-talk/message.cfm/messageid:4327 Subscription: http://www.houseoffusion.com/groups/cf-jobs-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-jobs-talk/unsubscribe.cfm
