problem on inserting null when option value is selected
Hi Everybody have this situation where I have a cfselect listed below with an added OPTION to display Please select province and a the list of provinces generated from a query which displays on the dropdown using the attribute QueryPosition=below. On the selected attribute the real value from the database should show from the query getdetails using #GetDetails.ProvID# which is ok. The problem now is when a value from the GetProvinces query is select all would be fine but when the added option with a blank value is select it stores the string Please select province on the database. How could I insert a null value when that is selected? CFSELECT NAME=TransProv Label=Transferred province QueryPosition=below query=GetProvinces value=ProvID display=provname selected=#GetDetails.ProvID# option value=Please select province/option /CFSELECT this is the action query to update the table cfquery name=UpdateSoc datasource=socs UPDATE Soc SET TransProv='#form.TransProv#' WHERE ID=100 /cfquery Thanks for any help alex ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332624 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: PDF alternate to cfdocument [spamtrap bayes][spamtrap heur][auto-ip]
On Tuesday 06 Apr 2010, Paul Hastings wrote: On 4/6/2010 10:52 AM, Craigsell wrote: I would use iText (http://itextpdf.com/). It's the same code that runs i think he specified easy ;-) There are a ton of good examples on the first page of the obvious google search. -- Helping to evangelistically reintermediate virtual market-growth as part of the IT team of the year 2010, '09 and '08 This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners. We use the word partner to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.co ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332625 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: problem on inserting null when option value is selected
I think this'll work: UPDATE Soc SET TransProv=cfif Len(form.TransProv)'#form.TransProv#'cfelseNULL/cfif WHERE ID=100 On Tue, Apr 6, 2010 at 2:43 AM, alex poyaoan ap.cli...@tiscali.it wrote: Hi Everybody have this situation where I have a cfselect listed below with an added OPTION to display Please select province and a the list of provinces generated from a query which displays on the dropdown using the attribute QueryPosition=below. On the selected attribute the real value from the database should show from the query getdetails using #GetDetails.ProvID# which is ok. The problem now is when a value from the GetProvinces query is select all would be fine but when the added option with a blank value is select it stores the string Please select province on the database. How could I insert a null value when that is selected? CFSELECT NAME=TransProv Label=Transferred province QueryPosition=below query=GetProvinces value=ProvID display=provname selected=#GetDetails.ProvID# option value=Please select province/option /CFSELECT this is the action query to update the table cfquery name=UpdateSoc datasource=socs UPDATE Soc SET TransProv='#form.TransProv#' WHERE ID=100 /cfquery Thanks for any help alex ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332626 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: problem on inserting null when option value is selected
Let queryParam do the work for you: UPDATE Soc SET TransProv = cfqueryparam cfsqltype=cf_sql_varchar value=#form.TransProv# null=#not len(form.TransProv)# / WHERE ID = cfqueryparam cfsqltype=cf_sql_integer value=100 / ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332627 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: problem on inserting null when option value is selected
Let queryParam do the work for you: UPDATE Soc SET TransProv = cfqueryparam cfsqltype=cf_sql_varchar value=#form.TransProv# null=#not len(form.TransProv)# / WHERE ID = cfqueryparam cfsqltype=cf_sql_integer value=100 / Hi I tried both your solutions but this time it inserts the quotes which is the value of the option and not a null value. Is there something wrong with my code? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332628 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: problem on inserting null when option value is selected
Let queryParam do the work for you: UPDATE Soc SET TransProv = cfqueryparam cfsqltype=cf_sql_varchar value=#form.TransProv# null=#not len(form.TransProv)# / WHERE ID = cfqueryparam cfsqltype=cf_sql_integer value=100 / ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332629 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: problem on inserting null when option value is selected
Let queryParam do the work for you: UPDATE Soc SET TransProv = cfqueryparam cfsqltype=cf_sql_varchar value=#form.TransProv# null=#not len(form.TransProv)# / WHERE ID = cfqueryparam cfsqltype=cf_sql_integer value=100 / ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332630 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Passing NT Username and Password to SQL Server datasource - still impossible or have things changed?
I've been trying to pass with CF8 on a Windows Server 2008 box to SQL Server 2005 on a separate server. The references I've been seeing for previous versions say it can only pass the username and password of the account the CF8 service runs under. Kerberos references say it could be possible with the proper setup. Is it still impossible? Has it been done, and how? Thank you. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332631 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
VAADIN Integration with coldfusion ?!
Has anyone used Vaadin UI Library in a Coldfusion 9 or 8 application ? Any samples or wrapper would be appreciated . check out the library on http://demo.vaadin.com/sampler/ ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332632 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: java.lang.String as a structure with members
You don't need the #'s either! change cfset t1 = #Trim(t1.Team)# to cfset tname1 = Trim(t1.Team) and cfset logo1 = #Trim(t1.Logo)# to cfset logo1 = Trim(t1.Logo) thanks, eric cobb http://www.cfgears.com Maureen wrote: You are using t1 as the name of a query: cfquery name=t1 datasource=hockey then you set it to a string cfset t1 = #Trim(t1.Team)# then you try to use it again as a query name. cfset logo1 = #Trim(t1.Logo)# Also, you don't need the quotes around the string on the right of the = sign change cfset t1 = #Trim(t1.Team)# to cfset tname1 = #Trim(t1.Team)# and cfset logo1 = #Trim(t1.Logo)# to cfset logo1 = #Trim(t1.Logo)# On Mon, Apr 5, 2010 at 12:33 PM, Rick Sanders c...@webenergy.ca wrote: This is the line throwing the error: cfset logo1 = #Trim(t1.Logo)# ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332633 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: problem on inserting null when option value is selected
Really should not be sending in . Can we see your full, revised query? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332634 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: problem on inserting null when option value is selected
Yes I tried it a couple of times but it still inserts the quotes. I tried a workaround which worked fine.. I inserted a value=1 to the blank option of the cfselect and did a cfif on the update query the code is listed below CFSELECT NAME=TransProv Label=Transferred province QueryPosition=below query=GetProvinces value=ProvID display=provname selected=#GetDetails.ProvID# option value=1Please select province/option /CFSELECT and here is the UPDATE QUERY. cfquery name=UpdateSoc datasource=socs UPDATE Soc SET TransProv=cfif (form.TransProv)neq 1'#form.TransProv#'cfelseNULL/cfif WHERE ID=100 /cfquery Thanks all for your help ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332635 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Passing NT Username and Password to SQL Server datasource - still impossible or have things changed?
Do you mean using Windows Authentication, where the client automatically passes the credentials it has logged into the domain controller with? As far as I know that still can't be done but I'm not sure why. Is there are particular reason you can't create a SQL account for CF to connect with? I actually like that because it makes it a bit easier to audit permissions with explicit accounts. ~Brad - Original Message - From: Thomas Harper harpe...@upmc.edu To: cf-talk cf-talk@houseoffusion.com Sent: Tuesday, April 06, 2010 7:26 AM Subject: Passing NT Username and Password to SQL Server datasource - still impossible or have things changed? I've been trying to pass with CF8 on a Windows Server 2008 box to SQL Server 2005 on a separate server. The references I've been seeing for previous versions say it can only pass the username and password of the account the CF8 service runs under. Kerberos references say it could be possible with the proper setup. Is it still impossible? Has it been done, and how? Thank you. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332636 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Java library signing problem
Hi, I'm trying to use several Java libraries that, I believe, are conflicting with some of the default libraries that come with CF9. Specifically, I'm trying to load the smack.jar library from Jive Software (for interacting with an Openfire server.) I've tried two different methods for loading these - the 'standard' way of adding my local /libs folder to CF's classpath in the administrator, and the JavaLoader way of loading them at runtime. In both cases, I can get to the point where things seem to load without error, but when I use the library, I get this error: class org.jivesoftware.smack.MessageListener's signer information does not match signer information of other classes in the same package (java.lang.SecurityException) I'm afraid I only know enough Java to get into trouble, so I'm not quite sure where to start on this one. The main Java objects I'm using on this project are being developed by my client, so I do have flexibility to rearrange libraries and mess with the overall codebase and builds, but I'm not sure what to tell those devs to try. :) Thanks for any assistance on this. - Ken ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332637 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
using cfhttp
Hello, Is there a way to use cfhttp to see if a site is down? Does it involve using #HTMLCodeFormat(cfhttp.FileContent)# to see if a 403 error is downloaded? Thanks. RO HWW ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332638 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: using cfhttp
On Tue, Apr 6, 2010 at 8:36 AM, Orlini, Robert rorl...@hwwilson.com wrote: Hello, Is there a way to use cfhttp to see if a site is down? Does it involve using #HTMLCodeFormat(cfhttp.FileContent)# to see if a 403 error is downloaded? check the cfhttp.filestatus to see if it contains the string 200 -- Charlie Griefer http://charlie.griefer.com/ I have failed as much as I have succeeded. But I love my life. I love my wife. And I wish you my kind of success. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332639 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: using cfhttp
Using cfhttp will return a cfhttp.statusCode, which if is 200 OK you know the URL has resolved correct. -- /Kevin Pepperman They who can give up essential liberty to obtain a little temporary safety, deserve neither liberty nor safety. - Benjamin Franklin ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332640 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: using cfhttp
d'oH! yeah, cfhttp.statusCode. not cfhttp.fileStatus. :) On Tue, Apr 6, 2010 at 8:41 AM, Kevin Pepperman chorno...@gmail.com wrote: Using cfhttp will return a cfhttp.statusCode, which if is 200 OK you know the URL has resolved correct. -- /Kevin Pepperman They who can give up essential liberty to obtain a little temporary safety, deserve neither liberty nor safety. - Benjamin Franklin ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332641 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Passing NT Username and Password to SQL Server datasource - still impossible or have things changed?
cfNTauthenticate will pass NT authentication but you will need to have the user authenticate twice; once when they login to the machine and again per coldfusion application. http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_m-o_07.html ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332642 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Passing NT Username and Password to SQL Server datasource - still impossible or have things changed?
why did I say twice? The user needs to be part of a registered domain and that's all. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332643 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: using cfhttp
Additionally you can make the request a little lighter by just making a HEAD request instead of a get or post. cfhttp url=http://www.andymatthews.net; method=head/cfhttp It doesn't return the entire body of the site in the filecontent key. andy -Original Message- From: Charlie Griefer [mailto:charlie.grie...@gmail.com] Sent: Tuesday, April 06, 2010 10:47 AM To: cf-talk Subject: Re: using cfhttp d'oH! yeah, cfhttp.statusCode. not cfhttp.fileStatus. :) On Tue, Apr 6, 2010 at 8:41 AM, Kevin Pepperman chorno...@gmail.com wrote: Using cfhttp will return a cfhttp.statusCode, which if is 200 OK you know the URL has resolved correct. -- /Kevin Pepperman They who can give up essential liberty to obtain a little temporary safety, deserve neither liberty nor safety. - Benjamin Franklin ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332644 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: using cfhttp
On Tue, Apr 6, 2010 at 9:24 AM, Andy Matthews li...@commadelimited.comwrote: Additionally you can make the request a little lighter by just making a HEAD request instead of a get or post. cfhttp url=http://www.andymatthews.net; method=head/cfhttp It doesn't return the entire body of the site in the filecontent key. Nice! I did not know that. -- Charlie Griefer http://charlie.griefer.com/ I have failed as much as I have succeeded. But I love my life. I love my wife. And I wish you my kind of success. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332645 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: PDF alternate to cfdocument [spamtrap bayes][spamtrap heur][auto-ip]
On 4/6/2010 4:48 PM, Tom Chiverton wrote: There are a ton of good examples on the first page of the obvious google search. yup but none are as easy as cfdocument ;-) ..if you need to use iText, by all means by bruno's book: http://www.manning.com/lowagie2/ ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332646 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
SOT: external css not displaying
We just renewed the IIS certs on our servers yesterday and today an app that uses external CSS is not formatting. It's almost as if the CSS file isn't found though it's in the same directory as the files. Everything works locally and our staging server. The CSS file is being called: link rel=stylesheet href=print.css type=text/css media=print / any ideas why this would be working yesterday and after the new certs are installed it stops? Thanks! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332647 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
coldfusion.ajax.submitform
Is it not possible to have multiple cfforms on a page and submit them using coldfusion.ajax.submitform I tried this which I would think would work but it just gives this JavaScript error myform is not defined cfajaximport script function submitForm(FormName) { var FormName = FormName; alert(FormName); ColdFusion.Ajax.submitForm(FormName, '~form-action.cfm', callback, errorHandler); } function callback(text) { alert(Callback: + text); } function errorHandler(code, msg) { alert(Error!!! + code + : + msg); } /script cfform method=get name=myform id=myform cfinput name=tinput1br / cfinput name=tinput2 a href=javascript:submitForm(myform)img src=mybutton.gif alt=Submit width=100 height=25 border=0 //a /cfform Any ideas as to how I can have more than one form on a page and accomplish this? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332648 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: external css not displaying
Have you tried using Firebug to see if the file is indeed failing to load? andy -Original Message- From: Greg Morphis [mailto:gmorp...@gmail.com] Sent: Tuesday, April 06, 2010 11:42 AM To: cf-talk Subject: SOT: external css not displaying We just renewed the IIS certs on our servers yesterday and today an app that uses external CSS is not formatting. It's almost as if the CSS file isn't found though it's in the same directory as the files. Everything works locally and our staging server. The CSS file is being called: link rel=stylesheet href=print.css type=text/css media=print / any ideas why this would be working yesterday and after the new certs are installed it stops? Thanks! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332649 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: using cfhttp
Yep. I use that to ping a site with an AJAX call too. -Original Message- From: Charlie Griefer [mailto:charlie.grie...@gmail.com] Sent: Tuesday, April 06, 2010 11:35 AM To: cf-talk Subject: Re: using cfhttp On Tue, Apr 6, 2010 at 9:24 AM, Andy Matthews li...@commadelimited.comwrote: Additionally you can make the request a little lighter by just making a HEAD request instead of a get or post. cfhttp url=http://www.andymatthews.net; method=head/cfhttp It doesn't return the entire body of the site in the filecontent key. Nice! I did not know that. -- Charlie Griefer http://charlie.griefer.com/ I have failed as much as I have succeeded. But I love my life. I love my wife. And I wish you my kind of success. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332650 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SOT: external css not displaying
That CSS file is used when printing. When you say the CSS isn't showing up are you referring to the printouts you get or what you see on the computer screen? Updating SSL certs is unlikely to be related to whatever CSS problems you are encountering. -Mike Chabot On Tue, Apr 6, 2010 at 12:41 PM, Greg Morphis gmorp...@gmail.com wrote: We just renewed the IIS certs on our servers yesterday and today an app that uses external CSS is not formatting. It's almost as if the CSS file isn't found though it's in the same directory as the files. Everything works locally and our staging server. The CSS file is being called: link rel=stylesheet href=print.css type=text/css media=print / any ideas why this would be working yesterday and after the new certs are installed it stops? Thanks! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332651 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Passing NT Username and Password to SQL Server datasource - still impossible or have things changed?
Do you mean using Windows Authentication, where the client automatically passes the credentials it has logged into the domain controller with? As far as I know that still can't be done but I'm not sure why. Is there are particular reason you can't create a SQL account for CF to connect with? I actually like that because it makes it a bit easier to audit permissions with explicit accounts. Yes. We can use a SQL login, but for our auditing purposes we want something that is automatic and assured that the username will be entered in by the system and not just our code. If we have to, we can use CGI.AUTH_USER and tack it onto each query into a separate column if it can't happen automatically, or some other kind of system that'll meet their requirements. cfNTauthenticate will pass NT authentication but you will need to have the user authenticate twice; once when they login to the machine and again per coldfusion application. Right. Unfortunately, our domain is its own server that we're not going to have access to, so that option is closed to us. Thanks for your help! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332652 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Java library signing problem
You'll probably need to delete/replace the smack.jar that comes with CF9: WEB-INF/cfusion/lib/smack.jar :Den -- I believe that freedom is the deepest need of every human soul. George W. Bush On Tue, Apr 6, 2010 at 8:47 AM, Ken Dunnington wrote: Hi, I'm trying to use several Java libraries that, I believe, are conflicting with some of the default libraries that come with CF9. Specifically, I'm trying to load the smack.jar library from Jive Software (for interacting with an Openfire server.) I've tried two different methods for loading these - the 'standard' way of adding my local /libs folder to CF's classpath in the administrator, and the JavaLoader way of loading them at runtime. In both cases, I can get to the point where things seem to load without error, but when I use the library, I get this error: class org.jivesoftware.smack.MessageListener's signer information does not match signer information of other classes in the same package (java.lang.SecurityException) I'm afraid I only know enough Java to get into trouble, so I'm not quite sure where to start on this one. The main Java objects I'm using on this project are being developed by my client, so I do have flexibility to rearrange libraries and mess with the overall codebase and builds, but I'm not sure what to tell those devs to try. :) Thanks for any assistance on this. - Ken ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332653 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SOT: external css not displaying
Locally and in our staging environments the PDF created is formatted correctly when viewing. However in production its not formatted at all. On Apr 6, 2010 3:19 PM, Mike Chabot mcha...@gmail.com wrote: That CSS file is used when printing. When you say the CSS isn't showing up are you referring to the printouts you get or what you see on the computer screen? Updating SSL certs is unlikely to be related to whatever CSS problems you are encountering. -Mike Chabot On Tue, Apr 6, 2010 at 12:41 PM, Greg Morphis gmorp...@gmail.com wrote: We just renewed the I... ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332654 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
new fullasagoog
Looks like fullasagoog was redesigned..like the new look, but it was nice before when you could see who's blog it was before you clicked the article ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332655 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: PDF alternate to cfdocument [spamtrap bayes][spamtrap heur][auto-ip]
On Mon, Apr 5, 2010 at 10:41 PM, Paul Hastings wrote: On 4/6/2010 10:52 AM, Craigsell wrote: I would use iText (http://itextpdf.com/). It's the same code that runs i think he specified easy ;-) If you're doing canned PDFs (think report builder style) there's a custom tag for Railo which runs jasperreport JRXML files. I think it will work on CF9 too, but I haven't tested it lately. The UI for iReport is freaking awesome, and works on a ton of platforms and whatnot. Excellent stuff. (And easy.) :Den -- Pray that your loneliness may spur you into finding something to live for, great enough to die for. Dag Hammarskjol ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332656 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SOT: external css not displaying
If it helps any this is a PDF we're displaying for the user. The link tag is within the cfdocumentsection tag.. cfdocument ... cfdocumentsection ... link rel=stylesheet ... Thanks, any ideas are appreciated On Tue, Apr 6, 2010 at 11:41 AM, Greg Morphis gmorp...@gmail.com wrote: We just renewed the IIS certs on our servers yesterday and today an app that uses external CSS is not formatting. It's almost as if the CSS file isn't found though it's in the same directory as the files. Everything works locally and our staging server. The CSS file is being called: link rel=stylesheet href=print.css type=text/css media=print / any ideas why this would be working yesterday and after the new certs are installed it stops? Thanks! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332657 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
resetting form variables
Hello All, I am trying to do the following: I have a web page which has all form variables populated based on previous page selection. One such variable is current year. There is a link called 'previous year data' which upon clicking opens a new page for the previous year and shows previous year stuff. This is done for comparing data between two years When the user clicks on the 'previous year' link, am just replacing the form variable which stores the current year value with the previous year value. Suppose I have the following variable: input type=hidden name=hold_year initially it would have the current year, but I am populating with previous year, so the query that gets the data depending on the year, uses the hold_year variable. But when I click on previous year link, the new window opens with previous year data, but the old window upon navigation reflects data from previous year. is there a way that both windows shows their respective data? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332658 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SOT: external css not displaying
Any chance you could share the URL so we can look at it? =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332659 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF - jQuery - Javascript
Hi folks - I have a question that could probably fall into multiple categories on HOF, but I thought I would start with my default list! ;-) Anyway, here's my story: I have a web page split in half. Left half has different records being displayed. Right half has a form, which populates a set of tables, and then that information appears on the left half. This process is working. The current challenge is this: The Left side has different records appearing on it as mentioned, it's not an iFrame BTW - the records have an ID number. The user would click on the ID number, and then form on the Right gets populated with that record's details. What I am hoping to do is pass the ID number using jQuery to a CF form, that gets the data from a query, passes the data back, and then that data is told to go into the proper fields to be displayed. Here are my questions/statements: I can send information to the CFM page with the ID on it. 1) When I perform the CFSTOREDPROC and assign it to a resulting variable. What do I have to do to, or what commands are needed so that it can be taken back to the original calling page. 2) Once the data comes back, what format is the data in? If anybody wants to provide any other details that I could be overlooking, I would appreciate it. Thanks, Doug ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332660 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF - jQuery - Javascript
Hi folks - I have a question that could probably fall into multiple categories on HOF, but I thought I would start with my default list! ;-) Anyway, here's my story: I have a web page split in half. Left half has different records being displayed. Right half has a form, which populates a set of tables, and then that information appears on the left half. This process is working. The current challenge is this: The Left side has different records appearing on it as mentioned, it's not an iFrame BTW - the records have an ID number. The user would click on the ID number, and then form on the Right gets populated with that record's details. What I am hoping to do is pass the ID number using jQuery to a CF form, that gets the data from a query, passes the data back, and then that data is told to go into the proper fields to be displayed. Here are my questions/statements: I can send information to the CFM page with the ID on it. 1) When I perform the CFSTOREDPROC and assign it to a resulting variable. What do I have to do to, or what commands are needed so that it can be taken back to the original calling page. 2) Once the data comes back, what format is the data in? If anybody wants to provide any other details that I could be overlooking, I would appreciate it. Thanks, Doug ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332661 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF - jQuery - Javascript
You could use cfajaxproxy to get your recordset in json and then use jquery to populate the form fields with the values of each member of the json query object. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332662 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: JFreeChart with CF [spamtrap bayes][spamtrap heur]
Hey Paul, One more thing... I want to restrict the bar width to particular size. I searched the net and got this funtion. renderer.setMaxBarWidth(0.10); but its not working. Its giving the following error as usual :( No matching Method/Function for org.jfree.chart.renderer.category.BarRenderer3D.SETMAXBARWIDTH(numeric) found any clues? Regards, Arsalan -- From: Paul Hastings p...@sustainablegis.com Sent: Tuesday, April 06, 2010 9:45 AM To: cf-talk cf-talk@houseoffusion.com Subject: Re: JFreeChart with CF [spamtrap bayes][spamtrap heur] On 4/6/2010 8:45 AM, Arsalan Tariq Keen wrote: Paul, your code works... its showing labels! However, its showing 'php sucks1!' and 'php sucks 2!' in the label. Whereas, I want to display the actual value of each bar, which in your example would be 1,5,3,2,3,2. What shall I change in this code? change: itemLabelGenerator=createObject(java,org.jfree.chart.labels.StandardCategoryItemLabelGenerator).init( php sucks {0}!,nf); to: itemLabelGenerator=createObject(java,org.jfree.chart.labels.StandardCategoryItemLabelGenerator).init( {0},nf); look at the java docs for NumberFormat DateFormat if you need to format the values. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332663 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SOT: external css not displaying
No because it's on an intranet, company info.. but here's the relevant code: cfdocument format=pdf overwrite=yes cfdocumentsection link rel=stylesheet href=print.css type=text/css media=print / On Tue, Apr 6, 2010 at 12:03 PM, Alan Rother alan.rot...@gmail.com wrote: Any chance you could share the URL so we can look at it? =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332664 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Font Problem with ImageDrawText()
I have ran into an issue using the following fonts with ImageDrawText(). 1. courier 2. helvetica 3. times 4. times-roman These fonts are recognized in my ColdFusion Administrator. The one thing I noticed is that all 4 of these fonts are listed as type: Adobe Built-in. The error that I'm getting is: Unable to find font: Serif. This is happening on both ColdFusion 8 and ColdFusion 9. I have tried to directly register the font in CF Admin. I have tried to put the font in the cf_root/runtime/jre/lib/fonts directory and register it from there. I have tried to install the font on the server like normal and restart ColdFusion. Every on of those attempts will let me see that ColdFusion recognizes the font in the CF Admin, but when trying to run the below sample code I still got the error. I have run out of ideas. I would appreciate any help. Thanks, Chuck !--- BEGIN CODE --- !--- This example shows how to draw three text strings with different text attributes. --- !--- Use the ImageNew function to create a 400x400-pixel image. --- cfset myImage=ImageNew(,400,400) !--- Set the text attributes. --- cfset attr = StructNew() cfset attr.underline = yes cfset attr.size = 25 cfset attr.style = bold cfset ImageSetDrawingColor(myImage,yellow) !--- Draw the text string ColdFusion Rocks! starting at (100,150). --- cfset ImageDrawText(myImage,ColdFusion Rocks!,100,150,attr) !--- Set new text attributes. --- cfset attr=StructNew() cfset attr.size = 18 cfset attr.strikethrough = yes cfset attr.style = bolditalic cfset ImageSetDrawingColor(myImage,red) !--- Draw the text string Powered by ColdFusion starting at (100,200). --- cfset ImageDrawText(myImage,Powered by ColdFusion,110,200,attr) !--- Set new text attributes. --- cfset attr = StructNew() cfset attr.font=courier cfset attr.style=italic cfset attr.size=15 cfset ImageSetDrawingColor(myImage,white) !--- Draw the text string Coming in 2007 starting at (150,250). --- cfset ImageDrawText(myImage,We've arrived,150,250,attr) !--- Display the text image in a browser. --- cfimage source=#myImage# action=writeToBrowser !--- END CODE --- ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332665 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: problem on inserting null when option value is selected
Let queryParam do the work for you: UPDATE Soc SET TransProv = cfqueryparam cfsqltype=cf_sql_varchar value=#form.TransProv# null=#not len(form.TransProv)# / WHERE ID = cfqueryparam cfsqltype=cf_sql_integer value=100 / You may need to trim the value first: null=#not len(trim(form.TransProv))# Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332666 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: using cfhttp
Additionally you can make the request a little lighter by just making a HEAD request instead of a get or post. cfhttp url=http://www.andymatthews.net; method=head/cfhttp It doesn't return the entire body of the site in the filecontent key. Well, this really depends on how the site was written, I think. If you're writing something with CF, and someone makes an HTTP HEAD request, it's up to you to abort processing to prevent the execution of the page after generation of HTTP response headers. It's possible that the web server truncates the request anyway, and that behavior may be dependent on the specific web server for all I know, but you're typically more concerned (as the publisher) with reducing the amount of time needed to respond to the request. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332667 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SOT: external css not displaying
On Tue, Apr 6, 2010 at 14:07, Greg Morphis gmorp...@gmail.com wrote: If it helps any this is a PDF we're displaying for the user. The link tag is within the cfdocumentsection tag.. cfdocument ... cfdocumentsection ... link rel=stylesheet ... I recommend that you use CFINCLUDE to include the contents of the stylesheet within an HTML STYLE tag. Linking to stylesheets is always problematic when using CFDOCUMENT. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332668 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: JFreeChart with CF [spamtrap bayes][spamtrap heur]
the method is actually setMaximumBarWidth(percent double) :) Works fine!! -- From: Arsalan Tariq Keen arsalk...@hotmail.com Sent: Wednesday, April 07, 2010 3:07 AM To: cf-talk cf-talk@houseoffusion.com Subject: Re: JFreeChart with CF [spamtrap bayes][spamtrap heur] Hey Paul, One more thing... I want to restrict the bar width to particular size. I searched the net and got this funtion. renderer.setMaxBarWidth(0.10); but its not working. Its giving the following error as usual :( No matching Method/Function for org.jfree.chart.renderer.category.BarRenderer3D.SETMAXBARWIDTH(numeric) found any clues? Regards, Arsalan -- From: Paul Hastings p...@sustainablegis.com Sent: Tuesday, April 06, 2010 9:45 AM To: cf-talk cf-talk@houseoffusion.com Subject: Re: JFreeChart with CF [spamtrap bayes][spamtrap heur] On 4/6/2010 8:45 AM, Arsalan Tariq Keen wrote: Paul, your code works... its showing labels! However, its showing 'php sucks1!' and 'php sucks 2!' in the label. Whereas, I want to display the actual value of each bar, which in your example would be 1,5,3,2,3,2. What shall I change in this code? change: itemLabelGenerator=createObject(java,org.jfree.chart.labels.StandardCategoryItemLabelGenerator).init( php sucks {0}!,nf); to: itemLabelGenerator=createObject(java,org.jfree.chart.labels.StandardCategoryItemLabelGenerator).init( {0},nf); look at the java docs for NumberFormat DateFormat if you need to format the values. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332669 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Passing NT Username and Password to SQL Server datasource - still impossible or have things changed?
cfNTauthenticate will pass NT authentication but you will need to have the user authenticate twice; once when they login to the machine and again per coldfusion application. http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_m-o_07.html To the best of my knowledge, this will not allow CF to pass that user's credentials to the database server, though. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332670 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SOT: external css not displaying
On 4/6/2010 7:23 PM, Dave Watts wrote: On Tue, Apr 6, 2010 at 14:07, Greg Morphisgmorp...@gmail.com wrote: If it helps any this is a PDF we're displaying for the user. Thelink tag is within thecfdocumentsection tag.. cfdocument ... cfdocumentsection ... link rel=stylesheet ... I recommend that you use CFINCLUDE to include the contents of the stylesheet within an HTML STYLE tag. Linking to stylesheets is always problematic when using CFDOCUMENT. I agree with this. I have never gotten linked style sheets to work properly with cfdocument. I even had to duplicate them inside of the headers and footers at times to get proper styles. I was using CF7 at the time. I hope Adobe fixes this in the future versions. I have not experimented with cfdocument in CF8 or CF9 so I can't say for certain if these issues persist. -- LinkedIn: http://www.linkedin.com/pub/8/a4/60 Twitter: http://twitter.com/RogerTheGeek MissHunt: http://www.misshunt.com/ (Home of the Clean/Dirty Magnet) NCDevCon: http://ncdevcon.com/ 2010 Raleigh ColdFusion Conference ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332671 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion 9 WACK
Oh definitely. I didn't want to imply anything otherwise :) I have great respect for the way Ben writes. After all, halfway through the CF5 WACK, I was making good money as a developer with little to no experience. Far and few between are books that you can point someone to and with little else, have them ready for entry into the world of development. In other words.. I'm awaiting the tasty morsels that are soon to come regarding CF9's new tools :) BTW, to your reply to Maureen - b3 == Book 3? Remember that the book is for beginners, so a 'rehash of the basics' is a bit unfair. If you _know_ CF, then you probably want to wait till the 3rd volume where more advanced topics are. If you _dont_ know CF, then I think the 1st volume is excellent. Of course, I'm fairly biased. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332672 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: ColdFusion 9 WACK
To add to what's been said, existing CF users will likely NOT want Volume 1, as the only significant change in it is coverage of ColdFusion Builder. Real coverage of all that's new in CF9 is in Volumes 2 and 3. This is intentional. I broke out Volume 1 last time into its own volume so that existing users would not have to buy a book that they'd not need most of. Volume 1 is definitely a beginners books, which is why we named it Getting Started. --- Ben -Original Message- From: Eric . [mailto:mister...@mistergin.net] Sent: Tuesday, April 06, 2010 10:32 PM To: cf-talk Subject: Re: ColdFusion 9 WACK Oh definitely. I didn't want to imply anything otherwise :) I have great respect for the way Ben writes. After all, halfway through the CF5 WACK, I was making good money as a developer with little to no experience. Far and few between are books that you can point someone to and with little else, have them ready for entry into the world of development. In other words.. I'm awaiting the tasty morsels that are soon to come regarding CF9's new tools :) BTW, to your reply to Maureen - b3 == Book 3? Remember that the book is for beginners, so a 'rehash of the basics' is a bit unfair. If you _know_ CF, then you probably want to wait till the 3rd volume where more advanced topics are. If you _dont_ know CF, then I think the 1st volume is excellent. Of course, I'm fairly biased. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332673 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Font Problem with ImageDrawText()
I have ran into an issue using the following fonts with ImageDrawText(). 1. courier 2. helvetica 3. times 4. times-roman These fonts are recognized in my ColdFusion Administrator. The one thing I noticed is that all 4 of these fonts are listed as type: Adobe Built-in. The error that I'm getting is: Unable to find font: Serif. I don't think you can use anything other than the TrueType fonts with CFIMAGE and related functions. I also think that if you read the entire error message, you'll only see the TrueType fonts listed, not the OpenType or Adobe built-in fonts (which can be used with PDFs). Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332674 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: ColdFusion 9 WACK
Ben, The only problem with the new layout is vol. one is the only current (other than John Farrar's...very rarely) cf book at bookstores. I'd bet vol. 3 would sell well. When it was just two volumes, even the beginning level (the one most readily available) had significant information on the newest version. So you would benefit as a beginner and someone looking for info on the latest version. But I understand you had to make decisions with the books getting too large and all. Mark -Original Message- From: Ben Forta [mailto:b...@forta.com] Sent: Tuesday, April 06, 2010 10:58 PM To: cf-talk Subject: RE: ColdFusion 9 WACK To add to what's been said, existing CF users will likely NOT want Volume 1, as the only significant change in it is coverage of ColdFusion Builder. Real coverage of all that's new in CF9 is in Volumes 2 and 3. This is intentional. I broke out Volume 1 last time into its own volume so that existing users would not have to buy a book that they'd not need most of. Volume 1 is definitely a beginners books, which is why we named it Getting Started. --- Ben -Original Message- From: Eric . [mailto:mister...@mistergin.net] Sent: Tuesday, April 06, 2010 10:32 PM To: cf-talk Subject: Re: ColdFusion 9 WACK Oh definitely. I didn't want to imply anything otherwise :) I have great respect for the way Ben writes. After all, halfway through the CF5 WACK, I was making good money as a developer with little to no experience. Far and few between are books that you can point someone to and with little else, have them ready for entry into the world of development. In other words.. I'm awaiting the tasty morsels that are soon to come regarding CF9's new tools :) BTW, to your reply to Maureen - b3 == Book 3? Remember that the book is for beginners, so a 'rehash of the basics' is a bit unfair. If you _know_ CF, then you probably want to wait till the 3rd volume where more advanced topics are. If you _dont_ know CF, then I think the 1st volume is excellent. Of course, I'm fairly biased. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332675 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Font Problem with ImageDrawText()
@Dave That is what I was thinking from the error I was getting. What I was wondering was if there was a way around that? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332676 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Font Problem with ImageDrawText()
That is what I was thinking from the error I was getting. What I was wondering was if there was a way around that? If you want to use Courier, install and use Courier New which is basically an identical TrueType font. Problem solved! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332677 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion 9 WACK
On Tue, Apr 6, 2010 at 9:32 PM, Eric . mister...@mistergin.net wrote: BTW, to your reply to Maureen - b3 == Book 3? Yep! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332678 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Font Problem with ImageDrawText()
I fully agree. But try explaining that to a Graphic Designer that wants to use Helvetica and not Arial, which are also identical, well to me anyhow. Thanks for your help. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332679 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Font Problem with ImageDrawText()
I fully agree. But try explaining that to a Graphic Designer that wants to use Helvetica and not Arial, which are also identical, well to me anyhow. You can get a TrueType version of Helvetica, I think. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332680 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Font Problem with ImageDrawText()
Yep. http://www.linotype.com/526/helvetica-family.html You should be able to get Truetype versions of most popular fonts... But fonts are more pricey than stock art - or *gasp* - ColdFusion Builder! - Nick -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Tuesday, April 06, 2010 10:36 PM To: cf-talk Subject: Re: Font Problem with ImageDrawText() I fully agree. But try explaining that to a Graphic Designer that wants to use Helvetica and not Arial, which are also identical, well to me anyhow. You can get a TrueType version of Helvetica, I think. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332681 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Font Problem with ImageDrawText()
On 7 April 2010 11:48, Eric Nicholas Sweeney n...@bigfatdesigns.com wrote: Yep. http://www.linotype.com/526/helvetica-family.html You should be able to get Truetype versions of most popular fonts... But fonts are more pricey than stock art - or *gasp* - ColdFusion Builder! Disgusting, considering they are reusing the work done by previous people in coming up with the alphabet. I mean, they should charge less or come up with an alphabet by themselves. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332682 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF server upgrade and training offer
Hi everyone! Please excuse this crass commercial message. Fig Leaf Software is offering the following discount: Upgrade your ColdFusion server and your development skills for one low price! Through May 31, 2010 upgrade your ColdFusion Server license or purchase a new license through Fig Leaf Software and receive a coupon to take our three-day introductory Fast Track to ColdFusion 9 instructor-led training course in Washington DC for only $295 (an $800 savings!) Can't make it to DC? No problem: You can also apply the discount to take the same course online and in real-time from our award-winning certified developer-instructors for only $445. Contact Manny Doraghi @ 1-877-FIG-LEAF x114 or by email: ad...@figleaf.com for more details. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332683 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Regex to remove script and style blocks
I am at a loss as to how to structure a regex to remove a JavaScript block from a file using CF5. What I am trying to do is remove the script and everything including and between /script. something like this: script language=JavaScript !-- JavaScript code here // -- /script I have tried this but it give me and error: Bad regular expression cfset Newstring = ReReplaceNoCase(string,script.*?.*?/script,, all) Assistance would be appreciated. Dennis Powers UXB Internet - A Website Design Hosting Company P.O. Box 6028 Wolcott, CT 06716 203-879-2844 http://www.uxbinternet.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332684 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF - jQuery - Javascript
Hi, Doug... I don't know about the CFStoredProc part, but I would do it something like this: - run a query to return a list of the record numbers you want to click and display the record numbers (or person's name with ID attached) - display the record numbers with an id for each so jQuery can use the id to determine which record number is clicked - once a record number is clicked, use a jQuery ajax call to a component method which runs a query and retrieves the record information - at this point, you have a couple of options to get the information from the record to the calling page for display: 1. You can use cfSaveContent in the component method and write the CFML and HTML needed to create the page content, save the content to a variable, return the variable value in a struct to the calling and then use jQuery to append the variable values onto the calling page 2. Or you can just take the query values and assign them to a struct and return the struct value to the jQuery function and use Javascript code (such as out.push syntax) to insert the new CFML/HTML into the calling page I prefer, usually, to put the CFML and HTML into the variable as in possibility 1 above using cfSaveContent. That allows me to use CF's syntax to create the page content, which is an easier method for me, but I can use CF to jQuery to modify the page content. You don't need to use a CFForm or any form to make this work. Once you have the record numbers on your page with a link on each with an ID that jQuery can work with, you can use jQuery's AJAX functions to send and receive data back from a cfcomponent method and use jQuery to add the new record information to the right side of your page. You can specify the data format for the returned data from the component method I the URL for the component and method. For example: ../components/records.cfm?method=mGetRecordreturnFormat=json I know this seems broad, but that's just an overview. If you need help coding a solution, I'll be glad to help you work something out. I use CF and jQuery practically every day, especially using jQuery's AJAX functionality. Here's a sample of how this might look on the page: Ben Forta Name:Ben Forta Ray CamdenHobbies: Checkers, Backgammon Doug Ford Profession: CF Programmer, Adobe CF Evangelist When you click on a name on the left, the info on the right fades out, is retrieved and the new information is displayed via AJAX on the right. (links on all the names above, such as: a id=recordNumber-1 href=Ben Forta/a a id=recordNumber-2 href=Ray Camden/a a id=recordNumber-3 href=Doug Ford/a You could use jQuery to change the record name, such as Doug Ford to the color red when it is the record displayed. Quite a few options. Let me know what questions you have... It's late (1:17am!) and I'm tired from softball this evening, so I hope this makes sense. hth, Rick -Original Message- From: Doug Ford [mailto:doug.e.f...@gmail.com] Sent: Tuesday, April 06, 2010 5:31 PM To: cf-talk Subject: CF - jQuery - Javascript Hi folks - I have a question that could probably fall into multiple categories on HOF, but I thought I would start with my default list! ;-) Anyway, here's my story: I have a web page split in half. Left half has different records being displayed. Right half has a form, which populates a set of tables, and then that information appears on the left half. This process is working. The current challenge is this: The Left side has different records appearing on it as mentioned, it's not an iFrame BTW - the records have an ID number. The user would click on the ID number, and then form on the Right gets populated with that record's details. What I am hoping to do is pass the ID number using jQuery to a CF form, that gets the data from a query, passes the data back, and then that data is told to go into the proper fields to be displayed. Here are my questions/statements: I can send information to the CFM page with the ID on it. 1) When I perform the CFSTOREDPROC and assign it to a resulting variable. What do I have to do to, or what commands are needed so that it can be taken back to the original calling page. 2) Once the data comes back, what format is the data in? If anybody wants to provide any other details that I could be overlooking, I would appreciate it. Thanks, Doug ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332685 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF - jQuery - Javascript
Use jQuery's getJSON() to call a CFC containing and returning your stored proc call. Make the returnType JSON and you'll get a JavaScript object. You can then assign various bits of the javasript object to your form, in the getJSON() callback. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ On 7 April 2010 05:10, Doug Ford doug.e.f...@gmail.com wrote: Hi folks - I have a question that could probably fall into multiple categories on HOF, but I thought I would start with my default list! ;-) Anyway, here's my story: I have a web page split in half. Left half has different records being displayed. Right half has a form, which populates a set of tables, and then that information appears on the left half. This process is working. The current challenge is this: The Left side has different records appearing on it as mentioned, it's not an iFrame BTW - the records have an ID number. The user would click on the ID number, and then form on the Right gets populated with that record's details. What I am hoping to do is pass the ID number using jQuery to a CF form, that gets the data from a query, passes the data back, and then that data is told to go into the proper fields to be displayed. Here are my questions/statements: I can send information to the CFM page with the ID on it. 1) When I perform the CFSTOREDPROC and assign it to a resulting variable. What do I have to do to, or what commands are needed so that it can be taken back to the original calling page. 2) Once the data comes back, what format is the data in? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332686 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm