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]
