Rohit Patra August 10, 2024 No Comments ColdFusion variables scope precedence ordering. Description:- If you use a variable name without a scope prefix, ColdFusion checks the scopes in the following order to find the variable.ColdFusion searches variables…
Rohit Patra August 3, 2024 2 Comments How to use the ORDER BY clause in an inner MS SQL? Sample Table:- emp_idemp_namejob_namedep_id68319KAYLINGPRESIDENT100166928BLAZEMANAGER300167858SCARLETANALYST200163679SANDRINECLERK2001 sql:- SELECT * FROM ( SELECT * FROM ( SELECT emp_id, emp_name, job_name, dep_id, ROW_NUMBER( ) OVER( ORDER BY dep_id ) AS…
Rohit Patra July 27, 2024 No Comments ColdFusion Operator precedence and evaluation ordering SequenceOperator Name1^2*, /3\4MOD, %5+, -6&7EQ, IS, ==, NEQ, !=, IS NOT, LT, <, LTE, LE, <=, GT, >, GTE, GE, >=, CONTAINS, DOES NOT CONTAIN8NOT,…
Rohit Patra July 20, 2024 No Comments How to prevent “+”, “-“, “e”, “E” character in input “type=number” When we use <input type="number"> in HTML form, it can accept some special characters also like +, -, e, E etc. If you don’t need…