Re: cfx_pwtextcrypt CF9

2011-02-13 Thread Jeffrey Battershall
Check the CF9 docs. There's quite a bit of encryption/decryption support built in to CF8/9. You might have transition issues to work through, but you shouldn't need a CFX for that purpose at this point. On Thu, Feb 10, 2011 at 3:53 PM, Brook Davies cft...@logiforms.com wrote: We've been

Re: Fusebox seemingly clearing contents of session variables on relocation

2011-02-13 Thread Dave Watts
Presumably you are doing something like so... cfset session.myvariable = form / cflocation url=foo.cfm / I have not tested it, but I am guessing that you are loosing the session variables because you are creating a _reference_ to the form scope.  When you redirect, the form scope is now

Re: Fusebox seemingly clearing contents of session variables on relocation

2011-02-13 Thread Matt Quackenbush
Dave, as you well know I usually agree with you. However, in this case, I do not agree with you at all. Why? Because you are 100% wrong in your statement. What I showed is **exactly** how references work. 1) If you create a _reference_ to something as my code example did... cfset

Re: Fusebox seemingly clearing contents of session variables on relocation

2011-02-13 Thread Matt Quackenbush
On Sun, Feb 13, 2011 at 11:36 AM, Matt Quackenbush wrote: The only way to pass a structure in CF by reference is by using duplicate(). Oops. That is suppose to say The only way to pass a structure in CF by value is by using duplicate().

Reserved function names?

2011-02-13 Thread Pete Ruckelshaus
Hi, I am creating a site with a codebase that is shared across several domains. Each site has a cfc that contains functions that are called in each section of my base application.cfc. Will I run into any issues if I name the functions in my site-specific cfc onApplicationStart(),

Re: Reserved function names?

2011-02-13 Thread Matt Quackenbush
Have you tried it? :-) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive:

SQL selecting distinct items by date?

2011-02-13 Thread wabba
More on SQL-topic than CF (MS SQL), but hopefully is an easy one. I have items with a datetime field that stores when the items are added to the DB. There is a pivot table that links items to categories. I'm trying to pull out the top 5 unique categories with the newest-added items. This is what

Re: SQL selecting distinct items by date?

2011-02-13 Thread John M Bliss
SELECT TOP 5 DISTINCT pivot.CategoryID, Category.Name, YEAR(Item.DateAdded) AS theyear, MONTH(Item.DateAdded) AS themonth, DAY(Item.DateAdded) AS theday On Sun, Feb 13, 2011 at 12:51 PM, wabba must...@wabba.net wrote: More on SQL-topic than CF (MS SQL), but hopefully is an easy one. I have

Re: Reserved function names?

2011-02-13 Thread Pete Ruckelshaus
I have, and it works, I just wanted to make sure I don't create an alternate dimension or release a kraken or something. On Sun, Feb 13, 2011 at 1:49 PM, Matt Quackenbush quackfu...@gmail.comwrote: Have you tried it? :-)

RE: SQL selecting distinct items by date?

2011-02-13 Thread wabba
Here's what I ended up with SELECT distinct TOP 5 pc.nCategoryID, c.sCategory, YEAR(p.dPartDate) AS theyear, MONTH(p.dPartDate) AS themonth, DAY(p.dPartDate) AS theday FROM Category c INNER JOIN PartCat pc ON pc.nCategoryID=c.nCategoryID inner join part p on pc.npartid=p.npartid order by theyear

Re: Reserved function names?

2011-02-13 Thread Matt Quackenbush
Heh. OK. Well, the answer is, as you have found, yes, it works just fine. This is what most (all?) of your MVC frameworks do in order to extend the Application.cfc functionality. Assuming that the code you place in such named methods is appropriately placed, there is nothing at all wrong with

Re: CF8 cftextarea richtext is stealing form focus, and being referred to by the form

2011-02-13 Thread Michael Benoit
In addition, FCKConfig.StartupFocus= false; in fckconfig.js Hi, sorry for necroposting, but has anyone seen a solution to this problem in CF8? I'm experiencing the exact same issue, and it's a bit aggravating. Thanks!

Re: Fusebox seemingly clearing contents of session variables on relocation

2011-02-13 Thread Sean Corfield
On Sun, Feb 13, 2011 at 9:36 AM, Matt Quackenbush quackfu...@gmail.com wrote: Dave, as you well know I usually agree with you.  However, in this case, I do not agree with you at all.  Why?  Because you are 100% wrong in your statement.  What I showed is **exactly** how references work. Well,

Re: Fusebox seemingly clearing contents of session variables on relocation

2011-02-13 Thread Sean Corfield
On Sun, Feb 13, 2011 at 7:59 PM, Sean Corfield seancorfi...@gmail.com wrote: I tried it on Railo and discovered that the form scope is somehow reused across multiple requests - so on Railo, your logic would be correct. That's interesting and I'll have to take that up with engineering to find

Re: Fusebox seemingly clearing contents of session variables on relocation

2011-02-13 Thread Matt Quackenbush
I have two different CF9 installations that behave the way I described. It actually caught me out on a quickie application I did for someone awhile back, because I did not expect that behavior. But that's exactly what it does on two different installations. shrug

Re: Fusebox seemingly clearing contents of session variables on relocation

2011-02-13 Thread Sean Corfield
On Sun, Feb 13, 2011 at 8:58 PM, Matt Quackenbush quackfu...@gmail.com wrote: I have two different CF9 installations that behave the way I described. Odd. I couldn't repro on CF9.0.1 locally. Do you have a small test case that shows form scope behaving like that for you? I'd love to try it on

Re: Latest Hot Fix Issues

2011-02-13 Thread Shilpi Khariwal
Hi, Can you please try this on another machine/Setup? Shilpi ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: