Re: Development Server Installation Scenario
Yes, that sounds like an interesting solution. I'll explore that. I probably overstated the amount of code, it's probably more like 1 gig or less. > 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. > > > and Google has an alternative: > http://arstechnica. > com/web/news/2010/05/google-storage-for-developers-takes-on-amazon-s3. > ars > > 30GB of code is a lot of code... hopefully someone else will suggest > how best to deal with that! > > > > Our production server has over 300 gb of files (90% images and 10% > > code). We'd like to a setup a development server that includes all > of > > those files and thus are considering the following... > > > > 1. Have our isp copy our production server's wwwroot/sites folder > with > > its 300 gb of files to an external hard drive and have that drive > > shipped to us. > > 2. Create an XP box locally and install CF8 developer on it as our > > development server. > > 3. Copy the contents of that hard drive to the local server's sites > > > folder. > > 4. Create a CF datasource that connects remotely to a duplicate of > our > > production SQL Server database that is on a dedication SQL Server at > > > our isp. > > 5. Have our developers install CF8 developer and CFBuilder on their > > > local computers (outside of our offices). > > 6. Use CFBuilder RDS to access our development server. > > 7. Sync changes to the production server (new image files, etc. ) so > > > that they are automatically updated on the local server. > > 8. After testing, have the developers connect to the production > server > > and upload their new or changed files to it. > > > > This also gives us a nice safety backup of our production server's > > critical files. > > > > Does this sound like a good, realistic plan? > > > > What method would we use to refresh the development server's files > > with new or changed files from the production server on a daily > > basis? > > > > Thanks in advance. > > > > ~| 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:334359 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'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. > > > and Google has an alternative: > http://arstechnica. > com/web/news/2010/05/google-storage-for-developers-takes-on-amazon-s3. > ars > > 30GB of code is a lot of code... hopefully someone else will suggest > how best to deal with that! > > > > Our production server has over 300 gb of files (90% images and 10% > > code). We'd like to a setup a development server that includes all > of > > those files and thus are considering the following... > > > > 1. Have our isp copy our production server's wwwroot/sites folder > with > > its 300 gb of files to an external hard drive and have that drive > > shipped to us. > > 2. Create an XP box locally and install CF8 developer on it as our > > development server. > > 3. Copy the contents of that hard drive to the local server's sites > > > folder. > > 4. Create a CF datasource that connects remotely to a duplicate of > our > > production SQL Server database that is on a dedication SQL Server at > > > our isp. > > 5. Have our developers install CF8 developer and CFBuilder on their > > > local computers (outside of our offices). > > 6. Use CFBuilder RDS to access our development server. > > 7. Sync changes to the production server (new image files, etc. ) so > > > that they are automatically updated on the local server. > > 8. After testing, have the developers connect to the production > server > > and upload their new or changed files to it. > > > > This also gives us a nice safety backup of our production server's > > critical files. > > > > Does this sound like a good, realistic plan? > > > > What method would we use to refresh the development server's files > > with new or changed files from the production server on a daily > > basis? > > > > Thanks in advance. > > > > ~| 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:334358 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'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.cfm/2010/5/27/Paid-Railo-Extension-Amazon-S3-now-free-moves-to-the-core. and Google has an alternative: http://arstechnica.com/web/news/2010/05/google-storage-for-developers-takes-on-amazon-s3.ars 30GB of code is a lot of code... hopefully someone else will suggest how best to deal with that! > Our production server has over 300 gb of files (90% images and 10% > code). We'd like to a setup a development server that includes all of > those files and thus are considering the following... > > 1. Have our isp copy our production server's wwwroot/sites folder with > its 300 gb of files to an external hard drive and have that drive > shipped to us. > 2. Create an XP box locally and install CF8 developer on it as our > development server. > 3. Copy the contents of that hard drive to the local server's sites > folder. > 4. Create a CF datasource that connects remotely to a duplicate of our > production SQL Server database that is on a dedication SQL Server at > our isp. > 5. Have our developers install CF8 developer and CFBuilder on their > local computers (outside of our offices). > 6. Use CFBuilder RDS to access our development server. > 7. Sync changes to the production server (new image files, etc. ) so > that they are automatically updated on the local server. > 8. After testing, have the developers connect to the production server > and upload their new or changed files to it. > > This also gives us a nice safety backup of our production server's > critical files. > > Does this sound like a good, realistic plan? > > What method would we use to refresh the development server's files > with new or changed files from the production server on a daily > basis? > > Thanks in advance. > > ~| 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:334357 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Development Server Installation Scenario
Our production server has over 300 gb of files (90% images and 10% code). We'd like to a setup a development server that includes all of those files and thus are considering the following... 1. Have our isp copy our production server's wwwroot/sites folder with its 300 gb of files to an external hard drive and have that drive shipped to us. 2. Create an XP box locally and install CF8 developer on it as our development server. 3. Copy the contents of that hard drive to the local server's sites folder. 4. Create a CF datasource that connects remotely to a duplicate of our production SQL Server database that is on a dedication SQL Server at our isp. 5. Have our developers install CF8 developer and CFBuilder on their local computers (outside of our offices). 6. Use CFBuilder RDS to access our development server. 7. Sync changes to the production server (new image files, etc. ) so that they are automatically updated on the local server. 8. After testing, have the developers connect to the production server and upload their new or changed files to it. This also gives us a nice safety backup of our production server's critical files. Does this sound like a good, realistic plan? What method would we use to refresh the development server's files with new or changed files from the production server on a daily basis? Thanks in advance. ~| 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:334356 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: List Of Custom Tags
Yeah but any .cfm file can be called by the server as a custom tag anywhere that the cf server has access to. On Tue, 2010-06-08 at 06:35 +1000, Andrew Scott wrote: > > > > > -Original Message- > From: Paul Alkema [mailto:paulalkemadesi...@gmail.com] > Sent: Tuesday, 8 June 2010 5:54 AM > To: cf-talk > Subject: List Of Custom Tags > > > Is there any possible way to pull a list of all custom tags available? > > > > > ~| 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:334355 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
transposing sql rows as columns
Hi All - I have a query which returns result set as follows: year amt_type amount 2001 vacation 1000 2001 medical 1000 2001 college 15000 2002 vacation 800 2002 medical 1000 2002 college 1 2003 vacation 400 2003 medical 2000 2003 college 8. I am trying to make the years 2001, 2002, and 2003 as columns and trying to achieve the below output Amt type2001 2002 2003 vacation1000 800400 medical 1000 1000 2000 college 15000 1 8000 I am able to achieve this perfectly on client side. Right now I am trying to achieve the same through using SQL. I am using DECODE to achieve but my result set looks like below Amt type2001 2002 2003 vacation1000 vacation 800 vacation 400 medical 1000 medical1000 medical 2000 college 15000 college1 college 8000 I am trying this on oracle. I am new to this concept. can anyone who worked in similar situation help me. Also, the years may change depending upon the dropdown selection on client page. Can I transpose rows to columns in SQL for dynamic values Thanks ~| 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:334354 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: List Of Custom Tags
-Original Message- From: Paul Alkema [mailto:paulalkemadesi...@gmail.com] Sent: Tuesday, 8 June 2010 5:54 AM To: cf-talk Subject: List Of Custom Tags Is there any possible way to pull a list of all custom tags available? ~| 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:334353 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: List Of Custom Tags
Especially true since any tag can be called from any location with CFMODULE. From: "Dave Watts" Sent: Monday, June 07, 2010 4:26 PM To: "cf-talk" Subject: Re: List Of Custom Tags > Is there any possible way to pull a list of all custom tags available? No, I don't think so. This would be a bit difficult for CF to accomplish, as custom tags can be invoked many different ways and can be placed in many different locations. 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:334352 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: RegEx help
Assuming that those are tabs between the elements, the following will expand on Andy's suggestion. #mid(testString, test.pos[2], test.len[2])# From: "Andy Matthews" Sent: Monday, June 07, 2010 3:32 PM To: "cf-talk" 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:334351 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: List Of Custom Tags
> Is there any possible way to pull a list of all custom tags available? No, I don't think so. This would be a bit difficult for CF to accomplish, as custom tags can be invoked many different ways and can be placed in many different locations. 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:334350 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: ColdFusion and .NET Web Services running WSE 3.0
James, I too have had issue connecting to Exact Target's poorly documented API. I did manage to figure out how to add a user via an older API though. http://paulalkema.com/post.cfm/how-to-subscribe-a-user-in-exact-target-via-t heir-api Regards, Paul Alkema -Original Message- From: Dan O'Keefe [mailto:dan.oke...@gmail.com] Sent: Sunday, June 06, 2010 2:36 PM To: cf-talk Subject: Re: ColdFusion and .NET Web Services running WSE 3.0 James, I would be interested in participating on this as well as I have a current need for the WS-Security piece with ExactTarget API. Dan On Sat, Jun 5, 2010 at 7:13 AM, James Holmes wrote: > > OK, I'll finish up the webservice wrapper CFC on which I'm working and then > look at what's necessary to add the digest password type (currently I just > have the text type working) and any other parts of WS-Security that are > possible in CF. > > The code will work in CF8 and higher, although parts of it will probably > work in CF7 (since that's when we got addSoapRequestHeader()). > > mxAjax / CFAjax docs and other useful articles: > http://www.bifrost.com.au/blog/ > > > On 5 June 2010 21:15, Phillip Duba wrote: > >> >> James, I know I will definitely need something like that in the future. >> While this project went the .NET route, there are two follow-on projects >> that will most likely be needed, one requested by my group, so I know I'll >> be working on at least one more integration using WS-Securit. Thanks, >> >> Phil >> >> On Sat, Jun 5, 2010 at 8:12 AM, James Holmes >> wrote: >> >> > >> > Coincidentally, I've just finished developing the code necessary to do a >> > basic WS-SECURITY call in CF, using standard cf webservices code (i.e. no >> > extra Java jars or other external dependencies). >> > >> > If people need this sort of thing, let me know because I'm thinking of >> > starting an open source project to flesh it out. >> > >> > mxAjax / CFAjax docs and other useful articles: >> > http://www.bifrost.com.au/blog/ >> > >> > >> > On 5 June 2010 01:04, Phillip Duba wrote: >> > >> > > >> > > It did for the pure web services, not for the HTTP Post method (not >> > > recommended for production). It was a proof-of-concept under a tight >> > > deadline so I didn't have time to follow the web service all the way to >> > the >> > > conclusion I would need for production. I did find a few blog posts >> that >> > > got >> > > me pointed in the direction I probably needed to go. The specific >> > > implementation was the Username Token profile. I eventually got to >> > > receiving >> > > an error of cannot authorize/validate the username token. It probably >> had >> > > to >> > > do with timestamps and the makeup of the token itself. Again, I just >> ran >> > > out >> > > of time and the project was chosen to be done by another organization >> > > internally doing .NET work for which the WS-Security implementation was >> > > seamless using MS's WSE library. It wasn't the deciding factor, but it >> > was >> > > definitely a differentiator, >> > > >> > > Phil >> > > >> > > On Fri, Jun 4, 2010 at 12:53 PM, Dan O'Keefe >> > wrote: >> > > >> > > > >> > > > Philip, >> > > > >> > > > Did you authorization require WS-Security? >> > > > >> > > > Dan >> > > > -- >> > > > Dan O'Keefe >> > > > >> > > > >> > > > >> > > > On Thu, Apr 29, 2010 at 12:13 PM, Phillip Duba >> > > wrote: >> > > > > >> > > > > Dave, thanks for the response. I've gone to executing the request >> > using >> > > > > CFHTTP, creating the soap:Header tag and building it as I go >> through >> > > the >> > > > WSE >> > > > > spec and examples. I've gotten to the point that I get unauthorized >> > so >> > > > > that's where I'm at now. I may have to use CFHTTP to do it, but >> we'll >> > > > see. >> > > > > Thanks again, >> > > > > >> > > > > Phil >> > > > > >> > > > > >> > > > > >> > > > >> > > > >> > > >> > > >> > >> > >> >> > > ~| 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:334349 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
List Of Custom Tags
Is there any possible way to pull a list of all custom tags available? ~| 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:334348 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 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:334347 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfquery to json array
toJson is better if you have room for the server-side overhead, and don't mind writing methods that can't be used in any other scenario than via Ajax. CFQueryReader is solely a client side solution, so that you can reuse your server-side code in any way that you see fit. Steve "Cutter" Blades Adobe Community Professional - ColdFusion Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer Co-Author of "Learning Ext JS" http://www.packtpub.com/learning-ext-js/book _ http://blog.cutterscrossing.com Richard White wrote: > in fact toJson is even better for th job: http://tojson.riaforge.org/ > > >> thanks, sorry dont think i was clear enough, i knew about >> serializejson but this doesnt work with extjs, in case anyone else >> stumbles on this post and is interested i found the following: >> http://blog.cutterscrossing.com/index.cfm/CFQueryReader >> >> >>> Google is your friend: >>> >>> Search "cfquery to json" and get: >>> >>> http://www.coldfusionjedi.com/index. >>> >> cfm/2007/9/20/Quick-and-Dirty-JSONQuery-Example >> >>> >>> > > > ~| 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:334346 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Programmatic manipulation of DSN settings
On 6/7/2010 11:57 AM, Dave Watts wrote: > There may even be earlier versions online. > There are. I occasionally have to go back to some 4.5 documentation for our ancient servers, that I am counting down the days to when we can replace. ~| 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:334345 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
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:334344 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Programmatic manipulation of DSN settings
> Nice is that new to coldfusion 9? No. As Ian pointed out, it was introduced in CF 7. But when questions like this come up again, you can always check directly against the documentation, which is still online for CF 7 to CF 9. There may even be earlier versions online. 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:334343 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Programmatic manipulation of DSN settings
No, the admin api has been around for a few releases now On Mon, Jun 7, 2010 at 1:45 PM, Dan Baughman wrote: > > Nice is that new to coldfusion 9? > > On Mon, Jun 7, 2010 at 12:33 PM, Dave Watts wrote: > > > > > > Can you update, add, and delete datasources via code in ColdFusion? > > > > Yes, through the Admin API: > > > > > http://help.adobe.com/en_US/ColdFusion/9.0/Admin/WSc3ff6d0ea77859461172e0811cbf364104-7fcf.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:334342 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfchart ignores scalefrom value
Hi all, I have the following codes in my page. The style variable holds the custom style. Before I begin, please go to http://www.monteandjanicechan.com/chart_good.jpg. This is how I want my report to come up. On the x-axis, there will always be three items as long as at least one of them has values. If an item does not have any values (i.e. 2010), there would not be a marker in the chart. The problem occurs only when only one item has value. Please see http://www.monteandjanicechan.com/chart_bad.jpg. As you can see, 2008 and 2010 do not have any values; y-axis is now scaled from 0 to 100. I have tried setting one of the items (ex. 2008) a value of 0 or something off the chart; it would scale according to this off-the-chart value and the 2009 value. In short, I have to have at least two items with values between 20 and 100 in order for cfchart to scale from 20 to 100. My question is, how can I correct the issue so that cfchart would ALWAYS scale from 20 to 100? I am running CF9. Thanks in advance, Monte ~| 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:334341 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Programmatic manipulation of DSN settings
On 6/7/2010 11:45 AM, Dan Baughman wrote: > Nice is that new to coldfusion 9? > ColdFusion 7, IIRC ~| 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:334340 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Programmatic manipulation of DSN settings
Nice is that new to coldfusion 9? On Mon, Jun 7, 2010 at 12:33 PM, Dave Watts wrote: > > > Can you update, add, and delete datasources via code in ColdFusion? > > Yes, through the Admin API: > > http://help.adobe.com/en_US/ColdFusion/9.0/Admin/WSc3ff6d0ea77859461172e0811cbf364104-7fcf.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:334339 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Programmatic manipulation of DSN settings
> Can you update, add, and delete datasources via code in ColdFusion? Yes, through the Admin API: http://help.adobe.com/en_US/ColdFusion/9.0/Admin/WSc3ff6d0ea77859461172e0811cbf364104-7fcf.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:334338 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Programmatic manipulation of DSN settings
Can you update, add, and delete datasources via code in ColdFusion? ~| 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:334337 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfquery to json array
in fact toJson is even better for th job: http://tojson.riaforge.org/ > thanks, sorry dont think i was clear enough, i knew about > serializejson but this doesnt work with extjs, in case anyone else > stumbles on this post and is interested i found the following: > http://blog.cutterscrossing.com/index.cfm/CFQueryReader > > >Google is your friend: > > > >Search "cfquery to json" and get: > > > >http://www.coldfusionjedi.com/index. > cfm/2007/9/20/Quick-and-Dirty-JSONQuery-Example > > > > > > > >> ~| 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:334336 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfquery to json array
thanks, sorry dont think i was clear enough, i knew about serializejson but this doesnt work with extjs, in case anyone else stumbles on this post and is interested i found the following: http://blog.cutterscrossing.com/index.cfm/CFQueryReader >Google is your friend: > >Search "cfquery to json" and get: > >http://www.coldfusionjedi.com/index.cfm/2007/9/20/Quick-and-Dirty-JSONQuery-Example > > > >> ~| 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:334335 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfquery to json array
Google is your friend: Search "cfquery to json" and get: http://www.coldfusionjedi.com/index.cfm/2007/9/20/Quick-and-Dirty-JSONQuery-Example On Mon, Jun 7, 2010 at 11:53 AM, Richard White wrote: > > hi, > > is there a quick and easy way to convert a cfquery into a json array. i > will be returning the json array to extjs to present in a grid > > thanks > > ~| 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:334334 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfquery to json array
hi, is there a quick and easy way to convert a cfquery into a json array. i will be returning the json array to extjs to present in a grid thanks ~| 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:334333 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm