Re: Changing Order By - designating specific value to return first

[Jason Miller]

I am not familair with a 
"SELECT TOP 1

and ORDER DESC "
As for Order Desc would just flop a list like

Distribution

General Features

Materials Management Inventory

Purchase Order Production etc etc etc
TO

Purchase Order Production

Materials Management Inventory

General Features

Distribution etc etc.



I am physically trying to display the specific Term General Features (
field sSubHeading) to show first -then actually don't care about balance
of output.
Am I missing something really easy?

thanks!
jay


Taco Fleur wrote:


How about a SELECT TOP 1

and ORDER DESC

?

- Original Message -

From: "Jason Miller"    <[EMAIL PROTECTED]>

To: "CF-Talk"   
<[EMAIL PROTECTED]>

Sent: Wednesday, February 12, 2003 5:39 PM

Subject: Changing Order By - designating specific value to return first





  

Hello list - I have a query that specifys a specific order - I need to

take the last value in the order by statement and alter that... for

example -

Query is



SELECT mf.iModule, mf.iApplication, mf.sModuleFeature,

mf.sFeatureIndent, mf.sFeatureSubHeading, mf.iModuleID, mf.LTC_Related,

mf.Reh_Related, mf.Inp_Related, mf.Out_Related,

am.smodulename

FROM ModuleFeatures mf, applicationmodules am

WHERE mf.imodule = am.iapplicationmoduleID AND #ProviderPage# = 1 AND

iApplication = #ApplicationPage#

ORDER BY iApplication, iModule, sFeatureSubHeading





THe ORDER BY iApplication, iModule is exactly as i need.



Now - the issue is sFeatureSubHeading - If I sort by any logical order

it is incorrect - values returned as of now are as expected sample

output is:



Distribution

General Features

Materials Management Inventory

Purchase Order Production etc etc etc



What I would like is simple force if so General Features displays first

- then the others like so



General Features

Distribution

Materials Management Inventory

Purchase Order Production etc etc etc



I don't care really about the others although keeping the balance would

be good in alphabetical.

Typically I would give up and add a sort order field - which I don't

have... Is there another way to do it other than add a new column for no

reason to force General Features above all else?



The query works great and is the core query for 16 active pages so I

don't want to have to modify it too much.

THanks!

jay










~|
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
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: Second try: can anybody help with this deserialization problem?

[afrinl]

Dave --

Hmmm, interesting idea, will give it a shot when I can get some time...  Thanks again!

-- LBA

Dave Watts wrote:

> > FYI, I just got back from exploring the Axis bug list at the
> > URL you referenced, and the problem with deserialization of
> > complex-within-complex datatypes does seem to be listed
> > there, but I saw conflicting info about whether it was fixed for
> > 1.0 vs. de-escalated to a post-1.0 fix.
> >
> > Guess I'll have to wait for Updater 3, unless there's some
> > way I can test Axis 1.0 (or an even later beta) with my
> > existing MX installation...
>
> Sure, you can test it right now. Unfortunately, you can't test it within
> CFMX. However, you can download Axis 1.0 and test it from Java. If the
> problem is related to WSDL interpretation, you can just use the bundled
> wsdl2java utility, and see if it returns any errors. Tom Jordahl, one of the
> Axis lead developers from Macromedia, showed me this at Devcon, to
> demonstrate that the final Axis release would work with MS MapPoint.
>
> 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
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: Changing Order By - designating specific value to return first

[Taco Fleur]

How about a SELECT TOP 1
and ORDER DESC
?
- Original Message -
From: "Jason Miller" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, February 12, 2003 5:39 PM
Subject: Changing Order By - designating specific value to return first


> Hello list - I have a query that specifys a specific order - I need to
> take the last value in the order by statement and alter that... for
> example -
> Query is
> 
> SELECT mf.iModule, mf.iApplication, mf.sModuleFeature,
> mf.sFeatureIndent, mf.sFeatureSubHeading, mf.iModuleID, mf.LTC_Related,
> mf.Reh_Related, mf.Inp_Related, mf.Out_Related,
> am.smodulename
> FROM ModuleFeatures mf, applicationmodules am
> WHERE mf.imodule = am.iapplicationmoduleID AND #ProviderPage# = 1 AND
> iApplication = #ApplicationPage#
> ORDER BY iApplication, iModule, sFeatureSubHeading
> 
>
> THe ORDER BY iApplication, iModule is exactly as i need.
>
> Now - the issue is sFeatureSubHeading - If I sort by any logical order
> it is incorrect - values returned as of now are as expected sample
> output is:
>
> Distribution
> General Features
> Materials Management Inventory
> Purchase Order Production etc etc etc
>
> What I would like is simple force if so General Features displays first
> - then the others like so
>
> General Features
> Distribution
> Materials Management Inventory
> Purchase Order Production etc etc etc
>
> I don't care really about the others although keeping the balance would
> be good in alphabetical.
> Typically I would give up and add a sort order field - which I don't
> have... Is there another way to do it other than add a new column for no
> reason to force General Features above all else?
>
> The query works great and is the core query for 16 active pages so I
> don't want to have to modify it too much.
> THanks!
> jay
>
>
> 
~|
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: Second try: can anybody help with this deserialization proble m?

[Dave Watts]

> FYI, I just got back from exploring the Axis bug list at the 
> URL you referenced, and the problem with deserialization of
> complex-within-complex datatypes does seem to be listed 
> there, but I saw conflicting info about whether it was fixed for
> 1.0 vs. de-escalated to a post-1.0 fix.
> 
> Guess I'll have to wait for Updater 3, unless there's some 
> way I can test Axis 1.0 (or an even later beta) with my
> existing MX installation...

Sure, you can test it right now. Unfortunately, you can't test it within
CFMX. However, you can download Axis 1.0 and test it from Java. If the
problem is related to WSDL interpretation, you can just use the bundled
wsdl2java utility, and see if it returns any errors. Tom Jordahl, one of the
Axis lead developers from Macromedia, showed me this at Devcon, to
demonstrate that the final Axis release would work with MS MapPoint.

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

Transferring Files between Web Servers

[mfriedman]

How do I check this.

I am not sure where to look or how to change this.

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

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

OT: how to check if a browser is a windows IE > 5.5

[mfriedman]

Use the code that is generated out of Dreamweaver and the you can hack that into Code 
fusion.

There are also some great custom tags on the macromedia site that will provide you 
everything you need to about the broswer, version, platform, is javascript enabled, 
CSS enabled, everything.
~|
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
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

CFFile???

[mfriedman]

How do you open the service of cold fusion and set the permissions.

I am also having an issue with CFFile where I have to move a file to another server 
that has a mapped newtork drive.  I am getting an Access Denide issue and that thought 
that I have is that the CF is running under a service/permissions where that drive is 
not mounted or seen.

Any thoughts?
~|
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
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: Second try: can anybody help with this deserialization problem?

[afrinl]

Dave --

1Q03?  Heck, that's within the next six weeks -- just a blink of an eye around here... 
 Guess I can put this project on
the backburner 'til then.  Thanks!

-- LBA

Dave Watts wrote:

> > Really?  CFMX's Axis module is a beta? Well, that explains
> > some stuff, doesn't it?  :-)
>
> In Macromedia's defense, it was the best version of Axis available at the
> time. Macromedia has also been one of the driving forces behind Axis
> development - two of the lead Axis developers are from Macromedia.
>
> > I'll check out the Axis site you referenced, but I guess
> > the next question naturally is, does anyone on this list
> > know anything about the expected timeframe for a release
> > of Updater 3?
>
> I've heard rumors that it'll be released in the first quarter of 2003.
>
> 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
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: Second try: can anybody help with this deserialization proble m?

[Dave Watts]

> Really?  CFMX's Axis module is a beta? Well, that explains 
> some stuff, doesn't it?  :-)

In Macromedia's defense, it was the best version of Axis available at the
time. Macromedia has also been one of the driving forces behind Axis
development - two of the lead Axis developers are from Macromedia.

> I'll check out the Axis site you referenced, but I guess 
> the next question naturally is, does anyone on this list 
> know anything about the expected timeframe for a release 
> of Updater 3?

I've heard rumors that it'll be released in the first quarter of 2003.

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
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: experthost.com & cfmx

[Dave Watts]

> is anyone else out there, using experthost.com
> to host your sites, on one of their cfmx servers
> and noticed that sometimes when you ftp a file over
> that when you refresh in your browser, you wont
> see the new file, and sometimes, you can delete the file
> refresh, and it still shows the old cached version?
> 
> i emailed them and they told me that it was a cfmx bug, 
> and that they werent sure of a fix?

If this is what I think it is, it's a known issue that may occur regardless
of your host.

CFMX compiles your .cfm files to Java class files. When you change the .cfm
file, CFMX compares the timestamp of the .cfm to the timestamp of the class,
and recompiles if the .cfm has a newer timestamp. However, apparently there
are some situations where that doesn't work correctly. The "fix" in this
case is to delete the compiled class, which would be in /WEB-INF/cfclasses.
Unfortunately, you probably don't have access to that directory.

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
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

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

Re: experthost.com & cfmx

[Dave Lyons]

i've had issues similar before on asp sites on windows servers and the
server just had to be flushed. Most are set to do it every 24 hours.

its always something stupid like that


Dave

- Original Message -
From: "Tony Weeg" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 11, 2003 11:29 PM
Subject: RE: experthost.com & cfmx


> stuff im workin on tonight :)
>
> tw
>
> -Original Message-
> From: Dave Lyons [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 11, 2003 11:28 PM
> To: CF-Talk
> Subject: Re: experthost.com & cfmx
>
>
> how many days has it been?
>
> Dave
>
> - Original Message -
> From: "Tony Weeg" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, February 11, 2003 11:24 PM
> Subject: RE: experthost.com & cfmx
>
>
> > already did, no dice. that was my first question to them.
> >
> > i know...odd...
> >
> > -Original Message-
> > From: Chris Kief [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, February 11, 2003 11:22 PM
> > To: CF-Talk
> > Subject: RE: experthost.com & cfmx
> >
> >
> > Sounds like they have Trusted Cache turned on in the administrator.
> Ask
> > them
> > about that setting...
> >
> > chris
> >
> >
> > -Original Message-
> > From: Tony Weeg [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, February 11, 2003 8:18 PM
> > To: CF-Talk
> > Subject: experthost.com & cfmx
> >
> > is anyone else out there, using experthost.com
> > to host your sites, on one of their cfmx servers
> > and noticed that sometimes when you ftp a file over
> > that when you refresh in your browser, you wont
> > see the new file, and sometimes, you can delete the file
> > refresh, and it still shows the old cached version?
> >
> > i emailed them and they told me that it was a cfmx bug, and
> > that they werent sure of a fix?
> >
> > thanks!
> >
> > tony
> >
> > tony weeg
> > [EMAIL PROTECTED]
> > www.revolutionwebdesign.com
> > rEvOlUtIoN wEb DeSiGn
> > 410.334.6331
> >
> >
> >
> >
>
> 
~|
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.

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

Changing Order By - designating specific value to return first

[Jason Miller]

Hello list - I have a query that specifys a specific order - I need to 
take the last value in the order by statement and alter that... for 
example -
Query is

SELECT mf.iModule, mf.iApplication, mf.sModuleFeature, 
mf.sFeatureIndent, mf.sFeatureSubHeading, mf.iModuleID, mf.LTC_Related, 
mf.Reh_Related, mf.Inp_Related, mf.Out_Related,
am.smodulename
FROM ModuleFeatures mf, applicationmodules am
WHERE mf.imodule = am.iapplicationmoduleID AND #ProviderPage# = 1 AND 
iApplication = #ApplicationPage#
ORDER BY iApplication, iModule, sFeatureSubHeading


THe ORDER BY iApplication, iModule is exactly as i need.

Now - the issue is sFeatureSubHeading - If I sort by any logical order 
it is incorrect - values returned as of now are as expected sample 
output is:

Distribution
General Features
Materials Management Inventory
Purchase Order Production etc etc etc

What I would like is simple force if so General Features displays first 
- then the others like so

General Features
Distribution
Materials Management Inventory
Purchase Order Production etc etc etc

I don't care really about the others although keeping the balance would 
be good in alphabetical.
Typically I would give up and add a sort order field - which I don't 
have... Is there another way to do it other than add a new column for no 
reason to force General Features above all else?

The query works great and is the core query for 16 active pages so I 
don't want to have to modify it too much.
THanks!
jay


~|
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
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: experthost.com & cfmx

[Tony Weeg]

stuff im workin on tonight :)

tw

-Original Message-
From: Dave Lyons [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, February 11, 2003 11:28 PM
To: CF-Talk
Subject: Re: experthost.com & cfmx


how many days has it been?

Dave

- Original Message -
From: "Tony Weeg" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 11, 2003 11:24 PM
Subject: RE: experthost.com & cfmx


> already did, no dice. that was my first question to them.
>
> i know...odd...
>
> -Original Message-
> From: Chris Kief [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 11, 2003 11:22 PM
> To: CF-Talk
> Subject: RE: experthost.com & cfmx
>
>
> Sounds like they have Trusted Cache turned on in the administrator.
Ask
> them
> about that setting...
>
> chris
>
>
> -Original Message-
> From: Tony Weeg [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 11, 2003 8:18 PM
> To: CF-Talk
> Subject: experthost.com & cfmx
>
> is anyone else out there, using experthost.com
> to host your sites, on one of their cfmx servers
> and noticed that sometimes when you ftp a file over
> that when you refresh in your browser, you wont
> see the new file, and sometimes, you can delete the file
> refresh, and it still shows the old cached version?
>
> i emailed them and they told me that it was a cfmx bug, and
> that they werent sure of a fix?
>
> thanks!
>
> tony
>
> tony weeg
> [EMAIL PROTECTED]
> www.revolutionwebdesign.com
> rEvOlUtIoN wEb DeSiGn
> 410.334.6331
>
>
>
> 

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

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

RE: experthost.com & cfmx

[Russ]

I've not had that exposure with them.  Actually, to be fair, I've
noticed no issues with them for awhile, but we had more than a few bumps
with them upfront.

Russ
(hosting CFMX sites on a small, no-name server for fair rates)

> -Original Message-
> From: Tony Weeg [mailto:[EMAIL PROTECTED]] 
> Sent: Tuesday, February 11, 2003 10:18 PM
> To: CF-Talk
> Subject: experthost.com & cfmx
> 
> 
> is anyone else out there, using experthost.com
> to host your sites, on one of their cfmx servers
> and noticed that sometimes when you ftp a file over
> that when you refresh in your browser, you wont
> see the new file, and sometimes, you can delete the file
> refresh, and it still shows the old cached version?
> 
> i emailed them and they told me that it was a cfmx bug, and
> that they werent sure of a fix?
> 
> thanks!
> 
> tony
> 
> tony weeg
> [EMAIL PROTECTED]
> www.revolutionwebdesign.com
> rEvOlUtIoN wEb DeSiGn
> 410.334.6331 
> 
> 
~|
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.

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

Re: experthost.com & cfmx

[Dave Lyons]

how many days has it been?

Dave

- Original Message -
From: "Tony Weeg" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 11, 2003 11:24 PM
Subject: RE: experthost.com & cfmx


> already did, no dice. that was my first question to them.
>
> i know...odd...
>
> -Original Message-
> From: Chris Kief [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 11, 2003 11:22 PM
> To: CF-Talk
> Subject: RE: experthost.com & cfmx
>
>
> Sounds like they have Trusted Cache turned on in the administrator. Ask
> them
> about that setting...
>
> chris
>
>
> -Original Message-
> From: Tony Weeg [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 11, 2003 8:18 PM
> To: CF-Talk
> Subject: experthost.com & cfmx
>
> is anyone else out there, using experthost.com
> to host your sites, on one of their cfmx servers
> and noticed that sometimes when you ftp a file over
> that when you refresh in your browser, you wont
> see the new file, and sometimes, you can delete the file
> refresh, and it still shows the old cached version?
>
> i emailed them and they told me that it was a cfmx bug, and
> that they werent sure of a fix?
>
> thanks!
>
> tony
>
> tony weeg
> [EMAIL PROTECTED]
> www.revolutionwebdesign.com
> rEvOlUtIoN wEb DeSiGn
> 410.334.6331
>
>
>
> 
~|
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.

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

RE: experthost.com & cfmx

[Tony Weeg]

already did, no dice. that was my first question to them.

i know...odd...

-Original Message-
From: Chris Kief [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, February 11, 2003 11:22 PM
To: CF-Talk
Subject: RE: experthost.com & cfmx


Sounds like they have Trusted Cache turned on in the administrator. Ask
them
about that setting...

chris


-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, February 11, 2003 8:18 PM
To: CF-Talk
Subject: experthost.com & cfmx

is anyone else out there, using experthost.com
to host your sites, on one of their cfmx servers
and noticed that sometimes when you ftp a file over
that when you refresh in your browser, you wont
see the new file, and sometimes, you can delete the file
refresh, and it still shows the old cached version?

i emailed them and they told me that it was a cfmx bug, and
that they werent sure of a fix?

thanks!

tony

tony weeg
[EMAIL PROTECTED]
www.revolutionwebdesign.com
rEvOlUtIoN wEb DeSiGn
410.334.6331 



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

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

RE: experthost.com & cfmx

[Chris Kief]

Sounds like they have Trusted Cache turned on in the administrator. Ask them
about that setting...

chris


-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, February 11, 2003 8:18 PM
To: CF-Talk
Subject: experthost.com & cfmx

is anyone else out there, using experthost.com
to host your sites, on one of their cfmx servers
and noticed that sometimes when you ftp a file over
that when you refresh in your browser, you wont
see the new file, and sometimes, you can delete the file
refresh, and it still shows the old cached version?

i emailed them and they told me that it was a cfmx bug, and
that they werent sure of a fix?

thanks!

tony

tony weeg
[EMAIL PROTECTED]
www.revolutionwebdesign.com
rEvOlUtIoN wEb DeSiGn
410.334.6331 


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

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

experthost.com & cfmx

[Tony Weeg]

is anyone else out there, using experthost.com
to host your sites, on one of their cfmx servers
and noticed that sometimes when you ftp a file over
that when you refresh in your browser, you wont
see the new file, and sometimes, you can delete the file
refresh, and it still shows the old cached version?

i emailed them and they told me that it was a cfmx bug, and
that they werent sure of a fix?

thanks!

tony

tony weeg
[EMAIL PROTECTED]
www.revolutionwebdesign.com
rEvOlUtIoN wEb DeSiGn
410.334.6331 

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

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

RE: Second try: can anybody help with this deserialization proble m?

[Dave Watts]

> If I understand you right (and I may not, since 
> nobody would ever confuse me with an XML/WDDX/SOAP/
> webservices expert), you're basically recommending 
> I build an improved version of CFX_SOAP, right? That 
> is, put together a module that builds a CFML structure 
> representing a SOAP envelope and the service request 
> contained therein, then do a CFML-to-WDDX conversion 
> to get a serialized version of the SOAP message, then 
> do a CFHTTP (via the HTTP GET method) to execute it,
> then take the returned cfhttp.fileContent, which should 
> be the XML-formatted SOAP return, then do a WDDX-to-CFML
> conversion (either via CFWDDX or XmlParse()) to deserialize 
> the return message, then start manipulating my way 
> through the resulting complex structure to pick out the 
> structure-within-structure that represents the true return 
> value from the remote service.

This is not a viable solution, within CFML itself. For one thing, you won't
be able to use CFHTTP to build a valid SOAP request. I suspect that Howard
was suggesting that you use WDDX on both ends of the process, but since
you're using a third-party web service, that's probably not an option.

> Ick.  :-)  A working Axis module that lets me cfinvoke 
> to get back a structure-within-structure would be so much
> simpler.  I mean, wasn't I supposed to get a working Axis 
> module when my organization paid to upgrade to CFMX?  :-)

Well, not really. You got a beta Axis module with CFMX. However, I've heard
rumors that CFMX Updater 3 will include Axis 1.0, as well as the ability to
allow you to update Axis to post 1.0 versions later.

You might want to peruse the Axis bug list (available off of
http://ws.apache.org/axis/, I think) and see if your issue has been fixed in
Axis 1.0 or 1.1 beta, then wait until Updater 3 if possible.

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
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: Second try: can anybody help with this deserialization problem?

[afrinl]

Howard --

If I understand you right (and I may not, since nobody would ever confuse me with an 
XML/WDDX/SOAP/webservices expert),
you're basically recommending I build an improved version of CFX_SOAP, right?  That 
is, put together a module that
builds a CFML structure representing a SOAP envelope and the service request contained 
therein, then do a CFML-to-WDDX
conversion to get a serialized version of the SOAP message, then do a CFHTTP (via the 
HTTP GET method) to execute it,
then take the returned cfhttp.fileContent, which should be the XML-formatted SOAP 
return, then do a WDDX-to-CFML
conversion (either via CFWDDX or XmlParse()) to deserialize the return message, then 
start manipulating my way through
the resulting complex structure to pick out the structure-within-structure that 
represents the true return value from
the remote service.

Ick.  :-)  A working Axis module that lets me cfinvoke to get back a 
structure-within-structure would be so much
simpler.  I mean, wasn't I supposed to get a working Axis module when my organization 
paid to upgrade to CFMX?  :-)

Guess I'll do it your way if I gotta.  But first, I gotta ask: yo, Macromedia lurkers 
on this list!  Is anyone at MM
working on a fix for this?

-- LBA

"<\"Owens>,Howard\"" wrote:

> Have you considered CFWDDX?
>
> I imagine it would be a pain to go WDDX to CFML and then loop over all the
> structures and arrays and build something you can manipulate, but ...
>
> H.
>
> > -Original Message-
> > From: "Lawrence B. Afrin>,M.D." <[EMAIL PROTECTED] [SMTP:"Lawrence B.
> > Afrin>,M.D." <[EMAIL PROTECTED]]
> > Sent: Tuesday, February 11, 2003 3:24 PM
> > To:   CF-Talk
> > Subject:  Second try: can anybody help with this deserialization
> > problem?
> >
> > Howdy --
> >
> > I've received no responses to my more detailed posting last night, and,
> > figuring the problem was that nobody likes to read long e-mails, let me
> > try
> > again with a shorter (one paragraph!) version of the problem.
> >
> > My efforts to use cfinvoke to access a third-party web service which
> > returns a structure within a structure (i.e., a complex datatype within a
> > complex datatype) are being thwarted by a consistent failure in CFMX's
> > Axis
> > SOAP handler which is claiming it can't find a deserializer for the
> > internal complex datatype.  A single, brief comment on Macromedia's CF
> > forums from last month suggests this (the occasional inability of Axis to
> > handle complex-within-complex returns) is a known problem with no known
> > fix.  I am seeking confirmation of this assertion from others as well as
> > suggestions for alternative approaches for consuming this service, with
> > the
> > understanding that I have no control over the structuring of the returned
> > data.
> >
> > I am happy to provide additional details again to those who are
> > interested,
> > though most of the relevant details were included in my original message
> > last night.
> >
> > Any tips would be greatly appreciated.
> >
> > -- Larry Afrin
> >Medical University of South Carolina
> >[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
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: CFMX too fast?

[Tony Weeg]

good ideadefinitely worth a try!

tony

-Original Message-
From: bryan.hogan [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, February 11, 2003 10:23 PM
To: CF-Talk
Subject: Re: CFMX too fast?


Suggestion: Why not check for the file with FileExists() before trying
to transfer it.



logic

do something else


-- Original Message --
From: "Dave Lyons" <[EMAIL PROTECTED]>
Reply-To: <[EMAIL PROTECTED]>
Date:  Tue, 11 Feb 2003 21:19:50 -0500

wow, cf has a sleep function!
dang, i need that, tired as hell

Dave
- Original Message -
From: "Tony Weeg" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 11, 2003 9:12 PM
Subject: RE: CFMX too fast?


> maybe you could use the custom tag cf_sleep
> to wait for x amount of seconds...
>
> you can get it from the devex
>
> heres a url
>
>
http://devex.macromedia.com/developer/gallery/info.cfm?ID=59C805F4-D741-
> 11D6-840C00508B94F85A&method=Full
>
> my thinking tho' is thats not the issue.  maybe
> it is, and some others may chime in, but to pause a page
> for x amount of seconds, i use this, to have time to write
> a file that i am cflocating to
>
> hth
>
> tony
>
>
> -Original Message-
> From: Dale Coyner [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 11, 2003 9:08 PM
> To: CF-Talk
> Subject: CFMX too fast?
>
>
> I have some CF code that was executing pretty reliably under CF4.
Just
> this week we moved to CFMX/JRun on a new server and that formerly
> reliable script seems to have some issues but they are not
> syntax-related.
>
> We embed a Windows Media file with a script and write it to disk using
> CFFILE.  Then we CFFTP it to another server.  For files under 5MB it
> still seems to work fine but for larger files, I get an FTP error that
> it can't find the file.
>
> So I was wondering if execution of the FTP tag is getting ahead of the
> operating system's ability to finish writing the file?  If so, should
I
> just write a loop that tests for the presence of the file before
> attempting the FTP or is there a better way to do that?
>
>
> Also, does anybody know whether CFMX's log files like application.log
> will be fixed so that they show the same kind of debugging data
> previously available?  Without good stuff like the referring URL's
> values, they are not very helpful at the present.
>
> Thanks,
>
> Dale
>
>
> Dale Coyner
> Communicast, Inc.
> "Don't just webcast it, Communicast it!"
> (703) 435-8073
> www.communicast.com
> [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

ANNOUNCEMENT: Fusebox classes in Wash DC 2/15-3/10/03

[Michael Smith]

Come to an intensive intermediate class on Fusebox for Coldfusion in 
Rockville.
We explain how the Fusebox method can improve your productivity and
show you how it works. Plus we have a special advanced classfrom Hal 
Helms training.
Learn the hot, free way other CF programmers use to
produce project on time and budget. Class limited to 12 students each so 
that
you can be sure to get your own questions answered! Sign up today to 
guarantee a
place at
http://www.teratech.com/training/
- Michael Smith,
TeraTech, Inc
(Finalist CFDJ award for best training company)

PS If you are interested in other Hal Helms classes on Java or CFCs 
reply with
what you are interested in and if enough people are interested we will
put them on too!

Upcoming Classes

Sat 2/15/03 FB 100 - Welcome to Fusebox $9.95
Wed 2/19/03 FB 101 - Intro to Fusebox $199
Wed 2/26/03 FB 201 - Intermediate Fusebox $349
Mon 3/10/02 FB 202 - Advanced Fusebox and CFMX with Hal Helms Training 
$349 (NEW)

Other CF classes:
Wed 2/12/03 CF 201 - Building ColdFusion Skills $349
Thu 2/13/03 CF 206 - ColdFusion SQL Skills $349
Wed 3/5/03  CF 202 - Section 508 & ColdFusion $199
Wed 3/12/03 CF 204 - CFMX in Depth: Opportunities and Challenges $349

FB 100 - Welcome to Fusebox
***
Registration/Sign-in 9:30am Class 10am-12pm
* Learn the basics of how the Fusebox architecture can help you build 
ColdFusion Applications.

[ What is Fusebox? ]

Learn all the basics of how the Fusebox architecture can help you
build ColdFusion Applications.  Learn to tie together all the
queries, display elements, and actions of your application in a
consistent model.

[ How can Fusebox help you code? ]

Find out about how Fusebox can improve your applications from better
organization to proven methods of application design.

[ Did you ever wonder how you could work better as a team? ]

Fusebox builds teamwork!  Regain the efficiency of a single
programmer in a team environment.

[ Do you want to speed up development? ]

Fusebox helps you accelerate development with clear organization. 
Avoid redundancy and easily make changes with reusable queries and
display elements.  Avoid getting bogged down in the application
design and stick to the coding.  Get a taste of how Fusebox works
well with prototyping.


FB 101 - Introduction to Fusebox

Half Day course noon-4pm
Just $199

FB101 is ideal for any ColdFusion users interested in learning the
basics of Fusebox.  Whether you're just getting started with
ColdFusion or you're an experienced developer, Fusebox can help
you build better applications. If you want to learn more about
Fusebox first come to FB100 first.

* What is Fusebox?
* How can Fusebox help you code?
* index.cfm organization
* Naming conventions
* fuseaction

+ Learn all the basics of how the Fusebox architecture can help you
build ColdFusion Applications.

+ Learn to tie together all the queries, display elements, and
actions of your application in a consistent model.

+ Study a sample fusebox application and take the code home with you
to use in your own applications.

+ Find out about how Fusebox can improve your applications from
better organization to proven methods of application design.

+ Work hands on with the latest Fusebox techniques

* Q & A time



FB 201 - Intermediate Fusebox
*
Full Day course 10am-5pm
Just $349, includes lunch

Prerequisite: FB101 or similar basic Fusebox knowledge.

FB201 is for people who have already met Fusebox and want to improve
their skills with the new Fusebox 3.0 spec. Step up to the next level
with your Fusebox programming and save yourself time and headaches
when coding ColdFusion applications. Great for team projects!

* Fusebox 3 overview
  - How version 3 is better than version 2
* Core files - fbx_switch, settings, layouts
  - What files are essential to an FB3 app
* Nested Circuits
  - How nesting can help you organize your code for reuse
* XFAs
  - How Extended FuseActions can save time and self document code
* Nested Layouts
  - How nested layout can help code reuse and be smart layouts
that can change appearance depending where they are used
* Wireframes
  - How to build wireframe outlines of a site and what not to include
them if you don't want headaches
* Devnotes
  - How Devnotes can save you butt when developing
* Fusedocs
  - How to document the Fusebox way and why it can help testing too
* Fusebox API variables
  - What are all the API variables and what can you use them for

+ Learn all the advanced parts of how the Fusebox architecture can
help you build ColdFusion Applications.

+ Learn to tie together all the new parts of a Fusebox 3 application
together.

+ Study a sample fusebox application and take the code home with you
to use in your own applications.

+ Find out about how Fusebox can improve your applications from
better organization to proven methods of application design.

+ Work hands on with 

Re: CFMX too fast?

[bryan.hogan]

Suggestion: Why not check for the file with FileExists() before trying to transfer it.



logic

do something else


-- Original Message --
From: "Dave Lyons" <[EMAIL PROTECTED]>
Reply-To: <[EMAIL PROTECTED]>
Date:  Tue, 11 Feb 2003 21:19:50 -0500

wow, cf has a sleep function!
dang, i need that, tired as hell

Dave
- Original Message -
From: "Tony Weeg" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 11, 2003 9:12 PM
Subject: RE: CFMX too fast?


> maybe you could use the custom tag cf_sleep
> to wait for x amount of seconds...
>
> you can get it from the devex
>
> heres a url
>
> http://devex.macromedia.com/developer/gallery/info.cfm?ID=59C805F4-D741-
> 11D6-840C00508B94F85A&method=Full
>
> my thinking tho' is thats not the issue.  maybe
> it is, and some others may chime in, but to pause a page
> for x amount of seconds, i use this, to have time to write
> a file that i am cflocating to
>
> hth
>
> tony
>
>
> -Original Message-
> From: Dale Coyner [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 11, 2003 9:08 PM
> To: CF-Talk
> Subject: CFMX too fast?
>
>
> I have some CF code that was executing pretty reliably under CF4.  Just
> this week we moved to CFMX/JRun on a new server and that formerly
> reliable script seems to have some issues but they are not
> syntax-related.
>
> We embed a Windows Media file with a script and write it to disk using
> CFFILE.  Then we CFFTP it to another server.  For files under 5MB it
> still seems to work fine but for larger files, I get an FTP error that
> it can't find the file.
>
> So I was wondering if execution of the FTP tag is getting ahead of the
> operating system's ability to finish writing the file?  If so, should I
> just write a loop that tests for the presence of the file before
> attempting the FTP or is there a better way to do that?
>
>
> Also, does anybody know whether CFMX's log files like application.log
> will be fixed so that they show the same kind of debugging data
> previously available?  Without good stuff like the referring URL's
> values, they are not very helpful at the present.
>
> Thanks,
>
> Dale
>
>
> Dale Coyner
> Communicast, Inc.
> "Don't just webcast it, Communicast it!"
> (703) 435-8073
> www.communicast.com
> [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
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re:RESOLVED time and date to abort a page

[Dave Lyons]

Thanks Charlie!
i had too only make a small adjustment and it works:)




sorry charlie



youre in time!


dave

- Original Message -
From: "charlie griefer" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 11, 2003 6:41 PM
Subject: Re: time and date to abort a page


> Dave:
>
> You should be able to accomplish this very easily with cfform...
>
> (KIDDING...hey, i kid because i love)
>
> Seriously...looks like you were on the right track.
>
> 
>
> 
> SORRY
> 
>
> hth,
> Charlie
>
>
>
> Dave Lyons writes:
>
> > sorry for another stupid post but I cant get this too wok.
> > Been reading the live docs and its confused me even more! figures!
> >
> > I just got mad and deleted the code and starting fresh
> >
> > what I need to do is on a certain day of the week and at a certain time
(say Friday, march 10, 2003 at 6pm exactly) to abort any further actions
with the page
> > so someone cant make an entry into the db 1 sec after the deadline.
> > should be simple but I cant get it to work right, did once but it was
reversed, lol
> > Been messing around with a lot of the date & time functions but I really
couldn't tell which 1 to use.
> > Basically something like this
> > 
> > 
> > 
> > 
> > Sorry time is up
> >
> > 
> >
> > 
> > 
> >
> > ..rest of page
> >
> > 
> >
> > any suggestions.. (besides read the ben forta book, lol)
> >
> > dave
> > 
> >
> >
> >
> 
~|
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
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: CFMX too fast?

[Dave Lyons]

wow, cf has a sleep function!
dang, i need that, tired as hell

Dave
- Original Message -
From: "Tony Weeg" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 11, 2003 9:12 PM
Subject: RE: CFMX too fast?


> maybe you could use the custom tag cf_sleep
> to wait for x amount of seconds...
>
> you can get it from the devex
>
> heres a url
>
> http://devex.macromedia.com/developer/gallery/info.cfm?ID=59C805F4-D741-
> 11D6-840C00508B94F85A&method=Full
>
> my thinking tho' is thats not the issue.  maybe
> it is, and some others may chime in, but to pause a page
> for x amount of seconds, i use this, to have time to write
> a file that i am cflocating to
>
> hth
>
> tony
>
>
> -Original Message-
> From: Dale Coyner [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 11, 2003 9:08 PM
> To: CF-Talk
> Subject: CFMX too fast?
>
>
> I have some CF code that was executing pretty reliably under CF4.  Just
> this week we moved to CFMX/JRun on a new server and that formerly
> reliable script seems to have some issues but they are not
> syntax-related.
>
> We embed a Windows Media file with a script and write it to disk using
> CFFILE.  Then we CFFTP it to another server.  For files under 5MB it
> still seems to work fine but for larger files, I get an FTP error that
> it can't find the file.
>
> So I was wondering if execution of the FTP tag is getting ahead of the
> operating system's ability to finish writing the file?  If so, should I
> just write a loop that tests for the presence of the file before
> attempting the FTP or is there a better way to do that?
>
>
> Also, does anybody know whether CFMX's log files like application.log
> will be fixed so that they show the same kind of debugging data
> previously available?  Without good stuff like the referring URL's
> values, they are not very helpful at the present.
>
> Thanks,
>
> Dale
>
>
> Dale Coyner
> Communicast, Inc.
> "Don't just webcast it, Communicast it!"
> (703) 435-8073
> www.communicast.com
> [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
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: CFMX too fast?

[Tony Weeg]

maybe you could use the custom tag cf_sleep
to wait for x amount of seconds...

you can get it from the devex

heres a url

http://devex.macromedia.com/developer/gallery/info.cfm?ID=59C805F4-D741-
11D6-840C00508B94F85A&method=Full

my thinking tho' is thats not the issue.  maybe
it is, and some others may chime in, but to pause a page
for x amount of seconds, i use this, to have time to write
a file that i am cflocating to 

hth

tony


-Original Message-
From: Dale Coyner [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, February 11, 2003 9:08 PM
To: CF-Talk
Subject: CFMX too fast?


I have some CF code that was executing pretty reliably under CF4.  Just
this week we moved to CFMX/JRun on a new server and that formerly
reliable script seems to have some issues but they are not
syntax-related.

We embed a Windows Media file with a script and write it to disk using
CFFILE.  Then we CFFTP it to another server.  For files under 5MB it
still seems to work fine but for larger files, I get an FTP error that
it can't find the file.  

So I was wondering if execution of the FTP tag is getting ahead of the
operating system's ability to finish writing the file?  If so, should I
just write a loop that tests for the presence of the file before
attempting the FTP or is there a better way to do that?


Also, does anybody know whether CFMX's log files like application.log
will be fixed so that they show the same kind of debugging data
previously available?  Without good stuff like the referring URL's
values, they are not very helpful at the present.

Thanks,

Dale


Dale Coyner
Communicast, Inc.
"Don't just webcast it, Communicast it!"
(703) 435-8073
www.communicast.com
[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
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

CFMX too fast?

[Dale Coyner]

I have some CF code that was executing pretty reliably under CF4.  Just
this week we moved to CFMX/JRun on a new server and that formerly
reliable script seems to have some issues but they are not
syntax-related.

We embed a Windows Media file with a script and write it to disk using
CFFILE.  Then we CFFTP it to another server.  For files under 5MB it
still seems to work fine but for larger files, I get an FTP error that
it can't find the file.  

So I was wondering if execution of the FTP tag is getting ahead of the
operating system's ability to finish writing the file?  If so, should I
just write a loop that tests for the presence of the file before
attempting the FTP or is there a better way to do that?


Also, does anybody know whether CFMX's log files like application.log
will be fixed so that they show the same kind of debugging data
previously available?  Without good stuff like the referring URL's
values, they are not very helpful at the present.

Thanks,

Dale


Dale Coyner
Communicast, Inc.
"Don't just webcast it, Communicast it!"
(703) 435-8073
www.communicast.com
[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: CGI. variable and proxy?

[Taco Fleur]

Thanks!
- Original Message -
From: "Justin Scott" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, February 12, 2003 10:54 AM
Subject: Re: CGI. variable and proxy?


> cgi.http_x_forwarded_for
>
> -Justin Scott
>
> - Original Message -
> From: "Taco Fleur" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, February 11, 2003 7:47 PM
> Subject: CGI. variable and proxy?
>
>
> > I have seen a variable to get the ip of the client a proxy does the
> forwarding for.
> > But I can't find any documentation on it anymore.
> >
> > I believe it was cgi.forward_for
> >
> > Anyone??
> >
> >
> >
> 
~|
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: cf-jobs list

[Ben Doom]

For whatever reason, the HOF lists have been dropping messages at random
from the email distros.  The big blowout this weekend was the accidental
result of trying to fix that.

In any case, your messages always (as far as I've been able to tell) show up
on the site, so you can always check there for any replies.


--  Ben Doom
Programmer & General Lackey
Moonbow Software, Inc

: -Original Message-
: From: Justin Scott [mailto:[EMAIL PROTECTED]]
: Sent: Tuesday, February 11, 2003 7:56 PM
: To: CF-Talk
: Subject: cf-jobs list
:
:
: Does anyone know if the cf-jobs list is working correctly?  I posted a
: message on there earlier today, and have not seen it come through
: via e-mail
: yet.  It does show up on the web site though.  Any ideas?
:
: -Justin Scott
:
: 
~|
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.

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

cf-jobs list

[Justin Scott]

Does anyone know if the cf-jobs list is working correctly?  I posted a
message on there earlier today, and have not seen it come through via e-mail
yet.  It does show up on the web site though.  Any ideas?

-Justin Scott

~|
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: CGI. variable and proxy?

[Justin Scott]

cgi.http_x_forwarded_for

-Justin Scott

- Original Message -
From: "Taco Fleur" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 11, 2003 7:47 PM
Subject: CGI. variable and proxy?


> I have seen a variable to get the ip of the client a proxy does the
forwarding for.
> But I can't find any documentation on it anymore.
>
> I believe it was cgi.forward_for
>
> Anyone??
>
>
> 
~|
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
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

CGI. variable and proxy?

[Taco Fleur]

I have seen a variable to get the ip of the client a proxy does the forwarding for.
But I can't find any documentation on it anymore.

I believe it was cgi.forward_for

Anyone??


~|
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: time and date to abort a page

[Dave Lyons]

it almost worked
if i set the date to yesterday it works when i use the following (see below)
it doesnt work, which it should because the time has passed




sorry charlie



youre in time!




- Original Message -
From: "charlie griefer" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 11, 2003 6:41 PM
Subject: Re: time and date to abort a page


> Dave:
>
> You should be able to accomplish this very easily with cfform...
>
> (KIDDING...hey, i kid because i love)
>
> Seriously...looks like you were on the right track.
>
> 
>
> 
> SORRY
> 
>
> hth,
> Charlie
>
>
>
> Dave Lyons writes:
>
> > sorry for another stupid post but I cant get this too wok.
> > Been reading the live docs and its confused me even more! figures!
> >
> > I just got mad and deleted the code and starting fresh
> >
> > what I need to do is on a certain day of the week and at a certain time
(say Friday, march 10, 2003 at 6pm exactly) to abort any further actions
with the page
> > so someone cant make an entry into the db 1 sec after the deadline.
> > should be simple but I cant get it to work right, did once but it was
reversed, lol
> > Been messing around with a lot of the date & time functions but I really
couldn't tell which 1 to use.
> > Basically something like this
> > 
> > 
> > 
> > 
> > Sorry time is up
> >
> > 
> >
> > 
> > 
> >
> > ..rest of page
> >
> > 
> >
> > any suggestions.. (besides read the ben forta book, lol)
> >
> > dave
> > 
> >
> >
> >
> 
~|
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: @@identity and serialization errors.

[Scott Weikert]

Do it just like I posted earlier - all in one CFQUERY tag.

At 07:04 PM 2/11/2003 -0500, you wrote:
>I was running it in-between another cfquery tag, is this wrong?

~|
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: @@identity and serialization errors.

[Neil H.]

I was running it in-between another cfquery tag, is this wrong?

Neil

- Original Message -
From: "Scott Weikert" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 11, 2003 6:40 PM
Subject: Re: @@identity and serialization errors.


> At 06:29 PM 2/11/2003 -0500, you wrote:
> >Yes so you are doing two things to the DB within one query?
>
> I guess you could say that. Though the second thing isn't really doing
> anything 'to' the DB, just retrieving the value of the ID field for that
> newly created row. Works like a champ for me.
>
> 
~|
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: Unknown character codes appearing in DB

[Scott Weikert]

I've been encountering this same issue. A fellow told me to enforce ISO 
8559. I did a bit of poking around and found this meta tag being used here 
and there;



I haven't really put it to the test myself yet, but that's supposed to 
knock out those odd Word characters.

What I'd done before is do a Replace() function on each character with the 
normal ASCII character I wanted, before writing to my DB.

~|
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
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: time and date to abort a page

[Dave Lyons]

u like that tony, lol

haven't tried it yet, looking at some of the docs. You know what I hate
about these live docs? they fricking throw forms into everyone so you cant
tell the correct way to do something.

by the time I get to the cfm learning during the evening, my brains fried,
someone must have slipped me a bunch of 'cid in high school cause i sure
cant remember anything anymore, lol



Dave
- Original Message -
From: "Tony Weeg" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 11, 2003 6:46 PM
Subject: RE: time and date to abort a page


> dave,
>
> is that nice to pour gas on fires :)
>
> did you get it figgered out?
>
> tw
>
> -Original Message-
> From: Dave Lyons [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 11, 2003 6:44 PM
> To: CF-Talk
> Subject: Re: time and date to abort a page
>
>
> lol!  :)
> thanks I needed a good laugh at the moment!
> I was like oh not cfform AGAIN
> haha
> its the damn seconds that are really throwing me off.
> Thanks i will try and see
>
> is it wise to use cfabort in this case?
>
> and do I have to cflock it?? haha
>
> go avs!
> Dave
> -
>
> - Original Message -
> From: "charlie griefer" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, February 11, 2003 6:41 PM
> Subject: Re: time and date to abort a page
>
>
> > Dave:
> >
> > You should be able to accomplish this very easily with cfform...
> >
> > (KIDDING...hey, i kid because i love)
> >
> > Seriously...looks like you were on the right track.
> >
> > 
> >
> > 
> > SORRY
> > 
> >
> > hth,
> > Charlie
> >
> >
> >
> > Dave Lyons writes:
> >
> > > sorry for another stupid post but I cant get this too wok.
> > > Been reading the live docs and its confused me even more! figures!
> > >
> > > I just got mad and deleted the code and starting fresh
> > >
> > > what I need to do is on a certain day of the week and at a certain
> time
> (say Friday, march 10, 2003 at 6pm exactly) to abort any further actions
> with the page
> > > so someone cant make an entry into the db 1 sec after the deadline.
> > > should be simple but I cant get it to work right, did once but it
> was
> reversed, lol
> > > Been messing around with a lot of the date & time functions but I
> really
> couldn't tell which 1 to use.
> > > Basically something like this
> > > 
> > > 
> > > 
> > > 
> > > Sorry time is up
> > >
> > > 
> > >
> > > 
> > > 
> > >
> > > ..rest of page
> > >
> > > 
> > >
> > > any suggestions.. (besides read the ben forta book, lol)
> > >
> > > dave
> > > 
> > >
> > >
> > >
> >
>
> 
~|
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
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: time and date to abort a page

[Tony Weeg]

dave,

is that nice to pour gas on fires :)

did you get it figgered out?

tw

-Original Message-
From: Dave Lyons [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, February 11, 2003 6:44 PM
To: CF-Talk
Subject: Re: time and date to abort a page


lol!  :)
thanks I needed a good laugh at the moment!
I was like oh not cfform AGAIN
haha
its the damn seconds that are really throwing me off.
Thanks i will try and see

is it wise to use cfabort in this case?

and do I have to cflock it?? haha

go avs!
Dave
-

- Original Message -
From: "charlie griefer" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 11, 2003 6:41 PM
Subject: Re: time and date to abort a page


> Dave:
>
> You should be able to accomplish this very easily with cfform...
>
> (KIDDING...hey, i kid because i love)
>
> Seriously...looks like you were on the right track.
>
> 
>
> 
> SORRY
> 
>
> hth,
> Charlie
>
>
>
> Dave Lyons writes:
>
> > sorry for another stupid post but I cant get this too wok.
> > Been reading the live docs and its confused me even more! figures!
> >
> > I just got mad and deleted the code and starting fresh
> >
> > what I need to do is on a certain day of the week and at a certain
time
(say Friday, march 10, 2003 at 6pm exactly) to abort any further actions
with the page
> > so someone cant make an entry into the db 1 sec after the deadline.
> > should be simple but I cant get it to work right, did once but it
was
reversed, lol
> > Been messing around with a lot of the date & time functions but I
really
couldn't tell which 1 to use.
> > Basically something like this
> > 
> > 
> > 
> > 
> > Sorry time is up
> >
> > 
> >
> > 
> > 
> >
> > ..rest of page
> >
> > 
> >
> > any suggestions.. (besides read the ben forta book, lol)
> >
> > dave
> > 
> >
> >
> >
> 

~|
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: time and date to abort a page

[Dave Lyons]

lol!  :)
thanks I needed a good laugh at the moment!
I was like oh not cfform AGAIN
haha
its the damn seconds that are really throwing me off.
Thanks i will try and see

is it wise to use cfabort in this case?

and do I have to cflock it?? haha

go avs!
Dave
-

- Original Message -
From: "charlie griefer" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 11, 2003 6:41 PM
Subject: Re: time and date to abort a page


> Dave:
>
> You should be able to accomplish this very easily with cfform...
>
> (KIDDING...hey, i kid because i love)
>
> Seriously...looks like you were on the right track.
>
> 
>
> 
> SORRY
> 
>
> hth,
> Charlie
>
>
>
> Dave Lyons writes:
>
> > sorry for another stupid post but I cant get this too wok.
> > Been reading the live docs and its confused me even more! figures!
> >
> > I just got mad and deleted the code and starting fresh
> >
> > what I need to do is on a certain day of the week and at a certain time
(say Friday, march 10, 2003 at 6pm exactly) to abort any further actions
with the page
> > so someone cant make an entry into the db 1 sec after the deadline.
> > should be simple but I cant get it to work right, did once but it was
reversed, lol
> > Been messing around with a lot of the date & time functions but I really
couldn't tell which 1 to use.
> > Basically something like this
> > 
> > 
> > 
> > 
> > Sorry time is up
> >
> > 
> >
> > 
> > 
> >
> > ..rest of page
> >
> > 
> >
> > any suggestions.. (besides read the ben forta book, lol)
> >
> > dave
> > 
> >
> >
> >
> 
~|
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: Unknown character codes appearing in DB

[Dwayne Cole]

What version of ColdFusion are you using?


>A small utility on our intranet contains a simple form with a single textarea sending 
>to an Access DB. Users typically copy and paste text from MS Word documents into this 
>textarea. From time to time the following character codes show up in the database.
>
>’
>“
>…
>
>What are these and how can we prevent this from occurring?
>


~|
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: @@identity and serialization errors.

[Scott Weikert]

At 06:29 PM 2/11/2003 -0500, you wrote:
>Yes so you are doing two things to the DB within one query?

I guess you could say that. Though the second thing isn't really doing 
anything 'to' the DB, just retrieving the value of the ID field for that 
newly created row. Works like a champ for me.

~|
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: time and date to abort a page

[Dave Lyons]

i have and am using it for another part of this but i dont think it does
what i am looking for but maybe, i have no idea and a fricking blinding
headache.

basically i want it to do this
if they submit there test before the deadline all is good and its entered to
the db. But the slackers who hit submit after the deadline get a too bad
meesage
does that help?

- Original Message -
From: "Scott Weikert" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 11, 2003 6:33 PM
Subject: Re: time and date to abort a page


> Look at the DateDiff() function.
>
>
> >what I need to do is on a certain day of the week and at a certain time
> >(say Friday, march 10, 2003 at 6pm exactly) to abort any further actions
> >with the page
> >so someone cant make an entry into the db 1 sec after the deadline.
>
> 
~|
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
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: time and date to abort a page

[charlie griefer]

Dave: 

You should be able to accomplish this very easily with cfform... 

(KIDDING...hey, i kid because i love) 

Seriously...looks like you were on the right track. 

 


SORRY
 

hth,
Charlie 

 

Dave Lyons writes: 

> sorry for another stupid post but I cant get this too wok.
> Been reading the live docs and its confused me even more! figures! 
> 
> I just got mad and deleted the code and starting fresh 
> 
> what I need to do is on a certain day of the week and at a certain time (say Friday, 
>march 10, 2003 at 6pm exactly) to abort any further actions with the page
> so someone cant make an entry into the db 1 sec after the deadline.
> should be simple but I cant get it to work right, did once but it was reversed, lol
> Been messing around with a lot of the date & time functions but I really couldn't 
>tell which 1 to use.
> Basically something like this
> 
> 
> 
> 
> Sorry time is up 
> 
>  
> 
> 
>  
> 
> ..rest of page 
> 
>  
> 
> any suggestions.. (besides read the ben forta book, lol) 
> 
> dave
>  
> 
> 
> 
~|
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: time and date to abort a page

[Scott Weikert]

Look at the DateDiff() function.


>what I need to do is on a certain day of the week and at a certain time 
>(say Friday, march 10, 2003 at 6pm exactly) to abort any further actions 
>with the page
>so someone cant make an entry into the db 1 sec after the deadline.

~|
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: @@identity and serialization errors.

[Neil H.]

Yes so you are doing two things to the DB within one query?

Thanks,

Neil

- Original Message -
From: "Scott Weikert" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 11, 2003 3:08 PM
Subject: Re: @@identity and serilizatoin errors.


> At 02:33 PM 2/11/2003 -0500, you wrote:
> >Are you suggesting that I run two queries within the cfquery tag?
>
> I guess you're looking at that "select" as a second query? I hadn't really
> considered it that way.
>
> Just run whatever query that normally you would run, then outside of it,
> try and get the ID of the new record you inserted... use that where I put
> (query syntax).
>
> For example... here's one I use, trimmed out a bit:
>
> 
>  set nocount on
>
>  INSERT INTO TCustomField(***my fields ***)
>  VALUES(*** my values ***)
>
>  select NewID = @@IDENTITY
>  set nocount off
> 
> 
>
> 
~|
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

time and date to abort a page

[Dave Lyons]

sorry for another stupid post but I cant get this too wok.
Been reading the live docs and its confused me even more! figures!

I just got mad and deleted the code and starting fresh

what I need to do is on a certain day of the week and at a certain time (say Friday, 
march 10, 2003 at 6pm exactly) to abort any further actions with the page
so someone cant make an entry into the db 1 sec after the deadline.
should be simple but I cant get it to work right, did once but it was reversed, lol
Been messing around with a lot of the date & time functions but I really couldn't tell 
which 1 to use.
Basically something like this




Sorry time is up






..rest of page



any suggestions.. (besides read the ben forta book, lol)

dave



~|
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: DSNless connection

[Jim Davis]

> Hello all
> 
> 
>   We are looking into upgrading to CFMX from CF5, but one 
> issue we have not been able to overcome is that CFMX does not 
> have DSNless db connections. Is there a way in CFMX to create 
> a DSN connection on the fly, i.e. not having to go to CF 
> Admin to create the mapping?
> 
> Currently we have engineers that go all over the world 
> (Europe, Japan, Korea, etc), so they some times have very limited 
> access to GOOD internet access.
> 
> SO, We have developed an MS ACCESS db application that they 
> take a copy of, with them to what every site they are going to survey.
> 
> Upon returning they upload the db to the website. 
> 
> Currently the db is renamed at upload to conform to the 
> surveyed sites naming convention and the db dir is saved to 
> table on the server(central db) and later this is pulled to 
> create the DSNless connection to access the uploaded db, for 
> displaying info on the website.
> 
> Is there a way in CFMX to create the DSN connection when the 
> db is uploaded? Hope I have explained this enough.

It may not be fast, but you should be able to use COM/ADO to create your
connections (I'm assuming you're on windows since you're using Access).

You should be able to dig up information at www.cfcomet.com.

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
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Custom tags

[Bryan F. Hogan]

Make sure that your DLL or JAVA class is registered in the administrator
under cfx tags.


Bryan F. Hogan
Director of Internet Development
Macromedia Certified ColdFusion MX Developer
Digital Bay Media, Inc.
1-877-72DIGITAL


-Original Message-
From: Ryan Mitchell [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 11, 2003 6:01 PM
To: CF-Talk
Subject: Re: Custom tags


Nope this is the error I get:

Error processing CFX custom tag "CFX_JpegResizer".

The CFX custom tag "CFX_JpegResizer" was not found in the custom tag
database. Please be sure to add custom tags to the database before using
them. If you have added your tag to the database then you should check the
spelling of the tag within your template to insure that it matches the
database entry.


On 11/2/03 22:59, "Bryan Stevenson" <[EMAIL PROTECTED]> wrote:

> could the tag be looking for a table in the DB that you might not have?
>
> Bryan Stevenson B.Comm.
> VP & Director of E-Commerce Development
> Electric Edge Systems Group Inc.
> t. 250.920.8830
> e. [EMAIL PROTECTED]
>
> -
> Macromedia Associate Partner
> www.macromedia.com
> -
> Vancouver Island ColdFusion Users Group
> Founder & Director
> www.cfug-vancouverisland.com
> - Original Message -
> From: "Ryan Mitchell" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, February 11, 2003 2:45 PM
> Subject: Custom tags
>
>
>> Hey
>>
>> I've added a custom tag but when I try to use it I get an error saying
its
>> not in the database... Any thoughts? CFMX Pro btw...
>>
>> Ryan Mitchell
>>
>>
>

~|
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: Custom tags

[Ryan Mitchell]

Nope this is the error I get:

Error processing CFX custom tag "CFX_JpegResizer".

The CFX custom tag "CFX_JpegResizer" was not found in the custom tag
database. Please be sure to add custom tags to the database before using
them. If you have added your tag to the database then you should check the
spelling of the tag within your template to insure that it matches the
database entry. 


On 11/2/03 22:59, "Bryan Stevenson" <[EMAIL PROTECTED]> wrote:

> could the tag be looking for a table in the DB that you might not have?
> 
> Bryan Stevenson B.Comm.
> VP & Director of E-Commerce Development
> Electric Edge Systems Group Inc.
> t. 250.920.8830
> e. [EMAIL PROTECTED]
> 
> -
> Macromedia Associate Partner
> www.macromedia.com
> -
> Vancouver Island ColdFusion Users Group
> Founder & Director
> www.cfug-vancouverisland.com
> - Original Message -
> From: "Ryan Mitchell" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, February 11, 2003 2:45 PM
> Subject: Custom tags
> 
> 
>> Hey
>> 
>> I've added a custom tag but when I try to use it I get an error saying its
>> not in the database... Any thoughts? CFMX Pro btw...
>> 
>> Ryan Mitchell
>> 
>> 
> 
~|
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: Custom tags

[Bryan Stevenson]

could the tag be looking for a table in the DB that you might not have?

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com
- Original Message -
From: "Ryan Mitchell" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 11, 2003 2:45 PM
Subject: Custom tags


> Hey
>
> I've added a custom tag but when I try to use it I get an error saying its
> not in the database... Any thoughts? CFMX Pro btw...
>
> Ryan Mitchell
>
> 
~|
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: issues with JVM change?

[paul]

> > its been smooth sailing for me as far as i18n goes. what were the
> > issues?
>
> I thought you were the one posting that there were problems with the
> 1.4.1 JRE???

nope. the only i18n issue i'm aware of is currency formatting for one locale
(brazil if i recall) but thats been there for years already.

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

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

Re: issues with JVM change?

[Sean A Corfield]

On Tuesday, Feb 11, 2003, at 10:15 US/Pacific, <[EMAIL PROTECTED] (Paul 
Hastings)> wrote:
>> 1.4.0_03 works really well on Solaris (and Windows I believe). Some
>> people have reported a few problems with 1.4.1 - including
>> internationalization issues.
>
> its been smooth sailing for me as far as i18n goes. what were the 
> issues?

I thought you were the one posting that there were problems with the 
1.4.1 JRE???

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

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

Custom tags

[Ryan Mitchell]

Hey

I've added a custom tag but when I try to use it I get an error saying its
not in the database... Any thoughts? CFMX Pro btw...

Ryan Mitchell

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

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

RE: cftransaction HELP Please...

[Dave Watts]

> So with CFTransaction, the only reason to use  
> is if you want additional error handling? For example, 
> if I want details every time this fails, I could use 
> try within a transaction to capture failure reason? Is
> there a better way?

It's been my experience that you can capture the error information from the
CFTRANSACTION tag itself, so you could just wrap the entire thing in a
CFTRY, or use CFERROR TYPE="EXCEPTION" with the EXCEPTION="DATABASE"
attribute.

> Do you normally attempt to capture the reason that a 
> transaction fails?

Not specifically, unless I have a relatively high expectation that it will
fail. Usually, I'll know ahead of time why it might fail, anyway. For more
generic, unexpected exceptions, I'd rely on a higher-level error handler,
such as CFERROR or even the site-wide error handler.

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
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: cftransaction HELP Please...

[Andy Ousterhout]

How do you capture the error information?

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 11, 2003 4:19 PM
To: CF-Talk
Subject: RE: cftransaction HELP Please...


> now, if I want to know which of my queries failed and what
> error message the DB returned for that errant query, I will
> need the multiple try/catches within the transaction.

It's been my experience that the CFTRANSACTION itself will return an error
describing the query that went wrong, and the reason. Of course, that may
well vary between databases and platforms.

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: cftransaction HELP Please...

[Dave Watts]

> now, if I want to know which of my queries failed and what 
> error message the DB returned for that errant query, I will 
> need the multiple try/catches within the transaction.

It's been my experience that the CFTRANSACTION itself will return an error
describing the query that went wrong, and the reason. Of course, that may
well vary between databases and platforms.

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
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: CFLOCK

[Dave Lyons]

lol! not again

u ok there tony?




- Original Message -
From: "Ben Doom" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 11, 2003 3:47 PM
Subject: RE: CFLOCK


> Author's note.  This is not meant to be patronizing or anything.  It's
kind
> of an oversimplification, but it's intended to help you (and anyone else
who
> wants to read it) visualize the problems.
>
> Okay.  Pretend that data storage is a bunch of bins.  Anyone can look at
> shared bins, like the session, client, application, and server bins.
Anyone
> can write to them as well (for the most part).
>
> Now, let's pretend that you've got a bunch of office workers who use
these.
> There are two problems associated with sharing all this stuff.
>
> One:  garbling things.   Let's pretend that you have a long memo stored in
> (what else?) application.memo.  Bob the janitor is taking the memo out of
> the bin a paragraph at a time (he's a slow reader).  Normally, this isn't
a
> problem.  Until Jim the manager starts rewriting the memo and sticks the
> paragraphs in the bin while Bob isn't looking..  Unfortunately, Bob & Jim
> aren't smart enough to co-ordinate this, so what Bob gets is the first
half
> of the old memo and the last half of the new memo.  So he gets a garbled
> memo.
>
> Two:  race conditions.  Fred needs to remember something, so he sticks in
in
> application.something.  Unfortunately, Herman needs to remember a slightly
> different version, and sticks it in application.something just after Fred
> does.  Now, when Fred goes to read what he put there, he gets Herman's
> version.
>
> Okay, now we have CFLOCK.  It's like a note on the front of the bin.  If
> it's a readonly lock, it says "You can read this, but don't change it
until
> I remove the note."  If it's an exclusive lock, it says "I'm using this,
> wait your turn!"
>
>
>
> HTH.
>
>
> --  Ben Doom
> Programmer & General Lackey
> Moonbow Software, Inc
>
> : -Original Message-
> : From: Scott Wilhelm [mailto:[EMAIL PROTECTED]]
> : Sent: Tuesday, February 11, 2003 3:17 PM
> : To: CF-Talk
> : Subject: CFLOCK
> :
> :
> : Can someone please explain to me, in very simply terms, what CFLOCK
> : does, and why/when/where I should use it?
> :
> : I'm trying to build an application, and put it together as proper as can
> : be, but for some reason, my brain doesn't want to comprehen CFLOCK.
> :
> : Thanks,
> :
> : Scott
> :
> :
> : Scott Wilhelm
> : Computer Technician/Web Developer
> : St. Lawrence-Lewis BOCES
> : PO Box 231, Outer State Street
> : Canton, NY 13617
> :
> : P. 315-386-4504 x 164
> : F. 315-386-3395
> : W.   http://www.sllboces.org
> : E.[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: cftransaction HELP Please...

[Dave Carabetta]

>So with CFTransaction, the only reason to use  is if you want
>additional error handling?  For example, if I want details every time this
>fails, I could use try within a transaction to capture failure reason?  Is
>there a better way?
>
>Do you normally attempt to capture the reason that a transaction fails?

I wouldn't use  around each individual query in the  
to begin with.

The reason why you are using the  tag to begin with is 
because you want your logic to be executed as one block of code whereby if 
one query fails, within that block, everything gets rolled back. I, instead, 
would put a  block around the  tags if you want this 
granular error-handling, and in my  block, I would use the 
"cfcatch" scope (i.e., cfcatch.message, cfcatch.detail, etc.) to output the 
specific diagnostic information to pin down where in your  
the code failed. For more information on the "cfcatch" scope, see the 
documentation:



Regards,
Dave.


~|
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: Java and CFMX

[Joe Eugene]

You can write Java Bean/Objects and execute them in any CFMX/CF(4.5+) Version. You 
will require CFMX Ent to run Jsp.

Joe Eugene

---Original Message---
From: [EMAIL PROTECTED]
Sent: 02/11/03 03:51 PM
To: CF-Talk <[EMAIL PROTECTED]>
Subject: Java and CFMX

> 
> Hello,

I am new to Java and am curious how or if Java can be used with CFMX? Can 
you write JAVA and integrate it with a CFMX Professional Application or 
does the server need to be Enterprise?

Brook



~|
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: cftransaction HELP Please...

[Andy Ousterhout]

Or should you just have 1 try:







Error handling with catch message indicating where problem was.


If error rollback, otherwise commit




-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 11, 2003 3:34 PM
To: CF-Talk
Subject: RE: cftransaction HELP Please...


now, if I want to know which of my queries failed and what error message the
DB returned for that errant query, I will need the multiple try/catches
within the transaction.


Doug

>-Original Message-
>From: Dave Watts [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, February 11, 2003 2:55 PM
>To: CF-Talk
>Subject: RE: cftransaction HELP Please...
>
>
>> Here is the outline of the code that should work.  Just
>> plug in your queries:
>>
>> ... CFTRANSACTION with nested CFTRYs snipped ...
>
>Yikes! You don't need to use exception handling to rollback
>the transaction
>- that's what CFTRANSACTION itself is for! If you have three
>queries in a
>CFTRANSACTION, and any of them fail, they'll all be rolled
>back, as long as
>all queries use the same database connection information (datasource,
>username, password).
>
>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
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: cftransaction HELP Please...

[Douglas.Knudsen]

now, if I want to know which of my queries failed and what error message the DB 
returned for that errant query, I will need the multiple try/catches within the 
transaction.


Doug

>-Original Message-
>From: Dave Watts [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, February 11, 2003 2:55 PM
>To: CF-Talk
>Subject: RE: cftransaction HELP Please...
>
>
>> Here is the outline of the code that should work.  Just 
>> plug in your queries:
>> 
>> ... CFTRANSACTION with nested CFTRYs snipped ...
>
>Yikes! You don't need to use exception handling to rollback 
>the transaction
>- that's what CFTRANSACTION itself is for! If you have three 
>queries in a
>CFTRANSACTION, and any of them fail, they'll all be rolled 
>back, as long as
>all queries use the same database connection information (datasource,
>username, password).
>
>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
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: CFLOCATION & IE 6

[Jochem van Dieten]

Matt Kornguth wrote:
> 
> Positive it is just IE 6. I test on multiple versions of IE (mostly 5.5) without 
>ever seeing the headers.

Verify that the response from the server is correct and then maybe try a 
microsoft.* newsgroup?

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
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: CFLOCATION & IE 6

[Matt Kornguth]

Jochem,
Positive it is just IE 6. I test on multiple versions of IE (mostly 5.5) without ever 
seeing the headers.



On 2/11/2003 4:05 PM, Jochem van Dieten <[EMAIL PROTECTED]> wrote:
>Matt Kornguth wrote:
>> Has anyone found an issue using CFLOCATION in IE 6, where http 
>header information displays on the new url ... above the page output? 
>This is in CF 5.0 Enterprise BTW.
>
>Just in IE 6? Are you sure it is not a IE issue? Telnet to the server 
>
>and manually check the right headers are sent.
>
>
~|
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.

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

RE: CFLOCATION & IE 6

[Matthew Walker]

Do you have a bunch of javascript in the head of your page? If you can
put it in external scripts or move down to the bottom of the page that
seems to help, I've found. 

> -Original Message-
> From: Matt Kornguth [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, 12 February 2003 8:06 a.m.
> To: CF-Talk
> Subject: CFLOCATION & IE 6
> 
> 
> Has anyone found an issue using CFLOCATION in IE 6, where 
> http header information displays on the new url ... above the 
> page output? This is in CF 5.0 Enterprise BTW.
> 
> Can avoid it by redirecting using CFHEADER instead, but I'd 
> hate to have to program around this.
> 
> Thanks in advance,
> Matt Kornguth
> BLR.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
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: CF MX Enterprise Security

[Jochem van Dieten]

David Brown wrote:
> Could someone tell me how to limit what drives and folders in DW MX or Home
> Site connecting to a CF MX Enterprise server.  I have enabled sandbox
> security, but it does not seem to limit what drives a user see when login in
> via RDS.   I don't see a way to assign security based on username.

You can't assign permissions based on username. The only way you can 
limit access is by running CF MX with the credetials of some account 
that doesn't have permissions to all of the system, but that would still 
only allow permissions on a per server basis, not a per user basis.

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
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: cfoutput + cfloop: bug or

[Jochem van Dieten]

Peter Mayer wrote:
> 
> I know this example isn't very good but the general question still exists 
> if it is a bug that during a cfloop within a cfoutput always the first row 
> is returned and not the currentrow record.

Presuming this is your actual question: some call it a bug, some call it 
a feature, but I doubt it will ever change because it will break 
applications that have been working since the previous century ;-)


BTW, my favourite workaround is not to set temporary values, but loop 
over the query like it is a structure of arrays: 
queryname.columnname[rownumber]

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
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: CFFORM vs FORM

[Benoit Hediard]

I don't think that the question should be "CFForm is good or bad?".
It should be "Does it answer to your needs?".

If you don't need more validation capabilites, you should go for CFForm
"automatic" JS validation.
If you find them too limited, then go for "manual" JS validation.

My 0.02€...

Benoit Hediard
www.benorama.com

> -Message d'origine-
> De : Dave Lyons [mailto:[EMAIL PROTECTED]]
> Envoyé : mardi 11 février 2003 19:34
> À : CF-Talk
> Objet : Re: CFFORM vs FORM
>
>
> very true
> just hard to argue with Ben
> personally I haven't bothered learning the cfform tags but after
> I read that
> I am compelled to try it out.
> not agreeing or disagreeing with anyone just thought I would mention it.
> but then again don't listen to be (see below, loll)
>
>
> dave
> 
>
> - Original Message -
> From: "charlie griefer" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, February 11, 2003 1:29 PM
> Subject: Re: CFFORM vs FORM
>
>
> > Dave Lyons writes:
> >
> > > I distinctly remember reading in Ben Forta book cfwack, that
> this issue
> was
> > > brought up and he cleared said that it was a very good tag to use.
> > >
> > > if need be I will flip through and try to find the wording if
> necessary
> >
> > If that is in fact Ben's opinion, he's entitled to it (just as we all
> are).
> >
> > He may have recommended it because it can arguably 'speed up'
> > development...but I think the costs (not learning) are too high
> a price to
> > pay for that small convenience.
> >
> > $0.02.
> >
> > Charlie
> >
> >
> > >
> > > - Original Message -
> > > From: "Charlie Griefer" <[EMAIL PROTECTED]>
> > > To: "CF-Talk" <[EMAIL PROTECTED]>
> > > Sent: Tuesday, February 11, 2003 10:46 AM
> > > Subject: Re: CFFORM vs FORM
> > >
> > >
> > >> - Original Message -
> > >> From: "Tony Weeg" <[EMAIL PROTECTED]>
> > >> To: "CF-Talk" <[EMAIL PROTECTED]>
> > >> Sent: Tuesday, February 11, 2003 6:42 AM
> > >> Subject: RE: CFFORM vs FORM
> > >>
> > >>
> > >> > well, that makes sense for someone proficient in js :)
> > >> > for those of us who arent, it really is a blessing.
> > >> >
> > >> > NOTICE TO ALL WHO ARE NOT HIGHLY PROFICIENT IN JS
> > >> > CFMX AND CFFORM TAGS ARE OK 
> > >>
> > >> I could not disagree with this statement more.
> > >>
> > >> For the record, I've not yet played with MX...but my
> comments speak to
> the
> > >> usage of cfform in general.
> > >>
> > >> 1) You are a professional Web Developer (or some such title that
> implies
> > > the
> > >> same).  If you're not proficient in js, learn it or risk
> falling behind
> > > the
> > >> curve.
> > >>
> > >> 2) cfform can only do so much.  Can you compare two field
> values to see
> if
> > >> they're equal?  Can you say, 'if this field has a value then
> this field
> > >> cannot'?  Can you do anything past the basic validation?  By learning
> JS,
> > >> you give yourself that ability.  By relying on cfform, you are very
> > > limited
> > >> in what you can do.
> > >>
> > >> 3) If you truly think having CF do the work for you (in
> generating its
> own
> > >> JS) is 'a blessing'...you are very wrong.  It's a curse because it
> coaxes
> > >> you in to a false sense of security while others around you
> are moving
> > >> forward with javascript and learning numerous other things
> that can be
> > >> accomplished with js.  you will always be limited to
> checking to see if
> a
> > >> field is empty.  or if it's numeric.  h.  blessing.
> > >>
> > >> Not trying to come down on you.  But since you stood on the
> soapbox and
> > >> yelled to the world that it's 'OK' to be in this field (Web
> Development)
> > > and
> > >> not be profieient in JS...well, that's your opinion and
> you're entitled
> to
> > >> it.  My opinion is that if you don't know XHTML, XML,
> JavaScript, CSS,
> and
> > >> at least one server side scripting language (CF, ASP, JSP, etc)...and
> are
> > >> content to know less...then you're in for a rude awakening.
> > >>
> > >> Just my $0.02.
> > >>
> > >> Charlie
> > >>
> > >>
> > >
> >
> 
~|
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: CFLOCATION & IE 6

[Jochem van Dieten]

Matt Kornguth wrote:
> Has anyone found an issue using CFLOCATION in IE 6, where http header information 
>displays on the new url ... above the page output? This is in CF 5.0 Enterprise BTW.

Just in IE 6? Are you sure it is not a IE issue? Telnet to the server 
and manually check the right headers are sent.

~|
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: end.cfm?

[Tony Weeg]

why switch from windows to *nix :) jk, no flame war please!!!

really, I use application.cfm interchangeably with Application.cfm

honestly...i do use it either way.

...tony

Tony Weeg
Senior Web Developer
UnCertified Advanced ColdFusion Developer
Information System Design
Navtrak, Inc.
Mobile workforce monitoring, mapping & reporting
www.navtrak.net
410.548.2337 

-Original Message-
From: Lincoln Milner [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, February 11, 2003 3:53 PM
To: CF-Talk
Subject: RE: end.cfm?


I think the case thing is more *nix specific, but every training
material I've ever read on CF indicates that, regardless of platform,
you should use Application.cfm and OnRequestEnd.cfm.  So, even if you're
in Windows, should you ever port your CF app to Unix, you're prepared.

-Original Message-
From: Scott Wilhelm [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 11, 2003 3:40 PM
To: CF-Talk
Subject: RE: end.cfm?


Does case count for application.cfm too?  Or is that just for *nix
systems?

> -Original Message-
> From: Lincoln Milner [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 11, 2003 3:42 PM
> To: CF-Talk
> Subject: RE: end.cfm?
> 
> 
> Case counts, Tony.  OnRequestEnd.cfm
> 
> Shame on you...*grin*
> 
> -lincoln
> 
> -Original Message-
> From: Tony Weeg [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 11, 2003 3:26 PM
> To: CF-Talk
> Subject: RE: end.cfm?
> 
> 
> onrequestend.cfm
> 
> ...tony
> 
> Tony Weeg
> Senior Web Developer
> UnCertified Advanced ColdFusion Developer
> Information System Design
> Navtrak, Inc.
> Mobile workforce monitoring, mapping & reporting
> www.navtrak.net
> 410.548.2337 
> 
> -Original Message-
> From: Scott Wilhelm [mailto:[EMAIL PROTECTED]] 
> Sent: Tuesday, February 11, 2003 3:11 PM
> To: CF-Talk
> Subject: end.cfm?
> 
> 
> What is the file that automatically loads when a page loads?  (the one
> I'm looking for is the opposite of application.cfm)
>  
>  
> Scott Wilhelm
> Computer Technician/Web Developer
> St. Lawrence-Lewis BOCES
> PO Box 231, Outer State Street
> Canton, NY 13617
> 
> P. 315-386-4504 x 164
> F. 315-386-3395
> W.   http://www.sllboces.org
> E.[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
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

OT: Good XML, Schema, and XLST resources?

[Drew Harris]

I could really use a few really good XML, Schema, and XLST resources, I have
the XLST Cookbook by Sal Mangano but it does not provide all that I am
needing.

Thanks,
Drew Harris

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

[Ryan]

It's possible, Ben, but we've tried this with a non-testing table that
doesn't have any reserved words as field names and we get the same error.
Good eye, though, good eye, mmhmmm.

Ryan

- Original Message -
From: "Ben Doom" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 11, 2003 2:47 PM
Subject: RE: CFStoredProc


> could it be because 'DESC' is a reserved term?
>
>
> --  Ben Doom
> Programmer & General Lackey
> Moonbow Software, Inc
>
> : -Original Message-
> : From: Ryan [mailto:[EMAIL PROTECTED]]
> : Sent: Tuesday, February 11, 2003 3:26 PM
> : To: CF-Talk
> : Subject: Re: CFStoredProc
> :
> :
> : Thanks, but that didn't work.  We're using DB2, Solaris 8, and
> : Apache 2.13.
> :
> :
> : - Original Message -
> : From: "<"Everett>,Al"" <[EMAIL PROTECTED]>
> : To: "CF-Talk" <[EMAIL PROTECTED]>
> : Sent: Tuesday, February 11, 2003 2:17 PM
> : Subject: RE: CFStoredProc
> :
> :
> : > I've found that cfcprocresult should be last. (Oracle 8i/9i). Try
that.
> : >
> : > > -Original Message-
> : > > From: Nuovo [mailto:[EMAIL PROTECTED]]
> : > > Sent: Tuesday, February 11, 2003 3:13 PM
> : > > To: CF-Talk
> : > > Subject: CFStoredProc
> : > >
> : > >
> : > > Ok, gang,
> : > >
> : > > The following stored proc call works beautifully:
> : > >
> : > > 
> : > >  
> : > > 
> : > >
> : > > It inserts a record into our test table and returns the ADID
> : > > (INTEGER, autonumber) and DESC (CHAR, defaults to "TEST") fields.
> : > >
> : > > Then I try to pass the proc a value for DESC as follows:
> : > >
> : > > 
> : > >  
> : > >   : > > cfsqltype="CF_SQL_CHAR" type="In">
> : > > 
> : > >
> : > > And I get the following error:
> : > >
> : > >   Error Diagnostic Information
> : > >   DB2 Error Code = -10013
> : > >
> : > >   [IBM][CLI Driver][DB2/SUN] SQL10013N The specified
> : > > library "/export/home/testingUser/sqllib/function/test" could
> : > > not be loaded.
> : > >
> : > >
> : > >
> : > >   SQL = "test"
> : > >
> : > >   Data Source = "TESTING"
> : > >
> : > >
> : > >   The error occurred while processing an element with a
> : > > general identifier of (CFSTOREDPROC), occupying document
> : > > position (15:1) to (15:61).
> : > >
> : > >
> : > >   Date/Time: Tue Feb 11 13:56:01 2003
> : > >   Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT
> : > > 5.0; T312461; .NET CLR 1.0.3705)
> : > >   Remote Address:
> : > >
> : > >
> : > >
> : > >
> : > > I'm stumped, any thoughts?
> : > >
> : > > Thanks,
> : > >
> : > > Ryan
> : > >
> : >
> :
> 
~|
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
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: end.cfm?

[Ben Doom]

Windows systems are case insensitive, so it doesn't matter for either
(except as a stylistic issue).

However, *nix systems are all case sensitive (with the sort-of-exception of
Mac OS X) so it should be Application.cfm

If you expect to /ever/ port your apps to a nix box, use correct
capitalization and such.  If it'll be a cold day on the sun before you try
to migrate off Windows, don't worry about it.

and thus, I start the Holy Wars about capitalization, style, and porting.
*sigh*


--  Ben Doom
Programmer & General Lackey
Moonbow Software, Inc

: -Original Message-
: From: Scott Wilhelm [mailto:[EMAIL PROTECTED]]
: Sent: Tuesday, February 11, 2003 3:40 PM
: To: CF-Talk
: Subject: RE: end.cfm?
:
:
: Does case count for application.cfm too?  Or is that just for *nix
: systems?
:
: > -Original Message-
: > From: Lincoln Milner [mailto:[EMAIL PROTECTED]]
: > Sent: Tuesday, February 11, 2003 3:42 PM
: > To: CF-Talk
: > Subject: RE: end.cfm?
: >
: >
: > Case counts, Tony.  OnRequestEnd.cfm
: >
: > Shame on you...*grin*
: >
: > -lincoln
: >
: > -Original Message-
: > From: Tony Weeg [mailto:[EMAIL PROTECTED]]
: > Sent: Tuesday, February 11, 2003 3:26 PM
: > To: CF-Talk
: > Subject: RE: end.cfm?
: >
: >
: > onrequestend.cfm
: >
: > ...tony
: >
: > Tony Weeg
: > Senior Web Developer
: > UnCertified Advanced ColdFusion Developer
: > Information System Design
: > Navtrak, Inc.
: > Mobile workforce monitoring, mapping & reporting
: > www.navtrak.net
: > 410.548.2337
: >
: > -Original Message-
: > From: Scott Wilhelm [mailto:[EMAIL PROTECTED]]
: > Sent: Tuesday, February 11, 2003 3:11 PM
: > To: CF-Talk
: > Subject: end.cfm?
: >
: >
: > What is the file that automatically loads when a page loads?  (the one
: > I'm looking for is the opposite of application.cfm)
: >
: >
: > Scott Wilhelm
: > Computer Technician/Web Developer
: > St. Lawrence-Lewis BOCES
: > PO Box 231, Outer State Street
: > Canton, NY 13617
: >
: > P. 315-386-4504 x 164
: > F. 315-386-3395
: > W.   http://www.sllboces.org
: > E.[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: end.cfm?

[Lincoln Milner]

I think the case thing is more *nix specific, but every training material I've ever 
read on CF indicates that, regardless of platform, you should use Application.cfm and 
OnRequestEnd.cfm.  So, even if you're in Windows, should you ever port your CF app to 
Unix, you're prepared.

-Original Message-
From: Scott Wilhelm [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 11, 2003 3:40 PM
To: CF-Talk
Subject: RE: end.cfm?


Does case count for application.cfm too?  Or is that just for *nix
systems?

> -Original Message-
> From: Lincoln Milner [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 11, 2003 3:42 PM
> To: CF-Talk
> Subject: RE: end.cfm?
> 
> 
> Case counts, Tony.  OnRequestEnd.cfm
> 
> Shame on you...*grin*
> 
> -lincoln
> 
> -Original Message-
> From: Tony Weeg [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 11, 2003 3:26 PM
> To: CF-Talk
> Subject: RE: end.cfm?
> 
> 
> onrequestend.cfm
> 
> ...tony
> 
> Tony Weeg
> Senior Web Developer
> UnCertified Advanced ColdFusion Developer
> Information System Design
> Navtrak, Inc.
> Mobile workforce monitoring, mapping & reporting
> www.navtrak.net
> 410.548.2337 
> 
> -Original Message-
> From: Scott Wilhelm [mailto:[EMAIL PROTECTED]] 
> Sent: Tuesday, February 11, 2003 3:11 PM
> To: CF-Talk
> Subject: end.cfm?
> 
> 
> What is the file that automatically loads when a page loads?  (the one
> I'm looking for is the opposite of application.cfm)
>  
>  
> Scott Wilhelm
> Computer Technician/Web Developer
> St. Lawrence-Lewis BOCES
> PO Box 231, Outer State Street
> Canton, NY 13617
> 
> P. 315-386-4504 x 164
> F. 315-386-3395
> W.   http://www.sllboces.org
> E.[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
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: end.cfm?

[Tony Weeg]

hm I use application.cfm on every directory
we have one in.so, case may count for some systems
but on win2k/xp and iis and cfmx it doesn't matter 

;) grin

...tony

Tony Weeg
Senior Web Developer
UnCertified Advanced ColdFusion Developer
Information System Design
Navtrak, Inc.
Mobile workforce monitoring, mapping & reporting
www.navtrak.net
410.548.2337 

-Original Message-
From: Scott Wilhelm [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, February 11, 2003 3:40 PM
To: CF-Talk
Subject: RE: end.cfm?


Does case count for application.cfm too?  Or is that just for *nix
systems?

> -Original Message-
> From: Lincoln Milner [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 11, 2003 3:42 PM
> To: CF-Talk
> Subject: RE: end.cfm?
> 
> 
> Case counts, Tony.  OnRequestEnd.cfm
> 
> Shame on you...*grin*
> 
> -lincoln
> 
> -Original Message-
> From: Tony Weeg [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 11, 2003 3:26 PM
> To: CF-Talk
> Subject: RE: end.cfm?
> 
> 
> onrequestend.cfm
> 
> ...tony
> 
> Tony Weeg
> Senior Web Developer
> UnCertified Advanced ColdFusion Developer
> Information System Design
> Navtrak, Inc.
> Mobile workforce monitoring, mapping & reporting
> www.navtrak.net
> 410.548.2337 
> 
> -Original Message-
> From: Scott Wilhelm [mailto:[EMAIL PROTECTED]] 
> Sent: Tuesday, February 11, 2003 3:11 PM
> To: CF-Talk
> Subject: end.cfm?
> 
> 
> What is the file that automatically loads when a page loads?  (the one
> I'm looking for is the opposite of application.cfm)
>  
>  
> Scott Wilhelm
> Computer Technician/Web Developer
> St. Lawrence-Lewis BOCES
> PO Box 231, Outer State Street
> Canton, NY 13617
> 
> P. 315-386-4504 x 164
> F. 315-386-3395
> W.   http://www.sllboces.org
> E.[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
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

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

Java and CFMX

[brook]

Hello,

I am new to Java and am curious how or if Java can be used with CFMX? Can 
you write JAVA and integrate it with a CFMX Professional Application or 
does the server need to be Enterprise?

Brook


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

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

RE: CFStoredProc

[Ben Doom]

could it be because 'DESC' is a reserved term?


--  Ben Doom
Programmer & General Lackey
Moonbow Software, Inc

: -Original Message-
: From: Ryan [mailto:[EMAIL PROTECTED]]
: Sent: Tuesday, February 11, 2003 3:26 PM
: To: CF-Talk
: Subject: Re: CFStoredProc
:
:
: Thanks, but that didn't work.  We're using DB2, Solaris 8, and
: Apache 2.13.
:
:
: - Original Message -
: From: "<"Everett>,Al"" <[EMAIL PROTECTED]>
: To: "CF-Talk" <[EMAIL PROTECTED]>
: Sent: Tuesday, February 11, 2003 2:17 PM
: Subject: RE: CFStoredProc
:
:
: > I've found that cfcprocresult should be last. (Oracle 8i/9i). Try that.
: >
: > > -Original Message-
: > > From: Nuovo [mailto:[EMAIL PROTECTED]]
: > > Sent: Tuesday, February 11, 2003 3:13 PM
: > > To: CF-Talk
: > > Subject: CFStoredProc
: > >
: > >
: > > Ok, gang,
: > >
: > > The following stored proc call works beautifully:
: > >
: > > 
: > >  
: > > 
: > >
: > > It inserts a record into our test table and returns the ADID
: > > (INTEGER, autonumber) and DESC (CHAR, defaults to "TEST") fields.
: > >
: > > Then I try to pass the proc a value for DESC as follows:
: > >
: > > 
: > >  
: > >   > cfsqltype="CF_SQL_CHAR" type="In">
: > > 
: > >
: > > And I get the following error:
: > >
: > >   Error Diagnostic Information
: > >   DB2 Error Code = -10013
: > >
: > >   [IBM][CLI Driver][DB2/SUN] SQL10013N The specified
: > > library "/export/home/testingUser/sqllib/function/test" could
: > > not be loaded.
: > >
: > >
: > >
: > >   SQL = "test"
: > >
: > >   Data Source = "TESTING"
: > >
: > >
: > >   The error occurred while processing an element with a
: > > general identifier of (CFSTOREDPROC), occupying document
: > > position (15:1) to (15:61).
: > >
: > >
: > >   Date/Time: Tue Feb 11 13:56:01 2003
: > >   Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT
: > > 5.0; T312461; .NET CLR 1.0.3705)
: > >   Remote Address:
: > >
: > >
: > >
: > >
: > > I'm stumped, any thoughts?
: > >
: > > Thanks,
: > >
: > > Ryan
: > >
: >
: 
~|
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: CFLOCK

[Ben Doom]

Author's note.  This is not meant to be patronizing or anything.  It's kind
of an oversimplification, but it's intended to help you (and anyone else who
wants to read it) visualize the problems.

Okay.  Pretend that data storage is a bunch of bins.  Anyone can look at
shared bins, like the session, client, application, and server bins.  Anyone
can write to them as well (for the most part).

Now, let's pretend that you've got a bunch of office workers who use these.
There are two problems associated with sharing all this stuff.

One:  garbling things.   Let's pretend that you have a long memo stored in
(what else?) application.memo.  Bob the janitor is taking the memo out of
the bin a paragraph at a time (he's a slow reader).  Normally, this isn't a
problem.  Until Jim the manager starts rewriting the memo and sticks the
paragraphs in the bin while Bob isn't looking..  Unfortunately, Bob & Jim
aren't smart enough to co-ordinate this, so what Bob gets is the first half
of the old memo and the last half of the new memo.  So he gets a garbled
memo.

Two:  race conditions.  Fred needs to remember something, so he sticks in in
application.something.  Unfortunately, Herman needs to remember a slightly
different version, and sticks it in application.something just after Fred
does.  Now, when Fred goes to read what he put there, he gets Herman's
version.

Okay, now we have CFLOCK.  It's like a note on the front of the bin.  If
it's a readonly lock, it says "You can read this, but don't change it until
I remove the note."  If it's an exclusive lock, it says "I'm using this,
wait your turn!"



HTH.


--  Ben Doom
Programmer & General Lackey
Moonbow Software, Inc

: -Original Message-
: From: Scott Wilhelm [mailto:[EMAIL PROTECTED]]
: Sent: Tuesday, February 11, 2003 3:17 PM
: To: CF-Talk
: Subject: CFLOCK
:
:
: Can someone please explain to me, in very simply terms, what CFLOCK
: does, and why/when/where I should use it?
:
: I'm trying to build an application, and put it together as proper as can
: be, but for some reason, my brain doesn't want to comprehen CFLOCK.
:
: Thanks,
:
: Scott
:
:
: Scott Wilhelm
: Computer Technician/Web Developer
: St. Lawrence-Lewis BOCES
: PO Box 231, Outer State Street
: Canton, NY 13617
:
: P. 315-386-4504 x 164
: F. 315-386-3395
: W.   http://www.sllboces.org
: E.[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

Re: CFLOCK

[Fregas]

CFLOCK is for single threaded access.  Coldfusion is a multi-threaded
application which means that two people can access coldfusion at the exact
same time and therefore code that you write could potentially be accessed by
two people at the exact same time.  This is undesireable in the case of
application or session variables because one person might read from that
variable while another might write to it.  Also, in some datbase actions,
you might not two people accessing the same record at the same time or
something (although your database software might have features to handle
this better than CFLOCK.)

You use CFLOCK when you want a portion of code to be single-threaded, that
is, that span of code, even if two people access the page simulataneously,
will process one person first, then the next.  This may slow down
performance a bit on that code, but sometimes is necessary.

Fregas

- Original Message -
From: "Scott Wilhelm" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 11, 2003 2:17 PM
Subject: CFLOCK


> Can someone please explain to me, in very simply terms, what CFLOCK
> does, and why/when/where I should use it?
>
> I'm trying to build an application, and put it together as proper as can
> be, but for some reason, my brain doesn't want to comprehen CFLOCK.
>
> Thanks,
>
> Scott
>
>
> Scott Wilhelm
> Computer Technician/Web Developer
> St. Lawrence-Lewis BOCES
> PO Box 231, Outer State Street
> Canton, NY 13617
>
> P. 315-386-4504 x 164
> F. 315-386-3395
> W.   http://www.sllboces.org
> E.[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

RE: CFLOCK

[Mike Brunt]

Scott it can be a tough thing to grasp, if you are familiar with databases
think of it as equivalent to a record in a database.  You don't want two
people to write to a record at the same time.  Similarly, you don't want
people reading a record while someone is writing to it.  Typically we lock
all writes to creating a memory scoped variable (Application, Server,
Session) with "exclusive" locks and all reads with a "read-only" lock and we
use the variables scope as the setting in the CFLOCK tag.

Which version of CF you use is also important, anything up to CFMX conforms
to what I said in the above paragraph.  Because CFMX runs on Java locking to
avoid shared memory scope corruption is not necessary, however locking to
prevent "race-conditions" is.  If you are on CFMX this article (watch for
url wrapping)
http://www.macromedia.com/v1/Handlers/index.cfm?ID=23021&Method=full is good
to check.

Another tip, if you take a look at our blog http://www.webapper.net and do a
search you will find tips and links to other articles that may help you.

Hth and good luck.

Kind Regards - Mike Brunt
Webapper Services LLC
Web Site http://www.webapper.com
Blog http://www.webapper.net

Webapper 

-Original Message-
From: Scott Wilhelm [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 11, 2003 12:17 PM
To: CF-Talk
Subject: CFLOCK

Can someone please explain to me, in very simply terms, what CFLOCK
does, and why/when/where I should use it?

I'm trying to build an application, and put it together as proper as can
be, but for some reason, my brain doesn't want to comprehen CFLOCK.

Thanks,

Scott


Scott Wilhelm
Computer Technician/Web Developer
St. Lawrence-Lewis BOCES
PO Box 231, Outer State Street
Canton, NY 13617

P. 315-386-4504 x 164
F. 315-386-3395
W.   http://www.sllboces.org
E.[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

RE: end.cfm?

[Scott Wilhelm]

Does case count for application.cfm too?  Or is that just for *nix
systems?

> -Original Message-
> From: Lincoln Milner [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 11, 2003 3:42 PM
> To: CF-Talk
> Subject: RE: end.cfm?
> 
> 
> Case counts, Tony.  OnRequestEnd.cfm
> 
> Shame on you...*grin*
> 
> -lincoln
> 
> -Original Message-
> From: Tony Weeg [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 11, 2003 3:26 PM
> To: CF-Talk
> Subject: RE: end.cfm?
> 
> 
> onrequestend.cfm
> 
> ...tony
> 
> Tony Weeg
> Senior Web Developer
> UnCertified Advanced ColdFusion Developer
> Information System Design
> Navtrak, Inc.
> Mobile workforce monitoring, mapping & reporting
> www.navtrak.net
> 410.548.2337 
> 
> -Original Message-
> From: Scott Wilhelm [mailto:[EMAIL PROTECTED]] 
> Sent: Tuesday, February 11, 2003 3:11 PM
> To: CF-Talk
> Subject: end.cfm?
> 
> 
> What is the file that automatically loads when a page loads?  (the one
> I'm looking for is the opposite of application.cfm)
>  
>  
> Scott Wilhelm
> Computer Technician/Web Developer
> St. Lawrence-Lewis BOCES
> PO Box 231, Outer State Street
> Canton, NY 13617
> 
> P. 315-386-4504 x 164
> F. 315-386-3395
> W.   http://www.sllboces.org
> E.[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
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

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

RE: end.cfm?

[Lincoln Milner]

Case counts, Tony.  OnRequestEnd.cfm

Shame on you...*grin*

-lincoln

-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 11, 2003 3:26 PM
To: CF-Talk
Subject: RE: end.cfm?


onrequestend.cfm

...tony

Tony Weeg
Senior Web Developer
UnCertified Advanced ColdFusion Developer
Information System Design
Navtrak, Inc.
Mobile workforce monitoring, mapping & reporting
www.navtrak.net
410.548.2337 

-Original Message-
From: Scott Wilhelm [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, February 11, 2003 3:11 PM
To: CF-Talk
Subject: end.cfm?


What is the file that automatically loads when a page loads?  (the one
I'm looking for is the opposite of application.cfm)
 
 
Scott Wilhelm
Computer Technician/Web Developer
St. Lawrence-Lewis BOCES
PO Box 231, Outer State Street
Canton, NY 13617

P. 315-386-4504 x 164
F. 315-386-3395
W.   http://www.sllboces.org
E.[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
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: cftransaction HELP Please...

[Andy Ousterhout]

Dave,

So with CFTransaction, the only reason to use  is if you want
additional error handling?  For example, if I want details every time this
fails, I could use try within a transaction to capture failure reason?  Is
there a better way?

Do you normally attempt to capture the reason that a transaction fails?

Andy

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 11, 2003 1:55 PM
To: CF-Talk
Subject: RE: cftransaction HELP Please...


> Here is the outline of the code that should work.  Just
> plug in your queries:
>
> ... CFTRANSACTION with nested CFTRYs snipped ...

Yikes! You don't need to use exception handling to rollback the transaction
- that's what CFTRANSACTION itself is for! If you have three queries in a
CFTRANSACTION, and any of them fail, they'll all be rolled back, as long as
all queries use the same database connection information (datasource,
username, password).

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
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: value in a specific range>

[Raymond Camden]

Do you really need a udf for it?


...


If you do...


function inRange(a,min,max) {
return a gte min and a lte max;
}


===
Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc

Email: [EMAIL PROTECTED]
WWW  : www.camdenfamily.com/morpheus
Yahoo IM : morpheus

"My ally is the Force, and a powerful ally it is." - Yoda 

> -Original Message-
> From: "Bosky [mailto:"Bosky] 
> Sent: Tuesday, February 11, 2003 2:31 PM
> To: CF-Talk
> Subject: UDF: value in a specific range>
> 
> 
> Does anyone know of a function that would check if a value is 
> in within a range of two numbers?
> 
> Say I wanted to find out if ' -.50' in the range of '-1.50 and .25'. 
> 
> Regards,
> Dave Bosky
> Sr. Multimedia Web Designer
> Horry Telephone Cooperative, Inc. 
> office: (843)369-8613
> [EMAIL PROTECTED]
> 
> 
> 
> HTC Disclaimer:  The information contained in this message 
> may be privileged and confidential and protected from 
> disclosure. If the reader of this message is not the intended 
> recipient, or an employee or agent responsible for delivering 
> this message to the intended recipient, you are hereby 
> notified that any dissemination, distribution or copying of 
> this communication is strictly prohibited.  If you have 
> received this communication in error, please notify us 
> immediately by replying to the message and deleting it from 
> your computer.  Thank you. 
> 
~|
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: CFLOCK

[Ryan]

Scott,

Basically, use cflock around anything to do with application, server, or
session variables.  When you set one of those variables, set the type to
"exclusive".  When you read one, use a "readonly" lock.  See below:









Now you can use "request.test" for the rest of your page without locking and
unlocking everytime you need it.

Hope that helps,

Ryan

- Original Message -
From: "Scott Wilhelm" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 11, 2003 2:17 PM
Subject: CFLOCK


> Can someone please explain to me, in very simply terms, what CFLOCK
> does, and why/when/where I should use it?
>
> I'm trying to build an application, and put it together as proper as can
> be, but for some reason, my brain doesn't want to comprehen CFLOCK.
>
> Thanks,
>
> Scott
>
>
> Scott Wilhelm
> Computer Technician/Web Developer
> St. Lawrence-Lewis BOCES
> PO Box 231, Outer State Street
> Canton, NY 13617
>
> P. 315-386-4504 x 164
> F. 315-386-3395
> W.   http://www.sllboces.org
> E.[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
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: SOT

[mdinowit]

Please continue this on the CF-OT list or CF-Community. I'm quite sure they
would have no problem with the puns there and it'll be on topic.


> I'm just going to pretend /real hard/ that it has to do with linguistics,
> and not just cunning linguists.
>
>
> --  Ben Doom
> Programmer & General Lackey
> Moonbow Software, Inc
>
> : -Original Message-
> : From: Dave Watts [mailto:[EMAIL PROTECTED]]
> : Sent: Tuesday, February 11, 2003 3:11 PM
> : To: CF-Talk
> : Subject: RE: SOT
> :
> :
> : > What does SOT mean anyway? So Off Topic? Sort of Off Topic?
> : > Somebody's Other Tongue?
> :
> : If you really think it might mean "somebody's other tongue", I
> : don't want to
> : know what other mailing lists you're on.
> :
> : 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: end.cfm?

[Dave Watts]

> What is the file that automatically loads when a page 
> loads?  (the one I'm looking for is the opposite of 
> application.cfm)

The file is OnRequestEnd.cfm. It's not really the opposite of
Application.cfm, though; it's only used when the Application.cfm in the same
directory is also used.

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
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: CFLOCK

[AEverett]

Here's what Uncle Ben has to say:

http://www.cffaq.com/faq.cfm?f=3#q15

> -Original Message-
> From: Scott Wilhelm [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 11, 2003 3:17 PM
> To: CF-Talk
> Subject: CFLOCK
> 
> 
> Can someone please explain to me, in very simply terms, what CFLOCK
> does, and why/when/where I should use it?
>  
> I'm trying to build an application, and put it together as 
> proper as can
> be, but for some reason, my brain doesn't want to comprehen CFLOCK.
>  
> Thanks,
>  
> Scott
>  
>  
> Scott Wilhelm
> Computer Technician/Web Developer
> St. Lawrence-Lewis BOCES
> PO Box 231, Outer State Street
> Canton, NY 13617
> 
> P. 315-386-4504 x 164
> F. 315-386-3395
> W.   http://www.sllboces.org
> E.[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
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: SOT

[John Stanley]

lol

-Original Message-
From: Ben Doom [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 11, 2003 3:19 PM
To: CF-Talk
Subject: RE: SOT


I'm just going to pretend /real hard/ that it has to do with linguistics,
and not just cunning linguists.


--  Ben Doom
Programmer & General Lackey
Moonbow Software, Inc

: -Original Message-
: From: Dave Watts [mailto:[EMAIL PROTECTED]]
: Sent: Tuesday, February 11, 2003 3:11 PM
: To: CF-Talk
: Subject: RE: SOT
:
:
: > What does SOT mean anyway? So Off Topic? Sort of Off Topic?
: > Somebody's Other Tongue?
:
: If you really think it might mean "somebody's other tongue", I
: don't want to
: know what other mailing lists you're on.
:
: 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
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: CFStoredProc

[Ryan]

Thanks, but that didn't work.  We're using DB2, Solaris 8, and Apache 2.13.


- Original Message -
From: "<"Everett>,Al"" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 11, 2003 2:17 PM
Subject: RE: CFStoredProc


> I've found that cfcprocresult should be last. (Oracle 8i/9i). Try that.
>
> > -Original Message-
> > From: Nuovo [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, February 11, 2003 3:13 PM
> > To: CF-Talk
> > Subject: CFStoredProc
> >
> >
> > Ok, gang,
> >
> > The following stored proc call works beautifully:
> >
> > 
> >  
> > 
> >
> > It inserts a record into our test table and returns the ADID
> > (INTEGER, autonumber) and DESC (CHAR, defaults to "TEST") fields.
> >
> > Then I try to pass the proc a value for DESC as follows:
> >
> > 
> >  
> >   > cfsqltype="CF_SQL_CHAR" type="In">
> > 
> >
> > And I get the following error:
> >
> >   Error Diagnostic Information
> >   DB2 Error Code = -10013
> >
> >   [IBM][CLI Driver][DB2/SUN] SQL10013N The specified
> > library "/export/home/testingUser/sqllib/function/test" could
> > not be loaded.
> >
> >
> >
> >   SQL = "test"
> >
> >   Data Source = "TESTING"
> >
> >
> >   The error occurred while processing an element with a
> > general identifier of (CFSTOREDPROC), occupying document
> > position (15:1) to (15:61).
> >
> >
> >   Date/Time: Tue Feb 11 13:56:01 2003
> >   Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT
> > 5.0; T312461; .NET CLR 1.0.3705)
> >   Remote Address:
> >
> >
> >
> >
> > I'm stumped, any thoughts?
> >
> > Thanks,
> >
> > Ryan
> >
> 
~|
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
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

UDF: value in a specific range>

[Dave.Bosky]

Does anyone know of a function that would check if a value is 
in within a range of two numbers?

Say I wanted to find out if ' -.50' in the range of '-1.50 and .25'. 

Regards,
Dave Bosky
Sr. Multimedia Web Designer
Horry Telephone Cooperative, Inc. 
office: (843)369-8613
[EMAIL PROTECTED]



HTC Disclaimer:  The information contained in this message may be privileged and 
confidential and protected from disclosure. If the reader of this message is not the 
intended recipient, or an employee or agent responsible for delivering this message to 
the intended recipient, you are hereby notified that any dissemination, distribution 
or copying of this communication is strictly prohibited.  If you have received this 
communication in error, please notify us immediately by replying to the message and 
deleting it from your computer.  Thank you.
~|
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: end.cfm?

[Dave Sueltenfuss]

OnRequestEnd.cfm

Thanks
 
Dave Sueltenfuss
Application Developer
Arch Wireless
Phone: 508-870-6711
Fax: 508-870-8011
Email: [EMAIL PROTECTED]



-Original Message-
From: Scott Wilhelm [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, February 11, 2003 3:11 PM
To: CF-Talk
Subject: end.cfm?


What is the file that automatically loads when a page loads?  (the one I'm
looking for is the opposite of application.cfm)
 
 
Scott Wilhelm
Computer Technician/Web Developer
St. Lawrence-Lewis BOCES
PO Box 231, Outer State Street
Canton, NY 13617

P. 315-386-4504 x 164
F. 315-386-3395
W.   http://www.sllboces.org
E.[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
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

OT RE: SOT

[Mike Brunt]

In England a SOT is someone who is inebriated as in "drunken old sot" !

Kind Regards - Mike Brunt
Webapper Services LLC
Web Site http://www.webapper.com
Blog http://www.webapper.net

Webapper 

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 11, 2003 12:11 PM
To: CF-Talk
Subject: RE: SOT

> What does SOT mean anyway? So Off Topic? Sort of Off Topic?
> Somebody's Other Tongue?

If you really think it might mean "somebody's other tongue", I don't want to
know what other mailing lists you're on.

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
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: DSNless connection

[Rodney.Bruce]

Thanks for the info, will have to experiment and see what happens

-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 11, 2003 12:30 PM
To: CF-Talk
Subject: Re: DSNless connection


Sam Neff posted this a while back for mehaven't tested, but I'll betcha
it'll work:

Sam Neff said:

As earlier posters stated, DSN-less connections are no longer directly
supported in CFMX because they are not supported in JDBC.  However, there is
an easy work around.

Jet (MS Access database engine) supports a special use of the IN keyword in
the FROM clause of a query to specify another source database.  The
secondary source can be a Jet (Access) database or any Jet accessible source
(Excel, DBase, Text, etc.) or any ODBC connection (dynamic connect string).

To set this up create an empty Access database and then create a datasource
for this database named "PassThroughMDB".

Then you can run queries like:


  SELECT *
  FROM some_table_in_another_db IN 'c:\wherever\other_database.mdb'


You can experiment with paths to an MDB, XLS, etc. or you can use an ODBC
connect string.  To use ODBC I believe you have prepend it with ODBC; as in

FROM wherever IN 'ODBC; [dynamic odbc connect string]'

See MS Access help for more information.  You can also view some examples in
MSDN Library.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/htm
l/acsqlINX.asp

Another option is to create linked tables in the Access database.  I know
you can do this with DAO, and you may be able to do it with some combination
of ADOX/JRO or even with DDL through CFQUERY.

If using MSSQL or Oracle (and if so why would you need a dynamic connect
string?) you can use linked databases (perhaps they use a different term,
but the concept exists in both).

Good luck!

Sam

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com
- Original Message -
From: <"Bruce>; >
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 11, 2003 11:13 AM
Subject: DSNless connection


> Hello all
>
>
> We are looking into upgrading to CFMX from CF5, but one issue we
> have not been able to overcome is that
> CFMX does not have DSNless db connections.
> Is there a way in CFMX to create a DSN connection on the fly, i.e. not
> having to go to CF Admin to create the mapping?
>
> Currently we have engineers that go all over the world (Europe, Japan,
> Korea, etc), so they some times have very limited
> access to GOOD internet access.
>
> SO, We have developed an MS ACCESS db application that they take a copy
of,
> with them to what every site they are going to survey.
>
> Upon returning they upload the db to the website.
>
> Currently the db is renamed at upload to conform to the surveyed sites
> naming convention and the db dir is saved to table on the server(central
db)
> and later this is pulled to create the DSNless connection to access the
> uploaded db,
> for displaying info on the website.
>
> Is there a way in CFMX to create the DSN connection when the db is
uploaded?
> Hope I have explained this enough.
>
>
> Thanks
> Rodney
>
>
>
> 

~|
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: end.cfm?

[Mike Brunt]

OnRequestEnd.cfm

Kind Regards - Mike Brunt
Webapper Services LLC
Web Site http://www.webapper.com
Blog http://www.webapper.net

Webapper 

-Original Message-
From: Scott Wilhelm [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 11, 2003 12:11 PM
To: CF-Talk
Subject: end.cfm?

What is the file that automatically loads when a page loads?  (the one
I'm looking for is the opposite of application.cfm)


Scott Wilhelm
Computer Technician/Web Developer
St. Lawrence-Lewis BOCES
PO Box 231, Outer State Street
Canton, NY 13617

P. 315-386-4504 x 164
F. 315-386-3395
W.   http://www.sllboces.org
E.[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
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: CF runs as what user in linux

[Brian Scandale]

Ahhh... the standard install has it running as apache.
Thanks

At 11:23 AM 2/11/03, you wrote:
>Depends what you install it as.
>
>ps -aux (as root) will give you list of the processes and which user they
>are running under.
>
>WG
>
>-Original Message-
>From: Brian Scandale [mailto:[EMAIL PROTECTED]]
>Sent: 11 February 2003 19:19
>To: CF-Talk
>Subject: CF runs as what user in linux
>
>
>what user does coldfusion run as in linux?
>thanks,
>Brian
>
>
>
~|
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
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: end.cfm?

[Tony Weeg]

onrequestend.cfm

...tony

Tony Weeg
Senior Web Developer
UnCertified Advanced ColdFusion Developer
Information System Design
Navtrak, Inc.
Mobile workforce monitoring, mapping & reporting
www.navtrak.net
410.548.2337 

-Original Message-
From: Scott Wilhelm [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, February 11, 2003 3:11 PM
To: CF-Talk
Subject: end.cfm?


What is the file that automatically loads when a page loads?  (the one
I'm looking for is the opposite of application.cfm)
 
 
Scott Wilhelm
Computer Technician/Web Developer
St. Lawrence-Lewis BOCES
PO Box 231, Outer State Street
Canton, NY 13617

P. 315-386-4504 x 164
F. 315-386-3395
W.   http://www.sllboces.org
E.[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
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: end.cfm?

[Jerry Johnson]

OnRequestEnd.cfm

Jerry Johnson

>>> [EMAIL PROTECTED] 02/11/03 03:10PM >>>
What is the file that automatically loads when a page loads?  (the one
I'm looking for is the opposite of application.cfm)
 
 
Scott Wilhelm
Computer Technician/Web Developer
St. Lawrence-Lewis BOCES
PO Box 231, Outer State Street
Canton, NY 13617

P. 315-386-4504 x 164
F. 315-386-3395
W.   http://www.sllboces.org 
E.[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
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: end.cfm?

[Scott Wilhelm]

Sorry, I found in...OnRequestEnd.cfm...

> -Original Message-
> From: Scott Wilhelm 
> Sent: Tuesday, February 11, 2003 3:11 PM
> To: CF-Talk
> Subject: end.cfm?
> 
> 
> What is the file that automatically loads when a page loads?  (the one
> I'm looking for is the opposite of application.cfm)
>  
>  
> Scott Wilhelm
> Computer Technician/Web Developer
> St. Lawrence-Lewis BOCES
> PO Box 231, Outer State Street
> Canton, NY 13617
> 
> P. 315-386-4504 x 164
> F. 315-386-3395
> W.   http://www.sllboces.org
> E.[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
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

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

RE: end.cfm?

[John Stanley]

OnRequestEnd.cfm

-Original Message-
From: Scott Wilhelm [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 11, 2003 3:11 PM
To: CF-Talk
Subject: end.cfm?


What is the file that automatically loads when a page loads?  (the one
I'm looking for is the opposite of application.cfm)
 
 
Scott Wilhelm
Computer Technician/Web Developer
St. Lawrence-Lewis BOCES
PO Box 231, Outer State Street
Canton, NY 13617

P. 315-386-4504 x 164
F. 315-386-3395
W.   http://www.sllboces.org
E.[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
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

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

RE: end.cfm?

[AEverett]

> What is the file that automatically loads when a page loads?  (the one
> I'm looking for is the opposite of application.cfm)

OnRequestEnd.cfm

I believe that in versions prior to MX, OnRequestEnd.cfm would only run if
there was an Application.cfm in the same directory.

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