I am running into a command time out error. I have to retrieve a lot of date thru a complex query. For some reason, I can't change the commandtimeout to more then 30 secs. And yes I have Connectiontime incr4eased to 90 seconds. Code:
View RepliesI am getting the above error when trying to execute the following code:
View Replies View RelatedI a running a SP and calling it through ASP. I keep getting this error:
Parameter object is improperly defined. Inconsistent or incomplete information was provided. I think I have the format of the date wrong somewhere. Code:
I am trying to run this command but get the error below.
Code:
INSERT INTO Paint_Orders ( PaintID, Paint, Qty, TicketID )
SELECT TempCart.PaintID, TempCart.Paint, TempCart.Qty, Order_Business.TicketID
FROM TempCart, Order_Business;
Unterminated string constant
/pinsys/Goods_receive/cart4.asp, line 59, column 82
Command1.CommandText = "INSERT INTO Paint_Orders ( PaintID, Paint, Qty, TicketID )
I'm trying to run a stored procedure and access data to read data. I'm getting an error with the ObjComm.CommandText when it's calling the Stored procedure.
ADODB.Command error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.....
I'm getting the following error:
Command text was not set for the command object.
/supercircuits/results.asp, line 30
I've never encountered this error before. Is there a problem with the
syntax? Anyone see where the problem is occurring?
Here is the code to the page: Code:
I am getting the above error in an asp page. Not sure why? The error details is given below. Code:
View Replies View RelatedWhen I run the following code, i get an error:
80070002 corresponding to line18: wshell.run (name).
When I copy & paste this command to prompt it works fine. Have tried other simple commands such as ping as they work fine. Any idea what error number could be or how I could output the error the prompt might be giving. Code:
I am having a problem with an insert statement. I keep getting the following error:
2147217900 Syntax error in INSERT INTO statement. Here is my SQL statement:
INSERT INTO Notes (Note, Submitter, NoteDate, ContactID)
VALUES ('Barb us our Rep', 'DrM', '10/13/2004', '1')
I am not able to seee the error. Are there other problems that could give me this error that are not relative to the SQL Command. If I have made an error please help me to see it.
I have one activex control which fetches data from database and writes it in text file. This control i am using in my asp page. The page executes perfectly fine on my machine but when i execute it from different machine it gives me following error:
Run-time error '-2147467259(80004005)'
Unspecified error
I have an online application. I get the following error when a user selects an option from one drop down list but doesn't select an option from another drop down list. Here is the error:
Microsoft OLE DB Provider for SQL Server error '80040e0c' Command Text was not set for the command object. Code:
I have an online application. I get the following error when a user selects an option from one drop down list but doesn't select an option from another drop down list. Here is the error:
Microsoft OLE DB Provider for SQL Server error '80040e0c'
Command Text was not set for the command object.
Line 87
Line 87 = rs1 = conn.execute(finalSQL)
Here is the page causing the error. Code:
I keep getting this error. I searched the forums, and found one. It said to basically replace elseif with else. It worked for that person.
I tried it and it didn't work. So what i decided to do was, remove all of the if statements and keep one. Even with just one if statement i get the same problem. Does anybody know what is wrong? It worked fine, up until i added the if statement. I need them there though for a reason.
Personally i think, it;s not getting the value from the request form, and hense it isn't picking anything up. What do you lot reckon? Code:
I have a message that scrolls across the top of the page,
it can work, refresh, work, refresh, fail, refresh, work, etc etc
I dont have any control of the permissions, web server etc
just my code and database file.
I can see any reason why it will work 4 out of 5 times.
Any thoughts ? Code:
What causes this?
CDO.Message.1 error '80040212'
The transport lost its connection to the server.
/cardmanagement.asp, line 140
how does one go about fixing a run time error? it pops up an alert box with "run-time" and then gives a line number that doesn't really go anywhere. it is usually referring to some html tag. how can i figure out what line it is actually referring to?
View Replies View RelatedI have spent a fair amount of time creating a company Intranet. Now I have decided to create an admin page that will analyse the automatically created log files. This project is going well so far so good. the time in my log file is 1 hour earlier than the event that it records.
Ie 11.30 am is recorded as 10.30 am. This is true of both my setups (programming/test and working) The time on both computers is correct and if I request the time using ASP the correct time is displayed. While this is not the end of the world I could adjust the time when displaying the data I would like to fix the problem at source.
Microsoft OLE DB Provider for SQL Server error '80040e31'
Timeout expired
/localedit.asp, line 225
here is the query and [Eligible Demo For Contract] is HUGE.
StrSql = "SELECT EPN, D FROM [Eligible Demo For Contract] WHERE SID = (SID) GROUP BY EPN, D"
I am getting the error Time out expired , I have tried every thing increased Server.scripttimeout to 90000 response.buffer=false .. etc even then I m gettin the error.
View Replies View Relatedi need to calculate the time and date difference between two times and dates.
Example 1 works fine:
Difference between 27/09/04 10:00 and 28/09/04 12:00 gives a correct answer of 1 day and 2 hours.
Example 2 gives an error:
Difference between 9/16/04 1:50 PM and 9/28/04 11:54 AM gives an incorrect answer of 12 days -56 minute(s) .
How do i fix this?
I m getting this error :
Run Time error '-2147217887 (80040e21)':
Multiple-step OLE DB operation generated errors. Check each OLE DB Status value, if available. No work was done.Can anyone tell me the reason why this error comes?
I am using VB with SQL Server 2000 with File-DSN Connection and that VB code (Standard Exe) has more than one insert/update statements.
The 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 performed a forum search and there was a similar question but I had some problems in the visualization of the posts.
Anyway the question is:
run-time error Microsoft VBScript (0x800A01AD)
ActiveX component cannot create object
and the error that raise the error is
Set rs = Server.CreateObject("ADODB.Recordset")
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.
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.