Re: CF 7 + Apps .. minimum ram
2gb should be plenty for a dev server, but no harm in having more. Regards Russ Michaels www.michaels.me.uk www.cfmldeveloper.com - Free CFML hosting for developers www.cfsearch.com - CF search engine On Dec 12, 2012 2:20 AM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: I'm setting up a testing server. CF7, SQL 2005. Can someone tell me the minimum RAM required please? It doesn't have to set any records Thanks, Jenny -- I am using the free version of SPAMfighter. SPAMfighter has removed 6923 of my spam emails to date. Get the free SPAMfighter here: http://www.spamfighter.com/len Do you have a slow PC? Try a Free scan http://www.spamfighter.com/SLOW-PCfighter?cid=sigen ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353433 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
60sec timeout CF10
We are having issues with requests timing out after 60sec. We are running CF10 in IIS 7.5. I have checked all the timeout settings in IIS and set them to 600sec. I have changed the Tomcat connector in server.xml to 6 as well. Are there any other areas to check in CF10. We have not had this issue with previous version. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353434 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: 60sec timeout CF10
Yes the ColdFusion Administrator is the place to start, by default ColdFusion is set to timeout after 60 secs. There is also a tag that can override this on a per page request, which I would recommend over changing the Administrator setting. http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7d68.html -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/113032480415921517411 On Wed, Dec 12, 2012 at 10:11 PM, Chad Baloga cbal...@gmail.com wrote: We are having issues with requests timing out after 60sec. We are running CF10 in IIS 7.5. I have checked all the timeout settings in IIS and set them to 600sec. I have changed the Tomcat connector in server.xml to 6 as well. Are there any other areas to check in CF10. We have not had this issue with previous version. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353435 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF 7 + Apps .. minimum ram
Loading CF and SQL on the same box (for dev/testing), I'd say about 6+GB of RAM. I usually give about 2GB room for the OS (just 'cause), then I'd say 2 for CF and the rest for SQL. I don't think they have a 64-bit CF 7, but you will need a 64-bit OS to utilize all of the RAM. Don't forget, CF only allocates 512KB out of the box, so you'll need to update your jrun config accordingly. Steve 'Cutter' Blades Adobe Community Professional Adobe Certified Expert Advanced Macromedia ColdFusion MX 7 Developer http://cutterscrossing.com Co-Author Learning Ext JS 3.2 Packt Publishing 2010 https://www.packtpub.com/learning-ext-js-3-2-for-building-dynamic-desktop-style-user-interfaces/book The best way to predict the future is to help create it On 12/11/2012 9:19 PM, Jenny Gavin-Wear wrote: I'm setting up a testing server. CF7, SQL 2005. Can someone tell me the minimum RAM required please? It doesn't have to set any records Thanks, Jenny -- I am using the free version of SPAMfighter. SPAMfighter has removed 6923 of my spam emails to date. Get the free SPAMfighter here: http://www.spamfighter.com/len Do you have a slow PC? Try a Free scan http://www.spamfighter.com/SLOW-PCfighter?cid=sigen ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353436 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF 7 + Apps .. minimum ram
just FYI, that spec would be sufficient for a production server running a couple hundred sites, overkill if you only need to run a couple of dev sites under no load. On Wed, Dec 12, 2012 at 12:40 PM, Steve 'Cutter' Blades cold.fus...@cutterscrossing.com wrote: Loading CF and SQL on the same box (for dev/testing), I'd say about 6+GB of RAM. I usually give about 2GB room for the OS (just 'cause), then I'd say 2 for CF and the rest for SQL. I don't think they have a 64-bit CF 7, but you will need a 64-bit OS to utilize all of the RAM. Don't forget, CF only allocates 512KB out of the box, so you'll need to update your jrun config accordingly. Steve 'Cutter' Blades Adobe Community Professional Adobe Certified Expert Advanced Macromedia ColdFusion MX 7 Developer http://cutterscrossing.com Co-Author Learning Ext JS 3.2 Packt Publishing 2010 https://www.packtpub.com/learning-ext-js-3-2-for-building-dynamic-desktop-style-user-interfaces/book The best way to predict the future is to help create it On 12/11/2012 9:19 PM, Jenny Gavin-Wear wrote: I'm setting up a testing server. CF7, SQL 2005. Can someone tell me the minimum RAM required please? It doesn't have to set any records Thanks, Jenny -- I am using the free version of SPAMfighter. SPAMfighter has removed 6923 of my spam emails to date. Get the free SPAMfighter here: http://www.spamfighter.com/len Do you have a slow PC? Try a Free scan http://www.spamfighter.com/SLOW-PCfighter?cid=sigen ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353437 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Anyone using CFPDF/CFPDFFORM to deliver personalized PDFs?
We have an app that takes a user's info and uses it to populate an existing, blank Acrobat PDF form template that the user can then view, save or print. We had been using a commercial component, ActivePDFToolkit, for this on a CF7 platform. Our process previously had been to populate the PDF form template from a query, then to flatten and save the resulting PDF with a unique name. Now we want to use CF10 to accomplish the same goal. I'd be interested in discussing the approaches you may have taken for doing this type of thing with CF10. If anyone has experience with this and would be willing to discuss how you've approached it, please let me know, either through the list or by e-mail. Regards, Stephen Hait sh...@mindspring.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353438 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Is there a better way to do this import
I'm in the process of rebuilding one of our sites and part of that means
rationalising data and correcting mistakes that were made in the original
build. I've got a chunk of data that needs to be extracted and transformed,
then inserted into a new table in a new database. I'm currently using CF to
do the heavy lifting and so my first question is whether CF is best for
this or if I should try to do this with SQL queries. If the answer is 2 can
anyone point me in the right direction as to how I would go about doing
this in native SQL? Or is there a more efficient way to do this in CF?
Here's what the code currently looks like. Bear in mind that the citem
table contains over 90k rows so we're talking about a lot of data here.
!--- gets the old data the modX fields need merging into a new dbase
schema ---
cfquery datasource=#oldDSN# name=gtd
select id, mod, mod2, mod3, mod4
from citem
where active = 1
/cfquery
!--- Start looping through items ---
cfoutput query=gtd
!--- Get the new item ID from the new database ---
cfquery datasource=#newDSN# name=getNewItemID
select id from items where oldid = '#gtd.id#'
/cfquery
!-- Merge the mod fields into a list ---
cfset topicList = ''
cfset topicList = listappend(#topicList#,'#gtd.mod#')
cfset topicList = listappend(#topicList#,'#gtd.mod2#')
cfset topicList = listappend(#topicList#,'#gtd.mod3#')
cfset topicList = listappend(#topicList#,'#gtd.mod4#')
!--- Loop through the list ---
cfloop list=#topicList# index=t
!--- Assuming there's a value in the field do the insert into the new
database ---
cfif trim(t) NEQ '' and trim(t) NEQ '0'
!-- Get the value for the new topicid field ---
cfquery datasource=#newDSN# name=getNewTopicID
select id from topics where oldid = '#t#'
/cfquery
!--- Insert the data into the new topiclinks table that will link topic
IDs and item IDs ---
cfquery datasource=#newDSN#
insert into topiclinks
(topicid,itemid)
values
('#getNewTopicID.id#','#getNewItemID.id#')
/cfquery
!--- Increment a counter so I know how many rows were created ---
cfset numTopics = numTopics + 1
/cfif
/cfloop
/cfoutput
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353439
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Is there a better way to do this import
On Wed, Dec 12, 2012 at 11:16 AM, Edward Chanter firew...@cc.uk.com wrote: my first question is whether CF is best for this or if I should try to do this with SQL queries. If the answer is 2 can anyone point me in the right direction as to how I would go about doing this in native SQL? Or is there a more efficient way to do this in CF? Making all the data do a round trip to CF and then back to the Database is always going to be slightly slower. Doing this 90K times in a row may magnify this effect. If it's slow in CF, then yes, write it in SQL. Only you can answer this question. If it's a one time migration though, who cares if it's slow as long as it happens. Explaining how to write the SQL to do this is beyond the scope of a simple email, but I would start by taking a look into the syntax for SELECT INTO, which will allow you to select data from one table directly into another. If you need to massage the data first, then it will get more complicated. -Cameron -- Cameron Childress -- p: 678.637.5072 im: cameroncf facebook http://www.facebook.com/cameroncf | twitterhttp://twitter.com/cameronc | google+ https://profiles.google.com/u/0/117829379451708140985 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353440 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Is there a better way to do this import
Thanks for the tip Cameron, I will definitely research SELECT INTO as suggested, all I was hoping for was a pointer like that. I have a lot of tables to transfer but not all require any massaging of the data so I might be able to use CF for some and SQL for the others. Cheers :) On 12 December 2012 16:23, Cameron Childress camer...@gmail.com wrote: On Wed, Dec 12, 2012 at 11:16 AM, Edward Chanter firew...@cc.uk.com wrote: my first question is whether CF is best for this or if I should try to do this with SQL queries. If the answer is 2 can anyone point me in the right direction as to how I would go about doing this in native SQL? Or is there a more efficient way to do this in CF? Making all the data do a round trip to CF and then back to the Database is always going to be slightly slower. Doing this 90K times in a row may magnify this effect. If it's slow in CF, then yes, write it in SQL. Only you can answer this question. If it's a one time migration though, who cares if it's slow as long as it happens. Explaining how to write the SQL to do this is beyond the scope of a simple email, but I would start by taking a look into the syntax for SELECT INTO, which will allow you to select data from one table directly into another. If you need to massage the data first, then it will get more complicated. -Cameron -- Cameron Childress -- p: 678.637.5072 im: cameroncf facebook http://www.facebook.com/cameroncf | twitterhttp://twitter.com/cameronc | google+ https://profiles.google.com/u/0/117829379451708140985 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353441 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Is there a better way to do this import
you may also want to read up on stored procedures,custom functions cursors, and bulk inserts which would help in converting cfml to TSQL On Wed, Dec 12, 2012 at 4:28 PM, Edward Chanter firew...@cc.uk.com wrote: Thanks for the tip Cameron, I will definitely research SELECT INTO as suggested, all I was hoping for was a pointer like that. I have a lot of tables to transfer but not all require any massaging of the data so I might be able to use CF for some and SQL for the others. Cheers :) On 12 December 2012 16:23, Cameron Childress camer...@gmail.com wrote: On Wed, Dec 12, 2012 at 11:16 AM, Edward Chanter firew...@cc.uk.com wrote: my first question is whether CF is best for this or if I should try to do this with SQL queries. If the answer is 2 can anyone point me in the right direction as to how I would go about doing this in native SQL? Or is there a more efficient way to do this in CF? Making all the data do a round trip to CF and then back to the Database is always going to be slightly slower. Doing this 90K times in a row may magnify this effect. If it's slow in CF, then yes, write it in SQL. Only you can answer this question. If it's a one time migration though, who cares if it's slow as long as it happens. Explaining how to write the SQL to do this is beyond the scope of a simple email, but I would start by taking a look into the syntax for SELECT INTO, which will allow you to select data from one table directly into another. If you need to massage the data first, then it will get more complicated. -Cameron -- Cameron Childress -- p: 678.637.5072 im: cameroncf facebook http://www.facebook.com/cameroncf | twitterhttp://twitter.com/cameronc | google+ https://profiles.google.com/u/0/117829379451708140985 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353442 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Is there a better way to do this import
No problem. These sorts of data migrations are always a pain, and somewhat unrewarding tasks... -Cameron On Wed, Dec 12, 2012 at 11:28 AM, Edward Chanter firew...@cc.uk.com wrote: Thanks for the tip Cameron, I will definitely research SELECT INTO as suggested, all I was hoping for was a pointer like that. I have a lot of tables to transfer but not all require any massaging of the data so I might be able to use CF for some and SQL for the others. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353443 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Is there a better way to do this import
Thanks Russ, stored procedures I know something about the others I've never had to use before but will check them out. On 12 December 2012 16:36, Russ Michaels r...@michaels.me.uk wrote: you may also want to read up on stored procedures,custom functions cursors, and bulk inserts which would help in converting cfml to TSQL ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353444 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: 60sec timeout CF10
We do not have that box checked in the CF Admin and it is set to 600sec Yes the ColdFusion Administrator is the place to start, by default ColdFusion is set to timeout after 60 secs. There is also a tag that can override this on a per page request, which I would recommend over changing the Administrator setting. http://help.adobe.com/en_US/ColdFusion/9. 0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7d68.html -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/113032480415921517411 On Wed, Dec 12, 2012 at 10:11 PM, Chad Baloga cbal...@gmail.com wrote: We are having issues with requests timing out after 60sec. We are running CF10 in IIS 7.5. I have checked all the timeout settings in IIS and set them to 600sec. I have changed the Tomcat connector in server.xml to 6 as well. Are there any other areas to check in CF10. We have not had this issue with previous version. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353445 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: 60sec timeout CF10
do you have any cfsetting tags in your code to override the timeout. Also anything in your application.cfc ? On Wed, Dec 12, 2012 at 5:00 PM, Chad Baloga cbal...@gmail.com wrote: We do not have that box checked in the CF Admin and it is set to 600sec Yes the ColdFusion Administrator is the place to start, by default ColdFusion is set to timeout after 60 secs. There is also a tag that can override this on a per page request, which I would recommend over changing the Administrator setting. http://help.adobe.com/en_US/ColdFusion/9. 0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7d68.html -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/113032480415921517411 On Wed, Dec 12, 2012 at 10:11 PM, Chad Baloga cbal...@gmail.com wrote: We are having issues with requests timing out after 60sec. We are running CF10 in IIS 7.5. I have checked all the timeout settings in IIS and set them to 600sec. I have changed the Tomcat connector in server.xml to 6 as well. Are there any other areas to check in CF10. We have not had this issue with previous version. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353446 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
processing within modal window
I have a summary type page and I would like to drill down into detail of a record using a modal window. What is the preferred method not to reload the summary page but open the modal window that possibly cfincludes another template that I pass a few parameters too? The way I see it now modal windows are just hidden and all the processing is done upon the first load of the page. I need to do some processing within the loaded page almost like an old school popup. Will this be an AJAX thing? Thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353447 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: processing within modal window
Yes, this is an ajax thing. CFWindow might have something for this (don't remember), but you don't have a lot of control after that. You're better off creating your own, with something like JQueryUI, or (even better) Twitter Bootstrap, then using JQuery's .load() method to pull in an html fragment. Basically, you create the html box of the modal in your page html, then a javascript method opens the window, calls your server for your html fragment (maybe just a cfm page, for instance) and puts the return into your box/modal. If you don't have a lot of JS chops, I would look up some tutorials. Steve 'Cutter' Blades Adobe Community Professional Adobe Certified Expert Advanced Macromedia ColdFusion MX 7 Developer http://cutterscrossing.com Co-Author Learning Ext JS 3.2 Packt Publishing 2010 https://www.packtpub.com/learning-ext-js-3-2-for-building-dynamic-desktop-style-user-interfaces/book The best way to predict the future is to help create it On 12/12/2012 7:58 PM, Adrian Cesana wrote: I have a summary type page and I would like to drill down into detail of a record using a modal window. What is the preferred method not to reload the summary page but open the modal window that possibly cfincludes another template that I pass a few parameters too? The way I see it now modal windows are just hidden and all the processing is done upon the first load of the page. I need to do some processing within the loaded page almost like an old school popup. Will this be an AJAX thing? Thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353448 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
