RE: Cons to Fusebox

[Philip Arnold]

> Oh, in that case fusebox sucks. I'm not going to use it
> anymore! You're the smartest guy ever!

Hey, you said
> I've never heard a developer who's actually architected
> and developed a project with FB say "I wish I hadn't used FB"

I told you that I had a situation where I HAD said that I wished I
hand't used FuseBox

So, because you've been proven wrong, you come back with a smart-ass
remark?

Sorry, I'd better go back in time and decide that FuseBox 2 was the
greatest thing ever, even though it added 20 minutes to my upload time
because of how many locations I had to FTP to...






~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Cons to Fusebox

[GL]

No dork, I was responding to your weird remark:
"What does that say about FuseBox?"
I don't understand nor do I wish to understand your goofy situation and
why you have to work so hard to upload files. I think you may have made
a logistical error or 2 designing this cluster-f*** of a site, but it
doesn't reflect at all on the merits of fuesbox so I'm not sure why you
made that remark. You're just further supporting my theory about
nay-sayers not understanding something about using fusebox.

-Original Message-
From: Philip Arnold [mailto:[EMAIL PROTECTED] 
Sent: Sunday, July 20, 2003 2:08 AM
To: CF-Talk
Subject: RE: Cons to Fusebox


> Oh, in that case fusebox sucks. I'm not going to use it anymore! 
> You're the smartest guy ever!

Hey, you said
> I've never heard a developer who's actually architected
> and developed a project with FB say "I wish I hadn't used FB"

I told you that I had a situation where I HAD said that I wished I
hand't used FuseBox

So, because you've been proven wrong, you come back with a smart-ass
remark?

Sorry, I'd better go back in time and decide that FuseBox 2 was the
greatest thing ever, even though it added 20 minutes to my upload time
because of how many locations I had to FTP to...







~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Cons to Fusebox

[Roger B.]

> I tried to build an app on FB2, then another client wanted a site with
> exactly the same technology - this meant duplicating the files over the
? 2 folders - whenever I did updates, I had to upload to 2 locations

Philip,

I'm no FB evangelist... people should use whatever works for them, IMO. But
there are a couple things in your comment that don't make sense to me.

(1) FB2 places no particular limits on the locations of your individual
fuses. In my case, each JournURL community is an independent instance of an
FB2-ish app, but all instances share dsp_s, act_s, qry_s, custom tags, and
CFCs that are stored in centralized locations.

(2) Ignoring any potential architectural issues, the problem you're
describing could have been solved with an automation app like AutoMate
(http://www.unisyn.com/automate/). One click (or a scheduler) will copy
files across directories and FTP them to the appropriate remote locations.
Would have been a whole lot simpler than scrapping most of the code and
starting from scratch.

--
Roger Benningfield
JournURL
blog: http://admin.support.journurl.com/


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Cons to Fusebox

[Roger B.]

> This is almost rediculous. I've seen complete newbies with little or no
> CF experience pick up fusebox in a week.

There's nothing ridiculous about the FB learning curve... FB makes instant
sense to many people, and is completely impenetrable to many others. Anyone
who has watched the various FB mailing lists over the years has seen newbies
struggle with simple tasks like framing a Fusebox'd site, not because such
things are actually hard to do, but because FB can be conceptually confusing
to folks who are accustomed to EPIAI (Each Page Is An Island) web
development.

Folks have different backgrounds and make different intuitive leaps. That's
just the way it is.

--
Roger
JournURL
blog: http://admin.support.journurl.com/


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Cons to Fusebox

[Matt Robertson]

The anonymous GL said,
>No dork, I was responding to 

If you can't be a grownup here then get out.  Around here that attitude
just discounts your opinion as noise.


 Matt Robertson   [EMAIL PROTECTED] 
 MSB Designs, Inc.  http://mysecretbase.com


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Cons to Fusebox

[Michael Wilson]

...and you further support their point that people who use Fusebox are
idiots. You do nothing to further this thread with these comments and
you do nothing to show that Fusebox is beneficial to developers.
 
Michael Wilson

-Original Message-
From: GL [mailto:[EMAIL PROTECTED] 
Sent: Sunday, July 20, 2003 7:25 AM
To: CF-Talk
Subject: RE: Cons to Fusebox

You're just further supporting my theory about nay-sayers not
understanding something about using fusebox.


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

SOAP & CF

[W Luke]

Hi,

I need to get a very basic app running by Thursday - just one which
messages MSN/ICQ clients instead of email.  I've found a Web Service
which can help (free):
http://www.bindingpoint.com/ws/imalert/imalert.asmx

I've not done any SOAP before, and not much WSDL (although a little).
Could anyone give me an example of how the following code could be
adapted?

POST /ws/imalert/imalert.asmx HTTP/1.1
Host: www.bindingpoint.com
Content-Type: text/xml; charset=utf-8
Content-Length: length
SOAPAction: "http://www.bindingpoint.com/ws/imalert/SendMSN";


http://www.w3.org/2001/XMLSchema-instance";
xmlns:xsd="http://www.w3.org/2001/XMLSchema";
xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/";>
  
http://www.bindingpoint.com/ws/imalert/";>
  string
  string
  string

  

HTTP/1.1 200 OK
Content-Type: text/xml; charset=utf-8
Content-Length: length


http://www.w3.org/2001/XMLSchema-instance";
xmlns:xsd="http://www.w3.org/2001/XMLSchema";
xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/";>
  
http://www.bindingpoint.com/ws/imalert/";>
  SENT or UNREACHABLE or FAILED or
LIMITEXCEEDED

  


Thanks

Will
--
http://cricketalerts.co.uk

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: SOAP & CF

[Jim Campbell]

Are you using ColdFusion MX?  If so, this code will do the job:

http://www.bindingpoint.com/ws/imalert/imalert.asmx?wsdl";
method="sendICQ" returnvariable="theResult">





Change the cfinvoke method to "sendMSN" and you're golden.  No SOAP
deconstruction necessary!

If you're using ColdFusion 4.5 and above (non-MX), there's a custom tag
called cfx_soap on devnet that might work for you, since you're only sending
strings.

- Jim

-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]
Sent: Sunday, July 20, 2003 12:39 PM
To: CF-Talk
Subject: SOAP & CF


Hi,

I need to get a very basic app running by Thursday - just one which
messages MSN/ICQ clients instead of email.  I've found a Web Service
which can help (free):
http://www.bindingpoint.com/ws/imalert/imalert.asmx

I've not done any SOAP before, and not much WSDL (although a little).
Could anyone give me an example of how the following code could be
adapted?

POST /ws/imalert/imalert.asmx HTTP/1.1
Host: www.bindingpoint.com
Content-Type: text/xml; charset=utf-8
Content-Length: length
SOAPAction: "http://www.bindingpoint.com/ws/imalert/SendMSN";


http://www.w3.org/2001/XMLSchema-instance";
xmlns:xsd="http://www.w3.org/2001/XMLSchema";
xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/";>
  
http://www.bindingpoint.com/ws/imalert/";>
  string
  string
  string

  

HTTP/1.1 200 OK
Content-Type: text/xml; charset=utf-8
Content-Length: length


http://www.w3.org/2001/XMLSchema-instance";
xmlns:xsd="http://www.w3.org/2001/XMLSchema";
xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/";>
  
http://www.bindingpoint.com/ws/imalert/";>
  SENT or UNREACHABLE or FAILED or
LIMITEXCEEDED

  


Thanks

Will
--
http://cricketalerts.co.uk


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Cons to Fusebox

[GL]

It's not really a campaign to convert stubborn cowboy-coders to use
Fusebox is it? I don't care if these guys are too smart to use fusebox.
Those of us that efficiently produce reusable, maintainable code are
just becomming more valued in the industry. Clients/Investors are
quickly learning that it's not practical to invest hundreds of thousands
of dollars into "disposal" software. It all comes out in the wash.

-Original Message-
From: Michael Wilson [mailto:[EMAIL PROTECTED] 
Sent: Sunday, July 20, 2003 12:24 PM
To: CF-Talk
Subject: RE: Cons to Fusebox


...and you further support their point that people who use Fusebox are
idiots. You do nothing to further this thread with these comments and
you do nothing to show that Fusebox is beneficial to developers.
 
Michael Wilson

-Original Message-
From: GL [mailto:[EMAIL PROTECTED] 
Sent: Sunday, July 20, 2003 7:25 AM
To: CF-Talk
Subject: RE: Cons to Fusebox

You're just further supporting my theory about nay-sayers not
understanding something about using fusebox.



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Cons to Fusebox

[Shawn Grover]

Your statements assume the apps in multiple locations all belong to one
client.  If I had 3 clients who each required a shopping cart app (for
instance), I doubt very much if they would want their system to be even
partially located on server's outside their domains.  In this case (which is
common among software shops) one would need to copy the common code to each
of the domains.  Then, if a fix is done for one site (to the common code),
then it is very likely that fix needs to be applied to the other sites as
well.  I don't see how FB helps with this situation any, nor makes it any
worse.  This issue would exist regardless of what architecture or
methodology was implemented.  But yes, I agree that there are tools
available to synchronize remote folders which would make this issue easier
to deal with.




Roger Benningfield said:
>(1) FB2 places no particular limits on the locations of your individual
>fuses. In my case, each JournURL community is an independent instance of an
>FB2-ish app, but all instances share dsp_s, act_s, qry_s, custom tags, and
>CFCs that are stored in centralized locations.
>
>(2) Ignoring any potential architectural issues, the problem you're
>describing could have been solved with an automation app like AutoMate
>(http://www.unisyn.com/automate/). One click (or a scheduler) will copy
>files across directories and FTP them to the appropriate remote locations.
>Would have been a whole lot simpler than scrapping most of the code and
>starting from scratch.

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Cons to Fusebox

[GL]

Just to set the record straight since you weren't paying attention to
the whole thread. I was using "dork" to describe the obvious latency in
brain function on the part of the guy when he said: "So, because you've
been proven wrong, you come back with a smart-ass remark?". My smart-ass
remark was about "What does that say about FuseBox?". That's a "dorky"
statement when all he just explained is why he couldn't figure out a
good way to do something so he blames it on fusebox.

-Original Message-
From: Shawn Grover [mailto:[EMAIL PROTECTED] 
Sent: Sunday, July 20, 2003 2:40 PM
To: CF-Talk
Subject: RE: Cons to Fusebox


Your statements assume the apps in multiple locations all belong to one
client.  If I had 3 clients who each required a shopping cart app (for
instance), I doubt very much if they would want their system to be even
partially located on server's outside their domains.  In this case
(which is common among software shops) one would need to copy the common
code to each of the domains.  Then, if a fix is done for one site (to
the common code), then it is very likely that fix needs to be applied to
the other sites as well.  I don't see how FB helps with this situation
any, nor makes it any worse.  This issue would exist regardless of what
architecture or methodology was implemented.  But yes, I agree that
there are tools available to synchronize remote folders which would make
this issue easier to deal with.




Roger Benningfield said:
>(1) FB2 places no particular limits on the locations of your individual

>fuses. In my case, each JournURL community is an independent instance 
>of an FB2-ish app, but all instances share dsp_s, act_s, qry_s, custom 
>tags, and CFCs that are stored in centralized locations.
>
>(2) Ignoring any potential architectural issues, the problem you're 
>describing could have been solved with an automation app like AutoMate 
>(http://www.unisyn.com/automate/). One click (or a scheduler) will copy

>files across directories and FTP them to the appropriate remote 
>locations. Would have been a whole lot simpler than scrapping most of 
>the code and starting from scratch.


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: OT: anyone take a MySQL training class from mysql.com?

[S. Allen]

dan martin wrote:

> I am considering taking the Using and Managing MySQL training class and was 
> wondering if anyone here had any feedback on the class (from www.mysql.com)
> 
> Anyone take any other training class on MySQL that they could recommend?
> 
> I am interested in coming up to speed quickly on MySQL. It seems a class is the best 
> mechanism. Any other recommendations?

Presently I'm taking the Virtual Training Company's MySQL course (CD with 
Video). I'm enjoying it very much as I like to watch the instructor show 
examples onscreen, while doing the same. I recommend it highly.

-- 
Best Regards,

Steve

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

read-only SQL transactions

[Jochem van Dieten]

How do you start a read-only SQL transaction from CF MX?

Jochem



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: read-only SQL transactions

[Dave Watts]

> How do you start a read-only SQL transaction from CF MX?

I don't think the CFTRANSACTION tag supports this. I suspect that you could
just write your batch within CFQUERY tags and set it there. This is just a
suspicion, though; I haven't tried it.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: read-only SQL transactions

[Joe Eugene]

What do you mean by a "start read-only SQL transaction"?
Multiple select statements within a ?

Joe Eugene


> -Original Message-
> From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
> Sent: Sunday, July 20, 2003 4:41 PM
> To: CF-Talk
> Subject: read-only SQL transactions
>
>
> How do you start a read-only SQL transaction from CF MX?
>
> Jochem
>
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Fire and forget a Stored Procedure

[Gunther Ahamer]

I am not 100% on this but I believe even if the user hits the stop button or
disconnects the client some other way, CF will continue processing the page
anyway.
I dont think that IIS tells CF that the client has disconnected.

Gunther

-Original Message-
From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED]
Sent: Friday, 18 July 2003 10:59 PM
To: CF-Talk
Subject: Fire and forget a Stored Procedure


Hi all,
 
Just wondering if this is possible (and if so, how to do it)...
 
We have a stored procedure that is run when a user asks for it.  It doesn't
have a set time, just when the user requests.  Normally I just open query
analyzer (MSSQL 2000 btw) and execute the procedure.
 
I want to be able to add a link to our site so that the user can click and
it will kick off, the problem is that the procedure takes 1 to 2 hours to
run.  That's a long time to have a browser open and I don't want to do any
changes to our timeouts or use request timeout (long story don't ask).
 
Is there anyway to do a "Fire and forget"?  I.E. user click the link,
procedure starts, user gets a page stating job is started and the procedure
runs no matter what the user does (close browser, take hammer to
workstation, etc :)
 
Thanks
*COST SAVINGS SUGGESTION*
For pages that must be printed, change your print settings to print in
"grayscale" instead of color.



Steve Durette
Mgr-Eng. & Const. Systems Support
100 S. Main
Room 314
Mt. Clemens, MI 48043
Ofc: 586.466.7654
Fax: 586.466.1109
  [EMAIL PROTECTED] 
 


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Fire and forget a Stored Procedure

[Doug White]

I don't think it will work -   When the visitor closes the browser or moves on
to somewhere else you will get an error like the following in your ColdFusion
Server Log file:

"Error","1160","07/15/03","12:20:34",,"Unable to write reply -- client browser
stopped waiting for request. "
"Error","1160","07/15/03","12:20:34",,"Windows NT error number 109 occurred."


==
Stop spam on your domain, use our gateway!
For hosting solutions http://www.clickdoug.com
ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772
==
If you are not satisfied with my service, my job isn't done!

- Original Message - 
From: "Gunther Ahamer" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, July 20, 2003 6:42 PM
Subject: RE: Fire and forget a Stored Procedure


| I am not 100% on this but I believe even if the user hits the stop button or
| disconnects the client some other way, CF will continue processing the page
| anyway.
| I dont think that IIS tells CF that the client has disconnected.
|
| Gunther
|
| -Original Message-
| From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED]
| Sent: Friday, 18 July 2003 10:59 PM
| To: CF-Talk
| Subject: Fire and forget a Stored Procedure
|
|
| Hi all,
|
| Just wondering if this is possible (and if so, how to do it)...
|
| We have a stored procedure that is run when a user asks for it.  It doesn't
| have a set time, just when the user requests.  Normally I just open query
| analyzer (MSSQL 2000 btw) and execute the procedure.
|
| I want to be able to add a link to our site so that the user can click and
| it will kick off, the problem is that the procedure takes 1 to 2 hours to
| run.  That's a long time to have a browser open and I don't want to do any
| changes to our timeouts or use request timeout (long story don't ask).
|
| Is there anyway to do a "Fire and forget"?  I.E. user click the link,
| procedure starts, user gets a page stating job is started and the procedure
| runs no matter what the user does (close browser, take hammer to
| workstation, etc :)
|
| Thanks
| *COST SAVINGS SUGGESTION*
| For pages that must be printed, change your print settings to print in
| "grayscale" instead of color.
|
|
|
| Steve Durette
| Mgr-Eng. & Const. Systems Support
| 100 S. Main
| Room 314
| Mt. Clemens, MI 48043
| Ofc: 586.466.7654
| Fax: 586.466.1109
|   [EMAIL PROTECTED]
|
|
|
| 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

CF5 with Apache 2.0.42 on Windows

[Mike Alberts]

Mike,

I'm running Apache 2.044 on Windows 2000 without any issues. Using one of the drivers 
Dave mentioned.

HTH

Mike Alberts
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Code Reuse

[LI, Chunshen \(Don\)]

Code Reuse
-- How to make a reusable component to provide more
value to customers?

Hope the topic is not OT.  I'm not sure if Dr. Carma
McClure's claim that "software reuse is the best
answer to the decade-old software crisis"
is all that accurate.  But I'm a firm believer in code
reuse, probably it's a common practice by many
developers, and I'd like to do better in this area.  
The intention of this posting is to seek wisdom and
ideas.

It's necessary to revisit some key benefits of code
reuse to put the subject matter into perspective
without going into detail:

* Increased developers' productivity by reducing
development time;
* Increased software quality (premise: reusable
components are reliable and of good quality);
* Reduced cost;
* Improved software interoperability;
* conducive to maintenance and future enhancements

Despite all these great benefits code reuse faces a
few formidable challenges.  Chief among them, IMHO,
Context Prediction.  Allow me to use a specific case
to demonstrate the challenge, SureFire, a reusable
component, URL,
http://68.32.61.40/datadata/ddSearch.cfm.  
This simple component lets one search for data against
any user table of a given database 
(MS SQL Server -based in this case).  

Say, in one environment/context, the business may not 
want certain table or tables to be
accessable/searchable by the application.  Easy
solution, the component has a mechnism to handle this
situation and the component configuration is easy
as well.  Now, in another environment, the business
does not want data in certain columns to 
be viewed by the application users.  Again, the
component has a little nice mechnism to handle that.
OK, now, the third business environment's given
database has all this cryptic column names like
fn, ln for firstName and lastName respectively, again,
no problem, the component can address
the semantic problem adequately.

Now, the real challenge, it seems to me, is the
enormous difficulty of adapting to many different
usage contexts (failure to anticipate possible usage
context(s)).  How could a developer possibly do better
in this area?  Let's use the particular case when
referencing concept(s).

BTW, I read a bit on domain analysis by SEI, though
informative, I can't extract practical 
value or to be more accurate, apply it to this case.  

Aother less important thing, can we consider the above
mechnisms as "adaptable architecture"?

Your thoughts and ideas would be appreciated.

Li, Chunshen (Don)
[EMAIL PROTECTED]









~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

cfqueryparam and unicode and SQL Server

[Matthew Walker]

I'm inserting Unicode data (specifically Japanese characters) into a SQL
Server table. This works fine if you use the N prefix, e.g.

title = N'#arguments.title#',

Anybody know how to write this using the cfqueryparam tag? I optimistically
tried . . .

title = N,

But I didn't expect that to work. 



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: cfqueryparam and unicode and SQL Server

[Paul Hastings]

make sure you're using the JDBC driver, set the advanced option's "use
unicode.." on.
then title =  should work. all the
other encoding stuff still applies.

> I'm inserting Unicode data (specifically Japanese characters) into a SQL
> Server table. This works fine if you use the N prefix, e.g.


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: cfqueryparam and unicode and SQL Server

[Matthew Walker]

Beautiful! Thanks! I figured you'd probably know the answer. ;-)

> -Original Message-
> From: Paul Hastings [mailto:[EMAIL PROTECTED]
> Sent: Monday, 21 July 2003 4:03 p.m.
> To: CF-Talk
> Subject: Re: cfqueryparam and unicode and SQL Server
> 
> make sure you're using the JDBC driver, set the advanced option's "use
> unicode.." on.
> then title =  should work. all the
> other encoding stuff still applies.
> 
> > I'm inserting Unicode data (specifically Japanese characters) into a SQL
> > Server table. This works fine if you use the N prefix, e.g.
> 
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Cons to Fusebox

[Mosh Teitelbaum]

Brian Kotek wrote:
> I mean, I could say the best methodology is the
> "build the best application" methodology.  There are no
> repeatable steps to this methodology, no way to document it in a
> way that someone else can use.  But when you use it and you do it
> right, whooeee the results are amazing!

Brian:

Not to try and get you back into the thread here 8^), but there are numerous
methodologies/frameworks/paradigms/etc. out there, for any number of
languages, that consistently produce successful products.  Of course, those
same methodologies/frameworks/paradigms/etc. can also consistently create
dreck.  I think the key is not so much in the
methodologies/frameworks/paradigms/etc. as it is in the preparations made
prior to the actual development of the code.

In my experience, which includes long stretches of time at "programming
shops" as well as technology consultancies, the most successful projects and
products have been those in which a significant amount of time was spent,
prior to actual coding, in developing the concept of the final product, the
details of inner and outer workings, the documents supporting these details,
solid planning (including time for unforeseeables), solid programming, peer
review/oversight/auditing/whatever, testing, and more.  Whether or not all
of this was wrapped into Framework X, Methodology Y, or Paradigm Z was of
very little import if all of the other factors were not there.

I think that, in general, any standard, whether standardized at the
individual; organization, or community at large, can be beneficial.  But it
tends to be only a small part of the larger process.  Frameworks are great
for taking care of core functionalities, methodologies are great for
explaining how things should be done, and "paradigm" is a horrible word that
should never have found its way into our lexicon but no matter what you use,
or even if you don't use anything at all, if you don't have a solid pre- and
post- coding process, you're still not going to produce a successful
product.

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

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Fire and forget a Stored Procedure

[Jim Davis]

> -Original Message-
> From: Doug White [mailto:[EMAIL PROTECTED]
> Sent: Sunday, July 20, 2003 8:10 PM
> To: CF-Talk
> Subject: Re: Fire and forget a Stored Procedure
> 
> I don't think it will work -   When the visitor closes the browser or
> moves on
> to somewhere else you will get an error like the following in your
> ColdFusion
> Server Log file:
> 
> "Error","1160","07/15/03","12:20:34",,"Unable to write reply -- client
> browser
> stopped waiting for request. "
> "Error","1160","07/15/03","12:20:34",,"Windows NT error number 109
> occurred."

That error only occurs AFTER the resource (in this case the DB) has returned
and CF attempts (actually the web server attempts) to give the page to the
browser.

What will happen however is that CF will time out - the request will STILL
BE RUNNING, but CF will have given the thread up for dead and increased the
lost thread count.

Unless you need user feedback on the process I wouldn't look to CF to do
this directly.  I believe (test it first) that CFEXECUTE, if set to a
timeout of zero, will run the process and return immediately - most DBs
comes with a command line process of some kind.

In SQL Server this is "OSQL" - from the command line you can run SQL
statements or scripts.  It may be just what you need.  Just get the command
line syntax and use CFEXECUTE to launch it.

Jim Davis

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Cons to Fusebox

[Mosh Teitelbaum]

Mosh Teitelbaum wrote:
> 4) Fusebox does have a learning curve (IMO, a pretty steep one if you want
to
>truly and properly use all that FB offers) but once learned, you're in
>pretty good company (until the next release and then there usually
seems to
>be another learning curve).

GL drew on a cave wall:
> This is almost rediculous. I've seen complete newbies with little or no
> CF experience pick up fusebox in a week. Although I haven't been into
> FB4 yet, the transition from FB2 to FB3 took about a half hour.

In less than the time it took me to read the Techspedition book, I had
"picked up" Fusebox.  But did I know it well enough to architect a
"perfect," completely Fusebox-compatible and -compliant system taking full
advantage of all it offers?  No.  That takes experience.  I picked up
ColdFusion in about 4 hours.  But was I as good with it 8 years ago as I am
now?  No.  Because now I have 8 years of experience with it that I didn't
have back then.

The fact that someone can "pick something up" in a short amount of time says
absolutely nothing about their ability to turn it around and make something
useful.  As a purely hypothetical example (with no offense intended to
Fuseboxers or the newbies in question), I have to assume that your newbies
were used as coders and not architects.  Given that Fusebox is advertised as
being able to separate coders from having to actually know anything about
the system that they're developing, it doesn't say much for people who
require a week to learn how to code individual files each of which perform a
single task and are fully documented and spec'ed out.

Now I suspect that your newbies were something of an exaggeration.  And my
"example" was intended to bring that to the fore, but my point remains...
something as (relatively) complex as Fusebox cannot be fully learned in that
short a time frame.  And every time it changes, it needs to be relearned.

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

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Environment variables not available

[Neculai Macarie]

Hi!

I'm trying to set an environment variable using mod_rewrite, Apache 2 and CFMX on 
Windows, but it does not work. I can verify that the variable is set by mod_rewrite, 
but it does not appear in the CGI structure in CFMX.

Do I need to compile the connector to pass additional environment variables ?




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4