Question
query query
hi.I have these 2 queries:
<cfquery name="qProducts" datasource="#session.eManager.datasource#">
select * from tbl_product_vendor WHERE (dbo.tbl_product_vendor.product_id = '#url.ProductID#')
</cfquery>
<cfquery name="qvendors" datasource="#session.eManager.datasource#">
select * from tbl_vendor where vendore_id = <cfqueryparam value="#qProducts.vendor_id#">
</cfquery>
bur I get an errer which says:
Invalid column name 'vendore_id'.
what is wrong with my query?
thanks
<cfquery name="qProducts" datasource="#session.eManager.datasource#">
select * from tbl_product_vendor WHERE (dbo.tbl_product_vendor.product_id = '#url.ProductID#')
</cfquery>
<cfquery name="qvendors" datasource="#session.eManager.datasource#">
select * from tbl_vendor where vendore_id = <cfqueryparam value="#qProducts.vendor_id#">
</cfquery>
bur I get an errer which says:
Invalid column name 'vendore_id'.
what is wrong with my query?
thanks
