I have an mssql database with a table of timesheets, each recorded with a Week-Ending date. I have an asp3 webpage that checks the table for timesheets for a given month and calculates hours etc (sum where month = 8 etc). However i need to detect if a time sheet is missing for a given month... as sum() just adds up timesheets if there is 1 or 4.
How can i do this? the only way i could think of is determine the week numbers for a given date then pass these to a stored procedure or something which will then only select people with a full set of time sheets. or is there an easier way?
I'm working on asp project, access 2000 at backend.I can write arabic text and arabic numbers in textbox and save them in database.but if i see these records, arabic text and arabic numbers,it is ok,if my computer is arabicenable.
If my computer is not arabic enable then it show arabic number into english numbers. how can i show arabic numbers instead of english numbers if my computer is not arabic enable.i'm working on a project i have to complete it.How can i convert english numbers that are coming from database and convert that numbers in arabic for show.
I have use
<meta http-equiv="Content-Type" content="text/html; charset=windows-1256"> I shall be very thankful to you for this purpose.
I know there is a function that shows: <% = date %>, which gives: 2/17/2006, is there any way to show the day of year? Example: Today is 2/17/06, but the 48th day of the year. Is there any call to get the 48th day?
Currently i'm working on a application and i have no idea how to get the date for it. This is the scenario.
User will key in this code. For example 07W04. This mean is fourth week of 2007. So now i need to find out the date from the given code. I think of since 1 week is 7 days therefore fourth week should be 7 X 4 so the date will be 28. But then that is for the first month. The others i need to think for the 30 and 31.
So is there any solution for this? I think this is not an easy way. So hope some helps from you all or any function for this.
Does anybody know how I can get the week number. The week number we are currently on is 28 and I need to be able to reitrieve this number so that i can manipulate for loops to advance that number to 33 and 38.
I am trying to figure out a way to get the week number of the current week. I know this is relatively easy using the calendar year (starting from January to now). However, I want to do it so I start in October on the first monday of the month, so today's date would be the 10th week.
I'm trying to create a page that displays records from an SQL database for any records that were created in the last week. I'm stuck on syntax.
I know I have to do something with the date field along the lines of SELECT * FROM table WHERE theDate <= "& now() -7 & " ... or something like that, but I don't know how to format now() or date() for anything other than their defaults.
If I would like to get the week number for month, let's say today is July 25, 2005, which is the fourth weeks for July, how can I use base on the date I have and convert to get the week number in ASP.
Can anyone please tell me is there any method to convert the week to the date?? For example If the week is 6 then we can get the date where the date is between '2/1/2004' and '2/7/2004'
I've made up a set of simple tide table files in notepad showing high and low tides. Each file is for 1 week (7 days) from Sunday to Sunday.
At present I change the text file manually every Sunday...Erm, ok, most of the time anyway.
How can I call a different text file on a weekly basis, using ASP, from the directory which the .txt files are all stored in. (The site is an asp driven site)
The existing files are each named by the starting Sunday date.....18_04_04.txt. (UK date format, sorry), but it'd be no effort to number them sequentially if neccesary.
I have a db with the fields Day, Month, Year and Message. How can I select all of the messages for the current week starting with sunday and return the results as a list.
If I know the week number and the year, how can I calc the beginning and ending dates of the week? For background I'm going to do some grouping by week but don't just want to call the weeks Week 25, Week 26, Week 27, etc. And the week number is to be calculated with:
I have an Access database which asp pages use which has a number of fixtures and events which take place on certain days, and I want to select all values from the database which occur over a period of a week.
For example, for this week I'd want to select all items which have dates between Monday 26th November and Sunday 2nd December. Code:
I need know the week nuber of the month. I know the function datepart() but returns the week number of the year a number between (1,53) I need a number between (1,4 o5). There is a function or method that i can use to do it?
I know this is going to be blindingly simple but I've had one of those days where the more I search and try, the further away from finding the solution I am!
What I'm trying to do is really simple, but the last part of it I can't seem to get right... hopefully someone will spot it straight away.
<% fPath = Server.MapPath(".") qDate = DateAdd("d", -7, Now()) Response.write qDate Set objFSO = Server.CreateObject("Scripting.FileSystemObject") Set Folder = objFSO.GetFolder(fPath) For Each i In Folder.Files If i.DateCreated <= qDate Then 'objFSO.DeleteFile(i.Name) Response.Write i.Name & "<br>" End If Next
Set i = nothing Set Folder = nothing %>
As you can see, I've got down to selecting all the week old files no problem, but when I come to execute the 'objFSO.DeleteFile(i.Name)' line - I either get file not found or nothing at all.
I need to build a sort of calendar in ASP (not .NET). I need to display just the fridays or the first days of each week of each months of an year. Any ideas on where or how to start?
In my page i have two combobox. one for year and one for week numbers.Now my prob is
1.when i select a year from combo box 1, second combox box will display the number of weeks in that year.eg if i select 2005 it display me list from 1 to 53 as there are 53 weeks in 2005.
2.when i select a weeknumber from combobox 2 and press submit button it ll display start date and end date of entered week.
I updated to aspx last three month,after developing serveral applications,Idecided to downgraded to asp, following is my reasons: 1.in ASPX,the page format is hard to control,in ASP u can change every html as u like ,but in aspx, a aspx control decide the page format,and its hard to change the format.
2.ASPX is said to be faster that asp, but it is based on too-often communication back to the server,for example,u click a radio a button,there is new page request, but in reality,such a communication is bandwidth-consuming and time-consuming. the user only need to submit the form, and the exchange between IE and Server was minimazed. the Speed of ASPX is not useful for most sites, for bigger sites, the speed increase is singnificant,but for small sites with less traffic, the speed of ASP is quite enough.
3.ASPX is based on Object Orinted Programming, but in most small sites, Procedure orinted programming is used, we never build objects, and POP is more efficient.ASPX is for three-tiered structure with a single layer of business logic component, but in reality, most of us used two-tier structure,that is Presetation layer and Datalayer, we can layout the page and change the database in a single page, quite effienct too.
I want to return a 404 response from an ASP script (IIS 5).
Response.Status lets me set the response string, but if I don't include any HTML text myself, the result is an empty page.
Is there a way to 'redirect' it to the server's default 404 response, as if the URI really doesn't exist, but without really redirecting it so the URL isn't replaced in the browser's address bar?
I am trying to replace a huge chunck of code that currently I incorporate with an #Include directive. The program rarely has to flow through that code, so I thought it would be better if I used Server.Execute. I found I can pass data TO the called asp file by creating an HTML <input> and erading it after I get there. However, I also need to read back ONE variable that the called file must set. I cannot figuer out how to do that. My backup positions are (1) I can keep on using the #Include technique, and (2) I can use a database to bridge the gap.Isn't there a way to carry data BACK TO the calling asp file FROM THE CALLED asp file?
I am using a stored procedure to insert set of values to a table.I am generating or calculating the value of the primary key and inserting that record and i need that value to use in my application so is there any possibilty to return a value from storedprocedure to asp application.
what i am using to do is creating a #temp table and inserting that value in the sp and then opening that value in the asp application and droping that table, but i hope it is not a efficient method.
When a user logs in, I want to redirect them to the page that they were previously on. How do I do that? I already have the login page working. I just need to edit the redirect part.
