Click here to Skip to main content
11,709,220 members (60,580 online)

Visual Basic

 
QuestionVB.NET Parameters error Pin
Diego Carrion11-Oct-12 4:12
memberDiego Carrion11-Oct-12 4:12 
<html>
<form name="form1" action="ordersconnection3.asp" method="post">



Employee ID :
<input type="number" name="Employee_ID" min="0" max="999999999">


Customer ID :
<input type="number" name="Customer_ID" min="0" max="999999999">


Order Date :
<input type="date" name="Order_Date">


Shipped Date :
<input type="date" name="Shipped_Date">


Shipper ID :
<input type="name" name="Shipper_ID">


Ship Name :
<input type="text" name="Ship_Name">


Ship Address :
<input type="text" name="Ship_Address">


Ship City :
<input type="text" name="Ship_City">


Ship State/Province :
<input type="text" name="Ship_State_Province">


Ship ZIP/Postal Code :
<input type="text" name="Ship_ZIP_Postal_Code">


Ship Country/Region :
<input type="text" name="Ship_Country_Region">


Shipping Fee :
<input type="number" name="Shiping_Fee" min="0" max="999999999">


Taxes :
<input type="number" name="Taxes" min="0" max="999999999">


Payment Type :
<input type="text" name="Payment_Type">


Paid Date :
<input type="date" name="Paid_Date">


Notes :
<input type="text" name="Notes">


Tax Rate :
<input type="number" name="Tax_Rate" min="0" max="999999999">


Tax Status :
<input type="number" name="Tax_Status" min="0" max="999999999">


Status ID :
<input type="number" name="Status_ID" min="0" max="999999999">

 
<input type="submit" value="submit details" name="submit">



</form>
</html>
<%
Dim Employee_ID, Customer_ID, Order_Date, Shipped_Date, Shipper_ID, Ship_Name,

Ship_Address, Ship_City, Ship_State_Province, Ship_ZIP_Postal_Code, Ship_Country_Region,

Shipping_Fee, Taxes, Payment_Type, Paid_Date, Notes, Tax_Rate, Tax_Status, Status_ID
Dim sConnString, connection, sSQL

Employee_ID=Request.Form("Employee_ID")
Customer_ID=Request.Form("Customer_ID")
Order_Date=Request.Form("Order_Date")
Shipped_Date=Request.Form("Shipped_Date")
Shipper_ID=Request.Form("Shipper_ID")
Ship_Name=Request.Form("Ship_Name")
Ship_Address=Request.Form("Ship_Address")
Ship_City=Request.Form("Ship_City")
Ship_State_Province=Request.Form("Ship_State_Province")
Ship_ZIP_Postal_Code=Request.Form("Ship_ZIP_Postal_Code")
Ship_Country_Region=Request.Form("Ship_Country_Region")
Shipping_Fee=Request.Form("Shipping_Fee")
Taxes=Request.Form("Taxes")
Payment_Type=Request.Form("Payment_Type")
Paid_Date=Request.Form("Paid_Date")
Notes=Request.Form("Notes")
Tax_Rate=Request.Form("Tax_Rate")
Tax_Status=Request.Form("Tax_Status")
Status_ID=Request.Form("Status_ID")

sSQL = "INSERT INTO Orders (Employee_ID, Customer_ID, Order_Date, Shipped_Date,

Shipper_ID, Ship_Name, Ship_Address, Ship_City, Ship_State_Province,

Ship_ZIP_Postal_Code, Ship_Country_Region, Shipping_Fee, Taxes, Payment_Type, Paid_Date,

Notes, Tax_Rate, Tax_Status, Status_ID) Values (" & Employee_ID & ", " & Customer_ID & ",

#" & Order_Date & "#, #" & Shipped_Date & "#, " & Shipper_ID & ", '" & Ship_Name & "', '"

& Ship_Address & "', '" & Ship_City & "', '" & Ship_State_Province & "', '" &

Ship_ZIP_Postal_Code & "', '" & Ship_Country_Region & "', '' & Shipping_Fee & '', '' &

Taxes & '', '" & Payment_Type & "', #" & Paid_Date & "#, '" & Notes & "', '" & Tax_Rate &

"', '" & Tax_Status & "', '" & Status_ID & "')"


sConnString="PROVIDER=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & Server.MapPath

("/database/Examen.mdb")
Set connection = Server.CreateObject("ADODB.Connection")

connection.Open(sConnString)
connection.execute(sSQL)


response.write "The form information was inserted successfully."

connection.Close
Set connection = Nothing
%>

I have an HTML Form that request various data types and I keep getting the following error:

Microsoft JET Database Engine error '80040e10'

No value given for one or more required parameters.

/ordersconnection3.asp, line 32

It's a Microsoft Access Database. Any help will be appreciated.
AnswerRe: VB.NET Parameters error Pin
Simon_Whale11-Oct-12 4:45
memberSimon_Whale11-Oct-12 4:45 
GeneralRe: VB.NET Parameters error Pin
Diego Carrion11-Oct-12 4:47
memberDiego Carrion11-Oct-12 4:47 
GeneralRe: VB.NET Parameters error Pin
ChandraRam11-Oct-12 11:06
memberChandraRam11-Oct-12 11:06 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web03 | 2.8.150819.1 | Last Updated 31 Aug 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid