javascript-iif delimiter

editMode=(<%=Input[i][152]%>)?'edit':'readonly';


delimiter 
_c0x2=_c0x2+(_c0x2?',':'')+_c0x1[i4];

s2=s2+(s2?'<BR><BR>':'')+_lookup('SALES_ORDER_PO_DESC.DESCRIPTION'+i2)

user-table

password
email
surname
alias
username
recordid
loginid

img-center css-center

<img id="waiting" src="images/ajax_loader.gif" alt="" width="128" height="128"
style=" position: absolute; 
    top: 50%;    left: 50%;    margin-top: -50px;    margin-left: -50px;    width: 100px;    height: 100px;"
>

generator-subform button-subform

{object}
0.5,query.OPEN,button,0,0,:OPEN,,
{labelInLineStyle}display:inline;{/labelInLineStyle}
{subform}
input.jsp?mode=SINPUT&input=payment.txt&config='+ListSubFormConfig+'&config0=paymentConfig.txt&key=recordid&keyValue='+Xdata[thisRowNo]+'&timer=datetimr()
{/subform}
{colspan}2{/colspan}
{/object}

generator-variable

{saveValidation}
if (documentAction=='A'){
var s=lookupTable('CAN_AUTO_APPROVE_BY_DATE','SALES_ORDER_REPORT2.RECORDID',_lookup('query.PARENT_RECORDID'));
var s2=lookupTable('MAX_COST','BOM_LIST.RECORDID',RECORDID); 
var s3=_lookup('query.SOI_PO_COST')*1;
/*alert(' s2'+s2+' s3: '+s3); */
if (s==0 | s3>s2){alert(' Remark : This BOM Need Special Approve');}
}
{/saveValidation}


Standard
standard Template





sql Variable

where=where (status:`A`   or status:`D`   or status:`C`  or status:`S` or status:`R` or status:`P`) and PO_DDATE<:ADDDATE(curdate(), INTERVAL '+7+' DAY)


countChecked i.e. count the checked. and save to the countEhecked Variable

countChecked[0]
{countChecked}0{/countChecked}


USER
var notSameUser=(USER!=lookupTable('PAYEE_INPUT_USERNAME','VENDOR.RECORDID',RECORDID));Checked[0]

COMPANY_NAME
_refreshv2('SALES_HEADER.PAYMENT_METHOD_REMARK','Please send a crossed cheque made payable to “'+COMPANY_NAME+'”.' );


DISK_DOC_STATUS

endofload=if(DISK_DOC_STATUS!:'D'){document.getElementById('SALES_ORDER_INV_DESC_gridButton1').style.display : 'none';}



thisRowNo

a

this.id

 {refresh}DOCUMENT=($.trim(_lookup('this.id'))+'-'+$.trim(_lookup('PURCHASE_HEADER.VERSION'))).replace('-0',''); if (DOCUMENT==''){$("#printCaption0").css("disabled", "disabled" );}{/refresh}

generator-dependent

{object}
0.69,PURCHASE_HEADER.NURSERY_PERIOD,num.0,10%,200,Nursery Period,,
{toolTips}Nursery Period{/toolTips}
{alignRight}
{classGroup}PS{/classGroup}
{/object}


{object}
0.69,PURCHASE_HEADER.NURSERY_PERIOD_UOM,combo,5,3,,,
{combo}Day,Day,Week,Week,Month,Month{/combo}
{dependent}
{/object}

generator-sumtotal generator-total

generator-subtotal generator-sum

Sum 1 column Grand Total

{SumTotal}SumTotal('tableName()','this.id','this.id','query.DOMAIN_AMOUNT','query.DOMAIN_AMOUNT'){/SumTotal}


Sum Qty, price to amount and Grand Total

{SumTotal}SumTotal('tableName()','this..QTY','this..PRICE','this..AMOUNT','SUPPLIER_INVOICE_HEADER.AMOUNT',
1,'SUPPLIER_INVOICE_LINE',''){/SumTotal}

***********************************************

1.261,SALES_ORDER_INV_DESC.PRICE,text:GRID,10%,150,Price,,{numeric} {alignRight} {SumTotal}SumTotal('tableName()','this..QTY','this.id','this..AMOUNT'){/SumTotal}

Red Color Must 

generator-domain-amount

{object}
0.38,query.AMOUNT,text,10,50,Amount,,
{spaceLine}
{readonly}
{currency}{alignRight}
{endOfLoad}$('.query_AMOUNT_label').html('Amount ('+COMPANY_CUR+')');{/endOfLoad}
{/object}

generator-invisible generator-visible

{object}
1.361,SUPPLIER_INVOICE_LINE.CODE_RECORDID,text:GRID,0,150,CODE,,
{invisible}
{/object}


{visibleWhen}     PROCESSING_MODE=='D' {/visibleWhen}

{invisibleWhen}     PROCESSING_MODE=='D' | PROCESSING_MODE=='R' {/invisibleWhen}

{invisibleWhen}
(PROCESSING_MODE=='D' | PROCESSING_MODE=='R' | PROCESSING_MODE=='A') & CONFIGFILE!='customerInvoiceToInvoiceConfig.txt'
{/invisibleWhen}


{tdInLineStyle}display:none;{/tdInLineStyle}
{thInLineStyle}display:none;{/thInLineStyle}

{layoutInvisibleWhenPROCESSING_MODE}P,a,R,S{/layoutInvisibleWhenPROCESSING_MODE} Payment DnoteList

{buttonVisibleAlways}

{deleteButtonInvisibleAlways}

deleteVisible=1
deleteAction=withHeader

InvisibleRetrivalNumber=1

{invisibleWhen}{visibleWhen}
{invisibleWhenSearch}
{invisibleWhenBOM}B
{invisibleWhenRevoke}=R
{invisibleWhenActive} =a
{invisibleWhenSearch}=S
{invisibleWhenDraft} = D
{invisibleWhenPartial} =P
{invisibleWhenApprove}=A

invisibleButtonWhenNoRow('SALES_ORDER_INV_DESC','1_011','submit1');invisibleButtonWhenNoRow('SALES_ORDER_INV_DESC','1_011','submit2');

javascript-if

el=document.createElement('<'+tag+(type?' type='+type:'')+' name='+nme+' >');

var y = (x == 2 ? "yes" : "no");

jquery-not

$('button:not(#vView)').each(function() {this.disabled='disabled';})

generator-debug log

null
Select distinct recordid,if(isnull(TIMESTAMP),"",CONCAT(TIMESTAMP," ",SAVE_ACTION)) ,if(isnull(CONTENT),"",CONCAT(USER," - ",CONTENT)),USER,SAVE_ACTION from MESSAGE_VIEW0 where parent_recordid = D order by TIMESTAMP DESC
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'D' in 'where clause'
]);

null
Select distinct null from null where (status='A' or  status='D' or  status='F' or  status='R'  or status='P')  and (  (false  or ( DOC_NO like '%competition%')  or ( NO_2 like '%competition%')  or ( NAME like '%competition%') ))   order by null limit 25 offset 0
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'null where (status='A' or  status='D' or  status='F' or  status='R'  or status='' at line 1
]);

jQuery19108735514129512012_1430359737833([
['1419391286546',' HP ProDesk 600 G1 TWR<z><z>- Intel Core i7-4790 3.6G 8M HD 4600 CPU<z><z>- 4GB DDR3-1600 DIMM (1x4GB) RAM<z><z>- 1TB 7200 RPM 3.5 Hard Drive<z><z>- 1TB 7200 RPM 3.5 2nd Hard Drive<z><z>- AMD Radeon R9 255 2GB PCIe x16 GFX<z><z>- Slim SuperMulti Optical Disc Drive<z><z>- HP USB Keyboard - Win Taiwan<z><z>- HP USB Mouse<z><z>- Windows 7 Professional 32 bit OS DVD+ DRDVD<z><z>- Windows 7 Professional 64 bit OS DVD+ DRDVD<z><z>- Preload Microsoft Windows 7 Professional 32 bit (Traditional Chinese)'
Select distinct RECORDID,DESCRIPTION from SALES_ORDER_INV_DESC where 1=1  order by DESCRIPTION
java.sql.SQLException: Column Index out of range, 3 > 2. 
]);

you are only selecting a single column, yet you are trying to access the third column in your result.

Change getString(3) to getString(1) and you should be fine.

user action 
DATALOCK;
DATALOCK_HISTORY;

SELECT USER,TIMESTAMP FROM DB_LOG_BAK00  WHERE DATE(TIMESTAMP)=CURDATE() ;

view user login 

select login_time, login_date , login_id from erp.USER ORDER BY LOGIN_DATE;

database

select LOG  from DB_LOG WHERE DATE(TIMESTAMP)=CURDATE() AND LOG LIKE'%EXCEPT%';

select timestamp from DB_LOG WHERE DATE(TIMESTAMP)=CURDATE();
delete from GRN_LINE where  = 1425438570590 ;

SELECT LOG FROM DB_LOG WHERE LOG LIKE '%SQLException%'
AND  DATE(TIMESTAMP)=CURDATE()
;

MySQLSyntaxErrorException:view' doesn't exist
java.sql.SQLException: Lock wait timeout exceeded
java.sql.SQLException: Data truncated
java.sql.SQLException: Incorrect integer value:


javascript

var myWindowxx = window.open('', 'MsgWindow','_blank');
myWindowxx.document.write('abcd');

SELECT LOG FROM DB_LOG WHERE REC_NO=63;


/**************************/

DNOTE_NO='DNTP01503007'
RECORDID=1420525755409

SOHD_DNBODYOS.DESCRIPTION
<- SOHD_DNBODY <- SODNBODY < - DNBODY

SELECT DESCRIPTION FROM DNOTE_LINE WHERE DESCRIPTION LIKE '%GW%';
SELECT DN_DESC FROM DNBODY WHERE DN_DESC LIKE '%GW%';
SELECT DN_DESC FROM SODNBODY WHERE DN_DESC LIKE '%GW%';
SELECT DN_DESC FROM SOHD_DNBODY WHERE DN_DESC LIKE '%GW%';


SELECT DN_DESC FROM SOHD_DNBODYOS WHERE DN_DESC LIKE '%GW%';

SELECT DN_NO, DN_DESC,QD_NO FROM SOHD_DNBODY WHERE DN_DESC LIKE '%GW%'

SELECT DN_DESC,QD_NO,DNQTY,INVQTY FROM SOHD_DNBODY WHERE DN_DESC LIKE '%GW

SELECT QD_NO FROM SOHD_DNBODY WHERE QD_NO LIKE '%4125%'

SELECT QD_NO FROM SALES_ORDER_HEAD WHERE QD_NO LIKE '%4125%';

SELECT DNOTE_LINE.USER, DNOTE_LINE.TIMESTAMP,DNOTE_LINE.RECORDID,SO_RECORDID,SALES_ORDER_INV_DESC.RECORDID FROM DNOTE_LINE
LEFT JOIN SALES_ORDER_INV_DESC ON SALES_ORDER_INV_DESC.RECORDID=DNOTE_LINE.SO_RECORDID
WHERE DNOTE_LINE.PARENT_RECORDID=1420525755409;

SELECT RECORDID FROM SALES_ORDER_HEAD WHERE SALES_ORDER='SOTP01503001'; // 1420193987163
 SELECT RECORDID FROM SALES_ORDER_INV_DESC WHERE PARENT_RECORDID=1420193987163; //1420774626655
 SELECT * FROM DNOTE_LINE WHERE SO_RECORDID=1420774626655;



SELECT * FROM DNOTE_LINE WHERE SO_RECORDID=1420444533025;
SELECT RECORDID FROM SALES_ORDER_INV_DESC WHERE RECORDID=1420444533025;

UPDATE DNOTE_LINE SET SO_RECORDID=1420774626655 WHERE RECORDID=1420525762175;