This was what i meant to put in instead of qgetcustomer query
So am I still missing a join somewhere
<cfif isdefined("url.invoice")>
<cfquery name="qgetcompanyno" datasource="#request.dsn#">
select COMPANY_Number, INVOICE_Number, CUSTOMER_AccNum
from INVOICE
where INVOICE_Key = #url.invoice#
</cfquery>
<cfset form.INVOICE_Number = qgetcompanyno.INVOICE_Number>
<cfset form.COMPANY_Number = qgetcompanyno.COMPANY_Number>
</cfif>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:328955
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
