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/013c01cba751$344f4170$9cedc4...@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.
