[cfaussie] MySQL - date insertion issues.

Hi Everyone, I have the following code; form.date : #form.datelisted#br / LSDATEFORMAT : #lsdateformat(form.datelisted, '-MM-DD')#br / DATEFORMAT : #dateformat(form.datelisted, '-MM-DD')#br / CREATEODBCDATE : #createodbcdate(form.datelisted)#br / CREATEODBCDATETIME :

[cfaussie] Re: MySQL - date insertion issues.

HI Steve, Thanks for the email. I checked the region settings on my Laptop and have ensured myself that the OS settings are correct for Australia. Doing some work with Mr. Google I found this CFML code; this.locale=SetLocale(English (Australian)); Which enables LSDateFormat to create a correct

RE: [cfaussie] ColdFusion Builder 2 hotfix #1 now available...

Andrew, just wanted to let you know I had raised your concern the day you raised it to a private list of Adobe Community Professionals (that includes some others here, as well as folks at Adobe, including the new product manager). Some noted that it was related to the licensing engine Adobe

Re: [cfaussie] ColdFusion Builder 2 hotfix #1 now available...

Hey Charlie, Does sound like a cop out to me, if you mean licensing as through the Eclipse update or licensing through the CFB update would be good to know the difference here. The last time I raised it was because it would have been better to use the Eclipse update, so lets wait and see what

Re: [cfaussie] Re: CreateObject of itself

Paul, I am going to correct you here. When creating the constructor, whether it be init or initmethod=whatever you can return the object type. public testComponent function() { } Also notice that I didn't include the return this, because in ColdFusion 9 this will work without it. What you can't

[cfaussie] CF9 Event Gateway

Hi, I am wanting to be able to build a CF application that will accept incoming data sent over gprs from multiple devices in the field to have said data be captured and then stored into sql database Does the CF gateway work as the listener on the server to the assigned port ?? Can

RE: [cfaussie] CF9 Event Gateway

Are you going to be writing your own application on the mobile device to connect to the CF server? From: rai...@ozemail.com.au [mailto:rai...@ozemail.com.au] Sent: Wednesday, 20 July 2011 11:42 AM To: cfaussie@googlegroups.com Subject: [cfaussie] CF9 Event Gateway Hi, I am wanting to

[cfaussie] cfaussie] CF9 Event Gateway

Hi Steve, No the mobile devices are already programmed with the firmware to send out the relevant data using a pre defined schema for each different piece of data, the firmware on the mobile devices is able to be configured to specify the back end server IP and port that it needs to send the

RE: [cfaussie] cfaussie] CF9 Event Gateway

What is the port? Cant you just use HTTP? From: rai...@ozemail.com.au [mailto:rai...@ozemail.com.au] Sent: Wednesday, 20 July 2011 12:05 PM To: cfaussie@googlegroups.com Subject: [cfaussie] cfaussie] CF9 Event Gateway Hi Steve, No the mobile devices are already programmed with the

Re: [cfaussie] cfaussie] CF9 Event Gateway

The SocketGateway is your friend for this. An instance of it basically listens and responds to TCP/IP port traffic on a port you can define. As a general rule of thumb: - If you want to use one of the existing EG types (e.g. you're setting up an instance) - you'd usually be writing CF code for

[cfaussie] cf.Objective(ANZ) + Flex 2011: Call for speakers

The only Australian and New Zealand conference aimed specifically at the hardcore* end of ColdFusion development is back in 2011. This year it gets better: Additionally to the already awesome double-ColdFusion-track goodness, we're adding a dedicated Flash Platform/Flex track. Let's repeat

RE: [cfaussie] MySQL - date insertion issues.

Do this #createodbcdatetime(createDate(mid(form.datelisted, 7, 4), mid(form.datelisted, 4, 2), mid(form.datelisted, 1, 2))# Dale -Original Message- From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Gavin Baumanis Sent: Wednesday, 20 July 2011 12:05 AM To:

[cfaussie] ColdFusion Builder 2 Hotfix

Get this when trying to install Not sure, why I now need a JVM. I managed to install the builder without a JVM. Regards Dale Fraser http://dale.fraser.id.au http://dale.fraser.id.au http://cfmldocs.com http://cfmldocs.com http://learncf.com http://learncf.com

[cfaussie] Re: ColdFusion Builder 2 Hotfix

Hi Dale, There is a JRE as part of eclipse. I assume it is complaining about that. I am not trying to be insulting, but I assume you have tried the usual suspects? * Re-downloading the patch? * Applying the patch to a different CFBuilder install? * Creating a new workspace first? I don't have a

[cfaussie] Re: MySQL - date insertion issues.

Hi Everyone, And thanks to you all for replying... Upon reflection my initial email wasn't very good. I have postgresql and mysql installed. Using postgresql; (ls)dateformat(DATE,-MM-DD) both correctly insert a eurodate into the database. I am trying to do something with mysql on the same