sql=SELECT PictureCount , RTRIM(Address)+' '+NormCity+', '+PostalCode as 'LeftHeader' , '$'+RTRIM(LTRIM(convert(char(20),CAST(ListPrice AS money),1))) as 'ReightHeader' FROM v_PropMain_CityArea WHERE ListingID='788476' AND DB='REIL' AND Desig='1' Error in AllPhotos.asp: Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.