Jump to content

yyyy2k

Members
  • Posts

    1
  • Joined

  • Last visited

yyyy2k's Achievements

Seeker

Seeker (1/7)

0

Reputation

  1. I use store procedures in this way, in this example is can pass parameters to the store Dim $oConn1 Dim $oCmd Dim $strConnetion $strConnetion = "Dsn=Order;Uid=;Pwd=;" $oConn1 = ObjCreate("ADODB.Connection") $oConn1.open($strConnetion) $oCmd = ObjCreate("ADODB.Command") $oCmd.ActiveConnection = $oConn1 $oCmd.CommandText = "call UpdateOrderTest('1234')" $oCmd.Execute ( Default, 0, -1 ) $oConn1.close MsgBox(0,"","Update OK !!!") the my store is "UpdateOrderTest" and "1234" is tha parameter. I use the database mysql
×
×
  • Create New...