Reading and Inserting filenames 1

[CFMSACCESS]

I have 400 images in a directory. I want to loop through the images and insert their file names into a database.
Please help.

http://www.GracefulWebDevelopment.com

 

[ecobb]

To list/get all of the files in the directory, you can use

<cfdirectory action=&quot;LIST&quot;
directory=&quot;C:\Inetpub\

http://wwwroot\etc...&quot;

name=&quot;get_images&quot;>

Then, just loop through the list and insert the image name into the database

<cfloop query=&quot;get_images&quot;>
<cfquery>
INSERT INTO table(ImageField)
VALUES(#Name#)
</cfquery>
</cfloop>

Hope This Helps!

Ecobb

&quot;Alright Brain, you don't like me, and I don't like you. But lets just do this, and I can get back to killing you with beer.&quot; - Homer Simpson