vbscript

Author Message
shuaki

  • Total Posts : 1
  • Scores: 0
  • Reward points : 0
  • Joined: 10/10/2008
  • Status: offline
vbscript Friday, October 10, 2008 1:31 AM (permalink)
0
Hello

I have a problem i have a function to get some data and with that data create a link to a page the problem is im not expert in vb and i dont know how to do it! can someone helpe me

 Set UserRS = Server.CreateObject("ADODB.RecordSet")
 
 'Posterplaats gegevens ophalen'
        Dim p(2), i
        UserRS.Open "SELECT * FROM Posterplaatsen ORDER BY id",  ConnStr
 
        i = 0
 
        If Not (UserRS.BOF Or UserRS.EOF) Then
            UserRS.MoveFirst
            Do While Not UserRS.EOF and i<3
                i = i + 1
                If (UserRS("datum")<Now) Then
                    If Not (IsNull(UserRS("posterplaats"&i)) Or IsNull(UserRS("Image"&i))) Then
                        p(i) = "<a href=""programmaDetail.asp?DataId=" & UserRS("posterplaats"&i) & """ target=""content_frame""><img src=""" & UserRS("Image"&i) & """ style=""border:1px""  /></a>"
                    End If
                End If
                UserRS.MoveNext
            Loop
        End If
 
        UserRS.Close : Set UserRS = Nothing
 


and is call here
    <%
 
                        =p(0)
                        
                    %>
 


Kind regards im waiting for your hel i realy need


Ps: sometimes appear this error

Microsoft VBScript runtime error '800a000d'
Type mismatch

<message edited by shuaki on Friday, October 10, 2008 1:34 AM>
 
#1

    Online Bookmarks Sharing: Share/Bookmark

    Jump to:

    Current active users

    There are 0 members and 1 guests.

    Icon Legend and Permission

    • New Messages
    • No New Messages
    • Hot Topic w/ New Messages
    • Hot Topic w/o New Messages
    • Locked w/ New Messages
    • Locked w/o New Messages
    • Read Message
    • Post New Thread
    • Reply to message
    • Post New Poll
    • Submit Vote
    • Post reward post
    • Delete my own posts
    • Delete my own threads
    • Rate post

    2000-2012 ASPPlayground.NET Forum Version 3.9