At a guess IS or EQ true ? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 09 January 2004 10:43 To: [EMAIL PROTECTED] Subject: [ cf-dev ] No value given for one or more required parameters
Got a query which worked fine. Something along the lines of: SELECT Projects.ID, Projects.Title, Categories.ID AS CategoryID, Categories.Title as CategoryTitle FROM Projects, Categories WHERE Projects.CategoryID = Categories.ID AND Categories.ID = #URL.ID# This worked fine, but I thought I'd use table aliases, so changed it to SELECT P.ID, P.Title, PC.ID AS CategoryID, PC.Title as CategoryTitle FROM Projects P, Categories PC WHERE P.CategoryID = PC.ID AND PC.ID = #URL.ID# After which it started giving the error: OLEDB Error Code = 0 No value given for one or more required parameters. So I changed it back, and it worked fine again... Then I added an extra clause to the WHERE statement, checking for a Boolean value. After which it started throwing the same error. All I added was: AND Projects.Active = TRUE I know the field exists, I know it's boolean, I can't figure out why this is throwing up the error. A different query on the projects table checking for Active = TRUE works fine: SELECT * FROM Projects where active = true any ideas, this is very bugging Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world ---------------------------------------------------------------------- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! ---------------------------------------------------------------------- ---------------------------------------------------------------------- -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.559 / Virus Database: 351 - Release Date: 07/01/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.559 / Virus Database: 351 - Release Date: 07/01/2004 -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
