Re: Using XML to Create schema/database

[s. isaac dealey]

> Hello,
> I was wondering if there were any libraries or functions which can be
> used to create database tables on the fly based on XML data and then
> insert the data. So all I had to worry about was formatting the xml
> data.

I've not done anything for performing the inserts/updates using XML, but
the DataFaucet orm ( http://datafaucet.riaforge.org ) creates DB tables
using XML and so does Steve Bryan'ts DataMgr project (
http://datamgr.riaforge.org ). Shouldn't be too difficult to add
something for performing the inserts/updates with either tool. 

hth 
ike

-- 
s. isaac dealey :: AutLabs 
Creating meaningful employment for people with Autism 
http://www.autlabs.com 
ph: 817.385.0301

http://onTap.riaforge.org/blog



~|
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:329001
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Possible thread issue?

[Jaime Metcher]

I can't comment on whether for your app singleton is right or not.  Just be
aware that in CF singleton is much more common than in Java, largely due to
the much higher object instantiation overhead.

Jaime
On Wed, Dec 9, 2009 at 3:28 PM, Andre Kapp  wrote:

>
> Tks Leigh
>
> I changed all the variables to be var scoped. I have also var scoped the
> queries.
> Still busy testing but it looks go
>
> Tks again for all the input. Without this I would have been lost! I still
> believe the Singleton is not the correct design pattern here, so will still
> do some work on that.
>
> Andre
>
>
> 

~|
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:329000
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Possible thread issue?

[Andre Kapp]

> > It pretty much looks like a singleton design!
> 
> Yep. I think Jaime has it right. It looks like few (if any) of the 
> variables set within the DAO's functions are VAR scoped. So they will 
> automatically be placed in the shared "variables" scope. Since you are 
> working with a singleton, those variables will be accessible to 
> multiple threads. Under heavy load, it is very likely that would lead 
> to the behavior you have described. ie One thread overwriting values 
> set by another.
> 
> All variables that are local to a function must be VAR-scoped. That 
> ensures they are only visible to the function, and not other threads.  
> It seems like the code starts to do the right thing by declaring the 
> function-local structure "stTrans". 
> 
>  
  .
> 
  
>  
  
> 
 
> 
> 
> 
> 
> But then starts using un-VAR'd variables like:
> 
 
>  getAccountBalance("available", arguments.acctid)> 
...
> 
> 
> Since theCurrentAvailableBalance was not var-scoped (or added to an 
> object that _was_ var-scoped) it will fall into the "variables" scope. 
> Since the DAO functions seem to use a lot of variables, the easiest 
> way to make them function-local would to add them to the localized 
> structure "stTrans". **Note, as Jaime mentioned this includes query 
> names as well.
> 
> Example:
 
>  getAccountBalance("available", arguments.acctid)> 
>  getAccountBalance("actual", arguments.acctid)>  
... 
> etcetera ...
> 
> 
>  result="stTrans.trans_insert_res"> 
.
> 
> 
> 
> HTH
> -Leigh
> 
> 
> 
> 
> 
  
Tks Leigh

I changed all the variables to be var scoped. I have also var scoped the 
queries.
Still busy testing but it looks go

Tks again for all the input. Without this I would have been lost! I still 
believe the Singleton is not the correct design pattern here, so will still do 
some work on that.

Andre


~|
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:328999
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Possible thread issue?

[Leigh]

> but you'd have to find where
> the service is instantiated to be sure.  

Based on the names, I took a leap of faith that it really is what it appears to 
be ;-)  But Jaime is right. You should verify it.

-Leigh


 

~|
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:328998
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Possible thread issue?

[Leigh]

> It pretty much looks like a singleton design!

Yep. I think Jaime has it right. It looks like few (if any) of the variables 
set within the DAO's functions are VAR scoped. So they will automatically be 
placed in the shared "variables" scope. Since you are working with a singleton, 
those variables will be accessible to multiple threads. Under heavy load, it is 
very likely that would lead to the behavior you have described. ie One thread 
overwriting values set by another.

All variables that are local to a function must be VAR-scoped. That ensures 
they are only visible to the function, and not other threads.  It seems like 
the code starts to do the right thing by declaring the function-local structure 
"stTrans". 

 
  .
   
  
 



But then starts using un-VAR'd variables like:

  
...

Since theCurrentAvailableBalance was not var-scoped (or added to an object that 
_was_ var-scoped) it will fall into the "variables" scope. Since the DAO 
functions seem to use a lot of variables, the easiest way to make them 
function-local would to add them to the localized structure "stTrans". **Note, 
as Jaime mentioned this includes query names as well.

Example:
  
  
... etcetera ...


 
.


HTH
-Leigh





  

~|
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:328997
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Possible thread issue?

[Jaime Metcher]

Andre,

Yeah, looks like singleton, but you'd have to find where the service is
instantiated to be sure.  Throw it back to the guys who wrote the code
anyway!  They should be var scoping always.

Don't know about the classid.  You can of course get the hashcode - see
http://www.compoundtheory.com/?action=displayPost&ID=42.   Failing that, a
common but invasive way to establish CFC instance identity is to set a
variable:



and then next time around check IsDefined(transDAO,
"__variable_name_unlikely_to_be_already_used ").

Jaime

On Wed, Dec 9, 2009 at 1:50 PM, Andre Kapp  wrote:

>
> > >Andre,
> > >
> > >Is this DAO a singleton?  I notice the queries aren't var scoped.  If
> > this
> > >is a singleton under load another thread could easily overwrite your
> > >trans_insert variable in between issuing the query and logging the
> > generated
> > >key.
> > >
> > >Jaime
> > >
> > >
> > >
> > >>
> > Tks Jaime.
> > I have traced the code back to where this object is instantiated. It
> > pretty much looks like a singleton design!
> >
> > This is the code just above this transdao.cfc
> >
>
> Just a quick question.
>
> I'm much more familiar with the Java environment, so still learning the CF
> way.
>
> Is there a way to get the classid value of the Java object that gets
> created by coldfusion? This will help me to dump the TransDAO classid when
> displaying the transid value. If the classid is the same, then it will prove
> the singleton implementation.
>
> Tks
> Andre
>
>
> 

~|
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:328996
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Possible thread issue?

[Andre Kapp]

> >Andre,
> >
> >Is this DAO a singleton?  I notice the queries aren't var scoped.  If 
> this
> >is a singleton under load another thread could easily overwrite your
> >trans_insert variable in between issuing the query and logging the 
> generated
> >key.
> >
> >Jaime
> >
> >
> >
> >>
> Tks Jaime.
> I have traced the code back to where this object is instantiated. It 
> pretty much looks like a singleton design!
> 
> This is the code just above this transdao.cfc
> 
> 
> 
>   
>   
>   
> 
>output="false">
>   
>   
>  
> 
>output="false">
>type="moneymaker.core.model.trans.
> TransGateway" required="true" />
>   
>   
>   
>output="false">
>   
>   

> 

>  output="false">
>   
>   
> 

>  returntype="struct">

> 

>  getTransLimits(argumentCollection=arguments) />

> 
> 

>  returntype="struct">

> 

> 

> 

> 

> 

> 

> 

> 
> 
>   

> 

> 
> 

> 
> 
> 
> 
> I just want to prove that and then throw it back to the guys that 
> wrote the initial code. 
> 
> Tks again for all the help...! 


Just a quick question.

I'm much more familiar with the Java environment, so still learning the CF way.

Is there a way to get the classid value of the Java object that gets created by 
coldfusion? This will help me to dump the TransDAO classid when displaying the 
transid value. If the classid is the same, then it will prove the singleton 
implementation.

Tks
Andre


~|
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:328995
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Possible thread issue?

[Andre Kapp]

>Andre,
>
>Is this DAO a singleton?  I notice the queries aren't var scoped.  If this
>is a singleton under load another thread could easily overwrite your
>trans_insert variable in between issuing the query and logging the generated
>key.
>
>Jaime
>
>
>
>>
Tks Jaime.
I have traced the code back to where this object is instantiated. It pretty 
much looks like a singleton design!

This is the code just above this transdao.cfc










   





































I just want to prove that and then throw it back to the guys that wrote the 
initial code. 

Tks again for all the help...! 

~|
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:328994
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

ColdFusion Collaboration Chat Starting

[s. isaac dealey]

Hey guys, we've stared the collaboration chat at 

http://experts.na3.acrobat.com/collab/

Hope to see you there! :)

-- 
s. isaac dealey :: AutLabs 
Creating meaningful employment for people with Autism 
http://www.autlabs.com 
ph: 817.385.0301

http://onTap.riaforge.org/blog



~|
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:328993
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CFLDAP & SSL

[Tom Jones]

Yes, you have to install the cert, and you have to restart the cfm service as 
well. The other thing I'm not seeing in your cfldap tag is the port. If it's 
missing it's will default to 389 not the standard 636 for ssl.

tom

On Dec 8, 2009, at 8:50 AM, Jake Churchill wrote:

> 
> I'm working on an SSL integration of CFLDAP for a client and am consistently
> getting "Connection to LDAP server failed."
> 
> All attributes are correct and for testing I'm attempting a simple query
> with * for attributes and maxrows of 10.  Snippet below.  Everything is
> straight from the IT staff that controls the LDAP server.  I read this
> article: http://kb2.adobe.com/cps/191/tn_19139.html#enableCF which stated
> that you have to install the certificate of the remote LDAP server in the CF
> local keystore.  Is that true?  Is that the only way?
> 
> Here's that snippet:
> 
>  action="query"
> server="client.domain.com"
> username="username"
> password="password"
> name="ldapResult"
> attributes="*"
> start="DN_PROPERTIES_COMMA_SEPARATED_LIST"
> secure="CFSSL_BASIC"
> maxrows="10"
> />
> 
> 
> 

~|
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:328992
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: cf9 packaging & deployment

[Tim Do]

nevermind, I'm on standard...

NOTE: This requires either an Enterprise or Developer Edition installation. If 
you have installed the Standard Edition, you can revert to the Developer 
Edition by removing the serial number.

-Original Message-
From: Tim Do [mailto:t...@wng.com] 
Sent: Tuesday, December 08, 2009 3:45 PM
To: cf-talk
Subject: cf9 packaging & deployment


I just upgraded to 9 from 8 and I can't see the packaging & deployment feature 
in cfadmin?  Where can I find it?  thx




~|
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:328991
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Using XML to Create schema/database

[Tom Jones]

Hello,
I was wondering if there were any libraries or functions which can be used to 
create database tables on the fly based on XML data and then insert the data. 
So all I had to worry about was formatting the xml data.

Thanks,
tom


~|
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:328990
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

cf9 packaging & deployment

[Tim Do]

I just upgraded to 9 from 8 and I can't see the packaging & deployment feature 
in cfadmin?  Where can I find it?  thx


~|
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:328989
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Reading Microsoft "smart" quotes with CFFILE

[Mosh Teitelbaum]

All:

 

I’m trying to read content from an XML file stored on disk, fiddle with it,
and save it to a database.  It all works fine except for when the content
includes smart-quotes (the XML file is a spreadsheet exported from MS Excel
to “XML Spreadsheet 2003” format).  When I use CFFILE to read the XML file,
without specifying a character set, the smart quotes get turned into 3 other
characters.  For example, an opening quote (ASC value of 8220) gets turned
into “ï¿ ½” (239-191-189).  When I specify a character set, I either get the
same results or, using “utf-8”, I get a single, unprintable character with
an ASC value of 65533, regardless of what the starting character actually
was.

 

If I enter the offending string directly into my CF code, or into a textarea
in a form, the string is read as expected.  It’s only a problem when the
string is read via CFFILE.

 

Any suggestions on what character set I should use or, barring that, another
means of reading the content from the disk?

 

TIA

 

--

Mosh Teitelbaum

evoch, LLC

http://www.evoch.com/

~|
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:328988
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: C:\ColdFusion8\Mail\Spool

[John M Bliss]

Thanks!

On Tue, Dec 8, 2009 at 4:51 PM, David  wrote:

>
> On Tue, Dec 8, 2009 at 8:16 AM, John M Bliss  wrote:
> >
> > So this AM, my production server had not sent me my usual batch of emails
> > (via cfmail).  I went to Server Settings > Mail, checked Verify mail
> server
> > connection, clicked Submit Changes, and received Connection Verification
> > Successful.  I stopped and restarted my SMTP server and then noticed that
> > email I was expecting to receive was sitting in
> C:\ColdFusion8\Mail\Spool.
> > I stopped and restarted the CF server (CF 8 with CHF 4) and now all of
> the
> > mail is being delivered.
> >
> > Is this a fluke?  Known issue?  Anything I can do to prevent it from
> > recurring?
> >
> > Thanks!
>
>
> There's actually a way to restart just the spool component, which may
> be all you need to get it spooling again
> http://stackoverflow.com/questions/94948/restarting-coldfusion-mail-queue
>
> I added a file to my cf admin/custom folder, and added to
> custommenu.xml, to restart the mail service:
>
> 
> Restart
> mail spool service
>
>  URL.restartMailService IS true>
> CreateObject("java","coldfusion.server.ServiceFactory")>
>
>
>Mail spool service stopped.
>
>
>Mail spool service restarted!
>
> 
>
> - D
>
> 

~|
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:328987
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: C:\ColdFusion8\Mail\Spool

[David]

On Tue, Dec 8, 2009 at 8:16 AM, John M Bliss  wrote:
>
> So this AM, my production server had not sent me my usual batch of emails
> (via cfmail).  I went to Server Settings > Mail, checked Verify mail server
> connection, clicked Submit Changes, and received Connection Verification
> Successful.  I stopped and restarted my SMTP server and then noticed that
> email I was expecting to receive was sitting in C:\ColdFusion8\Mail\Spool.
> I stopped and restarted the CF server (CF 8 with CHF 4) and now all of the
> mail is being delivered.
>
> Is this a fluke?  Known issue?  Anything I can do to prevent it from
> recurring?
>
> Thanks!


There's actually a way to restart just the spool component, which may
be all you need to get it spooling again
http://stackoverflow.com/questions/94948/restarting-coldfusion-mail-queue

I added a file to my cf admin/custom folder, and added to
custommenu.xml, to restart the mail service:


Restart
mail spool service





Mail spool service stopped.


Mail spool service restarted!



- D

~|
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:328986
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CFWindow z-index with overlib

[John Pullam]

Just in case anyone comes looking at this post in the future, I discovered that 
cfwindows use a z-index in the 9000 range. I had set overlib at 1000 so it 
wasn't high enough. I changed it to 10,000 and it is now fine.


~|
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:328985
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: C:\ColdFusion8\Mail\Spool

[John M Bliss]

Ug.  OK.  Thanks.

On Tue, Dec 8, 2009 at 4:23 PM, Bobby  wrote:

>
> The same thing has happened to use before. I never found any logs
> indicating the cause and a service restart prompted the spooled emails
> to start sending again.
>
> It was just one of the few reasons we put all of our servers on a weekly
> reboot schedule.
>
>
> John M Bliss wrote:
> >> Typically you'll see an error in your ColdFusion mail.log file that will
> >>
> > state that the connection to your mail server failed at some point.
> >
> > That didn't happen in this case.
> >
> >
> > On Tue, Dec 8, 2009 at 8:04 AM, Cutter (ColdFusion) <
> > cold.fus...@cutterscrossing.com> wrote:
> >
> >
> >> See if this might help you:
> >>
> >>
> >>
> 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
> >>
> >>
> >>
> >> John M Bliss wrote:
> >>
> >>> So this AM, my production server had not sent me my usual batch of
> emails
> >>> (via cfmail).  I went to Server Settings > Mail, checked Verify mail
> >>>
> >> server
> >>
> >>> connection, clicked Submit Changes, and received Connection
> Verification
> >>> Successful.  I stopped and restarted my SMTP server and then noticed
> that
> >>> email I was expecting to receive was sitting in
> >>>
> >> C:\ColdFusion8\Mail\Spool.
> >>
> >>> I stopped and restarted the CF server (CF 8 with CHF 4) and now all of
> >>>
> >> the
> >>
> >>> mail is being delivered.
> >>>
> >>> Is this a fluke?  Known issue?  Anything I can do to prevent it from
> >>> recurring?
> >>>
> >>> Thanks!
> >>>
> >>>
> >>>
> >>
> >>
> >
> >
>
> 

~|
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:328984
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: C:\ColdFusion8\Mail\Spool

[Bobby]

The same thing has happened to use before. I never found any logs 
indicating the cause and a service restart prompted the spooled emails 
to start sending again.

It was just one of the few reasons we put all of our servers on a weekly 
reboot schedule.


John M Bliss wrote:
>> Typically you'll see an error in your ColdFusion mail.log file that will
>> 
> state that the connection to your mail server failed at some point.
>
> That didn't happen in this case.
>
>
> On Tue, Dec 8, 2009 at 8:04 AM, Cutter (ColdFusion) <
> cold.fus...@cutterscrossing.com> wrote:
>
>   
>> See if this might help you:
>>
>>
>> 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
>>
>>
>>
>> John M Bliss wrote:
>> 
>>> So this AM, my production server had not sent me my usual batch of emails
>>> (via cfmail).  I went to Server Settings > Mail, checked Verify mail
>>>   
>> server
>> 
>>> connection, clicked Submit Changes, and received Connection Verification
>>> Successful.  I stopped and restarted my SMTP server and then noticed that
>>> email I was expecting to receive was sitting in
>>>   
>> C:\ColdFusion8\Mail\Spool.
>> 
>>> I stopped and restarted the CF server (CF 8 with CHF 4) and now all of
>>>   
>> the
>> 
>>> mail is being delivered.
>>>
>>> Is this a fluke?  Known issue?  Anything I can do to prevent it from
>>> recurring?
>>>
>>> Thanks!
>>>
>>>
>>>   
>>
>> 
>
> 

~|
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:328983
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Reading Microsoft "smart" quotes with CFFILE

[Robert Harrison]

Replace them in a var before trying to do anything with them:
#ReplaceList(trim(YOURCONTENT), "’,…,“,” ","'',...,"","" ")#



Robert B. Harrison
Director of Interactive Services
Austin & Williams
125 Kennedy Drive, Suite 100 
Hauppauge NY 11788
P : 631.231.6600 Ext. 119 
F : 631.434.7022
http://www.austin-williams.com 

Great advertising can't be either/or.  It must be &.

Plug in to our blog: A&W Unplugged
http://www.austin-williams.com/unplugged


-Original Message-
From: Mosh Teitelbaum [mailto:mosh.teitelb...@evoch.com] 
Sent: Tuesday, December 08, 2009 4:11 PM
To: cf-talk
Subject: Reading Microsoft "smart" quotes with CFFILE


All:

 

I’m trying to read content from an XML file stored on disk, fiddle with it,
and save it to a database.  It all works fine except for when the content
includes smart-quotes (the XML file is a spreadsheet exported from MS Excel
to “XML Spreadsheet 2003” format).  When I use CFFILE to read the XML file,
without specifying a character set, the smart quotes get turned into 3 other
characters.  For example, an opening quote (ASC value of 8220) gets turned
into “ï¿ ½” (239-191-189).  When I specify a character set, I either get the
same results or, using “utf-8”, I get a single, unprintable character with
an ASC value of 65533, regardless of what the starting character actually
was.

 

If I enter the offending string directly into my CF code, or into a textarea
in a form, the string is read as expected.  It’s only a problem when the
string is read via CFFILE.

 

Any suggestions on what character set I should use or, barring that, another
means of reading the content from the disk?

 

TIA

 

--

Mosh Teitelbaum

evoch, LLC

http://www.evoch.com/



~|
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:328982
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Reading Microsoft "smart" quotes with CFFILE

[Mosh Teitelbaum]

All:

 

I’m trying to read content from an XML file stored on disk, fiddle with it,
and save it to a database.  It all works fine except for when the content
includes smart-quotes (the XML file is a spreadsheet exported from MS Excel
to “XML Spreadsheet 2003” format).  When I use CFFILE to read the XML file,
without specifying a character set, the smart quotes get turned into 3 other
characters.  For example, an opening quote (ASC value of 8220) gets turned
into “ï¿ ½” (239-191-189).  When I specify a character set, I either get the
same results or, using “utf-8”, I get a single, unprintable character with
an ASC value of 65533, regardless of what the starting character actually
was.

 

If I enter the offending string directly into my CF code, or into a textarea
in a form, the string is read as expected.  It’s only a problem when the
string is read via CFFILE.

 

Any suggestions on what character set I should use or, barring that, another
means of reading the content from the disk?

 

TIA

 

--

Mosh Teitelbaum

evoch, LLC

http://www.evoch.com/

~|
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:328981
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Possible thread issue?

[Jaime Metcher]

Andre,

Is this DAO a singleton?  I notice the queries aren't var scoped.  If this
is a singleton under load another thread could easily overwrite your
trans_insert variable in between issuing the query and logging the generated
key.

Jaime

On Tue, Dec 8, 2009 at 8:58 PM, Andre Kapp  wrote:

>
> Ok - changed the pk id field returned to the following:
>  
>
> Still the same issue.
>
>
> Here is the complete cfc module sorry for it being a bit long...
>
> 
>
> returntype="moneymaker.core.model.trans.TransDAO" output="false">
> type="moneymaker.core.model.DatasourceSettings" required="true"/>
>
>
> application.serviceFactory.getBean("AccountService")>
>
>
>
> displayname="fetch">
>
>
>
>
>
>
>
>
>
>
>
> default="" />
>
>
>
>
>
>
>
> variables.accountService.getAccountBalance("available", arguments.acctid)>
> variables.accountService.getAccountBalance("actual", arguments.acctid)>
> numberformat(theCurrentAvailableBalance, "_.__") +
> numberformat(arguments.amount, "_.__")>
> numberformat(theCurrentActualBalance, "_.__") +
> numberformat(arguments.amount, "_.__")>
> numberformat(theCurrentActualBalance, "_.__") +
> numberformat(arguments.amount, "_.__")>
>
>
>
>
>
>
>
>SELECT *
>FROM card
>WHERE card_id =  value="#arguments.cardid#">
>
>
>
>
>
>
> file="closed_card_loads" type="Information">
>
> "D98">
>
> "D98">
>
>
> message="Error 62: Card is restricted">
>
>
>
>
> cardcheck.bin_prog_link_id EQ 9>
>
>update card
>set status_id = 1
>where card_id =  cfsqltype="CF_SQL_NUMERIC" value="#arguments.cardid#">
>
>
>
>
> text="#cfcatch.toString()#--#cardcheck.card_cardnumber#"
> file="activate_on_load_error" type="Error">
>
>
>
>
>
>
>
>
>
>
>
> datasource="#variables.dsn#">
>SELECT trans_id
>FROM trans
>WHERE
>trans_api_tracenumber =  cfsqltype="cf_sql_varchar" value="#arguments.tracenumber#"> AND
>card_id =  value="#arguments.cardid#"> AND
>status_id =  value="6">
>
>
> message="Error 61: Duplicate Transaction Attempt">
>
>
>
>
>
>
> numberformat(arguments.amount, "_.__") GT
> numberformat(stLimits.loads.per_load_limit, "_.__")>
>
>
>
>
>
>
>
>
> datepart('m',now()), 1)>
> datepart('m',now()), daysinmonth(now()))>
> datasource="#variables.dsn#">
>SELECT
>
>  IF(ISNULL(SUM(trans_amount)),0,SUM(trans_amount)) AS monthlysum
>FROM
>trans
>WHERE
> acct_id = #arguments.acctid# AND
> trans_transaction_type = 'L99' AND
> status_id = 6 AND
> trans_datetime >=  cfsqltype="cf_sql_varchar" value="#DateFormat(startdttm, '-mm-dd')#
> 00:00:00"> AND
> trans_datetime <=  cfsqltype="cf_sql_varchar" value="#DateFormat(enddttm, '-mm-dd')#
> 23:59:59">
>
>
> arguments.amount, "_.__")>
>
>
> "_.__")>
>
>
>
>
>
>
>
>
>
>
> result="trans_insert_res">
>INSERT INTO trans (
>acct_id,
>card_id,
>trans_pan,
>trans_amount,
> 

Re: CF8 / Windows 7 - ODBC services not starting

[Mike Purrington]

>What does the event viewer say about this error?

Here is the error form the event viewer...

The description for Event ID 0 from source ColdFusion 8 ODBC Agent cannot be 
found. Either the component that raises this event is not installed on your 
local computer or the installation is corrupted. You can install or repair the 
component on the local computer.

If the event originated on another computer, the display information had to be 
saved with the event.

The following information was included with the event: 

ColdFusion 8 ODBC 
ag...@localhost,ErrorCode=3005,ErrorMessage=sched.swschd.3954.Internal error, 
fatal server error detected.



Dave - I have not tried un/reinstalling yet, but that is my next step.


Thanks for the help.



~|
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:328979
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 Server question re table names

[Leigh]

I have only seen that with exports from MS Access. 

Yes, +1 about using the information INFORMATION_SCHEMA views. Tapping into the 
system views is my favorite way to generate mass statements on-the-fly ;-)

DECLARE @DBPrefix VARCHAR(50)
SET @DBPrefix = 'oldabc.'

SELECT  'exec sp_rename @objname=''['+ TABLE_NAME +']'', @newname = '''+ 
SUBSTRING(TABLE_NAME , LEN(@DBPrefix)+1, LEN(TABLE_NAME)) +
FROMINFORMATION_SCHEMA.TABLES
WHERE   TABLE_NAME LIKE @DBPrefix +'_%'

-Leigh


  

~|
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:328978
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CF8 / Windows 7 - ODBC services not starting

[Dave Watts]

> Am I really the only one here with this configuration?  I'm just wondering if 
> it's been done before or if it's a lost cause.  Should I
> just bite the bullet and upgrade to CF9 - I hesitate because our production 
> environment is running all CF8 - I don't want to do that
> if there is just a configuration setting I'm missing somewhere.

Have you tried manually uninstalling and reinstalling just the ODBC services?

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 informatio

~|
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:328977
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: CF8 Settings: Large upload failure

[Robert Harrison]

> I'm sure you probably did, but did you restart ColdFusion after changing
the settings?

Thanks. Yes we restarted CF. That did not do it... but we did solve it.
Strangely, restarting IIS got it to reset.  Maybe there is some hook between
the IIS and CFsettings that I'm not aware of. 

Regardless, problem solved.


Robert B. Harrison
Director of Interactive Services
Austin & Williams
125 Kennedy Drive, Suite 100 
Hauppauge NY 11788
P : 631.231.6600 Ext. 119 
F : 631.434.7022
http://www.austin-williams.com 

Great advertising can't be either/or.  It must be &.

Plug in to our blog: A&W Unplugged
http://www.austin-williams.com/unplugged

 

__ Information from ESET Smart Security, version of virus signature
database 4671 (20091208) __

The message was checked by ESET Smart Security.

http://www.eset.com
 

~|
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:328976
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CF8 / Windows 7 - ODBC services not starting

[Matthew Small]

What does the event viewer say about this error?


> I'm getting the "The service started then stopped" error when I try to 
> start my CF 8 ODBC services in Windows 7 32-bit.  I've done a lot of 
> searching for this issue, and have found a number of people who have 
> had issues with ODBC on Windows Server 2008 64-bit, but nothing really 
> on a 32-bit system.  Obviously, this isn't a server enviroment, this 
> is my development PC so it's running the developer version of CF8.
> 
> Do other people have this running?  If so, do I need to do something 
> special to get it to work, or is my problem unique? 


~|
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:328975
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 Server question re table names

[brad]

I can't say I've ever seen that one before, but you could just do a loop
over the contents of INFORMATION_SCHEMA.TABLES and build/exec an ALTER
statement for each one.

http://technet.microsoft.com/en-us/library/ms190273.aspx

How many tables are there?  If there are under 75, you might be just as
fast renaming them them by hand.

~Brad


 Original Message 
Subject: SQL Server question re table names
From: "Larry Soo" 
Date: Tue, December 08, 2009 1:45 pm
To: cf-talk 


A client asked me to see if I could get a copy of his old web site up
and 
running. I did a restore of the backed up database onto my PC. The 
problem is that all the table names have the name of the database
prepended 
to them.



~|
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:328974
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: CF8 Settings: Large upload failure

[Josh Nathanson]

I'm sure you probably did, but did you restart ColdFusion after changing the
settings?

-- Josh


-Original Message-
From: Robert Harrison [mailto:rob...@austin-williams.com] 
Sent: Tuesday, December 08, 2009 9:20 AM
To: cf-talk
Subject: CF8 Settings: Large upload failure


Simplified version.

In CFServer Settings we set:

  Maximum size of post data  1500 MB

Any time we try to upload a file more than 100Mb we get JS thread dump:

  ROOT CAUSE: 
 
coldfusion.filter.RequestThrottleFilter$PostSizeLimitExceededException: Post
  Size exceeds the maximum limit.

Any ideas on why CF is ignoring the settings?


Robert B. Harrison
Director of Interactive Services
Austin & Williams
125 Kennedy Drive, Suite 100 
Hauppauge NY 11788
P : 631.231.6600 Ext. 119 
F : 631.434.7022
http://www.austin-williams.com 

Great advertising can't be either/or.  It must be &.

Plug in to our blog: A&W Unplugged
http://www.austin-williams.com/unplugged


 

__ Information from ESET Smart Security, version of virus signature
database 4670 (20091208) __

The message was checked by ESET Smart Security.

http://www.eset.com
 



~|
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:328973
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CF8 / Windows 7 - ODBC services not starting

[Mike Purrington]

Am I really the only one here with this configuration?  I'm just wondering if 
it's been done before or if it's a lost cause.  Should I just bite the bullet 
and upgrade to CF9 - I hesitate because our production environment is running 
all CF8 - I don't want to do that if there is just a configuration setting I'm 
missing somewhere.


~|
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:328972
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

SQL Server question re table names

[Larry Soo]

A client asked me to see if I could get a copy of his old web site up and 
running.  I did a restore of the backed up database onto my PC.  The 
problem is that all the table names have the name of the database prepended 
to them.

When I view the tables in SQL Server Manager, the table, "city", is named 
"abc.city", where oldabc is the name of the database from which the data 
was backed up from.  For the sake of this example, "newabc" is the database 
name I used on my own machine, to which the backup data was restored to.

So, is there an easy way to rename all those tables?

I know this is a problem because when I tested the app, it immediately 
threw an error because its cfquery statements were referring to table names 
with the database name prepended to them (ie: SELECT * FROM city, instead 
of SELECT * FROM oldabc.city).

Thanks in advance for your help.

...lars


~|
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:328971
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CF8 / IIS7 / ColdFusion.Ajax.submitForm/errorhandler not working

[Matthew Small]

No, there are different 500 errors returned per application server.  CF could 
handle any processing problems and return an HTTP 500 with its own custom 
messages if it wanted to, which would still be a normal processed request 
routed through IIS.  An IIS 500 would be returned if the CF engine or some 
other component were to encounter an unhandled exception which prevents the 
full execution of the the component.  That's why I ask if the 500 is a CF 500 
or an IIS 500.  

> > That begs the question - is this an IIS 500 or a CF 500?  I imagine 
> they look a lot different.
> 
> I think that it's the job of the application server to provide error
> information, generally, so 500 errors will depend on the specific
> application server. If you just have static content, you don't get 
> 500
> errors, so I don't think there's really an "IIS" 500 error. There are,
> 
> of course, standard error messages for ASP.NET and "classic" ASP 500
> errors.
> 
> 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:328970
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: cfdocument not working in ie

[Dave Watts]

> we have a cfdocument and works fine in firefox but when trying to view in 
> internet explorer it only shows characters e.g. � [�ˏ
> �� �C��_>�y�l�fS�6 (������{� ( 
>D�.�X�>1� �������

If you reload the page in IE immediately after this, does it work then?

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:328969
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: cfdocument not working in ie

[Claude Schneegans]

 >>thanks for your help

You would have better help if you show us your CFDOCUMENT tag.

~|
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:328968
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: cfselect url bind

[Azadi Saryev]

you can specify which event triggers the binding by including
@[event-name] in the binding parameter:
{y...@change} for example will trigger the binding when the value of
year field changes.

you can also specify @none to prevent the field triggering the binding,
but still use the field's value as parameter.
i think in your case, when you need to make sure all 3 fields used in
the binding have a value entered/selected, it may be better to:
1) add a button to the form which will trigger the binding ()
2) change the 3 fields you use in the binding to add @none to the triggers
3) add the above button as 4th binding param with @click event - thus
only the click of the button will trigger the binding

hth

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


On 09/12/2009 00:00, Sean Sekora wrote:
> I have the following cfselect
>
>  bind="url:lookup.cfc?method=getType&year={year}&make={make}&model={model}" 
> bindonload="false" />
>
> Is there a way to prevent the lookup from being executed until all the 
> required values have been set? 
>
> 

~|
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:328967
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: ColdFusion.Window.create set bodystyle attribute

[Bruno Nunes]

Same for me. No matter what i do the style is always ugly gray. did you find a 
solution for this?

thanks

Bruno


>Hmmm.. The background color is gray by default on my machine for whatever
>reason.  Also, for some reason, the headerstyle attribute works, but the
>bodystyle attribute does not.  I'll play around with it some more and see if
>I can get it to work.
>
>
>this code worked fine for me - a cfwindow with blindingly blue background
>popped up:
>
>  doWindow = function() {
>var wConfig = new Object();
>wConfig.bodystyle = "background-color: blue"; //changed it to 'blue'
>wConfig.center = true; //center the window on page
>ColdFusion.Window.create('mywin', 'test window', 'some-page.cfm',
>wConfig); //change some-page.cfm to your url }  onload="doWindow();"> 
>
>Azadi Saryev
>Sabai-dee.com
>http://www.sabai-dee.com/
>
>
>On 13/11/2009 08:15, Joshua Rowe wrote:
>> How do I set the bodystyle attribute for the ColdFusion.Window.create()
>function?  I tried creating a JavaScript object like so, but it didn't work:
>>
>> var windowConfig = new Object();
>> windowConfig.bodystyle = "background-color: white;"; 
>> ColdFusion.Window.create(name, title, url, windowConfig);
>>
>> I read somewhere that you cannot set the bodystyle attribute when creating
>a cfwindow this way.  Any thoughts? 
>>
>> 

~|
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:328966
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

cfdocument not working in ie

[Richard White]

hi 

we have a cfdocument and works fine in firefox but when trying to view in 
internet explorer it only shows characters e.g. �[�ˏ 
���C��_>�y�l�fS�6(������{�(D�.�X�>1��������

we have tried in pdf and flashpaper with the same results

thanks for your help

richard

~|
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:328965
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CFLDAP & SSL

[Dave Watts]

> All attributes are correct and for testing I'm attempting a simple query
> with * for attributes and maxrows of 10.  Snippet below.  Everything is
> straight from the IT staff that controls the LDAP server.  I read this
> article: http://kb2.adobe.com/cps/191/tn_19139.html#enableCF which stated
> that you have to install the certificate of the remote LDAP server in the CF
> local keystore.  Is that true?  Is that the only way?

Yeah, that's the only way. That's how SSL works. You need to have a
trusted local cert to validate the remote cert. That's how it works in
a browser, too.

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 informa

~|
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:328964
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

CF8 Settings: Large upload failure

[Robert Harrison]

Simplified version.

In CFServer Settings we set:

  Maximum size of post data  1500 MB

Any time we try to upload a file more than 100Mb we get JS thread dump:

  ROOT CAUSE: 
 
coldfusion.filter.RequestThrottleFilter$PostSizeLimitExceededException: Post
  Size exceeds the maximum limit.

Any ideas on why CF is ignoring the settings?


Robert B. Harrison
Director of Interactive Services
Austin & Williams
125 Kennedy Drive, Suite 100 
Hauppauge NY 11788
P : 631.231.6600 Ext. 119 
F : 631.434.7022
http://www.austin-williams.com 

Great advertising can't be either/or.  It must be &.

Plug in to our blog: A&W Unplugged
http://www.austin-williams.com/unplugged


 

__ Information from ESET Smart Security, version of virus signature
database 4670 (20091208) __

The message was checked by ESET Smart Security.

http://www.eset.com
 

~|
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:328963
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Check Boxes

[Won Lee]

On Tue, Dec 8, 2009 at 11:53 AM, Damo Drumm wrote:

>
> The company table represents the seller, and the Customer table represents
> the individual Buyers.
> Invoice_Number is unique but I also have INVOICE_Key in the INVOICE table
>
>
If that is the case then the query should work

COMPANY <-> INVOICE <-> CUSTOMER

This is how the information is joined.


~|
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:328962
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Check Boxes

[Damo Drumm]

The company table represents the seller, and the Customer table represents the 
individual Buyers.
Invoice_Number is unique but I also have INVOICE_Key in the INVOICE table 

~|
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:328961
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

CFLDAP & SSL

[Jake Churchill]

I'm working on an SSL integration of CFLDAP for a client and am consistently
getting "Connection to LDAP server failed."

All attributes are correct and for testing I'm attempting a simple query
with * for attributes and maxrows of 10.  Snippet below.  Everything is
straight from the IT staff that controls the LDAP server.  I read this
article: http://kb2.adobe.com/cps/191/tn_19139.html#enableCF which stated
that you have to install the certificate of the remote LDAP server in the CF
local keystore.  Is that true?  Is that the only way?

Here's that snippet:




~|
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:328960
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

CF8 Settings: Large upload failure

[Robert Harrison]

We just moved our site from one CF8 server to a new CF8 server.  We have an
extranet and upload some very large files (up to 1Gb). We keep getting the
message below.
 
We already changed set the CFsettings to:
 
Maximum size of post data  1500 MB
Request Throttle Threshold  4 MB
Request Throttle Memory  1500 MB
 
Anyone have any idea why CF is failing? It's still setting a limit of 100Mb,
but that is not what we have set.
 
500 
ROOT CAUSE: 
coldfusion.filter.RequestThrottleFilter$PostSizeLimitExceededException: Post
Size exceeds the maximum limit.
at
coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:11
2)
at coldfusion.CfmServlet.service(CfmServlet.java:175)
at
coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
at
coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletF
ilter.java:42)
at
coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
at jrun.servlet.FilterChain.service(FilterChain.java:101)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
at
jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)
at
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:
320)
at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428
)
at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:26
6)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
 
javax.servlet.ServletException: ROOT CAUSE: 
coldfusion.filter.RequestThrottleFilter$PostSizeLimitExceededException: Post
Size exceeds the maximum limit.
at
coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:11
2)
at coldfusion.CfmServlet.service(CfmServlet.java:175)
at
coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
at
coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletF
ilter.java:42)
at
coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
at jrun.servlet.FilterChain.service(FilterChain.java:101)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
at
jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)
at
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:
320)
at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428
)
at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:26
6)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
 
at
coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletF
ilter.java:70)
at
coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
at jrun.servlet.FilterChain.service(FilterChain.java:101)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
at
jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)
at
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:
320)
at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428
)
at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:26
6)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
 
 
 
 
 

Robert B. Harrison
Director of Interactive Services
Austin & Williams
125 Kennedy Drive, Suite 100 
Hauppauge NY 11788
P : 631.231.6600 Ext. 119 
F : 631.434.7022
  http://www.austin-williams.com 


Great advertising can't be either/or.  It must be &.

Plug in to our blog: A&W Unplugged
 
http://www.austin-williams.com/unplugged
 
 



~

Re: cfselect url bind

[Won Lee]

On Tue, Dec 8, 2009 at 11:00 AM, Sean Sekora  wrote:

>
> I have the following cfselect
>
>  bind="url:lookup.cfc?method=getType&year={year}&make={make}&model={model}"
> bindonload="false" />
>
> Is there a way to prevent the lookup from being executed until all the
> required values have been set?
>
>
The workaround that comes to mind is to disable the select until the other
form elements are populated.  Perhaps someone else can give a more elegant
solution.


~|
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:328958
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

cfselect url bind

[Sean Sekora]

I have the following cfselect



Is there a way to prevent the lookup from being executed until all the required 
values have been set? 

~|
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:328957
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Check Boxes

[Won Lee]

On Tue, Dec 8, 2009 at 10:35 AM, Damo Drumm wrote:

>
> This was what i meant to put in instead of qgetcustomer query
> So am I still missing a join somewhere
>
> 
>
>select COMPANY_Number, INVOICE_Number, CUSTOMER_AccNum
>from INVOICE
>where INVOICE_Key = #url.invoice#
>
>
>
> 
>
>
based on the code you sent me, yes I believe you are still missing a join
in qgetinvoices


select I.INVOICE_DateAdded, I.COMPANY_Number, I.INVOICE_Number,
C.COMPANY_Name, I.INVOICE_Key, I.CUSTOMER_AccNum, CU.CUSTOMER_Name
from INVOICE I, COMPANY C, CUSTOMER CU
where I.COMPANY_Number = C.COMPANY_Number and CU.invoice_number =
I.invoice_number



This all depends if invoice_number is unique in the invoice table.  if it
isn't then you have more work to do.  If so, this is the basic query.  Then
you can add in more conditions to the where clause get only the results you
want.

In this schema, what does the company represent?  the seller, the buyer,
both?  Is the customer an individual or a company?  if it is a company why
are there to separate tables?  Not saying any of your schema is incorrect.
 Just relevant information to try help you.  Even if there was something
wrong with the schema not sure you could even change it right now.


~|
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:328956
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Check Boxes

[Damo Drumm]

This was what i meant to put in instead of qgetcustomer query
So am I still missing a join somewhere



select COMPANY_Number, INVOICE_Number, CUSTOMER_AccNum
from INVOICE
where INVOICE_Key = #url.invoice#



 

~|
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:328955
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Check Boxes

[Won Lee]

>
>
> 
> select I.INVOICE_DateAdded, I.COMPANY_Number, I.INVOICE_Number,
> C.COMPANY_Name, I.INVOICE_Key, I.CUSTOMER_AccNum, CU.CUSTOMER_Name
> from INVOICE I, COMPANY C, CUSTOMER CU
> where I.COMPANY_Number = C.COMPANY_Number
> AND I.COMPANY_Number = '#form.COMPANY_Number#'
> AND I.INVOICE_Number LIKE '%#form.INVOICE_Number#%'
> AND I.CUSTOMER_AccNum LIKE '%#form.CUSTOMER_AccNum#%'
> AND CU.CUSTOMER_Name LIKE '%#form.CUSTOMER_Name#%'
> AND I.INVOICE_PDFFile <> ''
> 
>
>
This query looks like it gets the results for your search.

You have 3 tables: invoice, company, and customer.  You join the invoice
table and the company table via the SQL, I.COMPANY_Number =
C.COMPANY_Number.
Unfortunately you do not join customer table to the other 2 tables.  This is
why you are always getting more results than you want.  You need to join the
invoice table to the customer table.


the top half of your code looks like it was not a full cut and paste.  If it
was then it really doesn't make any sense.  What is the query, qgetcustomer,
being used for?


~|
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:328954
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Check Boxes

[Damo Drumm]

Heres the code im using


SELECT invoice.*, customer.CUSTOMER_Name
FROM invoice left join customer
on invoice.CUSTOMER_AccNum = customer.CUSTOMER_AccNum;


   


Invoice Number : 
Customer Number : 
Customer Name : 







Your Search has returned 0 results


select I.INVOICE_DateAdded, I.COMPANY_Number, I.INVOICE_Number, C.COMPANY_Name, 
I.INVOICE_Key, I.CUSTOMER_AccNum, CU.CUSTOMER_Name
from INVOICE I, COMPANY C, CUSTOMER CU
where I.COMPANY_Number = C.COMPANY_Number
AND I.COMPANY_Number = '#form.COMPANY_Number#'
AND I.INVOICE_Number LIKE '%#form.INVOICE_Number#%'
AND I.CUSTOMER_AccNum LIKE '%#form.CUSTOMER_AccNum#%'
AND CU.CUSTOMER_Name LIKE '%#form.CUSTOMER_Name#%'
AND I.INVOICE_PDFFile <> ''
 

~|
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:328953
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Check Boxes

[Won Lee]

On Tue, Dec 8, 2009 at 9:27 AM, Damo Drumm wrote:

>
> Hi
> can someone help me out here, Im trying to have a check box for each
> invoice so when its ticked and you press submit all the ticked invoices will
> be sent to the revelant email address,
> I'm trying to have it so the check boxes will be defaulted to ticked if the
> customer Number for the invoice, is in the Customer Table, The next problem
> I have is for each Customer I add to the Customer Table its duplicating the
> Data and showing everything twice if theres 2 Customers. or 3 times if
> theres 3 Customers added and so on, I cant seem to figure out why its doing
> this
>
> any tips would be great


1) only send email to customers who have a checkbox next to them

one way would be to  for
each record the on the action page loop around the list of IDs and send the
emails.

2) have the checkbox defaulted to checked

use a checked 

3) Looks like you have a Cartesian join.  You need to edit your SQL query.

Without any code these are my best guesses.

W


~|
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:328952
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Check Boxes

[Charlie Griefer]

Showing code would be a good first step...

On Tue, Dec 8, 2009 at 6:27 AM, Damo Drumm wrote:

>
> Hi
> can someone help me out here, Im trying to have a check box for each
> invoice so when its ticked and you press submit all the ticked invoices will
> be sent to the revelant email address,
> I'm trying to have it so the check boxes will be defaulted to ticked if the
> customer Number for the invoice, is in the Customer Table, The next problem
> I have is for each Customer I add to the Customer Table its duplicating the
> Data and showing everything twice if theres 2 Customers. or 3 times if
> theres 3 Customers added and so on, I cant seem to figure out why its doing
> this
>
> any tips would be great
>
> 

~|
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:328951
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Check Boxes

[Damo Drumm]

Hi
can someone help me out here, Im trying to have a check box for each invoice so 
when its ticked and you press submit all the ticked invoices will be sent to 
the revelant email address,
I'm trying to have it so the check boxes will be defaulted to ticked if the 
customer Number for the invoice, is in the Customer Table, The next problem I 
have is for each Customer I add to the Customer Table its duplicating the Data 
and showing everything twice if theres 2 Customers. or 3 times if theres 3 
Customers added and so on, I cant seem to figure out why its doing this

any tips would be great 

~|
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:328950
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: C:\ColdFusion8\Mail\Spool

[John M Bliss]

> Typically you'll see an error in your ColdFusion mail.log file that will
state that the connection to your mail server failed at some point.

That didn't happen in this case.


On Tue, Dec 8, 2009 at 8:04 AM, Cutter (ColdFusion) <
cold.fus...@cutterscrossing.com> wrote:

>
> See if this might help you:
>
>
> 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
>
>
>
> John M Bliss wrote:
> > So this AM, my production server had not sent me my usual batch of emails
> > (via cfmail).  I went to Server Settings > Mail, checked Verify mail
> server
> > connection, clicked Submit Changes, and received Connection Verification
> > Successful.  I stopped and restarted my SMTP server and then noticed that
> > email I was expecting to receive was sitting in
> C:\ColdFusion8\Mail\Spool.
> > I stopped and restarted the CF server (CF 8 with CHF 4) and now all of
> the
> > mail is being delivered.
> >
> > Is this a fluke?  Known issue?  Anything I can do to prevent it from
> > recurring?
> >
> > Thanks!
> >
> >
>
>
> 

~|
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:328949
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: C:\ColdFusion8\Mail\Spool

[Cutter (ColdFusion)]

See if this might help you:

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



John M Bliss wrote:
> So this AM, my production server had not sent me my usual batch of emails
> (via cfmail).  I went to Server Settings > Mail, checked Verify mail server
> connection, clicked Submit Changes, and received Connection Verification
> Successful.  I stopped and restarted my SMTP server and then noticed that
> email I was expecting to receive was sitting in C:\ColdFusion8\Mail\Spool.
> I stopped and restarted the CF server (CF 8 with CHF 4) and now all of the
> mail is being delivered.
>
> Is this a fluke?  Known issue?  Anything I can do to prevent it from
> recurring?
>
> Thanks!
>
>   


~|
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:328948
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: \ColdFusion8\Mail\Spool

[John M Bliss]

Nothing since Oct 16.

On Tue, Dec 8, 2009 at 7:30 AM, Dave Phillips <
experiencedcfdevelo...@gmail.com> wrote:

>
> John,
>
> Anything revealing in your mail log?  I've seen this behavior before, but
> not with CF 8. It was with older versions.  We ended up scheduling a
> nightly
> restart of the service to alleviate things like this occurring.
>
> Dave Phillips
>
> -Original Message-
> From: John M Bliss [mailto:bliss.j...@gmail.com]
> Sent: Tuesday, December 08, 2009 7:17 AM
> To: cf-talk
> Subject: C:\ColdFusion8\Mail\Spool
>
>
> So this AM, my production server had not sent me my usual batch of emails
> (via cfmail).  I went to Server Settings > Mail, checked Verify mail server
> connection, clicked Submit Changes, and received Connection Verification
> Successful.  I stopped and restarted my SMTP server and then noticed that
> email I was expecting to receive was sitting in C:\ColdFusion8\Mail\Spool.
> I stopped and restarted the CF server (CF 8 with CHF 4) and now all of the
> mail is being delivered.
>
> Is this a fluke?  Known issue?  Anything I can do to prevent it from
> recurring?
>
> Thanks!
>
> --
> John Bliss
> IT Professional
> @jbliss (t) / http://www.brandiandjohn.com
>
>
>
>
> 

~|
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:328947
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: \ColdFusion8\Mail\Spool

[Dave Phillips]

John,

Anything revealing in your mail log?  I've seen this behavior before, but
not with CF 8. It was with older versions.  We ended up scheduling a nightly
restart of the service to alleviate things like this occurring.

Dave Phillips

-Original Message-
From: John M Bliss [mailto:bliss.j...@gmail.com] 
Sent: Tuesday, December 08, 2009 7:17 AM
To: cf-talk
Subject: C:\ColdFusion8\Mail\Spool


So this AM, my production server had not sent me my usual batch of emails
(via cfmail).  I went to Server Settings > Mail, checked Verify mail server
connection, clicked Submit Changes, and received Connection Verification
Successful.  I stopped and restarted my SMTP server and then noticed that
email I was expecting to receive was sitting in C:\ColdFusion8\Mail\Spool.
I stopped and restarted the CF server (CF 8 with CHF 4) and now all of the
mail is being delivered.

Is this a fluke?  Known issue?  Anything I can do to prevent it from
recurring?

Thanks!

-- 
John Bliss
IT Professional
@jbliss (t) / http://www.brandiandjohn.com




~|
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:328946
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

C:\ColdFusion8\Mail\Spool

[John M Bliss]

So this AM, my production server had not sent me my usual batch of emails
(via cfmail).  I went to Server Settings > Mail, checked Verify mail server
connection, clicked Submit Changes, and received Connection Verification
Successful.  I stopped and restarted my SMTP server and then noticed that
email I was expecting to receive was sitting in C:\ColdFusion8\Mail\Spool.
I stopped and restarted the CF server (CF 8 with CHF 4) and now all of the
mail is being delivered.

Is this a fluke?  Known issue?  Anything I can do to prevent it from
recurring?

Thanks!

-- 
John Bliss
IT Professional
@jbliss (t) / http://www.brandiandjohn.com


~|
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:328945
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Possible thread issue?

[Andre Kapp]

Ok - changed the pk id field returned to the following:
 

Still the same issue.


Here is the complete cfc module sorry for it being a bit long...











































SELECT *
FROM card
WHERE card_id = 




















update card
set status_id = 1
where card_id = 

















SELECT trans_id
FROM trans
WHERE
trans_api_tracenumber =  AND
card_id =  AND
status_id = 





















SELECT
IF(ISNULL(SUM(trans_amount)),0,SUM(trans_amount)) 
AS monthlysum
FROM
trans
WHERE
 acct_id = #arguments.acctid# AND
 trans_transaction_type = 'L99' AND
 status_id = 6 AND
 trans_datetime >=  AND
 trans_datetime <= 

















INSERT INTO trans (
acct_id,
card_id,
trans_pan,
trans_amount,
trans_response_code,
trans_begin_balance,
trans_end_balance,
trans_transaction_type,
trans_message_type,
trans_description,
trans_datetime,
trans_api_tracenumber,
status_id
) VALUES (
,
,
,
,
,
,
,
,
,
,
NOW(),
,

)











UPDATE acct_balances
SET
acct_balance = acct_balance + #arguments.amount#,
acct_balance_available = acct_balance_available + 
#arguments.amount#
WHERE
acct_id = 


   






UPDATE fees_collection
SET
settled = ,
settled_trans_id = ,
settled_dttm = NOW()
WHERE
acct_id =  AND
settled = 0