password retrival
Hi Mike D, Not sure what I'm doing wrong but I can't retrieve my password. I entered my email and received a message reading 'Your user information has been emailed to you. ' I don't see my password though. I have tried several times. Spam and trash folders are empty. Thanks, W ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351815 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: WHERE Left(str,5) = 'string' VS WHERE str LIKE 'string%'
Interesting. Thanks for the results. There probably is another route we could test. We could right a function in C, compile it , and add it to mysql. I've never done it myself but I did read that it may make your query faster. I think I also I read that it might slow it down. BTW according to the mysql explain, the real reason why the LIKE wins in this case is when you start to join other tables. In my example the DB server will execute against every row with the LEFT statement while the execution plan for the LIKE will try execute against 40% of the rows in the db with another table. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337036 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: WHERE Left(str,5) = 'string' VS WHERE str LIKE 'string%'
On Wed, Sep 8, 2010 at 1:27 PM, Michael Grant mgr...@modus.bz wrote: What about mySQL? Do you know if this is documented and easy to find? http://dev.mysql.com/doc/refman/5.6/en/mysql-indexes.html ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336907 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: WHERE Left(str,5) = 'string' VS WHERE str LIKE 'string%'
mike, Please let us know what you find out. I'm very curious of this myself. As the document clearly states, mysql will use an index when you use a like but don't start the string with a wildcard. So we know that Left(str,5) = 'string' VS WHERE str LIKE 'string%'both will use an index. The question now becomes the cost of using LEFT vs using the LIKE. BTW, I assume you meant where left(str, 6) = 'string'. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336918 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: WHERE Left(str,5) = 'string' VS WHERE str LIKE 'string%'
I ran a quick test
CREATE TABLE HoF (
ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
LastName VARCHAR(100)
) ENGINE = InnoDB;
insert into HoF (LastName) values ('Smith');
insert into HoF (LastName) values ('Smithville');
insert into HoF (LastName) values ('Jones');
insert into HoF (LastName) values ('Smithy');
insert into HoF (LastName) values ('Smit');
select lastname from HoF where left(lastname, 5) = 'smith';
select lastname from HoF where lastname like 'smith%';
explain extended select lastname from HoF where left(lastname, 5) = 'smith';
explain extended select lastname from HoF where lastname like 'smith%';
create index lname_index on HoF (lastname(100));
explain extended select lastname from HoF where left(lastname, 5) = 'smith';
explain extended select lastname from HoF where lastname like 'smith%';
Conclusion, which seems pretty obvious now, is that Like is the better
route. LEFT will have to read every row so it can execute the LEFT function
against it while the LIKE column will filter out columns that it doesn't
meet the condition.
It's really late and I had a tough day at work so please correct me if
anyone sees anything wrong with my analysis.
W
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336927
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: mySQL data types - possible db bloat with text type? yes or no?
On Fri, Sep 3, 2010 at 12:04 PM, Michael Grant mgr...@modus.bz wrote: *bump* No one has any insight into this? Please please please. On Thu, Sep 2, 2010 at 11:47 AM, Michael Grant mgr...@modus.bz wrote: Normally I use MSSQL but the shop I'm at uses mySQL. I've always built my db's so that the field best matches the data going into it. As an example if I was storing some text data that was max 1000 chars I would use varchar(1000) and not a blob type. I've always thought that this prevented bloating. However I've just been told something that contradicts this and I'm wondering what you experts say. Is using the TEXT datatype completely variable how long it it? So if I insert a single character into a tinytext, text, mediumtext or longtext field it will only take up that much room in the db? Is that correct? It's not as simple as you think it is. I don't know the answer for sure but this is what I know. Assuming mySQL...How much space something takes is dependent on the type of engine you select. The common ones are innodb, myISAM, and the perconaDB. As far I remember the innodb takes more space because it has more features and can't be compressed. Looking at myISAM, which by the way is probably not the engine you want for any transaction based db, you would use one (1) more bytes over a varchar(1000). So if storing i piece of data as a varchar(1000) that was 299 cahr longs it would take 300 bytes it would take 301 bytes if you had typed is as a text. That is true up to 65536 bytes. then the storage requirements changes. recap: in your case if you were using myISAM the text type would use 1 more byte than the varchar(1000). Things like char encoding like UTF or latin will impact it as well. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336810 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: mySQL data types - possible db bloat with text type? yes or no?
On Fri, Sep 3, 2010 at 12:23 PM, Michael Grant mgr...@modus.bz wrote: Thanks. Other than the 1 extra byte thing... if I'm using MyISAM and assumming I have a string that's 150 characters is there any advantage to using varchar(150) over say TEXT or any of the other text type fields? that's what I'm trying to get at. So is a table that's got 20 TEXT datatype fields going to be the same as a table that has 20 varchar(x) fields? There is an advantage in using varchar over text and it is performance. Because text type is written in a different area of the memory that the row buffer there may be a slight performance hit because it needs to do a harddrive read/write. I guess like your does ## impact performance thread it depends on the data you are storing. But let me say that you are much more likely to see this performance hit. I also believe that varchar can be indexed while text can't. I'm a little hazy on remembering everything right now cause I moved to an Oracle shop. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336812 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) FTP Servers with DB integration
On Tue, Aug 31, 2010 at 10:46 AM, Rick Root rick.r...@gmail.com wrote: Anyone out there have any experience with FTP server software that integrates with a external database for things like authentication and directory access? I need an FTP server where a user can log in using their web site username/password, and based on that information, have their FTP session chrooted to their specific file directory on the server. Windows. I investigated XLight FTP a few months back but had some problems and found their technical support to be less than stellar. Rick Axway.com. The whole purpose of their Gateway product is for B2B secure file transfer. We use it to trade files between pharma companies and also to send files to the FDA. Another, but pricey option, is to setup a point to point t1 to delivery only the messages or files to your trading partner directly. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336669 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: social network application based on CF ?
myspace used to be in CF I think. On Fri, Aug 27, 2010 at 6:23 PM, cf-t...@sdsolutions.de cf-t...@sdsolutions.de wrote: Hi list, is there any social network application / social network framework based on CF you guys are aware of ? Thanks in advance for your feedback ! Uwe ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336640 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Number of site using ColdFusion
http://www.adobe.com/enterprise/pdfs/Adobe3112.pdf Please read it and decide if this is something that you can use. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336529 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Dump to Excel from CF 5
On Mon, Aug 23, 2010 at 11:46 AM, Eric J. Ehlers ericjehl...@gmail.comwrote: Yes, you read that right. CF FIVE. That's what Govt work will get you. I'm not used to developing in ColdFusion, so nuances are easily escaping me. I've tried using various iterations of CFCONTENT and CFHeader but nothing is changing. I'm only getting a display in the web browser. Clearly, I'm doing something wrong. I need a straightforward, no assumptions made tutorial on how I can use CF5 to dump data from a query into an Excel document. The query works fine, and I can write it into an HTML table without a problem. But beyond that, I'm starting to feel a little dumb. Hopefully, you can stand my noobishness. Read up on cffile. I don't have cf5 to test against but I think creating a string and writing it to a cffile should work. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336463 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: oracle database link
I assume you mean a link from one oracle schema to another schema by executing the CREATE DATABASE LINK sql command through a CFML page. Is this correct? If it is check your permissions. This most likely has nothing to do with CF. As I side note, I don't think CFML pages should be running this sort of code. You should just login to your Oracle DB and run that command to create a link. Curious? Is there a reason why you just don't create a new CF datasource in the CF ADMIN? On Wed, Aug 4, 2010 at 9:11 AM, Dave P jda...@gmail.com wrote: Hello all, Has anyone actually gotten a database link working from a CF server to a second oracle server? I'm trying a connection string: create database link prodlink connect to myusername identified by mypass using 'PROD'; and getting: Error Executing Database Query. Executing the SQL statement is not allowed. The problem is that I am not the admin and have little oracle experience. The DBA has little CF (or even web) experience. It sounds like to me there is a permissions error in either the oracle DB, or in CF. I'm not sure which. Of course i'm crunched for time. Any ideas? Thank you, Dave Powell ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335976 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) changing the default for loading actionscript files in cfeclipse/eclipse
On Mon, Jul 19, 2010 at 12:35 PM, DURETTE, STEVEN J (ATTASIAIT) sd1...@att.com wrote: Sorry for the off topic, but when I'm working on a project in CFEclipse that has actionscript files, if I double click on the file it starts up Flash to open the file. I don't want that, I want the .as file to open in CFEclipse. I know I can right click the file and choose Open With - Text editor, but that slows me down. After all, the IDE is supposed to conform to me not me to it. J Not sure about CFEclipse because my CFBuilder is on a VM that is down but I would think you can change the file type association at the OS level so it opens it in CFEclips ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335471 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) changing the default for loading actionscript files in cfeclipse/eclipse
On Mon, Jul 19, 2010 at 12:42 PM, DURETTE, STEVEN J (ATTASIAIT) sd1...@att.com wrote: Ok... But why should I have to do that? The default OS Application for .cfm files is Dreamweaver, but when I open CFE and double click a .cfm file it opens in CFE. Besides, in some companies, changing defaults like that are locked down. Thanks for the idea though, I might do that as a last resort. (where is my admin's phone number) I agree with you; I don't think one should be forced to change file association at the OS level. It was the only thing I could think of while my CFBuilder was down. W ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335473 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: development and testing server
Adam, That would be great. I will email you my work email off the list. On Wed, Jul 14, 2010 at 10:22 AM, Adrocknaphobia adrocknapho...@gmail.comwrote: Won, Unfortunately, the EULA is about as official as it gets. The best I can offer is to send you and your admin and email from my Adobe account confirming that the same key can be used between production, staging, testing and development environments. It's important to note that licenses and license keys are not one in the same. For example, if you buy a volume license for ColdFusion that covers many servers, we commonly issue just a single key -- imagine the headaches it would cause if you have to manage 100+ different CF license keys. The recent EULA change follows the same principals. One serial key can cover multiple installs. -Adam On Tue, Jul 13, 2010 at 3:36 PM, Won Lee won...@gmail.com wrote: Thanks. I did tell him that I got the post from Adam, who is the product manager, and the evangelist's blog. he understands that we can create a dev and staging server for each key we own. The EULA is clear about that. He wants, in writing, that the process is to just use the production key. We operate in a GxP environment and our process must be documented for audits. W On Tue, Jul 13, 2010 at 3:32 PM, Judah McAuley ju...@wiredotter.com wrote: The author of that article works for Adobe in an official CF capacity and then points to the changes in the EULA. I think that short of get a signed statement from Adobe's lawyers that they won't sue you, that is about as official as you are going to get. You've got the license text and you have a top-level Adobe employee spelling out the details of what it means. Baring that, I'd suggest contacting Adobe directly. Judah On Tue, Jul 13, 2010 at 12:26 PM, Won Lee won...@gmail.com wrote: He was looking for something more official. We take licenses very seriously here. W On Tue, Jul 13, 2010 at 3:19 PM, Judah McAuley ju...@wiredotter.com wrote: http://www.terrenceryan.com/blog/post.cfm/coldfusion-9-testing-staging-and-development-changes-to-eula On Tue, Jul 13, 2010 at 12:16 PM, Won Lee won...@gmail.com wrote: Adam, my network admin is asking me for a URL or documenation that specifically states that. I showed him the EULA but he is asking for the part where we can use a production key for development and testing. He understands those servers will only be used for development and testing. W On Tue, Jul 13, 2010 at 2:49 PM, Won Lee won...@gmail.com wrote: Thanks On Tue, Jul 13, 2010 at 1:36 PM, Adrocknaphobia adrocknapho...@gmail.comwrote: Just use the same key. -Adam On Tue, Jul 13, 2010 at 1:03 PM, Won Lee won...@gmail.com wrote: Hi folks, I've been using CF 9 developer on edition on my dev box and the standard version on my production box. I want to change the dev box to standard for development only purpose under the EULA 3.1.3. Any directions for this or do I just enter the same key? W ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335371 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
development and testing server
Hi folks, I've been using CF 9 developer on edition on my dev box and the standard version on my production box. I want to change the dev box to standard for development only purpose under the EULA 3.1.3. Any directions for this or do I just enter the same key? W ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335296 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: development and testing server
Thanks On Tue, Jul 13, 2010 at 1:36 PM, Adrocknaphobia adrocknapho...@gmail.comwrote: Just use the same key. -Adam On Tue, Jul 13, 2010 at 1:03 PM, Won Lee won...@gmail.com wrote: Hi folks, I've been using CF 9 developer on edition on my dev box and the standard version on my production box. I want to change the dev box to standard for development only purpose under the EULA 3.1.3. Any directions for this or do I just enter the same key? W ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335302 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: development and testing server
Adam, my network admin is asking me for a URL or documenation that specifically states that. I showed him the EULA but he is asking for the part where we can use a production key for development and testing. He understands those servers will only be used for development and testing. W On Tue, Jul 13, 2010 at 2:49 PM, Won Lee won...@gmail.com wrote: Thanks On Tue, Jul 13, 2010 at 1:36 PM, Adrocknaphobia adrocknapho...@gmail.comwrote: Just use the same key. -Adam On Tue, Jul 13, 2010 at 1:03 PM, Won Lee won...@gmail.com wrote: Hi folks, I've been using CF 9 developer on edition on my dev box and the standard version on my production box. I want to change the dev box to standard for development only purpose under the EULA 3.1.3. Any directions for this or do I just enter the same key? W ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335305 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: development and testing server
He was looking for something more official. We take licenses very seriously here. W On Tue, Jul 13, 2010 at 3:19 PM, Judah McAuley ju...@wiredotter.com wrote: http://www.terrenceryan.com/blog/post.cfm/coldfusion-9-testing-staging-and-development-changes-to-eula On Tue, Jul 13, 2010 at 12:16 PM, Won Lee won...@gmail.com wrote: Adam, my network admin is asking me for a URL or documenation that specifically states that. I showed him the EULA but he is asking for the part where we can use a production key for development and testing. He understands those servers will only be used for development and testing. W On Tue, Jul 13, 2010 at 2:49 PM, Won Lee won...@gmail.com wrote: Thanks On Tue, Jul 13, 2010 at 1:36 PM, Adrocknaphobia adrocknapho...@gmail.comwrote: Just use the same key. -Adam On Tue, Jul 13, 2010 at 1:03 PM, Won Lee won...@gmail.com wrote: Hi folks, I've been using CF 9 developer on edition on my dev box and the standard version on my production box. I want to change the dev box to standard for development only purpose under the EULA 3.1.3. Any directions for this or do I just enter the same key? W ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335310 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: development and testing server
Thanks. I did tell him that I got the post from Adam, who is the product manager, and the evangelist's blog. he understands that we can create a dev and staging server for each key we own. The EULA is clear about that. He wants, in writing, that the process is to just use the production key. We operate in a GxP environment and our process must be documented for audits. W On Tue, Jul 13, 2010 at 3:32 PM, Judah McAuley ju...@wiredotter.com wrote: The author of that article works for Adobe in an official CF capacity and then points to the changes in the EULA. I think that short of get a signed statement from Adobe's lawyers that they won't sue you, that is about as official as you are going to get. You've got the license text and you have a top-level Adobe employee spelling out the details of what it means. Baring that, I'd suggest contacting Adobe directly. Judah On Tue, Jul 13, 2010 at 12:26 PM, Won Lee won...@gmail.com wrote: He was looking for something more official. We take licenses very seriously here. W On Tue, Jul 13, 2010 at 3:19 PM, Judah McAuley ju...@wiredotter.com wrote: http://www.terrenceryan.com/blog/post.cfm/coldfusion-9-testing-staging-and-development-changes-to-eula On Tue, Jul 13, 2010 at 12:16 PM, Won Lee won...@gmail.com wrote: Adam, my network admin is asking me for a URL or documenation that specifically states that. I showed him the EULA but he is asking for the part where we can use a production key for development and testing. He understands those servers will only be used for development and testing. W On Tue, Jul 13, 2010 at 2:49 PM, Won Lee won...@gmail.com wrote: Thanks On Tue, Jul 13, 2010 at 1:36 PM, Adrocknaphobia adrocknapho...@gmail.comwrote: Just use the same key. -Adam On Tue, Jul 13, 2010 at 1:03 PM, Won Lee won...@gmail.com wrote: Hi folks, I've been using CF 9 developer on edition on my dev box and the standard version on my production box. I want to change the dev box to standard for development only purpose under the EULA 3.1.3. Any directions for this or do I just enter the same key? W ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335313 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Looking for a CF Recipe script!
On Thu, Jul 8, 2010 at 9:57 PM, denstar valliants...@gmail.com wrote: So /that's/ why my ascii art is all mangled! ;] , - \O , .-.___ - /\ O/ /xx\XXX\ - __/\ ` /\ |xx|XXX| `\, () ` |xx|XXX| jgs`^^^ NSFW! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335213 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Extract an URL Variable name?
On Thu, Jul 8, 2010 at 11:11 PM, Les Mizzell lesm...@bellsouth.net wrote: If I'm passing an URL Variable - with the variable name itself being dynamic, what's the best was to extract the variable name (not the value) on the receiving page? As in: for: index.cfm?somevar=somevalue I need to return somevar on the receiving page as a value. or for: index.cfm?bigdog=bruto I need to return bigdog on the receiving page as a value. Reference cgi.query_string W ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335214 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF vs. ASP.Net
http://www.adobe.com/enterprise/pdfs/Adobe3112.pdf ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334686 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF vs. ASP.Net
On Mon, Jun 21, 2010 at 2:29 PM, Casey Dougall ca...@uberwebsitesolutions.com wrote: On Mon, Jun 21, 2010 at 2:23 PM, Won Lee won...@gmail.com wrote: http://www.adobe.com/enterprise/pdfs/Adobe3112.pdf Well, there ya go, we got another 4 years to learn new languages... Adobe, way to set a bleak future for your own product! Report was written by Gartner which is not affiliated with Adobe AFAIK. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334689 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF Builder Install Problem
From memory... You may install CF Builder as a stand alone or plugin. It asks you for the eclipse directory if you are installing as a plugin. i think CF Builder actually ships with Eclipse. I can't go through the install process because I don't have rights on this system but that is what I remember. W On Tue, May 25, 2010 at 4:02 PM, Rick Colman rcol...@cox.net wrote: The trial version of CF Builder thinks I already have Eclipse installed, and is asking for the relevant directory. I can't recall such an install, but who knows. Any ideas appreciated. Rick. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333987 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF 9 How pass data in one grid to a query that populates another grid?
On Mon, May 24, 2010 at 9:52 AM, Joy Rose joycer...@gmail.com wrote: I have a cfgrid from which a user would choose a data row. Based on the values in the selected row, I would run to a query to get detailed data that would display in another grid. In that new grid, I would want to be able to insert and also maybe edit a row. I haven't found any explanation of how to get the values of the selected row. Any other ideas on how to structure the process I described would also be really helpful. been awhile since I've done this but you can do this easily via ETX which is the underlying code for cfgrid. You need to manually create two stores. Then add two listeners to each of the grids. Probably want a RowSelectionModel(). Don't know how to do it via CFGRID. Hopefully this puts you in the right direction. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333959 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
house of fusion password recovery
Can anyone else retrieve their emails through the website? What I Did: Went to www.houseoffusion.com. clicked on Sign In - email password. entered won...@gmail.com. The system returned message Your user information has been emailed to you. on page http://www.houseoffusion.com/signin/mailpass.cfm. I tried this about a month ago and nothing was sent to me. I also searched on won@gmail.com. The system sent me a messaging stating the email was not registered. I also did a search on password on my gmail and so no thread with my HoF password. I also did a search on houseoffusion which yielded no results either. TIA, W ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333255 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL data integrity
This is what I follow to ensure my data is clean. http://en.wikipedia.org/wiki/Title_21_CFR_Part_11 ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333108 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL data integrity
Look up validation process. On Thu, Apr 22, 2010 at 3:30 PM, Justin Scott jscott-li...@gravityfree.comwrote: Hi all, not a CF-specific question but I'm hoping someone can point me in the right direction. We're building an application where some information stored in our database could potentially be subpoenaed to court as evidence. One of the issues brought up by the attorneys is the integrity of the data stored in the database and how it could be proven in court that the data has not been altered since it was entered into the database. Any ideas on where to start looking for a solution to that? The front-end is ColdFusion with a MS-SQL back-end. This is a new area for me, so it's interesting, but I don't have any points of reference to work from either. Any insight is appreciated. Thanks! -Justin ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333094 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Opa
http://www.shadowfyre.com/ESx5iJBwdx.htm -- Lola J. Lee Beno ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-jobs-talk/message.cfm/messageid:4309 Subscription: http://www.houseoffusion.com/groups/cf-jobs-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-jobs-talk/unsubscribe.cfm
Re: GIT Anyone?
I'm curious if you considered using Hg and if you did why you picked it over GIT. Thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332250 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: GIT Anyone?
TLDR: I wouldn't worry too much about graphical tools for either Git or Hg unless you have a funky deployment plan. Both have plugins for CFBuilder. I can tell you that Hg works. I would like to add that I picked Hg over Git because I was able to get Hg working like I wanted within 20 minutes of download. Official Git, last time I checked, has horrible Windows support. I think there is a forked version that supports Windows but I don't think I'm exaggerating when I write that you are really taking a unnecessary, however small, risk if you work in a Windows environment. In reality, I don't think either Git or Hg is a bad choice. Heck, you can even pull from linux kernel repository using Hg. http://www.kernel.org/hg/linux-2.6/ Short: I recommend Hg due to a) easier install, b) easier to use, c) and better Windows support. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332276 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: GIT Anyone?
Those wanting more Hg: http://hgbook.red-bean.com/read/ Those wanting more Git: http://progit.org/book/ ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332281 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion Builder Released!
I have TOAD but do not use is. SQL Plus, Oracle SQL Developer, or OEM are enough to effectively manage Oracle. I know the first two are free. I believe the third is as well. On Wed, Mar 24, 2010 at 11:23 AM, Eric Roberts ow...@threeravensconsulting.com wrote: That's one of the big issues I have with oracle. You shouldn't have to buy a 3rd party product to effectively manage it. Even MS provides a free management tool for SQL Server. Eric -Original Message- From: James Holmes [mailto:james.hol...@gmail.com] Sent: Wednesday, March 24, 2010 10:09 AM To: cf-talk Subject: Re: ColdFusion Builder Released! That's how I view the issue. We run Oracle, connected to 8 licences worth of CF Enterprise. To develop for Oracle we use TOAD, the cost of which is much higher than CFB. Don't even ask what it costs us to site licence Adobe CS4 Web Premium. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ On 24 March 2010 22:37, Dave Watts dwa...@figleaf.com wrote: It's not so much that $300 is a trivial amount, but rather that it's well within the expected range of prices for the tools you buy as a software developer, and it's at the low end of that range. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332187 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Differences between MySQLs?
1) check the datasource in cf admin. 2) make sure the JDBC connectors are the same. In your case it doesn't seem like it will be the issue but I would eliminate it as a possibility. 3) check the application.dsn (or whatever you named it). Make sure it is correct by cfdumping it. W On Wed, Mar 24, 2010 at 3:02 PM, Phillip Vector vec...@mostdeadlygame.comwrote: When I run this on my server.. SELECT * FROM Accounting Where PromoCode = 'CNJ0009001' I get 6 results... This is a local Dev server I have set up. When i run it at my hosting company, I get 0 results for the same exact query. I go in and my external database program confirms the records are in there. The page works fine locally, but on the live site, it doesn't. Before I make a ticket, can anyone confirm perhaps a setting they heard of or some such that might be responsible or does anyone have any additional troubleshooting steps I may be missing? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332198 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Differences between MySQLs?
I'm really trying hard to remember...but I think the connector is part of the db string. Open up each datasource in cfadmin. It also might be installed to your JDK_Path/lib/ext. I might be off, both in pointing you towards the JDBC connector and how to check which version you have. I have no experience actually handling the connector. I just know that when my data sets started to yield unexpected data I would have the server admins check the connectors and often it was the cause. On Wed, Mar 24, 2010 at 4:17 PM, Phillip Vector vec...@mostdeadlygame.comwrote: Datasource is correct and the application datasource is correct. I have no way to confirm the JDBC connectors. On Wed, Mar 24, 2010 at 12:37 PM, Won Lee won...@gmail.com wrote: 1) check the datasource in cf admin. 2) make sure the JDBC connectors are the same. In your case it doesn't seem like it will be the issue but I would eliminate it as a possibility. 3) check the application.dsn (or whatever you named it). Make sure it is correct by cfdumping it. W On Wed, Mar 24, 2010 at 3:02 PM, Phillip Vector vec...@mostdeadlygame.comwrote: When I run this on my server.. SELECT * FROM Accounting Where PromoCode = 'CNJ0009001' I get 6 results... This is a local Dev server I have set up. When i run it at my hosting company, I get 0 results for the same exact query. I go in and my external database program confirms the records are in there. The page works fine locally, but on the live site, it doesn't. Before I make a ticket, can anyone confirm perhaps a setting they heard of or some such that might be responsible or does anyone have any additional troubleshooting steps I may be missing? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332212 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFBuilder: standalone or plugin?
First excuse me for not posting on cf-builder. I've been waiting couple of hours for HoF to email me a new password link. What is the major difference between the two types of install? I did a google search and the only worthwhile information I was able to find was Ray Camden writing that he only used the standalone version so far. My major concern is getting CFBuilder to work with HgEclipse. I just DLed the trial version and giving it a spin before I commit part of my budget for a license. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332140 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFBuilder: standalone or plugin?
Thanks W On Tue, Mar 23, 2010 at 4:21 PM, Scott Stewart webmas...@sstwebworks.comwrote: Won, If there are Eclipse plugins that you already use, or want to use then install the CFBuilder plugin. I've run it on the latest Eclipse builds and haven't had any problems. Conversly I think CFBuilder is based off of either the 3.2 or 3.3 builds, and most plugins would fould out on install On Tue, Mar 23, 2010 at 4:12 PM, Won Lee won...@gmail.com wrote: First excuse me for not posting on cf-builder. I've been waiting couple of hours for HoF to email me a new password link. What is the major difference between the two types of install? I did a google search and the only worthwhile information I was able to find was Ray Camden writing that he only used the standalone version so far. My major concern is getting CFBuilder to work with HgEclipse. I just DLed the trial version and giving it a spin before I commit part of my budget for a license. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332144 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: good forums
1) http://www.extjs.com/learn/Main_Page. You should do the tutorials. 2) While not a forum, Cutter's blog is worth reading while drinking one's morning coffee. http://blog.cutterscrossing.com/ 3) I'm surprised that the ExtJs forums hasn't been more helpful. I've had a lot of success on there. On Mon, Mar 22, 2010 at 8:11 AM, Richard White rich...@j7is.co.uk wrote: hi, i have used this forum whilst learning coldfusion and the community is excellent. I have always had answers to my questions within minutes and has really helped. I am currently very new to extjs and attempting to learn it from scratch. Unfortunately there are many questions I have but the forums on www.extjs.com/forum/ dont appear to be as helpful. I dont get replies to answers very often and when i do the answers are very confusing. Does anyone know of any good forums for learning extjs thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331944 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF, Flex and EXTJS
EXTJs, the version that ships with your CF server, is also free to use in production as it is part of your CF Server license. Don't know about Flex in production. On Thu, Mar 18, 2010 at 1:06 PM, Andy Matthews li...@commadelimited.comwrote: The two technologies, Flex and Ext JS, do very similar things in different ways. I'd say that it all depends on where your comfort level is. If your team knows Actionscript 3 (or Java) already, then Flex might be a good fit. If, on the other hand, you have JavaScript experts, you might want to use Ext JS. Bear in mind that both are free to develop in, but Flex Builder, the preferred IDE for Flex developers, is not free. andy -Original Message- From: Richard White [mailto:rich...@j7is.co.uk] Sent: Thursday, March 18, 2010 11:41 AM To: cf-talk Subject: CF, Flex and EXTJS Hi we used to use dhtmlx for our interface components but found it was very slow. We were pointed to Ext JS and think it is brilliant. However, we are just wondering where flex fitd in. do you guys use flex instead of ext js, or do you combine the two? we would appreciate any general advice you have about interfaces and technologies to use thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331862 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
empty strings
I'm not sure what to do a search on this subject so please excuse me if this question was already asked. I have a form. It has an optional field. When I go to insert a new record into the Oracle DB, the db will throw an error if the formfield is empty. I can get around this by using a cfif len(trim(form.fieldname). Is there a better way to handle this? Isn't there a performance hit for this sort of quasi-dymanic sql statement? The only thing I can think off the top of my head is when I convert it to a stored procedure to check for the length there since quasi-dynamic queries have less impact on the DB side. TIA, W ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329548 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: empty strings
Thanks. On Mon, Jan 11, 2010 at 4:43 PM, Qing Xia txiasum...@gmail.com wrote: I didn't test it against an Oracle DB, but the following works against a SQL Server DB. Be sure to adjust the cfsqltype according to the data type of your form field. cfqueryparam value=#form.myField# cfsqltype=cf_sql_varchar null=#YesNoFormat(NOT LEN(TRIM(form.myField)))# Hope this helps! On Mon, Jan 11, 2010 at 4:21 PM, Won Lee won...@gmail.com wrote: I'm not sure what to do a search on this subject so please excuse me if this question was already asked. I have a form. It has an optional field. When I go to insert a new record into the Oracle DB, the db will throw an error if the formfield is empty. I can get around this by using a cfif len(trim(form.fieldname). Is there a better way to handle this? Isn't there a performance hit for this sort of quasi-dymanic sql statement? The only thing I can think off the top of my head is when I convert it to a stored procedure to check for the length there since quasi-dynamic queries have less impact on the DB side. TIA, W ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329550 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: empty strings
The performance hit I meant was on the cf-app and then the inability of the app server (or would it be the db server?) to cache that query. also cfqueryparam doesn't seem to be working in this case. here is my code cfdump var=#form# cfparam name=form.user_id default=1 cfset variables.dateTimeStamp = createodbcdatetime(now()) cftry cfquery name=insertProduct datasource=#application.dsn# insert into case_products ( case_id ,created_by ,datetimestamp ,product_id ,formulation cfif len(trim(form.freq)),frequency/cfif cfif len(trim(form.dosage_route)),route/cfif cfif len(trim(form.product_dosage)),dosage/cfif cfif len(trim(form.product_duration)),duration/cfif cfif len(trim(form.product_exposure)),exposure/cfif cfif len(trim(form.product_indication)),indication_for_use/cfif cfif len(trim(form.product_interaction)),interaction/cfif ) values ( #form.case_id# ,#form.user_id# ,#variables.dateTimeStamp# ,#form.product_id# cfqueryparam value=#form.product_formula# cfsqltype=cf_sql_char null=#YesNoFormat(NOT LEN(TRIM(form.product_formula)))# cfif len(trim(form.freq)),#form.freq#/cfif cfif len(trim(form.dosage_route)),#form.dosage_route#/cfif cfif len(trim(form.product_dosage)),#form.product_dosage#/cfif cfif len(trim(form.product_duration)),#form.product_duration#/cfif cfif len(trim(form.product_exposure)),#form.product_exposure#/cfif cfif len(trim(form.product_indication)),#form.product_indication#/cfif cfif len(trim(form.product_interaction)),#form.product_interaction#/cfif ) /cfquery cfcatch type = any !--- the message to display --- h3You've Thrown a Database bError/b/h3 cfoutput !--- and the diagnostic message from the ColdFusion server --- p#cfcatch.message#/p pCaught an exception, type = #CFCATCH.TYPE# /p pThe contents of the tag stack are:/p cfloop index = i from = 1 to = #ArrayLen(CFCATCH.TAGCONTEXT)# cfset sCurrent = #CFCATCH.TAGCONTEXT[i]# br#i# #sCurrent[ID]# (#sCurrent[LINE]#,#sCurrent[COLUMN]#) #sCurrent[TEMPLATE]# /cfloop /cfoutput /cfcatch /cftry -- The part that is throwing the error is the form.product_formula. I intentionally sent over empty formfields. cfqueryparam doesn't seem to insert in a null if the string is empty.I have sent over both NULL and empty string and the cfdump is always empty. If i put the cfif around the sql statements it works though. On Mon, Jan 11, 2010 at 5:01 PM, Leigh cfsearch...@yahoo.com wrote: I can get around this by using a cfif len(trim(form.fieldname). Is there a better way to handle this? Isn't there a performance hit for this sort of quasi-dymanic sql statement? No, because the sql string is all constructed in CF. Then the final string is sent (all at once) to your database. So the database is not even aware of any conditionals. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329553 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: empty strings
and so it was. Thanks =). Thanks to everyone else that chimed in. W On Mon, Jan 11, 2010 at 5:19 PM, Jason Fisher ja...@wanax.com wrote: Looks like you're missing your comma before the queryparam: ,#form.product_id# ,cfqueryparam value=#form.product_formula# cfsqltype=cf_sql_char null=#YesNoFormat(NOT LEN(TRIM(form.product_formula)))# ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329556 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Two Column Select Box?
On Wed, Dec 16, 2009 at 5:03 PM, ColdFusion Developer cfdev2...@gmail.comwrote: Tried that as well. Does not line up. Ex: option value=13M | XYZ Corporation/option option value=1ABCDY | AB Corporation of Delaware/option The first one is 2 characters and 5 spaces The second one if 5 characters and 2 spaces Both equal 7 spaces :-( I am wondering if the is a CSS way to do it. What font are you using? Will changing the type of font work? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329198 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Check Boxes
On Tue, Dec 8, 2009 at 9:27 AM, Damo Drumm damien.dr...@quinn-group.comwrote: Hi can someone help me out here, Im trying to have a check box for each invoice so when its ticked and you press submit all the ticked invoices will be sent to the revelant email address, I'm trying to have it so the check boxes will be defaulted to ticked if the customer Number for the invoice, is in the Customer Table, The next problem I have is for each Customer I add to the Customer Table its duplicating the Data and showing everything twice if theres 2 Customers. or 3 times if theres 3 Customers added and so on, I cant seem to figure out why its doing this any tips would be great 1) only send email to customers who have a checkbox next to them one way would be to input type=checkbox name=sendEmail_customerID for each record the on the action page loop around the list of IDs and send the emails. 2) have the checkbox defaulted to checked use a cfif conditionchecked /cfif 3) Looks like you have a Cartesian join. You need to edit your SQL query. Without any code these are my best guesses. W ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328952 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Check Boxes
cfquery name=qgetinvoices datasource=#request.dsn# select I.INVOICE_DateAdded, I.COMPANY_Number, I.INVOICE_Number, C.COMPANY_Name, I.INVOICE_Key, I.CUSTOMER_AccNum, CU.CUSTOMER_Name from INVOICE I, COMPANY C, CUSTOMER CU where I.COMPANY_Number = C.COMPANY_Number AND I.COMPANY_Number = '#form.COMPANY_Number#' AND I.INVOICE_Number LIKE '%#form.INVOICE_Number#%' AND I.CUSTOMER_AccNum LIKE '%#form.CUSTOMER_AccNum#%' AND CU.CUSTOMER_Name LIKE '%#form.CUSTOMER_Name#%' AND I.INVOICE_PDFFile '' /cfquery This query looks like it gets the results for your search. You have 3 tables: invoice, company, and customer. You join the invoice table and the company table via the SQL, I.COMPANY_Number = C.COMPANY_Number. Unfortunately you do not join customer table to the other 2 tables. This is why you are always getting more results than you want. You need to join the invoice table to the customer table. the top half of your code looks like it was not a full cut and paste. If it was then it really doesn't make any sense. What is the query, qgetcustomer, being used for? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328954 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Check Boxes
On Tue, Dec 8, 2009 at 10:35 AM, Damo Drumm damien.dr...@quinn-group.comwrote: This was what i meant to put in instead of qgetcustomer query So am I still missing a join somewhere cfif isdefined(url.invoice) cfquery name=qgetcompanyno datasource=#request.dsn# select COMPANY_Number, INVOICE_Number, CUSTOMER_AccNum from INVOICE where INVOICE_Key = #url.invoice# /cfquery cfset form.INVOICE_Number = qgetcompanyno.INVOICE_Number cfset form.COMPANY_Number = qgetcompanyno.COMPANY_Number /cfif based on the code you sent me, yes I believe you are still missing a join in qgetinvoices cfquery name=qgetinvoices datasource=#request.dsn# select I.INVOICE_DateAdded, I.COMPANY_Number, I.INVOICE_Number, C.COMPANY_Name, I.INVOICE_Key, I.CUSTOMER_AccNum, CU.CUSTOMER_Name from INVOICE I, COMPANY C, CUSTOMER CU where I.COMPANY_Number = C.COMPANY_Number and CU.invoice_number = I.invoice_number /cfquery This all depends if invoice_number is unique in the invoice table. if it isn't then you have more work to do. If so, this is the basic query. Then you can add in more conditions to the where clause get only the results you want. In this schema, what does the company represent? the seller, the buyer, both? Is the customer an individual or a company? if it is a company why are there to separate tables? Not saying any of your schema is incorrect. Just relevant information to try help you. Even if there was something wrong with the schema not sure you could even change it right now. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328956 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfselect url bind
On Tue, Dec 8, 2009 at 11:00 AM, Sean Sekora seansek...@gmail.com wrote:
I have the following cfselect
cfselect name=type
bind=url:lookup.cfc?method=getTypeyear={year}make={make}model={model}
bindonload=false /
Is there a way to prevent the lookup from being executed until all the
required values have been set?
The workaround that comes to mind is to disable the select until the other
form elements are populated. Perhaps someone else can give a more elegant
solution.
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328958
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Check Boxes
On Tue, Dec 8, 2009 at 11:53 AM, Damo Drumm damien.dr...@quinn-group.comwrote: The company table represents the seller, and the Customer table represents the individual Buyers. Invoice_Number is unique but I also have INVOICE_Key in the INVOICE table If that is the case then the query should work COMPANY - INVOICE - CUSTOMER This is how the information is joined. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328962 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: datefield + js
On Wed, Dec 2, 2009 at 12:51 PM, Leigh _ cfsearch...@yahoo.com wrote:
Depending on your needs, you might try the work-around mentioned here:
http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:55190#299204
Or you try binding the text field to the datefield:
script type=text/javascript
function calcAge(bDateValue)
{
// ... return whatever value desired
return bDateValue;
}
/script
cfform name=patient_form action=patient_action.cfm method=post
cfinput mask=DDMMM name=patient_bdate type=datefield
value=/td
cfinput type=text name=patient_age
bind=javascript:calcAge({patient_bdate})
/cfform
HTH
-Leigh
Thanks I'm going to try that right now.
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328781
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
datefield + js
Hello folks,
This has to be something simple as I've seen example of ppl getting it to
work but I'm having problems running some JS on a cfinput type datefield.
Part of the code
script type=text/javascript
function calcAge(){
alert('calc age');
return true;
}
/script
cfform name=patient_form action=patient_action.cfm method=post
tr
tdbBirthdate:/b/td
tdcfinput mask=DDMMM name=patient_bdate type=datefield
value= onChange=calcAge()/td
tdbAge:/b/td
tdcfinput type=text name=patient_age value=/td
/tr
I've also tried onClick (Works if I click on the input box but not the
calendar icon), OnError, onValidate, onKeyDown, onKeyUp.
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328746
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfgrid
Using CF9 Developer edition version 9. 0. 0. 251028 Anyone else have issues with trying to insert more than one row in cfgrid? cfquery name=getOutcome datasource=#application.dsn# select * from l_outcomes /cfquery cfquery name=getSerious datasource=#application.dsn# select * from l_serious_criteria /cfquery cfset variables.outcome = valuelist(getOutcome.outcome) cfset variables.serious = valuelist(getSerious.serious_criteria) cfform name=event_form action=event_action.cfm method=post cfgrid format=html name=event selectmode=edit insert=yes delete=yes cfgridcolumn name=reported_terms header=Reported Terms cfgridcolumn name=onset_date header=Onset Date type=date mask=dMY cfgridcolumn name=outcome header=Outcome values=#variables.outcome# valuesdisplay=#variables.outcome# select=true cfgridcolumn name=abated_date header=Abated Date type=date mask=dMY cfgridcolumn name=serious_criteria header=Serious Criteria values=#variables.serious# valuesdisplay=#variables.serious# select=true width=600 /cfgrid /cfform I rather not have to build out all the ext for a new grid. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328614 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
Sorry for the poor explanation of my problem. This is always a new grid. There is no data I am binding. I do not create the store. I assume the CF server is creating the DataStore. I want the user to be able to add as many rows to the grid as they need. As of right now I am not making any DB calls. I type in what I want in the first row. I click 'insert' and a new row should be appended. This happens on the first click.The second time I click 'insert' I get a JS error. PS I used the term insert to stay true with the CF9 docs. I didn't mean a SQL insertion. On Mon, Nov 23, 2009 at 3:08 PM, Cutter (ColdFusion) cold.fus...@cutterscrossing.com wrote: Ah, yes. But, a complete ExtJs solution would be much more... OK, that (not) said, cfgrid does have problems with multiple insertions. Or, rather, it doesn't really deal with them well. When you insert a line, it gives the underlying Ext store record some default values. This includes the id, which could be either '0' or empty. Once you've posted back to the server, if you haven't updated that record with the id given at the server level, then the next time you attempt to insert a line... Well, you get the idea. What you might do is reload the data store after inserting to the server. This does hit the server again to reload your grid, but it also ensures correct data after it re-renders. Check out the Ext.grid.GridPanel and Ext.data.Store API's on the ExtJs site for more information. Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer Co-Author of Learning Ext JS http://www.packtpub.com/learning-ext-js/book _ http://blog.cutterscrossing.com Won Lee wrote: Using CF9 Developer edition version 9. 0. 0. 251028 Anyone else have issues with trying to insert more than one row in cfgrid? cfquery name=getOutcome datasource=#application.dsn# select * from l_outcomes /cfquery cfquery name=getSerious datasource=#application.dsn# select * from l_serious_criteria /cfquery cfset variables.outcome = valuelist(getOutcome.outcome) cfset variables.serious = valuelist(getSerious.serious_criteria) cfform name=event_form action=event_action.cfm method=post cfgrid format=html name=event selectmode=edit insert=yes delete=yes cfgridcolumn name=reported_terms header=Reported Terms cfgridcolumn name=onset_date header=Onset Date type=date mask=dMY cfgridcolumn name=outcome header=Outcome values=#variables.outcome# valuesdisplay=#variables.outcome# select=true cfgridcolumn name=abated_date header=Abated Date type=date mask=dMY cfgridcolumn name=serious_criteria header=Serious Criteria values=#variables.serious# valuesdisplay=#variables.serious# select=true width=600 /cfgrid /cfform I rather not have to build out all the ext for a new grid. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328623 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
NVM. I just reread your post and realized what you were trying to teach me. Basically, The user types data into the first row. I put that row into the DB. Update the datastore. Reload the Grid. then the user can click on insert again and a new row will be appended to the grid. Repeat as many times as necessary. On Mon, Nov 23, 2009 at 3:44 PM, Won Lee won...@gmail.com wrote: Sorry for the poor explanation of my problem. This is always a new grid. There is no data I am binding. I do not create the store. I assume the CF server is creating the DataStore. I want the user to be able to add as many rows to the grid as they need. As of right now I am not making any DB calls. I type in what I want in the first row. I click 'insert' and a new row should be appended. This happens on the first click.The second time I click 'insert' I get a JS error. PS I used the term insert to stay true with the CF9 docs. I didn't mean a SQL insertion. On Mon, Nov 23, 2009 at 3:08 PM, Cutter (ColdFusion) cold.fus...@cutterscrossing.com wrote: Ah, yes. But, a complete ExtJs solution would be much more... OK, that (not) said, cfgrid does have problems with multiple insertions. Or, rather, it doesn't really deal with them well. When you insert a line, it gives the underlying Ext store record some default values. This includes the id, which could be either '0' or empty. Once you've posted back to the server, if you haven't updated that record with the id given at the server level, then the next time you attempt to insert a line... Well, you get the idea. What you might do is reload the data store after inserting to the server. This does hit the server again to reload your grid, but it also ensures correct data after it re-renders. Check out the Ext.grid.GridPanel and Ext.data.Store API's on the ExtJs site for more information. Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer Co-Author of Learning Ext JS http://www.packtpub.com/learning-ext-js/book _ http://blog.cutterscrossing.com Won Lee wrote: Using CF9 Developer edition version 9. 0. 0. 251028 Anyone else have issues with trying to insert more than one row in cfgrid? cfquery name=getOutcome datasource=#application.dsn# select * from l_outcomes /cfquery cfquery name=getSerious datasource=#application.dsn# select * from l_serious_criteria /cfquery cfset variables.outcome = valuelist(getOutcome.outcome) cfset variables.serious = valuelist(getSerious.serious_criteria) cfform name=event_form action=event_action.cfm method=post cfgrid format=html name=event selectmode=edit insert=yes delete=yes cfgridcolumn name=reported_terms header=Reported Terms cfgridcolumn name=onset_date header=Onset Date type=date mask=dMY cfgridcolumn name=outcome header=Outcome values=#variables.outcome# valuesdisplay=#variables.outcome# select=true cfgridcolumn name=abated_date header=Abated Date type=date mask=dMY cfgridcolumn name=serious_criteria header=Serious Criteria values=#variables.serious# valuesdisplay=#variables.serious# select=true width=600 /cfgrid /cfform I rather not have to build out all the ext for a new grid. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328624 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
NVM. I just reread your post and realized what you were trying to teach me. Basically, The user types data into the first row. I put that row into the DB. Update the datastore. Reload the Grid. then the user can click on insert again and a new row will be appended to the grid. Repeat as many times as necessary. Thanks for the help. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328625 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
New book on the way? When I first learned EXT, about a year ago, your blog was goto reference. I'm not sure why I never bought your book but a new book would be on the top of my purchase list. Once again, thanks for the help. PS one of the reasons I'm avoiding a full EXT implementation is I need to purchase the commercial license. On Mon, Nov 23, 2009 at 4:17 PM, Cutter (ColdFusion) cold.fus...@cutterscrossing.com wrote: Right on the money! Man, that sounds so much easier than what I wrote ;) Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer Co-Author of Learning Ext JS http://www.packtpub.com/learning-ext-js/book _ http://blog.cutterscrossing.com Won Lee wrote: NVM. I just reread your post and realized what you were trying to teach me. Basically, The user types data into the first row. I put that row into the DB. Update the datastore. Reload the Grid. then the user can click on insert again and a new row will be appended to the grid. Repeat as many times as necessary. Thanks for the help. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328628 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfgrid
Hello, is cfgrid broken? the insert can't seem to add more than one row before it returns a uncaught exception: Multiple row insert is not supported error message. I would really like to avoid building out the grid in ext myself. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328358 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT - MySQL List
http://lists.mysql.com/ http://lists.mysql.com/Navicat is a good tool to use with MySQL. I think Sun/Oracle might still have their workbench tool. On Thu, Nov 12, 2009 at 3:49 PM, Duane Boudreau du...@sandybay.com wrote: Hi All, Anyone know of a good MySQL list? I have to take on a project that has a PHP/MySQL backend. Thankfully it's a short term thing as the entire site is getting migrated. In the mean time I need to find a tool similar to Enterprise Manager/SQL Studio for MySQL. Any suggestions? Thanks, Duane Boudreau, Chief Code Monkey Sandy Bay Networks 902 735 x222 ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328323 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfgrid + datetype
cfform name=event_form action=event_action.cfm method=post cfgrid format=html name=event_grid selectmode=edit insert=true autowidth=true cfgridcolumn name=reported_terms header=Reported Terms cfgridcolumn name=onset_date header=Onset Date type=date select=true cfgridcolumn name=outcome header=Outcome values=#variables.outcome# valuesdisplay=#variables.outcome# select=true cfgridcolumn name=abated_date header=Abated Date cfgridcolumn name=serious_criteria header=Serious Criteria values=#variables.serious# valuesdisplay=#variables.serious# select=true width=600 /cfgrid /cfform --- cfgridcolumn name=onset_date header=Onset Date type=date select=true Reading through the help files and I can't see why type date does not bring up a date selector since selectmode = edit. What am I doing wrong? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328277 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CGI Certificate Seral Number
We are having a problem where a client is sending some xml to an Web page and we are validating on the cgi.Cert_SerialNumber. When we dump the cgi structure in Coldfusion, Cert_SerialNumber is showing [empty string]. The client is insisting that they are sending the serial number. How can we prove whether they are or not? Can IIS tell us? Do we need some kind of third party sniffer? Any thoughts would be great. Thanks Lee S ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325263 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CGI Certificate Seral Number
Cancel that. We found a bad setting in IIS. We are having a problem where a client is sending some xml to an Web page and we are validating on the cgi.Cert_SerialNumber. When we dump the cgi structure in Coldfusion, Cert_SerialNumber is showing [empty string]. The client is insisting that they are sending the serial number. How can we prove whether they are or not? Can IIS tell us? Do we need some kind of third party sniffer? Any thoughts would be great. Thanks Lee S ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325265 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CGI Certificate Seral Number
Actually we are still having problems. That IIS setting was not the cure. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325266 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
XmlTransform and Iframe
I want to take the results of an xmlTransform and display it in an Iframe. As far as I can tell Iframe wants a source document and I don't want to go through the hassle of creating a file. Are there any work arounds for this? Lee ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320028 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
[OT] Data xfer from CD to DB
Hello CF gods. Quick question. I have a large data set which is delivered to me via CD every quarter. I need to get this data into a MySQL server. What are my options? I know I could probably do this via PERL or VB but it seems like a rather mundane task and something where a tool already exists. W ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319374 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: [OT] Data xfer from CD to DB
Hello CF gods. Quick question. I have a large data set which is delivered to me via CD every quarter. I need to get this data into a MySQL server. What are my options? I know I could probably do this via PERL or VB but it seems like a rather mundane task and something where a tool already exists. W I should also add that the format is somewhat odd. The data is supplied by Arbitron. I'm looking through one of their CDs now. I don't know what their policy is about posting their data so I can't post a sample until I find out for sure. A straight import won't work because each row isn't part of the same data set. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319376 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF7 to CF8 Encrpt Problem
We are having a problem upgrading from CF7 to CF8. It appears as though encrypted values stored in the database using CF7 are storing characters that are not playing well with the CF8 decrypt process. One example is the greater than sign (). If that character exists in the stored encrypted value, the decrypt process returns a null. Others include the question mark and parenthesis. We are using the following code. cfreturn encrypt(trim(arguments.string), request.encryption,'CFMX_COMPAT','Hex') / cfreturn decrypt(arguments.string, request.encryption,'CFMX_COMPAT','Hex') / Any thoughts on this? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316620 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RDS to Dev Box
We are in the process of upgrading to CF8 and I want to take advantage of the step debugging using CFEclipse. We have a Windows 2003 Standard Dev box setup using host headers for multiple users all inside a firewall. I installed the CF8 extensions for CfEclipse. When I go to preferences in Eclipse to set up the RDS it tells me it is unable to make the connection. I have gone to the CF Admin security section to give RDS a password. What am I missing? Are there special IIS settings we need to make? Thanks, Lee Surma ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315312 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: RDS to Dev Box
I found the answer here. You need to enable RDS on the server. The default is off. http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_17276 Lee Surma ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315318 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Is it possible to override that CF starts weeks on sundays?
This looks like you are trying to build a broadcast calendar. We used JavaScript to handle that on the front end w/ the week number. On the back end we reduce all date ranges to a startdate, enddate, and numDaysDiff. We eliminated the concept of weeks and months in the CF. We do have stored procedures that do handle weeks, like number of spots this week etc - but I don't know how they handled that. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315319 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
StructKeyExists() + dynamic names
We just upgraded from 7 to 8 and I'm getting some unexpected behavior with StructKeyExists. I'm pretty sure this worked before: cfif structkeyexists(arguments.myStruct,'dp' daypartID 'max')../cfif Now this always resolves to false no matter what. I can forward the CFDUMP of arguments.mystruct which I'm looking at right now and I clearly see keys of 'dp10max' etc. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315109 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: StructKeyExists() + dynamic names
structKeyExists(arguments.myStruct, variables['dp' daypartID 'max']) not sure i'd have expected the syntax you used to work (at least, not without an evaluate()). don't have any older versions available to test on tho. Bah sorry I posted this. My Co-worker came back and said the output was correct and as expected. Trying to debug this stuff through Ext is cumbersome. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315112 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cffile + cffunction
*Tried a search via HoF and it didn't return anything useful. I have a form page with an input type=file name=all On the action page, I would like to call a function that will upload the file. Unfortunately cffile assumes fileField is always a form field. So my function breaks with the error message: 14:10:10.010 - Application Exception - in /data/workspace/wlee/EMCSRADIO/Agency/createString.cfc : line 85 The form field arguments.MP3File did not contain a file. Anyone know a way around this? I also tried to create a structure named form with key all and set myStruct[all] = form.all and that doesn't work either. W ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314817 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cffile + cffunction
*Tried a search via HoF and it didn't return anything useful. I have a form page with an input type=file name=all On the action page, I would like to call a function that will upload the file. Unfortunately cffile assumes fileField is always a form field. So my function breaks with the error message: 14:10:10.010 - Application Exception - in /data/workspace/wlee/EMCSRADIO/Agency/createString.cfc : line 85 The form field arguments.MP3File did not contain a file. Anyone know a way around this? I also tried to create a structure named form with key all and set myStruct[all] = form.all and that doesn't work either. W I just realized I spelled cffunction incorrectly in the search box. Reading through those threads right now. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314820 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cffile + cffunction
Thanks for the quick replies.
I've fixed the problem and am going to share so other ppl don't have to waste
an hour like I did.
1) The form field name and the argument name do NOT have to be the same. I
named my input field all and my argument name MP3File.
2) When you pass the file name to the CFC you can NOT reference it by the form
scope.
cfinvokeargument name=MP3File value=all
3) In your CFC, you must put ## signs around the argument name in filefield.
cffile action=UPLOAD
destination=#expandpath('/UploadedFiles')#/MP3/#val(arguments.copyid)#
filefield=#arguments.MP3File# nameconflict=MakeUnique
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314825
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Using cfargumentCollection with cfajaxproxy
I used cfajaxproxy to create a JavaScript method, like so: cfajaxproxy cfc=account.InternalAccountManagement jsclassname=accountManager Then, within a script block, I have the following: var am = new accountManager(); am.setCallbackHandler(showUpdate); am.setErrorHandler(myErrorHandler); am.updatePerson(1,Doe,John); My InternalAccountManagement.cfc has a function named, of course, updatePerson, and it takes three arguments: personID, lastName, and firstName (declared in that order in the method). What I'd really like to do in my JavaScript block above is to take advantage of ColdFusion's argumentCollection parameter, and pass 1, Doe, and John within one argumentCollection, rather than passing them as three separate values in the am.updatePerson call. Is this possible? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311460 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Using cfargumentCollection with cfajaxproxy
Most excellent, Charlie! I had suspected that I might have to do something like what you suggested. Thanks so much! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311465 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Dynamic Code Execution
Try this
http://code.google.com/p/coldquery/source/browse/trunk/src/org/coldquery/UDFCreator.cfc
It doesn't execute the code, but it creates a udf from a string. Then you can
call the udf. The string can be cfml or script.
So an example using script would be:
cfscript
yourcfmlcode = {read your source from the db};
scriptfun = cffunction name='f' output='false';
scriptfun = scriptfun cfset var out='' /cfsavecontent variable='out';
scriptfun = scriptfun yourcfmlcode;
scriptfun = scriptfun /cfsavecontentcfreturn out //cffunction;
//Create a UDF from the string above
myudf =
createObject(component,org.coldquery.UDFCreator).createudf(scriptfun);
/cfscript
cfoutput#myUDF()#/cfoutput
Hi,
I'm not sure if this is possible or not. What I want to do is store
snippets of coldfusion code (for an email template) in a database. I
then want to take that database record, load it into a variable and
then have coldfusion process the variable as if it were code that was
written in a normal cfm template.
One way that I could do it is to write the code to a .cfm file (using
cffile) and then read that file back in via a cfinclude to be
processed as normal. However, I wish to avoid this solution if
possible.
An example:
In the database, this is the code that has been stored as text:
cfoutput
pDear #buyerrecord.getfirstname()#,p
pYour order has shipped. Your tracking number is #orderrecord.
gettrackingnumber()#/p
pThanks,/p
pYour friendly and highly attentive and customer-focused Customer
Service Representative/p
This will then be read into a variable (perhaps named
emailtemplatecontent) which I then wish to execute within cfmail
tags.
For example:
cfmail to[EMAIL PROTECTED].
#emailtemplatecontent#
/cfmail
Does anybody have any ideas? I've tried loading the variable into
cfsavecontent / variables but it doesn't seem to work. The code that
is stored in the database record gets output (literally) into the
email but the code doesn't get executed.
Any help would be greatly appreciated. I hope I've made the problem
relatively clear.
Thanks,
Tom
~|
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:306410
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Coldfusion 8 Install
I just installed MX8 (Multiple Server) configuration on our app server and need to configure the web server to communicate with coldfusion. In MX7 you could install the Web Server Configuration tool on the webserver through an installation process but in mx8 I do not see that installation option. How do you just install the web server configuration tool ONLY in mx8. Any help would be greatly appreciated. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297782 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Cybersource Gateway Solution Found For ColdFusion
Philip, If you are willing to share your code, please email me at [EMAIL PROTECTED] Thanks, JL Philip, I have just been asked to interface one of our apps with Cybersource. I would greatly appreciate any code that you have to share. Thanks. JL If anybody is interested I did find information on how to use ColdFusion to access the CyberSource Credit Card Gateway. I'll be happy to send you my sample code if you need it. Works like a charm. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297419 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Cybersource Gateway Solution Found For ColdFusion
Philip, I have just been asked to interface one of are apps with Cybersource. I would greatly appreciate any code that you have to share. Thanks. JL If anybody is interested I did find information on how to use ColdFusion to access the CyberSource Credit Card Gateway. I'll be happy to send you my sample code if you need it. Works like a charm. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297100 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Trigger Question
I'm doing an update trigger that is doing a bunch of convoluted stuff to update a pseudo warehouse table. All I care about passing to the trigger code is the ID of the record being updated. I'm doing something like this. Set Blah blah blah where Table_ID = (Select Table_ID from inserted) I've heard that inserted can contain more than one record. If so the above could obviously fail in a nasty way. Is that correct and if so what would be the way to do this? Lee Surma ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296738 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Trigger Question
On Thu, 17 Jan 2008 11:04:46 -0500 Sonny Savage [EMAIL PROTECTED] wrote: Change the statement to: Set Blah blah blah where Table_ID IN (Select Table_ID from inserted) I don't think that will work. The code needs to handle every record that is changed. The following is a better sample of what I'm doing. DECLARE @ccc_id varchar(50), Select @ccc_id=ccc_id FROMSource_Table where Table_ID IN (Select Table_ID from inserted) Update Warehouse_Table set [EMAIL PROTECTED] where Table_ID IN (Select Table_ID from inserted) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296752 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Trigger Question
Which database? Before or after trigger? Per row or per statement trigger? Jochem MS SQL 2000 After Per Row ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296755 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Trigger Question
Oops it looks like this. Pre IN statement. DECLARE @ccc_id varchar(50), Select @ccc_id=ccc_id FROM Source_Table where Table_ID = (Select Table_ID from inserted) Update Warehouse_Table set [EMAIL PROTECTED] where Table_ID = (Select Table_ID from inserted) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296754 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Cffile Write Problem
Thanks we open up the rights and it is still occurring. The Network guys think it is a CFfile timeout issue which apparently cannot be controlled. On Thu, 6 Dec 2007 17:42:44 -0500 (GMT-05:00) James Blaha [EMAIL PROTECTED] wrote: Hi Lee, You need to make sure that the service the ColdFusion application server runs under has rights to that UNC path. Give that a try. -Jim ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294387 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Cffile Write Problem
We are having a problem writing files. When we send the files locally to the Web server it works fine. When we change the path to our SAN occasionally a couple files get through but most throw an error like the following. An error occurred when performing a file operation write on file \\ksdsan01\ksdPDF\QA\2985481_A_7840.PDF. Application The cause of this exception was: java.io.FileNotFoundException: \\ksdsan01\ksdPDF\QA\2985481_A_7840.PDF (Access is denied). Because some files do get through I'm doubting that it's an access problem as the error states. Is there a built in timeout in cffile write? Lee Surma ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294314 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Next lowest number from array (or list).
My faith would be even more increased if there were not unnecessary pound signs in the if statements. On 10/3/07, Jayesh Viradiya [EMAIL PROTECTED] wrote: Hey Good Asha...One suggestion would be to add Adobe CF Team in your signature. Let CF community know that CF India Team is doing good in participating in public ForumsIt helps increase their faith in us. -Original Message- From: Asha K S [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 03, 2007 5:54 AM To: CF-Talk Subject: RE: Next lowest number from array (or list). Another solution could be Here value would be input from the user. cfset l=32,48,64,72,144,160,200,288,320,400,512,576,640,720,800 cfset len=#ListLen(l)# cfif #value# LT 32 cfset res=32 cfelseif #value# GT 800 cfset res=800 cfelse cfloop index=i from=1 to=#len-1# cfset k=ListGetAt(l,i) cfset q=ListGetAt(l,i+1) cfif #value# GT #k# AND #value# LT #q# cfset res=#k# cfelseif #value# EQ #k# cfset res=#k# cfelseif #value# EQ #q# cfset res=#q# cfelse /cfif /cfloop /cfif cfoutput#res#/cfoutput Thanks, Asha. -Original Message- From: William Seiter [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 03, 2007 1:04 PM To: CF-Talk Subject: RE: Next lowest number from array (or list). Depending on deployment and expected usage, I would suggest adding an 'if' statement around the loop to Dale's code in order to check if the arguments.value is greater than 32. This will reduce the 'if' statement inside the loop to only 1 value check, allowing for a cfbreak to be added as an 'else' statement. cfif arguments.value gt local.return cfloop index=local.index list=#arguments.list# cfif local.index lt arguments.value cfset local.return = local.index / cfelse cfbreak /cfif /cfloop /cfif This will allow the function to not perform the loop in the case of the default value of local.return being the only 'true' value to return. It will also allow the loop to stop running the moment a 'true' value is found. In a small deployment, this won't mean a thing, but in a large scale deployment anticipating a lot of use, the milliseconds saved can be valuable. Just my 2 cents William -- William E. Seiter Have you ever read a book that changed your life? Go to: www.winninginthemargins.com Enter passkey: goldengrove -Original Message- From: Dale Fraser [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 02, 2007 10:09 PM To: CF-Talk Subject: RE: Next lowest number from array (or list). cfset myList = 32,48,64,72,144,160,200,288,320,400,512,576,640,720,800 cfoutput#getNextLowest(myList, 12)#/cfoutput cffunction name=getNextLowest returntype=numeric cfargument name=list type=string required=true / cfargument name=value type=numeric required=true / cfset local = structNew() / cfset local.return = 32 / cfloop index=local.index list=#arguments.list# cfif local.index lt arguments.value and local.index gt local.return cfset local.return = local.index / /cfif /cfloop cfreturn local.return / /cffunction Regards Dale Fraser http://learncf.com -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Wednesday, 3 October 2007 3:20 PM To: CF-Talk Subject: Next lowest number from array (or list). Say that I have a list of allowed nmbers: 32,48,64,72,144,160,200,288,320,400,512,576,640,720,800 If I give the user the option of selecting a number, and it happens to not be in this list, how might I go about automagically selecting the next lowest number? One exception being if the user selects a number lower than 32, in which case the code should return 32. Examples: User selects 100, the code would return 72. User selects 480, the code would return 400. User selects 25, the code would return 32. Currently the numbers are stored in a simple list, but I have control over that list and they can be in whatever format makes the most sense. One caveat is that they need to stay in code (so no database interaction). ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290099 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Next lowest number from array (or list).
That was kind of my point. Pound signs within IF/ELSE/ELSEIF statements are wholly unnecessary and are, to me at least, somewhat indicative of a person who doesn't understand how ColdFusion processes variables. Not meant as harshly as it sounds, I promise, but might be a useful thing to remember . I don't think it is necessary to put pound signs around your variables until and unless you need to print them on the screen. You can try removing them from the code given by Asha. ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290106 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Report Builder vs. JasperReports/iReport
Microsoft SQL Reporting Services is free with SQL and it is a lot like Crystal. You use Visual Studio as the report builder and it works well and ports to the Web. The only problem is that I have yet to hear about anyone using ColdFusion to display the reports on CF Web pages. On Thu, 23 Aug 2007 15:21:45 -0500 Christopher Jordan [EMAIL PROTECTED] wrote: Hi folks, I'm in need of a visual report builder. Can anyone tell me if they have experience with either Adobe's Report Builder (which I've downloaded and played with a little bit) or Jasper Reports/iReport? We're up in the air over using PHP or CF. I'm pushing CF and my boss is pushing PHP (*sigh*). He's also insistent on being able to build the report visually, like he does in Fox Pro, or like using Crystal (except that's too expensive). I almost think I've got him convinced that we need to use CF, but he's pushing back hard on me to come up with reasons why we can't use PHP (not really why CF would be better, but why PHP would be worse/slower). I've already mentioned to him that Jasper is written in Java and that CF can talk natively to all the objects, and that to do the same in PHP requires a third party (all be it open source) PHP/Java bridge, and then jumping through several hoops. This only turned him off to the idea of JasperReports, not to the idea of using PHP. Any information on how folks are typically generating complex reports (visually) would be great. Heck any help in general would be fantastic. Thanks, Chris -- http://cjordan.us ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286994 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Report Builder vs. JasperReports/iReport
I know SQL Reporting Services is suppose to use Web Services to do a lot of what you are asking. It's fairly straight forward to set up the internal Report Manager Server and view internal reports through a Web browser. Integrating them into a live Internet facing Web site is what I also need to learn. On Thu, 23 Aug 2007 15:45:48 -0500 Christopher Jordan [EMAIL PROTECTED] wrote: Thanks for responding Lee. What about using Microsoft SQL Reporting Services with PHP? See, I've never used Crystal or anything like it, so all this is pretty new to me. I'm unsure of how I connect my web app to a report template or skeleton (for lack of better terms). How do I call the report? How do I feed it data? I'm a bit lost in this respect no matter which report builder I end up using. So if you have thoughts on those sorts of questions, I'd love to hear them. Thanks heaps, Chris ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286999 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
SQL Reporting Services
OK I have done all my home work and searched the archives of this list and the Internet. I need to find a simple example of a CF page calling a SQL Server 2005 Reporting Services report. I'm fairly certain that it requires a Web service. Are there any examples out there? Is anyone doing this? Lee Surma ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286696 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Can't get CF8 to read EXIF from .jpg on Remote server
Hello, Using CF8 I'm building a app for a client that needs to retreive EXIF data from .jpg files not local to the CF server. Using the following code... 1 CFset photoURL=http://www.foo.com/photo.jpg; 2 CFimage Source=#photoURL# action=read name=photo 3 CFSET PhotoEXIF=ImageGetEXIFMetadata(photo) 4 CFDUMP var=#PhotoEXIF# Processing stops at line 3 and CF8 spits out Exception occured in JPG processing. segment size would extend beyond file stream length When I attempt to get around this issue by writing the image out to a temp file using the following 1 CFset photoURL=http://www.foo.com/photo.jpg; 2 CFimage Source=#photoURL# action=write overwrite=yes destination=\phototemp.jpg 3 CFimage Source=\phototemp.jpg name=photo 4 CFSET PhotoEXIF=ImageGetEXIFMetadata(photo) 5 CFDUMP var=#PhotoEXIF# This executes, but the CFDump returns an Empty struct After looking at phototemp.jpg as written by CF8 I find it does not contain any EXIF data. I've also tried retrieving the .jpg using CFHTTP and the EXIF is lost that way as well. Has anyone gotten this to work? Any ideas? Thanks. ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285556 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
No Debug Access, Tricks for getting some kind of debug info?
Do you have anything that would help someone who can't turn on debugging? I'm on a shared server with no access to the administrator and could use any tricks I can find to get as much info into a make-do deug template as I can. Obviously I can dump all the variable scopes manually. Any other tricks would be lovely. Server is MX 7. On 7/25/07, Michael Dinowitz [EMAIL PROTECTED] wrote: If you have debug access I have an enhanced debug template that shows the full flow of an application. It includes standard templates, components, custom tags and includes in a full tree view. ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284615 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
XML Insert Problem
We are having trouble inserting a line into XML when using straight string manipulation it blows up on XML Search. We are guessing that there is a better way to insert the line. Details below. The existing XML structure shows (partial XML is noted in the examples below and does not represent the entire xml document): ClientReferences IdValue name=ClientReferenceField2_Valuecrf2/IdValue /ClientReferences We wish to add another IdValue node before the ClientReferenceField2_Value attribute as follows: IdValue name=ClientReferenceField1_Valuecrf1/IdValue The resulting XML structure would show: ClientReferences IdValue name=ClientReferenceField1_Valuecrf1/IdValue IdValue name=ClientReferenceField2_Valuecrf2/IdValue /ClientReferences The full Xpath to ClientReferences is as follows: /BackgroundCheck/BackgroundSearchPackage/Screenings/ClientReferences Notes: - Assume the existing XML document is in a ColdFusion structure through the use of XmlParse() - The resulting XML should be maintained as a ColdFusion structure that will allow Xpath searches using XMLSearch() ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284541 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: The Texas Real Estate Site
A few months ago, I saw and app someone (in Texas I think) had developed that allowed you to search county real estate data.. this app was Flex/CF powered.. but I can't find it now... Anyone remember this app and know where it is? Maybe this one, http://www.asfusion.com/projects/home-locator/ ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284455 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How do I properly check for an empty string?
I would suggest adding a trim function to catch spaces and see if that helps. cfif len(trim(instructorid)) On 7/19/07, Will Tomlinson [EMAIL PROTECTED] wrote: I'm tryin to check and see if some fields have any data in a spreadsheet, using Ben's POI utility. cfif Len(instructorid) AND Len(lastname) AND Len(firstname) AND Len( URL.EID) Add data to the db cfelse Build a query in cf memory of bad data /cfif The problem is, empty strings are slippin thru and I end up with rows of empty strings. Then my process bombs out because it tries looping over these empty string columns and can't find an index. How can I either make sure no empty strings build rows, or either delete rows from my query in memory where all columns are empty strings? Hope this makes sense. :) Thanks, Will ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284094 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Virtual Servers
Has anyone had any luck running CF 6 on a Widows Virtual Server with about 400K hits per day? Lee ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282552 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Virtual Servers
I failed to mention they are also trying to cluster it. Jrun starts running up the memory and then the CPU starts pegging at 100%. On Sat, 30 Jun 2007 00:31:35 +1000 Andrew Scott [EMAIL PROTECTED] wrote: What problems are you having? On 6/30/07, Lee [EMAIL PROTECTED] wrote: Has anyone had any luck running CF 6 on a Widows Virtual Server with about 400K hits per day? Lee ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282561 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
editing session variables
Hi, I want to edit the values of someone else's session variables. I have a session variable named session.user.isLoggedIn. I want to set it to 0. I have the session.sessionID. The reason I want to do this is because I want to be able to close my old session when I log in from another computer. The scenario is this. I log into computer A and my sessionID is MyApp__1. I forget to log off and go home. I input my username and password. The system tells me that I'm already logged on and asks me if I want to close my old session. If I click on Yes, the system will query the DB and based on my userID it will return my old sessionID. At the very least I want to change my session.user.isLoggedIn = 0 for sessionID MyApp__1. Afterwards the system will log me and create a new sessionID, MyApp__2 or some other ID. TIA, Won ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277663 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
