Yes because you are missing the identify step:
Thanks Teo I will try again
Sorry Teo, I am nearly there.
The id has been found
{
“identity”: 485,
“scUser”: {
“options”: {
“connection”: “connection1”,
“sql”: {
“type”: “select”,
“columns”: [
{
“table”: “customers”,
“column”: “name”
},
{
“table”: “customers”,
“column”: “mobile”
},
{
“table”: “customers”,
“column”: “email”
}
],
“table”: {
“name”: “customers”
},
“joins”: ,
“wheres”: {
“condition”: “AND”,
“rules”: [
{
“id”: “customers.idno”,
“field”: “customers.idno”,
“type”: “double”,
“operator”: “equal”,
“value”: 485,
“data”: {
“table”: “customers”,
“column”: “idno”,
“type”: “number”
},
“operation”: “=”
}
],
“conditional”: null,
“valid”: true
},
“query”: “SELECT name, mobile, email\nFROM customers\nWHERE idno = :P1 /* 485 */”,
“params”: [
{
“operator”: “equal”,
“type”: “expression”,
“name”: “:P1”,
“value”: 485
}
],
“orders”:
},
“test”: true
},
“query”: “SELECT name, mobile, email FROM customers WHERE (idno = ?)”,
“params”: [
{
“id”: “customers.idno”,
“field”: “customers.idno”,
“type”: “double”,
“operator”: “equal”,
“value”: 485,
“data”: {
“table”: “customers”,
“column”: “idno”,
“type”: “number”
},
“operation”: “=”
}
]
}
}
But I still can’t get it ti display the data
This option must be turned off:
It should only be used if you want to debug the sql query generated.
I am learning! thanks again Teo all good now
2 Likes