Coldfusion killed my query?
Morning Guys and Girls, I'm running ColdFusion 8 Standard and SQL Server 2005 Workgroup edition. I'm using The standard SQL Server driver that comes with CF8. I'm having a strange performance issue with a particular query. When running the query from SSMS it returns the dataset in less than a second, which I'm more than happy with and kind of confirms that the query itself, the database and the table indexes are all correct. However, when I run the same query from a cfquery block it takes 8 minutes to return!?!!!?! I also ran some tests where I would start the ColfFusion page request and then jump into SSMS and run the query from there at the same time, the query continued to return in less than a second in SSMS but still sat for upto 8 minutes before returning to CF. There are a bunch of other queries on the page, all of which run exactly as I would expect them too, just this one single query which is massively under performing. I can confirm that this performance decrease is not caused by slow rendering or anything as the 8 minute time is taken from the 'execution time' of the query displayed in its cfdump. Any suggestions as to what might be causing this beef? Cheers all, Rob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318150 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Limits on images being uploaded using CFFILE?
Azadi, thanks for your help - sorry i havent responded earlier - been away from my keyboard for the weekend - first time in nearly a year! Anyway, the maxsize of post data is set to 100MB so it isnt that. Any other thoughts? Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On Fri, Jan 16, 2009 at 5:13 PM, Azadi Saryev az...@sabai-dee.com wrote: what is your value for Maximum size of post data in CF Admin (at the bottom of Server Settings - Settings section)? Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Mike Kear wrote: Are there limits imposed on the file sizes or filenames when uploading using CFFILE? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318151 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Coldfusion killed my query?
To make sure it's not the display/debugging causing the issue, remove it all. A dump of a large query in Firefox with Firebug will take a while (I'm not saying 8 minutes, but a while!). Post the query too. Adrian -Original Message- From: Robert Rawlins [mailto:robert.rawl...@thinkbluemedia.co.uk] Sent: 19 January 2009 10:23 To: cf-talk Subject: Coldfusion killed my query? Morning Guys and Girls, I'm running ColdFusion 8 Standard and SQL Server 2005 Workgroup edition. I'm using The standard SQL Server driver that comes with CF8. I'm having a strange performance issue with a particular query. When running the query from SSMS it returns the dataset in less than a second, which I'm more than happy with and kind of confirms that the query itself, the database and the table indexes are all correct. However, when I run the same query from a cfquery block it takes 8 minutes to return!?!!!?! I also ran some tests where I would start the ColfFusion page request and then jump into SSMS and run the query from there at the same time, the query continued to return in less than a second in SSMS but still sat for upto 8 minutes before returning to CF. There are a bunch of other queries on the page, all of which run exactly as I would expect them too, just this one single query which is massively under performing. I can confirm that this performance decrease is not caused by slow rendering or anything as the 8 minute time is taken from the 'execution time' of the query displayed in its cfdump. Any suggestions as to what might be causing this beef? Cheers all, Rob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318152 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Limits on images being uploaded using CFFILE?
There was a post a short while ago about the file name length being a problem on Windows. The magic number was 255 I seem to remember. Does the same file renamed go up ok? Adrian -Original Message- From: Mike Kear [mailto:afpwebwo...@gmail.com] Sent: 16 January 2009 05:53 To: cf-talk Subject: Limits on images being uploaded using CFFILE? Are there limits imposed on the file sizes or filenames when uploading using CFFILE? I'm getting errors when i attempt to upload images to a site using an image upload form I've done. But I'm not sure why. The image i'm trying to upload it called: 56237 ambuscade atlantic 1981 - unverified name and date likely wrong because pennants pained over in falklands.jpg and file size is 1295kb. At first i thought it was because of the file name, but when i change the name to testimage.jpg it still gives the error. When i opened it in fireworks, reduced the size to 117kb and uploaded it with the first, long filename, it uploaded ok. So does that mean there's a limit to the file size I can upload? Our environment is Windows2003 server, with CF8 Enterprise. The error we're getting is: [quote] An exception occured while trying to write the image. Ensure that the destination directory exists and that Coldfusion has permission to write to the given path or file. cause : java.io.FileNotFoundException: e:\domains\alacastinaswh.com.au\wwwroot\cms\images\Userfiles\featureima ges\56237 ambuscade atlantic 1981 - unverified name and date likely wrong because pennants pained over in falklands.jpg (The system cannot find the file specified) [/quote] I know that this is not exactly correct, since i just uploaded an image to that very directory using that image name. I can only conclude that it's the size of the image that's causing the problem. If so, where do i look to change that setting? -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318153 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion killed my query?
Morning Adrian, thanks for getting back to me. This is definitely not caused by the output/dump of the queries, even when all those are removed it takes the same amount of time to return the page. This is not a large query to return, simply a single row containing 2 columns. The query looks as follows: Select Sum(Case When d.LogClassName = 'org.thinkblue.TransferComplete' Then 1 Else 0 End) As SuccessSentCount, Count(Distinct d.Device_ID) As UniqueDevicesCount, Sum(Case When d.MinDate Is NULL Then 0 Else 1 End) As FirstAppearanceCount From( Select MessageLog.Device_ID, FirstAppearance.MinDate, LogClass.Name As LogClassName FromMessageLog Inner Join LogClass On LogClass.LogClass_ID = MessageLog.LogClass_ID Left Outer Join ( Select Device_ID, Min(LogDateTime) As MinDate FromMessageLog Inner Join LogClass On LogClass.LogClass_ID = MessageLog.LogClass_ID Where LogClass.Name In ( 'org.thinkblue.TransferComplete', 'org.openobex.Error.ConnectionRefused', 'org.openobex.Error.Forbidden', 'org.openobex.Error.NotAuthorized', 'org.openobex.Error.ConnectionTimeout' ) AndMessageLog.ThinkTank_ID = cfqueryparam value=#ARGUMENTS.ThinkTank_ID# cfsqltype=cf_sql_integer / Group ByDevice_ID ) As FirstAppearance On MessageLog.Device_ID = FirstAppearance.Device_ID And MessageLog.LogDateTime = FirstAppearance.MinDate Where LogClass.Name In ( 'org.thinkblue.TransferComplete', 'org.openobex.Error.ConnectionRefused', 'org.openobex.Error.Forbidden', 'org.openobex.Error.NotAuthorized', 'org.openobex.Error.ConnectionTimeout' ) And MessageLog.LogDateTime = cfqueryparam value=#ARGUMENTS.StartDate# cfsqltype=cf_sql_date / And MessageLog.LogDateTime cfqueryparam value=#ARGUMENTS.EndDate# cfsqltype=cf_sql_date / And ThinkTank_ID = cfqueryparam value=#ARGUMENTS.ThinkTank_ID# cfsqltype=cf_sql_integer / ) As d Like I say, the query actually runs fine from SSMS but just not when run from CF. Cheers, Rob To make sure it's not the display/debugging causing the issue, remove it all. A dump of a large query in Firefox with Firebug will take a while (I'm not saying 8 minutes, but a while!). Post the query too. Adrian ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318154 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Limits on images being uploaded using CFFILE?
Thanks Adrian, that was my first thought too. So i renamed the file to test.jpg and it still died. Resizing the file and keeping the original name, it went up. Yet, the max upload size is 100MB to that cant be the problem either. I dont have a problem telling my client she has to change the way she's doign things, but i want to make sure I'm telling her the right thing. There's no use my telling her she has to rename all her images if that's not the cause of the problem.It'll still keep on happening after she renames them all (and there are LOTS). Then i'll have the problem on my plate, as well as an irritated client on my back too. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On Mon, Jan 19, 2009 at 9:59 PM, Adrian Lynch cont...@adrianlynch.co.uk wrote: There was a post a short while ago about the file name length being a problem on Windows. The magic number was 255 I seem to remember. Does the same file renamed go up ok? Adrian ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318155 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Limits on images being uploaded using CFFILE?
Can you get it to fail every time with a given file? Can you post it somewhere for us to try? Adrian -Original Message- From: Mike Kear [mailto:afpwebwo...@gmail.com] Sent: 19 January 2009 11:14 To: cf-talk Subject: Re: Limits on images being uploaded using CFFILE? Thanks Adrian, that was my first thought too. So i renamed the file to test.jpg and it still died. Resizing the file and keeping the original name, it went up. Yet, the max upload size is 100MB to that cant be the problem either. I dont have a problem telling my client she has to change the way she's doign things, but i want to make sure I'm telling her the right thing. There's no use my telling her she has to rename all her images if that's not the cause of the problem.It'll still keep on happening after she renames them all (and there are LOTS). Then i'll have the problem on my plate, as well as an irritated client on my back too. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318156 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Coldfusion killed my query?
Try running this query by itself on a cf page, to see if maybe one of the other querries on the page is somehow blocking it At 06:03 AM 1/19/2009, you wrote: Morning Adrian, thanks for getting back to me. This is definitely not caused by the output/dump of the queries, even when all those are removed it takes the same amount of time to return the page. This is not a large query to return, simply a single row containing 2 columns. The query looks as follows: Select Sum(Case When d.LogClassName = 'org.thinkblue.TransferComplete' Then 1 Else 0 End) As SuccessSentCount, Count(Distinct d.Device_ID) As UniqueDevicesCount, Sum(Case When d.MinDate Is NULL Then 0 Else 1 End) As FirstAppearanceCount From( Select MessageLog.Device_ID, FirstAppearance.MinDate, LogClass.Name As LogClassName FromMessageLog Inner Join LogClass On LogClass.LogClass_ID = MessageLog.LogClass_ID Left Outer Join ( Select Device_ID, Min(LogDateTime) As MinDate FromMessageLog Inner Join LogClass On LogClass.LogClass_ID = MessageLog.LogClass_ID Where LogClass.Name In ( 'org.thinkblue.TransferComplete', 'org.openobex.Error.ConnectionRefused', 'org.openobex.Error.Forbidden', 'org.openobex.Error.NotAuthorized', 'org.openobex.Error.ConnectionTimeout' ) And MessageLog.ThinkTank_ID = cfqueryparam value=#ARGUMENTS.ThinkTank_ID# cfsqltype=cf_sql_integer / Group ByDevice_ID ) As FirstAppearance On MessageLog.Device_ID = FirstAppearance.Device_ID And MessageLog.LogDateTime = FirstAppearance.MinDate Where LogClass.Name In ( 'org.thinkblue.TransferComplete', 'org.openobex.Error.ConnectionRefused', 'org.openobex.Error.Forbidden', 'org.openobex.Error.NotAuthorized', 'org.openobex.Error.ConnectionTimeout' ) And MessageLog.LogDateTime = cfqueryparam value=#ARGUMENTS.StartDate# cfsqltype=cf_sql_date / And MessageLog.LogDateTime cfqueryparam value=#ARGUMENTS.EndDate# cfsqltype=cf_sql_date / And ThinkTank_ID = cfqueryparam value=#ARGUMENTS.ThinkTank_ID# cfsqltype=cf_sql_integer / ) As d Like I say, the query actually runs fine from SSMS but just not when run from CF. Cheers, Rob To make sure it's not the display/debugging causing the issue, remove it all. A dump of a large query in Firefox with Firebug will take a while (I'm not saying 8 minutes, but a while!). Post the query too. Adrian ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318157 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion killed my query?
Another thing to try: put the query in a sproc and call it with cfstoredproc. Theoretically, modern SQL Server has made it so that cfquery (ad-hoc) is as fast as cfstoredproc...but...maybe... Let us know... On Mon, Jan 19, 2009 at 7:17 AM, Al Musella, DPM muse...@virtualtrials.comwrote: Try running this query by itself on a cf page, to see if maybe one of the other querries on the page is somehow blocking it At 06:03 AM 1/19/2009, you wrote: Morning Adrian, thanks for getting back to me. This is definitely not caused by the output/dump of the queries, even when all those are removed it takes the same amount of time to return the page. This is not a large query to return, simply a single row containing 2 columns. The query looks as follows: Select Sum(Case When d.LogClassName = 'org.thinkblue.TransferComplete' Then 1 Else 0 End) As SuccessSentCount, Count(Distinct d.Device_ID) As UniqueDevicesCount, Sum(Case When d.MinDate Is NULL Then 0 Else 1 End) As FirstAppearanceCount From( Select MessageLog.Device_ID, FirstAppearance.MinDate, LogClass.Name As LogClassName FromMessageLog Inner Join LogClass On LogClass.LogClass_ID = MessageLog.LogClass_ID Left Outer Join ( Select Device_ID, Min(LogDateTime) As MinDate FromMessageLog Inner Join LogClass On LogClass.LogClass_ID = MessageLog.LogClass_ID Where LogClass.Name In ( 'org.thinkblue.TransferComplete', 'org.openobex.Error.ConnectionRefused', 'org.openobex.Error.Forbidden', 'org.openobex.Error.NotAuthorized', 'org.openobex.Error.ConnectionTimeout' ) And MessageLog.ThinkTank_ID = cfqueryparam value=#ARGUMENTS.ThinkTank_ID# cfsqltype=cf_sql_integer / Group ByDevice_ID ) As FirstAppearance On MessageLog.Device_ID = FirstAppearance.Device_ID And MessageLog.LogDateTime = FirstAppearance.MinDate Where LogClass.Name In ( 'org.thinkblue.TransferComplete', 'org.openobex.Error.ConnectionRefused', 'org.openobex.Error.Forbidden', 'org.openobex.Error.NotAuthorized', 'org.openobex.Error.ConnectionTimeout' ) And MessageLog.LogDateTime = cfqueryparam value=#ARGUMENTS.StartDate# cfsqltype=cf_sql_date / And MessageLog.LogDateTime cfqueryparam value=#ARGUMENTS.EndDate# cfsqltype=cf_sql_date / And ThinkTank_ID = cfqueryparam value=#ARGUMENTS.ThinkTank_ID# cfsqltype=cf_sql_integer / ) As d Like I say, the query actually runs fine from SSMS but just not when run from CF. Cheers, Rob To make sure it's not the display/debugging causing the issue, remove it all. A dump of a large query in Firefox with Firebug will take a while (I'm not saying 8 minutes, but a while!). Post the query too. Adrian ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318158 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Coldfusion killed my query?
Hello Guys, Thank you all for your ideas. After speaking with [Justice] over on the IRC channel I removed the cfqueryparam / and found it ran smooth as silk. Seems that there was some form of datatype mismatch going on, after changing the cf_sql_type on the queryparam we've got it running at proper speed again!! Thanks for your suggestions. Rob Another thing to try: put the query in a sproc and call it with cfstoredproc. Theoretically, modern SQL Server has made it so that cfquery (ad-hoc) is as fast as cfstoredproc...but...maybe... Let us know... On Mon, Jan 19, 2009 at 7:17 AM, Al Musella, DPM muse...@virtualtrials.comwrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318159 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfchart in cfdocument.
Guys, I've got a cfchart which sits inside a cfdocument. In development on my local machine this works perfectly, however, when moved to production we just get a red [X] where the chart should be sat. I've had this problem for as long as I can remember but have only got around to tackling it this morning. After doing some reading around it has become apparent that cfdocument obviously cant access the chart image on my production server which is why it inst displayed, my challenge is finding out WHY it cant access that resource. Nothing springs to mind as a configuration mismatch between dev/production but for some reason it only works on one. Can anyone give me some pointers on solving this? Cheers all, Rob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318160 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion killed my query?
What the heck?! Never would have guessed that. You changed cf_sql_type on which queryparam from what to what? On Mon, Jan 19, 2009 at 7:55 AM, Robert Rawlins robert.rawl...@thinkbluemedia.co.uk wrote: Hello Guys, Thank you all for your ideas. After speaking with [Justice] over on the IRC channel I removed the cfqueryparam / and found it ran smooth as silk. Seems that there was some form of datatype mismatch going on, after changing the cf_sql_type on the queryparam we've got it running at proper speed again!! Thanks for your suggestions. Rob Another thing to try: put the query in a sproc and call it with cfstoredproc. Theoretically, modern SQL Server has made it so that cfquery (ad-hoc) is as fast as cfstoredproc...but...maybe... Let us know... On Mon, Jan 19, 2009 at 7:17 AM, Al Musella, DPM muse...@virtualtrials.comwrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318161 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfchart in cfdocument.
If you do it without the cfdocument so that the chart would appear in the browser, does it still show as a broken image? If so, can you right-click the broken image and pull up the image location? That'll (at least) tell you where that page *thinks* the chart should be... On Mon, Jan 19, 2009 at 8:00 AM, Robert Rawlins robert.rawl...@thinkbluemedia.co.uk wrote: Guys, I've got a cfchart which sits inside a cfdocument. In development on my local machine this works perfectly, however, when moved to production we just get a red [X] where the chart should be sat. I've had this problem for as long as I can remember but have only got around to tackling it this morning. After doing some reading around it has become apparent that cfdocument obviously cant access the chart image on my production server which is why it inst displayed, my challenge is finding out WHY it cant access that resource. Nothing springs to mind as a configuration mismatch between dev/production but for some reason it only works on one. Can anyone give me some pointers on solving this? Cheers all, Rob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318162 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
SQL CASE STATEMENTS
Can I use case statements within a QoQ? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318163 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SQL CASE STATEMENTS
If you're referring to something like the following, then sure: cfquery dbtype=query select stuff from stuff where cfswitch expression=#var# cfcase value=7 things = 2 /cfcase cfdefaultcase things = 1 /cfdefaultcase /cfswitch /cfquery On Mon, Jan 19, 2009 at 8:19 AM, Torrent Girl torrentg...@gmail.com wrote: Can I use case statements within a QoQ? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318164 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL CASE STATEMENTS
If you mean SQL case statements, no. On Mon, Jan 19, 2009 at 9:19 AM, Torrent Girl torrentg...@gmail.com wrote: Can I use case statements within a QoQ? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318165 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfchart in cfdocument.
John, Thanks for the reply. chchart outside of the cfdocument works just fine, no problems at all, its only when placing it inside that it doesn't work :-( Rob If you do it without the cfdocument so that the chart would appear in the browser, does it still show as a broken image? If so, can you right-click the broken image and pull up the image location? That'll (at least) tell you where that page *thinks* the chart should be... On Mon, Jan 19, 2009 at 8:00 AM, Robert Rawlins robert.rawl...@thinkbluemedia.co.uk wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318166 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: SQL CASE STATEMENTS
I don't believe you can use T-SQL case statements in a QofQ. -Original Message- From: Torrent Girl [mailto:torrentg...@gmail.com] Sent: Monday, January 19, 2009 8:19 AM To: cf-talk Subject: SQL CASE STATEMENTS Can I use case statements within a QoQ? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318167 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Limits on images being uploaded using CFFILE?
I'm getting errors when i attempt to upload images to a site using an image upload form I've done. But I'm not sure why. What does your file processing code look like? Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318168 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Storing HTML code in a MS sql database
If storing all Web site content in a single column within a single database table is a specific requirement of the client then you should do what they want, especially if you are getting paid by the hour. I wouldn't question it unless this is a site that has a lot of content and gets a lot of traffic. -Mike Chabot On Sun, Jan 18, 2009 at 8:48 PM, Torrent Girl torrentg...@gmail.com wrote: Why would you not so it this way. This is actually the requirement from my client. it's a simple call to the database with each page request. Why would that be an issue? I am an experienced CF programmer but never built a completely database-driven site. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318169 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SQL CASE STATEMENTS
CASE is part of core SQL, not an MS extension in T-SQL. But not supported by QofQ either way. Write to your local Adobe rep today!! cheers, barneyb On 1/19/09, Andy Matthews li...@commadelimited.com wrote: I don't believe you can use T-SQL case statements in a QofQ. -Original Message- From: Torrent Girl [mailto:torrentg...@gmail.com] Sent: Monday, January 19, 2009 8:19 AM To: cf-talk Subject: SQL CASE STATEMENTS Can I use case statements within a QoQ? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318170 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion killed my query?
Thank you all for your ideas. After speaking with [Justice] over on the IRC channel I removed the cfqueryparam / and found it ran smooth as silk. Seems that there was some form of datatype mismatch going on, after changing the cf_sql_type on the queryparam we've got it running at proper speed again!! While you're doing that, you might want to make your lists with CFQUERYPARAM too. Where LogClass.Name In ( 'org.thinkblue.TransferComplete', 'org.openobex.Error.ConnectionRefused', 'org.openobex.Error.Forbidden', 'org.openobex.Error.NotAuthorized', 'org.openobex.Error.ConnectionTimeout' ) would be Where LogClass.Name In ( cfqueryparam ... list=yes value=org.thinkblue.TransferComplete,org.openobex.Error.ConnectionRefused,... ) Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318171 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfchart in cfdocument.
I've got a cfchart which sits inside a cfdocument. In development on my local machine this works perfectly, however, when moved to production we just get a red [X] where the chart should be sat. I've had this problem for as long as I can remember but have only got around to tackling it this morning. After doing some reading around it has become apparent that cfdocument obviously cant access the chart image on my production server which is why it inst displayed, my challenge is finding out WHY it cant access that resource. Nothing springs to mind as a configuration mismatch between dev/production but for some reason it only works on one. Can anyone give me some pointers on solving this? Save the chart to a file, then build an image tag that points to the file. You can use the FILE attribute of CFCHART to do this. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318172 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Coldfusion killed my query?
Is it true that the SQL will perform better if you cfqp any static values too? So: WHERE cfqp value=1 over: WHERE id = 1 Adrian -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: 19 January 2009 16:31 To: cf-talk Subject: Re: Coldfusion killed my query? Thank you all for your ideas. After speaking with [Justice] over on the IRC channel I removed the cfqueryparam / and found it ran smooth as silk. Seems that there was some form of datatype mismatch going on, after changing the cf_sql_type on the queryparam we've got it running at proper speed again!! While you're doing that, you might want to make your lists with CFQUERYPARAM too. Where LogClass.Name In ( 'org.thinkblue.TransferComplete', 'org.openobex.Error.ConnectionRefused', 'org.openobex.Error.Forbidden', 'org.openobex.Error.NotAuthorized', 'org.openobex.Error.ConnectionTimeout' ) would be Where LogClass.Name In ( cfqueryparam ... list=yes value=org.thinkblue.TransferComplete,org.openobex.Error.ConnectionRefu sed,... ) Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318173 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfchart in cfdocument.
I assume you mean the NAME attribute, which will save the chart bits to a variable. You could then use fileWrite() or cffile to save it to a file. On Mon, Jan 19, 2009 at 10:32 AM, Dave Watts dwa...@figleaf.com wrote: Save the chart to a file, then build an image tag that points to the file. You can use the FILE attribute of CFCHART to do this. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ -- === Raymond Camden, VP of Software Dev, Broadchoice Email: r...@camdenfamily.com Blog : www.coldfusionjedi.com AOL IM : cfjedimaster Keep up to date with the community: http://www.coldfusionbloggers.org ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318174 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
swsoc.exe CPU Spike
The process swsoc.exe (CF ODBC Server) keeps taking over my computer with CPU utilization frequently over 80%. I'll notice my computer running slowly, check task manager, see swsoc taking up a lot of CPU time, restart the CF ODBC Server and things will be fine for a while. I'm running ColdFusion 8 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318175 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Dynamic Flash
I am trying to output a video name dynamicly with coldfusion with JW FLV Player
http://www.longtailvideo.com/players/jw-flv-player/ but keep getting a
404:Error 2032.
I have the same file in the body tag when it loads and that works just fine.
But then if i try on the dynamic link which just outputs a name I get the error
or the player disappears altogether.
My browser status bar and alert in the Url Javascript Alert show me the same
exact file url.
I have also tried using the full domain address in the link too. Someone also
told me to try #URLEncodedFormat(video)# but that still didnt work.
Any Ideas or tips?
Thank you.
script type=text/javascript src=scripts/swfobject.js/script
script type=text/javascript
function deletePlayer(theWrapper, thePlaceholder, thePlayerId) {
swfobject.removeSWF(thePlayerId);
var tmp=document.getElementById(theWrapper);
if (tmp) { tmp.innerHTML = div id= + thePlaceholder + /div; }
}
function createPlayer(thePlaceholder, thePlayerId, theFile) {
var flashvars = {
file:theFile,
autostart:true
}
var params = {
allowfullscreen:true,
allowscriptaccess:always
}
var attributes = {
id:thePlayerId,
name:thePlayerId
}
swfobject.embedSWF(scripts/player.swf, thePlaceholder, 320, 196,
9.0.115, false, flashvars, params, attributes);
}
function initPlayer(theFile) {
deletePlayer('wrapper', 'placeholder1', 'player1');
alert('URL: ' + theFile);
createPlayer('placeholder1', 'player1', theFile);
}
/script
/head
body onLoad=initPlayer('video/files/test.flv');
cfoutput query=qVideo
table width=100 border=0
tr
tdVideo/td
tdTitle/td
tdDescription/td
tdUser_submit/td
td /td
td /td
/tr
tr
tda href=javascript:initPlayer('video/files/#video#')#video#/a/td
td#title#/td
td#description#/td
td#user_submit#/td
td /td
td /td
/tr
/table
/cfoutput
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318176
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: swsoc.exe CPU Spike
I have this problem when connecting to FoxPro tables... in the process of moving those over to SQL server -Original Message- From: Sean Sekora [mailto:seansek...@gmail.com] Sent: Monday, January 19, 2009 8:47 AM To: cf-talk Subject: swsoc.exe CPU Spike The process swsoc.exe (CF ODBC Server) keeps taking over my computer with CPU utilization frequently over 80%. I'll notice my computer running slowly, check task manager, see swsoc taking up a lot of CPU time, restart the CF ODBC Server and things will be fine for a while. I'm running ColdFusion 8 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318177 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Dynamic Flash
Make sure your webserver can server up .flv files. IIS doesn't (not sure if
things have changed for the latest one) by default.
Browse to where you think the flv is and see if it's being served up.
If it is, try playing it in a regular video player, does it work?
Adrian
-Original Message-
From: Sin Tec [mailto:tooles...@gmail.com]
Sent: 19 January 2009 16:55
To: cf-talk
Subject: Dynamic Flash
I am trying to output a video name dynamicly with coldfusion with JW
FLV Player http://www.longtailvideo.com/players/jw-flv-player/ but keep
getting a 404:Error 2032.
I have the same file in the body tag when it loads and that works just
fine. But then if i try on the dynamic link which just outputs a name I
get the error or the player disappears altogether.
My browser status bar and alert in the Url Javascript Alert show me the
same exact file url.
I have also tried using the full domain address in the link too.
Someone also told me to try #URLEncodedFormat(video)# but that still
didnt work.
Any Ideas or tips?
Thank you.
script type=text/javascript src=scripts/swfobject.js/script
script type=text/javascript
function deletePlayer(theWrapper, thePlaceholder, thePlayerId) {
swfobject.removeSWF(thePlayerId);
var tmp=document.getElementById(theWrapper);
if (tmp) { tmp.innerHTML = div id= + thePlaceholder + /div; }
}
function createPlayer(thePlaceholder, thePlayerId, theFile) {
var flashvars = {
file:theFile,
autostart:true
}
var params = {
allowfullscreen:true,
allowscriptaccess:always
}
var attributes = {
id:thePlayerId,
name:thePlayerId
}
swfobject.embedSWF(scripts/player.swf, thePlaceholder, 320, 196,
9.0.115, false, flashvars, params, attributes);
}
function initPlayer(theFile) {
deletePlayer('wrapper', 'placeholder1', 'player1');
alert('URL: ' + theFile);
createPlayer('placeholder1', 'player1', theFile);
}
/script
/head
body onLoad=initPlayer('video/files/test.flv');
cfoutput query=qVideo
table width=100 border=0
tr
tdVideo/td
tdTitle/td
tdDescription/td
tdUser_submit/td
td /td
td /td
/tr
tr
tda
href=javascript:initPlayer('video/files/#video#')#video#/a/td
td#title#/td
td#description#/td
td#user_submit#/td
td /td
td /td
/tr
/table
/cfoutput
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318178
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion killed my query?
Is it true that the SQL will perform better if you cfqp any static values too? So: WHERE cfqp value=1 over: WHERE id = 1 I don't think so, generally. But query performance can be all over the map - there are a lot of contributing factors. So I wouldn't be entirely surprised if it did perform better in some cases. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318179 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfchart in cfdocument.
I assume you mean the NAME attribute, which will save the chart bits to a variable Yes, I guess so! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318180 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF - mySQL (and OT from there)
I'm trying to learn to set up a mySQL database. Does CF have to be on the same machine/server for it to talk to the mySQL database? I'm also not sure if I have to set up a web server for anything to talk to the database or can I just give it an IP that the database is on, somehow. Finally, can anyone suggest a mySQL user group? I've seen several, but I'd like a recommendation. thanks. daniel ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318181 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF - mySQL (and OT from there)
CF can connect to a database on a remote box - that's the way pretty much everything is set up, except on shared hosting where you usually have a single box filling both roles. With separate boxes you can scale the two halves separately, which is quite important as your resource needs grow, because they rarely grow in sync between the application and database layers. When you set up the CF DSN one of the fields is for the DB server, just add the IP (or name if you have one) of the server and the port number (probably 3306) and you should be good to go. I don't have a user group to recommend for you, but someone on here probably does. cheers, barneyb On Mon, Jan 19, 2009 at 10:08 AM, daniel kessler dani...@umd.edu wrote: I'm trying to learn to set up a mySQL database. Does CF have to be on the same machine/server for it to talk to the mySQL database? I'm also not sure if I have to set up a web server for anything to talk to the database or can I just give it an IP that the database is on, somehow. Finally, can anyone suggest a mySQL user group? I've seen several, but I'd like a recommendation. thanks. daniel ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318182 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF - mySQL (and OT from there)
When you set up the CF DSN one of the fields is for the DB server, just add the IP (or name if you have one) of the server and the port number (probably 3306) and you should be good to go. okay. I see. In my case, I'm in a shared hosting environment where CF and Oracle are given to me. I don't have access to the management of either, except as a user. So I couldn't point the CF to my mySQL database on another machine. I was hoping that there was a way as a CF user I could do that for certain queries. It sounds like that's a no. So to learn mySQL, it seems that I should also install the CF single-user server on my Mac OSX. I guess I should then go the whole route and enable the Apache that comes with the machine. daniel ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318183 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF - mySQL (and OT from there)
Yeah, if you don't have the DSN config available to you, you're kind of stuck. You can sort of fake it by manually doing your own JDBC connections, but that's a disaster waiting to happen. If you've got the ability to do it locally on your own hardware, I'd highly recommend that approach. Controlling your own stack from top to bottom is WAY better than having to deal with other people's stuff, especially when you're learning/playing. cheers, barneyb On Mon, Jan 19, 2009 at 10:24 AM, daniel kessler dani...@umd.edu wrote: When you set up the CF DSN one of the fields is for the DB server, just add the IP (or name if you have one) of the server and the port number (probably 3306) and you should be good to go. okay. I see. In my case, I'm in a shared hosting environment where CF and Oracle are given to me. I don't have access to the management of either, except as a user. So I couldn't point the CF to my mySQL database on another machine. I was hoping that there was a way as a CF user I could do that for certain queries. It sounds like that's a no. So to learn mySQL, it seems that I should also install the CF single-user server on my Mac OSX. I guess I should then go the whole route and enable the Apache that comes with the machine. daniel ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318184 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF - mySQL (and OT from there)
Those are good points. Thank you very much. It's way past time I learned the management side of CF anyway. I'm sure it'll be good for me. thanks for taking the time to respond. daniel ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318185 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Creating a PDF outline
Has anyone ever created an outline in a pdf dynamically using ColdFusion? If so, how do you do it? Thanks, Chuck ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318186 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Creating a PDF outline
Can you explain what you mean? Are you outlining some other data and _rendering_ it in PDF? Or are you creating an outline from PDF content? And if so, is that outline itself in PDF, or just in some CFML structure that you can do with what you want? On Mon, Jan 19, 2009 at 1:11 PM, Chuck Weidler h...@coldfusionguru.com wrote: Has anyone ever created an outline in a pdf dynamically using ColdFusion? If so, how do you do it? Thanks, Chuck -- === Raymond Camden, VP of Software Dev, Broadchoice Email: r...@camdenfamily.com Blog : www.coldfusionjedi.com AOL IM : cfjedimaster Keep up to date with the community: http://www.coldfusionbloggers.org ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318187 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Creating a PDF outline
Let me explain what I'm looking for. Sometimes when you open a PDF you will get an outline or maybe you might call it a page jump on the left hand side of the PDF when viewing it in Acrobat Reader. This is the section that you can click on and it will take you to that particular section in the PDF. Now that I have explain that, I think here is what I'm fully trying to do. 1. I will be merging multiple PDF files together using cfpdf and your (Ray Camden) pdfutils.cfc, which is awesome by the way. The PDFs are not created by the application they are uploaded by users of the site. 2. Depending on if I can produce the outline, will determine how I use cfpdf and pdfutils.cfc. The documents that are being combined can and probably will be many pages and I want to give the end receiver of the combined PDF an easy way to navigate through the PDFs. I hope this helps. Thanks, Chuck ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318188 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Strange error with cffeed
We're facing a rebuild of every CF8 server in our fleet here - if anyone has any ideas, please, please chime in. So far I've built a new cf8.01 server with the same patches, the same FusionReactor, the same JVM and the same settings on the same OS and I can't duplicate the problem, yet every server in our existing fleet has this issue. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/1/15 James Holmes james.hol...@gmail.com: We are having a similar issue with our CF8.01 SLES 10 servers. A windows dev box with the same config (multiserver install, Java 1.5.0_13 JVM, headless JVM switches) works fine with the same code but all of our SLES servers fail. The code is this simple: cffeed action=read source=http://askcurtin.custhelp.com/cgi-bin/askcurtin.cfg/php/enduser/opensearch.php?q=bachelor; query=qryFeed It fails with java.lang.NoClassDefFoundError at coldfusion.tagext.io.FeedTag.init(FeedTag.java:64) at sun.reflect.GeneratedConstructorAccessor4006.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:494) at java.lang.Class.newInstance0(Class.java:350) ... etc ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318189 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Strange error with cffeed
If it helps anyone, I think I've found the class that's failing: cfset myFeedTag = createobject(java,coldfusion.syndication.FeedDateParser).getInstance() This works on the Windows box and on the new SLES box; it fails on our main boxes with java.lang.NoClassDefFoundError at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at etc. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/1/20 James Holmes james.hol...@gmail.com: We're facing a rebuild of every CF8 server in our fleet here - if anyone has any ideas, please, please chime in. So far I've built a new cf8.01 server with the same patches, the same FusionReactor, the same JVM and the same settings on the same OS and I can't duplicate the problem, yet every server in our existing fleet has this issue. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318190 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SOT: New Project: shrinkURL - API wrapper for URL shortening services
Just wanted to take a minute to announce a new project I worked on over the weekend. It's a small library which wraps the API functionality of multiple URL shorteners into one codebase. One method to call, returns a string, couldn't be easier. I'd love to get some feedback from any of you on it. It's currently CF8 only, but that's only because I took the easy way out and used implicit struct creation in several locations. It'd be a snap to change that if anyone wants support for pre CF8. Project Link: http://snurl.com/adxsh Thanks in advance for any feedback Regards Andy Matthews ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318191 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Strange error with cffeed
James, Why are you using the 1.5 series of the JVM? Since the reinstall works, try installing the new 1.6.0_11 JVM and see if that fixes the issue? If for some reason you absolutely can not use the 1.6 version then install a second copy of the JVM you have and switch to that one. To me it sounds like a part of your JVM install got damaged or lost. Wil Genovese One man with courage makes a majority. -Andrew Jackson A fine is a tax for doing wrong. A tax is a fine for doing well. On Jan 19, 2009, at 9:50 PM, James Holmes wrote: If it helps anyone, I think I've found the class that's failing: cfset myFeedTag = createobject (java,coldfusion.syndication.FeedDateParser).getInstance() This works on the Windows box and on the new SLES box; it fails on our main boxes with java.lang.NoClassDefFoundError at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun .reflect .NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at etc. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/1/20 James Holmes james.hol...@gmail.com: We're facing a rebuild of every CF8 server in our fleet here - if anyone has any ideas, please, please chime in. So far I've built a new cf8.01 server with the same patches, the same FusionReactor, the same JVM and the same settings on the same OS and I can't duplicate the problem, yet every server in our existing fleet has this issue. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318192 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT: New Project: shrinkURL - API wrapper for URL shortening services
Hi Andy, Looks nice, but why wouldn't you just create the short URL using your own domain? I do that, and it allows me to count how many people click each short link, and also lets me put links back to my website all over the web, instead of links to the short url websites? Al ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318193 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Strange error with cffeed
The 1.6 JVM breaks the SSL for the internal JRun Webserver, which we use for administration. As an aside, if anyone can tell us how to make JWS with SSL work with Java 6 we'd be very happy. Regardless, I actually did try going back to the default CF8.01 JVM with the same results. For completeness, I downloaded a fresh copy of the 1.5_13 JVM (as was just installed on the new SLES box) and pointed jrun at that - with the same results. The first time the tag is called this is the result: java.lang.NullPointerException at java.util.Properties$LineReader.readLine(Properties.java:365) at java.util.Properties.load(Properties.java:293) at com.sun.syndication.io.impl.PropertiesLoader.init(PropertiesLoader.java:67) at com.sun.syndication.io.impl.PropertiesLoader.clinit(PropertiesLoader.java:33) at com.sun.syndication.io.impl.DateParser.clinit(DateParser.java:44) at coldfusion.syndication.FeedDateParser.init(FeedDateParser.java:29) at coldfusion.syndication.FeedDateParser.clinit(FeedDateParser.java:20) at ... etc and after that the ClassDefNotFound error occurs. So it seems that the com.sun.syndication.io.impl.PropertiesLoader can't read its properties for some reason and this causes the rest of the issues. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/1/20 Wil Genovese jugg...@visi.com: James, Why are you using the 1.5 series of the JVM? Since the reinstall works, try installing the new 1.6.0_11 JVM and see if that fixes the issue? If for some reason you absolutely can not use the 1.6 version then install a second copy of the JVM you have and switch to that one. To me it sounds like a part of your JVM install got damaged or lost. Wil Genovese One man with courage makes a majority. -Andrew Jackson A fine is a tax for doing wrong. A tax is a fine for doing well. On Jan 19, 2009, at 9:50 PM, James Holmes wrote: If it helps anyone, I think I've found the class that's failing: cfset myFeedTag = createobject (java,coldfusion.syndication.FeedDateParser).getInstance() This works on the Windows box and on the new SLES box; it fails on our main boxes with java.lang.NoClassDefFoundError at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun .reflect .NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at etc. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/1/20 James Holmes james.hol...@gmail.com: We're facing a rebuild of every CF8 server in our fleet here - if anyone has any ideas, please, please chime in. So far I've built a new cf8.01 server with the same patches, the same FusionReactor, the same JVM and the same settings on the same OS and I can't duplicate the problem, yet every server in our existing fleet has this issue. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318194 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
iframe to cause a seperate iframe to refresh
i have a page that has 2 iframes... iframe1 is a form pstpg.cfm that posts to itself and writes to table... when a visitor submits form in iframe1 need it to tell dsppg.cfm in iframe2 to refresh. i know not a cf issue but driving me nuts - note --- i use script below which has the correct function on a page that has frames and iframes body onLoad=top.topr.headr.location.href='sect_hd.cfm?secID=#gtsec.secID#' where top is a frame name. new site has no frames so all pages load in index.cfm what i need is to just tell iframe2's file to refresh when iframe1's file is acted upon. --- tnx in advance ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318195 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Strange error with cffeed
You know, you might want to try copying the tools.jar file from the
{currentjre}/lib folder to the /cfusion/lib folder. Until I did this,
my webservice calls were all shot to hell. This may only be a problem
for those that install in multiserver mode though. Maybe standalone
copies the correct file here? Or maybe it pulls it from the PATH
variable somehow? Either way, when I installed CF8 as an ear/war into
my current environment, that was a problem for me.
Matthew Williams
Geodesic GraFX
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318196
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: iframe to cause a seperate iframe to refresh
see if any of these can help you: http://bytes.com/groups/javascript/148043-refreshing-one-iframe-another http://www.tek-tips.com/viewthread.cfm?qid=1281918page=6 http://www.daniweb.com/forums/thread130202.html but, as was wisely suggested in of the other links i found: DON'T use iframes - use AJAX. Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ andy mann wrote: i have a page that has 2 iframes... iframe1 is a form pstpg.cfm that posts to itself and writes to table... when a visitor submits form in iframe1 need it to tell dsppg.cfm in iframe2 to refresh. i know not a cf issue but driving me nuts - note --- i use script below which has the correct function on a page that has frames and iframes body onLoad=top.topr.headr.location.href='sect_hd.cfm?secID=#gtsec.secID#' where top is a frame name. new site has no frames so all pages load in index.cfm what i need is to just tell iframe2's file to refresh when iframe1's file is acted upon. --- tnx in advance ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318197 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Strange error with cffeed
Yeah, we do that as part of every standard install when we change the
JVM - it's a good tip for anyone reading though.
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/
2009/1/20 Matthew Williams mai...@geodesicgrafx.com:
You know, you might want to try copying the tools.jar file from the
{currentjre}/lib folder to the /cfusion/lib folder. Until I did this,
my webservice calls were all shot to hell. This may only be a problem
for those that install in multiserver mode though. Maybe standalone
copies the correct file here? Or maybe it pulls it from the PATH
variable somehow? Either way, when I installed CF8 as an ear/war into
my current environment, that was a problem for me.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318198
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Creating a PDF outline
Not sure, but it may be worth checking out - it MAY create the outline from h1 , h3 , h3 elements in your document. I could be wrong tho, but its worth a shot. Mark On Tue, Jan 20, 2009 at 12:25 PM, Chuck h...@coldfusionguru.com wrote: Let me explain what I'm looking for. Sometimes when you open a PDF you will get an outline or maybe you might call it a page jump on the left hand side of the PDF when viewing it in Acrobat Reader. This is the section that you can click on and it will take you to that particular section in the PDF. Now that I have explain that, I think here is what I'm fully trying to do. 1. I will be merging multiple PDF files together using cfpdf and your (Ray Camden) pdfutils.cfc, which is awesome by the way. The PDFs are not created by the application they are uploaded by users of the site. 2. Depending on if I can produce the outline, will determine how I use cfpdf and pdfutils.cfc. The documents that are being combined can and probably will be many pages and I want to give the end receiver of the combined PDF an easy way to navigate through the PDFs. I hope this helps. Thanks, Chuck ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318199 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Strange error with cffeed
Right, I have the solution.
We have sandboxing turned on; while just about everything works as you
would expect without it, it appears that for some functionality
(including cffeed) the path to [coldfusion
instance]/WEB-INF/cfusion/lib needs to be added to the sandbox. After
adding the permissions I had to restart too (to re-create the classes
for the relevant pages, no doubt); just clearing the template cache
didn't do the job. With this, the problem is fixed.
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/
2009/1/20 James Holmes james.hol...@gmail.com:
Yeah, we do that as part of every standard install when we change the
JVM - it's a good tip for anyone reading though.
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/
2009/1/20 Matthew Williams mai...@geodesicgrafx.com:
You know, you might want to try copying the tools.jar file from the
{currentjre}/lib folder to the /cfusion/lib folder. Until I did this,
my webservice calls were all shot to hell. This may only be a problem
for those that install in multiserver mode though. Maybe standalone
copies the correct file here? Or maybe it pulls it from the PATH
variable somehow? Either way, when I installed CF8 as an ear/war into
my current environment, that was a problem for me.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318200
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
