I have a field with datetime values like below LISTING 1. me write code strip the time part so only values like "7/15/2005" will be left.
Note - We must be able to strip dates with double digit months and days, so
i can't just use the right function with a hard coded parameter. Code:
How can I strip the time part from the Now()?
View Replies View RelatedCould someone help me work out out a way to either convert a smalldatetime
value from my database(access) to a normal date with out the trailing time.
Is it simple matter of using FormatDate or does one need to do string
maniupulation?
Current
9/13/2003 11:36:00 AM
What I want:
9/13/2003
i have db in MS SQL Server 2000.
i have a field in a table as datetime.
but i want to display only time from that datetime field.
i tried using time(rs.fields("time_in"))
i get this error
Error Type:
Microsoft VBScript runtime (0x800A01C2)
Wrong number of arguments or invalid property assignment: 'time'
how can i achieve this??
Anyone know of a good routine for stripping out HTML from a string?
View Replies View RelatedI'm using XMLHTTP to perform a simple screen scraping job.
When I try to have it "scrape" lines with embeded CSS declarations, it
renders them incorrectly, stripping the leading period. Consequently, my CSS
doesn't work.Here's how I'm calling it, but I don't think my implementation is the
problem.
Dim srvXmlHttp
Set srvXmlHttp = Server.CreateObject("MSXML2.ServerXMLHTTP")
srvXmlHttp.open "GET", TearURL, false
srvXmlHttp.send()
If srvXmlHttp.status <> 200 Then
Response.Write "No Server Response"
Response.End
End If
Dim strRetval5
strRetval5 = srvXmlHttp.responseText
I have an ASP page which has a form for user to input some information and it gets stored in an Access database. The problem i am having is when a person enters a name with a special character, like Macy's, it gives a Jet database error.
What i am looking for is for a way to remove special characters from the form field in question, like apostrophes, when they tab to the next field. So if they input Macy's, when they go to the next field the previous field gets updated to Macys instead.
We have an unusual situation at the USC School of Medicine; we have to
covert every Web page to a template. The template is too wide to print and a
lot of our students print lectures, notes, etc. We thought we could keep to
the template and draw in the content from other files by using includes. BUT
these files are HTML files and therefore, have Body commands in them. If
this could work, we could put a printable link back to the other page and it
would print. Seems like a great solution except for the extra body commands.
We are using ASP for our scripting.
1. How much of a boondoggle will it be if the files have two body commands
in them. How many browsers would it break?
2. Is there a scripting way around this without creating some objects?
3. Is there something out there -- shareware or commercial -- that would fix
this problem.
4. Could something be done about this using pearl, for example?
We'd really like to do it this way because we can have the users create the
content, use the same file names all the time, thus overwriting the old
file, and the user would never get a chance to screw up the template.
Is there a string function to strip the file extension from a variable in ASP? If not any suggestions as to the best way to approach this?
View Replies View RelatedI'm looking for a easy way to pull all the zeros out of a variable. They can be leading, trailing, or in the middle. I just want them all gone.
View Replies View RelatedThe following pattern is used to strip HTML tags from a string. I need to remove the tags only if they contain a colon. Is it possible? How can I modify this regexp pattern to match only if a colon exists between the "<" and ">" ? Code:
<[^>]*>
I think a regular expression maybe the solution to the problem I have. My problem is I am pulling a list from a database which I want to list alphabetically. The problem is, the records are stored with a number before them:
eg."762348 - RecordA" --> So I want just the "RecordA" bit so I can list alphabetically.
What I want to do is strip off everything at the beginning up to the first Alphabetic character. Is a regular expression the way to go?
I just want the raw text of a string so I can display a preview of what is in the file.
View Replies View RelatedI have been trying to figure out how to get a function to strip html tags from part of an html file. The way I need it achieved is as so: Code:
<% strOutput = stripHTML("<!--#include file=includes/MyInclude.asp-->") %>
The included file is html-rich, and if included in default.asp, it displays as such. However, as I am attempting to make my website accessible, I wish to be able to strip out the html tags on the included page dynamically.
I have used the following function (and have called it with the above statement) but am getting an error in my functions.asp file: Unexpected quantifier. This is on the line that states Code:
I am designing a page in ASP and using MSSQL for the database. I want to use an if statement saying that if the field is empty, display something, else display something else.
However when i write:
Code:
If rsBoxEdit.Fields.Item("bFinishTime").Value = "" Then
response.write("Edit Finish Time")
Else
response.write("Finish Time Already has a Value")
End If
It say "Finish Time Already has a Value" when the field is blank.
The database saud the field is <NULL> if this helps and the field type is set to datetime.
Also if i put
Code:
If rsBoxEdit.Fields.Item("bFinishTime").Value <> "" Then
response.write("Edit Finish Time")
Else
response.write("Finish Time Already has a Value")
End If
It STILL says "Finish Time Already has a Value"
If someone could help that would be great....
I am calling a recordset from sql which happens to contain one column that is a datetime in the format: DD/MM/YYYY HH:MM:SS. So when I call that column from the db, it displays in the same format within my page.
However, I would like to be able to display the datetime as part of my recordset, but in a more aesthetically pleasing format (i.e: Sunday 1st May 2000, 7.23PM)
I have tried using the formatdatetime() function along with my rs, but this causes syntax errors. I know this is probably dead simple, but I don't get it!
I am using mysql as my database and which to use a datetime field, for both displaying the data and time and using it to sort the recordsets.
And although when you look at the Db it shows the data and time like this
yyyy-mm-dd hh:mm:ss
however if you simply display the field it displays like this
mm/dd/yyyy hh:mm:ss am (or pm)
I want to sort the data out so that it displays dd/mm/yyyy and there is no time, i can do this but wanted to know if there is a better way of doing it
My problems being I first have to work out if the date is below 10 then us a split function according, then the same with the month, then i have to use a massive if statement, to get it to display in words, and then I have to us the queries before so i can split the year, even if i use to fields in the db to store time and date i would still have the same problems, what is the best way to do this, Plus i may have more than one record to do, will this make a big different in processing my page if i say have 20 records to do.
and just to make sure is the timedate field suitable to sort my record sets out.
Once i inserted "date()" in date field
This worked fine for 3days
but on the 4th day I got this error
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
Again I changed the format of date to oracle DB format
and Ive solved the prob
I just want to know why I got that error
In one of my asp webpage,i am fetching the data from a XML file and which indeed is fetching data from mySql database.
Now the date time format i am getting in from XML is "Wednesday, October 24, 2007, 2:03:42 PM" and when i display that time in my asp webpage then it shows like
"Wed, 24 Oct 2007 19:03:42 +0000"
I have a shopping cart that logs the datetime when a user logs in...
I want to run reports to see who all has been on in the last 90 minutes (or whatever my script specifies)
The problem is that I cant get the select statement down...
I would think it to be something like:
SELECT CompanyName, LastLoggedIn from LoginDB where LastLoggedIn > (LastLoggedIn -90m)
And obviosuly that doesnt work as the datetime field date is in the format:
1/21/2007 2:20:00 PM
I'm trying to isolate just the m/d/yyyy part of a datetime string like
below. Can someone tell me why my string modification fails on some dates? I
thought byb basing my code on where the blank space between the date and
time would work. my code works on some dates that are single digit days and
months.
mydate = "12/30/2005 10:00 AM"
newDate = Left(mydate,len(mydate)-Instr(mydate," "))
response.write newDate
' trying the return 12/30/2005
I have a form that submits the date to SQL database. problem is the date keeps getting messed up, such as:
25/12/05 is in the db as 05/12/2025
I live in the UK hence dd/mm/yy.
I have tried using Code:
<% LCID=2057 %>
at the top of the page but still the same.
what formate does your variable have to be in to search a sql datetime type i am trying mm/dd/year?
View Replies View RelatedI just want datetime to be displayed as it is displayed in codecomments forum
format is like
mm/dd/yy hh:mm
I am trying to do an INSERT using the Now() function to populate a MySQL DateTime field. It is giving me the following error:
Incorrect datetime value: ‘11/20/2005 4:56:39 PM’ for Column ‘DateAdded’ at row 1.
The SQL works if I remove the DateAdded part so I assume the SQL statement is good. The reading I have done on MySQL shows examples using the Now() function inserting into different date/time MySQL data types so I don’t understand why my SQL is not working. I am trying to use the DateTime data type… basically, I want to keep as accurate of a date time as possible.....
This is part of an expense reporting application that I'm trying to recreate for a client. Client logs in and is shown a date. The date shown lets them know that they are entering info for the month after their last report (which is why we can't use Now(). The months have to be entered sequentially.This part is working fine.
I have a hidden field that holds the same date variable that I need inserted back into the same db. When they submit the form, they get a results page telling them everything went through. Everything is being inserted correctly to the database except for the datetime. It gets inserted incorrectly like this 0000-00-00 00:00:00. Meaning, it's zeroed out everytime even though the hidden field is pulling the date correctly.
how can i only display the hour / minute portion when i do (timestamp2 - timestamp1) in asp. When i display in asp, it gives me some funky number, probably it is the representation of timestamp value. It works in query analyzer, it gives me some date but the time is write though.
View Replies View Relatedneed to subtract one date from another to show how long a user was logger in for. i.e.
<%=(rsDriverLogin.Fields.Item("OFF_DATE").Value)%> minus
<%=(rsDriverLogin.Fields.Item("ON_DATE").Value)%>
The values in the sql OFF_DATE and ON_DATE fields are stored as 13/06/2006 19:01:28 . Can either be done on the ASP page or in the db itself, doesn't matter which.
I have a client who does not like the uppercase PM AM that is passed from MS SQL I would like to format that to am pm lower case. my code is Code:
<%= " " & TimeValue(rsDT("StartDT")) & " - " & TimeValue(rsDT("EndDT"))%>
this returns
1:00:00 AM - 1:00:00 PM
I am trying to use the datetime function. I am using Access as my backend database if you are wondering. I am building a program where someone can keep track of the software in our department and she wanted it to be able to email her when the software has been checked out for over 7 days.
How to do this or where I begin? I am not too familiar with how one would add to dates in ASP.
i want to query the datetime field. need some guidance. Intention is to "Select * ...... Where datetime > 1st Jan 2006 and datetime < 31st Jan 2006" . My datetime is in "mm/dd/yyyy HH:MI: SS" . i understand that i can't put the query as in "where datetime => '01/01/2006' and datetime <= '01/31/2006'
i need to convert it to varchar as in "where convert(datetime, convert(varchar(10)...". Am i right ? Any other way to achieve that? What will be the correct query ?
I am trying to use the datetime function. I am using Access as my backend database if you are wondering. I am building a program where someone can keep track of the software in our department and she wanted it to be able to email her when the software has been checked out for over 7 days. how to do this or where I begin? I am not too familiar with how one would add to dates in ASP.
View Replies View RelatedI have a date/time field, and I have an int field. When the user submits the form, I want to do date/time field - int field. I want to CAST the int field to a hour / minute field. Is that possible? For example: (4/7/2006 12:13:15 PM - x/x/xxxx xx:15 (min):xx
Is there a better way to do this besides this?