RE: cfmailcfoutput
Add a CHR(13) and/or CHR(10) character to the end of the line. -Original Message- I'm using a cfoutput inside cfmail to output a query. cfmail from=[EMAIL PROTECTED] to=#GetName.PrimaryEmail# subject=USGenWeb Registration server=#SESSION.server# username=#SESSION.username# password=#SESSION.password# query=GetPosition ... ... ... Your positions include: PositionStateRegionNotes cfoutput #Title##State# #Description# #ProjTitleUrl# /cfoutput ... ... The problem is how it is output. Instead of one set of data per line the result is concantenated into a long string. It did okay when I was sending it as html but a copy goes to their listserv and it is stripping all html code so I'm back to plain text messages. Any idea on how to get this output one line at a time? ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276209 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Wierd CF Output IE Problem
Spaces in the input fields? Did you examine the resulting query in your debug output? You're going to use cfqueryparam when you finalize this, right? -Original Message- I am doing a very, very simple search on two database columns, Title and Link. For my query, I am also doing the simplistic: cfquery name=Search datasource=mydb SELECT * FROM my_table WHERE 0=0 AND Title LIKE '%#FORM.SearchText#%' OR Link LIKE '%#FORM.SearchText#%' /cfquery On the output, I just do a simple output query of search. Now for my problem. In Firefox, the search will return the appropriate results, as expected. However, in IE 6.0, the exact same search returns nothing. I have gone cross-eyed trying to figure out what could possibly be happening. ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276211 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: condition
cfif (form[editor_ ee] is not and form[editor_ ee] is not other) or (form[editor_ ee] is other and form[e_fname_ ee] is not and form[e_lname_ ee] is not ) !--- action: do something --- /cfif That should do what you want. It also eliminates the use of evaluate(). If you want to keep it as two separate cfifs for clarity, you could do cfif (form[editor_ ee] is not cfif form[editor_ ee] is not other) or (form[e_fname_ ee] is not and form[e_lname_ ee] is not ) -Original Message- Alright, my brain is locked-up today, so I'm just going to ask. I need to make a set of cfif statements to so that if the dropdown value is '' then it skips the action. If the dropdown is 'other', then it needs to check to see if fname and lname both have values before it does the action. If the dropdown is anything else, then it does the action but doesn't need to do the fname, lname check. Do I just need to have the action in there twice? If so, I can make a file out of it and include it. here's my current failure: cfloop from=1 to=#Form.editorcount# index=ee cfif evaluate(Form.editor_#ee#) NEQ '' cfif evaluate(Form.e_fname_#ee#) NEQ '' OR evaluate (Form.e_lname_#ee#) NEQ '' action: do something /cfif /cfif /cfloop ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276214 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Error invoking CFC for gateway myGateway: String index out of range: -1
(Trying again, as this seems to have not been received.) Well, thanks for all the feedback. Oddly, all of the gateways on our development server throw this error, but the same gateways work fine in our test and production environments. Code is all the same and the servers are SUPPOSED to be identical. Any ideas? Error invoking CFC for gateway myGateway: String index out of range: -1 Anyone have any experience with this error? The cfc is essentially empty at this point. It's an initiator gateway and all I have (after removing things trying to debug) is just an onIncomingMessage() function that doesn't do anything. I've restarted the gateway after each code change, but the error stays the same. Ideas? ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275602 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: What conditions would cause a new jsessionid to be assigned to a user session?
Something monkeying with the jsession cookie, I imagine. A poorly-conceived spyware blocker, perhaps, or a poorly configured proxy server. Can you find any commonality among the users this is happening to? Browser version? Company or IP address? -Original Message- I know this may be a rather rookie question, but I want as much input as possible on this so I'm asking it anyways. We're having problems with users being timed out prematurely, before the 2hr time limit our client has decided upon. Everything has been setup in CFadministrator correctly, as 95% of the users are able to stay logged in for the 2hr time frame and have no problems. With the small percentage of users that are not being able to stay logged, the timeout is random and the server assigns a NEW jsessionid to them. Of course, when this happens all of the user info that is stored in session is lost, therefore they are gracefully kicked out of the site and asked to log in again. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275134 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: WebService Issue w/Special Characters being sent to XMLParse
You may have other issues there. If an ampersand is properly encoded as amp;, your replace() statement will make that amp;amp; Shouldn't the source of that XML be escaping the ampersand? -Original Message- From: James Blaha [mailto:[EMAIL PROTECTED] Sent: Friday, April 13, 2007 11:33 AM To: CF-Talk Subject: Re: WebService Issue w/Special Characters being sent to XMLParse All, Thanks for your posts, issue resolved using: CFFILE ACTION=READ FILE=c:\stock.xml VARIABLE=GotTheStockInfo cfset newXML = Replace(GotTheStockInfo, chr(38), amp;, ALL) cfdump var=#newXML# label=MyStockInfo cfset parsedStockInfo = XMLParse(newXML) cfdump var=#parsedStockInfo# label=MyStockInfo Have a great weekend! -Jim ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275167 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Finding one line of text in a large text file.
You might want to look into the Java string-handling functions. There's probably something there that will serve and should be plenty fast. -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 10, 2007 1:01 PM To: CF-Talk Subject: Finding one line of text in a large text file. Hello all. I am reading the contents of a tab delimited text file using cffile and the new line character. It may have up to 8500 lines. The last line will have a single line of text that reads eof,lines:WXYZ where WXYZ is the number of lines in the file. This last line signifies that the file is complete and not a partial file. Once I load the contents of the file with cffile, what would be the *most efficient* way that I could verify that the last line of this text file contains the needed text eof,lines:? Would the find function be my best bet, or something else? ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275026 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Arrays | Array + Structure
I don't know about speed and memory efficiency, but I would think that option 3 would be the easiest to work with and offer the best data integrity. Of course, I wouldn't write to the SESSION scope in each loop iteration. I'd write to a local variable and only write to SESSION when it was all done. -Original Message- Let's say I have table of building info. I need to recurse the info multiple times attach temporary variables to each building's info have the data persistent over multiple pages speed is essential (part of an emergency notification system) I see multiple ways to do this. 1) Load the data into a multi-dimensional array (except I still have a mental block on doing this) 2) Load the data into parallel arrays, e.g., SESSION.arrBldgNames SESSION.arrBldgWardens SESSION.arrBldgWardenEmail SESSION.arrBldgWardenEmailSent (temporary info) etc. Where arrBldgWardens[5] would match with arrBldgNames[5] (and there are several more fields of data to be accessed). 3) Use an array + structure, e.g., cfset SESSION.arrBldg = ArrayNew(1) cfloop index=x from=1 to=#BldgQuery.Recordcount# cfset SESSION.arrBldg[x] = StructNew() cfset SESSION.arrBldg[x].Name = BldgQuery.BldgName ... cfset SESSION.arrBldg[x].EmailSent = False etc. Does anyone have any idea which is more efficient insofar as memory used or speed of accessing the data? ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274628 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Returning a user's roles?
I'm using cflogin to authenticate users on a site. Is there a way to return the roles that a user is in (i.e. the roles that are passed in using CFLOGINUSER)? I'm using a very hackish method of looping through all of the roles for a site and using isuserinrole() to determine this, but was hoping that there was a more elegant solution. Apparently not. You'll probably need to put something in the SESSION scope to keep track of that. IsUserInRole() does accept a comma-delimited list of roles, if that helps. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274442 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Scheduler settings
I found the scheduler in version 5.0 and lower to be inherently unreliable. When we still had CF5.0, we used the NT scheduler and the CFML.EXE executable for our scheduled tasks. -Original Message- I have version 5.0 of CF. In the Scheduler I have set a cfm page to run every day at 9:15, but it does not. Its is checked as Daily at 09:15:00. There is a Start date of yesterday. Are there inherent problems with the Scheduler that I don't know about or is there a better way to do this? ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274196 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Werid cfqueryparam error...
null=#iif(COURSE.COU_LANGUAGE_STUDY IS '',de('Yes'),de('No'))#
Why not #yesNoFormat(COURSE.COU_LANGUAGE_STUDY IS '')# ?
~|
Macromedia ColdFusion MX7
Upgrade to MX7 experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion?sdid=RVJW
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274086
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Browser default home page
I think the JavaScript window.home() is what you're looking for. -Original Message- From: ch g [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 27, 2007 2:05 PM To: CF-Talk Subject: Re: Browser default home page I just want to redirect to their default home page once they are done with my site, i don't want to change browser settings. Any other way ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273908 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Error invoking CFC for gateway myGateway: String index out of range: -1
Well, thanks for all the feedback. Oddly, all of the gateways on our development server throw this error, but the same gateways work fine in our test and production environments. Code is all the same and the servers are SUPPOSED to be identical. Any ideas? -Original Message- Error invoking CFC for gateway myGateway: String index out of range: -1 Anyone have any experience with this error? The cfc is essentially empty at this point. It's an initiator gateway and all I have (after removing things trying to debug) is just an onIncomingMessage() function that doesn't do anything. I've restarted the gateway after each code change, but the error stays the same. Ideas? ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273507 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Error invoking CFC for gateway myGateway: String index out of range: -1
Error invoking CFC for gateway myGateway: String index out of range: -1 Anyone have any experience with this error? The cfc is essentially empty at this point. It's an initiator gateway and all I have (after removing things trying to debug) is just an onIncomingMessage() function that doesn't do anything. I've restarted the gateway after each code change, but the error stays the same. Ideas? ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273270 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
SparkPlug CMS
Anyone know what happened to the 13amp SparkPlug CMS? 13amp.com is suspended by the ISP and 13amp.net redirects to some learn Chinese site. ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272652 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Insert Looped Form Entry into Database
If you know the number range you're using, and there are no gaps, something like this should do the trick cfloop from=1 to=#upperbound# index=i cfquery datasource=#dsn# INSERT INTO ANSWERS ( QUESTION_ID, ANSWER ) VALUES cfqueryparam cfsqltype=CF_SQL_INTEGER value=#i#, cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#form[Q i]# ) /cfquery /cfloop The key is using array notation rather than dot notation: #form[fieldname] -Original Message- From: Joel Watson [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 06, 2007 7:37 AM To: CF-Talk Subject: Insert Looped Form Entry into Database I have a cfform that is dynamically populated with test questions and answer choices from a database. The answer choices are also dynamically named based upon the id of the question, e.g., input name=Q#QuestionID#. I am currently able, upon submit, to pass the values of user-selected answers, producing this: struct FIELDNAMESSUBMIT,Q1,Q2,Q3,Q4,Q5,Q6,Q7 Q1Mexico City Q2Seattle Q3London Q4Istanbul Q5True Q6HEre is an essay question Q7Here is an essay question SUBMITSubmit Test My question is how do I capture the fieldnames and values (i.e., Q1 - Mexico City) so that I can place them in a database when the fieldnames are being dynamically created? I initially tried an insert qualification like '#FORM.Q#QuestionID##', but obviously this does not work as CF complains about Q being undefined. Any ideas would be greatly appreciated! Joel ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271689 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Insert Looped Form Entry into Database
For one thing, you have too many pound signs. cfset mylist = listappend(mylist, #FORM[ 'Q#Results.QuestionID#' ]#) Should be cfset mylist = listappend(mylist, FORM[ Q#Results.QuestionID# ]) Where is Results.QuestionID coming from? If you're using this code inside of a loop for a query result, you either need to put that value in a local variable or explicitly name the row. Results.QuestionID[CurrentRow] -Original Message- From: Joel Watson [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 06, 2007 8:53 AM To: CF-Talk Subject: Re: Insert Looped Form Entry into Database Thanks for the quick response! This does work, but now I am running into another problem. While it submits the right number of entries to my database (in this case, 7), it submits the same value for all (e.g., Havanna, Havanna, Havanna, Havanna, Havanna, Havanna, Havanna). Here is the code that I am using: cfif isDefined(FORM.Submit) cfdump var=#form# cfparam name=mylist default= cfloop from=1 to=#Test.RecordCount# index=i cfset mylist = listappend(mylist, #FORM[ 'Q#Results.QuestionID#' ]#) /cfloop cfquery datasource=Test UPDATE Users SET AnswerID = '#mylist#' WHERE Username = existdissolve /cfquery /cfif The loop gives me the correct number of entries, but does not separate the values. If I do a straight loop of the query Results, it enters all the values, but duplicates each value per the number of answer options available. Again, I really appreciate both your guy's help! Joel Access the FORM struct using array notation: #FORM[ Q#QuestionID# ]# This should work the way you expect it to. . Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Joel Watson [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 06, 2007 7:37 AM To: CF-Talk Subject: Insert Looped Form Entry into Database I have a cfform that is dynamically populated with test questions and answer choices from a database. The answer choices are also dynamically named based upon the id of the question, e.g., input name=Q#QuestionID#. I am currently able, upon submit, to pass the values of user-selected answers, producing this: struct FIELDNAMESSUBMIT,Q1,Q2,Q3,Q4,Q5,Q6,Q7 Q1Mexico City Q2Seattle Q3London Q4Istanbul Q5True Q6HEre is an essay question Q7Here is an essay question SUBMITSubmit Test My question is how do I capture the fieldnames and values (i.e., Q1 - Mexico City) so that I can place them in a database when the fieldnames are being dynamically created? I initially tried an insert qualification like '#FORM.Q#QuestionID##', but obviously this does not work as CF complains about Q being undefined. Any ideas would be greatly appreciated! Joel ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271699 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: undefined in APPLICATION???
What am I doing wrong? Not scoping your variables. Application is not one of the scopes that CF searches when presented with an unscoped variable. You have to explicitly use the application scope prefix. ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271715 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Comparing two arrays or lists
Did you look at ListCompare ( http://www.cflib.org/udf.cfm?ID=149 ) ? ListDiff ( http://www.cflib.org/udf.cfm?ID=660 ) ? listsAreDistinct ( http://www.cflib.org/udf.cfm?ID=960 ) ? One of those sounds like it'll do what you want. -Original Message- From: Joel Watson [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 06, 2007 10:41 AM To: CF-Talk Subject: Comparing two arrays or lists I have two lists that I want to compare and be able to show the resulting differences. For example, if my first list has 1,2,3,4 and the second has 1,2,4,4, I want to be able to output that 3 and 4 are different. What would be the best way of going about this? I applied the arrayCompare UDF from cflib, but it only outputs a bollean for the entire comparison. I would like to be able to compare on a more detailed level and output the results. ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271736 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: GotCFM.Com Status Report
What are your plans for duplicates? I see that http://www.macworld.co.uk/ is listed twice, for instance. -Original Message- From: Rey Bango [mailto:[EMAIL PROTECTED] Sent: Monday, March 05, 2007 8:59 AM To: CF-Talk Subject: Re: GotCFM.Com Status Report Hi Claude, Please email me with any changes you need and I'll be happy to update the records. Rey Claude_Schnéegans wrote: Also, apart from the list, what else do you see can be put onto the site to help promote CF-based technologies? (everyone should feel free to jump into this discussion and offer suggestions) Is it possible to re-edit the records we sent? I see that I forgot to update the filed for the CF version, and the version is 3.x by default. ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271517 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: checking for best approach
Alternatively I could save the form data on the confirmation page to hidden values and then on the action page use the data in the hidden fields to write to the database. That's probably how I would approach it. Uncle Ben's CF_EmbedFields custom tag would make this easy. http://www.adobe.com/cfusion/exchange/index.cfm?view=sn131extID=101 #loc=en_usview=sn131extID=101viewName=Adobe%20Exchangeavm=1 ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271291 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: checking for best approach
And of course, I don't need to warn you about just blindly taking the data you've saved into the form and got then got handedd back and using it in SQL do I ? Of course not. I am a zealous user of cfqueryparam. ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271299 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: checking for best approach
I'd still parse the inital form into the session scope and just redisplay that though. Nothing wrong with either approach, of course. I had a couple of reasons for thinking form would be better. - I have to have a form for the configuration button anyway. - Sessions would have to be enabled. - If the user navigates away from the confirmation page I don't want the data to hang around. Of course, these might not apply in the original poster's case. As with so many things CF, there are multiple ways to accomplish the same thing. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271309 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: upload multiple images
cfif form[file i] is not
cffile ...
/cfif
-Original Message-
From: Rick King [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 01, 2007 9:50 AM
To: CF-Talk
Subject: upload multiple images
Hey all, I'm using the following script to allow users to upload 3
images. It seems to work fairly well, but I have 2 issues.
1. It errors unless a user uploads all 3 images. I'd like to give them
the option of only uploading 1 or 2 images.
2. I have a hidden form variable called IsPrimary that should set the
image in the first upload field to Yes and the other 2 to No (the
IsPrimary image is the one that shows up in searches, etc.) But with
this script, they're all being set to Yes
Any ideas on how to solve these 2 issues?
Thanks
Rick
cfparam name=SESSION.Auth.UserID default= cfparam
name=FORM.CatID default= cfparam name=FORM.Category default=
cfparam name=FORM.Designer default= cfparam name=FORM.Model
default= cfparam name=FORM.Color default= cfparam
name=FORM.Size default= cfparam name=FORM.Price default=
cfparam name=FORM.Material default= cfparam
name=FORM.Description default= cfparam name=FORM.IsPrimary
default=0
cftransaction
cfquery name=Product datasource=DB
SET NOCOUNT ON;
INSERT INTO Products (CatID, UserID, Designer, Model, Color, Price,
Material, Description, Status)
VALUES ('#Trim(FORM.CatID)#',
'#Trim(SESSION.Auth.UserID)#',
'#Trim(FORM.Designer)#',
'#Trim(FORM.Model)#',
'#Trim(FORM.Color)#',
'#Trim(FORM.Price)#',
'#Trim(FORM.Material)#',
'#Trim(FORM.Description)#',
'Pending');
SELECT @@identity AS ProdID FROM Products;
/cfquery
!--- Accept the file upload ---
cfloop from=1 to=3 index=i
cffile
action=upload
filefield=file#i#
result=cffile.file#i#
destination=#ExpandPath('users/uploads/')#
nameconflict=makeunique
accept=image/jpg, image/JPG, image/jpeg, image/JPEG, image/gif,
image/GIF, image/pjpeg, image/pjpg
!--- Resize, rename and set the quality of the image uploaded with
cfx_openimage ---
cfx_openimage
action=iml
name=qimages
file=#ExpandPath('users/uploads/')##cffile['file'i].serverFile#
commands=
setjpegdpi 72
setquality 100
setimage large=original
setimage thumb=original
## resize if either width or height is greater than 500
useimage large
resizeif 500,400
write
#ExpandPath('users/uploads/'cffile['file'i].serverFileName'.jpg')#
## resize if either width or height is greater than 100
useimage thumb
resizeif 100,75
write
#ExpandPath('users/uploads/th_'cffile['file'i].serverFileName'.jpg')#
!--- Upload to database ---
cfquery datasource=wioDB
INSERT INTO Images (ProdID, Image, IsPrimary)
VALUES (#Product.ProdID#,'#cffile['file'i].serverFile# ',
'#FORM.IsPrimary#')
/cfquery
/cfloop
/cftransaction
cflocation url=review.cfm?ProdID=#Product.ProdID#
~|
Create Web Applications With ColdFusion MX7 Flex 2.
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271145
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Show your support for CF - cfMaps.com
Whatever happened to the group on Frappr.com? -Original Message- From: Nicholas M Tunney [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 28, 2007 10:03 PM To: CF-Talk Subject: Show your support for CF - cfMaps.com I think this fits into the discussion over the last two days well (300k CF devs and gotcf.com): I've been putting together a community site for the last few weeks, and it is finally ready to be released. The site is called cfMaps.com http://www.cfmaps.com. Overall, it allows ColdFusion developers and ColdFusion sites to be geocoded and placed on a map of the world. I think I should be able to derive some pretty cool statistics in the long run. Companies can also search by zip code or country to find a CF developer. Check out the About http://www.cfmaps.com/index.cfm?event=main.showAbout page to see why I put this together and get a bigger picture of what the site does. My goal is to allow developers and managers to see how widespread ColdFusion really is. If you are a CF developer, I hope you register http://www.cfmaps.com/index.cfm?event=security.showUserForm. If you have a ColdFusion site, I hope you register the site http://www.cfmaps.com/index.cfm?event=website.showWebsite as well. - Nic ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271149 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Ideas and approaches
The CFPOP tag returns a query on action=getAll, which has a column BODY which presumably has the text that you want to manipulate. -Original Message- I have a plain text email that this pushed out when triggered by a third party app (BaseCampHQ). Inside Basecamp, I can point this email to any fixed address I choose. What I want to do is: receive this email inside CF, then parse the body, glitz it up with HTML, and resend out to a list of people. I would assume that I set up CFPop to receive the mail, but I don't know how to do is grab the text body of the message, so I can save in a var and paste into the new HTML message I create with CFMail. What is/are good approaches to doing that? Thanks for your help. Mark ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271001 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: ANN: GotCFM.Com is Launched - Dedicated to CF Evangelism
The U.S. Federal and State Governments love CF. Unfortunately, most of the uses of it (like mine) are on intranet applications. http://www.google.com/search?source=ighl=enq=index.cfm+*.govbtnG=Goog le+Search gives some of the public ones, though. ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270800 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: GotCFM.Com is Launched - Dedicated to CF Evangelism
If you want to keep the spam down, I suggest using rel=nofollow. You'll probably need a CAPTCHA at some point, too. -Original Message- From: Rey Bango [mailto:[EMAIL PROTECTED] Sent: Monday, February 26, 2007 11:22 PM To: CF-Talk Subject: ANN: GotCFM.Com is Launched - Dedicated to CF Evangelism Guys, for awhile, I've been griping up a storm via my blog and to whomever would listen that MM Adobe weren't doing enough to get the word out about CF. And while I still think that a lot of work needs to be done, I came to the realization that I also needed to do more than just post gripes. I recently read this post on Ray Camden's blog: http://ray.camdenfamily.com/index.cfm/2007/2/22/Help-spread-the-word-at- the-Peoples-Toolbox The quote that struck me was: apparently they had never heard of it, and I'm having a bit of trouble convincing them that a) lots of people use ColdFusion and b) that it is indeed worth adding to their site It hit me how bad of a job *all* of us have done in keeping ColdFusion in the limelight. ColdFusion and CFML just celebrated its 10th year and here's some new, unknown site questioning CF's worthiness. I was floored. So I decided to use a domain that I've had sitting around for some time as a vehicle for CF-related evangelism. http://www.gotcfm.com/ I am looking at GotCFM.com as a VERY niche site that's whole focus is to have information to help promote CF-related technologies. It won't allow people to search for the best way to create a CFC or which custom tag is available for zip code locations. There are plenty of top-notch sites for that. I want to build a place where anyone can go to find specific information such as: - A continuously updated list of sites using CF - Information on how to position CF within your company - Information on specific features that make CF better than other technologies - Case studies on successful implementations of CF - Powered by buttons - Banner ads that can be added to your site to promote your favorite CF engine Some of you may say, Well, Ben Forta already keeps a list of sites using CF, and that's certainly true. Ben has done a great job over the years of trying to get a nice list of sites. But, by no fault of Ben, its not all encompassing, its not up-to-date and it doesn't appear to include sites built using other technologies like Ralio, Coral or BlueDragon. We don't just need a list of Adobe ColdFusion powered sites. We need a list of ALL *CFML* powered sites. And we need a method of allowing people to submit these sites themselves. I hope to flush it out further, especially if I can get community support. I hope that this type of site, dedicated solely to methods of bi-partisan CF evangelism, will help spread the word about CFML. I've already received support from New Atlanta and hope to soon get the support of Adobe, Ralio and the whole CF-Community. Your feedback is welcome and your involvement would definitely be appreciated. You can start by submitting sites that powered by *ANY* CFML engine. That would be a great first step. If you have other ideas for the site, please let me know. Thanks, Rey Bango... ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270858 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Delimited list problems - a bug?
Sure. Replace the substring that you want to use as a list delimiter with a single character, then do your list operation. For the single character, be careful to use something that's unlikely to be in your data already. I like to use a non-printable character for this, like the Bell character (ASC 7, I think). I like to use CHR(30) for that, which is the record separator character. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267759 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Changes to Daylight Savings Time in 2007 may affect your data bases (DB2, Oracle and others)
Is 1.4.2_11 officially approved for use by Adobe for CFMX 6.1 and 7.02? http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=d2ab4470 ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267584 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Better way to send nulls to a Stored Proc?
1. a function that returns true if a string has length, and false if it doesn't, I like to use IsNull () ( http://www.cflib.org/udf.cfm?id=644 ) which should be easy to convert to IsNotNull(). ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267463 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfsearch issue
If you want to use a reserved word as part of the Verity search, you need to put it in quotes. Criteria=Why $50 per Barrel Oil is 'Not' Out of the Question -Original Message- From: Jason Herbolsheimer [mailto:[EMAIL PROTECTED] Sent: Friday, January 12, 2007 2:06 PM To: CF-Talk Subject: cfsearch issue Hello, I have run into a problem using a verity index and cfsearch. The problem I'm having is that the search string that is being used has the word Not in it. The search string is listed below, with the error I'm getting. The cfsearch code is listed below that. Does anyone know how I get around this issue? Thanks in advance. Search string: Why $50 per Barrel Oil is Not Out of the Question Error: Invalid search CRITERIA specified: Why AND $50 AND per AND Barrel AND Oil AND is AND Not AND Out AND of AND the AND Question. Code: cfset thekeyword = MANYSTEM replace(trim(keyword),' ',' AND ','ALL') cfsearch name = newsSearch collection = mycollection criteria =#thekeyword# type=explicit startrow=1 maxrows = 5000 Jason Herbolsheimer 11204 Davenport, Suite 200b Omaha, NE 68154 http://www.cfwebtools.com 402-408-3733 Ext 102 ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266423 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cfsearch issue
From what I'm reading, only AND, OR, and NOT will cause problems, as the other words need to be escaped with brackets in the search criteria. You could try this UDF, http://www.cflib.org/udf.cfm?ID=760, but I don't know if it's up to date for CFMX 7. -Original Message- From: Jason Herbolsheimer [mailto:[EMAIL PROTECTED] Sent: Friday, January 12, 2007 2:46 PM To: CF-Talk Subject: RE: cfsearch issue Is there a set list of reserved words that I can/should use? Is there a udf out there that I could use/modify to replace and surround these reserved words with single quotes? -Original Message- From: Everett, Al (NIH/NIGMS) [C] [mailto:[EMAIL PROTECTED] Sent: Friday, January 12, 2007 1:18 PM To: CF-Talk Subject: RE: cfsearch issue If you want to use a reserved word as part of the Verity search, you need to put it in quotes. Criteria=Why $50 per Barrel Oil is 'Not' Out of the Question -Original Message- From: Jason Herbolsheimer [mailto:[EMAIL PROTECTED] Sent: Friday, January 12, 2007 2:06 PM To: CF-Talk Subject: cfsearch issue Hello, I have run into a problem using a verity index and cfsearch. The problem I'm having is that the search string that is being used has the word Not in it. The search string is listed below, with the error I'm getting. The cfsearch code is listed below that. Does anyone know how I get around this issue? Thanks in advance. Search string: Why $50 per Barrel Oil is Not Out of the Question Error: Invalid search CRITERIA specified: Why AND $50 AND per AND Barrel AND Oil AND is AND Not AND Out AND of AND the AND Question. Code: cfset thekeyword = MANYSTEM replace(trim(keyword),' ',' AND ','ALL') cfsearch name = newsSearch collection = mycollection criteria =#thekeyword# type=explicit startrow=1 maxrows = 5000 Jason Herbolsheimer 11204 Davenport, Suite 200b Omaha, NE 68154 http://www.cfwebtools.com 402-408-3733 Ext 102 ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266455 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF7 and tasks won't run through scheduler
Are you using any kind of third party user authentication, like SiteMinder. I ran into exactly this. When I entered the URLs in my own browser I was already authenticated with SiteMinder, so they ran. When ColdFusion tried to run them it, of course, didn't authenticate with SiteMinder. Since Siteminder returns a 200 OK no matter what, to ColdFusion the template ran. Our solution was to create a special website for scheduled tasks that doesn't use authentication. To keep it secure we restricted the Ips that it would respond to. -Original Message- From: Earl, George [mailto:[EMAIL PROTECTED] Sent: Thursday, January 11, 2007 11:09 AM We're running CF Enterprise 7.0.2 on Win2k. A couple of days ago I created a whole bunch of scheduled tasks. None of these tasks work through the scheduler itself nor through clicking on the 'Run Scheduled Task' icon on the scheduled tasks page in CFAdmin. If I do the latter I get a message at the top of the scheduled task page that says the task was run successfully and I get a corresponding entry in the scheduler.log file. However the task doesn't do what it is supposed to do - it's like it didn't really run. If I let the scheduler run the tasks as scheduled I get the same messages in scheduler.log that say the tasks ran successfully but they really haven't. If I copy the URLs in the scheduled task setup page and drop them into a browser and run them they work fine. We restarted the CF Application service and tried again but that didn't fix the problem. I deleted and recreated a task but that didn't fix it. Other tasks that I had created in the past work just fine. Any ideas what might be causing this problem? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266245 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: List of Sections from an initialisation file
listOfSections = structKeyList(getProfileSections(inifile.ini)) I've done such a thing. Let me see if I can dig up my code... cffunction name=loadFromINI access=public output=false returntype=struct hint=Given a fully-qualified path to an *.ini file, returns a structure with the key/value pairs in that file. If useGroups is true, uses the group name(s) to create a structure of structures. cfargument name=pathToINI required=yes type=string cfargument name=useGroups default=true type=boolean cfset var local=structNew() cfset local.returnStruct=structNew() cfset local.sectionStruct=getProfileSections(arguments.pathToINI) cfloop collection=#local.sectionStruct# item=local.item cfset local.workingStruct=structNew() cfloop list=#local.sectionStruct[local.item]# index=local.key cfset local.workingStruct[local.key]=getProfileString(arguments.pathToINI,loca l.item,local.key) /cfloop cfif arguments.useGroups cfset local.returnStruct[local.item]=duplicate(local.workingStruct) cfelse cfset structAppend(local.returnStruct,local.workingStruct,yes) /cfif /cfloop cfreturn local.returnStruct /cffunction I then generally add this structure to the application scope. HTH -Original Message- From: James Buckingham [mailto:[EMAIL PROTECTED] Sent: Thursday, January 11, 2007 10:13 AM To: CF-Talk Subject: List of Sections from an initialisation file Hi everyone, Is there any way that I can get a list of all the sections within an ini file through ColdFusion? If I use getProfileSections and dump it I'm seeing each section + all the variables included with them. All I want, for now, is the section names. What I'm looking to do is setup a simple dynamic loop which uses the list to grab each section, insert its variables into a struct and place this in my application. That way if I add a new section to the ini. file I don't have to worry about extending my CF code to accommadate it. Or is there an easier way I could be doing this? Cheers, James ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266252 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Number to currency words
Try DollarAsString http://www.cflib.org/udf.cfm?ID=58 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, January 08, 2007 11:53 AM To: CF-Talk Subject: Number to currency words Is there anything out there that will take a number and convert it to words like you would have on a check? Example 12.45 would become twelve dollars and forty five cents. Lee ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266165 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Number to currency words
Of course, if you wanted to roll your own, judicious use of NumberAsString() should serve you well. -Original Message- From: Everett, Al (NIH/NIGMS) [C] Sent: Wednesday, January 10, 2007 3:06 PM To: CF-Talk Subject: RE: Number to currency words Try DollarAsString http://www.cflib.org/udf.cfm?ID=58 ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266166 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: dmoz
My first organizational request would be for a Mailing Lists section to showcase all of the ColdFusion specific mailing lists. This does benefit me a little as each list here is a separate entity (like the various google or yahoo lists), but not all of them are ColdFusion specific. You'll not get every mailing list with its own listing. Since houseoffusion.com is listed in the main category, it's unlikely that any deeplinks from there will be in subcategories. See the editing guidelines: http://dmoz.org/guidelines/site-specific.html#deeplinks I'd be happy to compile a collection of all of the ColdFusion related lists from Google, Yahoo, and independent sources (CFCDev, CFDJ, etc.) Go for it. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265070 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Using arrays in a simple bean
I'm using a bean cfc for an instance of a meeting. Each meeting can have between 0 and 10 sponsors. (These are just string values.) Rather than have setSponsor1, getSponsor1, setSponsor2 etc. and have 10 different properties in the instance, I thought I'd put it into an array. This has two other side effects: Memory isn't taken up by undefined variables and it should easily allow for future expansion/contraction if the business rules should change. I'm having a bit of trouble getting my head around the best way to do the getter/setter methods. Has anyone done something similar that I could crib for ideas? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264734 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using arrays in a simple bean
No, no reason, except a structure with numbers as keys is essentially an array anyway. That doesn't help me with best practices for getting the data into and out of the instance. -Original Message- From: Qasim Rasheed [mailto:[EMAIL PROTECTED] Sent: Thursday, December 21, 2006 12:28 PM To: CF-Talk Subject: Re: Using arrays in a simple bean Is there are reason you cannot use Structure for meeting sponsors? e.g. cfset variables.instance.sponsors = StructNew() / cfset variable.instance.sponsors[sponser1] = 'Name of Sponsor' / .. HTH On 12/21/06, Everett, Al (NIH/NIGMS) [C] [EMAIL PROTECTED] wrote: I'm using a bean cfc for an instance of a meeting. Each meeting can have between 0 and 10 sponsors. (These are just string values.) Rather than have setSponsor1, getSponsor1, setSponsor2 etc. and have 10 different properties in the instance, I thought I'd put it into an array. This has two other side effects: Memory isn't taken up by undefined variables and it should easily allow for future expansion/contraction if the business rules should change. I'm having a bit of trouble getting my head around the best way to do the getter/setter methods. Has anyone done something similar that I could crib for ideas? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264768 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Using arrays in a simple bean
No, no, that's not what I need. The sponsor is just a string value in the meeting object. I don't need an array of sponsor objects. I just need an array of strings in my object. Now that I think about it some more, I'm going to be working with the data as a list almost exclusively. As such, getSponsorList() and setSponsorList() are fairly straightforward. How I actually store them in the instance is really immaterial. Is it a bad thing to have private methods in a bean in case I need to do some manipulation of the array under the covers? -Original Message- From: Teddy Payne [mailto:[EMAIL PROTECTED] Sent: Thursday, December 21, 2006 12:36 PM To: CF-Talk Subject: Re: Using arrays in a simple bean Al, When you deal with one record or one sponsor at a time, you can use a getter/setter bean to modify its data. If you individually want to modidy a group of them, a typical useage is an array of bean objects. The array of bean objects gets expensive though creating all of the objects. If you just want to just output them, you would create a gateway, which would just return a query of the sponsors. Since you are dealing with only 10 though, you may be able to get away with an array of beans aka value objects. I would definitely test performance. Teddy On 12/21/06, Everett, Al (NIH/NIGMS) [C] [EMAIL PROTECTED] wrote: I'm using a bean cfc for an instance of a meeting. Each meeting can have between 0 and 10 sponsors. (These are just string values.) Rather than have setSponsor1, getSponsor1, setSponsor2 etc. and have 10 different properties in the instance, I thought I'd put it into an array. This has two other side effects: Memory isn't taken up by undefined variables and it should easily allow for future expansion/contraction if the business rules should change. I'm having a bit of trouble getting my head around the best way to do the getter/setter methods. Has anyone done something similar that I could crib for ideas? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264769 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Posting variables
I've done something like that. My method was to have a hidden form field with the original data and compare it to the submitted data. input type=text name=userName value=#variables.userName# input type=hidden name=userName_orig value=#variables.userName# !--- Action page --- cfif form.userName neq form.userName_orig !--- Add username to data to update --- ... /cfif Of course, I'd loop on form.fieldnames (or a custom list of field names to check) so I wouldn't have to repeat the same code for every field. Another option might be to use JavaScript to disable the unchanged fields. Disabled fields aren't in the FORM scope of the action page. -Original Message- From: Richard White Sent: Monday, September 25, 2006 1:54 PM To: CF-Talk Subject: Posting variables Hi, i am used to programming standalone computer applications not internet applications and would really appreciate some advice. I have a form with quite a few fields (text boxes etc...) on it. For additiional HCI, when the user edits the form from pre-exsting data, i like to have the fields all green, then if they edit some of the fields they turn red, to show that the changed data needs to be saved. To lesson the load on the database interation, i would like to program it so that when the user clicks save changes, it only updates the database based on the fields that are red. This is quite simple in standalone computer apps as i just code it to look for the fields that are red, but of course with the internet apps i cant check this as when the user clicks submit the fields are gone. Can anyone give me some advice on how this can be done. I am a bit lost with this. Thanks ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254090 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: The best free word editor?
openoffice.org -Original Message- From: Will Tomlinson Sent: Thursday, September 21, 2006 8:48 PM To: CF-Talk Subject: OT: The best free word editor? I haven't been able to reinstall any word editors since my puter crashed a few months back. What's the best free editor out there? I'll google for one but thought I'd get some input. Thanks, Will ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253846 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: SESSION won't save on user's computer
A software firewall, perhaps, that is blocking cookies? -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Friday, September 22, 2006 11:39 AM To: CF-Talk Subject: RE: SESSION won't save on user's computer I believe so, but it does this in both IE AND a fresh install of Firefox. Wouldn't you think that cookies would be turned on by default in FF? I checked for cookies in IE, but not specifically in FF. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253853 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: isdefined() error
Syntactically correct ColdFusion variables contain letters, numbers, and the underscore. -Original Message- From: Chad Gray Sent: Monday, September 11, 2006 11:11 AM To: CF-Talk Subject: isdefined() error Isdefined is giving me an error when a form variable has a slash character in it. Error: Parameter 1 of function IsDefined, which is now Form.ItemRemove_/XP106, must be a syntactically valid variable name. Code: cfif IsDefined(Form.ItemRemove_ thisItemNum) What is syntactically valid for CF variable names? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252771 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: directory listener
One of the sample asynchronous gateways that ships with CFMX 7 is a directory watcher. -Original Message- From: Crow T Robot Sent: Thursday, August 31, 2006 3:14 PM To: CF-Talk Subject: directory listener Anyone know of a way to create a listener that would listen to a directory and send an email out when a file is modified/created? I have a client who is insisting on getting FTP access, and considering their level of expertise (I know DreamWeaver! I can write my own code now!), I'd like to be the fly on the wall for a little while. Strictly for the sake of entertainment, of course. :-) ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251672 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: File attachment after user error
Basically, it can't be done. Not with HTML and JavaScript, anyway. It's a security issue. What you're seeing is by design. You'd have to use something other than input type=file. -Original Message- From: Casey C Cook Sent: Thursday, August 31, 2006 3:03 PM To: CF-Talk Subject: File attachment after user error Once again Ive run into one of those seems so easy, yet its so hard situations. Basically, a user has the ability to attach up to 3 files on a form input type = file. If the user throws an error, such as forgetting to input a required field, the form will submit and go through validation.cfm since they didnt pass the validation they will come back to the submission screen. The problem is, I know the user has input/attached a file, but browser security prevents me from populating the input field with the previous entry. Does anyone know a good way around this? I want to keep all the same logic in place, just be able to somehow recognize the user has already made the effort to attach the file and be able to submit that information after they correct their error. So far we have discussed many other solutions which will work, but require a coding effort greater than what should seem so easy - populate the freaking value the user has entered previously. Seems like I run across one of these scenario's once every six months and just wonder why things seem so easy when talking about it, but next to impossible in practice. Ive spent way too much time on this, any input would be greately appreciated. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251671 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF bringing down IIS Application Pool
Following up. After going round-and-round with the hardware guys, they finally called Microsoft who had them get a crash dump. MS's analysis says that the culprit is JRUN_IIS6_WILDCARD.DLL. 00d51264 77bcde94 00d51280 1000d60f 00d532f0 msvcrt!_output+0x6a7 00d512a0 10001d02 00d522cc 0fff 1000d600 msvcrt!_vsnprintf+0x2d 00d8fe2c 5a32150f 00d93b60 00d934f8 jrun_iis6_wildcard!TerminateExtension+0xa2 00d8fe48 5a3991f1 00d93ad8 10001480 00d8fe74 w3isapi!ProcessIsapiRequest+0x204 00d8fe7c 5a3992a0 00d934f8 w3core!W3_ISAPI_HANDLER::IsapiDoWork+0x2ac 00d8fe9c 5a394bf0 00d8fef0 00d928d8 0001 w3core!W3_ISAPI_HANDLER::DoWork+0xae [snip] The file is: D:\CFusionMX\runtime\lib\wsconfig\1\jrun_iis6_wildcard.dll Timestamp:Thu Jan 06 14:24:33 2005 (41DD9E81) File version: 4.0.5.25479 ProductName: Macromedia JRun Application Server MS's suggestion is to replace the file with a newer one. Okay, I can see instructions in the Adobe Knowledgebase on how to do that, but I'm not finding anything which talks about this file bringing down IIS. Am I missing it? Also, how can this file be implicated when the most reliable scheduled task in bringing down the Application Pools was the one that ran every 61 seconds and called a vanilla HTML file? -Original Message- Got a scenario I'm currently investigating. Our test and production machines are crapping out on a daily basis. It appears that something ColdFusion is doing is bringing down the IIS application pool. Oddly, the identically-configured development server is unaffected. What would cause that to happen? A runaway memory leak? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251520 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF bringing down IIS Application Pool
Try downloading the latest wsconfig and rerunning the connection to IIS. I believe it will create wsconfig\2 folder with the newer dll in it. I'll pass that along. If all else fails, reinstall windows, Unlikely. or better yet install apache :-P Not an option. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251530 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfloop conditional help
I don't think you need to loop at all. Your ranges are 10 numbers apiece, right? cfset currentValue=72 cfset rangeSize=10 !--- Use integer division --- cfset startValue=currentValue \ rangeSize * rangeSize + 1 cfset endValue=startValue + rangeSize - 1 \ is the operator for integer division. 72 \ 10 = 7 * 10 = 70 + 1 = 71 71 + 10 = 81 - 1 = 80 -Original Message- From: [EMAIL PROTECTED] Sent: Friday, August 25, 2006 3:07 AM To: CF-Talk Subject: cfloop conditional help I want to loop over a URL.VIDEO_ID value and find the numeric range it falls in. The value range needs to be between 1-10 or 11-21 etc. until the condition is met. EXAMPLE: if the URL.VIDEO_ID value is 72 I would want to cfloop until I found the range that this 72 value fit and then set variables like ... CFSET start = 71 and CFSET end = 80 I have ... CFSET START = 1 CFSET END = 10 THIS IS WHERE I NEED HELP CFLOOP condition=URL.VIDEO_ID GREATER THAN OR EQUAL TO START OR URL.VIDEO_ID LESS THAN OR EQUAL TO END step=10 /CFLOOP D- ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251018 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: storing registry in a datastore
Do you mean storing CLIENT variables? -Original Message- From: Maureen Barger Sent: Thursday, August 24, 2006 1:15 PM To: CF-Talk Subject: storing registry in a datastore When doing this, do I need to define any tables or columns? Or simply create the instance and let ColdFusion do its thing? cfmxe 7.01 under solaris. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250891 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFQUERY of non-swequential primary key ids
How very inefficient. How about something like this: cfquery name=get_vid_ids datasource=#datasource# SELECT vidwee_id FROM vidweek /cfquery cfset idList=valueList(get_vid_ids.vidwee_id) cfset idPosition=randRange(1,listLen(idList),SHA1PRNG) cfset VAL_ID=listGetAt(idList,idPosition) CFQUERY name=get_vids2 datasource=#datasource# select vow_up_lgnail_file,vidwee_id,vow_title from vidweek where vidwee_id = #VAL_ID# /CFQUERY CFSET lgthbimg = #get_vids2.vow_up_lgnail_file# There is also a function on CFLIB to randomly select rows from a database table: http://www.cflib.org/udf.cfm?id=524 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 23, 2006 12:14 PM To: CF-Talk Subject: CFQUERY of non-swequential primary key ids All, I'm doing a query and randomly displaying images from within each record but records have been removed so I don't have sequential id values. PROBLEM: When I run this code sometime I get images, sometimes I get nothing. Should I be running a different random'izer? 8-) Any ideas? CODE: !--- GET 2ND VALUE TO BE PASSED TO RANDRANGE --- CFQUERY name=get_vids_a datasource=#datasource# maxrows=1 select * from vidweek order by vidwee_id desc /CFQUERY !--- GET 1ST VALUE TO BE PASSED TO RANDRANGE --- CFQUERY name=get_vids_b datasource=#datasource# maxrows=1 select * from vidweek order by vidwee_id asc /CFQUERY cfset VAL_ID = #RandRange(get_vids_b.vidwee_id, get_vids_a.vidwee_id, SHA1PRNG)# !--- USE THAT ID VALUE TO SET IMAGE NAME --- CFQUERY name=get_vids2 datasource=#datasource# select vow_up_lgnail_file,vidwee_id,vow_title from vidweek where vidwee_id = #VAL_ID# /CFQUERY CFSET lgthbimg = #get_vids2.vow_up_lgnail_file# img src=VideoOfTheWeek/home/cfoutput#lgthbimg#/cfoutput width=262 height=231 border=0 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250754 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Sorting by Column Headers
Well, yeah, because the form variables don't exist because you're not submitting a form. There are a couple of ways I would attack this: 1. Cache the initial query to the session scope. Then do a query of query to sort when one of the headers is clicked. 2. Have the form use method=get so that query criteria are in the URL, use URL variables in the query, and adjust the links in the headers to include the initial criteria. Option 1 is best, I think, because it only has one trip to the database per search. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250787 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Parsing an XML Feed
cfset localDir=getDirectoryFromPath(currentTemplatePath()) cffile action=write file=#localDir#test.xml output=#cfhttp.filecontent# -Original Message- How would I write the file to my filesystem, could you explain please. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250603 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF Rules on including Application.cfm
Uh...not as I understand it. CF looks for an Application.cfm in the current template's directory. If one isn't found it looks in the next higher directory and keeps moving up the directory tree until it finds an Application.cfm or reaches the root directory. It never runs more than one Application.cfm unless you do something like cfinclude template=../Application.cfm in an Application.cfm file. Note that CFMX7 will use Application.cfc if one is found and ignore Application.cfm. -Original Message- From: Munson, Jacob Sent: Monday, August 21, 2006 1:00 PM To: CF-Talk Subject: RE: CF Rules on including Application.cfm It is as simple as you stated. If you run a .cfm file, ColdFusion looks for an Application.cfm file in it's directory, and in the parent application's root directory. It will run both of those (assuming there is a lower level directory Application.cfm file) -Original Message- From: Robertson-Ravo, Neil (RX) Sent: Monday, August 21, 2006 8:53 AM Does anyone know what the rules are for ColdFusion including Application.cfm? I mean, it cannot be as simple as you have requested a ..cfm file, I am gonna look for an Application.cfm now is it? Does it look into headers etc? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250474 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF bringing down IIS Application Pool
Got a scenario I'm currently investigating. Our test and production machines are crapping out on a daily basis. It appears that something ColdFusion is doing is bringing down the IIS application pool. Oddly, the identically-configured development server is unaffected. What would cause that to happen? A runaway memory leak? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250277 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF bringing down IIS Application Pool
Hmmm...there is a distinct lack of named locks around some cffile calls in a scheduled task. (Not my code.) A possible culprit? The other difficulty here is that this was not happening until after some access changes had been made to allow a directory to be accessed by an anonymous web user for a scheduled task. There's nothing really that exotic going on. -Original Message- From: Dave Watts Sent: Friday, August 18, 2006 12:48 PM To: CF-Talk Subject: RE: CF bringing down IIS Application Pool Got a scenario I'm currently investigating. Our test and production machines are crapping out on a daily basis. It appears that something ColdFusion is doing is bringing down the IIS application pool. Oddly, the identically-configured development server is unaffected. What would cause that to happen? A runaway memory leak? The only part of CF that runs within the IIS application pool is the ISAPI filter and/or extension that is installed by the web server configuration utility. Generally, all that does is pass requests to the CF server, but I believe that it handles a more significant part of file uploads via CFFILE and downloads via CFCONTENT, so I'd look at those first. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250308 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Register CF 7 after developer install
Simply go into the ColdFusion Administrator and enter your serial number. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250195 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cfqueryparam acting up
A space perhaps? cfqueryparam value=#trim(URL.productID)# cfsqltype=cf_sql_integer / -Original Message- From: Richard Cooper Sent: Wednesday, August 16, 2006 10:51 AM To: CF-Talk Subject: cfqueryparam acting up Hi, I've recently been getting some odd occurrences when using cfqueryparam. For instance I've have a table products. Everything was fine until recently when a product was updated via a CMS system. Each product that was edited after this point had this error when attempted to view in a listing: [code] [Macromedia][SQLServer JDBC Driver]Value can not be converted to requested type. The error occurred in W:\inetpub\wwwroot\testsite\www\untitled.cfm: line 4 2 : SELECT * 3 : FROM products 4 : WHERE productID = cfqueryparam value=#URL.productID# cfsqltype=cf_sql_integer / 5 : /cfquery 6 : SQLSELECT * FROM products WHERE productID = (param 1) [/code] For example I went to ?productID=285 and it would break but ?productID=395 would be fineboth of which a integers, so both should work. I removed the cfqueryparam to leave: WHERE productID = #URL.productID# and everything worked fine? To get it working I have to change the SELECT * and list all of the fields required. The problem seems to be happening only when using cfqueryparam and only on columns that are: INTEGER IDENTITY(1,1) PRIMARY KEY I'm using CF MX 7 SQL Server 2000 on a windows 2000 platform. Has anyone else experienced such problems or know if I'm doing something wrong ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249982 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Transform Unicode characters
What does preg_replace do that REReplace() doesn't? -Original Message- From: Dmitrii Dimandt [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 16, 2006 11:04 AM To: CF-Talk Subject: Re: Transform Unicode characters Because it transforms charactrs into garbage (sth. like %C4%B1 for ı). And I need human-readable format :)) Anyway. I guess I'll stick to my XML solution. I read mappings from a UTF-8 encoded XML file into arrays and then iterate over them and replace whatever characters I need. I miss PHP's preg_replace :))) ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249989 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Transform Unicode characters
Couldn't a UDF get close to that? cffunction name=REReplaceByArray returntype=string cfargument name=patternArray type=array required=yes cfargument name=replacementArray type=array required=yes cfargument name=stringValue type=string required=yes cfset var i=0 cfset var returnString= cfif arrayLen(arguments.patternArray) neq arrayLen(arguments.replacementArray) cfthrow message=patternArray and replacementArray are not the same size. /cfif cfset returnString=arguments.stringValue cfloop from=1 to=#arrayLen(arguments.patternArray)# index=i cfset returnString=REReplace(returnString,patternArray[i],replacementArray[i],all) /cfloop cfreturn returnString /cffunction cfset myString=The quick brown fox jumped over the lazy dog. cfset patterns=arrayNew(1) cfset patterns[1] = quick cfset patterns[2] = brown cfset patterns[3] = fox cfset replacements=arrayNew(1) cfset replacements[3] = bear cfset replacements[2] = black cfset replacements[1] = slow cfoutput#REReplaceByArray(patterns,replacements,myString)#/cfoutput Needs a bit of tweaking, but... -Original Message- From: Dmitrii Dimandt [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 16, 2006 12:08 PM To: CF-Talk Subject: Re: Transform Unicode characters Accepts arrays for both patterns and replacements. From the docs: ?php $string = 'The quick brown fox jumped over the lazy dog.'; $patterns[0] = '/quick/'; $patterns[1] = '/brown/'; $patterns[2] = '/fox/'; $replacements[2] = 'bear'; $replacements[1] = 'black'; $replacements[0] = 'slow'; echo preg_replace($patterns, $replacements, $string); ? But anyway, problem solved... In a way... On 8/16/06, Everett, Al (NIH/NIGMS) [C] [EMAIL PROTECTED] wrote: What does preg_replace do that REReplace() doesn't? -Original Message- From: Dmitrii Dimandt [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 16, 2006 11:04 AM To: CF-Talk Subject: Re: Transform Unicode characters Because it transforms charactrs into garbage (sth. like %C4%B1 for ý). And I need human-readable format :)) Anyway. I guess I'll stick to my XML solution. I read mappings from a UTF-8 encoded XML file into arrays and then iterate over them and replace whatever characters I need. I miss PHP's preg_replace :))) ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250013 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: OT: Anyone else affected by the hostmysite outage?
Call before you dig! I expect there will be a lawsuit or three out of this. -Original Message- From: Casey Dougall [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 16, 2006 2:50 PM To: CF-Talk Subject: Re: OT: Anyone else affected by the hostmysite outage? ha... they posted photos of the pipe... I guess we can believe them now. http://hostmysite.com/emergency/ ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250037 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ColdFusion extensions for Dreamweaver MX 2004 - non-administrator
I work in a locked-down environment. I cannot install software myself nor choose different tools to use. We're using CFMX 7, so naturally I want the extensions for Dreamweaver MX 2004. I cannot install them as I do not have administrative rights to my machine. One of the tech guys can install it as an administrator but it's only installed for that user account and doesn't work for me. I've not found anything in the Adobe knowledgebase yet. Any ideas? No, I cannot use CFEclipse. No, I cannot get administrative rights to my machine. Yes, Dreamweaver 8 may be an option, but that's a whole other request process and who-knows-how-long a wait. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249830 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Multiple joins between the same tables.
So alias it. SELECT c1.COMPANY_NAME AS BRAND_NAME, c2.COMPANY_NAME AS LABEL_NAME, c3.COMPANY_NAME AS MANUFACTURER_NAME, c4.COMPANY_NAME AS PUBLISHER_NAME, c5.COMPANY_NAME AS STUDIO_NAME -Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 10:40 AM To: CF-Talk Subject: RE: Multiple joins between the same tables. Look good to me. What's wrong? You can use the same table multiple times or even joing a table on itself. I personally would use a LEFT JOIN, but it depends what your goal is. The problem with using... LEFT JOIN t_PI_Companies c1 ON (c1.CompanyID = m.BrandID) LEFT JOIN t_PI_Companies c2 ON (c2.CompanyID = m.LabelID) LEFT JOIN t_PI_Companies c3 ON (c3.CompanyID = m.ManufacturerID) LEFT JOIN t_PI_Companies c4 ON (c4.CompanyID = m.PublisherID) LEFT JOIN t_PI_Companies c5 ON (c5.CompanyID = m.StudioID) Is that the column CompanyName in the t_PI_Companies table isn't aliased for each join so whatever the BrandID is from the main table is returned 5 times simply as CompanyName. What I need is some way for the CompanyName to be returned 5 times with 5 different names so each can be accessed separately. I could do it by leaving out the companies and simply querying them separately but I would prefer one query to six if at all possible. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249846 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ColdFusion extensions for Dreamweaver MX 2004 - non-administrator
CF Eclipse doesn't require an install. You just execute the exe. Although that could have all kinds of policy repercussions I would imagine. Indeed. I'm not allowed. Not if I want to stay employed, which I do. I'm surprised that NIH is that locked down. The software is approved throughout pretty much the entire federal government. Not necessarily NIH, but the individual institute. What is blocking you from installing the extensions? Can't you just run the built in extension manager? The extension manager runs, but I am informed that I have insufficient privileges to complete the installation. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249845 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: ColdFusion extensions for Dreamweaver MX 2004 - non-administr ator
I'll pass that along, thanks. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 11:44 AM To: CF-Talk Subject: RE: ColdFusion extensions for Dreamweaver MX 2004 - non-administr ator I cannot install them as I do not have administrative rights to my machine. One of the tech guys can install it as an administrator but it's only installed for that user account and doesn't work for me. Your administrator can handle this for you, with a little bit of work: http://www.windowsitpro.com/Article/ArticleID/50102/50102.html?Ad=1 Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249859 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFDumping a bean
Did you try getMetaData()? -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 12:23 PM To: CF-Talk Subject: CFDumping a bean I want to dump a bean, but a dump on a bean only gives me a list of the functions. How do you dump a bean? Do you create a function that displays the parameter with the value? Or another way? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249860 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: OT - Nice site I will recommend you to all my friends.
It's likely they're testing their system so they can charge people to send their spam. We can guarantee your message will appear on 50,000 websites and will be indexed by Google within 1 week! -Original Message- From: Les Mizzell Sent: Friday, August 11, 2006 9:50 AM To: CF-Talk Subject: Re: OT - Nice site I will recommend you to all my friends. Having no link in the message of any kind threw me off at first. Why not go ahead and try to post all the intended spam the first time around instead of a two tiered attack? Twice the work to do it that way, right? . unless there's something a little more sinister in store at a later date for the vunerable form addresses that get collected. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249569 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFIF inside a Form
aolMe too./aol -Original Message- From: loathe Sent: Friday, August 11, 2006 10:39 AM To: CF-Talk Subject: RE: CFIF inside a Form I prefer: select cfif value eq url.value cfset selected = selected cfelse cfset selected = /cfif option value=#value# #selected# #text# /option /select ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249594 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: (Admin) Security bulletin - ColdFusion AdminAPI Authentication Issue
their RSS Notification feed Got an URL? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249622 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Development Environment Setup
Then your security team is full of idiots. No comment. I wish to remain gainfully employed so I just deal with it. I have pointed out several times that this prevents from using some of the power of source versioning, like branching, and interferes with unit testing, among other issues. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249462 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Storing hard coded data - advice?
Simplest, to me anyway, would be a config.ini file with the data needed. Second choice would be XML. Third choice a database table. Option 3 really requires a front-end, as letting people directly edit in the database gives me the heebie-jeebies. The other two, not so much, although it's do-able. -Original Message- From: Peterson, Chris Sent: Thursday, August 10, 2006 3:25 PM To: CF-Talk Subject: Storing hard coded data - advice? I have about 12 excel pages of GL Accounts that I have been asked to build reports on. I have separate GL lists for 4 different companies, and each company's data is grouped into categories (Fuel, Property Taxes, Payroll, etc), and have a variable number of GL's per category. Each account is designated as a Major (only match left 4 characters) or Minor account (match all 6 characters). The accountants are telling me this data won't change often (at most they will add an account, or edit once a year) My question is, how would you store this information? Would you just make a SQL table to store it all, or perhaps a structure or array in a config.cfm file that stores it all? Create an XML file? Also, would you bother putting a front end so the users can edit this, or just leave in the DB to be edited by IT only? My source data is a mashup of several iSeries/AS400 data tables. I know several ways to do this, I am just looking for your thoughts or idea's, maybe make this more painless down the road. =) Chris Peterson Gainey Corporation ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249504 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFIF inside a Form
Is it possible there's a null value in that column? That would result in an empty string for CF and gt would be an invalid operator. cfif val(getDollDetails.price) gt 0 might be better. -Original Message- From: Donna French [mailto:[EMAIL PROTECTED] Sent: Thursday, August 10, 2006 5:02 PM To: CF-Talk Subject: CFIF inside a Form I'm trying to use the following code inside a FORM tag that uses POST: cfif getDollDetails.price gt 0 input type=hidden name=price value=#Trim(getDollDetails.price)# cfelse input type=hidden name=price value=#Trim(getDollDetails.srp)# /cfif Is there a trick to doing this because I've written similar code without problems. The error says: An error occurred while evaluating the expression: price GT 0 I'm scoping the price variable and quad checked the name of the query. What am I missing here??? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249515 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Sessions seem to go away for some (CFMX701-Linux)
Wasn't this problem fixed in CFMX 7? -Original Message- From: Kris Jones Sent: Wednesday, August 09, 2006 7:57 AM To: CF-Talk Subject: Re: Sessions seem to go away for some (CFMX701-Linux) If you use CFLOCATION on the same template after a CFCOOKIE set, the cookie will not be set. I've also found this behavior to vary depending on version of CF (works on 4.5, and 5, but not MX6 or MX7). ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249302 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Scheduled tasks
Is there a way to programmatically get data from currently defined scheduled tasks without parsing the neo-cron.xml file? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249341 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Scheduled tasks
Is there a way to programmatically get data from currently defined scheduled tasks without parsing the neo-cron.xml file? Nevermind. I found an answer. http://www.bpurcell.org/blog/index.cfm?mode=entryentry=935 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249349 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Scheduled tasks
Here's the Google cache http://216.239.51.104/search?q=cache:kC0aaNbiwDcJ:www.bpurcell.org/blog/ index.cfm%3Fmode%3Dentry%26entry%3D935+coldfusion+service+factory+schedu led+taskshl=engl=usct=clnkcd=1lr=lang_en -Original Message- From: Aaron Rouse Sent: Wednesday, August 09, 2006 3:42 PM To: CF-Talk Subject: Re: Scheduled tasks I could not get the linke to load and was curious what exactly it covered? Often had the needs here to be able to view what all tasks are and more so to be able to maybe create them. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249353 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Development Environment Setup
I'd love to do that, but we're not allowed to have servers installed on our desktop machines for security reasons. -Original Message- From: Oðuz_Demirkapý Sent: Wednesday, August 09, 2006 2:37 PM To: CF-Talk Subject: RE: Development Environment Setup Test Server --- SVN --- Production Server | | Developers Test Server: Testing current status of code and deciding production version of code. Production Server: Deploying tested code version from SVN reposity. Developers: Every developer have their local CF installation and they chekin/checkout code from main SVN reposities. This is what we have here. :) ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249354 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Numbers to Text
Nice tag apart from it's gramatical problems... Irony. Has anyone already suggested the UDF at http://www.cflib.org/udf.cfm?ID=40 ? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249039 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cfquery - single quotes become doubled
That's by design. ColdFusion is escaping your single quotes. You need to either wrap your string in the PreserveSingleQuotes() function or, better, use cfqueryparam -Original Message- From: David Carter Sent: Monday, August 07, 2006 3:14 PM To: CF-Talk Subject: cfquery - single quotes become doubled Hello all, I am having a strange problem with a cfquery through SQL Server where I am building the SQL statement dynamically from form input. I wonder if anyone here has encountered and over come a similar error in the past, and could lead me toward a solution. When the SQL statement is placed into a cfquery tag, the single quotes which denote the string literal in the WHERE clause become doubled-up and cause a syntax error. Dumping the Variables scope gives the value of sql_stmt as: SELECT user_id, user_name, name_first, name_last, ssn_encrypted FROM tbl_user WHERE c_encrypted = 'KSNRUy1VUDcvIzI4PAo=' (the ending = is a part of the string literal) Cutting and pasting this value directly into SQL Server's Query Analyzer generates the single row which I am expecting. In ColdFusion however, I get this: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Line 1: Incorrect syntax near 'KSNRUy1VUDcvIzI4PAo'. The error occurred in C:\Webs\user\find\search_results.cfm: line 37 35 : cfinclude template=#application.root#pop_up_variables.cfm 36 :cfquery name=q_users_found datasource=#application.db# 37 :#sql_stmt# 38 :/cfquery 39 :cfelse SQL SELECT user_id, user_name, name_first, name_last, c_encrypted FROM tbl_user WHERE c_encrypted = ''KSNRUy1VUDcvIzI4PAo='' (notice the single quotes are doubled) DATASOURCE base_db VENDORERRORCODE 170 SQLSTATE HY000 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249044 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: 30 days from now date variable
cfset myVar=dateAdd(d,30,now()) -Original Message- From: Tim Laureska Sent: Thursday, August 03, 2006 11:38 AM To: CF-Talk Subject: 30 days from now date variable How do you set a variable to be 30 days from today? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248726 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Security Setup/Array Find
I'd think a structure. cfif structKeyFind(stAssets,thisAssetName) cfset currentAccess=stAssets[thisAssetName] cfelse cfset currentAccess=none /cfif Abstract it into a function for better code re-use. -Original Message- From: David S. Neuman Sent: Thursday, August 03, 2006 4:00 PM To: CF-Talk Subject: RE: Security Setup/Array Find This question is an extension of the original question about the security setup. Is an array even the best way to go about this, or is there a better way? Our security setup gives users different permissions for different parts of the site. We broke down individual sections of the site into assets, and for each asset the user gets a specific function. User 1: Asset Function A edit B delete C view When the user comes to the page, we need to check to see if the asset is there, and if so, the function the user has for that area. What is the best way to handle this? Thanks ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248756 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Unofficial CF Developer Salary Survey
Bonuses? Who gets bonuses? I'd be happy getting an extra 40 hours PTO. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 01, 2006 5:19 PM To: CF-Talk Subject: Re: Unofficial CF Developer Salary Survey + bonuses you could find yourself up at 100K USD. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248615 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Eclipse and CSS
How about Aptana? Someone blogged about it yesterday. http://www.remotesynthesis.com/blog/index.cfm/2006/7/31/Aptana-EclipseBa sed-Web-IDE -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 02, 2006 11:12 AM To: CF-Talk Subject: OT: Eclipse and CSS Now that I have Eclipse running with RDS, CFEclipse and Subversion I need a plugin for CSS that will work with CFEclipse. Any recommendations? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248637 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ColdFusion Tag and Attribute Case
aolMe too./aol -Original Message- From: Ken Ferguson Sent: Wednesday, August 02, 2006 11:26 AM To: CF-Talk Subject: RE: ColdFusion Tag and Attribute Case As far as tags go, I am an all-lowercase type of guy. Functions and variable names are where I use mixed-case, but tags are all lower for me. --Ferg ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248639 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Advanced Developer Average Salary
http://www.frappr.com/cfdevelopers -Original Message- From: Dan Plesse Sent: Tuesday, August 01, 2006 12:13 PM To: CF-Talk Subject: Re: Advanced Developer Average Salary It seems like a lot of employers are still very interested in the location of CF developers. Is there a google map where you can plug in your location for this very purpose? Would this help with the employment matching process? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248468 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Oracle 8.i and querying for table/field list
It's guaranteed to bring back 0 records, giving you just the query columns. By the way, if that's your real username and password, you should probably change them, because now the entire world knows it. -Original Message- From: Terry C. Mergl [mailto:[EMAIL PROTECTED] Sent: Monday, July 31, 2006 11:08 AM To: CF-Talk Subject: RE: Oracle 8.i and querying for table/field list James, not sure what to say but that did it. It listed all of the tables and fiellds and fast also. I appreciate it very very much. Terry PS: Why WHERE 0=1 though? -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Monday, July 31, 2006 10:59 AM To: CF-Talk Subject: Re: Oracle 8.i and querying for table/field list Try this cfquery datasource=alopa username=metaserv password=metaserv name=findfields Select * From #i# WHERE 0=1 /cfquery Yes, I did type that correctly. The fieldnames should still be returned, even though the recordcount is 0. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248241 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Random Characters
I think you mean CAPTCHA. If so, there have been a number of conversations about it on this list in the last couple of weeks. A quick perusal of the archives should help. -Original Message- From: Steve LaBadie Sent: Friday, July 28, 2006 8:06 AM To: CF-Talk Subject: Random Characters I am sure that we have all seen the random character generators at the bottom of forms these days. Is there a proper term associated with this type of form and where can I go to learn how to make it? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247989 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Event Scheduler question
Change the end date to yesterday? Re-enable by changing the end date to NULL. -Original Message- From: kurt schroeder [mailto:[EMAIL PROTECTED] Sent: Thursday, July 27, 2006 3:28 PM To: CF-Talk Subject: Event Scheduler question I sometimes have to take a scheduled task off line. I've tried setting it to one time at a time eairlier that the current time, but this just starts the task imediately. Is there a way to just aturn a task off without deleting it? THanks KES ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247917 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
SOT: uploading large files
Searched houseoffusion.com and Google and wasn't able to find anything. I'm working on a small intranet application that has a module where users can upload files, generally PDFs. Some of these PDFs can be quite large. In fact, on anything larger than about 2.4MB, the web server throws a 500 error. We're using a multipart form. This is a government installation, so other options are limited. Third-party applets are right out. FTP is almost certainly NOT an option (as if we could educate the users how to use THAT). It seems sure that the problem is with IIS, since it's throwing the error, not ColdFusion. (Then why are you posting here? Bear with me.) In a support call with Microsoft, our server guys were walked through changing an ASP setting and were then able to upload a larger file via an HTTP POST on an ASP page. So, of course, the problem must now be ColdFusion. *sigh* Servers are Win2K3 and IIS 6.0. As far as I know, no SPs have been applied. CFMX 7.01. I am SURE that at least a few of you on this list have encountered this sort of thing before. I've used HTTP POST to upload files larger than 2.5MB elsewhere, so I don't know where this artificial limit is coming from. Everything works fine for smaller files. It does not appear to be a timeout issue, as the server comes back instantly with the 500 error. Any suggestions I should make to the server guys? Any options for code that I can try? Any CF settings that I might be overlooking? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247308 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SOT: uploading large files
My mistake. We're still on CFMX 7.0. -Original Message- From: Eric Haskins [mailto:[EMAIL PROTECTED] Sent: Friday, July 21, 2006 12:31 PM To: CF-Talk Subject: Re: SOT: uploading large files We are Running 7.0.2 but have you checked under Server Settings - Settings there is a field for Maximum Size of Post Data by default it is set to 500MB Just a thought ~Eric I've used HTTP POST to upload files larger than 2.5MB elsewhere, so I don't know where this artificial limit is coming from. Everything works fine for smaller files. It does not appear to be a timeout issue, as the server comes back instantly with the 500 error. Any suggestions I should make to the server guys? Any options for code that I can try? Any CF settings that I might be overlooking? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247318 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
[resolved] uploading large files
It figures. It appears that the root of the problem is Siteminder, which is used here for authentication. Which is hosted on a completely different server, in a completely different building, and managed by a completely different group. I suppose the first clue was when no errors appeared in the ColdFusion logs or IIS logs. The wheels of bureaucracy turn slowly, but it'll be managed. It's completely out of my hands anyway. Thanks all for your help. -Original Message- Searched houseoffusion.com and Google and wasn't able to find anything. I'm working on a small intranet application that has a module where users can upload files, generally PDFs. Some of these PDFs can be quite large. In fact, on anything larger than about 2.4MB, the web server throws a 500 error. We're using a multipart form. This is a government installation, so other options are limited. Third-party applets are right out. FTP is almost certainly NOT an option (as if we could educate the users how to use THAT). It seems sure that the problem is with IIS, since it's throwing the error, not ColdFusion. (Then why are you posting here? Bear with me.) In a support call with Microsoft, our server guys were walked through changing an ASP setting and were then able to upload a larger file via an HTTP POST on an ASP page. So, of course, the problem must now be ColdFusion. *sigh* Servers are Win2K3 and IIS 6.0. As far as I know, no SPs have been applied. CFMX 7.01. I am SURE that at least a few of you on this list have encountered this sort of thing before. I've used HTTP POST to upload files larger than 2.5MB elsewhere, so I don't know where this artificial limit is coming from. Everything works fine for smaller files. It does not appear to be a timeout issue, as the server comes back instantly with the 500 error. Any suggestions I should make to the server guys? Any options for code that I can try? Any CF settings that I might be overlooking? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247342 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Creating a watermark for CFDOCUMENT
Hmmm...I didn't include all of the HTML elements. I'll try that.
-Original Message-
From: Sandra Clark [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 13, 2006 5:51 PM
To: CF-Talk
Subject: RE: Creating a watermark for CFDOCUMENT
I got something working with the following code, the information shows
up in the PDF. Media style will mean nothing to PDF, it can only print
what it shows. Notice that the cfdocument must surround both the head
and body tags. It won't work if you just surround the body or the
information within the body. (In other words, you must use proper
markup (style belongs in the
head) and send all of that to the pdf.
!DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Strict//EN
http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd;
html xmlns=http://www.w3.org/1999/xhtml; xml:lang=en lang=en
cfdocument format=PDF pagetype=letter orientation=portrait
unit=in
encryption=none
fontembed=Yes backgroundvisible=Yes
head
title/title
style type=text/css
body{
background-image: url(hdr_right.jpg);
background-position: top right;
background-repeat: no-repeat;
height: 11in;
width: 8.5in;
padding: .5in;
}
/style
/head
body
h1 This is a test/h1
/body/cfdocument
/html
Sandra Clark
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246525
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Creating a watermark for CFDOCUMENT
No dice. I tried with the doctype and html element outside CFDOCUMENT
and inside. I even popped a cfcontent reset=yes before it to make
sure my framework code wasn't enforcing a layout on it. Still nothing.
Viewing the output as HTML my background image is there, but CFDOCUMENT
refuses to use it.
I'm giving up. The client will have to be satisfied with the word
DRAFT in text at the bottom of every page. I have too many other
defects I need to be working on.
Thanks all for your help.
-Original Message-
From: Sandra Clark [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 13, 2006 5:51 PM
To: CF-Talk
Subject: RE: Creating a watermark for CFDOCUMENT
I got something working with the following code, the information shows
up in the PDF. Media style will mean nothing to PDF, it can only print
what it shows. Notice that the cfdocument must surround both the head
and body tags. It won't work if you just surround the body or the
information within the body. (In other words, you must use proper
markup (style belongs in the
head) and send all of that to the pdf.
!DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Strict//EN
http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd;
html xmlns=http://www.w3.org/1999/xhtml; xml:lang=en lang=en
cfdocument format=PDF pagetype=letter orientation=portrait
unit=in
encryption=none
fontembed=Yes backgroundvisible=Yes
head
title/title
style type=text/css
body{
background-image: url(hdr_right.jpg);
background-position: top right;
background-repeat: no-repeat;
height: 11in;
width: 8.5in;
padding: .5in;
}
/style
/head
body
h1 This is a test/h1
/body/cfdocument
/html
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246533
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Creating a watermark for CFDOCUMENT
That shouldn't have anything to do with it, as it's a PDF document. -Original Message- From: Qasim Rasheed [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 12, 2006 10:06 PM To: CF-Talk Subject: Re: Creating a watermark for CFDOCUMENT I can be way off but have you tried setting up in printing prerference of your browser to print backgrond images. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246401 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Creating a watermark for CFDOCUMENT
Okay. Got any code to share? I mean, it seems straightforward enough to me, so I don't see why it's not working. -Original Message- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 12, 2006 11:07 PM To: CF-Talk Subject: Re: Creating a watermark for CFDOCUMENT I've done this with CSS and a background image. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246402 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Creating a watermark for CFDOCUMENT
No, no change.
Here's the code I have:
cfdocument backgroundvisible=yes format=pdf pagetype=letter
orientation=landscape
cfif arguments.report_status is draft
style type=text/css media=print
body {
background-image:url(#request.baseURL#images/draft-watermark.gif);
background-position:center;
}
/style
/cfif
I've tried with 'media=print' and without. I've tried the style tags
before and after cfdocument. I am sure that the image file exists
where I say it does. I've tried attaching the image to html and table as
well as body. All give the same result.
I tried changing my browser settings to display background images when
printing. Still nothing.
If I comment out all of the cfdocument and child tags, the HTML I get
has a background image.
I'm stumped.
-Original Message-
From: Qasim Rasheed [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 13, 2006 5:14 PM
To: CF-Talk
Subject: Re: Creating a watermark for CFDOCUMENT
I think technically those are related. CFDocument uses the styles that
you have defined for printing and take advantage of your printing
preferences.
FWIW.
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246472
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Creating a watermark for CFDOCUMENT
I have a report I am creating with CFDOCUMENT. (CFREPORT would have been better, but this report has a lot of extra logic in it that CFREPORT wasn't going to allow me to do, but that's beside the point.) What I want is to have a watermark on the document if the user creates it with the draft option, but not if the user selects final. The in the CFREPORT tag, backgroundvisible is set to yes. However, when creating the document, my image never shows up. I've tried putting a background image on the html table and tried making it the background of my page body. If I look at the report as HTML it's fine, but with the CFREPORT tag the background is not displaying. I am using PDF format. Any clues? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246255 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Complex object types - a little help?
It's also the name of a ColdFusion scope, which can cause a lot of other weirdness. I suggest using a different variable name. -Original Message- From: Nathan C. Smith [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 11, 2006 2:28 AM To: CF-Talk Subject: RE: Complex object types - a little help? Argh! That be pirate speak for messin' up. I was referring to 'client' which was my loop index and also a field in the query. Thanks All for the pointers though! -Nate ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246122 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: hour as string representation?
CreateTime() does what you want. cfloop from=0 to=23 index=hr cfoutput#TimeFormat(CreateTime(hr,0,0),hh:mm tt)#/cfoutputbr / /cfloop -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Thursday, July 06, 2006 9:35 AM To: CF-Talk Subject: hour as string representation? I'm wondering if there's a built in function to do what I want. I've got some form fields I need duplicated, one for each hour of the day (1-24). I want to display the label as 12:00 am, 1:00 am, etc. I'm wondering if there's a function that can take a number value and return a string representation of it's time of the day; ie: 13 would return 1:00 pm. I want to think that CF has something like this built in but I can't find it. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:245505 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
