[Zope-DB] ZSQL Method - BUG

Smith, Neil (Worcester) Neil.Smith at npower.com
Mon Jun 28 03:57:01 EDT 2004

In fact this is a perfectly valid SQL statement.

It's just aliasing the table name person as dasaaeasa.


-----Original Message-----
From: Andreas Jung [mailto:lists at zopyx.com]
Sent: 26 June 2004 12:21
To: hawelek_tlen; zope at zope.org; zope-db at zope.org
Subject: Re: [Zope-DB] ZSQL Method - BUG

--On Samstag, 26. Juni 2004 13:06 Uhr +0200 hawelek_tlen <hawelek at tlen.pl> 

> Hi,
> I found a Bug in ZSQL Method,
> I use it with Oracle Connection and when put some simple SQL-Query, like
> select * from person dasaaeasa

This is not a valid SQL statement. Don't expect that every parser is smart 
to detect when you feed it with trash.


P.S. DON'T CROSSPOST to multiple lists
Andreas Jung
zopyx.com - Software Development and Consulting Andreas Jung
Zope-DB mailing list
Zope-DB at zope.org

This e-mail is provided for general information purposes only and does not constitute investment or transactional advice. For  the avoidance of doubt the contents of this e-mail are subject to contract and will not constitute a legally binding contract. 

The information contained in this e-mail is confidential and intended only for the use of the addressee. If the reader of this message is not the addressee, you are hereby notified that you have received this e-mail in error and you must not copy, disseminate, distribute, use or take any action as a result of the information contained in it.
If you have received this e-mail in error, please notify postmaster at npower.com (UK 01384 275454) and delete it immediately from your system.
Neither Npower nor any of the other companies in the RWE Innogy group from whom this e-mail originates accept any responsibility for losses or damage as a result of any viruses and it is your responsibility to check attachments (if any) for viruses.  Npower Limited Registered office: Windmill Hill Business Park, Whitehill Way, Swindon SN5 6PB. Registered in England and Wales: number 3653277. This e-mail may be sent on behalf of a member of the RWE Innogy group of companies.


More information about the Zope-DB mailing list