cfset wsURL = http://
mywebservicepath/jira/rpc/soap/jirasoapservice-v2?wsdl
cfset CreateObject( java, coldfusion.server.ServiceFactory
).XmlRpcService.RefreshWebService(wsURL) /
Something like this will refresh the webservice if cached dont think this is
supported but can be used to help debug.
Hi,
I am overloaded with work atm and have a Sydney based large client we
have implemented a farcry site for. They require 3 more phases - an
intranet, a sales tracking system and a simple read only extranet all
based on farcry. I would imagine the work to be about 20K or so but
that would be up
Mike,
Setup a blank access db - link tables to myob using a ODBC connection.
Check the case sensitivity on the tables within myob after linking. Run
queries using the access db then port them into CF once successful.
Worked this way for me.
Hth
Rod
-Original Message-
From:
Hi,
Not sure what is happening this month but we have had very little
interest in this month's meeting for BMUG, as such we will postpone to
next Thursday the 22nd of November to see if more coders crawl out
into the daylight. Please if your are interested in coming along let
us know. We
BMUG November Meeting Details
Just a reminder the BMUG meeting is this Thursday, 12th of November,
at the usual place for a 6.30pm start. Details can be found on the
www.bmug.org.au site for more info including a location map. This
month there will be a tshirt giveaway and also tickets for the
15th?
regards
Mizdog!
On Nov 12, 2007 2:36 PM, rod higgins [EMAIL PROTECTED] wrote:
BMUG November Meeting Details
Just a reminder the BMUG meeting is this Thursday, 12th of November,
at the usual place for a 6.30pm start. Details can be found on the
www.bmug.org.au site for more
], [res2], [res3])) AS pvt
ORDER By Convert(DATETIME,'01'+sDate,13)
If you can provide the tables and columns in your access db then someone
of the list may be able to write the sql code.
Hth
Rod Higgins
WebDaemon
www.webdaemon.com.au
-Original Message-
From: cfaussie@googlegroups.com
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On
Behalf
Of Rod Higgins
Sent: Wednesday, 26 September 2007 12:13 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: VBA crosstab query --- coldfusion query
Hi Maureen,
From the ms developer forums -:
Two
.
Cheers
Rod Higgins
BMUG Organiser.
--~--~-~--~~~---~--~~
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
The second ever BMUG meeting will occur this Wednesday evening, so those of
you living out West or in the Blue Mountains come along and spend some time
networrking and discussing the new release of CF. Finger food
and refreshments will be provided and maybe a lucky door prize or two. The
meeting
I'm going through the joys or converting an MS SQL app onto an Oracle
platform. The app uses MG, Reactor with Coldspring and I'm having a few
issues setting up the config file for reactor to behave with oracle tables.
Do I have to prefix tables in oracle using oracleuser.mytable, etc.? With
the
:* cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] *On
Behalf Of *Rod Higgins
*Sent:* Tuesday, 24 July 2007 5:56 PM
*To:* cfaussie@googlegroups.com
*Subject:* [cfaussie] Reactor using oracle
I'm going through the joys or converting an MS SQL app onto an Oracle
platform. The app uses MG, Reactor
cf_bmugplug
wouldn't it be nice to run an air desktop app that talks back to a modified
lighthouse pro application that records time on projects in seconds ... come
to the BMUG meeting in either August or September (depending on what is
happening on the August 8/8 cfug meeting .. interesting
@googlegroups.com [mailto:[EMAIL PROTECTED] *On
Behalf Of *Rod Higgins
*Sent:* Tuesday, 24 July 2007 6:25 PM
*To:* cfaussie@googlegroups.com
*Subject:* [cfaussie] Re: open source time tracking app
cf_bmugplug
wouldn't it be nice to run an air desktop app that talks back to a
modified
Your a bit late Mike ... Not sure why this is posted so late but please
ignore it. The next meeting is scheduled for early August.
On 7/9/07, Mike Kear [EMAIL PROTECTED] wrote:
The first meeting of the CF User Group in Western Sydney is going to
be held in Penrith tonight, starting at 6pm.
Hi Charlie,
I must say your Hidden Gems in CF8 is a great way to wet ones appetite
on CF8. I would also like to thank you on your work with the UGTV site -
it really is a wonderful resource and I would recommend all having a
look.
Sorry all for the cross post, I'm having issues creating new
This email is a call for presenters for the first CFUG meeting in
Western Sydney / Blue Mountains. We have set a date of Monday the 9th
of July with a 6.00pm start, location details below. At this stage we
have 9 confirmed developers attending with hopefully a few more roll
ups. If you wish to
it depends
on the client and their budget. A lot of smaller ones are happy to test
their own applications.
Hth
Rod Higgins
T +61 2 8207 8916
M +61 2 410 684 609
E [EMAIL PROTECTED]
W http://www.webdaemon.com.au
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED
Yup we are interested. Count us in (x3 developers), that makes 4. I was
interested last time this was raised about 3 years ago and can provide the
venue if required. The conference room can hold about 20 ppl comfortably,
wireless internet available. If enough interest is around we might spring
Why bother making a comment like that when it adds no value whatsoever to
the discussion? There are a multitude of reasons why a webservice may not
either be allowed, be possible or even be preferred to be used.
Thanks for the input Simon I've always wondered how an ABN was generated.
, PHP, ASP, ASP.NET hosting from AUD$15/month
On 4/4/07, Nathan Drury [EMAIL PROTECTED] wrote:
Rod
What error message do you get back? I'm having difficulties with COM
at the moment too and will post about them here.
On Apr 3, 5:19 pm, rod higgins [EMAIL PROTECTED] wrote:
Hi,
I'm
Trying to create a date of 0001/01/01 is alot of fun in CF - I cant
seem to create one using createdate(). I imagine Tom you will have to
use something like the code below to generate a reference date to
compare the integers against.
cfset mydate = createdate(1962,2,2)
cfset refdate = dateadd(d,
What SQL db are you using?
On Apr 3, 7:04 pm, Rei [EMAIL PROTECTED] wrote:
Evening all,
I am trying to retrieve WDDX packet stored in an ntext field of table
x in my trusty SQL db. The charLength of said WDDX packet is approx
7.
CFWDDX ACTION=WDDX2CFML INPUT=#bigPacket# OUTPUT=xStruct
I can't see a bug at all. The dateformat function simply diplays the
last two digits of the year of the date as it should. It the date is
stored as 9.4.3866 you would expect a display of 9.4.66 wouldn't you?
What I want to know is why #dateformat(1,d.m.)# is 31/12/1899
and not 1/1/900 ??
On
refer back to Karen's previous entry and then follow up the
joelonsoftware link, about halfway donn the joelonsoftware post. it might
help
On 4/4/07, rod higgins [EMAIL PROTECTED] wrote:
I can't see a bug at all. The dateformat function simply diplays the
last two digits of the year of the date
I disagree I think certification is looked upon quite well by employers and
is well worth the effort.
My2c.
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Dale Fraser
Sent: Wednesday, 4 April 2007 2:58 PM
To: cfaussie@googlegroups.com
Subject:
/
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Rod Higgins
Sent: Wednesday, 4 April 2007 3:37 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Affordable Flex Training
I disagree I think certification is looked upon quite well by employers
It simply might mean the CF server can not connect to the mail server, the
email address might be completely valid. If CF runs through the list of
configured mail servers and can't connect to any of them it will shift the
mail to the undelivered directory.
my 2c.
-Original Message-
Sorry forgot the URL
http://www.adobe.com/devnet/coldfusion/articles/mail_61_03.html
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Andrew Scott
Sent: Tuesday, 27 March 2007 5:47 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: How to
Sent: Wednesday, 28 March 2007 10:15 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: How to send out undelivered cfmails?
Thanks for the explanation. My problem is how to deliver these undelivered
mails to the mail server again.
On 27/03/07, Rod Higgins mailto:[EMAIL PROTECTED]
[EMAIL
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: How to send out undelivered cfmails?
i wouldnt use COPY, rather use MOVE. you dont want duplicates going back
into the undelivered folder
_
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Rod Higgins
Sent
What was recorded in the mail logs? Can you verify the connection to the
mail server from within cf admin?
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
cfaussie group.
To post to this group, send email to
This has to do with coldfusion how?
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of mrEscher
Sent: Tuesday, 20 March 2007 1:50 PM
To: cfaussie
Subject: [cfaussie] Re: SOT: Local domain names
Heh,
I'm back on cfaussie after a couple of years
SELECT T.TABLE_NAME AS [Table], C.COLUMN_NAME AS [Column],
C.IS_NULLABLE AS [Nulls], C.DATA_TYPE AS [Type]
FROM INFORMATION_SCHEMA.Tables T JOIN INFORMATION_SCHEMA.Columns C
ON T.TABLE_NAME = C.TABLE_NAME
WHERE T.TABLE_NAME NOT LIKE 'sys%'
AND T.TABLE_NAME 'dtproperties'
AND T.TABLE_SCHEMA
2007 3:23 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: OT: SQL Server Schema
Thanks Rod. Thats a great start.
Brian
_
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Rod Higgins
Sent: Monday, 19 March 2007 2:17 PM
To: cfaussie@googlegroups.com
Subject
Can you post your full code that you have put together to now?
On Mar 7, 3:55 pm, Duncan [EMAIL PROTECTED] wrote:
Thanks Andrew, I can see what this does, but I dont understand it all
enough (and the differences between your code and mine) to mash it
into what I need.
So I have managed to
Anyone know of a reliable cross browser combo box ui component? No
flash or ajax just simple js will be fine (ajax renders too slowly for
large lists). Needs to be the same as a VB type combobox, single input
box with autocomplete and a simple drop down list filtered by the
characters typed in.
If you use the java class and methods that handle these types of
numbers I don't see the problem??
cfloop from=1 to=1000 index=i
cfset diff = CreateObject(Java, java.math.BigDecimal).init(0.1)
cfset a = CreateObject(Java,
java.math.BigDecimal).init(RandRange(100,1))
Wouldn't the lat and long be the same for both?
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Mike Kear
Sent: Wednesday, 15 November 2006 12:31 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: [OT] Calculate distance with long/lat
Insert into dbTwo.Users
Select *
From dbOne.Users
Where firstname + lastname
not in (select firstname + lastname from dbTwo.Users)
Or something like it.
Hth.
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Barry Beattie
Sent: Tuesday,
Froman image / button onclick=window.open('mylocation.cfm'); ?? Or on a
new page body onload=window.open('mylocation.cfm'); is that the sort of
thing your looking for?
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Mike Kear
Sent: Monday, 23
Title: Message
What are ppl
using to generation images on the fly? I have an old app using the batik api to
create images from SVG content using the
org.apache.batik.apps.rasterizer.SVGConverter class. What are ppl currently
using and what are the pros and cons with each
approach?
tia
Rod
.. Though I do like
alagad Being written in java.. (and is free)
Im gagging to see what adobe do with image manilpulation functionality in
CF8..
Cheers,
Adam
From: Rod Higgins [mailto:[EMAIL PROTECTED]
Sent: Thursday, 12 October 2006 12:56 PM
To: cfaussie
-summary.html)rather than go directly to the jpeg encoder / decoder.
I suppose its a question of what you need?I'm sure there are some Javalibs out there that already do what youmay want, no?MarkOn 10/12/06, Rod Higgins
[EMAIL PROTECTED] wrote: Im almost sure Adobe will end up using some
Maybe separate the processes into two different scripts? One to
generate the PDF and write to disk the other to email and remove from
disk? Maybe set up a batch process - ie group the emails into batches
of 500 or so? Creating a lot of pdf's does chew up memory. The only
other thing is maybe send
select * from dbTable
where CustomerID not like '%bn%'
--~--~-~--~~~---~--~~
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,
sorry missed the first two characters bit ...
select * from dbTable
where CustomerID not like 'bn%'
or
select * from dbTable
where left(CustomerID, 2) 'bn'
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
Firstly if the SQL platform is pre 2005 the service is hardly built in.
Secondly if the column is indexed and the like statement starts with a
character not a wildcard the index will be used. Why will this lead to
a meltdown? If a wildcard (underscore etc) is the first character a
full table scan
Title: Message
Hi,
Is there anything in open source written in coldfusion that can compare to
KnowledgeTree which is written mostly in php? Basically looking for a document
management system other then farcry that is open source which can be built upon.
TIA
Rod
Hi,
Is there anything in open source written in coldfusion that can compare to KnowledgeTree which is written mostly in php? Basically looking for a document management system other then farcry that is open source which can be built upon.
Anyone?
TIA
Rod
Title: Message
numberformat(mynumber, '9.999')
hth
Rod
-Original Message-From:
cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of
Tom MacKeanSent: Monday, 18 September 2006 11:43
AMTo: cfaussie@googlegroups.comSubject: [cfaussie]
decimal places
Hi
CFQUERY datasource=#DSN# name=SESSION.SECTOR
SELECT
SB_SECTOR_ID,
SB_SECTOR_DESC
FROM
SB_SECTOR
ORDER BY
SB_SECTOR_ID
/CFQUERY
cfoutput query=SESSION.SECTOR
cfset FORM.EXTRACT_DATE_TO = '01-jan-1990'
cfset FORM.SB_SECTOR_ID = SB_SECTOR_ID
!--- Run program for each sector ---
Startting
CFQUERY datasource=#DSN# name=SESSION.SECTOR ??
- Original Message -
From: Scott Thornton [EMAIL PROTECTED]
To: cfaussie@googlegroups.com
Sent: Thursday, August 31, 2006 3:44 PM
Subject: [cfaussie] Multiple calls of the same page
Hi,
I want to call a certain page (in a cf schedule)
the company behind PHP.
Regards
Dale Fraser
http://dale.fraser.id.au
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On
Behalf
Of Rod Higgins
Sent: Wednesday, 30 August 2006 11:01 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Why buy
If it is valid and well formed and meets the dtd
requirements why is it your problem? If you have to, you can run the xml through
a xslt and produce any particular output format.
my half a cent
Rod
- Original Message -
From:
Andrew Mercer
To: cfaussie@googlegroups.com
on the
change
in production).
Let us know how it goes.
/charlie
http://www.carehart.org/blog/
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On
Behalf
Of Rod Higgins
Sent: Sunday, August 20, 2006 9:13 PM
To: cfaussie@googlegroups.com
Subject
could see
thanks for all the help guys.
- Original Message -
From: Rod Higgins [EMAIL PROTECTED]
To: cfaussie@googlegroups.com
Sent: Tuesday, August 22, 2006 10:07 AM
Subject: [cfaussie] Re: Access Lock File
Hi Charlie,
When I create the datasource I turn off the maintain
to design my app in a manner that didn't
require DB creation stuff in an Access file. Main reason I move to
SQL.
Chad
On 8/21/06, Rod Higgins [EMAIL PROTECTED] wrote:
Hi,
Currently I am having major issues with creating an MS Access with
Unicode
datasource via the CF admin api
side.
Chad
On 8/21/06, Rod Higgins [EMAIL PROTECTED] wrote:
Hi Chad,
Im using access to dump very small sections of data from a much larger
SQL
database so users can download the access db and run ad hoc reports
from
it.
I am not using access as a primary datasource
Off the top of my head ...
cfset myfile="c:\outfile.gzip"cfset
myString="This is a sample string."
cfscript// Create the GZIP
output stream fileOut =
createobject("java",
"java.io.FileOutputStream").init(myfile);
out = createobject("java",
http://www.intersuite.com/client/index.cfm/2005/11/15/ColdFusion-Tip-Using-the-included-webcharts3d-engine-in-CFMX-7
and then
http://www.webcharts3d.com/website/WebCharts50/products/developer.pdf
looks cheap to me??
On 8/8/06, Dale Fraser [EMAIL PROTECTED] wrote:
It's webcharts3d bit pricy
/7/htmldocs/1442.htm),
you can't use cfchart in cfdocument.
On 8/8/06, Chris Velevitch [EMAIL PROTECTED] wrote:
On 8/8/06, Rod Higgins [EMAIL PROTECTED] wrote:
WebCharts 5.0 executable jar file is called from a bat file here ...
cfmx-install\CFusionMX7\charting\webcharts.bat
Connecting to SQL 2005 with EM is not
supported.
http://msdn2.microsoft.com/en-us/library/ms174190.aspx
http://msdn2.microsoft.com/en-us/library/ms173738.aspx
I would suggest installing the SQL Server Management
Studio that ships with SQL server 2005. It can administer SQL 2000
as well
One thing I have always wondered on this list is why developers limit
themselves to only cfml? Sure cfml is a great language that is easy to
learn but vbscript, php, .Net, jsp, svg, even vrml all have their place in
the development realm - well maybe not vrml anymore. Why not just learn as
much
Hi Dmitry,
So your trying to say there is no point in learning a new language unless
your a guru at it? How does one become at guru at any language (or surgery
for that matter) unless they start learning and using it at the beginner's
level? I'm not quite sure what your trying to say here? My
I've used POI successfully before. The other option is too create the word
document save it as html then use CF to create the same html and save as a
.doc file. If the application's users have Office 2003, xml might be an
option as well.
All options work it just depends on your needs.
-
When running a page that uses excessive QofQ from a
single query the CPU goes bezerk. I was under the impression that QofQ was
simply accessing a recordset from memory.I have a couple of questions if
anyone has some ideas,workarounds for this. Why does the cfstat utility
record QofQ's as DB
Hi Joel,
The reason Im using QofQ firstly is because Im lazy
and secondly because Im using a lot of date/time matching from the source
recordset. The source recordset has about 160 odd records so it's not that
large. What I am finding though is QofQ is not really that efficient. I was
Im checking 30 minute increments (datetime)on
a date column so Im using the QofQ to determine whether a record exists within a
certain start and end time. I will more then likely create an arrayfrom
the date column and then test against this. I had thought QofQ would be the more
elegant
cfset thisPath=ExpandPath(/)
cfset rootDirectory=GetDirectoryFromPath(thisPath)
or am I missing something?
- Original Message -
From: Scott Thornton [EMAIL PROTECTED]
To: cfaussie@googlegroups.com
Sent: Thursday, June 22, 2006 12:17 PM
Subject: [cfaussie] Path to the site root
http://www.activsoftware.com/mx/undocumentation/query.cfm
Found this on google, interesting reading. I dont know where they got that
java code from??
hth
Rod
- Original Message -
From: Barry Beattie [EMAIL PROTECTED]
To: cfaussie@googlegroups.com
Sent: Thursday, June 15, 2006 11:55
Hi,
Anyone know of an Australian based currency
conversion webservice, preferably free.
Thanks in advanced.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to
cfscript sessionTracker = createObject(java, coldfusion.runtime.SessionTracker);
// once created maybe something like the cleanUp() function
// but it depends on how your ending thesessions sessionTracker.cleanUp();/cfscript
cfdump var=#sessionTracker#
This might send you on the right path
cfset myArray =
listtoarray("server1,server2,server3")
cfdump var="#myArray#"
cfscriptarrList =
createobject("Java","java.util.ArrayList");for (i = 1; i LTE
arrayLen(myArray); i = i + 1)temp =
arrList.add(myArray[i]);strArray =
arrList.toArray();/cfscript
cfdump var="#strArray#"
Looks
You need to take out the toArray() call from within
the loop. Add all of the items into the arrayList then convert to a String[]
try
{myServerArray = listToArray( getServer()
);ArrayList = createobject( "java", "java.util.ArrayList"
);for ( i = 1; i lte arrayLen( myServerArray ); i = i
Depending on what is returned from getServer() you might want to also change this
line also...
ArrayList.add(
myServerArray[ i ] );
to
ArrayList.add(
myServerArray[ i ].toString() );
- Original Message -
From:
Taco Fleur
To: cfaussie@googlegroups.com
Sent:
The certification exam tests a lot more then just CF syntax, if it did it
would be of little value. From my experience only about 60% of the exam
focused on cf syntax type questions. The rest was on evaluating code and
general web 'assumed knowledge' type questions.
I think the certification
Anyone know of a port of Safari for windows? Or even something that
will emulate it?
--~--~-~--~~~---~--~~
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
I wish. But the client I'm working for has a general manager that just
loves mac's and of course loves safari. kind of a showstopper if the code
doesnt work on a mac.
Here's an idea.
Don't support safari.
Catering to such a small minority is a waste of time. Get the mac users to
use a
I'd also be interested to know what people generally use for installing web
apps as well.
- Original Message -
From: cfgroupie [EMAIL PROTECTED]
To: cfaussie cfaussie@googlegroups.com
Sent: Wednesday, March 08, 2006 12:11 PM
Subject: [cfaussie] Installer 4 ColdFusion
Hi Guys,
I'm
80 matches
Mail list logo
