Wrox Home  
Search P2P Archive for: Go

  Return to Index  

sql_language thread: INSERT INTO...SELECT not working


Message #1 by jprentice@e... on Wed, 21 Jun 2000 14:30:34
I get a 'data type mismatch in criteria expression' error with the 
following code, which is located in an asp page.

strSQL = "INSERT INTO tblJobs SELECT '" & (request.form("ID")+1) & "' AS 
ID, '" & request.form("frmTitle") & "' AS JobTitle, '" & 
request.form("frmSummary") & "' AS Summary, '" & 
request.form("frmResponsibilities") & "' AS Responsibilties, '" & 
request.form("frmRequirements") & "' AS Requirements, '" & 
request.form("frmAccountability") & "' AS Accountability, '" & 
request.form("chkInternal") & "'AS Internal, '" & 
request.form("txtInternal") & "' AS InternalDate, '" & 
request.form("chkExternal") & "' AS External, '" & 
request.form("txtExternal") & "' AS ExternalDate"
	
Note:  The code shows up here using word-wrap; it's not how it's written.

I think the error is coming from the checkboxes.  Either that or the ID.

Any ideas?

  Return to Index