Re: OLE DB and Maintain Connections
Wednesday, January 15, 2003, 4:26:21 PM, you wrote: IL Hi all, IL We've got a server that's suddenly become very cranky - running slowly, IL hanging, etc. 3-4 times per day. When you say hanging, do you mean the CF process, or the entire machine? If the entire machine is locking, then it's probably not a software issue at all, or it's a Windows problem. What does the CPU load look like before it crashes? IL The hosting company told us that we should: IL 1. Uncheck 'maintain database connections' for all ODBC datasources. This is flat wrong for anything other than Access, and performance will suffer greatly. Maybe it would help isolate an odd odbc driver issue but that seems unlikely. IL 2. Only use OLE DB for MSSQL datasources. MS has been trying to push the world to OLEDB for a while now. Other than that, I can't say. IL Both of these seem counterintuitive to me - OLE DB is buggy as all get IL out, and I've always been told that 'maintain database connections' is IL a performance enhancer, not a drag. IL We're using CF 4.5.1 - traffic levels are about what they've always IL been, and all session/app vars are appropriately locked. IL Any input? Have you examined the logs to see if anything obvious jumps out, like on template in particular running before the crash, or a particular template hanging a thread consistently? Usually I need both the web logs and the cf logs side by side to get a good picture of what is going on. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MS Outlook Calendar - Pulling Data
I do believe it is called either PUB.edb or PRIV.edb PUB.edb is the Public Folders, and PRIV.edb is the individual mailboxes of the users accounts good luck trying to get access to it/them. I dont remember which directory Exchange puts them in, but you can do a search/find. depending on the number of users with exchange accounts and the sizes of their mailboxes the PRIV.edb could be huge. I have a very small exchange server (10 users) and the PRIV.edb is 700+MB Jon Moneymaker Fleet and Family Support Center, Yorktown Computer Specialist -Original Message- From: Kennerly, Rick H CIV [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 14, 2003 8:59 AM To: CF-Talk Subject: MS Outlook Calendar - Pulling Data I'm still trying to find the DB in the exchange server. Anybody have any tips for pulling data from MS Outlook Calendar for use in a scroller? Is it even possible? Rick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How to handle Calendar Scheduling of Recurring Events?
I wrote an app that allows the user to enter a start date, and an end date the code then calculates the number of days between those date (inclusive) and then uses that number to create calendar dates for a particular event (leave or training). It also subtracts out weekends (sat and sun) for display purposes. It's kinda crude (I am fairly new to CF) and the code looks U.G.L.Y...but it does work. Jon -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 14, 2003 9:33 AM To: CF-Talk Subject: RE: How to handle Calendar Scheduling of Recurring Events? I am not sure, I am waiting on WebGuy's solution. -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED]] Sent: 14 January 2003 14:25 To: CF-Talk Subject: RE: How to handle Calendar Scheduling of Recurring Events? Rick: One way I did it in a previous application was to have the person select the duration of the event...If it was a single day event, the start date end date were the same in the DB. Then, in the field below, I would ask what days it occurs on (ie. Monday, Tuesday, etc.) The values for each check box were the numerical values of the day of the week. Then, when the calendar processes, it checks each day that it's displaying if there are any events...It would then find that all those days there might be something to display. Then check to be sure that the current day it's processing is selected for weekdays. Let's say the event went from 1/6/03 to 1/13/03 and the user select M,W,F. The way I had the calendar setup was that for each day it would search the database...So for 1/1, call to the db check for events, 1/2, call to the db check for events, etc. Once it got to 1/6, it would see that there's an event that it might be able to display...Then it checks the weekday values and sees that the 6th is a Monday and falls within what the user defined...Then onto 1/7...it would then find that it does fall within the time span, but Tuesday's not listed...And so on... Did I confuse anyone? If there's a better way to do this, I'd love to hear HTH, Scott -Original Message- From: Rick Faircloth Sent: Tue 01/14/2003 09:06 AM To: CF-Talk Cc: Subject: How to handle Calendar Scheduling of Recurring Events? Hi, all. I was wondering about the various approaches that have been taken to scheduling recurring events in a calendar? I haven't worked with auto-insertion of recurring events, but now is the time for my calendar creation to become more sophisticated. Should I insert data for one-time events in one table and data for recurring events in another with the user specifiying daily, weekly, monthly, quarterly, yearly, etc...and have code that checks that table and auto-inserts those events when the day/dates are checked? How would I handle the City Council meeting that is scheduled on the 2nd Tuesday of each month. Would I have the person inputting the data fill out or check fields for 1st, 2nd, 3rd, etc., then Tuesday, Wednesday, etc., each Week, Month, Year or whatever? (That could get really complicated...) Just let them handle that kind of insertion manually? Perspectives? (If anyone knows of any tutorials that address this subject, a link would be most appeciated!) Thanks, and good morning! Rick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MS Outlook Calendar - Pulling Data
oh geez, what a killjoy lol... but he is right... does not take much to corrupt them (speaking as the Exchange admin, and from experience) will make you very unpopular with your users who have made the PRIV.edb what it is. Jon -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 14, 2003 10:23 AM To: CF-Talk Subject: RE: MS Outlook Calendar - Pulling Data I do believe it is called either PUB.edb or PRIV.edb PUB.edb is the Public Folders, and PRIV.edb is the individual mailboxes of the users accounts good luck trying to get access to it/them. I dont remember which directory Exchange puts them in, but you can do a search/find. depending on the number of users with exchange accounts and the sizes of their mailboxes the PRIV.edb could be huge. I have a very small exchange server (10 users) and the PRIV.edb is 700+MB For the love of all that's holy, please, please don't touch these files directly. If you do, your Exchange server administrator will be forced to kill you slowly, and even so, your fate will be better than you deserve. The EDB files are exclusively locked by Exchange anyway, so you'd have to stop the Information Store service to get to them, and people would probably start complaining then about not being able to use Outlook. If you want to access Exchange data, do it through the Exchange API. That's why it has an API. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: WOT: MySQL in the Enterprise
postgreSQL is a pretty nice, opensource alternative to mysql if you need a more feature-rich db backend. I use mysql, I use microsoft sql. At least in my opinion, both have their place, depending on what it is you're up to. I've gotta say though, for 99% of what I do, mysql handles my needs perfectly. 'Course, I'm doing mostly insert, delete, update, select... nothing too complicated. I'll be very happy when the next version comes out that can do subqueries, though. -- jon -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 14, 2003 4:50 AM To: CF-Talk Subject: Re: WOT: MySQL in the Enterprise Paris Lundis wrote: As far as I am concerned Oracle is a big hunk of overpriced (read too dam* expensive) crud... sure if you are a bank or some other oversized monstrosity it is for you... all 5% of the total businesses if even that... The only reasonable number that I can think of to relate the price of a database to is the price of all the data it contains. Since for most corporations it would mean going out of business if they loose their data, paying something like that is an easy choice. Anyway... MySQL is just marvelous from here... fast, small, easy to manage... great cost - even if you are paying / licensing for real... If it has the features you are looking for it is probably the best choice. Personally, I can not imagine a single case where I would want a relational database without for instance full referential integrity. If it really is not that important to maintain the relations between your data, why store it in a relational database at all? Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
transactions and multiple datasources
I have a set of db inserts involving two datasources and if there is a failure in the 2nd datasource, I need to roll back the transaction on the first datasource. In a perfect world I could somehow hold up the first transaction commit until the transaction on the second datasource has completed successfully and then commit them both. However I'm not sure how to do this with cftransaction since it throws an error if multiple datasources are used. Doing the transaction in just SQL might be doable, but I would like to avoid that if at all possible, because the amount of re-engineering that would be necessary. Anyone have a suggestion? -- jon mailto:[EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: transactions and multiple datasources
Yeah, that's actually what I am doing, if the first fails, no need to do the second one at all. The problem lies in that when the second query fails, I need to roll back the first. -- jon mailto:[EMAIL PROTECTED] Thursday, January 9, 2003, 3:27:33 PM, you wrote: MA According to Mastering ColdFusion 5: MA Within a transaction block, you can write queries to more than one database; however, you must commit or rollback the transaction to one database before writing a query to another database. MA Not what you want to hear I'm sure, but sounds like it can't be done the way you want. MA As a possible wordaround (this is just a shot in the dark and might not be possible), maybe either setting some variable on success of the first query and using a cfif to decide whether to do the MA second one, or using cftry/cfcatch, or a combination of the 2? MA ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Test CSV
I did the same thing not to long ago, importing emails from an ACT exported list. I ended up using reading the uploaded file via an ODBC Text DSN. This lets the ODBC driver handle any corrupted data, and turns the csv into a query automagically. All I did was manually create a ODBC Text DSN to get the schema.ini format, and proceeded to write the below function to handle creating text dsns on the fly. cffunction name=cvsToQuery returntype=query cfargument name=filename type=string cfset var schemaFile = E:\emailman\emailUpload\schema.ini !--- Make sure dsn name hasn't been created already --- cfif len(trim(getProfileString(schemaFile, arguments.filename, ColNameHeader))) EQ 0 cfset rs = setProfileString(schemaFile, arguments.filename, ColNameHeader, False) cfset rs = setProfileString(schemaFile, arguments.filename, Format, CSVDelimited) cfset rs = setProfileString(schemaFile, arguments.filename, MaxScanRows, 0) cfset rs = setProfileString(schemaFile, arguments.filename, CharacterSet, OEM) cfset rs = setProfileString(schemaFile, arguments.filename, Col1, CUSTNAME Char Width 255) cfset rs = setProfileString(schemaFile, arguments.filename, Col2, CUSTREP Char Width 255) cfset rs = setProfileString(schemaFile, arguments.filename, Col3, CUSTEMAIL Char Width 255) /cfif cfquery datasource=textsource name=textqry SELECT * FROM [#arguments.filename#] /cfquery cfreturn textqry /cffunction -- jon mailto:[EMAIL PROTECTED] Tuesday, January 7, 2003, 5:27:11 PM, you wrote: PK I have a CSV file that I want to read into variable (see below). Before PK doing so I think I should test the construction of the file to ensure that PK its valid otherwise I think there is a risk of the process falling over if PK it encounters a badly constructed file somewhere a long the way. How can I PK test that a file is a validly constructed CSV file. It will contain e-mail PK addresses exported from ACT. PK TIA!!! PK cffile action=READ file=loop.txt variable=LoopVariableName ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: custom tag: pair of list boxes with transferring
Unless you really want this in custom tag format, I'd suggest using this one. It's got a lot of nice helper functions, is well written js, and is free. http://www.mattkruse.com/javascript/optiontransfer/ -- jon mailto:[EMAIL PROTECTED] Wednesday, January 8, 2003, 12:45:05 PM, you wrote: CM Hi. I think there is a custom tag out there that allows me to do what I CM want, but I don't know what words to use to search for it. Here is what it CM should do: create a pair of listboxes, with a pair of buttons in between. CM The idea is to transfer items from one listbox to the other. This typically CM is used to add items from the left list to the right list or remove CM items from the right list (thereby sending them back to the left list). CM Anyone know the name of this tag, assuming it exists? CM Thanks, CM Matthieu ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFFILE Workarounds?
Depending on the version of CF and OS, different ways would be preferable. Assuming they haven't disabled cfobject though, using the Scripting.FileSystemObject (GetFile() or OpenTextFile()), or java.io.FileReader will both work. http://java.sun.com/j2se/1.4/docs/api/java/io/FileReader.html http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbenlr98/html/vamthgetfile.asp I have some code examples for both methods somewhere. If you would want to see them let me know. -- jon mailto:[EMAIL PROTECTED] Tuesday, January 7, 2003, 4:57:00 AM, you wrote: RB I can use CFExecute on my host. But the file I create I need to read it RB into a variable, but CFFILE does not seem to work as it throws an error RB saying it exceeded the allotted time limit, so I am guessing they shut RB this off, but kept CFExecute. Well, here is my question: Can I read the RB contents of this file into a variable without using CFFile? RB Robert Bailey RB [EMAIL PROTECTED] RB Famous for nothing! RB http://www.tinetics.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
whats a black line around my cfdumped query mean?
I serialized my query object (recordset) to wddx. Later, I read it in and need to CFOUTPUT over it again. For some reason, CF doesn't see it as a native query and when I cfdump it, its got a black line going around the outside of the table. How do I get my deserialized query to work like a native query again? Thanks, Jon ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: whats a black line around my cfdumped query mean?
Doh!... I just realized my deserialization tag wasn't set up right. Thanks anyway, Jon -Original Message- From: Jon Block [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 07, 2003 11:31 AM To: CF-Talk Subject: whats a black line around my cfdumped query mean? I serialized my query object (recordset) to wddx. Later, I read it in and need to CFOUTPUT over it again. For some reason, CF doesn't see it as a native query and when I cfdump it, its got a black line going around the outside of the table. How do I get my deserialized query to work like a native query again? Thanks, Jon ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: New Mac Browser
It uses the KHTML rendering engine, which appears in my professional opinion...to suck. Luckily it looks like they also are apparently spoofing the browser by default (as NS5), so it will never show up in server logs, and we can safely pretend it doesn't exist. http://developer.kde.org/documentation/library/kdeqt/kde3arch/khtml/ The KHTML docs speak for themselves, but I will highlight :) KHTML provides a (almost) complete implementation of Dom Level 1. Cascading style sheets Level1 are mostly supported now. In other words, they are (almost) mostly ready to compare favorably with Netscape 4... -- jon mailto:[EMAIL PROTECTED] Tuesday, January 7, 2003, 2:38:35 PM, you wrote: AJ I'm elated, but at the same time sick to my stomach. After years we AJ finally got ie and netscape to render damn near close to identical. AJ Please tell me this meets all w3c standards. Btw, anyone know if a JVM AJ is built in? AJ Adam Wayne Lehman AJ Web Systems Developer AJ Johns Hopkins Bloomberg School of Public Health AJ Distance Education Division AJ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: New Mac Browser
I hope so...but I feel the same way Ben does about them not using Gecko. They have quite a few excellent Gecko specific tutorials one their developer site even. -- jon mailto:[EMAIL PROTECTED] Tuesday, January 7, 2003, 3:39:44 PM, you wrote: DA Ahh, but... They started with the KHTML engine, rewrote much of it, and DA are publishing their rewrite as open-source. DA They did the same thing with parts of the JVM. DA So, everyone (potentially) benefits. DA Dick DA On Tuesday, January 7, 2003, at 12:25 PM, jon hall wrote: It uses the KHTML rendering engine, which appears in my professional opinion...to suck. Luckily it looks like they also are apparently spoofing the browser by default (as NS5), so it will never show up in server logs, and we can safely pretend it doesn't exist. http://developer.kde.org/documentation/library/kdeqt/kde3arch/khtml/ The KHTML docs speak for themselves, but I will highlight :) KHTML provides a (almost) complete implementation of Dom Level 1. Cascading style sheets Level1 are mostly supported now. In other words, they are (almost) mostly ready to compare favorably with Netscape 4... -- jon mailto:[EMAIL PROTECTED] Tuesday, January 7, 2003, 2:38:35 PM, you wrote: AJ I'm elated, but at the same time sick to my stomach. After years we AJ finally got ie and netscape to render damn near close to identical. AJ Please tell me this meets all w3c standards. Btw, anyone know if a JVM AJ is built in? AJ Adam Wayne Lehman AJ Web Systems Developer AJ Johns Hopkins Bloomberg School of Public Health AJ Distance Education Division ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFFILE Workarounds?
Just had a thought...if cfobject is disabled, you could try getting the more command via cfexecute to read a text file too... -- jon mailto:[EMAIL PROTECTED] Tuesday, January 7, 2003, 4:57:00 AM, you wrote: RB I can use CFExecute on my host. But the file I create I need to read it RB into a variable, but CFFILE does not seem to work as it throws an error RB saying it exceeded the allotted time limit, so I am guessing they shut RB this off, but kept CFExecute. Well, here is my question: Can I read the RB contents of this file into a variable without using CFFile? RB Robert Bailey RB [EMAIL PROTECTED] RB Famous for nothing! RB http://www.tinetics.com RB --- RB [This E-mail scanned for viruses] RB ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Recursive UDFs ?...
How about calling the UDF with an extra parameter only when you do the recursive call? Then test the length of the arguments array to see if the function was called by itself or from outside? -- jon mailto:[EMAIL PROTECTED] Monday, January 6, 2003, 9:17:31 AM, you wrote: TS Is there a way to tell if you are calling a recursive UDF from within the UDF? So that I could figure out from within my UDF that the UDF is being called by itself...hopefully this question TS makes sense...TIA- TS Tyler ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Anybody have a UDF that will sort a structure on it's values?
I want to loop over a structure that I have but in a specific order. The values of my structure are integers so I want to start with the highest number first and go from there decending. Anybody have a good UDF for this? Thanks, Jon ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Anybody have a UDF that will sort a structure on it's values?
Exactly - I need the values to spit out like records in a record set. When I use structSort, I lose the values and get an index like 1,2,3,4 rather than my original strucure values. I guess I'll just create a tag that magically turns the structure into a custom recordset object which will simplify my life. Given all the things I'm trying to do in this page load, this will be the best way to go for me. Thanks, Jon -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Monday, January 06, 2003 4:47 PM To: CF-Talk Subject: Re: Anybody have a UDF that will sort a structure on it's values? Do you mean that the values of the structure are integers, or the keys of the structure are integers? If the latter, then StructSort, as someone else had mentioned, would probably do it. It will return an array. Then you'll have to loop over the array, sending the current array value as the key to the structure in your processing code. However, that is technically not ordering the structure; merely processing elements inside the structure in a specific order. By there very nature structures are unordered. In most cases, I doubt it makes a difference. I might ask the question if you should you be using an array instead of a structure? At 04:26 PM 1/6/2003 -0500, you wrote: I want to loop over a structure that I have but in a specific order. The values of my structure are integers so I want to start with the highest number first and go from there decending. Anybody have a good UDF for this? Thanks, Jon ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Page context
I hadn't extended it to the page context, but I do something similar for my customer object. I have a structure called 'contextInfo' that is sort of a dumping grounds for any information that applies to the customer for a page or two only. Extending the idea to the page context would seem like a good idea to me. -- jon mailto:[EMAIL PROTECTED] Thursday, January 2, 2003, 12:27:28 PM, you wrote: JH Ok, this might sound weird, but I'm thinking of building something I'd JH call a page-context. JH The idea is that on certain pages one needs to have a lot a variables JH that you load once, from a database or file and then use pretty often. JH You can manually cache these variables in the application scope, but I JH was looking for something more specific. An example of such data might JH be: a default sort order, l10n texts etc. JH So this would work like a normal client or session variable, but these JH variables would be unique for each page (haven't though about includes JH yet, but they may have their own page context too). I'm working on a JH simple system that stores these variables in-memory in either the JH application or the server scope, but I'd rather not use any of those. JH Another option would be to create a java object that can be referenced JH statically to get to these variables (haven't worked that out either). JH Then appart from the default page data there might be user specific paga JH date like the users preferred sort order, last 10 entered search JH keywords etc. One could store these in the clientscope or the session JH scope, but then these would be accessible from any other page aswell. So JH in this case there would be a pageSession and a pageClient scope to JH handle these kinds of data. JH I haven't worked out the details yet, but I'm open for any ideas, pros, JH cons etc. JH Jesse JH ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: INPUT = FILE
Only in IE because of it's support for the click() method on anything. You have to create a hidden input type file, and a normal button and textbox... input type=file name=nameFile onchange=this.form.nameText.value=this.value style=display:none; input type=button name=nameButton value=Browse onclick=this.form.nameFile.click() input type=text size=70 name=nameText -- jon mailto:[EMAIL PROTECTED] Tuesday, December 31, 2002, 12:52:34 PM, you wrote: RBA Is there anyway to assign a class file to the BROWSE button RBA on an input type of FILE? RBA Maybe you can and I am just not with it today to find out how. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: Restore a backup over a current SQL Dbase
I assume you mean to a different server, if same server just use enterprise manager wizard. First Step - get database name: restore filelistonly from disk = 'c:\backup.bak' Second Step: restore database dbname from disk = 'c:\backup.bak' with move 'dbname_Data' to 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\dbname.mdf', move 'dbname_Log' to 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\dbname.ldf' -- jon mailto:[EMAIL PROTECTED] Tuesday, December 31, 2002, 4:56:04 PM, you wrote: RJS How do you restore a .BAK file over a current Database in SQL SERVER 2000? RJS Joy ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Cold Fusion forum (OPEN SOURCE?)
Not too many, these days... and compared to the # of hosts that support CF? -- jon -Original Message- From: Cutter (CF_Talk) [mailto:[EMAIL PROTECTED]] Sent: Friday, December 27, 2002 9:44 AM To: CF-Talk Subject: Re: Cold Fusion forum (OPEN SOURCE?) I can think of one good reason...Some hosts do not support PHP. Cutter jon roig wrote: I hear you, Adrocknaphobia... there really isn't a perfect forum system out there. (I've been running online forums for several years, most recently for a large non-profit website...) That said, PhpBB comes pretty darn close... and it's because of the reasons you describe. A large developer community contributing code, mods, new themes, and doing code peer review, etc... has created some excellent results. The result is a top-knotch OpenSource project with the extended feature set one might demand from such a project. So... here's my question... Why bother to compete? If all you're looking for is a top knotch opensource forum, why not dive in and contribute to PhpBB? It's a pretty remarkable little project, and certainly worth checking out. Don't get me wrong -- I think CF could really use a high quality OS forum system. I know we'd use it if we could migrate from Fusetalk. I mean, fusetalk is cool and all, but I had to hack the heck out of it to get it to do what we wanted and now any kind of upgrade path is somewhat dubious to say the least, given all the little changes we made. I'd contribute code the code that I changed to fusetalk, I guess, but the motivation to improve somebody else's commercial products in a way that doesn't benefit me (or the community as a whole) at all isn't all that strong. Obviously, with CF, it's not that hard to build a mediocre forum system. But building a great one... well, that's another story altogether. If someone does dive into this, let us know -- I might be interested in helping out a bit as well if it's the right project. -- jon -Original Message- From: Adrocknaphobia Jones [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 26, 2002 2:10 PM To: CF-Talk Subject: RE: Cold Fusion forum (OPEN SOURCE?) Yeah, I think we have two different philosophies on open-source. I'd write open-source for the need of building the perfect application utilizing multiple developer perspectives. (To save from the headaches of rewriting everyone else's) Quite frankly, the 'perfect BBS app' has yet to be written. And I'm surprised. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: jon roig [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 26, 2002 10:35 AM To: CF-Talk Subject: RE: Cold Fusion forum (OPEN SOURCE?) I've open sourced small things in CF, but as for Open Sourcing a big project... why on earth would I want to do that on a platform that is inherently not free? As much as I like CF and working in it -- I do make a living from it -- I'd much rather do my open source programming in a language that presents no $$$ barrier to adoption, a platform that anyone on earth can use, regardless of financial backing. (I created OpenRealty -- http://jonroig.com/freecode/openrealty in PHP, for instance, and it's being used by hundreds of sites...) I'm not one of those little Stallman groupies either... and that's also not to say there aren't little pockets of OS CF stuff developing. I mean, look at CFLIB.org and how helpful that has been to the community. -- jon - jon roig senior manager, online production epilepsy foundation phone: 215.850.0710 site: http://www.epilepsyfoundation.org email: [EMAIL PROTECTED] -Original Message- From: Adrocknaphobia Jones [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 24, 2002 11:47 AM To: CF-Talk Subject: RE: Cold Fusion forum (OPEN SOURCE?) Chris, I've dealt with UBB, fuseTalk, ezBoard, and the old Allaire Forums. If I can say anything on the subject, it's that NO ONE has gotten it right (especially on the database end). Mike D said a year ago he was going to re-write the old Allaire Forums and eventually open source it. Which, stop me if I'm wrong, is what is being used on houseoffusion.com? But I think I missed the part where he open sourced it. Last I checked in June at cfFun, he said he was still working on it. I for one would really like to work an open-source bbs project. I think there is a pretty high demand for a sturdy open source board, which can be customized at the will of the programmer. I've thrown around the open-source idea with a bunch of people but found our selves intimidated by the legal requirements. You know we have a really great community here, but I can't tell you of ANY cold fusion open-source projects. Is open source cold fusion a pipe dream? Would anyone else be interested in contributing? Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division
Re: Best way to handle Checkboxes with Insert Query?
MSSQL's Query Analyzer and DBArtisan both have functionality that will generate INSERT statements from a table. Saves a ton of time, I would hate to have to write every insert from scratch... I'm sure one of the MySQL frontends does something similar. -- jon mailto:[EMAIL PROTECTED] Friday, December 27, 2002, 3:39:49 PM, you wrote: RF I know it's good that I'm learning SQL better and writing my own code RF for the updates and inserts instead of using CFUPDATE and CFINSERT... RF I'm just in the throws of agony having to go through 200 pages of code RF that I thought was finished and rewrite all the queries incorporating RF better practices than I was using before... ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Cold Fusion forum (OPEN SOURCE?)
I've open sourced small things in CF, but as for Open Sourcing a big project... why on earth would I want to do that on a platform that is inherently not free? As much as I like CF and working in it -- I do make a living from it -- I'd much rather do my open source programming in a language that presents no $$$ barrier to adoption, a platform that anyone on earth can use, regardless of financial backing. (I created OpenRealty -- http://jonroig.com/freecode/openrealty in PHP, for instance, and it's being used by hundreds of sites...) I'm not one of those little Stallman groupies either... and that's also not to say there aren't little pockets of OS CF stuff developing. I mean, look at CFLIB.org and how helpful that has been to the community. -- jon - jon roig senior manager, online production epilepsy foundation phone: 215.850.0710 site: http://www.epilepsyfoundation.org email: [EMAIL PROTECTED] -Original Message- From: Adrocknaphobia Jones [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 24, 2002 11:47 AM To: CF-Talk Subject: RE: Cold Fusion forum (OPEN SOURCE?) Chris, I've dealt with UBB, fuseTalk, ezBoard, and the old Allaire Forums. If I can say anything on the subject, it's that NO ONE has gotten it right (especially on the database end). Mike D said a year ago he was going to re-write the old Allaire Forums and eventually open source it. Which, stop me if I'm wrong, is what is being used on houseoffusion.com? But I think I missed the part where he open sourced it. Last I checked in June at cfFun, he said he was still working on it. I for one would really like to work an open-source bbs project. I think there is a pretty high demand for a sturdy open source board, which can be customized at the will of the programmer. I've thrown around the open-source idea with a bunch of people but found our selves intimidated by the legal requirements. You know we have a really great community here, but I can't tell you of ANY cold fusion open-source projects. Is open source cold fusion a pipe dream? Would anyone else be interested in contributing? Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Chris Montgomery [mailto:[EMAIL PROTECTED]] Sent: Monday, December 23, 2002 10:58 PM To: CF-Talk Subject: Re: Cold Fusion forum Howdy Michael, Thursday, December 19, 2002, 7:54:13 PM, Michael T. Tangorre wrote: I am attempting to to try some more advanced things with an idea I have. I am going to be building an online forum to tinker with.. can anyone point me to some database examples? The code side is what I am going to be playing with but need a good architecture to use.. anyone know of one I can download? I didn't see a reply to this yet, so I'll offer one to consider: http://sourceforge.net/projects/fbopenforums/ It uses Fusebox, but you might be able to get something useful out of it. If you are wanting to explore how the database would be structured for a forums app, you might want to research hierarchical database design, parent-child relationships, or using recursion with your database. This page is an example of doing recursive joins for a forum: http://www.4guysfromrolla.com/webtech/sqlguru/q120899-1.shtml with a follow-up here: http://www.4guysfromrolla.com/webtech/sqlguru/q121799-1.shtml Another post about threaded discussion forums database design: http://www.sqlteam.com/item.asp?ItemID=1353 with a follow-up here: http://www.sqlteam.com/item.asp?ItemID=1602 Some good SQL sites to check out: http://www.dbmsmag.com/index.shtml http://www.codebits.com/ntm/ http://www.onlamp.com/pub/a/onlamp/2001/07/12/aboutSQL.html http://www.sqlteam.com/Default.asp http://www.4guysfromrolla.com/ http://www.intelligententerprise.com/info_centers/database/ http://www.databasejournal.com/ http://www.sqlmag.com/ Hope that helps you somewhat. Happy Holidays! -- Chris Montgomerymonty @ airtightweb.com Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-3249/888-745-7603 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
cfstoredproc code generator
Does a free one of these exist? I faintly remember the topic coming up in the past, but my searches are coming up empty. I did find this one for $99. http://www.netwebapps.com/Products/speedDB/introduction.cfm -- jon mailto:[EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Cold Fusion forum (OPEN SOURCE?)
I hear you, Adrocknaphobia... there really isn't a perfect forum system out there. (I've been running online forums for several years, most recently for a large non-profit website...) That said, PhpBB comes pretty darn close... and it's because of the reasons you describe. A large developer community contributing code, mods, new themes, and doing code peer review, etc... has created some excellent results. The result is a top-knotch OpenSource project with the extended feature set one might demand from such a project. So... here's my question... Why bother to compete? If all you're looking for is a top knotch opensource forum, why not dive in and contribute to PhpBB? It's a pretty remarkable little project, and certainly worth checking out. Don't get me wrong -- I think CF could really use a high quality OS forum system. I know we'd use it if we could migrate from Fusetalk. I mean, fusetalk is cool and all, but I had to hack the heck out of it to get it to do what we wanted and now any kind of upgrade path is somewhat dubious to say the least, given all the little changes we made. I'd contribute code the code that I changed to fusetalk, I guess, but the motivation to improve somebody else's commercial products in a way that doesn't benefit me (or the community as a whole) at all isn't all that strong. Obviously, with CF, it's not that hard to build a mediocre forum system. But building a great one... well, that's another story altogether. If someone does dive into this, let us know -- I might be interested in helping out a bit as well if it's the right project. -- jon -Original Message- From: Adrocknaphobia Jones [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 26, 2002 2:10 PM To: CF-Talk Subject: RE: Cold Fusion forum (OPEN SOURCE?) Yeah, I think we have two different philosophies on open-source. I'd write open-source for the need of building the perfect application utilizing multiple developer perspectives. (To save from the headaches of rewriting everyone else's) Quite frankly, the 'perfect BBS app' has yet to be written. And I'm surprised. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: jon roig [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 26, 2002 10:35 AM To: CF-Talk Subject: RE: Cold Fusion forum (OPEN SOURCE?) I've open sourced small things in CF, but as for Open Sourcing a big project... why on earth would I want to do that on a platform that is inherently not free? As much as I like CF and working in it -- I do make a living from it -- I'd much rather do my open source programming in a language that presents no $$$ barrier to adoption, a platform that anyone on earth can use, regardless of financial backing. (I created OpenRealty -- http://jonroig.com/freecode/openrealty in PHP, for instance, and it's being used by hundreds of sites...) I'm not one of those little Stallman groupies either... and that's also not to say there aren't little pockets of OS CF stuff developing. I mean, look at CFLIB.org and how helpful that has been to the community. -- jon - jon roig senior manager, online production epilepsy foundation phone: 215.850.0710 site: http://www.epilepsyfoundation.org email: [EMAIL PROTECTED] -Original Message- From: Adrocknaphobia Jones [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 24, 2002 11:47 AM To: CF-Talk Subject: RE: Cold Fusion forum (OPEN SOURCE?) Chris, I've dealt with UBB, fuseTalk, ezBoard, and the old Allaire Forums. If I can say anything on the subject, it's that NO ONE has gotten it right (especially on the database end). Mike D said a year ago he was going to re-write the old Allaire Forums and eventually open source it. Which, stop me if I'm wrong, is what is being used on houseoffusion.com? But I think I missed the part where he open sourced it. Last I checked in June at cfFun, he said he was still working on it. I for one would really like to work an open-source bbs project. I think there is a pretty high demand for a sturdy open source board, which can be customized at the will of the programmer. I've thrown around the open-source idea with a bunch of people but found our selves intimidated by the legal requirements. You know we have a really great community here, but I can't tell you of ANY cold fusion open-source projects. Is open source cold fusion a pipe dream? Would anyone else be interested in contributing? Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Chris Montgomery [mailto:[EMAIL PROTECTED]] Sent: Monday, December 23, 2002 10:58 PM To: CF-Talk Subject: Re: Cold Fusion forum Howdy Michael, Thursday, December 19, 2002, 7:54:13 PM, Michael T. Tangorre wrote: I am attempting to to try some more advanced things with an idea I have. I am going to be building an online
RE: Cold Fusion forum (OPEN SOURCE?)
Sure... I'm down. Let me know how I can help... -- jon -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 26, 2002 3:38 PM To: CF-Talk Subject: RE: Cold Fusion forum (OPEN SOURCE?) I feel like I'm talking to empty air. ;p Who's up for turning SMB into the phpBB (which I use to great success on is300.net) of CF forums? I hear you, Adrocknaphobia... there really isn't a perfect forum system out there. (I've been running online forums for several years, most recently for a large non-profit website...) That said, PhpBB comes pretty darn close... and it's because of the reasons you describe. A large developer community contributing code, mods, new themes, and doing code peer review, etc... has created some excellent results. The result is a top-knotch OpenSource project with the extended feature set one might demand from such a project. So... here's my question... Why bother to compete? If all you're looking for is a top knotch opensource forum, why not dive in and contribute to PhpBB? It's a pretty remarkable little project, and certainly worth checking out. Don't get me wrong -- I think CF could really use a high quality OS forum system. I know we'd use it if we could migrate from Fusetalk. I mean, fusetalk is cool and all, but I had to hack the heck out of it to get it to do what we wanted and now any kind of upgrade path is somewhat dubious to say the least, given all the little changes we made. I'd contribute code the code that I changed to fusetalk, I guess, but the motivation to improve somebody else's commercial products in a way that doesn't benefit me (or the community as a whole) at all isn't all that strong. Obviously, with CF, it's not that hard to build a mediocre forum system. But building a great one... well, that's another story altogether. If someone does dive into this, let us know -- I might be interested in helping out a bit as well if it's the right project. -- jon -Original Message- From: Adrocknaphobia Jones [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 26, 2002 2:10 PM To: CF-Talk Subject: RE: Cold Fusion forum (OPEN SOURCE?) Yeah, I think we have two different philosophies on open-source. I'd write open-source for the need of building the perfect application utilizing multiple developer perspectives. (To save from the headaches of rewriting everyone else's) Quite frankly, the 'perfect BBS app' has yet to be written. And I'm surprised. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: jon roig [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 26, 2002 10:35 AM To: CF-Talk Subject: RE: Cold Fusion forum (OPEN SOURCE?) I've open sourced small things in CF, but as for Open Sourcing a big project... why on earth would I want to do that on a platform that is inherently not free? As much as I like CF and working in it -- I do make a living from it -- I'd much rather do my open source programming in a language that presents no $$$ barrier to adoption, a platform that anyone on earth can use, regardless of financial backing. (I created OpenRealty -- http://jonroig.com/freecode/openrealty in PHP, for instance, and it's being used by hundreds of sites...) I'm not one of those little Stallman groupies either... and that's also not to say there aren't little pockets of OS CF stuff developing. I mean, look at CFLIB.org and how helpful that has been to the community. -- jon - jon roig senior manager, online production epilepsy foundation phone: 215.850.0710 site: http://www.epilepsyfoundation.org email: [EMAIL PROTECTED] -Original Message- From: Adrocknaphobia Jones [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 24, 2002 11:47 AM To: CF-Talk Subject: RE: Cold Fusion forum (OPEN SOURCE?) Chris, I've dealt with UBB, fuseTalk, ezBoard, and the old Allaire Forums. If I can say anything on the subject, it's that NO ONE has gotten it right (especially on the database end). Mike D said a year ago he was going to re-write the old Allaire Forums and eventually open source it. Which, stop me if I'm wrong, is what is being used on houseoffusion.com? But I think I missed the part where he open sourced it. Last I checked in June at cfFun, he said he was still working on it. I for one would really like to work an open-source bbs project. I think there is a pretty high demand for a sturdy open source board, which can be customized at the will of the programmer. I've thrown around the open-source idea with a bunch of people but found our selves intimidated by the legal requirements. You know we have a really great community here, but I can't tell you of ANY cold fusion open-source projects. Is open source cold fusion a pipe dream? Would anyone else be interested in contributing? Adam
Re: cfstoredproc code generator
Thanks! This was what I had seen. Three things: It should allow more than 20 parameters. Those stock images with the people shot from the overhead view are a pet peeve of mine...they just scream late 90's :) Your wizard should be included in Studio by default (hear that Macr? :))...it's almost perfect for what it is. However, I'm looking for more of a tool that will take the SQL, or connect to the data source directly and generate the cfstoredproc. It's the repetitive typing I'm trying to get around... I just wrote a little snippet to parse the SP varnames and datatypes after I posted though in case anyone wants for such a thing. cfsavecontent variable=sp_text @web_order_reference_id char(20) ,@ord_program_id char(10) , etc... /cfsavecontent cfset dataTypeCFSQL = structNew() cfset dataTypeCFSQL.char = CF_SQL_CHAR cfset dataTypeCFSQL.varchar = CF_SQL_CHAR cfset dataTypeCFSQL.datetime = CF_SQL_DATE cfset dataTypeCFSQL.money = CF_SQL_MONEY cfset dataTypeCFSQL.int = CF_SQL_INTEGER cfloop list=#sp_text# index=i cfset dbvarname = mid( getToken(i,1),2, len(getToken(i,1)) ) cfif getToken(i,2) CONTAINS ( cfset datatypeSQL = left(getToken(i,2), find((, getToken(i,2)) - 1) cfelse cfset dataTypeSQL = getToken(i,2) /cfif cfset dataType = dataTypeCFSQL[datatypeSQL] cfoutput lt;cfprocparam type=In dbvarname=#dbvarname# value= cfsqltype=#dataType# null=Nogt;br /cfoutput /cfloop -- jon mailto:[EMAIL PROTECTED] Thursday, December 26, 2002, 3:44:51 PM, you wrote: AC You can get ours free of charge at http://www.ProductivityEnhancement.com. AC It runs as a wizard within ColdFusion Studio. AC Enjoy! :) AC Respectfully, AC Adam Phillip Churvis AC Advanced Intensive ColdFusion MX Training AC http://www.ColdFusionTraining.com AC E-mail: [EMAIL PROTECTED] AC Phone: 770-446-8866 AC Team Macromedia Volunteer for ColdFusion AC http://www.macromedia.com/support/forums/team_macromedia/ AC - Original Message - AC From: jon hall [EMAIL PROTECTED] AC To: CF-Talk [EMAIL PROTECTED] AC Sent: Thursday, December 26, 2002 3:02 PM AC Subject: cfstoredproc code generator Does a free one of these exist? I faintly remember the topic coming up in the past, but my searches are coming up empty. I did find this one for $99. http://www.netwebapps.com/Products/speedDB/introduction.cfm -- jon mailto:[EMAIL PROTECTED] AC ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: FW: Cold Fusion forum (OPEN SOURCE?)
My sentiments exactly. Other than the session variable issue, extensive use of subquery's to pull up those little counts of messages, and dare I say, looping over select query's, absolutely kills performance once it gets big enough. We (or one of clients to be specific) have the dev edition as well, and one week I sat down and optimized it to the point that I would put it up against phpbb and could feel confident about it winning. I ended up almost rewriting every query, and all the logic to do it though. Still love the interface though...it's great. IMO it's still the best cf forum software as far as features vs price go though for a small site. A quick look at the SMB source shows that while it could use some work (precalculating those counts for starters), it looks less bloated, and would probably perform better out of the box. -- jon mailto:[EMAIL PROTECTED] Thursday, December 26, 2002, 5:50:51 PM, you wrote: BD We have the developer version of that (although it may not be the current BD version) here. It allows unlimited copies on a single box -- edit the code BD all you want as long as you leave the product info at the bottom. BD Personally, I don't care for it. There are a great many things that they do BD right, but there are a few things that are glaringly wrong. For example, BD when looking thru the code it appears that they never NEVER lock session BD variables. Ick. And there were a few other inconsistencies that I can't BD remember off the top of my head. :-) I just remember that there was some BD really wierd stuff about their code. BD At one point, I needed some very basic forum stuff, but needed to use a BD specific interface (I'm working with designers) and needed to allow access BD to forums based on a single login (instead of a password for each forum) so BD I ended up writing my own from scratch. It turned out to be /much/ easier BD than editing theirs. BD I guess this would be an OK base if they let it go open-source. It's got a BD lot of nice features. But the fact that you have to edit the code to make BD it run properly doesn't make it a 'good' product in my mind. BD --Ben Doom BD Programmer General Lackey BD Moonbow Software BD : -Original Message- BD : From: Jason Miller [mailto:[EMAIL PROTECTED]] BD : Sent: Thursday, December 26, 2002 8:40 PM BD : To: CF-Talk BD : Subject: Re: FW: Cold Fusion forum (OPEN SOURCE?) BD : BD : BD : Out of the whole - annoying forum search - price vs usability vs BD : scalability vs features blah blah - I found these guys - Code 2 go.. I BD : never purchased but it seemed the best price and the most feature rich. BD : And open source I beleive was under $300. To me that seems quite BD : affordable to start up some forums. BD : BD : http://www.cfcode.com/ http://www.cfcode.com/ BD : BD : worth a look. BD : jay miller BD : BD : Jim Davis wrote: BD : BD : BD : I'd be happy to throw my BBML Parser into the mix: BD : BD : BD : BD : http://www.depressedpress.com/DepressedPress/Content/ColdFusio BD : http://www.depressedpress.com/DepressedPress/Content/ColdFusio BD : BD : n/CustomTags/DP_ParseBBML/Index.cfm BD : BD : BD : BD : I keep meaning to build a real forum system but I only seem BD : BD : to get the time to throw together components of one... ;^) BD : BD : I'd be happy to participate in a community forum project. BD : BD : BD : BD : Jim Davis BD : BD : BD : BD : BD : BD : -Original Message- BD : BD : From: Tony Schreiber [ mailto:[EMAIL PROTECTED] BD : mailto:[EMAIL PROTECTED] ] BD : BD : Sent: Thursday, December 26, 2002 10:37 AM BD : BD : To: CF-Talk BD : BD : Subject: RE: Cold Fusion forum (OPEN SOURCE?) BD : BD : BD : BD : BD : BD : I'd be willing to open SMB to other developers... BD : BD : BD : BD : http://www.simplemessageboard.com/ http://www.simplemessageboard.com/ BD : BD : BD : BD : BD : BD : BD : BD : BD : BD ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: CFMX / JVM
Tuesday, December 24, 2002, 4:01:14 AM, you wrote: That's gives a little background about the two types of JVMs. As far as performance, you might find this link interesting: http://www.javaworld.com/javaworld/jw-12-1997/jw-12-volanomark.html PH interesting? geez thats darned shocking. ms's jvm beats sun's on windows? PH its 5 times faster? i suppose ms's implementation is feature poor compar to PH sun's especially i18n stuff? do anyone know of a comparison list? Back before Sun got pissed at Microsoft, MS was as big into Java as they are into .Net today. Their JVM back then was by far the best JVM in existence. One of those little facts those Java owns the world, Microsoft haters like to forget. Watch...one will pipe up and proclaim some minor missing feature actually made it the worst. It's pretty much end of lifed now though. -- jon mailto:[EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: MS CF?
I'll believe it when I see it. Anyway, if Microsoft has you in their sights...you know you have to be doing something right. Of course, Microsoft isn't allowed to distribute any Java technology without making nice with Sun, because of the lawsuit, and we all know that isn't going to happen. So if Microsoft were to buy Macromedia, they would have to either kill CF, sell it off, or perhaps keep the name and rewrite the engine as a .Net app. None of which make me exactly happy...except maybe the chance to replace Studio with VS.Net ;) Oh well...one thing is for sure, Macromedia's stock is going to get a nice push for a bit if Wall Street catches this rumor. -- jon mailto:[EMAIL PROTECTED] Monday, December 23, 2002, 5:06:31 AM, you wrote: LC http://theregister.co.uk/content/4/28667.html ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: Rating System
Hey, how about just getting them to stop detecting Gecko based browsers as Netscape 4 on the dev exchange? They already did it for the rest of the macromedia.com site...It's impossible to read the text. The untapped potential of the dev exchange is incredible really. I'd turn it into a mini-Sourceforge type app given the chance. Bug tracking, comments, and a todo list would be all that's needed right off. -- jon mailto:[EMAIL PROTECTED] Monday, December 23, 2002, 1:45:08 PM, you wrote: CC Adam, CC This is a great idea, and something that will be included in the next CC version of the developers' exchange. Keep the good ideas coming! CC Christian CC On Monday, December 23, 2002, at 01:15 PM, Adrocknaphobia Jones wrote: Welcome to list/party. Do you think we could ever get a rating system on the developer's exchange? I can't tell you how many hours I've lost downloading crappy cide looking for the diamond in the rough. I think a rating system would help a lot, possibly with user reviews/comments. I just find it nearly impossible to tell similar tags apart, aside from downloading and testing. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Christian Cantrell [mailto:[EMAIL PROTECTED]] Sent: Monday, December 23, 2002 12:47 PM To: CF-Talk Subject: Brief Introduction I would like to introduce myself to everyone on cf-talk as the new Macromedia community manager for ColdFusion. My name is Christian, and I have been developing various types of applications in ColdFusion and Java for the last five years. I am excited about the opportunity to work with such a strong and active community, and to help ensure that the dialogue between the community and Macromedia is efficient and productive. In addition to managing the relationship between the ColdFusion community and Macromedia, I will, among other things, also be responsible for the ColdFusion content on the Macromedia MX Developer Resource Kit, so I am interested in discussing ideas about the types of articles, tutorials, sample applications, component libraries, etc. you think would be useful. Additionally, please do not hesitate to email me personally off-list with any other questions, comments or suggestions at any time. Christian Cantrell CC ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: OT: W3C DOM Reference
You may already know these, but these are the refs I use. I'd use the msdn site, but the frames really get on my nerves sometimes :) http://www.w3.org/DOM/ http://www.mozilla.org/docs/dom/domref/ http://www.devguru.com/Technologies/ecmascript/quickref/javascript_intro.html and a good links page...which may have what you want. http://www.xs4all.nl/~ppk/js/linksv5.html -- jon mailto:[EMAIL PROTECTED] Saturday, December 21, 2002, 11:22:16 PM, you wrote: SID I've been putting off going and buying a reference book for the W3C's dom SID .. I really like the dhtml reference on msdn.microsoft.com (in spite of its SID own dhtml being a bit hit or miss) -- it's really handy -- but I need SID something that includes only the official W3C specification. The MS site for SID starters claims that there's no specification of standard for the SID window.history object, which would be news to me. Anybody know of anything SID like this? I've been searching the web for a couple hours and haven't found SID anything particularly useful. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: writing to Excel
Hey... I just put up a quick and simple tutorial on how to do this: http://jonroig.com/modules.php?op=modloadname=Newsfile=articlesid=54 Doesn't require com objects or any of that high fallutin' stuff -- but it does write straight to the browser, so that might not be what you have in mind. -- jon - jon roig senior manager, online production epilepsy foundation phone: 215.850.0710 site: http://www.epilepsyfoundation.org email: [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 4:19 PM To: CF-Talk Subject: writing to Excel Anyone have any good resources or documentation for writing to Excel spreadsheets with CF? Thanks. Nick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: OT: browser stats, mozilla rising
Just wanted to comment to this older thread... I was just looking over some stats from a consumer oriented non ecommerce site that has been hitting 3.5 million hits+ per day for the past few weeks, and Gecko based browsers are more popular than NS4 for the first time. Not by a small margin either, but certainly not as big a margin as the German site below. Looking at the stats I'm seeing, it looks as if most NS4 diehards are switching to 6.0 or Mozilla, with IE and Opera loosing a small amount of users. Overall Gecko browsers are number 5 in popularity behind IE 5.0, 5.5, 6.0, and IE 5 Mac. Kinda ironic that Macromedia still hasn't updated their dev exchange to detect Gecko based browers. I heard they were pretty big into web stuff... ;-) -- jon mailto:[EMAIL PROTECTED] Thursday, December 19, 2002, 3:56:58 AM, you wrote: ZS few interesting stories around the web today about mozilla's market ZS share rising... ZS this is the stats from heise.de a big german news site, where mozilla ZS based browsers now accounting for 19.4% of users ZS http://translate.google.com/translate?u=http://www.heise.de/newsticker/data/anw-18.12.02-000/ ZS found from a story on mozilazine ZS http://www.mozillazine.org/talkback.html?article=2767 ZS ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: Best Way To Integrate Separate Web Sites using CF
Sounds like you are using Access...if a better db server is not in the budget, you might want to investigate MySQL. That would allow you to make remote db connections. -- jon mailto:[EMAIL PROTECTED] Thursday, December 19, 2002, 1:15:56 AM, you wrote: C The databases will be on separate servers. C So, unfortunately, I won't be able to do SQL statements. C Is there another method I can use? C -- C Mike ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Simplest translation of simple XML file to CF5 structure?
Lets pretend that abc.xml contains... ?xml version=1.0? book authorjon/author titlea question/title /book What is the most easy way to magically turn that into a coldfusion structure where I can do #book.author# and #book.title#? There has GOT to be a CF5 xmlParse() UDF out there somewhere. Please advise. Thank you, Jon ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: cferror
Hey... we added this to our error page... works like a charm: cfmail to=[EMAIL PROTECTED] cc=[EMAIL PROTECTED] from=[EMAIL PROTECTED] subject=Cold Fusion Error type=HTML CFDump var=#error#CFDump var=#cgi#/cfmail Gives a ton of diagnostic data that usually helps us in finding/reproducing the source of the error. -- jon - jon roig senior manager, online production epilepsy foundation phone: 215.850.0710 site: http://www.epilepsyfoundation.org email: [EMAIL PROTECTED] -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 11:42 AM To: CF-Talk Subject: RE: cferror Hi, Tim. I implemented your approach below and it works well, except that when the request type error occurs, I do get the email sent to the admin, but the only thing that shows up in the browser is a blank screen. If I add your error_page.cfm code to the error_admin.cfm page then the admin email is sent, then the error message to the user is displayed. Why do we need two pages? (I assume that exception error code, being set to any will catch every type of error that occurs and therefore, the error_admin.cfm page will always be executed?) Thanks, Rick -Original Message- From: Tim Laureska [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 8:54 AM To: CF-Talk Subject: RE: cferror First, a thanks to those who replied to my initial question about CFERROR I thought it might be useful to share what I finally came up with Using Scott Brady's initial suggestion for using two error template references in the application.cfm file (exception and request). The templates are as follows... these seem to work fine in testing and may be pretty basic, but I learned a fair amount from the exercise APPLICATION.CFM file: !--- code for sending error message to web developer/site admin cferror type=exception template=error_admin.cfm EXCEPTION=Any mailto=[EMAIL PROTECTED] !--- code for person viewing web page--- cferror type=request template=error_page.cfm mailto=[EMAIL PROTECTED] ERROR_ADMIN.cfm: (file to send message to web page developer/admin) cfmail from=[EMAIL PROTECTED] subject=Web Site Error Report to=[EMAIL PROTECTED] type=html Error Date/Time: #DateFormat(Now())# at #TimeFormat(Now(),h:m tt)#p Viewers Browser: #http_user_agent#p Page error was generated: #error.template#p URL Query string of Client's request: #error.QueryString#p #error.diagnostics# /cfmail ERROR_PAGE.CFM (excerpt of page that viewer sees) We have logged the following information that will help us identify and correct the problem: UL LIError occurred at B#ERROR.Datetime#/B LIYour IP address is B#ERROR.RemoteAddress#/B LIYour browser is B#ERROR.Browser#/B LIYou were trying to process B#ERROR.Template#?#ERROR.QueryString#/B /UL If you can provide us with any additional information that would help us fix this problem, please send E-Mail to: A HREF=mailto:#ERROR.MailTo#;#ERROR.MailTo#/A. Tim Laureska -Original Message- From: Chris Norloff [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 8:26 AM To: CF-Talk Subject: RE: cferror Here's my notes on cferror types (CF 4.5 SP2, Solaris, Oracle 8i): Chris Norloff type=expression - catches bad expression like select * from m_job_summary where job_id=#doesnt_exist# type=database - catches bad SQL like select * from m_job_summary GROUP ORDER BY - catches invalid column like select * from m_job_summary where doesnt_exist=10 type=missinginclude - catches missing cfincluded files - catches missing cfmodule files. type=lock - catches problem with lock, such as timing out while waiting to get exclusive access. type=any Catches things not caught by a previous cfcatch statement. Example: - timeout error. Sometimes timeout error has type COM.ALLAIRE.COLDFUSION.REQUEST.TIMEOUT. Sometimes type is UNKNOWN and the message is Request timed out. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: CF Instant Messaging
Does CFMX have better sockets support through Java now? If so, it might be trivial to whip something simple up... -- jon -Original Message- From: Brandon Harper [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 17, 2002 3:49 AM To: CF-Talk Subject: RE: CF Instant Messaging An option besides those old tags is PresenceWorks ( http://www.presenceworks.com ). I've worked enough with it enough to get something basic working in CF 5, then another project came along and I haven't gotten back to it yet. Perhaps I'll be able to write it as a CFC by the time it's a priority again and open source it at CFLib or something along those lines. I don't remember what the service cost of PresenceWorks is offhand, but its very reasonable. The support is very good as well-- when I had some questions I ended-up talking to the person who wrote their Java API. I think combining PresenceWorks with the open source work which has already been done to figure out the AIM/ICQ (they both use the same login servers now.. rumor is they are working to merge protocols, finally!), MSN, and Yahoo protocols, I suppose you could eventually roll something together. However it seems like a pretty big PITA and potentially maintenance heavy item if its not core to you or your clients business. - Brandon -- http://booms.net http://spooled.net ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: Issue: Change row color on mouse over in Netscape 4.7
Netscape 4 does not support changing table background colors like that... -- jon mailto:[EMAIL PROTECTED] Tuesday, December 17, 2002, 1:17:33 PM, you wrote: JB Hello Everyone: JB IÂ’ve spent too many hours on this I hit a wall. IÂ’m using the code below JB to alternate row color for my table and when you mouse over each row it JB should change the background color for the row. It works in IE 5+ and JB Netscape 6+ but I canÂ’t get it to work in Netscape 4.7 any ideas? JB TR valign=top JB bgcolor=###iif(currentrow MOD 2,DE('BFCCE6'),DE('D8DFE1'))# JB onmouseover=this.style.backgroundColor='##FAF7B8'; window.status='My JB Window Message';return true; JB onmouseout=this.style.backgroundColor='###iif(currentrow MOD JB 2,DE('BFCCE6'),DE('D8DFE1'))#'; window.status=''; return true; JB Bonus Question: IÂ’m working within a framed page it possible when the JB user mouseÂ’s over the row to send a value to a window.status for JB Netscape 4.7? JB Regards, JB James Blaha JB ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: need tag for dropdown and input
Not a tag, but you can use it however you want... http://www.oztek.net/jon/combobox.htm -- jon mailto:[EMAIL PROTECTED] Tuesday, December 17, 2002, 12:06:25 PM, you wrote: VLC I know I've seen it somewhere on my journeys. VLC It's the tag that displays both a dropdown (populated from a query) as well VLC as an accompanying text input so that the if the needed value isn't listed VLC in the dropdown, the user can enter it into the text box. But only one VLC variable for the value is sent. VLC Anyone know where I can pick this up? VLC I'm not sure what to search for on the DevX. I sure wish they would make a VLC more powerful and relevant search tool. VLC TIA, VLC ~Val ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: debug report/image magick with cfexecute
That's interesting...makes me think that cfexecute doesn't report it's content back to whatever the cf equivalent to stdout is, or it just works in a different way than the other tags, or someone forgot about cfexceute :). I wonder if putting cfoutput's around the cfexecute would work...probably not, but just a thought. A possible solution would be to pipe the output of imagemagick to a file and read it in, or use cfexecute to write the output to a file and read that file it... -- jon mailto:[EMAIL PROTECTED] Tuesday, December 17, 2002, 8:53:21 PM, you wrote: OH I thought if I did something like this: OH CF_SaveContent variable=debugReport OH CFEXECUTE OH NAME=F:\ImageMagick-5.5.1-Q8\mogrify.exe OH ARGUMENTS=-format jpg -antialias -mask unsharpen -quality 70 OH F:\Inetpub\wwwroot\inserts\ps\#name# OH F:\Inetpub\wwwroot\inserts\ps\#tempFile#.jpg -debug -verbose -log OH /CFEXECUTE OH /CF_SaveContent OH cfoutput OH #debugReport# OH /cfoutput OH I would get the results of the cfexecute, arguments include -debug, report OH .. but I'm shooting blanks. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: mySQL CF
For mysql -- or any sql, really -- you code it as follows: cfquery name=yourName datasource=yourDataSource INSERT INTO yourTable (field1, field2) VALUES ('value1', 'value2') /cfquery With mysql, you need to watch out for illegal characters. That means if value1 = This won't work you need to replace it with This won\'t work In other words, you need to escape the quotes. Good luck and enjoy mysql. For what it is -- a quick, simple little db -- it's really quite nice. -- jon - jon roig senior manager, online production epilepsy foundation phone: 215.850.0710 site: http://www.epilepsyfoundation.org email: [EMAIL PROTECTED] -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 11:02 AM To: CF-Talk Subject: RE: mySQL CF Hi, Matt. I, too, learned about the CFUPDATE problem from personal experience and from the Allaire forums when I first started using CF (with Access at that time). I stopped using it and went to the CFQUERY...Set... approach. That's worked fine. I haven't had any problems with CFINSERT, but if that may be problematic in the future I may as well go ahead and change my coding habits now. How is the INSERT coded for mySQL and CF? Example? Thanks, Rick -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 1:11 AM To: CF-Talk Subject: RE: mySQL CF Rick, I noticed you mention that you use CFINSERT. From your earlier postings I know you are on CF 4.5x, as I am. You're likely to discover that CFINSERT and/or CFUPDATE sometimes blow sky-high on CF 4.5x (at least) when working with mySQL (3.23 for sure, and maybe 4.0x). In threads on the subject over at the (then) Allaire forums no specific cause was ever traced. It just happens. Sometimes. In one of those threads I believe it was Paul Hastings who advised me to 'just say no to cfinsert/cfupdate' and it ranks as some of the best CF advice I ever got. On the surface those tags appear to be handy shortcuts, but they black-box your SQL, take away the otherwise granular control you should have and make debugging ... difficult. I suggest you follow the same advice -- you'll probably find out you have to, anyway. While you're at it go for the double bonus and implement cfqueryparam. Happy Monday (early) :) --- Matt Robertson, MSB Designs, Inc. http://mysecretbase.com - Retail http://foohbar.org - ColdFusion Tools --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: Coldfusion moving very..cold
I'd suspect the MDAC first...make sure you have the latest version. The original 2.7 had performance problems with Access under certain circumstances. -- jon mailto:[EMAIL PROTECTED] Monday, December 16, 2002, 10:48:55 PM, you wrote: AC Hi, AC I might say I am a cf newbie because I got installation problems. I installed my CF MX as an stand alone server. So the CF itself isnt slow as the pages load quick. However I am having trouble AC when the PC access the access databases. I have tried the tutorials of CFMX and everything is very slow. AC - Whenever I tried to access the database on DWMX AC - Whenever the application gets into the database AC - Whenever I tried to load a query, generated object within the DWMX interface. AC My data is the following: AC PIII 1 Ghz 256 MB RAM AC I also had use this PC for hosting PHP-Mysql which went superfast. I am thinking on using mysql database, but for the tutorial porposes. I rather want to be able to use MDB too. Does it has to do AC with the MAC (MAD) driver update you need to install when u get cf? ok Please send your suggestions. AC ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: Mildly OT: JS, Form, Passing Vars
Your making it to complex I think. Just submit the form using target=new. Something like this... script function setFormParams(elem, type) { if (type == 'preview') { elem.action = 'letterPreview.cfm'; elem.target = 'new'; else if (type == 'complete') { elem.action = 'completeForm.cfm'; } elem.submit(); /script form id=letter input type=submit id=preview value=preview onclick=setFormParams(this.form, 'preview') input type=submit id=complete value=sumbit onclick=setFormParams(this.form, 'complete') /form -- jon mailto:[EMAIL PROTECTED] Sunday, December 15, 2002, 2:59:04 AM, you wrote: R I am attempting to take values from a form that I have (it's a form that R chooses recipient, sender, letter to be sent, custom header, custom R footer and whether or not a password is sent to the user, for what it's R worth) and then pass them to a pop-up window for display/preview prior R to submitting and having all values combined into the email and sent, R and then added to the database. R I've found a couple of Javascript methods for handling this, but I'd R prefer to keep the pop-up page reading the CF values--which it's not; R it's saying that my FORM.values are undefined. R Ideally, I'd simply like to pass all my values to the popup, display R them, have a window.close and then allow the user to submit the letter, R if they so choose, but right now, I'm not correctly passing anything. R Here's what I'm working with (and it's probably butchered after a few R tries here, so please bear with me): R (button): input name=Submit2 type=Button class=ButtonInv R onClick=newWin() value=Preview Letter R SCRIPT language=javascript type=text/javascript R !-- R !--- Form name = Letter; trying to see if I can manipulate the code R below to work for me; failing horribly --- R !--- document.Letter.action=letterPreview; --- R !--- document.Letter.submit() --- R function newWin(){ R var confirmWin = R window.open('letterPreview.cfm','','width=800,height=600,scrollbars=yes, R left=380,top=0') R if(confirmWin.opener==null){ R confirmWin.opener = self; R } R } //-- R /SCRIPT R And now, my head's starting to spin and I'm getting a little lost. R Any assistance? R Thanks very much! R Russ R ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: Mildly OT: JS, Form, Passing Vars
The opener stays should stay as is. There is a problem with my code though that I didn't see until now. The elem.target should be changed to '' if elem.type = complete, because if the close the window after previewing, the target needs to be reset. Also the onclick event may need to return true for the form to actually submit. I didn't test this :) onclick=setFormParams(this.form, 'complete'); return true; If he wants to have a close window button that submits the opener form I'd do something line opener.setFormParams(opener.forms.letter,'complete') from the popup. In thinking about it again, the problem with this method is that you still want to control the size of the popup. Probably the best way to solve that using this method would be to create the window named new before submitting the form. So a somewhat debugged version might look like this. script function setFormParams(elem, type) { if (type == 'preview') { elem.action = 'letterPreview.cfm'; elem.target = 'new'; else if (type == 'complete') { elem.action = 'completeForm.cfm'; elem.target = ''; } window.open('null.htm','new', ...) elem.submit(); /script form id=letter input type=submit id=preview value=preview onclick=setFormParams(this.form, 'preview'); return true input type=submit id=complete value=sumbit onclick=setFormParams(this.form, 'complete'); return true /form -- jon mailto:[EMAIL PROTECTED] Sunday, December 15, 2002, 5:36:53 PM, you wrote: G - Original Message - G From: Jon Hall [EMAIL PROTECTED] Your making it to complex I think. Just submit the form using target=new. Something like this... script function setFormParams(elem, type) { if (type == 'preview') { elem.action = 'letterPreview.cfm'; elem.target = 'new'; else if (type == 'complete') { elem.action = 'completeForm.cfm'; } elem.submit(); /script form id=letter input type=submit id=preview value=preview G onclick=setFormParams(this.form, 'preview') input type=submit id=complete value=sumbit G onclick=setFormParams(this.form, 'complete') /form G G I'm curious (and too immersed in something else to set up a test ;-)... What G happens to the opener, the parent window contents, when you submit to the G preview pop-up? Does the browser know not to reload anything into here when G it's submitted a form to another window? G Gyrus G [EMAIL PROTECTED] G work: http://www.tengai.co.uk G play: http://www.norlonto.net G PGP key available G ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: Mildly OT: JS, Form, Passing Vars
Resend...didn't see it hit the list, sry if it's a repeat The opener stays should stay as is. There is a problem with my code though that I didn't see until now. The elem.target should be changed to '' if elem.type = complete, because if the close the window after previewing, the target needs to be reset. Also the onclick event may need to return true for the form to actually submit. I didn't test this :) onclick=setFormParams(this.form, 'complete'); return true; If he wants to have a close window button that submits the opener form I'd do something line opener.setFormParams(opener.forms.letter,'complete') from the popup. In thinking about it again, the problem with this method is that you still want to control the size of the popup. Probably the best way to solve that using this method would be to create the window named new before submitting the form. So a somewhat debugged version might look like this. script function setFormParams(elem, type) { if (type == 'preview') { elem.action = 'letterPreview.cfm'; elem.target = 'new'; else if (type == 'complete') { elem.action = 'completeForm.cfm'; elem.target = ''; } window.open('null.htm','new', ...) elem.submit(); /script form id=letter input type=submit id=preview value=preview onclick=setFormParams(this.form, 'preview'); return true input type=submit id=complete value=sumbit onclick=setFormParams(this.form, 'complete'); return true /form -- jon mailto:[EMAIL PROTECTED] Sunday, December 15, 2002, 5:36:53 PM, you wrote: G - Original Message - G From: Jon Hall [EMAIL PROTECTED] Your making it to complex I think. Just submit the form using target=new. Something like this... script function setFormParams(elem, type) { if (type == 'preview') { elem.action = 'letterPreview.cfm'; elem.target = 'new'; else if (type == 'complete') { elem.action = 'completeForm.cfm'; } elem.submit(); /script form id=letter input type=submit id=preview value=preview G onclick=setFormParams(this.form, 'preview') input type=submit id=complete value=sumbit G onclick=setFormParams(this.form, 'complete') /form G G I'm curious (and too immersed in something else to set up a test ;-)... What G happens to the opener, the parent window contents, when you submit to the G preview pop-up? Does the browser know not to reload anything into here when G it's submitted a form to another window? G Gyrus G [EMAIL PROTECTED] G work: http://www.tengai.co.uk G play: http://www.norlonto.net G PGP key available G ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: Pass null to a Java object?
Friday, December 13, 2002, 3:46:18 PM, you wrote: JE Didnt you say.. you were trying to pass null to a Java Object.. if you cant JE run Java Class files.. How can you instantiate a Java Object? from CFML and I am forced to do everything with plain CFML. JE You can only write Plan CF.. Now where does Java Objects even fit here? JE Joe Been to cflib.org or read Forta's MX book? People are using Java objects in CF everywhere... -- jon mailto:[EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
cfcatch.nativeErrorCode and sqlstate?
Is there any way in CF5 to get this information using only cfquery? In particular I am having a problem where a trigger is returning an error, but not throwing an error. -- jon mailto:[EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: XML and Javascript
How about using the wddx.js in the wddx api? Might save you some time. I've used it in the past and it's very nice. -- jon mailto:[EMAIL PROTECTED] Thursday, December 12, 2002, 11:25:08 AM, you wrote: JM Hey, JM Would anyone know off any good online resources giving good help with JM creating XML documents in memory with javascript so they can then be passed JM via a form JM to CF. JM I know javascript can parse XML, so I'm sure it I'll have not problems JM creating XML JM docs, or will it? JM I want to be to append and remove nodes within any part of the doc not just JM append JM to the over all doc. JM I guess I should have posted this on cf-xml, ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
For the gurus: Question about state management with CLIENT scope
I'm writing an app that uses the CLIENT scope for state management. When somebody logs in, there are some client variables that are set like CLIENT.firstName and CLIENT.lastName. The problem is that even if the end user quits the browser after being logged in and comes back to the site 10 minutes later, the user is still logged in from before. I realize that you can set a timeout on client variables, but that is stupid. The CFTOKEN and CFID need to go away when the browser closes - just it it does on any other website I can think of. How can I tell CF to set the CFID and CFTOKEN cookies as 'session' cookies, meaning that they are gone when the browser instance quits? It doesn't make any since for people to still be logged in after they quit the browser and it poses a mild security risk for what I'm trying to do. I can think of some annoying work arounds but I can't think of any elegant solutions for this problem. Thanks, Jon ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: For the gurus: Question about state management with CLIENT sc ope
Dave, That makes perfect since. Thats a great idea I didn't even think of it. I'm just suprised that the default behavior or CF Server is to drop permanent state cookies. I will do it manually and then I will be golden. Cool. Thanks, Jon -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 4:10 PM To: CF-Talk Subject: RE: For the gurus: Question about state management with CLIENT sc ope I'm writing an app that uses the CLIENT scope for state management. When somebody logs in, there are some client variables that are set like CLIENT.firstName and CLIENT.lastName. The problem is that even if the end user quits the browser after being logged in and comes back to the site 10 minutes later, the user is still logged in from before. I realize that you can set a timeout on client variables, but that is stupid. The CFTOKEN and CFID need to go away when the browser closes - just it it does on any other website I can think of. The Client scope isn't really intended to behave the same way as the Session scope - it's intended more for long-term user data storage, rather than storing data during an individual visit. How can I tell CF to set the CFID and CFTOKEN cookies as 'session' cookies, meaning that they are gone when the browser instance quits? It doesn't make any since for people to still be logged in after they quit the browser and it poses a mild security risk for what I'm trying to do. I can think of some annoying work arounds but I can't think of any elegant solutions for this problem. You can set the cookies yourself in Application.cfm: cfapplication ... clientmanagement=yes setclientcookies=no cfif not IsDefined(Cookie.CFID) cfcookie name=CFID value=#Client.CFID# cfcookie name=CFTOKEN value=#Client.CFTOKEN# /cfif Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: cf5 and mx both on iis
Why don't you just post it to the list? Thanks, Jon -Original Message- From: Matt Bathje [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 4:56 PM To: CF-Talk Subject: cf5 and mx both on iis Hi all. I just today figured out how to run CF5 and CFMX both on the same W2K machine both using IIS (but on different ports). Right now I have CF5 running on IIS port 80, and CFMX running on IIS port 90 (it is not running on the CFMX standalone webserver) Is anybody interested in the instructions for doing this, or would it be re-covering old ground that I somehow missed (and couldn't find in the archives)? Email me personally if you want the instructions (I don't want a bunch of me-toos on the list!) and if I get more than 1 or 2 requests, or somebody telling me its never been done before or something, I'll post them. Matt ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: Redirection based on IP address.
CountryHawk may be good (or bad...) but it's certainly far from 100% accurate. Just looking at the docs real quick, it uses a database of ip:country mappings that has to be updated regularly. Even if they put out a new version every day, I seriously doubt they can keep track of all 4 billion+ possible ip addresses accurately. Not only that, dynamic ip's, multinational isp's, and proxies are unknown's. What if a netblock owner with an ASN number sells out or moves to a different country, or heck, just loans some unused net blocks he had since the 80's to a buddy? To me, if a product is reliable, it means 100%. Browserhawk would not fit my definition of reliable. Not even close if you ask me. -- jon mailto:[EMAIL PROTECTED] Wednesday, December 11, 2002, 9:53:21 AM, you wrote: There is no reliable way to determine the country of a user on a web site based on ip, user locale, reverse dns, or any other technique. AJ -- Course, this product begs to differ: AJ http://www.browserhawk.com/products/country/intro.asp AJ AJ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: BlueDragon J2EE on OSX - Working !!!
JBoss is written in Java, it should run on the Mac... Why not choose the J2EE version if he is running Tomcat? -- jon mailto:[EMAIL PROTECTED] Wednesday, December 11, 2002, 10:22:13 AM, you wrote: KO I'm very interested... KO are there any J2EE servers available for the MAC? If not why did you KO choose the J2EE version? KO Thanks KO Kola -Original Message- From: Joshua Miller [mailto:[EMAIL PROTECTED]] Sent: 11 December 2002 15:11 To: CF-Talk Subject: BlueDragon J2EE on OSX - Working !!! I know this is probably nothing special, but getting an KO easy-to-install CFML engine on my Mac just made my day! If you're interested, just use the default Apache installation, then download Tomcat from http://jakarta.apache.org, then download KO BlueDragon for J2EE from www.newatlanta.com and install them in order (Apache, Tomcat, BlueDragon) - Now you can serve CFML from your Mac. I know this isn't fully CFMX compatable, but I'm certainly happy that KO it runs on the Mac. Wonder why it's not officially supported on Mac? KO All of the UNIX files worked just fine without any trouble/tweaking. Anyway, just thought I'd post my success to the list in case anyone KO else is interested. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: Anonymous Access to Web Server -- CF 5.0
First, before you do anything. Install every patch for IIS! Just to add to what others have said, in Win2k at least, by default all files and directories have Everyone with Full Control, so the IUSR_MachineName user should already have full access to your web root by proxy... Make sure that in IIS, Allow Anonymous Connections is enabled under Directory Security, and that the anonymous user name is actually IUSR. On your web root folder (c:\inetpub\wwwroot\), go to properties, security, and uncheck Allow Inheritable Permissions, and click Copy. Remove the user Everyone, and add Administrators, and IUSR. Then go to advanced, and check Reset Permissions...Then click OK, Apply. That should do it. -- jon mailto:[EMAIL PROTECTED] Tuesday, December 10, 2002, 5:06:13 PM, you wrote: NB First and foremost -- I am a self proclaimed illiterate (in totality) NB regarding Network admin, security\permissions, etc. knowledge. NB I recently installed CF 5.0 on a new computer system running Windows XP Pro. NB Anonymous access to the web server is not working when trying to access for NB example http://127.0.0.1/index.html. I.e., I can't get around the NB requirement for a User Name and Password NB Access using the dir\filename, as below, works. NB http://localhost/index.html and c:\inetpub\wwwroot\index.html NB All of the documentation that came with CF 5.0 and that I can find on the NB Macromedia.com Web site addresses Win 95, 98, NT and 2000. Some of the NB directories, file names, etc. described for those OS's don't appear to have NB different names or are in different locations in XP Pro NB Any help would be appreciated? NB Thanks, NB Nick NB ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: Redirection based on IP address.
You could ask ARIN and RIPE for their databases ;) There is no reliable way to determine the country of a user on a web site based on ip, user locale, reverse dns, or any other technique. Just do it like cnn.com, buy.com, bbc.co.uk, etc, do it. Pop up a window asking which country the user is from and set a cookie. -- jon mailto:[EMAIL PROTECTED] Wednesday, December 11, 2002, 9:48:53 AM, you wrote: S Yup. Thanks. S How do I reliably determine the country from the IP address realtime. S I think that the tricky part. S Is there a CF tag that will do that for me? S Srimanta S - Original Message - S From: Scott Brady [EMAIL PROTECTED] S To: CF-Talk [EMAIL PROTECTED] S Sent: Tuesday, December 10, 2002 4:01 PM S Subject: Re: Redirection based on IP address. Assuming you can reliably determine which IP addresses go with which S country, it should be fairly easy using CGI.remote_addr (which gives you S their IP address). Of course, what if an Australian user is on vacation in the US and wants S to see the Australian page? I'd suggest still giving the users the option to go to other country pages S (so the aforementioned Aussie will initially get the US page but can switch S go the Australian pages [and keep the preference with a cookie/session S variable]). Scott ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Redirection based on IP address.
You can probably come up with a fairly simple way to query netgeo. Although this isn't 100% reliable (and relies on an outside server), it might work. http://www.caida.org/tools/utilities/netgeo/NGServer/index.xml I believe other people have written php interfaces to this, although you could probably figure out how to port it to CF without too much trouble. -- jon - jon roig senior manager, online production epilepsy foundation phone: 215.850.0710 site: http://www.epilepsyfoundation.org email: [EMAIL PROTECTED] -Original Message- From: Srimanta [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 11, 2002 9:49 AM To: CF-Talk Subject: Re: Redirection based on IP address. Yup. Thanks. How do I reliably determine the country from the IP address realtime. I think that the tricky part. Is there a CF tag that will do that for me? Srimanta - Original Message - From: Scott Brady [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 10, 2002 4:01 PM Subject: Re: Redirection based on IP address. Assuming you can reliably determine which IP addresses go with which country, it should be fairly easy using CGI.remote_addr (which gives you their IP address). Of course, what if an Australian user is on vacation in the US and wants to see the Australian page? I'd suggest still giving the users the option to go to other country pages (so the aforementioned Aussie will initially get the US page but can switch go the Australian pages [and keep the preference with a cookie/session variable]). Scott Scott Brady http://www.scottbrady.net/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: CFMX - Mail Spooling Issue!
CFMX can handle quite a few emails in it's spool without choking, I haven't bumped against a limit so far. I also haven't specifically seen this kind of behavior, but if the cf server spool process got confused somehow, it might cause such behavior. I've noticed that MX's spool keeps an internal counter of some kind, and if you copy an email out of the spool, let MX send it, and copy it back again it doesn't get sent. Are the emails getting stuck in the CF spool or the mail server spool, if it's the mail server spool, which mail server are you running? -- jon mailto:[EMAIL PROTECTED] Monday, December 9, 2002, 6:07:20 PM, you wrote: DN See below. Anybody else have any ideas? DN --D DN -Original Message- DN From: samcfug [mailto:[EMAIL PROTECTED]] DN Sent: Monday, December 09, 2002 1:45 PM DN To: CF-Talk DN Subject: Re: CFMX - Mail Spooling Issue! DN Is your mail server running on the same machine as the script? DN [Dave] Yes. CFMX server is on LOCALHOST, using 127.0.0.1 (my local DN machine) as the mail server. DN Is your mail server set to do open relays? DN [Dave] Yes, allow all. DN What mail server do you have set in CF Administrator? DN [Dave] I have 127.0.0.1 set in CF Administrator. DN Is your mail server sending mail only from your script, or relaying for DN someone DN else? DN [Dave] Only from the script. Keep in mind all of the mails get sent DN eventually -- the only issue is why some of then only get sent after I DN reboot (as if, say, it stops at 300 e-mails when originally ran, then DN when I reboot my computer, and thus CFMX, it sends the rest). DN NOTE: I am using the CFMX Server developer version that comes with DN Macromedia Studio. Maybe this issue is specific to that? DN I am not really clear on what you are asking here, , I guess you can see DN that, DN huh? DN = DN Douglas White DN group Manager DN mailto:[EMAIL PROTECTED] DN http://www.samcfug.org DN = DN - Original Message - DN From: David Notik [EMAIL PROTECTED] DN To: CF-Talk [EMAIL PROTECTED] DN Sent: Monday, December 09, 2002 2:49 PM DN Subject: CFMX - Mail Spooling Issue! DN | Hi all: DN | DN | Has anyone seen behavior like this? DN | DN | I have a script on localhost that pulls e-mails from an Access DN database, DN | then loops over and sends a message to each e-mail address (over 500 DN | addresses) using 127.0.0.1. The e-mail gets sent fine and all is DN good, DN | but days later when I reboot my computer for whatever reason, when the DN | computer comes back up I noticed that many more e-mails had just been DN | sent (I know this because I start getting a bunch of bouncebacks for DN the DN | invalid addresses). DN | DN | This leads me to believe that when I actually run the script, not all DN | the e-mails get sent and it hangs for some reason (maybe?), and then DN | when I reboot, it retriggers something and the rest of the mails get DN | sent out? DN | DN | Does the CFMX mail component choke when there's a lot of messages in DN the DN | CFMX\Mail\Spool folder? I know CFMX never stopped working so it DN doesn't DN | completely hose, but maybe the mail part is? DN | DN | I don't know. Anyone have any clues? DN | DN | --D DN | ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: CFMX - Mail Spooling Issue!
Makes sense, but why CF's mail spool process is dying doesn't... The only other thing I could think to check, would be after you notice the mail files getting stuck in the spool, check to see if you can run a script that uses cfmail and see if it too gets stuck. If it does, the mail spool process it totally fubared, and it might be a corrupted mail file of some kind. I know this was a problem in past versions. Restarting CF in this case should cause the mail to be sent, rebooting the server shouldn't be necessary. You might want to try and see if slowing down or speeding up the mail spool checking time in the CF admin affects the problem at all. Other than that, I'm fresh out of ideas. -- jon mailto:[EMAIL PROTECTED] Monday, December 9, 2002, 6:42:49 PM, you wrote: DN It seems as if it's being stuck in the CF mail spool DN (c:\cfusionmx\mail\spool) -- I use IIS as my mail server. Pretty simple DN setup. DN The only reason I assume it's getting stuck is because, like I said, all DN is fine but then the next time I reboot my computer I notice that it DN sends out a bunch of e-mails -- so it leads me to believe things got DN stuck when I originally ran the script to send all the e-mails and now DN that I've rebooted, it triggered the remaining ones and sent them off. DN Make sense? DN --D DN -Original Message- DN From: jon hall [mailto:[EMAIL PROTECTED]] DN Sent: Monday, December 09, 2002 3:23 PM DN To: CF-Talk DN Subject: Re: CFMX - Mail Spooling Issue! DN CFMX can handle quite a few emails in it's spool without choking, I DN haven't bumped against a limit so far. I also haven't specifically seen DN this kind of behavior, but if the cf server spool process got confused DN somehow, it might cause such behavior. DN I've noticed that MX's spool keeps an internal counter of some kind, DN and if you copy an email out of the spool, let MX send it, and copy it DN back again it doesn't get sent. DN Are the emails getting stuck in the CF spool or the mail server spool, DN if it's the mail server spool, which mail server are you running? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: Client Variable Question
Complete is a property of the form, not the user, so neither a session nor a client variable are appropriate, and unless each instance of a form is a unique application (that seems unlikely from your desc.), then an application variable would be inapropriate. I would have a complete bit in a table in a database for each form, so you simply query out whether or not the form is completed where necessary. All the query needs to know is the StudentID. The table structure might look something like this: StudentID | Form1 | Form2 | Form3 | ReviewedByCaseManager A12345 1 0 0 0 -- jon mailto:[EMAIL PROTECTED] Friday, December 6, 2002, 2:20:08 PM, you wrote: JJ I generally make client variables those that aren't going to change while JJ the user is logged in. (ie:Group type=admin/etc) JJ I have an app that will have several different forms per student. (some with JJ one to many relationships/some with one to one). JJ If a case manager says the forms are complete =All forms except one becomes JJ read only. JJ If the case manager says they are not complete = All forms can be edited by JJ a variety of users. JJ I'm wondering what type of variable this Complete=Y/N should be... JJ It will have to follow each student through all the forms, but reset when a JJ new student is chosen. I'm assuming client variable isn't appropriate for JJ this JJ Thanks for the input. JJ j ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: CFX_Image - Quality of images not good when rotating
Agreed. It's in PHP. You can do all kinds of cool manipulations in either the GD or ImageMagick libraries without any funny business. -- jon -Original Message- From: Tyler Silcox [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 9:53 AM To: CF-Talk Subject: Re: CFX_Image - Quality of images not good when rotating Man, this is the never-ending, and ever-recurring, thread...but I have to try and ask a summarizing question, because after all these posts and replies I still don't have a solution to my personal problems. The perfect tag/function I'm looking for needs to be able to: 1) Get dimensions from an image (Height, Width, Size, etc.) 2) Be able to resize a GIF or JPEG with (almost) the same quality as PhotoShop 3) Plug and play ability with no need to configure anything in CF Administrator (So a Java JAR would probably be best) 4) Adding text or a watermark would be icing on the cake, but not necessary And that's about it. The closest I'm come is ImageJ (http://rsb.info.nih.gov/ij/) using some of www.benorama.com implementations along with some edits. I can just place the JAR file in the same directory and access it there, but the quality on JPEGs is not so good. This really should be a feature of *Macromedia's* ColdFusion already, I've been pleading for the latest two versions now- Tyler Silcox email | [EMAIL PROTECTED] website | www.gslsolutions.com - Original Message - From: jon roig [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 12:06 AM Subject: RE: CFX_Image - Quality of images not good when rotating Kind of interesting -- somebody sat down and wrote a custom tag to manipulate imagemagick. http://www.alagad.com/index.cfm/name-mtinfo -- jon - jon roig senior manager, online production epilepsy foundation phone: 215.850.0710 site: http://www.epilepsyfoundation.org email: [EMAIL PROTECTED] -Original Message- From: Mark Smeets [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 7:27 PM To: CF-Talk Subject: Re: CFX_Image - Quality of images not good when rotating Awesome idea...one slight problem, where's the link to download it? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Strange characters appearing in emails?
This may not be cfmail, but the issue is hard to diagnose, so I'm wondering if anyone else has seen this before I start digging. Using MX, I am seeing to the string   appended to one line in one particular html email. Here is where it gets strange though. When I look at the email in the cfmail spool folder, the characters are not there. When I open up the message in the mail servers outbound queue, the characters are not there, however if I open the email up in IE from the queue, the characters are there, but they are not in the source. When the actual mail gets to the end user, the string is in the source! I think this is the weirdest bug I have ever had the displeasure of battling...anyone have any clue what might be going on? -- jon mailto:[EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: SQL Database Decimal problem
Set the scale to something other than 0. -- jon mailto:[EMAIL PROTECTED] Thursday, December 5, 2002, 1:20:44 PM, you wrote: LM Hi, LM 1. Field data type is defined as Decimal LM 2. Insert/Update from form 1.234 LM 3. Look in database - value written is 1. LM It's getting truncated LM Suggestions? LM Thanks... LM ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: SOT: Ending tasks with CF
pstools from www.sysinternals.com -- jon mailto:[EMAIL PROTECTED] Thursday, December 5, 2002, 4:14:13 PM, you wrote: MT Oops, didn't see these before sending my own response. MT I don't have the Win2k Resource Kit, but there are freeware Win32 ps and MT kill utilities available. As I offered in my last email, feel free to MT contact me and I'll send it/them to you. MT -- MT Mosh Teitelbaum MT evoch, LLC MT Tel: (301) 625-9191 MT Fax: (301) 933-3651 MT Email: [EMAIL PROTECTED] MT WWW: http://www.evoch.com/ -Original Message- From: Scott Mulholland [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 4:04 PM To: CF-Talk Subject: RE: SOT: Ending tasks with CF Jesse, I looked at that option but don't you need to know the PID of what you are killing. In my case I need to kill all instances of a certain appi.e. notepad.exe Scott -Original Message- From: Jesse Houwing [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 3:28 PM To: CF-Talk Subject: Re: SOT: Ending tasks with CF Scott Mulholland wrote: Is there anyway to end a process or task running on a Win2k machine with CF? Possibly a call to something with cfexecute? use kill.exe from the Windows 2000 Resource Kit. Jesse MT ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: CFX_Image - Quality of images not good when rotating
Kind of interesting -- somebody sat down and wrote a custom tag to manipulate imagemagick. http://www.alagad.com/index.cfm/name-mtinfo -- jon - jon roig senior manager, online production epilepsy foundation phone: 215.850.0710 site: http://www.epilepsyfoundation.org email: [EMAIL PROTECTED] -Original Message- From: Mark Smeets [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 7:27 PM To: CF-Talk Subject: Re: CFX_Image - Quality of images not good when rotating Awesome idea...one slight problem, where's the link to download it? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: Trying to dynamically populate IFrame content pages...somehow.
IFrame's have been a part of the HTML 4.0 spec which was finalized in 1998, one year after Netscape 4.0 came out. Every browser released since the end of 1998 has supported iframes. Netscape 4.0's version of iframe's are ilayer's. -- jon mailto:[EMAIL PROTECTED] Monday, December 2, 2002, 8:41:31 AM, you wrote: CC Glad it worked out (and that you slept better because of it). I don't CC know of any other issues with iframes beside browser compatibility. CC I've always liked the idea of iframes, and thought that they should CC have been included in the HTML 4.0 specification. It seems that CC Netscape is finally getting around to supporting them, though. I tried CC the test I sent last night in Netscape 7 on a Mac, and one of the CC iframes rendered. I guess Netscape doesn't want to jump into anything CC too quickly. CC Cantrell CC On Monday, December 2, 2002, at 02:46 AM, Rick Faircloth wrote: Hi, Christian! Your were right! I tried your test and it worked fine. Put it to the test in my app and it worked perfectly! I'm not sure why I thought the variables couldn't be sent through the IFrame Src URL. I've been working on this for two days and my mind was getting into quite a fog over it. I'll have to remember to test approaches simply before putting them into the complicated apps, where many things can cause them to fail, not just the approach itself. I'm still not sure why some of the other approaches weren't working... but I'm just glad this one is. I think the IFrames will make a handy design element. I haven't used them before. Are there any issues with using them besides browser compatibility? Thanks so much for your help! I will sleep better now! (2:45am...yawn) Rick -Original Message- From: Christian Cantrell [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 1:12 AM To: CF-Talk Subject: Re: Trying to dynamically populate IFrame content pages...somehow. Rick, Why can't the variables be URL variables? I think creating them as URL variables is actually your best bet. If you use a scope like session or application, you are certainly looking at race conditions which cause mysterious bugs like the ones you are describing. Consider the following example: html cfloop from=1 to=3 index=i iframe src=filler.cfm?myvar=cfoutput#i#/cfoutput /cfloop /html Now filler.cfm: html cfoutput#url.myvar#/cfoutput /html This code works perfectly, rendering three iframes with documents containing the numbers 1, 2, and 3. Hope this helps. Cantrell On Monday, December 2, 2002, at 12:51 AM, Rick Faircloth wrote: Hi, all. I was wondering if anyone had any experience with using Cold Fusion and IFrames. I've been trying to setup a page that has one or more IFrames, depending on query results, that send information to a page that is the content page for the IFrames. I loop the output from the query on the first page, and the IFrames are created and the IFrame content page does display in the IFrame, but the content is the same for each IFrame content page. In other words, the page that populates the IFrames is created dynamically, based on the variables sent to it. When the page holding the IFrames loops through its query results, those results are sent during each loop to the IFrame content page where it is created dynamically, then the page is brought in to the IFrame. The problem is, the IFrame content page reflects only the last loop's variables in all three IFrames. I can't figure out how to get each loop's variables in the various IFrames. Since the variables can't be URL variables or Form variables, I created application variables so the variables would be available to the IFrame content pages. That worked, but the only version of the IFrame content page to show up in the IFrames was the version with the last loop's variables. It seems like what is happening is that the IFrame content page is not created until the full page is rendered that contains the IFrames. Then, last, the IFrame content pages are included. In this case, it's the last loop's variables that show up, because that's the last version of the page that was created before it's inclusion in the IFrames. Most likely, only one version of the IFrame content page can exist at one time, therefore it shows up in each IFrame. I even tried creating separate IFrame content pages to populate the IFrames, but even then the variables didn't change. ? I hope this makes some sense... This is driving me crazy! I've just about given up on using IFrames in this manner because they just seemed to be more trouble than they are worth... Rick - Rick Faircloth Prism Productions CC ~| Archives: http://www.houseoffusion.com/cf_lists
Re: Trying to dynamically populate IFrame content pages...somehow.
It's very similar, but technically it's probably closer to the span tag, with the addition of a src parameter. Being a layer tag, it's a bit more flexible than an iframe, but it's a close to an iframe tag as it gets in ns4. -- jon mailto:[EMAIL PROTECTED] Monday, December 2, 2002, 10:46:30 AM, you wrote: RF Perhaps coding both iFrames and iLayers wouldn't be RF too much to do to use the effect. RF So iFrames and iLayers are really the same thing from a coding RF and output perspective? Same parameters, etc? RF Rick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: OT: CFX_SNMP, usefulness in the CF community
I'm very interested. Is there a place I can download it? What is the cost? -- jon mailto:[EMAIL PROTECTED] Monday, December 2, 2002, 11:30:54 AM, you wrote: RE Hi, RE I've written a CFX tag that creates a simple and easy interface with SNMP-enabled entities. I am curious of the community's need for such a tag. RE The tag does the following: RE * Provides a simple interface to the somewhat complex world of SNMP RE * Probes multiple SNMP OIDs in a single datagram connection RE * Returns an easy-to-use query data structure with the results RE The tag currently performs GETs and WALKs through the SNMP OID tree. Below is an example: RE CFX_SNMP RE OID=1.3.6.1.2.1.25.4.2.1.2,1.3.6.1.2.1.25.5.1.1.2,1.3.6.1.2.1.25.5.1.1.1 RE host=#host# RE Community=#communityString# RE r_qResults=procInfo RE That call will actually return all NT processIDs, process memory usage, CPU time and process names in one QUERY (procInfo). Once you have the data available in CF, you have unprecedented control RE over the data in backend structures. RE I am trying to gauge the utility of such a tag as to determine whether i should bother to continue with development and QA. RE Let me know your feelings either here or privately. RE Thanks! RE -- RE Ryan Emerle, BSCS [EMAIL PROTECTED] RE Lead Systems Developer RE Interactive Network Systems, Inc ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: Posting XML
CF4.5 actually was the last version before they hosed up cfhttp. It still may be slow and flakey, but it doesn't encode. -- jon mailto:[EMAIL PROTECTED] Friday, November 29, 2002, 10:12:41 AM, you wrote: FM Is there a known Java component or tag I can use with CF 4.5 to make to type FM of post reliably? FM I'll look around the dev exchange. FM - Original Message - FM From: Craig Dudley [EMAIL PROTECTED] FM To: CF-Talk [EMAIL PROTECTED] FM Sent: Friday, November 29, 2002 5:22 AM FM Subject: RE: Posting XML It's not quite the same thing as a simple html form, a form can't be posted automatically by the server and the response processed in the same thread for example. Cfhttp is fine for occasional posts, but beware. It's slow, flaky and basically crap under heavy load. Java is the way to go. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: CFJava - SOLVED!! (maybe)
So CF now has a server side Javascript implementation? :) Taking a look at the BSF site, it look like the last release was in January of 01 though, or am I looking in the wrong place? http://www-124.ibm.com/developerworks/projects/bsf My mind boggles at the possibilities... -- jon mailto:[EMAIL PROTECTED] Wednesday, November 27, 2002, 7:45:10 PM, you wrote: RR Lastly (then I'll stop and wait till I get home) when I do this RR cfdump var=#jEngine.getClass().getName()#/ (see fun sample code below) RR I show com.ibm.bsf.engines.javascript.JavaScriptEngine Which seem to RR indicate it is *not* a com object. :) So after some Linux tests I'll write RR back. RR to be continued... ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: Image creation
There are a couple free cfx_image tags around that can do this, also a commercial one called cfx_imageflare which is pretty nice. You can use any of the COM objects out there to do this also. -- jon mailto:[EMAIL PROTECTED] Sunday, November 24, 2002, 9:27:15 PM, you wrote: SW I'm just wondering if there is any way using CF 5.0 to do on the fly image creation like what can be done with PHP. Easy question, yes? SW Thanks! SW Scott Wolf SW ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
remove all linebreaks
Kind of an odd request, but does anyone know if it's possible to use Studio's replace function to replace all line breaks from a document, and if so, how? -- jon mailto:[EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: remove all linebreaks
In studio goto searchextended replace..find what.hit the enter key in that box, leave replace with blank, and hit replace caution: make sure you have a copyonce done, it's not easily undone, and FYI, the resulting code is very hard to read. -Original Message- From: jon hall [mailto:[EMAIL PROTECTED]] Sent: Monday, November 25, 2002 10:19 AM To: CF-Talk Subject: remove all linebreaks Kind of an odd request, but does anyone know if it's possible to use Studio's replace function to replace all line breaks from a document, and if so, how? -- jon mailto:[EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: remove all linebreaks
Doh...that was too easy, thanks. I've got a bunch of large formatted XML files that I need to programmatically create and I was gettting really sick of going through and deleting all the line breaks... -- jon mailto:[EMAIL PROTECTED] Monday, November 25, 2002, 11:14:57 AM, you wrote: MJSCWY In studio goto searchextended replace..find what.hit the MJSCWY enter key in that box, leave replace with blank, and hit replace MJSCWY caution: make sure you have a copyonce done, it's not easily undone, and MJSCWY FYI, the resulting code is very hard to read. MJSCWY -Original Message- MJSCWY From: jon hall [mailto:[EMAIL PROTECTED]] MJSCWY Sent: Monday, November 25, 2002 10:19 AM MJSCWY To: CF-Talk MJSCWY Subject: remove all linebreaks MJSCWY Kind of an odd request, but does anyone know if it's possible to use MJSCWY Studio's replace function to replace all line breaks from a MJSCWY document, and if so, how? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: CFAPPLICATION causes NULL Error for new users
I've seen this problem in action, but never on one of my installs, but this bug was the topic of a thread about a month ago. -- jon mailto:[EMAIL PROTECTED] Monday, November 25, 2002, 1:45:46 PM, you wrote: DSUSL Answering my own post. I changed the variable handling mechanism from DSUSL Registry to Cookie and it seemed to fix the problem. I still don't know why DSUSL though. DSUSL Dustin Snell DSUSL Unisyn Software, LLC DSUSL http://www.unisyn.com DSUSL - Original Message - DSUSL From: Dustin Snell [Unisyn Software, LLC] [EMAIL PROTECTED] DSUSL To: CF-Talk [EMAIL PROTECTED] DSUSL Sent: Monday, November 25, 2002 9:01 AM DSUSL Subject: CFAPPLICATION causes NULL Error for new users Hello all, I upgraded from CF 4.5 to MX the other day and among other problems I ran into a strange issue where the presence of CFAPPLICATION in my application.cfm file would cause a new visitor (that is, one that had not been to the site to receive a cookie) would receive an CF generated error message with no line number or any other information except the text DSUSL Null. The only way I could find to fix the error was to remove the CFapplication line which looked like this: CFAPPLICATION NAME=UnisynWeb sessionmanagement=Yes SESSIONTIMEOUT=#CreateTimeSpan(0,11,0,0)# APPLICATIONTIMEOUT=#CreateTimeSpan(0,11,0,0)# Any idea? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: combo box
Sure, do you already have the combo box working in one direction? If so, just apply the same logic to the second dropdown, the only difference would be that you would be searching for a software title, instead of searching for the company. -- jon mailto:[EMAIL PROTECTED] Monday, November 25, 2002, 5:18:14 PM, you wrote: JB is there any way to do a reverse combo box? so say i have two fields, one is applications the other is companies. JB say i choose the application: outlook 2000, then the company would automatically change to microsoft. JB but lets say i knew the company was microsoft. how could i get the top box to change to every app that is associated with microsoft? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: list problems - empty fields
Saturday, November 23, 2002, 5:37:57 AM, you wrote: SC I'm reading a txt file which has 3 fields to a line SC eg SC 14||'Maggin, Elliot S.' SC 15||'Maine, Charles Eric' SC 16|1|'McCaffrey, Anne' SC but often the second field is empty SC Lists don't believe an empty field exists so I keep getting errors when I SC try to loop over the list to import to a database SC How can I make the list a true believer? (in accepting empty fields?) listToArray(list, |) might do the trick. Then each of your fields would be an element in the array, even the null ones. SC Or is there an alternative way to import the data? (access database and SC ColdFusion 5) Set up an ODBC Text Datasource for the file if you have a text driver on the machine. It requires less code, and is magnitudes faster than converting a csv to a query with CF logic. Once the datasource is set up, it's one cfquery to convert the entire csv to a query. cfquery datasource=textDSN name=qry SELECT * FROM [foo.csv] /cfquery I know CF5 Enterprise comes with the Merant text drivers, and the Microsoft text drivers work very nice as well. I'm just not sure if they get installed with Access or just with SQL Server. You could also try bypassing all the insanity directly and using the Link Table function to link the text file directly to the database. No need to do anything then...the text file is already part of the database. -- jon mailto:[EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: JSRS and ColdFusion
I haven't looked at it in about a year or so, but I used JSRS with a few modifications in the past for a project. It's a bit overdone in my opinion, but it is a good way to learn the concept's behind exchanging data with the server using JS. Basically JSRS, takes data passed to it, and passes the data as URL variables to a hidden iframe or ilayer. You can access these URL variables with CF the same as any other CF template. The part that makes JSRS so complex is that it handles arrays as well as simple strings, so it has to be able to serialize and deserialize js arrays. Overkill imo...you are better off ripping out what you need from JSRS and making your own library. His real innovation was figuring out exactly how to make an invisible iframe/ilayer across all 3 major platforms at the time. Today I think using the script tag is a better way to exchange data though. IFrame's are fine, but they make that annoying click in IE when the url is changed. -- jon mailto:[EMAIL PROTECTED] Friday, November 22, 2002, 12:15:12 AM, you wrote: gec Has anyone out there done anything with JSRS (JavaScript Remote Scripting) by gec Brent Ashley (see http://ashleyit.com/rs/) and ColdFusion? If you don't know gec what Remote Scripting is, it basically allows you to get information from the gec server without refreshing the page -- for example database queries. There are gec a lot of examples out there -- see http://ashleyit.com/rs/links.htm for some gec links if you are interested. None of the links are done with CF though. gec The current distribution of JSRS (v2.12) has a jsrsServer.cf5.inc file gec packaged with it written by an author out of Taiwan. Problem is there are no gec CF examples of any kind whatsoever available anywhere that I can find and thus gec I thought I'd throw this out to cf-talk. gec If anyone has used JSRS with CF I'd be most grateful to hear from you gec offline. I'm trying to write an example in CF to help myself understand the gec process better and I'm having some difficulties. gec Thanks, gec Grant ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Image Resize without MS server
Yeah... imagemagick is by far the best option. Kind of the industry standard, so to speak. Chances are, it's already on your machine -- it ships standard with most linux distros these days. PHP has a bunch of nice libraries for both this and GD, but you'll probably have to do cfexecutes to manipulate imagemagick from the commandline in CF. (Which isn't actually that evil...) -- jon -Original Message- From: jon hall [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 20, 2002 6:01 PM To: CF-Talk Subject: Re: Image Resize without MS server That statement is true only if there is no current software installed on the server that resizes images...g There is no built in CF functions to resize images though. ImageMagick is another good option that I didn't see mentioned yet. http://www.imagemagick.org/ -- jon mailto:[EMAIL PROTECTED] Wednesday, November 20, 2002, 5:19:18 PM, you wrote: CC So, to recap, there is no way to resize images on a *nix based server, CC using CF MX, without installing some other piece of software (JAI, CC XWindows, etc.)? CC Cutter CC Falcon Knives CC Kevin Graeme wrote: These have come up a few times. I haven't used them yet though. JAI (Sun's Java Advanced Imaging API) http://java.sun.com/products/java-media/jai/ http://www.macromedia.com/desdev/mx/coldfusion/articles/jai_images.html ImageJ http://rsb.info.nih.gov/ij/index.html http://www.benorama.com/coldfusion/libraries/imaging.htm http://www.web-rat.com/mt2/mt-search.cgi?IncludeBlogs=2search=image+j Kevin Graeme CC ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: CF + COM
Why not use their new XML API? The ShipAPI stuff is really nasty imho. -- jon mailto:[EMAIL PROTECTED] Thursday, November 21, 2002, 11:59:32 AM, you wrote: CA Im not using FedEX's Java API because CA 1) We are not using CFMX as of yet and 2) because my knowledge of Java CA is extremely limited unfortunately CA I do plan on getting more into Java dev as soon as things slow up a CA little around here. I would definitely love to delve into the language. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: Java in CF (CFMX)
Not to my knowledge...if there is, I haven't seen it documented. You can of course instantiate classes and read/set properties and use the classes methods with standard CF. -- jon mailto:[EMAIL PROTECTED] Thursday, November 21, 2002, 3:36:54 PM, you wrote: RR is there a way to do something like RR cfjava RR //actual java code not cfscript RR /cfjava RR in cfmx? Like JSP in line - how do you make a jsp block? RR Thanks, RR Rob ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: Java in CF (CFMX)
Interesting, sounds like the same reasoning that has kept CF tags from being able to be used in cfscript all those years, another design decision, even though many people asked for it. The case for allowing inline Java is simple, CF developers can use Java without having to know everything about Java. Methods and classes are easy to get. Compiling, classpath's, and understanding the lengths Java goes to, to abstract everything, etc. is not. CFQuery is the perfect example here. If CF gives developers the power to do whatever they want within cfquery tags, then why not java within cfjava tags? Seems's inconsistent to me. Especially since cfquery probably the biggest strength of the CF language. If disallowing Java is just a design decision, I would disagree with it. If it's something that would take some time to implement, then I can understand, because as you say, the Java integration is pretty solid as it is. -- jon mailto:[EMAIL PROTECTED] Thursday, November 21, 2002, 8:19:04 PM, you wrote: PC We made a design decision not to allow inline Java code. This was done to keep the code more organized and rational, and because we felt the many methods for calling out covered the basees. PC You can integrate with java code that lives in another file pretty easily -- include/forward to JSPs/servlets, instantiate and invoke Java objects, or import JSP tag libraries and invoke them in PC your page. PC Under the covers, what happens is that the class created from your CFM file calls the other class represented by your JSP page or Java class. PC If there's a use case you've got for writing Java in the page itself that wouldn't be covered by the methods noted above, I'd be interested in it. PC Phil Costa PC Macromedia PC -Original Message- PC From: Jim Campbell [mailto:[EMAIL PROTECTED]] PC Sent: Thursday, November 21, 2002 4:50 PM PC To: CF-Talk PC Subject: Re: Java in CF (CFMX) PC That's an interesting idea - sort of like a cfquery tag - anything between is directly interpreted Java code. It would probably be pretty hairy though, since there would have to be an PC impressive kludge to get something like... PC System.out.println(#variables.HelloWorld#); PC . to work and still be even marginally recognizable by CF coders. PC - Jim PC - Original Message - PC From: Rob Rohan [EMAIL PROTECTED] PC To: CF-Talk [EMAIL PROTECTED] PC Sent: Thursday, November 21, 2002 3:40 PM PC Subject: RE: Java in CF (CFMX) There is no need. I was just wondering. Since all cfm pages get complied into classes, I was thinking I could write some code blocks that would be faster using pure java (give direct access to the class). Somewhat like using ASM in C. It was just a thought. Thanks Rob Scientia Est Potentia -Original Message- From: Jim Campbell [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 21, 2002 1:37 PM To: CF-Talk Subject: Re: Java in CF (CFMX) I guess not. Would using the Java CFX API, or even just custom classes PC you call from a CFMX template not meet your needs? - Jim - Original Message - From: Rob Rohan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 21, 2002 3:20 PM Subject: RE: Java in CF (CFMX) So, judging by the lack of comments - this cannot be done. Rob Scientia Est Potentia -Original Message- From: Rob Rohan [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 21, 2002 12:37 PM To: CF-Talk Subject: Java in CF (CFMX) is there a way to do something like cfjava //actual java code not cfscript /cfjava in cfmx? Like JSP in line - how do you make a jsp block? Thanks, Rob Scientia Est Potentia PC ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: Java in CF (CFMX)
Thursday, November 21, 2002, 11:54:58 PM, you wrote: MT Jon Hall wrote: The case for allowing inline Java is simple, CF developers can use Java without having to know everything about Java. Methods and classes are easy to get. Compiling, classpath's, and understanding the lengths Java goes to, to abstract everything, etc. is not. MT Knowing just a little about a language as deep/complex as Java can be MT dangerous in a number of ways... MT It's very easy to run into errors in java if you don't understand how it all MT works (ex. trying to instantiate an interface). One of the overriding MT strengths of CF is that it offers a great deal of power in an easy to MT use/learn style. This sort of thing, IMO, goes against that strength. MT Mixing CFML and Java can very quickly lead to code that is horribly MT organized and difficult to follow/maintain. Obviously, anal coders will MT keep things nice and neat, but others will be mashing CFML, CFScript, Java, MT and SQL together haphazardly. MT Then there's the compatibility thing... Java lists != CF lists. Java arrays MT != CF arrays. Etc. Again, this can lead to confusion and cause all kinds MT of errors. I say let the coders (and the pm's who have a clue g) who write the applications make the decision on what works in their application. I'm not trying to be facetious, but be brutally honest, I couldn't care less that anyone else thinks my hypothetical hybrid Java/CF code is unorganized or difficult to maintain, as long as those that it matters to, like my boss and clients don't care either. So I don't see how the fear of some overwhelming horde of organized code existing somewhere out there, just over the horizon, really is a valid argument against allowing inline Java within CF templates. CFQuery is the perfect example here. If CF gives developers the power to do whatever they want within cfquery tags, then why not java within cfjava tags? Seems's inconsistent to me. Especially since cfquery probably the biggest strength of the CF language. MT SQL and CFML serve 2 different purposes, database manipulation and MT application logic. Java and CFML serve the same purpose, application logic. That's not entirely true. TSQL and probably PLSQL work fine within cfquery tags. Terrible as it may sound, if I want to loop over a cfquery that manipulates a cursor I can. I'm not saying there are not valid reasons for disallowing inline Java, I'm just saying that limiting the flexibility of CF just because of the possibility that nasty code may come into existence is not a good enough reason in my opinion, but it's the only one that's been put forward by both you and Phil. I also don't want to start yet another debate about what's good and bad for CF, but as you said earlier, I am curious as well. Though I suspect it's similar reasoning behind not allowing cfscript to call tags in the past (not that I ever got the reasoning behind that either). -- jon mailto:[EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: SOT: Stand alone cfmx class interpreter
I think cfclassclown is scheduled for the next version of CF. Ack! No cfspitballs! /me runs back to cf-community :) -- jon mailto:[EMAIL PROTECTED] Thursday, November 21, 2002, 8:25:23 PM, you wrote: RR Is MM thinking about making a standalone cfm class interrupter. snip ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: Image Resize without MS server
That statement is true only if there is no current software installed on the server that resizes images...g There is no built in CF functions to resize images though. ImageMagick is another good option that I didn't see mentioned yet. http://www.imagemagick.org/ -- jon mailto:[EMAIL PROTECTED] Wednesday, November 20, 2002, 5:19:18 PM, you wrote: CC So, to recap, there is no way to resize images on a *nix based server, CC using CF MX, without installing some other piece of software (JAI, CC XWindows, etc.)? CC Cutter CC Falcon Knives CC Kevin Graeme wrote: These have come up a few times. I haven't used them yet though. JAI (Sun's Java Advanced Imaging API) http://java.sun.com/products/java-media/jai/ http://www.macromedia.com/desdev/mx/coldfusion/articles/jai_images.html ImageJ http://rsb.info.nih.gov/ij/index.html http://www.benorama.com/coldfusion/libraries/imaging.htm http://www.web-rat.com/mt2/mt-search.cgi?IncludeBlogs=2search=image+j Kevin Graeme CC ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: [OT] Zip Code Lookup
Yeah... it's for US only, you're correct. That's interesting about PostGres, though. I hadn't realized that. .. another reason to support open source databases! -- jon -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Monday, November 18, 2002 4:01 PM To: CF-Talk Subject: Re: [OT] Zip Code Lookup jon roig wrote: If you're using the JCSM database, here's a simple query to pull out all the zips within #radius# number of miles. CFQUERY NAME=findLocal DATASOURCE=Zip_Search SELECT jcszip.Zip, jcszip.LastLineCity, jcszip.State, jcszip.Lat, jcszip.Lon FROM jcszip WHERE (((jcszip.lat)= (#geoCode.Lat# - (#Radius# * 0.0005)) And (jcszip.lat)= (#geoCode.Lat# + (#Radius# * 0.0005)) ) AND ((jcszip.lon)= (#geoCode.Lon# - (#Radius# * 0.0005)) And (jcszip.lon)= (#geoCode.Lon# + (#Radius# * 0.0005)) )) ORDER BY jcszip.Zip /cfquery I don't know what area the JCSM database covers, but from the looks of it I wouldn't count on this code unless it only covers the equator because the distance between meridians differs with the lattitude. And if you think the difference is insignificant: chances are your search area is only 50% of what it should be when doing a search from Anchorage, Alaska. Just think of the difference in distance between meridians on the equator and on the poles. The difference between the 0-meridian and the 1-meridian (either east or west) on the equator is 60 miles (n), and on the poles they actually overlap. My trigo is a bit rusty, but I will give it a shot to get the code correct: distance = acos(cos(latA)cos(latB)cos(lonB-lonA)+sin(latA)sin(latB))/360 * 2 * pi * R R = radius earth in the appropriate units lon from -180 to 180 degrees lat from -90 to 90 degrees If you are dealing with small distances and don't actually overlap one of the poles a reasonable approximation would be to compensate only the longitude by division with cos(#geoCode.Lat#): SELECT * FROM jcszip WHERE (((jcszip.lat)= (#geoCode.Lat# - (#Radius# * 0.0005)) And (jcszip.lat)= (#geoCode.Lat# + (#Radius# * 0.0005)) ) AND ((jcszip.lon)= (#geoCode.Lon# - (#Radius# * 0.0005)/cos(#geoCode.Lat#)) And (jcszip.lon)= (#geoCode.Lon# + (#Radius# * 0.0005)/cos(#geoCode.Lat#)) )) ORDER BY jcszip.Zip (I assume your factor 0.0005 is correct for miles (s).) Naturally you need to apply the full calculation on the resultset to get the actual distance, but this first approximation should reduce its size sufficiently to make that possible. And for the PostgreSQL users: check /contrib/, this functionality is built-in to the database. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: MX and UPS XML
I should write up a CF/UPS XML FAQ or something, seeing as how often this question comes up. CFHTTP can not be used to POST XML because CFHTTP encodes all POSTS, unless the receiver specifically takes steps to decode the XML. These companies are in the minority in my experience though. UPS expects non-encoded XML. That's why it doesn't work. The type=xml does not construct the HTTP commands. It just opens a socket and sends xml. cfx_rawsocket probably works with the 1.4 JRE, because the 1.4 JRE integrates SSL (JSSE), which the 1.3 JRE does not. CFHTTP with a default CF install will not work with SSL either. UPS requires SSL. I posted some MX/Java code to do http posts, and the source for a java cfx tag was posted within the last few weeks. A raw socket tag will work as well, but you will need to construct the http posts yourself...not difficult, just another step. If you are using MX enterprise, you can use the Jakarta JSP Taglibs also, which are pretty neat imo. -- jon mailto:[EMAIL PROTECTED] Tuesday, November 19, 2002, 4:14:48 PM, you wrote: C We actually got MX to talk to UPS for tracking. We had to use C CFX_RawSocket http://www.iexp.com/ C Of course according to all of CFX_RawSocket's documentation it should C not work under MX. We upgraded the JRE to 1.4 and it appears to work C for UPS tracking numbers. C I have no idea what we will run into by upgrading to 1.4, but we will C keep playing with it and see if there are any downsides. -Original Message- From: Chad [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 19, 2002 2:52 PM To: CF-Talk Subject: RE: MX and UPS XML I hate to beat this into the ground, but why won't this type of XML passing work with UPS? We started looking at the Java example they sent. It works, but it sure is complicated! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: SSL Certificate usage in Cold Fusion
Did you set port 443 as the SSL port in IIS? That's always the step I forget... cflocation will work fine... -- jon mailto:[EMAIL PROTECTED] Monday, November 18, 2002, 2:19:40 PM, you wrote: BL I have purchased a secure certificate from GeoTrust. I have it BL installed in IIS under the www.mycustomer.com web site. I can view the BL certificate in IIS. BL My question what mean of relocation / redirection do I use in Cold BL fusion to get page to show using this certificate. BL I am showing a age to enter credit card numbers. I am using BL CFLOCATION url= BL https://www.mycustomer.com/index.cfm?fuseaction=cart.dspcrditcard BL https://www.mycustomer.com/index.cfm?fuseaction=cart.dspcrditcard token=yes BL NOTE: there is an S in the https .. BL Is this the correct way to do this?? BL I am getting a page unable to display. If I change the same URL to http BL it will work. BL Any suggestion and/or idea would greatly be appreciated. I really need BL to get this to work. BL Bartee Lamar BL www.enterpriseenergy.com http://www.enterpriseenergy.com/ BL MSN mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] BL ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: [OT] Zip Code Lookup
If you're using the JCSM database, here's a simple query to pull out all the zips within #radius# number of miles. !--- zip search is here --- CFPARAM NAME=Radius DEFAULT=50 CFQUERY NAME=geoCode DATASOURCE=Zip_Search SELECT lat, lon, Zip, LastLineCity, State FROM jcszip WHERE Zip = '#zip#' /cfquery !--- find cities close to a given zip --- CFQUERY NAME=findLocal DATASOURCE=Zip_Search SELECT jcszip.Zip, jcszip.LastLineCity, jcszip.State, jcszip.Lat, jcszip.Lon FROM jcszip WHERE (((jcszip.lat)= (#geoCode.Lat# - (#Radius# * 0.0005)) And (jcszip.lat)= (#geoCode.Lat# + (#Radius# * 0.0005)) ) AND ((jcszip.lon)= (#geoCode.Lon# - (#Radius# * 0.0005)) And (jcszip.lon)= (#geoCode.Lon# + (#Radius# * 0.0005)) )) ORDER BY jcszip.Zip /cfquery We purchased this fairly recently and we love it. -- jon -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Friday, November 15, 2002 5:04 PM To: CF-Talk Subject: Re: [OT] Zip Code Lookup charlie griefer wrote: I'm building an application where i need to do the 'search within x miles of zip code 12345' Can anybody make a recommendation? The client would like something that offers updates fairly regularly. Maybe even some sort of XML feed direct from the (a) source? Any leads would be greatly appreciated. Oh, and would be nice if it integrated easily with CF (to kinda bring this question a little bit on topic) :) Strategy and options depends quite a bit on the usage pattern and the financial room. I will just presume it is for nearest outlet matching for now. If it is for the occasional lookup, I am sure there are webservices where you can pay per hit. Easy and all the database maintenance is done for you by the remote partner. But it might be a bit clumsy if you get back a long list of ZIP codes that you then have to match against your own database of outlets. And if you get a lot of hits, paying per hit might not be the best model. Another option would be to buy a ZIP database with subscriptions for updates and a bunch of tags for running queries on them. But again, it might be a bit clumsy if you want to match those results with another database of outlets. The last option is to buy the ZIP database and built your own search system for it. It really isn't that hard to make the database do distance calculations based on lat/lon pairs, and unless you have a very special set of datapoints using a smart algorithm and some indexing will make it very fast, especially since you can do the outlet matching in the database as well. I would probably go for option 3, unless there is a business reason for doing number 1. Let me know if you want some code for option 3. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Importing Studio snippets into DW?
How can I import my Studio snippets into DW? -- jon mailto:[EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: secure email...
I use the IIS SMTP server that sits on the same server that CF is running on, and set it to only allow connections from 127.0.0.1 Keeping the whole process one one server makes it easier to debug a possible email problem too. If the email isn't in the iis badmail or the cf undlvr folders, it left our server, no if's and's or but's. -- jon mailto:[EMAIL PROTECTED] Saturday, November 16, 2002, 8:03:42 PM, you wrote: PL so we are in the process of changing email servers and we toggled PL relaying on and somehow the malicious spammers found it in record time PL and started bombing us with email to broadcast... That we are going to PL address on Monday in litigation against the sending companies... PL I was wondering how people were dealing with email from Cold Fusion PL applications to respond to such issues... Since CFMAIL doesn't support PL any login and password login type stuff... PL We have applications like mail to a friend that are particularly PL troublesome where the origin is an email that is not local to our PL servers and the recipient isn't local either... by every definition it PL fits the whole looks like spam definition to a properly closed email PL server... PL Interested in hearing what everyone is doing :) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
OT: Serverwide SSL's
Does anyone have any experience with server wide SSL's? We have one client, who is going to be bringing up 15 or so domains to this server, and I am thinking that a globabl cert may be cheaper... I thought I had seen something about a global server certificate on Verisign or Thawte's site once, but the information I am finding is sparse or may be old. Anyone have any pointers? -- jon mailto:jonhall;ozline.net ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: SOT: Sad Day
Will there be a Community Manager MX beta program? ;) -- jon mailto:jonhall;ozline.net Monday, November 11, 2002, 11:52:56 PM, you wrote: MC this is from an email that i sent out earlier: MC We will be providing more information on a new, enhanced community MC manager position in the very near future. This is first of a number of MC steps that we are taking which will allow us to be more responsive to MC and aggressive within the ColdFusion community. We will send out MC additional details about this new position very soon. MC mike chambers MC [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: SOT: Sad Day
Ever want to respond to an off-topic thread, asking to please keep it on topic, but then think that maybe it will just end when everyone says their piece, but then it continues to go on, then you think about sending that email again, then stop again...and the thread continues to go on, then... Pardon me while I go wrestle with my own internal demons now. jon ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: webConference software
Doesn't MSN Messenger have something like that built in? Haven't tried it... but I seem to remember something to that effect. -- jon -Original Message- From: Brian Scandale [mailto:Brrrian;Excite.com] Sent: Thursday, November 07, 2002 6:22 PM To: CF-Talk Subject: webConference software Looking to find some cheap or even free Web Based conferenceing software that I can use to demo a CF WEB based application with. That is... when I enter data and post getting a result set from the CF Server... the prospect also gets that data sent to his browser to render. Not really looking to re-write the app to include this feature but thought there might be a clever solution I could try. Open to suggestions. ;-) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
fast compare?
Using MX is there a relatively simple way to do a fast compare of two large string arrays? I need to know if an element in an array is contained in the another. Currently I'd use something like this for(o = 1, o LT arrayLen(ary1), o = o + 1) { for(i = 1, LT arrayLen(ary2), i = i + 1) { if(ary1[o] EQ ary2[i]) { //match... } } } This obviously does not scale well. Given the fact that I am not a CS grad (no quicksort, not ready for that :)), does Java have a good way to do this kind of compare, that I could use in MX, or is there another way? -- jon mailto:jonhall;ozline.net ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: Really bad cfc performance?
FYI the program is an addon to our shopping cart that allows people to visually construct an html email from their database of products. Spammers don't worry about dupes and remove lists either... -- jon mailto:jonhall;ozline.net Saturday, November 9, 2002, 3:02:06 PM, you wrote: s It just occurred to me, are you working for a spammer? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: Really bad cfc performance?
Saturday, November 9, 2002, 9:01:36 AM, you wrote: -Original Message- From: jon hall [mailto:jonhall;ozline.net] Sent: Friday, November 08, 2002 4:22 PM To: CF-Talk Specifically what I was trying to optimize was a check to see of an email address was a duplicate, valid, and not in a remove list. This would require 2 database queries and a run through the validate method. SA Aside... Why even have a remove list ? Why not have a remove flag in one SA table? That's the way I have it...it's an import routine, new addresses are coming from a cvs file uploaded... -- jon mailto:jonhall;ozline.net ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: OT: Using Javascript to disable backspace key with exception
You are calling this function onKeyDown right? Just leave the function call out on the textarea you don't want to trap the backspace key on. Also event.which is NS4's version of event.keyCode. If you do a little object detection you can make this script work cross browser... if (document.all) keyPressed = event.keyCode; if (document.layers) keyPressed = event.which -- jon mailto:jonhall;ozline.net Friday, November 8, 2002, 9:52:27 AM, you wrote: JT I am using Javascript to disable backspace key. It works fine. The only JT problem is that I need to have the backspace key functional for only one JT field on my form. JT Here is the current script I am using: JT - JT script JT function checkShortcut() JT { JT if(event.keyCode==8 || event.keyCode==13) JT { JT return false; JT } JT } JT /script JT - JT How can I modify this script to include backspace for my one textbox? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.