Questions and discussion about developing processes and programming in PHP, JavaScript, web services & REST API.

Moderator: amosbatto

Forum rules: Please search to see if a question has already asked before creating a new topic. Please don't post the same question in multiple forums.
By Thommelise
#825981
$V_ORDERID = @%ORDERID;

@=linuxManualDiskLayoutID = executeQuery("SELECT D1 AS linuxDiskManualTag, D2 AS linuxManualDiskLgVg, D3 AS linuxManualDiskSize, D4 AS linuxManualDiskDescr FROM PMT_ORDER_DATA_ITEM WHERE ORDERITEMID='$V_ORDERID' AND TYPE= '4'");

trying to populate grids by using a trigger. i have 2 tables order_data and order data_item.

why dosent it work?
User avatar
By amosbatto
#825985
MySQL is very particular about data types. If your ORDERITEMID and TYPE fields are integers, then you need to remove the single quotation marks from your database query like this:
Code: Select all
@=linuxManualDiskLayoutID = executeQuery("SELECT D1 AS linuxDiskManualTag, D2 AS linuxManualDiskLgVg, 
   D3 AS linuxManualDiskSize, D4 AS linuxManualDiskDescr 
   FROM PMT_ORDER_DATA_ITEM 
   WHERE ORDERITEMID=$V_ORDERID AND TYPE= 4");
Also, verify that linuxManualDiskLayoutID is the exact spelling of the variable associated with your grid (if you are trying to populate a grid).

Sending documents as base64 worked the last time I[…]

I don't see those problems using PM 3.3.10 Communi[…]

Tengo el mismo problema con el MultipleFile, inten[…]

Getting this error

_ERROR_ : The row '3149943815d31b85fdf39650326697[…]