This week's giveaway is in the EJB and other Java EE Technologies forum.
We're giving away four copies of EJB 3 in Action and have Debu Panda, Reza Rahman, Ryan Cuprak, and Michael Remijan on-line!
See this thread for details.
The moose likes JDBC and the fly likes Unknown column 'mkl' in 'field list Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Unknown column Watch "Unknown column New topic
Author

Unknown column 'mkl' in 'field list

Tapan Prajapati
Greenhorn

Joined: Mar 05, 2010
Posts: 27



i get an error : unknown column in 'xx' in field list when i run it and entered the text in text field the value displayed in ' ' and i used net bean . javascript:emoticon('');
Ernest Friedman-Hill
author and iconoclast
Marshal

Joined: Jul 08, 2003
Posts: 24166
    
  30

Your SQL syntax is wrong; the string has to be in single quotes. But you should never, never do this, as you're opening the door to a SQL injection attack (Google that to learn about it if you don't know what it is.) Instead, you should just do this:





[Jess in Action][AskingGoodQuestions]
Tapan Prajapati
Greenhorn

Joined: Mar 05, 2010
Posts: 27
Ernest Friedman-Hill wrote:Your SQL syntax is wrong; the string has to be in single quotes. But you should never, never do this, as you're opening the door to a SQL injection attack (Google that to learn about it if you don't know what it is.) Instead, you should just do this:






Thanks a lot.! its work.!


javascript:emoticon('');
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Unknown column 'mkl' in 'field list
 
Similar Threads
retrieving database data to textarea
Pressing a button to open a new window
swing with mysql connection1
Problem With GUI of Net Beans
how will we move from one page to another within the same window in Swing?