Skip to main content
A
Anonymous
July 21, 2006
Question

cfdirectory query insert

  • July 21, 2006
  • 1 reply
  • 235 views
Hi and thanks in advance,

I'm currently using cfdirectory and querying over that and inserting the file names in a table. no problem there. but now that i have those files in the table I want to check those files against cfdirectory for any new files and only insert new ones in the table. This has thrown me for a loop. can anyone give me some suggestions?
    This topic has been closed for replies.

    1 reply

    S
    Sojovi
    Inspiring
    July 22, 2006
    you can use a QoQ with the results of the cfdirectory and cfquery of your table, joining by filename, or filename and folder.
    A
    Anonymous
    July 22, 2006
    thanks for helping.. but how do join by filename?
    A
    Anonymous
    July 24, 2006
    Can anyone give me any more ideas on this? I have never done a query of a file before and it has me a bit confused.
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices