p2p.wrox.com: Archives - access

access_asp thread: HELP! - Microsoft JET Database Engine error '80040e10'

Message #1 by "Marc Nascimento" <nascimento@r...> on Sat, 9 Feb 2002 20:38:33

Please help if you can. 



I am trying to make a database driven news archive with ASP. 

Now, I have created a database and I have a table called menu.



Inside menu I have the following categories



menu_id, menu_category, menu_name, menu_status, menu_date, menu_thumbnail, 

menu_picture, menu_featured, menu_briedDesc and menu_fullDesc



Here is my error message.



-------------------------------------------------------------------------

Microsoft JET Database Engine error '80040e10' 



No value given for one or more required parameters. 



/summer2001/Marcn/NoID/featured.asp, line 9 



-------------------------------------------------------------------------



And here is the coding for my page - featured.asp 

-------------------------------------------------------------------------

<%



Dim featuredRS

Set featuredRS = Server.CreateObject("ADODB.Recordset")

featuredRS.ActiveConnection = Con

sqlString = "SELECT menu_id, menu_category, menu_name, menu_briefDesc " &_

            "FROM menu WHERE menu_featured=1 " &_

            "AND menu_status=1 " &_

            "ORDER BY menu_name"

featuredRS.Open sqlString    <- LINE 9 

%>



-------------------------------------------------------------------------



If you have any ideas on what the problem is please write back, I am still 

a novice with ASP. So please try to word things in a way I can understand. 

Thanks a bunch.



Marc

nascimento@r...

Message #2 by "Charles Mabbott" <aa8vs@m...> on Sun, 10 Feb 2002 08:15:09 -0500

Please try & _ insted of &_



Kind Regards,

Chuck





>From: "Marc Nascimento" <nascimento@r...>

>Reply-To: "Access ASP" <access_asp@p...>

>To: "Access ASP" <access_asp@p...>

>Subject: [access_asp] HELP! - Microsoft JET Database Engine error 

>'80040e10'

>Date: Sat, 9 Feb 2002 20:38:33

>

>Please help if you can.

>

>I am trying to make a database driven news archive with ASP.

>Now, I have created a database and I have a table called menu.

>

>Inside menu I have the following categories

>

>menu_id, menu_category, menu_name, menu_status, menu_date, menu_thumbnail,

>menu_picture, menu_featured, menu_briedDesc and menu_fullDesc

>

>Here is my error message.

>

>-------------------------------------------------------------------------

>Microsoft JET Database Engine error '80040e10'

>

>No value given for one or more required parameters.

>

>/summer2001/Marcn/NoID/featured.asp, line 9

>

>-------------------------------------------------------------------------

>

>And here is the coding for my page - featured.asp

>-------------------------------------------------------------------------

><%

>

>Dim featuredRS

>Set featuredRS = Server.CreateObject("ADODB.Recordset")

>featuredRS.ActiveConnection = Con

>sqlString = "SELECT menu_id, menu_category, menu_name, menu_briefDesc " &_

>             "FROM menu WHERE menu_featured=1 " &_

>             "AND menu_status=1 " &_

>             "ORDER BY menu_name"

>featuredRS.Open sqlString    <- LINE 9

>%>

>

>-------------------------------------------------------------------------

>

>If you have any ideas on what the problem is please write back, I am still

>a novice with ASP. So please try to word things in a way I can understand.

>Thanks a bunch.

>

>Marc

>nascimento@r...

>

>

>

>

>












"Racial interaction is described by Physics,

for every action there is an opposite

reaction.  We hate them, they hate us, and

we hate them back. And there you are, we are

trapped by mathematics."

    -Londo B5



http://aa8vs.dhs.org:81/aa8vs





_________________________________________________________________

Join the world?s largest e-mail service with MSN Hotmail. 

http://www.hotmail.com

Message #3 by "Marc Nascimento" <nascimento@r...> on Sun, 10 Feb 2002 16:18:17

Thanks for your help Chuck,



I tried changing the &_ to & _ and nothing changed, I'm still getting the 

same error. I don't think that would do anything to the code anyways. I 

almost the same code on a fake ecommerce site I did for school and it 

worked. 



Thank you once again,



Marc



>Please try & _ insted of &_

>

>Kind Regards,

>Chuck





> Please help if you can. 

> 

> I am trying to make a database driven news archive with ASP. 

> Now, I have created a database and I have a table called menu.

> 

> Inside menu I have the following categories

> 

> menu_id, menu_category, menu_name, menu_status, menu_date, 

menu_thumbnail, 

> menu_picture, menu_featured, menu_briedDesc and menu_fullDesc

> 

> Here is my error message.

> 

> -------------------------------------------------------------------------

> Microsoft JET Database Engine error '80040e10' 

> 

> No value given for one or more required parameters. 

> 

> /summer2001/Marcn/NoID/featured.asp, line 9 

> 

> -------------------------------------------------------------------------

> 

> And here is the coding for my page - featured.asp 

> -------------------------------------------------------------------------

> <%

> 

> Dim featuredRS

> Set featuredRS = Server.CreateObject("ADODB.Recordset")

> featuredRS.ActiveConnection = Con

> sqlString = "SELECT menu_id, menu_category, menu_name, menu_briefDesc " 

&_

>             "FROM menu WHERE menu_featured=1 " &_

>             "AND menu_status=1 " &_

>             "ORDER BY menu_name"

> featuredRS.Open sqlString    <- LINE 9 

> %>

> 

> -------------------------------------------------------------------------

> 

> If you have any ideas on what the problem is please write back, I am 

still 

> a novice with ASP. So please try to word things in a way I can 

understand. 

> Thanks a bunch.

> 

> Marc

> nascimento@r...

> 

> 

> 

>

Message #4 by "Caroline & Hossein" <mach3@w...> on Sun, 10 Feb 2002 20:55:39 +0100

Hi

try this. Check your data type of menu_featured and menu_status if you

defined them as number then menu_status = '1' and menu_featured = '1'



Set conn = Server.CreateObject("ADODB.Connection")

conn.open "your datasource name here Conn","",""



sqlString = "SELECT menu_id, menu_category, menu_name, menu_briefDesc " &_

            "FROM menu WHERE menu_featured=1 " &_

            "AND menu_status=1 " &_

            "ORDER BY menu_name"

Set featuredRS= Server.CreateObject("ADODB.Recordset")

featuredRS.Open sqlString , conn, 3, 3



Regards

Hossein











----- Original Message -----

From: "Marc Nascimento" <nascimento@r...>

To: "Access ASP" <access_asp@p...>

Sent: Saturday, February 09, 2002 8:38 PM

Subject: [access_asp] HELP! - Microsoft JET Database Engine error '80040e10'





> Please help if you can.

>

> I am trying to make a database driven news archive with ASP.

> Now, I have created a database and I have a table called menu.

>

> Inside menu I have the following categories

>

> menu_id, menu_category, menu_name, menu_status, menu_date, menu_thumbnail,

> menu_picture, menu_featured, menu_briedDesc and menu_fullDesc

>

> Here is my error message.

>

> -------------------------------------------------------------------------

> Microsoft JET Database Engine error '80040e10'

>

> No value given for one or more required parameters.

>

> /summer2001/Marcn/NoID/featured.asp, line 9

>

> -------------------------------------------------------------------------

>

> And here is the coding for my page - featured.asp

> -------------------------------------------------------------------------

> <%

>

> Dim featuredRS

> Set featuredRS = Server.CreateObject("ADODB.Recordset")

> featuredRS.ActiveConnection = Con

> sqlString = "SELECT menu_id, menu_category, menu_name, menu_briefDesc " &_

>             "FROM menu WHERE menu_featured=1 " &_

>             "AND menu_status=1 " &_

>             "ORDER BY menu_name"

> featuredRS.Open sqlString    <- LINE 9

> %>

>

> -------------------------------------------------------------------------

>

> If you have any ideas on what the problem is please write back, I am still

> a novice with ASP. So please try to word things in a way I can understand.

> Thanks a bunch.

>

> Marc

> nascimento@r...

>

>

>

>

>




$subst('Email.Unsub').

>

Message #5 by "Ken Schaefer" <ken@a...> on Mon, 11 Feb 2002 12:16:01 +1100

www.adopenstatic.com/faq/80040e10.asp



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

----- Original Message -----

From: "Marc Nascimento" <nascimento@r...>

To: "Access ASP" <access_asp@p...>

Sent: Saturday, February 09, 2002 8:38 PM

Subject: [access_asp] HELP! - Microsoft JET Database Engine error '80040e10'





: Please help if you can.

:

: I am trying to make a database driven news archive with ASP.

: Now, I have created a database and I have a table called menu.

:

: Inside menu I have the following categories

:

: menu_id, menu_category, menu_name, menu_status, menu_date, menu_thumbnail,

: menu_picture, menu_featured, menu_briedDesc and menu_fullDesc

:

: Here is my error message.

:

: -------------------------------------------------------------------------

: Microsoft JET Database Engine error '80040e10'

:

: No value given for one or more required parameters.

:

: /summer2001/Marcn/NoID/featured.asp, line 9

:

: -------------------------------------------------------------------------

:

: And here is the coding for my page - featured.asp

: -------------------------------------------------------------------------

: <%

:

: Dim featuredRS

: Set featuredRS = Server.CreateObject("ADODB.Recordset")

: featuredRS.ActiveConnection = Con

: sqlString = "SELECT menu_id, menu_category, menu_name, menu_briefDesc " &_

:             "FROM menu WHERE menu_featured=1 " &_

:             "AND menu_status=1 " &_

:             "ORDER BY menu_name"

: featuredRS.Open sqlString    <- LINE 9

: %>

:

: -------------------------------------------------------------------------

:

: If you have any ideas on what the problem is please write back, I am still

: a novice with ASP. So please try to word things in a way I can understand.

: Thanks a bunch.

:

: Marc

: nascimento@r...

:

:

:

:

:




$subst('Email.Unsub').

Return to Index

P2P Archives