1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

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,646
    Likes Received:
    86
    Trophy Points:
    0
    Occupation:
    Programmer
    Location:
    Kolkata, India
    Home Page:
    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