A simple question, but I can't seem to find a simple answer in any of the
documentation...

How do you do a SELECT AS statement in a ZSQL method?

For example
SELECT FirstName + " " + LastName AS FullName

Whenever I use AS, I end up getting the SQL error "Two few parameters: x
expected" where is the number of AS expressions in my query.

I have tried the same query in Access on the same database and it works
fine.
I even tried to leave Access to do the query and then just let Zope treat
the query as a table.
SELECT * FROM MyQueryInAccessWhichUsesAsStatements
but I get the same error.

Can anyone help?

Thanks

Alex

==================================
Alex Bowyer
IT Consultant, Logica Australasia
Tel    : +61 2 9202 8130
Fax    : +61 2 9922 7466
E-mail : [EMAIL PROTECTED]
WWW    : http://www.logica.com.au/
==================================

_______________________________________________
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )

Reply via email to