RE: mysql EXPLAIN [tablename] in CFQUERY?
I run this: cfquery name=TableColumns datasource=#Client.Database# explain #form.tablename# /cfquery cfdump var=#TableColumns# And get this: Error resolving parameter TABLECOLUMNS ColdFusion was unable to determine the value of the parameter. This problem is very likely due to the fact that either: You have misspelled the parameter name, or You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, or CFTABLE tag. The error occurred while processing an element with a general identifier of (CFDUMP), occupying document position (381:1) to (381:29) in the template Other funny occurence. If I select * from the table in question and loop through the result I can display the records with no problem. But if I do a cfdump on that queryset, I get a DNS error. -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 9:49 PM To: CF-Talk Subject: RE: mysql EXPLAIN [tablename] in CFQUERY? Do a CFDUMP VAR=#explain# after the CFQUERY to see if anything at all is returned. --- Ben __ 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: mysql EXPLAIN [tablename] in CFQUERY?
They both work from the command line. And changing the query to describe generates the same error. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 21, 2002 12:18 PM To: CF-Talk Subject: RE: mysql EXPLAIN [tablename] in CFQUERY? FYI, MySQL doesn't use 'explain table' it uses 'describe table' On Wed, 21 Aug 2002, Lon Lentz wrote: I run this: cfquery name=TableColumns datasource=#Client.Database# explain #form.tablename# /cfquery cfdump var=#TableColumns# And get this: Error resolving parameter TABLECOLUMNS ColdFusion was unable to determine the value of the parameter. This problem is very likely due to the fact that either: You have misspelled the parameter name, or You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, or CFTABLE tag. The error occurred while processing an element with a general identifier of (CFDUMP), occupying document position (381:1) to (381:29) in the template Other funny occurence. If I select * from the table in question and loop through the result I can display the records with no problem. But if I do a cfdump on that queryset, I get a DNS error. -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 9:49 PM To: CF-Talk Subject: RE: mysql EXPLAIN [tablename] in CFQUERY? Do a CFDUMP VAR=#explain# after the CFQUERY to see if anything at all is returned. --- Ben __ 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: mysql EXPLAIN [tablename] in CFQUERY? (fwd)
What OS are you running on? I am running on Linux with Apache/CF 5 using the Merant driver. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 21, 2002 12:25 PM To: CF-Talk Subject: RE: mysql EXPLAIN [tablename] in CFQUERY? (fwd) cfquery name=getTables datasource=cfmx describe blah /cfquery cfdump var=#getTables# Works for me. Sorry I didn't catch this email sooner and read it, just been busy. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: mysql EXPLAIN [tablename] in CFQUERY? (fwd)
The use db did not fix it. Are you using a non-Merant driver on your Linux box? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 21, 2002 12:36 PM To: CF-Talk Subject: RE: mysql EXPLAIN [tablename] in CFQUERY? (fwd) I'm using Windows/Apache/MySQL/CFMX and I'm using RH7.2/Apache/MySQL/CFMX. Maybe it's a merant driver problem if it's not a use db problem. __ 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
mysql EXPLAIN [tablename] in CFQUERY?
I am trying to return the result set of an EXPLAIN tablename command from a mysql database. I can query the table directly with no problems. The EXPLAIN returns a result set from the command line properly. But it seems that CFQUERY does not return anything. When I try to loop through the result, it gives me an error: The QUERY attribute of the tag does not specify the name of an available query __ Lon Lentz Applications Developer EXImpact.com __ 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: mysql EXPLAIN [tablename] in CFQUERY?
Here is what I have: cfquery name=TableColumns datasource=#Client.Database# explain #form.TableName# /cfquery cfloop query=TableColumns cfoutput#Field# - #Type# - #Null#/cfoutput /cfloop -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 5:28 PM To: CF-Talk Subject: Re: mysql EXPLAIN [tablename] in CFQUERY? Does your situtation look something like this? Are you putting the query=EXPLAIN in the loop? cfquery datasource=xxx name=EXPLAIN SQL Stuff /cfquery cfloop query=EXPLAIN #data#br /cfloop Paul Giesenhagen QuillDesign I am trying to return the result set of an EXPLAIN tablename command from a mysql database. I can query the table directly with no problems. The EXPLAIN returns a result set from the command line properly. But it seems that CFQUERY does not return anything. When I try to loop through the result, it gives me an error: The QUERY attribute of the tag does not specify the name of an available query __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: mysql EXPLAIN [tablename] in CFQUERY?
The query is built okay. A .recordcount produces the same error. It appears that explain generates a standard queryset in proper form. So I am stumped as to why explain may not be supported. -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 5:39 PM To: CF-Talk Subject: Re: mysql EXPLAIN [tablename] in CFQUERY? I don't know if explain is supported .. did you try to output a recordcount? to see if the query is bringing anything in? How about also trying to output your cfquery statement to see if there are any errors such as: cfoutput cfquery name=TableColumns datasource=#Client.Database#br explain #form.TableName#br /cfquerybr /cfoutput With the above example, you can make sure that everything is being dynamically populated. Paul Giesenhagen QuillDesign - Original Message - From: Lon Lentz [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, August 20, 2002 4:40 PM Subject: RE: mysql EXPLAIN [tablename] in CFQUERY? Here is what I have: cfquery name=TableColumns datasource=#Client.Database# explain #form.TableName# /cfquery cfloop query=TableColumns cfoutput#Field# - #Type# - #Null#/cfoutput /cfloop -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 5:28 PM To: CF-Talk Subject: Re: mysql EXPLAIN [tablename] in CFQUERY? Does your situtation look something like this? Are you putting the query=EXPLAIN in the loop? cfquery datasource=xxx name=EXPLAIN SQL Stuff /cfquery cfloop query=EXPLAIN #data#br /cfloop Paul Giesenhagen QuillDesign I am trying to return the result set of an EXPLAIN tablename command from a mysql database. I can query the table directly with no problems. The EXPLAIN returns a result set from the command line properly. But it seems that CFQUERY does not return anything. When I try to loop through the result, it gives me an error: The QUERY attribute of the tag does not specify the name of an available query __ 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
cf_objectdump not working on Linux
I can't get cf_objectdump to work on linux. I have used this tag on windows with no problems. Can someone point me to a resource on the issues of CF on Linux? Thanks. __ 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: cf_objectdump not working on Linux
I am trying to dump the CGI scope: cf_objectdump object=#cgi# I have also tried it with cfdump (Using CF 5.0): cfdump var=#cgi# It's not really an error. I placed the tag in /opt/coldfusion/CustomTags. I get a page that displays: !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META http-equiv=Content-Type content=text/html; charset=windows-1252/HEAD BODY/BODY/HTML -Original Message- From: Jesse Noller [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 13, 2002 1:25 PM To: CF-Talk Subject: RE: cf_objectdump not working on Linux What error message are you getting? __ 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: Using Text lists variable in SQL IN operator
Have you mailed the query to yourself (or some other way of looking at the actual query that is being thrown against your dbase)? You may need to use the infamous preservesinglequotes(). -Original Message- From: Michael E. Carluen [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 7:05 PM To: CF-Talk Subject: Using Text lists variable in SQL IN operator I'm having difficulty using the IN operator condition on a text list dynamically generated from previous query. Any suggestions? cfquery name=get_category_avg datasource=emp_review SELECT AVG(dbo.answer_rating.answer_value) as category_avg FROMdbo.answer_rating WHERE (dbo.answer_rating.site_id = #ATTRIBUTES.site_id#) AND (dbo.answer_rating.question_id IN (#category_qid#)) AND (dbo.answer_rating.eval_email IN (#manager_direct_staff#)) AND (dbo.answer_rating.self = 'n') /cfquery __ 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: Loading Large Files through a Browser
How are you sure the upload has stalled/failed? Are you using a requesttimeout=? -Original Message- From: Jason Larson [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 12:34 PM To: CF-Talk Subject: Loading Large Files through a Browser I was wondering if anybody out there has had any timeout issues when loading large files through the web browser with cffile. I have been trying to upload a 6 to 15 meg file through a file input field and the browser seems to time out, I don't get a cold fusion error just the browser seems to hang. If anybody has run into this problem, what kind of solutions did you come up for it? __ 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: Mac form submission file upload
Using a little JS, you could assign the value of the file field into another field in the submission template and test that value for eq in the action template. -Original Message- From: Axiomatique (Vincent) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 11, 2002 10:21 AM To: CF-Talk Subject: RE: Mac form submission file upload I don't know if this is related to your problem, but I noticed that on the MAC, if you have a file upload field and that you don't select a file to upload (field supposely empty), the MAC doesn't see the field as empty, thus forcing you to trap the error in the cffile as cfif form.filefield neq won't work on the MAC. __ 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
Pez convention moves after teen is cited
By Heather Ratcliffe Of The Post-Dispatch * A Frontenac officer issued a summons to the youth for not having a merchant's license. That led the convention's organizer to move the candy dispenser collectors' convention to Town and Country. Pez candy dispenser collectors moved their annual convention this weekend from Frontenac to Town and Country after an undercover police officer busted a teen who sold a $3 item without a merchant's license. A Frontenac police detective wandered into a room at the Frontenac Hilton on Thursday and bought a Star Wars Pez candy dispenser from 18-year-old Seth Weinberg of Columbia, Mo. About an hour later, the officer returned to issue Weinberg a court summons. Dozens of other dealers were not cited. I didn't invite this guy into my room to buy Pez. He just came in, Weinberg said. City officials said anyone selling merchandise in Frontenac must apply for a itinerant merchant license 30 days before the sale. The process gives police an opportunity to check the background of a vendor before the public buys wares. It doesn't matter what they are selling - diamond rings or Pez dispensers, said City Attorney Chet Pleban. We want to make sure everyone follows the law, and we know who comes into our town. John Devlin, who founded the convention 10 years ago, said he never needed a license when he hosted the event in the St. Louis area in the past. Devlin, of south St. Louis County, said the hotel event coordinator never mentioned it. He said he heard about the ordinance about three weeks before the convention. By then, he said, he didn't have time to apply. Instead, Devlin decided to move the event to the St. Louis Marriott West hotel in Town and Country after the incident Thursday. Town and Country does not put the same restrictions on vendors. The Pez show, open to the public from 10:30 to 2 p.m. today, will be squeezed into the Marriott West ballroom, which is one-third the size of the planned space. More than 200 people from across the country registered for the event. Organizers expected several hundred more to stop in. Weinberg must return to Frontenac July 17 to appear in court on his violation. I know the police are doing their job, he said. But I'm sure there has got to be something better they can be doing than busting people selling Pez. __ 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: Login Inside Popup
I don't have an app, but from the authentication page, loaded in the popup, if authenticated, load a page with the following: script opener.location.href=PageToLoad.cfm; self.close(); /script I can expand on this if needed. -Original Message- From: Charlie [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 4:53 PM To: CF-Talk Subject: Login Inside Popup Has anyone created a login app within a pop-up window that upon authentication, the pop-up closes and redirects the parent window to a new page..much appreciated if anyone can get me on the right track __ 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: damn Netscape 4.x!
Can you post a link? -Original Message- From: Jeff Brown [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 10:40 AM To: CF-Talk Subject: damn Netscape 4.x! All, I have a page that displays perfectly in IE 5.5, but shows up blank in Netscape 4.79. Not only does it render blank, but it takes about 30 seconds to render blank. (no dynamic content). When I do a View Source in Netscape, the source is there. However, in the browser, I am only seeing the background color. I know that open ended table tags have caused this problem for me in the past, but there are no problems with table tags in this document. All the CSS elements linked to the page pass the TopStyle3 NN4.x validation, and the page's HTML passes the CFStudio 5 Document validation. Can anyone think of some other reasons this might be happening?? Thanks! __ 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
FW: MacBinary Xtraction Component 1.0
Much thanks to you and Dave. I got it working. Now I just need to find some glue so I can stick my hair back on... -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 1:00 PM To: CF-Talk Subject: Re: MacBinary Xtraction Component 1.0 Most likely it can, after looking at the source it is a very simple COM object that doesn't return anything that CF might choke on. The key function is the ConvertMacFile function. In that function these two lines would be key, and they would look exactly the same in cfscript without the Set keyword, and adding semicolons. Set MacBin = CreateObject(Softwing.MacBinary) bRetVal = MacBin.ConvertFromMacBinary(File,strCurrentTempFile) __ 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
MacBinary Xtraction Component 1.0
The guys at this site: http://www.alphasierrapapa.com/IisDev/Components/MacBinary/ , have come up with a C++ component for fixing MacBinary uploaded files. Being an ASP site, they have written an ASP page for running this component. Is there a way of running this component from CF? Lon Lentz Applications Developer and Keeper of the I.T. http://ProofitOnline.Com - Free 15 Day Trial __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFLOOP problem with commas
How are you building your list? You could use a non-URL type character, or a small
group of characters, as your delimiter. Something like ~~~ or |||.
-Original Message-
From: Tim Claremont [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 23, 2002 4:25 PM
To: CF-Talk
Subject: CFLOOP problem with commas
I am trying to CFLOOP through a collection of URLs. The problem comes
from the fact that there are commas in some of the URLs. To illustrate
the problem, my code is as follows:
CFSET URL1=
http://www.foobar.com/selector/en/prodselect.asp?Xcntry=USAXlang=en_US
error=novars
CFSET URL2=
http://www.foobar.com/SRVS/CGI-BIN/WEBCGI.EXE?New,Kb=x_main_en,Company=
{7C4ED4E1-1DE9-46A0-BC3E-BE1C2FA9E9C9},varset=Xlang:en_US,varset=Xcntry:
USA,varset=prodID:DC220DC
__
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFLOOP problem with commas
Huh. Okay. I've never experienced a problem with them. Which isn't to say that no one will. -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 23, 2002 4:39 PM To: CF-Talk Subject: RE: CFLOOP problem with commas Guys, Delimeters that are more than 1 (or 2?) characters don't always work in my experience. CF kinda just uses 1 character for a delimeter. __ 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
cookie, session, and domain management trouble
Can someone explain to me why adding domain=.mydomain.com to my cfcookie tags in my application.cfm would cause a cookie disruption in NS4.7? Lon Lentz Applications Developer and Keeper of the I.T. http://ProofitOnline.Com - Free 15 Day Trial __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cookie, session, and domain management trouble
Is there a work around for this or a way to fool NS4.7? I used to be a fan of NS, but this passed year dealing with xbrowser issues with it has been hell. -Original Message- From: Critz [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 11, 2002 2:12 PM To: CF-Talk Subject: Re: cookie, session, and domain management trouble oi Lon!! cuz netscape sucks? __ 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: application.cfm
I understand the CF server will create the datasource and the tables automatically, is this true? Also, how long will this process take to change it over? And are there any issues that someone should be aware of when changing it over? -Original Message- From: Joel Firestone [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 10:25 AM To: CF-Talk Subject: Re: application.cfm Darren: We had a machine that was using (by default) the registry to store the client variables. Then it started crashing like every few hours. We looked at the registry, and it was like 120 mb. The machine crawled. So we cleaned it out, and set the storage to cookies, and it hasn't gone down since. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: application.cfm
Cool. Thanks for the info. One other question. How do I go about safely removing all the data that CF put into the registry once I move it? -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 10:45 AM To: CF-Talk Subject: RE: application.cfm At 10:51 AM 4/10/2002 -0400, you wrote: I understand the CF server will create the datasource and the tables automatically, is this true? CF will create the tables automatically. You have to create the database and datasource yourself. Also, how long will this process take to change it over? I was able to set the whole thing up in ~15 minutes including a coffee break, the first time I did it. And are there any issues that someone should be aware of when changing it over? Making the change over is the smoothest server administration task I have ever done. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: listing all form variables
#form.fieldnames# -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 12:43 PM To: CF-Talk Subject: listing all form variables Can CF output a list of all the form variables passed to a page? I vaguely remember this being possible but i don't remember how to do it. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: mystery page named FFFFFF
Just a thought: Are there places where a color is set to #FF and within cfoutput tags and contains only one pound sign #? Perhaps CF is doing something funky like running the FF into your form tag's action value. And if you are using a pound encased CF variable as your action value, things could get kinda funky. -Original Message- From: Chris Norloff [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 4:09 PM To: CF-Talk Subject: mystery page named FF This might or might not be a CF problem: we routinely get 404 errors when the application looks for a page named FF. Somehow a link is getting corrupted and we've been unable to track it down. It happens all over our application, with no real pattern. It appears more often after calling a style sheet, but it appears even when we're not calling the style sheet. Anybody seen anything like this? __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Zipping Files
You could grab cfx_consolecommand and run pkzip old school style. -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 9:38 AM To: CF-Talk Subject: Zipping Files Does anyone have code or an example of zipping files? Thx, Duane __ 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
Session variables dropping
I have an intermittent problem with the session scoped variables being dropped going from the frame definition template to the template within the frame. This is occurring on IE 6. I remember hearing at one point that IE 6 handles each separate frame as a separate window. Are there any known issues with how IE 6 handles session variables across frames? Lon Lentz Applications Developer and Keeper of the I.T. http://ProofitOnline.Com - Free 15 Day Trial __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFFTP
My experience with cfftp has been that CF will handle as many simultaneous connections as your physical server and bandwidth will allow. One solution if you are concerned about load or bandwidth is to create a queueing system and to only allow a limited number of simultaneous connections. -Original Message- From: Jim Curran [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 7:12 PM To: CF-Talk Subject: CFFTP Hi all, Anyone know the limitations / performance issues w/ cfftp? I building an application that will have many simultaneous users accessing templates that cfftp files to many different locations. Questions: 1) How many simultaneous / active connections can the CF Server handle? 2) Is there a better way to do this? __ 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: session variables and multiple servers
-Original Message- From: S R [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 8:29 PM To: CF-Talk Subject: session variables and multiple servers We just changed our website from one being on one server to being on 3 redundant web servers. The problem is, the web farm switches from server to server every 15 minutes to whichever server has the least traffic, which causes me and any other user to have to re-login to password protected areas on the site every 15 minutes. How can I make session variables span across all three servers? Or should I look into other solutions? __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: session variables and multiple servers
Have you guys given thought to real time load management? Which would keep users on the machine they log into? -Original Message- From: S R [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 8:29 PM To: CF-Talk Subject: session variables and multiple servers We just changed our website from one being on one server to being on 3 redundant web servers. The problem is, the web farm switches from server to server every 15 minutes to whichever server has the least traffic, which causes me and any other user to have to re-login to password protected areas on the site every 15 minutes. How can I make session variables span across all three servers? Or should I look into other solutions? __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Query Analyzer
How long is it? Under tools/options there is a maximum characters per column. -Original Message- From: Kahng, Lucius [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 3:12 PM To: CF-Talk Subject: SQL Query Analyzer I'm trying to retrieve a long text field from out ColdFusion SQL database using SQL Query Analyzer, however, the program truncates the field contents. Is there a way to display the full contents of long text fields? (Instead of having to use CFML to output a the whole table's column contents!) __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: FoxPro General Error
-Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 10:50 AM To: CF-Talk Subject: FoxPro General Error Any FoxPro folks out there that can tell me why I am receiving this error? Unless I'm reading it wrong, you have one more ( than you have ). ODBC Error Code = S1000 (General error) [Microsoft][ODBC Visual FoxPro Driver]Function name is missing ). I am not sure what function is missing. This query works fine in Access and SQL Server. SQL = SELECT DISTINCT drname.DR_ID, drname.DR_LNAME, drname.DR_FNAME, dr name.DR_INAME FROM (drname LEFT JOIN stfstatu ON drname.DR_ID = stfstatu. DR_ID) RIGHT JOIN Address ON drname.DR_ID = Address.DR_ID WHERE (((drname DR_LNAME) Like 'N%') AND ((stfstatu.DR_ID)=[drname].[dr_id]) AND ((stfst atu.ACTIVE123)='1') AND ((Address.SCH_TYPE)='1')) OR (((Address.OVERRID E)='1')) ORDER BY drname.DR_LNAME Thanks, Bruce __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: odd cookie behavior - more serious
Dumb question: Is this occuring on multiple IE machines? Did you try deleting all of your cookies? Your cookie file for that domain may have gotten corrupted. -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 4:36 PM To: CF-Talk Subject: odd cookie behavior - more serious This is more serious than my previous post suggests. I just attempted to connect to the application using a Mac and IE4.5 and got the same error... yet yesterday no problem at all... === previous message Today... right in the middle of working with a cf app when suddenly the Applications starts saying I need to enable cookies. I check and IE 5.5 cookies are enabled... so I fire up Netscrape and it has no problems with the application. It seems to be an IE only problem. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Decryption Licensing Verbiage/Copy
You could reference the DMCA in saying that decrypting would be a violation of federal law. -Original Message- From: Rick Osborne [Mojo] [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 5:12 PM To: CF-Talk Subject: Decryption Licensing Verbiage/Copy We're looking to add some verbiage/copy to our licensing agreements that says something to the effect of decrypting any encrypted templates violates the terms of this license. Our management-types want it to sound more authoritative (and nastier) than that. Does anyone have anything in their licensing agreements like this that we can copy/steal? __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT percentage of Broadband v.s. Dial up
CNET radio just stated that 51% are currently on broadband. They did not mention (or I did not hear) the source for that figure. -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Monday, March 04, 2002 6:10 PM To: CF-Talk Subject: OT percentage of Broadband v.s. Dial up Anyone have a link to statistics showing percentage of users with broadband v.s. dial up? __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT percentage of Broadband v.s. Dial up
I miss heard the original statement. According to Nielson's net ratings, 20% are broadband and account for 51% of the net's activity. -Original Message- From: jon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 11:23 AM To: CF-Talk Subject: RE: OT percentage of Broadband v.s. Dial up 51% of users listing to CNET radio, maybe... .. but the real figues are closer to 15%. http://www.netaction.org/broadband/dsl/section1.html (These stats are from July 2001, but I doubt adoption rates have climbed at too massive a pace since then) -- jon __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Get everything between in a CSV file.
text,text,dumb,text Change , to ~. Change the independent commas, then change ~ back to ,. -Original Message- From: Tracy Bost [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 5:40 PM To: CF-Talk Subject: Get everything between in a CSV file. Can someone help me out here. I have a cvs file being uploaded and am having trouble with one of the fields. It a field that *can* contain comments and therefore have a comma in it. I'm dumping it into the database and everything is hunky dorie until a comma is put in the comment field. I notice the csv file puts this field like this This is a comment, and another comment,and another... I would like to find all commas between the two and temporarily change the commas to something else so it doesn't think its another field... __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: 1 browser window kill client var
Two possible suggestions: Do not allow multiple jobs to be processed simultaneously. That is, do not allow that particular session to process more than one job at a time. The other would be to make arrays of all your job related variables and track them separately. - Original Message - From: Chris Norloff [EMAIL PROTECTED] We just made an interesting discovery. We process multiple jobs, identified by different job numbers. We were looking into using client variables for job numbers, but if (when?) users open more than one browser window this can cause problems. If the user uses a second browser instance to go to another job, then the client vars will be overwritten by the new job number. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: Real-time Monitoring
www.internetseer.com -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] A few months ago, we were talking about Humanclick on cf-talk, and how some of us have been using its free Real-time Monitoring program. Since Humanclick no longer off the Real-time Monitoring for the free version, does anyone know of a similar service that's free? __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
More information from an errored template
I cfcatch my errors to a template that sends me emails with all of the information I need to fix the problem. Except that I now have total = charges - (Round(discountAmount * 100) / 100) causing a Cannot convert to number error. Is there a tag somewhere that would take that and actually display the value of every variable in the string it displays? I know I can find the error if I put some debug code in there, but breaking those down to real values would be really helpful. Or, is there a way to reference unscoped variables as a group in a template so I could do a cf_objectdump on them? Or will I have to scope them all and dump that object? Lon Lentz Applications Developer and Keeper of the I.T. http://ProofitOnline.Com - Free 15 Day Trial __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Vertical Text
Can you use tables? You could create a single column of cells with a letter in each. -Original Message- From: Jeff Brown [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 06, 2002 4:00 PM To: CF-Talk Subject: Vertical Text Any ideas on how I might display text vertically using either CF or CSS? Without stacking the letters using br's and without creating graphics. The text displayed vertically will be dynamic... it's looking like it might not be possible...? Thanks! __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: disappearing session variables
Is Netscape issuing a new cookie on the second page because it thinks that the domain has changed? -Original Message- From: c talk [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 4:16 PM To: CF-Talk Subject: disappearing session variables snip When I browse this site on my laptop/dev server using it's IP address (192.168.x.x), the site runs ok in IE, but chokes on the 2nd page in Netscape. It works in IE if I use either 127.0.0.1 or localhost as the domain. Netscape only likes localhost. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: disappearing session variables
Sorry, sloppy use of words. I once had a problem with dying session variables and found that NS was showing a new set of cookies. Apparently when the reference changes, NS does not see it as being in the same domain and does not send the cookies it set for the previous page. CF sees the page request from a new user and sets new cookies for a new session. A session for which session variables have not been set. Example: If you came to www.mydomain.com, one set of cookies would be set. But let's say you follow a link to another page on the server through a link that had http://mydomain.com. You would get a new set of cookies and a new session assigned to you. -Original Message- From: c talk [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 5:24 PM To: CF-Talk Subject: RE: disappearing session variables Lon, et al --- Lon Lentz [EMAIL PROTECTED] wrote: Is Netscape issuing a new cookie on the second page because it thinks that the domain has changed? The domain doesn't change between pages. I didn't think browsers issued cookies? Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Need some ideas and help!
You can reload a frame from within another frame with: parent.otherframename.location.reload(). The reason the CF code goes off before the Javascript is because the CF is being executed on the server before the javascript ever hits the browser. -Original Message- From: Eric Homa [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 5:53 PM To: CF-Talk Subject: Need some ideas and help! Hi, I inherited an application that uses frames. There is a left frame and then a top and bottom on the right. The left and top pretty much remain static, menu links and a logo on top, category list on the left. When someone logs in they use a login page in the bottom right page. When they successfully log in they can continue with their business, most of which happens in the bottom right frame. I need for the top right and left side frames to refresh once the user has logged in. Is there a way to refresh the top and left frames without effecting the bottom right? Using cflocation does not allow for a target parameter and I cannot cflocation back to the index page which defines the frameset as it will change the bottom right frame back to the beginning. I've tried to use javascript - window.open(leftside.cfm, left) but I can't seem to update the two frames at once. Also the cflocation tag in the lower right seems to supercede the javascript even though the javascript is previous to the cflocation tag in the template. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Odd session variable behavior in a custom tag (A ghost of session variable past?)
I am running CF based on a 4.5 install. I did not do the CF install. Nor did I originally build the app. I have a little security tag that checks for the existence of a user based session variable. I do this to test whether the user is logged in. And I stick it at the top of all of my templates. The problem I am having is when someone loads the template without being logged in. Inside the custom tag, the session variable exists, but outside of the tag, the variable, correctly, does not exist. I have locks in place for the templates concerned. Where is this phantom variable coming from and how do I exorcise it? Lon Lentz Applications Developer and Keeper of the I.T. http://ProofitOnline.Com - Free 15 Day Trial __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Isdefined okays nonexistent session variable
Arghh! I have a custom tag that I use to test for a person's logged in state. I am doing: cfif isdefined(session.user.customerid) I then also test to see if the value is empty. The application is saying that the session variable exists, yet, the template within which the custom tag call is located correctly throws an error for lack of another session.user.x variable. When I email the value out of the custom tag, it has a value, yet when I cf_objectdump the session scope within that same email, it does not exist. How do I get rid of this phantom variable? Lon Lentz Applications Developer and Keeper of the I.T. http://ProofitOnline.Com - Free 15 Day Trial __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Server Union statement
select into? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, December 17, 2001 5:45 PM To: CF-Talk Subject: OT: SQL Server Union statement Hi all, I have an union statement that puts 2 cust tables together. I want to but I could not save it as a view in SQL Server for other pages.. Is there some other way to save it in SQL ? 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: Send response to browser, but continue working on request?
Sorry for my nondescript answer yesterday but I didn't have the exact answer in front of me. Use cfhttp in your kickstart template to make a post to the action template with a timeout=1. -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 4:07 PM To: CF-Talk Subject: RE: Send response to browser, but continue working on request? Thanks, that sounds good, but I was hoping to not have to use CFSCHEDULE. Any other 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: Send response to browser, but continue working on request?
I don't know how this will work if you are running both templates on the same server. We had the kickstart template on the webserver and the action template on a different machine. -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 12, 2001 10:28 AM To: CF-Talk Subject: RE: Send response to browser, but continue working on request? CFHTTP with a timeout of 1? Hmm. I got it working with CFEXECUTE (Timeout 0), but ultimately CFHTTP may be easier to use (because I can pump some cookie variables into it)... Sorry for my nondescript answer yesterday but I didn't have the exact answer in front of me. Use cfhttp in your kickstart template to make a post to the action template with a timeout=1. -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 4:07 PM To: CF-Talk Subject: RE: Send response to browser, but continue working on request? Thanks, that sounds good, but I was hoping to not have to use CFSCHEDULE. Any other 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
Hi
How are you ? When I saw this screen saver, I immediately thought about you I am in a harry, I promise you will love it! ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Capturing login and logout times
There has been some code floating around for expiring the session when the browser closes. If you think it would help you, I can search for it. -Original Message- From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 04, 2001 9:38 AM To: CF-Talk Subject: Capturing login and logout times Hi everyone. I posted a question about two weeks ago about an issue I was having with an application in which I was attempting to charge members of a site by the minute when they were logged in to a specific section. I can get a timestamp when they log in no problem, and I can get one if the session expires, but I am still looking for a solution to getting a timestamp if the browser closes either voluntarily or involuntarily. I have been looking into other language alternatives but think 90% of what I am looking for can be done using CF. Can any of the advanced developers here offer a bit more insight on how I should proceed. I have intermediate skills in CF, but I am beginning to think that charge by the minute is not a good approach, although I am working with a guy who will not budge. ~~ 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
Hi
How are you ? When I saw this screen saver, I immediately thought about you I am in a harry, I promise you will love it! ~~ 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: CFMAIL
Can you give a little more info on this? I'm just real curious. I've had similar problems in the past for which I made work arounds. Thanks. -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Friday, November 30, 2001 10:38 AM To: CF-Talk Subject: Re: CFMAIL Figured it out. We had a custom tag CF_ParagraphFormat We took out all the white space in the custom tag and the CFMAIL works now. ~~ 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: CFHTTP and FQDN
Under CF 4.5, I had this problem once when we installed a couple new webservers and the one internal cfhttp command generated continuous connection failures. It turned out to be an access permissions issue with the account that CF was running in. -Original Message- From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 27, 2001 11:16 AM To: CF-Talk Subject: CFHTTP and FQDN Searching through the Allaire forums, we see that we're not the only ones experiencing a problem with ColdFusion 5 in respect to CFHTTP and FQDNs. Specifically, a CFHTTP request to the same domain that is making the request fails. The error message is the ubiquitous CFHTTP Connection Failure. I've included the debugging information from CFDUMP below. Substituting the IP address for the domain works. In addition, substituting a domain other than the one making the request but one still pointed at the same IP address works. It would seem that ColdFusion parses a CFHTTP request for its own domain differently than in any other scenario. Perhaps this is for performance reasons? Who knows but it is clear there is a problem. Has anyone come across a real fix or been able to narrow down the cause of problem? We're experiencing the problem on Windows 2000 running IIS 5 and ColdFusion Server 5 Professional Edition, though many of the people reporting the problem in the Allaire forums seem to be running Apache on Linux. ~~ 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: Routing restrictions on exchange server
A relay is a mail transport situation where neither the sender nor the receiver is a user in the local domain. You may need to authorize relaying in Exchange for CF. Or, you need to change the domain settings for the account under which CF is running. -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 27, 2001 12:14 PM To: CF-Talk Subject: Routing restrictions on exchange server I am trying to set the routing restrictions in the connections tab on Exchange Server 5.5 SP3. This would be to allow our websites and IIS Server to use our Exchange Server to route e-mail via the website, also to stop spamming we that have been experiencing. On our developemnt server emails from all websites can be sent successfully, but externally, they are not recieved. The mail log all have the same error, Failed to send the spooled mail file, C:\CFUSION\Mail\spool\23B.cfmail. SMTP server replied Relaying is prohibited . Its obviously to do with exchange, any experience on this would be great. ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Mulitple cookie domains and sessions
The previous developer coded our site around mydomain.com. The problem is is when people come to the site via www.mydomain.com. CF issues one set of cookies for www.mydomain.com, and then, as the system is processing their login, it sets cookies for mydomain.com. CF sees this as a new session, issuing a new CFID, and dropping all of the session variables that were created by their login. Is there a simple solution to force the two to be treated as the same cookie source? Or to force the www. appenders to go to the mydomain.com domain without a cookie being issued for the www. site? Lon Lentz Applications Developer and CyberEntomolgist http://ProofitOnline.Com - Free 15 Day Trial ~~ 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: How to tell if a number is a multiple of 3?
x mod 3 eq 0 -Original Message- From: Melanie Maddix [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 9:34 AM To: CF-Talk Subject: How to tell if a number is a multiple of 3? Hello, I am trying to figure out how to use CF code to determine whether or not a variable is a multiple of 3. Does anyone have any suggestions? ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RequestTimeOut with a custom tag
How do you pass a requesttimeout when you call the template as a custom tag? Or do you put the timeout on the template calling the tag? Lon Lentz Applications Developer and CyberEntomolgist http://ProofitOnline.Com - Free 15 Day Trial ~~ 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: Frames and variable scoping
Thanks for the help. I am coming into an application that is already deployed. I'm here to fix bugs and add functionality. I am in the process of converting a lot of stuff to a few session scoped structures. The scoping going on in the frameset and frames is a little funky. My first goal is to get all of the variables passed and scoped properly. And if I had thought about how the thing was working, I would have been able to answer my question. Doh! The form thing is very slick, though. Thanks again! -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 8:43 PM To: CF-Talk Subject: RE: Frames and variable scoping Keep in mind that variables are processed server side while the frameset tags are processed client side. That means that ONLY the page you call with the form action can see the form variables - in this case that page will likely have the FRAMESET tags and nothing else. Once that page is served up the browser initiates requests for the frame sources - by this time your form variables are gone. Your only option here is to generate the frame tags on the fly using CF and put the form variables in the url string for the SRC attribute. This way when the browser makes the request for the frame source your variables will be passed in again through the url scope. You could also store the variables in a persistant scope, but it's probably not the best idea. If you do decide to do this there is one very easy way to do it: cfset session.theForm = form (this works because form is actually a struct pointer which is getting copied into the session.theForm variable) then you can access the variables later like this #session.theForm.fieldName# ~~ 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: Frames and variable scoping
Hi Kelly, Went and grabbed it. Very interesting and helpful reading. Thanks. -Original Message- From: Kelly Matthews [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 5:25 PM To: CF-Talk Subject: RE: Frames and variable scoping Check out this: http://www.cfugorama.com/cfugorama/DevCon.cfm Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ 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: Virus checking uploads
Hi Katherine, I don't know what kind of solution you are tending to be partial to, but I can speak about a product I have some experience with. It's a network based antivirus program from a company called PandaSoft. At my previous company we ran it on our internal network (which also protected all of our pop servers and checked all incoming email) and on all of our web and production servers. It will realtime monitor everything and as a file is uploaded or otherwise added to the system's drives, it will check it and remove any part of the file that is contaminated. It has very small overhead and has a browser based admin where all of your computers can be monitored and controlled realtime. -Original Message- From: Katherine Maltby [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 7:36 AM To: CF-Talk Subject: Virus checking uploads Hi, We've got to develop a facility whereby users can upload material to a server via a cfm page, but we need to have some kind of virus checking software to check all uploads first. Does anyone know of anything already out there and how much it would cost? ~~ 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
Frames and variable scoping
I have a frameset that is called through a form post. How should I refer to those posted variables within a frame inside that frameset? Do I pass them as url variables in the template call of the frame tag? Lon Lentz Applications Developer and CyberEntomolgist http://ProofitOnline.Com - Free 15 Day Trial ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: MySQL?
Have you installed MyODBC? -Original Message- From: Rich Tretola [mailto:[EMAIL PROTECTED]] Sent: Friday, October 26, 2001 3:10 PM To: CF-Talk Subject: MySQL? How can I connect to a MySQL datasource through the CF 5 admin (Windows 2000)? Rich ~~ 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: Checking file size before upload.
This is very helpful, and pretty impressive. Thank you. Ron Hornbaker [EMAIL PROTECTED] wrote in message Try as I might, I can't get your script to work. I've gone through replacing hard carriage returns with spaces where they should be (the message got wrapped), but it's not working, and not throwing any errors with IE5.5. Any chance you could put up a sample form live on the web where we could see it work? Or send it to me w/o linewraps off-list: [EMAIL PROTECTED]? Here it is: http://www.massimocorner.com/beta/js_upload.htm ~~ 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: cf_filter_duplicate_emails_from_query
Have you tried unions? Another option is to convert the email query to a list and run it through a custom tag like cfx_listsort which can sort the list and dedupe it. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 25, 2001 11:12 AM To: CF-Talk Subject: cf_filter_duplicate_emails_from_query Hello, I am querying 3 tables that all contain email addresses. What I want to do is send an email using all the email addresses. I just want to make sure there aren't duplicate e-mail when i sent the email. I need some advice on how to remove duplicates. ~~ 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
Checking file size before upload.
Is there a way to check the size of a file before the server CFFile-Uploads it? Lon Lentz Applications Developer and CyberEntomolgist http://Proof-it-Online.Com - Free 15 Day Trial ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Need decryptor tag for CFUG presentation
It would also be a violation of the Digital Millenium Copyright Act. Lon Lentz Applications Developer CyberEntomologist - Alvion Technologies DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Friday, June 08, 2001 9:50 AM To: CF-Talk Subject: Re: Need decryptor tag for CFUG presentation Saying this as Michael Dinowitz, yes. The decrypt utility is illegal according to the MM licensing contract. Correct me if I'm wrong, and I'm saying this as Ray Camden, not Ray Camden of Macromedia, but isn't use of this decryptor illegal? Should we so casually discuss a piece of a software that is probably illegal to use? Also, in general, unless you encrypt your OWN files, you should not be decrypting other people's templates. If you _do_ encrypt your files, you can contact Tech support for help. Therefore, there is no need for this software. Am I wrong here? And let's not discuss wether it's right or wrong, I'm talking about legality. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Need decryptor tag for CFUG presentation
I'm not a lawyer and this is not legal advice. But according to the federal judge in the first round of MPAA vs. 2600 in the DeCSS case, circumventing _any_ encryption on _any_ digital work, without permission from the copyright holder, is a violation of federal law. 2600 had a federal injunction to remove the program from their site and to remove all links to it. Now, I personally am not in favor of this law as it has profound impact on fair use rights and my ability to watch/listen to my purchased copy of a work anywhere I want, anyway I want, but any tool used for circumvention of encrypted copywritten works is illegal (according to this case which is in appeal). If you're interested, you can find all the specifics of the case, including all of the injunctions, the filings, and the court decisions at www.2600.com Lon Lentz Applications Developer CyberEntomologist - Alvion Technologies DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 -Original Message- From: Michael Bruce [mailto:[EMAIL PROTECTED]] Sent: Friday, June 08, 2001 11:10 AM To: CF-Talk Subject: RE: Need decryptor tag for CFUG presentation Lets be sure we understand something Is it illegal to have such a utility or is it illegal to use the utiltiy. I do believe there is a similar argument about DVDs and DeCSS??? Just a thought... Mike -Original Message- From: Lon Lentz [mailto:[EMAIL PROTECTED]] Sent: Friday, June 08, 2001 10:29 AM To: CF-Talk Subject: RE: Need decryptor tag for CFUG presentation It would also be a violation of the Digital Millenium Copyright Act. Lon Lentz Applications Developer CyberEntomologist - Alvion Technologies DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Friday, June 08, 2001 9:50 AM To: CF-Talk Subject: Re: Need decryptor tag for CFUG presentation Saying this as Michael Dinowitz, yes. The decrypt utility is illegal according to the MM licensing contract. Correct me if I'm wrong, and I'm saying this as Ray Camden, not Ray Camden of Macromedia, but isn't use of this decryptor illegal? Should we so casually discuss a piece of a software that is probably illegal to use? Also, in general, unless you encrypt your OWN files, you should not be decrypting other people's templates. If you _do_ encrypt your files, you can contact Tech support for help. Therefore, there is no need for this software. Am I wrong here? And let's not discuss wether it's right or wrong, I'm talking about legality. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Need decryptor tag for CFUG presentation
The key phrase in my explanation was permission from owner. If you own the code, it's legal to circumvent it. But by the judge's declaration in the DeCSS case, any tool used for encryption circumvention violates the DMCA. I'm not saying it's right, just what the judge said. The MPAA has won a multi-million dollar suit (still in appeal) against 2600 just for hosting a copy of the program. Lon Lentz Applications Developer CyberEntomologist - Alvion Technologies DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 -Original Message- From: Marc Edwards [mailto:[EMAIL PROTECTED]] Sent: Friday, June 08, 2001 2:17 PM To: CF-Talk Subject: Re: Need decryptor tag for CFUG presentation I don't see how the software can be illegal, as it does have legitimate use if you've lost or don't have immediate access to your unencrypted source code. How can it be illegal to circumvent encryption which you yourself applied to your own source code to which you yourself own the copyright??? And even if Macromedia tech support can decrypt it for you, sometimes you simply might not have the luxury of the time it would take to run through the process with them. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is this an Access limitation ?
Without seeing the error message, you may need a preservesinglequotes around the quotedvaluelist in the second query. Lon Lentz Applications Developer CyberEntomologist - Alvion Technologies DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 At 11:40 AM 5/31/2001 -0500, Tracy Bost wrote: The code below throws an error whenever I try to run it... What am I doing wrong ? Thanks in Advance... CFQUERY name=getproducts datasource=SQL7DATABASE SELECT partnumber FROM products WHERE manufacturer_id = 4 /CFQUERY CFQUERY name=getstuff datasource=ACCESSDATABASE SELECT item_id FROM inv_mast WHERE partnumber NOT IN(#QuotedValueList(getproducts.partnumber)#) AND manufacturer_id = 4 /CFQUERY ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF Session IDs?
I have an issue with a template that is called through a cfhttp. The problem is, when it errors and we cf_catch it, the session variables are not available to be emailed to me. Does the CF server maintain an ID system for the sessions it is supporting? If so, is it possible to pull that id out within the session? And then, is it possible to use that id outside of that session to refer to that session and its variables? Lon Lentz Applications Developer CyberEntomologist - Alvion Technologies DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Session IDs?
We are currently using CFID and CFToken for session management purposes. What I would like to be able to do is to access session variables outside of that session. We have worked a way around this whch requires serializing and then deserializing our 2 main session variables. This requires more overhead and time than I would like to spend. So I am trying to find a shortcut. And I thought if CF uses an internal id system for sessions, we might be able to reference them that way. Lon Lentz Applications Developer CyberEntomologist - Alvion Technologies DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 -Original Message- From: Robert Rusher [mailto:[EMAIL PROTECTED]] Sent: Friday, April 27, 2001 12:03 PM To: CF-Talk Subject: Re: CF Session IDs? Lon, Yes, the server automatically produces the CFID and CFToken variables for each user. You do need to code your application.cfm accordingly to take advantage of them. But, if you want to come back and access these variables at a later date, you would be better off setting client variables and store them in a backend database. HTH Regards, Rusher ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Looking for CF employee and PO expense accounting management system
We are currently looking for a CF based employee time management system. Bonuses would include expense and PO accounting. And if it worked with active directory. We would require open source for integration and future in house modifications. Lon Lentz Applications Developer CyberEntomologist - Alvion Technologies DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Detecting a mac
I use: cfif http_user_agent contains "mac" I'm interested to see if someone has anything clever. Lon Lentz Applications Developer CyberEntomologist - Alvion Technologies DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 06, 2001 1:13 PM To: CF-Talk Subject: OT: Detecting a mac Anyone know of a way to detect a Mac with IE 5 when they hit your web page? Thanks, Chad ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is there a way to run a server side executable through CF?
Are these scripts command line executables? You could use the cfx_consolecommand custom tag. Lon Lentz Applications Developer CyberEntomologist - Alvion Technologies DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 -Original Message- From: Paul Begovich [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 06, 2001 3:35 PM To: CF-Talk Subject: Is there a way to run a server side executable through CF? We have created several scripts written for NT Server that perform various server side tasks. What we want to do is execute these scripts using the CF scheduler. Is there a way to run a server side executable through CF? - Paul ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: connection limit has been reached?
There could be another issue. If CF is not releasing connections, you may be creating a slew of them and using up the available slots. Lon Lentz Applications Developer CyberEntomologist - Alvion Technologies DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 -Original Message- From: Russel Madere [mailto:[EMAIL PROTECTED]] Sent: Friday, January 19, 2001 10:29 AM To: CF-Talk Subject: RE: connection limit has been reached? If you are using Winders NT use the Lisence Manager to verify that you have the correct number of SQL and NT lisences for the servers. If necessary, purchase a few more. Russel Russel Madere, Jr. Senior Web Developer ICQ: 5446158 http://www.TurboSquid.com Some days you eat the bear; some days the bear eats you. -Original Message- From: Jay Patton [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 18, 2001 09:41 To: CF-Talk Subject: connection limit has been reached? can anyone help me with this error or atleast give me an idea of what to do about it? i get it when i try to log onto the client section of the site im working on and ive never seen this before Error Diagnostic Information ODBC Error Code = () Timed-out trying to get a connection to MYDATASOURCENAME. The connection limit has been reached. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (3:1) to (5:23) in the template file d:\??.???.???.??\Clients\Login.cfm. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Template management software compatible with CF Studio?
We are currently using Visual SourceSafe for template version control. It does a good job keeping people from stepping on others' work. Our current state of development though has moved beyond VSS' capability. Does anyone have experience with a system that works? One that ties well with CF Studio and the ways with which websites are developed? Lon Lentz Applications Developer CyberEntomologist - Alvion Technologies DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Problem with long string
I have a string within a cfloop(query). The string itself is kinda long. Inside the loop, certain query variables are placed, and the string is appended to a master string. The problem I am having is that there are roughly 10 character chunks missing from the final product. And it seems that these chunks are coming from the middle of a single string, and not at the section where one is appended. The missing characters seem to come at the same interval (I haven't counted), but I am wondering if there is some Cold Fusion limitation on string lengths. If so, how do I get around this? Lon Lentz Applications Developer CyberEntomologist - Alvion Technologies DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Need help interpreting error message.
I'll check it out. We've been using session.user for a long time. It's in our login script and is where all the user's settings are loaded in. I don't think anything in the template has changed. Although there have been a lot of other changes recently. Thanks! Lon Lentz Applications Developer CyberEntomologist - Alvion Technologies DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 -Original Message- From: David Cummins [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 07, 2000 11:31 PM To: CF-Talk Subject: Re: Need help interpreting error message. Not sure... Try two things: (a) Try a different variable name than user. (b) Try assigning it to a local variable, then setting the session variable equal to that. I wonder if session variables don't support structures... If you're using CFSCRIPT, there may be some error the line before causing it to misunderstand what session.user is. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Need help interpreting error message.
Here's a little of the code before and after the error causing line.
cfset DynaTextMode = ""
cfif IsDefined("session.user.DynaTextMode")
cfif session.user.DynaTextMode EQ "Edit"
cfset DynaTextMode = "Edit"
/cfif
/cfif
cfset session.user = structNew()
cfset session.user.systemid = sys.systemID
cfset session.user.userid = ucase(variables.userid)
cfset session.user.preferences = u2.preferences
a series of these cfsets
Lon Lentz
Applications Developer CyberEntomologist - Alvion Technologies
DataWarehousing and List Sales - Market Your Lists on the Net!
[EMAIL PROTECTED]
941-574-8600 Ext. 210
-Original Message-
From: Thomas Brown [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 07, 2000 11:05 PM
To: CF-Talk
Subject: RE: Need help interpreting error message.
can you send the code surrounding this as well???
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Need help interpreting error message.
Anyone know why we should be getting the message below? Is this an indicator that the user variable already exists? An error occurred while evaluating the expression: session.user = structNew() Error near line 199, column 7. Cannot assign result to symbol session.user Lon Lentz Applications Developer CyberEntomologist - Alvion Technologies DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Difference between CF calling the transact vs. SQL?
Is there a difference between using CFTransaction and using "begin transaction" in a regular CFQuery? Lon Lentz Applications Developer CyberEntomologist - Alvion Technologies DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Certified ColdFusion Developers
How about CF_Cert? If you have more than one Cf_Cert By="Allaire,Brainbench" Lon Lentz Applications Developer CyberEntomologist - Alvion Technologies DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 Just out of curiosity... since I notice that most of us who passed the Certification have adjusted their Sigs to say "Certified ColdFusion Developer", wouldn't it be easier to use an abbreviation? Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Allaire CF Tuning Class
Has anyone taken the 2 day CF Tuning class? How is it oriented? What's the emphasis on? Coding or server settings? Did it help you make things run smoother and/or faster? Lon Lentz Applications Developer CyberEntomologist - Alvion Technologies DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Displaying decimal part as a fraction...
Is this for dollar amounts? Always 2 decimal places? cfset displaydecimal = 100 * (x - int(x)) "/100" Lon Lentz Applications Developer CyberEntomologist - Alvion Technologies DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 -Original Message- From: Rice, David [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 01, 2000 4:20 PM To: CF-Talk Subject: RE: Displaying decimal part as a fraction... We can get the decimal part, no problem. We can also perform various rounding schemes, of course. What we actually need is for the decimal part to be "displayed" as a fraction for the user, as in: 10 over 100, or 10/100, in other words. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Insert Statement
Use a stored procedure, make a connection to the destination database, and copy the table that way? Completely bypassing CF. Lon Lentz Applications Developer CyberEntomologist - Alvion Technologies DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 -Original Message- From: Joseph Vincent [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 4:27 PM To: CF-Talk Subject: Insert Statement I am running a query that selects 49,000 records from our main database...then I'm turning right around and inserting these records into an Access database for another use. The problem is that this takes FOREVER!! (about 10-12 minutes). When I insert the records I am looping with the CFOUTPUT query = "1st query" tag and using INSERT INTO for each iteration of the loop. I'm just wondering if there is anyway to insert all of the records I selected in the 1st query at one time? _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Oracle Cold Fusion $1 million dollars
Sybase can be twice as fast as Oracle. Which is perhaps why he challenged Microsoft instead. Sybase doesn't need any middleware, and it runs great with CF. Lon Lentz Applications Developer CyberEntomologist - Alvion Technologies DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 -Original Message- From: Donovan Rittenbach [mailto:[EMAIL PROTECTED]] Sent: Friday, October 06, 2000 11:11 AM To: CF-Talk Subject: RE: Oracle Cold Fusion $1 million dollars Its performance was so fast in fact, that Larry Ellison said that he'd pay $1 million to anybody who could show a Microsoft database performing anything less than 3X slower than an Oracle database. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Error attempting to write location redirection to web server
I did a search of the MS knowledgebase using "Windows NT error number 16389 occurred" and got this: Q172101 - PRB: "Data Type Conversion Error" When Using a Data Control Here's a link to the knowledgebase. Just use the Q number above. http://search.support.microsoft.com/kb/c.asp Lon Lentz Applications Developer CyberEntomologist - Alvion Technologies DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 -Original Message- From: Eron Cohen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 26, 2000 2:41 PM To: CF-Talk Subject: Error attempting to write location redirection to web server Does anyone know what this error is referring to? Its not in the Allaire KB and others on the forums.allaire.com have asked, but nobody seems to know what exactly it means. "ERROR","TID=492","09/19/00","18:48:13","Error attempting to write location redirection to web server (Windows NT error number 16389 occurred)" I really wish there was a good resource that has a list of all the various errors you could get in your ColdFusion logs and what they mean. Thank You, Eron Cohen -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Verity: Allaire's Disowned Step Child?
Is there anyone here with experience setting Verity up? Someone willing to answer a couple questions? Lon Lentz Applications Developer CyberEntomologist - Alvion Technologies DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Verity: Allaire's Disowned Step Child?
Hi Anthony, Yeah, when I came into development, my first job was as a bug wrangler. It actually helped me to learn the system fairly quickly. And unfortunately, old habits die hard. So I still wrangle a few now and then. I've gotten a few pointers from some people. Including a FAQ and the mini-tutorial movie from Allaire's site. I'm going to give this a go again in the morning. And if I don't have any luck, I will definitely ask again. Thanks! Lon Lentz Applications Developer CyberEntomologist - Alvion Technologies DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 -Original Message- From: Anthony Geoghegan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 12:27 PM To: '[EMAIL PROTECTED]' Subject: RE: Verity: Allaire's Disowned Step Child? Hi Lon, You wrote: Is there anyone here with experience setting Verity up? Someone willing to answer a couple questions? I wrote: We have used Verity extensively here at WOW! What help do you need? Also I like the term "CyberEntomologist", interesting... -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Problem setting up Verity.
Any help with this would be greatly appreciated. I'm following Forta's book for this. I set up the collection in the administrator. I then go to studio and use the wizard. I'm trying to set it up for a directory and sub-directories that contain nothing but html. The created templates load ok. I don't get an error when I do the initial indexing. But my results come back empty. And I don't have a clue. Is there a trick to verity? Lon Lentz Applications Developer CyberEntomologist - Alvion Technologies DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF not letting go of database connection?
I would only suggest this if you absolutely know the maximum time for any request from the table. In your config file there is a setting, TI, which is client idle time before shutdown. It defaults to 240 minutes I believe. You can adjust this. Now, if there is idle time between the CF request and the database filling that request, and you set this time to be too short, it will drop the connection before the request is sent back. Lon Lentz Applications Developer CyberEntomologist - Alvion Technologies DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 -Original Message- From: Boris [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 31, 2000 1:21 PM To: [EMAIL PROTECTED] Subject: CF not letting go of database connection? I have a number CF based pages that once the query is completed with the data presented it will not let go of the database connection to my Sybase SQL Anywhere database. Even after the page has been exited. Any suggestion would be appreciated. Boris -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: variable does not exist
cfparam name="session.user" default="" !--- then put --- cfif '#Session.User#' IS "" cflocation url="login.cfm" /cfif Lon Lentz Applications Developer - Alvion Technologies DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 -Original Message- From: Jamie Symonds [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 10, 2000 9:53 AM To: [EMAIL PROTECTED] Subject: "variable does not exist" This is secure.cfm: !--- User has yet to login --- cfif '#Session.User#' IS "" cflocation url="login.cfm" /cfif Is there a way that I can say [if variable Session.User does not exisit, create Session.User with value ""]? This would default to login.cfm? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SQL Server errors
Just an idea: Do you have the SQL Server service running under a user with insufficient access rights? Lon Lentz Applications Developer - Alvion Technologies DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 09, 2000 8:34 AM To: [EMAIL PROTECTED] Subject: SQL Server errors I've been getting the following SQL Server errors in the event log over and over. Any idea what these mean? === Source: SQLExecutive Type: Error Category: Alert Engine Description: Unable to read local EventLog. Reason: Invalid access to memory location. === Thanks, Howie Hamlin -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: How to get part of string?
Won't that return: is a really It starts at position 6 and returns the next 11 characters? Lon Lentz Applications Developer - Alvion Technologies DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 -Original Message- From: Shane Pitts [mailto:[EMAIL PROTECTED]] Sent: Friday, August 04, 2000 6:55 PM To: [EMAIL PROTECTED] Subject: RE: How to get part of string? CFSET original_string = "this is a really short message" CFSET new_string = mid(original_string, 6, 11) new string = "is a r" message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFTRANSACTION
"Undoing" what you just did. Lon Lentz Applications Developer - Alvion Technologies DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 -Original Message- From: Chad [mailto:[EMAIL PROTECTED]] Sent: Monday, August 07, 2000 3:05 PM To: [EMAIL PROTECTED] Subject: CFTRANSACTION Can someone explain what the book means by "CFTRANSACTION implements transaction,and rollback processing."??? What is roll back processing? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: substituting variables in a variable
I've tried this before with no luck. I use place holders and do replaces on those values. Lon Lentz Applications Developer - Alvion Technologies DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 -Original Message- From: Neil Peaslee [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 26, 2000 10:17 AM To: cf-talk Subject: substituting variables in a variable I am trying to set up a mail system that can grab text from a database and insert it into a mail message. I also need to customize the text of the message (e.g. Dear #first_name# evaluates to Dear John). The problem arises when I insert the mail text variable into the cfmail tag. The variables that are contained in the text message are not evaluated. cfmail .. #mail_message# /cfmail This will output "Dear #first_name#, ..." How do I get the sub variable to be evaluated? Thanks in advance, Neil -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: How the heck can I do this?
Use a counter to count rows. cfif RowNum Mod 5 eq 0#BidAmount#/cfif Lon Lentz Applications Developer - Alvion Technologies DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 06, 2000 8:19 AM To: [EMAIL PROTECTED] Subject: How the heck can I do this? With the output method, I can't seem to be able to get the results to populate the 5th bid amt., but not the first 4. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: My experience with Sybase
We use ASIQ 12. Our system averages 2,000 counts a day from 500 million records. We find that it runs roughly 70% faster than SQL Server. Now, if you're running under 10 million records, that may not hold. And our Cold Fusion system loves it. We have not experienced your apparent problems with their support and technical staff. Lon Lentz Applications Developer - GetLists.Com DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 -Original Message- From: Karl Simanonok [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 22, 2000 1:05 PM To: [EMAIL PROTECTED] Subject: My experience with Sybase My experience with Sybase has been that the company is incompetent about technical matters regarding their own products, nonresponsive to support issues and even to potential buyers, and their database is a dinosaur that performs poorly compared to SQL Server or Oracle. Based on my experience with that flaky company, I wouldn't use Sybase if they gave it to me. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: How to stop an infinite CF loop?
We didn't shut the service down right away because what it was doing was mild and our live system had people logged in and was running counts and orders. We has access to the code. We tried forcing the template to error out, but the system had cached it and was ignoring all the updates we were making. We checked for scheduling. We're just looking for a way to deal with situations like this from a remote location. We've been considering the custom tag that allows control of services. I was hoping there was another way other than shutting down the service. Lon Lentz Applications Developer - GetLists.Com DataWarehousing and List Sales - Market your lists on the Net! [EMAIL PROTECTED] 941-541-9000 Ext. 210 -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Monday, June 19, 2000 7:47 PM To: [EMAIL PROTECTED] Subject: Re: How to stop an infinite CF loop? I can't believe you didn't immediately shut down the CF server if you suspected there was a template running amok. I'm aware of only two things that would cause a working template to terminate prematurely. The first is if the request timeout is met. You have a default template timeout set for the CF server in the Administrator, but if the template were called with ?RequestTimeout=xx, it is overridden. Trouble with this is that anyone can alter the request timeout by simply putting that url parameter in the request. The other would be to kill the CF application server. There might have been some other things you could have done to either cause an error or alleviate the problem. If you knew what the rogue template was doing, and had access to the code you could do this. You might have shut down the email server, for example. None of those would have been nearly as effective as simply shutting down CF server. One thing you'd need to watch out for would be whether the template had scheduled itself using CFSCHEDULE to start up again at a later time. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
