[cfaussie] Issue with concurrency

2008-03-26 Thread djdawson
Just having a CF issue at the moment and thought I'd send out an email requesting some assistance. I am having an issue with concurrency on an application in development. When I raise a new request it should grab a new request number and assign it to me via email. Problem: If there are a

[cfaussie] Re: Issue with concurrency

2008-03-26 Thread Mark Mandel
Dj - Hard to say, without knowing many of the specific of your application? What version of CF are you on? Are you using CFCs? If so, are you storing them in the applications scope? Are you using any particular frameworks? Where does the request id come from? This may be a locking issue,

[cfaussie] Re: Issue with concurrency

2008-03-26 Thread djdawson
HI Mark, Am using CF7. Not using cfcs What do you mean by frameworks? The request comes from the user clicking on 'add new request', then a form displays with a new request number. Once they fill in the data and click on submit, an email gets sent to the user with the request number and

[cfaussie] Re: Issue with concurrency

2008-03-26 Thread Mark Mandel
Without seeing any of the code, it's hard to say... What do you mean by frameworks? Fusebox? model glue? machii? (obviously nothing like coldspring, or Transfer). The request comes from the user clicking on 'add new request', then a form displays with a new request number. Once they

[cfaussie] Re: Issue with concurrency

2008-03-26 Thread Ricardo Russon
How are you generating the number exactly? Is the number reference stored somewhere so that you can check if it is in use before you generate another one? (I would assume this would be stored in the application scope or a database) Are you making use of cflock at all within the process? Just

[cfaussie] Re: Issue with concurrency

2008-03-26 Thread Brett Payne-Rhodes
Hi Mark, I suspect that you are doing something to get the Issue Number that is out of kilter with the actual processing - and I guess that the other info in the email is coming off the form which is why it is different for each email. When *exactly* are you picking up the Issue Number? And

[cfaussie] Re: Issue with concurrency

2008-03-26 Thread Joel Cass
It sounds like you're grabbing the latest number from the DB (or something) to display in your form. It sounds like this number is only updated when the user submits the form. Therefore two visitors to form at the same time will get the same number... I think you have to redesign your app.

[cfaussie] Re: Issue with concurrency

2008-03-26 Thread Peter Robertson
Best to store the value of the request in a dedicated db table. When a user needs a new number, do two sql operations; 1. select the previously issued value - eg, select max(transactionVal) as prev_trans_val from etc 2. increment the value for use by current user and write it straight back to

[cfaussie] Looking For- Sr. IT Analyst.

2008-03-26 Thread Ranjit Patil
Hi, Greetings!! This is Ranjit from Coolsoft, hope you are doing well, we have the following requirement . Appreciate if you can forward your latest word format resume contact no as soon as possible. Please check all the skills carefully !! Position : Sr. IT

[cfaussie] Creating Excel files with multiple worksheets

2008-03-26 Thread Darren Tracey
Making an Excel files come out of your CF pages is pretty straight forward with tables and CFContent. Is there any way to make an Excel file that has multiple worksheets? The solutions I've found involve calling COM objects for a server copy of Excel, but my server doesn't have Excel installed so

[cfaussie] Re: Creating Excel files with multiple worksheets

2008-03-26 Thread Ryan Sabir
Generate it as XML.. 1. Manually create the spreadsheet in Excel, with the multiple worksheets. 2. Save it as XML 3. Examine the XML in a text editor and use your mad CF skillz to recreate the content dynamically 4. Profit! -Original Message- From: cfaussie@googlegroups.com

[cfaussie] Re: Creating Excel files with multiple worksheets

2008-03-26 Thread Andrew Scott
I suppose you don't have the luxury of running it under Coldfusion 8:-) Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613  9015 8628 Mobile: 0404 998 273 -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of