<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Alric Aneron wrote:
<blockquote cite="mid20051230173208.49590.qmail@web50210.mail.yahoo.com"
type="cite">hello,<br>
I have a python code that recieves two result objects from two
different ZSQL methods. I need to join them (sort of like UNION).<br>
I can't do result1+result2, otherwise it raises an exception that the +
operator isn't supported.<br>
When I try to do this (read below, I explained what i've done if you
are lazy to read the code)<br>
result1 = context.zsqlmethod1()<br>
result2 = context.zsqlmethod2()<br>
if (len(result1) == 0):<br>
return result2<br>
row1 = 0<br>
row2 = len(result1) + 1<br>
col = 0<br>
for r in result2:<br>
col = 0<br>
if (context.duplicateExists(result1, result2[row1][0]) == -1):<br>
result1[row2][col] = result2[row][col]<br>
col = col + 1<br>
row1 = row1 + 1<br>
row2 = row2 + 1<br>
<br>
return result1<br>
<br>
Basically, it loops through the rows and columns of result2 and adds
them to the end of th e result 1. However it for some reason raises
"index out of range" and says that assigning
result1[0][0]=result2[0][0] (if there is an element in both of them) is
illegal because:<br>
<strong>Error Value: object does not support item or slice assignment<br>
</strong>I realize that in most programming languages you can't add
them to result1 without resizing it first, but I can't find much
documentaiton on member functions of the result object, so I can't
resize it. <br>
I am completely stuck, I've tried everything, spent so much time on it,
can anyone please help save my sanity :P<br>
<br>
Thanks in advance guys! I really appreciate it.<br>
<p> </p>
<hr size="1"> <a
href="http://pa.yahoo.com/*http://us.rd.yahoo.com/evt=37474/*http://promo.yahoo.com/broadband/%20">Y</a></blockquote>
Alric,<br>
The merging of two zsql result sets is easy - here's one way:<br>
newResults = []<br>
<br>
for r in resultset1:<br>
newResults.append( r )<br>
<br>
for r in resultset2:<br>
newResults.append( r )<br>
<br>
return newResults.<br>
<br>
David<br>
<br>
<br>
<br>
<br>
<br>
</body>
</html>