diff options
author | Sashi20 | 2019-09-24 18:17:30 +0530 |
---|---|---|
committer | Sashi20 | 2019-09-24 18:17:30 +0530 |
commit | 432d12d3e01e376d4fee9ba7ff6a0da3b72d3bb8 (patch) | |
tree | a015f175806d708f619a7f26c36a5e203a42ff41 | |
parent | e64c735a9177a66923ca748a0ae7373eedf5de1d (diff) | |
download | DWSIM_lab_migration-432d12d3e01e376d4fee9ba7ff6a0da3b72d3bb8.tar.gz DWSIM_lab_migration-432d12d3e01e376d4fee9ba7ff6a0da3b72d3bb8.tar.bz2 DWSIM_lab_migration-432d12d3e01e376d4fee9ba7ff6a0da3b72d3bb8.zip |
Modify query to download solution file
-rwxr-xr-x | download.inc | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/download.inc b/download.inc index e15819c..cb5783c 100755 --- a/download.inc +++ b/download.inc @@ -5,7 +5,7 @@ function lab_migration_download_solution_file() $solution_file_id = arg(3); $root_path = lab_migration_path(); // $solution_files_q = db_query("SELECT * FROM {lab_migration_solution_files} WHERE id = %d LIMIT 1", $solution_file_id); - $solution_files_q = db_query("SELECT lmsf.*, lmp.directory_name FROM lab_migration_solution_files lmsf JOIN lab_migration_solution lms JOIN lab_migration_experiment lme JOIN lab_migration_proposal lmp WHERE lms.id = lmsf.solution_id AND lme.id = lms.experiment_id AND lmp.id = lme.proposal_id AND lmsf.solution_id = :solution_id LIMIT 1", array(':solution_id' => $solution_file_id)); + $solution_files_q = db_query("SELECT lmsf.*, lmp.directory_name FROM lab_migration_solution_files lmsf JOIN lab_migration_solution lms JOIN lab_migration_experiment lme JOIN lab_migration_proposal lmp WHERE lms.id = lmsf.solution_id AND lme.id = lms.experiment_id AND lmp.id = lme.proposal_id AND lmsf.id = :solution_id LIMIT 1", array(':solution_id' => $solution_file_id)); /*$query = db_select('lab_migration_solution_files'); $query->fields('lab_migration_solution_files'); $query->condition('id', $solution_file_id); |