RE: CF Mail Queue

2011-08-30 Thread Jenny Gavin-Wear

Many thanks Joachem, good info.

Jenny

-Original Message-
From: Jochem van Dieten [mailto:joch...@gmail.com]
Sent: 29 August 2011 14:47
To: cf-talk
Subject: Re: CF Mail Queue



On Fri, Aug 26, 2011 at 1:42 PM, Jenny Gavin-Wear wrote:
 For some reason a mail item causes an error and then holds up the entire
 mail spool.  All the mail.log shows is Error.

 Is there somewhere I can get further error details so I can prevent this
 happening?

You could try to verify in your mailserver logfile if this problem
occurs before sending (corrupt message) or after sending (problem
during delete due to permissions / lock by virusscanner etc.). If this
happens again in a few years, try to remember to make a tread dump of
the CF server and see if any application is holding a lock on the
file.

Jochem


--
Jochem van Dieten
http://jochem.vandieten.net/



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347118
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: google map suddenly not showing

2011-08-30 Thread Jenny Gavin-Wear

Didn't CFMAP come with CF9?

Jenny 



-Original Message-
From: Akos Fortagh [mailto:akos.fort...@yahoo.com]
Sent: 29 August 2011 17:05
To: cf-talk
Subject: Re: google map suddenly not showing



thank you for all your suggestions folks, like I mentioned this 
was developed before the time of CFMAP on CF 7, anyway I found 
out what the problem was.



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347119
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: google map suddenly not showing

2011-08-30 Thread Raymond Camden

I think he meant, developer on cf7, before the time of cfmap, and
yea, it was cf9.

On Tue, Aug 30, 2011 at 4:10 AM, Jenny Gavin-Wear
jenn...@fasttrackonline.co.uk wrote:

 Didn't CFMAP come with CF9?

 Jenny




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347120
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


dynamic hyperlink creations with CFSPREADSHEET

2011-08-30 Thread rick pelletier

anyone successfully created dynamic hyperlinks via cfspreadsheet?

via this methodology:
http://www.techonthenet.com/excel/formulas/hyperlink.php

i want to create cells that have an Item ID that links to the corresponding URL 
on the website, so each row has its own Item ID:

what displays in the cell: 1234
and links to: http://www.mysite.com/prodID/1234

i kick out the spreadsheet and open the excel file only to see each cell 
displaying the function as text:
=HYPERLINK(http://www.mysites.com/prodID/1,1;)

any help/ideas/advice? thanks in advance. 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347121
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: dynamic hyperlink creations with CFSPREADSHEET

2011-08-30 Thread Leigh

 =HYPERLINK(http://www.mysites.com/prodID/1,1;)

It should work fine. Are you using SpreadSheetSetCellFormula()? 

-Leigh

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347122
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Best thing for testing code?

2011-08-30 Thread Eric Cobb

We are wanting to put some type of testing system in place here at
work.  I know there's a ton of stuff out there, and I'm really at a loss
as to where to start.  I'm not sure if any of the TDD
frameworks are what we're after or not.  Our main concern right now is
setting up something to help test our existing applications.  Here's a
scenario of something we would be wanting to test:

We have an automated process that checks for new orders that came in from 
our
website.  This process takes an order and checks each of the items in
that order to see if we have it in stock or need to check 3rd party
vendors.  If it needs to check the vendors, it begins going through a
list of venders and hitting their APIs to see if they have the item.  In
certain cases we may want to skip vendor 1 and order directly from
vendor 2, or always order from vendor 3 without even looking at the others. 
 Once it finds the item it then instructs our system to place
the order for the item with that vendor, and then it moves the order
over to our accounting system.

We're not just concerned with whether or not the CFCs work, we need to
know that the correct vendor was selected for the correct item, the
database records were updated with the correct values, we don't
accidentally place the same order with 2 vendors, etc...  

All that to say, what would be a good testing system to use with
something like that? I'm open to any and all suggestions, even if it's
something we have to purchase.  

Thanks,

Eric Cobb
http://www.cfgears.com



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347123
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


multiple apps on a single server

2011-08-30 Thread Greg Morphis

We have a CF/IIS7.5 server running an app, our main app. The wwwroot
is full of folders related to our main app.
If we want to add another app what's the best way to do this? Moving
everything to a subdirectory and making a couple subdirectories
(wwwroot/mainapp and wwwroot/newapp) isn't feasible.

Thanks!

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347124
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: multiple apps on a single server

2011-08-30 Thread Greg Morphis

Also, we're not running CF with Jrun.. just FYI

On Tue, Aug 30, 2011 at 11:27 AM, Greg Morphis gmorp...@gmail.com wrote:
 We have a CF/IIS7.5 server running an app, our main app. The wwwroot
 is full of folders related to our main app.
 If we want to add another app what's the best way to do this? Moving
 everything to a subdirectory and making a couple subdirectories
 (wwwroot/mainapp and wwwroot/newapp) isn't feasible.

 Thanks!


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347125
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: multiple apps on a single server

2011-08-30 Thread Dave Watts

 We have a CF/IIS7.5 server running an app, our main app. The wwwroot
 is full of folders related to our main app.
 If we want to add another app what's the best way to do this? Moving
 everything to a subdirectory and making a couple subdirectories
 (wwwroot/mainapp and wwwroot/newapp) isn't feasible.

If this app will have a distinct hostname, create a directory parallel
to wwwroot and put it in there, and create a new web site in IIS. If
the app won't have a distinct hostname, create a directory somewhere
outside of wwwroot and create a new virtual directory in IIS.

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

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsite.

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347126
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: multiple apps on a single server

2011-08-30 Thread Greg Morphis

So simply create another directory wwwroot2 (for example) in
c:\inetpub, should it have the same CFIDE, cfdocs, WEB-INF, etc
folders?
And create the site in IIS?

Thanks Dave!

On Tue, Aug 30, 2011 at 11:30 AM, Dave Watts dwa...@figleaf.com wrote:

 We have a CF/IIS7.5 server running an app, our main app. The wwwroot
 is full of folders related to our main app.
 If we want to add another app what's the best way to do this? Moving
 everything to a subdirectory and making a couple subdirectories
 (wwwroot/mainapp and wwwroot/newapp) isn't feasible.

 If this app will have a distinct hostname, create a directory parallel
 to wwwroot and put it in there, and create a new web site in IIS. If
 the app won't have a distinct hostname, create a directory somewhere
 outside of wwwroot and create a new virtual directory in IIS.

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

 Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
 GSA Schedule, and provides the highest caliber vendor-authorized
 instruction at our training centers, online, or onsite.

 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347127
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: multiple apps on a single server

2011-08-30 Thread Dave Watts

 So simply create another directory wwwroot2 (for example) in
 c:\inetpub, should it have the same CFIDE, cfdocs, WEB-INF, etc
 folders?

Well, not necessarily. You may need parts (not all, just the public
parts) of CFIDE. You won't need CFDOCS at all. You won't need WEB-INF
unless you deploy a separate J2EE application to this site (which in
CF terms would be a separate service).

 And create the site in IIS?

Yes, exactly.

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

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsite.

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347128
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: multiple apps on a single server

2011-08-30 Thread Russ Michaels

you do not need to use the c:\inetpub\wwwroot, this is just where windows
stores the default website.
Thus anything you put in here will also be accessible via the default
website, so bear that in mind.

Usually you would put each site in a subdirectory
E.G.

c:\inetpub\wwwroot\site1.com\wwwroot
c:\inetpub\wwwroot\site2.com\wwwroot

but you can put your sites anywhere, so if you have multiple drives, then
why not stick your sites there.

d:\wwwroot\site1.com\wwwroot
d:\wwwroot\site2.com\wwwroot

You should also bear in mind that if you are just creating sites and using
default permissions, then any other CGI based scripting you may be using
such as PHP or ASP will have full read/execute and maybe write access on
every site. You need to run every site under its own user context to avoid
this and give that user permissions only on his own folder.
When managing multiple sites you are better off using a hosting control
panel to do this as it handles all that for you.
With CF this does not count as CFML pages run under the context of the
ColdFusion service (system by default) so permissions are controlled by your
security sandboxes in the cfadmin.


--

Russ Michaels

www.bluethunderinternet.com  : Business hosting services  solutions
www.cfmldeveloper.com: ColdFusion developer community
www.michaels.me.uk   : my blog
www.cfsearch.com : ColdFusion search engine
**
*skype me* : russmichaels


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347129
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Best thing for testing code?

2011-08-30 Thread Russ Michaels

there are several cf unit testing solutions available.

http://mxunit.org/
http://www.cfcunit.org/cfcunit/
http://cfunit.sourceforge.net/

You can use these not only to test that everything is working, but also to
test the data being returned is correct as you require.

--

Russ Michaels

www.bluethunderinternet.com  : Business hosting services  solutions
www.cfmldeveloper.com: ColdFusion developer community
www.michaels.me.uk   : my blog
www.cfsearch.com : ColdFusion search engine
**
*skype me* : russmichaels


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347130
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Best thing for testing code?

2011-08-30 Thread sm...@ibsys.com sm...@ibsys.com

I'm replying via the website, since I don't subscribe to the feed, and I've 
never been sure if this gets sent out to the list via email or not, but anyway, 
I found your question very interesting.

In your question, you're saying, We have this business process.  We have this 
software, which is supposed to implement the business process.  But, I don't 
trust that it does, so how can I verify that it is.

The statement, We're not just concerned with whether or not the CFCs work... 
is wrong.  If you don't trust your software to properly implement your business 
process, then you don't believe that your software WORKS.  Sure, it might not 
have any compile-time errors, or even any runtime errors, but does a 
calculator that sometimes returns 22 for 2+2 WORK?

Software is deterministic.  It only does what you program it to do.  You should 
be able to be sure about whether individual chunks of code WORK.  When you've 
done that for most of the chunks of code, you can be pretty sure the whole 
thing works.

So, what you're really looking for are, at the bare minimum, unit tests.

You mentioned TDD, but that's a methodology for developing software where you 
write your test first, then develop the solution to fulfill the test.

That doesn't mean you still can't use unit tests on already completed software.

If you have a function that is, based on certain input, supposed to provide 
certain output, then you can write a test for it.  You write a test for good 
input, you write a test for bad input, etc.  Once you're sure that function 
works, you move on to the next one.

It may seem like a daunting task, but if you do a little bit at a time, its 
doable.  And, the feeling you get when you've got some relatively solid test 
coverage is amazing.  You no longer fear making changes.

So, I've been out of the CF world for a bit, but I found MXUnit to be the 
standout test framework for CF.  I used ColdMock for creating mock CFCs 
(something you'll discover you'll need as you start writing tests).

Start by getting that working and writing a test for one of your functions in 
one of your CFCs.

If you find that you can't write tests for that function - its generally an 
indicator that the function is not well designed.  Its doing too much, etc.

You're going to write several tests for each function.  You're going to have, 
in the end, thousands of tests, but, when you're done, you'll be a lot closer 
to actually trusting your software to work properly.  Your software will also 
be much better in the end, because over the course of refactoring it to be 
actually testable, it will be cleaner, more maintainable, and most likely 
better performing..

We are wanting to put some type of testing system in place here at
work.  I know there's a ton of stuff out there, and I'm really at a loss
as to where to start.  I'm not sure if any of the TDD
frameworks are what we're after or not.  Our main concern right now is
setting up something to help test our existing applications.  Here's a
scenario of something we would be wanting to test:

We have an automated process that checks for new orders that came in from 
our
website.  This process takes an order and checks each of the items in
that order to see if we have it in stock or need to check 3rd party
vendors.  If it needs to check the vendors, it begins going through a
list of venders and hitting their APIs to see if they have the item.  In
certain cases we may want to skip vendor 1 and order directly from
vendor 2, or always order from vendor 3 without even looking at the others. 
 Once it finds the item it then instructs our system to place
the order for the item with that vendor, and then it moves the order
over to our accounting system.

We're not just concerned with whether or not the CFCs work, we need to
know that the correct vendor was selected for the correct item, the
database records were updated with the correct values, we don't
accidentally place the same order with 2 vendors, etc...  

All that to say, what would be a good testing system to use with
something like that? I'm open to any and all suggestions, even if it's
something we have to purchase.  

Thanks,

Eric Cobb
http://www.cfgears.com 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347131
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: multiple apps on a single server

2011-08-30 Thread Greg Morphis

Thanks guys! I appreciate the information!

On Tue, Aug 30, 2011 at 11:50 AM, Russ Michaels r...@michaels.me.uk wrote:

 you do not need to use the c:\inetpub\wwwroot, this is just where windows
 stores the default website.
 Thus anything you put in here will also be accessible via the default
 website, so bear that in mind.

 Usually you would put each site in a subdirectory
 E.G.

 c:\inetpub\wwwroot\site1.com\wwwroot
 c:\inetpub\wwwroot\site2.com\wwwroot

 but you can put your sites anywhere, so if you have multiple drives, then
 why not stick your sites there.

 d:\wwwroot\site1.com\wwwroot
 d:\wwwroot\site2.com\wwwroot

 You should also bear in mind that if you are just creating sites and using
 default permissions, then any other CGI based scripting you may be using
 such as PHP or ASP will have full read/execute and maybe write access on
 every site. You need to run every site under its own user context to avoid
 this and give that user permissions only on his own folder.
 When managing multiple sites you are better off using a hosting control
 panel to do this as it handles all that for you.
 With CF this does not count as CFML pages run under the context of the
 ColdFusion service (system by default) so permissions are controlled by your
 security sandboxes in the cfadmin.


 --

 Russ Michaels

 www.bluethunderinternet.com  : Business hosting services  solutions
 www.cfmldeveloper.com        : ColdFusion developer community
 www.michaels.me.uk           : my blog
 www.cfsearch.com             : ColdFusion search engine
 **
 *skype me*                     : russmichaels


 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347132
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: dynamic hyperlink creations with CFSPREADSHEET

2011-08-30 Thread rick pelletier

thanks for the reply Leigh. No i'm not. Could be the source of my problem? This 
is my first go using CFSPREADSHEET as a converter from CFX_EXCEL. 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347133
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: CFFORM or Jquery Form Validation

2011-08-30 Thread Al Musella, DPM

Note that even if you used my example (which you are welcome to use 
of course), you still need to confirm it on the server side when the 
form is submitted.. some people turn off javascript, and others will 
play around with tools like fiddler to mess you up:)
Best way is to use both - check on the client side to make it easier 
for the user and check on the server to make sure you have what you need,


At 03:06 PM 8/29/2011, you wrote:

Al,
Now that's what I call perfection.

Thank you very much and I am not going to copy your code as I already
finished Sunday
My old school method. I too am not great with javascript or jquery, but am
starting to try getting into it
So I don't get left completely behind.
I have no use for frameworks at this time so the method you provided is just
perfect and I can get me old head around it.

Terry

-Original Message-
From: Al Musella, DPM [mailto:muse...@virtualtrials.com]
Sent: Monday, August 29, 2011 10:22 AM
To: cf-talk
Subject: RE: CFFORM or Jquery Form Validation


Terry,
I see nobody gave a simple example.. here is one:
http://virtualtrials.com/testjquery.cfmhttp://virtualtrials.com/testjquery
.cfm

view page source to see how it works.
Try submitting it first with nothing entered, then with something in
one of the fields
I am not great with javascript or jquery but it works:)
I stripped out everything unneeded.
You can also easily do it without jquery just using javascript... but
the jquery syntax is easier to remember.

Al



At 11:10 PM 8/28/2011, you wrote:

 Cameron,
 I did as you said and downloaded the framework.
 I read the quick start and the pdf and it is way over this guy's head.
 I ended up using cfform and checkboxes which passed the list onto the next
 page
 To a loop which then displayed the text input for which ever the user
 checked off.
 Works fine and is old school yes, but I am not yet into frameworks as you
 obviously
 Are, but I did learn something today. I am a 70 year old guy who loves all
 this stuff
 And do not want to just have something given to me to copy their work, but
 instead to
 See a working example to learn from. I did learn that grouping fields is an
 option
 I hadn't thought about and am going to go deeper into that.
 
 Thank you very much for your input, just try and remember an example is
just
 that,
 Something to learn by.
 
 Terry
 
 -Original Message-
 From: Cameron Childress [mailto:camer...@gmail.com]
 Sent: Sunday, August 28, 2011 2:51 PM
 To: cf-talk
 Subject: Re: CFFORM or Jquery Form Validation
 
 
 
 There are many many examples available for ValidateThis.  You'd asked for
 more than one.  The download contains a whole bunch. If you meant what you
 said when you claimed you want learn something new today, I would look at
 ValidateThis.
 
 If instead, you want someone to link to a solution for you so you can
 cut/paste code to solve your exact problem, someone else will surely
provide
 it shortly.
 
 
 
 
 





~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347134
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: dynamic hyperlink creations with CFSPREADSHEET

2011-08-30 Thread Leigh

 No i'm not. Could be the source
 of my problem? 

Yep. Otherwise it will not be evaluated and you will end up with plain text. 
Other than removing the leading =. The syntax should be the same. Something 
like

SpreadsheetSetCellFormula(sheet, 
'HYPERLINK(http://www.mysites.com/prodID/1;, 1234)'
, 1 , 1); 

http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-6732.html


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347135
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Mac 10.7 datasource problem

2011-08-30 Thread Joe Brislin

 Since I upgraded to lion, my sql server datasource has stopped working. 
 The error message i'm getting is:
 java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer 
 JDBC Driver]No more data available to read.
 
 Anyone know anything about this? 

Did you ever get this issue resolved? I'm having the exact same issue and my 
firewall is turned off so it can't be that.

Joe Brislin 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347136
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Bulk image upload and in-browser cropping?!?

2011-08-30 Thread David McGuigan

Anyone built anything that lets you select multiple image files from a web
browser for upload ( as well as folders ) like Facebook has?

How about anything that lets you do in-browser image cropping?

I can probably fire up Flash and develop the 2nd part myself, but I'm hoping
there's something out there that I can just plug in and use particularly
smoothly with ColdFusion.

Thanks.


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347137
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Bulk image upload and in-browser cropping?!?

2011-08-30 Thread Gerald Guido

 How about anything that lets you do in-browser image cropping?

http://www.bennadel.com/blog/1824-Creating-An-Image-Zoom-And-Clip-Effect-With-jQuery-And-ColdFusion.htm

HTH,
G!

On Tue, Aug 30, 2011 at 5:20 PM, David McGuigan davidmcgui...@gmail.comwrote:


 Anyone built anything that lets you select multiple image files from a web
 browser for upload ( as well as folders ) like Facebook has?

 How about anything that lets you do in-browser image cropping?

 I can probably fire up Flash and develop the 2nd part myself, but I'm
 hoping
 there's something out there that I can just plug in and use particularly
 smoothly with ColdFusion.

 Thanks.


 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347138
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Anyone know how to fix this or why this happening?

2011-08-30 Thread Andrew Scott

This is a ColdFusion 8 server, and not all mail is having this problem, as
it appears that any email that is sent without the from or to address
contains the name of the email account it is being sent from.

I am sort of think it is a relay issue, or something but can't seem to find
anything that is leading me in the right direction. Google has been of no
help in finding an answer either.

This is what is showing up in the logs

Error,scheduler-1,08/31/11,07:32:14,,Exception reading response
javax.mail.MessagingException: Exception reading response;
  nested exception is:
java.net.SocketTimeoutException: Read timed out
at
com.sun.mail.smtp.SMTPTransport.readServerResponse(SMTPTransport.java:1462)
 at com.sun.mail.smtp.SMTPTransport.openServer(SMTPTransport.java:1260)
at com.sun.mail.smtp.SMTPTransport.protocolConnect(SMTPTransport.java:370)
 at javax.mail.Service.connect(Service.java:275)
at coldfusion.mail.MailSpooler.getConnection(MailSpooler.java:994)
 at coldfusion.mail.MailSpooler.deliver(MailSpooler.java:832)
at coldfusion.mail.MailSpooler.sendMail(MailSpooler.java:753)
 at coldfusion.mail.MailSpooler.deliverStandard(MailSpooler.java:1070)
at coldfusion.mail.MailSpooler.run(MailSpooler.java:1035)
 at coldfusion.scheduling.ThreadPool.run(ThreadPool.java:201)
at coldfusion.scheduling.WorkerThread.run(WorkerThread.java:71)
Caused by: java.net.SocketTimeoutException: Read timed out
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:129)
 at com.sun.mail.util.TraceInputStream.read(TraceInputStream.java:97)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:218)
 at java.io.BufferedInputStream.read(BufferedInputStream.java:237)
at com.sun.mail.util.LineInputStream.readLine(LineInputStream.java:75)
 at
com.sun.mail.smtp.SMTPTransport.readServerResponse(SMTPTransport.java:1440)




-- 
Regards,
Andrew Scott
WebSite: http://www.andyscott.id.au/
Google+: http://plus.google.com/108193156965451149543


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347139
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Anyone know how to fix this or why this happening?

2011-08-30 Thread Scott Stewart

Make sure that the email admin is allowing relay from the cf server's ip
address.

On Aug 30, 2011 5:42 PM, Andrew Scott andr...@andyscott.id.au wrote:

 This is a ColdFusion 8 server, and not all mail is having this problem, as
 it appears that any email that is sent without the from or to address
 contains the name of the email account it is being sent from.

 I am sort of think it is a relay issue, or something but can't seem to
find
 anything that is leading me in the right direction. Google has been of no
 help in finding an answer either.

 This is what is showing up in the logs

 Error,scheduler-1,08/31/11,07:32:14,,Exception reading response
 javax.mail.MessagingException: Exception reading response;
 nested exception is:
 java.net.SocketTimeoutException: Read timed out
 at

com.sun.mail.smtp.SMTPTransport.readServerResponse(SMTPTransport.java:1462)
 at com.sun.mail.smtp.SMTPTransport.openServer(SMTPTransport.java:1260)
 at com.sun.mail.smtp.SMTPTransport.protocolConnect(SMTPTransport.java:370)
 at javax.mail.Service.connect(Service.java:275)
 at coldfusion.mail.MailSpooler.getConnection(MailSpooler.java:994)
 at coldfusion.mail.MailSpooler.deliver(MailSpooler.java:832)
 at coldfusion.mail.MailSpooler.sendMail(MailSpooler.java:753)
 at coldfusion.mail.MailSpooler.deliverStandard(MailSpooler.java:1070)
 at coldfusion.mail.MailSpooler.run(MailSpooler.java:1035)
 at coldfusion.scheduling.ThreadPool.run(ThreadPool.java:201)
 at coldfusion.scheduling.WorkerThread.run(WorkerThread.java:71)
 Caused by: java.net.SocketTimeoutException: Read timed out
 at java.net.SocketInputStream.socketRead0(Native Method)
 at java.net.SocketInputStream.read(SocketInputStream.java:129)
 at com.sun.mail.util.TraceInputStream.read(TraceInputStream.java:97)
 at java.io.BufferedInputStream.fill(BufferedInputStream.java:218)
 at java.io.BufferedInputStream.read(BufferedInputStream.java:237)
 at com.sun.mail.util.LineInputStream.readLine(LineInputStream.java:75)
 at

com.sun.mail.smtp.SMTPTransport.readServerResponse(SMTPTransport.java:1440)




 --
 Regards,
 Andrew Scott
 WebSite: http://www.andyscott.id.au/
 Google+: http://plus.google.com/108193156965451149543


 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347140
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Anyone know how to fix this or why this happening?

2011-08-30 Thread Andrew Scott

I thought I would do a test and it appears to not be a relay issue, by
sending a dummy email from and to addresses that aren't the actualy smtp
account they were sent and received fine.

All I can find on Google is that it might be a bottleneck, but then why does
some mail get through and some don't?

Btw the smtp is a gmail account on Googel Apps.


On Wed, Aug 31, 2011 at 7:47 AM, Scott Stewart webmas...@sstwebworks.comwrote:


 Make sure that the email admin is allowing relay from the cf server's ip
 address.

 On Aug 30, 2011 5:42 PM, Andrew Scott andr...@andyscott.id.au wrote:
 
  This is a ColdFusion 8 server, and not all mail is having this problem,
 as
  it appears that any email that is sent without the from or to address
  contains the name of the email account it is being sent from.
 
  I am sort of think it is a relay issue, or something but can't seem to
 find
  anything that is leading me in the right direction. Google has been of no
  help in finding an answer either.
 
  This is what is showing up in the logs
 
  Error,scheduler-1,08/31/11,07:32:14,,Exception reading response
  javax.mail.MessagingException: Exception reading response;
  nested exception is:
  java.net.SocketTimeoutException: Read timed out
  at
 
 com.sun.mail.smtp.SMTPTransport.readServerResponse(SMTPTransport.java:1462)
  at com.sun.mail.smtp.SMTPTransport.openServer(SMTPTransport.java:1260)
  at
 com.sun.mail.smtp.SMTPTransport.protocolConnect(SMTPTransport.java:370)
  at javax.mail.Service.connect(Service.java:275)
  at coldfusion.mail.MailSpooler.getConnection(MailSpooler.java:994)
  at coldfusion.mail.MailSpooler.deliver(MailSpooler.java:832)
  at coldfusion.mail.MailSpooler.sendMail(MailSpooler.java:753)
  at coldfusion.mail.MailSpooler.deliverStandard(MailSpooler.java:1070)
  at coldfusion.mail.MailSpooler.run(MailSpooler.java:1035)
  at coldfusion.scheduling.ThreadPool.run(ThreadPool.java:201)
  at coldfusion.scheduling.WorkerThread.run(WorkerThread.java:71)
  Caused by: java.net.SocketTimeoutException: Read timed out
  at java.net.SocketInputStream.socketRead0(Native Method)
  at java.net.SocketInputStream.read(SocketInputStream.java:129)
  at com.sun.mail.util.TraceInputStream.read(TraceInputStream.java:97)
  at java.io.BufferedInputStream.fill(BufferedInputStream.java:218)
  at java.io.BufferedInputStream.read(BufferedInputStream.java:237)
  at com.sun.mail.util.LineInputStream.readLine(LineInputStream.java:75)
  at
 
 com.sun.mail.smtp.SMTPTransport.readServerResponse(SMTPTransport.java:1440)
 
 
 
 
  --
  Regards,
  Andrew Scott
  WebSite: http://www.andyscott.id.au/
  Google+: http://plus.google.com/108193156965451149543
 
 
 

 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347141
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Anyone know how to fix this or why this happening?

2011-08-30 Thread Andrew Scott

The other thing I should mention is that this has only just started
happening as of 5 days ago, the site has been running for 8 years.


On Wed, Aug 31, 2011 at 7:51 AM, Andrew Scott andr...@andyscott.id.auwrote:

 I thought I would do a test and it appears to not be a relay issue, by
 sending a dummy email from and to addresses that aren't the actualy smtp
 account they were sent and received fine.

 All I can find on Google is that it might be a bottleneck, but then why
 does some mail get through and some don't?

 Btw the smtp is a gmail account on Googel Apps.

 --

Regards,
Andrew Scott
WebSite: http://www.andyscott.id.au/
Google+: http://plus.google.com/108193156965451149543


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347142
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


PHP Serialization to JSON/Struct via ColdFusion?

2011-08-30 Thread Matthew Reinbold

I have a database filled with PHP serialized strings that represent data that I 
want to consume with a ColdFusion application (not pleased with the data model 
for this project but, unfortunately, that ship sailed long before I arrived). 

Sample data:

a:18:{s:10:user_title;s:0:;s:31:user_relationships_auto_approve;a:2:{i:1;i:0;i:2;i:0;}s:14:picture_delete;i:0;s:14:picture_upload;s:0:;s:17:messaging_default;s:10:privatemsg;s:16:privatemsg_allow;s:1:1;s:28:privatemsg_setmessage_notify;s:1:1;s:20:privatemsg_mailalert;s:1:2;s:9:init_stuff;s:3:744;s:12:current_stuff;i:623;s:7:display;s:1:1;s:10:current_id;s:1:4;s:7:contact;i:0;s:12:current_date;s:10:1222790275;s:8:nextpage;s:0:;s:9:messaging;s:0:;s:5:blahblah;s:10:2145048145;s:11:destination;s:26:user/kaboom?;}

I was hoping that there was a library or tag that would allow me to create a 
ColdFusion variable out of this but I don't seem to be finding anything. I did 
find this post:

http://stackoverflow.com/questions/4511184/deserialize-php-array-in-coldfusion

...however adding Corfield's php scripting for ColdFusion project is a no-no as 
I can't add jar files to the hosts CF lib folder.

Anybody have an idea how I go about parsing a PHP Serialized variable and turn 
it into something I can use via CF?

- Matthew 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347143
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: PHP Serialization to JSON/Struct via ColdFusion?

2011-08-30 Thread Michael Grant

Is that Drupal data you're working with?

On Tue, Aug 30, 2011 at 6:43 PM, Matthew Reinbold 
matthew.reinb...@voxpopdesign.com wrote:


 I have a database filled with PHP serialized strings that represent data
 that I want to consume with a ColdFusion application (not pleased with the
 data model for this project but, unfortunately, that ship sailed long before
 I arrived).

 Sample data:


 a:18:{s:10:user_title;s:0:;s:31:user_relationships_auto_approve;a:2:{i:1;i:0;i:2;i:0;}s:14:picture_delete;i:0;s:14:picture_upload;s:0:;s:17:messaging_default;s:10:privatemsg;s:16:privatemsg_allow;s:1:1;s:28:privatemsg_setmessage_notify;s:1:1;s:20:privatemsg_mailalert;s:1:2;s:9:init_stuff;s:3:744;s:12:current_stuff;i:623;s:7:display;s:1:1;s:10:current_id;s:1:4;s:7:contact;i:0;s:12:current_date;s:10:1222790275;s:8:nextpage;s:0:;s:9:messaging;s:0:;s:5:blahblah;s:10:
 2145048145;s:11:destination;s:26:user/kaboom?;}

 I was hoping that there was a library or tag that would allow me to create
 a ColdFusion variable out of this but I don't seem to be finding anything. I
 did find this post:


 http://stackoverflow.com/questions/4511184/deserialize-php-array-in-coldfusion

 ...however adding Corfield's php scripting for ColdFusion project is a
 no-no as I can't add jar files to the hosts CF lib folder.

 Anybody have an idea how I go about parsing a PHP Serialized variable and
 turn it into something I can use via CF?

 - Matthew

 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347144
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Anyone know how to fix this or why this happening?

2011-08-30 Thread Rex

Google can have availability problems sometimes.  Also, one of these 
could be the reason:

* They don't allow you to change the from address.  You must provide
  the proper username/password for the email to send.  You say that
  that is working, but I never got that to work, but I use a regular
  @gmail.com account, and not a google apps account
* Google has been migrating/updating google apps accounts, so maybe
  the admin got an email saying something like Google Apps account
  transition complete or something like that, so it may have
  affected something
* I think, before, we can just do username as the cfmail username
  attribute, without the @gmail.com and now I think you have to
  put this in (I'm not sure about this).
* Google has sending limits as well, make sure you have not hit those.

- Rex

On 8/30/2011 2:52 PM, Andrew Scott wrote:
 The other thing I should mention is that this has only just started
 happening as of 5 days ago, the site has been running for 8 years.


 On Wed, Aug 31, 2011 at 7:51 AM, Andrew Scottandr...@andyscott.id.auwrote:

 I thought I would do a test and it appears to not be a relay issue, by
 sending a dummy email from and to addresses that aren't the actualy smtp
 account they were sent and received fine.

 All I can find on Google is that it might be a bottleneck, but then why
 does some mail get through and some don't?

 Btw the smtp is a gmail account on Googel Apps.

 --

 Regards,
 Andrew Scott
 WebSite: http://www.andyscott.id.au/
 Google+: http://plus.google.com/108193156965451149543


 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347145
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Anyone know how to fix this or why this happening?

2011-08-30 Thread Andrew Scott

Rex,

Nothing you said makes sense, nor is it a solution. I am very well aware
that accounts have been migrating for Google Apps, that is not an issue and
has never affected any of my other domains or emails at gmail. And it was
one of the very first things I checked here.

Secondly the user/password used for sending the email is verified
succesfully in CF Admin, and as I stated emails are being sent. I thought it
might have been a relay problem, so I did another test and that went ok.

But for some reason certain emails being generated from the system are
throwing the error that I posted, and I can't work out why some are being
thrown in the undeliverable folder, and some are going through.

Now Google searches have turned up nothing that helps, and most keep talking
about a network congestion, but why is it so selective as to what goes
through and what doesn't. Dragging the emails that can't be delivered into
the spool, just seems to take forever to try to send them and they seem to
be taking forever, before going straight back to the undeliverable folder
again.

So I am stumped, and have no idea where to begin looking for the problem any
more.


On Wed, Aug 31, 2011 at 9:20 AM, Rex li...@chickything.com wrote:


 Google can have availability problems sometimes.  Also, one of these
 could be the reason:

* They don't allow you to change the from address.  You must provide
  the proper username/password for the email to send.  You say that
  that is working, but I never got that to work, but I use a regular
  @gmail.com account, and not a google apps account
* Google has been migrating/updating google apps accounts, so maybe
  the admin got an email saying something like Google Apps account
  transition complete or something like that, so it may have
  affected something
* I think, before, we can just do username as the cfmail username
  attribute, without the @gmail.com and now I think you have to
  put this in (I'm not sure about this).
* Google has sending limits as well, make sure you have not hit those.

 - Rex

 On 8/30/2011 2:52 PM, Andrew Scott wrote:
  The other thing I should mention is that this has only just started
  happening as of 5 days ago, the site has been running for 8 years.
 
 
  On Wed, Aug 31, 2011 at 7:51 AM, Andrew Scottandr...@andyscott.id.au
 wrote:
 
  I thought I would do a test and it appears to not be a relay issue, by
  sending a dummy email from and to addresses that aren't the actualy smtp
  account they were sent and received fine.
 
  All I can find on Google is that it might be a bottleneck, but then why
  does some mail get through and some don't?
 
  Btw the smtp is a gmail account on Googel Apps.
 
  --
 
  Regards,
  Andrew Scott
  WebSite: http://www.andyscott.id.au/
  Google+: http://plus.google.com/108193156965451149543
 
 
 

 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347146
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: PHP Serialization to JSON/Struct via ColdFusion?

2011-08-30 Thread Rex

maybe you can use this http://javaloader.riaforge.org/ that way you can 
drop the jar file in one of your directories

- Rex

On 8/30/2011 3:43 PM, Matthew Reinbold wrote:
 I have a database filled with PHP serialized strings that represent data that 
 I want to consume with a ColdFusion application (not pleased with the data 
 model for this project but, unfortunately, that ship sailed long before I 
 arrived).

 Sample data:

 a:18:{s:10:user_title;s:0:;s:31:user_relationships_auto_approve;a:2:{i:1;i:0;i:2;i:0;}s:14:picture_delete;i:0;s:14:picture_upload;s:0:;s:17:messaging_default;s:10:privatemsg;s:16:privatemsg_allow;s:1:1;s:28:privatemsg_setmessage_notify;s:1:1;s:20:privatemsg_mailalert;s:1:2;s:9:init_stuff;s:3:744;s:12:current_stuff;i:623;s:7:display;s:1:1;s:10:current_id;s:1:4;s:7:contact;i:0;s:12:current_date;s:10:1222790275;s:8:nextpage;s:0:;s:9:messaging;s:0:;s:5:blahblah;s:10:2145048145;s:11:destination;s:26:user/kaboom?;}

 I was hoping that there was a library or tag that would allow me to create a 
 ColdFusion variable out of this but I don't seem to be finding anything. I 
 did find this post:

 http://stackoverflow.com/questions/4511184/deserialize-php-array-in-coldfusion

 ...however adding Corfield's php scripting for ColdFusion project is a no-no 
 as I can't add jar files to the hosts CF lib folder.

 Anybody have an idea how I go about parsing a PHP Serialized variable and 
 turn it into something I can use via CF?

 - Matthew

 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347147
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Anyone know how to fix this or why this happening?

2011-08-30 Thread Rex

Sorry, just trying to help.  It's hard to pin down an intermittent 
problem like yours.

I've also had problems with GMail's SMTP and IMAP every now and then.  
Maybe you can benefit from a third party email service?

- Rex

On 8/30/2011 4:33 PM, Andrew Scott wrote:
 Rex,

 Nothing you said makes sense, nor is it a solution. I am very well aware
 that accounts have been migrating for Google Apps, that is not an issue and
 has never affected any of my other domains or emails at gmail. And it was
 one of the very first things I checked here.

 Secondly the user/password used for sending the email is verified
 succesfully in CF Admin, and as I stated emails are being sent. I thought it
 might have been a relay problem, so I did another test and that went ok.

 But for some reason certain emails being generated from the system are
 throwing the error that I posted, and I can't work out why some are being
 thrown in the undeliverable folder, and some are going through.

 Now Google searches have turned up nothing that helps, and most keep talking
 about a network congestion, but why is it so selective as to what goes
 through and what doesn't. Dragging the emails that can't be delivered into
 the spool, just seems to take forever to try to send them and they seem to
 be taking forever, before going straight back to the undeliverable folder
 again.

 So I am stumped, and have no idea where to begin looking for the problem any
 more.


 On Wed, Aug 31, 2011 at 9:20 AM, Rexli...@chickything.com  wrote:

 Google can have availability problems sometimes.  Also, one of these
 could be the reason:

 * They don't allow you to change the from address.  You must provide
   the proper username/password for the email to send.  You say that
   that is working, but I never got that to work, but I use a regular
   @gmail.com account, and not a google apps account
 * Google has been migrating/updating google apps accounts, so maybe
   the admin got an email saying something like Google Apps account
   transition complete or something like that, so it may have
   affected something
 * I think, before, we can just do username as the cfmail username
   attribute, without the @gmail.com and now I think you have to
   put this in (I'm not sure about this).
 * Google has sending limits as well, make sure you have not hit those.

 - Rex

 On 8/30/2011 2:52 PM, Andrew Scott wrote:
 The other thing I should mention is that this has only just started
 happening as of 5 days ago, the site has been running for 8 years.


 On Wed, Aug 31, 2011 at 7:51 AM, Andrew Scottandr...@andyscott.id.au
 wrote:

 I thought I would do a test and it appears to not be a relay issue, by
 sending a dummy email from and to addresses that aren't the actualy smtp
 account they were sent and received fine.

 All I can find on Google is that it might be a bottleneck, but then why
 does some mail get through and some don't?

 Btw the smtp is a gmail account on Googel Apps.

 --

 Regards,
 Andrew Scott
 WebSite: http://www.andyscott.id.au/
 Google+: http://plus.google.com/108193156965451149543




 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347148
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Anyone know how to fix this or why this happening?

2011-08-30 Thread Andrew Scott

Thanks Rex, but your assuming it is the gmail account. All my tests show
that this is not the case, as we have another server we ran the same
application on it, and it all works fine.

So this is not as intermittent as you think, the failure rate is actually
very high. We are talking like 20k emails not being sent, and even if I try
to move one at a time back into the spool it goes straight back to the
undeliverable folder.

All tests that I have run actually work on the server, except these emails.
And there is nothing, absolutely nothing in the email that shows what could
be making it fail. Which is what makes it even harder to understand where to
look.

Even an email that gets sent ok, if I intercept it and make a copy before it
it sent. Looking at it and any that fail, apart from the subject and body
nothing else is different.


On Wed, Aug 31, 2011 at 9:45 AM, Rex li...@chickything.com wrote:


 Sorry, just trying to help.  It's hard to pin down an intermittent
 problem like yours.

 I've also had problems with GMail's SMTP and IMAP every now and then.
 Maybe you can benefit from a third party email service?

 - Rex

 On 8/30/2011 4:33 PM, Andrew Scott wrote:
  Rex,
 
  Nothing you said makes sense, nor is it a solution. I am very well aware
  that accounts have been migrating for Google Apps, that is not an issue
 and
  has never affected any of my other domains or emails at gmail. And it was
  one of the very first things I checked here.
 
  Secondly the user/password used for sending the email is verified
  succesfully in CF Admin, and as I stated emails are being sent. I thought
 it
  might have been a relay problem, so I did another test and that went ok.
 
  But for some reason certain emails being generated from the system are
  throwing the error that I posted, and I can't work out why some are being
  thrown in the undeliverable folder, and some are going through.
 
  Now Google searches have turned up nothing that helps, and most keep
 talking
  about a network congestion, but why is it so selective as to what goes
  through and what doesn't. Dragging the emails that can't be delivered
 into
  the spool, just seems to take forever to try to send them and they seem
 to
  be taking forever, before going straight back to the undeliverable folder
  again.
 
  So I am stumped, and have no idea where to begin looking for the problem
 any
  more.
 
 
  On Wed, Aug 31, 2011 at 9:20 AM, Rexli...@chickything.com  wrote:
 
  Google can have availability problems sometimes.  Also, one of these
  could be the reason:
 
  * They don't allow you to change the from address.  You must provide
the proper username/password for the email to send.  You say that
that is working, but I never got that to work, but I use a regular
@gmail.com account, and not a google apps account
  * Google has been migrating/updating google apps accounts, so maybe
the admin got an email saying something like Google Apps account
transition complete or something like that, so it may have
affected something
  * I think, before, we can just do username as the cfmail username
attribute, without the @gmail.com and now I think you have to
put this in (I'm not sure about this).
  * Google has sending limits as well, make sure you have not hit
 those.
 
  - Rex
 
  On 8/30/2011 2:52 PM, Andrew Scott wrote:
  The other thing I should mention is that this has only just started
  happening as of 5 days ago, the site has been running for 8 years.
 
 
  On Wed, Aug 31, 2011 at 7:51 AM, Andrew Scottandr...@andyscott.id.au
  wrote:
 
  I thought I would do a test and it appears to not be a relay issue, by
  sending a dummy email from and to addresses that aren't the actualy
 smtp
  account they were sent and received fine.
 
  All I can find on Google is that it might be a bottleneck, but then
 why
  does some mail get through and some don't?
 
  Btw the smtp is a gmail account on Googel Apps.
 
  --
 
  Regards,
  Andrew Scott
  WebSite: http://www.andyscott.id.au/
  Google+: http://plus.google.com/108193156965451149543
 
 
 
 
 

 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347149
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Anyone know how to fix this or why this happening?

2011-08-30 Thread Russ Michaels

how many emails are you sending per day through gmail, there are limits, and
it might be blocking you if you have exceeded them.
For google Apps it is 500 per day per user.

--

Russ Michaels

www.bluethunderinternet.com  : Business hosting services  solutions
www.cfmldeveloper.com: ColdFusion developer community
www.michaels.me.uk   : my blog
www.cfsearch.com : ColdFusion search engine
**
*skype me* : russmichaels


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347150
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Anyone know how to fix this or why this happening?

2011-08-30 Thread Andrew Scott

That is still not an issue, this has been working for years. It has only
just started to have these problems, and again I tried re-sending one at a
time and one at a time fails.

Like I said Google says that the error I pasted is a network bottle neck, as
the reason is it times out waiting for a response.

On Wed, Aug 31, 2011 at 10:14 AM, Russ Michaels r...@michaels.me.uk wrote:


 how many emails are you sending per day through gmail, there are limits,
 and
 it might be blocking you if you have exceeded them.
 For google Apps it is 500 per day per user.

 --

 Russ Michaels

 www.bluethunderinternet.com  : Business hosting services  solutions
 www.cfmldeveloper.com: ColdFusion developer community
 www.michaels.me.uk   : my blog
 www.cfsearch.com : ColdFusion search engine
 **
 *skype me* : russmichaels


 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347151
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Anyone know how to fix this or why this happening?

2011-08-30 Thread Russ Michaels

you could use wireshark to confirm this is the case, it will show you the
commication between coldfusion and google so you can see if cf is getting a
response.

On Wed, Aug 31, 2011 at 1:22 AM, Andrew Scott andr...@andyscott.id.auwrote:


 That is still not an issue, this has been working for years. It has only
 just started to have these problems, and again I tried re-sending one at a
 time and one at a time fails.

 Like I said Google says that the error I pasted is a network bottle neck,
 as
 the reason is it times out waiting for a response.

 On Wed, Aug 31, 2011 at 10:14 AM, Russ Michaels r...@michaels.me.uk
 wrote:

 
  how many emails are you sending per day through gmail, there are limits,
  and
  it might be blocking you if you have exceeded them.
  For google Apps it is 500 per day per user.
 
  --
 
  Russ Michaels
 
  www.bluethunderinternet.com  : Business hosting services  solutions
  www.cfmldeveloper.com: ColdFusion developer community
  www.michaels.me.uk   : my blog
  www.cfsearch.com : ColdFusion search engine
  **
  *skype me* : russmichaels
 
 
 

 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347152
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Anyone know how to fix this or why this happening?

2011-08-30 Thread Billy Cravens

Very similar to what you're reporting:

http://www.google.com/support/forum/p/Google%20Apps/thread?tid=5f96d0e5cfc60a95hl=en

It can be a limit issue - I believe Google's SMTP server reject all connections 
from that user once you hit limit (500/day or 2000/day for a premium account; I 
am very certain about the limit, just less so about how the SMTP server 
responds). 
I know you say it's been working before, but test the limit issue before you 
summarily dismiss it. Google does have that limit, and perhaps they only 
recently started enforcing it for you.

To confirm whether or not it's a limit issue:
Login to the web interface using the user you're using for CFMail, and try to 
send - if you hit a limit, you're locked out for 24 hours.

You can always cycle through accounts to bypass the limit issue (this solution 
even shows up in Google's support pages, go figure)


Billy Cravens
bdcrav...@gmail.com



On Aug 30, 2011, at 7:22 PM, Andrew Scott wrote:

 
 That is still not an issue, this has been working for years. It has only
 just started to have these problems, and again I tried re-sending one at a
 time and one at a time fails.
 
 Like I said Google says that the error I pasted is a network bottle neck, as
 the reason is it times out waiting for a response.
 
 On Wed, Aug 31, 2011 at 10:14 AM, Russ Michaels r...@michaels.me.uk wrote:
 
 
 how many emails are you sending per day through gmail, there are limits,
 and
 it might be blocking you if you have exceeded them.
 For google Apps it is 500 per day per user.
 
 --
 
 Russ Michaels
 
 www.bluethunderinternet.com  : Business hosting services  solutions
 www.cfmldeveloper.com: ColdFusion developer community
 www.michaels.me.uk   : my blog
 www.cfsearch.com : ColdFusion search engine
 **
 *skype me* : russmichaels
 
 
 
 
 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347153
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Anyone know how to fix this or why this happening?

2011-08-30 Thread Andrew Scott

Bill,

It does sound very similar, but there are two things that doesn't gel with
me here.

1) this would mean that no more emails can be sent from this user, but I can
send another email and it will be delivered fine.

2) It also says that for this to be true, then an email will be sitting in
the users mailbox stating that it was not deliverable and that it was
considered Spam.

This is not the case, and lastly we are talking about something that has
only just happened. It appears the Google have had this in place for many
years, and we have only just began to receive this problem in the last 7
days.


On Wed, Aug 31, 2011 at 12:57 PM, Billy Cravens bdcrav...@gmail.com wrote:


 Very similar to what you're reporting:


 http://www.google.com/support/forum/p/Google%20Apps/thread?tid=5f96d0e5cfc60a95hl=en

 It can be a limit issue - I believe Google's SMTP server reject all
 connections from that user once you hit limit (500/day or 2000/day for a
 premium account; I am very certain about the limit, just less so about how
 the SMTP server responds).
 I know you say it's been working before, but test the limit issue before
 you summarily dismiss it. Google does have that limit, and perhaps they only
 recently started enforcing it for you.

 To confirm whether or not it's a limit issue:
 Login to the web interface using the user you're using for CFMail, and try
 to send - if you hit a limit, you're locked out for 24 hours.

 You can always cycle through accounts to bypass the limit issue (this
 solution even shows up in Google's support pages, go figure)


 Billy Cravens
 bdcrav...@gmail.com


 --
Regards,
Andrew Scott
WebSite: http://www.andyscott.id.au/
Google+: http://plus.google.com/108193156965451149543


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347154
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Anyone know how to fix this or why this happening?

2011-08-30 Thread Billy Cravens

If you can send email, then you haven't hit the limit.

Have you identified any patterns (size, to, from, cc, etc) on the messages that 
are unsuccessful?

Billy Cravens
bdcrav...@gmail.com



On Aug 31, 2011, at 12:15 AM, Andrew Scott wrote:

 
 Bill,
 
 It does sound very similar, but there are two things that doesn't gel with
 me here.
 
 1) this would mean that no more emails can be sent from this user, but I can
 send another email and it will be delivered fine.
 
 2) It also says that for this to be true, then an email will be sitting in
 the users mailbox stating that it was not deliverable and that it was
 considered Spam.
 
 This is not the case, and lastly we are talking about something that has
 only just happened. It appears the Google have had this in place for many
 years, and we have only just began to receive this problem in the last 7
 days.
 
 
 On Wed, Aug 31, 2011 at 12:57 PM, Billy Cravens bdcrav...@gmail.com wrote:
 
 
 Very similar to what you're reporting:
 
 
 http://www.google.com/support/forum/p/Google%20Apps/thread?tid=5f96d0e5cfc60a95hl=en
 
 It can be a limit issue - I believe Google's SMTP server reject all
 connections from that user once you hit limit (500/day or 2000/day for a
 premium account; I am very certain about the limit, just less so about how
 the SMTP server responds).
 I know you say it's been working before, but test the limit issue before
 you summarily dismiss it. Google does have that limit, and perhaps they only
 recently started enforcing it for you.
 
 To confirm whether or not it's a limit issue:
 Login to the web interface using the user you're using for CFMail, and try
 to send - if you hit a limit, you're locked out for 24 hours.
 
 You can always cycle through accounts to bypass the limit issue (this
 solution even shows up in Google's support pages, go figure)
 
 
 Billy Cravens
 bdcrav...@gmail.com
 
 
 --
 Regards,
 Andrew Scott
 WebSite: http://www.andyscott.id.au/
 Google+: http://plus.google.com/108193156965451149543
 
 
 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347155
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm