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 <*> 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/
