sql - Coldfusion - Comma delimiter with comma inside value -

-

i building list using sql data , trying make each value of list as: 'value1',value2','value,4' , on. problem using code:

(     select count(ns.ticket)     ns_trade ns     ns.[login]=mt.[login]         ,          <cfif qgetcommentsaccounting.recordcount gt 0>              ns.comment in ('#listchangedelims(qgetcommentsaccounting.list_comments, "','")#')         <cfelse>             1=2         </cfif> )as no_of_tickets_accounting

which works perfect except when value has comma inside 'value,4'. suggestions how solve that?

if both queries work on same database, way more kiss put them together. usually, should try as possible within database.

select      count(ns.ticket)      ns_trade ns      ns.[login] = mt.[login] ,      ns.comment in          (         select              comment                      tbl_comment                       report_type = <cfqueryparam value="#arguments.type#" cfsqltype="cf_sql_varchar">         ,              report_id = <cfqueryparam value="#arguments.report_id#" cfsqltype="cf_sql_integer">         )

Comments

Post a Comment

Popular posts from this blog

Upgrade php version of xampp not success -

-
today decided upgrade xampp new php version (5.6.11). have downloaded , configured based on google said. after resetting server, runs successfully. when check xampp's phpinfo, has not been updated. screenshot what have missed? back htdocs files , database. download xampp . uninstall xampp control panel. manually remove xampp folder partition. install back problem solved
Read more

c - Bitwise operation with (signed) enum value -

-
i using enumerator values flags: typedef enum { = 0x00, b = 0x01u, // u has no influence, expected c = 0x02u, // u has no influence, expected ... } enum_name; volatile unsigned char* reg = someaddress; *reg |= b; according misra-c:2004 bitwise operations shall not done signed type. unfortunately, compiler iar use signed int (or short or char) underlying type of enums, , option can find relates size, not signedness ("--enum-is-int"). according iar c/c++ development guide arm , pages 169 , 211, can define type of enum s if enable iar language extensions ( -e command-line option, or project > options > c/c++ compiler > language > allow iar extensions in ide). in particular, should define "sentinel" value, make sure compiler chooses correct type. prefers signed types, , uses smallest possible integer type, sentinel should largest positive integer corresponding unsigned integer type can describe. example, typedef enum ...
Read more

xslt - Unnest parent nodes by child node -

-
in xml there items 0-n attributes , item should copied each attribute new item 1 attribute. given xml this: <?xml version="1.0" encoding="utf-8" ?> <items> <item> <name>a</name> <attributes> <attribute> <key>attribute1</key> <value>1</value> </attribute> </attributes> </item> <item> <name>b</name> </item> <item> <name>c</name> <attributes> <attribute> <key>attribute1</key> <value>5</value> </attribute> <attribute> <key>attribute2</key> <value>2</value> </attribute> <attribute> <key>attri...
Read more