Skip to main content
sawank18707653
sawank18707653
Participant
August 17, 2016
Question

Retrieve a single row form the data

  • August 17, 2016
  • 1 reply
  • 539 views

I want to retrieve single row from my database when i enter id of that row. I am giving id number in a prompt box and sending it to database when the id matches to database id, it gives me the data of entire row but i don't know how to do it via prompt box in cordova.  also when i store data from server in sqlite and print data it only gives me last row of the data not the entire column data..

    This topic has been closed for replies.

    1 reply

    sinious
    sinious
    Legend
    August 20, 2016

    This is a pretty broad stroke of a question. It's better to really scope this down.

    Start with the first issue, getting data per your db 'id'. I'm assuming you have a standard column in a table in your database (whatever kind, sqlite, etc) and are trying to access that row via specifying the 'id' of the row. Please post the relevant code either here or a pasting on your preferred site such as jsfiddle, codepen, etc. Then please explain the DB 'id' column type (int? other?).

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices