----- Original Message -----
From: "Bowyer, Alex" <[EMAIL PROTECTED]>
> 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

hmm... shouldn't that be

    SELECT FirstName || " " || LastName as FullName

I am bit unsure of the proper syntax (I am mostly working with Oracle), but
I think you use "||" to concatenate two strings in SQL.

- --------------------------------------------------------------------
Dario Lopez-Kästen     Systems Developer  Chalmers Univ. of Technology
[EMAIL PROTECTED]  ICQ will yield no hits    IT Systems & Services

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

Reply via email to