I am creating the following random number including date and time !
Now it creates fine but leaves an annoying space and the I want to get rid of AM / PM
as follows
822200753131 PMNXM7EMT3VY2817656XK1
id like
822200753131NXM7EMT3VY2817656XK1
here is the method Code:
If I replace "a" with "b", and then I replace "b" with "a", shouldn't I get the same result? That is what I am trying to encode and decode with Replace() function, but it is giving me different things when I replace and replace again. Here is what I am talking about: Code:
View Replies View RelatedI 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.
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:
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
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:
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 RelatedHow will we convert the system date & time to other timezone for eg: Eastern Time zone using ASP?
View Replies View RelatedWhen 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. ?
Any some tools or sample codes drop down asp script execute time and
database connection time ?
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.
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.
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.
some text is coming out of the DB with different urls in it, i want to delink it (like href="#" or something), how do i do that when i don't know what url is coming out?
View Replies View RelatedI've got a function that I use to replace ' marks so the page will insert properly into a database - typically I use .Code:
whatever= request.form("whatever")
whatever = replace(whatever,"'", "''")
However, I've got some code that I unfortunately inherited from someone else that I can't get the replace to work:Code:
call buildquery (colq,valq,retq,"whatever")
colq = "(" & colq & ")"
valq = "(" & valq & ")"
ssql = "insert into table_name " & colq & " values " & valq
I was trying to do something in the call buildquery line to add a replace, but that doesn't seem to work.
How do I take out double quotes before writing to database? As doing ,""",""e;" created an error.Is it something like ,chr(34),""e;" which I sort of stumbled accross when I did soem google searching... But what and where do these chr(34) etc coem from?
View Replies View RelatedI have lots of textbox that needs to have data entry. Is it possible for me to replace the tab key to return key that transfers the focus from one textbox to another? And also, how to submit the form after all textbox have values?
View Replies View RelatedI come across this often
PHP Code:
Replace(rs.fields("Headline_f"),"''","'")
Where rs.fields("Headline_f") is actually empty.
I usually use
PHP Code:
IF NOT isNull(rs.fields("Headline_f")) or rs.fields("Headline_f") = "" THEN
Headline_f=Replace(rs.fields("Headline_f"),"''","'")
END IF
Is there a better way to handle this?
Even though I ask customers to enter there phone number like xxx-xxx-xxxx they some times don't. go figure:
I create a text file thats used by the factories EDI system and the number needs to be xxxxxxxxxx. I'm using the code below but what if they enter their number xxx.xxx.xxxx OR (xxx) xxx-xxxx etc. You get the idea.
strPhone = Replace(objRS("DayTimePhoneNbr"),"-","")
Does some one have a small chunk of code to help me replace additional chars?
My form gets populated from an access database. Now in the database there are fields containg <br>. While in a normal page everything works as it's supposed to, in my listbox the <br> shows as it is. What I would like to do is replace it with a space so I've used this:
<option value="<%=(rsProducts.Fields.Item("CatNum").Value)%>"><%=replace(rsProducts.Fi elds.Item("NotesR").Value),"<BR>"," "%></option>
but it doesn't seem to work.
What exactly am I doing wrong here?
I've tried EVERY way i can think of to do this replace function, basically when i go to insert "Do's and Dont's into the database it cuts it off at "Do" because of the ' now ill show you my section of code that i have it in currently:
curdescription = trim(replace(arrTemp(4), "'", "''"))
I have it this way and it doesnt work, and i even had it
curdescription = trim(arrTemp(4))
curdescription = replace(curdescription, "'", "''")
i use the URLencode function and it changes my form text to: this+is+it%21
ok, this is good, but when I use it in a URL, it includes "this" but then the link dies and the rest is just text, the user must then copy and paste the whole address in the browser. Anyway to get around this?
what's wrong with this string?
" WHERE InStr (" & request("Field") & ", " & chr(34) & replace(replace(request("SearchWord"),"*","%"), "'", "''") & chr(34) & ") > 0 " & _
i have some sql data that has " and ' in it. can someone tell me how to do a replace on those so they display correctly?
View Replies View RelatedI am not sure if this is a question for this forum or the IIS forum but here goes. I have a dedicated server on which I am hosting about 80 websites at the moment, all of which have been created by copying a template site. All of these sites have an identical structure and are located in the same directory on the server, C:Inetpubvhosts. Several times when I have needed to make an adjustment to the sites I have to go into the remote desktop connection to the server and go site by site, copying and pasting files. For example, as each site has the same pages, ie., map.asp, sometimes I make a change to that page and have to copy it to every site. Could I write some sort of script using the FSO and execute it from one site and have it loop through each site on the server making the neccessary change(s)?
View Replies View RelatedDoes anyone have a snippet that will replace ALL HTML formatting BUT
leave the <p>'s and <br>'s ??
my replace is not working
Shipping News ...i don't want news word ..mean i just want
Shipping
Code:
<%=Replace(rs("name"), "news", "")%>
Can someone help with an error? It's a StoreFront store. right after the credit card screen is gives me the error. I get the following:
Microsoft VBScript runtime error '800a005e'
Invalid use of Null: 'replace' /ssl/SFLib/incGeneral.asp, line 85
--------------------------------------------
84 Function makeInputSafe(str)
85 makeInputSafe=replace(str, "'", "''")
86 End Function
-------------------------------------------
I'm trying to use the replace function to change a variable ie like this:-
replace folder_old, txtOldFoldername,folder_rename
folder_old = c:DocumentsRoot_Testob
txtOldFoldername = bob
folder_rename = newfoldername
all i want to do is to beable to change the name bob to the new folder, is there a easier way to do this or am I on the right track. if i do the replace like this replace(folder_old, " & txtOldFoldername & "," & folder_rename & ")
i get this error:-
Cannot use parentheses when calling a Sub
I been trying to figure out the following. I have a string of 9 numeric characters such as 000982675 and 001000510. The problem I have is in the following code:
View Replies View Relatedi can get the replace function to work in rs return but i'm returning a qs value and it's not working can someone tell what code will work with a qs.
View Replies View Relatedhow can i replace all single quotes in a string to double quotes:
Replace(strLog_text, "'", """)
however, this doesn't work, as you might expect.
I'm trying to replace the pipe character with a null value? Is that possible?I'm trying the following:
Replace(Request("strategyA"), "|", "")
I can't get it to work.Is my syntax incorrect?