RE: [ACFUG Discuss] List Handling

2011-11-04 Thread Matthew Nicholson
ry value, then it's always going to return 1 as the list position. You can also output the id value and it's list "pos" as a debug measure if you want... Either inline or using cflog or similar. #id#:#pos# If that doesn't uncover your problem, shoot back

RE: [ACFUG Discuss] List Handling

2011-11-02 Thread Matthew Nicholson
long. Show your code or describe what you are trying to achieve and perhaps we can collectively help you find a better way. -Cameron On Wed, Nov 2, 2011 at 2:35 PM, Matthew Nicholson wrote: Morning All! I could swear we had a discussion about this awhile ago (although I may just be re

[ACFUG Discuss] List Handling

2011-11-02 Thread Matthew Nicholson
Morning All! I could swear we had a discussion about this awhile ago (although I may just be remembering an article from Charlie's site). I'm experiencing a bit of a head scratcher in regards to lists and managing them. 1. Using a QoQ, we create a ValueList from one of its columns

RE: [ACFUG Discuss] PDFs / Excel Shenanigans

2011-10-11 Thread Matthew Nicholson
The PDF option looks to be the most ideal (especially if I can just convert html to PDF from CFDocument.) I wasn't sure where to even begin on that side of things. I'll dig around and see what I can scrounge up, thank you so much for the direction & assistance! Matthew R. Nicholson SolTec

RE: [ACFUG Discuss] PDFs / Excel Shenanigans

2011-10-11 Thread Matthew Nicholson
Jason, Dawn, thank you both so much for the suggestions! I am stuck on CF8 although I'm trying to avoid having to re-write the HTML page to utilize the POI API (or CFXL that Jason provided). What flexibility do we have with appending to an already established document (with a new sheet?)

[ACFUG Discuss] PDFs / Excel Shenanigans

2011-10-11 Thread Matthew Nicholson
Afternoon All! I've got a issue that I've been mulling over and curious if I'm just making this more difficult on myself the necessary. To begin, I've got this delightfully (and obnoxiously) detailed HTML form that is currently being piped out to an excel file for user consumption. This who

RE: [ACFUG Discuss] CF8 Preformance

2011-05-10 Thread Matthew Nicholson
John, Charlie Thank you both very much for the suggestions and direction! My client has apparently been "living" with this issues for some time and only recently has it's becoming more acute and turned into a real issue. And I will say, I will never run a CF server without FusionReacto

[ACFUG Discuss] CF8 Preformance

2011-05-10 Thread Matthew Nicholson
Morning All! I was curious of all of your thoughts of what might cause you to experience a "HTTP Error 503. The service is unavailable." I'm running CF8 and have standard edition, I spent a little time reviewing the groups previous discussion over CF9 performance issues (thank you for thos

RE: [ACFUG Discuss] CF Submits & Function Behavior

2011-04-29 Thread Matthew Nicholson
erently because of that. If that doesn't help, share some more info and perhaps we can help. /charlie From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Matthew Nicholson Sent: Thursday, April 28, 2011 6:46 PM To: discussion@acfug.org Subject: [ACFUG Discuss] CF Submits &

[ACFUG Discuss] CF Submits & Function Behavior

2011-04-28 Thread Matthew Nicholson
Evening All! So, I'm trying to make my life a little bit easier with an auditing module on this application. I'm a little be confused though with a behavior I'm experiencing on a submit post back to the page. (The user clicks a buttons and we reload the page and perform a bunch of logic.)

RE: [ACFUG Discuss] QoQ & Variable Disappearance

2011-04-14 Thread Matthew Nicholson
ie > -Original Message- > From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Matthew > Nicholson > Sent: Wednesday, April 13, 2011 7:36 PM > To: discussion@acfug.org > Subject: [ACFUG Discuss] QoQ & Variable Disappearance > > Alright, > > This i

[ACFUG Discuss] QoQ & Variable Disappearance

2011-04-13 Thread Matthew Nicholson
Alright, This is turning into a delightful exercise in QoQ syntax, restrictions, and design. Here is a recap on problem I'm experiencing; CFSTOREDPROC provides a list of all work orders and associated information CFQUERYA generates list of sites to auto-accept (Huge List - 17000 Elements) CFQU

RE: [ACFUG Discuss] Handling SQL limitation with CF

2011-04-13 Thread Matthew Nicholson
ng var, value, int, etc as a column name. -Cameron On Wed, Apr 13, 2011 at 1:02 PM, Matthew Nicholson wrote: > Afternoon All! > > It looks as though the subquery was by far the best option in the previous > situation. > > However, I've run into a similar problem but th

RE: [ACFUG Discuss] Handling SQL limitation with CF

2011-04-13 Thread Matthew Nicholson
ul to use them, but very often (usually?) there is a better way to do it. -Cameron On Tue, Apr 12, 2011 at 11:17 AM, Matthew Nicholson wrote: > And that option was staring me in the face... > > Thank you very much for the suggestion Cameron. That might certainly do the > trick! --

RE: [ACFUG Discuss] Handling SQL limitation with CF

2011-04-12 Thread Matthew Nicholson
a subquery instead http://beginner-sql-tutorial.com/sql-subquery.htm -Cameron On Tue, Apr 12, 2011 at 11:07 AM, Matthew Nicholson wrote: > Depressingly, the "list" of items I'm dealing with is a mass of ID's and > they don't have any common elements I could potenti

RE: [ACFUG Discuss] Handling SQL limitation with CF

2011-04-12 Thread Matthew Nicholson
the second function a stored proc? On Tue, Apr 12, 2011 at 11:07 AM, Matthew Nicholson wrote: Depressingly, the "list" of items I'm dealing with is a mass of ID's and they don't have any common elements I could potentially leverage with a regular expression. Although, I

RE: [ACFUG Discuss] Handling SQL limitation with CF

2011-04-12 Thread Matthew Nicholson
WHERE state = 'GA') Of course, the REGEXP_LIKE is an oracle only function, but I am sure the SQL Server has an equivalent function. Also, use single quotes as appropriate depending on the column datatype. And all variable data should use a . I hope this helps... Frank

[ACFUG Discuss] Handling SQL limitation with CF

2011-04-11 Thread Matthew Nicholson
Evening All! I was curious if all of you had any thoughts on what may be the best way to tackle this issue. I received the following error a moment ago and spent a little bit of time digging in my source; Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Th

RE: [ACFUG Discuss] Problems with Errors and Quotes

2011-03-15 Thread Matthew Nicholson
fug.org [mailto:ad...@acfug.org] On Behalf Of John Youngman Sent: Monday, March 14, 2011 6:07 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Problems with Errors and Quotes Could u not just use cfmail in a global error handler script? Sent from my iPhone On Mar 14,

[ACFUG Discuss] Problems with Errors and Quotes

2011-03-14 Thread Matthew Nicholson
Evening All! I'd love your thoughts on a sort of odd-ball problem. Here's the situation: I'm attempting to capture all error messages generated from my code and then send an email. I do this by passing all the information into an HTML form and then shooting off a CFMail with all the nec

RE: [ACFUG Discuss] Error Handling and CF8

2011-03-11 Thread Matthew Nicholson
in your error handling. From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Matthew Nicholson Sent: Friday, March 11, 2011 3:31 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] Error Handling and CF8 Excellent point! I’ll admit, I’m still quite new to working with CF and co

RE: [ACFUG Discuss] Error Handling and CF8

2011-03-11 Thread Matthew Nicholson
__ From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Matthew Nicholson Sent: Friday, March 11, 2011 3:22 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] Error Handling and CF8 Ah Ha! Looks as though I was barking up the wrong Application.cfm… I’ve found one that

RE: [ACFUG Discuss] Error Handling and CF8

2011-03-11 Thread Matthew Nicholson
might be encrypted. From: Matthew Nicholson <mailto:matthew.nichol...@soltech.net> Sent: Friday, March 11, 2011 3:08 PM To: discussion@acfug.org Subject: [ACFUG Discuss] Error Handling and CF8 Afternoon All! I’m trying to setup error handling for our production environment

[ACFUG Discuss] Error Handling and CF8

2011-03-11 Thread Matthew Nicholson
Afternoon All! I'm trying to setup error handling for our production environment to be more sophisticated then explosion followed by a crash and burn. With that, I've been able to find a wealth of tutorials on how to set templates and all sorts of other goodies but a majority of them requ

RE: [ACFUG Discuss] css for cfgrid

2011-02-18 Thread Matthew Nicholson
Afternoon! I think its, .x-grid-row-over td{ background:#AADEFF; } .x-grid-hd-over .x-grid-hd-text { background: #AADEFF; } Matthew R. Nicholson To find what you seek in the road of life, the best proverb of all is that which says: "Leave no stone unturned." ~Edward Bulwer Lytton

RE: [ACFUG Discuss] Query within a Query

2011-02-15 Thread Matthew Nicholson
if you are working in varchar, why is it erroring on a date type? __ John Youngman j...@jg-technologies.net http://www.linkedin.com/in/johngyoungman On Feb 15, 2011, at 3:40 PM, Matthew Nicholson wrote: Afternoon All! I seem to be running int

[ACFUG Discuss] Query within a Query

2011-02-15 Thread Matthew Nicholson
Afternoon All! I seem to be running into a bit of a syntax error for query within a query. Here's the situation, I've got a query that creates contains an idea with an associated display variable. I'd like to take that query and use QoQ limit the results based upon a separate select st

[ACFUG Discuss] Newbie Question - PICNIC

2011-02-02 Thread Matthew Nicholson
Afternoon again all! It would seem my problem was a classic example of a PICNIC ("Problem in the chair not in the computer"). Thank you all for your expertise! Matthew R. Nicholson - To unsubscribe from this list, manag

[ACFUG Discuss] Newbie Question

2011-02-02 Thread Matthew Nicholson
Afternoon All! Here's one of those, "I have to be making this overly difficult" moments of the day: Here's what my problem I'd love some insight into: We start with - Select stored procedure-A() as blah1 s

RE: [ACFUG Discuss] Manual Data Source Modification

2011-01-28 Thread Matthew Nicholson
fug.org] On Behalf Of John Mason Sent: Friday, January 28, 2011 12:54 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Manual Data Source Modification If you have a fairly recent version (cf7+) the adminapi John ma...@fusionlink.com On 1/28/11 12:47 PM, Matthew Nicholson wrote: Af

RE: [ACFUG Discuss] Manual Data Source Modification

2011-01-28 Thread Matthew Nicholson
not anything unethical. The solutions only work if you own/have direct access to the box on which CF is installed. /charlie From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Matthew Nicholson Sent: Friday, January 28, 2011 12:47 PM To: discussion@acfug.org Subject: [ACFUG Discuss

[ACFUG Discuss] Manual Data Source Modification

2011-01-28 Thread Matthew Nicholson
Afternoon All! Does anyone know of a manual way to modify the data sources presented in the administrative panel? I have a server where the old developer decided to disabled access to the administrative panel and I can't for the life of me find a way to turn it back on. Now, I need to chang

[ACFUG Discuss] Newbie Question with Components

2010-12-30 Thread Matthew Nicholson
Afternoon All! Here's my basic dilemma. I'm enhancing a CF application that needs a whole lot of TLC. With that, I'm attempting to redesign a few aspects of the application to use components to keep with good design principles. Now, I think I'm being exceptionally thick headed but I can't

[ACFUG Discuss] CF Tools: Site Mapping

2010-12-27 Thread Matthew Nicholson
Morning All! I was curious if anyone had run into a tool that constructs a site map or a visualization of CF site. (Heck... even something as simple as an XML file would showing hierarchical structure would be awesome.) Thank you all for your expertise! Matthew R. Nicholson

RE: [ACFUG Discuss] New to CF: Server Configuration Issue

2010-12-21 Thread Matthew Nicholson
to:ad...@acfug.org] On Behalf Of Les Sent: Tuesday, December 21, 2010 12:26 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] New to CF: Server Configuration Issue You might check for a missing alias mapping in the web service. Les On 12/21/2010 12:17 PM, Matthew Nicholson wrote: Gree

[ACFUG Discuss] New to CF: Server Configuration Issue

2010-12-21 Thread Matthew Nicholson
Greetings! I've recently been tasked with enhancing a rather creatively developed CF application. While I've been able to configure the enviroment to run all the source and other various goodies. None of the sites images will load (even though the application seems to be running swimmingly)