Forums
This topic is locked
How do I retrieve only those records with an image
Posted 17 Jul 2002 11:43:20
1
has voted
17 Jul 2002 11:43:20 nigel burkinshaw posted:
Hi guys, i need to search my dbases and retrieve only those records that have an image in the image field. Im sure the answer is staring me right in the face but im having one of those mental bloc mornings, cheers nigelReplies
Replied 21 Jul 2002 07:33:23
21 Jul 2002 07:33:23 aegis kleais replied:
Since I have no info on your setup I'll assume that you're needing an SQL Query to create a recordset for records that have an image in the image field.
SELECT * from table_name WHERE fldImage NOT Null
Aegis Kleais
New Media Web Developer
(DWMX : IIS5.1 : SQL2K : WXP : ASP[VB/JS])
SELECT * from table_name WHERE fldImage NOT Null
Aegis Kleais
New Media Web Developer
(DWMX : IIS5.1 : SQL2K : WXP : ASP[VB/JS])