[RE]Re: [RE][jifty-devel] UPDATE in SQL

Mon, 04 Dec 2006 20:19:25 -0800


Thanks, but it seems like 'WHERE' clause is not applicable.

Maybe, I can rewrite a new method mimicking '__set'.

---------[ 받은 메일 내용 ]----------
제목 : Re: [RE][jifty-devel] UPDATE in SQL
날짜 : Mon, 4 Dec 2006 22:44:58 -0500
보낸이 : Jesse Vincent <[EMAIL PROTECTED]>
받는이 : Nifty apps in a Jiffy <[email protected]>




On Tue, Dec 05, 2006 at 12:40:24PM +0900, In-Suk Joung wrote:
> I answer to my question. I did this way. If anybody knows a fancier way,
> please let me know.


Hi! Sorry for the delay in my reply. I've been working a bit too hard of
late ;)

It should be as easy as

$object->__set( column => 'column_name',
value => 'column_name +1'
is_sql_function => 1);

Best,

Jesse


>
> 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,
>
> );
>
>
>
> ---------[ ^1THA-o ,THAI ^3>>?e ]----------
> A|,n : [jifty-devel] UPDATE in SQL
> ^3-AYEN : Mon, 04 Dec 2006 14:01:01 +0900 (KST)
> -o,^3 1/2AI : "In-Suk Joung" <[EMAIL PROTECTED]>
> ^1TH'AAI :
>
> 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
> -----------
>
> [IMG]
> "?`i,(R) AIAAI^3Y, Daum" http://www.daum.net !-oAEo>>y 3/4^2'A ^1<<.a
> C,N,THAI^3Y!>>
> [IMG]
> [IMG]
>
> -----------
> InSuk Joung
> -----------
>
> [IMG]
> "?`i,(R) AIAAI^3Y, Daum" http://www.daum.net !-oAEo>>y 3/4^2'A ^1<<.a
> C,N,THAI^3Y!>>
> [IMG]
> [IMG]

> _______________________________________________
> jifty-devel mailing list
> [email protected]
> http://lists.jifty.org/cgi-bin/mailman/listinfo/jifty-devel


--
_______________________________________________
jifty-devel mailing list
[email protected]
http://lists.jifty.org/cgi-bin/mailman/listinfo/jifty-devel




-----------
InSuk Joung
-----------

"우리 인터넷, Daum" http://www.daum.net 『평생쓰는 무료 한메일넷』
_______________________________________________
jifty-devel mailing list
[email protected]
http://lists.jifty.org/cgi-bin/mailman/listinfo/jifty-devel

Reply via email to