djmarkes wrote:Hola amigos.
Estoy usando el plugin de anton, al menos probando.
Hago esto:
Code: Select all
bakInQuiryTableMySQL "SELECT" "SELECT * FROM products WHERE REFERENCE = '[refe]'" [json]
y obtengo esto en [json]
Code: Select all
[{"ID":"79795","REFERENCE":"FE20570158ECO","FAMILY_ID":"7882","MEASURE":"205/70R15C FEDERAL TL ECOVAN ( NEU)106S *E*","PRICE":"53.8","STOCK":"0","SLOPE":"0","ROLL_RESISTANCE":null,"BRAKING_DISTANCE":null,"NOISE_DB":null,"EAN_CODE":null,"MANUFACTURER_CODE":null,"FLAG_FIX_PRICE":"0","FLAG_GT2000":"0","SPEED_INDEX":null,"MEASURE_CODE":null,"MEASURE_WIDTH":null,"MEASURE_HEIGHT":null,"MEASURE_INCH":null},{"ID":"28837468","REFERENCE":"FE20570158ECO","FAMILY_ID":"7882","MEASURE":"205/70R15C TL ECOVAN (NEU)106S *E*","PRICE":"47.18","STOCK":"0","SLOPE":"31","ROLL_RESISTANCE":"E"}]
Quiero acceder a los datos del array pero no hay manera. Intento esto:
[json|element:(0)(REFERENCE)]
[json|element:(0)]
[json|element:3]
[json|element:('REFERENCE')]
Pero no hay manera de que me imprima solo el valor...
Pueden ayudarme?
Gracias!
[json(0)('REFERENCE')] = FE20570158ECO
En orden, para llevar el valor del elemento de la pantalla, para la variable correspondiente debe ejecutar setvar:
SetVar [REFERENCE] [json(0)('REFERENCE')]
[json(0)] = {"ID":"79795","REFERENCE":"FE20570158ECO","FAMILY_ID":"7882","MEASURE":"205/70R15C FEDERAL TL ECOVAN ( NEU)106S *E*","PRICE":"53.8","STOCK":"0","SLOPE":"0","ROLL_RESISTANCE":null,"BRAKING_DISTANCE":null,"NOISE_DB":null,"EAN_CODE":null,"MANUFACTURER_CODE":null,"FLAG_FIX_PRICE":"0","FLAG_GT2000":"0","SPEED_INDEX":null,"MEASURE_CODE":null,"MEASURE_WIDTH":null,"MEASURE_HEIGHT":null,"MEASURE_INCH":null}
[json(1)('FAMILY_ID')] = 7882
En orden, para llevar el valor del elemento de la pantalla, para la variable correspondiente debe ejecutar setvar:
SetVar [FAMILY_ID] [json(1)('FAMILY_ID')]
[json(1)] = {"ID":"28837468","REFERENCE":"FE20570158ECO","FAMILY_ID":"7882","MEASURE":"205/70R15C TL ECOVAN (NEU)106S *E*","PRICE":"47.18","STOCK":"0","SLOPE":"31","ROLL_RESISTANCE":"E"}
