[PHP] mssql_bind() couldn't process string parameter longer than 254 characters

[Miroslav I.]

Hi, people

- the first time in the list,
- subscribed only for few minutes and already have 7 messages :-) this is
promising!!



#The problem:
mssql_bind() (PHP Version 4.3.2-RC) couldn't pass string parameter longer
than 254 characters to the stored procedure (MSSQL2000 server)

##Is there a way to call stored procedure ( from PHP ) with long string
parameters?



###Additional:
- Warnings and PHP code lines related:
Warning: mssql_bind(): Unable to set parameter in
E:\Intranet\webtreb.fresh.co.yu\connections\insert_treb.php on line 59
< line 59: mssql_bind($kveri, "@item_treb1", $item_treb1, SQLVARCHAR, FALSE,
FALSE, 255); >

Warning: mssql_execute(): message: Procedure 'sp_tr_InsertTrebIDetails'
expects parameter '@item_treb1', which was not supplied. (severity 16) in
E:\Intranet\webtreb.fresh.co.yu\connections\insert_treb.php on line 70
Warning: mssql_execute(): stored procedure execution failed in
E:\Intranet\webtreb.fresh.co.yu\connections\insert_treb.php on line 70
< line 70: $result = mssql_execute($kveri); >

- PHP Manual (2003-09-06):
"There is a bug in MSSQL Client Libraries that avoid sending varchar
parameters for more than 255 characters to a stored procedure.Use
mssql_query instead."

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] CGI error when loading iFRAME

[Miroslav I.]

Hi, people

#The problem:
There is an error message that stops proper loading of one iFRAME, I
couldn't understand what is the problem.
Complete error message issued:
>>CGI Error
The specified CGI application misbehaved by not returning a complete set of
HTTP headers. The headers it did return are:<<

- In one of two FRAMEs of "main.PHP" , "zero.PHP" page is loaded.
- "zero.PHP" has 3 iFRAMEs.
- Both the first and the second iframe has its own self refering PHP file
(if one of the PHP files name is "first.PHP" its form has:
action="first.PHP").
- One of the PHP files, e.g.: "first.PHP" loads the "third.PHP" file in the
third iFRAME when a condition was met, using expression like:
echo 'top.frames[1].frames[1].location="third.PHP";
';
- Sometimes loading of the "third.PHP" issues mentioned CGI error.

##What is the problem, why the error?

###Additional:
PHP Version 4.3.3 is running on Windows 2000 server

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] [PHP or maybe JavaScript or CSS] protecting my PHP from bad input

[Miroslav I.]

#The problem:
This is about protecting my PHP from bad input (e.g.: letters instead of
numbers).

##
Is there a way to prevent user from even inputting a letter in a text box?

Thanks in advance

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] [PHP or maybe JavaScript or CSS] protecting my PHP from bad input

[Miroslav I.]

Thanks Eugen,

I'm familiar with the concepts, but I've seen sites with textboxes that
would not show any letter typed - only numbers are displayed in the textbox.
This is what I like but don't know how to achieve. :-)


> : #The problem:
> : This is about protecting my PHP from bad input (e.g.: letters instead
> : of numbers).
>
> Good idea.  You need to make sure user-inputted data is valid.
>
> : ##
> : Is there a way to prevent user from even inputting a letter in a text
> : box?
>
> There's two general ways to do data validation: client-side and
> server-side.  PHP is server-side.  JavaScript is client-side.
.
.
.

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php