Re: Dateadd in SQL statement not working

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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!

Relevant Pages

  • Re: How does ct_connect track down database to open?
    ... SQLAPI uses the connect command which has notes ... about connecting to sybase. ... Since the initial parameter is database ...
    (comp.databases.sybase)
  • Re: DAO Sybase system 11
    ... same way regardless of what you are connecting to. ... Has anyone coonected via ADO with Sybase System 11 driver or Sybase ASE ...
    (microsoft.public.access.modulesdaovba)
  • Sybase connection
    ... This is the first time I need to connect via PHP to a Sybase DB. ... I'm working with PHP5 and Apache 2 under WinXP... ... connecting with Mysql... ... I enabled in php.ini the correct dll: ...
    (comp.lang.php)
  • Re: Sybase connection
    ... > This is the first time I need to connect via PHP to a Sybase DB. ... > connecting with Mysql... ... > restart Apache got this error: ...
    (comp.lang.php)
  • Re: Dateadd in SQL statement not working
    ... ability to run a query containing "FROM dbo.tablename" in Access. ... > the dateadd piece and it works without a problem (tested on an ASP ... I thought you said you had tested your queries ... > ASP and SQL (Sybase) and there seems to be little in the way of advice ...
    (microsoft.public.inetserver.asp.general)