Hi!
Win2k-PHP4.3.3-Apache2.0.43-MySQL4.0.15
I collect data from MSSQLServer,Access and MySQL. When I use MySQL, fields with cyrillic symbols from MySQL are not displayed correctly in the web page. But this problem doesn't exist with MSSQLServer and Access.
If I use MySQL-client cyrillic data is...
Hi!
Win2k-PHP4.3.3-Apache2.0.43-MySQL4.0.15
I collect data from MSSQLServer,Access and MySQL. When I use MySQL, fields with cyrillic symbols from MySQL are not displayed correctly in the web page. But this problem doesn't exist with MSSQLServer and Access.
If I use MySQL-client cyrillic data is...
Excellent, 10x, James!
It works fine.
But I wonder for some optimization.
I wrote stored procedure which takes 2 arguments @num1(number of displayed records), @num2(position):
CREATE stored procedure stTest
@num1 int, @num2 int
AS
SELECT TOP @num1 col1, col2
FROM tbl
WHERE col1 NOT IN (...
Unfortunately I'm using PHP. I can manipulate the resultset by PHP, but every time the page is requested and query is executed, SQLServer will return me all resultset:(.
Imagine 700 records in the recordset - I need only 10 records - for example records 290 to 300 - it's a waste of network...
Hi!
I'm building Web-application and I want to limit the number of displayed records (1-10, 11-20, 21-30 etc. as hyperlinks on the page). If I use MySQLSever - there is built-in function LIMIT(start,record_numbers). But unfortunately I couldn't find equivalent function in MSSQLServer. MSSQL's...
Meanwhile one friend of mine told the solution of the problem!!
In Php.ini default values for:
mssql.textlimit=4096 and
mssql.textsize=4096.
I changed these values to 65536 and now the size of text is OK!
Anyway, Thank you very much!!
Meanwhile one fried of mine told the solution of the problem!!
In Php.ini default values for:
mssql.textlimit=4096 and
mssql.textsize=4096.
I changed these values to 65536 and now the size of text is OK!
Anyway, Thank you very much!!
form with POST-button and 3 fields...Sends the data to another page...
$headline=$_POST['headline'];
$story_text=$_POST['story_text'];
$page=$_POST['page'];
$query="Insert Into news_stories (headline, story_text, page, writer, created, modified) values ('$headline', '$story_text', $page...
Hi!
I have field in the database which should accept text (Unicode) with different size. First I set this field to be nvarchar(3000) and I've attempted to put some text (about 2000 symbols) in that field with PHP. Then I tried to view the saved text using again PHP. For my suprise the length of...
Hi!
I have field in the database which should accept text (Unicode) with different size. First I set this field to be nvarchar(3000) and I've attempted to put some text (about 2000 symbols) in that field with PHP. Then I tried to view the saved text using again PHP. For my suprise the length of...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.