Visual Web Developer 2005 Express

Fetch Date based on From Date To Date

anandbe21@gmail.com — Tue, 21 Jul 2009 13:03:29 GMT

I had requirement like user want to fetch data using among dates like From Date and TO date among this dates i need to display number of employees leave details among employees based on Empid. I want Query regarding this requirement here in my database columns having From date only to date is n't available. Is there any hard code for to date.Help me regarding hw i need to approach i want query to genarate my crystal report .

select convert(char(8),fdate,112),convert(char(8),todate,112),count(empNo) from table

where datediff(d,fdate,@Fdate)>=0 and datediff(d,tdate,@Tdate)<=0

group by convert(char(8),fdate,112),convert(char(8),todate,112)

previous had somebody give query for this requirement but tdate is n't there in database how this tdate can do any query regarding this very urgent requirement.

Re: line number in VWD

Thomas Sun – MSFT — Wed, 01 Jul 2009 03:19:06 GMT

Hi,

phddas:

is there a keyboard key to close the Output window? thx

There is not such shortcut keyboard to close the Output window. There is just keyboard key to open the Output window ("Ctrl+W,O" by default).

You can make it auto hide when Output window loses focus (Right click Output window header and select "Auto Hide" or click "Auto Hide" button in the upper right of Output window).

Thanks.

Re: line number in VWD

phddas — Sat, 27 Jun 2009 21:45:07 GMT

is there a keyboard key to close the Output window? thx

Re: line number in VWD

phddas — Sat, 27 Jun 2009 21:14:50 GMT

oh, ok... just put a check mark in the box at the bottom of the window where it says "Show all settings".

thx

Re: line number in VWD

phddas — Sat, 27 Jun 2009 21:13:42 GMT

in VS08

Tools > Options > {General, Fonts and Colors, Format, Validation, CSS, CSS Styling} "no Text Editor". and there is no + sign in the start of each line.

in VWD08

Tools > Options > {Environment, Projects and Solutions, Text Editor, Databse Tools, Debugging, HTML Designer} and there is a + sign in start of each line.

Re: line number in VWD

MetalAsp.Net — Sat, 27 Jun 2009 11:30:49 GMT

What I posted above. I use VS 2008.

Re: line number in VWD

phddas — Sat, 27 Jun 2009 05:12:27 GMT

how can I do the same for VS2008? thx

Re: line number in VWD

MetalAsp.Net — Thu, 25 Jun 2009 22:41:08 GMT

Tools -> Options -> Text Editor. You can enable line numbers globally, or based on the section ou want.

line number in VWD

phddas — Thu, 25 Jun 2009 21:02:14 GMT

Please tell me how to turn line numbers on for web.config and file.js files. the line numbers work for html and css files but not for the other I stated.

thx