Nevermind it was a laps of brain matter I was using access but now I'm using
SQL server and the value true or false is really 1or 0 in SQL. Jeez!
Thanks All!
;) Mark
----- Original Message -----
From: "Mark Adams" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, May 02, 2001 2:53 PM
Subject: SQL troubles
> I'm pulling out my hair can anyone see whats up here?
>
>
> "SELECT Assets.Course_ID, Assets.Module_ID, Assets.Lesson_ID,
Assets.Screen_ID, Assets.Form_ID, Assets.Asset_ID, Assets.Prose,
Assets.Reuse, Assets.Asset_Type, Screen.Reviewed FROM Assets INNER JOIN
Screen ON (Assets.Screen_ID = Screen.Screen_ID) AND (Assets.Lesson_ID =
Screen.Lesson_ID) AND (Assets.Module_ID = Screen.Module_ID) AND
(Assets.Course_ID = Screen.Course_ID) WHERE (((Screen.Reviewed)=True));"
>
> Running really low on hair at this point! AAAAAAAAAHHHHHHHHHH!!!
>
> Thanks for any help! :)
>
> -Mark
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
