Error: No value given for one or more required parameters.

Hi i am trying to update a recored using ASP, but i cannot get the record to save: here is my code:

Expand|Select|Wrap|Line Numbers

 <%

user=request.serverVariables("LOGON_USER")

no=Request("PAGEID")
 
set conn=Server.CreateObject("ADODB.Connection")

conn.Provider="Microsoft.Jet.OLEDB.4.0"

Conn.Mode = 3

conn.Open(Server.Mappath("../../../shared/setup/site.mdb"))

set rs = Server.CreateObject("ADODB.recordset")
 
       sql="UPDATE StuPages SET"

        sql=sql & " Content='" & Request("content") & "' WHERE Page= " & no & ""
 
        on error resume next
 
        conn.Execute sql

         if err<>0 then

                response.write("Error: " & err.Description)

                response.write("<BR>")

                response.write("ERROR CODE: "& err.number)

        else %>

<body background="../../../shared/Wallpaper.gif">

<h1><font face="Comic Sans MS" color="#FF0000">Changes To The Staff Page Has Been 

  Saved.</font></h1>

<BR>

<font face="Comic Sans MS">This Window Will Automatically Close. Please Refresh 

Your Page To See The Changes.</font> 

<script language="javascript"> 

<!-- 

setTimeout("self.close();",500) 

//--> 

</script> 

       <% end if 
 
conn.close%>

<BR>

<%response.write ""&no%>

<BR>

<%response.write request.serverVariables("LOGON_USER")

%>

Dec 14 '07 #1

Subscribe Post Reply

1404

missinglinq

3,532

Expert 2GB

Since this is an ASP question I am moving it from the Access/VBA forum to the ASP forum!

Welcome to TheScript!

Linq ;0)>

Dec 14 '07 #2

Nicodemas

164

Expert 100+

That error is normally indicative of a misspelled, or non-existent field in your SQL query. Check to make sure that Page and Content are both fields of table: StuPage

Dec 14 '07 #3

Similar topics

Error Trapping In Access 2000

by: Peter Frost | last post by:

Please help I don't know if this is possible but what I would really like to do is to use On Error Goto to capture the code that is being executed when an error occurs. Any help would be much...

Microsoft Access / VBA

Logon Error

by: Alixx Skevington | last post by:

OK why does the following code work in a Windows form with a crystal report viewer but not in a webform. I get the usual CrystalReports.EngineLogONException logon Failed when this is called in...

ASP.NET

Error: "System.Data.OleDb.OleDbException: No value given for one or more required parameters"

by: Brian Foree | last post by:

I am developing an ASP.NET application that uses Access 2000 as its backend, and have just started getting the following error on 2 ASP.NET pages that had been working until late last week (and I...

ASP.NET

Asp script connected to sql server gives error

by: Jack | last post by:

I have the following asp script which I am trying to run against sql server. <HTML> <HEAD> <META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0"> <TITLE>Chapter 12 - Command...

ASP / Active Server Pages

"No value given for one or more required parameters" Error

by: Grayscale | last post by:

Hello, When I execute the code below, I get: "Microsoft JET Database Engine (0x80040E10) No value given for one or more required parameters." error message in the first line. Rs.Open...

ASP / Active Server Pages

Intermittent database error

by: Dave | last post by:

I am getting an intermittent database error on my asp page. I am using Access 2003 with classic ASP. The error is this: Microsoft JET Database Engine Error 80040e10 No value given for one or...

ASP / Active Server Pages

Help Needed. Update with parameters error - No value given for one or more parameters.

by: Hexman | last post by:

Hello All, Well I'm stumped once more. Need some help. Writing a simple select and update program using VB.Net 2005 and an Access DB. I'm using parameters in my update statement and when trying...

Visual Basic .NET

'80040e10 Error: No value given for one or more required parameters

by: Dave | last post by:

I am getting the error above intermittantly with an ASP 3.0 page using an MS Access 2003 database. I have searched Google extensively and found the following possible causes for this error: A...

ASP / Active Server Pages

Compilation error - Parameterized update

by: dancer | last post by:

Using Asp.net 1.1 Can somebody tell me why the code following gives this error message: Compilation Error Description: An error occurred during the compilation of a resource required to service...

ASP.NET

Error: "No value given for one or more required parameters

by: Gwen Crutcher | last post by:

I keep getting the error "No value given for one or more required parameters", but not sure why. Can anyone please look at my code snipet and see if you see any reason why I could be getting this...

ASP / Active Server Pages

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA