Too Few Parameters?? Date field?

Posted: 02-24-2005, 04:13 PM
Hi,

Access, DWMX, ASP, VBScript.

SELECT eventydate
FROM qryEvents
ORDER BY eventydate ASC

Is returning:

Too Few Parameters, Expected 1??

What is wrong?
PS. I called it eventydate because I was worried that eventdate was a field
name I perhaps couldn't use? Both produce the same error.

Doing my head in this.

Nath.


Reply With Quote

Responses to "Too Few Parameters?? Date field?"

Paul Whitham TMM
Guest
Posts: n/a
 
Re: Too Few Parameters?? Date field?
Posted: 02-24-2005, 08:27 PM
Unless you have a field in your query called eventydate then this statement
is not going to work.

--
Regards

Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
www.valleybiz.net

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
http://www.macromedia.com/support/fo...eam_macromedia

"Nathon Jones" <nathonjonesNOT@kirkmoor.com> wrote in message
news:cvl1us$3t6$1@forums.macromedia.com...
> Hi,
>
> Access, DWMX, ASP, VBScript.
>
> SELECT eventydate
> FROM qryEvents
> ORDER BY eventydate ASC
>
> Is returning:
>
> Too Few Parameters, Expected 1??
>
> What is wrong?
> PS. I called it eventydate because I was worried that eventdate was a
field
> name I perhaps couldn't use? Both produce the same error.
>
> Doing my head in this.
>
> Nath.
>
>

Reply With Quote
 
LinkBack Thread Tools Search this Thread Display Modes
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
date field in update stored procedure lwd Coldfusion Database Access 3 03-28-2005 08:26 PM
Query a date field in report builder Boise-J-Man Coldfusion Database Access 1 03-04-2005 03:12 AM
Radio btn makes text field equal value of different text field mitchel Dreamweaver AppDev 2 02-22-2005 03:59 PM
adding parameters acidrain9 Dreamweaver AppDev 0 02-19-2005 07:19 PM
Forms: Text field - auto fill another field? LDVDG@adobeforums.com Adobe Acrobat Macintosh 2 08-09-2004 10:02 PM