Insert command error !

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

Hi,

I am working on archiving concept of a live project.
The issue is that when i select check box he corresponding value should be selected and on the submit button click event should move to the another page named a s archive. My code is picking up almost correct values but when i need the method of copying the query is called it is showing error.
the value should move from one table to another in data-base and through the second table it should display the contents in grid view on the page archive.aspx.
the error is coming when data table is filled when copy method is called.
it gives a error

"Incorrect syntax near ','."

as far as i understood its a small error in insert command which is as follows

SQL

string sql = "INSERT INTO tbl_Event(newsId,newsTitle,shortnews,newsDetails,postedDate,newsStatus)"
                                    + "SELECT (newsId,newsTitle,shortnews,newsDetails,postedDate,newsStatus)"
                                    + "FROM tbl_News where newsId = '"+newsId+"' ";

please help.

Regards,
Taresh

Posted 10-Feb-12 19:11pm

Taresh Uppal

Updated 10-Feb-12 19:15pm

NikulDarji

v2

Add a Solution

2 solutions

Solution 2

Finally it worked... iremoved the '+' sign where i ws breaking the statement into next line in insertion and i removed braces too...so its working..
thanx Rahul

Regards,
Taresh

Posted 10-Feb-12 20:59pm

Taresh Uppal

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

RDBurmon · Accepted Answer · 2012-02-10T20:27:00

Solution 1

Try this

SQL

string sql = "INSERT INTO tbl_Event(newsId,newsTitle,shortnews,newsDetails,postedDate,newsStatus)"
                                    + " SELECT newsId,newsTitle,shortnews,newsDetails,postedDate,newsStatus "
                                    + " FROM tbl_News where newsId = '"+newsId+"' ";

Posted 10-Feb-12 20:27pm

RDBurmon

Comments

Taresh Uppal 11-Feb-12 2:48am

I have done this but using this it shows a new error which says
Invalid column name 'newsId'.
Invalid column name 'newsId'.
Invalid column name 'newsTitle'.
Invalid column name 'shortnews'.
Invalid column name 'newsDetails'.
Invalid column name 'postedDate'.
Invalid column name 'newsStatusFROM'.

RDBurmon 11-Feb-12 5:44am

Please copy and paste as it is
string sql = "INSERT INTO tbl_Event(newsId,newsTitle,shortnews,newsDetails,postedDate,newsStatus)"
+ " SELECT newsId,newsTitle,shortnews,newsDetails,postedDate,newsStatus "
+ " FROM tbl_News where newsId = '"+newsId+"' ";

Also share you table stucture of tbl_News and tbl_Event