|
SQL Server ASP Discussions about ASP programming with Microsoft's SQL Server. For more ASP forums, see the ASP forum category. |
Welcome to the p2p.wrox.com Forums.
You are currently viewing the SQL Server ASP section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
|
|
|
June 18th, 2004, 06:47 AM
|
Authorized User
|
|
Join Date: Jun 2004
Posts: 25
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Object required error ??
Hi,
I am using this query:
strQuery="INSERT INTO Articles, ArtNode (ArtHeadline, ArtBodyText, ArtStartDate, ArtAuthorID, ArtActive, URD) values ('" & _
f_str_headline & "', '" & f_str_articletext & "', '" & f_str_date & "', " & f_str_author & ", " & f_str_active & ", '" & f_str_urd & "'" & ")"
The funny thing is that the query works but it still generated an error in the browser:
-2147217900 , Syntax error in INSERT INTO statement.Syntax error in INSERT INTO statement.424 , Object requiredObject required
Please Help!
|
June 18th, 2004, 08:35 AM
|
Friend of Wrox
|
|
Join Date: May 2004
Posts: 642
Thanks: 0
Thanked 43 Times in 42 Posts
|
|
can you paste your code?
Om Prakash
|
June 18th, 2004, 10:02 AM
|
Authorized User
|
|
Join Date: Jun 2004
Posts: 25
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Hi Om,
I've sent you an email.
Ian
Quote:
quote:Originally posted by om_prakash
can you paste your code?
Om Prakash
|
|
June 18th, 2004, 12:05 PM
|
Friend of Wrox
|
|
Join Date: Jun 2003
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
|
|
Hi Hman,
INSERT INTO Articles, ArtNode (ArtHeadline, ArtBodyText, ArtStartDate, ArtAuthorID, ArtActive, URD)...
It looks like you are trying to insert into 2 tables with one insert statement.
That is not possible. Check the Insert Statement syntax.
Code:
INSERT TABLENAME (column_1, column_2) VALUES ('Row #1',1)
Hope that helps.
Cheers!
_________________________
-Vijay G
Strive for Perfection
|
June 19th, 2004, 12:36 AM
|
Friend of Wrox
|
|
Join Date: May 2004
Posts: 642
Thanks: 0
Thanked 43 Times in 42 Posts
|
|
Yes, as pointed out by vijay,
you are trying to insert data in two tables (Articles, ArtNode)
You need to write 2 seperate queries.
Om Prakash
|
June 21st, 2004, 09:30 AM
|
Authorized User
|
|
Join Date: Jun 2004
Posts: 25
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Thanks but I still get an error when just inserting into one table. I also have another SQL query in my ASP page, which seems to give the error:
'424 , Object requiredObject required '
Here is my other query:
strQuery2="SELECT ArticleID FROM Articles WHERE ArtLastModifDate='" & f_str_modifdate2 & "'"
Please help
|
June 21st, 2004, 09:36 AM
|
Friend of Wrox
|
|
Join Date: Jun 2003
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
|
|
The other query looks okay, but what is the code on line 424?
Cheers!
_________________________
-Vijay G
Strive for Perfection
|
June 21st, 2004, 09:56 AM
|
Authorized User
|
|
Join Date: Jun 2004
Posts: 25
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Hi Vijay,
I don't think it has anything do with the line number as line 424 is the last line in my code which is just </html>
Here is a break down of my query:
strQuery2="SELECT ArticleID FROM Articles WHERE ArtLastModifDate='" & f_str_modifdate2 & "'"
I am selecting the FIELD 'ArticleID' from the TABLE 'Articles' where the FIELD 'ArtLastModifDate' = to FIELD f_str_modifdate2
'f_str_modifdate2' field is a date & time field and the format will look like this in the database itself: 21/06/2004 15:16:32
BTW it is an 'MS Access' database I am using, NOT SQL database.
Any ideas about the error
|
June 21st, 2004, 10:05 AM
|
Friend of Wrox
|
|
Join Date: Jun 2003
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
|
|
Hi,
As It says OBJECT REQUIRED, it should be something with the way you are trying to set your RECORDSET. So just explaining on this SQL statement would show no light on this.
Can you paste some lines before and after this SQL statement?
Also when you say you are using MSACCESS, the date values should be used with # around it in the select statement instead of '.
Also in your previous post you say
Quote:
quote:Thanks but I still get an error when just inserting into one table. I also have another SQL query in my ASP page, which seems to give the error:
|
Is you insert statement on the same page too? What is that error about? Or it could be the use of ' within the column value which you are trying to insert.
Without seeing some code around it is is hard to narrow down to the problem.
Cheers!
_________________________
-Vijay G
Strive for Perfection
|
June 21st, 2004, 10:24 AM
|
Authorized User
|
|
Join Date: Jun 2004
Posts: 25
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Here is the section of code I am using in my ASP page for the query:
headline_str_db = "Provider=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=C:\datafiles\db1.MDB;"
dim f_str_modifdate2
f_str_modifdate2=Request.Form("modifdate")
'variable to store the result
dim l_str_articleid
'Variable for Connection and Recordset
dim conDB2
dim rsDB2
'Creating a instance of a ado connection
set conDB2=server.createobject("ADODB.Connection")
'create a instance of a ado recordset
set rsDB2=server.CreateObject("ADODB.RecordSet")
if err.number<>0 then
ErrorHandler (Err.number)
end if
string strQuery2,strResult2
'Opening database connection
'conDB.Open f_str_db,f_str_user,f_str_password
conDB2.ConnectionString= headline_str_db
conDB2.Open
if err.number<>0 then
ErrorHandler (Err.number)
end if
strQuery2="SELECT ArticleID FROM Articles WHERE ArtLastModifDate='" & f_str_modifdate2 & "'"
'Executing the query
set rsDB2=conDB2.Execute(strQuery2)
'testing for end of file
if not rsDB2.EOF then
strResult2=rsDB2(0).Value
if err.number<>0 then
ErrorHandler (Err.number)
end if
'Replacing ' with \'
strResult2=Replace(strResult2,"'","\'")
if err.number<>0 then
ErrorHandler (Err.number)
end if
'Replacing \n with blank space
strResult2=Replace(strResult2,chr(10)," ")
strResult2=Replace(strResult2,chr(13)," ")
if err.number<>0 then
ErrorHandler (Err.number)
end if
'Assigning into the variable
l_str_articleid=strResult2
if err.number<>0 then
ErrorHandler (Err.number)
end if
'displaying the content on the screen
'Response.Write(l_str_content)
else
'Response.Write "<script language=javascript>alert('Not found!');</script>"
End if
Sub ErrorHandler(Eno)
Select case Eno
case 0
case Else
Response.Write(Err.number &" , " & Err.Description)
l_str_articleid=Err.Description
Response.Write(l_str_articleid)
Err.Clear
End select
End Sub
conDB2.Close
|
|
|