Type Mismatch

[mortkc]

I am trying to add (via ASP) a combination of letters and numbers to a "SerialNumber" field in an Access Table, and it returns a Type Mismatch. If I enter only numbers, the code works fine. It is failing on the following lines:

strItemID = CStr(Request("txtSN&quot)
ItemRS("ItemID&quot = strItemID

Any suggestions on what I am doing wrong would be greatly appreciated. Thanks!

 

[100dtl]

Make the type of column Text

 

[mortkc]

My MSAccess field is set to text, but it is still returning an error.

 

[100dtl]

Have you response.write the concatenated string to see how it looks

 

[mortkc]

I just tried, and it looks fine. The number I entered was sf11, and when I do the response.write, it appears the same.

 

[mortkc]

I tried adding it manually to the database and it worked without error. I only get an error when adding with ASP. Thanks.

 

[Tarwn]

Are you sure the error is coming back from Access? Could it be related to the CStr your doing on the previous line?

-T

_{01000111 01101111 01110100 00100000 01000011 01101111 01100110 01100110 01100101 01100101 00111111}
The never-completed website:

http://www.tiernok.com/

 

[onpnt]

I would say the same. Using cStr() on a request seems usless. if you submitted the value to the colection through a form process it will be a string data type already.

_____________________________________________________________________

http://www.onpntwebdesigns.com

 

[mortkc]

The code now reads:

strItemID = Request("txtSN&quot
ItemRS("ItemID&quot = strItemID

I am still getting the type mismatch on the second line.

 

[onpnt]

what exacetly are you doing here
strItemID = Request("txtSN&quot
ItemRS("ItemID&quot = strItemID

does this indicate you've initialized the ItemRS.AddNew method etc...

sense you're giving the value to the RS

_____________________________________________________________________

http://www.onpntwebdesigns.com

 

[mortkc]

for now, I have gotten around this error by removing the two lines. I am going to go about this from a different angle for now, due to a deadline. Thanks for all your help, and I will post a response once I have time to go back and find the error of my ways. Thanks again.

 

[mortkc]

OK, now I have just confused the issue more.... Here is the new error:

You cannot add or change a record because a related record is required in table 'Items'.
/intranet/emarketpe/inc/process_addItems.asp, line 38

This is the code I am using:

strCategory = Request("CategoryID&quot
strName = Request("txtName&quot
strSN = Request("txtSN&quot
strDetails = Request("txtDetails&quot
strPicture = Request("selPix&quot
strEndTime = "11:59PM"
'strLocation = "300 Littleton"
strSeller = Request("txtSeller&quot


' Add items into the Auctions table

strStartBid = trim(Request("txtStartBid&quot)
strEndDate = trim(Request("txtEndDate&quot)
strBidStatus = trim(Request("chkBidStatus&quot)
strBidder="postmaster"
strSQL = "INSERT INTO Auctions(StartBid,Bidder,BidStatus,EndDate)Values(" & strStartBid & "," & "'" & strBidder &"'" & "," & strBidStatus & "," & "#" & strEndDate & "#)"

objConn.Execute strSQL

'Add Items into the Items Table

Set ItemRS = Server.Createobject("adodb.recordset&quot
ItemRS.Open "Items",objConn,3,3

ItemRS.addnew
ItemRS("SerialNumber&quot = strSN
ItemRS("ItemName&quot = strName
ItemRS("ItemDetails&quot = strDetails
ItemRS("CategoryID&quot = strCategory
ItemRS("Picture&quot = strPicture
ItemRS("Seller&quot = strSeller

ItemRS.Update
ItemRS.MoveLast


ItemRS.Close
set ItemRS = nothing