i am converting an existing asp site over to php (noble cause) and i am
using odbc as my connection layer. i have no problem with statements, but
difficulties with stored procs.
the following is one of the statements i am trying to convert:

  Set cmdSub = Server.CreateObject("ADODB.Command")
  With cmdSub
   .ActiveConnection = DBConn

   .CommandText = "sp_edit_UtilCorp"
   .CommandType = 4 ' - adCmdStoredProc
   .Parameters("@UTILCORP_ID") = UTILCORP_ID
   .Parameters("@CoName") = CoName
   .Parameters("@Add1") = Add1
   .Parameters("@Add2") = Add2
   .Parameters("@City") = City
   .Parameters("@State") = State
   .Parameters("@Zip") = Zip
   .Parameters("@Tel") = Tel
   .Parameters("@Fax") = Fax
   .Parameters("@Email") = Email
   .Parameters("@ContactName") = ContactName

   edit_status = .Parameters("@RETURN_VALUE")
  End With

i found this under odbc_execute, but it supposedly is unable to give a
return value:
$stmt=odbc_prepare($conn_id, "exec my_proc_name ?,?,?");
if (!odbc_execute($stmt, &$parms)) die("odbc_execute failed");
is it possible to change this to both: explicitly pass the parameters by
name and pass the return value to a variable?????

Ian Ferger

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to