cleaning up a word file

2004-06-21 Thread Dave Lyons
i have a user that will be using a mac and copying & pasting code from word files, any good tags to make sure that code is cleaned up good?
I remember seeing something somewhere but cant remember where

ty!
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Java-CF MX 6.1 (Enterprise edition) integration

2004-06-21 Thread Stavros Tekes
Thanks Kola,
I am interested in using some jar files (tag libraries) but I will also need to call some funciton stored in class files (directly from cfscript).
My main concern is drawbacks that might be caused when trying to integrate java function in CF.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: HitBox for web traffic/marketing

2004-06-21 Thread Andrew Grosset
came across this cgi.variable the other day, not sure if this helps or not but:

ColdFusion with Proxy detection:


  
  

  
  

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: Dreamweaver seeing database

2004-06-21 Thread Karolus Smejda
No, Dreamweavers sees none of the datasources. (snippets, etc.)  What does
"IIRC" mean?
  -Original Message-
  From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]
  Sent: Monday, June 21, 2004 5:18 PM
  To: CF-Talk
  Subject: Re: Dreamweaver seeing database

  > I have loaded CFMx & DreamweaverMx on a newly formatted laptop.
  > CF Administrator sees the datasource, but Dreamweaver does not...any
  > thoughts on how to proceed or where to look for the problem? Thanks

  Does Dreamweaver see any of the datasources?  IIRC you need to open up
  a ColdFusion site and specify the RDS login for Dreamweaver to connect
  properly.

  Hatton
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: cfscript'd switch with multi-params?

2004-06-21 Thread Matt Robertson
I like that better myself.  Thx for sharing.

And I noticed you weren't using braces around the case statement. 
Nice that I can get rid of those.  Been using 'em since I learned
this.

Cheers,

-- 
--Matt Robertson--
MSB Designs, Inc.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: CF Compatible Menus/Products?

2004-06-21 Thread Andrew Golden
E-mail me off list at angolden   @    airdatanetworks.com and I will 
send you the menu system I hacked together from some freely available 
_javascript_ code. It code use a little cleanup as it was quick and 
dirty, but I haven't had time and allows lots of nested menus. I am 
currently looking for a good freely avaialable js based dhtml menu 
system to improve upon this system.

It's appearance is configurable via js(and could be modified to be 
configurable via CF), it supports lots of nesting(I don't remember the 
limit of the js I started with) and works pretty damn well for a 2 hour 
hack.

Andrew Golden
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: cfscript'd switch with multi-params?

2004-06-21 Thread Barney Boisvert
This is how I learned to format switchblocks, and I like it.  It makes it
very obvious what leads up to what, especially since a scripted switch is so
different from a CFSWITCH in how it executes.

switch (variables.switchParam) {
   case "1":
   case "2":
   case "3":
  parameters.foo[1] = parameters.foo[1] + 1;
  break;
}

Cheers,
barneyb

> -Original Message-
> From: Matt Robertson [mailto:[EMAIL PROTECTED] 
> Sent: Monday, June 21, 2004 4:15 PM
> To: CF-Talk
> Subject: re: cfscript'd switch with multi-params?
> 
> Never mind.  RTFM. 
> 
> switch (variables.SwitchParam)
> {
> case "1": case "3": case "3": {
> parameters.foo[1]=parameters.foo[1]+1;
> break; }
> } // end switch
> 
> Clunky, but works.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




re: cfscript'd switch with multi-params?

2004-06-21 Thread Matt Robertson
Never mind.  RTFM. 

switch (variables.SwitchParam)
{
case "1": case "3": case "3": {
parameters.foo[1]=parameters.foo[1]+1;
break; }
} // end switch

Clunky, but works.

-- 
--Matt Robertson--
MSB Designs, Inc.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




cfscript'd switch with multi-params?

2004-06-21 Thread Matt Robertson
I'm trying to do this in cfscript:

switch (variables.SwitchParam)
{
case "1,2,3": {
parameters.foo[1]=parameters.foo[1]+1;
break; }
} // end switch

which is similar to this:







This is a chopped-down snippet.  There's more of course.  The trouble
is that I can't get the cfscript version to take multiple parms.  I've
tried a few variations.  Is this not supported in cfscript'd switches?

-- 
--Matt Robertson--
MSB Designs, Inc.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: JRUN and ColdFusion MX

2004-06-21 Thread Dave Watts
> Is there another list for JRUN or would this be the list
> for JRUN?

There is a separate JRun list hosted by houseoffusion.com.

> Does anyone have a recommendation for a book on JRUN so 
> that I can get up and running soon as possible.

To the best of my knowledge, there are no books specifically about the
latest version of JRun. In general, writing applications for JRun doesn't
seem to be much different than writing them for any other J2EE application
server, so if that's what you're looking for you might just pick up a book
on that general topic.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Dreamweaver seeing database

2004-06-21 Thread C. Hatton Humphrey
> I have loaded CFMx & DreamweaverMx on a newly formatted laptop.  
> CF Administrator sees the datasource, but Dreamweaver does not...any 
> thoughts on how to proceed or where to look for the problem? Thanks

Does Dreamweaver see any of the datasources?  IIRC you need to open up
a ColdFusion site and specify the RDS login for Dreamweaver to connect
properly.

Hatton
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: JRUN and ColdFusion MX

2004-06-21 Thread Greg Stewart
Hi,
Why not have a look at the Cold Fusion Developer Journal (http://www.sys-con.com/coldfusion/). Over the last couple of months there were a number of articles on setting up JRun with CFMX as a J2EE application. 

Here you can find a bunch of resources I put together on the topic: http://gregs.tcias.co.uk/jrun/jrun_resources.php

Hope this helps
Greg

>All,
>
>Is there another list for JRUN or would this be the list for JRUN?
>Does anyone have a recommendation for a book on JRUN so that I can get 
>up and running soon as possible.
>
>Thanks,
>Troy
>
>-- 
>Troy Simpson
>  Applications Analyst/Programmer, OCPDBA, MCSE, SCSA
>North Carolina State University Libraries
>Campus Box 7111 | Raleigh | North Carolina
>ph.919.515.3855 | fax.919.513.3330
>E-mail: [EMAIL PROTECTED]
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: HitBox for web traffic/marketing

2004-06-21 Thread Bryan Stevenson
hehe...thanks Mattjust figured that one after looking at their code.

So it looks like they use a  combo of IP address and cookies to determine unique visitsboth have their obvious flaws.

Does anyone know of a tag/UDF/CFC/code snippet that could parse http_referrer info to determine which search engine a user came from (assuming they came from one at all) and what keywords they used (sucked from the URL params from the referrer)?

I know I could write it...but finding all the variants of search engine referrers etc. would take some leg work ;-)

Cheers

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

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com
  - Original Message - 
  From: Matt Robertson 
  To: CF-Talk 
  Sent: Monday, June 21, 2004 3:00 PM
  Subject: Re: HitBox for web traffic/marketing

  >Does anyone know how to identify unique users hitting a site via the
  same proxy
  >server?

  HitBox plants a cookie if it doesn't find one already.  Run Spybot on
  yourself and you'll probably find several.

  -- 
  --Matt Robertson--
  MSB Designs, Inc.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: HitBox for web traffic/marketing

2004-06-21 Thread Matt Robertson
>Does anyone know how to identify unique users hitting a site via the
same proxy
>server?

HitBox plants a cookie if it doesn't find one already.  Run Spybot on
yourself and you'll probably find several.

-- 
--Matt Robertson--
MSB Designs, Inc.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Dreamweaver seeing database

2004-06-21 Thread Karolus Smejda
I have loaded CFMx & DreamweaverMx on a newly formatted laptop.  CF Administrator sees the datasource, but Dreamweaver does not...any thoughts on how to proceed or where to look for the problem? Thanks
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




JRUN and ColdFusion MX

2004-06-21 Thread Troy Simpson
All,

Is there another list for JRUN or would this be the list for JRUN?
Does anyone have a recommendation for a book on JRUN so that I can get 
up and running soon as possible.

Thanks,
Troy

-- 
Troy Simpson
  Applications Analyst/Programmer, OCPDBA, MCSE, SCSA
North Carolina State University Libraries
Campus Box 7111 | Raleigh | North Carolina
ph.919.515.3855 | fax.919.513.3330
E-mail: [EMAIL PROTECTED]
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: HitBox for web traffic/marketing

2004-06-21 Thread Bryan Stevenson
Does anyone know how to identify unique users hitting a site via the same proxy server? (this relates to HitBox's claims and I'm not sure how they would do it).

TIA

Cheers

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

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com
  - Original Message - 
  From: Bryan Stevenson 
  To: CF-Talk 
  Sent: Monday, June 21, 2004 1:42 PM
  Subject: OT: HitBox for web traffic/marketing

  Has anyone used HitBox from WebSideStory?

  I've got some specific questions but don't want to bother the whole list
  with them ;-)

  Cheers

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

  -
  Macromedia Associate Partner
  www.macromedia.com
  -
  Vancouver Island ColdFusion Users Group
  Founder & Director
  www.cfug-vancouverisland.com
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: OT: HitBox for web traffic/marketing

2004-06-21 Thread Bryan Stevenson
replied offlist Jerry ;-)

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

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com
  - Original Message - 
  From: Jerry Johnson 
  To: CF-Talk 
  Sent: Monday, June 21, 2004 1:54 PM
  Subject: Re: OT: HitBox for web traffic/marketing

  I tried to respond directly, but the mail was bounced.

  I updated a site that had hitbox code in it.

  I think I may still have the code base at home.

  Is it something I could find out from the legacy code for you?

  Jerry Johnson

  >>> [EMAIL PROTECTED] 06/21/04 04:42PM >>>
  Has anyone used HitBox from WebSideStory?

  I've got some specific questions but don't want to bother the whole list
  with them ;-)

  Cheers

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

  -
  Macromedia Associate Partner
  www.macromedia.com 
  -
  Vancouver Island ColdFusion Users Group
  Founder & Director
  www.cfug-vancouverisland.com
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: OT: HitBox for web traffic/marketing

2004-06-21 Thread Jerry Johnson
I tried to respond directly, but the mail was bounced.

I updated a site that had hitbox code in it.

I think I may still have the code base at home.

Is it something I could find out from the legacy code for you?

Jerry Johnson

>>> [EMAIL PROTECTED] 06/21/04 04:42PM >>>
Has anyone used HitBox from WebSideStory?

I've got some specific questions but don't want to bother the whole list
with them ;-)

Cheers

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

-
Macromedia Associate Partner
www.macromedia.com 
-
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




OT: HitBox for web traffic/marketing

2004-06-21 Thread Bryan Stevenson
Has anyone used HitBox from WebSideStory?

I've got some specific questions but don't want to bother the whole list
with them ;-)

Cheers

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

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: ColdFusion Blogging Tool

2004-06-21 Thread Jake .
>By the way, is there a cf-based (or otherwise) blog that can be
>installed for multiple users on the same server. I know Ray's blog can
>be used for this, but then it would mean about a hundred datasources.
>Anything database-driven?

You mean with one datasource, rather than one per blog? BlogFusion does multiple bloggers per blog, but each blog is a separate datasource.

I have that on the to-do list, as several purchasers have been implementing multiple blogs on a single server. 

So tell me who you would like to see this working and I'll add it to my task notes. 

Thanks!
Jake
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Follow Up on Case Sensititive ( was Determining Directory Where Current Template Is Located)

2004-06-21 Thread Jochem van Dieten
Dave Carabetta wrote:
> On Mon, 21 Jun 2004 21:20:41 +0200, Pascal Peters <[EMAIL PROTECTED]> wrote:
>> 
>> It will only break on case-sensitive DBs like ORACLE. But even then you
>> can convert the strings to lowercase
>> 
>> WHERE LOWER(directory) = 
>> value="#Lcase(variables.CurrentDirectory)#>
>> 
>> (or whatever the lowercase function is on the DB)
> 
> Well, I'd be careful before utilizing that strategy, particularly for
> a case like Oracle. If you use a DB function around a column name,
> such as you have with LOWER(directory), then Oracle will not use an
> index to search if one exists on that column. This can have a major
> impact on query performance, depending on the size of your table.

Then define a functional index:
CREATE INDEX lower_dir_idx ON Products (LOWER(directory));

Jochem
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: FileExists() ?

2004-06-21 Thread Dave Watts
> Can I use the FileExists() function on Map network drives? I 
> have a line like below and for some reason it cannot validate 
> that the file exist at all when it actually does. 
>  
> 
> Sites\Images\AgentPictures\#Trim(AgPicture.PATH)#") is "Yes"> 
>  

Does the drive mapping actually exist for the account that's running CF? By
default, CF runs as SYSTEM, which has no access to network resources. If
you're running CF as a different user, you'll need to create the drive
mapping for that user. You might just stick to UNC paths, in that case.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: FileExists() ?

2004-06-21 Thread Marlon Moyer
Is your ColdFusion Service running under an account with network
permissions and is that drive mapped in that account?

Marlon

On Mon, 21 Jun 2004 15:00:31 -0500, Bailey, Neal <[EMAIL PROTECTED]> wrote:
> 
> Hey guys...
> 
> Can I use the FileExists() function on Map network drives? I have a line
> like below and for some reason it cannot validate that the file exist at all
> when it actually does.
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Follow Up on Case Sensititive ( was Determining Directory Where Current Template Is Located)

2004-06-21 Thread Dave Carabetta
On Mon, 21 Jun 2004 21:20:41 +0200, Pascal Peters <[EMAIL PROTECTED]> wrote:
> 
> It will only break on case-sensitive DBs like ORACLE. But even then you
> can convert the strings to lowercase
> 
> WHERE LOWER(directory) = 
> value="#Lcase(variables.CurrentDirectory)#>
> 
> (or whatever the lowercase function is on the DB)
> 

Well, I'd be careful before utilizing that strategy, particularly for
a case like Oracle. If you use a DB function around a column name,
such as you have with LOWER(directory), then Oracle will not use an
index to search if one exists on that column. This can have a major
impact on query performance, depending on the size of your table.

> 
> PS As Barney and I said: you can use "\/" as dilimiter to make it *nix
> compliant

Or you could call this UDF and not worry about it (adapted from
Christian Cantrell's blog entry at
http://www.markme.com/cantrell/archives/002195.cfm:

function getFileSeparator() {
    var fileObj = "";
    fileObj = createObject("java", "java.io.File");
    return fileObj.separator;
}

in your code:




Regards,
Dave.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




ColdFusion TechNote Notification: "ColdFusion MX 6.1: Oracle Stor ed Procedure errors"

2004-06-21 Thread Debbie Dickerson
Check out the new TechNote at:
http://www.macromedia.com/support/coldfusion/ts/documents/oracle_storedproc_
errors.htm

_errors.htm> 

Intro:
Errors may be encountered when running Oracle Stored Procedures with the
cfstoredproc tag. This TechNote describes two of those errors and how to
avoid them.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Follow Up on Case Sensititive ( was Determining Directory Where Current Template Is Located)

2004-06-21 Thread Rick Root
Bob Haroche wrote:
> 
> Even though the value of "directory" stored in the DB is
> "MyDirectory", the query works with the variable passed as
> "mydirectory". No problem, but I'm wondering if this is going to break
> if I try it some day on another DB like MS SQL.

I would probably insert the data in upper case, then compare using the 
CF UCASE() function..

ie, WHERE DIRECTORY='#UCASE(CurrentDirectory)#'

Just make sure that you don't need the case of the directory name in 
other situations.. ie when creating product links.  If you do, then 
you'd also have to store the direct name in actual case as well as upper 
case.

Alternatively, if you're going to a case-sensitve database, you CAN have 
functional indexes in some, like oracle...

WHERE upper(DIRECTORY) = '#UCASE(DIRECTORY)#'

That will actually use an index in oracle if you've specified an index 
including the upper() function.  I recently learned how to do that but 
have since forgotten and am too lazy to look at my code where I'm doing 
it :)

  - Rick
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Kevin Roche is Lame

2004-06-21 Thread Michael Dinowitz
Please move this thread off of CF-Talk to your OT list of choice. 
Thanks
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: Follow Up on Case Sensititive ( was Determining Directory Where Current Template Is Located)

2004-06-21 Thread Pascal Peters
It will only break on case-sensitive DBs like ORACLE. But even then you
can convert the strings to lowercase 

WHERE LOWER(directory) = 
value="#Lcase(variables.CurrentDirectory)#>

(or whatever the lowercase function is on the DB)

Pascal

PS As Barney and I said: you can use "\/" as dilimiter to make it *nix
compliant

> -Original Message-
> From: Bob Haroche [mailto:[EMAIL PROTECTED] 
> Sent: maandag 21 juni 2004 20:49
> To: CF-Talk
> Subject: Follow Up on Case Sensititive ( was Determining 
> Directory Where Current Template Is Located)
> 
> So this works fine to tell me the current directory:
> 
> 
> 
> 
> I find however that if my directory is called "MyDirectory", 
> the value returned for the variable "CurrentDirectory" is all 
> lowercase, ie "mydirectory".  I'm then using this variable to 
> query an Access
> database:
> 
>  Select *
>  From   Products
>  Where  directory = '#CurrentDirectory#';
> 
> Even though the value of "directory" stored in the DB is 
> "MyDirectory", the query works with the variable passed as 
> "mydirectory". No problem, but I'm wondering if this is going 
> to break if I try it some day on another DB like MS SQL.
> 
> Need I be concerned, or is there a way to get the 
> CurrentDirectory variable returned with actual upper/lower case?
> 
> Thanks again.
> 
> -
> Regards,
> Bob Haroche
> O n P o i n t  S o l u t i o n s
> www.OnPointSolutions.com
> 
> 
> 
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: Follow Up on Case Sensititive ( was Determining Directory Whe re Current Template Is Located)

2004-06-21 Thread Dave Watts
> SQL comparisons are case insensitive, unless you tell it
> otherwise.

This is true in MS Access, I think, but isn't always true. Case sensitivity
will usually depend on your database's collation settings.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: Follow Up on Case Sensititive ( was Determining Directory Where Current Template Is Located)

2004-06-21 Thread Samuel R. Neff
case sensitivity in the database depends on the DB, Oracle is case sensitive
for example.

Paths are usually case insensitive in Windows but Java is case sensitive so
there are situations where differences in case can be a problem.
Specifically, CFMX can generate a "Wrong name" error when calling a JSP from
a CF template.  More info here:
http://www.rewindlife.com/archives/000142.cfm

Best regards,

Sam

> -Original Message-
> From: Barney Boisvert [mailto:[EMAIL PROTECTED] 
> Sent: Monday, June 21, 2004 2:55 PM
> To: CF-Talk
> Subject: RE: Follow Up on Case Sensititive ( was Determining 
> Directory Where Current Template Is Located)
> 
> SQL comparisons are case insensitive, unless you tell it otherwise.
> 
> You can probably get the proper case if you go through a java.io.File
> instance, and use the canonicalPath method.  However, CF may 
> be doing this
> already, and the canonical path according to your JRE is all 
> lower case
> (since case is irrelevant on windows). 
> 
> Cheers,
> barneyb
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: Follow Up on Case Sensititive ( was Determining Directory Where Current Template Is Located)

2004-06-21 Thread Barney Boisvert
SQL comparisons are case insensitive, unless you tell it otherwise.

You can probably get the proper case if you go through a java.io.File
instance, and use the canonicalPath method.  However, CF may be doing this
already, and the canonical path according to your JRE is all lower case
(since case is irrelevant on windows). 

Cheers,
barneyb

> -Original Message-
> From: Bob Haroche [mailto:[EMAIL PROTECTED] 
> Sent: Monday, June 21, 2004 11:49 AM
> To: CF-Talk
> Subject: Follow Up on Case Sensititive ( was Determining 
> Directory Where Current Template Is Located)
> 
> So this works fine to tell me the current directory:
> 
> 
> 
> 
> I find however that if my directory is called "MyDirectory", the value
> returned for the variable "CurrentDirectory" is all lowercase, ie
> "mydirectory".  I'm then using this variable to query an Access
> database:
> 
>  Select *
>  From   Products
>  Where  directory = '#CurrentDirectory#';
> 
> Even though the value of "directory" stored in the DB is
> "MyDirectory", the query works with the variable passed as
> "mydirectory". No problem, but I'm wondering if this is going to break
> if I try it some day on another DB like MS SQL.
> 
> Need I be concerned, or is there a way to get the CurrentDirectory
> variable returned with actual upper/lower case?
> 
> Thanks again.
> 
> -
> Regards,
> Bob Haroche
> O n P o i n t  S o l u t i o n s
> www.OnPointSolutions.com
> 
> 
> 
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Follow Up on Case Sensititive ( was Determining Directory Where Current Template Is Located)

2004-06-21 Thread Bob Haroche
So this works fine to tell me the current directory:




I find however that if my directory is called "MyDirectory", the value
returned for the variable "CurrentDirectory" is all lowercase, ie
"mydirectory".  I'm then using this variable to query an Access
database:

 Select *
 From   Products
 Where  directory = '#CurrentDirectory#';

Even though the value of "directory" stored in the DB is
"MyDirectory", the query works with the variable passed as
"mydirectory". No problem, but I'm wondering if this is going to break
if I try it some day on another DB like MS SQL.

Need I be concerned, or is there a way to get the CurrentDirectory
variable returned with actual upper/lower case?

Thanks again.

-
Regards,
Bob Haroche
O n P o i n t  S o l u t i o n s
www.OnPointSolutions.com
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: Determining Directory Where Current Template Is Located

2004-06-21 Thread Pascal Peters
If you want it to work on *nix too, use "\/" as delimiter. 

> -Original Message-
> From: Bob Haroche [mailto:[EMAIL PROTECTED] 
> Sent: maandag 21 juni 2004 20:31
> To: CF-Talk
> Subject: Re: Determining Directory Where Current Template Is Located
> 
> Ah, beautiful. Thanks to both of you.
> 
> > Use GetDirectoryFromPath(GetCurrentTemplatePath()) to get 
> the current 
> > directory path and then treat the directory as a list using 
> \ as the 
> > delimiter to get the last item in the list!
> 
> I actually was doing that (almost). I was using "/" as my 
> delimiter which of course returned a single item list, which 
> didn't work.
> 
> 
> -
> Regards,
> Bob Haroche
> O n P o i n t  S o l u t i o n s
> www.OnPointSolutions.com
> 
> 
> 
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Determining Directory Where Current Template Is Located

2004-06-21 Thread Bob Haroche
Ah, beautiful. Thanks to both of you.

> Use GetDirectoryFromPath(GetCurrentTemplatePath()) to get the
> current
> directory path and then treat the directory as a list using \ as
> the
> delimiter to get the last item in the list!

I actually was doing that (almost). I was using "/" as my delimiter
which of course returned a single item list, which didn't work.

-
Regards,
Bob Haroche
O n P o i n t  S o l u t i o n s
www.OnPointSolutions.com
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: Determining Directory Where Current Template Is Located

2004-06-21 Thread Paul Vernon
Use GetDirectoryFromPath(GetCurrentTemplatePath()) to get the current
directory path and then treat the directory as a list using \ as the
delimiter to get the last item in the list!

 
Paul
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: Determining Directory Where Current Template Is Located

2004-06-21 Thread Barney Boisvert

 dir = getDirectoryFromPath(getCurrentTemplatePath());
 dir = listLast(dir, "\/");
 

The first line basically does an expandPath('.'), but relative to the
current template, rather than the root template for the request.  The second
line gets the last part of the directory, using the slash and backslash as
delimiters, so it'll work on windows or *nix.

Cheers,
barneyb

> -Original Message-
> From: Bob Haroche [mailto:[EMAIL PROTECTED] 
> Sent: Monday, June 21, 2004 11:18 AM
> To: CF-Talk
> Subject: Determining Directory Where Current Template Is Located
> 
> I've done this before but of course now I can't remember how...
> 
> I have a template located at:
> 
> f:\wwwroot\client\myDirectory\template.cfm
> 
> I need to extract just the name of the directory holding the
> template -- ie, "myDirectory".  And I need to do this in such a way
> that the CFML doesn't rely on hard coding  "f:\", "wwwroot" or
> "client" as copies of this template will reside in different locations
> on different servers.
> 
> Ideas? Thanks.
> 
> -
> Regards,
> Bob Haroche
> O n P o i n t  S o l u t i o n s
> www.OnPointSolutions.com
> 
> 
> 
> 
> 
> 
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Determining Directory Where Current Template Is Located

2004-06-21 Thread Bob Haroche
I've done this before but of course now I can't remember how...

I have a template located at:

f:\wwwroot\client\myDirectory\template.cfm

I need to extract just the name of the directory holding the
template -- ie, "myDirectory".  And I need to do this in such a way
that the CFML doesn't rely on hard coding  "f:\", "wwwroot" or
"client" as copies of this template will reside in different locations
on different servers.

Ideas? Thanks.

-
Regards,
Bob Haroche
O n P o i n t  S o l u t i o n s
www.OnPointSolutions.com
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: cfmail only works internally

2004-06-21 Thread Rick Eidson
Go into the CF Admin and add the IP address of the local Server. Then
you do not need to specify the server in the CFMAIL tag.

If you are behind a firewal running NAT then you may have a
192.168.0.* IP address this would be the Local IP address. The
External IP would be the one that the visitors see from OutSide the
firewall.

For expample I have a server with the IP 192.168.0.74 but you would go
to 65.16.30.74 and the firwall/Router would redirect the request to
the internat IP.

Rick

- Original Message -
From: Christy Carter <[EMAIL PROTECTED]>
Date: Mon, 21 Jun 2004 13:56:06 -0400
Subject: Re: cfmail only works internally
To: CF-Talk <[EMAIL PROTECTED]>

Thanks! Okay, I've done that much - although I didn't rewlize there
was a difference in local vs. external IP addresses.

Now I'm trying to figure out how to use this server in my cfmail code. :)


Christy
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: cfmail only works internally

2004-06-21 Thread Christy Carter
Thanks! Okay, I've done that much - although I didn't rewlize there was a difference in local vs. external IP addresses.

Now I'm trying to figure out how to use this server in my cfmail code. :)

Christy
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: cfmail only works internally

2004-06-21 Thread Rick Eidson
When you get IIS SMTP installed (if its not allready). Go into the
proporties and under the Access Tab click the Relay button. Then Add
the Local IP and the External IP of the server to this list and select
the Radio Button "Only the List Below"

Rick Eidson
Partner & CTO
ArcRiver Technology, LLC
ASP, PHP, PERL, Cold Fusion Hosting Kansas City
http://www.arcriver.com/

 
Kansas City Musicians
http://www.1sourceentertainment.com/

- Original Message -
From: Christy Carter <[EMAIL PROTECTED]>
Date: Mon, 21 Jun 2004 13:25:12 -0400
Subject: Re: cfmail only works internally
To: CF-Talk <[EMAIL PROTECTED]>

Well, that sounds promising, Rick...I'm off to figure out how to do
it. :)  I'm running Windows 2000 with IIS so that sounds promising.


Thanks!

Christy
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: JS Issue submit() to CF Form

2004-06-21 Thread mavinson
James,

Put 


  POST = #form.fieldnames#

  NO POST


in your action page ... and you will find that it's all good.

As my friend/pipefitter told me numerous times this weekend as we were 
wrangling gas-lines: "I'd rather answer your stupid questions now than fix 
your stupid mistakes later!" ;)

-mike



James Blaha <[EMAIL PROTECTED]>
06/21/2004 01:30 PM
Please respond to cf-talk

To: CF-Talk <[EMAIL PROTECTED]>
cc: 
Subject:JS Issue submit() to CF Form

Hello All,

I have a really stupid question.

Can anyone please send me a html template that auto submits to a cf page 
that will have the form variable show up properly on the CF template 
that recieves the POST.

Regards,
-JB

Example:



    function login()
    {
document.LoginForm.submit();
    }
      [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: cfmx and CAPTCHA

2004-06-21 Thread Doug White
Still working on it - :-)

==
Our Anti-spam solution works!!
http://www.clickdoug.com/mailfilter.cfm
For hosting solutions http://www.clickdoug.com
http://www.forta.com/cf/isp/isp.cfm?isp_id=1069
==

  - Original Message - 
  From: Burns, John D
  To: CF-Talk
  Sent: Monday, June 21, 2004 12:44 PM
  Subject: RE: cfmx and CAPTCHA

  Doug,

  Any break on your Image Manipulation CFC for fellow CF-Talkers?  Just
  figured I'd ask :-)

  John

  -Original Message-
  From: Doug Hughes [mailto:[EMAIL PROTECTED]
  Sent: Monday, June 21, 2004 11:57 AM
  To: CF-Talk
  Subject: Re: cfmx and CAPTCHA

  1) Hi Joe!

  2) I talked to Ben Forta when he came to the DC WAMMO meeting about the
  CFCs being replicated across clustered servers.  His answer, in a
  nutshell was that they didn't have the time to do it.  He also indicated
  that there was a good chance that it would be supported in the future.
  However, I know nothing about blackstone.

  Doug Hughes
  (Check out my ColdFusion Image Manipulation CFC at
  http://www.alagad.com/index.cfm/name-aic)

  On Fri, 18 Jun 2004 17:50:58 +0100, Kola Oyedeji
  <[EMAIL PROTECTED]> wrote:
  >
  > Apparently Blue dragon can but I haven't tried it ;-)
  >
  > KOla
  >
  > -Original Message-
  > From: Dave Watts [mailto:[EMAIL PROTECTED]
  > Sent: 18 June 2004 13:43
  > To: CF-Talk
  > Subject: RE: cfmx and CAPTCHA
  >
  > > why don't CFC instances go across cluster members?
  >
  > I don't really know why they don't, just that they don't. I suspect
  > that JRun has some sort of serializer to write its own session
  > variables to strings, and that this serializer doesn't know what to do

  > with CFC instances, but I really don't know for certain.
  >
  > Dave Watts, CTO, Fig Leaf Software
  > http://www.figleaf.com/
  > phone: 202-797-5496
  > fax: 202-797-5444
  >  _
  >
  >
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: cfmx and CAPTCHA

2004-06-21 Thread Burns, John D
Doug,

Any break on your Image Manipulation CFC for fellow CF-Talkers?  Just
figured I'd ask :-)

John

-Original Message-
From: Doug Hughes [mailto:[EMAIL PROTECTED] 
Sent: Monday, June 21, 2004 11:57 AM
To: CF-Talk
Subject: Re: cfmx and CAPTCHA

1) Hi Joe! 

2) I talked to Ben Forta when he came to the DC WAMMO meeting about the
CFCs being replicated across clustered servers.  His answer, in a
nutshell was that they didn't have the time to do it.  He also indicated
that there was a good chance that it would be supported in the future.
However, I know nothing about blackstone.

Doug Hughes
(Check out my ColdFusion Image Manipulation CFC at
http://www.alagad.com/index.cfm/name-aic)

On Fri, 18 Jun 2004 17:50:58 +0100, Kola Oyedeji
<[EMAIL PROTECTED]> wrote:
> 
> Apparently Blue dragon can but I haven't tried it ;-)
> 
> KOla
> 
> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]
> Sent: 18 June 2004 13:43
> To: CF-Talk
> Subject: RE: cfmx and CAPTCHA
> 
> > why don't CFC instances go across cluster members?
> 
> I don't really know why they don't, just that they don't. I suspect 
> that JRun has some sort of serializer to write its own session 
> variables to strings, and that this serializer doesn't know what to do

> with CFC instances, but I really don't know for certain.
> 
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> phone: 202-797-5496
> fax: 202-797-5444
>  _
> 
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: JS Issue submit() to CF Form

2004-06-21 Thread Dave Watts
> Can anyone please send me a html template that auto submits 
> to a cf page that will have the form variable show up 
> properly on the CF template that recieves the POST.
>
> ...
> 
> 
> METHOD=POST">

The code you have is fine, except you're missing a quote around POST.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




JS Issue submit() to CF Form

2004-06-21 Thread James Blaha
Hello All,

I have a really stupid question.

Can anyone please send me a html template that auto submits to a cf page 
that will have the form variable show up properly on the CF template 
that recieves the POST.

Regards,
-JB

Example:



    function login()
    {
document.LoginForm.submit();
    }
      [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: cfmail only works internally

2004-06-21 Thread Christy Carter
Well, that sounds promising, Rick...I'm off to figure out how to do it. :)  I'm running Windows 2000 with IIS so that sounds promising.

Thanks!
Christy
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: cfmail only works internally

2004-06-21 Thread Rick Eidson
IF you are the admin for the CF server why don;t you just use a local
SMTP server instead of the campus email server. If you are running
Windows then IIS has an SMTP server that works fine.

Rick Eidson
Partner & CTO
ArcRiver Technology, LLC
ASP, PHP, PERL, Cold Fusion Hosting Kansas City
http://www.arcriver.com/

 
Kansas City Musicians
http://www.1sourceentertainment.com/


- Original Message -
From: Christy Carter <[EMAIL PROTECTED]>
Date: Mon, 21 Jun 2004 13:09:21 -0400
Subject: Re: cfmail only works internally
To: CF-Talk <[EMAIL PROTECTED]>

Thanks, Scott.

Yep, just as you guys suggested - the majority of the emails say this.

"Error","1004","06/21/04","10:42:59",,"Failed to send the spooled mail 

file, C:\CFusion\Mail\spool\D5.cfmail. SMTP server replied ""Relaying 

is prohibited"" Moved file to C:\CFusion\Mail\undelivr\D6.cfmail."

I guess I'll have to talk to the admin.  Are there any downsides to 

enabling relaying? Just trying to anticipate if I'll have to fight for 

this. :)

Thanks!

Christy
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: ODBC Service Hangs on Query

2004-06-21 Thread hammerin hankster
It appears I *might* have found the problem.  As I inherited this database, I didn't check all the fields to see if any queries were being done from the front end lookup tab and sure enough, there was a query to a non-existant table.  Will keep troubleshooting.

Thanks
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: ODBC Service Hangs on Query

2004-06-21 Thread Mark A. Kruger - CFG
First,

make sure the query gives you what you want. Because you have no parenthasise this query is going to give you ALL
records from the tables:

tblbillingaddr, tblterm

That's because the WHERE clause reads "Give me everything WHERE"

where tblmasterclients.clientname = "tblbillingaddr.Client Name"
and tblmasterclients.clientname = tblterm.clientname
and tblterm.leaseid = tblbilling.leaseid
and tblmasterclients.acctstatus = 'A'

    OR give me everything WHERE

 tblmasterclients.acctstatus = 'ACT'

Because the second part of the where has no joins - you get it all baby! I suspect you wanted it to look more like this:

where tblmasterclients.clientname = "tblbillingaddr.Client Name"
and tblmasterclients.clientname = tblterm.clientname
and tblterm.leaseid = tblbilling.leaseid
and
    (tblmasterclients.acctstatus = 'A'
OR tblmasterclients.acctstatus = 'ACT')

-Mark

 -Original Message-
From: hammerin hankster [mailto:[EMAIL PROTECTED]
Sent: Monday, June 21, 2004 11:42 AM
To: CF-Talk
Subject: ODBC Service Hangs on Query

  I've got two problems. One is that I'm running a (bad) query that causes the ODBC service to hang during the query
attempt. I have to repeatedly try to stop the service and once it finally times out, I can restart it.

  In a nutshell, I have inherited a database full of relationships (which is good), but poorly designed. All I've done
is add a new table to the query and a new field to search on. Here's the query:

  
  SELECT DISTINCT tblmasterclients.ClientName, AliasName, AlphaPrefix, SiteID, Infinity, AuthCode, POBox, POBoxCombo,
tblmasterclients.Comments, DID,
  SVCType, tblmasterclients.AcctStatus, PreparedDate, URL, TerminationReason, TerminationDesc, billingaddr,
billingaddr2, billingstate, billingcity,
  billingzip, billingcontact, billingemail, billingphone, billingext, billingfaxnumber, billingcellnumber, leaseid

  FROM tblMasterClients, tblbillingaddr, tblterm

  where tblmasterclients.clientname = "tblbillingaddr.Client Name"
  and tblmasterclients.clientname = tblterm.clientname
  and tblterm.leaseid = tblbilling.leaseid
  and tblmasterclients.acctstatus = 'A'
  OR tblmasterclients.acctstatus = 'ACT'

  ORDER BY tblmasterclients.clientname
  

  Note: leaseid field and anything related to tblterm is new part I'm adding.

  Thanks for any help!
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: cfmail only works internally

2004-06-21 Thread Christy Carter
Thanks, Scott.

Yep, just as you guys suggested - the majority of the emails say this.

"Error","1004","06/21/04","10:42:59",,"Failed to send the spooled mail 
file, C:\CFusion\Mail\spool\D5.cfmail. SMTP server replied ""Relaying 
is prohibited"" Moved file to C:\CFusion\Mail\undelivr\D6.cfmail."

I guess I'll have to talk to the admin.  Are there any downsides to 
enabling relaying? Just trying to anticipate if I'll have to fight for 
this. :)

Thanks!
Christy
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Kevin Roche is Lame

2004-06-21 Thread Doug White
My gateway server blocks 98% of spam with a rare false positive requiting
whitelisting.
And no challenge - response either.

Currently serving 180 domains.

==
Our Anti-spam solution works!!
http://www.clickdoug.com/mailfilter.cfm
For hosting solutions http://www.clickdoug.com
http://www.forta.com/cf/isp/isp.cfm?isp_id=1069
==

  >> "On average it stops about 82% of all incoming mail"

  > You mean people don't mind not receiving 82% of their email? ;-)
  > KOla

  Not if whats incoming is pure, unadulterated kaka.  I host what I
  would consider is a general mix of ordinary folk, plus a few with
  extremely low tolerance for false positives (government types).  Three
  times since its inception someone has gotten the jitters and requested
  that I take them off the system so they can manage spam for
  themselves...

  They've never lasted more than 48 hrs.  300+ spams per day will do
  that to you.  Plus the system drops the connection (NOT a bounce msg)
  back to the sending mail server that includes a human-readable
  message, so if it is a real person then their own server's postmaster
  will let them know the score.

  I used to spend an hour a day massaging my previous, very capable
  anti-spam system.  After a week of training, now I spend zero.  And
  the thing was free.

  --
  --Matt Robertson--
  MSB Designs, Inc.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: cfmail only works internally

2004-06-21 Thread Scott Brady
Original Message:
> From: Christy Carter <[EMAIL PROTECTED]>

> Yep, just looked in my Undeliverable folder (thanks - didn't realize this was there!) and all the messages are there. Must be something to do with the mail server - I suspect I'll have to talk to the admin guys.

Have you checked the mail logs?  That should tell you why they're not getting delivered. (The mail log should tell you what the name of the undelivered mail's file name in the Undeliverable folder is)

Scott
---
Scott Brady
http://www.scottbrady.net/
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: cfmail only works internally

2004-06-21 Thread Christy Carter
I'm running version 5 right now...

Not sure about sending emails outside of CF - I don't administer the 
mail server - I'm just a client. I just put in my own email address as 
the "from" address, and put the name of the mail server in CF 
administrator.

Christy
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: cfmail only works internally

2004-06-21 Thread Christy Carter
KOla, it's definitely a valid address, as it's the one I use every day for work purposes. But I think it probably has to do with the permissions on my account...

Christy
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: cfmail only works internally

2004-06-21 Thread Christy Carter
Yep, just looked in my Undeliverable folder (thanks - didn't realize this was there!) and all the messages are there. Must be something to do with the mail server - I suspect I'll have to talk to the admin guys.

Thanks!
Christy
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: cfmail only works internally

2004-06-21 Thread Kola Oyedeji
Christy

 
Is the from address a valid from address? Have you checked the undelivr
folder and the mail logs? These will normally give you a good clue as to
what the problem is.

 
KOla

 
-Original Message-
From: Christy Carter [mailto:[EMAIL PROTECTED] 
Sent: 21 June 2004 17:37
To: CF-Talk
Subject: cfmail only works internally

 
I use cfloop and cfmail to send a mass auto-email to all the users in my
database. Or I try to anyway! :)

It goes through to all users on our local email server - i.e. anyone
with the same email extension (for example [EMAIL PROTECTED]).  But nobody
else seems to get it - nobody with a yahoo or hotmail account, and
nobody with a different ISP account...and I have no idea why.

Here's my code...any ideas?

Thanks,
Christy



server="#application.mailserver#" to="#email#" subject="#form.subject#">

Dear #getlist.Username#,

#form.body#

Sincerely,
"The Company"



  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: cfmail only works internally

2004-06-21 Thread Christy Carter
Well, I'm using a mail server here at the university.

I'm the admin of ColdFusion, but not of the mail server. Perhaps I should talk to our tech guy in the building, the one who administers the netowkr and mail server. So he would have to enable it for me?

We are moving out on our own at the end of this month, and will be running (somehow haha!) our own local network. Maybe I should wait and try to set it up myself then...

THanks for your help and ideas...

Christy
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: cfmail only works internally

2004-06-21 Thread Rick Root
Christy Carter wrote:

> It goes through to all users on our local email server - i.e. anyone 
> with the same email extension (for example [EMAIL PROTECTED]).  But nobody 
> else seems to get it - nobody with a yahoo or hotmail account, and 
> nobody with a different ISP account...and I have no idea why.

I suspect that it has nothing to do with CFMAIL.

Have you looked in the mail logs for cold fusion?  Are the mails being 
put in the undeliverable mail folder (ie, C:\CFUSIONMX\mail\undelivr)?

Is the from address a local domain?  If not, your mail server may be 
rejecting the messages as relay.

  - Rick
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: cfmail only works internally

2004-06-21 Thread Jeff Garza
Make sure that your mail admin has enabled relaying for your CF server.  Otherwise, it will only allow local addresses.  What mail server are you using?

Cheers,

Jeff Garza
  - Original Message - 
  From: Christy Carter 
  To: CF-Talk 
  Sent: Monday, June 21, 2004 9:37 AM
  Subject: cfmail only works internally

  I use cfloop and cfmail to send a mass auto-email to all the users in my database. Or I try to anyway! :)

  It goes through to all users on our local email server - i.e. anyone with the same email extension (for example [EMAIL PROTECTED]).  But nobody else seems to get it - nobody with a yahoo or hotmail account, and nobody with a different ISP account...and I have no idea why.

  Here's my code...any ideas?

  Thanks,
  Christy

  
  

  Dear #getlist.Username#,

  #form.body#

  Sincerely,
  "The Company"

  
  
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: cfmail only works internally

2004-06-21 Thread Christine Lawson
What version of CF are you running and can you send email to these addresses
using this mail server outside of ColdFusion?

Christine

  _  

From: Christy Carter [mailto:[EMAIL PROTECTED] 
Sent: Monday, June 21, 2004 12:37 PM
To: CF-Talk
Subject: cfmail only works internally

I use cfloop and cfmail to send a mass auto-email to all the users in my
database. Or I try to anyway! :)

It goes through to all users on our local email server - i.e. anyone with
the same email extension (for example [EMAIL PROTECTED]).  But nobody else
seems to get it - nobody with a yahoo or hotmail account, and nobody with a
different ISP account...and I have no idea why.

Here's my code...any ideas?

Thanks,
Christy



server="#application.mailserver#" to="#email#" subject="#form.subject#">

Dear #getlist.Username#,

#form.body#

Sincerely,
"The Company"




  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: CFPOP streamlining

2004-06-21 Thread Paul Vernon
You could always use CFX_POP3 to fix the utf-7 issue...

 
http://www.web-architect.co.uk/downloads.cfm

 
Paul
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




ODBC Service Hangs on Query

2004-06-21 Thread hammerin hankster
I've got two problems. One is that I'm running a (bad) query that causes the ODBC service to hang during the query attempt. I have to repeatedly try to stop the service and once it finally times out, I can restart it. 

In a nutshell, I have inherited a database full of relationships (which is good), but poorly designed. All I've done is add a new table to the query and a new field to search on. Here's the query:


SELECT DISTINCT tblmasterclients.ClientName, AliasName, AlphaPrefix, SiteID, Infinity, AuthCode, POBox, POBoxCombo, tblmasterclients.Comments, DID,
SVCType, tblmasterclients.AcctStatus, PreparedDate, URL, TerminationReason, TerminationDesc, billingaddr, billingaddr2, billingstate, billingcity,
billingzip, billingcontact, billingemail, billingphone, billingext, billingfaxnumber, billingcellnumber, leaseid

FROM tblMasterClients, tblbillingaddr, tblterm

where tblmasterclients.clientname = "tblbillingaddr.Client Name"
and tblmasterclients.clientname = tblterm.clientname
and tblterm.leaseid = tblbilling.leaseid
and tblmasterclients.acctstatus = 'A'
OR tblmasterclients.acctstatus = 'ACT'

ORDER BY tblmasterclients.clientname


Note: leaseid field and anything related to tblterm is new part I'm adding.

Thanks for any help!
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




cfmail only works internally

2004-06-21 Thread Christy Carter
I use cfloop and cfmail to send a mass auto-email to all the users in my database. Or I try to anyway! :)

It goes through to all users on our local email server - i.e. anyone with the same email extension (for example [EMAIL PROTECTED]).  But nobody else seems to get it - nobody with a yahoo or hotmail account, and nobody with a different ISP account...and I have no idea why.

Here's my code...any ideas?

Thanks,
Christy




Dear #getlist.Username#,

#form.body#

Sincerely,
"The Company"



 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: CF Compatible Menus/Products?

2004-06-21 Thread Thomas Chiverton
On Monday 21 Jun 2004 16:09 pm, Kenneth Wilson wrote:
> Project samples can be downloaded at
> http://more.ericmeyeroncss.com/projects/06/ but the book is well worth
> the cost. Extemely lightweight with just a stylesheet and unordered
> lists controlling it.

I belive alistapart.com show you how to do that sort of thing for free...

-- 
Tom Chiverton 
Advanced ColdFusion Programmer

Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: CFPOP streamlining

2004-06-21 Thread Cedric Villat
One thing that I came upon when using CFPOP and deciding which method to
use, is that if you are using CFMX there is a nasty bug that deals with
encoding. Check out
http://www.mail-archive.com/[EMAIL PROTECTED]/msg149313.html for
some information. I know Raymond Camden also wrote about this bug on his
blog. See it here:
http://www.camdenfamily.com/morpheus/blog/index.cfm?mode=entry&entry=437EFED9-B15B-8957-860C45AFE6E30A4D .

Basically, if an email comes in with he unsupported encoding type, anytime
you try to do a GETALL with CFPOP, it will break. The only way to recover is
to delete the offending email some other way. Due to this bug, all of our
CFPOP apps now describe your method of retrieving the headers, and then
downloading each piece of email one at a time.

Cedric Villat
http://www.cornfeed.com
Creators of CFTicket - A customer support, trouble ticket application

> Subject: CFPOP streamlining
> From: "James Smith" <[EMAIL PROTECTED]>
> Date: Mon, 21 Jun 2004 11:06:12 +0100
> Thread:
http://www.houseoffusion.com/cf_lists/index.cfm/method=messages&threadid=33372&forumid=4#167433
>
> I have a template that retrieves mail and processes it to extract order
> information using cfpop.  At any one time it can be retrieving up to 300
> emails of which around 200 will be orders, the rest will be a mixture of
> junk and correspondence aimed at the human who reads the account.
>
> I am currently doing a cfpop to retrieve the headers only, then looping
over
> these doing another cfpop for each to get the message body resulting in
200+
> pop connections in total.
>
> Would it be better to just do one connection, retrieve everything, and
> simply ignore to 100 message bodies I am not interested in?
>
> --
> James Smith
> [EMAIL PROTECTED]
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.707 / Virus Database: 463 - Release Date: 15/06/2004
>
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Kevin Roche is Lame

2004-06-21 Thread Matt Robertson
>> "On average it stops about 82% of all incoming mail"

 
> You mean people don't mind not receiving 82% of their email? ;-)
> KOla

Not if whats incoming is pure, unadulterated kaka.  I host what I
would consider is a general mix of ordinary folk, plus a few with
extremely low tolerance for false positives (government types).  Three
times since its inception someone has gotten the jitters and requested
that I take them off the system so they can manage spam for
themselves...

They've never lasted more than 48 hrs.  300+ spams per day will do
that to you.  Plus the system drops the connection (NOT a bounce msg)
back to the sending mail server that includes a human-readable
message, so if it is a real person then their own server's postmaster
will let them know the score.

I used to spend an hour a day massaging my previous, very capable
anti-spam system.  After a week of training, now I spend zero.  And
the thing was free.

--
--Matt Robertson--
MSB Designs, Inc.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: Kevin Roche is Lame

2004-06-21 Thread Kola Oyedeji
"On average it stops about 82% of all incoming mail"

 
You mean people don't mind not receiving 82% of their email? ;-)

 
KOla

-Original Message-
From: Matt Robertson [mailto:[EMAIL PROTECTED] 
Sent: 21 June 2004 16:42
To: CF-Talk
Subject: Re: Kevin Roche is Lame

 
If you have your own mail server, try ASSP
(http://assp.sourceforge.net).  Its unbeatable, but like all Bayesian
systems you have to train it for a week or so.  Been running it for
about 4 months.   and I have zero complaints from customers.  YMMV.

-- 
--Matt Robertson--
MSB Designs, Inc.
  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




CFCHARTSERIES cannot do different colors for each bar in bargraph

2004-06-21 Thread Dustin Snell [Unisyn Software, LLC]
Hi all, 

Trying to switch my charts finally from the old Allaire Java applets to the
new CFCHART ones.  I am using CFMX 6.1 with CFCHART and CFCHARTSERIES to
show total sales for each sales rep for the current day. It is a Bar graph
style outputting flash content and specifying the query parameter in the
cfchartseries tag.

Problem is, I want each bar on the bargraph to be a different color, but it
seems to ignore my barcolor parameter even thought it is valud a fieldname
in the database. Any suggestions would be appreciated.

Here is my code:
  
SELECT smuser.id, 
smuser.id, 
smuser.name,
smuser.barcolor,
sum(orders.Total) As SumSales
FROM smuser,orders 
where smuser.id = Orders.salesrepid
and (orders.odate >= #CreateODBCDateTime(start_date)# 
  and orders.odate <= #CreateODBCDateTime(end_date)#)
  AND completed=1
group by smuser.id,smuser.name,smuser.barcolor



	
#Replace(DollarFormat(GetTotals.SumSales[i]), '$','')#>





xaxistitle="Sales Rep" 
yaxistitle="Dollar Amount"
show3d="yes"
labelFormat="currency"
foregroundColor="##33"
chartheight="250"
chartwidth="480"
backgroundcolor="#color_table_background2#">
	
	query="Gettotals"
	itemcolumn="name" 
	valuecolumn="SumSales">
	
 
  





#graph_data#

Thanks for any help you can provide,

Dustin Snell
Unisyn Software, LLC
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: cfmx and CAPTCHA

2004-06-21 Thread Doug Hughes
1) Hi Joe! 

2) I talked to Ben Forta when he came to the DC WAMMO meeting about
the CFCs being replicated across clustered servers.  His answer, in a
nutshell was that they didn't have the time to do it.  He also
indicated that there was a good chance that it would be supported in
the future.  However, I know nothing about blackstone.

Doug Hughes
(Check out my ColdFusion Image Manipulation CFC at
http://www.alagad.com/index.cfm/name-aic)

On Fri, 18 Jun 2004 17:50:58 +0100, Kola Oyedeji
<[EMAIL PROTECTED]> wrote:
> 
> Apparently Blue dragon can but I haven't tried it ;-)
> 
> KOla
> 
> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]
> Sent: 18 June 2004 13:43
> To: CF-Talk
> Subject: RE: cfmx and CAPTCHA
> 
> > why don't CFC instances go across cluster members?
> 
> I don't really know why they don't, just that they don't. I suspect that
> JRun has some sort of serializer to write its own session variables to
> strings, and that this serializer doesn't know what to do with CFC
> instances, but I really don't know for certain.
> 
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> phone: 202-797-5496
> fax: 202-797-5444
>  _
> 
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Kevin Roche is Lame

2004-06-21 Thread Matt Robertson
If you have your own mail server, try ASSP
(http://assp.sourceforge.net).  Its unbeatable, but like all Bayesian
systems you have to train it for a week or so.  Been running it for
about 4 months.  On average it stops about 82% of all incoming mail
and I have zero complaints from customers.  YMMV.

-- 
--Matt Robertson--
MSB Designs, Inc.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: CF Compatible Menus/Products?

2004-06-21 Thread Kenneth Wilson
Something to bookmark for when you have the time...

If you like CSS and don't need to support pre-5.0 browsers, you might
want to take a look at the CSS menu code from Eric Meyers latest book.
Project samples can be downloaded at
http://more.ericmeyeroncss.com/projects/06/ but the book is well worth
the cost. Extemely lightweight with just a stylesheet and unordered
lists controlling it.

Ken

-Original Message-
From: Nick Baker [mailto:[EMAIL PROTECTED] 
Sent: Monday, June 21, 2004 10:51 AM
To: CF-Talk
Subject: CF Compatible Menus/Products?

I am looking for a nice expandable/retractable menu. Have looked at
several DHTML/_javascript_ offerings.
Prefer CF 5.0 compatibility for some backwards projects, but will use 6
if necessary.

Main concerns are:

1. CF compatible
2. Minimum time ;-)

Any recommendations?

One I ran across was Sothink.com. These folks have a very interesting
offering that includes

DHTMLMenu, Flash Editor. The marketing words sound great, but don't they
always? Anyone have experience using CF with Sothink's products.

Thanks,

Nick
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




OT: Kevin Roche is Lame

2004-06-21 Thread Scott Brady
I've found that a combination of the Bayesian filter on Thundermail and the use of K9 (http://www.keir.net/k9.html) eliminates me having to see virtually all spam.  It will require some training, of course, but it eliminates the need to use a challenge-response system.

(Almost every message that happens to get through K9 will then get caught by the junk mail filter on Thundermail)

Scott

---
Scott Brady
http://www.scottbrady.net/
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: CF and Eclipse

2004-06-21 Thread John Beynon
Thanks Ian,

All setup now,

Jb.

-Original Message-
From: Ian Sheridan [mailto:[EMAIL PROTECTED] 
Sent: 21 June 2004 13:57
To: CF-Talk
Subject: Re: CF and Eclipse

DL the FTP and WEBDAV plugin. it's a little tricky but basically you  
deploy with FTP.

http://download.eclipse.org/downloads/drops/S-3.0RC2-200406111814/ 
index.php

scroll down you should see what you need.

I manage using the FTP deployment with import and export.

Hope that helps

Ian

On Jun 18, 2004, at 10:52 AM, John Beynon wrote:

> I've just put the new version on and the latest cfeclipse...i can see  
> me
> switching to this as my preferred IDe very quickly...just need to  
> figure out
> how to ftp from within eclipse - anyone?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: CF Compatible Menus/Products?

2004-06-21 Thread Philip Arnold
On Mon, 21 Jun 2004 09:50:32 -0500, Nick Baker wrote:
> 
> I am looking for a nice expandable/retractable menu. Have looked at several
> DHTML/_javascript_ offerings.
> Prefer CF 5.0 compatibility for some backwards projects, but will use 6 if
> necessary.
> 
> Main concerns are:
> 
> 1. CF compatible
> 2. Minimum time ;-)
> 
> Any recommendations?
> 
> One I ran across was Sothink.com. These folks have a very interesting
> offering that includes
> 
> DHTMLMenu, Flash Editor. The marketing words sound great, but don't they
> always? Anyone have experience using CF with Sothink's products.

We've used AllWebMenus with some success, although the initial setup
was a little bit of a pain as I had messed up some of the JS settings
(all my fault, not the product )
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: CF Compatible Menus/Products?

2004-06-21 Thread Dave Carabetta
On Mon, 21 Jun 2004 09:50:32 -0500, Nick Baker <[EMAIL PROTECTED]> wrote:
> 
> I am looking for a nice expandable/retractable menu. Have looked at several
> DHTML/_javascript_ offerings.
> Prefer CF 5.0 compatibility for some backwards projects, but will use 6 if
> necessary.
> 
> Main concerns are:
> 
> 1. CF compatible
> 2. Minimum time ;-)
> 
> Any recommendations?

Give the Milonic menu a good look. Cheap, powerful, super fast, and
fully compatible with ColdFusion (for generating the menu options) and
all major browsers (for display). www.milonic.com

Regards,
Dave.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: ColdFusion Blogging Tool

2004-06-21 Thread Roger Benningfield
> This feed actually works in most aggregators I 
> tried (about 10-12 so far).

Jake,

Yep, as they should. Most aggregator authors try to parse anything you throw at them. The number of feeds out there with invalid s is staggering, so they're conditioned to simply ignore a bad date and carry on. But that can be annoying for readers... aggregators that stick to the spec (like Newzcrawler) will render all your entries with the date they were retrieved, making date sorting impossible.

> It's a fun non-standardized world, that RSS. 

It's not that bad. Just pay heed to the spec (email address in , RFC822 in ) and run everything through the feed validator to see where you're at. It's relatively painless.

The only murky areas are related to escaping in s and s, and the inexplicable problem some folks have with figuring out how to use the isPermaLink attribute on the  element.

--
Roger Benningfield
work: http://journurl.com/
blog: http://admin.support.journurl.com/
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




CF Compatible Menus/Products?

2004-06-21 Thread Nick Baker
I am looking for a nice expandable/retractable menu. Have looked at several 
DHTML/_javascript_ offerings.
Prefer CF 5.0 compatibility for some backwards projects, but will use 6 if 
necessary.

Main concerns are:

1. CF compatible
2. Minimum time ;-)

Any recommendations?

One I ran across was Sothink.com. These folks have a very interesting 
offering that includes

DHTMLMenu, Flash Editor. The marketing words sound great, but don't they 
always? Anyone have experience using CF with Sothink's products.

Thanks,

Nick
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: cflocation fails

2004-06-21 Thread Kevin Roche
The problem has been reported on two different machines.

Although there is conditional logic the required location including URL
variables is definitely shown in the address box.

I am begining to think there is a response time problem on the server.

Kevin
  -Original Message-
  From: James Smith [mailto:[EMAIL PROTECTED]
  Sent: 21 June 2004 13:24
  To: CF-Talk
  Subject: RE: cflocation fails

  I wouldn't have thought so because the correct URL is in the browser
window,
  if conditional logic was stopping the cflocation being executed then there
  would be no way for the browser to have the URL.  I would suspect the
  browser is not handling the relocation properly, are you able to test it
  from a different machine?

  > is it possible that there is conditional logic around the
  > relocation and the conditional test fails the first time that
  > page loads?

  > > Hi,
  > >
  > > I have a strange situation which I can't track down.
  > >
  > > I have an application that I have been using successfully for some
  > > time running on CFMX 6.1
  > >
  > > Recently the application has been giving problems because the
  > >  tags are not working sometimes.
  > >
  > > The characteristics are that the browser shows the
  > redirected URL at
  > > the address bar and the content (Usually nothing or debug info) for
  > > the page that issues the cflocation.
  > >
  > > If you position the cursor in the address bar and hit enter you do
  > > then go to the correct page.
  > >
  > > Anyone seen this before?
  > >
  > > Anyone know what could possibly cause it?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Kevin Roche is Lame

2004-06-21 Thread Adrocknaphobia
lol. you do exist. no problems at all just worried about the same thing you are.

-Adam

- Original Message -
From: Kevin Roche <[EMAIL PROTECTED]>
Date: Mon, 21 Jun 2004 08:32:40 +0100
Subject: RE: Kevin Roche is Lame
To: CF-Talk <[EMAIL PROTECTED]>

Apologies, if they annoyed you.  I am getting way too much SPAM now and was
spending hours throwing it away.

  -Original Message-
  From: Philip Arnold [mailto:[EMAIL PROTECTED]
  Sent: 19 June 2004 15:31
  To: CF-Talk
  Subject: Re: Kevin Roche is Lame

  On Fri, 18 Jun 2004 16:25:53 -0400, Adrocknaphobia wrote:
  >
  > Is anyone else getting Spam Interceptor emails from this guy?
  >
  > (This message will probably trigger another one.)

  I got one and promptly ignored it

  I've seen cases of these things as harvesters, so I'm not trusting any
  of them anymore
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Datasource creation errors

2004-06-21 Thread Kathleen Cashel
> -now it will work ;-)

Unfortunately not. Also there is no provision for testing Access DSNs in Windows ODBC (like there is for SQL). Perhaps I am missing something here?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Unresponsive requests - very strange

2004-06-21 Thread Jochem van Dieten
Earl, George wrote:
> 
> Any thoughts on what might be causing this problem ONLY on the production
> server and ONLY with dates starting on May 1? Where would you look next to
> try to find the source of this problem?

Enable query tracing (ODBC Control Panel) and get a log of the 
actual query being send to the database. Then scrutinize that for 
issues in the date pattern: 04/30/04 vs 05/01/04 vs 04/05/01 etc.

Jochem
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: ColdFusion Blogging Tool

2004-06-21 Thread Bryan F. Hogan
"Don't let yourself get carried away with that." +1 :-)
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Unresponsive requests - very strange

2004-06-21 Thread G
Employing Ockham's Razor here..

Are you sure that the app on production is submitting the right date when the user selects "May 1st, 2004" ??

Brian 
  From: Earl, George 
  To: CF-Talk 
  Sent: Monday, June 21, 2004 8:31 AM
  Subject: Unresponsive requests - very strange

  I have a very strange and frustrating problem - 

  We are running CF 5.0 on Windows 2000, Oracle 8i, and the Merant ODBC
  drivers that ship with CF (we have had problems with the Oracle native
  drivers).

  We have a reporting application that submits requests with 5 queries to
  Oracle and then massages the answer sets into a report before sending it
  back to the browser.

  There are 7 x 4 x 4 x 3 different ways the reports can be requested (by
  choosing different combinations of radio buttons and dates from dropdown
  boxes), and all work fine except for one report which will time out every
  single time ONLY on our production web server and ONLY when using week and
  month ending dates starting this past May . . .

  I can run the problem report from our production web server, accessing
  production data, with any dates after April 30 and it will time out every
  time and write an unresponsive request message in the server.log file. Dates
  before May 1 work fine.

  I can run the problem report from our development and integration servers,
  also accessing production data, with any dates after April 30 (and before
  May 1) and it works fine every time!

  So it appears that the problem is not with the data.

  I have compared cfm and date files between the different environments using
  WinMerge and everything appears to be identical except for the expected
  differences in references to data sources in the different environments . .
  . and when I switch these differences to point to production data, the
  reports work.

  So it appears it is not something in the code.

  Any thoughts on what might be causing this problem ONLY on the production
  server and ONLY with dates starting on May 1? Where would you look next to
  try to find the source of this problem?

  Thanks!

  George
  [EMAIL PROTECTED]
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: ColdFusion Blogging Tool

2004-06-21 Thread George Abraham
By the way, is there a cf-based (or otherwise) blog that can be
installed for multiple users on the same server. I know Ray's blog can
be used for this, but then it would mean about a hundred datasources.
Anything database-driven?

Thanks,
George
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Unresponsive requests - very strange

2004-06-21 Thread Earl, George
I have a very strange and frustrating problem - 

We are running CF 5.0 on Windows 2000, Oracle 8i, and the Merant ODBC
drivers that ship with CF (we have had problems with the Oracle native
drivers).

We have a reporting application that submits requests with 5 queries to
Oracle and then massages the answer sets into a report before sending it
back to the browser.

There are 7 x 4 x 4 x 3 different ways the reports can be requested (by
choosing different combinations of radio buttons and dates from dropdown
boxes), and all work fine except for one report which will time out every
single time ONLY on our production web server and ONLY when using week and
month ending dates starting this past May . . .

I can run the problem report from our production web server, accessing
production data, with any dates after April 30 and it will time out every
time and write an unresponsive request message in the server.log file. Dates
before May 1 work fine.

I can run the problem report from our development and integration servers,
also accessing production data, with any dates after April 30 (and before
May 1) and it works fine every time!

So it appears that the problem is not with the data.

I have compared cfm and date files between the different environments using
WinMerge and everything appears to be identical except for the expected
differences in references to data sources in the different environments . .
. and when I switch these differences to point to production data, the
reports work.

So it appears it is not something in the code.

Any thoughts on what might be causing this problem ONLY on the production
server and ONLY with dates starting on May 1? Where would you look next to
try to find the source of this problem?

Thanks!

George
[EMAIL PROTECTED]
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: CF and Eclipse

2004-06-21 Thread Ian Sheridan
DL the FTP and WEBDAV plugin. it's a little tricky but basically you  
deploy with FTP.

http://download.eclipse.org/downloads/drops/S-3.0RC2-200406111814/ 
index.php

scroll down you should see what you need.

I manage using the FTP deployment with import and export.

Hope that helps

Ian

On Jun 18, 2004, at 10:52 AM, John Beynon wrote:

> I've just put the new version on and the latest cfeclipse...i can see  
> me
> switching to this as my preferred IDe very quickly...just need to  
> figure out
> how to ftp from within eclipse - anyone?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: ColdFusion Blogging Tool

2004-06-21 Thread Jake .
> Ironically, the support forum for this CF blogger is written in ASP?
> http://www.countersinkdg.com/forum/default.asp

Indeed. It was some excellent free code. The only ASP I've run before, but very very easy to setup. It taught me a few things for how simply code should be to install.

I threw the forums on in a hurry after a quick search for CF code revealed (or so it seemed) that CF forums were either costly or low on features. 

I'm sure this isn't actually true, but I didn't have time to wait at the time. Can someone prove me wrong by posting a few links?

> On the flip side, I can understand the way you feel when advertising a 
> product and the list responds by pointing out alternatives that are 
> free Did you do much market research before developing this 
> product? Did you perceive a market need or simply decide to sell 
> something you had already written?

No worries. Didn't really mean for this thread to come across as advertising. 

The long history short is that I created a CF blogging tool of my own more than a year ago (just a few rough features and pages). After realizing I liked blogging, but needed a real tool, I looked around at all of the CF tools I could find (again, a year ago, so there weren't that many). 

I liked some features from some, but not from others. I liked some of the features from Moveable Type and some of the other non-CF versions. So I started coding. I use the tool myself on the three blogs I run, and it works quite effectively, which was the original goal #1. At some point a year ago, I thought that others might get use out of the code I had created.

> I am in the process of developing some software for intended developer 
> purchase also. It is fascinating and a learning experience seeing 
> people do a similar thing. I wish you all the best in your endeavours.

Yeah, absolutely agree. I've downloaded a number of CF apps of varying purpose lately just to see how things work and what their install process is like. As mentioned about the WebWiz forums, the install process was amazing, and prompted me to reduce the BlogFusion setup steps to nearly none. 

I really hope the next version of CF Server does a better, more documented job of handling service.Factory stuff so that users have to do very little, if any setup when installing new apps!

Jake
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: Load testing

2004-06-21 Thread Yves Arsenault
And thanks Kelly...

 
I'll certainly read the article.

 
Yves

  _  

From: Kelly Tetterton [mailto:[EMAIL PROTECTED] 
Sent: June 21, 2004 9:18 AM
To: CF-Talk
Subject: RE: Load testing

I won't beat a dead horse here, other than to agree with the previous
posters: look at the database and caching strategies first.

We documented our recent load testing experience in an April CFDJ article;
you can read it here:
http://www.duoconsulting.com/index.cfm/fuseaction/news.detail/object_id/5ea7
ed33-8896-49d1-9945-e6e216dc85ed/TheArtScienceofLoadTestingonaBudget.cfm

-- 
Kelly Tetterton
Technical Lead | Duo Consulting
Internet Strategy, Design and Development 

312.529.3000| main 
312.529.3014 | direct
312.529.3001| fax
www.duoconsulting.com

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Sunday, June 20, 2004 7:45 PM
To: CF-Talk
Subject: RE: Load testing

> I was wondering what was the general pratice for testing 
> your app is

In my experience, the general practice is to release your application, and
it either supports the number of users it needs to, or it doesn't. Of
course, that's not the best practice, but it's certainly the most common.

> Is there any way of similating a certain number of hits 
> per minute?

Yes, there are plenty of load testing tools. Some are free, such as my
favorite free load tester, OpenSTA (http://www.opensta.org/). Some are
incredibly expensive, such as Segue SilkPerformer, which can run up to $50K.
The commercial tools generally provide richer feature sets, and if you do
enough load testing, they're worth the money in the amount of time they save
you.

> I'd like to test some sections of some apps and see what 
> kind of performance my code is getting (or not getting).
>  
> Does anyone have any suggestions as to how this test could 
> be done?

Unfortunately, load testing isn't a trivial task. In general, though, to
oversimplify things a bit, you write a test script which travels through
your application, then you give that script to your load test tool and let
it run the script with some predetermined number of virtual users. As it
runs the script, it measures response time and throughput, and stores those
measurements. After the test has been run, you can generate data about which
pages took longest on average, and those are your bottlenecks.

You can then examine those pages specifically, and use GetTickCount within
those pages to find out which section of the page is causing trouble.

This kind of load test is called a performance test. You can also use load
test tools to perform capacity planning tests.

> I liked the example on the houseoffusion.com home page where 
> the question was asked, "Is CFLOOP really needed?"... little 
> tricks like that, I'm sure are almost trivial but running 
> sloppy queries/loopsetc... Just want to tighten it up.

I'm sorry, but that kind of question is like asking how many angels can
dance on the head of a pin. You won't find your performance problems can be
solved by "little tricks" like that. I've analyzed literally hundreds of CF
applications, and their problems were never caused by those sorts of things.
Instead, the problems almost always come down to poor database schema
design, poorly written SQL, inadequate caching, or some combination of
those.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444 
  _ 
  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: Load testing

2004-06-21 Thread Yves Arsenault
Thanks to all who replied...

 
Thanks for the info Dave.

 
:-)

 
Yves

  _  

From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: June 20, 2004 9:45 PM
To: CF-Talk
Subject: RE: Load testing

> I was wondering what was the general pratice for testing 
> your app is

In my experience, the general practice is to release your application, and
it either supports the number of users it needs to, or it doesn't. Of
course, that's not the best practice, but it's certainly the most common.

> Is there any way of similating a certain number of hits 
> per minute?

Yes, there are plenty of load testing tools. Some are free, such as my
favorite free load tester, OpenSTA (http://www.opensta.org/). Some are
incredibly expensive, such as Segue SilkPerformer, which can run up to $50K.
The commercial tools generally provide richer feature sets, and if you do
enough load testing, they're worth the money in the amount of time they save
you.

> I'd like to test some sections of some apps and see what 
> kind of performance my code is getting (or not getting).
>  
> Does anyone have any suggestions as to how this test could 
> be done?

Unfortunately, load testing isn't a trivial task. In general, though, to
oversimplify things a bit, you write a test script which travels through
your application, then you give that script to your load test tool and let
it run the script with some predetermined number of virtual users. As it
runs the script, it measures response time and throughput, and stores those
measurements. After the test has been run, you can generate data about which
pages took longest on average, and those are your bottlenecks.

You can then examine those pages specifically, and use GetTickCount within
those pages to find out which section of the page is causing trouble.

This kind of load test is called a performance test. You can also use load
test tools to perform capacity planning tests.

> I liked the example on the houseoffusion.com home page where 
> the question was asked, "Is CFLOOP really needed?"... little 
> tricks like that, I'm sure are almost trivial but running 
> sloppy queries/loopsetc... Just want to tighten it up.

I'm sorry, but that kind of question is like asking how many angels can
dance on the head of a pin. You won't find your performance problems can be
solved by "little tricks" like that. I've analyzed literally hundreds of CF
applications, and their problems were never caused by those sorts of things.
Instead, the problems almost always come down to poor database schema
design, poorly written SQL, inadequate caching, or some combination of
those.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444 
  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: cflocation fails

2004-06-21 Thread James Smith
I wouldn't have thought so because the correct URL is in the browser window,
if conditional logic was stopping the cflocation being executed then there
would be no way for the browser to have the URL.  I would suspect the
browser is not handling the relocation properly, are you able to test it
from a different machine?

> is it possible that there is conditional logic around the 
> relocation and the conditional test fails the first time that 
> page loads?

> > Hi,
> >
> > I have a strange situation which I can't track down.
> >
> > I have an application that I have been using successfully for some 
> > time running on CFMX 6.1
> >
> > Recently the application has been giving problems because the 
> >  tags are not working sometimes.
> >
> > The characteristics are that the browser shows the 
> redirected URL at 
> > the address bar and the content (Usually nothing or debug info) for 
> > the page that issues the cflocation.
> >
> > If you position the cursor in the address bar and hit enter you do 
> > then go to the correct page.
> >
> > Anyone seen this before?
> >
> > Anyone know what could possibly cause it?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: cflocation fails

2004-06-21 Thread Simon Horwith
is it possible that there is conditional logic around the relocation and 
the conditional test fails the first time that page loads?

~Simon

Simon Horwith
CTO, eTRILOGY ltd.
Member of Team Macromedia
Macromedia Certified Master Instructor
http://www.cfstandards.org

Kevin Roche wrote:

> Hi,
>
> I have a strange situation which I can't track down.
>
> I have an application that I have been using successfully for some time
> running on CFMX 6.1
>
> Recently the application has been giving problems because the 
> tags are not working sometimes.
>
> The characteristics are that the browser shows the redirected URL at the
> address bar and the content (Usually nothing or debug info) for the page
> that issues the cflocation.
>
> If you position the cursor in the address bar and hit enter you do then go
> to the correct page.
>
> Anyone seen this before?
>
> Anyone know what could possibly cause it?
>
> Kevin Roche
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: Load testing

2004-06-21 Thread Kelly Tetterton
I won't beat a dead horse here, other than to agree with the previous posters: look at the database and caching strategies first.

 
We documented our recent load testing experience in an April CFDJ article; you can read it here: http://www.duoconsulting.com/index.cfm/fuseaction/news.detail/object_id/5ea7ed33-8896-49d1-9945-e6e216dc85ed/TheArtScienceofLoadTestingonaBudget.cfm

 
-- 
Kelly Tetterton
Technical Lead | Duo Consulting
Internet Strategy, Design and Development 

312.529.3000| main 
312.529.3014 | direct
312.529.3001| fax
www.duoconsulting.com

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Sunday, June 20, 2004 7:45 PM
To: CF-Talk
Subject: RE: Load testing

> I was wondering what was the general pratice for testing 
> your app is

In my experience, the general practice is to release your application, and
it either supports the number of users it needs to, or it doesn't. Of
course, that's not the best practice, but it's certainly the most common.

> Is there any way of similating a certain number of hits 
> per minute?

Yes, there are plenty of load testing tools. Some are free, such as my
favorite free load tester, OpenSTA (http://www.opensta.org/). Some are
incredibly expensive, such as Segue SilkPerformer, which can run up to $50K.
The commercial tools generally provide richer feature sets, and if you do
enough load testing, they're worth the money in the amount of time they save
you.

> I'd like to test some sections of some apps and see what 
> kind of performance my code is getting (or not getting).
>  
> Does anyone have any suggestions as to how this test could 
> be done?

Unfortunately, load testing isn't a trivial task. In general, though, to
oversimplify things a bit, you write a test script which travels through
your application, then you give that script to your load test tool and let
it run the script with some predetermined number of virtual users. As it
runs the script, it measures response time and throughput, and stores those
measurements. After the test has been run, you can generate data about which
pages took longest on average, and those are your bottlenecks.

You can then examine those pages specifically, and use GetTickCount within
those pages to find out which section of the page is causing trouble.

This kind of load test is called a performance test. You can also use load
test tools to perform capacity planning tests.

> I liked the example on the houseoffusion.com home page where 
> the question was asked, "Is CFLOOP really needed?"... little 
> tricks like that, I'm sure are almost trivial but running 
> sloppy queries/loopsetc... Just want to tighten it up.

I'm sorry, but that kind of question is like asking how many angels can
dance on the head of a pin. You won't find your performance problems can be
solved by "little tricks" like that. I've analyzed literally hundreds of CF
applications, and their problems were never caused by those sorts of things.
Instead, the problems almost always come down to poor database schema
design, poorly written SQL, inadequate caching, or some combination of
those.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444 
  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: ColdFusion Blogging Tool

2004-06-21 Thread Jake .
> Oh, and as a head's up, you appear to be producing broken RSS. You'll 
> usually be able to skate by with invalid  elements, but your 
> invalid s will result in most aggregators simply ignoring 
> the date info entirely. Either switch to  with W3CDTF dates, 
> or produce full RFC822 for .

RSS is a strange beast. This feed actually works in most aggregators I tried (about 10-12 so far). This particular demo feed may be a little off, but the final version has gotten a handful of tweaks. In the next version, I'm actually adding Atom support, as well as more robust RSS 2.0, RSS blog comments feeds, etc. 

It's a fun non-standardized world, that RSS. 

Jake
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




CGI variables

2004-06-21 Thread hemant jain
hi, 

We have a cold fusion web application. Which is under the security of another applicaiton. Security application passes the user id to our application in form of something like below. 

cgi.http_scempnum 

We access this variable value in applicaiton.cfm file and query the user table for this user id every time when any cold fusion page is accessed. 
SO for every coldfusion request send query is fired against the database. 

We have 1000 users and out of them only 5 are losing that cgi user id variable passed on to us from security applicaiton. 

In the first attempt some users get thru it and we are able to access above mentioned value. 
But in is subsequent requests send after successfully login in to our site ,  we are losing that value. 

For some users in the very first attempt we are losing the value of cgi variable. 

It comes as blank string. 

One work around we have though is to store in cookie for very first time and then in subsequent requests we can use cookie value. 

But what if we dont get the cgi variable valiue in first attempt itself and so cookie will also contain blank string. 

Users are using IE 6.0 all 1000 users. 
Its happening in production only and not devleopment . 

Can any help me on this issue.Is it related to some server settings? 

thanks 

hemant
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




cflocation fails

2004-06-21 Thread Kevin Roche
Hi,

I have a strange situation which I can't track down.

I have an application that I have been using successfully for some time
running on CFMX 6.1

Recently the application has been giving problems because the 
tags are not working sometimes.

The characteristics are that the browser shows the redirected URL at the
address bar and the content (Usually nothing or debug info) for the page
that issues the cflocation.

If you position the cursor in the address bar and hit enter you do then go
to the correct page.

Anyone seen this before?

Anyone know what could possibly cause it?

Kevin Roche
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: ColdFusion Blogging Tool

2004-06-21 Thread Jake .
>Sometimes, the paid versions aren't worth the money
>http://www.countersinkdg.com/demo/admin/login.cfm?url="">
>dg.com/demo/admin/index.cfm?

No need to be rude. As I stated in the notes to this demo, it's a demo and a testbed, and as such always getting tweaks. I was doing some testing this weekend and forgot to copy a file up to the server. Oops! Sorry about that. It's all good now.

Jake
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: CFPOP streamlining

2004-06-21 Thread James Smith
In this case I am using MX, but that in useful information to be filed in
the "for future reference" folder, cheers.

> I'm not sure which version of CF you are using but on CF4.x/5 
> the getheaderonly action actually retrieved the entire mail 
> although it didn't present it all in the query so for what 
> you are doing, a single pass is probably preferable under the 
> circumstances outlined above... I haven't really played with 
> CFPOP on CFMX that much to know it's nuances so this 
> information may or may not be correct when using CFMX
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: CFPOP streamlining

2004-06-21 Thread Kola Oyedeji
James 

 
I just had a look at the livedocs for CFMX
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-b14.htm#wp11
01854 
(assuming you are on cfmx) and message number can actually be a comma
separated list of all the messages you would like to retrieve, this
should save you having to call cfpop for each email and allow you to
re-use the connect.

 
Not sure if the getHeaderOnly action correctly only gets the header but
you can look at the commands being sent to the mail server in the mail
logs which should give you some indication of what  POP commands are
being sent to the mail server

 
HTH

 
KOla

 
-Original Message-
From: James Smith [mailto:[EMAIL PROTECTED] 
Sent: 21 June 2004 11:37
To: CF-Talk
Subject: RE: CFPOP streamlining

 
Thanks, that is what I am in the process of doing now, I was more
wondering
if there were any protocol issues here where one method would be
considered
"more propper" than the other.

  _  

From: Kola Oyedeji [mailto:[EMAIL PROTECTED] 
Sent: 21 June 2004 11:32
To: CF-Talk
Subject: RE: CFPOP streamlining

James you could well be right, it may actually be quicker to download
and then ignore the additional emails as opposed to constantly
opening/closing connections to the mail server - I would test both
options and see which one performs better.

Kola

-Original Message-
From: James Smith [mailto:[EMAIL PROTECTED] 
Sent: 21 June 2004 11:06
To: CF-Talk
Subject: CFPOP streamlining

I have a template that retrieves mail and processes it to extract order
information using cfpop.  At any one time it can be retrieving up to 300
emails of which around 200 will be orders, the rest will be a mixture of
junk and correspondence aimed at the human who reads the account.

I am currently doing a cfpop to retrieve the headers only, then looping
over
these doing another cfpop for each to get the message body resulting in
200+
pop connections in total.

Would it be better to just do one connection, retrieve everything, and
simply ignore to 100 message bodies I am not interested in?

--
James Smith
[EMAIL PROTECTED]

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.707 / Virus Database: 463 - Release Date: 15/06/2004
  _ 
  _
  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: CFPOP streamlining

2004-06-21 Thread Paul Vernon
I'm not sure which version of CF you are using but on CF4.x/5 the
getheaderonly action actually retrieved the entire mail although it didn't
present it all in the query so for what you are doing, a single pass is
probably preferable under the circumstances outlined above... I haven't
really played with CFPOP on CFMX that much to know it's nuances so this
information may or may not be correct when using CFMX

 
Paul
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




  1   2   >