Re: CF8 Image manipulation
normal 8 handles? what is that? where is it 'normal to see them??? the only thing i can think of where an image has 8 handles when you click on it is M$ applications... and even then it is not always the case... what handles are you talking about? Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Terry Troxel wrote: I am loving the CF8 Image drawing functions, but have a question. Consider this: I have drawn an image and written it to the browser. Has anyone seen a way to click on an image and then get the normal 8 handles and be able to massage the angles by clicking on a corner handle and adusting the perspective or clicking in the middle and moving the whole image. Terry ~| 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:320217 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8 Image manipulation
Your browser is not an image editor - it cannot manipulate *any* images in this way -regardless of what server-side language/application generated them. To the browser there is no significant difference with the image downloaded from your server and any other image downloaded from the web. If your want your website users to be able to modify images in-browser, you will need either a Flash app or a specific browser plugin. ~| 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:320218 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF8 Image manipulation
Azadi, What I was trying to explain was normally when you click on an image object you get top left, top middle, top right, left, right, bottom left, bottom center and bottom right handles that you can then manipulate them. Sorry it was late. Terry -Original Message- From: Azadi Saryev [mailto:az...@sabai-dee.com] Sent: Sunday, March 08, 2009 12:55 AM To: cf-talk Subject: Re: CF8 Image manipulation normal 8 handles? what is that? where is it 'normal to see them??? the only thing i can think of where an image has 8 handles when you click on it is M$ applications... and even then it is not always the case... what handles are you talking about? Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Terry Troxel wrote: I am loving the CF8 Image drawing functions, but have a question. Consider this: I have drawn an image and written it to the browser. Has anyone seen a way to click on an image and then get the normal 8 handles and be able to massage the angles by clicking on a corner handle and adusting the perspective or clicking in the middle and moving the whole image. Terry ~| 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:320219 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 Facebook
If I may be so bold, I'll also bring up this article: http://www.adobe.com/devnet/coldfusion/articles/coldfusion_facebook.html On Sat, Mar 7, 2009 at 12:22 PM, Monte Chan monte_c...@sanctuarysoftwareonline.com wrote: Hi Michael, I have done five Facebook apps using ColdFusion and there are 3 others in the works right now. In addition to the traditional Facebook application, Facebook now has the Facebook Connect option. What Facebook Connect allows you to do is for you to allow your users to log on using their Facebook user name and password. As a result, you can also access their Facebook profiles/information. You can view the details of Facebook Connect on http://wiki.developers.facebook.com/index.php/Facebook_Connect That said, you can keep the video files on your company site. At the same time, you incorporate the Facebook Connect option on your company site too. If anyone logs on using their Facebook credentials, you can provide an option for them to authorize your company to post the video files on their own profiles. This way, you are not creating a Facebook application but you get the job done. Is this the solution that you are looking for? Best Regards, Monte Ok, here's the issue I present to the gurus on this list. I know absolutely nothing about Facebook, I just created an account recently. The only thing I've found out is what an amazing time sucking application it is. But, my company (i.e. sales weenies who convinced the CEO) determined that we must upload our video files (.mp4s to be precise) to Facebook. Both to our own company page, and if one of our users enters their username and password, to their page as well. Is there an easy way to do this? I've already looked through the ColdFusion Facebook Dev site by Gavin Vincent, and it looks like way more than I need. And the documentation on Facebook keeps stating that I need to create an app, but from my (admittedly) very limited understanding of Facebook apps, is that the other user would have to approve of my app to gain access to their page to upload the video. We really need this to be as simple as possible for our users, i.e. all they have to do is enter their Facebook login info and my code will do the rest. If I have to build a full-blown app, I will, but I was hoping somebody on this list has done this before and can at least point me in the right direction. Thanks in Advance! Michael ~| 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:320220 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF8 Image manipulation
I beg to differ, but I have a cfx_efflare and it allows me to click on an image and crop it on the admin area of my sites. I can click and drag to any part of the image and then resize to my heart's content. What I am looking for is a way to do a similar thing only basically change a rectangle into a trapezoid in order to make the perspective of the image I am placing over another fit perspective wise. Not trying to start a flame here, just looking for some new ideas. Terry -Original Message- From: Peter Boughton [mailto:bought...@gmail.com] Sent: Sunday, March 08, 2009 6:26 AM To: cf-talk Subject: Re: CF8 Image manipulation Your browser is not an image editor - it cannot manipulate *any* images in this way -regardless of what server-side language/application generated them. To the browser there is no significant difference with the image downloaded from your server and any other image downloaded from the web. If your want your website users to be able to modify images in-browser, you will need either a Flash app or a specific browser plugin. ~| 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:320221 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 Facebook
Nobody can resist pitching their wares... not even that Camden feller. G! On Sun, Mar 8, 2009 at 9:57 AM, Raymond Camden rcam...@gmail.com wrote: If I may be so bold, I'll also bring up this article: http://www.adobe.com/devnet/coldfusion/articles/coldfusion_facebook.html -- Gerald Guido http://www.myinternetisbroken.com To invent, you need a good imagination and a pile of junk. -- Thomas A. Edison ~| 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:320222 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
true false
Isnt there a CF function that takes a 1 or 0 and converts it to display True or False? Or am I dreaming? ~| 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:320223 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: true false
YesNoFormat does it for yes and no, but nothing built in for true and false. cheers, barneyb On 3/8/09, Chad Gray cg...@careyweb.com wrote: Isnt there a CF function that takes a 1 or 0 and converts it to display True or False? Or am I dreaming? ~| 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:320224 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: true false
Ah.. I was not dreaming. I knew there was something built in. Thanks Barney! -Original Message- From: Barney Boisvert [mailto:bboisv...@gmail.com] Sent: Sunday, March 08, 2009 1:31 PM To: cf-talk Subject: Re: true false YesNoFormat does it for yes and no, but nothing built in for true and false. cheers, barneyb On 3/8/09, Chad Gray cg...@careyweb.com wrote: Isnt there a CF function that takes a 1 or 0 and converts it to display True or False? Or am I dreaming? ~| 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:320225 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: true false
You can build your own. cffunction name=yesnoformat return=string cfargument name=bValue required='true' cfif arguments.bValue cfreturn 'True' cfelse cfreturn 'False' /cfif /cffunction Not tested, but along these lines... William -- William E. Seiter Need to have your mortgage modified? I charge no fees until I am successful, then I charge almost half the rate you would find elsewhere. Professional. Dedicated. Effective. The Easy 24/7 way to get started: http://www.goldengrove.net/ or you can call: (626) 593 - 5501 -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Sunday, March 08, 2009 10:23 AM To: cf-talk Subject: true false Isnt there a CF function that takes a 1 or 0 and converts it to display True or False? Or am I dreaming? ~| 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:320226 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8 Image manipulation
I beg to differ, but I have a cfx_efflare and it allows me to click on an image and crop it on the admin area of my sites. I can click and drag to any part of the image and then resize to my heart's content. The last time I looked at CFX_Efflare, it didn't have any client-side functionality. But in any case, you would need client-side functionality to do this - just generating an image on the server is not enough. 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:320227 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: true false
Prolly should have called it 'truefalseformat', instead of an already defined function of 'yesnoformat' ::blush:: =^) -- William E. Seiter Need to have your mortgage modified? I charge no fees until I am successful, then I charge almost half the rate you would find elsewhere. Professional. Dedicated. Effective. The Easy 24/7 way to get started: http://www.goldengrove.net/ or you can call: (626) 593 - 5501 -Original Message- From: William Seiter [mailto:will...@seiter.com] Sent: Sunday, March 08, 2009 10:43 AM To: cf-talk Subject: RE: true false You can build your own. cffunction name=yesnoformat return=string cfargument name=bValue required='true' cfif arguments.bValue cfreturn 'True' cfelse cfreturn 'False' /cfif /cffunction Not tested, but along these lines... William -- William E. Seiter Need to have your mortgage modified? I charge no fees until I am successful, then I charge almost half the rate you would find elsewhere. Professional. Dedicated. Effective. The Easy 24/7 way to get started: http://www.goldengrove.net/ or you can call: (626) 593 - 5501 -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Sunday, March 08, 2009 10:23 AM To: cf-talk Subject: true false Isnt there a CF function that takes a 1 or 0 and converts it to display True or False? Or am I dreaming? ~| 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:320228 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: true false
Semi-sorta: #IIF(myvar eq 1, DE(true), DE(false))# On Sun, Mar 8, 2009 at 12:36 PM, Chad Gray cg...@careyweb.com wrote: Ah.. I was not dreaming. I knew there was something built in. Thanks Barney! -Original Message- From: Barney Boisvert [mailto:bboisv...@gmail.com] Sent: Sunday, March 08, 2009 1:31 PM To: cf-talk Subject: Re: true false YesNoFormat does it for yes and no, but nothing built in for true and false. cheers, barneyb On 3/8/09, Chad Gray cg...@careyweb.com wrote: Isnt there a CF function that takes a 1 or 0 and converts it to display True or False? Or am I dreaming? ~| 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:320229 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: true false
You're possibly thinking of Railo's TrueFalseFormat function. Does exactly the same as YesNoFormat, but with true and false. ~| 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:320230 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
phpBB to Galleon migration?
Has anyone ever carried out a successful migration from phpBB to Galleon (or even any other CF-based forum)? After wasting nearly a whole Sunday trying to get PHP installed and running on a new web server (just to transfer across an existing phpBB forum), I've really had enough of PHP (although it's working now.) I'd really like to move to a CFML-based forum, but my client has a fairly sizeable archive of posts (recently passed 300,000), so retaining all these is essential. [Who knew there was that much to say about making cards and parchment craft...] Seb Seb Duggan Web ColdFusion Developer e: s...@sebduggan.com t: 07786 333184 w: http://sebduggan.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:320231 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: true false
#IIF(myvar eq 1, DE(true), DE(false))# Actually you can get a little bit cleaner than this even: #iif(myvar,true,false)# True and false don't need the DE wrappers because they're boolean values, so they evaluate to themselves and then as long as myvar is a boolean, you don't have to explicitly compare it to 1 (although you can if you like). -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 817.385.0301 http://onTap.riaforge.org/blog ~| 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:320232 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF8 Image manipulation
Dave, I sent the guys at Efflare a the code I downloaded at http://www.defusion.org.uk/demos/060519/cropper.php And they sent me a script for cfx_imageflare to allow me to do the following: User uploads a photo, cfx_imagecr3 resizes to 760px with proper aspect ratio, optimizes to 72 dpi. The resulting image is then displayed in the browser. Then when the user clicks on the image the cropping code I got from the link above displays a 760px x 300px rectangle that can be dragged up-down to select the panoramic view to crop from the image when you click the submit button. I Have forced the width to be 760px for my task, but as you wull see in the demo link there is much, much more. But what I am looking for is how to use the same functionality as above. But to be able to decrease the bottom width and leave the top alone to create a trapezoid. Terry -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Sunday, March 08, 2009 10:44 AM To: cf-talk Subject: Re: CF8 Image manipulation I beg to differ, but I have a cfx_efflare and it allows me to click on an image and crop it on the admin area of my sites. I can click and drag to any part of the image and then resize to my heart's content. The last time I looked at CFX_Efflare, it didn't have any client-side functionality. But in any case, you would need client-side functionality to do this - just generating an image on the server is not enough. 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:320233 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: true false
Indeed, evaluating to 1 is not strictly correct because: false = 0 true = not false Dominic ~| 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:320234 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF8 Image manipulation
Cropping is easy, because JavaScript can mimic it with transparent/shaded backgrounds, and just send the coordinates of the corner back to the server to perform the actual manipulation. Likewise, normal resizing is also rectangular and easy to mimic in JS. Creating a trapezoid is more difficult, you wont be able to get a 'live preview', though you could use a similar technique to the cropping to define the widths of the top and bottom edge. However, there aren't any trapezoid/trapezium mainupulations with CF8s image functions - the closest is Skew/Shear which wont do what you want. I couldn't find any useful Java-based results either - apparently Java manipulations keep lines straight and parallel, which prevents trapezoiding as this obviously makes them non-parallel. Maybe you could investigate using GIMP on the command line to do this - although that appears to involve writing LISP... http://www.gimp.org/tutorials/Basic_Batch/ ~| 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:320235 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF8 Image manipulation
Cropping is easy, because JavaScript can mimic it with transparent/shaded backgrounds, and just send the coordinates of the corner back to the server to perform the actual manipulation. Likewise, normal resizing is also rectangular and easy to mimic in JS. Creating a trapezoid is more difficult - you wont be able to get a 'live preview', though you could use a similar technique to the cropping to define the widths of the top and bottom edge. However, there aren't any trapezoid/trapezium manipulations with CF8s image functions - the closest is Skew/Shear which wont do what you want. I couldn't find any useful Java-based results either - apparently Java manipulations keep lines straight and parallel, which prevents trapezoiding which of course makes them non-parallel. Maybe you could investigate using GIMP on the command line to do this - although that appears to involve writing LISP... http://www.gimp.org/tutorials/Basic_Batch/ But other than that, can't think of any solutions, unless there are other cfx tags that will support trapezoidizing images (maybe ImageMagick does?) ~| 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:320236 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 Facebook
Nobody can resist pitching their wares... not even that Camden feller. I did for sometime but hey, for a stripped down starter into facebook apps, there is always: http://fbmlstarter.riaforge.org/ :p Dominic ~| 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:320237 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: true false
Yes, but I think he wanted it to display TRUE or FALSE the way the yesnoformat displays YES or NO. On Sun, Mar 8, 2009 at 11:50 AM, s. isaac dealey i...@turnkey.to wrote: #IIF(myvar eq 1, DE(true), DE(false))# Actually you can get a little bit cleaner than this even: #iif(myvar,true,false)# True and false don't need the DE wrappers because they're boolean values, so they evaluate to themselves and then as long as myvar is a boolean, you don't have to explicitly compare it to 1 (although you can if you like). ~| 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:320238 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
What the heck is happening during CFQUERY?
Hi, I've always thought that all what CFQUERY was doing was to create some connection to the database, and then the actual content of all records would be read as needed during some loop on the result set. I have this statement on some Access database : CFQUERY NAME=getArmes DATASOURCE=Armoriaux SELECT armeId, armTexte FROM armesArmoriaux /CFQUERY CFOUTPUTgetArmes.recordCount = #getArmes.recordCount#BR cfquery.ExecutionTime = #cfquery.ExecutionTime#BR/CFOUTPUTCFABORT The query semms to take for ever. Actually, the output says: getArmes.recordCount = 303203 cfquery.ExecutionTime = 614469 More than 10 min. just to settle a result set? That does not make sense. Ok, armTexte is a memo field, but is CFQUERY supposed to read all of them? If I run the same query directly from Access, it runs so fast, I cannot even measure the time it takes. So, what the heck CF is doing within CFQUERY? Read all content? That does not make sense. Is the problem with CF, or the ODBC driver? ~| 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:320239 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What the heck is happening during CFQUERY?
Yes, CFQUERY reads all the content of the query. It gets a connection from the pool, queries the DB, retrieves all the data and finally returns the connection to the pool. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/3/9 Claude Schneegans schneeg...@internetique.com: Hi, I've always thought that all what CFQUERY was doing was to create some connection to the database, and then the actual content of all records would be read as needed during some loop on the result set. I have this statement on some Access database : CFQUERY NAME=getArmes DATASOURCE=Armoriaux SELECT armeId, armTexte FROM armesArmoriaux /CFQUERY CFOUTPUTgetArmes.recordCount = #getArmes.recordCount#BR cfquery.ExecutionTime = #cfquery.ExecutionTime#BR/CFOUTPUTCFABORT The query semms to take for ever. Actually, the output says: getArmes.recordCount = 303203 cfquery.ExecutionTime = 614469 More than 10 min. just to settle a result set? That does not make sense. Ok, armTexte is a memo field, but is CFQUERY supposed to read all of them? If I run the same query directly from Access, it runs so fast, I cannot even measure the time it takes. So, what the heck CF is doing within CFQUERY? Read all content? That does not make sense. Is the problem with CF, or the ODBC drive ~| 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:320240 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What the heck is happening during CFQUERY?
The CFQUERY connects to the database, returns the whole of the resulting query result into the specified variable, then closes the connection; the variable is held in memory for the lifetime of the request. So, if you run a query that, as in this case, returns more than 300,000 records, there is going to be a significant overhead as the data is read out of the database and into ColdFusion. Especially if one of those fields is a memo field. I don't think this is unexpected behaviour - you just need to examine what you actually require from the query, and tailor your SQL to that. It is highly unlikely that you actually need to work with 300,000 records at one time... Seb Duggan Web ColdFusion Developer e: s...@sebduggan.com t: 07786 333184 w: http://sebduggan.com On 8 Mar 2009, at 22:42, Claude Schneegans wrote: Hi, I've always thought that all what CFQUERY was doing was to create some connection to the database, and then the actual content of all records would be read as needed during some loop on the result set. I have this statement on some Access database : CFQUERY NAME=getArmes DATASOURCE=Armoriaux SELECT armeId, armTexte FROM armesArmoriaux /CFQUERY CFOUTPUTgetArmes.recordCount = #getArmes.recordCount#BR cfquery.ExecutionTime = #cfquery.ExecutionTime#BR/ CFOUTPUTCFABORT The query semms to take for ever. Actually, the output says: getArmes.recordCount = 303203 cfquery.ExecutionTime = 614469 More than 10 min. just to settle a result set? That does not make sense. Ok, armTexte is a memo field, but is CFQUERY supposed to read all of them? If I run the same query directly from Access, it runs so fast, I cannot even measure the time it takes. So, what the heck CF is doing within CFQUERY? Read all content? That does not make sense. Is the problem with CF, or the ODBC driver? ~| 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:320241 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What the heck is happening during CFQUERY?
By the time the cfquery tag has finished executing the entire data set has been returned from the database and is loaded into memory in ColdFusion. If the cfquery tag is taking a very long time to complete then: 1) The actual SQL is taking a long time to complete. 2) and/or you are returning a very large amount of data to the ColdFusion server 3) and/or you have very slow connection between your SQL server and your CF server. 302 thousands records is quite a bit-- especially if you have a memo field in there. Can you even add indexes in Access? If so, you might want to consider it. If you just want a count, then just do select count(1) and only a single record has to pass from your database to CF. There are a number of reasons why running the select directly in Access may appear much faster. 1) You are probably running it locally so there is no costly transfer of data between servers. 2) In my experience, Access spools the data behind the scenes and only loads in the records which are visible on the screen which gives your query a very fast turn-around and then it lazy-loads the data in as your scroll down. ~Brad - Original Message - From: Claude Schneegans schneeg...@internetique.com To: cf-talk cf-talk@houseoffusion.com Sent: Sunday, March 08, 2009 5:42 PM Subject: What the heck is happening during CFQUERY? Hi, I've always thought that all what CFQUERY was doing was to create some connection to the database, and then the actual content of all records would be read as needed during some loop on the result set. I have this statement on some Access database : CFQUERY NAME=getArmes DATASOURCE=Armoriaux SELECT armeId, armTexte FROM armesArmoriaux /CFQUERY CFOUTPUTgetArmes.recordCount = #getArmes.recordCount#BR cfquery.ExecutionTime = #cfquery.ExecutionTime#BR/CFOUTPUTCFABORT The query semms to take for ever. Actually, the output says: getArmes.recordCount = 303203 cfquery.ExecutionTime = 614469 ~| 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:320242 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What the heck is happening during CFQUERY?
Change it to this and the time should go down by a factor of about 100,000 : CFQUERY NAME=getArmes DATASOURCE=Armoriaux SELECT count (*) as N FROM armesArmoriaux /CFQUERY CFOUTPUTgetArmes.recordCount = #getArmes.n#BR cfquery.ExecutionTime = #cfquery.ExecutionTime#BR/CFOUTPUTCFABORT Hi, I've always thought that all what CFQUERY was doing was to create some connection to the database, and then the actual content of all records would be read as needed during some loop on the result set. I have this statement on some Access database : CFQUERY NAME=getArmes DATASOURCE=Armoriaux SELECT armeId, armTexte FROM armesArmoriaux /CFQUERY CFOUTPUTgetArmes.recordCount = #getArmes.recordCount#BR cfquery.ExecutionTime = #cfquery.ExecutionTime#BR/CFOUTPUTCFABORT The query semms to take for ever. Actually, the output says: getArmes.recordCount = 303203 cfquery.ExecutionTime = 614469 More than 10 min. just to settle a result set? That does not make sense. Ok, armTexte is a memo field, but is CFQUERY supposed to read all of them? If I run the same query directly from Access, it runs so fast, I cannot even measure the time it takes. So, what the heck CF is doing within CFQUERY? Read all content? That does not make sense. Is the problem with CF, or the ODBC driver? ~| 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:320243 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
How to convert GMT Time into something I can use
Hey all, I'm building an app which is using the Checkout by Amazon service. Whenever an order is placed, Amazon is nice enough to pass me an order notification in xml which contains the data associated w/ the order. Problem is, the order date they are passing is in Greenwich Mean Time, and looks pretty funky to me: example: 2009-03-08T06:23:15.000Z I tried to run some cf functions on that to see if it could operate on it, but CF is telling me it's not a valid date/time string. Does anyone have any insight on how I can convert this to something I can use? Maybe an ODBC datetime ...? Thanks a lot, Brian FitzGerald ~| 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:320244 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How to convert GMT Time into something I can use
Did you try DateConvert()? http://cfquickdocs.com/cf8/?getDoc=DateConvert mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/3/9 Brian FitzGerald bmfitzgera...@yahoo.com: Hey all, I'm building an app which is using the Checkout by Amazon service. Whenever an order is placed, Amazon is nice enough to pass me an order notification in xml which contains the data associated w/ the order. Problem is, the order date they are passing is in Greenwich Mean Time, and looks pretty funky to me: example: 2009-03-08T06:23:15.000Z I tried to run some cf functions on that to see if it could operate on it, but CF is telling me it's not a valid date/time string. Does anyone have any insight on how I can convert this to something I can use? Maybe an ODBC datetime ...? Thanks a lot, Brian FitzGerald ~| 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:320245 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: true false
I thought this sample would do that. Yes, but I think he wanted it to display TRUE or FALSE the way the yesnoformat displays YES or NO. On Sun, Mar 8, 2009 at 11:50 AM, s. isaac dealey i...@turnkey.to wrote: #IIF(myvar eq 1, DE(true), DE(false))# Actually you can get a little bit cleaner than this even: #iif(myvar,true,false)# True and false don't need the DE wrappers because they're boolean values, so they evaluate to themselves and then as long as myvar is a boolean, you don't have to explicitly compare it to 1 (although you can if you like). -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 817.385.0301 http://onTap.riaforge.org/blog ~| 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:320246 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How to convert GMT Time into something I can use
Problem is, the order date they are passing is in Greenwich Mean Time, and looks pretty funky to me: I used this. Seemed to work fine... http://www.cflib.org/udf/DateConvertZ 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:320247 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Compare FieldValues with DataBase Values
Hi All, I have an issue and I am out of my mind.. to solve it. FieldNames: FirstName, LastName,Address,PhoneNumber, EmployerID, DepartmentID , DepartmentName, EmployerID, Branch Table Employee FirstName, LastName,Address,PhoneNumber, EmployerID Table Department DepartmentID , DepartmentName, EmployerID, Branch I have a FirstName attribute in the table and I want to compare these attribute (FirstName) with the fieldvalue. I thought of using arrays but I dont know how to add database date to the array and compare. I also have one more issue. I am trying to insert data into the database and once the data is inserted the inserted (FirstName) should be displayed (Primary Key is EmployerID). If I add n number of FirstNames in the table in the session then it should display those many New entry values in the main page. How can we do it? Can anyone help me with this? Thanks in Advance... Priya ~| 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:320248 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How to convert GMT Time into something I can use
Hey there James, thanks for the response ... Actually, I hadn't tried dateConvert simply because I figured if one date function wouldn't recognize the string as a valid datetime string, then none of them would. I went ahead and gave dateConvert() a go and came up w/ the same error: dateConvert(localToUtc, 2009-03-08T06:23:15.000Z); 2009-03-08T06:23:15.000Z is an invalid date or time string. ~| 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:320249 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How to convert GMT Time into something I can use
Brian FitzGerald wrote: Problem is, the order date they are passing is in Greenwich Mean Time, and looks pretty funky to me: example: 2009-03-08T06:23:15.000Z that's iso8601 format. there's code to convert to cf datetimes in the comments here: http://www.bennadel.com/blog/811-Converting-ISO-Date-Time-To-ColdFusion-Date-Time.htm ~| 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:320250 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How to convert GMT Time into something I can use
Wow, all sorts of great info here... thanks a million. I tried the function you linked to Will but didn't have much luck w/ that. You'll have to show me how you managed to finesse that at work. Paul, you were right, Ben's post and subsequent comments right on target for this situation. I got a function out of there that is doing the trick quite nicely. Thanks again, Brian ~| 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:320251 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Compare FieldValues with DataBase Values
Any ideas? Hi All, I have an issue and I am out of my mind.. to solve it. FieldNames: FirstName, LastName,Address,PhoneNumber, EmployerID, DepartmentID , DepartmentName, EmployerID, Branch Table Employee FirstName, LastName,Address,PhoneNumber, EmployerID Table Department DepartmentID , DepartmentName, EmployerID, Branch I have a FirstName attribute in the table and I want to compare these attribute (FirstName) with the fieldvalue. I thought of using arrays but I dont know how to add database date to the array and compare. I also have one more issue. I am trying to insert data into the database and once the data is inserted the inserted (FirstName) should be displayed (Primary Key is EmployerID). If I add n number of FirstNames in the table in the session then it should display those many New entry values in the main page. How can we do it? Can anyone help me with this? Thanks in Advance... Priya ~| 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:320252 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Compare FieldValues with DataBase Values
- Original Message - From: Priya Koya priya23...@gmail.com To: cf-talk cf-talk@houseoffusion.com I have an issue and I am out of my mind.. to solve it. FieldNames: FirstName, LastName,Address,PhoneNumber, EmployerID, DepartmentID , DepartmentName, EmployerID, Branch Ok, what about these field names? Can you explain for us please? Are these columns in a table? Columns in a result set? Do you realize you have EmployerID in there twice?? Table Employee FirstName, LastName,Address,PhoneNumber, EmployerID Is EmployerID the primary key or a foreign key? I would have expected it to be called EmployeeID if it were the primary key, since an employer employs the employee. Table Department DepartmentID , DepartmentName, EmployerID, Branch I have a FirstName attribute in the table and I want to compare these attribute (FirstName) with the fieldvalue. What field value?? Is this in a ColdFusion page or a SQL statement? Where is the fieldvalue coming from? A form? The Url? In what way do you want to compare? Do you want to compare a single record, or more than one? ? I thought of using arrays but I don't know how to add database date to the array and compare. What is a database date? None of the columns you have mentioned so far seem to have anything to do with dates. Setting a date into an array is easy as cfset myArray = [now()] but I'm not sure where you are going with this. I also have one more issue. I am trying to insert data into the database and once the data is inserted the inserted (FirstName) should be displayed (Primary Key is EmployerID). What table is this? The employee table? If EmployerID is the primary key of the Employee table, why is that column also in the Department table? If two people are in the same department, do you have two department records with the same department name, but different EmployerIds? I'm quite confused. If I add n number of FirstNames in the table in the session then it should display those many New entry values in the main page. How can we do it? Is the table in session, or do you simply mean inserts into the database during a user's session? So you want to have a screen that shows someone the records they entered since their session started? You could store the data in a session variable, or store the primary key of the records they inserted. I'm not sure where you are headed, but this would also be possible if you had a userIDModified in the table and a datetimeCreated column. You could simply query out the records that user had inserted since the time their session started. Can anyone help me with this? Probably, but we need a bit more direction on what it is you are doing. I'm pretty bad at guessing. ~Brad ~| 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:320253 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
