As the witching hour approaches and my first deadline draws near,
expect my stress levels to climb and my emails to get less and less
graceful. For now, I feel remarkably composed, although I don't
suppose I'll be getting to bed anytime soon.
Now: this query fetches some data from two tables.
<CFQUERY name="get_tasks" datasource=taskomatic>
SELECT
tasks.taskID,
tasks.taskname,
tasks.status,
tasks.project,
projects.projectsID,
projects.projectname,
projects.client
FROM tasks, projects
WHERE tasks.project=projects.projectsID
</CFQUERY>
Further down I have a table that looks something like this:
<CFOUTPUT query="get_tasks">
#task.taskname# #task.status# #projects.projectname#
#projects.client#
</CFOUTPUT>
The trouble is that the field project.client just returns the primary
key from another table (clients). I'd like it to display the field
clients.clientname.
I appreciate that this an extremely low hurdle to fall at but I've been
frying my brain with this stuff for days and I'm finding it hard to
think straight...
Kind regards,
CK.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
