Hi,
I'm trying to insert an Image into MS SQL Server 2005 database using CF 8.
I started to work with the SQL Server 'Image' data type but I'm not sure
this data type is the best/correct choice.
Somebody has probably done this before, so what data-type should/could I use
in SQL Server - The
I'll assume you're storing images in the DB because you don't have another
option...
Someone else with have to help with the error you're getting because I'm not
familiar with that part. To display the image you'll need CF template takes
the staff ID as a parameter. You'll query the value using
-Original Message-
From: Nathan C. Smith [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 17, 2008 10:00 AM
To: CF-Talk
Subject: insert/retrieve image into database SQL Server 2005/CF8?
Hi,
I'm trying to insert an Image into MS SQL Server 2005 database using CF 8.
I started to work
Hi Dave,
Are you using CF8? what SQL data type is the column you are inserting into
and what does the SQL query look like?
I was hoping to avoid the tired old in-DB v. Out-of-DB conversation. These
are small pictures and fewer than 100 so it shouldn't be a big
-Original Message-
From: Dave Long [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 17, 2008 12:56 PM
To: CF-Talk
Subject: RE: insert/retrieve image into database SQL Server 2005/CF8?
I do it using a unix cron job timed to retrieve, unzip and
rename the files
soon after they're refreshed
There's nothing wrong with storing images in a modern RDBMS.
Except may be people having problems and asking questions in forums ;-)
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to
I was hoping to avoid the tired old in-DB v. Out-of-DB
conversation.
Like the war between good and evil, that conversation is eternal. There's
nothing wrong with storing images in a modern RDBMS.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the
, 2008 1:54 PM
To: CF-Talk
Subject: RE: insert/retrieve image into database SQL Server 2005/CF8?
I was hoping to avoid the tired old in-DB v. Out-of-DB
conversation.
Like the war between good and evil, that conversation is
eternal. There's
nothing wrong with storing images in a modern
You are always a great resource Dave, any thoughts on my
original question?
Unfortunately, I won't have access to a SQL Server 2005 machine until the
weekend.
That said, you should be able to rewrite your original code like this:
cfimage source=/var/www/images/staffpics/#staffID#.jpg
-Talk
Subject: RE: insert/retrieve image into database SQL Server 2005/CF8?
Hi Dave,
Are you using CF8? what SQL data type is the column you are inserting into
and what does the SQL query look like?
I was hoping to avoid the tired old in-DB v. Out-of-DB conversation. These
are small pictures
PROTECTED]
Sent: Thursday, January 17, 2008 1:54 PM
To: CF-Talk
Subject: RE: insert/retrieve image into database SQL Server 2005/CF8?
I was hoping to avoid the tired old in-DB v. Out-of-DB
conversation.
Like the war between good and evil, that conversation is
eternal. There's
nothing wrong
-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 17, 2008 2:32 PM
To: CF-Talk
Subject: RE: insert/retrieve image into database SQL Server 2005/CF8?
You are always a great resource Dave, any thoughts on my
original question?
Unfortunately, I won't have access
12 matches
Mail list logo