Hi. . . hope someone can help. . . (PLEASE BEAR WITH ME -- THIS IS ALL
HIGGLEDYPIGGLEDY) we are having a problem displaying the value of a query
variable. . it seems really confusing, and it is - but unfortunately this is
the simplest way we can think of to do this.
Our goal is to run a
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
:13 AM
To: CF-Talk
Subject: HELP!! Query - Loop - List - Form Madness
Hi. . . hope someone can help. . . (PLEASE BEAR WITH ME --
THIS IS ALL HIGGLEDYPIGGLEDY) we are having a problem
displaying the value of a query variable. . it seems really
confusing, and it is - but unfortunately
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
Hi,
Up until now I had a nice little loop list going.
cfloop list=#GetArticle.articleLinks#
index=myLink
cfoutputa href=#myLink#
class=contentarearight target=new#myLink#/abr/cfoutput
/cfloop
Now i have decided to have another field in my
cfloop from=1 to=listlen(listA) index=i
a href=#listGetAt(listA,i)##listGetAt(listB,i)#/a
/cfloop
-Original Message-
From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 22, 2005 11:14 AM
To: CF-Talk
Subject: loop list
Hi,
Up until now I had a nice
Yes, that is not the best set-up. Assuming both lists contained the same
number of items, maybe something like this?
cfloop from=1 to=#listLen(GetArticle.articleLinks)# index=i
cfset myLink = listGetAt(GetArticle.articleLinks,i)
cfset myLinkText =
I'm back with another question ( imagine that :)
First i would like to say thanks to everyone that has helped me so far a lot of things
have worked great!
what i have is a form that has 6 selection box's (all multiple select box's) which
list's all of the contestans in a circuit.
if i select
15 matches
Mail list logo