Dates

	Home Register Search Help Login

Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

Dates

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> Dates

Page: [1]


TAMAJAMA Posts: 28 From: KANSAS Status: offline	Dates - 3/9/2001 17:22:00 Spooky and friends; You have got to be sick of hearing questions about date fields, but even after looking through previous posts, I was unable to find any information on this specific problem. Here's my code. fp_sQry="SELECT * FROM ALLTESTS WHERE (((ALLTESTS.TESTDATE) Between Date() And DateAdd(""m"",-3,Date())))" No default is set up. (I don't think I need a default) It is bringing up this error when displayed in my browser: Database Results Error Description: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. Number: -2147217904 (0x80040E10) Source: Microsoft OLE DB Provider for ODBC Drivers I did not do this page using the DRW. I pulled it from my SQL view in my Access query which is working fine in my database. I tested it in a new page with the DRW as a custom query and it verifies the connection. I am assuming my code is incorrect somewhere. I will continue to work with it, but I feel like I'm at a dead end here. I've tried all of the ways I know of. Any help is greatly appreciated. Thanks!!!!

Spooky

Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline

RE: Dates - 3/9/2001 23:26:00

Try this one :

"SELECT * FROM ALLTESTS WHERE (((ALLTESTS.TESTDATE) Between Date() And DateAdd('m',-3,Date())))"

------------------
Spooky
"I am Spooky of Borg. Prepare to be assimilated, babycakes!"
Subscribe to OutFront News
Database / DRW Q & A
The Spooky Login!

(in reply to TAMAJAMA)


TAMAJAMA Posts: 28 From: KANSAS Status: offline	RE: Dates - 3/13/2001 15:44:00 Spooky, That worked perfectly, THANKS! Your login system works great by the way!!! Once I dug in and looked at how it all worked together I was a little humbled at how much these ASP pages can do that I have NO knowledge of. I'm learning though. ------------------ Don't treat me any differently than you would the queen (in reply to TAMAJAMA)


Spooky Posts: 26599 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: Dates - 3/13/2001 16:02:00 Everyones been there at one stage or another. Curiousity is one of the requirements when coding, otherwise youd never ever consider trying to find how it works, or find a better way. For everything else theres frontpage.... (in reply to TAMAJAMA)