Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Extract Date from DateTime
Hmm, NoCool, you raise a good point re: performance issues between DateDiff and BETWEEN... Never woulda foreseen that. In fact I would have expected the opposite considering the datatype conversion. Regardless, don't forget that BETWEEN is inclusive and converting a string without a specified...- sense
- Post #6
- Forum: Microsoft SQL Server: Programming
-
Extract Date from DateTime
I find DateDiff a very useful function. Here you would say "where DateDiff(dd, StatDate, getDate()) = 0"- sense
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Passing form variable to JavaScript/ASP function
Try this : <form name="main" action="post"> <input type="text" name="empnum" value="<%= Request("empnum") %>" onBlur="main.submit();return false;"> [...] The moment you tab out of the empnum input box the form will be...- sense
- Post #7
- Forum: Microsoft: ASP (Active Server Pages)
-
3-D Query Analyzer?
Hi, everyone. I'm a newbie to the forum but so far am enjoying the dialog. I have a "wouldn't-it-be-cool-if" idea to share: A 3-dimensional version of Query Analyzer that would display a new "plane" for each data set of a multiple join, and show via some sort of color...- sense
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
GET and POST - Probably Simple
For argument's sake: I know it's bad form, and you'll take a minor performance hit, but why not just evaluate Request("x"), without specifying the method? I believe IIS will look in .querystring first, then .form, (or vice versa, I forget which) until it finds the item.- sense
- Post #9
- Forum: Microsoft: ASP (Active Server Pages)
