Time Insert
I've got a site with multiple sections (jobs, clubs, motor, property etc), and have banner adverts displaying. Banner adverts have defined start and finish dates to allow advertisers to have period campaigns. They can also choose which section to display in, as well as location of advert (banner, side, base) on page.
But I would also like to break it down further for them to have an option of starting at 01/06/2004 06:00pm to 31/06/2004 09:45pm as an example.
Firstly, I need to find a time selector to enter the times into 'form field'. any help there? I have a date selector, but no time facility...
Secondly, I need to develop the correct select statement.
here is the date part of it:
strSQL = strSQL & " AND START_DATE >= DATE()"
strSQL = strSQL & " AND FINISH_DATE <= DATE()"
The problem I know if I simply put the time being greater than and less than, then the advert will only be seen between those times on those days in database, but I need them to be seen between the time on start day to the time on finish time, and all inclusive.
View Replies
ADVERTISEMENT
I tried to insert time using now() and failed,
time= date();
conn = Server.CreateObject("ADODB.Connection");
rs = Server.CreateObject("ADODB.Recordset");
conn.Open("DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" +
Server.MapPath("generator.mdb") + ";");
sqlQuery = "INSERT INTO table1 ([time]) VALUES (" +
time + ")";
conn.Execute(sqlQuery);
View Replies
View Related
I want to insert the element selected by the user from the drop down box in the DB(Access).Once the user hits submit i want it to insert this in the DB + i want to update one of the fields from True to False . how can i perform both these at the same time?
View Replies
View Related
how to insert current date and time in an insert command into SQl.
insert statement as it sits..
SQL = "INSERT INTO adLogins (adLogins) "
SQL = SQL & "VALUES ('"&user&"')"
objCn.Execute SQL
i have another column, date/time format and would simply like to also shove the date in.. column named dateLogin.
View Replies
View Related
I need help to solve this situation....
House 1 (1 photo)
House 2 (4 photos)
Example:
Table1
idHouse....#auto
House.......text
Addr..........Memo
Table2
idPhoto.....#auto
idHouse....num
Photo........text
I need insert multiple records into a single field of the Table2 and
insert the idHouse too. How do I do this?
View Replies
View Related
I need to deposit and empty dummy value into a date/time field within Access
using INSERT. However, I pick up a data type error if I attempt to insert
a NULL value for this particular date time field....
What are my options here.....I need the date to come up empty.....what can I
do?
View Replies
View Related
Does anyone know how to insert multiple records in the same table at the same time. This is what I have. I have a form with 6 fields and they are name prod1 through to prod 6. The table is called related products.
Basically this table is related to the main table called prod_parent. tried looking on google and couldn't find anything.
View Replies
View Related
I need to insert atleast 10000 records at a time but if the user stops the process i need to rollback the transaction.
View Replies
View Related
How to prevent duplicate values when using BULK INSERT to insert CSV to SQL Server? Code:
View Replies
View Related
I would like to display the difference between the logging time
[Session("start"] and the current time [now]. In hours minutes and seconds,
I have tried a couple of things but all I see is gobbledy gook.
View Replies
View Related
I have a website that I subscribe to that allows me to track tasks. I have an extra computer with a big monitor that i want to always display the task list. the problem is after so many hours I get logged out.
I need to need to reload that sign in url every few hours Code:
View Replies
View Related
there i was just windering how do i compare a date/time vlaue in sql server agaisnt the computers' date/time.
for example, if computer date/time is two months or 2 weeks before the database date/time do something
View Replies
View Related
Currently working on a ASP for a friend, which requires the date and
time on it. It pulls in entries from an Access Database with dates and
times in the format of:
"Fri Oct 17 18:02:46 2003"
However my date and time on the ASP page is displayed as:
"Friday, October 17, 2003 18:02:46"
using the script:
"<%Session.LCID = 1033%>
<%=FormatDateTime(Date(), vbLongDate)%>
<%Session.LCID = 2057%>
<%=time()%>"
Anyone know how to change this script, fully or partly to produce the
date and time on the format that's in the access database i.e. "Fri Oct 17
18:02:46 2003" Code:
View Replies
View Related
I am working on a database that collects information about incidents. One of the fields that people enter is the time of the incident. I am trying to convert that string that people enter into a OdbcType.Time and I am at a lost.
View Replies
View Related
How will we convert the system date & time to other timezone for eg: Eastern Time zone using ASP?
View Replies
View Related
When the Form is submitted I use the Date() and Time() functions to put the date and time into the Body part of the e-mail. The time reported is three hours earlier than the time at which the Form is actually submitted.
I understand these functions are evaluated on the server so the server must be in a time zone three hours earlier than where I am . Is there any way I can get the local time at the location where the user is actually located. ?
View Replies
View Related
Any some tools or sample codes drop down asp script execute time and
database connection time ?
View Replies
View Related
I'm trying to do a very simple code that converts the server time into a time zone of your choice.
<%
dim h 'Current Hour
dim i ' Time Zone Increase - add or subtract hours
dim r 'Result Here
h = Hour(Now)
i = + 2
r = h + i
%>
but obvisouly i'm having trouble with the time zone convert.
View Replies
View Related
I am trying to compare the NOW time with a "deadline" time. Please help. Just not sure why this is not working. I need to be able to say IF IT'S BEFORE 9:30 TODAY, IT'S OKAY TO ADD SOMETHING. IF IT'S AFTER 9:30 TODAY, YOU MUST ADD IT TOMORROW.
CODE:
nowtime=now()
deadlinetime=formatdatetime(now(),2) + " 8:30:00 AM"
response.write "NOW: " & nowtime & "<BR>"
response.write "Deadline: " & deadlinetime & "<BR>"
if nowtime<deadlinetime then response.write "can send out today" end if
if nowtime>deadlinetime then response.write "must send out tomorrow" end
if
RESULTS:
NOW: 1/18/2007 8:51:43 AM
Deadline: 1/18/2007 8:30:00 AM
can send out today
As you can see, NOW is GREATER THAN Deadline, so it should must send out tomorrow.
View Replies
View Related
i want to calculate the total time between to dates and time.
Example: Total time elapsed from date 1 time 1 to date 2 time 2.
27/09/2004 11:00 - 28/09/2004 10:30
The user enters a record and then later comes back and closes it. I need to know the time it took from when they entered the record until the time it was closed.
View Replies
View Related
Our graphic designer has just finished redeveloping our website. On the
site, we use SSL to secure the area where a user enters their personal
information to order items from us. (we do not do many transactions - maybe
1 per day...) We are a log home mfg company so they would only order plan
books, maybe a video etc...
When the user clicks "Submit Order", we want to encrypt each data item
(because of new legislation governing customer personal info etc...) and
write a record to an access db. From here it will be imported into our
Customer DB leads database...
I do not use ASP but program in VB 6 and Access 2000. ASP looks similiar in
many ways...
Does someone have a good ASP script for encrypting data? And, if so, is it
fairly strong encryption?
Also, is there any trick to writing an "insert" SQL script in ASP or is it
exactly the same as I would do in VB or Access? Maybe someone has an
"insert" script handy they could pass along including the command to
actually execute it?
View Replies
View Related
i have got a data base which contain more than one tables
one for student one for teacher and one for books
i make a fourm to read the input from the user Code:
View Replies
View Related
Code:
mySQL="INSERT INTO products (sku, youtube, description, details) VALUES ('" &pSku& "','" &pYoutube& "','" &pDescription& "','" & pDetails& "')"
call updateDatabase(mySQL, rstemp, "insert1")
that's shortly the way i'm inserting new records.
using mysql and asp functions.
The prob is that inserting only one record every time.
if i got data for 3 records how can i make it at once
to add 3 new records in some given order into the db
View Replies
View Related
What is the best way to see if a record has inserted correctly into the datase in ASP?
Also, how to tell the user what the error is.
I am inserting like this with the ADO command object:
Dim sInsert, objCmd
set objCmd = Server.CreateObject("ADODB.Command")
sInsert = "sp_ADS_Insert_Driver_General_Data "
on error resume next
With objCmd
.ActiveConnection = oConnEnergy
.CommandText = sInsert
.CommandType = adCmdStoredProc
.Execute , , adExecuteNoRecords
View Replies
View Related
Application X has three screens. The user captures information on screen one and then clicks a navigation button to go onto screen two.He does the same on screen three. At the bottom of screen three is a submit button. When this button is clicked the system does some calculations with the information that is supplied and then uploads all the info that was captured on the screens to the database.
Should the data be uploaded to the database all on one go when the user clicks the submit button or should it be uploaded after each screen - ie when the user clicks the button on Screen 1 the data is uploaded to the database and then screen two is displayed.
View Replies
View Related
When the following code runs it produces no errors but doesn't give proper results:
sql = "INSERT INTO TableName (Line1, Line2, Line3, Line4) VALUES ('" & lines(0) & "', '" & lines(1) & "', '" & lines(2) & "', '" & lines(3) & "')"
Response.Write(sql)
SET RS = Conn.Execute(sql)
lines() contains nothing but strings and is never empty.
The Response.Write(sql) shows the proper values going into the proper locations.
However, only Lines(0) actually populates the table. Line2, Line3, and Line4 never receive any values despite the SQL showing the proper syntax.
View Replies
View Related
i have this insert statement that is giving me trouble, the problem is with expiration_date field the error i'm getting is:
Syntax error in date in query expression '##'.Code:
SQL_Insert = "Insert INTO TableName(ColumnX, ColumnY, ColumnZ, ColumnZZ, ColumnXX, ColunmYY, Expiration_Date) values ('" & _
ColumnX& "', '" & ColumnY & "', '" & ColumnZ & "', '" & ColumnZZ & "', '" & ColumnXX& "', '" & ColunmYY & "', #" & Expiration_Date & "#)"
View Replies
View Related
I have a column call UserDate and it's properties are this : varchar(50) . I have a function which updates the column with todays date. for some reason, if I manualy give the value to be inserted a value of '10/10/2006' or use date() it inserts a value of 0 if I give a value of 4 to be inserted it works?
I have been working on a project for 2 days and this is the last piece to get it to work, can anyone point out where I'm going wrong. P.S I have tried giving the colum a date format but unfotunately the format is american and I need it in english to compare with something else I'm working on.
View Replies
View Related
How can i get the last inserted record in an ASP ACCESS combination? Code:
View Replies
View Related
I'm looking for tutorials on how to upload a file (.doc or .pdf),insert in database and retreive from database. i'm using pure asp and sql 2000.
View Replies
View Related
I'm getting a syntax error when I try to run this SQL Insert statement, can anyone tell me what might be wrong? Before I was getting a data type mismatch error then I removed the ' quotes around the intPhone variable. The error occurs on the line after the SQL statement.
strSQL = "INSERT INTO candidates (Name, Grade, CivilService, Branch, Department, Sector, Town, EmailAddress, PhoneNumber, LunchReq, SpecialReq) VALUES ('" & strName & "','" & strGrade & "', '" & strCivilService & "', '" & strBranch & "', '" & strDepartment & "', '" & strSector & "', '" & strTown & "', '" & strEmail & "', " & intPhone & ", '" & strLunchReq & "', '" & strSpecialReq & "')"
Set rs = cn.Execute(strSQL)
View Replies
View Related
I have a 2 asp pages for a registration form. The first one is where the user types the data, and the second one has a form that requests the data from the 1st one and then sends it to the database. Both are sending the data correctly (I've seen it on the error page) but it's not feeding the DB.
View Replies
View Related
I have a website I am working on that I did not create. It is ASP and SQL based. There is a content management system created using ASP and saving in the SQL server database. A user can enter a news article into a big text box/area, and choose to add an image. The text and image are stored in the database via ASP and pulled out to the website via ASP.
The image shows up in the website to the top left of the article. I need to make it so the user can enter an image where their cursor is in the paragraph (like a word document) and have it also show up there on the website. Any ideas?
View Replies
View Related
