I do not get the gist of what you are trying to do (while skimming from my
office while I should be working), but one pointer:
You do not need to loop over a query to get a list of ids. Use the
ValueList() method. It takes a column:
cfset lstProposalIDs = ValueList(getproposals.proposalid) /
Molly,
Hi, there. I think that using a database alias will do the trick. If
you use this syntax:
CFQUERY name=getindiv datasource=sotl
SELECT #i# AS ProposalName
FROMgrades06
WHERE readerid = #session.readerid#
/CFQUERY
then you can refer to that column as
It does and it doesn't. . .cannot figure out why. . . it seems to work. . but
only returns the column name:
cfquery name=getindiv datasource=sotl
select #i# as grade
from grades06
where readerid = #session.readerid#
/cfquery
tdcfoutput#getindiv.grade#/cfoutput (the column name -- ex:
Molly,
cfquery name=getproposals datasource=sotl
select *
from proposal06
where readinggroup = #session.group#
and status = 1
order by proposalid asc
/cfquery
cfset proposals = ''
cfoutput query=getproposals
cfset proposals = '#listappend(proposals,proposalid)#'
/cfoutput
This
What database are you using? You need to name those columns differently.
In MySQL, even if you do a straight select on a column named 404, it's
going to return 404 for every row. However, if you name that column
col_404, it'll return the values you're looking for. I think you've got
a larger
All incredibly valid points!
Unfortunately very short on time. . .they (faculty) need to start grading
these things tomorrow evening. Starting closer to the beginning we
currently have the following:
1) oracle database
2) one table containing the proposals -- proposalid, readinggroup, proposal
I'm interested to know what happens in SQL+ or Toad if you run:
select 404 from proposals
I mean, am I understanding you right that you have a column in a
database named 404 (or some other number)??? I would expect, given 5
results from the above query, that you would get:
| --| |
| 1 |
with the db
structure. It looks like she will be going with the restructuring/join
approach advocated by the list.
Matthieu
-Original Message-
From: Ken Ferguson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 29, 2005 4:44 PM
To: CF-Talk
Subject: Re: HELP!! Query - Loop - List - Form
I am confused. Down in your code, you have cfif #FIELD# is 1. Where
should FIELD be coming from? Your getindiv query? Another of your
queries? The form that from the previous page?
-Original Message-
From: Molly Abraham [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 29, 2005
Okay. . . . just thought I'd jump in here. . . Matthieu is correct. . . I am
in the middle of trying to build bigger and better data structures to handle
what is admittedly a fairly simple task . . .but had dug myself so far into
a hole trying to set it up the wrong way there is NO WAY I could
10 matches
Mail list logo