Hi,
I'm trying to create a stacked series chart using cfchart where the stack has multiple values.
For example, my columns could be feedback codes, with the values being a stack of the count of the type of action taken.
I can generate the columns, but can't find a way to split the stack into the count of the action taken type.
Any ideas on how I do this? I previously abandoned cfchart for...
ndeeley
Last Activity: Jun 5 '14, 12:25 PM
Joined: Mar 6 '07
Location:
-
cfchart stacked series, multiple values
-
Thanks acoder - I missed looking at using the drive letter on the server: I muddled it with the drive it was mapped to on my machine. All fixed now.
Thanks for your persistance! -
Hi acoder,
I have the path, but its not drive letter specific, as everyone has the drive mapped to different letters. The full path is http://marlin/assetinl/scripts/TaskBank/DocStore
Would that still work, or would i have to map to a drive letter?
ThanksLeave a comment:
-
Coldfusion Error: String index out of range
Hello,
I recently moved my scripts over to a server running Coldfusion MX instead of 5. Now the scripting I'm using to upload a file doesn't work. I've checked it and it all looks okay - any ideas why it isn't working?
The path quoted by the CF variable is an absolute one:
//marlin/assetinl/scripts/TaskBank/Docstore
...Code:<cfoutput> <cffile action="upload"
-
find almost matching data
Hi there,
I have two tables with site information. There's a field in each for the site name, with sites from a - z. Unfortunately the site name isn't quite an exact match between tables:
Common_List.Equ ipmentDesc
ADMIRALTY SR, TORPOINT
ALLERS WPS, TIVERTON
BARLEY LANE SR, EXETER
...
SList.SiteDesc
ADMIRALTY SR
ALLERS WPS TIVERTON
BARLEY LANE SR... -
hi Rabbit,
That's great thanks. Just one thing - the month value is returned as a number, which despite formatting with DateFormat doesn't display the correct month name. Do I need to use CreateODBCDate?
ThanksLeave a comment:
-
Loop by Month
Hi,
I have some data I need to total by Month.
i can create a query to do this for a particular month:
...Code:<cfset vStart=createDate(year(Now()), 3, 1)> <cfset vEnd=createDate(year(Now()), 3, 31)> <cfquery name="getSum"> select sum(TimeTaken) as mySum, CompletionDate from tblTaskBank where CompletionDate BETWEEN #vStart# AND #vEnd#
-
Loop through multiple queries
Hi,
I'm outputting the results of a query to generate some select boxes. The query runs through a list of skills to generate the boxes. Inside this I`m looping through another query to show a choice of skill levels:
...Code:<cftransaction> <cfquery datasource="taskbook" name="getSkills"> select LoginNameFK, SkillType, SkillLevel from tblSkillset where
Last edited by Niheel; Jul 19 '11, 08:21 AM. Reason: Please use a proper title next time. "Looping" is not descriptive enough. -
That's great, thanks acoder - worked a treat.
NeilLeave a comment:
-
List values to rows
Hi,
I have a table in a db that stores a users skillset.
There are 3 columns: the users name, the skillset (eg Access) and their proficiency ('Beginner' etc).
Currently I'm storing these as a separate line, so with 10 skillsets each user will have ten rows. But that means i have to create 10 select boxes for them to choose their proficiency. And I`m naturally lazy.
Instead I've created a table showing... -
Thanks acoder, I'll give it a go - hopefully I'll have no problems!
Cheers
NeilLeave a comment:
-
Thanks acoder, sounds like the 'other' option is a good one, so I`ll use that.Leave a comment:
-
I've added a field called 'Visible' to my table to use to unselect records from view. I've used a copy of the page to toggle between the two states of seeing / not seeing the records, which sort of works, but doesn't display the checkbox text propery. I'd like all the code to be on the one page.
This is the code to select the records:
...Code:<cfif isDefined('mycheck')> <cfif mycheck EQ 1>Leave a comment:
-
Using Checkboxes
Hi,
I've been mulling it over but I can't get my head around how to achieve the following:
I have a page that displays jobs for a user. I'd like a checkbox which, when checked, removes jobs with the status of 'Completed', stays checked on the refresh of the page and then adds the Completed jobs when unchecked.
Is this doable? I've tried this but I can't get it to work.
Thanks
Nei... -
Combine Select & Text box?
Hi,
Not sure if this is doable in CF, but is it possible to combine a text and select box - ie so the user can type in text if it's not in the drop down, then add that value back into the list?
Thanks
Neil -
Thanks acoder, looks like I'll have to have a think around the problem!Leave a comment:
-
Yes, I do...but everyones network path will be on different drive letters, so it's unlikely that more than 3 people in the team will have it mapped to the same letter. Mine is K: tho...Leave a comment:
-
Hmmm...still not working. I get an error saying that the path cannot contain leading slashes or drive letters.
Here's an example of the values I`m storing in the field FileLoc:
\\gopher\gis_da ta\GIS Maintenance Data\Workflow\3 9017081\myfilen ame.doc
I'm performing the following code, but still cannot display the file link:
...Code:<cfif #FileLoc# NEQ ''> <td rowspan="3"
Leave a comment:
-
That works brilliantly, thanks for your help acoder!Leave a comment:
-
Get File Location and store in Field
Hi,
I've created a form that allows the user to upload an attachment.
I can save the attachment with <cffile> and create a directory (if none exists) with <cfdirectory> . However, I want to save the absolute filepath to a database field so I can use it as a hyperlink later.
I've tried to concatenate the directory path with a trimmed version of the form.UploadFile field contents, but it doesn't...
No activity results to display
Leave a comment: