Repeater with inline BLOB

Employees Profile

Photo

	1	Name	Ms. Nancy Davolio
Reports To	Andrew Fuller
Title	Sales Representative
Birthdate	12/8/1968 12:00:00 AM
HireDate	5/1/1992 12:00:00 AM
Address	507 - 20th Ave. E. Apt. 2A - Seattle - WA. 98122 USA
Phone	(206) 555-9857 x 5467
Notes	Education includes a BA in psychology from Colorado State University. She also completed "The Art of the Cold Call." Nancy is a member of Toastmasters International.

	2	Name	Dr. Andrew Fuller
Reports To
Title	Vice President, Sales
Birthdate	2/19/1952 12:00:00 AM
HireDate	8/14/1992 12:00:00 AM
Address	908 W. Capital Way - Tacoma - WA. 98401 USA
Phone	(206) 555-9482 x 3457
Notes	Andrew received his BTS commercial and a Ph.D. in international marketing from the University of Dallas. He is fluent in French and Italian and reads German. He joined the company as a sales representative, was promoted to sales manager and was then named vice president of sales. Andrew is a member of the Sales Management Roundtable, the Seattle Chamber of Commerce, and the Pacific Rim Importers Association.

	3	Name	Ms. Janet Leverling
Reports To	Andrew Fuller
Title	Sales Representative
Birthdate	8/30/1963 12:00:00 AM
HireDate	4/1/1992 12:00:00 AM
Address	722 Moss Bay Blvd. - Kirkland - WA. 98033 USA
Phone	(206) 555-3412 x 3355
Notes	Janet has a BS degree in chemistry from Boston College). She has also completed a certificate program in food retailing management. Janet was hired as a sales associate and was promoted to sales representative.

	4	Name	Mrs. Margaret Peacock
Reports To	Andrew Fuller
Title	Sales Representative
Birthdate	9/19/1958 12:00:00 AM
HireDate	5/3/1993 12:00:00 AM
Address	4110 Old Redmond Rd. - Redmond - WA. 98052 USA
Phone	(206) 555-8122 x 5176
Notes	Margaret holds a BA in English literature from Concordia College and an MA from the American Institute of Culinary Arts. She was temporarily assigned to the London office before returning to her permanent post in Seattle.

	5	Name	Mr. Steven Buchanan
Reports To	Andrew Fuller
Title	Sales Manager
Birthdate	3/4/1955 12:00:00 AM
HireDate	10/17/1993 12:00:00 AM
Address	14 Garrett Hill - London - . SW1 8JR UK
Phone	(71) 555-4848 x 3453
Notes	Steven Buchanan graduated from St. Andrews University, Scotland, with a BSC degree. Upon joining the company as a sales representative, he spent 6 months in an orientation program at the Seattle office and then returned to his permanent post in London, where he was promoted to sales manager. Mr. Buchanan has completed the courses "Successful Telemarketing" and "International Sales Management." He is fluent in French.

[1 - 5 : 9]

Data Repeater with BLOB

<script language="VB" runat="server">
Sub Page_Load(Src As Object, E As EventArgs)
'------------- Repeater Template -------------------
Dim fm as string="<TABLE border='0' cellpadding='2' cellspacing='0' width='100%'><TR><TD align=right>"
fm=fm & "<TD class='ch'>!EmployeeID!</TD>"
fm=fm & "<TD align=right class='gh'><B>Name</B></TD>"
fm=fm & "<TD class='ch'>!TitleOfCourtesy! "
fm=fm & "!FirstName! !LastName!</TD></TR>"
fm=fm & "<TR><TD align=right class='fl'><b>"
fm=fm & "Reports To</b></TD><TD COLSPAN=3 class='r2'>"
fm=fm & "!ReportsTo!</TD></TR>"
fm=fm & "<TR><TD align=right class='fl'><B>Title</B></TD>"
fm=fm & "<TD COLSPAN=3 class='r1'>"
fm=fm & "!Title!</TD></TR>"
fm=fm & "<TR><TD align=right class='fl'><b>"
fm=fm & "Birthdate</b></TD>"
fm=fm & "<TD colspan='3' class='r2'>"
fm=fm & "!Birthdate!</TD></TR>"
fm=fm & "<TR><td align=right class='fl'><b>"
fm=fm & "HireDate</b></TD><td colspan='3' class='r1'>"
fm=fm & "!Hiredate!</TD></TR>"
fm=fm & "<TR><TD align=right class='fl'><B>Address</B></TD>"
fm=fm & "<TD COLSPAN=3 class='r2'>!Address! - !City! - !Region!. !PostalCode! !Country!</TD></TR>"
fm=fm & "<TR><TD align=right class='fl'><B>Phone</B></TD>"
fm=fm & "<TD COLSPAN=3 class='r1'>!HomePhone! x !Extension!</TD></TR>"
fm=fm & "<TR><TD align=right class='flf'><B>Notes</B></TD><TD COLSPAN=3>"
fm=fm & "<TEXTAREA COLS=50 ROWS=6>!Notes!</TEXTAREA></TD></TR>"
fm=fm & "</TABLE>"


'---- ASPdb.Net Code ----
  Dim ACC As New Tornado.Z()
  With ACC
    .dbQP="U=9| Q=Employees| D=NewNwind.mdb| M=G| Gdf=0,Photo| Mts=-1| Th=Tit=Repeater with inline BLOB| BM=employees;0"
    .dbSkin = "type=Watch"
    .dbNameMap="field=0|alias=Employees Profile"
    .dbCommonTables="index=EID,FULLNAME|sql=SELECT EmployeeID, FirstName & ' ' & Lastname as Name FROM Employees"
    .dbLookUpFLds="fi=ReportsTo|key=EID|look=FullName"
    .dbGridMagicCell="(;,[]!|~/)field=0|macro=" & fm
    .dbBlob = "fi=Photo|co=image/bmp|la=browser|off=78"
    .ASPdbNet
  End With
End Sub
</script>

We'll add an Inline image BLOB to the repeater by just adding the additional properties in blue. That all it takes, try to view this example using browsers that supports BMP image file format. If the BLOB is a .gif format, then it work for all.

Note: The Photo field contains the image BLOB in BMP format. BLOB offset for BMP file is 78 and 0 for GIF format.