[PHP-DB] sybase remote procedure ergebnis in variable

[7k]

Hallo,

ich nutze per ODBC eine remote procedure auf einem Sybase Server. Die 
Prozedur liefert mir unter anderem eine Variable zurück, die ich in PHP 
weiternutzen muß. Kann mir jemand einen Hinweis geben, wie ich die 
Variable der ODBC Abfrage in eine PHP Variable übertragen kann?
Hier das Beispiel:

odbc_exec ($conn,declare @VARIABLE int exec PROZEDURNAME 
'TABELLENNAME_SPALTENNAME', @VARIABLE output);

@VARIABLE soll übertragen werden in $VARIABLE

Danke im voraus
7k


-- 
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]

[PHP-DB] sybase remote pocedure into variable

[7k]

Hi,

I run a remote procedure via ODBC on a sybse server. The procedure 
returns an integer in a variable @VARIABLE. I have to use the integer 
as a variable $VARIABLE in PHP. Does anybody know how to get the 
content of @VARIABLE into $VARIABLE?
This is the code I use:

odbc_exec ($conn,declare @VARIABLE int exec PROZEDURNAME 
'TABELLENNAME_SPALTENNAME', @VARIABLE output);

content of @VARIABLE must be written into $VARIABLE

Thanks in advance
7k


-- 
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]

[PHP-DB] Re: sybase remote pocedure into variable

[7k]

Good idea Michiel,

I tried $@VARIABLE but it doens't work (not content).
Concerning the other idea, as far as I know the odbc procedure only 
returns if it has run successfull or not and thus gives me a 0 or a 
1 if use:
$VARIABLE=odbc_exec ($conn,declare @VARIABLE int exec PROZEDURNAME 
'TABELLENNAME_SPALTENNAME', @VARIABLE output);

Any other ideas?
Ciao
7k

Michiel Lange wrote:

  Missed that...
 
  Try these:
 
  $VARIABLE = odbc_exec(...)
 
  or try what $@VARIABLE contains...
 
  Met vriendelijke groet,
 
  Michiel Lange
  ActuEra B.V.



-- 
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]