Syntax Error

Discussion in 'ASP General' started by colleen1980@gmail.com, Mar 23, 2007.

  1. Guest

    Hi: Can any one please tell me how to i fix that problem on line:
    objFile.WriteLine PostURL("http://ssdi.rootsweb.com/cgi-
    bin/ssdi.cgi", "ssn1=" & social)
    Thanks.
    Error Type:
    Microsoft VBScript runtime (0x800A000D)
    Type mismatch: 'PostURL'
    /deceased.asp, line 17

    Browser Type:
    Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR
    2.0.50727)
    ---------------------------------------
    Const ForAppend = 8
    Dim objFSO: Set objFSO=CreateObject("Scripting.FileSystemObject")
    Dim DBConn,rs,social,vpath,vfile,xLine
    Dim WShell
    Set WShell = CreateObject("wscript.shell")
    vPath = WShell.SpecialFolders("MyDocuments") & "\"
    vFile = vPath & "Deceased-Information-"
    vFile = vFile & year(now) & month(now) & day(now) & "-"
    vFile = vFile & hour(now) & minute(now) & second(now) & ".txt"
    Set DBConn = CreateObject("ADODB.Connection")
    DBConn.Open "Provider=MSDASQL.1;Persist Security Info=False;Data
    Source=dec1"
    sSQL = "select name1,ssn1 from dbtr where status_code=450"
    Set rs = DBConn.Execute(sSQL)
    Set objFile = objFSO.OpenTextFile(vfile, ForAppend, True)
    Do While Not rs.EOF
    objFile.WriteLine PostURL("http://ssdi.rootsweb.com/cgi-
    bin/ssdi.cgi", "ssn1=" & social)
    response.write(rs.Fields("ssn1"))
    response.write("<br>")
    rs.moveNext
    loop
     
    , Mar 23, 2007
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Balaji
    Replies:
    3
    Views:
    10,202
  2. gabriele renzi
    Replies:
    2
    Views:
    244
    gabriele renzi
    Dec 31, 2005
  3. Ken Bloom
    Replies:
    3
    Views:
    249
  4. Good Night Moon
    Replies:
    9
    Views:
    323
    Rick DeNatale
    Jul 25, 2007
  5. Mark Richards
    Replies:
    3
    Views:
    349
    Tad McClellan
    Nov 18, 2007
Loading...

Share This Page