From: "r937"
bofadem*
;o)
* i just cannot pass up an opportuinity to use one of my
favourite words, bofadem
Perfect, a trademark looking for a product:
Bofadem, the cleaner with bleach
The law partners are at your service, Bofadem.
Joseph
The WDVL Discussio
Ugh - After I started looking at this I realized that it's an Access DB -
not SQL Server (which I'm used to working with). I'm guessing that might
be
the difference?
in general, you cannot use the same SQL in different database systems
in particular, you can almost never use the same SQL in
PM
To: wdvltalk@lists.wdvl.com
Subject: Re: [wdvltalk] Limited Records - ASP
> Here is the original - "SELECT * FROM events ORDER BY StartDate"
>
> Without anything, I will get 10 events listed on the page. If I try
> "SELECT TOP 5 * FROM events ORDER BY StartDate",
> the
09 PM
To: wdvltalk@lists.wdvl.com
Subject: Re: [wdvltalk] Limited Records - ASP
> Yeah, I do have an ORDER BY. Maybe I don't have it in the right place?
if it isn't at the end, you'd get a syntax error
could you perhaps show us the entire query? or did i miss it already?
rudy
.
Here is the original - "SELECT * FROM events ORDER BY StartDate"
Without anything, I will get 10 events listed on the page. If I try
"SELECT TOP 5 * FROM events ORDER BY StartDate",
then I only get the first 2 events.
quite frankly, i just do not believe that
try running it in Query Analyzer
Yeah, I do have an ORDER BY. Maybe I don't have it in the right place?
if it isn't at the end, you'd get a syntax error
could you perhaps show us the entire query? or did i miss it already?
rudy
The WDVL Discussion List from WDVL.COM
To Join wdvltalk, Send An Email To: mailto
Yeah, I do have an ORDER BY. Maybe I don't have it in the right place?
Todd
-Original Message-
From: r937 [mailto:[EMAIL PROTECTED]
Sent: Friday, June 06, 2008 12:50 PM
To: wdvltalk@lists.wdvl.com
Subject: Re: [wdvltalk] Limited Records - ASP
> I also tried using "T
I also tried using "Top", and that doesn't produce the right results
("select top 5 * from table...")
this is, indeed, what you use for SQL Server
do you have an ORDER BY clause?
rudy
http://r937.com/
The WDVL Discussion List from WDVL.COM
To Join wdvltalk, Send An Email To: ma
Anything that does SQL should be able to handle the LIMIT clause - even
MS SQL Server. Just stick it on the end of your query and job done :)
in a word, no
;o)
The WDVL Discussion List from WDVL.COM
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web inte
On 06/06/2008 05:15 PM, Todd Richards wrote:
> Hmm, it's throwing an error on me about a missing operator. I've got my
> statement as
>
> SQL = "SELECT * FROM table ORDER BY StartDate LIMIT 5"
>
> Does that look right?
>
It looks right to me, but a quick Google suggests that MS SQL doesn't
s
* from table...")
Todd
-Original Message-
From: David Precious [mailto:[EMAIL PROTECTED]
Sent: Friday, June 06, 2008 11:04 AM
To: wdvltalk@lists.wdvl.com
Subject: Re: [wdvltalk] Limited Records - ASP
On 06/06/2008 04:54 PM, Todd Richards wrote:
> Yes, it's coming from a MS SQL
On 06/06/2008 04:54 PM, Todd Richards wrote:
> Yes, it's coming from a MS SQL Server 2000 DB, and I'm using ASP to pull the
> data. Does that offer the "limit", or is that just a MySQL feature?
Anything that does SQL should be able to handle the LIMIT clause - even
MS SQL Server. Just stick it o
ltalk@lists.wdvl.com
Subject: Re: [wdvltalk] Limited Records - ASP
On 06/05/2008 11:36 PM, Todd Richards wrote:
> Hey Everyone -
>
> I'm having a brain lapse here and can't figure out the "right" way to do
> this. On a home page, I have "Upcoming Events"
On 06/05/2008 11:36 PM, Todd Richards wrote:
> Hey Everyone -
>
> I'm having a brain lapse here and can't figure out the "right" way to do
> this. On a home page, I have "Upcoming Events" with a box floating to the
> right that will show the next 5 events. I was trying to use "rs.pagesize =
> 5
Hey Everyone -
I'm having a brain lapse here and can't figure out the "right" way to do
this. On a home page, I have "Upcoming Events" with a box floating to the
right that will show the next 5 events. I was trying to use "rs.pagesize =
5" but for some reason it's not working (although it is in
15 matches
Mail list logo
