Re: Dateadd in SQL statement not working

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Brandon (bdreilingATmac.com)
Date: 05/10/04 

Date: Mon, 10 May 2004 07:24:05 -0700

Bob,

I am connecting to a Sybase db, however, I am using Access to write and
test
my queries.

In the FROM line, I am able to use FROM db.whatever.blah AS db to
shorten
the code used in every other line. I have tested that query without the
dateadd piece and it works without a problem (tested on an ASP page).

I don't have any problems with the connection script or returning basic
data
from the db. I just seem to have difficulty using DateAdd.

It has been a difficult search for assistance because I am working with
both
ASP and SQL (Sybase) and there seems to be little in the way of advice
for
both.

Thanks for all of your help, I will look for a good Sybase forum.

Brandon

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Quantcast