[thelist] ASP error: Too few parameters.

Herrick, Emma eherric at ju.edu
Thu May 17 13:24:06 CDT 2001

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. 
>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.
>----- 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
>| 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
>| allowed to do that in ASP?
>| I've looked the error up on MS but none of the examples 
>seems to apply to
>| 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 ! 

More information about the thelist mailing list