font format issue

jazzlall's Avatar, Join Date: Oct 2006
Light Poster
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:
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
%>
Thanks in advance.

Last edited by shabbir; 18Apr2007 at 05:52.. Reason: Code block
pradeep's Avatar, Join Date: Apr 2005
Team Leader
You didn't open the font tag, it should look something like this...

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