SOLVED RE: braindead duh!! moment with db
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 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 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) 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 -- #itemID# -- #designerID# 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
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 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 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) 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 -- #itemID# -- #designerID# 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
Re: braindead duh!! moment with db
OKthat's better ;-) You are still selecting designerID from items and designers tablesjust select it from one table and not both (or as I said before...alias one or both of them). I can only guess (if the query is actually running) that it is getting confused between those 2 columns with the same name and you're getting some unexpected weirdness. What if you use CFDUMP to dump the querydo you see the correct data then? HTH Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287557 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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) 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 -- #itemID# -- #designerID# 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! :-) -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Friday, August 31, 2007 5:54 PM To: CF-Talk Subject: Re: braindead duh!! moment with db You are selecting 2 columns from different tables named "designer_id".you should alias one of them. I'm suprised the query even executes like thatit shouldn't! You haven't put the query name in the CFOUTPUT tag eitherthat might help ;-) None of what you posted should even runso I can only assume it's psuedo code?? Cheers PS...outputting the designerID as you code states would NOT show the designer nameuse the designerNAme field for that ;-) Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287556 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: braindead duh!! moment with db
You are selecting 2 columns from different tables named "designer_id".you should alias one of them. I'm suprised the query even executes like thatit shouldn't! You haven't put the query name in the CFOUTPUT tag eitherthat might help ;-) None of what you posted should even runso I can only assume it's psuedo code?? Cheers PS...outputting the designerID as you code states would NOT show the designer nameuse the designerNAme field for that ;-) Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287555 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
braindead duh!! moment with db
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 -- #designerID# -- 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