RE: [cfaussie] CF9 Enterprise, Memory Leak\Resource Issue

2017-10-22 Thread Scott Thornton
. make sure that if there are any open files that they are closed. Cheers, Simon On 23 October 2017 at 14:38, Scott Thornton mailto:scott.thorn...@hnehealth.nsw.gov.au>> wrote: Hi, ( In case anyone is still subscribed to cfaussie ) I have recently moved some code from cf6 to cf9 ente

[cfaussie] CF9 Enterprise, Memory Leak\Resource Issue

2017-10-22 Thread Scott Thornton
Hi, ( In case anyone is still subscribed to cfaussie ) I have recently moved some code from cf6 to cf9 enterprise and a particular process consumes all of the resources and hangs the CF server. The exact same code on CF9 standard works okay ( although different windows server version ). The co

RE: [cfaussie] Re: Strange problem - Element RECORDCOUNT is undefined in query

2016-11-03 Thread Scott Thornton
HI Guys, That post was from 2010! From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Mike K Sent: Friday, 4 November 2016 8:21 AM To: cfaussie Subject: Re: [cfaussie] Re: Strange problem - Element RECORDCOUNT is undefined in query Have you run the query in your dat

RE: [cfaussie] Update to CF 9.0.2

2016-03-15 Thread Scott Thornton
ting page of carehart.org. /charlie From: cfaussie@googlegroups.com<mailto:cfaussie@googlegroups.com> [mailto:cfaussie@googlegroups.com] On Behalf Of Scott Thornton Sent: Monday, March 14, 2016 7:51 PM To: cfaussie@googlegroups.com<mailto:cfaussie@googlegroups.com> Subject: RE: [cfaussie] Upd

RE: [cfaussie] Update to CF 9.0.2

2016-03-14 Thread Scott Thornton
[mailto:cfaussie@googlegroups.com] On Behalf Of Mike K Sent: Tuesday, 15 March 2016 11:25 AM To: cfaussie Subject: Re: [cfaussie] Update to CF 9.0.2 I have the WIn64 installer for CF9.0.2 if you want it. On Tue, Mar 15, 2016 at 10:58 AM, Scott Thornton mailto:scott.thorn...@hnehealth.nsw.gov.au

[cfaussie] Update to CF 9.0.2

2016-03-14 Thread Scott Thornton
://www.gpickin.com/cfrepo/ , however the View Files link https://copy.com/nhIbHZYZnmPN doesn't appear to work currently. Could anyone provide any advice on obtaining the updater if possible? Scott Thornton, Platypus2 Phone: 498 53361 Fax: 498 53364 -- You received this message because yo

RE: [cfaussie] Using CF Report Builder

2014-07-24 Thread Scott Thornton
Hi, I still use Crystal reports, rather than CFReport. But, is there any possibility you could add an additional detail line to the report, and display it conditionally when the big field needs to be displayed? OR Can you not set the field to "can grow vertically" ( another crystal report optio

RE: [cfaussie] Unable to read WSDL from URL

2014-07-13 Thread Scott Thornton
m: cfaussie@googlegroups.com<mailto:cfaussie@googlegroups.com> [mailto:cfaussie@googlegroups.com] On Behalf Of Dmitry Yakhnov Sent: Thursday, July 10, 2014 4:26 AM To: cfaussie@googlegroups.com<mailto:cfaussie@googlegroups.com> Subject: Re: [cfaussie] Unable to read WSDL from URL Hi Scott,

RE: [cfaussie] Unable to read WSDL from URL

2014-07-09 Thread Scott Thornton
l 10, 2014 at 3:34 PM, Andrew Scott mailto:andr...@andyscott.id.au>> wrote: Restful is not a web service but a normal RPC that uses get/post/delete etc. So any language than can have an entry point can do RPC or restful calls. Regards, Andrew Scott WebSite: http://www.andyscott.i

RE: [cfaussie] Unable to read WSDL from URL

2014-07-09 Thread Scott Thornton
Hi, Your suggestion works, passing it in via URL. If I use my domain credentials it returns: usernamesuccess I guess it might have something to do with the cffunction returning a struct ( the cfauthenticate result ). I may have to simplify that. Do coldfusion RESTful webservices work in CF 9?

RE: [cfaussie] Unable to read WSDL from URL

2014-07-09 Thread Scott Thornton
Hi, After deleting the stubs in C:\ColdFusion9\stubs\WS854518475\login I was able to get the wsdl to generate ( see below ) The CFinvoke statement returns an error however: http://localhost/login/NTLoginService.cfc?wsdl"; method="loginUserNT"

RE: [cfaussie] Unable to read WSDL from URL

2014-07-09 Thread Scott Thornton
Hi, Sorry, yes this option is already selected. The server is running on 32-bit. From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Andrew Scott Sent: Thursday, 10 July 2014 2:44 PM To: cfaussie@googlegroups.com Subject: Re: [cfaussie] Unable to read WSDL from URL

RE: [cfaussie] Unable to read WSDL from URL

2014-07-09 Thread Scott Thornton
e if there's any more detail in there about the problem. /charlie From: cfaussie@googlegroups.com<mailto:cfaussie@googlegroups.com> [mailto:cfaussie@googlegroups.com] On Behalf Of Scott Thornton Sent: Wednesday, July 09, 2014 8:37 PM To: cfaussie@googlegroups.com<mailto:cfau

[cfaussie] Unable to read WSDL from URL

2014-07-09 Thread Scott Thornton
Hi, I am working with webservices for the first time, and my knowledge is very rudimentary. Scenario: I need to implement NT Authentication on my intranet app. My CF6.1 server can't process the cfntauthenticate tag. I also have a CF9 9,0,1,274733 server that I can use to process a webservice

RE: [cfaussie] Dynamic Data source

2014-05-12 Thread Scott Thornton
Hi, You could read the .csv line by line, using CFFILE , but it can be pretty slow. ( There are probably fancier\faster ways ) Eg.

[cfaussie] CFMX 6.1 and MSSQL2012 db, Error: The requested instance is either invalid or not running.

2013-07-16 Thread Scott Thornton
Hi A recent database upgrade from MS SQL2005 to 2012 has caused ( I believe) the following error to occur intermittently ( about 10 times today): Macromedia][SQLServer JDBC Driver][Macromedia][SQLServer JDBC Driver]The requested instance is either invalid or not running. java.sql.SQLException:

RE: [cfaussie] Re: Debugging problem on cf9

2012-10-04 Thread Scott Thornton
Hi Charlie\Carl, Yes that was the problem. The number of form fields needed to be increased. I am emailing as it didn't see Joel's post come throught the email notification. He did post on the googlegroup website apparently though. Thanks for your quick responses, we would never had figured it

[cfaussie] OT: Crystal Reports for Eclipse, on a CF 9 server.

2012-07-23 Thread Scott Thornton
Hi, I was wondering if any of you have investigated the usage of the Crystal Reports for Eclipse project, specifically: accessing\deploying Crystal Reports from a coldfusion 9 jrun webserver? http://scn.sap.com/community/crystal-reports-for-eclipse Jrun is not listed as a supported server... b

RE: [cfaussie] Re: OT: Webpage download timing

2012-04-04 Thread Scott Thornton
Apologies, I should I have mentioned I have Firebug ( and yslow ), but have yet to figure out to display a timing for each of the components of the web page. ……. Scrap that, I have just seen the components option under Firebug ( I was stuffing around in ySlow orginally) and now see the individu

RE: [cfaussie] BarCode Generator with CF Report Builder

2012-03-20 Thread Scott Thornton
Bar codes are just fonts. In the past I have used a font to display Bar Codes generated in Crystal reports. A standard format for the code must be defined for item you are scanning, eg length and pre and postfix characters. For example a Medical Record Number (I work in health) might represent

RE: [cfaussie] RE: Attribute validation error for tag cfoutput

2012-01-31 Thread Scott Thornton
tell if you are surprised that it returned 0 records. /charlie From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Scott Thornton Sent: Tuesday, January 31, 2012 4:27 PM To: cfaussie@googlegroups.com Subject: RE: [cfaussie] RE: Attribute validation error for tag cfoutpu

RE: [cfaussie] RE: Attribute validation error for tag cfoutput

2012-01-31 Thread Scott Thornton
@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Scott Thornton Sent: Monday, January 30, 2012 11:23 PM To: cfaussie@googlegroups.com Subject: [cfaussie] RE: Attribute validation error for tag cfoutput I changed my code to work within a cfloop ( which it should have been anyway

[cfaussie] RE: Attribute validation error for tag cfoutput

2012-01-30 Thread Scott Thornton
I changed my code to work within a cfloop ( which it should have been anyway ), and it works okay. -- 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

[cfaussie] Attribute validation error for tag cfoutput

2012-01-30 Thread Scott Thornton
G'day, A strange problem just cropped up in one of my live systems ( CF 9 ). This page works on a CFMX6.1 server ( against a different database ). The page works when I run it locally ( cf 9 against the same datbase ) When I look at the debug output for the page, I can see that the query "BBER

[cfaussie] OT: jquery plugin eurodate (dmy) validation

2012-01-10 Thread Scott Thornton
Hi, Is anyone aware of any great client side eurodate validation plugins for jquery? eg: Valid: 01/01/01, 01-01-01, 01/Jan/2001, 29-Feb-2012 Invalid: 31-Mar-2001, 29-Feb-2011 I am looking for more then just a regex, to acutally parse and verify the date. I'd really rather not have to build one.

RE: [cfaussie] Scheduled Tasks - Where is the log file?

2011-06-13 Thread Scott Thornton
tting under Debugging & Logging > Logging Settings From: Scott Thornton [mailto:scott.thorn...@hnehealth.nsw.gov.au] Sent: Tuesday, 14 June 2011 2:18 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Scheduled Tasks - Where is the log file? Hi, CF MX 6.1 has a log file named scheduler.log

[cfaussie] Scheduled Tasks - Where is the log file?

2011-06-13 Thread Scott Thornton
Hi, CF MX 6.1 has a log file named scheduler.log available in cf admin. CF 9 standard, doesn't appear to have one at all Can you tell me should it exist, or perhaps the logged information goes into one of the other log files now? Thanks, -- You received this message because you are subscribe

RE: [cfaussie] Coldfusion Builder 2 is now available to buy or try

2011-05-02 Thread Scott Thornton
Hi, Do you guys actually use CF builder? I wanted to give proper debugging another go, installed CF builder 1 three weeks ago and attempted to get started. To be fair, its an environment that I am not famaliar with, but it seems so slow, so hard to do anything in it, I have so many questions a

RE: [cfaussie] OT: jsp question

2011-04-14 Thread Scott Thornton
jsphandler, which is mapped to *.jsp This is from our Enterprise CF 9 on IIS 7. It'd be easy enough to check for other configurations (standalone etc) by downloading and installing it as a developer edition Cheers Paul On Thu, Apr 14, 2011 at 10:56 AM, Scott Thornton mailto:scott.

[cfaussie] OT: jsp question

2011-04-13 Thread Scott Thornton
Hello, Quick off topic question, Can an IIS server running CF 9 also run .jsp pages? I am guessing not, and that it would need another server software... like apache or something? I don't know anything about jsp obviously -- You received this message because you are subscribed to the G

[cfaussie] Fullasagoog still working?

2011-03-20 Thread Scott Thornton
Hi, Is the www.fullasagoog.com website still working? The last post I have is from 6 days ago entitled - "cf.Objective() 2011 - Call for Pecha Kucha Speakers and BoF Survey Now Open" -- You received this message beca

RE: [cfaussie] CFChart X axis value formatting

2011-03-17 Thread Scott Thornton
Hello, Couldn't you summarise your data in your query the first place? eg: select left(datename(month, my_date ),3) +'-'+ datename( year, my_date) as period, count( of something ) as my_count from my_table group by left(datename(month, my_date ),3) +'-'+ datename( year, my_date) ( MS

RE: [cfaussie] CF and Ajax

2010-10-12 Thread Scott Thornton
:31 PM, Andrew Scott wrote: No you don’t need to always use jQuery, you can even look at using the cfajaxproxy tag to do what you need. Regards, Andrew Scott http://www.andyscott.id.au/ From: cfaussie@googlegroups.com<mailto:cfaussie@googlegroups.com> [mailto:cfaus...@googlegroups.com] O

RE: [cfaussie] Crystal Reports and CF9 Report Builder - how similar?

2010-10-11 Thread Scott Thornton
Hello, A few things.. Reports written in Crystal Reports ( 8,9, 11 etc) do not work with the CFREPORT tag. My understanding is that Report Builder is a cut down version of Crytsal Reports and is missing some functionality. The reports are not interchangeable between products btw. You CAN get

[cfaussie] CF and Ajax

2010-10-11 Thread Scott Thornton
Hello, I am looking for a solution that will allow Ajax-y style updates of a database when a user changes a value in one of many select boxes in a form. EG: Say there are 20 select boxes in a form with Yes or No Options. Changing the value will perform a database update without the usual form s

RE: [cfaussie] Strange problem - Element RECORDCOUNT is undefined in query

2010-09-30 Thread Scott Thornton
Hello, Thanks for all replies. An update of my local dev server to 9,0,1,274733 appears to have solved the problem. From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Scott Thornton Sent: Friday, 1 October 2010 10:29 AM To: cfaussie@googlegroups.com Subject: RE

RE: [cfaussie] Strange problem - Element RECORDCOUNT is undefined in query

2010-09-30 Thread Scott Thornton
COUNT is undefined in query What happens if you try CFDUMP instead right after the query? On 1/10/2010 9:35 AM, Scott Thornton wrote: Hi, Running across a odd problem in CF 9,0,0,251028. development server. I was just running a process that usually works and has not been modified for quite a

[cfaussie] Strange problem - Element RECORDCOUNT is undefined in query

2010-09-30 Thread Scott Thornton
Hi, Running across a odd problem in CF 9,0,0,251028. development server. I was just running a process that usually works and has not been modified for quite a long time. part of that process runs a query and then loops over the result set. Simple enough... however the query does not seem to exi

[cfaussie] @Geoff Bowers, http://www.fullasagoog.com/ seems to be down

2010-09-15 Thread Scott Thornton
in case you didn't already know. -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options,

RE: [cfaussie] Database Changes

2010-08-18 Thread Scott Thornton
RIGGER [tablename_UPDATE] ON[dbo].[tablename] FOR UPDATE AS /* Author: Scott Thornton Date: 05-07-2005 Desc: For each field modified on the x table, insert a record into the Audit log table and show the value of the filed before and after the update. */ set nocount on SET DATEFORMAT DMY D

RE: [cfaussie] CF8 and MSSQL 2005/2008

2010-08-15 Thread Scott Thornton
I have seen similar behaviour, I think it was with CF 8. Using the Set nocount on option seemed to help. set nocount on INSERT INTO TableName (Col1) VALUES ('foobar') SELECT @@IDENTITY AS 'NewID' Set nocount off PS: SCOPE_IDENTITY() is a better choice. You never know when your table may have

[cfaussie] Re: Issue with displaying Chinese characters into CFDOCUMENT PDF

2010-07-19 Thread Scott Thornton
Hi, FileMon and ProcMon ( formerly from a company named SysInternals) are now owned by Microsoft. Good utilities they are. www.sysinternals.com >>> Gavin Baumanis 20/07/2010 10:22 am >>> Try stopping the CF service and any other service that might be using those files. then you should be good

[cfaussie] Adobe LiveCycle

2010-06-16 Thread Scott Thornton
Hi, Anyone else having trouble seeing the Adobe website http://www.adobe.com/products/livecycle/forms/ ? I have been asked to review an Analysis document for a project that includes livecycle, but am struggling to find out what it does. The costs seem quite high, and I wanted to see what it do

Re: [cfaussie] Re: Odd date behaviour - CF9/SQLServer2005

2010-06-07 Thread Scott Thornton
alia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Tue, Jun 8, 2010 at 2:15 PM, Gavin Baumanis wrote: > Hi All, > > On Jun 8, 2:06 pm, "Scott Thornton" > wrote: &

Re: [cfaussie] Re: Odd date behaviour - CF9/SQLServer2005

2010-06-07 Thread Scott Thornton
Hi, pretty sure that collation refers to sort order. Language refers to date format however, but I could not find a server wide setting to change it. SELECT @@LANGUAGE AS 'Language Name' returns us_english in my SQL 2005 server. If the language was British it would default to dmy select * fro

Re: [cfaussie] Display XML on webpage

2010-06-06 Thread Scott Thornton
Hi, I have now. it will also need special formatting to make it more readable. >>> Blair McKenzie 07/06/2010 2:50 pm >>> Have you tried the htmleditformat function? On Mon, Jun 7, 2010 at 2:44 PM, Scott Thornton < scott.thorn...@hnehealth.nsw.gov.au> wrote: > Hi,

Re: [cfaussie] Display XML on webpage

2010-06-06 Thread Scott Thornton
07/06/2010 at 2:37 pm, in message <4c0c7794.1070...@ampersand.net.au>, >>> "m...@ampersand.net.au" wrote: How about #replace(query.xml,"<","<","all")# Dodgy I know but does it work? On 7/06/2010 2:29 PM, Scott Thornton wrote: Thanks

Re: [cfaussie] Display XML on webpage

2010-06-06 Thread Scott Thornton
Thanks, however: returns: Attribute validation error for tag cfcontent. java.lang.String is not a supported variable type. The variable is expected to contain binary data. >>> Andrew Scott 07/06/2010 2:22 pm >>> Try using the cfcontent. On Mon, Jun 7, 2010 at 2:18

[cfaussie] Display XML on webpage

2010-06-06 Thread Scott Thornton
Hi, I was hoping to achieve something rather simple ( I thought), which was to display on a webpage the xml stored from within a database, in hopefully a formatted manner. The XML is stored unformatted within a database text field. When I save the following XML a text document with an .xml ext

Re: [cfaussie] CFUG Melbourne May 2010. REMINDER, POSTPONED TO NEXT WEEK

2010-05-19 Thread Scott Thornton
Hi, do you have any events on the 01-jun ? I am down that way for a meeting... I'd guess not but >>> Peter Robertson 20/05/2010 10:13 am >>> If you're attending the CFUG in Melbourne this month, please don't roll up tonight, we've postponed to next week to accommodate CogState's move and so

Re: [cfaussie] OT : google group bounced emails

2010-05-18 Thread Scott Thornton
I have been yes. >>> "Steve Onnis" 19/05/2010 11:10 am >>> Is anyone else getting bounce emails from Mike Gardiner or is it just me? Steve -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaus...@googlegroups

[cfaussie] Re: CF Mail problem

2010-05-17 Thread Scott Thornton
Hi, google searches indicate that the .restart() method might be available from 7 onwards. I am updating my servers soon to 9, so Ill see if I can implement something then.. >>> nkosi 18/05/2010 11:25 am >>> Hi Scott, I can't remember if you can get a hold of ColdFusion's server factory in C

RE: [cfaussie] CF Mail problem

2010-05-17 Thread Scott Thornton
uot; attribute on CFMAIL. Or did you have in mind some other goal in "breaking the tie that binds"? /charlie > -Original Message- > From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On > Behalf Of Scott Thornton > Sent: Monday, May 17, 2010 6:14 PM

Re: [cfaussie] CF Mail problem

2010-05-17 Thread Scott Thornton
ink version 9 is much the same. I wonder if they'd consider an enhancement request? >>> Kym Kovan 17/05/2010 4:58 pm >>> On 17/05/2010 16:30, Scott Thornton wrote: > Hi, > > Nothing unusual on logs > > I am, since last week. The spool checking stooped last Friday a

Re: [cfaussie] CF Mail problem

2010-05-16 Thread Scott Thornton
il being sent from a CF server. Cheers Kai On 17/05/2010, at 2:03 PM, Scott Thornton wrote: > Hi, > > I have a bunch or mail sitting in my spool directory un-sent from over the > weekend. > > Obviously something is not working. Is it possible to 'restart' the

[cfaussie] CF Mail problem

2010-05-16 Thread Scott Thornton
Hi, I have a bunch or mail sitting in my spool directory un-sent from over the weekend. Obviously something is not working. Is it possible to 'restart' the cfmail process without re-starting the entire CF service? This is CF MX 6.1. -- You received this message because you are subscribed

RE: [cfaussie] Trying To Connect To Exchange Server using

2010-05-12 Thread Scott Thornton
Hello Bryce, I see you are from Newcastle too.. I didn't realise the Council also used CF. Finally there is another person using CF ( outside of HNEAHS that is.) :> >>> Bryce Hoffmann 13/05/2010 11:21 am >>> Try putting the domain in front of your 'myusername' as in 'domain\myusername' Reg

Re: [cfaussie] CF9 upgrade and subscription renewal heeelllpp!!!

2010-05-06 Thread Scott Thornton
Hello, Try Vanessa at daemon 8302 4600 >>> MrBuzzy 07/05/2010 3:51 pm >>> I guess it depends where the original "subscription" came from. Don't you have that information? The client may receive an invoice to pay their subscription periodically. If it's kept up to date they are eligible for CF9

[cfaussie] CF IDE

2010-05-03 Thread Scott Thornton
e fancy features of DW MX, Coldfusion Builder seemed a good fit. What do you use? Scott Thornton, Acting System Administrator Centralised Billing Unit Hunter-New England Area Health Service ext: 53361 p: +61 02 498 53361 m: 0413 800 242 -- You received this message because you are subscribed to the

RE: [cfaussie] cfmamil problem

2010-04-18 Thread Scott Thornton
the CF Administrator. Brian -Original Message- From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Scott Thornton Sent: Friday, 16 April 2010 11:34 AM To: 'cfaussie@googlegroups.com' Subject: RE: [cfaussie] cfmamil problem Hi, thanks for your reply.

RE: [cfaussie] cfmamil problem

2010-04-15 Thread Scott Thornton
g the correct log file, and that it is actually turned on to log in the CF Administrator. Brian -Original Message- From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Scott Thornton Sent: Friday, 16 April 2010 11:34 AM To: 'cfaussie@googlegroups.com' Subj

RE: [cfaussie] cfmamil problem

2010-04-15 Thread Scott Thornton
g initialized" The emails are in the spool folder, just not going anywhere... I might have to schedule a service restart. Scott Thornton, Centralised Billing Unit Hunter-New England Area Health Service ext: 53358 p: +61 02 498 53358 m: 0413 800 242 >>> "KNOTT, Brian"

[cfaussie] cfmamil problem

2010-04-15 Thread Scott Thornton
going wrong, and, what can I do to fix it? Scott Thornton, Centralised Billing Unit Hunter-New England Area Health Service ext: 53358 p: +61 02 498 53358 m: 0413 800 242 -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this g

Re: [cfaussie] First foray into ajax

2010-03-31 Thread Scott Thornton
od examples, as is Dodo and moo tools. On Thu, Apr 1, 2010 at 1:26 PM, Scott Thornton < scott.thorn...@hnehealth.nsw.gov.au> wrote: > Hello, > > Checked out that page, and thought i'd look for examples before I > downaloded to see what it can do etc > > http://aja

Re: [cfaussie] First foray into ajax

2010-03-31 Thread Scott Thornton
ww.robgonda.com/ don't work,. any posts on this site about cfajax are quite old >>> Kym Kovan 23/03/2010 12:19 pm >>> On 23/03/2010 12:05, Scott Thornton wrote: > Hello, > > I have been very lazy and not delved into any ajax stuff, mostly because > I don't h

RE: [cfaussie] CFqueryparam value's in debug output

2010-03-24 Thread Scott Thornton
parameters in the above statements. >>> "Steve Onnis" 25/03/2010 9:52 am >>> If you use the result argument and dump that you will get the params -Original Message- From: Scott Thornton [mailto:scott.thorn...@hnehealth.nsw.gov.au] Sent: Thursday, 25 Mar

[cfaussie] CFqueryparam value's in debug output

2010-03-24 Thread Scott Thornton
site wide error template and in an email that is sent. Can any recall seeing this too? and point me in the right direction? I thought i saw it at barneyblog or the one by andy jarret but no luck... cf 9 development system, cfmx6.1 in live environment. Scott Thornton, Centralised Billing Unit Hun

Re: [cfaussie] RocketBoots - Galaxy

2010-03-22 Thread Scott Thornton
Hi, What's the name of the PMS? and who do you work for if you don't mind me asking? being in health myself... and doing cf, didn't think there where many people out there like us Scott Thornton, Centralised Billing Unit Hunter-New England Area Health Service ext: 5335

[cfaussie] First foray into ajax

2010-03-22 Thread Scott Thornton
Hello, I have been very lazy and not delved into any ajax stuff, mostly because I don't have the time, and we have tried to keep the application I work on as simple as possible. However, I was wondering if it was possible to perform the following asynchronously without a page submit: User ent

Re: [cfaussie] FusionReactor vs built in Coldfusion 8 monitor

2010-02-08 Thread Scott Thornton
I like Fusionreaactor's ability to kill off processes.. I don't think that is built into 8 or 9. >>> BarryC 09/02/2010 9:24 am >>> Hi All we are looking at getting FusionReactor, but will be upgrading from Coldfusion 7 to Coldfusion 8 in several months. How does FusionReactor compare to the Co

[cfaussie] CFREPORT and Crystal reports

2010-01-31 Thread Scott Thornton
Hello, I am having a bit of a play around with CF9 and CFREPORT I can successfully display a report based on a datasource and supply a password, but the resulting output is in .html and a 3 page report scrolls down the page and looks ugly. Can I specify the format to be in .pdf? I have tried u

RE: [cfaussie] Killing Slow Threads in cf9

2009-12-09 Thread Scott Thornton
minate threads in a "native thread" state. HTH /charlie > -Original Message- > From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On > Behalf Of Scott Thornton > Sent: Wednesday, December 09, 2009 6:04 PM > To: cfaussie@googlegroups.com > Subject:

[cfaussie] Killing Slow Threads in cf9

2009-12-09 Thread Scott Thornton
hello, Does anyone know if the new cf9 monitor can be used to kill off slow running pages\threads? Or is an external product like FusionRector still required? Thanks, Scott Thornton, Centralised Billing Unit Hunter-New England Area Health Service ext: 53358 p: +61 02 498 53358 m: 0413 800

Re: [cfaussie] Grouping Date / time values in a Cfquery output

2009-11-22 Thread Scott Thornton
sql 2000, 2005 etc set dateformat dmy select from group by convert(datetime, convert(varchar, my_date, 103)), description, user or select from group by year( my_date ), month(my_date), day(my_date), description, user PS. either my email client is showing cfau

[cfaussie] ping

2009-01-14 Thread Scott Thornton
Hi, Just checking if cfaussie is still working for me. Please ignore. Scott Thornton, Programmer Billing Unit, Hunter-New England Area Health Service ext: 51762 p: +61 02 491 51762 m: 0413 800 242 --~--~-~--~~~---~--~~ You received this message because you

[cfaussie] Re: Error 500 Page

2008-12-09 Thread Scott Thornton
Hi, Maybe Tools -> Internet Options -> Browsing -> Show Friendly HTTP error messages has something to do with it ( within IE 6 this is maybe diff for ie 7 ) Maybe Firefox has a similar option? >>> Andrew <[EMAIL PROTECTED]> 10/12/2008 11:10 am >>> Hi All, This is probably not a ColdFusion

[cfaussie] merge databases

2008-12-08 Thread Scott Thornton
I think they can be purchased individually. At least the Compare program could be purchased individually last year when I was looking at it. I know its a bit more painful, but why don't you do it by hand if its a once off? USE OLD_DATABASE INSERT INTO MYTABLE ( ... ) SELECT ... FROM NEW_DATAB

[cfaussie] PDF Generation

2008-11-26 Thread Scott Thornton
Hi, I think Crystal reports is a powerful tool without any real competitors. It works great on stored proc, views and linked table.. and I don't know how people really develop 'reports' without it.. I think we have over 300 or so on the application I work on.. we just found the set-up rathe

[cfaussie] PDF Generation

2008-11-25 Thread Scott Thornton
Correction... easy to use, a pain to set up... >>> "Steve Onnis" <[EMAIL PROTECTED]> 26/11/2008 3:01 pm >>> Crystal is a pain to use. Looking for something easy to set up and manage. _ From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Dale Fraser Sent: Wednesday, 2

[cfaussie] RegEx Banging Head

2008-11-24 Thread Scott Thornton
the character " literally «"» its cheap too. :> Scott Thornton, Programmer Billing Unit, Hunter-New England Area Health Service ext: 51762 p: +61 02 491 51762 m: 0413 800 242 >>> Robin Hilliard <[EMAIL PROTECTED]> 25/11/2008 10:56 am >>> This is the regex: h

[cfaussie] parsing as string into a text and numeric portion

2008-11-20 Thread Scott Thornton
NoCase(string, "[^[:digit:]]", ""); Simple enough? -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Scott Thornton Sent: Friday, 21 November 2008 11:03 AM To: cfaussie@googlegroups.com Subject: [cfaussie] parsing as string into a text

[cfaussie] parsing as string into a text and numeric portion

2008-11-20 Thread Scott Thornton
e- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Scott Thornton Sent: Friday, 21 November 2008 11:03 AM To: cfaussie@googlegroups.com Subject: [cfaussie] parsing as string into a text and numeric portion Hi, Given a string like acb123, is there a simple method of parsing

[cfaussie] parsing as string into a text and numeric portion

2008-11-20 Thread Scott Thornton
Hi, Given a string like acb123, is there a simple method of parsing into the text portion and the numeric portion. I have thought about looping of each character of the string and checking to see if it was IsNumeric. Any better ideas? Scott Thornton, Programmer Billing Unit, Hunter-New

[cfaussie] Re: threaded function that calls itself

2008-11-20 Thread Scott Thornton
Hi, Don't forget to build in some functionality that allows you to stop it as well. >>> "AJ Mercer" <[EMAIL PROTECTED]> 21/11/2008 9:38 am >>> Would this be a bad thing to do? A component that is living in the APPLICATION scope on init() creates a thread for a method call (one of it's own meth

[cfaussie] Re: Verity vs SQL Server Full-text index

2008-11-18 Thread Scott Thornton
Hi, I realise it will be of no use whatsoever, but staff here recently replaced a verity search site ( written in part by myself many many years ago) with a solution from google. To be fair the verity solution was only slapped together solution, but the google result seem more accurate and re

[cfaussie] Referencing a query inside another query in ColdFusionMX

2008-11-12 Thread Scott Thornton
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] Referencing a query inside another query inColdFusionMX

2008-11-11 Thread Scott Thornton
Hi, Depending n the number of rows returned from this 'complicated' query, this approach may or may not work. I am unsure as to which database you are using but each differs in the number of values it can cope with in an IN clause. Lets assume its 1000 values ( or probably closer to 2000). Yo

[cfaussie] CF Maintenance purchase

2008-10-29 Thread Scott Thornton
Yes, >> >> CF9 will be released inside of 12 months I think. >> >> Regards >> Dale Fraser >> http://learncf.com >> http://flexcf.com >> >> >> -Original Message- >> From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED]

[cfaussie] CF Maintenance purchase

2008-10-29 Thread Scott Thornton
Hi, Out of curiosity, is there expected to be any new releases etc of coldfusion in the next year? I am trying to decide weather to purchase the maintenance plan with a some new licences... Cheers, Scott Thornton, Programmer Billing Unit, Hunter-New England Area Health Service ext: 51762 p

[cfaussie] Purchasing Enterprise

2008-10-27 Thread Scott Thornton
HI, What's the best place to purchase 2 copies of CF Enterprise these days? From Adobe direct or an Aussie re-seller? Bear in mind that purchasing by Credit card is an absolute hassle in an organisation like mine.. Pretty sure we have gone through Daemon before, but its been years ( still run

[cfaussie] Re: dhtml / advanced select boxes

2008-10-21 Thread Scott Thornton
nvm. found http://bassistance.de/jquery-plugins/jquery-plugin-autocomplete/ >>> "Scott Thornton" <[EMAIL PROTECTED]> 22/10/2008 3:20 pm >>> Hi, I really hate our iframe-based doctor selector thingamy. I was wondering if dhtml/ajax etc has advanced enough o

[cfaussie] dhtml / advanced select boxes

2008-10-21 Thread Scott Thornton
Hi, I really hate our iframe-based doctor selector thingamy. I was wondering if dhtml/ajax etc has advanced enough over the years to do a client-side select as you type select box yet? What I mean is, is it possible to cache ( or something ) say a list over 2000 items on the client side, and

[cfaussie] OT : SQL server over a network

2008-10-12 Thread Scott Thornton
ge- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Scott Thornton Sent: Monday, 13 October 2008 11:24 AM To: cfaussie@googlegroups.com Subject: [cfaussie] OT : SQL server over a network HI, Its always worth it ( imho ). A year or more ago we went from an aging dua

[cfaussie] OT : SQL server over a network

2008-10-12 Thread Scott Thornton
clustering CF next just need someone to pay for CF licences. >>> "Barry Beattie" <[EMAIL PROTECTED]> 13/10/2008 10:38 am >>> @Scott Thornton "Also clustering sql server for the ultimate in redundancy." if someone was after hot-swapping from a pr

[cfaussie] OT : SQL server over a network

2008-10-12 Thread Scott Thornton
t $$. A simple cost effective solution may be log shipping.. if you have another server handy. That may mean you have to point your DSN to the different server if things go pear-shaped. You could even try catch a specific database error code and change your DSN in a variable.. Scott Thorn

[cfaussie] Re: OT : SQL server over a network

2008-10-12 Thread Scott Thornton
mean redundant server? You may like to check out the terms "Replication" and "Log Shipping" for making hot-standby by copies of your database. Also clustering sql server for the ultimate in redundancy. Scott Thornton, Programmer Billing Unit, Hunter-New England Area Health Ser

[cfaussie] Re: Adobe AIR Weather Widget

2008-10-09 Thread Scott Thornton
Hi, Having had no experience in AIR (or really know what it is), out of curiosity I installed AIR, and i think installed your app properly. At first I thought I must be doing something wrong...I didn't see anything load, then found a little sun on my taskbar, but no program on either of my two

[cfaussie] Re: Version control + ColdFusion development

2008-09-25 Thread Scott Thornton
Hi, Hope you get some great answers. I need to do this myself with a few other developers here. Version control as you have found, is as much about the process of using it as it is as having a repository. It is the process part that undoes me. >>> Matthew <[EMAIL PROTECTED]> 26/09/2008 9:25 a

[cfaussie] Re: Quick List question

2008-09-09 Thread Scott Thornton
Hi Before reading .csv files, I typically try to find and replace any repeating delimiters because as you discovered, CF ( for me its 6.1 ) treats them as one delimiter and not two. eg replace two commas with the string comma space comma. the deals with empty columns Cheers, >>> "Andr

[cfaussie] Re: Grouping Output By Date Not working

2008-09-03 Thread Scott Thornton
Hi, to remove the time from a date column I would use (SQL 2000\2005 ETC) SET DATEFORMAT DMT SELECT CONVERT(DATETIME, CONVERT(VARCHAR, MY_DATE_TIME_FIELD, 103)) FROM XXX GROUP BY CONVERT(DATETIME, CONVERT(VARCHAR, MY_DATE_TIME_FIELD, 103)) >>> On 03/09/2008 at 5:58 pm, in message

  1   2   3   4   >