Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    ASP & have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for

Selecting The Next Five Upcoming Birthdays From The Current Date

I want to do is select the next five upcoming birthdays from the current date, using ASP + Access. The name of table is "juventude" and the birtday field is "db_dtnasc" ....

View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Recordset To Only Contain Current Items (i.e. If Date Of Item Is Past Current Date)
I have a noticeboard that the user inputs items into. One of those is the date of an event. Once that event has passed I want it to disappear from the page.

So I need to do a comparison with current date to the date in the "datestarted" field. My table is called "notices." Using Access and ASP VBscript.

View Replies !   View Related
How To Check The Date Difference Between The Current Date And The Booking Date?
I am developing a simple booking system where I had a booking date. The problem is I want to make sure that the user must book 3 days in advanced for certain room.

I have tried to use DateDiff but it seems doesn't work. Actually i just 1 to make sure that the user must book 3 days in advanced from the current date. I am wondering whether there is anything goes wrong in my datediff function. Code:

View Replies !   View Related
Selecting * After Date()
I have a database with date of gigs in it and am trying to select * from the database the next gig basically, and am compariung against todays date and saying select * more than todays date. Is this right, cause it's not doing it? Code:

dateN = Date()
set conn = Server.CreateObject("ADODB.Connection")
conn.Open "************"
set recsetS= server.createobject("ADODB.Recordset")
sql = "select * from admin where dated > "& dateN &" order by relevance DESC " sql,conn,3,3

View Replies !   View Related
Compare A Date In My Database To The Current Date
I am trying to compare a date in my database to the current date. MySQL statement is:

sqltemp5="select * from users where dateclosed <= '" & date & "'"

What I am trying to accomplish is exclude records where the dateclosed field is older than todays date. Such as if dateclosed = 6/30/2004 then today being 08/25/2004 that record should be excluded.

View Replies !   View Related
Selecting Records Where Date Between Two Dates
I'm trying to display all the jobs that occur during a selected month/s. Here is the code I use: Code:

View Replies !   View Related
Storing Dates As Int But Selecting Them As Date
while I store the dates as is in db, I can use a select statement like this:

mySQL="SELECT SUM(total) AS totalSum, month(orderdate) AS monthsql FROM orderDetails GROUP BY MONTH(orderdate)"

but when I use dates as integer, it simply gives me error. Are there any way of getting over that problem?

View Replies !   View Related
Get Current Date
i need a button or a link, that when clicked on, grabs the current date. It then puts this date inside a textbox.

View Replies !   View Related
SQL For Current Date
I am coding an ASP page and need to know how to pull the current date.

Here is my code:

SELECT tenant_id,fname + ' ' + lname as [name],
WHERE start_date < [TODAY'S DATE] AND [TODAY'S DATE] < end_date

View Replies !   View Related
I have an event that update my database, I would like to record the current date and time when the record was updated. Not quite sure of the command.

View Replies !   View Related
Expire Date To Current
I would like to know how can I remove expires date from asp I am not this can be done in access or asp script. There are a field i n access datbase say p_expdate which I delete and replace p_date which display the current post date

Which specific file in asp should I modify I had look into the file like register.asp and search for p_expdate. I had rename to p_date. Do you think the setting on my datbase or value I need to set.

View Replies !   View Related
Fill A Box With Current Date
i have three boxes to display date.dd/mm/yyyy format.1 box for dd 2 for mm 3 for yyyy.suppose today's is 25 july i want to fill this box date from 24 july 2005 to prevous month 25 june 2005 .means each time one month back of current date.

View Replies !   View Related
How To Update My Access To Current Date??
I try using the following sql statement..

strSQL = "UPDATE Messages(TABLE) SET Date=now() where MessageID=25"

The error given to me:
Syntax error in UPDATE statement.

I'm doing an update of the date already stored in my Access. How do i
resolve this problem??

View Replies !   View Related
Delete ALL Records Before Current Date
how can you delete every single record in a table from the access DB with a DATE column, which stores the date in format DD/MM/YYYY? Code:

View Replies !   View Related
Next Five Birthdays
I'm using a MySQL database. I'd like to retrieve the next five upcoming birthdays (column `birthday`) from table `users`. What's the best query I should use for this?

Currently, I'm trying this, which returns an empty recordset:

RS.Open "SELECT `userID`, `username`, `birthday`, `donated` FROM `users` WHERE DATE_FORMAT(`birthday`, '%j') > DATE_FORMAT('" & Date & "', '%j') AND `status` <> 9 AND `confirmed` <> 0 ORDER BY `birthday` DESC LIMIT 5;", Conn

View Replies !   View Related
Show Recordset Based On Current Date
I want to call a recordset based on whether the 'expiration_start' date and 'expiration_end' date are within the current date.

I've tried a few things but can't get it to work?

Here's my non-working SQL statement:


sSQL = "SELECT * FROM poll WHERE #" & date & "# BETWEEN expiration_start AND expiration_end"

I'm simply using 'date' to call the current date. I'm not sure if that's correct but it seems to work ok when I use it in an "if" statement like this example:

View Replies !   View Related
Implementing Current Date Into Form Variable
<input type="hidden" name="date" value= (Date)>

When I use:

<% Response.Write (Date)%> if returns the date I want.

I need to enter it to this date value in my form. What is wrong with my code above? It should be obvious, but I can't figure it out....

View Replies !   View Related
Current-Date-Driven Range Of Events
I entered a whole year's worth of events. I want to display a range of events which change according to the date, so only 2 weeks later and one week earlier are displayed on the main page.

How did other people deal with similar issues? I know I can set a range mathematically speaking (date + 14 AND date -7). But did other people encounter other issues? How did you solve them?

View Replies !   View Related
Error In The Consultation Of Information With Current Date
This command below would have in accordance with to catch information of bd the current date, or either... I inserted notice day 05 today, then the user has access and this command alone shows information of day 05 today, sees the command that I tried to use Code:

View Replies !   View Related
Showing Birthdays In ASP
I have a table called 'players2005' with fields of 'player' and 'pdob' The 'pbod' is a DATE realted to the players date of birth.

Using ASP how can I call the access database to show members that date of birth is today.
I have the rest of the script but just nedd a SQL statement Code:

View Replies !   View Related
Current Date And Due Date
I have two textboxes, currentdate and datedue. When a user enters the current date, how do I automatically update the datedue textbox so that it is 4 months later?

View Replies !   View Related
Selecting Info
I'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"
strTemplate = "template.htm"

If request.form "template" = "template2" then
strTemplate = "template2.htm"
strTemplate = "template.htm"

End If
End If

View Replies !   View Related
Selecting A Value From The List Box
I have a list box which has the following values:

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?

View Replies !   View Related
Selecting Dropdown In ASP
My boss wanted me to add a dropdown to this form. I was able to add in the dropdown and it inserts into my database (Access) just fine. However, I have an edit page also and this is where my trouble comes in.

On the edit page, the dropdown does not "know" which specific option was selected. I tried to write an If statement but I think there is something wrong in my syntax. Code:

View Replies !   View Related
Selecting Software
I have undertaken a website revision project after not programming for about 6 years. I am beginning to set up a work environment on my pc, and have questions about the software being used verses what could be the ideal software.

I am familiar with classic asp pages, not I am also familiar MS Interdev (but am unable to locate my copy and cannot find a torrent file - is this an archaic program now?). The last thing that I'll mentioned is that I prefer to have a debugging capabilities.So the current website uses Dreamweaver 8.0, IIS 6.0, and MSSQL 2000. Question.Given my background, what software would you use to set up a work station?

View Replies !   View Related
Selecting Values
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.

View Replies !   View Related
Selecting Last Record
i need to extract some data from a table called accountantsBids. I want to select the last entry for every accountant based on the date descending.

entryid = Autonumber
Accountantid = FK

I've tried TOP 1 but that doesn't do it - it only gives one recordset. What would be the best way to get this working.

View Replies !   View Related
Selecting All Checkboxes Using ASP
I created a form for Deleting multiple records (from Access db )using checkboxes. However, I would like to add a link or button that would check mark all the checkboxes since I could have hundreds of records.

What is the best way to go about it. Does anyone knows of any samples other than Javascript.

View Replies !   View Related
ASP & XML - Selecting Last Node??
I was wondering if anyone has a moment to look over some code I've written?

I'm involved in the maintenance of an old CMS system I wrote a number of years ago, when I was regularly coding in ASP. These days it takes a while to mobilise the grey matter when it comes to ASP.

Anyhow, basically I am trying to select a specific node and determine the id of the last child of the parent node.

At the moment, I am only returning the first childs id, despite my best efforts. Code:

View Replies !   View Related
Selecting Ranges
On the online crm system i've built (using ASP) our customers can create a list of contacts and download/delete/add to this list when they want to and then go and view the list. It will display 20 on a page with forward/back buttons etc.

I have written a routine which queries the MS SQL 2000 database and retrieves all the IDs of the contacts. It will then work out the page it is on and display the appropriate records by reading through the 20 IDs for that page and query the data from each ID it needs to display on the screen.

This works fine for lists of up to 1000-2000 but when it gets to 5000, 10000 records it becomes an issue of performance as it will hold in a variable all of those 5000 or 10000 IDs. There has to be another way of doing this.

View Replies !   View Related
Selecting Count(distinct Value)
I want to select just one field to display using sql and I want to have another variable that counts how many fields of the same value there are. My code looks something like this but i'm getting an error...

ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name or ordinal. Code:

View Replies !   View Related
Selecting Random Images
Is it possible to select random images from a directory without creating a "library"

As in I want to have a directory with 25 or so images and want to randomly select an image without having to change the txt document when I add new images.

View Replies !   View Related
Selecting Which Page To View .ASP.
This is my page that displays a certain players games played below. It sorts by games played and excludes all records that = 0. Now with 9 different grades to show i did not want 9 different pages, so i added in 'strSortGames' so that they can select which grade to view and only one page is needed.

I used a menu (list field) on a previous page to do this, do you no a better way to do this? e.g Text links or some other way? or is a list field a fairly good way? Code:

View Replies !   View Related
Selecting DB Results Where First Letter = ?
What query would I have to use to select entries from a database where there first letter is a letter of the alphabet? ie. Select all entries starting with an A etc.

View Replies !   View Related
Selecting Distinct Intervals
I need help programming a search function. I want to narrow down a search function regarding time. I figure the best way to do this is to select a higher interval and a lower interval, and then have an sql function that grabs the times from within that range.Code:

sql = "SELECT DISTINCT place, time FROM bussystem WHERE time >= '"&timey&"'"
Set rscurrent = Server.CreateObject("ADODB.Recordset")
rscurrent.Open sql, conn, 3, 3

sql = "SELECT DISTINCT place, time FROM bussystem WHERE time <= '"&timey&"'"
Set rsrecent = Server.CreateObject("ADODB.Recordset")
rsrecent.Open sql, conn, 3, 3

View Replies !   View Related
Selecting All12 Months
Is it possible to select all twelve months in one select query either from a single field name or through an alias name?
I have a field name that conatins dates, and I would like to arrange the value of each month in a grid, jan-dec, monday-saturday. can I accomplish this with one select statement using an access db?

View Replies !   View Related
Inserting And Selecting Image From DB
I need Help in inserting the user image in my data base. but
unfortunatly I don't know how.I'm using asp with sql server. I tried to
insert the image and i geuss it worked.for the field in the db in not
null and it have this value <Binary> . but when i try to select it in
gives me this error "An unhandled data type was encountered".
this is my code :

View Replies !   View Related
Selecting Values That Do Not Match
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.

View Replies !   View Related
Selecting Drop Down Options
I am trying to set up a component that will allow events that are date sensitive. From this date to that date. What I am trying to do is use drop down menus for selecting the dates, and I am having a hard time finding out how to build these drop downs so when someone is editing an event, the existing dates are pre-selected in the drop downs. But I need to seperate year, month and day for both and then have it change the value of the correct option to selected.What is the easiest way to do this?

View Replies !   View Related
Selecting Random Records
i want to select some records from my database by random. i want also to set a limit (limit=9).

View Replies !   View Related
Selecting Correct Details
Im trying to make a client area on my website and an not sure on how to go about editing clients details.When the client logs in they are brought to a menu where they can update there record. How can i get the appropriate record from the database so they can update there details?

View Replies !   View Related
Selecting 2 Access Tables
Select data from 2 tables at the same time but there is no relationship between them. This is what i want but i dont know how to join them.Here is what i was trying.Code:

sqlstr = "SELECT * FROM persinfo,positions WHERE personid.personid = '"& session("personid") &"'"
rs.Open sqlstr,conn,0,2

sqlstr1 = "SELECT * FROM positions WHERE jobidid = '"& session("jobid") &"'"
rs.Open sqlstr1,conn,0,2

View Replies !   View Related
Selecting Random Rows
I've got an application I'm working on that will be used to generate and track the results of a computer based test. What my boss want's to do is have a repository of questions. Have some questions coded so they are always asked, and the remainder of the test come from randomly selected questions.

I'm having trouble figuring out how to pull random rows from a table and make sure that that they haven't already been selected.

View Replies !   View Related
Selecting Part Of A String
I'm just starting out learning a bit of asp with my job so pardon my bad use of any jargon

In 'A:B:C: D:E' I want it to only return 'A:B:C: D'. Dropping off the content after and including the LAST :

Can anyone help?

View Replies !   View Related
Selecting The Bottom Number
I want to select the bottom 25 of records in my table. How would I do this?

View Replies !   View Related
Selecting Multiple Records
I want to select multiple records using the WHERE function. Currently my SQL query is as below:-

strSQL = "SELECT albums.* FROM albums WHERE id = 1"

As well as selecting id = 1, I would like to select id = 2 and id = 3 . How can I write this? I have tried seperating it by commas and spaces but this didn't work.

View Replies !   View Related
Selecting Tables From A Drop Down Box
i have a drop down box that selects tables on my asp page, but using the hidden attribute, they have fixed positions on the screen. this a search engine and i need it so that if they only search two options that them two options will be at the top of the screen?

View Replies !   View Related
Selecting All Values In A Week
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:

View Replies !   View Related
Selecting Data From Two Databases
I am trying to write a SELECT query in ASP to retrieve information from two databases (that must be kept seperate :-().

I have managed it using Access using something similar to the code included below, which I have modified for ASP. Looking around this seems to not be possible in ASP, instead the general recommendation is to link tables??? I would prefer to do it using ASP. Code:

View Replies !   View Related
Problem Selecting An Option
I have got a form with a set of options like this:

<select name="Target">
<option value=""> A.Name</option>
<option value=""> B.Name</option>
<option value=""> C.Name</option>
<option value=""> D.Name</option>

I'm using this at the moment to get the vlaue:

Email = Request.form("Target")

I would like to have another variable ("Name") which could store the actual name,rather than the e-mail address.So,while "Email" could store "", "Name" would store "A.Name".

View Replies !   View Related
Record Sets - Selecting All Results
im a passing 3 fields from a form to use a search criteria against an access database table, i have set the fields a numeric values, what should i use to allow all records to be shown for a invidual value rather than a selected value.

Ie the form would pass

Location_id as 22

so the result page would see Request.form("Location_id")

sql would then see

where location_id = var1

var = 22

but i want to get the sql to say

where location_id >=0

what do i need to do

View Replies !   View Related
Selecting Random Records From 2 Different Databases
I have a tough question that i ca't get over it for all the day.
I have two different news tables. I can't get any of them and list.

Bu i want to do something different. I want to get both and randomize them and list them.

for example,

1. news (from the 1st db)
2. news (from the 2nd db)


is that possible, because i couln't find any solution for this.

View Replies !   View Related
Show DB Values When Selecting An <option>
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.

View Replies !   View Related

Copyright 2005-08, All rights reserved