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

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

Android SQLite error on insert

Course Queries Syllabus Queries 2 years ago

0 2 0 0 0 tuteeHUB earn credit +10 pts
5 Star Rating 1 Rating
Previous Next

Posted on 16 Aug 2022, this text provides information on Syllabus Queries related to Course Queries. Please note that while accuracy is prioritized, the data presented might not be entirely correct or up-to-date. This information is offered for general knowledge and informational purposes only, and should not be considered as a substitute for professional advice.

Take Quiz To Earn Credits!

Turn Your Knowledge into Earnings.

tuteehub_quiz

Answers (2)

Post Answer
profilepic.png
manpreet Tuteehub forum best answer 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
                                                
                                                


                                                    

                                                        
                                                            0
                                                            views 

                                                            
                                                            

                                                            0
                                                            shares
profilepic.png
manpreet 2 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.

Q

What is the full form of NABARD ?

Banking, Finance & Insurance
Q

How to refresh app upon shaking the device?

Mobile Technologies
Q

What are the govt exams after BCA?

Career Talk
Q

TYPO3 v8. Override function in Core class

General Tech
Q

Why do people in India give so much importance to Government jobs?

Commerce & Accounting

Explore Other Libraries

Blogs Tutorials Question Bank Feeds Careernews

Related Searches

Android SQLite error INSERT

Important Course Queries Links

 Syllabus Queries
 Competitions/Entrance Exams