note 21875 deleted from function.mssql-query by dams

From: 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

« previous php.notes (#31205) next »