On Mar 23, 2013, at 00:51, Adva wrote:
> בתאריך יום שבת, 23 במרץ 2013 00:49:23 UTC+2, מאת ryandesign:
>
>> On Mar 22, 2013, at 13:48, Adva wrote:
>>
>> > im executing a stored procedre in node.js using jsonStringify to show the
>> > results in the console.
>> > but now i want to put the results in a html table using tr and td.
>> > how can i do it? thank you!
>>
>> What have you tried so far? Show us your code.
>
> this is my code:
> i turn it to csv file. but now i want the results in a table and not in csv
> file:
>
>
> exports.email = function (req, res) {
> var sql = require('msnodesql');
> var conn_str = "Driver=SQL Server Native Client
> 10.0;Server=toyga-app02\\toyga;Database=ToygaDev;Trusted_Connection=Yes";
>
> sql.open(conn_str, function (err, conn) {
> if (err) {
> console.log("Database connection failed!");
> return;
> }
>
> conn.query("GetEmailTemplatesStatistics2 ?,?", dates, function (err,
> results) {
> if (err) {
> console.log("Error running query!");
> console.log(err);
> return;
> }
> if (!res.headersSent) {
> res.setHeader('Content-type', 'application/CSV');
> res.setHeader('content-disposition', 'attachment;
> filename=report.csv');
> }
>
> var firstRow = results[0];
> for (var item in firstRow) {
> res.write(item + ",");
> }
> res.write("\n");
>
>
> for (var i = 0; i < results.length; i++) {
> var row = results[i];
> for (var item in row) {
> res.write(row[item] + ",");
> }
> res.write("\n");
> }
>
> res.end('');
> });
> });
> }
So what's the problem? It looks fairly straightforward. You'll change the
content-type to text/html, and then you'll output your HTML, which you can
build up with res.write() just like you're building up the CSV now. Assuming
you want the HTML displayed in the browser instead of being downloaded to the
user's disk, you'll want to stop setting the content-disposition.
--
--
Job Board: http://jobs.nodejs.org/
Posting guidelines:
https://github.com/joyent/node/wiki/Mailing-List-Posting-Guidelines
You received this message because you are subscribed to the Google
Groups "nodejs" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/nodejs?hl=en?hl=en
---
You received this message because you are subscribed to the Google Groups
"nodejs" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
