is there a way to 'force' ASP date function to return date in a given format; I mean, my need is to force 'date()' function to give me system date in italian format instead of english (O.S. is in english as well as locale settings for IIS anonymous user); is there a directive or something similar to put in ASP code?
View RepliesWhen should we use 'return' in a function to return the result versus 'FunctionName = result'
View Replies View RelatedCode:
function findcinemaid(nameofthecinema)
findcinemaid = "select cinemasid from cinemas" &_
" where brand = 'tgv' and cinemaplace2 like '"&nameofthecinema&"'"
set cinemaidfound = objconndb.execute (findcinemaid)
optainedcinemaid = cinemaidfound("cinemasid")
end function
tgvcinemanamexcel = "[1u_f$]"
cinemaname = "ONE UTAMA"
findcinemaid(cinemaname)
response.write optainedcinemaid
if I put response.write inside funciton it will display the cinemaid properly but if I put it outside , it wont display
im trying to create a function that accepts a sql statement as a parameter,
makes a db connection, returns a recordset, and inserts all items from the
recordset into a data dictionary - then i want to set the value of my
function equal to my newly created dictionary of items from the recordset -
this is where im having a problem. is it possible to set a function equal
to a dictionary? i cant seem to make this work and it seems that this
should be possible.
here is some sample code:
i am trying to write a function which will add an entry to to a table in my DB
and then return me one of the values of the newly added entry.
For e.g. I use the function to add a new Order Entry into the DB, but i would also
like the function to return me the value of the OrderID field for the new entry. Code:
I need a VB function to return array of collections like
Private Type Employee
empname as string
address as string
salary as integer
deptno as integer
End Type
dim employees() as Employee
Public Function getEmployees() as Employee()
getEmployees=employees
End Function
I will call that function in ASP.This was not working any other method is welcomed.
Can anyone tell me why the funciton checkCode returning in the middle of the for loop breaks the for loop? ie. If I remove the section:
if checkCode("0011") = 1 then
response.write "<br />Passed submission of user code"
else
response.write "<br />failed submission of user code"
end if
from the code snippet below, then the code will successfully loop through and print out all the post var fields (there are in fact 4).
If however you leave this in, the function returning seems to break the for loop from continuing through all the other post variables after "user_code" Code:
How do I convert 12/15/1985 to 15 December 1985 format using classic ASP?
View Replies View RelatedI'm trying to display activities completed on the previous day.
I tried =Date() -1 but... I'm getting both the previous day's
and current day's completed activities.... I'm using Access/
MS-SQLServer... which I'm newbie with... I'm an Oracle type.
I would need a function in asp wich will show date like at www.sitepoint.com at last forum post's. It means function would look like:
function(date)
and print for example this:
before 2h & 14 minutes.
I want to insert the current date into a form field as a default text.However, when I use <%=Date()%> it insets the date in the format 6/9/2004.How can I get it to insert the date in UK format (dd/mm/yyyy) using leading 0's for single numbers, so I end up with 09/06/2004?
View Replies View RelatedI have a table in which i have a field dtmdatetime as date/time data type.I want to fetch the records of current date,since the filed in table is in date/time format,it doesnot compare the date i entered,bcoz i enter only the date not time.
View Replies View Relateddoes anyone know how to put the 'date()' into a text box.
View Replies View RelatedIs it possible to find out the date of a Monday from a given date. Here are to examples
The date is Thursday 5th of June the function would return Monday 2nd June. The date is Friday 13th June the function would return Monday 9th June.
i have a to find out if this can be done in a easier way . i am trying to add 5 years to the current date
so today is 08/11/2006
if i add 5 years
i want it to be 08/11/2011. so what i did was from current date get the mm/dd/yyyy seperately then added 5 to the yyyy . and then did a concat and got 08/11/2011 . is there a easier way of adding years to the current date.
How do I convert 12/15/1985 to 15 December 1985 format using classic ASP?
View Replies View Relatedhow do i display only the day using the date function.
View Replies View RelatedI need to put a date function into a textbox. The function is <%=date>
View Replies View RelatedIs it possible to change ASP's date function to a MySQL compliant (ie. year first; 2003/8/17) style without a lot of code?
Maybe I'm mis-guided. I have a website built in ASP and using MS SQL. I'm converting it all to MySQL, but I'd rather not have to rewrite all the instances where I do something like this...
ASP:
Code:
Query = "SELECT SUM(Total) AS Totals FROM orders WHERE create_date BETWEEN '" & date & "' AND NOW()"
Results in: Code:
Any function on ASP to format date on dd/mm/yyyy?
The format (VB) function does not work on ASP ?
Is there a way to output a date in latin american format?
You know the day first, the month second and the year last.
If I want a message to show on the 3rd Friday evening and Saturday early morning of each month, is there a better way than the code that I use...
aztime = dateadd("h",-2,now())
If (day(aztime) => 14 and day(aztime) =< 21) and ((varDayOfTheWeek = 6 and dhour => 15) or (varDayOfTheWeek = 7 and dhour =< 2)) then
my message here
end if
The only month it would fail in 2008 would be June, so I was hoping there is code that would just deal with the 3rd Friday or Saturday of the month.
Im working on a Year(Date) function right now, the output of that function is this "2005", my question is how can i change the format into this "05"
Function: Year(Date)
Output: 2005
Needed Output: 05
Does anyone have a date validation function that checks if the day month and year are all valid. For instance, if it's a non leap year and the date 29th Feb is entered?
View Replies View Relatedi need to retrive record form database for a particular DATE and particular name i have to pass date and name thro "form" then i have to display that particular record . how to proceed.
View Replies View Relatedi want to display the Week start Date & End Date with week number when i use:
select datepart(date,Pur_Date),sum(Amt) from Purchase where Pur_Date
between '01/01/2004' and '14/01/2004 ' group by
datepart(date,Pur_Date)
result should be displayed as:
week start date end date SumAmt
1 01/01/2004 07/01/2004 1000
2 08/01/2004 14/01/2004 20000
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:
What's the difference between private and public functions in ASP? When should I use either?
I updated to aspx last three month,after developing serveral
applications,Idecided to downgraded to asp, following is my reasons:
1.in ASPX,the page format is hard to control,in ASP u can change every html
as u like ,but in aspx, a aspx control decide the page format,and its hard
to change the format.
2.ASPX is said to be faster that asp, but it is based on too-often
communication back to the server,for example,u click a radio a button,there
is new page request, but in reality,such a communication is
bandwidth-consuming and time-consuming. the user only need to submit the
form, and the exchange between IE and Server was minimazed.
the Speed of ASPX is not useful for most sites, for bigger sites, the speed
increase is singnificant,but for small sites with less traffic, the speed of
ASP is quite enough.
3.ASPX is based on Object Orinted Programming, but in most small sites,
Procedure orinted programming is used, we never build objects, and POP is
more efficient.ASPX is for three-tiered structure with a single layer of
business logic component, but in reality, most of us used two-tier
structure,that is Presetation layer and Datalayer, we can layout the page
and change the database in a single page, quite effienct too.
I want to return a 404 response from an ASP script (IIS 5).
Response.Status lets me set the response string, but if I don't include any
HTML text myself, the result is an empty page.
Is there a way to 'redirect' it to the server's default 404 response, as if
the URI really doesn't exist, but without really redirecting it so the URL
isn't replaced in the browser's address bar?
I am trying to replace a huge chunck of code that currently I incorporate
with an #Include directive. The program rarely has to flow through that
code, so I thought it would be better if I used Server.Execute.
I found I can pass data TO the called asp file by creating an HTML <input>
and erading it after I get there.
However, I also need to read back ONE variable that the called file must
set. I cannot figuer out how to do that. My backup positions are (1) I can
keep on using the #Include technique, and (2) I can use a database to bridge
the gap.Isn't there a way to carry data BACK TO the calling asp file FROM
THE CALLED asp file?
I am using a stored procedure to insert set of values to a table.I am generating or calculating the value of the primary key and inserting that record and i need that value to use in my application so is there any possibilty to return a value from storedprocedure to asp application.
what i am using to do is creating a #temp table and inserting that value in the sp and then opening that value in the asp application and droping that table, but i hope it is not a efficient method.
When a user logs in, I want to redirect them to the page that they were previously on. How do I do that? I already have the login page working. I just need to edit the redirect part.
View Replies View Related