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, Feb 27, 2009 at 7:32 PM, Ashley Sheridan
>> > wrote:
&
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 mann
-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
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
e-
>> >> > 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: [PH
> -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
> data
On Sat, Feb 28, 2009 at 5:13 AM, Ashley Sheridan
wrote:
> On Sat, 2009-02-28 at 01:04 -0500, Andrew Ballard wrote:
>> On Fri, Feb 27, 2009 at 7:32 PM, Ashley Sheridan
>> wrote:
> I absolutely love enum datatypes; they allow you to use string values
> but internally stores them as numbers, and pre
l.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
tien 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
>> > wrote:
>>
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
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
ht
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
> > wrote:
> > > On Fri, Feb 27, 2009 at 4:01 PM, Shawn McKenzie
> > wrote:
> > >
> >
> -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? Plea
On Fri, Feb 27, 2009 at 4:21 PM, Bastien Koert wrote:
> On Fri, Feb 27, 2009 at 4:01 PM, Shawn McKenzie wrote:
>
>> 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
On Fri, Feb 27, 2009 at 4:01 PM, Shawn McKenzie wrote:
> 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 w
15 matches
Mail list logo