The between syntax Where myDate between @date1 and @date2 In a stored procedure you could receive one date and add the ending date for the between part of the statement.
Sent from my iPhone Stephen Russell 901.246-0159 On Dec 29, 2010, at 6:09 AM, "James E Harvey" <[email protected]> wrote: > You mean like this: > > mfdate = ThisForm.hscntsqlcon.hstxtfdate.Value > > > mldate = mfdate + 1 > > mcfdate = DTOC(mfdate) > mcldate = DTOC(mldate) > > m.lcxn=("Driver={SQL Server}; Server=<server name>; Database=<database > name>; Uid=<uid>; Pwd=<password>") > m.lih=SQLSTRINGCONNECT(m.lcxn) > > SQLEXEC(m.lih,"SELECT * FROM hsf_webct where DTE_OWN between ?mcfdate and > ?mcldate " ) > > browse > > James E Harvey > Corresponding Officer/M.I.S. > Hanover Shoe Farms, Inc. > [email protected] > 717-637-8931 > fax: 717-637-6766 > cell: 717-887-2565 > > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf > Of Alan Bourke > Sent: Wednesday, December 29, 2010 5:50 AM > To: [email protected] > Subject: Re: select on ms sql 2005 data on web server > > And you're using parameters in the query instead of building a string > directly from user input, right? > > Right. :) > -- > Alan Bourke > alanpbourke (at) fastmail (dot) fm > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] 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/[email protected] ** 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.
