Re^5: Using variables in a DBI do queriy

You showed me 4 insert queries that I assumed were ran sequentially one after another. If that's the case, than the code I provided would programmatically build the same queries, but run then in a single insert statement. Someone might want to do this if they were concerned about the number of database accesses and if there was an index on the table that was updated every time an insert was performed.

If those insert statements you showed me are not actually run immediately, one after another as shown, than my sample code is meaningless.

Either way mate, I believe I've helped you as much as I can.

Comment on Re^5: Using variables in a DBI do queriy

Replies are listed 'Best First'.
Re^6: Using variables in a DBI do queriy by vendion (Scribe) on May 05, 2011 at 18:14 UTC
Sorry if I was a bit unclear about my problem this script has to be able to parse through multilevel files, each query represents a different file within a directory. Over all there are three directories I have to read from, one has three files (handled by the code in my other post), one has two files, and the last directory has one file. The way I am doing it now with different queries works I was just wondering if there was a more maintainable way to do it. Anyways thanks for the help.	[reply]

Replies are listed 'Best First'.

Re^6: Using variables in a DBI do queriy
by vendion (Scribe) on May 05, 2011 at 18:14 UTC

Sorry if I was a bit unclear about my problem this script has to be able to parse through multilevel files, each query represents a different file within a directory. Over all there are three directories I have to read from, one has three files (handled by the code in my other post), one has two files, and the last directory has one file. The way I am doing it now with different queries works I was just wondering if there was a more maintainable way to do it.

Anyways thanks for the help.

[reply]