crossdb-developers

RE: [Crossdb-developers] Missing Enclosing Quotes

[<tr...@th...>]

Hi Adam,

Use the addWhereString method to compare to a string, if you use addWhereCondition, it treats the strings as column names. 

Travis

---- Original Message ----
From: Adam Sherman <ad...@tr...>
Sent: 2003-01-13
To: cro...@li...
Subject: [Crossdb-developers] Missing Enclosing Quotes

Using the November 11th release and the hsqldb implementation.

My queries containing comparisons to Strings are missing the quotes:

SELECT id,name,family,location,floorArea,bedrooms,price FROM models WHERE  
(location  = Adult LifeStyle )  ORDER BY name
             ^^^^^^^^^^^^^^^
Is this normal behaviour?

Thanks,

A.

P.S. I tried building current CVS, but am not sure how to install Maven to 
complete the build process.

-- 
Adam Sherman
Tritus CG Inc.
http://www.tritus.ca/
+1 (613) 797-6819



-------------------------------------------------------
This SF.NET email is sponsored by: FREE  SSL Guide from Thawte
are you planning your Web Server Security? Click here to get a FREE
Thawte SSL guide and find the answers to all your  SSL security issues.
http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0026en
_______________________________________________
Crossdb-developers mailing list
Cro...@li...
https://lists.sourceforge.net/lists/listinfo/crossdb-developers

Re: [Crossdb-developers] Missing Enclosing Quotes

[Adam S. <ad...@tr...>]

On Monday 13 January 2003 16:56, tr...@th... wrote:
> Use the addWhereString method to compare to a string, if you use
> addWhereCondition, it treats the strings as column names.

Ah! This explains much.

However, I'm using WhereCondition objects everywhere. Is this not the pro=
per=20
way?

Thanks,

A.

--=20
Adam Sherman
Tritus CG Inc.
http://www.tritus.ca/
+1 (613) 797-6819

Re: [Crossdb-developers] Missing Enclosing Quotes

[Adam S. <ad...@tr...>]

On Monday 13 January 2003 17:10, Adam Sherman wrote:
> On Monday 13 January 2003 16:56, tr...@th... wrote:
> > Use the addWhereString method to compare to a string, if you use
> > addWhereCondition, it treats the strings as column names.

> However, I'm using WhereCondition objects everywhere. Is this not the
> proper way?

Actually, I realise that I'm using WhereClause objects to build queries l=
ike=20
"WHERE (a =3D s AND b =3D s) OR (a =3D s AND b =3D s", how do I do this u=
sing=20
SelectQuery.addWhereString()?

Thanks,

A.

--=20
Adam Sherman
Tritus CG Inc.
http://www.tritus.ca/
+1 (613) 797-6819