RE: braindead duh!! moment with db

[Bruce, Rodney S Mr CTR USA AMC]

Don't know why you are getting the ds or Is.

But a few things I would do are:

Alias one of the designerIDs or remove it from the SELECT.

Scope the vars  #getItems.itemid#----#getItems.designerid#,  something
might be in designerid from another scope.

Do a <CFDUMP> of the query and see what is in the recordset.
See if you have ds in the recordset before you are outputting the data.

If you have ds in the recordset from the <CFDUMP> then I would go back
and run the query in the database and look at what is in the tables.



-----Original Message-----
From: mayo [mailto:[EMAIL PROTECTED] 
Sent: Friday, August 31, 2007 3:10 PM
To: CF-Talk
Subject: RE: braindead duh!! moment with db

Yes, it was abbreviated.

And, yes I'm tired. I should have stated designerID not designerName?

here's a snippet (MUCH IS CUT OUT)

<cfquery name="getItems" datasource="storeSR">
        SELECT
                items.itemID,
                items.categoryID,
                items.itemTypeID,
                items.designerID,
                items.designerItemCode,
                items.itemName,
                items.itemDescShort,
                items.itemPrice,
                designers.designerID,
                designers.designerName,
                designers.designerNameWWW,
                designers.isActive,
                designers.hasDescriptionPage
        FROM
                items,
                designers
        WHERE
                items.designerID=designers.designerID

</cfquery>


        <cfoutput query="getItems">
         -- #itemID#  -- #designerID# <br/>
        </cfoutput>

I ought to get a list of numbers
-- 77 -- 20
-- 78 -- 20
Etc..

Instead I get

-- 77 -- d
-- 77 -- d
-- 78 -- d
-- 78 -- d
-- 78 -- d

If I ran the query width itemTypes (changed the tables and fields) and
put in itemTypeID instead of designerID I get a list with  an i instead
of a d.

Go figure!?

I swear these queries worked before!  :-)

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287558
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4