Using ASP, I would like to write down to the HTML the time taken to execute a query. I am trying to optimize my SQL queries in the ASP page. So I want to determine if my SQL query is optimal or not. So how can I determine how much time it took to execute the query and return the results.
For example, something like: It took 5 seconds.
I tried to run 2 queries in single connection. But it doesnt work to the second query
page will return an error but execute the frist query only. How can i solve this problem.
I'm using Microsoft Access 2000. Here are the code an error that return
Dim objConn, strSQL1, strSQL2
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "DSN=egbit_dev;"
strSQL1 = "Update ADM_USERTAB Set USER_PWD = '" & new_pwd & "' where USER_ID = '" & userid & "'"
set rsUpdate_Pwd = objConn.Execute(strSQL1)
strSQL2 = "Update EGBIT_PWD_STATUS Set password_status = 'change' Where user_id = '" & userid & "'"
set rsstatus = objConn.Execute(strSQL2)
error :
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
( it refering to line that execute set rsstatus = objConn.Execute(strSQL2) )
wat are the different ways i could execute this update query. Code:
sql="Update Employee Set name='"& name&"', age="& age &" location='"& loc &"'
Conn.Execute sql
the sql statement shows evrythings correct. but when i execute the update query...it shows syntax error in UPDATE statment.
How can you use ASP code to execute an Access query. I want to run the query to then display updated data on the webpage.
View Replies View RelatedThe following code has run-time error on "divide by 0" error. I expect
"do the work<br>" will not print in the browser, since it happen after
the code that cause the error. However, this is the output: any ideas why?? Or
this is the nature of ASP scripting language that is being executed in
sequential order? Code:
i wirte SQL statment to collect information from oracel database but after 5 minutes i got the following measage
Error Type:
Active Server Pages, ASP 0113 (0x80004005) The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools. Code:
After commands like:
tmpDBconn.Execute("DELETE * FROM mytable WHERE rc_id = 10" )
How do I check for errors?
Is there a way to check the results?
OR:
Set rsCatCount = tmpDBconn.Execute("SELECT COUNT(*) FROM cat WHERE key_id = 10 AND cat_id = 6")
How do I get the count? Do I use rsCatCount(0)?
What should be SQL statement in asp to update time field (in MSACCESS) with current time?
View Replies View RelatedDoes anyone know the asp code to display the time it took to do a search?Like what Google has "found xxxx items. Search took 1.24 seconds"
View Replies View RelatedHow can i set the Query Processing Time in my asp page.i am getting this error messages "Estimated query processing time 152 exceeds limit 30"
View Replies View RelatedI have set up an Access database with a couple of time fields. These display within the database columns as hh:mm but when used to populate my web page show up as hh:mm:ss.
What ASP code can i use to remove the seconds and show these times in the format hh:mm?
I 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.
My code retrieves a username and a password from a form. Then this information is compared to some usernames and passwords that are stored in a database. The important thing here is that the comparison must be case sensitive meaning that "passWord" is not the same thing as "password"
I have this code, working fine in access 2003
SQL = "SELECT * FROM users WHERE StrComp(username_column,'" & entered_username_in_form & "',0) = 0 AND StrComp(password_column,'" & entered_password_in_form & "',0) = 0"
but get the following error when I run it against my sql 2005 database.
[Microsoft][SQL Native Client][SQL Server]'StrComp' is not a recognized built-in function name.
I don't know the corresponding t-sql for the query.
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.
I am running a querry on an access database and have set the number of records/page displayed at 20. if there are more than 20 records returned, then 1st page will show the first 20, the next page will show next 20 and so on....
The trouble:
the count of total records displayed is correct and the first page is displayed correctly. But when i click on *Next* to go to the next page, all the records of the database get displayed (not the 2nd page of records from the query).
I am using ASP/MS ACCESS to see how I can query the same database, via 2 formfields.
{name: - search}Textfield 1: - Search by Category
AND/OR By
{name: - searchT}Textfield 2: - Location
Currently,
strSearchwords = Trim(Request.QueryString("search")); where "search" is the name of Textfield1
Which is fine, but how can I set it so that on Submit, the string from search, and searchT are somehow joined together into one string?
WEll I see that this issue is not yet solved ...
So here's some more beef...
There is an update the first part of the query that takes ~50 seconds
and the connection gets cut off at 30 sec sharp. Logical as the default value us 30 sec.
question :Does anyone know how to increase that value? I can't do it in the udl , it reverts back to nothing.
Option:
[1]I would/could also optimize that update using a hint to fasten it
[2] Or try to execute the proc without using the dsn?
Using ASP 3 on an ISP account (I don't have access to the root of the
server). I have a page that does some intake processing and I'd like to have
it run every 5 minutes. Right now, the only way I can see to do this is to
have a client task that wakes up every 5 minutes and opens that page.Is
there a better way?
how can i setup a connection to run the sql statement? how can i embedded it in the script? Code:
View Replies View RelatedI recently moved an app over to IIS 6 from IIS 5. Everything works great! I use ASPExecute to run an .exe - but it doesn't fire. It just sits in the process window. Doesn't do anything. Is IWAM, or IUSR or both required to run it?
View Replies View RelatedI need to use a VB6 dll like an ActiveX in ASP page. This dll use other .exe that is configured en DCOMCNFG and this dll is configured too in the same environment (DCOMCNFG) like a DllSurrogate with an specific user administrator.
I don't know how to configure this dll & IIS to it works with Anonymous authentication. I need to do this because is a development that it works in an Internet environtment and I can't assign a administration user in IIS 5 to the anonymous user.
Can server.execute provide a return value? How? ie.
dim test
test = server.execute("page2.asp")
What code in page2.asp will produce something in test?
my global.asa file doesn't seem to be executing in IIS and i don't know how to make them run. Any ideas how to execute the global.asa file in IIS 5.1 ,
View Replies View Related<%Response.Write "Hello"%>
<html>
<head>
<javascript language="javascript">
alert("First");
</script>
</head>
<body bgcolor="#FFFFFF">
<h1>Testing</h1>
</body>
Which code execute first.