Re: Re[2]: Server hanging. Wierd problems. HELP!
oop - my bad. sorry MD! Um Christopher, please remember while you are working on that laptop, that you might be logged in as me when you go to House Of Fusion (among other web sites). Secondly, I've heard about this issue before, but have never experienced the the problem. That's not to say that it doesn't exist; just that I have never personally experienced it - even on sites under heavy load. So don't panic. There's no need to test a bunch of cfifs unnecessarily. Now - stop and make yourself another login on that laptop, please... -- Cheers! Michael David Tuesday, September 18, 2007, 2:18:16 PM, you wrote: WOW - I hav enever heard of this. I use CFSWITCH to test strings all the time. Should I back through all my sites and and convert those to a bunch of CFIFs? Messy... CWB ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288725 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SQL Server problem getting records within date range
Hello Janet - thanks for the reply. I should have mentioned that I need to get only the most recent transaction for each user within the given time-frame. That's why I am using max(). Using this aggregate function, I think, requires I use having, no?. Thanks, CWB Use the WHERE not HAVING clause. Try something like SELECT ... FROM ... WHERE dbo.tblSubscribers.SID = dbo.tblUserTransactionLog.SID ANDdbo.tblUserTransactionLog.Processed = convert(datetime, '08/01/2007', 101) AND dbo.tblUserTransactionLog.Processed = convert(datetime, '08/07/2007', 101) GROUP BY dbo.tblSubscribers.SID, dbo.tblSubscribers.Username, ~| 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:285733 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Server problem getting records within date range
Hello again Janet, thank you for your help on this. It suare has had me stumped. So, like this? SELECT dbo.tblSubscribers.SID, dbo.tblSubscribers.Username, max(dbo.tblUserTransactionLog.Processed) AS LastTransaction FROM dbo.tblSubscribers, dbo.tblUserTransactionLog WHERE dbo.tblSubscribers.SID = dbo.tblUserTransactionLog.SID AND (dbo.tblUserTransactionLog.Processed = CONVERT(datetime, '08/01/2007', 101)) AND (dbo.tblUserTransactionLog.Processed = CONVERT(datetime, '08/07/2007', 101)) GROUP BY dbo.tblSubscribers.SID, dbo.tblSubscribers.Username Thanks, CWB I should have mentioned that I need to get only the most recent transaction for each user within the given time-frame. That's why I am using max(). Using this aggregate function, I think, requires I use having, no?. No, if I'm understanding correctly its not required here. The WHERE clause restricts the results to the given time frame and the aggregate + the GROUP BY gives you the max (per user) Janet ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285754 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Server problem getting records within date range
Hello again Janet... I am so sorry to be bugging you again on this, but I am having trouble with this new query - not doubt it's something I just don't understand. If I set the dates in this query to 08/01/2007 and 08/02/2007 I only get results from 08/01/2007. And, if I have them both set to 08/02/2007, I don't get no results at all - but I would expect to set the results from 8/2, which do indeed exist. Note that I am using = and = in the query. What am I missing here? Feeling kinda dumb today :( Yes, that looks correct. ~| 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=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285779 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SQL Server problem getting records within date range
Ah Ha! I figured out the problem with the query. This following seems to work as expected: SELECT dbo.tblSubscribers.SID, dbo.tblSubscribers.Username, max(dbo.tblUserTransactionLog.Processed) AS LastTransaction FROM dbo.tblSubscribers, dbo.tblUserTransactionLog WHERE dbo.tblSubscribers.SID = dbo.tblUserTransactionLog.SID AND (CONVERT(varchar, dbo.tblUserTransactionLog.Processed, 101) = \'08/01/2007\') AND (CONVERT(varchar, dbo.tblUserTransactionLog.Processed, 101) = \'08/01/2007\') GROUP BY dbo.tblSubscribers.SID, dbo.tblSubscribers.Username Thanks to Janet and Josh for their help! Thanks, - cwb ~| 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:285787 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
