[thelist] ASP error: Too few parameters.

Gebreselassie Johnny gebreselassie_johnny at bah.com
Thu May 17 14:01:06 CDT 2001


a view is nothing more than a query that is stored as a table.

-----Original Message-----
From: thelist-admin at lists.evolt.org
[mailto:thelist-admin at lists.evolt.org]On Behalf Of Herrick, Emma
Sent: Thursday, May 17, 2001 2:23 PM
To: thelist at lists.evolt.org
Subject: RE: [thelist] ASP error: Too few parameters.


When I say the sql statement works in access, i mean if I plug it in and run
it, it returns all the records it's supposed to. I did a join on the sql
statement because I didn't think access supported views, though admittedly
I'm a db newbie so I wouldn't really know a view if it hit me in the head.

>-----Original Message-----
>From: Michele Foster [mailto:michele at wordpro.on.ca]
>Sent: Thursday, May 17, 2001 2:03 PM
>To: thelist at lists.evolt.org
>Subject: Re: [thelist] ASP error: Too few parameters.
>
>
>Emma,
>
>Some code would be helpful.  Have you printed out your SQL
>statement to see
>what's missing?  When you say it works in Access, via a View?
>Access can be
>temperamental about allowing View's to be updateable.
>
>Michele
>
>----- Original Message -----
>From: "Herrick, Emma" <eherric at ju.edu>
>
>
>| Does anyone know what this error means?
>|
>| Too few parameters. Expected 9.
>|
>| I get it on my sql statement which works fine if I run it in
>access, but
>not
>| through ASP. 9 is the number of fields I'm retrieving from 2
>tables. Is it
>| because I'm trying to do an update on one table with 2
>tables open? Am I
>not
>| allowed to do that in ASP?
>|
>| I've looked the error up on MS but none of the examples
>seems to apply to
>my
>| issue.
>
>
>
>---------------------------------------
>For unsubscribe and other options, including
>the Tip Harvester and archive of TheList go to:
>http://lists.evolt.org Workers of the Web, evolt !
>

---------------------------------------
For unsubscribe and other options, including
the Tip Harvester and archive of TheList go to:
http://lists.evolt.org Workers of the Web, evolt !





More information about the thelist mailing list