note 21876 added to function.mssql-connect

From: Date: Thu, 30 May 2002 09:21:21 +0000
Subject: note 21876 added to function.mssql-connect
Groups: php.notes 
Request: Send a blank email to php-notes+get-31184@lists.php.net to get a copy of this message
I put this same question to mssql_query-page, and hope to get some answers... Situation: I make a query to an MS SQL database and get some data (date, name, value). In the database, there is many values for every minute. When I put query like this: SELECT date, name, value from table WHERE date > 'may 30 2002 10:00AM' and date < 'may 30 2002 10:30AM' I get many values for same minute (query reply does not show seconds). But when I put there like: SELECT date, name, value from table WHERE date > 'may 25 2002 10:00AM' and date < 'may 30 2002 10:00AM' Where the time is longer, I get a value for every two hours?!?! Question: Is there somekind of limitation for the amount of data being sent back from database? I didn't found any limitations in php.ini -file, tell me if I'm wrong? I must get the data for every minute or even more accurately from database. Now in long time queries data just disappears somewhere. Hope you can help, Jaro -- http://www.php.net/manual/en/function.mssql-connect.php http://master.php.net/manage/user-notes.php?action=edit+21876 http://master.php.net/manage/user-notes.php?action=delete+21876 http://master.php.net/manage/user-notes.php?action=reject+21876

« previous php.notes (#31184) next »