Date (easy One)
<% Response.Write "" & FormatDateTime(now,2) & "" %>
Gives me the date in MM/DD/YYYY. How can I reformat this to DD/MM/YYYY?
ADVERTISEMENT
Easy Date Handling
I'm working on a system that requires alot of date handling, and i'm getting pretty tired of doing custom calculating when modifying dates, so i hope someone would be able to help me. Is there any easy way to do re-calculating of dates? such as adding 2,11
or 36 months to a date, and have it automatically checking whether or not it should increase months or year, and by how much?
Like, if i have to add 11 months to the date right now, i have to check which month it's in to see whether or not i could just take one month lesser the next year and so on.
Easy Date Formatting Question
I have a variable that represents a standard mm/dd/yyyy date , but i want to change it to just October 6
''''
datepart("m","d" , mydatevariable)
'''''
....doesnt work.
Easy Asp Question?
I need to do a string comparison (in asp) that checks to see if "META" is contained somewhere/anywhere in the string. Can anyone tell me the syntax for doing this?
View Replies View RelatedEasy Solution
I'm hoping for an easy solution to this that I'm not seeing that
someone more experienced will.
All I want to do it mark an option tag as selected....
<%
hourCounter = 1
Do WHILE hourCounter <= 12 %>
<option value="<%=hourCounter%>" <%If hourCounter =
hour(rsCalendarEdit("fld_calendar_DateTime")) Then Response.write "
selected" End If %>><%=hourCounter%></option>
<% hourCounter = hourCounter + 1
Loop
%>
The trouble is if the time is "PM" I have a problem as you can see. Is
there a method or property here I can implement that I'm not seeing?
Code Easy
why asp is retarded compared to some other server side scripting languages? or am i just the retard? Code:
<% If Session("auth") = "1" And Session("userid") <> "" Then %>
// Show user information box....
<% Else %>
// Show login form....
<% End If %>
in my head, what i just wrote should equal something like if the session variable "auth" equals 1 and the session variable "userid" does not equal nothing, then do this.well, i haven't set any session variables, and it's processing the chunk of code right after the above if/then. either shows a user information box or a login form.it shows the user information box, instead of the form.
really baffles me considering i haven't set any session variables. i guess this is why i like php better, but i'm trying to get a grasp on asp, it just seems to hard to do something simple. can anyone tell me why that code is returning the wrong block of code?
Easy ASP Query
Using ASP & Access. So I am having a total brain-fade. I am trying to pull up data out of a table. But I want a "select all" option. What should the value be for the "select all" option of the form? What should the WHERE statement be in the query?
View Replies View RelatedEasy One Display The First 2 Numbers
<%= objrs ("age"), 2)%>????
how do i get it to only display the first 2 numbers?
Convert An Easy Php Code To Asp
I am having trouble with our server host they are saying that the php
upload limit is 20 mbs but using the code below with my flash file I
can only get it to do 8mbs. I know that asp is allowing for up to
20mbs though so I was hoping that someone would be able to change this
code to ASP(I am not very good at either php or asp). I think that
should be pretty easy:
<?php
if (is_uploaded_file($_FILES['Filedata']['tmp_name'])) {
$uploadDirectory = "uploads/";
$uploadFile = $uploadDirectory .
basename($_FILES['Filedata']['name']);
copy($_FILES['Filedata']['tmp_name'], $uploadFile);
}
?>
Easy String Question
I am just trying to take pieces out of the sql statement individually and display them. I get this error:
ADODB.Recordset (0x800A0CC1)
Item cannot be found in the collection corresponding to the requested name or ordinal
There is data there in the table and I'm not sure what's going on. Code:
Easy Site Creator
Im making an asp website for a rotary club what would be the best script to create a website something like a CMS without all the forums and stuff.
Easy Graph In Asp Or Html?
What is the easiest way to create a graph in either asp or html code? Is there one? I am doing several SQL queries the result of which I will give me a number. I need to put this number into some kind of graph (bar graph) on the page. THe number will vary so it must be some type of dynamicly created graph.
I would prefer to not use a thrid party tool to do this if possible ......
Is There An Easy Way To Retieve The Key Value On INSERT
Basicly I have a table that gets contact info and stores it from a form AND emails me...
Problem is I want to just email a link to the ContactInfo.. which should be referenced via the unique PK so whwn i view it, it would be nice to reference the row just inserted...
ala view.asp?emailpk=141
figured there woudl be something like recaffected out there.
MVP Or MVC For Easy Migration From Winform To Asp.net
I need to write an application which should work as web application (ASP.NET) and it should have its counterpart for winforms - (they would do the same thing). My question is... what kind of pattern shall I use (MVP or MVC) for writing these apps to minimize overhead of rewriting code (e.g. I'll start writing winform app and then create similar web app )?
View Replies View RelatedShould Be An Easy Form To Mail Question
I've searched the forum for the answer to this..it's probably on here somewhere but in a different guise to my particular question and I don't know enough to figure it out.
If I have a basic form to mail ie
strEmail = request.form("Email")
and
mail = "me@me.com"
can I simply do this to get my form to be sent to 2 email addresses?
mail = "me@me.com, you@me.com"
ObjNewMail.Body Question, I'm Sure Very Easy To Fix??
I have a "tell a friend" form and the backend sends the information just fine, however in the bodytext I want the "comments" box text to be added to the e-mail. User fills in his name, his email, friends email, comments box (name=message) and the email is sent except the text from the comments box. My code for the body tag is:
objNewMail.Body = sendersName & " (mailto:" & sendersEmail & ") thought you would be interested in this article " & vbcrlf & vbcrlf & vbcrlf & "Link:" & vbcrlf & request.ServerVariables("HTTP_REFERER")
How can I insert the comments box text in there?
My thought was:
objNewMail.Body = sendersName & " (mailto:" & sendersEmail & ") thought you would be interested in this article " & vbcrlf & vbcrlf & message & "Link:" & vbcrlf & request.ServerVariables("HTTP_REFERER") but it does not work.
Is There An Easy Way To Find Out If All OBJECTS Are Closed?
I have several pages ( ASP) that were working OK on NT4. We moved it to Server 2003. At random , it appears that the Server.CreateObject fails.
I've looked through the code and it looks OK. Is there an easy way to make sure I have Closed all CONNECTIONS RecordSets etc.
Dynamic Menu Best Easy Methods
The database is used for referencing filename, there located folder, id, order shown, but also there are some fields say "location_1" up to "location_4" which have a 0 , 1 or 2 in them. 0 means that file not needed for that section. 1 means needed for that section, and 2 means mandantory (must be seen before exit).
firstly selecting a location from a html radio box, drop down menu (not decided yet) will return whats needed so not showing pages what aint needed and wasting time.
Here it is though in order on the left i wish it to build a menu, but more advanced than plain links would be good. drop down like windows explorer etc. Code:
How To Create This System Of Easy Form?
i would like to create the following one, but nor I know as. One index.asp that db catches one information as heading, hour of entrance and station time and shows in the page index. An example, let us assume that now they are 23:00, then the shown information will be inserted in the page index.asp in accordance with the current hour.
If it will have something registered in cadastre in db that it starts the 23:00 and it finishes the 01:00 will be in index, passing the hour it leaves and it enters another message with programmed hour.
If I have in db a message that would have to be shown of the 09:00 the 11:30, and now I am 11:20, the system analyze and show the information, until he is 11:31, when then I enter another one, and thus successively, they are menmsagens that in accordance with enter the hour of the server.
Easy To Setup Web Chat For Windows?
i'm looking for a easy to setup web chat script that i can install on IIS? if someone can point me in the right direction it woudl be great, i download a couple cgi scripts but couldn't get them to load.
View Replies View RelatedIs There An Easy Way To Find Out If All OBJECTS Are Closed?
I have several pages ( ASP) that were working OK on NT4.
We moved it to Server 2003. At random , it appears that the
Server.CreateObject fails.
I've looked through the code and it looks OK.
Is there an easy way to make sure I have Closed all
CONNECTIONS
RecordSets
etc.
Is There An Easy Way To Prevent Duplicate Records Being Added To A Access DB
I am adding simple records to a fairly simple access database with the following code
rsEntry.Fields("Player1") = ShortName(Player1)
rsEntry.Fields("Player2") = ShortName(Player2)
'Write the updated recordset to the database
rsEntry.Update
rsEntry.Close
adoCon.Close
Set rsEntry = Nothing
Set adoCon = Nothing
How can I SIMPLY :-) prevent duplicate records from being added? I know I can set the index property on the fields but that mean handling the errors - not sure how to do this.
OR I could write the code to seach the DB before update - which may be the only way :-(
Is there a simple way?
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:
Select Statement Comparing Date() & Date Field Of Database
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 RelatedDate Problem (wrong Date Inserted When Updating)
sql = "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
Getting Week Start Date And End Date By Entering Weeknumber
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.
Compare Server Date With Date String
I am trying to compare two dates. My problem is no matter what the value of mydate, it is still fall in the first IF statement condition (even if mydate is 10/10/2004). Any advise for this matter?
mydate = "6/6/"&year(date)
IF date() <= mydate THEN
response.write "first half of the year"
ELSE
response.write "second half of the year"
END IF
Comapare General Date With Short Date
I am trying to construct an SQL statement that can grab all of the entries out of a table, where the Date field consists of today's date. The Date field is called 'DateTime' - and it is in a General Date format (DD/MM/YYYY HH:MM:SS). I obviusly want to use an SQL statement like this:
SELECT * FROM tblExample WHERE (DateTime = Date());
However, that wont work because Date() will only return a short date (DD/MM/YYYY).
Date Picker - Making The First Date Five Days Away
I would like to modify this so that the first available date that can be selected is five BUSINESS days out. The script only shows Mon-Fri so if the date is Tue Jul 13, 2004, Tue Jul 20, 2004 needs to be displayed. Code:
View Replies View RelatedCompare 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.
MS SQL Database Field Date Comparison To Date()
In a connection string, I have the following:
sql3 = "SELECT DISTINCT State FROM Property Where TypeID = '" & srch_cat & "'"
In the database, is a field called expiredDate I am trying to show only records whose expiredDates are greater than todays date, but I am messing up somewhere. The values in the fields are as this: 3/7/03 (or something like that...no time is added to it)
Comparing A Date Field To A Date In A Form.
"SELECT id, title FROM Businesses WHERE Date_Added >= " &
Request.Form("Since_Date")
This SQL string returns all records from the table Businesses and does
not seem to be able to recognise Request.Form("Since_Date") as a valid
date. The Since_Date value is entered into a form field as
"01-Jan-2005" and appears to be treated as a date; when viewing the
SQL statement(with a response.write) it shows the date as 1/1/2005
even if it is entered into the form as 2005/1/1
I've also tried CDate(Request.Form("Since_Date")) with no luck,
although this was the treatment that worked when the SQL statement was
running in an .idc file.
Date_Added is a regular DateTime field in an Access 2000 database
Any suggestions please ?????
ASP Date: Get Records With Date = Today (SQL Server)
I'm trying to get all records from my SQL Server Database with
"DeadlineDate" = today (not today - 24 hours).
All records has a field called "DeadlineDate", and the date is stored in
this field like this: 13.08.2005 07:00:00
I dont care about the hours (Ex: 07:00:00), just the date (ex: 13.08.2005).
This is the SQL I have made, it gets all the record with the date = today -
24 hours... but that is not what I want.
sql = "select title from tblProject where (deadlineDate BETWEEN DATEADD(d, -
1, GETDATE()) AND GETDATE())"
How can I get just the records that has the date = today's date??