jr->JobStatus = (int)*row[9];
jr->Type = (int)*row[10];
jr->Level = (int)*row[11];
- jr->ClientId = str_to_uint64(row[12]);
+ jr->ClientId = str_to_uint64(row[12]!=NULL?row[12]:(char *)"");
sql_free_result(mdb);
db_unlock(mdb);
db_lock(mdb);
Mmsg(&mdb->cmd,
- "SELECT VolumeName,JobMedia.VolIndex FROM JobMedia,Media WHERE "
- "JobMedia.JobId=%u AND JobMedia.MediaId=Media.MediaId "
- "ORDER BY JobMedia.VolIndex", JobId);
+ "SELECT DISTINCT VolumeName FROM JobMedia,Media WHERE "
+ "JobMedia.JobId=%u AND JobMedia.MediaId=Media.MediaId",
+ JobId);
Dmsg1(130, "VolNam=%s\n", mdb->cmd);
*VolumeNames[0] = 0;