Source language: Translate to:

Ayuda array plugin MYSQL

General questions about NeoAppBuilder - our rapid application development tool for building HTML5, web and mobile apps.

Moderator: Neosoft Support

Ayuda array plugin MYSQL

Postby djmarkes » Fri Feb 24, 2017 10:33 am

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!
Diseño gráfico y Web profesional
http://www.jm-style.net
User avatar
djmarkes
 
Posts: 187
Joined: Thu May 26, 2011 5:08 pm

Re: Ayuda array plugin MYSQL

Postby anton » Mon Feb 27, 2017 7:01 am

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"}
User avatar
anton
 
Posts: 60
Joined: Fri Oct 19, 2012 9:21 pm


Return to General NeoAppBuilder Discussion

Who is online

Users browsing this forum: No registered users and 1 guest