:)
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: 09 January 2004 10:49
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] No value given for one or more required
parameters
ignore me, i just realised what i'd done; changed the name of one of my
columns but forgot to update the query. working of two different
datasources, and it was using the old datasource when it worked, the new
one when it didn't.
doh!
"Paul
Fennell" To:
<[EMAIL PROTECTED]>
<[EMAIL PROTECTED] cc:
.com> Subject: RE: [ cf-dev ] No
value given for one or more required
parameters
09/01/2004
10:48
Please
respond to
dev
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]
--
** 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]
