Querystring Problem

Results 1 to 2 of 2

Thread: Querystring Problem

  1. #1
    Join Date
    Dec 1969

    Default Querystring Problem

    I have a page with this querystring link<BR>&#060;a href="mypage.asp?Records=&#060;%=FP_FieldURL(fp_rs ,"Records")%&#062;"&#062;<BR>When i try to open mypage.asp i get the error.<BR> Data type mismatch in criteria expression.<BR>Here is the code from mypage.asp<BR><BR>If Request.QueryString ("records") &#060;&#062; "" Then<BR>RecordToEdit = Request.QueryString ("records")<BR><BR>Set Recordset = objDC.Execute("SELECT Site1,Fname,Lname,Employeeid,alarmcode,Title,Room, DateDue,DateNeeded,KeyNo,records FROM Keydetails WHERE records= &#039;" & Request.QueryString("records") & "&#039;")<BR>End If<BR><BR>Any ideas why i get the error<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Querystring Problem

    3 things will cause that error. Check them out in the ASPFAQ&#039;s link above under database errors.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts