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

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

First, hot off the presses of the Scorpio Beta, we'll be looking at
some of the new ColdFusion language enhancements that's been announced -
guaranteed to make your work with ColdFusion more energy efficient.

then we delve into the world of Internationalisation (i18n) with special
Guest Jason Sheedy taking us through how to get your sites and apps
accessed in the Global marketplace. Think Globally, act Locally.

And then our very own Gareth.E ("in da house!") will bring us another
installment on energy-efficient programing (ie: "Lazy-Coders") with
using ANT's (and their tasks) to do the heavy lifting so you don't
need to. Use an ANT eater today!


so, if you're not already a member, sign up to the QLD CFUG usergroup
http://groups.google.com/group/qldcfug/

and that will give us your RSVP so you can go into the prize draw (and
ensure we do a good job on catering)  - we hope to see you there


cheers
The QLD CFUG crew.

Meeting Details: 6:30 pm - ?, Wednesday, 14th March 2007
If doors are locked, call 0414 328 902 for entry

QANTM Auditorium
QANTM House
Level 9, 138 Albert St
Brisbane City
(Opposite the "Coffee Club")

Find it on WHEREIS:
http://www.whereis.com/whereis/retrieveEmailMap.do?linkId=-;7243212240990709884

Find it on Google Maps:
http://maps.google.com/maps?f=q&hl=en&q=138+Albert+St,+City+QLD+4000,+Australia&ie=UTF8&sll=37.0625,-95.677068&sspn=28.168051,68.90625&z=17&om=1&iwloc=addr

---
Upcoming Meetings for your Calendar:

16th May: Brisbane Flash Platform Group
  - CS3 Mobile device workflows
  - 10 minute "easing into" tip: stepping thru XML in Flex
  - More News on Apollo Desktop RIA Goodness

6th June: QMUG
  - goodness details to be advised

13th June: CFUG
  - Scorpio (CF8) PDF Features report
  - more goodness details to be advised

20th June: Brisbane Flash Platform Group
  - 10 minute "easing into" tip
  - more goodness details to be advised

---

--~--~-~--~~~---~--~~
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: Formal Testing (was: Hack ColdFusion Application)

[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 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] On Behalf
Of Chris Velevitch
Sent: Friday, 4 May 2007 1:38 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Formal Testing (was: Hack ColdFusion Application)



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 the  requirements and specifications are in place
whilst the developers are coding, the testers are creating test
cases/scenarios in readiness for the testing phase of the project.

Chris
-- 
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
m: 0415 469 095
www.flashdev.org.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] Re: Formal Testing (was: Hack ColdFusion Application)

[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 time or on a contract basis)?
> What I mean by formal testing is once the  requirements and
> specifications are in place whilst the developers are coding, the
> testers are creating test cases/scenarios in readiness for the testing
> phase of the project.
>

We handle ours in-house. We don't actually have dedicated testers, but test
cases are drawn up from the various requirements documents and then once the
site's on the testing server they get handed around the office for people to
run through.

Not sure if that's as formal as you're asking about, though.

~Seona

--~--~-~--~~~---~--~~
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] Formal Testing (was: Hack ColdFusion Application)

[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 the  requirements and
specifications are in place whilst the developers are coding, the
testers are creating test cases/scenarios in readiness for the testing
phase of the project.

Chris
-- 
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
m: 0415 469 095
www.flashdev.org.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] Re: CFHeader tag

[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] <[EMAIL PROTECTED]> wrote:
>
>
> 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() :
>
> 
>  value="http://mydomain/admin/login.cfm";>
>
> But it doesn't allow me to do this, or at least isn't acting the way i
> want it. It just stays on the same page.
>
> i also tried cflocation, only to get redirecting issues.
>
> Any ideas ?
>
> Thanks
> Rony
>
>
> >
>


-- 
Lucas

http://www.thebitbucket.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: Reading CSV Files - Carriage Returns

[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 field on data entry although
what about if their data entry app allows this? ...

"... of a patient who
 - is at least 55 YEARS OLD
 - OF ABORIGINAL OR TORRES STRAIT ISLANDER DESCENT
 - not being a health assessment of a patient in respect of whom
 - in the preceding 12 months
 a payment has been made under this item or item AA500, AA510 or AA520
"
which is legit 'cos it's still between the "..." field deliminators

which makes me think a different end of line/record marker might help.

but none of which is telling you anything new, I realise. long live
XML with [[CDATA.

hope you get to your weekend...

cheers
b



On 5/4/07, Scott Thornton <[EMAIL PROTECTED]> wrote:
>
> 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 it... but as the application goes out to more 
> and more locations this is no longer an option.
>
> The file actually opens fine when viewed in excel... I guess its import 
> method is pretty robust. my next option was to import into MS access like you 
> suggested.
>
> Meanwhile I think I might try to replace the CRLF with a different character 
> for fun to see if it can be done.
>
> Sample text if interested (doesn't look so good in the email tho):
>
> AA415,"SERVICE provided BY A PRACTICE NURSE or registered Aboriginal Health 
> Worker, where ONE clinical task is performed on behalf of, and under the 
> supervision of, a medical practitioner; and AT A PLACE OTHER THAN CONSULTING 
> ROOMS BUT NOT IN A HOSPITAL OR DAY-HOSPITAL FACILITY, not being a service to 
> which AA401, AA405, AA411, AA421 or AA425 applies",43,,
> AA421,"SERVICE provided BY A PRACTICE NURSE or registered Aboriginal Health 
> Worker, where TWO clinical tasks are performed on behalf of, and under the 
> supervision of, a medical practitioner; and AT A PLACE OTHER THAN CONSULTING 
> ROOMS BUT NOT IN A HOSPITAL OR DAY-HOSPITAL FACILITY, not being a service to 
> which AA401, AA405, AA411, AA415 or AA425 applies",64,,
> AA425,"SERVICE provided BY A PRACTICE NURSE or registered Aboriginal Health 
> Worker, where THREE OR MORE clinical tasks are performed on behalf of, and 
> under the supervision of, a medical practitioner; and AT A PLACE OTHER THAN 
> CONSULTING ROOMS BUT NOT IN A HOSPITAL OR DAY-HOSPITAL FACILITY, not being a 
> service to which AA401, AA405, AA411, AA415 or AA421 applies",96,,
> AA500,"ATTENDANCE BY A MEDICAL PRACTITIONER (including a general 
> practitioner, but not including a specialist or consultant physician) AT 
> CONSULTING ROOMS for a HEALTH ASSESSMENT - of a patient who is at least 75 
> YEARS OLD - not being a health assessment of a patient in respect of whom, in 
> the preceding 12 months, a payment has been made under this item or item 
> AA510, AA520 or AA530",230,700,167.45
> AA510,"ATTENDANCE BY A MEDICAL PRACTITIONER (including a general 
> practitioner, but not including a specialist or consultant physician) NOT 
> BEING AN ATTENDANCE AT CONSULTING ROOMS, A HOSPITAL OR A RESIDENTIAL AGED 
> CARE FACILITY, for a HEALTH ASSESSMENT - of a patient who is at least 75 
> YEARS OLD - not being a health assessment of a patient in respect of whom, in 
> the preceding 12 months, a payment has been made under this item or item 
> AA500, AA520 or AA530
> ",375,702,236.85
> AA520,"ATTENDANCE BY A MEDICAL PRACTITIONER (including a general 
> practitioner, but not including a specialist or consultant physician) AT 
> CONSULTING ROOMS for a HEALTH ASSESSMENT - of a patient who is at least 55 
> YEARS OLD AND OF ABORIGINAL OR TORRES STRAIT ISLANDER DESCENT - not being a 
> health assessment of a patient in respect of whom, in the preceding 12 
> months, a payment has been made under this item or item AA500, AA510 or 
> AA540",230,704,167.45
> AA530,"ATTENDANCE BY A MEDICAL PRACTITIONER (including a general 
> practitioner, but not including a specialist or consultant physician) NOT 
> BEING AN ATTENDANCE AT CONSULTING ROOMS, A HOSPITAL OR A RESIDENTIAL AGED 
> CARE FACILITY, for a HEALTH ASSESSMENT - of a patient who is at least 55 
> YEARS OLD AND OF ABORIGINAL OR TORRES STRAIT ISLANDER DESCENT - not being a 
> health assessment of a patient in respect of whom, in the preceding 12 
> months, a payment has been made under this item or item AA500, AA510 or AA520
> ",375,706,236.85
>
> >>> "Barry Beattie" <[EMAIL PROTECTED]> 04/05/2007 11:25 am >>>
>
> keeping in mind that it's 2 chars (carrage return AND line feed)
>
> 3 idea

[cfaussie] Sorting date in

[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

--~--~-~--~~~---~--~~
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] Reading CSV Files - Carriage Returns

[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 it... but as the application goes out to more and 
more locations this is no longer an option.

The file actually opens fine when viewed in excel... I guess its import method 
is pretty robust. my next option was to import into MS access like you 
suggested.

Meanwhile I think I might try to replace the CRLF with a different character 
for fun to see if it can be done.

Sample text if interested (doesn't look so good in the email tho):

AA415,"SERVICE provided BY A PRACTICE NURSE or registered Aboriginal Health 
Worker, where ONE clinical task is performed on behalf of, and under the 
supervision of, a medical practitioner; and AT A PLACE OTHER THAN CONSULTING 
ROOMS BUT NOT IN A HOSPITAL OR DAY-HOSPITAL FACILITY, not being a service to 
which AA401, AA405, AA411, AA421 or AA425 applies",43,,
AA421,"SERVICE provided BY A PRACTICE NURSE or registered Aboriginal Health 
Worker, where TWO clinical tasks are performed on behalf of, and under the 
supervision of, a medical practitioner; and AT A PLACE OTHER THAN CONSULTING 
ROOMS BUT NOT IN A HOSPITAL OR DAY-HOSPITAL FACILITY, not being a service to 
which AA401, AA405, AA411, AA415 or AA425 applies",64,,
AA425,"SERVICE provided BY A PRACTICE NURSE or registered Aboriginal Health 
Worker, where THREE OR MORE clinical tasks are performed on behalf of, and 
under the supervision of, a medical practitioner; and AT A PLACE OTHER THAN 
CONSULTING ROOMS BUT NOT IN A HOSPITAL OR DAY-HOSPITAL FACILITY, not being a 
service to which AA401, AA405, AA411, AA415 or AA421 applies",96,,
AA500,"ATTENDANCE BY A MEDICAL PRACTITIONER (including a general practitioner, 
but not including a specialist or consultant physician) AT CONSULTING ROOMS for 
a HEALTH ASSESSMENT - of a patient who is at least 75 YEARS OLD - not being a 
health assessment of a patient in respect of whom, in the preceding 12 months, 
a payment has been made under this item or item AA510, AA520 or 
AA530",230,700,167.45
AA510,"ATTENDANCE BY A MEDICAL PRACTITIONER (including a general practitioner, 
but not including a specialist or consultant physician) NOT BEING AN ATTENDANCE 
AT CONSULTING ROOMS, A HOSPITAL OR A RESIDENTIAL AGED CARE FACILITY, for a 
HEALTH ASSESSMENT - of a patient who is at least 75 YEARS OLD - not being a 
health assessment of a patient in respect of whom, in the preceding 12 months, 
a payment has been made under this item or item AA500, AA520 or AA530 
",375,702,236.85
AA520,"ATTENDANCE BY A MEDICAL PRACTITIONER (including a general practitioner, 
but not including a specialist or consultant physician) AT CONSULTING ROOMS for 
a HEALTH ASSESSMENT - of a patient who is at least 55 YEARS OLD AND OF 
ABORIGINAL OR TORRES STRAIT ISLANDER DESCENT - not being a health assessment of 
a patient in respect of whom, in the preceding 12 months, a payment has been 
made under this item or item AA500, AA510 or AA540",230,704,167.45
AA530,"ATTENDANCE BY A MEDICAL PRACTITIONER (including a general practitioner, 
but not including a specialist or consultant physician) NOT BEING AN ATTENDANCE 
AT CONSULTING ROOMS, A HOSPITAL OR A RESIDENTIAL AGED CARE FACILITY, for a 
HEALTH ASSESSMENT - of a patient who is at least 55 YEARS OLD AND OF ABORIGINAL 
OR TORRES STRAIT ISLANDER DESCENT - not being a health assessment of a patient 
in respect of whom, in the preceding 12 months, a payment has been made under 
this item or item AA500, AA510 or AA520 
",375,706,236.85

>>> "Barry Beattie" <[EMAIL PROTECTED]> 04/05/2007 11:25 am >>>

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 per record or close enough? some
combination of char counts and CRLF with a bit of logic to get over
the broken records.

3)
use MSAccess to play around with importing of the CSV. I've found it
great to get results quickly and you can see the resultant data in
tables to check. good for prototyping. if you export from MSAccess
it'll effectively clean up the crap

csv -> access -> new csv - > CF

I hope this is a one off job and not something to be automated...

just some quick ideas
barry.b




On 5/4/07, Scott Thornton <[EMAIL PROTECTED]> wrote:
>
> 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 supplied by the g

[cfaussie] CFHeader tag

[[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 least isn't acting the way i
want it. It just stays on the same page.

i also tried cflocation, only to get redirecting issues.

Any ideas ?

Thanks
Rony


--~--~-~--~~~---~--~~
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: Reading CSV Files - Carriage Returns

[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 per record or close enough? some
combination of char counts and CRLF with a bit of logic to get over
the broken records.

3)
use MSAccess to play around with importing of the CSV. I've found it
great to get results quickly and you can see the resultant data in
tables to check. good for prototyping. if you export from MSAccess
it'll effectively clean up the crap

csv -> access -> new csv - > CF

I hope this is a one off job and not something to be automated...

just some quick ideas
barry.b




On 5/4/07, Scott Thornton <[EMAIL PROTECTED]> wrote:
>
> 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 supplied by the government and I can't imagine that it would be 
> fixed up quickly...
>
>
>
>
> >
>

--~--~-~--~~~---~--~~
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] Reading CSV Files - Carriage Returns

[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 supplied by the government and I can't imagine that it would be 
fixed up quickly...




--~--~-~--~~~---~--~~
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: RDS error on w2k CFMX 7 scanning the floppy drive

[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.com [mailto:[EMAIL PROTECTED] On Behalf
Of Zac Spitzer
Sent: Thursday, 3 May 2007 4:57 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] RDS error on w2k CFMX 7 scanning the floppy drive


Anyone know how to stop the RDS scanning the floppy disk drive?

I've googled around and haven't found any help

i hit the same error when i try to browse the server to add a mapping

z

-- 
Zac Spitzer
+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 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: Dynamically Read SQL Table Column Names

[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.COLUMNS as col LEFT JOIN
INFORMATION_SCHEMA.TABLE_CONSTRAINTS as tabCon
ON col.TABLE_NAME = tabCon.TABLE_NAME
AND tabCon.CONSTRAINT_TYPE = 'PRIMARY KEY'
LEFT JOIN INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE as colCon
ON col.COLUMN_NAME = colCon.COLUMN_NAME
AND col.TABLE_NAME = colCon.TABLE_NAME
AND colCon.CONSTRAINT_NAME = tabCon.CONSTRAINT_NAME
WHERE col.TABLE_NAME = 'whatevertablename'

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



On 5/3/07, Steve Onnis <[EMAIL PROTECTED]> wrote:
>
> 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

--~--~-~--~~~---~--~~
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: Dynamically Read SQL Table Column Names

[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 that store table metadata
> like SQL Server has sysobjects
>   Informix has systables, syscolumns
>
> You can query these tables to get the information you are after.
> What Database Server are you using?
>
> On 5/3/07, claude raiola <[EMAIL PROTECTED]> wrote:
>
>
>
>
>
>
>
> >  Just wondering if its possible to dynamically read column names of an
> > existing sq table.
>
> > What I am trying to create is a facility where the user can select the
> > table name which will then list the columns of the given table.
>
> > The user can the select the column names of choice which will in turn be
> > used to build in a CF Query
>
> > I look forward to your comments
>
> > Kind Regards
>
> > Claude Raiola
> > B.Econ(Acc.); B.Hotel Mngt.
> > Mobile: 0414 228 948
> > Phone: 07 5527 1990
> > Fax: 07 3319 6444
>
> > Websites:
> >www.WebsiteSolutions.com.au
> >www.AustralianAccommodation.com
> >www.AccommodationNewZealand.com
> >www.HospitalityPurchasing.net
> >www.Samaris.net
>
> --
> If you are not living on the edge,
> You are taking up too much space.- Hide quoted text -
>
> - Show quoted text -


--~--~-~--~~~---~--~~
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
-~--~~~~--~~--~--~---