I'm having problem with this chunk of code I've written. Looks ok to me but it doesnt work the way I want it. Here the code is
Set rsMBR_CODE = Server.CreateObject("ADODB.Recordset")
rsMBR_CODE.Open "Select * From members Where MBR_CODE='" & Replace(sMBR_CODE,"'","''") & "'", cnn, 2, 3
If rsMBR_CODE.EOF Then
rsMBR_CODE("MBR_CODE") = sMBR_CODE
Response.Redirect "URL to another page"
the field type is Number. everytime I try to add a new member code it appears as a Zero. Help me please.