0

i just want to fetch data from sql without using query. if i use query I'm getting data successfully but i don't want to use it.

This is what i am trying but i don't know where i am doing wrong.

    function showPerson(event) {
        var selectedPerson = event.source;
        var recoverDatabase = Alloy.createCollection("persons");;
        alert("Starting fetching data");
        recoverDatabase.fetch({'name': selectedPerson.title });
        // recoverDatabase.fetch({query:"SELECT * FROM persons WHERE name = '" + selectedPerson.title + "'" });
        alert("Successfully retrive data");
        alert(recoverDatabase.get('name'));
        alert(recoverDatabase.get('Age'));
    }

i am not getting an error just empty values. Thanks

EDIT persons.js

exports.definition = {
    config: {
        columns: {
            "id"        : "int",
            "name"      : "text",
            "email"     : "text",
            "age"       : "int",
            "address"   : "text",
            "sex"       : "text"
        },
        adapter: {
            type: "sql",
            collection_name: "persons"
        }
    },
    extendModel: function(Model) {
        _.extend(Model.prototype, {
            // extended functions and properties go here
        });

        return Model;
    },
    extendCollection: function(Collection) {
        _.extend(Collection.prototype, {
            // extended functions and properties go here
        });

        return Collection;
    }
};
OOkhan
  • 297
  • 3
  • 8
  • 20

0 Answers0