Batch enter images and keywords into image database

[luvfool313]

I'm in the process of creating an image database with search capabilities. Is there a way to batch enter images into the database as well as batch enter key words? Like if I wanted the key words "dog, animal, pet" for images "dog001 - dog050" can I somehow batch enter this information so that I don't have to do it for each image separately? Any input and suggestion would be greatly appreciated!

 

[csteinhilber]

You could do it "after the fact" fairly easily, with something like:

UPDATE myImageTable
   SET keywords = 'dog, animal, pet'
 WHERE imageName LIKE 'dog%'

But to do it when the image is initially inserted would be a bit more complex. You'd probably get a file listing with a CFDIRECTORY, step through it file by file, then create some sort of hairy CFIF statement like:

<CFIF Left(myImageName,3) EQ 'dog'>
   <CFSET myKeywords = &quot;dog, animal, pet&quot;>

      :
<CFIF>

<CFQUERY name=&quot;myInsert&quot; ...>
INSERT INTO myImageTable
   (imageName, kword) VALUES ('#myImageName#','#myKeywords#')
</CFQUERY>

Hope it helps,
-Carl