[cfaussie] Re: Finding the scope of variable was found in

Does this help? http://www.coldfusionjedi.com/index.cfm/2008/10/6/Ask-a-Jedi-Finding-where-a-variable-is-defined On Tue, Nov 11, 2008 at 5:40 PM, Brontojoris <[EMAIL PROTECTED]> wrote: > > Hi, > > I've inherited a CF app that has A LOT of unscoped variables, which > are sometimes coming from t

[cfaussie] Re: Orientation of x-axis labels in a bar graph

Just as an FYI, 9 out of 10 cfchart questions I get can be answered by going to the chart editor. It is rather powerful. On Tue, Nov 11, 2008 at 9:51 PM, Seona Bellamy <[EMAIL PROTECTED]> wrote: > > Thanks Cassie and Steve. I'd never even known that was there! Time to > start playing I guess. :)

[cfaussie] Clear query cache

Hi, I've got a query in a CFC with a cache setting: cachedWithin="#CreateTimeSpan(7,0,0,0)#". I've updated the query but how can I clear or reset the cache so I can see the updated query result now? Thanks, George --~--~-~--~~~---~--~~ You received this message be

[cfaussie] Re: Clear query cache

You have two methods: 1) This clears ALL cached queries on the entire box. 2) You can rerun the query with a timespan of 0,0,0,0. Note - the SQL must be the exact same, and that includes white space! Personally I cache my queries in the Application or Session scope. Makes it a lot easier to

[cfaussie] Re: Clear query cache

Thank you Raymond. I've tried the first one - it didn't work. I'll try the second one. Would you be able to give me an example how to put cache in the Application scope? Thanks, George 2008/11/13 Raymond Camden <[EMAIL PROTECTED]> > > You have two methods: > > 1) > > This clears ALL cached que

[cfaussie] Re: Referencing a query inside another query in ColdFusionMX

ok i tried the ValueList syntax as per Steve Onnis, but i get an error message - "The ValueList() function has an invalid parameter: SelectedOrders.SalesHDRID. Parameter 1 of function ValueList which is now (SelectedOrders.SalesHDRID) must be pointing to a valid query name." 'SelectedOrders' is

[cfaussie] Re: Clear query cache

There ya go. :) That assumes Y is a query. Here is a more fuller, but still a bit pseudo-code, example: select id, name from states Obviously this could be wrapped up into a CFC. On Wed, Nov 12, 2008 at 4:43 PM, George Lu <[EMAIL PROTECTED]> wrote: > Thank you Raymond. I've t

[cfaussie] Referencing a query inside another query in ColdFusionMX

Post your code please probably just a typo somewhere.. >>> Khush <[EMAIL PROTECTED]> 13/11/2008 9:44 am >>> ok i tried the ValueList syntax as per Steve Onnis, but i get an error message - "The ValueList() function has an invalid parameter: SelectedOrders.SalesHDRID. Parameter 1 of function

[cfaussie] Re: Clear query cache

Thanks Raymond for the example. I'll incorporate it into my CFC. Well, I've tried the second method. It didn't work either. I'm using Flash Forms (I know, it's bit old :)) in the front end. Maybe I should use this in onRequestStart? 2008/11/13 Raymond

[cfaussie] Re: Referencing a query inside another query in ColdFusionMX

The argument for ValueList is.. ValueList(queryName.columnName) The error suggests that the query name you are passing in ( SelectedOrders ) is not a query. This value is the value you use for the "name" attribute of the cfquery tag. So... SELECT myColumn FROMMy

[cfaussie] Re: Clear query cache

It works now! I guess because I've put the cfc into the application scope and the query into the request scope. 2008/11/13 George Lu <[EMAIL PROTECTED]> > Thanks Raymond for the example. I'll incorporate it into my CFC. Well, I've > tried the second method. It didn't work either. I'm using Flash

[cfaussie] Re: Finding the scope of variable was found in

Yes, that is exactly what I was after. Thank you very much! On Nov 13, 1:56 am, "Raymond Camden" <[EMAIL PROTECTED]> wrote: > Does this help? > > http://www.coldfusionjedi.com/index.cfm/2008/10/6/Ask-a-Jedi-Finding-... > > > > On Tue, Nov 11, 2008 at 5:40 PM, Brontojoris <[EMAIL PROTECTED]> wrot

[cfaussie] Re: Clear query cache

Any reason why you wouldn't just put that scope into the query name? As in: Brett B) Raymond Camden wrote: > > > There ya go. :) That assumes Y is a query. Here is a more fuller, but > still a bit pseudo-code, example: > > > > > select id, name > from states > > > > > > O

[cfaussie] Re: Clear query cache

I have the query "getStates" in the cfc: helpdeskGateway and create object for the cfc in application.cfc: So when I access the query I use this: application.helpdeskGateway.getStates. As sometimes CF complains it couldn't find helpdeskGateway in the application scope so I've also put helpdeskGa

[cfaussie] CFUG Meeting : November 20th

Steve Onnis talks about virtualisation Date and Time:November 20, 2008 from 7:00pm - 8:30pm Address: NGA.net Level 2 17 Raglan St South Melbourne http://maps.google.com/maps?q=NGA.net+Level+2+17+Raglan+St+South+Melbourne

[cfaussie] Re: Referencing a query inside another query in ColdFusionMX

Here's my code syntax- I have tried to use spaces to make it more readable... Basically there is an IF condition and the complicated sub query, then there is another IF condition and i am using the ValueList function in this query here.. SELECT SALESHEADER.SalesHDRID, ACCOUNTS_1.ParentAccoun

[cfaussie] Re: Referencing a query inside another query in ColdFusionMX

Your first CFIF says... and your second one says Obviously the first query isnt running because "Confirmed" does not equal "", it equals "CONFIRM" so when the second query gets run the query named "SelectedOrders" does not exist. Steve --~--~-~--~~~---~--

[cfaussie] Attaching files to emails

Is it possible to attach a file to an email but not use a file path? I want to do something similar to downloading a file where you push the content out. I have files i need to attach but they get dynamically created so i dont want to have all these files hanging around. What i was hoping to be

[cfaussie] Re: Attaching files to emails

if you're on 8.01, cfmailparam's file/content attributes perhaps? cheers. terry 2008/11/13 Steve Onnis <[EMAIL PROTECTED]>: > Is it possible to attach a file to an email but not use a file path? I want > to do something similar to downloading a file where you push the content > out. I have fil

[cfaussie] Re: Attaching files to emails

I don't get it, You want to attach a file, but not have it attached? The answer is no, you can attach or insert a link. Regards Dale Fraser http://learncf.com http://flexcf.com From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTE

[cfaussie] Re: Attaching files to emails

I need to give it a filename though -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Terry Sasaki Sent: Thursday, 13 November 2008 1:35 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Attaching files to emails if you're on 8.01, cfmailp

[cfaussie] Re: Attaching files to emails

iirc, with file/content attirubtes, file is for actually file name, and content is for generated file content. 2008/11/13 Steve Onnis <[EMAIL PROTECTED]>: > > I need to give it a filename though > > -Original Message- > From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf >

[cfaussie] Re: Attaching files to emails

I want to attach it, but i want to do it by passing in the data of the file, not the path to the file what would be good would be a "deleteattachmentfiles" attribute or something to instruct the cf server to clean up the files used as the attachments after the email has been processed _

[cfaussie] Re: Attaching files to emails

Steve, probably my english is not good enough (grin). I mean: cheers. T 2008/11/13 Steve Onnis <[EMAIL PROTECTED]>: > I want to attach it, but i want to do it by passing in the data of the file, > not the path to the file > > what would be good would be a "deleteattachmentfiles" attribute or

[cfaussie] Re: Attaching files to emails

Oh, Makes sense, normally just clean up later, be good if you could capture an email delivered event. Regards Dale Fraser http://learncf.com http://flexcf.com From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Steve

[cfaussie] Re: Attaching files to emails

ok so that works but the files i am receiving in my email dont open. Do i need to uncode the variable or something? -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Terry Sasaki Sent: Thursday, 13 November 2008 2:04 PM To: cfaussie@googlegroups.c

[cfaussie] Cleaning up attachment files : Attaching files to emails

Never mind Worked it out. Ended up using ImageNew() and CFPDF to make sure the files were being read into the variables properly and attaching correctly. Thanks for your help. Just a side not if anyone is listening from the powers that be, i did notice using this method creates a tmp file and t

[cfaussie] Re: Cleaning up attachment files : Attaching files to emails

> > > This tells the CFMAIL process to remove the file after the email has been > processed. well, there's something new to learn every day. Good catch Steve. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfauss

[cfaussie] Re: Cleaning up attachment files : Attaching files to emails

IIRC, this was added in CF8 maybe even 801 On Thu, Nov 13, 2008 at 12:58 PM, Barry Beattie <[EMAIL PROTECTED]>wrote: > > > > > > > This tells the CFMAIL process to remove the file after the email has been > > processed. > > well, there's something new to learn every day. Good catch Steve. > > >

[cfaussie] Re: Cleaning up attachment files : Attaching files to emails

year it's added in 8.0.1 and sort of documented ;-) i've just found this from my delicious bookmarks. http://www.adobe.com/support/documentation/en/coldfusion/801/cf801releasenotes.pdf 2008/11/13 AJ Mercer <[EMAIL PROTECTED]>: > IIRC, this was added in CF8 > maybe even 801 > > On Thu, Nov 13, 20

[cfaussie] Re: Application / Software License agreements

Claude, try Brad Thomas at Innovation Law in Brisbane. Ph. 32119086. They have done some IP stuff for us in the past and we have found them to be very thorough & professional. Given that your software will be used under licence and deployed on remote servers, have you considered how going to dep