Re: Templates executing twice CF bug
Ok, here is what I see is hapenning in this situation (and it is NOTHING to do with CF or IIS or anything server side here), quite simple... let's take for exampl the _URL_) you are using in the src of your img tag it has a bit before the first # which in this case is an empty string, and a bit after the first # which isn't important for now. What does this remind you of perhaps something like A SRC=blah.htm#someAnchorfoo/A (by now you probably see your error but I'll continue for those who it is not obvious to). What that anchor does is tells your browser to get blah.htm and display it from the point in the document that the anchor named someAnchor appears. You canm just as easily write A SRC=#someAnchorfoo/A which tells the browser to go to the point in the document where the anchor someAnchor appears. Both of these are valid URLS. The src in an image tag takes a valid URL. So in your example img tag below, when the browser gets that (the hashes come through because there is no cfoutput around it) it reads that as load the image from the current document at the point where the anchor variables.someVariable#/test.gif is written (which of course makes no sense, but the browser doesn't care, all it wanted was a URL and you gave it a URL), it does it's duty, the img tag causes the template to be hit again, and when it gets the results it tries to the anchor you specified (which of course doesn't do anything because not only does the anchor not exist, but that file isn't an image either). Now of course this may not happen on all browsers, mainly because if they are clever enough they will not have to actually hit the server to get the same file they are looking at, and if they are really clever enough they will know that an anchor specification inside an img src is nonsense and will ignore it. Nothing mystical, just not an expected behaviour on behalf of web browsers. At 05:29 PM 12/11/2001, you wrote: img src=#variables.someVariable#/test.gif James Sleeman Innovative Media Ltd Phone: (03) 377 6262 http://www.websolutions.co.nz/ CAUTION: The information contained in this email message is confidential and may be legally privileged. If the reader of this message is not the intended recipient you are notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify the sender immediately and destroy the original message and any attachments. Views expressed in this communication may not be those of Innovative Media Ltd. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How to Sort Multidimensional Array
Paige Chandler wrote: Happy Holidays All, Is it possible to sort a multidimensional array? If what's the syntax? The following doesn't seem to sort: CFSET SortFile = ArraySort(FileArray[1], Text, ASC) There is a customtag for sorting multidimensional arrays at the Developers Exchange. There is also a lot of code available from the CF Challenge to sort 2 queries (you can address queries as arrays) run by Jim Davis of depressedpress.com http://www.depressedpress.com/DepressedPress/Content/ColdFusion/Challenge/CombineSortQuery/Index.cfm Jochem ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Templates executing twice CF bug
Max Paperno wrote:
Greetings,
I've identified a somewhat minor but possibly damaging bug in CF 5.
It is not a bug.
It's pretty strange, but true. Zac Belado has confirmed that this
was also the problem in his case (see his Page Processing Twice message from earlier
today). It seems to only affect CF5 (4.5 was also tried) but so far only tested on
W2K.
Why you believe this is unclear to me. There must be differences in
server setup.
The bug causes a template to be executed twice by the CF engine. It literally runs
everything connected to the request twice (all includes, parent template, etc).
There is no indication of this unless you have data that is noticeably affected (such
as inserting DB records). The HTTP request is not doubled, only the actual CF code
execution. This is not browser or Web server-related in any way.
It is browser related.
The cause seems to be missing cfoutput tags around a variable call, and apparently
specifically in an IMG tag (some others were tried with no problems surfacing).
I would imagine this would also surface with objects, javascript
includes etc.
So some code like this:
img src=#variables.someVariable#/test.gif
(w/out cfoutput tags anywhere around it) will cause double execution. Wrap it in
cfoutputs (or in comments) and the problem goes away.
Strange, no?
Not strange at all.
This is what happens. Inside the page you send to the browser is the
following HTML.
img src=#someVariable#/test.gif
The browser expects to have to display an image with a relavtive
location of #someVariable#/test.gif. But since # means that it is a
named object inside the same page the browser repeats the request to the
webserver to get the same page again. Just like you would use target=#
to make a form post back to itself.
If I run your template normally.
Webserver log:
2001-12-11 09:43:08 130.161.67.244 - W3SVC1 SPIKE GET
/jochemd/bugtest.cfm - 200 641 502 0 HTTP/1.1
Mozilla/5.0+(Windows;+U;+WinNT4.0;+en-US;+rv:0.9.5)+Gecko/20011011
CFID=63542;+CFTOKEN=51494371 -
2001-12-11 09:43:08 130.161.67.244 - W3SVC1 SPIKE GET
/jochemd/bugtest.cfm - 200 643 560 16 HTTP/1.1
Mozilla/5.0+(Windows;+U;+WinNT4.0;+en-US;+rv:0.9.5)+Gecko/20011011
CFID=63542;+CFTOKEN=51494371 http://spike.oli.tudelft.nl/jochemd/bugtest.cfm
BugTestLog.txt:
Ran at {ts '2001-12-11 10:43:08'}
Ran at {ts '2001-12-11 10:43:08'}
But now I disable the automatic loading of images in my browser
(Mozilla: Edit, Preferences, Privacy Security, Images, Do not load
any images).
webserver log:
2001-12-11 09:46:27 130.161.67.244 - W3SVC1 SPIKE GET
/jochemd/bugtest.cfm - 200 641 502 0 HTTP/1.1
Mozilla/5.0+(Windows;+U;+WinNT4.0;+en-US;+rv:0.9.5)+Gecko/20011011
CFID=63542;+CFTOKEN=51494371 -
BugTestLog.txt:
Ran at {ts '2001-12-11 10:46:27'}
FYI:
Browser: Mozilla/5.0 (Windows; U; WinNT4.0; en-US; rv:0.9.5) Gecko/20011011
Server: NT4 SP6a + Security Rolup Package
Webserver: IIS 4 + Security Rollup Package (15 august I believe)
CF: 4.5.1 SP2 Enterprise + Security Fixes
Jochem
~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Does anyone see a problem with this query?
I don't know if I'm alone in this, but at first, second, and third glance your query syntax seems fine. Is there anything else to this query? -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: 11 December 2001 00:42 To: CF-Talk Subject: Does anyone see a problem with this query? I keep getting this error when I run the query. This is a SQL 2K database ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect syntax near '.'. SELECT topc.id, topc.topics, subt.id, subt.topic_id, subt.s_topics FROM topics AS topc INNER JOIN sub_topics AS subt ON topc.id = subt.id WHERE topc.id = subt.id Thanks Doug ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How to Sort Multidimensional Array
Hello Jochem, Thank you. I did find several sorts on the Developer Exchange for two dimensional arrays but none for a 3D. At least that tells me why mine wouldn't work. Have a nice day. Regards, Paige - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 11, 2001 4:24 AM Subject: Re: How to Sort Multidimensional Array Paige Chandler wrote: Happy Holidays All, Is it possible to sort a multidimensional array? If what's the syntax? The following doesn't seem to sort: CFSET SortFile = ArraySort(FileArray[1], Text, ASC) There is a customtag for sorting multidimensional arrays at the Developers Exchange. There is also a lot of code available from the CF Challenge to sort 2 queries (you can address queries as arrays) run by Jim Davis of depressedpress.com http://www.depressedpress.com/DepressedPress/Content/ColdFusion/Challenge/Co mbineSortQuery/Index.cfm Jochem ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF Forums Discussion Forums - Where can I find the source?
Jochem van Dieten wrote: Bosky, Dave wrote: I need to setup a discussion forum and would like to use cfforums, where can I download the free open source to customize? I tried forumspot.org but their site is gone. I emailed the caretaker about it. I expect it will be up shortly, if not contact me off-list for the source. I set up an alternate download at http://spike.oli.tudelft.nl/forumspot/ It is not complete, but it should be sufficient to get a Windows version of the forums running. Jochem ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: Keep search engine spyders from following links
Doesn't robots.txt do the exact job you are after? I don't know the systnax, but any visting spider will most likely request that file 1st, you can tell the spider what to index, and what not to index. Craig. -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: 11 December 2001 00:20 To: CF-Talk Subject: Re: OT: Keep search engine spyders from following links Joe, I'll try it out. Since the links all appear on CF-generated pages (pulled from database tables) I think I should be able to just Unicode the links within the CF templates themselves. Is there a CF Unicode tag or function somewhere, or do Unicode'd string simply use the ASCII codes for each character? Jim - Original Message - From: Joseph DeVore [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, December 10, 2001 5:05 PM Subject: RE: OT: Keep search engine spyders from following links Jim, It is possible to UNICODE HREFs and a lot of bots ignore these types of links. I use unicoded HREFs for all of my email addresses so spam bots don't grab them. I haven't tested unicoded HREFs in all browsers, just Netscape 4.08 and IE 4+ on Windows If you want to take a look at a unicoded href you can use this form to generate them: http://cftags.veloxweb.com/unicode/ HTH, Joseph DeVore VeloxWeb Technologies -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 3:35 PM To: CF-Talk Subject: Re: OT: Keep search engine spyders from following links IIS. What exactly would the ISAPI application do? I suppose within my redirection template I _could_ parse the cgi.useragent string and neither record nor redirect known spyders. Keeping an up-to-date list of agents might be a pain, though. I'd rather just tell the syders (even if only the well-behaved ones) not to follow the link. Jim - Original Message - From: Alex [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, December 10, 2001 3:39 PM Subject: Re: OT: Keep search engine spyders from following links what's your web server? You can write an apache module to do this and I would assume you could do the same with ISAPI On Mon, 10 Dec 2001, Jim McAtee wrote: On a couple of web pages, I run links to outside web sites through a CF template that records the click-through along with some browser and referer stats in a table, then redirects the browser to the target URL. Is there any way to prevent search engine spyders from following these links? If I'm not mistaken, there's no way to use a robots.txt to prevent this behavior, or is there? Thanks, Jim ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: Keep search engine spyders from following links
if i remember correctly you can put all the pages you dont want into a folder, then tell the spider not to index this folder using robots.txt. This would prevent all robots from indexing a folder called private: User-agent: * Disallow: /private/ You can also specify pages: User-agent: * Disallow: /private/secret.html HTH will -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED]] Sent: 11 December 2001 11:51 To: CF-Talk Subject: RE: OT: Keep search engine spyders from following links Doesn't robots.txt do the exact job you are after? I don't know the systnax, but any visting spider will most likely request that file 1st, you can tell the spider what to index, and what not to index. Craig. -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: 11 December 2001 00:20 To: CF-Talk Subject: Re: OT: Keep search engine spyders from following links Joe, I'll try it out. Since the links all appear on CF-generated pages (pulled from database tables) I think I should be able to just Unicode the links within the CF templates themselves. Is there a CF Unicode tag or function somewhere, or do Unicode'd string simply use the ASCII codes for each character? Jim - Original Message - From: Joseph DeVore [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, December 10, 2001 5:05 PM Subject: RE: OT: Keep search engine spyders from following links Jim, It is possible to UNICODE HREFs and a lot of bots ignore these types of links. I use unicoded HREFs for all of my email addresses so spam bots don't grab them. I haven't tested unicoded HREFs in all browsers, just Netscape 4.08 and IE 4+ on Windows If you want to take a look at a unicoded href you can use this form to generate them: http://cftags.veloxweb.com/unicode/ HTH, Joseph DeVore VeloxWeb Technologies -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 3:35 PM To: CF-Talk Subject: Re: OT: Keep search engine spyders from following links IIS. What exactly would the ISAPI application do? I suppose within my redirection template I _could_ parse the cgi.useragent string and neither record nor redirect known spyders. Keeping an up-to-date list of agents might be a pain, though. I'd rather just tell the syders (even if only the well-behaved ones) not to follow the link. Jim - Original Message - From: Alex [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, December 10, 2001 3:39 PM Subject: Re: OT: Keep search engine spyders from following links what's your web server? You can write an apache module to do this and I would assume you could do the same with ISAPI On Mon, 10 Dec 2001, Jim McAtee wrote: On a couple of web pages, I run links to outside web sites through a CF template that records the click-through along with some browser and referer stats in a table, then redirects the browser to the target URL. Is there any way to prevent search engine spyders from following these links? If I'm not mistaken, there's no way to use a robots.txt to prevent this behavior, or is there? Thanks, Jim ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Pcode errors
This happened to us. It kept happening over and over again. We finally (through a fluke) tracked it down to a corrupt record in an Access database. Everytime one of the secretaries would try to edit the record it crashed the CF server! When I looked at the record, it was full of gibberish. I deleted the record and the problem stopped. -Original Message- From: ehoma [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 3:52 PM To: CF-Talk Subject: Help! Hi, Anyone ever seen the following error message? PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (45:1) to (45:53). Our application has been running fine for 3 months and now this occurs on occasion. Hit refresh on the browser and the page runs fine on the reload. It is a page with multiple queries. It is the index page that you are directed to after a login with application, client and session variables set. I'm wondering if it has to do with system resources? Any help? Thanks, Eric Homa FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Anyone else get solicited? FW: CFX ImageCR
Hey..I got this email. It had a response I had made to someone about image manipulation via CF attached, so I really didn't mind it at all. :) Thanks, -Gel -Original Message- From: Efflare Systems [mailto:[EMAIL PROTECTED]] Since I had not read/posted a message since February, I was doing some thorough catchup on cf-talk through the mail-archive web interface. I replied to some of the threads by direct email. The mail Kelly received was meant for someone else. I must have miscopied an address in a thread somewhere. Sorry for any headache this has caused, but it was an honest mistake and you are not part of any spam list. ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ODBC or OLE DB
Hello CF-Talk, What's better/faster ODBC/OLE DB. I'm using SQL2k on Win2k. Kind Regards, Christopher Dawes Dawes International FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is CFGRAPH Crap?
Check with your ISP, they may not have a setting properly configured in CF Server. Mark -Original Message- From: Ron Anderson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 1:44 AM To: CF-Talk Subject: RE: Is CFGRAPH Crap? I keep getting this error: Could not connect to JRun Connector Proxy But I'm only running 1 report with the new CFGraph on it. Are these not scalable?? -Original Message- From: Ben Koshy [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 4:37 PM To: CF-Talk Subject: RE: Is CFGRAPH Crap? My experience is that its CRAP! I played with it a lot when it first came out excited to have a built in graphing feature. Very quickly I realized that it doesn't scale very well for real-world applications. If its not like a percentage or value out of 100 or you want to customize the look of this very generic graph, it appears to be impossible. Or I gave up to early. I'm sure someone could build a better graphing tool with DHTML or the Flash Connector Kit. Ben Koshy Technical Manager W3 International Media Ltd. www.w3media.net 'Web Hosting Professionals' [T]604.871.9899 x388 [T]1.866.4.WEB.NOW x388 [F]604.871.1108 -Original Message- From: Jay Jennings [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 9:15 AM To: CF-Talk Subject: Is CFGRAPH Crap? Is the new CFGRAPH tag crap or is it just designed for very basic usage? Specifically, I need to increase the width of the graph -- partly to make more room for the labels in a vertical bar chart (and partly for aesthetics). I've searched the archives and have seen other people asking but no definitive answer. Should I just bag CFGRAPH or is it a little more robust than I'm thinking at this point? Thanks. jay - - - - - - - - - - - - - - - - - - - - - - - - - - Free toys for your kids! Or, earn extra income while you play! http://www.FamilyToysAndGames.com - - - - - - - - -- - - - - - - - - - - - - - - - - - ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
3 selects related and nightmare trees
Hi all, I posted this on the HouseOfFusion SQL list but haven't had any bites... Can anyone help? I have a limited tree kind of deal going with a table of categories - the structure is like so: pkCategoriescategory_name fkParentCategory To save it from turning into absolute hell, there can only be three categories deep - so a category can have a subcategory which can have subcategories, but that's as far as it goes. I want to use Nate Weiss's custom tag three selects related. To use it I need to create a query object with the following structure: grandparentID grandparentname parentIDparentname childID childname I have no idea how to write such a beast. I started out with: SELECT A.pkCategories, A.category_name, A.fkParentCategory, ( SELECT B.pkCategories, B.category_name, B.fkParentCategory FROM Categories B WHERE B.pkCategories = A.fkParentCategory ) FROM Categories A But I'm not really sure what I'm doing or where I'm going :) If it's not possible with SQL, I could use CF's query functions to create what I need. That requires a whole rethink though. Any help greatly appreciated! Kay. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: ODBC or OLE DB
Christopher Dawes wrote: Hello CF-Talk, What's better/faster ODBC/OLE DB. I'm using SQL2k on Win2k. Better: ODBC from a portability point of view, OLE DB from a technical point of view (see faster). Faster: OLE DB. In this case (SQL2K) ODBC is actually a layer on top of OLE DB. That layer introduces some performance loss, and also an extra point of failure. Jochem ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ODBC or OLE DB
OLEDB seems to be slightly faster under load, nothing much in it though under normal conditions. ODBC drivers can apparantly suffer from memory leaks under certain circumstances. Although I've never really seen any evidence of this using SQL server. OLEDB handles dates and boolean fields slightly differently at times (perhaps other data types too?), converting sites that use ODBC can be a pain. I've used both quite bit, and still don't have a preference. If I was trying to decide which to use for a new site, then I would probably go with ODBC as I know it better and find it easier. Craig. -Original Message- From: Christopher Dawes [mailto:[EMAIL PROTECTED]] Sent: 11 December 2001 13:36 To: CF-Talk Subject: ODBC or OLE DB Hello CF-Talk, What's better/faster ODBC/OLE DB. I'm using SQL2k on Win2k. Kind Regards, Christopher Dawes Dawes International FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFGRAPH
Hi Cfers, I am battling to get the URL attribute to work with a line graph. It is working with a bar graph but not with the line graph. Is there a limitation with the line graph that you guys are aware of? TIA ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Rcurring Event for Calendar
I need to be able to schedule recurring events on our calendar. For example every 3rd Monday of the month for say 6 months. I think I figured out how to find the 3rd Monday of the month, but it is not the fast way I think. What I am doing is finding the first day of the month then looping through each day until I get to the 3rd occurrence of whatever day I am looking for in this case the 3rd Monday. What I would like to know; is there a formula for calculating a particular day of the month is this case say the 3rd Monday of each month? David ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: 3 selects related and nightmare trees
Kay, When I made my 3 select I resorted to doing it in access and then modifying the sql that i needed to make the 3 select work. It's a huge burdensome query and I don't know if it's overkill or not. I'm showing you my query so you'll have an idea about what i did. Mine was for a school the user picks a grade then picks a teacher then can pick student(s). I've taken three tables for this: Teacher, Student and Class tables. (my client.schoolnum maybe confusing- to make a unique teacherid we need the school number and the teacher number). I added my formatting inside my query because I couldn't find a way to do it otherwise (LASTNAME + ', '+FIRSTNAME AS NAME) I hope this is helpful... j CFQUERY NAME=GradeTeachStudent DATASOURCE=#Request.dsn# SELECT Teachers.GRADE, Students.GRADE, Students.LASTNAME, Students.FIRSTNAME, CLASS.CLASSID, LASTNAME +', '+ FIRSTNAME AS NAME, CLASS.SCHOOLNUM, CLASS.TeachType, Students.ID, Teachers.TCHNAME FROM Teachers INNER JOIN (CLASS INNER JOIN Students ON CLASS.ID = Students.ID) ON (Teachers.CLASSLINK = CLASS.CLASSID) AND (Teachers.SCHOOLNUM = CLASS.SCHOOLNUM) WHERE Teachers.SCHOOLNUM=#CLIENT.SCHOOLNUM# AND (CLASS.TeachType='Homeroom') AND CLASS.CLASSID=Teachers.CLASSID AND CLASS.ID =Students.ID ORDER BY Students.GRADE, Teachers.TCHNAME, Students.LASTNAME /CFQUERY -Original Message- From: Kay Smoljak [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 8:43 AM To: CF-Talk Subject: 3 selects related and nightmare trees Hi all, I posted this on the HouseOfFusion SQL list but haven't had any bites... Can anyone help? I have a limited tree kind of deal going with a table of categories - the structure is like so: pkCategoriescategory_name fkParentCategory To save it from turning into absolute hell, there can only be three categories deep - so a category can have a subcategory which can have subcategories, but that's as far as it goes. I want to use Nate Weiss's custom tag three selects related. To use it I need to create a query object with the following structure: grandparentID grandparentname parentIDparentname childID childname I have no idea how to write such a beast. I started out with: SELECT A.pkCategories, A.category_name, A.fkParentCategory, ( SELECT B.pkCategories, B.category_name, B.fkParentCategory FROM Categories B WHERE B.pkCategories = A.fkParentCategory ) FROM Categories A But I'm not really sure what I'm doing or where I'm going :) If it's not possible with SQL, I could use CF's query functions to create what I need. That requires a whole rethink though. Any help greatly appreciated! Kay. ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ODBC or OLE DB
I'm curious as to what differences you've found as I've used both interchangeably without any problems whatsoever. Could you possibly enumerate the differences for the benefit of the list. Cheers, Steve OLEDB handles dates and boolean fields slightly differently at times (perhaps other data types too?), converting sites that use ODBC can be a pain. I've used both quite bit, and still don't have a preference. If I was trying to decide which to use for a new site, then I would probably go with ODBC as ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is CFGRAPH Crap?
I just use it for very basic things as I find the tag very limiting. For example: I can't figure out how to apply formatting to the numbers in the graph. On some reports, I have values that are in the millions - It doesn't look very good when you have a graph with a number like 100 Maybe neo will provide more integration. -Original Message- From: Jay Jennings [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 12:15 PM To: CF-Talk Subject: Is CFGRAPH Crap? Is the new CFGRAPH tag crap or is it just designed for very basic usage? Specifically, I need to increase the width of the graph -- partly to make more room for the labels in a vertical bar chart (and partly for aesthetics). I've searched the archives and have seen other people asking but no definitive answer. Should I just bag CFGRAPH or is it a little more robust than I'm thinking at this point? Thanks. jay - - - - - - - - - - - - - - - - - - - - - - - - - - Free toys for your kids! Or, earn extra income while you play! http://www.FamilyToysAndGames.com - - - - - - - - -- - - - - - - - - - - - - - - - - - ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Trimming Files
Does anyone have a quick way to trim extra lines from a text file? I have an app that uploads a text file and processes it as a TSV file, but some users are exporting from MS Access, which is adding some extra line feeds to the end. Any suggestions? C. Hatton Humphrey, Developer Fisher, Towne Associates 716-839-2141 x336 [EMAIL PROTECTED] ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Java Byte Code
I'm currently learning Java and I'm very excited to see Macromedia moving in the Java direction. However, one of my co-workers stated that Java byte code was very slow. Since I'm just learning Java, I didn't have a good retort for him at the moment. So, I'm turning to you for some answers here. Is this true? In my limited work with Java, I haven't seen it to be slow. But then again, I don't expect a little Hello World app to be slow. Any suggestions or places that I can find some answers? Thanks, Mark Stewart Programmer/Analyst CC3 Phone: 215.672.6900 x1332 http://www.cc3.com ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Java Byte Code
java is slower than some other languages (e.g C++), but thats a pice you pay for portability Mark -Original Message- From: Mark Stewart [mailto:[EMAIL PROTECTED]] Sent: 11 December 2001 14:40 To: CF-Talk Subject: OT: Java Byte Code I'm currently learning Java and I'm very excited to see Macromedia moving in the Java direction. However, one of my co-workers stated that Java byte code was very slow. Since I'm just learning Java, I didn't have a good retort for him at the moment. So, I'm turning to you for some answers here. Is this true? In my limited work with Java, I haven't seen it to be slow. But then again, I don't expect a little Hello World app to be slow. Any suggestions or places that I can find some answers? Thanks, Mark Stewart Programmer/Analyst CC3 Phone: 215.672.6900 x1332 http://www.cc3.com ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Trimming Files
Depending on what line separator(s) are used... you can do it a few different ways. But ones that come to mind this instant are... 1. Use a regular expression, I don't use the builtin regexp coldfusion stuff 2. Search and replace on two instance of the separator(s), then clean the last line, if exists 3. Loops lines and manually parse, removing startline+whitespace+endline if it appears 4. Write or have someone write a simple custom tag that does this if you need efficiency, future use, ease. - Original Message - From: C. Hatton Humphrey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 11, 2001 8:40 AM Subject: Trimming Files Does anyone have a quick way to trim extra lines from a text file? I have an app that uploads a text file and processes it as a TSV file, but some users are exporting from MS Access, which is adding some extra line feeds to the end. Any suggestions? C. Hatton Humphrey, Developer Fisher, Towne Associates 716-839-2141 x336 [EMAIL PROTECTED] ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Java Byte Code
I wouldn't call java slow, loading a jvm can be slow, depending on platform, but once it's loaded java isn't slow at all. -Original Message- From: Mark Smyth [mailto:[EMAIL PROTECTED]] Sent: 11 December 2001 14:41 To: CF-Talk Subject: RE: Java Byte Code java is slower than some other languages (e.g C++), but thats a pice you pay for portability Mark -Original Message- From: Mark Stewart [mailto:[EMAIL PROTECTED]] Sent: 11 December 2001 14:40 To: CF-Talk Subject: OT: Java Byte Code I'm currently learning Java and I'm very excited to see Macromedia moving in the Java direction. However, one of my co-workers stated that Java byte code was very slow. Since I'm just learning Java, I didn't have a good retort for him at the moment. So, I'm turning to you for some answers here. Is this true? In my limited work with Java, I haven't seen it to be slow. But then again, I don't expect a little Hello World app to be slow. Any suggestions or places that I can find some answers? Thanks, Mark Stewart Programmer/Analyst CC3 Phone: 215.672.6900 x1332 http://www.cc3.com ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Trimming Files
Or just use Trim() on the variable containing the file content and then write it out again. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 11 December 2001 14:44 To: CF-Talk Subject: Re: Trimming Files Depending on what line separator(s) are used... you can do it a few different ways. But ones that come to mind this instant are... 1. Use a regular expression, I don't use the builtin regexp coldfusion stuff 2. Search and replace on two instance of the separator(s), then clean the last line, if exists 3. Loops lines and manually parse, removing startline+whitespace+endline if it appears 4. Write or have someone write a simple custom tag that does this if you need efficiency, future use, ease. - Original Message - From: C. Hatton Humphrey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 11, 2001 8:40 AM Subject: Trimming Files Does anyone have a quick way to trim extra lines from a text file? I have an app that uploads a text file and processes it as a TSV file, but some users are exporting from MS Access, which is adding some extra line feeds to the end. Any suggestions? C. Hatton Humphrey, Developer Fisher, Towne Associates 716-839-2141 x336 [EMAIL PROTECTED] ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Trimming Files
C. Hatton Humphrey wrote: Does anyone have a quick way to trim extra lines from a text file? I have an app that uploads a text file and processes it as a TSV file, but some users are exporting from MS Access, which is adding some extra line feeds to the end. Any suggestions? Read it, parse it, overwrite it. Probably the best way to parse it would be a regular expression like: cfset text=REReplaceNoCase(text,(^.*[^[:space:]])[[:space:]]*$,\1) (I believe linefeeds are in the space clase, could be control as well in which case you need to change accordingly.) Jochem ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Type mismatch in expression
I am getting a type mismatch error with this query. I am currently using Access while waiting for SQL Server connection to be configured.I cant see what ius causing the error? cfquery name=GetFunds datasource=infotrac_test select tbl_accounts.account_id, tbl_accounts.account, tbl_fundsrc.fund_id, tbl_fundsrc.type_fund, tbl_codes.code_id, tbl_codes.code fromtbl_accounts, tbl_fundsrc, tbl_codes where tbl_accounts.account_id = tbl_fundsrc.fund_id and tbl_fundsrc.fund_id = tbl_codes.code_id order by tbl_accounts.account_id, tbl_fundsrc.fund_id /cfquery ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Rcurring Event for Calendar
If you're on CF5, use the UDF, otherwise copy the code http://www.cflib.org/udf.cfm?ID=179 -Original Message- From: David Brown [mailto:[EMAIL PROTECTED]] Sent: dinsdag 11 december 2001 15:01 To: CF-Talk Subject: Rcurring Event for Calendar I need to be able to schedule recurring events on our calendar. For example every 3rd Monday of the month for say 6 months. I think I figured out how to find the 3rd Monday of the month, but it is not the fast way I think. What I am doing is finding the first day of the month then looping through each day until I get to the 3rd occurrence of whatever day I am looking for in this case the 3rd Monday. What I would like to know; is there a formula for calculating a particular day of the month is this case say the 3rd Monday of each month? David ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ODBC or OLE DB
The last problem I had was runnign query a query on a recordset returned via oledb, all the sql BIT fields were coming back as 'Yes' and 'No' as oppossed to 0/1. -Original Message- From: Steve Martin [mailto:[EMAIL PROTECTED]] Sent: 11 December 2001 14:28 To: CF-Talk Subject: RE: ODBC or OLE DB I'm curious as to what differences you've found as I've used both interchangeably without any problems whatsoever. Could you possibly enumerate the differences for the benefit of the list. Cheers, Steve OLEDB handles dates and boolean fields slightly differently at times (perhaps other data types too?), converting sites that use ODBC can be a pain. I've used both quite bit, and still don't have a preference. If I was trying to decide which to use for a new site, then I would probably go with ODBC as ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ODBC or OLE DB
All my bit fields come back as 1/0 both in OLEDB and ODBC. All my date fields are treated the same. Text (VC, Text, etc.) fields, no probs. Numerics - all OK Anyone out there actually KNOW of any fundamental differences on the SQL interface level? -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED]] Sent: 11 December 2001 14:51 To: CF-Talk Subject: RE: ODBC or OLE DB The last problem I had was runnign query a query on a recordset returned via oledb, all the sql BIT fields were coming back as 'Yes' and 'No' as oppossed to 0/1. -Original Message- From: Steve Martin [mailto:[EMAIL PROTECTED]] Sent: 11 December 2001 14:28 To: CF-Talk Subject: RE: ODBC or OLE DB I'm curious as to what differences you've found as I've used both interchangeably without any problems whatsoever. Could you possibly enumerate the differences for the benefit of the list. Cheers, Steve OLEDB handles dates and boolean fields slightly differently at times (perhaps other data types too?), converting sites that use ODBC can be a pain. I've used both quite bit, and still don't have a preference. If I was trying to decide which to use for a new site, then I would probably go with ODBC as ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Send response to browser, but continue working on request?
I have a function that allows a user to create a file of available inventory. The problem is that it takes a long time and eventually the browser will timeout, but they haven't gotten their file yet... What I want to do is let the user make the request and then respond with Thank you for your request. Your file will be created and emailed to you shortly. How can I spawn off the part that will actually create the file and still respond with a finished request to the browser? Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion http://www.is300.net ___The Enthusiast's Home of the Lexus IS300 http://www.digitacamera.com __DigitA Camera Scripts and Tips http://www.linklabexchange.com _Miata Link ECU Data Exchange ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: Java Byte Code
Ask your coworker why He says it's slow? He probably only says that because that's what was written a few years ago. Yes, java is slower than C, C++, assembly, and any truely compiled language. But development time, ease of use, and somewhat portability makes it good. Besides, who cares if it's slow; java is where the jobs are at. On Tue, 11 Dec 2001, Mark Stewart wrote: I'm currently learning Java and I'm very excited to see Macromedia moving in the Java direction. However, one of my co-workers stated that Java byte code was very slow. Since I'm just learning Java, I didn't have a good retort for him at the moment. So, I'm turning to you for some answers here. Is this true? In my limited work with Java, I haven't seen it to be slow. But then again, I don't expect a little Hello World app to be slow. Any suggestions or places that I can find some answers? Thanks, Mark Stewart Programmer/Analyst CC3 Phone: 215.672.6900 x1332 http://www.cc3.com ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFDirectory and Network
I'm trying to do a cfdirectory across our network from the server to a mapped drive (i.e. the H:\ drive) Everthing works fine on the locals but I get nothing back on the mapped drive. Am I missing something in the doc about not being able to do this ? TIA Richard ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Send response to browser, but continue working on request?
If you are running CF5, just use CFFLUSH. Sample: ... Hey, I'm doing a bunch of junk, please stand by CFFLUSH CFREALSLOWTHING === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 10:17 AM To: CF-Talk Subject: Send response to browser, but continue working on request? I have a function that allows a user to create a file of available inventory. The problem is that it takes a long time and eventually the browser will timeout, but they haven't gotten their file yet... What I want to do is let the user make the request and then respond with Thank you for your request. Your file will be created and emailed to you shortly. How can I spawn off the part that will actually create the file and still respond with a finished request to the browser? Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion http://www.is300.net ___The Enthusiast's Home of the Lexus IS300 http://www.digitacamera.com __DigitA Camera Scripts and Tips http://www.linklabexchange.com _Miata Link ECU Data Exchange ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFDirectory and Network
Make sure the account that CF is running under (system by default) has network rights. Typically, the system account on a webserver doesn't have network privs. Change the account that CF runs as using the services control panel to an account that has network rights. Jeff Garza Lead Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: webmaster [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 8:05 AM To: CF-Talk Subject: CFDirectory and Network I'm trying to do a cfdirectory across our network from the server to a mapped drive (i.e. the H:\ drive) Everthing works fine on the locals but I get nothing back on the mapped drive. Am I missing something in the doc about not being able to do this ? TIA Richard ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Send response to browser, but continue working on request?
Have you tried cfflush? I believe this tag will allow you to send partial responses to the browser. I might have spelled it wrong, but I am sure there is a function in CF. David - Original Message - From: Tony Schreiber [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 11, 2001 7:17 AM Subject: Send response to browser, but continue working on request? I have a function that allows a user to create a file of available inventory. The problem is that it takes a long time and eventually the browser will timeout, but they haven't gotten their file yet... What I want to do is let the user make the request and then respond with Thank you for your request. Your file will be created and emailed to you shortly. How can I spawn off the part that will actually create the file and still respond with a finished request to the browser? Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion http://www.is300.net ___The Enthusiast's Home of the Lexus IS300 http://www.digitacamera.com __DigitA Camera Scripts and Tips http://www.linklabexchange.com _Miata Link ECU Data Exchange ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: Java Byte Code
I like your attitude Alex! Excellent response and it makes perfect sense (especially the part about the jobs). Thanks, Mark -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 10:02 AM To: CF-Talk Subject: Re: OT: Java Byte Code Ask your coworker why He says it's slow? He probably only says that because that's what was written a few years ago. Yes, java is slower than C, C++, assembly, and any truely compiled language. But development time, ease of use, and somewhat portability makes it good. Besides, who cares if it's slow; java is where the jobs are at. On Tue, 11 Dec 2001, Mark Stewart wrote: I'm currently learning Java and I'm very excited to see Macromedia moving in the Java direction. However, one of my co-workers stated that Java byte code was very slow. Since I'm just learning Java, I didn't have a good retort for him at the moment. So, I'm turning to you for some answers here. Is this true? In my limited work with Java, I haven't seen it to be slow. But then again, I don't expect a little Hello World app to be slow. Any suggestions or places that I can find some answers? Thanks, Mark Stewart Programmer/Analyst CC3 Phone: 215.672.6900 x1332 http://www.cc3.com ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFDirectory and Network
If you can, try a Web Server mapping or use UNC Mark -Original Message- From: webmaster [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 10:05 AM To: CF-Talk Subject: CFDirectory and Network I'm trying to do a cfdirectory across our network from the server to a mapped drive (i.e. the H:\ drive) Everthing works fine on the locals but I get nothing back on the mapped drive. Am I missing something in the doc about not being able to do this ? TIA Richard ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Send response to browser, but continue working on request?
That let's me get a message to the browser, but the request is still running and the browser is still waiting... I want to browser to stop waiting... Have you tried cfflush? I believe this tag will allow you to send partial responses to the browser. I might have spelled it wrong, but I am sure there is a function in CF. David - Original Message - From: Tony Schreiber [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 11, 2001 7:17 AM Subject: Send response to browser, but continue working on request? I have a function that allows a user to create a file of available inventory. The problem is that it takes a long time and eventually the browser will timeout, but they haven't gotten their file yet... What I want to do is let the user make the request and then respond with Thank you for your request. Your file will be created and emailed to you shortly. How can I spawn off the part that will actually create the file and still respond with a finished request to the browser? Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion http://www.is300.net ___The Enthusiast's Home of the Lexus IS300 http://www.digitacamera.com __DigitA Camera Scripts and Tips http://www.linklabexchange.com _Miata Link ECU Data Exchange ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFDirectory and Network
webmaster wrote: I'm trying to do a cfdirectory across our network from the server to a mapped drive (i.e. the H:\ drive) Everthing works fine on the locals but I get nothing back on the mapped drive. Am I missing something in the doc about not being able to do this ? Have a look at kb article 11859. Jochem ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: UPS Prices
well the connection failure was me being short sighted and not realizing that there was some server setting that has been changed and needed to be changed back to get cfhttp to work, which I finally figured out and got the sysadmin to fix, but now that I'm actually connecting, which is always a good start, I'm getting the message UPSOnLine5%Missing ActionCode%6837 when I try to run the tag with one of the example usages. where are you downloading it from? I'm obviously not looking at the same version you are. -Original Message- From: Judith Taylor [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 11:26 AM To: CF-Talk Subject: RE: UPS Prices Well, I've just downloaded a new copy of the tag, and compared it with the version I've been usingthere are no differences in the tag itself. How are you calling the tag? That may be where the problem is.what is the code you're using when you call it? Trying to help, Judith Dunwiddie, Bruce put into words: The FileContent is coming back with Connection Failure and that's it. When I go to the url in a browser, I get UPSOnLine5%Missing ActionCode%6837. In the code, there's a line that says CFIF ListFirst(CFHTTP.FileContent, %) IS UPSOnLine3. I'm kind of at a loss if it's something wrong on my end, but it really looks to me like this one is on the wrong version by that upsonline #, and I tried changing the code to look for upsonline5, and I still get the same. Could you fill in on maybe some other processes I need to do to use the script. I don't see any login variables or anything... Judith Taylor Freelance ColdFusion Developer - Athens, OH ICQ: 67460562 | YahooID: lace_n_steel | AIM: BlacksmithLace Friends don't let friends code before coffee. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Send response to browser, but continue working on request?
Tony Schreiber wrote: That let's me get a message to the browser, but the request is still running and the browser is still waiting... I want to browser to stop waiting... Could you send some javascript to the browser with CFFLUSH that does a redirect? script language=javascript window.location = thankyou.cfm; /script Jochem ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFDirectory and Network
You have to refer to network computers via the network name. CF does not like mapped drives. Example: cffile action=read file=\\OTHERSERVERNAME\FOLDER\FILENAME.TXT ... Justin Hansen - [EMAIL PROTECTED] Project Leader / Web Application Developer Interactive Business Solutions, Inc 816-221-5200 ext. 1305 -Original Message- From: webmaster [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 9:05 AM To: CF-Talk Subject: CFDirectory and Network I'm trying to do a cfdirectory across our network from the server to a mapped drive (i.e. the H:\ drive) Everthing works fine on the locals but I get nothing back on the mapped drive. Am I missing something in the doc about not being able to do this ? TIA Richard ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFDirectory and Network
Jeff, Thanks a million - that did the trick ! Richard - Original Message - From: Garza, Jeff [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 11, 2001 7:23 AM Subject: RE: CFDirectory and Network Make sure the account that CF is running under (system by default) has network rights. Typically, the system account on a webserver doesn't have network privs. Change the account that CF runs as using the services control panel to an account that has network rights. Jeff Garza Lead Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: webmaster [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 8:05 AM To: CF-Talk Subject: CFDirectory and Network I'm trying to do a cfdirectory across our network from the server to a mapped drive (i.e. the H:\ drive) Everthing works fine on the locals but I get nothing back on the mapped drive. Am I missing something in the doc about not being able to do this ? TIA Richard ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Send response to browser, but continue working on request?
you are wanting the browser to make a request for a file but not wait for the file to be retrieved? if so, I don't think that's feasible. a general solution for the problem of generating the email would be to have a img src=createfile.cfm that can send out the email and you can show them whatever message you'd like to show them and the browser waiting for more should have no effect on the cfm or on the user. -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 9:33 AM To: CF-Talk Subject: Re: Send response to browser, but continue working on request? That let's me get a message to the browser, but the request is still running and the browser is still waiting... I want to browser to stop waiting... Have you tried cfflush? I believe this tag will allow you to send partial responses to the browser. I might have spelled it wrong, but I am sure there is a function in CF. David - Original Message - From: Tony Schreiber [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 11, 2001 7:17 AM Subject: Send response to browser, but continue working on request? I have a function that allows a user to create a file of available inventory. The problem is that it takes a long time and eventually the browser will timeout, but they haven't gotten their file yet... What I want to do is let the user make the request and then respond with Thank you for your request. Your file will be created and emailed to you shortly. How can I spawn off the part that will actually create the file and still respond with a finished request to the browser? Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion http://www.is300.net ___The Enthusiast's Home of the Lexus IS300 http://www.digitacamera.com __DigitA Camera Scripts and Tips http://www.linklabexchange.com _Miata Link ECU Data Exchange ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Send response to browser, but continue working on request?
Perhaps you could use the CFSCHEDULE tag to programmatically schedule a job to run (soon) which generates the file and sends the email? Then the page that the user sees will be done as soon as the job is scheduled (should be quick). Though some people hate CFSCHEDULE and I haven't used it much. -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 10:33 AM To: CF-Talk Subject: Re: Send response to browser, but continue working on request? That let's me get a message to the browser, but the request is still running and the browser is still waiting... I want to browser to stop waiting... Have you tried cfflush? I believe this tag will allow you to send partial responses to the browser. I might have spelled it wrong, but I am sure there is a function in CF. David - Original Message - From: Tony Schreiber [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 11, 2001 7:17 AM Subject: Send response to browser, but continue working on request? I have a function that allows a user to create a file of available inventory. The problem is that it takes a long time and eventually the browser will timeout, but they haven't gotten their file yet... What I want to do is let the user make the request and then respond with Thank you for your request. Your file will be created and emailed to you shortly. How can I spawn off the part that will actually create the file and still respond with a finished request to the browser? Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion http://www.is300.net ___The Enthusiast's Home of the Lexus IS300 http://www.digitacamera.com __DigitA Camera Scripts and Tips http://www.linklabexchange.com _Miata Link ECU Data Exchange ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Does anyone see a problem with this query?
Absolutely nothing else. Doug - Original Message - From: Mike Connolly [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 11, 2001 2:12 AM Subject: RE: Does anyone see a problem with this query? I don't know if I'm alone in this, but at first, second, and third glance your query syntax seems fine. Is there anything else to this query? -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: 11 December 2001 00:42 To: CF-Talk Subject: Does anyone see a problem with this query? I keep getting this error when I run the query. This is a SQL 2K database ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect syntax near '.'. SELECT topc.id, topc.topics, subt.id, subt.topic_id, subt.s_topics FROM topics AS topc INNER JOIN sub_topics AS subt ON topc.id = subt.id WHERE topc.id = subt.id Thanks Doug ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Send response to browser, but continue working on request?
Tony; The scheme I used in the past to do something similar was the following. Please keep in mind this is pre-version 5 and may no longer be the best practice. 1) Update a database with the user's id and the details on the page to generate (any variables passed, etc.). Display a page explaining the user will receive an email with download instructions. 2) CFSCHEDULE the page to generate the report ON ANOTHER BOX so you won't bog down a production server with long running pages. Set the timeout on this template to serve your needs. Make sure you use CFERROR or CFCATCH to monitor the template's progress. It is a good idea to set yourself up to be notified in case of errors. 3) Use CFFILE to create the file and store the file name and path in a database for later removal. 4) Update the database to indicate the page has generated or Delete the record to remove it from the queue. 5) CFMAIL the client download instructions on successful creation of the file. Tell the user how long they will have to download the file. You may wish to have the client download the page via CFCONTENT and have some error handling set up at this stage to avoid any snafus. 6) CFSCHEDULE another page to delete old files using the information stored in step 3. No need to keep reports that have already been created. Good luck, Mike -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 10:17 AM To: CF-Talk Subject: Send response to browser, but continue working on request? I have a function that allows a user to create a file of available inventory. The problem is that it takes a long time and eventually the browser will timeout, but they haven't gotten their file yet... What I want to do is let the user make the request and then respond with Thank you for your request. Your file will be created and emailed to you shortly. How can I spawn off the part that will actually create the file and still respond with a finished request to the browser? Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion http://www.is300.net ___The Enthusiast's Home of the Lexus IS300 http://www.digitacamera.com __DigitA Camera Scripts and Tips http://www.linklabexchange.com _Miata Link ECU Data Exchange ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Does anyone see a problem with this query?
What is the error you are getting? -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 11:39 AM To: CF-Talk Subject: Re: Does anyone see a problem with this query? Absolutely nothing else. Doug - Original Message - From: Mike Connolly [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 11, 2001 2:12 AM Subject: RE: Does anyone see a problem with this query? I don't know if I'm alone in this, but at first, second, and third glance your query syntax seems fine. Is there anything else to this query? -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: 11 December 2001 00:42 To: CF-Talk Subject: Does anyone see a problem with this query? I keep getting this error when I run the query. This is a SQL 2K database ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect syntax near '.'. SELECT topc.id, topc.topics, subt.id, subt.topic_id, subt.s_topics FROM topics AS topc INNER JOIN sub_topics AS subt ON topc.id = subt.id WHERE topc.id = subt.id Thanks Doug ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Trimming Files
Parse the file as a list, with a carriage return as your delimiter. Each list element will represent a line. ListDeleteAt() any lines that are empty. cfset lineNum = 1 cfloop index=thisLine list=#fileContents# delimiters=#chr(10)# cfif not len(trim(thisLine)) cfset fileContents = listDeleteAt(list,lineNum,chr(10)) cfelse cfset lineNum = lineNum + 1 /cfif /cfloop --- Billy Cravens - Original Message - From: C. Hatton Humphrey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 11, 2001 8:40 AM Subject: Trimming Files Does anyone have a quick way to trim extra lines from a text file? I have an app that uploads a text file and processes it as a TSV file, but some users are exporting from MS Access, which is adding some extra line feeds to the end. Any suggestions? C. Hatton Humphrey, Developer Fisher, Towne Associates 716-839-2141 x336 [EMAIL PROTECTED] ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Does anyone see a problem with this query?
Here is the original post ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect syntax near '.'. SELECT topc.id, topc.topics, subt.id, subt.topic_id, subt.s_topics FROM topics AS topc INNER JOIN sub_topics AS subt ON topc.id = subt.id WHERE topc.id = subt.id - Original Message - From: Michael Haggerty [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 11, 2001 8:27 AM Subject: RE: Does anyone see a problem with this query? What is the error you are getting? -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 11:39 AM To: CF-Talk Subject: Re: Does anyone see a problem with this query? Absolutely nothing else. Doug - Original Message - From: Mike Connolly [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 11, 2001 2:12 AM Subject: RE: Does anyone see a problem with this query? I don't know if I'm alone in this, but at first, second, and third glance your query syntax seems fine. Is there anything else to this query? -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: 11 December 2001 00:42 To: CF-Talk Subject: Does anyone see a problem with this query? I keep getting this error when I run the query. This is a SQL 2K database ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect syntax near '.'. SELECT topc.id, topc.topics, subt.id, subt.topic_id, subt.s_topics FROM topics AS topc INNER JOIN sub_topics AS subt ON topc.id = subt.id WHERE topc.id = subt.id Thanks Doug ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: 3 selects related and nightmare trees
The below piece is from the SQL books online and provides a sample of handling expanding heirarchies. This may be what you are looking for (though it will probably only work in SQL, not access)... Expanding Hierarchies Databases often store hierarchical information. For example, the following data is a hierarchical representation of regions of the world. This representation does not clearly show the structure implied by the data. Parent Child -- -- World Europe World North America Europe France France Paris North America United States North America Canada United States New York United States Washington New York New York City Washington Redmond This example is easier to interpret: World North America Canada United States Washington Redmond New York New York City Europe France Paris The following Transact-SQL procedure expands an encoded hierarchy to any arbitrary depth. Although Transact-SQL supports recursion, it is more efficient to use a temporary table as a stack to keep track of all of the items for which processing has begun but is not complete. When processing is complete for a particular item, it is removed from the stack. New items are added to the stack as they are identified. CREATE PROCEDURE expand (@current char(20)) as SET NOCOUNT ON DECLARE @level int, @line char(20) CREATE TABLE #stack (item char(20), level int) INSERT INTO #stack VALUES (@current, 1) SELECT @level = 1 WHILE @level 0 BEGIN IF EXISTS (SELECT * FROM #stack WHERE level = @level) BEGIN SELECT @current = item FROM #stack WHERE level = @level SELECT @line = space(@level - 1) + @current PRINT @line DELETE FROM #stack WHERE level = @level AND item = @current INSERT #stack SELECT child, @level + 1 FROM hierarchy WHERE parent = @current IF @@ROWCOUNT 0 SELECT @level = @level + 1 END ELSE SELECT @level = @level - 1 END -- WHILE The input parameter (@current) indicates the place in the hierarchy to start. It also keeps track of the current item in the main loop. The two local variables used are @level, which keeps track of the current level in the hierarchy, and @line, which is a work area used to construct the indented line. The SET NOCOUNT ON statement avoids cluttering up the output with ROWCOUNT messages from each SELECT. The temporary table, #stack, is created and primed with the item identifier of the starting point in the hierarchy, and @level is set to match. The level column in #stack allows the same item to appear at multiple levels in the database. Although this situation does not apply to the geographic data in the example, it can apply in other examples. In this example, when @level is greater than 0, the procedure follows several steps: If there are any items in the stack at the current level (@level), the procedure chooses one and calls it @current. Indents the item @level spaces, and then prints the item. Deletes the item from the stack so it won't be processed again, and then adds all its child items to the stack at the next level (@level + 1). This is the only place where the hierarchy table (#stack) is used. Note With a conventional programming language, you would have to find each child item and add it to the stack individually. With Transact-SQL, you can find all child items and add them with a single statement, avoiding another nested loop. If there are child items (IF @@ROWCOUNT 0), descends one level to process them (@level = @level + 1); otherwise, continues processing at the current level. Finally, if there are no items on the stack awaiting processing at the current level, goes back up one level to see if there are any awaiting processing at the previous level (@level = @level - 1). When there is no previous level, the expansion is complete. -Original Message- From: Kay Smoljak [mailto:[EMAIL PROTECTED]] Sent: Tuesday,
RE: Does anyone see a problem with this query?
I have a feeling that this is not the actual query that's running, you're just assuming it is. I may be wrong, but what is the actual cfquery block containing this query? don't modify it at all, just show the actual cfm query... -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 10:49 AM To: CF-Talk Subject: Re: Does anyone see a problem with this query? Here is the original post ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect syntax near '.'. SELECT topc.id, topc.topics, subt.id, subt.topic_id, subt.s_topics FROM topics AS topc INNER JOIN sub_topics AS subt ON topc.id = subt.id WHERE topc.id = subt.id - Original Message - From: Michael Haggerty [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 11, 2001 8:27 AM Subject: RE: Does anyone see a problem with this query? What is the error you are getting? -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 11:39 AM To: CF-Talk Subject: Re: Does anyone see a problem with this query? Absolutely nothing else. Doug - Original Message - From: Mike Connolly [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 11, 2001 2:12 AM Subject: RE: Does anyone see a problem with this query? I don't know if I'm alone in this, but at first, second, and third glance your query syntax seems fine. Is there anything else to this query? -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: 11 December 2001 00:42 To: CF-Talk Subject: Does anyone see a problem with this query? I keep getting this error when I run the query. This is a SQL 2K database ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect syntax near '.'. SELECT topc.id, topc.topics, subt.id, subt.topic_id, subt.s_topics FROM topics AS topc INNER JOIN sub_topics AS subt ON topc.id = subt.id WHERE topc.id = subt.id Thanks Doug ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Does anyone see a problem with this query?
I was hoping that was not really the error... I don't see how this could be causing the error, but it seems like you are joining on the wrong id field. Did you really mean to join on the id fields of each table, or were you meaning to join on topics.id to to sub_topics.topic_id? I dunno... this is a wierd one. Maybe the problem has to do with the permissions on CF? Mike -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 11:49 AM To: CF-Talk Subject: Re: Does anyone see a problem with this query? Here is the original post ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect syntax near '.'. SELECT topc.id, topc.topics, subt.id, subt.topic_id, subt.s_topics FROM topics AS topc INNER JOIN sub_topics AS subt ON topc.id = subt.id WHERE topc.id = subt.id - Original Message - From: Michael Haggerty [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 11, 2001 8:27 AM Subject: RE: Does anyone see a problem with this query? What is the error you are getting? -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 11:39 AM To: CF-Talk Subject: Re: Does anyone see a problem with this query? Absolutely nothing else. Doug - Original Message - From: Mike Connolly [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 11, 2001 2:12 AM Subject: RE: Does anyone see a problem with this query? I don't know if I'm alone in this, but at first, second, and third glance your query syntax seems fine. Is there anything else to this query? -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: 11 December 2001 00:42 To: CF-Talk Subject: Does anyone see a problem with this query? I keep getting this error when I run the query. This is a SQL 2K database ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect syntax near '.'. SELECT topc.id, topc.topics, subt.id, subt.topic_id, subt.s_topics FROM topics AS topc INNER JOIN sub_topics AS subt ON topc.id = subt.id WHERE topc.id = subt.id Thanks Doug ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Does anyone see a problem with this query?
Can't see anything to cause a syntax error but you do have a superfluous WHERE clause as the expression is being handled by the join. Could you post the CF code that generates the SQL pls. Steve -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: 11 December 2001 16:49 To: CF-Talk Subject: Re: Does anyone see a problem with this query? Here is the original post ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect syntax near '.'. SELECT topc.id, topc.topics, subt.id, subt.topic_id, subt.s_topics FROM topics AS topc INNER JOIN sub_topics AS subt ON topc.id = subt.id WHERE topc.id = subt.id - Original Message - From: Michael Haggerty [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 11, 2001 8:27 AM Subject: RE: Does anyone see a problem with this query? What is the error you are getting? -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 11:39 AM To: CF-Talk Subject: Re: Does anyone see a problem with this query? Absolutely nothing else. Doug - Original Message - From: Mike Connolly [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 11, 2001 2:12 AM Subject: RE: Does anyone see a problem with this query? I don't know if I'm alone in this, but at first, second, and third glance your query syntax seems fine. Is there anything else to this query? -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: 11 December 2001 00:42 To: CF-Talk Subject: Does anyone see a problem with this query? I keep getting this error when I run the query. This is a SQL 2K database ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect syntax near '.'. SELECT topc.id, topc.topics, subt.id, subt.topic_id, subt.s_topics FROM topics AS topc INNER JOIN sub_topics AS subt ON topc.id = subt.id WHERE topc.id = subt.id Thanks Doug ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Does anyone see a problem with this query?
That is totally weird. Right after I got this error I refreshed and it worked. Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect syntax near '.'. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (1:1) to (1:65) in the template file C:\CARNIVOREPC\_FORUM\_QRY\QRY_GET_TOPICS.CFM. Date/Time: 12/11/01 09:08:45 Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0) Remote Address: 66.27.3.82 CFQUERY DATASOURCE=#request.site.forum_dsn# NAME=get_topics SELECT topc.id, topc.topics, sub.id, sub.topic_id, sub.s_topics FROM topics AS topc INNER JOIN sub_topics AS sub ON topc.id = sub.id WHERE topc.id = sub.id /CFQUERY Doug - Original Message - From: Dunwiddie, Bruce [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 11, 2001 8:51 AM Subject: RE: Does anyone see a problem with this query? I have a feeling that this is not the actual query that's running, you're just assuming it is. I may be wrong, but what is the actual cfquery block containing this query? don't modify it at all, just show the actual cfm query... -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 10:49 AM To: CF-Talk Subject: Re: Does anyone see a problem with this query? Here is the original post ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect syntax near '.'. SELECT topc.id, topc.topics, subt.id, subt.topic_id, subt.s_topics FROM topics AS topc INNER JOIN sub_topics AS subt ON topc.id = subt.id WHERE topc.id = subt.id - Original Message - From: Michael Haggerty [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 11, 2001 8:27 AM Subject: RE: Does anyone see a problem with this query? What is the error you are getting? -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 11:39 AM To: CF-Talk Subject: Re: Does anyone see a problem with this query? Absolutely nothing else. Doug - Original Message - From: Mike Connolly [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 11, 2001 2:12 AM Subject: RE: Does anyone see a problem with this query? I don't know if I'm alone in this, but at first, second, and third glance your query syntax seems fine. Is there anything else to this query? -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: 11 December 2001 00:42 To: CF-Talk Subject: Does anyone see a problem with this query? I keep getting this error when I run the query. This is a SQL 2K database ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect syntax near '.'. SELECT topc.id, topc.topics, subt.id, subt.topic_id, subt.s_topics FROM topics AS topc INNER JOIN sub_topics AS subt ON topc.id = subt.id WHERE topc.id = subt.id Thanks Doug ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Errors 232s Long running requests, and lots more stuff
I can't seem to find the answer to these contstant errors/warnings in the log file of cf 5... It seems all throughout the day, I'm seeing NT error 232 A long-running request returned. The unresponsive thread count is down to 0. A request exceeded the timeout. The unresponsive thread count is up to 1. !! CFTrace::logThread(1116) has no entry for thread 1116 Can anyone clue me in on where I need to start looking ? One thing, I'm concerned about is the group that wrote this application used session variables continously and didn't use any locking whatsoever.. If this a possibility of the problems ? .. Could it be timing out talking to the database server ? Thanks ! -- Visit The Most Powerful Tool on the Farm at http://www.ifarm.com Get the latest on Ag News, Market Reports, FREE email, and much more. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Templates executing twice CF bug
Hi, Not strange at all. Well, I agree that would make sense. Also I should have checked the Web server logs for my test before I sent it out. I do see the double HTTP request in the logs from this example. However, I just tried again the original place I discovered this (a much more complicated situation), and there is no double entry in the Web logs. Really. Perhaps it has something to do with browser cache. So, that was the source of my confusion previously. Perhaps the browser really is requesting the whole page twice but it's not logged by the Web server? Not sure. Web servers I tried are WebSite Pro and Apache. Also not sure why the CF version would affect the results in my case. I'll see if I can repro this situation again and cause it not to log to the Web server. I agree the explanation offered by James and Jochem makes sense, but in any case this is something to watch out for. I'll report back if I find anything new on this. Regards, -Max ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How to Sort Multidimensional Array
the problem is that a 2D (or 3D) is simply an array of arrays (or an array of arrays of arrays). so when you try to sort that, there's no sortable value to an array, so the sort will fail. christopher olive, cto, vp of web development cresco technologies, inc 410.825.0383 http://www.crescotech.com -Original Message- From: Paige Chandler [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 6:34 AM To: CF-Talk Subject: Re: How to Sort Multidimensional Array Hello Jochem, Thank you. I did find several sorts on the Developer Exchange for two dimensional arrays but none for a 3D. At least that tells me why mine wouldn't work. Have a nice day. Regards, Paige - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 11, 2001 4:24 AM Subject: Re: How to Sort Multidimensional Array Paige Chandler wrote: Happy Holidays All, Is it possible to sort a multidimensional array? If what's the syntax? The following doesn't seem to sort: CFSET SortFile = ArraySort(FileArray[1], Text, ASC) There is a customtag for sorting multidimensional arrays at the Developers Exchange. There is also a lot of code available from the CF Challenge to sort 2 queries (you can address queries as arrays) run by Jim Davis of depressedpress.com http://www.depressedpress.com/DepressedPress/Content/ColdFusion/Challeng e/Co mbineSortQuery/Index.cfm Jochem ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF and Access
hey guys, the client uses an Access application where they can, at the click of a button, create mailing labels that pull off information from their volunteers table. In fact, that whole Access app is a ufll blown Volunteer Management system. Except it's very ugly and not as robust. So i created a web version. The problem is how to handle the mailing labels part. Is it possible to export a list of info, and have them import it into that Access app and have it work with the labels? Can someone tlel me how to approach this please thanx! _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF and Access
Is the web data different fomr the data in the access DB.. In other words, do you have a aseparate DB for the web app? -Original Message- From: Mookie Bear [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 12:32 PM To: CF-Talk Subject: CF and Access hey guys, the client uses an Access application where they can, at the click of a button, create mailing labels that pull off information from their volunteers table. In fact, that whole Access app is a ufll blown Volunteer Management system. Except it's very ugly and not as robust. So i created a web version. The problem is how to handle the mailing labels part. Is it possible to export a list of info, and have them import it into that Access app and have it work with the labels? Can someone tlel me how to approach this please thanx! _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Form Submittal
I am going brain dead. I need to see if it's possible to either, Store changed fields in a database without doing a standard submit with a reload. Or, if I can modify the form action to point to two different actions depending on which submit is pressed. Marcus ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: CF Evaluate in VB?
I'm writing a program in VB and find it would be extremely useful to have a function similar to to Cold Fusion's Evaluate function. Does anyone know if such a function exists in VB? I've yet to see anything like it in the MSDN. I have seen third party tools that would handle math, but these don't appear to handle strings to the extent that CF does. Thanks for the info. ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFCONTENT performance issue
I need help solving a CFCONTENT performance issue. I am using CF4.5.1 SP1 on WinNT4.0 SP6 and IIS 4 (but se the same problem with CF 5, Win2000 and IIS5) I am trying to use CFCONTENT to display several (up to 20) GIF images on a page. This is to allow running authentication checks before permitting the user to view the images. All the mechanics are fine and the images display, but there is a *severe* performance degradation vs. direct HREFs to the files. When the CF number of simultaneous requests is set to 5 there is a 2-second delay after each 5 GIFs. When the CF number of simultaneous requests is set to 1 there is a 2-second delay after each GIF. This is noted in the IIS logs. I also have network monitor logs which capture the actual packets. If you look at the last packet before and the first packet after the 2-second delay sent by the server to the browser, the only difference is that the data has been sent bit is set. The data is already completely sent before the 2-second delay. Anyone have any hints as to what is going on, or better yet, how to fix it? Any faster alternatives to CFCONTENT for downloading a file but not revealing its location? thanks ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
QUASI OT: Opening Office Documents in a spawned browser.
This is an intranet page, so IE5.5 is the controlled environment. I'm opening an office document in a spawned window (a href= target=_Blank). The spawned window pops up, but I'm still prompted with an Open/Save dialog. Anyway I can just have it open without the prompt. I think this happens when you open it in the same browser window, but that's not an option. Any ideas would be appreciated :) Thanks, ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Form Submittal
Store changed fields in a database without doing a standard submit with a reload. Or, if I can modify the form action to point to two different actions depending on which submit is pressed. You could probably do both with some combination of the generic 'button' input type and 'onclick' event, e.g. input type=button name=submit1 id=submit1 value=Submit 1 onclick=thisForm.action='index.cfm?action=submit1'; thisForm.submit(); / input type=button name=submit2 id=submit2 value=Submit 2 onclick=thisForm.action='index.cfm?action=submit2'; thisForm.submit(); / Maybe do the first thing (submit info without current page reloading) by transferring everything to another window that closes itself - not sure about that though. hth, - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: QUASI OT: Opening Office Documents in a spawned browser.
Check to make sure the web server is sending the file using the correct MIME type. Kevin [EMAIL PROTECTED] 12/11/01 10:00AM This is an intranet page, so IE5.5 is the controlled environment. I'm opening an office document in a spawned window (a href= target=_Blank). The spawned window pops up, but I'm still prompted with an Open/Save dialog. Anyway I can just have it open without the prompt. I think this happens when you open it in the same browser window, but that's not an option. Any ideas would be appreciated :) Thanks, ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: QUASI OT: Opening Office Documents in a spawned browser.
Try it like this a href=c:\somedir\myofficedoc.doc target=_Blank OR a href=#FullPathandDocumentName# target=_Blank HTH -Original Message- From: Carlisle, Eric [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 1:00 PM To: CF-Talk Subject: QUASI OT: Opening Office Documents in a spawned browser. This is an intranet page, so IE5.5 is the controlled environment. I'm opening an office document in a spawned window (a href= target=_Blank). The spawned window pops up, but I'm still prompted with an Open/Save dialog. Anyway I can just have it open without the prompt. I think this happens when you open it in the same browser window, but that's not an option. Any ideas would be appreciated :) Thanks, ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Form Submittal
if you name the submit buttons, then form.submitbutton1 and form.submitbutton2 exist on the recieving end depending on which one was pressed, or if you're using type=image for the submit buttons, form.submitbutton1.x and form.submitbutton2.x exist on the recieving to do your switch for the action. -Original Message- From: Marcus [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 11:50 AM To: CF-Talk Subject: Form Submittal I am going brain dead. I need to see if it's possible to either, Store changed fields in a database without doing a standard submit with a reload. Or, if I can modify the form action to point to two different actions depending on which submit is pressed. Marcus ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: QUASI OT: Opening Office Documents in a spawned browser.
But doing that would cause the browser to search the client hard river for the file, wouldn't it? Regardless, thanks Kevin David :) I'll check the MIME types. EC -Original Message- From: Boardwine, David L. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 1:07 PM To: CF-Talk Subject: RE: QUASI OT: Opening Office Documents in a spawned browser. Try it like this a href=c:\somedir\myofficedoc.doc target=_Blank OR a href=#FullPathandDocumentName# target=_Blank HTH -Original Message- From: Carlisle, Eric [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 1:00 PM To: CF-Talk Subject: QUASI OT: Opening Office Documents in a spawned browser. This is an intranet page, so IE5.5 is the controlled environment. I'm opening an office document in a spawned window (a href= target=_Blank). The spawned window pops up, but I'm still prompted with an Open/Save dialog. Anyway I can just have it open without the prompt. I think this happens when you open it in the same browser window, but that's not an option. Any ideas would be appreciated :) Thanks, ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Does anyone see a problem with this query?
yeah, I see a problem alright! From: Dunwiddie, Bruce [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: Does anyone see a problem with this query? Date: Tue, 11 Dec 2001 10:51:50 -0600 I have a feeling that this is not the actual query that's running, you're just assuming it is. I may be wrong, but what is the actual cfquery block containing this query? don't modify it at all, just show the actual cfm query... -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 10:49 AM To: CF-Talk Subject: Re: Does anyone see a problem with this query? Here is the original post ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect syntax near '.'. SELECT topc.id, topc.topics, subt.id, subt.topic_id, subt.s_topics FROM topics AS topc INNER JOIN sub_topics AS subt ON topc.id = subt.id WHERE topc.id = subt.id - Original Message - From: Michael Haggerty [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 11, 2001 8:27 AM Subject: RE: Does anyone see a problem with this query? What is the error you are getting? -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 11:39 AM To: CF-Talk Subject: Re: Does anyone see a problem with this query? Absolutely nothing else. Doug - Original Message - From: Mike Connolly [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 11, 2001 2:12 AM Subject: RE: Does anyone see a problem with this query? I don't know if I'm alone in this, but at first, second, and third glance your query syntax seems fine. Is there anything else to this query? -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: 11 December 2001 00:42 To: CF-Talk Subject: Does anyone see a problem with this query? I keep getting this error when I run the query. This is a SQL 2K database ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect syntax near '.'. SELECT topc.id, topc.topics, subt.id, subt.topic_id, subt.s_topics FROM topics AS topc INNER JOIN sub_topics AS subt ON topc.id = subt.id WHERE topc.id = subt.id Thanks Doug ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SmServAz.exe SmServAuth.exe
smservaz.exe smservauth.exe What are these programs for? ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Form Submittal
if you name the submit buttons, then form.submitbutton1 and form.submitbutton2 exist on the recieving end depending on which one was pressed, or if you're using type=image for the submit buttons, form.submitbutton1.x and form.submitbutton2.x exist on the recieving to do your switch for the action. Problem is, that does a standard submit. I need the ability to press submit, and then a new window opens up with results that are different based on the possible changes he has made on the original form. If he doesn't like the results, he can close the second window, and change any field on the original form, and view his changes. Over and over until he is happy with the results. Marcus ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: QUASI OT: Opening Office Documents in a spawned browser.
I think you will find that it depends on how each browser is set up. Users are given the option of how they want to handle non-web files such as Word, Excel, etc. These options generally are: Open, Save, Always Prompt. Each browser and version is normally a little different in their implementation. In short though you will always run in to problems and the best solution I would offer is to provide some help text explaining how to always have it open. Thanks, Sam Sam Farmer - Senior Developer Certified Advanced ColdFusion 5 Developer [EMAIL PROTECTED] INTELIX - Intelligent Solutions http://www.intelixinc.com 12500 Fair Lakes Circle, Suite 150 Fairfax, VA 22033 703-815-2500 - Original Message - From: Carlisle, Eric [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 11, 2001 1:00 PM Subject: QUASI OT: Opening Office Documents in a spawned browser. This is an intranet page, so IE5.5 is the controlled environment. I'm opening an office document in a spawned window (a href= target=_Blank). The spawned window pops up, but I'm still prompted with an Open/Save dialog. Anyway I can just have it open without the prompt. I think this happens when you open it in the same browser window, but that's not an option. Any ideas would be appreciated :) Thanks, ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How to Sort Multidimensional Array
In a 3-dimensional array the first and second dimensions are arrays of pointers, not values. You'll need a loop to sort them. Check this example - this will sort each array independently: cfset ta = arrayNew(3) cfset ta[1][1][1] = a cfset ta[1][1][2] = b cfset ta[1][1][3] = c cfset ta[1][2][1] = f cfset ta[1][2][2] = h cfset ta[1][2][3] = e cfset ta[2][1][1] = q cfset ta[2][1][2] = j cfset ta[2][1][3] = k cfoutput cfloop from=1 to=#arrayLen(ta)# index=i cfloop from=1 to=#arrayLen(ta[i])# index=j cfset temp = arraySort(ta[i][j],text) !--- output the results for verification --- cfloop from=1 to=#arrayLen(ta[i][j])# index=k #ta[i][j][k]#br /cfloopbr /cfloop /cfloop /cfoutput +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecomunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Paige Chandler [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 7:56 PM To: CF-Talk Subject: How to Sort Multidimensional Array Happy Holidays All, Is it possible to sort a multidimensional array? If what's the syntax? The following doesn't seem to sort: CFSET SortFile = ArraySort(FileArray[1], Text, ASC) Thanks for you help. Regards, Paige ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SmServAz.exe SmServAuth.exe
Subject: SmServAz.exe SmServAuth.exe smservaz.exe smservauth.exe What are these programs for? They're the two services used by Advanced Security - the authentication and authorization servers. Rather than just leave it at that, it might be worth mentioning that, in Windows, you can often find out what a program does by right-clicking it in Windows Explorer, selecting Properties, then selecting the Version tab. In the case of SmServAuth.exe, that would give you SiteMinder (TM) Authentication Server. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Tag to parse incoming email???
Couldn't find anything like this in the tag gallery. We are putting together a basic help desk software. The idea is to read a (Eudora) mail box file. Extract only the basic header info, i.e., Date, From, To, Reply-to and Subject, and the body. Insert the extracted info into the corresponding MS Access DB fields. CFPOP seems to be a little short on features as it only extracts the header info. Rather than query a pop server and pre-filter, we prefer to batch off-line with mailbox files where Eudora has already pre-filtered. . Thanks, Nick [EMAIL PROTECTED] ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Evaluate in VB?
I think the reason is that in normal programming, non-web, you would use function calls as opposed to using just evaluates. I think you need to take another look at what you're trying to accomplish in a different way. -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 11:50 AM To: CF-Talk Subject: OT: CF Evaluate in VB? I'm writing a program in VB and find it would be extremely useful to have a function similar to to Cold Fusion's Evaluate function. Does anyone know if such a function exists in VB? I've yet to see anything like it in the MSDN. I have seen third party tools that would handle math, but these don't appear to handle strings to the extent that CF does. Thanks for the info. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Form Submittal
can't do it without a page refresh somewhere. you could put the actual form in a frame and just have that part submit to itself, does the action, and onload calls a window.open to some page that then displays the results. we're doing something very similar on an image generation and preview. orr, you could attempt to have some rather complex java script that onclick of the submit button, pops open a new window and in the url for that new window, send the values of each form element as url parameters and have the action of the update at the top of the page that's being popped open. -Original Message- From: Marcus [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 12:39 PM To: CF-Talk Subject: RE: Form Submittal if you name the submit buttons, then form.submitbutton1 and form.submitbutton2 exist on the recieving end depending on which one was pressed, or if you're using type=image for the submit buttons, form.submitbutton1.x and form.submitbutton2.x exist on the recieving to do your switch for the action. Problem is, that does a standard submit. I need the ability to press submit, and then a new window opens up with results that are different based on the possible changes he has made on the original form. If he doesn't like the results, he can close the second window, and change any field on the original form, and view his changes. Over and over until he is happy with the results. Marcus ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Evaluate in VB?
Understood, and I do have another method in place. But in this particular case the evaluate would have been good. It's become a matter of academic interest, but is not required for functionality (cuz I am doing it in another way). Thanks for the response though. Shawn Grover -Original Message- From: Dunwiddie, Bruce [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 12:43 PM To: CF-Talk Subject: RE: CF Evaluate in VB? I think the reason is that in normal programming, non-web, you would use function calls as opposed to using just evaluates. I think you need to take another look at what you're trying to accomplish in a different way. -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 11:50 AM To: CF-Talk Subject: OT: CF Evaluate in VB? I'm writing a program in VB and find it would be extremely useful to have a function similar to to Cold Fusion's Evaluate function. Does anyone know if such a function exists in VB? I've yet to see anything like it in the MSDN. I have seen third party tools that would handle math, but these don't appear to handle strings to the extent that CF does. Thanks for the info. ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Form Submittal
TARGET=_newpage in the FORM tag will also open a new window for you each time the form is submitted (_newpage should be understood to be any name you want for the new window), which will also let you accomplish what you describe below. The attribute may not be supported in older (pre-version 3) browsers, though. Regards, Joel Parramore -Original Message- From: Marcus [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 1:39 PM To: CF-Talk Subject: RE: Form Submittal if you name the submit buttons, then form.submitbutton1 and form.submitbutton2 exist on the recieving end depending on which one was pressed, or if you're using type=image for the submit buttons, form.submitbutton1.x and form.submitbutton2.x exist on the recieving to do your switch for the action. Problem is, that does a standard submit. I need the ability to press submit, and then a new window opens up with results that are different based on the possible changes he has made on the original form. If he doesn't like the results, he can close the second window, and change any field on the original form, and view his changes. Over and over until he is happy with the results. Marcus ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: RE: Form Submittal
In your form tag, specify the target attribute. When the user hits submit, it will open a new browser window. - Original Message - From: Dunwiddie, Bruce [EMAIL PROTECTED] Date: Tuesday, December 11, 2001 12:34 pm Subject: RE: Form Submittal can't do it without a page refresh somewhere. you could put the actual form in a frame and just have that part submit to itself, does the action, and onload calls a window.open to some page that then displays the results.we're doing something very similar on an image generation and preview. orr, you could attempt to have some rather complex java script that onclick of the submit button, pops open a new window and in the url for that new window, send the values of each form element as url parameters and have the action of the update at the top of the page that's being popped open. -Original Message- From: Marcus [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 12:39 PM To: CF-Talk Subject: RE: Form Submittal if you name the submit buttons, then form.submitbutton1 and form.submitbutton2 exist on the recieving end depending on which one was pressed, or if you're using type=image for the submit buttons, form.submitbutton1.x and form.submitbutton2.x exist on the recieving to do your switch for the action. Problem is, that does a standard submit. I need the ability to press submit, and then a new window opens up with results that are different based on the possible changes he has made on the original form. If he doesn't like the results, he can close the second window, and change any field on the original form, and view his changes. Over and over until he is happy with the results. Marcus ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF Evaluate in VB?
VB does not have an eval function. - Original Message - From: Shawn Grover [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 11, 2001 12:50 PM Subject: OT: CF Evaluate in VB? I'm writing a program in VB and find it would be extremely useful to have a function similar to to Cold Fusion's Evaluate function. Does anyone know if such a function exists in VB? I've yet to see anything like it in the MSDN. I have seen third party tools that would handle math, but these don't appear to handle strings to the extent that CF does. Thanks for the info. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Form Submittal
I think that will have to do it. I can use a variation of.. form name=foo method=post action= Target=_display Form fields... input type=submit value=Use Dallas onclick=setFormAction(this.form, 'http://mach2/submit.cfm') / input type=submit value=Use Chicago onclick=setFormAction(this.form, 'http://mach1/submit.cfm') / Thanks for all the help... Marcus TARGET=_newpage in the FORM tag will also open a new window for you each time the form is submitted (_newpage should be understood to be any name you want for the new window), which will also let you accomplish what you describe below. The attribute may not be supported in older (pre-version 3) browsers, though. ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Install CF Server single user version 5.0 over 4.5?
Should I install the CF Server single user version 5.0 over my existing version 4.5 or should I uninstall version 4.5 first? Thanks! George ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Writing to text file
hey guys, I am doing a CFFILE and writing to a NEW file (not appending). i am tyring to input information in text delimited from a query. how do I do this though? i cannot put CFOUTPUT query=whatever inside the output. help! _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Writing to text file
If you need to nest the output of a query within the CFOUTPUT tags, simply use the CFLOOP function. -Original Message- From: Mookie Bear [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 3:27 PM To: CF-Talk Subject: Writing to text file hey guys, I am doing a CFFILE and writing to a NEW file (not appending). i am tyring to input information in text delimited from a query. how do I do this though? i cannot put CFOUTPUT query=whatever inside the output. help! _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Install CF Server single user version 5.0 over 4.5?
Just install it over it, it should keep all the settings -Original Message- From: Earl, George [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 12 December 2001 9:28 a.m. To: CF-Talk Subject: Install CF Server single user version 5.0 over 4.5? Should I install the CF Server single user version 5.0 over my existing version 4.5 or should I uninstall version 4.5 first? Thanks! George ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Install CF Server single user version 5.0 over 4.5?
Should I install the CF Server single user version 5.0 over my existing version 4.5 or should I uninstall version 4.5 first? Thanks! In my relatively limited experience installing CF 5, it hasn't seemed to make much difference either way. For my own development machine, I'd save the existing registry keys for datasources, etc, then uninstall 4.5 (which should leave those keys anyway, I think) then install CF 5. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Writing to text file
why can't I do this? i mean, I need to do this!! because i have to put over 3,000 names How can I loop over a write CFFILE tag? because it would keep making new files. why can't i put it all in one single thing? I was also thinking putting all that info in one variable, but how do I specify a line break in that variable? that line break is important, because Access reads it as a new row. grr!!! output=CFOUTPUT query=hello#fname#,#lname# /CFOUTPUT From: Adkins, Randy [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: Writing to text file Date: Tue, 11 Dec 2001 15:31:00 -0500 If you need to nest the output of a query within the CFOUTPUT tags, simply use the CFLOOP function. -Original Message- From: Mookie Bear [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 3:27 PM To: CF-Talk Subject: Writing to text file hey guys, I am doing a CFFILE and writing to a NEW file (not appending). i am tyring to input information in text delimited from a query. how do I do this though? i cannot put CFOUTPUT query=whatever inside the output. help! _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: javascript or html to crash netscape or IE
I need a snippet of javascript/html/dhtml/css/whatever that will cause Netscape or IE to crash reliably so I can test something. I have certainly managed to crash them in the past but can't find the code that did it. Any ideas? Martin Herbener ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Writing to text file
This is how I did it: cfset output = /*** The spaces in the next line of code are not spaces, they're tabs ***/ cfset output = output Overnite/Next Day Request DateDealer Office Dealer Name Address1Address2Address3 CityState Postal Code Repid Reason Statements Sheets Images Comments cffile action=write file=#request.excelfilepath# output=#output# nameconflict=overwrite cfloop query=getreprints cfset output = /*** Again, not spaces, but tabs ***/ cfset output = output #yesnoformat(overnite)# #dateformat(requestdate,'mm/dd/')# #trim(dealeroffice)# #trim(dealername)# #trim(address1)##trim(address2)# #trim(address3)##trim(city)##trim(state)# #trim(postalcode)# #trim(repid)# #reason##statements# #sheets##pages# #trim(comments)# cffile action=append file=#request.excelfilepath# output=#output# /cfloop Hope that helps. Mark -Original Message- From: Mookie Bear [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 3:27 PM To: CF-Talk Subject: Writing to text file hey guys, I am doing a CFFILE and writing to a NEW file (not appending). i am tyring to input information in text delimited from a query. how do I do this though? i cannot put CFOUTPUT query=whatever inside the output. help! _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Writing to text file
You would handle the line break like this: cfoutput query=hello cfset Output = Output #fname,#lname# #chr(13)chr(10)# /cfoutput Hope that helps. Shawn Grover -Original Message- From: Mookie Bear [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 1:37 PM To: CF-Talk Subject: RE: Writing to text file why can't I do this? i mean, I need to do this!! because i have to put over 3,000 names How can I loop over a write CFFILE tag? because it would keep making new files. why can't i put it all in one single thing? I was also thinking putting all that info in one variable, but how do I specify a line break in that variable? that line break is important, because Access reads it as a new row. grr!!! output=CFOUTPUT query=hello#fname#,#lname# /CFOUTPUT From: Adkins, Randy [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: Writing to text file Date: Tue, 11 Dec 2001 15:31:00 -0500 If you need to nest the output of a query within the CFOUTPUT tags, simply use the CFLOOP function. -Original Message- From: Mookie Bear [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 3:27 PM To: CF-Talk Subject: Writing to text file hey guys, I am doing a CFFILE and writing to a NEW file (not appending). i am tyring to input information in text delimited from a query. how do I do this though? i cannot put CFOUTPUT query=whatever inside the output. help! _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Writing to text file
why can't I do this? i mean, I need to do this!! because i have to put over 3,000 names How can I loop over a write CFFILE tag? because it would keep making new files. why can't i put it all in one single thing? I was also thinking putting all that info in one variable, but how do I specify a line break in that variable? that line break is important, because Access reads it as a new row. grr!!! output=CFOUTPUT query=hello#fname#,#lname# /CFOUTPUT You can't use CFOUTPUT there, because you can't use it in any CF tags - it's only intended to output CFML expressions into HTML or other text returned directly to the browser (although you can also use it to loop over a recordset without actually generating any output, if you like. But don't freak out, Mr. Bear! You can still do what you want, by building a single variable: cfset mystr = cfset CrLf = Chr(13) Chr(10) cfoutput query=hello cfset mystr = mystr fname , lname CrLf /cfoutput cffile action=write output=#mystr# ... Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: javascript or html to crash netscape or IE
I need a snippet of javascript/html/dhtml/css/whatever that will cause Netscape or IE to crash reliably so I can test something. I have certainly managed to crash them in the past but can't find the code that did it. Any ideas? http://www.netscape.com/ usually does it for me. ;) Seriously, crash how? Throw a JS error? Lock up the application? Lock up the computer? Lock up the house, and cause your toilets to overflow and your wife's hairdryer to catch fire? Be specific, man. :) -Ron ¸_¸.·´¯) http://www.BookCrossing.com ~ Read and Release! (¯`·.¸_¸. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Writing to text file
add a line break using #chr(10)#: output=CFOUTPUT query=hello#fname#,#lname##chr(10)# /CFOUTPUT or, the really slow method: you only create a new file on the first record - so do an append if you're doing record 2+ cfoutput qurey=hello cfif currentRow eq 1 cfset action = WRITE cfelse cfset action=APPEND /cfif cffile action=#action# file=test.txt output=#fname#,#lname# addnewline=Yes /cfoutput --- Billy Cravens - Original Message - From: Mookie Bear [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 11, 2001 2:36 PM Subject: RE: Writing to text file why can't I do this? i mean, I need to do this!! because i have to put over 3,000 names How can I loop over a write CFFILE tag? because it would keep making new files. why can't i put it all in one single thing? I was also thinking putting all that info in one variable, but how do I specify a line break in that variable? that line break is important, because Access reads it as a new row. grr!!! output=CFOUTPUT query=hello#fname#,#lname# /CFOUTPUT From: Adkins, Randy [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: Writing to text file Date: Tue, 11 Dec 2001 15:31:00 -0500 If you need to nest the output of a query within the CFOUTPUT tags, simply use the CFLOOP function. -Original Message- From: Mookie Bear [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 3:27 PM To: CF-Talk Subject: Writing to text file hey guys, I am doing a CFFILE and writing to a NEW file (not appending). i am tyring to input information in text delimited from a query. how do I do this though? i cannot put CFOUTPUT query=whatever inside the output. help! _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Writing to text file
Dave recommended using a single variable: : cfset mystr = : cfset CrLf = Chr(13) Chr(10) : cfoutput query=hello : cfset mystr = mystr fname , lname CrLf : /cfoutput : cffile action=write output=#mystr# ... Actually, you could take this one step further and make it pretty transparent: CF_SaveFileContent File=filename.txt CFOUTPUT query=hello#fname#,#lname# /CFOUTPUT /CF_SaveContent Then, your CF_SaveFileContent tag is really simple: CFIF ThisTag.ExecutionMode IS End CFFILE ACTION=WRITE FILE=#Attributes.File# OUTPUT=#ThisTag.GeneratedContent# CFSET ThisTag.GeneratedContent= /CFIF You can do pretty much *anything* you want in that first set of tags. Output, formatting, logic, whatever. If you don't want to write your own custom tag (even if it is just 4 lines), and you have CF5(?), use CFSAVECONTENT. -R ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFContent
I'm using CFCONTENT to call a pdf form- It does fine on MAC IE and most pc IE and Netscape. However, on one browser a 98 machine with IE5.5 I can't get the pdf to show. Instead there is the box and the msg says Error Locating Object Handler There is no viewer available for the type of object you are trying to open. The following informantion is available about this object. Address: http://blahblah Content type: text/html Possible location of viewer: Microsoft ActiveXGallery I took the Ben Forta advice and checked the Folder Options in Tools of Windows Explorer. I went over it piece by piece comparing it to the settings of a browser that worked- I didn't see any differences. This browser has opened pdfs when I used the meta tag and the embed tag so I know that it does open pdfs...any suggestions? Thanks in advance, ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Send response to browser, but continue working on request?
Thanks, that sounds good, but I was hoping to not have to use CFSCHEDULE. Any other ideas? The scheme I used in the past to do something similar was the following. Please keep in mind this is pre-version 5 and may no longer be the best practice. 1) Update a database with the user's id and the details on the page to generate (any variables passed, etc.). Display a page explaining the user will receive an email with download instructions. 2) CFSCHEDULE the page to generate the report ON ANOTHER BOX so you won't bog down a production server with long running pages. Set the timeout on this template to serve your needs. Make sure you use CFERROR or CFCATCH to monitor the template's progress. It is a good idea to set yourself up to be notified in case of errors. 3) Use CFFILE to create the file and store the file name and path in a database for later removal. 4) Update the database to indicate the page has generated or Delete the record to remove it from the queue. 5) CFMAIL the client download instructions on successful creation of the file. Tell the user how long they will have to download the file. You may wish to have the client download the page via CFCONTENT and have some error handling set up at this stage to avoid any snafus. 6) CFSCHEDULE another page to delete old files using the information stored in step 3. No need to keep reports that have already been created. Good luck, Mike -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 11, 2001 10:17 AM To: CF-Talk Subject: Send response to browser, but continue working on request? I have a function that allows a user to create a file of available inventory. The problem is that it takes a long time and eventually the browser will timeout, but they haven't gotten their file yet... What I want to do is let the user make the request and then respond with Thank you for your request. Your file will be created and emailed to you shortly. How can I spawn off the part that will actually create the file and still respond with a finished request to the browser? Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion http://www.is300.net ___The Enthusiast's Home of the Lexus IS300 http://www.digitacamera.com __DigitA Camera Scripts and Tips http://www.linklabexchange.com _Miata Link ECU Data Exchange ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
