Android SQLite error on insert

manpreet Best Answer 2 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
                                                

                                                                                                        REPLY
                                                    
                                                
                                                


                                                    

                                                        
                                                            0
                                                            views 

                                                            0
                                                                likes 
                                                            
                                                            

                                                            0
                                                            shares

                                                            


    

         Facebook
        
         Twitter
        
        
         Linked In 
        
          WhatsApp