RE: CF chat in CFMX?

2006-10-25 Thread Bobby Hartsfield
http://www.opensourcecf.com/cfopenchat/


"This chat room was written using Coldfusion MX 7 and ajaxCFC. If you're
here, you probably know what those are. It has been tested and will run on
Coldfusion MX 6.1."


-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 25, 2006 5:48 PM
To: CF-Talk
Subject: CF chat in CFMX?

Does anyone know of a CFMX based chat system? I found a list of apps on
cfopensource but the one I saw is CF7 only.






~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258077
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: OT: authorize.net

2006-10-25 Thread jonese
we use authorize.net for a few clients and i haven't seen this happen
on any of our sites.

Are you using custom code or a 3rd party tag to interface with
authorize.net? Could be something getting tranposed or formatted funny
before the date is passed to the processing company (not that that is
an excuse or anything...).

jonese

On 10/25/06, Jon Clausen <[EMAIL PROTECTED]> wrote:
> I'm on Payflow Pro as a Gateway with Moneris/Vital as a Processor,
> but they validate everything, every time, including the CCV code.  I
> think you need to take this issue further, though.
>
> It sounds like it's an issue with your Processor, not the Gateway.
> If Authorize.net is passing the exp date/CCV and the processor isn't
> checking it, it's time to switch processors IMHO.   Unless you have
> some sort of fraud protection in place that indemnifies you from any
> loss.
>
> - Jon
>
> On Oct 25, 2006, at 8:57 PM, Will Tomlinson wrote:
>
> > I just noticed on our site, if you submit an authorize.net
> > transaction with a bogus expiration date, the transaction is still
> > approved.
> >
> > Just got off IM with a auth.net rep. Anybody ever run into this?
> >
> > Thanks,
> > Will
> >
> > Will Tomlinson: Ok, I'm running some sample transactions thru our
> > site, and the responses seem to be approved even if the expiration
> > date on the card is wrong.
> >
> > Will Tomlinson: I can give you a transaction # to check out
> >
> > Kevin T: No, actually we don't have the ability to check that. We
> > depend on the credit card networks to do the security checks for
> > us, and this is one thing they don't usually check, oddly enough.
> >
> > Kevin T: We'll make sure that the expiration date being provided
> > hasn't already passed, but other than that, we depend on the credit
> > card networks to confirm the accuracy of the expiration date
> > instead, and they rarely seem to actually do that.
> >
> >
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258076
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Using PDF's...

2006-10-25 Thread Rick Faircloth
Thanks for the advice, John...  :o)

Rick

-Original Message-
From: John Dowdell [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 25, 2006 4:32 PM
To: CF-Talk
Subject: Re: Using PDF's...

Rick Faircloth wrote:
> Just curious if today's browsers, especially IE,
> have built-in support for reading PDF's.  I mean
> they are able to open them and print them without
> having Acrobat Reader installed.

Microsoft Internet Explorer uses system-level ActiveX Controls as an 
extension mechanism, and these will auto-install if a sufficient version 
of the Control is not already installed on that system. So, the free 
Adobe Reader, in its ActiveX wrapper, will automatically download if not 
yet on the system, and a little permissions dialog will appear. Easy-peasy.

Other browsers use Netscape Plugins, and so there's a page-redirect 
before installation.

Apple's Safari browser uses the Apple system-level PDF renderer, Apple 
Preview. This can handle simple PDF documents, but can show font/display 
issues with basic files, and does not support the collaborative features 
of Adobe Acrobat.

Practically speaking, people see so many PDF files through the life of a 
computer that it's a rare system which cannot already render 
garden-variety PDF. (PDFs are indeed much friendlier and more universal 
than DOCs... the latter require money to render, for one. ;-)

jd








~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258075
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: OT: authorize.net

2006-10-25 Thread Jon Clausen
I'm on Payflow Pro as a Gateway with Moneris/Vital as a Processor,  
but they validate everything, every time, including the CCV code.  I  
think you need to take this issue further, though.

It sounds like it's an issue with your Processor, not the Gateway.   
If Authorize.net is passing the exp date/CCV and the processor isn't  
checking it, it's time to switch processors IMHO.   Unless you have  
some sort of fraud protection in place that indemnifies you from any  
loss.

- Jon

On Oct 25, 2006, at 8:57 PM, Will Tomlinson wrote:

> I just noticed on our site, if you submit an authorize.net  
> transaction with a bogus expiration date, the transaction is still  
> approved.
>
> Just got off IM with a auth.net rep. Anybody ever run into this?
>
> Thanks,
> Will
>
> Will Tomlinson: Ok, I'm running some sample transactions thru our  
> site, and the responses seem to be approved even if the expiration  
> date on the card is wrong.
>
> Will Tomlinson: I can give you a transaction # to check out
>
> Kevin T: No, actually we don't have the ability to check that. We  
> depend on the credit card networks to do the security checks for  
> us, and this is one thing they don't usually check, oddly enough.
>
> Kevin T: We'll make sure that the expiration date being provided  
> hasn't already passed, but other than that, we depend on the credit  
> card networks to confirm the accuracy of the expiration date  
> instead, and they rarely seem to actually do that.
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258074
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


OT: authorize.net

2006-10-25 Thread Will Tomlinson
I just noticed on our site, if you submit an authorize.net transaction with a 
bogus expiration date, the transaction is still approved. 

Just got off IM with a auth.net rep. Anybody ever run into this? 

Thanks,
Will

Will Tomlinson: Ok, I'm running some sample transactions thru our site, and the 
responses seem to be approved even if the expiration date on the card is wrong. 

Will Tomlinson: I can give you a transaction # to check out 

Kevin T: No, actually we don't have the ability to check that. We depend on the 
credit card networks to do the security checks for us, and this is one thing 
they don't usually check, oddly enough. 

Kevin T: We'll make sure that the expiration date being provided hasn't already 
passed, but other than that, we depend on the credit card networks to confirm 
the accuracy of the expiration date instead, and they rarely seem to actually 
do that. 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258073
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Where can I download Coldspring for use in MG:U?

2006-10-25 Thread Denny Valliant
On 10/25/06, Dave Lyons <[EMAIL PROTECTED]> wrote:
> u can still see it here
>
> http://svn.reactorframework.com/reactor/trunk/reactor/data/mysql/ObjectDao.cfc

Are you using mysql ver 5?  It's working for me, and I am, and I'm
resonalby sure it wouldn't, if it was broke...  do you have the
information_schema table?

I've been running hot with reactor and model glue... besides a hiccup
with query.cfc (or some such... it was fixed so fast, I don't recall)
it's been amazing.  Props to all involved in those three frameworks!

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258072
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Query of Query

2006-10-25 Thread Richard White
along these same lines, if a session variable is approx no more than 50 in 
length do you think it would be better to perform a query on the session 
structure or to implement a loop. 

Just wondering about performance and if there would be much of a difference

thanks

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258071
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Invoking CFIDE.adminapi.base components

2006-10-25 Thread Snake
www.satachi.com/downloads/adminapi_enc.zip

Snake 

-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED] 
Sent: 25 October 2006 23:07
To: CF-Talk
Subject: Re: Invoking CFIDE.adminapi.base components

Provide a link for the code :-)






"This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
Registered in England, Number 678540.  It contains information which is
confidential and may also be privileged.  It is for the exclusive use of the
intended recipient(s).  If you are not the intended recipient(s) please note
that any form of distribution, copying or use of this communication or the
information in it is strictly prohibited and may be unlawful.  If you have
received this communication in error please return it to the sender or call
our switchboard on +44 (0) 20 89107910.  The opinions expressed within this
communication are not necessarily those expressed by Reed Exhibitions." 
Visit our website at http://www.reedexpo.com

-Original Message-
From: Snake
To: CF-Talk
Sent: Wed Oct 25 22:59:26 2006
Subject: RE: Invoking CFIDE.adminapi.base components

If anyone else is interested, I have created a webservice that allows you to
remotely create DSN's, mappings and sandboxes. Rest of cfadmin functionality
to come.

Snake 

-Original Message-
From: Jon Clausen [mailto:[EMAIL PROTECTED]
Sent: 25 October 2006 22:36
To: CF-Talk
Subject: Re: Invoking CFIDE.adminapi.base components

Never mind.   I figured it out.  In case anyone needs the code for  
future reference, here's how to create a Coldfusion datasource on the fly
(In this case using an "other" driver):


//Instantiate the Admin API
createObject("component","cfide.adminapi.administrator").login
("myCFAdminPassword");
//Create the Datasource
createObject("component","cfide.adminapi.datasource").setOther
(dsnName,dsnURL,dbdriver,"PostgresDriver",dbowner,dbownerpass);


- Jon
On Oct 25, 2006, at 2:46 PM, Jon Clausen wrote:

> I'm trying to create a Coldfusion datasource on the fly using the 
> RDSInvoker method in the CFIDE.adminapi.base component.









~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258070
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Invoking CFIDE.adminapi.base components

2006-10-25 Thread Robertson-Ravo, Neil (RX)
Provide a link for the code :-)






"This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
Registered in England, Number 678540.  It contains information which is
confidential and may also be privileged.  It is for the exclusive use of the
intended recipient(s).  If you are not the intended recipient(s) please note
that any form of distribution, copying or use of this communication or the
information in it is strictly prohibited and may be unlawful.  If you have
received this communication in error please return it to the sender or call
our switchboard on +44 (0) 20 89107910.  The opinions expressed within this
communication are not necessarily those expressed by Reed Exhibitions." 
Visit our website at http://www.reedexpo.com

-Original Message-
From: Snake
To: CF-Talk
Sent: Wed Oct 25 22:59:26 2006
Subject: RE: Invoking CFIDE.adminapi.base components

If anyone else is interested, I have created a webservice that allows you to
remotely create DSN's, mappings and sandboxes. Rest of cfadmin functionality
to come.

Snake 

-Original Message-
From: Jon Clausen [mailto:[EMAIL PROTECTED] 
Sent: 25 October 2006 22:36
To: CF-Talk
Subject: Re: Invoking CFIDE.adminapi.base components

Never mind.   I figured it out.  In case anyone needs the code for  
future reference, here's how to create a Coldfusion datasource on the fly
(In this case using an "other" driver):


//Instantiate the Admin API
createObject("component","cfide.adminapi.administrator").login
("myCFAdminPassword");
//Create the Datasource
createObject("component","cfide.adminapi.datasource").setOther
(dsnName,dsnURL,dbdriver,"PostgresDriver",dbowner,dbownerpass);


- Jon
On Oct 25, 2006, at 2:46 PM, Jon Clausen wrote:

> I'm trying to create a Coldfusion datasource on the fly using the 
> RDSInvoker method in the CFIDE.adminapi.base component.







~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258069
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Invoking CFIDE.adminapi.base components

2006-10-25 Thread Snake
If anyone else is interested, I have created a webservice that allows you to
remotely create DSN's, mappings and sandboxes. Rest of cfadmin functionality
to come.

Snake 

-Original Message-
From: Jon Clausen [mailto:[EMAIL PROTECTED] 
Sent: 25 October 2006 22:36
To: CF-Talk
Subject: Re: Invoking CFIDE.adminapi.base components

Never mind.   I figured it out.  In case anyone needs the code for  
future reference, here's how to create a Coldfusion datasource on the fly
(In this case using an "other" driver):


//Instantiate the Admin API
createObject("component","cfide.adminapi.administrator").login
("myCFAdminPassword");
//Create the Datasource
createObject("component","cfide.adminapi.datasource").setOther
(dsnName,dsnURL,dbdriver,"PostgresDriver",dbowner,dbownerpass);


- Jon
On Oct 25, 2006, at 2:46 PM, Jon Clausen wrote:

> I'm trying to create a Coldfusion datasource on the fly using the 
> RDSInvoker method in the CFIDE.adminapi.base component.





~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258068
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: CF chat in CFMX?

2006-10-25 Thread Snake
There is a cf_chat, dunno if it is CF7 only though

Snake 

-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED] 
Sent: 25 October 2006 22:48
To: CF-Talk
Subject: CF chat in CFMX?

Does anyone know of a CFMX based chat system? I found a list of apps on
cfopensource but the one I saw is CF7 only.






~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258067
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


CF chat in CFMX?

2006-10-25 Thread Andy Matthews
Does anyone know of a CFMX based chat system? I found a list of apps on
cfopensource but the one I saw is CF7 only.




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258066
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Invoking CFIDE.adminapi.base components

2006-10-25 Thread Jon Clausen
Never mind.   I figured it out.  In case anyone needs the code for  
future reference, here's how to create a Coldfusion datasource on the  
fly (In this case using an "other" driver):


//Instantiate the Admin API
createObject("component","cfide.adminapi.administrator").login 
("myCFAdminPassword");
//Create the Datasource
createObject("component","cfide.adminapi.datasource").setOther 
(dsnName,dsnURL,dbdriver,"PostgresDriver",dbowner,dbownerpass);


- Jon
On Oct 25, 2006, at 2:46 PM, Jon Clausen wrote:

> I'm trying to create a Coldfusion datasource on the fly using the
> RDSInvoker method in the CFIDE.adminapi.base component.



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258065
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Mime Type for File Upload

2006-10-25 Thread Martyn Bowis
Hi again,

If CFFile does not read the file content when uploading, then perhaps you
can use CFFILE to read the BINARY content of that file that has been
uploaded (before renaming or making it available anywhere for anyone to
access) and determine its header makeup from that?

See the following link for a start on reading BINARY content of files:
http://www.johnwbartlett.com/CF_tipsNtricks/index.cfm?TopicID=84

Example to display the ASCII value of the first 100 characters in a file.


#Chr(Get(Data,loop))#

Cheers,
Martyn


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258064
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Query of Query

2006-10-25 Thread Ian Skinner
I believe I read somewhere that Query of Query performs best with record sets 
that are 50,000 records or smaller.


This was discussed in one of the topics at CFUnderground this year.  Yes Query 
of Query is best for small record sets, because CF is not optimized as a DBMS 
and can not create or use indexes on record sets used in QofQ logic.

The speaker suggested turning large record sets into structures and/or arrays 
when ever possible.  CF is optimized to look up keys and indexes very quickly.  

But I'm not sure how helpful this would be for this particular search 
refinement issue.

--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

-
| 1 |   |
-  Binary Soduko
|   |   |
-
 
"C code. C code run. Run code run. Please!"
- Cynthia Dunning

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message. 




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258063
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: WebServices Question

2006-10-25 Thread Ian Skinner
I believe a  should do what you want it to 
do.

 will show everything returned by this cfhttp call.


--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

-
| 1 |   |
-  Binary Soduko
|   |   |
-
 
"C code. C code run. Run code run. Please!"
- Cynthia Dunning

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message. 




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258062
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


CFCHART and all its goodness confused....

2006-10-25 Thread Richard Dillman
Im attempting a couple things so i have a coule questions

1 IS it possible to do an IIF inside the Series color?  I have a chart that
is a bar chart shoing children who recieved inqueries  and id like to color
their bars pink/blue based on gender.

2. How do i get the labels to show for EVERY item in the list.  right now
its showing every 10th im assuming because of lineheight. but even changing
font size to 6 point i get every 4th one.

Any Thoughts?

here is what i get with the fololowing code
http://www.webintegrity.us/GraphData.jpg




SELECT COUNT(Correspondence.CorrespondenceChildID) AS callcount,
Correspondence.CorrespondenceChildID, tbl_Children.CHILD_ID,
tbl_Children.FIRSTNAME,
  tbl_Children.SEX
FROM Correspondence LEFT OUTER JOIN
  tbl_Children ON Correspondence.CorrespondenceChildID =
tbl_Children.REC_ID
WHERE (Correspondence.CorrespondenceDate >= ) AND (
Correspondence.CorrespondenceDate <= ) AND
  (Correspondence.CorrespondenceChildID IS NOT NULL)
GROUP BY Correspondence.CorrespondenceChildID, tbl_Children.CHILD_ID,
tbl_Children.FIRSTNAME, tbl_Children.SEX
ORDER BY Correspondence.CorrespondenceChildID







DATA
  Jan 01, 2005 *Through* Feb 01, 2005  Child ID Name Inqueries 1770B Mia 1
3103 Robert 1 3229 Trevia 1 3354A Precious 6 3354B Judas 1 3360 Randy 3
3404A Damar 3 3411A Keontaye 3 3030 Kyle 2 3429A Sarah 1 3442 Shawn 5 3466
Michael 2 3482 Chris 1 3489 Craig 2 3494 Keith 1 3496 Christopher 2 3498
Teleatha 2 3503 Dartangan 1 3507A Garrett 7 3510 Manny 16 3516 Nicole 3 3518
Jessica 5 3519 Christopher 3 3522D Isaac 1 3524B Jose 1 3525 Katrina 1 3527A
Susie 3 3530 Jason 1 3531A Lukas 3 3531B Vincent 1 3534 Dana 1 3535A Monea 1
3535C Michelle 2 3537 Maxwell 1 3538 Adam 1 3539A Dezaraye 11 3539B Samantha
1 3541A Anita 19 3541B Mauda 7 3541C Rosa 2 3541D Oscar 2 3078 Trevor 3 3395
Melissa 6 3397 Johnathan 1 3420 Brea 1 3450A Gininia 1 3522B Shena 1 3532
Kenny 5   Grand Total 149
-- 
-- 
Richard Dillman
[EMAIL PROTECTED]
(317) 916-8341

"...the very powerful and the very stupid have one thing in common, they
don't alter their views to fit the facts, they alter the facts to fit the
views."


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258061
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Using PDF's...

2006-10-25 Thread John Dowdell
Rick Faircloth wrote:
> Just curious if today's browsers, especially IE,
> have built-in support for reading PDF's.  I mean
> they are able to open them and print them without
> having Acrobat Reader installed.

Microsoft Internet Explorer uses system-level ActiveX Controls as an 
extension mechanism, and these will auto-install if a sufficient version 
of the Control is not already installed on that system. So, the free 
Adobe Reader, in its ActiveX wrapper, will automatically download if not 
yet on the system, and a little permissions dialog will appear. Easy-peasy.

Other browsers use Netscape Plugins, and so there's a page-redirect 
before installation.

Apple's Safari browser uses the Apple system-level PDF renderer, Apple 
Preview. This can handle simple PDF documents, but can show font/display 
issues with basic files, and does not support the collaborative features 
of Adobe Acrobat.

Practically speaking, people see so many PDF files through the life of a 
computer that it's a rare system which cannot already render 
garden-variety PDF. (PDFs are indeed much friendlier and more universal 
than DOCs... the latter require money to render, for one. ;-)

jd





-- 
John Dowdell . Adobe Developer Support . San Francisco CA USA
Weblog: http://weblogs.macromedia.com/jd
Aggregator: http://weblogs.macromedia.com/mxna
Technotes: http://www.macromedia.com/support/
Spam killed my private email -- public record is best, thanks.

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258060
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: WebServices Question

2006-10-25 Thread Dave Watts
> So is there a way to do a http get request for my function 
> called getDN that's in my WebService?

No, CF web services are SOAP services, and SOAP requires HTTP POST or M-POST
requests containing a SOAP envelope. If you wanted to write a REST-style web
service, it would be up to you to do that on your own. However, that
wouldn't be especially difficult. You would have to decide what exactly you
want your web service to require for inputs, and what it would generate for
a response.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
 
Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore and Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258059
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: ANN: CFFormProtect, new open source project

2006-10-25 Thread Munson, Jacob
True, there is a 1 and 3 chance.  In the next release I want to put a
failure limit in, so bots can't keep hitting it until they get it right.
I suppose I could also add more images to decrease the odds.

The biggest advantage I hoped was to make it easier on the user.   

> -Original Message-
> From: Michael Traher [mailto:[EMAIL PROTECTED] 
> Sent: Tuesday, October 24, 2006 1:21 PM
> To: CF-Talk
> Subject: Re: ANN: CFFormProtect, new open source project
> 
> what advantage does it have over the usual CAPTCHA method 
> apart from being
> prettier? I would have thought that a bot would take its 1 in 
> 3 chance and
> you would therefore not block the bots so effectively.
> 
> On 10/24/06, Munson, Jacob <[EMAIL PROTECTED]> wrote:
> >
> > I'm releasing a new open source project, called 
> CFFormProtect (licensed
> > under MPL).  This attempts to be more user friendly than 
> the obfuscated
> > text type of CAPTCHA. CFFormProtect displays three pictures, and the
> > user is asked to click on the correct image. This is a variation of
> > CAPTCHA I've read about, but haven't seen in use.  You can see a
> > screenshot and get the download at the project page:
> > http://cfformprotect.riaforge.org/

"EMF " made the following annotations.
--
This transmission may contain information that is privileged, confidential 
and/or exempt from disclosure under applicable law. If you are not the intended 
recipient, you are hereby notified that any disclosure, copying, distribution, 
or use of the information contained herein (including any reliance thereon) is 
STRICTLY PROHIBITED. If you received this transmission in error, please 
immediately contact the sender and destroy the material in its entirety, 
whether in electronic or hard copy format. Thank you. 

==


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258058
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Unhashing a password with Coldfusion

2006-10-25 Thread Barney Boisvert
Hashes are not reversable, and the salt is used to further prevent
unhashing based on dictionary attacks.  To authenticate the password,
you'll need to hash the password using the salt and compare it to the
hashed password in the database.  If they match, the original
passwords were the same.  Chances are good the hash algorithm is MD5
or SHA-1, both of which CF supports via it's hash() built-in function.
 If you have an account that you know the password of, it should be
simple to figure out the right algorithm and salt/password assembly to
generate the approprate matching hash.  My first guess (in psuedocode)
would be:

creds = query("select salt, hashedPassword from aTable where username
= #form.username#");
incomingHash = hash(creds.salt & form.password);
if (incomingHash EQ creds.hashedPassword) {
  // it's valid!
}

cheers,
barneyb

On 10/25/06, Smith, Daron [PA] <[EMAIL PROTECTED]> wrote:
> Anyone have any experience in unhashing a Dotnetnuke password with CF.
> We need to authenticate a CF app with a DotNetNuke database.  The
> passwords are stored in a hashed format.  There is also a password salt
> field, which I'm assuming is a key to dehash the password field.  Any
> help would be appreciated.
>
> Thanks,
> Daron Smith
> PSEA IT
>
> "PSEA E-mail Firewall" annotation on Wed Oct 25 2006 16:17:48
> -
> NOTICE: Only the individual sender is responsible for the content of the 
> message, and the message does not necessarily reflect the position or policy 
> of the Pennsylvania State Education Association.
> -
>
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258057
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Unhashing a password with Coldfusion

2006-10-25 Thread Smith, Daron [PA]
Anyone have any experience in unhashing a Dotnetnuke password with CF.
We need to authenticate a CF app with a DotNetNuke database.  The
passwords are stored in a hashed format.  There is also a password salt
field, which I'm assuming is a key to dehash the password field.  Any
help would be appreciated.

Thanks,
Daron Smith
PSEA IT

"PSEA E-mail Firewall" annotation on Wed Oct 25 2006 16:17:48
-
NOTICE: Only the individual sender is responsible for the content of the 
message, and the message does not necessarily reflect the position or policy of 
the Pennsylvania State Education Association.
-


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258056
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: WebServices Question

2006-10-25 Thread Charles E. Heizer
So yes, it's a cfc called qAD.cfc. So if I run qAD.cfc?wsdl that works fine.
So is there a way to do a http get request for my function called getDN
that's in my WebService?

Thanks,
- Charles


On 10/25/06 12:55 PM, "Alan Rother" <[EMAIL PROTECTED]> wrote:

> First off, did you create it using a CFC?
> 
> Assuming you did and you set the access to "remote"
> 
> All you need to do is this:
> 
> http://www.MYWEBSITEURLHERE.com/MYCFCFOLDERHERE/MYCFCNAME.cfc?wsdl
> 
> That will generate the WSDL


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258055
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: WebServices Question

2006-10-25 Thread Alan Rother
First off, did you create it using a CFC?

Assuming you did and you set the access to "remote"

All you need to do is this:

http://www.MYWEBSITEURLHERE.com/MYCFCFOLDERHERE/MYCFCNAME.cfc?wsdl

That will generate the WSDL

-- 
Alan Rother
Adobe Certified Advanced ColdFusion MX 7 Developer


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258054
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Query of Query

2006-10-25 Thread Ben Koshy
I believe I read somewhere that Query of Query performs best with recordsets 
that are 50,000 records or smaller.

- Original Message - 
From: "Ken" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Thursday, October 26, 2006 12:54 AM
Subject: Query of Query


> Hi. I want to hold the results of a query in a session variable, and
> then when the user has gone couple of pages further, I want to refine
> the search by doing a Query of Query on the previous query held in the
> session.
> Is this method ok, or can anyone suggest a method to do refined searches?
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258053
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Query of Query

2006-10-25 Thread Brad Wood
Agreed.  Just be careful of how large the result sets may be.  If you
begin storing tens of thousands of records in memory for hundreds of
users, your JVM heap might start growing like crazy.  It shouldn't be a
problem on a smaller scale, though. 

~Brad

-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 25, 2006 2:29 PM
To: CF-Talk
Subject: RE: Query of Query

There's nothing wrong with what you are saying, other than it is not all
that clear. But yes, you can refine searches stored in memory. Heck, you
can even name them the same thing.

Let's say you have a query in memory names SESSION.UserSearch... And you
want to refine it, you should be able to do:


SELECT
[columns]
FROM
SESSION.UserSearch
WHERE
date_created > [criteria]
 

This takes the SESSION.UserSearch query in memory and basically over
writes it with a query of queries on itself.


...
Ben Nadel
Certified Advanced ColdFusion Developer
www.bennadel.com
 

-Original Message-
From: Ken [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 25, 2006 3:25 PM
To: CF-Talk
Subject: Query of Query

Hi. I want to hold the results of a query in a session variable, and
then when the user has gone couple of pages further, I want to refine
the search by doing a Query of Query on the previous query held in the
session.
Is this method ok, or can anyone suggest a method to do refined
searches?





~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258052
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Query of Query

2006-10-25 Thread Ben Nadel
There's nothing wrong with what you are saying, other than it is not all
that clear. But yes, you can refine searches stored in memory. Heck, you
can even name them the same thing.

Let's say you have a query in memory names SESSION.UserSearch... And you
want to refine it, you should be able to do:


SELECT
[columns]
FROM
SESSION.UserSearch
WHERE
date_created > [criteria]
 

This takes the SESSION.UserSearch query in memory and basically over
writes it with a query of queries on itself.


..
Ben Nadel
Certified Advanced ColdFusion Developer
www.bennadel.com
 

-Original Message-
From: Ken [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 25, 2006 3:25 PM
To: CF-Talk
Subject: Query of Query

Hi. I want to hold the results of a query in a session variable, and
then when the user has gone couple of pages further, I want to refine
the search by doing a Query of Query on the previous query held in the
session.
Is this method ok, or can anyone suggest a method to do refined
searches?



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258051
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Query of Query

2006-10-25 Thread Ken
Hi. I want to hold the results of a query in a session variable, and
then when the user has gone couple of pages further, I want to refine
the search by doing a Query of Query on the previous query held in the
session.
Is this method ok, or can anyone suggest a method to do refined searches?

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258050
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


WebServices Question

2006-10-25 Thread Charles E. Heizer
Hello,
I have created a web service and it's been published and I can call it just
fine using coldfusion. My question is, I have a colleague who is using .Net
to create a web service and when I look at the WSDL it's nicely formatted
and with the different ways to call it. I also has an exmaple on how to call
it using a http get.

So my question is really two, is there a way to have cf display a nicely
formatted WSDL page and in my current web service how can I call it using
http get command?

Thanks,
- Charles



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258049
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: XML Question...

2006-10-25 Thread Charles E. Heizer
Thanks!

Your right this is a lot easier...


On 10/25/06 11:29 AM, "Rob Wilkerson" <[EMAIL PROTECTED]> wrote:

> On 10/25/06, Charles E. Heizer <[EMAIL PROTECTED]> wrote:
>> What is cfxml?
> 
> Just another CFML tag.
> 
> http://www.cfquickdocs.com/?sourceid=cfQDSearch1.02&getDoc=cfxml
> 
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258048
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Frameworks Conf early bird and CFUNITED call for speakers ends 10/31/06, Version control interview

2006-10-25 Thread Michael Smith
In this week's Newsletter:

* Frameworks early early bird price ends 10/31/06
* Vote for the Frameworks Conference Topics!
* CFUNITED-07 call for speakers ends 10/31/06
* CFUNITED-07 dates and hotel announced
* BlueDragon 7 and Development Best Practices Webinar 11/9/06
* Interview with Sholomy Gantz on "Version Control 101 with Subversion"

--
* Frameworks early early bird price ends 10/31/06

The early early bird price of $299 on Frameworks conference end midnight 
EST Tuesday 10/31/06
After that date it will be $399.

Date: 2/1/07 - 2/2/07

Location: North Bethesda Marriott (same as CFUNITED) near Washington DC

http://www.frameworksconference.com

Topics from last year were:

*Advanced*
Using Fusebox with CFCs: An OO Approach - Hal Helms
Leveraging the Fusebox 4 XML Vocabularies - Jeff Peters
Migrating Applications Between Frameworks - Joe Rinehart
Taming Framework XML files with XSLT and Xdoclet - John Paul Ashenfelter
Layouts in Fusebox 4 - Sandy Clark
Lock/key security plugin - Sandy Clark
Best Practices and Frameworks - Simon Horwith
Creating Your Own XML Verbs in Fusebox - John Quarto-vonTivadar

*Basic*
Introduction to Fusebox - Simon Horwith
Fusedocs for Better Code - Hal Helms
Building your first FB application - Jeff Peters
Optimizing Architectures for Search Engines - Jon Rowny
Strategies for Successful Development with FliP - Maxim Porges
Using FLiP to streamline your distributed development business model 
Workshop - Michael Smith
This Glue Dries Fast - Joe Rinehart

*Keynote*
The Psychology of Frameworks - Jeff Peters and Hal Helms

*Other*
Managing Your Career as a Developer - Scott Knaub
Mach-II Architecture: Under the Hood - Ben Edwards
Power onTap - Isaac Dealey
Ruby on Rails for CF Developers - John Paul Ashenfelter
TheHUB - A ColdFusion Application Framework - Neil Ross
Tartan Framework and Service Architectures - Paul Kenney
Head First Mach-II - Matthew Woodward
Easy Java/J2EE with ColdFusion and the Spring Framework - Maxim Porges

--

*VOTE for 2007 Frameworks Conference Topics!
Go to http://www.frameworksconference.com/survey.cfm

--
* CFUNITED-07 call for speakers ends 10/31/06
Suggest your favorite topic or speaker or suggest yourself!
http://www.cfunited.com/2007/

CFUNITED-07 is Wed 6/27/06 - Sat 6/30/06 at North Bethesda Marriott, 
just outside
Washington DC (same great hotel as last year!).
Registration will open next week.


* BlueDragon 7 and Development Best Practices Webinar 11/9/06
New Atlanta will be demoing the latest release of their CFML compiler 
BlueDragon 7
and I will be talking about Development Best Practices at the Webinar on 
11/9/06.
at 1pm-2pm EST. Look out for the invite in the next week.



Michael Smith: This time we are talking with Shlomy Gantz about his
CFUNITED-06 talk "Version Control 101 with Subversion".
What is interesting about your session Shlomy?

Shlomy Gantz: If you want to know more about version control in general 
and specifically
about setting up and using Subversion this session is for you. Version
Control has long been a sore spot for many developers. Systems were either
too complex to use and set up or incredibly expensive. Subversion is free
and easy to install and use and as such is a perfect system for both
beginner and advanced developers.

MS: What exactly is version control and why would I want to use it?

SG: "Management of multiple revisions of the same unit of information".
Simply put, a version control system enables the developer to save multiple
revisions of his/her code, rolling back to a previous version if necessary
and much much more.

MS: And if I don't use version control what can happen?

SG: Well, has this ever happened to you? You change some code, The
application breaks... You change the code back... The application is still
broken ... What do you do?

MS: Ouch! Ok now I remember why we use it at TeraTech!
Are there any other benefits to using version control?

SG: Of course, using version control enables you to more efficiently develop
in parallel,
manage different customized versions of your code etc...

MS: So how do I get and install subversion?

SG: You can come to my presentation and get step by step instructions 
:-)  or
go to http://subversion.tigris.org/ and follow the instructions.

MS: Does it work with CF Studio, Dreamweaver or CFEclipse?

SG: CF Studio and Dreamweaver have very basic version control integration,
but some third party tools exist that integrate the two. The Eclipse
platform has a few plug-ins that enable it to work seamlessly with
subversion, and best of all, IT'S FREE.

MS: So what is this Tortoise thing I keep hearing about when people mention
subversion? Will you cover that too?

SG: TortoiseSVN is a Free Subversion Client that uses allows you to perform
Most Subversion operations directly from Windows Explorer, and YES , I will
Definitely demonstrate using TortoiseSVN.

MS: It was good to see you at CF-Underground Sunday.

Yo

Invoking CFIDE.adminapi.base components

2006-10-25 Thread Jon Clausen
I'm trying to create a Coldfusion datasource on the fly using the  
RDSInvoker method in the CFIDE.adminapi.base component.   Here's what  
I've got for the creation code:


dbname = "thenewdsn";
dsnArgs.name = dbname;
dsnArgs.url = application.jdbcURL & dbname;
dsnArgs.class = application.dbdriver;
dsnArgs.driver = "Postgres Driver";
dsnArgs.username = application.dbowner;
dsnArgs.password = application.dbownerpass;



The adminapi.base doesn't seem to accept my calling  the datasource  
method, however the inheritance of the  CFIDE.adminapi.datasource  
should allow it.

A dump of #newDSN# provides this response:   "Only ADMINAPI  
componenets may be invoked through RDS."

Here's the cfcexplorer text of the RDSInvoker method:

RDSInvoker
public RDSInvoker ( required service, required method, required args,  
required adminPassword )

Used internally to invoke the Administrator API

Output: suppressed
Parameters:
service: any, required, service - Name of service.
method: any, required, method - Name of method to invoke.
args: any, required, args - Arguments for remote method.
adminPassword: any, required, adminPassword - RDS password for  
authentication

I'm guessing it's a syntax issue in my service argument.Does  
anyone have any thoughts on what I need to do differently?   I've  
tried "CFIDE.adminapi.datasource" but it will only accept a string  
variable.

When you call CFIDE.adminapi.datasource directly, it throws a  
permissions error.

Also, I'd be open to using another method apart from RDS, if anyone  
has any suggestions.

Thanks,
Jon

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258046
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CF and HL7

2006-10-25 Thread Dan O'Keefe
Is HL7 the XML like messaging interface used in the medical industry?

Dan

On 10/25/06, Brendan Canty <[EMAIL PROTECTED]> wrote:
>
> Does anyone know if a vendor that makes an app the generates HL7 messages
> that integrates with CF?
>
> Brendan Canty
> NorthPoint Domain
> [EMAIL PROTECTED]
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258045
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: XML Question...

2006-10-25 Thread Rob Wilkerson
On 10/25/06, Charles E. Heizer <[EMAIL PROTECTED]> wrote:
> What is cfxml?

Just another CFML tag.

http://www.cfquickdocs.com/?sourceid=cfQDSearch1.02&getDoc=cfxml

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258044
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: XML Question...

2006-10-25 Thread Charles E. Heizer
What is cfxml?


On 10/25/06 10:15 AM, "Rob Wilkerson" <[EMAIL PROTECTED]> wrote:

> Just out of curiosity, what about using ?  It's a much more
> readable method of creating an XML doc, IMO.
> 
> On 10/25/06, Charles E. Heizer <[EMAIL PROTECTED]> wrote:
>> Hello,
>> So I'm playing with creating a xml file but I'm not sure what I'm doing
>> wrong. The problem is that it's only displaying dn and it's text.
>> 
>> Thanks,
>> - Charles
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> #MyDoc#
>> 
>> 
>> 
> 
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258043
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Powerbuilder 10 and CF7.01

2006-10-25 Thread Rey Bango
Its a client/server development tool used to build Enterprise-capable 
desktop applications. Its been GREATLY enhanced to also work in the 
Internet-space. When I used it before, the best description was Visual 
Basic on steroids.

Rey...

Peterson, Chris wrote:
> Ok, everyone is talking about Powerbuilder now... Anyone care to give
> any details as to what it does and what its used for without any
> sales-speak?  I don't want to fill out their survey and get more
> junk-mail just to download a trial I wouldn't use =)
> 
> Chris
> 
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258042
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Powerbuilder 10 and CF7.01

2006-10-25 Thread Peterson, Chris
Ok, everyone is talking about Powerbuilder now... Anyone care to give
any details as to what it does and what its used for without any
sales-speak?  I don't want to fill out their survey and get more
junk-mail just to download a trial I wouldn't use =)

Chris

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258041
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Powerbuilder 10 and CF7.01

2006-10-25 Thread Rey Bango
No way! Man, I did PB work from 2.x through 7.0. I still own a copy of 
PB 7. It was the last gift from Sybase before I retired from Team 
Powersoft/Team Sybase.

I LOVED coding in PowerBuilder and it was way ahead of its time.

Rey...

Bryan Stevenson wrote:
>>>PowerBuilder!!! Wow, thats a blast from my past.
>>>
>>
>>The title caught my eye...I'm ex-Powersoft (left after the Sybase merger for 
>>Allaire), now running the ColdFusion engineering team...
>>
>>You can see the roots in the FlexBuilder 2 CF App Wizard, I think :)
>>
>>Damon
> 
> 
> LOL...it's alive and well here.  We have built and continue to maintain many 
> PowerBuilder Apps for one of our clients (a large ferry corporation).
> 
> Cheers
> 
> Bryan Stevenson B.Comm.
> VP & Director of E-Commerce Development
> Electric Edge Systems Group Inc.
> phone: 250.480.0642
> fax: 250.480.1264
> cell: 250.920.8830
> e-mail: [EMAIL PROTECTED]
> web: www.electricedgesystems.com 
> 
> 
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258040
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: XML Question...

2006-10-25 Thread Dave Watts
> So I'm playing with creating a xml file but I'm not sure what 
> I'm doing wrong. The problem is that it's only displaying dn 
> and it's text.

If you want to output the contents of an XML document object to your page,
you'll need to convert it to a string using ToString. I'd also second Rob's
recommendation to use CFXML - it's a lot easier.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
 
Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore and Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258039
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: XML Question...

2006-10-25 Thread Rob Wilkerson
Just out of curiosity, what about using ?  It's a much more
readable method of creating an XML doc, IMO.

On 10/25/06, Charles E. Heizer <[EMAIL PROTECTED]> wrote:
> Hello,
> So I'm playing with creating a xml file but I'm not sure what I'm doing
> wrong. The problem is that it's only displaying dn and it's text.
>
> Thanks,
> - Charles
>
>
>
>
> 
> 
> 
>
> 
>
>
> 
>
> 
>
> 
>
> #MyDoc#
>
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258038
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Sybase Data source for ASA 8

2006-10-25 Thread Mike Elmalem
Hello All,
I am trying to create a datasource on CFMX to Sybase ASA 8 database.
Previously I was using an Odbc socket datasource, but this is no longer 
possible.  I tried connecting using the built in Sybase driver but this did not 
work.  After searching for a while I still could find the procedure to setup a 
jdbc connection.  Can anyone point me in right direction?

Thanks,

Mike

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258037
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: adding controls

2006-10-25 Thread Richard White
thanks very much :)

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258036
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


XML Question...

2006-10-25 Thread Charles E. Heizer
Hello,
So I'm playing with creating a xml file but I'm not sure what I'm doing
wrong. The problem is that it's only displaying dn and it's text.

Thanks,
- Charles







   

  







#MyDoc#


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258035
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


CF and HL7

2006-10-25 Thread Brendan Canty
Does anyone know if a vendor that makes an app the generates HL7 messages that 
integrates with CF?

Brendan Canty
NorthPoint Domain
[EMAIL PROTECTED]

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258034
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: DB2 Cursor question

2006-10-25 Thread Peterson, Chris
You could always try a subselect inside your primary query, or use DB2's
'FETCH FIRST X ROWS ONLY' to get only 1 row, not sure why you are using
a cursor for it?


Chris Peterson 

-Original Message-
From: Dan Plesse [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 25, 2006 12:49 PM
To: CF-Talk
Subject: Re: DB2 Cursor question

With JDBC I always had to set the object fist to allow that to happen.

On 10/24/06, Loathe <[EMAIL PROTECTED]> wrote:
>
> Let's try this again.
>
> Asume the following table:
>
> aftest.tperdet
>
> mac_id (varchar)
> parno (varchar)
> ident (char)
>
> How would I write a cursor to say, pull a single row, and just return 
> that record?
>
> Again, this is just a proof of concept, never had to use them before, 
> just trying to get a cursor that will execute from a query block, that

> I can also test using a native Java class I am writing.
>
> > -Original Message-
> > From: Loathe [mailto:[EMAIL PROTECTED]
> > Sent: Monday, October 23, 2006 9:38 PM
> > To: CF-Talk
> > Subject: DB2 Cursor question
> >
> >
> > Never really had to user cursors before now, thank god.
> >
> > Now I have to :(
> >
> > So we are comparing performance across several different drivers and
> such.
> >
> > Right now I'm stuck on getting something that will even run.
> >
> > I'm trying this:
> >
> > 
> >   
> >   Declare CursorPas Cursor for
> >   Select
> >   par_pas_nr
> >   From
> >   pas_data_ref
> >   Where
> >   pas_nr = 'F3LQ'
> >
> >   open CursorPas
> >   fetch CursorPas into myField
> >   close CursorPas
> >   
> >   
> >   
> >   
> >   
> >   
> >   
> >   
> >
> > 
> > 
> >
> > To see if we can execute cursors inline, becuase we cannot use 
> > stored procedures.
> >
> > Is there something wrong with that?
> >
> > I don't even know, this is cobbeled together from a couple different

> > sources.
> >
> > Generated SQL:
> >
> > Declare CursorPas Cursor for Select par_pas_nr From 
> > aftest.pas_data_ref Where pas_nr = 'F3LQ' open CursorPas fetch 
> > CursorPas into myField close CursorPas
> >
> > SQL Code: -199
> > SQL State: 42601
> >
> > TIA
> >
> >
> >
> >
>
> 



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258033
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: adding controls

2006-10-25 Thread Andy Matthews
You don't need a while loop. Just output the query like so:


input box #currentrow#: 


That will create a number of input boxes each named using the currentrow
attribute of the query loop. It's a sort of built-in counter.



-Original Message-
From: Richard White [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 25, 2006 11:28 AM
To: CF-Talk
Subject: adding controls


hi, i have a query that returns a number of rows. the number of rows is not
known.

I want to be able to add a number of text boxes on the page dependant on how
many rows it has returned. Basically i wanted to do a whiole loop that
looped through all of the rows, got their data, created a text box and
placed the data in the text box, then move onto the next row and do the
same.

I have got lost as of course i cannot add the text boxes within cfscript or
javascript. But i need to use cfscript or javascript in order to implement
the while loop to loop through the rows getting their data and putting it in
the text boxes

does anyone have any advice on how i can achieve this

thanks very much for any help



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258032
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: adding controls

2006-10-25 Thread Sandra Clark




 
In cfscript


if (myQuery.RecordCount gt 0) {
  do {
writeOutput('');
WriteOutput('');
WriteOutput('');
  } while (myQuery.currentRow LTE myQuery.RecordCount);
}
 


Sandra Clark
==
http://www.shayna.com
Training in Cascading Style Sheets and Accessibility


-Original Message-
From: Richard White [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 25, 2006 12:28 PM
To: CF-Talk
Subject: adding controls

hi, i have a query that returns a number of rows. the number of rows is not
known.

I want to be able to add a number of text boxes on the page dependant on how
many rows it has returned. Basically i wanted to do a whiole loop that
looped through all of the rows, got their data, created a text box and
placed the data in the text box, then move onto the next row and do the
same.

I have got lost as of course i cannot add the text boxes within cfscript or
javascript. But i need to use cfscript or javascript in order to implement
the while loop to loop through the rows getting their data and putting it in
the text boxes

does anyone have any advice on how i can achieve this

thanks very much for any help



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258031
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: DB2 Cursor question

2006-10-25 Thread Dan Plesse
With JDBC I always had to set the object fist to allow that to happen.

On 10/24/06, Loathe <[EMAIL PROTECTED]> wrote:
>
> Let's try this again.
>
> Asume the following table:
>
> aftest.tperdet
>
> mac_id (varchar)
> parno (varchar)
> ident (char)
>
> How would I write a cursor to say, pull a single row, and just return that
> record?
>
> Again, this is just a proof of concept, never had to use them before, just
> trying to get a cursor that will execute from a query block, that I can
> also
> test using a native Java class I am writing.
>
> > -Original Message-
> > From: Loathe [mailto:[EMAIL PROTECTED]
> > Sent: Monday, October 23, 2006 9:38 PM
> > To: CF-Talk
> > Subject: DB2 Cursor question
> >
> >
> > Never really had to user cursors before now, thank god.
> >
> > Now I have to :(
> >
> > So we are comparing performance across several different drivers and
> such.
> >
> > Right now I'm stuck on getting something that will even run.
> >
> > I'm trying this:
> >
> > 
> >   
> >   Declare CursorPas Cursor for
> >   Select
> >   par_pas_nr
> >   From
> >   pas_data_ref
> >   Where
> >   pas_nr = 'F3LQ'
> >
> >   open CursorPas
> >   fetch CursorPas into myField
> >   close CursorPas
> >   
> >   
> >   
> >   
> >   
> >   
> >   
> >   
> >
> > 
> > 
> >
> > To see if we can execute cursors inline, becuase we cannot use stored
> > procedures.
> >
> > Is there something wrong with that?
> >
> > I don't even know, this is cobbeled together from a couple different
> > sources.
> >
> > Generated SQL:
> >
> > Declare CursorPas Cursor for Select par_pas_nr From aftest.pas_data_ref
> > Where pas_nr = 'F3LQ' open CursorPas fetch CursorPas into myField close
> > CursorPas
> >
> > SQL Code: -199
> > SQL State: 42601
> >
> > TIA
> >
> >
> >
> >
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258030
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


adding controls

2006-10-25 Thread Richard White
hi, i have a query that returns a number of rows. the number of rows is not 
known.

I want to be able to add a number of text boxes on the page dependant on how 
many rows it has returned. Basically i wanted to do a whiole loop that looped 
through all of the rows, got their data, created a text box and placed the data 
in the text box, then move onto the next row and do the same.

I have got lost as of course i cannot add the text boxes within cfscript or 
javascript. But i need to use cfscript or javascript in order to implement the 
while loop to loop through the rows getting their data and putting it in the 
text boxes

does anyone have any advice on how i can achieve this

thanks very much for any help

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258029
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Tag Insight from a DTD

2006-10-25 Thread Robertson-Ravo, Neil (RX)
Thanks Dave, Sandra

I will take a look at these...




"This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
Registered in England, Number 678540.  It contains information which is
confidential and may also be privileged.  It is for the exclusive use of the
intended recipient(s).  If you are not the intended recipient(s) please note
that any form of distribution, copying or use of this communication or the
information in it is strictly prohibited and may be unlawful.  If you have
received this communication in error please return it to the sender or call
our switchboard on +44 (0) 20 89107910.  The opinions expressed within this
communication are not necessarily those expressed by Reed Exhibitions." 
Visit our website at http://www.reedexpo.com

-Original Message-
From: Dave Watts
To: CF-Talk
Sent: Wed Oct 25 17:13:12 2006
Subject: RE: Tag Insight from a DTD

> Anyone know of any XML editors which provide tag insight 
> based off a DTD?

I'm pretty sure that XMLSpy does this.

http://www.altova.com/products/xmlspy/xml_editor.html

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
 
Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore and Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258028
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Image upload impacting web server performance

2006-10-25 Thread Richard Cooper
I think you can do this with javascript? 

// Declare a new image to obtain math values
x=new Image;
x.src=element.value;
is=Math.ceil(x.fileSize/1000);

This is a snippet of an old piece of javascript that I used for previewing and 
uploading multiple image files. I'm not 100% that I got the file size preview 
to work but I think I did.

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258027
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: cf date conversion

2006-10-25 Thread Andy Matthews
It sucks, but that's the way CF returns dates, regardless of their
formatting in the DB.

To return it usable for you, just use CF's DateFormat function:

DateFormat(dbDateField,"-mm-dd") gives you 2006-10-25
DateFormat(dbDateField,"mmm dd, ") gives you October 25, 2006



-Original Message-
From: Richard White [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 25, 2006 10:48 AM
To: CF-Talk
Subject: cf date conversion


hi, i have a field saved in mysql database as a Date type
oddly when i run a cfquery to get it out of the database it comes back with
the following:

{ts '2001-01-01 00:00:00'}

i am assuming ts means timestamp but this seems odd as it is saved as a date
type and if i run the query in the mysql database it just returns
2001-01-01. Am i doing something wrong, or is there a function in cf to
convert the above into just the date value that mysql outputs

thanks for any help



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258026
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: cf date conversion

2006-10-25 Thread Jake Churchill
DateFormat(datevar, '-mm-dd') would output 2001-01-01 just as in the 
mysql database.  I think date in mysql is date/time.  Instead of 
'-mm-dd' there are names like 'short', 'medium', 'long' and 'full' 
but I don't remember off the top of my head what they output.  I think 
you would want 'short' so DateFormat(datevar, 'short')

Richard White wrote:
> hi, i have a field saved in mysql database as a Date type
> oddly when i run a cfquery to get it out of the database it comes back with 
> the following:
>
> {ts '2001-01-01 00:00:00'}
>
> i am assuming ts means timestamp but this seems odd as it is saved as a date 
> type and if i run the query in the mysql database it just returns 2001-01-01. 
> Am i doing something wrong, or is there a function in cf to convert the above 
> into just the date value that mysql outputs
>
> thanks for any help
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258024
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Tag Insight from a DTD

2006-10-25 Thread Dave Watts
> Anyone know of any XML editors which provide tag insight 
> based off a DTD?

I'm pretty sure that XMLSpy does this.

http://www.altova.com/products/xmlspy/xml_editor.html

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
 
Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore and Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258025
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Tag Insight from a DTD

2006-10-25 Thread Sandra Clark
Oxygen for Eclipse
 


Sandra Clark
==
http://www.shayna.com
Training in Cascading Style Sheets and Accessibility


-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 25, 2006 12:04 PM
To: CF-Talk
Subject: Tag Insight from a DTD

Anyone know of any XML editors which provide tag insight based off a DTD?

i.e. I have an XML doc and it has a defined DTD, just wondering if there is
an editor out there which supports a sort of insight when you press space to
say..hey I looked at the DTD and here is what you can add

Anyone...bueller?





~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258023
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: cf date conversion

2006-10-25 Thread Richard White
thanks very much it works fine now :)

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258022
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Tag Insight from a DTD

2006-10-25 Thread Robertson-Ravo, Neil (RX)
Anyone know of any XML editors which provide tag insight based off a DTD?

i.e. I have an XML doc and it has a defined DTD, just wondering if there is
an editor out there which supports a sort of insight when you press space to
say..hey I looked at the DTD and here is what you can add

Anyone...bueller?



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258021
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: cf date conversion

2006-10-25 Thread loathe
That's an ODBC Date.

Just use dateFormat() to make it look however you want.

> -Original Message-
> From: Richard White [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, October 25, 2006 11:48 AM
> To: CF-Talk
> Subject: cf date conversion
> 
> hi, i have a field saved in mysql database as a Date type
> oddly when i run a cfquery to get it out of the database it comes back
> with the following:
> 
> {ts '2001-01-01 00:00:00'}
> 
> i am assuming ts means timestamp but this seems odd as it is saved as a
> date type and if i run the query in the mysql database it just returns
> 2001-01-01. Am i doing something wrong, or is there a function in cf to
> convert the above into just the date value that mysql outputs
> 
> thanks for any help
> 
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258020
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


cf date conversion

2006-10-25 Thread Richard White
hi, i have a field saved in mysql database as a Date type
oddly when i run a cfquery to get it out of the database it comes back with the 
following:

{ts '2001-01-01 00:00:00'}

i am assuming ts means timestamp but this seems odd as it is saved as a date 
type and if i run the query in the mysql database it just returns 2001-01-01. 
Am i doing something wrong, or is there a function in cf to convert the above 
into just the date value that mysql outputs

thanks for any help

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258019
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Mime Type for File Upload

2006-10-25 Thread Rick Faircloth
Thanks!

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 25, 2006 11:22 AM
To: CF-Talk
Subject: RE: Mime Type for File Upload

> Thanks for the advice, Dave...and what does this mean in practice?
> 
> "you don't want to allow files to be placed where they could 
> be potentially executed."

Set the permissions on the directory where you write these files so that
they can't be executed by CF or your web server, and don't make the
directory web-accessible.







~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258018
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Using PDF's...

2006-10-25 Thread Mingo Hagen
Except for Safari on Mac OS X of course... That one has native PDF reading.
Mingo.


Sandra Clark wrote:
> Its added in by the Adobe Acrobat Reader when its installed. None of today's
> browsers can read it natively that I know of 



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258017
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Powerbuilder 10 and CF7.01

2006-10-25 Thread Bryan Stevenson
> >PowerBuilder!!! Wow, thats a blast from my past.
>>
>
> The title caught my eye...I'm ex-Powersoft (left after the Sybase merger for 
> Allaire), now running the ColdFusion engineering team...
>
> You can see the roots in the FlexBuilder 2 CF App Wizard, I think :)
>
> Damon

LOL...it's alive and well here.  We have built and continue to maintain many 
PowerBuilder Apps for one of our clients (a large ferry corporation).

Cheers

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com 


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258016
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: URL for CF7 Multi-Server configurations

2006-10-25 Thread Rob Wilkerson
On 10/25/06, Dave Hatz <[EMAIL PROTECTED]> wrote:
> Do you run Apache on Win box?

Yes.  And Linux, and mac (OS X), and Solaris.  :-)

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258015
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: REPOST: CFDOCUMENT and CFCONTENT

2006-10-25 Thread Bryan Stevenson
> Hi Bryan,
>
> Do the images work on your localhost, but fail on production? If so,
> then please read Ben Nadel's post regarding route-back:
>
> http://www.bennadel.com/blog/266-CFDocument-Errors-And-Resolving-DNS.htm
>
> Hope this helps,
> Kris

Thanks Kris, but I doubt that is the issue as it works just fine with images on 
the box referenced directly with an IMG tag (i..e http://domain.com/images/image.jpg>).  The problem arises when I use 
CFCONTENT to push the image.

That and Ben's post mentions an error messageI just get a red "X" in place 
of the image in my FlashPaper/PDF docs.

That said, I'll try anything ;-)

Cheers

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com 


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258014
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Using PDF's...

2006-10-25 Thread Sandra Clark
Its added in by the Adobe Acrobat Reader when its installed. None of today's
browsers can read it natively that I know of 


Sandra Clark
==
http://www.shayna.com
Training in Cascading Style Sheets and Accessibility


-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 25, 2006 11:21 AM
To: CF-Talk
Subject: Using PDF's...

No exactly about CF coding.but, I am using CF to handle the files.s..
;o)

Just curious if today's browsers, especially IE, have built-in support for
reading PDF's.  I mean they are able to open them and print them without
having Acrobat Reader installed.

I can't test it, since all my computers have Acrobat Reader already
installed.

I'm encouraging a client to use only PDF's for their read-only documents,
rather than .doc's, because their site visitors will have to have MS Word to
open the .doc files, but PDF's can be opened in the browser.  I just didn't
know if that capability was built-in, or added-in by the installation of
Acrobat Reader.

Correct.Incorrect.Info.advice???

Rick





~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258013
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Using PDF's...

2006-10-25 Thread Ian Skinner
I just didn't know if that capability was built-in, or added-in by the 
installation of Acrobat Reader.

I believe it is still required to have Acrobat Reader installed to view PDF's.  
What I'm not sure is how common it maybe to have Reader bundled with modern 
installs of some of the popular browsers.


--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

-
| 1 |   |
-  Binary Soduko
|   |   |
-
 
"C code. C code run. Run code run. Please!"
- Cynthia Dunning

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message. 




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258012
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Using PDF's...

2006-10-25 Thread Rick Faircloth
No exactly about CF coding.but, I am using CF
to handle the files.s.. ;o)

Just curious if today's browsers, especially IE,
have built-in support for reading PDF's.  I mean
they are able to open them and print them without
having Acrobat Reader installed.

I can't test it, since all my computers have Acrobat Reader
already installed.

I'm encouraging a client to use only PDF's for their read-only
documents, rather than .doc's, because their site visitors will
have to have MS Word to open the .doc files, but PDF's can
be opened in the browser.  I just didn't know if that capability
was built-in, or added-in by the installation of Acrobat Reader.

Correct.Incorrect.Info.advice???

Rick



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258011
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Mime Type for File Upload

2006-10-25 Thread Dave Watts
> Thanks for the advice, Dave...and what does this mean in practice?
> 
> "you don't want to allow files to be placed where they could 
> be potentially executed."

Set the permissions on the directory where you write these files so that
they can't be executed by CF or your web server, and don't make the
directory web-accessible.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
 
Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore and Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258010
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Mime Type for File Upload

2006-10-25 Thread Rick Faircloth
Thanks for the advice, Dave...and what does this mean
in practice?

"you don't want to allow files to be placed where they could be potentially
executed."

Rick

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 25, 2006 10:48 AM
To: CF-Talk
Subject: RE: Mime Type for File Upload

> > if someone wants to upload an .exe file all they have to do 
> > is give it a .pdf extension.  Plan your security for that as 
> > best you can.
> 
> What type of security can prevent that?  What can truly 
> determine what type of file a file is except by extension?

Well, the extension isn't what gives the ability to do one thing or another,
it's the actual contents of the file. The extension is just a convenience
used by Windows to determine the file type without having to actually read
and interpret the contents of the file. Other operating systems don't use
extensions, they use other file metadata (resource forks, etc) to figure
this out.

There are third-party libraries that can determine what type a file is, by
examining the file itself.

However, you should simply assume that all files, under the right
conditions, could be executable. So, you don't want to allow files to be
placed where they could be potentially executed.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
 






~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258009
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Mime Type for File Upload

2006-10-25 Thread Rick Faircloth
Thanks for the advice, Mosh!

Rick

-Original Message-
From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 25, 2006 9:44 AM
To: CF-Talk
Subject: RE: Mime Type for File Upload

Rick Faircloth wrote:
> Need to specify the CFFILE "Accept" attributes for .doc and .pdf.
>
> What would those be?
>
> I know Accept  = "application/msword" would accept
> Word docs, but would they be limited .doc filetype?
>
> And what about .pdf. application or text or ???
>
> I want to limit uploads to .doc and .pdf only.

Rick:

The two Mime-Types you're after are application/msword and application/pdf.
You would use these like:



ColdFusion does, in fact, use the HTTP headers to determine the Mime-Type of
the uploaded file.  The browser automatically determines the Mime-Type and
includes that as an HTTP header.  How the browser determines it is browser
and OS dependant.  Most browsers and OSs simply use the file's extension to
determine the file type.

Because of the trusting nature of HTTP, if someone wants to fool your
system, they're almost certainly going to be able to.  The user can change
the file extension, manually construct the HTTP header to specify an
incorrect Mime-Type, etc.  The only fool-proof way for you to guarantee that
you're getting what you expect is to have some sort of server-side
application that can check the CONTENTS of the uploaded file to ensure it is
what you think it is (ex. unzip utilities can often run a verification
operation on a file to validate that it is a ZIP file).  Checking the
filename and/or extension is not the least bit fool-proof.

The other extra precaution you can take, especially if you allow people to
upload files directly into a web-accessible path, is to run a virus scan on
the file as soon as it's uploaded.  Most modern AV solutions can scan
multiple file types (exe, com, doc, xls, zip, rar, etc.) for viruses.  Even
JPG files can contain malware.

HTH







~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258008
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: URL for CF7 Multi-Server configurations

2006-10-25 Thread Rob Wilkerson
On 10/25/06, Russ <[EMAIL PROTECTED]> wrote:
> I'm not really sure... I don't use CF with IIS.  I prefer apache, where you
> can plainly see your configuration at a glance.  Maybe if you run wsconfig
> you can see it there?
>
> Russ

Look on your start menu.  You should see a Macromedia program group.
Now go to Macromedia > ColdFusion MX 7 (Multiserver version) > Web
Server configuration Tool

This should show you what you're looking for, if memory serves (like
Russ, I'm largely an Apache guy, but I used IIS a bit more a few
months ago).

> > -Original Message-
> > From: Dave Hatz [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, October 25, 2006 10:29 AM
> > To: CF-Talk
> > Subject: RE: URL for CF7 Multi-Server configurations
> >
> > Russ,
> > Thanks for the clarification on that.  Question for you though, how can I
> > confirm that the site I have assigned with the wsconfig utility is using
> > the
> > correct CF Instance?  For example, I have 2 sites that have 2 different
> > instances assigned.  I want to make sure that I have correctly assigned
> > each
> > of my sites to the appropriate instance.
> >
> > Thanks,
> > Dave Hatz
> >
> > -Original Message-
> > From: Russ [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, October 24, 2006 4:50 PM
> > To: CF-Talk
> > Subject: RE: URL for CF7 Multi-Server configurations
> >
> > Each instance has a port on which the internal web server listens on
> > (which
> > you should disable).  It also has a port on which the jrun connector
> > listens
> > on.  This port gets automatically mapped for you using the wsconfig
> > utility.
> > IIS should just run on port 80 and use the host headers to differentiate
> > between different instances.
> >
> > Russ
> >
> >
> > > -Original Message-
> > > From: Dave Hatz [mailto:[EMAIL PROTECTED]
> > > Sent: Tuesday, October 24, 2006 6:47 PM
> > > To: CF-Talk
> > > Subject: RE: URL for CF7 Multi-Server configurations
> > >
> > > I set up multiple instances of CF7 Server.  Each Instance is using a
> > > different port to listen on.  So, don't I need to tell IIS to listen
> > > on that port?
> > >
> > > -Original Message-
> > > From: Russ [mailto:[EMAIL PROTECTED]
> > > Sent: Tuesday, October 24, 2006 3:36 PM
> > > To: CF-Talk
> > > Subject: RE: URL for CF7 Multi-Server configurations
> > >
> > > Why are you running iis6 on 8301?  You should be running it on port
> > 80...
> > > I
> > > believe 8301 was the port # for the internal webserver, which you
> > > should have disabled.
> > >
> > > Russ
> > >
> > > > -Original Message-
> > > > From: Dave Hatz [mailto:[EMAIL PROTECTED]
> > > > Sent: Tuesday, October 24, 2006 6:12 PM
> > > > To: CF-Talk
> > > > Subject: URL for CF7 Multi-Server configurations
> > > >
> > > > I am trying to figure out how not to display the port number in the
> > > > URL for multi-server CF7 installations.  I have created my different
> > > > servers and I am able to hit them all just fine, as long as I
> > > > include the port number they are listening on.  For example:
> > > >
> > > > http://www.mywebsite.com:8301/helloworld.cfm
> > > >
> > > > We are running on IIS6.  I have used the JRun Server Configuration
> > > > tool to map the web site too.  I have the web site properties in
> > > > IIS6 listening on port 8301 and my Host Header value is set to
> > > www.mywebsite.com.
> > > >
> > > > How can I get away from inlcuding the port number in my URL?  I
> > > > really don't want my clients to have to see that.
> > > >
> > > > Thanks,
> > > > Dave Hatz
> > > >
> > > >
> > >
> > >
> > >
> > >
> >
> >
> >
> >
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258007
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Developer Edition - Remote IP

2006-10-25 Thread David Low
Tried that, still blocked the second person from accessing.  Nobody else
has accessed the machine remotely...

> -Original Message-
> From: Andy Allan [mailto:[EMAIL PROTECTED]
> Sent: 25 October 2006 15:53
> To: CF-Talk
> Subject: Re: Developer Edition - Remote IP
> 
> Restart CF.
> 
> On 25/10/06, David Low <[EMAIL PROTECTED]> wrote:
> > We've got a genuine need to try and change the remote IP which has
been
> > set up for a developer edition of CFMX (6.1).  Having trawled the
> > settings and registry, I can't find any trace of the IP which was
> > accidentally used.
> >
> > Any ideas if it's possible to change this, once a remote IP has
> > connected to the dev machine?  Without needing a reinstall, that is.
> >
> > David
> >
> >
> >
> 
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258005
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: URL for CF7 Multi-Server configurations

2006-10-25 Thread Snake
This is a problme because every time you use the wsconfig tool it creates a
new connector rather than usuing any existing one for that instance, so the
numbers tell you nothing. This is why I tend to us ethe wsconfig only once
for each instance and then setup the mappings manually for further sites, so
my connectors match my isntances.
You have two options, look in the connector folder, one of these files show
sthe JDNI ports, which will correspond to your instance.

Or just stop the instance and test if the site still works.

Snake 

-Original Message-
From: Dave Hatz [mailto:[EMAIL PROTECTED] 
Sent: 25 October 2006 15:29
To: CF-Talk
Subject: RE: URL for CF7 Multi-Server configurations

Russ,
Thanks for the clarification on that.  Question for you though, how can I
confirm that the site I have assigned with the wsconfig utility is using the
correct CF Instance?  For example, I have 2 sites that have 2 different
instances assigned.  I want to make sure that I have correctly assigned each
of my sites to the appropriate instance.

Thanks,
Dave Hatz 



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258004
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Developer Edition - Remote IP

2006-10-25 Thread Snake
Restart CF, and the next connection will become the remote IP.

Snake 

-Original Message-
From: David Low [mailto:[EMAIL PROTECTED] 
Sent: 25 October 2006 15:41
To: CF-Talk
Subject: Developer Edition - Remote IP

We've got a genuine need to try and change the remote IP which has been set
up for a developer edition of CFMX (6.1).  Having trawled the settings and
registry, I can't find any trace of the IP which was accidentally used.

Any ideas if it's possible to change this, once a remote IP has connected to
the dev machine?  Without needing a reinstall, that is.

David




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258006
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: URL for CF7 Multi-Server configurations

2006-10-25 Thread Dave Watts
> Thanks for the clarification on that.  Question for you 
> though, how can I confirm that the site I have assigned with 
> the wsconfig utility is using the correct CF Instance?  For 
> example, I have 2 sites that have 2 different instances 
> assigned.  I want to make sure that I have correctly assigned 
> each of my sites to the appropriate instance.

When you run wsconfig, it should list your instances by host and instance
name (localhost, cfusion). When you select an instance, it should then show
you what web server it's listening to.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
 
Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore and Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258003
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Developer Edition - Remote IP

2006-10-25 Thread Andy Allan
Restart CF.

On 25/10/06, David Low <[EMAIL PROTECTED]> wrote:
> We've got a genuine need to try and change the remote IP which has been
> set up for a developer edition of CFMX (6.1).  Having trawled the
> settings and registry, I can't find any trace of the IP which was
> accidentally used.
>
> Any ideas if it's possible to change this, once a remote IP has
> connected to the dev machine?  Without needing a reinstall, that is.
>
> David
>
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258002
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: URL for CF7 Multi-Server configurations

2006-10-25 Thread Dave Hatz
Do you run Apache on Win box? 

-Original Message-
From: Russ [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 25, 2006 7:34 AM
To: CF-Talk
Subject: RE: URL for CF7 Multi-Server configurations

I'm not really sure... I don't use CF with IIS.  I prefer apache, where you
can plainly see your configuration at a glance.  Maybe if you run wsconfig
you can see it there?

Russ

> -Original Message-
> From: Dave Hatz [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, October 25, 2006 10:29 AM
> To: CF-Talk
> Subject: RE: URL for CF7 Multi-Server configurations
> 
> Russ,
> Thanks for the clarification on that.  Question for you though, how 
> can I confirm that the site I have assigned with the wsconfig utility 
> is using the correct CF Instance?  For example, I have 2 sites that 
> have 2 different instances assigned.  I want to make sure that I have 
> correctly assigned each of my sites to the appropriate instance.
> 
> Thanks,
> Dave Hatz
> 
> -Original Message-
> From: Russ [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, October 24, 2006 4:50 PM
> To: CF-Talk
> Subject: RE: URL for CF7 Multi-Server configurations
> 
> Each instance has a port on which the internal web server listens on 
> (which you should disable).  It also has a port on which the jrun 
> connector listens on.  This port gets automatically mapped for you 
> using the wsconfig utility.
> IIS should just run on port 80 and use the host headers to 
> differentiate between different instances.
> 
> Russ
> 
> 
> > -Original Message-
> > From: Dave Hatz [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, October 24, 2006 6:47 PM
> > To: CF-Talk
> > Subject: RE: URL for CF7 Multi-Server configurations
> >
> > I set up multiple instances of CF7 Server.  Each Instance is using a 
> > different port to listen on.  So, don't I need to tell IIS to listen 
> > on that port?
> >
> > -Original Message-
> > From: Russ [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, October 24, 2006 3:36 PM
> > To: CF-Talk
> > Subject: RE: URL for CF7 Multi-Server configurations
> >
> > Why are you running iis6 on 8301?  You should be running it on port
> 80...
> > I
> > believe 8301 was the port # for the internal webserver, which you 
> > should have disabled.
> >
> > Russ
> >
> > > -Original Message-
> > > From: Dave Hatz [mailto:[EMAIL PROTECTED]
> > > Sent: Tuesday, October 24, 2006 6:12 PM
> > > To: CF-Talk
> > > Subject: URL for CF7 Multi-Server configurations
> > >
> > > I am trying to figure out how not to display the port number in 
> > > the URL for multi-server CF7 installations.  I have created my 
> > > different servers and I am able to hit them all just fine, as long 
> > > as I include the port number they are listening on.  For example:
> > >
> > > http://www.mywebsite.com:8301/helloworld.cfm
> > >
> > > We are running on IIS6.  I have used the JRun Server Configuration 
> > > tool to map the web site too.  I have the web site properties in
> > > IIS6 listening on port 8301 and my Host Header value is set to
> > www.mywebsite.com.
> > >
> > > How can I get away from inlcuding the port number in my URL?  I 
> > > really don't want my clients to have to see that.
> > >
> > > Thanks,
> > > Dave Hatz
> > >
> > >
> >
> >
> >
> >
> 
> 
> 
> 



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258000
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Developer Edition - Remote IP

2006-10-25 Thread Dave Watts
> We've got a genuine need to try and change the remote IP 
> which has been set up for a developer edition of CFMX (6.1).  
> Having trawled the settings and registry, I can't find any 
> trace of the IP which was accidentally used.
> 
> Any ideas if it's possible to change this, once a remote IP 
> has connected to the dev machine?  Without needing a 
> reinstall, that is.

In the CF directory, you should have the file /lib/license.properties. You
should be able to edit that, and remove the last IP address used.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
 
Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore and Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258001
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Mime Type for File Upload

2006-10-25 Thread Dave Watts
> > if someone wants to upload an .exe file all they have to do 
> > is give it a .pdf extension.  Plan your security for that as 
> > best you can.
> 
> What type of security can prevent that?  What can truly 
> determine what type of file a file is except by extension?

Well, the extension isn't what gives the ability to do one thing or another,
it's the actual contents of the file. The extension is just a convenience
used by Windows to determine the file type without having to actually read
and interpret the contents of the file. Other operating systems don't use
extensions, they use other file metadata (resource forks, etc) to figure
this out.

There are third-party libraries that can determine what type a file is, by
examining the file itself.

However, you should simply assume that all files, under the right
conditions, could be executable. So, you don't want to allow files to be
placed where they could be potentially executed.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
 
Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore and Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257999
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Developer Edition - Remote IP

2006-10-25 Thread David Low
We've got a genuine need to try and change the remote IP which has been
set up for a developer edition of CFMX (6.1).  Having trawled the
settings and registry, I can't find any trace of the IP which was
accidentally used.

Any ideas if it's possible to change this, once a remote IP has
connected to the dev machine?  Without needing a reinstall, that is.

David


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257998
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Mime Type for File Upload

2006-10-25 Thread Dave Watts
> Use PHP as this can definitely determine mime type as well as 
> file extension.

I'm pretty sure that, just like CF, PHP just looks at the MIME type it's
given. So, if you're using CF for everything else, you might as well use it
for this also. You use the ACCEPT attribute of CFFILE to list acceptable
MIME types.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
 
Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore and Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257997
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: URL for CF7 Multi-Server configurations

2006-10-25 Thread Russ
I'm not really sure... I don't use CF with IIS.  I prefer apache, where you
can plainly see your configuration at a glance.  Maybe if you run wsconfig
you can see it there?

Russ

> -Original Message-
> From: Dave Hatz [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, October 25, 2006 10:29 AM
> To: CF-Talk
> Subject: RE: URL for CF7 Multi-Server configurations
> 
> Russ,
> Thanks for the clarification on that.  Question for you though, how can I
> confirm that the site I have assigned with the wsconfig utility is using
> the
> correct CF Instance?  For example, I have 2 sites that have 2 different
> instances assigned.  I want to make sure that I have correctly assigned
> each
> of my sites to the appropriate instance.
> 
> Thanks,
> Dave Hatz
> 
> -Original Message-
> From: Russ [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, October 24, 2006 4:50 PM
> To: CF-Talk
> Subject: RE: URL for CF7 Multi-Server configurations
> 
> Each instance has a port on which the internal web server listens on
> (which
> you should disable).  It also has a port on which the jrun connector
> listens
> on.  This port gets automatically mapped for you using the wsconfig
> utility.
> IIS should just run on port 80 and use the host headers to differentiate
> between different instances.
> 
> Russ
> 
> 
> > -Original Message-
> > From: Dave Hatz [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, October 24, 2006 6:47 PM
> > To: CF-Talk
> > Subject: RE: URL for CF7 Multi-Server configurations
> >
> > I set up multiple instances of CF7 Server.  Each Instance is using a
> > different port to listen on.  So, don't I need to tell IIS to listen
> > on that port?
> >
> > -Original Message-
> > From: Russ [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, October 24, 2006 3:36 PM
> > To: CF-Talk
> > Subject: RE: URL for CF7 Multi-Server configurations
> >
> > Why are you running iis6 on 8301?  You should be running it on port
> 80...
> > I
> > believe 8301 was the port # for the internal webserver, which you
> > should have disabled.
> >
> > Russ
> >
> > > -Original Message-
> > > From: Dave Hatz [mailto:[EMAIL PROTECTED]
> > > Sent: Tuesday, October 24, 2006 6:12 PM
> > > To: CF-Talk
> > > Subject: URL for CF7 Multi-Server configurations
> > >
> > > I am trying to figure out how not to display the port number in the
> > > URL for multi-server CF7 installations.  I have created my different
> > > servers and I am able to hit them all just fine, as long as I
> > > include the port number they are listening on.  For example:
> > >
> > > http://www.mywebsite.com:8301/helloworld.cfm
> > >
> > > We are running on IIS6.  I have used the JRun Server Configuration
> > > tool to map the web site too.  I have the web site properties in
> > > IIS6 listening on port 8301 and my Host Header value is set to
> > www.mywebsite.com.
> > >
> > > How can I get away from inlcuding the port number in my URL?  I
> > > really don't want my clients to have to see that.
> > >
> > > Thanks,
> > > Dave Hatz
> > >
> > >
> >
> >
> >
> >
> 
> 
> 
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257996
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Mime Type for File Upload

2006-10-25 Thread Rick Faircloth
I've never use PHP, so I'll have to do some
work to get that done...I'll check it out...

Thanks for the tip!

Rick

-Original Message-
From: Martyn Bowis [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 25, 2006 8:42 AM
To: CF-Talk
Subject: RE: Mime Type for File Upload

Hi Rick,

Use PHP as this can definitely determine mime type as well as file
extension.

See the following:

http://php.about.com/od/advancedphp/ss/php_file_upload_5.htm

I don't limit myself to CFM, PHP or any other language.  Often PHP is a
great compliment to CFM code ... and of course you can submit form.cfm to
upload.php and then redirect back to form.cfm

Cheers,
Martyn






~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257995
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: URL for CF7 Multi-Server configurations

2006-10-25 Thread Dave Hatz
Russ,
Thanks for the clarification on that.  Question for you though, how can I
confirm that the site I have assigned with the wsconfig utility is using the
correct CF Instance?  For example, I have 2 sites that have 2 different
instances assigned.  I want to make sure that I have correctly assigned each
of my sites to the appropriate instance.

Thanks,
Dave Hatz 

-Original Message-
From: Russ [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, October 24, 2006 4:50 PM
To: CF-Talk
Subject: RE: URL for CF7 Multi-Server configurations

Each instance has a port on which the internal web server listens on (which
you should disable).  It also has a port on which the jrun connector listens
on.  This port gets automatically mapped for you using the wsconfig utility.
IIS should just run on port 80 and use the host headers to differentiate
between different instances. 

Russ


> -Original Message-
> From: Dave Hatz [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, October 24, 2006 6:47 PM
> To: CF-Talk
> Subject: RE: URL for CF7 Multi-Server configurations
> 
> I set up multiple instances of CF7 Server.  Each Instance is using a 
> different port to listen on.  So, don't I need to tell IIS to listen 
> on that port?
> 
> -Original Message-
> From: Russ [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, October 24, 2006 3:36 PM
> To: CF-Talk
> Subject: RE: URL for CF7 Multi-Server configurations
> 
> Why are you running iis6 on 8301?  You should be running it on port 80...
> I
> believe 8301 was the port # for the internal webserver, which you 
> should have disabled.
> 
> Russ
> 
> > -Original Message-
> > From: Dave Hatz [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, October 24, 2006 6:12 PM
> > To: CF-Talk
> > Subject: URL for CF7 Multi-Server configurations
> >
> > I am trying to figure out how not to display the port number in the 
> > URL for multi-server CF7 installations.  I have created my different 
> > servers and I am able to hit them all just fine, as long as I 
> > include the port number they are listening on.  For example:
> >
> > http://www.mywebsite.com:8301/helloworld.cfm
> >
> > We are running on IIS6.  I have used the JRun Server Configuration 
> > tool to map the web site too.  I have the web site properties in 
> > IIS6 listening on port 8301 and my Host Header value is set to
> www.mywebsite.com.
> >
> > How can I get away from inlcuding the port number in my URL?  I 
> > really don't want my clients to have to see that.
> >
> > Thanks,
> > Dave Hatz
> >
> >
> 
> 
> 
> 



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257994
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: nested queries

2006-10-25 Thread Richard White
thanks very much, i learnt about using the refernces the other day but thought 
it was just a different way of writing the queries but i am now starting to see 
that you actually have alot more control by using them and it is alot more 
logical

thanks for your help, i will change all my queries to use the reference now :)

thanks again

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257993
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: FireFox 2 Download help

2006-10-25 Thread Bobby Hartsfield
Let me know if you want it put up somewhere in a  zip

-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 25, 2006 10:10 AM
To: CF-Talk
Subject: RE: FireFox 2 Download help

I think my firewall is stopping the downloading of EXE files or
something. Dang! Security inhibits me again :) 

...
Ben Nadel
Certified Advanced ColdFusion Developer
www.bennadel.com
 

-Original Message-
From: Rob Wilkerson [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 25, 2006 10:07 AM
To: CF-Talk
Subject: Re: FireFox 2 Download help

On 10/25/06, Adrian <[EMAIL PROTECTED]> wrote:
> works fine for me...
>
> On 25/10/06, Ben Nadel <[EMAIL PROTECTED]> wrote:
> >
> > Hey all, I keep trying to download FireFox 2, but the link never
works:
> >
> > http://mozilla2.mirrors.tds.net/pub/mozilla.org/firefox/releases/2.0
> > /win
> > 32/en-US/Firefox%20Setup%202.0.exe
> >
> > Does this work for anyone else? Is there somewhere else I can 
> > download this?

I just downloaded it moments ago.  Try just going here:
http://www.mozilla.com/en-US/





~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257992
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: FireFox 2 Download help

2006-10-25 Thread Chris Montgomery
Ben Nadel said the following on 10/25/2006 8:30 AM:
> Hey all, I keep trying to download FireFox 2, but the link never works:
>  
> http://mozilla2.mirrors.tds.net/pub/mozilla.org/firefox/releases/2.0/win
> 32/en-US/Firefox%20Setup%202.0.exe
>  
> Does this work for anyone else? Is there somewhere else I can download
> this?

It might be better to ask this in the Firefox support forum:
http://forums.mozillazine.org/viewforum.php?f=38

FWIW, the following link, placed at the top of the Mozilla home page, 
seems to work:
http://www.mozilla.com/products/download.html?product=firefox-2.0&os=win&lang=en-US

-- 
Chris Montgomery

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257991
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: FireFox 2 Download help

2006-10-25 Thread Ben Nadel
I think my firewall is stopping the downloading of EXE files or
something. Dang! Security inhibits me again :) 

..
Ben Nadel
Certified Advanced ColdFusion Developer
www.bennadel.com
 

-Original Message-
From: Rob Wilkerson [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 25, 2006 10:07 AM
To: CF-Talk
Subject: Re: FireFox 2 Download help

On 10/25/06, Adrian <[EMAIL PROTECTED]> wrote:
> works fine for me...
>
> On 25/10/06, Ben Nadel <[EMAIL PROTECTED]> wrote:
> >
> > Hey all, I keep trying to download FireFox 2, but the link never
works:
> >
> > http://mozilla2.mirrors.tds.net/pub/mozilla.org/firefox/releases/2.0
> > /win
> > 32/en-US/Firefox%20Setup%202.0.exe
> >
> > Does this work for anyone else? Is there somewhere else I can 
> > download this?

I just downloaded it moments ago.  Try just going here:
http://www.mozilla.com/en-US/



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257990
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: FireFox 2 Download help

2006-10-25 Thread Rob Wilkerson
On 10/25/06, Adrian <[EMAIL PROTECTED]> wrote:
> works fine for me...
>
> On 25/10/06, Ben Nadel <[EMAIL PROTECTED]> wrote:
> >
> > Hey all, I keep trying to download FireFox 2, but the link never works:
> >
> > http://mozilla2.mirrors.tds.net/pub/mozilla.org/firefox/releases/2.0/win
> > 32/en-US/Firefox%20Setup%202.0.exe
> >
> > Does this work for anyone else? Is there somewhere else I can download
> > this?

I just downloaded it moments ago.  Try just going here:
http://www.mozilla.com/en-US/

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257989
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: WebService issue...

2006-10-25 Thread Andrew Scott
some webservices also have to be passed the return values too:-)

For example if there is 1 paramter to be passed and 1 parameter that gets
returned then you need to pass 2 paramters the in/out for the webservice as
well.

Not all the time, but I have had this issue with a few before.



On 10/25/06, J W <[EMAIL PROTECTED]> wrote:
>
> I've been dealing with this issue for a while now trying to use a web
> service. I've done the refresh. Still no go..
>
> Some web services give the same error when the optional parameters are not
> included in the invoke call as well or all the mandatory arguements were
> not
> included. You have to include the omit="yes" as part of your
> cfinvokeargument if they are requiring the optional ones. Still no go for
> me
> too.
>
> Has anyone delt with RSA's webservice?
>
> Jeff
>
>
> On 10/24/06, Charles E. Heizer <[EMAIL PROTECTED]> wrote:
> >
> > Thanks,
> > I did find this on the livedocs and this fixed it...
> >
> > "When you get that error about "can't be found", its becuase coldFusion
> > caches the WSDL for that webservice. You have to go into the CF
> > administriaon > Web Services You'll see your webservice there...
> click
> > the refresh button, then all should work fine."
> >
> >
> > On 10/24/06 2:44 PM, "Nathan Strutz" <[EMAIL PROTECTED]> wrote:
> >
> > > It's a little bit hard to say for sure, but, to try the simple stuff
> > first,
> > > make sure the cffunction you are calling has access="remote" on it.
> >
> >
> >
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257988
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: WebService issue...

2006-10-25 Thread J W
I've been dealing with this issue for a while now trying to use a web
service. I've done the refresh. Still no go..

Some web services give the same error when the optional parameters are not
included in the invoke call as well or all the mandatory arguements were not
included. You have to include the omit="yes" as part of your
cfinvokeargument if they are requiring the optional ones. Still no go for me
too.

Has anyone delt with RSA's webservice?

Jeff


On 10/24/06, Charles E. Heizer <[EMAIL PROTECTED]> wrote:
>
> Thanks,
> I did find this on the livedocs and this fixed it...
>
> "When you get that error about "can't be found", its becuase coldFusion
> caches the WSDL for that webservice. You have to go into the CF
> administriaon > Web Services You'll see your webservice there... click
> the refresh button, then all should work fine."
>
>
> On 10/24/06 2:44 PM, "Nathan Strutz" <[EMAIL PROTECTED]> wrote:
>
> > It's a little bit hard to say for sure, but, to try the simple stuff
> first,
> > make sure the cffunction you are calling has access="remote" on it.
>
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257987
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: nested queries

2006-10-25 Thread Andy Matthews
You should be able to copy the top query, replacing the = value with the
cfqueryparam straight into a cfquery.



-Original Message-
From: Richard White [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 25, 2006 8:33 AM
To: CF-Talk
Subject: nested queries


hi, i am having problems working out how to execute a nested query in a
cfquery.

It works fine in mysql with the following sql statement:

SELECT staffTitle,staffFirstName,staffLastName FROM STAFF WHERE staffEmail =
(SELECT staffEmail FROM STUDENTS WHERE studentEmail = email);

however, i am not sure how to convert this into a cfquery. i have tried the
following but getting an error:

SELECT staffTitle, staffFirstName, staffLastName FROM STAFF WHERE staffEmail
= SELECT staffEmail FROM STUDENTS WHERE studentEmail = 

i would appreciate some help on what i am doing wrong

thanks very much



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257986
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: nested queries

2006-10-25 Thread Charlie Hanlon

 SELECT s.staffTitle, s.staffFirstName, s.staffLastName
 FROM STAFF s, STUDENTS p
 WHERE s.staffEmail = p.staffEmail
 AND  p.studentEmail = 


Above is how I would write the query, but I am still learning.

hth...

Charles Hanlon
Web Applications Developer
Food Service Enablers, Inc.
www.fsenablers.com

The People. The Platform. The Products.
Make the Difference


- Original Message - 
From: "Richard White" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Wednesday, October 25, 2006 9:32 AM
Subject: nested queries


> hi, i am having problems working out how to execute a nested query in a 
> cfquery.
>
> It works fine in mysql with the following sql statement:
>
> SELECT staffTitle,staffFirstName,staffLastName FROM STAFF WHERE staffEmail 
> = (SELECT staffEmail FROM STUDENTS WHERE studentEmail = email);
>
> however, i am not sure how to convert this into a cfquery. i have tried 
> the following but getting an error:
>
> SELECT staffTitle, staffFirstName, staffLastName FROM STAFF WHERE 
> staffEmail = SELECT staffEmail FROM STUDENTS WHERE studentEmail = 
> 
>
> i would appreciate some help on what i am doing wrong
>
> thanks very much
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257985
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: OT: Other countries besides US

2006-10-25 Thread Claude Schneegans
 >>There are too many differences to handle in a
practical manner.

Right.
In my case, I just ask the user to enter his address in a textarea and 
store all lines it in a memo field.
When I print or display the address, I change the line field with 

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257984
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Mime Type for File Upload

2006-10-25 Thread Mosh Teitelbaum
Rick Faircloth wrote:
> Need to specify the CFFILE "Accept" attributes for .doc and .pdf.
>
> What would those be?
>
> I know Accept  = "application/msword" would accept
> Word docs, but would they be limited .doc filetype?
>
> And what about .pdf. application or text or ???
>
> I want to limit uploads to .doc and .pdf only.

Rick:

The two Mime-Types you're after are application/msword and application/pdf.
You would use these like:



ColdFusion does, in fact, use the HTTP headers to determine the Mime-Type of
the uploaded file.  The browser automatically determines the Mime-Type and
includes that as an HTTP header.  How the browser determines it is browser
and OS dependant.  Most browsers and OSs simply use the file's extension to
determine the file type.

Because of the trusting nature of HTTP, if someone wants to fool your
system, they're almost certainly going to be able to.  The user can change
the file extension, manually construct the HTTP header to specify an
incorrect Mime-Type, etc.  The only fool-proof way for you to guarantee that
you're getting what you expect is to have some sort of server-side
application that can check the CONTENTS of the uploaded file to ensure it is
what you think it is (ex. unzip utilities can often run a verification
operation on a file to validate that it is a ZIP file).  Checking the
filename and/or extension is not the least bit fool-proof.

The other extra precaution you can take, especially if you allow people to
upload files directly into a web-accessible path, is to run a virus scan on
the file as soon as it's uploaded.  Most modern AV solutions can scan
multiple file types (exe, com, doc, xls, zip, rar, etc.) for viruses.  Even
JPG files can contain malware.

HTH

--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 942-5378
Fax: (301) 933-3651
Email: [EMAIL PROTECTED]
WWW: http://www.evoch.com/



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257983
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Anyone know of a good tree control

2006-10-25 Thread Claude Schneegans
 >>You may give this a try:

Thanks, but I've already been through all this for my own dynamic menu 
which uses backgound
images and had the problem fixed.

I was just noticing that this list system was showing the problem which 
they didn't
correct on their own server.
And by the way, I do not see why they need background images to do this.


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257982
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


nested queries

2006-10-25 Thread Richard White
hi, i am having problems working out how to execute a nested query in a cfquery.

It works fine in mysql with the following sql statement:

SELECT staffTitle,staffFirstName,staffLastName FROM STAFF WHERE staffEmail = 
(SELECT staffEmail FROM STUDENTS WHERE studentEmail = email);

however, i am not sure how to convert this into a cfquery. i have tried the 
following but getting an error:

SELECT staffTitle, staffFirstName, staffLastName FROM STAFF WHERE staffEmail = 
SELECT staffEmail FROM STUDENTS WHERE studentEmail = 

i would appreciate some help on what i am doing wrong

thanks very much

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257981
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: FireFox 2 Download help

2006-10-25 Thread Adrian
works fine for me...

On 25/10/06, Ben Nadel <[EMAIL PROTECTED]> wrote:
>
> Hey all, I keep trying to download FireFox 2, but the link never works:
>
> http://mozilla2.mirrors.tds.net/pub/mozilla.org/firefox/releases/2.0/win
> 32/en-US/Firefox%20Setup%202.0.exe
>
> Does this work for anyone else? Is there somewhere else I can download
> this?
>
> Thanks
>
>
> ..
> Ben Nadel
> Certified Advanced ColdFusion Developer
> www.bennadel.com
>
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257980
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


FireFox 2 Download help

2006-10-25 Thread Ben Nadel
Hey all, I keep trying to download FireFox 2, but the link never works:
 
http://mozilla2.mirrors.tds.net/pub/mozilla.org/firefox/releases/2.0/win
32/en-US/Firefox%20Setup%202.0.exe
 
Does this work for anyone else? Is there somewhere else I can download
this?
 
Thanks
 

..
Ben Nadel
Certified Advanced ColdFusion Developer
www.bennadel.com


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257979
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: All Stored Procs in 1 CFC?

2006-10-25 Thread Gaulin, Mark
One of the benefits you mention for .net, namely knowing what code is
affected when stored procedures change, won't buy you much in CF since
you won't get a compile-time error... You'll have to wait until someone
calls the CFC method (with the wrong arguments, say) to find out that
you needed to update you code.  Late binding and weak typing sucks for
generating that kind of very-handy diagnostic.

If anyone has a work-around for this I'd love to hear about it.

Mark

-Original Message-
From: Brian Peddle [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, October 24, 2006 7:29 PM
To: CF-Talk
Subject: All Stored Procs in 1 CFC?

I have worked a few companies where they use .NET and know of several
other companies who follow this process.  They have a generator that
reads all the stored procs and creates the needed code in .NET to make
the calls to the stored procedures in classes.  All this is done
automatically and the file is never edited by human hands.  One of the
cool things is that if a stored proc is altered and the file is
recreated on build any page calling that class will fail and they can
quickly and easily see what needs to be fixed.  The other cool thing is
all the SQL is in one place.

Anyway, has anyone ever done this in CF?  Not so much the auto generate
stuff (although be good to know) but have one monster .cfc with all the
calls.  Since it isn't compiled like .NET performance may be a huge
issue but not sure. Or maybe if this is tossed in application scope it
would fly.

Thoughts?

Hope this made sense.







~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257978
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


  1   2   >