Styjun

How do credit card companies know what type of business I'm paying for?

Sakkāya-Ditthi and Self-View

Are athletes' college degrees discounted by employers and graduate school admissions?

How many times to repeat an event with known probability before it has occurred a number of times

New Site Design!

Support Structures for Green beans and peas

Idiom for 'person who gets violent when drunk"

Do items with curse of vanishing disappear from shulker boxes?

Can an opamp have its own voltage regulator?

How can Caller ID be faked?

Can an open source licence be revoked if it violates employer's IP?

Bullying by school - Submitted PhD thesis but not allowed to proceed to viva until change to new supervisor

Should I worry about having my credit pulled multiple times while car shopping?

How do you translate “talk shit”?

Background for black and white chart

How did Avada Kedavra get its name?

How can religions without a hell discourage evil-doing?

Approach sick days in feedback meeting

Can I appeal credit ding if ex-wife is responsible for paying mortgage?

Can a 40amp breaker be used safely and without issue with a 40amp device on 6AWG wire?

Are soroban (Japanese abacus) classes worth doing?

Reflecting Telescope Blind Spot?

How to avoid offending original culture when making conculture inspired from original

What is the difference between state-based effects and effects on the stack?

How to show data from mysql in json response

How do I format a Microsoft JSON date?How can I pretty-print JSON in a shell script?How to parse JSON in JavaWhy does Google prepend while(1); to their JSON responses?Why can't Python parse this JSON data?How can I pretty-print JSON using JavaScript?How to parse JSON using Node.js?How do I POST JSON data with Curl from a terminal/commandline to Test Spring REST?How do I get ASP.NET Web API to return JSON instead of XML using Chrome?How do I write JSON data to a file?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

Hi all i am working on json to send data i had from a mysql query back to facebook bot, i just want o know if this looks right as i cant get the data to show in the results area

app.get("/Getcompany", function(request, response) 
 const cname = request.query.cname, query = `select * from clientdata_nsw where companyname = $connection.escape(
 cname
 )`;
 connection.query(query, function(err, rows) 
 if (err) 
 console.log(err);
 return;
 
 console.log(cname);

 rows.forEach(function(result) 
 console.log(
 result.companyname,
 result.service,
 result.phone,
 result.open_times,
 result.rating_facebook,
 result.rating_goggle
 );
 );
 response.json(

 "version": "v2",
 "content": 
 "messages": [
 
 "type": "text",
 "text": "Company: result.companynamenPhone: result.phonenService:  result.servicenOpen: result.open_timesnFacebook: result.rating_facebook StarnGoogle: result.rating_goggle Star",

 

 ]
 
)
 );

)

node.js json

share|improve this question

asked Mar 25 at 2:36

Adam WolarczukAdam Wolarczuk

136

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  result.companyname will just be a string. use template literal instead, `$somevariable`
  
  – 1556089774
  Mar 25 at 16:50
  

  
  
  
  

add a comment | 

0

Hi all i am working on json to send data i had from a mysql query back to facebook bot, i just want o know if this looks right as i cant get the data to show in the results area

app.get("/Getcompany", function(request, response) 
 const cname = request.query.cname, query = `select * from clientdata_nsw where companyname = $connection.escape(
 cname
 )`;
 connection.query(query, function(err, rows) 
 if (err) 
 console.log(err);
 return;
 
 console.log(cname);

 rows.forEach(function(result) 
 console.log(
 result.companyname,
 result.service,
 result.phone,
 result.open_times,
 result.rating_facebook,
 result.rating_goggle
 );
 );
 response.json(

 "version": "v2",
 "content": 
 "messages": [
 
 "type": "text",
 "text": "Company: result.companynamenPhone: result.phonenService:  result.servicenOpen: result.open_timesnFacebook: result.rating_facebook StarnGoogle: result.rating_goggle Star",

 

 ]
 
)
 );

)

node.js json

share|improve this question

asked Mar 25 at 2:36

Adam WolarczukAdam Wolarczuk

136

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  result.companyname will just be a string. use template literal instead, `$somevariable`
  
  – 1556089774
  Mar 25 at 16:50
  

  
  
  
  

add a comment | 

Hi all i am working on json to send data i had from a mysql query back to facebook bot, i just want o know if this looks right as i cant get the data to show in the results area

app.get("/Getcompany", function(request, response) 
 const cname = request.query.cname, query = `select * from clientdata_nsw where companyname = $connection.escape(
 cname
 )`;
 connection.query(query, function(err, rows) 
 if (err) 
 console.log(err);
 return;
 
 console.log(cname);

 rows.forEach(function(result) 
 console.log(
 result.companyname,
 result.service,
 result.phone,
 result.open_times,
 result.rating_facebook,
 result.rating_goggle
 );
 );
 response.json(

 "version": "v2",
 "content": 
 "messages": [
 
 "type": "text",
 "text": "Company: result.companynamenPhone: result.phonenService:  result.servicenOpen: result.open_timesnFacebook: result.rating_facebook StarnGoogle: result.rating_goggle Star",

 

 ]
 
)
 );

)

node.js json

share|improve this question

asked Mar 25 at 2:36

Adam WolarczukAdam Wolarczuk

136

app.get("/Getcompany", function(request, response) 
 const cname = request.query.cname, query = `select * from clientdata_nsw where companyname = $connection.escape(
 cname
 )`;
 connection.query(query, function(err, rows) 
 if (err) 
 console.log(err);
 return;
 
 console.log(cname);

 rows.forEach(function(result) 
 console.log(
 result.companyname,
 result.service,
 result.phone,
 result.open_times,
 result.rating_facebook,
 result.rating_goggle
 );
 );
 response.json(

 "version": "v2",
 "content": 
 "messages": [
 
 "type": "text",
 "text": "Company: result.companynamenPhone: result.phonenService:  result.servicenOpen: result.open_timesnFacebook: result.rating_facebook StarnGoogle: result.rating_goggle Star",

 

 ]
 
)
 );

)

share|improve this question

asked Mar 25 at 2:36

Adam WolarczukAdam Wolarczuk

136

share|improve this question

asked Mar 25 at 2:36

Adam WolarczukAdam Wolarczuk

136

asked Mar 25 at 2:36

Adam WolarczukAdam Wolarczuk

136

asked Mar 25 at 2:36

Adam WolarczukAdam Wolarczuk

136