RE: Problem loading data from text file...

2008-09-18 Thread Eric Roberts
Why not use cffile and then load it into the db...then you could easily
process the data to be however you want it?

Eric

/*-Original Message-
/*From: Rick Faircloth [mailto:[EMAIL PROTECTED]
/*Sent: Wednesday, September 17, 2008 7:40 PM
/*To: CF-Talk
/*Subject: Problem loading data from text file...
/*
/*I'm using this query to load data into a table from a text file:
/*
/*cfquery name=load_data datasource=c21ar
/*
/*  load data infile
/*'e:/inetpub/webroot/real_estate_data/hmls/data/#today#_idx_custom/active_p
/*hotos.txt'
/*  into table hmls_active_photos_temp
/*  lines terminated by '\r\n'
/*  ignore 1 lines
/*
/*/cfquery
/*
/*It runs fine except for the fact that at the end of each day's new
/*active_photos.txt file,
/*there are a couple of blanks lines, like the ENTER key has been struck a
/*couple of times
/*after the last line of data.
/*
/*The load data infile command is trying to read these lines and throws an
/*error because of the
/*empty lines.
/*
/*Is there some way to cause this query not to process, or to skip, empty
/*lines?  The empty lines
/*are always at the end of the file and prevent me from automating the
/*loading of data.
/*
/*Suggestions?
/*
/*Thanks,
/*
/*Rick
/*
/*
/*

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

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


RE: JRun issues on Vista 64 bit?

2008-09-18 Thread WebSite CFtalk
Security?

Try to setup the datasource manually in the xml file?

Helge

-Original Message-
From: Jeff Chastain [mailto:[EMAIL PROTECTED] 
Sent: 18. september 2008 02:52
To: CF-Talk
Subject: Re: JRun issues on Vista 64 bit?

In addition, I tried creating a MSSQL datasource, connecting to another
server I have running MSSQL 2005 and JRun crashed trying to setup that
datasource as well, so it is something local to the JRun/CF install and
its connection ability with MSSQL. 



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

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


Re: Nested sets under load

2008-09-18 Thread Gert Franz
Well a good tip for me was that the difference between two left values 
is not one but for example 10. In this case you can update your left  
right values without having to update all the left  right values larger 
than a particular one when you insert a record or delete one. You can 
then reorganize your tree once a day and then you have your usual 
differences again. So check the following example:

Classical Nested Set:
NodeLeftRight
A   1   10
? B 2   5
 | ? C  3   4
? D 6   9
 ? E7   8


If you now insert a new node F below the node B you have to update 
several nodes:
NodeLeftRight
A   1   12
? B 2   7
 | ? C  3   4
 | ? F  5   6
? D 8   11
 ? E9   10

In this particular case you had to update all nodes!

The new more spaced nested set would look like:
NodeLeftRight
A   10  100
? B 20  50
 | ? C  30  40
? D 60  90
 ? E70  80


An insert of the Node F below the node B would only require one insert:
NodeLeftRight
A   10  100
? B 20  50
 | ? C  30  40
 | ? F  41  42
? D 60  90
 ? E70  80


You see the rest of the nodes keep their values. Of course after several 
insert the tree might get crowdy, but with a little logic, you can 
manage this quite easily and get rid of tons of updates.
Another good practice is to keep the left  right values in a separate 
table. Then only these values get updated and the main Table where the 
tree resides is untouched. I use a combination of nested set and parent 
child values. In this case I can reorganize the tree at any time.

BTW: a very good book about nested set tree model is Joe Celko's SQL 
for Smarties. He has released one about hierarchies in SQL as well. You 
might want to have a look at it.

Greetings from Switzerland
Gert Franz
Railo Technologies GmbH
[EMAIL PROTECTED]
www.railo.ch

Join our Mailing List
german:http://de.groups.yahoo.com/group/railo/
english:   http://groups.yahoo.com/group/railo_talk/
linked in: http://www.linkedin.com/e/gis/71368/0CF7D323BBC1



Mike Kear schrieb:
 @Brad:  thanks for the advice.  Throws my plans into a spin, but not
 as much as it might have it if the whole shebang gor fubared.  (I
 didnt know 'fubar' was a verb!).

 @Mark: It's MSSql 2005. Thanks for the tip Mark,  I'll have a look at that.

 What is going to happen is event type {a} happens (lets say it's a
 sale).  That triggers a default action plan of umpteen things that
 have to follow based on that event, documents that have to be filed,
 people notified, approvals gained etc, then the the default plan has
 to be modified to allow for the specifics of this particular
 transaction.

 So the event has to trigger the generation of a whole heirarchy of
 maybe up to 50 things that have to happen, some of which rely on
 previous things being done

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

   



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

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


Re: Trouble getting this loop to work ...

2008-09-18 Thread Gert Franz
John... THere's something wrong with your code. Shouldn't it read:

If mcategories is a fieldvalue:

cfloop list=#mcategory# index=mcategories delimiters=,
cfquery name=qGetMList datasource=ROL
select * 
from tablename where categories = 
#getcategorydetailnames(mcategories)#;
/cfquery
/cfloop

When it's a tablename then it should read:

cfloop list=#mcategory# index=mcategories delimiters=,
cfquery name=qGetMList datasource=ROL
select * 
from #getcategorydetailnames(mcategories)#;
/cfquery
/cfloop

Or am I getting something wrong here...

Greetings from Switzerland
Gert Franz
Railo Technologies GmbH
[EMAIL PROTECTED]
www.railo.ch

Join our Mailing List
german:http://de.groups.yahoo.com/group/railo/
english:   http://groups.yahoo.com/group/railo_talk/
linked in: http://www.linkedin.com/e/gis/71368/0CF7D323BBC1



John Seelye schrieb:
 Having trouble getting this loop to work. I'm not sure anymore if it is even 
 possible, but it seemed like a good way to go at the start.

 What I'm trying to do is have the loop take the list (it can be anything from 
 1 to 42 items long) from a form and then run the function in the cfquery 
 for each item in the list and keep the output from each iteration of the 
 query in #mcategories# 

 cfloop list=#mcategory# index=mcategories delimiters=,
 cfquery name=qGetMList datasource=ROL
 select * 
 from ROL.getcategorydetailnames(#mcategories#);
 /cfquery
 /cfloop


 

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

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


Re: Developing an order form for an application

2008-09-18 Thread Randy
If possible (in your environment), use JS to dynamically do the calculations
while th euser is on the form.
It gives them a visualization of the total cost.

On Wed, Sep 17, 2008 at 9:21 PM, Toby King [EMAIL PROTECTED] wrote:

 Just wondering what the easiest way might be to complete the following task

 I have a client that has requested that they display an order form on their
 website.

 Basically they want the form to look like the following:

 Product NamePrice QTY   Total
 Product 13.00  2 6.00
 Product 25.00  1 5.00
 Product 36.00  318.00

 Total   29.00

 Developing the form is easy - just wanting to know what the best way would
 be to do the calculations in the form prior to the user submitting the form.

 Thanks in advance


 Here is the code that I have so far:

 form action=## id=orderform1
 cfoutput
 table width=100% border=0 cellspacing=0 cellpadding=0
  tr
thProduct/th
thDescription/th
thUnit Price /th
thQuantity/th
thSubtotoal/th
/tr
  tr
tdProduct 1 /td
tdProd 1 desc /td
td align=center3.00/td
td align=centerinput name=qty1 type=text value=#1# size=3
 onBlur=cleanField(this)/td
td align=center3.00 * qty1  /tr
  tr
tdProduct 2 /td
tdProd 2 desc /td
td align=center5.00/td
td align=centerinput name=qty2 type=text value=## size=3
 onBlur=cleanField(this)/td
td align=center5.00/td
/tr
  tr
tdProduct 3 /td
tdProd 3 desc /td
td align=center6.00/td
td align=centerinput name=qty3 type=text value=## size=3
 onBlur=cleanField(this)/td
td align=center18.00/td
/tr
  tr
td align=centerTotal/td
td align=centernbsp;/td
td align=centernbsp;/td
td align=centernbsp;/td
td align=center29.00/td
/tr
  tr
td align=centernbsp;/td
td align=centernbsp;/td
td align=centernbsp;/td
td align=centernbsp;/td
td align=centernbsp;/td
/tr
 /table
 /cfoutput
 /form

 Thanks in advance.



 

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

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


Re: Developing an order form for an application

2008-09-18 Thread Toby King
I guess that is what I was thinking except I am not a JS expert.

Any feedback on the Javascript to be used would be greatly appreciated.

Thanks in advance.



If possible (in your environment), use JS to dynamically do the calculations
while th euser is on the form.
It gives them a visualization of the total cost.



 

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

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


Re: Developing an order form for an application

2008-09-18 Thread Brian Swartzfager
Hi, Toby,

You could use a JavaScript framework like jQuery to do the calculations.

In fact, Ray Camden just recently had a blog post about how to use jQuery to 
solve a very similar problem:

http://www.coldfusionjedi.com/index.cfm/2008/9/10/Ask-a-Jedi-Dynamically-updating-line-items-on-a-form

--Brian



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

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


Re: Nested sets under load

2008-09-18 Thread Jochem van Dieten
Mike Kear wrote:
 What is going to happen is event type {a} happens (lets say it's a
 sale).  That triggers a default action plan of umpteen things that
 have to follow based on that event, documents that have to be filed,
 people notified, approvals gained etc, then the the default plan has
 to be modified to allow for the specifics of this particular
 transaction.
 
 So the event has to trigger the generation of a whole heirarchy of
 maybe up to 50 things that have to happen, some of which rely on
 previous things being done

Would it be correct to say you have a table with X independent 
hierarchies with about 50 elements per hierarchy with their own left and 
right values, where you can identify which hierarchy an element belongs 
to because they all reference the original event (the sale)? Because in 
that case when you update a hierarchy you are only updating a limited 
range of the total table. That really shouldn't pose any performance 
problems for a well tuned database.

Jochem

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

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


RE: XML-RPC with CF8?

2008-09-18 Thread Che Vilnonis
+1 to this CFC. Just used it to consume the Oodle.com classifieds API.
~Che 

-Original Message-
From: Brad Wood [mailto:[EMAIL PROTECTED] 
Sent: Thursday, September 18, 2008 12:21 AM
To: CF-Talk
Subject: Re: XML-RPC with CF8?

I actually just got done doing a project that consumed an XML-RPC web
service.  There is a CFC Roger Benningfield wrote that will translate
xml-rpc xml to ColdFusion vars and back again.
There is a link in the comments of my blog here:
http://www.codersrevolution.com/index.cfm/2008/8/30/XMLRPC-Alive-yes-but-sti
ll-kicking

Basically, you call the webservice with a cfhttp tag, and you simply pass
the XML as the body of the request and parse the XML that comes back.
Here's a snippet of code that goes with the CFC I mentioned above (error
checking removed).

cfset local.request_xml = CFML2XMLRPC(local.inputs_array,'call')

cfhttp url=#arguments.web_service_location# method=POST timeout=60 
result=local.cfhttp
 cfhttpparam name=request_body value=#local.request_xml# type=xml
/cfhttp

cfset local.response = XMLRPC2CFML(local.cfhttp.filecontent)

~Brad



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

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


Re: Developing an order form for an application

2008-09-18 Thread Gerald Guido
+1 for jQuery.

Having rolled plenty of price calculators by hand and by looking at Ray's
example (which is pretty darn slick) I would recommend using a JS framework
like jQuery. It will definitely take a lot of the grunt work and pain of the
process.

jQuery is a lot like CF in that it makes hard things (relatively) easy.

~G~

On Thu, Sep 18, 2008 at 7:56 AM, Brian Swartzfager [EMAIL PROTECTED] wrote:

 Hi, Toby,

 You could use a JavaScript framework like jQuery to do the calculations.

 In fact, Ray Camden just recently had a blog post about how to use jQuery
 to solve a very similar problem:


 http://www.coldfusionjedi.com/index.cfm/2008/9/10/Ask-a-Jedi-Dynamically-updating-line-items-on-a-form

 --Brian



 

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

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


Re: Alternative to using CONTAINS repeatedly?

2008-09-18 Thread Julie Davenport
To all who replied and offered advice, thank you very much.  Sorry for the 
delay in responding.  Good tips from all, thanks again.
Julie


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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312757
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 7.0.2 freezes on install

2008-09-18 Thread Greg Morphis
I left it trying to install all last night and nada.. after 15 hours,
still nothing..
I think it may have to do with the installer..

For fun I ran the CF 8 installer and the install screen looks
different.. Buttons!
In the CF 7 installer  the buttons are labels and there aren't any
radio buttons..
So I wonder if it's even registering the button click at the end to
initiate the install
Here's some screen shots..
http://img140.imageshack.us/my.php?image=ss1od6.jpg
http://img140.imageshack.us/my.php?image=ss2dn9.jpg
http://img140.imageshack.us/my.php?image=ss3hc5.jpg
http://img140.imageshack.us/my.php?image=ss4ri9.jpg

So what the hell? Any Adobe guys reading the forums that might have suggestions?
CF 8 is installing fine but our dev and prod server is CF 7.0.2. I
really need to get 7.0.2 installed.



On Tue, Sep 16, 2008 at 7:51 AM, Greg Morphis [EMAIL PROTECTED] wrote:
  I tried 3 different versions, they all did the same. I'll get with
 the LAN people tomorrow and see what's up.

 On Tue, Sep 16, 2008 at 3:47 AM, Azadi Saryev [EMAIL PROTECTED] wrote:
 + make sure windows firewall (or any other firewall you may be using) is
 turned off or at least not blocking ports required by installation
 (there is a list of those somewhere on abode website... i prefer to just
 turn firewalls off).

 Azadi Saryev
 Sabai-dee.com
 http://www.sabai-dee.com/



 Brad Wood wrote:
 For starters, can you re-download the installation (make sure you have the
 correct 32 bit or 64 bit version) and verify the file size to ensure you
 downloaded the entire file.
 Also, shut down any other programs during the install and make sure you have
 installation rights as well as making sure there are no anti-virus programs
 messing with you.

 ~Brad

 - Original Message -
 From: Greg Morphis [EMAIL PROTECTED]
 To: CF-Talk cf-talk@houseoffusion.com
 Sent: Monday, September 15, 2008 5:30 PM
 Subject: Re: cf 7.0.2 freezes on install



 I finally cancelled after nearly 3 hours...





 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312758
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 7.0.2 freezes on install

2008-09-18 Thread Ryan Stille
I have no suggestions for your issue, but you may be able to get around 
it by doing a silent install:
http://kb.adobe.com/selfservice/viewContent.do?externalId=87bd20f4

-Ryan

Greg Morphis wrote:
 I left it trying to install all last night and nada.. after 15 hours,
 still nothing..
 I think it may have to do with the installer..

 For fun I ran the CF 8 installer and the install screen looks
 different.. Buttons!
 In the CF 7 installer  the buttons are labels and there aren't any
 radio buttons..
 So I wonder if it's even registering the button click at the end to
 initiate the install
 Here's some screen shots..
 http://img140.imageshack.us/my.php?image=ss1od6.jpg
 http://img140.imageshack.us/my.php?image=ss2dn9.jpg
 http://img140.imageshack.us/my.php?image=ss3hc5.jpg
 http://img140.imageshack.us/my.php?image=ss4ri9.jpg

 So what the hell? Any Adobe guys reading the forums that might have 
 suggestions?
 CF 8 is installing fine but our dev and prod server is CF 7.0.2. I
 really need to get 7.0.2 installed.



 On Tue, Sep 16, 2008 at 7:51 AM, Greg Morphis [EMAIL PROTECTED] wrote:
   
  I tried 3 different versions, they all did the same. I'll get with
 the LAN people tomorrow and see what's up.

 On Tue, Sep 16, 2008 at 3:47 AM, Azadi Saryev [EMAIL PROTECTED] wrote:
 
 + make sure windows firewall (or any other firewall you may be using) is
 turned off or at least not blocking ports required by installation
 (there is a list of those somewhere on abode website... i prefer to just
 turn firewalls off).

 Azadi Saryev
 Sabai-dee.com
 http://www.sabai-dee.com/



 Brad Wood wrote:
   
 For starters, can you re-download the installation (make sure you have the
 correct 32 bit or 64 bit version) and verify the file size to ensure you
 downloaded the entire file.
 Also, shut down any other programs during the install and make sure you 
 have
 installation rights as well as making sure there are no anti-virus programs
 messing with you.

 ~Brad

 - Original Message -
 From: Greg Morphis [EMAIL PROTECTED]
 To: CF-Talk cf-talk@houseoffusion.com
 Sent: Monday, September 15, 2008 5:30 PM
 Subject: Re: cf 7.0.2 freezes on install



 
 I finally cancelled after nearly 3 hours...

   

 
   

 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312759
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 7.0.2 freezes on install

2008-09-18 Thread Azadi Saryev
re-download cf mx 7 installer as Brad had suggested. the one you have is
probably corrupt.

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/



Greg Morphis wrote:
 I left it trying to install all last night and nada.. after 15 hours,
 still nothing..
 I think it may have to do with the installer..

 For fun I ran the CF 8 installer and the install screen looks
 different.. Buttons!
 In the CF 7 installer  the buttons are labels and there aren't any
 radio buttons..
 So I wonder if it's even registering the button click at the end to
 initiate the install
 Here's some screen shots..
 http://img140.imageshack.us/my.php?image=ss1od6.jpg
 http://img140.imageshack.us/my.php?image=ss2dn9.jpg
 http://img140.imageshack.us/my.php?image=ss3hc5.jpg
 http://img140.imageshack.us/my.php?image=ss4ri9.jpg

 So what the hell? Any Adobe guys reading the forums that might have 
 suggestions?
 CF 8 is installing fine but our dev and prod server is CF 7.0.2. I
 really need to get 7.0.2 installed.



 On Tue, Sep 16, 2008 at 7:51 AM, Greg Morphis [EMAIL PROTECTED] wrote:
   
  I tried 3 different versions, they all did the same. I'll get with
 the LAN people tomorrow and see what's up.

 On Tue, Sep 16, 2008 at 3:47 AM, Azadi Saryev [EMAIL PROTECTED] wrote:
 
 + make sure windows firewall (or any other firewall you may be using) is
 turned off or at least not blocking ports required by installation
 (there is a list of those somewhere on abode website... i prefer to just
 turn firewalls off).

 Azadi Saryev
 Sabai-dee.com
 http://www.sabai-dee.com/



 Brad Wood wrote:
   
 For starters, can you re-download the installation (make sure you have the
 correct 32 bit or 64 bit version) and verify the file size to ensure you
 downloaded the entire file.
 Also, shut down any other programs during the install and make sure you 
 have
 installation rights as well as making sure there are no anti-virus programs
 messing with you.

 ~Brad

 - Original Message -
 From: Greg Morphis [EMAIL PROTECTED]
 To: CF-Talk cf-talk@houseoffusion.com
 Sent: Monday, September 15, 2008 5:30 PM
 Subject: Re: cf 7.0.2 freezes on install



 
 I finally cancelled after nearly 3 hours...
   

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

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


Re: Empty error message in a query of queries

2008-09-18 Thread Brent Shaub
Thanks for the replies Carl and Brad.

Turns out you're both on the right track.  The query is the same as it loops 
over various databases and appends the results using the QofQ.  There is no 
chance of the records being the same since they are in different databases and 
one of the columns is the database name.  The union all seems like a perfect. 
 It worked immediately.  I never knew about this option.  Thank you, Brad.  

Carl, there were 45 columns in the query and not having to specify them all was 
the solution I opted for.  Detailing their types may have worked just as well.

Thanks again for your help.
Brent 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312761
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 7.0.2 freezes on install

2008-09-18 Thread Greg Morphis
I downloaded 3 versions.. one from Adobe, one from FigLeaf and one we
had that all the other developers use(on our dev server). I've
downloaded it on this laptop (the new one), I've downloaded 1 from
another laptop (my old one and moved it over). The only thing I havent
done was download it on my home PC or laptop and transfer it over.




On Thu, Sep 18, 2008 at 8:58 AM, Azadi Saryev [EMAIL PROTECTED] wrote:
 re-download cf mx 7 installer as Brad had suggested. the one you have is
 probably corrupt.

 Azadi Saryev
 Sabai-dee.com
 http://www.sabai-dee.com/



 Greg Morphis wrote:
 I left it trying to install all last night and nada.. after 15 hours,
 still nothing..
 I think it may have to do with the installer..

 For fun I ran the CF 8 installer and the install screen looks
 different.. Buttons!
 In the CF 7 installer  the buttons are labels and there aren't any
 radio buttons..
 So I wonder if it's even registering the button click at the end to
 initiate the install
 Here's some screen shots..
 http://img140.imageshack.us/my.php?image=ss1od6.jpg
 http://img140.imageshack.us/my.php?image=ss2dn9.jpg
 http://img140.imageshack.us/my.php?image=ss3hc5.jpg
 http://img140.imageshack.us/my.php?image=ss4ri9.jpg

 So what the hell? Any Adobe guys reading the forums that might have 
 suggestions?
 CF 8 is installing fine but our dev and prod server is CF 7.0.2. I
 really need to get 7.0.2 installed.



 On Tue, Sep 16, 2008 at 7:51 AM, Greg Morphis [EMAIL PROTECTED] wrote:

  I tried 3 different versions, they all did the same. I'll get with
 the LAN people tomorrow and see what's up.

 On Tue, Sep 16, 2008 at 3:47 AM, Azadi Saryev [EMAIL PROTECTED] wrote:

 + make sure windows firewall (or any other firewall you may be using) is
 turned off or at least not blocking ports required by installation
 (there is a list of those somewhere on abode website... i prefer to just
 turn firewalls off).

 Azadi Saryev
 Sabai-dee.com
 http://www.sabai-dee.com/



 Brad Wood wrote:

 For starters, can you re-download the installation (make sure you have the
 correct 32 bit or 64 bit version) and verify the file size to ensure you
 downloaded the entire file.
 Also, shut down any other programs during the install and make sure you 
 have
 installation rights as well as making sure there are no anti-virus 
 programs
 messing with you.

 ~Brad

 - Original Message -
 From: Greg Morphis [EMAIL PROTECTED]
 To: CF-Talk cf-talk@houseoffusion.com
 Sent: Monday, September 15, 2008 5:30 PM
 Subject: Re: cf 7.0.2 freezes on install




 I finally cancelled after nearly 3 hours...


 

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

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


Re: CF8 and Crystal Reports v2008 or v8.5

2008-09-18 Thread Jim Gabler
No one?  Just to add a little more info, the full install (all custom features) 
are done on my desktop while the CRPE32.dll is installed on the server in the 
System32 folder and is registered.  As far as I know from searching the web and 
looking at Adobe's/Macromedia's technical issues articles, that dll is all that 
is needed on the server for this to work. 

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

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


Re: Nested sets under load

2008-09-18 Thread Brad Wood
 What is going to happen is event type {a} happens (lets say it's a
 sale).  That triggers a default action plan of umpteen things that
 have to follow based on that event, documents that have to be filed,
 people notified, approvals gained etc, then the the default plan has
 to be modified to allow for the specifics of this particular
 transaction.

 So the event has to trigger the generation of a whole heirarchy of
 maybe up to 50 things that have to happen, some of which rely on
 previous things being done


I have helped build a project management system similar to what you 
describe.  Each company's products had a flow defined like a tree of 
actions and decision processes that all got fired off in order as they 
completed each portion of work.  We started using a nested set model, and as 
the complexity grew (and performance dipped) we converted over to an 
adjacency list and it worked just fine like that.

~Brad 


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

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


Re: CFFILE and Ajax file uploads

2008-09-18 Thread Brent Nicholas
This is the solution in Prototype.
Original concept provided by Ben Nadel and translated to Prototype by Mahesh
---

index.htm
-

script type=text/javascript src=prototype-1.6.0.2.js/script

script type=text/javascript
Event.observe(window, 'load', function(){
Event.observe('file_upload', 'change', function(){
$('form').writeAttribute({enctype:multipart/form-data, 
method:post, action:cffile.cfm, target:RSIFrame});
$('form').insert(new Element(iframe, {id: RSIFrame, name: 
RSIFrame, style: width: 0px; height: 0px; border: 0px;, src: 
blank.html}));
$('form').submit();
});
});

function showResult(result){
$('file_upload').remove();
$('upload_update').insert(new Element(a, {href: http://localhost/upload/; + 
result}).update(Uploaded Image));
}
/script

form id=form
input name=file_upload id=file_upload type=file size=60 /
span id=upload_update/span
/form

For the above script to work across browsers, do not set the form enctype in 
the prototype writeAttribute, instead add it to the form, as IE will not do the 
upload, if the form is set with the encType through JS.

-
---end---

cffile.cfm---
-

cffile action=upload filefield=file_upload 
destination=d:/inetpub/wwwroot/ nameconflict=MAKEUNIQUE

script type=text/javascript
cfoutput
window.parent.showResult('#file.serverfile#');
alert('#file.serverfile#');
/cfoutput
/script

-
---end--- 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312765
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 7.0.2 freezes on install

2008-09-18 Thread Greg Morphis
The silent install works, thanks Ryan!

On Thu, Sep 18, 2008 at 9:08 AM, Greg Morphis [EMAIL PROTECTED] wrote:
 I downloaded 3 versions.. one from Adobe, one from FigLeaf and one we
 had that all the other developers use(on our dev server). I've
 downloaded it on this laptop (the new one), I've downloaded 1 from
 another laptop (my old one and moved it over). The only thing I havent
 done was download it on my home PC or laptop and transfer it over.




 On Thu, Sep 18, 2008 at 8:58 AM, Azadi Saryev [EMAIL PROTECTED] wrote:
 re-download cf mx 7 installer as Brad had suggested. the one you have is
 probably corrupt.

 Azadi Saryev
 Sabai-dee.com
 http://www.sabai-dee.com/



 Greg Morphis wrote:
 I left it trying to install all last night and nada.. after 15 hours,
 still nothing..
 I think it may have to do with the installer..

 For fun I ran the CF 8 installer and the install screen looks
 different.. Buttons!
 In the CF 7 installer  the buttons are labels and there aren't any
 radio buttons..
 So I wonder if it's even registering the button click at the end to
 initiate the install
 Here's some screen shots..
 http://img140.imageshack.us/my.php?image=ss1od6.jpg
 http://img140.imageshack.us/my.php?image=ss2dn9.jpg
 http://img140.imageshack.us/my.php?image=ss3hc5.jpg
 http://img140.imageshack.us/my.php?image=ss4ri9.jpg

 So what the hell? Any Adobe guys reading the forums that might have 
 suggestions?
 CF 8 is installing fine but our dev and prod server is CF 7.0.2. I
 really need to get 7.0.2 installed.



 On Tue, Sep 16, 2008 at 7:51 AM, Greg Morphis [EMAIL PROTECTED] wrote:

  I tried 3 different versions, they all did the same. I'll get with
 the LAN people tomorrow and see what's up.

 On Tue, Sep 16, 2008 at 3:47 AM, Azadi Saryev [EMAIL PROTECTED] wrote:

 + make sure windows firewall (or any other firewall you may be using) is
 turned off or at least not blocking ports required by installation
 (there is a list of those somewhere on abode website... i prefer to just
 turn firewalls off).

 Azadi Saryev
 Sabai-dee.com
 http://www.sabai-dee.com/



 Brad Wood wrote:

 For starters, can you re-download the installation (make sure you have 
 the
 correct 32 bit or 64 bit version) and verify the file size to ensure you
 downloaded the entire file.
 Also, shut down any other programs during the install and make sure you 
 have
 installation rights as well as making sure there are no anti-virus 
 programs
 messing with you.

 ~Brad

 - Original Message -
 From: Greg Morphis [EMAIL PROTECTED]
 To: CF-Talk cf-talk@houseoffusion.com
 Sent: Monday, September 15, 2008 5:30 PM
 Subject: Re: cf 7.0.2 freezes on install




 I finally cancelled after nearly 3 hours...


 

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

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


coldfusion 8 application server not starting automatically

2008-09-18 Thread Richard White
hi

we have a computer where the coldfusion 8 application server is not starting 
automatically but the start type is set to automatic. we have done searches on 
the web and found somewhere that suggested it may be timing out, and also gave 
us instructions on how to increase the timeout but this didnt work

has anyone come across this before and have a solutions?

thanks

richard 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312767
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 7.0.2 freezes on install

2008-09-18 Thread Greg Morphis
Doh Running in Windows 2000 compatibility works too.. not sure why
it doesnt work normally.. must be a problem with the image they use to
set up the laptops...

Anyways.. this is resolved.. thanks!

On Thu, Sep 18, 2008 at 10:02 AM, Greg Morphis [EMAIL PROTECTED] wrote:
 The silent install works, thanks Ryan!

 On Thu, Sep 18, 2008 at 9:08 AM, Greg Morphis [EMAIL PROTECTED] wrote:
 I downloaded 3 versions.. one from Adobe, one from FigLeaf and one we
 had that all the other developers use(on our dev server). I've
 downloaded it on this laptop (the new one), I've downloaded 1 from
 another laptop (my old one and moved it over). The only thing I havent
 done was download it on my home PC or laptop and transfer it over.




 On Thu, Sep 18, 2008 at 8:58 AM, Azadi Saryev [EMAIL PROTECTED] wrote:
 re-download cf mx 7 installer as Brad had suggested. the one you have is
 probably corrupt.

 Azadi Saryev
 Sabai-dee.com
 http://www.sabai-dee.com/



 Greg Morphis wrote:
 I left it trying to install all last night and nada.. after 15 hours,
 still nothing..
 I think it may have to do with the installer..

 For fun I ran the CF 8 installer and the install screen looks
 different.. Buttons!
 In the CF 7 installer  the buttons are labels and there aren't any
 radio buttons..
 So I wonder if it's even registering the button click at the end to
 initiate the install
 Here's some screen shots..
 http://img140.imageshack.us/my.php?image=ss1od6.jpg
 http://img140.imageshack.us/my.php?image=ss2dn9.jpg
 http://img140.imageshack.us/my.php?image=ss3hc5.jpg
 http://img140.imageshack.us/my.php?image=ss4ri9.jpg

 So what the hell? Any Adobe guys reading the forums that might have 
 suggestions?
 CF 8 is installing fine but our dev and prod server is CF 7.0.2. I
 really need to get 7.0.2 installed.



 On Tue, Sep 16, 2008 at 7:51 AM, Greg Morphis [EMAIL PROTECTED] wrote:

  I tried 3 different versions, they all did the same. I'll get with
 the LAN people tomorrow and see what's up.

 On Tue, Sep 16, 2008 at 3:47 AM, Azadi Saryev [EMAIL PROTECTED] wrote:

 + make sure windows firewall (or any other firewall you may be using) is
 turned off or at least not blocking ports required by installation
 (there is a list of those somewhere on abode website... i prefer to just
 turn firewalls off).

 Azadi Saryev
 Sabai-dee.com
 http://www.sabai-dee.com/



 Brad Wood wrote:

 For starters, can you re-download the installation (make sure you have 
 the
 correct 32 bit or 64 bit version) and verify the file size to ensure you
 downloaded the entire file.
 Also, shut down any other programs during the install and make sure you 
 have
 installation rights as well as making sure there are no anti-virus 
 programs
 messing with you.

 ~Brad

 - Original Message -
 From: Greg Morphis [EMAIL PROTECTED]
 To: CF-Talk cf-talk@houseoffusion.com
 Sent: Monday, September 15, 2008 5:30 PM
 Subject: Re: cf 7.0.2 freezes on install




 I finally cancelled after nearly 3 hours...


 

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

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


Re: Trouble getting this loop to work ...

2008-09-18 Thread John Seelye
Thanks for the reply.

ROL.getcategorydetailnames()

Is actually a PostGRESQL function that is called within the cfquery ...

The function only accepts one input (an integer) per iteration, so in my form 
that calls this page when someone selects more than one category I need the 
entire query to execute (and give output) for each category id ... 
(#mcategories#).

The way I have it written it only gives the output for the last category id 
passed to it.

The output I am looking for would look something like ...

Category 1 - thing 1, thing 2, thing 3, thing 4
Category 2 - thing 11, thing 12, thing 13, thing 14
Category 3 - thing 20, thing 21 
and so on ...

I need to get the categories from user input and the things from the database 
with that function.

The function works like a charm with just 1 category passed to it.


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

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


URL caused display problem for an IFRAME in editing mode

2008-09-18 Thread Don L
Hi, 

I have an IFRAME like the following and its content is html text 
sometimes with some URLs embedded, when an event trigger is fired, this 
frame is for editing. 

User Agent: IE7 
on XP OS. 

iframe id=textID src=somefile.htm 
onload=document.frames['someframeID'].document.designMode='on'; 
contenteditable=true style=width:420px; height:300px{display html 
document here}/iframebr/ 

Problem: if a URL starts with http://bla.bla.com/ something, the data 
would be loaded correctly into the frame, HOWEVER, a shadow copy of 
the same data would show up right beneath the frame?  How come?  Most 
importantly how to fix it? 

And if memory serves I think someone posted a similar problem before, not sure 
here or elsewhere.

Thanks. 




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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312770
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 application server not starting automatically

2008-09-18 Thread brad
1) check your windows system logs to see if it tired to start the
service
2) Check your ColdFusion out logs to what happened.
3) Can you start the service manually?
 
~Brad
 
 Original Message 
Subject: coldfusion 8 application server not starting automatically
From: Richard White [EMAIL PROTECTED]
Date: Thu, September 18, 2008 10:04 am
To: CF-Talk cf-talk@houseoffusion.com

hi

we have a computer where the coldfusion 8 application server is not
starting automatically but the start type is set to automatic. we have
done searches on the web and found somewhere that suggested it may be
timing out, and also gave us instructions on how to increase the timeout
but this didnt work



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

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


Re: Trouble getting this loop to work ...

2008-09-18 Thread Gert Franz
Well of course, you overwrite the query every time you iterate to the 
next value. The query always has the same name, so CFMX overwrites it. 
Nevertheless it is a bad solution. You should do something like this:
cfquery name=getCateories...   
select * from categories where category in ('#mcategories#')
/cfquery

You could of course have your form, where the user selects the 
categories store the categoryID's and then do an in over these categoryID's

Greetings from Switzerland
Gert Franz
Railo Technologies GmbH
[EMAIL PROTECTED]
www.railo.ch

Join our Mailing List
german:http://de.groups.yahoo.com/group/railo/
english:   http://groups.yahoo.com/group/railo_talk/
linked in: http://www.linkedin.com/e/gis/71368/0CF7D323BBC1



John Seelye schrieb:
 Thanks for the reply.

 ROL.getcategorydetailnames()

 Is actually a PostGRESQL function that is called within the cfquery ...

 The function only accepts one input (an integer) per iteration, so in my form 
 that calls this page when someone selects more than one category I need the 
 entire query to execute (and give output) for each category id ... 
 (#mcategories#).

 The way I have it written it only gives the output for the last category id 
 passed to it.

 The output I am looking for would look something like ...

 Category 1 - thing 1, thing 2, thing 3, thing 4
 Category 2 - thing 11, thing 12, thing 13, thing 14
 Category 3 - thing 20, thing 21 
 and so on ...

 I need to get the categories from user input and the things from the 
 database with that function.

 The function works like a charm with just 1 category passed to it.


 

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

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


JRun Servlet Error After Reinstall of Developer Edition (CFMX7)

2008-09-18 Thread Chris Montgomery
Ok, I feel like an idiot and must be missing something obvious.
I had to reinstall my developer edition of the CF server on my local box 
(Win XP SP2). Since doing so, I cannot get CF pages to work. When I try 
to load a page I am receiving a 404 JRun Servlet Error. The sites on my 
dev box are under the d:\webapps\myapps folder. I have this mapped in CF 
Admin as /myapps. I configured CF during install to run the built-in web 
server.

So, for example, when I start the CF server and enter 
http://localhost:8500/myapps/mysite; in the browser address bar, this 
results in a 404 /myapps/mysite error. If I add index.cfm to the path, 
I get a 404 File not found: /myapps/mysite/index.cfm error.

What am I overlooking?

Separately, when attempting to create a mapping, clicking on the 
Browser Server form button to select a folder path brings up the 
Select Directory on the Server window to select a folder but after a 
few seconds it throws up a Server Error message (IO error on server 
communication). I didn't encounter this problem before reinstalling the 
CF developer edition on my box. Any ideas?

Thanks.

-- 
Best regards,

Chris Montgomery

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

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


Re: JRun issues on Vista 64 bit?

2008-09-18 Thread Jeff Chastain
I have done a reinstall several times and the issue appears to be specifically 
related to the MSSQL drivers.  I pulled the latest JDBC drivers from Microsoft 
and was able to use those to setup a MSSQL data source, so the issue appears to 
be in the drivers.  I posted all of the details of my fix here ... 
http://www.alagad.com/go/blog-entry/mssql-driver-issue-with-cf-8-0-1 

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

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


difference between ERROR and EXCEPTION

2008-09-18 Thread sandeep saini
HI

What is difference between ERROR and EXCEPTION?

thanks 

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

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


Re: difference between ERROR and EXCEPTION

2008-09-18 Thread Barney Boisvert
With ColdFusion, not really anything.  In Java, an error is
unrecoveable (e.g. out of memory), while an exception is recoverable
(e.g. database connection failed).  In other words, if you get an
error, chances are good that whatever is happening is just going to
ungracefully terminate (JVM dies), but if you get an exception you can
control what happens (retry the connection, show the user an error,
queue for later reattempt, etc.).

cheers,
barneyb

On Thu, Sep 18, 2008 at 11:10 AM, sandeep saini [EMAIL PROTECTED] wrote:
 HI

 What is difference between ERROR and EXCEPTION?

 thanks

 

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

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


Re: JRun issues on Vista 64 bit?

2008-09-18 Thread Jochem van Dieten
Jeff Chastain wrote:
 I just got a new workstation running Windows Vista 64 and I am running into
 some issues with JRun.  I pulled the latest release of CF off of the Adobe
 site this morning, making sure it was for Windows 64-bit.  Everything
 installed right with no issues, but whenever I attempt to do anything with a
 DSN that points to SQL Server 2005 (also 64-bit), JRun crashes.

Do you mean the actual jrun.exe process terminates? If so, is there a 
*pid*.log file somewhere?

Jochem

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

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


RE: Problem loading data from text file...

2008-09-18 Thread Rick Faircloth
Sounds like a good idea, Eric...if I could just figure out
how to handle the data!

I read the file with this code:

cffileaction   = read
   file = e:\active_photos.txt
   variable = active_photos /

From here, I've tried listtoarray, etc., but I can't get the
info in the text file into an array properly.

The text file is a list of photos.

The first line is column headings; Photo Filename, Photo Label.

I can use listtoarray with chr(10)chr(13) as the delimiters,
but that gives me each row as an element.

I need the photo filename as array(1,1) and photo label as array(1,2).

The problem I'm running into is that the photo filename and the photo label
are tab delimited...chr(9)...and each row is delimited by chr(10)chr(13).

I can't figure out how to use both delimiters to parse the rows and the row
elements.

Suggestions?

Thanks,

Rick


 -Original Message-
 From: Eric Roberts [mailto:[EMAIL PROTECTED]
 Sent: Thursday, September 18, 2008 2:26 AM
 To: CF-Talk
 Subject: RE: Problem loading data from text file...
 
 Why not use cffile and then load it into the db...then you could easily
 process the data to be however you want it?
 
 Eric
 
 /*-Original Message-
 /*From: Rick Faircloth [mailto:[EMAIL PROTECTED]
 /*Sent: Wednesday, September 17, 2008 7:40 PM
 /*To: CF-Talk
 /*Subject: Problem loading data from text file...
 /*
 /*I'm using this query to load data into a table from a text file:
 /*
 /*cfquery name=load_data datasource=c21ar
 /*
 /*load data infile
 /*'e:/inetpub/webroot/real_estate_data/hmls/data/#today#_idx_custom/active_p
 /*hotos.txt'
 /*into table hmls_active_photos_temp
 /*lines terminated by '\r\n'
 /*ignore 1 lines
 /*
 /*/cfquery
 /*
 /*It runs fine except for the fact that at the end of each day's new
 /*active_photos.txt file,
 /*there are a couple of blanks lines, like the ENTER key has been struck a
 /*couple of times
 /*after the last line of data.
 /*
 /*The load data infile command is trying to read these lines and throws an
 /*error because of the
 /*empty lines.
 /*
 /*Is there some way to cause this query not to process, or to skip, empty
 /*lines?  The empty lines
 /*are always at the end of the file and prevent me from automating the
 /*loading of data.
 /*
 /*Suggestions?
 /*
 /*Thanks,
 /*
 /*Rick
 /*
 /*
 /*
 
 

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

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


Want to Learn Fuse-Box

2008-09-18 Thread sandeep saini
Dear all,

I am a certified CF Programmer. Since long time I am planning to learn Fuse 
Box.But It looks something strange to me and I quit. 
Please let me now a good resource and method to make FuseBox Learing an 
exciting experience.

Cheers
sandy 

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

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


screen capture software

2008-09-18 Thread Richard White
hi,

we want to be creating tutorial movies by capturing what we are doing on screen 
and being able to discuss what we are doing. 

we have got some software at present called instant demo which allows us to do 
this and then outputs a flash movie, which is exactly what we want. 

however the product we have was relatively cheap and produces very poor quality 
sound and visuals even with the quality up as high as it can go.

can anyone recommend similar applications that produce 'very high quality' 
visual and sound? 

thanks for your recommendations

richard 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312780
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 application server not starting automatically

2008-09-18 Thread Richard White
thanks for your response brad, we can start it manually but it is just a bit of 
a pain to do this! looked into the log files and it didn't say anything at all.

thanks

richard

1) check your windows system logs to see if it tired to start the
service
2) Check your ColdFusion out logs to what happened.
3) Can you start the service manually?
 
~Brad
 
hi

we have a computer where the coldfusion 8 application server is not
starting automatically but the start type is set to automatic. we have
done searches on the web and found somewhere that suggested it may be
timing out, and also gave us instructions on how to increase the timeout
but this didnt work 

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

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


OT Flash help

2008-09-18 Thread Huff, Jerome P.
 I have been tasked to create a project like the link below in flash
however I am not familiar with flash but would love to learn. We have a
project we are interested in creating to look like the link below that
was created in flash and I wanted to know who may know how to create the
3-D object rotating as is in the link below Discover the new panamera
We want that exact page but with our information in it rather than the
Porche dealership where we found this create piece. Does anyone know how
to create this piece and could give me a hand? It has multiple pages,
pop-outs ect. I know there must be a lot of scripting involved and
programming, could anyone give me more information as to how this was
created and what is needed?
When you click on the link click skip intro then click on the left link
and let the video play, when the video stops playing you will see the
3-d object full of information which is what we were thinking of
creating ourselves from your expertise using our information to replace
all of the Porche's info.
Discover the new Panamera.
http://www.porsche.com/microsite/panamera/usa.aspx 

Jerome Huff
(540)469-2875



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

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


RE: screen capture software

2008-09-18 Thread Dawson, Michael
Take a look at Adobe Captivate.

Mike 

-Original Message-
From: Richard White [mailto:[EMAIL PROTECTED] 
Sent: Thursday, September 18, 2008 1:37 PM
To: CF-Talk
Subject: screen capture software

hi,

we want to be creating tutorial movies by capturing what we are doing on
screen and being able to discuss what we are doing. 

we have got some software at present called instant demo which allows us
to do this and then outputs a flash movie, which is exactly what we
want. 

however the product we have was relatively cheap and produces very poor
quality sound and visuals even with the quality up as high as it can go.

can anyone recommend similar applications that produce 'very high
quality' visual and sound? 

thanks for your recommendations

richard 

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

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


Re: Want to Learn Fuse-Box

2008-09-18 Thread Greg Luce
Sandy, I have taken the classes at the conference
http://www.frameworksconference.com/ but also get on the Fusebox list and
try out some of the sample apps...

Greg

On Thu, Sep 18, 2008 at 2:27 PM, sandeep saini [EMAIL PROTECTED]wrote:

 Dear all,

 I am a certified CF Programmer. Since long time I am planning to learn Fuse
 Box.But It looks something strange to me and I quit.
 Please let me now a good resource and method to make FuseBox Learing an
 exciting experience.

 Cheers
 sandy

 

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

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


RE: screen capture software

2008-09-18 Thread Adam Churvis
Camtasia Studio rocks (www.techsmith.com).  Combine it with anything from a
Logitech noise-cancelling USB headset on the low end to a complete mixer
board and studio mic on the high end, and you've got some serious quality
screencasts.  Also supports a good Logitech camera so you can do PIP right
on top of your screen action.

Captivate eats nasty ass.

Respectfully,

Adam Phillip Churvis 
President
Productivity Enhancement



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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312785
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 application server not starting automatically

2008-09-18 Thread brad
Hmm, if I had to guess, I would say you haven't checked the right logs.
 
First right click on My Computer and click manage.
 
Expand Services and Applications and click Services.  Check that
ColdFusion 8 Application Server startup type is Automatic.
 
Now restart your server.
 
To view the windows log, right click on My Computer again and click
manage again.
 
This time expand Event Viewer and click on System.
 
There should be a bunch of recent Information entries from when
Windows booted up from the Service Control Manager.   Go through them
and you will see stuff like The Terminal Services service was
successfully sent a start control..  Look for ColdFusion.  
 
Also check the Application logs under Event Viewer for any errors that
ColdFusion may have thrown while starting up.
 
Now, as to the ColdFusion logs. Assuming a stand alone install with
default folder locations, open up the following log file:
C:\ColdFusion8\runtime\logs\coldfusion-out.log
 
If ColdFusion did try to start, there should be something in this log
file.
 
~Brad
 
 
 
 Original Message 
Subject: Re: coldfusion 8 application server not starting automatically
From: Richard White [EMAIL PROTECTED]
Date: Thu, September 18, 2008 1:37 pm
To: CF-Talk cf-talk@houseoffusion.com

thanks for your response brad, we can start it manually but it is just a
bit of a pain to do this! looked into the log files and it didn't say
anything at all.



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

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


Re: OT Flash help

2008-09-18 Thread Sherif Abdou
Papervision3D and just create 5 TileList(Assuming There is a similar class 
like that in Flash) with say 10 Children or you can just create a container 
layout the children same way and then just use PaperVision3D to play around 
with the x,y,z,rotationX,rotationZ,rotationY.
--
Sherif Abdou
http://VadexFX.com
http://Sherifabdou.com
- Original Message - 
From: Huff, Jerome P. [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Thursday, September 18, 2008 1:40 PM
Subject: OT Flash help


 I have been tasked to create a project like the link below in flash
 however I am not familiar with flash but would love to learn. We have a
 project we are interested in creating to look like the link below that
 was created in flash and I wanted to know who may know how to create the
 3-D object rotating as is in the link below Discover the new panamera
 We want that exact page but with our information in it rather than the
 Porche dealership where we found this create piece. Does anyone know how
 to create this piece and could give me a hand? It has multiple pages,
 pop-outs ect. I know there must be a lot of scripting involved and
 programming, could anyone give me more information as to how this was
 created and what is needed?
 When you click on the link click skip intro then click on the left link
 and let the video play, when the video stops playing you will see the
 3-d object full of information which is what we were thinking of
 creating ourselves from your expertise using our information to replace
 all of the Porche's info.
 Discover the new Panamera.
 http://www.porsche.com/microsite/panamera/usa.aspx

 Jerome Huff
 (540)469-2875



 

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

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


Re: Want to Learn Fuse-Box

2008-09-18 Thread Claude Schneegans
 But It looks something strange to me

Then you must be a sane and well-balanced person ;-)

  and I quit.

Believe me, that was your best decision ;-)

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

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


How to parse a text file...

2008-09-18 Thread Rick Faircloth
Hi, all...

I've got a text file that I'm trying to read with cffile that has
data structured like this:

96201_01.jpgMain View
96202_01.jpgAlternate View 01
etc...

This is a list of photos with a description of each photo.
There is a tab between the photo filename and the description,
then a return...chr(10)chr(13)...at the end of each pair.

I've tried several methods to get this code into an array with
the filename as the first array element and the description as the
second array element, but so far it's not working.

I read the file with this code:

cffileaction   = read
   file = e:\active_photos.txt
   variable = active_photos /

From here, I've tried listtoarray, etc., but I can't get the
info in the text file into an array properly.

I can use listtoarray with chr(10)chr(13) as the delimiters,
but that gives me each row as an element.

I can't figure out how to use both delimiters to parse the rows and the row
elements.

I was using the MySQL function, load data infile, to load the data into a 
table,
but some of the text files have blank lines, like the enter key was struck a 
couple
of times, and that throws an error with load data infile.

Suggestions?

Thanks,

Rick


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

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


Re: Want to Learn Fuse-Box

2008-09-18 Thread sandeep saini
:-)

hilarious  

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

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


Re: How to parse a text file...

2008-09-18 Thread Barney Boisvert
Best bet would be to do listToArray() with newline as the delimiter,
and then loop over the array and split each item on a tab.

Though if you've already got LOAD DATA INFILE set up, why not just set
up some REReplaces to sanitize the input file before import.  Do
things like replace sequential newlines with a single newline and
such.

cheers,
barneyb

On Thu, Sep 18, 2008 at 2:00 PM, Rick Faircloth
[EMAIL PROTECTED] wrote:
 Hi, all...

 I've got a text file that I'm trying to read with cffile that has
 data structured like this:

 96201_01.jpgMain View
 96202_01.jpgAlternate View 01
 etc...

 This is a list of photos with a description of each photo.
 There is a tab between the photo filename and the description,
 then a return...chr(10)chr(13)...at the end of each pair.

 I've tried several methods to get this code into an array with
 the filename as the first array element and the description as the
 second array element, but so far it's not working.

 I read the file with this code:

 cffileaction   = read
   file = e:\active_photos.txt
   variable = active_photos /

 From here, I've tried listtoarray, etc., but I can't get the
 info in the text file into an array properly.

 I can use listtoarray with chr(10)chr(13) as the delimiters,
 but that gives me each row as an element.

 I can't figure out how to use both delimiters to parse the rows and the row
 elements.

 I was using the MySQL function, load data infile, to load the data into a 
 table,
 but some of the text files have blank lines, like the enter key was struck 
 a couple
 of times, and that throws an error with load data infile.

 Suggestions?

 Thanks,

 Rick


-- 
Barney Boisvert
[EMAIL PROTECTED]
http://www.barneyb.com/

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

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


Totally inexplicable server crash

2008-09-18 Thread Josh Nathanson
A little history:  we moved our ecommerce site to a new CF8 installation a 
couple of months ago.  Prior to that, we had been on CF7 and never had any 
problems.  Everything went smoothly during the move.  It's on Linux, 64-Bit 
CF dedicated box.  We have two servers, one for the db (MySQL 5) and one for 
CF/Apache.  We average about 1 to 3 requests per second, around 500 
concurrent sessions and our Session and Application scopes are very light.

Last Saturday, during a time of not too heavy traffic, CF apparently crashed 
and any CF requests were returned with an Apache 503 error Request timed 
out.  There was nothing in any of the logs to indicate any problems prior 
to the crash:  no error messages, no indication of any odd or heavy traffic 
before CF went down.  We restarted the server and everything seemed fine.

Again this morning, same thing -- sudden crash and any CF requests returned 
with a 503 error.  Again we restarted the server and everything seems fine 
again.

We have been running the Server Monitor, and I've seen mixed messages as to 
whether that might be related to the problem.  Some folks seem to say don't 
run it in production, others say it's ok to do that.

Anyway, I'm just fishing for any leads or suggestions as to what we might 
need to look for so we can nip this issue in the bud.

-- Josh 


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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312792
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 parse a text file...

2008-09-18 Thread Rick Faircloth
Thanks for the suggestions!

Rick

 -Original Message-
 From: Barney Boisvert [mailto:[EMAIL PROTECTED]
 Sent: Thursday, September 18, 2008 5:04 PM
 To: CF-Talk
 Subject: Re: How to parse a text file...
 
 Best bet would be to do listToArray() with newline as the delimiter,
 and then loop over the array and split each item on a tab.
 
 Though if you've already got LOAD DATA INFILE set up, why not just set
 up some REReplaces to sanitize the input file before import.  Do
 things like replace sequential newlines with a single newline and
 such.
 
 cheers,
 barneyb
 
 On Thu, Sep 18, 2008 at 2:00 PM, Rick Faircloth
 [EMAIL PROTECTED] wrote:
  Hi, all...
 
  I've got a text file that I'm trying to read with cffile that has
  data structured like this:
 
  96201_01.jpgMain View
  96202_01.jpgAlternate View 01
  etc...
 
  This is a list of photos with a description of each photo.
  There is a tab between the photo filename and the description,
  then a return...chr(10)chr(13)...at the end of each pair.
 
  I've tried several methods to get this code into an array with
  the filename as the first array element and the description as the
  second array element, but so far it's not working.
 
  I read the file with this code:
 
  cffileaction   = read
file = e:\active_photos.txt
variable = active_photos /
 
  From here, I've tried listtoarray, etc., but I can't get the
  info in the text file into an array properly.
 
  I can use listtoarray with chr(10)chr(13) as the delimiters,
  but that gives me each row as an element.
 
  I can't figure out how to use both delimiters to parse the rows and the row
  elements.
 
  I was using the MySQL function, load data infile, to load the data into a 
  table,
  but some of the text files have blank lines, like the enter key was 
  struck a couple
  of times, and that throws an error with load data infile.
 
  Suggestions?
 
  Thanks,
 
  Rick
 
 
 --
 Barney Boisvert
 [EMAIL PROTECTED]
 http://www.barneyb.com/
 
 

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

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


Ray Camden's Galleon - Forums

2008-09-18 Thread coldfusion . developer
Has anyone had any expereince with Galleon on a Clustered configuration?
My problem is successful logins aren't sticking.  I read in the documentation
that all you need to do is prepend the jsessionid variable to the session 
variable.
I can find a session variable being set.

Could use some friendly advice.

Thanks

D


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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312794
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 parse a text file...

2008-09-18 Thread Marcus Raphelt
Hi Rick,

depending on how large the text file is, you might consider using the 
gnu texttools (sed, awk, grep etc.) to convert the data to sql 
statements and import the result natively via mysql. This is WAY faster 
than parsing it via cf, as text file parsing is one of the things cf is 
*really* weak at (sadly).

as far as the cf part is concerned: you can use two loops for that. one 
to loop over the list of elements divided by line breaks (13/10), one 
inner loop that uses chr#9 as delimiter.

bye,
marcus

Rick Faircloth schrieb:
 Hi, all...

 I've got a text file that I'm trying to read with cffile that has
 data structured like this:

 96201_01.jpgMain View
 96202_01.jpgAlternate View 01
 etc...

   


-- 
Mit freundlichen Grüßen,
Marcus Raphelt

at.net websolutions
Mühlenbeck  Raphelt GbR
Klever Str. 60
47839 Krefeld
Tel.: 02151 / 3699732
Fax : 02151 / 3699734
Mob.: 0151 / 58113803

mailto: [EMAIL PROTECTED]
http://www.atnet-websolutions.de




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

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


Re: Totally inexplicable server crash

2008-09-18 Thread Mark Mandel
I have heard of people having various memory issues on 64bit... but
that was 64bit Windows...

How is your overall memory travelling?

Was your server before 32, or 64 bit?

Mark

On Fri, Sep 19, 2008 at 7:08 AM, Josh Nathanson [EMAIL PROTECTED] wrote:
 A little history:  we moved our ecommerce site to a new CF8 installation a
 couple of months ago.  Prior to that, we had been on CF7 and never had any
 problems.  Everything went smoothly during the move.  It's on Linux, 64-Bit
 CF dedicated box.  We have two servers, one for the db (MySQL 5) and one for
 CF/Apache.  We average about 1 to 3 requests per second, around 500
 concurrent sessions and our Session and Application scopes are very light.

 Last Saturday, during a time of not too heavy traffic, CF apparently crashed
 and any CF requests were returned with an Apache 503 error Request timed
 out.  There was nothing in any of the logs to indicate any problems prior
 to the crash:  no error messages, no indication of any odd or heavy traffic
 before CF went down.  We restarted the server and everything seemed fine.

 Again this morning, same thing -- sudden crash and any CF requests returned
 with a 503 error.  Again we restarted the server and everything seems fine
 again.

 We have been running the Server Monitor, and I've seen mixed messages as to
 whether that might be related to the problem.  Some folks seem to say don't
 run it in production, others say it's ok to do that.

 Anyway, I'm just fishing for any leads or suggestions as to what we might
 need to look for so we can nip this issue in the bud.

 -- Josh


 

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

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


Re: Ray Camden's Galleon - Forums

2008-09-18 Thread Raymond Camden
If you aren't using sticky sessions, then you would need to modify the
code to pass along the proper variables. You could do this with
urlSessionFormat, but that may a bit of a chore to do to all the
files.

On Thu, Sep 18, 2008 at 4:21 PM,  [EMAIL PROTECTED] wrote:
 Has anyone had any expereince with Galleon on a Clustered configuration?
 My problem is successful logins aren't sticking.  I read in the documentation
 that all you need to do is prepend the jsessionid variable to the session 
 variable.
 I can find a session variable being set.

 Could use some friendly advice.

 Thanks

 D


 

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

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


Re: How to parse a text file...

2008-09-18 Thread Claude Schneegans
 I've tried several methods to get this code into an array with
the filename as the first array element and the description as the
second array element

May be you don't need to go that far in creating an array.
Just create a single array the way you did it, with both the file name 
and the description in each element,
then as you loop on that array, in each iteration use list functions to 
separate the file name and
the description.

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

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


RE: How to parse a text file...

2008-09-18 Thread Rick Faircloth
Suggestions on how to replace the sequential newlines?
I tried this...

cffile action  = read
file=
e:\inetpub\webroot\real_estate_data\hmls\data\2008_0918_idx_custom\active_photos.txt
variable= active_photos /

cfset active_photos = #replace(active_photos, 
#chr(10)chr(13)##chr(10)chr(13)#, , All)#

cffile action  = write
file=
e:\inetpub\webroot\real_estate_data\hmls\data\2008_0918_idx_custom\active_photos_edited.txt
output  = #active_photos# /

That just gave me a file with the text, active_photos, and a return symbol 
after it...

Thoughts?

Rick


 -Original Message-
 From: Barney Boisvert [mailto:[EMAIL PROTECTED]
 Sent: Thursday, September 18, 2008 5:04 PM
 To: CF-Talk
 Subject: Re: How to parse a text file...
 
 Best bet would be to do listToArray() with newline as the delimiter,
 and then loop over the array and split each item on a tab.
 
 Though if you've already got LOAD DATA INFILE set up, why not just set
 up some REReplaces to sanitize the input file before import.  Do
 things like replace sequential newlines with a single newline and
 such.
 
 cheers,
 barneyb
 



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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312799
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 parse a text file...

2008-09-18 Thread C S
 cfset active_photos = #replace(active_photos, 

 That just gave me a file with the text, active_photos, and a return 
 symbol after it...

Remove the quotes from active_photos so CF knows it is a variable to be 
evaluated ;-) 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312800
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 parse a text file...

2008-09-18 Thread C S
 cfset active_photos = #replace(active_photos, 
 #chr(10)chr(13)##chr(10)chr(13)#, , All)#

Also, check Barney's suggestion:

 replace sequential newlines with a single newline and such. 


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

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


Re: Totally inexplicable server crash

2008-09-18 Thread Josh Nathanson
 How is your overall memory travelling?

 Was your server before 32, or 64 bit?


We were on 32 bit Linux before.

Not sure what you mean by memory travelling - here are some stats from the 
server monitor:

Total memory: 1.42 GB
Used memory: 900 - 1100 MB (up and down when garbage collection occurs)
Session scope: 1.175 MB
Application scope: 304K
Query cache: 20 MB

JVM:  min and max heap sizes set to 1.512 GB
JVM 
arguments: -server -Dsun.io.useCanonCaches=false -XX:MaxPermSize=256m 
-XX:+UseParallelGC 
 -Xbatch -Dcoldfusion.rootDir={application.home}/../ 
-Dcoldfusion.libPath={application.home}/../lib

One thing I don't get - we used to use SeeFusion on our CF7 installation, 
and the memory in use fluctuated at around 20% all the time.  It seems like 
now on CF8 we are consistently using 70-80% of the JVM allotment, but the 
application hasn't changed at all.

When I look at the sawtooth pattern that is shown by the memory tracker, it 
consistently goes up to 1.1 GB used and then drops down to about 800 MB used 
when garbage collection occurs, but it never goes below 800 MB used.

I guess I'm not sure what is using up 700 MB of memory when we've only got ~ 
22 MB usage in the session/app scopes and cached queries.  I know CF 8 has a 
bigger footprint, but that much bigger?

-- Josh



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

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


Yet Another URL Rewrite Question...

2008-09-18 Thread Les Mizzell
Evening,

I know how to do:
www.mysite.com/newsletters.cfm/My August Newsletter

But, the client wants to see the .cfm extension go away completely.

So, I need:
www.mysite.com/newsletters/My August Newsletter

Shared server, so needs to be done in CF.

When you request a file in a folder (newsletters) - does the 
Application.cfc run FIRST, even if the file isn't found? If so, is there 
any way to use error processing code in the Application.cfc to extract 
the variable (My August Newsletter) and call the correct page from there?

Ideas?
Links to a tutorial?

Site is running on CF7 ...

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

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


RE: Yet Another URL Rewrite Question...

2008-09-18 Thread Russ
Is it a linux shared server?  If it's running Apache, you might be able to
set up some redirect rules in .htaccess files. 

Russ

 -Original Message-
 From: Les Mizzell [mailto:[EMAIL PROTECTED]
 Sent: Thursday, September 18, 2008 7:14 PM
 To: CF-Talk
 Subject: Yet Another URL Rewrite Question...
 
 Evening,
 
 I know how to do:
 www.mysite.com/newsletters.cfm/My August Newsletter
 
 But, the client wants to see the .cfm extension go away completely.
 
 So, I need:
 www.mysite.com/newsletters/My August Newsletter
 
 Shared server, so needs to be done in CF.
 
 When you request a file in a folder (newsletters) - does the
 Application.cfc run FIRST, even if the file isn't found? If so, is there
 any way to use error processing code in the Application.cfc to extract
 the variable (My August Newsletter) and call the correct page from there?
 
 Ideas?
 Links to a tutorial?
 
 Site is running on CF7 ...
 
 

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

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


Re: Yet Another URL Rewrite Question...

2008-09-18 Thread Phillip M. Vector
Well, besides the spaces in the pages (Not allowed to have spaces in a 
URL)..

Also, you don't put a / after the .cfm...

I'd say just make a directory of MyAugustNewsletter and stick an 
index.cfm in there. Problem solved.

Les Mizzell wrote:
 Evening,
 
 I know how to do:
 www.mysite.com/newsletters.cfm/My August Newsletter
 
 But, the client wants to see the .cfm extension go away completely.
 
 So, I need:
 www.mysite.com/newsletters/My August Newsletter
 
 Shared server, so needs to be done in CF.
 
 When you request a file in a folder (newsletters) - does the 
 Application.cfc run FIRST, even if the file isn't found? If so, is there 
 any way to use error processing code in the Application.cfc to extract 
 the variable (My August Newsletter) and call the correct page from there?
 
 Ideas?
 Links to a tutorial?
 
 Site is running on CF7 ...
 
 

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

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


RE: How to parse a text file...

2008-09-18 Thread Rick Faircloth
Well, I've tried loops and inner loops, etc, but nothing is giving
me the results I need.

I need to get rid of the column headers in the first line,
and then get rid of any linefeeds after the last piece of data.

This seemed fairly straightforward when I started...

Any more clues, anyone?

Rick


 -Original Message-
 From: Rick Faircloth [mailto:[EMAIL PROTECTED]
 Sent: Thursday, September 18, 2008 5:50 PM
 To: CF-Talk
 Subject: RE: How to parse a text file...
 
 Suggestions on how to replace the sequential newlines?
 I tried this...
 
 cffile   action  = read
   file=
 e:\inetpub\webroot\real_estate_data\hmls\data\2008_0918_idx_custom\active_photos.txt
   variable= active_photos /
 
 cfset active_photos = #replace(active_photos, 
 #chr(10)chr(13)##chr(10)chr(13)#, ,
All)#
 
 cffile   action  = write
   file=
 e:\inetpub\webroot\real_estate_data\hmls\data\2008_0918_idx_custom\active_photos_edited.txt
   output  = #active_photos# /
 
 That just gave me a file with the text, active_photos, and a return symbol 
 after it...
 
 Thoughts?
 
 Rick



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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312806
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 parse a text file...

2008-09-18 Thread Justin D. Scott
 I need to get rid of the column headers in the first line,
 and then get rid of any linefeeds after the last piece of data.
 This seemed fairly straightforward when I started...

and it should still be fairly straightforward:

cfset data = listRest(data, chr(10)) /
cfset data = trim(data) /


-Justin Scott, http://www.tlson.com/


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

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


RE: screen capture software

2008-09-18 Thread Dave Watts
 Camtasia Studio rocks (www.techsmith.com).  Combine it with 
 anything from a Logitech noise-cancelling USB headset on the 
 low end to a complete mixer board and studio mic on the high 
 end, and you've got some serious quality screencasts.  Also 
 supports a good Logitech camera so you can do PIP right on 
 top of your screen action.
 
 Captivate eats nasty ass.

I wouldn't go so far as to say that either eats nasty ass - they're both
good products. Captivate has some advantages. It doesn't force you to
download one big honking SWF file containing all your content. Instead, it
generates individual SWFs per piece of content, and uses the same preloading
mechanism that Adobe Presenter uses to download a few pieces of content
while you're viewing one. It lets you build things other than just demos.
Simulations, for example. It also lets you more easily generate matching
printed documentation, in my experience. Camtasia Studio has other
advantages, such as the ability to generate multiple output formats.

Both are available as trial downloads. You should check them both out, and
see what you prefer.

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;203748912;27390454;j

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


Re: JRun Servlet Error After Reinstall of Developer Edition (CFMX7)

2008-09-18 Thread James Holmes
CF mappings don't help the built in webserver find your pages. You
need to move your files into CF's webroot. Altervatively, connect CF
to a webserver.

On Fri, Sep 19, 2008 at 2:55 AM, Chris Montgomery [EMAIL PROTECTED] wrote:
 Ok, I feel like an idiot and must be missing something obvious.
 I had to reinstall my developer edition of the CF server on my local box
 (Win XP SP2). Since doing so, I cannot get CF pages to work. When I try
 to load a page I am receiving a 404 JRun Servlet Error. The sites on my
 dev box are under the d:\webapps\myapps folder. I have this mapped in CF
 Admin as /myapps. I configured CF during install to run the built-in web
 server.

-- 
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;203748912;27390454;j

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


Re: Want to Learn Fuse-Box

2008-09-18 Thread Brian Kotek
Hilarious? No. Expected from Claude? Yes. It's a perfect example of a snide
comment with no actual substance at all. Which, sadly, is typical.
If you're used to procedural programming, Fusebox may be a very good option
to consider. If you come from a more OO background, you may find Model-Glue
or Mach-II more intuitive. Either way, I'd urge you to disregard any useless
jibes and investigate for yourself. A book on Fusebox 5.5 just came out, and
Doug Hughes is teaching a full course on Model-Glue in the near future.
There are plenty of options to look at.

On Thu, Sep 18, 2008 at 4:58 PM, sandeep saini [EMAIL PROTECTED]wrote:

 :-)

 hilarious 

 

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

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


Re: How to parse a text file...

2008-09-18 Thread C S
 I need to get rid of the column headers in the first line,
 and then get rid of any linefeeds after the last piece of data.
 This seemed fairly straightforward when I started...

...and it should still be fairly straightforward:

cfset data = listRest(data, chr(10)) /
cfset data = trim(data) /


As pre-parsing the file already, you might as well keep it all in CF. However, 
you could also skip the header in your LOAD DATA statement using IGNORE x LINES;
http://dev.mysql.com/doc/refman/5.0/en/load-data.html


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

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


Re: Want to Learn Fuse-Box

2008-09-18 Thread Matt Quackenbush
Let's not leave ColdBox out of the loop.  Luis Majano has a training seminar
coming up in October.  ;-)


On Thu, Sep 18, 2008 at 8:29 PM, Brian Kotek wrote:

 Hilarious? No. Expected from Claude? Yes. It's a perfect example of a snide
 comment with no actual substance at all. Which, sadly, is typical.
 If you're used to procedural programming, Fusebox may be a very good option
 to consider. If you come from a more OO background, you may find Model-Glue
 or Mach-II more intuitive. Either way, I'd urge you to disregard any
 useless
 jibes and investigate for yourself. A book on Fusebox 5.5 just came out,
 and
 Doug Hughes is teaching a full course on Model-Glue in the near future.
 There are plenty of options to look at.



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

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


Re: Want to Learn Fuse-Box

2008-09-18 Thread s. isaac dealey
Brian Kotek said: 

 If you're used to procedural programming, Fusebox may be a very good
 option to consider. If you come from a more OO background, you may
 find Model-Glue or Mach-II more intuitive. Either way, I'd urge you to
 disregard any useless jibes and investigate for yourself. A book on
 Fusebox 5.5 just came out, and Doug Hughes is teaching a full course
 on Model-Glue in the near future. 
 
 There are plenty of options to look at.

And speaking of options (wait for it)... 

Here is a page that Charlie Arehart maintains with a list of some
various ColdFusion frameworks you can check out: 
http://www.carehart.org/cf411/#cffw 

There have actually been a number of similar lists maintained by
different people. Some more comprehensive than others and of course they
fluctuate because projects do come and go. 

I will give a little more insight into Charlie's list: 
Database frameworks: Transfer, Reactor, DataMgr and DataFaucet 

IoC / Dependency Injection: 
  LightWire and ColdSpring (required by Model-Glue) 

Full Stack (frameworks that do it all): 
  cfrails, CF on Wheels, FarCry and the onTap framework 

(Of course, if I left anyone out, feel free to correct me) 

And who knows what other frameworks on RIAForge.org might not even be in
Charlie's list currently. 

You may also want to check out Kay Smoljak's recent series of articles
on SitePoint in which she's interviewing various framework teams /
authors to get the skinny on their history, purpose and techniques 
http://www.sitepoint.com/blogs/2008/05/06/frameworks-frameworks-everywhere/

And I recently published this survey in which I'm trying to get some
general information about the community's thoughts on frameworks. I
posted the survey URL before, but this time I'm going to post this blog
article where I explain a little bit more about my reason for creating
the survey: 
http://ontap.riaforge.org/blog/index.cfm/2008/9/14/Framework-Survey

For a long time there was only FuseBox in the ColdFusion community...
Really, right up until the introduction of ColdFusion MX and the advent
of CFCs. I'm not sure how related those two things are, I just know
they happened at the same time. And even initially the first frameworks
to be released after that were influenced by FuseBox. Though today even
FuseBox doesn't much resemble what it looked like back then. My own
frustration with the earlier versions of FuseBox (primarily 3) stemmed
from what seemed to me a lot of repetition. More recent versions of that
particular framework have really streamlined that aspect and made it
much easier to work with (imo anyway). And while I personally found early
versions of Mach-II even *more* repetitive than FuseBox, that's also
changed some and is continuing to change as I read recently that they're
planning to revise the XML syntax for views to make it more concise.
There has been (and I think continues to be) a gradual shift toward more
configuration light style frameworks and making those XML config files
more concise (that is, when they're not being removed all-together).

Anyway these days there's a very wide array of public frameworks
available to choose from and that's not even including the host of
private or proprietary frameworks used by various corporate entities.
And I suspect the proliferation of frameworks will only continue with
more of them being created and more of the ones that are already
available gaining popularity and becoming larger development communities. 

At the moment I don't really have much to back up that claim other than
to say, check out this list of application frameworks on Wikipedia and
look at the size of the lists for Java and PHP! 

http://en.wikipedia.org/wiki/List_of_web_application_frameworks

And to note as well that the ColdFusion community is growing and can be
expected to grow rather rapidly in the coming year or so thanks to a
recent proliferation of free/open-source CFML engines (Railo, OpenBD and
SmithProject) as well as the Adobe merger and a lot of good press we've
been getting recently, such as the codie award given to ColdFusion for
best webservice solution. 
http://www.talkingtree.com/blog/index.cfm/2008/5/21/SIIA-2008-Codie-Award-For-Adobe-ColdFusion

And the recent evangelism kit Kristen Schofield published, showing some
of the roadmap for Centaur (9), Sully (10) and Link (11). 

http://www.webbschofield.com/index.cfm/2008/9/15/ColdFusion-Evangelism-Kit
http://www.codersrevolution.com/index.cfm/2008/9/17/A-Look-Into-ColdFusions-Future-Centaur-Sully-Link

We're already starting to see the effects of these things. I've been
seeing recruiters recently talking about a dearth of ColdFusion talent
in California. Basically if you're a talented CF programmer it seems you
can pretty much have your pick of jobs if you're willing to move to LA. 

So I wouldn't expect the proliferation of frameworks to abate any time
soon. 

All that being said, (okay, now I'll hawk) Kay Smoljak did a fantastic
job editing an interview 

Re: Want to Learn Fuse-Box

2008-09-18 Thread s. isaac dealey
And I still forgot one! 

Web Application Frameworks Comparison chart 

http://en.wikipedia.org/wiki/Comparison_of_web_application_frameworks


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

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;203748912;27390454;j

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


Re: Want to Learn Fuse-Box

2008-09-18 Thread s. isaac dealey
Just received the body too long message. :) 

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

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;203748912;27390454;j

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


Re: Problem loading data from text file...

2008-09-18 Thread Azadi Saryev
you could do a 3-step process and use LOAD DATA INFILE:

1) loop through your file, checking the data and saving the output in a
var using cfsavecontent:
cfoutput
cfsavecontent variable=myvarcfloop file=pathtoyourfile
index=linecfif len(trim(line))#line  chr(13) 
chr(10)#/cfif/cfloop/cfsavecontent
/cfoutput

[note: linebreaks inside cfsavecontent have een purposefully removed to
prevent cf inserting empty lines. you can also use cfsetting
enablecfoutputonly=true around the whole block for good measure
]
then do cfset myvar = trim(myvar) to get rid of any trailing emptyness

2) save the massaged data into another temp file
cffile action=write file=fullpath/temp.csv output=#trim(myvar)#

3) use the temp file in your LOAD DATA INFILE and then delete it if
necessary

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/



Rick Faircloth wrote:
 Sounds like a good idea, Eric...if I could just figure out
 how to handle the data!

 I read the file with this code:

 cffileaction   = read
file = e:\active_photos.txt
variable = active_photos /

 From here, I've tried listtoarray, etc., but I can't get the
 info in the text file into an array properly.

 The text file is a list of photos.

 The first line is column headings; Photo Filename, Photo Label.

 I can use listtoarray with chr(10)chr(13) as the delimiters,
 but that gives me each row as an element.

 I need the photo filename as array(1,1) and photo label as array(1,2).

 The problem I'm running into is that the photo filename and the photo label
 are tab delimited...chr(9)...and each row is delimited by chr(10)chr(13).

 I can't figure out how to use both delimiters to parse the rows and the row
 elements.

 Suggestions?

 Thanks,

 Rick


   
 -Original Message-
 From: Eric Roberts [mailto:[EMAIL PROTECTED]
 Sent: Thursday, September 18, 2008 2:26 AM
 To: CF-Talk
 Subject: RE: Problem loading data from text file...

 Why not use cffile and then load it into the db...then you could easily
 process the data to be however you want it?

 Eric

 /*-Original Message-
 /*From: Rick Faircloth [mailto:[EMAIL PROTECTED]
 /*Sent: Wednesday, September 17, 2008 7:40 PM
 /*To: CF-Talk
 /*Subject: Problem loading data from text file...
 /*
 /*I'm using this query to load data into a table from a text file:
 /*
 /*cfquery name=load_data datasource=c21ar
 /*
 /*   load data infile
 /*'e:/inetpub/webroot/real_estate_data/hmls/data/#today#_idx_custom/active_p
 /*hotos.txt'
 /*   into table hmls_active_photos_temp
 /*   lines terminated by '\r\n'
 /*   ignore 1 lines
 /*
 /*/cfquery
 /*
 /*It runs fine except for the fact that at the end of each day's new
 /*active_photos.txt file,
 /*there are a couple of blanks lines, like the ENTER key has been struck a
 /*couple of times
 /*after the last line of data.
 /*
 /*The load data infile command is trying to read these lines and throws an
 /*error because of the
 /*empty lines.
 /*
 /*Is there some way to cause this query not to process, or to skip, empty
 /*lines?  The empty lines
 /*are always at the end of the file and prevent me from automating the
 /*loading of data.
 /*
 /*Suggestions?
 /*
 /*Thanks,
 /*
 /*Rick
 /*
 /*
 /*


 

 

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

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


'Coldfusion' is undefined if using cflayout,cftree in cf8

2008-09-18 Thread Deepender Singh
The same code that use cflayout(type border),cftree is working in developer 
addition of cf8 on my local machine.

But when move to multiserver...its giving javascript error.
'Coldfusion' is undefined

i have my code in the cfide and cfdoc directory(cf_webroot).

Is there is some issue with cfajx.js?


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

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