RE: Printing mailing labels

2008-02-10 Thread Rick Faircloth
There's Will, keepin' that stand-up comic routine sharp.  :o)

Rick

 -Original Message-
 From: Will Tomlinson [mailto:[EMAIL PROTECTED]
 Sent: Sunday, February 10, 2008 12:01 AM
 To: CF-Talk
 Subject: Re: Printing mailing labels
 
 I got the cf_avery tag workin. It's pretty sweet. Had a few alignment 
 problems but got it
 worked out.
 
 It's ancient and I figured rick probably built it, but he didn't.  :)
 
 Thanks,
 Will
 
 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298666
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Huh? EMBED and OBJECT Tags Get Modified During CFFILE WRITE?

2008-02-10 Thread Jochem van Dieten
Karl Simanonok wrote:
 The webserver is running Windows 2003 Server and CF is version 
 7,0,0,91690 (MX 7) Enterprise version, the webserver is IIS 
 6.0.  Anybody have any idea what setting somewhere (no doubt for 
 security) is changing all my EMBED and OBJECT tags to InvalidTag 
 when CFFILE WRITE occurs?

Enable Global Script Protection: 
http://livedocs.adobe.com/coldfusion/8/htmldocs/basiconfig_05.html#1215023

Jochem

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298667
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Drill Down Problem

2008-02-10 Thread Jason Congerton
Hi

I am working on a product database, and need to drill down the products using 
price bands i.e. upto £1000, £1001 to £2500 etc.

My problem is; the database table has two fields for pricing info, an RRP and a 
sale price. The RRP price has to stay intact and can not be changed to the sale 
price. (If the product is not on offer the sale price field remains at £0.00.) 
If i use the following clause i get all the products, quite rightly as the sale 
price field is less than 1000

AND (((products.rrPrice)=1000)) OR (((products.cfsalePrice)=1000))

so i added this

AND (((products.cfsalePrice)  0))

This now returns all products with an RRP less than 1000, great!! However, this 
will not return a product with a sale price of £800, and a RRP of £1250, which 
is right!! Because the RRP is greater than 1000, but i need it to return the on 
sale products as well, regardless that the RRP is still higher than 1000. I 
hope this make sense. Any help would be appreciated.


Full query below;

cfquery name=getProducts datasource=#application.dsn#
SELECT productType.*, productRange.*, products.*
FROM (productType INNER JOIN productRange ON productType.prodtypeID = 
productRange.prpdType) INNER JOIN products ON (productType.prodtypeID = 
products.pdType) AND (productRange.prID = products.pdRange)
WHERE 0=0 AND (products.pdArchive) = 0
AND (((products.rrPrice)=1000)) OR (((products.cfsalePrice)=1000))
AND (((products.cfsalePrice)  0))
/cfquery

Jason




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298668
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Passing method/function name to CFC

2008-02-10 Thread Andrew Grosset
I have a cfc in the application scope initiated on application start

cfset application.myImage = createObject(component,mycfcs.ImageStuff)

I can then access the methods/functions like so:

(Z returns a boolean indicating weather the image was successfully rotated)

cfset z = application.myImage.rotateImage(argumentCollection = #arguments#)

I am trying to dynamically pass the cfc name and function like so:

cfset myname = myImage
cfset mymethod = rotateImage

Here I am just passing in the cfc name and it works:

cfset z = application[myname].rotateImage(argumentCollection = #arguments#)

The problem is I cannot find a way to pass in the function name...something 
like this..which does not work:

cfset z = application[myname].[mymethod](argumentCollection = #arguments#)

which gives an error: Invalid CFML construct.

any suggestions appreciated,

thanks, Andrew Grosset. 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298669
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Coldfusion 8 and RC4 encryption?

2008-02-10 Thread Andy Matthews
I'm implementing a shopping cart solution on a client site which has the 
ability to periodically push a datafeed containing RC4 encrypted XML to a page 
of my choosing.

I thought it would be a simple thing to encrypt test XML so that I could write 
the code to DEcrypt the same. Problem is that when I try to encrypt the string, 
I get the following error.

An error occurred while trying to encrypt or decrypt your input string: '' Can 
not decode string this is a test key.. 

Here's the code I'm using. The XML string is about 100 lines lonig, but I've 
also tried with one that was about 65 lines long with the same result.:

cfsavecontent variable=VARIABLES.xmlData
cfinclude template=data.xml
/cfsavecontent

cfset VARIABLES.key = this is a test key

cfset VARIABLES.encrypted = Encrypt(VARIABLES.xmlData, VARIABLES.key, 'RC4') 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298670
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: CFexecute, batch file calling another batch file

2008-02-10 Thread s. isaac dealey
Looks to me like when you CD to \Documents and Settings you want to
have quotes around the path, otherwise I don't think the CD will work.
Other than that, I would suspect that it's calling the bat okay. You
might want to have cfexecute save the output from the command to a file
while you're testing it. That way any errors will show up in the file it
creates. I don't remember offhand what the name of the attribute for the
output file path is. 


-- 
s. isaac dealey  ^  new epoch
 isn't it time for a change? 
 ph: 503.236.3691

http://onTap.riaforge.org/blog



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298672
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Coldfusion 8 and RC4 encryption?

2008-02-10 Thread Andy Matthews
The problem is that I have to provide a key to the site sending the data. So 
given your post, are you saying that I can just run this method once, save that 
key on my client's site, and also give the key to the data provider?


Keys for these algorithms are created via the GenerateSecretKey() function.

On Feb 10, 2008 12:22 PM, Andy Matthews [EMAIL PROTECTED] wrote:

-- 
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/ 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298671
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Passing method/function name to CFC

2008-02-10 Thread William Seiter
First thing that comes to mind is to remove the period (.) between [myname]
and [mymethod]

cfset z = application[myname][mymethod](argumentCollection =
#arguments#)

-- 
William E. Seiter
 
Have you ever read a book that changed your life?
Go to: www.winninginthemargins.com
Enter passkey: goldengrove
 
Web Developer / ColdFusion Programmer
http://William.Seiter.com

-Original Message-
From: Andrew Grosset [mailto:[EMAIL PROTECTED] 
Sent: Sunday, February 10, 2008 9:48 AM
To: CF-Talk
Subject: Passing method/function name to CFC

I have a cfc in the application scope initiated on application start

cfset application.myImage = createObject(component,mycfcs.ImageStuff)

I can then access the methods/functions like so:

(Z returns a boolean indicating weather the image was successfully rotated)

cfset z = application.myImage.rotateImage(argumentCollection =
#arguments#)

I am trying to dynamically pass the cfc name and function like so:

cfset myname = myImage
cfset mymethod = rotateImage

Here I am just passing in the cfc name and it works:

cfset z = application[myname].rotateImage(argumentCollection =
#arguments#)

The problem is I cannot find a way to pass in the function name...something
like this..which does not work:

cfset z = application[myname].[mymethod](argumentCollection =
#arguments#)

which gives an error: Invalid CFML construct.

any suggestions appreciated,

thanks, Andrew Grosset. 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298675
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: HOW TO: No consecutive cfschdule calls

2008-02-10 Thread s. isaac dealey
 I have made sure that each request is in the same application, but the
 second request still waits for the previous request to complete.

Right, that's because you put the conditional inside the cflock pair --
so it doesn't test the flag until it's already made sure there isn't
another concurrent instance running, and since you reset the flag at the
end, then once it releases the lock, it's already told the 2nd one it's
fine, go ahead. 

What you probably want is something more like this: 

cflock name=SchedLock timeout=5 type=exclusive
  cfparam name=application.SchedLock default=true /
  cfset variables.SchedLock = application.SchedLock /
  cfif variables.SchedLock
cfset application.SchedLock = false /
  /cfif
/cflock

cfif variables.schedLock
!--- it wasn't already running and we locked it, so run it now ---
cftry
  [CODE HERE]

  cfcatch
cflock name=SchedLock type=exclusive timeout=5
  cfset application.schedLock = true /
/cflock
[HANDLE THE ERROR HERE]
  /cfcatch
/cftry

cflock name=SchedLock type=exclusive timeout=5
  cfset application.schedLock = true /
/cflock
/cfif

So in this case what you're doing is locking access to the application
scope flag variable that tells you whether or not it's running. It
enters the lock, parameterizes the variable and then sets a local
variable to tell the current page whether or not it can execute the code.
If the current page can execute the code, it sets the application flag
so that other requests will skip execution. Then at the end, either if
the code errors or if it completes, it resets the application flag to
release the lock and allow other requests to execute the code. 

Generally speaking, you don't want to have large bodies of code
executing inside a cflock pair anyway. What you want is to use cflock
around just a very small set of a few, fast-running lines where you're
doing something critical. So if you need it to do something like this
where you're using it to single-thread a long-running process, you
separate out the flag-setting from the process itself and just lock the
flag, that way individual requests still don't wait long for the lock and
ideally actually the locks don't throw any errors. So even though you've
got say 3 requests trying to execute the same process and you only want
one of them to complete, as far as the code is concerned, nothing ever
failed (generate an error), it's all normal operation. 

hth,
ike

-- 
s. isaac dealey  ^  new epoch
 isn't it time for a change? 
 ph: 503.236.3691

http://onTap.riaforge.org/blog



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298673
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Drill Down Problem

2008-02-10 Thread William Seiter
I haven't tested, but maybe something like this?

SELECT productType.*, productRange.*, products.*,
Displayprice = CASE products.cfsalePrice
 WHEN products.cfsalePrice = 0 THEN products.rrPrice
  ELSE products.cfsalePrice
END
FROM (productType, productRange, products
WHERE productType.prodtypeID = productRange.prpdType
AND productType.prodtypeID = products.pdType
AND productRange.prID = products.pdRange) 
AND Displayprice = 1000

William
-- 
William E. Seiter
 
Have you ever read a book that changed your life?
Go to: www.winninginthemargins.com
Enter passkey: goldengrove
 
Web Developer / ColdFusion Programmer
http://William.Seiter.com
-Original Message-
From: Jason Congerton [mailto:[EMAIL PROTECTED] 
Sent: Sunday, February 10, 2008 9:16 AM
To: CF-Talk
Subject: Drill Down Problem

Hi

I am working on a product database, and need to drill down the products
using price bands i.e. upto £1000, £1001 to £2500 etc.

My problem is; the database table has two fields for pricing info, an RRP
and a sale price. The RRP price has to stay intact and can not be changed to
the sale price. (If the product is not on offer the sale price field remains
at £0.00.) If i use the following clause i get all the products, quite
rightly as the sale price field is less than 1000

AND (((products.rrPrice)=1000)) OR (((products.cfsalePrice)=1000))

so i added this

AND (((products.cfsalePrice)  0))

This now returns all products with an RRP less than 1000, great!! However,
this will not return a product with a sale price of £800, and a RRP of
£1250, which is right!! Because the RRP is greater than 1000, but i need it
to return the on sale products as well, regardless that the RRP is still
higher than 1000. I hope this make sense. Any help would be appreciated.


Full query below;

cfquery name=getProducts datasource=#application.dsn#
SELECT productType.*, productRange.*, products.*
FROM (productType INNER JOIN productRange ON productType.prodtypeID =
productRange.prpdType) INNER JOIN products ON (productType.prodtypeID =
products.pdType) AND (productRange.prID = products.pdRange)
WHERE 0=0 AND (products.pdArchive) = 0
AND (((products.rrPrice)=1000)) OR (((products.cfsalePrice)=1000))
AND (((products.cfsalePrice)  0))
/cfquery

Jason






~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298674
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Datadiff and years, months, days

2008-02-10 Thread Steve Sequenzia
I posted this yesterday but I don't see any trace of it hitting the list, so if 
it is a  double post I apologize.

I am trying to use the Datediff function to determine the years, months, days 
between to days. Example - from 1/1/08 to 2/9/08 is 1 years 2 months 8 days. I 
am trying to figure out how to do that programmatically. Right now I can only 
come up with the totals months and the total days between two dates. I cannot 
figure out how to get it in the format I need.

Any help on this would be great.

Thanks! 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298676
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Passing method/function name to CFC

2008-02-10 Thread s. isaac dealey
 The problem is I cannot find a way to pass in the function name...
 something like this..which does not work:
 
 cfset z = application[myname].[mymethod](argumentCollection =
 #arguments#)

Yeah, you can't use array notation on the name of a method, so even if
you remove the extra dot between [myname] and [mymethod] I'm pretty sure
it'll still fail... 

I believe the only way you can really do this is with cfinvoke: 

cfinvoke component=#application[myname]# method=#mymethod# 
argumentcollection=#arguments# returnvariable=z /

hth,
ike

-- 
s. isaac dealey  ^  new epoch
 isn't it time for a change? 
 ph: 503.236.3691

http://onTap.riaforge.org/blog



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298678
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


re: Datadiff and years, months, days

2008-02-10 Thread Jake Churchill
Not in proper code but here's the logic I would follow:
fromDate = 1/1/07;toDate - 2/8/08;
// get the years differenceyearsDiff = datediff('y',fromDate,toDate);
// add that to the from datefromDate = dateAdd('y', yearsDiff, fromDate);
// get the months differencemonthsDiff = datediff('m', fromDate, toDate);
// add that to the from datefromDate = dateAdd('m', monthsDiff, fromDate);
// get the days differencedaysDiff = dateDiff('d', fromDate, toDate);

Hope that helps.
--

Jake Churchill 
 Team Leader
11204 Davenport, Ste. 100
Omaha, NE  68154 
http://www.cfwebtools.com   
 402-408-3733 x103 


From: Steve Sequenzia [EMAIL PROTECTED]
Sent: Sunday, February 10, 2008 2:54 PM
To: CF-Talk cf-talk@houseoffusion.com
Subject: Datadiff and years, months, days 

I posted this yesterday but I don't see any trace of it hitting the list, so if 
it is a  double post I apologize.

I am trying to use the Datediff function to determine the years, months, days 
between to days. Example - from 1/1/08 to 2/9/08 is 1 years 2 months 8 days. I 
am trying to figure out how to do that programmatically. Right now I can only 
come up with the totals months and the total days between two dates. I cannot 
figure out how to get it in the format I need.

Any help on this would be great.

Thanks! 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298677
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Years, Months and Days from a date

2008-02-10 Thread Jeff Price
There isn't an quick and easy solution, although a few straight forward ones.

Everyone is going to suggest you do a DateDiff on each date part you want to 
handle, but after quickly glancing at cflib.org, think that a better solution 
might be the following.

Use DateDiff to get the difference in seconds and then use the formatTimespan 
function from cflib.org.

http://www.cflib.org/udf.cfm?ID=1637

Of course, you can also roll your own function to do the same thing, which if 
you are going to do this more than once, you definitely want to encapsulate 
this functionality to reuse it.

cfset aDate = 07/04/2007
cfset bDate = 12/01/2007

cfset sDif = DateDiff(s, aDate, bDate)
cfset ts = CreateTimeSpan(0,0,0,sDif)
cfoutput#formatTimeSpan(ts,y year{s}, m month{s}, d day{s}, n 
minutes)#/cfoutput

OUTPUT:
0 years, 4 months, 29 days, 60 minutes


 I am trying to figuring how to determine the year, months and days 
 from a date. Like from 1/1/2007 to 2/9/2008 it is 1 year 1 month and 8 
 days. I am trying to figure out how to do that programmatically.
 
 I have been trying to do it with datediff but I cannot figure out how.
 
 
 Any help would be great.
 
 Thanks! 


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298679
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Years, Months and Days from a date

2008-02-10 Thread Paul Ihrig
what happens if you do
cfset difDate = ('#pastDate#' - '#futureDate#')
cfoutput#difDate#/cfoutput


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298680
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Passing method/function name to CFC

2008-02-10 Thread Matt Quackenbush
In this scenario, you need to use cfinvoke to do the job for you.


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298682
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Passing method/function name to CFC

2008-02-10 Thread Andrew Grosset
I have a cfc in the application scope initiated on application start

cfset application.myImage = createObject(component,mycfcs.ImageStuff)

I can then access the methods/functions like so:

(Z returns a boolean indicating weather the image was successfully rotated)

cfset z = application.myImage.rotateImage(argumentCollection = #arguments#)

I am trying to dynamically pass the cfc name and function like so:

cfset myname = myImage
cfset mymethod = rotateImage

Here I am just passing in the cfc name and it works:

cfset z = application[myname].rotateImage(argumentCollection = #arguments#)

The problem is I cannot find a way to pass in the function name...something 
like this..which does not work:

cfset z = application[myname].[mymethod](argumentCollection = #arguments#)

which gives an error: Invalid CFML construct.

any suggestions appreciated,

thanks, Andrew Grosset. 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298681
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


CFFORM problem

2008-02-10 Thread Les Irvin
Today I moved a site from one CF8 server to another CF8 server.
Suddenly, all the cfform validity checks that were working on the
previous server now fail on the new server.  Is there some setting in
Adminstrator that may possibly be making this happen?  Anything else
that it could be?  It's the exact same page that it was on the other
server.

http://71.5.111.207/register.cfm

Thanks in advance for your help.
Les

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298684
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Pound signs in URL variables?

2008-02-10 Thread Dave Watts
 The trick is, I'm finding that there are data bits out there 
 that have a pound sign in them. An example I'm working on now 
 - one variable has the value '!$#$!'. (Don't ask. Long 
 story.) But when doing a dump of the URL structure, it only 
 shows '!$'.

The hash character is a URL metacharacter. You need to escape it before it's
sent from the browser to the server. If you're generating the page with the
link/form action/JavaScript redirect/etc, you can do this with CF using the
URLEncodedFormat function. If you're writing a GreaseMonkey script that will
only run within the client, you'll need to use the JavaScript escape
function.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Training: Adobe/Google/Paperthin Certified Partners
http://training.figleaf.com/

WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers!
http://www.webmaniacsconference.com/

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298685
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Pound signs in URL variables?

2008-02-10 Thread Scott Weikert
Hey gang -

Got a little personal side project I've been working on lately, and I've 
come across a small stumper.

What I have is a GreaseMonkey (FF plug-in) script that will do a 
screenscrape of a particular page, package up the needed data into a 
query string, and push it via HTTP to my CF hosting account. I've got a 
page there that catches the data in the URL and does what it does with it.

The trick is, I'm finding that there are data bits out there that have a 
pound sign in them. An example I'm working on now - one variable has the 
value '!$#$!'. (Don't ask. Long story.) But when doing a dump of the URL 
structure, it only shows '!$'.

I've tried grabbing this query string, sticking it in a browser, and 
adding a second pound to the variable value, i.e. '!$##$!' - hoping that 
would cause it to escape - but no go. URL dump still shows '!$'.

I may well, on the data scraping side, just convert any pound signs I 
get to some odd string - like '[pound]' or something that wouldn't 
normally show up - and then convert back on the CF side prior to the 
database insert. But that's clunky and I don't like it...!

Is there any way to deal with the pound signs as they come in? I've 
Googled around, but I have yet to find any results that aren't dealing 
with the basic Spit out CF variables by surrounding them with pound 
signs type pages. :/

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298683
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: CFFORM problem

2008-02-10 Thread Dave Watts
 Today I moved a site from one CF8 server to another CF8 server.
 Suddenly, all the cfform validity checks that were working 
 on the previous server now fail on the new server.  Is there 
 some setting in Adminstrator that may possibly be making this 
 happen?  Anything else that it could be?  It's the exact same 
 page that it was on the other server.
 
 http://71.5.111.207/register.cfm

This URL doesn't resolve properly:
http://71.5.111.207/CFIDE/scripts/cfform.js

You need to either fix that, or use the SCRIPTSRC attribute of CFFORM to
point to a valid location, or set the default location in the CF
Administrator.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Training: Adobe/Google/Paperthin Certified Partners
http://training.figleaf.com/

WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers!
http://www.webmaniacsconference.com/

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298686
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: A suggestion of placing the # of msgs info to the left of a msg title

2008-02-10 Thread Aaron Rouse
Yeah, the way gmail handles the list is one of the big reasons I
re-subscribed to this list awhile back.  I would think there are some
desktop email clients that would handle things like this but never looked
for one.

On Feb 9, 2008 8:44 PM, J.J. Merrick [EMAIL PROTECTED] wrote:

 get Gmail... conversations are your best friend.

 On 2/9/08, Don L [EMAIL PROTECTED] wrote:
  It would be much easier to read.  Thanks.
 
 

 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298687
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Maintain client connections - not working in CF8 / SQL 2000

2008-02-10 Thread Paul Vernon
Guys,

I have a really weird problem where the connection pooling doesn't seem to be 
working on our CF servers. For every query, a brand new connection to the SQL 
server is being made. It doesn't matter if I turn the setting on or off, the 
behaviour is the same which is a real bind as it's pushing the SQL server right 
up to its memory limit within 24 hours of a service restart.

The CF install is completely standard and I'm using the standard JDBC drivers 
that ship with CF. All hotfixes are applied. I really need some pointers on 
this one as restarting SQL every 24 hours is turning into a real chore...

TIA

Paul



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298688
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Printing mailing labels

2008-02-10 Thread Dave l
if only you knew the problems he had trying to make it work!

There's Will, keepin' that stand-up comic routine sharp.  :o)

Rick

 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298689
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4