Client Variable Storage in CF 5.0 versus 4.0
I have some questions relating to how client variable storage was handled in CF 4.0 compared to how it is handled today in CF 5.0. Some background information may help these questions make sense by putting them in context: Background info === I am upgrading a web site (not of my design or construction) that is still running CF 4.0, that uses three load-balanced web servers. The site owner has been having endless problems that appear to trace to client variables getting mixed up somehow, with the end result being that people who log in sometimes see other people's data returned from the database instead of their own. This results in some unpleasant calls to customer support and probably a certain amount of lost business that we never learn about. The CF coding is very poor (no indents, max dependencies everywhere, deeply nested CFINCLUDEs, no variable scoping, variables renamed every time they get passed from one place to the next, etc.) and the database is for practical purposes almost impenetrable (it's an academic's experiment of a denormalized style of database that is emulated on SQL Server, with no primary keys, completely unrelated data stored in the same tables, almost a thousand Byzantine stored procedures to maintain referential integrity, views of views of views and so on -- but that is a separate problem). In this environment it would be extremely difficult to isolate this problem even if I could reproduce it, but I have never been able to observe the problem myself, we just get two or three irate customers calling every day about it. Needless to say, the only sensible thing to do is to replace the awful database with a normal one and rewrite all the kludgy CF code the way it should have been written in the first place, and this is what I am beginning to do. Tonight I removed one of the three web servers from load balancing and upgraded it to CF 5.0 as an early step in the process, and something odd happened: the client variable storage that had worked previously in CF 4.0 didn't work any longer, even though it was set up to work the same way as it did before in the CF Administrator. The Registry is set up as the default location for client variable storage; however the production database was still explicitly named as the place for client variable storage in the CFAPPLICATION tag in Application.cfm (CLIENTSTORAGE=ProductionDB). Looking in ProductionDB, I noticed something that had eluded me before: no CDATA and CGLOBAL tables! That must mean that CF 4.0 doesn't find them in the production database and uses the Registry default as set up in the CF Administrator. I'm guessing that CF 5.0 is stricter and won't put up with such shenanigans, and that if the database specified for use as client variable storage in the CFAPPLICATION tag doesn't have those tables, CF 5.0 throws an error. So, my questions for you experts are: 1) Is my conclusion true, did CF 4.0 default to the Registry (or the default setup in the CF Administrator for client variable storage) if the database specified in the CFAPPLICATION tag for client variable storage did not contain CDATA and CGLOBAL tables? 2) Can client variables be maintained properly in a load-balanced (by hardware, not ClusterCats) system if they are stored in the Registry of each web server? I'm thinking that this might explain how the client variables are getting mixed up. Thanks for your help. Regards, Karl Simanonok 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
Oracle Character Limitations ??? ...
Hi Folks Have anyone on this list come across this Oracle 8 error when inserting large pieces of text in a LONG field? Because when I do these large inserts I am getting the following error message. --- Error Occurred While Processing Request Error Diagnostic Information Oracle Error Code = 1704 ORA-01704: string literal too long The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (46:1) to (46:60). - Any ideas on how to get around this either by using a different approach or by rewriting the query I am using Any help would be most appreciated... Thanks Ian cftransaction cfquery name=LOOKUP datasource=intranetv8 SELECT Max(eventid) NeweventID FROM whatson /cfquery cfif lookup.neweventid is cfset eventid = 1 cfelse cfset eventid = lookup.neweventid + 1 /cfif !--- Insert contact into the contacts tabel in the tes8 Database --- ! COMBINE MONTH, DAY, AND YEAR INTO A SINGLE VARIABLE - cfset eventdate = form.event_month / form.event_day / form.event_year cfset eventdate = #CreateODBCDate(eventdate)# cfset eventexpires = form.expires_month / form.expires_day / form.expires_year cfset eventexpires = #CreateODBCDate(eventexpires)# cfset formatted_date = dateformat(eventdate, MM/DD/) cfset format_date = dateformat(eventexpires, MM/DD/) cfif form.uploadfile neq cffile action=UPLOAD filefield=Form.UploadFile destination=/export/home/docs/intranet/testpages/ nameconflict=OVERWRITE /cfif !--- Make sure that file is of correct type --- cfquery datasource=#Application.DSN# name=insert_query INSERT INTO whatson ( eventid, eventdate, eventexpires, longtitle, location, telephone, email, url, description, imgsrc) VALUES (#eventid#, TO_DATE('#formatted_date#', 'MM/DD/'), TO_DATE('#format_date#', 'MM/DD/'), '#longtitle#', '#location#', '#telephone#', '#email#', '#url#', '#content#', cfif isdefined(file.serverFile)'#file.serverFile#'cfelseNULL/cfif) /cfquery /cftransaction __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: Cookie Blocking
Lee Surma [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Is there a good way to determine if a users browser is set to not accept cookies as you are attempting to set a cookie? I want to be able to send a message to the user if blocking is on. cfif isdefined(cookie.tmtCookieTest) cflocation url=yescookie.htm addtoken=No cfelseif not isdefined(url.tmtCookieSend) !--- First time the user visit the page, set the cookie --- cfcookie name=tmtCookieTest value=Accepts cookies !--- The cookie was send, redirect and set the tmtCookieSend flag as an url variable --- cfheader name=Refresh value=0; URL=#cgi.script_name#?tmtCookieSend=1 cfelseif isdefined(url.tmtCookieSend) !--- We tried sending the cookie, no way, cookies are disabled, get out of here --- cflocation url=nocookie.htm addtoken=No /cfif -- Massimo Foti [EMAIL PROTECTED] http://www.massimocorner.com Dreamweaver, Ultradev and Fireworks goodies http://www.projectseven.com/viewer/snippets.htm Snippets Panel __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
OT-FONT Problem
--0-91440316-1011962610=:40516 Content-Type: text/plain; charset=us-ascii Anyone know the name of this font used in this Header/Nav-bar? I made it a long time ago, and need to make some changes, but can't remember where I came up with the darned font! Thanks. www.zonedogg.com Greg - Do You Yahoo!? Yahoo! Auctions Great stuff seeking new owners! Bid now! --0-91440316-1011962610=:40516 Content-Type: text/html; charset=us-ascii PAnyone know the name of this font used in this Header/Nav-bar? I made it a long time ago, and need to make some changes, but can't remember where I came up with the darned font! Thanks./P PA href=http://www.zonedogg.com;www.zonedogg.com/A/P PGreg/PBRBRpbrhr size=1bDo You Yahoo!?/bbr a href=http://rd.yahoo.com/mail_us/tag/?http://auctions.yahoo.com;Yahoo! Auctions/a Great stuff seeking new owners! a href=http://rd.yahoo.com/mail_us/tag/?http://auctions.yahoo.com;Bid now!/a --0-91440316-1011962610=:40516-- 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
Fw: Client Variable Storage in CF 5.0 versus 4.0
Grrr... flipping mail servers... grumble groan... sorry in advance for the resend. Stephen - Original Message - From: Stephen Moretti [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 25, 2002 10:11 AM Subject: Re: Client Variable Storage in CF 5.0 versus 4.0 Karl, 1) Is my conclusion true, did CF 4.0 default to the Registry (or the default setup in the CF Administrator for client variable storage) if the database specified in the CFAPPLICATION tag for client variable storage did not contain CDATA and CGLOBAL tables? I can't say for certain, because I've never tested the theory, but from experience of occassionally doing daft things like forgetting to generate the client variable tables in the client datasource, that would seem to be the case. 2) Can client variables be maintained properly in a load-balanced (by hardware, not ClusterCats) system if they are stored in the Registry of each web server? I'm thinking that this might explain how the client variables are getting mixed up. You be right to think that if you are load balancing (hardware or clustercats) and have registry stored client variables there are going to be problems. In order to share client variables in a cluster, they need a central store, such as your production database, to which all of your servers have ODBC/OLEDB/Native driver access and a pointer from the CFAPPLICATION tag or in CFAdmin itself. CF, as I'm sure you've deduced, can't access the registry of other servers even if they are in a cluster. You might be advised, given how badly it sounds the application is written, to change the client store setting in the administrator, so that all applications, whether they have a cfapplication tag or not, actually use a datasource rather than the registry. Hope this helps. Regards Stephen __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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
CFSchedule
Any good tutorials on this subject - all I've seen in numerous books is examples of running reports at determined intervals. What I want to do is run a template which contains a query and then outputs the results to CFMAIL. Can I do this using CFSchedule, or is there a better way? Here's what I have now, and it won't work (I'm on a shared server with no access to the CF Admin functions): Any assistance or suggestions is/are appreciated. Thanks, Mark - !---Scheduler Template--- CFSCHEDULE ACTION=UPDATE TASK=TestMessage OPERATION=HTTPRequest URL=http://www.mydomain.com/admin/email/scheduler/test_email_process.cfm; STARTDATE=01/24/02 STARTTIME=06:45:00 INTERVAL=DAILY RESOLVEURL=No PUBLISH=No /cfschedule !---Query/Email Sendout Template--- CFQUERY NAME=q_sub DATASOURCE=uspc SELECT * FROM t_email, t_msg, t_sig, t_subcat, t_unsub_msg WHERE t_email.subcat_h = t_msg.t_subcat_ID AND t_msg.t_subcat_ID = t_subcat.sc_id AND t_msg.dateofsend = DateValue(Now()) /CFQUERY CFIF q_sub.recordcount IS 0cfabort/cfif !--- Send out mail to the specified group--- CFMAIL QUERY=q_sub GROUP = email GROUPCASESENSITIVE=No STARTROW=1 TO=#firstname# #lastname# #email# FROM=John Doe [EMAIL PROTECTED] SUBJECT=#msg_subject# CC=#copy_to# BCC=#blind_copy_to# SERVER=127.0.0.1 cfmailparam name=Reply-To value=John Doe [EMAIL PROTECTED] cfif q_sub.vit_ID NEQ 0#trim(thought)# --#trim(author)##crlf##crlf#/cfif cfif q_sub.txtmessage IS NOT #Trim(txtmessage)##crlf##crlf#/cfif cfif unsublink IS Yes#trim(unsub_msg)##crlf##crlf#/cfif cfif msg_sig IS Yes#trim(sig_line)#/cfif /CFMAIL !---Send a confirming Email to Mydomain.com indicating that the messages have been delivered.--- !---Do not suppress whitespace in the email message--- CFPROCESSINGDIRECTIVE SUPPRESSWHITESPACE=No CFMAIL TO=John Doe [EMAIL PROTECTED] FROM=John Doe [EMAIL PROTECTED] SUBJECT=Email Message Center Delivery Success SERVER=127.0.0.1 As of #LSDateFormat(Now(), dd, )# #LSTimeformat(Now(), hh:mm:ss)#, #q_sub.recordcount# subscribers have been provided a #q_sub.sub_category# message via automated email. END OF MESSAGE /CFMAIL /CFPROCESSINGDIRECTIVE cfabort __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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: UltraDev
They haven't force you to buy Ultradev 4, heck like the design tab was any good to begin with, I mean come on, that thing screwed the code up more than Ultradev ever could. At least now that I have both I don't have to spend extra time coding a simple data display page I could just do it in ultradev then clean up the code later if I have to. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Peter Tilbrook [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 12:00 AM To: CF-Talk Subject: RE: UltraDev Macromedia have diminished your right to use a third party WYSIWYG HTML editor with ColdFusion Studio 5. Thay have attempted to FORCE you to not only purchase Studio 5 but also Ultradev 4.0.x. The latter product is severely lacking in it's current form. Most CF developers could not care less about visual development. Ultradev asssists in some ways but generally hinders in others. Use it for a while, especially in ColdFusion 'code complex' situations. Ultradev is a good start but way off what serious developers need. Can someone tell me what UltraDev adds to the Cold Fusion Studio? I looked at the product description and could not really get what I would have if I had CF Sudio 5 Ultradev versus CF Studio 5. I am contemplating whether it is worth the money to renew my alliance. Save your money and stick with CF 4.5.2 if you value the one-click method of opening your current template into your preferred editor. CFS 5 removes the choice - the same is said with the CSS editor - TopStyle. Save your money = stick with CF Studio 4.5 (SP) until MM pull there finger out. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: Oracle Character Limitations ??? ...
Ian Vaughan wrote: Hi Folks Have anyone on this list come across this Oracle 8 error when inserting large pieces of text in a LONG field? Because when I do these large inserts I am getting the following error message. CFQUERYPARAM VALUE=#mylongtext# CFSQLType=CF_SQL_LONGVARCHAR :-) __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
Can I somehow cache the results from a custom tag??
Friday, January 25, 2002, 8:38:39 AM Hello CF-Talk, I'm using a custom tag, called FreeData_NWS by Jim at Depressed Press. It goes to the national Weather Service, gets some weather data and gives them as variables. Works slick! I'm trying to display the temperature on every page, and if I call this tag on every page, I get a real performance hit since the NWS is pretty slow in giving its data. Is there a good way, that I can somehow cache the returned variables? Then on each page, just check if the variable exists before I cfmodule the tag? Then if I do set them as variables, can I get them to timeout? Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: Client Variable Storage in CF 5.0 versus 4.0
First off here is a little piece of code I got from Hal Helms that helps to get rid of duplicate sessions !--- Set session cookies --- cfif IsDefined(Cookie.CFID) AND IsDefined(Cookie.CFTOKEN) cfset cfid_local = Cookie.CFID cfset cftoken_local = Cookie.CFTOKEN cfcookie name=CFID value=#cfid_local# cfcookie name=CFTOKEN value=#cftoken_local# /cfif 1. I had found many oddities with 4.0, one being that when we upgraded from 4.0 to 4.0.1 it was erroring on cfapplication because there was no name. This was a huge problem, made the website completely unusable till I went to every place that has cfapplication. So it would not surprise me if CF did something wierd like you described. 2. I am not sure about your second question, though it would seem logical since the registry is not shared between the servers. Though Dave Watts could probably answer this better than me. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Karl Simanonok [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 4:42 AM To: CF-Talk Subject: Client Variable Storage in CF 5.0 versus 4.0 I have some questions relating to how client variable storage was handled in CF 4.0 compared to how it is handled today in CF 5.0. Some background information may help these questions make sense by putting them in context: Background info === I am upgrading a web site (not of my design or construction) that is still running CF 4.0, that uses three load-balanced web servers. The site owner has been having endless problems that appear to trace to client variables getting mixed up somehow, with the end result being that people who log in sometimes see other people's data returned from the database instead of their own. This results in some unpleasant calls to customer support and probably a certain amount of lost business that we never learn about. The CF coding is very poor (no indents, max dependencies everywhere, deeply nested CFINCLUDEs, no variable scoping, variables renamed every time they get passed from one place to the next, etc.) and the database is for practical purposes almost impenetrable (it's an academic's experiment of a denormalized style of database that is emulated on SQL Server, with no primary keys, completely unrelated data stored in the same tables, almost a thousand Byzantine stored procedures to maintain referential integrity, views of views of views and so on -- but that is a separate problem). In this environment it would be extremely difficult to isolate this problem even if I could reproduce it, but I have never been able to observe the problem myself, we just get two or three irate customers calling every day about it. Needless to say, the only sensible thing to do is to replace the awful database with a normal one and rewrite all the kludgy CF code the way it should have been written in the first place, and this is what I am beginning to do. Tonight I removed one of the three web servers from load balancing and upgraded it to CF 5.0 as an early step in the process, and something odd happened: the client variable storage that had worked previously in CF 4.0 didn't work any longer, even though it was set up to work the same way as it did before in the CF Administrator. The Registry is set up as the default location for client variable storage; however the production database was still explicitly named as the place for client variable storage in the CFAPPLICATION tag in Application.cfm (CLIENTSTORAGE=ProductionDB). Looking in ProductionDB, I noticed something that had eluded me before: no CDATA and CGLOBAL tables! That must mean that CF 4.0 doesn't find them in the production database and uses the Registry default as set up in the CF Administrator. I'm guessing that CF 5.0 is stricter and won't put up with such shenanigans, and that if the database specified for use as client variable storage in the CFAPPLICATION tag doesn't have those tables, CF 5.0 throws an error. So, my questions for you experts are: 1) Is my conclusion true, did CF 4.0 default to the Registry (or the default setup in the CF Administrator for client variable storage) if the database specified in the CFAPPLICATION tag for client variable storage did not contain CDATA and CGLOBAL tables? 2) Can client variables be maintained properly in a load-balanced (by hardware, not ClusterCats) system if they are stored in the Registry of each web server? I'm thinking that this might explain how the client variables are getting mixed up. Thanks for your help. Regards, Karl Simanonok FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup
Re: Can I somehow cache the results from a custom tag??
You can store the data in your own datasource, and retrieve it with a query and cache that. Of course you'll need to code in some way of knowing when to get new data to put into the datasource... David Schmidt - Original Message - From: Jeff Fongemie [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, January 25, 2002 5:44 AM Subject: Can I somehow cache the results from a custom tag?? Friday, January 25, 2002, 8:38:39 AM Hello CF-Talk, I'm using a custom tag, called FreeData_NWS by Jim at Depressed Press. It goes to the national Weather Service, gets some weather data and gives them as variables. Works slick! I'm trying to display the temperature on every page, and if I call this tag on every page, I get a real performance hit since the NWS is pretty slow in giving its data. Is there a good way, that I can somehow cache the returned variables? Then on each page, just check if the variable exists before I cfmodule the tag? Then if I do set them as variables, can I get them to timeout? Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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
Format Date statement?
This one should be easy.. *should* being the operative word. I have a query on an access database where its pulling a date. when I CFOUTPUT that date, I get the big nasty date format: '2002-01-25 08:53:36' Is there a way when the data is queried to set that field = to my DateFormat setting? i.e. cfquery datasource=copycenter name=goober select dateread AS (#dateformat(dateread, mmm-dd-)#) /cfquery Or is there an eaiser way to do this? I'm trying to reference this date in a CFGRAPH (and i cant format it there), so I need to format that date before it gets there, because it looks horrid thanks all! __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: Oracle Character Limitations ??? ...
Thanks for that, what if you still are using Coldfusion Server 4 and do not have access to CFQUERYPARAM ? - Original Message - From: Zac Spitzer [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, January 25, 2002 1:36 PM Subject: Re: Oracle Character Limitations ??? ... Ian Vaughan wrote: Hi Folks Have anyone on this list come across this Oracle 8 error when insertin g large pieces of text in a LONG field? Because when I do these large inserts I am getting the following error message. CFQUERYPARAM VALUE=#mylongtext# CFSQLType=CF_SQL_LONGVARCHAR :-) __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: Searching text fields for like words
Like 'e%' to get anything that starts with e Like '%e%' to get anything with an e in it Like '%e' to get anything that ends with e -Original Message- From: OFAH Webmaster [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 24, 2002 4:10 PM To: CF-Talk Subject: Searching text fields for like words I am having troubles searching fields in my database for Like situations. I have to type in the word (this case e-mail address) exactly as it is in the database or else I get a 0 back, even if I leave off one letter. Now I have done this before (a long time ago). Can someone refresh my memory. is it the Where EMail Like '#SearchEMail#' or something like that? Thanks in advance. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: Format Date statement?
not sure about access, but you could use day,year,month functions in SQL SELECT cast(Month(columnname) as char(2)) + cast(Day(columname) as char(2)) + cast(Year(columname) as char(4)) AS MyWelFormattedDAte ..soemthing like that (forgive me if the syntax is screwed up) -Original Message- From: Ron Davis [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 6:00 AM To: CF-Talk Subject: Format Date statement? This one should be easy.. *should* being the operative word. I have a query on an access database where its pulling a date. when I CFOUTPUT that date, I get the big nasty date format: '2002-01-25 08:53:36' Is there a way when the data is queried to set that field = to my DateFormat setting? i.e. cfquery datasource=copycenter name=goober select dateread AS (#dateformat(dateread, mmm-dd-)#) /cfquery Or is there an eaiser way to do this? I'm trying to reference this date in a CFGRAPH (and i cant format it there), so I need to format that date before it gets there, because it looks horrid thanks all! _ _ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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 __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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: extracting data from a huge text file
This should be IDEAL for you. http://www.macromedia.com/v1/handlers/index.cfm?ID=22277method=full DRE -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 24, 2002 6:10 PM To: CF-Talk Subject: Re: extracting data from a huge text file How does it accomplish this when you want to loop over the contents of a large file? Does it keep the file open, or when you call it to read the 250,000th line, has it opened and closed and read through the file 249,999 times already? Jim - Original Message - From: Lewis Sellers [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 24, 2002 5:54 PM Subject: Re: extracting data from a huge text file On Thu, 24 Jan 2002 16:09:54 -0800, Chris Giminez [EMAIL PROTECTED] wrote: I'm trying to retrieve data and put it into a database from a text file. The text file is over 100MB with (I'm guessing) around 260,000 records, each record contains 85 fields. I tried to create a conditional loop at each line break, which works fine if I am working on a smaller version of the file, but chokes on the 100MB monster. Is there a more efficient way to deal with this other than looping through it or is there a way to break this file up into smaller chunks and deal with it piece by piece? Been a while since I used it but I wrote a cfx called... hmm.. I don't recall what it was called /-) ... anyway, the cfx was to read in log files one line at a time. Which is what it does, one carriage-deliminated line per call, not the entire file all at once. It's somewhere at http://www.intrafoundation.com/freeware.html. --min __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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
HELP! CFJava2.jar Errors
We've just upgraded a development server to CF5. The server has an app on it that we purchased from a vendor. They haven't certified it to run under CF5, but they said that it should be fine, if we decided to give it a try. Well, most of it seems to be ok, but there is a section that loads some java, and we get errors. On the main screen, there is a message that it is trying to load servername/cfide/classes/CFJava2.jar, and then the following Java Plug-in Security Warning: java.security.cert.CertificateExpiredException: NotAfter: Sun Dec 16 17:59:59 CST 2001 at sun.security.x509.CertificateValidity.valid(Unknown Source) at sun.security.x509.X509CertImpl.checkValidity(Unknown Source) at sun.security.x509.X509CertImpl.checkValidity(Unknown Source) at sun.plugin.security.TrustDecider.isAllPermissionGranted(Unknown Source) at sun.plugin.security.PluginClassLoader.getPermissions(Unknown Source) at java.security.SecureClassLoader.getProtectionDomain(Unknown Source) at java.security.SecureClassLoader.defineClass(Unknown Source) at java.net.URLClassLoader.defineClass(Unknown Source) at java.net.URLClassLoader.access$100(Unknown Source) at java.net.URLClassLoader$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(Unknown Source) at sun.applet.AppletClassLoader.findClass(Unknown Source) at sun.plugin.security.PluginClassLoader.findClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at sun.applet.AppletClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at sun.applet.AppletClassLoader.loadCode(Unknown Source) at sun.applet.AppletPanel.createApplet(Unknown Source) at sun.plugin.AppletViewer.createApplet(Unknown Source) at sun.applet.AppletPanel.runLoader(Unknown Source) at sun.applet.AppletPanel.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Does this mean that we have an expired cert? Is it a bug in CF5? Any ideas on what might be causing this? Thanks, Erica __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
OT PMS
can anyone give me the rgb for pantone 541U? __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: HELP! CFJava2.jar Errors
Have you installed all the hotfixes for ColdFusion 5? There are about 6 of them, and one of them replaces some of the Java class and .jar files. This might be a source of your problem. Kevin Langevin Flying Chimp Media 954-585-0999 [EMAIL PROTECTED] http://www.FlyingChimp.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 10:19 AM To: CF-Talk Subject: HELP! CFJava2.jar Errors We've just upgraded a development server to CF5. The server has an app on it that we purchased from a vendor. They haven't certified it to run under CF5, but they said that it should be fine, if we decided to give it a try. Well, most of it seems to be ok, but there is a section that loads some java, and we get errors. On the main screen, there is a message that it is trying to load servername/cfide/classes/CFJava2.jar, and then the following Java Plug-in Security Warning: java.security.cert.CertificateExpiredException: NotAfter: Sun Dec 16 17:59:59 CST 2001 at sun.security.x509.CertificateValidity.valid(Unknown Source) at sun.security.x509.X509CertImpl.checkValidity(Unknown Source) at sun.security.x509.X509CertImpl.checkValidity(Unknown Source) at sun.plugin.security.TrustDecider.isAllPermissionGranted(Unknown Source) at sun.plugin.security.PluginClassLoader.getPermissions(Unknown Source) at java.security.SecureClassLoader.getProtectionDomain(Unknown Source) at java.security.SecureClassLoader.defineClass(Unknown Source) at java.net.URLClassLoader.defineClass(Unknown Source) at java.net.URLClassLoader.access$100(Unknown Source) at java.net.URLClassLoader$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(Unknown Source) at sun.applet.AppletClassLoader.findClass(Unknown Source) at sun.plugin.security.PluginClassLoader.findClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at sun.applet.AppletClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at sun.applet.AppletClassLoader.loadCode(Unknown Source) at sun.applet.AppletPanel.createApplet(Unknown Source) at sun.plugin.AppletViewer.createApplet(Unknown Source) at sun.applet.AppletPanel.runLoader(Unknown Source) at sun.applet.AppletPanel.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Does this mean that we have an expired cert? Is it a bug in CF5? Any ideas on what might be causing this? Thanks, Erica __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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: OT PMS
you mean 541CVU? if yes try 074B85 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] om] Sent: Friday, January 25, 2002 7:25 AM To: CF-Talk Subject: OT PMS can anyone give me the rgb for pantone 541U? _ _ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: OT PMS
0,83,141 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 10:25 AM To: CF-Talk Subject: OT PMS can anyone give me the rgb for pantone 541U? __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: OT PMS
shameless_plug I've written a few UDFs that switch back and forth from RGB to Hex color values. Perhaps it may be useful to you. http://www.cflib.org/udf.cfm?ID=339 http://www.cflib.org/udf.cfm?ID=340 /shameless_plug :) EC -Original Message- From: Tony Gruen [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 10:39 AM To: CF-Talk Subject: RE: OT PMS you mean 541CVU? if yes try 074B85 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] om] Sent: Friday, January 25, 2002 7:25 AM To: CF-Talk Subject: OT PMS can anyone give me the rgb for pantone 541U? _ _ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: Client Variable Storage in CF 5.0 versus 4.0
1) Is my conclusion true, did CF 4.0 default to the Registry (or the default setup in the CF Administrator for client variable storage) if the database specified in the CFAPPLICATION tag for client variable storage did not contain CDATA and CGLOBAL tables? I have no idea, since I've never let that occur. I wouldn't be surprised if it did behave the way you described, though. Yikes! 2) Can client variables be maintained properly in a load-balanced (by hardware, not ClusterCats) system if they are stored in the Registry of each web server? I'm thinking that this might explain how the client variables are getting mixed up. No, they can't. While you're fixing this, you might take a look at the SETDOMAINCOOKIES attribute of CFAPPLICATION, which is a good thing to use in a clustered environment. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: UltraDev
Macromedia have diminished your right to use a third party WYSIWYG HTML editor with ColdFusion Studio 5. I think this is kind of silly. You're free to use whatever WYSIWYG editor you want - or use none at all. Thay have attempted to FORCE you to not only purchase Studio 5 but also Ultradev 4.0.x. How have they attempted to force this? As far as I can tell, you can either buy one or the other separately, or you can buy them bundled. They may merge the products in the future, but your complaint seems premature to me. The latter product is severely lacking in it's current form. I can't think of a WYSIWYG editor for CGI programs which isn't. Most CF developers could not care less about visual development. Those developers (myself included) can stick with CF Studio 5, or vi for that matter. Ultradev asssists in some ways but generally hinders in others. Use it for a while, especially in ColdFusion 'code complex' situations. Ultradev is a good start but way off what serious developers need. I agree. Ultradev, by itself, is not a sufficient development tool. Maybe, though, if the guys at Macromedia thought about it, they'd bundle this design tool with a good text editor. Oh, wait... Can someone tell me what UltraDev adds to the Cold Fusion Studio? I looked at the product description and could not really get what I would have if I had CF Sudio 5 Ultradev versus CF Studio 5. I am contemplating whether it is worth the money to renew my alliance. It adds ... Ultradev. If you like Ultradev, you can buy the bundle for less than buying each separately. If you don't like Ultradev, you can just buy Studio. If the only value you get from your alliance is a tools discount, and you can pay less to just get Studio, then I guess it isn't worth renewing. Save your money and stick with CF 4.5.2 if you value the one-click method of opening your current template into your preferred editor. CFS 5 removes the choice - the same is said with the CSS editor - TopStyle. I have both Studio and Ultradev installed, and if I double-click on a CFM file, it opens Studio. If I wanted to change that, I could edit the registry or use the File Types dialog and have it open whatever I like. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: OT PMS
thanks all!! __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: Client Variable Storage in CF 5.0 versus 4.0
Karl, 1) Is my conclusion true, did CF 4.0 default to the Registry (or the default setup in the CF Administrator for client variable storage) if the database specified in the CFAPPLICATION tag for client variable storage did not contain CDATA and CGLOBAL tables? I can't say for certain, because I've never tested the theory, but from experience of occassionally doing daft things like forgetting to generate the client variable tables in the client datasource, that would seem to be the case. 2) Can client variables be maintained properly in a load-balanced (by hardware, not ClusterCats) system if they are stored in the Registry of each web server? I'm thinking that this might explain how the client variables are getting mixed up. You be right to think that if you are load balancing (hardware or clustercats) and have registry stored client variables there are going to be problems. In order to share client variables in a cluster, they need a central store, such as your production database, to which all of your servers have ODBC/OLEDB/Native driver access and a pointer from the CFAPPLICATION tag or in CFAdmin itself. CF, as I'm sure you've deduced, can't access the registry of other servers even if they are in a cluster. You might be advised, given how badly it sounds the application is written, to change the client store setting in the administrator, so that all applications, whether they have a cfapplication tag or not, actually use a datasource rather than the registry. Hope this helps. Regards Stephen __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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: UltraDev
Dave, Hehe - got your dander up a bit eh? I think I agree with every point you made (except the part about using VI if they want to... aught to be outlawed g). Mark -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 7:51 AM To: CF-Talk Subject: RE: UltraDev Macromedia have diminished your right to use a third party WYSIWYG HTML editor with ColdFusion Studio 5. I think this is kind of silly. You're free to use whatever WYSIWYG editor you want - or use none at all. Thay have attempted to FORCE you to not only purchase Studio 5 but also Ultradev 4.0.x. How have they attempted to force this? As far as I can tell, you can either buy one or the other separately, or you can buy them bundled. They may merge the products in the future, but your complaint seems premature to me. The latter product is severely lacking in it's current form. I can't think of a WYSIWYG editor for CGI programs which isn't. Most CF developers could not care less about visual development. Those developers (myself included) can stick with CF Studio 5, or vi for that matter. Ultradev asssists in some ways but generally hinders in others. Use it for a while, especially in ColdFusion 'code complex' situations. Ultradev is a good start but way off what serious developers need. I agree. Ultradev, by itself, is not a sufficient development tool. Maybe, though, if the guys at Macromedia thought about it, they'd bundle this design tool with a good text editor. Oh, wait... Can someone tell me what UltraDev adds to the Cold Fusion Studio? I looked at the product description and could not really get what I would have if I had CF Sudio 5 Ultradev versus CF Studio 5. I am contemplating whether it is worth the money to renew my alliance. It adds ... Ultradev. If you like Ultradev, you can buy the bundle for less than buying each separately. If you don't like Ultradev, you can just buy Studio. If the only value you get from your alliance is a tools discount, and you can pay less to just get Studio, then I guess it isn't worth renewing. Save your money and stick with CF 4.5.2 if you value the one-click method of opening your current template into your preferred editor. CFS 5 removes the choice - the same is said with the CSS editor - TopStyle. I have both Studio and Ultradev installed, and if I double-click on a CFM file, it opens Studio. If I wanted to change that, I could edit the registry or use the File Types dialog and have it open whatever I like. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 _ _ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: UltraDev
LOL I've never had any problems using multiple WYSIWYG's on one computer - maybe one day Studio will uninstall all of them except for UD when I'm sleeping but I doubt it. By the way, you can control what applications open what files. It's an operating system feature. Actually, Macromedia determined that they have to remove one click convenience because Amazon.com was going to sue them for copyright infringement. - Original Message - From: Peter Tilbrook [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 24, 2002 10:59 PM Subject: RE: UltraDev Macromedia have diminished your right to use a third party WYSIWYG HTML editor with ColdFusion Studio 5. Thay have attempted to FORCE you to not only purchase Studio 5 but also Ultradev 4.0.x. The latter product is severely lacking in it's current form. Most CF developers could not care less about visual development. Ultradev asssists in some ways but generally hinders in others. Use it for a while, especially in ColdFusion 'code complex' situations. Ultradev is a good start but way off what serious developers need. Can someone tell me what UltraDev adds to the Cold Fusion Studio? I looked at the product description and could not really get what I would have if I had CF Sudio 5 Ultradev versus CF Studio 5. I am contemplating whether it is worth the money to renew my alliance. Save your money and stick with CF 4.5.2 if you value the one-click method of opening your current template into your preferred editor. CFS 5 removes the choice - the same is said with the CSS editor - TopStyle. Save your money = stick with CF Studio 4.5 (SP) until MM pull there finger out. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: OT-FONT Problem
It's Marlett or something like that. - Original Message - From: Greg Luce [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, January 25, 2002 6:43 AM Subject: OT-FONT Problem --0-91440316-1011962610=:40516 Content-Type: text/plain; charset=us-ascii Anyone know the name of this font used in this Header/Nav-bar? I made it a long time ago, and need to make some changes, but can't remember where I came up with the darned font! Thanks. www.zonedogg.com Greg - Do You Yahoo!? Yahoo! Auctions Great stuff seeking new owners! Bid now! --0-91440316-1011962610=:40516 Content-Type: text/html; charset=us-ascii PAnyone know the name of this font used in this Header/Nav-bar? I made it a long time ago, and need to make some changes, but can't remember where I came up with the darned font! Thanks./P PA href=http://www.zonedogg.com;www.zonedogg.com/A/P PGreg/PBRBRpbrhr size=1bDo You Yahoo!?/bbr a href=http://rd.yahoo.com/mail_us/tag/?http://auctions.yahoo.com;Yahoo! Auctions/a Great stuff seeking new owners! a href=http://rd.yahoo.com/mail_us/tag/?http://auctions.yahoo.com;Bid now!/a --0-91440316-1011962610=:40516-- 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 __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: UltraDev
Actually, Macromedia determined that they have to remove one click convenience because Amazon.com was going to sue them for copyright? infringement. LOL! I think I'm going to copyright oxygen today. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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
Using CFmail and loops
Hi, I am having a serious problem with CFMAIL. I have a form that has a collection of checkboxes, about nine of them, the user can select any one of them or as many as they want. This form also contain some other details that the user fills in. When they submit this form a search is carried out using the criteria they have entered in the form, in order to get my query to work I need to loop around the comma delimited list of values sent by these checkboxes. Within each loop I have the search query and the table in which the results are displayed. I have to also loop around the results of this query in order for all of them to be displayed in the table and not just the last one. The problem I am having with cfmail is that I wish to send the user these search results all within one email. Does anyone know how I can still have my outer loop and inner loop, and send the result in one email. Thanks Stephen __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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: OT-FONT Problem
never mind - it's not marlett - but it starts with an M, i'm pretty sure :-) - Original Message - From: Greg Luce [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, January 25, 2002 6:43 AM Subject: OT-FONT Problem --0-91440316-1011962610=:40516 Content-Type: text/plain; charset=us-ascii Anyone know the name of this font used in this Header/Nav-bar? I made it a long time ago, and need to make some changes, but can't remember where I came up with the darned font! Thanks. www.zonedogg.com Greg - Do You Yahoo!? Yahoo! Auctions Great stuff seeking new owners! Bid now! --0-91440316-1011962610=:40516 Content-Type: text/html; charset=us-ascii PAnyone know the name of this font used in this Header/Nav-bar? I made it a long time ago, and need to make some changes, but can't remember where I came up with the darned font! Thanks./P PA href=http://www.zonedogg.com;www.zonedogg.com/A/P PGreg/PBRBRpbrhr size=1bDo You Yahoo!?/bbr a href=http://rd.yahoo.com/mail_us/tag/?http://auctions.yahoo.com;Yahoo! Auctions/a Great stuff seeking new owners! a href=http://rd.yahoo.com/mail_us/tag/?http://auctions.yahoo.com;Bid now!/a --0-91440316-1011962610=:40516-- 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 __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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: extracting data from a huge text file
Another option.. Why not open it as an ODBC data source, and let the ODBC drivers worry about the size of the file? We recently did something like this with VB for a text file, only a few lines/records though. But it should still work well with larger files. -Original Message- From: Chris Giminez [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 24, 2002 6:56 PM To: CF-Talk Subject: Re: extracting data from a huge text file It's called CFX_ReadLine and with an initial test, it looks like it's going to do the trick. thanks very much!! Chris I'm trying to retrieve data and put it into a database from a text file. The text file is over 100MB with (I'm guessing) around 260,000 records, each record contains 85 fields. I tried to create a conditional loop at each line break, which works fine if I am working on a smaller version of the file, but chokes on the 100MB monster. Is there a more efficient way to deal with this other than looping through it or is there a way to break this file up into smaller chunks and deal with it piece by piece? Been a while since I used it but I wrote a cfx called... hmm.. I don't recall what it was called /-) ... anyway, the cfx was to read in log files one line at a time. Which is what it does, one carriage-deliminated line per call, not the entire file all at once. It's somewhere at http://www.intrafoundation.com/freeware.html. --min __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: UltraDev
Don't you dare! It's MINE! MINE, I tell you! I'll sue you for breathing!! chuckle Actually, Macromedia determined that they have to remove one click convenience because Amazon.com was going to sue them for copyright? infringement. LOL! I think I'm going to copyright oxygen today. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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 CFmail and loops
Can you post a code snippet to show us an idea of what you're doing? Without seeing any, the suggestion might be to use CFParam to define your form checkboxes and in your SQL statement, use the IN (#form.fieldname#) as opposed to looping through a list. You'll need to make sure the formfield is defined, hence the referent to the cfparam. Also, if you've got a loop inside the cfmail tag, you'll probably need to drop the query parameter from the cfmail tag and do a query loop inside it. Hatton -Original Message- From: Stephen Adams [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 11:12 AM To: CF-Talk Subject: Using CFmail and loops Hi, I am having a serious problem with CFMAIL. I have a form that has a collection of checkboxes, about nine of them, the user can select any one of them or as many as they want. This form also contain some other details that the user fills in. When they submit this form a search is carried out using the criteria they have entered in the form, in order to get my query to work I need to loop around the comma delimited list of values sent by these checkboxes. Within each loop I have the search query and the table in which the results are displayed. I have to also loop around the results of this query in order for all of them to be displayed in the table and not just the last one. The problem I am having with cfmail is that I wish to send the user these search results all within one email. Does anyone know how I can still have my outer loop and inner loop, and send the result in one email. Thanks Stephen __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: CFFILE ERROR
Thanks for the help, the multipart/form-data worked like a charm. I have just one more quick ? if you do not mind. Is there a way to rename the file before it get uploaded? There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown - Original Message - From: Kym Kovan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 24, 2002 11:26 PM Subject: Re: CFFILE ERROR I keep getting the following error Error Diagnostic Information Error in CFFILE tag The form field specified in the CFFILE tag (THUMBNAIL) does not contain an uploaded file. Please be sure that you have specified the correct form field name. You usually get that eror when you don't change the form enctype over on the template that is sending the file. It should be: form action=uploadfile.cfm method=post enctype=multipart/form-data -- Yours, Kym __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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: RE: Using CFmail and loops
Hi Hatton, Here is an example of my code: cfloop index=PType list=#FORM.PropertyType# delimiters=, cfquery name=SearchProperties datasource=CMSX SELECT PropertyID, FullJobName, PropertyType, Tenure FROMProperties WHERE PropertyType = '#FORM.PropertyType#' cfif IsDefined(FORM.PropertyInfo) cfif FORM.PropertyInfo NEQ Freehold,Leasehold AND Tenure = '#FORM.PropertyInfo#' /cfif /cfif AND OnPrintedList = 1 ORDER BYPropertyType, FullJobName, Tenure /cfquery cfmail query=SearchProperties to=[EMAIL PROTECTED] from=[EMAIL PROTECTED] server=mail.company.com port=25 timeout=20 type=HTML cfloop query=SearchProperties cfoutput p table trtd#SearchProperties.FullJobName#/td/tr trtd#SearchProperties.PropertyType#/td/tr trtd#SearchProperties.Tenure#/td/tr /table /p hr /cfoutput /cfloop /cfmail /cfloop Hope this helps, Cheers Stephen __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: OT-FONT Problem
Try running it through www.whatthefont.com - a great tool for figuring out what font something is. -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
Query or Queries
I am try to qury queries. Do not know wy the below funtion is not working? Any help be appreciated. Thank you Dave CLay www.trusjoist.com cfquery datasource=#Request.App.datasource# name=Searchitems SELECT ItemID,ItemNumber,type,ProdName, QSPriceUS,CUQty FROMItems /cfquery cfquery datasource=#Request.App.datasource# name=SearchLititems SELECT ItemID,ItemNumber,type,ProdName, QSPriceUS,CUQty FROMItemsLit /cfquery CFSET form.searchterms=Cap cfquery name=combinedQ dbtype=query SELECT ItemID,ItemNumber,ProdName, QSPriceUS,CUQty FROM SearchItems, SearchLitItems WHERE (ProdName like '#form.searchTerms#%' OR ItemNumber like '#form.searchTerms#%') ORDER BY ProdName /cfquery __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
Fw: Help with CFGRID
Please, does anyone has any aditional ideas for me on this problem? I´m really having problems making cfgrid run here... Thanks Waldemiro Junior - Original Message - From: Waldemiro Junior [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 24, 2002 3:39 PM Subject: Help with CFGRID I´m using IE6, CF5, W2K and I have already installed the J2RE 1.30 on my server and CFGRID still not working. After loading my page that contains CFGRID, on the browser´s status bar there´s this message: Start: applet not initialized and the tex t inside the Java Console is: --- -- -- Java(TM) Plug-in: Version 1.3.0_01 Using JRE version 1.3.0_01 Java HotSpot(TM) Client VM User home directory = C:\WINDOWS Proxy Configuration: Manual Configuration Proxy: FW02:8080 Proxy Overrides: local c: clear console window f: finalize objects on finalization queue g: garbage collect h: display this help message l: dump classloader list m: print memory usage q: hide console s: dump system properties t: dump thread list x: clear classloader cache 0-5: set trace level to n java.lang.NullPointerException at allaire.controls2.CFGridApplet.adjustColumnWidths(CFGridApplet.java:307 ) at allaire.controls2.CFGridApplet.init(CFGridApplet.java:169) at sun.applet.AppletPanel.run(Unknown Source) at java.lang.Thread.run(Unknown Source) --- -- -- Can anyone help me on this issue? Thanks. Waldemiro Junior __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: OT-FONT Problem
I think it's Matisse or Juice ITC Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Original Message - From: Greg Luce [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, January 25, 2002 4:43 AM Subject: OT-FONT Problem --0-91440316-1011962610=:40516 Content-Type: text/plain; charset=us-ascii Anyone know the name of this font used in this Header/Nav-bar? I made it a long time ago, and need to make some changes, but can't remember where I came up with the darned font! Thanks. www.zonedogg.com Greg - Do You Yahoo!? Yahoo! Auctions Great stuff seeking new owners! Bid now! --0-91440316-1011962610=:40516 Content-Type: text/html; charset=us-ascii PAnyone know the name of this font used in this Header/Nav-bar? I made it a long time ago, and need to make some changes, but can't remember where I came up with the darned font! Thanks./P PA href=http://www.zonedogg.com;www.zonedogg.com/A/P PGreg/PBRBRpbrhr size=1bDo You Yahoo!?/bbr a href=http://rd.yahoo.com/mail_us/tag/?http://auctions.yahoo.com;Yahoo! Auctions/a Great stuff seeking new owners! a href=http://rd.yahoo.com/mail_us/tag/?http://auctions.yahoo.com;Bid now!/a --0-91440316-1011962610=:40516-- 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 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: Client Variable Storage in CF 5.0 versus 4.0
You might be advised, given how badly it sounds the application is written, to change the client store setting in the administrator, so that all applications, whether they have a cfapplication tag or not, actually use a datasource rather than the registry. One thing worth mentioning here; if you do this, and you have a problem with the database, you won't be able to run the CF Administrator, since it uses Client variables. It's easy enough to go into the registry and change the default client variable storage setting back to registry, though. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: Query or Queries
Three things come to mind. First - you must specify which query that which columns fom from. You cannot do: SELECT ItemID,ItemNumber,ProdName, QSPriceUS,CUQty Instead you must do: SELECT SearchItems.ItemID AS ItemId, SearchItems.ItemNumber AS ItemNumber, SearchItems.ProdName AS ProdName etc. Secondly, you the WHERE has some case sensitivity issues and I've had MUCH better luck putting the column name in all uppercase (don't ask me why) within the where clause. AND thirdly - aren't you really looking at a union here? Q of a Q might be the wrong choice in this instance. Mark cfquery datasource=#Request.App.datasource# name=Searchitems SELECT ItemID,ItemNumber,type,ProdName, QSPriceUS,CUQty FROMItems /cfquery cfquery datasource=#Request.App.datasource# name=SearchLititems SELECT ItemID,ItemNumber,type,ProdName, QSPriceUS,CUQty FROMItemsLit /cfquery CFSET form.searchterms=Cap cfquery name=combinedQ dbtype=query SELECT ItemID,ItemNumber,ProdName, QSPriceUS,CUQty FROM SearchItems, SearchLitItems WHERE (ProdName like '#form.searchTerms#%' OR ItemNumber like '#form.searchTerms#%') ORDER BY ProdName /cfquery _ _ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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 __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: RE: Using CFmail and loops
Stephen, You should be able to re-work your query to use the in function (where PropertyType IN ('#replace(form.propertytype, ,, ',', ALL)#'). Also, you might try building a pseudo grouping into your loop inside the cfmail and take out the query parameter of the cfmail tag assuming that you only want one email generated per serarch, right? Hatton cfloop index=PType list=#FORM.PropertyType# delimiters=, cfquery name=SearchProperties datasource=CMSX SELECT PropertyID, FullJobName, PropertyType, Tenure FROMProperties WHERE PropertyType = '#FORM.PropertyType#' cfif IsDefined(FORM.PropertyInfo) cfif FORM.PropertyInfo NEQ Freehold,Leasehold AND Tenure = '#FORM.PropertyInfo#' /cfif /cfif AND OnPrintedList = 1 ORDER BYPropertyType, FullJobName, Tenure /cfquery cfmail query=SearchProperties to=[EMAIL PROTECTED] from=[EMAIL PROTECTED] server=mail.company.com port=25 timeout=20 type=HTML cfloop query=SearchProperties cfoutput p table trtd#SearchProperties.FullJobName#/td/tr trtd#SearchProperties.PropertyType#/td/tr trtd#SearchProperties.Tenure#/td/tr /table /p hr /cfoutput /cfloop /cfmail /cfloop Hope this helps, Cheers Stephen __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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: Help with CFGRID
I couldn't get CFGRID working properly until the CFIDE folder was in the right place and mapped correctly. There's some great archives on this subject at http://www.mail-archive.com/cf-talk@houseoffusion.com/ :) Christine - Original Message - From: Waldemiro Junior [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, January 25, 2002 8:56 AM Subject: Fw: Help with CFGRID Please, does anyone has any aditional ideas for me on this problem? I´m really having problems making cfgrid run here... Thanks Waldemiro Junior - Original Message - From: Waldemiro Junior [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 24, 2002 3:39 PM Subject: Help with CFGRID I´m using IE6, CF5, W2K and I have already installed the J2RE 1.30 on my server and CFGRID still not working. After loading my page that contains CFGRID, on the browser´s status bar there´s this message: Start: applet not initialized and the tex t inside the Java Console is: --- -- -- Java(TM) Plug-in: Version 1.3.0_01 Using JRE version 1.3.0_01 Java HotSpot(TM) Client VM User home directory = C:\WINDOWS Proxy Configuration: Manual Configuration Proxy: FW02:8080 Proxy Overrides: local c: clear console window f: finalize objects on finalization queue g: garbage collect h: display this help message l: dump classloader list m: print memory usage q: hide console s: dump system properties t: dump thread list x: clear classloader cache 0-5: set trace level to n java.lang.NullPointerException at allaire.controls2.CFGridApplet.adjustColumnWidths(CFGridApplet.java:307 ) at allaire.controls2.CFGridApplet.init(CFGridApplet.java:169) at sun.applet.AppletPanel.run(Unknown Source) at java.lang.Thread.run(Unknown Source) --- -- -- Can anyone help me on this issue? Thanks. Waldemiro Junior __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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: extracting data from a huge text file
On Thu, 24 Jan 2002 23:46:14 -0600, Ron Hornbaker [EMAIL PROTECTED] wrote: okay, min, put DOWN the cough syrup, and step away from the keyboard. You know, if you didn't write such goshdarned excellent code, people would think you were nuts. ;) There is a bee on my keyboard. Ekkk. Oh wait. I am a glass of orange juice. Being what it seeks, I drown the bee in heaven. --min /- (Min thinks he must practice the fine lost art of sleep more often.) Ron Hornbaker President/CTO __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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: extracting data from a huge text file
the format of the text file is not very consistent. It's a comma delimited list, but the last field is itself a comma delimited list and fields 8 and 9 contain one double quote instead of a pair like every other field. It's very strange and I can't get the writers of this text file to explain their logic or change it so far. I don't think an automated solution will work for these reason, so I am parsing each line piece by piece and saving as individual variables. Another option.. Why not open it as an ODBC data source, and let the ODBC drivers worry about the size of the file? We recently did something like this with VB for a text file, only a few lines/records though. But it should still work well with larger files. -Original Message- From: Chris Giminez [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 24, 2002 6:56 PM To: CF-Talk Subject: Re: extracting data from a huge text file It's called CFX_ReadLine and with an initial test, it looks like it's going to do the trick. thanks very much!! Chris I'm trying to retrieve data and put it into a database from a text file. The text file is over 100MB with (I'm guessing) around 260,000 records, each record contains 85 fields. I tried to create a conditional loop at each line break, which works fine if I am working on a smaller version of the file, but chokes on the 100MB monster. Is there a more efficient way to deal with this other than looping through it or is there a way to break this file up into smaller chunks and deal with it piece by piece? Been a while since I used it but I wrote a cfx called... hmm.. I don't recall what it was called /-) ... anyway, the cfx was to read in log files one line at a time. Which is what it does, one carriage-deliminated line per call, not the entire file all at once. It's somewhere at http://www.intrafoundation.com/freeware.html. --min __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: RE: Using CFmail and loops
Actually, it might be a bit cleaner to use the ListQualify function instead of Replace: listQualify(form.propertyType,') - Original Message - From: C. Hatton Humphrey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, January 25, 2002 11:15 AM Subject: RE: RE: Using CFmail and loops Stephen, You should be able to re-work your query to use the in function (where PropertyType IN ('#replace(form.propertytype, ,, ',', ALL)#'). Also, you might try building a pseudo grouping into your loop inside the cfmail and take out the query parameter of the cfmail tag assuming that you only want one email generated per serarch, right? Hatton cfloop index=PType list=#FORM.PropertyType# delimiters=, cfquery name=SearchProperties datasource=CMSX SELECT PropertyID, FullJobName, PropertyType, Tenure FROM Properties WHERE PropertyType = '#FORM.PropertyType#' cfif IsDefined(FORM.PropertyInfo) cfif FORM.PropertyInfo NEQ Freehold,Leasehold AND Tenure = '#FORM.PropertyInfo#' /cfif /cfif AND OnPrintedList = 1 ORDER BY PropertyType, FullJobName, Tenure /cfquery cfmail query=SearchProperties to=[EMAIL PROTECTED] from=[EMAIL PROTECTED] server=mail.company.com port=25 timeout=20 type=HTML cfloop query=SearchProperties cfoutput p table trtd#SearchProperties.FullJobName#/td/tr trtd#SearchProperties.PropertyType#/td/tr trtd#SearchProperties.Tenure#/td/tr /table /p hr /cfoutput /cfloop /cfmail /cfloop Hope this helps, Cheers Stephen __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: CFSchedule
Nothing too difficult about CF schedule, just point it to a page that runs normally. I see your url is under /admin. If you have security built in to application.cfm of that directory, you won't be able to get in with your scheduled tag as far as I know. I had to do something like this with cfschedule, so I made another directory under admin, call it schedule and only would run the template with a password in the url variable, so your scheduled tag url might look like this. http://www.mydomain.com/admin/email/scheduler/test_email_process.cfm?accesscode=OIEiorJD833Ksjd Nothing is output in the template, so great security is not really necessary. Just run your report output within cfmail tags. Also keep in mind it won't work in https mode. Chris Any good tutorials on this subject - all I've seen in numerous books is examples of running reports at determined intervals. What I want to do is run a template which contains a query and then outputs the results to CFMAIL. Can I do this using CFSchedule, or is there a better way? Here's what I have now, and it won't work (I'm on a shared server with no access to the CF Admin functions): Any assistance or suggestions is/are appreciated. Thanks, Mark - !---Scheduler Template--- CFSCHEDULE ACTION=UPDATE TASK=TestMessage OPERATION=HTTPRequest URL=http://www.mydomain.com/admin/email/scheduler/test_email_process.cfm; STARTDATE=01/24/02 STARTTIME=06:45:00 INTERVAL=DAILY RESOLVEURL=No PUBLISH=No /cfschedule !---Query/Email Sendout Template--- CFQUERY NAME=q_sub DATASOURCE=uspc SELECT * FROM t_email, t_msg, t_sig, t_subcat, t_unsub_msg WHERE t_email.subcat_h = t_msg.t_subcat_ID AND t_msg.t_subcat_ID = t_subcat.sc_id AND t_msg.dateofsend = DateValue(Now()) /CFQUERY CFIF q_sub.recordcount IS 0cfabort/cfif !--- Send out mail to the specified group--- CFMAIL QUERY=q_sub GROUP = email GROUPCASESENSITIVE=No STARTROW=1 TO=#firstname# #lastname# #email# FROM=John Doe [EMAIL PROTECTED] SUBJECT=#msg_subject# CC=#copy_to# BCC=#blind_copy_to# SERVER=127.0.0.1 cfmailparam name=Reply-To value=John Doe [EMAIL PROTECTED] cfif q_sub.vit_ID NEQ 0#trim(thought)# --#trim(author)##crlf##crlf#/cfif cfif q_sub.txtmessage IS NOT #Trim(txtmessage)##crlf##crlf#/cfif cfif unsublink IS Yes#trim(unsub_msg)##crlf##crlf#/cfif cfif msg_sig IS Yes#trim(sig_line)#/cfif /CFMAIL !---Send a confirming Email to Mydomain.com indicating that the messages have been delivered.--- !---Do not suppress whitespace in the email message--- CFPROCESSINGDIRECTIVE SUPPRESSWHITESPACE=No CFMAIL TO=John Doe [EMAIL PROTECTED] FROM=John Doe [EMAIL PROTECTED] SUBJECT=Email Message Center Delivery Success SERVER=127.0.0.1 As of #LSDateFormat(Now(), dd, )# #LSTimeformat(Now(), hh:mm:ss)#, #q_sub.recordcount# subscribers have been provided a #q_sub.sub_category# message via automated email. END OF MESSAGE /CFMAIL /CFPROCESSINGDIRECTIVE cfabort __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: extracting data from a huge text file
You might still use the Merant ODBC text driver to do the work of retrieving the lines, though. Just treat it as a single large field and continue to parse it as you're doing. Jim - Original Message - From: Chris Giminez [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, January 25, 2002 10:42 AM Subject: Re: extracting data from a huge text file the format of the text file is not very consistent. It's a comma delimited list, but the last field is itself a comma delimited list and fields 8 and 9 contain one double quote instead of a pair like every other field. It's very strange and I can't get the writers of this text file to explain their logic or change it so far. I don't think an automated solution will work for these reason, so I am parsing each line piece by piece and saving as individual variables. Another option.. Why not open it as an ODBC data source, and let the ODBC drivers worry about the size of the file? We recently did something like this with VB for a text file, only a few lines/records though. But it should still work well with larger files. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
Hash()
What version of CF server introduced the function hash()? Shawn Regan Applications Developer pacifictechnologysolutions __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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: extracting data from a huge text file
It does look ideal. Unfortunately, I'm not sure how to plug in and compile the Java code and don't know that I can take the time to learn just now. Anyone have the class files for this that can be plugged in ready to roll? Chris This should be IDEAL for you. http://www.macromedia.com/v1/handlers/index.cfm?ID=22277method=full DRE -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 24, 2002 6:10 PM To: CF-Talk Subject: Re: extracting data from a huge text file How does it accomplish this when you want to loop over the contents of a large file? Does it keep the file open, or when you call it to read the 250,000th line, has it opened and closed and read through the file 249,999 times already? Jim - Original Message - From: Lewis Sellers [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 24, 2002 5:54 PM Subject: Re: extracting data from a huge text file On Thu, 24 Jan 2002 16:09:54 -0800, Chris Giminez [EMAIL PROTECTED] wrote: I'm trying to retrieve data and put it into a database from a text file. The text file is over 100MB with (I'm guessing) around 260,000 records, each record contains 85 fields. I tried to create a conditional loop at each line break, which works fine if I am working on a smaller version of the file, but chokes on the 100MB monster. Is there a more efficient way to deal with this other than looping through it or is there a way to break this file up into smaller chunks and deal with it piece by piece? Been a while since I used it but I wrote a cfx called... hmm.. I don't recall what it was called /-) ... anyway, the cfx was to read in log files one line at a time. Which is what it does, one carriage-deliminated line per call, not the entire file all at once. It's somewhere at http://www.intrafoundation.com/freeware.html. --min __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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: RE: Using CFmail and loops
The reason I suggested the replace is in case his form.propertytype is a list of strings (eg rental,studio,ranch,condo)... that would blow up an in-based where clause (the result would be WHERE PropertyType IN (rental,studio,ranch,condo) unless you use the replace, in which case it comes out as WHERE PropertyType IN ('rental','studio','ranch','condo')) .. that and the fact that ListQualify doesn't come up in my version of CF ;) C. Hatton Humphrey, Developer Fisher, Towne Associates 716-839-2141 x336 [EMAIL PROTECTED] -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 12:40 PM To: CF-Talk Subject: Re: RE: Using CFmail and loops Actually, it might be a bit cleaner to use the ListQualify function instead of Replace: listQualify(form.propertyType,') - Original Message - From: C. Hatton Humphrey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, January 25, 2002 11:15 AM Subject: RE: RE: Using CFmail and loops Stephen, You should be able to re-work your query to use the in function (where PropertyType IN ('#replace(form.propertytype, ,, ',', ALL)#'). Also, you might try building a pseudo grouping into your loop inside the cfmail and take out the query parameter of the cfmail tag assuming that you only want one email generated per serarch, right? Hatton cfloop index=PType list=#FORM.PropertyType# delimiters=, cfquery name=SearchProperties datasource=CMSX SELECT PropertyID, FullJobName, PropertyType, Tenure FROM Properties WHERE PropertyType = '#FORM.PropertyType#' cfif IsDefined(FORM.PropertyInfo) cfif FORM.PropertyInfo NEQ Freehold,Leasehold AND Tenure = '#FORM.PropertyInfo#' /cfif /cfif AND OnPrintedList = 1 ORDER BY PropertyType, FullJobName, Tenure /cfquery cfmail query=SearchProperties to=[EMAIL PROTECTED] from=[EMAIL PROTECTED] server=mail.company.com port=25 timeout=20 type=HTML cfloop query=SearchProperties cfoutput p table trtd#SearchProperties.FullJobName#/td/tr trtd#SearchProperties.PropertyType#/td/tr trtd#SearchProperties.Tenure#/td/tr /table /p hr /cfoutput /cfloop /cfmail /cfloop Hope this helps, Cheers Stephen __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: OT: Macromedia's new site design
Great, thanks. I'm seeing that content in a Netscape 6.x branch, but if it's across a good segment of browsers then that'd be a good issue to flag for them. It might just be a Mozilla 0.96 bug. The new version (o.97) doesn't have the same behaviour. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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: Hash()
CF 4.5 There's a complete list of CF functions and version on the front of www.houseoffusion.com At 12:50 PM 1/25/02, you wrote: What version of CF server introduced the function hash()? Shawn Regan Applications Developer pacifictechnologysolutions __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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: Hash()
4.5 FYI, you can find that answer at: http://www.houseoffusion.com/hof/functions.cfm Regards, Dave. Original Message Follows From: Shawn Regan [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Hash() Date: Fri, 25 Jan 2002 09:50:14 -0800 What version of CF server introduced the function hash()? Shawn Regan Applications Developer pacifictechnologysolutions __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: Help: need to Evaluate() in Caller's context
At 12:03 PM 1/23/02 -0500, Steve Oliver wrote: Name='welcome-email' Value='Thank you for signing up! Your username is ' user ' and your password is ' password That is no better. It would still try to evaluate the variables user and password in the custom tag's scope and NOT resolve them. Or you could assign user and password to the request scope, since request works in tag scopes Name='welcome-email' Value='Thank you for signing up! Your username is #Request.user# and your password is #Request.password#' Hmm... That would work, but would require adding code to hundreds of places to copy the variables into the request scope before calling the custom tag. There has GOT to be a way to evaluate using my caller's scope instead of my own (custom tag) scope. Slightly better than using request, I can use #caller.user# and #caller.password# inside the value. That would require changing all the values, but at least I wouldnt have to change any code that uses the custom tag. __ steve oliver cresco technologies, inc. http://www.crescotech.com -Original Message- From: Peter Theobald [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 23, 2002 11:47 AM To: CF-Talk Subject: Help: need to Evaluate() in Caller's context I have some text blocks that can be customized by the client (a mini-mini document management). In those blocks they sometimes access variables, for example: Name='welcome-email' Value='Thank you for signing up! Your username is #User# and your password is #password#' This dynamic text is accessed by calling my custom tag: cf_dynamictext name='welcome-email' My problem is how do I substititute the variables in the text value? If I just use #Evaluate(query.value)# then it will not have the variables #user# and #password# defined in the custom tag, because they belong to the caller's scope, not the custom tag's scope. How do I Evaluate() in the context of my caller? Or in other words, how do I make all Caller. variables accessible in the Variable. scope? Thanks, Peter Theobald P.S. please CC me directly because I only read the list every week or so and I need to get this working quickly. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: extracting data from a huge text file
Hi, I have had it complied but have not try it out yet. If you want please contact me off list, because I cannot attach any file here. Regards, Sima -Original Message- From: Chris Giminez [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 12:54 PM To: CF-Talk Subject: Re: extracting data from a huge text file It does look ideal. Unfortunately, I'm not sure how to plug in and compile the Java code and don't know that I can take the time to learn just now. Anyone have the class files for this that can be plugged in ready to roll? Chris This should be IDEAL for you. http://www.macromedia.com/v1/handlers/index.cfm?ID=22277method=full DRE -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 24, 2002 6:10 PM To: CF-Talk Subject: Re: extracting data from a huge text file How does it accomplish this when you want to loop over the contents of a large file? Does it keep the file open, or when you call it to read the 250,000th line, has it opened and closed and read through the file 249,999 times already? Jim - Original Message - From: Lewis Sellers [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 24, 2002 5:54 PM Subject: Re: extracting data from a huge text file On Thu, 24 Jan 2002 16:09:54 -0800, Chris Giminez [EMAIL PROTECTED] wrote: I'm trying to retrieve data and put it into a database from a text file. The text file is over 100MB with (I'm guessing) around 260,000 records, each record contains 85 fields. I tried to create a conditional loop at each line break, which works fine if I am working on a smaller version of the file, but chokes on the 100MB monster. Is there a more efficient way to deal with this other than looping through it or is there a way to break this file up into smaller chunks and deal with it piece by piece? Been a while since I used it but I wrote a cfx called... hmm.. I don't recall what it was called /-) ... anyway, the cfx was to read in log files one line at a time. Which is what it does, one carriage-deliminated line per call, not the entire file all at once. It's somewhere at http://www.intrafoundation.com/freeware.html. --min __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: CFFILE ERROR
Nope. But you can change it immediately after it gets uploaded. If you are having a file name conflict problem, you could always rename the file after upload or you could upload into a different directory. (Either make a directory before uploading, which would basically get out of control, or upload, rename, then move to the permanent directory.) At 08:50 AM 1/25/02 -0800, you wrote: Thanks for the help, the multipart/form-data worked like a charm. I have just one more quick ? if you do not mind. Is there a way to rename the file before it get uploaded? There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown - Original Message - From: Kym Kovan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 24, 2002 11:26 PM Subject: Re: CFFILE ERROR I keep getting the following error Error Diagnostic Information Error in CFFILE tag The form field specified in the CFFILE tag (THUMBNAIL) does not contain an uploaded file. Please be sure that you have specified the correct form field name. You usually get that eror when you don't change the form enctype over on the template that is sending the file. It should be: form action=uploadfile.cfm method=post enctype=multipart/form-data -- Yours, Kym __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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
creating a list from a query
I need to create a comma delineated list of all field values generated from a query. I know ValueList will create a list, but from what I can tell it will only create a list of values from one column for all records. Is the a way to create a list of all fields for one record? cfquery name=test datasource=names select * from finals where name = #form.name# cfquery I need to be able to search the list for specific values later. __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
CFContent and mapped drives?
Hi, Because CFContent is billed as having the ability to serve up files located in non-web-accessible folders, I took that to mean that I could map to another server from my web server and serve files located there. When I accidently called the wrong folder on the mapped drive, CF server told me there was no file of that name in that folder. I thought, Great! CFContent can access a mapped drive - now I just have to supply the correct path. When I did, I get another error message - sort of. It reads simply: Please inform the site administrator that this error has occurred (be sure to include the contents of this page in your message to the administrator). Why would CFContent be able to access a mapped drive well enough to know that the file didn't exist, but couldn't serve up the file when the path was correct? Apparently, it knew it was there; otherwise, I'd have gotten the same error message as before. Here's my code: cfheader name=Content-Disposition value=filename=#fileName#.txt cfcontent file=f:\downloads\#fileName#.txt type=text/plain Any ideas are greatly appreciated. Thanks! Andy __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: CFFILE ERROR
cffile action=upload ... has an attribute called nameConflict that y ou can set to overwrite or makeunique. If you set it to makeunique it creates a new filename for you and stores the value in FILE.SERVERFILE -MK -Original Message- From: Jennifer Larkin [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 10:38 AM To: CF-Talk Subject: Re: CFFILE ERROR Nope. But you can change it immediately after it gets uploaded. If you are having a file name conflict problem, you could always rename the file after upload or you could upload into a different directory. (Either make a directory before uploading, which would basically get out of control, or upload, rename, then move to the permanent directory.) At 08:50 AM 1/25/02 -0800, you wrote: Thanks for the help, the multipart/form-data worked like a charm. I have just one more quick ? if you do not mind. Is there a way to rename the file before it get uploaded? There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown - Original Message - From: Kym Kovan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 24, 2002 11:26 PM Subject: Re: CFFILE ERROR I keep getting the following error Error Diagnostic Information Error in CFFILE tag The form field specified in the CFFILE tag (THUMBNAIL) does not contain an uploaded file. Please be sure that you have specified the correct form field name. You usually get that eror when you don't change the form enctype over on the template that is sending the file. It should be: form action=uploadfile.cfm method=post enctype=multipart/form-data -- Yours, Kym _ _ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: CFContent and mapped drives?
System by default does not have access to the network. You must have cf log on as a user that has access to view that drive. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Andrew Peterson [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 2:09 PM To: CF-Talk Subject: CFContent and mapped drives? Hi, Because CFContent is billed as having the ability to serve up files located in non-web-accessible folders, I took that to mean that I could map to another server from my web server and serve files located there. When I accidently called the wrong folder on the mapped drive, CF server told me there was no file of that name in that folder. I thought, Great! CFContent can access a mapped drive - now I just have to supply the correct path. When I did, I get another error message - sort of. It reads simply: Please inform the site administrator that this error has occurred (be sure to include the contents of this page in your message to the administrator). Why would CFContent be able to access a mapped drive well enough to know that the file didn't exist, but couldn't serve up the file when the path was correct? Apparently, it knew it was there; otherwise, I'd have gotten the same error message as before. Here's my code: cfheader name=Content-Disposition value=filename=#fileName#.txt cfcontent file=f:\downloads\#fileName#.txt type=text/plain Any ideas are greatly appreciated. Thanks! Andy __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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: creating a list from a query
Tim; How about: cfoutput query=qGetRecords cfset lstRecords = #lstRecords#~'#B_FName#','#B_LName#','#Address#'~ /cfoutput Seperate your records by a tilda and then split them out later by looking for a double tilda. -Original Message- From: Tim [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 12:08 PM To: CF-Talk Subject: creating a list from a query I need to create a comma delineated list of all field values generated from a query. I know ValueList will create a list, but from what I can tell it will only create a list of values from one column for all records. Is the a way to create a list of all fields for one record? cfquery name=test datasource=names select * from finals where name = #form.name# cfquery I need to be able to search the list for specific values later. __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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: creating a list from a query
cfset qryList = cfoutput query=test cfset qryList = ListAppend(qryList,#name#,#address#,#phone#,#chr(7)# /cfoutput You can then get each list by breaking it down to smaller lists by using chr(7) as your delimiter. __ steve oliver cresco technologies, inc. http://www.crescotech.com -Original Message- From: Tim [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 1:08 PM To: CF-Talk Subject: creating a list from a query I need to create a comma delineated list of all field values generated from a query. I know ValueList will create a list, but from what I can tell it will only create a list of values from one column for all records. Is the a way to create a list of all fields for one record? cfquery name=test datasource=names select * from finals where name = #form.name# cfquery I need to be able to search the list for specific values later. __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: CFContent and mapped drives?
Even though you can get the cold fusion server to access files on a shared drive, by running cold fusion in an administrator account or some other user, this does not help for cfcontent because cfcontent runs in the context of the stub, in other words, it runs as the iis user and it is a lot more difficult to get it to access files on a share. - Original Message - From: Andrew Peterson [EMAIL PROTECTED] Because CFContent is billed as having the ability to serve up files located in non-web-accessible folders, I took that to mean that I could map to another server from my web server and serve files located there. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: CFContent and mapped drives?
You're correct that it's not the CV user; instead you need to replace the default iis anonymous account with one that has access to the remote machine. There's some info here: http://www.defusion.com/articles/index.cfm?ArticleID=89 on what's involved. -Original Message- From: DDB Lists [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 2:27 PM To: CF-Talk Subject: Re: CFContent and mapped drives? Even though you can get the cold fusion server to access files on a shared drive, by running cold fusion in an administrator account or some other user, this does not help for cfcontent because cfcontent runs in the context of the stub, in other words, it runs as the iis user and it is a lot more difficult to get it to access files on a share. - Original Message - From: Andrew Peterson [EMAIL PROTECTED] Because CFContent is billed as having the ability to serve up files located in non-web-accessible folders, I took that to mean that I could map to another server from my web server and serve files located there. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: creating a list from a query
Something like this should work. Lookup the columnList property in the CF manual. cfquery name=myQuery datasource=names select * from finals where name = #form.name# /cfquery cfset myValList = cfloop list = #myQuery.columnList# index = i cfset myValList = listappend(valuelist(evaluate(myQuery. i))) /cfloop - Original Message - From: Tim [EMAIL PROTECTED] I need to create a comma delineated list of all field values generated from a query. I know ValueList will create a list, but from what I can tell it will only create a list of values from one column for all records. Is the a way to create a list of all fields for one record? __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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
(ot) SQL Brain Fart
I'm just blanking out on how to do this query. The query below is returning multiple duplicates of records. I can't figure out why. It looks to me like it shouldn't. Obviously, I'm missing something: SELECT FirstName FROM table1 WHERE TableID IN ( SELECT TableID FROM Table2 WHERE Status = 'Paid') Obviously, I want only one copy of each record. Howard Owens Internet Operations Coordinator www.insidevc.com [EMAIL PROTECTED] AIM: GoCatGo1956 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: (ot) SQL Brain Fart
why are you doing a subselect? it's extremely slow compared to a direct join. SELECT t1.firstname FROM table1 t1, table2 t2 WHERE t1.tableid = t2.tableid AND t2.status = 'Paid' christopher olive, cto, vp of web development cresco technologies, inc 410.825.0383 http://www.crescotech.com -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 2:43 PM To: CF-Talk Subject: (ot) SQL Brain Fart I'm just blanking out on how to do this query. The query below is returning multiple duplicates of records. I can't figure out why. It looks to me like it shouldn't. Obviously, I'm missing something: SELECT FirstName FROM table1 WHERE TableID IN ( SELECT TableID FROM Table2 WHERE Status = 'Paid') Obviously, I want only one copy of each record. Howard Owens Internet Operations Coordinator www.insidevc.com [EMAIL PROTECTED] AIM: GoCatGo1956 __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: (ot) SQL Brain Fart
dunno, try doing a join versus an 'in'... or maybe a distinct FirstName (perhaps you've got more than one entry with the same first name too) select FirstName from table1 inner join table2 on table1.tableid = table2.tableid where table2.status = 'Paid' C. Hatton Humphrey, Developer Fisher, Towne Associates 716-839-2141 x336 [EMAIL PROTECTED] -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 2:43 PM To: CF-Talk Subject: (ot) SQL Brain Fart I'm just blanking out on how to do this query. The query below is returning multiple duplicates of records. I can't figure out why. It looks to me like it shouldn't. Obviously, I'm missing something: SELECT FirstName FROM table1 WHERE TableID IN ( SELECT TableID FROM Table2 WHERE Status = 'Paid') Obviously, I want only one copy of each record. Howard Owens Internet Operations Coordinator www.insidevc.com [EMAIL PROTECTED] AIM: GoCatGo1956 __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: (ot) SQL Brain Fart
Thanks for the quick responses, guys. As for the query below -- that was my original query. Got multiples with it, too. I'll try C. Hatton Humphrey's suggestion -- after lunch. H. Howard Owens Internet Operations Coordinator www.insidevc.com [EMAIL PROTECTED] AIM: GoCatGo1956 -Original Message- From: Christopher Olive [SMTP:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 11:55 AM To: CF-Talk Subject: RE: (ot) SQL Brain Fart why are you doing a subselect? it's extremely slow compared to a direct join. SELECT t1.firstname FROM table1 t1, table2 t2 WHERE t1.tableid = t2.tableid AND t2.status = 'Paid' christopher olive, cto, vp of web development cresco technologies, inc 410.825.0383 http://www.crescotech.com -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 2:43 PM To: CF-Talk Subject: (ot) SQL Brain Fart I'm just blanking out on how to do this query. The query below is returning multiple duplicates of records. I can't figure out why. It looks to me like it shouldn't. Obviously, I'm missing something: SELECT FirstName FROM table1 WHERE TableID IN ( SELECT TableID FROM Table2 WHERE Status = 'Paid') Obviously, I want only one copy of each record. Howard Owens Internet Operations Coordinator www.insidevc.com [EMAIL PROTECTED] AIM: GoCatGo1956 __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: (ot) SQL Brain Fart
Putting a 'distinct' into the select below should do it. It sounds like you have more than one record matching in your second table, which is why you're getting multiples. Dirk -Original Message- From: Owens, Howard [SMTP:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 11:52 AM To: CF-Talk Subject: RE: (ot) SQL Brain Fart Thanks for the quick responses, guys. As for the query below -- that was my original query. Got multiples with it, too. I'll try C. Hatton Humphrey's suggestion -- after lunch. H. Howard Owens Internet Operations Coordinator www.insidevc.com [EMAIL PROTECTED] AIM: GoCatGo1956 -Original Message- From: Christopher Olive [SMTP:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 11:55 AM To: CF-Talk Subject:RE: (ot) SQL Brain Fart why are you doing a subselect? it's extremely slow compared to a direct join. SELECT t1.firstname FROM table1 t1, table2 t2 WHERE t1.tableid = t2.tableid AND t2.status = 'Paid' christopher olive, cto, vp of web development cresco technologies, inc 410.825.0383 http://www.crescotech.com -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 2:43 PM To: CF-Talk Subject: (ot) SQL Brain Fart I'm just blanking out on how to do this query. The query below is returning multiple duplicates of records. I can't figure out why. It looks to me like it shouldn't. Obviously, I'm missing something: SELECT FirstName FROM table1 WHERE TableID IN ( SELECT TableID FROM Table2 WHERE Status = 'Paid') Obviously, I want only one copy of each record. Howard Owens Internet Operations Coordinator www.insidevc.com [EMAIL PROTECTED] AIM: GoCatGo1956 __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: Verify form post was from my server.
This is a very important question in my opinion... and I have been scrounging the net looking for a solution I can implement. I would certainly appreciate someone throwing a light switch so I can see the solution more clearly. As Dave clearly points out... we can NOT use the cgi.http.referrer variable. Curious, would having application.cfm check a client.LoggedIn or session.LoggedIn variable keep users with other tools like Dave suggested from being successful? till next time, Brian At 10:19 AM 1/24/02 -0800, you wrote: Is there a way I can narrow down a hackers ability to post a form to one of my action templates. Http-referrer is not reliable, I know. JS __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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: extracting data from a huge text file
Chris, Sima, Can you keep me posted on what you figure out with that java io buisness. I'll have to do something similar soon myself. And it will probably give a bit of a headsup on NEO. Thanks. DRE [EMAIL PROTECTED] -Original Message- From: Sima Lee [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 11:24 AM To: CF-Talk Subject: RE: extracting data from a huge text file Hi, I have had it complied but have not try it out yet. If you want please contact me off list, because I cannot attach any file here. Regards, Sima -Original Message- From: Chris Giminez [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 12:54 PM To: CF-Talk Subject: Re: extracting data from a huge text file It does look ideal. Unfortunately, I'm not sure how to plug in and compile the Java code and don't know that I can take the time to learn just now. Anyone have the class files for this that can be plugged in ready to roll? Chris This should be IDEAL for you. http://www.macromedia.com/v1/handlers/index.cfm?ID=22277method=full DRE -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 24, 2002 6:10 PM To: CF-Talk Subject: Re: extracting data from a huge text file How does it accomplish this when you want to loop over the contents of a large file? Does it keep the file open, or when you call it to read the 250,000th line, has it opened and closed and read through the file 249,999 times already? Jim - Original Message - From: Lewis Sellers [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 24, 2002 5:54 PM Subject: Re: extracting data from a huge text file On Thu, 24 Jan 2002 16:09:54 -0800, Chris Giminez [EMAIL PROTECTED] wrote: I'm trying to retrieve data and put it into a database from a text file. The text file is over 100MB with (I'm guessing) around 260,000 records, each record contains 85 fields. I tried to create a conditional loop at each line break, which works fine if I am working on a smaller version of the file, but chokes on the 100MB monster. Is there a more efficient way to deal with this other than looping through it or is there a way to break this file up into smaller chunks and deal with it piece by piece? Been a while since I used it but I wrote a cfx called... hmm.. I don't recall what it was called /-) ... anyway, the cfx was to read in log files one line at a time. Which is what it does, one carriage-deliminated line per call, not the entire file all at once. It's somewhere at http://www.intrafoundation.com/freeware.html. --min __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
WAY OT: IE 5.5 error when updating JavaScript Arrays
Hey All, OK I've built an invoicing module that uses DHTML, JavaScript, and CF to essentially add line items to an invoice without refreshing the browser or touching the database (until it's finished and submitted of course). When a user hits the add button after entering the line item details, the JavaScript arrays for line items are all updated and the layer is rebuilt and displays the newly added line item (and clears the line item entry form etc.). The problem that has just started is that after entering a random number of line items...up pops the IE would you like to send a bug report to Microsoft because your app just blew up in your face doohickeys. when I first tested it, the failure occurred when trying to add line item number 5. Now it seems to fail everytime on the 2nd item (my client has had varying results with this...failure on 4 and on 5). So I know I'll get all kinds of requestes for code examples and the rest, but I haven't even started digging yet, so at this point I'm just wondering if anyone has heard of or experienced anything like this involving DHTML, JavaScript (and possibly specific to JS arrays)?? Thanks in advance for any insight...I can already feel that this bit of debugging is going to hurt :-( Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: creating a list from a query
It's faster to build the list in the SQL statement... [Oracle] SELECT field1 || ~ || field2 || ~ || field 3 FROM. then finish it off with a VALUELIST() function. But this is pretty specialized so it may not be the right solution for your app. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Tim [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 10:08 AM To: CF-Talk Subject: creating a list from a query I need to create a comma delineated list of all field values generated from a query. I know ValueList will create a list, but from what I can tell it will only create a list of values from one column for all records. Is the a way to create a list of all fields for one record? cfquery name=test datasource=names select * from finals where name = #form.name# cfquery I need to be able to search the list for specific values later. __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: WAY OT: IE 5.5 error when updating JavaScript Arrays
BTW I've tested this issue in Netscape 4.07 and to my amazement it works fine there and only craps out in IE (now there's a first) ;-) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, January 25, 2002 12:33 PM Subject: WAY OT: IE 5.5 error when updating JavaScript Arrays Hey All, OK I've built an invoicing module that uses DHTML, JavaScript, and CF to essentially add line items to an invoice without refreshing the browser or touching the database (until it's finished and submitted of course). When a user hits the add button after entering the line item details, the JavaScript arrays for line items are all updated and the layer is rebuilt and displays the newly added line item (and clears the line item entry form etc.). The problem that has just started is that after entering a random number of line items...up pops the IE would you like to send a bug report to Microsoft because your app just blew up in your face doohickeys. when I first tested it, the failure occurred when trying to add line item number 5. Now it seems to fail everytime on the 2nd item (my client has had varying results with this...failure on 4 and on 5). So I know I'll get all kinds of requestes for code examples and the rest, but I haven't even started digging yet, so at this point I'm just wondering if anyone has heard of or experienced anything like this involving DHTML, JavaScript (and possibly specific to JS arrays)?? Thanks in advance for any insight...I can already feel that this bit of debugging is going to hurt :-( Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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
Worked for the last two weeks, suddenly stopped
I have a site that I have a couple of session variables set, and for the la st two or three weeks that I have been working on this all was working well Now, for some reason the CFIF statements are not working. What I am talking about is this: CFQUERY NAME=GetInsuranceCompanies DATASOURCE=#DataSource# SELECT * FROM Insurance cfif Session.UserType IS User WHERE EntityID = #SESSION.EntityID# AND Active 0 cfelse Where Active 0 /cfif ORDER BY InsuranceCompany /CFQUERY I am outputting the UserType Session using the CFDUMP tag right in the form that this and other queries are in, and I am showing my usertype as User, however, the query is only using the Where Active 0 clause. I have some other things that are supposed to happen based on the usertype, but none of them are working. I am baffled. I have gone through my CF server admin sec tion, tried other machines thinking that mine was messed up or something, c opied the site to another web server to see if maybe the server was the iss ue, tried putting the session.usertype attribute in parens and using single and double quotes but I am not getting anywhere. And like I said before, e verything was working great up till this afternoon. Nothing has changed on the site or the server as far as I know. Anyone encounter this in the past and if so, how did you overcome it? __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: Worked for the last two weeks, suddenly stopped
Try changing IS to EQ and trim your session variable. HTH Clint -- Original Message -- from: Bruce Sorge [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Fri, 25 Jan 2002 16:31:53 -0500 I have a site that I have a couple of session variables set, and for the la st two or three weeks that I have been working on this all was working well Now, for some reason the CFIF statements are not working. What I am talking about is this: CFQUERY NAME=GetInsuranceCompanies DATASOURCE=#DataSource# SELECT * FROM Insurance cfif Session.UserType IS User WHERE EntityID = #SESSION.EntityID# AND Active 0 cfelse Where Active 0 /cfif ORDER BY InsuranceCompany /CFQUERY I am outputting the UserType Session using the CFDUMP tag right in the form that this and other queries are in, and I am showing my usertype as User, however, the query is only using the Where Active 0 clause. I have some other things that are supposed to happen based on the usertype, but none of them are working. I am baffled. I have gone through my CF server admin sec tion, tried other machines thinking that mine was messed up or something, c opied the site to another web server to see if maybe the server was the iss ue, tried putting the session.usertype attribute in parens and using single and double quotes but I am not getting anywhere. And like I said before, e verything was working great up till this afternoon. Nothing has changed on the site or the server as far as I know. Anyone encounter this in the past and if so, how did you overcome it? __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: Worked for the last two weeks, suddenly stopped
OK, that worked. Anyone have any ideas why for the last few weeks all was w ell, and suddenly it did not work? -- Original Message -- From: clint [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Fri, 25 Jan 2002 16:37:50 -0500 Try changing IS to EQ and trim your session variable. HTH Clint -- Original Message -- from: Bruce Sorge [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Fri, 25 Jan 2002 16:31:53 -0500 I have a site that I have a couple of session variables set, and for the la st two or three weeks that I have been working on this all was working well Now, for some reason the CFIF statements are not working. What I am talking about is this: CFQUERY NAME=GetInsuranceCompanies DATASOURCE=#DataSource# SELECT * FROM Insurance cfif Session.UserType IS User WHERE EntityID = #SESSION.EntityID# AND Active 0 cfelse Where Active 0 /cfif ORDER BY InsuranceCompany /CFQUERY I am outputting the UserType Session using the CFDUMP tag right in the form that this and other queries are in, and I am showing my usertype as User, however, the query is only using the Where Active 0 clause. I have some other things that are supposed to happen based on the usertype, but none of them are working. I am baffled. I have gone through my CF server admin sec tion, tried other machines thinking that mine was messed up or something, c opied the site to another web server to see if maybe the server was the iss ue, tried putting the session.usertype attribute in parens and using single and double quotes but I am not getting anywhere. And like I said before, e verything was working great up till this afternoon. Nothing has changed on the site or the server as far as I know. Anyone encounter this in the past and if so, how did you overcome it? __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: Worked for the last two weeks, suddenly stopped
You need to lock your session variables first off. Try copying them into local variables before you use them in a query. cflock scope=SESSION timeout=30 type=READONLY cfset Variables.userType = Session.UserType cfset Variables.EntityID = Session.EntityID /cflock __ steve oliver cresco technologies, inc. http://www.crescotech.com -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 4:32 PM To: CF-Talk Subject: Worked for the last two weeks, suddenly stopped I have a site that I have a couple of session variables set, and for the la st two or three weeks that I have been working on this all was working well Now, for some reason the CFIF statements are not working. What I am talking about is this: CFQUERY NAME=GetInsuranceCompanies DATASOURCE=#DataSource# SELECT * FROM Insurance cfif Session.UserType IS User WHERE EntityID = #SESSION.EntityID# AND Active 0 cfelse Where Active 0 /cfif ORDER BY InsuranceCompany /CFQUERY I am outputting the UserType Session using the CFDUMP tag right in the form that this and other queries are in, and I am showing my usertype as User, however, the query is only using the Where Active 0 clause. I have some other things that are supposed to happen based on the usertype, but none of them are working. I am baffled. I have gone through my CF server admin sec tion, tried other machines thinking that mine was messed up or something, c opied the site to another web server to see if maybe the server was the iss ue, tried putting the session.usertype attribute in parens and using single and double quotes but I am not getting anywhere. And like I said before, e verything was working great up till this afternoon. Nothing has changed on the site or the server as far as I know. Anyone encounter this in the past and if so, how did you overcome it? __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
ReReplaceNoCase problem
I have this text: font color=white How would I turn it into: font color=white using REReplaceNoCase... This effort chokes: temp = font color=white REReplaceNoCase(temp, ##60;(font[^62](##62;), \1, ALL); __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: ReReplaceNoCase problem
Try this: cfset string= font color=white cfset newstring=rereplacenocase(string, ([^]*),\1,ALL) __ steve oliver cresco technologies, inc. http://www.crescotech.com -Original Message- From: Eddie Shipman [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 4:51 PM To: CF-Talk Subject: ReReplaceNoCase problem I have this text: font color=white How would I turn it into: font color=white using REReplaceNoCase... This effort chokes: temp = font color=white REReplaceNoCase(temp, ##60;(font[^62](##62;), \1, ALL); __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: ReReplaceNoCase problem
Even though I sent the message in plaintext... the text that was sent in the message didn't come out correct... This text, #60; font color=#34;white#34;#62; was supposed to be: #38;#35;60;font color=#38;#35;34;white#38;#35;34;#38;#35;62; I want it changed to: font color=white --- Steve Oliver [EMAIL PROTECTED] wrote: Try this: cfset string= font color=white cfset newstring=rereplacenocase(string, ([^]*),\1,ALL) SNIP How would I turn it into: font color=white using REReplaceNoCase... This effort chokes: temp = font color=white REReplaceNoCase(temp, ##60;(font[^62](##62;), \1, ALL); __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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
CFPOP attachments
Say I've got a CFpop query as follows. I was using some code for looping through multiple-attachments from cfcomet.com (http://www.cfcomet.com/cfcomet/other/index.cfm?ArticleID=7AD3EF1A-C5E5-4FE9 -8F7C88F84D5C822D). What I need to do is prepend the sender's email address to the attachment-filename when it's stored to the web-server. At the moment, I'm using the GENERATEUNIQUEFILENAMES=Yes attrib in the query. The CFComet code I'm using is as follows: CFSET Count = ListLen(newspool.attachments, #CHR(9)#) CFIF Len(newspool.attachments) This message contains #Count# attachmentCFIF Count NEQ 1s/CFIF:P CFLOOP FROM=1 TO=#ListLen(newspool.Attachments, chr(9))# INDEX=i !--- A HREF=index.cfm?fuseaction=getMailFile file=#URLEncodedFormat(GetFileFromPath(ListGetAt(newspool.attachmentfiles, i, chr(9# name=#URLEncodedFormat(ListGetAt(newspool.attachments, i, chr(9)))# #ListGetAt(newspool.attachments, i, chr(9))# /ABR --- /CFLOOP /CFIF Should I rename the files in the above cfloop using #i# for the filename/path in cffile - and if so, do I keep the generateuniquefilenames attrib Yes? Hope some of that makes sense! Cheers Will __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: CFPOP attachments
You'll need to rename the files in one loop, and then link to the newly named files in a separate loop. (You could do them both, but it seems cleaner to do it the other way) I'd keep the unique file names. - Original Message - From: W Luke [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, January 25, 2002 4:05 PM Subject: CFPOP attachments Say I've got a CFpop query as follows. I was using some code for looping through multiple-attachments from cfcomet.com (http://www.cfcomet.com/cfcomet/other/index.cfm?ArticleID=7AD3EF1A-C5E5-4FE9 -8F7C88F84D5C822D). What I need to do is prepend the sender's email address to the attachment-filename when it's stored to the web-server. At the moment, I'm using the GENERATEUNIQUEFILENAMES=Yes attrib in the query. The CFComet code I'm using is as follows: CFSET Count = ListLen(newspool.attachments, #CHR(9)#) CFIF Len(newspool.attachments) This message contains #Count# attachmentCFIF Count NEQ 1s/CFIF:P CFLOOP FROM=1 TO=#ListLen(newspool.Attachments, chr(9))# INDEX=i !--- A HREF=index.cfm?fuseaction=getMailFile file=#URLEncodedFormat(GetFileFromPath(ListGetAt(newspool.attachmentfiles, i, chr(9# name=#URLEncodedFormat(ListGetAt(newspool.attachments, i, chr(9)))# #ListGetAt(newspool.attachments, i, chr(9))# /ABR --- /CFLOOP /CFIF Should I rename the files in the above cfloop using #i# for the filename/path in cffile - and if so, do I keep the generateuniquefilenames attrib Yes? Hope some of that makes sense! Cheers Will __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: Worked for the last two weeks, suddenly stopped
Do you set the usertype to User or User somewhere? - Original Message - From: Bruce Sorge [EMAIL PROTECTED] Date: Friday, January 25, 2002 2:55 pm Subject: Re: Worked for the last two weeks, suddenly stopped OK, that worked. Anyone have any ideas why for the last few weeks all was w ell, and suddenly it did not work? -- Original Message -- From: clint [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Fri, 25 Jan 2002 16:37:50 -0500 Try changing IS to EQ and trim your session variable. HTH Clint -- Original Message -- from: Bruce Sorge [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Fri, 25 Jan 2002 16:31:53 -0500 I have a site that I have a couple of session variables set, and for the la st two or three weeks that I have been working on this all was working well Now, for some reason the CFIF statements are not working. What I am talking about is this: CFQUERY NAME=GetInsuranceCompanies DATASOURCE=#Data Source# SELECT * FROM Insurance cfif Session.UserType IS User WHERE EntityID = #SESSION.EntityID# AND Active 0 cfelse Where Active 0 /cfif ORDER BY InsuranceCompany /CFQUERY I am outputting the UserType Session using the CFDUMP tag right in the form that this and other queries are in, and I am showing my usertype as User, however, the query is only using the Where Active 0 clause. I have some other things that are supposed to happen based on the usertype, but none of them are working. I am baffled. I have gone through my CF server admin sec tion, tried other machines thinking that mine was messed up or something, c opied the site to another web server to see if maybe the server was the iss ue, tried putting the session.usertype attribute in parens and using single and double quotes but I am not getting anywhere. And like I said before, e verything was working great up till this afternoon. Nothing has changed on the site or the server as far as I know. Anyone encounter this in the past and if so, how did you overcome i t? ___ _ __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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?sideb ar=lists __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: Geographical dispersion
See if you can find a hosting company that does load balancing..M aybe try co-locating 2 servers in different places with Windows 2000 server to load balance..or find someone that has a hardware load balancer.without the client actually having their own physical lo cation/network available it may be difficult [EMAIL PROTECTED] 01/24/02 09:10PM Hi! We have a client who needs their ColdFusion site mirrored geograph ically. They need it so that if Seattle gets hit with an earthquake (since we are out of the Seattle area), the mirrored site in Chicago (for example) will automatically pick up without any site outage. I am not familiar wit h all the details of how mirroring works, but the hosting companies I have talked to so far cannot offer this service... they say that mirroring it in the same rack is not a problem, but mirroring across the country poses so me kind of problem. Is there a hosting company that anyone knows of that can take care of this situation? We actually have two applications for a solu tion to this problem. We have this new site that needs to be hosted and mirr ored, but we also have a Linux server in a data center here that needs to b e mirrored somewhere else in the country also (with auto switch over). I thought Akamai would be a solution, but the rep from there said that they do only hit dispersion, but not actual content and site mirroring. Any ideas? Sorry if some of the terminology is off...kind of over my head here.. :) Thanks, Christine [EMAIL PROTECTED] _ _ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: ReReplaceNoCase problem
Why don't you just use replace then? cfset string=Replace(string, ##38;##35;##60;, , ALL cfset string=Replace(string, ##38;##35;##34;, , ALL cfset string=Replace(string, ##38;##35;##62;, , ALL Remember whenever do something like that you have to escape the characters. ## for # and for __ steve oliver cresco technologies, inc. http://www.crescotech.com -Original Message- From: Eddie Shipman [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 5:07 PM To: CF-Talk Subject: RE: ReReplaceNoCase problem Even though I sent the message in plaintext... the text that was sent in the message didn't come out correct... This text, #60; font color=#34;white#34;#62; was supposed to be: #38;#35;60;font color=#38;#35;34;white#38;#35;34;#38;#35;62; I want it changed to: font color=white --- Steve Oliver [EMAIL PROTECTED] wrote: Try this: cfset string= font color=white cfset newstring=rereplacenocase(string, ([^]*),\1,ALL) SNIP How would I turn it into: font color=white using REReplaceNoCase... This effort chokes: temp = font color=white REReplaceNoCase(temp, ##60;(font[^62](##62;), \1, ALL); __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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
Events system
Does anyone know of an events system where I can have users log in and post happenings that can be displayed and searched? Sort of like - someone enters information pertaining to a computer fair including place/date/time. Thanks, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
optional UDF parameters???
Is it possible to make a parameter optional in UDFs, just like some of CF's built in functions? Here's what I got's: cfscript /* i might only want to pass the 1st parameter and i have no need to pass the 2nd parameter everytime so i'd like to leave it off and not code in an empty () everytime */ function myFunction(Parameter1,Parameter2){ someVariable=; etc... } /cfscript If I leave the function like above and then only pass one argument: #myFunction(Bah)# , I get the following error: The number of arguments passed to a user-defined function cannot be less than the number of parameters in its definition. This call to myFunction passes 1 arguments, but 2 parameters are defined. I know CF can do it, but can I? Tyler Silcox email | [EMAIL PROTECTED] __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: optional UDF parameters???
There's a function that mimics CFPARAM here, if that helps. http://www.cflib.org/udf.cfm?ID=144 __ steve oliver cresco technologies, inc. http://www.crescotech.com -Original Message- From: Tyler Silcox [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 6:24 PM To: CF-Talk Subject: optional UDF parameters??? Is it possible to make a parameter optional in UDFs, just like some of CF's built in functions? Here's what I got's: cfscript /* i might only want to pass the 1st parameter and i have no need to pass the 2nd parameter everytime so i'd like to leave it off and not code in an empty () everytime */ function myFunction(Parameter1,Parameter2){ someVariable=; etc... } /cfscript If I leave the function like above and then only pass one argument: #myFunction(Bah)# , I get the following error: The number of arguments passed to a user-defined function cannot be less than the number of parameters in its definition. This call to myFunction passes 1 arguments, but 2 parameters are defined. I know CF can do it, but can I? Tyler Silcox email | [EMAIL PROTECTED] __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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: optional UDF parameters???
Yes attributes can be optional You'll want to only list the attributes that are required function defintion. But when you call the function you can use the arguments array to reference anything that you pass to the function. cfscript Function fnMyTest(req1,req2) { var optionlVar = arguments[3] // the problem here is that I don't remember/know if you need some scope for the argument array - CFDJ had an article on it back when CF5 was coming out I can only assume forta.com has info on it too. } // use the function fnMyTest(FORM.req1,FORM.req2,FORM.opt1); // will process it /cfscript HTH, t ** Tyler M. Fitch Certified Advanced ColdFusion 5 Developer http://isitedesign.com ** -Original Message- From: Tyler Silcox [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 3:24 PM To: CF-Talk Subject: optional UDF parameters??? Is it possible to make a parameter optional in UDFs, just like some of CF's built in functions? Here's what I got's: cfscript /* i might only want to pass the 1st parameter and i have no need to pass the 2nd parameter everytime so i'd like to leave it off and not code in an empty () everytime */ function myFunction(Parameter1,Parameter2){ someVariable=; etc... } /cfscript If I leave the function like above and then only pass one argument: #myFunction(Bah)# , I get the following error: The number of arguments passed to a user-defined function cannot be less than the number of parameters in its definition. This call to myFunction passes 1 arguments, but 2 parameters are defined. I know CF can do it, but can I? Tyler Silcox email | [EMAIL PROTECTED] __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: Geographical dispersion
well a solution will be elegant and certainly complex... I forgot expensive as well... client should be deep pocketed.. whether you do it yourself or opt for proven products... it take enough work to call it a skill.. hopefully others will chime in on this topic. First, outsource your DNS... someplace you have the ability to dynamically update your IP info via the web when you need to live time... See Enom.com service... plug in your multiple locations separate Nameservers.. be sure to register those initially as nameservers with INternic... From the switching layer, companies like F5 and Coyote Point has DNS loaded switches/load balancers that have geographic distribution... you of course need multiple units on each end for redundancy.. it gets expensive... but they are cheap on Ebay... From the disk end... I believe you can easily map a remote drive via Windows.. based on IP with proper permissions.. once you do that, you can run one of the may mirror packages to push the flat files into synchronization.. ideally, one is the master and one is the servant... Folks like EMC offer addon software (20-40k) for their Symmetrix system that allows such... but mapping and lowly software likely will cut it for you.. or an FTP client with duplication feature set... From the database side... SQL Server 7 + has some transaction stuff... I don't use such.. but mature databases will have distribution facilities... Oracle and MySQl also have a good set of tools to accommodate...be sure to buy some aspirin before you start...getting it to work and synching seamlessly is another feat... Those are the pieces... With the multiples and DNS stuff, you also can get full usage of all gear versus having unused gear that isn't regularly tested and operational online... highly recommend doing it that way.. otherwise when something happens you might be embarrassed. -paris -Original Message- From: Michael Ross [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 17:50 To: CF-Talk Subject: Re: Geographical dispersion See if you can find a hosting company that does load balancing..M aybe try co-locating 2 servers in different places with Windows 2000 server to load balance..or find someone that has a hardware load balancer.without the client actually having their own physical lo cation/network available it may be difficult [EMAIL PROTECTED] 01/24/02 09:10PM Hi! We have a client who needs their ColdFusion site mirrored geograph ically. They need it so that if Seattle gets hit with an earthquake (since we are out of the Seattle area), the mirrored site in Chicago (for example) will automatically pick up without any site outage. I am not familiar wit h all the details of how mirroring works, but the hosting companies I have talked to so far cannot offer this service... they say that mirroring it in the same rack is not a problem, but mirroring across the country poses so me kind of problem. Is there a hosting company that anyone knows of that can take care of this situation? We actually have two applications for a solu tion to this problem. We have this new site that needs to be hosted and mirr ored, but we also have a Linux server in a data center here that needs to b e mirrored somewhere else in the country also (with auto switch over). I thought Akamai would be a solution, but the rep from there said that they do only hit dispersion, but not actual content and site mirroring. Any ideas? Sorry if some of the terminology is off...kind of over my head here.. :) Thanks, Christine [EMAIL PROTECTED] _ _ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: Events system
duckingTomatos I can offer http://www.dayinthevalley.com, a php/mySql site /duck ... no search feature but ez to use --mv Howie Hamlin wrote: Does anyone know of an events system where I can have users log in and post happenings that can be displayed and searched? Sort of like - someone enters information pertaining to a computer fair including place/date/time. Thanks, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: Geographical dispersion
Isn't this the type of thing Akami does?? Hope I got the name right. If I'm remebering right, they mirror a website to multiple geographic locations, and requests for the site are served by the location closest to them (thus improving speed). Shawn Grover -Original Message- From: Paris Lundis [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 4:41 PM To: CF-Talk Subject: RE: Geographical dispersion well a solution will be elegant and certainly complex... I forgot expensive as well... client should be deep pocketed.. whether you do it yourself or opt for proven products... it take enough work to call it a skill.. hopefully others will chime in on this topic. First, outsource your DNS... someplace you have the ability to dynamically update your IP info via the web when you need to live time... See Enom.com service... plug in your multiple locations separate Nameservers.. be sure to register those initially as nameservers with INternic... From the switching layer, companies like F5 and Coyote Point has DNS loaded switches/load balancers that have geographic distribution... you of course need multiple units on each end for redundancy.. it gets expensive... but they are cheap on Ebay... From the disk end... I believe you can easily map a remote drive via Windows.. based on IP with proper permissions.. once you do that, you can run one of the may mirror packages to push the flat files into synchronization.. ideally, one is the master and one is the servant... Folks like EMC offer addon software (20-40k) for their Symmetrix system that allows such... but mapping and lowly software likely will cut it for you.. or an FTP client with duplication feature set... From the database side... SQL Server 7 + has some transaction stuff... I don't use such.. but mature databases will have distribution facilities... Oracle and MySQl also have a good set of tools to accommodate...be sure to buy some aspirin before you start...getting it to work and synching seamlessly is another feat... Those are the pieces... With the multiples and DNS stuff, you also can get full usage of all gear versus having unused gear that isn't regularly tested and operational online... highly recommend doing it that way.. otherwise when something happens you might be embarrassed. -paris -Original Message- From: Michael Ross [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 17:50 To: CF-Talk Subject: Re: Geographical dispersion See if you can find a hosting company that does load balancing..M aybe try co-locating 2 servers in different places with Windows 2000 server to load balance..or find someone that has a hardware load balancer.without the client actually having their own physical lo cation/network available it may be difficult [EMAIL PROTECTED] 01/24/02 09:10PM Hi! We have a client who needs their ColdFusion site mirrored geograph ically. They need it so that if Seattle gets hit with an earthquake (since we are out of the Seattle area), the mirrored site in Chicago (for example) will automatically pick up without any site outage. I am not familiar wit h all the details of how mirroring works, but the hosting companies I have talked to so far cannot offer this service... they say that mirroring it in the same rack is not a problem, but mirroring across the country poses so me kind of problem. Is there a hosting company that anyone knows of that can take care of this situation? We actually have two applications for a solu tion to this problem. We have this new site that needs to be hosted and mirr ored, but we also have a Linux server in a data center here that needs to b e mirrored somewhere else in the country also (with auto switch over). I thought Akamai would be a solution, but the rep from there said that they do only hit dispersion, but not actual content and site mirroring. Any ideas? Sorry if some of the terminology is off...kind of over my head here.. :) Thanks, Christine [EMAIL PROTECTED] _ _ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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 __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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
OT: Quick JS Question..
Ok.. Again for you JS gurus.. If I'm doing an auto-fill on a field on a form, based on the input already in another form (then onblur'd to trigger the auto-fill) and I want the first letter in the auto-filled field to be upper-case, and the rest lower, what's the function/event to make that work? I have this now, and it works fine.. But I need the domain name to be upper-case on the first letter only... function autoFills() { if( document.domainrecord.domainname.value != '' ) { document.domainrecord.hostdesc.value = (Type) + document.domainrecord.domainname.value; return true; } } Figured one of you prolly has a 2 second fix for this. TTAIA Lee __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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: (ot) SOLVED -- SQL Brain Fart
A true brain fart ... the problem wasn't with the query ... it was with the output ... I had specified a query name in my CFOutput tag, which was already running within a CFLoop. Doh! H. Howard Owens Internet Operations Coordinator www.insidevc.com [EMAIL PROTECTED] AIM: GoCatGo1956 __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: Geographical dispersion
Akami in part does that... they are good for large files like media I don't believe their service is really mirroring or at least applicable in regards to the need for redundancy of a site they are more of a means of distribution... I could be totally off base here.. as I have only listened to an old pitch of there's and never actually directly used their product... Given that a site were completely flat filed, I would thing certainly they could do it for you.. on the dynamic sites, no way... -paris -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 19:03 To: CF-Talk Subject: RE: Geographical dispersion Isn't this the type of thing Akami does?? Hope I got the name right. If I'm remebering right, they mirror a website to multiple geographic locations, and requests for the site are served by the location closest to them (thus improving speed). Shawn Grover -Original Message- From: Paris Lundis [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 4:41 PM To: CF-Talk Subject: RE: Geographical dispersion well a solution will be elegant and certainly complex... I forgot expensive as well... client should be deep pocketed.. whether you do it yourself or opt for proven products... it take enough work to call it a skill.. hopefully others will chime in on this topic. First, outsource your DNS... someplace you have the ability to dynamically update your IP info via the web when you need to live time... See Enom.com service... plug in your multiple locations separate Nameservers.. be sure to register those initially as nameservers with INternic... From the switching layer, companies like F5 and Coyote Point has DNS loaded switches/load balancers that have geographic distribution... you of course need multiple units on each end for redundancy.. it gets expensive... but they are cheap on Ebay... From the disk end... I believe you can easily map a remote drive via Windows.. based on IP with proper permissions.. once you do that, you can run one of the may mirror packages to push the flat files into synchronization.. ideally, one is the master and one is the servant... Folks like EMC offer addon software (20-40k) for their Symmetrix system that allows such... but mapping and lowly software likely will cut it for you.. or an FTP client with duplication feature set... From the database side... SQL Server 7 + has some transaction stuff... I don't use such.. but mature databases will have distribution facilities... Oracle and MySQl also have a good set of tools to accommodate...be sure to buy some aspirin before you start...getting it to work and synching seamlessly is another feat... Those are the pieces... With the multiples and DNS stuff, you also can get full usage of all gear versus having unused gear that isn't regularly tested and operational online... highly recommend doing it that way.. otherwise when something happens you might be embarrassed. -paris -Original Message- From: Michael Ross [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 17:50 To: CF-Talk Subject: Re: Geographical dispersion See if you can find a hosting company that does load balancing..M aybe try co-locating 2 servers in different places with Windows 2000 server to load balance..or find someone that has a hardware load balancer.without the client actually having their own physical lo cation/network available it may be difficult [EMAIL PROTECTED] 01/24/02 09:10PM Hi! We have a client who needs their ColdFusion site mirrored geograph ically. They need it so that if Seattle gets hit with an earthquake (since we are out of the Seattle area), the mirrored site in Chicago (for example) will automatically pick up without any site outage. I am not familiar wit h all the details of how mirroring works, but the hosting companies I have talked to so far cannot offer this service... they say that mirroring it in the same rack is not a problem, but mirroring across the country poses so me kind of problem. Is there a hosting company that anyone knows of that can take care of this situation? We actually have two applications for a solu tion to this problem. We have this new site that needs to be hosted and mirr ored, but we also have a Linux server in a data center here that needs to b e mirrored somewhere else in the country also (with auto switch over). I thought Akamai would be a solution, but the rep from there said that they do only hit dispersion, but not actual content and site mirroring. Any ideas? Sorry if some of the terminology is off...kind of over my head here.. :) Thanks, Christine [EMAIL PROTECTED] _ _ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: