PCMech Forums - View Single Post - More ASP and Access problems. Please help ASAP

artsapimp · 12-22-2000, 11:07 AM

That is it. Thank you very much.

I do have another problem though. This is an error I'm getting when trying to just open Updates from a different table. Here is what I've got so far. thanks for any help.

Code:

strUpdateSQL = "SELECT Follow_up.TicketNumber, Follow_up.Update, Follow_up.Update_Date, Follow_up.Update_Time, NDCRep.NDCRep_First_Name, NDCRep.NDCRep_Last_Name"
strUpdateSQL = strUpdateSQL & " FROM NDCRep RIGHT JOIN Follow_up ON NDCRep.NDCRepID = Follow_up.NDCRep"
strUpdateSQL = strUpdateSQL & " WHERE Follow_up.TicketNumber = " & Request.QueryString("TicketNumber")

The error I'm getting is this...

Code:

 
Microsoft JET Database Engine error '80040e07' 

Data type mismatch in criteria expression. 

/tickets1/ticket.asp, line 141

I thought it was because the table was called update which is some "special" word so I changed it to "follow_up" and that didn't fix it either. Any help would be great.

thanks again for the previous help.

12-22-2000, 11:07 AM	#6
artsapimp Member (10 bit) Join Date: May 1999 Location: Orlando, FL Posts: 975	That is it. Thank you very much. I do have another problem though. This is an error I'm getting when trying to just open Updates from a different table. Here is what I've got so far. thanks for any help. Code: strUpdateSQL = "SELECT Follow_up.TicketNumber, Follow_up.Update, Follow_up.Update_Date, Follow_up.Update_Time, NDCRep.NDCRep_First_Name, NDCRep.NDCRep_Last_Name" strUpdateSQL = strUpdateSQL & " FROM NDCRep RIGHT JOIN Follow_up ON NDCRep.NDCRepID = Follow_up.NDCRep" strUpdateSQL = strUpdateSQL & " WHERE Follow_up.TicketNumber = " & Request.QueryString("TicketNumber") The error I'm getting is this... Code: Microsoft JET Database Engine error '80040e07' Data type mismatch in criteria expression. /tickets1/ticket.asp, line 141 I thought it was because the table was called update which is some "special" word so I changed it to "follow_up" and that didn't fix it either. Any help would be great. thanks again for the previous help.