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