What is the difference between @mssql_connect() and mssql_connect()?
i.e. What is the relevance of the prefixed @?
--
Regards,
Alf Stocktonwww.stockton.co.za
You may my glories and my state dispose,
But not my griefs; still am I king of those.
-- William Shakespeare,
Hi Alf,
As far as I can tell it's working just fine. Hre is a sample:
and here is the output:
bool(true)
Warning: mssql_query(): message: Syntax error converting the varchar value
'aa' to a column of data type int. (severity
16) in C:\php5\test\mssql_error.php on line 10
Warning: mssql_query
Hi Alf
You'd be better off asking this type of question in the database list.
I'm not familiar with MS-SQL, the syntax doesn't look much different to
the MySQL flavour.
When you say " whether the query works or not" do you mean the query is
failing with an error, or it simply returns no data?
I just realised the problem was the SP was not setting set nocount on so the
first record set was the number of records returned
From: "Aspen Olmsted" <[EMAIL PROTECTED]>
Sent: Thursday, October 12, 2006 6:21 AM
To: php-
Hello,
I am having trouble with pdo_odbc and calling a stored procedure that
returns a record set.
I have tried with out using parameters:
$stmt = $dbh->prepare("EXEC ASC_GridData
@StartRecordIndex=0,@PageSize=15,@SortColumn='',@SortDirection='ASC',@Filter
='lscShowCode=14 and
lscType=2',@Primary
Am I misunderstanding the PHP Manual, where it says:-
mixed *mssql_query* ( string query [, resource link_identifier [, int
batch_size]] )
Returns: A MS SQL result resource on success, *TRUE* if no rows were
returned, or *FALSE* on error.
and my code reads:-
$Reply = mssql_query($insert, $link)
