<style> p {margin-top:0px;margin-bottom:0px;} </style>
<table border=0 width=100% bgcolor='' cellpadding=0 cellspacing=0 align=center>
<tr>
<td valign=top style='padding:8pt;'><font size=2 face='굴림'>
<P>I answer to my question. I did this way. If anybody knows a fancier way, please let me know.</P>
<P> </P>
<P>my $db_handle = $self->_handle;<BR>
my $table = $self->table;<BR>
$db_handle->simple_query(<BR>
"UPDATE $table SET column_name = column_name + 1"<BR>
." WHERE column_name >= ?",<BR>
$certain_number,</P>
<P>);</P>
<P> </P>
<BLOCKQUOTE style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">---------[ 받은 메일 내용 ]----------<BR>
<B>제목 : </B>[jifty-devel] UPDATE in SQL<BR>
<B>날짜 : </B>Mon, 04 Dec 2006 14:01:01 +0900 (KST)<BR>
<B>보낸이 : </B>"In-Suk Joung" <jmarch@hanmail.net><BR>
<B>받는이 : </B><jifty-devel@lists.jifty.org><BR>
<BR>
<STYLE> p {margin-top:0px;margin-bottom:0px;} </STYLE>
<TABLE cellSpacing=0 cellPadding=0 width="100%" align=center border=0>
<TBODY>
<TR>
<TD style="PADDING-RIGHT: 8pt; PADDING-LEFT: 8pt; PADDING-BOTTOM: 8pt; PADDING-TOP: 8pt" vAlign=top><FONT face=굴림 size=2>Could anybody show me a quick example how to replace the SQL below in Jifty?<BR>
<BR>
UPDATE table_name SET column_name = column_name + 1 WHERE column_name >= $certain_number<BR>
<BR>
I guess probably I need to use some methods in Jifty::DBI::Handle. But I have no clue, yet.<BR>
</FONT></TD></TR></TBODY></TABLE><!-- __Hanmail-sig-Start__ --><BR>
<BR>
<BR>
<FONT style="FONT-SIZE: 9pt" color=#000000>----------- <BR>
InSuk Joung <BR>
-----------</FONT> <BR>
<BR>
<A href="mailto:jmarch@hanmail.net">
<IMG src="http://nametag.hanmail.net/2F5haTe4IitbGJFWMrkpew00" border=0></A> <!-- __Hanmail-sig-End__ --><!-- __Hanmail-tail-Start__ --><!-- 메일 푸터 시작 -->
<DIV id=mailFooter style="MARGIN-TOP: 20px; BACKGROUND: url(http://mailimg.hanmail.net/05mail/img_dotline.gif) repeat-x 0px 0px">
<DIV class=d_12_333333 id=mfTop style="LINE-HEIGHT: 28px; PADDING-TOP: 4px">"우리 인터넷, Daum" <A class=d_12_333333 href="http://www.daum.net/" target=_top>http://www.daum.net</A> 『평생쓰는 무료 한메일넷』<BR>
</DIV>
<DIV id=mfLeft style="BORDER-RIGHT: #dfdfdf 1px solid; BORDER-TOP: #dfdfdf 1px solid; FLOAT: left; MARGIN: 0px 12px 10px 0px; BORDER-LEFT: #dfdfdf 1px solid; BORDER-BOTTOM: #dfdfdf 1px solid"><A href="http://allim.daum.net/servlet/Redirect?sid=footer060925_daumdirect" target=_new>
<IMG height=48 src="http://hmm.daum.net/image/daumdirect_hanmailfoot.gif" width=350 border=0> </A></DIV>
<DIV id=mfRight style="BORDER-RIGHT: #dfdfdf 1px solid; BORDER-TOP: #dfdfdf 1px solid; FLOAT: left; BORDER-LEFT: #dfdfdf 1px solid; BORDER-BOTTOM: #dfdfdf 1px solid"><A href="http://mail.daum.net/hanmail/Goto.daum?url=%2Fhanmail%2FIndex.daum%3Fright%3Dhttp%253A%252F%252Fhmm.daum.net%252Finvoice%252FyearlyTax.html&event=yearlyTax" target=new>
<IMG height=48 src="http://mailimg.hanmail.net/event/061124_tax/footbn_061124_tax.gif" width=350 border=0> </A></DIV>
<DIV style="CLEAR: both"></DIV></DIV><!-- 메일 푸터 끝 --><!-- __Hanmail-tail-End__ -->
<IMG src="http://wwl361.hanmail.net:4280/@from=jmarch&rcpt=jifty-devel%40lists.jifty.org&msgid=%3C20061204140101.HM.z000000000JBJB9%40jmarch.wwl361.hanmail.net%3E"> </BLOCKQUOTE></font></td></tr>
</table>
<!-- __Hanmail-sig-Start__ -->
<br><br><br><font color=#000000 style='font-size: 9pt;'>-----------
<br>InSuk Joung
<br>-----------</font> <br><br><a href="mailto:jmarch@hanmail.net"><img src="http://nametag.hanmail.net/2F5haTe4IitbGJFWMrkpew00" border="0"></a>
<!-- __Hanmail-sig-End__ -->
<!-- __Hanmail-tail-Start__ -->
<!-- 메일 푸터 시작 -->
<div id="mailFooter" style="background:url('http://mailimg.hanmail.net/05mail/img_dotline.gif') repeat-x 0 0;margin-top:20px;">
<div id="mfTop" style="line-height:28px;padding-top:4px;" class="d_12_333333">
"우리 인터넷, Daum" <a href="http://www.daum.net" target="_top" class="d_12_333333">http://www.daum.net</a>
『평생쓰는 무료 한메일넷』<br />
</div>
<div id="mfLeft" style="border:1px #dfdfdf solid;float:left;margin:0 12px 10px 0;">
<a href="http://allim.daum.net/servlet/Redirect?sid=footer060925_daumdirect" target="_new">
<img src="http://hmm.daum.net/image/daumdirect_hanmailfoot.gif" width="350" height="48" border="0">
</a>
</div>
<div id="mfRight" style="border:1px #dfdfdf solid;float:left;">
<a href="http://allim.daum.net/servlet/Redirect?sid=footer_lucky1204" target="new">
<img src="http://mailimg.hanmail.net/event/061129_hm3/footbn_061129.gif" width="350" height="48" border="0">
</a>
</div>
<div style="clear:both;"></div>
</div>
<!-- 메일 푸터 끝 -->
<!-- __Hanmail-tail-End__ -->
<img src="http://wwl361.hanmail.net:4280/@from=jmarch&rcpt=jifty%2Ddevel%40lists%2Ejifty%2Eorg&msgid=%3C20061205124024%2EHM%2Ez000000000JBJBb%40jmarch%2Ewwl361%2Ehanmail%2Enet%3E">