I have an asp page that I'm trying to make, that will allow users to start a new time sheet. when doing this, the users will select a pay period start and end date. I have a table with the days of the week for two weeks (i.e. mon1-sun2). When users select the start and end dates I want to populate these fields with auto increment... Soo my question is, does anyone know how you auto increment the date using ASP?
View RepliesI use asp to execute an INSERT query into a table that has an auto-increment column can i get the value of the auto-increment column with a function in asp?
View Replies View RelatedI'm trying to implement a feature where when user click on a button, a table will be displayed in the page and when second time the user clikc on the same button, the other table will be displayed, and so on. can anyone give me an idea on how to implement this?
View Replies View RelatedI just want to make the primary key so that it auto increments. Thanks
Code: .....
I am having problem inserting the auto_increment id (FID) of table "TOPIC" to FTopicID of Table Msgs. Code:
View Replies View Relatedi have a field with a list of wrong ID (random) and i wish to replac
them with a sequential (auto-increment) value. how to remove the valu
and to add in the sequential ID?
If today date was 06/10/2003 how do i increment it to 07/10/2003? And also to increase time 4 hours from it's current time. E.g Time Now = 23:30 => Increment 4 hous = 03:30
View Replies View Relatedi have a field in my form which auto adds the date to my database, its inputs as 1/09/2007 and what im after is when i retrieve that data to be displayed i would like the date to be displayed as 9th September 2007,
View Replies View RelatedI just recently created a html form and one of the fields required a date. I want to make it so it will insert the date when the form is being filled out. For example, if I fill out the form today I want today's date on it.
I am going to connect this form to a MS access database, the database also has a field "date". How would I like all these together? Also, I want to send a notice to a specific email whenever someone submits the form.
i hv created function that used to increment ID. The max id is like Q01946. once user click on the "new" button, the id suppose to be Q01947. but wat i get is Q1947. could anybody know how to keep/maintain the "0" value
View Replies View RelatedI am retreiving a number from the db then need to increment it by 1 and then store it back in the DB!
is this possible? I am counting how many times users are logging into the site. this is the current code....
I have created a field which is in access database so user cant see on web page so whenever user submit their form I want to increment that field value by one ..
NOTE: This is field is not primary key and its data type is "text"
An ASP page has a variable named iCounter whose initial value is 0. This ASP page has a drop-down list. When an option is selected from the drop-down list, I want the value of the iCounter variable to increment by 1. For e.g. when an option is first selcted, iCounter should be equal to 1. When an option is selected again, iCounter should be equal
to 2 so on & so forth. How do I do this?
do anybody know how to write a code to increment id number in the text field once the "New" button is clicked in the form. Code:
View Replies View RelatedHow would I get the max record + 1 to auto-populate in the GMVINC form field? I have a feeling that my query is not correct. Code:
View Replies View RelatedWhen the user clicks a button, I want to increment a server side variable by 1. When the user clicks a different button, I want to decrement a server side variable by 1 only if the variable is not less than or equal to 1. Does any one know how to do this?
View Replies View RelatedI 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:
i'm new here and i'd like to ask if there's someone who knows how to compare date() function and date from database with date/time type inside select statement so i don't have to do if..then..else
View Replies View Relatedi have a page with top frame (html) and bottom frame (asp)the top frame come with choices and then submit value to bottom asp page by submit button.how can i do it if i wish the bottom asp to run automatically in specific value when the html is loaded.then the user can change the choices after.
View Replies View Relatedsql = "UPDATE Marknad SET" _
& " Typ ='" & Typ & "'" _
& ", Modell ='" & Modell & "'" _
& ", Arsmodell ='" & Arsmodell & "'" _
& ", Beskrivning ='" & Beskrivning & "'" _
& ", Stad ='" & Stad & "'" _
& ", Prisidé ='" & Priside & "'" _
& ", Fornamn ='" & Fornamn & "'" _
& ", Efternamn ='" & Efternamn & "'" _
& ", Telefon ='" & Telefon & "'" _
& ", Epost ='" & Epost & "'" _
& ", Datum ='" & Datum & "'" _
& " WHERE (((Marknad.Annonsnr)=" & Request.QueryString("id") & "))"
DatabaseConnection.Execute sql
---
Above does work as I want it to do BUT it inserts 1/8/2006 instead of 8/1/2006 as it should!
The best thing would be to exclude the date from updating at all, but when taking away the line:
& ", Datum ='" & Datum & "'" _
It gives an error... how do I solve this?
I forgot, you might want to see this:
Datum = date
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.
Is it possible in ASP to have an Auto Fill option? For instance, if I am typing in a name and I type in the first few characters, can ASP recognize a similar name in the database and begin filling in the rest of a possible match?
View Replies View Relatedive got an online system which allows people to enter info into a database about an absence request they have - at the same time this emails the person in charge of absences.
The form is setup now but to make it easier i want to alter the "Name" and "email" fields so they require no filling in ie - a staff members name will be chosen from a drop down list (ive done this bit fine) and then once this is done the relevant email for this person is automatically placed in the email field. This bit i am struggling with - anyone any ideas how this can be done??
does anyone in here got an idea on how to automatically send an email message once a person signs up for a website? i'm doing a small website right now and if a person signs up on the website details about the non profit organization would be send automatically to their email.
View Replies View RelatedIn my form I placed a text box, in which I want when the users writing something some choices from a database table to be presentes for example:
if they wrote
G
a drop down list to be showned which contains.
I am running 2000 server, sp4, IIS 5
I need to be able to autoexecute an asp page from a batch file that is placed in the windows scheduler.
I can execute the page fine, but I can't get past the authentication. How do I pass the username and password to windows via the URL automatically so this can be done without any user action? This is not a https but it uses integrated windows authentication.
I work for a large company and the outside supervisors are not that computer savy. The simpler the better. Each supervisor has 15 employees that he must assign work for each day(Monday through Friday and sometimes Saturday).
I am trying to create this so they can click on a button it will add 15 new records to Table A that are copied from the day before. Then they just have to update the new records with today's LocDate and a new location if needed. Code:
I have a an url to file in one page and when user clicks, it takees them to another page, say url.asp?ID=...
On this page i want the download to that file to start automatically. the purpose of this page is to record the number of file downloads. is this possible in asp, or is there a better way of doing this?
how to make a window explorer closed tiself like after 1 min? I think I rem there is such function available but I had forgotten the function/code...
View Replies View RelatedI would like to write an ASP script which will auto-login me to a Yahoo account or some user account which needs a username and a password. How can I make this possible using ASP?Or is there any way to get auto-login working?
View Replies View RelatedHow can you get cursor to "jump" from the first field that has focus onto the following one and so on, and is it possible to do so if fields sometimes might be empty and if so how would I take care of that?And is it possible to make autotabbing if the field is not a set lenght, I have only come accross examples where the field is expecting to receive a certain number of characters?!!!
Can you use the option of auto tabbing only for input field or it can be done for select options as well?
I am currently developing a web form for the transfer of assets between departments, which will store information in an Access database. I currently have the form created and I am working getting the transaction processing portion of it going.
Basically, there is a minimal amount of information that needs to be entered into the form and I would like the rest of the information to auto-fill. So for instance, I would enter the asset number of the asset to be transferred, and said asset's serial number and description would fill in automatically. I have go this working in Access, but I'm at a loss for how to do it with ASP.
I think that I need the script to execute after a change is made to the AssetNo field, but I have not been able to get it to work how I want. Code:
I am in the beginning phase of a project that will require automatic email reminders to be sent out. Has anyone had any experience or suggestions that might help me get started in the right direct. My project will use the following.
ASP/VBScript/SQL Server Express
Once a record has been added the Auto Email reminders will be sent every 24 hours for the first 3 days or until the receiving party has responded to a questionnaire.