Re: Retrieve data in groups
Select TOP doesn't work in MySQL. You have to use Limit 0, N where N= the number of records you want to return On Fri, Jun 17, 2011 at 11:17 AM, John M Bliss wrote: > > SELECT TOP 10 ... > > or > > > > or > > > > On Fri, Jun 17, 2011 at 12:57 PM, Torrent Girl wrote: > >> >> >Hi All. >> > >> >Is there a way for me to retrieve records from a db in groups? >> > >> >I have a query that selects over 200,000 records and it times out on the >> cf output. >> > >> >Thanks >> >> I don't think I asked this right. What I need to do is encrypt user >> passwords I need to do it in CF. Problem is there are over 200,00 records >> which is too much for the cf loop and output. >> >> Any suggestions? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345419 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Retrieve data in groups
There are many ways to do this, although some of the ways depend on which database software you are using. The suggestions John made are a good starting point. Cfloop can handle as many rows as you want it to handle. If you are getting a timeout, increase the timeout. 200,000 records is a reasonable number for CF to handle, although processing each row individually probably bumps up against the default timeout limit. -Mike Chabot On Fri, Jun 17, 2011 at 1:57 PM, Torrent Girl wrote: > > >Hi All. > > > >Is there a way for me to retrieve records from a db in groups? > > > >I have a query that selects over 200,000 records and it times out on the > cf output. > > > >Thanks > > I don't think I asked this right. What I need to do is encrypt user > passwords I need to do it in CF. Problem is there are over 200,00 records > which is too much for the cf loop and output. > > Any suggestions? > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345418 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Encrypt/Decrypt
> My preferred encryption algorithm is AES, as this is what the > Government uses to encrypt classified documents. :) AES with a 256-bit key is authorized for use up to top secret, if memory serves. Remember, with any encryption, it's only as safe as the keys you use which is why key management is seeing a lot more scrutiny these days from security auditors. See the FIPS-140-2 guide for the juicy details on the US government's standards for cryptography and key management. -Justin ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345417 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Encrypt/Decrypt
My preferred encryption algorithm is AES, as this is what the Government uses to encrypt classified documents. :) Paul Alkema http://paulalkema.com http://twitter.com/#!/paulalkema ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345416 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Applying hotFixes and updates
you may also want to try www.merlinmanager.com Russ On Fri, Jun 17, 2011 at 9:09 PM, Wil Genovese wrote: > > Yes, there is confusion, but if you follow the instructions closely you > will notice they include which files to removed from the update folder. > There are times when certain jar files are deprecated or overwritten. > While the update process is tedious, if you follow the instructions EXACTLY > you will succeed. I know this, because I've had to fully patch several > CF8.0.1 servers. > > There are a few good resources. > > Charlie Arhart has an excellent writeup > > http://www.carehart.org/blog/client/index.cfm/2010/12/12/cfmyths_cumulative_hotfixes > > David Epler's Blog - > > http://www.dcepler.net/post.cfm/what-does-a-fully-patched-coldfusion-8-0-1-server-look-like > > And my blog > http://www.trunkful.com/index.cfm/2011/3/7/When-the-Patch-Fails > > > > > > Wil Genovese > Sr. Web Application Developer/ > Systems Administrator > CF Webtools > www.cfwebtools.com > > wilg...@trunkful.com > www.trunkful.com > > On Jun 17, 2011, at 2:59 PM, Russ Michaels wrote: > > > > > I think there is some confusion here. > > > > If you install a hotfix which is simply a JAR file by uploading it via > the > > cfadmin, it gets uploaded to the UPDATES folder. > > This is where it now gets loaded from. If you delete it from the updates > > folder, CF will no longer load it. Jars loaded from the updates folder > get > > loaded last, so they overwrite the previous classes that had the bugs, > thus > > is is a temporary hotfix. > > When the instructions tell you that you can delete the files, they means > the > > ones you downloaded, not the ones you just installed, which would be > silly. > > Unless they are specifically referring to OTHER files than the ones you > are > > currently installing, such as files to be replaced. > > > > If you are installing an update that is not manual, i.e. there is an > > automated installer, then this usually replaces the original core files > > rather than install hotfixes, so you don;t have to worry about it. > > > > When you install a major update such as 8.0.1 or cumulative hotfix this > will > > (or should) include all the previous hotfixes and updates, so you can > then > > delete them from the updates folder to avoid the hotfix overriding the > > update. You should of course check that they are included in your update > > first though, this information is in the release notes. > > > > Russ > > > > On Fri, Jun 17, 2011 at 6:43 PM, Rex wrote: > > > >> > >> Hi Brook, > >> > >> The CF 8.0.0 hotfix instructions says to only delete the following: > >> > >> * hf800-1.jar > >> * hf800-2.jar > >> * hf800-70523.jar > >> * hf800-71471.jar > >> * hf800-73122.jar > >> * hf800-1875.jar > >> * hf800-77218.jar > >> * hf800-1878.jar > >> > >> So leave everything else. > >> > >> Also, looks like you applied the 8.0.0 fix (because you applied > >> hf800-3.jar) but you are following the instructions for 8.0.1 > >> (because you said "You do not need to keep the ColdFusion 8.0.1 > >> cumulative hot fix JAR file after installing it with the ColdFusion > >> Administrator"), so make sure you are using and reading the correct CF > >> version. > >> > >> Make sure you are applying the correct JARs, and deleting the JARs that > >> it tells you to delete. > >> > >> - Rex > >> > >> > >> > >> > > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345415 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Applying hotFixes and updates
Yes, there is confusion, but if you follow the instructions closely you will notice they include which files to removed from the update folder. There are times when certain jar files are deprecated or overwritten. While the update process is tedious, if you follow the instructions EXACTLY you will succeed. I know this, because I've had to fully patch several CF8.0.1 servers. There are a few good resources. Charlie Arhart has an excellent writeup http://www.carehart.org/blog/client/index.cfm/2010/12/12/cfmyths_cumulative_hotfixes David Epler's Blog - http://www.dcepler.net/post.cfm/what-does-a-fully-patched-coldfusion-8-0-1-server-look-like And my blog http://www.trunkful.com/index.cfm/2011/3/7/When-the-Patch-Fails Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com wilg...@trunkful.com www.trunkful.com On Jun 17, 2011, at 2:59 PM, Russ Michaels wrote: > > I think there is some confusion here. > > If you install a hotfix which is simply a JAR file by uploading it via the > cfadmin, it gets uploaded to the UPDATES folder. > This is where it now gets loaded from. If you delete it from the updates > folder, CF will no longer load it. Jars loaded from the updates folder get > loaded last, so they overwrite the previous classes that had the bugs, thus > is is a temporary hotfix. > When the instructions tell you that you can delete the files, they means the > ones you downloaded, not the ones you just installed, which would be silly. > Unless they are specifically referring to OTHER files than the ones you are > currently installing, such as files to be replaced. > > If you are installing an update that is not manual, i.e. there is an > automated installer, then this usually replaces the original core files > rather than install hotfixes, so you don;t have to worry about it. > > When you install a major update such as 8.0.1 or cumulative hotfix this will > (or should) include all the previous hotfixes and updates, so you can then > delete them from the updates folder to avoid the hotfix overriding the > update. You should of course check that they are included in your update > first though, this information is in the release notes. > > Russ > > On Fri, Jun 17, 2011 at 6:43 PM, Rex wrote: > >> >> Hi Brook, >> >> The CF 8.0.0 hotfix instructions says to only delete the following: >> >> * hf800-1.jar >> * hf800-2.jar >> * hf800-70523.jar >> * hf800-71471.jar >> * hf800-73122.jar >> * hf800-1875.jar >> * hf800-77218.jar >> * hf800-1878.jar >> >> So leave everything else. >> >> Also, looks like you applied the 8.0.0 fix (because you applied >> hf800-3.jar) but you are following the instructions for 8.0.1 >> (because you said "You do not need to keep the ColdFusion 8.0.1 >> cumulative hot fix JAR file after installing it with the ColdFusion >> Administrator"), so make sure you are using and reading the correct CF >> version. >> >> Make sure you are applying the correct JARs, and deleting the JARs that >> it tells you to delete. >> >> - Rex >> >> >> >> > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345414 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Applying hotFixes and updates
I think there is some confusion here. If you install a hotfix which is simply a JAR file by uploading it via the cfadmin, it gets uploaded to the UPDATES folder. This is where it now gets loaded from. If you delete it from the updates folder, CF will no longer load it. Jars loaded from the updates folder get loaded last, so they overwrite the previous classes that had the bugs, thus is is a temporary hotfix. When the instructions tell you that you can delete the files, they means the ones you downloaded, not the ones you just installed, which would be silly. Unless they are specifically referring to OTHER files than the ones you are currently installing, such as files to be replaced. If you are installing an update that is not manual, i.e. there is an automated installer, then this usually replaces the original core files rather than install hotfixes, so you don;t have to worry about it. When you install a major update such as 8.0.1 or cumulative hotfix this will (or should) include all the previous hotfixes and updates, so you can then delete them from the updates folder to avoid the hotfix overriding the update. You should of course check that they are included in your update first though, this information is in the release notes. Russ On Fri, Jun 17, 2011 at 6:43 PM, Rex wrote: > > Hi Brook, > > The CF 8.0.0 hotfix instructions says to only delete the following: > >* hf800-1.jar >* hf800-2.jar >* hf800-70523.jar >* hf800-71471.jar >* hf800-73122.jar >* hf800-1875.jar >* hf800-77218.jar >* hf800-1878.jar > > So leave everything else. > > Also, looks like you applied the 8.0.0 fix (because you applied > hf800-3.jar) but you are following the instructions for 8.0.1 > (because you said "You do not need to keep the ColdFusion 8.0.1 > cumulative hot fix JAR file after installing it with the ColdFusion > Administrator"), so make sure you are using and reading the correct CF > version. > > Make sure you are applying the correct JARs, and deleting the JARs that > it tells you to delete. > > - Rex > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345413 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Encrypt/Decrypt
No, not really as long as you're using a cipher that hasn't been broken. Encryption uses a special class of functions that are easy to perform one direction but prohibitively hard to perform the other direction. For instance, if you take two very large prime numbers and multiply them together to produce a really big number, that's pretty easy to do. However, it is really really really difficult to take a really big number and figure out which two large prime numbers were used to compose the new number. You can look up the details of a particular algorithm if you want to get a better understanding of how it is implemented. There are differences between public/private key systems, straight up encryption/decryption with a single key and then one way hashing, but essentially, if the private key is kept safe, knowing the input text and the output of the cipher will not generally tell anyone enough to be able to guess the key. Cheers, Judah On Fri, Jun 17, 2011 at 10:00 AM, Steve Reich wrote: > > If I have Encrypt(x,y) which equals z OR Decrypt(x,y) which equals z, can z > be determined (encrypted or decrypted) without having both x and y? > > Example: > > "dj0yJmk9TTJOUXFnakphWjVlJmQ9WVdrOVVtMU9jak5rTjJNbWNHbzlPREV4TVRrNE5EWXkmcz1jb25zdW1lcnNlY3JldCZ4PWQx"> > > > if you output variables.value, you get: > *<'Y^MZ!]F;*=V@ > > So... if someone gets my MYPASSWORD and *<'Y^MZ!]F;*=V@, can they figure out > the value of variables.secretKey? > > Thanks, > Steve ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345412 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Encrypt/Decrypt
perhaps I really should say "virtually impossible" just to be syntactically correct. On Fri, Jun 17, 2011 at 8:49 PM, Russ Michaels wrote: > Technically yes as this is how hackers reverse engineer encryption keys to > create keygens etc. > However it does depend on what encryption type you use, some have not yet > been hacked, so the chances are of course very very minute, and you would > need to be encrypting something that some desperately wanted in order for > them to put the effort in. > > This might help > > http://en.wikipedia.org/wiki/Blowfish_(cipher) > > Russ > > > On Fri, Jun 17, 2011 at 6:00 PM, Steve Reich wrote: > >> >> If I have Encrypt(x,y) which equals z OR Decrypt(x,y) which equals z, can >> z >> be determined (encrypted or decrypted) without having both x and y? >> >> Example: >> >> > >> "dj0yJmk9TTJOUXFnakphWjVlJmQ9WVdrOVVtMU9jak5rTjJNbWNHbzlPREV4TVRrNE5EWXkmcz1jb25zdW1lcnNlY3JldCZ4PWQx"> >> >> >> if you output variables.value, you get: >> *<'Y^MZ!]F;*=V@ >> >> So... if someone gets my MYPASSWORD and *<'Y^MZ!]F;*=V@, can they figure >> out >> the value of variables.secretKey? >> >> Thanks, >> Steve >> >> >> ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345411 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Encrypt/Decrypt
Technically yes as this is how hackers reverse engineer encryption keys to create keygens etc. However it does depend on what encryption type you use, some have not yet been hacked, so the chances are of course very very minute, and you would need to be encrypting something that some desperately wanted in order for them to put the effort in. This might help http://en.wikipedia.org/wiki/Blowfish_(cipher) Russ On Fri, Jun 17, 2011 at 6:00 PM, Steve Reich wrote: > > If I have Encrypt(x,y) which equals z OR Decrypt(x,y) which equals z, can z > be determined (encrypted or decrypted) without having both x and y? > > Example: > > > "dj0yJmk9TTJOUXFnakphWjVlJmQ9WVdrOVVtMU9jak5rTjJNbWNHbzlPREV4TVRrNE5EWXkmcz1jb25zdW1lcnNlY3JldCZ4PWQx"> > > > if you output variables.value, you get: > *<'Y^MZ!]F;*=V@ > > So... if someone gets my MYPASSWORD and *<'Y^MZ!]F;*=V@, can they figure > out > the value of variables.secretKey? > > Thanks, > Steve > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345410 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: What happened to my CF Builder install?
I looked in the file associations and saw that Adobe CFML Editor wasn't the default editor type and the other 2 "Untitled Text Editor" and "Text Editor" showed "locked by 'CFML SourceFile' content type" Anyways I selected *.cfc *.cfm and *.cfml and made the default Adobe CFML Editor and that appears to have corrected my issue On Fri, Jun 17, 2011 at 2:41 PM, Wil Genovese wrote: > > Just the one that isn't working. > > As I understand it the licensing program is rather old and archaic and > craps out a lot. It's also the only reason these products don't work on > Linux. > > > 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 Jun 17, 2011, at 2:35 PM, Greg Morphis wrote: > > > > > only CFBuilder? will I have to reinstall FlashBuilder too? Argh, this is > > rather annoying! > > > > On Fri, Jun 17, 2011 at 2:33 PM, Wil Genovese > wrote: > > > >> > >> It looks like the Adobe Licensing app failed. The fastest fix I've > found > >> is to uninstall and reinstall. > >> > >> > >> Wil Genovese > >> Sr. Web Application Developer/ > >> Systems Administrator > >> CF Webtools > >> www.cfwebtools.com > >> > >> wilg...@trunkful.com > >> www.trunkful.com > >> > >> On Jun 17, 2011, at 2:30 PM, Greg Morphis wrote: > >> > >>> > >>> I have been using CF Builder 2 and I saw that my license included a > Flash > >>> Builder 4.5 serial so I downloaded that and installed it. > >>> Now I open CF Builder 2 and none of the keywords are color coded, all > >> text > >>> is black, all the keywords are underlined with e.g "The word > >> 'arrayappend' > >>> is not correctly spelled" when you mouse over. > >>> The Getting Started page loaded fine.. I chose the ColdFusion > perspective > >>> and I had to re-add my CF server. That's all good but what about the > >>> editor.. why is it hosed now and how to I get it back? > >>> > >>> > >>> > >> > >> > > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345409 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: What happened to my CF Builder install?
Just the one that isn't working. As I understand it the licensing program is rather old and archaic and craps out a lot. It's also the only reason these products don't work on Linux. 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 Jun 17, 2011, at 2:35 PM, Greg Morphis wrote: > > only CFBuilder? will I have to reinstall FlashBuilder too? Argh, this is > rather annoying! > > On Fri, Jun 17, 2011 at 2:33 PM, Wil Genovese wrote: > >> >> It looks like the Adobe Licensing app failed. The fastest fix I've found >> is to uninstall and reinstall. >> >> >> Wil Genovese >> Sr. Web Application Developer/ >> Systems Administrator >> CF Webtools >> www.cfwebtools.com >> >> wilg...@trunkful.com >> www.trunkful.com >> >> On Jun 17, 2011, at 2:30 PM, Greg Morphis wrote: >> >>> >>> I have been using CF Builder 2 and I saw that my license included a Flash >>> Builder 4.5 serial so I downloaded that and installed it. >>> Now I open CF Builder 2 and none of the keywords are color coded, all >> text >>> is black, all the keywords are underlined with e.g "The word >> 'arrayappend' >>> is not correctly spelled" when you mouse over. >>> The Getting Started page loaded fine.. I chose the ColdFusion perspective >>> and I had to re-add my CF server. That's all good but what about the >>> editor.. why is it hosed now and how to I get it back? >>> >>> >>> >> >> > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345408 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: What happened to my CF Builder install?
only CFBuilder? will I have to reinstall FlashBuilder too? Argh, this is rather annoying! On Fri, Jun 17, 2011 at 2:33 PM, Wil Genovese wrote: > > It looks like the Adobe Licensing app failed. The fastest fix I've found > is to uninstall and reinstall. > > > Wil Genovese > Sr. Web Application Developer/ > Systems Administrator > CF Webtools > www.cfwebtools.com > > wilg...@trunkful.com > www.trunkful.com > > On Jun 17, 2011, at 2:30 PM, Greg Morphis wrote: > > > > > I have been using CF Builder 2 and I saw that my license included a Flash > > Builder 4.5 serial so I downloaded that and installed it. > > Now I open CF Builder 2 and none of the keywords are color coded, all > text > > is black, all the keywords are underlined with e.g "The word > 'arrayappend' > > is not correctly spelled" when you mouse over. > > The Getting Started page loaded fine.. I chose the ColdFusion perspective > > and I had to re-add my CF server. That's all good but what about the > > editor.. why is it hosed now and how to I get it back? > > > > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345407 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: What happened to my CF Builder install?
It looks like the Adobe Licensing app failed. The fastest fix I've found is to uninstall and reinstall. Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com wilg...@trunkful.com www.trunkful.com On Jun 17, 2011, at 2:30 PM, Greg Morphis wrote: > > I have been using CF Builder 2 and I saw that my license included a Flash > Builder 4.5 serial so I downloaded that and installed it. > Now I open CF Builder 2 and none of the keywords are color coded, all text > is black, all the keywords are underlined with e.g "The word 'arrayappend' > is not correctly spelled" when you mouse over. > The Getting Started page loaded fine.. I chose the ColdFusion perspective > and I had to re-add my CF server. That's all good but what about the > editor.. why is it hosed now and how to I get it back? > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345406 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
What happened to my CF Builder install?
I have been using CF Builder 2 and I saw that my license included a Flash Builder 4.5 serial so I downloaded that and installed it. Now I open CF Builder 2 and none of the keywords are color coded, all text is black, all the keywords are underlined with e.g "The word 'arrayappend' is not correctly spelled" when you mouse over. The Getting Started page loaded fine.. I chose the ColdFusion perspective and I had to re-add my CF server. That's all good but what about the editor.. why is it hosed now and how to I get it back? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345405 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Retrieve data in groups
SELECT TOP 10 ... or or On Fri, Jun 17, 2011 at 12:57 PM, Torrent Girl wrote: > > >Hi All. > > > >Is there a way for me to retrieve records from a db in groups? > > > >I have a query that selects over 200,000 records and it times out on the > cf output. > > > >Thanks > > I don't think I asked this right. What I need to do is encrypt user > passwords I need to do it in CF. Problem is there are over 200,00 records > which is too much for the cf loop and output. > > Any suggestions? > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345404 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Retrieve data in groups
>Hi All. > >Is there a way for me to retrieve records from a db in groups? > >I have a query that selects over 200,000 records and it times out on the cf >output. > >Thanks I don't think I asked this right. What I need to do is encrypt user passwords I need to do it in CF. Problem is there are over 200,00 records which is too much for the cf loop and output. Any suggestions? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345403 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Retrieve data in groups
Hi All. Is there a way for me to retrieve records from a db in groups? I have a query that selects over 200,000 records and it times out on the cf output. Thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345402 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Applying hotFixes and updates
Hi Brook, The CF 8.0.0 hotfix instructions says to only delete the following: * hf800-1.jar * hf800-2.jar * hf800-70523.jar * hf800-71471.jar * hf800-73122.jar * hf800-1875.jar * hf800-77218.jar * hf800-1878.jar So leave everything else. Also, looks like you applied the 8.0.0 fix (because you applied hf800-3.jar) but you are following the instructions for 8.0.1 (because you said "You do not need to keep the ColdFusion 8.0.1 cumulative hot fix JAR file after installing it with the ColdFusion Administrator"), so make sure you are using and reading the correct CF version. Make sure you are applying the correct JARs, and deleting the JARs that it tells you to delete. - Rex ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345401 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Encrypt/Decrypt
If I have Encrypt(x,y) which equals z OR Decrypt(x,y) which equals z, can z be determined (encrypted or decrypted) without having both x and y? Example: if you output variables.value, you get: *<'Y^MZ!]F;*=V@ So... if someone gets my MYPASSWORD and *<'Y^MZ!]F;*=V@, can they figure out the value of variables.secretKey? Thanks, Steve ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345400 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: onSessionEnd not working as expected
Jerry, On Fri, Jun 17, 2011 at 11:55 AM, Gerald Weir wrote: > > First, my apologies to all if this is a duplicate post. I seem to be having > trouble posting. Anyway, > > Hello All, > > Thanks for your input. Ray, you are correct in that I needed to pass in the > session scope variables correctly. > > In my original post it is clear that a) I was not passing in the session > scope vars (the array) correctly; and b) I had not indicated the path > correctly. Now I've fixed those items and am mostly successful as in the > following: > > > > > > method="writeJobStepArray" returnvariable="isSuccess"> > value="#Arguments.SessionScope.jobStepArray#"> > > > > > > > > I had tried the / paths because it had appeared to me that the onSessionEnd > was not finding the component but what I see now is that there is an error > in the CFC regarding an application scope variable that I had not seen so > naturally it was erroring out - not that it couldn't find the cfc. > > I definitely learned a lot about using CFLOG for debugging in this one. > But, there is one other small issue and that is I tried to pass in the > application scope var as follows and it didn't seem to work (so I've > hard-coded for the time being): > > In application.cfc I have defined a datasource structure: > application.database = structNew() > > The database is: application.database.dsn > > I tried to pass this to the CFC in onSessionEnd like this: > > value="#Arguments.ApplicationScope.application.database.dsn#"> > > ...but it didn't work. What is the correct syntax for this? > > You'd only need: -Dan -- Dan G. Switzer, II dswit...@pengoworks.com http://blog.pengoworks.com/ âââââââ ââ âââââ âââââââ â âââ â âââââ ââ â âââ â â âââ â ââ â âââ â âââ â âââââââ âââ â â â âââââââ ââââââââ âââââ âââââ âââ ââââââââââââââ âââââ ââ ââââââââââââââ âââââ ââââ ââ ââ â ââââââââ âââââââ ââ ââ â ââ âââ ââââââââ â âââââââ âââ âââââ â âââââ â âââ â âââ ââ ââââââ ââ â âââ â â ââ ââ âââ âââ â âââââââ ââ ââ ââ â ââ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345399 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: onSessionEnd not working as expected
First, my apologies to all if this is a duplicate post. I seem to be having trouble posting. Anyway, Hello All, Thanks for your input. Ray, you are correct in that I needed to pass in the session scope variables correctly. In my original post it is clear that a) I was not passing in the session scope vars (the array) correctly; and b) I had not indicated the path correctly. Now I've fixed those items and am mostly successful as in the following: I had tried the / paths because it had appeared to me that the onSessionEnd was not finding the component but what I see now is that there is an error in the CFC regarding an application scope variable that I had not seen so naturally it was erroring out - not that it couldn't find the cfc. I definitely learned a lot about using CFLOG for debugging in this one. But, there is one other small issue and that is I tried to pass in the application scope var as follows and it didn't seem to work (so I've hard-coded for the time being): In application.cfc I have defined a datasource structure: application.database = structNew() The database is: application.database.dsn I tried to pass this to the CFC in onSessionEnd like this: ...but it didn't work. What is the correct syntax for this? Many thanks to all Jerry ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345398 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Applying hotFixes and updates
No. That means the file you downloaded to your desktop is no longer required. Matthew Williams Geodesic GraFX www.geodesicgrafx.com/blog ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345397 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Applying hotFixes and updates
Ok, so I guess when Adobe says " You do not need to keep the ColdFusion 8.0.1 cumulative hot fix JAR file after installing it with the ColdFusion Administrator. The file has been copied to the correct location.". It only refers to updates installed via the administrator. I think that's where I got confused.. thanks Russ! Brook -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: June-17-11 7:35 AM To: cf-talk Subject: Re: Applying hotFixes and updates no, do not ever delete cumulative hotfix files. You can only delete the files I outlined below. On Fri, Jun 17, 2011 at 3:13 PM, Brook Davies wrote: > > Yeah, it's a wee bit confusing. So you can delete the Cumulative hot > fix Jars but not the stand alone hot fixes? Is that correct? > > -Original Message- > From: Russ Michaels [mailto:r...@michaels.me.uk] > Sent: June-17-11 7:00 AM > To: cf-talk > Subject: Re: Applying hotFixes and updates > > > if you remove the other update files then they will no longer be > loaded and will not be applied. > You should not remove hotfixes from the updates folder unless you have > installed an cumulative UPDATE that has the hotfixes included. > Then you should remove the hotfixes to avoid them being loaded twice. > > Adobe's updating process for CF is pretty pants i'm afraid. > > Russ > > On Fri, Jun 17, 2011 at 2:52 PM, Brook Davies > wrote: > > > > > Hello, > > > > > > > > Yesterday I installed the APSB11-14 hotfix by dropping the file > > hf800-3.jar into the cfroot/lib/updates directory. I removed the > > other files that were in there since I was under the impression that > > they were "applied" an no longer needed to be there. I am not > > getting a bunch of these > > errors: > > > > > > > > String index out of range: 0 null The error occurred on line -1. > > > > > > > > Did I need to leave the previous files in the update directory? > > > > > > > > Brook > > > > > > > > > > > > > > > > > > > > > > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345396 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Applying hotFixes and updates
no, do not ever delete cumulative hotfix files. You can only delete the files I outlined below. On Fri, Jun 17, 2011 at 3:13 PM, Brook Davies wrote: > > Yeah, it's a wee bit confusing. So you can delete the Cumulative hot fix > Jars but not the stand alone hot fixes? Is that correct? > > -Original Message- > From: Russ Michaels [mailto:r...@michaels.me.uk] > Sent: June-17-11 7:00 AM > To: cf-talk > Subject: Re: Applying hotFixes and updates > > > if you remove the other update files then they will no longer be loaded and > will not be applied. > You should not remove hotfixes from the updates folder unless you have > installed an cumulative UPDATE that has the hotfixes included. > Then you should remove the hotfixes to avoid them being loaded twice. > > Adobe's updating process for CF is pretty pants i'm afraid. > > Russ > > On Fri, Jun 17, 2011 at 2:52 PM, Brook Davies > wrote: > > > > > Hello, > > > > > > > > Yesterday I installed the APSB11-14 hotfix by dropping the file > > hf800-3.jar into the cfroot/lib/updates directory. I removed the > > other files that were in there since I was under the impression that > > they were "applied" an no longer needed to be there. I am not getting > > a bunch of these > > errors: > > > > > > > > String index out of range: 0 null The error occurred on line -1. > > > > > > > > Did I need to leave the previous files in the update directory? > > > > > > > > Brook > > > > > > > > > > > > > > > > > > > > > > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345395 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Applying hotFixes and updates
Yeah, it's a wee bit confusing. So you can delete the Cumulative hot fix Jars but not the stand alone hot fixes? Is that correct? -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: June-17-11 7:00 AM To: cf-talk Subject: Re: Applying hotFixes and updates if you remove the other update files then they will no longer be loaded and will not be applied. You should not remove hotfixes from the updates folder unless you have installed an cumulative UPDATE that has the hotfixes included. Then you should remove the hotfixes to avoid them being loaded twice. Adobe's updating process for CF is pretty pants i'm afraid. Russ On Fri, Jun 17, 2011 at 2:52 PM, Brook Davies wrote: > > Hello, > > > > Yesterday I installed the APSB11-14 hotfix by dropping the file > hf800-3.jar into the cfroot/lib/updates directory. I removed the > other files that were in there since I was under the impression that > they were "applied" an no longer needed to be there. I am not getting > a bunch of these > errors: > > > > String index out of range: 0 null The error occurred on line -1. > > > > Did I need to leave the previous files in the update directory? > > > > Brook > > > > > > > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345394 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Applying hotFixes and updates
if you remove the other update files then they will no longer be loaded and will not be applied. You should not remove hotfixes from the updates folder unless you have installed an cumulative UPDATE that has the hotfixes included. Then you should remove the hotfixes to avoid them being loaded twice. Adobe's updating process for CF is pretty pants i'm afraid. Russ On Fri, Jun 17, 2011 at 2:52 PM, Brook Davies wrote: > > Hello, > > > > Yesterday I installed the APSB11-14 hotfix by dropping the file > hf800-3.jar into the cfroot/lib/updates directory. I removed the other > files that were in there since I was under the impression that they were > "applied" an no longer needed to be there. I am not getting a bunch of > these > errors: > > > > String index out of range: 0 null The error occurred on line -1. > > > > Did I need to leave the previous files in the update directory? > > > > Brook > > > > > > > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345393 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Applying hotFixes and updates
Hello, Yesterday I installed the APSB11-14 hotfix by dropping the file hf800-3.jar into the cfroot/lib/updates directory. I removed the other files that were in there since I was under the impression that they were "applied" an no longer needed to be there. I am not getting a bunch of these errors: String index out of range: 0 null The error occurred on line -1. Did I need to leave the previous files in the update directory? Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345392 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfhttp and SSL ... I/O Exception: peer not authenticated
Hey Bobby, thanks for the reply. It turns out this is a CF9 bug. Ray Camden outlines it well here, with a workaround that is working for me: http://www.coldfusionjedi.com/index.cfm/2011/1/12/Diagnosing-a-CFHTTP-issue--peer-not-authenticated Here is the bug report Jason Dean filed: http://cfbugs.adobe.com/cfbugreport/flexbugui/cfbugtracker/main.html#bugId=85815 Thank you again for the feedback, I just wanted to post again to direct future visitors to where I found the workaround. Best, Brian ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345391 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cfhttp and SSL ... I/O Exception: peer not authenticated
"I'm pretty sure it's related to the fact that I'm trying to make a secure request (SSL), and maybe since I'm on my local development machine and thus don't have a local SSL setup on my end as well it's causing problems (maybe?)." Yes, most likely. If you have a self signed cert, you can add it to the java keystore on the CF server to have CFHTTP make successful SSL calls to a page using that cert. Your other options are to use a real, valid cert and some hosts file magic to make the request remain local but use the real domain (that the cert was issued to) Or... just stop using SSL for testing. .:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Brian FitzGerald [mailto:bmfitzgera...@yahoo.com] Sent: Thursday, June 16, 2011 2:33 PM To: cf-talk Subject: cfhttp and SSL ... I/O Exception: peer not authenticated Hey all, I'm trying to make a cfhttp call to a secure url (the API for http://spreedly.com) and this is what I keep getting back: ErrorDetail I/O Exception: peer not authenticated Filecontent Connection Failure Mimetype Unable to determine MIME type of file. Statuscode Connection Failure. Status code unavailable. I'm pretty sure it's related to the fact that I'm trying to make a secure request (SSL), and maybe since I'm on my local development machine and thus don't have a local SSL setup on my end as well it's causing problems (maybe?). I've been Googling around on it and this seemed like the most relevant article: http://australiansearchengine.wordpress.com/2011/01/19/cfhttp-io-exception-p eer-not-authenticated-error/#comment-1860 I did what he suggested by downloading and placing their cert in my CF9 directory structure, but no luck. Seen anything like this? Thanks! Brian http://www.spanishwizards.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345390 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfhttp and SSL ... I/O Exception: peer not authenticated
> You'll need to download the certificate and install it in your JVM's > keystore. Google "java keystore keytool coldfusion" for instructions. Hi Dave, Thank you for the reply. Only thing is that I've already downloaded the certificate through Google Chrome, and imported it via the keytool as described by Steven Erat[1]. I've even downloaded a KeyStore Explorer GUI[2] and used it to confirm that the cert is indeed shown in the keystore, which is appears to be as you can see in this screenshot (spreedlyCert is the one I created): http://fitzgeraldmedia.net/images/keystoreShot.jpg I have also restarted CF9 via the windows services panel. So for me, the thing that came to mind was maybe CF was using a different JRE, but I checked in the CF9 admin settings, and I see that Java Home is indeed listed as: C:\ColdFusion9\runtime\jre which is where imported the cert. C:\ColdFusion9\runtime\jre\lib\security. I'm still getting the same error. Is there anything else you can think of I may be overlooking? Thanks, Brian [1] http://www.talkingtree.com/blog/index.cfm?mode=entry&entry=25AA75A4-45A6-2844-7CA3EECD842DB576 [2] http://www.lazgosoftware.com/kse/index.html [3] ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345389 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Proxying Apache to Tomcat For CF9
Thanks for all your help Sean. I've got ACF and Railo running now together on jrun using the same webroot so that will do. And yes you are very right about ACF :) On Fri, Jun 17, 2011 at 7:24 AM, Sean Corfield wrote: > > On Thu, Jun 16, 2011 at 9:19 PM, Michael Wright > wrote: > > Ahh ok I see now :) Basically its failing because the webroot I'm trying > to > > use doesnt have the WEB-INF right? > > Yup. > > > Would my idea of all 3 engines sharing a webroot on JRun work then? > > No. Railo and OpenBD are strict Java web applications and expect the > webroot to contain their WEB-INF/ folder. > > ACF has really spoiled CFers and made them oblivious to how (Java) web > applications work :) > -- > Sean A Corfield -- (904) 302-SEAN > An Architect's View -- http://corfield.org/ > World Singles, LLC. -- http://worldsingles.com/ > Railo Technologies, Inc. -- http://www.getrailo.com/ > > "Perfection is the enemy of the good." > -- Gustave Flaubert, French realist novelist (1821-1880) > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345388 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm