Re: MySQL infinity?

AJAX?

I guess I am not sure where oyu are going there. Like I said, it works fine
right now except that I am using a "really large" number to in place of
infinity.

Maybe I didn't explain it well enough. I think maybe I will just stick to the
"really large" number thing instead of COUNT or other methods.


Thanks for the reply.

Blaine
Quoting Scott Downing <sdowning-44oa8dZYi30C0E6/esFX4Q@xxxxxxxxxxxxxxxx>:

> > On 6/16/05, Blaine Garrett <blaine-4hELYU93S8xBDgjK7y7TUQ@xxxxxxxxxxxxxxxx> 
> > wrote:
> > >
> > > Hi,
> > >
> > > Does anyone know if mysql has a way of representing infinity. I want to
> > > use it
> > > as the default for some limit statements.
>
>
> What is your overall goal you are trying to accomplish? Are you going to
> be inserting from another source and want to return the new rows in this
> query? If that is what you're trying to do then it is impossible, once
> you send a query, the db server does the results and sends them to php,
> all rows. So if more rows are added while you're proccessing them in php
> they wont be in your results set. This is how sql works and there is no
> way around it.
>
> Now you might be able to do something where you display some rows and
> use an AJAX kind of process that will check for more records and add to
> your list.
>
> But the bottom line is, if you want newly added rows you must do another
> query.
>
>
>
> --
> Scott Downing <sdowning-44oa8dZYi30C0E6/esFX4Q@xxxxxxxxxxxxxxxx>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: 
> talk-unsubscribe-4zcLI8jJc/rYtjvyW6yDsg@xxxxxxxxxxxxxxxx
>
> Please read and follow the list guidelines:
>   http://www.tcphp.org/mailing_list/guidelines
>
> The tcphp.org mailing list is sponsored by pajunas interactive, inc.
>
>


--
Blaine Garrett
Chief Web Applications Developer
JR Computer Associates INC
http://jrcorps.com
blaine-4hELYU93S8xBDgjK7y7TUQ@xxxxxxxxxxxxxxxx




---------------------------------------------------------------------
To unsubscribe, e-mail: talk-unsubscribe-4zcLI8jJc/rYtjvyW6yDsg@xxxxxxxxxxxxxxxx

Please read and follow the list guidelines:
  http://www.tcphp.org/mailing_list/guidelines

The tcphp.org mailing list is sponsored by pajunas interactive, inc.