RE: [PHP] Re: How important is your Express or Web Edition database? Please weigh in--

2009-03-02 Thread Boyd, Todd M.
-Original Message- From: Andrew Ballard [mailto:aball...@gmail.com] Sent: Saturday, February 28, 2009 12:05 AM To: a...@ashleysheridan.co.uk Cc: Boyd, Todd M.; PHP General list Subject: Re: [PHP] Re: How important is your Express or Web Edition database? Please weigh in-- On Fri

Re: [PHP] Re: How important is your Express or Web Edition database? Please weigh in--

2009-03-02 Thread Andrew Ballard
: Friday, February 27, 2009 3:26 PM To: Bastien Koert Cc: Shawn McKenzie; php-general@lists.php.net Subject: Re: [PHP] Re: How important is your Express or Web Edition database? Please weigh in-- I use SQLExpress (SQL Server Express) all the time at work for prototyping and such... although

Re: [PHP] Re: How important is your Express or Web Edition database? Please weigh in--

2009-03-02 Thread Chris
Wait, wait, wait... I know SQL Server doesn't have LIMIT, but haven't you guys ever used TOP? As in... select top 10 * from some_table where some_column = 'some_value'; FWIW you have to do a similar thing in oracle. select * from table where rownum = 5; -- get 5 rows. to use a limit

RE: [PHP] Re: How important is your Express or Web Edition database? Please weigh in--

2009-03-02 Thread Ashley Sheridan
: Friday, February 27, 2009 3:26 PM To: Bastien Koert Cc: Shawn McKenzie; php-general@lists.php.net Subject: Re: [PHP] Re: How important is your Express or Web Edition database? Please weigh in-- I use SQLExpress (SQL Server Express) all the time at work for prototyping

Re: [PHP] Re: How important is your Express or Web Edition database? Please weigh in--

2009-03-02 Thread Chris
There isn't a BOTTOM, the solution looks something like this: SELECT * FROM (SELECT TOP 10 * FROM (SELECT TOP 20 * FROM table WHERE clause ORDER BY col) AS temp ORDER BY col DESC) as temp2 ORDER BY col It's an awful mess, but was the only way I found to select results x to y in a reliable

Re: [PHP] Re: How important is your Express or Web Edition database? Please weigh in--

2009-03-02 Thread Andrew Ballard
Cc: Boyd, Todd M.; PHP General list Subject: Re: [PHP] Re: How important is your Express or Web Edition database? Please weigh in-- On Fri, Feb 27, 2009 at 7:32 PM, Ashley Sheridan a...@ashleysheridan.co.uk wrote: On Fri, 2009-02-27 at 16:41 -0600, Boyd, Todd M. wrote: -Original

Re: [PHP] Re: How important is your Express or Web Edition database? Please weigh in--

2009-02-28 Thread Ashley Sheridan
, February 27, 2009 3:26 PM To: Bastien Koert Cc: Shawn McKenzie; php-general@lists.php.net Subject: Re: [PHP] Re: How important is your Express or Web Edition database? Please weigh in-- On Fri, Feb 27, 2009 at 4:21 PM, Bastien Koert phps...@gmail.com wrote: On Fri, Feb 27

Re: [PHP] Re: How important is your Express or Web Edition database? Please weigh in--

2009-02-28 Thread Andrew Ballard
On Sat, Feb 28, 2009 at 5:13 AM, Ashley Sheridan a...@ashleysheridan.co.uk wrote: On Sat, 2009-02-28 at 01:04 -0500, Andrew Ballard wrote: On Fri, Feb 27, 2009 at 7:32 PM, Ashley Sheridan a...@ashleysheridan.co.uk wrote: I absolutely love enum datatypes; they allow you to use string values

[PHP] Re: How important is your Express or Web Edition database? Please weigh in--

2009-02-27 Thread Shawn McKenzie
Stan Stadelman wrote: Hello All: I'm trying to see how Web Edition databases are being used in your company for PHP-driven web-apps. Our strategy team thought that free and community editions would be dominant, but we interviewed Zend Framework developers using Oracle, IBM, Microsoft,

Re: [PHP] Re: How important is your Express or Web Edition database? Please weigh in--

2009-02-27 Thread Bastien Koert
On Fri, Feb 27, 2009 at 4:01 PM, Shawn McKenzie nos...@mckenzies.netwrote: Stan Stadelman wrote: Hello All: I'm trying to see how Web Edition databases are being used in your company for PHP-driven web-apps. Our strategy team thought that free and community editions would be

Re: [PHP] Re: How important is your Express or Web Edition database? Please weigh in--

2009-02-27 Thread Andrew Ballard
On Fri, Feb 27, 2009 at 4:21 PM, Bastien Koert phps...@gmail.com wrote: On Fri, Feb 27, 2009 at 4:01 PM, Shawn McKenzie nos...@mckenzies.netwrote: Stan Stadelman wrote: Hello All: I'm trying to see how Web Edition databases are being used in your company for PHP-driven web-apps.  Our

RE: [PHP] Re: How important is your Express or Web Edition database? Please weigh in--

2009-02-27 Thread Boyd, Todd M.
-Original Message- From: Andrew Ballard [mailto:aball...@gmail.com] Sent: Friday, February 27, 2009 3:26 PM To: Bastien Koert Cc: Shawn McKenzie; php-general@lists.php.net Subject: Re: [PHP] Re: How important is your Express or Web Edition database? Please weigh in-- On Fri, Feb

RE: [PHP] Re: How important is your Express or Web Edition database? Please weigh in--

2009-02-27 Thread Ashley Sheridan
Express or Web Edition database? Please weigh in-- On Fri, Feb 27, 2009 at 4:21 PM, Bastien Koert phps...@gmail.com wrote: On Fri, Feb 27, 2009 at 4:01 PM, Shawn McKenzie nos...@mckenzies.netwrote: Stan Stadelman wrote: Hello All: I'm trying to see how Web Edition

Re: [PHP] Re: How important is your Express or Web Edition database? Please weigh in--

2009-02-27 Thread Murray
Not sure he's from a company. His email address is in the berkeley.edudomain. I guess there's a chance he's involved in Berkeley DB, although I believe this is now owned by Oracle? I'd be curious to know if any Berkeley people are still involved in the development of the engine. M is for Murray

Re: [PHP] Re: How important is your Express or Web Edition database? Please weigh in--

2009-02-27 Thread Michael A. Peters
Murray wrote: Not sure he's from a company. His email address is in the berkeley.edudomain. I guess there's a chance he's involved in Berkeley DB, although I believe this is now owned by Oracle? I'd be curious to know if any Berkeley people are still involved in the development of the engine. M

Re: [PHP] Re: How important is your Express or Web Edition database? Please weigh in--

2009-02-27 Thread Andrew Ballard
McKenzie; php-general@lists.php.net Subject: Re: [PHP] Re: How important is your Express or Web Edition database? Please weigh in-- On Fri, Feb 27, 2009 at 4:21 PM, Bastien Koert phps...@gmail.com wrote: On Fri, Feb 27, 2009 at 4:01 PM, Shawn McKenzie nos...@mckenzies.netwrote: Stan