Setting up a shared hosting environment?

2002-11-27 Thread news
Hi
This is a request for a how-to guide or hints and tips for setting up a
ColdFusion MX shared hosting environment on Windows and/or Unix.

I administer www.Coldfusionhosts.net, a search engine for CF hosting
companies. The site also has articles on CF related matters and welcomes
press releases and technical info from interested parties.

One of the hosts listed on www.Javahosts.net, a sister site, recently wrote
an article on setting up Tomcat for shared hosting, and it's been very well
received. Of course the host that wrote gained some free publicity and kudos
for publishing the article.

Any publishable material would be gratefully received either via this list,
or privately to [EMAIL PROTECTED]

Many thanks,

James, ColdFusionhosts.

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



RE: Processing .htm files as .cfm

2002-11-27 Thread Paul Wilson
That did the trick! Thanks.

-Original Message-
From: Christine Lawson [mailto:[EMAIL PROTECTED]]
Sent: 26 November 2002 19:27
To: CF-Talk
Subject: RE: Processing .htm files as .cfm


Take a look at this technote and change .dbm to .htm: 
http://www.macromedia.com/v1/Handlers/index.cfm?ID=23258&Method=Full

Regards,
Christine Lawson
Macromedia

-Original Message-
From: David Notik [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 26, 2002 2:19 PM
To: CF-Talk
Subject: RE: Processing .htm files as .cfm


That's actually a great question.

I've never tested it with CFMX, which is radically different in how it
processes everything (uses JRun, etc...).

I just now tried it, and IE just endlessly tries to open the file, which
leads me to believe that JRun.dll doesn't want to parse it.

Oh well.

--D

-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, November 26, 2002 10:58 AM
To: CF-Talk
Subject: RE: Processing .htm files as .cfm

is this cf5 or cfmx?

tony

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


-Original Message-
From: chris regan [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, November 26, 2002 1:16 PM
To: CF-Talk
Subject: RE: Processing .htm files as .cfm


You have to change the IIS settings.
Under the Home Directory tab:
Click on Configuration.
Then find the cfm extension and copy the Executable Path.
Then change the htm path to read the same.  
Fred

-Original Message-
From: Paul Wilson [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, November 26, 2002 1:05 PM
To: CF-Talk
Subject: Processing .htm files as .cfm

Which file do i need to change to process .htm files as .cfm?

Thanks






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



Re: datasource problem with mx

2002-11-27 Thread Jochem van Dieten
Matthew P. Smith wrote:

> I am getting this error first time I hit a cfquery:

*Only* the first time?

> Error Occurred While Processing Request
>
> Data source foo could not be found.
>
>
> Thing is, it verifies fine in cfadministrator.

Typo in the datasource name is the most common problem. You might want 
to verify using the code below:

   
 factory = CreateObject("java", "coldfusion.server.ServiceFactory");
 ds_service = factory.datasourceservice;

 dsources = ds_service.datasources;
   

   
   


Jochem

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm



RE: activePDF

2002-11-27 Thread webguy
One thing that annoys me about ActivePDF is the lack of a developer version.
We have 2 full versions, installed on our cluster, but to test it I have to
install the 30 day version. Why can't they give u a single IP or something?
Also the error messages are a little crap -99 for everything. I'd advise you
to turn on the logging when developing

We use it mostly form PDF form filling from the DB, and document conversion
to PDF. The only issue we have is the odd doc seems to cause a problem.


WG

> -Original Message-
> From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
> Sent: 27 November 2002 03:30
> To: CF-Talk
> Subject: Re: activePDF
>
>
>   I have only used the ActivePDF toolkit.
>   It is really really really easy to get up and running.
>   It uses COM.  My experience with ActivePDF is that it has no problems
> with CFMX.  As near as I can tell, that makes me the only living
> person in
> existence who has been able to successfully use a COM object w/ CFMX.
>
>   I'm not sure about competitors, but I do know that there are other ways
> to generate PDFs on the fly.
>
> At 10:00 PM 11/26/2002 -0500, you wrote:
> >hi list.
> >
> >whats the pro's / con's of activePDF?
> >
> >competitors?
> >
> >thanks!
> >
> >...tony
> >
> >tony weeg
> >[EMAIL PROTECTED]
> >www.revolutionwebdesign.com
> >rEvOlUtIoN wEb DeSiGn
> >410.334.6331
> >
> >
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



RE: datasource problem with mx

2002-11-27 Thread John Beynon
I've hand this before. It verified in the admin but then when trying to
CFQUERY against the db it errored.

I think in the end I deleted the datasource, created it in the Windows ODBC
control panel and then created the same entry in CFADMIN, that worked for
me,

Jb.

-Original Message-
From: Matthew P. Smith [mailto:[EMAIL PROTECTED]] 
Sent: 27 November 2002 05:39
To: CF-Talk
Subject: datasource problem with mx

I am getting this error first time I hit a cfquery:
 

Error Occurred While Processing Request 



Data source foo could not be found. 

 
Thing is, it verifies fine in cfadministrator.
 
I have installed the latest cf server update, and restarted the box
several times.



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



Sybase ASE

2002-11-27 Thread Robert Shaw
I have an app that I am trying to setup and the dB is a Sybase 12 .dat file. 
This may be a silly question but do I need to have Sybase ASE server loaded 
on the machine to connect to this? I've never worked with connecting to 
Sybase before so any help is appreciated.

TIA,
Rob






~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



RE: security question

2002-11-27 Thread webguy
Email addresses are usually gathered using a "spider"
http://www.whatis.com/definition/0,,sid9_gci213035,00.html , which grabs
pages and takes out the email addresses on it.

Sometimes people use something like

joe  online.com

or

[EMAIL PROTECTED]

etc...

to prevent this.

WG
> -Original Message-
> From: michael firth [mailto:[EMAIL PROTECTED]]
> Sent: 27 November 2002 00:43
> To: CF-Talk
> Subject: security question
>
>
> Hey gang out there in CF land,
>
> Got a question for a security application I am doing up, plus
> also cure my curiousity.  You see the security app I am building
> I would like to include some sort of safeguard that allows or
> prevents people from collecting emails, but in order to do that I
> need to know how they do that process.
>
> I thought about it and would think that access the Registry but
> am not totally sure.  If anybody has any thoughts to share just
> let me know.
>
> Mike Firth
>
>
>
>
>
> -
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com



RE: security question

2002-11-27 Thread John Beynon
A really neat way to solve it is to use the EmailAntiSpam (cflib.org) UDF,
it converts an email address to Unicode which the email harvesters don't
retrieve, it's as easy as:

#EmailAntiSpam("[EMAIL PROTECTED]", "Yes")#

jb.

-Original Message-
From: webguy [mailto:[EMAIL PROTECTED]] 
Sent: 27 November 2002 11:32
To: CF-Talk
Subject: RE: security question

Email addresses are usually gathered using a "spider"
http://www.whatis.com/definition/0,,sid9_gci213035,00.html , which grabs
pages and takes out the email addresses on it.

Sometimes people use something like

joe  online.com

or

[EMAIL PROTECTED]

etc...

to prevent this.

WG
> -Original Message-
> From: michael firth [mailto:[EMAIL PROTECTED]]
> Sent: 27 November 2002 00:43
> To: CF-Talk
> Subject: security question
>
>
> Hey gang out there in CF land,
>
> Got a question for a security application I am doing up, plus
> also cure my curiousity.  You see the security app I am building
> I would like to include some sort of safeguard that allows or
> prevents people from collecting emails, but in order to do that I
> need to know how they do that process.
>
> I thought about it and would think that access the Registry but
> am not totally sure.  If anybody has any thoughts to share just
> let me know.
>
> Mike Firth
>
>
>
>
>
> -
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now
> 

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



Re: Setting up a shared hosting environment?

2002-11-27 Thread Jochem van Dieten
[EMAIL PROTECTED] wrote:

> This is a request for a how-to guide or hints and tips for setting up 
> a ColdFusion MX shared hosting environment on Windows and/or Unix.

First, subscribe to the Macromedia security announcements service :-) 
Then, set it up like you would set up hosting without CF MX, then 
install CF MX and secure it like you normally would. Then:
- disable the running of .jsp pages
- disable RDS
- switch on Sandbox Security
   - disable cfschedule, cfobject, cfregistry, cfexecute and createobject
   - set the sandbox filesystem permissions (same as for the FTP access)
   - set permissions on datasources
- write a disk image to a WORM-mediun and put it in the safe

Not much of a tutorial, but it has everything I can think of at the 
moment and then some more. Proper procedures for the different steps are 
in the manual or knowledgebase, the Sandbox Security thing is easily 
scriptable through the java.ColdFusion.Factory if you need to set up 
many accounts.
The only tricky thing is that "secure it like you normally would" 
implies switching it to run under a not-default OS user account, which 
can have quite some implications depending on how your FTP, webserver 
and other scripting languages are set. But that is a matter of 
understanding your OS, not CF MX.

Additionally, you might want to look into providing/running tools that 
allow a client to have a look at the error log for his site (moving it 
to a database and querying it is probably the easiest way), set up 
scheduled tasks (they are not a security risk in themselves, but giving 
clients direct access to cfschedule would allow them to manipulate 
eachothers tasks) and similar small maintenance stuff (purge client 
vars, requeue undelivered mail etc.).

Jochem

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



Code messing up cferror

2002-11-27 Thread Robert Everland
I make use of cferror in my application.cfm to catch everthing that goes
wrong with my app. If there is something wrong, it emails where it happened
along with all of the variables I need. The problem is in our shopping cart
this chunk of code is making cferror break. I don't know why, can anyone
shed any light on it. Once I take this piece of code out cferror catches the
errors, put it back in, it throws the error to the user. This is on CF5.










" & "*** Error getting your
order. ***">






Robert Everland III
Web Developer Extraordinaire
Dixon Ticonderoga Company
http://www.dixonusa.com 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



RE: Code messing up cferror

2002-11-27 Thread Robertson-Ravo, Neil (RX)
erm at a guess...

>From what I can see you have created a variable named pencilorder which is
assigned to a client variable.  You are also redefining this variable as a
normal CF array before it is WDDX'ed.

Neil





-Original Message-
From: Robert Everland [mailto:[EMAIL PROTECTED]]
Sent: 27 November 2002 13:46
To: CF-Talk
Subject: Code messing up cferror


I make use of cferror in my application.cfm to catch everthing that goes
wrong with my app. If there is something wrong, it emails where it happened
along with all of the variables I need. The problem is in our shopping cart
this chunk of code is making cferror break. I don't know why, can anyone
shed any light on it. Once I take this piece of code out cferror catches the
errors, put it back in, it throws the error to the user. This is on CF5.










" & "*** Error getting your
order. ***">






Robert Everland III
Web Developer Extraordinaire
Dixon Ticonderoga Company
http://www.dixonusa.com 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



RE: activePDF

2002-11-27 Thread David Adams
Have you tried HTMLDOC by Easysoftware.  I am really satisfied with it.

Dave Adams
CFUG Ottawa

-Original Message-
From: webguy [mailto:[EMAIL PROTECTED]] 
Sent: November 27, 2002 6:18 AM
To: CF-Talk
Subject: RE: activePDF

One thing that annoys me about ActivePDF is the lack of a developer
version.
We have 2 full versions, installed on our cluster, but to test it I have
to
install the 30 day version. Why can't they give u a single IP or
something?
Also the error messages are a little crap -99 for everything. I'd advise
you
to turn on the logging when developing

We use it mostly form PDF form filling from the DB, and document
conversion
to PDF. The only issue we have is the odd doc seems to cause a problem.


WG

> -Original Message-
> From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
> Sent: 27 November 2002 03:30
> To: CF-Talk
> Subject: Re: activePDF
>
>
>   I have only used the ActivePDF toolkit.
>   It is really really really easy to get up and running.
>   It uses COM.  My experience with ActivePDF is that it has no
problems
> with CFMX.  As near as I can tell, that makes me the only living
> person in
> existence who has been able to successfully use a COM object w/ CFMX.
>
>   I'm not sure about competitors, but I do know that there are other
ways
> to generate PDFs on the fly.
>
> At 10:00 PM 11/26/2002 -0500, you wrote:
> >hi list.
> >
> >whats the pro's / con's of activePDF?
> >
> >competitors?
> >
> >thanks!
> >
> >...tony
> >
> >tony weeg
> >[EMAIL PROTECTED]
> >www.revolutionwebdesign.com
> >rEvOlUtIoN wEb DeSiGn
> >410.334.6331
> >
> >
> 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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: Server Problems When Code is Not Locked (was RE: Application vari ables)

2002-11-27 Thread Haggerty, Mike
Mike;

No server packs were installed. The server was built about 3 years ago and
not touched (I just 'inherited' this server from a contractor who no longer
works with the agency).

The next step in my plan is to install the server pack and see if that
improves the situtation.

Thanks for the response!

M

-Original Message-
From: Mike Brunt [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 26, 2002 6:07 PM
To: CF-Talk
Subject: RE: Server Problems When Code is Not Locked (was RE:
Application vari ables)


Mike what service pack are you on with CF4.5, the reason I ask is that
Service Pack 2 was significantly better.

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

Web Application Specialists

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



RE: Code messing up cferror

2002-11-27 Thread Robert Everland
Yeah I do this because I made an array of structures in a wddx packet. Even
if I take out the variable that makes an array it messes up.

Robert Everland III
Web Developer Extraordinaire
Dixon Ticonderoga Company
http://www.dixonusa.com 

-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, November 27, 2002 9:05 AM
To: CF-Talk
Subject: RE: Code messing up cferror


erm at a guess...

>From what I can see you have created a variable named pencilorder which is
assigned to a client variable.  You are also redefining this variable as a
normal CF array before it is WDDX'ed.

Neil





-Original Message-
From: Robert Everland [mailto:[EMAIL PROTECTED]]
Sent: 27 November 2002 13:46
To: CF-Talk
Subject: Code messing up cferror


I make use of cferror in my application.cfm to catch everthing that goes
wrong with my app. If there is something wrong, it emails where it happened
along with all of the variables I need. The problem is in our shopping cart
this chunk of code is making cferror break. I don't know why, can anyone
shed any light on it. Once I take this piece of code out cferror catches the
errors, put it back in, it throws the error to the user. This is on CF5.










" & "*** Error getting your
order. ***">






Robert Everland III
Web Developer Extraordinaire
Dixon Ticonderoga Company
http://www.dixonusa.com 


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



OT: T-SQL

2002-11-27 Thread Luce, Greg
I'm trying to learn to run T-SQL scripts in Query Analyzer like I can with
Oracle in SQL Plus. In the Books Online I found a nice example of a cursor
loop running a report against the pubs db. I paste this script into Query
Analyzer and hit go and get 5 different errors. Here's the script, you can
find it in books online with keyword "cursors, Transact-SQL": 
SET NOCOUNT ON 

DECLARE @au_id varchar(11), @au_fname varchar(20), @au_lname varchar(40), 
@message varchar(80), @title varchar(80) 

PRINT " Utah Authors report " 

DECLARE authors_cursor CURSOR FOR 
SELECT au_id, au_fname, au_lname 
FROM authors 
WHERE state = "UT" 
ORDER BY au_id 

OPEN authors_cursor 

FETCH NEXT FROM authors_cursor 
INTO @au_id, @au_fname, @au_lname 

WHILE @@FETCH_STATUS = 0 
BEGIN 
PRINT " " 
SELECT @message = "- Books by Author: " + 
@au_fname + " " + @au_lname 

PRINT @message 

-- Declare an inner cursor based 
-- on au_id from the outer cursor. 

DECLARE titles_cursor CURSOR FOR 
SELECT t.title 
FROM titleauthor ta, titles t 
WHERE ta.title_id = t.title_id AND 
ta.au_id = @au_id -- Variable value from the outer cursor 

OPEN titles_cursor 
FETCH NEXT FROM titles_cursor INTO @title 

IF @@FETCH_STATUS <> 0 
PRINT " <>" 

WHILE @@FETCH_STATUS = 0 
BEGIN 

SELECT @message = " " + @title 
PRINT @message 
FETCH NEXT FROM titles_cursor INTO @title 

END 

CLOSE titles_cursor 
DEALLOCATE titles_cursor 

-- Get the next author. 
FETCH NEXT FROM authors_cursor 
INTO @au_id, @au_fname, @au_lname 
END 

CLOSE authors_cursor 
DEALLOCATE authors_cursor 
GO 
Why is it not possible to run this in Query Analyzer against the pubs db? 
***Sterling Financial Investment Group, Inc. (SFIG) is a member of
NASD/MSRB/NFA/SIPC.  Email transmissions may be monitored.  SFIG cannot
accept orders to buy or sell via email.  Please visit www.mysterling.com for
more information.***
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm



RE: T-SQL

2002-11-27 Thread webguy
Change all the double-quotes to single quotes..

Silly books on line 

WG

> -Original Message-
> From: Luce, Greg [mailto:[EMAIL PROTECTED]]
> Sent: 27 November 2002 14:39
> To: CF-Talk
> Subject: OT: T-SQL
>
>
> I'm trying to learn to run T-SQL scripts in Query Analyzer like I can with
> Oracle in SQL Plus. In the Books Online I found a nice example of a cursor
> loop running a report against the pubs db. I paste this script into Query
> Analyzer and hit go and get 5 different errors. Here's the script, you can
> find it in books online with keyword "cursors, Transact-SQL":
http://www.fusionauthority.com/ads.cfm

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



Reloading VTMs without restarting studio

2002-11-27 Thread mynews
I remember a CFDJ article, I think it was by Ben Forta, about 
creating wizards in Studio and he told how to reload the wizards 
without restarting Studio. Does anyone know how to do this? I 
can't find the article.

Thanks.
David Murphy
www.cfugcny.org

___
Sent by ePrompter, the premier email notification software.
Free download at http://www.ePrompter.com.

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm



RE: CF4.5 C++ Runtime Library error

2002-11-27 Thread Dave Watts
> The "Pure Virtual Function Call" error is a standard 
> C++ issue. Something has attempted to call a method 
> on a class for which no implementation exists. My 
> first suspicion would be a C++ CFX tag...

I've seen that error many times in the past, with older versions of CF,
typically under load, with no CFXs or anything else beyond a default CF
install. Most often, I saw them when teaching the old Allaire "ColdFusion
Performance Tuning" class, during the load-testing sections.

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

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



RE: T-SQL

2002-11-27 Thread Luce, Greg
Gracias! That was the lynch-pin. Then I found the problem with my script. I
had "DECLARE co_cursor FOR..." instead of "DECLARE co_cursor CURSOR FOR..."

-Original Message-
From: webguy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 27, 2002 9:53 AM
To: CF-Talk
Subject: RE: T-SQL


Change all the double-quotes to single quotes..

Silly books on line 

WG

> -Original Message-
> From: Luce, Greg [mailto:[EMAIL PROTECTED]]
> Sent: 27 November 2002 14:39
> To: CF-Talk
> Subject: OT: T-SQL
>
>
> I'm trying to learn to run T-SQL scripts in Query Analyzer like I can with
> Oracle in SQL Plus. In the Books Online I found a nice example of a cursor
> loop running a report against the pubs db. I paste this script into Query
> Analyzer and hit go and get 5 different errors. Here's the script, you can
> find it in books online with keyword "cursors, Transact-SQL":
http://www.fusionauthority.com/ads.cfm


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



RE: CFMX Server -Java class

2002-11-27 Thread Dave Watts
> > If this is true, what does a high-traffic, clustered 
> > production system do when they need to change a Java 
> > program (say to fix a bug, or a security exposure).
> 
> They drop and restart each server in the cluster. Normally 
> production systems do not use 'hot deploy' because of the 
> performance overhead involved in 'watching' a hot deploy 
> directory.

I'm pretty sure that you'd have to do something similar if you're using
MTS-managed COM objects, which in the days of "classic" ASP was the
MS-approved architecture for n-tier ASP apps.

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

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm



RE: Reloading VTMs without restarting studio

2002-11-27 Thread Raymond Camden
I believe it is ctrl-shift-alt-c.

===
Raymond Camden, ColdFusion Jedi Master for Hire

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

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

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
> Sent: Wednesday, November 27, 2002 8:58 AM
> To: CF-Talk
> Subject: Reloading VTMs without restarting studio
> 
> 
> I remember a CFDJ article, I think it was by Ben Forta, about 
> creating wizards in Studio and he told how to reload the wizards 
> without restarting Studio. Does anyone know how to do this? I 
> can't find the article.
> 
> Thanks.
> David Murphy
> www.cfugcny.org
> 


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



RE: GoogleBot Robot.txt

2002-11-27 Thread Joel Blanchette
Rick,
I can help you out with this.  I would need to know more info
about your situation.  Email me off list at [EMAIL PROTECTED] and I
will be able to help u out.

 
 
==
Joel Blanchette
IT and System Specialist
Point of Impact Technologies Inc.
Tel: (204) 989-0013
Email: [EMAIL PROTECTED]
==


-Original Message-
From: cfhelp [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, November 26, 2002 7:15 PM
To: CF-Talk
Subject: GoogleBot Robot.txt


I have put a robots.txt file in the root of my site to stop it from
accessing subdirectories. But GoogleBot is still accessing all the files
in my root bit some of the files do not run without passing a variable
to them. So my Application Logfile is full of errors.

So I want to know if it is a good idea to put this in my Application.cfm
file?

http://www.googlebot.com/bot.html)'>


 
Site Title



  


Text from the About page







This way Google gets to spider all pages and I don't get any errors.

Rick

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm



SQL Question

2002-11-27 Thread Matthew Friedman
I have a quick SQL question:

I need to keep a running count of the time a specific location is requested
and I could do it with 2 queries ie.


select hits
from sitecount
where id = #idpassed#





update sitecount
set hits = #new_hit#
where id = #idpassed#



But I was wondering if you could do it in a single statment since it is an
incremental variable.

Thanks

Matt


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



RE: Reloading VTMs without restarting studio

2002-11-27 Thread webguy
Don't know the answer but you should get the answer here 

http://www.wilk4.com/asp4hs/links.htm


WG

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 27 November 2002 14:58
> To: CF-Talk
> Subject: Reloading VTMs without restarting studio
> 
> 
> I remember a CFDJ article, I think it was by Ben Forta, about 
> creating wizards in Studio and he told how to reload the wizards 
> without restarting Studio. Does anyone know how to do this? I 
> can't find the article.
> 
> Thanks.
> David Murphy
> www.cfugcny.org

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm



Re: SQL Question

2002-11-27 Thread Paul Giesenhagen

UPDATE sitecount
SET hits = hits + 1
WHERE id = #idpassed#



Hope this helps!
Paul Giesenhagen
QuillDesign
- Original Message -
From: "Matthew Friedman" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, November 27, 2002 9:18 AM
Subject: SQL Question


> I have a quick SQL question:
>
> I need to keep a running count of the time a specific location is
requested
> and I could do it with 2 queries ie.
>
> 
> select hits
> from sitecount
> where id = #idpassed#
> 
>
> 
>
> 
> update sitecount
> set hits = #new_hit#
> where id = #idpassed#
> 
>
>
> But I was wondering if you could do it in a single statment since it is an
> incremental variable.
>
> Thanks
>
> Matt
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



RE: Reloading VTMs without restarting studio

2002-11-27 Thread Debbie Dickerson
Yep, that should be correct.
http://www.macromedia.com/v1/Handlers/index.cfm?ID=20621&Method=Full


-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 27, 2002 10:05 AM
To: CF-Talk
Subject: RE: Reloading VTMs without restarting studio


I believe it is ctrl-shift-alt-c.

===
Raymond Camden, ColdFusion Jedi Master for Hire

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

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

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
> Sent: Wednesday, November 27, 2002 8:58 AM
> To: CF-Talk
> Subject: Reloading VTMs without restarting studio
> 
> 
> I remember a CFDJ article, I think it was by Ben Forta, about 
> creating wizards in Studio and he told how to reload the wizards 
> without restarting Studio. Does anyone know how to do this? I 
> can't find the article.
> 
> Thanks.
> David Murphy
> www.cfugcny.org
> 



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm



RE: SQL Question

2002-11-27 Thread webguy
Update sitecount
Set hits = hits + 1
Where id = xyz

WG

> -Original Message-
> From: Matthew Friedman [mailto:[EMAIL PROTECTED]]
> Sent: 27 November 2002 15:19
> To: CF-Talk
> Subject: SQL Question
>
>
> I have a quick SQL question:
>
> I need to keep a running count of the time a specific location is
> requested
> and I could do it with 2 queries ie.
>
> 
> select hits
> from sitecount
> where id = #idpassed#
> 
>
> 
>
> 
> update sitecount
> set hits = #new_hit#
> where id = #idpassed#
> 
>
>
> But I was wondering if you could do it in a single statment since it is an
> incremental variable.
>
> Thanks
>
> Matt
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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: CF4.5 C++ Runtime Library error

2002-11-27 Thread Haggerty, Mike
Hey Dave;

Thanks for the response!

This brings me to want to ask some performance tuning questions, but I feel
like I should get the service pack installed first and then come back with
some more specific ones. 

One thing I am curious about is the affect of application variables on
memory usage on the server. I can load applications and watch the mem usage
counter for cfserver.exe climb in the task manager.

Is there a 'ceiling' to memory usage on NT boxes for CF, or maybe just an
optimal range? Does anyone have any detailed knowledge about what this
figure should be? I suppose the optimal figure would be dependent on
processor speed and concurrently running applications, but I would really
like to know what admins think about when monitoring this number.

I've never really thought about it too much before now, but it may be part
of the problems I am running into.

M

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 27, 2002 10:06 AM
To: CF-Talk
Subject: RE: CF4.5 C++ Runtime Library error


> The "Pure Virtual Function Call" error is a standard 
> C++ issue. Something has attempted to call a method 
> on a class for which no implementation exists. My 
> first suspicion would be a C++ CFX tag...

I've seen that error many times in the past, with older versions of CF,
typically under load, with no CFXs or anything else beyond a default CF
install. Most often, I saw them when teaching the old Allaire "ColdFusion
Performance Tuning" class, during the load-testing sections.

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

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



RE: Pure Virtual Function Call

2002-11-27 Thread Debbie Dickerson
Jochem's correct. If you turn off the option for the CF service to interact with the 
desktop, it should take care of it. Either SP1 or SP2 changed the default for that 
setting, specifically to resolve that issue.

Deb

-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 26, 2002 6:45 PM
To: CF-Talk
Subject: Re: Pure Virtual Function Call


Haggerty, Mike wrote:

> First off, this is a SERVICE causing this to happen. I thought 
> services were not supposed to throw alerts up on the screen, but 
> instead dump their messages into a log file (especially error 
> messages). Am I wrong?

Depends on the "interact with desktop" setting in the services window.

Jochem


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm



silly rereplace

2002-11-27 Thread Smith, Matthew P -CONT(DYN)

 
this is not stripping out spaces like I want it too...?
 
 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



RE: silly rereplace

2002-11-27 Thread Tony Weeg


why not just do this?

..tony

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


-Original Message-
From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]]

Sent: Wednesday, November 27, 2002 10:28 AM
To: CF-Talk
Subject: silly rereplace



 
this is not stripping out spaces like I want it too...?
 
 


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



Re: Sybase ASE

2002-11-27 Thread Dick Applebaum
Rob

My only experience with Sybase_ASE is on Mac OS X with CFMX but it 
should apply to other systems too.

Yes, you need to have Sybase_ASE, installed and running.

You need to have the particular database running.

In my configuration, can use the admin to setup the datasource:

1)  using Sybase as the driver

2)  using Other as the driver, referencing a copy of the 
macromedia_drivers.jar
placed in /Library/Java/Extensions

here's this datasource definition for one of the Sybase sample 
databases, pubs2, as installed.

URL:  jdbc:macromedia:sybase://TiBook:11222;DatabaseName=pubs2;
Driver: macromedia.jdbc.sybase.SybaseDriver
Name: SybaseJDBC
Userid: sa
Password: (blank)
Comment:  Sybase Interface using Sybase JDBC Driver from CFMX

Note: I prefer to define all my datasources  with the long form of the 
datasource definition
and use a common JDBC driver (step 2, above).  This allows 
me to use the same
information when defining the  datasource to a non-CF 
program such as a GUI SQL
client such as ViennaSQL.

Sybase has a free trial version that you can  download.

If you follow the install instructions, you should be able to access 
the pubs2 database from CFMX.

HTH

Dick



On Wednesday, November 27, 2002, at 03:21 AM, Robert Shaw wrote:

> I have an app that I am trying to setup and the dB is a Sybase 12 .dat 
> file.
> This may be a silly question but do I need to have Sybase ASE server 
> loaded
> on the machine to connect to this? I've never worked with connecting to
> Sybase before so any help is appreciated.
>
> TIA,
> Rob

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



RE: silly rereplace

2002-11-27 Thread Smith, Matthew P -CONT(DYN)
Yep, works great.  Thanks for the help.

Any reason why the original doesn't work?  It seems like it should, or am I
misunderstanding the [[:Space:]] ?


>>-Original Message-
>>From: Tony Weeg [mailto:[EMAIL PROTECTED]]
>>Sent: Wednesday, November 27, 2002 9:50 AM
>>To: CF-Talk
>>Subject: RE: silly rereplace
>>
>>
>>
>>why not just do this?
>>
>>..tony
>>
>>Tony Weeg
>>Senior Web Developer
>>Information System Design
>>Navtrak, Inc.
>>Fleet Management Solutions
>>www.navtrak.net
>>410.548.2337
>>
>>
>>-Original Message-
>>From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]]
>>
>>Sent: Wednesday, November 27, 2002 10:28 AM
>>To: CF-Talk
>>Subject: silly rereplace
>>
>>
>>
>>
>>this is not stripping out spaces like I want it too...?
>>
>>
>>
>>
>>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



CFMail Problems

2002-11-27 Thread Hatton Humphrey
I'm having an interesting problem with an application.  I searched the 
archives and found issues with 0 byte emails and spool questions about 
CF Mail, but nothing that matches this.

Why would CFMail put a perfectly good email in the Undeliverable folder? 
 I have an app that generates a steady flow of emails all day long and 
they typically get delivered.  However there are some cases where an 
email will get batched in the undeliverable folder.  I don't have access 
to the server logs as of yet but it's rather disconcerting.

On the same issue, my mind's already working on a work-around for the 
issue.  I'm thinking it might come in the form of a batch file that 
automatically copies any files in the undeliver directory that meet a 
specific criteria back into the spool directory.  My thought was to base 
it on the date/time stamp of the file, however I'm wondering if CF 
changes the date/time stamp when it moves a message into undeliver.

Thanks!
C. Hatton Humphrey


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



SOT: IIS, URLScan, CF and Mac

2002-11-27 Thread Joshua Miller
AHH!

I recently installed URLScan and the IIS Lockdown Utility on my IIS 5 
Server running CFMX and now I'm getting some bizarre issues with 400 
errors from Macintosh browsers on all of my CFM pages that use 
HTTP-POST for forms.

Every browser on the Mac except OmniWeb is returning 400 errors - even 
on CF Administrator - when submitting forms. Everything works just fine 
from a PC, but when using Macintosh I get these crazy errors.

Has anyone else experienced anything like this using IIS Lockdown or 
URLScan or have you seen this problem elsewhere?

Thanks in advance,

Joshua Miller

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm



RE: silly rereplace

2002-11-27 Thread Lofback, Chris
The POSIX character class is case-sensitive.  Try this:



Chris Lofback
Sr. Web Developer

TRX Integration
28051 US 19 N., Ste. C
Clearwater, FL  33761
www.trxi.com


> -Original Message-
> From: Smith, Matthew P -CONT(DYN) 
> [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, November 27, 2002 10:59 AM
> To: CF-Talk
> Subject: RE: silly rereplace
> 
> 
> Yep, works great.  Thanks for the help.
> 
> Any reason why the original doesn't work?  It seems like it 
> should, or am I
> misunderstanding the [[:Space:]] ?
> 
> 
> >>-Original Message-
> >>From: Tony Weeg [mailto:[EMAIL PROTECTED]]
> >>Sent: Wednesday, November 27, 2002 9:50 AM
> >>To: CF-Talk
> >>Subject: RE: silly rereplace
> >>
> >>
> >>
> >>why not just do this?
> >>
> >>..tony
> >>
> >>Tony Weeg
> >>Senior Web Developer
> >>Information System Design
> >>Navtrak, Inc.
> >>Fleet Management Solutions
> >>www.navtrak.net
> >>410.548.2337
> >>
> >>
> >>-Original Message-
> >>From: Smith, Matthew P -CONT(DYN) 
> [mailto:[EMAIL PROTECTED]]
> >>
> >>Sent: Wednesday, November 27, 2002 10:28 AM
> >>To: CF-Talk
> >>Subject: silly rereplace
> >>
> >>
> >>
> >>
> >>this is not stripping out spaces like I want it too...?
> >>
> >>
> >>
> >>
> >>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm



RE: CFMail Problems

2002-11-27 Thread John Beynon
I've recently had an issue similar to this and the cause was an
uncontactable SMTP server, perhaps down to a network glitch or over worked
SMTP server/

Jb.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: 27 November 2002 16:21
To: CF-Talk
Subject: CFMail Problems

I'm having an interesting problem with an application.  I searched the 
archives and found issues with 0 byte emails and spool questions about 
CF Mail, but nothing that matches this.

Why would CFMail put a perfectly good email in the Undeliverable folder? 
 I have an app that generates a steady flow of emails all day long and 
they typically get delivered.  However there are some cases where an 
email will get batched in the undeliverable folder.  I don't have access 
to the server logs as of yet but it's rather disconcerting.

On the same issue, my mind's already working on a work-around for the 
issue.  I'm thinking it might come in the form of a batch file that 
automatically copies any files in the undeliver directory that meet a 
specific criteria back into the spool directory.  My thought was to base 
it on the date/time stamp of the file, however I'm wondering if CF 
changes the date/time stamp when it moves a message into undeliver.

Thanks!
C. Hatton Humphrey



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



Re: CFMail Problems

2002-11-27 Thread Howie Hamlin
You'll need to get the mail log in order to see exactly what's happening (I know you 
already mentioned getting that).
As for moving the UNDELIVR mail - there are already a few tags in the gallery that do 
this so you you might be better
off downloading one of those.

HTH,

--
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc. - www.CoolFusion.com  - 631-737-4668 x101
inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server
>>> Find out how iMS Stacks up to the competition: 
>http://www.coolfusion.com/imssecomparison.cfm

- Original Message -
From: "Hatton Humphrey" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, November 27, 2002 11:21 AM
Subject: CFMail Problems


> I'm having an interesting problem with an application.  I searched the
> archives and found issues with 0 byte emails and spool questions about
> CF Mail, but nothing that matches this.
>
> Why would CFMail put a perfectly good email in the Undeliverable folder?
>  I have an app that generates a steady flow of emails all day long and
> they typically get delivered.  However there are some cases where an
> email will get batched in the undeliverable folder.  I don't have access
> to the server logs as of yet but it's rather disconcerting.
>
> On the same issue, my mind's already working on a work-around for the
> issue.  I'm thinking it might come in the form of a batch file that
> automatically copies any files in the undeliver directory that meet a
> specific criteria back into the spool directory.  My thought was to base
> it on the date/time stamp of the file, however I'm wondering if CF
> changes the date/time stamp when it moves a message into undeliver.
>
> Thanks!
> C. Hatton Humphrey
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



Re: silly rereplace

2002-11-27 Thread S . Isaac Dealey
> 

> this is not stripping out spaces like I want it too...?

imho you're apt to have people try to put hyphens and stuff in there also...
I'd probably go with a negate:



s. isaac dealey954-776-0046

new epoch  http://www.turnkey.to

lead architect, tapestry cms   http://products.turnkey.to

certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



Re: SOT: IIS, URLScan, CF and Mac

2002-11-27 Thread Jochem van Dieten
Joshua Miller wrote:

> I recently installed URLScan and the IIS Lockdown Utility on my IIS 5
> Server running CFMX and now I'm getting some bizarre issues with 400
> errors from Macintosh browsers on all of my CFM pages that use
> HTTP-POST for forms.
>
> Every browser on the Mac except OmniWeb is returning 400 errors - even
> on CF Administrator - when submitting forms. Everything works just 
> fine from a PC, but when using Macintosh I get these crazy errors.
>
> Has anyone else experienced anything like this using IIS Lockdown or
> URLScan or have you seen this problem elsewhere?

Sniff the network traffic to see what is the difference between OmniWeb 
and other browsers. Doesn't URLScan keep a log?

Jochem

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



Re: SQL Question

2002-11-27 Thread S . Isaac Dealey
If they're available to you, I'd use a stored procedure if you want a single
query ...

CREATE PROCEDURE sp_hit @id int AS
UPDATE sitecount
SET hits = hits + 1
WHERE id = @id;

SELECT hits FROM sitecount
WHERE id = @id;
GO


EXEC sp_hit @id = #idpassed#


hth

s. isaac dealey954-776-0046

new epoch  http://www.turnkey.to

lead architect, tapestry cms   http://products.turnkey.to

certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816



> I have a quick SQL question:

> I need to keep a running count of the time a specific location is
> requested
> and I could do it with 2 queries ie.

> 
> select hits
> from sitecount
> where id = #idpassed#
> 

> 

> 
> update sitecount
> set hits = #new_hit#
> where id = #idpassed#
> 


> But I was wondering if you could do it in a single statment since it is an
> incremental variable.
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm



Re: CFMail Problems

2002-11-27 Thread Joshua Miller
As a note, I wrote an application several months ago that scanned the  
Undeliverable folder in CF for mail and made 3 attempts to resend the  
message before discarding the message (stored attempts in a database).  
It worked pretty well, but the code is on my former employer's servers  
which I don't have access to. But it can be done and it was pretty  
successful. It typically caught all the "good" mail that just got  
shoved aside for whatever reason. CFMail is pretty buggy (especially  
4.x and 5) so I'd recommend doing something similar if you're not using  
MX.

So far I haven't had any issues with MX and CFMail, but I'm still going  
to be re-writing that application for my new CFMX server just in case.  
If you can find a reliable method to scan the undelivered mail for  
status codes or something then it would be more efficient than  
resending everything that doesn't get delivered.

Thanks,

Joshua Miller

On Wednesday, November 27, 2002, at 11:18 AM, John Beynon wrote:

> I've recently had an issue similar to this and the cause was an
> uncontactable SMTP server, perhaps down to a network glitch or over  
> worked
> SMTP server/
>
> Jb.
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 27 November 2002 16:21
> To: CF-Talk
> Subject: CFMail Problems
>
> I'm having an interesting problem with an application.  I searched the
> archives and found issues with 0 byte emails and spool questions about
> CF Mail, but nothing that matches this.
>
> Why would CFMail put a perfectly good email in the Undeliverable  
> folder?
>  I have an app that generates a steady flow of emails all day long and
> they typically get delivered.  However there are some cases where an
> email will get batched in the undeliverable folder.  I don't have  
> access
> to the server logs as of yet but it's rather disconcerting.
>
> On the same issue, my mind's already working on a work-around for the
> issue.  I'm thinking it might come in the form of a batch file that
> automatically copies any files in the undeliver directory that meet a
> specific criteria back into the spool directory.  My thought was to  
> base
> it on the date/time stamp of the file, however I'm wondering if CF
> changes the date/time stamp when it moves a message into undeliver.
>
> Thanks!
> C. Hatton Humphrey
>
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



RE: silly rereplace

2002-11-27 Thread Smith, Matthew P -CONT(DYN)
>>

I was stripping out the dashes the step before, but this is a much better
solution.  Nice!

Thanks to all for the help.

Matthew P. Smith 
Web Developer, Object Oriented 
Naval Education & Training Professional 
Development & Technology Center 
(NETPDTC) 
(850)452-1001 ext. 1245 
[EMAIL PROTECTED] 


>>-Original Message-
>>From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]]
>>Sent: Wednesday, November 27, 2002 10:22 AM
>>To: CF-Talk
>>Subject: Re: silly rereplace
>>
>>> 
>>
>>> this is not stripping out spaces like I want it too...?
>>
>>imho you're apt to have people try to put hyphens and stuff in there
>>also...
>>I'd probably go with a negate:
>>
>>
>>
>>s. isaac dealey954-776-0046
>>
>>new epoch  http://www.turnkey.to
>>
>>lead architect, tapestry cms   http://products.turnkey.to
>>
>>certified advanced coldfusion 5 developer
>>http://www.macromedia.com/v1/handlers/index.cfm?ID=21816
>>
>>
>>
>>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm



RE: silly rereplace

2002-11-27 Thread Adrian Lynch
I've been burnt with that one too. Is it me or is it not well documented?

-Original Message-
From: Lofback, Chris [mailto:[EMAIL PROTECTED]]
Sent: 27 November 2002 16:20
To: CF-Talk
Subject: RE: silly rereplace


The POSIX character class is case-sensitive.  Try this:



Chris Lofback
Sr. Web Developer

TRX Integration
28051 US 19 N., Ste. C
Clearwater, FL  33761
www.trxi.com


> -Original Message-
> From: Smith, Matthew P -CONT(DYN) 
> [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, November 27, 2002 10:59 AM
> To: CF-Talk
> Subject: RE: silly rereplace
> 
> 
> Yep, works great.  Thanks for the help.
> 
> Any reason why the original doesn't work?  It seems like it 
> should, or am I
> misunderstanding the [[:Space:]] ?
> 
> 
> >>-Original Message-
> >>From: Tony Weeg [mailto:[EMAIL PROTECTED]]
> >>Sent: Wednesday, November 27, 2002 9:50 AM
> >>To: CF-Talk
> >>Subject: RE: silly rereplace
> >>
> >>
> >>
> >>why not just do this?
> >>
> >>..tony
> >>
> >>Tony Weeg
> >>Senior Web Developer
> >>Information System Design
> >>Navtrak, Inc.
> >>Fleet Management Solutions
> >>www.navtrak.net
> >>410.548.2337
> >>
> >>
> >>-Original Message-
> >>From: Smith, Matthew P -CONT(DYN) 
> [mailto:[EMAIL PROTECTED]]
> >>
> >>Sent: Wednesday, November 27, 2002 10:28 AM
> >>To: CF-Talk
> >>Subject: silly rereplace
> >>
> >>
> >>
> >>
> >>this is not stripping out spaces like I want it too...?
> >>
> >>
> >>
> >>
> >>
> 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



RE: IIS, URLScan, CF and Mac

2002-11-27 Thread webguy
Off the cuff guess, might be due to Macs adding whitespace to the request
data.
It does that for some reason. The white space wouldn't be encoded properly
and url scan will thing that you are trying to a SQL injection or command
injection

WG

> -Original Message-
> From: Joshua Miller [mailto:[EMAIL PROTECTED]]
> Sent: 27 November 2002 16:21
> To: CF-Talk
> Subject: SOT: IIS, URLScan, CF and Mac
>
>
> AHH!
>
> I recently installed URLScan and the IIS Lockdown Utility on my IIS 5
> Server running CFMX and now I'm getting some bizarre issues with 400
> errors from Macintosh browsers on all of my CFM pages that use
> HTTP-POST for forms.
>
> Every browser on the Mac except OmniWeb is returning 400 errors - even
> on CF Administrator - when submitting forms. Everything works just fine
> from a PC, but when using Macintosh I get these crazy errors.
>
> Has anyone else experienced anything like this using IIS Lockdown or
> URLScan or have you seen this problem elsewhere?
>
> Thanks in advance,
>
> Joshua Miller
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



Alternating Row Colours & Number Listing in CFOutput

2002-11-27 Thread Ian Vaughan
Hi

I am using the following script to display the latest 5 records from the
database table, and alternate the colour of each row, from white to grey.

This works, but how to I add a number listing with each record so the latest
record would have a number 1. next to it the seconf record would have number
2 then number 3 etc.

If you look at the code attached and the second CFIF statement you will see
that at present I have hard coded a number 1 and number 2, so in the results
at present it is bringing back

1.) Record Name
2.) Record Name
1.) Record Name
2.) Record Name
1.) Record Name

How to I make this dynamic in Coldfusion so it is a number listing of 1 to
5???

TIA
Ian



  

   


  

   
 


  


1.
  
  2
  

  

 #linktitle#
  
  #linktitle#
  
  

  




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



RE: silly rereplace

2002-11-27 Thread S . Isaac Dealey
>>>

> I was stripping out the dashes the step before, but this is a much better
> solution.  Nice!

> Thanks to all for the help.

Always glad to help. :)

s. isaac dealey954-776-0046

new epoch  http://www.turnkey.to

lead architect, tapestry cms   http://products.turnkey.to

certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816



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



Re: Alternating Row Colours & Number Listing in CFOutput

2002-11-27 Thread Gyrus
- Original Message -
From: "Ian Vaughan" <[EMAIL PROTECTED]>
> This works, but how to I add a number listing with each record so the
latest
> record would have a number 1. next to it the seconf record would have
number
> 2 then number 3 etc.
---

Try using the currentrow variable in the Query scope, i.e. instead of your
current if/else 1/2 code, use:

#latestlinks.currentrow#

HTH,

Gyrus
[EMAIL PROTECTED]
work: http://www.tengai.co.uk
play: http://www.norlonto.net
PGP key available

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm



RE: Alternating Row Colours & Number Listing in CFOutput

2002-11-27 Thread webguy



color a  #foo.currentrow# ) #foo.recordname#

color b  #foo.currentrow# ) #foo.recordname#




wg
> -Original Message-
> From: Ian Vaughan [mailto:[EMAIL PROTECTED]]
> Sent: 27 November 2002 16:39
> To: CF-Talk
> Subject: Alternating Row Colours & Number Listing in CFOutput
>
>
> Hi
>
> I am using the following script to display the latest 5 records from the
> database table, and alternate the colour of each row, from white to grey.
>
> This works, but how to I add a number listing with each record so
> the latest
> record would have a number 1. next to it the seconf record would
> have number
> 2 then number 3 etc.
>
> If you look at the code attached and the second CFIF statement
> you will see
> that at present I have hard coded a number 1 and number 2, so in
> the results
> at present it is bringing back
>
> 1.) Record Name
> 2.) Record Name
> 1.) Record Name
> 2.) Record Name
> 1.) Record Name
>
> How to I make this dynamic in Coldfusion so it is a number listing of 1 to
> 5???
>
> TIA
> Ian
>
> 
>
>   
>
>
>
> 
>   
>
>
>   bgcolor="##DFDFDF">
> 
>
>   
>
> 
>  valign="middle">1.
>   
>bgcolor="##DFDFDF">2
>   
>
>   
>
>   class="xmaslinking">#linktitle#
>   
>class="xmaslinking">#linktitle#
>   
>   
>
>   
>
>
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



RE: IIS, URLScan, CF and Mac

2002-11-27 Thread webguy
Also look in the Urlscan.log

Justin



> -Original Message-
> From: webguy [mailto:[EMAIL PROTECTED]]
> Sent: 27 November 2002 16:37
> To: CF-Talk
> Subject: RE: IIS, URLScan, CF and Mac
>
>
> Off the cuff guess, might be due to Macs adding whitespace to the request
> data.
> It does that for some reason. The white space wouldn't be encoded properly
> and url scan will thing that you are trying to a SQL injection or command
> injection
>
> WG
>
> > -Original Message-
> > From: Joshua Miller [mailto:[EMAIL PROTECTED]]
> > Sent: 27 November 2002 16:21
> > To: CF-Talk
> > Subject: SOT: IIS, URLScan, CF and Mac
> >
> >
> > AHH!
> >
> > I recently installed URLScan and the IIS Lockdown Utility on my IIS 5
> > Server running CFMX and now I'm getting some bizarre issues with 400
> > errors from Macintosh browsers on all of my CFM pages that use
> > HTTP-POST for forms.
> >
> > Every browser on the Mac except OmniWeb is returning 400 errors - even
> > on CF Administrator - when submitting forms. Everything works just fine
> > from a PC, but when using Macintosh I get these crazy errors.
> >
> > Has anyone else experienced anything like this using IIS Lockdown or
> > URLScan or have you seen this problem elsewhere?
> >
> > Thanks in advance,
> >
> > Joshua Miller
> >
> >
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



Re: Alternating Row Colours & Number Listing in CFOutput

2002-11-27 Thread charlie griefer
you can use that #currentRow# variable that you're already using to 
determine alternating rows... 

 

Ian Vaughan writes: 

> Hi 
> 
> I am using the following script to display the latest 5 records from the
> database table, and alternate the colour of each row, from white to grey. 
> 
> This works, but how to I add a number listing with each record so the latest
> record would have a number 1. next to it the seconf record would have number
> 2 then number 3 etc. 
> 
> If you look at the code attached and the second CFIF statement you will see
> that at present I have hard coded a number 1 and number 2, so in the results
> at present it is bringing back 
> 
> 1.) Record Name
> 2.) Record Name
> 1.) Record Name
> 2.) Record Name
> 1.) Record Name 
> 
> How to I make this dynamic in Coldfusion so it is a number listing of 1 to
> 5??? 
> 
> TIA
> Ian 
> 
>  
> 
>
> 
> 
> 
> 
>
> 
>
>  
>  
> 
>
> 
> 
> 1.
>   
>bgcolor="##DFDFDF">2
>
> 
>
> 
>   class="xmaslinking">#linktitle#
>   
>class="xmaslinking">#linktitle#
>   
>
> 
>
> 
>  
> 
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm



RE: Alternating Row Colours & Number Listing in CFOutput

2002-11-27 Thread Jason Lees (National Express)
Cant you just use the CurrentRow variable, for the record number display?

Jason Lees
Systems Developer
National Express Coaches Ltd.



-Original Message-
From: Ian Vaughan [mailto:[EMAIL PROTECTED]]
Sent: 27 November 2002 16:39
To: CF-Talk
Subject: Alternating Row Colours & Number Listing in CFOutput


Hi

I am using the following script to display the latest 5 records from the
database table, and alternate the colour of each row, from white to grey.

This works, but how to I add a number listing with each record so the latest
record would have a number 1. next to it the seconf record would have number
2 then number 3 etc.

If you look at the code attached and the second CFIF statement you will see
that at present I have hard coded a number 1 and number 2, so in the results
at present it is bringing back

1.) Record Name
2.) Record Name
1.) Record Name
2.) Record Name
1.) Record Name

How to I make this dynamic in Coldfusion so it is a number listing of 1 to
5???

TIA
Ian



  

   


  

   
 


  


1.
  
  2
  

  

 #linktitle#
  
  #linktitle#
  
  

  





~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm



Re: Alternating Row Colours & Number Listing in CFOutput

2002-11-27 Thread S . Isaac Dealey

   
   
 
 #currentrow#.
 
   #linktitle#
 
   


Try this -- less code. :)

s. isaac dealey954-776-0046

new epoch  http://www.turnkey.to

lead architect, tapestry cms   http://products.turnkey.to

certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



Re: Alternating Row Colours & Number Listing in CFOutput

2002-11-27 Thread Cutter (CF_Talk)
Could you please explain what the following statement does?

"###iif(currentrow mod 2, DE('DFDFDF'), DE('FF'))#"


Cutter

S. Isaac Dealey wrote:

>
>   
>   
> 
> valign="middle">#currentrow#.
> 
>   #linktitle#
> 
>   
>
>
>Try this -- less code. :)
>
>s. isaac dealey954-776-0046
>
>new epoch  http://www.turnkey.to
>
>lead architect, tapestry cms   http://products.turnkey.to
>
>certified advanced coldfusion 5 developer
>http://www.macromedia.com/v1/handlers/index.cfm?ID=21816
>
>
>
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm



Re: Alternating Row Colours & Number Listing in CFOutput

2002-11-27 Thread charlie griefer
Cutter (CF_Talk) writes: 

> Could you please explain what the following statement does? 
> 
> "###iif(currentrow mod 2, DE('DFDFDF'), DE('FF'))#"

actually, i'd appreciate an explanation as well.  I understand the 
IIF()...but i never really understood DE()...what exactly it does or why it 
makes the world a better place :) 

thx.
charlie
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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



CF server hangng with unresponsive threads

2002-11-27 Thread Stephen Richards
The number of users on our system has recently increased from about 15 to
35, and now the server is hanging 3 or 4 times a day.  Server.log reporting
that the unrespnsive thread count (see log snippet at end of message).

Have tried paying with the various cfadmin settings, but no joy.

There are killer queries that are being executed, and this takes 99% of the
CPU for up to 2 minutes - and although the cfserver appears to hang at those
times, the response comes back when the query has finished, btu what we are
seeing is worse than that - indefinite hangs which can only be cured by
stoping and restarting the cf server.

We are working to get rid of the killer queries (even if they are not the
cause, they should be eliminated in any case), and will probably move the cf
server to another machine (currently on the same high spec machine as the
databse).

Is there anything else we should be doing?  Has anyone else experienced
these problems?

Am running CF 5.0 on RedHat Linux 2.4.2-2smp,  UNIX ODBC and Postgres 7.2.3

-
Stephen Richards
020 7903 3226
--




RE: Alternating Row Colours & Number Listing in CFOutput

2002-11-27 Thread webguy
Confuses the crap out of people, but saves .001  millisecond, that why
you shouldn't use it.

WG

> -Original Message-
> From: Cutter (CF_Talk) [mailto:[EMAIL PROTECTED]]

>
> Could you please explain what the following statement does?
>
> "###iif(currentrow mod 2, DE('DFDFDF'), DE('FF'))#"
>
> http://www.fusionauthority.com/ads.cfm

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm



Re: Alternating Row Colours & Number Listing in CFOutput

2002-11-27 Thread Jerry Johnson
I should let Isaac explain, since he did all the hard work, but I'll try.

The first 2 hash marks (##) output the hash symbol (The first # escapes the second #, 
which results in a single # being output)

The next two hash marks surround a Cold Fusion function, iif()

The iif() function is the "immediate if".
It evaluates a condition to true and false, and if true it outputs the first 
string, if false it outputs the second string
iif(condition,truestring,falsestring) - so iif(fname eq "Jerry", "It's me!", "It's 
not me")

The condition statement uses the mod function, which returns the left over (modulus) 
or currentrow divided by 2 
If currentrow is a multiple of 2 (2, 4, 6..), it returns a 0.  If not it returns a 
1.

The first and second strings use the DE function to "delay evaluation', or basically 
just output the string exactly as is. The DFDFDF is a grey color.

Does this help?

And I will note for the record that the first line will be grey, the second white and 
so on.

Jerry Johnson

>>> [EMAIL PROTECTED] 11/27/02 12:03PM >>>
Could you please explain what the following statement does?

"###iif(currentrow mod 2, DE('DFDFDF'), DE('FF'))#"


Cutter

S. Isaac Dealey wrote:

>
>   
>   
> 
> valign="middle">#currentrow#.
> 
>   #linktitle#
> 
>   
>
>
>Try this -- less code. :)
>
>s. isaac dealey954-776-0046
>
>new epoch  http://www.turnkey.to 
>
>lead architect, tapestry cms   http://products.turnkey.to 
>
>certified advanced coldfusion 5 developer
>http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 
>
>
>
>

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



can't refernce #attributes# on cf5?

2002-11-27 Thread Smith, Matthew P -CONT(DYN)
I'm in the unenviable position of working a site with a development server
running cfmx and the production server running cf 5.
 
I have a bit of code that verifies the form and cfmodules back to the form
if an error is found passing the entire attributes scope to maintain the
user entries.
 
Works perfect on the dev(mx) box, but dies on the prod(cf5) box.
 
I can't even do a 
 
The below code shows attributes.birthDateDay, but gets an undefined error on
the cf dump on the cf 5 server.  It works fine on the mx box...
 

#attributes.birthDateDay#

 
Matthew P. Smith 
Web Developer, Object Oriented 
Naval Education & Training Professional 
Development & Technology Center 
(NETPDTC) 
(850)452-1001 ext. 1245 
[EMAIL PROTECTED] 
 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm



Re: Alternating Row Colours & Number Listing in CFOutput

2002-11-27 Thread Dina Hess
You could also do it like this:

 
   bgcolor="##DFDFDF"
  
   bgcolor="##FF"
  >
 
which I think is slightly faster in CF5 or earlier.

Regarding DE, or Delay Evaluation, this is straight from CF5 docs:

"DE prevents evaluation of a string as an expression when it is passed as an argument 
to IIf or Evaluate." 

  - Original Message - 
  From: charlie griefer 
  To: CF-Talk 
  Sent: Wednesday, November 27, 2002 11:23 AM
  Subject: Re: Alternating Row Colours & Number Listing in CFOutput


  Cutter (CF_Talk) writes: 

  > Could you please explain what the following statement does? 
  > 
  > "###iif(currentrow mod 2, DE('DFDFDF'), DE('FF'))#"

  actually, i'd appreciate an explanation as well.  I understand the 
  IIF()...but i never really understood DE()...what exactly it does or why it 
  makes the world a better place :) 

  thx.
  charlie
  
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



RE: can't refernce #attributes# on cf5?

2002-11-27 Thread Stacy Young
Perhaps the attribute struct is not yet created when that line of code
executes. That may cause the error in CF5...and in MX it would auto create
the struct if it didn't exist.


 


HTH

Stace

-Original Message-
From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, November 27, 2002 12:36 PM
To: CF-Talk
Subject: can't refernce #attributes# on cf5?

I'm in the unenviable position of working a site with a development server
running cfmx and the production server running cf 5.
 
I have a bit of code that verifies the form and cfmodules back to the form
if an error is found passing the entire attributes scope to maintain the
user entries.
 
Works perfect on the dev(mx) box, but dies on the prod(cf5) box.
 
I can't even do a 
 
The below code shows attributes.birthDateDay, but gets an undefined error on
the cf dump on the cf 5 server.  It works fine on the mx box...
 

#attributes.birthDateDay#

 
Matthew P. Smith 
Web Developer, Object Oriented 
Naval Education & Training Professional 
Development & Technology Center 
(NETPDTC) 
(850)452-1001 ext. 1245 
[EMAIL PROTECTED] 
 


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



RE: CF server hangng with unresponsive threads

2002-11-27 Thread Jim Davis
> The number of users on our system has recently increased from 
> about 15 to 35, and now the server is hanging 3 or 4 times a 
> day.  Server.log reporting that the unrespnsive thread count 
> (see log snippet at end of message).
> 
> Have tried paying with the various cfadmin settings, but no joy.
> 
> There are killer queries that are being executed, and this 
> takes 99% of the CPU for up to 2 minutes - and although the 
> cfserver appears to hang at those times, the response comes 
> back when the query has finished, btu what we are seeing is 
> worse than that - indefinite hangs which can only be cured by 
> stoping and restarting the cf server.
> 
> We are working to get rid of the killer queries (even if they 
> are not the cause, they should be eliminated in any case), 
> and will probably move the cf server to another machine 
> (currently on the same high spec machine as the databse).
> 
> Is there anything else we should be doing?  Has anyone else 
> experienced these problems?
> 
> Am running CF 5.0 on RedHat Linux 2.4.2-2smp,  UNIX ODBC and 
> Postgres 7.2.3

I know that this is an old saw, but are you locking properly?  If not
then added load is exactly when you'll see problems.

I've a guide to locking here that might be useful:

http://www.depressedpress.com/DepressedPress/Content/ColdFusion/Guides/L
ocking/Index.cfm

The guide is really only application to CF 4-5 as MX changes (and
improves) the locking rules quite a bit, but since you're on 5.0 it's
still VERY important.

Jim Davis


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



RE: Alternating Row Colours & Number Listing in CFOutput

2002-11-27 Thread Andy Ousterhout
Here is the code that I use combined with a Style Sheet:









Column 1
Column
2



Andy

-Original Message-
From: Ian Vaughan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 27, 2002 10:39 AM
To: CF-Talk
Subject: Alternating Row Colours & Number Listing in CFOutput


Hi

I am using the following script to display the latest 5 records from the
database table, and alternate the colour of each row, from white to grey.

This works, but how to I add a number listing with each record so the latest
record would have a number 1. next to it the seconf record would have number
2 then number 3 etc.

If you look at the code attached and the second CFIF statement you will see
that at present I have hard coded a number 1 and number 2, so in the results
at present it is bringing back

1.) Record Name
2.) Record Name
1.) Record Name
2.) Record Name
1.) Record Name

How to I make this dynamic in Coldfusion so it is a number listing of 1 to
5???

TIA
Ian



  

   


  

   
 


  


1.
  
  2
  

  

 #linktitle#
  
  #linktitle#
  
  

  





~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm



RE: CFDIRECTORY FILTER MX

2002-11-27 Thread Sam Roach
Posting this again I still can't figure it out.

thanks,
-- Sam


-Original Message-
From: Sam Roach [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 26, 2002 9:50 AM
To: CF-Talk
Subject: CFDIRECTORY FILTER MX


I need a little help with the CFDIRECTORY tag...

This used to work fine in cold fusion 5. But in MX it returns to many files.



This returns the same results as *0*.html ... But What I need it only one
character between the '0' and the '.html'. 

EX:
myreport01.html  -- I want this file listed
myreport01_data.html  -- But not this one..
myreport02.html  -- I want this file listed
myreport02_data.html  -- not this one..

-- Sam

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm



RE: CF server hangng with unresponsive threads

2002-11-27 Thread Mike Brunt
Stephen, are you using Application, Server and/or Session scoped variables
in your application?

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

Web Application Specialists


-Original Message-
From: Stephen Richards [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 27, 2002 9:21 AM
To: CF-Talk
Subject: CF server hangng with unresponsive threads


The number of users on our system has recently increased from about 15 to
35, and now the server is hanging 3 or 4 times a day.  Server.log reporting
that the unrespnsive thread count (see log snippet at end of message).

Have tried paying with the various cfadmin settings, but no joy.

There are killer queries that are being executed, and this takes 99% of the
CPU for up to 2 minutes - and although the cfserver appears to hang at those
times, the response comes back when the query has finished, btu what we are
seeing is worse than that - indefinite hangs which can only be cured by
stoping and restarting the cf server.

We are working to get rid of the killer queries (even if they are not the
cause, they should be eliminated in any case), and will probably move the cf
server to another machine (currently on the same high spec machine as the
databse).

Is there anything else we should be doing?  Has anyone else experienced
these problems?

Am running CF 5.0 on RedHat Linux 2.4.2-2smp,  UNIX ODBC and Postgres 7.2.3

-
Stephen Richards
020 7903 3226
--



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



RE: can't reference #attributes# on cf5?

2002-11-27 Thread Smith, Matthew P -CONT(DYN)
Wouldn't setting a variable in the attributes scope cause it to be defined?

Here's a bit more expanded view of the code:











It errors out on the attributeCollection="#attributes#", line above the
cfabort.

I added in you snippet, and it's working now.  Thanks so much.

I'm just curious as to why setting a var wouldn't create the structure?
















>>-Original Message-
>>From: Stacy Young [mailto:[EMAIL PROTECTED]]
>>Sent: Wednesday, November 27, 2002 11:41 AM
>>To: CF-Talk
>>Subject: RE: can't refernce #attributes# on cf5?
>>
>>Perhaps the attribute struct is not yet created when that line of code
>>executes. That may cause the error in CF5...and in MX it would auto create
>>the struct if it didn't exist.
>>
>>
>> 
>>
>>
>>HTH
>>
>>Stace
>>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



RE: Alternating Row Colours & Number Listing in CFOutput

2002-11-27 Thread webguy
Andy said:
>Here is the code that I use combined with a Style Sheet:
>   


Why on earth ? Here is that logic in English

if (the number of the currentrow plus one) divided by 2 is divisible by two
with no remainder

you can just do



if ( the currentrow is divisible by two with no remainder )  

WG

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



OT: Anyone Having Success with Verity

2002-11-27 Thread David Hannum
Is there anyone out there who is having success with Verity in an Enterprise
environment.  We have over 88,000 web pages plus all the other documents on
55 servers.  Can Verity K2 which comes with CF even begin to handle this in
a reliable manner?  Comments please . . .  Alternate recommendations . . .

Dave Hannum

===
David R. Hannum
Web Analyst/Programmer
Ohio University Computer Services
Administrative Systems
(740) 597-2524

"If your wife is having fun, and you're not . . .
You're still having a lot more fun than if
you're having fun, and she's not!"  (Red Green)

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm



RE: can't reference #attributes# on cf5?

2002-11-27 Thread Stacy Young
Glad it works!

I'm no expert on the mechanics but basically pre-MX you have to define the
item as a structure first before u can start adding keys to it...

Stace

-Original Message-
From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, November 27, 2002 12:52 PM
To: CF-Talk
Subject: RE: can't reference #attributes# on cf5?

Wouldn't setting a variable in the attributes scope cause it to be defined?

Here's a bit more expanded view of the code:











It errors out on the attributeCollection="#attributes#", line above the
cfabort.

I added in you snippet, and it's working now.  Thanks so much.

I'm just curious as to why setting a var wouldn't create the structure?
















>>-Original Message-
>>From: Stacy Young [mailto:[EMAIL PROTECTED]]
>>Sent: Wednesday, November 27, 2002 11:41 AM
>>To: CF-Talk
>>Subject: RE: can't refernce #attributes# on cf5?
>>
>>Perhaps the attribute struct is not yet created when that line of code
>>executes. That may cause the error in CF5...and in MX it would auto create
>>the struct if it didn't exist.
>>
>>
>> 
>>
>>
>>HTH
>>
>>Stace
>>

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



RE: CFDIRECTORY FILTER MX

2002-11-27 Thread webguy
If so, it looks like a bug or a undocumented change in MX, in MX they
dropped the listing of "." and ".."

I work around is to do >





You should report the bug 

WG

> -Original Message-
> From: Sam Roach [mailto:[EMAIL PROTECTED]]
> Sent: 27 November 2002 17:46
> To: CF-Talk
> Subject: RE: CFDIRECTORY FILTER MX
>
>
> Posting this again I still can't figure it out.
>
> thanks,
> -- Sam
>
>
> -Original Message-
> From: Sam Roach [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, November 26, 2002 9:50 AM
> To: CF-Talk
> Subject: CFDIRECTORY FILTER MX
>
>
> I need a little help with the CFDIRECTORY tag...
>
> This used to work fine in cold fusion 5. But in MX it returns to
> many files.
>
>  NAME="myDirectory" FILTER="*0?.html"
>   SORT="datelastmodified, name ASC">
>
> This returns the same results as *0*.html ... But What I need it only one
> character between the '0' and the '.html'.
>
> EX:
>   myreport01.html  -- I want this file listed
>   myreport01_data.html  -- But not this one..
>   myreport02.html  -- I want this file listed
>   myreport02_data.html  -- not this one..
>
> -- Sam
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



RE: Alternating Row Colours & Number Listing in CFOutput

2002-11-27 Thread Andy Ousterhout
Because the first row is a header row and I did this to align the colors
correctly.  I should have just have switched labels.  Duh.

Thanks.

-Original Message-
From: webguy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 27, 2002 11:53 AM
To: CF-Talk
Subject: RE: Alternating Row Colours & Number Listing in CFOutput


Andy said:
>Here is the code that I use combined with a Style Sheet:
>   


Why on earth ? Here is that logic in English

if (the number of the currentrow plus one) divided by 2 is divisible by two
with no remainder

you can just do



if ( the currentrow is divisible by two with no remainder )  

WG


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm



sessionquery.recordcount

2002-11-27 Thread Simon Stanlake
hi,
we have the following code...


select  * 
fromtheTable








occasionally, we exit this piece of code and the length of the array is
different from the length of the query.  ie: 

arraylen(defaultValueArray) != session.myResults.recordCount.

It seems to me that this should never happen.

I've changed the name of the table and the session variable, but otherwise
the code is a cut-and-paste.  I realize there are a bunch of different ways
to do this, but I want to know what causes this behaviour.  Has anyone else
seen something similar?  recordcount not always returning the right value?
cfloop bailing out early? funniness when storing queries in the session
scope?

thanks,
simon
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



Looking for ideas or suggestions to accomplish task

2002-11-27 Thread David Hannum
Eric,  You simply use FORM.vars to repopulate the search field on the second page.  
That way, they see their current search criteria, and can change it if desired.

Dave
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm



RE: sessionquery.recordcount

2002-11-27 Thread Tony Weeg
ive never seen naming a query in the session scopethats definitely a
new one one me.

..tony

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


-Original Message-
From: Simon Stanlake [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, November 27, 2002 1:04 PM
To: CF-Talk
Subject: sessionquery.recordcount


hi,
we have the following code...


select  * 
fromtheTable








occasionally, we exit this piece of code and the length of the array is
different from the length of the query.  ie: 

arraylen(defaultValueArray) != session.myResults.recordCount.

It seems to me that this should never happen.

I've changed the name of the table and the session variable, but
otherwise
the code is a cut-and-paste.  I realize there are a bunch of different
ways
to do this, but I want to know what causes this behaviour.  Has anyone
else
seen something similar?  recordcount not always returning the right
value?
cfloop bailing out early? funniness when storing queries in the session
scope?

thanks,
simon

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



RE: Alternating Row Colours & Number Listing in CFOutput

2002-11-27 Thread Andy Ousterhout
I just remembered why I did this --

The loop that does this creates 2 columns (Each loop processes 1 record, 2
records per row).  You are correct for a single column.

Andy

-Original Message-
From: Andy Ousterhout [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 27, 2002 11:59 AM
To: [EMAIL PROTECTED]
Subject: RE: Alternating Row Colours & Number Listing in CFOutput


Because the first row is a header row and I did this to align the colors
correctly.  I should have just have switched labels.  Duh.

Thanks.

-Original Message-
From: webguy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 27, 2002 11:53 AM
To: CF-Talk
Subject: RE: Alternating Row Colours & Number Listing in CFOutput


Andy said:
>Here is the code that I use combined with a Style Sheet:
>   


Why on earth ? Here is that logic in English

if (the number of the currentrow plus one) divided by 2 is divisible by two
with no remainder

you can just do



if ( the currentrow is divisible by two with no remainder )  

WG


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm



RE: sessionquery.recordcount

2002-11-27 Thread Timothy Heald
The only time I have gotten a record count higher than I thought it should be was when 
I was using aggregate functions. So I would get 1, even if there was really nothing 
returned (because the result was a 0).

Aside from that, what are you doing that requires this? Maybe we could figure out a 
better way of doing it?

Tim

-Original Message-
From: Simon Stanlake [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 27, 2002 1:04 PM
To: CF-Talk
Subject: sessionquery.recordcount


hi,
we have the following code...


select  * 
fromtheTable








occasionally, we exit this piece of code and the length of the array is
different from the length of the query.  ie: 

arraylen(defaultValueArray) != session.myResults.recordCount.

It seems to me that this should never happen.

I've changed the name of the table and the session variable, but otherwise
the code is a cut-and-paste.  I realize there are a bunch of different ways
to do this, but I want to know what causes this behaviour.  Has anyone else
seen something similar?  recordcount not always returning the right value?
cfloop bailing out early? funniness when storing queries in the session
scope?

thanks,
simon

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



Re: CFMail Problems

2002-11-27 Thread Hatton Humphrey
Thanks for all the replies!

I did get my hands on the mail.log file and it does look to be a server 
communication issue.  The log file showed over 900 out of 1038 lines 
were some form of sever communication problem.

Happy Turkey Day!
Hatton


John Beynon wrote:

>I've recently had an issue similar to this and the cause was an
>uncontactable SMTP server, perhaps down to a network glitch or over worked
>SMTP server/
>
>Jb.
>
>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
>Sent: 27 November 2002 16:21
>To: CF-Talk
>Subject: CFMail Problems
>
>I'm having an interesting problem with an application.  I searched the 
>archives and found issues with 0 byte emails and spool questions about 
>CF Mail, but nothing that matches this.
>
>Why would CFMail put a perfectly good email in the Undeliverable folder? 
> I have an app that generates a steady flow of emails all day long and 
>they typically get delivered.  However there are some cases where an 
>email will get batched in the undeliverable folder.  I don't have access 
>to the server logs as of yet but it's rather disconcerting.
>
>On the same issue, my mind's already working on a work-around for the 
>issue.  I'm thinking it might come in the form of a batch file that 
>automatically copies any files in the undeliver directory that meet a 
>specific criteria back into the spool directory.  My thought was to base 
>it on the date/time stamp of the file, however I'm wondering if CF 
>changes the date/time stamp when it moves a message into undeliver.
>
>Thanks!
>C. Hatton Humphrey
>
>
>
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



RE: sessionquery.recordcount

2002-11-27 Thread Simon Stanlake
well, we want to add a column called 'selected' using addQueryColumn.

the best way to do this (would probably be faster too) would be to go


select theTable.*, 1 as selected
from theTable


I will probably end up doing this, just wanted to figure out what was going
on.

thanks,
simon

-Original Message-
From: Timothy Heald [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 27, 2002 10:12 AM
To: CF-Talk
Subject: RE: sessionquery.recordcount


The only time I have gotten a record count higher than I thought it should
be was when I was using aggregate functions. So I would get 1, even if there
was really nothing returned (because the result was a 0).

Aside from that, what are you doing that requires this? Maybe we could
figure out a better way of doing it?

Tim

-Original Message-
From: Simon Stanlake [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 27, 2002 1:04 PM
To: CF-Talk
Subject: sessionquery.recordcount


hi,
we have the following code...


select  * 
fromtheTable








occasionally, we exit this piece of code and the length of the array is
different from the length of the query.  ie: 

arraylen(defaultValueArray) != session.myResults.recordCount.

It seems to me that this should never happen.

I've changed the name of the table and the session variable, but otherwise
the code is a cut-and-paste.  I realize there are a bunch of different ways
to do this, but I want to know what causes this behaviour.  Has anyone else
seen something similar?  recordcount not always returning the right value?
cfloop bailing out early? funniness when storing queries in the session
scope?

thanks,
simon


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm



RE: sessionquery.recordcount

2002-11-27 Thread Simon Stanlake
I should clarify, I'm getting a lower record count than I expect.

ie: querylen=5000, arraylen=1537 (or something).

thanks for the replies,
simon

-Original Message-
From: Timothy Heald [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 27, 2002 10:12 AM
To: CF-Talk
Subject: RE: sessionquery.recordcount


The only time I have gotten a record count higher than I thought it should
be was when I was using aggregate functions. So I would get 1, even if there
was really nothing returned (because the result was a 0).

Aside from that, what are you doing that requires this? Maybe we could
figure out a better way of doing it?

Tim

-Original Message-
From: Simon Stanlake [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 27, 2002 1:04 PM
To: CF-Talk
Subject: sessionquery.recordcount


hi,
we have the following code...


select  * 
fromtheTable








occasionally, we exit this piece of code and the length of the array is
different from the length of the query.  ie: 

arraylen(defaultValueArray) != session.myResults.recordCount.

It seems to me that this should never happen.

I've changed the name of the table and the session variable, but otherwise
the code is a cut-and-paste.  I realize there are a bunch of different ways
to do this, but I want to know what causes this behaviour.  Has anyone else
seen something similar?  recordcount not always returning the right value?
cfloop bailing out early? funniness when storing queries in the session
scope?

thanks,
simon


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm



RE: Alternating Row Colours & Number Listing in CFOutput

2002-11-27 Thread Rob Rohan
Hey don't be too mean. Judging from most people I have taught, Mod is one of
the hardest things to grasp for new procedural programmers (that and when to
use / how to write a function).

Rob

http://treebeard.sourceforge.net
http://ruinworld.sourceforge.net
Scientia Est Potentia

-Original Message-
From: webguy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 27, 2002 9:53 AM
To: CF-Talk
Subject: RE: Alternating Row Colours & Number Listing in CFOutput


Andy said:
>Here is the code that I use combined with a Style Sheet:
>   


Why on earth ? Here is that logic in English

if (the number of the currentrow plus one) divided by 2 is divisible by two
with no remainder

you can just do



if ( the currentrow is divisible by two with no remainder )  

WG


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



RE: Anyone Having Success with Verity

2002-11-27 Thread Ryan Kime
Wow that's a lot of stuff...well supposedly the OEM version can handle it,
but if it is a critical component to the university, I would look into a
separate solution. Either the full strength Verity Enterprise on a dedicated
box or a Google appliance:

Verity K2 Enterprise
http://www.verity.com/products/k2_enterprise/index.html

Google appliances
http://www.google.com/appliance/hardware.html

Both can handle more info and have enhanced features such as allowing you to
view documents as HTML instead of the original content format (such as doc
and pdf) which could save some internal network bandwidth and user search
time. Unfortunately, both of these are not cheap and can quickly tell you
how serious management is about their search capabilities. 


-Original Message-
From: David Hannum [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, November 27, 2002 11:53 AM
To: CF-Talk
Subject: OT: Anyone Having Success with Verity


Is there anyone out there who is having success with Verity in an Enterprise
environment.  We have over 88,000 web pages plus all the other documents on
55 servers.  Can Verity K2 which comes with CF even begin to handle this in
a reliable manner?  Comments please . . .  Alternate recommendations . . .

Dave Hannum

===
David R. Hannum
Web Analyst/Programmer
Ohio University Computer Services
Administrative Systems
(740) 597-2524

"If your wife is having fun, and you're not . . .
You're still having a lot more fun than if
you're having fun, and she's not!"  (Red Green)


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm



RE: Anyone Having Success with Verity

2002-11-27 Thread Jim Davis
> -Original Message-
> From: David Hannum [mailto:[EMAIL PROTECTED]] 
> Sent: Wednesday, November 27, 2002 12:53 PM
> To: CF-Talk
> Subject: OT: Anyone Having Success with Verity
> 
> 
> Is there anyone out there who is having success with Verity 
> in an Enterprise environment.  We have over 88,000 web pages 
> plus all the other documents on 55 servers.  Can Verity K2 
> which comes with CF even begin to handle this in a reliable 
> manner?  Comments please . . .  Alternate recommendations . . .

I would guess that it depends on how it's set up... In that case I would
suggest, at the very least, a dedicated search server (or several).

The problem doesn't seem to be the size of the catalog particularly (but
the frequency of rebuilds does matter), but the size of the server farm.
With over 50 machines my guess is that network lag is going to play a
huge part in performance - also you may need more control over the
collection as each file can come from many different places.

Lastly CF Pro and Enteprise have different hard-coded limits on
collection size - you didn't say which you were using.

In short it should handle it, if done well, but it might be easier to
consider the full Verity product which is quite a bit more configurable.

Jim Davis


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



Looking for ideas or suggestions to accomplish task

2002-11-27 Thread Eric Creese
I do not have to show them their criteria, and to do so would cause some additional 
coding grief for me. For example I would have to then write my queries to exclude 
their previous criteria from their select choices.
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm



Would anyone want a CFX_HTTP tag written in Java?

2002-11-27 Thread ksuh
So, I just wrote a CFHTTP tag in Java that actually works.  Right now, it only does 
"get" operations, but if anyone would want to play with it, I can set up a website 
tonight where you guys can download it.

So, anybody interested? 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm



RE: CF server hangng with unresponsive threads

2002-11-27 Thread Lee Fuller
Stephen,

See the following thread at MM's site...

http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=143



| -Original Message-
| From: Mike Brunt [mailto:[EMAIL PROTECTED]] 
| Sent: Wednesday, November 27, 2002 9:47 AM
| To: CF-Talk
| Subject: RE: CF server hangng with unresponsive threads
| 
| 
| Stephen, are you using Application, Server and/or Session 
| scoped variables in your application?
| 
| Kind Regards - Mike Brunt, CTO
| Webapper
| Blog http://www.webapper.net
| Web site http://www.webapper.com
| Downey CA Office
| 562.243.6255
| AIM - webappermb
| 
| Web Application Specialists
| 
| 
| -Original Message-
| From: Stephen Richards [mailto:[EMAIL PROTECTED]]
| Sent: Wednesday, November 27, 2002 9:21 AM
| To: CF-Talk
| Subject: CF server hangng with unresponsive threads
| 
| 
| The number of users on our system has recently increased from 
| about 15 to 35, and now the server is hanging 3 or 4 times a 
| day.  Server.log reporting that the unrespnsive thread count 
| (see log snippet at end of message).
| 
| Have tried paying with the various cfadmin settings, but no joy.
| 
| There are killer queries that are being executed, and this 
| takes 99% of the CPU for up to 2 minutes - and although the 
| cfserver appears to hang at those times, the response comes 
| back when the query has finished, btu what we are seeing is 
| worse than that - indefinite hangs which can only be cured by 
| stoping and restarting the cf server.
| 
| We are working to get rid of the killer queries (even if they 
| are not the cause, they should be eliminated in any case), 
| and will probably move the cf server to another machine 
| (currently on the same high spec machine as the databse).
| 
| Is there anything else we should be doing?  Has anyone else 
| experienced these problems?
| 
| Am running CF 5.0 on RedHat Linux 2.4.2-2smp,  UNIX ODBC and 
| Postgres 7.2.3
| 
| -
| Stephen Richards
| 020 7903 3226
| --
| 
| 
| 
| 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm



RE: Would anyone want a CFX_HTTP tag written in Java?

2002-11-27 Thread Stacy Young
Sure!

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, November 27, 2002 1:52 PM
To: CF-Talk
Subject: Would anyone want a CFX_HTTP tag written in Java?

So, I just wrote a CFHTTP tag in Java that actually works.  Right now, it
only does "get" operations, but if anyone would want to play with it, I can
set up a website tonight where you guys can download it.

So, anybody interested? 


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



Re: Alternating Row Colours & Number Listing in CFOutput

2002-11-27 Thread S . Isaac Dealey
> I should let Isaac explain, since he did all the hard work, but I'll try.

Thanks Jerry, :)

I don't think I could have explained it better myself. :)

> The first 2 hash marks (##) output the hash symbol (The first # escapes
> the second #, which results in a single # being output)

> The next two hash marks surround a Cold Fusion function, iif()

> The iif() function is the "immediate if".
> It evaluates a condition to true and false, and if true it outputs the
> first string, if false it outputs the second string
> iif(condition,truestring,falsestring) - so iif(fname eq "Jerry", "It's
> me!", "It's not me")

> The condition statement uses the mod function, which returns the left over
> (modulus) or currentrow divided by 2
> If currentrow is a multiple of 2 (2, 4, 6..), it returns a 0.  If not
> it returns a 1.

> The first and second strings use the DE function to "delay evaluation', or
> basically just output the string exactly as is. The DFDFDF is a grey
> color.

> Does this help?

> And I will note for the record that the first line will be grey, the
> second white and so on.

> Jerry Johnson

 [EMAIL PROTECTED] 11/27/02 12:03PM >>>
> Could you please explain what the following statement does?

> "###iif(currentrow mod 2, DE('DFDFDF'), DE('FF'))#"


> Cutter

> S. Isaac Dealey wrote:

>>
>>   
>>   
>> 
>> >valign="middle">#currentrow#.
>> 
>>   #linktitle#
>> 
>>   
>>
>>
>>Try this -- less code. :)
>>
>>s. isaac dealey954-776-0046
>>
>>new epoch  http://www.turnkey.to
>>
>>lead architect, tapestry cms   http://products.turnkey.to
>>
>>certified advanced coldfusion 5 developer
>>http://www.macromedia.com/v1/handlers/index.cfm?ID=21816
>>
>>
>>
>>

> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



RE: Would anyone want a CFX_HTTP tag written in Java?

2002-11-27 Thread Mike Brunt
Yes we are interested also, thank you.

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

Web Application Specialists


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 27, 2002 10:52 AM
To: CF-Talk
Subject: Would anyone want a CFX_HTTP tag written in Java?


So, I just wrote a CFHTTP tag in Java that actually works.  Right now, it
only does "get" operations, but if anyone would want to play with it, I can
set up a website tonight where you guys can download it.

So, anybody interested?


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



Looking for ideas or suggestions to accomplish task

2002-11-27 Thread Eric Creese
How could I do this with multi list select boxes?
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com



RE: sessionquery.recordcount

2002-11-27 Thread S . Isaac Dealey
This was a bad idea pre-MX because of locking issues... i.e.

You wouldn't want to use  because the query is going to
take a lot longer to complete than  and you
wouldn't want to leave the reference to the session variable unlocked, so
although it was possible to use name="session.myquery" it wasn't adviseable.


s. isaac dealey954-776-0046

new epoch  http://www.turnkey.to

lead architect, tapestry cms   http://products.turnkey.to

certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816



> ive never seen naming a query in the session scopethats definitely a
> new one one me.

> ..tony

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


> -Original Message-
> From: Simon Stanlake [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, November 27, 2002 1:04 PM
> To: CF-Talk
> Subject: sessionquery.recordcount


> hi,
> we have the following code...

>   
>   select  *
>   fromtheTable
>   

> 
>   
>   
>   
>   

> occasionally, we exit this piece of code and the length of the array is
> different from the length of the query.  ie:

>   arraylen(defaultValueArray) != session.myResults.recordCount.

> It seems to me that this should never happen.

> I've changed the name of the table and the session variable, but
> otherwise
> the code is a cut-and-paste.  I realize there are a bunch of different
> ways
> to do this, but I want to know what causes this behaviour.  Has anyone
> else
> seen something similar?  recordcount not always returning the right
> value?
> cfloop bailing out early? funniness when storing queries in the session
> scope?

> thanks,
> simon

> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



RE: CFDIRECTORY FILTER MX

2002-11-27 Thread S . Isaac Dealey
I always used ListFind(".,..",mydirectory.name)

> If so, it looks like a bug or a undocumented change in MX, in MX they
> dropped the listing of "." and ".."

> I work around is to do >

>NAME="myDirectory" FILTER="*0?.html"
>   SORT="datelastmodified, name ASC">

>   --->

> You should report the bug 

> WG

>> -Original Message-
>> From: Sam Roach [mailto:[EMAIL PROTECTED]]
>> Sent: 27 November 2002 17:46
>> To: CF-Talk
>> Subject: RE: CFDIRECTORY FILTER MX
>>
>>
>> Posting this again I still can't figure it out.
>>
>> thanks,
>> -- Sam
>>
>>
>> -Original Message-
>> From: Sam Roach [mailto:[EMAIL PROTECTED]]
>> Sent: Tuesday, November 26, 2002 9:50 AM
>> To: CF-Talk
>> Subject: CFDIRECTORY FILTER MX
>>
>>
>> I need a little help with the CFDIRECTORY tag...
>>
>> This used to work fine in cold fusion 5. But in MX it returns to
>> many files.
>>
>>  >  NAME="myDirectory" FILTER="*0?.html"
>>  SORT="datelastmodified, name ASC">
>>
>> This returns the same results as *0*.html ... But What I need it only one
>> character between the '0' and the '.html'.
>>
>> EX:
>>  myreport01.html  -- I want this file listed
>>  myreport01_data.html  -- But not this one..
>>  myreport02.html  -- I want this file listed
>>  myreport02_data.html  -- not this one..
>>
>> -- Sam
>>
>>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



RE: Alternating Row Colours & Number Listing in CFOutput

2002-11-27 Thread S . Isaac Dealey
I suspect one one-millionth of a second ( or is that of a millisecond ) will
matter much on an output of 5 rows.

> Confuses the crap out of people, but saves .001  millisecond, that why
> you shouldn't use it.

> WG

>> -Original Message-
>> From: Cutter (CF_Talk) [mailto:[EMAIL PROTECTED]]

>>
>> Could you please explain what the following statement does?
>>
>> "###iif(currentrow mod 2, DE('DFDFDF'), DE('FF'))#"
>>
>> http://www.fusionauthority.com/ads.cfm


s. isaac dealey954-776-0046

new epoch  http://www.turnkey.to

lead architect, tapestry cms   http://products.turnkey.to

certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm



Pushing a file to a specified port?

2002-11-27 Thread Jim Campbell
We have a CFMX-based reservation application.  There's a software company
that wants to partner with us to provide some interoperability with a Win32
reservation management application.  Match made in heaven, right?

The proposal is to have a "Get my reservations" button at some location,
which would send a delimited file to a certain port on the requester's
machine.  The Win32 app will constantly be listening to that port when it's
running, and will scan the destination directory where this file is supposed
to be placed on startup for any updates.  When it finds/gets updates, it
will automatically drop all the data into whatever structure it uses
internally.

So, I'm just starting to think my way through this one.  Assuming the port
is open (we'll conveniently not think about blocked ports, firewalls,
ZoneAlarm or anything else at this point), how would you think I should go
about this?  The client won't have any server software on their end, so I'll
basically have to push a bunch of bytes to a specific address:port and
assume the machine lets me write it there.  Does CFMX have anything internal
that might facilitate this, or would I be better off writing an app and
running it via ?

- Jim

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm



RE: CFDIRECTORY FILTER MX

2002-11-27 Thread Rob Rohan
It's a documented change. It's in the migrating to CFMX hand book.

Rob

http://treebeard.sourceforge.net
http://ruinworld.sourceforge.net
Scientia Est Potentia

-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 27, 2002 11:06 AM
To: CF-Talk
Subject: RE: CFDIRECTORY FILTER MX


I always used ListFind(".,..",mydirectory.name)

> If so, it looks like a bug or a undocumented change in MX, in MX they
> dropped the listing of "." and ".."

> I work around is to do >

>NAME="myDirectory" FILTER="*0?.html"
>   SORT="datelastmodified, name ASC">

>   --->

> You should report the bug 

> WG

>> -Original Message-
>> From: Sam Roach [mailto:[EMAIL PROTECTED]]
>> Sent: 27 November 2002 17:46
>> To: CF-Talk
>> Subject: RE: CFDIRECTORY FILTER MX
>>
>>
>> Posting this again I still can't figure it out.
>>
>> thanks,
>> -- Sam
>>
>>
>> -Original Message-
>> From: Sam Roach [mailto:[EMAIL PROTECTED]]
>> Sent: Tuesday, November 26, 2002 9:50 AM
>> To: CF-Talk
>> Subject: CFDIRECTORY FILTER MX
>>
>>
>> I need a little help with the CFDIRECTORY tag...
>>
>> This used to work fine in cold fusion 5. But in MX it returns to
>> many files.
>>
>>  >  NAME="myDirectory" FILTER="*0?.html"
>>  SORT="datelastmodified, name ASC">
>>
>> This returns the same results as *0*.html ... But What I need it only one
>> character between the '0' and the '.html'.
>>
>> EX:
>>  myreport01.html  -- I want this file listed
>>  myreport01_data.html  -- But not this one..
>>  myreport02.html  -- I want this file listed
>>  myreport02_data.html  -- not this one..
>>
>> -- Sam
>>
>>
>

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



spawn the e-mail client & line breaks in mailto:

2002-11-27 Thread Sosnow, Michael
I am trying to write an application that will allow the user to subscribe to
multiple Listserv lists. I want them to fill out a form that when submitted
will automatically open their mail client with the subscribe commands in the
body of the e-mail. I can construct the mailto on submittal of the form

mailto:[EMAIL PROTECTED]?body=#mybody#";>Link text

but I don't know how to spawn the client on execution of the template. 
And the second problem I have it getting "mybody" have line breaks, as I
need each subscribe command on a separate line. I tried:



and a few other variations with no luck.

Any help would be appreciated.

Michael Sosnow




RE: Pushing a file to a specified port?

2002-11-27 Thread Dave Watts
> We have a CFMX-based reservation application. There's a 
> software company that wants to partner with us to provide 
> some interoperability with a Win32 reservation management 
> application. Match made in heaven, right?
> 
> The proposal is to have a "Get my reservations" button at 
> some location, which would send a delimited file to a 
> certain port on the requester's machine. The Win32 app will 
> constantly be listening to that port when it's running, and 
> will scan the destination directory where this file is supposed
> to be placed on startup for any updates. When it finds/gets 
> updates, it will automatically drop all the data into whatever
> structure it uses internally.
> 
> So, I'm just starting to think my way through this one.  
> Assuming the port is open (we'll conveniently not think 
> about blocked ports, firewalls, ZoneAlarm or anything else 
> at this point), how would you think I should go about this?  
> The client won't have any server software on their end, so 
> I'll basically have to push a bunch of bytes to a specific 
> address:port and assume the machine lets me write it there.  
> Does CFMX have anything internal that might facilitate this, 
> or would I be better off writing an app and running it via 
> ?

I'm a little confused. Where will the Win32 application reside, exactly?
Will it be on the end-users machine? If so, why not have the Win32
application just fetch the file itself, if it's running? It sounds like the
approach you're proposing is a bit backwards.

If you are going to proceed this way, good luck - I imagine that it simply
won't work in many locations, because of the firewall issue you mention.
However, in any case, you might find these useful:

http://java.sun.com/docs/books/tutorial/networking/sockets/
http://www.javaworld.com/javaworld/jw-12-1996/jw-12-sockets.html

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

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm



Re: Pushing a file to a specified port?

2002-11-27 Thread Samuel R. Neff
CFMX can't send raw data to ports like that.  Best bet is to create a Java 
class/bean/ejb to do that work--much more efficient than using cfexecute.

At 01:17 PM 11/27/2002, Jim Campbell wrote:
>(snip)
>assume the machine lets me write it there.  Does CFMX have anything internal
>that might facilitate this, or would I be better off writing an app and
>running it via ?
>
>- Jim

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



CFEXECUTE and Perl Scripts

2002-11-27 Thread David Adams
I am having a hard time calling a PERL script from a CFEXECUTE tag.  It
seems to not accept more than one argument.
 
For example the following code with FAIL:
 
http://www.cnn.com";
timeout="10">

 
 
The following code will WORK but I cannot pass it a second or third
argument:
 


 
Any ideas?
Dave adams
CFUG Ottawa


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



RE: Would anyone want a CFX_HTTP tag written in Java?

2002-11-27 Thread Smith, Matthew P -CONT(DYN)
Me 2

Matthew P. Smith 
Web Developer, Object Oriented 
Naval Education & Training Professional 
Development & Technology Center 
(NETPDTC) 
(850)452-1001 ext. 1245 
[EMAIL PROTECTED] 


>>-Original Message-
>>From: Mike Brunt [mailto:[EMAIL PROTECTED]]
>>Sent: Wednesday, November 27, 2002 1:04 PM
>>To: CF-Talk
>>Subject: RE: Would anyone want a CFX_HTTP tag written in Java?
>>
>>Yes we are interested also, thank you.
>>
>>Kind Regards - Mike Brunt, CTO
>>Webapper
>>Blog http://www.webapper.net
>>Web site http://www.webapper.com
>>Downey CA Office
>>562.243.6255
>>AIM - webappermb
>>
>>Web Application Specialists
>>
>>
>>-Original Message-
>>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>>Sent: Wednesday, November 27, 2002 10:52 AM
>>To: CF-Talk
>>Subject: Would anyone want a CFX_HTTP tag written in Java?
>>
>>
>>So, I just wrote a CFHTTP tag in Java that actually works.  Right now, it
>>only does "get" operations, but if anyone would want to play with it, I
>>can
>>set up a website tonight where you guys can download it.
>>
>>So, anybody interested?
>>
>>
>>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



Re: CFEXECUTE and Perl Scripts

2002-11-27 Thread FlashGuy
Have you tried modifying the Perl script to handle additional arguments being passed 
at the command prompt. I had a similar problem and fixed it by doing so.

On Wed, 27 Nov 2002 14:28:19 -0500, David Adams wrote:

> I am having a hard time calling a PERL script from a CFEXECUTE tag.  It
> seems to not accept more than one argument.
>  
> For example the following code with FAIL:
>  
>  name="C:\perl\bin\perl.exe"
> arguments="c:\scripts\run_myPERLapp.pl http://www.cnn.com";
> timeout="10">
> 
>  
>  
> The following code will WORK but I cannot pass it a second or third
> argument:
>  
>  name="C:\perl\bin\perl.exe"
> arguments="c:\scripts\run_myPERLapp.pl"
> timeout="10">
> 
>  
> Any ideas?
> Dave adams
> CFUG Ottawa
> 
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com



  1   2   >