Will,
I ended up creating a function that cleaned up the data and built a
structure out of it. It is in the office right now but i can send it to you
on Monday.
If you are trying to resolve the issue over the weekend, here are a few
pointers.
To resolve the empty list item issue, what I would
cfoutput query=Positions
cfset
PermissionList=Schedule,Chat,Calendar,Games,Staff,Accounting,Permissions,Forum,Profile,Store,Polls,BugCatcher,SQL,Hiring,Links,Newsletter,Comments,Lockdown
cfloop index=Permission list=#PermissionList# delimiters=,
a select query returns a list of all columns in #queryname.columnlist#
variable. loop over that. user array notation to return specific query
column values.
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
Phillip M. Vector wrote:
cfoutput query=Positions
cfset
That helps... a bit..
But not fully. What if I want to do something like this..
cfloop index=Permission list=#Position.columnlist#
cfset session.#Permission# = #Position.#Permission##
/cfloop
So I get ...
session.schedule = 0
session.calendar = 1
session.staff =
Basically the question becomes... How do I pull the value of a row that
I'm looping over and put it as part of another variable?
Phillip M. Vector wrote:
That helps... a bit..
But not fully. What if I want to do something like this..
cfloop index=Permission
All of the columns are returned in #queryname.columnlist# you can also
access column/row values with #queryname['columnname'][rowNumber]#
-Original Message-
From: Phillip M. Vector [mailto:[EMAIL PROTECTED]
Sent: Saturday, July 12, 2008 10:40 AM
To: CF-Talk
Subject: Looping over database
if Position query returns one row:
cfloop
cfset session[Permission] = Position[Permission]
/cfloop
with multiple row returned by Position query, you could do something like:
cfset session[Permission Position.currentRow] =
Position[Permission][Position.currentRow]
Azadi Saryev
Sabai-dee.com
Ok.. That works.. But why when I do a cfdump on session[Permission], I
get numbers (which I should) and when I do a #session[Permission]#, I
get a Complex object types cannot be converted to simple values?
Sorry for being dense... I still can't seem to pull the values from the
session over the
session[Permission] - Permission is a cf variable in this case, same as
session.#Permission#
session['Permission'] - refers to Permission key in session structure,
same as session.Permission
your Permission variable is list loop index. do you have that same loop
when you do the cfif ...?
Azadi
Hjdj
Sent from my iPhone
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
Sent from my iPhone
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
hey. change your signature already Newbie!
On Sat, Jul 12, 2008 at 12:48 PM, houseoffusion
[EMAIL PROTECTED] wrote:
Sent from my iPhone
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
I'm not sure what you are asking.
Here is the code I'm using.
table width=100% border=1
cfoutput query=Positions
cfset count=0
tr
td rowspan=4 class=tableheader
#position#
hmm... are you really still using FONT tags??? ever heard of CSS and
inline styles?
but that's beside the point...
here goes:
1) your query is named POSITIONS, but in your code you refer to it as
POSITION - no S on the end...
2) ... unless you refer to your var 'position' - but i have no idea
Azadi Saryev wrote:
hmm... are you really still using FONT tags??? ever heard of CSS and
inline styles?
but that's beside the point...
Yes.. I am for special circumstances. :)
here goes:
1) your query is named POSITIONS, but in your code you refer to it as
POSITION - no S on the end...
The project has now been updated. You could now do:
cfscript
attributes = StructNew();
attributes['id'] = 23
oXml.CreateElement('//[EMAIL PROTECTED]#theId#]', 'newelement', 'This
is some element content.', attributes);
/cfsript
You can also now supply an xml string to either
you need to reference the row as well:
cfif Positions[Permission][currentrow] EQ 1
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
Phillip M. Vector wrote:
Azadi Saryev wrote:
hmm... are you really still using FONT tags??? ever heard of CSS and
inline styles?
but that's beside
THANK YOU!! :) That did the trick. :)
Azadi Saryev wrote:
you need to reference the row as well:
cfif Positions[Permission][currentrow] EQ 1
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
Phillip M. Vector wrote:
Azadi Saryev wrote:
hmm... are you really still using
QoQ is only a subset of the SQL available in a full RDBMS. Heavier
lifting is usually better suited for SQL calls directly to your
database. I'm not saying it's impossible to solve this problem using
QoQ, I'm just saying it really looks like you should consider solving
this problem in the DB and
Will,
I ended up creating a function that cleaned up the data and built a
structure out of it. It is in the office right now but i can send it to you
on Monday.
Thanks dude! I posted again about resolving this issue, but it never went
through. :(
I blogged the solution, which looks like what
Hello all,
I've just started work at a company that is in the middle of moving to an agile
development process who use coldfusion, javascript and pl/sql.
I have a couple of questions where you hopefully will be able to point me in
the right direction ...
Given that most agile texts are
I use this:
http://tredosoft.com/Multiple_IE
You can install 3.0 through 6.0 as stand-alone. I then have IE 7 as my
system install.
On Fri, Jul 11, 2008 at 6:30 PM, Claude Schneegans
[EMAIL PROTECTED] wrote:
You might want to take a look at IE7 stand alone.
I will sure do.
Thanks.
--
On Sat, Jul 12, 2008 at 4:44 PM, Neb o'Gwbl [EMAIL PROTECTED]
wrote:
Hello all,
I've just started work at a company that is in the middle of moving to an
agile development process who use coldfusion, javascript and pl/sql.
I have a couple of questions where you hopefully will be able to
Easy question, I looked everywhere but do not know what to exactly search.
Anyhow, say you have an HTML Form, and a bunch of other variables in HTML are
they all undefined unless you submit the page? I did an example and I found
that is true but just want to make sure it is suppose to behave
24 matches
Mail list logo
