Dateadd Function Not Adding Up
The code generating the page is as follows:
testdate = "1/29/2003 1:00:00 PM"
while count <> 5
testdate = dateadd("n",15,testdate)
response.write testdate & "<br>"
count = count + 1
wend
What is going on there? The times should be incrementing by 15 minute intervals, not 14min and 59 seconds. I have several pages that have suddenly stopped functioning because of this strange date calculating. My web host insists there is nothing wrong with the ASP service.
View Replies
ADVERTISEMENT
This sort of stuff really gets me!I've been using the DateAdd function in various places to return results from the last 3 months e.g.
Code:
SELECT * FROM table WHERE publicationDate > #" & DateAdd("m",-3,now) & "#"
It's been working fine until today when I get into work and suddenly no records are showing up.If I substitute a date from 3 months ago for the function, the records reappear.
View Replies
View Related
Im trying to use the DateAdd and Now() functions so that I can specify some sql statements into my access db. Code:
View Replies
View Related
I'm trying to compare two dates, All I need to see is if the first date is greater than the second date.
I'm fimiliar with how the DateAdd works, I use it often in my SQL Stored Procs, but for ASP it doesnt want to return a value Here's an piece of the code:
If DateAdd(d,DateDiff(d,0,BookingDate),0) > DateAdd(d,DateDiff(d,0,EndDate),0) Then
Flag = 0
Else...
I've also tried just printing out the literal value of the expression but that doesnt return anything either.
Test = Cstr(DateAdd(d,DateDiff(d,0,BookingDate),0))
Response.Write("<b><font color='0000ff'>" & Test & "</font></b>")
Can anyone tell me what I'm missing here?
View Replies
View Related
I'm trying to code a drop down for a date entry that gives the user the option of the current date plus the dates of the last 7 days.
<%
for i = -7 to -1
Response.write "<option>" & DateAdd(d,i,Date())
& "<option>"
next
%>
Besides this, even the following code generates an error:
Today=Date()
Response.write DateAdd(d,5,Today)
View Replies
View Related
I need to add 1 day to a specific date. The date have is stored in a variable called "DateOld". The value of the variable have this syntax: mm.dd.yyyy. The new date is the variable called "DateNew".
This is my code that dont work:
DateNew = DATEADD(d,1,DateOld)
What is wrong here? I get this error message: Invalid procedure call or argument: 'DATEADD'.
View Replies
View Related
I'm trying to add hours together in the format HH:MM + HH:MM. There doesn't seem to be a functional part of DateAdd that will accomplish this though ?
The calculation is to work out how many hours have been spent on a website so exceeding the 24:00 is fine. Is there another function that would accomplish this?
View Replies
View Related
I need to display on a web page a 7 day week split up into 30 minute blocks.
I have written the code below to do this. No doubt it is a load of rubbish (I know the bit that prints the days of the week is, but I'm not worried about that for the moment, I'm more concerned about getting the times correct).
The problem is that I cannot get it to print out midnight. The day starts at 00:30:00 and ends at 23:30:00.
Looking at the code below, can anyone suggest how I might be able to do this please?
I know I could just type in something like:
<TD>00:00:00 AM</TD> manually, but I want it to go in via a loop so I can compare it against data that will eventually be pulled from a database.
View Replies
View Related
I'm trying to increment between the end of lunch and the end of the day. The code below is returning a datePart of 13 instead of 1 (for 1:00:00 PM) and 14 instead of 2:00:00 PM etc. If response.write just counter2 I get a real hour. how can I return the actual hour datePart?
lunchStart = "12:00:00 PM"
lunchEnd = "1:00:00 PM"
dayEnd = "5:00:00 PM"
counter2 = cdate(lunchEnd)
while counter2 >= cdate(lunchEnd) AND counter2 <= cdate(dayEnd)
response.write datePart("h",counter2)
counter2 = dateAdd("h",1,counter2)
wend
View Replies
View Related
Does any one know how I can use DATEADD and COVERT in the same select statement for retrieving data from a smalldatetime field?
I want to retrieve a date, add a year to it, then convert it to dd/mm/yyyy format without the time showing. It works seperatly EG:
convert date - SELECT adId, CONVERT(CHAR(11),datefrom,103) AS datefrom1 FROM ...
Add date - SELECT adId, DATEADD(year, 1, datefrom) AS dateto FROM....
How do you combine the 2 statements? I have been going slowly mad trying to figure this out
I’m using ASP3.JS and MS-SQL db
View Replies
View Related
What's the difference between private and public functions in ASP? When should I use either?
View Replies
View Related
I am using a simple guestbook /portal and i want script to send mail to the thread owner when someone reply his message.
this is the send message code ....
View Replies
View Related
Can I define a function inside a function. e.g;
function abc()
function xyz()
....some code.....
End Function
End Function
I googled this but can't find any related topic.
View Replies
View Related
I want to use the instr function, but return results from it depending on surtain functions, I can't realy explain so I'll show my example:
I have a string in wich some word I want to find might be in diffrent Capital Letters order, I want the Instr function to return all the values of the place of that word (avcourse I'll run a for and increase the starting point of the Instr func until it returns 0). The instinct thought is to use the Lcase or the Ucase functions, but in this case I don't know how to use them. In the same Idea I wanted to use the Instr Func with the trim Func, But Its realy the same principle if I just understood how to do so.
View Replies
View Related
I have a form on my asp page that sends data to an emailing script. I am working with other peoples code which is causing a lot of hassle. Is there any way of sending a Bcc address command from the form rather than the emailing script?
View Replies
View Related
I wanted to know how I should go about doing this. I have this query:
SQLmax="SELECT Max(OrderNumber) AS intTotal FROM Status"
Which gives the Max(OrderNumber).Say in this case it is giving out put as 37.
Now i want the output to be displayed 38,which can be done by adding 1 to Max(OrderNumber).
Should i get this by doing this way?
var=RS(intTotal)
var=var+1
Response.WRite var
Is this right?
View Replies
View Related
Im using this code to pass a value to a variable:
<a href="Artists.asp?cat=<%=Server.URLEncode( rsuser( "art_Artist" ) )%>"> <%=rsuser( "art_Artist" )%></a>
How do I add another value to this link with the variable name catArt so that I can add:
?catArt=<%=Server.URLEncode( rsuser( "art_Artist" ) )%>
View Replies
View Related
what do you think is the best way to implement an "add new row to table" functionalilty?
am using asp(obviously )im currently using document.createElement with javascript, but im having a hard time retrieving the data.am also thinking if this is really the best way to do this.or if this would work with all other browsers other than IE...
View Replies
View Related
how to add a password to using this connection string
<%
set conn = server.createobject ("ADODB.connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("dat48372.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
SQL = "SELECT Price FROM DABRadios WHERE (ID LIKE 6)"
rs.Open SQL, conn
showall=true
%>
View Replies
View Related
i have a id1 field which has data like this 002,003,004 and i have to increment it by one when i add a new customer so this is what i do
Set rs1 = Server.CreateObject("ADODB.Recordset")
sql1="Select Max(id1) from table2"
rs1.Open sql1, Conn ,2,2
maxid=rs1(0)
so i get the maxid for example as 003. the next record will be added and it should be 004 and i do it in this way maxid= maxid+1
but when the record is added the id1 field has a value of 4 instead of 004
View Replies
View Related
Say I have to different recordsets that have the fields:
rsA.Fields.Item("A").Value ,rsB.Fields.Item("B").Value
How would I add those to fields? It may be my inexperience but when I
tried something like
rsA.Fields.Item("A").Value + rsB.Fields.Item("B").Value
didnt work because one of the fields was a empty value. I have about
6 fields i need to add together if a value exists in any of them.
Suggestions?
View Replies
View Related
I want to fix this problem, i dont no how. Bassicly there is blank data appearing in my database, for no apparant reason! Code:
View Replies
View Related
How can I add a new user on my server using ASP?
User example: myserver/user1
View Replies
View Related
I'm new to ASP and a few querys
I have created my database in Access with the following fields
StockCode (Text Box, Primary Key)
Item (Memo)
Price (currency)
Picture (memo)
OnOffer (Yes/No)
and I know that access table cannot have a picture in it, only a access
form using OLE, but how do I get my asp page to display a picture for
every record? The picture would be a picture of the product with the
Stockcode as the filename - m001110.jpg?
View Replies
View Related
I have an ASP page with a table that fills with records from a loop. Every
row gets a link to another ASP page with data from the row. The link is
written as <a href=newpage.asp?value1=xx&value2=yy .... and so on.
Now I try to let the user specify a number that should be sent to the other
page. But I do not want to clutter up every row with each an input field,
so I thought instead I would place it above all the data rows. When the user
clicks on the link, I want to include the input field to the querysting. The
problem here is that I cannot figure out how to refer to the name of the
input field.
View Replies
View Related
I have just finished building my first shopping cart in asp and MS Access. Originally the shopping cart was to be built for products with no size and colour, however as usual the goal posts have moved and I now need to incorporate a size and colour option for each product. Could anyone explain to me how I can go about doing this i.e. adding the different sizes and colours in the admin website and then linking them to a specific product when it is displayed on the products page? I know they both need to be in a dynamic drop down box when displayed on the products page within the shopping cart, but I am just wondering how to read the correct values out from the table depending on which product is being displayed. I have a normal products table at the moment with general fields i.e ID, name, description etc.
View Replies
View Related
I have a web page hosted by server1. I need to add a link to a web page hosted by server2. This part is simple. However, I also need to give the linked web page the user id for the user that was validated in server1 (it's in a session variable).
At first, I thought the following would work:
mywebpageonserver1.asp:
Response.AddHeader "MYUSERID", "whatever"
Response.Redirect "http://server2/mywebpageonserver2.asp"
On server2, mywebpageonserver2.asp:
View Replies
View Related
i have a page that enters numbers stored in different values e.g monday tuesday wednesday thursday friday into a database. is it possible in asp to add those values up and store the added up value in a seperate field in the database
bascially
total =monday+tuesday+wednesday+thursday+friday
How would i do that in asp.
View Replies
View Related
I am using Dreamweaver MX to create ASP and MS SQL Server for database. I got a few fields like Value1 - Value5. So i have create the recordset of the 5 fields and i am extracting the total count of each field. Now i got 5 recordsets showing the total of each field. So is it possible to add the value of the 5 recordset together into one value? And is it possible to use the value of the recordset to do some simple math addition, subtraction, multiplication and division?
View Replies
View Related
I need to add a ppicture to my Database.. The table is accessed through ASP Recordset but having troubles trying to insert an individual picture to each record?
View Replies
View Related
I have a table with 2 fields, name and value
I need to be able to add multiple records quickly, for example I need to add
name value
abc 1
abc 2
abc 3
abc 4
abc 5
abc 6
etc etc, does each record have to be added separately, or is there a way I
can add a chosen number of records, lets say 10, and have the value field
increase by one each time?
sometimes I might have 30+ simple records that need adding quickly, and each
time the first records value will be one, and each record after will
increase by one, is there a way to solve this problem or does each record
have to be added separately?
View Replies
View Related
i have a variable in a database that is looping that outputs numbers like:
1. 45
2. 34
3. 94
4. 34
But are all in the same variable:
DoDateTime((rsBoxEdit.Fields.Item("").Value), 3, 2057)
How can i make it so that it loops that variable and adds the numbers up and outputs 1 variable called total or something?
View Replies
View Related
I have a drop down which has numbers from 1 to 25
When a user selects 3 he will see 3 first name textboxes and 3 last name textboxes
the user fills them out and hits the submit button
three records are added to the table
i have a for loop for adding records
Here is my code:
View Replies
View Related
