Can you show me your criteria.add statments?
----- Original Message -----
From: jon * <[EMAIL PROTECTED]>
To: Turbine <[EMAIL PROTECTED]>
Sent: Tuesday, May 16, 2000 6:46 PM
Subject: BasePeer problem
> This is mostly for John McNally...
>
> Here is a problem I'm running into with MySQL...if I do this query, I get
> nothing back:
>
> SELECT
> SCARAB_PROJECT.PROJECT_ID, SCARAB_PROJECT.PROJECT_NAME
> FROM
> SCARAB_PROJECT, SCARAB_PROJECT_VISITOR
> WHERE
> SCARAB_PROJECT.PROJECT_ID='SCARAB_PROJECT_VISITOR.PROJECT_ID';
>
> but, if i remove the "'" from around the where clause, it works:
>
> SELECT
> SCARAB_PROJECT.PROJECT_ID, SCARAB_PROJECT.PROJECT_NAME
> FROM
> SCARAB_PROJECT, SCARAB_PROJECT_VISITOR
> WHERE
> SCARAB_PROJECT.PROJECT_ID=SCARAB_PROJECT_VISITOR.PROJECT_ID;
>
> I'm using the basepeer to build up this string...so, I don't have a lot of
> control over the addition of the single quotes...john, can you think of a
> way to fix this?
>
> thanks,
>
> -jon
>
> --
> Java Servlet Based - Open Source | Collab.Net
> Bug/Issue Tracking System | now hiring smart people
> <http://scarab.tigris.org/> | <http://Collab.Net/jobs/>
>
>
>
> ------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Problems?: [EMAIL PROTECTED]
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
