DB server: MSSQL 2000
System: RedHat Linux 8.0
Driver FreeTDS: 0.61
PHP_rev: 4.3.2 (also tried on 4.3.1 gives same problem)
Apache 2.0.46
I'm having a problem with mssql_bind under this configuration it appears not
to be binding variables specified to the stored procedure and I was
wondering
If
I used to use MSSQL.. I've always called the stored procedures like you
would call any method/function.. Have you tried just:
// ** Query for user details *** //
$query = sp_StaffDetail $var1, $var2;
$result = mssql_execute($query);
On Mon, 21 Jul 2003, A.J.Masterton wrote:
DB
:[EMAIL PROTECTED]
Sent: 21 July 2003 13:51
To: A.J.Masterton
Cc: '[EMAIL PROTECTED]'
Subject: Re: [PHP-DB] mssql_bind problem
I used to use MSSQL.. I've always called the stored procedures like you
would call any method/function.. Have you tried just:
// ** Query for user details
To: A.J.Masterton
Cc: '[EMAIL PROTECTED]'
Subject: Re: [PHP-DB] mssql_bind problem
I used to use MSSQL.. I've always called the stored procedures like you
would call any method/function.. Have you tried just:
// ** Query for user details *** //
$query = sp_StaffDetail $var1
Return 99 -- success
GO
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 21 July 2003 14:43
To: A.J.Masterton
Cc: '[EMAIL PROTECTED]'
Subject: RE: [PHP-DB] mssql_bind problem
I found this old piece of code.. not sure if it will still work
Eventually, thanks for the help.
Andrew Masterton
-Original Message-
From: A.J.Masterton [mailto:[EMAIL PROTECTED]
Sent: 21 July 2003 14:57
To: colbey; A.J.Masterton
Cc: php-db
Subject: RE: [PHP-DB] mssql_bind problem
Fetching the result as a array or object gives the data (a row