[Ur] [Bulk] Re: urblog

[Manu]

gdp3 at cs.waikato.ac.nz wrote:
>> manu at chleb:~/Code/Ur/urblog$ ./urblog.exe
>> Fatal initialization error: Unable to create prepared statement:
>> SELECT User.uw_DisplayName, User.uw_Id, User.uw_Password,
>> User.uw_Username FROM uw_Urblog_user AS User WHERE ((User.uw_id =
>> $1::int8) AND (User.uw_password = $2::text))
>> ERROR:  syntax error at or near "."
>> LINE 1: SELECT User.uw_DisplayName, User.uw_Id, User.uw_Password, Us...
>>                    ^
>>
>>
>> Has this to do with the special version of the compiler Gian's been using
>> ?
>>     
>
> Unlikely.  I compiled Urblog with the last two public releases of the
> compiler with no trouble.  The special versions of the compiler were just
> versions with bug fixes that have since been applied in the most recent
> releases.  I suspect that more information about the specific
> platform/database environment might be helpful to diagnosing this.
>
> Gian
>   


Hi Gian,

it seems I cannot alias tables with the User

for instance the folowing works fine

SELECT Aser.uw_id FROM uw_Urblog_comment AS Aser

but not this:

SELECT User.uw_id FROM uw_Urblog_comment AS User

Manu