CTED]
Sent: Tuesday, August 16, 2005 4:37 PM
To: CF-Talk
Subject: Re: SQL help (updated)
You realize that this is essentially a db design issue - right? The
table shouldn't be holding lists of numbers - there should be a join
table that does that job. Right?
On 8/16/05, [EMAIL PROTECTED] &l
>That probably needs to be
> WHERE #idnumber# IN (MyColumn)
Ian,
Yes, I tried that. I had typoed my e-mail, but in my code I had the
parenthesis. That's what give the invalid comparison error. It doesn't seem
to recognize the field.
Dave
**
You realize that this is essentially a db design issue - right? The
table shouldn't be holding lists of numbers - there should be a join
table that does that job. Right?
On 8/16/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> Okay, I still need help, but I've resolve part of my problem. I'm ab
[EMAIL PROTECTED] wrote:
> Okay, I still need help, but I've resolve part of my problem. I'm able now
> to have the list of ID numbers in one field by themselves. So, my new field
> value (MyColumn) looks like this:
>
> '5,2,3,4,45,7'
>
> I still need a way using Query of Queries to extract o
SELECT *
FROM AllResults
WHERE #idnumber# in MyColumn
That probably needs to be
WHERE #idnumber# IN (MyColumn)
The values of an IN clause are supposed to be in parenthesis I believe. You
may also need to do something about the quotes if they are p
Okay, I still need help, but I've resolve part of my problem. I'm able now to
have the list of ID numbers in one field by themselves. So, my new field value
(MyColumn) looks like this:
'5,2,3,4,45,7'
I still need a way using Query of Queries to extract only the records that have
the 'idnumbe
> Had some incorrect info in there Carry on :-)
>
> Given the following journals with related documents.
>
> Journal A
>
> document1a - Jan 1, 2004
> document2a - Jan 2, 2003
> document3a - Dec 3, 2002
>
> Journal B
>
> document1b - Jan 3, 2001
> document2b - Jan 4, 2000
> document3b
Had some incorrect info in there Carry on :-)
Given the following journals with related documents.
Journal A
document1a - Jan 1, 2004
document2a - Jan 2, 2003
document3a - Dec 3, 2002
Journal B
document1b - Jan 3, 2001
document2b - Jan 4, 2000
document3b - Dec 2, 1999
Journal C
docu
8 matches
Mail list logo
