Announcement

**GGandhi** · 04-06-2016, 04:07 PM

Re: a5_mergeDataIntoTemplate with SQL ResultSet yields blank HTML

may be silly question:
did you define the template first?

**CarlMPearson** · 04-06-2016, 04:30 PM

Re: a5_mergeDataIntoTemplate with SQL ResultSet yields blank HTML

A5_Merge.jpg

fax_html is correct.
fax_html2 is blank.

merge_results show no errors for either.

Customer_Signature is INK text. Other fields are common.

**GGandhi** · 04-06-2016, 04:59 PM

Re: a5_mergeDataIntoTemplate with SQL ResultSet yields blank HTML

since I do not see the template definition in your last post I am posting the way I have done to clarify my answer

Code:

dim template as c
template = <<%html%
<html>
<head>
<title></title>
</head>
<body>
<table>
<thead>
<th>Last Name</th><th>First Name</th><th>Address</th><th>City</th><th>State></th><th>Zipcode</th>
</thead>
<tbody>
<tr>
<td>{ds.data("firstname")}</td><td>{ds.data("lastname")}</td><td>{ds.data("address")}</td><td>{ds.data("city")</td><td>{ds.data("State")}</td><td>{ds.data("zipcode")}</td>
</tr>
</tbody>
</table>
</body>
</html>
%html%
dim cn as sql::Connection
dim result as l = .f.
result = cn.Open("::Name::local_mySql")
if result then
	dim sqlSelect as c
	sqlSelect = "SELECT * FROM customer"
	result = cn.Execute(sqlSelect)
	if result then
		dim rs as sql::ResultSet
		rs = cn.ResultSet
		dim html as c
		html = a5_mergedataintotemplate(template, rs)
	end if
	showvar(html)
	cn.close()
end if

and the result is

Code:

<html>
<head>
<title></title>
</head>
<body>
<table>
<thead>
<th>Last Name</th><th>First Name</th><th>Address</th><th>City</th><th>State></th><th>Zipcode</th>
</thead>
<tbody>
<tr>
<td>govindan</td><td>gandhi</td><td>33 east end avenue</td><td>{ds.data("city")</td><td>ny</td><td>10028</td>
</tr>
</tbody>
</table>
</body>
</html>
<html>
<head>
<title></title>
</head>
<body>
<table>
<thead>
<th>Last Name</th><th>First Name</th><th>Address</th><th>City</th><th>State></th><th>Zipcode</th>
</thead>
<tr>
<td>govindan</td><td>gandhi</td><td>33 east end ave</td><td>{ds.data("city")</td><td>ny</td><td>10028</td>
</tr>
</table>
</body>
</html>
<html>
<head>
<title></title>
</head>
<body>
<table>
<thead>
<th>Last Name</th><th>First Name</th><th>Address</th><th>City</th><th>State></th><th>Zipcode</th>
</thead>
<tr>
<td>govindan</td><td>gg3</td><td></td><td>{ds.data("city")</td><td></td><td></td>
</tr>
</table>
</body>
</html>

while this is good, it needs to broken into three parts i will post those three parts in a minute.

**CarlMPearson** · 04-06-2016, 05:11 PM

Re: a5_mergeDataIntoTemplate with SQL ResultSet yields blank HTML

But you can see that I am building the XBasic dset array from the results_set using the same names.

The same html template is being used for both.

I have it all working using the intermediate dset array.

I didn't bother showing the messy template and all its CSS.

**GGandhi** · 04-06-2016, 05:17 PM

Re: a5_mergeDataIntoTemplate with SQL ResultSet yields blank HTML

okay then,
the way i do and it works is not to declare a pointer variable like dset[] and set the result_set data to it than
just call the ds pointer. even without declaring it
like
{ds.data("Manifest")} like that

hope it makes sense.

**CarlMPearson** · 04-06-2016, 05:25 PM

Re: a5_mergeDataIntoTemplate with SQL ResultSet yields blank HTML

I did both.

All of the HTML is coded as you showed, {ds.data("Manifest")} for each field.

In the first invocation of A5_merge ds is the dset.
In the second invocation, ds is the results_set.

Yeah, it has me confused, too.

**GGandhi** · 04-06-2016, 05:29 PM

Re: a5_mergeDataIntoTemplate with SQL ResultSet yields blank HTML

Code:

dim template as c
template = <<%html%

<li>
{ds.data("firstname")} {ds.data("lastname")}
</li>

%html%
dim cn as sql::Connection
dim result as l = .f.
result = cn.Open("::Name::local_mySql")
if result then
	dim sqlSelect as c
	sqlSelect = "SELECT * FROM customer"
	result = cn.Execute(sqlSelect)
	if result then
		dim rs as sql::ResultSet
		rs = cn.ResultSet
		dim html as c
		html = a5_mergedataintotemplate(template, rs)
	end if
	showvar(html)
	cn.close()
	end if

here is the code without anything - just naked.

and the result

Code:

<li>
govindan gandhi
</li>
<li>
govindan gandhi
</li>
<li>
govindan gg3
</li>

I will post a screencast if you like.

**GGandhi** · 04-06-2016, 05:34 PM

Re: a5_mergeDataIntoTemplate with SQL ResultSet yields blank HTML

http://screencast.com/t/kHn7wALdsRo9

take a look at this it is done in three parts so the head, body and the footer is combined to give the table.

Announcement

The Alpha Software Forum Participation Guidelines

a5_mergeDataIntoTemplate with SQL ResultSet yields blank HTML

a5_mergeDataIntoTemplate with SQL ResultSet yields blank HTML

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment