p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

asp_databases thread: Re: Error 0x80040E07 reply


Message #1 by "lalit tamta" <lmtamta@h...> on Wed, 05 Dec 2001 04:47:23 +0000





>From: "Tsikina Vassiliki" <tsivas@o...>

>Reply-To: "ASP Databases" <asp_databases@p...>

>To: "ASP Databases" <asp_databases@p...>

>Subject: [asp_databases] Error  0x80040E07

>Date: Tue, 4 Dec 2001 23:54:11 +0200

>

>Hi all,

>     I'm trying to do an insert to an existing table but I am getting this 

>error that says I have a data type mismatch. Can anyone help with this? 

>What am I doing wrong?

>I'm using Access 2000.

>

>Here's the code:

>

><%

>    if RSCourseInProgress.EOF then

>      set RSCourseInProgress = conn.execute ("INSERT INTO StudentCourses 

>(StudentID, CourseID, " &  _

>       " Status, StatusDate) VALUES (" & Session("StudentID") & ", " & _

>      Request.QueryString("CourseID") & ", 'InProgress', '" & Date & "') ")

>    end if

>    Response.Redirect "student_menudistant.asp"

>%>

>

>Here's the error:

>     Microsoft JET Database Engine (0x80040E07)

>    Data type mismatch in criteria expression.

>    /OnLineCampus/enrolldrop.asp, line 18

>

>

>P.S.  line 18 is the line that shows the Insert command

>

>

>

>Thanx!

>

>soslution



>conn.execute ("INSERT INTO StudentCourses (StudentID, CourseID, " &  _

>       " Status, StatusDate) VALUES ('" & Session("StudentID") & "', '" & _

>      Request.QueryString("CourseID") & "', 'InProgress', '" & Date & "') 

>")

RSCourseInProgress.open"select * from StudentCourses" ,conn,3,3,1



>




>$subst('Email.Unsub')

>





_________________________________________________________________

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




  Return to Index