Changeset 21872 for main

Timestamp:

2010-04-12T17:45:35+12:00 (14 years ago)

Author:

davidb

Message:

sqlite3 can take an sql statement as an extra parameter. Better to do this than use echo and pipe it through, as more cross-platform independent.

File:

• main/trunk/greenstone2/perllib/dbutil/sqlite.pm (modified) (1 diff)

main/trunk/greenstone2/perllib/dbutil/sqlite.pm

@@ -81 +81 @@
   my $sqlite3_exe = &util::filename_cat($ENV{'GSDLHOME'},"bin",$ENV{'GSDLOS'}, "sqlite3" . &util::get_os_exe());
   my $infodb_handle = undef;
-  my $cmd = "echo \"$sqlcmd\" | \"$sqlite3_exe\" \"$infodb_file_path\"";
+  my $cmd = "\"$sqlite3_exe\" \"$infodb_file_path\" \"$sqlcmd\"";
 
   if (!-e "$sqlite3_exe" || !open($infodb_handle, "$cmd |"))