PDA

View Full Version : simple syntax question

gcapp
10-08-2002, 03:10 PM
If I have this code:

'-- Display the fields
Response.Write(" <tr>" & Chr(13))
Response.Write(" <td>" & RecordSet.Fields("BusinessID") & "</td>" & Chr(13))
Response.Write(" <td>" & RecordSet.Fields("Image_ID") & "</td>" & Chr(13))
Response.Write(" <td>" & RecordSet.Fields("Category") & "</td>" & Chr(13))
Response.Write(" <td>" & RecordSet.Fields("Business") & "</td>" & Chr(13))
Response.Write(" <td>" & RecordSet.Fields("Address") & "</td>" & Chr(13))
Response.Write(" <td>" & RecordSet.Fields("City") & "</td>" & Chr(13))
Response.Write(" <td>" & RecordSet.Fields("State") & "</td>" & Chr(13))
Response.Write(" <td>" & RecordSet.Fields("Zip") & "</td>" & Chr(13))
Response.Write(" <td>" & RecordSet.Fields("Phone") & "</td>" & Chr(13))
Response.Write(" <td>" & RecordSet.Fields("Phone2") & "</td>" & Chr(13))
Response.Write(" <td>" & RecordSet.Fields("Fax") & "</td>" & Chr(13))
Response.Write(" <td>" & RecordSet.Fields("Website") & "</td>" & Chr(13))
Response.Write(" <td>" & RecordSet.Fields("Email") & "</td>" & Chr(13))
Response.Write(" <td>" & RecordSet.Fields("Information") & "</td>" & Chr(13))


and want all these records to display on my page in an Arial font, in size 2, what is the code i can use to do this??

Thanks,
Gary
Roy Sinclair
10-08-2002, 03:43 PM
Response.Write(" <tr style=""font-family: Arial; font-size:x-small;"">" & vbCR


Note that vbCR is a built in constant, there's also vbCRLF, vbLF and vbNull you can use.
gcapp
10-08-2002, 03:53 PM
Roy,
So I would assume that the code would go like this???

Response.Write(" <tr style=""font-family: Arial; font-size:x-small;"">" & vbCR & Chr(13))
Response.Write(" <td>" & RecordSet.Fields("BusinessID") & "</td>" & Chr(13))
Response.Write(" <td>" & RecordSet.Fields("Image_ID") & "</td>" & Chr(13))
Response.Write(" <td>" & RecordSet.Fields("Category") & "</td>" & Chr(13))
Response.Write(" <td>" & RecordSet.Fields("Business") & "</td>" & Chr(13))
Response.Write(" <td>" & RecordSet.Fields("Address") & "</td>" & Chr(13))
Response.Write(" <td>" & RecordSet.Fields("City") & "</td>" & Chr(13))
Response.Write(" <td>" & RecordSet.Fields("State") & "</td>" & Chr(13))
Response.Write(" <td>" & RecordSet.Fields("Zip") & "</td>" & Chr(13))
Response.Write(" <td>" & RecordSet.Fields("Phone") & "</td>" & Chr(13))
Response.Write(" <td>" & RecordSet.Fields("Phone2") & "</td>" & Chr(13))
Response.Write(" <td>" & RecordSet.Fields("Fax") & "</td>" & Chr(13))
Response.Write(" <td>" & RecordSet.Fields("Website") & "</td>" & Chr(13))
Response.Write(" <td>" & RecordSet.Fields("Email") & "</td>" & Chr(13))
Response.Write(" <td>" & RecordSet.Fields("Information") & "</td>" & "</style>" & Chr(13))
gcapp
10-08-2002, 04:01 PM
Roy,
I think my code is wrong somehow because it views the same as before.

Help!


Gary
Roy Sinclair
10-08-2002, 06:57 PM
No, it should look like this:


Response.Write(" <tr style=""font-family: Arial; font-size:x-small;"">" & vbCR)
Response.Write(" <td>" & RecordSet.Fields("BusinessID") & "</td>" & vbCR)
Response.Write(" <td>" & RecordSet.Fields("Image_ID") & "</td>" & vbCR)
Response.Write(" <td>" & RecordSet.Fields("Category") & "</td>" & vbCR)
Response.Write(" <td>" & RecordSet.Fields("Business") & "</td>" & vbCR)
Response.Write(" <td>" & RecordSet.Fields("Address") & "</td>" & vbCR)
Response.Write(" <td>" & RecordSet.Fields("City") & "</td>" & vbCR)
Response.Write(" <td>" & RecordSet.Fields("State") & "</td>" & vbCR)
Response.Write(" <td>" & RecordSet.Fields("Zip") & "</td>" & vbCR)
Response.Write(" <td>" & RecordSet.Fields("Phone") & "</td>" & vbCR)
Response.Write(" <td>" & RecordSet.Fields("Phone2") & "</td>" & vbCR)
Response.Write(" <td>" & RecordSet.Fields("Fax") & "</td>" & vbCR)
Response.Write(" <td>" & RecordSet.Fields("Website") & "</td>" & vbCR)
Response.Write(" <td>" & RecordSet.Fields("Email") & "</td>" & vbCR)
Response.Write(" <td>" & RecordSet.Fields("Information") & "</td>" & vbCR)
Response.Write(" </tr>" & vbCR)


vbCR is the same as Chr(13) but is cleaner looking and more self documenting and since the "style" is a property of the <tr> you don't need or want a </style> tag. However, a "</tr>" tag is a good thing to have.