After giving up all hope, I did something I should have done a lot earlier. I put my code on another server ... and it worked!!!
Apparently my host was having some problems. Wasted a few hours, lost some more hair but aside from that all is good. Thanks for all those who answered and help bring back some sanity. Gil -----Original Message----- From: Bruce, Rodney S Mr CTR USA AMC [mailto:[EMAIL PROTECTED] Sent: Friday, August 31, 2007 6:26 PM To: CF-Talk Subject: RE: braindead duh!! moment with db 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! :-) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287669 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
