oh, that wasn't specified. that sql works for me in sqlServer :) sorry ...tony
Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping & reporting www.navtrak.net 410.548.2337 -----Original Message----- From: Joel Blanchette [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 1:48 PM To: CF-Talk Subject: RE: SQL Question (Distinct) Tried that...I get the following error You have an error in your SQL syntax near '* from stats0301 where DomainID = '43' and SameDayDate = '20030128'' at line 1 I am using MySQL ============================== Joel Blanchette IT and System Specialist Point of Impact Technologies Inc. Tel: (204) 989-0013 Email: [EMAIL PROTECTED] ============================== -----Original Message----- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 12:35 PM To: CF-Talk Subject: RE: SQL Question (Distinct) select distinct IpAddress, * from stats0301 where DomainId = '43' and SameDayDate = '20030128' I think.... hth ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping & reporting www.navtrak.net 410.548.2337 -----Original Message----- From: Joel Blanchette [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 1:29 PM To: CF-Talk Subject: SQL Question (Distinct) I am trying to do a query as follows SELECT DISTINCT IPAddress from stats0301 WHERE DomainID = '43' AND SameDayDate = '20030128' Now I need the IPAddress to be DISTINCT but I need to return all the columns. What would I do to accomplish this? Thanks ============================== Joel Blanchette IT and System Specialist Point of Impact Technologies Inc. Tel: (204) 989-0013 Email: [EMAIL PROTECTED] ============================== ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
