also - there are some articles at http://www.teratech.com
<http://www.teratech.com> on modifying tables - their code snips are so
completely straightforward too.. good little resource to have although
not a vast resource.
jay
Philip Arnold - ASP wrote:
Much easier to create column in SQL statement DUH!!! ( on my part )
<cfquery name="qryJobAgent" datasource="#setting.dsn#">
select *,JobsFound = 0,JobsRespondedTo = 0 from search_job where
jobseeker_id = #client.jobseekerid#
</cfquery>
Depending on your SQL flavor, you might want to do it as;
select *, 0 as JobsFound, 0 as JobsRespondedTo
from search_job
where jobseeker_id = #client.jobseekerid#
Philip Arnold
Technical Director
Certified ColdFusion Developer
ASP Multimedia Limited
Switchboard: +44 (0)20 8680 8099
Fax: +44 (0)20 8686 7911
www.aspmedia.co.uk <http://www.aspmedia.co.uk>
www.aspevents.net <http://www.aspevents.net>
An ISO9001 registered company.
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
*******************************************************************
***
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
