I tried doing this but I still get the same error message
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2.
/PickADog.asp, line 29
Do I need to declare these 2 variables and do I need an if statement like
if (int_BreederNo!="undefined" && str_PupsAvailable!="undefined")
in order to read in these 2 values from a form like this
</SCRIPT>
<meta name="Microsoft Theme" content="indust 110...
Do I have to declare the two variables txtPupsAvailable and txtBreederNo like this
var int_BreederNo = new Integer(Request.Form("txtBreederNo"))
var str_PupsAvailable = new String(Request.Form("txtPupsAvailable"))
Could somebody have a look at this and tell me what if anything is missing from it:
<%@ LANGUAGE = JavaScript%>
<HTML>
<HEAD>
<meta name="Microsoft Theme" content="indust 110, default">
</HEAD>
<BODY>
<%
// Connect to database
var adoConnection =...
I get the following error message
Error Type:
Microsoft JScript compilation (0x800A03EC)
Expected ';'
/Update.asp, line 17, column 22
& "WHERE BreederNo ='"Request.Form("txtBreederNo") &"'";
---------------------^
How could I modify the following code to allow a breeder to update the pups available field of their record in the breeders table?
<%@ LANGUAGE = JavaScript%>
<HTML>
<HEAD>
<meta name="Microsoft Theme" content="indust 110, default">
</HEAD>
<BODY>
<%
// Connect to...
One of the table fields was incorrectly named and when I corrected it the error message changed to:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2.
/PickADog.asp, line 29
They are all text fields...
One of the table fields was incorrectly named and when I corrected it the error message changed to:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2.
/PickADog.asp, line 29
They are all text fields...
This is the code I used to return a list of breeders for a particuar breed. The BookPup.asp part then allowed the user to add their name to a booking table so it is not relevant in this instance. I want to allow a breeder to update the PupsAvailable field which consists of text stating Yes or...
How could I modify this code to enable a user to update the pups available field
<BODY><TABLE BORDER=1>
<THEAD>
<TR>
<TH>BreederNo</TH>
<TH>Breeder Name</TH>
<TH>Phone No.</TH>
<TH>Address</TH>
<TH>Pups Available</TH>
</TR>
</THEAD>
<% var str_DogName = new...
Breed Name SELECT BreedName FROM Breeds WHERE Size="L" and Grooming="Mod" and ExerciseReq="Mod" and SpaceReq="Mod" and FeedingReq="Mod"
This is what is returned when I pick these radio buttons and submit it
This is the way I inserted your code
<%@ LANGUAGE = "JavaScript"%>
<html>
<head>
<meta name="Microsoft Theme" content="indust 110, default">
</head>
<body><table border="1">
<%var str_DogSize = new...
Could someone please tell me if this is the correct way to go about allowing a user to enter their BreederNo and getting a list of bookings for themselves from the two tables
I have it exactly as you've shown but I still get an error message saying:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 3.
/PickADog.asp, line 29
What's wrong?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.