I guess this is a very old problem, but this keeps bugging many ppl in
many ways.
I am facing the problem with the SQL query >>>>
Insert Into DailySalesReport (hoautoid, dsdate, dsreport, dsclientid,
dsprincipleid, dsremarks, dsadminlock ) Values
(5,'2/16/2005','sacc',1,1,'cdssd','not')
This query runs fine on query analyser, but when I try to put in asp
page and then it gives the runtime error as >>
Microsoft VBScript runtime error '800a01a8'
Object required: ''
/data/dsreport.asp, line 52
Line # 52 is >>
Set oRs4 = oConn.Execute(qry)
The whole set of code is :
<%
IF Request("action") = "1" Then
'muname = request("T1")
'mfname = request("T2")
'mbranch = Request("T3")
mhoautoid = Session("Ssrid")
mdate = date()
mvreport = Request("T5")
mclient = Request("T6")
mprinciple = Request("T7")
mremark = Request("T8")
malock = "not"
'Removed the date input from the page
'mdate = Trim(Request("T4"))
'<tr>
'<td width="130">Date</td>
'<td width="391"><input type="date" name="T4" size="10"></td>
'<td>Date of Entering the Record in mm/dd/yy</td>
'</tr>
'Set oRs4 = Server.CreateObject("ADODB.Recordset")
'Dim msql
qry = "Insert Into DailySalesReport "
qry = qry & " (hoautoid, dsdate, dsreport, dsclientid, dsprincipleid,
dsremarks, dsadminlock ) Values ("
qry = qry & mhoautoid & ",'" & mdate & "','" & mvreport & "'," &
mclient & "," & mprinciple & ",'" & mremark & "','" & malock & "')"
response.write qry
'response.end
'oRs4.Open msql
Set oRs4 = oConn.Execute(qry)
response.write "One Record added to the database"
oRs4.close
end if
%>
So pls help ASAP... thanks in advance
sg 1 4242
On 15 Feb 2005 23:40:14 -0800, g_******@yahoo.com wrote:
oConn is not set.
Action queries like INSERT do not return a recordset.
-Tom. I guess this is a very old problem, but this keeps bugging many ppl in many ways.
I am facing the problem with the SQL query >>>> Insert Into DailySalesReport (hoautoid, dsdate, dsreport, dsclientid, dsprincipleid, dsremarks, dsadminlock ) Values (5,'2/16/2005','sacc',1,1,'cdssd','not')
This query runs fine on query analyser, but when I try to put in asp page and then it gives the runtime error as >>
Microsoft VBScript runtime error '800a01a8'
Object required: ''
/data/dsreport.asp, line 52
Line # 52 is >> Set oRs4 = oConn.Execute(qry)
The whole set of code is : <% IF Request("action") = "1" Then
'muname = request("T1") 'mfname = request("T2") 'mbranch = Request("T3") mhoautoid = Session("Ssrid") mdate = date() mvreport = Request("T5") mclient = Request("T6") mprinciple = Request("T7") mremark = Request("T8") malock = "not"
'Removed the date input from the page 'mdate = Trim(Request("T4")) '<tr> '<td width="130">Date</td> '<td width="391"><input type="date" name="T4" size="10"></td> '<td>Date of Entering the Record in mm/dd/yy</td> '</tr> 'Set oRs4 = Server.CreateObject("ADODB.Recordset") 'Dim msql qry = "Insert Into DailySalesReport " qry = qry & " (hoautoid, dsdate, dsreport, dsclientid, dsprincipleid, dsremarks, dsadminlock ) Values (" qry = qry & mhoautoid & ",'" & mdate & "','" & mvreport & "'," & mclient & "," & mprinciple & ",'" & mremark & "','" & malock & "')" response.write qry 'response.end 'oRs4.Open msql Set oRs4 = oConn.Execute(qry) response.write "One Record added to the database" oRs4.close end if %>
So pls help ASAP... thanks in advance
sg This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Matrix |
last post by:
I just got one virtual directory setup and try to run my web application from
there. I am getting following error
Microsoft VBScript runtime error '800a01a8'
Object required: 'Session'
I even...
|
by: PaulieS |
last post by:
Hi all.
Am migrating a customer from IIS5 on W2K server to IIS6 on W2K3.
Zipped all the websites and unzipped them to the identical locations
on new server. Used IISMT to migrate metabase.
...
|
by: anidmarty |
last post by:
Hey
I'm a Sysadmin and my users are getting this error on my production box.
It works fine on the dev box.
There is a script that is run that generates this error.
Production is clustered...
|
by: raminator |
last post by:
Microsoft VBScript runtime error '800a01a8'
Object required: 'rs2'
/login/login.asp, line 233
-------------------------------------------------------------------------------------
I get the...
|
by: =?Utf-8?B?TWF0dCBDYWxob29u?= |
last post by:
HI there,
I am getting an error on my page which calls up a web service.
Microsoft VBScript runtime error '800a13ba'
Unknown runtime error: 'SearchQueryXML'
/SearchResults.asp, line 142
| |
by: Genken |
last post by:
Hi can anybody help me i get this error when running this code.
Error Type:
Microsoft VBScript runtime (0x800A01A8)
Object required: ''
And then a line number indicating where the error is, i...
|
by: nitindel |
last post by:
Hi All,
Please let me know that why i am getting the error like this:-
Microsoft VBScript runtime error '800a01a8'
Object required
/Melange/MasconNet/singlesignon.asp, line 49
|
by: .nLL |
last post by:
Erorr is
---------------------
Microsoft VBScript runtime error '800a0046'
Permission denied
/a.asp, line 3
-----------------------
|
by: gray d newbie |
last post by:
Greetings All,
I'm new to this forum as well as to ASP. Therefore I am ready to learn from the ASP experts in this forum. Thank you very much in advance.
I was assign to develop a ASP based...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
| |
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...
| |