Simple way to check for valid date?

2003-12-05 Thread Mike Kear
I have a form where users enter dates by selecting from drop-down menus for
date, month and year.Is there a simple way to check they have entered a
valid date rather than a laborious checking for leap year, if the month is
april and date greater than 30 etc etc etc?

I get errors if they choose 31 September or 30 February etc as you'd expect
but I'd rather handle the error gracefully than just display a nasty
database error. 



Cheers,

Michael Kear

Windsor, NSW, Australia

AFP Webworks.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Simple way to check for valid date?

2003-12-05 Thread Dan Farmer
How about this

Take the form values... form.theyear form.themonthmm
form.theday dd

submit the form to a temporay page where you will combine them into one 
form.thedate ( but this time use the input type=hidden 
name=thedate_date value=enter the date validation tag.

Write out all the form variables ( set them again in that temp page ) and 
use _javascript_to point to your real form processing page.

script
form.submit();
/script



I have a form where users enter dates by selecting from drop-down menus for
date, month and year.Is there a simple way to check they have entered a
valid date rather than a laborious checking for leap year, if the month is
april and date greater than 30 etc etc etc?



I get errors if they choose 31 September or 30 February etc as you'd expect
but I'd rather handle the error gracefully than just display a nasty
database error.







Cheers,

Michael Kear

Windsor, NSW, Australia

AFP Webworks.









 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




escaping characters in Javascript.

2003-12-05 Thread Dwayne Cole
Code Scenerio looks like this:



Problem: sometimes the #EVENT_OBJECTIVE# variable contains quotes and apostrophies.When that happens I get a _javascript_ error.How do I make sure that the content in the #event_objective# is properly escaped.

Dwayne Cole, MS in MIS, MBA
Florida AM University
Certified Advanced ColdFusion Developer
850-591-0212
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Simple way to check for valid date?

2003-12-05 Thread Michael Wolfe
cfif not IsDate(9/31/2003)
 !--- error code goes here ---
/cfif

 
--
Michael Wolfe
[EMAIL PROTECTED] 

-Original Message-
From: Mike Kear [mailto:[EMAIL PROTECTED] 
Sent: Friday, December 05, 2003 12:49 AM
To: CF-Talk
Subject: Simple way to check for valid date?

I have a form where users enter dates by selecting from drop-down menus for
date, month and year.Is there a simple way to check they have entered a
valid date rather than a laborious checking for leap year, if the month is
april and date greater than 30 etc etc etc?

I get errors if they choose 31 September or 30 February etc as you'd expect
but I'd rather handle the error gracefully than just display a nasty
database error. 

Cheers,

Michael Kear

Windsor, NSW, Australia

AFP Webworks. 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: escaping characters in Javascript.

2003-12-05 Thread Massimo, Tiziana e Federica
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/funct148.htm#wp110699
3


Massimo Foti
Certified Dreamweaver MX Developer
Certified Advanced ColdFusion MX Developer
http://www.massimocorner.com/

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Simple way to check for valid date?

2003-12-05 Thread Mike Kear
YOU'RE KIDDING!!!I looked at that function and came to the conclusion it
wasn't for that, but for checking that the format of the string was really a
date.Cool. It checks the calendar too.

Sometimes the most simple answers are sitting right in front of you and
staring you in the face. 

Thanks Michael. 



Cheers,

Michael Kear

Windsor, NSW, Australia

AFP Webworks.





-Original Message-
From: Michael Wolfe [mailto:[EMAIL PROTECTED] 
Sent: Friday, 5 December 2003 8:58 PM
To: CF-Talk
Subject: RE: Simple way to check for valid date?

cfif not IsDate(9/31/2003)
 !--- error code goes here ---
/cfif

--
Michael Wolfe
[EMAIL PROTECTED] 

-Original Message-
From: Mike Kear [mailto:[EMAIL PROTECTED] 
Sent: Friday, December 05, 2003 12:49 AM
To: CF-Talk
Subject: Simple way to check for valid date?

I have a form where users enter dates by selecting from drop-down menus for
date, month and year.Is there a simple way to check they have entered a
valid date rather than a laborious checking for leap year, if the month is
april and date greater than 30 etc etc etc?

I get errors if they choose 31 September or 30 February etc as you'd expect
but I'd rather handle the error gracefully than just display a nasty
database error. 

Cheers,

Michael Kear

Windsor, NSW, Australia

AFP Webworks. 
_

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




RE: Simple way to check for valid date?

2003-12-05 Thread Michael Wolfe
Let me qualify my answer...

 
IsDate checks for a valid date, but CF has funny notions about valid dates.
Basically, you can enter almost any value you want for the year part of the
date, and CF will accept if. So... you need to check if the date is within a
valid range also.

 
I have recently had a need to use this in a medical billing app I am working
on. Since some of the patients are over 100 years old, I use a function like
this:

 
cfif not IsDate(birthdate) or Abs(DateDiff(, birthdate, Now()) GT
120)
 !--- error code here ---
/cfif

 
--
Michael Wolfe
[EMAIL PROTECTED] 

-Original Message-
From: Mike Kear [mailto:[EMAIL PROTECTED] 
Sent: Friday, December 05, 2003 2:25 AM
To: CF-Talk
Subject: RE: Simple way to check for valid date?

YOU'RE KIDDING!!!I looked at that function and came to the conclusion it
wasn't for that, but for checking that the format of the string was really a
date.Cool. It checks the calendar too.

Sometimes the most simple answers are sitting right in front of you and
staring you in the face. 

Thanks Michael. 

Cheers,

Michael Kear

Windsor, NSW, Australia

AFP Webworks.



-Original Message-
From: Michael Wolfe [mailto:[EMAIL PROTECTED] 
Sent: Friday, 5 December 2003 8:58 PM
To: CF-Talk
Subject: RE: Simple way to check for valid date?

cfif not IsDate(9/31/2003)
 !--- error code goes here ---
/cfif

--
Michael Wolfe
[EMAIL PROTECTED] 

-Original Message-
From: Mike Kear [mailto:[EMAIL PROTECTED] 
Sent: Friday, December 05, 2003 12:49 AM
To: CF-Talk
Subject: Simple way to check for valid date?

I have a form where users enter dates by selecting from drop-down menus for
date, month and year.Is there a simple way to check they have entered a
valid date rather than a laborious checking for leap year, if the month is
april and date greater than 30 etc etc etc?

I get errors if they choose 31 September or 30 February etc as you'd expect
but I'd rather handle the error gracefully than just display a nasty
database error. 

Cheers,

Michael Kear

Windsor, NSW, Australia

AFP Webworks. 
_

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




Re: Another CFML app server...

2003-12-05 Thread Thomas Chiverton
On Thursday 04 Dec 2003 20:32 pm, Rick Root wrote:
 Looks to me like BlueDragon Server is a better free option for CFML.
 Heck, I'm probably gonna go with BlueDragon 6.1 JX when it is released
 rather than upgrading to CF 6.1 from 5.0 on my box...

We're sorta roughly looking at it as a cheaper alternative than CFMX.

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




Re: ConnectString - Oops

2003-12-05 Thread Thomas Chiverton
On Thursday 04 Dec 2003 18:54 pm, Schuster, Steven wrote:
 Does anyone have a sample connectstring for CFQUERY for Oracle. Here is
 what I use for JSP and was wondering if it would be ok for CFM as well.

Why are you trying to setup a connection in a cfquery ?
datasources are setup in the CF administrator, or you can use whatever your 
application server provides in terms of jdbc datasources (these should show 
up in CF, but not be editable in the administrator.

The 'jdbc:oracle:thin' isn't a class path, it's a resource locator (like 
http:), that says 'use jdbc to find the oracle connector, and ask that for a 
thin connection, passing it this data'.

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




RE: Another CFML app server...

2003-12-05 Thread Tangorre, Michael
At first I was trying to be optimistic and polite, but their site is such a
distraction due to its lack of style and the more I explore and read about
Coral, the more I am not in favor at all...

-Original Message-
From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 04, 2003 4:02 PM
To: CF-Talk
Subject: RE: Another CFML app server...

Sorry. This whole thing seems a little backwoods to me. I'll admit I'm
superficial about this sort of thing, but I'm not about to use a
webserver from a company who has such a crappy site. The information
about the server so far is misleading at best. Not a single person on
their staff is here to comment to the community? Or bother to make an
official announcement?

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

-Original Message-
From: Thane Sherrington [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 04, 2003 3:43 PM
To: CF-Talk
Subject: RE: Another CFML app server...

At 03:24 PM 12/4/03 -0500, Adam Wayne Lehman wrote:
Seriously though. they only support like 25 tags! You'd be better off
just learning the ASP equivalents and calling it a day!

24 by my count (I'm ignoring cflock since it isn't needed.)

cfabort
cfapplication
cfbreak
cfcookie
cfdirectory
cfexecute
cffile
cfhttp
cfif
cfelse
cfelseif
cfinclude
cflocation
cflock not required in Coral
cfloop
cfmail
cfoutput
cfparam
cfpop
cfprocessingdirective
cfquery
cfscript
cfset
cftransaction
cftry/cfcatch

While it could be better, it is a start - we should be encouraging this 
sort of thing, I think.

T


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

-Original Message-
From: Dan Farmer [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 04, 2003 12:34 PM
To: CF-Talk
Subject: RE: Another CFML app server...

A the links seemed to work for me as well. I kinda like the idea of
this...



 From: Greg Luce [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Subject: RE: Another CFML app server...
 Date: Thu, 4 Dec 2003 11:36:44 -0500
 MIME-Version: 1.0
 Received: from houseoffusion.com ([64.118.64.245]) by
mc5-f39.hotmail.com
 with Microsoft SMTPSVC(5.0.2195.6713); Thu, 4 Dec 2003 08:41:33 -0800
 Received: from LOCALHOST by LOCALHOSTwith ESMTP id
 9EF0D689E3AD1E40A2C3F72EDF6FB058Thu, 4 Dec 2003 11:39:33 -0500
 X-Message-Info: JGTYoYF78jGZZGSE3Ub5y1wF09VcJMdd
 Message-ID: [EMAIL PROTECTED]
 Precedence: bulk
 References:
[EMAIL PROTECTED]
 Return-Path: [EMAIL PROTECTED]
 X-OriginalArrivalTime: 04 Dec 2003 16:41:41.0752 (UTC)
 FILETIME=[7ED08F80:01C3BA85]
 
 What doesn't work? I just bounced through it all and downloaded it.
 
 -Original Message-
 From: Gabriel Robichaud [mailto:[EMAIL PROTECTED]
 Sent: Thursday, December 04, 2003 10:11 AM
 To: CF-Talk
 Subject: RE: Another CFML app server...
 
 
 Chickens.
 
 -Original Message-
 From: Ryan Mitchell [mailto:[EMAIL PROTECTED]
 Sent: Thursday, December 04, 2003 10:09 AM
 To: CF-Talk
 Subject: Re: Another CFML app server...
 
 I think its been removed :)
 
 On 4/12/03 3:04 pm, Gabriel Robichaud [EMAIL PROTECTED]
 wrote:
 
   wow... the site must be down, i was able to view it all this am.
  
  
   Gabriel
  
   -Original Message-
   From: Clint Tredway [mailto:[EMAIL PROTECTED]
   Sent: Thursday, December 04, 2003 10:03 AM
   To: CF-Talk
   Subject: Re: Another CFML app server...
  
   I would like to try it, but none of the links work on the site ;)
  
   Tim Blair wrote:
  
Morning,
   
Has anyone seen this before: http://www.pcaonline.com/coral/
http://www.pcaonline.com/coral/ 
   
It's a new one on me...
   
Tim.
   
---
RAWNET LTD - Internet, New Media and ebusiness Gurus.
Visit our new website at http://www.rawnet.com
http://www.rawnet.comfor
more information about our company, or call us free
anytime on 0800 294 24 24.
---
Tim Blair
Web Application Engineer, Rawnet Limited
Direct Phone : +44 (0) 1344 393 441
Switchboard : +44 (0) 1344 393 040
---
This message may contain information which is legally
privileged and/or confidential.If you are not the
intended recipient, you are hereby notified that any
unauthorised disclosure, copying, distribution or use
of this information is strictly prohibited. Such
notification notwithstanding, any comments, opinions,
information or conclusions expressed in this message
are those of the originator, not of rawnet limited,
unless otherwise explicitly and independently indicated
by an authorised representative of rawnet limited.
---
   
  _
  
  
 _
 _
 
 
 
_



_ 
_
 [Todays 

RE: Another CFML app server...

2003-12-05 Thread [EMAIL PROTECTED]
I use switch/case tags and don't use Fusebox.
Admittedly not very often but if logic dictates...

Why is it bad to use them,is there a substantial overhead verses cfifs ?

I must admit the one curious thing I have always though about Fusebox is
that essentially boils down to a switch/case statment and I can't believe
that for a big app it's that efficient. imho

-Original Message-
From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED]
Sent: 04 December 2003 20:25
To: CF-Talk
Subject: RE: Another CFML app server...

Dear FuseBox Users,

 
No one uses cfcase/cfswitch. So It's not supported in Coral.

 
Seriously though. they only support like 25 tags! You'd be better off
just learning the ASP equivalents and calling it a day!

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

 
-Original Message-
From: Dan Farmer [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 04, 2003 12:34 PM
To: CF-Talk
Subject: RE: Another CFML app server...

 
A the links seemed to work for me as well. I kinda like the idea of
this...

From: Greg Luce [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: Another CFML app server...
Date: Thu, 4 Dec 2003 11:36:44 -0500
MIME-Version: 1.0
Received: from houseoffusion.com ([64.118.64.245]) by
mc5-f39.hotmail.com 
with Microsoft SMTPSVC(5.0.2195.6713); Thu, 4 Dec 2003 08:41:33 -0800
Received: from LOCALHOST by LOCALHOSTwith ESMTP id 
9EF0D689E3AD1E40A2C3F72EDF6FB058Thu, 4 Dec 2003 11:39:33 -0500
X-Message-Info: JGTYoYF78jGZZGSE3Ub5y1wF09VcJMdd
Message-ID: [EMAIL PROTECTED]
Precedence: bulk
References:
[EMAIL PROTECTED]
Return-Path: [EMAIL PROTECTED]
X-OriginalArrivalTime: 04 Dec 2003 16:41:41.0752 (UTC) 
FILETIME=[7ED08F80:01C3BA85]

What doesn't work? I just bounced through it all and downloaded it.

-Original Message-
From: Gabriel Robichaud [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 04, 2003 10:11 AM
To: CF-Talk
Subject: RE: Another CFML app server...


Chickens.

-Original Message-
From: Ryan Mitchell [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 04, 2003 10:09 AM
To: CF-Talk
Subject: Re: Another CFML app server...

I think its been removed :)

On 4/12/03 3:04 pm, Gabriel Robichaud [EMAIL PROTECTED]
wrote:

  wow... the site must be down, i was able to view it all this am.
 
 
  Gabriel
 
  -Original Message-
  From: Clint Tredway [mailto:[EMAIL PROTECTED]
  Sent: Thursday, December 04, 2003 10:03 AM
  To: CF-Talk
  Subject: Re: Another CFML app server...
 
  I would like to try it, but none of the links work on the site ;)
 
  Tim Blair wrote:
 
   Morning,
  
   Has anyone seen this before: http://www.pcaonline.com/coral/
  
   It's a new one on me...
  
   Tim.
  
   ---
   RAWNET LTD - Internet, New Media and ebusiness Gurus.
   Visit our new website at http://www.rawnet.com for
   more information about our company, or call us free
   anytime on 0800 294 24 24.
   ---
   Tim Blair
   Web Application Engineer, Rawnet Limited
   Direct Phone : +44 (0) 1344 393 441
   Switchboard : +44 (0) 1344 393 040
   ---
   This message may contain information which is legally
   privileged and/or confidential.If you are not the
   intended recipient, you are hereby notified that any
   unauthorised disclosure, copying, distribution or use
   of this information is strictly prohibited. Such
   notification notwithstanding, any comments, opinions,
   information or conclusions expressed in this message
   are those of the originator, not of rawnet limited,
   unless otherwise explicitly and independently indicated
   by an authorised representative of rawnet limited.
   ---
  
 _
 
 
_
_



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




Re: Another CFML app server...

2003-12-05 Thread Thomas Chiverton
On Friday 05 Dec 2003 11:39 am, Tangorre, Michael wrote:
 [not a lot, but quoted everyone in full]

Would it kill people to trim the quoted emails down a little ?
Not directed at just you Michael !

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




RE: Another CFML app server...

2003-12-05 Thread Tangorre, Michael
Interesting considering some people have 22 line signatures. :-)

 Would it kill people to trim the quoted emails down a little ?
  Not directed at just you Michael !
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Another CFML app server...

2003-12-05 Thread d.a.collie
 Would it kill people to trim the quoted emails down a little ?
 Not directed at just you Michael !

 Interesting considering some people have 22 line signatures. :-)

Required by company no doubt..
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Another CFML app server...

2003-12-05 Thread Philip Arnold
 I use switch/case tags and don't use Fusebox.
 Admittedly not very often but if logic dictates...

 Why is it bad to use them,is there a substantial overhead
 verses cfifs ?

 I must admit the one curious thing I have always though about
 Fusebox is that essentially boils down to a switch/case
 statment and I can't believe that for a big app it's that
 efficient. imho

CFSWITCH has an exponentially better performance than CFIF the more
entries you use

The reason for this is that the choices are hard coded into the CFCASE
elements, while each entry in a CFIF has to be evaluated every time it
runs the code

FuseBox uses CFSWITCH a lot, so anything written in it would have to be
re-written to work on this systems...

But then again, just about any application would, as the tag list is
very limited
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Another CFML app server...

2003-12-05 Thread Thomas Chiverton
On Friday 05 Dec 2003 13:07 pm, [EMAIL PROTECTED] wrote:
 Would it kill people to trim the quoted emails down a little ?
 Interesting considering some people have 22 line signatures. :-)
 Required by company no doubt..

Yup.
And i've told them it's shite.
And I've told them it's anti-netiquete.
And I've told them I don't want my plain-text email address, postal details, 
phone and fax numbers dumped where any spam bot can find them.

But *no* :-(

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




Re: Another CFML app server...

2003-12-05 Thread Jochem van Dieten
Tangorre, Michael wrote:

 Interesting considering some people have 22 line signatures. :-)

Atleast they use a proper signature delimiter so the signature 
isn't quoted in the reply :-)

Jochem

-- 
When you don't want to be surprised by the revolution
organize one yourself
- Loesje
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Another CFML app server...

2003-12-05 Thread Tangorre, Michael
Well you got me on that one I guess... what an email novice I must be.

-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED] 
Sent: Friday, December 05, 2003 8:12 AM
To: CF-Talk
Subject: Re: Another CFML app server...

Tangorre, Michael wrote:

 Interesting considering some people have 22 line signatures. :-)

Atleast they use a proper signature delimiter so the signature 
isn't quoted in the reply :-)

Jochem

-- 
When you don't want to be surprised by the revolution
organize one yourself
- Loesje 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Another CFML app server...

2003-12-05 Thread DURETTE, STEVEN J (AIT)
Jochem,

 
What is the proper signature delimiter?

 
Steve

-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Friday, December 05, 2003 8:12 AM
To: CF-Talk
Subject: Re: Another CFML app server...

Tangorre, Michael wrote:

 Interesting considering some people have 22 line signatures. :-)

Atleast they use a proper signature delimiter so the signature 
isn't quoted in the reply :-)

Jochem

-- 
When you don't want to be surprised by the revolution
organize one yourself
- Loesje 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Another CFML app server...

2003-12-05 Thread Thomas Chiverton
On Friday 05 Dec 2003 13:10 pm, Tangorre, Michael wrote:
 Well you got me on that one I guess... what an email novice I must be.

 -Original Message-

Hmm, top quoting too :-)

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




Re: Another CFML app server...

2003-12-05 Thread Jochem van Dieten
DURETTE, STEVEN J (AIT) wrote:

 What is the proper signature delimiter?

dash dash space on a line by itself. Mail clients should 
discard that line and everything below it when quoting a message 
in a reply.

Jochem

-- 
When you don't want to be surprised by the revolution
organize one yourself
- Loesje
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Another CFML app server...

2003-12-05 Thread Howie Hamlin
Hmmm...Outlook Express doesn't do that :)

We all know how much you love MS email clients vbg

-- 
Regards,

Howie
- Original Message - 
From: Jochem van Dieten 
To: CF-Talk 
Sent: Friday, December 05, 2003 8:24 AM
Subject: Re: Another CFML app server...

dash dash space on a line by itself. Mail clients should 
discard that line and everything below it when quoting a message 
in a reply.

Jochem

-- 
When you don't want to be surprised by the revolution
organize one yourself
 - Loesje
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Posting XML data to ASP service?

2003-12-05 Thread Tony Weeg
show your code... :) 

...tony

tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337

-Original Message-
From: cf-talk [mailto:[EMAIL PROTECTED] 
Sent: Friday, December 05, 2003 12:06 AM
To: CF-Talk
Subject: RE: Posting XML data to ASP service?

Thanks Tony but that doesn't seem to work for me.I'm not sure why.

 
This is the service I'm trying to connect to:

 
http://www.MelissaData.com/Tech/dqws.htm

 
-Novak

-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 04, 2003 8:58 PM
To: CF-Talk
Subject: RE: Posting XML data to ASP service?

cfhttp method=Post
url="">
cfhttpparam type=Formfield value=#xml#
name=xml
/cfhttp

-Original Message-
From: cf-talk [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 04, 2003 11:43 PM
To: CF-Talk
Subject: Posting XML data to ASP service?

Does anyone here have a quick code snippit showing how exactly to post
an XML document/request to a web service page?I'm trying to determine
what exactly I'm doing wrong and I'm sure it's something very simple.I
can make it work in CF5 using the MS XML object... but can't make it
work in CFMX using the native XML tag and functions.

Quick help anyone?

-Novak 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Another CFML app server...

2003-12-05 Thread John McCosker
phone and fax numbers dumped where any spam bot can find them
Just out of curriosity, why attach it then?

-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]
Sent: 05 December 2003 13:10
To: CF-Talk
Subject: Re: Another CFML app server...

On Friday 05 Dec 2003 13:07 pm, [EMAIL PROTECTED] wrote:
 Would it kill people to trim the quoted emails down a little ?
 Interesting considering some people have 22 line signatures. :-)
 Required by company no doubt..

Yup.
And i've told them it's shite.
And I've told them it's anti-netiquete.
And I've told them I don't want my plain-text email address, postal details,

phone and fax numbers dumped where any spam bot can find them.

But *no* :-(

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




Re: Another CFML app server...

2003-12-05 Thread Thomas Chiverton
On Friday 05 Dec 2003 13:30 pm, Howie Hamlin wrote:
 Hmmm...Outlook Express doesn't do that :)

have you seen OEQuoteFix ?

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




Re: Generating Primary Key in Oracle (part 2)

2003-12-05 Thread Deanna Schneider
Hi Stacy,

 I was thinking of using a single db table with single db column to store
 the current 'highest value' for the primary key.

 If anyone's used this method before...do you this incremental value
 across multiple tables? i.e. I have a table for 'orders' and another for
 'users'. Would both feed off this single primary key table?

I use a sequence, but I use the same sequence across an application. It cuts
down on the number of objects I need to maintain, and makes it so that any
one table probably doesn't have too many consecutive primary keys. The same
would apply if you're building your own table to generate a sequential
primary key. Though, I really see no reason for building your own table when
sequences are so easy to use.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




BlueDragon (was Re: Another CFML app server...)

2003-12-05 Thread Matt Liotta
 We're sorta roughly looking at it as a cheaper alternative than CFMX.

While that is certainly one difference between BlueDragon and 
ColdFusion, it isn't the only one. There are many other reasons to 
chose BlueDragon over ColdFusion and vice versa. With the BlueDragon 
6.1's availability around the corner I think it is now clear that at 
least from a CFML perspective, the two application servers are very 
similar and will remain that way into the future. Of course, there is a 
lot more to a CF application than just CFML and each of the respective 
products has functionality that they share and some that they don't. I 
think it is important for the CF community to understand these 
differences, so their CF applications can be deployed on the best 
possible platform for their needs. In some cases that may be ColdFusion 
and in other cases it may be BlueDragon, but the point is there is a 
choice and BlueDragon's strong showing as of 6.1 just made that choice 
a lot harder than it used to be by implemented much of CFMX.

Matt Liotta
President  CEO
Montara Software, Inc.
http://www.MontaraSoftware.com
(888) 408-0900 x901
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Another CFML app server...

2003-12-05 Thread Howie Hamlin
Yep - and I have it installed.A stock version of OE doesn't detect sigs.

Regards,

Howie
- Original Message - 
From: Thomas Chiverton 
To: CF-Talk 
Sent: Friday, December 05, 2003 8:50 AM
Subject: Re: Another CFML app server...

On Friday 05 Dec 2003 13:30 pm, Howie Hamlin wrote:
 Hmmm...Outlook Express doesn't do that :)

have you seen OEQuoteFix ?

-- 
Tom Chiverton 
Advanced ColdFusion Programmer
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Another CFML app server...

2003-12-05 Thread Thomas Chiverton
On Friday 05 Dec 2003 13:48 pm, John McCosker wrote:
 phone and fax numbers dumped where any spam bot can find them
 Just out of curriosity, why attach it then?

Which bit of 'required by company, yup' passed you by ?

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




Re:cfmail pre-formatting

2003-12-05 Thread cf coder
thank you all for your suggestions. This code does the job.

cfmail to=[EMAIL PROTECTED]
from=#frommail#
subject=Order
server=someserver
port=25
type=HTML

Any Comments=#AnyComments# br
cfif shoppingBasket neq 0Shopping Basket=#shoppingBasket# br/cfif 
cfif username neq 0User Name=#username#br/cfif

/cfmail
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: BlueDragon (was Re: Another CFML app server...)

2003-12-05 Thread Thomas Chiverton
On Friday 05 Dec 2003 13:56 pm, Matt Liotta wrote:
  We're sorta roughly looking at it as a cheaper alternative than CFMX.
 choice and BlueDragon's strong showing as of 6.1 just made that choice
 a lot harder than it used to be by implemented much of CFMX.

:nods
That's one of the things that has made us look at it again (we first did when 
MX was in beta).
We may have to deploy CF servers to customer sites in future, so the 
per-server costs are more important now.

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




Which is the better charset for sending CFMail messages?

2003-12-05 Thread Mark Leder
In CFMX 6.1 ...

UTF-7 or UTF-8?

If one is better than the other, why?

Curious, Mark
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Which is the better charset for sending CFMail messages?

2003-12-05 Thread Howie Hamlin
UTF-8 is usually for web pages and UTF-7 is usually for emails.The first one designates 8-bit data and the second one signifies 7-bit.

HTH,
-- 
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc. - www.CoolFusion.com
inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server
PrismAV - Virus scanning for ColdFusion applications
 Please vote for iMS here: http://www.sys-con.com/coldfusion/readerschoice2003/index.cfm 
 Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm

- Original Message - 
From: Mark Leder 
To: CF-Talk 
Sent: Friday, December 05, 2003 9:05 AM
Subject: Which is the better charset for sending CFMail messages?

In CFMX 6.1 ...

UTF-7 or UTF-8?

If one is better than the other, why?

Curious, Mark
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: BlueDragon (was Re: Another CFML app server...)

2003-12-05 Thread d.a.collie
Matt wrote:
 ColdFusion, it isn't the only one. There are many other reasons to 
 chose BlueDragon over ColdFusion and vice versa. With the BlueDragon 

Any chance of elaboration on that point?Main advantages/disadvantages?

-dc
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Manipulating Images

2003-12-05 Thread Trevor Holm-Laursen
We have a client that has a photo gallery where users can upload photos which then have to be approved by the admin.I want to be able to check the dimensions of the image when it's approve and if the width is more the X, resize it to a width X.It looks like Imagemagik might be the solution.Has anyone else done something like this and have Code or a tag that will do it or any other suggestions?

Thanks,

Trevor

PS.Don't really have time to write a Java Class to do this even though i know it can be done.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: BlueDragon (was Re: Another CFML app server...)

2003-12-05 Thread Rick Root
[EMAIL PROTECTED] wrote:

 Matt wrote:
 ColdFusion, it isn't the only one. There are many other reasons to
 chose BlueDragon over ColdFusion and vice versa. With the BlueDragon
 
 Any chance of elaboration on that point?Main advantages/disadvantages?

The cost advantage is even larger if you want to run JSPs and servlets 
as will as CFML.From what I can tell, BlueDragon JX 6.1 will allow you 
to do that for $549  while Cold Fusion Professional at $1299 will 
not.. you have to get Enterprise to actually be able to use CFMX as a 
JSP/Servlet engine, right?(I could be way off here)

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




Re:cfmail pre-formatting

2003-12-05 Thread MILAN MUSHRAN
This code is fine for HTML supported email servers, but not when it is text 
supported only.

From: cf coder [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Re:cfmail pre-formatting
Date: Fri, 05 Dec 2003 09:05:53 -0400

thank you all for your suggestions. This code does the job.

cfmail to=[EMAIL PROTECTED]
from=#frommail#
subject=Order
server=someserver
port=25
type=HTML

Any Comments=#AnyComments# br
cfif shoppingBasket neq 0Shopping Basket=#shoppingBasket# br/cfif
cfif username neq 0User Name=#username#br/cfif

/cfmail

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




application.cfm and session variable

2003-12-05 Thread cf coder
I am having a strange problem. I created an
application.cfm file on the webroot and have declared
few session variables.

CFAPPLICATION NAME=NApp
CLIENTMANAGEMENT=Yes
SESSIONMANAGEMENT=Yes
SETCLIENTCOOKIES=No
SESSIONTIMEOUT=#CreateTimeSpan(0,0,30,0)#

I have a cfldap tag wrapped around try/catch blocks in
my application.cfm file that authenticates the user.

CFSET VALID = 0

cftry
cfldap
	action="">
	name=authUser
	server=ldapServer
	start=dc=uk
	filter=(uid=cfcoder) 
	attributes=cn,givenname,sn,mail
	scope=subtree
	port=389

cfcatch type=any
CFSET VALID = 1
/cfcatch

/cftry

cfif VALID IS 0 
 cfif isDefined(authUser) and authUser.cn neq

	cflock scope=SESSION timeout=30
type=EXCLUSIVE
	cfset session.doesUserHavePermissions = True
	/cflock
 /cfif
/cfif
	
/CFIF

Now when I refer to this session variable in another
file, I get an error, it says the session variable is
not defined. I thought whenever a .cfm file is called,
the CF Server does a search for the application.cfm
file and initializes the application and all scoped
variables. I also added a cfdump line in the
application file, dumping the results from the ldap
query and dumping session variables.

When I view the cfm file on the browser I don't see no
dump, just get the msg that the session variable is
not defined. Don't know what's
happening, can somebody you please help?

Thanks
CF Coder

__
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Manipulating Images

2003-12-05 Thread MILAN MUSHRAN
A CFX tag is available for checking the length of the images. I do not 
remember the name of the tag.

From: Trevor Holm-Laursen [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Manipulating Images
Date: Fri, 05 Dec 2003 09:16:56 -0400

We have a client that has a photo gallery where users can upload photos 
which then have to be approved by the admin.I want to be able to check 
the dimensions of the image when it's approve and if the width is more the 
X, resize it to a width X.It looks like Imagemagik might be the solution. 
Has anyone else done something like this and have Code or a tag that will 
do it or any other suggestions?

Thanks,

Trevor

PS.Don't really have time to write a Java Class to do this even though i 
know it can be done.

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Generating Primary Key in Oracle (part 2)

2003-12-05 Thread Gabriel Robichaud
If your on Oracle, you should go with sequences!

 
http://www.macromedia.com/devnet/server_archive/articles/cf_best_practices_oracle.html#6

 
Gabriel

-Original Message-
From: Deanna Schneider [mailto:[EMAIL PROTECTED]
Sent: Friday, December 05, 2003 8:55 AM
To: CF-Talk
Subject: Re: Generating Primary Key in Oracle (part 2)

Hi Stacy,

 I was thinking of using a single db table with single db column to store
 the current 'highest value' for the primary key.

 If anyone's used this method before...do you this incremental value
 across multiple tables? i.e. I have a table for 'orders' and another for
 'users'. Would both feed off this single primary key table?

I use a sequence, but I use the same sequence across an application. It cuts
down on the number of objects I need to maintain, and makes it so that any
one table probably doesn't have too many consecutive primary keys. The same
would apply if you're building your own table to generate a sequential
primary key. Though, I really see no reason for building your own table when
sequences are so easy to use. 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: BlueDragon (was Re: Another CFML app server...)

2003-12-05 Thread Matt Liotta
 Any chance of elaboration on that point?  Main 
 advantages/disadvantages?

That is an interesting question and partially why I brought it up. I'm 
not sure that I know all the advantages and disadvantages. I could 
certainly start listing things off the top of my head, but I don't know 
that would cover things. However, maybe if others chime in we can all 
get a more thorough list.

The disadvantages list is pretty easy I think. Anything CFMX does that 
BlueDragon doesn't would be on that list. I believe the BlueDragon 
compatibility guide does a good job of explaining that.

For advantages I would list the following:
* price
* standard deployment to any Servlet engine/J2EE app server
* deployment without source code
* upcoming support for .NET deployment
* cfimap
* cfimage
* CFC enhancements (will be released in beta 2)
* full-text search uses Lucene and includes a spider (will be released 
in beta 2)
* web service consumption is fully dynamic i.e. there is no stub 
caching issue
* disk space and memory requirements are much lower

Again, I am sure there are others, but that was just off the top of my 
head. One major thing I don't think many people have thought about is 
the release cycle of BlueDragon. It seems to me New Atlanta is able to 
release about two versions of BlueDragon for every version released of 
ColdFusion by Macromedia. IMHO, that means that all the things we as a 
community look for in a new release happens more often such as bug 
fixes and feature enhancements.

Matt Liotta
President  CEO
Montara Software, Inc.
http://www.MontaraSoftware.com
(888) 408-0900 x901
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




PAYPAL/NETSOL Security Code

2003-12-05 Thread Ketan Patel
Hi All,
has anybody seen a custom tag or function which will generate a security
code like paypal or netsol.com which is a gif image code and you have to
type the code as a adon to security you have. Please let me know I am
looking for that.

Ketan Patel
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Debugging CFQUERYPARAM

2003-12-05 Thread Tom Kitta
Search the arhives of this group, we had a discussion about that some time
ago and got a list of all known to work type translations for populard DBs.

TK
-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 04, 2003 9:46 PM
To: CF-Talk
Subject: Debugging CFQUERYPARAM

I hate CFQUERYPARAM.Why?Because debugging it seems to be a REAL pain
in the butt.

For example, I have a fairly length query with a lot of fields that are
being inserted.I recently attempted to convert it to use CFQUERYPARAM
(I currently am not using it, to my own risk).

Suddenly, I'm getting this error:


ODBC Error Code = 94 ()
[MERANT][ODBC MySql driver]6053


This is absolutely meaningless to me.

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




Re:cfmail pre-formatting

2003-12-05 Thread cf coder
so what are you saying?

This code is fine for HTML supported email servers, but not when it is text 
supported only.


From: cf coder [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Re:cfmail pre-formatting
Date: Fri, 05 Dec 2003 09:05:53 -0400

thank you all for your suggestions. This code does the job.

cfmail to=[EMAIL PROTECTED]
from=#frommail#
subject=Order
server=someserver
port=25
type=HTML

Any Comments=#AnyComments# br
cfif shoppingBasket neq 0Shopping Basket=#shoppingBasket# br/cfif
cfif username neq 0User Name=#username#br/cfif

/cfmail

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: cfmail pre-formatting

2003-12-05 Thread Tony Weeg
he is saying that its all fine and dandy for email servers that support
html, but the ones that cant
well, its not going to perform EXACTLY as you have intended.

its nothing new, there are no standards, and you can only hope that MOST see
what you wanted them to
HOW you wanted them to.

...tony

tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337

-Original Message-
From: cf coder [mailto:[EMAIL PROTECTED] 
Sent: Friday, December 05, 2003 8:27 AM
To: CF-Talk
Subject: Re:cfmail pre-formatting

so what are you saying?

This code is fine for HTML supported email servers, but not when it is text 
supported only.


From: cf coder [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Re:cfmail pre-formatting
Date: Fri, 05 Dec 2003 09:05:53 -0400

thank you all for your suggestions. This code does the job.

cfmail to=[EMAIL PROTECTED]
from=#frommail#
subject=Order
server=someserver
port=25
type=HTML

Any Comments=#AnyComments# br
cfif shoppingBasket neq 0Shopping Basket=#shoppingBasket# 
br/cfif cfif username neq 0User Name=#username#br/cfif

/cfmail

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: application.cfm and session variable

2003-12-05 Thread Raymond Camden
Now when I refer to this session variable in another file, I 
 get an error, it says the session variable is not defined. I 
 thought whenever a .cfm file is called, the CF Server does a 
 search for the application.cfm file and initializes the 
 application and all scoped variables. I also added a cfdump 
 line in the application file, dumping the results from the 
 ldap query and dumping session variables.

Sorry, but it wasn't clear. YOu said you dumped Session, but was the
variable defined?

 When I view the cfm file on the browser I don't see no dump, 

Ah, so you arne't seeing the dump in application.cfm? Is this file in
another folder? If so, another application.cfm is probably running.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: application.cfm and session variable

2003-12-05 Thread Randell B Adkins
On *nix, you should (well any OS) make sure the application.cfm
has a Capital A: Application.cfm

 [EMAIL PROTECTED] 12/05/03 09:19AM 
I am having a strange problem. I created an
application.cfm file on the webroot and have declared
few session variables.

CFAPPLICATION NAME=NApp
CLIENTMANAGEMENT=Yes
SESSIONMANAGEMENT=Yes
SETCLIENTCOOKIES=No
SESSIONTIMEOUT=#CreateTimeSpan(0,0,30,0)#

I have a cfldap tag wrapped around try/catch blocks in
my application.cfm file that authenticates the user.

CFSET VALID = 0

cftry
cfldap
	action="">
	name=authUser
	server=ldapServer
	start=dc=uk
	filter=(uid=cfcoder) 
	attributes=cn,givenname,sn,mail
	scope=subtree
	port=389

cfcatch type=any
CFSET VALID = 1
/cfcatch

/cftry

cfif VALID IS 0 
 cfif isDefined(authUser) and authUser.cn neq

	cflock scope=SESSION timeout=30
type=EXCLUSIVE
	cfset session.doesUserHavePermissions = True
	/cflock
 /cfif
/cfif
	
/CFIF

Now when I refer to this session variable in another
file, I get an error, it says the session variable is
not defined. I thought whenever a .cfm file is called,
the CF Server does a search for the application.cfm
file and initializes the application and all scoped
variables. I also added a cfdump line in the
application file, dumping the results from the ldap
query and dumping session variables.

When I view the cfm file on the browser I don't see no
dump, just get the msg that the session variable is
not defined. Don't know what's
happening, can somebody you please help?

Thanks
CF Coder

__
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re:cfmail pre-formatting

2003-12-05 Thread MILAN MUSHRAN
Use ASCII code #Chr(13)#  #Chr(10)# (which is equivalent to BR).Use 
#Chr(13)#  #Chr(10)# for a new line in text email and use BR (as you 
already have) for HTML emails.



From: cf coder [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Re:cfmail pre-formatting
Date: Fri, 05 Dec 2003 09:26:33 -0400

so what are you saying?

This code is fine for HTML supported email servers, but not when it is text
 supported only.
 
 
 From: cf coder [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Subject: Re:cfmail pre-formatting
 Date: Fri, 05 Dec 2003 09:05:53 -0400
 
 thank you all for your suggestions. This code does the job.
 
 cfmail to=[EMAIL PROTECTED]
 from=#frommail#
 subject=Order
 server=someserver
 port=25
 type=HTML
 
 Any Comments=#AnyComments# br
 cfif shoppingBasket neq 0Shopping Basket=#shoppingBasket# br/cfif
 cfif username neq 0User Name=#username#br/cfif
 
 /cfmail
 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: application.cfm and session variable

2003-12-05 Thread Tony Weeg
doesn't matter on windows servers.

capital A that is.

...tony

tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337

-Original Message-
From: Randell B Adkins [mailto:[EMAIL PROTECTED] 
Sent: Friday, December 05, 2003 9:34 AM
To: CF-Talk
Subject: Re: application.cfm and session variable

On *nix, you should (well any OS) make sure the application.cfm
has a Capital A: Application.cfm

 [EMAIL PROTECTED] 12/05/03 09:19AM 
I am having a strange problem. I created an application.cfm file on the
webroot and have declared few session variables.

CFAPPLICATION NAME=NApp
CLIENTMANAGEMENT=Yes
SESSIONMANAGEMENT=Yes
SETCLIENTCOOKIES=No
SESSIONTIMEOUT=#CreateTimeSpan(0,0,30,0)#

I have a cfldap tag wrapped around try/catch blocks in my application.cfm
file that authenticates the user.

CFSET VALID = 0

cftry
cfldap
	action="">
	name=authUser
	server=ldapServer
	start=dc=uk
	filter=(uid=cfcoder) 
	attributes=cn,givenname,sn,mail
	scope=subtree
	port=389

cfcatch type=any
CFSET VALID = 1
/cfcatch

/cftry

cfif VALID IS 0 
 cfif isDefined(authUser) and authUser.cn neq 
	cflock scope=SESSION timeout=30
type=EXCLUSIVE
	cfset session.doesUserHavePermissions = True
	/cflock
 /cfif
/cfif
	
/CFIF

Now when I refer to this session variable in another file, I get an error,
it says the session variable is not defined. I thought whenever a .cfm file
is called, the CF Server does a search for the application.cfm file and
initializes the application and all scoped variables. I also added a cfdump
line in the application file, dumping the results from the ldap query and
dumping session variables.

When I view the cfm file on the browser I don't see no dump, just get the
msg that the session variable is not defined. Don't know what's happening,
can somebody you please help?

Thanks
CF Coder

__
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Generating Primary Key in Oracle (part 2)

2003-12-05 Thread Stacy Young
Thanks Deanna, it was a unique situation where the db might have been
migrated mid-project to another platform so I was trying to keep it
portable. As it stands I'll probably just use sequences. 

Cheers!

Stace

_

From: Deanna Schneider [mailto:[EMAIL PROTECTED] 
Sent: December 5, 2003 8:55 AM
To: CF-Talk
Subject: Re: Generating Primary Key in Oracle (part 2)

Hi Stacy,

 I was thinking of using a single db table with single db column to
store
 the current 'highest value' for the primary key.

 If anyone's used this method before...do you this incremental value
 across multiple tables? i.e. I have a table for 'orders' and another
for
 'users'. Would both feed off this single primary key table?

I use a sequence, but I use the same sequence across an application. It
cuts
down on the number of objects I need to maintain, and makes it so that
any
one table probably doesn't have too many consecutive primary keys. The
same
would apply if you're building your own table to generate a sequential
primary key. Though, I really see no reason for building your own table
when
sequences are so easy to use.

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




OT: Making JavaScript Wait.

2003-12-05 Thread Ian Skinner
I have a page that has upwards of 200 links on it that each will open a
detail screen in a new window with a _javascript_ function.This is a
calendar display showing all the events in a month with the ability to get
further details in a popup window by clicking on the event's name.

The problem, is that apparently the _javascript_ throws an object expected
error, if a link is clicked before the entire calendar page is rendered.It
is large enough, the this can take a full second or three to complete.

Is it possible to prevent this error?A better way to implement the code so
that it doesn't matter if the main window if fully rendered? Something to
cause the function to gracefully fail (no error message displayed) or not
run or wait if it's not ready to run correctly?Something else?

Thanks for any help.

function Popup(file,width,height)
{
	
	var topX = (screen.width - width)/2;
	var topY = (screen.height - height)/2;

	popup = window.open(file, Popup, fullscreen=no, toolbar=no,
status=no, menubar=no, scrollbars=yes, resizable=yes, directories=no,
location=no, width=+width+, height=+height+, left=+topX+, top=+topY)
	popup.focus();
	
	return false;
}

--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

Confidentiality Notice:This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Manipulating Images

2003-12-05 Thread Charlie Griefer
Trevor -

Search the archives.That's a topic that comes up frequently.

Also search the forums at easycfm.com, as I know the topic's been discussed there a few times too (relatively recently as well).

Charlie

- Original Message - 
From: Trevor Holm-Laursen 
To: CF-Talk 
Sent: Friday, December 05, 2003 6:16 AM
Subject: Manipulating Images

We have a client that has a photo gallery where users can upload photos which then have to be approved by the admin.I want to be able to check the dimensions of the image when it's approve and if the width is more the X, resize it to a width X.It looks like Imagemagik might be the solution.Has anyone else done something like this and have Code or a tag that will do it or any other suggestions?

Thanks,

Trevor

PS.Don't really have time to write a Java Class to do this even though i know it can be done.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Generating Primary Key in Oracle (part 2)

2003-12-05 Thread d.a.collie
Deanna wrote:
 I use a sequence, but I use the same sequence across an application. 
 It cuts down on the number of objects I need to maintain, and makes 
 it so that any one table probably doesn't have too many consecutive 
 primary keys.

That is very interesting I've always had a pk sequence for (just
about) every table rather than just having one and using that
everywhere.

Ever come across a situation where this 'one sequence fits all' has
tripped you up?

Anyone else got any advantages/disadvantages with regards to this?

-- 
I now know how to delimit my sig :-)

-dc
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Which is the better charset for sending CFMail messages?

2003-12-05 Thread Mark Leder
When I change the charset in CFMail 6.1, CFMX throws an error:

 
Invalid character encoding: utf-7 - Please verify your system can support
the character set you specifed.

 
My cfm page charset is utf-8

 
Thanks, Mark 

-Original Message-
From: Howie Hamlin [mailto:[EMAIL PROTECTED] 
Sent: Friday, December 05, 2003 9:11 AM
To: CF-Talk
Subject: Re: Which is the better charset for sending CFMail messages?

UTF-8 is usually for web pages and UTF-7 is usually for emails.The first
one designates 8-bit data and the second one signifies 7-bit.

HTH,
-- 
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc. - www.CoolFusion.com
inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server
PrismAV - Virus scanning for ColdFusion applications
 Please vote for iMS here:
http://www.sys-con.com/coldfusion/readerschoice2003/index.cfm 
 Find out how iMS Stacks up to the competition:
http://www.coolfusion.com/imssecomparison.cfm

- Original Message - 
From: Mark Leder 
To: CF-Talk 
Sent: Friday, December 05, 2003 9:05 AM
Subject: Which is the better charset for sending CFMail messages?

In CFMX 6.1 ...

UTF-7 or UTF-8?

If one is better than the other, why?

Curious, Mark 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Manipulating Images

2003-12-05 Thread Craig Dudley
This works well,

 
cfx_image

 
http://www.kolumbus.fi/jukka.manner/

	-Original Message-
	From: Trevor Holm-Laursen [mailto:[EMAIL PROTECTED] 
	Sent: 05 December 2003 13:17
	To: CF-Talk
	Subject: Manipulating Images
	
	
	We have a client that has a photo gallery where users can upload
photos which then have to be approved by the admin.I want to be able
to check the dimensions of the image when it's approve and if the width
is more the X, resize it to a width X.It looks like Imagemagik might
be the solution.Has anyone else done something like this and have Code
or a tag that will do it or any other suggestions?
	
	Thanks,
	
	Trevor
	
	PS.Don't really have time to write a Java Class to do this
even though i know it can be done. 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: application.cfm and session variable

2003-12-05 Thread Randell B Adkins
I meant it to become a normal practice of 
saving the file as Application.cfm rather than
application.cfm so that way it would not matter
at that point.

But yes Windows platofrms are more forgiving.

 [EMAIL PROTECTED] 12/05/03 09:38AM 
doesn't matter on windows servers.

capital A that is.

...tony

tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net 
[EMAIL PROTECTED] 
410.548.2337

-Original Message-
From: Randell B Adkins [mailto:[EMAIL PROTECTED] 
Sent: Friday, December 05, 2003 9:34 AM
To: CF-Talk
Subject: Re: application.cfm and session variable

On *nix, you should (well any OS) make sure the application.cfm
has a Capital A: Application.cfm

 [EMAIL PROTECTED] 12/05/03 09:19AM 
I am having a strange problem. I created an application.cfm file on
the
webroot and have declared few session variables.

CFAPPLICATION NAME=NApp
CLIENTMANAGEMENT=Yes
SESSIONMANAGEMENT=Yes
SETCLIENTCOOKIES=No
SESSIONTIMEOUT=#CreateTimeSpan(0,0,30,0)#

I have a cfldap tag wrapped around try/catch blocks in my
application.cfm
file that authenticates the user.

CFSET VALID = 0

cftry
cfldap
	action="">
	name=authUser
	server=ldapServer
	start=dc=uk
	filter=(uid=cfcoder) 
	attributes=cn,givenname,sn,mail
	scope=subtree
	port=389

cfcatch type=any
CFSET VALID = 1
/cfcatch

/cftry

cfif VALID IS 0 
 cfif isDefined(authUser) and authUser.cn neq 
	cflock scope=SESSION timeout=30
type=EXCLUSIVE
	cfset session.doesUserHavePermissions = True
	/cflock
 /cfif
/cfif
	
/CFIF

Now when I refer to this session variable in another file, I get an
error,
it says the session variable is not defined. I thought whenever a .cfm
file
is called, the CF Server does a search for the application.cfm file
and
initializes the application and all scoped variables. I also added a
cfdump
line in the application file, dumping the results from the ldap query
and
dumping session variables.

When I view the cfm file on the browser I don't see no dump, just get
the
msg that the session variable is not defined. Don't know what's
happening,
can somebody you please help?

Thanks
CF Coder

__
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Posting XML data to ASP service?

2003-12-05 Thread Samuel R. Neff
That should be:

cfhttp method=Post
url="">
cfhttpparam type=XML value=#xml#
/cfhttp

But since it's a WSDL you should probably be using CFINVOKE...

Sending data as a form field is a CF specific kludge since CF5 didn't have
the ability to send XML in an outgoing request stream (although it had the
ability to read the incoming request stream).

Sam

---
Blog: http://www.rewindlife.com
Charts: http://www.blinex.com/products/charting
---

 -Original Message-
 From: Tony Weeg [mailto:[EMAIL PROTECTED] 
 Sent: Thursday, December 04, 2003 11:58 PM
 To: CF-Talk
 Subject: RE: Posting XML data to ASP service?
 
 cfhttp method=Post
 url="">
 cfhttpparam type=Formfield value=#xml#
 name=xml
 /cfhttp
 
 -Original Message-
 From: cf-talk [mailto:[EMAIL PROTECTED]
 Sent: Thursday, December 04, 2003 11:43 PM
 To: CF-Talk
 Subject: Posting XML data to ASP service?
 
 Does anyone here have a quick code snippit showing how 
 exactly to post an XML document/request to a web service 
 page?I'm trying to determine what exactly I'm doing wrong 
 and I'm sure it's something very simple.I can make it work 
 in CF5 using the MS XML object... but can't make it work in 
 CFMX using the native XML tag and functions.
 
 
 Quick help anyone?
 
 
 -Novak
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: application.cfm and session variable

2003-12-05 Thread d.a.collie
Tony wrote:
 doesn't matter on windows servers.
 Capital A that is.

Should always have a capital regardless of platform... wot if you moved
it... should be shouting about best practices on the list.

Your app may get moved to a *nix box later and then your application.cfm
would break

-- 
-dc
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: cfmail pre-formatting

2003-12-05 Thread Justin Hansen
What I like to do is use chr(10) and format the entire email as in one string. Then just output the string inside the cfmail tags. This way you get total control of the output and your cf tags/logic do not add to the white space in the text you are trying to email.

Justin Hansen
Project Manager
Uhlig Communications

[EMAIL PROTECTED]

-Original Message-
From: MILAN MUSHRAN [mailto:[EMAIL PROTECTED]
Sent: Friday, December 05, 2003 8:38 AM
To: CF-Talk
Subject: Re:cfmail pre-formatting

Use ASCII code #Chr(13)#  #Chr(10)# (which is equivalent to BR).Use 
#Chr(13)#  #Chr(10)# for a new line in text email and use BR (as you 
already have) for HTML emails.

From: cf coder [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Re:cfmail pre-formatting
Date: Fri, 05 Dec 2003 09:26:33 -0400

so what are you saying?

This code is fine for HTML supported email servers, but not when it is text
 supported only.
 
 
 From: cf coder [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Subject: Re:cfmail pre-formatting
 Date: Fri, 05 Dec 2003 09:05:53 -0400
 
 thank you all for your suggestions. This code does the job.
 
 cfmail to=[EMAIL PROTECTED]
 from=#frommail#
 subject=Order
 server=someserver
 port=25
 type=HTML
 
 Any Comments=#AnyComments# br
 cfif shoppingBasket neq 0Shopping Basket=#shoppingBasket# br/cfif
 cfif username neq 0User Name=#username#br/cfif
 
 /cfmail
 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Making JavaScript Wait.

2003-12-05 Thread Justin Hansen
to js wait setTimeout(functionCall(),1000);

-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: Friday, December 05, 2003 8:47 AM
To: CF-Talk
Subject: OT: Making _javascript_ Wait.

I have a page that has upwards of 200 links on it that each will open a
detail screen in a new window with a _javascript_ function.This is a
calendar display showing all the events in a month with the ability to get
further details in a popup window by clicking on the event's name.

The problem, is that apparently the _javascript_ throws an object expected
error, if a link is clicked before the entire calendar page is rendered.It
is large enough, the this can take a full second or three to complete.

Is it possible to prevent this error?A better way to implement the code so
that it doesn't matter if the main window if fully rendered? Something to
cause the function to gracefully fail (no error message displayed) or not
run or wait if it's not ready to run correctly?Something else?

Thanks for any help.

function Popup(file,width,height)
{

var topX = (screen.width - width)/2;
var topY = (screen.height - height)/2;

popup = window.open(file, Popup, fullscreen=no, toolbar=no,
status=no, menubar=no, scrollbars=yes, resizable=yes, directories=no,
location=no, width=+width+, height=+height+, left=+topX+, top=+topY)
popup.focus();

return false;
}

--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

Confidentiality Notice:This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message. 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: application.cfm and session variable

2003-12-05 Thread Tony Weeg
not as long as I have control over them ... no reason to, and yes, it's a
best practice, so why not...but just to let those people out there know
that's its not NECESSARY.

that's all.

...tony

tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Friday, December 05, 2003 10:00 AM
To: CF-Talk
Subject: RE: application.cfm and session variable

Tony wrote:
 doesn't matter on windows servers.
 Capital A that is.

Should always have a capital regardless of platform... wot if you moved
it... should be shouting about best practices on the list.

Your app may get moved to a *nix box later and then your application.cfm
would break

--
-dc
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Application.cfm maybe

2003-12-05 Thread Mickael
Hello All,

I have a strange request.I have a site that would like to create certain content for search engines then have certain content in flash.My question is, is there a way to create a page and link it to a search engine, have the link appear on the search engine.But have some code at the bottom of the page direct the user to the actual flash page with related content.

I was thinking about CFLOCATION but would the crawler have time to read the page? Or the (now I forgot the name) page like application.cfm that run after each page is requested direct them to the content?

I am not trying to spam search engines I would just like to get flash content linked to search engines.

Mike
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




cfscript?

2003-12-05 Thread John Ho
hi all
I have a _javascript_ function checking the size of
window something like this

SCRIPT LANGUAGE=_javascript_ TYPE=text/_javascript_
function changeForm( ) { 
if ( screen.availWidth  800 ) {
return 800
}
 else {
return 1024
}
}

/SCRIPT

How do I call this function in CFscript?
Or do you know how to check for the size of window in
CFusionMX. Basicly I need to know what size of window
so I would use the cflocation to load the right form.
For example
cfif size IS 800
 cflocaiton url = "">
cfelse
 cflocaiton url = "">
/cfif

__
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: application.cfm and session variable

2003-12-05 Thread d.a.collie
Tony wrote:
 not as long as I have control over them ... 
 no reason to, and yes, it's a best practice, so why not...
 but just to let those people out there know that's its not NECESSARY.

Hehe... no worries, it's too late on Fri arvo here to get into a flame
war aboot this

Have a good one :-)

-- 

-dc
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: cfscript?

2003-12-05 Thread d.a.collie
You can't

JS is client side
cfscript is server side

-Original Message-
From: John Ho [mailto:[EMAIL PROTECTED] 
Sent: 05 December 2003 15:01
To: CF-Talk
Subject: cfscript?

hi all
I have a _javascript_ function checking the size of
window something like this

SCRIPT LANGUAGE=_javascript_ TYPE=text/_javascript_
function changeForm( ) { 
if ( screen.availWidth  800 ) {
return 800
}
 else {
return 1024
}
}

/SCRIPT

How do I call this function in CFscript?
Or do you know how to check for the size of window in CFusionMX. Basicly
I need to know what size of window so I would use the cflocation to load
the right form. For example
cfif size IS 800
 cflocaiton url = "">
cfelse
 cflocaiton url = "">
/cfif

__
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Generating Primary Key in Oracle (part 2)

2003-12-05 Thread Deanna Schneider
I haven't had a problem with it yet. The only problem I could imagine is
maxing out the sequence, but since they go pretty insanely high, and none of
our projects have that kind of total data accumulation, I haven't been
worried about that.

I suppose if you were doing a lot of transactions in the database, you might
run into some locking issues. But, we generally only have a web front end -
so we're not dealing with locked transactions at all.

-Deanna

- Original Message - 
From: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, December 05, 2003 8:53 AM
Subject: RE: Generating Primary Key in Oracle (part 2)

 Deanna wrote:
  I use a sequence, but I use the same sequence across an application.
  It cuts down on the number of objects I need to maintain, and makes
  it so that any one table probably doesn't have too many consecutive
  primary keys.

 That is very interesting I've always had a pk sequence for (just
 about) every table rather than just having one and using that
 everywhere.

 Ever come across a situation where this 'one sequence fits all' has
 tripped you up?

 Anyone else got any advantages/disadvantages with regards to this?


 -- 
 I now know how to delimit my sig :-)

 -dc


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Debugging CFQUERYPARAM

2003-12-05 Thread Rick Root
Tom Kitta wrote:

 Search the arhives of this group, we had a discussion about that some time
 ago and got a list of all known to work type translations for populard DBs.
 

I did search the archives (I'm a good mailing list user)...all I found 
was http://www.houseoffusion.com/cf_lists/cache.cfm/4/23/23083.htm and 
that doesn't really cover my problem.I also searched google.. for a 
variety of things.Searching formerant 6053 returns no meaningful 
results except one - a message on this list of a user that is having the 
same problem and got no responses 
(http://www.houseoffusion.com/lists.cfm/link=m:4:28384:142789)

My query is not complex... the datatypes I'm using are all varchar, 
char, and numeric.So I'm using CF_SQL_VARCHAR, CF_SQL_NUMERIC, and 
CF_SQL_CHAR.

I've checked and double checked the order of my parameters based on the 
debugging output, which I'll include and the error code means nothing.

ODBC Error Code = 94 ()
[MERANT][ODBC MySql driver]6053
SQL = INSERT INTO MEMBERS ( UNAME, PWORD, EMAIL, EMAIL_CONFIRMED, 
GENDER, FNAME, LNAME, MEMBER_SINCE, LAST_LOGIN, EMAIL_ANNOUNCE, ADDRESS, 
ADDRESS_HIDE, CITY, STATE, ZIP, COUNTRY, LOCATION_HIDE, PHONE, 
PHONE_HIDE, EMAIL_HIDE, REFERRAL ) VALUES ( ?, ?, ?, 0, ?, ?, ?, {d 
'2003-12-05'}, {d '2003-12-05'}, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )

Query Parameter Value(s) -
Parameter #1 = rickroot
Parameter #2 = password
Parameter #3 = [EMAIL PROTECTED]
Parameter #4 = 1
Parameter #5 = Rick
Parameter #6 = Root
Parameter #7 = 1
Parameter #8 =
Parameter #9 = 0
Parameter #10 =
Parameter #11 = NC
Parameter #12 =
Parameter #13 = US
Parameter #14 = 0
Parameter #15 =
Parameter #16 = 0
Parameter #17 = 0
Parameter #18 =

-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 04, 2003 9:46 PM
To: CF-Talk
Subject: Debugging CFQUERYPARAM
 
I hate CFQUERYPARAM.Why?Because debugging it seems to be a REAL pain
in the butt.
 
For example, I have a fairly length query with a lot of fields that are
being inserted.I recently attempted to convert it to use CFQUERYPARAM
(I currently am not using it, to my own risk).
 
Suddenly, I'm getting this error:
 

ODBC Error Code = 94 ()
[MERANT][ODBC MySql driver]6053

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Making JavaScript Wait.

2003-12-05 Thread Ian Skinner
I was hoping for something a little more intuitive then just making the
script wait one, or two or three, seconds every time.Because, often it
doesn't need to wait.This only is a problem if the user clicks a detail
screen while the page is still rendering.Once the page is done, they can
click links all they want, why make them wait then, when it is unnecessary.
Also, what if the page is really slow do to network traffic or other factors
beyond my control, at it takes more then the allotted wait time to render, I
could occasionally still get the error.

 
What I think might be best, is to check for the existence of the required
object, if unavailable, then don't allow the function to run, until it is
available.I just not skilled enough in my JS to figure out what object to
which the error is referring.Anybody give some insight into this?

-- 
Ian Skinner 
Web Programmer 
BloodSource 
www.BloodSource.org 
Sacramento, CA 

-Original Message-
From: Justin Hansen [mailto:[EMAIL PROTECTED]
Sent: Friday, December 05, 2003 6:57 AM
To: CF-Talk
Subject: RE: Making _javascript_ Wait.

to js wait setTimeout(functionCall(),1000);

-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: Friday, December 05, 2003 8:47 AM
To: CF-Talk
Subject: OT: Making _javascript_ Wait.

I have a page that has upwards of 200 links on it that each will open a
detail screen in a new window with a _javascript_ function.This is a
calendar display showing all the events in a month with the ability to get
further details in a popup window by clicking on the event's name.

The problem, is that apparently the _javascript_ throws an object expected
error, if a link is clicked before the entire calendar page is rendered.It
is large enough, the this can take a full second or three to complete.

Is it possible to prevent this error?A better way to implement the code so
that it doesn't matter if the main window if fully rendered? Something to
cause the function to gracefully fail (no error message displayed) or not
run or wait if it's not ready to run correctly?Something else?

Thanks for any help.

function Popup(file,width,height)
{

var topX = (screen.width - width)/2;
var topY = (screen.height - height)/2;

popup = window.open(file, Popup, fullscreen=no, toolbar=no,
status=no, menubar=no, scrollbars=yes, resizable=yes, directories=no,
location=no, width=+width+, height=+height+, left=+topX+, top=+topY)
popup.focus();

return false;
}

--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

Confidentiality Notice:This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message. 
_ 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: application.cfm and session variable

2003-12-05 Thread Tony Weeg
cheers mate, enjoy your Friday...

...tony

tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Friday, December 05, 2003 10:09 AM
To: CF-Talk
Subject: RE: application.cfm and session variable

Tony wrote:
 not as long as I have control over them ... 
 no reason to, and yes, it's a best practice, so why not...
 but just to let those people out there know that's its not NECESSARY.

Hehe... no worries, it's too late on Fri arvo here to get into a flame war
aboot this

Have a good one :-)

-- 

-dc
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Generating Primary Key in Oracle (part 2)

2003-12-05 Thread d.a.collie
Deanna wrote:
 The only problem I could imagine is maxing out the sequence, 
 but since they go pretty insanely high, and none of our projects 
 have that kind of total data accumulation, I haven't been worried 
 about that.

I like, I like.As you mention, wouldn't be able to do it all the time
but for a smaller app... I think I'd be well tempted to use :-)

-- 
-dc
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: cfscript?

2003-12-05 Thread Philip Arnold
You have to pass the data to the server first

Since you never know which client is running which request, you'd have
to send the data either in the URL, or in a form variable

Most things like this run a push page which detects which screen size
you have, and that then sends the request to the server which alters
things

I'm not sure if JS cookies are easily readable by CF, but that'd be
another option

 -Original Message-
 From: John Ho [mailto:[EMAIL PROTECTED]
 Sent: Friday, December 05, 2003 10:01 AM
 To: CF-Talk
 Subject: cfscript?


 hi all
 I have a _javascript_ function checking the size of
 window something like this

 SCRIPT LANGUAGE=_javascript_ TYPE=text/_javascript_
 function changeForm( ) {
if ( screen.availWidth  800 ) {
 return 800
 }
else {
 return 1024
 }
 }

 /SCRIPT

 How do I call this function in CFscript?
 Or do you know how to check for the size of window in
 CFusionMX. Basicly I need to know what size of window so I
 would use the cflocation to load the right form. For example
 cfif size IS 800
cflocaiton url = "">
 cfelse
cflocaiton url = "">
 /cfif


 __
 Do you Yahoo!?
 Free Pop-Up Blocker - Get it now
 http://companion.yahoo.com/

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




ListFind(Problems)

2003-12-05 Thread Bailey, Neal
Hey Guys,

I'm stuck and have been trying to figure this out all morning.

Here is what I have... 

CFSTOREDPROC procedure=LookUpAgentLinks datasource=Leads
CFPROCPARAM type=IN dbvarname=@EntityID value=#agEntityID#
cfsqltype=CF_SQL_CHAR
CFPROCPARAM type=IN dbvarname=@BtnType value=INSP 
cfsqltype=CF_SQL_VARCHAR
CFPROCRESULT name=InsPlans
/CFSTOREDPROC

cfquery name=Fusion_Content datasource=Leads
SELECT ID, Content_Name, Non_HTM_Desc
FROM Fusion_Content
ORDER BY ID ASC
/cfquery

!--- Create List from Database ---
cfset idlist = #Trim(valueList(InsPlans.BTNTYPE))#

--- Body HTML Form---

cfoutput query=Fusion_Content
 input type=checkbox name=ins#Fusion_Content.ID#  
 handleEnter(this, event) value=#Fusion_Content.ID#
 cfif listFind(idlist, Fusion_Content.ID) checked=checked/cfif
br 
/cfoutput

What I am trying to do is repeat the checkbox for each entry in the
Fusion_Content Table and then have the checkbox pre selected depending if
the values in the Stored Procedure (InsPlan) match. 

Basically I want the Check box to be pre selected if the user has already
chosen this in the past.

I know the idlist is working but for some reason when I do the
ListFind(idlist, Fusion_Content.ID) it only has the last item selected. 

For example if have a list like 10 ,20 ,90 only 90 is selected. 

If the list was 20 ,30 ,60 ,70 then 70 is selected. 

For some reason it's not selecting the others. 

Hope this makes sense. 

Thanks,
Neal Bailey
Internet Marketing Manager
UGA-Association Field Services
E-mail: [EMAIL PROTECTED]
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: cfscript?

2003-12-05 Thread Ian Skinner
To be a little more informative

 
You Can't EASILY

 
BecauseJS if client side and CFscript is server side.

 
To do something like this, you have to plan ahead.You would need to detect
the data with a JS like solution and then pass this data somehow (form, url)
to a server side action page that would then store and/or use the data as
you desire.In other words, it's a multiple page process.

 
HTH

-- 
Ian Skinner 
Web Programmer 
BloodSource 
www.BloodSource.org 
Sacramento, CA 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, December 05, 2003 7:12 AM
To: CF-Talk
Subject: RE: cfscript?

You can't

JS is client side
cfscript is server side

-Original Message-
From: John Ho [mailto:[EMAIL PROTECTED] 
Sent: 05 December 2003 15:01
To: CF-Talk
Subject: cfscript?

hi all
I have a _javascript_ function checking the size of
window something like this

SCRIPT LANGUAGE=_javascript_ TYPE=text/_javascript_
function changeForm( ) { 
if ( screen.availWidth  800 ) {
return 800
}
 else {
return 1024
}
}

/SCRIPT

How do I call this function in CFscript?
Or do you know how to check for the size of window in CFusionMX. Basicly
I need to know what size of window so I would use the cflocation to load
the right form. For example
cfif size IS 800
 cflocaiton url = "">
cfelse
 cflocaiton url = "">
/cfif

__
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/ http://companion.yahoo.com/
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Making JavaScript Wait.

2003-12-05 Thread Plunkett, Matt
If the calendar is in a separate frame/template, have a function onload that
sets a semaphore back in the links page.Until the semaphore is on, don't
allow links to be opened.

-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: Friday, December 05, 2003 9:47 AM
To: CF-Talk
Subject: OT: Making _javascript_ Wait.

I have a page that has upwards of 200 links on it that each will open a
detail screen in a new window with a _javascript_ function.This is a
calendar display showing all the events in a month with the ability to get
further details in a popup window by clicking on the event's name.

The problem, is that apparently the _javascript_ throws an object expected
error, if a link is clicked before the entire calendar page is rendered.It
is large enough, the this can take a full second or three to complete.

Is it possible to prevent this error?A better way to implement the code so
that it doesn't matter if the main window if fully rendered? Something to
cause the function to gracefully fail (no error message displayed) or not
run or wait if it's not ready to run correctly?Something else?

Thanks for any help.

function Popup(file,width,height)
{

var topX = (screen.width - width)/2;
var topY = (screen.height - height)/2;

popup = window.open(file, Popup, fullscreen=no, toolbar=no,
status=no, menubar=no, scrollbars=yes, resizable=yes, directories=no,
location=no, width=+width+, height=+height+, left=+topX+, top=+topY)
popup.focus();

return false;
}

--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

Confidentiality Notice:This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message. 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Debugging CFQUERYPARAM

2003-12-05 Thread Ian Skinner
Can you provide a copy of your CFML code of the errant query.That may
help.

-- 
Ian Skinner 
Web Programmer 
BloodSource 
www.BloodSource.org 
Sacramento, CA 

-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED]
Sent: Friday, December 05, 2003 7:10 AM
To: CF-Talk
Subject: Re: Debugging CFQUERYPARAM

Tom Kitta wrote:

 Search the arhives of this group, we had a discussion about that some time
 ago and got a list of all known to work type translations for populard
DBs.
 

I did search the archives (I'm a good mailing list user)...all I found 
was http://www.houseoffusion.com/cf_lists/cache.cfm/4/23/23083.htm
http://www.houseoffusion.com/cf_lists/cache.cfm/4/23/23083.htmand 
that doesn't really cover my problem.I also searched google.. for a 
variety of things.Searching formerant 6053 returns no meaningful 
results except one - a message on this list of a user that is having the 
same problem and got no responses 
(http://www.houseoffusion.com/lists.cfm/link=m:4:28384:142789)

My query is not complex... the datatypes I'm using are all varchar, 
char, and numeric.So I'm using CF_SQL_VARCHAR, CF_SQL_NUMERIC, and 
CF_SQL_CHAR.

I've checked and double checked the order of my parameters based on the 
debugging output, which I'll include and the error code means nothing.

ODBC Error Code = 94 ()
[MERANT][ODBC MySql driver]6053
SQL = INSERT INTO MEMBERS ( UNAME, PWORD, EMAIL, EMAIL_CONFIRMED, 
GENDER, FNAME, LNAME, MEMBER_SINCE, LAST_LOGIN, EMAIL_ANNOUNCE, ADDRESS, 
ADDRESS_HIDE, CITY, STATE, ZIP, COUNTRY, LOCATION_HIDE, PHONE, 
PHONE_HIDE, EMAIL_HIDE, REFERRAL ) VALUES ( ?, ?, ?, 0, ?, ?, ?, {d 
'2003-12-05'}, {d '2003-12-05'}, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )

Query Parameter Value(s) -
Parameter #1 = rickroot
Parameter #2 = password
Parameter #3 = [EMAIL PROTECTED]
Parameter #4 = 1
Parameter #5 = Rick
Parameter #6 = Root
Parameter #7 = 1
Parameter #8 =
Parameter #9 = 0
Parameter #10 =
Parameter #11 = NC
Parameter #12 =
Parameter #13 = US
Parameter #14 = 0
Parameter #15 =
Parameter #16 = 0
Parameter #17 = 0
Parameter #18 =

-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 04, 2003 9:46 PM
To: CF-Talk
Subject: Debugging CFQUERYPARAM
 
I hate CFQUERYPARAM.Why?Because debugging it seems to be a REAL pain
in the butt.
 
For example, I have a fairly length query with a lot of fields that are
being inserted.I recently attempted to convert it to use CFQUERYPARAM
(I currently am not using it, to my own risk).
 
Suddenly, I'm getting this error:
 

ODBC Error Code = 94 ()
[MERANT][ODBC MySql driver]6053
 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Application.cfm maybe

2003-12-05 Thread Jochem van Dieten
Mickael wrote:
 
 I have a site that would like to create certain content for search engines then have certain content in flash.My question is, is there a way to create a page and link it to a search engine, have the link appear on the search engine.But have some code at the bottom of the page direct the user to the actual flash page with related content.

Why not put the content of your site in the content of your object:

object ...
param ...
param ...
Put the content here. It will be seen by the crawler.
Additionally, this is great for accessibility.
/object

That is the way object is supposed to be used.

Jochem

-- 
When you don't want to be surprised by the revolution
organize one yourself
- Loesje
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: cfscript?

2003-12-05 Thread Tony Weeg
yeah, you can set a screen size cookie, in js, then on the cf processing,
read that cookie, and go from there.

...tony

tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337

-Original Message-
From: Philip Arnold [mailto:[EMAIL PROTECTED] 
Sent: Friday, December 05, 2003 10:17 AM
To: CF-Talk
Subject: RE: cfscript?

You have to pass the data to the server first

Since you never know which client is running which request, you'd have to
send the data either in the URL, or in a form variable

Most things like this run a push page which detects which screen size you
have, and that then sends the request to the server which alters things

I'm not sure if JS cookies are easily readable by CF, but that'd be another
option

 -Original Message-
 From: John Ho [mailto:[EMAIL PROTECTED]
 Sent: Friday, December 05, 2003 10:01 AM
 To: CF-Talk
 Subject: cfscript?


 hi all
 I have a _javascript_ function checking the size of window something 
 like this

 SCRIPT LANGUAGE=_javascript_ TYPE=text/_javascript_ function 
 changeForm( ) {
if ( screen.availWidth  800 ) {
 return 800
 }
else {
 return 1024
 }
 }

 /SCRIPT

 How do I call this function in CFscript?
 Or do you know how to check for the size of window in CFusionMX. 
 Basicly I need to know what size of window so I would use the 
 cflocation to load the right form. For example
 cfif size IS 800
cflocaiton url = "">
 cfelse
cflocaiton url = "">
 /cfif


 __
 Do you Yahoo!?
 Free Pop-Up Blocker - Get it now
 http://companion.yahoo.com/

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Debugging CFQUERYPARAM

2003-12-05 Thread Charlie Griefer
Hi Rick:

The thread Tom's referring to can be found at http://www.mail-archive.com/[EMAIL PROTECTED]/msg157166.html

Based on that, Sam Neff was good enough to put together the following page, http://www.blinex.com/~sam/CF_SQL_TYPES.cfm , that displays cfsqltypes with their corresponding datatypes in various databases.

As far as your error message, below...the obvious question to ask (and sorry to do it, but you know it has to be asked) is...you have a few empty values.does your database accept null values/empty strings for those columns?

charlie

- Original Message - 
From: Rick Root 
To: CF-Talk 
Sent: Friday, December 05, 2003 8:09 AM
Subject: Re: Debugging CFQUERYPARAM

Tom Kitta wrote:

 Search the arhives of this group, we had a discussion about that some time
 ago and got a list of all known to work type translations for populard DBs.
 

I did search the archives (I'm a good mailing list user)...all I found 
was http://www.houseoffusion.com/cf_lists/cache.cfm/4/23/23083.htm and 
that doesn't really cover my problem.I also searched google.. for a 
variety of things.Searching formerant 6053 returns no meaningful 
results except one - a message on this list of a user that is having the 
same problem and got no responses 
(http://www.houseoffusion.com/lists.cfm/link=m:4:28384:142789)

My query is not complex... the datatypes I'm using are all varchar, 
char, and numeric.So I'm using CF_SQL_VARCHAR, CF_SQL_NUMERIC, and 
CF_SQL_CHAR.

I've checked and double checked the order of my parameters based on the 
debugging output, which I'll include and the error code means nothing.

ODBC Error Code = 94 ()
[MERANT][ODBC MySql driver]6053
SQL = INSERT INTO MEMBERS ( UNAME, PWORD, EMAIL, EMAIL_CONFIRMED, 
GENDER, FNAME, LNAME, MEMBER_SINCE, LAST_LOGIN, EMAIL_ANNOUNCE, ADDRESS, 
ADDRESS_HIDE, CITY, STATE, ZIP, COUNTRY, LOCATION_HIDE, PHONE, 
PHONE_HIDE, EMAIL_HIDE, REFERRAL ) VALUES ( ?, ?, ?, 0, ?, ?, ?, {d 
'2003-12-05'}, {d '2003-12-05'}, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )

Query Parameter Value(s) -
Parameter #1 = rickroot
Parameter #2 = password
Parameter #3 = [EMAIL PROTECTED]
Parameter #4 = 1
Parameter #5 = Rick
Parameter #6 = Root
Parameter #7 = 1
Parameter #8 =
Parameter #9 = 0
Parameter #10 =
Parameter #11 = NC
Parameter #12 =
Parameter #13 = US
Parameter #14 = 0
Parameter #15 =
Parameter #16 = 0
Parameter #17 = 0
Parameter #18 =

-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 04, 2003 9:46 PM
To: CF-Talk
Subject: Debugging CFQUERYPARAM
 
I hate CFQUERYPARAM.Why?Because debugging it seems to be a REAL pain
in the butt.
 
For example, I have a fairly length query with a lot of fields that are
being inserted.I recently attempted to convert it to use CFQUERYPARAM
(I currently am not using it, to my own risk).
 
Suddenly, I'm getting this error:
 

ODBC Error Code = 94 ()
[MERANT][ODBC MySql driver]6053

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Debugging CFQUERYPARAM

2003-12-05 Thread Tom Kitta
I meant looking up information about cfqueryparam tag itself. A lot of
strange errors can be explained by using the wrong types. Even if you think
you are using a correct type, you may not be. One of group users created a
whole table with all type listing.

I see you are having some dates in there as well as numbers so things might
be tricky (for dates use CF_SQL_TIMESTAMP not date or time alternatives).
Also, what DB are you using? I didn't have to many problems myself with SQL
server 2000 except for the type translation (in fact this question prompted
me to join this mailing list). Also the version of CF you are using might be
a factor, I know it works fine under MX, didn't try it under 5.0. I know
that some DB engines don't support parameter binding.

If all else fails just shrink the query and see at what point it starts to
work, this way you find the problem. I know this is time consuming, but use
it as a last resort.

Hope this helps,

TK
-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED]
Sent: Friday, December 05, 2003 10:10 AM
To: CF-Talk
Subject: Re: Debugging CFQUERYPARAM

Tom Kitta wrote:

 Search the arhives of this group, we had a discussion about that some
time
 ago and got a list of all known to work type translations for populard
DBs.


I did search the archives (I'm a good mailing list user)...all I found
was http://www.houseoffusion.com/cf_lists/cache.cfm/4/23/23083.htm and
that doesn't really cover my problem.I also searched google.. for a
variety of things.Searching formerant 6053 returns no meaningful
results except one - a message on this list of a user that is having the
same problem and got no responses
(http://www.houseoffusion.com/lists.cfm/link=m:4:28384:142789)

My query is not complex... the datatypes I'm using are all varchar,
char, and numeric.So I'm using CF_SQL_VARCHAR, CF_SQL_NUMERIC, and
CF_SQL_CHAR.

I've checked and double checked the order of my parameters based on the
debugging output, which I'll include and the error code means nothing.

ODBC Error Code = 94 ()
[MERANT][ODBC MySql driver]6053
SQL = INSERT INTO MEMBERS ( UNAME, PWORD, EMAIL, EMAIL_CONFIRMED,
GENDER, FNAME, LNAME, MEMBER_SINCE, LAST_LOGIN, EMAIL_ANNOUNCE, ADDRESS,
ADDRESS_HIDE, CITY, STATE, ZIP, COUNTRY, LOCATION_HIDE, PHONE,
PHONE_HIDE, EMAIL_HIDE, REFERRAL ) VALUES ( ?, ?, ?, 0, ?, ?, ?, {d
'2003-12-05'}, {d '2003-12-05'}, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )

Query Parameter Value(s) -
Parameter #1 = rickroot
Parameter #2 = password
Parameter #3 = [EMAIL PROTECTED]
Parameter #4 = 1
Parameter #5 = Rick
Parameter #6 = Root
Parameter #7 = 1
Parameter #8 =
Parameter #9 = 0
Parameter #10 =
Parameter #11 = NC
Parameter #12 =
Parameter #13 = US
Parameter #14 = 0
Parameter #15 =
Parameter #16 = 0
Parameter #17 = 0
Parameter #18 =

-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 04, 2003 9:46 PM
To: CF-Talk
Subject: Debugging CFQUERYPARAM

I hate CFQUERYPARAM.Why?Because debugging it seems to be a REAL
pain
in the butt.

For example, I have a fairly length query with a lot of fields that
are
being inserted.I recently attempted to convert it to use
CFQUERYPARAM
(I currently am not using it, to my own risk).

Suddenly, I'm getting this error:


ODBC Error Code = 94 ()
[MERANT][ODBC MySql driver]6053

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: application.cfm and session variable

2003-12-05 Thread Hassan Arteaga Rodriguez
Use before set the variable session.doesUserHavePermissionsthe
function IsDefined or define it with a cfparam tag

 
Regards,

__
MSc. Hassan Arteaga Rodrguez
Microsoft Certified System Engineer.
DIGI- Grupo de Desarrollo
COPEXTEL, S.A.

-Original Message-
From: cf coder [mailto:[EMAIL PROTECTED] 
Sent: Friday, December 05, 2003 08:20 AM
To: CF-Talk
Subject: application.cfm and session variable

I am having a strange problem. I created an
application.cfm file on the webroot and have declared
few session variables.

CFAPPLICATION NAME=NApp
CLIENTMANAGEMENT=Yes
SESSIONMANAGEMENT=Yes
SETCLIENTCOOKIES=No
SESSIONTIMEOUT=#CreateTimeSpan(0,0,30,0)#

I have a cfldap tag wrapped around try/catch blocks in
my application.cfm file that authenticates the user.

CFSET VALID = 0

cftry
cfldap
action="">
name=authUser
server=ldapServer
start=dc=uk
filter=(uid=cfcoder) 
attributes=cn,givenname,sn,mail
scope=subtree
port=389

cfcatch type=any
CFSET VALID = 1
/cfcatch

/cftry

cfif VALID IS 0 
 cfif isDefined(authUser) and authUser.cn neq

cflock scope=SESSION timeout=30
type=EXCLUSIVE
cfset session.doesUserHavePermissions = True
/cflock
 /cfif
/cfif

/CFIF

Now when I refer to this session variable in another
file, I get an error, it says the session variable is
not defined. I thought whenever a .cfm file is called,
the CF Server does a search for the application.cfm
file and initializes the application and all scoped
variables. I also added a cfdump line in the
application file, dumping the results from the ldap
query and dumping session variables.

When I view the cfm file on the browser I don't see no
dump, just get the msg that the session variable is
not defined. Don't know what's
happening, can somebody you please help?

Thanks
CF Coder

__
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/ 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: ListFind(Problems)

2003-12-05 Thread Raymond Camden
Is your list really X(space),Y(space),Z? If so, the issue is that X is not
the same as X(space).
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: ListFind(Problems)

2003-12-05 Thread Jerry Johnson
I always write my checkbox selected as:

input type=checkbox CHECKED

rather than the 

input type=checkbox checked=checked

as you have.

Jerry Johnson

 [EMAIL PROTECTED] 12/05/03 10:11AM 
Hey Guys,

I'm stuck and have been trying to figure this out all morning.

Here is what I have... 

CFSTOREDPROC procedure=LookUpAgentLinks datasource=Leads
CFPROCPARAM type=IN dbvarname=@EntityID value=#agEntityID#
cfsqltype=CF_SQL_CHAR
CFPROCPARAM type=IN dbvarname=@BtnType value=INSP 
cfsqltype=CF_SQL_VARCHAR
CFPROCRESULT name=InsPlans
/CFSTOREDPROC

cfquery name=Fusion_Content datasource=Leads
SELECT ID, Content_Name, Non_HTM_Desc
FROM Fusion_Content
ORDER BY ID ASC
/cfquery

!--- Create List from Database ---
cfset idlist = #Trim(valueList(InsPlans.BTNTYPE))#

--- Body HTML Form---

cfoutput query=Fusion_Content
 input type=checkbox name=ins#Fusion_Content.ID#  
 handleEnter(this, event) value=#Fusion_Content.ID#
 cfif listFind(idlist, Fusion_Content.ID) checked=checked/cfif
br 
/cfoutput

What I am trying to do is repeat the checkbox for each entry in the
Fusion_Content Table and then have the checkbox pre selected depending if
the values in the Stored Procedure (InsPlan) match. 

Basically I want the Check box to be pre selected if the user has already
chosen this in the past.

I know the idlist is working but for some reason when I do the
ListFind(idlist, Fusion_Content.ID) it only has the last item selected. 

For example if have a list like 10 ,20 ,90 only 90 is selected. 

If the list was 20 ,30 ,60 ,70 then 70 is selected. 

For some reason it's not selecting the others. 

Hope this makes sense. 

Thanks,
Neal Bailey
Internet Marketing Manager
UGA-Association Field Services
E-mail: [EMAIL PROTECTED]
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Application.cfm maybe

2003-12-05 Thread Mickael
Hi Jochem,

Does object work only for flash pages or can I use this to migrate visitors from older pages to new non flash pages?
- Original Message - 
From: Jochem van Dieten 
To: CF-Talk 
Sent: Friday, December 05, 2003 10:37 AM
Subject: Re: Application.cfm maybe

Mickael wrote:
 
 I have a site that would like to create certain content for search engines then have certain content in flash.My question is, is there a way to create a page and link it to a search engine, have the link appear on the search engine.But have some code at the bottom of the page direct the user to the actual flash page with related content.

Why not put the content of your site in the content of your object:

object ...
param ...
param ...
Put the content here. It will be seen by the crawler.
Additionally, this is great for accessibility.
/object

That is the way object is supposed to be used.

Jochem

-- 
When you don't want to be surprised by the revolution
organize one yourself
 - Loesje
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: cfscript?

2003-12-05 Thread Tangorre, Michael
If all you want to do is redirect based on screen size, use JS as you are
and do a 

 
var x = screen width //pseudo code

 
if x = 800{
 document.location=form800.cfm;
}
else{
 document.location=form1024.cfm;
}

Mike

 cfif size IS 800
cflocaiton url = "">
 cfelse
cflocaiton url = "">
 /cfif
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: [cftalk] About CFChart..

2003-12-05 Thread Hassan Arteaga Rodriguez
Hi Allan:

 
Sorry for this late email but i had problems with my ISP.
About CFChart i fixed the problem re-installing CF Server MX 6.1...Now
all works fine.

 
Thanks

__
MSc. Hassan Arteaga Rodrguez
Microsoft Certified System Engineer.
DIGI- Grupo de Desarrollo
COPEXTEL, S.A.

-Original Message-
From: Allan Cliff [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, December 03, 2003 04:11 AM
To: CF-Talk
Subject: RE: [cftalk] About CFChart..

You have this:

D:\WEB_Datais my root dir for web sites...then i have GraphData.cfm in
D:\WEB_Data\CFIDE\GraphData.cfm

This is fine as far as I can see.

In IIS you need to set up.

New Website (i.e. www.mysite.com)
Then inside that set up you need to create 2 virtual directories

CFIDE -- D:\WEB_Data\CFIDE
JRunScripts -- C:\CFusionMX\runtime\lid\wsconfig\1 (or your equivalent)

You have already created the dummy GraphData.cfm file so

restart IIS and restart CFMX and try now.

Allan

- Original Message - 
From: Hassan Arteaga Rodriguez 
To: CF-Talk 
Sent: Tuesday, December 02, 2003 5:18 PM
Subject: RE: [cftalk] About CFChart..

Allan:

D:\WEB_Datais my root dir for web sites...then i have GraphData.cfm in
D:\WEB_Data\CFIDE\GraphData.cfm

It's correct?

Allan:If I put this code in my cf page 

cfchart format=jpg chartheight=500 chartwidth=650
showxgridlines=no showygridlines=no showborder=yes fontbold=no
fontitalic=no show3d=yes rotated=no sortxaxis=no showlegend=no
showmarkers=no 
cfchartseries type=bar query=RsInfo itemcolumn=pub_name
valuecolumn=pub_id
/cfchart

I get as output this..

IMG SRC="">
id=Images_12_JPG name=Images_12_JPG
usemap="" border=0

with the map above..
My question how can i control this output ? Because i know
SRC="" show
anything in the browser..because Images/12.jpg is not created inside
images dir where is running my cf page

cold u run some example of a single chart and send me the html code
output?

Thanks 

__
MSc. Hassan Arteaga Rodrguez
Microsoft Certified System Engineer.
DIGI- Grupo de Desarrollo
COPEXTEL, S.A.

-Original Message-
From: Allan Cliff [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 02, 2003 09:03 AM
To: CF-Talk
Subject: Re: [cftalk] About CFChart..

C:\Inetpub\wwwroot\CFIDE\GraphData.cfm

Then restart cfmx service then try.

Allan
- Original Message - 
From: Hassan Arteaga Rodriguez 
To: CF-Talk 
Sent: Tuesday, December 02, 2003 4:51 PM
Subject: RE: [cftalk] About CFChart..

I created it..the same problem!!

__
MSc. Hassan Arteaga Rodrguez
Microsoft Certified System Engineer.
DIGI- Grupo de Desarrollo
COPEXTEL, S.A.

-Original Message-
From: Allan Cliff [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 02, 2003 08:47 AM
To: CF-Talk
Subject: Re: [cftalk] About CFChart..

You need to make a GraphData.cfm file in the cfide directory.

Just make it an empty file with that EXACT name

Allan

- Original Message - 
 From: Hassan Arteaga Rodriguez 
 To: CF-Talk 
 Sent: Tuesday, December 02, 2003 4:15 PM
 Subject: [cftalk] About CFChart..

 Hi all:

 I'm trying to make a simple chart just to test cfchart tag. But i
had
 many problems with that.
 Now when i take out the name in cfchart apear in the browser an
symbol
 as a missing image.

 When i look at the HTML code i have this:
 .
 .
 .
 Normal html hearder 
 .
 .
 some map with the name Images_100012_JPG_map
 .
 .
 .
 And this img tag
 IMG SRC="">
 id=Images_100012_JPG name=Images_100012_JPG
 usemap="" border=0
 .
 .

 When i search in CFIDE dir for GraphData.cfm file...the file is
missing.

 Help please
 Regards, 

 __

 MSc. Hassan Arteaga Rodrguez
 Microsoft Certified System Engineer.
 DIGI- Grupo de Desarrollo
 COPEXTEL, S.A. 
 _ 
_ 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: ListFind(Problems)

2003-12-05 Thread Tangorre, Michael
NOTXHTML format:

 
input type=checkbox CHECKED

 
XHTML format:

 
input type=checkbox checked=checked

 
If your doctype is xhtml then you need the latter.

 
Mike
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: ListFind(Problems)

2003-12-05 Thread Bailey, Neal
Yeah it has a space after it but I tried to Trim it off or replace it with a
, and still I can't get it to work same result. Also it will find the last
item in the list but it's not recognizing the other elements. I'm missing
something simple. It's the simple things that really mess me up sometimes. 

Neal Bailey
Internet Marketing Manager
UGA-Association Field Services
E-mail:mailto:[EMAIL PROTECTED] [EMAIL PROTECTED]

From: Raymond Camden [mailto:[EMAIL PROTECTED] 
Sent: Friday, December 05, 2003 9:51 AM
To: CF-Talk
Subject: RE: ListFind(Problems)

 
Is your list really X(space),Y(space),Z? If so, the issue is that X is not
the same as X(space).
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Application.cfm maybe

2003-12-05 Thread Jochem van Dieten
Mickael wrote:
 
 Does object work only for flash pages or can I use this to migrate visitors from older pages to new non flash pages?

Since I don't understand the question, I will let you figure it 
out yourself: http://www.w3.org/TR/html401/struct/objects.html

Jochem

-- 
When you don't want to be surprised by the revolution
organize one yourself
- Loesje
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: ListFind(Problems)

2003-12-05 Thread Bailey, Neal
Ok thanks,

 
But it works both ways. And I still have this issue... Can any one think of
a better way to have dynamic checkboxes pre-selected? Maybe I need to
approach this ad a different angle. 

 
Neal Bailey
Internet Marketing Manager
UGA-Association Field Services
E-mail:mailto:[EMAIL PROTECTED] [EMAIL PROTECTED]

-Original Message-
From: Jerry Johnson [mailto:[EMAIL PROTECTED] 
Sent: Friday, December 05, 2003 9:58 AM
To: CF-Talk
Subject: Re: ListFind(Problems)

 
I always write my checkbox selected as:

input type=checkbox CHECKED

rather than the 

input type=checkbox checked=checked

as you have.

Jerry Johnson

 [EMAIL PROTECTED] 12/05/03 10:11AM 
Hey Guys,

I'm stuck and have been trying to figure this out all morning.

Here is what I have... 

CFSTOREDPROC procedure=LookUpAgentLinks datasource=Leads
CFPROCPARAM type=IN dbvarname=@EntityID value=#agEntityID#
cfsqltype=CF_SQL_CHAR
CFPROCPARAM type=IN dbvarname=@BtnType value=INSP 
cfsqltype=CF_SQL_VARCHAR
CFPROCRESULT name=InsPlans
/CFSTOREDPROC

cfquery name=Fusion_Content datasource=Leads
SELECT ID, Content_Name, Non_HTM_Desc
FROM Fusion_Content
ORDER BY ID ASC
/cfquery

!--- Create List from Database ---
cfset idlist = #Trim(valueList(InsPlans.BTNTYPE))#

--- Body HTML Form---

cfoutput query=Fusion_Content
 input type=checkbox name=ins#Fusion_Content.ID#  
 handleEnter(this, event) value=#Fusion_Content.ID#
 cfif listFind(idlist, Fusion_Content.ID) checked=checked/cfif
br 
/cfoutput

What I am trying to do is repeat the checkbox for each entry in the
Fusion_Content Table and then have the checkbox pre selected depending if
the values in the Stored Procedure (InsPlan) match. 

Basically I want the Check box to be pre selected if the user has already
chosen this in the past.

I know the idlist is working but for some reason when I do the
ListFind(idlist, Fusion_Content.ID) it only has the last item selected. 

For example if have a list like 10 ,20 ,90 only 90 is selected. 

If the list was 20 ,30 ,60 ,70 then 70 is selected. 

For some reason it's not selecting the others. 

Hope this makes sense. 

Thanks,
Neal Bailey
Internet Marketing Manager
UGA-Association Field Services
E-mail: [EMAIL PROTECTED]
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Debugging CFQUERYPARAM

2003-12-05 Thread Jochem van Dieten
Charlie Griefer wrote:
 
 does your database accept null values/empty strings for those columns?

MySQL does not enforce NOT NULL constraints even if they exist.

Jochem

-- 
When you don't want to be surprised by the revolution
organize one yourself
- Loesje
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Generating Primary Key in Oracle (part 2)

2003-12-05 Thread Mike Kear
An example of where a common seq would cause problems is if the seq number
becomes an invoice number, and the audit trail requires that every number in
a sequence be accounted for.This is pretty outmoded thinking now, but some
auditors still stick to the rule - I want to see every invoice,IN
SEQUENCE, filed in those binders there to verify they are all accounted
for.



Cheers,

Michael Kear

Windsor, NSW, Australia

AFP Webworks.





-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Saturday, 6 December 2003 1:54 AM
To: CF-Talk
Subject: RE: Generating Primary Key in Oracle (part 2)

Deanna wrote:
 I use a sequence, but I use the same sequence across an application. 
 It cuts down on the number of objects I need to maintain, and makes 
 it so that any one table probably doesn't have too many consecutive 
 primary keys.

That is very interesting I've always had a pk sequence for (just
about) every table rather than just having one and using that
everywhere.

Ever come across a situation where this 'one sequence fits all' has
tripped you up?

Anyone else got any advantages/disadvantages with regards to this?

-- 
I now know how to delimit my sig :-)

-dc

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




Oracle Stored Procs Returning Arrays?

2003-12-05 Thread Stacy Young
Has anyone ever had to handle a stored proc returning a series of Oracle
arrays rather than a recordset? There's an example for CF4 on MM's site
but so far we haven't been able to get it to work under cfmx61.

http://www.macromedia.com/support/coldfusion/ts/documents/tn17938.htm

Any insight appreciated!

Stace


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

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




Comparing two arrays...

2003-12-05 Thread Tyler Silcox
I was searching for a way to uniquely identify a each position in an array,
and in the following post, it looks like the snippet should do exactly what
I want. But, I'm getting mixed results with Results() and HashCode().Are
their any limits to these functions? I.e.: can you not call them on
dynamically generated arrays or structs? Is there a length limit, etc?

 
I'm trying:

 
if(CurrentPosition GT 1){

 
WriteOutput(CurrentNode[Trace][CurrentPosition]Equals(CurrentNode[Trace]
[CurrentPosition - 1])  br /);
}

 
CurrentNode is set to a specific structure in a much larger structure before
this, and CurrentNode[Trace] is an array, where CurrentPosition is the
CurrentPosition, which has already been set.

 
I'm getting a Complex object types cannot be converted to simple values.
error.And this same syntax works with simple values: 

 
cfscript
a=ArrayNew(1);
a[1]=one;
a[2]=two;
/cfscript

 
#a[1]Equals(a[2])#

 
One more thing, when I run:

 
CurrentNode[Trace][CurrentPosition].HashCode() ...it outputs 0?

 
Any ideas?

 
TIA for any help you can provide-

 
Tyler

 
_

Matt wrote:

 
cfscript
 foo = StructNew();
 foo.a = b;
 foo.b = a;
 WriteOutput(foo.hashCode());
/cfscript

 
Also, I have included more information on how the hashCode is generated
below.

 
public int hashCode()
Returns the hash code value for this map. The hash code of a map is
defined to be the sum of the hash codes of each entry in the map's
entrySet() view. This ensures that t1.equals(t2) implies that
t1.hashCode()==t2.hashCode() for any two maps t1 and t2, as required by
the general contract of Object.hashCode.

 
This implementation iterates over entrySet(), calling hashCode on each
element (entry) in the Collection, and adding up the results.

 
Specified by: hashCode in interface Map
Overrides: hashCode in class Object
Returns: the hash code value for this map.
See Also: Map.Entry.hashCode(), Object.hashCode(),
Object.equals(Object), Set.equals(Object)

 
Matt Liotta
President  CEO
Montara Software, Inc.
 http://www.montarasoftware.com/ http://www.montarasoftware.com/
V: 415-577-8070
F: 415-341-8906
P:mailto:[EMAIL PROTECTED]
[EMAIL PROTECTED]
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re:application.cfm and session variable

2003-12-05 Thread cf coder
Cheers everybody for your suggestions. What I did was save the cfm file with a different name, ran it on the browser and just like magic, it calls the application.cfm and the session variable has a value set to it. I don't know why I was getting an error when I tried to run the original .cfm file, but just so you know, the original file had a very long name with a lot of underscores, I saved it as something else with a short name wihtout underscores and it all works. Don't know if this is a coldfusion bug

cheers mate, enjoy your Friday...

...tony

tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Friday, December 05, 2003 10:09 AM
To: CF-Talk
Subject: RE: application.cfm and session variable

Tony wrote:
 not as long as I have control over them ... 
 no reason to, and yes, it's a best practice, so why not...
 but just to let those people out there know that's its not NECESSARY.

Hehe... no worries, it's too late on Fri arvo here to get into a flame war
aboot this

Have a good one :-)

-- 

-dc

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: ListFind(Problems)

2003-12-05 Thread Jerry Johnson
Well, aren't _we_ fancy?

Just kidding. 

That's good to know.

I'm still trying to get my collection of legacy documents to validate as HTML!

500,000 down, 150,000 to go.

Jerry (Sisyphus) Johnson

 [EMAIL PROTECTED] 12/05/03 11:02AM 
NOTXHTML format:

 
input type=checkbox CHECKED

 
XHTML format:

 
input type=checkbox checked=checked

 
If your doctype is xhtml then you need the latter.

 
Mike
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: ListFind(Problems)

2003-12-05 Thread Bailey, Neal
Ok I think I figured this out kind of... 

 
It does seem to be a Spacing problem but I am still having an issue with
trying to remove the trailing spaces. I am using Trim() but it does not seem
to be doing anything. Could this be because I'm pulling this from a Stored
Procedure?

 
Here is how I'm trimming it...

 
cfset idlist=#Trim(valueList(InsPlans.BTNTYPE))#

Neal Bailey
Internet Marketing Manager
UGA-Association Field Services
E-mail:mailto:[EMAIL PROTECTED] [EMAIL PROTECTED]

 
-Original Message-
From: Bailey, Neal [mailto:[EMAIL PROTECTED] 
Sent: Friday, December 05, 2003 10:05 AM
To: CF-Talk
Subject: RE: ListFind(Problems)

 
Yeah it has a space after it but I tried to Trim it off or replace it with a
, and still I can't get it to work same result. Also it will find the last
item in the list but it's not recognizing the other elements. I'm missing
something simple. It's the simple things that really mess me up sometimes. 

Neal Bailey
Internet Marketing Manager
UGA-Association Field Services
E-mail:mailto:[EMAIL PROTECTED] [EMAIL PROTECTED]

From: Raymond Camden [mailto:[EMAIL PROTECTED] 
Sent: Friday, December 05, 2003 9:51 AM
To: CF-Talk
Subject: RE: ListFind(Problems)

Is your list really X(space),Y(space),Z? If so, the issue is that X is not
the same as X(space).
_
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Debugging CFQUERYPARAM

2003-12-05 Thread Charlie Griefer
i've never used mySQL...just seemed like the question to ask, based on the information presented: )

charlie

- Original Message - 
From: Jochem van Dieten 
To: CF-Talk 
Sent: Friday, December 05, 2003 9:16 AM
Subject: Re: Debugging CFQUERYPARAM

Charlie Griefer wrote:
 
 does your database accept null values/empty strings for those columns?

MySQL does not enforce NOT NULL constraints even if they exist.

Jochem

-- 
When you don't want to be surprised by the revolution
organize one yourself
 - Loesje
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: ListFind(Problems)

2003-12-05 Thread Raymond Camden
Can you show me agian how you are generating your list? At worst, this
should work:

cfset list = replace(list,, ,,,all)
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: RE: ListFind(Problems)

2003-12-05 Thread ksuh
Actually, the xml format would be:

input type=checkbox checked=checked/

There are probably some required attributes as well (id, most likely).

- Original Message -
From: Tangorre, Michael [EMAIL PROTECTED]
Date: Friday, December 5, 2003 9:02 am
Subject: RE: ListFind(Problems)

 NOTXHTML format:
 
 input type=checkbox CHECKED
 
 XHTML format:
 
 input type=checkbox checked=checked
 
 If your doctype is xhtml then you need the latter.
 
 Mike 
 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




question about which memory scope to load cfc's

2003-12-05 Thread Michael Hodgdon
I am working with a website structure that will have five to seven separate applications.As I start to plan which CFC's will perform tasks necessary for each website, I am also noticing functionality that would be useful for all applications.For instance, if you create a database.cfc to pull queries that are based on data that all websites will need (for instance company information) would it be appropriate to stick that cfc in server memory?

I guess my question is a best practices question regarding storing CFC's in server memory.

Thanks in advance.

Michael
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




  1   2   >