[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