note 21875 deleted from function.mssql-query by dams
| From: | dams@php.net | Date: | Thu, 30 May 2002 15:01:16 +0000 |
| Subject: | note 21875 deleted from function.mssql-query by dams | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-31205@lists.php.net to get a copy of this message | ||
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