RE: MySQL Conversion
then remember that MSSQL Express is also FREE limited to 4GB in size. if you definitely want to end up with MySQL then it would be easier to use the built in wizard to upsize from MSAccess to MSSQL then (if you still want to) ... convert from MSSQL to MySQL i would bother trying to use the MySQL Migration Tool Kit. ive never had much luck with this. I've converted many DBs from MS to My. So many that i bought some third party software to do it for me. takes about 30 seconds. Let me know if i can help out. zac Regards, Zac Wingfield Operations Manager For and on behalf of, Allied Facilities.com Limited 01903 723999 7 Wickham Business Centre Harwood Road Littlehampton West Sussex BN17 7AU For more information about Allied please visit: http://www.allied-facilities.com -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: 20 April 2011 11:20 To: cf-talk Subject: Re: MySQL Conversion You would probably find it easier to upgrade to MSSQL, which is better anyway in so many ways than MySQL esp if you are on windows (speed, performance, reliability, scheduled backups, automated maintenance, no table corrupting issues, no horrid SQL dumps to name a few). Presumably if your using Access you must be on a windows host, so MSSQL is probably available to you. If you are choosing MySQL only because it is free, as many do, then remember that MSSQL Express is also FREE. You have an upgrade tool built in to MSACCESS, and Microsoft also provide free migration tools as well. just something to consider. On Wed, Apr 20, 2011 at 7:22 AM, Azadi Saryev azadi.sar...@gmail.comwrote: how are you migrating your db? mysql used to have a migration toolkit as part of mysql gui tools bundle which handled access-mysql migration very well. the gui tools have now been replaced by mysql workbench, but you can still download them from mysql website. gui tools: http://dev.mysql.com/downloads/gui-tools/5.0.html workbench: http://dev.mysql.com/downloads/workbench/5.2.html mysql equivalent of access's autonumber type is an Integer column with auto_increment attribute. http://dev.mysql.com/doc/refman/5.5/en/numeric-types.html (bottom of page for auto_increment attr info) you can also set/change the next auto_increment value to use on mysql column: ALTER TABLE t2 AUTO_INCREMENT = value (from http://dev.mysql.com/doc/refman/5.5/en/alter-table.html) all this and much much more is covered in mysql reference manual on mysql website: http://dev.mysql.com/doc/ another point to keep in mind: if you cfqueries used any access-specific syntax you will have to re-write them to use proper sql to work with mysql db. Azadi On 20/04/2011 13:46 , Scott Williams wrote: Oy -- I shouldn't have started this one until the weekend. I'm converting from MS Access to MySQL on one of my ColdFusion sites, and having problems converting my Autonumbered Access tables to MySQL format. They just won't import at all. If I remove the primary key and change the format to Integer instead of Autonumber, the tables import. The real problem is when I try to add data to these tables later. It will take one additional record (numbering it 0), then won't take anymore because then there would be two 0s. How can I get a MySQL table to autonumber like Access? Scott ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343868 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Good CF Host in Texas
try gowestweb.com over your way somewhere, not exactly sure where though Regards, Zac Wingfield Operations Manager For and on behalf of, Allied Facilities.com Limited 01903 723999 7 Wickham Business Centre Harwood Road Littlehampton West Sussex BN17 7AU For more information about Allied please visit: http://www.allied-facilities.com -Original Message- From: Jenny Gavin-Wear [mailto:jenn...@fasttrackonline.co.uk] Sent: 15 April 2011 11:11 To: cf-talk Subject: RE: Good CF Host in Texas Do NOT use Vortech. A Texas based hosting company that gives awful service. -Original Message- From: Les Mizzell [mailto:lesm...@bellsouth.net] Sent: 15 April 2011 06:06 To: cf-talk Subject: Good CF Host in Texas Client is requesting that hosting *has* to be in Texas. I've NO idea why. But - anybody familiar with good reliable, CF hosting in Texas with *helpful* 24/7 tech support? Most of my stuff is either at hosting.com or CrystalTech, niether in Texas TIA ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343744 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Good CF Host in Texas
yes sorry everyone. i was thinking of gowestwebdesign.com which is the same company. isn't Utah just up the road from Texas? :-) Regards, Zac Wingfield Operations Manager For and on behalf of, Allied Facilities.com Limited 01903 723999 7 Wickham Business Centre Harwood Road Littlehampton West Sussex BN17 7AU For more information about Allied please visit: http://www.allied-facilities.com -Original Message- From: Peter Donahue [mailto:pdonah...@satx.rr.com] Sent: 15 April 2011 14:57 To: cf-talk Subject: Re: Good CF Host in Texas Good morning everyone, If you mean www.GoWest.com they're in Utah not Texas. Peter Donahue - Original Message - From: Zac Wingfield z...@allied-facilities.com To: cf-talk cf-talk@houseoffusion.com Sent: Friday, April 15, 2011 5:25 AM Subject: RE: Good CF Host in Texas try gowestweb.com over your way somewhere, not exactly sure where though Regards, Zac Wingfield Operations Manager For and on behalf of, Allied Facilities.com Limited 01903 723999 7 Wickham Business Centre Harwood Road Littlehampton West Sussex BN17 7AU For more information about Allied please visit: http://www.allied-facilities.com -Original Message- From: Jenny Gavin-Wear [mailto:jenn...@fasttrackonline.co.uk] Sent: 15 April 2011 11:11 To: cf-talk Subject: RE: Good CF Host in Texas Do NOT use Vortech. A Texas based hosting company that gives awful service. -Original Message- From: Les Mizzell [mailto:lesm...@bellsouth.net] Sent: 15 April 2011 06:06 To: cf-talk Subject: Good CF Host in Texas Client is requesting that hosting *has* to be in Texas. I've NO idea why. But - anybody familiar with good reliable, CF hosting in Texas with *helpful* 24/7 tech support? Most of my stuff is either at hosting.com or CrystalTech, niether in Texas TIA ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343746 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFM Generators
I just picked this up from another post but i thought it deserves it's own thread. http://www.sebgen.com this is brilliant! ive never come across anything like this before. Also there are full apps on there. Many thanks Steve Bryant :-) If anyone else knows of similar sites please do post some links. thanks zac ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343406 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFM Generators
Cool, book marked, thanks again zac If anyone else knows of similar sites please do post some links. Zac, Thanks for the kind words. The best place to look for these sorts of things is Charlie Arehart's brilliant CF411. I see that I haven't asked Charlie to list my generator yet, so I will try to do that soon. Here is the category for CFML Code Generators: http://www.carehart.org/cf411/#cfmlgen He has lots of other useful categories as well. I visit it frequently, and I am always surprised at the wealth of information contained within. Steve ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343418 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Open source ColdFusion forums
what i'd really really really like to see is a fully blown cfml hosting control panel. so not just a control panel that integrates with CF but a control panel that is built on CF. probably built around Railo if you were to go the open source route. the hosting control panel would handle everything from resource allocation to billing to auto account creation and even domain registration. fancy biting that one off? :-) zac P.S. lots of individual packages already exisit that could be brought together to make this happen. FileZilla for FTP LightHouse Pro for bug tracking and support CF-works for billing you get the idea... the list goes on Hi everyone, I've recently taken a new job that has opened up some free time for me, and I'm considering a project I'd thought about long ago but never had time to implement. I'm curious if there is any interest in the development of an open source, ColdFusion-based forum application. The goal would be something comparable to vBulletin or PHPBB done in ColdFusion, done in open source style, completely free. It would seem that Ray's Galleon forums project is still alive and well, so with one open source forum application out in the wild I'm unsure if there is really need for another. So first, I want to be sure there would be interest in such a project; would the community welcome a second open source forum application in ColdFusion? Would anyone use it? Is there really a need for one? Is there some other category of software that I could invest time into that would be better served? I've been writing ColdFusion for over a decade, like many of you, and am interested in contributing back to the community. I welcome any thoughts or feedback you might have. -Justin Scott ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:34 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: social networking app in CF
Hey, thats brilliant! are you sharing it? perhaps post it on riaforge http://www.riaforge.org/index.cfm?event=page.categoryid=1 nice work! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343296 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
who's in charge around here?
having just recently found H.O.F ive used it a few times. there are some really helpful, knowledgeable guys monitoring these lists and Iâve received some great help from the CF Newbie list. however the web site needs some attention. it's slow to respond and poorly presented. why are all the adverts over on the right hand side? they take up a whole quarter of the page. why must we be subscribed to each list before we can post? when viewing a thread sometime it's all displayed, other times i have to refresh the page, cant quite work it out. considering how much experience there is floating around here i guess i just expected it to be a little bit better put together. I know communities like this are normally built up from people either donating their time or cash so, if it's needed, Iâd like to volunteer hosting services. I'll have a new server online within a couple of weeks. let me know if you're interested. Z ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343190 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: who's in charge around here?
Perhaps you'd better enjoy the mailing list vs. the web interface? yes good point. i try not to respond directly via email because of my email header/footer. I use my work email address for everything which is unrelated to any web dev work that i do. I work for MI5 so i wouldnât want people to find out :-), oops! Are you volunteering to help MD with a new design? yes i'd love to be involved. not sure i'd like sole responsibility though as i am still a bit of a newbie anyone else willing to put their name on a list? z ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343194 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: who's in charge around here?
ok, i'm getting idea about using it as a mailing list. :-) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343212 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: WYSIWYG inline editor on mac browsers
On Wednesday, October 8, 2003, at 06:01PM, Peter Tilbrook wrote: Perhaps the open source FCK Editor? (http://www.fredck.com/FCKeditor/) From their webpage Requirements Client Side: Internet Explorer 5+ over Windows with _javascript_ enabled (for rich text editing) I think that it only works on IE/Windows as it didn't work on any of the browsers on my Mac. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Access database 401 error
We are running into an unreproducible error when trying to connect to an Access database using CF 5. Our system has a series of scheduled events and in some cases our clients are reporting a 401 Unauthorised error when the scheduled event tries to connect to an Access database. The database connection is stored as a verified ODBC connection in the CF Administrator. Has anyone seen this error before? TIA [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:Access database 401 error
This error isn't related to the database connection.A 401 means that your web server has the requested URL protected and the client (in this case, the ColdFusion scheduler) is being rejected by the web server.The ColdFusion scheduler connects to the server as an HTTP client (so, it looks like a browser to the web server).You can enter a user name and password into the scheduled event so that the HTTP request will include a login. I tried to verify this with the client already (it was my first idea) and (according to them) they have set up the directory so that IIS has access to it and permission to access the directory. I'll double-check this with them to make doubly sure that this isn't the case Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Copying session vars to request scope
Can anyone see any reason why you wouldn't want to copy session scope variables to a request scope variable if all you want to do is to test the values in them but not set them? It strikes me that this would be more efficient than locking the session scope each time you wanted to test the variables. But then again I might be missing something really obvious :-) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Copying session vars to request scope
On Tuesday, October 7, 2003, at 06:02PM, Dave Watts: In my experience, this has occasionally caused severe performance degradation, so you'll want to be very careful when doing this. In general, I'd try to avoid doing it at all. Really?That is quite surprising. So is it the duplication of the struct that is causing the performance hit? As others have mentioned, this often isn't necessary with CFMX. I'm just starting to write some code for MX and this is one of the things I am trying to be very careful of Finally, you should be very careful when attempting to apply common sense to expected performance outcomes. Or anything associated with application development in general :-) Thanks to everyone for the links and comments [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: XML Serialisation
Neil Middleton wrote: Guys, I'm after a tag or function which can convert a complex cf data type into an xml packet. I've seen the ones on CFlib that convery queries and structs but I'm after one which can do combinations of datatypes all in one go and return a valid xml packet. I would use WDDX but I'd like XML as opposed to WDDX and I would also like the node names to match the object names within the cf data object. Am I asking too much or is there one out theresomewhere? sounds like you want to re-invent the wheel... everything you describe here about wanting over normal xml is provided by wddx WDDX is a xml as for node names it's more complex in xml than plain old cf structures... wddx rocks and it just plain works and is widely supported outside cf z ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: mx tag help/insight for studio 5
Massimo Foti wrote: I have CF Studio 5 and am just starting to code for MX a bit. Is there anyway I can get tag insight and help files for the new MX stuff such as cfc's? I looked around on the macromedia site a bit but couldn't find anything. The files for Homesite+ should work just fine for CF Studio as well: http://www.macromedia.com/software/coldfusion/downloads/ there are two files here, homesitetags.zip and homesiteextensions..zip there is under homesiteextensions an empty tagDefs tree but no VTM's homesitetags contains vtm's for pre MX tags presumably updated... but there's no cfcomponent.vtm for example so still no joy z ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: OT: packet sniffer
Michael T. Tangorre wrote: I am in the hunt for a tool that will allow me see the http traffic to and from ym machine. I am trying to debug an application that makes http posts to some servers and need to see what im sending and receiving. I have ethereal now, are there any alternatives (free if possible). try mozilla with http://livehttpheaders.mozdev.org .. it really rocks or http://www.proxomitron.info/files/index.shtml which is a filtering proxyserver, which is cool anyway, but it has a log window where you can also see all the http requests live zac ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Cold Fusion Studio 5 CFMX tag updater?
is there a tag updater for cf studio 5.0 which contains CFMX tags, the only one i find on the MM site is http://www.macromedia.com/software/coldfusionstudio/productinfo/resources/tag_updaters/ and it doesn't contain anything except vtms for cf 5.0 era tags z ~| 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
Mach II 1.0 released
Mach II has been released http://www.mach-ii.com with three sample apps, roulette, contactmanager and shopping cart redsky required being australian, I am thinking this is more of the usual aussie jvm date problems as i'm hitting a date problem on the parsing of the xml config file.. anyone got any pointers? z ~| 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. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Mach II 1.0 released
zac spitzer wrote: Mach II has been released http://www.mach-ii.com with three sample apps, roulette, contactmanager and shopping cart redsky required being australian, I am thinking this is more of the usual aussie jvm date problems as i'm hitting a date problem on the parsing of the xml config file.. anyone got any pointers? ok, it's fixable with a lsparsedatetime on the MachII\framework\AppLoader.cfc shouldReloadConfig cfset lastConfigDate = configFile.dateLastModified/ becomes cfset lastConfigDate = LSParseDateTime(configFile.dateLastModified)/ now I'm on a (shudder) old win98 box here so maybe it will work different on w2k etc, but having CFDIRECTORY return non-parsable dates for datelastmodified is REALLY dumb MM! Zac ~| 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: CF tag for highlighting text in a textfield?
Jerry Johnson wrote: I don't think you can highlight in a textarea. you can do this actually... you can also move the cursor in a text field or select part of it... here's a good start .. mozilla is way ahead on the easiness too.. ie is a bit more difficult FAQTs - Knowledge Base - View Entry - How can I manipulate the selection and the caret in an input type=text element in NN6 and IE? http://www.faqts.com/knowledge_base/view.phtml/aid/13562/fid/130 what makes text areas more difficult is they aren't treated like a string if i remember right, they r access more by rows and columns zac ~| 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: Page Context Bug?
Matt Liotta wrote: It does make it difficult to write efficient frameworks using CFCs tho' so, for example, Mach II will require Red Sky to run efficiently. I'm glad you finally admitted that. so matt, you said a while back it was impossible to write mvc frameworks in cfmx, with the advent of redsky, has this changed in your opinion? z ~| 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: MachII Speed (was RE: Mach II)
Haggerty, Mike wrote: 1) Speed. Each page took 700 ms to generate with debugging off. This was using a slow server: Apache / XP / RedSky / Celeron 733 with 512 MB RAM. However, FB3 pages doing just about the same amount of work average ~100 ms on the same server. coz of the page context bug, mach-ii currently recreates itself on each request you have redsky, so it should work, try commenting out line 19 in framework/requesthandler.cfc cfset application.appManager = / z ~| 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: cf5 - ColdFusion Graphing Server = JRun??
Any other suggestions? I'm running cf5 on my laptop and I noticed that the graphing server is JRun.exe. So does this mean that I can use it as a jsp container? guys, i am prettys ure this is a runtime limited use version of jrun license wise, you can't use it legally for anything else than generator (or graphing server) z -- zac spitzer - mailto:[EMAIL PROTECTED] http://fraggle.datagear.net/ radio://+61 405 847 168 / fixed://+61 3 9528 6775 ~| 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: New to Java and MX
I've tried this (mind you I am totally lost) cfobject type=JAVA action=Create name=myFtp class=Ftp cfset ret = myFtp.init() cfset ret2 = myFtp.main('ftp.server.org') The first two lines seem accepted fine, but when I add the third, it starts throwing errors. Any help would be appreciated. what's the errors being thrown? z ~| 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: all records deleted from table
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Kay Smoljak wrote: | A long time ago, I made a really stupid mistake that results in | deletion of all data from a table... | | | A tip I picked up from somewhere - it might even have been this list | - is to not ever actually delete records using code. Instead, I have | a dtDeleted field, which is set to the current date when I want to | delete the record. When doing selects, I add WHERE dtDeleted IS | NULL to get only non-deleted records. | good idea, badly implemented. a select using a null criteria cannot use a index and means the database must do a full table scan which means ~ bad performancetry changing your logic round so you can use an index... z -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+QSAM1lRHdy8ASusRAnb4AJoDt66u5fWbgibWEoFPmqmMu5AElwCeMmsK pSKubEkErq+ymszYSb/7QRo= =lz66 -END PGP SIGNATURE- ~| 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: all records deleted from table
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jochem van Dieten wrote: | Zac Spitzer wrote: | |Kay Smoljak wrote: || || A tip I picked up from somewhere - it might even have been this list || - is to not ever actually delete records using code. Instead, I have || a dtDeleted field, which is set to the current date when I want to || delete the record. When doing selects, I add WHERE dtDeleted IS || NULL to get only non-deleted records. || | |good idea, badly implemented. a select using a null criteria cannot |use a index and means the database must do a full table scan which means |~ bad performancetry changing your logic round so you can use an |index... | | | That is just a limitation of your specific dbms. Others can use much | fancier indexing schemes. (If your database supports it, look into | partial indexes for this type of problem.) interesting i think oracle (at least in the 8i world) ms-sql don't support it, which dbms *DO* support it? z -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+QSql1lRHdy8ASusRAtArAJwLPMHtUOvCWV9KR5Ronyoi9NljbQCgqla/ LwScJAm+7C2MZthJd2ZhqCA= =y9Ph -END PGP SIGNATURE- ~| 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: Replication - Mirroring Software for Linux?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Mike Brunt wrote: | We are about to add a new production environment that will be CFMX on Linux. | Can anyone recommend good replication software for Linux as this will be a | clustered environment. rsync would be a good starting point z -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+QTXk1lRHdy8ASusRAo7xAJ9KzZYoeyS1vVIOJ0Xanc2PJVJ2lwCfQ6s5 Kq2pxQBttF21IqS1N6X+HlI= =OR3t -END PGP SIGNATURE- ~| 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: sql 2000 vs sql 2000 enterprise
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Tony Weeg wrote: | can someone explain to me, very high level, what the difference is | between | | sql server 2000 Standard Edition | sql server 2000 Enterprise Edition | | we have 2000 ent edition on our servers now, however we are about to | configure 2 new ones, and my software ordering guys, got us standard | edition instead of what we already have, which is enterprise edition. | | thank you | | ...tony http://www.microsoft.com/sql/evaluation/features/choosing.asp for an overview chart or Choosing an Edition of SQL Server 2000 http://www.microsoft.com/sql/techinfo/planning/SQLResKChooseEd.asp is a good start i think standard is limited to four processors and enterprise is expensive i just noticed that a passiv or backup standby server requires no second license for sql server... coool :) z -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+QV7S1lRHdy8ASusRAoTTAKCWmkNG7EB+PX2K1oGrFsWN1LmjxgCfZSpr ml3Ak410pHxhlpUTgxExqwY= =i+Zp -END PGP SIGNATURE- ~| 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: Character Encoding - Reward Offered!
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Eric Hoffman wrote: | The xml got changed this year and it all comes back UTF-8 encoding. Is | this what you are looking for? but then the xml version would need to be 1.1 at the start, otherwise not if it 1.0...i think z -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+QWEP1lRHdy8ASusRAgJKAJ0cLkS2WsfNAl/dds3K9IbPBik33gCgt3DP W+RxEyNup/MpP6mg0PduQyM= =xwEJ -END PGP SIGNATURE- ~| 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
faxing from cf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 what r people using for online faxing solutions ( need to work in europe ) with only a tcp-ip connection z -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+PnEU1lRHdy8ASusRAiS4AJ9GQak0g/ir7TVjuL7cmo1Uq0MubACgrqsd 8LWBbrTA3PjHdMvAlXRti4w= =IgXy -END PGP SIGNATURE- ~| 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: Screening files before CFFile upload: Follow-up
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 webguy wrote: | becuase you can do this | | cffile action=read file=ntuser.dat only when cold fusion is not running under a restricted user acount z -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+OU961lRHdy8ASusRArGnAKCogbTj7BbBL7PPZHRu9g12GyylfgCgp275 gg1PNcWNatprfrHAziM/U+A= =muwX -END PGP SIGNATURE- ~| 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
Pet Market Benchmarks?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 does anyone know of some benchmarks of pet market against the java or .NET versions z -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+MDU31lRHdy8ASusRAiNeAJ9eEiyqEoWqt3CuQvB3zWUMw7QsnwCeME26 +ZVOfHQcmrk3L/jqBhvCiTM= =z5pa -END PGP SIGNATURE- ~| 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: PDF Conversion Tools Question
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 cflist wrote: | We use AdLib for converting large amounts of uploaded resumes in all | sorts of file formats to PDF. And it works great. | | We were using ActivePDF, and it worked well at converting, but the | application always seemed to hang and spit out errors, and after a | few moths of back and forth with tech support - we dumped it for | AdLib. i just downloaded adlib..looks nice but it's not ready yet for realtime conversion from what i see in the forums... are u using adlib simply in batch mode or can u generate a html document pass it to adlib and return the file reasonably quickly??? z -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+MHHA1lRHdy8ASusRAlgfAKCCi6WLY7g8NEDYGkzoZmFvw9TAtACfQoNQ tvv7vYn8PHkvv60GbP9MFaQ= =zvBz -END PGP SIGNATURE- ~| 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
SQL 2000 sp3
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 http://www.microsoft.com/sql/downloads/2000/sp3.asp z -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+LYPM1lRHdy8ASusRAofVAJ0Zz+wl/Rqa3wOuqXKE4oX+JLxWfACgrT/c xyQnPU3Jnbs3sMDvdb9M7Rk= =7GJK -END PGP SIGNATURE- ~| 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: Next N Navigation and query caching theory question
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 | needs to get run again? Should I do something like append the | CFTOKEN for that user's session to the query name so that it is | unique? Or should I store the query output as an array in a session | variable? store them in a session structure keyed on the query criteria, or if the results are the same for each user in an application structure.. never use arrays for such stuff, structs are better because they can be accessed via keys, not just numbers you will also have to manage this cache structure, deleting results when the database is changed z -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+KBHf1lRHdy8ASusRAi6LAJ9MKgFRC2maNlYbXHREM4TT6zW3owCbBts3 P4x9GoxQG0atg7m+1SQy1Y4= =wmFs -END PGP SIGNATURE- ~| 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
OT: mac cfmx zdnn et confused!
http://zdnet.com.com/2001-11-0.html?legacy=zdnn Macromedia heats up ColdFusion MX Adobe touts three new versions of its applications server software that will work with systems running on BEA's WebLogic, IBM's WebSphere and Sun's Sun ONE server software. adobe now makes mx? :-) z ~| 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: Text images on the fly
Does anyone have any pointers for creating GIFs on the fly? I would like to create dynamic headings for one of our portals (such as the quick link header on this page: http://my.georgetown.edu/) css2 would work 2 :-) cfx_image, imagemagik, cfx_image_cr from efflare.. the first 2 are free the efflare one is $99 but has better quaility and is a native cfx ( cfx_image is too) z ~| 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: browser stats, mozilla rising
few interesting stories around the web today about mozilla's market share rising... this is the stats from heise.de a big german news site, where mozilla based browsers now accounting for 19.4% of users http://translate.google.com/translate?u=http://www.heise.de/newsticker/data/anw-18.12.02-000/ found from a story on mozilazine http://www.mozillazine.org/talkback.html?article=2767 ~| 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: How to do this without the subselect?
Rick Faircloth wrote: Hi, all. How can I get the same results as this query with using the subselect? CFQUERY Name=GetWaivers Datasource=#DSN# Select UW.UtilityWaiverID from utilitywaivers UW where Month(UW.IssueDate) = #Form.Month# and Year(UW.IssueDate) = #Form.Year# and UW.ClientID not in (Select RW.ClientID from RentalWaivers RW where Month(RW.RentalWaiverDate) = #Form.Month# and Year(RW.RentalWaiverDate) = #Form.Year#) /CFQUERY (I'll be s glad when they get subselects in mySQL 4.2!) do a left outer join on RentalWaivers in the query and then do a check that where UW.ClientID is null (if, this is standard perfomance improvement anyway as it uses a index...) not in is actually a real bad performance killer... this technique is found in most good oracle books... should work for mysql but i don't know z ~| 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 : Mac / IE / OS X
Robertson-Ravo, Neil (RX) wrote: I'm running into some of the very problems you mention. I tried Decimal as the field type, but 100.5 gets rounded up to 101.00...not good. I tried Integer, but when, for example, 100.50 gets entered into a formfield, then inserted into the db, it gets truncated to 100. How do I set up Integer to retain 2 decimal places? cfqueryparam cfsqltype=CF_SQL_INTEGER Value=#LSCurrentFormat(LSParseNumber(Form.UCPaymentAmount))# CFQUERYPARAM value=100.5 CFSQLType=CF_SQL_DECIMAL scale=2 integers are whole numbers and you need to specific how many decimal points using scale as above... z ~| 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
Working with CF MMS enabled phones
anyone got any good pointers on working with these next gen gsm phones, like the nokia 7650 with the built in camera and GPRS? what do i need server side to recieve mms in coldfusion? i see there are two options, email or http(s) z ~| 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: Compare Two Lists - Keep What Is Similar
Scott Brady wrote: Hi everyone. I am looking for a way to compare 2 different lists of information, and after comparing them keep which records are exactly the same. I'd probably convert them both to arrays. Then, I'd loop along the first array and look for each element within the second array. If it exists in the second array, keep it; otherwise, delete that element from the first array. When you're done, whatever's left in the first array should be the items you need. You can do that keeping them as lists, but I think it'd be faster with arrays. no, structures would be faster would be faster...though where you use the load dataset1 into a structure load dataset2 into a structure loop over dataset2 if (NOT structkeyexists(dataset1,dataset2.id)) structdelete(dataset2,dataset2.id); or not deleete etc this is faster because the lookup is random, ( reminds be of basic data handling in MBASIC on my old CP/M box) structures are always faster for random access the array approach too much overhead, ie looping over dataset1.recordcount dataset2.recordcount times so 500 x 500 25 loops! above ends up being 1500 loops z z ~| 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: CFMX: Caching files
Dave Carabetta wrote: Hey all, I am running into an issue with CFMX apparently not showing the latest files that I place on the server. If I make a change to a file, say showdetails.cfm on my machine and load that page from the webserver, it shows me the previous page, not the page I just updated. I need to stop and restart the CFMX service in order to see my update. Why is this happening, and how can I prevent it? Dumb question I suppose, but do you have the Enable Trusted Cache option checked in the Administrator? thats for 'production' servers with static code bases, ie cold fusion can assume that the files never change and therefore doesn't check to see if the cfm file is updated since last time z ~| 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: Generating PDFs in CF
Ciliotta, Mario wrote: Hi, I was wondering if anyone has any information on how to create a PDF on the fly in CF. I have been told to look at Active PDF, but right now there is no money to purchase that tool, so I was looking of either a custom tag or maybe an article or two on how to do this. We are currently using CF 4.5 but will be using CFMX for J2EE within the 1st quarter of 2003, so maybe even a JSP library that does this would be an option. http://www.easysw.com/htmldoc/ produces pdfs using html 3.2, no css/style support but it's free, which is the same as active pdf without the ie option which is slower and no 100% perfect... there a tag in the tag gallery called cf_html2pdf which is a wrapper for it z ~| 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: Verity vs. SQL Server 2000 Full-Text
Matt Kornguth wrote: Would love to hear people's feelings and relative advantages/disadvantages of each.Need to make a decision and I'm vacilating between the two. really simple advantage of verity is that it's way more intelligent than sql-2000/full text/index server truy searching on msdn which uses the ms stuff, very limited.. verity returns much better matches on the same data set z ~| 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: Verity vs. SQL Server 2000 Full-Text
paul smith wrote: In my experience with storing recordsets in cached structures, subsequent reading records from the structure was slower than reading the same records from a cached query. Is this expected behavior, or did I screw up? (first time again) probably, show us your code... you should only need structkeyexists and never structfind anyway quasi code cflock timeout=4 throwontimeout=No type=READONLY scope=APPLICATION cfif NOT structkeyExists(application,search) cfset application.search=structnew() /cfif cfif structkeyExists(application.search,search_string) cfset qry_search=duplicate(application.search[search_string] cfelse cfsearch name=qry_search criteria=#search_string# cflock timeout=5 throwontimeout=No type=EXCLUSIVE scope=APPLICATION cfset application.search[search_string]=qry_search /cflock /cfif /cflock ~| 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: mySQL CF (url injection info)
Cary Gordon wrote: CFQueryParam gives you an easy way to validate the query params. Some clever, bored hackers have figured out how to do things like pass a drop table query through the header. It is an even easier exploit if you are passing query parameters through the url string. a simple example .. passing the column name instead of a value can get very damaging delete from comments where comment_id = #comment_id# which when #comment_id# = comment_id means delete from comments where comment_id=comment_id or as comment_id=comment_id is always true actually becomes delete from comments neat huh? or with users update user set password='#password#' where user_id=#user_id# nice way to reset all passwords on the site z z ~| 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: CF 5 PDF - FDF files
You really only NEED activePDF (or something similar) if you want the users to be able to save the generated PDF files with the fields filled out. If you just want them to print it (without being able to save the files), you can do it all within CF. (I believe there is a custom tag which can do this for you) see htmldoc, htmldoc is free but only supports html 3.2, without css, active pdf can do css via ie but it's slower, by default active pdf is functionally almost the same as htmldoc Ie html 3.2 without styles htmldoc is also open-source cross platform now if only someone would just hookup gecko ( mozilla) to output (PS) postscript to pass to a PS - PDF converter... that would be s cool z ~| 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: Lists vs. Arrays vs. Structures
Michael Dinowitz wrote: I think that a new array search function might be in order here. Something to look through an array for a value and return its index. I'm not sure what you are really trying to accomplish here. I agree with matt, are you working on the maketree tag in cf? lets talk examples... do you modify the array, ( ie inserting or deleting array members other than from the end?) if not then u could index the array using structures cfscript item_array=ArrayNew(1); item_struct=StructNew(); /cfscript cfloop query=qry_items cfscript x=arraylen(item_array); item_array[x]=qry_item.item; item_struct[qry_item.item]=x; /cfscript /cfloop find where dog is in the array = item_struct[dog] or item_struct.dog this method is so fast scaling the dataset makes almost no difference in speed now you can always find the position of x in the array using the struct, this of course doesn't handle very well adding elements to the aray ideally I would try to eliminate arrays all together... esp when u consider that have 2 values in a struct, the key and the value z ~| 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: Lists vs. Arrays vs. Structures
Michael Dinowitz wrote: You can see the code here: http://www.houseoffusion.com/_library/maketree.txt Your example will fail as there can be more than one item with the same 'parent', which is what we're looking for. No matter what, we have to do a search and the list search functions seem to be the fastest of the searches around, even though the list items have to be parsed. ok gotta run, times short in a second but off the top of my head i would loop over the query first and then make each parentid a structure containing the items cfscript item_struct=StructNew(); /cfscript cfloop query=qry_items cfscript if (NOT structkeyExists(item_struct,qry_items.parentId) ) item_struct[qry_items.parentId]=structnew(); item_struct[qry_items.parentId][qry_items.itemid]=qry_items.currentrow; /cfscript /cfloop now everything is grouped by parentid now we know that the items in item_struct[0] are the first level, you could then loop over the collection cfloop collection=#item_struct[0]# item=child cfscript if ( structkeyExists(item_struct,child) ) // yes there are children add to the to be processed list else // no it's just a member with no children /cfscript /cfloop and so on... sorry time ran out z ~| 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: Lists vs. Arrays vs. Structures
Michael Dinowitz wrote: isn't structkeyexists better than structfindvalue? as our jedi friend says, after not evalutating, cflocking I think that's his next biggest tip It's better if you just want to know if the value exists. I need to know where it exists. my experience is that structures are always *way* faster than lists or arrays.. basically because structures are key indexed Do you have any code to show this? I'm not seeing *way* faster. ok, it depends on what we are talking about, I would usually use a single depth structure, ie kinda of denormalising the data structure... to provide an indexing function, that returns references, know what i mean? structfindvalue isn't going to be using hashing in cf is it? ie a full table scan... my approach is only to work via struct keys, as they are hash indexed anyway, throw some of your code up and we can explore the ideas... z ~| 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: Lists vs. Arrays vs. Structures
Michael Dinowitz wrote: I'm rewriting my CFMakeTree tag in order to make it tighter and work in CFMX better. One of the assumptions I had was that Lists would be problematic in comparison to Arrays or Structs. My first test was to find a value in one of these data collections. For Lists I used ListFindNoCase. For Arrays, I looped over the array to find the value and for Structs I used StructFindValue(). I ran each test in a 1000 isn't structkeyexists better than structfindvalue? as our jedi friend says, after not evalutating, cflocking I think that's his next biggest tip my experience is that structures are always *way* faster than lists or arrays.. basically because structures are key indexed z ~| 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: Nested Query Loops
Jeff D. Chastain wrote: I was referring to the inner query using the full scoped name - variables.queryName. So, why does setting newQueryName = variables.queryName PRIOR to looping the first query change anything? Both variables are in the variable scope and are created prior to the first loop - they should be the same right? cf loses track of the currentrow when nesting, you need to track it, ie cfloop query=qry1 cfset qry1_row=qry1.currentrow cfloop query=qry2 cfoutput#qry1.name[qry1_row]# #qry2.name#/cfoutput /cfloop /cfloop z ~| 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: Nested Query Loops
Jeff D. Chastain wrote: I am not even making it that far. I am getting an error on cfloop query=qry2 stating that qry2 is not a recordset. If I do a cfdump prior to the first loop, qry2 is a recordset with several rows of data. If I do a cfdump right before the second loop (i.e. inside the outer loop), then qry2 is null. For some reason the variable is just gone. umm is qry2 by anychance a column name in qry1? z ~| 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: Checking SESSION variable
FlashGuy wrote: Hi, I have session variable that contains the directory name session.strFileName. I also have another session variable session.ShowMe that contains multiple directory names (comma-delimited) which i'm setting from my database. Basically, i need to check if the directory session.strFileName exists in the variable session.showme. Example: session.strfilename = 'mywork' session.showme = 'c:\temp\dir1,c:\temp\dir2,c:\temp\mywork,c:\temp\mywork2' use a struct, it's more reliable faster than a comma delimetered lists z ~| 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
Craig Dudley wrote: I'd stick to cfx_image then, it works well, can read and convert many, many formats. It's fast enough as well, as long as you don't run it on the front end of your site. just make sure your using the latest version too http://www.kolumbus.fi/jukka.manner/ z ~| 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: When CFHTTP fails, use WGET
Craig Dudley wrote: I use a self written java cfx, took 2 hrs to write (I'm a java n00b) and is massively faster than cfhttp, granted it's a little more simple but it works well. Using a w32 utility with cfexecute is likely to be even slower than cfhttp, I wouldn't go there to be honest. If your'e already doing it, I'd think again. agreed for simple stuff, but wget is much, much more than a simple http tool, it's a spider, it can process the files, do ftp and it's XP, it runs on linux etc... for example YAST ( the setup config install tool from suse ) uses wget for all network stuff.. z ~| 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: Application variables
Bryan Stevenson wrote: You have to restart CF to reset APPLICATION vars (timing out the app might work too). application=strucnew(); z ~| 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: How to get a JPEG's width/height (not cf_imgagesize)?
Bob Haroche wrote: I need to determine the width and height of JPEG's being uploaded. I've used the free cf_imagesize but it sometimes returns the wrong dimensions. I'm told it's just buggy with JPEG's. I'm deploying to a shared hosting situation so I can't control what can be installed on the server, but the server does presently support cfx_image. I see that cfx_image does have a getsize command, but I still can't figure out the command syntax of this tag? Can anyone help on that front or recommend an alternative to cf_imagesize that doesn't require additional installation on the server? if you are uploading via a web form, u can use the browser to get the values... create an onchange on the file input field and then use js to set an img src to the value from the file field and then access the img size via js z ~| 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: Gif Pipes
Jochem van Dieten wrote: Adrian Lynch wrote: www.depressedpress.com used to have something but the site isn't working for some reason. another way to do this that is becoming more common is like this document.write('script src=j.cfm?id=3opt=4/script'); j.cfm then returns javascript which gets added to the body of the document... ~| 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: java cfx and administrator woes
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 | Any suggestions on what to try next? do you have the CF 5.0 hotfixes installed? z -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE90nMU1lRHdy8ASusRAi9WAJ9ij1hsFR9XDwft+/0YuoNW+2vt5QCfe+ok 1sqA4Y8fy51re9SfhR7mHJM= =NmnJ -END PGP SIGNATURE- ~| 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: good Meta taggers
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Carlisle, Eric wrote: | Hi CF-Talkers, | | I'm looking for a good meta tagging mechanism -- something that'll build | good description and keyword meta tags from text content. FYI: meta keywords are dead, google never even read them http://searchenginewatch.com/sereport/02/10-meta.html z -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE90OWC1lRHdy8ASusRAmHvAJoDfjaHtcQiKRQ9z2B6PZ8CsaB4+gCfYppB Y1BAHGIs9zfR/7yfxCLKoFg= =M/Xe -END PGP SIGNATURE- ~| 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
cfqueryparam in MX
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 [EMAIL PROTECTED] wrote: | Well, it's good to learn Rick. For further reading on cfqueryparam | check out Ben Forta's article: | | http://www.macromedia.com/desdev/articles/ben_forta_faster.html | | Anyway, I would advise anyone working with *any* db to use queryparams. | You'll be doing yourself and your database a favor. Granted, not all | databases use the speed advantage, but the security of it is worth it. does cfqueryparam work with cached queries in MX? that is the only downside of cfqueryparam in Cf 5.0 z -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE90SfW1lRHdy8ASusRAohSAJ0e0FdmVXOyeQ+SFnuPqQ1xiXOWmgCeImPt ZjTSkX3+tc2LaFc8CIEtHpc= =2zow -END PGP SIGNATURE- ~| 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: Compare code on two pages...
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Adrian Lynch wrote: | Print out both versions, put them together and hold them up to the light :OD | | | -Original Message- | From: Chris White [mailto:whitec;earthlink.net] | Sent: 12 November 2002 13:10 | To: CF-Talk | Subject: Compare code on two pages... | | | I have the need to take the same page but there different versions and see | what has changed. Is it possible to see the differences in two different | files using DreamweaverMX? What are others using if they need to compare | code to see what has changed? from the unix world there is diff, which is used for cvs http://directory.google.com/Top/Computers/Software/File_Management/File_Comparison/Windows/?tc=1 z -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE90Sud1lRHdy8ASusRAtzxAJ9v30cxeeF6hA2AZ3let0crQch7igCaAjMD iqOE4cnrVJ2VPgFldcrNfK8= =6OVd -END PGP SIGNATURE- ~| 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
w2k optimal directory size?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 anyone know what w2k ntfs5 's optimal file count per directory is? ie I have 1,000,000 files, splitting them in to dirs with 5000 files, or 1000 files per directory... this is for cfcontent returned content, linked to a db with a security check, so human usability/readabilty is not a factor... whats the optimal split? z -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE9z9Xp1lRHdy8ASusRApdYAJ0WfnmOpbPJXwmbffmsg+3dtZyGtACeKRc0 QxGCZ/gGRfdjRrbb19mUf/8= =A9Qd -END PGP SIGNATURE- ~| 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: JSP share with CF 4.5?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Chris Norloff wrote: | I have a request to get JSP's and CFML (CF 4.5) to share data. My first response is to say Easy - buy CFMX | | In the meantime, they'd like JSP's and CFML to share data. Can they share jsessionid or something? use your database :-) it's a common datastore z -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE9y5UO1lRHdy8ASusRAjDGAJ9SfVR39K0+GnYxIgKMDtXCxoSuEACgmdPs UowGkEIDH0F9eGQpIP9o6pc= =EPVL -END PGP SIGNATURE- ~| 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: Simple serial interface and CF???
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Kris Pilles wrote: | Can I read data vai SSI into a CF application??? | | We have symbol datawand III and I would like to read the data from the | wand directly into my app... can I do this??? if you can find a commandline tool (ie dos ) you can always cfexecute and then parse the results back in to cf z -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE9y+I/1lRHdy8ASusRAspmAJ9ZNT/EQkjLt97nkFRPED7OKBEoqgCfbjxv Eh3zuhacu1eiPFdDIfdlu2U= =HtXi -END PGP SIGNATURE- ~| 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: Deleting duplicate values in list
Dowdell, Jason G wrote: Hi all, Does anyone know of an easy way to delete duplicate values from a list. For example: List = Jason, Jeremy, John, Jason, Jack i think the quickest way is to create a struct, make each list item a key in the struct and then return the structkeylist z ~| 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: Running custom tag
FlashGuy wrote: Hi, I downloaded the custom tag cf_sleep. I changed the path of my custom tags directory to e:\inetpub\customtags and added the custom tag path via CF Administrator and deleted the default path of c:\cfusion\customtags. When I run my template with the cf_sleep I get the following error. Why? What does it mean? I run CFX tags no problem. Maybe CF only likes the custom tags to reside in c:\cfusion\customtags directory? Here is the error: Error Occurred While Processing Request Error Diagnostic Information here is your answer from your post :-) ... The JVM library path is empty. To use Java objects or Java CFXs, you need to install (if not already installed) the JDK or JRE and specify the path of the JVM in the ColdFusion Administrator. Please read the release notes regarding the version of the software that is needed. coz, cf_sleep most likey uses a java function to pause.. which needs a jvm to run, cheers z ~| 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: Max length of Text Data?
Matthew Walker wrote: You can't apply max() to a text datatype. So how about: SELECT MAX(LEN(CAST(textdatafield AS nvarchar(4000 If the result is 4000 then it will work. If not, it won't. Or you could use varchar(8000). and you can only stored 8000 bytes in varchars in a row total, you can define more than 8000 in the table, but once the total bytes stored in a row reaches 8000, ms sql server throws and error.. pretty huh? this something that doesn't happen with oracle :-) z ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: How can you get the latest version of a page.
Adams, Stephen wrote: Hi all, How can I get the latest version of a CF page. I am opening a page in a popup window and I want the latest version, not the one stored in the cache, I'm not sure how to do this can anyone give me any pointers. CFHEADER NAME=cache-control VALUE=no-cache, no-store, must-revalidate, max-age=0 cfheader name=Pragma value=no-cache which sets http headers that tells the browser don't cache the file, or when that fails becuase of a brain dead proxy server then add a random number or date to the url z ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: Page Expires
Everett, Al wrote: This is what I use: CFHEADER NAME=Expires VALUE=#DateFormat(Now(), 'ddd, dd-mmm-')# 00:00:00 GMT CFHEADER NAME=Pragma VALUE=no-cache CFHEADER NAME=cache-control VALUE=no-cache you can also use the confusingly named GetHttpTimeString(date_time_object) function for the same effect z ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: Counting Page Views
I have a spec on a project that has me counting page views in order to generate a 'most popular' list of the 10 most commonly clicked on links. Has anybody done anything like this? Initially I was thinking of a db counter that incremented a field in my db as people viewed the page. Is there a better way to do this? that is the right approach, you need the info in the db for the resulting query. if your site is high load, you could cache the value in an application var ( do lock! ) and update the db less often to avoid so many database updates z ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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
EU internet law resources
I'm looking for some information regarding EU law and the internet, with regards to user agreements, privacy and what is legal and what isn't, in plain english or better from a developer point of view things in the direction for example that the MS eula is not legal in the eu and what isn't for example how binding is a purchase contact for when i buy something online gotcha and what isn't allowed is really what I am looking for z ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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.
Cumulative Patch for SQL Server (Q316333) Crtical for 2000
Microsoft Security Bulletin MS02-056 http://www.microsoft.com/technet/treeview/default.asp?url=/technet/security/bulletin/MS02-056.asp have fun, yet another crappy m$ patch from with no installer and 2 pages of instructions and it's rated critical for all internet instances z ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: QofQ weirdness when using QueryNew
Ryan Kime wrote: OK, I really need some help on this one. I have a query I create on the fly using QueryNew/QueryAddRow/QuerySetCell. Everything is fine until I try to use a cfquery with dbtype=Query on the created query to order the results - it throws a QofQ runtime error. If I comment out the cfquery and call the original query created with QueryNew, it runs fine and spits out the data (albeit unordered). I could really use some insight on this. I need to get that query in a particular ordered format and time is breathing down my neck. Here's a code snippet, it dies right on the cfquery tag saying Unsupported Numeric type conversionyet it worked fine in CF5: when using querysetcell you need to explictly force the datatype with int() etc, there was a thread on this late last week z ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: CFM Files are Locked?
[EMAIL PROTECTED] wrote: IIS likes to lock files for a little while if they have been recently accessed from the web. If you wait about 30 mins, they'll be freed. Annoying. rename then delete then write a new file always seems to work for me in w2k z ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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.
opinions about XSL
is found this article talking about why xsl is bad http://www.xml.com/pub/a/1999/05/xsl/xslconsidered_1.html any comments? I haven't personally looked into xsl, the syntax always looked like RTF :-) through babelfish and it looks like doing client side work on the server ( ie browser stuff ) i know from my old man who does java that it's quicker to go xml-dom-xml than xsl what's peoples experience? z __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: opinions about XSL
Alex wrote: What other option is there to transform xml docs? convert the xml to dom, do your mods and then back to xml, as a CF developer, it much easier to work IMHO with the xml dom as structures etc than messing around with... apparently one of the problems with XSL as an approach performance wise is something to do with the way that it progressively processes the xml file and has to do some prediction stuff (read more overhead) as it goes... you can do amazing stuff with xml and css, write a style sheet which hides nodes ( display:none;) now if only we could get everyone to upgrade to mozilla.. then life would be so much easier.. back to workarounds, again :-( __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: opinions about XSL
Tony Weeg wrote: zac. can u explain in brief, or give a brief example of taking an xml node(s) and sending that to a structure? using an xml parser in cf 5 or native in MX, you can convert an xml document into a dom object... like a tree of objects or structures of structures take an xml document and convert it to dom you end up with an complex array of array's and structyure and variables... a good example is rss.. rss is really simple syndication, except that so many people can't read a spec and produce well formed or valid rss files see this link here for a good working example http://static.userland.com/gems/backend/sampleRss.xml ok... rss should be something like channel title etc item title description /item and so on... but sometimes you get no channel and only items so you can load the xml into a dom under a var called rss and then say rss.channel.item=rss.item then if you have modified the xml structure or transformed it z __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Using the Verity Engine on non-cf apps
Bruce Sorge wrote: If you have CFMX and .net apps running on the same server, is it possible to use the K2 Verity engine on the .net apps, or does this require one to purchase and install the K2 product? sounds like you coud expose it via a web service :-) that would be the license compliant way z __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: NSLookup
James Smith wrote: Hi all. Here is a problem I have been pulling my hair out over. I want to do an NSLookup directly (ie: no custom tags if it can be avoided) and have tried both w3sockets and TCPClient to open the socket but not for love nor money can I find the appropriate commands to send. I can use either to connect to a POP3 server, login, read mail etc but I just cant get DNS queries to work. Can anyone point me in the correct direction? honestly the best advice here is don't re-invent the wheel.. use cfexecute and dig from sendmail/bind or maybe a java class this code using dig will give u really detailed info about dns cfsavecontent variable=dig_outcfexecute name=#server.dig_exe# arguments=#attributes.domain# +nssearch timeOut=5/cfexecute /cfsavecontent cfscript soa_pos=FindNoCase(SOA,dig_out,1); if (soa_pos gt 0){ soa_server=ListGetAt(dig_out,2, ); request.mod.dnsdig.status=1; } else { // name server soa not found! soa_server=; request.mod.dnsdig.status=-1; } /cfscript cfif len(soa_server) gt 0 cfsavecontent variable=request.mod.dnsdig.infopre cfexecute name=#server.dig_exe# arguments=#soa_server# #attributes.domain# axfr +multiline timeOut=5/cfexecute/pre/cfsavecontent the short explanation is SOA is the master server for a domain, u can only get the detailed info from the master server, you first get the SOA server, then u query the SOA server for the domain info is there a reason why you don't want to use custom tags??? what are u wanting to do? z __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: NSLookup
James Smith wrote: The reason for attempting direct interaction is that the page I have here has about 200+ domains on it and it is growing every day and every custom tag I have tried can't cope with the volume. like always, cache your results, if it's possible, most likely the results your are getting are cached in the dns server anyway.. cache to application vars or write out txt files z __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: IIS Security
Candace Cottrell wrote: What is the disadvantage of using the native IIS directory security functionality over using a cf-based login? you don't have so much control over the interface ( ie browser login dialogs ) and it generally more flexible via cf logins with error handling.. ie you control the flow and not with IIS HTTP status codes and then u need to configure IIS error pages etc etc z __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: IIS Security
Robertson-Ravo, Neil (REC) wrote: I am pretty sure that there are Netscape issues with IIS/NT security based systems. only with NTLM/kerbos auth, use basic security... NTLM is not secure anyway coz it's flawed (crackable) ... if you are worried about passwords in clear text then use ssl z __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: QueryNew() Filtering Problems
Raymond Camden wrote: Can we see your code? I had no issues with this on either CF5 or MX. Here is the code I used: cf_querysim name=foo price name 6000 foo 1 goo 2 moo /cf_querysim cfdump var=#foo# cfquery name=test dbtype=query select price fromfoo where price 7000 /cfquery cfdump var=#test# order by in CF 5.0 doesn't work with QoQ's when the query is built or modified using QuerySetCell, and I found no work arounds, querying the query and then trying to query and order by with that recordset still doesn't work z __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Textarea manipluation with JS ( IE Moz)
the following link show how to create controllable textarea's for editing, ie get selection, insert at selection with both mozilla and IE 456 ( diff methods, but same results ) hope it saves someone some time :-) http://www.faqts.com/knowledge_base/view.phtml/aid/1052/fid/130 http://bugzilla.mozilla.org/attachment.cgi?id=89748action=view http://www.faqts.com/knowledge_base/view.phtml/aid/13562/fid/130 z __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: UUID's ( maybe OT)
Bryan Love wrote: Not really true. The word terrible is a vast overstatement. Assuming you use char (or varchar) for the UUID (char is better since the size is constant)... The difference btwn string keys and numeric keys (performance-wise) is pretty much null until you get up into the millions of records and even then it's not enough to worry about. ok some simple maths, a uuid is what 30 chars or something, that means a join using two tables with lets say 1 and 3000 rows.. that means a query between the two is going to be working with either 13000 bytes or 13000 * 30 bytes just to join data... the answer there is that you are working with 30 times the amount of data, sure there is some optimzation but the logic goes further.. each index requires space, both memory and disk space... db's usually try and cache the indexes in ram sure the db can probably do some magic here and the difference is not 30 times in processing speed..but you will still need 30x more cache for your indexes but then each of pages will then contain x * content links * 30 more data, which means more transfer between your db and webserver, more bandwidth costs as all your pages are then bigger... z __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Returning columns with null values when specific columns are unknown at runtime
null values are not indexed btw. (maybe thigs have changed in the last few years but) using a value like 0 as a quasi null means that select user_id from users where b_sysadmin is null versus select user_id from users where b_sysadmin = 0 do an explain plan in oracle or execution plan in sql server, the second can use an index, the first cannot, which means the db server has to do a full table scan ( slow, expensive ) there are tricks to use a join in oracle to get around this z __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: more cfstoredproc issues -- ARGH!!
S. Isaac Dealey wrote: Yea, it turned out to be the cf_sql_date that was causing the wrong number of parameters error message... so changing that to cf_sql_timestamp solved the problem... Better support for cfstoredproc ( naming and better error handling in particular. ) would be _great_ to see from the folks at MM... I'll probably toy with it some once I start working with it on MX just to see if any improvements came with the new J2EE platform. my biggest peve with the cf query/stored proc param support is that there is no null=AUTO option... z __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
UUID's ( maybe OT)
I am probably OT here, but I see so many people using UUID's when simpler normal numeric keys are better... a classic example for me is article id's... look at cfcomet for example... the article ids aren't user friendly, it reminds me of good old lotus notes and we all know how short urls are better than long one ( email wrapping for example ) not to mention that your database and CF load is much higher using long text pk's than with nice short numeric keys and your page size is increased a lot too.. just letting off steam. don't want to create a flame war or anything z __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: FW: Jsp Vs Cfm (CFMX) -- Test Code
snip Anyone else have any ideas? try scoping your variables z __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: FW: Jsp Vs Cfm (CFMX) -- Test Code
and writeoutput in cf 5.0 is slower than cfoutput, did you try the same test with cfml and not cfscript ? z __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Recursion
S. Isaac Dealey wrote: Before you give up... There's a couple of things you can do for the recursion in the db... One is to create a cross-reference table which shows the parent-child relationship between all records in the table... Alternatively, you could try this: cfset rs = QueryNew(ID) cfset temp = QueryAddRow(rs) cfset rs.id[1] = 0 cfset rs2 = QueryNew(ID) cfloop condition=rs.recordcount cfquery name=rs datasource=... SELECT * FROM mytable WHERE parentid IN (#valuelist(rs.id)#) /cfquerycfquery name=rs3 dbtype=query SELECT * FROM rs UNION SELECT * FROM rs2 /cfquerycfset rs2 = rs3 /cfloop This or something like it ought to give you a single query containing all of the children of the parent... It will be much slower than a cross-reference table in the db, however, it should be similar in performance to the current solution... Once you have this query, however, you can then use the recursive UDF in CF 5 and either pass the query to the UDF along with the current parent id for the tree, or you can place the query in the request scope and reference it from there... never do to much work in cf when your database can do it faster http://www.sqlteam.com/item.asp?ItemID=8866 is a really nice and simple method for doing trees it stores an id path for each node in your tree, automatically, that why you can do a query like (see example on page above) select node where lineage contains '/#target_node_id#' to return a specific part of the tree z hth Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 All, Thank you for your responses to my inquiry. As it turns out, the CFSCRIPT option is not viable because the point of the recursion was querying a database for records that represented subordinate records which might have subordinate records of their own. The cfmodule seems to take forever and therefore is not practical. In the end, I will have to change the design of the application. However, that is not necessarily a bad thing. However, it does make me appreciate the changes in CFMX. Again, thank you all for your responses. -- Original Message -- From: Mosh Teitelbaum [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Thu, 12 Sep 2002 15:45:57 -0400 Or, you could rewrite the function without recursion. Just thought I'd mention it as another alternative. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 2:23 PM To: CF-Talk Subject: RE: Recursion I wrote this really neat recursive function using the cffunction tag on my development system which is running CFMX on WindowsXP Pro. When I ported to the operational host (third party), I discovered that they were running a previous version of CF (I do not know which) which does not support the new tag. Does anybody know how to do recursion without the cffunction tag? If your recursive function is relatively simple, you can probably write it as a CF 5-compliant user-defined function, using CFSCRIPT. CFSCRIPT is a tag in which you can write CF commands using a JavaScript-like language, which uses the same syntax and control flow structures as JavaScript, but uses CFML operators and expressions. You can't use CFML tags within a CFSCRIPT tag, though, and CFSCRIPT doesn't support all the things you can do with CFML tags, such as querying a database. Keep in mind that the host would have to be using CF 5 or higher for this to work. Alternatively, you could write a recursive custom tag. However, this is the least desirable alternative, as custom tags don't provide any built-in ability to return values (you can write that ability into your code, though) and they tend to negatively affect performance. Nevertheless, if you need recursion and you're using a version of CF prior to 5, that's the only way you can do it within CFML. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Re: Saving a static version of a website
Jason Miller wrote: I have been unsuccesful as well with some of the download utitilies. This would be great if UltraDev did indeed have this. Just wanted to post my interest if this is found - I would appreciate a note to the list. I will do the same if I should happen to solve the issue adequately. Thanks, Jay Miller gnu wget http://www.wget.org __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: upload multiple image files
Chris Edwards wrote: how do I access a file's information after uploading multiple images in a single form? the default is FILE.stuff. or CFFILE.stuff.. cfset this_file_info=duplicate(cffile) i think u need the duplicate because otherwise as cffile is a struct, when cffile changes this_files_info would change as it's only a reference z __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: html2jpg
James Smith wrote: Some time ago there was a thread about HTML2JPG (http://www.html2jpg.com/) and using it to create screen shots of web sites. Has anyone got it to work with the cfexecute tag? It works just fine when I execute it directly or with a batch file from windows, but either method with CF just produces screenshots of my desktop which is not a whole lot of use to me. use the cfx_html2bmp from http://www.efflare.com it's free ~| Archives/subscription: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 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: Programmatically Control IIS with CF.
Bryan F. Hogan wrote: I'm faced with a task of creating an app for our company where a sales person can input a new client and have it create the needed information within IIS. I have been able to do this with my registrar for domain names and have it programmatically create the needed DNS records. I can not seem to figure out how to do this with IIS. Does anyone have any suggestions? Intrafoundation Software - IHTK, Intranet/Hosting Toolkit .. Intranet/Hosting Toolkit. ... In short, it's a toolkit for anyone using ColdFusion to administrate an intranet or web hosting organization. ... www.intrafoundation.com/ihtk.html iis admin via cfx tags __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists