RE: Small Problem with Query Duplicates
What part is being duplicated? The URL? All of the records? If it is all the records then you should have a look at your Database. Unless duplication is okay in your DB. What is the ID field? Is it an auto generated ID or an ID Field you are populating? -Original Message- From: Mark Henderson [mailto:[EMAIL PROTECTED] Sent: Sunday, September 11, 2005 10:44 PM To: CF-Talk Subject: Small Problem with Query Duplicates I have a query thats run from a user search request, that looks like so: cfquery name=searchFarmLinks dataSource=#request.dsn# SELECT URL, ID, Company, Category, Phone, Email, Paid_listing FROM nzfarming WHERE URL IS NOT NULL ANDuCase(Company) like cfqueryparam value = %#uCase(searchtext)#% cfsqltype=cf_sql_varchar / ORDER BY Paid_listing ASC, Company ASC; /cfquery This is fine and works. However, the url is listed (in the output for display) each time an instance of the search term is matched (obviously) and I would like to get rid of the duplicates. I tried using DISTINCT without success i.e in the query, SELECT UNIQUE URL, Company etc If I do a single QoQ, like so cfquery name=searchDistinctFarmLinks dbtype=query SELECT DISTINCT URL FROMsearchFarmLinks /cfquery it DOES appear to return the correct recordset but I'm stumped as to how to re query based on that result. I also figure there must be a quicker cleaner way to do this. Any ideas?? All help appreciated. TIA regards Mark ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217916 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Reading file contents
One way is if the web server has permissions on the remote server, You could do a simple CFFILE ACTION=READ FILE=\\REMOTESERVER\FILE.TXT This is considering that the CF services are running under the same profile that has access to the remote server. Mindkeeper Solutions website: http://www.mindkeeper.net support: http://support.mindkeeper.net -Original Message- From: Richard Colman [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 03, 2005 8:09 PM To: CF-Talk Subject: Reading file contents I wish to read the contents of a file on a remote server via ftp. The lame approach appears to be: cfftp action=EXISTSFILE ... See if file is there cfif CFFTP.succeeded is yes cfftp connection=coda action=getfile ... Get the file from the remote server and write it to the disk on the host server. cffile action = read ... Read the contents of the file from the local server and do somethig with it. Is there a better, faster way to do this, since I have many read operations in a single template. TNX for any ideas on how to make this quicker and more efficient Richard Colman 949-824-1816, 701-5330 [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213682 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Reading file contents
Sorry that is the only other way I can think of besides the way you are processing the request now. Maybe someone else has a better idea. -Original Message- From: Richard Colman [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 03, 2005 9:00 PM To: CF-Talk Subject: RE: Reading file contents Unfortunately, no. The remote server is linux etc ... -Original Message- From: CF-DEV [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 03, 2005 5:53 PM To: CF-Talk Subject: RE: Reading file contents One way is if the web server has permissions on the remote server, You could do a simple CFFILE ACTION=READ FILE=\\REMOTESERVER\FILE.TXT This is considering that the CF services are running under the same profile that has access to the remote server. Mindkeeper Solutions website: http://www.mindkeeper.net support: http://support.mindkeeper.net -Original Message- From: Richard Colman [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 03, 2005 8:09 PM To: CF-Talk Subject: Reading file contents I wish to read the contents of a file on a remote server via ftp. The lame approach appears to be: cfftp action=EXISTSFILE ... See if file is there cfif CFFTP.succeeded is yes cfftp connection=coda action=getfile ... Get the file from the remote server and write it to the disk on the host server. cffile action = read ... Read the contents of the file from the local server and do somethig with it. Is there a better, faster way to do this, since I have many read operations in a single template. TNX for any ideas on how to make this quicker and more efficient Richard Colman 949-824-1816, 701-5330 [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213686 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Error in CFFile Tag
Make sure your form tag contains: enctype=multipart/form-data -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 07, 2003 5:27 PM To: CF-Talk Subject: Error in CFFile Tag I have the exact same code other than directory on two websites. One I can upload files too all day and the other one keeps giving me: The form field specified in the CFFILE tag (UPLOADNAME) does not contain an uploaded file. Please be sure that you have specified the correct form field name. My debug information shows: Form fields: etc.etc.etc UPLOADNAME=C:\My Documents\My Pictures\Eds55.jpg I have tried several different images in several different folders and it just does not want to work. Any help of any kind would be greatly appreciated. Larry Juncker Senior Cold fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] (515) 574-2122 CONFIDENTIALITY NOTICE The information contained in this e-mail is intended only for the use of the individual or entity to which it is addressed. This e-mail may contain information that is privileged, confidential and/or personal. If the reader of this message is not the intended recipient (or the employee or agent responsible to deliver it to the intended recipient), you are hereby notified that any dissemination, distribution, or copying of this communication is prohibited. If you have received this communication in error, please notify us at the e-mail listed above. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Email Problem
Is it sending HTML based email? It might be that they have Netscape Mail set for TEXT mail and not HTML. -Original Message- From: cfhelp [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 11, 2002 8:23 PM To: CF-Talk Subject: Email Problem One of our newsletter clients is getting email all full of ==09. They are running Win2k and Using Netscape Mail. Here is a piece of one of the newsletters. --part1_ef.6bbe8a7.2b26d046_boundary Content-Type: text/plain; name=BlueEarD.txt Content-Transfer-Encoding: quoted-printable Content-Disposition: inline; filename=BlueEarD.txt =09=09=09 =09=20 =20 =20 =20 =20 =09=09 =09=09 =09=09 =09=09 =09=09Welcome! 09=09=09 =09=09 =09=09December 09, 2002 =09=09 =09=09 =09=09 =09=09 =09=09 =09=09 =09=09 =09=09=09 Password? 3D%22http://www.blueear.com/Login.cfm%22 |=20 =09=09=09Help 3D%22http://www.blueear.com/help.cfm%22 |=20 =09=09=09Tell=20= a Friend 3D%22http://www.blueear.com/friend.cfm%22 Anyone seen this before please help. Rick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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: Need assistance with listbox on a form
On the action page test to see if the value exists: ISDEFINED() -Original Message- From: Clark, Aimee [mailto:aclark;stinsonmoheck.com] Sent: Thursday, October 31, 2002 2:14 PM To: CF-Talk Subject: Need assistance with listbox on a form I have a page in which employees can update information that is contained in their record in my SQL table. I recently added a multi-select list box with a list of foreign languages that they can choose from if it's applicable to them. If a user selects a foreign language and submits their changes, it works. If they change their address, but don't speak a foreign language and the list box doesn't have anything selected, then they get this lovely error message: GetOld.FLanaguage IS Error near line 126, column 24. _ Error resolving parameter GETOLD.FLANAGUAGE The column FLANAGUAGE is not present in the query named GETOLD. It is likely that you have misspelled the name of the column. The error occurred while processing an element with a general identifier of (CFIF), occupying document position (126:1) to (126:30). Ok, so FLangauge is a field in the query, so it isn't that. Here's the piece of the page where it's failing at: cfif GetOld.FLanaguage IS cfset chgFLanguage = cfelseif GetOld.FLanguage IS NOT '#FLanguage#' cfset chgFLanguage = #FLanguage# /cfif Is the reason why I am having this problem have to do with the fact that this is a multi-select list box and if so, how do I correct this to make this work correctly? For anyone who wants to see the code for the list box it is: tr tdbForiegn Languages You May Speak:/b/td tdcfselect name=FLanguage size=5 multiple CFOutput query=GetLanguages CFIF ListFindNoCase(EditNameQry.FLanguage,GetLanguages.LanguageName) CFSET PGSelected =Selected CFELSE CFSET PGSelected = /cfif Option #PGSelected# value=#LanguageName##LanguageName#/option /cfoutput /cfselect/td /tr Thank you, Aimee Clark Web Developer Stinson Morrison Hecker LLP [EMAIL PROTECTED] ~| 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: CFLoop query problem
What is happening, you are getting the LAST record in the query to populate the values. What is it you are attempting?? If you want an Overall total of ItemPrice Then is OrderTotal already defined? If you are want to loop and continually add the values until the end of the query is reached then you can do something as follows: CFLOOP QUERY=taxableOrderItems CFSET SubTotalTaxable = #SubTotalTaxable# + #OrderTotal# + #ItemPrice# /CFLOOP -Original Message- From: Mark Leder [mailto:mel;markleder.com] Sent: Thursday, October 31, 2002 2:32 PM To: CF-Talk Subject: CFLoop query problem Hi All, I'm trying to loop through a query to add all the items contained in that query. This query set contains three records. When I do a CFOUTPUT inside the CFLOOP on the ItemPrice field, all three individual prices are returned in succession, but the CFSET SubTotalTaxable tag only shows the first record. I want the tag to contain the sum of all three ItemPrice fields. What am I doing wrong? cfset SubTotalTaxable = 0 !--- Loop the taxable products --- CFLOOP QUERY=taxableOrderItems CFSET SubTotalTaxable = #OrderTotal# + #ItemPrice# /CFLOOP Thanks, Mark ~| 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: user - attachments ?
Usually an input box with the type=file The form must be set for method=multipart/form-data -Original Message- From: Ed Gordon [mailto:NetDr;callptc.com] Sent: Friday, October 25, 2002 3:31 PM To: CF-Talk Subject: user - attachments ? What is used to allow users to upload attachments, and what other considerations might there be to this scenario... I have a system whereas users enter headlines that are then posted to the HOME page of the site, along with an expiration date (after which the home page CFM ignores them). They often wish to refer to a JPG or something - have any code like this I can adapt for this purpose? It would be much appreciated. TIA, Ed Gordon ~| 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
CF5 Problem
Any idea why CF 5 would server CFM files up as TXT files? I do have the index.cfm in the IIS settings for default documents. TIA! ~| 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: CFM Files Display as TXT
CF Application Server service is running along with all the other CF services but still displays the contents of the CFM file to the browser instead of processing the CFM code. -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 10:35 AM To: CF-Talk Subject: Re: CFM Files Display as TXT Your default documents list shouldn't matter in this case although you may want to check to make sure the CF Server service hasn't stopped in NT Services... If the service is stopped, afaik IIS just passes the file on to the browser as is. Any idea why CFM files when called by a browser would display them as if they were TEXT and not served up as CFM files from the CF Application Server? I am running CF5 under IIS. I do have index.cfm as a default document. But when I call: http://localhost/mydir/index.cfm it displays the contents of the file as text and not being processed accordingly. 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 Get the mailserver that powers this list at http://www.coolfusion.com
RE: CFM Files Display as TXT
That was it!!! Thanks very much. Not sure how that happened but much appreciated for the info!! -Original Message- From: Andres [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 2:46 PM To: CF-Talk Subject: RE: CFM Files Display as TXT check your IIS site's application configuration. make sure your .cfm pages, or whatever mapping you use, is properly set to your CFUSION\bin\iscf.dll. for security purposes, make sure the check that file exists is checked. This will patch some IIS security flaws. HTH Andres -Original Message- From: Randell B Adkins [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 9:57 AM To: CF-Talk Subject: CFM Files Display as TXT Any idea why CFM files when called by a browser would display them as if they were TEXT and not served up as CFM files from the CF Application Server? I am running CF5 under IIS. I do have index.cfm as a default document. But when I call: http://localhost/mydir/index.cfm it displays the contents of the file as text and not being processed accordingly. TIA ~| 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: CF Application Logs
There is only maybe 3 session variables being used which are all in fact utilizing CFLOCK. -Original Message- From: Tilbrook, Peter [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 6:17 PM To: CF-Talk Subject: RE: CF Application Logs Possibly memory corruption due to variables not being locked appropriately. -Original Message- From: Randell B Adkins [mailto:[EMAIL PROTECTED]] Sent: Thursday, 3 October 2002 2:16 AM To: CF-Talk Subject: CF Application Logs Has anyone seen this error in the server.log file from the CF Administrator? Caught a fatal signal (4) - Aborting OR Caught a fatal signal (11) - Aborting After receiving this error, CF Executive (I imagine) initates a call for restarting the CF Application Server Services. If so, any ideas what it means as well as possible causes? ~| 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: CF Application Logs
Nope only session. Everything else is either request or variables scoped -Original Message- From: Mike Brunt [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 6:34 PM To: CF-Talk Subject: RE: CF Application Logs What about Application and/or Server scoped variables, are there any of those being used? Kind Regards - Mike Brunt, CTO Webapper http://www.webapper.com Downey CA Office 562.243.6255 AIM - webappermb Webapper - Making the NET work -Original Message- From: CF-DEV [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 3:21 PM To: CF-Talk Subject: RE: CF Application Logs There is only maybe 3 session variables being used which are all in fact utilizing CFLOCK. -Original Message- From: Tilbrook, Peter [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 6:17 PM To: CF-Talk Subject: RE: CF Application Logs Possibly memory corruption due to variables not being locked appropriately. -Original Message- From: Randell B Adkins [mailto:[EMAIL PROTECTED]] Sent: Thursday, 3 October 2002 2:16 AM To: CF-Talk Subject: CF Application Logs Has anyone seen this error in the server.log file from the CF Administrator? Caught a fatal signal (4) - Aborting OR Caught a fatal signal (11) - Aborting After receiving this error, CF Executive (I imagine) initates a call for restarting the CF Application Server Services. If so, any ideas what it means as well as possible causes? ~| 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
CFMX / MSSQL
I have CF MX installed and SQL 7. I created the database along with in the Control Panel, I created the ODBC connection to the DB with a DSN name of: myDB Now in CF it will not connect. I have SQL 7 set to TCP/IP in the Client Network Utility. I have no PWD associated since this is used as my DEV box. Any ideas? __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMX / MSSQL
I am using the local dbo account of sa no password. It will not authenicate in CF MX Admin. The drivers are those in CF MX. -Original Message- From: Brook [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 8:54 PM To: CF-Talk Subject: Re: CFMX / MSSQL What type of drivers are you using? The ODBC Socket Connection should work. If you want to use the Sql Server Driver, you need to have mixed mode authentication on your SQL Server. You need to setup a sql server login, with a username an password. Then use this username and password to connect to the datasource via CFMX. In earlier version you could use window authentication with the sql server driver, but not in MX. And you should try to avoid the ODBC Socket Connection. I have both those services stopped.. Brook At 08:24 PM 30/09/02 -0400, you wrote: I have CF MX installed and SQL 7. I created the database along with in the Control Panel, I created the ODBC connection to the DB with a DSN name of: myDB Now in CF it will not connect. I have SQL 7 set to TCP/IP in the Client Network Utility. I have no PWD associated since this is used as my DEV box. Any ideas? __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMX / MSSQL
This is the error: Connection verification failed for data source: Mindkeeper_SQL []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 8:51 PM To: CF-Talk Subject: Re: CFMX / MSSQL On Monday, September 30, 2002, at 05:24 PM, CF-DEV wrote: I have CF MX installed and SQL 7. I created the database along with in the Control Panel, I created the ODBC connection to the DB with a DSN name of: myDB Now in CF it will not connect. I have SQL 7 set to TCP/IP in the Client Network Utility. I have no PWD associated since this is used as my DEV box. Any ideas? Why use ODBC - CFMX has a built-in JDBC driver that works just fine. Below are 3 different ways that work on CFMX OS X (Linux). HTH Dick __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMX / MSSQL
Don't I feel like a total A$$ In the HELP it stated to put LOCAL within the parathesis. Such as: (local) Not True.. It is the standard: localhost Thanks everyone!! -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 9:09 PM To: CF-Talk Subject: Re: CFMX / MSSQL This is weird -- I'll try sending direct Dick On Monday, September 30, 2002, at 06:03 PM, Dick Applebaum wrote: I am having trouble posting the setups below -- copy pasted __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists