Re: Transform Unicode characters

2006-08-16 Thread Dmitrii Dimandt
Well, that's what I finally arrived at anyway :) But that's a whole 15
minutes of my time wasted :( However, CF makes up for quite a lot of that
lost time that I would've otherwise wasted in PHP.

Anyway. I guess character transformations can be done outside CF in Java and
then linked to CF. But I'm _not_ going to do that right now. So, I'm stuck
with an XML-based solution right now (not that I'm complaining or anything,
I just hate XML :) )

On 8/16/06, Everett, Al (NIH/NIGMS) [C] <[EMAIL PROTECTED]> wrote:
>
> Couldn't a UDF get close to that?
>
> 
> 
> 
> 
>
> 
> 
>
>  arguments.replacementArray)>
> 
> 
>
> 
>
>  index="i">
>  returnString=REReplace(returnString,patternArray[i],replacementArray[i],"all")>
> 
>
> 
> 
>
> 
>
> 
> 
> 
> 
>
> 
> 
> 
> 
>
> #REReplaceByArray(patterns,replacements,myString)#
>
>
> Needs a bit of tweaking, but...
>
> -Original Message-
> From: Dmitrii Dimandt [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 16, 2006 12:08 PM
> To: CF-Talk
> Subject: Re: Transform Unicode characters
>
> Accepts arrays for both patterns and replacements. From the docs:
>
>  $string = 'The quick brown fox jumped over the lazy dog.';
>
> $patterns[0] = '/quick/';
> $patterns[1] = '/brown/';
> $patterns[2] = '/fox/';
>
> $replacements[2] = 'bear';
> $replacements[1] = 'black';
> $replacements[0] = 'slow';
>
> echo preg_replace($patterns, $replacements, $string); ?>
>
> But anyway, problem solved... In a way...
>
> On 8/16/06, Everett, Al (NIH/NIGMS) [C] <[EMAIL PROTECTED]> wrote:
> >
> > What does preg_replace do that REReplace() doesn't?
> >
> > -Original Message-
> > From: Dmitrii Dimandt [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, August 16, 2006 11:04 AM
> > To: CF-Talk
> > Subject: Re: Transform Unicode characters
> >
> > Because it transforms charactrs into garbage (sth. like %C4%B1 for ý).
> > And I need human-readable format :)) Anyway. I guess I'll stick to my
> > XML solution. I read mappings from a UTF-8 encoded XML file into
> > arrays and then iterate over them and replace whatever characters I
> > need. I miss PHP's preg_replace :)))
> >
> >
>
>
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: Array Syntax

2006-08-16 Thread James Holmes
This is easier to understand if you don't use evaluate().

Refer to the form variables directly. The form scope is a struct, so
StructKeyExists will tell you if a particular form var is there.

...

Also, you can refer to it in struct notation:

FORM["Astockid" & i]

etc.

On 8/17/06, Jenny Gavin-Wear <[EMAIL PROTECTED]> wrote:
> Hi Alan,
>
> Thanks for the reply.  You are right, I was going about things the wrong way 
> and am on the right track now I hope.
>
> Weird thing with the code below, i've stepped through the code and the form 
> variables do exist but it crashes on the evalute line for the Ostockid.
>
> Any ideas, please?
>
>
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> #stockid# / #quantity# / #inout#
> 
> 
> 
> 
> 
>
>
>
>
> -Original Message-
> From: Alan Rother [mailto:[EMAIL PROTECTED]
> Sent: 17 August 2006 04:55
> To: CF-Talk
> Subject: Re: Array Syntax
>
>
> Offhand I see a few things.
>
> First, you can't use IsDefined on an array like that
>
> IsDefined("Form.MyArray[1][1]")
>
> You can only check for the existence of the main variable
>
> IsDefined("Form.MyArray")
>
> Second, you dont need the #'s in this part, form.Astockid[1][#i#] NEQ ""
>
> Last, why are you setting an array into the form scope? I tested it and it
> does work, but I would consider it "wrong", so I am curious why you are
> using it.
>
>
> Could you possibly give me a larger sample of what you are working on? I'd
> be happy to show you the right way to do it, but I'm confused about what I
> am seeing so far.
>
> --
> Alan Rother
> Macromedia Certified Advanced ColdFusion MX 7 Developer
>
>
>
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Array Syntax

2006-08-16 Thread Jenny Gavin-Wear
Hi Alan,

Thanks for the reply.  You are right, I was going about things the wrong way 
and am on the right track now I hope.

Weird thing with the code below, i've stepped through the code and the form 
variables do exist but it crashes on the evalute line for the Ostockid. 

Any ideas, please?












#stockid# / #quantity# / #inout#









-Original Message-
From: Alan Rother [mailto:[EMAIL PROTECTED]
Sent: 17 August 2006 04:55
To: CF-Talk
Subject: Re: Array Syntax


Offhand I see a few things.

First, you can't use IsDefined on an array like that

IsDefined("Form.MyArray[1][1]")

You can only check for the existence of the main variable

IsDefined("Form.MyArray")

Second, you dont need the #'s in this part, form.Astockid[1][#i#] NEQ ""

Last, why are you setting an array into the form scope? I tested it and it
does work, but I would consider it "wrong", so I am curious why you are
using it.


Could you possibly give me a larger sample of what you are working on? I'd
be happy to show you the right way to do it, but I'm confused about what I
am seeing so far.

-- 
Alan Rother
Macromedia Certified Advanced ColdFusion MX 7 Developer




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: captcha

2006-08-16 Thread Mark Mandel
Aaaages ago I had the idea to build a CFC with which you could
configure sentences that simply took numbers as possible arguments...
something like:


   There where {number} children in the yard then {number}
decided to go home, how many where left?

(add in many more of these things)

The CFC would choose one  at random, and insert word values
for randomly generated numbers, so you would end up with a sentence
like

"There where ten children in the yard then four decided to go home,
how many where left?"

Somehow the answer of "six" or "6" would be validated by the CFC, and
off you could go.

Would work very well for accessibility too.

I never got around to writing it, but seemed like a good idea at the time.

Maybe think about implementing something like that?

Mark

On 8/17/06, Andrew Grosset <[EMAIL PROTECTED]> wrote:
> Here's a good alternative to captcha:
>
> http://bennadel.com/index.cfm?dax=blog:197.view
>
> Andrew.
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: captcha

2006-08-16 Thread Andrew Grosset
Here's a good alternative to captcha:

http://bennadel.com/index.cfm?dax=blog:197.view

Andrew.

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: Array Syntax

2006-08-16 Thread Alan Rother
Offhand I see a few things.

First, you can't use IsDefined on an array like that

IsDefined("Form.MyArray[1][1]")

You can only check for the existence of the main variable

IsDefined("Form.MyArray")

Second, you dont need the #'s in this part, form.Astockid[1][#i#] NEQ ""

Last, why are you setting an array into the form scope? I tested it and it
does work, but I would consider it "wrong", so I am curious why you are
using it.


Could you possibly give me a larger sample of what you are working on? I'd
be happy to show you the right way to do it, but I'm confused about what I
am seeing so far.

-- 
Alan Rother
Macromedia Certified Advanced ColdFusion MX 7 Developer


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: Any ideas

2006-08-16 Thread Doug Brown
Thanks for your thoughts Paul. I think you are right as far as the database.
I am still adding columns to that list and hopefully all will end well.



thanks again,



- Original Message -
From: "Paul Giesenhagen" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Wednesday, August 16, 2006 9:42 PM
Subject: Re: Any ideas


> I would leave it up to the ad "owner" to turn the ad off by manually
setting
> it to sold.  There is really no other way to do this, they will be
> encouraged to do so as they do not want to keep getting emails and
contacts
> from people when they do not have the stuff anymore.
>
> my .02
> Paul Giesenhagen
> QuillDesign
> 417-885-1375
> http://www.quilldesign.com
>
>
> - Original Message -
> From: "Doug Brown" <[EMAIL PROTECTED]>
> To: "CF-Talk" 
> Sent: Wednesday, August 16, 2006 10:37 PM
> Subject: Any ideas
>
>
> > In my classifieds, I want to give the customer the ability to re-post
> > their ad for free for another month if they do not sale the item. Can
> > anyone think of a way to check if the item is sold? I was thinking that
I
> > could have the customer log-in to be able to "agree" to buy the item
from
> > the seller and then have the seller "agree" to sell the item to the
> > customer. At this point the database would be updated showing item was
> > sold. Any thoughts?
> >
> >
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: CF out of memory, even when out of scope

2006-08-16 Thread Dave Watts
> Currently, there is no way to turn debugging on or off per-application,
> right? It's either all or none?

Yes, to the best of my knowledge. But this is what development servers are
for.

SeeFusion includes some nice debugging functionality, which appears to be
safer in a production environment.

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

Fig Leaf Software provides the highest caliber vendor-authorized 
instruction at our training centers in Washington DC, Atlanta, 
Chicago, Baltimore, Northern Virginia, or on-site at your location. 
Visit http://training.figleaf.com/ for more information! 


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Array Syntax

2006-08-16 Thread Dave Watts
> I'm trying to use an array, can anyone tell me what's wrong with the
> syntax below please?
>
>  "" AND IsDefined("form.Aquantity[2][#i#]") AND form.Aquantity[2][#i#] GT
> 0>

You can't use IsDefined to test for the existence of an array element. You
can use it to test for the existence of the array itself, but that's it. If
you were careful to ensure that your array elements are contiguous, you can
simply check to see if i is less than or equal to
ArrayLen(Form.aStockID[1]). If you weren't careful, then your only choice is
to try to reference the potential array element, then catch the exception
that occurs when it doesn't exist.

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

Fig Leaf Software provides the highest caliber vendor-authorized 
instruction at our training centers in Washington DC, Atlanta, 
Chicago, Baltimore, Northern Virginia, or on-site at your location. 
Visit http://training.figleaf.com/ for more information! 


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: Any ideas

2006-08-16 Thread Paul Giesenhagen
I would leave it up to the ad "owner" to turn the ad off by manually setting 
it to sold.  There is really no other way to do this, they will be 
encouraged to do so as they do not want to keep getting emails and contacts 
from people when they do not have the stuff anymore.

my .02
Paul Giesenhagen
QuillDesign
417-885-1375
http://www.quilldesign.com


- Original Message - 
From: "Doug Brown" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Wednesday, August 16, 2006 10:37 PM
Subject: Any ideas


> In my classifieds, I want to give the customer the ability to re-post 
> their ad for free for another month if they do not sale the item. Can 
> anyone think of a way to check if the item is sold? I was thinking that I 
> could have the customer log-in to be able to "agree" to buy the item from 
> the seller and then have the seller "agree" to sell the item to the 
> customer. At this point the database would be updated showing item was 
> sold. Any thoughts?
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Any ideas

2006-08-16 Thread Doug Brown
In my classifieds, I want to give the customer the ability to re-post their ad 
for free for another month if they do not sale the item. Can anyone think of a 
way to check if the item is sold? I was thinking that I could have the customer 
log-in to be able to "agree" to buy the item from the seller and then have the 
seller "agree" to sell the item to the customer. At this point the database 
would be updated showing item was sold. Any thoughts?

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Array Syntax

2006-08-16 Thread Jenny Gavin-Wear
I'm trying to use an array, can anyone tell me what's wrong with the syntax 
below please?




I've looked for examples of using arrays and could do with some pointers.

many thanks,

jenny

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.11.1/421 - Release Date: 16/08/2006
 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: Stumped on CFC param issue

2006-08-16 Thread Rey Bango
Yep. I CFDump'd the query to make sure.

Rey...

James Holmes wrote:
> You are of course absolutely certain that getProductInfo contains only
> one row when the code fails?
> 
> On 8/17/06, Rey Bango <[EMAIL PROTECTED]> wrote:
> 
>>Thanks Matt. It really doesn't solve my problem though as the original
>>issue is that the method chkMDSInventory() is saying that the params are
>>not numeric values when in fact they are.
>>
>>I appreciate the suggestion though.
> 
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: Stumped on CFC param issue

2006-08-16 Thread James Holmes
You are of course absolutely certain that getProductInfo contains only
one row when the code fails?

On 8/17/06, Rey Bango <[EMAIL PROTECTED]> wrote:
> Thanks Matt. It really doesn't solve my problem though as the original
> issue is that the method chkMDSInventory() is saying that the params are
> not numeric values when in fact they are.
>
> I appreciate the suggestion though.

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

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: OT: Anyone else affected by the hostmysite outage?

2006-08-16 Thread Mike Kear
I for one am pretty impressed with how quickly they've got a major
repair done, and how they have kept customers in the picture through
that page, and the photos.

I think there are issues relating to redundancy and multiple
connections etc that need to be addressed, but given a big chunk of
thier business suddenly went dark, I thought their damage control and
reaction to the problem was pretty cool.

Long time internet users in Australia might remember the time years
ago when there were two internet connections across the Pacific where
most of the traffic from Australia went.  And a trawler dug up the
cable out of Melbourne.

Telstra, who at the time owned all the internet connections out of
Australia, tried to pretend nothing was wrong for days, even though
anyone using the internet knew that even their slow modems were
suddenly struggling to keep up with crippled snails.  Telstra
maintained for days and days that nothing was wrong, even when there
were newspaper reports that one of the two main undersea cables had
been broken.

I suppose Telstra figured they could get away with fixing it quickly
and quietly and no one woudl know any better.

I think HMS have shown a far better attitude, and would get much more
tolerance and cooperation from their customers as a result.

Disclaimer:  i have nothing to do with HMS, apart from having one of
my clients hosted there - in fact I'm a competitor in a minor part of
my business.

Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month


On 8/17/06, Dave Lyons <[EMAIL PROTECTED]> wrote:
> I think they need to be given some "thanks" because it was one of the worst 
> things that could happen to them and per usual they did a helluva job in not 
> only getting it fixed but also keeping their customers informed of what was 
> going on, not only in the slideshow but just the simple page that was updated 
> as things happened. I have yet to see if any host be able to handle a 
> situation like host my site did today. If it was ct they'd still be trying to 
> figure out why there was no internet.
>
> However, sites are supposed to rollover to other data center if/when a issue 
> arises and that didnt happen and I will find out why but still im happy they 
> are back up and going, i was so glad to get back into my mail and see I didnt 
> miss my chance to "be hung like the big boys at the club.."
>
>

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: Database design question

2006-08-16 Thread Paul Giesenhagen
To me the table structure looks fine, it would be one line per classified 
ad.

If they can place more than one ad at a time, it wouldn't matter to the 
database.  You would write your scripts to allow for multiple instances of 
ads and then submit them through a loop, inserting them one at a time.

Works much like a shopping cart, you have one table for the order and a 
related table that holds all the products associated with that order. 
Sometimes orders have many products in them and you just loop through 
inserting each product into the productOrder table.

I hope this helps .. looks like you are fine!

Paul Giesenhagen
QuillDesign
417-885-1375
http://www.quilldesign.com


- Original Message - 
From: "Doug Brown" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Wednesday, August 16, 2006 10:06 PM
Subject: Database design question


>I am creating a classifieds e-commerce site and was wondering...I have 
> the following columns that need to be in the database, and was wondering 
> if you would split them up into seperate tables. I am thinking no, but not 
> sure.
>
>I was considering letting customers place more than one ad at a time 
> and was thinking if I should use a structure to hold the info or if I 
> should create a temp_table that gets cleared out say once a week or more. 
> What would be better performance wise?
>
> (ads)
> ad_id
> cust_id
> cat_id
> sub_cat_id
> ad_text
> qty_on_hand
> ship_method
> item_condition
> unit_type
> refund_policy
> is_negotiable
> ad_title
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Database design question

2006-08-16 Thread Doug Brown
I am creating a classifieds e-commerce site and was wondering...I have the 
following columns that need to be in the database, and was wondering if you 
would split them up into seperate tables. I am thinking no, but not sure. 

I was considering letting customers place more than one ad at a time and 
was thinking if I should use a structure to hold the info or if I should create 
a temp_table that gets cleared out say once a week or more. What would be 
better performance wise?

(ads)
ad_id
cust_id
cat_id
sub_cat_id
ad_text
qty_on_hand
ship_method
item_condition
unit_type
refund_policy
is_negotiable
ad_title

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: Datediff help

2006-08-16 Thread Sam Farmer
The problem lies in the order that things are being executed.  The
DateDiff function is being processed by CF before it goes to the
database.  So CF is looking for a variable called MEB.MembShpDate and
ORD.ProcessedDate not the database columns!

You want to use the database function for dateDiff not CF's in this
case.  Not sure what database you are using but I think in SQLServer
the function is called DateDiff.

HTH

Sam

On 8/16/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> I have a query where I'm performing an inner join and the cfm page is telling 
> me ...
>
> MembShpDate is an existiing column in the MemberDetails table and it's a valid
> datetime datatype. Any ideas?  Full cfquery is after error message.
>
> The following information is meant for the website developer for debugging 
> purposes.
>
> Error Occurred While Processing Request
> Element MEMBSHPDATE is undefined in MEB.
>
>
> The error occurred in 
> C:\CFusionMX7\wwwroot\PipeLine\Pipe_SchoolCoun\rm\reportMemberReg.cfm: line 31
>
> 29 : 
> 30 :SELECT * FROM Orders ORD INNER JOIN MemberDetails MEB, 
> MEB.MembShpDate, ON ORD.UserID = MEB.MemberAutoID
> 31 :WHERE #DateDiff ('d', MEB.MembShpDate, ORD.ProcessedDate)#" = 0
> 32 :AND ORD.Deleted = 0
> 33 :AND (ORD.PaymentInfo = 'Membership Only' OR ORD.PaymentInfo = 'New 
> Membership and Registration')
>
>
>
>
>
> here is the full query.
> 
>  SELECT * FROM Orders ORD INNER JOIN MemberDetails MEB ON ORD.UserID = 
> MEB.MemberAutoID
>  WHERE #DateDiff ('d', MEB.MembShpDate, ORD.ProcessedDate)#" = 0
>  AND ORD.Deleted = 0
>  AND (ORD.PaymentInfo = 'Membership Only' OR ORD.PaymentInfo = 'New 
> Membership and Registration')
>  ORDER BY MEB.MembShpDate DESC
> 
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Datediff help

2006-08-16 Thread Dawson, Michael
In this context, #DateDiff()# is a ColdFusion function.  If you want the
database's DateDiff() function, remove the #s.

The error occurs because CF thinks it is parsing a CF variable,
MEB.MembShpDate but there is no structure named MEB.

M!ke 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]

Sent: Wednesday, August 16, 2006 8:24 PM
To: CF-Talk
Subject: Datediff help

I have a query where I'm performing an inner join and the cfm page is
telling me ...

MembShpDate is an existiing column in the MemberDetails table and it's a
valid datetime datatype. Any ideas?  Full cfquery is after error
message.

The following information is meant for the website developer for
debugging purposes. 

Error Occurred While Processing Request Element MEMBSHPDATE is undefined
in MEB. 

 
The error occurred in
C:\CFusionMX7\wwwroot\PipeLine\Pipe_SchoolCoun\rm\reportMemberReg.cfm:
line 31

29 : 
30 :SELECT * FROM Orders ORD INNER JOIN MemberDetails MEB,
MEB.MembShpDate, ON ORD.UserID = MEB.MemberAutoID
31 :WHERE #DateDiff ('d', MEB.MembShpDate, ORD.ProcessedDate)#" = 0
32 :AND ORD.Deleted = 0
33 :AND (ORD.PaymentInfo = 'Membership Only' OR ORD.PaymentInfo =
'New Membership and Registration')





here is the full query.
  SELECT *
FROM Orders ORD INNER JOIN MemberDetails MEB ON ORD.UserID =
MEB.MemberAutoID  WHERE #DateDiff ('d', MEB.MembShpDate,
ORD.ProcessedDate)#" = 0  AND ORD.Deleted = 0  AND (ORD.PaymentInfo =
'Membership Only' OR ORD.PaymentInfo = 'New Membership and
Registration')  ORDER BY MEB.MembShpDate DESC 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: Ajax Indicator Image Code for AjaxCFC

2006-08-16 Thread Denny Valliant
Ooh la la! (sorry, my French is pretty bad;)

I'd like to second the thanks for AjaxCFC, too.

Woot, good stuff, this async'n...

On 8/16/06, Rey Bango <[EMAIL PROTECTED]> wrote:
>
> No sweat Denny. Go here to pick up a cool Ajax indicator:
>
> http://www.ajaxload.info/
>
> It creates on for you on the fly. Very cool!
>
> Rey
>
> Denny Valliant wrote:
> > Thanks for sharing Rey!  I've been meaning to get something pretty...
> >
> > Yay!
>


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: Zipcodes addresses and all that jazz

2006-08-16 Thread Paul Hastings
Dave Lyons wrote:
> but the following addresses with come back with an error:
> 
> 123 s elm st ste #14, denver, co

pretty much all geocoding engines work on normalized addresses. the better ones 
have tools to clean them up before you pass them thru the engine.

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: Java/CF Question

2006-08-16 Thread Denny Valliant
On 8/15/06, loathe <[EMAIL PROTECTED]> wrote:
>
> Great ideas.
>
> I figure I will end up going with the inline example that was shown in
> another response.  I know one of the guys that worked on the Poi project,
> I'll try and hook you guys up if you're interested.


Thanks for the offer!

I think POI is swell, but the API for jExcelAPI is easy, and POI looks
harder.

Haven't tried much HSSF (sp?) stuff so I can't really comment, but the
examples
made me lean towards jExcelAPI.  Sadly, POI I think comes with CF, whereas
jexcelapi might, but if so, it's buried and renamed.

Not that sad though 'cause part of the exercise would be adding the jar
in some wayform or other. ;-)

Again, thanks for the offer, and I do dig this stuff, be it POI or no, so if
there
is a CF initiative to interact with MS files more using POI, I'm there dude.
:D


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: Zipcodes addresses and all that jazz

2006-08-16 Thread Paul Hastings
Turetsky, Seth wrote:
> I don't know much about ESRI, but Microsoft allows to get driving directions
> and distance in their JS API(definitely free), google and yahoo(I believe) do
> not.  M$'s other web service API(not sure about price), which I have not used
> and not sure if CF can use it, is also very extensive.  To me, more
> impressive than google/yahoo.

so does esri, though these are mostly proof-of-concept for flashforms (except 
the last one, we had a survey team's GPS die & the backup didn't do 
projections):

http://www.sustainablegis.com/projects/routing/
http://www.sustainablegis.com/projects/geocode/flashforms/
http://www.sustainablegis.com/projects/projection/gcs2utm.cfm

esri's a *real* GIS company.


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: Ajax Indicator Image Code for AjaxCFC

2006-08-16 Thread Rey Bango
No sweat Denny. Go here to pick up a cool Ajax indicator:

http://www.ajaxload.info/

It creates on for you on the fly. Very cool!

Rey

Denny Valliant wrote:
> Thanks for sharing Rey!  I've been meaning to get something pretty...
> 
> Yay!
> 
> On 8/16/06, Rey Bango <[EMAIL PROTECTED]> wrote:
> 
>>I've been using Rob Ghonda's AjaxCFC more and more and the one thing
>>that I wanted was the ability to define an Ajax indicator image.
>>
> 
> 
> 
> 
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: Ajax Indicator Image Code for AjaxCFC

2006-08-16 Thread Denny Valliant
Thanks for sharing Rey!  I've been meaning to get something pretty...

Yay!

On 8/16/06, Rey Bango <[EMAIL PROTECTED]> wrote:
>
> I've been using Rob Ghonda's AjaxCFC more and more and the one thing
> that I wanted was the ability to define an Ajax indicator image.
>



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: XML parsing & link underline

2006-08-16 Thread Denny Valliant
Yeesh... not sure, but maybe it's PPT itself adding the link?

Most of these new fangled apps automagically transform them to "real"
links...

Dont' know, really... are you building the PPT using a .HTM file and
renaming it,
or a similar method?  Or do you have an app for PPT generation?  Check it's
docs, if so, or PPT docs, else.

Maybe.  Not sure exaclty what is being asked.
:D

On 8/16/06, Oðuz_Demirkapý <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I have a CF project where I parse an XML document by a Java based tool and
> generate a PPT file.
>
> I need to show underline for a link now and I have a syntax as
>
> www.mydomain.com
>
> in my XML file.
>
> But it displays as www.mydomain.com in output.
>
>
> I guess this is an issue on my Java code but I remember same kind of
> problems on Flash & XML combination.
>
> Do you have any experience something like that?
>
> Any tip would be appreciated?
>
>
> Sincerely,
>
> Oðuz Demirkapý
>


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: OT: Anyone else affected by the hostmysite outage?

2006-08-16 Thread Dave Lyons
I think they need to be given some "thanks" because it was one of the worst 
things that could happen to them and per usual they did a helluva job in not 
only getting it fixed but also keeping their customers informed of what was 
going on, not only in the slideshow but just the simple page that was updated 
as things happened. I have yet to see if any host be able to handle a situation 
like host my site did today. If it was ct they'd still be trying to figure out 
why there was no internet.

However, sites are supposed to rollover to other data center if/when a issue 
arises and that didnt happen and I will find out why but still im happy they 
are back up and going, i was so glad to get back into my mail and see I didnt 
miss my chance to "be hung like the big boys at the club.."

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: Way OT: But you know you want one..

2006-08-16 Thread Denny Valliant
On 8/16/06, Dave Lyons <[EMAIL PROTECTED]> wrote:
>
>
> Hell, im still laughin cause dw knew what a "reach-a-round" was lol


Heh, he knows his stuff.  Doesn't mean he's "into it".  Maybe he just
watched
Sex in the City (and the City? bah;).  Frankly, I'm more surprised you
got it wrong... :-P

The laser keyboards impress me more, I want one of those. Oh yeah.

Lasers will always be cool.  LED is s last year.


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: Using CFQUERY to access DBCC output?

2006-08-16 Thread Denny Valliant
You can also use native JDBC drivers and a java-esk JDBC connection to get
back
more info than CF gives you.  Don't know if it would work in this case...
:Denny

On 8/16/06, Dan Plesse <[EMAIL PROTECTED]> wrote:
>
> It sure sounds like you need a socket with a listener. I would find an
> example already
> on the web and use that or add a request for CF 8 to add a feature to tags
> which allows
> for internal objects to be extended 
>
> Override addlisterner() method.
>
> On 8/16/06, powell @ nauticom. net powell @ nauticom. net <
> [EMAIL PROTECTED]> wrote:
> >
> > I'm trying to automate some of an application's database maintentance
> > tasks via a CF script that will check to see if it's time for a defrag,
> > index rebuild, etc.  I know that I can put a DBCC statement in a
> CFQUERY,
> > but what's got me scrambling is how to retrieve any output that the DBCC
> > might generate. If I feed CFQUERY something like
> >DBCC SHOWCONTIG ('activitylog')
> > I'd like to be able to get at the 10 or so lines of of output that it
> > would normally generate interactively.  But no result set is even
> created by
> > such a query, and I cannot see how to get to the data.  I've tried
> > variations of EXECUTE and subqueries, all with no luck.  Is this an
> > impossible dream?
> >
> > thanks
> > Reed
> >
> >
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: trouble with java.util.Date and long datatypes

2006-08-16 Thread Mark Mandel
Try casting all the values - it should help.

Mark

On 8/17/06, Mullai Subbiah <[EMAIL PROTECTED]> wrote:
> Thank you. I decided to write a java program and call it from coldfusion. But 
> coldfusion complains the method does not exist though it exists. If I write 
> the functionlity into another method with different signature it does not 
> complain. The two method calls
> search(String, String);
> searchDate(String, String, int); //complains about this method.
>
> Is CF good in passing integer arguments to Java method. Tried to force it by 
> using JavaCast("int", value); // No improvement.
>
> Anyway will keep trying.
>
> -Mullai


-- 
E: [EMAIL PROTECTED]
W: www.compoundtheory.com

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Datediff help

2006-08-16 Thread coldfusion . developer
I have a query where I'm performing an inner join and the cfm page is telling 
me ...

MembShpDate is an existiing column in the MemberDetails table and it's a valid
datetime datatype. Any ideas?  Full cfquery is after error message.

The following information is meant for the website developer for debugging 
purposes. 

Error Occurred While Processing Request 
Element MEMBSHPDATE is undefined in MEB. 

 
The error occurred in 
C:\CFusionMX7\wwwroot\PipeLine\Pipe_SchoolCoun\rm\reportMemberReg.cfm: line 31

29 : 
30 :SELECT * FROM Orders ORD INNER JOIN MemberDetails MEB, MEB.MembShpDate, 
ON ORD.UserID = MEB.MemberAutoID
31 :WHERE #DateDiff ('d', MEB.MembShpDate, ORD.ProcessedDate)#" = 0
32 :AND ORD.Deleted = 0
33 :AND (ORD.PaymentInfo = 'Membership Only' OR ORD.PaymentInfo = 'New 
Membership and Registration')





here is the full query.

 SELECT * FROM Orders ORD INNER JOIN MemberDetails MEB ON ORD.UserID = 
MEB.MemberAutoID
 WHERE #DateDiff ('d', MEB.MembShpDate, ORD.ProcessedDate)#" = 0
 AND ORD.Deleted = 0
 AND (ORD.PaymentInfo = 'Membership Only' OR ORD.PaymentInfo = 'New Membership 
and Registration')
 ORDER BY MEB.MembShpDate DESC


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: CF out of memory, even when out of scope

2006-08-16 Thread Denny Valliant
On 8/15/06, Dave Watts <[EMAIL PROTECTED]> wrote:
>
> > I thought you were supposed to turn of /all/ debugging on
> > production sites.
>
> Yes, please, for the love of all that's holy, turn off debugging on
> production servers unless you absolutely positively need it right that
> minute.


Currently, there is no way to turn debugging on or off per-application,
right?
It's either all or none?

Using Reactor, having debugging on will kill you. Or it kills me, at least.

Hoping against hope there is a way to programmatically do it, but haven't
looked into CFadmin api for debug stuff yet.  I'm guessing it's all or
nothing
though, application-specific-wise.


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: CSS help

2006-08-16 Thread James Holmes
While the br does work, it's a bit of a fudge. I came across an
article with a better solution when looking at the same problem; try
adding

clear: both;
overflow: hidden;

to the css for the box and you can remove the br after it.

On 8/17/06, Rick Root <[EMAIL PROTECTED]> wrote:
> Sandra Clark wrote:
> >
> > Float the wrapper to the right.  Text-align only works on the inline text
> > within the div, not on the div itself.
>
> I seriously need to buy you a drink at the next conference!  You're
> always coming to my CSS rescue.
>
> that worked, except that the remaining content floated to the left of
> the header box.
>
> I removed the "margin-bottom" css (and then realized I didn't need the
> wrapper anymore so I removed it entirely, putting the float on the
> #header), and added a  after the headerwrapper div.

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

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: cfdirectory of java file handling api?????

2006-08-16 Thread Denny Valliant
On 8/15/06, Barney Boisvert <[EMAIL PROTECTED]> wrote:


> As you can imagine, that's a LOT slower than a simple scan of the
> directory.  In your case, it's greatly affected by the fact that
> network files are handled differently than local files.  Specifically,
> the filenames (which is all your Java used) are cached, but all the
> nitty gritty (size, last mod date, etc) probably isn't, or at least
> not as aggressively.  As such, getting that data is very expensive.
> With all-local access you should still see a performance difference,
> but it should be much smaller.


Actually, even with a java.io.FileFilter, the java method is quite a bit
slower than cfdirectory, if doing recursion and sizes, etc..

Somehow I'm thinking that cfdirectory is some java that uses "native"
FS stuff vs. java FS stuff, but I'm no java guru, and don't really know.

Your blog entry got me thinking, ages ago.  Never posted the results,
did I? Sheesh, I'm week! I don't even know where I put that...

Guess the answer is, for recursion, something native, or cfdir; otherwise,
java is WAY faster (for just a list file names for a given dir).

:den


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: Java/CF Question

2006-08-16 Thread Mullai Subbiah
I created a Java Class within a package. I included the location in the 
classpath upto "classes" directory using CF Admin

C: -> Java -> classes -> XPA -> bin -> dateRange -> abc.class

In CF I created an object createObject("java", "XPA.bin.dateRange.abc"); No 
class found was thrown. I stripped the package and added abc.class under 
classes and it worked fine. Can anybody please show me how to include the 
package name along with the class name like for e.g java.util.Date

Thank you.

-Mullai

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: OT: Anyone else affected by the hostmysite outage?

2006-08-16 Thread B V
What I find hard to understand is how all cables were cut at the same time.
>From what I have heard for HMS support, supposedly DC2 is more modern, has
redundancy, and disparate access points, and the lot, but DC1 doesn't have
that stuff since it was an older Building, As a customer in DC2, My mail was
down for 1 hr, (Mail41), but I'm geussing it rolled over to the other DC. My
site worked, but I did have a little trouble with the db. Maybe that's what
it was. I forgot about which DC the DB was in. I'm geussing since goldman is
older it's 1. The worst part was that at any given time there were at least
41 calls. So many calls at the same time, that the line was beeping, and to
busy to even put me on HOLD, which is a rarety in itself. Right now almost
all systems are up, but the CP isn't. Kinda Annoying. But I have to be
honest, HMS does try very hard, and once when I had a corrupted backup, they
worked 16 hours straight on fixing it, and elevated it to Infrastructure.
Same kind of thing here. They have been working out in the 105 degree heat
all day fixing the line... The letter sent in is a good example...


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: handling java array

2006-08-16 Thread Denny Valliant
On 8/15/06, Brian Dumbledore <[EMAIL PROTECTED]> wrote:
>
> Jake,
>
> Apparently it doesn't let me use the .length property. no clue why.
>
> Also does anyone know how cfdirectory is implemented? I have a network
> folder which I am trying to list, and using cfdirectory takes for ever..


There are posts around that give examples of doing cfdirectory via java, but
sadly, it's not very fast.

Hands down, the solution is to use a "native" directory traversal mech.,
like "ls"(*nix) or "dir" (win*).
If you need speed, that is.

This is also an answer to the question about getting a directory structure
from a Linux box fast.
Use something "native".
:DeN

-ps I think Jake is right about the .length


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: trouble with java.util.Date and long datatypes

2006-08-16 Thread Mullai Subbiah
Thank you. I decided to write a java program and call it from coldfusion. But 
coldfusion complains the method does not exist though it exists. If I write the 
functionlity into another method with different signature it does not complain. 
The two method calls
search(String, String);
searchDate(String, String, int); //complains about this method. 

Is CF good in passing integer arguments to Java method. Tried to force it by 
using JavaCast("int", value); // No improvement.

Anyway will keep trying.

-Mullai

>You may want to try pushing the value through a
>java.lang.Long.getLong(string nm), and seeing if that works?
>
>ColdFusion can be funny about large numbers, because it tries ot fit
>them into java.lang.Integers, which can only go so high.
>
>Give that a shot, and let us know.
>
>Mark
>
>On 8/16/06, Mullai Subbiah <[EMAIL PROTECTED]> wrote:
>
>
>-- 
>E: [EMAIL PROTECTED]
>W: www.compoundtheory.com

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Ajax Indicator Image Code for AjaxCFC

2006-08-16 Thread Rey Bango
I've been using Rob Ghonda's AjaxCFC more and more and the one thing 
that I wanted was the ability to define an Ajax indicator image.

So I looked into the util.js and found a link to the online DWR 
reference. In there, Joe Walker shows a snippet of code that can do 
exactly what I wanted; display one of those animated Ajax indicator 
images! So, I figured I'd share the code with all of your guys & gals. 
Here it is:

/**
  * Setup a AJAX image indicator.
  * Added by Rey Bango (8/16/06) based on code in the URL below
  * @see http://getahead.ltd.uk/dwr/browser/util/useloadingmessage
  */
DWRUtil.useLoadingImage  = function(imageSrc) {
   var loadingImage;
   if (imageSrc)
loadingImage = imageSrc;
   else loadingImage = "ajax-loader.gif";
   DWREngine.setPreHook(function() {
 var disabledImageZone = $('disabledImageZone');
 if (!disabledImageZone) {
   disabledImageZone = document.createElement('div');
   disabledImageZone.setAttribute('id', 'disabledImageZone');
   disabledImageZone.style.position = "absolute";
   disabledImageZone.style.zIndex = "1000";
   disabledImageZone.style.left = "0px";
   disabledImageZone.style.top = "0px";
   disabledImageZone.style.width = "100%";
   disabledImageZone.style.height = "100%";
   var imageZone = document.createElement('img');
   imageZone.setAttribute('id','imageZone');
   imageZone.setAttribute('src',imageSrc);
   imageZone.style.position = "absolute";
   imageZone.style.top = "0px";
   imageZone.style.right = "0px";
   disabledImageZone.appendChild(imageZone);
   document.body.appendChild(disabledImageZone);
 }
 else {
   $('imageZone').src = imageSrc;
   disabledImageZone.style.visibility = 'visible';
 }
   });
   DWREngine.setPostHook(function() {
 $('disabledImageZone').style.visibility = 'hidden';
   });
}

Just drop that into util.js, clear your cache and reload your page. It 
should then be accessible.

All you have to do now is change your code to call the new function 
right before executing your Ajax call (like this):

DWRUtil.useLoadingImage("/images/ajax-loader.gif");

// send data to CF
DWREngine._execute(_ajaxConfig._cfscriptLocation, null, 'publishFeed', 
fid, doEchoResult); 

If you simply specify it like that, the function will create a DIV with 
an ID of "disabledImageZone" and an image with an ID of "imageZone". If 
you want to have some flexibility in where your Ajax indicator will 
display, then just create your own DIV with a child image inside 
wherever you want the indicator to appear (like this):



I hope this helps someone out and thanks again Rob, for building 
AjaxCFC. Its awesome.

Rey...



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: captcha

2006-08-16 Thread Denny Valliant
On 8/15/06, Peter J. Farrell <[EMAIL PROTECTED]> wrote:


> Untill be have an international "identity" system - Captchas and email
> confirmation (like click here to activate your account) will increase in use
> -- a necessary evil at the moment.


OMG! Please don't say you want to take the anonymous out of the internet!
That's just about toast already. *sniff*
What about all those terrorists though, right? Arrrg!!! I hate that people
are willing to trade everything for nutt'n.
Not that /you/ are, I just remembered that I like anonymity, even if I can't
spell it, or don't use it.

Anyways... the captcha is a PITA, for some people; I mean it's just too
new.  I've seen folks just struggle and struggle...
Given time, more people will "get" what's being asked, but I would opt for a
simple CSS and 2+3 = ? type deal over
a image based captcha.  You can make your CSS and stuff really complicated,
thus being a PITA for the spammer,
yet not being a PITA for the end user. (First I'd try the "timed"/"hidden"
approach though, as it doesn't effect the end user AT ALL;)

Guess some people have problems with simple math too, so might as well have
an watermelon picture and expect "manzano" back.

Only a human really knows if it's spam or poor email formatting, sadly.  I
don't think "identities" would stop it, either.
(Only the outlaws have guns, so to speak.)

As always, it depends on the specs and context as to what's best... but
we're not training dogs here, building a
really strong and high fence the first time isn't always needed.  99% of the
time, a really short one will do the job.

Just my .02, after watching grandma try to figure out what that image said.
Guess it's an argument against captcha in general...
I mean, same as the terrorist argument, really.  Why should I give up my
freedom because of spammers?

Rhetorical question^. I can figure out the "logic" behind the idea... I'm
just saying... impact the good guys last :-)


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: Accessing application variables between 2 different applications?

2006-08-16 Thread Alan Rother
Let me ask the next logical question, these variables you want to access...
Are they dynamic in some way, or are you looking to simplify updating a
large number of static variables?

If you are looking to just share a large group of static variables you can
simply create an external file that gets included in both application.cfms.
This include file would contain the set code for all of those variables and
you would then have all of the same variables and values in each
application. Keep in mind this method would not actually allow you to share
the variables, but rather mirror them.

HTH

=]

-- 
Alan Rother
Macromedia Certified Advanced ColdFusion MX 7 Developer


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250082
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 var bug?

2006-08-16 Thread Sixten Otto
>Is there a way to make it return a value if the id is already in the
>database?

How about:

declare @tableId int
select @tableId = tableid from table
where someotherID=#arguments.someotherID#

if @tableId is null 
begin
insert into table (
someotherId
) values (
#arguments.someotherID#
)
set @tableId = @@IDENTITY
end
select @tableId as tableId

Sixten

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: OT: Requirements Gathering/Analysis Software

2006-08-16 Thread Denny Valliant
On 8/15/06, Neil Middleton <[EMAIL PROTECTED]> wrote:
>
> hmm, I feel an open-source project coming on...
>
> who wants in?


I don't know about you, but I feel $$$ coming on... ;-)

OpenSource ShmopenSource! Let's corner the market and make a bazillion
dollers!


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: Accessing application variables between 2 different applications?

2006-08-16 Thread Denny Valliant
Yeah, it's probably doable; reasons for not doing it include lack of power
(createobject) and use of undocumented, and thus "changeable", methods.

But if you can grab session vars from various sessions (you can), I'm
betting you can grab app vars as well.

I can dig up the "get at session vars" code, but IIRC, Snake has it blogged
somewhere, and it has comments, unlike my code.
:Den

On 8/15/06, Andy Mcshane <[EMAIL PROTECTED]> wrote:
>
> I know this is probably a stupid question, as it most likely has security
> inplications, but I have 2 applications running on the same server and I was
> wondering if it is possible to access an application variables in one
> application from the other application, is this possible and if it is what
> would be the reasons against doing such a thing?
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


XML parsing & link underline

2006-08-16 Thread O�uz_Demirkap
Hi,

I have a CF project where I parse an XML document by a Java based tool and
generate a PPT file.

I need to show underline for a link now and I have a syntax as 

www.mydomain.com

in my XML file.

But it displays as www.mydomain.com in output.


I guess this is an issue on my Java code but I remember same kind of
problems on Flash & XML combination. 

Do you have any experience something like that? 

Any tip would be appreciated?


Sincerely,

Oðuz Demirkapý





~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250078
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 var bug?

2006-08-16 Thread Russ
Actually the first query was supposed to return something... the original
query went something like this

declare @tableId int
if not exists (
select tableid from table
where
someotherID=#arguments.someotherID#
) 
begin
insert into table (
someotherId
) values (
#arguments.someotherID#
)
set @tableId = @@IDENTITY
select @tableId as tableId
end

Is there a way to make it return a value if the id is already in the
database?

Russ

> -Original Message-
> From: Ian Skinner [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 16, 2006 5:39 PM
> To: CF-Talk
> Subject: RE: ColdFusion var bug?
> 
> Is this a CF bug?  I got around it by creating a local struct and then
> putting those variables into that struct, but in general, this is not
> intended behaviour, correct?
> 
> Probably not, but you also do not need the name parameter for the first
> query since, as you say, it does not return a value.  I suspect that would
> also be a work around.
> 
> 
> 
> 
> --
> Ian Skinner
> Web Programmer
> BloodSource
> www.BloodSource.org
> Sacramento, CA
> 
> -
> | 1 |   |
> -  Binary Soduko
> |   |   |
> -
> 
> "C code. C code run. Run code run. Please!"
> - Cynthia Dunning
> 
> 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.
> 
> 
> 
> 
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: Stumped on CFC param issue

2006-08-16 Thread Rey Bango
Thanks Matt. It really doesn't solve my problem though as the original 
issue is that the method chkMDSInventory() is saying that the params are 
not numeric values when in fact they are.

I appreciate the suggestion though.

Rey...

Matt Williams wrote:
> Try:
>  ),NumberFormat(variables.thisquantity) )>
> 
> Or
> 
>  variables.thisquantity) )>
> 
> 
> 
> On 8/16/06, Rey Bango <[EMAIL PROTECTED]> wrote:
> 
>>Yea tell me about it. I tried all these different variations of the code
>>and it was still throwing the error. I even ran through the other
>>section of the app that uses the same code because I was scared that the
>>site might be blowing up but everything is working just fine.
>>
>>I'll check out the rewrite suggestions.
>>
>>Thanks Ben
>>
>>Rey...
>>
>>Ben Nadel wrote:
>>
>>>That is a crazy error... I would erase the few lines of code that
>>
>>actually
>>
>>>call the chkMDSInventory() method and rewrite them... Sometimes that
>>
>>works
>>
>>>for me for  crazy errors.
>>>
>>
>>
> 
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Regular Expression Hell

2006-08-16 Thread Ian Skinner
Just so everybody posting [^a-z] as a suggestion, the original list does not 
contain all the letters.  This may just be a typo, but the list 
'abcdefghiklmnpqrstvwyz' does not contain the letters 'j', 'o' or 'u'.


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

-
| 1 |   |
-  Binary Soduko
|   |   |
-
 
"C code. C code run. Run code run. Please!"
- Cynthia Dunning

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. 




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Regular Expression Hell

2006-08-16 Thread Ian Skinner
I don't think the ^ needs to be inside the brackets because that is not a 
character unless it's escaped, it indicates to start at the beginning of the 
line.

It has a different meaning inside of brackets [].  Inside brackets it means 
NOT.  So [a-z] is all lower case letters, [^a-z] is everything NOT a lower case 
letter.



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

-
| 1 |   |
-  Binary Soduko
|   |   |
-
 
"C code. C code run. Run code run. Please!"
- Cynthia Dunning

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. 




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: Regular Expression Hell

2006-08-16 Thread Charlie Griefer
i think he was doing a rereplaceNoCase() (i deleted the original and
too lazy to check the archives)...in which case he wouldn't need to
explicitly specify the upper and lowercase values :)

On 8/16/06, Ian Skinner <[EMAIL PROTECTED]> wrote:
> If I am reading the original post correctly, there are some letters that are 
> allowed [abcdefghiklmnpqrstvwyz].
>
> If that is correct one would be looking for [^a-ik-npq-tw-z/s].  But this 
> assumes that your list wasn't just a typo and you really do not want to 
> replace all lower case letters [^a-z/s].  Also if you want uppercase letters 
> you need to also specify them [^a-zA-Z/s].
>
> HTH
>
> --
> Ian Skinner
> Web Programmer
> BloodSource
> www.BloodSource.org
> Sacramento, CA
>
> -
> | 1 |   |
> -  Binary Soduko
> |   |   |
> -
>
> "C code. C code run. Run code run. Please!"
> - Cynthia Dunning
>
> 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.
>
>
>
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Printing issues

2006-08-16 Thread Jenny Gavin-Wear
Hi Rick,

I use this in a print style sheet:
#pagefeed { page-break-after: always
}

and call it at the end of a page with:


There is a good CSS reference here:
http://www.w3schools.com/css/css_ref_print.asp

You can add separate style sheets to a page for each medium, for example:







This can be really useful when you don't want parts of a page to print, such as 
navigation.

Jenny




-Original Message-
From: Josh Nathanson [mailto:[EMAIL PROTECTED]
Sent: 16 August 2006 21:39
To: CF-Talk
Subject: Re: Printing issues


You can do a page break with css:



Put that where you want a page break to go.  I think that will work across 
browsers.  Of course, if the page is dynamically generated you'll need to 
take that into account.

-- Josh


- Original Message - 
From: "Rick Root" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Wednesday, August 16, 2006 1:14 PM
Subject: OT: Printing issues


> Okay, another off topic.
>
> I'm not one for printing out HTML documents, so I don't know if this is
> normal or not.
>
> This page:
>
> https://www.cfr.duke.edu/DukeFacultyandStaffSeekingFoundationFunding.cfm
>
> (I didn't make that file name, don't blame me!)
>
> When I print it (and it shows up in print preview too), a line at the
> bottm of the second page actually gets cut off and the rest of it prints
> on the third page.  I don't mean some of the words, I mean the top half
> of each letter appears at the end of page 2, and the bottom half of each
> letter appears on the bottom of page 3.
>
> I thought browsers were smart enough to *NOT* do this kind of thing.
>
> It's even worse in Firefox.  Firefox doesn't even have the sense to
> print multiple pages.  It just trails off the bottom and doesn't bother
> printing the second or third pages.
>
> Rick
>
> 



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Regular Expression Hell

2006-08-16 Thread Ian Skinner
If I am reading the original post correctly, there are some letters that are 
allowed [abcdefghiklmnpqrstvwyz].

If that is correct one would be looking for [^a-ik-npq-tw-z/s].  But this 
assumes that your list wasn't just a typo and you really do not want to replace 
all lower case letters [^a-z/s].  Also if you want uppercase letters you need 
to also specify them [^a-zA-Z/s].

HTH

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

-
| 1 |   |
-  Binary Soduko
|   |   |
-
 
"C code. C code run. Run code run. Please!"
- Cynthia Dunning

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. 




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: Stumped on CFC param issue

2006-08-16 Thread Matt Williams
Try:


Or





On 8/16/06, Rey Bango <[EMAIL PROTECTED]> wrote:
>
> Yea tell me about it. I tried all these different variations of the code
> and it was still throwing the error. I even ran through the other
> section of the app that uses the same code because I was scared that the
> site might be blowing up but everything is working just fine.
>
> I'll check out the rewrite suggestions.
>
> Thanks Ben
>
> Rey...
>
> Ben Nadel wrote:
> > That is a crazy error... I would erase the few lines of code that
> actually
> > call the chkMDSInventory() method and rewrite them... Sometimes that
> works
> > for me for  crazy errors.
> >
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: Regular Expression Hell

2006-08-16 Thread Claude Schneegans
 >>REREPLACENOCASE(form.AA_list, '[^abcdefghiklmnpqrstvwyz]','','all')

Try REREPLACENOCASE(form.AA_list, '[^a-z]','','all')

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: Way OT: But you know you want one..

2006-08-16 Thread Dave Lyons
I knew u didnt thats why i just tried to be funny back.

You know I hated macs before osx, had to work with them when i was in my 
medical days, so about a year and a half ago when i was so sick of windows and 
moving towards linux the girls from i can.d would come over with their 
powerbooks and and I wouldnt even look at them because I was hell bent on not 
liking an apple. But one day i gave in and looked and after about 2 minutes I 
was hooked.. no going back and im am sooo glad i did.

That apple keyboard is nice isnt it, they just feel good. I like how most 
everything u buy from apple is just "solid", I have no problem paying a few 
bucks extra for apple stuff since I know im getting better quality then going 
to best buy and buying something that looks good as well but is cheap and 
junky, "looks good but is made with the cheapest parts available" would 
describe most the stuff, that would also describe a dell lol ;)

Hell, im still laughin cause dw knew what a "reach-a-round" was lol


>I also knew it would stir the beast in you :-)
>
>For the record, I am not anti-Apple, well certainly since OSX! (9.5 and
>below were piss poor) I was just paraphrasing the iProduct piss take on the
>web...
>
>I have had an iPod since day 1 of their release and currently biding my time
>for the full face touch screen version at the end of the year :-) 
>
>Even use an Apple keyboard at work on my Windows machine.
>
>What do you expect though - their products are designed by a Britthey
>cannot fail.
>
>
>
>
>"casts reel"
>
>
>
>
>
>
>
>
>"This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant,
>Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business,
>Registered in England, Number 678540.  It contains information which is
>confidential and may also be privileged.  It is for the exclusive use of the
>intended recipient(s).  If you are not the intended recipient(s) please note
>that any form of distribution, copying or use of this communication or the
>information in it is strictly prohibited and may be unlawful.  If you have
>received this communication in error please return it to the sender or call
>our switchboard on +44 (0) 20 89107910.  The opinions expressed within this
>communication are not necessarily those expressed by Reed Exhibitions." 
>Visit our website at http://www.reedexpo.com
>
>-Original Message-
>From: Dave Lyons
>To: CF-Talk
>Sent: Wed Aug 16 02:34:44 2006
>Subject: Re: Way OT: But you know you want one..
>
>lmfao, that was pretty good dave!
>
>In my defense tho, for me personally I think it's a good thing I don't know
>how to do it right!! Why and/or how you know, i just dont wanna know!! 
>
>The reacharound has to be one of the funniest things ever tho, quite frankly
>I didn't know how many people on here would actually "get it" but it made me
>laugh without going after neil for apple bashin, since I do actually like
>neil, he's not on my "connie" or "snake" list.
>
>
>a

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Regular Expression Hell

2006-08-16 Thread Jake Churchill
Never done regexs with CF but you usually don't have to list all a-z,
you just do [a-z] and I don't think the ^ needs to be inside the
brackets because that is not a character unless it's escapted, it
indicates to start at the beginning of the line.  While this is a stab
in the dark, I'd try ^[a-z]

Jake Churchill
CF Web Tools
[EMAIL PROTECTED]
402-408-3733 x103


-Original Message-
From: Richard Colman [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 16, 2006 4:37 PM
To: CF-Talk
Subject: Regular Expression Hell


Trying to replace everything that is NOT:

abcdefghiklmnpqrstvwyz 

with a blank (including white space, returns, etc.)


Thought this would work, but it does not:



Help!

Rick Colman







~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: ColdFusion var bug?

2006-08-16 Thread Ben Nadel
Russ,

That looks like a bug to me. 

...
Ben Nadel 
www.bennadel.com

-Original Message-
From: Russ [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 16, 2006 5:33 PM
To: CF-Talk
Subject: ColdFusion var bug?

Looks like I found a bug in coldfusion in regards to varing variables in a
cfc.  Here is the example code to reproduce. 

 



  

 

  

DELETE FROM  table 

WHERE tableid=-1



  

  

select tableid from users where tableid=1



 



  

 

 

 

Then run this on a test page.  







 

If you've set everything up right, you'll see a dump of a query.  In reality
you should be getting an exception.  

 

 

I think what happens is when the first query runs, it deletes the variable,
since it doesn't return anything.  When the second select query runs, it
recreates the variable as a regular variable which is local to the cfc, not
the function.  

 

Is this a CF bug?  I got around it by creating a local struct and then
putting those variables into that struct, but in general, this is not
intended behaviour, correct?  

 

 

 

Russ





~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: OT: Anyone else affected by the hostmysite outage?

2006-08-16 Thread Munson, Jacob
In my state, they are /required/ to find out about lines before digging,
and there is a service that will mark them for you.  We had it done at
my house when we had a cable line installed, it didn't cost us any
money.  My guess is they didn't even get the lines marked.

> -Original Message-
> From: Josh Nathanson [mailto:[EMAIL PROTECTED] 
> Sent: Wednesday, August 16, 2006 2:26 PM
> 
> Fact is those construction guys are supposed to know about 
> where gas lines, 
> electrical, cables etc. are located before they start 
> digging.  Out here in 
> Cali a couple of years ago, a few guys died when they hit a 
> gas line and 
> caused a huge explosion.  The construction company 
> undoubtedly has insurance 
> so if I were HMS I'd nail them to the wall, they could probably get a 
> settlement without even going to court.
> 
> If the cables weren't marked though, then that's somebody 
> else's fault, not 
> the construction company's.  Not sure who'd be responsible for that.

This transmission may contain information that is privileged, confidential 
and/or exempt from disclosure under applicable law. If you are not the intended 
recipient, you are hereby notified that any disclosure, copying, distribution, 
or use of the information contained herein (including any reliance thereon) is 
STRICTLY PROHIBITED. If you received this transmission in error, please 
immediately contact the sender and destroy the material in its entirety, 
whether in electronic or hard copy format. Thank you. A1.



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Regular Expression Hell

2006-08-16 Thread Ben Nadel
Not sure exactly what you are saying, but you can include "white space" in
your regular expression:

[^a-z\s]

a-z : alphabet

\s : special character means "white space"
 
...
Ben Nadel 
www.bennadel.com

-Original Message-
From: Richard Colman [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 16, 2006 5:37 PM
To: CF-Talk
Subject: Regular Expression Hell

Trying to replace everything that is NOT:

abcdefghiklmnpqrstvwyz 

with a blank (including white space, returns, etc.)


Thought this would work, but it does not:



Help!

Rick Colman







~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: ColdFusion var bug?

2006-08-16 Thread Ian Skinner
Is this a CF bug?  I got around it by creating a local struct and then putting 
those variables into that struct, but in general, this is not intended 
behaviour, correct?  

Probably not, but you also do not need the name parameter for the first query 
since, as you say, it does not return a value.  I suspect that would also be a 
work around.




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

-
| 1 |   |
-  Binary Soduko
|   |   |
-
 
"C code. C code run. Run code run. Please!"
- Cynthia Dunning

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. 




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Regular Expression Hell

2006-08-16 Thread Richard Colman
Trying to replace everything that is NOT:

abcdefghiklmnpqrstvwyz 

with a blank (including white space, returns, etc.)


Thought this would work, but it does not:



Help!

Rick Colman





~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


ColdFusion var bug?

2006-08-16 Thread Russ
Looks like I found a bug in coldfusion in regards to varing variables in a
cfc.  Here is the example code to reproduce. 

 



  

 

  

DELETE FROM  table 

WHERE tableid=-1



  

  

select tableid from users where tableid=1



 



  

 

 

 

Then run this on a test page.  







 

If you've set everything up right, you'll see a dump of a query.  In reality
you should be getting an exception.  

 

 

I think what happens is when the first query runs, it deletes the variable,
since it doesn't return anything.  When the second select query runs, it
recreates the variable as a regular variable which is local to the cfc, not
the function.  

 

Is this a CF bug?  I got around it by creating a local struct and then
putting those variables into that struct, but in general, this is not
intended behaviour, correct?  

 

 

 

Russ



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: Zipcodes addresses and all that jazz

2006-08-16 Thread Dave Lyons
I just did a dealer finder based on zipcode that returns a google map, it also 
fetches their address and brings back lat & long and puts in db for accurate 
showing on map.

But here is the problem(s) you will run into. 
The first is that if you try and use a geoservice or in my case i go right at 
google, your address must be a certain way or you will get a false address. 
What I mean is if there is "additional" info in address it can throw it off, so 
say

123 elm st, denver, co  - that will work ok

but the following addresses with come back with an error:

123 s elm st ste #14, denver, co

or

123 s elm st ste 14 building 5, denver, co


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Way OT: But you know you want one..

2006-08-16 Thread Kevin Aebig
I'll have what he's drinking... cheers!

!k

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 15, 2006 6:44 PM
To: CF-Talk
Subject: RE: Way OT: But you know you want one..

> so is that the same as "windows-ites" do when ms copies.., 
> sorry, i mean "innovates" that same shit in a bin and all the 
> "windows-ites" go stick their tongues up bills bum and give 
> him a good ole fashion reach around?

Without getting into another endless Mac vs PC debate, I would just like to
point out that a reacharound does not involve analingus. In other words,
you're doing it wrong. In addition, to get the derogatory effect you're
trying to achieve, you'd want to describe Bill Gates' giving Windows users a
reacharound, not the other way around. Here's an example:

"Bill G really screwed me hard with Windows ME, and I didn't even get a
reacharound!"

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

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: zip code converter

2006-08-16 Thread Dave Lyons
I believe that free db someone suggested is like from 1999, i just did this and 
bought that $5 current one from http://teamredline.com/zc/default.asp

then just do a simply query(not putting all the extra crap in)

select * from tbl_zipcodes where zipcode = form.zipcode

and output

qry.city

its rocket science there!!

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: OT: Anyone else affected by the hostmysite outage?

2006-08-16 Thread Dave Lyons
yup, i got about 30 sites on that datacenter, thankfully the rest are at 
datacenter 2.

All 4 lines got cut and comcast cant fix them so they are having to replace the 
whole sections of them.

The bad part is that they are supposed to rollover to the other datacenter and 
it didnt happen, i suppose they can't without a connection tho.

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: OT: Anyone else affected by the hostmysite outage?

2006-08-16 Thread Crow T Robot
DigSafe, maybe?


- Original Message - 
From: "Josh Nathanson" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Wednesday, August 16, 2006 4:26 PM
Subject: Re: OT: Anyone else affected by the hostmysite outage?


> Fact is those construction guys are supposed to know about where gas
lines,
> electrical, cables etc. are located before they start digging.  Out here
in
> Cali a couple of years ago, a few guys died when they hit a gas line and
> caused a huge explosion.  The construction company undoubtedly has
insurance
> so if I were HMS I'd nail them to the wall, they could probably get a
> settlement without even going to court.
>
> If the cables weren't marked though, then that's somebody else's fault,
not
> the construction company's.  Not sure who'd be responsible for that.
>
> -- Josh
>
> - Original Message - 
> From: "Bryan Stevenson" <[EMAIL PROTECTED]>
> To: "CF-Talk" 
> Sent: Wednesday, August 16, 2006 1:01 PM
> Subject: Re: OT: Anyone else affected by the hostmysite outage?
>
>
> > Same damn thing happend in Vancouver, BC last year.  The ISP that
supplies
> > one
> > of our federal government clients was next to a sky scraper building
site.
> > The
> > big pit they dug caved in due to a sink hole and took the sidewalk and
> > most of
> > the street with it...along with the various pipes feeding the ISP.
> >
> > .and they said they'd never be down for more than 4 hours...try a
> > week!!
> >
> > If Mother Nature wants to get you...she will ;-)
> >
> > Cheers
> >
> > Bryan Stevenson B.Comm.
> > VP & Director of E-Commerce Development
> > Electric Edge Systems Group Inc.
> > phone: 250.480.0642
> > fax: 250.480.1264
> > cell: 250.920.8830
> > e-mail: [EMAIL PROTECTED]
> > web: www.electricedgesystems.com
> >
> >
> >
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: Web Service that returns blank page?

2006-08-16 Thread David
Some modifications (from a working SOAP project I worked on a while
ago, with a non-WSDL'd webservice)

1. XML may need  first; rest looks good
2. CFHTTP: Post method, Soap XML message should be in cfhttpparam
type="body", not type="XML"
May need some other headers, too.

- David


On 8/15/06, Deanna Schneider <[EMAIL PROTECTED]> wrote:
> Okay, I'm back on this issue.  I've now attempted to write the soap
> request manually. (See code below.) But, I get the error below. Any
> brilliant ideas? (Hey - at least I'm getting a valid SOAP response
> now, eh?)
>
> 
> Can't find root element in the
> message at /usr/footprints_perl/lib/site_perl/5.8.1/SOAP/Lite.pm line
> 2154.
> 
>
> My code (userid and password omitted).
> 
>  xmlns:soap-env="http://schemas.xmlsoap.org/soap/envelope/";
> xmlns:xsi="http://www.w3.org/1999/XMLSchema-instance";
> xmlns:xsd="http://www.w3.org/1999/XMLSchema";>
>
> 
> 
>
>
>   
>  xmlns:m="https://footprints.uwex.edu/MRcgi/MRWebServices.pl";>
>   ...
>   ...
>   
>   select mrID, mrtitle from master78
> 
>   
>
> 
> https://footprints.uwex.edu/MRcgi/MRWebServices.pl"; 
> method="POST">
> value="https://footprints.uwex.edu/MRcgi/MRWebServices.pl";>
> 
> 
>
>
> #cfhttp.filecontent#
>
>

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: Printing issues

2006-08-16 Thread Josh Nathanson
You can do a page break with css:



Put that where you want a page break to go.  I think that will work across 
browsers.  Of course, if the page is dynamically generated you'll need to 
take that into account.

-- Josh


- Original Message - 
From: "Rick Root" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Wednesday, August 16, 2006 1:14 PM
Subject: OT: Printing issues


> Okay, another off topic.
>
> I'm not one for printing out HTML documents, so I don't know if this is
> normal or not.
>
> This page:
>
> https://www.cfr.duke.edu/DukeFacultyandStaffSeekingFoundationFunding.cfm
>
> (I didn't make that file name, don't blame me!)
>
> When I print it (and it shows up in print preview too), a line at the
> bottm of the second page actually gets cut off and the rest of it prints
> on the third page.  I don't mean some of the words, I mean the top half
> of each letter appears at the end of page 2, and the bottom half of each
> letter appears on the bottom of page 3.
>
> I thought browsers were smart enough to *NOT* do this kind of thing.
>
> It's even worse in Firefox.  Firefox doesn't even have the sense to
> print multiple pages.  It just trails off the bottom and doesn't bother
> printing the second or third pages.
>
> Rick
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: OT: Anyone else affected by the hostmysite outage?

2006-08-16 Thread Josh Nathanson
Fact is those construction guys are supposed to know about where gas lines, 
electrical, cables etc. are located before they start digging.  Out here in 
Cali a couple of years ago, a few guys died when they hit a gas line and 
caused a huge explosion.  The construction company undoubtedly has insurance 
so if I were HMS I'd nail them to the wall, they could probably get a 
settlement without even going to court.

If the cables weren't marked though, then that's somebody else's fault, not 
the construction company's.  Not sure who'd be responsible for that.

-- Josh

- Original Message - 
From: "Bryan Stevenson" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Wednesday, August 16, 2006 1:01 PM
Subject: Re: OT: Anyone else affected by the hostmysite outage?


> Same damn thing happend in Vancouver, BC last year.  The ISP that supplies 
> one
> of our federal government clients was next to a sky scraper building site. 
> The
> big pit they dug caved in due to a sink hole and took the sidewalk and 
> most of
> the street with it...along with the various pipes feeding the ISP.
>
> .and they said they'd never be down for more than 4 hours...try a 
> week!!
>
> If Mother Nature wants to get you...she will ;-)
>
> Cheers
>
> Bryan Stevenson B.Comm.
> VP & Director of E-Commerce Development
> Electric Edge Systems Group Inc.
> phone: 250.480.0642
> fax: 250.480.1264
> cell: 250.920.8830
> e-mail: [EMAIL PROTECTED]
> web: www.electricedgesystems.com
>
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Cfimpersonate, Cfdirectory, MX

2006-08-16 Thread Patrick McGeehan
Back in the days of CF4 and 5 I used to use a cfdirectory wrapped in a
cfimpersonate to have users supply passwords then have cf read network
shares that they had access to on a file server.  I know that I could
have logged the CF service in as a user with permission (in fact I did
that on another application) but this worked the best for shares that
theoretically were supposed to only be accessed by their owner.  
 
I am at a loss as to how to do this (if possible) with the array of new
security features in MX and 7.  I am currently using
jrun.security.NTAuth to authenticate my users, but still am not sure if
I can or how to use user supplied credentials to access network
resources.  
 
Any help that you could give or point me to would be greatly
appreciated.
 
Thanks
Patrick


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: OT: Anyone else affected by the hostmysite outage?

2006-08-16 Thread Bryan Stevenson
Same damn thing happend in Vancouver, BC last year.  The ISP that supplies one 
of our federal government clients was next to a sky scraper building site.  The 
big pit they dug caved in due to a sink hole and took the sidewalk and most of 
the street with it...along with the various pipes feeding the ISP.

.and they said they'd never be down for more than 4 hours...try a week!!

If Mother Nature wants to get you...she will ;-)

Cheers

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com 


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


OT: Printing issues

2006-08-16 Thread Rick Root
Okay, another off topic.

I'm not one for printing out HTML documents, so I don't know if this is 
normal or not.

This page:

https://www.cfr.duke.edu/DukeFacultyandStaffSeekingFoundationFunding.cfm

(I didn't make that file name, don't blame me!)

When I print it (and it shows up in print preview too), a line at the 
bottm of the second page actually gets cut off and the rest of it prints 
on the third page.  I don't mean some of the words, I mean the top half 
of each letter appears at the end of page 2, and the bottom half of each 
letter appears on the bottom of page 3.

I thought browsers were smart enough to *NOT* do this kind of thing.

It's even worse in Firefox.  Firefox doesn't even have the sense to 
print multiple pages.  It just trails off the bottom and doesn't bother 
printing the second or third pages.

Rick

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: Flash form/Firefox Select multiple?

2006-08-16 Thread Will Tomlinson
>What version of the Flash Player are you using in IE? What version of the
>Flash Player are you using in Firefox? The browser shouldn't matter too
>much, but the Flash Player version may well matter.

As usual, you hit the nail on the head! FF is using 9, IE is using 8!

So what to do? Just give up on this flash form and convert it to a normal one? 
That'd suck, cause I REALLY like this thing. It's slick lookin'!

Thanks,
Will

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: OT: Anyone else affected by the hostmysite outage?

2006-08-16 Thread Munson, Jacob
Yeah, in a fancy Flash slide show.  I guess when you're sitting around
twiddling your thumbs, waiting for a line to be fixed, you have time to
do stuff like that.  :)

> -Original Message-
> From: Casey Dougall [mailto:[EMAIL PROTECTED] 
> Sent: Wednesday, August 16, 2006 12:50 PM
> 
> ha... they posted photos of the pipe... I guess we can 
> believe them now.
> http://hostmysite.com/emergency/

This transmission may contain information that is privileged, confidential 
and/or exempt from disclosure under applicable law. If you are not the intended 
recipient, you are hereby notified that any disclosure, copying, distribution, 
or use of the information contained herein (including any reliance thereon) is 
STRICTLY PROHIBITED. If you received this transmission in error, please 
immediately contact the sender and destroy the material in its entirety, 
whether in electronic or hard copy format. Thank you. A1.



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


3 Tier and CFC to CFC Remoting

2006-08-16 Thread Rick Schmitty
Is there a way to call a cfc remotely in a n tier setup outside of a
web service?

Right now you have to invoke a webservice to communicate between your
web server and application server in an n-tier environment.  Is there
a way to 'remote' in like you do in Flex using the AMF gateway
serialization for a speed increase?

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: Stumped on CFC param issue

2006-08-16 Thread Rey Bango
> is productid a character type on the database? if so you may want to wrap a
> trim() around it somewhere in the sql or maybe an int() function (depending
> on your dbms)
> 
> if it is numeric on the db then I have no idea :-)
> 

Hi Michael,

Its an int. :P

Rey...

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Zipcodes addresses and all that jazz

2006-08-16 Thread Turetsky, Seth
I don't know much about ESRI, but Microsoft allows to get driving directions 
and distance in their JS API(definitely free), google and yahoo(I believe) do 
not.  M$'s other web service API(not sure about price), which I have not used 
and not sure if CF can use it, is also very extensive.  To me, more impressive 
than google/yahoo.

As for the name of each of these API's, I may have said Mappoint when I should 
have said Virtual Earth.  There's also Windows Live Local, whew can they settle 
on one name!?! :)  

-Original Message-
From: Paul Hastings [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 16, 2006 2:56 PM
To: CF-Talk
Subject: Re: Zipcodes addresses and all that jazz

Turetsky, Seth wrote:
> I think it's free now

the mappoint/whatever stuff was insanely expensive compared to the redlands 
folks. not to mention that these days esri's doing a lot of work in flex. ms's 
spatial stuff doesn't overly impress me.



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: zip code converter

2006-08-16 Thread Mike Tangorre
Is that nice Ray?



From: "Ray Champagne" <[EMAIL PROTECTED]>
>I take no advice from upstate New Yorkers.




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: Stumped on CFC param issue

2006-08-16 Thread Rey Bango
Yea tell me about it. I tried all these different variations of the code 
and it was still throwing the error. I even ran through the other 
section of the app that uses the same code because I was scared that the 
site might be blowing up but everything is working just fine.

I'll check out the rewrite suggestions.

Thanks Ben

Rey...

Ben Nadel wrote:
> That is a crazy error... I would erase the few lines of code that actually
> call the chkMDSInventory() method and rewrite them... Sometimes that works
> for me for  crazy errors. 
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: OT: Anyone else affected by the hostmysite outage?

2006-08-16 Thread Everett, Al \(NIH/NIGMS\) [C]
"Call before you dig!"

I expect there will be a lawsuit or three out of this.

-Original Message-
From: Casey Dougall [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 16, 2006 2:50 PM
To: CF-Talk
Subject: Re: OT: Anyone else affected by the hostmysite outage?

ha... they posted photos of the pipe... I guess we can believe them now.
http://hostmysite.com/emergency/

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: Select * in a view needs "recompiled"

2006-08-16 Thread Jim Wright
On 8/16/06, Brent Shaub <[EMAIL PROTECTED]> wrote:
> I was just thinking that there might be a setting in SQL Server that was 
> geared for optimization and cached the view definition.  Perhaps there is a 
> way to reconfigure it to check for changes more often.  I might not change it 
> because it's a small extra step to re-save each view (there aren't many) when 
> I change a table that is referenced by a * in that view.  It's a question of 
> SQL-processing performance vs development-time performance.
>

You can use the sp_refreshview stored procedure when making
changes...if you google on it, you can find scripts out there for
looping through all views that reference a certain table and
refreshing them.  There is an option to create a view with
SCHEMABINDING, but that actually locks the underlying structure, so
you can't make changes to the table.

-- 
Jim Wright
Wright Business Solutions
[EMAIL PROTECTED]
919-417-2257

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: zip code converter

2006-08-16 Thread Ray Champagne
Seriously, though, thanks.  Think I'm going the USPS API route.


- Original Message - 
From: "Mike Tangorre" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Wednesday, August 16, 2006 1:20 PM
Subject: Re: zip code converter


> Ray,
>
> There is a zip file over at Pengoworks.com that contains
> zip,city,state,county,lat,long,area code, etc
>
> It is not the most current resource as Dan Switzer was providing it to
work
> with a few JS Gateway examples he developed. You can also use some web
> services from the USPS I believe...
>
> Tango.
>
>
>
>
> From: "Ray Champagne" <[EMAIL PROTECTED]>
> > Anyone know of a good custom tag that will take in a zip code and return
a
> > city/town that it belongs to?
>
>
>
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: Stumped on CFC param issue

2006-08-16 Thread Michael Traher
is productid a character type on the database? if so you may want to wrap a
trim() around it somewhere in the sql or maybe an int() function (depending
on your dbms)

if it is numeric on the db then I have no idea :-)

On 8/16/06, Rey Bango <[EMAIL PROTECTED]> wrote:
>
> I'm a little stumped on this. I have a cfc which contains a method that
> checks inventory levels. Its defined as:
>
> 
> 
> 
> ...
> 
> 
>
> I've used this in my code before with no issues at all.
>
> So, I go to use it in another part of the site via the following snippet
> of code:
>
> 
>  createObject("component","com.inventory.inventory").init() />
>
> 
> Select ProductID
> from products
> where sku =  cfsqltype="CF_SQL_VARCHAR">
> 
>
>  variables.thisquantity )>
> 
> 
>
> When I run this, I get an error back saying:
>
> "The argument PRODUCTID passed to function chkMDSInventory() is not of
> type numeric."
>
> Now, I've verified that both getProductInfo.productid &
> variables.thisquantity are numeric by using the isNumeric CF function
> and they are numeric values. But it still throws this error. The code
> above is almost exactly to code that I use in another part of the site
> which performs perfectly.
>
> Now here's the kicker. If I change the code to this:
>
> 
> 
>
> 
> 
> 
>
> it works just fine! I'm stumped. I have no idea why isNumeric() would
> report the values as numeric but the CFC's method won't especially when
> this same code works just fine in another part of the site.
>
> Any ideas?
>
> Rey...
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: zip code converter

2006-08-16 Thread Ray Champagne
I take no advice from upstate New Yorkers.


- Original Message - 
From: "Mike Tangorre" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Wednesday, August 16, 2006 1:20 PM
Subject: Re: zip code converter


> Ray,
>
> There is a zip file over at Pengoworks.com that contains
> zip,city,state,county,lat,long,area code, etc
>
> It is not the most current resource as Dan Switzer was providing it to
work
> with a few JS Gateway examples he developed. You can also use some web
> services from the USPS I believe...
>
> Tango.
>
>
>
>
> From: "Ray Champagne" <[EMAIL PROTECTED]>
> > Anyone know of a good custom tag that will take in a zip code and return
a
> > city/town that it belongs to?
>
>
>
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Stumped on CFC param issue

2006-08-16 Thread Ben Nadel
That is a crazy error... I would erase the few lines of code that actually
call the chkMDSInventory() method and rewrite them... Sometimes that works
for me for  crazy errors. 

...
Ben Nadel 
Web Developer
Nylon Technology
350 7th Avenue
Floor 10
New York, NY 10001
212.691.1134 x 14
212.691.3477 fax
www.nylontechnology.com
 
"Some people call me the space cowboy. Some people call me the gangster of
love."

-Original Message-
From: Rey Bango [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 16, 2006 3:01 PM
To: CF-Talk
Subject: Stumped on CFC param issue

I'm a little stumped on this. I have a cfc which contains a method that
checks inventory levels. Its defined as:


 


...



I've used this in my code before with no issues at all.

So, I go to use it in another part of the site via the following snippet of
code:

 

 Select ProductID
from products where sku = 
  





When I run this, I get an error back saying:

"The argument PRODUCTID passed to function chkMDSInventory() is not of type
numeric."

Now, I've verified that both getProductInfo.productid &
variables.thisquantity are numeric by using the isNumeric CF function and
they are numeric values. But it still throws this error. The code above is
almost exactly to code that I use in another part of the site which performs
perfectly.

Now here's the kicker. If I change the code to this:


   





it works just fine! I'm stumped. I have no idea why isNumeric() would report
the values as numeric but the CFC's method won't especially when this same
code works just fine in another part of the site.

Any ideas?

Rey...



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Stumped on CFC param issue

2006-08-16 Thread Rey Bango
I'm a little stumped on this. I have a cfc which contains a method that 
checks inventory levels. Its defined as:


 
  
...



I've used this in my code before with no issues at all.

So, I go to use it in another part of the site via the following snippet 
of code:





Select ProductID
from products
where sku = 
  





When I run this, I get an error back saying:

"The argument PRODUCTID passed to function chkMDSInventory() is not of 
type numeric."

Now, I've verified that both getProductInfo.productid & 
variables.thisquantity are numeric by using the isNumeric CF function 
and they are numeric values. But it still throws this error. The code 
above is almost exactly to code that I use in another part of the site 
which performs perfectly.

Now here's the kicker. If I change the code to this:


   





it works just fine! I'm stumped. I have no idea why isNumeric() would 
report the values as numeric but the CFC's method won't especially when 
this same code works just fine in another part of the site.

Any ideas?

Rey...

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Licensing question for CF on a VM Machine

2006-08-16 Thread Peterson, Chris
That is a beautiful thing.  Thanks a ton Jon and Big Mad Kev!

Chris Peterson

-Original Message-
From: John Beynon [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 16, 2006 2:56 PM
To: CF-Talk
Subject: Re: Licensing question for CF on a VM Machine

it's per physical processor - so virtual servers all use the same
processor and HT is the same physical proc...so you can go crazy with
the number of virtual servers/cf installs. I had a rep here look into it
too and that's the answer he came back with,

jb.

On 8/16/06, Peterson, Chris <[EMAIL PROTECTED]> wrote:
> Question, is the Per CPU license for CF Enterprise based on the 
> physical CPU, or the CPU's interpreted by the OS?  If physical CPU, 
> can I run 4 virtual servers on a single CPU box and install CF on each

> one?  If its per CPU seen by the OS, does hyper-threading have to be 
> turned off for me to be legal on a single CPU HT server?
>
> Chris
>
> 



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Zipcodes addresses and all that jazz

2006-08-16 Thread Shelley Browning
Another option: 

You can create a link to MapQuest with your variables...  


http://www.mapquest.com/maps/map.adp?country=US&countryid=US&addtohistor
y=&searchtype=address&cat=&address=#address#&city=#city#&state=#state#&z
ipcode=#zipcode#&search=Search&searchtab=address


Shelley Browning


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: Licensing question for CF on a VM Machine

2006-08-16 Thread John Beynon
it's per physical processor - so virtual servers all use the same
processor and HT is the same physical proc...so you can go crazy with
the number of virtual servers/cf installs. I had a rep here look into
it too and that's the answer he came back with,

jb.

On 8/16/06, Peterson, Chris <[EMAIL PROTECTED]> wrote:
> Question, is the Per CPU license for CF Enterprise based on the physical
> CPU, or the CPU's interpreted by the OS?  If physical CPU, can I run 4
> virtual servers on a single CPU box and install CF on each one?  If its
> per CPU seen by the OS, does hyper-threading have to be turned off for
> me to be legal on a single CPU HT server?
>
> Chris
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: Zipcodes addresses and all that jazz

2006-08-16 Thread Paul Hastings
Turetsky, Seth wrote:
> I think it's free now 

the mappoint/whatever stuff was insanely expensive compared to the 
redlands folks. not to mention that these days esri's doing a lot of 
work in flex. ms's spatial stuff doesn't overly impress me.

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: Using CFQUERY to access DBCC output?

2006-08-16 Thread Dan Plesse
It sure sounds like you need a socket with a listener. I would find an
example already
on the web and use that or add a request for CF 8 to add a feature to tags
which allows
for internal objects to be extended 

Override addlisterner() method.

On 8/16/06, powell @ nauticom. net powell @ nauticom. net <
[EMAIL PROTECTED]> wrote:
>
> I'm trying to automate some of an application's database maintentance
> tasks via a CF script that will check to see if it's time for a defrag,
> index rebuild, etc.  I know that I can put a DBCC statement in a CFQUERY,
> but what's got me scrambling is how to retrieve any output that the DBCC
> might generate. If I feed CFQUERY something like
>DBCC SHOWCONTIG ('activitylog')
> I'd like to be able to get at the 10 or so lines of of output that it
> would normally generate interactively.  But no result set is even created by
> such a query, and I cannot see how to get to the data.  I've tried
> variations of EXECUTE and subqueries, all with no luck.  Is this an
> impossible dream?
>
> thanks
> Reed
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: OT: Anyone else affected by the hostmysite outage?

2006-08-16 Thread Casey Dougall
ha... they posted photos of the pipe... I guess we can believe them now.
http://hostmysite.com/emergency/


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Licensing question for CF on a VM Machine

2006-08-16 Thread Big Mad Kev
I asked our adobe tech rep this a few months ago and it was physical cpu,
even with ht on it may look like twice as many but physically its only half

hth

-Original Message-
From: Peterson, Chris [mailto:[EMAIL PROTECTED] 
Sent: 16 August 2006 19:30
To: CF-Talk
Subject: Licensing question for CF on a VM Machine

Question, is the Per CPU license for CF Enterprise based on the physical
CPU, or the CPU's interpreted by the OS?  If physical CPU, can I run 4
virtual servers on a single CPU box and install CF on each one?  If its per
CPU seen by the OS, does hyper-threading have to be turned off for me to be
legal on a single CPU HT server?

Chris



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: (Admin) RSS options

2006-08-16 Thread Nathan Strutz
Instead of a set number of items in the feed (like 50), why not do it by
date. Everything in the last 3 hrs, for example, with a minimum of 30 or
something.

-nathan strutz
http://www.dopefly.com/


On 8/16/06, Michael Dinowitz <[EMAIL PROTECTED]> wrote:
>
> I'm redoing the RSS today and I'd like to hear what people who are using
> it have to say. I have it cached for performance but how often would you
> like it regenerated? Every 30 minutes? Every hour? How many messages would
> you like in the feed? Currently it's set to 50 for size which usually covers
> all of the messages since the last regeneration.
> Finally, what other features would you like me to add?
>
> If you can email me off list, I'd appreciate it but onlist posts to this
> thread is ok as it's site enhancements.
>
> Thanks
>
> Michael Dinowitz
> President: House of Fusion
> http://www.houseoffusion.com
> Publisher: Fusion Authority
> http://www.fusionauthority.com
> Adobe Community Expert
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: Zipcodes addresses and all that jazz

2006-08-16 Thread Richard Dillman
we dont need a map,  the Dataentry / Receptionist just needs some
coaxing... to put in correct stuff like street direction  sufix...

If i got back a list of possible matches:
I could wrap a link around it to repopulate the form.


On 8/16/06, Paul Hastings <[EMAIL PROTECTED]> wrote:
>
> Turetsky, Seth wrote:
> > I've been playing with Microsoft's Mappoint stuff lately, they offer
> > a lot of stuff that Google does not.  See
> > http://dev.live.com/virtualearth/sdk/ shows some examples and the
> > source of each.
>
> so does esri's webservices but you don't have to sell any of your
> children to use them.
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Zipcodes addresses and all that jazz

2006-08-16 Thread Ken Ferguson
Check out my blog entry here:

http://www.fergusonhouse.com/blog/index.cfm/2006/7/27/coldfusion-geocode

This actually uses geocoder.us to get the lat/lon for a given address.
What you could easily do is to mark an address as "suspect" if no
lat/lon is returned. However, whether you use geocoder or fake the funk
against the google maps api, you'll never be able to absolutely say that
an address is incorrect, as such. You'll only be able to say that it's
not in the database in question. My address couldn't be found on Google
Maps for the first 2 years that I lived there.

Thanks,
 
Ken Ferguson
214.636.6126



-Original Message-
From: Richard Dillman [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 16, 2006 12:54 PM
To: CF-Talk
Subject: Zipcodes addresses and all that jazz

OK, to start off with I already a table with:

-Zipcode, City, State, County, Country



I currently do a check onblur from the zip field to see if I have a
valid
zip and display back in a div the city state and county info.



I'd like to pass the address info to something like google Maps or Yahoo
Maps and verify the address is entered correclty



This is for a non proffit to check-in foster parents to training
programs
and such.  Their volume is about 20 to 30 a day (new members).



How can I go about this cheeply of even *free*?


-- 
-- 
Richard Dillman
[EMAIL PROTECTED]
(317) 916-8341

"I think it's T double-E double-R double-R double-I double-F double-I
double-C, C, C." - the Goose in 'Charlotte's Web'




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Zipcodes addresses and all that jazz

2006-08-16 Thread Turetsky, Seth
I think it's free now 

-Original Message-
From: Paul Hastings [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 16, 2006 2:31 PM
To: CF-Talk
Subject: Re: Zipcodes addresses and all that jazz

Turetsky, Seth wrote:
> I've been playing with Microsoft's Mappoint stuff lately, they offer a 
> lot of stuff that Google does not.  See 
> http://dev.live.com/virtualearth/sdk/ shows some examples and the 
> source of each.

so does esri's webservices but you don't have to sell any of your children to 
use them.



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Licensing question for CF on a VM Machine

2006-08-16 Thread Peterson, Chris
Question, is the Per CPU license for CF Enterprise based on the physical
CPU, or the CPU's interpreted by the OS?  If physical CPU, can I run 4
virtual servers on a single CPU box and install CF on each one?  If its
per CPU seen by the OS, does hyper-threading have to be turned off for
me to be legal on a single CPU HT server?

Chris

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Re: Zipcodes addresses and all that jazz

2006-08-16 Thread Paul Hastings
Turetsky, Seth wrote:
> I've been playing with Microsoft's Mappoint stuff lately, they offer
> a lot of stuff that Google does not.  See
> http://dev.live.com/virtualearth/sdk/ shows some examples and the
> source of each.

so does esri's webservices but you don't have to sell any of your 
children to use them.

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


  1   2   >