Heres the code im using
<cfquery name="qgetcustomer" datasource="#request.dsn#">
SELECT invoice.*, customer.CUSTOMER_Name
FROM invoice left join customer
on invoice.CUSTOMER_AccNum = customer.CUSTOMER_AccNum;
</cfquery>
</select>
</td>
<td>Invoice Number : <input type="text" name="INVOICE_Number" size="12"></td>
<td>Customer Number : <input type="text" name="CUSTOMER_AccNum" size="12"></td>
<td>Customer Name : <input type="text" name="CUSTOMER_Name" size="12"></td>
<td><input type="submit" name="Findinvoices" value="Find »" /></td>
</tr>
</form>
</table>
<cfif isdefined("form.COMPANY_Number")>
<cfif form.COMPANY_Number eq "">
<p>Your Search has returned 0 results</p>
<cfelse>
<cfquery name="qgetinvoices" datasource="#request.dsn#">
select I.INVOICE_DateAdded, I.COMPANY_Number, I.INVOICE_Number, C.COMPANY_Name,
I.INVOICE_Key, I.CUSTOMER_AccNum, CU.CUSTOMER_Name
from INVOICE I, COMPANY C, CUSTOMER CU
where I.COMPANY_Number = C.COMPANY_Number
AND I.COMPANY_Number = '#form.COMPANY_Number#'
AND I.INVOICE_Number LIKE '%#form.INVOICE_Number#%'
AND I.CUSTOMER_AccNum LIKE '%#form.CUSTOMER_AccNum#%'
AND CU.CUSTOMER_Name LIKE '%#form.CUSTOMER_Name#%'
AND I.INVOICE_PDFFile <> ''
</cfquery>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328953
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
