RE: One thing I've always wanted to build... breadcrumb trail...

2008-06-10 Thread William Seiter
I would use an array stored in the session.  Use arrayprepend to add a new
location, loop through the array to 'x' deep (5 locations?) and then you
could add a 'cleanup' after say 6 or 7 stored locations (arraylen gt 7,
arraydeleteat())

Just my 2pc on your ideas
William

--
William Seiter
ColdFusion Web Developer / Consultant
http://william.seiter.com
 
Free Website Trade Publication  Website Magazine
http://www.websitemagazine.com/referrals/?id=51344f=text2
Don't forget to answer the survey questions, it's a 10 second task ,
a very small request  for access to this  incredible resource.
 
Have you ever read a book that changed your life?
Go to: http://www.winninginthemargins.com
Use PassKey: GoldenGrove
You'll be glad you did.
 
 

::-Original Message-
::From: Rick Faircloth [mailto:[EMAIL PROTECTED]
::Sent: Monday, June 09, 2008 8:54 PM
::To: CF-Talk
::Subject: One thing I've always wanted to build... breadcrumb trail...
::
::
::Not the one that represents a folder structure or
::hierarchy, but shows the exact places visited.
::
::Home  Services  Contact  Pricing  FAQ
::
::Anyone know of a tutorial on how to do this?
::
::Just store the link name representing a full url
::for the last, say, 5 or so visited pages?
::
::Update the path variables with each new page visit?
::
::In application.cfm (yes, still .cfm), upon visit to homepage...
::
::cfset session.page_one = 'http://www.site.com/index.'
::cfset session.page_two = ''
::cfset session.page_three = ''
::cfset session.page_four = ''
::cfset session.page_five = ''
::
::cfoutout
::a href='#session.page_one#'Home/a
::/cfoutput
::
::Visit to 'Services' page:
::
::cfset session.page_two = 'http://www.site.com/cfm/services.cfm'
::
::cfoutput
::a href='#session.page_one#'Home/a
::
::a href='#session.page_two#'Services/a
::/cfoutput
::
::etc...
::
::Now there would have to be a way developed to figure out the next
::empty session variable to hold the visited page and then to rotate
::pages down one rank in the history and off the history after 5 pages
::were visited.
::
::But would this concept work?
::
::Thanks for any feedback or references to tutorials!
::
::Rick
::
::
::

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


Re: ODBC vs JDBC MS-SQL Driver Question

2008-06-10 Thread Paul Hastings
JB Cameron wrote:
 We are looking to optimize performance for a few client sites and many
 optimization whitepapers have recommended using a Type IV JDBC driver for
 MS-SQL server. What driver type of driver comes pre-built with with CFMX 7.0?

cf already has a type 4 from data direct for sql server, labeled as Microsoft 
SQL Server in the drivers pull-down in cfadmin/dsn. don't use the ODBC driver 
(actually a bridge as cf is java  talks to the db via jdbc) as it's slower  
not unicode compliant.

if you want speed, might give jTDS a spin. it's *fast*.



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


Re: Alarming script Injection in SQL Server 2005 tables

2008-06-10 Thread Tom Chiverton
On Monday 09 Jun 2008, Brian Kotek wrote:
 cfqueryparam won't actually stop someone from entering XSS code into a text
 field. It needs to be stripped out prior to insertion into the DB.

Ahh, yes, client side problems would still be possible, you're right :-)

-- 
'/div' Chiverton



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at 
Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB.  A list 
of members is available for inspection at the registered office. Any reference 
to a partner in relation to Halliwells LLP means a member of Halliwells LLP.  
Regulated by The Solicitors Regulation Authority.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be 
confidential or legally privileged.  If you are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 2500.

For more information about Halliwells LLP visit www.halliwells.com.

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


RE: [CF-Dev] WDDX-JSON plugin for jQuery ?

2008-06-10 Thread j.c.buckingham
A bit more background info. might be good but have you looking at AJAXCFC?

The Robert Gordon University, a Scottish charity registered under charity 
number SCO 13781.

This e-mail and any attachment is for authorised use by the intended 
recipient(s) only. It may contain proprietary material, confidential 
information and/or be subject to legal privilege. It should not be copied, 
disclosed to, retained or used by, any other party. If you are not an intended 
recipient then please promptly delete this e-mail and any attachment and all 
copies and inform the sender. Thank you.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter Boughton
Sent: 10 June 2008 11:40
To: Coldfusion Development; cf-talk@houseoffusion.com
Subject: [CF-Dev] WDDX-JSON plugin for jQuery ?

- see footer for list info -
Hi all,

Does anyone have a plugin for jQuery that handles the conversion
between WDDX and JSON?

Or any JS-based WDDX/JSON convertor that I can take and create a
jQuery plugin out of?

(note: not using cf8)

Thanks,

Peter


 \ \
Peter Boughton
blog.bpsite.net
 / /

___

For details on ALL mailing lists and for joining or leaving lists, go to 
http://list.cfdeveloper.co.uk/mailman/listinfo

--
CFDeveloper Sponsors:-
- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -
- Lists hosted by www.Gradwell.com -
- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


Re: Large Number of CF DSNs and SQL Performance Question

2008-06-10 Thread Tom Chiverton
On Tuesday 10 Jun 2008, JB Cameron wrote:
 Technically we run 3 web servers load balanced for this client, so we are
 really talking about 3 x 150 clients, or 450 connections to the SQL server,
 growing to probably 900 in a year. Thoughts?

Try it in your staging environment and see what happens.

-- 
Tom Chiverton



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at 
Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB.  A list 
of members is available for inspection at the registered office. Any reference 
to a partner in relation to Halliwells LLP means a member of Halliwells LLP.  
Regulated by The Solicitors Regulation Authority.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be 
confidential or legally privileged.  If you are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 2500.

For more information about Halliwells LLP visit www.halliwells.com.

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


Re: Large Number of CF DSNs and SQL Performance Question

2008-06-10 Thread Joel Stobart
 Hey Everyone, 
 
 This is more of a performance question. We have a client in the 
 securities industry for which we have built a client management system 
 in CFML, that enables our securities client to create fully managed 
 database solutions for each of their downstream clients. Due to 
 regulations in the securities industry, our client is required to 
 maintain seperate databases for each of their downstream clients. To 
 date our CF server had about 150 data sources the main applications 
 references, depending on which downstream client is logging in. 
 
 Has anyone bumped into an upper limit of DSNs permitted in Cold 
 Fusion? Our client is getting ready to expand and add another 200 
 clients, and we are a little concerned if CF is going to work well for 
 this since there are no dynamic DSNs. Also, has anyone run into 
 anything in the Microsoft SQL Server side about having that many 
 different connections to the DB server? Technically we run 3 web 
 servers load balanced for this client, so we are really talking about 
 3 x 150 clients, or 450 connections to the SQL server, growing to 
 probably 900 in a year. Thoughts?
 
 Cheers!
 
 JB 


I seem to remeber someone doing dynamic datasources using jdbc connections and 
a little bit of Java. http://www.petefreitag.com/item/152.cfm has some ideas. I 
havent tried it but setting up 900 datasources has to be too much of a

kind regards,
Joel 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


Re: Large Number of CF DSNs and SQL Performance Question

2008-06-10 Thread Joel Stobart
 Hey Everyone, 
 
 This is more of a performance question. We have a client in the 
 securities industry for which we have built a client management system 
 in CFML, that enables our securities client to create fully managed 
 database solutions for each of their downstream clients. Due to 
 regulations in the securities industry, our client is required to 
 maintain seperate databases for each of their downstream clients. To 
 date our CF server had about 150 data sources the main applications 
 references, depending on which downstream client is logging in. 
 
 Has anyone bumped into an upper limit of DSNs permitted in Cold 
 Fusion? Our client is getting ready to expand and add another 200 
 clients, and we are a little concerned if CF is going to work well for 
 this since there are no dynamic DSNs. Also, has anyone run into 
 anything in the Microsoft SQL Server side about having that many 
 different connections to the DB server? Technically we run 3 web 
 servers load balanced for this client, so we are really talking about 
 3 x 150 clients, or 450 connections to the SQL server, growing to 
 probably 900 in a year. Thoughts?
 
 Cheers!
 
 JB 


I seem to remeber someone doing dynamic datasources using jdbc connections and 
a little bit of Java. http://www.petefreitag.com/item/152.cfm has some ideas. I 
havent tried it but setting up 900 datasources has to be too much of a

kind regards,
Joel 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


Re: Large Number of CF DSNs and SQL Performance Question

2008-06-10 Thread Joel Stobart
I seem to remeber someone doing dynamic datasources using jdbc connections and 
a little bit of Java. http://www.petefreitag.com/item/152.cfm has some ideas. I 
havent tried it but setting up 900 datasources has to be too much of a

kind regards,
Joel 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


Re: Large Number of CF DSNs and SQL Performance Question

2008-06-10 Thread Joel Stobart
I seem to remeber someone doing dynamic datasources using jdbc connections and 
a little bit of Java. http://www.petefreitag.com/item/152.cfm has some ideas. I 
havent tried it but setting up 900 datasources has to be too much of a

kind regards,
Joel 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


Word document generation (header, footer, page numbering)

2008-06-10 Thread Loathe
There are several well known ways of generating word documents, xml, 
html with cfcontent/header, and I hear POI although I haven't used it.

I have a need to be able to create a word document and do page 
numbering, and have access to the header and footer to add letterhead 
and document classification information.  I'm wondering if anyone can 
point me towards a solution that does this other than CF Report Builder?

I've tried using open office wordProcesingML, but it doesn't auto 
generate page numbers.

T

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


How to change the properties of a column on an Oracle Server?

2008-06-10 Thread nic olai
Hi all,

how can i change the properties of a column on an Oracle Server?

With MySQL i can change it with:
ALTER TABLE `mytable.mycolumn` CHANGE `mytable.mycolumn` `mytable.mycolumn` 
TEXT CHARACTER SET utf-8 COLLATE utf-8 NOT NULL 

But whats the corry syntax for usage on Oracle Server?

Thank you  best regards
Nils 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


Re: How to change the properties of a column on an Oracle Server?

2008-06-10 Thread Tom Chiverton
On Tuesday 10 Jun 2008, nic olai wrote:
 But whats the corry syntax for usage on Oracle Server?

Fairly similar. What does the Oracle documentation (hell, a swift google) 
say ?

-- 
Tom Chiverton



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at 
Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB.  A list 
of members is available for inspection at the registered office. Any reference 
to a partner in relation to Halliwells LLP means a member of Halliwells LLP.  
Regulated by The Solicitors Regulation Authority.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be 
confidential or legally privileged.  If you are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 2500.

For more information about Halliwells LLP visit www.halliwells.com.

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


Re: Word document generation (header, footer, page numbering)

2008-06-10 Thread Paul Hastings
Loathe wrote:
 I have a need to be able to create a word document and do page 
 numbering, and have access to the header and footer to add letterhead 
 and document classification information.  I'm wondering if anyone can 
 point me towards a solution that does this other than CF Report Builder?

have a look at iText's rtfWriter2 class. iText powers cfdocument, etc on cf7  
above so it should just be there. if you need the latest  greatest version, 
use mark's javaLoader to load the iText jar for use w/cf.


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


Coldfusion 8 and Flex 2

2008-06-10 Thread Keith McGee
I am trying to configure messaging-config.xml file to talk to a flex 
application. The flex application keeps telling me “'Unknown destination”. 
Doe’s anyone have any Ideas?

Error Message

[MessagingError message='Unknown destination 'ColdFusionGateway'.']
at mx.messaging.config::ServerConfig$/getChannelSet()
at mx.messaging::Consumer/mx.messaging:Consumer::initChannelSet()
at mx.messaging::MessageAgent/mx.messaging:MessageAgent::internalSend()
at mx.messaging::Consumer/subscribe()
at flexemail2cf/initApp()
at flexemail2cf/___Application1_creationComplete()
at 
flash.events::EventDispatcher/flash.events:EventDispatcher::dispatchEventFunction()
at flash.events::EventDispatcher/dispatchEvent()
at mx.core::UIComponent/dispatchEvent()
at mx.core::UIComponent/set initialized()
at mx.managers::LayoutManager/::doPhasedInstantiation()
at Function/http://adobe.com/AS3/2006/builtin::apply()
at mx.core::UIComponent/::callLaterDispatcher2()
at mx.core::UIComponent/::callLaterDispatcher()


Config File

?xml version=1.0 encoding=UTF-8?
service id=message-service 
class=flex.messaging.services.MessageService 
messageTypes=flex.messaging.messages.AsyncMessage
adapters
adapter-definition id=cfgateway 
class=coldfusion.flex.CFEventGatewayAdapter default=true /
adapter-definition id=actionscript 
class=flex.messaging.services.messaging.adapters.ActionScriptAdapter/
adapter-definition id=jms 
class=flex.messaging.services.messaging.adapters.JMSAdapter/
/adapters
destination id=ColdFusionGateway
adapter ref=cfgateway /
properties
gatewayid*/gatewayid

 channels
channel ref=cf-polling-amf/
/channels
/destination
/service


Gateway Instances
 
Gateway ID - Flex2CF2

Gateway Type - DataServicesMessaging - Handles Data Services messaging

CFC Path - C:\(path)\handleemail.cfc

Configuration File C:\(path)\messaging-config.xml

 





~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


Re: Word document generation (header, footer, page numbering)

2008-06-10 Thread Loathe
Thanks a lot, I'll jump into it now.

Paul Hastings wrote:
 Loathe wrote:
 I have a need to be able to create a word document and do page 
 numbering, and have access to the header and footer to add letterhead 
 and document classification information.  I'm wondering if anyone can 
 point me towards a solution that does this other than CF Report Builder?
 
 have a look at iText's rtfWriter2 class. iText powers cfdocument, etc on cf7 
  
 above so it should just be there. if you need the latest  greatest 
 version, 
 use mark's javaLoader to load the iText jar for use w/cf.
 
 
 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


Re: alternatives to cfcontent to allow large downloads

2008-06-10 Thread George Abraham

 Instead of using CFCONTENT, you can use CF to create a temporary URL, then
 let your web server serve the file directly. For example, you could use
 CFEXECUTE to create a symlink to a directory containing the file, then
 after
 an hour (or whatever time you deem appropriate) you could delete the
 symlink.


Thanks Dave. After a bit of Googling, it appears you have answered a similar
question at a previous time. You mentioned using the Junction sysinternals
tool to do this. I could not find that thread on houseoffusion.com, but here
it is in another mail archive site:
http://www.mail-archive.com/cf-talk@houseoffusion.com/msg253608.html.

Looks like this might work the best for the current setup.

For the future though, I guess I also want to use this opportunity to ask if
people have had good experiences in general with using the Amazon S3
service. Barney seems to like it a lot, but are there any major gotchas?

Thanks,
George


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


Re: alternatives to cfcontent to allow large downloads

2008-06-10 Thread Gerald Guido
I have been looking at there stuff for a while for a my next dot bomb.

 Barney seems to like it a lot, but are there any major gotchas?

Their set up is very cool. There are no major gotchas that I have seen to
date. There are a couple of wrappers on RIAforge for using there service.
Here is another wrapper
http://www.ajaxcf.com/blog/index.cfm/2006/9/7/Amazon-S3-REST-Wrapper

I believe Barney rolled one himself as well (or was that EC2?). Barney has
blogged some on his experiences with AWS.
http://www.barneyb.com/

Adam Howitt has used it with great success... search his blog for S3
http://www.webdevref.com/blog/

Adam also did a presentation on his expereinces that can be found on this
page:
http://coldfusion.meetup.com/17/files/

This should keep you busy for a bit ;)

G$


On Tue, Jun 10, 2008 at 9:22 AM, George Abraham 
[EMAIL PROTECTED] wrote:

 
  Instead of using CFCONTENT, you can use CF to create a temporary URL,
 then
  let your web server serve the file directly. For example, you could use
  CFEXECUTE to create a symlink to a directory containing the file, then
  after
  an hour (or whatever time you deem appropriate) you could delete the
  symlink.
 
 
 Thanks Dave. After a bit of Googling, it appears you have answered a
 similar
 question at a previous time. You mentioned using the Junction sysinternals
 tool to do this. I could not find that thread on houseoffusion.com, but
 here
 it is in another mail archive site:
 http://www.mail-archive.com/cf-talk@houseoffusion.com/msg253608.html.

 Looks like this might work the best for the current setup.

 For the future though, I guess I also want to use this opportunity to ask
 if
 people have had good experiences in general with using the Amazon S3
 service. Barney seems to like it a lot, but are there any major gotchas?

 Thanks,
 George


 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


RE: One thing I've always wanted to build... breadcrumb trail...

2008-06-10 Thread Rick Faircloth
Thanks for the ideas and feedback, everyone...I'll
check it all out!

Rick

 -Original Message-
 From: William Seiter [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, June 10, 2008 2:48 AM
 To: CF-Talk
 Subject: RE: One thing I've always wanted to build... breadcrumb trail...
 
 I would use an array stored in the session.  Use arrayprepend to add a new
 location, loop through the array to 'x' deep (5 locations?) and then you
 could add a 'cleanup' after say 6 or 7 stored locations (arraylen gt 7,
 arraydeleteat())
 
 Just my 2pc on your ideas
 William
 
 --
 William Seiter
 ColdFusion Web Developer / Consultant
 http://william.seiter.com
 
 Free Website Trade Publication  Website Magazine
 http://www.websitemagazine.com/referrals/?id=51344f=text2
 Don't forget to answer the survey questions, it's a 10 second task ,
 a very small request  for access to this  incredible resource.
 
 Have you ever read a book that changed your life?
 Go to: http://www.winninginthemargins.com
 Use PassKey: GoldenGrove
 You'll be glad you did.
 
 
 
 ::-Original Message-
 ::From: Rick Faircloth [mailto:[EMAIL PROTECTED]
 ::Sent: Monday, June 09, 2008 8:54 PM
 ::To: CF-Talk
 ::Subject: One thing I've always wanted to build... breadcrumb trail...
 ::
 ::
 ::Not the one that represents a folder structure or
 ::hierarchy, but shows the exact places visited.
 ::
 ::Home  Services  Contact  Pricing  FAQ
 ::
 ::Anyone know of a tutorial on how to do this?
 ::
 ::Just store the link name representing a full url
 ::for the last, say, 5 or so visited pages?
 ::
 ::Update the path variables with each new page visit?
 ::
 ::In application.cfm (yes, still .cfm), upon visit to homepage...
 ::
 ::cfset session.page_one = 'http://www.site.com/index.'
 ::cfset session.page_two = ''
 ::cfset session.page_three = ''
 ::cfset session.page_four = ''
 ::cfset session.page_five = ''
 ::
 ::cfoutout
 ::a href='#session.page_one#'Home/a
 ::/cfoutput
 ::
 ::Visit to 'Services' page:
 ::
 ::cfset session.page_two = 'http://www.site.com/cfm/services.cfm'
 ::
 ::cfoutput
 ::a href='#session.page_one#'Home/a
 ::
 ::a href='#session.page_two#'Services/a
 ::/cfoutput
 ::
 ::etc...
 ::
 ::Now there would have to be a way developed to figure out the next
 ::empty session variable to hold the visited page and then to rotate
 ::pages down one rank in the history and off the history after 5 pages
 ::were visited.
 ::
 ::But would this concept work?
 ::
 ::Thanks for any feedback or references to tutorials!
 ::
 ::Rick
 ::
 ::
 ::
 
 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


Re: alternatives to cfcontent to allow large downloads

2008-06-10 Thread Gerald Guido
Actually the presentation is on this page:
http://coldfusion.meetup.com/17/calendar/6620698/?from=listoffset=30

Good stuff

G

On Tue, Jun 10, 2008 at 9:37 AM, Gerald Guido [EMAIL PROTECTED]
wrote:

 I have been looking at there stuff for a while for a my next dot bomb.

  Barney seems to like it a lot, but are there any major gotchas?

 Their set up is very cool. There are no major gotchas that I have seen to
 date. There are a couple of wrappers on RIAforge for using there service.
 Here is another wrapper
 http://www.ajaxcf.com/blog/index.cfm/2006/9/7/Amazon-S3-REST-Wrapper

 I believe Barney rolled one himself as well (or was that EC2?). Barney has
 blogged some on his experiences with AWS.
 http://www.barneyb.com/

 Adam Howitt has used it with great success... search his blog for S3
 http://www.webdevref.com/blog/

 Adam also did a presentation on his expereinces that can be found on this
 page:
 http://coldfusion.meetup.com/17/files/

 This should keep you busy for a bit ;)

 G$



-- 
If everything seems under control, you're not going fast enough
-- Mario Andretti


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


Re: One thing I've always wanted to build... breadcrumb trail...

2008-06-10 Thread Matt Williams
I have a breadcrumb solution that I created for a Mach-II app. You
could probably pull out relevant parts of the code and use it in
Application.cfm.

At one point I attempted to make it window aware so that if a link
spawned a new window or tab, it would keep track of that. I don't
think this part works 100%. However, it looks a bit like this:

session.struct_crumbTrails - structure for window numbers (e.g.,
session.struct_crumbTrails.1, session.struct_crumbTrails.2)
session.struct_crumbTrails.1 - an array of events (Mach-II speak for
pages or requests)
session.struct_crumbTrails.1[1] - a structure to hold the event name
(such as home), args (query string variables stored as a struct), and
the page name (what the crumb trail will display).

It is probably a bit overly complicated due to the window number part,
so unless that is really something you want, it should probably be
stripped out. I also have some hooks in there so that if you want a
the crumb trail to be reset you can do that. It also does some
checking to make sure the same request doesn't show up twice, like on
a refresh or from a bookmark or something.

I probably need to double check with my employer before sharing the
code, but I don't think it will be a problem (they are on Pacific
time, so not in yet). The code is Mach-II specific and refers to an
event object and such, but I think the code could be modified pretty
easily. I'll post back here and possibly on my blog if/when I can
share the code.


On Tue, Jun 10, 2008 at 8:17 AM, Rick Faircloth
[EMAIL PROTECTED] wrote:
 Thanks for the ideas and feedback, everyone...I'll
 check it all out!

 Rick
-- 
Matt Williams
It's the question that drives us.

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


Multi-dimentions Arrays

2008-06-10 Thread Kamru Miah
Hi, I am new to developing code with multi-dimensional arrays (or structures). 
Could someone please advise me how to implement the following 4-level loops to 
store the financial values (for outputting at a later stage)?

---
Loop by projNo
  Loop by finYear
Loop by account type (4 types)
  Loop by month/period
[show monthly amount]
  End month/period
End loop account type
  End loop finYear
End projNo
---

Thanks in anticipation, Kamru 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


Re: cfthread with a cffile upload

2008-06-10 Thread George Abraham
Chad,
As an aside, we went down many routes for large file uploads. HTTP is simply
not built for that. We finally went with an embedded FTP Java client that
simplified our lives a great deal. For reference, we went with this one:
http://www.utechsoft.com/products/uupload/webdemo/cart/

HTH,
George

On Fri, Jun 6, 2008 at 2:51 PM, Chad Baloga [EMAIL PROTECTED] wrote:

 Any way to upload it without loading it into memory?  I know the flash form
 file upload will do it, but I'm working with some code that is unable to do
 that.  Trying to find a way to upload big files faster.

 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


RE: Coldfusion 8 and Flex 2

2008-06-10 Thread Dave Watts
 I am trying to configure messaging-config.xml file to talk to 
 a flex application. The flex application keeps telling me 
 “'Unknown destination”. Doe’s anyone have any Ideas?

First, make sure that your server configuration is correct. You can easily
do this by starting CF as an application, then watching the startup in the
console. If you get a stack trace after MessageBrokerService init, your
configuration is wrong. That said, I don't see anything wrong with your
messaging-config.xml.

Second, make sure your Flex project knows where your server config files
are. It needs to identify destinations, channels, etc at compile time. You
can check this under Project ... Properties.

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, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


Re: Coldfusion 8 and Flex 2

2008-06-10 Thread Keith McGee
ColdFusion started fine.

In the file properties under Flex Server it says Sience this project dose not 
use a server, these settings do not apply.

Any Ideas 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


RtfWriter2 was (Re: Word document generation (header, footer, page numbering))

2008-06-10 Thread Loathe
Whats the correct path to the RtfWriter2 class?

I thought it would be  com.lowagie.text.RtfWriter2 but it can't find 
that, I have googled all over the place for it. I've created the 
document object now I need to pass that to RtfWriter2.getInstance() but 
can't seem to instantiate a RtfWriter2 object.

Any hep would be appreciated, I'm so damned close :)

Also, how do you find these out?  I assumed there would be some way 
through introspection but can't seem to figure out how to get the info, 
I'm dumping the objects I have but I just get the methods and 
properties, no info on children or super or anything.

Paul Hastings wrote:
 Loathe wrote:
 I have a need to be able to create a word document and do page 
 numbering, and have access to the header and footer to add letterhead 
 and document classification information.  I'm wondering if anyone can 
 point me towards a solution that does this other than CF Report Builder?
 
 have a look at iText's rtfWriter2 class. iText powers cfdocument, etc on cf7 
  
 above so it should just be there. if you need the latest  greatest 
 version, 
 use mark's javaLoader to load the iText jar for use w/cf.
 
 
 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


Re: RtfWriter2 was (Re: Word document generation (header, footer, page numbering))

2008-06-10 Thread Loathe
Disregard.

It's com.lowagie.text.rtf.RtfWriter2

Loathe wrote:
 Whats the correct path to the RtfWriter2 class?
 
 I thought it would be  com.lowagie.text.RtfWriter2 but it can't find 
 that, I have googled all over the place for it. I've created the 
 document object now I need to pass that to RtfWriter2.getInstance() but 
 can't seem to instantiate a RtfWriter2 object.
 
 Any hep would be appreciated, I'm so damned close :)
 
 Also, how do you find these out?  I assumed there would be some way 
 through introspection but can't seem to figure out how to get the info, 
 I'm dumping the objects I have but I just get the methods and 
 properties, no info on children or super or anything.
 
 Paul Hastings wrote:
 Loathe wrote:
 I have a need to be able to create a word document and do page 
 numbering, and have access to the header and footer to add letterhead 
 and document classification information.  I'm wondering if anyone can 
 point me towards a solution that does this other than CF Report Builder?
 have a look at iText's rtfWriter2 class. iText powers cfdocument, etc on cf7 
  
 above so it should just be there. if you need the latest  greatest 
 version, 
 use mark's javaLoader to load the iText jar for use w/cf.



 
 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


RE: Coldfusion 8 and Flex 2

2008-06-10 Thread Dave Watts
 In the file properties under Flex Server it says Sience this 
 project dose not use a server, these settings do not apply.

To use LCDS functionality, your project has to define a server.

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, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


Re: Coldfusion 8 and Flex 2

2008-06-10 Thread Tom Chiverton
On Tuesday 10 Jun 2008, Dave Watts wrote:
  In the file properties under Flex Server it says Sience this
  project dose not use a server, these settings do not apply.
 To use LCDS functionality, your project has to define a server.

Though you can probably just use the --services compiler argument to point at 
a services-config.xml file instead, right ?
That's what we do for Flash Remoting.

-- 
Tom Chiverton



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at 
Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB.  A list 
of members is available for inspection at the registered office. Any reference 
to a partner in relation to Halliwells LLP means a member of Halliwells LLP.  
Regulated by The Solicitors Regulation Authority.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be 
confidential or legally privileged.  If you are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 2500.

For more information about Halliwells LLP visit www.halliwells.com.

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


Re: One thing I've always wanted to build... breadcrumb trail...

2008-06-10 Thread Jerry Johnson
No, a worse idea, but it is already done for you (laziest approach)



On Tue, Jun 10, 2008 at 12:05 AM, Rick Faircloth [EMAIL PROTECTED]
wrote:

 Ooohhh... I knew someone was going to say the word 'javascript'.

 Is it really so much better to use js (with which I'm not so good)
 than a CF solution?



  -Original Message-
  From: Jerry Johnson [mailto:[EMAIL PROTECTED]
  Sent: Tuesday, June 10, 2008 12:02 AM
  To: CF-Talk
  Subject: Re: One thing I've always wanted to build... breadcrumb trail...
 
  maybe use the javascript history array?
 
  On Mon, Jun 9, 2008 at 11:53 PM, Rick Faircloth 
 [EMAIL PROTECTED]
  wrote:
 
   Not the one that represents a folder structure or
   hierarchy, but shows the exact places visited.
  
   Home  Services  Contact  Pricing  FAQ
  
   Anyone know of a tutorial on how to do this?
  
   Just store the link name representing a full url
   for the last, say, 5 or so visited pages?
  
   Update the path variables with each new page visit?
  
   In application.cfm (yes, still .cfm), upon visit to homepage...
  
   cfset session.page_one = 'http://www.site.com/index.'
   cfset session.page_two = ''
   cfset session.page_three = ''
   cfset session.page_four = ''
   cfset session.page_five = ''
  
   cfoutout
   a href='#session.page_one#'Home/a
   /cfoutput
  
   Visit to 'Services' page:
  
   cfset session.page_two = 'http://www.site.com/cfm/services.cfm'
  
   cfoutput
   a href='#session.page_one#'Home/a
   
   a href='#session.page_two#'Services/a
   /cfoutput
  
   etc...
  
   Now there would have to be a way developed to figure out the next
   empty session variable to hold the visited page and then to rotate
   pages down one rank in the history and off the history after 5 pages
   were visited.
  
   But would this concept work?
  
   Thanks for any feedback or references to tutorials!
  
   Rick
  
  
  
 
 

 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


Re: RtfWriter2 was (Re: Word document generation (header, footer, page numbering))

2008-06-10 Thread Loathe
Moving on:

I have:

cfset docPath = expandPath(./testDoc.rtf)
cfset myFile = 
CreateObject(java,java.io.FileOutputStream).Init(CreateObject(java,java.io.File).Init(docPath))
cfscript
paths = arrayNew(1);

/*
This points to the jar we want to load.
Could also load a directory of .class files
*/
paths[1] = expandPath(iText-2.1.2u.jar);
paths[2] = expandPath(iText-rtf-2.1.2u.jar);


//create the loader
loader = createObject(component, javaloader.JavaLoader).init(paths);

myDoc = loader.create(com.lowagie.text.Document).init();
myRTF = loader.create(com.lowagie.text.rtf.RtfWriter2);
// myRTF = myRTF.init(myDoc,myFile)
// thisRTF = myRTF.getInstance(myRTF, myFile);
/cfscript

cfdump var=myRTF

No I need to instantiate an object of type RtfWriter2 the constructor 
takes type Document and OutputStream.  I would have though my init() 
would work but CF says it can't find a constructor that takes these 
types, what am I doing wrong here?

Does anyone have a basic hello world example I could take a look at that 
uses these classes?  Once I can get to having the RtfWriter2 I'm pretty 
sure I can figure it our the rest of the methods seem pretty easy to use 
and the lowagie site has some good examples.

Loathe wrote:
 Disregard.
 
 It's com.lowagie.text.rtf.RtfWriter2
 
 Loathe wrote:
 Whats the correct path to the RtfWriter2 class?

 I thought it would be  com.lowagie.text.RtfWriter2 but it can't find 
 that, I have googled all over the place for it. I've created the 
 document object now I need to pass that to RtfWriter2.getInstance() but 
 can't seem to instantiate a RtfWriter2 object.

 Any hep would be appreciated, I'm so damned close :)

 Also, how do you find these out?  I assumed there would be some way 
 through introspection but can't seem to figure out how to get the info, 
 I'm dumping the objects I have but I just get the methods and 
 properties, no info on children or super or anything.

 Paul Hastings wrote:
 Loathe wrote:
 I have a need to be able to create a word document and do page 
 numbering, and have access to the header and footer to add letterhead 
 and document classification information.  I'm wondering if anyone can 
 point me towards a solution that does this other than CF Report Builder?
 have a look at iText's rtfWriter2 class. iText powers cfdocument, etc on 
 cf7  
 above so it should just be there. if you need the latest  greatest 
 version, 
 use mark's javaLoader to load the iText jar for use w/cf.




 
 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


Re: RtfWriter2 was (Re: Word document generation (header, footer, page numbering))

2008-06-10 Thread Loathe
Once again disregard, I figured it out.

A hello world with RtfWriter2:

cfset docPath = expandPath(testDoc.rtf)
cfset myFile = 
CreateObject(java,java.io.FileOutputStream).Init(CreateObject(java,java.io.File).Init(docPath))
 
/
cfscript
paths = arrayNew(1);

/*
This points to the jar we want to load.
Could also load a directory of .class files
*/
paths[1] = expandPath(iText-2.1.2u.jar);
paths[2] = expandPath(iText-rtf-2.1.2u.jar);


//create the loader
loader = createObject(component, javaloader.JavaLoader).init(paths);

myDoc = loader.create(com.lowagie.text.Document).init();
myRTF = loader.create(com.lowagie.text.rtf.RtfWriter2);
thisRTF = myRTF.getInstance(myDoc, myFile);
myDoc.open();
myPara = loader.create(com.lowagie.text.Paragraph);
para = myPara.init(Hello World);
myDoc.add(para);
myDoc.close();

/cfscript

Loathe wrote:
 Moving on:
 
 I have:
 
 cfset docPath = expandPath(./testDoc.rtf)
 cfset myFile = 
 CreateObject(java,java.io.FileOutputStream).Init(CreateObject(java,java.io.File).Init(docPath))
 cfscript
   paths = arrayNew(1);
 
   /*
   This points to the jar we want to load.
   Could also load a directory of .class files
   */
   paths[1] = expandPath(iText-2.1.2u.jar);
   paths[2] = expandPath(iText-rtf-2.1.2u.jar);
 
 
   //create the loader
   loader = createObject(component, javaloader.JavaLoader).init(paths);
   
   myDoc = loader.create(com.lowagie.text.Document).init();
   myRTF = loader.create(com.lowagie.text.rtf.RtfWriter2);
   // myRTF = myRTF.init(myDoc,myFile)
   // thisRTF = myRTF.getInstance(myRTF, myFile);
 /cfscript
   
 cfdump var=myRTF
 
 No I need to instantiate an object of type RtfWriter2 the constructor 
 takes type Document and OutputStream.  I would have though my init() 
 would work but CF says it can't find a constructor that takes these 
 types, what am I doing wrong here?
 
 Does anyone have a basic hello world example I could take a look at that 
 uses these classes?  Once I can get to having the RtfWriter2 I'm pretty 
 sure I can figure it our the rest of the methods seem pretty easy to use 
 and the lowagie site has some good examples.
 
 Loathe wrote:
 Disregard.

 It's com.lowagie.text.rtf.RtfWriter2

 Loathe wrote:
 Whats the correct path to the RtfWriter2 class?

 I thought it would be  com.lowagie.text.RtfWriter2 but it can't find 
 that, I have googled all over the place for it. I've created the 
 document object now I need to pass that to RtfWriter2.getInstance() but 
 can't seem to instantiate a RtfWriter2 object.

 Any hep would be appreciated, I'm so damned close :)

 Also, how do you find these out?  I assumed there would be some way 
 through introspection but can't seem to figure out how to get the info, 
 I'm dumping the objects I have but I just get the methods and 
 properties, no info on children or super or anything.

 Paul Hastings wrote:
 Loathe wrote:
 I have a need to be able to create a word document and do page 
 numbering, and have access to the header and footer to add letterhead 
 and document classification information.  I'm wondering if anyone can 
 point me towards a solution that does this other than CF Report Builder?
 have a look at iText's rtfWriter2 class. iText powers cfdocument, etc on 
 cf7  
 above so it should just be there. if you need the latest  greatest 
 version, 
 use mark's javaLoader to load the iText jar for use w/cf.




 
 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


RE: One thing I've always wanted to build... breadcrumb trail...

2008-06-10 Thread Rick Faircloth
Thanks, Matt... sounds similar to what I was thinking about doing.

Question:  What do you mean by window numbers?

Rick

 -Original Message-
 From: Matt Williams [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, June 10, 2008 9:53 AM
 To: CF-Talk
 Subject: Re: One thing I've always wanted to build... breadcrumb trail...
 
 I have a breadcrumb solution that I created for a Mach-II app. You
 could probably pull out relevant parts of the code and use it in
 Application.cfm.
 
 At one point I attempted to make it window aware so that if a link
 spawned a new window or tab, it would keep track of that. I don't
 think this part works 100%. However, it looks a bit like this:
 
 session.struct_crumbTrails - structure for window numbers (e.g.,
 session.struct_crumbTrails.1, session.struct_crumbTrails.2)
 session.struct_crumbTrails.1 - an array of events (Mach-II speak for
 pages or requests)
 session.struct_crumbTrails.1[1] - a structure to hold the event name
 (such as home), args (query string variables stored as a struct), and
 the page name (what the crumb trail will display).
 
 It is probably a bit overly complicated due to the window number part,
 so unless that is really something you want, it should probably be
 stripped out. I also have some hooks in there so that if you want a
 the crumb trail to be reset you can do that. It also does some
 checking to make sure the same request doesn't show up twice, like on
 a refresh or from a bookmark or something.
 
 I probably need to double check with my employer before sharing the
 code, but I don't think it will be a problem (they are on Pacific
 time, so not in yet). The code is Mach-II specific and refers to an
 event object and such, but I think the code could be modified pretty
 easily. I'll post back here and possibly on my blog if/when I can
 share the code.
 
 
 On Tue, Jun 10, 2008 at 8:17 AM, Rick Faircloth
 [EMAIL PROTECTED] wrote:
  Thanks for the ideas and feedback, everyone...I'll
  check it all out!
 
  Rick
 --
 Matt Williams
 It's the question that drives us.



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


Re: One thing I've always wanted to build... breadcrumb trail...

2008-06-10 Thread Matt Williams
On Tue, Jun 10, 2008 at 10:51 AM, Rick Faircloth
[EMAIL PROTECTED] wrote:
 Thanks, Matt... sounds similar to what I was thinking about doing.

 Question:  What do you mean by window numbers?

Some of our links open a new browser window or tab. If this happens
and they started using links in both windows/tabs, then the breadcrumb
trail would get wacked out. Because it is only one session per
browser, the session crumbs would be shared between 2 windows/tabs and
have links from one show up in the other. Window numbers were my way
to prevent this. Basically if I knew a link opened a new window/tab,
it was assigned a new window number. So then window #1 and window #2
have their own bread crumb trail.

Again, this may not be an issue for you and I'm not sure I had it working 100%.

-- 
Matt Williams
It's the question that drives us.

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


Money datatype in SQL Server

2008-06-10 Thread Charlie Griefer
Is there any bottom line recommendation on using the Money datatype
in SQL Server?  I've googled and found a lot of folks say not to use
it because of accuracy issues (and of course, the fact that it's
proprietary), but I haven't seen any that suggest a better
alternative.

My understanding is that Money is exactly the same as Decimal(19,4)...
so if there are accuracy issues with Money, wouldn't those same issues
exist with a Decimal datatype?  I saw one link that suggested that
Floats would be the most accurate... but I thought floats were
inherently *not* accurate.

Can anybody shed a bit of light?

Thanks!
Charlie

-- 
A byte walks into a bar and orders a pint. Bartender asks him What's
wrong? Byte says Parity error. Bartender nods and says Yeah, I
thought you looked a bit off.

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


Re: Multi-dimentions Arrays

2008-06-10 Thread Charlie Griefer
i did a 3 part tutorial on arrays and structures that might be of some help.

http://tutorial171.easycfm.com/
http://tutorial172.easycfm.com/
http://tutorial173.easycfm.com/

check 'em out and see if they help wrap your brain around the concepts.

On Tue, Jun 10, 2008 at 7:04 AM, Kamru Miah [EMAIL PROTECTED] wrote:
 Hi, I am new to developing code with multi-dimensional arrays (or 
 structures). Could someone please advise me how to implement the following 
 4-level loops to store the financial values (for outputting at a later stage)?

 ---
 Loop by projNo
  Loop by finYear
Loop by account type (4 types)
  Loop by month/period
[show monthly amount]
  End month/period
End loop account type
  End loop finYear
 End projNo
 ---

 Thanks in anticipation, Kamru

 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


RE: Coldfusion 8 and Flex 2

2008-06-10 Thread Dave Watts
 Though you can probably just use the --services compiler 
 argument to point at a services-config.xml file instead, right ?
 That's what we do for Flash Remoting.

Yeah, that's really what happens when you define your Flex Builder project
to use LCDS or Remoting.

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, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


RE: Money datatype in SQL Server

2008-06-10 Thread Jacob
Well... I use the money datatype in SQL server for our prices.  I have had
not issues.

When we output, we use #dollarformat(queryname.price)#.  Works for what we
do.

-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, June 10, 2008 9:23 AM
To: CF-Talk
Subject: Money datatype in SQL Server

Is there any bottom line recommendation on using the Money datatype
in SQL Server?  I've googled and found a lot of folks say not to use
it because of accuracy issues (and of course, the fact that it's
proprietary), but I haven't seen any that suggest a better
alternative.

My understanding is that Money is exactly the same as Decimal(19,4)...
so if there are accuracy issues with Money, wouldn't those same issues
exist with a Decimal datatype?  I saw one link that suggested that
Floats would be the most accurate... but I thought floats were
inherently *not* accurate.

Can anybody shed a bit of light?

Thanks!
Charlie

-- 
A byte walks into a bar and orders a pint. Bartender asks him What's
wrong? Byte says Parity error. Bartender nods and says Yeah, I
thought you looked a bit off.



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


Re: Money datatype in SQL Server

2008-06-10 Thread Charlie Griefer
hmm... this was the page i saw that seemed to strongly suggest that
the money datatype could be problematic in terms of accuracy (even
provided sample SQL to run in query analyzer to see the results):

http://tinyurl.com/6fh8hl

On Tue, Jun 10, 2008 at 9:55 AM, Jacob [EMAIL PROTECTED] wrote:
 Well... I use the money datatype in SQL server for our prices.  I have had
 not issues.

 When we output, we use #dollarformat(queryname.price)#.  Works for what we
 do.

 -Original Message-
 From: Charlie Griefer [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, June 10, 2008 9:23 AM
 To: CF-Talk
 Subject: Money datatype in SQL Server

 Is there any bottom line recommendation on using the Money datatype
 in SQL Server?  I've googled and found a lot of folks say not to use
 it because of accuracy issues (and of course, the fact that it's
 proprietary), but I haven't seen any that suggest a better
 alternative.

 My understanding is that Money is exactly the same as Decimal(19,4)...
 so if there are accuracy issues with Money, wouldn't those same issues
 exist with a Decimal datatype?  I saw one link that suggested that
 Floats would be the most accurate... but I thought floats were
 inherently *not* accurate.

 Can anybody shed a bit of light?

 Thanks!
 Charlie

 --
 A byte walks into a bar and orders a pint. Bartender asks him What's
 wrong? Byte says Parity error. Bartender nods and says Yeah, I
 thought you looked a bit off.



 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


Re: Coldfusion 8 and Flex 2

2008-06-10 Thread Keith McGee
Ok, I got past that error, Now I get.

Internet Explorer cannot display the webpage 
   
   Most likely causes:
You are not connected to the Internet. 
The website is encountering problems. 
There might be a typing error in the address. 
 
   What you can try: 
 Diagnose Connection Problems  
 
 More information 

This problem can be caused by a variety of issues, including: 

Internet connectivity has been lost. 
The website is temporarily unavailable. 
The Domain Name Server (DNS) is not reachable. 
The Domain Name Server (DNS) does not have a listing for the website's domain. 
If this is an HTTPS (secure) address, click Tools, click Internet Options, 
click Advanced, and check to be sure the SSL and TLS protocols are enabled 
under the security section. 

For offline users

You can still view subscribed feeds and some recently viewed webpages.
To view subscribed feeds 

Click the Favorites Center button , click Feeds, and then click the feed you 
want to view. 

To view recently visited webpages (might not work on all pages) 

Click Tools , and then click Work Offline. 
Click the Favorites Center button , click History, and then click the page you 
want to view. 

 

Is there something I new to set up in iis like an virtual directory, and 
proporties os set as follows

Root Folder - C:\ColdFusion8\wwwroot
Root URL: - http://l127.0.0.1/
Context root - wwwroot 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


RE: Coldfusion 8 and Flex 2

2008-06-10 Thread Dave Watts
 Is there something I new to set up in iis like an virtual 
 directory, and proporties os set as follows
 
 Root Folder - C:\ColdFusion8\wwwroot
 Root URL: - http://l127.0.0.1/
 Context root - wwwroot 

The root URL is wrong, and the context root would be / by default.

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, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


Re: Word document generation (header, footer, page numbering)

2008-06-10 Thread denstar
On Tue, Jun 10, 2008 at 6:26 AM, Loathe [EMAIL PROTECTED] wrote:
 There are several well known ways of generating word documents, xml,
 html with cfcontent/header, and I hear POI although I haven't used it.

 I have a need to be able to create a word document and do page
 numbering, and have access to the header and footer to add letterhead
 and document classification information.  I'm wondering if anyone can
 point me towards a solution that does this other than CF Report Builder?

My stock answer is JasperReports.  iReport is the visual designer,
and it's quite nice (destroys the Report Builder, IMO).

It has it's own XML format for creating reports, which is swell for
use with some kind of code generator.

Building PDFs and word docs and whatnot can eat up a lot of CPU cycles
on a loaded server, so I started using JasperServer on a separate box,
and just talk to it through the webservice it provides.

It exports reports in PDF, RTF, XLS, CSV, and jasperserver will do
auto-email stuff, so every Tuesday you can automatically send someone
a report, or whatever.

We've had great experiences with this setup.  YMMV.
-denny

-- 
Dave: We're in a warehouse, and you just hit a cow. I think we better back up.

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


Re: [CF-Dev] WDDX-JSON plugin for jQuery ?

2008-06-10 Thread Carl Von Stetten
Peter,

Have you considered skipping WDDX and going straight to JSON?  If not, 
check out both AJAXCFC and JSON.CFC.

Carl

[EMAIL PROTECTED] wrote:
 A bit more background info. might be good but have you looking at AJAXCFC?

 The Robert Gordon University, a Scottish charity registered under charity 
 number SCO 13781.

 This e-mail and any attachment is for authorised use by the intended 
 recipient(s) only. It may contain proprietary material, confidential 
 information and/or be subject to legal privilege. It should not be copied, 
 disclosed to, retained or used by, any other party. If you are not an 
 intended recipient then please promptly delete this e-mail and any attachment 
 and all copies and inform the sender. Thank you.

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter Boughton
 Sent: 10 June 2008 11:40
 To: Coldfusion Development; cf-talk@houseoffusion.com
 Subject: [CF-Dev] WDDX-JSON plugin for jQuery ?

   
 - see footer for list info -
 
 Hi all,

 Does anyone have a plugin for jQuery that handles the conversion
 between WDDX and JSON?

 Or any JS-based WDDX/JSON convertor that I can take and create a
 jQuery plugin out of?

 (note: not using cf8)

 Thanks,

 Peter


  \ \
 Peter Boughton
 blog.bpsite.net
  / /

 ___

 For details on ALL mailing lists and for joining or leaving lists, go to 
 http://list.cfdeveloper.co.uk/mailman/listinfo

 --
 CFDeveloper Sponsors:-
   
 - cfdeveloper Hosting provided by www.cfmxhosting.co.uk -
 - Lists hosted by www.Gradwell.com -
 - CFdeveloper is run by Russ Michaels, feel free to volunteer your help -
 

 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


cfoutput

2008-06-10 Thread Chad Gray
If I use cfoutput with query=foo and the queries record count is 0.  The 
CFoutput is not stepped into.

Has this always been true?

I have some code like this and noticed that I never returned the NOT FOUND 
statement because if the recordcount is zero the cfoutput is skipped over.


cfoutput query=getShots
cfif getShots.recordcount EQ 0
#variables.i#, NOT FOUNDbr /
cfelse
#variables.i#,#getShots.Filename#,#getShots.JID#,#getShots.status#br /
/cfif
/cfoutput




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


Re: Money datatype in SQL Server

2008-06-10 Thread Jochem van Dieten
Charlie Griefer wrote:
 Is there any bottom line recommendation on using the Money datatype
 in SQL Server?  I've googled and found a lot of folks say not to use
 it because of accuracy issues (and of course, the fact that it's
 proprietary), but I haven't seen any that suggest a better
 alternative.
 
 My understanding is that Money is exactly the same as Decimal(19,4)...

If that is the case, why would you want to use it instead of 
Decimal(19,4)? What value does it add to your application?

Jochem

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


Re: Coldfusion 8 and Flex 2

2008-06-10 Thread Keith McGee
Ok I changed Root URL: to http://127.0.0.1/ and to http://localhost:8500/ and 
changed context root: to / and added the project directory to IIS. Still 
won’t display, any other thoughts?

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


Re: Money datatype in SQL Server

2008-06-10 Thread Charlie Griefer
On Tue, Jun 10, 2008 at 10:34 AM, Jochem van Dieten
[EMAIL PROTECTED] wrote:
 Charlie Griefer wrote:
 Is there any bottom line recommendation on using the Money datatype
 in SQL Server?  I've googled and found a lot of folks say not to use
 it because of accuracy issues (and of course, the fact that it's
 proprietary), but I haven't seen any that suggest a better
 alternative.

 My understanding is that Money is exactly the same as Decimal(19,4)...

 If that is the case, why would you want to use it instead of
 Decimal(19,4)? What value does it add to your application?

There are some people here who suggest that it makes the database more
self documenting, and I don't disagree with that... but if there are
indeed accuracy issues I think that outweighs the self-documenting
aspect :)

What I'm not fully understanding is if those same accuracy issues
exist with Decimal(19,4).  And if they do, is the solution to just be
judicious in the use of Round() functions?  or is using Float the
preferred option.

Thanks,
Charlie

-- 
A byte walks into a bar and orders a pint. Bartender asks him What's
wrong? Byte says Parity error. Bartender nods and says Yeah, I
thought you looked a bit off.

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


Re: cfoutput

2008-06-10 Thread Charlie Griefer
I believe this is (and has been) true.

put the conditional outside.

cfif getshots.recordcount eq 0
 cfoutput#variables.i#, not found/cfoutput
cfelse
 cfoutput query=getShots
  #variables.i#, #getShots.Filename#, #getShots.JID#,
#getShots.status#br /
 /cfoutput
/cfif

On Tue, Jun 10, 2008 at 10:33 AM, Chad Gray [EMAIL PROTECTED] wrote:
 If I use cfoutput with query=foo and the queries record count is 0.  The 
 CFoutput is not stepped into.

 Has this always been true?

 I have some code like this and noticed that I never returned the NOT FOUND 
 statement because if the recordcount is zero the cfoutput is skipped over.


 cfoutput query=getShots
 cfif getShots.recordcount EQ 0
#variables.i#, NOT FOUNDbr /
 cfelse
#variables.i#,#getShots.Filename#,#getShots.JID#,#getShots.status#br 
 /
 /cfif
 /cfoutput




 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


Re: Money datatype in SQL Server

2008-06-10 Thread Jochem van Dieten
Make sure you read this message as UTF-8 (the list still strips the 
charset from the content-type header).


Charlie Griefer wrote:
 There are some people here who suggest that it makes the database more
 self documenting, and I don't disagree with that...  but if there are
 indeed accuracy issues I think that outweighs the self-documenting
 aspect :)

Would you consider this an accuracy issue?

create table test (mtype money);
insert into test (mtype) values ('€ 3');
insert into test (mtype) values ('$ 3');
select * from test;

I do :)


 What I'm not fully understanding is if those same accuracy issues
 exist with Decimal(19,4).

Just like money decimal is an exact datatype, i.e. no subtle rounding 
errors at the 8+ digit are introduced. That does not mean there are no 
algorithmic rounding errors. I demonstrated a very clear one where 
stripping the currency symbol gave 3 euro and 3 dollar the same 
values. There are other possible algorithmic errors such as rounding 
between operations instead of only at the end. (Or not rounding between 
operations if that is what is required for your currency.)


 And if they do, is the solution to just be
 judicious in the use of Round() functions?  or is using Float the
 preferred option.

float is never the preferred solution when accuracy matters because it 
adds the rounding problems to all the algorithmic problems.

Jochem

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


Re: Money datatype in SQL Server

2008-06-10 Thread Jochem van Dieten
Retry, and hopefully the charset stuff now works.

Make sure you read this message as UTF-8 (the list still strips the
charset from the content-type header).


Charlie Griefer wrote:
 There are some people here who suggest that it makes the database more
 self documenting, and I don't disagree with that...  but if there are
 indeed accuracy issues I think that outweighs the self-documenting
 aspect :)

Would you consider this an accuracy issue?

create table test (mtype money);
insert into test (mtype) values ('€ 3');
insert into test (mtype) values ('$ 3');
select * from test;

I do :)


 What I'm not fully understanding is if those same accuracy issues
 exist with Decimal(19,4).

Just like money decimal is an exact datatype, i.e. no subtle rounding
errors at the 8+ digit are introduced. That does not mean there are no
algorithmic rounding errors. I demonstrated a very clear one where
stripping the currency symbol gave 3 euro and 3 dollar the same
values. There are other possible algorithmic errors such as rounding
between operations instead of only at the end. (Or not rounding between
operations if that is what is required for your currency.)


 And if they do, is the solution to just be
 judicious in the use of Round() functions?  or is using Float the
 preferred option.

float is never the preferred solution when accuracy matters because it
adds the rounding problems to all the algorithmic problems.

Jochem


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


RE: Coldfusion 8 and Flex 2

2008-06-10 Thread Dave Watts
 Ok I changed Root URL: to http://127.0.0.1/ and to 
 http://localhost:8500/ and changed context root: to / and 
 added the project directory to IIS. Still won’t display, 
 any other thoughts?

What is the URL to your swf?

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, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


CF thinks 0F is boolean.

2008-06-10 Thread Fred Anderson
I have run into an issue with cold fusion,
When I try to concatenate the string '0F'  ' ' I get a value that passes 
isBoolean().
While this works with any number of leading zeros it does not work with any 
other value besides 'F'.
Additionally it only works when you try to append a ' ' space to it.
here is a little sample.
Pvar testbr /
cfset test1 = '0A'  ' '
cfset test2 = '0F'  ' '
cfset test3 = '0F'
cfoutput 
#isBoolean(test1)#:#test1#br /
#isBoolean(test2)#:#test2#br /
#isBoolean(test3)#:#test3#br /
/cfoutput
I have tested on both CF7 and CF8.
Does anyone know why this is happening?
Thank you in advance. Fred 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


Re: CF thinks 0F is boolean.

2008-06-10 Thread Adam Haskell
Hexadecimal :)


Adam Haskell


On Tue, Jun 10, 2008 at 5:00 PM, Fred Anderson [EMAIL PROTECTED]
wrote:

 I have run into an issue with cold fusion,
 When I try to concatenate the string '0F'  ' ' I get a value that passes
 isBoolean().
 While this works with any number of leading zeros it does not work with any
 other value besides 'F'.
 Additionally it only works when you try to append a ' ' space to it.
 here is a little sample.
 Pvar testbr /
 cfset test1 = '0A'  ' '
 cfset test2 = '0F'  ' '
 cfset test3 = '0F'
 cfoutput 
 #isBoolean(test1)#:#test1#br /
 #isBoolean(test2)#:#test2#br /
 #isBoolean(test3)#:#test3#br /
 /cfoutput
 I have tested on both CF7 and CF8.
 Does anyone know why this is happening?
 Thank you in advance. Fred

 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307195
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 thinks 0F is boolean.

2008-06-10 Thread Brian Kotek
True, but 0A is also hex and it still returns false for isBoolean.

On Tue, Jun 10, 2008 at 5:13 PM, Adam Haskell [EMAIL PROTECTED] wrote:

 Hexadecimal :)


 Adam Haskell


 On Tue, Jun 10, 2008 at 5:00 PM, Fred Anderson [EMAIL PROTECTED]
 wrote:

  I have run into an issue with cold fusion,
  When I try to concatenate the string '0F'  ' ' I get a value that passes
  isBoolean().
  While this works with any number of leading zeros it does not work with
 any
  other value besides 'F'.
  Additionally it only works when you try to append a ' ' space to it.
  here is a little sample.
  Pvar testbr /
  cfset test1 = '0A'  ' '
  cfset test2 = '0F'  ' '
  cfset test3 = '0F'
  cfoutput 
  #isBoolean(test1)#:#test1#br /
  #isBoolean(test2)#:#test2#br /
  #isBoolean(test3)#:#test3#br /
  /cfoutput
  I have tested on both CF7 and CF8.
  Does anyone know why this is happening?
  Thank you in advance. Fred
 
 

 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307196
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 thinks 0F is boolean.

2008-06-10 Thread Fred Anderson
A more simplified example would be:
cfoutput
#isBoolean(0F )#
/cfoutput
Additionally '0D' has the same effect.
Fred
 I have run into an issue with cold fusion,
 When I try to concatenate the string '0F'  ' ' I get a value that 
 passes isBoolean().
 While this works with any number of leading zeros it does not work 
 with any other value besides 'F'.
 Additionally it only works when you try to append a ' ' space to it.
 here is a little sample.
 Pvar testbr /
 cfset test1 = '0A'  ' '
 cfset test2 = '0F'  ' '
 cfset test3 = '0F'
 cfoutput 
 #isBoolean(test1)#:#test1#br /
 #isBoolean(test2)#:#test2#br /
 #isBoolean(test3)#:#test3#br /
 /cfoutput
 I have tested on both CF7 and CF8.
 Does anyone know why this is happening?
 Thank you in advance. Fred 


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


Re: CF thinks 0F is boolean.

2008-06-10 Thread Wil Genovese
I just tried this with Blue Dragon JX and I get the desired results. 
http://labs.trunkful.com/isitBoolean.cfm

Also, I check other hex values and found that 0D  also comes back as  
a boolean.  ALso if you just have the string 0F  ( that is Zero Ef  
Space) you get true for boolean.  Odd.

cfset test1 = '0A'  ' '
cfset test2 = '0B'  ' '
cfset test3 = '0C'  ' '
cfset test4 = '0D'  ' '
cfset test5 = '0E'  ' '
cfset test6 = '0F'  ' '
cfset test7 = '0D '
cfset test8 = '0F '
cfoutput 
#isBoolean(test1)#:#test1#br /
#isBoolean(test2)#:#test2#br /
#isBoolean(test3)#:#test3#br /
#isBoolean(test4)#:#test4#br /
#isBoolean(test5)#:#test5#br /
#isBoolean(test6)#:#test6#br /
#isBoolean(test7)#:#test7#br /
#isBoolean(test8)#:#test8#br /

/cfoutput



Wil Genovese

One man with courage makes a majority.
-Andrew Jackson

A fine is a tax for doing wrong. A tax is a fine for doing well.


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307198
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 thinks 0F is boolean.

2008-06-10 Thread Adam Haskell
0A is a line feed (pretty sure on this) which is certainly not boolean. I
have no idea what 0F is though I thought it had some significance like
terminator or something.


Adam Haskell

On Tue, Jun 10, 2008 at 5:20 PM, Brian Kotek [EMAIL PROTECTED] wrote:

 True, but 0A is also hex and it still returns false for isBoolean.

 On Tue, Jun 10, 2008 at 5:13 PM, Adam Haskell [EMAIL PROTECTED] wrote:

  Hexadecimal :)
 
 
  Adam Haskell
 
 
  On Tue, Jun 10, 2008 at 5:00 PM, Fred Anderson [EMAIL PROTECTED]
  wrote:
 
   I have run into an issue with cold fusion,
   When I try to concatenate the string '0F'  ' ' I get a value that
 passes
   isBoolean().
   While this works with any number of leading zeros it does not work with
  any
   other value besides 'F'.
   Additionally it only works when you try to append a ' ' space to it.
   here is a little sample.
   Pvar testbr /
   cfset test1 = '0A'  ' '
   cfset test2 = '0F'  ' '
   cfset test3 = '0F'
   cfoutput 
   #isBoolean(test1)#:#test1#br /
   #isBoolean(test2)#:#test2#br /
   #isBoolean(test3)#:#test3#br /
   /cfoutput
   I have tested on both CF7 and CF8.
   Does anyone know why this is happening?
   Thank you in advance. Fred
  
  
 
 

 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


RE: One thing I've always wanted to build... breadcrumb trail...

2008-06-10 Thread Jim Davis
 -Original Message-
 From: Rick Faircloth [mailto:[EMAIL PROTECTED]
 Sent: Monday, June 09, 2008 11:54 PM
 To: CF-Talk
 Subject: One thing I've always wanted to build... breadcrumb trail...
 
 Not the one that represents a folder structure or
 hierarchy, but shows the exact places visited.
 
 Home  Services  Contact  Pricing  FAQ

I've done this on my site for years:

www.depressedpress.com

I call it the ClickStream - it's up near the top right.

 Anyone know of a tutorial on how to do this?


In my case a lot of this falls from application framework.  I maintain an
instance of a session component for each user - that stores information
about them (browser information, clickstream, credentials, etc).  The whole
framework (all the CFC libraries) is here (look to the Framework Package
specifically):

http://www.depressedpress.com/Content/Development/ColdFusion/DPLibraries/Ind
ex.cfm

The actual clickstream component (a property of the session component) is
really just an abstraction of an array:

http://www.depressedpress.com/Content/Development/ColdFusion/DPLibraries/Doc
umentation/DocViewer.cfm?Component=cfc_DepressedPress.Framework.DP_Clickstre
am

If you look at the add method that's the meat of it.  I store the URL, the
QueryString (if any), the title of the page (to make using the data easier -
but it also means that your title is available), the datetime (let's you
infer how long they've spent on each page) and a boolen true if the user
was logged in at the time of the entry.

Each user has a key and each session has a key - when the session ends the
clickstream is saved to the database for later analysis.  I could pull up
clickstreams from previous visits (one of those to do items I never seem
to get around to) this way.

In any case the basic idea is just an array of URLs - what you do with the
data is up to you.  It can be as simple as here's where you've been or you
can get into really cool custom analytics.  ;^)

Jim Davis


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


Extending ColdFusion 8 servemonitoring.cfc

2008-06-10 Thread Andy Matthews
Is it possible to extend the servermonitoring cfc?

I'm writing a POC app and I thought it would be a simple thing to extend the 
SM.cfc so that I wouldn't have to write the methods myself. Also, that I 
wouldn't have to bother creating the object.

Just wanted to check if it's possible because I'm getting a JRun error when I 
try to hit my CFC in the browser:

cfcomponent displayname=SMApp hint=Accesses various methods from the 
Servermonitoring.cfc extends=cfide.adminapi.servermonitoring output=false

cfscript
overview = {};
overview['serverUptime'] = 0;
/cfscript

cffunction name=init returntype=SMApp access=remote 
description=initializes the SMApp connection
cfreturn this
/cffunction

/cfcomponent 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307201
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 thinks 0F is boolean.

2008-06-10 Thread Brad Wood
Man, I wish we could examine the source code on this kind of stuff.

When I do a bunch of isboolean's SeeFusion's stack trace sees a lot of
coldfusion.runtime.CFDouble.parseDouble and
java.lang.FloatingDecimal.readJavaFormatString going on, but there must
obviously be some more there that doesn't take long enough to catch in
the stack trace.  Maybe some regex is being used to get out yes, no,
true, false, and...  ??

~Brad

-Original Message-
From: Adam Haskell [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, June 10, 2008 4:34 PM
To: CF-Talk
Subject: Re: CF thinks 0F is boolean.

0A is a line feed (pretty sure on this) which is certainly not boolean.
I
have no idea what 0F is though I thought it had some significance like
terminator or something.


Adam Haskell

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


Importing Lists with empty values

2008-06-10 Thread Les Mizzell
I've set up a function for a client to import lists of email addresses 
from | delimeted files generated from Excel spreadsheets. There's a 
specific format that they always use:

firstname|lastname|emailaddress|other

No problems. The code below works fine:

--

cfloop from=1 to=#ArrayLen(queryFromFile)# index=i

   cfset fromARRAY = #queryFromFile[i]#
   cfset emailLIST = 
   cfset emailLIST = ListAppend(emailLIST,fromARRAY,|)

!--- IF THE ROW DOES NOT HAVE ALL 4 ELEMENTS, SKIP IT ---
cfif ListLen(emailLIST,|) EQ 4
  cfset req.firstname = ListGetAt(emailLIST,1,|)
  cfset req.lastname = ListGetAt(emailLIST,2,|)
  cfset req.email = ListGetAt(emailLIST,3,|)
  cfset req.other = ListGetAt(emailLIST,4,|)
/cfif

 then check for valid email address and insert the row
 into the database...

--

But, they need to import a bunch of new list that may *not* have all 
four fields for each row, so I could end up with a list looking like:

firstname|lastname|emailaddress|other
firstname||emailaddress|other
|lastname|emailaddress|other

Since the empty fields are ignored, everything gets snockered up into 
the wrong columns.

What's going to be my best way to assign a null or empty value to the 
empty elements so everything ends up in the correct column? Been working 
on this for awhile, but haven't found a great solution yet


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


Re: Importing Lists with empty values

2008-06-10 Thread Barney Boisvert
replace | with  |  (that's space-pipe-space), do your parse, and
then trim everything coming out of it.

cheers,
barneyb

On Tue, Jun 10, 2008 at 3:18 PM, Les Mizzell [EMAIL PROTECTED] wrote:
 I've set up a function for a client to import lists of email addresses
 from | delimeted files generated from Excel spreadsheets. There's a
 specific format that they always use:

 firstname|lastname|emailaddress|other

 No problems. The code below works fine:

 --

 cfloop from=1 to=#ArrayLen(queryFromFile)# index=i

   cfset fromARRAY = #queryFromFile[i]#
   cfset emailLIST = 
   cfset emailLIST = ListAppend(emailLIST,fromARRAY,|)

 !--- IF THE ROW DOES NOT HAVE ALL 4 ELEMENTS, SKIP IT ---
 cfif ListLen(emailLIST,|) EQ 4
  cfset req.firstname = ListGetAt(emailLIST,1,|)
  cfset req.lastname = ListGetAt(emailLIST,2,|)
  cfset req.email = ListGetAt(emailLIST,3,|)
  cfset req.other = ListGetAt(emailLIST,4,|)
 /cfif

  then check for valid email address and insert the row
 into the database...

 --

 But, they need to import a bunch of new list that may *not* have all
 four fields for each row, so I could end up with a list looking like:

 firstname|lastname|emailaddress|other
 firstname||emailaddress|other
 |lastname|emailaddress|other

 Since the empty fields are ignored, everything gets snockered up into
 the wrong columns.

 What's going to be my best way to assign a null or empty value to the
 empty elements so everything ends up in the correct column? Been working
 on this for awhile, but haven't found a great solution yet


 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


RE: Importing Lists with empty values

2008-06-10 Thread Brad Wood
http://www.cflib.org/index.cfm?event=page.udfbyidudfid=507
for starters

Alternatively you could do a manual replace to replace every instance of
|| with |some reserved word that you will interpret as blank|

Just make sure you do the replace twice so firstname|||address|other
will work as well.

~Brad

-Original Message-
From: Les Mizzell [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, June 10, 2008 5:18 PM
To: CF-Talk
Subject: Importing Lists with empty values

I've set up a function for a client to import lists of email addresses 
from | delimeted files generated from Excel spreadsheets. There's a 
specific format that they always use:

firstname|lastname|emailaddress|other

No problems. The code below works fine:

--

cfloop from=1 to=#ArrayLen(queryFromFile)# index=i

   cfset fromARRAY = #queryFromFile[i]#
   cfset emailLIST = 
   cfset emailLIST = ListAppend(emailLIST,fromARRAY,|)

!--- IF THE ROW DOES NOT HAVE ALL 4 ELEMENTS, SKIP IT ---
cfif ListLen(emailLIST,|) EQ 4
  cfset req.firstname = ListGetAt(emailLIST,1,|)
  cfset req.lastname = ListGetAt(emailLIST,2,|)
  cfset req.email = ListGetAt(emailLIST,3,|)
  cfset req.other = ListGetAt(emailLIST,4,|)
/cfif

. then check for valid email address and insert the row
 into the database...

--

But, they need to import a bunch of new list that may *not* have all 
four fields for each row, so I could end up with a list looking like:

firstname|lastname|emailaddress|other
firstname||emailaddress|other
|lastname|emailaddress|other

Since the empty fields are ignored, everything gets snockered up into 
the wrong columns.

What's going to be my best way to assign a null or empty value to the 
empty elements so everything ends up in the correct column? Been working

on this for awhile, but haven't found a great solution yet




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307205
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 thinks 0F is boolean.

2008-06-10 Thread Jim Davis
 -Original Message-
 From: Fred Anderson [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, June 10, 2008 5:31 PM
 To: CF-Talk
 Subject: Re: CF thinks 0F is boolean.
 
 A more simplified example would be:
 cfoutput
 #isBoolean(0F )#
 /cfoutput
 Additionally '0D' has the same effect.

I think you may find that 0D and 0E have the same effect - I'm guessing, but
I think CF is treating the letters as part of a number in scientific
notation.  0E isn't really useful, but it IS zero in scientific notation.
;^)

And in CF a zero is an acceptable Boolean.

You should be able to test this by doing cfif 0F EQ 0

Jim Davis


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


RE: CF thinks 0F is boolean.

2008-06-10 Thread Jim Davis
 -Original Message-
 From: Adam Haskell [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, June 10, 2008 5:34 PM
 To: CF-Talk
 Subject: Re: CF thinks 0F is boolean.
 
 0A is a line feed (pretty sure on this) which is certainly not boolean.
 I
 have no idea what 0F is though I thought it had some significance like
 terminator or something.

To be clear (and just a bit smugly, self-satisfied and pedantic) 0A is just
a number (a hexadecimal number which is 10 in decimal).  10, in ASCII, is  a
line feed, but 0A is just a number.  The function char(0A) would return a
line feed, tho'.

Yup. I can be a picky, picky prick sometimes.  ;^)

Jim Davis


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307207
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 thinks 0F is boolean.

2008-06-10 Thread Adam Haskell
Good point. on both accounts :-P


Adam Haskell

On Tue, Jun 10, 2008 at 6:39 PM, Jim Davis [EMAIL PROTECTED]
wrote:

  -Original Message-
  From: Adam Haskell [mailto:[EMAIL PROTECTED]
  Sent: Tuesday, June 10, 2008 5:34 PM
  To: CF-Talk
  Subject: Re: CF thinks 0F is boolean.
 
  0A is a line feed (pretty sure on this) which is certainly not boolean.
  I
  have no idea what 0F is though I thought it had some significance like
  terminator or something.

 To be clear (and just a bit smugly, self-satisfied and pedantic) 0A is just
 a number (a hexadecimal number which is 10 in decimal).  10, in ASCII, is
  a
 line feed, but 0A is just a number.  The function char(0A) would return a
 line feed, tho'.

 Yup. I can be a picky, picky prick sometimes.  ;^)

 Jim Davis


 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


Application.cfc variables

2008-06-10 Thread Alex Pogodin
Hi everyone!

Can somebody explain me why assigning a value to This.Blah inside 
Application.cfc doesn't affect Application struct itself. Doesn't 
Application.cfc represent an application scope? if so, why assigning 
this.name inside cfc affects Application. and one more related question: 
do I need to explicitly use Application scoping inside Application.cfc?

Any info is very appreciated.

Thanks in advance,
Alex

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


Re: Application.cfc variables

2008-06-10 Thread Barney Boisvert
the 'this' scope corresponds to the CFAPPLICATION tag, not the
application scope.  If you want to set stuff into the application
scope you have to use it literally.  A concrete example: setting
this.name is equivalent to passing the NAME attribute to
CFAPPLICATION, which in turn is available as the
application.applicationname variable.

cheers,
barneyb

On Tue, Jun 10, 2008 at 3:58 PM, Alex Pogodin [EMAIL PROTECTED] wrote:
 Hi everyone!

 Can somebody explain me why assigning a value to This.Blah inside
 Application.cfc doesn't affect Application struct itself. Doesn't
 Application.cfc represent an application scope? if so, why assigning
 this.name inside cfc affects Application. and one more related question:
 do I need to explicitly use Application scoping inside Application.cfc?

 Any info is very appreciated.

 Thanks in advance,
 Alex

 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307210
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 thinks 0F is boolean.

2008-06-10 Thread Brad Wood
Hmm, this isn't much, but when you step through an isboolean(0f )
function in a debugger, this is a _rough_ list of Java methods that get
called (several of these get called many times in a row).

Definitely no regex-- mostly attempts to parse as a double etc, and some
string manipulation.  I can watch the variables as they go by, but I
obviously can't see the actual Java code with the exception of when it
dips down into method in the String class etc...

CfJspPage.internalIsBoolean(Object) line: 677   
String.length() line: 535   
String.charAt(int) line: 557
CFDouble.parseDouble(String) line: 21   
String.length() line: 535   
CFDouble.parseDouble(String) line: 21   
String.charAt(int) line: 557
CFDouble.parseDouble(String) line: 21   
Double.parseDouble(String) line: 482
FloatingDecimal.readJavaFormatString(String) line: 984  
String.trim() line: 2483
String.substring(int, int) line: 1761   
String.init(int, int, char[]) line: 520   
FloatingDecimal.readJavaFormatString(String) line: 991  
String.charAt(int) line: 560
FloatingDecimal.readJavaFormatString(String) line: 996  
Math.min(int, int) line: 862
FloatingDecimal.doubleValue() line: 1259 [local variables unavailable]  
CfJspPage.internalIsBoolean(Object) line: 712   
Double.isInfinite(double) line: 506 

~Brad

-Original Message-
From: Brad Wood [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, June 10, 2008 5:11 PM
To: CF-Talk
Subject: RE: CF thinks 0F is boolean.

Man, I wish we could examine the source code on this kind of stuff.

When I do a bunch of isboolean's SeeFusion's stack trace sees a lot of
coldfusion.runtime.CFDouble.parseDouble and
java.lang.FloatingDecimal.readJavaFormatString going on, but there must
obviously be some more there that doesn't take long enough to catch in
the stack trace.  Maybe some regex is being used to get out yes, no,
true, false, and...  ??

~Brad

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


RE: Can't create Verity collections

2008-06-10 Thread Frank
At 06:05 PM 2008-06-09, you wrote:
Is the verity engine enabled?  By default it is not enabled in CF8 and
you have to run a command line utility.

It should be, when I run a cfcollection tag or ask verity to create 
the collection via the CF admin, it tries, but it presents me with an 
error. So I assume the error pre-supposes it's working.

I don't know if you are going to be able to use the verity collections
from CF7 with CF8.  I was unable to get CF8 to recognize CF6 verity
collections.

I don't really care about the CF 7 collection, the only intent was 
that if I could not create one, that I would try to map to the existing one.

No luck on either fronts. I'm still open to options.

Thanks!



Frank Marion [EMAIL PROTECTED]  Keep the signal high.




-- 
No virus found in this outgoing message.
Checked by AVG. 
Version: 7.5.524 / Virus Database: 270.2.0/1495 - Release Date: 2008-06-10 5:11 
PM



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


Re: Need some advice on approach...

2008-06-10 Thread s. isaac dealey
 Thanks for the wildcard idea, Isaac... that definitely sounds better!

Welcome. :) 

-- 
s. isaac dealey  ^  new epoch
 isn't it time for a change? 
 ph: 617.365.5732

http://onTap.riaforge.org/blog



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307213
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 thinks 0F is boolean.

2008-06-10 Thread denstar
On Tue, Jun 10, 2008 at 6:16 PM, Brad Wood [EMAIL PROTECTED] wrote:

 Definitely no regex-- mostly attempts to parse as a double etc, and some
 string manipulation.  I can watch the variables as they go by, but I
 obviously can't see the actual Java code with the exception of when it
 dips down into method in the String class etc...

JADclipse, a plugin for eclipse that uses the java decompiler, seems
to reveal a good bit of stuff.

Might be helpful if you're one of those digging types.

:d

-- 
be, or do, there is no try

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


RE: One thing I've always wanted to build... breadcrumb trail...

2008-06-10 Thread Rick Faircloth
Thanks for the info, Jim...sounds great!

I'll check it out!

Rick

 -Original Message-
 From: Jim Davis [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, June 10, 2008 5:53 PM
 To: CF-Talk
 Subject: RE: One thing I've always wanted to build... breadcrumb trail...
 
  -Original Message-
  From: Rick Faircloth [mailto:[EMAIL PROTECTED]
  Sent: Monday, June 09, 2008 11:54 PM
  To: CF-Talk
  Subject: One thing I've always wanted to build... breadcrumb trail...
 
  Not the one that represents a folder structure or
  hierarchy, but shows the exact places visited.
 
  Home  Services  Contact  Pricing  FAQ
 
 I've done this on my site for years:
 
 www.depressedpress.com
 
 I call it the ClickStream - it's up near the top right.
 
  Anyone know of a tutorial on how to do this?
 
 
 In my case a lot of this falls from application framework.  I maintain an
 instance of a session component for each user - that stores information
 about them (browser information, clickstream, credentials, etc).  The whole
 framework (all the CFC libraries) is here (look to the Framework Package
 specifically):
 
 http://www.depressedpress.com/Content/Development/ColdFusion/DPLibraries/Ind
 ex.cfm
 
 The actual clickstream component (a property of the session component) is
 really just an abstraction of an array:
 
 http://www.depressedpress.com/Content/Development/ColdFusion/DPLibraries/Doc
 umentation/DocViewer.cfm?Component=cfc_DepressedPress.Framework.DP_Clickstre
 am
 
 If you look at the add method that's the meat of it.  I store the URL, the
 QueryString (if any), the title of the page (to make using the data easier -
 but it also means that your title is available), the datetime (let's you
 infer how long they've spent on each page) and a boolen true if the user
 was logged in at the time of the entry.
 
 Each user has a key and each session has a key - when the session ends the
 clickstream is saved to the database for later analysis.  I could pull up
 clickstreams from previous visits (one of those to do items I never seem
 to get around to) this way.
 
 In any case the basic idea is just an array of URLs - what you do with the
 data is up to you.  It can be as simple as here's where you've been or you
 can get into really cool custom analytics.  ;^)
 
 Jim Davis



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


Re: Importing Lists with empty values

2008-06-10 Thread Raymond Camden
Don't forget CF8 modified ListToArray so you can detect empty items in a list.

On Tue, Jun 10, 2008 at 5:19 PM, Brad Wood [EMAIL PROTECTED] wrote:
 http://www.cflib.org/index.cfm?event=page.udfbyidudfid=507
 for starters

 Alternatively you could do a manual replace to replace every instance of
 || with |some reserved word that you will interpret as blank|

 Just make sure you do the replace twice so firstname|||address|other
 will work as well.


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


Re: Importing Lists with empty values

2008-06-10 Thread Les Mizzell
Raymond Camden wrote:
 Don't forget CF8 modified ListToArray so you can detect empty items in a list.


Yea - as soon as I get my freaking client to upgrade!!!
Still stuck with CF7!

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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


cffile upload temporary folder changes

2008-06-10 Thread James Holmes
I predict this is another stumper.

Occasionally, on one of our servers, the temporary folder into which
cffile uploads go before they are moved to the final location changes
from the correct
cf_root/runtime/servers/coldfusion/SERVER-INF/temp/wwwroot-tmp/ to
/var/tmp.

Has anyone else experienced this and solved it?

We're on Solaris / CF7.02 Ent / Apache 2.

-- 
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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