|
I answer to my question. I did this way. If anybody knows a fancier way, please let me know.
my $db_handle = $self->_handle;
my $table = $self->table;
$db_handle->simple_query(
"UPDATE $table SET column_name = column_name + 1"
." WHERE column_name >= ?",
$certain_number,
);
---------[ 받은 메일 내용 ]----------
제목 : [jifty-devel] UPDATE in SQL
날짜 : Mon, 04 Dec 2006 14:01:01 +0900 (KST)
보낸이 : "In-Suk Joung" <[EMAIL PROTECTED]>
받는이 : <[email protected]>
Could anybody show me a quick example how to replace the SQL below in Jifty?
UPDATE table_name SET column_name = column_name + 1 WHERE column_name >= $certain_number
I guess probably I need to use some methods in Jifty::DBI::Handle. But I have no clue, yet.
|
-----------
InSuk Joung
-----------
![]()
![]() |
-----------
InSuk Joung
----------- ![]()
![]()
_______________________________________________
jifty-devel mailing list
[email protected]
http://lists.jifty.org/cgi-bin/mailman/listinfo/jifty-devel
