RE: How to Make Layers Visible with OnMouseOver
-Original Message- From: Peter Boughton [mailto:bought...@gmail.com] And just a quick simplification of Adrian's jQuery... Instead of: $(#show).mouseover(func1).mouseout(func2) You can do: $(#show).hover(func1,func2) Holy bejeasus, how long has hover() been there?! God bless jQuery... ~| 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:325628 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How to Make Layers Visible with OnMouseOver
Way too much code to look at!
But using jQuery:
style type=text/css
.hidden {
display: none;
}
/style
script type=text/javascript src=/path/to/jquery-1.3.2.min.js/script
script type=text/javascript
$(function() {
$(#show).mouseover(function() {
$(#hiddenDiv).show();
}).mouseout(function() {
$(#hiddenDiv).hide();
});
});
/script
span id=showShow that div/span
div id=hiddenDiv class=hiddenA hidden div/div
Rolling off will hide it again. Not sure if you want that or not.
Adrian
-Original Message-
From: Scott Williams [mailto:myscottwilli...@yahoo.com]
Sent: 21 August 2009 19:36
To: cf-talk
Subject: How to Make Layers Visible with OnMouseOver
Hi all --
I can't figure out how to make Layer2 in this document visible when I
mouseover the a tag around the newbridgecollege.edu link. Can anyone
help me with this?
Scott
*
!DOCTYPE HTML PUBLIC -//IETF//DTD HTML//EN
html
*snip*
/html
***
Thanks in advance!
Scott
~|
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:325599
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: simple SQL Question
That is a left outer join. It's mixing new and old styles of joining tables. Not sure if there's a benefit to the mix, but I reckon this is clearer: SELECT a.id, b.name FROM a INNER JOIN b ON a.id = b.id LEFT OUTER JOIN b ON a.id = b.id Is this code actually used or an example for the question? Adrian -Original Message- From: Discover Antartica [mailto:discoverantart...@yahoo.com] Sent: 22 August 2009 00:50 To: cf-talk Subject: simple SQL Question what does the *= mean in a query. For example: select a.id, b.name from a inner join b on a.id = b.id where a.id *= b.id Thank ~| 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:325600 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Cannot declare local variable cfcatch twice
Can we see your code? -Original Message- From: SANJEEV SINGLA [mailto:planetsanj...@gmail.com] Sent: 19 August 2009 07:43 To: cf-talk Subject: Cannot declare local variable cfcatch twice Hi All, I migrated my CFMX6.1 application to CF8 on my local dev machine and getting the following error. Cannot declare local variable cfcatch twice. Local variables cannot have the same names as parameters or other local variables. Please let me know how it can be resolved. Thanks! Sanjeev ~| 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:325537 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ajax cfc not working for Access DB -- odd stuff
Railo or OpenBD? Do they support cfajaxproxy yet?
-Original Message-
From: Don L [mailto:do...@yahoo.com]
Sent: 19 August 2009 22:42
To: cf-talk
Subject: ajax cfc not working for Access DB -- odd stuff
I've moved on to an open source cfml engine, don't know what caused the
following odd behavior, that is, my cfajaxproxy tag no longer works for
an inline data editing function (meaning, it does not do database
update for a set of data) while the same code works for ms sql server
2005 express (db syntax are exactly same for such a simple query) and
since I'm using sync mode I can't use the setCallbackHandler method
to do debugging. Thought, could use more heads here...
caller line
cfajaxproxy cfc=myCFC4inlineEdit jsclassname=UpdateObj2 /
cfc code and js code below,
cfcomponent output=false
cfset THIS.dsn=myDS
cffunction name=doUpdate access=remote
cfloop item=i collection=#arguments#
cfif Left(i,6) IS someID
cfset someid = arguments.#i#
/cfif
cfif Left(i,4) IS uaid
cfset uaid = arguments.#i#
/cfif
cfif Left(i,5) IS whats
cfset whats = arguments.#i#
/cfif
/cfloop
cfif not isdefined(arguments.userID)
cfset arguments.someID = 'dummyID728932'
/cfif
cfset fmtwhats = REreplace(Evaluate(whats),','',ALL)
cfset fmwhats = REreplace(fmtwhats,'','',ALL)
cfparam name=result default=success
cftry
cfquery datasource=#THIS.dsn#
update blablaTBL
set whats = '#fmwhats#'
where uaid = cfqueryPARAM value =
#Evaluate(uaid)#
cfsqltype=CF_SQL_INTEGER
and sid = cfqueryPARAM
value =
#Evaluate(someid)#
cfsqltype=CF_SQL_VARCHAR
maxlength=128;
/cfquery
cfcatch type=databasecfset result=failed
/cfcatch
/cftry
!---cfreturn #fmWhats#---
cfreturn #result#
/cffunction
/cfcomponent
// much credit goes to Sam Farmer for getting me started on this (JSON)
approach
function callUpdateJS2(frm,row) {
rowUpdate(frm,row);
}
function handleResult(r) {
console.log(r);
}
function rowUpdate(frm,row){
// var d = new DraftObj();
var d = new UpdateObj2();
d.setSyncMode(true);
d.setForm(frm);
d.setHTTPMethod('POST');
// d.doUpdate();
// expect d.doUpdate() to return failed or success string
// BUT it doesn't!
// update {notes} field; 05/28/2008
document.getElementById(row).innerHTML = d.doUpdate();
}
Forgive me about the formatting and typo if any.
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:325550
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: odd error calling function in cfc
Yeah, reserved word seems unlikely. Chances are you're overwriting add_option somewhere or the scoping is out somehow. I notice there's no var scope on your getOptions query, var scope everything and see it that sorts things. It's hard to say more without seeing the full CFC mind. Adrian -Original Message- From: Charlie Griefer [mailto:charlie.grie...@gmail.com] Sent: 16 August 2009 04:24 To: cf-talk Subject: Re: odd error calling function in cfc I'd be really surprised if that was the actual issue. if add_option was a reserved word, your initial iteration of the loop would have thrown the error (you said it would successfully complete the first iteration and then break). I'm not sure what the issues is, I'm just saying I'd be surprised if it turned out to be the variable name, in this case :) On Sat, Aug 15, 2009 at 7:57 PM, Mike Little m...@nzsolutions.co.nz wrote: you kow what is was... it was the name of the function add_option - i have renamed to add_new_option and it works. if someon could explain that one?? is it a reserved word? You don't really need the CFIF test, since CFOUTPUT will only render if there are records. Simplify like the example below and see if it still gives you trouble. If it does, then check that the add_option() method isn't erroring ... cfoutput query=getOptions cfset add_option(product_id=arguments.product_id, product_option_title=product_option_title) /cfoutput ~| 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:325481 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Records set in CFStruct
cfset bothQueries = fnc_navigation(args go here) cfset thisIsOneQuery = bothQueries.rs_navsFrontEnd cfset thisIsTheOtherQuery = bothQueries.rs_navsAdmin cfdump var=#thisIsOneQuery# cfdump var=#thisIsTheOtherQuery# cfoutput query=thisIsOneQuery ... /cfoutput There are other ways, but this is one that'll work. Adrian -Original Message- From: Matthew Allen [mailto:a.matthe...@yahoo.com] Sent: 12 August 2009 12:21 To: cf-talk Subject: Records set in CFStruct Can someone please point me to the right direction. I am returning two result sets from a single query (stored proc). When I CFDUMP query as in cfdump var=#returnStruct# i get the two record sets displayed below. The question is how do I use cfoutput to display the record set below; Thanks struct ...SNIP... The code. cffunction name=fnc_navigation access=public output=NO returntype=struct cfargument name=DSN type=string required=yes default= cfargument name=permission type=numeric required=yes default=0 cfset var returnStruct = StructNew() / cfstoredproc datasource=#arguments.DSN# procedure=usp_navigation cfprocparam cfsqltype=CF_SQL_INTEGER value=#arguments.permission# cfprocresult name=rs_navsFrontEnd resultset=1 cfprocresult name=rs_navsAdmin resultset=2 /cfstoredproc cfset returnStruct.rs_navsFrontEnd = rs_navsFrontEnd / cfset returnStruct.rs_navsAdmin = rs_navsAdmin / cfreturn returnStruct / /cffunction ~| 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:325369 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Can you detect if CF page is loaded in Flex I-Frame?
Check if CGI.HTTP_USER_AGENT contains something different for Flex requests. Adrian -Original Message- From: Gordon Nall [mailto:gor...@imgstudios.com] Sent: 08 August 2009 21:54 To: cf-talk Subject: Can you detect if CF page is loaded in Flex I-Frame? Question: Is there a way in ColdFusion to detect if the CF page is displayed in a Flex I-Frame? Here's my dilemma - I have a Flex Store that loads a CF Community in an I-Frame. The client wants to send out links that go directly to sections of the CF Community. So how can I tell if a user is loading the page in an I-Frame within the Flex App, or as it's own stand-alone CF page? I need to know so when a user links directly into the Community, I can display a link to launch the Flex store, but hide the link when they are already in the Flex store merely navigating within the I-Frame. My initial thought was to change the links within Flex that open the I- Frame to contain a URL variable, such as community.cfm?iframe=1, which I would detect in CF then add that (iframe=1) onto each link throughout the community, so as the user navigates around within the I-Frame, I know. Similarly, if the user navigates directly into the Community, I know that and can display a link to load the Flex store. Is there an easier, more elegant solution? Thx, -- Gordon ~| 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:325304 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Can you detect if CF page is loaded in Flex I-Frame?
That's fair enough. Dump the CGI scope, see if there's anything else of interest. -Original Message- From: Gordon Nall [mailto:gordon_trav...@yahoo.com] Sent: 08 August 2009 22:22 To: cf-talk Subject: Re: Can you detect if CF page is loaded in Flex I-Frame? Just tested the CGI.HTTP_USER_AGENT, not gonna work. I think thats more about what browser your using, as I just tested it it's the same whether Flex called it into an I-Frame or CF delivers as stand-alone page. ~| 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:325306 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 Axis Issues
I get the same on CF8 and on Railo I get:
org.xml.sax.SAXException: Deserializing parameter 'GetVersionInfoResponse':
could not find deserializer for type {urn:IWS}GetVersionInfoResponseType
Sorry that's not much help.
Adrian
-Original Message-
From: Jeremy Rottman [mailto:rottm...@gmail.com]
Sent: 07 August 2009 23:09
To: cf-talk
Subject: WebService Axis Issues
I am working with a webservice and the issues I am having with it are
not what you would call typical.
When I make the call to the webservice I get the following error.
AxisFault
faultCode:
{http://schemas.xmlsoap.org/soap/envelope/}Server.userException
faultSubcode:
faultString: org.xml.sax.SAXException: Invalid element in
IWS_pkg.GetVersionInfoResponseType - Version
faultActor:
faultNode:
faultDetail:
{http://xml.apache.org/axis/}stackTrace:org.xml.sax.SAXException:
Invalid element in IWS_pkg.GetVersionInfoResponseType - Version
at
org.apache.axis.encoding.ser.BeanDeserializer.onStartChild(BeanDeserial
izer.java:258)
at
org.apache.axis.encoding.DeserializationContext.startElement(Deserializ
ationContext.java:1035)
at
org.apache.axis.message.SAX2EventRecorder.replay(SAX2EventRecorder.java
:165)
at
org.apache.axis.message.MessageElement.publishToHandler(MessageElement.
java:1141)
at
org.apache.axis.message.RPCElement.deserialize(RPCElement.java:236)
at
org.apache.axis.message.RPCElement.getParams(RPCElement.java:384)
at org.apache.axis.client.Call.invoke(Call.java:2448)
at org.apache.axis.client.Call.invoke(Call.java:2347)
at org.apache.axis.c... ''
The method on the webservice is fairly simple. It simply returns a soap
response.
This is the soap request that is generated (using eclipse wtp)
- soapenv:Envelope
xmlns:soapenv=http://schemas.xmlsoap.org/soap/envelope/;
xmlns:q0=urn:IWS xmlns:xsd=http://www.w3.org/2001/XMLSchema;
xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance;
- soapenv:Body
q0:GetVersionInfo /
/soapenv:Body
/soapenv:Envelope
This is the soap response that is returned (again using eclipse wtp)
- SOAP-ENV:Envelope xmlns:SOAP-
ENV=http://schemas.xmlsoap.org/soap/envelope/; xmlns:SOAP-
ENC=http://schemas.xmlsoap.org/soap/encoding/;
xmlns:xsd=http://www.w3.org/2001/XMLSchema;
xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance;
- SOAP-ENV:Body
- GetVersionInfoResponse xmlns=urn:IWS
VersionIntelius WebServices v1.0.1/Version
/GetVersionInfoResponse
/SOAP-ENV:Body
/SOAP-ENV:Envelope
Here is the coldfusion code I am working with:
cfset ws = createObject(webservice,https://api.intelius.com/iws-
all.php?wsdl)
cfset test = ws.GetVersionInfo()
cfdump var=#test#/
~|
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:325298
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Looping with BufferedReader.readLine() and comparing to NULL
Hey all, I'm trying to get an alternative to cfexecute working and I'm wondering how to loop with a call to BufferedReader.readLine(). Here's the code: cfset runtime = CreateObject(java, java.lang.Runtime) cfset process = runtime.getRuntime().exec(cmd) cfset errStream = process.getErrorStream() cfset errInputStreamReader = CreateObject(java, java.io.InputStreamReader).init(errStream) cfset bufferedErrRead = CreateObject(java, java.io.BufferedReader).init(errInputStreamReader) cfloop from=1 to=20 index=line cfset err = bufferedErrRead.readLine() Chr(13) Chr(10) /cfloop The loop is hardcoded to run 20 times, but what I really need is to be able to do something like: while bufferedErrRead.readLine() != null Any ideas on how to do a check for a Java null in CF? Cheers. Adrian ~| 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:325144 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Looping with BufferedReader.readLine() and comparing to NULL
Why didn't I try the obvious one first, IsDefined()!
cfset runtime = CreateObject(java, java.lang.Runtime)
cfset process = runtime.getRuntime().exec(cmd)
cfset errStream = process.getErrorStream()
cfset errInputStreamReader = CreateObject(java,
java.io.InputStreamReader).init(errStream)
cfset bufferedErrRead = CreateObject(java,
java.io.BufferedReader).init(errInputStreamReader)
cfset line = bufferedErrRead.readLine()
cfloop condition=IsDefined('line')
cfset err = line Chr(13) Chr(10)
cfset line = bufferedErrRead.readLine()
/cfloop
Seems to work a treat.
Adrian
-Original Message-
From: Adrian Lynch [mailto:cont...@adrianlynch.co.uk]
Sent: 31 July 2009 16:01
To: cf-talk
Subject: Looping with BufferedReader.readLine() and comparing to NULL
Hey all, I'm trying to get an alternative to cfexecute working and I'm
wondering how to loop with a call to BufferedReader.readLine().
Here's the code:
cfset runtime = CreateObject(java, java.lang.Runtime)
cfset process = runtime.getRuntime().exec(cmd)
cfset errStream = process.getErrorStream()
cfset errInputStreamReader = CreateObject(java,
java.io.InputStreamReader).init(errStream)
cfset bufferedErrRead = CreateObject(java,
java.io.BufferedReader).init(errInputStreamReader)
cfloop from=1 to=20 index=line
cfset err = bufferedErrRead.readLine() Chr(13)
Chr(10)
/cfloop
The loop is hardcoded to run 20 times, but what I really need is to be
able
to do something like:
while bufferedErrRead.readLine() != null
Any ideas on how to do a check for a Java null in CF?
Cheers.
Adrian
~|
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:325145
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT javascript
You can in FF3. You have some typos that'll stop it working though. A closing double quote for the name attribute in your selects. You need a . in between the [0] options. Have a look at using jQuery though. It'll make this code a lot smaller. Adrian -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: 30 July 2009 16:20 To: cf-talk Subject: OT javascript Say I have two select inputs on one page and they are named the same. select name=ID option value=Please Select/option option value=11/option /select select name=ID option value=Please Select/option option value=11/option /select I want to write javascript to check that both of these are not left blank or in their default stage of Please Select. Can I do this in javascript ID[0] to get the value of the first one? var ID=document.orderForm.ID[0]options[document.orderForm.ID[0].selectedInd ex].value; var ID2=document.orderForm.ID[1]options[document.orderForm.ID[1].selectedIn dex].value; ~| 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:325121 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT javascript
That's ok. Having duplicate names is cool. Adrian -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: 30 July 2009 16:46 To: cf-talk Subject: RE: OT javascript When you submit it makes a comma delimited list of ID's that we loop over and use. Some pages have one select on them, some pages have 10 selects on them. So rather than making them uniquely named and tracking how many of them we just loop over the comma delimited list. -Original Message- From: Cutter (ColdFusion) [mailto:cold.fus...@cutterscrossing.com] Sent: Thursday, July 30, 2009 11:38 AM To: cf-talk Subject: Re: OT javascript Why would you have two selects with the same name? Radio Buttons? Sure. But not selects... ~| 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:325125 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFC Error on CF8 (Same working on CFMX 6.1)
Run the page in Firefox with Firebug installed for a better error message. Post your code for CallWebService() if you can. Adrian -Original Message- From: SANJEEV SINGLA [mailto:planetsanj...@gmail.com] Sent: 29 July 2009 13:44 To: cf-talk Subject: CFC Error on CF8 (Same working on CFMX 6.1) Hi All, I am moving my old CFMX 6.1 code to CF8 for setting up some local environment. Most of the things are already set up or chnaged as per requirements. But I am getting an error while executing the following code (this line of code is in a java script library). var text= CallWebService(/Components/WS/wsabc.cfc?WSDL,sgetCMPFilter,params, XML); -- Call WebService is a custom witten javascript function to call the cfc functions (defined in separate js file). -- This is executing fine on CFMX 6.1 on development environment. I am geeting the Object Required java script error. (sgetCMPFilter is CFC method defined in a cfc file). When I actually tried to look what's happeing, I saw that no data is being returned by calling CallWebService function. I am wondering about the cause of the problem as the same code is working fine on CFMX 6.1 but not on CF8.1. Please 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:325073 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Question re: Reactor
Have you checked the table definitions are the same between dev and staging? It's possible to import/export/script tables and defaults not to go across too. Adrian -Original Message- From: Nathan Strutz [mailto:str...@gmail.com] Sent: 28 July 2009 05:30 To: cf-talk Subject: Re: Question re: Reactor Caroline, There haven't been very many big changes in Reactor for a few years. You should update to the latest version and see what breaks. (but no, I can't confirm that it works or doesn't in SQL2005) You may be able to win if you just update reactor, (making sure to delete the cache files in the reactor directory) and refreshing your app... nathan strutz [Blog and Family @ http://www.dopefly.com/] [AZCFUG Manager @ http://www.azcfug.org/] [Twitter @nathanstrutz] On Mon, Jul 27, 2009 at 4:47 PM, Caroline Wise caracol...@gmail.com wrote: We have a rather old application that uses an early version of Reactor (vintage 2006-ish). It works fine with SQL 2000 in the development environment. We don't get many change requests for this app so while it gets a lot of use in the production environment, things on dev and staging are pretty quiet. Recently I had to make an extremely minor content update and it turned out that the staging box version had an issue inserting a new user, a problem we could not duplicate in development or production. When I compared the the Reactor code it turned out that it was different for this part of the application. The user table is using some defaults and they were not picked up in the Reactor code. The client, who has control over the staging environment, updated the database to SQL 2005 some time ago and my suspicion is that our version of Reactor can't cope. I'm wondering if anyone out there is using a newer version of Reactor and can confirm that it works fine with SQL 2005. Also of course I'm trying to gauge the risk and effort involved with updating Reactor to that newer version. Would I have to replace the whole thing or are we talking about something akin to a plugin for 2005? Thanks in advance for your insights, Caroline Wise ~| 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:325028 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Converting Year to Integer
But then to take Azadi's point 4 and change it for this: 4) again, the simple cfset currentYear = year(now()) cfloop from=2000 to=#currentYear# index=yearCnt ALWAYS works. Something else is amiss. -Original Message- From: N K [mailto:neetukais...@gmail.com] Sent: 24 July 2009 18:48 To: cf-talk Subject: Re: Converting Year to Integer The whole idea of not using to=#year(now())# and declaring it is because the currYear variable is used at more than one place. So if the variable is set used CFSET then there are couple of modifications required. NK 1) year(now()) returns an integer - there is no need to call int() function on it. 2) the cfoutput... line in your code is totally useless and unnecessary. 3) is this code of yours in a cfm page or in a cfc function? 4) again, the simple cfloop from=2000 to=#year(now())# index=yearCnt ALWAYS works. Azadi Saryev Sabai-dee.com http://www.sabai-dee.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:324966 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Converting Year to Integer
Is Year((now)) a typo in your email? If not, try Year(Now()) and you will need the #'s in the to attribute of cfloop. Adrian -Original Message- From: N K [mailto:neetukais...@gmail.com] Sent: 24 July 2009 14:31 To: cf-talk Subject: Converting Year to Integer I am looping the records starting from the Year 2000 to current year. But some how the the CFLOOP gives me an error stating Can not convert into number I tried the following ,any idea how to fix the issue:-- cfset currYear= Year((now)) cfset currYear=int(currYear) table CFLOOP index=yearCnt from='2000' to='currYear' tr tdCFOUTPUT#yearCnt#/CFOUTPUT/td /tr /cfloop /table ~| 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:324925 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Converting Year to Integer
And failing that, post all your code... -Original Message- From: Dave Sueltenfuss [mailto:dsueltenf...@gmail.com] Sent: 24 July 2009 14:56 To: cf-talk Subject: Re: Converting Year to Integer Have you tried outputing your currYear variable, to make sure it is what you expect? On Fri, Jul 24, 2009 at 9:47 AM, N K neetukais...@gmail.com wrote: Yes thats a typo in my email.Adding ## sign does not help The error coming up is Attribute validation error for the CFLOOP tag. The value of the TO attribute is invalid. The value cannot be converted to a numeric because it is not a simple value.Simple values are booleans, numbers, strings, and date-time values. Thank You NK Is Year((now)) a typo in your email? If not, try Year(Now()) and you will need the #'s in the to attribute of cfloop. Adrian ~| 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:324931 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Converting Year to Integer
Right but something else is wrong. Azadi's example is about as simple as it gets. Something else in your code is causing the problem. -Original Message- From: N K [mailto:neetukais...@gmail.com] Sent: 24 July 2009 15:09 To: cf-talk Subject: Re: Converting Year to Integer currYear with out codes and inside ## sign WORKS !!! CFLOOP index=yearCnt from='2000' to=#currYear# NK simple CFLOOP index=yearCnt from='2000' to='#year(now())#' should work just fine. Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ On 24/07/2009 21:31, N K wrote: CFLOOP index=yearCnt from='2000' to='currYear' ~| 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:324938 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF8 functions only working in webroot?
All the AJAXy tags and function access files in domain.com/cfide/blaa/blaa. Add CFIDE as a virtual directory in your new sites and see if that fixes it. Adrian -Original Message- From: Paul Henderson [mailto:pa...@d2phosting.com] Sent: 22 July 2009 21:14 To: cf-talk Subject: CF8 functions only working in webroot? I'm not sure why this is but I'm working on a new CF8 install using IIS and for whatever reason the CF8 functions such as cflayout only seem to work in the webroot and default site. All other CF functionality works on the sub sites. Any ideas why I'm facing this issue? Thanks in advance -Paul ~| 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:324822 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SSOT: open source software
Well you're talking about Railo or OpenBD, which is it and what problem are you having? Adrian -Original Message- From: Don L [mailto:do...@yahoo.com] Sent: 20 July 2009 03:53 To: cf-talk Subject: SSOT: open source software Particularly related to ColdFusion. I understand open source software is not free software. So, to get everything working one has to pay something if he/she does not have the time or expertise to dig everything... and that seems fair, but if someone is asking about thousand or thousands of dollars upfront, I don't think that's a productive way of moving forward... Also, you may hear something like this, this key person is on vacation and will be back in like two weeks or you need patience, in the business world, every day counts (you snooze you lose). This ranting is for the benefit of whose who are considering switch from Adobe ColdFusion to other options. I'm not suggesting not to make the switch but think twice or better talk to the key person of the product you intend to switch to and possibly strike a deal or at least obtain his/her support first otherwise your conversion/switch would be at the mercy of others. ~| 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:324709 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: getDirectoryFromPath Question
Not sure exactly, but I always do this:
ExpandPath(.)
rather than this:
ExpandPath(*.*)
Try removing the *'s and see what happens.
Adrian
-Original Message-
From: Hunsaker, Michael Scott [mailto:mhuns...@indiana.edu]
Sent: 20 July 2009 14:24
To: cf-talk
Subject: getDirectoryFromPath Question
Hello -
I've noticed something strange when using the getDirectoryFromPath
function and wanted to see if anyone else has seen this. It's probably
something I'm doing incorrectly. Here's what I'm doing:
In the application.cfc, I created an application variable to hold the
physical path of the web site files. Instead of manually entering the
physical path (G:\ Inetpub\wwwroot), I used the getDirectoryFromPath
function like this:
#getdirectoryfrompath(expandpath('*.*'))#
That returns the same thing. However, when I use the function above as
the destination in the CFFILE function, it returns an error. The
error says:
The value of the attribute destination, which is currently
G:\Inetpub\wwwroot\, is invalid.
For some reason it adds a comma at the end of the physical path but I
can't figure out why. Any ideas? I would appreciate any help.
Thanks!!
Mike
Mike Hunsaker
Assistant Director of Information Systems
Kelley School of Business MBA Program
1275 East Tenth Street, Suite 2010
Bloomington, IN 47405
812.855.7024
mhuns...@indiana.edumailto:mhuns...@indiana.edu
Advance your career. Enhance your life.
~|
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:324713
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: getDirectoryFromPath Question
What does this show you:
cfoutput#application.physpath#data\/cfoutput
-Original Message-
From: Hunsaker, Michael Scott [mailto:mhuns...@indiana.edu]
Sent: 20 July 2009 17:49
To: cf-talk
Subject: RE: getDirectoryFromPath Question
Thanks for the help! Here's my CFFILE function:
cffile action= upload
filefield = form.embarkFile
destination = #application.physpath#data\
nameconflict = overwrite
accept= text/plain
attributes= Normal /
The #application.physpath# is declared as
#getdirectoryfrompath(expandpath('*.*'))# in the application.cfc.
The form.embarkFile is uploaded in the self-posting form. So between
the destination and fileField, the CFFILE should be okay... right?
Thanks for the help!! I really appreciate it!
Mike
-Original Message-
From: Rick Root [mailto:rick.r...@webworksllc.com]
Sent: Monday, July 20, 2009 9:56 AM
To: cf-talk
Subject: Re: getDirectoryFromPath Question
On Mon, Jul 20, 2009 at 9:23 AM, Hunsaker, Michael
Scottmhuns...@indiana.edu wrote:
#getdirectoryfrompath(expandpath('*.*'))#
That returns the same thing. However, when I use the function above
as the destination in the CFFILE function, it returns an error. The
error says:
The value of the attribute destination, which is currently
G:\Inetpub\wwwroot\, is invalid.
For some reason it adds a comma at the end of the physical path but I
can't figure out why. Any ideas? I would appreciate any help.
What others said, the comma is part of the error message, not the
value.
Can we see the full CFFILE?
You probably need a filename there, not a directory path.
~|
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:324728
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: getDirectoryFromPath Question
I could be wrong, but I remember that not being the case a good while back. Both fileField and FORM.fileField would work in the filefield attribute. Am I mistaken? Adrian -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: 20 July 2009 19:32 To: cf-talk Subject: RE: getDirectoryFromPath Question Not a surprise, really. The fileField tells CF to look for that variable name in the FORM scope, so that if it was a custom tag, for instance, CF would try this: form[attributes.filefield]. form[form.filefield] would in invalid in that case ... ~| 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:324741 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Calling .ASPX.VB from .CFM
Yes. Chances are you need to pass arguments along with your method call. Adrian -Original Message- From: Jason Neidert [mailto:ja...@steelfusion.com] Sent: 17 July 2009 18:50 To: cf-talk Subject: RE: Calling .ASPX.VB from .CFM Here is a link to the .WSDL file: http://lutsen.steelfusion.com/winter/rates_packages/packages/rdp/rdp/rd pweb/ IRMPublic.wsdl So I tried this: cfinvoke webservice=http://lutsen.steelfusion.com/winter/rates_packages/package s/rdp /rdp/rdpweb/IRMPublic.wsdl method=CheckAvailability returnvariable=aTemp /cfinvoke cfdump var=#aTemp# To call this code: http://lutsen.steelfusion.com/winter/rates_packages/packages/rdp/act_ca llDot Net.cfm It tells me that CheckAvailability cannot be found. I can see the it though in the wsdl file. Am I calling incorrectly? Thanks again, Jason ~| 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:324693 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Last modified Date for file
Try GetFileInfo() on CF8. Not sure how reliable the date last modified attribute is though. Doesn't it get updated with any kind of access? Maybe I'm thinking of something else. Adrian -Original Message- From: RamaDevi Dobbala [mailto:ramadobb...@gmail.com] Sent: 07 July 2009 10:39 To: cf-talk Subject: Reg:Last modified Date for file I need help on this, can any one tell me that, how can i get the last modified date of a file, because every day my file is going to update i.e some scheduler is runnign for that.Just i need last modified date of that file. ~| 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:324281 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Reg:Last modified Date for file
Dump qGetLastdateModified to see what's being returned as your code looks sound. Adrian -Original Message- From: RamaDevi Dobbala [mailto:ramadobb...@gmail.com] Sent: 07 July 2009 10:57 To: cf-talk Subject: Re: Reg:Last modified Date for file cfset fileList = datatrac.csv,datatrac-ag.csv cfoutput cfloop list=#fileList# index=page cfdirectory action=list directory=#application.domainname#\sections\uploads\xfer\ filter=#page# name=qGetLastdateModified #page# was last modified on : #DateFormat(qGetLastdateModified.dateLastModified, mm/dd/)#BR /cfloop /cfoutput i am wrikting this query but i am not able to see date, for me just i am able to see till this ( #page# was last modified on :), after this modified date is not printing, why it is happening like this, is there any thing wrong in this 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:324284 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Reality check
cfset variables.instance.scheduleWeekdayDAO=null / Ermmm, since when has this worked?! Do you create your own null variable? Adrian -Original Message- From: Phillip Vector [mailto:vec...@mostdeadlygame.com] Sent: 07 July 2009 17:24 To: cf-talk Subject: Re: Reality check As for the error message.. The WEEKDAYDAO argument passed to the init function is not of type ScheduleTimeDAO. If the component name is specified as a type of this argument, its possible that a definition file for the component cannot be found or is not accessible. The error occurred in C:\Webpages\Testing\vv_loc\cfcs\schedules\ScheduleDAO.cfc: line 6 Called from C:\Webpages\VinoVisit\vv_loc\cfcs\schedules\ScheduleBuilder.cfc: line 22 Called from C:\Webpages\VinoVisit\vv_loc\admin\application.cfc: line 22 4 : cfset variables.instance.scheduleWeekdayDAO=null / 5 : 6 : cffunction name=init access=package output=false returntype=ScheduleDAO 7 : cfargument name=TimeDAO type=ScheduleTimeDAO required=true 8 : cfargument name=WeekdayDAO type=ScheduleTimeDAO required=true The main thing that makes me suspect that it's code is that I'm accessing http://127.0.0.1/Testing/vv_loc/admin/ and it's correctly pointing to C:\Webpages\Testing\vv_loc\cfcs\schedules\ScheduleDAO.cfc On Tue, Jul 7, 2009 at 9:23 AM, Phillip Vectorvec...@mostdeadlygame.com wrote: The files were given to me as is and I was told they work fine on his windows dev machine. The more I think about it, the more I'm wondering if I don't have the files that are on the server, or his remake of it (he said only the admin directory works currently, but on the site, the non-admin files work). I'm installing a virtural machine and seeing about eliminating all possible issues with the server config. On Tue, Jul 7, 2009 at 9:18 AM, Nathan C. Smithnathan.sm...@ipmvs.com wrote: Don't forget about case-sensitivity of filenames. Especially on includes and such. -Original Message- From: Phillip Vector [mailto:vec...@mostdeadlygame.com] Sent: Tuesday, July 07, 2009 10:25 AM To: cf-talk Subject: Reality check Just need confirmation that I'm not losing it.. I have apache running on my dev server. A client gave me his files and I'm trying to get them set up on my local server (he is running IIS). However, after I create the mappings in CF and go to the directory that in his IIS, he has set to default to, I get a ColdFusion error (some variable is a complex variable or some such). It finds the files and the cfc as well. So.. It isn't that I'm using Apache and they are using IIS.. Right? The code is just broke. or am I missing something here? ~| 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:324317 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Reality check
The reason I asked is because cfset something = null will error unless null is defined. I thought maybe there was some Java magic going on a few lines up. -Original Message- From: Phillip Vector [mailto:vec...@mostdeadlygame.com] Sent: 07 July 2009 18:27 To: cf-talk Subject: Re: Reality check Like I mentioned before, this is badly written code and apparently, it's being held together by some gum and duct tape (TAKE THAT MCGUYVER!) :) Anyway, yeah. I hope to be able to convince the guy to just let me overhaul the entire thing as there's allot of things like this. On Tue, Jul 7, 2009 at 10:23 AM, Adrian Lynchcont...@adrianlynch.co.uk wrote: cfset variables.instance.scheduleWeekdayDAO=null / Ermmm, since when has this worked?! Do you create your own null variable? Adrian -Original Message- From: Phillip Vector [mailto:vec...@mostdeadlygame.com] Sent: 07 July 2009 17:24 To: cf-talk Subject: Re: Reality check As for the error message.. The WEEKDAYDAO argument passed to the init function is not of type ScheduleTimeDAO. If the component name is specified as a type of this argument, its possible that a definition file for the component cannot be found or is not accessible. The error occurred in C:\Webpages\Testing\vv_loc\cfcs\schedules\ScheduleDAO.cfc: line 6 Called from C:\Webpages\VinoVisit\vv_loc\cfcs\schedules\ScheduleBuilder.cfc: line 22 Called from C:\Webpages\VinoVisit\vv_loc\admin\application.cfc: line 22 4 : cfset variables.instance.scheduleWeekdayDAO=null / 5 : 6 : cffunction name=init access=package output=false returntype=ScheduleDAO 7 : cfargument name=TimeDAO type=ScheduleTimeDAO required=true 8 : cfargument name=WeekdayDAO type=ScheduleTimeDAO required=true The main thing that makes me suspect that it's code is that I'm accessing http://127.0.0.1/Testing/vv_loc/admin/ and it's correctly pointing to C:\Webpages\Testing\vv_loc\cfcs\schedules\ScheduleDAO.cfc On Tue, Jul 7, 2009 at 9:23 AM, Phillip Vectorvec...@mostdeadlygame.com wrote: The files were given to me as is and I was told they work fine on his windows dev machine. The more I think about it, the more I'm wondering if I don't have the files that are on the server, or his remake of it (he said only the admin directory works currently, but on the site, the non-admin files work). I'm installing a virtural machine and seeing about eliminating all possible issues with the server config. On Tue, Jul 7, 2009 at 9:18 AM, Nathan C. Smithnathan.sm...@ipmvs.com wrote: Don't forget about case-sensitivity of filenames. Especially on includes and such. -Original Message- From: Phillip Vector [mailto:vec...@mostdeadlygame.com] Sent: Tuesday, July 07, 2009 10:25 AM To: cf-talk Subject: Reality check Just need confirmation that I'm not losing it.. I have apache running on my dev server. A client gave me his files and I'm trying to get them set up on my local server (he is running IIS). However, after I create the mappings in CF and go to the directory that in his IIS, he has set to default to, I get a ColdFusion error (some variable is a complex variable or some such). It finds the files and the cfc as well. So.. It isn't that I'm using Apache and they are using IIS.. Right? The code is just broke. or am I missing something here? ~| 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:324320 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: New CF8 vulnerability
If you mean your FCKEditor is accessed in a secure area, I don't think that matters. It's whether or not certain scripts can be accessed at yourdomain.com/cfide/scripts/bla/bla/eek.cfm. Someone correct me if this isn't the case... Adrian -Original Message- From: Matt Robertson [mailto:websitema...@gmail.com] Sent: 04 July 2009 05:01 To: cf-talk Subject: Re: New CF8 vulnerability Supposedly on July 6 a new version will be released that is at least better, if not 'fixed'. Kind of glad I put mine behind logins from the get-go. I am guessing that this affects all FCKEditor installations and not just CF8's cftextarea. Way back when, an earlier cf connector was so full of holes I wound up rewriting it with another developer's help and posting it on their forum. Guess that since then its code got a lot more complex but not a lot better. -- -...@robertson-- Janitor, The Robertson Team mysecretbase.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:324222 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: New CF8 vulnerability
I don't seem to have the same file directory as that posted in the second link. Instead I have: \CFIDE\scripts\ajax\FCKeditor\editor\filemanager\upload\cfm\config.cfm and: \CFIDE\scripts\ajax\FCKeditor\editor\filemanager\browser\default\connectors\ cfm\config.cfm Both of these files look like they are encrypted. Am I missing something? Adrian -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: 03 July 2009 00:17 To: cf-talk Subject: New CF8 vulnerability You may want to check for this on any clients/projects you've worked with: http://isc.sans.org/diary.html?storyid=6715 Remediation steps available here: http://www.codfusion.com/blog/post.cfm/cf8-and-fckeditor-security- threat 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! ~| 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:324179 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: query object error
Could you show more of your code. This works for me.
Oh and you don't need to assign to a temp var when using QuerySetCell.
Adrian
-Original Message-
From: Kamru Miah [mailto:k.m...@csl.gov.uk]
Sent: 30 June 2009 11:43
To: cf-talk
Subject: query object error
I am using CF8 and I have a query object (with 1 record) called 'role'
with the following 4 column names: groups, positions, role and teams.
I wish to work around a problem by inserting a value ('homeCla') to the
'positions' column/cell.
Using cfset Temp = QuerySetCell(role, 'positions', 'homeCla') gives
me the following error (note that cfdump does show the query exists!):
'The object (coldfusion.runtime.Struct) is not an query object.'
Any ideas how I can over come this problem please?
Thanks in anticipation.
~|
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:324058
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: query object error
cfset role.positions = your value -Original Message- From: Kamru Miah [mailto:k.m...@csl.gov.uk] Sent: 30 June 2009 12:08 To: cf-talk Subject: Re: query object error I just realised that the 'role' query form a include file is returntype=struct, and not returntype=query - dah! So now the question is, how do I insert a value to the 'positions' cell of the structure, please? Could you show more of your code. This works for me. Oh and you don't need to assign to a temp var when using QuerySetCell. Adrian ~| 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:324060 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Open source ColdFusion again
Well we are in a credit crunch! For me, this makes cfwindow utterly redundant. Dominic ~| 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:323806 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Application Scope Problem
How are you setting the component in the app scope? -Original Message- From: Dawson, Michael [mailto:m...@evansville.edu] Sent: 18 June 2009 14:20 To: cf-talk Subject: RE: Application Scope Problem We have had instances where a component, stored in the application scope, could not be found. It is weird, because it works 99% of the time. Thanks, Mike ~| 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:323633 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Application Scope Problem
Sorry Paul, I was talking to Michael. Just wanted to see how it was set because I've had similar errors but I put it down to OnApplicationStart only partially completing because of an error so some init code wasn't reached. Adrian -Original Message- From: Paul Alkema [mailto:paulalkemadesi...@gmail.com] Sent: 18 June 2009 14:53 To: cf-talk Subject: RE: Application Scope Problem Code Example !--- Start set application in scope --- cfset application.translator=createObject(component,'packages.translator.tr ansla tor') !--- End set application in scope --- !--- Start function --- cffunction access=public name=lookup returntype=string output=no hint=Returns the text found for the given language and placeholder cfargument name=placeholder type=string required=yes cfargument name=language type=string required=yes cfset var tempText = !--- Attempt to short-circuit the whole translation-in-memory thing, and just do a lookup TVR 1/19/2008 --- cfquery name=getTranslation datasource=mainDNS SELECT * FROM translations WHERE lang = cfqueryparam CFSQLType=STRING value=#language# AND placeholder = cfqueryparam CFSQLType=STRING value=#placeholder# /cfquery !--- If nothing found, and not already looking for English, check English --- cfif (getTranslation.recordCount EQ 0) AND (language NEQ 'EN') cfquery name=getTranslation datasource=mainDNS SELECT * FROM translations WHERE lang = 'EN' AND placeholder = cfqueryparam CFSQLType=STRING value=#placeholder# /cfquery /cfif cfif getTranslation.recordCount NEQ 0 !--- Replace any variables in the text, marked by % %, with values passed to the function as var1, var2, etc. --- cfset tempText = getTranslation.content cfloop collection=#arguments# item=varName cfif ucase(left(varName, 3)) eq VAR cfset tempText = replaceNoCase(tempText, % #varName# %, arguments[varName]) /cfif /cfloop /cfif cfreturn temptext /cffunction !--- End function --- !--- Start Usage --- cfoutput #application.translator.lookup(placeholder=testtext.69EE0E03,language =requ est.current_lang)# /cfoutput !--- End Usage --- -Original Message- From: Adrian Lynch [mailto:cont...@adrianlynch.co.uk] Sent: Thursday, June 18, 2009 9:43 AM To: cf-talk Subject: RE: Application Scope Problem How are you setting the component in the app scope? ~| 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:323636 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Image killing server (RESOLVED)
Dude and double dude! Excellent work :OD To stop the errors we started looking in files for certain strings to indicate the image would crap out CF. Will let you know how we get on when we upgrade. Adrian -Original Message- From: Mark Kruger [mailto:mkru...@cfwebtools.com] Sent: 09 June 2009 22:49 To: cf-talk Subject: RE: Image killing server (RESOLVED) Adrian, I have an explanation and a resolution for you. The problem is a buffer overrun in the ICC parser (a bit of color correction meta data that ships with the image). To resolve it I upgraded my JVM from 1.6.0_04 to 1.6.0_14 ... But _05 or above would do the trick I think. I'll write a blog on it and give a more thorough explanation - but meanwhile, I found my best clues by looking not for ColdFusion related image issues, but javax.imagaio related image issues. I found this post: http://www.securiteam.com/securitynews/5SP0E1PNQA.htm Which lead me more closely examine the update (build) number of my JVM install. I hope this helps you! -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Adrian Lynch [mailto:cont...@adrianlynch.co.uk] Sent: Tuesday, June 09, 2009 10:49 AM To: cf-talk Subject: RE: Image killing server Thanks Mark. You're right, I'm beginning to think I shouldn't have posted it on here now. I've submitted a bug report to Adobe. When I open it in GIMP I get told The image 'killer.jpg' has an embedded colour profile: eciRGB v2 ICCv4. cftry/cfcatch doesn't help so the only way I can think of to spot this prior to using ImageRead() etc. is to read the file in with cffile and look for eciRGB v2 ICCv4. But who's to say that will cover all the bases? Adrian -Original Message- From: Mark Kruger [mailto:mkru...@cfwebtools.com] Sent: 09 June 2009 16:32 To: cf-talk Subject: RE: Image killing server Follow up: I can verify the image is able to be previewed and edited using fireworks. I can't see anything unusual about it. I have to say if it's a something that is reproducible, it's going to be an attack vector. I can think of 3 or 4 servers I manage that need a fix for this pretty quickly if it becomes common knowledge. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Mark Kruger [mailto:mkru...@cfwebtools.com] Sent: Tuesday, June 09, 2009 10:27 AM To: cf-talk Subject: RE: Image killing server Adrian, I verified your results on an 8.01 dev server running on my local XP box. Sure enough the service restarts. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Adrian Lynch [mailto:cont...@adrianlynch.co.uk] Sent: Tuesday, June 09, 2009 9:43 AM To: cf-talk Subject: Image killing server Hey all, got a bit of a strange one here. A user is uploading an image which GIMP is reporting to have an embedded colour profile of . When I use any of the image functions on this image, CF dies. I posted a while ago but because it was only one user we converted it manually and re-uploaded, now we're getting more of them. Could I ask for a sanity check by someone confirming that this image is killing their server too? http://www.halestorm.co.uk/images/killer.jpg Download it, create a .cfm page and do ImageRead(ExpandPath(./killer.jpg)) I get a blank page back then on refresh a message saying CF is starting up. I'm on the bug report page at the moment but I thought I would get someone else to test this also. Thanks. Adrian Lynch | www.halestorm.co.uk ~| 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:323329 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Simple regex question
There's a ISVIN function on CFLib and I had originally proposed to my boss that I rewrite it in javascript but he didn't want that level of functionality. Just do it, don't ask the boss! :OD ~| 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:323355 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Image killing server
Hey all, got a bit of a strange one here. A user is uploading an image which GIMP is reporting to have an embedded colour profile of . When I use any of the image functions on this image, CF dies. I posted a while ago but because it was only one user we converted it manually and re-uploaded, now we're getting more of them. Could I ask for a sanity check by someone confirming that this image is killing their server too? http://www.halestorm.co.uk/images/killer.jpg Download it, create a .cfm page and do ImageRead(ExpandPath(./killer.jpg)) I get a blank page back then on refresh a message saying CF is starting up. I'm on the bug report page at the moment but I thought I would get someone else to test this also. Thanks. Adrian Lynch | www.halestorm.co.uk ~| 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:323264 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Image killing server
Hey, thanks Jason, I did the blackout myself. It's an image for an awards show so I thought it best to mask it. It is RGB, CMYK was our first thought too. Adrian -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: 09 June 2009 15:54 To: cf-talk Subject: re: Image killing server Just looking at the link you sent in a browser, the image is nearly all black, which makes me think it's a CMYK jpeg, instead of an RGB jpeg. Browsers and the Adobe image engine can't handle the CMYK ... that's my guess. ~| 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:323266 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Image killing server
Of course ;O) Still kills our servers. Has anyone witnessed it yet? -Original Message- From: Robert Harrison [mailto:rob...@austin-williams.com] Sent: 09 June 2009 16:15 To: cf-talk Subject: RE: Image killing server I did the blackout myself. Yes, but that also means you altered the image and we're no longer looking at the image you have a problem with. Did you verify the CF function fails on this version of the image? Robert B. Harrison Director of Interactive Services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged __ Information from ESET Smart Security, version of virus signature database 4141 (20090609) __ The message was checked by ESET Smart Security. http://www.eset.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:323269 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Image killing server
Ah, interesting! -Original Message- From: Azadi Saryev [mailto:az...@sabai-dee.com] Sent: 09 June 2009 16:24 To: cf-talk Subject: Re: Image killing server hmm... worked just fine on my dev server... cfset myimage = ImageRead(ExpandPath(./killer.jpg)) cfdump var=#myimage# format=text dumped me this nice struct: struct colormodel: [struct] alpha_channel_support: NO alpha_premultiplied: NO bits_component_1: 8 bits_component_2: 8 bits_component_3: 8 colormodel_type: ComponentColorModel colorspace: Any of the family of RGB color spaces num_color_components: 3 num_components: 3 pixel_size: 24 transparency: OPAQUE height: 768 source: ...\killer.jpg width: 1024 NOTE: my dev server *DOES NOT* have the 71557 cfimage hotfix installed (http://www.adobe.com/go/kb403411) Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ On 09/06/2009 21:59, Adrian Lynch wrote: Hey, thanks Jason, I did the blackout myself. It's an image for an awards show so I thought it best to mask it. It is RGB, CMYK was our first thought too. Adrian -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: 09 June 2009 15:54 To: cf-talk Subject: re: Image killing server Just looking at the link you sent in a browser, the image is nearly all black, which makes me think it's a CMYK jpeg, instead of an RGB jpeg. Browsers and the Adobe image engine can't handle the CMYK ... that's my guess. ~| 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:323272 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Image killing server
Thanks Mark. You're right, I'm beginning to think I shouldn't have posted it on here now. I've submitted a bug report to Adobe. When I open it in GIMP I get told The image 'killer.jpg' has an embedded colour profile: eciRGB v2 ICCv4. cftry/cfcatch doesn't help so the only way I can think of to spot this prior to using ImageRead() etc. is to read the file in with cffile and look for eciRGB v2 ICCv4. But who's to say that will cover all the bases? Adrian -Original Message- From: Mark Kruger [mailto:mkru...@cfwebtools.com] Sent: 09 June 2009 16:32 To: cf-talk Subject: RE: Image killing server Follow up: I can verify the image is able to be previewed and edited using fireworks. I can't see anything unusual about it. I have to say if it's a something that is reproducible, it's going to be an attack vector. I can think of 3 or 4 servers I manage that need a fix for this pretty quickly if it becomes common knowledge. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Mark Kruger [mailto:mkru...@cfwebtools.com] Sent: Tuesday, June 09, 2009 10:27 AM To: cf-talk Subject: RE: Image killing server Adrian, I verified your results on an 8.01 dev server running on my local XP box. Sure enough the service restarts. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Adrian Lynch [mailto:cont...@adrianlynch.co.uk] Sent: Tuesday, June 09, 2009 9:43 AM To: cf-talk Subject: Image killing server Hey all, got a bit of a strange one here. A user is uploading an image which GIMP is reporting to have an embedded colour profile of . When I use any of the image functions on this image, CF dies. I posted a while ago but because it was only one user we converted it manually and re-uploaded, now we're getting more of them. Could I ask for a sanity check by someone confirming that this image is killing their server too? http://www.halestorm.co.uk/images/killer.jpg Download it, create a .cfm page and do ImageRead(ExpandPath(./killer.jpg)) I get a blank page back then on refresh a message saying CF is starting up. I'm on the bug report page at the moment but I thought I would get someone else to test this also. Thanks. Adrian Lynch | www.halestorm.co.uk ~| 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:323277 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Send a textbox value to an object
cfset twitterObj.postToTwitter(FORM.twittMessage)
Adrian
-Original Message-
From: nikoo m [mailto:nikou...@yahoo.com]
Sent: 09 June 2009 19:40
To: cf-talk
Subject: Send a textbox value to an object
I have an object in ColdFusion that post message to twitter. It works
well when I write my message in ââ¬Å ââ¬Å like line below.
cfset twitterObj.postToTwitter My Message /
But I need to have a textbox, and type my message in textbox. Iââ¬â¢m not
sure how can get my textbox value here instead of this message,
every think I tried give me an error. Can anybody help?
This is my code.
BODY
form action=Form.cfm method=post
input type=text name=twittMessage
input type=Submit name=SubmitForm value=Submit to Twitter
cfif IsDefined(Form.twittMessage)
br
cfoutputYour message postet to twitter/cfoutput
/cfif
/form
!--- call the init() method ---
cfset twitterObj = createObject('component', 'twitterCFC').init
('username','password') /
!--- Post to twitter ---
//here is problem - How I can get the value of textbox here instead of
(My message to poet is here)
for example I thought it's Form.twittMessage but it doesnââ¬â¢t work.
*
cfset twitterObj.postToTwitter (My message to poet is here)/
~|
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:323295
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: reducing a query result
Query the query using the same query variable name. Adrian -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: 04 June 2009 16:07 To: cf-talk Subject: reducing a query result Say I have a query returned with 500 records. Is there a way in CF (not SQL) to reduce the query to only rows 1-50, 51-100 etc? I talking physically reducing the 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:323167 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Help ColdFusion Output URGENT
Come on dude, you've been told before, help us by asking better questions!
What doesn't work?
Format your code so it's easy for us to see what's going on, I can't be
bothered to look through your code because it's all over the place.
If the query is correct and the problem lies in the output, why include the
big ol' query?
Oh and... why oh why do you put 'urgent' in the subject line, it's not
urgent to me?!
Adrian
-Original Message-
From: erik tom [mailto:erik.tso...@jhu.edu]
Sent: 01 June 2009 19:18
To: cf-talk
Subject: Help ColdFusion Output URGENT
I have a query which list all the Team members, their Area MANagers,
Region Managers, Locations and so on .
What i need to do is to display each managers(name)
column2: total number of people in their area
column3: and total number of people completed the course in the area
I came up with code but does not seems to work now
query:
cfquery name=getCareManagers datasource=XX
Select distinct e.employeeid, e.last_name,
er.last_name as erLastName, er.first_name as erFirstName,
er.EMployeeID as REID,
ea.last_name as eaLastName, ea.first_name as eaFirstName,
l.name as locname, l.locationID,ea.Employeeid as AEID!---
,et.CompletionDate---
from employee e
join employeejobhistory h on h.employeeid
= e.employeeid
!--- left outer join EmployeeTraining et on (et.EmployeeID =
e.employeeID andet.COurseID = 1661)---
inner join jobassignment ja on
(ja.sequence = h.sequence)
inner join jobcode_list j
on j.jobcode = h.jobcode
inner join location l
on l.locationid = ja.locationid
inner join area a
on a.areaid = l.areaid
inner join employee ea on
ea.employeeid = a.managerEmpID
inner join region r on
r.regionid = a.regionid
inner join employee er on
er.employeeid = r.managerEmpID
where ja.EndDate is NULL cfif
isDefined(form.RC) and form.RC eq 0and (h.JobCode in
('1024','1005','1059','1009','1014','1001') and h.DeptName like
'Reminiscence%')cfelseif isDefined(form.RC) and form.RC eq 1and
(h.JobCode in ('1025') and h.DeptName like 'Reminiscence%') cfelseand
(h.JobCode in ('1024','1005','1059','1009','1014','1001','1025')and
h.DeptName like 'Reminiscence%')/cfifand
ja.EmplRcd = 0 and r.ManagerEmpID in
(#SESSION.Admin_Reports_locregmanager#)
order by REID,AEID,l.locationID
/cfquery
The code is below :
table border=1 width=50% align=center
tr
thArea/th
th width=36%Total
Number of people/th
thTotal Employees
Completed/th
th% Completed/th
/tr
cfset lastEmp=''
cfset RegionTotal =0
cfset RegionComplete=0
cfset AreaComplete=0
cfset AreaTotal = 0
cfset lastArea=''
cfset LocationComplete = 0
cfset LocationTotal = 0
cfset lEmp = ''
cfset lastLoc =''
cfset percent2= 0
cfoutput query=getCareManagers
cfset
AreaLastName=getCareManagers.eaLastName
cfset
AreaFirstName=getCareManagers.eaFirstName
cfquery name=getCompletion
datasource=cfelsunrise
Select completionDate
from EmployeeTraining where courseID = 1661 and EmployeeID =
#getCareManagers.EmployeeID#
/cfquery
cfif lastArea is not
AEID
cfset AreaTotal =
AreaTotal + 1
cfif
isDate(getCompletion.CompletionDate)
cfset
AreaComplete = AreaComplete + 1
/cfif
cfset percent2=(AreaComplete/AreaTotal)*100
tr bgcolor=##AFD8D8
td align=leftstrong#AreaLastName#,#AreaFirstName#/strong/td
td align=centerfont size=3#AreaTotal#/td
td align=centerfont size=3#AreaComplete#/td
td align=centerfont size=3b
style=color:##FF8000#NumberFormat(percent2,0.00)#%b/td
/tr
RE: cfmail problem in cfc
Is your mail server on the same machine as CF? Check it's running. It probably has nothing to do with being in a CFC. Create a simple cfm page to test it. Adrian -Original Message- From: arya krishnan [mailto:arun.b.shou...@gmail.com] Sent: 29 May 2009 19:17 To: cf-talk Subject: cfmail problem in cfc Hi All, I am able to send mails via cfmail tag in cfm pages but not in cfc. I used to send mails from cfc but now it is throwing the below error message.Please advice where i am going wrong Error,scheduler-2,05/29/09,06:15:32,,Could not connect to SMTP host: 12 7.0.0.1, port: 25; nested exception is: java.net.ConnectException: Conne ction refused javax.mail.MessagingException: Could not connect to SMTP host: 127.0.0.1, port: 25; nested exception is: java.net.ConnectException: Connection refused at com.sun.mail.smtp.SMTPTransport.openServer(SMTPTransport.java:1008) at com.sun.mail.smtp.SMTPTransport.protocolConnect(SMTPTransport.java:19 7) at javax.mail.Service.connect(Service.java:233) at coldfusion.mail.MailSpooler.getConnection(MailSpooler.java:908) at coldfusion.mail.MailSpooler.deliver(MailSpooler.java:773) at coldfusion.mail.MailSpooler.sendMail(MailSpooler.java:704) at coldfusion.mail.MailSpooler.deliverFast(MailSpooler.java:1028) at coldfusion.mail.MailSpooler.run(MailSpooler.java:938) at coldfusion.scheduling.ThreadPool.run(ThreadPool.java:201) at coldfusion.scheduling.WorkerThread.run(WorkerThread.java:70) ~| 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:322996 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: my cfqueryparam grievance
The user changed it maybe? Adrian -Original Message- From: Qing Xia [mailto:txiasum...@gmail.com] Sent: 14 May 2009 20:30 To: cf-talk Subject: Re: my cfqueryparam grievance But still, it is interesting to ponder whatever happened to my data, and why, of all things, everything got to be 521636a. Just another thing to think about on the metro. ~| 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:322521 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: my cfqueryparam grievance
I thought you said it was a cookie value? -Original Message- From: Qing Xia [mailto:txiasum...@gmail.com] Sent: 14 May 2009 20:43 To: cf-talk Subject: Re: my cfqueryparam grievance I wish--but the value is a ID value passed back in a query recordset and there is no way how users can manually pass it in. On Thu, May 14, 2009 at 3:39 PM, Adrian Lynch cont...@adrianlynch.co.ukwrote: The user changed it maybe? Adrian -Original Message- From: Qing Xia [mailto:txiasum...@gmail.com] Sent: 14 May 2009 20:30 To: cf-talk Subject: Re: my cfqueryparam grievance But still, it is interesting to ponder whatever happened to my data, and why, of all things, everything got to be 521636a. Just another thing to think about on the metro. ~| 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:322526 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: my cfqueryparam grievance
Maybe it's happening in code. Do a search for the variable and make sure you don't find something like: cfset COOKIE.something = a COOKIE.something Stranger things have happened :OD Adrian -Original Message- From: Qing Xia [mailto:txiasum...@gmail.com] Sent: 14 May 2009 21:33 To: cf-talk Subject: Re: my cfqueryparam grievance Ah yes! You are right--that ID value, after being returned in the query recordset, does get set in cookie scope, and that is where my cfqueryparam tag gets it from, in cookie scope. So, yeah, it is possible that users could have manipulated that cookie value... But then, with so many users (i must have had a couple dozen error messages at least, and they are from different legitimate users) all generating the same error message, it seems unlikely that they all changed their cookie to the same value. On Thu, May 14, 2009 at 4:01 PM, Adrian Lynch cont...@adrianlynch.co.ukwrote: I thought you said it was a cookie value? ~| 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:322533 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 (maybe): Display additional info from a Select before Form is Submitted
If there aren't many categories, load all the extra info into the page in
the place you need it to appear and hide it by default. Then on change of
the drop down, show the relevant info.
With jQuery:
script type=text/javascript src=/scripts/jquery-1.3.1.min.js/script
script type=text/javascript
$(function() {
$(#cats).change(function() {
$(.catInfo).hide();
$(#catInfo + jQuery(this).val()).show();
});
});
/script
style type=text/css
.catInfo {
display: none;
}
/style
select id=cats
option value=1One/option
option value=2Two/option
option value=3Three/option
/select
div id=catInfo1 class=catInfo
Cat into 1
/div
div id=catInfo2 class=catInfo
Cat into 2
/div
div id=catInfo3 class=catInfo
Cat into 3
/div
Adrian
-Original Message-
From: Les Mizzell [mailto:lesm...@bellsouth.net]
Sent: 13 May 2009 18:23
To: cf-talk
Subject: OT (maybe): Display additional info from a Select before Form
is Submitted
For a select box (simplified):
select name=catID id=select
cfloop query=getCATS
option value=#getCATS.catID##getCATS.catNAME#/option
/cfloop
/select
I need to display additional info for each selection when the selection
is made - before the form is submitted.
So if you've got
Record 1
Record 2
Record 3
...and somebody selects Record 2 - I need the contents of an
additional field (cat_comments) to immediately display under the
select before the form is submitted...
Still scratching my head. Can somebody point me in the correct
direction
to pull this off?
~|
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:322474
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: my cfqueryparam grievance
Start logging the value of COOKIE.theID. Just save it somewhere and see if it's ever an unexpected value. Adrian -Original Message- From: Qing Xia [mailto:txiasum...@gmail.com] Sent: 12 May 2009 20:16 To: cf-talk Subject: my cfqueryparam grievance Hello folks, I had a pretty strange experience with CFQueryParam today. Basically, I have an innocent-looking query: cfquery datasource=#application.myDB# name=qGetUser *SELECT* username, password *FROM* someTable *WHERE* someID = cfqueryparam cfsqltype=CF_SQL_INTEGER value= #cookie.theID# maxlength=6 /cfquery This query had worked just fine for nearly a year (since I cfqueryparamed it last summer) until this morning, when it broke. The error messages read: *Message:* Error Executing Database Query. 12 May 2009 01:49:21 PM EDT Diagnostics: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Syntax error converting the varchar value '521636a' to a column of data type int. The error occurred on line 35. That error points to the WHERE statement, and it complains the cookie.theID is not an integer-but it is!!! *Even the error messages themselves which contains a CFDump on Cookie scope say it is an integer, of 6 digits!!!* Even more strangely, the error messages always say .converting the varchar value '521636a'. , no matter what the actual cookie.theID value is. Since this query is called from a template that logs users in, I got dozens of error reports, all with this identical error message, even though the actual theID values were very different. When I switched the cfqueryparam cfsqltype to varchar, the error went away!! Of course, the actual data type of the id table column IS varchar, but I had purposefully made it integer in the cfqueryparam, for code readability and more control over the incoming value. L The moral of the story, of course, is that the cfsqltype should probably always match the receiving database table column's data type. But I am just curious. why were my values being converted to 521636a.? 6-digit integer/varchar values are certainly not out of bounds for SQL int data type, so I simply cannot fathom why conversion was done and why it was necessary. A ~| 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:322445 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 8 Hosting recommendations
Look at using Railo instead then :O) Adrian -Original Message- From: Gerald Guido [mailto:gerald.gu...@gmail.com] Sent: 11 May 2009 03:30 To: cf-talk Subject: Re: CF 8 Hosting recommendations and it has *always* used CF 8. Hey Rick, I hear ya. Unless they are offering CF 8 for free, I just don't want to pay an extra $35 a month (100% more) for CF 8 support. Silly notion eh? G! ~| 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:322368 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: table display: row number. without recordset
Same as CSS.
table.className
Adrian
-Original Message-
From: Paul Ihrig [mailto:pih...@gmail.com]
Sent: 11 May 2009 20:23
To: cf-talk
Subject: Re: table display: row number. without recordset
how would i target my tables with a class=tablesorterXP
but not any other table classes?
i tried
$(.tablesorterXP table tbody tr).each( function(i) {
$(td, $(this)).eq(0).html(i+1);
});
Thanks BTW this is just what i was looking for.
~|
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:322385
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: table display: row number. without recordset
It probably does, but it's sorted already. Adrian -Original Message- From: Paul Ihrig [mailto:pih...@gmail.com] Sent: 11 May 2009 20:44 To: cf-talk Subject: Re: table display: row number. without recordset one weird thing is the tablesorter dost work on that column unles i sort from another column first. ~| 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:322389 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Embedded colour profile killing server
This cumulative hot fix is specific to ColdFusion 8.0.1 and should not be applied to any other releases Completely missed that! Cheers James... -Original Message- From: James Holmes [mailto:james.hol...@gmail.com] Sent: 06 May 2009 03:49 To: cf-talk Subject: Re: Embedded colour profile killing server You need to install CF 8.01 before you can install its hotfixes. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/5/6 Adrian Lynch cont...@adrianlynch.co.uk: I think we were up-to-date at work, looking at my local dev machine I'm on 8,0,0,176276. I've just installed CF 8.0.1 cumulative hot fix 1 but the version in CF admin is still the same. So too is a dump of the SERVER scope. Any ideas why this might happen? I followed the instructions here: http://kb2.adobe.com/cps/403/kb403622.html Adrian -Original Message- From: Pete Freitag [mailto:p...@foundeo.com] Sent: 05 May 2009 20:53 To: cf-talk Subject: Re: Embedded colour profile killing server Adrian, I haven't seen this issue, but I am curious if you have the CFImage hotfix for CF 8.0.1 installed, maybe that would help? http://kb2.adobe.com/cps/403/kb403411.html -- Pete Freitag http://foundeo.com/ - ColdFusion Consulting Products http://petefreitag.com/ - My Blog Firewall for CFML: http://foundeo.com/security/ On Tue, May 5, 2009 at 9:25 AM, Adrian Lynch cont...@adrianlynch.co.ukwrote: I'm trying to work on an image with CF8. Doing a simple ImageRead() on one particular image causes the server to restart. This is happening on two servers which I'm told have more than enough memory. The image is 372KB, so nothing to worry about there. When I open it up in GIMP, I get asked whether I want to keep or convert an Embedded colour profile: eciRGB v2 ICCv4. Short of finding another reason, I'm going to be blaming this! It's a user supplied image. Has anyone else witnessed this? At most I'd expect an error, not a dead server. I would upload the image for others to test but it's for an award show and I'm not sure I'd be allowed, if I hear differently I'll wack it up somewhere. Thanks in advance for any thoughts (or well wishes for the server this is killing). ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322219 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Embedded colour profile killing server
Tried this and still no joy. Out of interest, should the version number change after applying that hotfix? My version is still 8,0,1,195765. Thanks. Adrian -Original Message- From: Pete Freitag [mailto:p...@foundeo.com] Sent: 05 May 2009 20:53 To: cf-talk Subject: Re: Embedded colour profile killing server Adrian, I haven't seen this issue, but I am curious if you have the CFImage hotfix for CF 8.0.1 installed, maybe that would help? http://kb2.adobe.com/cps/403/kb403411.html -- Pete Freitag http://foundeo.com/ - ColdFusion Consulting Products http://petefreitag.com/ - My Blog Firewall for CFML: http://foundeo.com/security/ On Tue, May 5, 2009 at 9:25 AM, Adrian Lynch cont...@adrianlynch.co.ukwrote: I'm trying to work on an image with CF8. Doing a simple ImageRead() on one particular image causes the server to restart. This is happening on two servers which I'm told have more than enough memory. The image is 372KB, so nothing to worry about there. When I open it up in GIMP, I get asked whether I want to keep or convert an Embedded colour profile: eciRGB v2 ICCv4. Short of finding another reason, I'm going to be blaming this! It's a user supplied image. Has anyone else witnessed this? At most I'd expect an error, not a dead server. I would upload the image for others to test but it's for an award show and I'm not sure I'd be allowed, if I hear differently I'll wack it up somewhere. Thanks in advance for any thoughts (or well wishes for the server this is killing). ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:33 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Embedded colour profile killing server
I'm trying to work on an image with CF8. Doing a simple ImageRead() on one particular image causes the server to restart. This is happening on two servers which I'm told have more than enough memory. The image is 372KB, so nothing to worry about there. When I open it up in GIMP, I get asked whether I want to keep or convert an Embedded colour profile: eciRGB v2 ICCv4. Short of finding another reason, I'm going to be blaming this! It's a user supplied image. Has anyone else witnessed this? At most I'd expect an error, not a dead server. I would upload the image for others to test but it's for an award show and I'm not sure I'd be allowed, if I hear differently I'll wack it up somewhere. Thanks in advance for any thoughts (or well wishes for the server this is killing). ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322169 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Server just.... stops?
Got the same thing happening to us but we know what's causing it, damned images! Do you know what's being run just before it dies? Adrian -Original Message- From: Justin Scott [mailto:jscott-li...@gravityfree.com] Sent: 05 May 2009 15:54 To: cf-talk Subject: Server just stops? We have an occasional issue with CF where the server just stops responding at random times and the CF application service has to be stopped and restarted. We're on CF 8.0.1 on Windows 2003 Server. Pretty standard setup. All of the logs show everything normal, then the next entries are server starting up lines. The windows event viewer doesn't show anything out of the ordinary. Anywhere else I should be looking for information? Any particular JVM arguments that might be helpful in tracking down obscure issues? -Justin ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322171 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Getting a count from a group in cfquery
You need to include the other columns in your SELECT in your GROUP BY clause. Adrian -Original Message- From: Les Mizzell [mailto:lesm...@bellsouth.net] Sent: 05 May 2009 16:56 To: cf-talk Subject: Getting a count from a group in cfquery What I'm trying to get: cfoutput query=thisLOG group=groupID / #thisCOUNT# emails sent on #thisLOG.emailDATE# cfoutput #thisLOG.emailADDRESS#br /cfoutput /cfoutput thisCOUNT above would be the number of emails in a particular group Here's what I want to do in my query - but errors work since everything isn't included in a scalar function. I'm using SQL Server SELECT COUNT(groupID) as thisCOUNT, emailID, emailADDRESS, emailDATE, groupID FROM log_email WHERE emailID = cfqueryparam value=#trim(url.emailID)# cfsqltype=CF_SQL_INTEGER / GROUP BY groupID ORDER BY emailDATE desc Haven't found a way to correct this yet that works. Suggestions please? TIA! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322179 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Embedded colour profile killing server
I think we were up-to-date at work, looking at my local dev machine I'm on 8,0,0,176276. I've just installed CF 8.0.1 cumulative hot fix 1 but the version in CF admin is still the same. So too is a dump of the SERVER scope. Any ideas why this might happen? I followed the instructions here: http://kb2.adobe.com/cps/403/kb403622.html Adrian -Original Message- From: Pete Freitag [mailto:p...@foundeo.com] Sent: 05 May 2009 20:53 To: cf-talk Subject: Re: Embedded colour profile killing server Adrian, I haven't seen this issue, but I am curious if you have the CFImage hotfix for CF 8.0.1 installed, maybe that would help? http://kb2.adobe.com/cps/403/kb403411.html -- Pete Freitag http://foundeo.com/ - ColdFusion Consulting Products http://petefreitag.com/ - My Blog Firewall for CFML: http://foundeo.com/security/ On Tue, May 5, 2009 at 9:25 AM, Adrian Lynch cont...@adrianlynch.co.ukwrote: I'm trying to work on an image with CF8. Doing a simple ImageRead() on one particular image causes the server to restart. This is happening on two servers which I'm told have more than enough memory. The image is 372KB, so nothing to worry about there. When I open it up in GIMP, I get asked whether I want to keep or convert an Embedded colour profile: eciRGB v2 ICCv4. Short of finding another reason, I'm going to be blaming this! It's a user supplied image. Has anyone else witnessed this? At most I'd expect an error, not a dead server. I would upload the image for others to test but it's for an award show and I'm not sure I'd be allowed, if I hear differently I'll wack it up somewhere. Thanks in advance for any thoughts (or well wishes for the server this is killing). ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322210 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Unable to dump checkbox Values
You don't say what's wrong, but from these lines:
cfif chk_deletePage#count# neq ''
cfdump var='#form.chk_deletePage#i##'
/cfif
I'm guessing it's throwing an error?
cfif FORM[chk_deletePage#count#] neq ''
cfdump var=#FORM['chk_deletePage' count']#
/cfif
Adrian
-Original Message-
From: Priya Koya [mailto:priya23...@gmail.com]
Sent: 28 April 2009 16:26
To: cf-talk
Subject: Unable to dump checkbox Values
Hi All,
I have a checkbox in the cfoutput query and wanna record the values
of the checkbox and perform of delete using function.
I am unable to dump the checkbox values in it.I believe I am doing
someting wrong in the loop..Can anyone help me out with it.
cfset count=1
cfoutput query='Qry_getInfo'
table
tr
tdcfinput type=checkbox value=#getData.Name#
name=chk_deletePage#count#/td
cfparam default= name=form.chk_deletePage#count#
td#getData.Address#/td
/tr
trcfinput type='submit'name='Submit'/tr
/table
cfif isDefined('form.Submit')
cfloop from=1 to=#count# index=i
cfif chk_deletePage#count# neq ''
cfdump var='#form.chk_deletePage#i##'
/cfif
/cfloop
/cfif
what is that I am doing wrong
Thanks,
Priya
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322020
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Need some WSDL Help
Why don't you post the problem here? -Original Message- From: Rick Shapley [mailto:rs...@cade1.com] Sent: 28 April 2009 18:03 To: cf-talk Subject: Need some WSDL Help We are trying to connect some Cold Fusion Generated Data to a WSDL file. Can anyone help? Please e-mail me at rs...@cade1.com Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322024 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Set column value to NULL
cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#session.ID# null=true Adrian -Original Message- From: Pranathi Reddy [mailto:rk.prana...@gmail.com] Sent: 28 April 2009 18:06 To: cf-talk Subject: Set column value to NULL My image datatype is varbinary(max) and I am storing binary image data in database. This query works fine in sql Server 2005 to set the attribute to 'Null'(delete binary data) but wat if I wanna use in coldfusion8 cfquery update table1 set image = null where empid ='@id' I tried using cfquery name=Qry_DeleteImage datasource=#application.datasource# Update table1 SET image = cfqueryparam cfsqltype=CF_SQL_VARBINARY null=true value= '' WHERE empID=cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#session.ID# /cfquery How do I actually set the attribute value to null in coldfusion. Thanks, Priya ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322027 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT - Purchasing .bm domain names
I'm building a site for a charity in Bermuda and I've told them a great .bm domain name is available. Can anyone recommend a place to buy such domain names. I've done all my purchases through 123-reg.co.uk up until now. I've sent an email to bermudanic.bm but have not heard back from them yet. I'm mainly wondering about price. Thanks and sorry for the OT. Adrian ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321957 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT - Purchasing .bm domain names
You know after nine years doing this web stuff, that never occurred to me! I've done that, I've seen prices over $200. Short of hearing back from bermudanic.bm, I was hoping someone out there would know of a place that has them cheaper or if that's the going rate for one. My fault for not stating this in the first email I suppose... Adrian -Original Message- From: Ravi Gehlot [mailto:r...@ravigehlot.net] Sent: 26 April 2009 14:03 To: cf-talk Subject: Re: OT - Purchasing .bm domain names Adrian, Try a search on Google. Ravi. Adrian Lynch wrote: I'm building a site for a charity in Bermuda and I've told them a great .bm domain name is available. Can anyone recommend a place to buy such domain names. I've done all my purchases through 123-reg.co.uk up until now. I've sent an email to bermudanic.bm but have not heard back from them yet. I'm mainly wondering about price. Thanks and sorry for the OT. Adrian ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321959 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT - Purchasing .bm domain names
Thanks Ravi, I'd seen that site already, $350 for a year seems a bit much. Maybe that's the going rate though. Adrian -Original Message- From: Ravi Gehlot [mailto:r...@ravigehlot.net] Sent: 26 April 2009 14:40 To: cf-talk Subject: Re: OT - Purchasing .bm domain names http://www.101domains.com/ Adrian Lynch wrote: You know after nine years doing this web stuff, that never occurred to me! I've done that, I've seen prices over $200. Short of hearing back from bermudanic.bm, I was hoping someone out there would know of a place that has them cheaper or if that's the going rate for one. My fault for not stating this in the first email I suppose... Adrian -Original Message- From: Ravi Gehlot [mailto:r...@ravigehlot.net] Sent: 26 April 2009 14:03 To: cf-talk Subject: Re: OT - Purchasing .bm domain names Adrian, Try a search on Google. Ravi. Adrian Lynch wrote: I'm building a site for a charity in Bermuda and I've told them a great .bm domain name is available. Can anyone recommend a place to buy such domain names. I've done all my purchases through 123-reg.co.uk up until now. I've sent an email to bermudanic.bm but have not heard back from them yet. I'm mainly wondering about price. Thanks and sorry for the OT. Adrian ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321961 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT - Purchasing .bm domain names
Oh really? That's interesting because they did quote the price in pounds. I'll get someone in Bermuda to have a look, see if it's cheaper for them. Cheers. Adrian -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: 26 April 2009 14:59 To: cf-talk Subject: Re: OT - Purchasing .bm domain names I'm building a site for a charity in Bermuda and I've told them a great .bm domain name is available. Can anyone recommend a place to buy such domain names. I've done all my purchases through 123-reg.co.uk up until now. I've sent an email to bermudanic.bm but have not heard back from them yet. I'm mainly wondering about price. Thanks and sorry for the OT. I suspect that it'll be easier and cheaper for them to buy the domain name themselves, than for you to do it. Many small countries whose domains are popular with foreigners - often for domain hacks or because they have some unrelated meaning like .tv - have different rates for foreigners than for native citizens. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321964 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 - Purchasing .bm domain names
Cheers, that's all ok because the Bermudian charity will be purchasing it. I had just hoped I could find the best place for them to buy the domain. Adrian -Original Message- From: Ravi Gehlot [mailto:r...@ravigehlot.net] Sent: 26 April 2009 15:03 To: cf-talk Subject: Re: OT - Purchasing .bm domain names Hello Adrian, Registering domains outside of our jurisdiction may not be an easy process. You must be familiar with a countries policy in registering TLDs. For example, in order for someone to register a domain in Brazil, they must have Brazilian documentation and in some instances you may even need to have a company established in Brazil. I am not sure about Bermuda. I am also not sure how 101domains manages to get around and register domains from other countries. I would do a research before proceeding with registration just to make sure that you will have full access to your newly purchased domain in the future. Make sure to read the policies with your registrar and understand what they are doing. Just because you may be able to buy a domain for a different country does NOT mean that you may own all rights to it. Ravi. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321965 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Any JS wizards out there care to lend a hand?
True, but then you can always do $(selector).get(0) or $(selector)[0] to get
back to the DOM.
Not ideal, but very useful.
Adrian
-Original Message-
From: Andy Matthews [mailto:li...@commadelimited.com]
Sent: 24 April 2009 14:32
To: cf-talk
Subject: RE: Any JS wizards out there care to lend a hand?
Problem with that is that getElementByID returns a DOM object, while a
jQuery call returns a jQuery object. Different things.
-Original Message-
From: Cutter (CFRelated) [mailto:cold.fus...@cutterscrossing.com]
Sent: Friday, April 24, 2009 8:11 AM
To: cf-talk
Subject: Re: Any JS wizards out there care to lend a hand?
Don't think you really need a new menu, just convert some of you
functions
to *use* JQuery. Something like:
var el = $('#hb-nav li:first');
Steve Cutter Blades
Adobe Certified Professional
Advanced Macromedia ColdFusion MX 7 Developer
Co-Author of Learning Ext JS
http://www.packtpub.com/learning-ext-js/book
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321931
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Creating a dynamic variable to for storage
cfset VARIABLES[filename#i#] = filename Give that a go. Adrian -Original Message- From: Fawzi Amadu [mailto:abd...@gmail.com] Sent: 22 April 2009 19:35 To: cf-talk Subject: Creating a dynamic variable to for storage I have a loop within which I am trying to create a various variable. My code (below) is replying an error which I believe is due the my syntax being wrong. Please advise on how to construct such variable creation. Code: cfset filename#i# = #filename# Error: Invalid CFML construct found on line 75 at column 34. ColdFusion was looking at the following text: \ TIA ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321839 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFIMAGE - File referencing
Output #ExpandPath('/images/consumer/#Cnsmr_ProductIMAGE#) to see where
you're pointing to, it'll be wrong.
Adrian
-Original Message-
From: Fawzi Amadu [mailto:abd...@gmail.com]
Sent: 20 April 2009 17:43
To: cf-talk
Subject: CFIMAGE - File referencing
I have my images for my project under the webroot folder in the e-dang
folder under the image folder and in the consumer folder i.e.
(wwwroot/e-dang/images/comsumer).
But when I reference the file within my code (below), I realize in the
error report that the path returned by coldfusion is missing the
project folder name. Is this usual or does it mean that I got the
referencing wrong?
Here is a portion of the error report (NOTE - e-dang is missing from
the image path):
An exception occurred while trying to read the image.
File C:\ColdFusion8\wwwroot\images\consumer\DSC_0515_thumb.jpg does not
exist.
The error occurred in C:\ColdFusion8\wwwroot\e-
dang\process_simpleSearchResults.cfm: line 53
Here is the code:
td width=10%!--- creating a resized version of uploaded image of
product. ---
cfimage source=#ExpandPath('/images/consumer/#Cnsmr_ProductIMAGE#'
)# action=resize width=100 height=60 name=resizedImg format=
jpg
cfimage source=#resizedImg# action=writeToBrowser!---img
src=images/consumer/#Cnsmr_ProductIMAGE#---/font/td
td width=90%font size=+2#Cnsmr_ProductDESCRIPTION#
/fontnbsp; font size=+2a
href=showProductDetail.cfm?Cnsmr_ProductID=#URLEncodedFormat(TRIM(Cnsm
r_ProductID))##Cnsmr_ProductMODELNo# /fontnbsp;/a
font size=+2#Cnsmr_ProductMODELYEAR#
/fontnbsp; font size=+2#Cnsmr_ProductPRICE#/fontnbsp; font
size=+2#User_id#/font
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321811
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFIMAGE - for all formats
This one got me too a while ago: http://cferror.org/error.cfm?errorID=1 Adrian -Original Message- From: Fawzi Amadu [mailto:abd...@gmail.com] Sent: 17 April 2009 12:26 To: cf-talk Subject: CFIMAGE - for all formats Hi, I am trying to resize images with CFIMAGE but when I process my code, I keep getting an error that: The images/consumer/ image format is not supported on this operating system. Initially I left the format attribute out and got the same error with a suggestion that I try using GetReadableImageFormats(), but this hasn't resolved the problem. How can I resolve this problem, TIA Here's the code: The error occurred in C:\ColdFusion8\wwwroot\e- Ghana\process_simpleSearchResults.cfm: line 45 43 : 44 : td width=10%!--- creating a resized version of uploaded image of product. --- 45 : cfimage source=images/consumer/#Cnsmr_ProductIMAGE# action=resize width=100 height=60 name=resizedImg format= GetReadableImageFormats() 46 : cfimage source=#resizedImg# action=writeToBrowser!---img src=images/consumer/#Cnsmr_ProductIMAGE#---/font/td 47 : td width=90%font size=+2#Cnsmr_ProductDESCRIPTION# /fontnbsp; font size=+2a href=showProductDetail.cfm?Cnsmr_ProductID=#URLEncodedFormat(TRIM(Cnsm r_ProductID))##Cnsmr_ProductMODELNo# /fontnbsp;/a ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321719 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 x words not x characters
Treat the string as a list with any chars you see fit to be word delimiters, so spaces, tabs, full stops etc, then extract N elements from the left of the list. Adrian -Original Message- From: Glyn Jackson [mailto:glyn.jack...@newebia.co.uk] Sent: 15 April 2009 17:02 To: cf-talk Subject: show x words not x characters Ho every one, bit of a simple question, my website shows a snippet of text using the 'left(myvar,30)' function in ColdFusion. however this some times cuts off words mid flow, is there a function in CF that shows x words and not x characters? thanks in advance ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321621 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: how to handle in-appropriate image uploads
It's scary what they're doing with images now! http://www.ted.com/index.php/talks/blaise_aguera_y_arcas_demos_photosynth.ht ml Adrian -Original Message- From: Ian Skinner [mailto:h...@ilsweb.com] Sent: 09 April 2009 17:59 To: cf-talk Subject: Re: how to handle in-appropriate image uploads Chad Gray wrote: Hello, How do big web sites like myspace police image uploads? Staff reviews and approves images or users review and approve images or both. Computers can not tell much about images yet, though they are beginning to get better. I've been thinking I might play with some of the face recognition stuff I've heard about recent when I have some free time. Yeah free time, um what does that feel like again? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321484 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: simple RegEx?
Check the stackoverflow in this result: http://www.google.co.uk/search?hl=enq=find+roman+numerals+regexbtnG=Search meta= Adrian -Original Message- From: CF Developer [mailto:coldfus...@mindkeeper.net] Sent: 02 April 2009 13:00 To: cf-talk Subject: simple RegEx? This should be simple for all you RegEx Gurus. I have a textarea field that may contain list numbers such as : (i) (ii). What I want to do is convert those to LI statements. I know you have to escape the parathesis but it produces: LIi) and LIii) How can I change it just to an LI statement (regardless on the list number, since it can be i, ii, iii, iv) I tried: rereplace(myTextField,'\(*\)','ALL') TIA! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321215 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Button to support both IE and Firefox
Try adding a 'return false' to the onclick. Adrian -Original Message- From: Don L [mailto:do...@yahoo.com] Sent: 01 April 2009 18:25 To: cf-talk Subject: Re: Button to support both IE and Firefox Yeah, you all, good catch on width= instead of width: also, there's a semicolon for the onclick event, still to no avail. hmmm... thks. I missed that but yes, width= should be width:. Here's the code that it should be: input type=button style=background-color:#HEXVAL;width:150px; onclick=window.location='http://xyz.com/somefile.zip'; value= Download the File HEXVAL should be the actual Hex value of the lightgreen color that you are looking for. input type=button style=background-color:lightgreen;width=150 onclick=location.href='http://xyz.com/somefile.zip'; value= Download the File two things I can see ... Should width= not be width: ? Does onclick need the semicolon ; ? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321186 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Cfform upload - Form Field contains no file
Take the cfoutputs out of the cfinput tag. Adrian -Original Message- From: Fawzi Amadu [mailto:abd...@gmail.com] Sent: 31 March 2009 16:54 To: cf-talk Subject: Cfform upload - Form Field contains no file My code is throwing an error the baffles me. With the code below, when I select the files I need to be uploaded, the server returns an error that says that the field contained no file, while I had been able to select a file for that field. What is wrong with my code: cfform action=uploadExtraConsumerProductImages.cfm enctype=multipart/form-data method=post cfloop index=i from=1 to=#Session.numberoffields# step=1 cfset filename = #Session.ExtraProductImgName# #i# !--- Set the respective file name for the uploaded image --- cfinput type=File name=cfoutput#variables.filename#/cfoutput /br / /cfloop cfinput type=Submit name=upload value=upload / /cfform ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321120 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: scopes
I'm not sure if you're saying it works or doesn't work. If it doesn't, try FORM.putAll(URL) or StructAppend(FORM, URL) to get the URL vars into the FORM scope. Adrian -Original Message- From: Brian Dumbledore [mailto:psteja2...@yahoo.com] Sent: 25 March 2009 16:31 To: cf-talk Subject: scopes ok I was trying something and did this: cfif isdefined(url.username) cfset form = duplicate(url) /cfif And then I go about the rest as if the request came from a form post (I use form dot notation everywhere afterwards). When I did a cfdump var=#form# it doesn't recognize the form scope, but this works cfdump var=#variables.form# But every where else in the code it works fine (recorgnizes all form dot names that were originally sent as url parameters) So is cf not supposed to handle the dump 'logically'? Can someone please reason this behavior? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320940 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Create a thumbnail image from .flv video file once uploaded
Not with ColdFusion, but you can use ffmpeg. Railo might also do it as it uses ffmpeg. Adrian -Original Message- From: Riaan Venter [mailto:riven1...@gmail.com] Sent: 24 March 2009 16:48 To: cf-talk Subject: Create a thumbnail image from .flv video file once uploaded Hi Is it possible to use CF8 to create a thumbnail image when uploading a .flv video? How would I go about doing this? Thanks Riaan ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320855 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: String to List?
Ermm, no, I thought they looked like eyes! :OD -Original Message- From: Dawson, Michael [mailto:m...@evansville.edu] Sent: 20 March 2009 13:31 To: cf-talk Subject: RE: String to List? Are you referring to the ASCII breasts? Thanks, Mike -Original Message- From: Adrian Lynch [mailto:cont...@adrianlynch.co.uk] Sent: Thursday, March 19, 2009 6:20 PM To: cf-talk Subject: RE: String to List? You've gotta love this bit of code: REreplace(arguments.strInputString,(.)(.),\1#arguments.strDelimiter# \ 2#ar guments.strDelimiter#,ALL) lol Oh come on, that's funny! :OD Adrian ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320761 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: refresh session in ajax application
Is that method in the same application the rest of your code? It might be that you're calling code that's running in another app? Adrian -Original Message- From: Richard White [mailto:rich...@j7is.co.uk] Sent: 20 March 2009 14:25 To: cf-talk Subject: refresh session in ajax application Hi, we have an ajax application and to refresh the session we make a remote call to the following function on the server, which simply returns true: cffunction name=refreshSession access=remote output=false returntype=boolean hint=is just called to reset session cfreturn true/ /cffunction we are having intermittent problems where sometimes the server session timeouts out even though we make a call to this function, indicating it is not being refreshed correctly. would the function above actually keep the session alive? if not what should we be doing? thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320763 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Re: How is this done without evaluate()?
Another way is to write them to a file and cfinclude it. But in this case I think Evaluate might look nicer... Adrian -Original Message- From: dsbr...@gmail.com [mailto:dsbr...@gmail.com] Sent: 20 March 2009 15:37 To: cf-talk Subject: Re: Re: How is this done without evaluate()? The one time I know we have to use it is because we have some database tables where some fields actually have CF expressions in them, so to have those expressions get, errr, evaluated, we have to use evaluate(). On Mar 19, 2009 8:10pm, Dave Watts dwa...@figleaf.com wrote: In general, evaluating strings as expressions is computationally expensive. I can't think of any cases where I've had to use it in quite a while, but I suspect there are some rare cases where you can't get what you need any other way. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320768 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Suppress whitespace in CFC
Set output=false in both the cfcomponent and cffunction tags. See if that
makes a difference.
Adrian
-Original Message-
From: John M Bliss [mailto:bliss.j...@gmail.com]
Sent: 19 March 2009 15:22
To: cf-talk
Subject: Suppress whitespace in CFC
I've written a CFC responsible for returning data to cfgrid
format=html
bind=cfc:MyCFC.getStuff({cfgridpage},{cfgridpagesize},{cfgridsortcolum
n},{cfgridsortdirection})
I'm experiencing a strange error and, when I call
http://localhost/.../MyCFC.cfc?method=getStuffreturnFormat=json;...
the
actual JSON starts on line 39,439! The error I'm getting from cfgrid
is a
JS alert-style popup that reads, The page at http://localhost says:
CFGRID:
Response is empty
My theory is that, if I can make the JSON start on line 1, this error
will
go away but I'm not sure how to suppress the whitespace appearing above
the
JSON. (Frankly, I'm not even sure where it's coming from.) I've tried
cfsetting enableCFoutputOnly=yes, cfprocessingdirective
suppressWhiteSpace=yes, and cfsilent and none seems to affect the
amount
of whitespace at all.
Ideas?
--
John Bliss
IT Professional
LinkedIn: http://www.linkedin.com/in/jbliss
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320698
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Suppress whitespace in CFC
Oh and in your Application.cfc too if there's any more whitespace.
Adrian
-Original Message-
From: Adrian Lynch [mailto:cont...@adrianlynch.co.uk]
Sent: 19 March 2009 15:30
To: cf-talk
Subject: RE: Suppress whitespace in CFC
Set output=false in both the cfcomponent and cffunction tags. See if
that
makes a difference.
Adrian
-Original Message-
From: John M Bliss [mailto:bliss.j...@gmail.com]
Sent: 19 March 2009 15:22
To: cf-talk
Subject: Suppress whitespace in CFC
I've written a CFC responsible for returning data to cfgrid
format=html
bind=cfc:MyCFC.getStuff({cfgridpage},{cfgridpagesize},{cfgridsortcolum
n},{cfgridsortdirection})
I'm experiencing a strange error and, when I call
http://localhost/.../MyCFC.cfc?method=getStuffreturnFormat=json;...
the
actual JSON starts on line 39,439! The error I'm getting from cfgrid
is a
JS alert-style popup that reads, The page at http://localhost says:
CFGRID:
Response is empty
My theory is that, if I can make the JSON start on line 1, this error
will
go away but I'm not sure how to suppress the whitespace appearing
above
the
JSON. (Frankly, I'm not even sure where it's coming from.) I've
tried
cfsetting enableCFoutputOnly=yes, cfprocessingdirective
suppressWhiteSpace=yes, and cfsilent and none seems to affect the
amount
of whitespace at all.
Ideas?
--
John Bliss
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320699
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: String to List?
Dip into Java first maybe then back to CF? cfset str = abcdefg cfset arr = str.split() cfdump var=#arr# !--- cfset ArrayDeleteAt(arr, 1) --- cfset str = ArrayToList(arr, ,) cfdump var=#str# Note the the first element in the array is an empty string. I thought ArrayDeleteAt() would take care of that but it throws an error. I'd be interested to see if you find nice one or two line answer to this. Adrian -Original Message- From: Christophe Maso [mailto:zum...@hotmail.com] Sent: 19 March 2009 21:31 To: cf-talk Subject: String to List? Disclaimer - I haven't had to do any fancy string manipulation in a while... I had thought that ANY string can be treated like a list (for example, such that abcdef can be treated as a list containing six elements and a delimiter of ). Not so, I recently discovered when I tried to use listChangeDelims(abcdef, ,, ). I wanted to input abcdef and get a,b,c,d,e,f returned, but CF doesn't recognize an empty value as a valid delimiter for any of its list functions...and it doesn't accept an empty value as the second argument in replace(), either. So I wrote a function that'll do what I want, taking a string and the desired delimiter as arguments, then looping through each character in the string and inserting the delimiter after it (except for the last character in the string). But as one might imagine, it's SLOW for very long strings. String and list manipulation is kid stuff, or so I'd thought...surely there's a faster, simpler means? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320716 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: String to List?
I knew there'd be something in Java! -Original Message- From: Dominic Watson [mailto:watson.domi...@googlemail.com] Sent: 19 March 2009 22:03 To: cf-talk Subject: Re: String to List? This also does it quite nicely: cfset list = ArrayToList( myString.toCharArray() ) / Dominic ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320729 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: String to List?
You've gotta love this bit of code: REreplace(arguments.strInputString,(.)(.),\1#arguments.strDelimiter#\2#ar guments.strDelimiter#,ALL) lol Oh come on, that's funny! :OD Adrian -Original Message- From: Christophe Maso [mailto:zum...@hotmail.com] Sent: 19 March 2009 23:37 To: cf-talk Subject: Re: String to List? Thanks all! Good stuff all around...really must get myself locked onto regex one of these days :). I came up with this: cffunction name=stringToDelimListRE access=public returnType=string output=false hint=Takes a string argument and inserts the second argument between each character. Using reg ex, is much, much faster than the original looping function. cfargument name=strInputString type=string required=yes cfargument name=strDelimiter type=string required=no default=, cfset var strNewList = !--- account for empty string as input string --- cfif arguments.strInputString EQ cfreturn /cfif !--- account for empty value of strDelimiter --- cfif not len(arguments.strDelimiter) cfset arguments.strDelimiter=, /cfif cfset strNewList=REreplace(arguments.strInputString,(.)(.),\1#arguments.st rDelimiter#\2#arguments.strDelimiter#,ALL) !--- Get rid of 'hanging' delimiter at end of list --- cfset strNewList=mid(strNewList,1,len(strNewList)-1) cfreturn strNewList /cffunction ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320735 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 8 Certification
Ben said he's not doing a CF8 version of the book. 9 will be the next one. Adrian -Original Message- From: N K [mailto:neetukais...@gmail.com] Sent: 17 March 2009 20:13 To: cf-talk Subject: ColdFusion 8 Certification Hi All, It would be helpful if you all could give some advice/suggestions as I am planning to give my Adobe CF8 certification exam.Benforta Book for CF8 certification exam is still not out. -study material would be required NK ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320619 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 and performance, whats the impact on the server?
It's got to depend on what's going on in them surely? Adrian -Original Message- From: Glyn Jackson [mailto:glyn.jack...@newebia.co.uk] Sent: 18 March 2009 11:46 To: cf-talk Subject: scheduled tasks and performance, whats the impact on the server? A quick question re scheduled tasks and performance/load on the server. My server is NOT running slow however what worries me is how many scheduled tasks I can see in the administrator (25 of them). At what point does this become a problem or am I fussing over nothing? Many Thanks :) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320627 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Images/Videos of exact size
I need to test out an uploader, specifically the size limitations. I've made text files of the exact sizes needed but I was wondering about doing the same with images. Does anyone know how I can create JPGs and/or MPGs/AVIs/MOVs of a specific size? I'm guessing I need to take one and pad it with data, but I'm uncertain how. Any pointers? Adrian ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320635 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Images/Videos of exact size
Sorry, should have clarified, file size rather than dimensions. Ta. Adrian -Original Message- From: Adrian Lynch [mailto:cont...@adrianlynch.co.uk] Sent: 18 March 2009 13:01 To: cf-talk Subject: Images/Videos of exact size I need to test out an uploader, specifically the size limitations. I've made text files of the exact sizes needed but I was wondering about doing the same with images. Does anyone know how I can create JPGs and/or MPGs/AVIs/MOVs of a specific size? I'm guessing I need to take one and pad it with data, but I'm uncertain how. Any pointers? Adrian ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320636 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Eliminating repeated data in CFoutput field
Order your query by eName then do something like this: cfoutput query=yourQuery group=eName #yourQuery.eName# cfoutput #yourQuery.aTitle# #yourQuery.cCategory# /cfoutput /cfoutput You'll need to tweak it to fit in your table layout mind. Adrian -Original Message- From: BobSharp [mailto:bobsh...@ntlworld.com] Sent: 18 March 2009 22:45 To: cf-talk Subject: Eliminating repeated data in CFoutput field rom this output, I would like to eliminate repeated names eName aTitle cCategory Doug Briggs HP Omni 510Notebook PC Nick Heap IBM Netfinity Server Desktop PC Nick Heap HP Omni 510Notebook PC Nick Heap Motorola T60Mobile Phone Audrey Ibbotson Toshiba Satelite XL Notebook PC Karen Kear Viglen 733 Desktop PC Karen Kear HP Omni 510 Notebook PC Office Manager HP LaserJet XLLaser Printer Office Manager Epson Phaser Laser Printer Glyn Martin Toshiba Tecra 8000Notebook PC Glyn Martin Nokia 7650 Mobile Phone Bluetooth I am trying to use a variable LastEmp and CFif CFset but the output is just the same as the original. My script is ... table tr th Name /th th Asset /th th Category /th /tr tr CFoutput query=qEmpAssets CFif VARIABLES.LastEmp IS eName CFset eName = ' ' CFelse CFset VARIABLES.LastEmp = eName /CFif td #eName# /td td #aTitle# /td td #cCategory# /td /CFoutput /tr /table Am in anyway close to achieving it ? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320680 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Time-our on compute intensice page
Put cfsetting requesttimeout=number of seconds here in your page. Adrian -Original Message- From: Ron Gruner [mailto:webmas...@gruner.com] Sent: 17 March 2009 10:50 To: cf-talk Subject: Time-our on compute intensice page I'm executing a compute-intensive page that has 500 iterations which generates an exceeded allowable time limit error after 30 seconds or so. The page needs to run 500 seconds to finish. I tried executing one iteration and then having the page call itself using cflocation but that errors out after 10 iterations, I assume to block infinite loops. So, how do I execute 500 iterations of a routine taking about one second each? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320566 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Sort database records as a human not a computer.
If you'd like to keep things simple, create a new column and enter the title as you'd like it to be ordered by. Would love to hear if someone has an idea about this also. Adrian -Original Message- From: Ian Skinner [mailto:h...@ilsweb.com] Sent: 16 March 2009 14:27 To: cf-talk Subject: Sort database records as a human not a computer. With SQLServer (2000 I believe) if that matters, which it may well. I have a data column that contains titles. I desire the titles to be sorted alphabetically as a human would not a computer. The records I'm currently concerned with start with a quote () and need to start with a quote. Ideally I would like the records sorted with these records placed in order by the first letter inside the quotes like a human librarian would not to the top of the list as a computer does it. Since I'm wishing for this, it would be really cool if the sort also ignored the other human librarian no goes 'a', 'an' and 'the' that are supposed to be ignored at the beginning of titles when sorting. Luckily this is a very minor requirement and can be ignored if there is not is not a simple solution out there, but I also can't believe I am the first programmer that needed to do this with database data, so maybe the functionality already exists. TIA Ian ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320532 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Anybody have exerience with KickAssVPS.com?
Doing any PDF or image creation/manipulation? If so how are you finding it for speed? Adrian -Original Message- From: Rick Faircloth [mailto:r...@whitestonemedia.com] Sent: 16 March 2009 16:04 To: cf-talk Subject: RE: Anybody have exerience with KickAssVPS.com? I've kinda lost track of who I'm responding to...did you just reply to this to get the topic back in the loop, Mike? I didn't see any comments by you below. I assume that means you're just re-asking the question does anyone have any experience with KickAssVPS.com. If so, I've had about 9 months experience with them now and not a single problem at all...not billing issues, no server downtime (that wasn't announced...and a good thing is that when a planned upgrade didn't go smoothly, instead of continuing to keep the system down while they tried to work out the issue, the downgraded and got the system back up immediately), no server problems at all. Nice support staff. Worked with me to get a special configuration of services I wanted included and some I didn't want taken out of the configuration...and adjust the price accordingly to make it a good deal. Check out their offerings and don't hesitate to request changes to the stock configurations. Also, they were running a 2GB Mem special for the price of one when I got my server, which helps. But I've never had any slow server issues. And except for initial software setup and configuration, I've never even had to reboot the server! Smooth as silk. Can't recommend them highly enough! I have no vested interest, just a very satisfied customer. I tried at least two other companies before trying KickAssVPS.com and have never looked back. As far as I remember, with remoting into the server: - Win 2003 Server - Running MySQL 5 - ColdFusion 8 - Plesk was part of the pack, but I don't allow customer access to the server, so I had it uninstalled - MSSQL is available, but I don't use it I can't think of anything else, but I'm completely satisfied. Feel free to ask about more specifics if you need them. Rick PS - and from Jochems remarks awhile back, you do just get a slice of a quad-core Pentium, but that beats a slice of a Pentium 4! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320541 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Thinking of a career change.. how does one get into Technical Recruiting..
Seems we all have similar experiences. Would love to hear what a recruiter has to say! Adrian -Original Message- From: Scott Stewart [mailto:sstwebwo...@bellsouth.net] Sent: 12 March 2009 19:36 To: cf-jobs-talk Subject: Thinking of a career change.. how does one get into Technical Recruiting.. Hey all, Since there's a large number of recruiters on this list, I've been wondering. How does one break into technical recruiting? I've got years of experience as a ColdFusion developer, but it appears that the CF market in NC has dried up. So I'm entertaining the idea of moving into recruiting, but have no idea where to start. Thanks in advance for any replies sas -- Scott Stewart ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-jobs-talk/message.cfm/messageid:4193 Subscription: http://www.houseoffusion.com/groups/cf-jobs-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
RE: IOException while sending message
Permissions have changed? Run out of disk space? Adrian -Original Message- From: Richard White [mailto:rich...@j7is.co.uk] Sent: 12 March 2009 13:26 To: cf-talk Subject: IOException while sending message hi our cf emails were getting sent fine but they are now they are not getting sent and the logs are showing the following error: IOException while sending message we have tried restarting the server does anyone have any ideas on what may have caused this thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320432 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 *exactly* does cgi.server_name return.
calpip-devsite/index.cfmcalpip-devsite calpip.cdpr.ca.gov/index.cfmcalpip.cdpr.ca.gov calpip-devsite.inisde.cdpr.ca.gov/index.cfm calpip-devsite.inisde.cdpr.ca.gov 10.104.106.113/index.cfm10.104.106.113 134.186.118.90/index.cfm/ 134.186.118.90 But, I did read somewhere that depending on your set up, either SERVER_NAME or the other one that looks like it returns the same thing can include the port. Google for something like difference between SERVER_NAME and [some other CGI var that I can't remember] and you'll come across a post or two that explains what it returns. Or not :OD Adrian -Original Message- From: Ian Skinner [mailto:h...@ilsweb.com] Sent: 12 March 2009 17:20 To: cf-talk Subject: What *exactly* does cgi.server_name return. I think I can get the answer faster from this helpful and generous group of people then I can write one line of code and try it out on a wide variety of environments. What exactly is cgi.server_name expected to return? Looking at the following examples what would you expect to be in this variable? http://calpip-devsite/index.cfm http://calpip.cdpr.ca.gov/index.cfm http://calpip-devsite.inisde.cdpr.ca.gov/index.cfm http://10.104.106.113/index.cfm http://134.186.118.90/index.cfm/ TIA Ian ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320462 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
