Skip to main content
Known Participant
April 29, 2008
Question

query query

  • April 29, 2008
  • 3 replies
  • 399 views
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
    This topic has been closed for replies.

    3 replies

    Inspiring
    April 29, 2008
    Better yet, why not learn to select from more than one table in a single query.
    Participating Frequently
    April 29, 2008
    vendore_id? How about vendor_id (without the e) instead?

    Phil
    Known Participant
    April 29, 2008
    thanks.it was about vendor with e.sorry
    Inspiring
    April 29, 2008
    masoud_amen wrote:
    > Invalid column name 'vendore_id'.
    >
    > what is wrong with my query?


    Apparently your database table 'tbl_vendor' does not have a column named
    'vendore_id'.

    Could that possibly supposed to be 'vendor_id'?