[cfaussie] ACT and Region ColdFusion Users Group forums launched today!
A new website and now new Forums. Enjoy! Special thanks to FuseTalk Inc for providing a free license for FuseTalk Basic. See http://www.actcfug.com/ --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Session variable strangeness
Hi, Fromtime to time I get errors with my session variables. They are stored in an MS SQL 2000 database, the cf server is CFMX 6.1 The problem: I check to see if a session variable is defined and not blank, then I use the variable within the query. cfif not isdefined(SESSION.EPISODE) or SESSION.EPISODE eq show an error /cfif cfquery SELECT ... WHERE episode_number = CFQUERYPARAM cfsqltype=cf_sql_numeric value=#SESSION.EPISODE# /cfquery However I get en error: Error Executing Database Query. Invalid data for CFSQLTYPE CF_SQL_NUMERIC. The variable SESSION.EPISODE does no longer seem to contain a value. I am emailed an error of a CFDUMP of the session structure when errors like this occur, and the variable episode contains (in the dump ) [empty string] . Am I doing something wrong? Or are session variables playing up? Scott Thornton, Programmer Application Development Information Services and Telecommunications Hunter-New England Area Health Service p: +61 02 49213589 m: 0413800242 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Session variable strangeness
Try this instead of this. cfif not isdefined(SESSION.EPISODE) or SESSION.EPISODE eq show an error /cfif Do cfif not isDefined(session.episode) or len(session.episode) eq 0 ... show an error /cfif Regards Dale Fraser http://dale.fraser.id.au -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Scott Thornton Sent: Tuesday, 22 August 2006 16:41 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Session variable strangeness Hi, Fromtime to time I get errors with my session variables. They are stored in an MS SQL 2000 database, the cf server is CFMX 6.1 The problem: I check to see if a session variable is defined and not blank, then I use the variable within the query. cfif not isdefined(SESSION.EPISODE) or SESSION.EPISODE eq show an error /cfif cfquery SELECT ... WHERE episode_number = CFQUERYPARAM cfsqltype=cf_sql_numeric value=#SESSION.EPISODE# /cfquery However I get en error: Error Executing Database Query. Invalid data for CFSQLTYPE CF_SQL_NUMERIC. The variable SESSION.EPISODE does no longer seem to contain a value. I am emailed an error of a CFDUMP of the session structure when errors like this occur, and the variable episode contains (in the dump ) [empty string] . Am I doing something wrong? Or are session variables playing up? Scott Thornton, Programmer Application Development Information Services and Telecommunications Hunter-New England Area Health Service p: +61 02 49213589 m: 0413800242 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: DHTML Data Grid
Another one to look at is http://www.treegrid.com/. I've never seen anything as good as this one. -- Darryl http://www.acheron.org/darryl/ --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: CFECLIPSE search
Yeah I want the entire site, not just the page. We found something that we have to replace the whole selection. And I don't want to open up every bloody page just to change two lines. It would sh*t me to tears. I installed Jedit but still trying to figure out how to work it. Jeremy. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: FusionDebug Support
Still no email. But look if charlie reckons I should give it another try I will...BUT don't make me get out my pokin stick and beat ya'all with it! Just ask scott what happen last time he crossed me with a gewd idea.he is now working for the government! mmm...not sure if that is a good thing or a bad thing. Jeremy --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: FusionDebug Support
I emailed again and got a response. Apparently they have been having mail issues, so I agree with Charlie and give them another chance. Regards Dale Fraser http://dale.fraser.id.au -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of cfgroupie Sent: Tuesday, 22 August 2006 10:05 PM To: cfaussie Subject: [cfaussie] Re: FusionDebug Support Still no email. But look if charlie reckons I should give it another try I will...BUT don't make me get out my pokin stick and beat ya'all with it! Just ask scott what happen last time he crossed me with a gewd idea.he is now working for the government! mmm...not sure if that is a good thing or a bad thing. Jeremy --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: CFECLIPSE search
So, you're saying the search all files function (see menu search-search... (ctrl+H)) dialog that contains the replace... button, doesn't satisfy your needs. On 8/22/06, cfgroupie [EMAIL PROTECTED] wrote: Yeah I want the entire site, not just the page. We found something that we have to replace the whole selection. And I don't want to open up every bloody page just to change two lines. It would sh*t me to tears. I installed Jedit but still trying to figure out how to work it. Jeremy. -- Chris Velevitch Manager - Sydney Flash Platform Developers Group www.flashdev.org.au --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Session variable strangeness
Hi, Why would you suggest not re-using the variable as session.episode? I will give the structKeyExists a go today [EMAIL PROTECTED] 22/08/2006 5:16 pm You should clear up your syntax, ie. A) use structkeyexists() for better speed and avoid using not as it creates ambiguity when more than one statement involved: cfif structKeyExists(session, episode) IS false OR session.episode eq show an error /cfif B) Avoid re-using session variables throughout the page: cfif structKeyExists(session, episode) AND session.episode neq cfset episode = session.episode cfelse ...show an error /cfif ... CFQUERYPARAM cfsqltype=cf_sql_numeric value=#episode# -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] Behalf Of Scott Thornton Sent: Tuesday, 22 August 2006 4:41 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Session variable strangeness Hi, Fromtime to time I get errors with my session variables. They are stored in an MS SQL 2000 database, the cf server is CFMX 6.1 The problem: I check to see if a session variable is defined and not blank, then I use the variable within the query. cfif not isdefined(SESSION.EPISODE) or SESSION.EPISODE eq show an error /cfif cfquery SELECT ... WHERE episode_number = CFQUERYPARAM cfsqltype=cf_sql_numeric value=#SESSION.EPISODE# /cfquery However I get en error: Error Executing Database Query. Invalid data for CFSQLTYPE CF_SQL_NUMERIC. The variable SESSION.EPISODE does no longer seem to contain a value. I am emailed an error of a CFDUMP of the session structure when errors like this occur, and the variable episode contains (in the dump ) [empty string] . Am I doing something wrong? Or are session variables playing up? Scott Thornton, Programmer Application Development Information Services and Telecommunications Hunter-New England Area Health Service p: +61 02 49213589 m: 0413800242 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: FusionDebug Support
No I think I used my work email address. I got the issue resolved so I'll give it ago again. I'll let you know how I go. J. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: CFECLIPSE search
Um Chris, mine doesn't have the replace button??? Version: 3.1.1 Build id: M20050929-0840 Am I missing something here... j. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: CFECLIPSE search
I posted that days ago. When you click Replace you get a different dialog thus the ... at the end. And the replace does NOT allow entire site stuff. Regards Dale Fraser http://dale.fraser.id.au -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Chris Velevitch Sent: Wednesday, 23 August 2006 10:09 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: CFECLIPSE search I'm using the same version. The search dialog looks like (see attachment). On 8/23/06, cfgroupie [EMAIL PROTECTED] wrote: Um Chris, mine doesn't have the replace button??? Version: 3.1.1 Build id: M20050929-0840 Am I missing something here... j. -- Chris Velevitch Manager - Sydney Flash Platform Developers Group www.flashdev.org.au --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: CFECLIPSE search
My other favourite is to do a search... then manually delete from the search the items you don't want, then hit the replace button - and do it that way. Mark On 8/23/06, Joel Cass [EMAIL PROTECTED] wrote: Well yes, actually it does.. Select Working Set, click the choose button and create a new set. Choose your site folder to be included and optionally any other files (ie. components, settings files etc).. After the search is complete, you will be prompted to replace changes. Just click replace all. It isn't as obvious as in other apps but it still works well.. -- E: [EMAIL PROTECTED] W: www.compoundtheory.com --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: cflocation confusing me
What version of cf are you using? If youre using CFMX have a look at the cflogin tags Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone:+613 8676 4223 Mobile: 0404 998 273 From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Seona Bellamy Sent: Wednesday, 23 August 2006 3:21 PM To: CFAussie Subject: [cfaussie] cflocation confusing me Hi guys, I've trying to adapt some code I found for checking whether a user is logged in or not, and it's got me very confused over some of the results I'm getting. The code that I'm using is a custom tag as follows: cfif val(caller.userID) is 0 cfset session.srcdoc = attributes.srcdoc cflocation url="" addtoken=No /cfif I'm calling it via the following line: cf_checkLogin srcdoc=#xfa.newtopic#forumID=#forumID# So if the user isn't logged in, they will be shunted to the login page. Theoretically, then, by putting the following at the end of the login functionality, the user should be returned to the page they came from once they've logged in: cflocation url="" addtoken=no Sadly, however, this is not what's happening. Instead, the user is returned to the login page. I get a different (but still wrong) result if I change the call to: cf_checkLogin srcdoc=#xfa.newtopic#amp;forumID=#forumID# In this case, it takes me to the appropriate url but doesn't resolve the entity into a normal ampersand and so gives me an error that it can't find forumID when I call it further down the page. Does anyone know how to solve this? I've been going in circles for the last half hour ro so, and I'm merely succeeding in confusing myself further.. Cheers, Seona. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Web Service Stub Wierdness
You could try putting this in your application.cfc/cfm to reload the apps on
first launch:
!--- flush web services ---
cftry
cfscript
factory = CreateObject('JAVA', coldfusion.server.ServiceFactory);
RpcService = factory.XmlRpcService;
Mappings = RpcService.getMappings();
for (m in Mappings) {
RpcService.refreshWebService(Mappings[m]);
}
/cfscript
cfcatch!-- [error flushing web service cache] --/cfcatch
/cftry
!--- end flush web services ---
That fixes most niggling AXIS issues for me :) Though it does reload all
services on the server so be careful..
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED]
Behalf Of Scott Arbeitman
Sent: Wednesday, 23 August 2006 2:50 PM
To: cfaussie
Subject: [cfaussie] Web Service Stub Wierdness
I have some named web services in my ColdFusion administrator (CF 6.1).
I have templates which invoke the web services. These invocations have
a low timeout.
If I load a template which calls a web service after adding or
refreshing a web service in the administrator, it runs without
problems.
When I restart ColdFusion, however, I can no longer invoke these web
services because of socket timeout errors. These are resolved after
refreshing the web services in the administrator.
Now I know ColdFusion is going to use Axis to generate stubs when
adding/refreshing web services. Therefore, these stubs must be deleted
by CF when restarting ColdFusion even though Save Class Files setting
is enabled (I'm assuming, then, that this setting only applies to
compiled ColdFusion pages, not Axis stubs).
Needless to say, the generate of stubs and their invocation exceeds 5
the timeout threshhold.
Anyone know I can tell CF not to delete these stubs?
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
cfaussie group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~--~~~~--~~--~--~---
