p2p.wrox.com: Archives - asp_web

asp_web_howto thread: Error

Message #1 by "Jonathan Marshall" <jdmarsh2g@h...> on Mon, 17 Dec 2001 19:37:43 +0000

Totally stumped on this error





Error Type:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)

[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 7.

/app_update_insert.asp, line 243



app_update_insert.asp

**************************************************************************************

<%

'Declare variables needed

dim oConn,oRSapp,strInsert,strValues,adCmdText,objCmd,objConn,sqlString

dim varApplication

dim varOriginator

dim varTitle

dim varProblem

dim varPeopleID

dim varID

dim varAction



varApplication = Request.form("Application")

varOriginator = Request.form("Originator")

varProblem = Request.form("Problem")

varTitle = Request.form("Title")

varPeopleID = Request.form("PeopleID")

varID = Request.form("ID")

varAction = Request.form("Action")



response.write "<b>Application value:</b>&nbsp;" & varApplication & "<br>"

response.write "<b>Originator value:</b>&nbsp;" & varOriginator & "<br>"

response.write "<b>Problem value:</b>&nbsp;" & varProblem & "<br>"

response.write "<b>Title value:</b>&nbsp;" & varTitle & "<br>"

response.write "<b>People ID value:</b>&nbsp;" & varPeopleID & "<br>"

response.write "<b>Tracking Number value:</b>&nbsp;" & varID & "<br>"

response.write "<b>Action value:</b>&nbsp;" & varAction & "<br>"

response.write Request.Form

set oRSapp = Server.CreateObject("ADODB.Recordset")



adCmdText = 1

strInsert = ("UPDATE app_change SET ID = varID, Application = 

varApplication, Originator = varOriginator,

Title = varTitle, Problem = varProblem, PeopleID = varPeopleID, Action = 

varAction WHERE ID=" & varID &

"")



sqlString = strInsert

'Create the command object

set objConn=Server.CreateObject("ADODB.Connection")

objConn.Open "DSN=application"



set objCmd = Server.CreateObject("ADODB.Command")

set objCmd.ActiveConnection = objConn

objCmd.CommandText = sqlString

objCmd.CommandType = adCmdText



'Display the insert string

Response.Write sqlString



objCmd.Execute



'Close and dereference database objects

oRSapp.Close

  Set oRSapp = Nothing

  Set objCmd = Nothing

objConn.Close

  Set objConn = Nothing

**************************************************************************************



Here is app_update.asp

**************************************************************************************

<form ACTION=app_update_insert.asp method=post>



  <table>

  <tr>

  <td><b>Application:</b></td>

  <td><input type=text name=Application 

value="<%=oRSsearch("Application")%>">

  </td><br>

  </tr>

  <tr>

  <td><b>Originator:</b></td>

  <td><input type=text name=Originator value="<%=oRSsearch("Originator")%>">

  </td>

  </tr>

  <tr>

  <td><b>Request Date:</b></td>

  <td><INPUT TYPE=TEXT NAME=REQUEST_ON SIZE=10

VALUE="<%=oRSsearch("Request_on")%>"><br></td>

  </tr>

  <tr>

  <td><b>Title:</b></td>

  <td><INPUT TYPE=TEXT  NAME=Title SIZE=40 

value="<%=oRSsearch("Title")%>"></td>

  </tr>

  <tr>

  <td><b>Tracking Number:</b></td>

  <td><INPUT TYPE=TEXT  NAME=ID SIZE=2 value="<%=oRSsearch("ID")%>"></td>

  </tr>

  <tr>

  <td><b>Problem:</b></td>

  <td><TEXTAREA  NAME=PROBLEM COLS=50 ROWS=3

WRAP=PHYSICAL><%=oRSsearch("Problem")%> </TEXTAREA></td>

  </tr>

  <tr>

  <td><b>EnterID#:</b></td>

  <td><input name=PeopleID size=2 

value="<%=oRSsearch("PeopleID")%>">&nbsp;&nbsp;<font color=red>If

you forgot your ID please<a href=ID.asp>CLICK HERE</font></a></td>



  </tr>

  </table>

  <center><INPUT TYPE=submit VALUE="Update">&nbsp;<input type=reset 

value="Clear Form" ></center>



  </form>

**************************************************************************************



_________________________________________________________________

Join the world?s largest e-mail service with MSN Hotmail. 

http://www.hotmail.com

Message #2 by "Drew, Ron" <RDrew@B...> on Tue, 18 Dec 2001 12:05:39 -0500

strInsert =3D "UPDATE app_change SET "

strInsert =3D strInsert & "Application =3D " & varApplication

strInsert =3D strInsert & ", Originator =3D " & varOriginator

strInsert =3D strInsert & ", Title =3D " & varTitle

strInsert =3D strInsert & ", Problem =3D " & varProblem

strInsert =3D strInsert & ", PeopleID =3D " & varPeopleID

strInsert =3D strInsert & ", Action =3D " & varAction

strInsert =3D strInsert & " WHERE ID=3D" & varID



-----Original Message-----

From: Jonathan Marshall [mailto:jdmarsh2g@h...]

Sent: Monday, December 17, 2001 2:38 PM

To: ASP Web HowTo

Subject: [asp_web_howto] Error



Totally stumped on this error





Error Type:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)

[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected

7.

/app_update_insert.asp, line 243



app_update_insert.asp

************************************************************************

**************

<%

'Declare variables needed

dim oConn,oRSapp,strInsert,strValues,adCmdText,objCmd,objConn,sqlString

dim varApplication

dim varOriginator

dim varTitle

dim varProblem

dim varPeopleID

dim varID

dim varAction



varApplication =3D Request.form("Application")

varOriginator =3D Request.form("Originator")

varProblem =3D Request.form("Problem")

varTitle =3D Request.form("Title")

varPeopleID =3D Request.form("PeopleID")

varID =3D Request.form("ID")

varAction =3D Request.form("Action")



response.write "<b>Application value:</b>&nbsp;" & varApplication &

"<br>"

response.write "<b>Originator value:</b>&nbsp;" & varOriginator & "<br>"

response.write "<b>Problem value:</b>&nbsp;" & varProblem & "<br>"

response.write "<b>Title value:</b>&nbsp;" & varTitle & "<br>"

response.write "<b>People ID value:</b>&nbsp;" & varPeopleID & "<br>"

response.write "<b>Tracking Number value:</b>&nbsp;" & varID & "<br>"

response.write "<b>Action value:</b>&nbsp;" & varAction & "<br>"

response.write Request.Form

set oRSapp =3D Server.CreateObject("ADODB.Recordset")



adCmdText =3D 1

strInsert =3D ("UPDATE app_change SET ID =3D varID, Application =3D

varApplication, Originator =3D varOriginator,

Title =3D varTitle, Problem =3D varProblem, PeopleID =3D varPeopleID, 

Action =3D



varAction WHERE ID=3D" & varID &

"")



sqlString =3D strInsert

'Create the command object

set objConn=3DServer.CreateObject("ADODB.Connection")

objConn.Open "DSN=3Dapplication"



set objCmd =3D Server.CreateObject("ADODB.Command")

set objCmd.ActiveConnection =3D objConn

objCmd.CommandText =3D sqlString

objCmd.CommandType =3D adCmdText



'Display the insert string

Response.Write sqlString



objCmd.Execute



'Close and dereference database objects

oRSapp.Close

  Set oRSapp =3D Nothing

  Set objCmd =3D Nothing

objConn.Close

  Set objConn =3D Nothing

************************************************************************

**************



Here is app_update.asp

************************************************************************

**************

<form ACTION=3Dapp_update_insert.asp method=3Dpost>



  <table>

  <tr>

  <td><b>Application:</b></td>

  <td><input type=3Dtext name=3DApplication

value=3D"<%=3DoRSsearch("Application")%>">

  </td><br>

  </tr>

  <tr>

  <td><b>Originator:</b></td>

  <td><input type=3Dtext name=3DOriginator

value=3D"<%=3DoRSsearch("Originator")%>">

  </td>

  </tr>

  <tr>

  <td><b>Request Date:</b></td>

  <td><INPUT TYPE=3DTEXT NAME=3DREQUEST_ON SIZE=3D10

VALUE=3D"<%=3DoRSsearch("Request_on")%>"><br></td>

  </tr>

  <tr>

  <td><b>Title:</b></td>

  <td><INPUT TYPE=3DTEXT  NAME=3DTitle SIZE=3D40

value=3D"<%=3DoRSsearch("Title")%>"></td>

  </tr>

  <tr>

  <td><b>Tracking Number:</b></td>

  <td><INPUT TYPE=3DTEXT  NAME=3DID SIZE=3D2

value=3D"<%=3DoRSsearch("ID")%>"></td>

  </tr>

  <tr>

  <td><b>Problem:</b></td>

  <td><TEXTAREA  NAME=3DPROBLEM COLS=3D50 ROWS=3D3

WRAP=3DPHYSICAL><%=3DoRSsearch("Problem")%> </TEXTAREA></td>

  </tr>

  <tr>

  <td><b>EnterID#:</b></td>

  <td><input name=3DPeopleID size=3D2

value=3D"<%=3DoRSsearch("PeopleID")%>">&nbsp;&nbsp;<font color=3Dred>If

you forgot your ID please<a href=3DID.asp>CLICK HERE</font></a></td>



  </tr>

  </table>

  <center><INPUT TYPE=3Dsubmit VALUE=3D"Update">&nbsp;<input 

type=3Dreset

value=3D"Clear Form" ></center>



  </form>

************************************************************************

**************



_________________________________________________________________

Join the world's largest e-mail service with MSN Hotmail.

http://www.hotmail.com








$subst('Email.Unsub').

Message #3 by "Drew, Ron" <RDrew@B...> on Tue, 18 Dec 2001 12:14:08 -0500

Reply did not put the breaks in...so make sure each line starts with

"strInsert =3D"



-----Original Message-----

From: Drew, Ron

Sent: Tuesday, December 18, 2001 12:06 PM

To: ASP Web HowTo

Subject: [asp_web_howto] RE: Error



strInsert =3D "UPDATE app_change SET "

strInsert =3D strInsert & "Application =3D " & varApplication

strInsert =3D strInsert & ", Originator =3D " & varOriginator

strInsert =3D strInsert & ", Title =3D " & varTitle

strInsert =3D strInsert & ", Problem =3D " & varProblem

strInsert =3D strInsert & ", PeopleID =3D " & varPeopleID

strInsert =3D strInsert & ", Action =3D " & varAction

strInsert =3D strInsert & " WHERE ID=3D" & varID



-----Original Message-----

From: Jonathan Marshall [mailto:jdmarsh2g@h...]

Sent: Monday, December 17, 2001 2:38 PM

To: ASP Web HowTo

Subject: [asp_web_howto] Error



Totally stumped on this error





Error Type:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)

[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected

7.

/app_update_insert.asp, line 243



app_update_insert.asp

************************************************************************

**************

<%

'Declare variables needed

dim oConn,oRSapp,strInsert,strValues,adCmdText,objCmd,objConn,sqlString

dim varApplication

dim varOriginator

dim varTitle

dim varProblem

dim varPeopleID

dim varID

dim varAction



varApplication =3D Request.form("Application")

varOriginator =3D Request.form("Originator")

varProblem =3D Request.form("Problem")

varTitle =3D Request.form("Title")

varPeopleID =3D Request.form("PeopleID")

varID =3D Request.form("ID")

varAction =3D Request.form("Action")



response.write "<b>Application value:</b>&nbsp;" & varApplication &

"<br>"

response.write "<b>Originator value:</b>&nbsp;" & varOriginator & "<br>"

response.write "<b>Problem value:</b>&nbsp;" & varProblem & "<br>"

response.write "<b>Title value:</b>&nbsp;" & varTitle & "<br>"

response.write "<b>People ID value:</b>&nbsp;" & varPeopleID & "<br>"

response.write "<b>Tracking Number value:</b>&nbsp;" & varID & "<br>"

response.write "<b>Action value:</b>&nbsp;" & varAction & "<br>"

response.write Request.Form

set oRSapp =3D Server.CreateObject("ADODB.Recordset")



adCmdText =3D 1

strInsert =3D ("UPDATE app_change SET ID =3D varID, Application =3D

varApplication, Originator =3D varOriginator,

Title =3D varTitle, Problem =3D varProblem, PeopleID =3D varPeopleID, 

Action =3D



varAction WHERE ID=3D" & varID &

"")



sqlString =3D strInsert

'Create the command object

set objConn=3DServer.CreateObject("ADODB.Connection")

objConn.Open "DSN=3Dapplication"



set objCmd =3D Server.CreateObject("ADODB.Command")

set objCmd.ActiveConnection =3D objConn

objCmd.CommandText =3D sqlString

objCmd.CommandType =3D adCmdText



'Display the insert string

Response.Write sqlString



objCmd.Execute



'Close and dereference database objects

oRSapp.Close

  Set oRSapp =3D Nothing

  Set objCmd =3D Nothing

objConn.Close

  Set objConn =3D Nothing

************************************************************************

**************



Here is app_update.asp

************************************************************************

**************

<form ACTION=3Dapp_update_insert.asp method=3Dpost>



  <table>

  <tr>

  <td><b>Application:</b></td>

  <td><input type=3Dtext name=3DApplication

value=3D"<%=3DoRSsearch("Application")%>">

  </td><br>

  </tr>

  <tr>

  <td><b>Originator:</b></td>

  <td><input type=3Dtext name=3DOriginator

value=3D"<%=3DoRSsearch("Originator")%>">

  </td>

  </tr>

  <tr>

  <td><b>Request Date:</b></td>

  <td><INPUT TYPE=3DTEXT NAME=3DREQUEST_ON SIZE=3D10

VALUE=3D"<%=3DoRSsearch("Request_on")%>"><br></td>

  </tr>

  <tr>

  <td><b>Title:</b></td>

  <td><INPUT TYPE=3DTEXT  NAME=3DTitle SIZE=3D40

value=3D"<%=3DoRSsearch("Title")%>"></td>

  </tr>

  <tr>

  <td><b>Tracking Number:</b></td>

  <td><INPUT TYPE=3DTEXT  NAME=3DID SIZE=3D2

value=3D"<%=3DoRSsearch("ID")%>"></td>

  </tr>

  <tr>

  <td><b>Problem:</b></td>

  <td><TEXTAREA  NAME=3DPROBLEM COLS=3D50 ROWS=3D3

WRAP=3DPHYSICAL><%=3DoRSsearch("Problem")%> </TEXTAREA></td>

  </tr>

  <tr>

  <td><b>EnterID#:</b></td>

  <td><input name=3DPeopleID size=3D2

value=3D"<%=3DoRSsearch("PeopleID")%>">&nbsp;&nbsp;<font color=3Dred>If

you forgot your ID please<a href=3DID.asp>CLICK HERE</font></a></td>



  </tr>

  </table>

  <center><INPUT TYPE=3Dsubmit VALUE=3D"Update">&nbsp;<input 

type=3Dreset

value=3D"Clear Form" ></center>



  </form>

************************************************************************

**************



_________________________________________________________________

Join the world's largest e-mail service with MSN Hotmail.

http://www.hotmail.com








$subst('Email.Unsub').






$subst('Email.Unsub').

Message #4 by "Jonathan Marshall" <jdmarsh2g@h...> on Tue, 18 Dec 2001 20:50:53 +0000

<html><div style='background-color:'><P>Im not sure what you mean.&nbsp; Totally
lost</P>

<P>jdm&nbsp;</P>

<DIV></DIV>

<DIV></DIV>

<DIV></DIV>

<P>&nbsp;</P>

<P>&nbsp;</P>

<P>&gt;From: "Drew, Ron" <RDREW@B...></P>

<DIV></DIV>&gt;Reply-To: "ASP Web HowTo" <ASP_WEB_HOWTO@P...>

<DIV></DIV>&gt;To: "ASP Web HowTo" <ASP_WEB_HOWTO@P...>

<DIV></DIV>&gt;Subject: [asp_web_howto] RE: Error 

<DIV></DIV>&gt;Date: Tue, 18 Dec 2001 12:14:08 -0500 

<DIV></DIV>&gt; 

<DIV></DIV>&gt;Reply did not put the breaks in...so make sure each line starts with 

<DIV></DIV>&gt;"strInsert =" 

<DIV></DIV>&gt; 

<DIV></DIV>&gt;-----Original Message----- 

<DIV></DIV>&gt;From: Drew, Ron 

<DIV></DIV>&gt;Sent: Tuesday, December 18, 2001 12:06 PM 

<DIV></DIV>&gt;To: ASP Web HowTo 

<DIV></DIV>&gt;Subject: [asp_web_howto] RE: Error 

<DIV></DIV>&gt; 

<DIV></DIV>&gt;strInsert = "UPDATE app_change SET " 

<DIV></DIV>&gt;strInsert = strInsert &amp; "Application = " &amp; varApplication 

<DIV></DIV>&gt;strInsert = strInsert &amp; ", Originator = " &amp; varOriginator 

<DIV></DIV>&gt;strInsert = strInsert &amp; ", Title = " &amp; varTitle 

<DIV></DIV>&gt;strInsert = strInsert &amp; ", Problem = " &amp; varProblem 

<DIV></DIV>&gt;strInsert = strInsert &amp; ", PeopleID = " &amp; varPeopleID 

<DIV></DIV>&gt;strInsert = strInsert &amp; ", Action = " &amp; varAction 

<DIV></DIV>&gt;strInsert = strInsert &amp; " WHERE ID=" &amp; varID 

<DIV></DIV>&gt; 

<DIV></DIV>&gt;-----Original Message----- 

<DIV></DIV>&gt;From: Jonathan Marshall [mailto:jdmarsh2g@h...] 

<DIV></DIV>&gt;Sent: Monday, December 17, 2001 2:38 PM 

<DIV></DIV>&gt;To: ASP Web HowTo 

<DIV></DIV>&gt;Subject: [asp_web_howto] Error 

<DIV></DIV>&gt; 

<DIV></DIV>&gt;Totally stumped on this error 

<DIV></DIV>&gt; 

<DIV></DIV>&gt; 

<DIV></DIV>&gt;Error Type: 

<DIV></DIV>&gt;Microsoft OLE DB Provider for ODBC Drivers (0x80040E10) 

<DIV></DIV>&gt;[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 

<DIV></DIV>&gt;7. 

<DIV></DIV>&gt;/app_update_insert.asp, line 243 

<DIV></DIV>&gt; 

<DIV></DIV>&gt;app_update_insert.asp 

<DIV></DIV>&gt;************************************************************************ 

<DIV></DIV>&gt;************** 

<DIV></DIV>&gt;<%

</DIV>>'Declare variables needed

</DIV>>dim oConn,oRSapp,strInsert,strValues,adCmdText,objCmd,objConn,sqlString

</DIV>>dim varApplication

</DIV>>dim varOriginator

</DIV>>dim varTitle

</DIV>>dim varProblem

</DIV>>dim varPeopleID

</DIV>>dim varID

</DIV>>dim varAction

</DIV>>

</DIV>>varApplication = Request.form("Application")

</DIV>>varOriginator = Request.form("Originator")

</DIV>>varProblem = Request.form("Problem")

</DIV>>varTitle = Request.form("Title")

</DIV>>varPeopleID = Request.form("PeopleID")

</DIV>>varID = Request.form("ID")

</DIV>>varAction = Request.form("Action")

</DIV>>

</DIV>>response.write "<b>Application value:</b>&nbsp;" & varApplication &

</DIV>>"<br>"

</DIV>>response.write "<b>Originator value:</b>&nbsp;" & varOriginator & "<br>"

</DIV>>response.write "<b>Problem value:</b>&nbsp;" & varProblem & "<br>"

</DIV>>response.write "<b>Title value:</b>&nbsp;" & varTitle & "<br>"

</DIV>>response.write "<b>People ID value:</b>&nbsp;" & varPeopleID & "<br>"

</DIV>>response.write "<b>Tracking Number value:</b>&nbsp;" & varID & "<br>"

</DIV>>response.write "<b>Action value:</b>&nbsp;" & varAction & "<br>"

</DIV>>response.write Request.Form

</DIV>>set oRSapp = Server.CreateObject("ADODB.Recordset")

</DIV>>

</DIV>>adCmdText = 1

</DIV>>strInsert = ("UPDATE app_change SET ID = varID, Application 

</DIV>>varApplication, Originator = varOriginator,

</DIV>>Title = varTitle, Problem = varProblem, PeopleID = varPeopleID, Action 

</DIV>>

</DIV>>varAction WHERE ID=" & varID &

</DIV>>"")

</DIV>>

</DIV>>sqlString = strInsert

</DIV>>'Create the command object

</DIV>>set objConn=Server.CreateObject("ADODB.Connection")

</DIV>>objConn.Open "DSN=application"

</DIV>>

</DIV>>set objCmd = Server.CreateObject("ADODB.Command")

</DIV>>set objCmd.ActiveConnection = objConn

</DIV>>objCmd.CommandText = sqlString

</DIV>>objCmd.CommandType = adCmdText

</DIV>>

</DIV>>'Display the insert string

</DIV>>Response.Write sqlString

</DIV>>

</DIV>>objCmd.Execute

</DIV>>

</DIV>>'Close and dereference database objects

</DIV>>oRSapp.Close

</DIV>>   Set oRSapp = Nothing

</DIV>>   Set objCmd = Nothing

</DIV>>objConn.Close

</DIV>>   Set objConn = Nothing

</DIV>>************************************************************************

</DIV>>**************

</DIV>>

</DIV>>Here is app_update.asp

</DIV>>************************************************************************

</DIV>>**************

</DIV>><form ACTION=app_update_insert.asp method=post>

</DIV>>

</DIV>>   <table>

</DIV>>   <tr>

</DIV>>   <td><b>Application:</b></td>

</DIV>>   <td><input type=text name=Application

</DIV>>value="<%=oRSsearch("Application")%>"&gt; 

<DIV></DIV>&gt; </TD><BR>

<DIV></DIV>&gt; </TR>

<DIV></DIV>&gt; <TR>

<DIV></DIV>&gt; <TD><B>Originator:</B></TD> 

<DIV></DIV>&gt; <TD><INPUT name=Originator DIV
<>&gt;value="<%=oRSsearch("Originator")%>"&gt; 

<DIV></DIV>&gt; </TD>

<DIV></DIV>&gt; </TR>

<DIV></DIV>&gt; <TR>

<DIV></DIV>&gt; <TD><B>Request Date:</B></TD> 

<DIV></DIV>&gt; <TD><INPUT name=REQUEST_ON size=10 DIV
<>&gt;VALUE="<%=oRSsearch("Request_on")%>"&gt;<BR></TD>

<DIV></DIV>&gt; </TR>

<DIV></DIV>&gt; <TR>

<DIV></DIV>&gt; <TD><B>Title:</B></TD> 

<DIV></DIV>&gt; <TD><INPUT name=Title size=40 DIV
<>&gt;value="<%=oRSsearch("Title")%>"&gt;</TD> 

<DIV></DIV>&gt; </TR>

<DIV></DIV>&gt; <TR>

<DIV></DIV>&gt; <TD><B>Tracking Number:</B></TD> 

<DIV></DIV>&gt; <TD><INPUT name=ID size=2 DIV
<>&gt;value="<%=oRSsearch("ID")%>"&gt;</TD> 

<DIV></DIV>&gt; </TR>

<DIV></DIV>&gt; <TR>

<DIV></DIV>&gt; <TD><B>Problem:</B></TD> 

<DIV></DIV>&gt; <TD><TEXTAREA cols=50 name=PROBLEM rows=3 DIV
<>&gt;WRAP=PHYSICAL&gt;&lt;%=oRSsearch("Problem")%&gt; </TEXTAREA></TD> 

<DIV></DIV>&gt; </TR>

<DIV></DIV>&gt; <TR>

<DIV></DIV>&gt; <TD><B>EnterID#:</B></TD> 

<DIV></DIV>&gt; <TD><INPUT name=PeopleID size=2 DIV
<>&gt;value="<%=oRSsearch("PeopleID")%>"&gt;&nbsp;&nbsp;<FONT color=red>If 

<DIV></DIV>&gt;you forgot your ID please<A
href="http://pv1fd.pav1.hotmail.msn.com/cgi-bin/dasp/EN/ID.asp">CLICK HERE</FONT></A></TD> 

<DIV></DIV>&gt; 

<DIV></DIV>&gt; </TR>

<DIV></DIV>&gt; </TABLE>

<DIV></DIV>&gt; 

<CENTER><INPUT type=submit value=Update>&nbsp;<INPUT type=reset value=Reset DIV <>&gt;value="Clear
Form" &gt;</CENTER>

<DIV></DIV>&gt; 

<DIV></DIV>&gt; </FORM>

<DIV></DIV>&gt;************************************************************************ 

<DIV></DIV>&gt;************** 

<DIV></DIV>&gt; 

<DIV></DIV>&gt;_________________________________________________________________ 

<DIV></DIV>&gt;Join the world's largest e-mail service with MSN Hotmail. 

<DIV></DIV>&gt;http://www.hotmail.com 

<DIV></DIV>&gt; 

<DIV></DIV>&gt; 

<DIV></DIV>&gt;--- 

<DIV></DIV>&gt;

<DIV></DIV>&gt;

<DIV></DIV>&gt;$subst('Email.Unsub'). 

<DIV></DIV>&gt; 

<DIV></DIV>&gt;--- 

<DIV></DIV>&gt;

<DIV></DIV>&gt;

<DIV></DIV>&gt;$subst('Email.Unsub'). 

<DIV></DIV>&gt; 

<DIV></DIV>&gt;--- 

<DIV></DIV>&gt;

<DIV></DIV>&gt;

<DIV></DIV></div><br clear=all><hr>Join the world?s largest e-mail service with MSN Hotmail. <a
href='http://go.msn.com/bql/hmtag4_etl_EN.asp'>Click Here</a><br></html>

Message #5 by "Ken Schaefer" <ken@a...> on Wed, 19 Dec 2001 13:37:17 +1100

www.adopenstatic.com/faq/80040e10.asp



If you're still having problems I suggest you Response.Write(strSQL) and

post the SQL strings to the list.



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: "Jonathan Marshall" <jdmarsh2g@h...>

Subject: [asp_web_howto] Error





: Totally stumped on this error

:

:

: Error Type:

: Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)

: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 7.

: /app_update_insert.asp, line 243



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Message #6 by "Jonathan Marshall" <jdmarsh2g@h...> on Wed, 19 Dec 2001 15:10:16 +0000

<html><div style='background-color:'><DIV>

<P>I use a javascript popup to display the SQL string on the screen and it looks fine with the values but there is something
I'm missing. Yes I have been to your site and checked out that error. I checked all those situations and that wasn't the problem
with my syntax. Inside my update statement I didn't separate the variables with ampersands. Either of the statements still give me
an syntax error instead of 10 at the end there is the # 14.</P>

<P>strInsert = "UPDATE app_change SET "Application = " &amp; varApplication &amp; ",Originator" &amp;
varOriginator &amp; ",Title= " &amp; varTitle &amp; ",Problem" &amp; varProblem &amp; ",PeopleID= " &amp;
varPeopleID &amp; ",Action = " &amp; varAction &amp; "Where ID = '" &amp; varID &amp; "'"&nbsp;</P>

<P>**********************************************************************</P>

<P>strInsert = "UPDATE app_change SET "<BR>strInsert = strInsert &amp; "Application = " &amp;
varApplication<BR>strInsert = strInsert &amp; ", Originator = " &amp; varOriginator<BR>strInsert = strInsert
&amp; ", Title = " &amp; varTitle<BR>strInsert = strInsert &amp; ", Problem = " &amp;
varProblem<BR>strInsert = strInsert &amp; ", PeopleID = " &amp; varPeopleID<BR>strInsert = strInsert &amp;
", Action = " &amp; varAction<BR>strInsert = strInsert &amp; " WHERE ID=" &amp; varID
<BR><BR><BR></P></DIV>

<DIV></DIV>

<DIV></DIV>&gt;From: "Ken Schaefer" <KEN@A...>

<DIV></DIV>&gt;Reply-To: "ASP Web HowTo" <ASP_WEB_HOWTO@P...>

<DIV></DIV>&gt;To: "ASP Web HowTo" <ASP_WEB_HOWTO@P...>

<DIV></DIV>&gt;Subject: [asp_web_howto] Re: Error 

<DIV></DIV>&gt;Date: Wed, 19 Dec 2001 13:37:17 +1100 

<DIV></DIV>&gt; 

<DIV></DIV>&gt;www.adopenstatic.com/faq/80040e10.asp 

<DIV></DIV>&gt; 

<DIV></DIV>&gt;If you're still having problems I suggest you Response.Write(strSQL) and 

<DIV></DIV>&gt;post the SQL strings to the list. 

<DIV></DIV>&gt; 

<DIV></DIV>&gt;Cheers 

<DIV></DIV>&gt;Ken 

<DIV></DIV>&gt; 

<DIV></DIV>&gt;~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 

<DIV></DIV>&gt;From: "Jonathan Marshall" <JDMARSH2G@H...>

<DIV></DIV>&gt;Subject: [asp_web_howto] Error 

<DIV></DIV>&gt; 

<DIV></DIV>&gt; 

<DIV></DIV>&gt;: Totally stumped on this error 

<DIV></DIV>&gt;: 

<DIV></DIV>&gt;: 

<DIV></DIV>&gt;: Error Type: 

<DIV></DIV>&gt;: Microsoft OLE DB Provider for ODBC Drivers (0x80040E10) 

<DIV></DIV>&gt;: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 7. 

<DIV></DIV>&gt;: /app_update_insert.asp, line 243 

<DIV></DIV>&gt; 

<DIV></DIV>&gt;~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 

<DIV></DIV>&gt; 

<DIV></DIV>&gt; 

<DIV></DIV>&gt;--- 

<DIV></DIV>&gt;

<DIV></DIV>&gt;

<DIV></DIV></div><br clear=all><hr>Join the world?s largest e-mail service with MSN Hotmail. <a
href='http://go.msn.com/bql/hmtag4_etl_EN.asp'>Click Here</a><br></html>

Message #7 by Nick Charlesworth <nick@f...> on Wed, 19 Dec 2001 15:18:15 -0000

This message is in MIME format. Since your mail reader does not understand

this format, some or all of this message may not be legible.



------_=_NextPart_001_01C188A0.643CD41C

Content-Type: text/plain;

	charset="iso-8859-1"



Double quotes are in the wrong place, also single quotes missing from around

the values you pass.

 

UPDATE app_change SET Application = '" & varApplication & "', Originator 

'" & varOriginator & "', etc....



-----Original Message-----

From: Jonathan Marshall [mailto:jdmarsh2g@h...]

Sent: 19 December 2001 15:10

To: ASP Web HowTo

Subject: [asp_web_howto] Re: Error







I use a javascript popup to display the SQL string on the screen and it

looks fine with the values but there is something I'm missing. Yes I have

been to your site and checked out that error. I checked all those situations

and that wasn't the problem with my syntax. Inside my update statement I

didn't separate the variables with ampersands. Either of the statements

still give me an syntax error instead of 10 at the end there is the # 14.



strInsert = "UPDATE app_change SET "Application = " & varApplication &

",Originator" & varOriginator & ",Title= " & varTitle & ",Problem" &

varProblem & ",PeopleID= " & varPeopleID & ",Action = " & varAction & "Where

ID = '" & varID & "'" 



**********************************************************************



strInsert = "UPDATE app_change SET "

strInsert = strInsert & "Application = " & varApplication

strInsert = strInsert & ", Originator = " & varOriginator

strInsert = strInsert & ", Title = " & varTitle

strInsert = strInsert & ", Problem = " & varProblem

strInsert = strInsert & ", PeopleID = " & varPeopleID

strInsert = strInsert & ", Action = " & varAction

strInsert = strInsert & " WHERE ID=" & varID 









>From: "Ken Schaefer" 

>Reply-To: "ASP Web HowTo" 

>To: "ASP Web HowTo" 

>Subject: [asp_web_howto] Re: Error 

>Date: Wed, 19 Dec 2001 13:37:17 +1100 

> 

>www.adopenstatic.com/faq/80040e10.asp 

> 

>If you're still having problems I suggest you Response.Write(strSQL) and 

>post the SQL strings to the list. 

> 

>Cheers 

>Ken 

> 

>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 

>From: "Jonathan Marshall" 

>Subject: [asp_web_howto] Error 

> 

> 

>: Totally stumped on this error 

>: 

>: 

>: Error Type: 

>: Microsoft OLE DB Provider for ODBC Drivers (0x80040E10) 

>: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 7.



>: /app_update_insert.asp, line 243 

> 

>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 

> 

> 

>--- 



$subst('Email.Unsub'). 



  _____  



Join the world's largest e-mail service with MSN Hotmail. Click Here

<http://go.msn.com/bql/hmtag4_etl_EN.asp> 




$subst('Email.Unsub').

Message #8 by "Drew, Ron" <RDrew@B...> on Thu, 20 Dec 2001 13:54:50 -0500

This is a multi-part message in MIME format.



------_=_NextPart_001_01C18987.CD89E9A7

Content-Type: text/plain;

	charset="us-ascii"

Content-Transfer-Encoding: quoted-printable



Sorry, I actually forgot to add the single quotes for the character

fields...



strInsert =3D "UPDATE app_change SET  "

strInsert =3D strInsert & " Application =3D '" & varApplication & "'"

strInsert =3D strInsert & ", Originator =3D '" & varOriginator & "'"

strInsert =3D strInsert & ", Title =3D '" & varTitle & "'"

strInsert =3D strInsert & ", Problem =3D '" & varProblem & "'"

strInsert =3D strInsert & ", PeopleID =3D " & varPeopleID

strInsert =3D strInsert & ", Action =3D '" & varAction & "'"

strInsert =3D strInsert & " WHERE ID=3D" & varID





-----Original Message-----

From: Jonathan Marshall [mailto:jdmarsh2g@h...]

Sent: Wednesday, December 19, 2001 10:10 AM

To: ASP Web HowTo

Subject: [asp_web_howto] Re: Error







I use a javascript popup to display the SQL string on the screen and it

looks fine with the values but there is something I'm missing. Yes I

have been to your site and checked out that error. I checked all those

situations and that wasn't the problem with my syntax. Inside my update

statement I didn't separate the variables with ampersands. Either of the

statements still give me an syntax error instead of 10 at the end there

is the # 14.



strInsert =3D "UPDATE app_change SET "Application =3D " & varApplication 

&

",Originator" & varOriginator & ",Title=3D " & varTitle & ",Problem" &

varProblem & ",PeopleID=3D " & varPeopleID & ",Action =3D " & varAction 

&

"Where ID =3D '" & varID & "'"



**********************************************************************



strInsert =3D "UPDATE app_change SET "

strInsert =3D strInsert & "Application =3D " & varApplication

strInsert =3D strInsert & ", Originator =3D " & varOriginator

strInsert =3D strInsert & ", Title =3D " & varTitle

strInsert =3D strInsert & ", Problem =3D " & varProblem

strInsert =3D strInsert & ", PeopleID =3D " & varPeopleID

strInsert =3D strInsert & ", Action =3D " & varAction

strInsert =3D strInsert & " WHERE ID=3D" & varID









>From: "Ken Schaefer"

>Reply-To: "ASP Web HowTo"

>To: "ASP Web HowTo"

>Subject: [asp_web_howto] Re: Error

>Date: Wed, 19 Dec 2001 13:37:17 +1100

>

>www.adopenstatic.com/faq/80040e10.asp

>

>If you're still having problems I suggest you Response.Write(strSQL)

and

>post the SQL strings to the list.

>

>Cheers

>Ken

>

>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

>From: "Jonathan Marshall"

>Subject: [asp_web_howto] Error

>

>

>: Totally stumped on this error

>:

>:

>: Error Type:

>: Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)

>: [Microsoft][ODBC Microsoft Access Driver] Too few parameters.

Expected 7.

>: /app_update_insert.asp, line 243

>

>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

>

>




$subst('Email.Unsub').



  _____ 



Join the world's largest e-mail service with MSN Hotmail. Click Here

<http://go.msn.com/bql/hmtag4_etl_EN.asp>




$subst('Email.Unsub').

Message #9 by "Jonathan Marshall" <jdmarsh2g@h...> on Thu, 20 Dec 2001 21:54:36 +0000

<html><div style='background-color:'><DIV></DIV>

<P>thanks ron appreciated but now im getting this error after that one. </P>

<P>Microsoft OLE DB Provider for ODBC Drivers error '80040e14' </P>

<P>[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '\'Utilities, Submit\''.
</P>

<P>/app_update_insert.asp, line 258 <BR><BR>Frustrated now. I can display data search for data
now&nbsp;updating the database has me stumped. I have checked all values and variables. Not sure what im doing
wrong!!!</P>

<P>&nbsp;</P>

<DIV></DIV>

<DIV></DIV>

<DIV></DIV>&gt;From: "Drew, Ron" <RDREW@B...>

<DIV></DIV>&gt;Reply-To: "ASP Web HowTo" <ASP_WEB_HOWTO@P...>

<DIV></DIV>&gt;To: "ASP Web HowTo" <ASP_WEB_HOWTO@P...>

<DIV></DIV>&gt;Subject: [asp_web_howto] Re: Error 

<DIV></DIV>&gt;Date: Thu, 20 Dec 2001 13:54:50 -0500 

<DIV></DIV>&gt; 

<DIV></DIV>&gt;Sorry, I actually forgot to add the single quotes for the character 

<DIV></DIV>&gt;fields... 

<DIV></DIV>&gt; 

<DIV></DIV>&gt;strInsert = "UPDATE app_change SET " 

<DIV></DIV>&gt;strInsert = strInsert &amp; " Application = '" &amp; varApplication &amp; "'" 

<DIV></DIV>&gt;strInsert = strInsert &amp; ", Originator = '" &amp; varOriginator &amp; "'" 

<DIV></DIV>&gt;strInsert = strInsert &amp; ", Title = '" &amp; varTitle &amp; "'" 

<DIV></DIV>&gt;strInsert = strInsert &amp; ", Problem = '" &amp; varProblem &amp; "'" 

<DIV></DIV>&gt;strInsert = strInsert &amp; ", PeopleID = " &amp; varPeopleID 

<DIV></DIV>&gt;strInsert = strInsert &amp; ", Action = '" &amp; varAction &amp; "'" 

<DIV></DIV>&gt;strInsert = strInsert &amp; " WHERE ID=" &amp; varID 

<DIV></DIV>&gt; 

<DIV></DIV>&gt; 

<DIV></DIV>&gt;-----Original Message----- 

<DIV></DIV>&gt;From: Jonathan Marshall [mailto:jdmarsh2g@h...] 

<DIV></DIV>&gt;Sent: Wednesday, December 19, 2001 10:10 AM 

<DIV></DIV>&gt;To: ASP Web HowTo 

<DIV></DIV>&gt;Subject: [asp_web_howto] Re: Error 

<DIV></DIV>&gt; 

<DIV></DIV>&gt; 

<DIV></DIV>&gt; 

<DIV></DIV>&gt;I use a javascript popup to display the SQL string on the screen and it 

<DIV></DIV>&gt;looks fine with the values but there is something I'm missing. Yes I 

<DIV></DIV>&gt;have been to your site and checked out that error. I checked all those 

<DIV></DIV>&gt;situations and that wasn't the problem with my syntax. Inside my update 

<DIV></DIV>&gt;statement I didn't separate the variables with ampersands. Either of the 

<DIV></DIV>&gt;statements still give me an syntax error instead of 10 at the end there 

<DIV></DIV>&gt;is the # 14. 

<DIV></DIV>&gt; 

<DIV></DIV>&gt;strInsert = "UPDATE app_change SET "Application = " &amp; varApplication &amp; 

<DIV></DIV>&gt;",Originator" &amp; varOriginator &amp; ",Title= " &amp; varTitle &amp; ",Problem"
&amp; 

<DIV></DIV>&gt;varProblem &amp; ",PeopleID= " &amp; varPeopleID &amp; ",Action = " &amp; varAction
&amp; 

<DIV></DIV>&gt;"Where ID = '" &amp; varID &amp; "'" 

<DIV></DIV>&gt; 

<DIV></DIV>&gt;********************************************************************** 

<DIV></DIV>&gt; 

<DIV></DIV>&gt;strInsert = "UPDATE app_change SET " 

<DIV></DIV>&gt;strInsert = strInsert &amp; "Application = " &amp; varApplication 

<DIV></DIV>&gt;strInsert = strInsert &amp; ", Originator = " &amp; varOriginator 

<DIV></DIV>&gt;strInsert = strInsert &amp; ", Title = " &amp; varTitle 

<DIV></DIV>&gt;strInsert = strInsert &amp; ", Problem = " &amp; varProblem 

<DIV></DIV>&gt;strInsert = strInsert &amp; ", PeopleID = " &amp; varPeopleID 

<DIV></DIV>&gt;strInsert = strInsert &amp; ", Action = " &amp; varAction 

<DIV></DIV>&gt;strInsert = strInsert &amp; " WHERE ID=" &amp; varID 

<DIV></DIV>&gt; 

<DIV></DIV>&gt; 

<DIV></DIV>&gt; 

<DIV></DIV>&gt; 

<DIV></DIV>&gt; &gt;From: "Ken Schaefer" 

<DIV></DIV>&gt; &gt;Reply-To: "ASP Web HowTo" 

<DIV></DIV>&gt; &gt;To: "ASP Web HowTo" 

<DIV></DIV>&gt; &gt;Subject: [asp_web_howto] Re: Error 

<DIV></DIV>&gt; &gt;Date: Wed, 19 Dec 2001 13:37:17 +1100 

<DIV></DIV>&gt; &gt; 

<DIV></DIV>&gt; &gt;www.adopenstatic.com/faq/80040e10.asp 

<DIV></DIV>&gt; &gt; 

<DIV></DIV>&gt; &gt;If you're still having problems I suggest you Response.Write(strSQL) 

<DIV></DIV>&gt;and 

<DIV></DIV>&gt; &gt;post the SQL strings to the list. 

<DIV></DIV>&gt; &gt; 

<DIV></DIV>&gt; &gt;Cheers 

<DIV></DIV>&gt; &gt;Ken 

<DIV></DIV>&gt; &gt; 

<DIV></DIV>&gt; &gt;~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 

<DIV></DIV>&gt; &gt;From: "Jonathan Marshall" 

<DIV></DIV>&gt; &gt;Subject: [asp_web_howto] Error 

<DIV></DIV>&gt; &gt; 

<DIV></DIV>&gt; &gt; 

<DIV></DIV>&gt; &gt;: Totally stumped on this error 

<DIV></DIV>&gt; &gt;: 

<DIV></DIV>&gt; &gt;: 

<DIV></DIV>&gt; &gt;: Error Type: 

<DIV></DIV>&gt; &gt;: Microsoft OLE DB Provider for ODBC Drivers (0x80040E10) 

<DIV></DIV>&gt; &gt;: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. 

<DIV></DIV>&gt;Expected 7. 

<DIV></DIV>&gt; &gt;: /app_update_insert.asp, line 243 

<DIV></DIV>&gt; &gt; 

<DIV></DIV>&gt; &gt;~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 

<DIV></DIV>&gt; &gt; 

<DIV></DIV>&gt; &gt; 

<DIV></DIV>&gt; &gt;--- 

<DIV></DIV>&gt; &gt;

<DIV></DIV>&gt; &gt;

<DIV></DIV>&gt;$subst('Email.Unsub'). 

<DIV></DIV>&gt; 

<DIV></DIV>&gt; _____ 

<DIV></DIV>&gt; 

<DIV></DIV>&gt;Join the world's largest e-mail service with MSN Hotmail. Click Here 

<DIV></DIV>&gt; 

<DIV></DIV>&gt;--- 

<DIV></DIV>&gt;

<DIV></DIV>&gt;

<DIV></DIV>&gt;$subst('Email.Unsub'). 

<DIV></DIV>&gt; 

<DIV></DIV>&gt; 

<DIV></DIV>&gt; 

<DIV></DIV>&gt;--- 

<DIV></DIV>&gt;

<DIV></DIV>&gt;

<DIV></DIV></div><br clear=all><hr>Get your FREE download of MSN Explorer at <a
href='http://go.msn.com/bql/hmtag_etl_EN.asp'>http://explorer.msn.com</a>.<br></html>

Message #10 by "Drew, Ron" <RDrew@B...> on Thu, 20 Dec 2001 17:15:33 -0500

This is a multi-part message in MIME format.



------_=_NextPart_001_01C189A3.D77A6715

Content-Type: text/plain;

	charset="us-ascii"

Content-Transfer-Encoding: quoted-printable



In your script put a Response.Write(strInsert) after you build the

strInsert and comment out the execution of the update so the results

will display and not the error, then post the results of the

response.write with a copy/paste



Normally this relates to a quote missing, comma missing, equal sign

missing, forgetting to put a space between words or a space/quote

embedded in your variable.

The Response.Write will show the script with the variables included so

you can make it easier to debug.



----Original Message-----

From: Jonathan Marshall [mailto:jdmarsh2g@h...]

Sent: Thursday, December 20, 2001 4:55 PM

To: ASP Web HowTo

Subject: [asp_web_howto] Re: Error







thanks ron appreciated but now im getting this error after that one.



Microsoft OLE DB Provider for ODBC Drivers error '80040e14'



[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing

operator) in query expression '\'Utilities, Submit\''.



/app_update_insert.asp, line 258



Frustrated now. I can display data search for data now updating the

database has me stumped. I have checked all values and variables. Not

sure what im doing wrong!!!







>From: "Drew, Ron"

>Reply-To: "ASP Web HowTo"

>To: "ASP Web HowTo"

>Subject: [asp_web_howto] Re: Error

>Date: Thu, 20 Dec 2001 13:54:50 -0500

>

>Sorry, I actually forgot to add the single quotes for the character

>fields...

>

>strInsert =3D "UPDATE app_change SET "

>strInsert =3D strInsert & " Application =3D '" & varApplication & "'"

>strInsert =3D strInsert & ", Originator =3D '" & varOriginator & "'"

>strInsert =3D strInsert & ", Title =3D '" & varTitle & "'"

>strInsert =3D strInsert & ", Problem =3D '" & varProblem & "'"

>strInsert =3D strInsert & ", PeopleID =3D " & varPeopleID

>strInsert =3D strInsert & ", Action =3D '" & varAction & "'"

>strInsert =3D strInsert & " WHERE ID=3D" & varID

>

>

>-----Original Message-----

>From: Jonathan Marshall [mailto:jdmarsh2g@h...]

>Sent: Wednesday, December 19, 2001 10:10 AM

>To: ASP Web HowTo

>Subject: [asp_web_howto] Re: Error

>

>

>

>I use a javascript popup to display the SQL string on the screen and it



>looks fine with the values but there is something I'm missing. Yes I

>have been to your site and checked out that error. I checked all those

>situations and that wasn't the problem with my syntax. Inside my update



>statement I didn't separate the variables with ampersands. Either of

the

>statements still give me an syntax error instead of 10 at the end there



>is the # 14.

>

>strInsert =3D "UPDATE app_change SET "Application =3D " & 

varApplication &

>",Originator" & varOriginator & ",Title=3D " & varTitle & ",Problem" &

>varProblem & ",PeopleID=3D " & varPeopleID & ",Action =3D " & varAction 

&

>"Where ID =3D '" & varID & "'"

>

>**********************************************************************

>

>strInsert =3D "UPDATE app_change SET "

>strInsert =3D strInsert & "Application =3D " & varApplication

>strInsert =3D strInsert & ", Originator =3D " & varOriginator

>strInsert =3D strInsert & ", Title =3D " & varTitle

>strInsert =3D strInsert & ", Problem =3D " & varProblem

>strInsert =3D strInsert & ", PeopleID =3D " & varPeopleID

>strInsert =3D strInsert & ", Action =3D " & varAction

>strInsert =3D strInsert & " WHERE ID=3D" & varID

>

>

>

>

> >From: "Ken Schaefer"

> >Reply-To: "ASP Web HowTo"

> >To: "ASP Web HowTo"

> >Subject: [asp_web_howto] Re: Error

> >Date: Wed, 19 Dec 2001 13:37:17 +1100

> >

> >www.adopenstatic.com/faq/80040e10.asp

> >

> >If you're still having problems I suggest you Response.Write(strSQL)

>and

> >post the SQL strings to the list.

> >

> >Cheers

> >Ken

> >

> >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

> >From: "Jonathan Marshall"

> >Subject: [asp_web_howto] Error

> >

> >

> >: Totally stumped on this error

> >:

> >:

> >: Error Type:

> >: Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)

> >: [Microsoft][ODBC Microsoft Access Driver] Too few parameters.

>Expected 7.

> >: /app_update_insert.asp, line 243

> >

> >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

> >

> >




>$subst('Email.Unsub').

>

> _____

>

>Join the world's largest e-mail service with MSN Hotmail. Click Here

>




>$subst('Email.Unsub').

>

>

>




$subst('Email.Unsub').



  _____ 



Get your FREE download of MSN Explorer at http://explorer.msn.com

<http://go.msn.com/bql/hmtag_etl_EN.asp> .




$subst('Email.Unsub').

Return to Index

P2P Archives