Search results for query: *

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

I find DateDiff a very useful function. Here you would say "where DateDiff(dd, StatDate, getDate()) = 0"

Try this : <form name=&quot;main&quot; action=&quot;post&quot;> <input type=&quot;text&quot; name=&quot;empnum&quot; value=&quot;<%= Request(&quot;empnum&quot;) %>&quot; onBlur=&quot;main.submit();return false;&quot;> [...] The moment you tab out of the empnum input box the form will be...

Hi, everyone. I'm a newbie to the forum but so far am enjoying the dialog. I have a &quot;wouldn't-it-be-cool-if&quot; idea to share: A 3-dimensional version of Query Analyzer that would display a new &quot;plane&quot; for each data set of a multiple join, and show via some sort of color...

For argument's sake: I know it's bad form, and you'll take a minor performance hit, but why not just evaluate Request(&quot;x&quot;), 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.