Thanks everyone. It will be nice when Godaddy finally starts to support ms sql 2008, as I believe that version supports the date datatype?
James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. jhar...@hanoverpa.com 717-637-8931 fax: 717-637-6766 cell: 717-887-2565 -----Original Message----- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Stephen Russell Sent: Tuesday, December 28, 2010 4:21 PM To: ProFox Email List Subject: Re: select on ms sql 2005 data on web server On Tue, Dec 28, 2010 at 2:28 PM, James E Harvey <jhar...@hanoverpa.com> wrote: > I can connect and pull all the records using: > > SQLEXEC(m.lih,"SELECT * FROM hsf_webct") > > > But when I try the where clause it fails: > > SQLEXEC(m.lih,"SELECT * FROM hsf_webct where TTOD(DTE_OWN) = > {^2010/12/28}") > > > > dte_own is a datetime MS SQL2005 datatype --------------- In 2005 you have to go between time frames of the DATE you want. This should find all. SQLEXEC(m.lih,"SELECT * FROM hsf_webct where DTE_OWN between '2010/12/28' and '2010/12-29' ) -- Stephen Russell Sr. Production Systems Programmer CIMSgts 901.246-0159 cell [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/011601cba700$dff19060$9fd4b1...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.