ErrorASP

Results 1 to 2 of 2

Thread: ErrorASP

  1. #1
    Ameur Guest

    Default ErrorASP

    sqlText = Replace(sqlText, ":1", quoted_pf_id)<BR> sqlText = Replace(sqlText, ":2", Request("dept_id"))<BR><BR>I&#039m recieving this error,<BR>Microsoft VBScript runtime error &#039 800a005e&#039 <BR><BR>Invalid use of Null: &#039replace&#039 <BR><BR> can you help please.

  2. #2
    Join Date
    Dec 1969
    Posts
    2,849

    Default RE: ErrorASP

    What are the values in sqlText BEFORE you run the replace function? Also, what are the values of quoted_pf_id and Request("dept_id")? I&#039d bet one of these three things is NULL.<BR><BR>BEFORE your first replace statement, do a:<BR>Response.Write "sqlText = " & sqlText & "&#060;P&#062;quoted_pf_id = " & quoted_pf_id & "&#060;P&#062;Request(""Dept_id"") = " & Request("Dept_id")<BR><BR>and show us the results of that.

Posting Permissions

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