Skip to content
GitLab
Projects Groups Snippets
  • /
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in / Register
  • R ReActiveAndroid
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 18
    • Issues 18
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 1
    • Merge requests 1
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
  • Deployments
    • Deployments
    • Environments
    • Releases
  • Packages and registries
    • Packages and registries
    • Package Registry
    • Infrastructure Registry
  • Monitor
    • Monitor
    • Incidents
  • Analytics
    • Analytics
    • Value stream
    • CI/CD
    • Repository
  • Wiki
    • Wiki
  • Snippets
    • Snippets
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar
  • Mahach Imangazaliev
  • ReActiveAndroid
  • Issues
  • #58
Closed
Open
Issue created Apr 19, 2019 by BH Apps@bhapps

Pass Comma Deliminated String & IN SQL Query

ReActiveAndroid Version: latest Bug or Feature Request: Pass Array String for using WHERE.IN sql query

Description: When using the below I get an exception error as where() seems to not accept all internal sql clauses types, although I have used BETWEEN before ..

Error

#################################################################
    Error Code : 1 (SQLITE_ERROR)
    Caused By : SQL(query) error or missing database.
    	(near "?": syntax error (code 1): , while compiling: SELECT * FROM Notes WHERE id IN ? ORDER BY id ASC LIMIT 20)
    #################################################################

String myCommaStingOfIds = "86973,86974,86975,86976,86977,86978,86979,86980"; where.("id IN ?", "(" + myCommaStingOfIds + ")");

Refer to http://www.tutorialspoint.com/sqlite/sqlite_where_clause.htm

Assignee
Assign to
Time tracking