Changeset 16588 for trunk/ippTools/src/pzgetexp.c
- Timestamp:
- Feb 21, 2008, 6:09:46 PM (18 years ago)
- File:
-
- 1 edited
-
trunk/ippTools/src/pzgetexp.c (modified) (2 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/ippTools/src/pzgetexp.c
r16170 r16588 2 2 * pzgetexp.c 3 3 * 4 * Copyright (C) 2006 Joshua Hoblitt4 * Copyright (C) 2006-2008 Joshua Hoblitt 5 5 * 6 6 * This program is free software; you can redistribute it and/or modify it … … 186 186 psFree(newSummitExps); 187 187 188 // add new exps to pzPendingExp -- must be done before the new exps are189 // added to summitExp because of the SQL logic190 {191 char *query =192 "INSERT INTO pzPendingExp"193 " SElECT"194 " incoming.exp_name,"195 " incoming.camera,"196 " incoming.telescope"197 " FROM incoming"198 " LEFT JOIN summitExp"199 " USING(exp_name, camera, telescope)"200 " WHERE"201 " summitExp.exp_name is NULL"202 " AND summitExp.camera is NULL"203 " AND summitExp.telescope is NULL";204 205 if (!p_psDBRunQuery(config->dbh, query)) {206 // rollback207 if (!psDBRollback(config->dbh)) {208 psError(PS_ERR_UNKNOWN, false, "database error");209 }210 psError(PS_ERR_UNKNOWN, false, "database error");211 return false;212 }213 }214 215 188 // add new exps to summitExp 216 189 {
Note:
See TracChangeset
for help on using the changeset viewer.
