[thesite] update - article/act_process.cfm
Daniel J. Cody
djc at starkmedia.com
Mon Aug 27 17:01:31 CDT 2001
we had a query in there to grab the next value in the sequence so an
email could be sent with the correct article ID number:
<cfquery name="getnextarticle" datasource="#data#">
SELECT Max(contentid) AS n_content_id
FROM content
</cfquery>
reading up on some oracle stuff lately, and apparently there is a quick
and easy way to get the current value of the sequence(and its faster
than walking the sequence and getting the highest one), called 'currval'
I just uploaded this query to replace the old one and everything looks
good, nothing super crazy, but i'm in a 'make shit quicker' mood today.
<cfquery name="getnextarticle" datasource="#data#">
SELECT evolt_seq.currval AS n_content_id
FROM DUAL
</cfquery>
i'll look for other places this may be happening as well.
.djc.
More information about the thesite
mailing list