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

Retrieve a single row form the data

  • August 17, 2016
  • 1 reply
  • 547 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 is closed to new replies. Start a new post to keep the conversation going.

    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