RE: Multiple Left Outer Joins
Hi Bud In SQL Server, it's SELECT T1.*, T2.*, T3.* FROM Table1 T1 LEFT OUTER JOIN table2 T2 ON T1.ID = T2.ID LEFT OUTER JOIN table3 T3 ON T1.ID = T3.ID LEFT OUTER JOIN table4 T4 ON T1.ID = T4.ID WHERE (whatever) Other DB's may differ, for instance, in Access, you need to do lots of weird nesting stuff with brackets, but that's how you'd do it on SQL HTH Alistair -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: 19 May 2002 21:09 To: CF-Talk Subject: Multiple Left Outer Joins Hi all. Before I wreck my brain trying to figure this out, I'll ask here. :) Is there a way to do multiple Left Outer Joins off of a single table? I know how to join table 1 to table 2, then table 2 to table 3, etc. What I'd like to do is 3 separate Outer Joins to the same Left table in a single query: SELECT T1.*,T2.* FROM table1 T1 LEFT OUTER JOIN table2 T2 ON T1.ID = T2.ID WHERE T1.ID = #val(form.ID)# SELECT T1.*,T3.* FROM table1 T1 LEFT OUTER JOIN table3 T3 ON T1.ID = T3.ID WHERE T1.ID = #val(form.ID)# SELECT T1.*,T4.* FROM table1 T1 LEFT OUTER JOIN table4 T4 ON T1.ID = T4.ID WHERE T1.ID = #val(form.ID)# TIA -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Find a string and then italicize all after to next chr32
Isn't as simple as cfoutput b#ProductFamily#/bi#ProductFunction#/i /cfoutput or have I missed the point completely? Do you possibly mean that the entry in the DB is e-terracontrol? Like Donnie said, when you do find a solution, separate them in the db and change your code. Ade -Original Message- From: William H. Bowen [mailto:[EMAIL PROTECTED]] Sent: 18 May 2002 00:17 To: CF-Talk Subject: Find a string and then italicize all after to next chr32 I know what I want to do but am not sure where (or how) to start Background: we have product names (most companies do; odd that :-). A decision was made that the product name in all our literature, web sites etc. be split thusly: ProductFamilyProductFunction The ProductFamily portion of the name is bold and the ProductFunction part of the name is italic (no bold) like so: be-terra/bicontrol/i I used the Highlight UDF on cflib.org (thanks Ray!!) to find the e-terra portion of the string and bold it, no problem. Now on all pages of the site I am building every occurence of e-terra is bold(ed) when it is found in the database and written to the browser. now, the question; what can I do in order to make the second half of the name appear italicised? I know that it will involve finding every instance of e-terra but where do I go from there? I would search for specific strings attached to e-terra, but we currently have 47 products in that product family. Any thoughts? TIA will William H. Bowen Webmaster ALSTOM's Energy Management and Markets Business [EMAIL PROTECTED] http://www.esca.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: Find a string and then italicize all after to next chr32
watch out for wordwrap: cfset formattedProduct = rereplacenocase(this, (e-terra)([[:alnum:]]*), b\1/bi\2/i, ALL) -Original Message- From: William H. Bowen [mailto:[EMAIL PROTECTED]] Sent: 18 May 2002 00:17 To: CF-Talk Subject: Find a string and then italicize all after to next chr32 I know what I want to do but am not sure where (or how) to start Background: we have product names (most companies do; odd that :-). A decision was made that the product name in all our literature, web sites etc. be split thusly: ProductFamilyProductFunction The ProductFamily portion of the name is bold and the ProductFunction part of the name is italic (no bold) like so: be-terra/bicontrol/i I used the Highlight UDF on cflib.org (thanks Ray!!) to find the e-terra portion of the string and bold it, no problem. Now on all pages of the site I am building every occurence of e-terra is bold(ed) when it is found in the database and written to the browser. now, the question; what can I do in order to make the second half of the name appear italicised? I know that it will involve finding every instance of e-terra but where do I go from there? I would search for specific strings attached to e-terra, but we currently have 47 products in that product family. Any thoughts? TIA will William H. Bowen Webmaster ALSTOM's Energy Management and Markets Business [EMAIL PROTECTED] http://www.esca.com/ __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Find a string and then italicize all after to next chr32
sorry, missed the bit about up to the next chr(32) (space) this'll work: cfset formattedProduct = rereplacenocase(this, (e-terra)([^[:space:]]*[:space:]), b\1/bi\2/i, ALL) -Original Message- From: Rich Wild Sent: 20 May 2002 11:16 To: '[EMAIL PROTECTED]' Subject: RE: Find a string and then italicize all after to next chr32 watch out for wordwrap: cfset formattedProduct = rereplacenocase(this, (e-terra)([[:alnum:]]*), b\1/bi\2/i, ALL) -Original Message- From: William H. Bowen [mailto:[EMAIL PROTECTED]] Sent: 18 May 2002 00:17 To: CF-Talk Subject: Find a string and then italicize all after to next chr32 I know what I want to do but am not sure where (or how) to start Background: we have product names (most companies do; odd that :-). A decision was made that the product name in all our literature, web sites etc. be split thusly: ProductFamilyProductFunction The ProductFamily portion of the name is bold and the ProductFunction part of the name is italic (no bold) like so: be-terra/bicontrol/i I used the Highlight UDF on cflib.org (thanks Ray!!) to find the e-terra portion of the string and bold it, no problem. Now on all pages of the site I am building every occurence of e-terra is bold(ed) when it is found in the database and written to the browser. now, the question; what can I do in order to make the second half of the name appear italicised? I know that it will involve finding every instance of e-terra but where do I go from there? I would search for specific strings attached to e-terra, but we currently have 47 products in that product family. Any thoughts? TIA will William H. Bowen Webmaster ALSTOM's Energy Management and Markets Business [EMAIL PROTECTED] http://www.esca.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
Opening a MS word document from a remote server using http
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Hi, Is it possible, and if so how can you open a MS Word document from a remote server, in its own application and not a browser window ? Stephen ** Westminster City Council switchboard: +44 20 7641 6000 ** This E-Mail may contain information which is privileged, confidential and protected from disclosure. If you are not the intended recipient of this E-mail or any part of it, please telephone Westminster City Council immediately on receipt. You should not disclose the contents to any other person or take copies. ** 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 there such a thing as NOT DISTINCT?
I want to output all records in a table where a certain field is duplicated at least once. My first instinct is to filter in the SQL - but how?! I'm using Access 2000, and the field in question is VARCHAR. DISTINCT doesn't *seem* to support being negated with NOT, and anyway, isn't it only meant for numeric fields? Will I have to run some complex CF code to rebuild the query once it's returned? Confused! Any help welcomed... If you want only the multiples, then why not try grouping? Select myField From myTable Group by myField Where count(myField)1 Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Multiple Left Outer Joins
On 5/19/02, Eric J Hoffman penned: LEFT OUTER JOIN mycarinfo on mycust.id = mycarinfo.custid JOIN mycarmodel on mycarmodel.id = mycarinfo.carmodel JOIN mycarmake on mycarmake.id = mycarinfo.carmake WHERE blah /cfquery Does that make sense? We are joining onto multiple tabels from our main one, mycarinfo, and grabbing all associated records from the other tables if I remember right already That's basically what I want to do, but the associated tables may not have records in them. That's why I need the LEFT OUTER JOIN. What you did looks basically the same as joining table 1 to table 2, table 2 to table 3, etc, but without the parentheses. I'll give it a shot. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: is there such a thing as NOT DISTINCT?
- Original Message - From: Philip Arnold - ASP [EMAIL PROTECTED] If you want only the multiples, then why not try grouping? Select myField From myTable Group by myField Where count(myField)1 I actually need each record listed, if there are duplicates in a certain field. So I think just the 'WHERE count(myField)1' is the trick I'm after! thanks, - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ 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
TopStyle 3 (was Macromedia Folks...)
I'll second that! TopStyle seems to be a real progression from HomeSite in the thoughtfulness of its design. If Nick's got the spare time, give him a team and a budget and make Macromedia Coder MX the hand-coder's dream. It has always had a market beyond CF coders, too. It looks like Nick had the spare time. TopStyle 3 is being billed as a CSS/HTML/XHTML Editor. You can download a beta here: http://www.bradsoft.com/topstyle/beta/index.asp Probably doesn't have any help for us CF coders, but interesting nonetheless! -- Owen __ 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
CF vs. PHP email handling
Does anyone know if PHP has good built-in email handling? How does it compare to CFMAIL? A client is considering having the mailing section on a CF site handled with PHP cos they've heard about problems with CFMAIL. Could anyone outline the precise nature of these problems? Their host's using CF4.0 (!!) - has CFMAIL improved in 4.5, 5, MX? Some solid advice on this - maybe some hard figures on the volumes of mail that CFMAIL/PHP can handle? - would be a great help. cheers, - 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: UDFs in a Custom Tag problem
Thanks for the insight. I never would have thought of considering the difference between parsing and executing in this case. It works correctly now. Thanks everyone for their ideas. Mike Mertsock Date: Mon, 20 May 2002 12:28:08 +1200 From: James Sleeman [EMAIL PROTECTED] Subject: Re: UDFs in a Custom Tag problem Message-ID: 0d8001c1ff95$376b8d90$680a0a0a@impc04 You have to do it as an include, the function declaration actually happens on parsing of the template you see, so when your custom tag gets hit on the end tag that parser reads the custom tag template again, and sees a declaration for isOperator - no matter that it won't be used this time around. A CFINCLUDE'd file won't be parsed (read) until the CFINCLUDE is executed, so it is an effective work around. CFIF NOT isDefined(isOperator) CFINCLUDE TEMPLATE=thisOperator.cfm /CFIF and thisOperator.cfm contains cfscript function IsOperator( value ) { blah blah blah; return something; } /cfscript - Original Message - From: heirophant mm [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, May 18, 2002 2:27 AM Subject: UDFs in a Custom Tag problem Hello developers, I'm writing a custom tag, and I've written some UDFs to clean up some of the code within the custom tag. Only the custom tag uses these UDFs - they're pretty specialized - so I thought it would be easiest to just put them right inside the template for the custom tag. Here's my general structure: cfif thistag.executionmode EQ start cfscript function IsOperator( value ) { blah blah blah; return something; } /cfscript more code /cfif cfif thistag.executionmode EQ end some output, etc. /cfif I get this error: Routines cannot be declared more than once. The routine IsOperator has been declared twice in different templates. I have found that this error occurs at the very beginning of the end ExecutionMode of the tag. I can't figure out how to stop this error. Any ideas? Thanks Mike Mertsock Alfred University Webteam Outgrown your current e-mail service? Get a 25MB Inbox, POP3 Access, No Ads and No Taglines with LYCOS MAIL PLUS. http://login.mail.lycos.com/brandPage.shtml?pageId=plus 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
keeping a loading page in the browser
Greetings, is it at all possible to keep a page in the browser displaying a loading message while CF server is compiling and returning the requested template, I've got a view ideas knocking about in my head but unawares if they will work, any ideas would be appreciated, respectfully, j __ 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: keeping a loading page in the browser
I think there are several ways to do this... Flash, Javascript, hidden frames but how long do you anticipate your results to take? Remember that showing the result could take 1sec, and showing a Please Wait message for a tik would be a tad overkill.. Neil Clark Team Macromedia http://www.macromedia.com/go/team Announcing Macromedia MX!! http://www.macromedia.com/software/trial/. -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: 20 May 2002 13:43 To: CF-Talk Subject: keeping a loading page in the browser Greetings, is it at all possible to keep a page in the browser displaying a loading message while CF server is compiling and returning the requested template, I've got a view ideas knocking about in my head but unawares if they will work, any ideas would be appreciated, respectfully, j __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SOT: COM Object Scripting Help (Was: cf_HTML2Excel Question)
I've been having mail server problems so I may have missed any suggestions. I've made no progress except for the fact that I know the command has to be called as something.Replace (, '... ) But beyond that I'm lost. Anyone have any ideas? Comet.com has some excellent examples but I can't find an example of what I'm trying to do. Thanks! Hatton Hatton Humphrey wrote: Okay, made some progress on this and now have a better understanding of what I need to do. cf_HTML2Excel connects to the Excel COM object which is great, but now I need to figure out how to translate this: Cells.Replace What:=, Replacement:=', LookAt:=xlPart, SearchOrder _ :=xlByRows, MatchCase:=False to run in the cfscript that is interacting with the COM object. I've tried a variety of things but I'm not sure how to proceed. I don't think I can save a macro since the workbook will constantly be changing. Any thoughts or ideas? Thanks! Hatton Hatton Humphrey wrote: Does anyone have any expeirence with this tag? I have it working almost to where I need it but I'm running into an odd problem. I have a field that is coming in from a SQL Server VarChar with '00' as the value in the field. It is being output to the HTML as 00 in the table but for some reason the excel file is translating it as a numeric value and saving a single 0 in the file. The problem is that it's *supposed* to be a numeric value, so now I guess the question is how to I force the tag (or more to the point, Excel) to save the numbers as characters? TIA! Hatton __ 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
Slightly OT: Change a stylsheet class via JavaScript?
How can I programmatically change a stylesheet class via JavaScript? I'd like to change the background of a text box from white to red if some form validation fails. I've seen it done before, but haven't been able to track down the code to do it. Thanks, Dave. __ 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: keeping a loading page in the browser
Oh, definately 10 to 20 seconds, a customer can manipulate reports from the query object, for instance, actual hours worked over a date range would return the hours worked for each day, average for the duration, then a driver idling report, a stopped report, a location report and so on, the result set does not conatain these values, CF would have to loop the result set and build up the profile for each report, as each report is created its put into an xml document, then at the end the xml doc is queried and an xls document is greated, pushed to the user for download containing sheets within for each report. So what I wanted to do was, have a message saying creating report one, create and append to xml doc, then switch and relay a message saying creating report 2, append to xml doc, and so on through report 5, and finally, message 6 creating spreadsheet, We are not using flash, although the frameset idea would be an idea obviously with javascript, but what i'm not sure about is how I would keep a page client side while calling the server, using javascript would I be looking when that frameset loads, mmm, muttering on here and making much sense I think, like with an img src=path/img.gif onLoad=javascript:alert('Hello world') I'll have a go at it, j -Original Message- From: Neil Clark - =TMM= [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 1:41 PM To: CF-Talk Subject: RE: keeping a loading page in the browser I think there are several ways to do this... Flash, Javascript, hidden frames but how long do you anticipate your results to take? Remember that showing the result could take 1sec, and showing a Please Wait message for a tik would be a tad overkill.. Neil Clark Team Macromedia http://www.macromedia.com/go/team Announcing Macromedia MX!! http://www.macromedia.com/software/trial/. -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: 20 May 2002 13:43 To: CF-Talk Subject: keeping a loading page in the browser Greetings, is it at all possible to keep a page in the browser displaying a loading message while CF server is compiling and returning the requested template, I've got a view ideas knocking about in my head but unawares if they will work, any ideas would be appreciated, respectfully, j __ 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: Slightly OT: Change a stylsheet class via JavaScript?
Yes, you can change a CSS style by using Javascript, I cant remember off the top of my head exactly how but it can be done by referencing the objects style (or BG) and colour. item.style.color='#4d4d4d'; and then asking it to change it on mouseover/mouseout. onMouseOver=colourChange(this,'009933'); onMouseOut=colourChange(this,'66'); where colourChange is your function for manipulation... Neil Clark Team Macromedia http://www.macromedia.com/go/team Announcing Macromedia MX!! http://www.macromedia.com/software/trial/. -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED]] Sent: 20 May 2002 14:01 To: CF-Talk Subject: Slightly OT: Change a stylsheet class via JavaScript? How can I programmatically change a stylesheet class via JavaScript? I'd like to change the background of a text box from white to red if some form validation fails. I've seen it done before, but haven't been able to track down the code to do it. Thanks, Dave. __ 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: Slightly OT: Change a stylsheet class via JavaScript?
- Original Message - From: Dave Carabetta [EMAIL PROTECTED] How can I programmatically change a stylesheet class via JavaScript? I'd like to change the background of a text box from white to red if some form validation fails. I've seen it done before, but haven't been able to track down the code to do it. The basic syntax is: [elementRef].style.[property] = [value]; So for the above example it might be: document.getElementById(textBox).style.backgroundColor = yellow; You might have to look into things deeper for cross-browser functionality - either in terms of referring to elements without getElementById() or in the actual support for accessing the style object. But this should get you going :-) Actually, just reading your post again, you ask about changing the *class*. I know you can change the declarations with a class somehow (cssRules?), but as for changing the actual class of an element, that just rings bells that say Problems! I could well be wrong, though. But I think the above should be good for your purposes. - 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: Slightly OT: Change a stylsheet class via JavaScript?
Is your form validation done in CF or JS? -Craig __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: keeping a loading page in the browser
Sounds like a job for CFFLUSH to me, Jb. -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: 20 May 2002 14:06 To: CF-Talk Subject: RE: keeping a loading page in the browser Oh, definately 10 to 20 seconds, a customer can manipulate reports from the query object, for instance, actual hours worked over a date range would return the hours worked for each day, average for the duration, then a driver idling report, a stopped report, a location report and so on, the result set does not conatain these values, CF would have to loop the result set and build up the profile for each report, as each report is created its put into an xml document, then at the end the xml doc is queried and an xls document is greated, pushed to the user for download containing sheets within for each report. So what I wanted to do was, have a message saying creating report one, create and append to xml doc, then switch and relay a message saying creating report 2, append to xml doc, and so on through report 5, and finally, message 6 creating spreadsheet, We are not using flash, although the frameset idea would be an idea obviously with javascript, but what i'm not sure about is how I would keep a page client side while calling the server, using javascript would I be looking when that frameset loads, mmm, muttering on here and making much sense I think, like with an img src=path/img.gif onLoad=javascript:alert('Hello world') I'll have a go at it, j -Original Message- From: Neil Clark - =TMM= [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 1:41 PM To: CF-Talk Subject: RE: keeping a loading page in the browser I think there are several ways to do this... Flash, Javascript, hidden frames but how long do you anticipate your results to take? Remember that showing the result could take 1sec, and showing a Please Wait message for a tik would be a tad overkill.. Neil Clark Team Macromedia http://www.macromedia.com/go/team Announcing Macromedia MX!! http://www.macromedia.com/software/trial/. -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: 20 May 2002 13:43 To: CF-Talk Subject: keeping a loading page in the browser Greetings, is it at all possible to keep a page in the browser displaying a loading message while CF server is compiling and returning the requested template, I've got a view ideas knocking about in my head but unawares if they will work, any ideas would be appreciated, respectfully, j __ 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
deadlocks in CFGLOBAL
The other day I talked to our DBA about some deadlocks and she started to look for them... And found a whole bunch of deadlocks in the CFGLOBAL table. Those are row level locks and if she didn't start looking for them, I would never take notice that those were happening. Does anyone know why I get row level deadlocks in CFGLOBAL and what are the implications of that? TIA, Claudia __ 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: Slightly OT: Change a stylsheet class via JavaScript?
document.getElementById('textBoxId').className = 'class'; Dave Carabetta wrote: How can I programmatically change a stylesheet class via JavaScript? I'd like to change the background of a text box from white to red if some form validation fails. I've seen it done before, but haven't been able to track down the code to do it. Thanks, Dave. __ 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
CFFTP list all .txt files
Hello All: Could someone please tell me how to list all the .txt files when you want to check the server your logging onto using CFFTP? Is it possible to filter or query some how? Thanks, James Blaha CFFTP CONNECTION=FTP2HOST USERNAME=anonymous PASSWORD=guest@unknown SERVER=testsvr ACTION=Open STOPONERROR=Yes CFFTP CONNECTION=FTP2HOST ACTION=GetCurrentDir STOPONERROR=Yes table border=1 tr td FTP directory listing of:nbsp;/td tdcfoutputnbsp;nbsp;#CFFTP.returnvalue#nbsp;nbsp;/cfoutput/td /tr tr tdReturn is:nbsp;/td tdcfoutputnbsp;nbsp;#CFFTP.returnvalue#nbsp;nbsp;/cfoutput/td /tr /table CFFTP CONNECTION=FTP2HOST ACTION=ListDir DIRECTORY=/ NAME=ListFiles STOPONERROR=Yes HR cfloop query=ListFiles table border=1 cfoutput tr td colspan=2 h3bFTP Directory Listing:nbsp;/b/h3 /td /tr tr td width=118BName/Bnbsp;/td td#name#nbsp;/td /tr tr td width=118BPath/Bnbsp;/td td width=213#path#nbsp;/td /tr tr td width=118BURL/Bnbsp;/td td width=213#url#nbsp;/td /tr tr td width=118BLength/Bnbsp;/td td width=213nbsp;/td /tr tr td width=118bLast modified:/b/td td width=213#length##DateFormat(LastModified)#nbsp;/td /tr tr td width=118bAttributes:/b/td td width=213#Attributes#nbsp;/td /tr tr td width=118BIsDirectory/Bnbsp;/td td width=213#isdirectory#nbsp;/td /tr /cfoutput /tablebr/CFLOOP cfftp connection=FTP2HOST action=close __ 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: Slightly OT: Change a stylsheet class via JavaScript?
Is your form validation done in CF or JS? -Craig Actually, both...But I'm looking to change the style when I do the JS validation up front. The CF validation is really just my fall-back should the user have JS disabled or something. Thanks, Dave. __ 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
cfmail error question
have I have no idea why this happened, but all of a sudden cfmail fails every time it send out an email. I'm using the smtp service that comes with IIS to send out mails. Seems that every time an email is sent it goes right into the badmail directory. The error that is sent into the badmail directory is 0xc00402ce. Also an eventid 4000 is logged in the event viewer. Just wondering if any of you have come across this problem and how to fix it. I have been on google groups and support.microsoft.com for two days and have yet to find an answer other a format and reinstall. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfmail error question
Someone on the list posted the core of this code last week - I'll pass it along in Tag format. This basically bypasses CFMAIL and dumps mail straight into the mailroot spooler. Thanks to whomever that was that posted the CFFILE code, you're my new best friend! !--- === Tag Syntax === CF_SMTP_MAIL smtp_file= smtp_mime= smtp_date= smtp_to= smtp_from= smtp_reply= smtp_subject= smtp_body= === Begin Tag === --- cfscript // UDF function cfparam(varname) { var value = ; if(arrayLen(Arguments) gt 1) value = Arguments[2]; if(not isDefined(varname)) setVariable(varname,value); return evaluate(varname); } // Set Defaults #cfparam(attributes.smtp_file,c:\inetpub\mailroot\pickup\#createuuid( )#.txt)#; #cfparam(attributes.smtp_mime,Content-type: text/plain)#; #cfparam(attributes.smtp_date,#dateformat(now(), ddd, d mmm )# #timeformat(now(), HH:mm:ss)# -0500)#; #cfparam(attributes.smtp_to,[EMAIL PROTECTED])#; #cfparam(attributes.smtp_from,[EMAIL PROTECTED])#; #cfparam(attributes.smtp_reply,)#; #cfparam(attributes.smtp_subject,SMTP Test)#; #cfparam(attributes.smtp_body,This is a test of SMTP Mail Dump)#; /cfscript cffile action=write file=#attributes.smtp_file# output=#attributes.smtp_mime# Date: #attributes.smtp_date# To: #attributes.smtp_to# From: #attributes.smtp_from# Reply-To: #attributes.smtp_reply# Subject: #attributes.smtp_subject# #attributes.smtp_body# !--- === End Tag === --- Joshua Miller Web Development :: Programming Eagle Web Development LLC www.eaglewd.com [EMAIL PROTECTED] (304) 622-5676 (Clarksburg Office) (304) 456-4942 (Home Office) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 19, 2002 6:21 PM To: CF-Talk Subject: cfmail error question have I have no idea why this happened, but all of a sudden cfmail fails every time it send out an email. I'm using the smtp service that comes with IIS to send out mails. Seems that every time an email is sent it goes right into the badmail directory. The error that is sent into the badmail directory is 0xc00402ce. Also an eventid 4000 is logged in the event viewer. Just wondering if any of you have come across this problem and how to fix it. I have been on google groups and support.microsoft.com for two days and have yet to find an answer other a format and reinstall. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF vs. PHP email handling
Have they heard or have they experienced CFMAIL problems? PHP has good mail handling depending on what you mean. On Mon, 20 May 2002, Gyrus wrote: Does anyone know if PHP has good built-in email handling? How does it compare to CFMAIL? A client is considering having the mailing section on a CF site handled with PHP cos they've heard about problems with CFMAIL. Could anyone outline the precise nature of these problems? Their host's using CF4.0 (!!) - has CFMAIL improved in 4.5, 5, MX? Some solid advice on this - maybe some hard figures on the volumes of mail that CFMAIL/PHP can handle? - would be a great help. cheers, - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfmail error question
cameron childress presented a similiar solution at cfnorth a couple of weeks ago (cameron, aren't you lurking here somewhere?) he suggested that due to the nature of the spool folder (its constantly being polled for new files) its best to write the files in batches in a different folder, and then move them to the spooler. nagrom ~ http://www.morgankelsey.com - Original Message - From: Joshua Miller [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 20, 2002 9:57 AM Subject: RE: cfmail error question Someone on the list posted the core of this code last week - I'll pass it along in Tag format. This basically bypasses CFMAIL and dumps mail straight into the mailroot spooler. Thanks to whomever that was that posted the CFFILE code, you're my new best friend! !--- === Tag Syntax === CF_SMTP_MAIL smtp_file= smtp_mime= smtp_date= smtp_to= smtp_from= smtp_reply= smtp_subject= smtp_body= === Begin Tag === --- cfscript // UDF function cfparam(varname) { var value = ; if(arrayLen(Arguments) gt 1) value = Arguments[2]; if(not isDefined(varname)) setVariable(varname,value); return evaluate(varname); } // Set Defaults #cfparam(attributes.smtp_file,c:\inetpub\mailroot\pickup\#createuuid( )#.txt)#; #cfparam(attributes.smtp_mime,Content-type: text/plain)#; #cfparam(attributes.smtp_date,#dateformat(now(), ddd, d mmm )# #timeformat(now(), HH:mm:ss)# -0500)#; #cfparam(attributes.smtp_to,[EMAIL PROTECTED])#; #cfparam(attributes.smtp_from,[EMAIL PROTECTED])#; #cfparam(attributes.smtp_reply,)#; #cfparam(attributes.smtp_subject,SMTP Test)#; #cfparam(attributes.smtp_body,This is a test of SMTP Mail Dump)#; /cfscript cffile action=write file=#attributes.smtp_file# output=#attributes.smtp_mime# Date: #attributes.smtp_date# To: #attributes.smtp_to# From: #attributes.smtp_from# Reply-To: #attributes.smtp_reply# Subject: #attributes.smtp_subject# #attributes.smtp_body# !--- === End Tag === --- Joshua Miller Web Development :: Programming Eagle Web Development LLC www.eaglewd.com [EMAIL PROTECTED] (304) 622-5676 (Clarksburg Office) (304) 456-4942 (Home Office) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 19, 2002 6:21 PM To: CF-Talk Subject: cfmail error question have I have no idea why this happened, but all of a sudden cfmail fails every time it send out an email. I'm using the smtp service that comes with IIS to send out mails. Seems that every time an email is sent it goes right into the badmail directory. The error that is sent into the badmail directory is 0xc00402ce. Also an eventid 4000 is logged in the event viewer. Just wondering if any of you have come across this problem and how to fix it. I have been on google groups and support.microsoft.com for two days and have yet to find an answer other a format and reinstall. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
LDAP and CF Resources
We recently launched an app that uses LDAP. It's a phone directory. Since its release we have had problems with CF locking up. Anyone know if LDAP is a CF resource hog? James __ 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 vs. PHP email handling
Have they heard or have they experienced CFMAIL problems? They've never had anything doing more than a few (30) mails at a time. It's just the poor reputation that CFMAIL has - they're wanting to go with something more stable (?) from the start for this site for scalability. PHP has good mail handling depending on what you mean. In this instance, good = better than CFMAIL. Better = better able to handle larger loads, more reliable and stable - the usual stuff you want from mailing functionality. - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfmail error question
forgot to mention this, but the first thing I did was go through my cf-talk archives and try the code that writes directly to the pickup directory. get the same results, immediatly I get badmail errors. I guess what I'm basically looking for is not a cf solution but a windows error solution. anyone ever tackle this problem. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: nagrom [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 10:07 AM To: CF-Talk Subject: Re: cfmail error question cameron childress presented a similiar solution at cfnorth a couple of weeks ago (cameron, aren't you lurking here somewhere?) he suggested that due to the nature of the spool folder (its constantly being polled for new files) its best to write the files in batches in a different folder, and then move them to the spooler. nagrom ~ http://www.morgankelsey.com - Original Message - From: Joshua Miller [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 20, 2002 9:57 AM Subject: RE: cfmail error question Someone on the list posted the core of this code last week - I'll pass it along in Tag format. This basically bypasses CFMAIL and dumps mail straight into the mailroot spooler. Thanks to whomever that was that posted the CFFILE code, you're my new best friend! !--- === Tag Syntax === CF_SMTP_MAIL smtp_file= smtp_mime= smtp_date= smtp_to= smtp_from= smtp_reply= smtp_subject= smtp_body= === Begin Tag === --- cfscript // UDF function cfparam(varname) { var value = ; if(arrayLen(Arguments) gt 1) value = Arguments[2]; if(not isDefined(varname)) setVariable(varname,value); return evaluate(varname); } // Set Defaults #cfparam(attributes.smtp_file,c:\inetpub\mailroot\pickup\#createuuid( )#.txt)#; #cfparam(attributes.smtp_mime,Content-type: text/plain)#; #cfparam(attributes.smtp_date,#dateformat(now(), ddd, d mmm )# #timeformat(now(), HH:mm:ss)# -0500)#; #cfparam(attributes.smtp_to,[EMAIL PROTECTED])#; #cfparam(attributes.smtp_from,[EMAIL PROTECTED])#; #cfparam(attributes.smtp_reply,)#; #cfparam(attributes.smtp_subject,SMTP Test)#; #cfparam(attributes.smtp_body,This is a test of SMTP Mail Dump)#; /cfscript cffile action=write file=#attributes.smtp_file# output=#attributes.smtp_mime# Date: #attributes.smtp_date# To: #attributes.smtp_to# From: #attributes.smtp_from# Reply-To: #attributes.smtp_reply# Subject: #attributes.smtp_subject# #attributes.smtp_body# !--- === End Tag === --- Joshua Miller Web Development :: Programming Eagle Web Development LLC www.eaglewd.com [EMAIL PROTECTED] (304) 622-5676 (Clarksburg Office) (304) 456-4942 (Home Office) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 19, 2002 6:21 PM To: CF-Talk Subject: cfmail error question have I have no idea why this happened, but all of a sudden cfmail fails every time it send out an email. I'm using the smtp service that comes with IIS to send out mails. Seems that every time an email is sent it goes right into the badmail directory. The error that is sent into the badmail directory is 0xc00402ce. Also an eventid 4000 is logged in the event viewer. Just wondering if any of you have come across this problem and how to fix it. I have been on google groups and support.microsoft.com for two days and have yet to find an answer other a format and reinstall. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
FW: cfmail error question
From: Petruzzi, Tony Sent: Sunday, May 19, 2002 6:21 PM To: CF-Talk (E-mail) Subject: cfmail error question have I have no idea why this happened, but all of a sudden cfmail fails every time it send out an email. I'm using the smtp service that comes with IIS to send out mails. Seems that every time an email is sent it goes right into the badmail directory. The error that is sent into the badmail directory is 0xc00402ce. Also an eventid 4000 is logged in the event viewer. Just wondering if any of you have come across this problem and how to fix it. I have been on google groups and support.microsoft.com for two days and have yet to find an answer other a format and reinstall. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org __ 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: LDAP and CF Resources
the query time is slower than hitting a regular db, how large are your queries? how powerful is your ldap server?, whats the network connection to it like? this things can cause a ldap query to be significantly slowedand may cause cf to lock up on rare occasions. [EMAIL PROTECTED] 05/20/02 10:10AM We recently launched an app that uses LDAP. It's a phone directory. Since its release we have had problems with CF locking up. Anyone know if LDAP is a CF resource hog? James __ 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
Cfif cfelse question
Hello All, I'm trying to develop a way to differentiate between a new record or the editing of a previous entered record using a single template. The user clicks on the link which passes the variable ID to the template for the cfif new and cfelse edit - but can only get one portion of the template to show at a time? I've also tried cfswitch and cfcase to no avail. What else should I try? Any assistance or direction will be greatly appreciated. Best regards, Ben __ 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: Cfif cfelse question
I'm not really sure of this, but a switch statement will be broken out of once a match/condition has been made.. I think you can have multiple conditions for a block though. Any chance of some code? -Original Message- From: Ben Covington [mailto:[EMAIL PROTECTED]] Sent: 20 May 2002 15:40 To: CF-Talk Subject: Cfif cfelse question Hello All, I'm trying to develop a way to differentiate between a new record or the editing of a previous entered record using a single template. The user clicks on the link which passes the variable ID to the template for the cfif new and cfelse edit - but can only get one portion of the template to show at a time? I've also tried cfswitch and cfcase to no avail. What else should I try? Any assistance or direction will be greatly appreciated. Best regards, Ben __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Cfif cfelse question
is there any other variables distinguishing between a new and an edit? if not you should try passing a type variable that does. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Ben Covington [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 10:40 AM To: CF-Talk Subject: Cfif cfelse question Hello All, I'm trying to develop a way to differentiate between a new record or the editing of a previous entered record using a single template. The user clicks on the link which passes the variable ID to the template for the cfif new and cfelse edit - but can only get one portion of the template to show at a time? I've also tried cfswitch and cfcase to no avail. What else should I try? Any assistance or direction will be greatly appreciated. Best regards, Ben __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF vs. PHP email handling
Does anyone know if PHP has good built-in email handling? How does it compare to CFMAIL? How much volume are they looking at? I'm not a PHP junkie, but I would assume there's more work involved with sending mail from PHP than CF. CFMAIL is fairly safe if used on a low-volume basis in my experience. There is a limit to the number of files that can be in the queue, and zero-byte files can stop the queue from being processed until manually removed (at least in 4.5- not sure about 5). If doing high volumes of mail, use CFFILE to write directly to the pickup directory of your SMTP server. Microsoft's SMTP service that ships with IIS is great for this if configured properly. I have heard of people doing the same thing with sendmail on linux. This technique also should also work for PHP, though I've never tried it. -Justin Scott, Lead Developer Sceiron Internet Services, Inc. http://www.sceiron.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: Multiple Left Outer Joins
You see on the join stuff...they all are being done to the table mycarinfo...So table 2,3, and 4 are all being joined on table 1. We run on SQL, and if we used LEFT OUTER JOIN on each instance, it crapped. Couldn't figure out why, but this works swimmingly and returns the info we need if there is related info in the tables. Have fun! Eric -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 6:23 AM To: CF-Talk Subject: RE: Multiple Left Outer Joins On 5/19/02, Eric J Hoffman penned: LEFT OUTER JOIN mycarinfo on mycust.id = mycarinfo.custid JOIN mycarmodel on mycarmodel.id = mycarinfo.carmodel JOIN mycarmake on mycarmake.id = mycarinfo.carmake WHERE blah /cfquery Does that make sense? We are joining onto multiple tabels from our main one, mycarinfo, and grabbing all associated records from the other tables if I remember right already That's basically what I want to do, but the associated tables may not have records in them. That's why I need the LEFT OUTER JOIN. What you did looks basically the same as joining table 1 to table 2, table 2 to table 3, etc, but without the parentheses. I'll give it a shot. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 __ 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: Cfif cfelse question
I diferentiate by looking at the id. For a new item, its blank or not defined so isnumeric(id) or isdefined(id) tells you whether your editing or adding the entry. However, I am a bit confused as to your wording can only get one portion of the template to show at a time? Does that mean you want to show them both? DRE -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 8:53 AM To: CF-Talk Subject: RE: Cfif cfelse question is there any other variables distinguishing between a new and an edit? if not you should try passing a type variable that does. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Ben Covington [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 10:40 AM To: CF-Talk Subject: Cfif cfelse question Hello All, I'm trying to develop a way to differentiate between a new record or the editing of a previous entered record using a single template. The user clicks on the link which passes the variable ID to the template for the cfif new and cfelse edit - but can only get one portion of the template to show at a time? I've also tried cfswitch and cfcase to no avail. What else should I try? Any assistance or direction will be greatly appreciated. Best regards, Ben __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
MX in distributed mode?????
From a previous post I know that CF5 could be run in distributed mode, and that this was only done to satisfy security requirements. Well that's what I need to do. But I wondered what the process might be to manage this for MX? I assume it must be a different process. Can't find anything in the docs. I also assume that when the J2EE versions come out that can sit directly on top of for example the full version of JRun or WebSphere, this will be standard? What will the general architecture model be? Anyone at Macromedia point me in the right direction? ** The opinions expressed in this E-mail are those of the individual and not necessarily the company. This E-mail and any files transmitted with it are confidential and solely for the use of the intended recipients ** __ 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
OT (SQL): Add column to query?
I know this is OT, but I've seen some SQL on this list lately, so I figured I ask: Let's say I have this query: Col1Col2Col3 1 a 10 2 b 11 3 c 12 4 d 13 5 e 14 6 f 15 But I'd like to add a column to this query later in the process, so I'd have this: Col1Col2Col3myCol 1 a 10 24 2 b 11 24 3 c 12 24 4 d 13 24 5 e 14 24 6 f 15 24 Is there a queryAppend, or something I can use to add a column to a query in MSSQL? If it makes a difference, every value in the added column will be the same. Thanks for any help. Ryan __ 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: Cfif cfelse question
I've thought of that, but there should be a way of checking the table for the record and then running the cfif cfelse code? In my frustration yesterday I deleted the code for the cfswtich cfcase, but it was something like Location_ID IS NOT Location_ID, Location_ID IS Location_ID - pretty much the same of for the cfif statement. Ben -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 10:53 AM To: CF-Talk Subject: RE: Cfif cfelse question is there any other variables distinguishing between a new and an edit? if not you should try passing a type variable that does. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Ben Covington [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 10:40 AM To: CF-Talk Subject: Cfif cfelse question Hello All, I'm trying to develop a way to differentiate between a new record or the editing of a previous entered record using a single template. The user clicks on the link which passes the variable ID to the template for the cfif new and cfelse edit - but can only get one portion of the template to show at a time? I've also tried cfswitch and cfcase to no avail. What else should I try? Any assistance or direction will be greatly appreciated. Best regards, Ben __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: LDAP and CF Resources
Queries can be based off individuals, or by letter (i.e. all beginning with A) or by department. The data contains about 1200 names, phone numbers, emails and street addresses. Not sure about answers to the other questions since I am not the one who developed the app. -Original Message- From: Michael Ross [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 10:42 AM To: CF-Talk Subject: Re: LDAP and CF Resources the query time is slower than hitting a regular db, how large are your queries? how powerful is your ldap server?, whats the network connection to it like? this things can cause a ldap query to be significantly slowedand may cause cf to lock up on rare occasions. [EMAIL PROTECTED] 05/20/02 10:10AM We recently launched an app that uses LDAP. It's a phone directory. Since its release we have had problems with CF locking up. Anyone know if LDAP is a CF resource hog? James __ 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 (SQL): Add column to query?
do a google search on alter table -Original Message- From: Ryan Pieszak [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 9:13 AM To: CF-Talk Subject: OT (SQL): Add column to query? I know this is OT, but I've seen some SQL on this list lately, so I figured I ask: Let's say I have this query: Col1Col2Col3 1 a 10 2 b 11 3 c 12 4 d 13 5 e 14 6 f 15 But I'd like to add a column to this query later in the process, so I'd have this: Col1Col2Col3myCol 1 a 10 24 2 b 11 24 3 c 12 24 4 d 13 24 5 e 14 24 6 f 15 24 Is there a queryAppend, or something I can use to add a column to a query in MSSQL? If it makes a difference, every value in the added column will be the same. Thanks for any help. Ryan __ 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 (SQL): Add column to query?
Do you want it in the table, or just in the returned query? Jerry Johnson [EMAIL PROTECTED] 05/20/02 11:12AM I know this is OT, but I've seen some SQL on this list lately, so I figured I ask: Let's say I have this query: Col1Col2Col3 1 a 10 2 b 11 3 c 12 4 d 13 5 e 14 6 f 15 But I'd like to add a column to this query later in the process, so I'd have this: Col1Col2Col3myCol 1 a 10 24 2 b 11 24 3 c 12 24 4 d 13 24 5 e 14 24 6 f 15 24 Is there a queryAppend, or something I can use to add a column to a query in MSSQL? If it makes a difference, every value in the added column will be the same. Thanks for any help. Ryan __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT (SQL): Add column to query?
ALTER TABLE table_name ADD column_name datatype Or ALTER TABLE table_name DROP COLUMN column_name -Original Message- From: Ryan Pieszak [mailto:[EMAIL PROTECTED]] Sent: 20 May 2002 16:13 To: CF-Talk Subject: OT (SQL): Add column to query? I know this is OT, but I've seen some SQL on this list lately, so I figured I ask: Let's say I have this query: Col1Col2Col3 1 a 10 2 b 11 3 c 12 4 d 13 5 e 14 6 f 15 But I'd like to add a column to this query later in the process, so I'd have this: Col1Col2Col3myCol 1 a 10 24 2 b 11 24 3 c 12 24 4 d 13 24 5 e 14 24 6 f 15 24 Is there a queryAppend, or something I can use to add a column to a query in MSSQL? If it makes a difference, every value in the added column will be the same. Thanks for any help. Ryan __ 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: Cfif cfelse question
Are you referring to form reuse? You would like to write one form lets say, if it's new it displays something's different than if it is editing an existing record? We normally will key off of 0. If ID gt 0 then you are editing else your not editing. Then at the top of the template you param id to zero. So a basic example would be a single field form like this: FORM name=myNameForm action=#self#?fuseaction=name.actionpage method=post Name: input type=text name=cName /FORM Now I want this 1 form to be for both editing and adding new names. I can have an edit page with a drop down box where the values are the record (db) id, and the text is the actual name. And I can have one entry, whose value would be 0 that said something like - Add New Record - or some such. Above the form itself you will need to either have a query or a param depending on the id that is sent in. So the whole page may look like this: CFPARAM name=attributes.id value=0 CFIF attributes.id gt 0 !--- this is an existing record and you must run the query to get the current value of the cName field --- CFQUERY name=getName datasource=#dsdata# Select cName From NameTable Where id = #form.id# /CFQUERY !--- dumps this value to attributes scope --- CFSET attributes.cName = getName.cName !--- set the button value for editing --- CFSET buttonValue=Save Changes CFELSE !--- make attributes.cName an empty string to input new values --- CFSET attributes.cName = !--- set the button value for adding a new record --- CFSET buttonValue = Add New Record /CFIF FORM name=myNameForm action=#self#?fuseaction=name.actionpage method=post Name: input type=text name=cName value=#attributes.cName#br / input type=submit value=#buttonValue# /FORM Is that the kind of thing your asking about? Also I am sure there is probably a better way to do this. I know you can get a tag called cf_reuseFormField off of www.fusebox.org. Tim Heald ACP/CCFD :) Application Development www.schoollink.net -Original Message- From: Andre Turrettini [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 10:58 AM To: CF-Talk Subject: RE: Cfif cfelse question I diferentiate by looking at the id. For a new item, its blank or not defined so isnumeric(id) or isdefined(id) tells you whether your editing or adding the entry. However, I am a bit confused as to your wording can only get one portion of the template to show at a time? Does that mean you want to show them both? DRE -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 8:53 AM To: CF-Talk Subject: RE: Cfif cfelse question is there any other variables distinguishing between a new and an edit? if not you should try passing a type variable that does. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Ben Covington [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 10:40 AM To: CF-Talk Subject: Cfif cfelse question Hello All, I'm trying to develop a way to differentiate between a new record or the editing of a previous entered record using a single template. The user clicks on the link which passes the variable ID to the template for the cfif new and cfelse edit - but can only get one portion of the template to show at a time? I've also tried cfswitch and cfcase to no avail. What else should I try? Any assistance or direction will be greatly appreciated. Best regards, Ben __ 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: Cfif cfelse question
No you are right, I don't want to see both at the same time. The template is working but not displaying the form. I have tried the IsDefinded but I did not leave it blank, and have not tried the isnumeric. I will take another look at this. Thanks, Ben -Original Message- From: Andre Turrettini [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 10:58 AM To: CF-Talk Subject: RE: Cfif cfelse question I diferentiate by looking at the id. For a new item, its blank or not defined so isnumeric(id) or isdefined(id) tells you whether your editing or adding the entry. However, I am a bit confused as to your wording can only get one portion of the template to show at a time? Does that mean you want to show them both? DRE -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 8:53 AM To: CF-Talk Subject: RE: Cfif cfelse question is there any other variables distinguishing between a new and an edit? if not you should try passing a type variable that does. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Ben Covington [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 10:40 AM To: CF-Talk Subject: Cfif cfelse question Hello All, I'm trying to develop a way to differentiate between a new record or the editing of a previous entered record using a single template. The user clicks on the link which passes the variable ID to the template for the cfif new and cfelse edit - but can only get one portion of the template to show at a time? I've also tried cfswitch and cfcase to no avail. What else should I try? Any assistance or direction will be greatly appreciated. Best regards, Ben __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT (SQL): Add column to query?
just in the returned query -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 11:31 AM To: CF-Talk Subject: Re: OT (SQL): Add column to query? Do you want it in the table, or just in the returned query? Jerry Johnson [EMAIL PROTECTED] 05/20/02 11:12AM I know this is OT, but I've seen some SQL on this list lately, so I figured I ask: Let's say I have this query: Col1Col2Col3 1 a 10 2 b 11 3 c 12 4 d 13 5 e 14 6 f 15 But I'd like to add a column to this query later in the process, so I'd have this: Col1Col2Col3myCol 1 a 10 24 2 b 11 24 3 c 12 24 4 d 13 24 5 e 14 24 6 f 15 24 Is there a queryAppend, or something I can use to add a column to a query in MSSQL? If it makes a difference, every value in the added column will be the same. Thanks for any help. Ryan __ 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: MS SQL - Exporting table structures
I have seen this in MySQL editors, but does MS SQL have an export feature that will export the table structures and such or an export that builds the CREATE TABLE syntax for a list of tables. Any help would be great! Paul Giesenhagen QuillDesign __ 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 (SQL): Add column to query?
This physically alters a table not a query - do you mean table or query Ryan? - if you mean query then just add the column name to the table. If you mean table then I try to steer clear of Alter table. What I tend to do is write an SP which creates a temp table of the old structure of your table and copy's all of the table across, then drops the table, recreates it with the new columns/restraints/permissions/index's etc... and then copies the data back across. Sounds like overkill I know but a very experienced DBA taught me to stay away from alter tables - can't remember why... -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED]] Sent: 20 May 2002 16:26 To: CF-Talk Subject: RE: OT (SQL): Add column to query? ALTER TABLE table_name ADD column_name datatype Or ALTER TABLE table_name DROP COLUMN column_name -Original Message- From: Ryan Pieszak [mailto:[EMAIL PROTECTED]] Sent: 20 May 2002 16:13 To: CF-Talk Subject: OT (SQL): Add column to query? I know this is OT, but I've seen some SQL on this list lately, so I figured I ask: Let's say I have this query: Col1Col2Col3 1 a 10 2 b 11 3 c 12 4 d 13 5 e 14 6 f 15 But I'd like to add a column to this query later in the process, so I'd have this: Col1Col2Col3myCol 1 a 10 24 2 b 11 24 3 c 12 24 4 d 13 24 5 e 14 24 6 f 15 24 Is there a queryAppend, or something I can use to add a column to a query in MSSQL? If it makes a difference, every value in the added column will be the same. Thanks for any help. Ryan __ 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 (SQL): Add column to query?
I think he doesn't want to alter the table... just the results. And it's not during the query, it's after you get the results... right? Otherwise you could query like select col1, col2, col3, '24' as myCol from mytable -Original Message- From: Andre Turrettini [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 11:12 AM To: CF-Talk Subject: RE: OT (SQL): Add column to query? do a google search on alter table -Original Message- From: Ryan Pieszak [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 9:13 AM To: CF-Talk Subject: OT (SQL): Add column to query? I know this is OT, but I've seen some SQL on this list lately, so I figured I ask: Let's say I have this query: Col1Col2Col3 1 a 10 2 b 11 3 c 12 4 d 13 5 e 14 6 f 15 But I'd like to add a column to this query later in the process, so I'd have this: Col1Col2Col3myCol 1 a 10 24 2 b 11 24 3 c 12 24 4 d 13 24 5 e 14 24 6 f 15 24 Is there a queryAppend, or something I can use to add a column to a query in MSSQL? If it makes a difference, every value in the added column will be the same. Thanks for any help. Ryan __ 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: keeping a loading page in the browser
Look for the CF_Processing tag in the DevExch http://devex.macromedia.com/developer/gallery/info.cfm?ID=CA347514-2830-11D4-AA9700508B94F380method=Full Randy Adkins [EMAIL PROTECTED] 05/20/02 09:06 AM Oh, definately 10 to 20 seconds, a customer can manipulate reports from the query object, for instance, actual hours worked over a date range would return the hours worked for each day, average for the duration, then a driver idling report, a stopped report, a location report and so on, the result set does not conatain these values, CF would have to loop the result set and build up the profile for each report, as each report is created its put into an xml document, then at the end the xml doc is queried and an xls document is greated, pushed to the user for download containing sheets within for each report. So what I wanted to do was, have a message saying creating report one, create and append to xml doc, then switch and relay a message saying creating report 2, append to xml doc, and so on through report 5, and finally, message 6 creating spreadsheet, We are not using flash, although the frameset idea would be an idea obviously with javascript, but what i'm not sure about is how I would keep a page client side while calling the server, using javascript would I be looking when that frameset loads, mmm, muttering on here and making much sense I think, like with an img src=path/img.gif onLoad=javascript:alert('Hello world') I'll have a go at it, j -Original Message- From: Neil Clark - =TMM= [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 1:41 PM To: CF-Talk Subject: RE: keeping a loading page in the browser I think there are several ways to do this... Flash, Javascript, hidden frames but how long do you anticipate your results to take? Remember that showing the result could take 1sec, and showing a Please Wait message for a tik would be a tad overkill.. Neil Clark Team Macromedia http://www.macromedia.com/go/team Announcing Macromedia MX!! http://www.macromedia.com/software/trial/. -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: 20 May 2002 13:43 To: CF-Talk Subject: keeping a loading page in the browser Greetings, is it at all possible to keep a page in the browser displaying a loading message while CF server is compiling and returning the requested template, I've got a view ideas knocking about in my head but unawares if they will work, any ideas would be appreciated, respectfully, j __ 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 (SQL): Add column to query?
Sorry, I'm not real good with SQL I assume I can treat this query as a table, but how do I know the name of it? And how can I tell is what data to put into this added column? -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 11:26 AM To: CF-Talk Subject: RE: OT (SQL): Add column to query? ALTER TABLE table_name ADD column_name datatype Or ALTER TABLE table_name DROP COLUMN column_name -Original Message- From: Ryan Pieszak [mailto:[EMAIL PROTECTED]] Sent: 20 May 2002 16:13 To: CF-Talk Subject: OT (SQL): Add column to query? I know this is OT, but I've seen some SQL on this list lately, so I figured I ask: Let's say I have this query: Col1Col2Col3 1 a 10 2 b 11 3 c 12 4 d 13 5 e 14 6 f 15 But I'd like to add a column to this query later in the process, so I'd have this: Col1Col2Col3myCol 1 a 10 24 2 b 11 24 3 c 12 24 4 d 13 24 5 e 14 24 6 f 15 24 Is there a queryAppend, or something I can use to add a column to a query in MSSQL? If it makes a difference, every value in the added column will be the same. Thanks for any help. Ryan __ 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 (SQL): Add column to query?
1 as column name -Original Message- From: Ryan Pieszak [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 11:29 AM To: CF-Talk Subject: RE: OT (SQL): Add column to query? just in the returned query -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 11:31 AM To: CF-Talk Subject: Re: OT (SQL): Add column to query? Do you want it in the table, or just in the returned query? Jerry Johnson [EMAIL PROTECTED] 05/20/02 11:12AM I know this is OT, but I've seen some SQL on this list lately, so I figured I ask: Let's say I have this query: Col1Col2Col3 1 a 10 2 b 11 3 c 12 4 d 13 5 e 14 6 f 15 But I'd like to add a column to this query later in the process, so I'd have this: Col1Col2Col3myCol 1 a 10 24 2 b 11 24 3 c 12 24 4 d 13 24 5 e 14 24 6 f 15 24 Is there a queryAppend, or something I can use to add a column to a query in MSSQL? If it makes a difference, every value in the added column will be the same. Thanks for any help. Ryan __ 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: MS SQL - Exporting table structures
yeah i think it's called generate sql scripts or something like that... enterprise manager -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 11:31 AM To: CF-Talk Subject: OT: MS SQL - Exporting table structures I have seen this in MySQL editors, but does MS SQL have an export feature that will export the table structures and such or an export that builds the CREATE TABLE syntax for a list of tables. Any help would be great! Paul Giesenhagen QuillDesign __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT (SQL): Add column to query?
this is exactly right, just the query, not the table, and after I get the results. thanks for clarifying. -Original Message- From: Hoag, Claudia (LNG) [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 11:30 AM To: CF-Talk Subject: RE: OT (SQL): Add column to query? I think he doesn't want to alter the table... just the results. And it's not during the query, it's after you get the results... right? Otherwise you could query like select col1, col2, col3, '24' as myCol from mytable -Original Message- From: Andre Turrettini [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 11:12 AM To: CF-Talk Subject: RE: OT (SQL): Add column to query? do a google search on alter table -Original Message- From: Ryan Pieszak [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 9:13 AM To: CF-Talk Subject: OT (SQL): Add column to query? I know this is OT, but I've seen some SQL on this list lately, so I figured I ask: Let's say I have this query: Col1Col2Col3 1 a 10 2 b 11 3 c 12 4 d 13 5 e 14 6 f 15 But I'd like to add a column to this query later in the process, so I'd have this: Col1Col2Col3myCol 1 a 10 24 2 b 11 24 3 c 12 24 4 d 13 24 5 e 14 24 6 f 15 24 Is there a queryAppend, or something I can use to add a column to a query in MSSQL? If it makes a difference, every value in the added column will be the same. Thanks for any help. Ryan __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF Error pages and redirects for 404 pages
Hi, My challenge of the week is to provide automated forwarding services to URL's that return a File not found 404 error. This would act as a sort of switchboard that, whenever a 404 error was encountered, a query would be run against a database for the requested URL, and if there were a new URL value for that originally requested page, the user would be redirected there without ever seeing the actual 404 page. Now, in theory, this is how it would work: * Create a database table that holds the values for old URL's and the good URL's that the old URL's should redirect to * Create a custom 404 page that executes a query of this table each time it's (the custom 404 page) executed. The logic would be something like this... - run query, querying for the bad URL value and returning the good URL value - If a value is returned, + do a cflocation to the new URL - If a value is not returned + display the 404 page So, here's the first problem I'm running into. I have the following set in my application.cfm: cfapplication name=redirect_test cferror type=request template=404.cfm Yet, 404.cfm is not displayed; the standard IIS error page is displayed. Also, it's documented that request error pages can't have any CF code in them. Am I doing something wrong? Am I missing something? Is there any way to accomplish what I need to do? Thanks Pete __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT (SQL): Add column to query?
well, you could copy the resultset to a new structure and add your fake column to the structure, and use the structure instead of the query resultset. I don't think you can simply add your fake column to the resultset, even though it is a structure. -Original Message- From: Ryan Pieszak [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 11:39 AM To: CF-Talk Subject: RE: OT (SQL): Add column to query? this is exactly right, just the query, not the table, and after I get the results. thanks for clarifying. -Original Message- From: Hoag, Claudia (LNG) [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 11:30 AM To: CF-Talk Subject: RE: OT (SQL): Add column to query? I think he doesn't want to alter the table... just the results. And it's not during the query, it's after you get the results... right? Otherwise you could query like select col1, col2, col3, '24' as myCol from mytable -Original Message- From: Andre Turrettini [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 11:12 AM To: CF-Talk Subject: RE: OT (SQL): Add column to query? do a google search on alter table -Original Message- From: Ryan Pieszak [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 9:13 AM To: CF-Talk Subject: OT (SQL): Add column to query? I know this is OT, but I've seen some SQL on this list lately, so I figured I ask: Let's say I have this query: Col1Col2Col3 1 a 10 2 b 11 3 c 12 4 d 13 5 e 14 6 f 15 But I'd like to add a column to this query later in the process, so I'd have this: Col1Col2Col3myCol 1 a 10 24 2 b 11 24 3 c 12 24 4 d 13 24 5 e 14 24 6 f 15 24 Is there a queryAppend, or something I can use to add a column to a query in MSSQL? If it makes a difference, every value in the added column will be the same. Thanks for any help. Ryan __ 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 (SQL): Add column to query?
And just to make his option set complete, he could add a column to the query AFTER it is returned to CF. cfset myColFiller=arrayNew(1) cfset temp=ArraySet(myColFiller, 1, myQuery.recordCount, '24') cfset temp=QueryAddColumn(myQuery, 'myCol', myColFiller) Again, this is not the best way. Jerry Johnson [EMAIL PROTECTED] 05/20/02 11:29AM I think he doesn't want to alter the table... just the results. And it's not during the query, it's after you get the results... right? Otherwise you could query like select col1, col2, col3, '24' as myCol from mytable -Original Message- From: Andre Turrettini [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 11:12 AM To: CF-Talk Subject: RE: OT (SQL): Add column to query? do a google search on alter table -Original Message- From: Ryan Pieszak [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 9:13 AM To: CF-Talk Subject: OT (SQL): Add column to query? I know this is OT, but I've seen some SQL on this list lately, so I figured I ask: Let's say I have this query: Col1Col2Col3 1 a 10 2 b 11 3 c 12 4 d 13 5 e 14 6 f 15 But I'd like to add a column to this query later in the process, so I'd have this: Col1Col2Col3myCol 1 a 10 24 2 b 11 24 3 c 12 24 4 d 13 24 5 e 14 24 6 f 15 24 Is there a queryAppend, or something I can use to add a column to a query in MSSQL? If it makes a difference, every value in the added column will be the same. Thanks for any help. Ryan __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Annoying DB question
Hi Bill, It Seem that Same Primary Key Value is been inserted.You can do like this.Prior Inserting You make a check if it is existing Give a message that already existing else go with insertion.This way there is no chance of Inserting on Refreshing the page also. With Regards Nagaraj.A - Original Message - From: Bill Wheatley [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 20, 2002 9:08 PM Subject: Annoying DB question I'm having an issue Error,TID=361,05/20/102,10:54:12,ODBC Error Code = 23000 (Integrity constraint violation)P [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK benefit'. Cannot insert duplicate key in object 'tblBenefit'.PP SQL = sp_newmeal Heres whats happening we have 8 rows in the db that hold meal plans when we change them we remove the old plans and insert new plans sometimes if you hit refresh enough it causes a ERROR above to be thrown. What i did was put the enter thing into a transaction with SET TRANSACTION ISOLATION LEVEL SERIALIZABLE and it still throws the error when the SQL notes say it shouldnt happen like that any ideas? thanks Bill Wheatley Senior Database Developer Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 __ 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: Annoying DB question
The error you are getting suggests that your PK value is not unique for the row that you are inserting into tblBenefit. Are you using IDENTITY on the PK for that table, or are you inserting the value from the SP? -- Scott Van Vliet Sempra Energy 555 W. 5th St., 21st Floor Los Angeles, CA 90013 Tel 213.244.5205 Email [EMAIL PROTECTED] Hello Stupid, and welcome to your crappy computer. - Strong Bad, HomestarRunner.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 8:38 AM To: CF-Talk Subject: Annoying DB question I'm having an issue Error,TID=361,05/20/102,10:54:12,ODBC Error Code = 23000 (Integrity constraint violation)P [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK benefit'. Cannot insert duplicate key in object 'tblBenefit'.PP SQL = sp_newmeal Heres whats happening we have 8 rows in the db that hold meal plans when we change them we remove the old plans and insert new plans sometimes if you hit refresh enough it causes a ERROR above to be thrown. What i did was put the enter thing into a transaction with SET TRANSACTION ISOLATION LEVEL SERIALIZABLE and it still throws the error when the SQL notes say it shouldnt happen like that any ideas? thanks Bill Wheatley Senior Database Developer Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 __ 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 (SQL): Add column to query?
QueryAddColumn(query, column-name, array-name) Check the CF Docs :) -Original Message- From: Ryan Pieszak [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 11:39 AM To: CF-Talk Subject: RE: OT (SQL): Add column to query? this is exactly right, just the query, not the table, and after I get the results. thanks for clarifying. -Original Message- From: Hoag, Claudia (LNG) [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 11:30 AM To: CF-Talk Subject: RE: OT (SQL): Add column to query? I think he doesn't want to alter the table... just the results. And it's not during the query, it's after you get the results... right? Otherwise you could query like select col1, col2, col3, '24' as myCol from mytable -Original Message- From: Andre Turrettini [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 11:12 AM To: CF-Talk Subject: RE: OT (SQL): Add column to query? do a google search on alter table -Original Message- From: Ryan Pieszak [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 9:13 AM To: CF-Talk Subject: OT (SQL): Add column to query? I know this is OT, but I've seen some SQL on this list lately, so I figured I ask: Let's say I have this query: Col1Col2Col3 1 a 10 2 b 11 3 c 12 4 d 13 5 e 14 6 f 15 But I'd like to add a column to this query later in the process, so I'd have this: Col1Col2Col3myCol 1 a 10 24 2 b 11 24 3 c 12 24 4 d 13 24 5 e 14 24 6 f 15 24 Is there a queryAppend, or something I can use to add a column to a query in MSSQL? If it makes a difference, every value in the added column will be the same. Thanks for any help. Ryan __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Cfif cfelse question
Tim, Thanks for the reply, and thanks for the great example! I want to direct the user to different forms, the new form has dropdowns and the edit form does not. Is there a way to incorporate the different forms into the cfif statement? Best regards, Ben -Original Message- From: Timothy Heald [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 11:28 AM To: CF-Talk Subject: RE: Cfif cfelse question Are you referring to form reuse? You would like to write one form lets say, if it's new it displays something's different than if it is editing an existing record? We normally will key off of 0. If ID gt 0 then you are editing else your not editing. Then at the top of the template you param id to zero. So a basic example would be a single field form like this: FORM name=myNameForm action=#self#?fuseaction=name.actionpage method=post Name: input type=text name=cName /FORM Now I want this 1 form to be for both editing and adding new names. I can have an edit page with a drop down box where the values are the record (db) id, and the text is the actual name. And I can have one entry, whose value would be 0 that said something like - Add New Record - or some such. Above the form itself you will need to either have a query or a param depending on the id that is sent in. So the whole page may look like this: CFPARAM name=attributes.id value=0 CFIF attributes.id gt 0 !--- this is an existing record and you must run the query to get the current value of the cName field --- CFQUERY name=getName datasource=#dsdata# Select cName From NameTable Where id = #form.id# /CFQUERY !--- dumps this value to attributes scope --- CFSET attributes.cName = getName.cName !--- set the button value for editing --- CFSET buttonValue=Save Changes CFELSE !--- make attributes.cName an empty string to input new values --- CFSET attributes.cName = !--- set the button value for adding a new record --- CFSET buttonValue = Add New Record /CFIF FORM name=myNameForm action=#self#?fuseaction=name.actionpage method=post Name: input type=text name=cName value=#attributes.cName#br / input type=submit value=#buttonValue# /FORM Is that the kind of thing your asking about? Also I am sure there is probably a better way to do this. I know you can get a tag called cf_reuseFormField off of www.fusebox.org. Tim Heald ACP/CCFD :) Application Development www.schoollink.net -Original Message- From: Andre Turrettini [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 10:58 AM To: CF-Talk Subject: RE: Cfif cfelse question I diferentiate by looking at the id. For a new item, its blank or not defined so isnumeric(id) or isdefined(id) tells you whether your editing or adding the entry. However, I am a bit confused as to your wording can only get one portion of the template to show at a time? Does that mean you want to show them both? DRE -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 8:53 AM To: CF-Talk Subject: RE: Cfif cfelse question is there any other variables distinguishing between a new and an edit? if not you should try passing a type variable that does. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Ben Covington [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 10:40 AM To: CF-Talk Subject: Cfif cfelse question Hello All, I'm trying to develop a way to differentiate between a new record or the editing of a previous entered record using a single template. The user clicks on the link which passes the variable ID to the template for the cfif new and cfelse edit - but can only get one portion of the template to show at a time? I've also tried cfswitch and cfcase to no avail. What else should I try? Any assistance or direction will be greatly appreciated. Best regards, Ben __ 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 (SQL): Add column to query?
How much of a performance hit is this? It's probably quicker doing it is sql, right? The piece of code I'm working on isn't going to be used regularly, so I could see this cf snippet being a good option. I'll implement this and see if it truly affects performance. Thanks, everyone, for the help. A GREAT response on this list. -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 11:52 AM To: CF-Talk Subject: RE: OT (SQL): Add column to query? And just to make his option set complete, he could add a column to the query AFTER it is returned to CF. cfset myColFiller=arrayNew(1) cfset temp=ArraySet(myColFiller, 1, myQuery.recordCount, '24') cfset temp=QueryAddColumn(myQuery, 'myCol', myColFiller) Again, this is not the best way. Jerry Johnson [EMAIL PROTECTED] 05/20/02 11:29AM I think he doesn't want to alter the table... just the results. And it's not during the query, it's after you get the results... right? Otherwise you could query like select col1, col2, col3, '24' as myCol from mytable -Original Message- From: Andre Turrettini [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 11:12 AM To: CF-Talk Subject: RE: OT (SQL): Add column to query? do a google search on alter table -Original Message- From: Ryan Pieszak [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 9:13 AM To: CF-Talk Subject: OT (SQL): Add column to query? I know this is OT, but I've seen some SQL on this list lately, so I figured I ask: Let's say I have this query: Col1Col2Col3 1 a 10 2 b 11 3 c 12 4 d 13 5 e 14 6 f 15 But I'd like to add a column to this query later in the process, so I'd have this: Col1Col2Col3myCol 1 a 10 24 2 b 11 24 3 c 12 24 4 d 13 24 5 e 14 24 6 f 15 24 Is there a queryAppend, or something I can use to add a column to a query in MSSQL? If it makes a difference, every value in the added column will be the same. Thanks for any help. Ryan __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT (SQL): Add column to query?
I should explain my process a little better: I'm calling a stored procedure from CF. This first SP calls a second SP which does the query. This query is then returned back to CF (through the initial SP?) with the CFPROCRESULT. I want to somehow intercept this returning query in the first SP before it gets back to the CF page and add this column. Does that make it any clearer? Thanks. -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 11:31 AM To: CF-Talk Subject: RE: OT (SQL): Add column to query? This physically alters a table not a query - do you mean table or query Ryan? - if you mean query then just add the column name to the table. If you mean table then I try to steer clear of Alter table. What I tend to do is write an SP which creates a temp table of the old structure of your table and copy's all of the table across, then drops the table, recreates it with the new columns/restraints/permissions/index's etc... and then copies the data back across. Sounds like overkill I know but a very experienced DBA taught me to stay away from alter tables - can't remember why... -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED]] Sent: 20 May 2002 16:26 To: CF-Talk Subject: RE: OT (SQL): Add column to query? ALTER TABLE table_name ADD column_name datatype Or ALTER TABLE table_name DROP COLUMN column_name -Original Message- From: Ryan Pieszak [mailto:[EMAIL PROTECTED]] Sent: 20 May 2002 16:13 To: CF-Talk Subject: OT (SQL): Add column to query? I know this is OT, but I've seen some SQL on this list lately, so I figured I ask: Let's say I have this query: Col1Col2Col3 1 a 10 2 b 11 3 c 12 4 d 13 5 e 14 6 f 15 But I'd like to add a column to this query later in the process, so I'd have this: Col1Col2Col3myCol 1 a 10 24 2 b 11 24 3 c 12 24 4 d 13 24 5 e 14 24 6 f 15 24 Is there a queryAppend, or something I can use to add a column to a query in MSSQL? If it makes a difference, every value in the added column will be the same. Thanks for any help. Ryan __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Annoying DB question
I'm having an issue Error,TID=361,05/20/102,10:54:12,ODBC Error Code = 23000 (Integrity constraint violation)P [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK benefit'. Cannot insert duplicate key in object 'tblBenefit'.PP SQL = sp_newmeal Heres whats happening we have 8 rows in the db that hold meal plans when we change them we remove the old plans and insert new plans sometimes if you hit refresh enough it causes a ERROR above to be thrown. What i did was put the enter thing into a transaction with SET TRANSACTION ISOLATION LEVEL SERIALIZABLE and it still throws the error when the SQL notes say it shouldnt happen like that any ideas? thanks Bill Wheatley Senior Database Developer Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cf and flash: line breaks
Hi everyone, Might be an easy problem for everyone else but having some problems due to not knowing Flash well. I'm sending a variable into a Flash movie. The variable is a ordered record set. Problem is after each field I need to put in a line break. cfsetting ENABLECFOUTPUTONLY=yes cfset variables.escape = \r cfquery name=listNotes datasource=#request.dsn# SELECT * FROM messages ORDER BY dateTimeStamp DESC /cfquery cfset variables.formatedMessage = cfcontent type=application/x-www-urlformencoded / cfloop query=listNotes cfset variables.formatedMessage = variables.formatedmessage dateformat(listNotes.dateTimeStamp, MM.DD.YY) variables.escape listNotes.message variables.escape /cfloop cfoutput cfMessage=#URLEncodedFormat(variables.formatedMessage)# /cfoutput The following code won't resolve the /r for a line break. I used \r with no sucess either. Any idea how to handle this? __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF vs. PHP email handling
You assume wrong, my man. PHP is super-easy to use for mail. Connects right up to SMTP, no problem. http://www.php.net/manual/en/function.mail.php Works exactly how one would expect. -- jon - jon roig senior manager, online production epilepsy foundation phone: 215.850.0710 site: http://www.epilepsyfoundation.org email: [EMAIL PROTECTED] -Original Message- From: Justin Scott [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 11:07 AM To: CF-Talk Subject: Re: CF vs. PHP email handling Does anyone know if PHP has good built-in email handling? How does it compare to CFMAIL? How much volume are they looking at? I'm not a PHP junkie, but I would assume there's more work involved with sending mail from PHP than CF. CFMAIL is fairly safe if used on a low-volume basis in my experience. There is a limit to the number of files that can be in the queue, and zero-byte files can stop the queue from being processed until manually removed (at least in 4.5- not sure about 5). If doing high volumes of mail, use CFFILE to write directly to the pickup directory of your SMTP server. Microsoft's SMTP service that ships with IIS is great for this if configured properly. I have heard of people doing the same thing with sendmail on linux. This technique also should also work for PHP, though I've never tried it. -Justin Scott, Lead Developer Sceiron Internet Services, Inc. http://www.sceiron.com __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
deadlocks in CFGLOBAL
Does anyone know why I get row level deadlocks in CFGLOBAL and what are the implications of that? The other day I talked to our DBA about some deadlocks (not related to CFGLOBAL) and she started to look for them... And found a whole bunch of deadlocks in the CFGLOBAL table. Those are row level locks and if she didn't start looking for them, I would never take notice that those were happening. I wonder if that has anything to do with users complaining that their client variables are getting mixed with other users' client variables. I can't see how that would happen, considering that the client variables rely on a cookie set for an individual browser... Any ideas? TIA, Claudia __ 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 flash: line breaks
Thanks for the link. DLing the .fla right now. I'm loading it up into a movie and outputting it. We had originally passed it to the Flash movie as separate variables with the row number as the part of the variable name. Unfortunately the part of the movie we are outputting it is a self-contained box with it's own scroll bar. For the scroll bar to work with the no problems we are just treating it as one object. If you wish to see it go to www.recursivedesign.com. It is the left hand box. At 09:08 AM 5/20/2002 -0700, you wrote: What are you loading this text into? (ie. A text field, etc.) If you are loading the text into a text field, you can make that field accept limited HTML tags, and just use br. Otherwise, you can try loading in your vars using XML instead of loadVars(). Check out LoadXML.as by Phil Scott. It makes working with Flash/XML (and CF) fairly easy and quick: http://www.flashkit.com/movies/Scripting/XML/XML_to_O-Phil_Sco-4634/index.sh tml Enjoy! -- Scott Van Vliet Sempra Energy 555 W. 5th St., 21st Floor Los Angeles, CA 90013 Tel 213.244.5205 Email [EMAIL PROTECTED] Hello Stupid, and welcome to your crappy computer. - Strong Bad, HomestarRunner.com -Original Message- From: Won Lee [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 8:56 AM To: CF-Talk Subject: cf and flash: line breaks Hi everyone, Might be an easy problem for everyone else but having some problems due to not knowing Flash well. I'm sending a variable into a Flash movie. The variable is a ordered record set. Problem is after each field I need to put in a line break. cfsetting ENABLECFOUTPUTONLY=yes cfset variables.escape = \r cfquery name=listNotes datasource=#request.dsn# SELECT * FROM messages ORDER BY dateTimeStamp DESC /cfquery cfset variables.formatedMessage = cfcontent type=application/x-www-urlformencoded / cfloop query=listNotes cfset variables.formatedMessage = variables.formatedmessage dateformat(listNotes.dateTimeStamp, MM.DD.YY) variables.escape listNotes.message variables.escape /cfloop cfoutput cfMessage=#URLEncodedFormat(variables.formatedMessage)# /cfoutput The following code won't resolve the /r for a line break. I used \r with no sucess either. Any idea how to handle this? __ 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 vs. PHP email handling
- Original Message - From: jon [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 20, 2002 4:58 PM Subject: RE: CF vs. PHP email handling You assume wrong, my man. PHP is super-easy to use for mail. Connects right up to SMTP, no problem. http://www.php.net/manual/en/function.mail.php - My original post was about trying to sound out people's opinions of the reliability, stability, scalability, etc. of CF's mail handling as opposed to PHP's. Maybe referring to CF's mailing handling by saying CFMAIL was misleading! CFMAIL the tag - like, from what I can see, PHP's mail() - is incredibly straightforward to use. I'm just interested in people's experiences of the CF mailing handing vs. PHP mail handling, when volumes increase. I'm aware that some people use things like inFusion Mail Server in conjunction with CF for when CF's own mail handling can't cut it anymore. I'm curious as to what the conditions are where CF can't cut it, and how does PHP fare in comparison? Or is this an unfair comparison? I'm not fully aware of the mechanics of how CF/PHP/whatever deals with mail, interfaces with SMTP servers, etc., maybe I'm asking the wrong questions? cheers, - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: MS SQL - Exporting table structures
Either the generate scripts function or my experience is very limited. The scripts contain object ID references that seems to be specific to the SQL Server that generates the scripts. Additionally, don't expect the scripts to work on other RDBMs, such as MySQL or Oracle. It might be useful just as a basic template and then delete the unnecessary parts. Personally, I believe the best option is to purchase PowerTools by Sybase. Sybase allows developers to create a system for most major DB systems. If you need the option to be able to create the table from a shell /command prompt, or can't afford Sybase I suggest a basic ANSI SQL script. At 05:06 PM 5/20/2002 +0100, you wrote: Yup - in Enterprise Manager, right-click on the object you want and select Generate Scripts -Original Message- From: Ken Beard [mailto:[EMAIL PROTECTED]] Sent: 20 May 2002 16:41 To: CF-Talk Subject: RE: MS SQL - Exporting table structures yeah i think it's called generate sql scripts or something like that... enterprise manager -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 11:31 AM To: CF-Talk Subject: OT: MS SQL - Exporting table structures I have seen this in MySQL editors, but does MS SQL have an export feature that will export the table structures and such or an export that builds the CREATE TABLE syntax for a list of tables. Any help would be great! Paul Giesenhagen QuillDesign __ 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 vs. PHP email handling
You assume wrong, my man. PHP is super-easy to use for mail. Connects right up to SMTP, no problem. http://www.php.net/manual/en/function.mail.php Works exactly how one would expect. Ah, very nice. I stand corrected. My experiences with PHP have not been very successful, so I tend to think everything is harder in PHP than in CF. I never had a NEED to build anything in PHP (CF always does what I need, hehe), so I never got that far into it. That mail() function is pretty nice though. -Justin Scott, Lead Developer Sceiron Internet Services, Inc. http://www.sceiron.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
Re: deadlocks in CFGLOBAL
Client variables use a cookie to look up the client value from the database, so it is possible and I imagine cfglobal table gets a lot of Update or Select/Insert (I'm not sure how CF handles updating that table) queries under load. You might want to go into the CF admin and just disable global client variable updates, in the client variable section if you dont use the stats CF keeps about last visit's and hitcounts. Disabling the global stats is SOP here. You will probably notice an overall performance boost as well... jon - Original Message - From: Hoag, Claudia (LNG) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 20, 2002 12:02 PM Subject: deadlocks in CFGLOBAL Does anyone know why I get row level deadlocks in CFGLOBAL and what are the implications of that? The other day I talked to our DBA about some deadlocks (not related to CFGLOBAL) and she started to look for them... And found a whole bunch of deadlocks in the CFGLOBAL table. Those are row level locks and if she didn't start looking for them, I would never take notice that those were happening. I wonder if that has anything to do with users complaining that their client variables are getting mixed with other users' client variables. I can't see how that would happen, considering that the client variables rely on a cookie set for an individual browser... Any ideas? TIA, Claudia __ 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 Error pages and redirects for 404 pages
Can you put in a site-wide error handler in CF admin? If so that would let you code in pretty much anything you want. I just reroute to the current domain's index.cfm, but there's no reason you couldn't do something more complex/useful. --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com -Original Message- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 8:43 AM To: CF-Talk Subject: CF Error pages and redirects for 404 pages Hi, My challenge of the week is to provide automated forwarding services to URL's that return a File not found 404 error. This would act as a sort of switchboard that, whenever a 404 error was encountered, a query would be run against a database for the requested URL, and if there were a new URL value for that originally requested page, the user would be redirected there without ever seeing the actual 404 page. Now, in theory, this is how it would work: * Create a database table that holds the values for old URL's and the good URL's that the old URL's should redirect to * Create a custom 404 page that executes a query of this table each time it's (the custom 404 page) executed. The logic would be something like this... - run query, querying for the bad URL value and returning the good URL value - If a value is returned, + do a cflocation to the new URL - If a value is not returned + display the 404 page So, here's the first problem I'm running into. I have the following set in my application.cfm: cfapplication name=redirect_test cferror type=request template=404.cfm Yet, 404.cfm is not displayed; the standard IIS error page is displayed. Also, it's documented that request error pages can't have any CF code in them. Am I doing something wrong? Am I missing something? Is there any way to accomplish what I need to do? Thanks Pete __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF vs. PHP email handling
I, for instance, have a list of 17,000 people in a database who need to receive an email every week or so. There are two main issues for me, anyway: 1) CF does not run in the command line, so everytime I invoke it, I have to go to a URL to send the mail. Even with the page timeout set to like 30 minutes, this is a somewhat dubious experience. PHP, on the other hand, can run right from the command line for an unlimited amount of time. 2) CFMAIL cannot be run from within a query -- it must have a query attached to it. Why the heck is that? Drives me crazy, as there are things in every email that I want to change and replace. I should have the choice, at the minimum, of doing it any way I choose. All in all, there's nothing spectacular about PHP's handling of mail. It just works. The only real downside is that if you're sending HTML mail, you have to take a few seconds to set up the MIME types yourself. -- jon - jon roig senior manager, online production epilepsy foundation phone: 215.850.0710 site: http://www.epilepsyfoundation.org email: [EMAIL PROTECTED] -Original Message- From: Gyrus [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 12:25 PM To: CF-Talk Subject: Re: CF vs. PHP email handling - Original Message - From: jon [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 20, 2002 4:58 PM Subject: RE: CF vs. PHP email handling You assume wrong, my man. PHP is super-easy to use for mail. Connects right up to SMTP, no problem. http://www.php.net/manual/en/function.mail.php - My original post was about trying to sound out people's opinions of the reliability, stability, scalability, etc. of CF's mail handling as opposed to PHP's. Maybe referring to CF's mailing handling by saying CFMAIL was misleading! CFMAIL the tag - like, from what I can see, PHP's mail() - is incredibly straightforward to use. I'm just interested in people's experiences of the CF mailing handing vs. PHP mail handling, when volumes increase. I'm aware that some people use things like inFusion Mail Server in conjunction with CF for when CF's own mail handling can't cut it anymore. I'm curious as to what the conditions are where CF can't cut it, and how does PHP fare in comparison? Or is this an unfair comparison? I'm not fully aware of the mechanics of how CF/PHP/whatever deals with mail, interfaces with SMTP servers, etc., maybe I'm asking the wrong questions? cheers, - 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: deadlocks in CFGLOBAL
Thanks, I didn't realize that's all it was storing in CGLOBAL :) -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 12:38 PM To: CF-Talk Subject: Re: deadlocks in CFGLOBAL Client variables use a cookie to look up the client value from the database, so it is possible and I imagine cfglobal table gets a lot of Update or Select/Insert (I'm not sure how CF handles updating that table) queries under load. You might want to go into the CF admin and just disable global client variable updates, in the client variable section if you dont use the stats CF keeps about last visit's and hitcounts. Disabling the global stats is SOP here. You will probably notice an overall performance boost as well... jon - Original Message - From: Hoag, Claudia (LNG) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 20, 2002 12:02 PM Subject: deadlocks in CFGLOBAL Does anyone know why I get row level deadlocks in CFGLOBAL and what are the implications of that? The other day I talked to our DBA about some deadlocks (not related to CFGLOBAL) and she started to look for them... And found a whole bunch of deadlocks in the CFGLOBAL table. Those are row level locks and if she didn't start looking for them, I would never take notice that those were happening. I wonder if that has anything to do with users complaining that their client variables are getting mixed with other users' client variables. I can't see how that would happen, considering that the client variables rely on a cookie set for an individual browser... Any ideas? TIA, Claudia __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF vs. PHP email handling
1) CF does not run in the command line, so everytime I invoke it, I have to go to a URL to send the mail. Even with the page timeout set to like 30 minutes, this is a somewhat dubious experience. PHP, on the other hand, can run right from the command line for an unlimited amount of time. C:\CFUSION\BIN\CFML.EXE path to cfm I'm not sure about this in MX though. It would be cool if I could just locate the compiled class file and do a java cftemplate... 2) CFMAIL cannot be run from within a query -- it must have a query attached to it. Why the heck is that? Drives me crazy, as there are things in every email that I want to change and replace. I should have the choice, at the minimum, of doing it any way I choose. You can loop over a cfmail just fine... CF MX's cfmail is based on Sun's JavaMail. Hard to get much more powerful than that. http://java.sun.com/products/javamail/ jon __ 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: Annoying DB question
Actually I have to to CHECK if its there and if its there to UPDATE and if its not their to INSERT but its throwing the damn error i guess the SERIALIZE ISOLATION level doesn not do what it says it says its supposed to keep those rows locked until the transaction is completed Bill Wheatley Senior Database Developer Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 - Original Message - From: nagraj [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 20, 2002 12:04 PM Subject: Re: Annoying DB question Hi Bill, It Seem that Same Primary Key Value is been inserted.You can do like this.Prior Inserting You make a check if it is existing Give a message that already existing else go with insertion.This way there is no chance of Inserting on Refreshing the page also. With Regards Nagaraj.A - Original Message - From: Bill Wheatley [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 20, 2002 9:08 PM Subject: Annoying DB question I'm having an issue Error,TID=361,05/20/102,10:54:12,ODBC Error Code = 23000 (Integrity constraint violation)P [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK benefit'. Cannot insert duplicate key in object 'tblBenefit'.PP SQL = sp_newmeal Heres whats happening we have 8 rows in the db that hold meal plans when we change them we remove the old plans and insert new plans sometimes if you hit refresh enough it causes a ERROR above to be thrown. What i did was put the enter thing into a transaction with SET TRANSACTION ISOLATION LEVEL SERIALIZABLE and it still throws the error when the SQL notes say it shouldnt happen like that any ideas? thanks Bill Wheatley Senior Database Developer Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Annoying DB question
Well the value is not unique becuase the key is on MEALID and MEALTIME which is like 1 = monday time = 1(breakfast) i just was reading about that serialize isoloation level and thought that should do the trick Bill Wheatley Senior Database Developer Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 - Original Message - From: Van Vliet, Scott [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 20, 2002 11:50 AM Subject: RE: Annoying DB question The error you are getting suggests that your PK value is not unique for the row that you are inserting into tblBenefit. Are you using IDENTITY on the PK for that table, or are you inserting the value from the SP? -- Scott Van Vliet Sempra Energy 555 W. 5th St., 21st Floor Los Angeles, CA 90013 Tel 213.244.5205 Email [EMAIL PROTECTED] Hello Stupid, and welcome to your crappy computer. - Strong Bad, HomestarRunner.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 8:38 AM To: CF-Talk Subject: Annoying DB question I'm having an issue Error,TID=361,05/20/102,10:54:12,ODBC Error Code = 23000 (Integrity constraint violation)P [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK benefit'. Cannot insert duplicate key in object 'tblBenefit'.PP SQL = sp_newmeal Heres whats happening we have 8 rows in the db that hold meal plans when we change them we remove the old plans and insert new plans sometimes if you hit refresh enough it causes a ERROR above to be thrown. What i did was put the enter thing into a transaction with SET TRANSACTION ISOLATION LEVEL SERIALIZABLE and it still throws the error when the SQL notes say it shouldnt happen like that any ideas? thanks Bill Wheatley Senior Database Developer Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 __ 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: deadlocks in CFGLOBAL
Strange. Deadlocks most often happen when you have code that updates one row in the DB based on info from another row. Example: UPDATE cellGlobal SET myVar = (SELECT myVar from cellGlobal WHERE foo = 1) WHERE foo = 2; This code is dangerous because it could cause deadlocks... what if it's updating row 1 based on row 2 while a concurrent thread is updating row 2 based on row 1? deadlock Search your code for any client variable updates that might cause the above situation to happen. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication 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: Hoag, Claudia (LNG) [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 9:02 AM To: CF-Talk Subject: deadlocks in CFGLOBAL Does anyone know why I get row level deadlocks in CFGLOBAL and what are the implications of that? The other day I talked to our DBA about some deadlocks (not related to CFGLOBAL) and she started to look for them... And found a whole bunch of deadlocks in the CFGLOBAL table. Those are row level locks and if she didn't start looking for them, I would never take notice that those were happening. I wonder if that has anything to do with users complaining that their client variables are getting mixed with other users' client variables. I can't see how that would happen, considering that the client variables rely on a cookie set for an individual browser... Any ideas? TIA, Claudia __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Annoying DB question
how do you have the table setup? what column and default are you using for your PK? if you are using the two columns to form a PK, then you would get this error because, like you said, the values aren't unique. personally i always use uniqueidentifiers as PK and set the default of the column to newid(). if this sounds confusing, post the CREATE TABLE statments for that table and let us take a look. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 1:20 PM To: CF-Talk Subject: Re: Annoying DB question Well the value is not unique becuase the key is on MEALID and MEALTIME which is like 1 = monday time = 1(breakfast) i just was reading about that serialize isoloation level and thought that should do the trick Bill Wheatley Senior Database Developer Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 - Original Message - From: Van Vliet, Scott [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 20, 2002 11:50 AM Subject: RE: Annoying DB question The error you are getting suggests that your PK value is not unique for the row that you are inserting into tblBenefit. Are you using IDENTITY on the PK for that table, or are you inserting the value from the SP? -- Scott Van Vliet Sempra Energy 555 W. 5th St., 21st Floor Los Angeles, CA 90013 Tel 213.244.5205 Email [EMAIL PROTECTED] Hello Stupid, and welcome to your crappy computer. - Strong Bad, HomestarRunner.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 8:38 AM To: CF-Talk Subject: Annoying DB question I'm having an issue Error,TID=361,05/20/102,10:54:12,ODBC Error Code = 23000 (Integrity constraint violation)P [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK benefit'. Cannot insert duplicate key in object 'tblBenefit'.PP SQL = sp_newmeal Heres whats happening we have 8 rows in the db that hold meal plans when we change them we remove the old plans and insert new plans sometimes if you hit refresh enough it causes a ERROR above to be thrown. What i did was put the enter thing into a transaction with SET TRANSACTION ISOLATION LEVEL SERIALIZABLE and it still throws the error when the SQL notes say it shouldnt happen like that any ideas? thanks Bill Wheatley Senior Database Developer Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 __ 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
Does anyone know what this error means???
Error Diagnostic InformationODBC Error Code = S1000 (General error) [MERANT][ODBC Oracle 8 driver][Oracle 8]ORA-01461: can bind a LONG value only for insert into a LONG column SQL = Insert into Reports (RID, Job_Num, Job_Name, alias_name, report_date, report_body, First_Name, Last_Name) Values (7575, 71016, 'GEN''L CAD', 'rayb', {ts '2002-05-31 00:00:00'}, 'DFTCAD Status (05/07/02) Tapeout Support: 1. Leo Rev2: Atpg analysis on the final pass9 netlist is done. The coverage stands at 93.42% for 1500 vectors. 2. Cougar2: Debugging the Jtag issues on the netlist. Was able to generate vectors. Trying to compile the IKOS simulation database. 3. Orion: Atpg with the Rams bypassed is done. The coverage is at 91.85% for 1500 vectors. Vijay is looking into the test point insertion to improve coverage. Personal Status: - Raghavan: 1. Worked on the shaheen iddq issue. Supporting the Jtag sims debug and the ring oscillator vector generation 2. Working on the Cougar Atpg vector generation. Compiling the IKOS bin to verify the vectors. 3. Wrapping up gathering the register list for the Qdsp4u2 Isds support. 4. Looking into the Sequential Atpg for orion. - Vijay: 1. Performed Atpg vector generation and verification on the Leo Rev2 pass9 netlist 2. Working on the Orion Atpg vector generation and verification. Looking into the Test point insertion for Orion on the blocks with low coverage. 3. Wrapped up the Bsdl generation and verification scripts. Tried out the scripts on Cheetah, Qdsp4u2, Shaheen. Compiled a list of issues with inconsistency among the files used for generating the Bsdl files. Designers have to make this files consistent among all the designs 4. Experiments with the Leo set/reset pins to improve the coverage. Initial analysis showed that by tieing the set/reset to shift_enable instead of the test_mode will improve the coverage to 95.16. The vectors generated have to be verified to make sure that they were generated correctly by Tetramax - Raghu: 1. Working on bringing up the flow for at-speed test and transition delay test for orion for both the functional and the testmode cases. 2. Helping the Shaheen team in debugging the issues with Iddq. 3. Working with the Synopsys AE in verifying the flow for At-speed test and providing test cases regarding the issue Action Items: --- - Vijay: Perform the Jtag sims on Orion. Provide the Leo rev2 Atpg coverage break down to Inyup, so that Inyup can pick the vectors for Functional fault grading - Raghavan Perform the Jtag sims on the Cougar2 DFTCAD Status(05/15/02) Tapeout Support: 1. Cougar2 Atpg vectors with the Rams black boxed are Generated. Stil debugging the Zero delay oscillation loop in Ikos simulation. Isolated the problem to be in csc cells. Once the simulations are up, we have to generate the atpg vectors with the rams bypassed and also perform the test point insertion analysis for cougar2 to improve the test coverage. 2. Orion All atpg vectors passed simulation. The coverage stand at 91.85 for 1500 vectors. Still doing experiments to insert the test points to improve the coverage. Personal Status: - Raghavan: 1. Worked on the Atpg support for cougar2. Trying to resolve the zero delay oscillation loop. Tried out the different approaches by emptying out the blocks that might cause the oscillation. 2. Debugging the Jtag sims failure on the bscan_ip and bscan_op test files. 3. Performing the remaining isds sims for qdsp4u3 - Vijay: 1. Few more action items to implement on the Bsdl generation. a. Make a command for the compliance some what like this, compliance = pin, value b. Bsdl_Gen -help should show the config file. 2. Performed the Atpg vector generation and verification on Orion. Stil looking into the coverage improvement by doing test point insertion on orion. 3. Debugging the Orion Jtag sims failure issue - Raghu 1. Worked with Raghavan on debugging the zero delay oscillation issue on Cougar2. 2. Support the Shaheen Iddq debug issue. 3. Worked on the at speed test and functional mode vector generation evaluation on Orion. Bringing up the transition delay fault flow on Orion.', 'Ray', 'Bujarski') Data Source = SSR The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (56:2) to (56:53) in the template file /prj/vlsi/web/Groups/RFAnalog/SSR/act_Report.cfm. Ray Bujarski 858-845-7669 858-636-9900 pgr [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: deadlocks in CFGLOBAL
In addition to what Jon suggested you may want to consider implementing the UUIDToken solution described here: http://www.macromedia.com/v1/Handlers/index.cfm?ID=22427Method=Full It helped our site when we were seeing Session/Client variables being improperly shared by different users as you describe. Note that it requires some changes to the CFID field in order to hold the longer token. I have made those columns VARCHAR(70) and it seems to be long enough. /rob -Original Message- From: Hoag, Claudia (LNG) [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 12:42 PM To: CF-Talk Subject: RE: deadlocks in CFGLOBAL Thanks, I didn't realize that's all it was storing in CGLOBAL :) -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 12:38 PM To: CF-Talk Subject: Re: deadlocks in CFGLOBAL Client variables use a cookie to look up the client value from the database, so it is possible and I imagine cfglobal table gets a lot of Update or Select/Insert (I'm not sure how CF handles updating that table) queries under load. You might want to go into the CF admin and just disable global client variable updates, in the client variable section if you dont use the stats CF keeps about last visit's and hitcounts. Disabling the global stats is SOP here. You will probably notice an overall performance boost as well... jon - Original Message - From: Hoag, Claudia (LNG) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 20, 2002 12:02 PM Subject: deadlocks in CFGLOBAL Does anyone know why I get row level deadlocks in CFGLOBAL and what are the implications of that? The other day I talked to our DBA about some deadlocks (not related to CFGLOBAL) and she started to look for them... And found a whole bunch of deadlocks in the CFGLOBAL table. Those are row level locks and if she didn't start looking for them, I would never take notice that those were happening. I wonder if that has anything to do with users complaining that their client variables are getting mixed with other users' client variables. I can't see how that would happen, considering that the client variables rely on a cookie set for an individual browser... Any ideas? TIA, Claudia __ 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: MX in distributed mode?????
We use CF5 in distributed mode at the moment...and we're moving to CFMX. I can't confirm 100% but all you have to do is configure the apache module to farm out all jsp/cfm/cfc requests to the app server IP address rather than localhost:55000 or whatever it is normally. As for IIS configuration I'm not sure :( Stace -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 11:09 AM To: CF-Talk Subject: MX in distributed mode? From a previous post I know that CF5 could be run in distributed mode, and that this was only done to satisfy security requirements. Well that's what I need to do. But I wondered what the process might be to manage this for MX? I assume it must be a different process. Can't find anything in the docs. I also assume that when the J2EE versions come out that can sit directly on top of for example the full version of JRun or WebSphere, this will be standard? What will the general architecture model be? Anyone at Macromedia point me in the right direction? ** The opinions expressed in this E-mail are those of the individual and not necessarily the company. This E-mail and any files transmitted with it are confidential and solely for the use of the intended recipients ** __ 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: SQL Server 2K indexing
Jim, Short answer no with an if. Long answer yes with a but. just kidding ;) You can certainly create and index which contains multiple columns. Whether or not you want to do this is another topic completely. There are alot of questions which you need to answer to properly index a table. What kinds of queries will be run against the table? What fields will be most often searched or joined on? How many updates/inserts are anticipated? All of these things should be taken into account because they can have a large impact on index tuning. For example if you said that most of the searches would be done on names you might want to create a clustered index on (last_name, first_name). Also your table seems to be missing a primary key? Is it (office_id, position_id)? I would add a primary key (which will automatically create an index on those fields, you probably want it unclustered but again it's difficult to say without knowing your data patterns). Another option is to let the SQL Server (assuming you're using sql server, other db vendors likely have similar tools) Index Tuning Wizard do the work. This will allow SQL Server to watch your table in action so to speak and suggest index improvements. This is a good solution if you are unsure about the types of queries that will be run against your table. /rob -Original Message- From: Jim Curran [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 6:44 PM To: CF-Talk Subject: OT: SQL Server 2K indexing Hello all, I'm setting up indexes for a new table on the following fields... first_name last_name office_ID (FK) position_ID (fk) Should I create a new index for each field? Or can i create one index with all fields listed in the column area? TIA, - j __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: MX in distributed mode?????
Checkout the JRun install guide, should give ya the answer! http://livedocs.macromedia.com/jrun4docs/ -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 1:36 PM To: CF-Talk Subject: RE: MX in distributed mode? We use CF5 in distributed mode at the moment...and we're moving to CFMX. I can't confirm 100% but all you have to do is configure the apache module to farm out all jsp/cfm/cfc requests to the app server IP address rather than localhost:55000 or whatever it is normally. As for IIS configuration I'm not sure :( Stace -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 11:09 AM To: CF-Talk Subject: MX in distributed mode? From a previous post I know that CF5 could be run in distributed mode, and that this was only done to satisfy security requirements. Well that's what I need to do. But I wondered what the process might be to manage this for MX? I assume it must be a different process. Can't find anything in the docs. I also assume that when the J2EE versions come out that can sit directly on top of for example the full version of JRun or WebSphere, this will be standard? What will the general architecture model be? Anyone at Macromedia point me in the right direction? ** The opinions expressed in this E-mail are those of the individual and not necessarily the company. This E-mail and any files transmitted with it are confidential and solely for the use of the intended recipients ** __ 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: MX in distributed mode?????
Ok I was curious myself ;) http://livedocs.macromedia.com/jrun4docs/JRun_Administrators_Guide/connector s4.jsp#1124835 I believe you should be able to manually edit an equivalent file on the CFMX install. Stace -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 2:16 PM To: CF-Talk Subject: RE: MX in distributed mode? Checkout the JRun install guide, should give ya the answer! http://livedocs.macromedia.com/jrun4docs/ -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 1:36 PM To: CF-Talk Subject: RE: MX in distributed mode? We use CF5 in distributed mode at the moment...and we're moving to CFMX. I can't confirm 100% but all you have to do is configure the apache module to farm out all jsp/cfm/cfc requests to the app server IP address rather than localhost:55000 or whatever it is normally. As for IIS configuration I'm not sure :( Stace -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 11:09 AM To: CF-Talk Subject: MX in distributed mode? From a previous post I know that CF5 could be run in distributed mode, and that this was only done to satisfy security requirements. Well that's what I need to do. But I wondered what the process might be to manage this for MX? I assume it must be a different process. Can't find anything in the docs. I also assume that when the J2EE versions come out that can sit directly on top of for example the full version of JRun or WebSphere, this will be standard? What will the general architecture model be? Anyone at Macromedia point me in the right direction? ** The opinions expressed in this E-mail are those of the individual and not necessarily the company. This E-mail and any files transmitted with it are confidential and solely for the use of the intended recipients ** __ 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 vs. PHP email handling
has CFMAIL improved in 4.5, 5, MX? It's marginally better in later versions, up to 5, than in CF 4. However, it should be much, much better in CF MX, which uses the java.mail API instead of the code that Allaire/MM wrote themselves to interface with SMTP. In addition, CF MX supports spooling to memory instead of disk, if you choose. So, I think there'll be less need for CF developers to turn to third-party products to work around CFMAIL's limitations. 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: SQL Server 2K indexing
thanks.. That helps... All of my ID's are Primary Keys in their respective tables. ( i left out attorney_ID (PK) in my example) I assumed I should create indexes for all of the foreign keys within a table as well as all of the fields I search on, but just wanted to double check. All of my queries/joins will be based on Pkeys and Fkeys w/ some exceptions as first names, last names... As for implementing in SQL server, is it better practice to create each index w/ one column? - j -Original Message- From: Rob Baxter [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 2:10 PM To: CF-Talk Subject: RE: SQL Server 2K indexing Jim, Short answer no with an if. Long answer yes with a but. just kidding ;) You can certainly create and index which contains multiple columns. Whether or not you want to do this is another topic completely. There are alot of questions which you need to answer to properly index a table. What kinds of queries will be run against the table? What fields will be most often searched or joined on? How many updates/inserts are anticipated? All of these things should be taken into account because they can have a large impact on index tuning. For example if you said that most of the searches would be done on names you might want to create a clustered index on (last_name, first_name). Also your table seems to be missing a primary key? Is it (office_id, position_id)? I would add a primary key (which will automatically create an index on those fields, you probably want it unclustered but again it's difficult to say without knowing your data patterns). Another option is to let the SQL Server (assuming you're using sql server, other db vendors likely have similar tools) Index Tuning Wizard do the work. This will allow SQL Server to watch your table in action so to speak and suggest index improvements. This is a good solution if you are unsure about the types of queries that will be run against your table. /rob -Original Message- From: Jim Curran [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 6:44 PM To: CF-Talk Subject: OT: SQL Server 2K indexing Hello all, I'm setting up indexes for a new table on the following fields... first_name last_name office_ID (FK) position_ID (fk) Should I create a new index for each field? Or can i create one index with all fields listed in the column area? TIA, - j __ 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: deadlocks in CGLOBAL
That's not the only situation where you get deadlocks. On Friday we were discussing that, and the problem then was due to page locks in MSSQL. The deadlocks in CGLOBAL are at row level, and I see now what that has to do with the mixing client variables. People probably sent out URLs with their CFID and CFTOKEN on them. So whoever followed the link while the session was alive shared the same session! So possibly we had different browsers/computers/clients causing updates for the same row in CGLOBAL at the same time. For the CGLOBAL problem, we'll just disable the updates. For the mixing variables problem, I'll look at what Rob says... Thanks :) Claudia -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 1:24 PM To: CF-Talk Subject: RE: deadlocks in CFGLOBAL Strange. Deadlocks most often happen when you have code that updates one row in the DB based on info from another row. Example: UPDATE cellGlobal SET myVar = (SELECT myVar from cellGlobal WHERE foo = 1) WHERE foo = 2; This code is dangerous because it could cause deadlocks... what if it's updating row 1 based on row 2 while a concurrent thread is updating row 2 based on row 1? deadlock Search your code for any client variable updates that might cause the above situation to happen. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication 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: Hoag, Claudia (LNG) [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 9:02 AM To: CF-Talk Subject: deadlocks in CFGLOBAL Does anyone know why I get row level deadlocks in CFGLOBAL and what are the implications of that? The other day I talked to our DBA about some deadlocks (not related to CFGLOBAL) and she started to look for them... And found a whole bunch of deadlocks in the CFGLOBAL table. Those are row level locks and if she didn't start looking for them, I would never take notice that those were happening. I wonder if that has anything to do with users complaining that their client variables are getting mixed with other users' client variables. I can't see how that would happen, considering that the client variables rely on a cookie set for an individual browser... Any ideas? TIA, Claudia __ 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: Annoying DB question
try using a CFTRANSACTION like this... cftransaction cfquery name= EXECUTE sp_newmeal /cfquery /cftransaction It is my understanding that the CFTRANSACTION will single thread ALL requests to the specified DB (instead of just row-level or table-level locks). That will prevent concurrent threads from inserting the same ID +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 8:38 AM To: CF-Talk Subject: Annoying DB question I'm having an issue Error,TID=361,05/20/102,10:54:12,ODBC Error Code = 23000 (Integrity constraint violation)P [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK benefit'. Cannot insert duplicate key in object 'tblBenefit'.PP SQL = sp_newmeal Heres whats happening we have 8 rows in the db that hold meal plans when we change them we remove the old plans and insert new plans sometimes if you hit refresh enough it causes a ERROR above to be thrown. What i did was put the enter thing into a transaction with SET TRANSACTION ISOLATION LEVEL SERIALIZABLE and it still throws the error when the SQL notes say it shouldnt happen like that any ideas? thanks Bill Wheatley Senior Database Developer Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF vs. PHP email handling
Actually in both version 4.5 and 5 (I am not sure if you could do it in earlier versions or in CFMX) you can invoke CF from the command line by calling the CFML.exe engine.. I don't quite understand what you mean by CF not letting you CFMAIL from within a query...can you please elaborate? Best Regards, Donnie Bachan Phone: (718) 217-2883 ICQ#: 28006783 Nitendo Vinces - By Striving You Shall Conquer == The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Annoying DB question
I thought you have to committ the transaction as well? I've had SQL problems using this syntax w/o a commit.. - j -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 2:39 PM To: CF-Talk Subject: RE: Annoying DB question try using a CFTRANSACTION like this... cftransaction cfquery name= EXECUTE sp_newmeal /cfquery /cftransaction It is my understanding that the CFTRANSACTION will single thread ALL requests to the specified DB (instead of just row-level or table-level locks). That will prevent concurrent threads from inserting the same ID +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 8:38 AM To: CF-Talk Subject: Annoying DB question I'm having an issue Error,TID=361,05/20/102,10:54:12,ODBC Error Code = 23000 (Integrity constraint violation)P [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK benefit'. Cannot insert duplicate key in object 'tblBenefit'.PP SQL = sp_newmeal Heres whats happening we have 8 rows in the db that hold meal plans when we change them we remove the old plans and insert new plans sometimes if you hit refresh enough it causes a ERROR above to be thrown. What i did was put the enter thing into a transaction with SET TRANSACTION ISOLATION LEVEL SERIALIZABLE and it still throws the error when the SQL notes say it shouldnt happen like that any ideas? thanks Bill Wheatley Senior Database Developer Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 __ 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
Macromedia Forums (aka FuseTalk)
Dear MM, Your forums blow. I have tried to log in many times and it seems almost random if I get in. Anyway, I figured I would post something here so you know why I am not going to waste my time trying to tell you about your preview product. If others are having close to the same level of frustration with the forums, you're losing a lot of potentially valuable input. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x DaVita Inc. __ 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: Macromedia Forums (aka FuseTalk)
wow. that was remarkably professional. - Original Message - From: Rick Walters [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 20, 2002 3:11 PM Subject: Macromedia Forums (aka FuseTalk) Dear MM, Your forums blow. I have tried to log in many times and it seems almost random if I get in. Anyway, I figured I would post something here so you know why I am not going to waste my time trying to tell you about your preview product. If others are having close to the same level of frustration with the forums, you're losing a lot of potentially valuable input. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x DaVita Inc. __ 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: Macromedia Forums (aka FuseTalk)
I'm sure they're crushed. Absolutely devastated. They're probably going to cancel the whole thing based upon your input. -Original Message- From: Rick Walters [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 2:12 PM To: CF-Talk Subject: Macromedia Forums (aka FuseTalk) Dear MM, Your forums blow. I have tried to log in many times and it seems almost random if I get in. Anyway, I figured I would post something here so you know why I am not going to waste my time trying to tell you about your preview product. If others are having close to the same level of frustration with the forums, you're losing a lot of potentially valuable input. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x DaVita Inc. __ 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: Annoying DB question
try using a CFTRANSACTION like this... cftransaction cfquery name= EXECUTE sp_newmeal /cfquery /cftransaction It is my understanding that the CFTRANSACTION will single thread ALL requests to the specified DB (instead of just row-level or table-level locks). That will prevent concurrent threads from inserting the same ID I don't think that's correct. CFTRANSACTION doesn't single-thread all requests to the DB - and a good thing, too. Instead, it tells the database to treat the queries contained within the CFTRANSACTION tags as a single transaction. How the database actually handles the transaction is up to the database, to a degree - some databases may lock an entire table, others may lock a page, others may lock a row. In addition, you can use the ISOLATION attribute to specify the desired isolation level, which basically boils down to how optimistic you are about the likelihood of concurrency issues, or whether you even care about them. 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
Question on Email Addresses
I am trying to parse an email address due to the friendly email addresses by using CFPOP. If the #FROM# resembles: [EMAIL PROTECTED] then I am fine however since there are friendly email address which look like myname [EMAIL PROTECTED] then I have to use HTMLEditFormat to get the email address. However using this code, does not FIND the in the email addresses that are Friendly however it will fine the @ symbol. What am I missing??? cfset checkEmail = #HTMLEditFormat(from)# cfif #FindNoCase(,checkEmail,1)# Email Start Point Located cfelse !--- Use CheckEmail --- If it is a Friendly Email Address then When I validate this in the DB, it looks for the entire string myname [EMAIL PROTECTED] and NOT just the email address. /cfif sorry I am just not with it today to think about it any longer and I know it is something so dang simple that I am just overlooking... Thanks in Advance! NO - #findnocase(@,checkEmail,1)# - /cfif #LEN(checkEmail)# br /cfoutput __ 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