[cfaussie] Re: Why buy into CF?

2006-09-04 Thread cfgroupie
An Ad i found in seek this morning. This is what I have to deal with everyday at work. A financially secure, ASX listed company who provides IT services to organisations of all sizes across the Asia Pacific region, is seeking an experienced ColdFusion/.Net Developer. Working in a team

[cfaussie] Re: Why buy into CF?

2006-09-04 Thread Barry Beattie
aye and I've *heard* that Talent2 have some chunky modules to deilver for a large brisbane-based university _THAT_USED_TO_RUN_COLDFUSION_!!! somedays it feels like being a pixie about 2 inches high, jumping up and down waving arms everywhere shouting (at pixie volume) use coldfusion.. it's

[cfaussie] Re: Why buy into CF?

2006-09-04 Thread Andrew Scott
It's the same old argument, no developers to fill the role then looks look at what the market offers where there is plenty of skill. Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 -Original Message- From:

[cfaussie] Re: Why buy into CF?

2006-09-04 Thread Barry Beattie
but there's plenty of available Java programmers and they didn't go there. number one feature I want for ColdFusion 8: [EMAIL PROTECTED] the features, I want decent, widespread marketing. More than just to the converted. Get over this hump (struggle getting consideration for contracts,

[cfaussie] Someone help with this bit of code?

2006-09-04 Thread Andrew Scott
Ok, Help, anyone who has better SQL than me can you see why this query is not working? cfquery datasource=#DSN# name=qMyDiscountApprovals SELECT * FROM Bookings, BookingItems WHERE BO_DeleteDate IS NULL AND BO_ID =

[cfaussie] Re: Someone help with this bit of code?

2006-09-04 Thread Seona Bellamy
On 05/09/06, Andrew Scott [EMAIL PROTECTED] wrote: cfquery datasource=#DSN# name=qMyDiscountApprovalsSELECT *FROM Bookings, BookingItemsWHERE BO_DeleteDate IS NULLAND BO_ID = BI_BookingID AND BI_ParentItem IS NULLcfif Client.Authenticate eq 2and BO_Discount = 0.03cfelseif Client.Authenticate eq 3

[cfaussie] Re: Someone help with this bit of code?

2006-09-04 Thread Andrew Mercer
ORDER BY rather than GROUP BY.On 9/5/06, Seona Bellamy [EMAIL PROTECTED] wrote: On 05/09/06, Andrew Scott [EMAIL PROTECTED] wrote: cfquery datasource=#DSN# name=qMyDiscountApprovalsSELECT *FROM Bookings, BookingItemsWHERE BO_DeleteDate IS NULL AND BO_ID = BI_BookingID AND BI_ParentItem IS

[cfaussie] Re: Why buy into CF?

2006-09-04 Thread Robin Hilliard
So on one hand you want it to be free, (not to mention others complaining that $40/month is too much for shared CF hosting and taking their business offshore) on the other hand you want Adobe to spend a few hundred thousand dollars at least advertising ColdFusion in ANZ (and that is a

[cfaussie] Re: Someone help with this bit of code?

2006-09-04 Thread Seona Bellamy
Is it? Ah well, I usually end up putting both, so I wasn't sure. :)On 05/09/06, Andrew Mercer [EMAIL PROTECTED] wrote: ORDER BY rather than GROUP BY. On 9/5/06, Seona Bellamy [EMAIL PROTECTED] wrote: On 05/09/06, Andrew Scott [EMAIL PROTECTED] wrote: cfquery datasource=#DSN#

[cfaussie] Re: Someone help with this bit of code?

2006-09-04 Thread Dale Fraser
Dam I hate shitty queries, Where's the inner join? cfquery datasource=#DSN# name=qMyDiscountApprovals SELECT * FROMBookings INNER JOIN BookingItems ON BO_ID = BI_BookingID WHERE BO_DeleteDate IS NULL

[cfaussie] Re: Someone help with this bit of code?

2006-09-04 Thread Andrew Scott
Andrew, Order By doesnt help, in the query I want to write it will always return 73 records. Now the original query is on a group by, and it returns 23 records dropping 50 records and I really dont understand why there is a difference. When looking at the records returned on both

[cfaussie] Re: Someone help with this bit of code?

2006-09-04 Thread Andrew Scott
Dale, Not my code, but before I clean it up properly I need to know why there is a difference. And even with the inner joins it still doesn't match the difference to using the cfoutput group=, the code you posted Dale is the code I did write, and it returned 73 records, as well as the code I

[cfaussie] Re: Someone help with this bit of code?

2006-09-04 Thread Andrew Mercer
With the CFOUTPUT using groupyou will only be looking at the first BO_ID - and I am guessing that there are 23 unique BO_IDsif you want to process all of the records you either need an inner CFOUTPUT or loss the GROUP attribute. On 9/5/06, Andrew Scott [EMAIL PROTECTED] wrote: Dale,Not my code,

[cfaussie] Re: Someone help with this bit of code?

2006-09-04 Thread Scott Thornton
The orginal use of cfoutput query=BookingInfo group=BO_ID without ordering by BO_ID in the query is incorrect as the you would get three groups rather than two if the ids came out of the query as 1 2 1 which is three groups rather than 1 1 2 which is two groups. [EMAIL PROTECTED]

[cfaussie] Re: Someone help with this bit of code?

2006-09-04 Thread Andrew Scott
Scott, I think you hit the nail on the head, I sort of knew that so basically in the original code I am dealing with it would drop a record if the record BO_ID was the same as the previous output row, which now makes sense as to why there is a difference. Thanks Scott Senior Coldfusion

[cfaussie] Re: Why buy into CF?

2006-09-04 Thread Barry Beattie
well, Robin, I'll bow to your experiance and position in the industry and gladly accept the view that what's happening to Jeremy and I is mearly an aberation (caused by different circumstances). Others people's milage obviously vary to this. and if you're comfrortable with the current

[cfaussie] Re: VIC UG Numbers

2006-09-04 Thread christophe albrech
Same as Mark.TofOn 9/1/06, Dale Fraser [EMAIL PROTECTED] wrote: I wanted to do this last night but forgot.If you were at the usergroup last night,Can you let us know if you were there just because of the Flex stuff or forColdfusion.I've attached voting to this email so you can either click

[cfaussie] Re: Last nights usergroup meeting

2006-09-04 Thread christophe albrech
Too bad, it's a bit far for me. Maybe if I buy a bike?On 9/1/06, Bjorn Schultheiss [EMAIL PROTECTED] wrote:2 thumbs up.Sounds good to me.Just around the corner from where I work. Regards,Bjorn SchultheissSenior Flash DeveloperQDC Technologies-Original Message-From:

[cfaussie] ColdFusion Hosting Australia

2006-09-04 Thread CF Aussie Guy
Hi all,Currently looking for somewhere to host a site, have found the following via google... Can anyone give feedback on any of them, or recommendations on others not listed.FAST.hit : http://fasthit.net/Inevative : http://www.inevative.com.au/Core Digital Media : http://www.core.com.au/Aus

[cfaussie] Re: Last nights usergroup meeting

2006-09-04 Thread Mark Mandel
I'm yet to hear approval from Steve Steve? Mark On 9/5/06, Dale Fraser [EMAIL PROTECTED] wrote: Steve / Mark? So is it a done deal? Regards Dale Fraser http://dale.fraser.id.au -- E: [EMAIL PROTECTED] W: www.compoundtheory.com

[cfaussie] Re: Last nights usergroup meeting

2006-09-04 Thread Steve Onnis
We will have a look at some pics first. Needs to be somewhere people will feel comfortable going to. -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mark Mandel Sent: Tuesday, 5 September 2006 2:34 PM To: cfaussie@googlegroups.com Subject:

[cfaussie] Re: ColdFusion Hosting Australia

2006-09-04 Thread Peter Tilbrook
Whoa! Huge error here:http://www.inevative.com.au/Services/Hosting/index.cfmWhat is that your DEV server or something. On 05/09/06, Steve Onnis [EMAIL PROTECTED] wrote: Well seeing as no one has replied yet I will jump in. I run inevaitve / novahost hosting. Our servers are