Re: DSN-less connection to a CSV file?
Quick and dirty fix is to open the file using CFFILE then replace all of the LFs with CRLFs... then save the file. I've done this in the past without any problem. You will also want to make sure that there are no LFs anywhere that there shouldn't be... -Novak - Original Message - From: Michael Kear [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, October 28, 2002 11:17 PM Subject: RE: DSN-less connection to a CSV file? Well I have the CFX_CSVtoQuery tag, I've installed it, and I can read in comma delimited text files but not these CSV files I needed to use in the first place. It reads the file but says zero rows processed. When I open the .csv file in my trusty UltraEdit, it asks if I want to convert it to DOS format, so I took a look at the .csv file in hex and the line endings only have 0A not 0D 0A. (in other words a line feed, not carriage return line feed) So I think the tag only recognises the file as a single line. Anyone know what I can do about this? I can't have the information supplier make any change to the files - its' created automatically and FTP'd into our site anew every day. Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks IF you're interested here's some extra data - the first few lines of one of the files concerned (can't post more for copyright reasons), plus the code I'm trying to use to access it. First the file: Cash Management Accounts - $1,000.00 Institution Name,Account/Product Name,Effective Rate,Nominal Rate,Website Link,Customer Service Phone Institution Number One,Youbeauty Account,4.8025,4.70,http://www.institutionone.com.au,1800-666-666; Institution number two,Cash Management Account,4.3337,4.25,http://www.institutiontwo.com.au,1800-555-555; Now the code: CFSET CSV_StartRow = 2 CFX_CSVToQuery FILE=C:\Inetpub\wwwroot\testdir\td6m20k.csv NAME=MyQuery ROWNUMBERS=LineNum MAXROWS=15 STARTROW=#CSV_StartRow# LONGROWSARE=BAD ONBADROW=SKIP CFOUTPUT PRows Read: #CSV_RowsProcessed#BR Bad Rows: #CSV_BadRows#BR ReachedEOF: #CSV_ReachedEOF#BR StartRow: #CSV_StartRow#BR /CFOUTPUT cfdump var=# MyQuery # And this results in a page that shows the following: Rows Read: 0 Bad Rows: ReachedEOF: YES StartRow: 1 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: DSN-less connection to a CSV file?
Thanks but everything has to happen daily and fully automatically. How do I do that in CF? Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -Original Message- From: [EMAIL PROTECTED] [mailto:cf-talk;linenoize.com] Sent: Tuesday, 29 October 2002 7:13 PM To: CF-Talk Subject: Re: DSN-less connection to a CSV file? Quick and dirty fix is to open the file using CFFILE then replace all of the LFs with CRLFs... then save the file. I've done this in the past without any problem. You will also want to make sure that there are no LFs anywhere that there shouldn't be... -Novak - Original Message - From: Michael Kear [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, October 28, 2002 11:17 PM Subject: RE: DSN-less connection to a CSV file? Well I have the CFX_CSVtoQuery tag, I've installed it, and I can read in comma delimited text files but not these CSV files I needed to use in the first place. It reads the file but says zero rows processed. When I open the .csv file in my trusty UltraEdit, it asks if I want to convert it to DOS format, so I took a look at the .csv file in hex and the line endings only have 0A not 0D 0A. (in other words a line feed, not carriage return line feed) So I think the tag only recognises the file as a single line. Anyone know what I can do about this? I can't have the information supplier make any change to the files - its' created automatically and FTP'd into our site anew every day. Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks IF you're interested here's some extra data - the first few lines of one of the files concerned (can't post more for copyright reasons), plus the code I'm trying to use to access it. First the file: Cash Management Accounts - $1,000.00 Institution Name,Account/Product Name,Effective Rate,Nominal Rate,Website Link,Customer Service Phone Institution Number One,Youbeauty Account,4.8025,4.70,http://www.institutionone.com.au,1800-666-666; Institution number two,Cash Management Account,4.3337,4.25,http://www.institutiontwo.com.au,1800-555-555; Now the code: CFSET CSV_StartRow = 2 CFX_CSVToQuery FILE=C:\Inetpub\wwwroot\testdir\td6m20k.csv NAME=MyQuery ROWNUMBERS=LineNum MAXROWS=15 STARTROW=#CSV_StartRow# LONGROWSARE=BAD ONBADROW=SKIP CFOUTPUT PRows Read: #CSV_RowsProcessed#BR Bad Rows: #CSV_BadRows#BR ReachedEOF: #CSV_ReachedEOF#BR StartRow: #CSV_StartRow#BR /CFOUTPUT cfdump var=# MyQuery # And this results in a page that shows the following: Rows Read: 0 Bad Rows: ReachedEOF: YES StartRow: 1 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Verity and PDF
I've developed something to this effect. What you need to do is use the acrobat service that converts pdf to html, store this somewhere, then manipulate that html file and give them the option of viewing the first instance of the search term. Adam -Original Message- From: Trey Rouse [mailto:trouse;rice.edu] Sent: 28 October 2002 23:16 To: CF-Talk Subject: RE: Verity and PDF Afraid not. The full verity server has some help for this, but they handle it by converting the pdf to html. Other than that, you have to use the built in PDF search. Trey -Original Message- From: charlie griefer [mailto:charlie;griefer.com] Sent: Friday, October 25, 2002 1:10 PM To: CF-Talk Subject: Verity and PDF Hey All: Using CF 5 and indexing a directory that contains a mix of htm and pdf files. Everything seems to be going ok, as far as successfully indexing the collection, and searching... but (don't laugh, everybody's got one)... if the search term is found in a particular pdf, and I click the link...it takes me to the first page of the pdf (which can be potentially 100 pages), meaning i've just got to use the Acrobat search tool. Is there something that i've overlooked, or a tweak that i can perform, to get pdf files to return the page within the pdf that contains the search criteria? TIA, charlie ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Limit to SQL IN statement?
A little late on the reply. Just imagine this is how long it takes for me to go through all these emails on CF-Talk list. From what I understand, ANSI SQL 'IN' operator has no limitations. However, a check with developer suggested that we keep to about 5000 items in the list. He too was updating a list and found out that after a certain list of 5000, the cfquery will abort. Might want to try out stored procedures. Ant -Original Message- From: [EMAIL PROTECTED] [mailto:cf-talk;linenoize.com] Sent: Thursday, October 10, 2002 4:04 AM To: CF-Talk Subject: SOT: Limit to SQL IN statement? Perhaps someone on this list knows the answer. Here's the setup: CFMX MS SQL 2000 To make a long story short I'm fixing up a client's application and I would probably have written a lot of it differently but that's beside the point. I'm currently looking at a piece of code which uses the IN clause to update a comma delimited list of records. My concern is... what if there are 1000, 5000, or even 1 records that need updating? Is there a limit as to how many elements can be in the list? For example: UPDATE CLIENTS SET LAST_UPDATED = #Now()# WHERE CLIENT_ID IN (746,1093,83748,238,9484,948,635,8474,etc, etc, etc) How many elements is too many? Any ideas? -Novak ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: OT Tracking a CFMX bug
On Monday, October 28, 2002, at 07:57 PM, Sean A Corfield wrote: You're using 1.4.1 developer preview? If I were, I'd be under NDA, and would not be able to discuss it! CFMX doesn't work with that it seems. Not according to what I've heard! But, this is a more global question -- I have identified a problem on a non-supported platform OS X. It could well apply to supported platforms. I want to report that problem to MM as concisely as possible to help get it fixed -- I have no standing to submit an official bug report. What I am looking for is how to identify where (which CFMX module or process) the problem is occurring. If I can do this, there is an improved chance that the bug (if any) will get fixed, to the benefit of all! Dick On Monday, Oct 28, 2002, at 14:11 US/Pacific, Dick Applebaum wrote: I have a situation where i create and save a simple cfm template, then access it with a browser The following takes place: 1) the template is parsed 2) the Java source is generated 3) the .java file is saved. 4) I get an error before the.class file is saved The error is below -- just a single line stack trace. The question: How do I determine what portion of CFMX is in control when the error occurs? TIA Dick The Error: Error occurred while processing request! Please try the following: *Check the CFML Reference Manual to verify that you are using the correct syntax. *Search the Knowledge Base to find a solution to your problem. BrowserÜÜMozilla/4.0 (compatible; MSIE 5.22; Mac_PowerPC) Remote AddressÜÜ 127.0.0.1 ReferrerÜÜ http://127.0.0.1:8500/mycfmxapps/ Date/TimeÜÜ 28-Oct-02 02:05 PM Stack Trace (click to expand) [Ljava.lang.StackTraceElement;c127d ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: [OT] FlashCom Server High CPU Utilization
Anthony Wong wrote: opps .. i need to add something. This high utilization only occurs when i connect my webcam to the flash comm server. Else, it's working fine even with the chat. I think this issue is quite different from Joachem's post earlier with regards to chat.asc which had to be re-written. I find patching the communicationcomponents from MM site solves the problem and along you'll get the CommsComponent for FlashMX. Someone took away my web cam now and i couldn't test exactly which service that gives me such a high CPU. I reckon it could be FlashCom.exe service. The Community Suite app is now running 2 concurrent streams with 8 clients and some chatting, and CPU usage is about 2%. On the other hand, the people having their webcam hooked up and sending a stream to the server report a CPU usage of more as 50%, and I had IE eat about 75% just watching it (switching to Mozilla solved that). If it happens again, please check which service eats the CPU, considering you don't have the other symptoms I don't expect it to be FlashCom. Jochem -- http://cfmx.oli.tudelft.nl/flashcom/applications/sample_panel_presentation/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: OT Tracking a CFMX bug
More on this; The CFMX logs (below) show that the compile of the ,java source file (generated by CFMX fails). Does CFMX provide its own Java compiler, or does it use the javac compiler provided by Sun. This could be important, as the javac will likely change with each release of Java. Dick java.lang.IncompatibleClassChangeError at coldfusion.jsp.JavaCompiler.inProcessCompile(Unknown Source) at coldfusion.jsp.JavaCompiler.compileClass(Unknown Source) at coldfusion.compiler.NeoTranslator.translateJava(Unknown Source) at coldfusion.compiler.NeoTranslator.translateJava(Unknown Source) at coldfusion.runtime.TemplateClassLoader$1.fetch(Unknown Source) at coldfusion.util.LruCache.get(Unknown Source) at coldfusion.runtime.TemplateClassLoader$TemplateCache.fetchSerial(Unknown Source) at coldfusion.util.AbstractCache.fetch(Unknown Source) at coldfusion.util.SoftCache.get(Unknown Source) at coldfusion.runtime.TemplateClassLoader.findClass(Unknown Source) at coldfusion.filter.PathFilter.invoke(Unknown Source) at coldfusion.filter.LicenseFilter.invoke(Unknown Source) at coldfusion.filter.ExceptionFilter.invoke(Unknown Source) at coldfusion.filter.ClientScopePersistenceFilter.invoke(Unknown Source) at coldfusion.filter.BrowserFilter.invoke(Unknown Source) at coldfusion.filter.GlobalsFilter.invoke(Unknown Source) at coldfusion.filter.DatasourceFilter.invoke(Unknown Source) at coldfusion.CfmServlet.service(Unknown Source) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:241 ) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527 ) at jrun.servlet.http.WebService.invokeRunnable(WebService.java:172) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.j ava:348) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java :451) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.jav a:294) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) On Monday, October 28, 2002, at 02:11 PM, Dick Applebaum wrote: I have a situation where i create and save a simple cfm template, then access it with a browser The following takes place: 1) the template is parsed 2) the Java source is generated 3) the .java file is saved. 4) I get an error before the.class file is saved The error is below -- just a single line stack trace. The question: How do I determine what portion of CFMX is in control when the error occurs? TIA Dick The Error: Error occurred while processing request! Please try the following: * Check the CFML Reference Manual to verify that you are using the correct syntax. * Search the Knowledge Base to find a solution to your problem. Browser Mozilla/4.0 (compatible; MSIE 5.22; Mac_PowerPC) Remote Address 127.0.0.1 Referrerhttp://127.0.0.1:8500/mycfmxapps/ Date/Time 28-Oct-02 02:05 PM Stack Trace (click to expand) [Ljava.lang.StackTraceElement;c127d ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: DSN-less connection to a CSV file?
Well I've been fretting away at this wretched thing for 7 hours now, and I just can't make a query out of my csv files. I've tried cfhttp but that doesn't like having the column names on the second row and doesn't like having spaces in the column names. I downloaded CFX_CSVtoQuery and can't make that do anything but parse .TXT files. It flatly refuses to parse .CSV files. It won't scan any rows. I keep getting zero rows scanned as one of the output variables. I can't make a DSNless connection to the files - that says ERROR all the time and gives no hint as to the reason. When I load the files into my trusty UltraEdit, which WILL read them, it asks if I want to convert them to dos format. I don't know quite what that means, except I'm assuming it's because the file only has HEX0A (Linefeed) at the end of the rows instead of CR/LF.So I have tried using regex and the function REREplace to fix that, and it insists on putting a CR/LF at the top of the file, thereby making sure the column headings are on row 2 and therefore unable to be used by CFHTTP or CFX_CSVtoQUERY. Has anyone ACTUALLY done any of this? If you've forgotten, here's the deal I have an information provider automatically dumping 17 .csv files into my server and I have to read them and manipulate them as queries for my site users to see the data in various ways. It happens automatically and I can't have the files changed. They are deposited every day at 5am and I can't have any manual processing. I have to be able to ensure the files are not locked by the server at 5am (approx) when the provider drops them on my system. If they're locked by the CF Server at that time, the ftp will fail and we wont get the data updated. So, ... how can I get around this?I can't spend much more time trying one thing after another trying to make CF parse these CSV files. In a few hours I'm going to have to say ColdFusion can't do it and give the job to a ASP progammer who also works on the site. Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -Original Message- From: Michael Kear [mailto:mkear;afpwebworks.com] Sent: Tuesday, 29 October 2002 7:02 PM To: CF-Talk Subject: RE: DSN-less connection to a CSV file? Thanks but everything has to happen daily and fully automatically. How do I do that in CF? Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -Original Message- From: [EMAIL PROTECTED] [mailto:cf-talk;linenoize.com] Sent: Tuesday, 29 October 2002 7:13 PM To: CF-Talk Subject: Re: DSN-less connection to a CSV file? Quick and dirty fix is to open the file using CFFILE then replace all of the LFs with CRLFs... then save the file. I've done this in the past without any problem. You will also want to make sure that there are no LFs anywhere that there shouldn't be... -Novak ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: DSN-less connection to a CSV file?
I haven't read the rest of the thread, so forgive me if I'm suggestion something that has already been said, but... How about writing your own parser to deal with this specific format? Use CFFILE to pick up the CSV file and load it into a variable. If you really truely have to have the data as a query, then loop through the variable using an outer and inner loop. The outer loop treats the variable as a list delimited by chr(10) and the inner loop treats the list item from the outer loop as a comma delimited variable. Before your loop, create a new query (QueryNew() and QueryAddColumn() picking up the column headers from the second row of your CSV), inside the outer loop create a new row (QueryAddRow) and then in the inner loop use QuerySetCell to enter the information from your CSV into a row. Hope this helps. Regards Stephen - Original Message - From: Michael Kear [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 11:24 AM Subject: RE: DSN-less connection to a CSV file? Well I've been fretting away at this wretched thing for 7 hours now, and I just can't make a query out of my csv files. I've tried cfhttp but that doesn't like having the column names on the second row and doesn't like having spaces in the column names. I downloaded CFX_CSVtoQuery and can't make that do anything but parse .TXT files. It flatly refuses to parse .CSV files. It won't scan any rows. I keep getting zero rows scanned as one of the output variables. I can't make a DSNless connection to the files - that says ERROR all the time and gives no hint as to the reason. When I load the files into my trusty UltraEdit, which WILL read them, it asks if I want to convert them to dos format. I don't know quite what that means, except I'm assuming it's because the file only has HEX0A (Linefeed) at the end of the rows instead of CR/LF.So I have tried using regex and the function REREplace to fix that, and it insists on putting a CR/LF at the top of the file, thereby making sure the column headings are on row 2 and therefore unable to be used by CFHTTP or CFX_CSVtoQUERY. Has anyone ACTUALLY done any of this? If you've forgotten, here's the deal I have an information provider automatically dumping 17 .csv files into my server and I have to read them and manipulate them as queries for my site users to see the data in various ways. It happens automatically and I can't have the files changed. They are deposited every day at 5am and I can't have any manual processing. I have to be able to ensure the files are not locked by the server at 5am (approx) when the provider drops them on my system. If they're locked by the CF Server at that time, the ftp will fail and we wont get the data updated. So, ... how can I get around this?I can't spend much more time trying one thing after another trying to make CF parse these CSV files. In a few hours I'm going to have to say ColdFusion can't do it and give the job to a ASP progammer who also works on the site. Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -Original Message- From: Michael Kear [mailto:mkear;afpwebworks.com] Sent: Tuesday, 29 October 2002 7:02 PM To: CF-Talk Subject: RE: DSN-less connection to a CSV file? Thanks but everything has to happen daily and fully automatically. How do I do that in CF? Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -Original Message- From: [EMAIL PROTECTED] [mailto:cf-talk;linenoize.com] Sent: Tuesday, 29 October 2002 7:13 PM To: CF-Talk Subject: Re: DSN-less connection to a CSV file? Quick and dirty fix is to open the file using CFFILE then replace all of the LFs with CRLFs... then save the file. I've done this in the past without any problem. You will also want to make sure that there are no LFs anywhere that there shouldn't be... -Novak ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Recipe Application Wanted
Hi, My wife has this paper disaster area of recipes and I'd like to make her an app where she can input them and search, etc. Does anyone know if there are any CF apps (opensource) alrady around that do this? I just don't want to code anything that's already out there! TIA, Rob ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: Recipe Application Wanted
There was a thread about this a while back in CF-Community. I don't know if any work progressed or not. I was interested in an application like this as well, so if you find one, please let me know. - Original Message - From: Robert Shaw [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 8:16 AM Subject: Recipe Application Wanted Hi, My wife has this paper disaster area of recipes and I'd like to make her an app where she can input them and search, etc. Does anyone know if there are any CF apps (opensource) alrady around that do this? I just don't want to code anything that's already out there! TIA, Rob ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Recipe Application Wanted
I dont think so.. so you have a niche...go on, code oneshow here how much you care :-p -Original Message- From: Robert Shaw [mailto:robertshawsjaws;hotmail.com] Sent: 29 October 2002 13:17 To: CF-Talk Subject: Recipe Application Wanted Hi, My wife has this paper disaster area of recipes and I'd like to make her an app where she can input them and search, etc. Does anyone know if there are any CF apps (opensource) alrady around that do this? I just don't want to code anything that's already out there! TIA, Rob ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Recipe Application Wanted
yep, sounds to me like its an easy app to make, simple add/edit/delete functions, maybe some categories, sorting by category/name/ingredients, etcbe the hero for christmas and deliver the killer munchy app ;) ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:Neil.Robertson-Ravo;csd.reedexpo.com] Sent: Tuesday, October 29, 2002 8:20 AM To: CF-Talk Subject: RE: Recipe Application Wanted I dont think so.. so you have a niche...go on, code oneshow here how much you care :-p -Original Message- From: Robert Shaw [mailto:robertshawsjaws;hotmail.com] Sent: 29 October 2002 13:17 To: CF-Talk Subject: Recipe Application Wanted Hi, My wife has this paper disaster area of recipes and I'd like to make her an app where she can input them and search, etc. Does anyone know if there are any CF apps (opensource) alrady around that do this? I just don't want to code anything that's already out there! TIA, Rob ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Recipe Application Wanted
If you have access one of the sample databases is a recipy app Mark Stephenson New Media Director Evolution Internet T: 0870 757 1631 F: 0870 757 1632 W: www.evolutioninternet.co.uk E: [EMAIL PROTECTED] WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. -Original Message- From: Tony Weeg [mailto:tony;navtrak.net] Sent: 29 October 2002 13:43 To: CF-Talk Subject: RE: Recipe Application Wanted yep, sounds to me like its an easy app to make, simple add/edit/delete functions, maybe some categories, sorting by category/name/ingredients, etcbe the hero for christmas and deliver the killer munchy app ;) .tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:Neil.Robertson-Ravo;csd.reedexpo.com] Sent: Tuesday, October 29, 2002 8:20 AM To: CF-Talk Subject: RE: Recipe Application Wanted I dont think so.. so you have a niche...go on, code oneshow here how much you care :-p -Original Message- From: Robert Shaw [mailto:robertshawsjaws;hotmail.com] Sent: 29 October 2002 13:17 To: CF-Talk Subject: Recipe Application Wanted Hi, My wife has this paper disaster area of recipes and I'd like to make her an app where she can input them and search, etc. Does anyone know if there are any CF apps (opensource) alrady around that do this? I just don't want to code anything that's already out there! TIA, Rob ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Recipe Application Wanted
I've got one ... It makes very heavy use of JavaScript, but that shouldn't be too much of a problem. I'm zipping up the code and putting it at: http://www.joshuasmiller.com/recipe.zip I'll put the scripts in for SQL Server also. This is by no means complete, but it's pretty functional so far. If you make enhancements, please send them back! Joshua Miller [EMAIL PROTECTED] -Original Message- From: Robert Shaw [mailto:robertshawsjaws;hotmail.com] Sent: Tuesday, October 29, 2002 8:17 AM To: CF-Talk Subject: Recipe Application Wanted Hi, My wife has this paper disaster area of recipes and I'd like to make her an app where she can input them and search, etc. Does anyone know if there are any CF apps (opensource) alrady around that do this? I just don't want to code anything that's already out there! TIA, Rob ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: Coldfusion Message - Oracle Error Code = 0
Sounds to me like there weren't enough database connections available, and CF timed out while waiting to get a lock (or handle, or thread) to talk to Oracle. Chris Norloff -- Original Message -- from: Gary Groomer [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Mon, 28 Oct 2002 19:45:50 -0800 The company that I am working for, is periodically, bombarded with the following error message: Coldfusion Error Type - DATABASE Coldfusion Message - Oracle Error Code = 0 Timeout while obtaining an Oracle connection lock They are running CF 5 with Oracle 8i on the backend and are using the native drivers to connect to Oracle. I have searched high and low, but have not been able to find a definitive solution. Has anyone run into this error and found a solution? Gary Groomer ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: Recipe Application Wanted
Thanks for all of the input guys, I'll take a look at Joshua's app and if I make any mods I'll be sure to send them on. Rob From: SMR [EMAIL PROTECTED] To: [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: Recipe Application Wanted Date: Tue, 29 Oct 2002 08:22:37 -0500 There was a thread about this a while back in CF-Community. I don't know if any work progressed or not. I was interested in an application like this as well, so if you find one, please let me know. - Original Message - From: Robert Shaw [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 8:16 AM Subject: Recipe Application Wanted Hi, My wife has this paper disaster area of recipes and I'd like to make her an app where she can input them and search, etc. Does anyone know if there are any CF apps (opensource) alrady around that do this? I just don't want to code anything that's already out there! TIA, Rob ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Recipe Application Wanted
It's up now ... Let me know if you need any more information, but it should probably be off-list. Joshua Miller [EMAIL PROTECTED] -Original Message- From: Robert Shaw [mailto:robertshawsjaws;hotmail.com] Sent: Tuesday, October 29, 2002 9:28 AM To: CF-Talk Subject: Re: Recipe Application Wanted Thanks for all of the input guys, I'll take a look at Joshua's app and if I make any mods I'll be sure to send them on. Rob From: SMR [EMAIL PROTECTED] To: [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: Recipe Application Wanted Date: Tue, 29 Oct 2002 08:22:37 -0500 There was a thread about this a while back in CF-Community. I don't know if any work progressed or not. I was interested in an application like this as well, so if you find one, please let me know. - Original Message - From: Robert Shaw [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 8:16 AM Subject: Recipe Application Wanted Hi, My wife has this paper disaster area of recipes and I'd like to make her an app where she can input them and search, etc. Does anyone know if there are any CF apps (opensource) alrady around that do this? I just don't want to code anything that's already out there! TIA, Rob ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: [OT] FlashCom Server High CPU Utilization
what do you mean by running off the browser? are you talking about the admin interface? if so, the admin can be CPU intensive at times. mike chambers [EMAIL PROTECTED] -Original Message- From: Anthony Wong [mailto:anthony;intracomm.com] Sent: Monday, October 28, 2002 10:23 PM To: CF-Talk Subject: [OT] FlashCom Server High CPU Utilization Importance: High I'm trying out Flash Comm on my laptop and noticed that the CPU utilization level stays above 95% average all the time when the app is running off the browser. Might have occasional dip but it didn't last for long as it shoots up right away. When the browser is closed, the CPU simply goes back to normal (1-3%) Here's my config: Pentium III 500 Windows 2000 IE 5.5 SP2 256 MB RAM (I read that's the minimum for Flash Comm) CFMX server service is off Anyone else experianced the same thing? It's burning my laptop too. I can feel the heat through the keyboard while running the flash comm app even for a short period of time. anthony ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
OT: RE: Recipe Application Wanted
Josh, does it come with recipes built in ? ;-) Kola -Original Message- From: Joshua Miller [mailto:josh;joshuasmiller.com] Sent: 29 October 2002 14:07 To: CF-Talk Subject: RE: Recipe Application Wanted I've got one ... It makes very heavy use of JavaScript, but that shouldn't be too much of a problem. I'm zipping up the code and putting it at: http://www.joshuasmiller.com/recipe.zip I'll put the scripts in for SQL Server also. This is by no means complete, but it's pretty functional so far. If you make enhancements, please send them back! Joshua Miller [EMAIL PROTECTED] -Original Message- From: Robert Shaw [mailto:robertshawsjaws;hotmail.com] Sent: Tuesday, October 29, 2002 8:17 AM To: CF-Talk Subject: Recipe Application Wanted Hi, My wife has this paper disaster area of recipes and I'd like to make her an app where she can input them and search, etc. Does anyone know if there are any CF apps (opensource) alrady around that do this? I just don't want to code anything that's already out there! TIA, Rob ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Protecting NON-CF Files with CF
We have to protect an entire directory and it's subdirectories with CF. We'd like to use CF to process our logins.. but can't have people directly linking to JPGs and MPGs etc under neath.. since CF can't really protect these individual files unless called through a CFM page, we've run into a problem. How can we accomplish this? We DO own a copy of AuthentiX and unfortunately CFContent is not a viable solution. This site will have upwards of 12,000 simultaneous users and CFContent has too much overheard. Thank you! JLH ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Protecting NON-CF Files with CF
Then the simple answer is you can't do it. The web server is responsible for getting images, so unless you figure out some way to display images without using the webserver you're up s**t's creek for a full CF solution. You could prob use IIS's integrated security, but then you would need logins for each user. I see cfcontent as your only viable solution. There are many people using it in production, have you done some testing to make sure that it can't handle that load? What about CFMX? Maybe your issues are fixed in that release. Robert Everland III Web Developer Extraordinaire Dixon Ticonderoga Company http://www.dixonusa.com -Original Message- From: JLH All Turbo [mailto:jacob;allturbo.com] Sent: Tuesday, October 29, 2002 9:53 AM To: CF-Talk Subject: Protecting NON-CF Files with CF We have to protect an entire directory and it's subdirectories with CF. We'd like to use CF to process our logins.. but can't have people directly linking to JPGs and MPGs etc under neath.. since CF can't really protect these individual files unless called through a CFM page, we've run into a problem. How can we accomplish this? We DO own a copy of AuthentiX and unfortunately CFContent is not a viable solution. This site will have upwards of 12,000 simultaneous users and CFContent has too much overheard. Thank you! JLH ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Check this URL parameters out peoples
cfset Parameters = Emailaddress=#URLEncodedFormat(EmailAddress)#PopServer=#URLEncodedForm at(PopServer)#SMTPServer=#URLEncodedFormat(SMTPServer)#username=#URLEn codedFormat(username)#Password=#URLEncodedFormat(Encrypt(Password,815)) # Should it be like this preceding application. With the servers(pop smtp) cfset Parameters = Emailaddress=#URLEncodedFormat(EmailAddress)#application.PopServer=#UR LEncodedFormat(application.PopServer)#application.SMTPServer=#URLEncode dFormat(application.SMTPServer)#username=#URLEncodedFormat(username)#P assword=#URLEncodedFormat(Encrypt(Password,815))# Any help with the right way? Kodjo ackah Principal Consultant concrete-media.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: Protecting NON-CF Files with CF
Look into cfcontent. In short, basically, hide the files in a non-web accessible directory and then use cfcontent in a CF page to deliver the file to the user. At 09:53 AM 10/29/2002 -0500, you wrote: We have to protect an entire directory and it's subdirectories with CF. We'd like to use CF to process our logins.. but can't have people directly linking to JPGs and MPGs etc under neath.. since CF can't really protect these individual files unless called through a CFM page, we've run into a problem. How can we accomplish this? We DO own a copy of AuthentiX and unfortunately CFContent is not a viable solution. This site will have upwards of 12,000 simultaneous users and CFContent has too much overheard. Thank you! JLH ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Protecting NON-CF Files with CF
Doh... I missed the cfcontent remark from my previous post. You could write some code that would temporary copy the files from a non-web accessible directory to a web accessible directory when people request them. Use a scheduled task to clean out the web accessible directory every half hour or so. That seems like a not ideal solution, but it might work. At 09:56 AM 10/29/2002 -0500, you wrote: Then the simple answer is you can't do it. The web server is responsible for getting images, so unless you figure out some way to display images without using the webserver you're up s**t's creek for a full CF solution. You could prob use IIS's integrated security, but then you would need logins for each user. I see cfcontent as your only viable solution. There are many people using it in production, have you done some testing to make sure that it can't handle that load? What about CFMX? Maybe your issues are fixed in that release. Robert Everland III Web Developer Extraordinaire Dixon Ticonderoga Company http://www.dixonusa.com -Original Message- From: JLH All Turbo [mailto:jacob;allturbo.com] Sent: Tuesday, October 29, 2002 9:53 AM To: CF-Talk Subject: Protecting NON-CF Files with CF We have to protect an entire directory and it's subdirectories with CF. We'd like to use CF to process our logins.. but can't have people directly linking to JPGs and MPGs etc under neath.. since CF can't really protect these individual files unless called through a CFM page, we've run into a problem. How can we accomplish this? We DO own a copy of AuthentiX and unfortunately CFContent is not a viable solution. This site will have upwards of 12,000 simultaneous users and CFContent has too much overheard. Thank you! JLH ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: Protecting NON-CF Files with CF
I was trying that with cfcontent and it's just destroying the server. coolfusion.com had a solution for me, they had an iauth tag that would take a yes or no from cf and pass a generic l/p to windows if yes and would just shut down if no. but it stopped working. so i'm looking for other solutions. j - Original Message - From: Jeffry Houser [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 10:00 AM Subject: Re: Protecting NON-CF Files with CF Look into cfcontent. In short, basically, hide the files in a non-web accessible directory and then use cfcontent in a CF page to deliver the file to the user. At 09:53 AM 10/29/2002 -0500, you wrote: We have to protect an entire directory and it's subdirectories with CF. We'd like to use CF to process our logins.. but can't have people directly linking to JPGs and MPGs etc under neath.. since CF can't really protect these individual files unless called through a CFM page, we've run into a problem. How can we accomplish this? We DO own a copy of AuthentiX and unfortunately CFContent is not a viable solution. This site will have upwards of 12,000 simultaneous users and CFContent has too much overheard. Thank you! JLH ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Check this URL parameters out peoples
You only need application. Preceeding if you want to use application variables. You don't have to use application variables, you will also be opening a can of worms with locking and such. Robert Everland III Web Developer Extraordinaire Dixon Ticonderoga Company http://www.dixonusa.com -Original Message- From: Kodjo Ackah [mailto:kodjo;concrete-media.com] Sent: Tuesday, October 29, 2002 9:57 AM To: CF-Talk Subject: Check this URL parameters out peoples cfset Parameters = Emailaddress=#URLEncodedFormat(EmailAddress)#PopServer=#URLEncodedForm at(PopServer)#SMTPServer=#URLEncodedFormat(SMTPServer)#username=#URLEn codedFormat(username)#Password=#URLEncodedFormat(Encrypt(Password,815)) # Should it be like this preceding application. With the servers(pop smtp) cfset Parameters = Emailaddress=#URLEncodedFormat(EmailAddress)#application.PopServer=#UR LEncodedFormat(application.PopServer)#application.SMTPServer=#URLEncode dFormat(application.SMTPServer)#username=#URLEncodedFormat(username)#P assword=#URLEncodedFormat(Encrypt(Password,815))# Any help with the right way? Kodjo ackah Principal Consultant concrete-media.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: Protecting NON-CF Files with CF
How about giving users direct access to a reduced size image with a water mark in them and then when they purchase an image (I'm assuming that if you're protecting your images because you're selling them) use CFCONTENT to push the real image to the user. The overhead of using CFCONTENT is reduced drastically this way. Otherwise, you need to look at rewrite rules in apache (I believe there is some kind of plug-in for IIS that allows you to do rewrite rules in IIS). Use the rewrite rules to check to see if an image is being accessed via your pages and if its not redirect the offending person back to your home page r the disney homepage, depending on how cruel you're feeling. ;o) Regards Stephen - Original Message - From: JLH All Turbo [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 2:53 PM Subject: Protecting NON-CF Files with CF We have to protect an entire directory and it's subdirectories with CF. We'd like to use CF to process our logins.. but can't have people directly linking to JPGs and MPGs etc under neath.. since CF can't really protect these individual files unless called through a CFM page, we've run into a problem. How can we accomplish this? We DO own a copy of AuthentiX and unfortunately CFContent is not a viable solution. This site will have upwards of 12,000 simultaneous users and CFContent has too much overheard. Thank you! JLH ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: Protecting NON-CF Files with CF
Well we have to protect all the files. JPGs, .MOVs, .MPGs.. everything basically. We're not just selling access to images. :-) J - Original Message - From: Stephen Moretti [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 10:18 AM Subject: Re: Protecting NON-CF Files with CF How about giving users direct access to a reduced size image with a water mark in them and then when they purchase an image (I'm assuming that if you're protecting your images because you're selling them) use CFCONTENT to push the real image to the user. The overhead of using CFCONTENT is reduced drastically this way. Otherwise, you need to look at rewrite rules in apache (I believe there is some kind of plug-in for IIS that allows you to do rewrite rules in IIS). Use the rewrite rules to check to see if an image is being accessed via your pages and if its not redirect the offending person back to your home page r the disney homepage, depending on how cruel you're feeling. ;o) Regards Stephen - Original Message - From: JLH All Turbo [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 2:53 PM Subject: Protecting NON-CF Files with CF We have to protect an entire directory and it's subdirectories with CF. We'd like to use CF to process our logins.. but can't have people directly linking to JPGs and MPGs etc under neath.. since CF can't really protect these individual files unless called through a CFM page, we've run into a problem. How can we accomplish this? We DO own a copy of AuthentiX and unfortunately CFContent is not a viable solution. This site will have upwards of 12,000 simultaneous users and CFContent has too much overheard. Thank you! JLH ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: RE: Recipe Application Wanted
Nope, sorry ;) Joshua Miller [EMAIL PROTECTED] -Original Message- From: Kola Oyedeji [mailto:kola.oyedeji;iclployalty.com] Sent: Tuesday, October 29, 2002 9:43 AM To: CF-Talk Subject: OT: RE: Recipe Application Wanted Josh, does it come with recipes built in ? ;-) Kola -Original Message- From: Joshua Miller [mailto:josh;joshuasmiller.com] Sent: 29 October 2002 14:07 To: CF-Talk Subject: RE: Recipe Application Wanted I've got one ... It makes very heavy use of JavaScript, but that shouldn't be too much of a problem. I'm zipping up the code and putting it at: http://www.joshuasmiller.com/recipe.zip I'll put the scripts in for SQL Server also. This is by no means complete, but it's pretty functional so far. If you make enhancements, please send them back! Joshua Miller [EMAIL PROTECTED] -Original Message- From: Robert Shaw [mailto:robertshawsjaws;hotmail.com] Sent: Tuesday, October 29, 2002 8:17 AM To: CF-Talk Subject: Recipe Application Wanted Hi, My wife has this paper disaster area of recipes and I'd like to make her an app where she can input them and search, etc. Does anyone know if there are any CF apps (opensource) alrady around that do this? I just don't want to code anything that's already out there! TIA, Rob ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
HTML Tricks
In our website I am making heavy use of divs to place tables anywhere I want, the issue I have with this is that now when cf debugging is added it just sort of goes underneath some of the tables. Does anyone have a fix that I could do real quick with HTML. Robert Everland III Web Developer Extraordinaire Dixon Ticonderoga Company http://www.dixonusa.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: HTML Tricks
place the dump tag on a layer which has a higher z-axis than the rest... -Original Message- From: Robert Everland [mailto:REverland;dixonusa.com] Sent: 29 October 2002 15:20 To: CF-Talk Subject: HTML Tricks In our website I am making heavy use of divs to place tables anywhere I want, the issue I have with this is that now when cf debugging is added it just sort of goes underneath some of the tables. Does anyone have a fix that I could do real quick with HTML. Robert Everland III Web Developer Extraordinaire Dixon Ticonderoga Company http://www.dixonusa.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Protecting NON-CF Files with CF
Hi, The problem with cfcontent is that it uses one CF thread per download... So if you have several users downloading large files from you server at the same time, your server will be quickly down (all the CF threads will be taken one by one by the downloads). Most of big download sites use another technique, it seems that they check the authentication through a dynamic page and return a download info page, the download is then fired by a javascript on the client side (so the download is handled by the web server, not the application server). But I still wonder how they handle the security access from the javascript call... Benoit Hediard www.benorama.com -Message d'origine- De : JLH All Turbo [mailto:jacob;allturbo.com] Envoyé : mardi 29 octobre 2002 16:06 À : CF-Talk Objet : Re: Protecting NON-CF Files with CF I was trying that with cfcontent and it's just destroying the server. coolfusion.com had a solution for me, they had an iauth tag that would take a yes or no from cf and pass a generic l/p to windows if yes and would just shut down if no. but it stopped working. so i'm looking for other solutions. j - Original Message - From: Jeffry Houser [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 10:00 AM Subject: Re: Protecting NON-CF Files with CF Look into cfcontent. In short, basically, hide the files in a non-web accessible directory and then use cfcontent in a CF page to deliver the file to the user. At 09:53 AM 10/29/2002 -0500, you wrote: We have to protect an entire directory and it's subdirectories with CF. We'd like to use CF to process our logins.. but can't have people directly linking to JPGs and MPGs etc under neath.. since CF can't really protect these individual files unless called through a CFM page, we've run into a problem. How can we accomplish this? We DO own a copy of AuthentiX and unfortunately CFContent is not a viable solution. This site will have upwards of 12,000 simultaneous users and CFContent has too much overheard. Thank you! JLH ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: HTML Tricks
In our website I am making heavy use of divs to place tables anywhere I want, the issue I have with this is that now when cf debugging is added it just sort of goes underneath some of the tables. Does anyone have a fix that I could do real quick with HTML. If you're using CFMX and you have your own server with access to the administrator, you can have the debugging output put into another window (it's in the debugging settings). Scott Scott Brady http://www.scottbrady.net/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: HTML Tricks
How do I do that, I am using CF5, to my knowledge it always just outputs it on the page, there is no user actions. Robert Everland III Web Developer Extraordinaire Dixon Ticonderoga Company http://www.dixonusa.com -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:Neil.Robertson-Ravo;csd.reedexpo.com] Sent: Tuesday, October 29, 2002 10:26 AM To: CF-Talk Subject: RE: HTML Tricks place the dump tag on a layer which has a higher z-axis than the rest... -Original Message- From: Robert Everland [mailto:REverland;dixonusa.com] Sent: 29 October 2002 15:20 To: CF-Talk Subject: HTML Tricks In our website I am making heavy use of divs to place tables anywhere I want, the issue I have with this is that now when cf debugging is added it just sort of goes underneath some of the tables. Does anyone have a fix that I could do real quick with HTML. Robert Everland III Web Developer Extraordinaire Dixon Ticonderoga Company http://www.dixonusa.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Check this URL parameters out peoples
Should I just go on and use my smtp and pop server which is: mailhost.zen.co.uk. Given this information how will you alter the url parameters? Can you demonstrate this to me? Kodjo ackah Principal Consultant concrete-media.com -Original Message- From: Robert Everland [mailto:REverland;dixonusa.com] Sent: 29 October 2002 15:04 To: CF-Talk Subject: RE: Check this URL parameters out peoples You only need application. Preceeding if you want to use application variables. You don't have to use application variables, you will also be opening a can of worms with locking and such. Robert Everland III Web Developer Extraordinaire Dixon Ticonderoga Company http://www.dixonusa.com -Original Message- From: Kodjo Ackah [mailto:kodjo;concrete-media.com] Sent: Tuesday, October 29, 2002 9:57 AM To: CF-Talk Subject: Check this URL parameters out peoples cfset Parameters = Emailaddress=#URLEncodedFormat(EmailAddress)#PopServer=#URLEncodedForm at(PopServer)#SMTPServer=#URLEncodedFormat(SMTPServer)#username=#URLEn codedFormat(username)#Password=#URLEncodedFormat(Encrypt(Password,815)) # Should it be like this preceding application. With the servers(pop smtp) cfset Parameters = Emailaddress=#URLEncodedFormat(EmailAddress)#application.PopServer=#UR LEncodedFormat(application.PopServer)#application.SMTPServer=#URLEncode dFormat(application.SMTPServer)#username=#URLEncodedFormat(username)#P assword=#URLEncodedFormat(Encrypt(Password,815))# Any help with the right way? Kodjo ackah Principal Consultant concrete-media.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: HTML Tricks
could you use the CF's error handling tag? Use custom error pages? Mark Stephenson New Media Director Evolution Internet T: 0870 757 1631 F: 0870 757 1632 W: www.evolutioninternet.co.uk E: [EMAIL PROTECTED] WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. -Original Message- From: Robert Everland [mailto:REverland;dixonusa.com] Sent: 29 October 2002 15:33 To: CF-Talk Subject: RE: HTML Tricks How do I do that, I am using CF5, to my knowledge it always just outputs it on the page, there is no user actions. Robert Everland III Web Developer Extraordinaire Dixon Ticonderoga Company http://www.dixonusa.com -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:Neil.Robertson-Ravo;csd.reedexpo.com] Sent: Tuesday, October 29, 2002 10:26 AM To: CF-Talk Subject: RE: HTML Tricks place the dump tag on a layer which has a higher z-axis than the rest... -Original Message- From: Robert Everland [mailto:REverland;dixonusa.com] Sent: 29 October 2002 15:20 To: CF-Talk Subject: HTML Tricks In our website I am making heavy use of divs to place tables anywhere I want, the issue I have with this is that now when cf debugging is added it just sort of goes underneath some of the tables. Does anyone have a fix that I could do real quick with HTML. Robert Everland III Web Developer Extraordinaire Dixon Ticonderoga Company http://www.dixonusa.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: HTML Tricks
FYI this should do it : div id=cfdebugger style=position:absolute; width:200px; height:115px; z-index:1; visibility: visible;cfdump var=#session#/div NOTE : depending on your z-axis/index, i cant remember if it works as 1 on top or the the greatest number? :-) but that should output on top of everything else. -Original Message- From: Robert Everland [mailto:REverland;dixonusa.com] Sent: 29 October 2002 15:33 To: CF-Talk Subject: RE: HTML Tricks How do I do that, I am using CF5, to my knowledge it always just outputs it on the page, there is no user actions. Robert Everland III Web Developer Extraordinaire Dixon Ticonderoga Company http://www.dixonusa.com -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:Neil.Robertson-Ravo;csd.reedexpo.com] Sent: Tuesday, October 29, 2002 10:26 AM To: CF-Talk Subject: RE: HTML Tricks place the dump tag on a layer which has a higher z-axis than the rest... -Original Message- From: Robert Everland [mailto:REverland;dixonusa.com] Sent: 29 October 2002 15:20 To: CF-Talk Subject: HTML Tricks In our website I am making heavy use of divs to place tables anywhere I want, the issue I have with this is that now when cf debugging is added it just sort of goes underneath some of the tables. Does anyone have a fix that I could do real quick with HTML. Robert Everland III Web Developer Extraordinaire Dixon Ticonderoga Company http://www.dixonusa.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Your thoughts on a project
I have the opportunity to develop a database project on the side. The customers will be uploading and indexing graphic files (invoices, shipping etc). Also a lookup function for people to look and or print documents stored in jpg, gif, pdf What software is out there that allows me to upload graphics, index the files and do searches. I would think the graphic files would have to be converted on the server to PDF, and indexed for searching? Is this what Adobe Capture does? Are there other products out there? Has anyone developed such a product? I know one exists already (http://www.speedscan.com/) but I want to develop one myself. Any tips would be greatly appreciated. --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Your thoughts on a project
Adobe? shame on you. -Original Message- From: FlashGuy [mailto:flashmx;rogers.com] Sent: 29 October 2002 15:49 To: CF-Talk Subject: Your thoughts on a project I have the opportunity to develop a database project on the side. The customers will be uploading and indexing graphic files (invoices, shipping etc). Also a lookup function for people to look and or print documents stored in jpg, gif, pdf What software is out there that allows me to upload graphics, index the files and do searches. I would think the graphic files would have to be converted on the server to PDF, and indexed for searching? Is this what Adobe Capture does? Are there other products out there? Has anyone developed such a product? I know one exists already (http://www.speedscan.com/) but I want to develop one myself. Any tips would be greatly appreciated. --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
cfxml question
I am creating a small bit of sample XML, and posting it via form to a page to parse it. When I create the XML by simply setting myXML= all XML code here, it works fine with XMLParse() and dot notation referencing of values. When I create my xml using cfxml/cfxml, I get the following error when trying to parse: Document Root Element is Missing. This is what the XML variable contains also when it hits this page: coldfusion.xml.XmlNodeList7210a5 My cfxml call is below: cfxml variable=myXML CONTROL ID100/ID KEY200/KEY DATE10252002/DATE ITEM STATUS RESULTPassed/STATUS STATUS_DATE10252002/STATUS_DATE /STATUS /ITEM /CONTROL /cfxml Any ideas on this? Thanks, Scott ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Locking and clustered servers
In SQL7 and SQL2000 you can use IDENTITY safely assuming you have no triggers that are causing cascading inserts. If you have triggers causing inserts, then you need to use the select max() method as shown in original message for SQL 7: DECLARE nextid SET TRANSACTION ISOLATION LEVEL SERIALIZABLE; BEGIN TRANSACTION; INSERT INTO table ... ; SELECT nextid = IDENTITY COMMIT TRANSACTION; Justin -Original Message- From: S. Isaac Dealey [mailto:info;turnkey.to] Sent: Monday, October 28, 2002 12:30 PM To: CF-Talk Subject: Re: Locking and clustered servers SNIP Depends heavily on the db server in question... SQL Server 7 Stored Procedure DECLARE nextid SET TRANSACTION ISOLATION LEVEL SERIALIZABLE; BEGIN TRANSACTION; INSERT INTO table ... ; SET nextid = (SELECT TOP 1 identity FROM table ORDER BY identity DESC) COMMIT TRANSACTION; SQL Server 2000 Stored Procedure DECLARE nextid; INSERT INTO table ...; SET nextid = SCOPE_IDENTITY(); I'm not familiar enough with Oracle yet to know the specific syntax. If you're absolutely certain that you won't have any triggers which insert data into other tables with identity columns in your db on SQL Server 7, you can use IDENTITY DECLARE nextid; INSERT INTO table ...; SET nextid = IDENTITY If you have a trigger on that table that inserts data into another table with another identity column, however, IDENTITY will return the identity value from the trigger, not the stored procedure. S. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Check this URL parameters out peoples
Should it be like this preceding application. With the servers(pop smtp) cfset Parameters = Emailaddress=#URLEncodedFormat(EmailAddress)#application.PopServer=#UR LEncodedFormat(application.PopServer)#application.SMTPServer=#URLEncode dFormat(application.SMTPServer)#username=#URLEncodedFormat(username)#P assword=#URLEncodedFormat(Encrypt(Password,815))# Well, first of all, you don't need to include application. as part of the URL parameter's value. For example, part of your URL is: application.PopServer=#URLEncodedFormat(application.PopServer)# This should be rewritten as: PopServer=#URLEncodedFormat(application.PopServer)# After that, you need to determine whether or not you should be using APPLICATION variables or not. If you decide to use them, then you should probably recode this so that you can apply locks appropriately, as in: CFLOCK SCOPE=Appplication TYPE=ReadOnly CFSET PopServer = APPLICATION.PopServer CFSET SMTPServer = APPLICATION.SMTPServer /CFLOCK cfset Parameters = Emailaddress=#URLEncodedFormat(EmailAddress)# PopServer=#URLEncodedFormat(PopServer)#SMTPServer=#URLEncode dFormat(SMTPServer)#username=#URLEncodedFormat(username)#P assword=#URLEncodedFormat(Encrypt(Password,815))# -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: cfxml question
The line in XML sample was mistyped in my example RESULTPassed/STATUS, In actual code it is RESULTPassed/RESULT -Original Message- From: Scott Mulholland [mailto:smulholland;accurateimaging.com] Sent: Tuesday, October 29, 2002 10:58 AM To: CF-Talk Subject: cfxml question I am creating a small bit of sample XML, and posting it via form to a page to parse it. When I create the XML by simply setting myXML= all XML code here, it works fine with XMLParse() and dot notation referencing of values. When I create my xml using cfxml/cfxml, I get the following error when trying to parse: Document Root Element is Missing. This is what the XML variable contains also when it hits this page: coldfusion.xml.XmlNodeList7210a5 My cfxml call is below: cfxml variable=myXML CONTROL ID100/ID KEY200/KEY DATE10252002/DATE ITEM STATUS RESULTPassed/STATUS STATUS_DATE10252002/STATUS_DATE /STATUS /ITEM /CONTROL /cfxml Any ideas on this? Thanks, Scott ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: HTML Tricks
Hey, on a related note, I've written a couple tags that are in the Tag Gallery for FLUSHSESSIONS and DUMPSESSIONS ... I know you can dump with CFDUMP, but the FLUSHSESSIONS is sometimes nice to clear all the variables for a fresh start. By default it leaves CFID and CFTOKEN intact, but you can override that. You access the variables by: [yoururl.cfm]?dumpsessions=1 or ?flushsessions=1 ... It's nice because you can leave them in the Application.cfm file and use them for debugging at any time. Just drop the query string on any URL in your app to see the session state. Thanks, Joshua Miller [EMAIL PROTECTED] -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:Neil.Robertson-Ravo;csd.reedexpo.com] Sent: Tuesday, October 29, 2002 10:45 AM To: CF-Talk Subject: RE: HTML Tricks FYI this should do it : div id=cfdebugger style=position:absolute; width:200px; height:115px; z-index:1; visibility: visible;cfdump var=#session#/div NOTE : depending on your z-axis/index, i cant remember if it works as 1 on top or the the greatest number? :-) but that should output on top of everything else. -Original Message- From: Robert Everland [mailto:REverland;dixonusa.com] Sent: 29 October 2002 15:33 To: CF-Talk Subject: RE: HTML Tricks How do I do that, I am using CF5, to my knowledge it always just outputs it on the page, there is no user actions. Robert Everland III Web Developer Extraordinaire Dixon Ticonderoga Company http://www.dixonusa.com -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:Neil.Robertson-Ravo;csd.reedexpo.com] Sent: Tuesday, October 29, 2002 10:26 AM To: CF-Talk Subject: RE: HTML Tricks place the dump tag on a layer which has a higher z-axis than the rest... -Original Message- From: Robert Everland [mailto:REverland;dixonusa.com] Sent: 29 October 2002 15:20 To: CF-Talk Subject: HTML Tricks In our website I am making heavy use of divs to place tables anywhere I want, the issue I have with this is that now when cf debugging is added it just sort of goes underneath some of the tables. Does anyone have a fix that I could do real quick with HTML. Robert Everland III Web Developer Extraordinaire Dixon Ticonderoga Company http://www.dixonusa.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Your thoughts on a project
Hey, just because they're fighting with Macromedia doesn't mean they don't make fabulous software. I have yet to see anything that can even touch Photoshop. Although LiveMotion is a ball of crap ;) Joshua Miller [EMAIL PROTECTED] -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:Neil.Robertson-Ravo;csd.reedexpo.com] Sent: Tuesday, October 29, 2002 10:53 AM To: CF-Talk Subject: RE: Your thoughts on a project Adobe? shame on you. -Original Message- From: FlashGuy [mailto:flashmx;rogers.com] Sent: 29 October 2002 15:49 To: CF-Talk Subject: Your thoughts on a project I have the opportunity to develop a database project on the side. The customers will be uploading and indexing graphic files (invoices, shipping etc). Also a lookup function for people to look and or print documents stored in jpg, gif, pdf What software is out there that allows me to upload graphics, index the files and do searches. I would think the graphic files would have to be converted on the server to PDF, and indexed for searching? Is this what Adobe Capture does? Are there other products out there? Has anyone developed such a product? I know one exists already (http://www.speedscan.com/) but I want to develop one myself. Any tips would be greatly appreciated. --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: HTML Tricks
I think he's wanting to change the behavior for the server's debug output at the bottom of the page vs. a cfdump tag ... z-index places objects with larger z-index values overlapping or on top of objects with lower z-index values... I'm trying to think of any way to change the default output at the bottom and nothing really leaps to my mind -- the big problem with this being that the output is typically below the closing /html tag and there aren't any ID values on any of the elements to work with. Even using javascript I'm not sure if there's any way to reference the html elements below the closing /html tag, since it's not within the document. Even if you were to create an OnRequestEnd file with something like div id=blah in it, you couldn't close that div without closing it above the top of the debugging output, which would mean there wouldn't be any way to apply css to it, etc... My best guess: make sure that the tallest element on your page is not absolutely positioned ( so as to allow it's height to force the debugging output to display below it ) ... Say for instance: bodyimg src= width=0 height=500 style=visibility: hidden or bodycfloop index=x from=1 to=100br //cfloop Then your debug output will always be a certain given distance from the top, and if all the other elements are absolutely positioned div's neither of these lines will affed their display. hth S. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 FYI this should do it : div id=cfdebugger style=position:absolute; width:200px; height:115px; z-index:1; visibility: visible;cfdump var=#session#/div NOTE : depending on your z-axis/index, i cant remember if it works as 1 on top or the the greatest number? :-) but that should output on top of everything else. -Original Message- From: Robert Everland [mailto:REverland;dixonusa.com] Sent: 29 October 2002 15:33 To: CF-Talk Subject: RE: HTML Tricks How do I do that, I am using CF5, to my knowledge it always just outputs it on the page, there is no user actions. Robert Everland III Web Developer Extraordinaire Dixon Ticonderoga Company http://www.dixonusa.com -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:Neil.Robertson-Ravo;csd.reedexpo.com] Sent: Tuesday, October 29, 2002 10:26 AM To: CF-Talk Subject: RE: HTML Tricks place the dump tag on a layer which has a higher z-axis than the rest... -Original Message- From: Robert Everland [mailto:REverland;dixonusa.com] Sent: 29 October 2002 15:20 To: CF-Talk Subject: HTML Tricks In our website I am making heavy use of divs to place tables anywhere I want, the issue I have with this is that now when cf debugging is added it just sort of goes underneath some of the tables. Does anyone have a fix that I could do real quick with HTML. Robert Everland III Web Developer Extraordinaire Dixon Ticonderoga Company http://www.dixonusa.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Your thoughts on a project
We use Canto Cumulus (www.canto.com) for our Army Aviation customers. Luis -Original Message- From: FlashGuy [mailto:flashmx;rogers.com] Sent: Tuesday, October 29, 2002 9:49 AM To: CF-Talk Subject: Your thoughts on a project I have the opportunity to develop a database project on the side. The customers will be uploading and indexing graphic files (invoices, shipping etc). Also a lookup function for people to look and or print documents stored in jpg, gif, pdf What software is out there that allows me to upload graphics, index the files and do searches. I would think the graphic files would have to be converted on the server to PDF, and indexed for searching? Is this what Adobe Capture does? Are there other products out there? Has anyone developed such a product? I know one exists already (http://www.speedscan.com/) but I want to develop one myself. Any tips would be greatly appreciated. --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Your thoughts on a project
What else is there does this? On Tue, 29 Oct 2002 15:53:15 -, Robertson-Ravo, Neil (REC) wrote: Adobe? shame on you. -Original Message- From: FlashGuy [mailto:flashmx;rogers.com] Sent: 29 October 2002 15:49 To: CF-Talk Subject: Your thoughts on a project I have the opportunity to develop a database project on the side. The customers will be uploading and indexing graphic files (invoices, shipping etc). Also a lookup function for people to look and or print documents stored in jpg, gif, pdf What software is out there that allows me to upload graphics, index the files and do searches. I would think the graphic files would have to be converted on the server to PDF, and indexed for searching? Is this what Adobe Capture does? Are there other products out there? Has anyone developed such a product? I know one exists already (http://www.speedscan.com/) but I want to develop one myself. Any tips would be greatly appreciated. --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: cfxml question
(Despite the typo in the XML code) You don't need to use XMLParse() because when you use myxml it parses it all for you! when using the cfxml method, simply output #myxml.control.id.xmltext# to get the value of the ID, 100. you only need xmlparse when the xml document you provide it with is not already a native xml document. In your case you were providing it with a string rather than an XML document when using cfset. For this you need to zmlparse() it before using dot notation -Original Message- From: Scott Mulholland [mailto:smulholland;accurateimaging.com] Sent: 29 October 2002 15:58 To: CF-Talk Subject: cfxml question I am creating a small bit of sample XML, and posting it via form to a page to parse it. When I create the XML by simply setting myXML= all XML code here, it works fine with XMLParse() and dot notation referencing of values. When I create my xml using cfxml/cfxml, I get the following error when trying to parse: Document Root Element is Missing. This is what the XML variable contains also when it hits this page: coldfusion.xml.XmlNodeList7210a5 My cfxml call is below: cfxml variable=myXML CONTROL ID100/ID KEY200/KEY DATE10252002/DATE ITEM STATUS RESULTPassed/STATUS STATUS_DATE10252002/STATUS_DATE /STATUS /ITEM /CONTROL /cfxml Any ideas on this? Thanks, Scott ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: cfxml question
It's bad xml RESULTPassed/STATUS needs to end with /RESULT -Original Message- From: Scott Mulholland [mailto:smulholland;accurateimaging.com] Sent: Tuesday, October 29, 2002 7:58 AM To: CF-Talk Subject: cfxml question I am creating a small bit of sample XML, and posting it via form to a page to parse it. When I create the XML by simply setting myXML= all XML code here, it works fine with XMLParse() and dot notation referencing of values. When I create my xml using cfxml/cfxml, I get the following error when trying to parse: Document Root Element is Missing. This is what the XML variable contains also when it hits this page: coldfusion.xml.XmlNodeList7210a5 My cfxml call is below: cfxml variable=myXML CONTROL ID100/ID KEY200/KEY DATE10252002/DATE ITEM STATUS RESULTPassed/STATUS STATUS_DATE10252002/STATUS_DATE /STATUS /ITEM /CONTROL /cfxml Any ideas on this? Thanks, Scott ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Date Format 1/1/1900
Hello all, I remember when CF5 first came out that people where having problems with DateFormat() returning 1/1/1900. Do any of you remember how to correct this? Bryan F. Hogan Director of Internet Development Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: HTML Tricks
Yeah you gave me the reenforced what I figured was going to be wrong. Oh well, I found a dirty way to do it by doing what you said. Thanks Robert Everland III Web Developer Extraordinaire Dixon Ticonderoga Company http://www.dixonusa.com -Original Message- From: S. Isaac Dealey [mailto:info;turnkey.to] Sent: Tuesday, October 29, 2002 11:02 AM To: CF-Talk Subject: RE: HTML Tricks I think he's wanting to change the behavior for the server's debug output at the bottom of the page vs. a cfdump tag ... z-index places objects with larger z-index values overlapping or on top of objects with lower z-index values... I'm trying to think of any way to change the default output at the bottom and nothing really leaps to my mind -- the big problem with this being that the output is typically below the closing /html tag and there aren't any ID values on any of the elements to work with. Even using javascript I'm not sure if there's any way to reference the html elements below the closing /html tag, since it's not within the document. Even if you were to create an OnRequestEnd file with something like div id=blah in it, you couldn't close that div without closing it above the top of the debugging output, which would mean there wouldn't be any way to apply css to it, etc... My best guess: make sure that the tallest element on your page is not absolutely positioned ( so as to allow it's height to force the debugging output to display below it ) ... Say for instance: bodyimg src= width=0 height=500 style=visibility: hidden or bodycfloop index=x from=1 to=100br //cfloop Then your debug output will always be a certain given distance from the top, and if all the other elements are absolutely positioned div's neither of these lines will affed their display. hth S. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 FYI this should do it : div id=cfdebugger style=position:absolute; width:200px; height:115px; z-index:1; visibility: visible;cfdump var=#session#/div NOTE : depending on your z-axis/index, i cant remember if it works as 1 on top or the the greatest number? :-) but that should output on top of everything else. -Original Message- From: Robert Everland [mailto:REverland;dixonusa.com] Sent: 29 October 2002 15:33 To: CF-Talk Subject: RE: HTML Tricks How do I do that, I am using CF5, to my knowledge it always just outputs it on the page, there is no user actions. Robert Everland III Web Developer Extraordinaire Dixon Ticonderoga Company http://www.dixonusa.com -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:Neil.Robertson-Ravo;csd.reedexpo.com] Sent: Tuesday, October 29, 2002 10:26 AM To: CF-Talk Subject: RE: HTML Tricks place the dump tag on a layer which has a higher z-axis than the rest... -Original Message- From: Robert Everland [mailto:REverland;dixonusa.com] Sent: 29 October 2002 15:20 To: CF-Talk Subject: HTML Tricks In our website I am making heavy use of divs to place tables anywhere I want, the issue I have with this is that now when cf debugging is added it just sort of goes underneath some of the tables. Does anyone have a fix that I could do real quick with HTML. Robert Everland III Web Developer Extraordinaire Dixon Ticonderoga Company http://www.dixonusa.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: cfxml question
that was xmlparse() not zmlparse(), obviously. -Original Message- From: Rich Wild [mailto:r.wild;e-mango.com] Sent: 29 October 2002 15:52 To: CF-Talk Subject: RE: cfxml question (Despite the typo in the XML code) You don't need to use XMLParse() because when you use myxml it parses it all for you! when using the cfxml method, simply output #myxml.control.id.xmltext# to get the value of the ID, 100. you only need xmlparse when the xml document you provide it with is not already a native xml document. In your case you were providing it with a string rather than an XML document when using cfset. For this you need to zmlparse() it before using dot notation -Original Message- From: Scott Mulholland [mailto:smulholland;accurateimaging.com] Sent: 29 October 2002 15:58 To: CF-Talk Subject: cfxml question I am creating a small bit of sample XML, and posting it via form to a page to parse it. When I create the XML by simply setting myXML= all XML code here, it works fine with XMLParse() and dot notation referencing of values. When I create my xml using cfxml/cfxml, I get the following error when trying to parse: Document Root Element is Missing. This is what the XML variable contains also when it hits this page: coldfusion.xml.XmlNodeList7210a5 My cfxml call is below: cfxml variable=myXML CONTROL ID100/ID KEY200/KEY DATE10252002/DATE ITEM STATUS RESULTPassed/STATUS STATUS_DATE10252002/STATUS_DATE /STATUS /ITEM /CONTROL /cfxml Any ideas on this? Thanks, Scott ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: cfxml question
meanwhile.back at that batcave.. -Original Message- From: Rob Rohan [mailto:rob;cardinalweb.com] Sent: 29 October 2002 16:11 To: CF-Talk Subject: RE: cfxml question It's bad xml RESULTPassed/STATUS needs to end with /RESULT -Original Message- From: Scott Mulholland [mailto:smulholland;accurateimaging.com] Sent: Tuesday, October 29, 2002 7:58 AM To: CF-Talk Subject: cfxml question I am creating a small bit of sample XML, and posting it via form to a page to parse it. When I create the XML by simply setting myXML= all XML code here, it works fine with XMLParse() and dot notation referencing of values. When I create my xml using cfxml/cfxml, I get the following error when trying to parse: Document Root Element is Missing. This is what the XML variable contains also when it hits this page: coldfusion.xml.XmlNodeList7210a5 My cfxml call is below: cfxml variable=myXML CONTROL ID100/ID KEY200/KEY DATE10252002/DATE ITEM STATUS RESULTPassed/STATUS STATUS_DATE10252002/STATUS_DATE /STATUS /ITEM /CONTROL /cfxml Any ideas on this? Thanks, Scott ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
=?iso-8859-1?Q?=C2_before_=A3_with_MX_form_posts??=
I am posting some information from one cf page to another but every £ sign is proceeded with Â. You can see an example here (Look at Binasys Ltd) http://efilesystem.com/Computer/Web_Hosting/Technical_Web_Hosting/more4.html What could this be? Thanks ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: Protecting NON-CF Files with CF
iAuth can do this. More information is available on our web site. Regards, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: JLH All Turbo [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 9:53 AM Subject: Protecting NON-CF Files with CF We have to protect an entire directory and it's subdirectories with CF. We'd like to use CF to process our logins.. but can't have people directly linking to JPGs and MPGs etc under neath.. since CF can't really protect these individual files unless called through a CFM page, we've run into a problem. How can we accomplish this? We DO own a copy of AuthentiX and unfortunately CFContent is not a viable solution. This site will have upwards of 12,000 simultaneous users and CFContent has too much overheard. Thank you! JLH ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: cfxml question
Arghh, list delay. I had replied to my own post stating that was a typo in the example not the actual code. -Original Message- From: Rob Rohan [mailto:rob;cardinalweb.com] Sent: Tuesday, October 29, 2002 11:11 AM To: CF-Talk Subject: RE: cfxml question It's bad xml RESULTPassed/STATUS needs to end with /RESULT -Original Message- From: Scott Mulholland [mailto:smulholland;accurateimaging.com] Sent: Tuesday, October 29, 2002 7:58 AM To: CF-Talk Subject: cfxml question I am creating a small bit of sample XML, and posting it via form to a page to parse it. When I create the XML by simply setting myXML= all XML code here, it works fine with XMLParse() and dot notation referencing of values. When I create my xml using cfxml/cfxml, I get the following error when trying to parse: Document Root Element is Missing. This is what the XML variable contains also when it hits this page: coldfusion.xml.XmlNodeList7210a5 My cfxml call is below: cfxml variable=myXML CONTROL ID100/ID KEY200/KEY DATE10252002/DATE ITEM STATUS RESULTPassed/STATUS STATUS_DATE10252002/STATUS_DATE /STATUS /ITEM /CONTROL /cfxml Any ideas on this? Thanks, Scott ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: Date Format 1/1/1900
Bryan F. Hogan wrote: Hello all, I remember when CF5 first came out that people where having problems with DateFormat() returning 1/1/1900. Do any of you remember how to correct this? By using a valid datetime object instead of a string as the attribute. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Date Format 1/1/1900
Duh, nevermind. I missed my quotes! Bryan F. Hogan Director of Internet Development Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: Bryan F. Hogan [mailto:bryan.hogan;digitalbay.net] Sent: Tuesday, October 29, 2002 11:09 AM To: CF-Talk Subject: Date Format 1/1/1900 Hello all, I remember when CF5 first came out that people where having problems with DateFormat() returning 1/1/1900. Do any of you remember how to correct this? Bryan F. Hogan Director of Internet Development Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
=?iso-8859-1?Q?Re: =C2 before =A3 with MX form posts??=
I am posting some information from one cf page to another but every £ sign is proceeded with Â. You can see an example here (Look at Binasys Ltd) http://efilesystem.com/Computer/Web_Hosting/Technical_Web_Hosting/more4.html Looks fine for me on Win2000 with IE6. Looking at the generated output, my guess is you're using a browser setup that may not recognize the pound; (space to preserve the code) code correctly. But, I'm not that familiar with which browsers render that correctly. Scott Scott Brady http://www.scottbrady.net/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: DSN-less connection to a CSV file?
This is not available in CFMX. CFML Reference Guide http://download.macromedia.com/pub/coldfusion/documentation/cfmx_cfml_refere nce.pdf This is what it has to tell about cfquery: cfquery name = query_name dataSource = ds_name dbtype = query username = username password = password maxRows = number blockFactor = blocksize timeout = seconds cachedAfter = date cachedWithin = timespan Either of the following: debug = Yes or No or: debug SQL statement(s) /cfquery New in ColdFusion MX: The connectString, dbName, dbServer, provider, providerDSN, and sql attributes, and all values of the dbtype attribute except query, are deprecated. Do not use them. You can try this on Windows (replacing the mdb with csv) !---Include the ADO Defines file--- cfinclude template=adocfscript.cfm !---Create the new Conection Object call it MyObject--- cfobject type=COM name=MyObject class=ADODB.Connection action=CREATE cfscript //Use these variables to build a valid connection string Driver=Microsoft Access Driver (*.mdb); DataBasePath=f:\database\northwinds.mdb; Source=Driver=#Driver#;DBQ=#DataBasePath#; //Open a connection to the northwinds database MyObject.Open(#Source#, adModeUnknown, adFailIfNotExists, adOpenRecordUnspecified); WriteOutput(h3Success!!/h3); /cfscript !--- Close --- cfset MyObject.Close() http://cfhub.com/advanced/ado/connection_string.cfm -Original Message- From: Matthew Walker [mailto:Matthew;cabbagetree.co.nz] Sent: Monday, October 28, 2002 8:03 PM To: CF-Talk Subject: RE: DSN-less connection to a CSV file? I think I got the information from an MS page rather than a CF page. Persist Security Info I feel it relates more to ODBC connection strings than to the text driver specifically. But I'm just guessing... -Original Message- From: Michael Kear [mailto:mkear;afpwebworks.com] Sent: Tuesday, 29 October 2002 4:47 p.m. To: CF-Talk Subject: RE: DSN-less connection to a CSV file? Thanks Matthew! That looks exactly like what I'm needing. Is there any documentation anywhere about DSNless connections? For example, I'd be interested to know what the Persist Security Info parameter does. I presume that is what makes the server hold on to the connection or not but it'd be nice to be able to know for sure. Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -Original Message- From: Matthew Walker [mailto:Matthew;cabbagetree.co.nz] Sent: Tuesday, 29 October 2002 2:34 PM To: CF-Talk Subject: RE: DSN-less connection to a CSV file? This is how we've been doing it: cfset ConnectString = Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=#fulldirectorypath#;Extensions=txt,csv;Persist Security Info=False; CFQUERY NAME=Log DBType=dynamic ConnectString=#ConnectString# SELECT * FROM[#file#] ORDER BYmyColumn /CFQUERY fulldirectorypath is the directory not the file. file is the filename excluding the extension. Matthew Walker http://www.matthewwalker.net.nz/ -Original Message- From: Michael Kear [mailto:mkear;afpwebworks.com] Sent: Tuesday, 29 October 2002 4:22 p.m. To: CF-Talk Subject: DSN-less connection to a CSV file? I have an information provider FTP'ing a series of .csv files into my server every night, and I need to use these files to create dynamic tables for users. Since they are updated every day, I can't have them locked and in use when the provider's automatic ftp dumps them into my site. So what I wanted to do was set my calculator up so that when my site user calls the information, the page connects to the .csv table, does the query then disconnects again. Is this (a) possible? (b) the best way to access (only read - not write or update) the .csv files so that they are not locked when the ftp program comes to drop new ones on the server? If so, can someone please give me the code to connect to the .csv file? (we're using CF5) There's no documentation at all about dsnless connection in the docs, and I haven't been able to find any thing in the archives of this list or any other. Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
=?iso-8859-1?Q?Re: Re: =3D?iso-8859-1?Q?=3DC2_before_=3DA3_with_MX_form_posts??=C2_before_=A3_with_MX_form_posts?=
Paul Wilson wrote: I am posting some information from one cf page to another but every £ sign is proceeded with Â. You can see an example here (Look at Binasys Ltd) http://efilesystem.com/Computer/Web_Hosting/Technical_Web_Hosting/more4.html You are sending unicode but you are not using the right charset headers. http://validator.w3.org/ would have told you so. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
custom tags Vrs CFC vrs web services.
Good morning every one: I am working with a client that's moving from version 4.5 to MX. With this change (and because of some new features) I have to rewrite a lot of the core code. Here's my open ended question please feel free to write long rambling essays What are the advantages and disadvantage of using custom tags vs. CFC's or Web Services? Thank you in advance for everyone's expert opinion. Jason
RE: custom tags Vrs CFC vrs web services.
enjoy... http://www.macromedia.com/software/coldfusion/whitepapers/ -Original Message- From: jason kufner [mailto:jasonkufner;rio.com] Sent: 29 October 2001 16:57 To: CF-Talk Subject: custom tags Vrs CFC vrs web services. Good morning every one: I am working with a client that's moving from version 4.5 to MX. With this change (and because of some new features) I have to rewrite a lot of the core code. Here's my open ended question please feel free to write long rambling essays What are the advantages and disadvantage of using custom tags vs. CFC's or Web Services? Thank you in advance for everyone's expert opinion. Jason ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Reading database and inserting fields into another database
HI, I need to read in the field env_var from one database (data1) and insert the results into another database as a comma-delimited text. cfquery name=GetAlias datasource=data1 dbtype=ODBC SELECT env_var FROMdata1 /cfquery Output example: file1 file2 file3 file4 file5 etc... Insert results of GetAlias.env_var into database (data2) into field strVar as a comma-delimited field. strVar = file1,file2,file3,file4,file5,etc... Can I do this with just --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Reading database and inserting fields into another database
cfquery name=GetAlias datasource=data1 dbtype=ODBC SELECT env_var FROMdata1 /cfquery cfquery name=GetAlias datasource=data2 dbtype=ODBC INSERT INTO DATABASE2TABLENAME ( STRVAR ) VALUES ( '#GetAlias.env_var#' ) /cfquery Bryan F. Hogan Director of Internet Development Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: FlashGuy [mailto:flashmx;rogers.com] Sent: Tuesday, October 29, 2002 12:13 PM To: CF-Talk Subject: Reading database and inserting fields into another database HI, I need to read in the field env_var from one database (data1) and insert the results into another database as a comma-delimited text. cfquery name=GetAlias datasource=data1 dbtype=ODBC SELECT env_var FROMdata1 /cfquery Output example: file1 file2 file3 file4 file5 etc... Insert results of GetAlias.env_var into database (data2) into field strVar as a comma-delimited field. strVar = file1,file2,file3,file4,file5,etc... Can I do this with just --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Reading database and inserting fields into another database
use cfset strVar = Valuelist(GetAlias.env_var) to create a comma delimited list. -Original Message- From: FlashGuy [mailto:flashmx;rogers.com] Sent: 29 October 2002 17:13 To: CF-Talk Subject: Reading database and inserting fields into another database HI, I need to read in the field env_var from one database (data1) and insert the results into another database as a comma-delimited text. cfquery name=GetAlias datasource=data1 dbtype=ODBC SELECT env_var FROMdata1 /cfquery Output example: file1 file2 file3 file4 file5 etc... Insert results of GetAlias.env_var into database (data2) into field strVar as a comma-delimited field. strVar = file1,file2,file3,file4,file5,etc... Can I do this with just --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
XML and IE 6 = Strange Bug
Hi Everybody, I just wanted to see if anyone had noticed the following strange behavior: In spite of Microsoft's attempts to be XML this, XML that, their sodding web-browser cannot seem to handle the HTML entity reference apos; correctly. I have taken to mapping it to its decimal representaion (#39;) but this seems idiotic considering how XML-y Microsoft purports IE 6 to be. Has anyone else noticed this? FYI: The browser in question is... Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; Q312461; .NET CLR 1.0.3705) -- Kreig Zimmerman : Sr. Web Programmer : [EMAIL PROTECTED] Four Eyes Productions : Brooklyn, NY : [718]254-9557 x[104] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Reading database and inserting fields into another database
naming the queries the same is liable to cause problems... I'd also recommend using cfqueryparam cfsqltype=cf_sql_varchar value=#ValueList(GetAlias.env_var)# -- use cf_sql_longvarchar if the values of the files may be more than about 8000 characters. cfquery name=GetAlias datasource=data1 dbtype=ODBC SELECT env_var FROMdata1 /cfquery cfquery name=GetAlias datasource=data2 dbtype=ODBC INSERT INTO DATABASE2TABLENAME ( STRVAR ) VALUES ( '#GetAlias.env_var#' ) /cfquery Bryan F. Hogan Director of Internet Development Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: FlashGuy [mailto:flashmx;rogers.com] Sent: Tuesday, October 29, 2002 12:13 PM To: CF-Talk Subject: Reading database and inserting fields into another database HI, I need to read in the field env_var from one database (data1) and insert the results into another database as a comma-delimited text. cfquery name=GetAlias datasource=data1 dbtype=ODBC SELECT env_var FROMdata1 /cfquery Output example: file1 file2 file3 file4 file5 etc... Insert results of GetAlias.env_var into database (data2) into field strVar as a comma-delimited field. strVar = file1,file2,file3,file4,file5,etc... Can I do this with just --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Reading database and inserting fields into another database
naming the queries the same is liable to cause problems... I'd also recommend using cfqueryparam cfsqltype=cf_sql_varchar value=#ValueList(GetAlias.env_var)# -- use cf_sql_longvarchar if the values of the files may be more than about 8000 characters. True except for valuelist(), query returns comma delimited anyway, why the extra function? Bryan F. Hogan Director of Internet Development Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: S. Isaac Dealey [mailto:info;turnkey.to] Sent: Tuesday, October 29, 2002 12:32 PM To: CF-Talk Subject: RE: Reading database and inserting fields into another database naming the queries the same is liable to cause problems... I'd also recommend using cfqueryparam cfsqltype=cf_sql_varchar value=#ValueList(GetAlias.env_var)# -- use cf_sql_longvarchar if the values of the files may be more than about 8000 characters. cfquery name=GetAlias datasource=data1 dbtype=ODBC SELECT env_var FROMdata1 /cfquery cfquery name=GetAlias datasource=data2 dbtype=ODBC INSERT INTO DATABASE2TABLENAME ( STRVAR ) VALUES ( '#GetAlias.env_var#' ) /cfquery Bryan F. Hogan Director of Internet Development Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: FlashGuy [mailto:flashmx;rogers.com] Sent: Tuesday, October 29, 2002 12:13 PM To: CF-Talk Subject: Reading database and inserting fields into another database HI, I need to read in the field env_var from one database (data1) and insert the results into another database as a comma-delimited text. cfquery name=GetAlias datasource=data1 dbtype=ODBC SELECT env_var FROMdata1 /cfquery Output example: file1 file2 file3 file4 file5 etc... Insert results of GetAlias.env_var into database (data2) into field strVar as a comma-delimited field. strVar = file1,file2,file3,file4,file5,etc... Can I do this with just --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: cfxml question
Thanks Rich. -Original Message- From: Rich Wild [mailto:r.wild;e-mango.com] Sent: Tuesday, October 29, 2002 11:01 AM To: CF-Talk Subject: RE: cfxml question that was xmlparse() not zmlparse(), obviously. -Original Message- From: Rich Wild [mailto:r.wild;e-mango.com] Sent: 29 October 2002 15:52 To: CF-Talk Subject: RE: cfxml question (Despite the typo in the XML code) You don't need to use XMLParse() because when you use myxml it parses it all for you! when using the cfxml method, simply output #myxml.control.id.xmltext# to get the value of the ID, 100. you only need xmlparse when the xml document you provide it with is not already a native xml document. In your case you were providing it with a string rather than an XML document when using cfset. For this you need to zmlparse() it before using dot notation -Original Message- From: Scott Mulholland [mailto:smulholland;accurateimaging.com] Sent: 29 October 2002 15:58 To: CF-Talk Subject: cfxml question I am creating a small bit of sample XML, and posting it via form to a page to parse it. When I create the XML by simply setting myXML= all XML code here, it works fine with XMLParse() and dot notation referencing of values. When I create my xml using cfxml/cfxml, I get the following error when trying to parse: Document Root Element is Missing. This is what the XML variable contains also when it hits this page: coldfusion.xml.XmlNodeList7210a5 My cfxml call is below: cfxml variable=myXML CONTROL ID100/ID KEY200/KEY DATE10252002/DATE ITEM STATUS RESULTPassed/STATUS STATUS_DATE10252002/STATUS_DATE /STATUS /ITEM /CONTROL /cfxml Any ideas on this? Thanks, Scott ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: Reading database and inserting fields into another database
True except for valuelist(), query returns comma delimited anyway, why the extra function? If that's the case : INSERT INTO data2 (strVal) SELECT env_var FROM data1 will do the trick. Stephen ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Reading database and inserting fields into another database
Forgot to mention that the update of the field in database (data2) has to be inserted into the proper field based on username which I'm saving to the auth varaible. The INSERT is not working properly. I'm sure of the proper syntax of this line #auth# = 'strUsername' If the user is Bill which is a field (strUsername) in database (data2) then insert the results from #commalist# into field strField1 cfquery name=GetAlias datasource=data1 dbtype=ODBC SELECT env_var FROMalias /cfquery cfset commalist = valuelist(GetAlias.env_var) cfquery name=Insert datasource=data2 dbtype=ODBC INSERT into profs (strField1) VALUES ('#commalist#') WHERE #auth# = 'strUsername' /cfquery On Tue, 29 Oct 2002 17:24:58 -, Dave Wilson wrote: use cfset strVar = Valuelist(GetAlias.env_var) to create a comma delimited list. -Original Message- From: FlashGuy [mailto:flashmx;rogers.com] Sent: 29 October 2002 17:13 To: CF-Talk Subject: Reading database and inserting fields into another database HI, I need to read in the field env_var from one database (data1) and insert the results into another database as a comma-delimited text. cfquery name=GetAlias datasource=data1 dbtype=ODBC SELECT env_var FROMdata1 /cfquery Output example: file1 file2 file3 file4 file5 etc... Insert results of GetAlias.env_var into database (data2) into field strVar as a comma-delimited field. strVar = file1,file2,file3,file4,file5,etc... Can I do this with just --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Protecting NON-CF Files with CF
Howie, This question came up on the CFDJ list, this is the response by I-Lin Kuo: The problem is that CF's application.cfm page will not run unless you actually call a .cfm page. That being said, the following might work (haven't tried it): Configure your webserver to hand off ALL requests to CF -- .doc, .pdf, txt, whatever. You can then have your application.cfm page check to see whether the file being called is a .cfm, in which case it proceeds normally, or another file type. If it's another file type, check authentication and access level and use cfcontent to return the contents. Of course, you're going to have performance issues because you're running all requests through CF, and requests for multiple MB documents are going to eat up RAM, but it's the quickest and easiest solution to the problem with your constraints. This should buy you enough time to come up with a better solution. Hope that helps -Original Message- From: Howie Hamlin [mailto:howie;coolfusion.com] Sent: 29 October 2002 16:23 To: CF-Talk Subject: Re: Protecting NON-CF Files with CF iAuth can do this. More information is available on our web site. Regards, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: JLH All Turbo [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 9:53 AM Subject: Protecting NON-CF Files with CF We have to protect an entire directory and it's subdirectories with CF. We'd like to use CF to process our logins.. but can't have people directly linking to JPGs and MPGs etc under neath.. since CF can't really protect these individual files unless called through a CFM page, we've run into a problem. How can we accomplish this? We DO own a copy of AuthentiX and unfortunately CFContent is not a viable solution. This site will have upwards of 12,000 simultaneous users and CFContent has too much overheard. Thank you! JLH ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: [OT] FlashCom Server High CPU Utilization
I was viewing the community suite just a while ago and after a while i noticed that the CPU rose up to 94%. You're right, it couldn't be the FlashCom.exe service. It's my IExplorer.exe services that had jumped to 94% even without attaching the webcam. I'm using IE 5.5 SP2. I'm going to verify this again while i wait for my webcam to come back from another state (Dumb collegue took it away to my regional office without informing me). I'm now using Mozilla 1.0. So far so good ! Must be M$ thingy !! Geezz .. Anthony -Original Message- From: Jochem van Dieten [mailto:jochemd;oli.tudelft.nl] Sent: Tuesday, October 29, 2002 7:18 PM To: CF-Talk Subject: Re: [OT] FlashCom Server High CPU Utilization Anthony Wong wrote: opps .. i need to add something. This high utilization only occurs when i connect my webcam to the flash comm server. Else, it's working fine even with the chat. I think this issue is quite different from Joachem's post earlier with regards to chat.asc which had to be re-written. I find patching the communicationcomponents from MM site solves the problem and along you'll get the CommsComponent for FlashMX. Someone took away my web cam now and i couldn't test exactly which service that gives me such a high CPU. I reckon it could be FlashCom.exe service. The Community Suite app is now running 2 concurrent streams with 8 clients and some chatting, and CPU usage is about 2%. On the other hand, the people having their webcam hooked up and sending a stream to the server report a CPU usage of more as 50%, and I had IE eat about 75% just watching it (switching to Mozilla solved that). If it happens again, please check which service eats the CPU, considering you don't have the other symptoms I don't expect it to be FlashCom. Jochem -- http://cfmx.oli.tudelft.nl/flashcom/applications/sample_panel_presentation/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: [OT] FlashCom Server High CPU Utilization
Mike, sorry for not making that clear. I was just refering to viewing the application on the browser. I wasn't refering to the admin interface. That works fine. Its the IE. Using Mozilla solved the CPU usage problem. Looks like IE 5.5 SP2 is not compatible with Flash Com and Creative WebCam. Anthony -Original Message- From: Mike Chambers [mailto:mchamber;macromedia.com] Sent: Tuesday, October 29, 2002 10:40 PM To: CF-Talk Subject: RE: [OT] FlashCom Server High CPU Utilization what do you mean by running off the browser? are you talking about the admin interface? if so, the admin can be CPU intensive at times. mike chambers [EMAIL PROTECTED] -Original Message- From: Anthony Wong [mailto:anthony;intracomm.com] Sent: Monday, October 28, 2002 10:23 PM To: CF-Talk Subject: [OT] FlashCom Server High CPU Utilization Importance: High I'm trying out Flash Comm on my laptop and noticed that the CPU utilization level stays above 95% average all the time when the app is running off the browser. Might have occasional dip but it didn't last for long as it shoots up right away. When the browser is closed, the CPU simply goes back to normal (1-3%) Here's my config: Pentium III 500 Windows 2000 IE 5.5 SP2 256 MB RAM (I read that's the minimum for Flash Comm) CFMX server service is off Anyone else experianced the same thing? It's burning my laptop too. I can feel the heat through the keyboard while running the flash comm app even for a short period of time. anthony ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: Reading database and inserting fields into another database
You need : WHERE #auth# = '#strUsername#' Stephen - Original Message - From: FlashGuy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 5:46 PM Subject: RE: Reading database and inserting fields into another database Forgot to mention that the update of the field in database (data2) has to be inserted into the proper field based on username which I'm saving to the auth varaible. The INSERT is not working properly. I'm sure of the proper syntax of this line #auth# = 'strUsername' If the user is Bill which is a field (strUsername) in database (data2) then insert the results from #commalist# into field strField1 cfquery name=GetAlias datasource=data1 dbtype=ODBC SELECT env_var FROMalias /cfquery cfset commalist = valuelist(GetAlias.env_var) cfquery name=Insert datasource=data2 dbtype=ODBC INSERT into profs (strField1) VALUES ('#commalist#') WHERE #auth# = 'strUsername' /cfquery On Tue, 29 Oct 2002 17:24:58 -, Dave Wilson wrote: use cfset strVar = Valuelist(GetAlias.env_var) to create a comma delimited list. -Original Message- From: FlashGuy [mailto:flashmx;rogers.com] Sent: 29 October 2002 17:13 To: CF-Talk Subject: Reading database and inserting fields into another database HI, I need to read in the field env_var from one database (data1) and insert the results into another database as a comma-delimited text. cfquery name=GetAlias datasource=data1 dbtype=ODBC SELECT env_var FROMdata1 /cfquery Output example: file1 file2 file3 file4 file5 etc... Insert results of GetAlias.env_var into database (data2) into field strVar as a comma-delimited field. strVar = file1,file2,file3,file4,file5,etc... Can I do this with just --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Reading database and inserting fields into another database
The INSERT is not working properly. I'm sure of the proper syntax of this line #auth# = 'strUsername' This is saying that you have a column in your database named Bill that has a value of strUsername. I don't think that is what you are looking for. Turn them around and say: where strUsername='#Auth#' Also as S. Isaac Dealey stated don't forget to use cfqueryparam cfquery name=GetAlias datasource=data1 dbtype=ODBC SELECT env_var FROMalias /cfquery cfset commalist = valuelist(GetAlias.env_var) cfquery name=Insert datasource=data2 dbtype=ODBC INSERT into profs (strField1) VALUES ('#commalist#') WHERE strUsername=cfqueryparam value=#auth# cfsqltype=CF_SQL_VARCHAR /cfquery Note IMO don't set your list with valuelist() your select statement returns in a comma delimited list anyways so there is no need to redo something that is already done. Bryan F. Hogan Director of Internet Development Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: FlashGuy [mailto:flashmx;rogers.com] Sent: Tuesday, October 29, 2002 12:47 PM To: CF-Talk Subject: RE: Reading database and inserting fields into another database Forgot to mention that the update of the field in database (data2) has to be inserted into the proper field based on username which I'm saving to the auth varaible. The INSERT is not working properly. I'm sure of the proper syntax of this line #auth# = 'strUsername' If the user is Bill which is a field (strUsername) in database (data2) then insert the results from #commalist# into field strField1 cfquery name=GetAlias datasource=data1 dbtype=ODBC SELECT env_var FROMalias /cfquery cfset commalist = valuelist(GetAlias.env_var) cfquery name=Insert datasource=data2 dbtype=ODBC INSERT into profs (strField1) VALUES ('#commalist#') WHERE #auth# = 'strUsername' /cfquery On Tue, 29 Oct 2002 17:24:58 -, Dave Wilson wrote: use cfset strVar = Valuelist(GetAlias.env_var) to create a comma delimited list. -Original Message- From: FlashGuy [mailto:flashmx;rogers.com] Sent: 29 October 2002 17:13 To: CF-Talk Subject: Reading database and inserting fields into another database HI, I need to read in the field env_var from one database (data1) and insert the results into another database as a comma-delimited text. cfquery name=GetAlias datasource=data1 dbtype=ODBC SELECT env_var FROMdata1 /cfquery Output example: file1 file2 file3 file4 file5 etc... Insert results of GetAlias.env_var into database (data2) into field strVar as a comma-delimited field. strVar = file1,file2,file3,file4,file5,etc... Can I do this with just --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
MX not seeing my MS ODBC Text Driver
Would this be a bug? I am using a text file as my datasource and I go through the regular process of creating an ODBC connection using MDAC. I then go into CF Administrator to the Datasources and see if MX will detect this newly created connection and it does not. Am I doing anything wrong? Dave Adams, CFUG Ottawa ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Reading database and inserting fields into another database
He is looking to input data from one database into another database not one table into another table. Bryan F. Hogan Director of Internet Development Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: Stephen Moretti [mailto:stephen;cfmaster.co.uk] Sent: Tuesday, October 29, 2002 12:51 PM To: CF-Talk Subject: Re: Reading database and inserting fields into another database True except for valuelist(), query returns comma delimited anyway, why the extra function? If that's the case : INSERT INTO data2 (strVal) SELECT env_var FROM data1 will do the trick. Stephen ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: MX not seeing my MS ODBC Text Driver
It's not a bug...it's a feature ;-) Create an ODBC Socket DSN to it in MX. -- jon mailto:jonhall;ozline.net Tuesday, October 29, 2002, 12:56:29 PM, you wrote: DA Would this be a bug? DA I am using a text file as my datasource and I go through the regular DA process of creating an ODBC connection using MDAC. I then go into CF DA Administrator to the Datasources and see if MX will detect this newly DA created connection and it does not. DA Am I doing anything wrong? DA Dave Adams, CFUG Ottawa ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: [OT] FlashCom Server High CPU Utilization
np. i think that is actually an issue with the chat component. basically, after a while when there is a lot of text in the chat window, cpu usage can go up. the authoring solution is to only allow a certain amount of data to appear in the text field. hope that helps clear up what is going on. mike chambers [EMAIL PROTECTED] -Original Message- From: Anthony Wong [mailto:anthony;intracomm.com] Sent: Tuesday, October 29, 2002 12:54 PM To: CF-Talk Subject: RE: [OT] FlashCom Server High CPU Utilization Importance: High Mike, sorry for not making that clear. I was just refering to viewing the application on the browser. I wasn't refering to the admin interface. That works fine. Its the IE. Using Mozilla solved the CPU usage problem. Looks like IE 5.5 SP2 is not compatible with Flash Com and Creative WebCam. Anthony ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: [OT] FlashCom Server High CPU Utilization
Another oppss! .. i spoke to soon. Just 5 minutes after i sent the email below, mozilla.exe service started to get cranky and shot itself up to 90% on an average while viewing the community suite (with the video and audio streamed of course). This is worrying as I have quite a bit of presentation work to do with Flash Comm and CFMX (flash remoting bit). Is there anything I should look out for? I have plenty of RAM (256MB) on my laptop, so that shouldn't be the problem. Thanks to all who answered this OT (and in advance too) Anthony -Original Message- From: Anthony Wong [mailto:anthony;intracomm.com] Sent: Wednesday, October 30, 2002 1:54 AM To: CF-Talk Subject: RE: [OT] FlashCom Server High CPU Utilization I was viewing the community suite just a while ago and after a while i noticed that the CPU rose up to 94%. You're right, it couldn't be the FlashCom.exe service. It's my IExplorer.exe services that had jumped to 94% even without attaching the webcam. I'm using IE 5.5 SP2. I'm going to verify this again while i wait for my webcam to come back from another state (Dumb collegue took it away to my regional office without informing me). I'm now using Mozilla 1.0. So far so good ! Must be M$ thingy !! Geezz .. Anthony -Original Message- From: Jochem van Dieten [mailto:jochemd;oli.tudelft.nl] Sent: Tuesday, October 29, 2002 7:18 PM To: CF-Talk Subject: Re: [OT] FlashCom Server High CPU Utilization Anthony Wong wrote: opps .. i need to add something. This high utilization only occurs when i connect my webcam to the flash comm server. Else, it's working fine even with the chat. I think this issue is quite different from Joachem's post earlier with regards to chat.asc which had to be re-written. I find patching the communicationcomponents from MM site solves the problem and along you'll get the CommsComponent for FlashMX. Someone took away my web cam now and i couldn't test exactly which service that gives me such a high CPU. I reckon it could be FlashCom.exe service. The Community Suite app is now running 2 concurrent streams with 8 clients and some chatting, and CPU usage is about 2%. On the other hand, the people having their webcam hooked up and sending a stream to the server report a CPU usage of more as 50%, and I had IE eat about 75% just watching it (switching to Mozilla solved that). If it happens again, please check which service eats the CPU, considering you don't have the other symptoms I don't expect it to be FlashCom. Jochem -- http://cfmx.oli.tudelft.nl/flashcom/applications/sample_panel_presentation/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Reading database and inserting fields into another database
naming the queries the same is liable to cause problems... I'd also recommend using cfqueryparam cfsqltype=cf_sql_varchar value=#ValueList(GetAlias.env_var)# -- use cf_sql_longvarchar if the values of the files may be more than about 8000 characters. True except for valuelist(), query returns comma delimited anyway, why the extra function? Because if you just use #GetAlias.env_var# you'll only return one row ( the first if you're not inside a cfloop or cfoutput of the query ) of the query and not a comma delimited list of the values in that column. Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Shorter urls?
Hi all, I've searched the devcenter, google, etc. but can't seem to find any discussion of how to generate shorter URL strings. I want to take: http://www.site.com?action=blahbrand=1name=blahblah; And convert it to http://www.site.com/asdfwer234123 I've seen it done but just can't remember where. Can someone send me a url? Thanks in advance, Ian -- Portent Interactive Effective web sites through Conversation Marketing http://www.portentinteractive.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Reading database and inserting fields into another database
Correct. On Tue, 29 Oct 2002 13:04:15 -0500, Bryan F. Hogan wrote: He is looking to input data from one database into another database not one table into another table. Bryan F. Hogan Director of Internet Development Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: Stephen Moretti [mailto:stephen;cfmaster.co.uk] Sent: Tuesday, October 29, 2002 12:51 PM To: CF-Talk Subject: Re: Reading database and inserting fields into another database True except for valuelist(), query returns comma delimited anyway, why the extra function? If that's the case : INSERT INTO data2 (strVal) SELECT env_var FROM data1 will do the trick. Stephen ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Shorter urls?
You could do something like the following. cfscript requestMap = CreateObject(java, java.util.HashMap); for(key in url) requestMap.put(URL| key, url[key]); uid = requestMap.hashCode(); /cfscript Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ 888-408-0900 x901 -Original Message- From: Ian Lurie [mailto:ian;portentinteractive.com] Sent: Tuesday, October 29, 2002 1:27 PM To: CF-Talk Subject: Shorter urls? Hi all, I've searched the devcenter, google, etc. but can't seem to find any discussion of how to generate shorter URL strings. I want to take: http://www.site.com?action=blahbrand=1name=blahblah; And convert it to http://www.site.com/asdfwer234123 I've seen it done but just can't remember where. Can someone send me a url? Thanks in advance, Ian -- Portent Interactive Effective web sites through Conversation Marketing http://www.portentinteractive.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Reading database and inserting fields into another database
I stand corrected :) Bryan F. Hogan Director of Internet Development Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: S. Isaac Dealey [mailto:info;turnkey.to] Sent: Tuesday, October 29, 2002 1:23 PM To: CF-Talk Subject: RE: Reading database and inserting fields into another database naming the queries the same is liable to cause problems... I'd also recommend using cfqueryparam cfsqltype=cf_sql_varchar value=#ValueList(GetAlias.env_var)# -- use cf_sql_longvarchar if the values of the files may be more than about 8000 characters. True except for valuelist(), query returns comma delimited anyway, why the extra function? Because if you just use #GetAlias.env_var# you'll only return one row ( the first if you're not inside a cfloop or cfoutput of the query ) of the query and not a comma delimited list of the values in that column. Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Shorter urls?
If you put a .cfm on the end, you can handle the request in the Application.cfm page. If you are using IIS, you have to tell it not to check to make sure the page exists. This is a setting specific to the application mapping. Or, you can use an ISAPI extension (IIS) or mod_rewrite (Apache) to rewrite the URL before it even gets to ColdFusion. There's a free one for IIS called ISAPI_Rewrite (http://www.isapirewrite.com). Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Ian Lurie [mailto:ian;portentinteractive.com] Sent: Tuesday, October 29, 2002 1:27 PM To: CF-Talk Subject: Shorter urls? Hi all, I've searched the devcenter, google, etc. but can't seem to find any discussion of how to generate shorter URL strings. I want to take: http://www.site.com?action=blahbrand=1name=blahblah; And convert it to http://www.site.com/asdfwer234123 I've seen it done but just can't remember where. Can someone send me a url? Thanks in advance, Ian -- Portent Interactive Effective web sites through Conversation Marketing http://www.portentinteractive.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Shorter urls?
http://www.makeashorterlink.com is where you've probably seen it done. I'm not sure how they do it either though. -Kevin Graeme -Original Message- From: Ian Lurie [mailto:ian;portentinteractive.com] Sent: Tuesday, October 29, 2002 12:27 PM To: CF-Talk Subject: Shorter urls? Hi all, I've searched the devcenter, google, etc. but can't seem to find any discussion of how to generate shorter URL strings. I want to take: http://www.site.com?action=blahbrand=1name=blahblah; And convert it to http://www.site.com/asdfwer234123 I've seen it done but just can't remember where. Can someone send me a url? Thanks in advance, Ian -- Portent Interactive Effective web sites through Conversation Marketing http://www.portentinteractive.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
=?iso-8859-1?Q?Re: =C2 before =A3 with MX form posts??=
I recommend you don't use the £ sign as lots of people can't see it. pound; or #156; should be more reliable. Paul Wilson wrote: I am posting some information from one cf page to another but every £ sign is proceeded with Â. You can see an example here (Look at Binasys Ltd) http://efilesystem.com/Computer/Web_Hosting/Technical_Web_Hosting/more4.html What could this be? Thanks ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Shorter urls?
I think they make a database of urls and just use a randomly generated unique key to pull it out So you would have http://youurl?index.cfm?destination=#randomid# Robert Everland III Web Developer Extraordinaire Dixon Ticonderoga Company http://www.dixonusa.com -Original Message- From: Kevin Graeme [mailto:kgraeme;facstaff.wisc.edu] Sent: Tuesday, October 29, 2002 1:43 PM To: CF-Talk Subject: RE: Shorter urls? http://www.makeashorterlink.com is where you've probably seen it done. I'm not sure how they do it either though. -Kevin Graeme -Original Message- From: Ian Lurie [mailto:ian;portentinteractive.com] Sent: Tuesday, October 29, 2002 12:27 PM To: CF-Talk Subject: Shorter urls? Hi all, I've searched the devcenter, google, etc. but can't seem to find any discussion of how to generate shorter URL strings. I want to take: http://www.site.com?action=blahbrand=1name=blahblah; And convert it to http://www.site.com/asdfwer234123 I've seen it done but just can't remember where. Can someone send me a url? Thanks in advance, Ian -- Portent Interactive Effective web sites through Conversation Marketing http://www.portentinteractive.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: Shorter urls?
Thanks - I found the UDF I was looking for: http://www.cflib.org/udf.cfm?ID=212enable=1 On 10/29/02 10:39 AM, Benjamin S. Rogers [EMAIL PROTECTED] wrote: If you put a .cfm on the end, you can handle the request in the Application.cfm page. If you are using IIS, you have to tell it not to check to make sure the page exists. This is a setting specific to the application mapping. Or, you can use an ISAPI extension (IIS) or mod_rewrite (Apache) to rewrite the URL before it even gets to ColdFusion. There's a free one for IIS called ISAPI_Rewrite (http://www.isapirewrite.com). Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Ian Lurie [mailto:ian;portentinteractive.com] Sent: Tuesday, October 29, 2002 1:27 PM To: CF-Talk Subject: Shorter urls? Hi all, I've searched the devcenter, google, etc. but can't seem to find any discussion of how to generate shorter URL strings. I want to take: http://www.site.com?action=blahbrand=1name=blahblah; And convert it to http://www.site.com/asdfwer234123 I've seen it done but just can't remember where. Can someone send me a url? Thanks in advance, Ian -- Portent Interactive Effective web sites through Conversation Marketing http://www.portentinteractive.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: [OT] FlashCom Server High CPU Utilization
That make sense. I have read somewhere in the Flash Comm User Guide that you can set/limit the text on the chat box. Would it be right to say that I need to trim the length by clearing up the text when it reaches certain value? How would i flush that out from Flash Comm? I see what else i can find out managing FlashComm tomorrow morning when i'm more awake. Thanks ! -Original Message- From: Mike Chambers [mailto:mchamber;macromedia.com] Sent: Wednesday, October 30, 2002 2:11 AM To: CF-Talk Subject: RE: [OT] FlashCom Server High CPU Utilization np. i think that is actually an issue with the chat component. basically, after a while when there is a lot of text in the chat window, cpu usage can go up. the authoring solution is to only allow a certain amount of data to appear in the text field. hope that helps clear up what is going on. mike chambers [EMAIL PROTECTED] -Original Message- From: Anthony Wong [mailto:anthony;intracomm.com] Sent: Tuesday, October 29, 2002 12:54 PM To: CF-Talk Subject: RE: [OT] FlashCom Server High CPU Utilization Importance: High Mike, sorry for not making that clear. I was just refering to viewing the application on the browser. I wasn't refering to the admin interface. That works fine. Its the IE. Using Mozilla solved the CPU usage problem. Looks like IE 5.5 SP2 is not compatible with Flash Com and Creative WebCam. Anthony ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
OT: Charlies Greenhouse and Datamann
Long shot... but I am wondering if the developer of CharliesGreenhouse.com is on this list? We were told this site is using Datamann to supply product information, and order processing. We are getting ready to work on two web sites that the companies are using Datamann and have some questions about the interfaces. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Shorter urls?
I have done this by using a lot of session and client variables, and a settings panel that a user can set defaults with, and if there happens to be an variables passed between pages, I store them in session vars. ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Ian Lurie [mailto:ian;portentinteractive.com] Sent: Tuesday, October 29, 2002 1:27 PM To: CF-Talk Subject: Shorter urls? Hi all, I've searched the devcenter, google, etc. but can't seem to find any discussion of how to generate shorter URL strings. I want to take: http://www.site.com?action=blahbrand=1name=blahblah; And convert it to http://www.site.com/asdfwer234123 I've seen it done but just can't remember where. Can someone send me a url? Thanks in advance, Ian -- Portent Interactive Effective web sites through Conversation Marketing http://www.portentinteractive.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Shorter urls?
simple: 1. person submits link via form to make shorter... 2. you insert data into database 3. when inserting one field called maybe unique is a random generated alpha numberic string... randomize and compare to existing data to make sure no dupe exists already... 4. write the long URL and the unique string... 5. pass the shorter back to the user.. but first: A. create an index handler that shows form if no string found otherwise looks up table entries to find match ... pauses, displays notice and then pushes them out... that's how I plan on implementing mine when I find a few hours :) -paris Paris Lundis Founder Areaindex, L.L.C. http://www.areaindex.com http://www.pubcrawler.com 412-292-3135 [finding the future in the past, passing the future in the present] [connecting people, places and things] -Original Message- From: Kevin Graeme [EMAIL PROTECTED] Date: Tue, 29 Oct 2002 12:42:58 -0600 Subject: RE: Shorter urls? http://www.makeashorterlink.com is where you've probably seen it done. I'm not sure how they do it either though. -Kevin Graeme -Original Message- From: Ian Lurie [mailto:ian;portentinteractive.com] Sent: Tuesday, October 29, 2002 12:27 PM To: CF-Talk Subject: Shorter urls? Hi all, I've searched the devcenter, google, etc. but can't seem to find any discussion of how to generate shorter URL strings. I want to take: http://www.site.com?action=blahbrand=1name=blahblah; And convert it to http://www.site.com/asdfwer234123 I've seen it done but just can't remember where. Can someone send me a url? Thanks in advance, Ian -- Portent Interactive Effective web sites through Conversation Marketing http://www.portentinteractive.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Shorter urls?
I don't believe encrypting the URL as this UDF does is the way to go. If I read it correctly, the order of the URL variables in the query string will affect the encrypted value. The code I posted in response to the original question does not suffer from this problem. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ 888-408-0900 x901 -Original Message- From: Ian Lurie [mailto:ian;portentinteractive.com] Sent: Tuesday, October 29, 2002 1:45 PM To: CF-Talk Subject: Re: Shorter urls? Thanks - I found the UDF I was looking for: http://www.cflib.org/udf.cfm?ID=212enable=1 On 10/29/02 10:39 AM, Benjamin S. Rogers [EMAIL PROTECTED] wrote: If you put a .cfm on the end, you can handle the request in the Application.cfm page. If you are using IIS, you have to tell it not to check to make sure the page exists. This is a setting specific to the application mapping. Or, you can use an ISAPI extension (IIS) or mod_rewrite (Apache) to rewrite the URL before it even gets to ColdFusion. There's a free one for IIS called ISAPI_Rewrite (http://www.isapirewrite.com). Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: Ian Lurie [mailto:ian;portentinteractive.com] Sent: Tuesday, October 29, 2002 1:27 PM To: CF-Talk Subject: Shorter urls? Hi all, I've searched the devcenter, google, etc. but can't seem to find any discussion of how to generate shorter URL strings. I want to take: http://www.site.com?action=blahbrand=1name=blahblah; And convert it to http://www.site.com/asdfwer234123 I've seen it done but just can't remember where. Can someone send me a url? Thanks in advance, Ian -- Portent Interactive Effective web sites through Conversation Marketing http://www.portentinteractive.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Shorter urls?
Once upon a time, someone on this list described a process where they created a CFML page from IIS's 404 error page (404.html becomes 404.cfm) that pre-processes all incoming page requests. Basically, the IIS document root is completely empty and everything gets preprocessed by the 404 error file. Files get included from a CF document root to generate the actual user output. This seems like a pretty darn ingenious way to do a bunch of cool stuff! If the person who told me about this is out there, I apologize for forgetting your name! Regards, Kevin -Original Message- From: Ian Lurie [mailto:ian;portentinteractive.com] Sent: Tuesday, October 29, 2002 12:27 PM To: CF-Talk Subject: Shorter urls? Hi all, I've searched the devcenter, google, etc. but can't seem to find any discussion of how to generate shorter URL strings. I want to take: http://www.site.com?action=blahbrand=1name=blahblah; And convert it to http://www.site.com/asdfwer234123 I've seen it done but just can't remember where. Can someone send me a url? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm