font format issue

Discussion in 'ASP' started by jazzlall, Apr 17, 2007.

  1. jazzlall

    jazzlall New Member

    Joined:
    Oct 18, 2006
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    0
    I returning information from a database that check the database for item that are below a certain level (it's a stock inventory), and then returns the result of that. The function itself works fine, however the text is unformatted and i wish to be able to format the text. As a bit of a newbie when it comes to ASP (my friend did the code for me) I was wondering if anyone could help. The code is as follows:

    Code:
    [I]Dim sQuery
    sQuery = "select ItemName from item where CurrentQty < ParLevel"
    oRS.Open sQuery, oConnection
    
    do while not oRS.EOF
    Response.Write("<div align=""center"">" & oRS("ItemName") & " is below par level</font><div>")  
        oRS.MoveNext
    loop
    
    oRS.Close
    Set oRS = Nothing
    %>[/I]
    Thanks in advance.
     
    Last edited by a moderator: Apr 18, 2007
  2. pradeep

    pradeep Team Leader

    Joined:
    Apr 4, 2005
    Messages:
    1,645
    Likes Received:
    87
    Trophy Points:
    0
    Occupation:
    Programmer
    Location:
    Kolkata, India
    Home Page:
    http://blog.pradeep.net.in
    You didn't open the font tag, it should look something like this...

    Code:
    do while not oRS.EOF
    Response.Write("<div align=""center""><font color=""red"">" & oRS("ItemName") & " is below par level</font><div>")  
        oRS.MoveNext
    loop
    
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice