Wrox Programmer Forums
|
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 11th, 2006, 06:42 AM
Authorized User
 
Join Date: Aug 2005
Posts: 96
Thanks: 0
Thanked 0 Times in 0 Posts
Default Microsoft JET Database Engine error '80040e10'

Hi there, I continue to get the following error when trying to update a form.

Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/html/advertiser-basic-details.asp, line 144

Some of my code below.

SELECT tblSuppliers.idSupplier, tblLocation.Location, tblCountry.Country
FROM tblCountry INNER JOIN (tblLocation INNER JOIN tblSuppliers ON tblLocation.idLocation = tblSuppliers.iLocation) ON tblCountry.idCountry = tblSuppliers.iCountry

    ' execute the update
    Set MM_editCmd = Server.CreateObject("ADODB.Command")
    MM_editCmd.ActiveConnection = MM_editConnection
    MM_editCmd.CommandText = MM_editQuery
    MM_editCmd.Execute <------------ Line 144
    MM_editCmd.ActiveConnection.Close
    If (MM_editRedirectUrl <> "") Then
      Response.Redirect(MM_editRedirectUrl)
    End If
  End If
End If
%>

 
Old May 11th, 2006, 07:13 AM
Authorized User
 
Join Date: Aug 2005
Posts: 96
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I just noticed that if I enter a number rather than text, it works....

:(

Anyway around this by changing a little code?

 
Old May 11th, 2006, 09:16 AM
Friend of Wrox
 
Join Date: May 2006
Posts: 643
Thanks: 0
Thanked 0 Times in 0 Posts
Default

It is unclear from your code what you mean by "enter a number". Your Select statement as supplied does not use dynamically supplide values... it isn't an update statement, but merely a select statement. Executing that statement will should return a recordset, not update the database. Is it possible this is not part of the code you are trying to fix?

Woody Z http://www.learntoprogramnow.com
 
Old June 6th, 2006, 09:01 PM
Registered User
 
Join Date: Jun 2006
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Did you ever get an answer cuz im having the same problem some what

 
Old June 6th, 2006, 09:20 PM
Authorized User
 
Join Date: Aug 2005
Posts: 96
Thanks: 0
Thanked 0 Times in 0 Posts
Default

No I dont think we ended up using that code, didnt get any result. Are you getting the result because of an INNER JOIN, or is it something else?

Mally
 
Old June 6th, 2006, 10:07 PM
Registered User
 
Join Date: Jun 2006
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

http://p2p.wrox.com/topic.asp?TOPIC_...Terms=80040e10 check out this forum






Similar Threads
Thread Thread Starter Forum Replies Last Post
Microsoft JET Database Engine error '80040e10' byronthurman Classic ASP Databases 5 June 8th, 2006 08:20 AM
Microsoft JET Database Engine error '80040e10' froggzrevenge Classic ASP Databases 2 January 10th, 2005 12:44 AM
Microsoft JET Database Engine error '80040e10' waynehultum Classic ASP Databases 15 August 20th, 2004 10:22 AM
Microsoft JET Database Engine error '80040e10' shermttam Classic ASP Databases 9 December 10th, 2003 01:57 AM
Microsoft JET Database Engine error '80040e10' nvillare Classic ASP Databases 1 August 20th, 2003 12:09 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.