スカラりãµãれる - Hatena::Diary::Neko::kak 500 Internal Server Erroræ ¼è¨€ã€Œå›°ã£ãŸã‚‰ã€Scalarã‚Šãµãれるã€ã€‚ ã§ã™ã€‚ã¯ã„。 本日もDBICãƒã‚¿ã§ã™ãŒã€DBICã®Rã§å›°ã£ãŸã‚‰ã‚¹ã‚«ãƒ©ãƒ¼ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã§ã™ã€‚ã¯ã„。 $self->model('User')->search( { 'me.created_on' => \'IS NULL', } )->first; created_onã¯DATETIMEåž‹ã¨ã—ã¾ã™ã€‚ ã“ã‚“ãªæ„Ÿã˜ã§å®Ÿè¡Œã™ã‚‹ã¨ã€ SELECT me.created_on, me.rid, me.id FROM user me WHERE ( me.created_on IS NULL ) ã“ã‚“ãªSQLãŒå®Ÿè¡Œã•ã‚Œã¾ã™ã€‚ ã•ã‚‰ã«ã€ $self->model('User')->search( { 'me.created_on' => \' > NOW()', } )->first; ã“ã‚“ãªæ„Ÿã˜ã§å®Ÿè¡Œã™ã‚‹ã¨ SELECT me.created_on, me.ri
DBIC ã§now()ã¨ã‹sysdate() ã¨ã‹ã®SQL関数を使ã„ãŸã„ | ブãƒã‚°ãŒç¶šã‹ãªã„ã‚ã‘
Catalystã§DBICを使ã£ã¦ã„ã¦SELECT時ã«ãƒ†ãƒ¼ãƒ–ルをçµåˆ(JOIN)ã™ã‚‹ | ブãƒã‚°ãŒç¶šã‹ãªã„ã‚ã‘
{{#tags}}- {{label}}
{{/tags}}