Alf Stockton wrote:
> Niel Archer wrote:
>
>> 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.
>>
>>
I do not believe that I am misunderstanding MSSQL. What I
Alf Stockton wrote:
> Niel Archer wrote:
>
>> 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 th
Niel Archer wrote:
> 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
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?
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)
