Re: Converting from SQL to mySql

[John Vincent]

> I am wondering how difficult it might be to migrate over to mySql from 
> SQL2000? Is this a daunting task? Any assistance would be much 
> appreciated. I would especially love to hear from someone who has done 
> this.
> 
> 
> 
> Regards,
> 
> 
> Doug B.

I use data loader for migrating almost any data, it helps me to convert MSSQL 
to MYSQL, MS access to MSSQL, mysql, csv loader, foxpro and MSSQL to MS access, 
MYSQl, CSV, foxpro etc. In my view this is a best Data Migration Tool  


Download Free : http://www.convert-db.com/mssql-to-mysql.htm 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325762
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) profanity filter

[Tom Chiverton]

On Wednesday 26 Aug 2009, Peter Boughton wrote:
> It's idiotic that words can be considered offensive and blocked without
> context - yet "I hope you suffer an eternity of burning agony" will be
> allowed past just fine.

You should have seen the bizzare errors I had to deal with as a sys. admin for 
a company who had someone who's name was 'Mycock' !

-- 
Helping to simultaneously harness partnerships as part of the IT team of the 
year, '09 and '08



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at 
Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB.  A list 
of members is available for inspection at the registered office together with a 
list of those non members who are referred to as partners.  We use the word 
“partner” to refer to a member of the LLP, or an employee or consultant with 
equivalent standing and qualifications. Regulated by the Solicitors Regulation 
Authority.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be 
confidential or legally privileged.  If you are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 2500.

For more information about Halliwells LLP visit www.halliwells.co

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325763
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 Threads

[Tom Chiverton]

On Wednesday 26 Aug 2009, Byte Me wrote:
> Does anyone know how to get a list of Coldfusion Threads (created with the
> cfthread tag), programatically. I don't have access to the Server Monitor.
> If a thread is aborted, I need to know it was aborted, 

How about when you create the thread, you add it's name to an 
application-scoped variable.
Then you can attempt to join each one later ?

-- 
Helping to globally enable edge-of-your-seat architectures as part of the IT 
team of the year, '09 and '08



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at 
Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB.  A list 
of members is available for inspection at the registered office together with a 
list of those non members who are referred to as partners.  We use the word 
“partner” to refer to a member of the LLP, or an employee or consultant with 
equivalent standing and qualifications. Regulated by the Solicitors Regulation 
Authority.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be 
confidential or legally privileged.  If you are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 2500.

For more information about Halliwells LLP visit www.halliwells.co

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325764
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Custom 404 .cfm pages, and cf flash tags.

[Paul Alkema]

Hey All,
I've recently ran into an issue that I was hoping I could have a little help
with. My company has been using custom 404 pages for awhile that we set up
in iis however we had never set up this custom 404 page to display on .cfm
pages, only missing folders.

Ie; www.website.com/asdasdasdsd/ would display a custom 404 error
But www.website.com/asdasdasdsd.cfm would not.

I recently set this up by going in the iis properties for our site, went to
the home directory tab click on configuration and selected edit from the
mappings tab. From here I checked the verify that file exists open. 

This enabled the file.cfm custom error to appear however for some reason it
disabled all of my ColdFusion flash forms. None of them appear now. If I
undo the iis setting that I changes earlier they all re-appear.

Has anyone ever ran into this issue before? Is there a better way to do
this?

Thanks!
Paul Alkema


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325765
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Custom 404 .cfm pages, and cf flash tags.

[Peter Boughton]

> From here I checked the verify that file exists open. 

Don't do that - it breaks things (as you've discovered).

Instead, in the Administrator, you can specify the "Missing Template Handler" - 
set that to the same file as you're using for IIS and it should solve your 
problem.

(You probably also want to set the "Site-wide Error Handler" too.) 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325766
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Custom 404 .cfm pages, and cf flash tags.

[Azadi Saryev]

you can also use onMissingTemplate() method in your Application.cfc
this way you can define different error pages and handlers for your
missing .cfm templates for each application running on same server,
whereas settings in cf admin are server-wide (all applications running
on same server will use same missing template page).

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/


On 27/08/2009 21:27, Peter Boughton wrote:
>   
>> From here I checked the verify that file exists open. 
>> 
> Don't do that - it breaks things (as you've discovered).
>
> Instead, in the Administrator, you can specify the "Missing Template Handler" 
> - set that to the same file as you're using for IIS and it should solve your 
> problem.
>
> (You probably also want to set the "Site-wide Error Handler" too.) 
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325767
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

sql deadlock

[Chad Gray]

I occasionally see this error in an application I wrote.

Transaction (Process ID 54) was deadlocked on lock | communication buffer 
resources with another process and has been chosen as the deadlock victim. 
Rerun the transaction.

The code that is causing this is below.



DELETE FROM #variables.table#
WHERE #variables.IDField# = #variables.ID# AND ColorName = 
'#variables.i#'



Pretty simple query...  How do I keep this SQL from deadlocking?

What is a deadlock?  Two users hitting the code at the same time and database 
cant handle all the requests?


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325768
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: sql deadlock

[John M Bliss]

http://en.wikipedia.org/wiki/Deadlock

On Thu, Aug 27, 2009 at 8:46 AM, Chad Gray  wrote:

>
> I occasionally see this error in an application I wrote.
>
> Transaction (Process ID 54) was deadlocked on lock | communication buffer
> resources with another process and has been chosen as the deadlock victim.
> Rerun the transaction.
>
> The code that is causing this is below.
>
> 
>
>DELETE FROM #variables.table#
>WHERE #variables.IDField# = #variables.ID# AND ColorName =
> '#variables.i#'
>
> 
>
> Pretty simple query...  How do I keep this SQL from deadlocking?
>
> What is a deadlock?  Two users hitting the code at the same time and
> database cant handle all the requests?
>
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325769
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Custom 404 .cfm pages, and cf flash tags.

[Peter Boughton]

Good point, yes - if you've got multiple domains/applications on the server 
then you should probably do that.

Still worth having a very generic server-level one as well though. 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325770
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Converting from SQL to mySql

[Larry Lyons]

> > The value proposition of CF is that it pays for itself with shorter
> > development and maintenance times. If that's not true for 
> > you, you shouldn't
> > buy it no matter what the price is. If it is true for you, 
> > the price is
> > irrelevant. As enterprise products go, CF is dirt cheap.
> 
> Don't forget about people that sell software.  Even though I'm a CF
> developer, and I love it, if I wanted to make a web based product 
> that
> would go to small/medium businesses, I'd hate to have to tell them, 
> "My
> product costs $150, but I'm charging you a $1450 because it's built 
> on
> ColdFusion".  Yes, I know they could host it on my servers, but a lot 
> of
> data is too secure for that.
> 

Lets not forget there are 2 enterprise ready open source CF engines, Open 
BlueDragon and Railo. So the argument about price is no longer relevant. Unless 
you need some of the Adobe specific tags, both these two FOSS CF engines are 
more than adequate for most tasks. 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325771
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: 500 Error / java.lang.Error: Error starting thread: Not enough storage is available to process this command.

[Dave Watts]

> No body has a single word of advice about what this thread dump shows? Can
> some one point me in the right direction? I Googled it to no avail...

It's a fairly generic Windows error. Are you storing client variables
in the registry?

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!

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325772
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Cfemail issue(s)

[Victor Moore]

Hi all,

I have a couple of issues with cfmail.
Environment: Windows 2003, CF8.01 ent

The server stopped sending emails
After checking the logs .I found out that it stopped after complaining
that one email had "Invalid Address" which is strange because I check
all emails using isEmail () before sending and I looked at all the
emails in the spool directory and none have any bad email
addresses.The one that CF was complaining about had 500 email
addresses but all are valid.
After that, no emails are sent out. They just sit in the spool
directory. I have tried to move them in and out, play with CF admin
mail settings but no luck.
Somehow the original message caused CF server to ignore mail messages
in the spool directory.
So my questions are:

Is it possible to re-send the emails, short of restarting CF?
Second why would an email fail with Invalid address if all the emails
are valid email addresses.
Third, why will that error cause CF server to black out and stop
sending emails (even if after I have manually removed the so called
offending email with Invalid Address)

Thanks
Victor

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325773
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Cfemail issue(s)

[Cutter (ColdFusion)]

See if this post helps you any:

http://blog.cutterscrossing.com/index.cfm/2006/12/10/ColdFusion-Mail-Spool-Lock

Steve "Cutter" Blades
Adobe Certified Professional
Advanced Macromedia ColdFusion MX 7 Developer

Co-Author of "Learning Ext JS"
http://www.packtpub.com/learning-ext-js/book
_
http://blog.cutterscrossing.com


On 8/27/2009 9:55 AM, Victor Moore wrote:
> Hi all,
>
> I have a couple of issues with cfmail.
> Environment: Windows 2003, CF8.01 ent
>
> The server stopped sending emails
> After checking the logs .I found out that it stopped after complaining
> that one email had "Invalid Address" which is strange because I check
> all emails using isEmail () before sending and I looked at all the
> emails in the spool directory and none have any bad email
> addresses.The one that CF was complaining about had 500 email
> addresses but all are valid.
> After that, no emails are sent out. They just sit in the spool
> directory. I have tried to move them in and out, play with CF admin
> mail settings but no luck.
> Somehow the original message caused CF server to ignore mail messages
> in the spool directory.
> So my questions are:
>
> Is it possible to re-send the emails, short of restarting CF?
> Second why would an email fail with Invalid address if all the emails
> are valid email addresses.
> Third, why will that error cause CF server to black out and stop
> sending emails (even if after I have manually removed the so called
> offending email with Invalid Address)
>
> Thanks
> Victor
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325774
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Cfemail issue(s)

[Rick Root]

On Thu, Aug 27, 2009 at 10:55 AM, Victor Moore wrote:
>
> Is it possible to re-send the emails, short of restarting CF?

I can't answer the other questions, but I don't know of any way to
kick-start the mail spooler once it dies without restarting
Coldfusion.

This happens to use often enough where we have a process that monitors
the spool directories and if it finds files older than a certain time,
it will send us an alert that CF needs restarting due to a mail spool
backup.

-- 
Rick Root
CFFM - Open Source Coldfusion File Manager
http://www.opensourcecf.com/cffm

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325775
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Cfemail issue(s)

[Mark Kruger]

Victor,

Do you mean you are passing a list of 500 addresses in a single attribute?
As in:



If that is what you are doing  I would not be surprised if there is a buffer
for that attribute that truncates your string at some point. You would be
better off looping through your addresses.

Meanwhile you can try restarting the spooler:



  
 





-Mark 


Mark A. Kruger, CFG, MCSE
(402) 408-3733 ext 105
www.cfwebtools.com
www.coldfusionmuse.com
www.necfug.com

-Original Message-
From: Victor Moore [mailto:victor.mo...@gmail.com] 
Sent: Thursday, August 27, 2009 9:56 AM
To: cf-talk
Subject: Cfemail issue(s)


Hi all,

I have a couple of issues with cfmail.
Environment: Windows 2003, CF8.01 ent

The server stopped sending emails
After checking the logs .I found out that it stopped after complaining that
one email had "Invalid Address" which is strange because I check all emails
using isEmail () before sending and I looked at all the emails in the spool
directory and none have any bad email addresses.The one that CF was
complaining about had 500 email addresses but all are valid.
After that, no emails are sent out. They just sit in the spool directory. I
have tried to move them in and out, play with CF admin mail settings but no
luck.
Somehow the original message caused CF server to ignore mail messages in the
spool directory.
So my questions are:

Is it possible to re-send the emails, short of restarting CF?
Second why would an email fail with Invalid address if all the emails are
valid email addresses.
Third, why will that error cause CF server to black out and stop sending
emails (even if after I have manually removed the so called offending email
with Invalid Address)

Thanks
Victor



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325776
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Cfemail issue(s)

[Victor Moore]

Thank you both.
I guess I will have to restart the server which will piss all the people on it.
One would think that Adobe (Allaire, Macromedia) will have a fix for
this by now.

Thx
Victor

On Thu, Aug 27, 2009 at 11:02 AM, Rick Root wrote:
>
> On Thu, Aug 27, 2009 at 10:55 AM, Victor Moore wrote:
>>
>> Is it possible to re-send the emails, short of restarting CF?
>
> I can't answer the other questions, but I don't know of any way to
> kick-start the mail spooler once it dies without restarting
> Coldfusion.
>
> This happens to use often enough where we have a process that monitors
> the spool directories and if it finds files older than a certain time,
> it will send us an alert that CF needs restarting due to a mail spool
> backup.
>
> --
> Rick Root
> CFFM - Open Source Coldfusion File Manager
> http://www.opensourcecf.com/cffm
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325777
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Cfemail issue(s)

[Cutter (ColdFusion)]

One of my co-workers, Andy Matthews, wrote an app for that:

http://undelivrnator.riaforge.org/

Steve "Cutter" Blades
Adobe Certified Professional
Advanced Macromedia ColdFusion MX 7 Developer

Co-Author of "Learning Ext JS"
http://www.packtpub.com/learning-ext-js/book
_
http://blog.cutterscrossing.com


On 8/27/2009 10:02 AM, Rick Root wrote:
> On Thu, Aug 27, 2009 at 10:55 AM, Victor Moore  wrote:
>
>> Is it possible to re-send the emails, short of restarting CF?
>>  
> I can't answer the other questions, but I don't know of any way to
> kick-start the mail spooler once it dies without restarting
> Coldfusion.
>
> This happens to use often enough where we have a process that monitors
> the spool directories and if it finds files older than a certain time,
> it will send us an alert that CF needs restarting due to a mail spool
> backup.
>
>


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325778
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Problem with onblur event

[Dave Watts]

> Likewise with all of those: can anyone provide clear benefits that are more 
> significant
> than jQuery's clear dominance as THE JavaScript library:
> ...
> With other "minority" technologies (like CF), there are clear improvements 
> that make
> them worth using compared to the more popular choices, but that's not 
> something I've
> seen with any of the other JS libraries out there. (Otherwise I'd use them!)

Well, I could waste my time writing a thoughtful response, but someone
else already has:

http://jqueryvsmootools.com/

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!

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325779
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: CFSTOREDPROC kind of sucks

[Tony Bentley]

That is very nice Brad. Thanks for that perspective.





>First of all, it is my preference to explicitly check for an existing
>duplicate value prior to insertion instead of allowing SQL server to
>throw the error.  The column constraint is my fall-back.  
>Either way, if you want your stored procedures to be able to pass back
>useful information about problems or successes it encountered, I would
>recommend using the return code and an @outputMessage output variable.
>
>Your proc can test for the condition and set the output message into an
>output variable and return the desired code.  This way, if the database
>driver provider or DBMS itself ever changes their error codes in a
>future version it won't bork your code.
>
>CREATE PROCEDURE myProc
>@outputMessage varchar(255) OUTPUT,
>@input1 int,
>@input2 int
>
>AS
>BEGIN
>   
>   IF badCondition is true
>   BEGIN
>   SET @outputMessage = 'Here is a detailed and useful error 
> message'
>   RETURN 75 -- Your special "code" for this error
>   END
>
>-- otherwise...
>
>
>   SET @outputMessage = 'Execution Successful'
>   RETURN 0
>
>END
>
>The cfstoredproc tag give you the return code, and you can then check it
>for whatever problems may have occurred.  You can then use the value of
>@outputMessage to return to the user if you so choose.
>
>~Brad
>


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325780
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Cfemail issue(s)

[Victor Moore]

Good point.
I am not. The customer is sending. Now that I know that, I have to
change the process and send in batches.
Unfortunately the code bellow didn't restart the spooler so I had to
restart the server

Thanks
Victor


On Thu, Aug 27, 2009 at 11:06 AM, Mark Kruger wrote:
>
> Victor,
>
> Do you mean you are passing a list of 500 addresses in a single attribute?
> As in:
>
> 
>
> If that is what you are doing  I would not be surprised if there is a buffer
> for that attribute that truncates your string at some point. You would be
> better off looping through your addresses.
>
> Meanwhile you can try restarting the spooler:
>
>  throwontimeout="No">
>    type="JAVA"
>   class="coldfusion.server.ServiceFactory"
>   name="factory">
>
> 
>
> 
>
> 
>
> -Mark
>
>
> Mark A. Kruger, CFG, MCSE
> (402) 408-3733 ext 105
> www.cfwebtools.com
> www.coldfusionmuse.com
> www.necfug.com
>
> -Original Message-
> From: Victor Moore [mailto:victor.mo...@gmail.com]
> Sent: Thursday, August 27, 2009 9:56 AM
> To: cf-talk
> Subject: Cfemail issue(s)
>
>
> Hi all,
>
> I have a couple of issues with cfmail.
> Environment: Windows 2003, CF8.01 ent
>
> The server stopped sending emails
> After checking the logs .I found out that it stopped after complaining that
> one email had "Invalid Address" which is strange because I check all emails
> using isEmail () before sending and I looked at all the emails in the spool
> directory and none have any bad email addresses.The one that CF was
> complaining about had 500 email addresses but all are valid.
> After that, no emails are sent out. They just sit in the spool directory. I
> have tried to move them in and out, play with CF admin mail settings but no
> luck.
> Somehow the original message caused CF server to ignore mail messages in the
> spool directory.
> So my questions are:
>
> Is it possible to re-send the emails, short of restarting CF?
> Second why would an email fail with Invalid address if all the emails are
> valid email addresses.
> Third, why will that error cause CF server to black out and stop sending
> emails (even if after I have manually removed the so called offending email
> with Invalid Address)
>
> Thanks
> Victor
>
>
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325781
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: 500 Error / java.lang.Error: Error starting thread: Not enough storage is available to process this command.

[brad]

I doubt his client vars are in the registry since the stack trace was
trying to create a thread to get a JDBC connection as part of
coldfusion.runtime.AppHelper.setupClientScope.

If your JVM can't create any more threads, have you looked at the
minimum and maximum amounts of memory your JVM heap has assigned to it?
(-Xms and -Xmx settings in your jvm.config file) How much is being used?
 Download a trial of SeeFusion and it will allow you to see exactly how
much memory your JVM is using and will also allow you to run garbage
collection.

If I had to guess, I would say your JVM needs tuning or your application
is being wasteful with memory.  There's also a possibility the problem
lies with your datasource settings for your client storage since the
error was while trying to get a connection to the database.  Do you have
the "Maintain connections across client requests" option selected in
that datasource?

~Brad

 Original Message 
 Subject: Re: 500 Error / java.lang.Error: Error starting thread: Not
 enough storage is available to process this command.
 From: Dave Watts 
 Date: Thu, August 27, 2009 9:50 am
 To: cf-talk 
 
 
 > No body has a single word of advice about what this thread dump
shows? Can
 > some one point me in the right direction? I Googled it to no avail...
 
 It's a fairly generic Windows error. Are you storing client variables
 in the registry?



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325782
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Cfemail issue(s)

[Bryan Stevenson]

On Thu, 2009-08-27 at 11:35 -0400, Victor Moore wrote:
> Good point.
> I am not. The customer is sending. Now that I know that, I have to
> change the process and send in batches.
> Unfortunately the code bellow didn't restart the spooler so I had to
> restart the server
> 
> Thanks
> Victor
> 

YepI'd bet that mail with 500 addresses in it is going to get blocked by 
many SPAM filters

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: br...@electricedgesystems.com
web: www.electricedgesystems.com
 
Notice:
This message, including any attachments, is confidential and may contain
information that is privileged or exempt from disclosure. It is intended
only for the person to whom it is addressed unless expressly authorized
otherwise by the sender. If you are not an authorized recipient, please
notify the sender immediately and permanently destroy all copies of this
message and attachments.




~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325783
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: 500 Error / java.lang.Error: Error starting thread: Not enough storage is available to process this command.

[Brook Davies]

Hi Brad,

Client vars in the database - never in the registry ;)

Thanks for the advise. I have been tuning the JVM heap size for a long time
and at a fairly happy place these days. There were some dark times along the
way though, let me tell you.

Maintain connections is checked and the purge setting is 10 days or so. I've
followed the advise in  this post here:
http://forums.adobe.com/thread/200548

Which recommends adding -Xss256k to decrease the default heap size. This
seems to be helping keep memory usage down (I am checking memory usage via:





)

So, time will tell if this was an effective move.

Brook

-Original Message-
From: b...@bradwood.com [mailto:b...@bradwood.com] 
Sent: August-27-09 8:48 AM
To: cf-talk
Subject: RE: 500 Error / java.lang.Error: Error starting thread: Not enough
storage is available to process this command.


I doubt his client vars are in the registry since the stack trace was
trying to create a thread to get a JDBC connection as part of
coldfusion.runtime.AppHelper.setupClientScope.

If your JVM can't create any more threads, have you looked at the
minimum and maximum amounts of memory your JVM heap has assigned to it?
(-Xms and -Xmx settings in your jvm.config file) How much is being used?
 Download a trial of SeeFusion and it will allow you to see exactly how
much memory your JVM is using and will also allow you to run garbage
collection.

If I had to guess, I would say your JVM needs tuning or your application
is being wasteful with memory.  There's also a possibility the problem
lies with your datasource settings for your client storage since the
error was while trying to get a connection to the database.  Do you have
the "Maintain connections across client requests" option selected in
that datasource?

~Brad

 Original Message 
 Subject: Re: 500 Error / java.lang.Error: Error starting thread: Not
 enough storage is available to process this command.
 From: Dave Watts 
 Date: Thu, August 27, 2009 9:50 am
 To: cf-talk 
 
 
 > No body has a single word of advice about what this thread dump
shows? Can
 > some one point me in the right direction? I Googled it to no avail...
 
 It's a fairly generic Windows error. Are you storing client variables
 in the registry?





~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325784
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: sql deadlock

[brad]

Step 1: read the wiki page John sent.

Step 2: Deadlocks take two resources to tango. You need to see what the
two resources in question are.  Run a trace and filter for deadlocks and
lock escalations.  That will give you some more information about ground
zero at the time of the error.  

Are their other queries in that loop that you omitted for us?

Some deadlocks happen between two processes fighting over to different
tables in your DB, but other deadlocks can be two processes simply
fighting over a number of keys in the same index.  Depending on how many
times that loop runs, a connection can probably rack up a lot of row
locks that wants to escalate to a full table lock, but can't.  

If you are on SQL server, you might try wrapping a transaction around
your loop and playing with the tablockx or holdlock locking hints.  

~Brad

 Original Message 
 Subject: sql deadlock
 From: "Chad Gray" 
 Date: Thu, August 27, 2009 8:46 am
 To: cf-talk 
 
 
 I occasionally see this error in an application I wrote.
 
 Transaction (Process ID 54) was deadlocked on lock | communication
buffer resources with another process and has been chosen as the
deadlock victim. Rerun the transaction.
 
 The code that is causing this is below.
 
 
 
 DELETE FROM #variables.table#
 WHERE #variables.IDField# = #variables.ID# AND ColorName =
'#variables.i#'
 
 
 
 Pretty simple query... How do I keep this SQL from deadlocking?
 
 What is a deadlock? Two users hitting the code at the same time and
database cant handle all the requests?
 


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325785
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

WSDL vs. ODBC

[Billy Cox]

Has anyone here had a chance to evaluate system performance and 
reliability of WSDL versus ODBC?

-Billy Cox



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325786
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Using CFReport in a Websphere (linux) environment

[Dave Phillips]

Hi all,

I'm trying to create a simple report with CFReport (CF 8) and am getting the
following error:

 

Error 500: Could not find class: com.gp.java2d.ExHeadlessGraphicsEnvironment

 

Can anyone give me any direction on how to solve this problem?  I've tried
CFREPORT with type=PDF or type=FlashPaper and get it with both of them.

 

I've confirmed that the report works fine on my local windows development
machine, so there is nothing wrong with the report file or the CFM file.

 

Thanks!

 

Dave Phillips

 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325787
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: WSDL vs. ODBC

[John M Bliss]

http://en.wikipedia.org/wiki/Web_Services_Description_Language versus
http://en.wikipedia.org/wiki/Open_Database_Connectivity ?  In what context
are you comparing those two?

On Thu, Aug 27, 2009 at 11:40 AM, Billy Cox wrote:

>
> Has anyone here had a chance to evaluate system performance and
> reliability of WSDL versus ODBC?
>
> -Billy Cox
>
>
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325788
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: WSDL vs. ODBC

[Dave Watts]

> Has anyone here had a chance to evaluate system performance and
> reliability of WSDL versus ODBC?

That question doesn't make sense.

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!

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325789
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: WSDL vs. ODBC

[Bryan Stevenson]

On Thu, 2009-08-27 at 12:46 -0400, Dave Watts wrote:
> > Has anyone here had a chance to evaluate system performance and
> > reliability of WSDL versus ODBC?
> 
> That question doesn't make sense.
> 
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> 

Yepat first I thought it was because I've just quit coffeebut noit 
really doesn't make sense ;-)

I suppose it could be about getting data into remote databases.  You could have 
an ODBC (or JDBC) datasource pointing to the remote DB or you could 
access/alter data in it via webservices??

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: br...@electricedgesystems.com
web: www.electricedgesystems.com
 
Notice:
This message, including any attachments, is confidential and may contain
information that is privileged or exempt from disclosure. It is intended
only for the person to whom it is addressed unless expressly authorized
otherwise by the sender. If you are not an authorized recipient, please
notify the sender immediately and permanently destroy all copies of this
message and attachments.



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

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325790
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Cfemail issue(s)

[Rick Root]

On Thu, Aug 27, 2009 at 11:07 AM, Cutter
(ColdFusion) wrote:
>
> One of my co-workers, Andy Matthews, wrote an app for that:
>
> http://undelivrnator.riaforge.org/

This isn't an issue of respooling undeliverable email.

It's a matter of noticing that the SPOOL directory is not being processed.

-- 
Rick Root
CFFM - Open Source Coldfusion File Manager
http://www.opensourcecf.com/cffm

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325791
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: WSDL vs. ODBC

[Azadi Saryev]

a quick evaluation showed that apples perform better, while oranges are
more reliable.
:)

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/


On 28/08/2009 00:40, Billy Cox wrote:
> Has anyone here had a chance to evaluate system performance and 
> reliability of WSDL versus ODBC?
>
> -Billy Cox
>
>
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325792
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: WSDL vs. ODBC

[Rick Root]

On Thu, Aug 27, 2009 at 12:40 PM, Billy Cox wrote:
>
> Has anyone here had a chance to evaluate system performance and
> reliability of WSDL versus ODBC?

Um... ODBC is faster.

(?)

-- 
Rick Root
CFFM - Open Source Coldfusion File Manager
http://www.opensourcecf.com/cffm

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325793
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: WSDL vs. ODBC

[Scott Stroz]

Yes, but you can make a quasi-word out of WSDL.

On Thu, Aug 27, 2009 at 12:55 PM, Rick Root wrote:
>
> On Thu, Aug 27, 2009 at 12:40 PM, Billy Cox wrote:
>>
>> Has anyone here had a chance to evaluate system performance and
>> reliability of WSDL versus ODBC?
>
> Um... ODBC is faster.
>
> (?)
>
> --
> Rick Root
> CFFM - Open Source Coldfusion File Manager
> http://www.opensourcecf.com/cffm
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325794
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: WSDL vs. ODBC

[Rick Root]

On Thu, Aug 27, 2009 at 12:59 PM, Scott Stroz wrote:
>
> Yes, but you can make a quasi-word out of WSDL.

Only if you're in one of those countries that has outlawed vowels.

-- 
Rick Root
CFFM - Open Source Coldfusion File Manager
http://www.opensourcecf.com/cffm

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325795
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: WSDL vs. ODBC

[Casey Dougall]

On Thu, Aug 27, 2009 at 1:02 PM, Rick Root wrote:

>
> On Thu, Aug 27, 2009 at 12:59 PM, Scott Stroz wrote:
> >
> > Yes, but you can make a quasi-word out of WSDL.
>
> Only if you're in one of those countries that has outlawed vowels.
>

LMFAO!


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325796
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: WSDL vs. ODBC

[Dave Sueltenfuss]

I think it would be more like comparing apples to a book

On Thu, Aug 27, 2009 at 12:52 PM, Azadi Saryev  wrote:

>
> a quick evaluation showed that apples perform better, while oranges are
> more reliable.
> :)
>
> Azadi Saryev
> Sabai-dee.com
> http://www.sabai-dee.com/
>
>
> On 28/08/2009 00:40, Billy Cox wrote:
> > Has anyone here had a chance to evaluate system performance and
> > reliability of WSDL versus ODBC?
> >
> > -Billy Cox
> >
> >
> >
> >
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325797
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Cfemail issue(s)

[Victor Moore]

True.
I had a resend email scheduler job already implemented.
I end up sending in batches. 200 emails at one time.

It seems it's working fine. Is there a upper limit that I should be aware?

Thanks
Victor

On Thu, Aug 27, 2009 at 12:52 PM, Rick Root wrote:
>
> On Thu, Aug 27, 2009 at 11:07 AM, Cutter
> (ColdFusion) wrote:
>>
>> One of my co-workers, Andy Matthews, wrote an app for that:
>>
>> http://undelivrnator.riaforge.org/
>
> This isn't an issue of respooling undeliverable email.
>
> It's a matter of noticing that the SPOOL directory is not being processed.
>
> --
> Rick Root
> CFFM - Open Source Coldfusion File Manager
> http://www.opensourcecf.com/cffm
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325798
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 CFReport in a Websphere (linux) environment

[brad]

You always find the weird ones Dave.  :)

I don't have an answer, but it appears you aren't the first with the
problem:
http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:29706

You could try Barney's suggestion of installing X11, or perhaps you can
get a hold of Dave Carabetta and see how he fixed his problem.
http://www.cbetta.com

I assume your Linux install is running headless?

~Brad

 Original Message 
 Subject: Using CFReport in a Websphere (linux) environment
 From: Dave Phillips 
 Date: Thu, August 27, 2009 11:40 am
 To: cf-talk 
 
 
 Hi all,
 
 I'm trying to create a simple report with CFReport (CF 8) and am
getting the
 following error:
 Error 500: Could not find class:
com.gp.java2d.ExHeadlessGraphicsEnvironment



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325799
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: WSDL vs. ODBC

[Billy Cox]

It would be in the context of syncing a local app server with a cloud 
system like salesforce.com or netsuite.


John M Bliss wrote:
> http://en.wikipedia.org/wiki/Web_Services_Description_Language versus
> http://en.wikipedia.org/wiki/Open_Database_Connectivity ?  In what context
> are you comparing those two?
>
> On Thu, Aug 27, 2009 at 11:40 AM, Billy Cox wrote:
>
>   
>> Has anyone here had a chance to evaluate system performance and
>> reliability of WSDL versus ODBC?
>>
>> -Billy Cox
>>
>>
>>
>>
>> 
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325800
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: WSDL vs. ODBC

[John M Bliss]

I'm still not sure I understand but, ignoring that for a sec, have you
determined that salesforce.com / netsuite offer API's that'd allow you to
"touch" their systems via WSDL and ODBC?  If so, I'd ask salesforce.com /
netsuite which is faster.

Typically, WSDL / webservices are good for touching "cloud systems."

Typically (at least, in my experience), ODBC is not available for touching
"cloud systems."  That is, "cloud systems" don't allow you to touch them via
ODBC.  But I suppose it's possible...?


On Thu, Aug 27, 2009 at 1:50 PM, Billy Cox  wrote:

>
> It would be in the context of syncing a local app server with a cloud
> system like salesforce.com or netsuite.
>
>
> John M Bliss wrote:
> > http://en.wikipedia.org/wiki/Web_Services_Description_Language versus
> > http://en.wikipedia.org/wiki/Open_Database_Connectivity ?  In what
> context
> > are you comparing those two?
> >
> > On Thu, Aug 27, 2009 at 11:40 AM, Billy Cox  >wrote:
> >
> >
> >> Has anyone here had a chance to evaluate system performance and
> >> reliability of WSDL versus ODBC?
> >>
> >> -Billy Cox
> >>
> >>
> >>
> >>
> >>
> >
> >
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325801
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: WSDL vs. ODBC

[Dave Watts]

> It would be in the context of syncing a local app server with a cloud
> system like salesforce.com or netsuite.

I don't think that asking about system performance is an especially
good idea for getting your questions answered. In general, JDBC
expects direct network connections, open database sockets, etc. You
probably won't be able to make that happen in a cloud environment.
SOAP is a good alternative in that kind of environment, since you can
typically use SOAP over HTTP, which is generally already open. WSDL is
just a way to publish SOAP interfaces.

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!

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325802
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: WSDL vs. ODBC

[John M Bliss]

"I see," said the blind man as he picked up his hammer and saw!  :-)

Good web services will be slower and less reliable than good ODBC.  Having
said that, there're many, many things you can do to make web services
fast/reliable "enough" and, obviously, the cloud has lots of other
advantages...

On Thu, Aug 27, 2009 at 2:11 PM, Billy Cox  wrote:

>
> Salesforce and Netsuite both have a web services API. I am trying to
> gauge impacts involved with switching from a system that uses ODBC to a
> cloud based system.  If a web service is faster and/or more reliable
> than ODBC, then that helps me to make a case for the cloud.
>
> John M Bliss wrote:
> > I'm still not sure I understand but, ignoring that for a sec, have you
> > determined that salesforce.com / netsuite offer API's that'd allow you
> to
> > "touch" their systems via WSDL and ODBC?  If so, I'd ask salesforce.com/
> > netsuite which is faster.
> >
> > Typically, WSDL / webservices are good for touching "cloud systems."
> >
> > Typically (at least, in my experience), ODBC is not available for
> touching
> > "cloud systems."  That is, "cloud systems" don't allow you to touch them
> via
> > ODBC.  But I suppose it's possible...?
> >
> >
> > On Thu, Aug 27, 2009 at 1:50 PM, Billy Cox 
> wrote:
> >
> >
> >> It would be in the context of syncing a local app server with a cloud
> >> system like salesforce.com or netsuite.
> >>
> >>
> >> John M Bliss wrote:
> >>
> >>> http://en.wikipedia.org/wiki/Web_Services_Description_Language versus
> >>> http://en.wikipedia.org/wiki/Open_Database_Connectivity ?  In what
> >>>
> >> context
> >>
> >>> are you comparing those two?
> >>>
> >>> On Thu, Aug 27, 2009 at 11:40 AM, Billy Cox  >>> wrote:
> >>>
> >>>
> >>>
>  Has anyone here had a chance to evaluate system performance and
>  reliability of WSDL versus ODBC?
> 
>  -Billy Cox
> 
> 
> 
> 
> 
> 
> >>>
> >>
> >
> >
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325805
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: WSDL vs. ODBC

[Dave Watts]

> Salesforce and Netsuite both have a web services API. I am trying to
> gauge impacts involved with switching from a system that uses ODBC to a
> cloud based system.  If a web service is faster and/or more reliable
> than ODBC, then that helps me to make a case for the cloud.

I doubt it'll be either. Web services are an abstraction layer between
applications and databases. However, hosting your databases in the
cloud may make those databases more reliable.

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

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325806
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: WSDL vs. ODBC

[Adam Haskell]

It will be slower, reliability will also be lower when compared to ODBC if
that is all behind the firewall. Security is also a lot harder with
SOAP/WSDL and much more varied.


Adam


On Thu, Aug 27, 2009 at 3:11 PM, Billy Cox  wrote:

>
> Salesforce and Netsuite both have a web services API. I am trying to
> gauge impacts involved with switching from a system that uses ODBC to a
> cloud based system.  If a web service is faster and/or more reliable
> than ODBC, then that helps me to make a case for the cloud.
>
> John M Bliss wrote:
> > I'm still not sure I understand but, ignoring that for a sec, have you
> > determined that salesforce.com / netsuite offer API's that'd allow you
> to
> > "touch" their systems via WSDL and ODBC?  If so, I'd ask salesforce.com/
> > netsuite which is faster.
> >
> > Typically, WSDL / webservices are good for touching "cloud systems."
> >
> > Typically (at least, in my experience), ODBC is not available for
> touching
> > "cloud systems."  That is, "cloud systems" don't allow you to touch them
> via
> > ODBC.  But I suppose it's possible...?
> >
> >
> > On Thu, Aug 27, 2009 at 1:50 PM, Billy Cox 
> wrote:
> >
> >
> >> It would be in the context of syncing a local app server with a cloud
> >> system like salesforce.com or netsuite.
> >>
> >>
> >> John M Bliss wrote:
> >>
> >>> http://en.wikipedia.org/wiki/Web_Services_Description_Language versus
> >>> http://en.wikipedia.org/wiki/Open_Database_Connectivity ?  In what
> >>>
> >> context
> >>
> >>> are you comparing those two?
> >>>
> >>> On Thu, Aug 27, 2009 at 11:40 AM, Billy Cox  >>> wrote:
> >>>
> >>>
> >>>
>  Has anyone here had a chance to evaluate system performance and
>  reliability of WSDL versus ODBC?
> 
>  -Billy Cox
> 
> 
> 
> 
> 
> 
> >>>
> >>
> >
> >
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325807
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: WSDL vs. ODBC

[Adam Haskell]

They may be up more often but you have more network hops and more breaking
points. If you put your Database outside the internal network, I think net
result would be a less reliable RDBMS

Adam


On Thu, Aug 27, 2009 at 3:17 PM, Dave Watts  wrote:

>
> > Salesforce and Netsuite both have a web services API. I am trying to
> > gauge impacts involved with switching from a system that uses ODBC to a
> > cloud based system.  If a web service is faster and/or more reliable
> > than ODBC, then that helps me to make a case for the cloud.
>
> I doubt it'll be either. Web services are an abstraction layer between
> applications and databases. However, hosting your databases in the
> cloud may make those databases more reliable.
>
> 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
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325808
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: WSDL vs. ODBC

[Alan Rother]

I'll be darned..
DataDirect
OpenAccess *for* ODBC for Salesforce Data Source
http://www.datadirect.com/products/openaccess-sf/index.ssp



-- 
Alan Rother
Adobe Certified Advanced ColdFusion MX 7 Developer
Manager, Phoenix Cold Fusion User Group, AZCFUG.org


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325809
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: WSDL vs. ODBC

[John M Bliss]

I too will be darned.  :-)  Wonder how much that costs...

On Thu, Aug 27, 2009 at 2:24 PM, Alan Rother  wrote:

>
> I'll be darned..
> DataDirect
> OpenAccess *for* ODBC for Salesforce Data Source
> http://www.datadirect.com/products/openaccess-sf/index.ssp
>
>
>
> --
> Alan Rother
> Adobe Certified Advanced ColdFusion MX 7 Developer
> Manager, Phoenix Cold Fusion User Group, AZCFUG.org
>
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325810
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: WSDL vs. ODBC

[Billy Cox]

Salesforce and Netsuite both have a web services API. I am trying to 
gauge impacts involved with switching from a system that uses ODBC to a 
cloud based system.  If a web service is faster and/or more reliable 
than ODBC, then that helps me to make a case for the cloud.

John M Bliss wrote:
> I'm still not sure I understand but, ignoring that for a sec, have you
> determined that salesforce.com / netsuite offer API's that'd allow you to
> "touch" their systems via WSDL and ODBC?  If so, I'd ask salesforce.com /
> netsuite which is faster.
>
> Typically, WSDL / webservices are good for touching "cloud systems."
>
> Typically (at least, in my experience), ODBC is not available for touching
> "cloud systems."  That is, "cloud systems" don't allow you to touch them via
> ODBC.  But I suppose it's possible...?
>
>
> On Thu, Aug 27, 2009 at 1:50 PM, Billy Cox  wrote:
>
>   
>> It would be in the context of syncing a local app server with a cloud
>> system like salesforce.com or netsuite.
>>
>>
>> John M Bliss wrote:
>> 
>>> http://en.wikipedia.org/wiki/Web_Services_Description_Language versus
>>> http://en.wikipedia.org/wiki/Open_Database_Connectivity ?  In what
>>>   
>> context
>> 
>>> are you comparing those two?
>>>
>>> On Thu, Aug 27, 2009 at 11:40 AM, Billy Cox >> wrote:
>>>
>>>
>>>   
 Has anyone here had a chance to evaluate system performance and
 reliability of WSDL versus ODBC?

 -Billy Cox





 
>>>   
>> 
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325804
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: WSDL vs. ODBC

[Rick Root]

If you are accessing a database on a remote server, and you have two
options, one of them being web service calls, and the other being
ODBC, I don't think there's any doubt that the ODBC route would
probably be faster.

But it does seem extremely unlikely that any remote service, such as
salesforce, would allow ODBC access to their system.

Rick

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325803
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Session Based Recently Viewed Items...

[Che Vilnonis]

What would be the simplest way (using session vars), to keep track of up to
four "Recently Viewed Items" on an e-commerce site? Once the 5th item is
viewed, the 1st item is removed and so on?

I have some code that works... but I think I've overcomplicated things. Any
opinions?

Thanks, Che




~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325811
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: WSDL vs. ODBC

[Jason Fisher]

My guess is that they're staging data calls and still routing through their 
API objects to handle authentication / validation and all the other 
business logic they have in place in their API model.
 


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325812
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Session Based Recently Viewed Items...

[John M Bliss]

Howabout something like...?











On Thu, Aug 27, 2009 at 3:51 PM, Che Vilnonis  wrote:

>
> What would be the simplest way (using session vars), to keep track of up to
> four "Recently Viewed Items" on an e-commerce site? Once the 5th item is
> viewed, the 1st item is removed and so on?
>
> I have some code that works... but I think I've overcomplicated things. Any
> opinions?
>
> Thanks, Che
>
>
>
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325813
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: WSDL vs. ODBC

[Alan Rother]

>>>My guess is that they're staging data calls and still routing through
their
>>>API objects to handle authentication / validation and all the other
>>>business logic they have in place in their API model.
That does seem to be what they are doing, you enter a SQL command, it
translates it and spits out a WebService call then returns a clean query.
Great idea anyhow..
The ODBC connector wouldn't likely make the connection any faster but it
sure could help speed up development time drastically...

-- 
Alan Rother
Adobe Certified Advanced ColdFusion MX 7 Developer
Manager, Phoenix Cold Fusion User Group, AZCFUG.org


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325814
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Session Based Recently Viewed Items...

[Che Vilnonis]

listRest EQ more elegant solution than mine. Thanks, John! 

-Original Message-
From: John M Bliss [mailto:bliss.j...@gmail.com] 
Sent: Thursday, August 27, 2009 5:01 PM
To: cf-talk
Subject: Re: Session Based Recently Viewed Items...


Howabout something like...?






 






~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325815
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

How to make ODBC Connection to Access DB with MDW Connection

[Jeanmarie Richardson]

Hi --
I need to make an ODBC connection to an access database that utilizes an MBW 
file for security.  How can this be done?  Could I use a connection string?  Or 
does the ODBC manager allow this.

Thanks in advance! 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325816
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4