Close. 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.
