Re: looping over PDF subforms

2014-07-16 Thread Dave Watts
> So I'm still trying to produce a section 508 Compliant PDF using > cfdocument, or cfpdf or something > > I know there are methods to populate pre defined PDF forms, which would > work except that alot of my data is multiple row format and I don't know > how many rows may be returned and I ca

Re: looping over PDF subforms

2014-07-16 Thread Scott Stewart
We've got a temporary waiver to figure it out, but we can't push it off for much longer On Wed, Jul 16, 2014 at 4:32 PM, Randi Knutson wrote: > > Fair enough. I got my client to exempt "on the fly" pdfs from 508 > requirements. Although CF11/Splendor has some nice enhancements. > > PDFs and CF

Re: looping over PDF subforms

2014-07-16 Thread Randi Knutson
Fair enough. I got my client to exempt "on the fly" pdfs from 508 requirements. Although CF11/Splendor has some nice enhancements. PDFs and CF do seem to be a niche, at least in Adobe's eyes. I think they are badly underestimating it, but if only I ran the world...everything would be nice then

Re: looping over PDF subforms

2014-07-16 Thread Scott Stewart
I can generate HTML tables and such all day long and use CFDOCUMENT to turn it into a PDF, but it's not 508 Compliant because CFDOCUMENT doesn't support tagging, My thought is to create predefined PDFs that are compliant and populate them like you would a PDF Formthen merge the whole mess tog

Re: looping over PDF subforms

2014-07-16 Thread Randi Knutson
I am...I just have a cfdocumentsection within a cfloop that is looping through however many rows my query returned. Sometimes the page breaks can get goofy if there is a lot of data, in which case I test for greater than however many rows I can fit and insert a page break. cf-talk@houseoffus

Re: looping through an insert statement

2010-10-26 Thread Bryan Stevenson
*big grin* ;-) On Tue, 2010-10-26 at 14:25 -0700, Rick Colman wrote: > It is more than possible, it is likely ... typo ... > > SORRY > > On 10/26/2010 12:38 PM, Michael Grant wrote: > > Is it at all possible you've got the table name incorrect? > > > > On Tue, Oct 26, 2010 at 2:24 PM, Ric

Re: looping through an insert statement

2010-10-26 Thread Bryan Stevenson
BTW...I have seen invalid object when queries are malformedsee post your real query ;-) I'm not trying to be a tool by asking for it...all it takes is a comma out of place and things go wrong. There have been many occasions where I was a certain about the details of my "real" code that I did

Re: looping through an insert statement

2010-10-26 Thread Rick Colman
It is more than possible, it is likely ... typo ... SORRY On 10/26/2010 12:38 PM, Michael Grant wrote: > Is it at all possible you've got the table name incorrect? > > On Tue, Oct 26, 2010 at 2:24 PM, Rick Colman wrote: > >> ok, maybe I am cross-eyed and (tried matching cases), but: >> >>

Re: looping through an insert statement

2010-10-26 Thread Bryan Stevenson
Rickjust relax man.you want help you will have to answer questionsno matter how obvious they may be. Clearly you can't figure it out and you have the real codewe only have your pseudo code and are not inside your head 'nuff said On Tue, 2010-10-26 at 14:17 -0700, Rick Colman wr

Re: looping through an insert statement

2010-10-26 Thread Rick Colman
yes , yes (arghhh!!) On 10/26/2010 12:35 PM, Bryan Stevenson wrote: > ...and you have verified that the table name is in fact > "ProteinSequence"? and that your datasource is pointing at the correct > DB? > > an invalid object error does seem to point to the DB/table > > On Tue, 2010-10-26 a

Re: looping through an insert statement

2010-10-26 Thread Rick Colman
sdalifsdaifasifsadi which is what it should be ... On 10/26/2010 11:55 AM, Michael Grant wrote: > #form['ProteinSequence'&1]# ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/d

Re: looping through an insert statement

2010-10-26 Thread Rick Colman
here it is: struct COMMONNAME1 Bacillus subtilis EXPORG_ID1 314 FIELDNAMES NUM_GENES,PROJECTNAME,PURPOSE,GENENAME1,PROTEINSEQUENCE1,NOAMINOACIDS1,GENENAME2,PROTEINSEQUENCE2,NOAMINOACIDS2,EXPORG_ID1,COMMONNAME1,NOTES GENENAME1 g1 GENENAME2 g2 NOAMINOACIDS1 15 NOAMINOACID

Re: looping through an insert statement

2010-10-26 Thread Michael Grant
Is it at all possible you've got the table name incorrect? On Tue, Oct 26, 2010 at 2:24 PM, Rick Colman wrote: > > ok, maybe I am cross-eyed and (tried matching cases), but: > > PROTEINSEQUENCE1sdalifsdaifasifsadi > > equals > > '#form['ProteinSequence'& LoopCount]#', > > which is cal

Re: looping through an insert statement

2010-10-26 Thread Bryan Stevenson
...and you have verified that the table name is in fact "ProteinSequence"? and that your datasource is pointing at the correct DB? an invalid object error does seem to point to the DB/table On Tue, 2010-10-26 at 11:24 -0700, Rick Colman wrote: > ok, maybe I am cross-eyed and (tried matching cas

Re: looping through an insert statement

2010-10-26 Thread Michael Grant
Diagnostics time. take the loop and the query right out of it, what happens when you add this at the top of your page: #form['ProteinSequence' & 1]# On Tue, Oct 26, 2010 at 2:24 PM, Rick Colman wrote: > > ok, maybe I am cross-eyed and (tried matching cases), but: > > PROTEINSEQUENCE1

Re: looping through an insert statement

2010-10-26 Thread Carl Von Stetten
Rick, Can you provide a dump of the FORM scope? Thanks, Carl >ok, maybe I am cross-eyed and (tried matching cases), but: > >PROTEINSEQUENCE1 sdalifsdaifasifsadi > >equals > >'#form['ProteinSequence'& LoopCount]#', > >which is called AA_sequence in the data table as shown below > >Insert

Re: looping through an insert statement

2010-10-26 Thread Rick Colman
ok, maybe I am cross-eyed and (tried matching cases), but: PROTEINSEQUENCE1sdalifsdaifasifsadi equals '#form['ProteinSequence'& LoopCount]#', which is called AA_sequence in the data table as shown below Insert into ProteinSequence (Project_ID, AA_Sequence, ... this all seems to mat

Re: looping through an insert statement

2010-10-26 Thread Bryan Stevenson
Well I know you said in another post that the form elements are all there, but this error disagrees with you ;-) So it's time to check variable spellingpossibly caseother obvious yet silly things ...and of course you want to make sure that the complete set of form elements exist for ALL

Re: looping through an insert statement

2010-10-26 Thread Michael Grant
what happens if you put those into 's? On Tue, Oct 26, 2010 at 2:07 PM, Rick Colman wrote: > > actually, two are int, so revised, but still did not work: > > > Error Executing Database Query. > > [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name > 'ProteinSequence'. > The erro

Re: looping through an insert statement

2010-10-26 Thread Rick Colman
yes, thank you, the form variables are actually there. On 10/26/2010 11:05 AM, Greg Morphis wrote: > Those are all coming from a form so have you tried dumping the form scope? > Make sure proteinsequence exists in the form > On Oct 26, 2010 12:59 PM, "Rick Colman" wrote: >> It seems to die on th

Re: looping through an insert statement

2010-10-26 Thread Rick Colman
actually, two are int, so revised, but still did not work: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'ProteinSequence'. The error occurred in*C:\inetpub\wwwroot\sttr2\orders\neworder_main_confirm_action.cfm: line 77* 75 : '#form['Pr

Re: looping through an insert statement

2010-10-26 Thread Greg Morphis
Those are all coming from a form so have you tried dumping the form scope? Make sure proteinsequence exists in the form On Oct 26, 2010 12:59 PM, "Rick Colman" wrote: > > It seems to die on the first loop because nothing gets inserted. Cfdump > shows the proper form variables being passed. > > >

Re: looping through an insert statement

2010-10-26 Thread Michael Grant
And Project_ID, AA_Sequence, Gene_Name and Count are all string fields? On Tue, Oct 26, 2010 at 1:58 PM, Rick Colman wrote: > > It seems to die on the first loop because nothing gets inserted. Cfdump > shows the proper form variables being passed. > > > > username="#request.dsn_username#" pa

Re: looping through an insert statement

2010-10-26 Thread Rick Colman
It seems to die on the first loop because nothing gets inserted. Cfdump shows the proper form variables being passed. Insert into ProteinSequence (Project_ID, AA_Sequence, Gene_Name, Count) Values( '#thisprojectid#', '#form["ProteinSequence" & LoopCount]#', '#f

Re: looping through an insert statement

2010-10-26 Thread Bryan Stevenson
1) can you expand on "did not work"? like provide the error message ;-) 2) I would assume the project ID is numeric and thus no need for the single quotes around '#thisprojectid#' (same goes for count) HTH Cheers On Tue, 2010-10-26 at 10:47 -0700, Rick Colman wrote: > that did not work. >

Re: looping through an insert statement

2010-10-26 Thread Michael Grant
Could you post your code? If you only loop a single time do you still get the error? On Tue, Oct 26, 2010 at 1:47 PM, Rick Colman wrote: > > that did not work. > > what is funny is that the debug sql statement looks ok : > > Insert into ProteinSequence (Project_ID, AA_Sequence, Gene_Name, Count

Re: looping through an insert statement

2010-10-26 Thread Rick Colman
that did not work. what is funny is that the debug sql statement looks ok : Insert into ProteinSequence (Project_ID, AA_Sequence, Gene_Name, Count) Values( '20', 'sdalifsdaifasifsadi', 'g1', '15' ) On 10/26/2010 10:40 AM, Michael Grant wrote: > Maybe try this instead: > > Values( > '#thisp

Re: looping through an insert statement

2010-10-26 Thread Michael Grant
Maybe try this instead: Values( '#thisprojectid#', '#form["ProteinSequence" & LoopCount]#', '#form["genename" & LoopCount]#', '#form["NoAminoAcids" & LoopCount]#' ) ~| Order the Adobe Coldfusion Anthology now! http://www.

Re: Looping over Query that's contained in a structure.

2010-10-14 Thread Rick Root
I got a good laught out of this because I'm always happy to see I'm not the only one who sometimes makes stupid mistakes :) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/14302721

Re: Looping over Query that's contained in a structure.

2010-10-14 Thread Michael Grant
The é is a nice touch. Alt+130 FTW On Thu, Oct 14, 2010 at 9:17 AM, Che Vilnonis wrote: > > Touché :) > > -Original Message- > From: Eric Cobb [mailto:cft...@ecartech.com] > Sent: Thursday, October 14, 2010 9:13 AM > To: cf-talk > Subject: Re: Looping over Que

RE: Looping over Query that's contained in a structure.

2010-10-14 Thread Che Vilnonis
Touché :) -Original Message- From: Eric Cobb [mailto:cft...@ecartech.com] Sent: Thursday, October 14, 2010 9:13 AM To: cf-talk Subject: Re: Looping over Query that's contained in a structure. >Michael, would you believe once upon a time I placed 'top 3' in my &

Re: Looping over Query that's contained in a structure.

2010-10-14 Thread Eric Cobb
ime I placed 'top 3' in my local > spelling bee? > Age has not been kind to my spelling and/or typing skills. ;) > > -Original Message- > From: Michael Grant [mailto:mgr...@modus.bz] > Sent: Wednesday, October 13, 2010 9:16 PM > To: cf-talk > Subject: R

RE: Looping over Query that's contained in a structure.

2010-10-14 Thread Che Vilnonis
Michael, would you believe once upon a time I placed 'top 3' in my local spelling bee? Age has not been kind to my spelling and/or typing skills. ;) -Original Message- From: Michael Grant [mailto:mgr...@modus.bz] Sent: Wednesday, October 13, 2010 9:16 PM To: cf-talk Subject: R

Re: Looping over Query that's contained in a structure.

2010-10-14 Thread enigment
The spellchecker in IntelliJ IDEA is camel-case aware, so it highlights things like this. Not just for that reason, I'm very happy with it. Dave ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion

Re: Looping over Query that's contained in a structure.

2010-10-13 Thread Michael Grant
t: Wednesday, October 13, 2010 4:13 PM > To: cf-talk > Subject: Re: Looping over Query that's contained in a structure. > > > Could be becuase your structure key is LineTEMS, not LineItems... > Spelling > is sometimes the worst bug to catc

RE: Looping over Query that's contained in a structure.

2010-10-13 Thread Leigh
> I dispise typos. Sorry to bother everyone. ROFL. I can totally relate ;-) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http:

Re: Looping over Query that's contained in a structure.

2010-10-13 Thread Eric Cobb
he attribute query, which is currently > q.lineitems, is invalid." > I also tried and query="q[lineItems][resultset]">... No luck with either. > > -Original Message- > From: Leigh [mailto:cfsearch...@yahoo.com] > Sent: Wednesday, October 13, 2010 4:03 PM >

RE: Looping over Query that's contained in a structure.

2010-10-13 Thread Che Vilnonis
I dispise typos. Sorry to bother everyone. -Original Message- From: David McGraw [mailto:david.mcg...@gmail.com] Sent: Wednesday, October 13, 2010 4:13 PM To: cf-talk Subject: Re: Looping over Query that's contained in a structure. Could be becuase your structure key is LineTEMS

Re: Looping over Query that's contained in a structure.

2010-10-13 Thread David McGraw
Could be becuase your structure key is LineTEMS, not LineItems... Spelling is sometimes the worst bug to catch. David McGraw Oyova Software, LLC http://www.oyova.com On Wed, Oct 13, 2010 at 4:09 PM, Cameron Childress wrote: > > > > Pound signs, and single ticks to demote 'lineitems' is not a

Re: Looping over Query that's contained in a structure.

2010-10-13 Thread Cameron Childress
Pound signs, and single ticks to demote 'lineitems' is not a variable name, but a string. -Cameron -- Cameron Childress Sumo Consulting Inc http://www.sumoc.com --- cell:  678.637.5072 aim:   cameroncf email: camer...@gmail. ~~~

RE: Looping over Query that's contained in a structure.

2010-10-13 Thread Che Vilnonis
I tried that. I get, "The value of the attribute query, which is currently q.lineitems, is invalid." I also tried and ... No luck with either. -Original Message- From: Leigh [mailto:cfsearch...@yahoo.com] Sent: Wednesday, October 13, 2010 4:03 PM To: cf-talk Subject: Re: Lo

Re: Looping over Query that's contained in a structure.

2010-10-13 Thread Leigh
~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338142 Subscrip

RE: looping syntax inside a function?

2010-09-30 Thread Justin Scott
> http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337724 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/

Re: looping syntax inside a function?

2010-09-27 Thread Dave Watts
>  Do anyone know what the proper syntax is for adding a loop variable to > a variable name, like the following, which is not working: > > > > "#REReplaceNoCase(form.ProteinSequence_#loopcount#,'[^()1acdefghiklmnpqrstvwyz > ]','','all')#"> > > ... etc. or That said, you really don't need t

Re: Looping through arrays with structures

2010-09-21 Thread Michael Grant
I thought images was a structure containing an array? On Tue, Sep 21, 2010 at 5:15 PM, Richard Steele wrote: > > Thanks all. That was very helpful. Here's the code I ended up using. > > > > >#keyword_results[x].images[y]# > > > >

Re: Looping through arrays with structures

2010-09-21 Thread Richard Steele
Thanks all. That was very helpful. Here's the code I ended up using. #keyword_results[x].images[y]# ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael

Re: Looping through arrays with structures

2010-09-18 Thread Michael Grant
, > Andrew Scott > http://www.andyscott.id.au/ > > > > -Original Message- > > From: Jacob Munson [mailto:yacoub...@gmail.com] > > Sent: Saturday, 18 September 2010 12:54 PM > > To: cf-talk > > Subject: Re: Looping through arrays with structures > > > > >

RE: Looping through arrays with structures

2010-09-17 Thread Andrew Scott
mber 2010 12:54 PM > To: cf-talk > Subject: Re: Looping through arrays with structures > > > Am I blind? The email I read from Michael does NOT show the array > attribute. In fact, his loop looks exactly like your code. ~

Re: Looping through arrays with structures

2010-09-17 Thread Charlie Griefer
t; > Sent: Saturday, 18 September 2010 11:09 AM > > To: cf-talk > > Subject: Re: Looping through arrays with structures > > > > > > What version of cf won't my code work in? > > > > > ~

Re: Looping through arrays with structures

2010-09-17 Thread Jacob Munson
- > > From: Michael Grant [mailto:mgr...@modus.bz] > > Sent: Saturday, 18 September 2010 10:35 AM > > To: cf-talk > > Subject: Re: Looping through arrays with structures > > > > > > > > > > > index="y"> > > > > #firstA

RE: Looping through arrays with structures

2010-09-17 Thread Andrew Scott
om: Michael Grant [mailto:mgr...@modus.bz] > Sent: Saturday, 18 September 2010 11:09 AM > To: cf-talk > Subject: Re: Looping through arrays with structures > > > What version of cf won't my code work in? >

Re: Looping through arrays with structures

2010-09-17 Thread Michael Grant
indexing of the array in this manner > > > myArray[arrayCounter].images > > > > Regards, > Andrew Scott > http://www.andyscott.id.au/ > > > > > -Original Message- > > From: Michael Grant [mailto:mgr...@modus.bz] > > Sent: Saturday,

RE: Looping through arrays with structures

2010-09-17 Thread Andrew Scott
id.au/ > -Original Message- > From: Michael Grant [mailto:mgr...@modus.bz] > Sent: Saturday, 18 September 2010 10:35 AM > To: cf-talk > Subject: Re: Looping through arrays with structures > > > > > index="y&qu

Re: Looping through arrays with structures

2010-09-17 Thread Michael Grant
#firstArray[x].images.secondArray[y]# On Fri, Sep 17, 2010 at 8:18 PM, Richard Steele wrote: > > I have an array with a structure that has an array. How do I loop through > this in CF8 and retrieve the second array's 5 digit numbers? Thanks in > advance. > > array > 1 | > | struct >

Re: looping over an error of ORM objects

2010-05-27 Thread bill turner
Never mind! I just realized that I needed to use the getter/setter methods on the ORM components. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag

RE: Looping with BufferedReader.readLine() and comparing to NULL

2009-07-31 Thread Adrian Lynch
Why didn't I try the obvious one first, IsDefined()! Seems to work a treat. Adrian > -Original Message- > From: Adrian Lynch [mailto:cont...@adrianlynch.co.uk] > Sent: 31 July 2009 16:01 > To: cf-talk > Subject: Looping with BufferedReader.readLine() and comp

Re: Looping

2009-02-18 Thread Tom Chiverton
On Tuesday 17 Feb 2009, Priya Koya wrote: > I tried using Session but it didnt work... * Why not ? -- Tom Chiverton Helping to advantageously market cross-platform information *http://www.catb.org/~esr/faqs/smart-questions.html This email

Re: Looping

2009-02-17 Thread Priya Koya
I tried using Session but it didnt work... > On Tuesday 17 Feb 2009, Priya Koya wrote: > > page3.cfm from the table if I am not visiting it. And also wanted to > stay > > the highlight on page2.cfm even if I visit page3.cfm i.e.. page3.cfm > is my > > active page. > > Sounds like you could jus

Re: Looping

2009-02-17 Thread Tom Chiverton
On Tuesday 17 Feb 2009, Priya Koya wrote: > page3.cfm from the table if I am not visiting it. And also wanted to stay > the highlight on page2.cfm even if I visit page3.cfm i.e.. page3.cfm is my > active page. Sounds like you could just save the 'active' page name to the session scope (or as a c

Re: looping through varchar fields in a database

2009-01-23 Thread Ben Conner
Hi Justin, Much appreciated. This will give me a head-start. I have extensive security on the front end of this site, but it is written in ASP and I know very little other than how to spell it. :( Thanks! --Ben Justin Scott wrote: > Ben Conner wrote: > >> I need to inspect all varchar fields

RE: looping through varchar fields in a database

2009-01-23 Thread brad
Is that SQLi I smell? :) Yeah, based on your DBMS the information schema or sys tables can easily let you build some dynamic SQL. Here's something I wrote the other day to rid some tables of all null values by replacing them with their columns null value (please don't ask why) This runs on SQL

Re: looping through varchar fields in a database

2009-01-23 Thread Justin Scott
Ben Conner wrote: > I need to inspect all varchar fields in all tables in a MS SQL server > database and update rows that have a bogus value in them. This looks > like a LOT of work and wondered if anyone has an elegant framework > solution for something like this. Based on one of the recent SQL

Re: Looping over form structs into an array or query

2008-10-29 Thread Tom King
Thanks for the help all; finally settled on: It's the "#testStruct["UrlText_" & counter]#" syntax which was the key for me! Ta T 2008/10/29 Tom Chiverton <[EMAIL PROTECTED]> > On Wednesday 29 Oct 2008, Jake Ch

Re: Looping over form structs into an array or query

2008-10-29 Thread Tom Chiverton
On Wednesday 29 Oct 2008, Jake Churchill wrote: > This will loop over each Url and Text, where as you really want one to be both url and text. Use one of the condition based loops instead. -- Tom Chiverton Helping to quickly repurpose user-centric synergies *

Re: Looping over form structs into an array or query

2008-10-29 Thread Tom King
I get this cryptic error when running that: Element 1 is undefined in a CFML structure referenced as part of an expression. even though my stuff is getting passed: Link Name 1 URL 1 200

Re: Looping over form structs into an array or query

2008-10-29 Thread Jake Churchill
You are close. Try this: -Jake Churchill Tom King wrote: > Hi All, > > I've got a form where I've got a potentially unknown number of form fields > as they're being added by Javascript; > > i.e > form.linkText_1 > form.linkUrl_1 > form.linkText_2 > form.linkUrl_2

RE: Looping over form structs into an array or query

2008-10-29 Thread Adrian Lynch
If they're sequential then this'll help: #FORM["linkText_" & i]# #FORM["linkURL_" & i]# Adrian Building a database of ColdFusion errors at http://cferror.org/ -Original Message- From: Tom King Sent: 29 October 2008 13:37 To: cf-talk Subject: Loopi

Re: Looping over form structs into an array or query

2008-10-29 Thread Tom Chiverton
On Wednesday 29 Oct 2008, Tom King wrote: > > > > Key: #key#, Value: #form[key]# pos=listLast(key,'_') array[pos]=form[key] -- Tom Chiverton Helping to assertively restore revolutionary global paradigms This email is sent for an

Re: Looping over form structs into an array or query

2008-10-29 Thread Scott Stroz
Tom, When I have situations like that, where form fields can be added to the form via JS, I will have a form field that tells me how many form fields ther are. Then each time I add a form field, I increment that by 1. In my 'action page' I will use that fomr field as the basis for my loop Text

Re: Looping over form structs into an array or query

2008-10-29 Thread Ian Skinner
Well, a structure is probably easiest. Key: #key#, Value: #form[key]# ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f

Re: Looping over database columns

2008-07-12 Thread Phillip M. Vector
THANK YOU!! :) That did the trick. :) Azadi Saryev wrote: > you need to reference the row as well: > > > > 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 C

Re: Looping over database columns

2008-07-12 Thread Azadi Saryev
you need to reference the row as well: 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 the point... >> > > Yes.. I am fo

Re: Looping over database columns

2008-07-12 Thread Phillip M. Vector
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 en

Re: Looping over database columns

2008-07-12 Thread Azadi Saryev
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 wh

Re: Looping over database columns

2008-07-12 Thread Phillip M. Vector
I'm not sure what you are asking. Here is the code I'm using. #position#

Re: Looping over database columns

2008-07-12 Thread Azadi Saryev
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 ? Azadi Saryev S

Re: Looping over database columns

2008-07-12 Thread Phillip M. Vector
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

Re: Looping over database columns

2008-07-12 Thread Azadi Saryev
if Position query returns one row: with multiple row returned by Position query, you could do something like: Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Phillip M. Vector wrote: > Basically the question becomes... How do I pull the value of a row that > I'm looping over and put

RE: Looping over database columns

2008-07-12 Thread Bobby Hartsfield
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

Re: Looping over database columns

2008-07-12 Thread Phillip M. Vector
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.. > > > > > > So I get ...

Re: Looping over database columns

2008-07-12 Thread Phillip M. Vector
That helps... a bit.. But not fully. What if I want to do something like this.. So I get ... session.schedule = 0 session.calendar = 1 session.staff = 0 etc. Azadi Saryev wrote: > a select query returns a list of all columns in #queryname.columnlist# > varia

Re: Looping over database columns

2008-07-12 Thread Azadi Saryev
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: > >PermissionList="Schedule,Chat,Calendar,Games,Sta

Re: Looping over an XML Array

2008-05-19 Thread Dominic Watson
> > > to="#arrayLen(ledata.callmeasurement.resultscall.numbers.XMLChildren)#" > index="i"> > ...etc Also, the ArrayLen() of 'ledata.callmeasurement.resultscall.numbers.XMLChildren' could in *theory* not be the number of dnis elements (though in practice in this case it is). It cou

Re: Looping over an XML Array

2008-05-19 Thread Steve Good
Stupid flipping typos... Thanks Dave. On Mon, May 19, 2008 at 12:55 PM, Dave Watts <[EMAIL PROTECTED]> wrote: > > Anyone tell me what I'm doing wrong here? XML and Arrays are > > not my strong points. > > > > > "numbers")> > > > structKeyExists(ledata.callmeasurement.resul

RE: Looping over an XML Array

2008-05-19 Thread Dave Watts
> Anyone tell me what I'm doing wrong here? XML and Arrays are > not my strong points. > > "numbers")> > structKeyExists(ledata.callmeasurement.resultscall.numbers, "dnis")> > > to="#arrayLen(ledata.callmeasurement.resultscall.numbers.XMLCh

RE: looping through a form

2008-05-15 Thread Adrian Lynch
Sure there is, it's called an overscore... :OD -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: 15 May 2008 12:53 To: CF-Talk Subject: Re: looping through a form And to be very anal, I don't think there is a uppercase version of _. ;) You also w

Re: looping through a form

2008-05-15 Thread Jason Congerton
thank you.it worked a treat. >The parameters to FindNoCase are back-to-front. > >Adrian > >Hi > >I posted a question a few weeks ago regarding looping through form results, >and someone posted the code below for me to try, however no records are >updated when the form is submited. In fact nothing

Re: looping through a form

2008-05-15 Thread Raymond Camden
And to be very anal, I don't think there is a uppercase version of _. ;) You also want to use cfqueryparam with your sql. On Thu, May 15, 2008 at 6:09 AM, Bobby Hartsfield <[EMAIL PROTECTED]> wrote: > Change > findnocase(field, "_") > > To > findnocase("_", field) > > --

RE: looping through a form

2008-05-15 Thread Bobby Hartsfield
Change findnocase(field, "_") To findnocase("_", field) ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Jason Congerton [mailto:[EMAIL PROTECTED] Sent: Thursday, May 15, 2008 6:18 AM To: CF-Talk Subject: looping through a f

RE: looping through a form

2008-05-15 Thread Adrian Lynch
The parameters to FindNoCase are back-to-front. Adrian -Original Message- From: Jason Congerton [mailto:[EMAIL PROTECTED] Sent: 15 May 2008 11:18 To: CF-Talk Subject: looping through a form Hi I posted a question a few weeks ago regarding looping through form results, and someone poste

Re: Looping over a list with a 'NP form feed, new page' character [ascii(12)]

2008-04-08 Thread Ian Skinner
Azadi Saryev wrote: > shouldn;t the delimiter be chr(12) or whatever it is? Yes, yes it should be chr(12) not asc(12). The product of trying to figure this out without enough sleep. Again, thank you. ~| Adobe® ColdFusion® 8 s

Re: Looping over a list with a 'NP form feed, new page' character [ascii(12)]

2008-04-08 Thread Azadi Saryev
shouldn;t the delimiter be chr(12) or whatever it is? Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Ian Skinner wrote: > I have a text file that I am trying to loop over using the "NP form > feed, new page" character. The ultimate goal is to output this text > file as a PDF with repl

Re: Looping and CFIFs

2008-01-01 Thread Phillip M. Vector
That worked. Thanks. :) Dominic Watson wrote: > Ah, sorry I didn't test it! > > You will need to use: position[field][currentRow]. > > The currentRow is relative to the query that is being looped (with cfoutput > or cfloop) so you can use that instead of your count variable. > > Dominic > > >

Re: Looping and CFIFs

2008-01-01 Thread Dominic Watson
Ah, sorry I didn't test it! You will need to use: position[field][currentRow]. The currentRow is relative to the query that is being looped (with cfoutput or cfloop) so you can use that instead of your count variable. Dominic On 01/01/2008, Phillip M. Vector <[EMAIL PROTECTED]> wrote: > > Th

Re: Looping and CFIFs

2008-01-01 Thread Phillip M. Vector
Thanks.. When I do that, I get Complex object types cannot be converted to simple values. When I try the second solution, I get .. cannot convert the value of type class coldfusion.sql.QueryColumn to a boolean Any ideas? :) Dominic Watson wrote: > Hi Philip, instead of doing: > > > > D

Re: Looping and CFIFs

2008-01-01 Thread Dominic Watson
Hi Philip, instead of doing: Do: Also, and this is personal preference, you can treat the 1 or 0 values as booleans so you could also write it as: ... or ... Dominic On 01/01/2008, Phillip M. Vector <[EMAIL PROTECTED]> wrote: > > I'm trying to loop over a list of table columns and use

RE: looping through each row

2007-11-25 Thread Bobby Hartsfield
> I like the idea of abstracting this into a function a lot (I loves me > functions) but using the same principle as the last message I posted (look > for the difference in length after you remove "char") should make this > simpler: Yeah that sounds simpler. The first "or" did as well... #listle

Re: looping through each row

2007-11-25 Thread Janet MacKay
>"Return the length of the string MINUS the length of string after I've >removed all of the characters." (Jim - Yes. Makes sense) Thanks guys. I was curious if there was a way to do it without looping. I think the replace() approach would be simpler .. and unlike my code it works correctly too

RE: looping through each row

2007-11-25 Thread Jim Davis
> -Original Message- > From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] > Sent: Sunday, November 25, 2007 11:01 AM > To: CF-Talk > Subject: RE: looping through each row > > > function charCount(str,char) > { > var i = 1

RE: looping through each row

2007-11-25 Thread Jim Davis
> -Original Message- > From: Janet MacKay [mailto:[EMAIL PROTECTED] > Sent: Saturday, November 24, 2007 11:21 PM > To: CF-Talk > Subject: Re: looping through each row > > Any regex gurus out there know if there is a pattern to test the number > of commas in

  1   2   3   4   5   6   >