It sounds like it can't find either the table or fields used in the query - that's a common cause for this error. Check that they're spelt correctly on the live database perhaps?
Dan -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of GLSmyth Sent: 24 June 2005 16:20 To: [email protected] Subject: Re: [ASP] No value given for one or more required parameters. Dan - I am developing things using PWS. I have a copy of the database that I use locally. I added the two fields to the table last night and uploaded the new database to the server, where the code is not working. Thinking that perhaps the database did not upload properly, I renamed the database locally and downloaded the one from the server. Looking at the downloaded database showed me that it was the same. The code works just fine locally, but not on the server, which is strange because both databases are the same. Cheers - george --- In [email protected], "Dan Powderhill" <[EMAIL PROTECTED]> wrote: > Are you downloading the database to run the query locally? > > Dan > > -----Original Message----- > From: [email protected] > [mailto:[EMAIL PROTECTED] On Behalf Of GLSmyth > Sent: 24 June 2005 14:50 > To: [email protected] > Subject: Re: [ASP] No value given for one or more required parameters. > > Dan - > > Thank you. I changed the statement to: > > Select [Question] From [Registration] Where [Username] = 'z' > > without any change. > > The statement works fine as a query locally. I do not know how to run > Access remotely. Any idea how to do that? If I could then I would > almost surely get a more helpful error message. > > Cheers - > > george > > > --- In [email protected], "Dan Powderhill" > <[EMAIL PROTECTED]> wrote: > > Try wrapping Question and Registration in brackets as well. > > > > If that doesn't work, copy your SQL into a new query in the target > > database within Access and see what error message it gives you, if > any. > > > > Dan > > > > -----Original Message----- > > From: [email protected] > > [mailto:[EMAIL PROTECTED] On Behalf Of GLSmyth > > Sent: 24 June 2005 14:14 > > To: [email protected] > > Subject: Re: [ASP] No value given for one or more required parameters. > > > > Dave - > > > > Thank you for the response. I have never used brackets, though I > > normally write for SQL Server databases. > > > > I changed the statement to: > > > > Select Question From Registration Where [Username] = 'z' > > > > Unfortunately, this did not have any affect. > > > > Any other guesses as to what might be going on here? > > > > Thanks - > > > > george > > > > > > --- In [email protected], "David Smart" > > <[EMAIL PROTECTED]> wrote: > > > Is it possible that the server has a different version of the JET > > engine? > > > > > > I don't like the way you're not putting your field and table names > > inside [] brackets - especially a field name of "username". It's > > possible that this is what's giving you grief. Try it with the > > brackets around the names. > > > > > > Dave S > > > ----- Original Message ----- > > > From: GLSmyth > > > To: [email protected] > > > Sent: Friday, June 24, 2005 12:14 PM > > > Subject: [ASP] No value given for one or more required parameters. > > > > > > > > > I am having a strange problem. I am developing under PWS on > Windows > > > 2000 and when done with a program I move it to the server. This > > works > > > quite well. I am using ASP, not ASP.NET and an Access database. > > > > > > I added a couple of fields to the database locally then uploaded > the > > > database to the server (the system is not yet live), so they > should > > > both be the same. > > > > > > A program that works just fine locally is giving me the > > > following > > error: > > > > > > Microsoft JET Database Engine error '80040e10' > > > No value given for one or more required parameters. > > > /Administration/User/LostPassword.asp, line 53 > > > > > > Line 53 is trying to execute an SQL statement, which is simply: > > > Select Question From Registration Where Username = 'z' > > > > > > I am not understanding why this might be happening. Just to > > > make > > sure > > > that the two databases actually were the same, I renamed the > > database > > > locally and downloaded it from the server. The program works just > > > fine locally. > > > > > > Any help that can be offered with this strange problem would be > > > greatly appreciated. > > > > > > Cheers - > > > > > > george > > > > > > > > > > > > > > > > > -------------------------------------------------------------------- > > - > > > > > Home : http://groups.yahoo.com/group/active-server-pages > > > > > -------------------------------------------------------------------- > > - > > > Post : [email protected] > > > Subscribe : [EMAIL PROTECTED] > > > Unsubscribe: [EMAIL PROTECTED] > > > > > > ------------------------------------------------------------------ > > > -- > > > - > > > > > > > > > > > > > > -------------------------------------------------------------------- > > -- > > -- > > ------ > > > Yahoo! Groups Links > > > > > > a.. To visit your group on the web, go to: > > > http://groups.yahoo.com/group/active-server-pages/ > > > > > > b.. To unsubscribe from this group, send an email to: > > > [EMAIL PROTECTED] > > > > > > c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms > > > of > > Service. > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > -------------------------------------------------------------------- > > - > > > > Home : http://groups.yahoo.com/group/active-server-pages > > --------------------------------------------------------------------- > > Post : [email protected] > > Subscribe : [EMAIL PROTECTED] > > Unsubscribe: [EMAIL PROTECTED] > > -------------------------------------------------------------------- > > - > > Yahoo! Groups Links > > > > > > --------------------------------------------------------------------- > > Home : http://groups.yahoo.com/group/active-server-pages > --------------------------------------------------------------------- > Post : [email protected] > Subscribe : [EMAIL PROTECTED] > Unsubscribe: [EMAIL PROTECTED] > --------------------------------------------------------------------- > Yahoo! Groups Links --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [email protected] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [email protected] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
