I'm doing a select from three tables, and my query is timing out. The
problem is probably coming from the fact that there is not always a
record in the m.POS_ARC_HEADX table. Is there a way to restructure this
query so it still checks the m.POS_ARC_HEADX but does not die if no
record exists? Is there another reason this query might be dying?
Thanks!
John
<cfquery name="InvoiceDetail" datasource="triad.udd" dbtype="ODBC">
SELECT m.POS_ARC_HEAD.DocNo, m.POS_ARC_HEAD.CrName,
m.POS_ARC_SKU.SKU,
m.POS_ARC_SKU.Description, m.POS_ARC_HEADX.PersonAuthToCharge
FROM m.POS_ARC_HEAD, m.POS_ARC_HEADX, m.POS_ARC_SKU
WHERE m.POS_ARC_HEAD.DocNo = m.POS_ARC_HEADX.DocNo AND
m.POS_ARC_HEADX.DocNo = m.POS_ARC_SKU.DocNo
AND m.POS_ARC_HEADX.DocNo =
"#URL.RetrieveDoc#"
</cfquery>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
