Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by aspx

  1. aspx

    Win2K-MySQL cyrillic problem

    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...
  2. aspx

    Cyrillic problem with PHP-Apache-MySQL-Win2K

    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...
  3. aspx

    Limit number of rows

    10x again , James! 2 stars!!! Extremely useful for me!
  4. aspx

    Limit number of rows

    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 (...
  5. aspx

    Limit number of rows

    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...
  6. aspx

    Limit number of rows

    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...
  7. aspx

    Popup Save (or Print) windows standard dialogs

    Thank you very much!
  8. aspx

    Popup Save (or Print) windows standard dialogs

    Hi! When user clicks on these buttons (or links) Print (or Save) windows standard dialog should appear. How to do?
  9. aspx

    How to put live video (live web cam)

    Hi! How to put live video (live web cam) - refresh in real time (or delay not more than 20 sec)?
  10. aspx

    Datalength problem

    I found the problem - it was in the configuration of PHP (default maxsize of query=4KB).
  11. aspx

    Problem with MSSQLServer

    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!!
  12. aspx

    Problem with MSSQLServer

    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!!
  13. aspx

    Problem with MSSQLServer

    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...
  14. aspx

    Datalength problem

    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...
  15. aspx

    Problem with MSSQLServer

    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...

Part and Inventory Search

Back
Top