Look at http://www.aspnl.com/aspnl/nl/lessen/aspdb/ASPDBselect.asp

Here you can see the Getrow function is put in an array.

It's not very hard...



Regards,



Bart Beekhuizen





-----Original Message-----

From: Steve Read [mailto:steve@r...]

Sent: Monday, March 19, 2001 4:03 AM

To: ASP Web HowTo

Subject: [asp_web_howto] Recordset in an Array





Hello,



I have two questions on the above topic. 



Firstly, I have an array containing one record. I get an error if any of the

fields contain NULL. I have got around this by doing the following code

before putting the data into a table:



if isnull(ds(0,0)) THEN

ds(0,0) =0

end if



This works fine. But I had to do many times for all the twenty or so fields

in the array. Is there a smarter way of doing this?



Secondly, I would like to make a value RED if the number is negative. This

is my code so far. How do I test for this?



response.write "<TD><B>" & formatcurrency(ds(13,0),2) & "<TD><B>"



Thank you



steve