Re: Possible thread issue?
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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?
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
All: Im 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. Its 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
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: Im 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. Its 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
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
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
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
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
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
All: Im 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. Its 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
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
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
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
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
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?
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?
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?
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?
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?
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?
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?
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
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
