RE: DSN-less connection to a CSV file?
Well I have the CFX_CSVtoQuery tag, I've installed it, and I can read in comma delimited text files but not these CSV files I needed to use in the first place. It reads the file but says zero rows processed. When I open the .csv file in my trusty UltraEdit, it asks if I want to convert it to DOS format, so I took a look at the .csv file in hex and the line endings only have 0A not 0D 0A. (in other words a line feed, not carriage return line feed) So I think the tag only recognises the file as a single line. Anyone know what I can do about this? I can't have the information supplier make any change to the files - its' created automatically and FTP'd into our site anew every day. Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks IF you're interested here's some extra data - the first few lines of one of the files concerned (can't post more for copyright reasons), plus the code I'm trying to use to access it. First the file: Cash Management Accounts - $1,000.00 "Institution Name","Account/Product Name","Effective Rate","Nominal Rate","Website Link","Customer Service Phone" "Institution Number One","Youbeauty Account",4.8025,4.70,"http://www.institutionone.com.au","1800-666-666"; "Institution number two","Cash Management Account",4.3337,4.25,"http://www.institutiontwo.com.au","1800-555-555"; Now the code: Rows Read: #CSV_RowsProcessed# Bad Rows: #CSV_BadRows# ReachedEOF: #CSV_ReachedEOF# StartRow: #CSV_StartRow# And this results in a page that shows the following: Rows Read: 0 Bad Rows: ReachedEOF: YES StartRow: 1 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: DSN-less connection to a CSV file?
Brook, Yes, yes, yes, and yes. ;-) Although, I'm not sure about deleting the connection. When I've used it I've never considered or addressed this. Do you need to? D'uh I dunno. - Original Message - From: "brook" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, October 29, 2002 6:44 PM Subject: RE: DSN-less connection to a CSV file? > Mathew, > > So this allows you to query the CSV directly? Would this method work for > importing data into an existing table by looping over the resulting query > and doing the insert? Can you then delete the file and the connection? > > If the csv file contained field names in the first row, is this what you > get back as columns? > > Brook > > > At 04:33 PM 10/29/02 +1300, you wrote: > >This is how we've been doing it: > > > > > > > > > > SELECT * > > FROM[#file#] > > ORDER BYmyColumn > > > > > >fulldirectorypath is the directory not the file. file is the filename > >excluding the extension. > > > >Matthew Walker > >http://www.matthewwalker.net.nz/ > > > > > > > > > > > -Original Message- > > > From: Michael Kear [mailto:mkear@;afpwebworks.com] > > > Sent: Tuesday, 29 October 2002 4:22 p.m. > > > To: CF-Talk > > > Subject: DSN-less connection to a CSV file? > > > > > > > > > I have an information provider FTP'ing a series of .csv files > > > into my server > > > every night, and I need to use these files to create dynamic > > > tables for > > > users. Since they are updated every day, I can't have them > > > locked and in > > > use when the provider's automatic ftp dumps them into my site. > > > > > > So what I wanted to do was set my calculator up so that when > > > my site user > > > calls the information, the page connects to the .csv table, > > > does the query > > > then disconnects again. > > > > > > Is this (a) possible? (b) the best way to access (only read > > > - not write or > > > update) the .csv files so that they are not locked when the > > > ftp program > > > comes to drop new ones on the server? If so, can someone > > > please give me > > > the code to connect to the .csv file? > > > > > > (we're using CF5) There's no documentation at all about > > > dsnless connection > > > in the docs, and I haven't been able to find any thing in the > > > archives of > > > this list or any other. > > > > > > > > > Cheers, > > > Mike Kear > > > Windsor, NSW, Australia > > > AFP WebWorks > > > > > > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Replacement for CFX_fMAKETREE
Thx, very much, but Michael fixed me up. Cheers, --Matt-- -Original Message- From: Scott Weikert [mailto:scott@;alphageek.com] Sent: Monday, October 28, 2002 9:22 PM To: CF-Talk Subject: Re: Replacement for CFX_fMAKETREE Not sure if you're still in need... I wrote a CustomTag at work to do a nested tree in a select form field. If you want, I'll toss it your way tomorrow (Tuesday) morning when I get to work. You can pass a few things into it, so you can pre-select something farther down in the tree, if you need. It also does the DB queries for you (you pass datasource, tablename, ID field, parentID field into it). Le'me know. --Scott ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: DSN-less connection to a CSV file?
http://www.basic-ultradev.com/articles/dsnlesscoldfusion/ At 09:44 PM 10/28/02 -0800, you wrote: >Mathew, > >So this allows you to query the CSV directly? Would this method work for >importing data into an existing table by looping over the resulting query >and doing the insert? Can you then delete the file and the connection? > >If the csv file contained field names in the first row, is this what you >get back as columns? > >Brook > > >At 04:33 PM 10/29/02 +1300, you wrote: > >This is how we've been doing it: > > > > > > > > > > SELECT * > > FROM[#file#] > > ORDER BYmyColumn > > > > > >fulldirectorypath is the directory not the file. file is the filename > >excluding the extension. > > > >Matthew Walker > >http://www.matthewwalker.net.nz/ > > > > > > > > > > > -Original Message- > > > From: Michael Kear [mailto:mkear@;afpwebworks.com] > > > Sent: Tuesday, 29 October 2002 4:22 p.m. > > > To: CF-Talk > > > Subject: DSN-less connection to a CSV file? > > > > > > > > > I have an information provider FTP'ing a series of .csv files > > > into my server > > > every night, and I need to use these files to create dynamic > > > tables for > > > users. Since they are updated every day, I can't have them > > > locked and in > > > use when the provider's automatic ftp dumps them into my site. > > > > > > So what I wanted to do was set my calculator up so that when > > > my site user > > > calls the information, the page connects to the .csv table, > > > does the query > > > then disconnects again. > > > > > > Is this (a) possible? (b) the best way to access (only read > > > - not write or > > > update) the .csv files so that they are not locked when the > > > ftp program > > > comes to drop new ones on the server? If so, can someone > > > please give me > > > the code to connect to the .csv file? > > > > > > (we're using CF5) There's no documentation at all about > > > dsnless connection > > > in the docs, and I haven't been able to find any thing in the > > > archives of > > > this list or any other. > > > > > > > > > Cheers, > > > Mike Kear > > > Windsor, NSW, Australia > > > AFP WebWorks > > > > > > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: DSN-less connection to a CSV file?
Mathew, So this allows you to query the CSV directly? Would this method work for importing data into an existing table by looping over the resulting query and doing the insert? Can you then delete the file and the connection? If the csv file contained field names in the first row, is this what you get back as columns? Brook At 04:33 PM 10/29/02 +1300, you wrote: >This is how we've been doing it: > > > > > SELECT * > FROM[#file#] > ORDER BYmyColumn > > >fulldirectorypath is the directory not the file. file is the filename >excluding the extension. > >Matthew Walker >http://www.matthewwalker.net.nz/ > > > > > > -Original Message- > > From: Michael Kear [mailto:mkear@;afpwebworks.com] > > Sent: Tuesday, 29 October 2002 4:22 p.m. > > To: CF-Talk > > Subject: DSN-less connection to a CSV file? > > > > > > I have an information provider FTP'ing a series of .csv files > > into my server > > every night, and I need to use these files to create dynamic > > tables for > > users. Since they are updated every day, I can't have them > > locked and in > > use when the provider's automatic ftp dumps them into my site. > > > > So what I wanted to do was set my calculator up so that when > > my site user > > calls the information, the page connects to the .csv table, > > does the query > > then disconnects again. > > > > Is this (a) possible? (b) the best way to access (only read > > - not write or > > update) the .csv files so that they are not locked when the > > ftp program > > comes to drop new ones on the server? If so, can someone > > please give me > > the code to connect to the .csv file? > > > > (we're using CF5) There's no documentation at all about > > dsnless connection > > in the docs, and I haven't been able to find any thing in the > > archives of > > this list or any other. > > > > > > Cheers, > > Mike Kear > > Windsor, NSW, Australia > > AFP WebWorks > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: Replacement for CFX_fMAKETREE
Not sure if you're still in need... I wrote a CustomTag at work to do a nested tree in a select form field. If you want, I'll toss it your way tomorrow (Tuesday) morning when I get to work. You can pass a few things into it, so you can pre-select something farther down in the tree, if you need. It also does the DB queries for you (you pass datasource, tablename, ID field, parentID field into it). Le'me know. --Scott ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: Replacement for CFX_fMAKETREE
I'll have to check if the docs say that explicitly. I like to pass queries in rather than pass the query name and then have the custom tag go back out to actually get the query. > DOH! > > Thanks, Michael. That of course did it. > > --Matt-- > > > > -Original Message- > From: Michael Dinowitz [mailto:mdinowit@;houseoffusion.com] > Sent: Monday, October 28, 2002 7:21 PM > To: CF-Talk > Subject: Re: Replacement for CFX_fMAKETREE > > > Your not passing a query. Your passing a query name. Try putting pounds > around the query name. > > #myQuery# > > > I Need a hand with CF_MakeTree. I'm not familiar with reading query > output into a tag attribute and I'm screwing it up as a result. If I > simply > do this, then I get the following error: > > > > > datasource="#request.SiteDSN#" > > name="GetTopics"> > > SELECT > > cm_topics.ID AS ItemID, > > cm_topics.ParentID AS ParentItemID > > FROM cm_topics > > WHERE > > 0=0 > > > > > Query="myQuery" > > Result="GotEm" > > Unique="ItemID" > > Parent="ParentItemID"> > > > > MESSAGE: Invalid parameter type > > DETAIL: The passed value does not evaluate to a valid query object > > > > If I instead use QueryNew, QuerySetCell etc. to build a query and try > and > feed the thing in, I get identical results. > > > > Can anyone tell me what I'm missing here? > > > > --Matt Robertson-- > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Replacement for CFX_fMAKETREE
DOH! Thanks, Michael. That of course did it. --Matt-- -Original Message- From: Michael Dinowitz [mailto:mdinowit@;houseoffusion.com] Sent: Monday, October 28, 2002 7:21 PM To: CF-Talk Subject: Re: Replacement for CFX_fMAKETREE Your not passing a query. Your passing a query name. Try putting pounds around the query name. #myQuery# > I Need a hand with CF_MakeTree. I'm not familiar with reading query output into a tag attribute and I'm screwing it up as a result. If I simply do this, then I get the following error: > > datasource="#request.SiteDSN#" > name="GetTopics"> > SELECT > cm_topics.ID AS ItemID, > cm_topics.ParentID AS ParentItemID > FROM cm_topics > WHERE > 0=0 > > Query="myQuery" > Result="GotEm" > Unique="ItemID" > Parent="ParentItemID"> > > MESSAGE: Invalid parameter type > DETAIL: The passed value does not evaluate to a valid query object > > If I instead use QueryNew, QuerySetCell etc. to build a query and try and feed the thing in, I get identical results. > > Can anyone tell me what I'm missing here? > > --Matt Robertson-- > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: DSN-less connection to a CSV file?
I think I got the information from an MS page rather than a CF page. > Persist Security Info I feel it relates more to ODBC connection strings than to the text driver specifically. But I'm just guessing... > -Original Message- > From: Michael Kear [mailto:mkear@;afpwebworks.com] > Sent: Tuesday, 29 October 2002 4:47 p.m. > To: CF-Talk > Subject: RE: DSN-less connection to a CSV file? > > > Thanks Matthew! That looks exactly like what I'm needing. > Is there any > documentation anywhere about DSNless connections? For > example, I'd be > interested to know what the Persist Security Info parameter > does. I presume > that is what makes the server hold on to the connection or > not but it'd be > nice to be able to know for sure. > > Cheers, > Mike Kear > Windsor, NSW, Australia > AFP WebWorks > > > -Original Message- > From: Matthew Walker [mailto:Matthew@;cabbagetree.co.nz] > Sent: Tuesday, 29 October 2002 2:34 PM > To: CF-Talk > Subject: RE: DSN-less connection to a CSV file? > > This is how we've been doing it: > > > > > SELECT * > FROM[#file#] > ORDER BYmyColumn > > > fulldirectorypath is the directory not the file. file is the filename > excluding the extension. > > Matthew Walker > http://www.matthewwalker.net.nz/ > > > > > > -Original Message- > > From: Michael Kear [mailto:mkear@;afpwebworks.com] > > Sent: Tuesday, 29 October 2002 4:22 p.m. > > To: CF-Talk > > Subject: DSN-less connection to a CSV file? > > > > > > I have an information provider FTP'ing a series of .csv files > > into my server > > every night, and I need to use these files to create dynamic > > tables for > > users. Since they are updated every day, I can't have them > > locked and in > > use when the provider's automatic ftp dumps them into my site. > > > > So what I wanted to do was set my calculator up so that when > > my site user > > calls the information, the page connects to the .csv table, > > does the query > > then disconnects again. > > > > Is this (a) possible? (b) the best way to access (only read > > - not write or > > update) the .csv files so that they are not locked when the > > ftp program > > comes to drop new ones on the server? If so, can someone > > please give me > > the code to connect to the .csv file? > > > > (we're using CF5) There's no documentation at all about > > dsnless connection > > in the docs, and I haven't been able to find any thing in the > > archives of > > this list or any other. > > > > > > Cheers, > > Mike Kear > > Windsor, NSW, Australia > > AFP WebWorks > > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: OT Tracking a CFMX bug
You're using 1.4.1 developer preview? CFMX doesn't work with that it seems. On Monday, Oct 28, 2002, at 14:11 US/Pacific, Dick Applebaum wrote: > I have a situation where i create and save a simple cfm template, then > access it with a browser > > The following takes place: > > 1) the template is parsed > > 2) the Java source is generated > > 3) the .java file is saved. > > 4) I get an error before the.class file is saved > > The error is below -- just a single line stack trace. > > The question: How do I determine what portion of CFMX is in control > when the error occurs? > > > TIA > > > Dick > > > > The Error: > > > Error occurred while processing request! > > Please try the following: > > * Check the CFML Reference Manual to verify that you are using the > correct syntax. > * Search the Knowledge Base to find a solution to your problem. > > > > Browser Mozilla/4.0 (compatible; MSIE 5.22; Mac_PowerPC) > Remote Address 127.0.0.1 > Referrerhttp://127.0.0.1:8500/mycfmxapps/ > Date/Time 28-Oct-02 02:05 PM > Stack Trace (click to expand) > > > [Ljava.lang.StackTraceElement;@c127d > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: What advantages does Java 1.4.1 bring to CFMX?
On Monday, Oct 28, 2002, at 08:06 US/Pacific, Mark Johnson wrote: > Since you replied Sean, what is Macromedia's offical response > regarding JRE > version. I had asked this here before with no response. Which JRE > does > Macromedia endorse? Seems unclear as CFMX shipped with 1.3 but > portions of > the documentation speak of 1.4 and 1.4.1 has several severe issues > with MX. I was hoping someone from the product team would answer that. I can't answer it because I'm 'only' a user of the product. Sorry. An Architect's View -- http://www.corfield.org/blog/ Macromedia DevCon 2002, October 27-30, Orlando, Florida Architecting a New Internet Experience Register today at http://www.macromedia.com/go/devcon2002 An Architect's View -- http://www.corfield.org/blog/ Macromedia DevCon 2002, October 27-30, Orlando, Florida Architecting a New Internet Experience Register today at http://www.macromedia.com/go/devcon2002 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: [OT] FlashCom Server High CPU Utilization
opps .. i need to add something. This high utilization only occurs when i connect my webcam to the flash comm server. Else, it's working fine even with the chat. I think this issue is quite different from Joachem's post earlier with regards to chat.asc which had to be re-written. I find patching the communicationcomponents from MM site solves the problem and along you'll get the CommsComponent for FlashMX. Someone took away my web cam now and i couldn't test exactly which service that gives me such a high CPU. I reckon it could be FlashCom.exe service. Otherwise, others are functioning normally. thanks. Anthony -Original Message- From: Stacy Young [mailto:Stacy.Young@;sfcommerce.com] Sent: Tuesday, October 29, 2002 11:32 AM To: CF-Talk Subject: RE: [OT] FlashCom Server High CPU Utilization Something's definitely wrong...mine idles around 9mb ram or so... -Original Message- From: Anthony Wong [mailto:anthony@;intracomm.com] Sent: Monday, October 28, 2002 10:23 PM To: CF-Talk Subject: [OT] FlashCom Server High CPU Utilization I'm trying out Flash Comm on my laptop and noticed that the CPU utilization level stays above 95% average all the time when the app is running off the browser. Might have occasional dip but it didn't last for long as it shoots up right away. When the browser is closed, the CPU simply goes back to normal (1-3%) Here's my config: Pentium III 500 Windows 2000 IE 5.5 SP2 256 MB RAM (I read that's the minimum for Flash Comm) CFMX server service is off Anyone else experianced the same thing? It's burning my laptop too. I can feel the heat through the keyboard while running the flash comm app even for a short period of time. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: DSN-less connection to a CSV file?
Thanks Matthew! That looks exactly like what I'm needing. Is there any documentation anywhere about DSNless connections? For example, I'd be interested to know what the Persist Security Info parameter does. I presume that is what makes the server hold on to the connection or not but it'd be nice to be able to know for sure. Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -Original Message- From: Matthew Walker [mailto:Matthew@;cabbagetree.co.nz] Sent: Tuesday, 29 October 2002 2:34 PM To: CF-Talk Subject: RE: DSN-less connection to a CSV file? This is how we've been doing it: SELECT * FROM[#file#] ORDER BYmyColumn fulldirectorypath is the directory not the file. file is the filename excluding the extension. Matthew Walker http://www.matthewwalker.net.nz/ > -Original Message- > From: Michael Kear [mailto:mkear@;afpwebworks.com] > Sent: Tuesday, 29 October 2002 4:22 p.m. > To: CF-Talk > Subject: DSN-less connection to a CSV file? > > > I have an information provider FTP'ing a series of .csv files > into my server > every night, and I need to use these files to create dynamic > tables for > users. Since they are updated every day, I can't have them > locked and in > use when the provider's automatic ftp dumps them into my site. > > So what I wanted to do was set my calculator up so that when > my site user > calls the information, the page connects to the .csv table, > does the query > then disconnects again. > > Is this (a) possible? (b) the best way to access (only read > - not write or > update) the .csv files so that they are not locked when the > ftp program > comes to drop new ones on the server? If so, can someone > please give me > the code to connect to the .csv file? > > (we're using CF5) There's no documentation at all about > dsnless connection > in the docs, and I haven't been able to find any thing in the > archives of > this list or any other. > > > Cheers, > Mike Kear > Windsor, NSW, Australia > AFP WebWorks > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: [OT] FlashCom Server High CPU Utilization
- There is an error in line 84 of the chat.asc file installed in the server's scriptlib/components directory. Incorrect : this.history.unshift(); Correct: this.history.shift();" - This address is filtered through the open relay database at http://www.ordb.org and is virus scanned by ANTIVIR http://www.dwhite.ws mailto:doug@;dwhite.ws - Original Message - From: "Anthony Wong" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, October 28, 2002 9:23 PM Subject: [OT] FlashCom Server High CPU Utilization | I'm trying out Flash Comm on my laptop and noticed that the CPU utilization | level stays above 95% average all the time when the app is running off the | browser. | Might have occasional dip but it didn't last for long as it shoots up right | away. When the browser is closed, the CPU simply goes back to normal (1-3%) | | Here's my config: | | Pentium III 500 | Windows 2000 | IE 5.5 SP2 | 256 MB RAM (I read that's the minimum for Flash Comm) | CFMX server service is off | | Anyone else experianced the same thing? It's burning my laptop too. I can | feel the heat through the keyboard while running the flash comm app even for | a short period of time. | | | | ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Coldfusion Message - Oracle Error Code = 0
The company that I am working for, is periodically, bombarded with the following error message: Coldfusion Error Type - DATABASE Coldfusion Message - Oracle Error Code = 0 Timeout while obtaining an Oracle connection lock They are running CF 5 with Oracle 8i on the backend and are using the native drivers to connect to Oracle. I have searched high and low, but have not been able to find a definitive solution. Has anyone run into this error and found a solution? Gary Groomer ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: DSN-less connection to a CSV file?
This is how we've been doing it: SELECT * FROM[#file#] ORDER BYmyColumn fulldirectorypath is the directory not the file. file is the filename excluding the extension. Matthew Walker http://www.matthewwalker.net.nz/ > -Original Message- > From: Michael Kear [mailto:mkear@;afpwebworks.com] > Sent: Tuesday, 29 October 2002 4:22 p.m. > To: CF-Talk > Subject: DSN-less connection to a CSV file? > > > I have an information provider FTP'ing a series of .csv files > into my server > every night, and I need to use these files to create dynamic > tables for > users. Since they are updated every day, I can't have them > locked and in > use when the provider's automatic ftp dumps them into my site. > > So what I wanted to do was set my calculator up so that when > my site user > calls the information, the page connects to the .csv table, > does the query > then disconnects again. > > Is this (a) possible? (b) the best way to access (only read > - not write or > update) the .csv files so that they are not locked when the > ftp program > comes to drop new ones on the server? If so, can someone > please give me > the code to connect to the .csv file? > > (we're using CF5) There's no documentation at all about > dsnless connection > in the docs, and I haven't been able to find any thing in the > archives of > this list or any other. > > > Cheers, > Mike Kear > Windsor, NSW, Australia > AFP WebWorks > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: [OT] FlashCom Server High CPU Utilization
Something's definitely wrong...mine idles around 9mb ram or so... -Original Message- From: Anthony Wong [mailto:anthony@;intracomm.com] Sent: Monday, October 28, 2002 10:23 PM To: CF-Talk Subject: [OT] FlashCom Server High CPU Utilization I'm trying out Flash Comm on my laptop and noticed that the CPU utilization level stays above 95% average all the time when the app is running off the browser. Might have occasional dip but it didn't last for long as it shoots up right away. When the browser is closed, the CPU simply goes back to normal (1-3%) Here's my config: Pentium III 500 Windows 2000 IE 5.5 SP2 256 MB RAM (I read that's the minimum for Flash Comm) CFMX server service is off Anyone else experianced the same thing? It's burning my laptop too. I can feel the heat through the keyboard while running the flash comm app even for a short period of time. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
DSN-less connection to a CSV file?
I have an information provider FTP'ing a series of .csv files into my server every night, and I need to use these files to create dynamic tables for users. Since they are updated every day, I can't have them locked and in use when the provider's automatic ftp dumps them into my site. So what I wanted to do was set my calculator up so that when my site user calls the information, the page connects to the .csv table, does the query then disconnects again. Is this (a) possible? (b) the best way to access (only read - not write or update) the .csv files so that they are not locked when the ftp program comes to drop new ones on the server? If so, can someone please give me the code to connect to the .csv file? (we're using CF5) There's no documentation at all about dsnless connection in the docs, and I haven't been able to find any thing in the archives of this list or any other. Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
[OT] FlashCom Server High CPU Utilization
I'm trying out Flash Comm on my laptop and noticed that the CPU utilization level stays above 95% average all the time when the app is running off the browser. Might have occasional dip but it didn't last for long as it shoots up right away. When the browser is closed, the CPU simply goes back to normal (1-3%) Here's my config: Pentium III 500 Windows 2000 IE 5.5 SP2 256 MB RAM (I read that's the minimum for Flash Comm) CFMX server service is off Anyone else experianced the same thing? It's burning my laptop too. I can feel the heat through the keyboard while running the flash comm app even for a short period of time. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: Replacement for CFX_fMAKETREE
Your not passing a query. Your passing a query name. Try putting pounds around the query name. #myQuery# > I Need a hand with CF_MakeTree. I'm not familiar with reading query output into a tag attribute and I'm screwing it up as a result. If I simply do this, then I get the following error: > > datasource="#request.SiteDSN#" > name="GetTopics"> > SELECT > cm_topics.ID AS ItemID, > cm_topics.ParentID AS ParentItemID > FROM cm_topics > WHERE > 0=0 > > Query="myQuery" > Result="GotEm" > Unique="ItemID" > Parent="ParentItemID"> > > MESSAGE: Invalid parameter type > DETAIL: The passed value does not evaluate to a valid query object > > If I instead use QueryNew, QuerySetCell etc. to build a query and try and feed the thing in, I get identical results. > > Can anyone tell me what I'm missing here? > > --Matt Robertson-- > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Replacement for CFX_fMAKETREE
Hi Mike, Unfortunately that's just a typo, made while I was pasting code and rearranging it for the msg. Same error w/the code below (I renamed the tag to match up w/my own filing system). I'm using CF 4.5.1SP2. Is that an issue, I wonder? The tag blows up on Line 11, which is the cfparam for the query var. SELECT cm_topics.ID AS ItemID, cm_topics.ParentID AS ParentItemID FROM cm_topics WHERE 0=0 #GotEm.ItemID#_#GotEm.ItemID#, #GotEm.MakeTreeSortLevel# --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
cf to xml display
is it possible to convert xml to cfml, i guess using wddx stuff and still have the xsl document referred to in the xml document decide and display the presentation? thanks. ...tony tony weeg [EMAIL PROTECTED] www.revolutionwebdesign.com rEvOlUtIoN wEb DeSiGn 410.334.6331 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Replacement for CFX_fMAKETREE
Matt, what I can see is your query nmae and query output name are different. Query="myQuery" Maybe I'm mis-reading the code and I don't know CFX-Maketree but I think those names should be the same. Kind Regards - Mike Brunt, CTO Webapper http://www.webapper.com Downey CA Office 562.243.6255 AIM - webappermb "Webapper - Making the NET work" -Original Message- From: Matt Robertson [mailto:matt@;mysecretbase.com] Sent: Monday, October 28, 2002 4:38 PM To: CF-Talk Subject: Replacement for CFX_fMAKETREE I Need a hand with CF_MakeTree. I'm not familiar with reading query output into a tag attribute and I'm screwing it up as a result. If I simply do this, then I get the following error: SELECT cm_topics.ID AS ItemID, cm_topics.ParentID AS ParentItemID FROM cm_topics WHERE 0=0 MESSAGE: Invalid parameter type DETAIL: The passed value does not evaluate to a valid query object If I instead use QueryNew, QuerySetCell etc. to build a query and try and feed the thing in, I get identical results. Can anyone tell me what I'm missing here? --Matt Robertson-- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Invoking a CFC from Java?
You may be right but I'd still like to try...looking at a compiled cfm template with a single CFINVOKE statement generates the following: Any tips on how to strip it down and include some basic error handling? :-) import coldfusion.runtime.*; import coldfusion.tagext.GenericTag; import coldfusion.tagext.lang.InvokeArgumentTag; import coldfusion.tagext.lang.InvokeTag; import javax.servlet.jsp.JspWriter; import javax.servlet.jsp.tagext.BodyContent; public final class cftest22ecfm892357642 extends CFPage { protected final Object runPage() throws Throwable { out = super.pageContext.getOut(); InvokeTag invoke0 = (InvokeTag)_initTag(class0, 0, super.parent); invoke0.setComponent("zeus.api.Notification"); invoke0.setMethod("create"); int mode0; if((mode0 = invoke0.doStartTag()) != 0) try { if(mode0 == 2) { out = super.pageContext.pushBody(); invoke0.setBodyContent((BodyContent)out); invoke0.doInitBody(); } do { _whitespace(out, "\n\t"); InvokeArgumentTag invokeargument1 = (InvokeArgumentTag)_initTag(class1, 1, invoke0); invokeargument1.setName("email"); invokeargument1.setValue("EMAIL"); if(CfJspPage._emptyTag(invokeargument1)) { Object obj = null; return obj; } _whitespace(out, "\n"); } while(invoke0.doAfterBody() != 0); } finally { if(mode0 == 2) out = super.pageContext.popBody(); } if(invoke0.doEndTag() == 5) return null; else return null; } public final Object getMetadata() { return metaData; } static Class _mthclass$(String s) { try { return Class.forName(s); } catch(ClassNotFoundException classnotfoundexception) { throw new NoClassDefFoundError(classnotfoundexception.getMessage()); } } public cftest22ecfm892357642() { } private static final String sourceFile = "C:\\CFusionMX\\wwwroot\\zeus\\test2.cfm"; static Object metaData = new AttributeCollection(new Object[0]); static final Class class1; static final Class class0; protected JspWriter out; static final { class1 = coldfusion.tagext.lang.InvokeArgumentTag.class; class0 = coldfusion.tagext.lang.InvokeTag.class; } } -Original Message- From: Matt Liotta [mailto:mliotta@;r337.com] Sent: Monday, October 28, 2002 8:36 PM To: CF-Talk Subject: RE: Invoking a CFC from Java? I can't give you an example, but I can tell you it is not easy and certainly not worth it. Matt Liotta President & CEO Montara Software, Inc. http://www.montarasoftware.com/ 888-408-0900 x901 > -Original Message- > From: Stacy Young [mailto:Stacy.Young@;sfcommerce.com] > Sent: Monday, October 28, 2002 8:27 PM > To: CF-Talk > Subject: Invoking a CFC from Java? > > Anyone have an example on how to do this? > > Cheers, > > Stace > > > AVIS IMPORTANT: > --- > Les informations contenues dans le present document et ses pieces jointes > sont strictement confidentielles et reservees a l'usage de la (des) > personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, > soyez avise que toute divulgation, distribution, copie, ou autre > utilisation de ces informations est strictement prohibee. Si vous avez > recu ce document par erreur, veuillez s'il vous plait communiquer > immediatement avec l'expediteur et detruire ce document sans en faire de > copie sous quelque forme. > > WARNING: > --- > The information contained in this document and attachments is confidential > and intended only for the person(s) named above. If you are not the > intended recipient you are hereby notified that any disclosure, copying, > distribution, or any other use of the information is strictly prohibited. > If you have received this document by mistake, please notify the sender > immediately and destroy this document and attachments without making any > copy of any kind. > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Invoking a CFC from Java?
I can't give you an example, but I can tell you it is not easy and certainly not worth it. Matt Liotta President & CEO Montara Software, Inc. http://www.montarasoftware.com/ 888-408-0900 x901 > -Original Message- > From: Stacy Young [mailto:Stacy.Young@;sfcommerce.com] > Sent: Monday, October 28, 2002 8:27 PM > To: CF-Talk > Subject: Invoking a CFC from Java? > > Anyone have an example on how to do this? > > Cheers, > > Stace > > > AVIS IMPORTANT: > --- > Les informations contenues dans le present document et ses pieces jointes > sont strictement confidentielles et reservees a l'usage de la (des) > personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, > soyez avise que toute divulgation, distribution, copie, ou autre > utilisation de ces informations est strictement prohibee. Si vous avez > recu ce document par erreur, veuillez s'il vous plait communiquer > immediatement avec l'expediteur et detruire ce document sans en faire de > copie sous quelque forme. > > WARNING: > --- > The information contained in this document and attachments is confidential > and intended only for the person(s) named above. If you are not the > intended recipient you are hereby notified that any disclosure, copying, > distribution, or any other use of the information is strictly prohibited. > If you have received this document by mistake, please notify the sender > immediately and destroy this document and attachments without making any > copy of any kind. > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Replacement for CFX_fMAKETREE
I Need a hand with CF_MakeTree. I'm not familiar with reading query output into a tag attribute and I'm screwing it up as a result. If I simply do this, then I get the following error: SELECT cm_topics.ID AS ItemID, cm_topics.ParentID AS ParentItemID FROM cm_topics WHERE 0=0 MESSAGE: Invalid parameter type DETAIL: The passed value does not evaluate to a valid query object If I instead use QueryNew, QuerySetCell etc. to build a query and try and feed the thing in, I get identical results. Can anyone tell me what I'm missing here? --Matt Robertson-- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Invoking a CFC from Java?
Anyone have an example on how to do this? Cheers, Stace AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: CFMX & med-high traffic sites
On 10/28/02, Brook Davies penned: >I'm pretty sure I know the answer to this one, but is it necessary to lock >application variables reads? or application variables used in an isdefined >statement? I'm almost 100% sure you do not need to lock the isdefined, but >that the read may need a readonly lock. Can some one confirm this for me? Well, even with enforced locking turned on it does NOT throw an error in isDefined. If you try and read it it does. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: CFMX & med-high traffic sites
I'm pretty sure I know the answer to this one, but is it necessary to lock application variables reads? or application variables used in an isdefined statement? I'm almost 100% sure you do not need to lock the isdefined, but that the read may need a readonly lock. Can some one confirm this for me? Brook At 04:03 PM 28/10/02 -0800, you wrote: >Sorry, too late in the day for me. Just session and app vars. > > > > >On 10/28/02 3:52 PM, "Brook Davies" <[EMAIL PROTECTED]> wrote: > > > Client variables locked?? I don't think you have to lock client variables > > do you??? > > We do not use any session vars and only a handful of application variables > > which are all locked. No problems on early versions of CF. > > > > > > > > > > > > > > At 03:41 PM 28/10/02 -0800, you wrote: > >> I know this may be obvious, but are all session, client and app variables > >> locked? Not 100% sure of the role of locking in CFMX but we've seen > similar > >> behavior on CF 5 if an app, high or low-traffic, contains unlocked vars. > >> > >> Ian > >> > >> > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: CFMX & med-high traffic sites
Sorry, too late in the day for me. Just session and app vars. On 10/28/02 3:52 PM, "Brook Davies" <[EMAIL PROTECTED]> wrote: > Client variables locked?? I don't think you have to lock client variables > do you??? > We do not use any session vars and only a handful of application variables > which are all locked. No problems on early versions of CF. > > > > > > > At 03:41 PM 28/10/02 -0800, you wrote: >> I know this may be obvious, but are all session, client and app variables >> locked? Not 100% sure of the role of locking in CFMX but we've seen similar >> behavior on CF 5 if an app, high or low-traffic, contains unlocked vars. >> >> Ian >> >> > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: CFMX & med-high traffic sites
Client variables locked?? I don't think you have to lock client variables do you??? We do not use any session vars and only a handful of application variables which are all locked. No problems on early versions of CF. At 03:41 PM 28/10/02 -0800, you wrote: >I know this may be obvious, but are all session, client and app variables >locked? Not 100% sure of the role of locking in CFMX but we've seen similar >behavior on CF 5 if an app, high or low-traffic, contains unlocked vars. > >Ian > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Application Framework problem
Patti G. L. Hall wrote: > Well, the thing is if you put that kind of code in application.cfm, you'll > be calling it EVERY time youc all ANY template. > > For example, lets say that in your page you are calling a couple of > includes... Maybe one has a udf library. Maybe another has a whole bunch of > queries. Maybe another has a calendar or something reusable like that. In > that case you will be calling application.cfm 4 times... Not just once, > because every time one of those includes gets called, the application.cfm > file is run first. All The Time. Actually, you're incorrect about this. Application.cfm and OnRequestEnd.cfm are respectively called at the beginning and end of a REQUEST, not an INCLUDE. They are not called every time a new CFM file is used internally (i.e., by inclusion via CFINCLUDE, CFMODULE, UDF, CFC, etc.). > This is kind of an exaggeration, but I hope it illustrated the point as to > why you never put anything other that application *logic* in an > application.cfm or onrequestend.cfm. It's a gross abuse of the system and > before long, as soon as your sites get any kind of complexity to them, it > will cause many more headaches that it seems to solve. You can actually make a very good argument for including headers and footers from Application.cfm and OnRequestEnd.cfm instead of having to repeat the code at the top and bottom of every file. For example, all of the extra code placements can result in bugs (typos, etc.). Or, what if you change the filename or path to the included files? With App.cfm, you change the path/filename in one place. Granted you can do a global search and replace, but the point is, there are benefits to including the global files in the App.cfm et al files. Even more so, BTW, versus putting it in a Custom Tag. Custom Tags require extra overhead for processing. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: Application Framework problem
- Original Message - From: "Patti G. L. Hall" <[EMAIL PROTECTED]> > Well, the thing is if you put that kind of code in application.cfm, you'll > be calling it EVERY time youc all ANY template. > > For example, lets say that in your page you are calling a couple of > includes... Maybe one has a udf library. Maybe another has a whole bunch of > queries. Maybe another has a calendar or something reusable like that. In > that case you will be calling application.cfm 4 times... Not just once, > because every time one of those includes gets called, the application.cfm > file is run first. All The Time. I might be misreading you, but this doesn't seem right. Application.cfm only gets called for every HTTP request, not for every file processed by the server during that request. I do agree that it's probably not best to use it for headers and OnRequestEnd.cfm as a footer, though. It seems to be one of the first "hints", even in good CF books, regarding these tags, and it's not a great idea. For me, I use index.cfm as a gateway to every page in my app, and it starts with a DOCTYPE and ends with . It's the bare template for every actual HTML page that gets generated. Any output in Application.cfm or OnRequestEnd.cfm would be outside the document - not good! Gyrus [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net PGP key available ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: CFMX & med-high traffic sites
I know this may be obvious, but are all session, client and app variables locked? Not 100% sure of the role of locking in CFMX but we've seen similar behavior on CF 5 if an app, high or low-traffic, contains unlocked vars. Ian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: [OT] FlashCom Server crashes (the Community Suite Broadcast) [resolved?]
First of all, thanx for all the response (including the off-list response from Macromedia). It turns out I hadn't applied one fix from the release notes http://www.macromedia.com/support/flashcom/releasenotes/mx/rn_mx.html Apparently this can cause a lockup of a shared file object when there are a lot of people chatting, which would cause FlashCom to crash. A crash like that has happened twice, once on Saturday during testing, once earlier today. The first time nothing really bad happened, server was restarted and everything worked again. But today, during the crash the FCChat.chat_fc.history.fso file was damaged. This resulted in FlashCom crashing whenever 6 lines were entered in the chat (I presume because after 6 lines the log cache is flushed to the disk). After renaming the log file FlashCom stayed up. So about an hour ago I restarted the service for, hopefully, the last time to implement all the suggested fixes and rthe change from the release notes. Since then it has been stable, and I hope it will remain that way. If you want to drop by, don't forget to use a computer that has a webcam, you might get your 15 minutes of fame :) http://cfmx.oli.tudelft.nl/flashcom/applications/sample_panel_presentation/ Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: Screwy Excel Query Result
Ian, I have seen this behavior before. It seems that sometimes when you use excel even if you declare a field text and you then enter a number into it excel will convert it to a number instead! Before I get flamed stating that this doesn't happen, it has happened to me. The easiest way to fix from your point of view should be that when you call in the zip column add some code to check for the length of the zip and if it is less than 5 characters long, keep adding zeros to the beginning until it is 5 characters long. If this were sql I could come up with some really slick code to do the trick. I usually don't do this kind of stuff directly from CF. Normally I would pull the data into my SQL server and work on it that way. Steve - Original Message - From: "Ian Lurie" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, October 28, 2002 11:42 AM Subject: Screwy Excel Query Result > I'm querying an Excel spreadsheet that includes a ZIP column. > > For some reason the query drops all ZIP codes that start with 0. I'm using > CF5, and my query is really simple: > > SELECT * > FROM dealerinfo > > The ZIP column is TEXT format in the spreadsheet. > > I'd love to switch to CSV but I need this to be really, really simple for my > client - ideally they should be able to upload the .xls file and be done > with it. > > Has anyone else seen this behavior? > > Ian > > -- > Portent Interactive > Effective web sites through Conversation Marketing > http://www.portentinteractive.com > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: CFMX & med-high traffic sites
Well it's honestly hard to say because my server has had issues under a light load and medium load. This could be between 5,000 page views per day to 20,000 page views (all CF). There are definitely issues. Thats why I posted. I want to see if any body is having great success with med-high traffic. Most others in the forum, mentioned in the previous post, seem to think the server crashes are attributed to load. I'm not so sure any more after a strange crash yesterday. For me, and I think the others in the thread, the symptoms are always the number of running requests growing until the queued requests also starts to grow and this just goes on until the server completely stops server cfm pages. I've cut and pasted something I posted to the forums this morning. This is what happened when the server crashed yesterday. On my day off... I was uploading some new pages that had been tested on the development server and worked fine. The pages were very, very short and basic pages with not a single query or anything more advanced than a . The page was a feature tour for the publicly accessible part of our site, and it only contains an image and a next | back button. After uploading it I tried stepping through the tour using the next back button. Every time I got to the 4th slide, it would not return anything and would just spin (the browser). I tried other pages on the site and everything worked fine. But, each time I went back to this particular page (which is an EXACT duplicate of the previous slide only with a new pageID passed to it), it hung. After trying this about 10 times and not yet realizing that the threads were never dying on the server, the server was officially dead. All of the available threads were filled and the queued requests began to grow. The time out unresponsive threads setting in the cf administrator does not always work for some reason. Brook At 02:35 PM 28/10/02 -0800, you wrote: >Hi Brook, > >I was reading your posts about the server crashing and the missing client >variables. What kind of load is your server under right now? > >We are in the process of moving to MX and are using it on our development >server only. There are 4-5 of us hitting it every day, making code changes, >testing, etc. Our server has been up for a couple weeks now with no problems >(we had missing client variables, but that was an application tag problem - >which I already offered to you as a suggestion for your problem). > >We have a ridiculously light load, but your posts have us a bit nervous as >our live site gets a lot of hits. If you could, would you give us an idea of >what kind of load we can expect the severs to barf under - if we get the >same problem? > >Thanks >Rob > > >-Original Message- >From: Brook Davies [mailto:brook@;maracasmedia.com] >Sent: Monday, October 28, 2002 2:05 PM >To: CF-Talk >Subject: CFMX & med-high traffic sites > > >I'm curious; how many of you are running CFMX on medium - high traffic >sites without the server crashing?? My server crashes all the time. > >A thread about this topic is here >http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=143&threadi >d=468954 > >Prior to upgrading to CFMX our app was extremely stable, now it crashs at >completely irregular intervals sometimes under very little load. > >Brook Davies > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Recipe Application
Hi, My wife has this paper disaster area of recipes and I'd like to make her an app where she can input them and search, etc. Does anyone know if there are any CF apps (opensource) around that do this? I just don't want to code anything that's already out there! TIA, Rob ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: Application Framework problem
No, It's not. Though you may be keeping your code in includes, you're still using Application.cfm and onrequestend.cfm to call the includes. You might as well be writing the code directly to application.cfm and onrequestend.cfm, because coldfusion processes the contents of an include AS IF THEY BELONG IN THE PAGE THAT CALLS THEM (sorry for the shouting, it was for emphasis only). So, after the server has done its work, calling the includes from these pages amounts to the same thing. What you need to do, in order to be consistent with how application.cfm and onrequestend.cfm are supposed to be used, is to write a custom tag that contains your header and your footer and call the tag specifically around all of your display templates. For example: Mylookandfeel_customtag.cfm Myactualpage.cfm This is the actual code on my page. Yay, aren't I all pretty and formatted! Obviously this is just a toy example, but it illustrates the point. You store the formatting in mylookandfeel_customtaglcfm. You split the look in feel in half, determining where the body of the page will lie and everything above that point is in the fist case statement while everything below that point lies in the second case statement. On the page where your acutual content lies, you use a cfmodule tag to call the wrapper. Make sure the path you use in the template attribute is correct. In my little "toy" example I assume that I've saved the custom tag in the same directory as the page that will call it. This may not be the best site design, of course. If you store your tags in a separate central location, use a coldfusion mapping to create a path to the folder where it's located and call the mapping in the template attribute. Now you may ask, why is it such a bad, horrible thing to use application.cfm and onrequestend.cfm like you are? After all, it's so much easier to put the header and footer includes there ONCE rather than having to specifically call that pesky custom tag everything you want to put a table and some buttons around things. Well, the thing is if you put that kind of code in application.cfm, you'll be calling it EVERY time youc all ANY template. For example, lets say that in your page you are calling a couple of includes... Maybe one has a udf library. Maybe another has a whole bunch of queries. Maybe another has a calendar or something reusable like that. In that case you will be calling application.cfm 4 times... Not just once, because every time one of those includes gets called, the application.cfm file is run first. All The Time. You can imagine how horrible the resulting page would look if you ended up with four headers all nested inside one another. This is kind of an exaggeration, but I hope it illustrated the point as to why you never put anything other that application *logic* in an application.cfm or onrequestend.cfm. It's a gross abuse of the system and before long, as soon as your sites get any kind of complexity to them, it will cause many more headaches that it seems to solve. Not a sermon... Just a ... Well... Ok, maybe it was a sermon. -Patti Rick H Kennerly wrote: > |o| your development in due course. You might not want to put your > |o| header and > |o| footer on application.cfm and onrequestend.cfm respectively. Though it > |o| works, its not meant to put templates or any visual display > |o| items. It's not > |o| a standard practice either. > |o| > > Guess I didn't make it clear, or atleast don't understand. > > the files header.cfm and footer.cfm are actually called by CFINCLUDE in the > Application.cfm and OnRequestEnd.cfm. The graphic elements are not actually > in the Application file. Is still not a good idea? I'd gotten the idea to > that from a guide I was reading. > > Rick > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Verity and PDF
Afraid not. The full verity server has some help for this, but they handle it by converting the pdf to html. Other than that, you have to use the built in PDF search. Trey > -Original Message- > From: charlie griefer [mailto:charlie@;griefer.com] > Sent: Friday, October 25, 2002 1:10 PM > To: CF-Talk > Subject: Verity and PDF > > Hey All: > > Using CF 5 and indexing a directory that contains a mix of htm and pdf > files. Everything seems to be going ok, as far as successfully indexing > the > collection, and searching... > > but (don't laugh, everybody's got one)... > > if the search term is found in a particular pdf, and I click the link...it > takes me to the first page of the pdf (which can be potentially 100 > pages), > meaning i've just got to use the Acrobat search tool. > > Is there something that i've overlooked, or a tweak that i can perform, to > get pdf files to return the page within the pdf that contains the search > criteria? > > TIA, > charlie > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: What in the world is this?
I just posted this to the forum thread on this topic: --- Folks, It seems like this continues to be a problem, so I thought I would share a couple of ideas on where the underlying problem might be. While this won't get any of you _directly_ closer to solving your problems, it might be of some help to Macromedia in narrowing down the problem. Understand that this is all just theory offered to try and assist an eventual solution, so please don't attack me if I'm off base. Here goes... 1) The client.properties file is performing the same function as an Oracle Sequence object declared with CACHE = 100. This is a very efficient model for high transaction systems, as the requester simply queries a lightweight object pinned in memory that simply gets the next pre-cached value from an array, increments the index into the array, checks if the new index value is equal to the CACHE value (or directly tests the issued value against the value at the end of the array), and if so updates the persistent "placeholder" for the sequence value, which is in the form of a text file. 2) I assume that the LastID is "forward-looking" to the beginning of the next sequence series being cached, rather than "backward-looking" to the start of the current sequence series cached, since after a restart the mechanism must enable CFMX to pick right up where it left off without having to check anything other than this one persistent file. Anything else would cause overlapping values to be issued from the sequence, which would in turn overlap CFMX client IDs and throw everything off. 3) Since the sequence object pinned in memory must modify internal values every time it is called, all access to it would be synchronized through an exclusive lock on the object. If the system must suffer the mechanical bottleneck of an exclusive lock with each request, it must do so in the least resource-intensive manner possible. This is the main reason why this whole client.properties/sequence object mechanism exists in the first place: to prevent the performance bottleneck that would occur if the system had to exclusively lock and manipulate a file each time an ID request was made. So instead, CFMX just locks an existing object in memory that already contains 100 requests' worth of data and one simple index value that must be modified. Simultaneous requests of the object are queued, but not for very long (in terms of nanoseconds). Except for the request that gets the last value in the array, as this triggers the modification of the client.properties file. 4) Because access to the client.properties file is managed by the OS, OS-level mutex objects (locks) handle sequential I/O from this file, which is certainly slower than a mutex on an object pinned in memory. If CFMX has a problem with its "acquire lock/read file/write file/release lock" procedure on the client.properties file, then that would cause one of two things: either an empty client.properties file, or an unchanged client.properties file. 5) This is where their internal exception handling model comes into play, because what do you do if the modified file cannot be written to disk? What if CFMX couldn't acquire an exclusive lock in the time Macromedia's programmers allotted? Everything pivots on the two critical steps of acquiring an exclusive file lock and writing a properly-formatted file while the lock is in place. Keep this in mind as we discuss the subject further. 6) There is an anomaly in the system that causes the ID to return a value that is not one but _two_ more than the previous issued value. This makes me focus on the exact mechanism used to trigger the modification of client.properties. Is the test a match of the index value to the size of the array, or is it a match of the value retrieved to the last value in the array? If the former, this anomaly will cause some of the next batch of sequence values issued by the object to overlap those it had already issued from the previous batch. If the latter, we need to ask another question: is the test an equality test, or a "greater than or equal to" test. If a strict equality test, this anomaly might cause the test to sometimes fail. What happens to the next ID request after this "end of array" test fails? Is the result a NULL value, perhaps? 7) So now we're back to updating client.properties. With what value? If I were the engineer, I wouldn't take the time to read the file, parse the contents, extract the string containing the LastID value, convert it to an integer, and increment it. I would simply take the value I have in hand (issued by the object), increment that by 100, construct the new string contents of the client.properties file, and overwrite the file. So, if this issued value is NULL, and you try to concatenate that NULL value with any other value, the result will be NULL, right? So the file that is written to disk (if not checked for empty content) is empty. 8) Or what if an error _is_ th
RE: UDF argumement text size limitations?
I've successfully passed moderately sized HTML pages (about a K or so) without a problem in CF5. --Ben Doom Programmer & General Lackey Moonbow Software : -Original Message- : From: Brook Davies [mailto:brook@;maracasmedia.com] : Sent: Monday, October 28, 2002 5:26 PM : To: CF-Talk : Subject: UDF argumement text size limitations? : : : Is there a max length for a string passed to a udf? : : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: Cached Queries
Nothing wrong with a cfc having access to persistent data...I'd say an app variable is the best way to do this. Just make the cfc test to see if 24 hours have passed between refreshes. Application variables aren't the only way to make data persist...you could use a db, or the filesystem. Some skeleton code I did for something similar in CF5. If doupdate equals one, run your query, otherwise don't. I can imagine putting the above check in the constructor code, and setting a obj.doupdate property... -- jon mailto:jonhall@;ozline.net Monday, October 28, 2002, 4:56:20 PM, you wrote: BM> The problem seems to be that none of the query information is available BM> until the line in the code where the cfquery statement is. Therefore, I BM> can't figure out a good way to skip over all the code. BM> I would use an application variable to flag weather the query is current BM> cached or not, and the time since it was first cached, but all this code is BM> in a .cfc and I want to keep it portable as possible. BM> Byron Mann ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: CFMX & med-high traffic sites
Hi Brook, I was reading your posts about the server crashing and the missing client variables. What kind of load is your server under right now? We are in the process of moving to MX and are using it on our development server only. There are 4-5 of us hitting it every day, making code changes, testing, etc. Our server has been up for a couple weeks now with no problems (we had missing client variables, but that was an application tag problem - which I already offered to you as a suggestion for your problem). We have a ridiculously light load, but your posts have us a bit nervous as our live site gets a lot of hits. If you could, would you give us an idea of what kind of load we can expect the severs to barf under - if we get the same problem? Thanks Rob -Original Message- From: Brook Davies [mailto:brook@;maracasmedia.com] Sent: Monday, October 28, 2002 2:05 PM To: CF-Talk Subject: CFMX & med-high traffic sites I'm curious; how many of you are running CFMX on medium - high traffic sites without the server crashing?? My server crashes all the time. A thread about this topic is here http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=143&threadi d=468954 Prior to upgrading to CFMX our app was extremely stable, now it crashs at completely irregular intervals sometimes under very little load. Brook Davies ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Application Framework problem
|o| your development in due course. You might not want to put your |o| header and |o| footer on application.cfm and onrequestend.cfm respectively. Though it |o| works, its not meant to put templates or any visual display |o| items. It's not |o| a standard practice either. |o| Guess I didn't make it clear, or atleast don't understand. the files header.cfm and footer.cfm are actually called by CFINCLUDE in the Application.cfm and OnRequestEnd.cfm. The graphic elements are not actually in the Application file. Is still not a good idea? I'd gotten the idea to that from a guide I was reading. Rick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
UDF argumement text size limitations?
Is there a max length for a string passed to a udf? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: remote file exists help
Do a cfhttp and look for a 404 error. --Ben Doom Programmer & General Lackey Moonbow Software : -Original Message- : From: Chris Edwards [mailto:chris.edwards@;obinet.com] : Sent: Monday, October 28, 2002 4:55 PM : To: CF-Talk : Subject: remote file exists help : : : is there anything out there that does what FileExists() does, but : for remote : files? : : -- : Chris Edwards : Web Application Developer : Outer Banks Internet, Inc. : 252-441-6698 : [EMAIL PROTECTED] : http://www.OuterBanksInternet.com : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
OT Tracking a CFMX bug
I have a situation where i create and save a simple cfm template, then access it with a browser The following takes place: 1) the template is parsed 2) the Java source is generated 3) the .java file is saved. 4) I get an error before the.class file is saved The error is below -- just a single line stack trace. The question: How do I determine what portion of CFMX is in control when the error occurs? TIA Dick The Error: Error occurred while processing request! Please try the following: * Check the CFML Reference Manual to verify that you are using the correct syntax. * Search the Knowledge Base to find a solution to your problem. Browser Mozilla/4.0 (compatible; MSIE 5.22; Mac_PowerPC) Remote Address 127.0.0.1 Referrer http://127.0.0.1:8500/mycfmxapps/ Date/Time 28-Oct-02 02:05 PM Stack Trace (click to expand) [Ljava.lang.StackTraceElement;@c127d ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
CFMX & med-high traffic sites
I'm curious; how many of you are running CFMX on medium - high traffic sites without the server crashing?? My server crashes all the time. A thread about this topic is here http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=143&threadi d=468954 Prior to upgrading to CFMX our app was extremely stable, now it crashs at completely irregular intervals sometimes under very little load. Brook Davies ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: Cached Queries
The problem seems to be that none of the query information is available until the line in the code where the cfquery statement is. Therefore, I can't figure out a good way to skip over all the code. I would use an application variable to flag weather the query is current cached or not, and the time since it was first cached, but all this code is in a .cfc and I want to keep it portable as possible. Byron Mann - Original Message - From: "Matthew Walker" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, October 28, 2002 4:47 PM Subject: RE: Cached Queries > cfquery.executionTime might be useful. In my experience it is 0 for > cached queries. However it might conceivably return 0 for non-cached > queries too. > > Matthew Walker > http://www.matthewwalker.net.nz/ > > > > > -Original Message- > > From: Byron M [mailto:mbyron@;comcast.net] > > Sent: Tuesday, 29 October 2002 10:37 a.m. > > To: CF-Talk > > Subject: Cached Queries > > > > > > I have a bunch of code that I don't want to execute if a > > query is cached. > > > > I tried this > > > > > > ... whole lotta code, then the query occurs > > > > > > > > ... skip all that code > > > > > > and it still doesn't seem to skip over the code. > > > > Basically all the code does some cfhttp calls and creates a > > query, which I > > then do a query of a query and cache that one. I only need > > all the code to > > run once a day (because it takes some time). I don't want it > > to run every > > call to the page. > > > > I guess the question is, is there some variable in the server > > scope that > > lists the names of the cached queries? > > > > Byron > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: CFMX Issue(s) Status
Lee, when I run this bat file, the cfserver continues to respond and service requests but if I look in the services control panel, it says that the Cold Fusion MX Application Server is not started. And when I try to start it generates a type 2 error. But at the same time the CFMX server is functioning. This happened on two machines. Any idea why? Brook At 02:58 PM 25/10/02 -0700, you wrote: >Hello everyone.. Thought I would update you on the issues that caused >the "long" thread here. I'm posting here, because this is NOT about how >to manage communication between MM and ourselves. Rather, this is >specifically about the technical aspects of what's happening now. > >Here goes... (This is a long one!) > > > >** BIG - HUGE - HONKIN' - DISCLAIMER >I'm sending out this info for just that purpose.. INFO. It is NOT >recommended as a way for you to handle your own problems with CF(MX), >nor is this information, in any way shape or form, given at the behest >of, or suggestion from, Macromedia. These are MY observations and >workarounds. THEY MAY NOT WORK IN YOUR CASE -- PARTIALLY OR AT ALL, AND >MAY DESTROY DATA, GIVE YOU A HORRIBLE, PAINFUL AND INCURABLE DISEASE, >REMOTELY KILL YOUR PARENTS, GRANDPARENTS AND/OR REMAINING FAMILY WITH >NUCLEAR FALLOUT, AND/OR DRAIN YOUR BANK ACCOUNT, ALONG WITH ANY NUMBER >OF OTHER MORE PAINFUL AFTER-EFFECTS ((c)2002 ADOBE). You have been >warned. >* > > > > > >Issue #1: >~ >Server Spiraling Out Of Control > >Symptom: > >At irregular intervals, IIS5 will begin to spiral upwards in the number >of "Current Connections", showing that many of them are not dead/dying >properly. Correspondingly, the number of "Running Requests" of the JRUN >(CFMX) service begin to rise as well, with a "floor" number staying >stable (not dying), yet ever increasing until the CFMX server will stop >responding to CFM file requests at all. > >If we restart only IIS, on some occassions CFM files CALLED DIRECTLY >will begin to fail with 404 errors. However, indirect calls to the same >files will work normally (sometimes). I.e., >"http://www.somedomain.com/index.cfm"; fails with a 404, whereas >"http://www.somedomain.com"; works fine (sometimes) (and yes.. there is >ONLY an "index.cfm" file -- no default.xxx or other "home" pages in the >dir). > >Workaround: >~~~ >We have noticed that simply using the PerfMonitor to restart the CFMX >and IIS services does not always work properly. Sometimes, as mentioned >above, the IIS server simply loses touch with CFMX and delivers bizarre >404 errors, where other times CFMX will simply not respond and the >entire site appears to be offline. This DOES NOT correspond (as far as >we can tell) in any significant way to whether the page connecting to an >outside datasource. > >Therefore, we decided to try simply restarting the "jrun.exe" service >directly using the "cfstop.bat" and "cfstart.bat" files that are located >in the \bin directory. We trigger this restart using >PerfMon and setting "alerts" to make sure that we have no more than 25 >"Running Requests" for the JRUN service, and another that runs the >restart if we have more than 125 "Current Connections" to IIS. These >numbers may seem low. However, if we do not restart at these points, >either IIS or CFMX will begin to run VERY slowly, or simply not respond >at all. And since CFMX's Probes stop working when CFMX itself stops >working, a probe is useless. Besides, CF never does restart itself >properly "... after X unresponsive requests." > >Here is the BAT file that is used to restart the JRUN service: > >=== >@echo off >cls >REM == RESTART CFMX=== >c: >cd \ROOTCFMXDIR\bin >call C:\ROOTCFMXDIR\bin\cfstop.bat >c:\winnt\system32\kill -f jrun.exe >c:\winnt\system32\kill -f jrun.exe >sleep 2 >call C:\ROOTCFMXDIR\bin\cfstart.bat >REM === >Exit (interesting that this isn't needed, nor does it work.. So don't >ask me why it's here. :) === > >You may well ask "Why do you kill JRUN.EXE twice?" Good question! >Because JRUN.EXE is an actual service, we are effectively killing the >old service and opening a new one in a new CMD window (hidden of >course). We noticed that if we only kill it one time, it will not die. >Therefore, we will end up with dozens of CMD instances, along with >dozens of JRUN.EXE instances by day's end. We have found that killing >it twice does, indeed, get rid of the old instance, and properly create >only one new instance. > >It is important to note that there is no way (at least that I know of) >to cause PerfMon alerts to start themselves, upon a reboot caused >remotely. So if you're not there to start the alerts manually, they >will not restart the server if they are triggered. > >Lastly, we tried adding the CFMX ODBC services to this restart bat >file.. wi
remote file exists help
is there anything out there that does what FileExists() does, but for remote files? -- Chris Edwards Web Application Developer Outer Banks Internet, Inc. 252-441-6698 [EMAIL PROTECTED] http://www.OuterBanksInternet.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Cached Queries
cfquery.executionTime might be useful. In my experience it is 0 for cached queries. However it might conceivably return 0 for non-cached queries too. Matthew Walker http://www.matthewwalker.net.nz/ > -Original Message- > From: Byron M [mailto:mbyron@;comcast.net] > Sent: Tuesday, 29 October 2002 10:37 a.m. > To: CF-Talk > Subject: Cached Queries > > > I have a bunch of code that I don't want to execute if a > query is cached. > > I tried this > > > ... whole lotta code, then the query occurs > > > > ... skip all that code > > > and it still doesn't seem to skip over the code. > > Basically all the code does some cfhttp calls and creates a > query, which I > then do a query of a query and cache that one. I only need > all the code to > run once a day (because it takes some time). I don't want it > to run every > call to the page. > > I guess the question is, is there some variable in the server > scope that > lists the names of the cached queries? > > Byron > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Cached Queries
I have a bunch of code that I don't want to execute if a query is cached. I tried this ... whole lotta code, then the query occurs ... skip all that code and it still doesn't seem to skip over the code. Basically all the code does some cfhttp calls and creates a query, which I then do a query of a query and cache that one. I only need all the code to run once a day (because it takes some time). I don't want it to run every call to the page. I guess the question is, is there some variable in the server scope that lists the names of the cached queries? Byron ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: [OT] FlashCom Server crashes (the Community Suite Broadcast)
this sounds familiar: http://www.macromedia.com/support/flashcom/releasenotes/mx/rn_mx.html from: - There is an error in line 84 of the chat.asc file installed in the server's scriptlib/components directory. Incorrect : this.history.unshift(); Correct: this.history.shift();" - let me know if that helps... mike chambers [EMAIL PROTECTED] > -Original Message- > From: Jochem van Dieten [mailto:jochemd@;oli.tudelft.nl] > Sent: Monday, October 28, 2002 3:11 PM > To: CF-Talk > Subject: [OT] FlashCom Server crashes (the Community Suite Broadcast) > Importance: High > > > Hi all, > > I am having a bit of a problem with FlashCom Server. Default server > install on Win2K SP3, running the sample_panel_presentation example > application. Even without FlashCom Server serving any video streams, > just maybe 5 lines of chatting amongst 2 or 3 participants in about 2 > minutes and it crashes. CPU usage goes to 100%, service > manager can not > stop the service and the only thing that works is a cold reboot. > No messages in any log. > > Any suggestions? Are there any updates available that I > missed? Problems > with the example application (though that should not be able to bring > down an app server)? > > TIA, > Jochem > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: [OT] Community Suite Live
fyi, make sure you set the app to your connection setting (it defaults to modem). there is a drop down box at the top that lets you do this. i believe this was all done with the flash communication server components, so it may have required no actionscript code (i am not 100% sure how they implimented it though). mike chambers [EMAIL PROTECTED] > -Original Message- > From: Angel Stewart [mailto:gel@;silkcotton.com] > Sent: Monday, October 28, 2002 12:24 PM > To: CF-Talk > Subject: RE: [OT] Community Suite Live > Importance: High > > > It was very cool seeing a couple blocky faces :) > > We made out Candace though! YAY CANDACE! > > But next time we need a fatter pipe going out. > > I would love to find out how the presentation was put > together using the > MM Comm Server though..I haven't heard very much about that, but after > seeing this presentation I am QUITE interested in what it can do :) > > > -Gel > > -Original Message- > From: Michael Dinowitz [mailto:mdinowit@;houseoffusion.com] > http://cfmx.oli.tudelft.nl/flashcom/applications/sample_panel_presentati on/s ample_panel_presentation.html Thanks to Jochem Van Dieten for setting up the flash media server, Paul Ihrig for the camera and Adam Churvis for the line. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Clustering Question
If you're running with CLIENT variables, as long as both servers are pointing at the same database server for the client variable storage, you'll be fine. I've done this many times, and it works quite nicely. -Kev -Original Message- From: Jennifer Goodenow [mailto:jgoodenow@;spindustry.com] Sent: Monday, October 28, 2002 3:55 PM To: CF-Talk Subject: Clustering Question Has anyone had problems maintaining client variables in a clustered CF5 environment with two domains pointing to the same code? We've had one domain running just fine, but wondered about the addition of a new domain to the cluster, particularly with regard to server fail-over. Any input? J Goodenow ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Clustering Question
Has anyone had problems maintaining client variables in a clustered CF5 environment with two domains pointing to the same code? We've had one domain running just fine, but wondered about the addition of a new domain to the cluster, particularly with regard to server fail-over. Any input? J Goodenow
Re: CF 5 -> CFMX upgrade on Solaris
I'm also doing this and have had some problems although it may be some other software on the server. I would be interested in anything you find. Thanks! Bruce Holm wrote: > Thanks Kevin for the report. It was I who asked about Solaris upgrade to > MX. We may be asking you some questions directly in email as we have still > not migrated up yet, we had to back out and go back to 5 for now. > > Bruce Holm > > -Original Message- > From: Kevin Gilchrist [mailto:kgilchrist@;redsiren.com] > Sent: Monday, October 28, 2002 8:35 AM > To: CF-Talk > Subject: CF 5 -> CFMX upgrade on Solaris > > > Somebody asked last week if anyone had performed an upgrade from CF 5 to > CFMX on Solaris. > Well, I did so over the weekend and it worked fine. Everything migrated > the way I expected. > > Kevin > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: [OT] FlashCom Server crashes (the Community Suite Broadcast)
Monday, October 28, 2002, 2:39:44 PM, Chris Montgomery wrote: CM> "C'mon Mr. Van Dietan... Ooops, sorry 'bout that...should be Mr. van Dieten. Chris Montgomerymonty @ airtightweb.com -- Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-3249/888-745-7603 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: [OT] FlashCom Server crashes (the Community Suite Broadcast)
Jochem van Dieten wrote: > I am having a bit of a problem with FlashCom Server. Default server > install on Win2K SP3, running the sample_panel_presentation example > application. Even without FlashCom Server serving any video streams, > just maybe 5 lines of chatting amongst 2 or 3 participants in about 2 > minutes and it crashes. CPU usage goes to 100%, service manager can > not stop the service and the only thing that works is a cold reboot. > No messages in any log. > > Any suggestions? Are there any updates available that I missed? > Problems with the example application (though that should not be able > to bring down an app server)? We seem to be making progress. More testing revealed that the server consistently went down after 6 lines were entered in the chat application. So I got the hunch that some history file was corrupted. After renaming the old history files, it stays up longer now. This sounds suspiciously like some CFMAIL code was borrowed . Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
GROUP BY Clause and Aggregate Functions
Here is my query: SELECT MAX(Th.dateReceived) AS dateReceived, T.ticketID, Q.queueID, Q.queueName, TS.statusName FROM((Tickets T LEFT JOIN Queues Q ON T.queue = Q.queueID) LEFT JOIN ticketStatus TS ON T.status = TS.statusID) LEFT JOIN threads Th ON T.ticketID = Th.ticketID WHERET.ticketID >= 1 AND T.ticketID <= 400 AND T.owner <> 0 AND (TS.statusName = 'New' OR TS.statusName = 'Open') ORDER BY T.priority desc, T.ticketID This works as is without the MAX(Th.dateReceived) select. When I include that I get the dreaded "Column 'Q.queueID' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause." If I include all the other fields in the GROUP BY clause, I get: "The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator." The field in question is the T.Subject field. Is there anyway of performing this query? Any help is appreciated. Cedric ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: [OT] FlashCom Server crashes (the Community Suite Broadcast)
I wanna see the COMM server work! Forget the Beer! It's probably all just weak american beer anyways! I told everyone on every mailing list I was on to Log into the link to check it out and... .. .. 0_0 Oops. *sneaks quietly away to hide* -Gel -Original Message- From: Tony Weeg [mailto:tony@;navtrak.net] at devcon, shit no, its about beer, some more beer, a few conferences and then speaking, and then heck, its over, on to the finale, and more beer :) .tony -Original Message- From: Angel Stewart [mailto:gel@;silkcotton.com] Yeah. Instead it's what a Great Way to show their product apparently doesn't work. They probably want Jochem to submit a Support Ticket to their Tech Support people. *sigh* HowHow depressing. :( -Gel ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Mulitple websites on the say System
I'm running ColdFusionMX on Sun Solaris8 with Apache2. The Apache instance is hosting multlple web sites. www.domain1.com www.domain2.com www.domain3.com In the Coldfusion Administrator I can only specified one Root Mapping in the ColdFusion Mappings section of the CF Administrator. How are others handling this delimma? Thanks, Troy -- - Troy Simpson Applications Analyst/Programmer, MCSE, OCPDBA North Carolina State University Libraries Campus Box 7111 | Raleigh | North Carolina ph.919.515.3855 | fax.919.513.3330 E-mail: [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: [OT] FlashCom Server crashes (the Community Suite Broadcast)
Monday, October 28, 2002, 2:28:43 PM, Angel Stewart wrote: AS> Yeah. AS> Instead it's what a Great Way to show their product apparently AS> doesn't work. They probably want Jochem to submit a Support Ticket AS> to their Tech Support people. Wait, aren't they supposed to charge his credit card account first? (MM rep to Jochem) "C'mon Mr. Van Dietan, whip out the plastic and pay up! We need to pay for some more rides at DisneyWorld!" Chris Montgomerymonty @ airtightweb.com -- Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-3249/888-745-7603 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: [OT] FlashCom Server crashes (the Community Suite Broadcast)
:-) -Original Message- From: Jochem van Dieten [mailto:jochemd@;oli.tudelft.nl] Sent: October 28, 2002 4:36 PM To: CF-Talk Subject: Re: [OT] FlashCom Server crashes (the Community Suite Broadcast) Chris Montgomery wrote: > You mean that with all those MM techies running around there that none > of them can help? You don't run a server from a hotel. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: [OT] FlashCom Server crashes (the Community Suite Broadcast)
Chris Montgomery wrote: > You mean that with all those MM techies running around there that none > of them can help? You don't run a server from a hotel. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: [OT] FlashCom Server crashes (the Community Suite Broadcast)
at devcon, shit no, its about beer, some more beer, a few conferences and then speaking, and then heck, its over, on to the finale, and more beer :) ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Angel Stewart [mailto:gel@;silkcotton.com] Sent: Monday, October 28, 2002 3:29 PM To: CF-Talk Subject: RE: [OT] FlashCom Server crashes (the Community Suite Broadcast) Yeah. Instead it's what a Great Way to show their product apparently doesn't work. They probably want Jochem to submit a Support Ticket to their Tech Support people. *sigh* HowHow depressing. :( -Gel -Original Message- From: Chris Montgomery [mailto:lists@;airtightweb.com] You mean that with all those MM techies running around there that none of them can help? Seems like they oughta be all over this problem. What a great way to show off one of their latest products - real world and in real time. Chris Montgomerymonty @ airtightweb.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: [OT] FlashCom Server crashes (the Community Suite Broadcast)
Yeah. Instead it's what a Great Way to show their product apparently doesn't work. They probably want Jochem to submit a Support Ticket to their Tech Support people. *sigh* HowHow depressing. :( -Gel -Original Message- From: Chris Montgomery [mailto:lists@;airtightweb.com] You mean that with all those MM techies running around there that none of them can help? Seems like they oughta be all over this problem. What a great way to show off one of their latest products - real world and in real time. Chris Montgomerymonty @ airtightweb.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: [OT] FlashCom Server crashes (the Community Suite Broadcast)
Monday, October 28, 2002, 2:10:30 PM, Jochem van Dieten wrote: JvD> I am having a bit of a problem with FlashCom Server. JvD> Any suggestions? You mean that with all those MM techies running around there that none of them can help? Seems like they oughta be all over this problem. What a great way to show off one of their latest products - real world and in real time. Chris Montgomerymonty @ airtightweb.com -- Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-3249/888-745-7603 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: On again
The Flash Com server is crashing. -Original Message- From: Chris Montgomery [mailto:lists@;airtightweb.com] Sent: October 28, 2002 4:18 PM To: CF-Talk Subject: Re: On again Howdy Michael, Monday, October 28, 2002, 1:39:29 PM, Michael Dinowitz wrote: MD> We were off because Raymond needed the line for his really fantastic MD> presentation. Looks dead to me. Do we need a videocam to get in? Chris Montgomerymonty @ airtightweb.com -- Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-3249/888-745-7603 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Loading Screen for CF-Apps ???
Progress % #RepeatString(" ",200)# Rest of code craziness--- Regards, Eric J Hoffman Head Tech Geek DataStream Connexion www.datastreamconnexion.com Delivering Creative Data Solutions -Original Message- From: Joshua Miller [mailto:josh@;joshuasmiller.com] Sent: Monday, October 28, 2002 12:35 PM To: CF-Talk Subject: RE: Loading Screen for CF-Apps ??? The example on MM.com breaks "called CFFLUSH in an invalid location" for all 3 instances of CFFLUSH in the code snippet. Is there a working example somewhere? Joshua Miller [EMAIL PROTECTED] -Original Message- From: Eric Hoffman [mailto:webmaster@;digitalmpls.com] Sent: Monday, October 28, 2002 11:08 AM To: CF-Talk Subject: RE: Loading Screen for CF-Apps ??? CFFLUSH if you are on 5 or better. That works well. There is an article on MM about how to use with code examples. Regards, Eric J Hoffman Head Tech Geek DataStream Connexion www.datastreamconnexion.com Delivering Creative Data Solutions -Original Message- From: Joshua Miller [mailto:josh@;joshuasmiller.com] Sent: Monday, October 28, 2002 9:07 AM To: CF-Talk Subject: Loading Screen for CF-Apps ??? Hello, I'm writing a web application that uses a WebService for a weather feed and that is also, on the same template, generating a chart using CFCHART of some database data. The site loads quickly except for the page calling these two functions and I'd like to put up some kind of loading screen (x% completed) maybe using FLASH or whatever ... just so I can incrementally show the status to the user so they don't think it's broken and keep clicking "HOME" over and over. Anyone have any suggestions or ideas how to do something like this? Thanks, Joshua Miller [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: On again
Howdy Michael, Monday, October 28, 2002, 1:39:29 PM, Michael Dinowitz wrote: MD> We were off because Raymond needed the line for his really fantastic MD> presentation. Looks dead to me. Do we need a videocam to get in? Chris Montgomerymonty @ airtightweb.com -- Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-3249/888-745-7603 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: [OT] FlashCom Server crashes (the Community Suite Broadcast)
*cries* Wh whyy I had such high hopes for using it...whyyy.. Damn you MM... Wa :~(~ -Gel -Original Message- From: Jochem van Dieten [mailto:jochemd@;oli.tudelft.nl] Sent: Monday, October 28, 2002 4:11 PM To: CF-Talk Subject: [OT] FlashCom Server crashes (the Community Suite Broadcast) Hi all, I am having a bit of a problem with FlashCom Server. Default server install on Win2K SP3, running the sample_panel_presentation example application. Even without FlashCom Server serving any video streams, just maybe 5 lines of chatting amongst 2 or 3 participants in about 2 minutes and it crashes. CPU usage goes to 100%, service manager can not stop the service and the only thing that works is a cold reboot. No messages in any log. Any suggestions? Are there any updates available that I missed? Problems with the example application (though that should not be able to bring down an app server)? TIA, Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
[OT] FlashCom Server crashes (the Community Suite Broadcast)
Hi all, I am having a bit of a problem with FlashCom Server. Default server install on Win2K SP3, running the sample_panel_presentation example application. Even without FlashCom Server serving any video streams, just maybe 5 lines of chatting amongst 2 or 3 participants in about 2 minutes and it crashes. CPU usage goes to 100%, service manager can not stop the service and the only thing that works is a cold reboot. No messages in any log. Any suggestions? Are there any updates available that I missed? Problems with the example application (though that should not be able to bring down an app server)? TIA, Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: using SA-FileUp
>I just bought SA-FileUp Why when you've got CFFILE and CFFTP??? cffile action = "upload" -Original Message- From: Sim Graves [mailto:sim@;simgraves.com] Sent: Monday, October 28, 2002 1:49 PM To: CF-Talk Subject: using SA-FileUp I just bought SA-FileUp. I've been using CFOBJECT to connect to SoftArtisans.FileUp. It appears that I can CREATE this object but I can't pass variables back and forth. It may just be syntax problems using CFOBJECT but I'm not sure. I could just use an ASP connection but that would be kind of messy when I want to use ColdFusion for my other database functions. If you've had any luck with SoftArtisans.FileUp and CFOBJECT, I would appreciate any help. If you've used another method, I'd love to hear about that too. TIA Sim Graves ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: How do they do this?
They probably have a very nice system to do this, but basically they are scanning in pages from a catalog, then dumping the words from the page into a keyword field ... (thus making the keyword searches work). Paul Giesenhagen QuillDesign - Original Message - From: "Kris Pilles" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, October 28, 2002 1:45 PM Subject: OT: How do they do this? > http://www.catalogs.google.com/catalogs?issue=13334&catpage=cover&catvie > w=thumb > > I was wondering if anyone knows how they are doing this??? Especially > the searching (Try it out) > > Kris Pilles > Website Manager > Western Suffolk BOCES > 507 Deer Park Rd., Building C > Phone: 631-549-4900 x 267 > E-mail: [EMAIL PROTECTED] > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
using SA-FileUp
I just bought SA-FileUp. I've been using CFOBJECT to connect to SoftArtisans.FileUp. It appears that I can CREATE this object but I can't pass variables back and forth. It may just be syntax problems using CFOBJECT but I'm not sure. I could just use an ASP connection but that would be kind of messy when I want to use ColdFusion for my other database functions. If you've had any luck with SoftArtisans.FileUp and CFOBJECT, I would appreciate any help. If you've used another method, I'd love to hear about that too. TIA Sim Graves ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: SQL Query Results
Please clarify exactly what you want to retrieve... Gene -Original Message- From: Jillian Carroll [mailto:jillian@;koskie.com] Sent: Monday, October 28, 2002 2:34 PM To: CF-Talk Subject: RE: SQL Query Results If I use 'OR', won't it stop evaluating once it finds a match? -Original Message- From: Gene Kraybill [mailto:Gene.Kraybill@;adelphia.com] Sent: Monday, October 28, 2002 1:26 PM To: CF-Talk Subject: RE: SQL Query Results If I understand your intention correctly: WHERE s1_trainer1 = #client.id# OR s1_trainer2 = #client.id# OR s1_trainer3 = #client.id# OR ... Gene K. -Original Message- From: Jillian Carroll [mailto:jillian@;koskie.com] Sent: Monday, October 28, 2002 2:14 PM To: CF-Talk Subject: SOT: SQL Query Results How can I adjust the following query so that it checks every trainer (s1_trainer1, s1_trainer2, etc.) for a match to #client.id# without having to do 10 queries? SELECT id, type, other, city, prov, s1_startdate, s1_trainer1, s1_trainer2, s1_trainer3, s1_trainer4, s1_trainer5, s2_trainer1, s2_trainer2, s2_trainer3, s2_trainer4, s2_trainer5 FROM courses WHERE s1_trainer1 = #client.id# ORDER BY s1_startdate DESC ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
OT: How do they do this?
http://www.catalogs.google.com/catalogs?issue=13334&catpage=cover&catvie w=thumb I was wondering if anyone knows how they are doing this??? Especially the searching (Try it out) Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: SQL Query Results
If I use 'OR', won't it stop evaluating once it finds a match? -Original Message- From: Gene Kraybill [mailto:Gene.Kraybill@;adelphia.com] Sent: Monday, October 28, 2002 1:26 PM To: CF-Talk Subject: RE: SQL Query Results If I understand your intention correctly: WHERE s1_trainer1 = #client.id# OR s1_trainer2 = #client.id# OR s1_trainer3 = #client.id# OR ... Gene K. -Original Message- From: Jillian Carroll [mailto:jillian@;koskie.com] Sent: Monday, October 28, 2002 2:14 PM To: CF-Talk Subject: SOT: SQL Query Results How can I adjust the following query so that it checks every trainer (s1_trainer1, s1_trainer2, etc.) for a match to #client.id# without having to do 10 queries? SELECT id, type, other, city, prov, s1_startdate, s1_trainer1, s1_trainer2, s1_trainer3, s1_trainer4, s1_trainer5, s2_trainer1, s2_trainer2, s2_trainer3, s2_trainer4, s2_trainer5 FROM courses WHERE s1_trainer1 = #client.id# ORDER BY s1_startdate DESC ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
On again
We were off because Raymond needed the line for his really fantastic presentation. The problem was solved by BlueDragon. They went out and got us a new router for the room so we can always be on even when presenters are on. Wy cool. :) http://cfmx.oli.tudelft.nl/flashcom/applications/sample_panel_presentation/c ommunity_small.htm ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: SQL Query Results
If I understand your intention correctly: WHERE s1_trainer1 = #client.id# OR s1_trainer2 = #client.id# OR s1_trainer3 = #client.id# OR ... Gene K. -Original Message- From: Jillian Carroll [mailto:jillian@;koskie.com] Sent: Monday, October 28, 2002 2:14 PM To: CF-Talk Subject: SOT: SQL Query Results How can I adjust the following query so that it checks every trainer (s1_trainer1, s1_trainer2, etc.) for a match to #client.id# without having to do 10 queries? SELECT id, type, other, city, prov, s1_startdate, s1_trainer1, s1_trainer2, s1_trainer3, s1_trainer4, s1_trainer5, s2_trainer1, s2_trainer2, s2_trainer3, s2_trainer4, s2_trainer5 FROM courses WHERE s1_trainer1 = #client.id# ORDER BY s1_startdate DESC ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
CF and scientific notation/math formulas
has anyone worked within the science/math communities and developed or working with any content management system for the web (ideally in CF) that addressed the major problem of scientific notation/math formulas... One common storage/markup mechanism used elsewhere is LaTex... Anyone worked to accomodate these more complex types of data..??? Interested in hearing from anyone who has Paris Lundis Founder Areaindex, L.L.C. http://www.areaindex.com http://www.pubcrawler.com 412-292-3135 [finding the future in the past, passing the future in the present] [connecting people, places and things] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
OT: A Developer that owns a Science Site
Hi Guys, This is off topic but, a while back one of the guys responding to a question posted here owned a science website. At least I think it was a science website. As I remember it had articles and news about the scientific community. He ran the site himself but did offer some advertising options with detailed demographic data on his users. If anyone knows the url to this site I'd appreciate it. Sorry for the OT post. ~Jason - Jason Dowdell IM-AES Web Developer 321.799.6845 [EMAIL PROTECTED] - ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: Read in external file for manipulation
oi FlashGuy!! loop the file based on chr(13)&chr(10) as the delimiter.. ? -- Critz Macromedia Certified Advanced ColdFusion Developer http://blog.ctzc.com";> Monday, October 28, 2002, 2:10:14 PM, you wrote: F> Hi, F> I require the following: F> 1. Read in an external file. F> 2. All lines that contains "DATA", "FILE", "IMAGE" are put into a variable which is comma-delimited. Everything else that doesn't match the criteria gets thrown out. F> 3. The results of this variable gets stored on the users PC for future reference as a comma-deliimited text file (ref.txt) F> F> F> F> I'm not sure where to go next? I tried something like below but it lists *everything* in the external file being read in. F> ListLoop CONTAINS "DATA" OR F> ListLoop CONTAINS "DATA"> F>#ListLoop# F> F> --- F> Colonel Nathan R. Jessop F> Commanding Officer F> Marine Ground Forces F> Guatanamo Bay, Cuba F> --- F> ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
SOT: SQL Query Results
How can I adjust the following query so that it checks every trainer (s1_trainer1, s1_trainer2, etc.) for a match to #client.id# without having to do 10 queries? SELECT id, type, other, city, prov, s1_startdate, s1_trainer1, s1_trainer2, s1_trainer3, s1_trainer4, s1_trainer5, s2_trainer1, s2_trainer2, s2_trainer3, s2_trainer4, s2_trainer5 FROM courses WHERE s1_trainer1 = #client.id# ORDER BY s1_startdate DESC ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Read in external file for manipulation
Hi, I require the following: 1. Read in an external file. 2. All lines that contains "DATA", "FILE", "IMAGE" are put into a variable which is comma-delimited. Everything else that doesn't match the criteria gets thrown out. 3. The results of this variable gets stored on the users PC for future reference as a comma-deliimited text file (ref.txt) I'm not sure where to go next? I tried something like below but it lists *everything* in the external file being read in. #ListLoop# --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: Closing window from inside a frame?
Or, just target="_top" in your tag should work... Pete - Original Message - From: "Critter" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, October 28, 2002 1:49 PM Subject: Re: Closing window from inside a frame? > oi Greg!! > > top.window.close() ? > > top.window.opener... ? > > > -- > Critz > Macromedia Certified Advanced ColdFusion Developer > Channel="ColdFusion" Blog="http://blog.ctzc.com";> > > > > > > Monday, October 28, 2002, 1:39:53 PM, you wrote: > > GL> I have a form inside a frameset and after posting the form and processing > GL> the data I need to close the window and post back to the "opener". > GL> I've used this in an action template before after processing a form > GL> submission and it works nicely. But I'm trying to do a similar thing inside > GL> a frameset and it doesn't want to close the window. :-( Any ideas? > GL> > GL> > GL> > GL> function closeit() { > GL> window.opener.location="index.cfm?fuseaction=members.main"; > GL> window.close(); > GL> } > GL> > GL> > GL> > GL> > > GL> > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: ie mac problem?
This is a common problem. I can't recall all the permutations, but yes IE on the Mac will drop form data. One way around it is to set all the form variables into a structure. Then when the user goes anywhere, the structure data either exists or doesn't. If they come back to the form and there is data in their structure, then prefill the form with that data. -Kevin Graeme > -Original Message- > From: Nick Varner [mailto:VarnerN@;cookministries.org] > Sent: Monday, October 28, 2002 11:30 AM > To: CF-Talk > Subject: ie mac problem? > > > We have a form that people submit information, after submitting > the info we > confirm the info back to the user. If the user is on IE on the Mac and > clicks back enough times to get to our homepage then clicks forward to go > back to the confirmation page all of the values are missing. It > appears that > when IE goes from an SSL (input and confirmation) site to non SSL > (home) it > losses values; has any one else seen this before or know of a way > around it. > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: WebTV and CFLOCATION
Are you having problems? I have a couple boxes here I can test some stuff with if you want to send a url. I don't recall having problems, but then I can't recall for certain if we used a cflocation or not with our webtv stuff. -Kevin > -Original Message- > From: Bruce Sorge [mailto:bsorge@;bhswebdesign.com] > Sent: Monday, October 28, 2002 12:00 PM > To: CF-Talk > Subject: WebTV and CFLOCATION > > > Is anyone aware of any issues with WebTV users and CFLOCATION not > working with it? I do not know much about WebTV. > > > > Thanks, > > Bruce > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: Closing window from inside a frame?
oi Greg!! top.window.close() ? top.window.opener... ? -- Critz Macromedia Certified Advanced ColdFusion Developer http://blog.ctzc.com";> Monday, October 28, 2002, 1:39:53 PM, you wrote: GL> I have a form inside a frameset and after posting the form and processing GL> the data I need to close the window and post back to the "opener". GL> I've used this in an action template before after processing a form GL> submission and it works nicely. But I'm trying to do a similar thing inside GL> a frameset and it doesn't want to close the window. :-( Any ideas? GL> GL> GL> GL> function closeit() { GL> window.opener.location="index.cfm?fuseaction=members.main"; GL> window.close(); GL> } GL> GL> GL> GL> GL> ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Closing window from inside a frame?
I have a form inside a frameset and after posting the form and processing the data I need to close the window and post back to the "opener". I've used this in an action template before after processing a form submission and it works nicely. But I'm trying to do a similar thing inside a frameset and it doesn't want to close the window. :-( Any ideas? function closeit() { window.opener.location="index.cfm?fuseaction=members.main"; window.close(); } ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Loading Screen for CF-Apps ???
The example on MM.com breaks "called CFFLUSH in an invalid location" for all 3 instances of CFFLUSH in the code snippet. Is there a working example somewhere? Joshua Miller [EMAIL PROTECTED] -Original Message- From: Eric Hoffman [mailto:webmaster@;digitalmpls.com] Sent: Monday, October 28, 2002 11:08 AM To: CF-Talk Subject: RE: Loading Screen for CF-Apps ??? CFFLUSH if you are on 5 or better. That works well. There is an article on MM about how to use with code examples. Regards, Eric J Hoffman Head Tech Geek DataStream Connexion www.datastreamconnexion.com Delivering Creative Data Solutions -Original Message- From: Joshua Miller [mailto:josh@;joshuasmiller.com] Sent: Monday, October 28, 2002 9:07 AM To: CF-Talk Subject: Loading Screen for CF-Apps ??? Hello, I'm writing a web application that uses a WebService for a weather feed and that is also, on the same template, generating a chart using CFCHART of some database data. The site loads quickly except for the page calling these two functions and I'd like to put up some kind of loading screen (x% completed) maybe using FLASH or whatever ... just so I can incrementally show the status to the user so they don't think it's broken and keep clicking "HOME" over and over. Anyone have any suggestions or ideas how to do something like this? Thanks, Joshua Miller [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: [OT] Community Suite Live
> Forever trapped in the DevCon Cyberworld ... > -Original Message- > From: Angel Stewart [mailto:gel@;silkcotton.com] > Sent: October 28, 2002 1:58 PM > To: CF-Talk > Subject: RE: [OT] Community Suite Live > Yes! It was fun... > *sigh* > 'You can Login..but you can never Logout!' You can stab it with your steely code, but you just can't hack the beast... S. Isaac Dealey -- who shouldn't quit his day job Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: db query problem
It's confusing to see what you're trying to acheive because you can't tell from the query code you posted which fields refer to which table. It would help if you assigned table aliases, e.g. SELECT a.field, b.field FROM tableA a, tableB b and posted the code again. Beyond that, maybe UNION would do the trick? SELECT mls, type, asking_price, address, city, state, zip FROM Commercial WHERE listing_office #Request.App.Idx# AND agent = '#Request.User.Idx#' UNION SELECT mls, type, asking_price, address, city, state, zip FROM Multi_Family WHERE listing_office #Request.App.Idx# AND agent = '#Request.User.Idx#' UNION SELECT mls, type, asking_price, address, city, state, zip FROM Land WHERE listing_office #Request.App.Idx# AND agent = '#Request.User.Idx#' UNION cobbles all SELECT statements together, as long as each has the same fields. Check documentation depending on your DB. HTH, Gyrus [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net PGP key available - Original Message - From: "Chris Edwards" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, October 28, 2002 6:08 PM Subject: db query problem > Hi > > I need to condense these queries into one, can anyone help? > > > SELECT mls, type, asking_price, address, city, state, zip > FROM Residential, Commercial, Multi_Family, Land > WHERE listing_office #Request.App.Idx# AND agent = '#Request.User.Idx#' > > > > SELECT mls, type, asking_price, address, city, state, zip > FROM Commercial > WHERE listing_office #Request.App.Idx# AND agent = '#Request.User.Idx#' > > > > SELECT mls, type, asking_price, address, city, state, zip > FROM Multi_Family > WHERE listing_office #Request.App.Idx# AND agent = '#Request.User.Idx#' > > > > SELECT mls, type, asking_price, address, city, state, zip > FROM Land > WHERE listing_office #Request.App.Idx# AND agent = '#Request.User.Idx#' > > > -- > Chris Edwards > Web Application Developer > Outer Banks Internet, Inc. > 252-441-6698 > [EMAIL PROTECTED] > http://www.OuterBanksInternet.com > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Macromedia.com Game
Somehow I don't think that a perfect score on the Macromedia.com test indicates that one could pass the Certification Test if it's all that easy though, maybe I should sign up ;) Joshua Miller [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: [OT] Community Suite Live
Forever trapped in the DevCon Cyberworld ... -Original Message- From: Angel Stewart [mailto:gel@;silkcotton.com] Sent: October 28, 2002 1:58 PM To: CF-Talk Subject: RE: [OT] Community Suite Live Yes! It was fun... *sigh* 'You can Login..but you can never Logout!' Gel AKA Gel :-) -Original Message- From: Yves Arsenault [mailto:yves@;carrefour.peicaps.org] It was fun while it lasted... Not quite like being there. Yves Arsenault AKA CF_Yves :-) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: ie mac problem?
No id doesn't happen on any other browser (NS or IE on pc or NS on mac), after more testing it was losing values when going back to ssl and forward to ssl; it doesn't lose values if you go back to non-ssl and forward to non-ssl. -Original Message- From: Joshua Miller [mailto:josh@;joshuasmiller.com] Sent: Monday, October 28, 2002 10:55 AM To: CF-Talk Subject:RE: ie mac problem? I thought that happened with any browser - switching from SSL to non-SSL and back you lose the data with a message about "Page expired" or something like that. Doesn't this happen on Windows IE as well? Joshua Miller [EMAIL PROTECTED] -Original Message- From: Nick Varner [mailto:VarnerN@;cookministries.org] Sent: Monday, October 28, 2002 12:30 PM To: CF-Talk Subject: ie mac problem? We have a form that people submit information, after submitting the info we confirm the info back to the user. If the user is on IE on the Mac and clicks back enough times to get to our homepage then clicks forward to go back to the confirmation page all of the values are missing. It appears that when IE goes from an SSL (input and confirmation) site to non SSL (home) it losses values; has any one else seen this before or know of a way around it. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
New suite url
http://cfmx.oli.tudelft.nl/flashcom/applications/sample_panel_presentation/c ommunity_small.htm ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com