]
Sent: Tuesday, February 27, 2001 2:22 PM
To: CF-Talk
Subject: RE: Building Cold Fusion Search - Dynamic SQL
The problem with this approach is that it ignores the relational model of
the two tables. Each record in empSkills will only have one value for
skillId, so you won't get any records lo
-Talk
Subject: RE: Building Cold Fusion Search - Dynamic SQL
The problem with this approach is that it ignores the relational model of
the two tables. Each record in empSkills will only have one value for
skillId, so you won't get any records looking for two values. You'll need to
do a self-j
alk
Subject: RE: Building Cold Fusion Search - Dynamic SQL
since a multiple select gives you nothing more than a list, try a list loop.
SELECT
e.empId,
es.skillId
FROM
emp e,
empSkills es
WHERE
e.empId=es.empId
http://www.crescotech.com
-Original Message
You know, I've tried this exact code, but it pulls up 0 records even though
I know there was at least one matching record.this confuses the heck out
of me. A lot of people have mentioned the POST - I only put the snippet in
here to show you how I'm passing itmy problem is with actually wr
since a multiple select gives you nothing more than a list, try a list loop.
SELECT
e.empId,
es.skillId
FROM
emp e,
empSkills es
WHERE
e.empId=es.empId
http://www.crescotech.com
-Original Message-
From: Kim Mayhall [mailto:[EMAIL PROTECTED]]
Sent
Phillip, her original code works, she just needs to make the form's method
"post"
- Original Message -
From: "Philip Arnold - ASP" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 27, 2001 3:49 AM
Subject: RE: B
..etc
That should do it
hope it helps
Alistair Davidson
Senior Web Developer
Rocom
www.rocomx.net
-Original Message-
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: 27 February 2001 11:49
To: CF-Talk
Subject: RE: Building Cold Fusion Search - Dynamic SQL
OK, I'm goi
OK, I'm going to break this down bit by bit
> I'm trying to build some sql statements based on selections from
> a list box:
>
>
> Skill1
> Skill2
> Skill3
> Skill4
> (etcthis size will vary as it's dynamically populated)
>
>
> A user can do a multiple select, so let
Hmmm, are you trimming the variables in the IN statement? Is skillId set to
CHAR or VARCHAR? If its CHAR you should check to make sure the values
themselves in the database don't have extra spaces.
If that's all correct, make sure your form's method is "post" and not "get".
That is,
- O
hmm.. maybe u hav to set #frmSkill# as array...
then put each skill into different variables
at yr query..
use AND for each isdefined(variables.skill)
hope this help..
cheers
han
- Original Message -
From: Kim Mayhall <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Tuesday, Feb
10 matches
Mail list logo