<--- --------------------------------------------------------------------------------------- ----
Blog Entry:
Ask Ben: Streaming Binary Data From The Database (BLOB) To The User Using ColdFusion
Author:
Ben Nadel / Kinky Solutions
Link:
http://www.bennadel.com/index.cfm?dax=blog:1274.view
Date Posted:
Jun 30, 2008 at 8:29 AM
---- --------------------------------------------------------------------------------------- --->
UPDATE
hottie
SET
name =
,
hotness =
WHERE
id =
INSERT INTO hottie
(
name,
hotness
) VALUES (
,
);
SELECT
( LAST_INSERT_ID() ) AS id
;
UPDATE
hottie
SET
photo =
WHERE
id =
SELECT
h.id,
h.name,
h.hotness,
(
CASE
WHEN
h.photo IS NULL
THEN
0
ELSE
1
END
) AS has_photo
FROM
hottie h
WHERE
h.id =
ColdFusion / MySQL Blob Demo
ColdFusion / MySQL Blob Demo