Click here to Skip to main content
       

Visual Basic

 
QuestionVB.NET Parameters error PinmemberDiego 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 PinmemberSimon_Whale11-Oct-12 4:45 
GeneralRe: VB.NET Parameters error PinmemberDiego Carrion11-Oct-12 4:47 
GeneralRe: VB.NET Parameters error PinmemberChandraRam11-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
Web02 | 2.8.140916.1 | Last Updated 20 Sep 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid