Reply to thread

Message

<blockquote data-quote="sliit_kolla" data-source="post: 22904323" data-attributes="member: 563729">JS walata mama tikak aul<img src="/styles/default/xenforo/smilies/default/sad.gif"&nbsp; class="smilie" loading="lazy" alt=":(" title="Sad&nbsp; &nbsp; :(" data-shortname=":(" /> podi help ekak one.me thiyenne mage node eka peththe thiyena function ekaka body ekak (sampoorna kotasam demme ne)const sql = &nbsp;&nbsp; `SELECT names&nbsp; &nbsp; FROM&nbsp; Students&nbsp; &nbsp; WHERE JSON_EXTRACT(names, '$.name') LIKE ? `&nbsp; const values = [beginningLetter]&nbsp; &nbsp; const query = connection.query(sql, values, (error, results, fields) =&gt; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; connection.end()&nbsp; &nbsp; &nbsp; if (error) {&nbsp; &nbsp; &nbsp; &nbsp; return reject(error)&nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; resolve(results)&nbsp; &nbsp; })&nbsp; })&nbsp; &nbsp; .then((results) =&gt; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return {&nbsp; &nbsp; &nbsp; &nbsp; type: 'name',&nbsp; &nbsp; &nbsp; &nbsp; attributes: results&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }meken ena output eka me wge{&nbsp; &quot;data&quot;: {&nbsp; &nbsp; &quot;type&quot;: &quot;name&quot;,&nbsp; &nbsp; &quot;attributes&quot;: [&nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &quot;names&quot;: &quot;{\&quot;name\&quot;: \&quot;kamal perera\&quot;, \&quot;realFormat\&quot;: \&quot;Kamal Perera\&quot;}&quot;&nbsp; &nbsp; &nbsp; },&nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &quot;names&quot;: &quot;{\&quot;name\&quot;: \&quot;nimal lakmal\&quot;, \&quot;realFormat\&quot;: \&quot;Nimal Lakmal\&quot;}&quot;&nbsp; &nbsp; &nbsp; },&nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &quot;names&quot;: &quot;{\&quot;name\&quot;: \&quot;venura gunathilaka\&quot;, \&quot;realFormat\&quot;: \&quot;Venura Gunathilake\&quot;}&quot;&nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; ]&nbsp; }}namuth mata one oka me widiyata hadaganna{&nbsp; &quot;data&quot;: [&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &quot;type&quot;: &quot;name&quot;,&nbsp; &nbsp; &nbsp; &quot;attributes&quot;: {&nbsp; &nbsp; &nbsp; &nbsp; &quot;name&quot;: &quot;nimal lakmal&quot;,&nbsp; &nbsp; &nbsp; &nbsp; &quot;realFormat&quot;: &quot;Nimal Lakmal&quot;&nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; },&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &quot;type&quot;: &quot;name&quot;,&nbsp; &nbsp; &nbsp; &quot;attributes&quot;: {&nbsp; &nbsp; &nbsp; &nbsp; &quot;name&quot;: &quot;venura gunathilake&quot;,&nbsp; &nbsp; &nbsp; &nbsp; &quot;realFormat&quot;: &quot;Venura Gunathilake&quot;&nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }&nbsp; &nbsp; }&nbsp; ]}udin mama daala thiyena .then((results) eka ethule wenas wenna one widiya poddak kiala dennako..bump ekak daanna anith aya</blockquote>

[QUOTE="sliit_kolla, post: 22904323, member: 563729"] JS walata mama tikak aul:( podi help ekak one. me thiyenne mage node eka peththe thiyena function ekaka body ekak (sampoorna kotasam demme ne) const sql = `SELECT names FROM Students WHERE JSON_EXTRACT(names, '$.name') LIKE ? ` const values = [beginningLetter] const query = connection.query(sql, values, (error, results, fields) => { connection.end() if (error) { return reject(error) } resolve(results) }) }) .then((results) => { return { type: 'name', attributes: results } meken ena output eka me wge { "data": { "type": "name", "attributes": [ { "names": "{\"name\": \"kamal perera\", \"realFormat\": \"Kamal Perera\"}" }, { "names": "{\"name\": \"nimal lakmal\", \"realFormat\": \"Nimal Lakmal\"}" }, { "names": "{\"name\": \"venura gunathilaka\", \"realFormat\": \"Venura Gunathilake\"}" } ] } } namuth mata one oka me widiyata hadaganna { "data": [ { "type": "name", "attributes": { "name": "nimal lakmal", "realFormat": "Nimal Lakmal" } }, { "type": "name", "attributes": { "name": "venura gunathilake", "realFormat": "Venura Gunathilake" } } } ] } udin mama daala thiyena .then((results) eka ethule wenas wenna one widiya poddak kiala dennako..bump ekak daanna anith aya [/QUOTE]

Verification

Winadiyakata thappara keeyak tibeda?

Search

Latest ads

Reply to thread