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

[Scott Thornton]

Hi,

Simon:
There are a few places where CFFILE ( with an append) is used to log some 
things, but nothing that I could call a file stream or file handler.

Charlie:
I believe I turned on the memory tracking after the first half-dozen or so 
server crashes. I’ve turned it off subsequently. ( I have also read of it 
causing problems).
When the server stops responding to requests, they all have in common a large 
amount of Memory usage. CPU usage is quite low. I believe that the monitor is 
not running presently, memory usage is at 3,382MB.
I have used fusion-reactor.com previously on my old servers, and I had hoped I 
could avoid the cost of current fusion-reactor versions. I have obtained a 
quote for the new version and will get it installed soon ( hopefully ). I might 
be able to see if the demo version will work for me.



From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of 
Simon Haddon
Sent: Monday, 23 October 2017 3:16 PM
To: cfaussie@googlegroups.com
Subject: Re: [cfaussie] CF9 Enterprise, Memory Leak\Resource Issue

Without seeing the code my first thought is that you are opening a file stream 
or file handler without closing it within the loop.  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 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 code is processing HL7 messages ( health messaging, admission, discharge 
messages etc ) and basically it works in a continuous cfloop, selecting the top 
1 message from the database, and calls a bunch of extra pages to process the 
messages.


My errors look like the following, from the log file:

10/12 14:58:20 error ROOT CAUSE:
java.lang.OutOfMemoryError: GC overhead limit exceeded
at java.util.IdentityHashMap.init(IdentityHashMap.java:244)
at java.util.IdentityHashMap.(IdentityHashMap.java:190)
at 
coldfusion.monitor.memory.MemoryTrackerProxy.registerMemoryTracker(MemoryTrackerProxy.java:182)
at 
coldfusion.monitor.memory.MemoryTracker.registerWithObject(MemoryTracker.java:222)
at 
coldfusion.monitor.memory.MemoryTracker.onAddObject(MemoryTracker.java:174)
at 
coldfusion.monitor.memory.MemoryTrackerProxy.onReplaceValue(MemoryTrackerProxy.java:598)
at 
coldfusion.monitor.memory.MemoryTrackerProxy.onReplace(MemoryTrackerProxy.java:551)
at coldfusion.runtime.Variable.setInternal(Variable.java:143)
at coldfusion.runtime.Variable.set(Variable.java:71)
at 
coldfusion.runtime.LocalScope.bindInternal(LocalScope.java:362)
at 
cfsbbp03_pims_hl72ecfm1750835129$funcHL7LISTGETAT.runFunction(D:\WWWRoot\HNEPlatypus2\Batch\sbbp03_pims_hl7.cfm:86)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
at 
coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
at 
coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
at 
coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220)
at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2582)
at 
cfsbbp03_pims_hl72ecfm1750835129._factor7(D:\WWWRoot\HNEPlatypus2\Batch\sbbp03_pims_hl7.cfm:403)
at 
cfsbbp03_pims_hl72ecfm1750835129._factor16(D:\WWWRoot\HNEPlatypus2\Batch\sbbp03_pims_hl7.cfm:319)
at 
cfsbbp03_pims_hl72ecfm1750835129._factor17(D:\WWWRoot\HNEPlatypus2\Batch\sbbp03_pims_hl7.cfm:317)
at 
cfsbbp03_pims_hl72ecfm1750835129._factor24(D:\WWWRoot\HNEPlatypus2\Batch\sbbp03_pims_hl7.cfm:180)
at 
cfsbbp03_pims_hl72ecfm1750835129._factor26(D:\WWWRoot\HNEPlatypus2\Batch\sbbp03_pims_hl7.cfm:1)
at 
cfsbbp03_pims_hl72ecfm1750835129.runPage(D:\WWWRoot\HNEPlatypus2\Batch\sbbp03_pims_hl7.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
at 
coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56)
at 
coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271)
at 
coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722)
at 
cfsb_hl7_table_processor2ecfm1950658070._factor6(D:\WWWRoot\HNEPlatypus2\Batch\sb_hl7_table_processor.cfm:552)
at 
cfsb_hl7_table_processor2ecfm1950658070._factor8(D:\WWWRoot\HNEPlatypus2\Batch\sb_hl7_table_processor.cfm:518)
at 
cfsb_hl7_table_processor2ecfm1950658070._fact

[cfaussie] CF9 Enterprise, Memory Leak\Resource Issue

[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 code is processing HL7 messages ( health messaging, admission, discharge 
messages etc ) and basically it works in a continuous cfloop, selecting the top 
1 message from the database, and calls a bunch of extra pages to process the 
messages.


My errors look like the following, from the log file:

10/12 14:58:20 error ROOT CAUSE:
java.lang.OutOfMemoryError: GC overhead limit exceeded
at java.util.IdentityHashMap.init(IdentityHashMap.java:244)
at java.util.IdentityHashMap.(IdentityHashMap.java:190)
at 
coldfusion.monitor.memory.MemoryTrackerProxy.registerMemoryTracker(MemoryTrackerProxy.java:182)
at 
coldfusion.monitor.memory.MemoryTracker.registerWithObject(MemoryTracker.java:222)
at 
coldfusion.monitor.memory.MemoryTracker.onAddObject(MemoryTracker.java:174)
at 
coldfusion.monitor.memory.MemoryTrackerProxy.onReplaceValue(MemoryTrackerProxy.java:598)
at 
coldfusion.monitor.memory.MemoryTrackerProxy.onReplace(MemoryTrackerProxy.java:551)
at coldfusion.runtime.Variable.setInternal(Variable.java:143)
at coldfusion.runtime.Variable.set(Variable.java:71)
at 
coldfusion.runtime.LocalScope.bindInternal(LocalScope.java:362)
at 
cfsbbp03_pims_hl72ecfm1750835129$funcHL7LISTGETAT.runFunction(D:\WWWRoot\HNEPlatypus2\Batch\sbbp03_pims_hl7.cfm:86)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
at 
coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
at 
coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
at 
coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220)
at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2582)
at 
cfsbbp03_pims_hl72ecfm1750835129._factor7(D:\WWWRoot\HNEPlatypus2\Batch\sbbp03_pims_hl7.cfm:403)
at 
cfsbbp03_pims_hl72ecfm1750835129._factor16(D:\WWWRoot\HNEPlatypus2\Batch\sbbp03_pims_hl7.cfm:319)
at 
cfsbbp03_pims_hl72ecfm1750835129._factor17(D:\WWWRoot\HNEPlatypus2\Batch\sbbp03_pims_hl7.cfm:317)
at 
cfsbbp03_pims_hl72ecfm1750835129._factor24(D:\WWWRoot\HNEPlatypus2\Batch\sbbp03_pims_hl7.cfm:180)
at 
cfsbbp03_pims_hl72ecfm1750835129._factor26(D:\WWWRoot\HNEPlatypus2\Batch\sbbp03_pims_hl7.cfm:1)
at 
cfsbbp03_pims_hl72ecfm1750835129.runPage(D:\WWWRoot\HNEPlatypus2\Batch\sbbp03_pims_hl7.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
at 
coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56)
at 
coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271)
at 
coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722)
at 
cfsb_hl7_table_processor2ecfm1950658070._factor6(D:\WWWRoot\HNEPlatypus2\Batch\sb_hl7_table_processor.cfm:552)
at 
cfsb_hl7_table_processor2ecfm1950658070._factor8(D:\WWWRoot\HNEPlatypus2\Batch\sb_hl7_table_processor.cfm:518)
at 
cfsb_hl7_table_processor2ecfm1950658070._factor13(D:\WWWRoot\HNEPlatypus2\Batch\sb_hl7_table_processor.cfm:439)
at 
cfsb_hl7_table_processor2ecfm1950658070._factor14(D:\WWWRoot\HNEPlatypus2\Batch\sb_hl7_table_processor.cfm:1)
at 
cfsb_hl7_table_processor2ecfm1950658070.runPage(D:\WWWRoot\HNEPlatypus2\Batch\sb_hl7_table_processor.cfm:1)

I have moved the process back to my old server ( cf6 ), but the server admin 
team would prefer that the server is removed sooner rather than later.

I am contemplating putting another website on the cf9 server and running it 
from there.

There are few online forums with posts regarding similar problems, which mostly 
refer to var scoping variables in functions, or are looking at object creation.

I am seeking specific advice regarding what to do in this instance. Any gotcha, 
quick fixes, things to double check?


Unless explicitly attributed, the opinions expressed in this email are those of 
the author only and do not represent the official view of Hunter New England 
Local Health District nor the New South Wales Government..


-- 
You received this message because you are subscribed to the Google Groups 
"cfaussie" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cfaussie+unsubscr...@googlegroups.com.
To post to this group, send email to cfaussie@googlegroups.com.
Visit 

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

[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 database to be certain it actually should return 
some rows?   And that there's no syntax errors or anything like that in the 
query itself?  It's possible that your CFQuery is correctly returning no 
rows.

Cheers,
Mike Kear
Windsor, NSW, Australia
AFP Webworks.

On Fri, Nov 4, 2016 at 1:16 AM, Hanswurst Globobrüll 
mailto:rm.onlineumfra...@gmail.com>> wrote:
I had exactly the same problem in CF8, CF9 und also CF11.
Out team was analyzing and examining for days (!) - because the problem was not 
repleatable on purpose. It just occured sometimes and we found evidence in log 
files.
and finally we found out that the problem is the database. we use mysql, and 
when mysql (under huge load) creates deadlocks and a single request just times 
out, the 
select sb_invoice.sb_invoice_id, sb_invoice.sb_reminder_date, 
max(sb_claim_date) as sb_claim_date
from sb_invoice
inner join sb_invoice_item
on sb_invoice.sb_invoice_id = sb_invoice_item.sb_invoice_id
inner join sb_item_claim
on sb_invoice_item.sb_invoice_item_id = 
sb_item_claim.sb_invoice_item_id
where sb_invoice.sb_bill_mech_code in 
('M','F','AG','SC','MB','MO')
and sb_invoice_item.sb_item_status_code in ('21','24','31')
group by sb_invoice.sb_invoice_id, sb_invoice.sb_reminder_date
having sb_invoice.sb_reminder_date < 
DateAdd(d,30,max(sb_claim_date))







update sb_invoice
set sb_reminder_date = 

where sb_invoice_id = 







I have changed the name of the query to a few different values, I have used 
cfloop instead of cfoutput, I added the cfif.recordcount to see if that helped, 
to no avail. Without the CFIF the error was :
Attribute validation error for tag cfoutput.



The value of the attribute query, which is currently fix_this, is invalid.



Debug output shows that the query executed in 922ms and returned no rows.

What am I missing?

--
You received this message because you are subscribed to the Google Groups 
"cfaussie" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to 
cfaussie+unsubscr...@googlegroups.com.
To post to this group, send email to 
cfaussie@googlegroups.com.
Visit this group at https://groups.google.com/group/cfaussie.
For more options, visit https://groups.google.com/d/optout.



--
Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from 
AUD$15/month
--
You received this message because you are subscribed to the Google Groups 
"cfaussie" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to 
cfaussie+unsubscr...@googlegroups.com.
To post to this group, send email to 
cfaussie@googlegroups.com.
Visit this group at https://groups.google.com/group/cfaussie.
For more options, visit https://groups.google.com/d/optout.
Unless explicitly attributed, the opinions expressed in this email are those of 
the author only and do not represent the official view of Hunter New England 
Local Health District nor the New South Wales Government.

-- 
You received this message because you are subscribed to the Google Groups 
"cfaussie" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cfaussie+unsubscr...@googlegroups.com.
To post to this group, send email to cfaussie@googlegroups.com.
Visit this group at https://groups.google.com/group/cfaussie.
For more options, visit https://groups.google.com/d/optout.

RE: [cfaussie] Update to CF 9.0.2

[Scott Thornton]

Hi Charlie,

Thanks for the dropbox link. I was able to grab the 64bit installer for 9.0.2 
from dropbox. Oddly the 9.0.2 files in the copy.com website seemed to be 
absent, or not accessible ( everything else was present it seemed, when 
accessed from home internet access ). No problem though, dropbox worked just 
fine.

I have seen information regarding the requirement to do a full new install, 
after removing 9.0.1. As it’s a multi-server install, I was going to request 
some assistance from another colleague here to assist with it ( he did the 
original setup ). BUT, since you mention it, since 9.0.2 is 9.0.1 with Verity 
removed, I think I may just go with Cumulative hot fix 4 for this particular 
server ( and use 9.0.2 elsewhere ). I was really just after a fix for the 
scheduled task date format problem ( fixed in update 1 ).

Thank you again for you very informative,  complete assistance.

( And thanks to Mike K for offering to supply the 9.0.2 update ).


From: cfaussie@googlegroups.com<mailto:cfaussie@googlegroups.com> 
[mailto:cfaussie@googlegroups.com] On Behalf Of Charlie Arehart
Sent: Wednesday, 16 March 2016 1:29 AM
To: cfaussie@googlegroups.com<mailto:cfaussie@googlegroups.com>
Subject: RE: [cfaussie] Update to CF 9.0.2

Hi, Scott. Three things (the first and third are most important for you).

First, sadly, that copy.com site does often break, and Gavin (the guy behind 
the repo) is aware and is moving to dropbox. For some reason, he has not 
updated the site to point to that new repo. It’s:

https://www.dropbox.com/sh/8guq4gssov58ufy/AABm5NTljeQ-9XK2TdylM8hoa?dl=0

And it does have the 902 installers there.

Second, as for not finding them on the Adobe site, well, you may know that 
can’t even find CF11 installers on the site anymore, since they released CF2016 
last month. Many of us lament that (loudly), but it seems a corporate decision 
out of the hands of the CF team.

Third and finally, sine you propose you “Have Enterprise 9.0.1, and would like 
to go to 9.0.2”, do beware that 902 is NOT an updater to 9 or 901. It’s a 
separate installer. You would need to REMOVE your current 901 to get to 902. 
And there’s little reason to do that. All 902 is, is 901 with Verity removed, 
and some of the updates available at that time applied. You could (and should) 
just apply the latest Cumulative Hotfix for 901, and you’d almost be done. That 
last CHF included the latest security updates at the time, but there were a 
couple more since then.)

I do realize, also, that it’s tempting to want to go to 902 to “have it with 
the latest updates installed”. Then again, it too had a CHF and some security 
fixes after it came out.

And I realize also that applying updates in 9 was a pain. As you may know, 
there’s Dave Epler’s “unofficial updater” tool to help with that.

I have several posts that could help with all this:

http://www.carehart.org/blog/client/index.cfm/2013/8/19/understanding_ColdFusion_9.0.2_a_FAQ
http://www.carehart.org/blog/client/index.cfm/2014/3/14/cf9_and_earlier_hotfix_guide
http://www.carehart.org/blog/client/index.cfm/2011/10/21/why_chfs_may_break

Hope all that’s helpful. And of course, if you get stuck and/or want direct 
assistance, I can do that with you, remotely. More at the consulting 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] Update to CF 9.0.2

HI Mike,

I have checked the Windows server and it is indeed 64bit. The coldfusion admin 
also shows the  Java VM Name as Java HotSpot(TM) 64-Bit Server VM, so I 
guess I need the 64 bit version.

Dmitry,

I checked the link again, and it still doesn’t work for me. I work in health, 
and our firewall is pretty locked down, so the website might be being blocked 
on our end.

All,
I think what I will need to do is attempt to grab the file when I am at home 
tonight and bring it back into work tomorrow. I will send an update tomorrow.

Thanks for assistance.
--
You received this message because you are subscribed to the Google Groups 
"cfaussie" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to 
cfaussie+unsubscr...@googlegroups.com<mailto:cfaussie+unsubscr...@googlegroups.com>.
To post to this group, send email to 
cfaussie@googlegroups.com<mailto:cfaussie@googlegroups.com>.
Visit this group at https://groups.google.com/group/cfaussie.
For more options, visit https://groups.google.com/d/optout.

-- 
You received this message because you are subscribed to the Google Groups 
"cfaussie" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cfaussie+unsubscr...@googlegroups.com.
To post to this group, send email to cfaussie@googlegroups.com.
Visit this gro

RE: [cfaussie] Update to CF 9.0.2

[Scott Thornton]

HI Mike,

I have checked the Windows server and it is indeed 64bit. The coldfusion admin 
also shows the  Java VM Name as Java HotSpot(TM) 64-Bit Server VM, so I 
guess I need the 64 bit version.

Dmitry,

I checked the link again, and it still doesn’t work for me. I work in health, 
and our firewall is pretty locked down, so the website might be being blocked 
on our end.

All,
I think what I will need to do is attempt to grab the file when I am at home 
tonight and bring it back into work tomorrow. I will send an update tomorrow.

Thanks for assistance.

From: cfaussie@googlegroups.com [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>>
 wrote:
Hi,

Have Enterprise 9.0.1, and would like to go to 9.0.2

Cannot locate the installer in the adobe website.

The page 
https://helpx.adobe.com/coldfusion/release-note/coldfusion-9-0-update-2.html 
eventually leads to a page for downloading hot fixes.

I have seen previously a link to http://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

--
Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
--
You received this message because you are subscribed to the Google Groups 
"cfaussie" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to 
cfaussie+unsubscr...@googlegroups.com<mailto:cfaussie+unsubscr...@googlegroups.com>.
To post to this group, send email to 
cfaussie@googlegroups.com<mailto:cfaussie@googlegroups.com>.
Visit this group at https://groups.google.com/group/cfaussie.
For more options, visit https://groups.google.com/d/optout.

-- 
You received this message because you are subscribed to the Google Groups 
"cfaussie" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cfaussie+unsubscr...@googlegroups.com.
To post to this group, send email to cfaussie@googlegroups.com.
Visit this group at https://groups.google.com/group/cfaussie.
For more options, visit https://groups.google.com/d/optout.

[cfaussie] Update to CF 9.0.2

[Scott Thornton]

Hi,

Have Enterprise 9.0.1, and would like to go to 9.0.2

Cannot locate the installer in the adobe website.

The page 
https://helpx.adobe.com/coldfusion/release-note/coldfusion-9-0-update-2.html 
eventually leads to a page for downloading hot fixes.

I have seen previously a link to http://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 you are subscribed to the Google Groups 
"cfaussie" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cfaussie+unsubscr...@googlegroups.com.
To post to this group, send email to cfaussie@googlegroups.com.
Visit this group at https://groups.google.com/group/cfaussie.
For more options, visit https://groups.google.com/d/optout.

RE: [cfaussie] Using CF Report Builder

[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 
option, sorry ).

Good luck.

From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of 
rai...@ozemail.com.au
Sent: Thursday, 24 July 2014 5:08 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Using CF Report Builder

Hi

I am using CF report builder to build invoices

The challenge I have is that some of the items in the invoice may have 
supporting comments to be displayed under each invoice items

Sometimes there will be no comments other times there will be comments that 
could be 1 line long or potentially 20 lines long

The challenge I find is that if I create the text box that is big enough to 
display the let's say 20 line comment then that space exists under every other 
item regardless of whether it's a 20 line comment or 0 or 1 or 2 line comment

What I am trying to achieve is to have the items flow on the page so when there 
is comments the necessary space is provided under invoice line item and when 
there is no comments then the next invoice item appear directly under the 
previous item without any additional blank lines

Any advice re the above would be appreciated

Regards

Claude Raiola
SAMARIS Software
--
You received this message because you are subscribed to the Google Groups 
"cfaussie" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to 
cfaussie+unsubscr...@googlegroups.com.
To post to this group, send email to 
cfaussie@googlegroups.com.
Visit this group at http://groups.google.com/group/cfaussie.
For more options, visit https://groups.google.com/d/optout.

-- 
You received this message because you are subscribed to the Google Groups 
"cfaussie" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cfaussie+unsubscr...@googlegroups.com.
To post to this group, send email to cfaussie@googlegroups.com.
Visit this group at http://groups.google.com/group/cfaussie.
For more options, visit https://groups.google.com/d/optout.

RE: [cfaussie] Unable to read WSDL from URL

[Scott Thornton]

HI All,

I removed the use of the virtual directory and my example now works. The 
reported bug using CFC's and virtual directory exists as far back as version 9 
(which I am working on locally, not tested cfinvoke on cf6.1 as yet).

I had seen the bug report prior to Dmitry posting, but wasn't sure if it was an 
avenue I had to explore.

Thank you very much for all replies!

From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of 
Charlie Arehart
Sent: Saturday, 12 July 2014 1:52 AM
To: cfaussie@googlegroups.com
Subject: RE: [cfaussie] Unable to read WSDL from URL

That sounds like the good call, Dmitry.

Scott, you had opened saying that you were using a virtual directory in IIS. 
Can you change it to not be one and see if it helps? (Even though the bug 
report he refers to is for CF10, I would not be surprised if the problem went 
back to your CF 6.1.)

Also, Scott, your last message showing use of createobject indicated that you 
had gotten a 404 on the wsdl URL. The problem was that you left off the .cfc in 
the URL. So:

test = 
createObject("webservice","http://localhost/login/NTLoginService?wsdl";).loginUserNT(NTusername='username',
 NTpassword='pwd', NTdomainz='domain');

should have been instead:

test = 
createObject("webservice","http://localhost/login/NTLoginService.cfc?wsdl";).loginUserNT(NTusername='username',
 NTpassword='pwd', NTdomainz='domain');

(When you're calling a component, you don't put the .cfc, so it's easy to get 
tripped up on that.)

Finally, while you can chain methods on the createobject, note that you don't 
need to do that. And there can be advantages to NOT doing it, especially if you 
would need to call more than one method. You may already know that. Just wanted 
to point it out in case you go with that alternative approach. So you could do 
it this way, for instance:

ntlogin= 
createObject("webservice","http://localhost/login/NTLoginService.cfc?wsdl";).loginUserNT(NTusername='username',
 NTpassword='pwd', NTdomainz='domain');
test = ntlogin.loginUserNT(NTusername='username', NTpassword='pwd', 
NTdomainz='domain');
test2 = ntlogin.callsomeothermethod;

Hope that helps.

/charlie

From: 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,

This seems to be a well known bug:

https://bugbase.adobe.com/index.cfm?event=bug&id=3531653
https://forums.adobe.com/message/5207697

Cheers,
Dmitry,

On 10/07/2014 10:37 AM, Scott Thornton wrote:
Hi,

I am working with webservices for the first time, and my knowledge is very 
rudimentary.

Scenario:


--
You received this message because you are subscribed to the Google Groups 
"cfaussie" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to 
cfaussie+unsubscr...@googlegroups.com<mailto:cfaussie+unsubscr...@googlegroups.com>.
To post to this group, send email to 
cfaussie@googlegroups.com<mailto:cfaussie@googlegroups.com>.
Visit this group at http://groups.google.com/group/cfaussie.
For more options, visit https://groups.google.com/d/optout.

-- 
You received this message because you are subscribed to the Google Groups 
"cfaussie" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cfaussie+unsubscr...@googlegroups.com.
To post to this group, send email to cfaussie@googlegroups.com.
Visit this group at http://groups.google.com/group/cfaussie.
For more options, visit https://groups.google.com/d/optout.

RE: [cfaussie] Unable to read WSDL from URL

[Scott Thornton]

HI,


test = 
createObject("webservice","http://localhost/login/NTLoginService";).loginUserNT(NTusername='username',
 NTpassword='pwd', NTdomainz='domain');


Returns
Unable to read WSDL from URL: http://localhost/login/NTLoginService.

test = 
createObject("webservice","http://localhost/login/NTLoginService?wsdl";).loginUserNT(NTusername='username',
 NTpassword='pwd', NTdomainz='domain');


Returns:


Unable to read WSDL from URL: http://localhost/login/NTLoginService?wsdl.


Error: 404 Not Found.



When I try without the parameters being within text quotes, I get a different 
error again.

So I would say no, at this point in time.


From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of 
Andrew Scott
Sent: Thursday, 10 July 2014 3:39 PM
To: cfaussie@googlegroups.com
Subject: Re: [cfaussie] Unable to read WSDL from URL

Just out of curiosity if you switch from cfinvoke to create object does it 
suffer the same thing?

like

test = 
createObject("webservice","http://localhost/login/NTLoginService";).<http://localhost/login/NTLoginService.cfc?wsdl>loginUserNT(NTusername=test,
 NTpassword=testpassword, NTdomainz=testdomain);

Does that work or has the same problem?


Regards,
Andrew Scott
WebSite: http://www.andyscott.id.au<http://www.andyscott.id.au>/
Google+:  http://plus.google.com/113032480415921517411


On Thu, Jul 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.id.au<http://www.andyscott.id.au>/
Google+:  http://plus.google.com/113032480415921517411


On Thu, Jul 10, 2014 at 3:29 PM, Scott Thornton 
mailto:scott.thorn...@hnehealth.nsw.gov.au>>
 wrote:
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? ( and can be used from CF6 ? )

This example mentions support for it was added in cf10.

http://www.adobe.com/devnet/coldfusion/articles/restful-web-services.html

Thanks very much for your assistance Andrew.


PS: I am still stuck on CF6.1 since the server it is on still runs Windows 
Server 2000 which was about the last version of windows my Crystal reports .asp 
  SDK runs on. Which is a different issue all together.



From: cfaussie@googlegroups.com<mailto:cfaussie@googlegroups.com> 
[mailto:cfaussie@googlegroups.com<mailto:cfaussie@googlegroups.com>] On Behalf 
Of Andrew Scott
Sent: Thursday, 10 July 2014 3:15 PM

To: cfaussie@googlegroups.com<mailto:cfaussie@googlegroups.com>
Subject: Re: [cfaussie] Unable to read WSDL from URL

What happens if you try to invoke the CFC via the URL and not as a webservice?

For example what does this do in the browser?

http://localhost/login/NTLoginService.cfc?<http://localhost/login/NTLoginService.cfc?wsdl>method=loginUserNT&NTusername=test&NTpassword=testpassword&NTdomainz=testdomain

Could that be throwing an error that the invoke is masking?

But seriously, move away from webservices they actually suck in ColdFusion and 
is why people prefer RestFul.
--
You received this message because you are subscribed to the Google Groups 
"cfaussie" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to 
cfaussie+unsubscr...@googlegroups.com<mailto:cfaussie+unsubscr...@googlegroups.com>.
To post to this group, send email to 
cfaussie@googlegroups.com<mailto:cfaussie@googlegroups.com>.
Visit this group at http://groups.google.com/group/cfaussie.
For more options, visit https://groups.google.com/d/optout.


--
You received this message because you are subscribed to the Google Groups 
"cfaussie" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to 
cfaussie+unsubscr...@googlegroups.com<mailto:cfaussie+unsubscr...@googlegroups.com>.
To post to this group, send email to 
cfaussie@googlegroups.com<mailto:cfaussie@googlegroups.com>.
Visit this group at http://groups.google.com/group/cfaussie.
For more options, visit https://groups.google.com/d/optout.

-- 
You received this message because you are subscribed to the Google Groups 
"cfaussie" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cfaussie+unsubscr...@googlegroups.com.
To post to this group, send email to cfaussie@googlegroups.com.
Visit this group at http://groups.google.com/group/cfaussie.
For more options, visit https://groups.google.com/d/optout.

RE: [cfaussie] Unable to read WSDL from URL

[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? ( and can be used from CF6 ? )

This example mentions support for it was added in cf10.

http://www.adobe.com/devnet/coldfusion/articles/restful-web-services.html

Thanks very much for your assistance Andrew.


PS: I am still stuck on CF6.1 since the server it is on still runs Windows 
Server 2000 which was about the last version of windows my Crystal reports .asp 
  SDK runs on. Which is a different issue all together.



From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of 
Andrew Scott
Sent: Thursday, 10 July 2014 3:15 PM
To: cfaussie@googlegroups.com
Subject: Re: [cfaussie] Unable to read WSDL from URL

What happens if you try to invoke the CFC via the URL and not as a webservice?

For example what does this do in the browser?

http://localhost/login/NTLoginService.cfc?method=loginUserNT&NTusername=test&NTpassword=testpassword&NTdomainz=testdomain

Could that be throwing an error that the invoke is masking?

But seriously, move away from webservices they actually suck in ColdFusion and 
is why people prefer RestFul.

-- 
You received this message because you are subscribed to the Google Groups 
"cfaussie" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cfaussie+unsubscr...@googlegroups.com.
To post to this group, send email to cfaussie@googlegroups.com.
Visit this group at http://groups.google.com/group/cfaussie.
For more options, visit https://groups.google.com/d/optout.

RE: [cfaussie] Unable to read WSDL from URL

[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"
returnvariable="authUser"
refreshWSDL="yes">








coldfusion.jsp.CompilationFailedException: Errors reported by Java compiler: 
Found 5 semantic errors compiling 
"C:/ColdFusion9/stubs/WS854518475/login/NTLoginServiceLocator.java": 10. public 
class NTLoginServiceLocator extends org.apache.axis.client.Service implements 
login.NTLoginService { 
^--^
 *** Semantic Error: The checked exception "RemoteException" is not assignable 
to any exception in the throws clause of the accessible method 
"javax.xml.rpc.Call createCall() throws javax.xml.rpc.ServiceException;" 
declared in type "javax.xml.rpc.Service". 10. public class 
NTLoginServiceLocator extends org.apache.axis.client.Service implements 
login.NTLoginService { 
^--^
 *** Semantic Error: The method "org.apache.axis.client.Call createCall() 
throws java.rmi.RemoteException;" with protected access cannot replace the 
accessible method "javax.xml.rpc.Call createCall() th






WSDL:


http://www.w3.org/2001/XMLSchema"; 
xmlns:wsdlsoap="http://schemas.xmlsoap.org/wsdl/soap/"; 
xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/"; 
xmlns:tns1="http://rpc.xml.coldfusion"; 
xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/"; 
xmlns:intf="http://login"; xmlns:impl="http://login"; 
xmlns:apachesoap="http://xml.apache.org/xml-soap"; 
targetNamespace="http://login";>

http://xml.apache.org/xml-soap"; 
xmlns="http://www.w3.org/2001/XMLSchema";>http://rpc.xml.coldfusion"/>http://login"/>http://schemas.xmlsoap.org/soap/encoding/"/>http://rpc.xml.coldfusion"; 
xmlns="http://www.w3.org/2001/XMLSchema";>http://xml.apache.org/xml-soap"/>http://login"/>http://schemas.xmlsoap.org/soap/encoding/"/>http://login"; 
xmlns="http://www.w3.org/2001/XMLSchema";>http://xml.apache.org/xml-soap"/>http://rpc.xml.coldfusion"/>http://schemas.xmlsoap.org/soap/encoding/"/>http://schemas.xmlsoap.org/soap/http"; style="rpc"/>http://login"; use="encoded" 
encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"/>http://login"; use="encoded" 
encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"/>http://login"; name="CFCInvocationException" use="encoded" 
encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"/>http://schemas.xmlsoap.org/wsdl/";>Provides NT Domain Authentication 
http://localhost/login/NTLoginService.cfc"/>

From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of 
Andrew Scott
Sent: Thursday, 10 July 2014 2:57 PM
To: cfaussie@googlegroups.com
Subject: Re: [cfaussie] Unable to read WSDL from URL

Actually come to think of it.. Have you also tried this, during development if 
the component is being changed, you also need to clear the stubs. I don't 
recall it being that exact error, but a quick Google has made the exact same 
suggestions.

Reference:
http://jeffcoughlin.com/blog/index.cfm/2006/2/27/Using-CF7-SOAP-and-soapexamplecfc
http://www.michaels.me.uk/post.cfm/coldfusion-web-services-an

RE: [cfaussie] Unable to read WSDL from URL

[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

Yes, but you also need to look at this setting in ColdFusion. If this is not 
ticked it will only send a 404 or 500 status code, during development this 
really should be a setting that you switch on.

Enable HTTP status codes
Enables ColdFusion to set HTTP error status codes when ColdFusion errors are 
returned to the browser. ColdFusion sets an error status code of 404 if the 
template is not found and an error status code of 500 for server errors.

Regards,
Andrew Scott
WebSite: http://www.andyscott.id.au/
Google+:  http://plus.google.com/113032480415921517411

-- 
You received this message because you are subscribed to the Google Groups 
"cfaussie" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cfaussie+unsubscr...@googlegroups.com.
To post to this group, send email to cfaussie@googlegroups.com.
Visit this group at http://groups.google.com/group/cfaussie.
For more options, visit https://groups.google.com/d/optout.

RE: [cfaussie] Unable to read WSDL from URL

[Scott Thornton]

Hi

@Charlie,

>From coldfusion-out.log:

07/10 14:15:29 Information [jrpp-0] - Starting Web service request.
07/10 14:15:29 Information [jrpp-0] - Creating Web service proxy 
{url='http://localhost/login/NTLoginService.cfc?wsdl'}
07/10 14:15:31 Error [jrpp-0] - coldfusion.jsp.CompilationFailedException: 
Errors reported by Java compiler:  Found 5 semantic errors compiling 
""C:/ColdFusion9/stubs/WS854518475/login/NTLoginServiceLocator.java"":  10. 
public class NTLoginServiceLocator extends org.apache.axis.client.Service 
implements login.NTLoginService {  
^--^
 *** Semantic Error: The checked exception ""RemoteException"" is not 
assignable to any exception in the throws clause of the accessible method 
""javax.xml.rpc.Call createCall() throws javax.xml.rpc.ServiceException;"" 
declared in type ""javax.xml.rpc.Service"".   10. public class 
NTLoginServiceLocator extends org.apache.axis.client.Service implements 
login.NTLoginService {  
^--^
 *** Semantic Error: The method ""org.apache.axis.client.Call createCall() 
throws java.rmi.RemoteException;"" with protected ac... The specific sequence 
of files included or processed is: C:\websites\login\login_act.cfm, line: 17

Which refers to:




User Submitted Username #form.username#, password 
#form.password#

http://localhost/login/NTLoginService.cfc?wsdl";
method="loginUserNT"
returnvariable="authUser"
refreshWSDL="yes">







Where line 17 is 

Please note that I changed the name of the 3rd param to NTdomainz since I first 
posted, as I was thinking that NTDomain may have been a reserved word.

@Andrew

Enable Robust Exception Information is selected in CF Admin, and within IE Show 
friendly HTTP error messages is unticked. ( I assume this is what you are 
referring too).

Thanks,

From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of 
Charlie Arehart
Sent: Thursday, 10 July 2014 12:15 PM
To: cfaussie@googlegroups.com
Subject: RE: [cfaussie] Unable to read WSDL from URL

You may want to look at the coldfusion-out.log (in \coldfusion9\runtime\logs or 
jrun4\logs) to see 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:cfaussie@googlegroups.com>
Subject: [cfaussie] Unable to read WSDL from URL

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 to 
provide authentication.

So, working locally at present on CF9...

My NTLoginService.cfc looks like :
















I hope to return the result of the cfntauthenticate call.

I can browse the cfc via URL  http://localhost/login/NTLoginService.cfc and see 
the methods\parameters okay.

But if I browse to http://localhost/login/NTLoginService.cfc?wsdl

I receive the error:

AXIS error
Sorry, something seems to have gone wrong... here are the details:
Fault - Error attempting to create Java skeleton for CFC web service.; nested 
exception is:
coldfusion.xml.rpc.CFCInvocationException: 
[java.lang.NullPointerException : null]
AxisFault
faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.generalException
faultSubcode:
 faultString: Error attempting to create Java skeleton for CFC web service.; 
nested exception is:
coldfusion.xml.rpc.CFCInvocationException: 
[java.lang.NullPointerException : null]
faultActor:
 faultNode:
 faultDetail:
{http://xml.apache.org/axis/}hostname:WSHBILL032

If I try to invoke the webservice with :

http://localhost/login/NTLoginService.cfc?wsdl";
method="loginUserNT"
returnvariable="authentication"
refreshWSDL="yes">


 

[cfaussie] Unable to read WSDL from URL

[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 to 
provide authentication.

So, working locally at present on CF9...

My NTLoginService.cfc looks like :
















I hope to return the result of the cfntauthenticate call.

I can browse the cfc via URL  http://localhost/login/NTLoginService.cfc and see 
the methods\parameters okay.

But if I browse to http://localhost/login/NTLoginService.cfc?wsdl

I receive the error:

AXIS error
Sorry, something seems to have gone wrong... here are the details:
Fault - Error attempting to create Java skeleton for CFC web service.; nested 
exception is:
coldfusion.xml.rpc.CFCInvocationException: 
[java.lang.NullPointerException : null]

AxisFault
faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.generalException
faultSubcode:
 faultString: Error attempting to create Java skeleton for CFC web service.; 
nested exception is:
coldfusion.xml.rpc.CFCInvocationException: 
[java.lang.NullPointerException : null]
faultActor:
 faultNode:
 faultDetail:
{http://xml.apache.org/axis/}hostname:WSHBILL032

If I try to invoke the webservice with :

http://localhost/login/NTLoginService.cfc?wsdl";
method="loginUserNT"
returnvariable="authentication"
refreshWSDL="yes">







I receive the error:

Unable to read WSDL from URL: http://localhost/login/NTLoginService.cfc?wsdl.


Error: 500 Internal Server Error.


http://localhost/login/ is a IIS virtual directory that points to 
c:\websites\login\

I have restarted the local CF server multiple times.

I wouldn't be surprised if I have missed something simple.

Would any one have any ideas on what to do next? Googling hasn't been very 
informative.

Thanks for any assistance.

-- 
You received this message because you are subscribed to the Google Groups 
"cfaussie" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cfaussie+unsubscr...@googlegroups.com.
To post to this group, send email to cfaussie@googlegroups.com.
Visit this group at http://groups.google.com/group/cfaussie.
For more options, visit https://groups.google.com/d/optout.

RE: [cfaussie] Dynamic Data source

[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.


















etc





-- 
You received this message because you are subscribed to the Google Groups 
"cfaussie" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cfaussie+unsubscr...@googlegroups.com.
To post to this group, send email to cfaussie@googlegroups.com.
Visit this group at http://groups.google.com/group/cfaussie.
For more options, visit https://groups.google.com/d/optout.

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

[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: [Macromedia][SQLServer JDBC 
Driver][Macromedia][SQLServer JDBC Driver]The requested instance is either 
invalid or not running. at 
macromedia.jdbc.base.BaseExceptions.createException(Unknown Source) at 
macromedia.jdbc.base.BaseExceptions.getException(Unknown Source) at 
macromedia.jdbc.sqlserver.tds.TDSConnection.(Unknown Source) at 
macromedia.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source) at 
macromedia.jdbc.base.BaseConnection.connect(Unknown Source) at 
macromedia.jdbc.base.BaseConnection.setupImplConnection(Unknown Source) at 
macromedia.jdbc.base.BaseConnection.open(Unknown Source) at 
macromedia.jdbc.base.BaseDriver.connect(Unknown Source) at 
macromedia.jdbc.MacromediaDriver.connect(Unknown Source) at 
coldfusion.server.j2ee.sql.pool.JDBCPool.createPhysicalConnection(JDBCPool.java:559)
 at 
coldfusion.server.j2ee.sql.pool.ConnectionRunner$RunnableConnection.run(ConnectionRunner.java:64)
 at java.lang.Thread.run(Thread.java:534)

The queries that I have seen fail are quite simple ones, and are often not even 
the first on the .cfm page.

I use the Microsoft SQL option on my DSN. The database is on a named instance. 
e.g.: Server\InstanceName

The @@version of the MS SQL 2012 server is:

Microsoft SQL Server 2012 (SP1) - 11.0.3349.0 (X64)   Mar  8 2013 17:33:56   
Copyright (c) Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 
6.1  (Build 7601: Service Pack 1)

There are no obvious errors reported\logged on the SQL server itself, so I can 
only assume it might be some sort of jdbc driver problem.

The following code returns my JDBC version 3.40


#jdbcDriver.getMajorVersion()#.#jdbcDriver.getMinorVersion()#


Given the age of CFMX6.1, I don't know quite where to start, and many websites 
detailing potential solutions to this error are very out-dated.

Can anyone shed any light on the problem or offer solutions?

Thanks, Scott.

-- 
You received this message because you are subscribed to the Google Groups 
"cfaussie" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cfaussie+unsubscr...@googlegroups.com.
To post to this group, send email to cfaussie@googlegroups.com.
Visit this group at http://groups.google.com/group/cfaussie.
For more options, visit https://groups.google.com/groups/opt_out.

RE: [cfaussie] Re: Debugging problem on cf9

[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 out..

From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of 
Carl
Sent: Thursday, 4 October 2012 2:08 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Debugging problem on cf9

Hi Joel,

CF9.0.2 has security bulletin APSB12-15 installed as released.

For details on APSB12-15 refer to here:

http://helpx.adobe.com/coldfusion/kb/coldfusion-security-hotfix-apsb12-15.html

Perhaps you need to adjust postParametersLimit setting described in APSB12-15 
reference from 100 to something bigger (do your own testing eg 500, 1000) via 
editing CF9\lib\neo-runtime.xml plus restart CF9 application service.

Interestingly CF10 has postParametersLimit setting in CFadmin > Server Settings 
> Settings.

Regards, Carl.

On Thursday, 4 October 2012 11:50:33 UTC+10, Joel Caldwell wrote:
Hi,

I'm experiencing a problem whereby when a form is submitted I immediately 
receive an IIS HTTP error 500.0 Internal Server Error.

Another developed here using cf 9.0.1.274733 is able to run the page without 
any errors.

I'm using ColdFusion Server Developer

9,0,2,282541



Any suggestions?

Thanks

Joel Caldwell
--
You received this message because you are subscribed to the Google Groups 
"cfaussie" group.
To view this discussion on the web visit 
https://groups.google.com/d/msg/cfaussie/-/LXKmvJu-03sJ.
To post to this group, send email to cfaussie@googlegroups.com.
To unsubscribe from this group, send email to 
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

-- 
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 
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

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

[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... but since it is a java based 
webserver, I think there exists the potential that it *should* be able to do it.

I appear to be able to open reports in the viewer when my .jsp page  runs 
locally on a Tomcat webserver, however the same .jsp executed by CF 9 jrun 
server fails.

a little example code:::

<%@ page contentType="text/html; charset=UTF-8" pageEncoding="ISO-8859-1" %>
<%@ page import="
com.crystaldecisions.report.web.viewer.CrystalReportViewer,
com.crystaldecisions.sdk.occa.report.application.OpenReportOptions,
com.crystaldecisions.sdk.occa.report.application.ReportClientDocument,
com.crystaldecisions.sdk.occa.report.lib.ReportSDKExceptionBase" %>
<%
// This sample code calls methods from the CRJavaHelper class, 
which
// contains examples of how to use the BusinessObjects APIs. 
You are free to
// modify and distribute the source code contained in the 
CRJavaHelper class.

try {

String reportName = "test_params.rpt";

ReportClientDocument clientDoc = new 
ReportClientDocument();

out.println(ReportClientDocument.inprocConnectionString);

clientDoc.setReportAppServer(ReportClientDocument.inprocConnectionString);

// Open report
//clientDoc.open(reportName, 
OpenReportOptions._openAsReadOnly);

// lots of code cut out here


} catch (ReportSDKExceptionBase e) {
out.println(e);
}

%>

returns::

500
Translator.CompilationFailedExceptionCompiler errors:
Found 2 semantic errors compiling 
"C:/ColdFusion9/wwwroot/WEB-INF/jsp/jrun__reporttest__callReport22ejsp1a.java":

66. 
clientDoc.setReportAppServer(ReportClientDocument.inprocConnectionString);
  ^^
*** Semantic Error: The class file "ClonableMap.class" in 
"C:\ColdFusion9\wwwroot\WEB-INF\lib\CrystalReportsRuntime.jar\com\crystaldecisions\sdk\occa\report\lib"
 has an invalid format (duplicate local variable type table).


66. 
clientDoc.setReportAppServer(ReportClientDocument.inprocConnectionString);
  ^^
*** Semantic Error: The class file "ControllableList.class" in 
"C:\ColdFusion9\wwwroot\WEB-INF\lib\CrystalReportsRuntime.jar\com\crystaldecisions\sdk\occa\report\lib"
 has an invalid format (duplicate local variable type table).



javax.servlet.ServletException: Translator.CompilationFailedExceptionCompiler 
errors:
Found 2 semantic errors compiling 
"C:/ColdFusion9/wwwroot/WEB-INF/jsp/jrun__reporttest__callReport22ejsp1a.java":

66. 
clientDoc.setReportAppServer(ReportClientDocument.inprocConnectionString);
  ^^
*** Semantic Error: The class file "ClonableMap.class" in 
"C:\ColdFusion9\wwwroot\WEB-INF\lib\CrystalReportsRuntime.jar\com\crystaldecisions\sdk\occa\report\lib"
 has an invalid format (duplicate local variable type table).


66. 
clientDoc.setReportAppServer(ReportClientDocument.inprocConnectionString);
  ^^
*** Semantic Error: The class file "ControllableList.class" in 
"C:\ColdFusion9\wwwroot\WEB-INF\lib\CrystalReportsRuntime.jar\com\crystaldecisions\sdk\occa\report\lib"
 has an invalid format (duplicate local variable type table).

at jrun.jsp.Translator.compilePage(Translator.java:187)
at jrun.jsp.Translator.translate(Translator.java:254)
at jrun.jsp.Translator.translate(Translator.java:101)
at jrun.jsp.JSPEngine.translateJSP(JSPEngine.java:709)
at jrun.jsp.JSPServlet.translate(JSPServlet.java:125)
at jrun.jsp.JSPServlet.service(JSPServlet.java:113)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
at 
jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at 
jrun.servlet.JRunRequestDispatcher.invokeNext(JRunRequestDispatcher.java:586)
at 
jrun.servlet.JRunRequestDispatcher.forwardInvoke(JRunRequestDispatcher.java:555)
at 
jrun.servlet.JRunNamedDispatcher.forward(JRunNamedDispatcher.java:64)
at coldfusion.license.JspLicenseServlet.service(Unknown Source)
at 
coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:10

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

[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 individual site assets and 
their corresponding download times.

Thanks for your input, and the reminder.

From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of 
Josh Wines
Sent: Thursday, 5 April 2012 3:23 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: OT: Webpage download timing

Firebug is a great debugging tool that will give you that.

http://getfirebug.com/

Josh

On Thursday, April 5, 2012 3:15:17 PM UTC+10, Scott.thornton wrote:
G'Day,

Can anyone recommend any Firefox add-ons, or other programs, that will display 
the download time of a web page and its components eg .css\.js\.jpg files?

I am testing a CF 9 cluster, on a virtualised server, and while the CF debug 
shows the page renders quickly and queries complete in 10ms, the page is very 
slow to load and I was wondering if there were problems downloading the 
external files etc due to mapping problems or file access problems etc.

Cheers,


--
You received this message because you are subscribed to the Google Groups 
"cfaussie" group.
To view this discussion on the web visit 
https://groups.google.com/d/msg/cfaussie/-/C1JeNPWzjc4J.
To post to this group, send email to cfaussie@googlegroups.com.
To unsubscribe from this group, send email to 
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

-- 
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 
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

RE: [cfaussie] BarCode Generator with CF Report Builder

[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 represented as 
%0797613% which when displayed as a bar code, could be read by a bar code 
scanner .

You would need to install the font ( and there are free versions out there ) on 
your development machine  and I assume the CF server(s). Maybe your bar code 
scanners come with a font they prefer.

Cheers,



From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of 
rai...@ozemail.com.au
Sent: Wednesday, 21 March 2012 2:34 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] BarCode Generator with CF Report Builder

Hi,

I am building customer invoice templates using ColdFusion Report Builder and I 
am needing to have a bar code generated each time the invoice is generated from 
each customers unique reference number

If anyone can shed some light on the best way to achieve the above I would 
appreciate your suggestions

Regards

Claude Raiola (B.Econ Acc; B.Hot. Mngt)

--
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 
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

-- 
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 
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

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

[Scott Thornton]

G'Day,

the code original read:


select
..
from
…
group by
..
having
..




The error referred to 

The debug output was the generic query debug output you might see when 
debugging was turned on on the server, which gets displayed after the errors 
etc.

eg

SQL Queries
queryname (Datasource=datasourcename, Time=62ms, Records=0)

To test what was happening, I Used CFDUMP, eg:


select
..
from
…
group by
..
having
..





and the error moved to the 

The code is now running as expected though, I removed the CFLOOP and put back 
in CFOUTPUT and the error is no longer reproducable. It is as if nothing has 
happened at all and the page never had an error.

No server restart required I might add.

Thanks again.

From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of 
charlie arehart
Sent: Wednesday, 1 February 2012 3:53 PM
To: cfaussie@googlegroups.com
Subject: RE: [cfaussie] RE: Attribute validation error for tag cfoutput

Thanks for the kind regards, Scott. (Though I know that not everyone likes all 
the “detail” I offer. It’s an acquired taste!)

So about your results below, I’m curious: are you saying that you also placed a 
CFOUTPUT loop following the CFDUMP and that *did not* get an error this time? 
It’s just not clear, because you refer to “the debug output displayed below the 
error text”, but then you say “I can’t get the error to occur again”.

I press this point because it’s critical (for what I was trying to confirm) 
that you do BOTH the CFDUMP and THEN the CFOUTPUT loop in the same request. If 
the dump worked but then the CFOUTPUT loop did not, it would be vital to 
confirm then what the dump showed. Again, I have a suspicion of something that 
could be happening, but let’s the diagnostics tell us more before speculating. 
(Also, what version of CF are you running?)

Finally, are you saying you’re surprised that the query returned 0 records? 
That too is not clear. Of course, if a query had 0 records, a CFOUTPUT loop 
would not error but just do nothing, so I realize that’s no “the cause” of your 
error. We just can’t 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 cfoutput

Hi Charlie,

Thanks as always for your continued support of the CFAussie forum. I always 
appreaciate your replies.. they include so much detail!

I attempted to CFDUMP the query straight after the CFQUERY, and the attribute 
was not defined, which is very odd. Yes, I triple checked the name of the 
query, as I thought I must have made a mistake typing and ended up 
copy-and-pasting it :-)

However I could defintly see that the query had executed and had returned 0 
rows from the debug output displayed below the error text.

Odder still, I cant get the error to occur again this morning, despite the 
query returning 0 rows still.

I have put back in the cfoutput to try  and see if it happens again. I really 
hope I can replicate it someday.

Thanks again.


From: cfaussie@googlegroups.com<mailto:cfaussie@googlegroups.com> 
[mailto:cfaussie@googlegroups.com] On Behalf Of charlie arehart
Sent: Wednesday, 1 February 2012 3:03 AM
To: cfaussie@googlegroups.com<mailto:cfaussie@googlegroups.com>
Subject: RE: [cfaussie] RE: Attribute validation error for tag cfoutput

Hmm. You’re saying that a CFLOOP QUERY worked where a CFOUTPUT QUERY would not? 
That would indeed be curious.

If you’d still needed to (or want to) solve the mystery, I would have suggested 
doing a CFDUMP of the variable, to see what it said it was. Assuming that when 
you ran it, you still got an error referring to it (next) in a CFOUTPUT QUERY, 
it would be very strange if the CFOUTPUT QUERY failed where the CFDUMP showed 
that it was indeed a query.

Now, I press that point about making sure that the CFOUTPUT QUERY fails after 
the dump, because there is the possibility that it might work, which would 
suggest that there’s some other time when it fails, and it’s THEN that the 
CFDUMP would be most valuable. I could think of a number of scenarios where a 
variable might not have what it seems it should have. I won’t take your 
collective time speculating. But if you do get the error and do get a dump, and 
it is a query, let us know what you find. Again, that’s all if you want to 
press on. You may be happy to just leave it as a query loop.

/charlie

From: cfaussie@googlegroups.com<mailto:cfaussie@googlegroups.com> 
[mailto:cfaussie@googlegroups.com] On Behalf Of Scott Thornton
Sent: Monday, January 30, 2012 11:23 PM
To: cfaussie@googlegroups.com<mailto: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 ), 
and it works okay.
--
You received

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

[Scott Thornton]

Hi Charlie,

Thanks as always for your continued support of the CFAussie forum. I always 
appreaciate your replies.. they include so much detail!

I attempted to CFDUMP the query straight after the CFQUERY, and the attribute 
was not defined, which is very odd. Yes, I triple checked the name of the 
query, as I thought I must have made a mistake typing and ended up 
copy-and-pasting it :-)

However I could defintly see that the query had executed and had returned 0 
rows from the debug output displayed below the error text.

Odder still, I cant get the error to occur again this morning, despite the 
query returning 0 rows still.

I have put back in the cfoutput to try  and see if it happens again. I really 
hope I can replicate it someday.

Thanks again.


From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of 
charlie arehart
Sent: Wednesday, 1 February 2012 3:03 AM
To: cfaussie@googlegroups.com
Subject: RE: [cfaussie] RE: Attribute validation error for tag cfoutput

Hmm. You’re saying that a CFLOOP QUERY worked where a CFOUTPUT QUERY would not? 
That would indeed be curious.

If you’d still needed to (or want to) solve the mystery, I would have suggested 
doing a CFDUMP of the variable, to see what it said it was. Assuming that when 
you ran it, you still got an error referring to it (next) in a CFOUTPUT QUERY, 
it would be very strange if the CFOUTPUT QUERY failed where the CFDUMP showed 
that it was indeed a query.

Now, I press that point about making sure that the CFOUTPUT QUERY fails after 
the dump, because there is the possibility that it might work, which would 
suggest that there’s some other time when it fails, and it’s THEN that the 
CFDUMP would be most valuable. I could think of a number of scenarios where a 
variable might not have what it seems it should have. I won’t take your 
collective time speculating. But if you do get the error and do get a dump, and 
it is a query, let us know what you find. Again, that’s all if you want to 
press on. You may be happy to just leave it as a query loop.

/charlie

From: cfaussie@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 ), 
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<mailto:cfaussie@googlegroups.com>.
To unsubscribe from this group, send email to 
cfaussie+unsubscr...@googlegroups.com<mailto:cfaussie+unsubscr...@googlegroups.com>.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.
--
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 
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

-- 
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 
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

[cfaussie] RE: Attribute validation error for tag cfoutput

[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 email to 
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

[cfaussie] Attribute validation error for tag cfoutput

[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 
"BBERA_OK" works, but does not return any rows which is fine

Essentially the code reads


select
a bunch of stuff
from
a lot of tables


 ( on line 111 )

  do stuff




>From the exception log:
"Error","jrpp-3768","01/31/12","14:38:47","Bilby","Attribute validation error 
for tag cfoutput.The value of the attribute query, which is currently BBERA_OK, 
is invalid. The specific sequence of files included or processed is: 
D:\platypus2\batch\sbbp40.cfm, line: 111 "
coldfusion.tagext.InvalidTagAttributeException: Attribute validation error for 
tag cfoutput.
at coldfusion.tagext.QueryLoop.setQuery(QueryLoop.java:86)
at 
cfsbbp402ecfm359291098._factor12(D:\platypus2\batch\sbbp40.cfm:111)
at 
cfsbbp402ecfm359291098.runPage(D:\platypus2\batch\sbbp40.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
at 
coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416)
at 
coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at 
coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:381)
at 
coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:94)
at 
coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
at 
coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:79)
at 
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at 
coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
at coldfusion.CfmServlet.service(CfmServlet.java:200)
at 
coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
at 
coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
at 
coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
at jrun.servlet.FilterChain.service(FilterChain.java:101)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
at 
jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at 
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)
at 
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
at 
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
at 
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320)
at 
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
at 
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

>From the application log

"Error","jrpp-3768","01/31/12","14:38:47","Bilby","Attribute validation error 
for tag cfoutput.The value of the attribute query, which is currently BBERA_OK, 
is invalid. The specific sequence of files included or processed is: 
D:\platypus2\batch\sbbp40.cfm, line: 111 "

I have confirmed that the source cfm file is the same locally, and on both 
servers.

I cannot think of a single thing that would cause this problem, and I am out of 
ideas.

Any suggestions?

-- 
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 
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

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

[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...

Thanks!

-- 
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 
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

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

[Scott Thornton]

ah!, thankyou.

No I hadn't.

From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of 
Steve Onnis
Sent: Tuesday, 14 June 2011 2:36 PM
To: cfaussie@googlegroups.com
Subject: RE: [cfaussie] Scheduled Tasks - Where is the log file?

Have you turned it on? It is a setting 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 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 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 
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.
--
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 
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

-- 
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 
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

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

[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 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 
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

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

[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 and can't find the 
answers.

For example:
My local test site start page is 
http://127.0.0.1/my_site/password/password.cfm, if I view this page in IE I can 
see my debugging output and know its going to the correct page based on the DSN 
and settings, but the FireFox or IE view ( the tabs next to the source button) 
open a page without debugging and I am really not sure what or where the data 
is coming from. The copy Preview URL option returns 
"my_site/Password/sb_password.cfm".. but what server? It looks like its 
pointing to the settings\DSN that retrieve my live database, rather then my 
test database that I want.

Also I have managed to close some of the tabs within the ( lets say Snippets 
view), how do I get them back? better yet, can I "reset" the coldfusion 
perspective entirely?

Cheers,






-Original Message-
From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of 
Chris Velevitch
Sent: Tuesday, 3 May 2011 2:39 PM
To: ap...@googlegroups.com; cfaussie@googlegroups.com; 
flashaus...@googlegroups.com; AirAussie; Flexaussie
Subject: [cfaussie] Coldfusion Builder 2 is now available to buy or try

http://www.adobe.com/products/coldfusion-builder.html

-- 
Chris
--
Chris Velevitch
Manager - Adobe Platform Users Group, Sydney
m: 0415 469 095
www.apugs.org.au

Adobe Platform Users Group, Sydney
Topic: Panni, Burrito and Hero
Date: 30th May 6pm for 6:30 start
Details and RSVP on
http://apugs.groups.adobe.com/index.cfm?event=post.display&postid=34553

-- 
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 
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

-- 
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 
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

RE: [cfaussie] OT: jsp question

[Scott Thornton]

thanks guys..

From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of 
charlie arehart
Sent: Friday, 15 April 2011 8:18 AM
To: cfaussie@googlegroups.com
Subject: RE: [cfaussie] OT: jsp question

Yes, since CF 6 ColdFusion can itself run JSPs. (I think they may restrict it 
to Enterprise/Developer licenses only, and not Standard.)

To Scott’s question, technically, no IIS itself cannot run jsps, but if you 
have CF or any Java server/servlet engine, then yes THAT can run the JSPs, and 
you can certainly request them *through* IIS, just as you can request CFM pages 
through IIS and it’s CF that runs them.

/charlie

From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of 
Paul Haddon
Sent: Wednesday, April 13, 2011 9:10 PM
To: cfaussie@googlegroups.com
Subject: Re: [cfaussie] OT: jsp question

One of the handlers installed with CF 9 is 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.thorn...@hnehealth.nsw.gov.au>>
 wrote:
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 Google Groups 
"cfaussie" group.
To post to this group, send email to 
cfaussie@googlegroups.com<mailto:cfaussie@googlegroups.com>.
To unsubscribe from this group, send email to 
cfaussie+unsubscr...@googlegroups.com<mailto:cfaussie%2bunsubscr...@googlegroups.com>.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

--
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 
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.
--
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 
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

-- 
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 
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

[cfaussie] OT: jsp question

[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 Google Groups 
"cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com.
To unsubscribe from this group, send email to 
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

[cfaussie] Fullasagoog still working?

[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 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 
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

RE: [cfaussie] CFChart X axis value formatting

[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 SQL )

which would return
Dec-1989 etc?

much quicker imo.


From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of 
rai...@ozemail.com.au
Sent: Friday, 18 March 2011 12:49 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] CFChart X axis value formatting

Hi I have creating line graphs using cf charge and the dates are on the x axis

the date values in the sql tables being drawn on in the chart are datetime 
format  and as a result I am having the date and time appearing on the x axis 
for each point on the chart

as their a way I can alter the display format of the values similar what is 
done using the DateFromat() do that  my dates along the x axis only show in a 
month-year eg  "jan-11" rather than "01/01/11 10:55.00AM"

Regards

Claude Raiola (B.Econ Acc; B.Hot. Mngt)
[cid:image001.gif@01CBE56B.E9A076E0]
Email: i...@trackingcentral.com.au
Website: www.TrackingCentral.com.au
FREE CALL: 1300 255 990

--
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 
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

-- 
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 
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

<>

RE: [cfaussie] CF and Ajax

[Scott Thornton]

Hi,

Thanks for all replies to date

Looks like my colleague and I have a lot of catching up to do.

From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of 
Damen Hansen
Sent: Wednesday, 13 October 2010 7:59 AM
To: cfaussie@googlegroups.com
Subject: Re: [cfaussie] CF and Ajax

The docs for Ext Core may be better, theres not much in it.
I was merely suggesting using a library (there's a few out there!) so you don't 
reinvent any wheels.
The code you write for  ext core is very similar.

On 12 October 2010 18:54, Andrew Scott 
mailto:andr...@andyscott.id.au>> wrote:
Oh well then maybe you can look at ExtJS Core, it is actually easier to use and 
understand than jQuery.

Regards,
Andrew Scott
http://www.andyscott.id.au/



From: cfaussie@googlegroups.com<mailto:cfaussie@googlegroups.com> 
[mailto:cfaussie@googlegroups.com<mailto:cfaussie@googlegroups.com>] On Behalf 
Of Paul Kukiel
Sent: Tuesday, 12 October 2010 4:34 PM
To: cfaussie@googlegroups.com<mailto:cfaussie@googlegroups.com>

Subject: Re: [cfaussie] CF and Ajax

It needs to work in cfmx 6.1 so jQuery is looking like the way to go.


Regards,

Paul

On 12/10/2010 4: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] On Behalf Of Scott Thornton
Sent: Tuesday, 12 October 2010 8:50 AM
To: cfaussie@googlegroups.com<mailto:cfaussie@googlegroups.com>
Subject: [cfaussie] CF and Ajax

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 submit\page 
refresh rigmarole.

I have been looking through the coldfusionjedi website, but no example stands 
out.

Can anyone point me in the correct direction?

I am guessing that the solution uses jquery… just have never done much stuff 
with it before.

The solution should work in CF MX 6.1


--
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<mailto:cfaussie@googlegroups.com>.
To unsubscribe from this group, send email to 
cfaussie+unsubscr...@googlegroups.com<mailto:cfaussie+unsubscr...@googlegroups.com>.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.
--
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<mailto:cfaussie@googlegroups.com>.
To unsubscribe from this group, send email to 
cfaussie+unsubscr...@googlegroups.com<mailto:cfaussie+unsubscr...@googlegroups.com>.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.
--
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<mailto:cfaussie@googlegroups.com>.
To unsubscribe from this group, send email to 
cfaussie+unsubscr...@googlegroups.com<mailto:cfaussie+unsubscr...@googlegroups.com>.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.
--
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<mailto:cfaussie@googlegroups.com>.
To unsubscribe from this group, send email to 
cfaussie+unsubscr...@googlegroups.com<mailto:cfaussie%2bunsubscr...@googlegroups.com>.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

--
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

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

[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 proper Crystal Reports reports working for an web application, but 
they to need to called via classic asp via the SDK that is not 
supported\included in Crystal Reports 2008. I have never gotten around to 
attempting to get the .net calling paradigm worked out, but assume that works 
though ( but never have tried it).

Running reports like this with classic asp will require the IIS server running 
in IIS 5 Emulation mode ( whatever that is)

Look for a file named crsdk_net_samples_12.zip for .net examples, or asp 
examples in a file named something along the lines of aspmps115 on the website.

The Crytsal Reports product has suffered from being sold from Seagate, to 
Crytsal Decisions to Business Objects to SAP and getting support seems to be 
difficult when you run into the problems ( few people seem to want to run it in 
conjunction with web apps).

I have lets say 100 reports in Crystal Reports so re-engineering them for 
CFREPORT was not an option for me. 

Recent enquiries lead me to believe that the Report Builder was added to cf 8\9 
as a bit of an after thought and doesn't seem to be being actively maintained..

There is a report builder forum on the adobe website, so a question there may 
be of more help

Doesn't really answer your primary question, but perhaps some food for thought.

Cheers,


-Original Message-
From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of 
Mike Kear
Sent: Tuesday, 12 October 2010 1:21 PM
To: cfaussie
Subject: [cfaussie] Crystal Reports and CF9 Report Builder - how similar?

I have a client who has experience with Crystal Reports on his old CF5
site, and now that we've upgraded him to CF9 wants to use Crystal
Reports again.   I seem to recall that the adobe Report Builder that's
a free download to add on to CF9 is the same thing, only updated and
licensed.

Is that right?

If not, can anyone tell me how similar the current Report Builder is
to the CF5 era Crystal Reports?   (I'm wanting to gauge how much of a
job it's going to be for him to update his skills  I I never really
used that old Crystal Reports, so I'm not in a position to compare
them.)

-- 
Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month

-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

[cfaussie] CF and Ajax

[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 submit\page 
refresh rigmarole.

I have been looking through the coldfusionjedi website, but no example stands 
out.

Can anyone point me in the correct direction?

I am guessing that the solution uses jquery... just have never done much stuff 
with it before.

The solution should work in CF MX 6.1


-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

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

[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: [cfaussie] Strange problem - Element RECORDCOUNT is undefined in 
query

HI All,

1. What happens if you try CFDUMP instead right after the query?

using


returns

Variable FIX_THIS is undefined.

2. re recordcount gt 0.

I didn't know that, thanks.

3.  Why the cfoutput?

The original code used cfloop, I tried using cfoutput as well. Typically cfloop 
would be used.

4. Update CF?

Will try that now.

5. Does the query run (as is)?

Yes it does, however it does not return any rows ( in SQl Query Analyzer 2000). 
The database is MS SQL 2005

5. Much simplier query?


select top 1 * from sb_invoice




works fine.

Sooo, I will update my local server first, then put the orginal query back in 
and see how it goes.

From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of 
m...@ampersand.net.au
Sent: Friday, 1 October 2010 9:41 AM
To: cfaussie@googlegroups.com
Subject: Re: [cfaussie] Strange problem - Element RECORDCOUNT 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 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 exist after it 
has run.

eg: The following code returns Element RECORDCOUNT is undefined in FIX_THIS.



select sb_invoice.sb_invoice_id, sb_invoice.sb_reminder_date, 
max(sb_claim_date) as sb_claim_date
from sb_invoice
inner join sb_invoice_item
on sb_invoice.sb_invoice_id = sb_invoice_item.sb_invoice_id
inner join sb_item_claim
on sb_invoice_item.sb_invoice_item_id = 
sb_item_claim.sb_invoice_item_id
where sb_invoice.sb_bill_mech_code in 
('M','F','AG','SC','MB','MO')
and sb_invoice_item.sb_item_status_code in ('21','24','31')
group by sb_invoice.sb_invoice_id, sb_invoice.sb_reminder_date
having sb_invoice.sb_reminder_date < 
DateAdd(d,30,max(sb_claim_date))







update sb_invoice
set sb_reminder_date = 

where sb_invoice_id = 







I have changed the name of the query to a few different values, I have used 
cfloop instead of cfoutput, I added the cfif.recordcount to see if that helped, 
to no avail. Without the CFIF the error was :
Attribute validation error for tag cfoutput.



The value of the attribute query, which is currently fix_this, is invalid.



Debug output shows that the query executed in 922ms and returned no rows.

What am I missing?

--
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<mailto:cfaussie@googlegroups.com>.
To unsubscribe from this group, send email to 
cfaussie+unsubscr...@googlegroups.com<mailto:cfaussie+unsubscr...@googlegroups.com>.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.
--
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.
--
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

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

[Scott Thornton]

HI All,

1. What happens if you try CFDUMP instead right after the query?

using


returns

Variable FIX_THIS is undefined.

2. re recordcount gt 0.

I didn't know that, thanks.

3.  Why the cfoutput?

The original code used cfloop, I tried using cfoutput as well. Typically cfloop 
would be used.

4. Update CF?

Will try that now.

5. Does the query run (as is)?

Yes it does, however it does not return any rows ( in SQl Query Analyzer 2000). 
The database is MS SQL 2005

5. Much simplier query?


select top 1 * from sb_invoice




works fine.

Sooo, I will update my local server first, then put the orginal query back in 
and see how it goes.

From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of 
m...@ampersand.net.au
Sent: Friday, 1 October 2010 9:41 AM
To: cfaussie@googlegroups.com
Subject: Re: [cfaussie] Strange problem - Element RECORDCOUNT 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 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 exist after it 
has run.

eg: The following code returns Element RECORDCOUNT is undefined in FIX_THIS.



select sb_invoice.sb_invoice_id, sb_invoice.sb_reminder_date, 
max(sb_claim_date) as sb_claim_date
from sb_invoice
inner join sb_invoice_item
on sb_invoice.sb_invoice_id = sb_invoice_item.sb_invoice_id
inner join sb_item_claim
on sb_invoice_item.sb_invoice_item_id = 
sb_item_claim.sb_invoice_item_id
where sb_invoice.sb_bill_mech_code in 
('M','F','AG','SC','MB','MO')
and sb_invoice_item.sb_item_status_code in ('21','24','31')
group by sb_invoice.sb_invoice_id, sb_invoice.sb_reminder_date
having sb_invoice.sb_reminder_date < 
DateAdd(d,30,max(sb_claim_date))







update sb_invoice
set sb_reminder_date = 

where sb_invoice_id = 







I have changed the name of the query to a few different values, I have used 
cfloop instead of cfoutput, I added the cfif.recordcount to see if that helped, 
to no avail. Without the CFIF the error was :
Attribute validation error for tag cfoutput.



The value of the attribute query, which is currently fix_this, is invalid.



Debug output shows that the query executed in 922ms and returned no rows.

What am I missing?

--
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<mailto:cfaussie@googlegroups.com>.
To unsubscribe from this group, send email to 
cfaussie+unsubscr...@googlegroups.com<mailto:cfaussie+unsubscr...@googlegroups.com>.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.
--
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

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

[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 exist after it 
has run.

eg: The following code returns Element RECORDCOUNT is undefined in FIX_THIS.



select sb_invoice.sb_invoice_id, sb_invoice.sb_reminder_date, 
max(sb_claim_date) as sb_claim_date
from sb_invoice
inner join sb_invoice_item
on sb_invoice.sb_invoice_id = sb_invoice_item.sb_invoice_id
inner join sb_item_claim
on sb_invoice_item.sb_invoice_item_id = 
sb_item_claim.sb_invoice_item_id
where sb_invoice.sb_bill_mech_code in 
('M','F','AG','SC','MB','MO')
and sb_invoice_item.sb_item_status_code in ('21','24','31')
group by sb_invoice.sb_invoice_id, sb_invoice.sb_reminder_date
having sb_invoice.sb_reminder_date < 
DateAdd(d,30,max(sb_claim_date))







update sb_invoice
set sb_reminder_date = 

where sb_invoice_id = 







I have changed the name of the query to a few different values, I have used 
cfloop instead of cfoutput, I added the cfif.recordcount to see if that helped, 
to no avail. Without the CFIF the error was :
Attribute validation error for tag cfoutput.


The value of the attribute query, which is currently fix_this, is invalid.



Debug output shows that the query executed in 922ms and returned no rows.

What am I missing?

-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

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

[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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

RE: [cfaussie] Database Changes

[Scott Thornton]

easy no,  possible yes.

check out www.sqlservercentral.com<http://www.sqlservercentral.com> for some 
auditing techniques.

I audit quite a few of the fields in certain tables within my application.

This is done via triggers, inserting changes into an audit table: eg:

ALTER TRIGGER [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

DECLARE @SB_INVOICE_ITEM_ID AS NUMERIC
DECLARE @SB_UPDATED_BY AS VARCHAR(10)

DECLARE @SB_SERVICE_DATE_OLD AS DATETIME
DECLARE @SB_SERVICE_DATE_NEW AS DATETIME

DECLARE @SB_ITEM_QTY_OLD AS VARCHAR(5)
DECLARE @SB_ITEM_QTY_NEW AS VARCHAR(5)


-- SET VARIABLE VALUES TO THE OLD "PRE-UPDATE" VALUE
SELECT
  @SB_INVOICE_ITEM_ID = SB_INVOICE_ITEM_ID ,
  @SB_SERVICE_DATE_OLD =  SB_SERVICE_DATE,
  @SB_ITEM_QTY_OLD = ISNULL(CONVERT(VARCHAR, SB_ITEM_QTY) ,'blank')
FROM
  DELETED

-- SET VARIABLE VALUES TO THE NEW "POST-UPDATE" VALUE
SELECT
  @SB_SERVICE_DATE_NEW = SB_SERVICE_DATE ,
  @SB_ITEM_QTY_NEW = ISNULL(CONVERT(VARCHAR, SB_ITEM_QTY) ,'blank')
FROM
  INSERTED


-- THE SERVICE DATE HAS BEEN CHANGED
IF @SB_SERVICE_DATE_OLD <> @SB_SERVICE_DATE_NEW
BEGIN

  INSERT INTO dbo.SB_AUDIT_LOG
  (
SB_INVOICE_ITEM_ID,
SB_UPDATED_BY,
SB_UPDATE_DATE,
SB_AUDIT_EVENT
  )
  VALUES
  (
@SB_INVOICE_ITEM_ID,
@SB_UPDATED_BY,
GETDATE(),
'Service date has been changed from ' + 
isnull(CONVERT(VARCHAR,@SB_SERVICE_DATE_OLD,113 ), 'blank') + ' to ' + 
isnull(CONVERT(VARCHAR, @SB_SERVICE_DATE_NEW,113), 'blank')
  )

END

-- THE ITEM QUANTITY BEEN CHANGED
IF @SB_ITEM_QTY_OLD <> @SB_ITEM_QTY_NEW
BEGIN



  INSERT INTO dbo.SB_AUDIT_LOG
  (
SB_INVOICE_ITEM_ID,
SB_UPDATED_BY,
SB_UPDATE_DATE,
SB_AUDIT_EVENT
  )
  VALUES
  (
@SB_INVOICE_ITEM_ID,
@SB_UPDATED_BY,
GETDATE(),
'The Item Quantity has been changed from ' + CONVERT(VARCHAR, 
@SB_ITEM_QTY_OLD) + ' to ' + CONVERT(VARCHAR,@SB_ITEM_QTY_NEW)
  )

END


tedious I know….

PS: don't forget that triggers only will fire on single row updates. an update 
that effects multiple rows will only fire the trigger for the last row.

From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of 
Dale Fraser
Sent: Thursday, 19 August 2010 12:42 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Database Changes

Is there an easy way to see what fields have changed in a database.

I have an audit requirement that basically needs me to determine what changed

So when I do an update, I would ideally like to know what columns and fields 
changed

Something like

Name: Fred Fluntstone
Name: Fred Flintstone

Regards
Dale Fraser

http://dale.fraser.id.au
http://cfmldocs.com<http://cfmldocs.com/>
http://learncf.com
http://flexcf.com

--
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

RE: [cfaussie] CF8 and MSSQL 2005/2008

[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 an underlying insert trigger….


From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of 
Paul Kukiel
Sent: Friday, 13 August 2010 5:27 PM
To: cfaussie@googlegroups.com
Subject: Re: [cfaussie] CF8 and MSSQL 2005/2008

Steve don't use @@identity you can achieve this result with CF alone:

http://cookbooks.adobe.com/post_Getting_the_ID_of_the_Last_Record_Inserted_Into_a-16522.html

and with CF9 its more generic:

http://cookbooks.adobe.com/post_Generated_key___Get_the_ID_of_the_inserted_record-16593.html

Paul.
On Fri, Aug 13, 2010 at 5:19 PM, Steve Onnis 
mailto:st...@cfcentral.com.au>> wrote:
Is there an updated driver for SQL Server?  I have come across this issue where 
if i run this query:-


INSERT
INTO TableName (Col1)
VALUES ('foobar')
SELECT @@IDENTITY AS 'NewID'


Under CF8 it errors saying qInsert is undefined but under CF9 it runs fine.

Steve
--
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 
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.



--
Paul Kukiel
--
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

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

[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 to go.

There is a windows utility - I think it is called "fileproc" - that
will let you see what applications / services have a file open for
use.
Mr.Google will help you find the utility I am talking about - unless
someone else on the list knows it off the top of their head!

Good luck!



On Jul 20, 10:17 am, Hitesh  wrote:
> Hi Dale,
>
> Thanks for your help so far. Can you see if you can help on this?
>
> I copied those two .ttc font files somewhere else as backup but when
> try to delete those fonts by right clicking >> delete then it said
> something like "being used by another process". So we restarted the
> server & immediately went to CONTROL PANEL >> FONTS and tried to
> delete them but NO LUCK...there was the same message.
>
> Can you help how to remove/uninstall these 2 .ttc font files?
>
> Looking forward to seeing you reply.
>
> Thanks,
> Hitesh
>
> On Jul 19, 5:38 pm, "Dale Fraser"  wrote:
>
> > I remember doing that on one of our servers.
>
> > Just copy them somewhere and see if it helps. If it doesn’t you
can copy
> > them back.
>
> > Regards
> > Dale Fraser
>
>
>http://dale.fraser.id.auhttp://cfmldocs.comhttp://learncf.comhttp://f...
>
> > -Original Message-
> > From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com]
On Behalf
>
> > Of Hitesh
> > Sent: Monday, 19 July 2010 5:26 PM
> > To: cfaussie
> > Subject: [cfaussie] Re: Issue with displaying Chinese characters
into
> > CFDOCUMENT PDF
>
> > Hi Dale and Paul,
>
> > Do you guys think this is the right thing to do about Chinese
characters?
>
> > If you review last 3 comments at very
bottomhttp://forums.adobe.com/message/869253
> > then ADOBE is saying to remove 2 font files: SimSun.ttc &
MingLiu.ttc.
> > I am afraid to do this because not sure if they are being used
somewhere by
> > the server?
>
> > Kindly help me, please.
>
> > Thanks,
> > Hitesh
>
> > On Jul 19, 3:26 pm, "Dale Fraser"  wrote:
> > > You need to be using UTF8 in your document
>
> > > And you need to have the appropriate language pack installed on
the
> > server.
>
> > > Regards
> > > Dale Fraser
>
> >
>http://dale.fraser.id.auhttp://cfmldocs.comhttp://learncf.comhttp://fl

> > > excf.com
>
> > > -Original Message-
> > > From: cfaussie@googlegroups.com
[mailto:cfaus...@googlegroups.com] On
> > > Behalf
>
> > > Of Hitesh
> > > Sent: Monday, 19 July 2010 3:19 PM
> > > To: cfaussie
> > > Subject: [cfaussie] Issue with displaying Chinese characters
into
> > > CFDOCUMENT PDF
>
> > > Hi All,
>
> > > When I try to generate HTML to PDF using with below tag, the
Chinese
> > > characters getting converted to BLANK.
> > > What are the settings required in the code and on server?
>
> > >  > > unit="cm" localUrl="yes" fontembed="yes"> ..
>
> > > ..
> > > .
> > > .
> > > .
> > > 
>
> > > Looking forward to seeing your great help!
>
> > > Thanks,
> > > Hitesh
>
> > > --
> > > 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, visit this group
> > athttp://groups.google.com/group/cfaussie?hl=en.
>
> > --
> > 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, visit this group
athttp://groups.google.com/group/cfaussie?hl=en.

-- 
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, visit this group at
http://groups.google.com/group/cfaussie?hl=en.

-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

[cfaussie] Adobe LiveCycle

[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 does, versus 
coldfusion\flex

Does anyone use LiveCycle on this list?



-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

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

[Scott Thornton]

IMO, Set Langauge seems a bit... obtuse?

SET LANGUAGE DMY seems more appropriate, especially if you are giong to enter 
it into every sproc.

cheers,

>>> Mike Kear  08/06/2010 2:27 pm >>>
Thanks everyone for your help with this. I  dont have it solved yet but i'm
on the right track now I think.

I dont have this problem with any of the code I've written from scratch, but
in this case I'm inheriting a lot of code written in CF5 years ago, and
moved to a new server and database server.

I have determined by manually altering the values in the date fields that if
the dates are stored in -mm-dd format in the database, all the legacy
code works as expected, so all I have to do is make sure any insert and
update statements force the dates always to be inserted the right way
around.

It seems that if i add a Set language = 'british'  to my insert and update
queries, that should make sure of that. That's my theory and I'm testing
it now.

Once this episode is all done, I'll write more about how i manage Australian
format  dates when i write my own code, because I've had that under control
for a long time.  I only see this problem because of all the legacy code
I've inherited.

@Gavin,  no need for the meaculpa.  I had travelled along the locale road in
the documentation for SQLServer and had found SET LANGUAGE in my travels.
So you led me to this path anyway.

Thanks


Cheers
Mike Kear
Windsor, NSW, Australia
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:
> > 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 * from master.dbo.syslanguages to check out the dateformats
> available.
> >
> > I gave up on CF and SQL working well with European\Aussie dates long ago.
> >
> > I like using SET DATEFORMAT DMY in all of my procedures, and within CF
> DateFormat( x, "dd-MMM-") but I agree that we should not have to.
> >
>
> Ahhh thats the one - thanks Scott!
> Looks loie we do the same thing... manually ensure that the dateformat
> is manually handled prior to insertion into the database - regardless
> of format chosen.
>
> Sorry for the misleading LOCALE setting Mike!
>
> Gavin.
>
>

-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.


-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

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

[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 * from master.dbo.syslanguages to check out the dateformats available.

I gave up on CF and SQL working well with European\Aussie dates long ago.

I like using SET DATEFORMAT DMY in all of my procedures, and within CF 
DateFormat( x, "dd-MMM-") but I agree that we should not have to.



>>> Mike Kear  08/06/2010 1:51 pm >>>
@mgk:  I'm doing the updates using ColdFusion.  The only property I can find
that's remotely associated with language or nationality or locale is  the
collation = SQL_Latin1_General_CP1_CI_AS

Can this be set to something else?   Does it set the default date format
property?

Cheers
Mike Kear
Windsor, NSW, Australia
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 1:46 PM, m...@ampersand.net.au 
wrote:

>  I've been doing some more reading - slow day today - apparently the date
> format used can also depend on the user logged in to the database - if you
> get properties of the login you are using to do the updates (in management
> studio) is it English or British English?
>
>
>
>

-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.


-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

Re: [cfaussie] Display XML on webpage

[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,
>
> interestingly it kinda of works, at least IE display the xml now.
>
> Originally, i replaced all of the > with ">" etc in the query thinking
> that thwy would be a problem...
>
> Ill also try the formatter posted
> http://alexgorbatchev.com/wiki/SyntaxHighlighter 
>
>
>
> >>> On 07/06/2010 at 2:37 pm, in message <
> 4c0c7794.1070...@ampersand.net.au>, "m...@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, 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  ( mailto:andr...@andyscott.id.au )
> 07/06/2010 2:22 pm >>>Try using the cfcontent.
>
>
> On Mon, Jun 7, 2010 at 2:18 PM, Scott Thornton <
> scott.thorn...@hnehealth.nsw.gov.au> wrote:
>
>
>
> 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 extension,
> Internet explorer formats it and displays it okay, but a simple output of
> the database field eg:
> select #query.xml#
> Internet explorer displays an error,
>
> The XML page cannot be displayed
> Cannot view XML input using XSL style sheet. Please correct the error and
> then click the Refresh button, or try again later.
>
> Firefox displays it as one long string.
>
> Wrapping the cfoutput in  doesn't help.
>
> Putting the cfoutput with a CFtextarea helps, but then I need to format it
> ( indent it to make it more readable )
>
> I guess one potential problem is that the xml string contains another XML
> string ( partData )
> 
>  transmissionId="WEB20117091e4bf161a06700" from="WEB20117" mode="FIXME"
> contentsSigned="false"
> contentsType="MCA/OlcHospital/inhospitalclaimreques...@1" xmlns:ns1="
> http://hic.gov.au/hiconline/protocol/model"; (
> http://hic.gov.au/hiconline/protocol/model )>majorVersion="6.10" vendor="HIC"
> platform="os: Windows 2003 x86 5.2 jre: Sun 1.5.0_05" product="HicOnline">
>   platform="os:
> Windows 2003 x86 5.2 jre: Sun 1.5.0_05" product="OlcHospital">   
>  platform="os: Windows 2003 x86 5.2 jre: Sun 1.5.0_05" product="Platypus2">
>   platform="os:
> Windows 2003 x86 5.2 jre: Sun 1.5.0_05" product="eSignature">   
>  role="" dataRef="1" type="MCA/OlcHospital/inhospitalclaimreques...@1"
> signed="false">encoding="UTF-8" standalone="yes"?>xmlns:ns1="
> http://hic.gov.au/hiconline/eclipse/version-1"; (
> http://hic.gov.au/hiconline/eclipse/version-1 )>  messagePartId="CID">   PU
> 0012790J   ABC
> A1234567
>  abc  123
> 0249853321 
> emailaddr...@hnehealth.nsw.gov.au   
> N
> 9
> N
> 58800
> 58800
> 1messagePartId="PAT">  dateOfBirth="1939-01-16+10:00">firstName="firstName" lastName="lastName"/>
> memberRefNum="1" memberNum="1234567707"/>memberNum="1234567"/> 
> 97654321   
> 
> 2010-05-03+10:00
> 09:24:00+10:00
> 2010-05-05+10:00
> 15:35:00+10:00
> 2116524
> OT
> 10
> A
> 2 3
> 09
> 4
> 1   
> 
> 2010-05-03+10:00
> 2010-05-05+10:00 2
> 0
> 2
> 58800
> C  messagePartId="ACD1">
> 2010-05-03+10:00
> 2010-05-05+10:00
> 2
> 58800
> C   29400
>   OT
>   S
> false 
>   messagePartId="PSG1">
> 2010-05-03+10:00
> 09:24:00+10:00  t

Re: [cfaussie] Display XML on webpage

[Scott Thornton]

Hi,

interestingly it kinda of works, at least IE display the xml now.

Originally, i replaced all of the > with ">" etc in the query thinking that 
thwy would be a problem...

Ill also try the formatter posted 
http://alexgorbatchev.com/wiki/SyntaxHighlighter



>>> On 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, 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  ( mailto:andr...@andyscott.id.au ) 
07/06/2010 2:22 pm >>>Try using the cfcontent.


On Mon, Jun 7, 2010 at 2:18 PM, Scott Thornton 
 wrote:

  

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 extension,
Internet explorer formats it and displays it okay, but a simple output of
the database field eg:
select #query.xml#
Internet explorer displays an error,

The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error and
then click the Refresh button, or try again later.

Firefox displays it as one long string.

Wrapping the cfoutput in  doesn't help.

Putting the cfoutput with a CFtextarea helps, but then I need to format it
( indent it to make it more readable )

I guess one potential problem is that the xml string contains another XML
string ( partData )
 
http://hic.gov.au/hiconline/protocol/model"; ( 
http://hic.gov.au/hiconline/protocol/model )>  
 
   
 
  http://hic.gov.au/hiconline/eclipse/version-1"; ( 
http://hic.gov.au/hiconline/eclipse/version-1 )>PU   
0012790J   ABC  
 A1234567   
 abc  123 
0249853321 
emailaddr...@hnehealth.nsw.gov.au
  N   
9   
N   
58800   
58800   
1 
  
   
  
  97654321 
  
2010-05-03+10:00 
09:24:00+10:00 
2010-05-05+10:00 
15:35:00+10:00 
2116524 
OT 
10 
A 
2 3 
09 
4 
1  
 
2010-05-03+10:00 
2010-05-05+10:00 2
 0 
2 
58800 
C2010-05-03+10:00   
2010-05-05+10:00   
2   58800 
  C   
29400   
OT   
S   
false  
  
2010-05-03+10:00 
09:24:00+10:00 56507 0 
I 
0 
N 
S 
N 
0 
0  
  
  C782  
   C80 

5650700   
  9555000 
9555003  
0
   


Can anyone offer a simple solution?

The website http://aaronkarp.com/prettyXML/ formats the long string okay,
which makes me think there might be some kind of webservice available to do
this?

PS: A software product external to CF creates the XML and stores it in our
database. I have no control over this software and can't modify the XML
directly...

Thanks,





--
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 
tocfaussie+unsubscr...@googlegroups.com
 ( mailto:cfaussie%2bunsubscr...@googlegroups.com ).
For more options, visit this group 
athttp://groups.google.com/group/cfaussie?hl=en.




-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

-- 
You received this message because you are subscribed to the Google Groups 
"cfaussie" group.
To post to this group, send email to cfaus

Re: [cfaussie] Display XML on webpage

[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 PM, Scott Thornton <
scott.thorn...@hnehealth.nsw.gov.au> wrote:

> 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 extension,
> Internet explorer formats it and displays it okay, but a simple output of
> the database field eg:
>
> select 
> #query.xml#
>
> Internet explorer displays an error,
>
> The XML page cannot be displayed
> Cannot view XML input using XSL style sheet. Please correct the error and
> then click the Refresh button, or try again later.
>
> Firefox displays it as one long string.
>
> Wrapping the cfoutput in  doesn't help.
>
> Putting the cfoutput with a CFtextarea helps, but then I need to format it
> ( indent it to make it more readable )
>
> I guess one potential problem is that the xml string contains another XML
> string ( partData )
>
> 
>   transmissionId="WEB20117091e4bf161a06700" from="WEB20117" mode="FIXME"
> contentsSigned="false"
> contentsType="MCA/OlcHospital/inhospitalclaimreques...@1" xmlns:ns1="
> http://hic.gov.au/hiconline/protocol/model";>
> platform="os: Windows 2003 x86 5.2 jre: Sun 1.5.0_05" product="HicOnline">
>
>
>
> platform="os: Windows 2003 x86 5.2 jre: Sun 1.5.0_05" product="Platypus2">
>
>
>
> role="" dataRef="1" type="MCA/OlcHospital/inhospitalclaimreques...@1"
> signed="false">
>
>
>  
>http://hic.gov.au/hiconline/eclipse/version-1";>
>  
>PU
>0012790J
>ABC
>A1234567
>
>  abc  123
>  0249853321
>  emailaddr...@hnehealth.nsw.gov.au
>
>N
>9
>N
>58800
>58800
>1
>
>  
>
>
>
>
>  
>  97654321
>
>
>  2010-05-03+10:00
>  09:24:00+10:00
>  2010-05-05+10:00
>  15:35:00+10:00
>  2116524
>  OT
>  10
>  A
>  2
>  3
>  09
>  4
>  1
>
>
>  2010-05-03+10:00
>  2010-05-05+10:00
>  2
>  0
>  2
>  58800
>  C
>  
>2010-05-03+10:00
>2010-05-05+10:00
>2
>58800
>C
>29400
>OT
>S
>false
>  
>
>
>  2010-05-03+10:00
>  09:24:00+10:00
>  56507
>  0
>  I
>  0
>  N
>  S
>  N
>  0
>  0
>
>
>  
>C782
>  
>  
>C80
>  
>  
>5650700
>  
>  
>9555000
>  
>  
>9555003
>  
>  0
>
>  
>
>  
>
>
>
> Can anyone offer a simple solution?
>
> The website http://aaronkarp.com/prettyXML/ formats the long string okay,
> which makes me think there might be some kind of webservice available to do
> this?
>
> PS: A software product external to CF creates the XML and stores it in our
> database. I have no control over this software and can't modify the XML
> directly...
>
> Thanks,
>
>
>
>
>
> --
> 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.
> T

[cfaussie] Display XML on webpage

[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 extension, Internet 
explorer formats it and displays it okay, but a simple output of the database 
field eg:

select 
#query.xml#

Internet explorer displays an error, 

The XML page cannot be displayed 
Cannot view XML input using XSL style sheet. Please correct the error and then 
click the Refresh button, or try again later. 

Firefox displays it as one long string.

Wrapping the cfoutput in  doesn't help.

Putting the cfoutput with a CFtextarea helps, but then I need to format it ( 
indent it to make it more readable )

I guess one potential problem is that the xml string contains another XML 
string ( partData )


  http://hic.gov.au/hiconline/protocol/model";>











  
http://hic.gov.au/hiconline/eclipse/version-1";>
  
PU
0012790J
ABC
A1234567

  abc  123
  0249853321
  emailaddr...@hnehealth.nsw.gov.au

N
9
N
58800
58800
1

  




  
  97654321


  2010-05-03+10:00
  09:24:00+10:00
  2010-05-05+10:00
  15:35:00+10:00
  2116524
  OT
  10
  A
  2
  3
  09
  4
  1


  2010-05-03+10:00
  2010-05-05+10:00
  2
  0
  2
  58800
  C
  
2010-05-03+10:00
2010-05-05+10:00
2
58800
C
29400
OT
S
false
  


  2010-05-03+10:00
  09:24:00+10:00
  56507
  0
  I
  0
  N
  S
  N
  0
  0


  
C782
  
  
C80
  
  
5650700
  
  
9555000
  
  
9555003
  
  0

  

  



Can anyone offer a simple solution?

The website http://aaronkarp.com/prettyXML/ formats the long string okay, which 
makes me think there might be some kind of webservice available to do this?

PS: A software product external to CF creates the XML and stores it in our 
database. I have no control over this software and can't modify the XML 
directly...

Thanks,


 


-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

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

[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 there will also be a change of venue.  Details
follow:

This month Phil Haeusler is doing a presentation on FW/1 - Framework
One, 'The Invisible Framework'.

FW/1 is a new framework lead by Sean Corfield.   It leverages
Application.cfc and some simple conventions to provide a 'full' MVC
framework in a single file.

Intended to require near-zero configuration, FW/1 lets you build your
application without worrying about a framework getting in your way.

The session will cover
* Why bother with frameworks?
* Yet another ColdFusion Framework
* Getting started with FW/1
* Understanding the FW/1 lifecycle
* But what is MVC?
* Building a FW/1 app, and
* Looking towards the next release of FW/1 v1.1
* So, should we bother with FW/1?

Phil has been an independant ColdFusion consultant in Melbourne for
more than 10 years delivering on a vast number of solutions to public,
private and startup clients predominately focusing on ColdFusion, Flex
and other Adobe technologies.

Date: Thursday 27 May 2010
Time: 6:30 PM
NEW Location:
Level 2
255 Bourke Street
Melbourne, VIC, 3000

RSVP:  Please reply to this post if you are planning to attend so we
know how many pizzas to order.

We look forward to seeing you all there.

Peter Robertson

-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.


-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

Re: [cfaussie] OT : google group bounced emails

[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.com.
To unsubscribe from this group, send email to 
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.


-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

[cfaussie] Re: CF Mail problem

[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 CF6.1, but you could give this a whirl ...





I found this snippet somewhere on the electric interweb so I can't
take credit for it.

Cheers
Glen

-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.


-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

RE: [cfaussie] CF Mail problem

[Scott Thornton]

My thoughts exactly, I'd love to see it separate.

Spool mail messages for delivery - option. Could be interesting, but am unsure 
what un-intended side effect of turning this option off would have. I guess 
some research is required..

>>> "Steve Onnis"  18/05/2010 10:50 am >>>
Charlie

I think the issue was that something happened to the mail process which
stopped mail from being sent.  I have seen it a few times myself when cf
just stops sending mail for some reason.  He was asking if you can restart
the mailing process without having to restart the whole cf server...which I
don't believe you can.  Would be nice though. There are a few services that
get installed with the cf sever (ODBC, .NET, Search), would be nice to have
a Mail service there also so you don't have to bring down the whole cf
server to restart the mailing process...or even stop it all together

Steve

-Original Message-
From: charlie arehart [mailto:charlie_li...@carehart.org] 
Sent: Tuesday, 18 May 2010 10:44 AM
To: cfaussie@googlegroups.com 
Subject: RE: [cfaussie] CF Mail problem

Scott, I'm not sure if this is really what you're asking for (in wanting to
"break the ties of CF to mail processing"), but CF 6 did add the ability to
"break the tie" that has CF spooling the emails. If you want it to go
directly from CF to the SMTP mail server, you can do that now, either from
the CF Admin or via the spoolenable="no"
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
> To: cfaussie@googlegroups.com 
> Subject: Re: [cfaussie] CF Mail problem
> 
> Hello,
> 
> A restart of the cf service sent the mail off.
> 
> the mail was sitting in the spool directory, never going anywhere. 
> They undeliverable directory was empty.
> 
> I restarted the cf service at lunch time 12:30pm :>
> 
> Its such a pity that the mail service is tied to the CF service. I 
> think 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 at
4:45pm
> then nothing...
> 
> Are they going out now? Have you dragged them all back into the spool 
> folder to give them another go? If they are still not going out in the 
> sense that they are just sitting there in the spool folder then you 
> are going to have to kick the server. If they go back to the undelivr 
> folder then CF's mail engine is running and you are going to have to 
> check the emails in more detail. There is a cfc out there that talks 
> to the factory and restarts to mail engine but we have found it to be 
> a tad unreliable when we have tried it so we just pick a quiet moment 
> and restart CF, much more reliable :-)
> 
> 
> --
> 
> Yours,
> 
> Kym Kovan
> mbcomms.net.au
> 
> --
> 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, visit this group at
> http://groups.google.com/group/cfaussie?hl=en.
> 
> 
> --
> 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, visit this group at
> http://groups.google.com/group/cfaussie?hl=en.


--
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, visit this group at
http://groups.google.com/group/cfaussie?hl=en.


-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

Re: [cfaussie] CF Mail problem

[Scott Thornton]

Hello,

A restart of the cf service sent the mail off.

the mail was sitting in the spool directory, never going anywhere. They 
undeliverable directory was empty.

I restarted the cf service at lunch time 12:30pm :>

Its such a pity that the mail service is tied to the CF service. I think 
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 at 4:45pm 
> then nothing...

Are they going out now? Have you dragged them all back into the spool 
folder to give them another go? If they are still not going out in the 
sense that they are just sitting there in the spool folder then you are 
going to have to kick the server. If they go back to the undelivr folder 
then CF's mail engine is running and you are going to have to check the 
emails in more detail. There is a cfc out there that talks to the 
factory and restarts to mail engine but we have found it to be a tad 
unreliable when we have tried it so we just pick a quiet moment and 
restart CF, much more reliable :-)


-- 

Yours,

Kym Kovan
mbcomms.net.au

-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.


-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

Re: [cfaussie] CF Mail problem

[Scott Thornton]

Hi,

Nothing unusual on logs

I am, since last week. The spool checking stooped last Friday at 4:45pm 
then nothing...

>>> Kai Koenig  17/05/2010 3:58 pm >>>
check your log files if you can see any unusual issues in there. Also I'm a big 
fan of logging every single email 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 cfmail 
> process without re-starting the entire CF service?
> 
> This is CF MX 6.1.
> 
> 
> 
> 
> 
> -- 
> 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, visit this group at 
> http://groups.google.com/group/cfaussie?hl=en.
> 


--
Kai Koenig - Ventego Creative Ltd
ph: +64 4 476 6781 - mob: +64 21 928 365 /  +61 450 132 117
web: http://www.ventego-creative.co.nz 
blog: http://www.bloginblack.de 
twitter: http://www.twitter.com/agentK 

Hands-on Regular Expression training @ webDU 2010
http://bloginblack.de/agentk/workshop-befriending-regular-expressions/ 

Hands-on Flash Catalyst and Flex 4 training @ Webinale 2010 
http://bloginblack.de/agentk/workshop-rias-with-flash-catalyst-and-flex-4/ 
--







-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.


-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

[cfaussie] CF Mail problem

[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 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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

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

[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'

Regards
Bryce Hoffmann :)
NCC

From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of 
rai...@ozemail.com.au 
Sent: Tuesday, 11 May 2010 12:34 PM
To: cfaussie@googlegroups.com; coldfusion-ho...@yahoogroups.com 
Subject: [cfaussie] Trying To Connect To Exchange Server using 


However every time I try to connect I get the message

Access to the Exchange server denied.
Ensure that the user name and password are correct.

if anyone can shed some light on this I would appreciate it

Regards

Claude Raiola
B.Econ (Acc), B.Hot.Mngt.

Websites:
www.SAMARIS.NET
Mobile: 0414 228 948

--
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

*** Confidentiality and Disclaimer Statement *
The information in this e-mail and any attachments are confidential and may be 
subject to legal professional privilege. It is intended solely for the 
attention and use of the named addressee(s). If you are not the intended 
recipient, or person responsible for delivering this information to the 
intended recipient, please notify the sender immediately. Unless you are the 
intended recipient or his/her representative you are not authorised to, and 
must not read, copy, distribute, use or retain this message or any part of it.

Opinions, conclusions and other information expressed in this message are not 
given or endorsed by NCC unless otherwise indicated by an authorised officer 
independent of this message.

NCC has implemented anti-virus software, and whilst all care is taken, it is 
the recipient's responsibility to ensure that the message and any attachments 
are scanned for viruses prior to use.

This footnote also confirms this e-mail message has been read electronically by 
an e-mail content breakdown system.

Newcastle City Council
Web: http://www.newcastle.nsw.gov.au 
E-mail: m...@ncc.nsw.gov.au 


-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.


-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

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

[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 (I
think). But how they obtain those new license keys is a bit
mysterious. It seems they don't just get issued automatically.

I'd suggest calling Adobe Australia, or try Geoff or Robin, next week,
after WebDU ;)



On 5/7/10, Zac Spitzer  wrote:
> After half an hour of flash fueled pointless pain on the adobe website,
> can anyone point me in the right direction?
>
> I have a client with cf8 standard under subscription, using what is
> a volume license... i'd like to be able to find out about the cost of
> renewing the subscription...
>
> sigh
>
> z
>
>
> --
> Zac Spitzer
> Solution Architect / Director
> Ennoble Consultancy Australia
> http://www.ennoble.com.au 
> http://zacster.blogspot.com 
> +61 405 847 168
>
> --
> 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, visit this group at
> http://groups.google.com/group/cfaussie?hl=en.
>
>

-- 
Sent from my mobile device

-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.


-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

[cfaussie] CF IDE

[Scott Thornton]

Hi,

A co-workers Macromedia Dreamweaver MX has recently stopped working which has 
started me looking into getting our IDE's updated.

Now I know CFECLIPSE on top of ECLIPSE worked okay, so I am surprised to learn 
that the new Coldfusion Builder is priced at $299 US dollars.

Is CFECLIPSE now no longer available? Does CF Builder have functionality that 
does not exist in CFECLISPE ? Is CFEclipse now no longer developed\in 
use\recommended?

Dreamweaver CS4 is priced at $330 US I think, but as we don't do "real" web 
development, and we don't use any of the 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 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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

RE: [cfaussie] cfmamil problem

[Scott Thornton]

Hello,

restarting CF server fixed the problem.

>>> "KNOTT, Brian"  16/04/2010 11:36 am >>>
Working from memory there should be a mail.log and a mail error log.  Make sure 
you are checking 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'
Subject: RE: [cfaussie] cfmamil problem

Hi,

thanks for your reply.

the log is absolutely bare:

"Severity","ThreadID","Date","Time","Application","Message"
"Information","jrpp-2408","03/09/10","16:41:24",,"C:\CFusionMX\logs\mail.log 
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"  16/04/2010 11:24 am >>>
Scott,
Have a look in the mail error log.  It will tell you why what emails 
are failing and why.  You may have to increase your level of error capture if 
no log exists or there is not enough details.  Stick the failed emails back in 
the spool folder, let them run through and check the error log (cfadmin 
interface).

Brian Knott

-Original Message-
From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of 
Scott Thornton
Sent: Friday, 16 April 2010 11:22 AM
To: cfaussie@googlegroups.com 
Subject: [cfaussie] cfmamil problem

Hello,

I have a bunch of unprocessed mail in the C:\CFusionMX\Mail\Spool directory ( 
cfmx 6.1)

I have verified the mail connection in the cf admin.

mail can be sent from telnet on the server.

our server admins say that all looks okay their end on the postoffice etc.

my question is, what is 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 group, send email to cfaus...@googlegroups.com.
To unsubscribe from this group, send email to 
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.


This e-mail is sent by Suncorp-Metway Limited ABN 66 010 831 722 or one of its 
related entities "Suncorp".
Suncorp may be contacted at Level 18, 36 Wickham Terrace, Brisbane or on 13 11 
55 or at suncorp.com.au.
The content of this e-mail is the view of the sender or stated author and does 
not necessarily reflect the view of Suncorp. The content, including 
attachments, is a confidential communication between Suncorp and the intended 
recipient. If you are not the intended recipient, any use, interference with, 
disclosure or copying of this e-mail, including attachments, is unauthorised 
and expressly prohibited. If you have received this e-mail in error please 
contact the sender immediately and delete the e-mail and any attachments from 
your system.
If this e-mail constitutes a commercial message of a type that you no longer 
wish to receive please reply to this e-mail by typing Unsubscribe in the 
subject line.

-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.


-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

RE: [cfaussie] cfmamil problem

[Scott Thornton]

Hi,

I will set the Mail Logging Settings  \ Error Log Severity to "Debug" to see if 
identifies any problem...

>>> "KNOTT, Brian"  16/04/2010 11:36 am >>>
Working from memory there should be a mail.log and a mail error log.  Make sure 
you are checking 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'
Subject: RE: [cfaussie] cfmamil problem

Hi,

thanks for your reply.

the log is absolutely bare:

"Severity","ThreadID","Date","Time","Application","Message"
"Information","jrpp-2408","03/09/10","16:41:24",,"C:\CFusionMX\logs\mail.log 
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"  16/04/2010 11:24 am >>>
Scott,
Have a look in the mail error log.  It will tell you why what emails 
are failing and why.  You may have to increase your level of error capture if 
no log exists or there is not enough details.  Stick the failed emails back in 
the spool folder, let them run through and check the error log (cfadmin 
interface).

Brian Knott

-Original Message-
From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of 
Scott Thornton
Sent: Friday, 16 April 2010 11:22 AM
To: cfaussie@googlegroups.com 
Subject: [cfaussie] cfmamil problem

Hello,

I have a bunch of unprocessed mail in the C:\CFusionMX\Mail\Spool directory ( 
cfmx 6.1)

I have verified the mail connection in the cf admin.

mail can be sent from telnet on the server.

our server admins say that all looks okay their end on the postoffice etc.

my question is, what is 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 group, send email to cfaus...@googlegroups.com.
To unsubscribe from this group, send email to 
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.


This e-mail is sent by Suncorp-Metway Limited ABN 66 010 831 722 or one of its 
related entities "Suncorp".
Suncorp may be contacted at Level 18, 36 Wickham Terrace, Brisbane or on 13 11 
55 or at suncorp.com.au.
The content of this e-mail is the view of the sender or stated author and does 
not necessarily reflect the view of Suncorp. The content, including 
attachments, is a confidential communication between Suncorp and the intended 
recipient. If you are not the intended recipient, any use, interference with, 
disclosure or copying of this e-mail, including attachments, is unauthorised 
and expressly prohibited. If you have received this e-mail in error please 
contact the sender immediately and delete the e-mail and any attachments from 
your system.
If this e-mail constitutes a commercial message of a type that you no longer 
wish to receive please reply to this e-mail by typing Unsubscribe in the 
subject line.

-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.


-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

RE: [cfaussie] cfmamil problem

[Scott Thornton]

Hi,

thanks for your reply.

the log is absolutely bare:

"Severity","ThreadID","Date","Time","Application","Message"
"Information","jrpp-2408","03/09/10","16:41:24",,"C:\CFusionMX\logs\mail.log 
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"  16/04/2010 11:24 am >>>
Scott,
Have a look in the mail error log.  It will tell you why what emails 
are failing and why.  You may have to increase your level of error capture if 
no log exists or there is not enough details.  Stick the failed emails back in 
the spool folder, let them run through and check the error log (cfadmin 
interface).

Brian Knott

-Original Message-
From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of 
Scott Thornton
Sent: Friday, 16 April 2010 11:22 AM
To: cfaussie@googlegroups.com 
Subject: [cfaussie] cfmamil problem

Hello,

I have a bunch of unprocessed mail in the C:\CFusionMX\Mail\Spool directory ( 
cfmx 6.1)

I have verified the mail connection in the cf admin.

mail can be sent from telnet on the server.

our server admins say that all looks okay their end on the postoffice etc.

my question is, what is 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 group, send email to cfaus...@googlegroups.com.
To unsubscribe from this group, send email to 
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.


This e-mail is sent by Suncorp-Metway Limited ABN 66 010 831 722 or one of its 
related entities "Suncorp".
Suncorp may be contacted at Level 18, 36 Wickham Terrace, Brisbane or on 13 11 
55 or at suncorp.com.au.
The content of this e-mail is the view of the sender or stated author and does 
not necessarily reflect the view of Suncorp. The content, including 
attachments, is a confidential communication between Suncorp and the intended 
recipient. If you are not the intended recipient, any use, interference with, 
disclosure or copying of this e-mail, including attachments, is unauthorised 
and expressly prohibited. If you have received this e-mail in error please 
contact the sender immediately and delete the e-mail and any attachments from 
your system.
If this e-mail constitutes a commercial message of a type that you no longer 
wish to receive please reply to this e-mail by typing Unsubscribe in the 
subject line.

-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.


-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

[cfaussie] cfmamil problem

[Scott Thornton]

Hello,

I have a bunch of unprocessed mail in the C:\CFusionMX\Mail\Spool directory ( 
cfmx 6.1)

I have verified the mail connection in the cf admin.

mail can be sent from telnet on the server.

our server admins say that all looks okay their end on the postoffice etc.

my question is, what is 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 group, send email to cfaus...@googlegroups.com.
To unsubscribe from this group, send email to 
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

Re: [cfaussie] First foray into ajax

[Scott Thornton]

HI Andrew,

Thanks, that makes sense. A few more weeks and I'll have a environment of CF9 
Enterprise in a cluster to actually have somewhere to deploy. Not looked this 
stuff much as all I had was cf6.1

As an example, what I would like to do is:

User Enters a date. 
Button is clicked
Database is checked for that date.
If date is not in the db, a confirm prompt is given to the user to run a 
particular process



>>> Andrew Scott  01/04/2010 1:53 pm >>>
more than likely that is because ajax support is now built into ColdFusion
via the cfajaxproxy tag.

What are you actually looking at doing? If you can gives us some examples I
would like to try this, then we can point you in the right direction easier.
Ajax is a very brood term, but is mainly covered by the tag I mentioned
above. If your looking at doing DOM manipulation or UI work then jQuery and
extJS are good 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://ajaxcfc.com/ 
> www.ajaxcfc.com etc don't work.
>
> any idea where I can get more info about it\ an introduction?
>
> links to the pages formt he author's website http://www.robgonda.com/don't 
> work,. any posts on this site about cfajax are quite old
>

-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.


-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

Re: [cfaussie] First foray into ajax

[Scott Thornton]

Hello,

Checked out that page, and thought i'd look for examples before I downaloded to 
see what it can do etc

http://ajaxcfc.com/
www.ajaxcfc.com etc don't work.

any idea where I can get more info about it\ an introduction?

links to the pages formt he author's website http://www.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 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 enters a date
> Submit is pressed
> the /program /checks to see if the date exists in the database
> If the record exists, continue, otherwise, display a message to the user...
> If so, can anyone direct me to a resource to help me figure this out
> that combines the ajax functionality with CF calls to a database?
> I use cfmx6.1

If you just want to do ajax stuff without heavy javascript User 
Interfaces stuff then ajaxCFC is for you:
http://ajaxcfc.riaforge.org/ 

There is an example of almost exactly what you are truing to do.

If you are into javascript then you can try jquery or extjs, or wrap 
extjs in ColdExt



-- 

Yours,

Kym Kovan
mbcomms.net.au

-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.


-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

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

[Scott Thornton]

Yup, cfqueryparms can be seen in dumps of sql queries.

I guess I was referring to in particular was when an error occurs and the error 
object is used in displaying error detail. apologies for the confusion.

eg: #error.rootCause.SQL#, #error.rootCause.tagContext[1].SQL# etc.

There is no 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 March 2010 8:47 AM
To: cfaussie@googlegroups.com 
Subject: [cfaussie] CFqueryparam value's in debug output

G'day,

Is there any way to access the values for cfqueryparam's in debug output?

I am pretty sure I saw a blog entry by someone showing a modification of a
file(s) in the coldfusion directory but I cannot find it for the life of me.

I'd like to include the  query values in a 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
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 group, send email to cfaus...@googlegroups.com.
To unsubscribe from this group, send email to
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/cfaussie?hl=en.


-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.


-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

[cfaussie] CFqueryparam value's in debug output

[Scott Thornton]

G'day,

Is there any way to access the values for cfqueryparam's in debug output?

I am pretty sure I saw a blog entry by someone showing a modification of a 
file(s) in the coldfusion directory but I cannot find it for the life of me.

I'd like to include the  query values in a 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
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 group, send email to cfaus...@googlegroups.com.
To unsubscribe from this group, send email to 
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

Re: [cfaussie] RocketBoots - Galaxy

[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: 53358 p: +61 02 498 53358 m: 0413 800 242


>>> Gavin Baumanis  23/03/2010 2:01 pm >>>
Hi Everyone,

As a result of the Melbourne CFUG meeting last week, the company I
work for has decided to some development work with Robins Galaxy code.

The use-case we have for wanting to use it two fold.
Wrap an existing application into a service and consume that in a
brand new aplication.
and lastly to increase the modularity of our current application.

The last point we already do for the most part.
We write patient Management Software that is used in New Zealand and
Australia.
For the most part the applications are the same but there are some
significant differences between the two locations.

Thankfully, we already have a  separate Administration application for
each install.
We have a separate referral application for each install, etc.
But this separation was more by fluke than good design and is internal
to each install of the overall application package.
So, for example, we have 15 copies of the referral application - one
for each install.

By being service oriented, we hope to replace the 15 versions of the
referral application with two (one for AU and one for NZ).

Similarly we hope to replace the authentication processes used by our
application into a single authentication service that can be wired
into any of our applications and we thought that this service would be
a good candidate for us to use as our learning tool.

The reason for writing here is;
a) Lift the profile of the Galaxy OS project
b) Solicit input into what people see as being required in the
authentication service.

Currently we're thinking of;
 - allow user authentication via DB username / password matching
 - as above but with LDAP
 - as above but with OpenId

So our user authentication public method would have an argument for
authentication type and then subsequent arguments that would be
required for each of the suppoted authenticated types and it would
simply return a boolean for whether or not the authentication was
successful.

There is also a requirement around expired passwords / grace logins  /
intruder detection etc for directory servies enabled authentication
methods.

And if we get around to supporting Openid - then a simple boolean is
not an appropriate return.

We already have the code for this (LDAP / grace login testing /
processing) - but is it appropriate to place this code in the service
or is that best left in the "home" application.

And, of course - certainly please feel free to comletely disagree - we
don;t pretend to have all the answers.

Gavin.

-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.


-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

[cfaussie] First foray into ajax

[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 enters a date
Submit is pressed
the program checks to see if the date exists in the database
If the record exists, continue, otherwise, display a message to the user...
 
If so, can anyone direct me to a resource to help me figure this out that 
combines the ajax functionality with CF calls to a database?
 
I use cfmx6.1
 
Cheers,

 

-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

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

[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 Coldfusion 8 monitor tool built
in to the CF Administrator, does it provide much on top of the
Coldfusion 8 monitor, or is it worth just waiting till we upgrade to
Coldfusion 8?

Thanks
Barry.

-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.


-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

[cfaussie] CFREPORT and Crystal reports

[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 using the "Format" 
attribute but the documentation indicates this will only work for reports 
developed in CF Report Builder. In any case, when I supply this attribute to a 
crystal report it doesn't do anything, in fact the browser times out.

On a side note, I am moving an app to a clustered cf 9 box shortly and use 
crystal reports 11.. I was wondering if anyone had any experience in this? 
Namely will two licences of Crystal be required, one for each server and is the 
calling mechanism ( in .asp) any different?

Cheers,

Scott



-- 
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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

RE: [cfaussie] Killing Slow Threads in cf9

[Scott Thornton]

thanks for your reply charlie.



>>> "charlie arehart"  10/12/2009 10:58 am >>>
Scott, as far as I can tell, nothing has changed in the CF Enterprise Server
Monitor from 8 to 9. Both it, and FusionReactor, and SeeFusion can all
attempt to kill requests. 

Just beware: such an attempt is only that, an "attempt". There's no
guarantee it can be interrupted. If a CF request is in what's called a
native thread (that is, talking to something outside of CF, such as hung
talking to a database, doing a cfhttp, or invoking a web service, etc.) then
none of the tools can interrupt the request. 

Yes, that does mean that CF requests can hang for a very long time, indeed
indefinitely in some cases and that you can't really do anything about it.
And no, not even the CF admin timeout setting can change this. It's subject
to the same limitation. It is worth noting that putting a TIMEOUT on CFHTTTP
or CFINVOKE is a good ideas, as sometimes it can allow CF to interrupt
those. We had a discussion of that here last year, if I recall. There's also
a TIMEOUT on CFQUERY too, but it doesn't always work and depends on the
drive version, type, database, and other variables.

Finally, should anyone wonder, all this inability to timeout requests in a
native thread state is not a CF bug. It's a JVM thing. The CF "kill thread"
mechanisms above merely processes ask the JVM to terminate the thread, and
it cannot terminate 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
> 
> 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 242
> 
> 
> --
> 
> 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, visit this group at
> http://groups.google.com/group/cfaussie?hl=en.
> 


--

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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.



--

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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

[cfaussie] Killing Slow Threads in cf9

[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 242


--

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, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

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

[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 cfaussie emails again, or the list forgot 
that I unsubscribed ages ago, but I am getting cfaussie email again, so you may 
see me answer questiosn from time to time. Pretty sure I unsubscribed 
though.

cheers, 

>>>  23/11/2009 4:18 pm >>>
Hi,

 

I have a table that has duplicate records with columns of date and
description and user

 

I have a query that  groups all the records by date and the sub groups those
records by description which results in those duplicate records that were
created on the same date with the same description to be grouped together

 

The problem is that the date field has a time stamp which includes seconds
therefore the above grouping does not capture all the duplicates given the
seconds in the time stamp make many of the dates unique

 

Is there some way I can get around this so that the grouping of the query
only  looks at the date component excluding the 

time component of the date/time  stamp

 

 

Regards 

Claude Raiola 
B.Econ (Acc), B.Hot.Mngt. 

Websites: 

  www.SAMARIS.NET 

Mobile: 0414 228 948

 

--

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, visit this group at 
http://groups.google.com/group/cfaussie?hl=.



--

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, visit this group at 
http://groups.google.com/group/cfaussie?hl=.

[cfaussie] ping

[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 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 
cfaussie+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: Error 500 Page

[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 issue per se, but I was hoping
someone may have come across it and might be able to point me in the
right direction.

I work remotely and connect to our developer server via a VPN.  If I
encounter a page with an error, I get the familiar ColdFusion "Error
Occurred While Processing Request" page, with the blue background.

One of my colleagues works in the office and he only ever sees a white
page with the message:

Internal Server Error
This server has encountered an internal error which prevents it from
fulfilling your request.  The most likely cause is a
misconfiguration.  Please ask the administrator to look for messages
in the server's error log.

He is using Windows Vista, and this is happening in both Firefox and
IE.

A weird thing is I asked him to install curl and hit the page and send
me the output, and it contains the ColdFusion output I expected.  So I
suspect (but can't prove) that something between the server and his
browser is intercepting the error and replacing it with this page, but
I can't figure out what is doing it (or why).

We have tried by-passing all proxy servers in IE and FF options /
preferences but that hasn't resolved the issue

It's one of those situations where our hosting provider blames the
office network setup, and I am not even in the office but expected to
know all the answers. :-)  If anyone can offer any suggestions I would
be greatly appreciative!

Andrew.



--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] merge databases

[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_DATABASE.DBO.MYTABLE


assuming the database is on the same server.

Or you can add a linked server and reference it by

linked_server_name.NEW_DATABASE.DBO.MYTABLE

( Assuming your on MSSQL )

Cheers,



>>> "Steve Onnis" <[EMAIL PROTECTED]> 09/12/2008 2:12 pm >>>
anything cheaper?

  _  

From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Paul Kukiel
Sent: Tuesday, 9 December 2008 1:58 PM
To: cfaussie@googlegroups.com 
Subject: [cfaussie] Re: merge databases



This tool is great for merging databases.  Its expensive but there is a
trial which is fully functional:

 

http://www.red-gate.com/products/SQL_Professional_Toolbelt/index.htm 

 

Paul K.

 

From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Steve Onnis
Sent: Monday, 8 December 2008 9:55 PM
To: cfaussie@googlegroups.com 
Subject: [cfaussie] merge databases

 

I am in need of something to assist me in merging 2 databases together.  The
new database has some additional columns in a couple of the tables and it a
little bit old so i am wanting to merge the data in the old database with
the new database

 

Any suggestions/recommendations on software?

 

Steve





 








--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] PDF Generation

[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 rather difficult and finnicky.. we have a reached a 
stage where it just works, but I am not game to touch it...

we used to use the ActiveX report viewer but ran into problems about 4 years 
ago when IE started being locked down and computer policy type access stopped 
the control being installed unless an administrative account is used..  we now 
export reports to pdf and stream them to the browser via some voodoo I don't 
understand.. we probably do it a very strange out dated way I have to admit..

I would love to see how yo go about calling reports...

cheers,





>>> "CyberAngel" <[EMAIL PROTECTED]> 27/11/2008 1:14 pm >>>

Nope easy to setup too...

I am interested to know why you guys think that of Crystal Reports, I
actually find cfreport the biggest pain on this side of the universe. But
that's me:-)



--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] PDF Generation

[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, 26 November 2008 2:55 PM
To: cfaussie@googlegroups.com 
Subject: [cfaussie] Re: PDF Generation



Do the charts and content live on the same page.

 

I have used Crystal in the past it does a great job of high quality images,
cfdocument a poor job.

 

Regards

Dale Fraser

http://learncf.com  

http://flexcf.com  

 

 

From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Steve Onnis
Sent: Wednesday, 26 November 2008 2:51 PM
To: cfaussie@googlegroups.com 
Subject: [cfaussie] PDF Generation

 

I have a job where i need to populate some pdfs with data which is fine, i
can do that by injecting some fields with the information but i need to
insert some graphs and this is where i am hitting a wall.  In the past when
i have wanted to do this i would have an image and insert it like that but
the quality isnt the best.  The PDF is a financial report and it needs to be
pretty sharp.

 

Any suggestions on how i might be able to achive this?

 

So far i am looking at some way to create an inDesign file which can import
data and export the pdf from that.

 

Steve





 








--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] RegEx Banging Head

[Scott Thornton]

HI,

I like using the program named regexbuddy as it is useful to explain
what is happening, which helps in learning how to use rexex's ( I hate
them too and avoid them until its the last resort )

for example regexbuddy interprets href="([^"]+)"

as

Match the characters href=" literally «href="»
Match the regular expression below and capture its match into
backreference number 1 «([^"]+)»
   Match any character that is not a " «[^"]+»
  Between one and unlimited times, as many times as possible,
giving back as needed (greedy) «+»
Match 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:

href="([^"]+)"

I have a great eclipse plugin that helps:

http://www.brosinski.com/regex/

As I said in the WOTP presso, start with an expression that exactly  
matches an example of what you're looking for and get that working by 

escaping special characters with "\"s.  Then, _one_step_at_a_time_,  
make the expression more generic until it matches all the instances  
you're looking for.  This way you get immediate feedback about what  
broke your search.

Cheers,
Robin
  
  ROBIN HILLIARD
Chief Executive Officer
[EMAIL PROTECTED]

RocketBoots Pty Ltd
Level 11
189 Kent Street
Sydney NSW 2001
Australia
Phone +61 2 9323 2507
Facsimile +61 2 9323 2501
Mobile +61 418 414 341
www.rocketboots.com.au ( http://www.rocketboots.com.au/ )
  


On 25/11/2008, at 10:30 AM, Dale Fraser wrote:

> Ok,
>
> I suck at Regular Expressions, I dont know why, but I just dont  
> get them, someone should write a nice web based builder. I also hate 

> how CF ones are different to the rest of the world so the examples I 

> google often dont work.
>
> Ive done this before but cant get it to work this time, how do I  
> pull the url out of a href
>
> Ie
>
> http://www.ihateregex.com";>Please Click Here
>
> And I want the url from the http to the .com
>
> Regards
> Dale Fraser
> http://learncf.com ( http://learncf.com/ )
> http://flexcf.com ( http://flexcf.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?hl=en
-~--~~~~--~~--~--~---

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

[Scott Thornton]

needs scope:

text = REReplaceNoCase(string, "[[:digit:]]", "", "All");

>>> "Steve Onnis" <[EMAIL PROTECTED]> 21/11/2008 11:11 am >>>

text = REReplaceNoCase(string, "[[:digit:]]", "");
numbers = REReplaceNoCase(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 and numeric portion


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 England Area Health Service
ext: 51762 p: +61 02 491 51762 m: 0413 800 242









--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

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

[Scott Thornton]

Much :>

>>> "Steve Onnis" <[EMAIL PROTECTED]> 21/11/2008 11:11 am >>>

text = REReplaceNoCase(string, "[[:digit:]]", "");
numbers = REReplaceNoCase(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 and numeric portion


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 England Area Health Service
ext: 51762 p: +61 02 491 51762 m: 0413 800 242









--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

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

[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 England Area Health Service
ext: 51762 p: +61 02 491 51762 m: 0413 800 242



--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: threaded function that calls itself

[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 methods) that:

   - does it's thing,
   - then sleeps for a period of time,
   - then calls itself


-- 
AJ Mercer
Web Log: http://webonix.net 




--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

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

[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 relevant and returned in a shorter amount 
of time. ( also does spelling suggestions )

I suppose it is customisable, but the search result screen looks mostly like 
what you get from the google site and users are familiar and comfortable with 
it.

I don't know the details of cost etc but the more I see of it, the more I like 
it.. It works out-of-the-box i here too, which is nice from a maintenance point 
of view.

Cheers,



>>> Pat Branley <[EMAIL PROTECTED]> 19/11/2008 12:10 pm >>>

Hi Guys

I'm working on a website redevelopment that has a database using SQL
server full-text index. Ive never used it before and have always
worked with verity. I would be interested to hear about the advantages/
disadvantages of using each.

I'm also evaluating google mini and Lucene if you have any thoughts on
those too.

why im finding it hard to choose is theres no data i can find telling
me which is faster or produces more relevant results. My gut tells me
verity should be better, but i don't really know for sure. Does anyone
know of stats they could point me to ?

The other problem is that this will deploy on CF Enterprise servers in
a cluster.

Cheers

Pat





--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Referencing a query inside another query in ColdFusionMX

[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 ValueList which is now
(SelectedOrders.SalesHDRID) must be pointing to a valid query name."

'SelectedOrders' is a valid query name. So i am not sure what the
cause of error is.

Also i am writing this query in COldFusion and the backend is SQL
Server Express 2005. 'SelectedOrders' for my test cases is returning
less than 10 records. In the production environment it might return at
the max a 100 records, so valuelist shoul;d definitely work...

DOes anyone know y am i getting an error?




Steve Onnis wrote:
> SELECT salesdetail.packerid
>FROM SALESDETAIL
>WHERE SALESDETAIL.SalesHDRID IN
> (#ValueList(SelectedOrders.SalesHDRID)#)
>
> That will output all the items returned from that column into your query
>
> -Original Message-
> From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
> Of Khush
> Sent: Wednesday, 12 November 2008 9:02 AM
> To: cfaussie
> Subject: [cfaussie] Referencing a query inside another query in ColdFusionMX
>
>
> How do i reference a field (SalesHDRID) from a query (called
> SelectedOrders) in the where condition of another query.
>
> My CF query looks somewhat like this-
> SELECT salesdetail.packerid
>FROM SALESDETAIL
>WHERE SALESDETAIL.SalesHDRID IN (SelectedOrders.SalesHDRID)
>
> Now my query SelectedOrders is a really big and very complicated one,
> so I am not going to just paste it in the IN clause...If anyone has
> any ideas how to actually reference this sub query by it;s name in the
> main query above, please let me know ASAP as i need this urgently...
>
>
> THanks



--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Referencing a query inside another query inColdFusionMX

[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). You may wish to 
limit the number or rows passed to the IN clause.

You may care to use: ( an aggregate type query I think its called, but dont 
quote me)

SELECT
FROM
(  really big and very complicated query  ) AS selected_orders INNER JOIN
   SALESDETAIL sd ON
SOMETABLE .SalesHDRID = selected_orders.SalesHDRID 

a more robust approach I think.

Cheers,



>>> "Steve Onnis" <[EMAIL PROTECTED]> 12/11/2008 9:46 am >>>

 SELECT salesdetail.packerid
   FROM SALESDETAIL
   WHERE SALESDETAIL.SalesHDRID IN
(#ValueList(SelectedOrders.SalesHDRID)#)

That will output all the items returned from that column into your query

-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Khush
Sent: Wednesday, 12 November 2008 9:02 AM
To: cfaussie
Subject: [cfaussie] Referencing a query inside another query in ColdFusionMX


How do i reference a field (SalesHDRID) from a query (called
SelectedOrders) in the where condition of another query.

My CF query looks somewhat like this-
SELECT salesdetail.packerid
   FROM SALESDETAIL
   WHERE SALESDETAIL.SalesHDRID IN (SelectedOrders.SalesHDRID)

Now my query SelectedOrders is a really big and very complicated one,
so I am not going to just paste it in the IN clause...If anyone has
any ideas how to actually reference this sub query by it;s name in the
main query above, please let me know ASAP as i need this urgently...


THanks






--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] CF Maintenance purchase

[Scott Thornton]

Hi,

where do you get your prices from?

My quote is much scarier then $ up-front per CFENT licence

And based on my quote, maintenance is approx one quarter of the licence cost 
per year BTW.

Cheers

>>> "Brett Payne-Rhodes" <[EMAIL PROTECTED]> 30/10/2008 12:10 pm >>>

Sure, $5K is a significant investment depending on your circumstances.

But are you saying that the annual maintenance fee for CF is 90% of the 
purchase price? As in, CFENT costs $5,555 up front and $5,000 for maintenance 
annually? That would a bit over the top in my book. Or maybe it is 90% of the 
upgrade price? I think that would be more likely and in which case I'd say 
'place your bets!'. In reality the maintenance plans are aimed at the corporate 
end of the market where they prefer to pay an annual fee rather than have to go 
through the whole purchase process each time a new version of CF is released.

But I'm sure there are whole fields of study devoted to the question of how to 
build a sustainable business around writing software. And at the top of the 
list in terms of difficulty is to build a business around a software product 
(or products). If the initial investment to write the damn thing doesn't do you 
in, the ongoing support and maintenance probably will, and finding a way to 
entice your clients to part with more money to pay for that support and 
maintenance the hardest job of all.


B)



Steve Onnis wrote:
> CF maintenance is like 10% OFF the price so it is still a fair bit.  CFENT
> subscription is over 5k so i would want to be getting something for my money
> 
> -Original Message-
> From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
> Of Brett Payne-Rhodes
> Sent: Thursday, 30 October 2008 11:27 AM
> To: cfaussie@googlegroups.com 
> Subject: [cfaussie] Re: CF Maintenance purchase
> 
> 
> Isn't maintenance an annual charge? So you pay it each year and are covered
> from year to year for upgrades? So I don't really agree that they have
> anything to honour if you don't take out or renew your maintenance. I don't
> know what the fees are on CF but other software I have had on maintenance in
> the past has been around 10% of purchase price. In the end it comes down to
> a question of whether it is going to be cheaper to pay one or two years of
> maintenance rather than the upgrade cost from CF8 to CF9, having just paid
> for the upgrade from CFx to CF9. And of course Adobe probably hates this
> kind of speculation because the temptation is going to be for you to put off
> the upgrade until CF9 is released...
> 
> B)
> 
> 
> 
> Steve Onnis wrote:
>> I think if you purchase a subscription and nothing is released they should
>> either give you a refund or honour the next release when ever it comes
> out.
>> only fair.. 
>>
>> -Original Message-
>> From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On
> Behalf
>> Of Dale Fraser
>> Sent: Thursday, 30 October 2008 11:14 AM
>> To: cfaussie@googlegroups.com 
>> Subject: [cfaussie] Re: CF Maintenance purchase
>>
>>
>> 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] On
> Behalf
>> Of Scott Thornton
>> Sent: Thursday, 30 October 2008 10:54 AM
>> To: cfaussie@googlegroups.com 
>> Subject: [cfaussie] CF Maintenance purchase
>>
>>
>> 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: +61 02 491 51762 m: 0413 800 242
>>
>>
>>
>>
>>
>>
>>
>>
>>
> 

-- 
Brett Payne-Rhodes
Eaglehawk Computing
t: +61 (0)8 9371-0471
m: +61 (0)414 371 047
e: [EMAIL PROTECTED] 
w: http://www.yoursite.net.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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] CF Maintenance purchase

[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: +61 02 491 51762 m: 0413 800 242



--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Purchasing Enterprise

[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 
running 6.1 ) since I had anything to do with purchasing cf software.

Scott.






--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: dhtml / advanced select boxes

[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 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 have a select as you type select box query this 
rather than a database server upon every keystroke?

A link to an example would be nice..

I have seen something I like on the blizzard.com website (site has been blocked 
at work, otherwise I'd link the page.), and have done a bit of googling, but I 
don't know the correct terminology to find what I want.

Thanks,










--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] dhtml / advanced select boxes

[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 have a select as you type select box query this 
rather than a database server upon every keystroke?

A link to an example would be nice..

I have seen something I like on the blizzard.com website (site has been blocked 
at work, otherwise I'd link the page.), and have done a bit of googling, but I 
don't know the correct terminology to find what I want.

Thanks,







--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] OT : SQL server over a network

[Scott Thornton]

SQL server licences cost me nothing. Government contract :>

>>> "Steve Onnis" <[EMAIL PROTECTED]> 13/10/2008 11:41 am >>>

"just need someone to pay for CF licences"

Ill pay for your cf licenses if you pay for my sql licenses:)

-Original Message-
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 dual-core machine as our SQL server
to a dual quad-core SQL 2005 64bit cluster. Its reliable and blindingly
fast. I recall a certain report that took 15 minutes reduce to about 30
seconds. Having 32gig ram per server helped too.. our entire database is in
ram.

I am not an expert in this stuff so I probably get the terminology wrong and
am not the best person to ask.

Pretty sure its an Active-Active cluster eg There are servers named
BILLDB1 and BILLDB2 but we only know it as LIVESQL. I recall once a
windows update had hung the machine and it had failed-over to the 2nd node.
We never noticed that it had and didn't know until someone in my server-room
called to say.. Its expensive to set-up, but we can't afford to have staff
sitting around doing nothing during a technical problem. I am 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 primary to a back-up machine, would
clustering those two (and ensuring neither hits over 50% use) get the same
thing? (ie: is it worth it just for two?)

(this is putting aside the question of licenses)




On Mon, Oct 13, 2008 at 9:28 AM, Steve Onnis <[EMAIL PROTECTED]> wrote:
>
> My network is gigabit so i am hoping it wont be too bad.  The database 
> server is currently on a different system to the web server anyway. 
> What i am wanting to know is if the data is written to the MDF file as 
> quickly as it would if it was on the same physical system as the sql 
> server itself, or if there is a delay.
>
> I mean redundant as in like a seconday mail server, but sql server.  
> If one sql server goes down, the other one will kick in and take over.
>
> Stee
>
> -Original Message-
> From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On 
> Behalf Of Scott Thornton
> Sent: Monday, 13 October 2008 8:24 AM
> To: cfaussie@googlegroups.com 
> Subject: [cfaussie] Re: OT : SQL server over a network
>
>
> HI,
>
> There will be an inherent delay in DB access across a network. It will 
> only be as fast as the slowest piece of your network.
>
> That's why we put our DB databases on disks in a SAN, all connected up 
> with gigabit ethernet. Pretty much next to the database server in a rack.
>
> What do you 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 Service
> ext: 51762 p: +61 02 491 51762 m: 0413 800 242
>
>
>>>> "Steve Onnis" <[EMAIL PROTECTED]> 12/10/2008 10:39 pm >>>
> Hey guys
>
> Just curioud to know if anyone knows if there is a delay between data 
> being written to an MSSQL data file or if it is immediate.  I am 
> looking at storing the SQL data files across a network on a file 
> server and just wanting to try and find out any issues this would 
> cause if something was to happen and the sql server died.  Would the 
> data be current or is there a latency between actions and writing the data
out.
>
> Also, if anyone knows of any places to find out how to set up 
> redundant SQL servers, or if anyone has done it them or even if its
possible.
>
> Steve
>
>
>
>
>
>
>
> >
>









--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] OT : SQL server over a network

[Scott Thornton]

HI,

Its always worth it ( imho ).

A year or more ago we went from an aging dual-core machine as our SQL server to 
a dual quad-core SQL 2005 64bit cluster. Its reliable and blindingly fast. I 
recall a certain report that took 15 minutes reduce to about 30 seconds. Having 
32gig ram per server helped too.. our entire database is in ram.

I am not an expert in this stuff so I probably get the terminology wrong and am 
not the best person to ask.

Pretty sure its an Active-Active cluster eg There are servers named BILLDB1 
and BILLDB2 but we only know it as LIVESQL. I recall once a windows 
update had hung the machine and it had failed-over to the 2nd node. We never 
noticed that it had and didn't know until someone in my server-room called to 
say.. Its expensive to set-up, but we can't afford to have staff sitting around 
doing nothing during a technical problem. I am 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 primary to a back-up machine,
would clustering those two (and ensuring neither hits over 50% use)
get the same thing? (ie: is it worth it just for two?)

(this is putting aside the question of licenses)




On Mon, Oct 13, 2008 at 9:28 AM, Steve Onnis <[EMAIL PROTECTED]> wrote:
>
> My network is gigabit so i am hoping it wont be too bad.  The database
> server is currently on a different system to the web server anyway. What i
> am wanting to know is if the data is written to the MDF file as quickly as
> it would if it was on the same physical system as the sql server itself, or
> if there is a delay.
>
> I mean redundant as in like a seconday mail server, but sql server.  If one
> sql server goes down, the other one will kick in and take over.
>
> Stee
>
> -----Original Message-
> From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
> Of Scott Thornton
> Sent: Monday, 13 October 2008 8:24 AM
> To: cfaussie@googlegroups.com 
> Subject: [cfaussie] Re: OT : SQL server over a network
>
>
> HI,
>
> There will be an inherent delay in DB access across a network. It will only
> be as fast as the slowest piece of your network.
>
> That's why we put our DB databases on disks in a SAN, all connected up with
> gigabit ethernet. Pretty much next to the database server in a rack.
>
> What do you 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 Service
> ext: 51762 p: +61 02 491 51762 m: 0413 800 242
>
>
>>>> "Steve Onnis" <[EMAIL PROTECTED]> 12/10/2008 10:39 pm >>>
> Hey guys
>
> Just curioud to know if anyone knows if there is a delay between data being
> written to an MSSQL data file or if it is immediate.  I am looking at
> storing the SQL data files across a network on a file server and just
> wanting to try and find out any issues this would cause if something was to
> happen and the sql server died.  Would the data be current or is there a
> latency between actions and writing the data out.
>
> Also, if anyone knows of any places to find out how to set up redundant SQL
> servers, or if anyone has done it them or even if its possible.
>
> Steve
>
>
>
>
>
>
>
> >
>




--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] OT : SQL server over a network

[Scott Thornton]

Hi,

Typically the install configuration would have your CF server and your Db 
server separate anyways.

I think from memory you will find that SQL server will write to your log first, 
and then to the physical database table. So don't forget to place your log on a 
fast disk\network as well.

The scenario you describe that another sql server will 'kick in' can be dealt 
with in a number of scenarios.

Hardware clustering of your SQL servers for example will allow another to kick 
in if one server stops. Each solution has its benefits and pitfalls. Many of 
them being cost $$.

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 Thornton, Programmer
Billing Unit, Hunter-New England Area Health Service
ext: 51762 p: +61 02 491 51762 m: 0413 800 242


>>> "Steve Onnis" <[EMAIL PROTECTED]> 13/10/2008 10:28 am >>>

My network is gigabit so i am hoping it wont be too bad.  The database
server is currently on a different system to the web server anyway. What i
am wanting to know is if the data is written to the MDF file as quickly as
it would if it was on the same physical system as the sql server itself, or
if there is a delay.

I mean redundant as in like a seconday mail server, but sql server.  If one
sql server goes down, the other one will kick in and take over.

Stee

-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Scott Thornton
Sent: Monday, 13 October 2008 8:24 AM
To: cfaussie@googlegroups.com 
Subject: [cfaussie] Re: OT : SQL server over a network


HI,

There will be an inherent delay in DB access across a network. It will only
be as fast as the slowest piece of your network.

That's why we put our DB databases on disks in a SAN, all connected up with
gigabit ethernet. Pretty much next to the database server in a rack.

What do you 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 Service
ext: 51762 p: +61 02 491 51762 m: 0413 800 242


>>> "Steve Onnis" <[EMAIL PROTECTED]> 12/10/2008 10:39 pm >>>
Hey guys
 
Just curioud to know if anyone knows if there is a delay between data being
written to an MSSQL data file or if it is immediate.  I am looking at
storing the SQL data files across a network on a file server and just
wanting to try and find out any issues this would cause if something was to
happen and the sql server died.  Would the data be current or is there a
latency between actions and writing the data out.
 
Also, if anyone knows of any places to find out how to set up redundant SQL
servers, or if anyone has done it them or even if its possible.
 
Steve










--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

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

[Scott Thornton]

HI,

There will be an inherent delay in DB access across a network. It will only be 
as fast as the slowest piece of your network.

That's why we put our DB databases on disks in a SAN, all connected up with 
gigabit ethernet. Pretty much next to the database server in a rack.

What do you 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 Service
ext: 51762 p: +61 02 491 51762 m: 0413 800 242


>>> "Steve Onnis" <[EMAIL PROTECTED]> 12/10/2008 10:39 pm >>>
Hey guys
 
Just curioud to know if anyone knows if there is a delay between data being
written to an MSSQL data file or if it is immediate.  I am looking at
storing the SQL data files across a network on a file server and just
wanting to try and find out any issues this would cause if something was to
happen and the sql server died.  Would the data be current or is there a
latency between actions and writing the data out.
 
Also, if anyone knows of any places to find out how to set up redundant SQL
servers, or if anyone has done it them or even if its possible.
 
Steve




--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: Adobe AIR Weather Widget

[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 
monitors...

There is a AIR weather widget icon n my desktop, but clicking on it does 
nothing

by accident I see a little "Low 0 celcius " hidden beneath my icons on the top 
left of my desktop, and notice a settings button\widget\gear icon when I hover 
my mouse of the area in general.

Clicking on the settings button I get an option windows, and I typed in the 
Sydney code below. nothing happens.

Soo, I cant move the window ( if there is one), and can barely see it.

Perhaps I am doing something wrong? I am behind a firewall that requires 
authentication prompts...

( Screenshot attached)



>>> Chris Ellem <[EMAIL PROTECTED]> 10/10/2008 10:55 am >>>

If anyone is interested in AIR application I wrote a little one
recently

weather codes

//melbourne.ASXX0075
//brisbane..ASXX0016
//townsvilleASXX0117
//sydneyASXX0112
//perth.ASXX0089
//tampere/finland..FIXX0031


you will need the AIR runtime from adobe

http://get.adobe.com/air/ 

the application is located here

http://www.flexfactory.com.au/air/fsi_weather.zip 

feel free to pass on or post any comments so i can make it better


Regards

Chris Ellem





--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

<>

[cfaussie] Re: Version control + ColdFusion development

[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 am >>>

Hi everyone,

Setup: Windows environment, IIS, CF7, Eclipse

I'm looking to apply version control to a website I'm working on and
would appreciate any recommendations on how best to set everything up
in regards to version control + CF coding.

If you can't be bothered to ready the long winded post below than a
snapshot of your version control + CF dev setup would be helpful e.g.
when do you tag, branch etc and how do you get versions live to
production?

Question: I've install Subversion etc and am at the point where I've
got a repository setup on a shared server with a fresh copy of the
website code "as of today" in the trunk and I've tagged it as version
1.0. I've then checked it out (should I checkout the tag or the trunk
by the way?) and all works perfectly ready to start / edit code.
However I'm looking for advice on when to branch / tag? The added
complication is that I'm often working on multiple projects involving
this one website (e.g. whilst waiting for QA testing on one project or
waiting on resources etc) so how do you tackle this?

Perhaps some examples will help:
One of my current tasks is to migrate the website from MySql to Sql
Server. All the database work has been done so all I need to do now is
modify several queries throughout the website. In this instance would
you create a branch (v1.0.1) from the tag (v1.0) and checkout this new
branch? I've tried this and checkout out branch 1.0.1 into a new
Eclipse project but this of course has created a new directory and
therefore my development environment doesn't point at this project
folder. So would you reconfigure CF, IIS etc to all point to this new
folder whilst working on this branch?
Lets say in a few days time this branch is ready to go and is with the
QA department and I want to crack on with another project for this
website so would I create branch v1.0.2 and check this out into
another Eclipse project and therefore have to reconfigure all my dev
environment settings? Lets say v1.0.2 is approved before v1.0.1 so
would you pust v1.0.2 live to production server and the merge v1.0.1
and v1.0.2 into v1.0.3 in order to get v1.0.1 changes live?

Perhaps this example of working on 2 or more projects is a little
unusual so lets try a more common scenario: lets say you've got a team
of 3 developers. Each developer is assigned a project so would you
create 3 branches (one for each)? They go off and program away
(checking in their code to the trunk each night) and the first one
comes back and is finished. So you test etc and then are ready to live
so would you tag his branched version as v1.0.1 at this point? Then
developer 2 finishes so you test etc and are ready to go live so would
you checkout the tagged version v1.0.1, merge in his branch, test
again and than tag the combined version as v1.0.2?

A few other questions;
- I assume that the Repo administrator would be in charge of creating
branches / tags etc? The developers are just told the name of the
branch that they should checkout and instruct them to checkin their
changes to the trunk each night?
- How do you get a stable version (or "tagged" version) live to the
production server?!?!? Do you simple checkout a tagged version and
then FTP it up to the production server?

Cheers
Matthew



--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: Quick List question

[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,

>>> "Andrew Scott" <[EMAIL PROTECTED]> 10/09/2008 3:07 pm >>>
I thought this had been fixed at some point, anyone recall how to overcome
this?

 

 

myfile = FileOpen("#ExpandPath(test.csv')#", "read");

while(NOT FileisEOF(myfile)) {

x = FileReadLine(myfile); // read line

 

for(Counter=1; Counter lte ListLen(x);
Counter++) {

WriteOutput("#Counter#:
#ListGetAt(x, Counter)# ");

}

WriteOutput("");

}

FileClose(myfile);



 

As a test, one of the CSV columns is wrapped in double quotes. Coldfusion is
still ignoring these quotes, have I missed something somewhere somehow?

 

 

 

 

-- 
Senior Coldfusion Developer
Aegeon Pty. Ltd.
  www.aegeon.com.au 
Phone: +613 9015 8628
Mobile: 0404 998 273

 

 

 





--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: Grouping Output By Date Not working

[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 <[EMAIL PROTECTED]>, Claude Raiola 
>>> <[EMAIL PROTECTED]> wrote:
I am trying to group my cfquery output by date however as the values the date 
column also include the time stamp this is causing a problem.

Is there a way that i can make the query only group by the date portion of the 
datetime stamp as this will then allow me to group all records of the same date 
together  and then sort said grouped records by the complete date value which 
includes the date value.


select starttime, [from] as sentfrom, endtime, subject, duration, location, 
message, organizer, htmlmessage, requiredattendees
from mycalendar
group by starttime, endtime, subject, sentfrom, duration, location, message, 
organizer, htmlmessage, requiredattendees
order by starttime 



Regards 

Claude Raiola 
B.Econ (Acc), B.Hot.Mngt. 

Websites: 
www.AustralianAccommodation.com 
www.SAMARIS.NET 
www.WebSiteSolutions.com.au 
Mobile: 0414 228 948 





http://groups.google.com/group/cfaussie?hl=en
-~--~~~~--~~--~--~---