Re: Possible thread issue?

2009-12-08 Thread Andre Kapp

Ok - changed the pk id field returned to the following:
 cfset theTransID = trans_insert_res.GENERATED_KEY

Still the same issue.


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

cfcomponent displayname=TransDAO

cffunction name=init access=public 
returntype=moneymaker.core.model.trans.TransDAO output=false
cfargument name=datasourceSettings 
type=moneymaker.core.model.DatasourceSettings required=true/
cfset variables.dss = arguments.datasourceSettings /
cfset variables.dsn = variables.dss.getDatasourceName() /
cfset variables.accountService = 
application.serviceFactory.getBean(AccountService)
cfreturn this /
/cffunction

cffunction name=fetch access=public returntype=Trans 
displayname=fetch
/cffunction

cffunction name=process access=public returntype=struct

cfargument name=acctid required=Yes type=numeric /
cfargument name=cardid required=Yes type=numeric /
cfargument name=cardnumber required=Yes type=numeric /
cfargument name=amount required=Yes type=numeric /
cfargument name=type required=Yes type=string /
cfargument name=paytype required=Yes type=numeric /
cfargument name=description required=Yes type=string /
cfargument name=tracenumber required=no type=string default= /
cfargument name=stLimits required=Yes type=struct /

cfset var stTrans = structNew() /

cftry
cflog file=transdao_cfc text=Process tx for 
#cardnumber# type=information
!--- Get balance ---
cfset theCurrentAvailableBalance = 
variables.accountService.getAccountBalance(available, arguments.acctid)
cfset theCurrentActualBalance = 
variables.accountService.getAccountBalance(actual, arguments.acctid)
cfset theNewAvailableBalance = 
numberformat(theCurrentAvailableBalance, _.__) + 
numberformat(arguments.amount, _.__)
cfset theNewActualBalance = numberformat(theCurrentActualBalance, 
_.__) + numberformat(arguments.amount, _.__)
cfset theNewActualRunningBalance = 
numberformat(theCurrentActualBalance, _.__) + numberformat(arguments.amount, 
_.__)

!--- If debit, make sure there is enough funds ---

!---
2009-09-29 AJK
Changed this to enabled debit to push the account into 
negative.

cfif arguments.type IS D99 AND theNewAvailableBalance LT 0
cfthrow errorcode=51 detail=Insuffcient Funds 
message=Error 51: Card has insufficient funds
/cfif
---

!--- Check status of card/account ---
cfquery datasource=#variables.dsn# name=cardcheck
SELECT *
FROM card
WHERE card_id = cfqueryparam cfsqltype=CF_SQL_NUMERIC 
value=#arguments.cardid#
/cfquery


cfif cardcheck.status_id NEQ 1
cfswitch expression=#cardcheck.status_id#
!--- Closed account ---
cfcase value=3cflog text=closed 
card:#cardcheck.card_cardnumber# loaded for #arguments.amount# on 
#dateformat(now(), '-mm-dd')# #timeformat(now(), 'HH:mm:ss')# 
file=closed_card_loads type=Information/cfcase
!--- Lost Card ---
cfcase value=4cfif arguments.type NEQ D98cfthrow 
errorcode=41 detail=Lost Card message=Error 41: Card has been reported 
lost/cfif/cfcase
!--- Stolen Card ---
cfcase value=5cfif arguments.type NEQ D98cfthrow 
errorcode=43 detail=Stolen Card message=Error 43: Card has been reported 
stolen/cfif/cfcase
!--- Restricted Card ---
cfcase value=10
cfthrow errorcode=62 detail=Restricted Card 
message=Error 62: Card is restricted
/cfcase
!--- New Inactive Card ---
cfcase value=11
cftry
cfif cardcheck.card_type_id EQ 1 OR 
cardcheck.bin_prog_link_id EQ 9
cfquery datasource=#variables.dsn#
update card
set status_id = 1
where card_id = cfqueryparam 
cfsqltype=CF_SQL_NUMERIC value=#arguments.cardid#
/cfquery
cflog text=#cardcheck.card_cardnumber# 
activated on load file=activate_on_load type=Information
/cfif
cfcatch type=Any
cflog 
text=#cfcatch.toString()#--#cardcheck.card_cardnumber# 
file=activate_on_load_error 

C:\ColdFusion8\Mail\Spool

2009-12-08 Thread 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: \ColdFusion8\Mail\Spool

2009-12-08 Thread 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


Re: \ColdFusion8\Mail\Spool

2009-12-08 Thread 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: C:\ColdFusion8\Mail\Spool

2009-12-08 Thread 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: C:\ColdFusion8\Mail\Spool

2009-12-08 Thread 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


Check Boxes

2009-12-08 Thread 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: Check Boxes

2009-12-08 Thread Charlie Griefer

Showing code would be a good first step...

On Tue, Dec 8, 2009 at 6:27 AM, Damo Drumm damien.dr...@quinn-group.comwrote:


 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


Re: Check Boxes

2009-12-08 Thread Won Lee

On Tue, Dec 8, 2009 at 9:27 AM, Damo Drumm damien.dr...@quinn-group.comwrote:


 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 input type=checkbox name=sendEmail_customerID 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 cfif conditionchecked /cfif

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

2009-12-08 Thread Damo Drumm

Heres the code im using

cfquery name=qgetcustomer datasource=#request.dsn#
SELECT invoice.*, customer.CUSTOMER_Name
FROM invoice left join customer
on invoice.CUSTOMER_AccNum = customer.CUSTOMER_AccNum;
/cfquery

/select   

/td
tdInvoice Number : input type=text name=INVOICE_Number size=12/td
tdCustomer Number : input type=text name=CUSTOMER_AccNum size=12/td
tdCustomer Name : input type=text name=CUSTOMER_Name size=12/td
tdinput type=submit name=Findinvoices value=Find raquo; //td
/tr
/form
/table

cfif isdefined(form.COMPANY_Number)
cfif form.COMPANY_Number eq 
pYour Search has returned 0 results/p
cfelse
cfquery name=qgetinvoices datasource=#request.dsn#
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  ''
/cfquery 

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

2009-12-08 Thread Won Lee



 cfquery name=qgetinvoices datasource=#request.dsn#
 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  ''
 /cfquery


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

2009-12-08 Thread Damo Drumm

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

cfif isdefined(url.invoice)
cfquery name=qgetcompanyno datasource=#request.dsn#
select COMPANY_Number, INVOICE_Number, CUSTOMER_AccNum
from INVOICE
where INVOICE_Key = #url.invoice#
/cfquery
cfset form.INVOICE_Number = qgetcompanyno.INVOICE_Number
cfset form.COMPANY_Number = qgetcompanyno.COMPANY_Number
/cfif 

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

2009-12-08 Thread Won Lee

On Tue, Dec 8, 2009 at 10:35 AM, Damo Drumm damien.dr...@quinn-group.comwrote:


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

 cfif isdefined(url.invoice)
cfquery name=qgetcompanyno datasource=#request.dsn#
select COMPANY_Number, INVOICE_Number, CUSTOMER_AccNum
from INVOICE
where INVOICE_Key = #url.invoice#
/cfquery
cfset form.INVOICE_Number = qgetcompanyno.INVOICE_Number
cfset form.COMPANY_Number = qgetcompanyno.COMPANY_Number
 /cfif


based on the code you sent me, yes I believe you are still missing a join
in qgetinvoices

cfquery name=qgetinvoices datasource=#request.dsn#
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
/cfquery


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


cfselect url bind

2009-12-08 Thread Sean Sekora

I have the following cfselect

cfselect name=type 
bind=url:lookup.cfc?method=getTypeyear={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: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: cfselect url bind

2009-12-08 Thread Won Lee

On Tue, Dec 8, 2009 at 11:00 AM, Sean Sekora seansek...@gmail.com wrote:


 I have the following cfselect

 cfselect name=type
 bind=url:lookup.cfc?method=getTypeyear={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


CF8 Settings: Large upload failure

2009-12-08 Thread 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/ http://www.austin-williams.com 


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

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




CFLDAP SSL

2009-12-08 Thread 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:

cfldap
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:328960
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

2009-12-08 Thread 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


Re: Check Boxes

2009-12-08 Thread Won Lee

On Tue, Dec 8, 2009 at 11:53 AM, Damo Drumm damien.dr...@quinn-group.comwrote:


 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


CF8 Settings: Large upload failure

2009-12-08 Thread 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: AW 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: CFLDAP SSL

2009-12-08 Thread 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


cfdocument not working in ie

2009-12-08 Thread 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: ColdFusion.Window.create set bodystyle attribute

2009-12-08 Thread 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:

cfajaximport tags=cfwindow!--- need this because cfwindow is created
via js only --- script type=text/javascript 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 } /script body
onload=doWindow(); /body

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


Re: cfselect url bind

2009-12-08 Thread 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 (input
type=button name=triggerbinding value=show results /)
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

 cfselect name=type 
 bind=url:lookup.cfc?method=getTypeyear={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: cfdocument not working in ie

2009-12-08 Thread 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: cfdocument not working in ie

2009-12-08 Thread 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: CF8 / IIS7 / ColdFusion.Ajax.submitForm/errorhandler not working

2009-12-08 Thread 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


SQL Server question re table names

2009-12-08 Thread 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 / Windows 7 - ODBC services not starting

2009-12-08 Thread 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


RE: CF8 Settings: Large upload failure

2009-12-08 Thread 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: AW 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: SQL Server question re table names

2009-12-08 Thread 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 l...@bc4x4.com
Date: Tue, December 08, 2009 1:45 pm
To: cf-talk cf-talk@houseoffusion.com


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 / Windows 7 - ODBC services not starting

2009-12-08 Thread 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: CF8 Settings: Large upload failure

2009-12-08 Thread 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: AW 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

2009-12-08 Thread 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: SQL Server question re table names

2009-12-08 Thread 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

2009-12-08 Thread 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: Possible thread issue?

2009-12-08 Thread 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 kap...@gmail.com wrote:


 Ok - changed the pk id field returned to the following:
  cfset theTransID = trans_insert_res.GENERATED_KEY

 Still the same issue.


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

 cfcomponent displayname=TransDAO

cffunction name=init access=public
 returntype=moneymaker.core.model.trans.TransDAO output=false
cfargument name=datasourceSettings
 type=moneymaker.core.model.DatasourceSettings required=true/
cfset variables.dss = arguments.datasourceSettings /
cfset variables.dsn = variables.dss.getDatasourceName() /
cfset variables.accountService =
 application.serviceFactory.getBean(AccountService)
cfreturn this /
/cffunction

cffunction name=fetch access=public returntype=Trans
 displayname=fetch
/cffunction

cffunction name=process access=public returntype=struct

cfargument name=acctid required=Yes type=numeric /
cfargument name=cardid required=Yes type=numeric /
cfargument name=cardnumber required=Yes type=numeric /
cfargument name=amount required=Yes type=numeric /
cfargument name=type required=Yes type=string /
cfargument name=paytype required=Yes type=numeric /
cfargument name=description required=Yes type=string /
cfargument name=tracenumber required=no type=string
 default= /
cfargument name=stLimits required=Yes type=struct /

cfset var stTrans = structNew() /

cftry
cflog file=transdao_cfc text=Process tx for
 #cardnumber# type=information
!--- Get balance ---
cfset theCurrentAvailableBalance =
 variables.accountService.getAccountBalance(available, arguments.acctid)
cfset theCurrentActualBalance =
 variables.accountService.getAccountBalance(actual, arguments.acctid)
cfset theNewAvailableBalance =
 numberformat(theCurrentAvailableBalance, _.__) +
 numberformat(arguments.amount, _.__)
cfset theNewActualBalance =
 numberformat(theCurrentActualBalance, _.__) +
 numberformat(arguments.amount, _.__)
cfset theNewActualRunningBalance =
 numberformat(theCurrentActualBalance, _.__) +
 numberformat(arguments.amount, _.__)

!--- If debit, make sure there is enough funds ---

!---
2009-09-29 AJK
Changed this to enabled debit to push the account
 into negative.

cfif arguments.type IS D99 AND theNewAvailableBalance LT 0
cfthrow errorcode=51 detail=Insuffcient Funds
 message=Error 51: Card has insufficient funds
/cfif
---

!--- Check status of card/account ---
cfquery datasource=#variables.dsn# name=cardcheck
SELECT *
FROM card
WHERE card_id = cfqueryparam cfsqltype=CF_SQL_NUMERIC
 value=#arguments.cardid#
/cfquery


cfif cardcheck.status_id NEQ 1
cfswitch expression=#cardcheck.status_id#
!--- Closed account ---
cfcase value=3cflog text=closed
 card:#cardcheck.card_cardnumber# loaded for #arguments.amount# on
 #dateformat(now(), '-mm-dd')# #timeformat(now(), 'HH:mm:ss')#
 file=closed_card_loads type=Information/cfcase
!--- Lost Card ---
cfcase value=4cfif arguments.type NEQ
 D98cfthrow errorcode=41 detail=Lost Card message=Error 41: Card has
 been reported lost/cfif/cfcase
!--- Stolen Card ---
cfcase value=5cfif arguments.type NEQ
 D98cfthrow errorcode=43 detail=Stolen Card message=Error 43: Card
 has been reported stolen/cfif/cfcase
!--- Restricted Card ---
cfcase value=10
cfthrow errorcode=62 detail=Restricted Card
 message=Error 62: Card is restricted
/cfcase
!--- New Inactive Card ---
cfcase value=11
cftry
cfif cardcheck.card_type_id EQ 1 OR
 cardcheck.bin_prog_link_id EQ 9
cfquery datasource=#variables.dsn#
update card
set status_id = 1
where card_id = cfqueryparam
 cfsqltype=CF_SQL_NUMERIC value=#arguments.cardid#
/cfquery
cflog text=#cardcheck.card_cardnumber#
 activated on load 

Reading Microsoft smart quotes with CFFILE

2009-12-08 Thread 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: Reading Microsoft smart quotes with CFFILE

2009-12-08 Thread 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: AW 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


Re: C:\ColdFusion8\Mail\Spool

2009-12-08 Thread 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: C:\ColdFusion8\Mail\Spool

2009-12-08 Thread John M Bliss

Ug.  OK.  Thanks.

On Tue, Dec 8, 2009 at 4:23 PM, Bobby bo...@acoderslife.com 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: CFWindow z-index with overlib

2009-12-08 Thread 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

2009-12-08 Thread David

On Tue, Dec 8, 2009 at 8:16 AM, John M Bliss bliss.j...@gmail.com 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:

div style=margin: 3em;
cfoutputa href=#CGI.SCRIPT_NAME#?restartMailService=trueRestart
mail spool service/a/cfoutput

cfif structKeyExists(URL, restartMailService) AND
URL.restartMailService IS true
cfset sFactory = 
CreateObject(java,coldfusion.server.ServiceFactory)
cfset MailSpoolService = sFactory.mailSpoolService
cfset MailSpoolService.stop()
h2Mail spool service stopped./h2
cfflush
cfset MailSpoolService.start()
h2Mail spool service restarted!/h2
/cfif
/div

- 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: C:\ColdFusion8\Mail\Spool

2009-12-08 Thread John M Bliss

Thanks!

On Tue, Dec 8, 2009 at 4:51 PM, David david.lak...@gmail.com wrote:


 On Tue, Dec 8, 2009 at 8:16 AM, John M Bliss bliss.j...@gmail.com 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:

 div style=margin: 3em;
 cfoutputa href=#CGI.SCRIPT_NAME#?restartMailService=trueRestart
 mail spool service/a/cfoutput

 cfif structKeyExists(URL, restartMailService) AND
 URL.restartMailService IS true
cfset sFactory =
 CreateObject(java,coldfusion.server.ServiceFactory)
cfset MailSpoolService = sFactory.mailSpoolService
cfset MailSpoolService.stop()
h2Mail spool service stopped./h2
cfflush
cfset MailSpoolService.start()
h2Mail spool service restarted!/h2
/cfif
 /div

 - 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


Reading Microsoft smart quotes with CFFILE

2009-12-08 Thread 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


cf9 packaging deployment

2009-12-08 Thread 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


Using XML to Create schema/database

2009-12-08 Thread 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


RE: cf9 packaging deployment

2009-12-08 Thread 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


Re: CFLDAP SSL

2009-12-08 Thread 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:
 
 cfldap
 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


ColdFusion Collaboration Chat Starting

2009-12-08 Thread 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: Possible thread issue?

2009-12-08 Thread 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

cfcomponent name=TransService output=false

cffunction name=init access=public 
returntype=moneymaker.core.model.trans.TransService output=false
cfreturn this /
/cffunction

cffunction name=setTransDAO returntype=void access=public 
output=false
cfargument name=TransDAO 
type=moneymaker.core.model.trans.TransDAO required=true /
cfset variables.dao = arguments.TransDAO /
/cffunction   

cffunction name=setTransGateway returntype=void access=public 
output=false
cfargument name=TransGateway 
type=moneymaker.core.model.trans.TransGateway required=true /
cfset variables.gateway = arguments.TransGateway /
/cffunction

cffunction name=getAll returntype=query access=public 
output=false
cfreturn variables.gateway.getAll() /
/cffunction

cffunction name=getLastTrans returntype=query access=public 
output=false
cfreturn variables.gateway.getLastTrans() /
/cffunction

cffunction name=getTransLimits access=remote returntype=struct
cfargument name=cardid required=Yes type=numeric /
cfreturn 
variables.gateway.getTransLimits(argumentCollection=arguments) /
/cffunction

cffunction name=processTransaction access=remote returntype=struct
cfargument name=acctid required=Yes type=numeric /
cfargument name=cardid required=Yes type=numeric /
cfargument name=cardnumber required=Yes type=numeric /
cfargument name=amount required=Yes type=numeric /
cfargument name=type required=Yes type=string /
cfargument name=description required=Yes type=string /
cfargument name=paytype required=Yes type=numeric /
cfargument name=tracenumber required=No type=string /


cfset arguments.stlimits = getTransLimits(arguments.cardid) /
cfreturn variables.dao.process(argumentCollection=arguments) /

/cffunction

/cfcomponent

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


Re: Possible thread issue?

2009-12-08 Thread 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
 
 cfcomponent name=TransService output=false
 
   cffunction name=init access=public returntype=moneymaker.core.
 model.trans.TransService output=false
   cfreturn this /
   /cffunction
 
   cffunction name=setTransDAO returntype=void access=public 
 output=false
   cfargument name=TransDAO type=moneymaker.core.model.trans.
 TransDAO required=true /
   cfset variables.dao = arguments.TransDAO /
   /cffunction   
 
   cffunction name=setTransGateway returntype=void access=public 
 output=false
   cfargument name=TransGateway 
 type=moneymaker.core.model.trans.
 TransGateway required=true /
   cfset variables.gateway = arguments.TransGateway /
   /cffunction
   
   cffunction name=getAll returntype=query access=public 
 output=false
   cfreturn variables.gateway.getAll() /
   /cffunction

 

 cffunction name=getLastTrans returntype=query access=public 
 output=false
   cfreturn variables.gateway.getLastTrans() /
   /cffunction
 

 cffunction name=getTransLimits access=remote 
 returntype=struct

 cfargument name=cardid required=Yes type=numeric /

 cfreturn variables.gateway.
 getTransLimits(argumentCollection=arguments) /

 /cffunction
 

 cffunction name=processTransaction access=remote 
 returntype=struct

 cfargument name=acctid required=Yes type=numeric /

 cfargument name=cardid required=Yes type=numeric /

 cfargument name=cardnumber required=Yes type=numeric /

 cfargument name=amount required=Yes type=numeric /

 cfargument name=type required=Yes type=string /

 cfargument name=description required=Yes type=string /

 cfargument name=paytype required=Yes type=numeric /

 cfargument name=tracenumber required=No type=string /
 
   

 cfset arguments.stlimits = getTransLimits(arguments.cardid) /

 cfreturn variables.dao.process(argumentCollection=arguments) /
 

 /cffunction
 
 /cfcomponent
 
 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?

2009-12-08 Thread 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=displayPostID=42.   Failing that, a
common but invasive way to establish CFC instance identity is to set a
variable:

cfset transDAO.__variable_name_unlikely_to_be_already_used = I'm back!!!

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 kap...@gmail.com 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?

2009-12-08 Thread 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. 

cffunction name=process access=public returntype=struct 
  .
  cfset var stTrans = structNew() / 
  
 !--- 
theCurrentAvailableBalance will be place the shared variables scope
 ---

/cffunction

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

 cfset theCurrentAvailableBalance = 
variables.accountService.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:
 cfset stTrans.theCurrentAvailableBalance = 
variables.accountService.getAccountBalance(available, arguments.acctid) 
cfset stTrans.theCurrentActualBalance = 
variables.accountService.getAccountBalance(actual, arguments.acctid)  
... etcetera ...


cfquery datasource=#variables.dsn# name=stTrans.trans_insert 
result=stTrans.trans_insert_res 
.


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?

2009-12-08 Thread 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?

2009-12-08 Thread 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. 
 
 cffunction name=process access=public returntype=struct 
  .
 
  
 cfset var stTrans = structNew() / 
  
 
 
 !--- 

 theCurrentAvailableBalance will be place the shared variables scope
 
 ---
 
 /cffunction
 
 But then starts using un-VAR'd variables like:
 
 
 cfset theCurrentAvailableBalance = variables.accountService.
 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:
 
 cfset stTrans.theCurrentAvailableBalance = variables.accountService.
 getAccountBalance(available, arguments.acctid) 
 cfset stTrans.theCurrentActualBalance = variables.accountService.
 getAccountBalance(actual, arguments.acctid)  
... 
 etcetera ...
 
 
 cfquery datasource=#variables.dsn# name=stTrans.trans_insert 
 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?

2009-12-08 Thread 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 kap...@gmail.com 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: Using XML to Create schema/database

2009-12-08 Thread 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