Changeset 16905

Timestamp:

2007/12/11 13:49:18 (16 years ago)

Author:

satou

Message:

[ペイジェント決済モジュール]
SQLでのMAX値取得において、テキスト型を数値型に変換して取得する必要がある。

File:

• branches/beta/data/downloads/module/mdl_paygent/mdl_paygent.inc (modified) (1 diff)

branches/beta/data/downloads/module/mdl_paygent/mdl_paygent.inc

@@ -698 +698 @@
     $objQuery = new SC_Query();
     
+    if (DB_TYPE == "pgsql") $col = "cast(memo10 AS int4)";
+    elseif (DB_TYPE == "mysql") $col = "cast(memo10 AS SIGNED)";
+    $notice_id = $objQuery->max("dtb_order", $col, "memo01 = ?", array(MDL_PAYGENT_ID));
+    
+    $objQuery->begin();
+    
+    // ¥¹¥Æ¡¼¥¿¥¹¤Î¼èÆÀ
     $i = 0;
-    $notice_id = $objQuery->max("dtb_order", "memo10", "memo01 = ?", array(MDL_PAYGENT_ID));
-    
-    $objQuery->begin();
-    
-    // ¥¹¥Æ¡¼¥¿¥¹¤Î¼èÆÀ
     while($i < 1000) {
         $arrRet = sfGetPaymentStatus($objPaygent, $arrSend);