<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><BR>
Thanks, but it seems like 'WHERE' clause is not applicable.</P>
<P>Maybe, I can rewrite a new method mimicking '__set'.<BR>
</P>
<BLOCKQUOTE style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">---------[ 받은 메일 내용 ]----------<BR>
<B>제목 : </B>Re: [RE][jifty-devel] UPDATE in SQL<BR>
<B>날짜 : </B>Mon, 4 Dec 2006 22:44:58 -0500<BR>
<B>보낸이 : </B>Jesse Vincent <jesse@bestpractical.com><BR>
<B>받는이 : </B>Nifty apps in a Jiffy <jifty-devel@lists.jifty.org><BR>
<BR>
<BR>
<BR>
<BR>
On Tue, Dec 05, 2006 at 12:40:24PM +0900, In-Suk Joung wrote: <BR>
> I answer to my question. I did this way. If anybody knows a fancier way, <BR>
> please let me know. <BR>
<BR>
<BR>
Hi! Sorry for the delay in my reply. I've been working a bit too hard of <BR>
late ;) <BR>
<BR>
It should be as easy as <BR>
<BR>
$object->__set( column => 'column_name', <BR>
value => 'column_name +1' <BR>
is_sql_function => 1); <BR>
<BR>
Best, <BR>
<BR>
Jesse <BR>
<BR>
<BR>
> <BR>
> 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, <BR>
> <BR>
> ); <BR>
> <BR>
> <BR>
> <BR>
> ---------[ ^1THA-o ,THAI ^3>>?e ]---------- <BR>
> A|,n : [jifty-devel] UPDATE in SQL <BR>
> ^3-AYEN : Mon, 04 Dec 2006 14:01:01 +0900 (KST) <BR>
> -o,^3 1/2AI : "In-Suk Joung" <JMARCH@HANMAIL.NET><BR>
> ^1TH'AAI : <JIFTY-DEVEL@LISTS.JIFTY.ORG><BR>
> <BR>
> Could anybody show me a quick example how to replace the SQL below in <BR>
> Jifty? <BR>
> <BR>
> UPDATE table_name SET column_name = column_name + 1 WHERE column_name >= <BR>
> $certain_number <BR>
> <BR>
> I guess probably I need to use some methods in Jifty::DBI::Handle. But I <BR>
> have no clue, yet. <BR>
> <BR>
> ----------- <BR>
> InSuk Joung <BR>
> ----------- <BR>
> <BR>
> [IMG] <BR>
> "?`i,(R) AIAAI^3Y, Daum" http://www.daum.net !-oAEo>>y 3/4^2'A ^1<<.a <BR>
> C,N,THAI^3Y!>> <BR>
> [IMG] <BR>
> [IMG] <BR>
> <BR>
> ----------- <BR>
> InSuk Joung <BR>
> ----------- <BR>
> <BR>
> [IMG] <BR>
> "?`i,(R) AIAAI^3Y, Daum" http://www.daum.net !-oAEo>>y 3/4^2'A ^1<<.a <BR>
> C,N,THAI^3Y!>> <BR>
> [IMG] <BR>
> [IMG] <BR>
<BR>
> _______________________________________________ <BR>
> jifty-devel mailing list <BR>
> jifty-devel@lists.jifty.org <BR>
> http://lists.jifty.org/cgi-bin/mailman/listinfo/jifty-devel <BR>
<BR>
<BR>
-- <BR>
_______________________________________________ <BR>
jifty-devel mailing list <BR>
jifty-devel@lists.jifty.org <BR>
http://lists.jifty.org/cgi-bin/mailman/listinfo/jifty-devel <BR>
<BR>
</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=%3C20061205131858%2EHM%2Ez000000000JBJBf%40jmarch%2Ewwl361%2Ehanmail%2Enet%3E">