[cfaussie] QLD CFUG May meeting - this coming Wednesday (great unwashed version)

2007-05-03 Thread Barry Beattie
This month the Brisbane CFUG turns "Lean, Green and Global" Maximize the info, minimize the time. All members will be issued a "GET ON WITH IT!" meter to ensure we don't use up our allocation of time, space and oxygen. Energy Efficient Presentations! Why? 'Cos we've got so much on this month! F

[cfaussie] Re: Formal Testing (was: Hack ColdFusion Application)

2007-05-03 Thread Rod Higgins
Hi Chris, We employ a staff member to test every application before it is released. Most larger applications we develop run through a pilot program with a UAT document. The UAT usually incorporates functionality and usability and checks for the odd bug that escaped the developer But really i

[cfaussie] Re: Formal Testing (was: Hack ColdFusion Application)

2007-05-03 Thread Seona Bellamy
On 04/05/07, Chris Velevitch <[EMAIL PROTECTED]> wrote: > > > On 5/2/07, Mike Kear <[EMAIL PROTECTED]> wrote: > > Isn't testing work worth the hire? Shouldnt they get paid regardless? > > Mike comments brings up an interesting thought: who is doing formal > testing and employs testers (either full

[cfaussie] Formal Testing (was: Hack ColdFusion Application)

2007-05-03 Thread Chris Velevitch
On 5/2/07, Mike Kear <[EMAIL PROTECTED]> wrote: > Isn't testing work worth the hire? Shouldnt they get paid regardless? Mike comments brings up an interesting thought: who is doing formal testing and employs testers (either full time or on a contract basis)? What I mean by formal testing is once

[cfaussie] Re: CFHeader tag

2007-05-03 Thread Lucas
Hi Rony, are you rendering any other content after this? you may want to make sure that this is all you are sending to the client. the other question is, when they get to that URL, is there a that makes sure that this header is not sent to the login page? L. On 5/4/07, [EMAIL PROTECTED] <[EMAI

[cfaussie] Re: Reading CSV Files - Carriage Returns

2007-05-03 Thread Barry Beattie
ya poor bugger, more power to your (drinking) arm (it *is* friday) at a rough guess, there's a hole in their app that's letting CRLF's in when it shouldn't see: "...preceding 12 months, a payment has been made under this item or item AA500, AA520 or AA530 " looks like they need a trim() on that

[cfaussie] Sorting date in

2007-05-03 Thread George Lu
Hi, I've got a cfgrid table (flash forms) with a date field (format as dd/mm/). However, if you click the header to sort the date it only sort dd part and doesn't sort mm and parts (e.g. the sorted order: 09/12/2006, 10/11/2003, 11/08/2006). Is there any solution? Thanks. George --~--~-

[cfaussie] Reading CSV Files - Carriage Returns

2007-05-03 Thread Scott Thornton
Hi Barry, The government department just rang me back, agreed the file format was wrong and has agreed to fix it. :-) They won't send me the database they export the data from however :-( It is something to be automated... in the past I have had secretarial staff fix the file so I can import

[cfaussie] CFHeader tag

2007-05-03 Thread [EMAIL PROTECTED]
Hi all, What i want to do, is if the user isn't logged in, then send them to the login.cfm file, other keep them on the page that they requested. I am trying to use the following my onrequeststart() : http://mydomain/admin/login.cfm";> But it doesn't allow me to do this, or at

[cfaussie] Re: Reading CSV Files - Carriage Returns

2007-05-03 Thread Barry Beattie
keeping in mind that it's 2 chars (carrage return AND line feed) 3 ideas come to mind 1) do the broken records have both of them in the middle of them? if it's just one (CR or LF), replace the end of line markers (both the CRLF) with a known safe token/char. 2) failing that, are they a set width

[cfaussie] Reading CSV Files - Carriage Returns

2007-05-03 Thread Scott Thornton
Hi, Attempting to read a .csv file. Unfortunately some of the records have a carriage return in one of the fields so it seems I cannot use the carriage return line feed characters as a line delimiter. ( Chr(13) Chr(10) ). Has anyone got any ideas for working around this? The file is supplie

[cfaussie] Re: RDS error on w2k CFMX 7 scanning the floppy drive

2007-05-03 Thread Andrew Scott
This actually sounds like a Java issue and not a Coldfusion issue. And no I have never seen this type of behaviour. Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613  8676 4223 Mobile: 0404 998 273 -Original Message- From: cfaussie@googlegroups.c

[cfaussie] Re: Dynamically Read SQL Table Column Names

2007-05-03 Thread Mike Kear
The Stored Procedure that Steve Onnis refers to gives you a query containing heaps of info about the columns, including the column names. But if all you want is the column names, you could use this query for MSSQLServer. SELECT col.COLUMN_NAME as name FROM INFORMATION_SCHEMA.COLU

[cfaussie] Re: Dynamically Read SQL Table Column Names

2007-05-03 Thread Steve Onnis
There is actually a built in stored proceedure for this stuff in MSSQL sp_tables gets all the tables in a database sp_columns gets all the columns in a table Look up in the sql help on how to use them Steve On May 3, 8:23 am, "AJ Mercer" <[EMAIL PROTECTED]> wrote: > Most databases have tables