|
I want to calculate total working days between the two dates specified in ASP or javascript:
e.g.,
date1 = 16/08/2005
date2 = 25/08/2005
there are two holidays in the duration specified above.
Thanx
|
|
|
|
|
anyla,
You may use DateTime.Compare to get the difference but for WorkingDays, you need to have a class which calculates the number of holidays within a date span. This again is dependent on each region and/or enterprise. Is'nt it?
Vasudevan Deepak Kumar
Personal Web: http://www.lavanyadeepak.tk/
I Blog At: http://deepak.blogdrive.com/
|
|
|
|
|
yes we can calculate the difference b/w the dates, but i need a function to calculate number of working days (from the calendar dates).
and the holidays (offdays) are saturday and sunday.
thanx
|
|
|
|
|
Here is a simple, but not very efficient, method:
date1 = #2005-08-16#<br />
date2 = #2005-08-25#<br />
<br />
day = date1<br />
days = 0<br />
While day <= date2<br />
wday = Weekday(day, vbMonday) ' <-- here you use the first day of week<br />
If wday <> vbSaturday and wday <> vbSunday Then<br />
days = days + 1<br />
End Id<br />
day = DateAdd("d", 1, day)<br />
Wend<br />
Response.Write "The number of workdays are: " & days
---
b { font-weight: normal; }
|
|
|
|
|
Looking for a source example of how to communicate with an ip device via a web manager. Want to change settings of the device etc....
Example : Most wireless routers have a webmanager (linked to an ip address.)
that one can change and configure the device settings.
Does anything exists for .NET (Either VB or C# or C++ )
|
|
|
|
|
I need implement creation DIME-envelope in C++. And, conversely, I must restore source attachments from this DIME-envelope. I don't need implement sending or receiving data, only creation/parsing DIME-envelope.
What tools can I use for this? I think that this problem is typical and must be typical solution too. Can you help me, please?
May be Microsoft SOAP Toolkit 3.0 is suitable for this? And I found gSOAP Toolkit http://prdownloads.sourceforge.net/gsoap2, but I think that it
is very complicated and cumbersome for my simple task.
Thanks very mach
|
|
|
|
|
Microsoft SOAP Toolkit 3.0 isn't suitable for such task
|
|
|
|
|
hi,
how can i make the visited page unavailable after leaving the page,even if the user presses the back or forward button in browser?
thanks.
|
|
|
|
|
u can't. the browser that the user uses handles hystory like that. depending on the browser u target u might be able to find a way to trick the browser into thinking it never viewed that page
|
|
|
|
|
For a bit of a cheesy way, you could set display:none on your visited links and make sure the page expires imediatly so it must be reloaded when a user returns to it.
|
|
|
|
|
i have a list of words about 600 word ! i have a user that wana see some of the , for example when he types "m" , he can see the words start with "m" , or if he types "me" , he can see words start with "me" , but i wana do this with TEXTBOX or combobox .anybody know how to do this with VBSCRIPT or JAVASCRIPT??
Have good day and time
|
|
|
|
|
I have created some server controls programatically at runtime and these are fine, but I can't figure out how to access these controls at a later time ( ie after a button clicked:-
this is how I created the code
Label label = new Label();
// Set the label's Text and ID Properties
label.Text = fieldDesc;
label.ID = "label" + rowCount.ToString();
labelPH1.Controls.Add(label);
// Add a spacer in the form of an HTML
element
labelPH1.Controls.Add(new LiteralControl("
"));
TextBox textBoxInput = new TextBox();
// Set the Textbox Text and Id Properties
textBoxInput.Text = fieldDefault;
textBoxInput.ID = "textBoxInput" + rowCount.ToString();
textBoxInput.MaxLength = fieldLength;
textBoxPH1.Controls.Add(textBoxInput);
// Add a spacer in the form of an HTML
element
textBoxPH1.Controls.Add(new LiteralControl("
"));
when all the data has been input in textboxes created the user clicks a button, but whan I try to extract the value from textBoxInput1 I get a compilation error, for example
private void buttonOk_Click(object sender, System.EventArgs e)
{
Response.Write("data " + textBoxInput1.Text);
}
I get the error :- the type or namespace textBoxInput cannot be found.
|
|
|
|
|
Because textBoxInput1 is not a variable! 
this.Request.Form["textBoxInput1"] is one possible way how to get it's value.
Never forget: "Stay kul and happy" (I.A.)
David's thoughts / dnhsoftware.org / MyHTMLTidy
|
|
|
|
|
Hi i have a script im trying to get to work i need to split a date an re-join it back in a different order heres what i have so far, i can get it to split buti need to join it back into one again.
ages = request.querystring("age1")<br />
agesplit = Split(ages, ",")<br />
<br />
Dim agesplit(3)<br />
<br />
one = agesplit(0)<br />
two = agesplit(1)<br />
three = agesplit(2)<br />
<br />
Dim OneDimArray(3)<br />
<br />
OneDimArray(2) = one<br />
OneDimArray(0) = two<br />
OneDimArray(1) = three<br />
<br />
Dim strSentence<br />
strSentence = join(OneDimArray)
cheers
|
|
|
|
|
ages = request.querystring("age1")
agesplit = Split(ages, ",")
Dim agesplit(3)
one = agesplit(0)
two = agesplit(1)
three = agesplit(2)
Dim strSentence
strSentence = two & "/" & three & "/" & one
e.g., 31/12/2005 (dd/mm/yyyy) and u wanna to write it as
12/2005/31 (mm/yyyy/yy)
|
|
|
|
|
Don't dimension agesplit as an array. It's not an array, it's a variant that contains an array.
When you dimension an array in VBScript, you don't give the number of items, but the highest index to use. If you want an array with three items, the highest index will be two.
Dim ages, agesplit, strSentence<br />
Dim OneDimArray(2)<br />
<br />
ages = Request.QueryString("age1")<br />
agesplit = Split(ages, ",")<br />
<br />
one = agesplit(0)<br />
two = agesplit(1)<br />
three = agesplit(2)<br />
<br />
OneDimArray(2) = one<br />
OneDimArray(0) = two<br />
OneDimArray(1) = three<br />
<br />
strSentence = join(OneDimArray, ",")
---
b { font-weight: normal; }
|
|
|
|
|
'Dimension variables<br />
Dim adoCon2 <br />
Dim rsUser2 <br />
Dim strSQL2 <br />
Dim lngRecordNo2 <br />
Dim access<br />
<br />
<br />
<br />
lngRecordNo2 = Request.QueryString("ID")<br />
<br />
<br />
<br />
times = request.querystring("age2")<br />
<br />
<br />
<br />
sDate2 = times<br />
myArray2 = Split(sDate2, "/")<br />
<br />
sNewDate2 = myArray2(1) & "/" & myArray2(0) & "/" & myArray2(2)<br />
<br />
<br />
Dim ages, agesplit, strSentence<br />
Dim OneDimArray(2)<br />
<br />
ages = Request.QueryString("age1")<br />
agesplit = Split(ages, "/")<br />
<br />
one = agesplit(0)<br />
two = agesplit(1)<br />
three = agesplit(2)<br />
<br />
OneDimArray(2) = one<br />
OneDimArray(0) = two<br />
OneDimArray(1) = three<br />
<br />
strSentence = join(OneDimArray, "/") <br />
<br />
'Create an ADO connection odject<br />
Set adoCon2 = Server.CreateObject("ADODB.Connection")<br />
<br />
'Set an active connection to the Connection object using a DSN-less connection<br />
adoCon2.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("database.mdb")<br />
<br />
'Create an ADO recordset object<br />
Set rsUser2 = Server.CreateObject("ADODB.Recordset")<br />
<br />
'Initialise the strSQL variable with an SQL statement to query the database<br />
strSQL2 = "SELECT * FROM student WHERE dob BETWEEN #"&strSentence&"# AND #"&sNewDate2&"# Order By student_id ASC"<br />
<br />
<br />
'Open the recordset with the SQL query <br />
rsUser2.Open strSQL2, adoCon2...
|
|
|
|
|
When working with the database, I would suggest that you format the date according to ISO 8601, e.g. "yyyy-mm-dd". This format is totally unambigous (contrary to almost all other date formats), and the database should have no problems to dechiper it, regardles of what the date format might currently be on the server.
---
b { font-weight: normal; }
|
|
|
|
|
Ive cracked it thanks for the help
heres my final code snipet
<br />
Dim adoCon2 <br />
Dim rsUser2 <br />
Dim strSQL2 <br />
Dim lngRecordNo2 <br />
Dim access<br />
<br />
lngRecordNo2 = Request.QueryString("ID")<br />
<br />
times = request.querystring("age2")<br />
times2 = request.querystring("age1")<br />
<br />
sDate2 = times<br />
myArray2 = Split(sDate2, "/")<br />
<br />
sNewDate2 = myArray2(0) & "/" & myArray2(1) & "/" & myArray2(2)<br />
<br />
sDate = times2<br />
myArray = Split(sDate, "/")<br />
<br />
sNewDate = myArray(0) & "/" & myArray(1) & "/" & myArray(2)<br />
<br />
Set adoCon2 = Server.CreateObject("ADODB.Connection")<br />
<br />
adoCon2.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("database.mdb")<br />
<br />
Set rsUser2 = Server.CreateObject("ADODB.Recordset")<br />
<br />
strSQL2 = "SELECT * FROM student WHERE dob BETWEEN #"&sNewDate&"# AND #"&sNewDate2&"# Order By student_id ASC"<br />
<br />
rsUser2.Open strSQL2, adoCon2<br />
<br />
|
|
|
|
|
Hi,
I'm a newbie trying to write a fairly simple web app in C# with two complex issues - I need to present a document dialog box to the user, let them select a (usually MS Word) document on their local drive(s) and store it in a SQL Server 2000 table/column. I'm wondering if someone has some sample code (preferably C#) and can tell me what type of column needs to be defined in SQL Server to hold the document.
I'll also need the reverse: pulling the document out (mostly Word documents) and displaying it in the browser window.
I'm basically trying to store and retrieve these Word documents from various users in SQL Server 2000.
Any help would REALLY be appreciated! Thank you very much in advance!
Mike L.
|
|
|
|
|
Hi Mike,
+ To display a dialog box which allows the user to select a document on the client machine and upload it to the server, you can use an input file element. You can find the article posted on CP as an example:
http://www.codeproject.com/aspnet/fileupload.asp[^]
+ To store the Word document in SQL, you can define a column of the image type.
+ To insert/retrieve the content of the word document, you can use the ADO.NET[^] to implement the functionality. In addition to the above example, you can check out tons of examples in MSDN[^], CP and the internet.
+ To display the word document in the browser, you can save the content to disk and simply use a link to point to the file. You can also write out the content to the output stream of the Reponse object. Again, the above fileupload article can give you an idea on the issue.
|
|
|
|
|
I've seen a lot of code that demos ISAPI extension apps that works for browser based applications. Now i hope some good people provide some examples and code on how to build the same thing (ISAPI dll) that especially works with non-browser based applications.
b2c
|
|
|
|
|
Balu,
You mean Windows apps right. ISAPI stands for Internet Server API. You can embed a Web Browser or make a call to ISAPI dll from your Windows app via C# WebRequest or a similar trick and read the response back just like web browser. Is'nt it?
Did this attend to your query?
Vasudevan Deepak Kumar
Personal Web: http://www.lavanyadeepak.tk/
I Blog At: http://deepak.blogdrive.com/
|
|
|
|
|
I am trying to pop up a window from a link on a web page using the following code:
<br />
[head]<br />
[script etc etc]<br />
function popup(url)<br />
{<br />
window.open(url,'title','300,300');<br />
}<br />
[/script]<br />
[/head]<br />
<br />
[body]<br />
[a href='javascript:popup('someurl.html')']blahblah[/a]<br />
[/body]<br />
[edit]
The colon between javascript and popup is not showing up on this page but it is in the code
[/edit]
I have only shown the reqd bits so please don't tell me I missed out parts of the page 
Now this works fine except if I use it in an IFrame on IE. On FF etc it works just as I would expect.
Does anybody have a clue if this is a security feature of IE? Or what is wrong?
Thanks
|
|
|
|
|
The problem is that you use the same delimiter for html attributes and javascript strings. The browser thinks that the attribute ends where you think that the string starts. To the browser, it's only this that makes sense of your anchor tag:
[a href='javascript:popup(']blahblah[/a]
This will of course cause an error. If you had error messages enabled in your browser, you would get the error in a popup. Now it only shows up in the status bar.
Use quotes for html attributes and apostrophes for javascript strings:
[a href="javascript:popup('someurl.html');"]blahblah[/a]
---
b { font-weight: normal; }
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
