ColdFusion Mailing list
All, I am in search of a prebuilt mailing list application. Here are the requirements. * Announce only type of emails (only one or two people can send to the list). * 400 or fewer recepients (probably less than 200). * Has to be ColdFusion (I can't install software because it's a hosted site). It can do more but that is what I need. Any ideas/suggestions? Thanks, Steve ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303006 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfdocument on cf8 and unix/linux
The problem here is most likely permissions. Check to see that whatever user you're running ColdFusion as has write permissions to the tempfiles/ directory you indicate in your code. Usually your CF server will be running as nobody or apache, but it's specific to how it was installed on your system. Check with the person who installed it if you're unsure. Selecting the user to run as is part of the installation process. Jordan - thanks for your help. Unfortunately, this isn't it, however. We confirmed which user ColdFusion was running under and gave that user write permission to the tempfiles/ directory. That didn't help any. Then, we gave ALL access to EVERYONE (drwxrwxrwx). Do you (or anyone else) have any other ideas why this might be happening? Thanks! Dave ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303007 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFMX 8 and Oracle RAC database
I ma not sure if it has changed in CF8, but this is what our CF702 connect string looks like jdbc:macromedia:oracle://mustang-vip:1522;serviceName=iprod;alternateServers=(cougar-vip:1522);loadBalancing=true This seems to be doing the trick. On Wed, Apr 9, 2008 at 2:43 AM, Alex DeMarco [EMAIL PROTECTED] wrote: Using this type of connect string: jdbc:oracle:thin:@(description=(address_list= (LOAD_BALANCE=ON) (address=(host=server1) (protocol=tcp)(port=1521))(address=(host=server2)(protocol=tcp) (port=1521)))(connect_data=(service_name= servicename))) What should be the expected behavior? When a node in the cluster comes down should the CFMX throw and error or automatically switch to the other node? We are doing some testing and when a node comes down we get a cfquery error. However, wait a minute and hit refresh and the page continues to work.. Is this the correct behavior? I guess I was expecting a slight delay in response time while cfmx tried the other node... Am I off base here? Or is there something else I am missing? thanks! - Alex ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303004 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: turn integer list into list of characters
I don't think it matters because it will convert a number to a string. If you use cfqueryparam for the variable in your query, then that will ensure a proper conversion. Eric /*-Original Message- /*From: erik tom [mailto:[EMAIL PROTECTED] /*Sent: Wednesday, March 26, 2008 11:24 AM /*To: CF-Talk /*Subject: turn integer list into list of characters /* /*I have a query that returns the EmployeeiD, on the other table i have /*column employeeId which is varchar datatype. so my question is how can I /*convert integer list into char list so it looks like this /* /*cfste list='1233','12333','333' and so on /* /* ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303002 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: autosuggest and 508 Compliance
Matt, I stand corrected, and I appreciate the information. It's great to know that these technologies have progressed so much. In the space I work within we don't deal with 508 compliance, and it's been several years (though not quite THAT far back) since I personally had to look at it with any depth. You've put me straight, as I was 'parroting' the comments of other threads I've read in the past on various web development forums, and similar outdated articles on the topic. I'm happy to be wrong. Sorry for propagating the myth. Thanks again for the information. Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com Matt Morgan-May wrote: On 4/8/08 2:00 PM, cf-talk cf-talk@houseoffusion.com wrote: From: Cutter (CFRelated) I'm not positive, but I would think you're out of luck with any of the assistives, with regards to Ajax. Most assistives won't even run JavaScript at all (or very limited). Look at the developer plugin category of Firefox plugins. I seem to remember several emulators that might help you 'view' your work the way these browsers might. This is not the case anymore. A number of Ajax toolkits, including Dojo, YUI, and jQuery (plus our own toolkit, Spry), are implementing the WAI-ARIA specification, which helps make Ajax directly accessible. Microsoft, Mozilla and Opera are building support for it in their browsers, and the two top screen readers are implementing it as well. Statements like Most assistives won't even run JavaScript at all have not been true for several years. _Every_ modern screen reader has some ability to deal with content manipulated by JavaScript, particularly if the developer is using the DOM to work with the content. This is one of a class of myths that used to be true maybe seven years ago, but aren't anymore. Still, they resurface with mind-numbing regularity. I don't mean to pick on any one commenter here, but when comments like this get parroted thread after thread, year after year, it makes accessibility look like the enemy of new technology, and that's bad for developers as well as users with disabilities. Please don't dismiss things like JavaScript, Ajax, Flash, Flex, or PDF out of hand with regard to disability until you've done some research on your own, and don't believe anyone who tells you (Technology X) is inaccessible without a _very_ comprehensive body of supporting material. And for what it's worth, many of the assistive technology emulators are worthless, to be honest. Especially on web apps. You get more mileage out of downloading the demo versions of JAWS and Window-Eyes, which are free, and give you 30-40 minutes of time to test your stuff out. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303001 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ColdFusion Mailing list
i would have thought that's ab out one of the most basic things you can do with ColdFusion. I have a number of hosted sites i have mailing lists on You have a database and collect names and addresses through a simple form, to let people join and leave hte list. Yo uhave an admin end behind a password where you send the emails to some of all of the list. Use cfmail to send or put the emails into a database and then have a message handler to get batches of messages and send them What's hard about that? Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On Wed, Apr 9, 2008 at 12:41 PM, Steven Durette [EMAIL PROTECTED] wrote: All, I am in search of a prebuilt mailing list application. Here are the requirements. * Announce only type of emails (only one or two people can send to the list). * 400 or fewer recepients (probably less than 200). * Has to be ColdFusion (I can't install software because it's a hosted site). It can do more but that is what I need. Any ideas/suggestions? Thanks, Steve ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303011 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfdocument on cf8 and unix/linux
Dave Phillips wrote: Do you (or anyone else) have any other ideas why this might be happening? Get a stacktrace and see what it is doing. Jochem ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303013 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SOT: Where can I go to find the status of an Adobe bug I submitted?
Andy Matthews wrote: I recently submitted a bug to the AIR team. How do I check the status on that bug? What did it say on the page where you submitted the bug? Jochem ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303014 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 Crash ColdFusion 8 Application Server service terminated with service-specific error 2 (0x2).
jonese wrote: Anyone have a clue WTF this means? I can't find anything in my log files which tell me what is wrong If there is nothing in your *-out.log start CF in an interactive session and check the error. Jochem ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303012 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
QoQ question - left outer join
why cant i do a left outer join in a qoq? FROM getZMA LEFT OUTER JOIN getEQ ON getZMA.Material = getEQ.sap_partnum WHERE (getEQ.sap_partnum IS NULL) tried FROM getZMATMAST, getEQ WHERE (getZMATMAST.Material = getEQ.sap_partnum) AND (getEQ.sap_partnum IS NULL) but that dosnt return what i want how do i write it to work? also i cant do ABS(dbo.riprod_ZMATMAST.Material) AS specs_partnum ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303015 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't use J2EE Datasource with CF8?
Hi Brian, We would need more detailed information on the app. server dsn configuration that you are using in order to be able to reproduce it here at our end. Could you please provide answers to these questions: i. Which app server are you configuring the dsn on? Is it Weblogic? ii. Are you configuring the dsn through the Weblogic Admin-JDBC Datasources? iii. Which driver have you selected in the drivers dropdown? iv. Does the dsn connection get verified for you after configuring it? v. Can you please provide us the exception stack trace? If you want we can take this offline from the forum, you could mail me directly at [EMAIL PROTECTED] from your personal email id. Thanks, Dipanwita Adobe Coldfusion Team Has anyone else run into a problem using J2EE app server data sources/connections pools directly in CF8? In CF 6 and 7, we had created connections pools and datasources on Weblogic 8, and CF could access that datasource (if a CF datasource with the same name existed, it would take precedence). We are in the process of upgrading to CF8, but are getting errors when trying to use J2EE datasources. Connecting to Oracle 10.2. On CF 8.0, we were getting a NullPointerException (I don't have the full stack trace handy). On CF 8.0.1, we are getting a ClassCastException. This was with CF8 J2EE deployed against Weblogic 9.2. We also tried against JBoss with the same result, so the J2EE app server doesn't appear to be the issue. We are in the process of trying out the various hotfixes (1-3) Google was not really helpful, this was the only related issue we could find: http://www.adobe.com/cfusion/webforums/forum/messageview. cfm?forumid=... Any ideas? It seems like something changed in CF8. Thanks, Brian ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303009 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Can't use J2EE Datasource with CF8?
Hi Brian, We would need more detailed information on the app. server dsn configuration that you are using in order to be able to reproduce it here at our end. Could you please provide answers to these questions: i. Which app server are you configuring the dsn on? Is it Weblogic? ii. Are you configuring the dsn through the Weblogic Admin-JDBC Datasources? iii. Which driver have you selected in the drivers dropdown? iv. Does the dsn connection get verified for you after configuring it? v. Can you please provide us the exception stack trace? If you want we can take this offline from the forum, you could mail me directly at [EMAIL PROTECTED] from your personal email id. Thanks, Dipanwita Adobe Coldfusion Team Has anyone else run into a problem using J2EE app server data sources/connections pools directly in CF8? In CF 6 and 7, we had created connections pools and datasources on Weblogic 8, and CF could access that datasource (if a CF datasource with the same name existed, it would take precedence). We are in the process of upgrading to CF8, but are getting errors when trying to use J2EE datasources. Connecting to Oracle 10.2. On CF 8.0, we were getting a NullPointerException (I don't have the full stack trace handy). On CF 8.0.1, we are getting a ClassCastException. This was with CF8 J2EE deployed against Weblogic 9.2. We also tried against JBoss with the same result, so the J2EE app server doesn't appear to be the issue. We are in the process of trying out the various hotfixes (1-3) Google was not really helpful, this was the only related issue we could find: http://www.adobe.com/cfusion/webforums/forum/messageview. cfm?forumid=... Any ideas? It seems like something changed in CF8. Thanks, Brian ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303008 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: QoQ question - left outer join
OUTER JOIN isn't supported. Take a look here: http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=using_reco rdsets_7.html Adrian -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED] Sent: 09 April 2008 12:33 To: CF-Talk Subject: QoQ question - left outer join why cant i do a left outer join in a qoq? FROM getZMA LEFT OUTER JOIN getEQ ON getZMA.Material = getEQ.sap_partnum WHERE (getEQ.sap_partnum IS NULL) tried FROM getZMATMAST, getEQ WHERE (getZMATMAST.Material = getEQ.sap_partnum) AND (getEQ.sap_partnum IS NULL) but that dosnt return what i want how do i write it to work? also i cant do ABS(dbo.riprod_ZMATMAST.Material) AS specs_partnum ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303016 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: turn integer list into list of characters
Also...you can also just put quotes around the variable in the query and that will tell the db that it is a string... Eric /*-Original Message- /*From: erik tom [mailto:[EMAIL PROTECTED] /*Sent: Wednesday, March 26, 2008 11:24 AM /*To: CF-Talk /*Subject: turn integer list into list of characters /* /*I have a query that returns the EmployeeiD, on the other table i have /*column employeeId which is varchar datatype. so my question is how can I /*convert integer list into char list so it looks like this /* /*cfste list='1233','12333','333' and so on /* /* ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303003 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFMX 8 and 10gRAC db cluster
Using this type of connect string: jdbc:oracle:thin:@(description=(address_list= (LOAD_BALANCE=ON) (address=(host=server1) (protocol=tcp)(port=1521))(address=(host=server2)(protocol=tcp) (port=1521)))(connect_data=(service_name= servicename))) What should be the expected behavior? When a node in the cluster comes down should the CFMX throw and error or automatically switch to the other node? We are doing some testing and when a node comes down we get a cfquery error. However, wait a minute and hit refresh and the page continues to work.. Is this the correct behavior? I guess I was expecting a slight delay in response time while cfmx tried the other node... Am I off base here? Or is there something else I am missing? thanks! - Alex ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303005 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 Mailing list
I am in search of a prebuilt mailing list application. We have used http://www.2simplifi.com/ws/page.cfm/pid/1/sid/3 with no problems. It isn't really a mailing list though, may not be what you were looking for. -- Jay ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303010 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
508 Accessability
I have to look into making a site 508 accessible that has a ton of javascript in it (such as hidden div's, etc) Of course, I know someone on here has had to deal with this. Can I get some information on resources, comments on any tool/services used, and any other info I can on 508 accessibility would be great! -Lori ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303017 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 Mailing list
http://emailcampaign.riaforge.org/ On Tue, Apr 8, 2008 at 10:41 PM, Steven Durette [EMAIL PROTECTED] wrote: All, I am in search of a prebuilt mailing list application. Here are the requirements. * Announce only type of emails (only one or two people can send to the list). * 400 or fewer recepients (probably less than 200). * Has to be ColdFusion (I can't install software because it's a hosted site). It can do more but that is what I need. Any ideas/suggestions? Thanks, Steve ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303018 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: QoQ question - left outer join
ok...
wierd, i am only getting one result in my #getEQnum.sap_partnum#
i know there should be 36 results...
cfquery name=getNEQnum dbtype=query
SELECT DISTINCT
getZMA.Material
FROM getZMA, getEQnum
WHERE getZMA.Material NOT IN ('#getEQnum.sap_partnum#')
/cfquery
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303019
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFCs - Rule of thumb when to use
Yeh, I'd go with that. Not overkill at all and good thinking. If you also
have mini app specific checks, you could extend the 'global' cfc too.
And apologies for souding like a patronising git, I misread you as not
having used cfcs in an app before ;)
Lol, didn't take it that way at all. I just didn't want my initial post to be
swamped in detail :-). I've actually been using CFC's for a few years now but
I've been unclear as to if I'm using them in the right way. I appreciate that
these things aren't black and white but I just want to get an opinion on my
approach.
In my head I know that I should be using CFCs as a tool for common/specific
tasks but then I look at the example(s) below and think a) it's overkill and
more code and b) I'm breaking a simple process down into two separate parts
which might not be needed this way anyway!
No CFC approach:
cfif not session.username)
cflocation url=login.cfm addtoken=no /
/cfif
RESULT: Simple, three lines, job donebut no not modular and results in
duplication.
CFC approach (1):
-
// Get CFCs
UserManager = createObject(component,com.userManager).init();
AppManager = createObject(component,com.appManager).init();
// Check that the username exists in a session (returns boolean).
userChecker = IWSCFCManager.getUserName();
// No username. Send them to the login page
if(not userChecker){
appManager.getLogingPage();
}
RESULT: Process is now in two separate areas so good that it's modular and can
be cached but it's more external files to deal with.
or I guess all this could be far more generic.
CFC approach (2) - More generic CFC approach:
-
// Get CFC
AppManager = createObject(component, com.appManager).init();
// Check that the user exists in the session scope using a generic variable
checker. This method takes two parameters, the scope and which variable to look
for. Returns boolean.
userChecker = AppManager.getVariable(session,username);
if(not userChecker){
// This method does a redirect
appManager.redirectUser(login.cfm);
}
RESULT: One CFC and could use this for all kinds of things
then again I could just use a structKeyExists :-)... and oh look!!! I'm
back to another way of coding CFC approach 1 (ARRGGGHHH!!!)
There are many paths but I'm just concerned that I make the wrong one for the
wrong reasons :-)
@Gerald - Thanks for all those links. OO concepts are something I've never used
but I've got a good understanding of how it works in principle. I do aim to
keep everything encaplusated in my CFCS and I'm keen to look at things like
ColdSpring at some point soon. When I get two geeky minutes :-)
Thanks again for the feedback,
James
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303020
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: SOT: Where can I go to find the status of an Adobe bug I submitted?
I don't remember exactly, but I think it was just a thank you for submitting this... -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 09, 2008 5:50 AM To: CF-Talk Subject: Re: SOT: Where can I go to find the status of an Adobe bug I submitted? Andy Matthews wrote: I recently submitted a bug to the AIR team. How do I check the status on that bug? What did it say on the page where you submitted the bug? Jochem ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303021 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfgrid / cfgirdcolumn selectmode=edit checkbox
I want to reiterate that Im not looking for a free snipet of code...I am merely looking for how to work with the data that is selected via checkbox in a cfgrid. How would i pass the selected information (probably based on the uniquie ID in the table) to another page or directly into the DB? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303022 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFCs - Rule of thumb when to use
I'd recommend looking at ColdSpring or Litewire now. These help answer a lot of the questions about how organise and separate the CFCs and how to make them work with each other. On Wed, Apr 9, 2008 at 9:22 PM, James Buckingham [EMAIL PROTECTED] wrote: Yeh, I'd go with that. Not overkill at all and good thinking. If you also have mini app specific checks, you could extend the 'global' cfc too. And apologies for souding like a patronising git, I misread you as not having used cfcs in an app before ;) Lol, didn't take it that way at all. I just didn't want my initial post to be swamped in detail :-). I've actually been using CFC's for a few years now but I've been unclear as to if I'm using them in the right way. I appreciate that these things aren't black and white but I just want to get an opinion on my approach. In my head I know that I should be using CFCs as a tool for common/specific tasks but then I look at the example(s) below and think a) it's overkill and more code and b) I'm breaking a simple process down into two separate parts which might not be needed this way anyway! -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303023 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
update PDF title
I have a db with a bunch of pdf files and titles stored. Apparently the file titles are wrong in metadata for the files but not the db. I have to look at the db and then update the file metadata to what is in the db. Anyone done this before? -Lori ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303024 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: QoQ question - left outer join
found a fix! cfquery name=getNEQnum dbtype=query SELECT getZMA.Material FROM getZMA WHERE (1 = 1 !--- Make sure the current record does NOT match any records in the B query.--- cfloop query=getEQnumAND getZMA.Material '#Material#'/cfloop) from: http://www.bennadel.com/index.cfm?dax=blog:1074.viewcodeindex=1 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303025 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFCs - Rule of thumb when to use
I'd recommend looking at ColdSpring or Litewire now. These help answer a lot of the questions about how organise and separate the CFCs and how to make them work with each other. Thanks James but my question was aimed more at what I should be putting in CFC's rather than how I should organise them. Hence why I was asking about the Rule of thumb. I could do everything in them but I'm wondering if there are scenerios where they're overkill, the example being the one I've mentioned. I saw a presentation on ColdSpring at Scotch on the Rocks last year and I've seen a few more online. I'm still trying to get my head around it all though to be honest. Litewire I've not seen but I'll have a look ;-). ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303026 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: update PDF title
We are using 7 right now. Will possible move to 8 shortly. -Lori -Original Message- From: Stone, Lori Sent: Wednesday, April 09, 2008 9:41 AM To: CF-Talk Subject: update PDF title I have a db with a bunch of pdf files and titles stored. Apparently the file titles are wrong in metadata for the files but not the db. I have to look at the db and then update the file metadata to what is in the db. Anyone done this before? -Lori ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303027 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfgrid and text
I am about ready to give up on CFGrid and switch back to a standard html table. I just can't get it to do what I want. I love the features it automatically provides like sorting, paging data and column re-arranging but it is a little too limiting. Right now I have a long paragraph of text and it gets chopped off in the field. Is there any way to get the text to word-wrap so the row height automatically expands to display all of the type? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303028 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfgrid / cfgirdcolumn selectmode=edit checkbox
If you read through the ExtJS 1.1 documentation you will see that you can apply a RowSelectionModel to a grid. I'm pretty sure you can use this to define single or multi selection, to which you can act upon the selected (DataStore) records, etc. Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com LSD 4Me wrote: I want to reiterate that Im not looking for a free snipet of code...I am merely looking for how to work with the data that is selected via checkbox in a cfgrid. How would i pass the selected information (probably based on the uniquie ID in the table) to another page or directly into the DB? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303029 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
BIG problems with 8.0.1 update
Me again. :) I've had to uninstall CF on three machines and reinstall to get back to the pre-8.0.1 version (with just the pre-existing hotfixes installed). This new update broke a LOT of stuff, and I'm wondering if anybody else has noticed yet. First, there was the YUI-related issue that I posted about yesterday. That was pretty minor. Next, I was working on a script that I've been dinking with for about a month, that goes through a big directory of image files and checks their pixel size and filesize, and alters them accordingly to save space. The first problem I noticed after doing the update was that if there were more than about 70 files in the directory, JRUN would exit with a strange error (I don't recall the specific one). It had worked just fine prior to this (there are some 20,000 files in the directory I'm testing on). So I made a directory with fifty files and continued fine-tuning things. This is when I noticed the next problem. Half of the files (roughly) were coming up not found by the CFImage tag, despite definitely existing. I experimented... was it the ones with spaces in their names? Nope. Was it the ones that were uppercase? Nope. Lowercase? Nope. I could find no rhyme or reason as to why this was happening. It also happened on another site that I run (on another server, which also had the update) -- a message forum that I wrote. People who were uploading photos to their profiles were suddenly unable to do so. I saw lots of errors thrown due to file not found when the file clearly was there. Finally I figured the best move was to roll back to pre-8.0.1. So I uninstalled/reinstalled since Adobe didn't give us an Uninstall option. Since that time, everything has gone back to normal and is working just fine. Oh, I did go through the release notes very carefully to see if there was anything mentioned that might tell why these problems started, but there was nothing. So as of right now I'm advising everybody I know to NOT apply the 8.0.1 update. Rob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303030 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: BIG problems with 8.0.1 update
Rob, Just out of curiosity, were these fresh, ground-up installs, or did you install 8.0.1 on top of your existing copy of 8? Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com RobG wrote: Me again. :) I've had to uninstall CF on three machines and reinstall to get back to the pre-8.0.1 version (with just the pre-existing hotfixes installed). This new update broke a LOT of stuff, and I'm wondering if anybody else has noticed yet. First, there was the YUI-related issue that I posted about yesterday. That was pretty minor. Next, I was working on a script that I've been dinking with for about a month, that goes through a big directory of image files and checks their pixel size and filesize, and alters them accordingly to save space. The first problem I noticed after doing the update was that if there were more than about 70 files in the directory, JRUN would exit with a strange error (I don't recall the specific one). It had worked just fine prior to this (there are some 20,000 files in the directory I'm testing on). So I made a directory with fifty files and continued fine-tuning things. This is when I noticed the next problem. Half of the files (roughly) were coming up not found by the CFImage tag, despite definitely existing. I experimented... was it the ones with spaces in their names? Nope. Was it the ones that were uppercase? Nope. Lowercase? Nope. I could find no rhyme or reason as to why this was happening. It also happened on another site that I run (on another server, which also had the update) -- a message forum that I wrote. People who were uploading photos to their profiles were suddenly unable to do so. I saw lots of errors thrown due to file not found when the file clearly was there. Finally I figured the best move was to roll back to pre-8.0.1. So I uninstalled/reinstalled since Adobe didn't give us an Uninstall option. Since that time, everything has gone back to normal and is working just fine. Oh, I did go through the release notes very carefully to see if there was anything mentioned that might tell why these problems started, but there was nothing. So as of right now I'm advising everybody I know to NOT apply the 8.0.1 update. Rob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303031 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfgrid / cfgirdcolumn selectmode=edit checkbox
Im not using ExtJSim using flash cfgrids that automatically create the JS. Are there coldfusion methods to deal with my issue or is advanced JS the only way? I find it diffuclt to believe the CF doesnt offer any method of manipulating data from cfgrids. (Dont take that the wrong way...i do appreciate any help you can offer.) THANKS! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303032 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 Mailing list
Fair enough Steve. I shouldnt have been quite so high-handed about it either . reading back my response and it was pretty obnoxious. I'm sorry for that. Good luck with it. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On Thu, Apr 10, 2008 at 12:46 AM, DURETTE, STEVEN J (ATTASIAIT) [EMAIL PROTECTED] wrote: Nothing hard about it at all. I'm doing this for a non-profit group. So, I'm trying to keep my coding time down and was looking to see if there was anything already out there that would do this. So, sorry if you thought that I couldn't do it, I just didn't want to re-invent the wheel. Steve ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303034 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: ColdFusion Mailing list
Nothing hard about it at all. I'm doing this for a non-profit group. So, I'm trying to keep my coding time down and was looking to see if there was anything already out there that would do this. So, sorry if you thought that I couldn't do it, I just didn't want to re-invent the wheel. Steve -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 09, 2008 6:21 AM To: CF-Talk Subject: Re: ColdFusion Mailing list i would have thought that's ab out one of the most basic things you can do with ColdFusion. I have a number of hosted sites i have mailing lists on You have a database and collect names and addresses through a simple form, to let people join and leave hte list. Yo uhave an admin end behind a password where you send the emails to some of all of the list. Use cfmail to send or put the emails into a database and then have a message handler to get batches of messages and send them What's hard about that? Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On Wed, Apr 9, 2008 at 12:41 PM, Steven Durette [EMAIL PROTECTED] wrote: All, I am in search of a prebuilt mailing list application. Here are the requirements. * Announce only type of emails (only one or two people can send to the list). * 400 or fewer recepients (probably less than 200). * Has to be ColdFusion (I can't install software because it's a hosted site). It can do more but that is what I need. Any ideas/suggestions? Thanks, Steve ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303033 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Problem outputing The table
In the task I need to output the table which contains people and assosiate with
this poeople courses. If the course is required and has been taken then leave
the cell blank, if the course is required and has not been taken then X, the
rest should be N/A
CFOUTPUT
!--- Report Location Training Report ---
cfset TodayDT = now()
!--- variables for standard Header ---
cfset hdr_RptID = TTIS-ETR
cfset hdr_SysID = TRAINING RECORDS
cfset hdr_RptName = Employee Training Report
!--- end header variables ---
cfparam name = errmsgdefault =
cfparam name = community default = 0
cfinclude template=../includes/coursearray2.cfm
cfquery name=getLocations datasource=#session.dbdsn#
select l.LocationID, l.Name
from #session.dbname#.dbo.Location l
order by l.Name
/cfquery
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
cfset lastLocation =
html
head
titleReport Location Training/title
script language=javascript
function goMenu() {
self.location.replace('#session.menu#');
}
function printpage()
{
window.print()
}
function goProcessAnotherReport() {
self.location.replace('#CGI.SCRIPT_NAME#');
}
function validateForm(){
var estr = ;
if (estr ) {
alert(Please complete the following:\n + estr);
return false;
}else{
document.reportForm.submit();
}
}
/script
link rel=stylesheet href=../css/style.css /
/head
body
div id=hdr_ctr
cfinclude template=../includes/stdHeader.cfm
!--- font color=grayLocation Training Report is a summary report
that .../fontbr ---
/div
cfif not isdefined('submitForm')
div id=reportCopyForm
form action=#CGI.SCRIPT_NAME#?requesttimeout=99500
name=reportForm method=post onSubmit=return doDateCheck(this.cutoffdate);
br
table width=100%
trtd valign=top width=100%
bCommunity:/bbr /
select name=community
option value=0- All Locations
-/option
cfset lastLoc = '***'
cfloop query=getLocations
cfif locationID is not lastLoc
option
value=#locationID##name# - #locationID#/option
cfset lastLoc = locationID
/cfif
/cfloop
/select
br /br /
bSelect a Date:/bbr /
select name=dselected
option value=1Prior 01/01/2008/option
option value=2Post 01/01/2008/option
/select
cfif LEN(errmsg) GT 0
br
font color=redb#errmsg#/b/font
br
cfelse
br br
/cfif
/td/tr
trtd class=tdctr
br /br /
input type=button name=btn_submit
value=Show Report onClick=validateForm();/ input type=button
name=MainMenu value=Main Menu onClick=goMenu(); /
input type=hidden name=submitForm
value=true /
/td/tr
/table
/form
/div
cfelse
cfflush interval=10
!--- Show report progress bar ---
cfinclude template=../Includes/_showProgressBar.cfm
cfset xls_filename = #hdr_RptID##session.empID#.csv
cfset crslist =
cfset listCourse=31,32,33,136,35,36,37,135,38,39,40
cfquery name=getReportdatasource=#session.dbdsn# dbtype=ODBC
Select distinct e.employeeid, e.last_name as empLastName,
e.first_name , e.middle_name,
e.last_name,et.completiondate,et.CourseName,et.CourseId,
tr.TrainingID, tr.courseID, tr.StdTimeFrame,
er.last_name as erLastName, er.first_name as
erFirstName, er.middle_name as erMiddleName,
ea.last_name as eaLastName, ea.first_name as
eaFirstName,
ea.middle_name as eaMiddleName, l.name,
l.locationID, l.state, s.StateID, a.areaID, r.regionID, e.hireDate
from employee e
join employeejobhistory h on
cfform and confirmation cfwindow popup?
All, Does anyone have an example the can post using CFFORM with an onSubmit action so when a user clicks a submit button they get a confirmation cfwindow popup? Is this functionality working good in CF8.0.1? I thought this might be the way to go vs using a standard JavaScript pop-up method. Thanks in advance! -Jim ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303038 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF 8 Crash ColdFusion 8 Application Server service terminated with service-specific error 2 (0x2).
We finally fixed this. Not sure WHY (suspect an almost full HD) but the /runtime/jre/bin/ folder was empty after applying the 8.0.1 update. Just copied the files from an 8.0.0 installation and reran the update. Things appear to be working now but who knows how much longer i'll be able to say that :) jonese On Wed, Apr 9, 2008 at 6:39 AM, Jochem van Dieten [EMAIL PROTECTED] wrote: jonese wrote: Anyone have a clue WTF this means? I can't find anything in my log files which tell me what is wrong If there is nothing in your *-out.log start CF in an interactive session and check the error. Jochem ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303037 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: BIG problems with 8.0.1 update
Cutter (CFRelated) wrote: Rob, Just out of curiosity, were these fresh, ground-up installs, or did you install 8.0.1 on top of your existing copy of 8? These were done with the 8.0.1 updater. Rob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303036 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Problem outputing The table
You've got to help us help you out here: What's the problem? Is there an error, or does it just not display what you expect? Are your querys and QofQs returning the correct data? I'm sure I'm not alone in thinking that there are lots of people on this list that are happy to help, but we need more to go on. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303039 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfchart spacing problem
Step 1: Go to the following URL. http://bradwood.com/chart_screenshot.jpg Step 2: Tell me what I am doing wrong to have that huge gap between the first stacked bar and the last three. Even if I make the chart skinnier, or omit the width attribute all together, the gap still remains in the same proportion. My other problem is that I'm getting my series duplicated. This chart is supposed to be a remake of an Excel chart which shows support calls broken down by month and category where there is a stacked bar for each month showing all the help desk calls of each type. That problem is a bit stickier and I'll probably need to post the code, but I figured we would work on the gap first. Thanks. ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303040 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Problem outputing The table
I do not get any errors It just does not output it correctly . First of it looping throug the users, then it get the completion. I do not know if I am doing it correctly . I am trying outputing row by row, so get employeeId loop throu the courses required and compare that courses to the array of the courses for completion. You've got to help us help you out here: What's the problem? Is there an error, or does it just not display what you expect? Are your querys and QofQs returning the correct data? I'm sure I'm not alone in thinking that there are lots of people on this list that are happy to help, but we need more to go on. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303041 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfgrid / cfgirdcolumn selectmode=edit checkbox
Ok. so ive made some headway. Apparently, the functionality I was looking for was CFGRIDUPDATE. Now Im able to manipulate the values for the checked box to true or false in the table for each specific ID selected. My question now is there functionality to update session variables as opposed to table rows with CFGRIDUPDATE? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303042 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfgrid and text
I actually just saw that someone came up with a hack to solve this. http://www.dwmommy.com/?day=4/5/2008rss=true#blog623 Dan On Wed, Apr 9, 2008 at 10:02 AM, Chad Gray [EMAIL PROTECTED] wrote: I am about ready to give up on CFGrid and switch back to a standard html table. I just can't get it to do what I want. I love the features it automatically provides like sorting, paging data and column re-arranging but it is a little too limiting. Right now I have a long paragraph of text and it gets chopped off in the field. Is there any way to get the text to word-wrap so the row height automatically expands to display all of the type? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303043 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: BIG problems with 8.0.1 update
Cutter (CFRelated) wrote: Rob, Just out of curiosity, were these fresh, ground-up installs, or did you install 8.0.1 on top of your existing copy of 8? These were done with the 8.0.1 updater. Rob Rob, Post the exception details. May be it will help to nail the issue. Is this happening only with cfimage or other stuff as well? I am not into cfimage (not yet). My intranet website is up and running on 801 without any issues. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303044 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Problem outputing The table
erik tom wrote: I do not get any errors It just does not output it correctly . First of it looping throug the users, then it get the completion. I do not know if I am doing it correctly . I am trying outputing row by row, so get employeeId loop throu the courses required and compare that courses to the array of the courses for completion. Step by step. Maybe you have done this, we don't know. cfdump... your queries. Do they contain the data you expect them to contain. Is it organized as you expect it to be organized. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303045 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: QoQ question - left outer join
Hmmm... So you can loop a query within itself? Rick -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 09, 2008 9:41 AM To: CF-Talk Subject: Re: QoQ question - left outer join found a fix! cfquery name=getNEQnum dbtype=query SELECT getZMA.Material FROM getZMA WHERE (1 = 1 !--- Make sure the current record does NOT match any records in the B query.--- cfloop query=getEQnumAND getZMA.Material '#Material#'/cfloop) from: http://www.bennadel.com/index.cfm?dax=blog:1074.viewcodeindex=1 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303047 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: BIG problems with 8.0.1 update
Is there somewhere to find out what the bug is and what exactly causes it? I was about to install 8.1 but I think I'll wait a while longer. Adrian -Original Message- From: Hemant Khandelwal Sent: 09 April 2008 17:12 To: CF-Talk Subject: Re: BIG problems with 8.0.1 update We have identified the bug with cfimgae in CF8.0.1 and are in the process of releasing hotfix. Thanks, Hemant ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303049 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cfgrid and text
Thanks Dan! Works great in firefox, but not IE. I will keep experimenting and see if I can get IE to do it. -Original Message- From: Dan Vega [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 09, 2008 11:49 AM To: CF-Talk Subject: Re: cfgrid and text I actually just saw that someone came up with a hack to solve this. http://www.dwmommy.com/?day=4/5/2008rss=true#blog623 Dan On Wed, Apr 9, 2008 at 10:02 AM, Chad Gray [EMAIL PROTECTED] wrote: I am about ready to give up on CFGrid and switch back to a standard html table. I just can't get it to do what I want. I love the features it automatically provides like sorting, paging data and column re-arranging but it is a little too limiting. Right now I have a long paragraph of text and it gets chopped off in the field. Is there any way to get the text to word-wrap so the row height automatically expands to display all of the type? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303050 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: BIG problems with 8.0.1 update
We have identified the bug with cfimgae in CF8.0.1 and are in the process of releasing hotfix. Thanks, Hemant ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303046 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: QoQ question - left outer join
So you can loop a query within itself? The loop is just generating the QoQ SQL dynamically - once the SQL has been 'generated' and parsed it then gets processed. So, in reality, the query is not looped within itself. Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303048 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Problem outputing The table
erik tom wrote: I do not get any errors It just does not output it correctly . First of it looping throug the users, then it get the completion. I do not know if I am doing it correctly . I am trying outputing row by row, so get employeeId loop throu the courses required and compare that courses to the array of the courses for completion. Step by step. Maybe you have done this, we don't know. cfdump... your queries. Do they contain the data you expect them to contain. Is it organized as you expect it to be organized. I did some cfdump and it seems to be correct . However I noticed that the date is not capturing correctly cfif isDate(QoQInline.completiondate) td valign=top class=tdctr/td cfelse td valign=top class=tdctrX/td /cfif !-- There was no record in the QofQ - so this is not a required course for this EmpID -- cfelse td valign=top class=tdctrN/A/td /cfif if the completion date is NULL then it returns N/a rather than being X. I do not know how incount for that . Here is the sample output ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303052 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: QoQ question - left outer join
So... is just the one variable, Material, of the current loop iteration being used in the where clause? But still... it seems like a limited loop of the query is being used. It seems as if the loop just loops over the one variable value for '#Material#'. The loop seems to be acting as a means of reading the value of '#Material#' for current query row. Would that be accurate? I've just never seen a loop of a query inside the query itself. Then, again, having just moved from CF 4.5 to CF 8, I've never used a QoQ, either! :o) Rick -Original Message- From: Dominic Watson [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 09, 2008 12:20 PM To: CF-Talk Subject: Re: QoQ question - left outer join So you can loop a query within itself? The loop is just generating the QoQ SQL dynamically - once the SQL has been 'generated' and parsed it then gets processed. So, in reality, the query is not looped within itself. Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303051 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cfgrid and text
Cool I found some css for IE to. I had to apply it to the td for some reason
to get it to work. It does screw up the paging arrows also. It is close!
http://msdn2.microsoft.com/en-us/library/ms531186(VS.85).aspx
style type=text/css
div .x-grid-cell-text{white-space:normal;}
td {word-wrap:break-word;width:450px;left:0;}
/style
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 09, 2008 12:29 PM
To: CF-Talk
Subject: RE: cfgrid and text
Thanks Dan! Works great in firefox, but not IE.
I will keep experimenting and see if I can get IE to do it.
-Original Message-
From: Dan Vega [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 09, 2008 11:49 AM
To: CF-Talk
Subject: Re: cfgrid and text
I actually just saw that someone came up with a hack to solve this.
http://www.dwmommy.com/?day=4/5/2008rss=true#blog623
Dan
On Wed, Apr 9, 2008 at 10:02 AM, Chad Gray [EMAIL PROTECTED] wrote:
I am about ready to give up on CFGrid and switch back to a standard html
table. I just can't get it to do what I want. I love the features it
automatically provides like sorting, paging data and column re-arranging but
it is a little too limiting.
Right now I have a long paragraph of text and it gets chopped off in the
field.
Is there any way to get the text to word-wrap so the row height
automatically expands to display all of the type?
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303053
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: BIG problems with 8.0.1 update
David: This is what I was getting: An exception occurred while trying to read the image. File d:\web\docs\\18105\100_0690.JPG does not exist. The error occurred on line 102. It would say that for almost any filename... I never could find a reason why it would do that on some but not all. I don't have the exception info for why it was dying when there were lots of files to process; I've rolled back to 8.0 so I can't rerun to get it again. Hey Hermant... any word on the YUI-related issue I found too? My main concern is that it isn't a bigger issue than it appears. If copying over that /yui/build/calendar folder is all it takes to fix it, that's cool. Rob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303054 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfdocument on cf8 and unix/linux
Yeah, a stack trace would certainly give you better detail. How about parent directories? If the CF user cannot enter one of the parent directories, then it won't be able to write to a sub-directory no matter what the permissions on the subdirectory are. A good way to test this would be to have CF write to the /tmp directory (a directory that everyone can write to), instead of the directory you're using now. If CF can create the file there, then it's almost certainly a permissions issue. If it cannot, then the problem is somewhere else. Hope this helps! Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ Open BlueDragon Steering Committee Adobe Solution Provider Jochem van Dieten wrote: Dave Phillips wrote: Do you (or anyone else) have any other ideas why this might be happening? Get a stacktrace and see what it is doing. Jochem ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303055 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfgridupdate (append) data
Does anybody know how to append data to already existing data in a table? The issue i am having is the information obtained from the gridupdate is replacing the data in the DB. I want the update to append it to the existing data (data1, data2, etc). Is this possible with cfgridupdate? Is it possible with cfupdate? THANKS! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303056 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfgridupdate (append) data
LSD 4Me wrote: Is this possible with cfgridupdate? Is it possible with cfupdate? THANKS! I wouldn't think so. Update' means just that, change (i.e. update) existing data. If you want to add data, then you need to do some type of insert. I.E cfinsert... or write your own insert SQL in a cfquery... tag. You may want to review the documentation concerning the cfgrid... tag and what it returns when complex actions, such as inserting new rows, occur. Here is a highlight. Complex update data (SelectMode = Edit) The grid returns a large amount of data, to inform the action page of inserts, updates or deletes that the user made to the grid. In most cases, you can use the |cfgridupdate| tag to automatically gather the data from the form variables; the tag collects data, writes SQL calls, and updates the data source. If you cannot use |cfgridupdate| (if, for example, you must distribute the returned data to more than one data source), you must write code to read form variables. In this mode, ColdFusion creates the following array variables in the Form scope for each |cfgrid|: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303057 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
spry and cf
I am about to pull my hair out. What am I doing wrong? The page returns with
no errors and the table is empty of data. All I have on the page is the table
headers and no table rows after it.
Firebug says I am returning data:
{COLUMNS:[JOBNUM,EMPLOYEENUM],DATA:[[1049,3010],[1049,3160],[1049,3170],[1049,3170],[1049,3170
],[1049,3170],[1049,3170],[1049,3170],[1049,3170],[1049,3170],[1049,3170],[1049,3170],[1049,3170],[1049
,3170],[1049,3170],[1049,3170],[1049,3170],[1049,3170],[1049,3170],[1049,3170],[1049,3170]]}
script type=text/javascript src=SpryAssets/xpath.js/script
script type=text/javascript src=SpryAssets/SpryData.js/script
script type=text/javascript src=SpryAssets/SpryJSONDataSet.js/script
cfsprydataset name=mydata2 type=json bind=cfc:jobNotes.getSteps()
div spry:region=mydata2
table width=100% border=1
tr
thJob Num/th
thEmployee Num/th
/tr
tr spry:repeat=mydata2
td{mydata2::JOBNUM}/td
td{mydata2::EMPLOYEENUM}/td
/tr
/table
/div
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303058
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfgridupdate (append) data
If you are on CF 8 check this out: http://www.anujgakhar.com/2008/03/18/crud-with-cfgrid-html-format/ Ben Forta has a tute on his blog on using cfgrid to do crud on the fly. On Wed, Apr 9, 2008 at 2:38 PM, Ian Skinner [EMAIL PROTECTED] wrote: LSD 4Me wrote: Is this possible with cfgridupdate? Is it possible with cfupdate? THANKS! I wouldn't think so. Update' means just that, change (i.e. update) existing data. If you want to add data, then you need to do some type of insert. I.E cfinsert... or write your own insert SQL in a cfquery... tag. You may want to review the documentation concerning the cfgrid... tag and what it returns when complex actions, such as inserting new rows, occur. Here is a highlight. Complex update data (SelectMode = Edit) The grid returns a large amount of data, to inform the action page of inserts, updates or deletes that the user made to the grid. In most cases, you can use the |cfgridupdate| tag to automatically gather the data from the form variables; the tag collects data, writes SQL calls, and updates the data source. If you cannot use |cfgridupdate| (if, for example, you must distribute the returned data to more than one data source), you must write code to read form variables. In this mode, ColdFusion creates the following array variables in the Form scope for each |cfgrid|: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303059 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF8 autosuggest automatically filters again?
Problem summary: If you write SQL in the bound autosuggest function like this: WHERE d_name LIKE '%#srch#%' the coldfusion cfinput autosuggest function forces the result to START WITH the search term, where the SQL is looking for containment of the search string. So, for example, my query returns 10 matches, 6 start with the search term and 4 contain the search term but not at the beginning. The cfinput box only lists the 6 that start with the search term. This is actually intended behavior by Coldfusion. p658 of the cf8 developers guide reads: You do not have to limit the returned data to values that match the cfautosuggestvalue contents, because the client-side code displays only the values that match the user input. Why force a filter on the results when we can do it ourselves? Not good. The problem is that is Coldfusion failed to think to pass a parameter to the YUI component AutoComplete. It's defined in /CFIDE/scripts/ajax/yui/autocomplete/autocomplete-min.js. Search for this line: YAHOO.widget.DataSource.prototype.queryMatchContains=false; Change the false to true. That fixes the problem. I'm not sure what other coldfusion functions use this component or what unexpected side effects this change will introduce. However, this change allows the autosuggest feature to to function as it should, where you have the control in your SQL of what results are displayed in the dropdown. If you want the results to start with the search term, then search for WHERE d_name LIKE '#srch#%' You could even return results totally unrelated to the searched term if you wanted to. -Dave ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303060 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Why won't this insert work?
Hi, all... Why won't this insert create a record even when #no_acres# has no value (empty)...? I'm inserting into MySQL 5 and the no_acres column is set to allow null. The code below runs fine if I intercept any insertions where #no_acres# has no length, or rather, is empty. Thanks, Rick Here's the code: cfquery name=get_data datasource=abc select no_acres from smlc_acr_temp /cfquery cfloop query=get_data cfquery name=insert_data datasource=abc insert into smlc_acr (no_acres) values (#no_acres#) /cfquery /cfloop ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303061 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF8 autosuggest automatically filters again?
Hi Dave, I'll look into it for my auto suggest custom tag: http://betterautosuggest.riaforge.org/ Should be possible but will have to wait until later this evening. Dominic On 09/04/2008, Dave Markle [EMAIL PROTECTED] wrote: Problem summary: If you write SQL in the bound autosuggest function like this: WHERE d_name LIKE '%#srch#%' the coldfusion cfinput autosuggest function forces the result to START WITH the search term, where the SQL is looking for containment of the search string. So, for example, my query returns 10 matches, 6 start with the search term and 4 contain the search term but not at the beginning. The cfinput box only lists the 6 that start with the search term. This is actually intended behavior by Coldfusion. p658 of the cf8 developers guide reads: You do not have to limit the returned data to values that match the cfautosuggestvalue contents, because the client-side code displays only the values that match the user input. Why force a filter on the results when we can do it ourselves? Not good. The problem is that is Coldfusion failed to think to pass a parameter to the YUI component AutoComplete. It's defined in /CFIDE/scripts/ajax/yui/autocomplete/autocomplete-min.js. Search for this line: YAHOO.widget.DataSource.prototype.queryMatchContains=false; Change the false to true. That fixes the problem. I'm not sure what other coldfusion functions use this component or what unexpected side effects this change will introduce. However, this change allows the autosuggest feature to to function as it should, where you have the control in your SQL of what results are displayed in the dropdown. If you want the results to start with the search term, then search for WHERE d_name LIKE '#srch#%' You could even return results totally unrelated to the searched term if you wanted to. -Dave ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303062 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Why won't this insert work?
Assuming you have no_acres defined as an INT, when an empty record insert is attempted, it's actually attempting to insert an empty string, not NULL. Because it's trying to enter the empty string, it's going to throw a type error on the string vs numeric mismatch. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303063 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Why won't this insert work?
Try get_data.no_acres -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (919) 874-6229 (home) (703) 220-2835 (cell) -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 09, 2008 3:15 PM To: CF-Talk Subject: Why won't this insert work? Hi, all... Why won't this insert create a record even when #no_acres# has no value (empty)...? I'm inserting into MySQL 5 and the no_acres column is set to allow null. The code below runs fine if I intercept any insertions where #no_acres# has no length, or rather, is empty. Thanks, Rick Here's the code: cfquery name=get_data datasource=abc select no_acres from smlc_acr_temp /cfquery cfloop query=get_data cfquery name=insert_data datasource=abc insert into smlc_acr (no_acres) values (#no_acres#) /cfquery /cfloop ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303064 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Why won't this insert work?
That's exactly why it won't insert - because there is no value your SQL output will look like this (which is invalid): insert into smlc_acr (no_acres) values () Try this instead (not sure it will work with MySQL): insert into smlc_acr (no_acres) values ( cfif Len(Trim(no_acres)) cfqueryparam cfsqltype=cf_sql_integer value=#no_acres# cfelse NULL /cfif) HTH Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303065 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Why won't this insert work?
Thanks, guys... It did need a null value. (It's a decimal datatype). So, Dominic's solution worked! Rick -Original Message- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 09, 2008 3:20 PM To: CF-Talk Subject: RE: Why won't this insert work? Try get_data.no_acres -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (919) 874-6229 (home) (703) 220-2835 (cell) -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 09, 2008 3:15 PM To: CF-Talk Subject: Why won't this insert work? Hi, all... Why won't this insert create a record even when #no_acres# has no value (empty)...? I'm inserting into MySQL 5 and the no_acres column is set to allow null. The code below runs fine if I intercept any insertions where #no_acres# has no length, or rather, is empty. Thanks, Rick Here's the code: cfquery name=get_data datasource=abc select no_acres from smlc_acr_temp /cfquery cfloop query=get_data cfquery name=insert_data datasource=abc insert into smlc_acr (no_acres) values (#no_acres#) /cfquery /cfloop ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303067 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: spry and cf
What is up with this?
If I use cfsprydataset to get the json data, the data starts off with ]
{COLUMNS:[DEPT, etc.
If I use javascript to get the data ie. var mydata = new Spry.Data.JSONDataSet
The page works and the json data starts with ROWCOUNT.
{ROWCOUNT:3,COLUMNS:[DEPT, etc.
Why no ROWCOUNT when using cfsprydataset?
cfsprydataset name=mydata2 type=json bind=cfc:jobNotes.getSteps()
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 09, 2008 2:56 PM
To: CF-Talk
Subject: spry and cf
I am about to pull my hair out. What am I doing wrong? The page returns with
no errors and the table is empty of data. All I have on the page is the table
headers and no table rows after it.
Firebug says I am returning data:
{COLUMNS:[JOBNUM,EMPLOYEENUM],DATA:[[1049,3010],[1049,3160],[1049,3170],[1049,3170],[1049,3170
],[1049,3170],[1049,3170],[1049,3170],[1049,3170],[1049,3170],[1049,3170],[1049,3170],[1049,3170],[1049
,3170],[1049,3170],[1049,3170],[1049,3170],[1049,3170],[1049,3170],[1049,3170],[1049,3170]]}
script type=text/javascript src=SpryAssets/xpath.js/script
script type=text/javascript src=SpryAssets/SpryData.js/script
script type=text/javascript src=SpryAssets/SpryJSONDataSet.js/script
cfsprydataset name=mydata2 type=json bind=cfc:jobNotes.getSteps()
div spry:region=mydata2
table width=100% border=1
tr
thJob Num/th
thEmployee Num/th
/tr
tr spry:repeat=mydata2
td{mydata2::JOBNUM}/td
td{mydata2::EMPLOYEENUM}/td
/tr
/table
/div
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303068
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Why won't this insert work?
On Wed, Apr 9, 2008 at 12:20 PM, Dominic Watson [EMAIL PROTECTED] wrote: the following: cfif Len(Trim(no_acres)) cfqueryparam cfsqltype=cf_sql_integer value=#no_acres# cfelse NULL /cfif can be shortened into: cfqueryparam value=#no_acres# cfsqltype=cf_sql_integer null=#not len(trim(no_acres))# / -- Evelyn the dog, having undergone further modification pondered the significance of short-person behaviour in pedal depressed, pan-chromatic resonance, and other highly ambient domains. Arf, she said. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303066 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Why won't this insert work?
Thanks, Charlie! Rick -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 09, 2008 3:32 PM To: CF-Talk Subject: Re: Why won't this insert work? On Wed, Apr 9, 2008 at 12:20 PM, Dominic Watson [EMAIL PROTECTED] wrote: the following: cfif Len(Trim(no_acres)) cfqueryparam cfsqltype=cf_sql_integer value=#no_acres# cfelse NULL /cfif can be shortened into: cfqueryparam value=#no_acres# cfsqltype=cf_sql_integer null=#not len(trim(no_acres))# / -- Evelyn the dog, having undergone further modification pondered the significance of short-person behaviour in pedal depressed, pan-chromatic resonance, and other highly ambient domains. Arf, she said. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303069 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: QoQ question - left outer join
wouldn't this do the trick?:
WHERE getZMA.Material NOT IN (#quotedvaluelist(getEQnum.sap_partnum)#)
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
Paul Ihrig wrote:
ok...
wierd, i am only getting one result in my #getEQnum.sap_partnum#
i know there should be 36 results...
cfquery name=getNEQnum dbtype=query
SELECT DISTINCT
getZMA.Material
FROM getZMA, getEQnum
WHERE getZMA.Material NOT IN ('#getEQnum.sap_partnum#')
/cfquery
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303070
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: QoQ question - left outer join
The loop seems to be acting as a means of reading the value of '#Material#' for current query row. Would that be accurate? Nope ;). Think of cfquery as a kind of custom cfoutput tag and the outputted content between the tags as plain text. First of all, the cfquery tag evaluates the output between the cfquery tags as a 'query string'. Only THEN does it send that resultant string to the DB server or the QoQ engine to be processed. So, in this case, if there were three records in that 'inner loop', the query string sent to the QoQ engine might look like this: Cfquery code: cfquery name=getNEQnum dbtype=query SELECT getZMA.Material FROM getZMA WHERE (1 = 1 cfloop query=getEQnumAND getZMA.Material '#Material#'/cfloop) /cfquery Resulting query string sent to QoQ 'engine' / Database server: SELECT getZMA.Material FROM getZMA WHERE (1 = 1 AND getZMA.Material 'straw' AND getZMA.Material 'wood' AND getZME.Material 'bricks') Hope that makes sense, Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303071 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Another IDE survey -- Public results this time.
From Jim Priest courtesy of Ray Camden's Soundings Survey App. http://www.thecrumb.com/2008/04/09/the-open-cfml-ide-survey/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303072 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 autosuggest automatically filters again?
This is now incorporated into the betterautosuggest custom tag along with two other properties (case sensitivity and subset matching, i.e. 'abc' matches 'ab', 'abc' and 'bc'. http://betterautosuggest.riaforge.org/ Dominic On 09/04/2008, Dominic Watson [EMAIL PROTECTED] wrote: Hi Dave, I'll look into it for my auto suggest custom tag: http://betterautosuggest.riaforge.org/ Should be possible but will have to wait until later this evening. Dominic On 09/04/2008, Dave Markle [EMAIL PROTECTED] wrote: Problem summary: If you write SQL in the bound autosuggest function like this: WHERE d_name LIKE '%#srch#%' the coldfusion cfinput autosuggest function forces the result to START WITH the search term, where the SQL is looking for containment of the search string. So, for example, my query returns 10 matches, 6 start with the search term and 4 contain the search term but not at the beginning. The cfinput box only lists the 6 that start with the search term. This is actually intended behavior by Coldfusion. p658 of the cf8 developers guide reads: You do not have to limit the returned data to values that match the cfautosuggestvalue contents, because the client-side code displays only the values that match the user input. Why force a filter on the results when we can do it ourselves? Not good. The problem is that is Coldfusion failed to think to pass a parameter to the YUI component AutoComplete. It's defined in /CFIDE/scripts/ajax/yui/autocomplete/autocomplete-min.js. Search for this line: YAHOO.widget.DataSource.prototype.queryMatchContains=false; Change the false to true. That fixes the problem. I'm not sure what other coldfusion functions use this component or what unexpected side effects this change will introduce. However, this change allows the autosuggest feature to to function as it should, where you have the control in your SQL of what results are displayed in the dropdown. If you want the results to start with the search term, then search for WHERE d_name LIKE '#srch#%' You could even return results totally unrelated to the searched term if you wanted to. -Dave ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303073 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Resetting Active Directory Password using CFLDAP ?
Thank you, so much for the solution it was a tremendous help. I have an additional question. If you could please help that would be great. I created the CF account in AD and added it to the Account Operators group however, I am not able to change passwords but if I use the Administrator account it works. Is there anything else outside of the operators group that I need to do. Make sure you run your ColdFusion services as a domain account with, at least, Account Operator permissions (add your CF account to the Account Operators group in AD). Then, in the computer's Services, set the ColdFusion Application Server Service to log on as that domain account. Restart the CF service. ColdFusion will then be able to change the password of any account except for Domain Admins and above. The best way to set this up is to log in to a domain computer using the CF account credentials and run the NET command. If it works interactively, it will work using ColdFusion. m!ke I am attempting to build the same thing on my intranet and have found this post very useful, thank you. Unfortunately, I can not get this to work. What else do I need to do to get the cfexecute to work, Do I need to change something else on the net.exe file? and If so how does it pass that to the AD server? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303074 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 autosuggest automatically filters again?
Hi Dominic, I was wondering how many records can you through at your tag? I.E is it good if I past it a list of all U.S. cities? -Jim ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303075 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: QoQ question - left outer join
Yeah, that makes sense... I didn't realize that the query name getNEQnum was different from the looped query name getEQnum. I thought they were the same, so I thought the query was being referenced within itself. Thanks for the explanation, Dominic! Rick -Original Message- From: Dominic Watson [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 09, 2008 5:55 PM To: CF-Talk Subject: Re: QoQ question - left outer join The loop seems to be acting as a means of reading the value of '#Material#' for current query row. Would that be accurate? Nope ;). Think of cfquery as a kind of custom cfoutput tag and the outputted content between the tags as plain text. First of all, the cfquery tag evaluates the output between the cfquery tags as a 'query string'. Only THEN does it send that resultant string to the DB server or the QoQ engine to be processed. So, in this case, if there were three records in that 'inner loop', the query string sent to the QoQ engine might look like this: Cfquery code: cfquery name=getNEQnum dbtype=query SELECT getZMA.Material FROM getZMA WHERE (1 = 1 cfloop query=getEQnumAND getZMA.Material '#Material#'/cfloop) /cfquery Resulting query string sent to QoQ 'engine' / Database server: SELECT getZMA.Material FROM getZMA WHERE (1 = 1 AND getZMA.Material 'straw' AND getZMA.Material 'wood' AND getZME.Material 'bricks') Hope that makes sense, Dominic ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303076 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: spry and cf
When it comes to queries and JSON, CF supports two forms. See the
SerializeJSON function for more info. When you just use Spry (I mean
on the client, no CF8 Ajax stuff), you can specify the type hen you
create the data set. For an example, see Lighthouse Pro
(lighthousepro.riaforge.org).
On Wed, Apr 9, 2008 at 2:50 PM, Chad Gray [EMAIL PROTECTED] wrote:
What is up with this?
If I use cfsprydataset to get the json data, the data starts off with ]
{COLUMNS:[DEPT, etc.
If I use javascript to get the data ie. var mydata = new
Spry.Data.JSONDataSet
The page works and the json data starts with ROWCOUNT.
{ROWCOUNT:3,COLUMNS:[DEPT, etc.
Why no ROWCOUNT when using cfsprydataset?
cfsprydataset name=mydata2 type=json bind=cfc:jobNotes.getSteps()
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 09, 2008 2:56 PM
To: CF-Talk
Subject: spry and cf
I am about to pull my hair out. What am I doing wrong? The page returns
with no errors and the table is empty of data. All I have on the page is the
table headers and no table rows after it.
Firebug says I am returning data:
{COLUMNS:[JOBNUM,EMPLOYEENUM],DATA:[[1049,3010],[1049,3160],[1049,3170],[1049,3170],[1049,3170
],[1049,3170],[1049,3170],[1049,3170],[1049,3170],[1049,3170],[1049,3170],[1049,3170],[1049,3170],[1049
,3170],[1049,3170],[1049,3170],[1049,3170],[1049,3170],[1049,3170],[1049,3170],[1049,3170]]}
script type=text/javascript src=SpryAssets/xpath.js/script
script type=text/javascript src=SpryAssets/SpryData.js/script
script type=text/javascript src=SpryAssets/SpryJSONDataSet.js/script
cfsprydataset name=mydata2 type=json bind=cfc:jobNotes.getSteps()
div spry:region=mydata2
table width=100% border=1
tr
thJob Num/th
thEmployee Num/th
/tr
tr spry:repeat=mydata2
td{mydata2::JOBNUM}/td
td{mydata2::EMPLOYEENUM}/td
/tr
/table
/div
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303077
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: BIG problems with 8.0.1 update
Hi Adrian, This bug impacts certain cfimage functionality with jpg images. If you are not using this scenario you will not be impacted by upgrading to CF8.0.1. Thanks, Hemant ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303078 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
