My queries aren't working. Can't figure it out.
SELECT
items.itemID,
items.designerID,
designers.designerID,
designers.designerName,
FROM
items,
designers
WHERE
items.designerID=designers.designerID
<cfoutput query="">
-- #designerID# --
</cfoutput>
It should return the designer name. Instead I get "-- d --"
When I substituted designers with another table "itemTypes" I got an "-- I
--"
I've looked at this for over an hour and can't make head or tails with it.
Check to make certain I was accessing the correct database (changed data)
it's linked to the correct db. !?!
I'm going nuts here.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287553
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
