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 to display results that do not match those in the database.I have an excel file and i upload it,inserting the records in a temp table. han i compare the values in the original table and the temp table.All i want is the values that do not match
sql = "SELECT TempSerial.SerialNo "&_
"FROM TempSerial, Serial WHERE TempSerial.SerialNo <> Serial.SerialNo "&_
"OrderBY TempSerial.SerialNo;"
Set RS = objConn.Execute(sql)
i displayed the records with <%=RS("SerialNo")%> but i get all the records in the temp table displyed.
hi there i need to display results that do not match those in the database. I have an excel file and i upload it, inserting the records in a temp table. Than i compare the values in the original table and the temp table. All i want is the values that do not match..i did this:Code:
sql = "SELECT TempSerial.SerialNo "&_
"FROM TempSerial, Serial WHERE TempSerial.SerialNo <> Serial.SerialNo "&_
"OrderBY TempSerial.SerialNo;"
Set RS = objConn.Execute(sql)
i displayed the records with <%=RS("SerialNo")%> but i get all the records in the temp table displyed.
I have a form where the user selects their EmployeeID from a DB populated dropdown list. Then they fill out some other information and submit the form. I would like to make it possible that when the user selects their EID, other DB information tied to that EID is displayed on that page (Name, Phone #, etc), so that when the EID is selected, the employee can see their name and info, before the form is submitted.
Is it possible for JS/DHTML to show which value is selected (without posting the form) and then use that variable to call the additional information from my DB using SQL? I would probably then show that value using <div> or something.
Sorry, I am familiar with ASP/VBScript & SQL, but I don't know a ton about Javascript. And I don't think what I want to do is possible with only ASP, unless I post my form to another page, and then that page post the final submission for the form... I'd rather keep everything on one page, then submit the form.
This may seem like a silly question but i am now trying to get my data from my oracle database. This is going okay but i have the issue that when i have blank data in some of my fields, when i select it and out it in a table it doesn't seem to read them correctly
This is my asp code:
I use a multi-select menu in an ASP so the user can pick several values.
<select multiple name="lbErrorType" size="12">
However, after I have saved the records to the DB, and the user comes back
to edit a prior record, I re-populate the multiple select box and do a
"<option selected>" for each record that is saved to the DB.
<option selected>
But only the last value is selected !?!?
How do I get the select menu to select ALL the appropriate values ?
I was wondering if you could help me with the following problem. I have 2 listboxes in my
webpage, 1 has cities, and the other lists the streets of the city from the first listbox.
When I click on a city, I want the 2nd listbox to populate with all streets in the city. The city and streets are saved in a database, so when the user selects the city, I will run a query on the database and populate the 2nd listbox with all streets.
How can I do this with normal ASP? I know how to do this with ASP.NET, but don't know how to activate this with normal ASP?
I need the formula to return me the first day of the current week.. I've searched for 2 hours online and haven't come up with a classic asp example.
For instance - when the formula is run today, it should return 6/5/2006.. when it is run this thursday, it will be the same.
I have this working in T-SQL right now, it looks like this: DATEADD(day, 1-DATEPART(dw, GETDATE()), DATEADD(day, DATEDIFF(day, 0, GETDATE()), 0))
Perhaps this could get converted to asp >?
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?
View Replies View RelatedIs there a built in ASP function for getting the day of the week? Ultimately I'm trying to come up with the output:
Thursday, September 23, 2004.
Need to print "Week of (first day of week)" First day being Monday.
ie:
week = Request.querystring("mydate")
response.write "Week of" & week
If week = 5/6/2004 (which is Thursday) it should output "Week of Monday, May 03, 2004"
How can I do this?
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.
View Replies View RelatedIf 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.
I'm looking for a function that returns a date range for a specified week number of the year I'm not able to find functions like this anywhere.
View Replies View RelatedI need to provide a pulldown with work weeks displayed.Is there any easy way to do this?
I would like to go 6 months from the current date and show a week as Oct. 11- 15.Which is Monday to Friday.
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.
Is it possible (how) to display a new record every week (or day) from a recordset?
View Replies View RelatedI'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.
View Replies View RelatedCan 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.
View Replies View RelatedI 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?
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:
DatePart("WW", [MyDateField])
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?
View Replies View RelatedI 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.
Something to do with the ServerPath?
i want to display the Week start Date & End Date with week number when i use:
select datepart(date,Pur_Date),sum(Amt) from Purchase where Pur_Date
between '01/01/2004' and '14/01/2004 ' group by
datepart(date,Pur_Date)
result should be displayed as:
week start date end date SumAmt
1 01/01/2004 07/01/2004 1000
2 08/01/2004 14/01/2004 20000
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?
View Replies View Relatedis there a way to calculate the month from a week number and year?
View Replies View Relatedhow to retireve World Week calendar?
View Replies View RelatedI've got a WYSIWYG editor, that runs off a template page (i.e. template.htm) that gets opened in an iFrame for editing.
How can I get it setup so I cange the template at the click of a button? I've tried doing a form with radio buttons, but can't get it to work.
For example, the iframe source has been set to "strTemplate". My form processing was along the lines of:
<%
If request.form "template" = "template1" then
strTemplate = "template1.htm"
Else
strTemplate = "template.htm"
If request.form "template" = "template2" then
strTemplate = "template2.htm"
Else
strTemplate = "template.htm"
End If
End If
%>
I have a list box which has the following values:
Car
bike and Boat
If I select "car" it is fine but when I select "bike and boat" it just takes bike
as the selection. It is taking the space as the end of the string. Is there a way I can
rectify this?