Hi everyone - this is silly, I know, but... I'm a designer who can code a bit, and I have issues with font management on my system (I have about 2,000-odd fonts). so, Cleverdix here decides to quickly write his own ColdFusion font manager, easy peasy.  Import all the font families into a database, add my own delimiters (such as "oh yeah" and "Crap" and  'handwritten") so that when I look for a font, I can run a query, and find the fonts I'm looking for.  Heaven!  Got the database set up, works like a charm. Except, of course, it does not, because coldfusion doe snot want to render the fonts. Do a bit of digging, and I find this gem: <cfset adminObj = createObject("Component", "cfide.adminapi.administrator")> <cfset adminObj.login("password", "user")> <cfset rtService = createObject("component", "cfide.adminapi.runtime")> <cfset fonts = rtService.getFonts()> Ta-dah! absolutely brilliant - I now have a struct with all my fonts...  within a struct residing in a struct residing in a struct...  4 nested structs, and now I'm as lost as a Polar Bear in Australia. Questions: How do I get the "second key" and the third key, etc, so that I can loop over them and insert them into my database? with my limited knowledge, I can get the 1st struct key, which returns me "systemfonts" and "userfonts" - as useless as a snooker table on a canie.  I know what the hell that second key is, and the third one, so that I can list all the variables in a way that makes sense to me. Basic desired outcome is a database that looks sort-of like this: rowid | font family | font-face | postscript name | path When I can import the family, face and postscript into my database, I'll be happy as an ant at a picnic. thank you - thank you - I'll email you a sixpack for your effort. ... View more

Hi all – I have a dumb question – I’m not the worlds best scripter… I’ve got a ColdFusion page, with an element in it that is either flash, or HTML5. I need a way to detect what is happening client-side and push the client to either the Flash element, or the HTML element (or a s “you’re WAY behind the times” element if neither). I’ve found, and used, modernizr, but it does things the wrong way round for me.  I need to direct my clients to flash 1 st , then HTML5, then the sorry page.  Modernizr only gives me HTML 5 first then Flash, and this isn’t working for me.  the flash element is the preferred element.   I’ve screwed around with trying to “swap out” modernizr, but my glasses aren’t thick enough.  Thus, I (roughly) need something that does this: <cfif “flash”> Direct them to flash page <cfelseif “html5”> Direct them to HTML 5 page <cfelse> So, how is life in the 18 th century? </cfif> Help, please..  It does not have to be CFM, it can be a JavaScript or anything.  ... View more

Okay – here’s one for the guys smarter than me – IE: everyone.  An interesting query. (CF8, MySQL5) I’m building an internal stock library for a large firm.  Easy job – and its always the easy ones that knock you, ain’t it?  Basically, its very very simple, I have three tables. Table 1 is a list of images (ImageTbl) – this has a lot of data on it, but the only important thing from ImageTbl is the unique identifier, RowID.  It looks something like this Rowid Photo 1 Gold.jpg 2 iron.jpg 3 train.jpg 4 foo.jpg 5 bar.jpg …Etc. for hundreds of images. Table 2 is a list of features (FeatureTbl) that can be applied to any image, its literally just a RowID and a Feature, IE Rowid Feature 1 Mining 2 Coal 3 Rail Transport 4 Iron Ore 5 Road Transport 6 Refined Product 7 Gold Ore etc. for about 50-odd features.   Every image that is uploaded to the system is then given AT LEAST one of these categories, but it can be as many as 9 or 10.  This is where the fun starts….  So, maybe I’ve been given the wrong advice, but I’ve been told not to store strings, but to “normalise” the database, which means I’ve got a third table which has an image number and a feature number: (ImageFeaturesTbl) ImageNo FeatureNo 1 1 1 3 1 5 2 1 2 7 3 5 etc 100's of records (This is how I was told to do this, I can probably change the system if I really need to) Now they want to have a “search” function.  Gimme all images that feature “coal”.  Got the features list as a checklist on a form, check the feature you want, hit submit – voila! Easy – run a query on ImageFeaturesTbl  and Bob is your auntie. Select imageNo from ImageFeaturesTbl where feature=#FORM.FeatureNo# Works a treat!  Sits out all the images that  has the "Coal" featreNo.  But now, what if there are more than 2 categories? What if they want all images that has “Coal” or “gold” on it – that one I also figured out, the “OR” query.  I can do a loop and search for images on ImageFeaturesTbl that has either one or the other. So this is not the problem either. The fun really starts with the “and” query – select images that has both “coal” and “rail transport”… and this is where I get stuck.  I’ve literally worked till 4:00 AM this morning – and it’s a weekend; and up again at 7 trying to solve this puzzle.  I’m miserable! Basically I’m wanting to get from ImageFeaturesTbl a list of image numbers that contains ALL the selected features. It could be one feature (always at least one) but it could be Nine or 10.  But it has to have ALL the featurees.  So the system has to give me all the images that shows coal being transported on rail in summer at the harbour, for instance.  The database and tables exist, but how the hell do I write that select query…. Thanks - I'll email the winning answer a crate of beer.  ... View more

Help – been up all night and brain is flat… I have a text list, which I need to compare with n-amount of other lists.  IE: Original list: “beer, whisky, wine, vodka, tequila” Then I have: List 2: “beer, chocolate, nuts” List 3: “whisky, bacon, beer” List 4: “chocolate, bacon” Etc… I need a script that compares my original list with list 2, 3 & n, and return the list number that matches ANY of the list elements.  IE my result set would be “2, 3”.  (the ID of the lists returned as a valuelist) Bonus point if you can arrange them by the amount of matches – “3, 2” – but non-essential.  Point me in the right direction please! ... View more

Long story short: I have a database table with literally millions of records.  Every week a new column is added to this table dynamically. I need to find out the name of this column is.  I tried using the getColumnList() function, and it works fine – in theory.  The thing is, I have to use a “select * from” query, which I so do not want to do – I have no desire to select asterisk a couple of million records just to get a single column header value. I know I’m being an idiot here, but can someone please tell me how to get a column header from a table.  CF8, MySql Thanks! ... View more

I have an exceptionally large query that I run once a week, and it has now become very cumbersome.  at any given time its 20 000 records or more. I want to output to page as the query runs - trying cfflush but it does not seem to work. Anyone have any suggestions - running CF 8. ... View more

I’m looking for a solution. I’ve got a client who tasked me to code a newsletter system. I created a system whereby they can add pictures and text to articles, which are then consolidated in a single newsletter, run through a CFMAIL tag looped through a database, and Bob’s your auntie. Now they say, fine, but how do they do custom layouts – “like in the included word doc”. Basically non-IT-savvy clients wants to have their word doc mailed to their database, but not as an attachment. (Attachment would be easy!). It needs to display in their recipients inbox the way it looks in word – with the normal limitations, of course. Basically – compose a message in outlook/word and send it to the database – which is maintained on the CF server. I’m stumped! I thought of saving the word docs as MHT files and embedding them in the body of the CFMAIL tag, but on the recipient side it just laughs at me (should have guessed, was too simple). How can I solve this problem? Any help would be appreciated as I’ve already spent 3 non-billable days looking for a way to make this happen. ... View more

So I've got a dumb q again... <cfloop index="q" from="-5" to="5"> works perfectly and gives me numbers from -5 to 5. Counts up. How can I make it loop / output the other way, from 5 to -5. Counts down? This must be so easy, yet it escapes me. Its been a long day - forgive me. ... View more

I’m looking for a solution. I have a bunch of random variables, which I then need to compare with a set list, which ranges from 1 to 97. The variables will be in a list like “33, 45, 62”. What I need to figure out how to do is to compare the random variables with my set list. I used some list and find functions, but it either gives me only the first value of 33 only, or it gives me, 2, 3, 4, 5,6, 33, 45 and 62. I need to give it to me to give whole numbers only. Both sets of numbers will be in ascending numerical format. I currently have: <cfset qlist = ValueList(myqry.varno)> <table> <cfloop index="r" from="1" to="97"> <cfoutput> <tr><td>#r# - #ListFindNoCase(qlist, r)#</td><tr> </cfoutput> </cfloop> </table> Which gives me my list from 1 to 97 no problems, coldfusion 101 stuff, but it only gives me a true on 33, not on 45 and 62. What can I do where to give me something like: … 32 - 0 33 - 1 34 – 0 … 44 – 0 45 – 1 46 – 0 … etc? I'm open to suggestions and solutions, don't take my code example as the only way it has to be. Thanks! ... View more

Easy one for the experienced guys: I have a record with a list of comma separated values, IE, 1,2,4,6,12,24 or simply 24 I need to write a query where I find all records where the specific number/value I'm looking for is in the list. For example I’m looking for all records that contains the number "2". I've used the like operator select * from my_table where my_column like '%#form.my_search#%' (and a few variants), but the problem is, it finds the record with just "24" in it as well, whereas I want records that contains "2". And not anything that has a 2 in front or behind it. All numbers are integers, as they refer to a row identifier on another table. How to do this? Thanks ... View more