Meet on Monday, 19th January at 6pm for 6:30 start.
Details and RSVP http://groups.adobe.com/posts/b3ccf0d972
Chris
--
Chris Velevitch
Manager - Adobe Platform Users Group, Sydney
m: 0415 469 095
www.apugs.org.au
Adobe Platform Users Group, Sydney
January '09 meeting: Looking Ahead To The
Hi all,
It has been suggested by someone at work that we should only allow
access to database via stored procedures.
This was proposed to fix the current situation where we have hundreds
of similar SQL statements scattered
around the system. For example if the business logic has changed in
one
Depends on the queries I would say. If they are pretty stock standard
queries then I guess a stored proc process would be ok. Me personally I
prefer all or nothing. If you go down the stored proc route then I would be
wanting everything in there.
Another thing to consider is who is going to
I know ppl sometimes use databases for just basic data storage but
business logic in a database is a very valid process, especially if
inserts, updates and deletes involve triggers of related data.
having said that, it's something I don't need to do all that often,
and usually reserve for
the biggest hassle with SP's is that you are stuck with one set of SP
for a database
ie you can't tweak SP's like you can with normal queries
if you use bound sql, you can have two different builds with different
sql accessing the same db, with sp's
you can only have one a big hassle
Hey Felix,
* Faster execution is definitely a benefit of stored procs for
intensive or repetitive tasks
* Centralised place for logic is definitely a good thing, but I would
suggest that it's better to have in ColdFusion not stored procs. In
some cases, not all business logic can be represented
A little late on this conversation but I will address the questions you have
down below.
There are a number of ways you could approach this, but the idea of having a
central logic storage is the best solution. For the reasons that it was
suggested, and this is where ORM's have tried to bridge
I think the key is
This was proposed to fix the current situation where we have hundreds
of similar SQL statements scattered
around the system
it's possibly worth trying to understand why this happened, as you've
identified this as a maintenance nightmare.
do you *need* to have all these
My client is running CF5 (yes I know upgrade is needed) and since 1-1-09 the
cfmail server has been locking up
Their application has many many functions that generate email notifications
to nominated email addresses.
The scripts run as normal without crashing however the email are not
received
Check for zero byte files in the mail spool. CFMAIL seems to get stuck if
there are files with nothing in them in the spool directory
-Original Message-
From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf
Of Claude Raiola
Sent: Monday, 12 January 2009 4:50 PM
Steve I've seen that happen (to other ppl, thankfully)...
... any clue how/why it happens?
On Mon, Jan 12, 2009 at 3:52 PM, Steve Onnis st...@cfcentral.com.au wrote:
Check for zero byte files in the mail spool. CFMAIL seems to get stuck if
there are files with nothing in them in the spool
I think it might have something to do with the locking of the cfmail file
when it gets sent and then cf tried to delete the file but cant and ends up
with an empty file sitting in the que
-Original Message-
From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf
Of
I've seen that before too Steve
2009/1/12 Steve Onnis st...@cfcentral.com.au
I think it might have something to do with the locking of the cfmail file
when it gets sent and then cf tried to delete the file but cant and ends up
with an empty file sitting in the que
-Original
I have looked in the sppol folder are there were a couple of emails sitting
in there still from 5th and 6th jan which I deleted successfully however
there was 1 email file that could not be deleted each time I tried to it
said this file is being used by another process
the only way I was able to
You shoul dhave just stopped the CF server. Thats what would havebeen
locking it
-Original Message-
From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf
Of Claude Raiola
Sent: Monday, 12 January 2009 6:19 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re:
15 matches
Mail list logo