Re: UPS web services and CFMX

2002-10-19 Thread Jon Hall
Ok now this is twice someone has said UPS has a web service api.
I just double checked and on this page
http://www.ec.ups.com/ecommerce/techdocs/online_tools.html
they list all of their XML API's. I looked around, and downloaded the
tracking and rate selection docs again, even though they haven't been
updated since I memorized them earlier this year. There is no mention
of SOAP anywhere that I can see.
Is there something I am overlooking? Please provide a link.

-- 
jon
mailto:jonhall@;ozline.net

Friday, October 18, 2002, 11:32:13 PM, you wrote:

SY> I checked it out as well...believe it's SOAP-RPC...may work with CFHTTP and
SY> XML/CFHTTPPARAM ?

SY> You can download their API/XML doc off their site...

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



OT: MM - the story

2002-10-19 Thread cf-talk
Hi list, anybody who
knows how they did:
http://www.macromedia.com/macromedia/story/minorverdetect.swf?min_dot_version=29
Thanks for info.
Uwe



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



e-mailing-management tool

2002-10-19 Thread cf-talk
Hi list, there is an email list-manager to manage E-Mailings in HTML/ASCII from the 
following company: http://www.2simplifi.com/.
Someone there who knows this software and can tell me if it has any 
problems/disadvantages ?
Any other software for e-mailing-management with CF available ?
Uwe

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



RE: counting # of characters in file

2002-10-19 Thread Tony Weeg
that what i ended up doing last nightin the code
just above it, the contents happened to be in a variable
so i just did a len() of that ;) and it worked!!!

thanks anyway isaac.
t
w

-Original Message-
From: S. Isaac Dealey [mailto:info@;turnkey.to] 
Sent: Friday, October 18, 2002 11:49 PM
To: CF-Talk
Subject: Re: counting # of characters in file


> is there a function, that i missing from the help file
> for some reason, cant find anything, to count the amount
> of characters in a file?

> not the file length, but the actual amount of characters
> in a file?

There's no native function, you'd have to read in the file and check the
length...
In CFMX you could write this into a UDF.









hth

Isaac
Certified Advanced ColdFusion 5 Developer

www.turnkey.to
954-776-0046


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



RE: session vars and locking

2002-10-19 Thread Tony Weeg
thats what i thought, and for now, i just 
locked all accesses of session vars, be it
writing or reading, etc...

thanks...
tony


-Original Message-
From: Sean A Corfield [mailto:sean@;corfield.org] 
Sent: Saturday, October 19, 2002 2:10 AM
To: CF-Talk
Subject: Re: session vars and locking


On Friday, Oct 18, 2002, at 19:06 US/Pacific, Tony Weeg wrote:
> race condition?

When two requests might get processed at the same time and both might 
try to read and/or update a shared scope variable... a case of 
whichever request wins the the race... :)

A rule of thumb here is: if you don't really understand the subtleties 
of race conditions (or deadlock situations), then you're safer to lock 
every access/update (even if, in reality, you may not need to). In 
other words, if in doubt, be overly cautious.

"Conform! Consume! Obey!"
-- Mr Snaffleburger : http://www.matazone.co.uk/theotherside.html


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



RE: session vars and locking

2002-10-19 Thread S . Isaac Dealey
Isn't this only true if Session.SomeStruct.var1 is also a complex object
like another structure or query?

Not that I'm knocking the suggestion -- as a matter of fact I think it's
just good practice to always use duplicate when copying data to or from
persistent scopes.

> Joe,

> When you do it this way you are referencing the session
> variable as a local.
> To get a true copy use the duplicate function:


> 
> 
> tmpVar1= duplicate(Session.SomeStruct.var1);
> tmpVar2=duplicate(Session.SomeStruct.var2);
> 
> 

> -mk



> -Original Message-
> From: Joe Eugene [mailto:Jebebox@;earthlink.net]
> Sent: Friday, October 18, 2002 11:14 PM
> To: CF-Talk
> Subject: RE: session vars and locking


> You are correct... but i think its better to copy the
> variables to
> local scope in one sequence... instead of a lot cflocks..

> 
> 
> tmpVar1=Session.SomeStruct.var1;
> tmpVar2=Session.SomeStruct.var2;
> 
> 

> 
> 
> Session.SomeStruct.var1=Var1;
> Session.SomeStruct.var2=Var2;
> 
> 

> You can refer to the local scope variables in your page.


> Joe


>> -Original Message-
>> From: Tony Weeg [mailto:tony@;navtrak.net]
>> Sent: Friday, October 18, 2002 9:00 PM
>> To: CF-Talk
>> Subject: session vars and locking
>>
>>
>> hi there
>>
>> is it safe to assume that everywhere on a page, where i
>> am either
>> setting or reading from session variables, that i should
>> have cflock's
>> of the exclusive type (when writing to session vars) and
>> cflocks of
>> the readonly type (when reading from session vars) on
>> every single
>> occurence
>> of one of these situations?
>>
>> without fail, i mean do every single one of them in one
>> way or the
>> other?
>>
>> thanks.
>>
>> ...tony
>>
>> tony weeg
>> [EMAIL PROTECTED]
>> www.revolutionwebdesign.com
>> rEvOlUtIoN wEb DeSiGn
>> 410.334.6331
>>
>>

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


Isaac
Certified Advanced ColdFusion 5 Developer

www.turnkey.to
954-776-0046

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



RE: session vars and locking

2002-10-19 Thread Mark A. Kruger - CFG
Issaac,

I don't believe so.  I believe when you say "x = y" you are making an
assignment by reference.  To put it another way, you have 2 separate
variable names that point to the same spot in memory.

-mk

-Original Message-
From: S. Isaac Dealey [mailto:info@;turnkey.to]
Sent: Saturday, October 19, 2002 9:00 AM
To: CF-Talk
Subject: RE: session vars and locking


Isn't this only true if Session.SomeStruct.var1 is also a complex object
like another structure or query?

Not that I'm knocking the suggestion -- as a matter of fact I think it's
just good practice to always use duplicate when copying data to or from
persistent scopes.

> Joe,

> When you do it this way you are referencing the session
> variable as a local.
> To get a true copy use the duplicate function:


> 
> 
> tmpVar1= duplicate(Session.SomeStruct.var1);
> tmpVar2=duplicate(Session.SomeStruct.var2);
> 
> 

> -mk



> -Original Message-
> From: Joe Eugene [mailto:Jebebox@;earthlink.net]
> Sent: Friday, October 18, 2002 11:14 PM
> To: CF-Talk
> Subject: RE: session vars and locking


> You are correct... but i think its better to copy the
> variables to
> local scope in one sequence... instead of a lot cflocks..

> 
> 
> tmpVar1=Session.SomeStruct.var1;
> tmpVar2=Session.SomeStruct.var2;
> 
> 

> 
> 
> Session.SomeStruct.var1=Var1;
> Session.SomeStruct.var2=Var2;
> 
> 

> You can refer to the local scope variables in your page.


> Joe


>> -Original Message-
>> From: Tony Weeg [mailto:tony@;navtrak.net]
>> Sent: Friday, October 18, 2002 9:00 PM
>> To: CF-Talk
>> Subject: session vars and locking
>>
>>
>> hi there
>>
>> is it safe to assume that everywhere on a page, where i
>> am either
>> setting or reading from session variables, that i should
>> have cflock's
>> of the exclusive type (when writing to session vars) and
>> cflocks of
>> the readonly type (when reading from session vars) on
>> every single
>> occurence
>> of one of these situations?
>>
>> without fail, i mean do every single one of them in one
>> way or the
>> other?
>>
>> thanks.
>>
>> ...tony
>>
>> tony weeg
>> [EMAIL PROTECTED]
>> www.revolutionwebdesign.com
>> rEvOlUtIoN wEb DeSiGn
>> 410.334.6331
>>
>>

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


Isaac
Certified Advanced ColdFusion 5 Developer

www.turnkey.to
954-776-0046


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



RE: cfstoredproc behavior

2002-10-19 Thread S . Isaac Dealey
> I'm pretty sure it's the order that is hanging it up.  I
> have used
> cfstoredproc in other places on our servers and it works
> just fine.

> It's pretty dissapointing that this seems to be a
> "feature" or "bug" or
> whatever you want to call it that MM is ignoring.  What
> happens when you
> want to skip parameters in a dynamic statement like I was
> doing, I guess you
> have to revert to cfquery?

Or you have to include all the parameters you wanted to skip ... Which means
you can't allow the stored procedure to use its defaults. In my case most of
my stored procedures use NULL for any defaults, so passing null="yes" in the
 is equivalent, however, if I used "bilbo" as a default for
instance, I'd have to pass "bilbo" as the value, which thoroughly defeats
the purpose of having a default in my stored procedure and makes my job that
much harder if that "default" value ever changes.

> Also, what is the deal with cfquery in CFMX?  I've just
> finally got CFMX
> installed tonight for the first time.  Our website which
> is probably 95%
> cfquery vs. cfstoredproc seems to be working just fine.
> For a datasource I
> just chose SQL Server from the list of datasource types
> when I created it, I
> think this means I'm using the JDBC driver?  Either way,
> all of our stored
> procedure calls that are made in cfquery tags seem to be
> working fine.

Hmmm... do many of your stored procedures return a recordset? That's the
only issue really, so if you only use the stored procs to perform inserts
and updates and aren't concerned with getting a recordset back, there
wouldn't be any reason to notice the difference. Otherwise, you may be using
the ODBC socket -- I wouldn't know, I've been too busy with recent updates
and preparing for MX to actually install MX and work with it much. I suppose
it's possible MM could have found a way to change the behavior with the JDBC
drivers in the recent MX update though again I wouldn't know.

> Personally, I have always preferred the cfquery tag over
> the cfstoredproc
> for the simple reason that you get real error messages
> back and not just
> "Unknown Data Access Error".

Not to mention all that extra typing. :)

Though iirc, it does have some other advantages in that I believe it's
supposed to help speed up processing of stored procedures ( I wonder if this
is done by not naming parameters ;P ) and it insulates the procedure from
unlikely sql insertion attacks and issues with data insertion, like the \ on
MySQL ( although current versions of MySQL don't support stored procedures )
being a special character that  doesn't know to account for. Of
course, much of this can also be accomplished with  in a
stored procedure called with  so my biggest gripes are the lack of
ability to use db defined defaults and the fact that it's completely
undocumented anywhere on MM's site ( actually the documentation says that
the dbvarname attribute is supposed to be the name of the parameter in the
stored procedure, which you might be able to weasel out of saying is an out
and out lie, but it's certainly seems to indicate that the order of
parameters shouldn't matter ) and since I may not necessarily be the only
developer who ever touches my code there's a good chance at some point that
I'm going to have to field technical support calls or emails in which I'll
have to explain this whole debacle over again.


Isaac
Certified Advanced ColdFusion 5 Developer

www.turnkey.to
954-776-0046

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



RE: session vars and locking

2002-10-19 Thread S . Isaac Dealey
StructCopy() doesn't work for complex variables which contain other complex
variables, which is why afaik it was deprecated and should not be used.

> Yea.. the duplicate/structCopy route works good as well...
> i was just throwing out the logic.

> Joe


>> -Original Message-
>> From: Mark A. Kruger - CFG
>> [mailto:mkruger@;cfwebtools.com]
>> Sent: Saturday, October 19, 2002 12:25 AM
>> To: CF-Talk
>> Subject: RE: session vars and locking
>>
>>
>> Joe,
>>
>> When you do it this way you are referencing the session
>> variable
>> as a local.
>> To get a true copy use the duplicate function:
>>
>>
>> 
>> 
>> tmpVar1= duplicate(Session.SomeStruct.var1);
>> tmpVar2=duplicate(Session.SomeStruct.var2);
>> 
>> 
>>
>> -mk
>>
>>
>>
>> -Original Message-
>> From: Joe Eugene [mailto:Jebebox@;earthlink.net]
>> Sent: Friday, October 18, 2002 11:14 PM
>> To: CF-Talk
>> Subject: RE: session vars and locking
>>
>>
>> You are correct... but i think its better to copy the
>> variables to
>> local scope in one sequence... instead of a lot cflocks..
>>
>> 
>> 
>> tmpVar1=Session.SomeStruct.var1;
>> tmpVar2=Session.SomeStruct.var2;
>> 
>> 
>>
>> 
>> 
>> Session.SomeStruct.var1=Var1;
>> Session.SomeStruct.var2=Var2;
>> 
>> 
>>
>> You can refer to the local scope variables in your page.
>>
>>
>> Joe
>>
>>
>> > -Original Message-
>> > From: Tony Weeg [mailto:tony@;navtrak.net]
>> > Sent: Friday, October 18, 2002 9:00 PM
>> > To: CF-Talk
>> > Subject: session vars and locking
>> >
>> >
>> > hi there
>> >
>> > is it safe to assume that everywhere on a page, where i
>> > am either
>> > setting or reading from session variables, that i
>> > should have cflock's
>> > of the exclusive type (when writing to session vars)
>> > and cflocks of
>> > the readonly type (when reading from session vars) on
>> > every single
>> > occurence
>> > of one of these situations?
>> >
>> > without fail, i mean do every single one of them in one
>> > way or the
>> > other?
>> >
>> > thanks.
>> >
>> > ...tony
>> >
>> > tony weeg
>> > [EMAIL PROTECTED]
>> > www.revolutionwebdesign.com
>> > rEvOlUtIoN wEb DeSiGn
>> > 410.334.6331
>> >
>> >
>>
>>
> ~~
> ~~~|
> Archives:
> http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
> Subscription: http://www.houseoffusion.com/index.cfm?sideb
> ar=lists&body=lists/cf_talk
> FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
> This list and all House of Fusion resources hosted by
> CFHosting.com. The place for dependable ColdFusion
> Hosting.


Isaac
Certified Advanced ColdFusion 5 Developer

www.turnkey.to
954-776-0046

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



RE: counting # of characters in file

2002-10-19 Thread S . Isaac Dealey
Welcome ... I wonder if there may be a better way to do it than with
 possibly using a java class... It just seems like the function I
wrote below would be awfully heavy if you wanted to output the lengths of
files in say a  query with more than a small handful of files.

> that what i ended up doing last nightin the code
> just above it, the contents happened to be in a variable
> so i just did a len() of that ;) and it worked!!!

> thanks anyway isaac.
> t
> w

> -Original Message-
> From: S. Isaac Dealey [mailto:info@;turnkey.to]
> Sent: Friday, October 18, 2002 11:49 PM
> To: CF-Talk
> Subject: Re: counting # of characters in file


>> is there a function, that i missing from the help file
>> for some reason, cant find anything, to count the amount
>> of characters in a file?

>> not the file length, but the actual amount of characters
>> in a file?

> There's no native function, you'd have to read in the file
> and check the
> length...
> In CFMX you could write this into a UDF.

> 
>   

>  variable="myfile">
>   
> 


> hth

> Isaac
> Certified Advanced ColdFusion 5 Developer

> www.turnkey.to
> 954-776-0046


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


Isaac
Certified Advanced ColdFusion 5 Developer

www.turnkey.to
954-776-0046

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



RE: session vars and locking

2002-10-19 Thread S . Isaac Dealey
Could someone run this on a CF 5 server with full-checking selected in the
memory variables area in the cfadmin and confirm that my CF server isn't
working properly?

This test was written with the intention of confirming that simple values
either do or do not get passed by reference in a  tag, however, my cf
server seems to not be working, so I can't perform the test, because it's
not producing the expected error from variable accesses which are definitely
improperly locked.





application.a = "hello world";
application.b = structnew();
application.b.c = "hello world";
application.b.d = structnew();
application.b.d.e = "hello world";










application.a = #request.a#
application.b.c = #request.b.c#
application.b.d.e = #request.b.d.e#


After running this, outputting #request.b.d.e# at the bottom should produce
an error since request.b is supposed to be a pointer reference to
application.b and therefore request.b.d.e should be in the application scope
and not properly locked. For that matter, request.b.c should be in the
application scope as well, so both of these should produce an error, but
neither are on my machine, even though full-checking is turned on in the CF
admin.

In any event, if it errors on request.b.c or request.b.d.e but not on
request.a then this confirms that simple values are not passed as pointer
references but as literal strings. That being said, I still think duplicate
should always be applied when using persistent scopes in development /
production.

Isaac
Certified Advanced ColdFusion 5 Developer

www.turnkey.to
954-776-0046

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



RE: counting # of characters in file

2002-10-19 Thread Tony Weeg
yeah, well the way i look at it, 90% of the time
im going to have to populate a file with data. how that
data might come to me, in most cases i think, as part of-or
fully contained in a variable, so a len() function should
work most of the time...wouldnt you say.  but yeah, some
cool, ReadCharInFile() function would rock.

tw

-Original Message-
From: S. Isaac Dealey [mailto:info@;turnkey.to] 
Sent: Saturday, October 19, 2002 10:23 AM
To: CF-Talk
Subject: RE: counting # of characters in file


Welcome ... I wonder if there may be a better way to do it than with
 possibly using a java class... It just seems like the function
I
wrote below would be awfully heavy if you wanted to output the lengths
of
files in say a  query with more than a small handful of
files.

> that what i ended up doing last nightin the code
> just above it, the contents happened to be in a variable
> so i just did a len() of that ;) and it worked!!!

> thanks anyway isaac.
> t
> w

> -Original Message-
> From: S. Isaac Dealey [mailto:info@;turnkey.to]
> Sent: Friday, October 18, 2002 11:49 PM
> To: CF-Talk
> Subject: Re: counting # of characters in file


>> is there a function, that i missing from the help file
>> for some reason, cant find anything, to count the amount
>> of characters in a file?

>> not the file length, but the actual amount of characters
>> in a file?

> There's no native function, you'd have to read in the file
> and check the
> length...
> In CFMX you could write this into a UDF.

> 
>   

>  variable="myfile">
>   
> 


> hth

> Isaac
> Certified Advanced ColdFusion 5 Developer

> www.turnkey.to
> 954-776-0046


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


Isaac
Certified Advanced ColdFusion 5 Developer

www.turnkey.to
954-776-0046


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



RE: UPS web services and CFMX

2002-10-19 Thread Stacy Young
It may just be a XML/HTTP API...I'm not 100%, it's been a long time since I
checked them out.

Stace

-Original Message-
From: Jon Hall [mailto:jonhall@;ozline.net] 
Sent: Saturday, October 19, 2002 4:15 AM
To: CF-Talk
Subject: Re: UPS web services and CFMX

Ok now this is twice someone has said UPS has a web service api.
I just double checked and on this page
http://www.ec.ups.com/ecommerce/techdocs/online_tools.html
they list all of their XML API's. I looked around, and downloaded the
tracking and rate selection docs again, even though they haven't been
updated since I memorized them earlier this year. There is no mention
of SOAP anywhere that I can see.
Is there something I am overlooking? Please provide a link.

-- 
jon
mailto:jonhall@;ozline.net

Friday, October 18, 2002, 11:32:13 PM, you wrote:

SY> I checked it out as well...believe it's SOAP-RPC...may work with CFHTTP
and
SY> XML/CFHTTPPARAM ?

SY> You can download their API/XML doc off their site...


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



RE: session vars and locking

2002-10-19 Thread Tony Weeg
i would, but i dont see the "Full-Checking" checkbox anywhere?

tw

-Original Message-
From: S. Isaac Dealey [mailto:info@;turnkey.to] 
Sent: Saturday, October 19, 2002 11:03 AM
To: CF-Talk
Subject: RE: session vars and locking


Could someone run this on a CF 5 server with full-checking selected in
the
memory variables area in the cfadmin and confirm that my CF server isn't
working properly?

This test was written with the intention of confirming that simple
values
either do or do not get passed by reference in a  tag, however,
my cf
server seems to not be working, so I can't perform the test, because
it's
not producing the expected error from variable accesses which are
definitely
improperly locked.





application.a = "hello world";
application.b = structnew();
application.b.c = "hello world";
application.b.d = structnew();
application.b.d.e = "hello world";










application.a = #request.a#
application.b.c = #request.b.c#
application.b.d.e = #request.b.d.e#


After running this, outputting #request.b.d.e# at the bottom should
produce
an error since request.b is supposed to be a pointer reference to
application.b and therefore request.b.d.e should be in the application
scope
and not properly locked. For that matter, request.b.c should be in the
application scope as well, so both of these should produce an error, but
neither are on my machine, even though full-checking is turned on in the
CF
admin.

In any event, if it errors on request.b.c or request.b.d.e but not on
request.a then this confirms that simple values are not passed as
pointer
references but as literal strings. That being said, I still think
duplicate
should always be applied when using persistent scopes in development /
production.

Isaac
Certified Advanced ColdFusion 5 Developer

www.turnkey.to
954-776-0046


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



RE: session vars and locking

2002-10-19 Thread Tony Weeg
this is what i getcf5

A hello world  
APPLICATIONNAME POINTERTEST  
B C hello world  
D E hello world  
 
application.a = hello world
application.b.c = hello world
application.b.d.e = hello world

in a structure view though ;)

tw

-Original Message-
From: S. Isaac Dealey [mailto:info@;turnkey.to] 
Sent: Saturday, October 19, 2002 11:03 AM
To: CF-Talk
Subject: RE: session vars and locking


Could someone run this on a CF 5 server with full-checking selected in
the
memory variables area in the cfadmin and confirm that my CF server isn't
working properly?

This test was written with the intention of confirming that simple
values
either do or do not get passed by reference in a  tag, however,
my cf
server seems to not be working, so I can't perform the test, because
it's
not producing the expected error from variable accesses which are
definitely
improperly locked.





application.a = "hello world";
application.b = structnew();
application.b.c = "hello world";
application.b.d = structnew();
application.b.d.e = "hello world";










application.a = #request.a#
application.b.c = #request.b.c#
application.b.d.e = #request.b.d.e#


After running this, outputting #request.b.d.e# at the bottom should
produce
an error since request.b is supposed to be a pointer reference to
application.b and therefore request.b.d.e should be in the application
scope
and not properly locked. For that matter, request.b.c should be in the
application scope as well, so both of these should produce an error, but
neither are on my machine, even though full-checking is turned on in the
CF
admin.

In any event, if it errors on request.b.c or request.b.d.e but not on
request.a then this confirms that simple values are not passed as
pointer
references but as literal strings. That being said, I still think
duplicate
should always be applied when using persistent scopes in development /
production.

Isaac
Certified Advanced ColdFusion 5 Developer

www.turnkey.to
954-776-0046


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



Re: counting # of characters in file

2002-10-19 Thread Jesse Houwing
Tony Weeg wrote:
> yeah, well the way i look at it, 90% of the time
> im going to have to populate a file with data. how that
> data might come to me, in most cases i think, as part of-or
> fully contained in a variable, so a len() function should
> work most of the time...wouldnt you say.  but yeah, some
> cool, ReadCharInFile() function would rock.

should be something like:


function GetFileLength(filename){
file = createObject('java', 'java.io.File');
file.init(filename);
return file.length();
}


Very simular functions can be made for CanRead, CanWrite, delete, 
exists,isDirectory, isFile, lastModified, renameTo, setLastModified, 
setReadOnly.

Maybe I'm up to it tonight. If I am, I'll sumbit them to the cflib.

Jesse



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



RE: UPS web services and CFMX

2002-10-19 Thread Eric Hoffman
For just standard tools, I am not sure.  Restrictions are very tight on
the premium tools.

Here is thir FAQ:
http://www.ec.ups.com/ecommerce/techdocs/e5c2_techfaq.html

I was told when you first sign up, there is something in that agreement
with the license key.  I don't have it anymore (bad bad), so I will dig
it up if I can this weekend.  

Regards,

Eric J Hoffman
Head Tech Geek
DataStream Connexion
www.datastreamconnexion.com
Delivering Creative Data Solutions 

-Original Message-
From: Stacy Young [mailto:Stacy.Young@;sfcommerce.com] 
Sent: Friday, October 18, 2002 10:35 PM
To: CF-Talk
Subject: RE: UPS web services and CFMX


I thought they operated by license key submitted with each request? When
I signed up (a while back) they sent me some kind of key...but didn't
receive any other notification of restrictions on usage etc... ?

Stace

-Original Message-
From: Eric Hoffman [mailto:webmaster@;digitalmpls.com] 
Sent: Friday, October 18, 2002 8:49 PM
To: CF-Talk
Subject: RE: UPS web services and CFMX

A primary issue as well is their concerns that unregulated code will
cause significant problems to their servers.  My client was required to
be shipping a minimum of 50 packages a day to get access to the full
online shipping system, we had to certify a ton of code and database
stuff, as well as an onsite visit to the company.  They are very serious
about allowing access to their servers, which I do understand to some
degree.  I want those systems up and not bogged down by bad stuff, my
client would be very unhappy.  I think though, if you were to include in
applications and it was encrypted, you might have better luck.  Now if
this is just for tracking, come on UPS.  

If its out there and can be modified without strict regulation and a big
free for all exists outside of their licensing, they feel they risk
their services to all their customers.   That's how they explained it to
me.   They are a tremendous PIA to deal with.  

Regards,

Eric J Hoffman
Head Tech Geek
DataStream Connexion
www.datastreamconnexion.com
Delivering Creative Data Solutions 

-Original Message-
From: [EMAIL PROTECTED] [mailto:cliff@;cliffmeyers.com] 
Sent: Friday, October 18, 2002 7:21 PM
To: CF-Talk
Subject: RE: UPS web services and CFMX


Bud,


That's off the wall.  I find it ironic that UPS is fighting distribution
of code that ultimately would result in more customers / business for
their company.


-Cliff



On Fri, 18 Oct 2002 17:20:15 -0700 (PDT), Bud wrote:

> 
> On 10/18/02, Ben Forta penned:
> >I may be wrong, but I do not believe they have a Web Service. They
> >have a series of XML interfaces that are not trivial to use (not 
> >terribly complex either though).
> >
> >I started building a CFC to encapsulate their XML API's, but have a
> >way to go yet. I'll try get something working over the weekend so you

> >can see what is involved.
> 
> I'm almost done with a tag that will use cfhttp or msxml to talk with 
> their XML interface, BUT... They have said they'll sue me if I 
> distribute it. I can install the code under a person's end user 
> license, but absolutely cannot distribute it or include it in my 
> shopping cart. I can have the merchant "hire" me under their end user 
> developer license. I've been fighting tooth and nail with them for 
> over a week.
> 
> The really really nasty part of this is, they will not let me get 
> licensed as a third party developer to distribute my cart. They keep 
> telling me it's because they absolutely DO NOT license any software 
> that is distributed as Open Source. Although Able Solutions is 
> licensed and the XML interface is included in their Open Source 
> version. I know that the real reason is that they are discriminating 
> against me because I'm a small business.
> 
> When I mentioned that there are a number of modules available to talk 
> to their XML and datastream interfaces, they said that their legal 
> team is in the process of investigating this. Technically even the 
> cf_upsprice tag is illegal to distribute since the datastream version 
> is also covered under their current licensing.
> --
> 
> Bud Schneehagen - Tropical Web Creations
> 
> _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
> ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://mail.cliffmeyers.com/jump/http://www.twcreations.com";>http:
//www.twcreations.com/
> 954.721.3452
> 



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



RE: cfstoredproc behavior

2002-10-19 Thread Andy Clary
Yes, many of my stored procedures return recordsets and are working just
fine.  I think not being able to return recordsets would be a HUGE
limitation.  I can't imagine that this would be the case.  Again, when I
created my datasouce I chose the SQL Server datasource type from the drop
down menu.  There is no mention of whether or not it is a JDBC, but I tend
to believe it is because ODBC Socket was another option also on the drop
down list.  Can anyone else confirm or deny this behavior?

Andy

-Original Message-
From: S. Isaac Dealey [mailto:info@;turnkey.to]
Sent: Saturday, October 19, 2002 7:20 AM
To: CF-Talk
Subject: RE: cfstoredproc behavior


> I'm pretty sure it's the order that is hanging it up.  I
> have used
> cfstoredproc in other places on our servers and it works
> just fine.

> It's pretty dissapointing that this seems to be a
> "feature" or "bug" or
> whatever you want to call it that MM is ignoring.  What
> happens when you
> want to skip parameters in a dynamic statement like I was
> doing, I guess you
> have to revert to cfquery?

Or you have to include all the parameters you wanted to skip ... Which means
you can't allow the stored procedure to use its defaults. In my case most of
my stored procedures use NULL for any defaults, so passing null="yes" in the
 is equivalent, however, if I used "bilbo" as a default for
instance, I'd have to pass "bilbo" as the value, which thoroughly defeats
the purpose of having a default in my stored procedure and makes my job that
much harder if that "default" value ever changes.

> Also, what is the deal with cfquery in CFMX?  I've just
> finally got CFMX
> installed tonight for the first time.  Our website which
> is probably 95%
> cfquery vs. cfstoredproc seems to be working just fine.
> For a datasource I
> just chose SQL Server from the list of datasource types
> when I created it, I
> think this means I'm using the JDBC driver?  Either way,
> all of our stored
> procedure calls that are made in cfquery tags seem to be
> working fine.

Hmmm... do many of your stored procedures return a recordset? That's the
only issue really, so if you only use the stored procs to perform inserts
and updates and aren't concerned with getting a recordset back, there
wouldn't be any reason to notice the difference. Otherwise, you may be using
the ODBC socket -- I wouldn't know, I've been too busy with recent updates
and preparing for MX to actually install MX and work with it much. I suppose
it's possible MM could have found a way to change the behavior with the JDBC
drivers in the recent MX update though again I wouldn't know.

> Personally, I have always preferred the cfquery tag over
> the cfstoredproc
> for the simple reason that you get real error messages
> back and not just
> "Unknown Data Access Error".

Not to mention all that extra typing. :)

Though iirc, it does have some other advantages in that I believe it's
supposed to help speed up processing of stored procedures ( I wonder if this
is done by not naming parameters ;P ) and it insulates the procedure from
unlikely sql insertion attacks and issues with data insertion, like the \ on
MySQL ( although current versions of MySQL don't support stored procedures )
being a special character that  doesn't know to account for. Of
course, much of this can also be accomplished with  in a
stored procedure called with  so my biggest gripes are the lack of
ability to use db defined defaults and the fact that it's completely
undocumented anywhere on MM's site ( actually the documentation says that
the dbvarname attribute is supposed to be the name of the parameter in the
stored procedure, which you might be able to weasel out of saying is an out
and out lie, but it's certainly seems to indicate that the order of
parameters shouldn't matter ) and since I may not necessarily be the only
developer who ever touches my code there's a good chance at some point that
I'm going to have to field technical support calls or emails in which I'll
have to explain this whole debacle over again.


Isaac
Certified Advanced ColdFusion 5 Developer

www.turnkey.to
954-776-0046


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



Re: OT: MM - the story

2002-10-19 Thread Sean A Corfield
On Saturday, Oct 19, 2002, at 05:16 US/Pacific, cf-talk wrote:
> Hi list, anybody who knows how they did:
> http://www.macromedia.com/macromedia/story/

Well, it's 'just' a Flash movie. What would you like to know about it?

We may have used FlashCom for the video, I'm not sure. I can certainly 
find out.

"I can smell your brains!"
-- Mittens the Kitten : http://www.matazone.co.uk/theotherside.html

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



RE: OT: MM - the story

2002-10-19 Thread Tony Weeg
please dothat video F***ING ROCKS!
well done  presentation MM.

tony

-Original Message-
From: Sean A Corfield [mailto:sean@;corfield.org] 
Sent: Saturday, October 19, 2002 12:59 PM
To: CF-Talk
Subject: Re: OT: MM - the story


On Saturday, Oct 19, 2002, at 05:16 US/Pacific, cf-talk wrote:
> Hi list, anybody who knows how they did:
> http://www.macromedia.com/macromedia/story/

Well, it's 'just' a Flash movie. What would you like to know about it?

We may have used FlashCom for the video, I'm not sure. I can certainly 
find out.

"I can smell your brains!"
-- Mittens the Kitten : http://www.matazone.co.uk/theotherside.html


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



Re: How about Macromedia provide a more detailed configuration document for CFMX?

2002-10-19 Thread Doug
I am reading so much pain and suffering caused by configuration issues with the 
migration to
ColdFusionMX.

There have been so many issues, my clients, for instance are delaying the upgrade 
until the dust
settles.   I am seeing so many people reporting problems with the set up and 
configuration, and
reporting bugs, that turn out to be configuration that I would like to see Macromedia 
go to the
effort to product a comprehensive set of documentation that will address these 
configuration issues.
Just as Microsoft had to learn, the "one size fits all" is creating more problems than 
it solves.
It should not be required for a system administrator to have to go to a $3000.00 
course, purchase
$200 to $300.00 in books just to install and configure the product.  This is what it 
seems to appear
to be the case at present.  It should not require weeks and weeks of tweaking (read 
that thousands
of dollars of labor costs.) to install and set up the server product.

It seems to be a given that Macromedia does not pay much attention to its install 
application, which
has been a bone of contention of mine from way back.  Even the updater follows the old 
trend.

I suggest the gurus at Macromedia obtain a copy of the new Microsoft .NET Enterprise 
server (release
candidate) and walk through the install and configuration wizards and see what 
advances have been
made toward set up and security, and try to incorporate the idea into their own 
install application.

I have no question about the product being stable and awesome when properly 
configured, but why does
it require so much training and expertise just to set up a server?

When a hotfix is released, there should not be the requirement that the install 
procedure for the
patches be different than the original install, but with just the required 
configuration for the fix
itself.  Instead when Macromedia releases a fix, each one has a unique installation 
procedure, such
as "copy this file to this directory", and "copy that one to that directory" and then 
reboot or
restart the service.  The install application should do all that for consistency sake. 
 Setting up
remoting is treated so casually that way too much time is required to set that feature 
up and be
consistent with server security.  Best practices call for your database to be served 
on a different
serer than the one that provides web services, remember?



This address is filtered through the open relay database at http://www.ordb.org
and is virus scanned by ANTIVIR
http://www.dwhite.ws
mailto:doug@;dwhite.ws

|

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



RE: OT: MM - the story

2002-10-19 Thread Lee Fuller
Yeah.. I'd like to know about the opening text effects.. Where'd they
come from?


| -Original Message-
| From: Sean A Corfield [mailto:sean@;corfield.org] 
| Sent: Saturday, October 19, 2002 9:59 AM
| To: CF-Talk
| Subject: Re: OT: MM - the story
| 
| 
| On Saturday, Oct 19, 2002, at 05:16 US/Pacific, cf-talk wrote:
| > Hi list, anybody who knows how they did: 
| > http://www.macromedia.com/macromedia/story/
| 
| Well, it's 'just' a Flash movie. What would you like to know about it?
| 
| We may have used FlashCom for the video, I'm not sure. I can 
| certainly 
| find out.
| 
| "I can smell your brains!"
| -- Mittens the Kitten : http://www.matazone.co.uk/theotherside.html
| 
| 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm



RE: How about Macromedia provide a more detailed configuration document for CFMX?

2002-10-19 Thread Kola Oyedeji
Doug

I will be installing CFMX for the first time, what configuration problems
are you having? What issues should i be aware of?

Thanks

Kola

> >-Original Message-
> >From: Doug [mailto:doug@;dwhite.ws]
> >Sent: 19 October 2002 18:13
> >To: CF-Talk
> >Subject: Re: How about Macromedia provide a more detailed configuration
> >document for CFMX?
> >
> >
> >I am reading so much pain and suffering caused by configuration
> >issues with the migration to
> >ColdFusionMX.
> >
> >There have been so many issues, my clients, for instance are
> >delaying the upgrade until the dust
> >settles.   I am seeing so many people reporting problems with
> >the set up and configuration, and
> >reporting bugs, that turn out to be configuration that I would
> >like to see Macromedia go to the
> >effort to product a comprehensive set of documentation that will
> >address these configuration issues.
> >Just as Microsoft had to learn, the "one size fits all" is
> >creating more problems than it solves.
> >It should not be required for a system administrator to have to
> >go to a $3000.00 course, purchase
> >$200 to $300.00 in books just to install and configure the
> >product.  This is what it seems to appear
> >to be the case at present.  It should not require weeks and
> >weeks of tweaking (read that thousands
> >of dollars of labor costs.) to install and set up the server product.
> >
> >It seems to be a given that Macromedia does not pay much
> >attention to its install application, which
> >has been a bone of contention of mine from way back.  Even the
> >updater follows the old trend.
> >
> >I suggest the gurus at Macromedia obtain a copy of the new
> >Microsoft .NET Enterprise server (release
> >candidate) and walk through the install and configuration
> >wizards and see what advances have been
> >made toward set up and security, and try to incorporate the idea
> >into their own install application.
> >
> >I have no question about the product being stable and awesome
> >when properly configured, but why does
> >it require so much training and expertise just to set up a server?
> >
> >When a hotfix is released, there should not be the requirement
> >that the install procedure for the
> >patches be different than the original install, but with just
> >the required configuration for the fix
> >itself.  Instead when Macromedia releases a fix, each one has a
> >unique installation procedure, such
> >as "copy this file to this directory", and "copy that one to
> >that directory" and then reboot or
> >restart the service.  The install application should do all that
> >for consistency sake.  Setting up
> >remoting is treated so casually that way too much time is
> >required to set that feature up and be
> >consistent with server security.  Best practices call for your
> >database to be served on a different
> >serer than the one that provides web services, remember?
> >
> >
> >
> >This address is filtered through the open relay database at
http://www.ordb.org
and is virus scanned by ANTIVIR
http://www.dwhite.ws
mailto:doug@;dwhite.ws

|


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



Re: How about Macromedia provide a more detailed configuration document for CFMX?

2002-10-19 Thread Doug
We are holding off on the installation - we do not wish to bring down our production 
servers until
all the issues are worked out.


This address is filtered through the open relay database at http://www.ordb.org
and is virus scanned by ANTIVIR
http://www.dwhite.ws
mailto:doug@;dwhite.ws

- Original Message -
From: "Kola Oyedeji" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, October 19, 2002 12:24 PM
Subject: RE: How about Macromedia provide a more detailed configuration document for 
CFMX?


| Doug
|
| I will be installing CFMX for the first time, what configuration problems
| are you having? What issues should i be aware of?
|
| Thanks
|
| Kola
|

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



RE: is my redundancy solution a violation of licensing terms?

2002-10-19 Thread Trey Rouse
I'm fairly certain this is a violation of both licensures.

However, you CAN use your single SQL license to run on two boxes provided
you configure them in a passive cluster. However your non-clustered fail
over solution does not meet their definition of fail-over only.

Microsoft has made a concession that if your implementation is purely as
passive fail over, then they don't hit you twice for licensing.  They admit
that since only one license can actually be available at any given moment,
they can't charge you for 2. In honesty, I was surprised when our M$ rep
told us this ;).

Perhaps Macromedia should consider allowing this when installed on OS
enforced passive clusters as well ;).


Trey Rouse

-Original Message-
From: John Innit [mailto:harmony@;mtv.net]
Sent: Thursday, October 17, 2002 8:22 PM
To: CF-Talk
Subject: is my redundancy solution a violation of licensing terms?


I'm running a site on CF 4.5 on Win2K, IIS 5.0 and SQL 2000.

We have 2 servers. Web server runs IIS 5.0, CF 4.5 and the DB Server runs
SQL 2000

I want to set up a redundancy precaution where I install SQL Server on the
Web server and CF and IIS on the DB server so that in the event of a
hardware failure on either of the machines, I'll still be able to get the
site up and running quickly.

Does this violate the standard licensing agreements? I'm not sure what
licenses we have, but I will check with my tech people, I just want to know
if this is a viable option and if not can anyone suggest a way we can have
a backup solution in the event of a hardware failure on either of my
servers?

Thanks for your help.





"The only difference between me and a madman is that I'm not mad. Innit ?
- Salvador Dali + Co. (1904-1989)


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



RE: Verity Expertise? Macromedia?

2002-10-19 Thread Trey Rouse
Yes, Verity should stay in CF!!!

It is a terrifically powerful tool.

However, why can't Macromedia post the Verity Query Language reference as
implemented with CFMX on their support site?

My verity rep seemed to suggest this was within the bounds of MM's oem
agreement, but couldn't say for sure.

Trey Rouse

-Original Message-
From: Gaulin, Mark [mailto:mgaulin@;globalspec.com]
Sent: Friday, October 18, 2002 1:24 PM
To: CF-Talk
Subject: RE: Verity Expertise? Macromedia?


I don't know about that... Verity for CF is free. Have you checked out the
price of actually buying Verity? Or of buying a decent replacement for
verity?  Have you tried using any of the free alternatives? The power and
level of integration you get with CF & Verity is pretty good, so I'm happy
to take what I can get.

All the MM bashing on the list lately seems out of balance with how much you
do actually get from their products.

Just one person's opinion...

Mark

-Original Message-
From: Mark Leder [mailto:mel@;markleder.com]
Sent: Friday, October 18, 2002 12:37 PM
To: CF-Talk
Subject: RE: Verity Expertise? Macromedia?


I second the motion that Verity support is quite poor (Verity itself
won't even talk to us developers, or give us access to support docs).
MM needs to think about alternatives to Verity for future releases.

Thanks,
Mark


-Original Message-
From: Jeffrey Polaski [mailto:jpolaski@;rgs.uci.edu]
Sent: Thursday, October 17, 2002 1:35 PM
To: CF-Talk
Subject: RE: Verity Expertise? Macromedia?


I've been doing some work with Verity lately, but I ran into all sorts
of problems. I ended up ditching the Verity soundex, and, because we're
using MS SQL Server, I ended up just using the soundex function that
comes with it. You can run a regular CF query, but the where clause
looks like:
wheresoundex(table.column) = soundex('#form_field#')




   Jeff Polaski
   "The cow is of the bovine ilk;
One end is moo, the other, milk."
   -- Ogden Nash




-Original Message-
From: Adam Reynolds [mailto:adam@;craze.co.uk]
Sent: Thursday, October 17, 2002 9:44 AM
To: CF-Talk
Subject: Verity Expertise? Macromedia?


Ok,
I'm attempting to use the  command in Verity through the
 tag, but this fail unless the exact word is used.

Does anyboydy know where I can find information on getting this to work?
Shouldn't this already be working?

If anybody from Macromedia is listening, could they point me in the
direction of a document that they have that shows me how to get it
working.


Thank you
Adam










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



RE: Verity Expertise? Macromedia?

2002-10-19 Thread Trey Rouse
Yeah, I also found this not to work ;).  I can't speak to whether it is a
known bug or if there will be a patch.

We've just worked around it. For our daily and hourly maintenance we use
updates, and depending on the size of the collection we delete and recreate
them weekly or monthly to 'purge' the collections just for good measure ;).

Trey Rouse
Rice University

-Original Message-
From: Adam Reynolds [mailto:adam@;craze.co.uk]
Sent: Friday, October 18, 2002 1:41 AM
To: CF-Talk
Subject: RE: Verity Expertise? Macromedia?


Have you also found that  -Original Message-
> From: Trey Rouse [mailto:trouse@;rice.edu]
> Sent: 17 October 2002 21:10
> To: CF-Talk
> Subject: RE: Verity Expertise? Macromedia?
>
>
> You will probably have better luck reading documentation from Verity
> than finding support from MM.  At least that's been my experience.
>
> In the past I was able to purchase a verity query language reference
> from Verity.  Oddly, I no longer find any mention of the language at
> their site, go figure. ;)
>
> Apparently you have to be a registered verity customer to view their
> references now, kinda difficult for an oem end user, no?
>
> However, some bookmarks I've found helpful:
>
> http://www.library.upenn.edu/topicpdf/docs/qrylang.htm
> http://www.aip.org/careersvc/verhelp/verhelp.html
>
> Not the most useful stuff, but the verity oem agreement has always been,
> "Here is an amazingly powerful cool tool, good luck locating the
> reference material to actually make it work as expected".  ;)
>
> I have a whitepaper from Verity on my desk that specifically details the
> limitations of the k2 integrated product, and scanning it, there is no
> mention of soundex being implemented any differently.
>
>
> Trey Rouse
>
>
>
> > -Original Message-
> > From: Adam Reynolds [mailto:adam@;craze.co.uk]
> > Sent: Thursday, October 17, 2002 11:44 AM
> > To: CF-Talk
> > Subject: Verity Expertise? Macromedia?
> >
> > Ok,
> > I'm attempting to use the  command in Verity through the
> > 
> > tag, but this fail unless the exact word is used.
> >
> > Does anyboydy know where I can find information on getting this to
> work?
> > Shouldn't this already be working?
> >
> > If anybody from Macromedia is listening, could they point me in the
> > direction of a document that they have that shows me how to get it
> > working.
> >
> >
> > Thank you
> > Adam
>
>
>

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



RE: How about Macromedia provide a more detailed configuration document for CFMX?

2002-10-19 Thread Josh Trefethen
I have made the same decision...

-Original Message-
From: Doug [mailto:doug@;dwhite.ws] 
Sent: Saturday, October 19, 2002 10:55 AM
To: CF-Talk
Subject: Re: How about Macromedia provide a more detailed configuration
document for CFMX?

We are holding off on the installation - we do not wish to bring down
our production servers until
all the issues are worked out.


This address is filtered through the open relay database at
http://www.ordb.org
and is virus scanned by ANTIVIR
http://www.dwhite.ws
mailto:doug@;dwhite.ws

- Original Message -
From: "Kola Oyedeji" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, October 19, 2002 12:24 PM
Subject: RE: How about Macromedia provide a more detailed configuration
document for CFMX?


| Doug
|
| I will be installing CFMX for the first time, what configuration
problems
| are you having? What issues should i be aware of?
|
| Thanks
|
| Kola
|


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



RE: is my redundancy solution a violation of licensing terms?

2002-10-19 Thread Josh Trefethen
Switch to PostgreSQL! 

http://postgresql.org

I made the switch from SQL Server a while back and haven't paid or
worried about licensing for sometime; yet still enjoy advanced RDBMS
features like stored procs, triggers, etc.

Take a look...

Josh Trefethen
http://exciteworks.com
Affordable CF Hosting on Linux



-Original Message-
From: Trey Rouse [mailto:trouse@;rice.edu] 
Sent: Saturday, October 19, 2002 1:20 PM
To: CF-Talk
Subject: RE: is my redundancy solution a violation of licensing terms? 

I'm fairly certain this is a violation of both licensures.

However, you CAN use your single SQL license to run on two boxes
provided
you configure them in a passive cluster. However your non-clustered fail
over solution does not meet their definition of fail-over only.

Microsoft has made a concession that if your implementation is purely as
passive fail over, then they don't hit you twice for licensing.  They
admit
that since only one license can actually be available at any given
moment,
they can't charge you for 2. In honesty, I was surprised when our M$ rep
told us this ;).

Perhaps Macromedia should consider allowing this when installed on OS
enforced passive clusters as well ;).


Trey Rouse

-Original Message-
From: John Innit [mailto:harmony@;mtv.net]
Sent: Thursday, October 17, 2002 8:22 PM
To: CF-Talk
Subject: is my redundancy solution a violation of licensing terms?


I'm running a site on CF 4.5 on Win2K, IIS 5.0 and SQL 2000.

We have 2 servers. Web server runs IIS 5.0, CF 4.5 and the DB Server
runs
SQL 2000

I want to set up a redundancy precaution where I install SQL Server on
the
Web server and CF and IIS on the DB server so that in the event of a
hardware failure on either of the machines, I'll still be able to get
the
site up and running quickly.

Does this violate the standard licensing agreements? I'm not sure what
licenses we have, but I will check with my tech people, I just want to
know
if this is a viable option and if not can anyone suggest a way we can
have
a backup solution in the event of a hardware failure on either of my
servers?

Thanks for your help.





"The only difference between me and a madman is that I'm not mad. Innit
?
- Salvador Dali + Co. (1904-1989)



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



RE: cfstoredproc behavior

2002-10-19 Thread S . Isaac Dealey
Have you run the MX Updater? They may haved worked around the issue with the
JDBC drivers in the updater.

> Yes, many of my stored procedures return recordsets and
> are working just
> fine.  I think not being able to return recordsets would
> be a HUGE
> limitation.  I can't imagine that this would be the case.
> Again, when I
> created my datasouce I chose the SQL Server datasource
> type from the drop
> down menu.  There is no mention of whether or not it is a
> JDBC, but I tend
> to believe it is because ODBC Socket was another option
> also on the drop
> down list.  Can anyone else confirm or deny this behavior?

> Andy

> -Original Message-
> From: S. Isaac Dealey [mailto:info@;turnkey.to]
> Sent: Saturday, October 19, 2002 7:20 AM
> To: CF-Talk
> Subject: RE: cfstoredproc behavior


>> I'm pretty sure it's the order that is hanging it up.  I
>> have used
>> cfstoredproc in other places on our servers and it works
>> just fine.

>> It's pretty dissapointing that this seems to be a
>> "feature" or "bug" or
>> whatever you want to call it that MM is ignoring.  What
>> happens when you
>> want to skip parameters in a dynamic statement like I was
>> doing, I guess you
>> have to revert to cfquery?

> Or you have to include all the parameters you wanted to
> skip ... Which means
> you can't allow the stored procedure to use its defaults.
> In my case most of
> my stored procedures use NULL for any defaults, so passing
> null="yes" in the
>  is equivalent, however, if I used "bilbo"
> as a default for
> instance, I'd have to pass "bilbo" as the value, which
> thoroughly defeats
> the purpose of having a default in my stored procedure and
> makes my job that
> much harder if that "default" value ever changes.

>> Also, what is the deal with cfquery in CFMX?  I've just
>> finally got CFMX
>> installed tonight for the first time.  Our website which
>> is probably 95%
>> cfquery vs. cfstoredproc seems to be working just fine.
>> For a datasource I
>> just chose SQL Server from the list of datasource types
>> when I created it, I
>> think this means I'm using the JDBC driver?  Either way,
>> all of our stored
>> procedure calls that are made in cfquery tags seem to be
>> working fine.

> Hmmm... do many of your stored procedures return a
> recordset? That's the
> only issue really, so if you only use the stored procs to
> perform inserts
> and updates and aren't concerned with getting a recordset
> back, there
> wouldn't be any reason to notice the difference.
> Otherwise, you may be using
> the ODBC socket -- I wouldn't know, I've been too busy
> with recent updates
> and preparing for MX to actually install MX and work with
> it much. I suppose
> it's possible MM could have found a way to change the
> behavior with the JDBC
> drivers in the recent MX update though again I wouldn't
> know.

>> Personally, I have always preferred the cfquery tag over
>> the cfstoredproc
>> for the simple reason that you get real error messages
>> back and not just
>> "Unknown Data Access Error".

> Not to mention all that extra typing. :)

> Though iirc, it does have some other advantages in that I
> believe it's
> supposed to help speed up processing of stored procedures
> ( I wonder if this
> is done by not naming parameters ;P ) and it insulates the
> procedure from
> unlikely sql insertion attacks and issues with data
> insertion, like the \ on
> MySQL ( although current versions of MySQL don't support
> stored procedures )
> being a special character that  doesn't know to
> account for. Of
> course, much of this can also be accomplished with
>  in a
> stored procedure called with  so my biggest
> gripes are the lack of
> ability to use db defined defaults and the fact that it's
> completely
> undocumented anywhere on MM's site ( actually the
> documentation says that
> the dbvarname attribute is supposed to be the name of the
> parameter in the
> stored procedure, which you might be able to weasel out of
> saying is an out
> and out lie, but it's certainly seems to indicate that the
> order of
> parameters shouldn't matter ) and since I may not
> necessarily be the only
> developer who ever touches my code there's a good chance
> at some point that
> I'm going to have to field technical support calls or
> emails in which I'll
> have to explain this whole debacle over again.


> Isaac
> Certified Advanced ColdFusion 5 Developer

> www.turnkey.to
> 954-776-0046


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


Isaac
Certified Advanced ColdFusion 5 Developer

www.turnkey.to
954-776-0046

~|
Archives: http://www.houseoffusion.com/cf_list

Re: counting # of characters in file

2002-10-19 Thread S . Isaac Dealey
> Tony Weeg wrote:
>> yeah, well the way i look at it, 90% of the time
>> im going to have to populate a file with data. how that
>> data might come to me, in most cases i think, as part
>> of-or
>> fully contained in a variable, so a len() function should
>> work most of the time...wouldnt you say.  but yeah, some
>> cool, ReadCharInFile() function would rock.

> should be something like:

> 
> function GetFileLength(filename){
>   file = createObject('java', 'java.io.File');
>   file.init(filename);
>   return file.length();
> }
> 

> Very simular functions can be made for CanRead, CanWrite,
> delete,
> exists,isDirectory, isFile, lastModified, renameTo,
> setLastModified,
> setReadOnly.

> Maybe I'm up to it tonight. If I am, I'll sumbit them to
> the cflib.

There are already functions for exists() -- fileexists() and
directoryexists() ... but the rest of them would be rather useful

Isaac
Certified Advanced ColdFusion 5 Developer

www.turnkey.to
954-776-0046

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



RE: cfstoredproc behavior

2002-10-19 Thread Andy Clary
Yes, I have run the updater, but the stored procedure worked before the
updater as well.

-Original Message-
From: S. Isaac Dealey [mailto:info@;turnkey.to]
Sent: Saturday, October 19, 2002 12:09 PM
To: CF-Talk
Subject: RE: cfstoredproc behavior


Have you run the MX Updater? They may haved worked around the issue with the
JDBC drivers in the updater.

> Yes, many of my stored procedures return recordsets and
> are working just
> fine.  I think not being able to return recordsets would
> be a HUGE
> limitation.  I can't imagine that this would be the case.
> Again, when I
> created my datasouce I chose the SQL Server datasource
> type from the drop
> down menu.  There is no mention of whether or not it is a
> JDBC, but I tend
> to believe it is because ODBC Socket was another option
> also on the drop
> down list.  Can anyone else confirm or deny this behavior?

> Andy

> -Original Message-
> From: S. Isaac Dealey [mailto:info@;turnkey.to]
> Sent: Saturday, October 19, 2002 7:20 AM
> To: CF-Talk
> Subject: RE: cfstoredproc behavior


>> I'm pretty sure it's the order that is hanging it up.  I
>> have used
>> cfstoredproc in other places on our servers and it works
>> just fine.

>> It's pretty dissapointing that this seems to be a
>> "feature" or "bug" or
>> whatever you want to call it that MM is ignoring.  What
>> happens when you
>> want to skip parameters in a dynamic statement like I was
>> doing, I guess you
>> have to revert to cfquery?

> Or you have to include all the parameters you wanted to
> skip ... Which means
> you can't allow the stored procedure to use its defaults.
> In my case most of
> my stored procedures use NULL for any defaults, so passing
> null="yes" in the
>  is equivalent, however, if I used "bilbo"
> as a default for
> instance, I'd have to pass "bilbo" as the value, which
> thoroughly defeats
> the purpose of having a default in my stored procedure and
> makes my job that
> much harder if that "default" value ever changes.

>> Also, what is the deal with cfquery in CFMX?  I've just
>> finally got CFMX
>> installed tonight for the first time.  Our website which
>> is probably 95%
>> cfquery vs. cfstoredproc seems to be working just fine.
>> For a datasource I
>> just chose SQL Server from the list of datasource types
>> when I created it, I
>> think this means I'm using the JDBC driver?  Either way,
>> all of our stored
>> procedure calls that are made in cfquery tags seem to be
>> working fine.

> Hmmm... do many of your stored procedures return a
> recordset? That's the
> only issue really, so if you only use the stored procs to
> perform inserts
> and updates and aren't concerned with getting a recordset
> back, there
> wouldn't be any reason to notice the difference.
> Otherwise, you may be using
> the ODBC socket -- I wouldn't know, I've been too busy
> with recent updates
> and preparing for MX to actually install MX and work with
> it much. I suppose
> it's possible MM could have found a way to change the
> behavior with the JDBC
> drivers in the recent MX update though again I wouldn't
> know.

>> Personally, I have always preferred the cfquery tag over
>> the cfstoredproc
>> for the simple reason that you get real error messages
>> back and not just
>> "Unknown Data Access Error".

> Not to mention all that extra typing. :)

> Though iirc, it does have some other advantages in that I
> believe it's
> supposed to help speed up processing of stored procedures
> ( I wonder if this
> is done by not naming parameters ;P ) and it insulates the
> procedure from
> unlikely sql insertion attacks and issues with data
> insertion, like the \ on
> MySQL ( although current versions of MySQL don't support
> stored procedures )
> being a special character that  doesn't know to
> account for. Of
> course, much of this can also be accomplished with
>  in a
> stored procedure called with  so my biggest
> gripes are the lack of
> ability to use db defined defaults and the fact that it's
> completely
> undocumented anywhere on MM's site ( actually the
> documentation says that
> the dbvarname attribute is supposed to be the name of the
> parameter in the
> stored procedure, which you might be able to weasel out of
> saying is an out
> and out lie, but it's certainly seems to indicate that the
> order of
> parameters shouldn't matter ) and since I may not
> necessarily be the only
> developer who ever touches my code there's a good chance
> at some point that
> I'm going to have to field technical support calls or
> emails in which I'll
> have to explain this whole debacle over again.


> Isaac
> Certified Advanced ColdFusion 5 Developer

> www.turnkey.to
> 954-776-0046


> ~~
> ~~~|
> Archives:
> http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
> Subscription: http://www.houseoffusion.com/index.cfm?sideb
> ar=lists&body=lists/cf_talk
> FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
> Get the mails

RE: cfstoredproc behavior

2002-10-19 Thread S . Isaac Dealey
That's really strange... You're the only person I've talked to yet who's had
that behavior... at least, that I'm aware of. Everyone else I've talked to
who's tried to use cfquery for stored procedures on MX without using the
ODBC socket drivers has said they couldn't return record sets -- and I
remember reading from this list someone said ( and I think they were from MM
) that the JDBC drivers just didn't support the feature that allowed it to
be done with the ODBC drivers. Not to mention that, although I don't work
with MX yet, I was able to install an application on it briefly several
months ago and noticed that the cfquery syntax wasn't returning any
recordsets then.


Isaac
Certified Advanced ColdFusion 5 Developer

www.turnkey.to
954-776-0046

> Yes, I have run the updater, but the stored procedure
> worked before the
> updater as well.

> -Original Message-
> From: S. Isaac Dealey [mailto:info@;turnkey.to]
> Sent: Saturday, October 19, 2002 12:09 PM
> To: CF-Talk
> Subject: RE: cfstoredproc behavior


> Have you run the MX Updater? They may haved worked around
> the issue with the
> JDBC drivers in the updater.

>> Yes, many of my stored procedures return recordsets and
>> are working just
>> fine.  I think not being able to return recordsets would
>> be a HUGE
>> limitation.  I can't imagine that this would be the case.
>> Again, when I
>> created my datasouce I chose the SQL Server datasource
>> type from the drop
>> down menu.  There is no mention of whether or not it is a
>> JDBC, but I tend
>> to believe it is because ODBC Socket was another option
>> also on the drop
>> down list.  Can anyone else confirm or deny this
>> behavior?

>> Andy

>> -Original Message-
>> From: S. Isaac Dealey [mailto:info@;turnkey.to]
>> Sent: Saturday, October 19, 2002 7:20 AM
>> To: CF-Talk
>> Subject: RE: cfstoredproc behavior


>>> I'm pretty sure it's the order that is hanging it up.  I
>>> have used
>>> cfstoredproc in other places on our servers and it works
>>> just fine.

>>> It's pretty dissapointing that this seems to be a
>>> "feature" or "bug" or
>>> whatever you want to call it that MM is ignoring.  What
>>> happens when you
>>> want to skip parameters in a dynamic statement like I
>>> was
>>> doing, I guess you
>>> have to revert to cfquery?

>> Or you have to include all the parameters you wanted to
>> skip ... Which means
>> you can't allow the stored procedure to use its defaults.
>> In my case most of
>> my stored procedures use NULL for any defaults, so
>> passing
>> null="yes" in the
>>  is equivalent, however, if I used "bilbo"
>> as a default for
>> instance, I'd have to pass "bilbo" as the value, which
>> thoroughly defeats
>> the purpose of having a default in my stored procedure
>> and
>> makes my job that
>> much harder if that "default" value ever changes.

>>> Also, what is the deal with cfquery in CFMX?  I've just
>>> finally got CFMX
>>> installed tonight for the first time.  Our website which
>>> is probably 95%
>>> cfquery vs. cfstoredproc seems to be working just fine.
>>> For a datasource I
>>> just chose SQL Server from the list of datasource types
>>> when I created it, I
>>> think this means I'm using the JDBC driver?  Either way,
>>> all of our stored
>>> procedure calls that are made in cfquery tags seem to be
>>> working fine.

>> Hmmm... do many of your stored procedures return a
>> recordset? That's the
>> only issue really, so if you only use the stored procs to
>> perform inserts
>> and updates and aren't concerned with getting a recordset
>> back, there
>> wouldn't be any reason to notice the difference.
>> Otherwise, you may be using
>> the ODBC socket -- I wouldn't know, I've been too busy
>> with recent updates
>> and preparing for MX to actually install MX and work with
>> it much. I suppose
>> it's possible MM could have found a way to change the
>> behavior with the JDBC
>> drivers in the recent MX update though again I wouldn't
>> know.

>>> Personally, I have always preferred the cfquery tag over
>>> the cfstoredproc
>>> for the simple reason that you get real error messages
>>> back and not just
>>> "Unknown Data Access Error".

>> Not to mention all that extra typing. :)

>> Though iirc, it does have some other advantages in that I
>> believe it's
>> supposed to help speed up processing of stored procedures
>> ( I wonder if this
>> is done by not naming parameters ;P ) and it insulates
>> the
>> procedure from
>> unlikely sql insertion attacks and issues with data
>> insertion, like the \ on
>> MySQL ( although current versions of MySQL don't support
>> stored procedures )
>> being a special character that  doesn't know to
>> account for. Of
>> course, much of this can also be accomplished with
>>  in a
>> stored procedure called with  so my biggest
>> gripes are the lack of
>> ability to use db defined defaults and the fact that it's
>> completely
>> undocumented anywhere on MM's site ( actually the
>> documentation says that
>> the dbvarname at

RE: OT RegEx Help

2002-10-19 Thread Ben Doom
The problem that you are encountering is because you have put  in square
brackets [].  This makes  a character class.

If I understand what you are trying to do, what you are looking for is
something like:

^(()*[[:space:]]*)*

This looks for as many 's and spaces as it can find at the very
beginning of the string.  If you are using backreferences, be careful, as
this uses nested repeated groupings.

HTH.

As always, the plug for CF-RegEx:
http://www.houseoffusion.com/cf_lists/index.cfm?method=threads&forumid=21
Join, post, and read the archives here.



  --Ben Doom
Programmer & General Lackey
Moonbow Software

: -Original Message-
: From: Jim Curran [mailto:jim_ml@;nylontechnology.com]
: Sent: Thursday, October 17, 2002 6:29 PM
: To: CF-Talk
: Subject: OT RegEx Help
:
:
: Hello all,
:
: Simple Regex that I cannot decipher:
:
: String:
:
:   text
:
: Regex:
:
:   ^[()[:space:]]+
:
: I want to match:
:
:  
:
: But it matches:
:
:   http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com



Re: OT: MM - the story

2002-10-19 Thread cf-talk
Hi Sean, thanks. Typical questions would be:
What version of Flash ?
How did you integrate the movie ?
What video format ?
.. and those questions.
I am sure, I have seen an article somewhere:
"Making of" But I can't remember where it was.
That would be great if you can find it !
Uwe
-- Original Message --
from: Sean A Corfield <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Sat, 19 Oct 2002 09:58:51 -0700

On Saturday, Oct 19, 2002, at 05:16 US/Pacific, cf-talk wrote:
> Hi list, anybody who knows how they did:
> http://www.macromedia.com/macromedia/story/

Well, it's 'just' a Flash movie. What would you like to know about it?

We may have used FlashCom for the video, I'm not sure. I can certainly 
find out.

"I can smell your brains!"
-- Mittens the Kitten : http://www.matazone.co.uk/theotherside.html


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



Re: OT: MM - the story

2002-10-19 Thread Sean A Corfield
On Saturday, Oct 19, 2002, at 13:25 US/Pacific, cf-talk wrote:
> What version of Flash ?

MX (of course) with Flash Player 6.

BTW, there's a public beta of the new 6r60 player just started - check  
out the Flash Support Center:
http://www.macromedia.com/support/flash/ts/documents/ 
flashplayer_beta.htm
The transparent windowless mode is particularly cool (with full support  
for Mac and Linux now).

> How did you integrate the movie ?
> What video format ?

Flash Video format - you convert movies to that format and Flash can  
play them back through the player. This works fine for 'small' video  
clips but for full streaming video, you need something based on  
FlashCom. However, what you're seeing is pure Flash, loading 'small'  
movie clips, with no server magic (as far as I know!).

> I am sure, I have seen an article somewhere:
> "Making of" But I can't remember where it was.
> That would be great if you can find it !

You might be thinking of this article about the making of the Executive  
Presentation on the value of MX:

http://www.macromedia.com/desdev/mx/flashcom/articles/odopod.html

You might also find this interesting:

http://www.macromedia.com/desdev/mx/flash/articles/flashmx_video.html

"I can smell your brains!"
-- Mittens the Kitten : http://www.matazone.co.uk/theotherside.html

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



Re: OT: MM - the story

2002-10-19 Thread Sean A Corfield
On Saturday, Oct 19, 2002, at 14:00 US/Pacific, Sean A Corfield wrote:
>   http://www.macromedia.com/support/flash/ts/documents/
> flashplayer_beta.htm

Darn email wrap!

http://shorterlink.com/?HGXWBF

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



Re: e-mailing-management tool

2002-10-19 Thread Jon Hall
I've used it, and it works. It's not a heavy duty program though.

I'll just say that the code is in all caps, their are unlocked
session and app variables everywhere, and pound signs galore. Looks
like a 4.0 or earlier era program to me...

-- 
jon
mailto:jonhall@;ozline.net

Saturday, October 19, 2002, 8:17:16 AM, you wrote:

ctsd> Hi list, there is an email list-manager to manage E-Mailings in HTML/ASCII from 
the following company: http://www.2simplifi.com/.
ctsd> Someone there who knows this software and can tell me if it has any 
problems/disadvantages ?
ctsd> Any other software for e-mailing-management with CF available ?
ctsd> Uwe

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



Re: session vars and locking

2002-10-19 Thread Chris Norloff
YES! , if it's CF 4.5 or 5
It depends, if it's CFMX

Chris Norloff


-- Original Message --
from: "Tony Weeg" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Fri, 18 Oct 2002 21:00:23 -0400

>hi there
>
>is it safe to assume that everywhere on a page, where i am either
>setting or reading from session variables, that i should have cflock's
>of the exclusive type (when writing to session vars) and cflocks of
>the readonly type (when reading from session vars) on every single
>occurence
>of one of these situations? 
>
>without fail, i mean do every single one of them in one way or the
>other?
>
>thanks.
>
>...tony
>
>tony weeg
>[EMAIL PROTECTED]
>www.revolutionwebdesign.com
>rEvOlUtIoN wEb DeSiGn
>410.334.6331 
>
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm



RE: How about Macromedia provide a more detailed configuration document for CFMX?

2002-10-19 Thread Mike Chambers
what issues?

mike chambers

[EMAIL PROTECTED]

> -Original Message-
> From: Doug [mailto:doug@;dwhite.ws] 
> Sent: Saturday, October 19, 2002 1:55 PM
> To: CF-Talk
> Subject: Re: How about Macromedia provide a more detailed 
> configuration document for CFMX?
> 
> 
> We are holding off on the installation - we do not wish to 
> bring down our production servers until
> all the issues are worked out.
> 

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



RE: cfstoredproc behavior

2002-10-19 Thread Dave Watts
> Have you run the MX Updater? They may haved worked around 
> the issue with the JDBC drivers in the updater.

Based on my reading of the log file created by the Updater, no database
drivers were changed by the update process.

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

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



Re: How about Macromedia provide a more detailed configuration document for CFMX?

2002-10-19 Thread Marius Milosav
the null problem.
To see more details :
http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=3&threadid=
410762&highlight_key=y&keyword1=null

in our case this issue pops out of the blue. Once in a while any page
requested gives this error.
we had track it to a line of code that tries to copy some session
information in the request scope in the onRequest End page
For some reason CFMX is loosing a structure in the request scope and throws
a null error.
The only way to fix it (in or case is to restart CFMX) then everything goes
back to normal for a few days (weeks) and then hits you again.
This is major and should be resolved ASAP.

Connection reset by peer
http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=10&threadid
=423645&highlight_key=y&keyword1=Connection%20reset%20by%20peer


Probably the are some other minor ones but these ones are SHOW STOPPERS.

Thank you
Marius Milosav
www.scorpiosoft.com
It's not about technology, it's about people.
Virtual Company (VICO) Application Demo
www.scorpiosoft.com/vicodemo/login.cfm

- Original Message -
From: "Mike Chambers" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, October 19, 2002 7:35 PM
Subject: RE: How about Macromedia provide a more detailed configuration
document for CFMX?


> what issues?
>
> mike chambers
>
> [EMAIL PROTECTED]
>
> > -Original Message-
> > From: Doug [mailto:doug@;dwhite.ws]
> > Sent: Saturday, October 19, 2002 1:55 PM
> > To: CF-Talk
> > Subject: Re: How about Macromedia provide a more detailed
> > configuration document for CFMX?
> >
> >
> > We are holding off on the installation - we do not wish to
> > bring down our production servers until
> > all the issues are worked out.
> >
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



Dropdown Value Passing

2002-10-19 Thread Jillian Carroll
I have a bit of a problem... and I'm hoping there is an easy way to solve
it.

I have a dropdown that is populated like this:


#users.fname# #users.lname#,
#users.city#


So it provides a list of trainers, by name including the city they train in.
What I want to do is let my visitor choose from this list, but when it
passes the value, I'd like it to pass another variable #users.trainerid#...
instead of any of those other fields (fname, lname, city0.

How would I do this?

--
Jillian

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



Re: Dropdown Value Passing

2002-10-19 Thread Critter
oi Jillian!!

..


-- 
Critz
 Macromedia Certified Advanced ColdFusion Developer
 http://blog.ctzc.com";>





Saturday, October 19, 2002, 8:48:05 PM, you wrote:

JC> I have a bit of a problem... and I'm hoping there is an easy way to solve
JC> it.

JC> I have a dropdown that is populated like this:

JC> 
JC> #users.fname# #users.lname#,
JC> #users.city#
JC> 

JC> So it provides a list of trainers, by name including the city they train in.
JC> What I want to do is let my visitor choose from this list, but when it
JC> passes the value, I'd like it to pass another variable #users.trainerid#...
JC> instead of any of those other fields (fname, lname, city0.

JC> How would I do this?

JC> --
JC> Jillian

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