Small problem

Results 1 to 2 of 2

Thread: Small problem

  1. #1
    Join Date
    Dec 1969

    Default Small problem

    Hey can anyone tell what is the problem with the sql below.<BR>i guess its string problem somewhere<BR><BR>Getting type mismatch error<BR><BR> dim catid , catname, rs, rssql<BR> catid = CInt(Request.QueryString("id"))<BR> catname Request.QueryString("cat")<BR> rssql = "Select path from support where id=" & catid & " and productname=&#039" & catname & "&#039"<BR><BR><BR>******************the error*************<BR>Microsoft VBScript runtime error &#039 800a000d&#039 <BR><BR>Type mismatch <BR><BR>/bf/down.asp, line 7 <BR>****************end *********************<BR><BR>

  2. #2
    Jason Miller Guest

    Default RE: Small problem

    Well, you&#039re missing an "=" on "catname request.queryString("cat")", if you cut & pasted that...<BR><BR>Otherwise, I don&#039t see anything in that set of lines which would generate errors. You might want to save the cInt until you get to rsSql (ie: id = " & cInt(catID) & " etc), but other than that, it&#039s not possible for VBScript to generate errors on those lines (if request.queryString("id") is an integer).

Posting Permissions

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