I cannot seem to find my error i keep getting the following error

Microsoft JET Database Engine error '80040e10'

No value given for one or more required parameters.

/private1/tempcartupdate3.asp, line 49

Can any one point out my error cuz i cant.

Thank you all

Here is some snipits

*MyConnection include file is Shown at bottom*



<%

SQLtemp = "SELECT * FROM TempTourPos WHERE Cust_UserName = '" & Request.Cookies("UserName") & "' "
Set rs = MyConnection.Execute(SQLtemp)

while not rs.eof

If Request.Cookies("UserName") = rs("Cust_UserName") then
SQL = "UPDATE TempTourPos SET TourPo = '" & Request.Form("PoNumber") & "', TourTotal = '" & Request.Form("TourTotal") & "', AO_Total = '" & Request.Form("AoTotal") & "', Ship_Total = '" & Request.Form("DelTotal") & "', FPO_Total = '" & Request.Form("FpoTotal") & "' WHERE Cust_UserName = '" & Request.Cookies("UserName") & "' "

MyConnection.Execute(SQL) '<----line 49 here
'response.write(SQL)

'Response.redirect ("test.asp")

End If
rs.MoveNext
Wend

'OnError response.Redirect ("error.asp")
rs.Close
MyConnection.Close
set ConnStr = Nothing

%>

here is the code for the include file

<%
Dim MyConnection
Set MyConnection = Server.CreateObject("ADODB.Connection")
MyConnection.Provider = "Microsoft Jet 4.0 OLE DB Provider"
MyConnection.ConnectionString = "Data Source=D:\home\thomasla\showitbest.com\private1\db \users.mdb"
MyConnection.Properties("Jet OLEDB:Database Password") = "*****"
MyConnection.Open
%>

also when i use the respond.write it displays the following;

UPDATE TempTourPos SET TourPo = '0607200642', TourTotal = '84', AO_Total = '70', Ship_Total = '5', FPO_Total = '159' WHERE Cust_UserName = 'jonnyhip'

to me this is correct.

i have verified the spelling on my tables the connection works on other pages im just so stumped.

It might be that you are using single quotes for fields that are of a numeric data type.
What are the datatypes of all your fields? It looks like any one of these fields could be causing the problem: TourTotal, AO_Total, Ship_Total and FPO_Total

Woody Z http://www.learntoprogramnow.com

I thought about that but i thought if the database was set as those field being text that wouldn't matter. Does it but its possible cuz i do add multiple columns and multiply a couple from the same table to give me the totals. Ill look into thanks.

Well i changed some things around to test if it was a numbers problem and i still get the same error my respond.write now says

UPDATE TempTourPos SET TourPo = 0607200643, TourTotal = 69, AO_Total = 0, Ship_Total = 0, FPO_Total = 69 WHERE Cust_UserName = 'theone'

I really dont get this doesnt seem to me i am doing anything wrong. to me it seems i have all the parameters covered with a value.

Well... Can you hand write a sql statement that DOES work?
That would be an easy step to verify that you have your syntax and all fields correct.
Then you just have your code build the statement to match the one that you know works.

Woody Z http://www.learntoprogramnow.com