Ms sql sp problem

Question

odysseous 0 Newbie Poster

16 Years Ago

The code below gives me "Warning: Wrong parameter count for mssql_bind() in"

$action="L";
$M_ExhibitionID=$_REQUEST[M_ExhibitionID];
$areaid=1;
$LngCode="el";
$sproc=mssql_init( "sp_php" );
mssql_bind($sproc,"@action",$action,SQLCHAR,false,false);
mssql_bind($sproc,"@M_ExhibitionID",$M_ExhibitionID,SQLINT4,false,false);
mssql_bind($sproc,"@areaid",$areaid,SQLINT4,false,false);
mssql_bind($sproc,"@lang",$LngCode,SQLVARCHAR,false,false);
$GET_EXHIBITS=mssql_bind($sproc);

what is my wrong?

php

1 Contributor
1 Reply
91 Views
6 Days Discussion Span
Latest Post 16 Years Ago Latest Post by odysseous

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

odysseous 0 Newbie Poster · Answer 1 · 2008-07-29T12:32:01+00:00

The code below gives me "Warning: Wrong parameter count for mssql_bind() in"

$action="L";
$M_ExhibitionID=$_REQUEST[M_ExhibitionID];
$areaid=1;
$LngCode="el";
$sproc=mssql_init( "sp_php" );
mssql_bind($sproc,"@action",$action,SQLCHAR,false,false);
mssql_bind($sproc,"@M_ExhibitionID",$M_ExhibitionID,SQLINT4,false,false);
mssql_bind($sproc,"@areaid",$areaid,SQLINT4,false,false);
mssql_bind($sproc,"@lang",$LngCode,SQLVARCHAR,false,false);
$GET_EXHIBITS=mssql_execute($sproc);

what is my wrong?

There is a coding error