HTTP Compression and ColdFusion

[cf-talk]

Has anyone here used IIS5's built in HTTP Compression successfully with
ColdFusion 5 or ColdFusion MX?  I was playing around with it this evening
but interestingly enough the problem I'm getting is that some of my headers
are now showing on the page.  I have experienced an error like this before
while using URLScan and changing the setting to hide what type of web server
software is in use.

HTTP Compression does not support .CFM files by default, it must be modified
in the metabase.  I used the adsutil.vbs script to add the .CFM extension.

Turning on the "Compress Application Files" option results in two headers
being displayed on the HTML page.  Turning the compress option off fixes the
problem.  I was playing with this setting on a development machine which has
had A LOT of stuff installed/removed so sometimes these "problems" pop up.

Tomorrow I'll do a quick test on a different machine to see if I get the
same results.  I was just curious if anyone here has managed to successfully
get HTTP Compression working with ColdFusion and IIS.  From what I've been
able to tell in testing it seems like a very worthwhile thing to do.

-Novak

PS - I am already aware of PipeBoost and XCompress (3rd party ISAPI filters)
but for the time being I'd prefer to have a free solution. :-)

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

RE: Slightly OT - Powered by MX logo's ?

[Benoit Hediard]

Here it is :
http://www.macromedia.com/macromedia/style_guide/buttons/


Benoit Hediard
www.benorama.com

-Message d'origine-
De : Mike Brunt [mailto:mbrunt@;webapper.com]
Envoyé : jeudi 24 octobre 2002 02:49
À : CF-Talk
Objet : Slightly OT - Powered by MX logo's ?


Can someone point me to where I can get "Powered by ColdFusion MX" logo's?

Kind Regards - Mike Brunt, CTO
Webapper
http://www.webapper.com
Downey CA Office
562.243.6255
AIM - webappermb

"Webapper - Making the NET work"



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

Re: HTTP Compression and ColdFusion

[Jochem van Dieten]

[EMAIL PROTECTED] wrote:

> Has anyone here used IIS5's built in HTTP Compression successfully 
> with ColdFusion 5 or ColdFusion MX?

I switched it on a couple of days ago for CF MX and haven't seen any 
problems. Not sure if it is a performance improvement in my situation 
though.

> Turning on the "Compress Application Files" option results in two 
> headers being displayed on the HTML page.

Which headers?

> PS - I am already aware of PipeBoost and XCompress (3rd party ISAPI 
> filters) but for the time being I'd prefer to have a free solution. :-)

Damian Wright was working on something. Check the archives.

Jochem

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

RE: Search functionality: Verity, LIKE operator, or what?

[A.Little]

Hi,

We've had exactly the same problem with our document management system - the
way we originally got around it was to use 2 verity collections,
DocumentMetaData (a collection of the database entries) and DocumentFile (a
collection of the actual document files). Then when you do the verity search
you specify both collections. You'll then need to use a query on query of
the verity search result to strip out duplicates (where a record is returned
from DocumentMetaData and DocumentFile, but they are actually for the same
document) and you can use (another) query on query to strip out the
documents that the user doesn't have access to.

This method worked fine, though we found it was a bit too slow for our
liking. Having verity search more than 1 collection at once seemed to slow
it down quite a lot, plus the fact that you've then got the extra QoQ
manipulation.

We then changed how all our searching worked by making use of the full text
indexing within SQL and storing a copy of the file (using cfx_PutImage)
within the document table. Then we wrote a stored procedure to do the actual
searching and filtering out of documents that the user doesn't have access
to. We've found this to be much quicker and it gives us more flexibility to
alter the ranking - for example, if the search term is found in the title of
the document we multiply the ranking up (it's at x1.3 at the moment, but
we're still experimenting)

Hope that helps - I'm sure there's plenty of other solutions to this

Alex


> -Original Message-
> From: David Notik [mailto:dave@;digital202.com]
> Sent: 24 October 2002 00:03
> To: CF-Talk
> Subject: Search functionality: Verity, LIKE operator, or what?
> 
> 
> Hi all:
>  
> I haven't posted to this list for awhile.  I used to post all 
> the time,
> and used to write the TipWorld ColdFusion tips many of you received.
> Good to be back in the mix.
>  
> My question:
>  
> I built a document management system of sorts.  I have all 
> the files in
> a directory. there's a database record for every file with fields such
> as: title, filename, description, keywords, and more.  The filename
> field references the actual physical file and it's all very simple.
>  
> So now I want to provide the ability to search the files. 
> with a twist.
>  
> I have a box where the user can type in keywords.  I could 
> then write a
> query which uses the LIKE operator many times and searches the various
> relevant fields for that keyword.  But is that really the 
> most efficient
> way?
>  
> I know I could create a collection.  But doesn't a collection only
> search the actual content of the physical files indexed in the
> collection?  Meaning my title, description, and keywords fields (etc.)
> wouldn't be relevant.
>  
> What do I do?
>  
> That's question one. but then let's take it a step further:
>  
> I have a securitytype associated with each file record, which denotes
> whether the logged in user has access to the file.  When a 
> user searches
> for files, I DO NOT want to display files he does not have 
> access to.  I
> can easily accomplish this using my own query (LIKE operator 
> and a WHERE
> clause that only pulls records they have access to), but if I 
> do it the
> verity way, is this possible?
>  
> Just trying to decide the best way to go about this.
>  
> I am using ColdFusion Pro MX, SQLServer 2000.
>  
> --D
>  
> ###
> David Notik
> Digital202, LLC
> Imagination gone digital.
> Web:   www.digital202.com
> E-mail:   [EMAIL PROTECTED]
> Office: (206) 575-1717
> Mobile: (206) 351-3948
> ###
>  
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

Re: Using CFEXECUTE from a Web Browser???

[Jochem van Dieten]

Dave Cordes wrote:

> I checked and ColdFusion is logged in as the "Local System Account" so 
> I don't think it could be a permissions problem.

I'm not so sure about that.

> I found some other posts on the ColdFusion Support Forums that would 
> lead me to believe that your second point about timing out is the 
> cause. Here is the link that talks about it.

2 issues:

CF MX always waits for the entire period specified in the timeout 
instead of the shortest of the timeout and the process finishing (but 
you still haven't told us which version/OS/servicepack you use).

Every version of CF will wait forever on your specific code because if 
you call cmd.exe you need the /c parameter.


> I read somewhere that Macromedia has no current plans to fix it so 
> that's not a good sign.

http://www.macromedia.com/support/email/wishform/?6213=3

Jochem

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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.

Re: HTTP Compression and ColdFusion

[cf-talk]

Running my "test.cfm" normally I get the following output:

- Snip -
Done 10.0.0.102
- Snip -


But running "test.cfm" with the "Compress Application Files" turned on I get
the following output:

- Snip -
Content-type: text/html
Page-Completion-Status: Normal

Done


10.0.0.102
- Snip -

Interesting huh?

Once again, it's worth mentioning that this development box is "posessed"
and probably not the best candidate for such a test.  I'll try it on a
different box tomorrow and report my findings.  I was just curious to know
if anyone out there has done it successfully or if this was a bug in
CF/Microsoft just like the URLScan/CF issue (different thread, I won't
bother with details here).

-Novak


- Original Message -
From: "Jochem van Dieten" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, October 24, 2002 12:58 AM
Subject: Re: HTTP Compression and ColdFusion


> [EMAIL PROTECTED] wrote:
>
> > Has anyone here used IIS5's built in HTTP Compression successfully
> > with ColdFusion 5 or ColdFusion MX?
>
> I switched it on a couple of days ago for CF MX and haven't seen any
> problems. Not sure if it is a performance improvement in my situation
> though.
>
> > Turning on the "Compress Application Files" option results in two
> > headers being displayed on the HTML page.
>
> Which headers?
>
> > PS - I am already aware of PipeBoost and XCompress (3rd party ISAPI
> > filters) but for the time being I'd prefer to have a free solution. :-)
>
> Damian Wright was working on something. Check the archives.
>
> Jochem
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Re: Good Database Practices

[Jochem van Dieten]

Andy Ousterhout wrote:

> Would it be more effective given the hopefully minimal usage of the 
> audit trail to a flat file and save XML version of the record (in case 
> database structure changes).  I would think that this would add less 
> overhead then a db Insert/Add.

You do realize that you lose atomicity with this option?

Jochem

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Re: HTTP Compression and ColdFusion

[Jochem van Dieten]

[EMAIL PROTECTED] wrote:

> But running "test.cfm" with the "Compress Application Files" turned on 
> I get the following output:
>
> - Snip -
> Content-type: text/html
> Page-Completion-Status: Normal
>
> Done
>
>
> 10.0.0.102
> - Snip -
>
> Interesting huh?

Which CF version? This is a known problem for 5 and before.

Jochem

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

cfusion_encrypt URL safe?

[Richard Meredith-Hardy]

Dear all

Is cfusion_encrypt() URL safe? ie will a string thus encrypted and
passed in a URL variable always be correctly decrypted? (it seems to be
OK)

What is the maximum length a URL can be?

thanks


--
Regards;

Richard Meredith-Hardy

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

SQL Errors when updating Oracle table with CF ???

[Ian Vaughan]

Hi Folks

I would apprecaite if somebody can see what is wrong with my sql below, I am
trying to update a database table, but cant see why I am getting an error
for 'SQL command not properly ended ' from my script below.











UPDATE downloads

SET dldate = TO_DATE ('#formatted_date#', 'MM/DD/'),
dltitle ='#form.dltitle#',
dlsummary ='#form.dlsummary#',
area ='#form.area#',
dlos ='#form.dlos#',
dlpath =''#file.serverFile#'NULL',
username ='#Session.Fname# #Session.Lname#'

WHERE dloadidid = #form.id#


Error Occurred While Processing Request
Error Diagnostic Information
Oracle Error Code = 933

ORA-00933: SQL command not properly ended

Thanks
Ian


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

Re: HTTP Compression and ColdFusion

[cf-talk]

Jochem,

Actually it is version 5.  I hadn't taken a really close look at it until
now but just realized that it's a CF5 server with CFMX installed as well.  I
should have caught that earlier... I guess that's my que that it's time to
go to bed. :-)  Thanks for the tip.

-Novak

- Original Message -
From: "Jochem van Dieten" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, October 24, 2002 1:20 AM
Subject: Re: HTTP Compression and ColdFusion


> [EMAIL PROTECTED] wrote:
>
> > But running "test.cfm" with the "Compress Application Files" turned on
> > I get the following output:
> >
> > - Snip -
> > Content-type: text/html
> > Page-Completion-Status: Normal
> >
> > Done
> >
> >
> > 10.0.0.102
> > - Snip -
> >
> > Interesting huh?
>
> Which CF version? This is a known problem for 5 and before.
>
> Jochem
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Re: SQL Errors when updating Oracle table with CF ???

[Jochem van Dieten]

Ian Vaughan wrote:

> I would apprecaite if somebody can see what is wrong with my sql below,

You are not using cfqueryparam.

Jochem

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Verity, CFMX and Dreamweaver MX

[Adam Reynolds]

For those of you that have struggled to get the http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Re: SQL Errors when updating Oracle table with CF ???

[Ian Vaughan]

I have just changed my query to cfqueryparam














UPDATE downloads
SET dldate = TO_DATE ('#formatted_date#', 'MM/DD/'),
dltitle ='#form.dltitle#',
dlsummary ='#form.dlsummary#',
area ='#form.area#',
dlos ='#form.dlos#',
dlpath ='#file.serverFile#',
username ='#Session.Fname# #Session.Lname#'
WHERE dloadidid = #form.id#


and am recieving a new error, is my syntax wrong?.

Error Diagnostic Information
Just in time compilation error

An unknown attribute 'value' has been encountered at document position
(25:33) to (25:37) while processing tag CFPARAM. This tag can only take the
following attributes:

  a.. DEFAULT
  b.. NAME
  c.. TYPE


- Original Message -
From: "Jochem van Dieten" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, October 24, 2002 9:47 AM
Subject: Re: SQL Errors when updating Oracle table with CF ???


> Ian Vaughan wrote:
>
> > I would apprecaite if somebody can see what is wrong with my sql below,
>
> You are not using cfqueryparam.
>
> Jochem
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

Re: SQL Errors when updating Oracle table with CF ???

[Jochem van Dieten]

Ian Vaughan wrote:

> I have just changed my query to cfqueryparam
>
> 

value => default

> 
> UPDATE downloads
> SET dldate = TO_DATE ('#formatted_date#', 'MM/DD/'),
> dltitle ='#form.dltitle#',
> dlsummary ='#form.dlsummary#',
> area ='#form.area#',
> dlos ='#form.dlos#',
> dlpath ='#file.serverFile#',
> username ='#Session.Fname# #Session.Lname#'
> WHERE dloadidid = #form.id#
> 

This is still the old code without cfqueryparam.

Jochem

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

RE: cfusion_encrypt URL safe?

[Steve Green]

Lookup ToBase64() in your help and use that to make it safe.

SteG.

-Original Message-
From: Richard Meredith-Hardy [mailto:rmh@;flymicro.com]
Sent: 24 October 2002 09:27
To: CF-Talk
Subject: cfusion_encrypt URL safe?


Dear all

Is cfusion_encrypt() URL safe? ie will a string thus encrypted and
passed in a URL variable always be correctly decrypted? (it seems to be
OK)

What is the maximum length a URL can be?

thanks


--
Regards;

Richard Meredith-Hardy


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Re: SQL Errors when updating Oracle table with CF ???

[Ian Vaughan]

What exactly do you mean with the old code, what exactly does cfparam
achieve, I am just trying to update a database field, why does cfparam need
to be used and why does the update code need to be updated?

I have just had a look at the CFPARAM tag and is used to test for a
parameter's existence, and optionally test its data type, and provide a
default value if one is not assigned.

The syntax I am using looks correct so what else needs to be modified, I
cant see what??


Ian



- Original Message -
From: "Jochem van Dieten" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, October 24, 2002 10:23 AM
Subject: Re: SQL Errors when updating Oracle table with CF ???


> Ian Vaughan wrote:
>
> > I have just changed my query to cfqueryparam
> >
> > 
>
> value => default
>
> > 
> > UPDATE downloads
> > SET dldate = TO_DATE ('#formatted_date#', 'MM/DD/'),
> > dltitle ='#form.dltitle#',
> > dlsummary ='#form.dlsummary#',
> > area ='#form.area#',
> > dlos ='#form.dlos#',
> > dlpath ='#file.serverFile#',
> > username ='#Session.Fname# #Session.Lname#'
> > WHERE dloadidid = #form.id#
> > 
>
> This is still the old code without cfqueryparam.
>
> Jochem
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Re: SQL Errors when updating Oracle table with CF ???

[Jochem van Dieten]

Ian Vaughan wrote:

> What exactly do you mean with the old code, what exactly does cfparam
> achieve, I am just trying to update a database field, why does cfparam 
> need to be used and why does the update code need to be updated?

Not cfparam, cfqueryparam. It allows you to use bind variables which are 
basically strongly typed variables which are escaped in the driver 
instead of ColdFusion and can use pre-prepared execution plans on th server.

Jochem

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

Can't start CFMX Admin - No Default Web Site

[Paul Wilson]

The default web site on our IIS web server has been deleted and CFMX Admin has now 
stopped working. How can I get this started again?

Many thanks!
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

Re: Can't start CFMX Admin - No Default Web Site

[Jochem van Dieten]

Paul Wilson wrote:

> The default web site on our IIS web server has been deleted and CFMX 
> Admin has now stopped working. How can I get this started again?

Can you contact it directly at port 8500 (the built-in webserver port)?

Jochem

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Excel vs COM in CFMX

[Eric Zumot]

I have been facing big difficulties in using COM Objects to access
Excel, (Platform Win2000, Office2000, CFMX). When the same code was on
CF5.0 it worked perfectly without any problems.

In the beginning, COM Objects couldn't connect to Excel, after doing
several installations of Office2000, it connected successfully. The main
problem started happening afterwards, which is accessing the Excel COM
Object properties (The main error occurs whenever it tries saving the
file).
In brief, below are the main steps of I did so far;

1- I followed all the instructions recommended in Macromedia's article
(http://www.macromedia.com/v1/Handlers/index.cfm?ID=22922&Method=Full)
Followed the steps, and still the same error, no joy.

2- I changed the permissions of ColdFusion in the services Applets as
recommended in cfcomet.com
(http://www.cfcomet.com/other/index.cfm?ArticleID=32381637-0922-41CA-BBE
305C2D66A7025#22) Restarted the services and the server and still the
same error.

3- Downloaded and installed the Updater
(http://dynamic.macromedia.com/bin/MM/software/trial/hwswrec.jsp?product
=cfmx_updater) after showing installation was successful, I restarted
the services and the whole server again. I kept getting the same error,
except for one trial that was successful, afterwards it returned back to
the same problem.


Eric (Sael) Zumot,
Senior Programmer,

BizNet Solutions,
133-137 Lisburn Road,
Belfast,
Northern Ireland
BT09 7AG

T:++44 (028) 90223224
F:++44 (028) 90223223
E:[EMAIL PROTECTED]
W:http://www.bizNet-solutions.com
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

RE: Can't start CFMX Admin - No Default Web Site

[Paul Wilson]

No i can't

I have tried to add the default web site again and point the directory to 
c:\inetpub\wwwroot but i still get "page cannot be displayed"

-Original Message-
From: Jochem van Dieten [mailto:jochemd@;oli.tudelft.nl]
Sent: 24 October 2002 11:45
To: CF-Talk
Subject: Re: Can't start CFMX Admin - No Default Web Site


Paul Wilson wrote:

> The default web site on our IIS web server has been deleted and CFMX 
> Admin has now stopped working. How can I get this started again?

Can you contact it directly at port 8500 (the built-in webserver port)?

Jochem


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

Re: Can't start CFMX Admin - No Default Web Site

[Jochem van Dieten]

Paul Wilson wrote:

> I have tried to add the default web site again and point the directory 
> to c:\inetpub\wwwroot but i still get "page cannot be displayed"

Did you run the connector script after re-creating the default website?

Jochem

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

RE: Using CFEXECUTE from a Web Browser???

[Dave Wilson]

Couple of points and questions on this.

Firstly, have you tried using CFX_ShellExec tag? I've been using this since
cf4.01 due to various shortcomings of cfexecute's implementation over the
years.

Secondly. Do you need any particular type of printer to support this direct
printing method? I just tried the copy file LPT1 command on a machine here
with a little epson inkjet printer. The printer busy lights begin to flash
but nothing actually gets printed. Do you need a good networkable laser
printer which can support direct file dumps? I want to use this technique in
our systems for invoicing and much more.

Thanks,
Dave

-Original Message-
From: Jochem van Dieten [mailto:jochemd@;oli.tudelft.nl]
Sent: 24 October 2002 09:05
To: CF-Talk
Subject: Re: Using CFEXECUTE from a Web Browser???


Dave Cordes wrote:

> I checked and ColdFusion is logged in as the "Local System Account" so
> I don't think it could be a permissions problem.

I'm not so sure about that.

> I found some other posts on the ColdFusion Support Forums that would
> lead me to believe that your second point about timing out is the
> cause. Here is the link that talks about it.

2 issues:

CF MX always waits for the entire period specified in the timeout
instead of the shortest of the timeout and the process finishing (but
you still haven't told us which version/OS/servicepack you use).

Every version of CF will wait forever on your specific code because if
you call cmd.exe you need the /c parameter.


> I read somewhere that Macromedia has no current plans to fix it so
> that's not a good sign.

http://www.macromedia.com/support/email/wishform/?6213=3

Jochem


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

RE: Can't start CFMX Admin - No Default Web Site

[Paul Wilson]

No i havn't - What does that do and where can I find it. I didn't do anything like 
that when i installed it??

-Original Message-
From: Jochem van Dieten [mailto:jochemd@;oli.tudelft.nl]
Sent: 24 October 2002 11:56
To: CF-Talk
Subject: Re: Can't start CFMX Admin - No Default Web Site


Paul Wilson wrote:

> I have tried to add the default web site again and point the directory 
> to c:\inetpub\wwwroot but i still get "page cannot be displayed"

Did you run the connector script after re-creating the default website?

Jochem


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

Re: HTTP Compression and ColdFusion

[Jesse Houwing]

[EMAIL PROTECTED] wrote:
> Has anyone here used IIS5's built in HTTP Compression successfully with
> ColdFusion 5 or ColdFusion MX?  I was playing around with it this evening
> but interestingly enough the problem I'm getting is that some of my headers
> are now showing on the page.  I have experienced an error like this before
> while using URLScan and changing the setting to hide what type of web server
> software is in use.
> 
> HTTP Compression does not support .CFM files by default, it must be modified
> in the metabase.  I used the adsutil.vbs script to add the .CFM extension.

Do you ahve any information as to how to do this? I can run the script, 
but it is not very self expleining I'm afraid.

Jesse


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

Login Authentication

[FlashGuy]

Hi,

I require a login authentications script which uses a database and will redirect the 
user to different areas (directories) on the server based on the login. There are alot 
of 
scripts out there but rather than install and try the 30+ ones I've downloaded I was 
wondering what you guys/gals think the best one out there is. Of course, for free! ;-D



---
Colonel Nathan R. Jessop
Commanding Officer
Marine Ground Forces
Guatanamo Bay, Cuba
---



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

Re: HTTP Compression and ColdFusion

[Jochem van Dieten]

Jesse Houwing wrote:

> Do you ahve any information as to how to do this? I can run the 
> script, but it is not very self expleining I'm afraid.

Download the metabase editor from Microsoft 
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q232068
It is a RegEdit lookalike, only it is used to change the IIS metabase. 
Add cfm to the list of extensions in both 
LM\W3SVC\Filters\Compression\Deflate\HcScriptFileExtensions and
LM\W3SVC\Filters\Compression\Gzip\HcScriptFileExtensions and restart the 
service.

Jochem


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Re: Good Database Practices

[Jeffry Houser]

  In such a situation ( Invoice and InvoiceItems and other tables that 
trickled down to a price table shared with products, etc... )
  I had a problem where the price of a product would change and past 
invoices would change.

  So, for that reason I always recommend storing the current price (or 
PriceID) in the InvoiceItems table.

  As far as worrying about the total invoice amount and number of items.  I 
see no reason to store it separately in the Invoice table, unless you 
wanted to try to avoid doing calculations and (potentially) extra database 
queries every time you needed these two numbers.  I mean, computers don't 
do things they aren't told to do.  If the code is perfect, the numbers will 
always match up.

At 09:07 PM 10/23/2002 -0500, you wrote:
>How important is it to build auditing into your database?  For example, in
>an invoicing system where you have an invoice table and an invoice item
>table, does anyone recommend keeping totals such as number of items or total
>invoice amount in the invoice record?  Not for reporting, but for data
>integrity checks.  If so, how often would you validate the tables and what
>do you do if errors are found?
>
>Andy






--
Jeffry Houser | mailto:jeff@;farcryfly.com
DotComIt, Putting you on the web
AIM: Reboog711  | Phone: 1-203-379-0773
--
My CFMX Book: 

My Books: http://www.instantcoldfusion.com
My Band: http://www.farcryfly.com 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Web-based telnet

[FlashGuy]

Hi,

Im looking for some code that will allow me to open a telnet session within my 
browser. Is there such a beast?


---
Colonel Nathan R. Jessop
Commanding Officer
Marine Ground Forces
Guatanamo Bay, Cuba
---



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

Re: Web-based telnet

[todd]

If there is, it's java-applet based.

http://javassh.org/

~Todd


On Thu, 24 Oct 2002, FlashGuy wrote:

> Hi,
> 
> Im looking for some code that will allow me to open a telnet session within my 
>browser. Is there such a beast?
> 
> 
> ---
> Colonel Nathan R. Jessop
> Commanding Officer
> Marine Ground Forces
> Guatanamo Bay, Cuba
> ---

-- 

Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ |
Team Macromedia Volunteer for ColdFusion   |
http://www.macromedia.com/support/forums/team_macromedia/  |
http://www.flashCFM.com/   - webRat (Moderator)|
http://www.ultrashock.com/ - webRat (Back-end Moderator)   |
   Speakeasy DSL - http://www.speakeasy.net/refer/18280|


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

Urgent : GURU Required: Excel vs COM in CFMX

[Daryl Fullerton]

Folks / Guru's

Hi, Wonder if there are any CFMX / Excel COM gurus out there that could
help.

Much appreciated if anyone knows what is causing the below or can
recommend a fix.

Cheers

D
ColdFusion Usergroup Ireland Manager

E: [EMAIL PROTECTED] 

W: http://www.cfug.ie


-Original Message-
From: Eric Zumot 
Sent: 24 October 2002 11:46
To: CF-Talk
Subject: Excel vs COM in CFMX


I have been facing big difficulties in using COM Objects to access
Excel, (Platform Win2000, Office2000, CFMX). When the same code was on
CF5.0 it worked perfectly without any problems.

In the beginning, COM Objects couldn't connect to Excel, after doing
several installations of Office2000, it connected successfully. The main
problem started happening afterwards, which is accessing the Excel COM
Object properties (The main error occurs whenever it tries saving the
file). In brief, below are the main steps of I did so far;

1- I followed all the instructions recommended in Macromedia's article
(http://www.macromedia.com/v1/Handlers/index.cfm?ID=22922&Method=Full)
Followed the steps, and still the same error, no joy.

2- I changed the permissions of ColdFusion in the services Applets as
recommended in cfcomet.com
(http://www.cfcomet.com/other/index.cfm?ArticleID=32381637-0922-41CA-BBE
305C2D66A7025#22) Restarted the services and the server and still the
same error.

3- Downloaded and installed the Updater
(http://dynamic.macromedia.com/bin/MM/software/trial/hwswrec.jsp?product
=cfmx_updater) after showing installation was successful, I restarted
the services and the whole server again. I kept getting the same error,
except for one trial that was successful, afterwards it returned back to
the same problem.


Eric (Sael) Zumot,
Senior Programmer,

BizNet Solutions,
133-137 Lisburn Road,
Belfast,
Northern Ireland
BT09 7AG

T:++44 (028) 90223224
F:++44 (028) 90223223
E:[EMAIL PROTECTED] W:http://www.bizNet-solutions.com

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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.

Chat Application with login

[Mark Stephenson - Evolution Internet]

Hey,

Any pointers where I should start looking (Excluding devex)...

Dont want any popups, banners, etc, Need to be able to brand it and control
who uses it...

Anyone have one?

Oh, and it can't be one of those page refresh versions...

TIA



Mark Stephenson
New Media Director
Evolution Internet
T: 0870 757 1631
F: 0870 757 1632
W: www.evolutioninternet.co.uk
E: [EMAIL PROTECTED]


WARNING:
---
The information contained in this document and attachments is confidential
and intended only for the person(s) named above.  If you are not the
intended recipient you are hereby notified that any disclosure, copying,
distribution, or any other use of the information is strictly prohibited.
If you have received this document by mistake, please notify the sender
immediately and destroy this document and attachments without making any
copy of any kind.

AVIS IMPORTANT:
---
Les informations contenues dans le present document et ses pieces jointes
sont strictement confidentielles et reservees a l'usage de la (des)
personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez
avise que toute divulgation, distribution, copie, ou autre utilisation de
ces informations est strictement prohibee.  Si vous avez recu ce document
par erreur, veuillez s'il vous plait communiquer immediatement avec
l'expediteur et detruire ce document sans en faire de copie sous quelque
forme.


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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.

Read: CF-Talk-list V1 #37

[Phil Costa]

Your message

  To:  [EMAIL PROTECTED]
  Subject: CF-Talk-list V1 #37
  Sent:Wed, 23 Oct 2002 13:24:05 -0400

was read on Thu, 24 Oct 2002 08:06:57 -0400

RE: Can't start CFMX Admin - No Default Web Site

[Benoit Hediard]

IIS Connector script : "c:\CFusionMX\bin\connectors\IIS_connector.bat"
It should work fine after that.

Benoit Hediard
www.benorama.com

-Message d'origine-
De : Paul Wilson [mailto:Paul@;Dataflow-it.com]
Envoyé : jeudi 24 octobre 2002 13:21
À : CF-Talk
Objet : RE: Can't start CFMX Admin - No Default Web Site


No i havn't - What does that do and where can I find it. I didn't do
anything like that when i installed it??

-Original Message-
From: Jochem van Dieten [mailto:jochemd@;oli.tudelft.nl]
Sent: 24 October 2002 11:56
To: CF-Talk
Subject: Re: Can't start CFMX Admin - No Default Web Site


Paul Wilson wrote:

> I have tried to add the default web site again and point the directory
> to c:\inetpub\wwwroot but i still get "page cannot be displayed"

Did you run the connector script after re-creating the default website?

Jochem



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

RE: Web-based telnet

[Che Vilnonis]

I don't have an answer for ya...
but I like your email signature.

~Ché

-Original Message-
From: FlashGuy [mailto:flashmx@;rogers.com]
Sent: Thursday, October 24, 2002 7:50 AM
To: CF-Talk
Subject: Web-based telnet


Hi,

Im looking for some code that will allow me to open a telnet session within
my browser. Is there such a beast?


---
Colonel Nathan R. Jessop
Commanding Officer
Marine Ground Forces
Guatanamo Bay, Cuba
---




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

RE: SQL Errors when updating Oracle table with CF ???

[Everett, Al]

Try this. (I guessed on the CFSQLTYPEs)


UPDATE downloads
SET 
 dldate = ,
 dltitle = ,
 dlsummary =,
 area =,
 dlos =,
 dlpath =,
 username =
WHERE dloadidid = 


Oh yeah...you're using both SESSION and APPLICATION variables here, and
there's not a CFLOCK in sight.



> -Original Message-
> From: Ian Vaughan [mailto:i.vaughn@;neath-porttalbot.gov.uk]
> Sent: Thursday, October 24, 2002 6:05 AM
> To: CF-Talk
> Subject: Re: SQL Errors when updating Oracle table with CF ???
> 
> 
> What exactly do you mean with the old code, what exactly does cfparam
> achieve, I am just trying to update a database field, why 
> does cfparam need
> to be used and why does the update code need to be updated?
> 
> I have just had a look at the CFPARAM tag and is used to test for a
> parameter's existence, and optionally test its data type, and 
> provide a
> default value if one is not assigned.
> 
> The syntax I am using looks correct so what else needs to be 
> modified, I
> cant see what??
> 
> 
> Ian
> 
> 
> 
> - Original Message -
> From: "Jochem van Dieten" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, October 24, 2002 10:23 AM
> Subject: Re: SQL Errors when updating Oracle table with CF ???
> 
> 
> > Ian Vaughan wrote:
> >
> > > I have just changed my query to cfqueryparam
> > >
> > > 
> >
> > value => default
> >
> > > 
> > > UPDATE downloads
> > > SET dldate = TO_DATE ('#formatted_date#', 'MM/DD/'),
> > > dltitle ='#form.dltitle#',
> > > dlsummary ='#form.dlsummary#',
> > > area ='#form.area#',
> > > dlos ='#form.dlos#',
> > > dlpath ='#file.serverFile#',
> > > username ='#Session.Fname# #Session.Lname#'
> > > WHERE dloadidid = #form.id#
> > > 
> >
> > This is still the old code without cfqueryparam.
> >
> > Jochem
> >
> > 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

Re: Linux & Solaris file paths

[Chris Norloff]

I've always used "/" on our Solaris machines.  Not really sure if a backslash would 
work in a file path.  I wouldn't expect it to.

Chris Norloff

-- Original Message --
from: S. Isaac Dealey <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Tue, 22 Oct 2002 22:20:59 -0400

>Quick question for anyone using *nix and / or Apache.
>
>Using IIS on a windows server, file paths can be specified in  and
> using / or \ interchangeably. I'm guessing this isn't true for
>*nix servers, but I wanted to verify this before I put a ton of work into a
>modification that may not be necessary to support *nix servers.
>
>Isaac Dealey
>Certified Advanced ColdFusion 5 Developer
>
>new epoch
>www.turnkey.to
>954-776-0046
>
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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.

SOLVED: CF 4.5 work with Oracle 9i ?

[Chris Norloff]

Well, to answer my own question: NO.

CF 4.5 is not supported with Oracle 9i drivers.  I've spoken to people who've 
connected it and it's worked, but you're on your own for finding if there's any bugs.  
And MM tech support doesn't cover unsupported configurations.

Chris Norloff

-- Original Message --
from: "Chris Norloff" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Wed, 23 Oct 2002 14:17:49 -0400

>Anybody running CF 4.5 with Oracle 9i client drivers? (on Solaris 8).
>
>I see it's okay with CF 5
>http://www.macromedia.com/v1/Handlers/index.cfm?ID=23458&Method=Full
>and was wondering if it's also okay with CF 4.5
>
>thanks,
>Chris Norloff
>
>
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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.

RE: Good Database Practices

[Andy Ousterhout]

Jochem,

What do you mean by "atomicity"?

By the way, how do you pronounce your name?   "wah-keem"  accent on the
first part?

Andy

-Original Message-
From: Jochem van Dieten [mailto:jochemd@;oli.tudelft.nl]
Sent: Thursday, October 24, 2002 3:14 AM
To: CF-Talk
Subject: Re: Good Database Practices


Andy Ousterhout wrote:

> Would it be more effective given the hopefully minimal usage of the
> audit trail to a flat file and save XML version of the record (in case
> database structure changes).  I would think that this would add less
> overhead then a db Insert/Add.

You do realize that you lose atomicity with this option?

Jochem


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

RE: Good Database Practices

[Andy Ousterhout]

Agree.  Each invoice and related Invoice Items records need to be
independent of customer and product tables for the reasons you stated below.

Has anyone designed a separate data structure for reporting on customer and
item sales?  I am curious if anyone has found this to be necessary or if
reporting requirements did not negatively affect production database
response times.

Andy

-Original Message-
From: Jeffry Houser [mailto:jeff@;farcryfly.com]
Sent: Thursday, October 24, 2002 6:35 AM
To: CF-Talk
Subject: Re: Good Database Practices


  In such a situation ( Invoice and InvoiceItems and other tables that
trickled down to a price table shared with products, etc... )
  I had a problem where the price of a product would change and past
invoices would change.

  So, for that reason I always recommend storing the current price (or
PriceID) in the InvoiceItems table.

  As far as worrying about the total invoice amount and number of items.  I
see no reason to store it separately in the Invoice table, unless you
wanted to try to avoid doing calculations and (potentially) extra database
queries every time you needed these two numbers.  I mean, computers don't
do things they aren't told to do.  If the code is perfect, the numbers will
always match up.

At 09:07 PM 10/23/2002 -0500, you wrote:
>How important is it to build auditing into your database?  For example, in
>an invoicing system where you have an invoice table and an invoice item
>table, does anyone recommend keeping totals such as number of items or
total
>invoice amount in the invoice record?  Not for reporting, but for data
>integrity checks.  If so, how often would you validate the tables and what
>do you do if errors are found?
>
>Andy






--
Jeffry Houser | mailto:jeff@;farcryfly.com
DotComIt, Putting you on the web
AIM: Reboog711  | Phone: 1-203-379-0773
--
My CFMX Book:

My Books: http://www.instantcoldfusion.com
My Band: http://www.farcryfly.com


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Re: Good Database Practices

[Jochem van Dieten]

Andy Ousterhout wrote:

> Jochem,
>
> What do you mean by "atomicity"?

Atomicity, from the ACID test :)
http://searchdatabase.techtarget.com/sDefinition/0,,sid13_gci213756,00.html

> By the way, how do you pronounce your name?   "wah-keem"  accent on 
> the first part?

Like the German "Jochen". Sorry, I don't know any phonetic alphabet.

Jochem

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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.

RE: Using CFEXECUTE from a Web Browser???

[Eric Davis]

It probably is a permission issue, the local system account needs to have the right to 
"iteract with the desktop" in order to run an application.  Also, I have found that 
putting the commands in a .bat file works best.
-Eric D.

>>> [EMAIL PROTECTED] 10/23/02 8:28:41 PM >>>
I checked and ColdFusion is logged in as the "Local System Account" so I
don't think it could be a permissions problem. I found some other posts on
the ColdFusion Support Forums that would lead me to believe that your second
point about timing out is the cause. Here is the link that talks about it. I
read somewhere that Macromedia has no current plans to fix it so that's not
a good sign.

http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=7&threadid= 
310075

Dave Cordes
Senior ColdFusion Developer
636-939-1081 (H)
636-578-4235 (M)

-Original Message-
From: [EMAIL PROTECTED] [mailto:cf-talk@;linenoize.com] 
Sent: Wednesday, October 23, 2002 8:37 PM
To: CF-Talk
Subject: Re: Using CFEXECUTE from a Web Browser???


It's quite likely a permissions problem.  But another thing you can try is
to put the commands in a .BAT file and then execute the .BAT file.

Also note... I've experienced some "weirdness" with the CFEXECUTE command in
CFMX.  I wish I could explain it better than that but the main problem I was
having was that some programs (which worked in CF5) would not execute in
CFMX.  I also noticed that the "timeout" attribute was causing the program
to take that long to execute rather than executing and then returning back
to the calling template.  I'm not sure if this was addressed in the updater
patch or not.  I haven't tested it since.

-Novak

- Original Message -
From: "Dave Cordes" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, October 23, 2002 5:00 PM
Subject: Using CFEXECUTE from a Web Browser???


> Has anyone ever tried to use CFEXECUTE to execute a command?
>
>  ARGUMENTS="copy zebra.txt LPT1"
> TIMEOUT="5">
>
> We're trying to print barcodes from a Web browser and have been having
lots
> of problems. All it does is times out.
>
> I can go to a command prompt and type in "copy zebra.txt LPT1" and it
works
> fine.
>
> How can I do this using CFEXECUTE?
>
> Dave Cordes
> Senior ColdFusion Developer
> 636-939-1081 (H)
> 636-578-4235 (M)
>
>
>


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

RE: Good Database Practices

[Andy Ousterhout]

Thanks.  I'll ask my daughter, she is taking German.



-Original Message-
From: Jochem van Dieten [mailto:jochemd@;oli.tudelft.nl]
Sent: Thursday, October 24, 2002 8:59 AM
To: CF-Talk
Subject: Re: Good Database Practices


Andy Ousterhout wrote:

> Jochem,
>
> What do you mean by "atomicity"?

Atomicity, from the ACID test :)
http://searchdatabase.techtarget.com/sDefinition/0,,sid13_gci213756,00.html

> By the way, how do you pronounce your name?   "wah-keem"  accent on
> the first part?

Like the German "Jochen". Sorry, I don't know any phonetic alphabet.

Jochem


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

Re: SQL Errors when updating Oracle table with CF ???

[Deanna Schneider]

Regardless of whether you're using cfqueryparams or not, the best way to
figure out why you're getting the original error is to show us the debug
output (i.e. what all your variables turn into when cf processes them). If
you show us that, and it might be easier to see what the problem is.

-d



Deanna Schneider
Interactive Media Developer
[EMAIL PROTECTED]



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

RE: Web-based telnet

[WebSite CFtalk]

This is nice:

http://www.screensurfer.com/

-
Helge Hetland

-Original Message-
From: [EMAIL PROTECTED] [mailto:todd@;web-rat.com] 
Sent: 24. oktober 2002 14:14
To: CF-Talk
Subject: Re: Web-based telnet


If there is, it's java-applet based.

http://javassh.org/

~Todd


On Thu, 24 Oct 2002, FlashGuy wrote:

> Hi,
> 
> Im looking for some code that will allow me to open a telnet session 
> within my browser. Is there such a beast?
> 
> 
> ---
> Colonel Nathan R. Jessop
> Commanding Officer
> Marine Ground Forces
> Guatanamo Bay, Cuba
> ---

-- 

Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ |
Team Macromedia Volunteer for ColdFusion   |
http://www.macromedia.com/support/forums/team_macromedia/  |
http://www.flashCFM.com/   - webRat (Moderator)|
http://www.ultrashock.com/ - webRat (Back-end Moderator)   |
   Speakeasy DSL - http://www.speakeasy.net/refer/18280|



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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.

Cookie information apprearing at the top of a page

[Stephen Rojas]

Hey all,
I think I have seen reference to this problem before on the list but I
could not find it in the archives. Basically what is happening is that
when I go any CF page running on my production server that sets any
cookies the information for the cookie is displayed at the top of the
page in the following format:

Content-type: text/html Page-Completion-Status: Normal
Page-Completion-Status: Normal Set-Cookie: CFID=192333; expires=Sun,
27-Sep-2037 00:00:00 GMT; path=/; Set-Cookie: CFTOKEN=70022833;
expires=Sun, 27-Sep-2037 00:00:00 GMT; path=/;

A quick search on google shows that this is a common issue, however, I
haven't been able to find a resolution. Any ideas or suggestions?

TIA
Stephen

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

RE: SOT:Java?

[Chris Alvarado]

Heya fellow Chris...=)

Well I would like to get a good foundation in Java (for backend
development) but then would also like to get into the more display tier
level of Java dev (JSP) etc.

Thanks for the recommendsI will surely take a look at these books
and the editor.

-chris.alvarado
[ application developer ]
4 Guys Interactive, Inc.
http://www.4guys.com 

"We create websites that make you a hero."



-Original Message-
From: Chris Montgomery [mailto:lists@;airtightweb.com] 
Sent: Wednesday, October 23, 2002 11:07 PM
To: CF-Talk
Subject: Re: SOT:Java?


Howdy Chris,

Wednesday, October 23, 2002, 9:39:52 AM, Chris Alvarado wrote:

CA> Does anyone have any good book reccomendations to get me started 
CA> down that path? I have some basic OOP experience, but none with 
CA> Java, so any help would be awesome.

Are you talking about just starting out with Java? If so, I recently
purchased these two (Amazon.com has a package deal on them right now):

Beginning Java 2 SDK 1.4 Edition (Ivor Horton)
http://www.amazon.com/exec/obidos/tg/detail/-/1861005695/

Beginning Java Objects: From Concepts to Code (Jacquie Barker)
http://www.amazon.com/exec/obidos/tg/detail/-/1861004176/

I haven't had a chance to look at the Barker's book yet, but Horton's is
a pretty good intro to Java. Hal Helms recommended Barker's book as a
good starting point to learn about OOP in one of his recent newsletters.

CA> Also, any preferred Development Environments / Editors?

Based on a recommendation in Horton's book, I've started messing around
with JCreator ( http://www.jcreator.com/ ). It's a nice Java IDE and
pretty easy for beginners to pick up. The light edition is free, too.
Also, UltraEdit works pretty good and has a tool you can configure to
compile java files.

Chris Montgomerymonty @ airtightweb.com

-- 
Airtight Web Services   http://www.airtightweb.com
Web Development, Web Project Management, Software Sales
210-490-3249/888-745-7603


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

RE: Using CFEXECUTE from a Web Browser???

[Dave Cordes]

Thanks for the suggestion. I changed the account to "Administrator" and
still got a timeout error with the following code.



Any other suggestions???

Dave Cordes
Senior ColdFusion Developer
636-939-1081 (H)
636-578-4235 (M)

-Original Message-
From: [EMAIL PROTECTED] [mailto:cf-talk@;linenoize.com]
Sent: Wednesday, October 23, 2002 10:46 PM
To: CF-Talk
Subject: Re: Using CFEXECUTE from a Web Browser???


"Local System Account" probably DOES NOT have the proper permissions.  Try
(temporarily) setting ColdFusion to run as "Administrator" and see if that
solves your problem.  If it does, then you'll want to create a "ColdFusion"
(or similar) account and set it up that way.  I do NOT recommend running the
ColdFusion server as "Administrator" for obvious reasons... just as a test
to see if it's a permissions issue or not.

-Novak

- Original Message -
From: "Dave Cordes" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, October 23, 2002 8:28 PM
Subject: RE: Using CFEXECUTE from a Web Browser???


> I checked and ColdFusion is logged in as the "Local System Account" so I
> don't think it could be a permissions problem. I found some other posts on
> the ColdFusion Support Forums that would lead me to believe that your
second
> point about timing out is the cause. Here is the link that talks about it.
I
> read somewhere that Macromedia has no current plans to fix it so that's
not
> a good sign.
>
>
http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=7&threadid=
> 310075
>
> Dave Cordes
> Senior ColdFusion Developer
> 636-939-1081 (H)
> 636-578-4235 (M)
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:cf-talk@;linenoize.com]
> Sent: Wednesday, October 23, 2002 8:37 PM
> To: CF-Talk
> Subject: Re: Using CFEXECUTE from a Web Browser???
>
>
> It's quite likely a permissions problem.  But another thing you can try is
> to put the commands in a .BAT file and then execute the .BAT file.
>
> Also note... I've experienced some "weirdness" with the CFEXECUTE command
in
> CFMX.  I wish I could explain it better than that but the main problem I
was
> having was that some programs (which worked in CF5) would not execute in
> CFMX.  I also noticed that the "timeout" attribute was causing the program
> to take that long to execute rather than executing and then returning back
> to the calling template.  I'm not sure if this was addressed in the
updater
> patch or not.  I haven't tested it since.
>
> -Novak
>
> - Original Message -
> From: "Dave Cordes" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, October 23, 2002 5:00 PM
> Subject: Using CFEXECUTE from a Web Browser???
>
>
> > Has anyone ever tried to use CFEXECUTE to execute a command?
> >
> >  > ARGUMENTS="copy zebra.txt LPT1"
> > TIMEOUT="5">
> >
> > We're trying to print barcodes from a Web browser and have been having
> lots
> > of problems. All it does is times out.
> >
> > I can go to a command prompt and type in "copy zebra.txt LPT1" and it
> works
> > fine.
> >
> > How can I do this using CFEXECUTE?
> >
> > Dave Cordes
> > Senior ColdFusion Developer
> > 636-939-1081 (H)
> > 636-578-4235 (M)
> >
> >
> >
>
>

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

RE: Using CFEXECUTE from a Web Browser???

[Dave Cordes]

Jochem,
Here are the server specs:

Windows XP
ColdFusion MX

What did you mean by the "/c" parameter? Should I add that command in order
to close the command?

Like this?



Dave Cordes
Senior ColdFusion Developer
636-939-1081 (H)
636-578-4235 (M)

-Original Message-
From: Jochem van Dieten [mailto:jochemd@;oli.tudelft.nl]
Sent: Thursday, October 24, 2002 3:05 AM
To: CF-Talk
Subject: Re: Using CFEXECUTE from a Web Browser???


Dave Cordes wrote:

> I checked and ColdFusion is logged in as the "Local System Account" so
> I don't think it could be a permissions problem.

I'm not so sure about that.

> I found some other posts on the ColdFusion Support Forums that would
> lead me to believe that your second point about timing out is the
> cause. Here is the link that talks about it.

2 issues:

CF MX always waits for the entire period specified in the timeout
instead of the shortest of the timeout and the process finishing (but
you still haven't told us which version/OS/servicepack you use).

Every version of CF will wait forever on your specific code because if
you call cmd.exe you need the /c parameter.


> I read somewhere that Macromedia has no current plans to fix it so
> that's not a good sign.

http://www.macromedia.com/support/email/wishform/?6213=3

Jochem


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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.

RE: Urgent : GURU Required: Excel vs COM in CFMX

[Steve Drucker]

Yeah, the problem is that you're using COM to connect to Excel.

As has been previously mentioned several times on various boards, COM is
dead.  Microsoft has abandoned COM, ColdFusion MX doesn't support COM
particularly well due to its new architecture, and invoking Excel as a COM
object on the server isn't even supported by Microsoft under ASP:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q257757&ID=kb;en-us;
Q257757&FR=1

So, just say no to COM.

I'm actually lecturing about this topic at Devcon in a few days.  
Your viable options are as follows:

1) Simple data can be sent to Excel as delimited fields
2) More complex data can be represented as HTML or XML and loaded directly
into Excel (especially Excel 10/XP)
3) Use the Office XP web control to embed MS-excel functionality in your web
pages (assuming the end user owns a license of XP)
4) Use Excel's web query features, or use CF to create a web query file
5) Create a web service in CFMX that is accessible to Excel as a web client

Regards,
Steve Drucker
CEO
Fig Leaf Software


> -Original Message-
> From: Daryl Fullerton [mailto:Daryl.Fullerton@;biznet-solutions.com]
> Sent: Thursday, October 24, 2002 7:52 AM
> To: CF-Talk
> Subject: Urgent : GURU Required: Excel vs COM in CFMX
> 
> Folks / Guru's
> 
> Hi, Wonder if there are any CFMX / Excel COM gurus out there that could
> help.
> 
> Much appreciated if anyone knows what is causing the below or can
> recommend a fix.
> 
> Cheers
> 
> D
> ColdFusion Usergroup Ireland Manager
> 
> E: [EMAIL PROTECTED]
> 
> W: http://www.cfug.ie
> 
> 
> -Original Message-
> From: Eric Zumot
> Sent: 24 October 2002 11:46
> To: CF-Talk
> Subject: Excel vs COM in CFMX
> 
> 
> I have been facing big difficulties in using COM Objects to access
> Excel, (Platform Win2000, Office2000, CFMX). When the same code was on
> CF5.0 it worked perfectly without any problems.
> 
> In the beginning, COM Objects couldn't connect to Excel, after doing
> several installations of Office2000, it connected successfully. The main
> problem started happening afterwards, which is accessing the Excel COM
> Object properties (The main error occurs whenever it tries saving the
> file). In brief, below are the main steps of I did so far;
> 
> 1- I followed all the instructions recommended in Macromedia's article
> (http://www.macromedia.com/v1/Handlers/index.cfm?ID=22922&Method=Full)
> Followed the steps, and still the same error, no joy.
> 
> 2- I changed the permissions of ColdFusion in the services Applets as
> recommended in cfcomet.com
> (http://www.cfcomet.com/other/index.cfm?ArticleID=32381637-0922-41CA-BBE
> 305C2D66A7025#22) Restarted the services and the server and still the
> same error.
> 
> 3- Downloaded and installed the Updater
> (http://dynamic.macromedia.com/bin/MM/software/trial/hwswrec.jsp?product
> =cfmx_updater) after showing installation was successful, I restarted
> the services and the whole server again. I kept getting the same error,
> except for one trial that was successful, afterwards it returned back to
> the same problem.
> 
> 
> Eric (Sael) Zumot,
> Senior Programmer,
> 
> BizNet Solutions,
> 133-137 Lisburn Road,
> Belfast,
> Northern Ireland
> BT09 7AG
> 
> T:++44 (028) 90223224
> F:++44 (028) 90223223
> E:[EMAIL PROTECTED] W:http://www.bizNet-solutions.com
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

Can CF search a string from the right to the left.

[Ciliotta, Mario]

Hi,

I was wondering if anyone knows of a cf function or a tag that will search a string 
from the right to the left, instead of the left to the right.

I want to search a string say:  http://www.somesite.com/folder1/index.cfm   What I 
want returned is everything from the last "/" to the beginning.

Is there any function or tag that can do this, I can write the code to do it with from 
the left to the right but I was just wondering if a something else existed.

Thanks

Mario

This message is for the named person's use only. It may contain sensitive and private 
proprietary or legally privileged information. No confidentiality or privilege is 
waived or lost by any mistransmission. If you are not the intended recipient, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it and notify the sender. You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient. CREDIT SUISSE GROUP and each legal entity in the CREDIT SUISSE FIRST BOSTON 
or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT SUISSE FIRST BOSTON reserve 
the right to monitor all e-mail communications through its networks. Any views 
expressed in this message are those of the individual sender, except where the message 
states otherwise and the sender is authorized to state them to be the views of any 
such entity.
Unless otherwise stated, any pricing information given in this message is indicative  
only, is subject to change and does not constitute an offer to deal at any price 
quoted. Any reference to the terms of executed transactions should be treated as  
preliminary only and subject to our formal written confirmation.


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

Re: Oracle Error "no descriptor for this position

[Chris Norloff]

Nope, not here, but thanks for the idea.

Chris Norloff

-- Original Message --
from: "Deanna Schneider" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Tue, 22 Oct 2002 13:08:03 -0500

>I've been trying to trudge through my memory about this one, since I used to
>get it and don't anymore. I think it was this issue: There was one app where
>I was using translate() in a query. I updated all the data to do what the
>translate was doing, and haven't had a problem since. You wouldn't happen to
>be using that function, would you?
>-d
>
>
>
>Deanna Schneider
>Interactive Media Developer
>[EMAIL PROTECTED]
>
>
>
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

RE: Using CFEXECUTE from a Web Browser???

[Dave Cordes]

Dave,
Actually we're trying to use it to print barcodes to a Zebra LP2844 thermal
printer. And we're trying to do it from IE.

If you open a command prompt and type "copy C:\zebra.txt LPT1" and have
valid EPL2 code in that text file it should print a barcode.

That's how we're trying to use it.

Dave Cordes
Senior ColdFusion Developer
636-939-1081 (H)
636-578-4235 (M)

-Original Message-
From: Dave Wilson [mailto:dave@;autosdirect2u.com]
Sent: Thursday, October 24, 2002 5:59 AM
To: CF-Talk
Subject: RE: Using CFEXECUTE from a Web Browser???


Couple of points and questions on this.

Firstly, have you tried using CFX_ShellExec tag? I've been using this since
cf4.01 due to various shortcomings of cfexecute's implementation over the
years.

Secondly. Do you need any particular type of printer to support this direct
printing method? I just tried the copy file LPT1 command on a machine here
with a little epson inkjet printer. The printer busy lights begin to flash
but nothing actually gets printed. Do you need a good networkable laser
printer which can support direct file dumps? I want to use this technique in
our systems for invoicing and much more.

Thanks,
Dave

-Original Message-
From: Jochem van Dieten [mailto:jochemd@;oli.tudelft.nl]
Sent: 24 October 2002 09:05
To: CF-Talk
Subject: Re: Using CFEXECUTE from a Web Browser???


Dave Cordes wrote:

> I checked and ColdFusion is logged in as the "Local System Account" so
> I don't think it could be a permissions problem.

I'm not so sure about that.

> I found some other posts on the ColdFusion Support Forums that would
> lead me to believe that your second point about timing out is the
> cause. Here is the link that talks about it.

2 issues:

CF MX always waits for the entire period specified in the timeout
instead of the shortest of the timeout and the process finishing (but
you still haven't told us which version/OS/servicepack you use).

Every version of CF will wait forever on your specific code because if
you call cmd.exe you need the /c parameter.


> I read somewhere that Macromedia has no current plans to fix it so
> that's not a good sign.

http://www.macromedia.com/support/email/wishform/?6213=3

Jochem



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

RE: Can CF search a string from the right to the left.

[Robyn Follen]

you can use the reverse(string) function and then search from left to right.

-Original Message-
From: Ciliotta, Mario [mailto:mario.ciliotta@;csfb.com]
Sent: Thursday, October 24, 2002 10:34 AM
To: CF-Talk
Subject: Can CF search a string from the right to the left.


Hi,

I was wondering if anyone knows of a cf function or a tag that will search a
string from the right to the left, instead of the left to the right.

I want to search a string say:  http://www.somesite.com/folder1/index.cfm
What I want returned is everything from the last "/" to the beginning.

Is there any function or tag that can do this, I can write the code to do it
with from the left to the right but I was just wondering if a something else
existed.

Thanks

Mario

This message is for the named person's use only. It may contain sensitive
and private proprietary or legally privileged information. No
confidentiality or privilege is waived or lost by any mistransmission. If
you are not the intended recipient, please immediately delete it and all
copies of it from your system, destroy any hard copies of it and notify the
sender. You must not, directly or indirectly, use, disclose, distribute,
print, or copy any part of this message if you are not the intended
recipient. CREDIT SUISSE GROUP and each legal entity in the CREDIT SUISSE
FIRST BOSTON or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT
SUISSE FIRST BOSTON reserve the right to monitor all e-mail communications
through its networks. Any views expressed in this message are those of the
individual sender, except where the message states otherwise and the sender
is authorized to state them to be the views of any such entity.
Unless otherwise stated, any pricing information given in this message is
indicative  only, is subject to change and does not constitute an offer to
deal at any price quoted. Any reference to the terms of executed
transactions should be treated as  preliminary only and subject to our
formal written confirmation.



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

Re: Can CF search a string from the right to the left.

[jon hall]

Use reverse(), then search from the beginning.

-- 
 jon
 mailto:jonhall@;ozline.net

Thursday, October 24, 2002, 10:34:15 AM, you wrote:
CM> Hi,

CM> I was wondering if anyone knows of a cf function or a tag that will search a 
string from the right to the left, instead of the left to the right.

CM> I want to search a string say:  http://www.somesite.com/folder1/index.cfm   What I 
want returned is everything from the last "/" to the beginning.

CM> Is there any function or tag that can do this, I can write the code to do it with 
from the left to the right but I was just wondering if a something else existed.

CM> Thanks

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

RE: Urgent : GURU Required: Excel vs COM in CFMX

[Benjamin S. Rogers]

Macromedia breaks COM support in ColdFusion, and now COM is dead? Sounds
like spin to me: rather than fix it, we'll just declare it dead and
deride the use of it. Don't get me wrong, I know you don't work for
Macromedia, and I know COM is something less than ideal. However, it
works well for much of what we do, and sometimes it is the only way to
get the job done. I'd really like to see Macromedia fix COM support in
ColdFusion than have presenters haranguing the death of COM at Devcon.
COM is years away from being dead in any practical sense.

Benjamin S. Rogers
http://www.c4.net/
v.508.240.0051
f.508.240.0057

-Original Message-
From: Steve Drucker [mailto:sdrucker@;figleaf.com] 
Sent: Thursday, October 24, 2002 10:39 AM
To: CF-Talk
Subject: RE: Urgent : GURU Required: Excel vs COM in CFMX


Yeah, the problem is that you're using COM to connect to Excel.

As has been previously mentioned several times on various boards, COM is
dead.  Microsoft has abandoned COM, ColdFusion MX doesn't support COM
particularly well due to its new architecture, and invoking Excel as a
COM
object on the server isn't even supported by Microsoft under ASP:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q257757&ID=kb;en
-us;
Q257757&FR=1

So, just say no to COM.

I'm actually lecturing about this topic at Devcon in a few days.  
Your viable options are as follows:

1) Simple data can be sent to Excel as delimited fields
2) More complex data can be represented as HTML or XML and loaded
directly
into Excel (especially Excel 10/XP)
3) Use the Office XP web control to embed MS-excel functionality in your
web
pages (assuming the end user owns a license of XP)
4) Use Excel's web query features, or use CF to create a web query file
5) Create a web service in CFMX that is accessible to Excel as a web
client

Regards,
Steve Drucker
CEO
Fig Leaf Software


> -Original Message-
> From: Daryl Fullerton [mailto:Daryl.Fullerton@;biznet-solutions.com]
> Sent: Thursday, October 24, 2002 7:52 AM
> To: CF-Talk
> Subject: Urgent : GURU Required: Excel vs COM in CFMX
> 
> Folks / Guru's
> 
> Hi, Wonder if there are any CFMX / Excel COM gurus out there that
could
> help.
> 
> Much appreciated if anyone knows what is causing the below or can
> recommend a fix.
> 
> Cheers
> 
> D
> ColdFusion Usergroup Ireland Manager
> 
> E: [EMAIL PROTECTED]
> 
> W: http://www.cfug.ie
> 
> 
> -Original Message-
> From: Eric Zumot
> Sent: 24 October 2002 11:46
> To: CF-Talk
> Subject: Excel vs COM in CFMX
> 
> 
> I have been facing big difficulties in using COM Objects to access
> Excel, (Platform Win2000, Office2000, CFMX). When the same code was on
> CF5.0 it worked perfectly without any problems.
> 
> In the beginning, COM Objects couldn't connect to Excel, after doing
> several installations of Office2000, it connected successfully. The
main
> problem started happening afterwards, which is accessing the Excel COM
> Object properties (The main error occurs whenever it tries saving the
> file). In brief, below are the main steps of I did so far;
> 
> 1- I followed all the instructions recommended in Macromedia's article
> (http://www.macromedia.com/v1/Handlers/index.cfm?ID=22922&Method=Full)
> Followed the steps, and still the same error, no joy.
> 
> 2- I changed the permissions of ColdFusion in the services Applets as
> recommended in cfcomet.com
>
(http://www.cfcomet.com/other/index.cfm?ArticleID=32381637-0922-41CA-BBE
> 305C2D66A7025#22) Restarted the services and the server and still the
> same error.
> 
> 3- Downloaded and installed the Updater
>
(http://dynamic.macromedia.com/bin/MM/software/trial/hwswrec.jsp?product
> =cfmx_updater) after showing installation was successful, I restarted
> the services and the whole server again. I kept getting the same
error,
> except for one trial that was successful, afterwards it returned back
to
> the same problem.
> 
> 
> Eric (Sael) Zumot,
> Senior Programmer,
> 
> BizNet Solutions,
> 133-137 Lisburn Road,
> Belfast,
> Northern Ireland
> BT09 7AG
> 
> T:++44 (028) 90223224
> F:++44 (028) 90223223
> E:[EMAIL PROTECTED] W:http://www.bizNet-solutions.com
> 
> 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

IE 6.0 and cftree applet problem.

[Huynh Weiming]

Here is the situation we tested our application on Netscape 4  or
greater, and IE 5.5 and our file move feature works just fine.  This
feature uses the cftree applet to display the directory structure.  I've
just upgraded to IE 6.0 and it stopped working.

This is what happen in IE 6.0

- Tree show up,
- I select the directory to move to
- Submit my choice
- But file won't move.

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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.

cflock and CF 4.01

[Bud]

I can't believe I'm still asking questions about cflock. LOL

Refresh my memory, because I'm sure I've asked this and it's been 
answered, but I can't find it in my memory banks. :)

Example: I'm setting a variable named session.user. This is a pretty 
common variable name which would likely be used by several developers 
on a shared server.

When I exclusively lock the setting of the variable using name (CF 
4.01), should the name be exclusive to the user, to the application, 
or to the server (likely impossible).

So, if my application is named "myuniqueapp", should I set the name 
attribute to:

cflock type="exclusive" name="myuniqueapp_setuser"

which would make it unique to my application

or something like

cflock type="exclusive" name="#client.cfid#_#client.cftoken#_setuser"

which would make it unique to the user.
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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.

Re: SQL Errors when updating Oracle table with CF ???

[Ian Vaughan]

Deanna

Thanks for the mail

Right, we seem to be getting somehere

I am not getting any error messages and it is taking me to the form
processing page as it should, however the database field is not getting
updated

Is there anything wrong with the SQL that is causes the field not to get
updated with the new value ?? shown below














UPDATE downloads
SET dldate = TO_DATE ('#formatted_date#', 'MM/DD/'),
dltitle ='#form.dltitle#',
dlsummary ='#form.dlsummary#',
area ='#form.area#',
dlos ='#form.dlos#',
dlpath ='#file.serverFile#',
username ='#Session.Fname# #Session.Lname#'
WHERE dloadid = #form.id#



- Original Message -
From: "Deanna Schneider" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, October 24, 2002 3:10 PM
Subject: Re: SQL Errors when updating Oracle table with CF ???


> Regardless of whether you're using cfqueryparams or not, the best way to
> figure out why you're getting the original error is to show us the debug
> output (i.e. what all your variables turn into when cf processes them). If
> you show us that, and it might be easier to see what the problem is.
>
> -d
>
>
>
> Deanna Schneider
> Interactive Media Developer
> [EMAIL PROTECTED]
>
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

Re: Can CF search a string from the right to the left.

[Jerry Johnson]

But an easier way might be to treat the string as a list delimited with /, and delete 
the last element from the list




Jerry Johnson

>>> [EMAIL PROTECTED] 10/24/02 10:34AM >>>
Hi,

I was wondering if anyone knows of a cf function or a tag that will search a string 
from the right to the left, instead of the left to the right.

I want to search a string say:  http://www.somesite.com/folder1/index.cfm   What I 
want returned is everything from the last "/" to the beginning.

Is there any function or tag that can do this, I can write the code to do it with from 
the left to the right but I was just wondering if a something else existed.

Thanks

Mario

This message is for the named person's use only. It may contain sensitive and private 
proprietary or legally privileged information. No confidentiality or privilege is 
waived or lost by any mistransmission. If you are not the intended recipient, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it and notify the sender. You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient. CREDIT SUISSE GROUP and each legal entity in the CREDIT SUISSE FIRST BOSTON 
or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT SUISSE FIRST BOSTON reserve 
the right to monitor all e-mail communications through its networks. Any views 
expressed in this message are those of the individual sender, except where the message 
states otherwise and the sender is authorized to state them to be the views of any 
such entity.
Unless otherwise stated, any pricing information given in this message is indicative  
only, is subject to change and does not constitute an offer to deal at any price 
quoted. Any reference to the terms of executed transactions should be treated as  
preliminary only and subject to our formal written confirmation.



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

Re: M$Access DB and ColdFusionMX for Solaris

[Troy Simpson]

I got back the following error when I was trying to create the M$ Access data source:

Connection verification failed for data source: MSAccess
[]java.sql.SQLException: null
The root cause was that: java.sql.SQLException

Is this a problem related to being unable to find the *.jar or *.class file for 
sun.jdbc.odbc.JdbcOdbcDriver?
If so, what JAR file do I need in the ClassPath?

I'm running ColdFusionMX on Sun Solaris 8 and Apache 2.0.40.

Troy


Rob Rohan wrote:

> and you need to have a space
>
> Microsoft Access Driver (*.mdb)
>^--- space!
> -Original Message-
> From: Rob Rohan [mailto:rob@;cardinalweb.com]
> Sent: Thursday, October 24, 2002 10:58 AM
> To: CF-Talk
> Subject: RE: M$Access DB and ColdFusionMX for Solaris
>
> no []
>
> Good luck
>
> -Original Message-
> From: Troy Simpson [mailto:Troy_Simpson@;ncsu.edu]
> Sent: Thursday, October 24, 2002 10:54 AM
> To: CF-Talk
> Subject: Re: M$Access DB and ColdFusionMX for Solaris
>
> Thanks Rob it this works it would be great. :-)
>
> So the Java URL would be:
>
> jdbc:odbc:Driver={Microsoft Access Driver(*.mdb)};DBQ=[/usr/db/db1.mdb]
> or
> jdbc:odbc:Driver={Microsoft Access Driver(*.mdb)};DBQ=/usr/db/db1.mdb
>
> The second one does not have the [,].
>
> The reason I'm asking for examples is because if it is going to work, the
> syntax is what
> usually kills it.
>
> Thanks,
> Troy
>
> Rob Rohan wrote:
>
> > Ok, if it does work it would work like this:
> >
> > 1) in "Add new data source" setup in cfide choose "other" for "Driver"
> > 2) for jdbc url put jdbc:odbc:Driver={Microsoft Access Driver
> > (*.mdb)};DBQ=[path to access mdb]
> >where [path to access mdb] is C:\blah\blah.mdb or /usr/blah/blah.mdb
> > 3) Driver class = sun.jdbc.odbc.JdbcOdbcDriver
> > 4) Driver namae = whatever you want
> >
> > If it does work, please let us know.
> >
> > And I don't see why it wouldn't work in Solaris, I think I have used this
> in
> > Linux (just not with MX).
> >
> > Cheers,
> > Rob
> >
> > -Original Message-
> > From: Troy Simpson [mailto:Troy_Simpson@;ncsu.edu]
> > Sent: Thursday, October 24, 2002 10:14 AM
> > To: CF-Talk
> > Subject: Re: M$Access DB and ColdFusionMX for Solaris
> >
> > You have any more real examples for the jdbc:... string?
> > What *.jar or *.class files do I need?
> > And this will work on Sun Solaris?
> >
> > Thanks,
> > Troy
> >
> > Rob Rohan wrote:
> >
> > > Hey Troy,
> > >
> > > Try
> > >
> > > jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=[path to access
> > mdb]
> > >
> > > using the jdbc odbc bridge. That's how I access it straight from java.
> > Never
> > > tried it with MX but in theory...
> > >
> > > Rob
> > >
> > > -Original Message-
> > > From: Troy Simpson [mailto:Troy_Simpson@;ncsu.edu]
> > > Sent: Thursday, October 24, 2002 9:44 AM
> > > To: CF-Talk
> > > Subject: Re: M$Access DB and ColdFusionMX for Solaris
> > >
> > > Yea, I could.  ;-)
> > >
> > > But we are trying to provide a service for people in other departments
> and
> > > they only know
> > > MS Access.  Additionally, management wants us to try and host this on
> the
> > > Unix systems if
> > > possible.
> > >
> > > Troy
> > >
> > > David Adams wrote:
> > >
> > > > Good question and I hope you get a lot of response but can you export
> > > > the data from Access to MySQL or something that runs on UNIX and have
> > > > CF talk to it instead?
> > > >
> > > > -Original Message-
> > > > From: Troy Simpson [mailto:Troy_Simpson@;ncsu.edu]
> > > > Sent: October 23, 2002 1:23 PM
> > > > To: CF-Talk
> > > > Subject: M$Access DB and ColdFusionMX for Solaris
> > > >
> > > > I'm sitting here trying to figure a way to use ColdFusionMX on
> Solaris8
> > > > to get data out of an Microsoft Access Database.
> > > > I heard a rumor that there was an ODBC driver or some other driver
> that
> > > > would allow this to happen.
> > > > Does anyone know if this is true?
> > > > Can I store an Access DB File on a Solaris File system and use
> > > > ColdFusionMX to select data from it which is also running on the same
> > > > Solaris system?
> > > > I have a feeling that the answer would be NO, but just wanted to post
> > > > this to see if I am correct.
> > > >
> > > > I searched the CF-TALK list for this and did not find anything, but I
> > > > could have used the wrong search criteria.
> > > >
> > > > If this is indeed not possible, I thought of another idea to
> accomplish
> > > > this that might work.
> > > > Use ColdFusionMX in distributed mode.
> > > > Install ColdFusionMX and the Access DB file on a Windows2000/XP server
> > > > and use ODBC to connect to Access.
> > > > Configure the web server, maybe Apache2, on Sun Solaris8 with the
> > > > ColdFusionMX distributed client (wsconfig.jar).
> > > > I wonder if this would work like I expect it to?
> > > > Anyone already done this?
> > > > I can already see the benefits.
> > > > I can segregate my small Access Applications from the rest.  ;-)
> > > >
> > >

RE: Urgent : GURU Required: Excel vs COM in CFMX

[Adrocknaphobia Jones]

Daryl,

All this talk of web services Vs. COM is pointless. It doesn't pertain
to Office solutions. It doesn't pertain to right now.

The fact is that Office does not open its object model up for web
services natively. It is natively open as a COM object. If time is of
the essence go with the COM object. I've haven't had any major problems
using CFOBJECT in MX, of course I am using it on a small scale, not an
enterprise level solution.

If you have some development time, design a web service in .NET to
interact with the office object. Using VBA you can write the service in
NET. Since you'll be using VBA you will have access to the same objects
that COM has. Except this way it's the .NET architecture talking to the
Office objects, NOT Cold Fusion MX. Basically the web service can serve
as a mediator to ensure proper error handling in MX.

COM has been a very successful way to interact with Microsoft solutions
for some time now. It's ignorant to discount a proven technology on the
grounds that something better is coming... sometime... somehow. COM has
worked for thousands of applications in the past, and based on time and
testing, it will work now.

It's like saying that HTML will no longer get the job done, because
XHTML exists.

Adam Wayne Lehman
Web Systems Developer
Johns Hopkins Bloomberg School of Public Health
Distance Education Division


-Original Message-
From: Daryl Fullerton [mailto:Daryl.Fullerton@;biznet-solutions.com] 
Sent: Thursday, October 24, 2002 2:24 PM
To: CF-Talk
Subject: RE: Urgent : GURU Required: Excel vs COM in CFMX

Folks,

Thanks for the input so far.

Has any one got any more suggested solutions.

The thought of moving back to CF 5 is being considered if we don't get a
break through tomorrow.

We will be trying all the alternatives mentioned below in the morning.
Most of the replys are debates so appreciate any further suggestions
that may solve the problem before we make such a backward move (back to
CF5) so keep the suggestions rolling.

Cheers

Daryl

-Original Message-
From: jon hall [mailto:jonhall@;ozline.net] 
Sent: 24 October 2002 19:16
To: CF-Talk
Subject: Re: Urgent : GURU Required: Excel vs COM in CFMX


Thursday, October 24, 2002, 1:35:03 PM, you wrote:
>> It's a physical impossibility to pass xml data as
>> efficiently as passing data over a COM interface. 
>> I accept that SOAP is a viable replacement for DCOM, 
>> but not COM itself.

DW> If you're defining efficiency as speed, you're absolutely correct. 
DW> However, the general acceptance of XML should indicate that people 
DW> are often more concerned with things other than speed, such as the 
DW> use of (relatively
DW> human-readable) text formats instead of requiring binary
compatibility.

An example of being too inefficient would be sending binary data over
XML. Encoding a file into base64 when it used to be possible to send
binary is a huge performance hit and would be unacceptable. Of course
there are better ways, I'm just using this as an example.

>> Especially when with all the "industries investment in
>> Java" that is supposed to be a big reason we love Java 
>> now, nobody in Javaland has come up with as efficient 
>> an interface as MSXML. Just the thought of using a web 
>> service to parse/and receive/send XML is laughable to me.

DW> What part is laughable? The part about using HTTP as a transport 
DW> mechanism? There's nothing preventing the use of other transport 
DW> mechanisms for SOAP requests. Or the part about XML parsing? People 
DW> seem to be doing that just fine without MSXML, in general. And, of 
DW> course, using SOAP in .NET programs uses the MS parser, I'm sure, so

DW> again, I'm missing something here.

So you are suggesting creating a socket and sending a block of XML,
using SOAP to a process listening on the same machine, that does the
actual work is a decent solution? Networking socket overhead alone would
make this not a viable solution for a multiuser application. The joke
being the irony of the double work of parsing an xml packet, that is
instructing a program how do parse an xml packet, then actually parsing
the xml packet, and passing it back as...what? My sense of humor may be
odd though :)

In reference to the msxml comparison, msxml needs one line to actually
open a connection and get the xml from within CF. Using Java it takes
like 20 lines. Actually parsing the XML in java is unnecessary with CF
(unlike http, which is required because of cfhttp's deficiencies), but
parsing XML with Java is so incredibly complex as to be not worth it, at
least not for the price range of our clients.

I'm just pointing out that there are problems that have been solved with
COM that have no good counterpart in Java from my point of view, and
can't be replaced with web services. Hence web services != replacement
for COM.

-- 
 jon
 mailto:jonhall@;ozline.net



~|
Archives: http://www.houseoffusion.com/

Re: Loopy Logic

[Jerry Johnson]

Gel, what is SearchDate set to?

Jerry Johnson

>>> [EMAIL PROTECTED] 10/24/02 02:42PM >>>
Hey all,

I am writing a bit of code that is suppose to do this:

Check for a value in the database within a certain time period. 
If there is no value in this time period, then check previous months
until there is a value.

It sounds so simple. 
I tried using a conditional loop to accomplish it.










SELECT Mileage
FROM TblVmile

WHERE RecordDate
>=
to_date('#DateFormat(DateAdd('m',counter,Searchdate),'mm/dd/')#','mm
/dd/')

AND RecordDate
<=
to_date('#DateFormat(DateAdd('d',(DaysInMonth(DateAdd('m',counter,Search
date))-1),

DateAdd('m',counter,Searchdate)),'mm/dd/')#','mm/dd/')

AND Vehicle_NBR
= #GetTeamVehicles.Vehicle_NBR#









It doesn't work. The CFServer and Oracle shoot to about 100% usage
between themselves, and I never see any output.

I figure my logic is loopy.
Can anyone tell me what I'm doing wrong? :)

-Gel






~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

RE: CFMX best practices

[Michael Wilson]

Hi,

Michael did mention code optimization techniques in his initial post
(CFMX best practices, code optimizations, etc.); but, also requested a
list of best practices. Besides, if you suggest/require the use of  rather than , prior to actually coding
anything, it is a "best practice". It's best because it is optimal. :)

At any rate, I would love to get my hands on the finished product
Michael!

Mike

-Original Message-
From: Matt Liotta [mailto:mliotta@;r337.com] 

Again, it sounds like you are compiling code optimization techniques not
best practices.



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

Binary marketing tree in CF/SQL

[Jeff Beer]

I have a client who wants me to build a "No-flush Binary marketing"
application in SQL and CF.  I've looked at several examples and really
don't know how to approach building an infinite tree structure of this
sort.  Can anyone point me to resources for learning how to develop this
type of system, implementing business rules and calculating commissions?
 
I've never worked with MLM stuff.  At first glance it seems fairly
simple, but the further I get the more questions pop up.  The big thing
here is probably speed in calculating the left/right percentages and
processing downline commissions - it's an infinite structure...
 
Anyway, thanks for any information anyone can provide.
 
 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

whitespace woes

[Will Stalder]

I'm having with trouble with ColdFusion and extraneous whitespace.  And
yes, I've done my Google searching.

The problem is that I'm trying to output an XML file, and it's crucial
that there not be any whitespace before the 
declaration.

An extremely simplified likeness of my ColdFusion script (with line
numbers, lest e-mail word-wrapping confuse you) is thus:

1 
2 
3 
4 
5 
6 
7 http://www.foo.com/bar.dtd";>
8 
9 
10 
11 

So this page shows an HTML page with a form on it by default, and if the
form is submitted, it spits out XML.

As you can see, I'm trying at least two different ways to eliminate CF's
whitespace: the SuppressWhitespace and EnableCFOutputOnly.

The problem is that this is what I get from this simplified script (the
problem is the same in my big one):

http://www.foo.com/bar.dtd";>


You'll note the extra space before the 





http://www.foo.com/bar.dtd";>





Much to my surprise, the output of this file (with the proper URL inputs) 
is:
1
http://www.foo.com/bar.dtd";>


Which means the space is being added *before* any of my
whitespace-suppressing measures.

All of which just annoys the heck out of me.  Sure, I can go in and
manually delete that space, but I shouldn't *have* to.

Are there any wise warriors out there that could help here?  To my 
knowledge, we're running ColdFusion 4.0 on the server, although I only
recently inherited this project, and I'm not sure.

Thanks,
Todd


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

RE: CFMX best practices

[Ken Wilson]

>>CFMX best practices, code optimizations, etc.

>Again, it sounds like you are compiling code optimization
>techniques not best practices.


That is one part of what he was asking for. Did you have something
useful to contribute or just pursuing semantics once again?

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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.

Re: Loopy Logic

[S . Isaac Dealey]

> Hey all,

> I am writing a bit of code that is suppose to do this:

> Check for a value in the database within a certain time period.
> If there is no value in this time period, then check previous months
> until there is a value.

> It sounds so simple.
> I tried using a conditional loop to accomplish it.

>   
>   

>   

>   

>name="GetVehicleMileageLast" datasource="relora" DBTYPE="Oracle80" >

>   SELECT Mileage
> FROM TblVmile

>   WHERE RecordDate
>>=
> to_date('#DateFormat(DateAdd('m',counter,Searchdate),'mm/dd/')#','mm
> /dd/')

>   AND RecordDate
> <=
> to_date('#DateFormat(DateAdd('d',(DaysInMonth(DateAdd('m',counter,Search
> date))-1),

> DateAdd('m',counter,Searchdate)),'mm/dd/')#','mm/dd/')

>   AND Vehicle_NBR
> = #GetTeamVehicles.Vehicle_NBR#


>   

>GetVehicleMileageLast.Mileage>
>   

>   

> It doesn't work. The CFServer and Oracle shoot to about 100% usage
> between themselves, and I never see any output.

> I figure my logic is loopy.
> Can anyone tell me what I'm doing wrong? :)

Well... if the query never returns a positive value, the loop will continue
on forever... So, let's say it doesn't find anything last month, then it
continues to the previous month and finds nothing again. The previous month
is when the system was implemented, it continues to search back prior to
your first entry and find nothing and more nothing and continue the loop.
You might want to add a condition that stops the loop after it's gone back
say 12 months... This isn't to say there isn't any data there, but the query
may not be picking up that data properly, so if that's the case, then you
need to break your loop and figure out why the query isn't returning what
you need.

There's probably a better way to handle this with just SQL, but I won't bore
you with the details. :)

S. Isaac Dealey
Certified Advanced ColdFusion 5 Developer

www.turnkey.to
954-776-0046
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Re: IIS and virtual paths

[Phillip B]

Hey Paul,

Bring up the properties on the site and choose the Home Directory tab and
click Configuartion. Select .cfm and click edit then uncheck the "Check that
file exist" box.

HTH

Phillip Broussard
http://www.fillworks.com/
http://www.loungeroyale.com/

001010101011001010101101
101000100010110100101101
Decoder Ring (http://www.loungeroyale.com/experiences/coderring/)


- Original Message -
From: "Paul Giesenhagen" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, October 23, 2002 2:35 PM
Subject: OT: IIS and virtual paths


> I tried to find this as I know it was discussed before, but if you have a
> url string like:
>
> http://www.domain.com/index.cfm/id/123/param/222
>
> And it gives out a 404 error, how can you make IIS not look to see if the
> file actually exists?
>
> ( I think I am asking that right )
>
> Thanks
> Paul Giesenhagen
> QuillDesign
>
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

RE: OT: Dreamweaver MX saves slowwwly

[Tony Weeg]

do you notice it when it starts the laborious
re-indexing (or whatever the FU** its doing whenever you make
a change to any files) of the site files?

..tony

Tony Weeg
Senior Web Developer
Information System Design
Navtrak, Inc.
Fleet Management Solutions
www.navtrak.net
410.548.2337 


-Original Message-
From: David Notik [mailto:dave@;digital202.com] 
Sent: Thursday, October 24, 2002 2:36 PM
To: CF-Talk
Subject: RE: OT: Dreamweaver MX saves slowwwly


Hmmm...  it's saving to a local folder, not across the network.

Plenty of space, tons of RAM, super-awesome P4 2.2Ghz.

Where might I start looking for the issue?

--D


-Original Message-
From: Brian Scandale [mailto:Brrrian@;Excite.com] 
Sent: Thursday, October 24, 2002 10:30 AM
To: CF-Talk
Subject: Re: OT: Dreamweaver MX saves slowwwly

Sounds very much like a network configuration issue to me. Either the
network config or workstation config could be responsible.

At 11:18 AM 10/24/02, you wrote:
>Anybody else encounter this?
> 
>When saving an open document in Dreamweaver MX, it hangs for a few
>annoying seconds before it finally saves.  Not good when you're a web
>developer constantly saving and refreshing.
> 
>--Dave
> 
>###
>David Notik
>Digital202, LLC
>Imagination gone digital.
>Web:   www.digital202.com
>E-mail:   [EMAIL PROTECTED]
>Office: (206) 575-1717
>Mobile: (206) 351-3948
>###
> 
>
>


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

Re: Using CFEXECUTE from a Web Browser???

[Jochem van Dieten]

Paris Lundis wrote:

> ahh, connect a printer to your server.. which isn't a smart idea...

For some applications, it is a very smart idea. Why? No hacker kan mess 
with what is printed.
What do you think that noise is you hear when you get money at an ATM?

Jochem

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

Re: Using CFEXECUTE from a Web Browser???

[Jochem van Dieten]

Dave Cordes wrote:

> Jochem,
> Do you have an idea how I would use this solution from the server. I 
> mean, it works great on localhost, but I can't run this from the 
> server because the printer is installed locally.

If you mean over the internet to just any visitor: no way. You don't 
even know if they have a printer. If you are talking intranet with a 
server in the basement and an office on the 18th floor where the printer 
is, it might be possible.
My first try would be to share the printer using SMB and then see if the 
copy works. If that works from the command line, it is just a matter of 
changing the cfexecute command to whatever you type in the command line.
Alternatively, make CF dump the file to the spool dir of the printer 
server. Or to just dump it top a certain directory and set up a batch 
file to print them from there on the printer server.

Jochem

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

OT: BBS was RE: Urgent : GURU Required: Excel vs COM in CFMX

[S . Isaac Dealey]

My favorite BBS was called Katmandu ( after an old Cat Stevens song ) and
run on Opus. :P The sysop named all the "rooms" after other Cat Stevens
songs. When he converted to Islam the board changed to DreamPark ( after a
novel about live rpg's ), which I thought was kinda crummy. I still love
Cat's music. Seeing My Grandson Grow Old wasn't even produced until after he
converted. But then I'm neither islamic nor christian, so I could care less
what Cat's religeous affiliation is.

And I never got to use Kermit, but I liked the name. ;P

I should stop now, I'm way off-topic! :P

S. Isaac Dealey
Certified Advanced ColdFusion 5 Developer

www.turnkey.to
954-776-0046

> I actually miss BBS days :(  (WWIV, VBBS, etc..)

> Brian Yager
> President - North AL Cold Fusion Users Group
> http://www.nacfug.com
> Sr. Systems Analyst
> Sverdrup/CIC
> [EMAIL PROTECTED]
> (256) 842-8342


> -Original Message-
> From: S. Isaac Dealey [mailto:info@;turnkey.to]
> Sent: Thursday, October 24, 2002 12:40 PM
> To: CF-Talk
> Subject: Re: Urgent : GURU Required: Excel vs COM in CFMX


>> Thursday, October 24, 2002, 12:23:04 PM, you wrote:
 Web Services != replacement for COM.

Not by a long shot.

>> DW> It certainly works well as a replacement for DCOM; while it might not
>> DW> replace everything that COM does now, it can certainly replace some
>> of
>> it.
>> DW> SOAP, or something SOAP-like, could certainly replace a lot of the
>> rest of
>> DW> COM; you just have to figure out what you'll use for inter-process
>> DW> communication. So, I'm not sure if it's really the long shot that you
>> think.

>> It's a physical impossibility to pass xml data as efficiently as
>> passing data over a COM interface. I accept that SOAP is a viable
>> replacement for DCOM, but not COM itself.

>> Especially when with all the "industries investment in Java" that is
>> supposed to be a big reason we love Java now, nobody in Javaland has
>> come up with as efficient an interface as MSXML. Just the thought of
>> using a web service to parse/and receive/send XML is laughable to me.

> It is the natural progression, however. Speed / Efficiency is not the big
> selling point of xml web services. They've been designed / developed and
> implemented with the reasonable assumption that speed will continue to be
> less and less an issue as time passes. In the past 50-60 years speed,
> memory
> and storage have all continued to become less and less an issue in
> computing
> and there's no reason to believe the same won't continue. In a few years,
> the fact that web services were slow in the now will be completely moot.
> What will remain ( after their speed is no longer an issue ) is what they
> do
> provide, which is ( from what I understand ) a more flexible / dynamic and
> easier to develop method of moving and transforming data / content and
> separating it from format or platform.

> Case in point: Does anybody here particularly care that MS Word 2000 would
> be slow as hell on an old 286? ( That is assuming an old 286 would even
> support it. )

> For that matter, I remember some machines with boot cycles of 5 minutes or
> longer from as shortly ago as 1995 and Windows 95. Or for that matter
> waiting 30 minutes or an hour to download a reasonably small file from a
> BBS
> on my old monochrome DataGeneral and NEC laptops that I got hand-me-downed
> from my dad.

> Software is invariably developed "before its time"... That is the nature
> of
> the business ( or perhaps even human nature ) that innovation occurs
> because
> things that are not practical now are implemented now anyway and then made
> practical by further development because the innovators are able to see
> the
> potential. If everybody waited until everything were fast and easy, nobody
> would make any money and the industry would go nowhere. Everyone would be
> waiting on everyone else to produce something faster, more efficient, etc.
> But those things would never be developed because the companies trying to
> develop them would never have the money to develop and produce them as a
> result of never getting sales because their customers are waiting for the
> product to improve.

> This doesn't by any means indicate that everyone needs to be a forerunner
> and jump onto every new technology before it's practical -- this would be
> suicide. But those with the ability to work with a few new technologies
> before they are practical have the advantage of being early and getting a
> bigger piece of that new market.

> I often still wish the industry would evolve a bit slower than it does,
> but
> that's admittedly my own personal hangup, and it has more to do with
> economic equality ( if there is such a thing ) and "the digital divide"
> than
> with anything else.

> 


> S. Isaac Dealey
> Certified Advanced ColdFusion 5 Developer

> www.turnkey.to
> 954-776-0046

> 
~|
Archives: http://www.houseoffusio

RE: CFMX best practices

[David Notik]

Hopefully you'll put this list online somewhere for all to see -- those
things would be nice to know.

--D

###
David Notik
Digital202, LLC
Imagination gone digital.
Web: www.digital202.com
E-mail: [EMAIL PROTECTED]
Office: (206) 575-1717
Mobile: (206) 351-3948
###


-Original Message-
From: Michael Dinowitz [mailto:mdinowit@;houseoffusion.com] 
Sent: Thursday, October 24, 2002 10:44 AM
To: CF-Talk
Subject: CFMX best practices

I know this has come up before and I'm not trying to start it up again.
This
is a request for anyone on the list who knows of or has any CFMX best
practices, code optimizations, etc. to email them to me off list at
[EMAIL PROTECTED] I'm compiling many of them together for part
of
a presentation on differences in best practices between CF 5 (and
earlier)
and CFMX.
Even little things like:
In CF5 IIF() was half as fast as CFIF but in CFMX they run at the same
speed
In CFMX, doing a boolean comparison of  is faster than
 or  because the way the CF
template is
compiled into java makes the first a boolean operation and the others a
comparison (text and numbers) operation

Even if it'll only save fractions of a second, I'd like to hear of it. I
may
have missed some. :)
Thanks

Michael Dinowitz
Master of the House of Fusion
http://www.houseoffusion.com


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

RE: CFMX best practices

[Matt Liotta]

Again, it sounds like you are compiling code optimization techniques not
best practices.

Matt Liotta
President & CEO
Montara Software, Inc.
http://www.montarasoftware.com/
888-408-0900 x901

> -Original Message-
> From: Michael Dinowitz [mailto:mdinowit@;houseoffusion.com]
> Sent: Thursday, October 24, 2002 2:44 PM
> To: CF-Talk
> Subject: CFMX best practices
> 
> I know this has come up before and I'm not trying to start it up
again.
> This
> is a request for anyone on the list who knows of or has any CFMX best
> practices, code optimizations, etc. to email them to me off list at
> [EMAIL PROTECTED] I'm compiling many of them together for
part
> of
> a presentation on differences in best practices between CF 5 (and
earlier)
> and CFMX.
> Even little things like:
> In CF5 IIF() was half as fast as CFIF but in CFMX they run at the same
> speed
> In CFMX, doing a boolean comparison of  is faster than
>  variable is true> or  because the way the CF
template
> is
> compiled into java makes the first a boolean operation and the others
a
> comparison (text and numbers) operation
> 
> Even if it'll only save fractions of a second, I'd like to hear of it.
I
> may
> have missed some. :)
> Thanks
> 
> Michael Dinowitz
> Master of the House of Fusion
> http://www.houseoffusion.com
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

RE: CFGRAPH Help

[Joshua Miller]

Yeah, I've tried hex numbers as well ... No luck. It also doesn't
display the title.

Joshua Miller
[EMAIL PROTECTED]


-Original Message-
From: Brook Davies [mailto:brook@;maracasmedia.com] 
Sent: Thursday, October 24, 2002 2:06 PM
To: CF-Talk
Subject: Re: CFGRAPH Help


Have you tried using hexadecimals?


At 02:00 PM 24/10/02 -0400, you wrote:
>I'm having some strange problems using CFGRAPH under CFMX ... I've 
>specified for specific colors to display in the bars and for the title 
>to display, but it the title doesn't show and the colors are always 
>red. Anyone know what this could be?
>
>   type="Bar"
>   title="Inspections By Month"
>   barspacing="3"
>   bordercolor="99"
>   borderwidth="0"
>   fileformat="Flash"
>   graphheight="200"
>   graphwidth="185"
>   colorlist="blue"
>   showItemLabel="YES"
>   itemLabelFont="Arial"
>   itemLabelSize="10"
>   depth="0">
>
>   
>   
>   
>   
>   
>   
>   
>   
>   
>   
>   
>   
>
>  
>
>Joshua Miller
>[EMAIL PROTECTED]
>
>
>

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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.

Re: HTTP Compression and ColdFusion

[cf-talk]

Another way to do it is to go to the c:\inetpub\AdminScripts directory and
create a .BAT file.  Put the following into the .BAT file:

cscript.exe adsutil.vbs set
W3Svc/Filters/Compression/GZIP/HcScriptFileExtensions "asp" "cfm" "dll"
"exe" "aspx"
cscript.exe adsutil.vbs set
W3Svc/Filters/Compression/DEFLATE/HcScriptFileExtensions "asp" "cfm" "dll"
"exe" "aspx"
IISreset.exe /restart

Note that the BAT file contains only 3 lines... it might wrap in your mail
reader.  The reason I like this method is that I can modify my .BAT file at
any time and add or remove extensions.  Please note that this only modifies
the "Application" extensions.  If you want to modify the "static" page
extensions the command is slightly different.

-Novak

- Original Message -
From: "Jochem van Dieten" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, October 24, 2002 4:29 AM
Subject: Re: HTTP Compression and ColdFusion


> Jesse Houwing wrote:
>
> > Do you ahve any information as to how to do this? I can run the
> > script, but it is not very self expleining I'm afraid.
>
> Download the metabase editor from Microsoft
> http://support.microsoft.com/default.aspx?scid=kb;en-us;Q232068
> It is a RegEdit lookalike, only it is used to change the IIS metabase.
> Add cfm to the list of extensions in both
> LM\W3SVC\Filters\Compression\Deflate\HcScriptFileExtensions and
> LM\W3SVC\Filters\Compression\Gzip\HcScriptFileExtensions and restart the
> service.
>
> Jochem
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

Loopy Logic

[Angel Stewart]

Hey all,

I am writing a bit of code that is suppose to do this:

Check for a value in the database within a certain time period. 
If there is no value in this time period, then check previous months
until there is a value.

It sounds so simple. 
I tried using a conditional loop to accomplish it.










SELECT Mileage
FROM TblVmile

WHERE RecordDate
>=
to_date('#DateFormat(DateAdd('m',counter,Searchdate),'mm/dd/')#','mm
/dd/')

AND RecordDate
<=
to_date('#DateFormat(DateAdd('d',(DaysInMonth(DateAdd('m',counter,Search
date))-1),

DateAdd('m',counter,Searchdate)),'mm/dd/')#','mm/dd/')

AND Vehicle_NBR
= #GetTeamVehicles.Vehicle_NBR#









It doesn't work. The CFServer and Oracle shoot to about 100% usage
between themselves, and I never see any output.

I figure my logic is loopy.
Can anyone tell me what I'm doing wrong? :)

-Gel





~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Re: Urgent : GURU Required: Excel vs COM in CFMX

[jon hall]

Thursday, October 24, 2002, 1:55:23 PM, you wrote:
RR> 
RR> > Especially when with all the "industries investment in
RR> > Java" that is supposed to be a big reason we love Java
RR> > now, nobody in Javaland has come up with as efficient
RR> > an interface as MSXML.
RR> Two things.

RR> First, as I am sure you are aware MSXML runs only on windows. And XML is
RR> supposed to be a platform / language independent way to represent data.
RR> Xerces and Saxon run on a great many operation systems - that is why I love
RR> java.

I said "a big reason" not "the big reason". I agree cross platform is
a big advantage.

RR> Second, I would like to see some data that supports your claim. Now, I know
RR> MSXML is written in C (or some compiled language) so is probably faster, but
RR> I would like to know how much faster it really is - I assume you are
RR> referring to speed and not the actual API interface - if you are referring
RR> to the API, see the first comment.

I was referring to the API. From within MX I imagine the Java solution
is probably faster...oh wait, can't really compare the two solutions
can we? COM is dead after all.

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

RE: Urgent : GURU Required: Excel vs COM in CFMX

[Lee Fuller]

Ahhh.. Yes..   Me too...


| -Original Message-
| From: Yager, Brian T Contractor/Sverdrup 
| [mailto:brian.yager@;redstone.army.mil] 
| Sent: Thursday, October 24, 2002 11:36 AM
| To: CF-Talk
| Subject: RE: Urgent : GURU Required: Excel vs COM in CFMX
| 
| 
| I actually miss BBS days :(  (WWIV, VBBS, etc..)
| 
| Brian Yager
| President - North AL Cold Fusion Users Group 
| http://www.nacfug.com Sr. Systems Analyst Sverdrup/CIC 
| [EMAIL PROTECTED]
| (256) 842-8342
| 
| 
| -Original Message-
| From: S. Isaac Dealey [mailto:info@;turnkey.to]
| Sent: Thursday, October 24, 2002 12:40 PM
| To: CF-Talk
| Subject: Re: Urgent : GURU Required: Excel vs COM in CFMX
| 
| 
| > Thursday, October 24, 2002, 12:23:04 PM, you wrote:
| >>> Web Services != replacement for COM.
| >>>
| >>>Not by a long shot.
| 
| > DW> It certainly works well as a replacement for DCOM; 
| while it might 
| > DW> not replace everything that COM does now, it can 
| certainly replace 
| > DW> some of
| > it.
| > DW> SOAP, or something SOAP-like, could certainly replace a 
| lot of the
| > rest of
| > DW> COM; you just have to figure out what you'll use for 
| inter-process 
| > DW> communication. So, I'm not sure if it's really the long 
| shot that 
| > DW> you
| > think.
| 
| > It's a physical impossibility to pass xml data as efficiently as 
| > passing data over a COM interface. I accept that SOAP is a viable 
| > replacement for DCOM, but not COM itself.
| 
| > Especially when with all the "industries investment in 
| Java" that is 
| > supposed to be a big reason we love Java now, nobody in 
| Javaland has 
| > come up with as efficient an interface as MSXML. Just the 
| thought of 
| > using a web service to parse/and receive/send XML is 
| laughable to me.
| 
| It is the natural progression, however. Speed / Efficiency is 
| not the big selling point of xml web services. They've been 
| designed / developed and implemented with the reasonable 
| assumption that speed will continue to be less and less an 
| issue as time passes. In the past 50-60 years speed, memory 
| and storage have all continued to become less and less an 
| issue in computing and there's no reason to believe the same 
| won't continue. In a few years, the fact that web services 
| were slow in the now will be completely moot. What will 
| remain ( after their speed is no longer an issue ) is what 
| they do provide, which is ( from what I understand ) a more 
| flexible / dynamic and easier to develop method of moving and 
| transforming data / content and separating it from format or platform.
| 
| Case in point: Does anybody here particularly care that MS 
| Word 2000 would be slow as hell on an old 286? ( That is 
| assuming an old 286 would even support it. )
| 
| For that matter, I remember some machines with boot cycles of 
| 5 minutes or longer from as shortly ago as 1995 and Windows 
| 95. Or for that matter waiting 30 minutes or an hour to 
| download a reasonably small file from a BBS on my old 
| monochrome DataGeneral and NEC laptops that I got 
| hand-me-downed from my dad.
| 
| Software is invariably developed "before its time"... That is 
| the nature of the business ( or perhaps even human nature ) 
| that innovation occurs because things that are not practical 
| now are implemented now anyway and then made practical by 
| further development because the innovators are able to see 
| the potential. If everybody waited until everything were fast 
| and easy, nobody would make any money and the industry would 
| go nowhere. Everyone would be waiting on everyone else to 
| produce something faster, more efficient, etc. But those 
| things would never be developed because the companies trying 
| to develop them would never have the money to develop and 
| produce them as a result of never getting sales because their 
| customers are waiting for the product to improve.
| 
| This doesn't by any means indicate that everyone needs to be 
| a forerunner and jump onto every new technology before it's 
| practical -- this would be suicide. But those with the 
| ability to work with a few new technologies before they are 
| practical have the advantage of being early and getting a 
| bigger piece of that new market.
| 
| I often still wish the industry would evolve a bit slower 
| than it does, but that's admittedly my own personal hangup, 
| and it has more to do with economic equality ( if there is 
| such a thing ) and "the digital divide" than with anything else.
| 
| 
| 
| 
| S. Isaac Dealey
| Certified Advanced ColdFusion 5 Developer
| 
www.turnkey.to
954-776-0046


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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 t

CFMX best practices

[Michael Dinowitz]

I know this has come up before and I'm not trying to start it up again. This
is a request for anyone on the list who knows of or has any CFMX best
practices, code optimizations, etc. to email them to me off list at
[EMAIL PROTECTED] I'm compiling many of them together for part of
a presentation on differences in best practices between CF 5 (and earlier)
and CFMX.
Even little things like:
In CF5 IIF() was half as fast as CFIF but in CFMX they run at the same speed
In CFMX, doing a boolean comparison of  is faster than  or  because the way the CF template is
compiled into java makes the first a boolean operation and the others a
comparison (text and numbers) operation

Even if it'll only save fractions of a second, I'd like to hear of it. I may
have missed some. :)
Thanks

Michael Dinowitz
Master of the House of Fusion
http://www.houseoffusion.com

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

RE: Urgent : GURU Required: Excel vs COM in CFMX

[Yager, Brian T Contractor/Sverdrup]

I actually miss BBS days :(  (WWIV, VBBS, etc..)

Brian Yager
President - North AL Cold Fusion Users Group
http://www.nacfug.com
Sr. Systems Analyst
Sverdrup/CIC
[EMAIL PROTECTED]
(256) 842-8342


-Original Message-
From: S. Isaac Dealey [mailto:info@;turnkey.to]
Sent: Thursday, October 24, 2002 12:40 PM
To: CF-Talk
Subject: Re: Urgent : GURU Required: Excel vs COM in CFMX


> Thursday, October 24, 2002, 12:23:04 PM, you wrote:
>>> Web Services != replacement for COM.
>>>
>>>Not by a long shot.

> DW> It certainly works well as a replacement for DCOM; while it might not
> DW> replace everything that COM does now, it can certainly replace some of
> it.
> DW> SOAP, or something SOAP-like, could certainly replace a lot of the
> rest of
> DW> COM; you just have to figure out what you'll use for inter-process
> DW> communication. So, I'm not sure if it's really the long shot that you
> think.

> It's a physical impossibility to pass xml data as efficiently as
> passing data over a COM interface. I accept that SOAP is a viable
> replacement for DCOM, but not COM itself.

> Especially when with all the "industries investment in Java" that is
> supposed to be a big reason we love Java now, nobody in Javaland has
> come up with as efficient an interface as MSXML. Just the thought of
> using a web service to parse/and receive/send XML is laughable to me.

It is the natural progression, however. Speed / Efficiency is not the big
selling point of xml web services. They've been designed / developed and
implemented with the reasonable assumption that speed will continue to be
less and less an issue as time passes. In the past 50-60 years speed, memory
and storage have all continued to become less and less an issue in computing
and there's no reason to believe the same won't continue. In a few years,
the fact that web services were slow in the now will be completely moot.
What will remain ( after their speed is no longer an issue ) is what they do
provide, which is ( from what I understand ) a more flexible / dynamic and
easier to develop method of moving and transforming data / content and
separating it from format or platform.

Case in point: Does anybody here particularly care that MS Word 2000 would
be slow as hell on an old 286? ( That is assuming an old 286 would even
support it. )

For that matter, I remember some machines with boot cycles of 5 minutes or
longer from as shortly ago as 1995 and Windows 95. Or for that matter
waiting 30 minutes or an hour to download a reasonably small file from a BBS
on my old monochrome DataGeneral and NEC laptops that I got hand-me-downed
from my dad.

Software is invariably developed "before its time"... That is the nature of
the business ( or perhaps even human nature ) that innovation occurs because
things that are not practical now are implemented now anyway and then made
practical by further development because the innovators are able to see the
potential. If everybody waited until everything were fast and easy, nobody
would make any money and the industry would go nowhere. Everyone would be
waiting on everyone else to produce something faster, more efficient, etc.
But those things would never be developed because the companies trying to
develop them would never have the money to develop and produce them as a
result of never getting sales because their customers are waiting for the
product to improve.

This doesn't by any means indicate that everyone needs to be a forerunner
and jump onto every new technology before it's practical -- this would be
suicide. But those with the ability to work with a few new technologies
before they are practical have the advantage of being early and getting a
bigger piece of that new market.

I often still wish the industry would evolve a bit slower than it does, but
that's admittedly my own personal hangup, and it has more to do with
economic equality ( if there is such a thing ) and "the digital divide" than
with anything else.




S. Isaac Dealey
Certified Advanced ColdFusion 5 Developer

www.turnkey.to
954-776-0046

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Re: OT: Dreamweaver MX saves slowwwly

[Brian Scandale]

Sounds very much like a network configuration issue to me. Either the network config 
or workstation config could be responsible.

At 11:18 AM 10/24/02, you wrote:
>Anybody else encounter this?
> 
>When saving an open document in Dreamweaver MX, it hangs for a few
>annoying seconds before it finally saves.  Not good when you're a web
>developer constantly saving and refreshing.
> 
>--Dave
> 
>###
>David Notik
>Digital202, LLC
>Imagination gone digital.
>Web:   www.digital202.com
>E-mail:   [EMAIL PROTECTED]
>Office: (206) 575-1717
>Mobile: (206) 351-3948
>###
> 
>
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Re: Urgent : GURU Required: Excel vs COM in CFMX

[jon hall]

Thursday, October 24, 2002, 1:35:03 PM, you wrote:
>> It's a physical impossibility to pass xml data as 
>> efficiently as passing data over a COM interface. 
>> I accept that SOAP is a viable replacement for DCOM, 
>> but not COM itself.

DW> If you're defining efficiency as speed, you're absolutely correct. However,
DW> the general acceptance of XML should indicate that people are often more
DW> concerned with things other than speed, such as the use of (relatively
DW> human-readable) text formats instead of requiring binary compatibility.

An example of being too inefficient would be sending binary data over
XML. Encoding a file into base64 when it used to be possible to send
binary is a huge performance hit and would be unacceptable. Of course
there are better ways, I'm just using this as an example.

>> Especially when with all the "industries investment in 
>> Java" that is supposed to be a big reason we love Java 
>> now, nobody in Javaland has come up with as efficient 
>> an interface as MSXML. Just the thought of using a web 
>> service to parse/and receive/send XML is laughable to me.

DW> What part is laughable? The part about using HTTP as a transport mechanism?
DW> There's nothing preventing the use of other transport mechanisms for SOAP
DW> requests. Or the part about XML parsing? People seem to be doing that just
DW> fine without MSXML, in general. And, of course, using SOAP in .NET programs
DW> uses the MS parser, I'm sure, so again, I'm missing something here.

So you are suggesting creating a socket and sending a block of XML,
using SOAP to a process listening on the same machine, that does the
actual work is a decent solution? Networking socket overhead alone
would make this not a viable solution for a multiuser application. The
joke being the irony of the double work of parsing an xml packet, that is
instructing a program how do parse an xml packet, then actually
parsing the xml packet, and passing it back as...what? My sense of
humor may be odd though :)

In reference to the msxml comparison, msxml needs one line to actually
open a connection and get the xml from within CF. Using Java it takes
like 20 lines. Actually parsing the XML in java is unnecessary with CF
(unlike http, which is required because of cfhttp's deficiencies), but
parsing XML with Java is so incredibly complex as to be not worth it,
at least not for the price range of our clients.

I'm just pointing out that there are problems that have been solved
with COM that have no good counterpart in Java from my point of view,
and can't be replaced with web services. Hence web services != replacement for COM.

-- 
 jon
 mailto:jonhall@;ozline.net

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

OT: Dreamweaver MX saves slowwwly

[David Notik]

Anybody else encounter this?
 
When saving an open document in Dreamweaver MX, it hangs for a few
annoying seconds before it finally saves.  Not good when you're a web
developer constantly saving and refreshing.
 
--Dave
 
###
David Notik
Digital202, LLC
Imagination gone digital.
Web:   www.digital202.com
E-mail:   [EMAIL PROTECTED]
Office: (206) 575-1717
Mobile: (206) 351-3948
###
 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

Re: CFGRAPH Help

[Brook Davies]

Have you tried using hexadecimals?


At 02:00 PM 24/10/02 -0400, you wrote:
>I'm having some strange problems using CFGRAPH under CFMX ... I've
>specified for specific colors to display in the bars and for the title
>to display, but it the title doesn't show and the colors are always red.
>Anyone know what this could be?
>
>   type="Bar"
>   title="Inspections By Month"
>   barspacing="3"
>   bordercolor="99"
>   borderwidth="0"
>   fileformat="Flash"
>   graphheight="200"
>   graphwidth="185"
>   colorlist="blue"
>   showItemLabel="YES"
>   itemLabelFont="Arial"
>   itemLabelSize="10"
>   depth="0">
>
>   
>   
>   
>   
>   
>   
>   
>   
>   
>   
>   
>   
>
>  
>
>Joshua Miller
>[EMAIL PROTECTED]
>
>
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

RE: Can CF search a string from the right to the left.

[Ciliotta, Mario]

Thanks for the help.

-Original Message-
From: Jerry Johnson [mailto:jjohnson@;lawyersweekly.com]
Sent: Thursday, October 24, 2002 11:04 AM
To: CF-Talk
Subject: Re: Can CF search a string from the right to the left.


But an easier way might be to treat the string as a list delimited with /, and delete 
the last element from the list




Jerry Johnson

>>> [EMAIL PROTECTED] 10/24/02 10:34AM >>>
Hi,

I was wondering if anyone knows of a cf function or a tag that will search a string 
from the right to the left, instead of the left to the right.

I want to search a string say:  http://www.somesite.com/folder1/index.cfm   What I 
want returned is everything from the last "/" to the beginning.

Is there any function or tag that can do this, I can write the code to do it with from 
the left to the right but I was just wondering if a something else existed.

Thanks

Mario

This message is for the named person's use only. It may contain sensitive and private 
proprietary or legally privileged information. No confidentiality or privilege is 
waived or lost by any mistransmission. If you are not the intended recipient, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it and notify the sender. You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient. CREDIT SUISSE GROUP and each legal entity in the CREDIT SUISSE FIRST BOSTON 
or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT SUISSE FIRST BOSTON reserve 
the right to monitor all e-mail communications through its networks. Any views 
expressed in this message are those of the individual sender, except where the message 
states otherwise and the sender is authorized to state them to be the views of any 
such entity.
Unless otherwise stated, any pricing information given in this message is indicative  
only, is subject to change and does not constitute an offer to deal at any price 
quoted. Any reference to the terms of executed transactions should be treated as  
preliminary only and subject to our formal written confirmation.




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

RE: M$Access DB and ColdFusionMX for Solaris

[Rob Rohan]

and you need to have a space

Microsoft Access Driver (*.mdb)
   ^--- space!
-Original Message-
From: Rob Rohan [mailto:rob@;cardinalweb.com]
Sent: Thursday, October 24, 2002 10:58 AM
To: CF-Talk
Subject: RE: M$Access DB and ColdFusionMX for Solaris


no []

Good luck

-Original Message-
From: Troy Simpson [mailto:Troy_Simpson@;ncsu.edu]
Sent: Thursday, October 24, 2002 10:54 AM
To: CF-Talk
Subject: Re: M$Access DB and ColdFusionMX for Solaris


Thanks Rob it this works it would be great. :-)

So the Java URL would be:

jdbc:odbc:Driver={Microsoft Access Driver(*.mdb)};DBQ=[/usr/db/db1.mdb]
or
jdbc:odbc:Driver={Microsoft Access Driver(*.mdb)};DBQ=/usr/db/db1.mdb

The second one does not have the [,].

The reason I'm asking for examples is because if it is going to work, the
syntax is what
usually kills it.

Thanks,
Troy

Rob Rohan wrote:

> Ok, if it does work it would work like this:
>
> 1) in "Add new data source" setup in cfide choose "other" for "Driver"
> 2) for jdbc url put jdbc:odbc:Driver={Microsoft Access Driver
> (*.mdb)};DBQ=[path to access mdb]
>where [path to access mdb] is C:\blah\blah.mdb or /usr/blah/blah.mdb
> 3) Driver class = sun.jdbc.odbc.JdbcOdbcDriver
> 4) Driver namae = whatever you want
>
> If it does work, please let us know.
>
> And I don't see why it wouldn't work in Solaris, I think I have used this
in
> Linux (just not with MX).
>
> Cheers,
> Rob
>
> -Original Message-
> From: Troy Simpson [mailto:Troy_Simpson@;ncsu.edu]
> Sent: Thursday, October 24, 2002 10:14 AM
> To: CF-Talk
> Subject: Re: M$Access DB and ColdFusionMX for Solaris
>
> You have any more real examples for the jdbc:... string?
> What *.jar or *.class files do I need?
> And this will work on Sun Solaris?
>
> Thanks,
> Troy
>
> Rob Rohan wrote:
>
> > Hey Troy,
> >
> > Try
> >
> > jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=[path to access
> mdb]
> >
> > using the jdbc odbc bridge. That's how I access it straight from java.
> Never
> > tried it with MX but in theory...
> >
> > Rob
> >
> > -Original Message-
> > From: Troy Simpson [mailto:Troy_Simpson@;ncsu.edu]
> > Sent: Thursday, October 24, 2002 9:44 AM
> > To: CF-Talk
> > Subject: Re: M$Access DB and ColdFusionMX for Solaris
> >
> > Yea, I could.  ;-)
> >
> > But we are trying to provide a service for people in other departments
and
> > they only know
> > MS Access.  Additionally, management wants us to try and host this on
the
> > Unix systems if
> > possible.
> >
> > Troy
> >
> > David Adams wrote:
> >
> > > Good question and I hope you get a lot of response but can you export
> > > the data from Access to MySQL or something that runs on UNIX and have
> > > CF talk to it instead?
> > >
> > > -Original Message-
> > > From: Troy Simpson [mailto:Troy_Simpson@;ncsu.edu]
> > > Sent: October 23, 2002 1:23 PM
> > > To: CF-Talk
> > > Subject: M$Access DB and ColdFusionMX for Solaris
> > >
> > > I'm sitting here trying to figure a way to use ColdFusionMX on
Solaris8
> > > to get data out of an Microsoft Access Database.
> > > I heard a rumor that there was an ODBC driver or some other driver
that
> > > would allow this to happen.
> > > Does anyone know if this is true?
> > > Can I store an Access DB File on a Solaris File system and use
> > > ColdFusionMX to select data from it which is also running on the same
> > > Solaris system?
> > > I have a feeling that the answer would be NO, but just wanted to post
> > > this to see if I am correct.
> > >
> > > I searched the CF-TALK list for this and did not find anything, but I
> > > could have used the wrong search criteria.
> > >
> > > If this is indeed not possible, I thought of another idea to
accomplish
> > > this that might work.
> > > Use ColdFusionMX in distributed mode.
> > > Install ColdFusionMX and the Access DB file on a Windows2000/XP server
> > > and use ODBC to connect to Access.
> > > Configure the web server, maybe Apache2, on Sun Solaris8 with the
> > > ColdFusionMX distributed client (wsconfig.jar).
> > > I wonder if this would work like I expect it to?
> > > Anyone already done this?
> > > I can already see the benefits.
> > > I can segregate my small Access Applications from the rest.  ;-)
> > >
> > > I strongly invite any and all comments.
> > >
> > > Thanks,
> > > Troy
> > >
> > > --
> > > -
> > > Troy Simpson
> > >   Applications Analyst/Programmer, MCSE, OCPDBA
> > > North Carolina State University Libraries
> > > Campus Box 7111 | Raleigh | North Carolina
> > > ph.919.515.3855 | fax.919.513.3330
> > > E-mail: [EMAIL PROTECTED]
> > >
> > >
> >
> >
>
>


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place f

RE: Using CFEXECUTE from a Web Browser???

[Dave Cordes]

It's a Zebra LP2844 thermal printer. What kind of print server appliance are
you talking about?

Dave Cordes
Senior ColdFusion Developer
636-939-1081 (H)
636-578-4235 (M)

-Original Message-
From: Paris Lundis [mailto:PLundis@;areaindex.com]
Sent: Thursday, October 24, 2002 12:14 PM
To: CF-Talk
Subject: RE: Using CFEXECUTE from a Web Browser???


It all depends on the printer you are using.. if its a thermal barcode
type, well you likely will need to but a printserver appliance to smack
an IP to it...

Now if laser is the case, HP tends to be mostly IP based on the
business models or optional upgrade...  Administration and all can be
done via IP / Web browser...

The firewall matter is easily remedied by opening the Microsoft service
port used for such things... MS should have a list of PORT stuff
somewhere on their website... numbers of firewall vendors make such
available for easy configuration by new buyer.


-paris

Paris Lundis
Founder
Areaindex, L.L.C.
http://www.areaindex.com
http://www.pubcrawler.com
412-292-3135
[finding the future in the past, passing the future in the present]
[connecting people, places and things]


-Original Message-
From: "Dave Cordes" <[EMAIL PROTECTED]>
Date: Thu, 24 Oct 2002 12:04:09 -0500
Subject: RE: Using CFEXECUTE from a Web Browser???

> Interesting idea adding a printer via IP address. Obviously we would
> have to
> open the firewall in order to make that happen.
>
> Dave Cordes
> Senior ColdFusion Developer
> 636-939-1081 (H)
> 636-578-4235 (M)
>
> -Original Message-
> From: Paris Lundis [mailto:PLundis@;areaindex.com]
> Sent: Thursday, October 24, 2002 11:38 AM
> To: CF-Talk
> Subject: RE: Using CFEXECUTE from a Web Browser???
>
>
> ahh, connect a printer to your server.. which isn't a smart idea...
>
> alternatively... hmmm CF from the server runs the custom batch to get
> report or whatever (custom barcode).. then uses the CFHTTP to post to
> a
> CF template on your local box where the printer is...
>
> you could use other means to accomodate... but generally, thats what
> I
> would do...
>
> or, you could just connect the webserver to the printer by mapping it
> as a connected printer resource - especially if the printer support
> IP
> or you have a print server attached to it... so you would print to
> like
> LPT2 instead which is really a mapped resource that isn't physically
> connected to the server but your workstation...
>
> If you have the IP ability and can peer through firewall in and out,
> you could really make this work with your servers sitting across the
> planet.
>
> -paris
>
> Paris Lundis
> Founder
> Areaindex, L.L.C.
> http://www.areaindex.com
> http://www.pubcrawler.com
> 412-292-3135
> [finding the future in the past, passing the future in the present]
> [connecting people, places and things]
>
>
> -Original Message-
> From: "Dave Cordes" <[EMAIL PROTECTED]>
> Date: Thu, 24 Oct 2002 11:26:35 -0500
> Subject: RE: Using CFEXECUTE from a Web Browser???
>
> > Jochem,
> > Do you have an idea how I would use this solution from the server.
> I
> > mean,
> > it works great on localhost, but I can't run this from the server
> > because
> > the printer is installed locally.
> >
> > Dave Cordes
> > Senior ColdFusion Developer
> > 636-939-1081 (H)
> > 636-578-4235 (M)
> >
> > -Original Message-
> > From: Jochem van Dieten [mailto:jochemd@;oli.tudelft.nl]
> > Sent: Thursday, October 24, 2002 10:19 AM
> > To: CF-Talk
> > Subject: Re: Using CFEXECUTE from a Web Browser???
> >
> >
> > Dave Cordes wrote:
> >
> > > Windows XP
> > > ColdFusion MX
> >
> > OK, so your process will always run for as long as the timeout
> > specified.
> >
> > > What did you mean by the "/c" parameter? Should I add that
> command
> > in
> > > order to close the command?
> >
> > Yes. But I usually make it the first option I specify:
> >  >ARGUMENTS="/c copy C:\Inetpub\wwwroot\CFDEV\barcode\zebra.txt
> LPT"
> >TIMEOUT="5">
> >
> >
> > Jochem
> >
> >
> >
>
>

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

Re: M$Access DB and ColdFusionMX for Solaris

[Troy Simpson]

Thanks Rob it this works it would be great. :-)

So the Java URL would be:

jdbc:odbc:Driver={Microsoft Access Driver(*.mdb)};DBQ=[/usr/db/db1.mdb]
or
jdbc:odbc:Driver={Microsoft Access Driver(*.mdb)};DBQ=/usr/db/db1.mdb

The second one does not have the [,].

The reason I'm asking for examples is because if it is going to work, the syntax is 
what
usually kills it.

Thanks,
Troy

Rob Rohan wrote:

> Ok, if it does work it would work like this:
>
> 1) in "Add new data source" setup in cfide choose "other" for "Driver"
> 2) for jdbc url put jdbc:odbc:Driver={Microsoft Access Driver
> (*.mdb)};DBQ=[path to access mdb]
>where [path to access mdb] is C:\blah\blah.mdb or /usr/blah/blah.mdb
> 3) Driver class = sun.jdbc.odbc.JdbcOdbcDriver
> 4) Driver namae = whatever you want
>
> If it does work, please let us know.
>
> And I don't see why it wouldn't work in Solaris, I think I have used this in
> Linux (just not with MX).
>
> Cheers,
> Rob
>
> -Original Message-
> From: Troy Simpson [mailto:Troy_Simpson@;ncsu.edu]
> Sent: Thursday, October 24, 2002 10:14 AM
> To: CF-Talk
> Subject: Re: M$Access DB and ColdFusionMX for Solaris
>
> You have any more real examples for the jdbc:... string?
> What *.jar or *.class files do I need?
> And this will work on Sun Solaris?
>
> Thanks,
> Troy
>
> Rob Rohan wrote:
>
> > Hey Troy,
> >
> > Try
> >
> > jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=[path to access
> mdb]
> >
> > using the jdbc odbc bridge. That's how I access it straight from java.
> Never
> > tried it with MX but in theory...
> >
> > Rob
> >
> > -Original Message-
> > From: Troy Simpson [mailto:Troy_Simpson@;ncsu.edu]
> > Sent: Thursday, October 24, 2002 9:44 AM
> > To: CF-Talk
> > Subject: Re: M$Access DB and ColdFusionMX for Solaris
> >
> > Yea, I could.  ;-)
> >
> > But we are trying to provide a service for people in other departments and
> > they only know
> > MS Access.  Additionally, management wants us to try and host this on the
> > Unix systems if
> > possible.
> >
> > Troy
> >
> > David Adams wrote:
> >
> > > Good question and I hope you get a lot of response but can you export
> > > the data from Access to MySQL or something that runs on UNIX and have
> > > CF talk to it instead?
> > >
> > > -Original Message-
> > > From: Troy Simpson [mailto:Troy_Simpson@;ncsu.edu]
> > > Sent: October 23, 2002 1:23 PM
> > > To: CF-Talk
> > > Subject: M$Access DB and ColdFusionMX for Solaris
> > >
> > > I'm sitting here trying to figure a way to use ColdFusionMX on Solaris8
> > > to get data out of an Microsoft Access Database.
> > > I heard a rumor that there was an ODBC driver or some other driver that
> > > would allow this to happen.
> > > Does anyone know if this is true?
> > > Can I store an Access DB File on a Solaris File system and use
> > > ColdFusionMX to select data from it which is also running on the same
> > > Solaris system?
> > > I have a feeling that the answer would be NO, but just wanted to post
> > > this to see if I am correct.
> > >
> > > I searched the CF-TALK list for this and did not find anything, but I
> > > could have used the wrong search criteria.
> > >
> > > If this is indeed not possible, I thought of another idea to accomplish
> > > this that might work.
> > > Use ColdFusionMX in distributed mode.
> > > Install ColdFusionMX and the Access DB file on a Windows2000/XP server
> > > and use ODBC to connect to Access.
> > > Configure the web server, maybe Apache2, on Sun Solaris8 with the
> > > ColdFusionMX distributed client (wsconfig.jar).
> > > I wonder if this would work like I expect it to?
> > > Anyone already done this?
> > > I can already see the benefits.
> > > I can segregate my small Access Applications from the rest.  ;-)
> > >
> > > I strongly invite any and all comments.
> > >
> > > Thanks,
> > > Troy
> > >
> > > --
> > > -
> > > Troy Simpson
> > >   Applications Analyst/Programmer, MCSE, OCPDBA
> > > North Carolina State University Libraries
> > > Campus Box 7111 | Raleigh | North Carolina
> > > ph.919.515.3855 | fax.919.513.3330
> > > E-mail: [EMAIL PROTECTED]
> > >
> > >
> >
> >
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

RE: Urgent : GURU Required: Excel vs COM in CFMX

[Dave Watts]

> It's a physical impossibility to pass xml data as 
> efficiently as passing data over a COM interface. 
> I accept that SOAP is a viable replacement for DCOM, 
> but not COM itself.

If you're defining efficiency as speed, you're absolutely correct. However,
the general acceptance of XML should indicate that people are often more
concerned with things other than speed, such as the use of (relatively
human-readable) text formats instead of requiring binary compatibility.

> Especially when with all the "industries investment in 
> Java" that is supposed to be a big reason we love Java 
> now, nobody in Javaland has come up with as efficient 
> an interface as MSXML. Just the thought of using a web 
> service to parse/and receive/send XML is laughable to me.

What part is laughable? The part about using HTTP as a transport mechanism?
There's nothing preventing the use of other transport mechanisms for SOAP
requests. Or the part about XML parsing? People seem to be doing that just
fine without MSXML, in general. And, of course, using SOAP in .NET programs
uses the MS parser, I'm sure, so again, I'm missing something here.

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/index.cfm?sidebar=lists&body=lists/cf_talk
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

RE: M$Access DB and ColdFusionMX for Solaris

[Rob Rohan]

Ok, if it does work it would work like this:

1) in "Add new data source" setup in cfide choose "other" for "Driver"
2) for jdbc url put jdbc:odbc:Driver={Microsoft Access Driver
(*.mdb)};DBQ=[path to access mdb]
   where [path to access mdb] is C:\blah\blah.mdb or /usr/blah/blah.mdb
3) Driver class = sun.jdbc.odbc.JdbcOdbcDriver
4) Driver namae = whatever you want

If it does work, please let us know.

And I don't see why it wouldn't work in Solaris, I think I have used this in
Linux (just not with MX).

Cheers,
Rob



-Original Message-
From: Troy Simpson [mailto:Troy_Simpson@;ncsu.edu]
Sent: Thursday, October 24, 2002 10:14 AM
To: CF-Talk
Subject: Re: M$Access DB and ColdFusionMX for Solaris


You have any more real examples for the jdbc:... string?
What *.jar or *.class files do I need?
And this will work on Sun Solaris?

Thanks,
Troy

Rob Rohan wrote:

> Hey Troy,
>
> Try
>
> jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=[path to access
mdb]
>
> using the jdbc odbc bridge. That's how I access it straight from java.
Never
> tried it with MX but in theory...
>
> Rob
>
> -Original Message-
> From: Troy Simpson [mailto:Troy_Simpson@;ncsu.edu]
> Sent: Thursday, October 24, 2002 9:44 AM
> To: CF-Talk
> Subject: Re: M$Access DB and ColdFusionMX for Solaris
>
> Yea, I could.  ;-)
>
> But we are trying to provide a service for people in other departments and
> they only know
> MS Access.  Additionally, management wants us to try and host this on the
> Unix systems if
> possible.
>
> Troy
>
> David Adams wrote:
>
> > Good question and I hope you get a lot of response but can you export
> > the data from Access to MySQL or something that runs on UNIX and have
> > CF talk to it instead?
> >
> > -Original Message-
> > From: Troy Simpson [mailto:Troy_Simpson@;ncsu.edu]
> > Sent: October 23, 2002 1:23 PM
> > To: CF-Talk
> > Subject: M$Access DB and ColdFusionMX for Solaris
> >
> > I'm sitting here trying to figure a way to use ColdFusionMX on Solaris8
> > to get data out of an Microsoft Access Database.
> > I heard a rumor that there was an ODBC driver or some other driver that
> > would allow this to happen.
> > Does anyone know if this is true?
> > Can I store an Access DB File on a Solaris File system and use
> > ColdFusionMX to select data from it which is also running on the same
> > Solaris system?
> > I have a feeling that the answer would be NO, but just wanted to post
> > this to see if I am correct.
> >
> > I searched the CF-TALK list for this and did not find anything, but I
> > could have used the wrong search criteria.
> >
> > If this is indeed not possible, I thought of another idea to accomplish
> > this that might work.
> > Use ColdFusionMX in distributed mode.
> > Install ColdFusionMX and the Access DB file on a Windows2000/XP server
> > and use ODBC to connect to Access.
> > Configure the web server, maybe Apache2, on Sun Solaris8 with the
> > ColdFusionMX distributed client (wsconfig.jar).
> > I wonder if this would work like I expect it to?
> > Anyone already done this?
> > I can already see the benefits.
> > I can segregate my small Access Applications from the rest.  ;-)
> >
> > I strongly invite any and all comments.
> >
> > Thanks,
> > Troy
> >
> > --
> > -
> > Troy Simpson
> >   Applications Analyst/Programmer, MCSE, OCPDBA
> > North Carolina State University Libraries
> > Campus Box 7111 | Raleigh | North Carolina
> > ph.919.515.3855 | fax.919.513.3330
> > E-mail: [EMAIL PROTECTED]
> >
> >
>
>

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

RE: Hello

[todd]

Yup, Redhat linux here.

On Thu, 24 Oct 2002, Dave Watts wrote:

> > Is the requests on topics no one wants to touch or is no one 
> > seeing my posts?
> 
> Yes, your posts are there, but I suspect that not too many people have
> upgraded CF 5 on Solaris to CFMX, so no one's answering them.
> 
> 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/index.cfm?sidebar=lists&body=lists/cf_talk
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

Re: Hello

[Jerry Johnson]

Saw your posts, but since we are still a CF 5.0 shop, had exactly zero input into your 
problems.

Welcome.

But looking through the archives, there was a response to your "Easy Question" from 
Kris Pilles, which you responded to in turn.

And just for sanity's sake, you should start each new thread as a new message, rather 
than replying and changing the subject. (Which is my habit as well). On the Archives 
it makes it more difficult to follow a thread when they are all jumbled together.

Sorry I couldn't help,

Jerry Johnson
SP


>>> [EMAIL PROTECTED] 10/24/02 11:50AM >>>
I subscribed yesterday to this list and posted two requests for help and got 0 
response.
Is the requests on topics no one wants to touch or is no one seeing my posts?

Can a few (not everyone) let me know if you see this post?
Thanks

--
Bruce Holm
Web Developer
Lattice Semiconductor
[EMAIL PROTECTED] 
--


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

RE: Using CFEXECUTE from a Web Browser???

[Dave Cordes]

Jochem,
Do you have an idea how I would use this solution from the server. I mean,
it works great on localhost, but I can't run this from the server because
the printer is installed locally.

Dave Cordes
Senior ColdFusion Developer
636-939-1081 (H)
636-578-4235 (M)

-Original Message-
From: Jochem van Dieten [mailto:jochemd@;oli.tudelft.nl]
Sent: Thursday, October 24, 2002 10:19 AM
To: CF-Talk
Subject: Re: Using CFEXECUTE from a Web Browser???


Dave Cordes wrote:

> Windows XP
> ColdFusion MX

OK, so your process will always run for as long as the timeout specified.

> What did you mean by the "/c" parameter? Should I add that command in
> order to close the command?

Yes. But I usually make it the first option I specify:

   

Jochem


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

ANNOUNCEMENT: Using CF in Human Resources - what works and what is legal? Wash DC 11/6/02

[Michael Smith]

Does your HR department want to better use technology?   For recruitment?  For
handbooks?  For training?  For managing HR functions? Worried about the
technical and legal issues? You can help them with the seminar
"Human Resources and Technology:  What Works?  What is Legal?"
More details at
http://www.teratech.com/training/hr.cfm

***
Win*Win
***
You can win FREE TeraTech training or mentoring simply by inviting your Human
Resources staff to attend this valuable seminar.   Plus, your HR professionals
win by benefiting from expert advice on how HR professionals can better use
technology legally.  They will be better prepared to communicate business needs
to you!

* * * * * * * * * * * * * * * * * * * *
To our IT friend:
Please pass this invitation along to your colleagues in the HR department.  Send
an email to [EMAIL PROTECTED], subject "HR seminar".  In the body of the message
list the name, company, email (optional) of the people you referred.  When they
sign up, you will automatically be entered in the drawing for the FREE TeraTech
training or mentoring.
* * * * * * * * * * * * * * * * * * *


* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Human Resources and Technology:  What Works?  What is Legal?
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To our new HR friend:

TECHNOLOGY CAN IMPROVE THE HUMAN RESOURCE FUNCTION - UNLESS IT IS DEPLOYED
BADLY.

Time and money can be lost if you learn too late that the technological
"solution" that you have chosen does not work with the rest of your programs.
Lawsuits can result when you fail to understand the legal implications of the
systems you have chosen.

The highly regarded specialists in Employment Law, Shawe & Rosenthal, LLP, are
our partners in this seminar.

Attendees will receive invaluable guidance on viable technology solutions that
work and that are legal.  Learn how other HR departments are using web and
database technology.

We will be talking about great ways for HR folks to use technology --
-- Web-based recruiting
-- Managing and tracking applicant flow
-- "Qualifications screening" software
-- "Virtual" Handbooks and policies
-- E-handbook acknowledgment
-- Internet/Intranet-based training
-- "Tracking" mechanisms for attendance, training and the like
-- Security considerations

Register today

When: Wednesday, November 6, 8:30 a.m. to 1:00 p.m.

Where: Holiday Inn Select in Bethesda, Maryland

Cost: $75 includes course materials and lunch

Questions?: Call Doris at 301-881-1440 x101 or email [EMAIL PROTECTED]

More details and
Register online : http://www.teratech.com/training/hr.cfm

--
TeraTech voted top ColdFusion consulting company in the CFDJ awards


Michael Smith, TeraTech Inc
CF , VB, SQL, Math programming
12221 Parklawn Dr Ste 200, Rockville MD 20852-1711 USA
Voice: +1-301-881-1440 x110, 800-447-9120  Fax:301-881-3586
Web: http://www.teratech.com/sig/
Email:  mailto:michael@;teratech.com ICQ: 66057682


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

Re: Cookie information apprearing at the top of a page

[David Hannum]

Looks to me like you have IIS running with "URLScan" installed.  There is a
tweek to the URLScan config file that you need to make to remove that:
(Doug White [EMAIL PROTECTED] on this list sent me the info)

Here are some helpful links.

http://samcfug.org
http://www.strictlyhodaka.com
http://www.justnextdoor.us

www.clickdoug.com/clients.htm

Dave


- Original Message -
From: "Stephen Rojas" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, October 24, 2002 10:26 AM
Subject: Cookie information apprearing at the top of a page


Hey all,
I think I have seen reference to this problem before on the list but I
could not find it in the archives. Basically what is happening is that
when I go any CF page running on my production server that sets any
cookies the information for the cookie is displayed at the top of the
page in the following format:

Content-type: text/html Page-Completion-Status: Normal
Page-Completion-Status: Normal Set-Cookie: CFID=192333; expires=Sun,
27-Sep-2037 00:00:00 GMT; path=/; Set-Cookie: CFTOKEN=70022833;
expires=Sun, 27-Sep-2037 00:00:00 GMT; path=/;

A quick search on google shows that this is a common issue, however, I
haven't been able to find a resolution. Any ideas or suggestions?

TIA
Stephen


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

RE: Urgent : GURU Required: Excel vs COM in CFMX

[Mark A. Kruger - CFG]

Jon,

Actually - don't discount it out of hand. We recently did a simple reporting
form in Excel that passes a username/password and a number of search
parameters to a web service.  The resulting object populated the report -
which included some charts and calculations.  It was pretty slick data
presentation stuff.  The old way to do it would have been COM on the server
side - but this approach is more platform agnostic and easier to program.
Don't mis-understand me. COM is going to be around as long as folks are
still using old versions of Office (and for a lot of other reasons). But for
projects going forward, this approach CAN work very well.

-mk



-Original Message-
From: jon hall [mailto:jonhall@;ozline.net]
Sent: Thursday, October 24, 2002 11:06 AM
To: CF-Talk
Subject: Re: Urgent : GURU Required: Excel vs COM in CFMX


Web Services != replacement for COM.

Not by a long shot.
--
 jon
 mailto:jonhall@;ozline.net

Thursday, October 24, 2002, 12:01:49 PM, you wrote:
>> I don't think we'll agree that COM is dead until there is
>> a viable replacement.

DW> Maybe not, but I don't think Microsoft cares too much about our
opinions,
DW> and since it's their toybox, there isn't much we can do about it.

DW> And, of course, there are several viable replacements. Perhaps those
DW> replacements don't fill the niches you're interested in right now
(Office
DW> automation, for example), but it's safe to assume that they will, over
time.
DW> Newer versions of Office will support these replacements - web services,
for
DW> example.


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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

RE: Using CFEXECUTE from a Web Browser???

[Dave Cordes]

Andy,
Could you give me an example of how you used ZPL to send to a local client
printer?

Dave Cordes
Senior ColdFusion Developer
636-939-1081 (H)
636-578-4235 (M)

-Original Message-
From: Andy Clary [mailto:aclary@;teleplanwireless.com]
Sent: Thursday, October 24, 2002 10:26 AM
To: CF-Talk
Subject: RE: Using CFEXECUTE from a Web Browser???


We too, have to print barcodes on zebra printers.

For simple barcodes, we ended up using a barcode font, used CF to display a
dynamic page to the browser and used Meadco's ScriptX object to control
printing functions.  You can find the ScriptX object at
http://www.meadroid.com/scriptx

For one project, we had to print a 2D barcode and we thought using a zpl
file (native language for zebra printers) was the best way.  The developer
who wrote it actually used FoxPro (because that is the database we are
using) to receive some parameters, run a query and then create a zpl file
which could then be sent to the printer.  It actually works well.

Andy

-Original Message-
From: Dave Cordes [mailto:davecordes@;charter.net]
Sent: Thursday, October 24, 2002 7:36 AM
To: CF-Talk
Subject: RE: Using CFEXECUTE from a Web Browser???


Dave,
Actually we're trying to use it to print barcodes to a Zebra LP2844 thermal
printer. And we're trying to do it from IE.

If you open a command prompt and type "copy C:\zebra.txt LPT1" and have
valid EPL2 code in that text file it should print a barcode.

That's how we're trying to use it.

Dave Cordes
Senior ColdFusion Developer
636-939-1081 (H)
636-578-4235 (M)

-Original Message-
From: Dave Wilson [mailto:dave@;autosdirect2u.com]
Sent: Thursday, October 24, 2002 5:59 AM
To: CF-Talk
Subject: RE: Using CFEXECUTE from a Web Browser???


Couple of points and questions on this.

Firstly, have you tried using CFX_ShellExec tag? I've been using this since
cf4.01 due to various shortcomings of cfexecute's implementation over the
years.

Secondly. Do you need any particular type of printer to support this direct
printing method? I just tried the copy file LPT1 command on a machine here
with a little epson inkjet printer. The printer busy lights begin to flash
but nothing actually gets printed. Do you need a good networkable laser
printer which can support direct file dumps? I want to use this technique in
our systems for invoicing and much more.

Thanks,
Dave

-Original Message-
From: Jochem van Dieten [mailto:jochemd@;oli.tudelft.nl]
Sent: 24 October 2002 09:05
To: CF-Talk
Subject: Re: Using CFEXECUTE from a Web Browser???


Dave Cordes wrote:

> I checked and ColdFusion is logged in as the "Local System Account" so
> I don't think it could be a permissions problem.

I'm not so sure about that.

> I found some other posts on the ColdFusion Support Forums that would
> lead me to believe that your second point about timing out is the
> cause. Here is the link that talks about it.

2 issues:

CF MX always waits for the entire period specified in the timeout
instead of the shortest of the timeout and the process finishing (but
you still haven't told us which version/OS/servicepack you use).

Every version of CF will wait forever on your specific code because if
you call cmd.exe you need the /c parameter.


> I read somewhere that Macromedia has no current plans to fix it so
> that's not a good sign.

http://www.macromedia.com/support/email/wishform/?6213=3

Jochem





~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
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