directory contend write into database

[micpik]

Hello,

we started with CF after 5 years again. and test the functions. OK the Problem
is, we must load the contend of a Directoryfilenames into the database. It must
work for our picturegallery over 3000 pics.

Our samplecode you can see in the attachment.

After runs the code, we can see with the output tag the files with names on
screen but we dont save automatic in
our database

Please we hopy the group can help us.

Micpik

<cfdirectory directory="\\Sc\dddweltencf_fsc\bildergalery\" action="list"
name="pics" >

<cfloop query="pics">
<cfdirectory directory="\\Sc\dddweltencf_fsc\bildergalery\#pics .name#"
action="list" name="this">
<cfloop query="this">

#pics.name# #this.name#

<cfquery name=pics datasource=bildergallery>
INSERT INTO gallery(pics_name, this_name)
VALUES('#pics.name#', '#this.name#')
</cfquery>

</cfloop>
</cfloop>
Here yo can see the names on sreen
<cfoutput query="pics">#pics.name##this.name# </cfoutput>

[mpwoodward *TMM*]

On 2005-07-08 04:02:49 -0500, "micpik" <webforumsuser@macromedia.com> said:

> <cfloop query="pics">
> <cfdirectory
> directory="\\Sc\dddweltencf_fsc\bildergalery\#pics .name#" action="list"
> name="this">
> <cfloop query="this">
> #pics.name# #this.name#
> <cfquery name=pics datasource=bildergallery>
> INSERT INTO gallery(pics_name, this_name)
> VALUES('#pics.name#', '#this.name#')
> </cfquery>
>
> </cfloop>
> </cfloop>
> Here yo can see the names on sreen
> <cfoutput query="pics">#pics.name##this.name# </cfoutput>

My first guess would be that because your outer loop is over a query
named "pics" and your inner-most cfquery is also named "pics", that's
going to cause a problem. Try renaming your inner query and see if
that helps.

Matt
--
Matt Woodward
[email]mpwoodward@gmail.com[/email]
Team Macromedia - ColdFusion