Arrgh. Yep, 'twas the silly single quotes.
Since the Curriculum field was the one giving me trouble, this did the trick:
<cfset Cur2= #form["Curriculum" & 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="savefs" datasource="#deptdsn#">
update tbl_FactSheets
set FactSheetTitle = '#form["FactSheetTitle" & FSID]#',
Curriculum = '#form["Curriculum" & 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="form.StartDate" default="">
<cfparam name="form.EndDate" default="">
But you probably knew that.
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="form.StartDate" default="">
<cfparam...
Here's how I did it, getting 3 unique results from a catalog of rings:
<cfinclude template="qry_getAllRings.cfm">
make a list of values from that query
<cfset RingList = ValueList(getAllRings.RingID)>
then start the "already used" 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...
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 "I:\\Inet\\Public\\CSSrvcs\\Roster\\Pictures\\{MERGEFIELD...
I've got CF5 on my local developement machine, 4.01 on the webserver, and the software department says "no upgrade to CFServer for at least a month or two." Thus my current situation of developing something that works fine locally, alerts me to breaks on the web server, and pinches me...
I'm Mail Merging a staff directory, and I'm using {INCLUDEPICTURE} to bring in .jpg files from a local folder.
The merge works just fine, except that the images vary in their height/width dimensions. I need to specify the size/scaling of the images in the Word doc (I don't have permission to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.