Lines Matching refs:sSQL
201 …my $sSQL = "INSERT INTO documents (dbdistinct2, name, pagecount, priority, parentdistinct) VALUES";
202 $sSQL .= "('" . $dbdistinct . "', '" . $sSourceFilename . "', 0, 1, '". $sParentDistinct . "')";
205 push(@aEntries, $sSQL);
264 …my $sSQL = "UPDATE documentcompare SET documentpoolpath='$documentpoolpath' WHERE dbdistinct2='$db…
265 print "$sSQL\n";
266 ExecSQL($sSQL);
271 …my $sSQL = "UPDATE documentcompare SET state='failed',info='documentpoolpath not found.' WHERE dbd…
272 print "$sSQL\n";
273 ExecSQL($sSQL);
297 my $sSQL = "DELETE FROM documents WHERE dbdistinct2='$dbdistinct'";
298 print "$sSQL\n";
299 ExecSQL($sSQL);
307 foreach $sSQL (@aEntries)
310 print "$sSQL\n";
311 ExecSQL($sSQL);
314 my $sSQL = "UPDATE documentcompare SET state='inprogress' WHERE dbdistinct2='$dbdistinct'";
315 print "$sSQL\n";
316 ExecSQL($sSQL);
324 my $sSQL = "UPDATE documentcompare SET state='cancelled' WHERE dbdistinct2='$dbdistinct'";
325 ExecSQL($sSQL);
425 …my $sSQL = "SELECT documentpoolpath,documentpool,dbdistinct2,sourceversion,destinationversion,mail…
426 @aResult = ExecSQL($sSQL);