Mobile Technologies Web Technologies Digital Marketing Creative Design Career Talk Medical General Tech Interviews Internet Of Things

Embark on a journey of knowledge! Take the quiz and earn valuable credits.

Take A Quiz

Challenge yourself and boost your learning! Start the quiz now to earn credits.

Take A Quiz

Unlock your potential! Begin the quiz, answer questions, and accumulate credits along the way.

Take A Quiz

Popular Categories

All
Interview Questions
Question Bank
Quantitative Aptitude
Engineering
Govt Exams
Digital Marketing
Management
Interviews

Android SQLite error on insert

Course Queries Syllabus Queries 3 years ago

6.18K 2 0 0 0
author
Previous Next

User submissions are the sole responsibility of contributors, with TuteeHUB disclaiming liability for accuracy, copyrights, or consequences of use; content is for informational purposes only and not professional advice.

Answers (2)

Post Answer
profilepic.png
manpreet Tuteehub forum best answer Best Answer 3 years ago


I am having a very odd error here

android.database.sqlite.SQLiteException: near ",": syntax error (code 1): , while compiling: INSERT INTO course(banner_image,image,subtitle,homepage,short_summary,expected_learning,,new_release,syllabus,title,slug,key,featured,summary,faq,starter,project_description,required_knowledge,project_name,level,full_course_available) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

I have 2 consecutive commas in my query. The problem is that I am building my insert statement using ContentValues class like this

private ContentValues createCourseValues(){
    ContentValues courseValues = new ContentValues();
    courseValues.put(CourseContract.Course.SUBTITLE, "Starting Out with Web Serving Technology");
    courseValues.put(CourseContract.Course.KEY, "ud171");
    courseValues.put(CourseContract.Course.IMAGE, "avc");
    courseValues.put(CourseContract.Course.EXPECTED_LEARNING, "You want to build Web services");
    courseValues.put(CourseContract.Course.FEATURED, false);
    courseValues.put(CourseContract.Course.PROJECT_NAME, "asd");
    courseValues.put(CourseContract.Course.TITLE, "Intro to Backend");
    courseValues.put(CourseContract.Course.REQUIRED_KNOWLEDGE, "You have a basic working knowledge ");
    courseValues.put(CourseContract.Course.SYLLABUS, "### Forms and Inputs How do web sites security?");
    courseValues.put(CourseContract.Course.NEW_RELEASE, false);
    courseValues.put(CourseContract.Course.HOMEPAGE, "https://www.udacity.com/course/" );
    courseValues.put(CourseContract.Course.PROJECT_DESCRIPTION, "");
    courseValues.put(CourseContract.Course.FULL_COURSE_AVAILABLE, false
                                                

                                                                                                        
                                                    
                                                

                                                

                                                    

                                                        
                                                            0
                                                            views 

                                                            
                                                            

                                                            0
                                                            shares
profilepic.png
manpreet 3 years ago

I found your issue. In your CourseContract class the following field is empty:

public static final String DURATION_IN_HOURS = "";

I changed it to:

public static final String DURATION_IN_HOURS = "duration_in_hours";

and the tests passed.

shareimprove this answer

0 views   0 shares

No matter what stage you're at in your education or career, TuteeHUB will help you reach the next level that you're aiming for. Simply,Choose a subject/topic and get started in self-paced practice sessions to improve your knowledge and scores.

Similar Forum

Q

Neet 2019 syllabus will change?

Q

Syllabus in LaTeX

Q

Does Hogwarts follow any specific syllabus for DADA?

View All

Explore Other Libraries

Online Exams

Question Bank

Career News

Feeds

Full Forms

Dictionary

Interview Question

Gigs

Quotes

Lyrics

Videos

Courses

Blogs

Tutorials

Forum

Educators

Corporates

Tools

Related Searches

Course Queries Syllabus Queries

Important Course Queries Links

Syllabus Queries
Competitions/Entrance Exams