Recent content by simmerdown

Arrgh. Yep, 'twas the silly single quotes. Since the Curriculum field was the one giving me trouble, this did the trick: <cfset Cur2= #form[&quot;Curriculum&quot; & FSID]#> <cfset Cur3 = PreserveSingleQuotes(Cur2)> I had tried making it one efficient statement like <cfset Cur3 =...

you won't find the answer with ColdFusion. cf only runs on a web server, so it's impossible to have it accurately monitor usage time on a local machine ... if you really want to keep track of what users are doing, you could go for some software like - Watchdog: http://www.sarna.net/watchdog/ -...

OK, so that was way too long. All I really need answered ... is <cfquery name=&quot;savefs&quot; datasource=&quot;#deptdsn#&quot;> update tbl_FactSheets set FactSheetTitle = '#form[&quot;FactSheetTitle&quot; & FSID]#', Curriculum = '#form[&quot;Curriculum&quot; & FSID]#'...

The app is a content management system for 50-some academic departments at a community college. The edit-your-department's-content page displays a variable number of sets of three fields: FactSheetTitle, Curriculum, and CourseList. Additionally, users have the option to add or delete sets...

oops, that should be <cfparam name=&quot;form.StartDate&quot; default=&quot;&quot;> <cfparam name=&quot;form.EndDate&quot; default=&quot;&quot;> But you probably knew that.

yes it did ... thanks from me too, Tek.

Thanks mate Hope a complete answer will be useful to someone

But you'll need to use SQL operators for GTE and LTE. And your code must be able to handle a specified start date only, or a specified end date only, or both. Also you can simplify the <cfif>ing by using <cfparam>... <cfparam name=&quot;form.StartDate&quot; default=&quot;&quot;> <cfparam...

Here's how I did it, getting 3 unique results from a catalog of rings: <cfinclude template=&quot;qry_getAllRings.cfm&quot;> make a list of values from that query <cfset RingList = ValueList(getAllRings.RingID)> then start the &quot;already used&quot; list <cfset RingsUsed = 0> now loop...

oops, forgot the huge thank you to http://www.prodok.com/snippets/n6sniff.html for providing such an excellently simple snippet and explanation. 'Twas 80% of the solution right there.

It's somewhat easy to (in a roundabout way) have Javascript affect a ColdFusion page ... trouble is, the others have been right. You need to submit a form to do so. In a content management system I'm just finishing, I just this evening cobbled together a browser detection script which...

Problem fixed. I had a large section of the stylesheet commented out, and apparently DW4 doesn't like large commented-out sections in stylesheets. Took out the commented section out altogether, and crashes immediately ceased.

on that same Staff Directory project [see thread68-384950 for other fun], WordXP now won't update any of the {includepicture} fields after merging. I select all and hit F9, and nothing happens. Not an image do I see. Is there another way to command Word to update merge fields (besides using...

Thank you ... the growling has ceased.

I'm setting up a staff directory as a Mail Merge, and everything's all fine and dandy until we come to my {INCLUDEPICTURE} that is an absolute path to a folder on a network drive. The path to the image needs to be: {INCLUDEPICTURE &quot;I:\\Inet\\Public\\CSSrvcs\\Roster\\Pictures\\{MERGEFIELD...