Richard Broersma wrote:
>>> I have a piece of python code that excutes a SQL statement:
>>> apitempCur.execute("select * from jfcs_balancedue('%s') f(enrolleeid
>>> varchar,
>>> course_cost decimal, paid_amt decimal)" % (enrollIds,));
>>> The "enrollids" is a list of primary keys and the "jfcs
On Thursday 10 June 2010 06:46:46 am Little, Douglas wrote:
> First remove the python
> select * from jfcs_balancedue(parameter) f(enrolleeid varchar,course_cost
> decimal, paid_amt decimal)
>
> the jfcs_balancedue is a table function, f is the alias (with the column
> alias list/datatype of the c
First remove the python
select * from jfcs_balancedue(parameter) f(enrolleeid varchar,course_cost
decimal, paid_amt decimal)
the jfcs_balancedue is a table function, f is the alias (with the column alias
list/datatype of the columns returned by the function).
Doug
-Original Message-
On Thu, Jun 10, 2010 at 3:57 AM, Tim Landscheidt
wrote:
> John wrote:
>
>> I have a piece of python code that excutes a SQL statement:
>
>> apitempCur.execute("select * from jfcs_balancedue('%s') f(enrolleeid varchar,
>> course_cost decimal, paid_amt decimal)" % (enrollIds,));
>
>> The "enrollid
John wrote:
> I have a piece of python code that excutes a SQL statement:
> apitempCur.execute("select * from jfcs_balancedue('%s') f(enrolleeid varchar,
> course_cost decimal, paid_amt decimal)" % (enrollIds,));
> The "enrollids" is a list of primary keys and the "jfcs_balancedue" is a user
>
