Ian Bicking wrote:
If you use Class.q.employeePhone, that should translate to class.employee_phone in the SQL.
Is that supposed to work in this context?
results = Timesheet._connection.queryAll("""SELECT
Client.q.clientName,
Project.q.projectDesc,
Timesheet.q.travelTime,
Timesheet.q.regularTime,
Timesheet.q.description,
TImesheet.q.internalNote
FROM
Timesheet,
Client,
Project
WHERE
timesheet.client_id = Client.id AND
timesheet.project_id = Project.id AND
date >=
'%s' AND
date <= '%s'
ORDER BY
client.client_name""" % (beginDate, endDate)
)
I'm getting an error saying that Client.q.clientName does not exist. Is
there a better way of doing this? Or did I get something wrong?
