re: Passing Session variables
For all you all nighters:) I am having a problem passing session variables in my app. The variable I am using does not get invoked until after you are already in the app. Where I am having the problem is passing that variable from the page after it get initialized. Here is the code in part: Page 1: cfquery name=members datasource=#db# SELECT * FROM contact,contact_role,progress WHERE contact.contact_role_key = contact_role.contact_role_key AND contact_role.contact_role_key = 1 AND contact.contact_key = progress.contact_key /cfquery Select a Member to Evaluatebr FORM NAME=select1 SELECT NAME=select1 onChange=surfto(this.form) SIZE=1 OPTION -- Select a Member -- /option cfoutput query=get_members option value=dsp_membergraphs.cfm?contact_key=#first##last# #first# #last#/cfoutput /option /select /form Passes to Page 2: cfoutput strongProgress Tracker Report: #SESSION.member_contact_key#/strong P p align=left ul lia href=dsp_progress-report.cfm?action=#URL.contact_key#View/Edit /aReport li a href=index2.cfm?contact_key=#URL.contact_key#View/a Member Graphs /ul /cfoutput Passes to page 3: (Problem page) cfset action=SESSION.member_contact_key cfoutput table border=0 cellpadding=3 cellspacing=3 th align=left colspan=3 bgcolor=006951 font color=White Here are the current progress tracker scores for: #SESSION.member_contact_key#/font/th /cfoutput/table This page gives me an error. It's late and I'm on brain lock:) This needs to work by morning. Any suggestions are truly appreciated! Cecilia Jimason Shaw __ 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: Passing Session variables
It would be helpful if you could post the entire error it is giving you, as well as the code for that custom JavaScript function. -Justin Scott, Lead Developer Sceiron Internet Services, Inc. http://www.sceiron.com - Original Message - From: Cecilia Shaw [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 06, 2002 3:08 AM Subject: re: Passing Session variables For all you all nighters:) I am having a problem passing session variables in my app. The variable I am using does not get invoked until after you are already in the app. Where I am having the problem is passing that variable from the page after it get initialized. Here is the code in part: Page 1: cfquery name=members datasource=#db# SELECT * FROM contact,contact_role,progress WHERE contact.contact_role_key = contact_role.contact_role_key AND contact_role.contact_role_key = 1 AND contact.contact_key = progress.contact_key /cfquery Select a Member to Evaluatebr FORM NAME=select1 SELECT NAME=select1 onChange=surfto(this.form) SIZE=1 OPTION -- Select a Member -- /option cfoutput query=get_members option value=dsp_membergraphs.cfm?contact_key=#first##last# #first# #last#/cfoutput /option /select /form Passes to Page 2: cfoutput strongProgress Tracker Report: #SESSION.member_contact_key#/strong P p align=left ul lia href=dsp_progress-report.cfm?action=#URL.contact_key#View/Edit /aReport li a href=index2.cfm?contact_key=#URL.contact_key#View/a Member Graphs /ul /cfoutput Passes to page 3: (Problem page) cfset action=SESSION.member_contact_key cfoutput table border=0 cellpadding=3 cellspacing=3 th align=left colspan=3 bgcolor=006951 font color=White Here are the current progress tracker scores for: #SESSION.member_contact_key#/font/th /cfoutput/table This page gives me an error. It's late and I'm on brain lock:) This needs to work by morning. Any suggestions are truly appreciated! Cecilia Jimason Shaw __ 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: Passing Session variables
Here is the error I get on the 3rd page: Error Diagnostic Information ODBC Error Code = 22005 (Error in assignment) [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (71:3) to (71:52). Date/Time: 05/06/02 01:51:28 Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0) Remote Address: 172.142.191.243 HTTP Referrer: ../../dsp_membergraphs.cfm?contact_key=memberfirstmemberlast Query String: contact_key=member This is the query producing the error: CFSET action IS URL.contact_key CFQUERY NAME=progress_report DATASOURCE=#db# SELECT contact.contact_key, progress.* FROM contact,progress WHERE contact.contact_key = progress.contact_key AND contact.contact_key = '#URL.contact_key#' ORDER BY contact.contact_key /cfquery From: Justin Scott [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: Passing Session variables Date: Mon, 6 May 2002 03:31:20 -0400 It would be helpful if you could post the entire error it is giving you, as well as the code for that custom JavaScript function. -Justin Scott, Lead Developer Sceiron Internet Services, Inc. http://www.sceiron.com - Original Message - From: Cecilia Shaw [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 06, 2002 3:08 AM Subject: re: Passing Session variables For all you all nighters:) I am having a problem passing session variables in my app. The variable I am using does not get invoked until after you are already in the app. Where I am having the problem is passing that variable from the page after it get initialized. Here is the code in part: Page 1: cfquery name=members datasource=#db# SELECT * FROM contact,contact_role,progress WHERE contact.contact_role_key = contact_role.contact_role_key AND contact_role.contact_role_key = 1 AND contact.contact_key = progress.contact_key /cfquery Select a Member to Evaluatebr FORM NAME=select1 SELECT NAME=select1 onChange=surfto(this.form) SIZE=1 OPTION -- Select a Member -- /option cfoutput query=get_members option value=dsp_membergraphs.cfm?contact_key=#first##last# #first# #last#/cfoutput /option /select /form Passes to Page 2: cfoutput strongProgress Tracker Report: #SESSION.member_contact_key#/strong P p align=left ul lia href=dsp_progress-report.cfm?action=#URL.contact_key#View/Edit /aReport li a href=index2.cfm?contact_key=#URL.contact_key#View/a Member Graphs /ul /cfoutput Passes to page 3: (Problem page) cfset action=SESSION.member_contact_key cfoutput table border=0 cellpadding=3 cellspacing=3 th align=left colspan=3 bgcolor=006951 font color=White Here are the current progress tracker scores for: #SESSION.member_contact_key#/font/th /cfoutput/table This page gives me an error. It's late and I'm on brain lock:) This needs to work by morning. Any suggestions are truly appreciated! Cecilia Jimason Shaw __ 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: Passing Session variables
I still don't see how this is a problem with your session variables? Check the type of the contact_key field in the contact table and make sure it's a string of some sort if that's what you're trying to compare it with. Also, your CFSET above that is using the operator IS instead of an equal sign. Maybe that's supposed to be a CFIF instead? -Justin Scott, Lead Developer Sceiron Internet Services, Inc. http://www.sceiron.com - Original Message - From: Cecilia Shaw [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 06, 2002 4:53 AM Subject: Re: Passing Session variables Here is the error I get on the 3rd page: Error Diagnostic Information ODBC Error Code = 22005 (Error in assignment) [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (71:3) to (71:52). Date/Time: 05/06/02 01:51:28 Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0) Remote Address: 172.142.191.243 HTTP Referrer: ./../dsp_membergraphs.cfm?contact_key=memberfirstmemberlast Query String: contact_key=member This is the query producing the error: CFSET action IS URL.contact_key CFQUERY NAME=progress_report DATASOURCE=#db# SELECT contact.contact_key, progress.* FROM contact,progress WHERE contact.contact_key = progress.contact_key AND contact.contact_key = '#URL.contact_key#' ORDER BY contact.contact_key /cfquery From: Justin Scott [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: Passing Session variables Date: Mon, 6 May 2002 03:31:20 -0400 It would be helpful if you could post the entire error it is giving you, as well as the code for that custom JavaScript function. -Justin Scott, Lead Developer Sceiron Internet Services, Inc. http://www.sceiron.com - Original Message - From: Cecilia Shaw [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 06, 2002 3:08 AM Subject: re: Passing Session variables For all you all nighters:) I am having a problem passing session variables in my app. The variable I am using does not get invoked until after you are already in the app. Where I am having the problem is passing that variable from the page after it get initialized. Here is the code in part: Page 1: cfquery name=members datasource=#db# SELECT * FROM contact,contact_role,progress WHERE contact.contact_role_key = contact_role.contact_role_key AND contact_role.contact_role_key = 1 AND contact.contact_key = progress.contact_key /cfquery Select a Member to Evaluatebr FORM NAME=select1 SELECT NAME=select1 onChange=surfto(this.form) SIZE=1 OPTION -- Select a Member -- /option cfoutput query=get_members option value=dsp_membergraphs.cfm?contact_key=#first##last# #first# #last#/cfoutput /option /select /form Passes to Page 2: cfoutput strongProgress Tracker Report: #SESSION.member_contact_key#/strong P p align=left ul lia href=dsp_progress-report.cfm?action=#URL.contact_key#View/Edit /aReport li a href=index2.cfm?contact_key=#URL.contact_key#View/a Member Graphs /ul /cfoutput Passes to page 3: (Problem page) cfset action=SESSION.member_contact_key cfoutput table border=0 cellpadding=3 cellspacing=3 th align=left colspan=3 bgcolor=006951 font color=White Here are the current progress tracker scores for: #SESSION.member_contact_key#/font/th /cfoutput/table This page gives me an error. It's late and I'm on brain lock:) This needs to work by morning. Any suggestions are truly appreciated! Cecilia Jimason Shaw __ 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: Passing values between frames
We have an app that does this all over the place. In our case it is for our intranet so we can insure that everyone is using IE. Therefore we did it with IFRAME tags. But you can do the same thing with regular frames, you just have another object level in the chain. To reference the form on the parent page we do a parent.formname.submit() - i.e. parent.DataForm.submit() __ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX:301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299WWW:http://www.euservices.com __ -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 05, 2002 3:37 PM To: CF-Talk Subject: RE: Passing values between frames I am not anywhere a JS reference, but you can reference the parent frame's form with something like parent.document. -Matt -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 05, 2002 12:24 PM To: CF-Talk Subject: Re: Passing values between frames How can I have the child frame cause the parent to submit to itself using JS? Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: Matt Liotta [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, May 05, 2002 11:58 AM Subject: RE: Passing values between frames In order to move data from JavaScript to CF, you will need to have the browser make a request. A common way to hide this is to use a hidden frame. In the hidden frame, you have JavaScript send and receive some data on a regular basis. You might want to look to WDDX for help moving the data back and forth. -Matt -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 05, 2002 11:58 AM To: CF-Talk Subject: Passing values between frames I have a chat application that I am attempting and require the brain energy of the group. This is frames based app, and I am attempting to do it with an array versus a database. the layout etc... is below. I am trying to use a Coldfusion array, but do not know if I can pass the value of the textbox in [postMessage.cfm] from javascript into the coldfusion array using arrayAppend() somehow. [Index.cfm] Holds the frameset of the pages [messages.cfm] This is the chat window [postMessage.cfm] This holds the textbox for the person to submit their message. [whosOn.cfm] This holds a list of who is currently logged into the chat Douglas Brown Email: [EMAIL PROTECTED] __ 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: Looping...
Hi, I have the following code that lists a directory structure but ignores the files listed below. Is there a way to have the files below read in from a database and then loop through field to eliminate all the code below? The database field would be as follows: test1.txt,text2.txt,tst3.txt,txt4.txt,test5.txt,text6.txt,tst7.txt,txt8.txt cfloop index=LineNo from=#i# to=#i# cfif Session.stDirFileType[i] eq File cfif Session.stDirFileName[i] is not test1.txt and Session.stDirFileName[i] is not text2.txt and Session.stDirFileName[i] is not tst3.txt and Session.stDirFileName[i] is not txt4.txt and Session.stDirFileName[i] is not test5.txt and Session.stDirFileName[i] is not text6.txt and Session.stDirFileName[i] is not txt7.txt and Session.stDirFileName[i] is not txt8.txt /cfif /c +---+ Philip Humeniuk [EMAIL PROTECTED] [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: Who wants a free Mac?
Or To ReArrange the toolbars on the top of the editor simply right click and select 'Organize Quick Bar...' or To create a custom toolbar, simply click on the toolbars and select 'Customize...' or To view a list of local files not contained within a 'SITE' in less than 3 minutes, simply look to the Directory Listing on the left hand pane... or To connect to a remote server using FTP or RDS without having to create a site definition for the entire site ... Seriously - why does the directory listing in DWMX take 3-4 minutes to retrieve the contents of my LOCAL websites directory in my f: drive? Every time I open a new folder it does it all over again and it really takes a long long time. I manage a LOT of sites that we host - and it's a real pain to have to make a SITE for every single one just to make 1 page modification. Why would you remove such elegant functionality? FTP/RDS was one of the features that really set Studio apart from other IDEs. Why would you remove functionality in an upgrade? Not everyone wants to be Wizarded through every phase of development. Hopefully I'm just missing something and someone here will point me in the right direction for the old, more functional and faster file panel while in Code Layout. PLEASE 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: Owen Leonard [mailto:[EMAIL PROTECTED]] Sent: Saturday, May 04, 2002 7:36 AM To: CF-Talk Subject: RE: Who wants a free Mac? Can you figure out how the tip would be applicable for DWMX and submit that? Not if my tip is, Assign keyboard shortcuts to your snippets to make hand coding faster and more efficient! ;-) -- Owen While you're getting your tips/entries on, check out the tips already in there at: http://www.macromedia.com/v1/tipsubmission/main.cfm Hmmm... Where's ColdFusion Studio in that list? I'll bet this group has lots of good Studio tips to contribute. __ 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
MySQL OLE DB
I cant find a OLE DB driver for MySQL. Does one exists? Thanks __ 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: Looping...
You can write the query in such a way that you do not select the records with the filenames u have listed below You can use not in ( 'test1.txt','text2.txt','tst3.txt',... ) clause Then in that case u need not have any loop to ignore these... -Original Message- From: phumes1 [SMTP:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 6:25 PM To: CF-Talk Subject: Re: Looping... Hi, I have the following code that lists a directory structure but ignores the files listed below. Is there a way to have the files below read in from a database and then loop through field to eliminate all the code below? The database field would be as follows: test1.txt,text2.txt,tst3.txt,txt4.txt,test5.txt,text6.txt,tst7.txt,txt8.tx t cfloop index=LineNo from=#i# to=#i# cfif Session.stDirFileType[i] eq File cfif Session.stDirFileName[i] is not test1.txt and Session.stDirFileName[i] is not text2.txt and Session.stDirFileName[i] is not tst3.txt and Session.stDirFileName[i] is not txt4.txt and Session.stDirFileName[i] is not test5.txt and Session.stDirFileName[i] is not text6.txt and Session.stDirFileName[i] is not txt7.txt and Session.stDirFileName[i] is not txt8.txt /cfif /c +- --+ Philip Humeniuk [EMAIL PROTECTED] [EMAIL PROTECTED] +- ---+ __ 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: Who wants a free Mac?
| From: Joshua Miller [mailto:[EMAIL PROTECTED]] | | I manage a LOT of sites that we host - and it's a real pain | to have to make a SITE for every single one just to make | 1 page modification. Why would you remove such elegant | functionality? FTP/RDS was one of the features that really | set Studio apart from other IDEs. Why would you remove | functionality in an upgrade? Not everyone wants to be | Wizarded through every phase of development. | If you look under the folders for your defined site, you'll see the rest of the drives on your local machine ... If the files are there, you can still get to them, as far as RDS, well, I'm still having trouble setting that up. I have the CFIDE folder setup on the remote server with limited permissions ...so I need to login twice, once with Windows authentication, then with RDS authentication ... With Studio, this is fine, I get the prompt box for my Win password, then RDS kicks in ... Doesn't seem as if DWMX can handle this, unless I'm missing something somewhere? - Erika L. Walker-Arnold, VP, RUWebby, LLC US 1.973.626.2412 UK 011.44.20.8406.4094 UK Mobile 011.44.77.6607.3695 - Macromedia ColdFusion Alliance Partner Macromedia ColdFusion 5.0 Certified Developer - Instant Messenger Access AIM: WebErika5 | Yahoo: WebErika | MSN: WebErika - __ 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
CFWACK's CD Index
Hi, I'm trying to understand the CD Index in the CFWack book. If I wish to learn more about looping over lists (which I am), I look it up in the CD index and it directs me to CD-71. Does anyone know what this is? I mean, I'm looking on the CD for anything regarding a 71st page/chapter/file/folder but no luck. Thanks! Andrew __ 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: Query Issue.
Well obviously you wouldn't be using a column that you were trying to update. - Original Message - From: Jared Stark To: CF-Talk Sent: Friday, May 03, 2002 6:25 PM Subject: RE: Query Issue. Except then if you try to update that same column later in the same query SQL Server will get upset with you. -Original Message- From: Kreig Zimmerman [mailto:[EMAIL PROTECTED]] Sent: Friday, May 03, 2002 4:23 PM To: CF-Talk Subject: Re: Query Issue. what i usually do is columnname = columnname which updates the content of the column, with the contents of the column--no problems there, eh? - Original Message - From: Jared Stark To: CF-Talk Sent: Friday, May 03, 2002 5:52 PM Subject: RE: Query Issue. I tried the 0 = 0 trick and SQL Server gives me an error. Does that work for you? __ 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
CFHTTP + Cookies?
Can CFHTTP accept cookies and if so how? Thanks, Neil __ 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: CFWACK's CD Index
Just a guess, but is it Chapter 7, example 1? Which version of the WACK book are you looking at? Look for an About the CD' section in the index. I bet that would help. At 08:22 AM 5/6/2002 -0500, you wrote: Hi, I'm trying to understand the CD Index in the CFWack book. If I wish to learn more about looping over lists (which I am), I look it up in the CD index and it directs me to CD-71. Does anyone know what this is? I mean, I'm looking on the CD for anything regarding a 71st page/chapter/file/folder but no luck. Thanks! Andrew __ 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: CFHTTP + Cookies?
Send a cookie along cfhttpparam type=COOKIE name=userid value=10 If you want to accept a cookie coming from the other server, you can get it from the cfhttp.responseHeader structure. Look for a key called Set-cookie. Be aware that the value is a simple value if 1 cookie is set or an array if multiple cookies are set. -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: maandag 6 mei 2002 15:35 To: CF-Talk Subject: CFHTTP + Cookies? Can CFHTTP accept cookies and if so how? Thanks, Neil __ 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: CFWACK's CD Index
Hi Jeffry. Thanks for your response. However, there ain't no chapter 7 code listing. I'm baffled! -Andrew -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 9:06 AM To: CF-Talk Subject: Re: CFWACK's CD Index Just a guess, but is it Chapter 7, example 1? Which version of the WACK book are you looking at? Look for an About the CD' section in the index. I bet that would help. At 08:22 AM 5/6/2002 -0500, you wrote: Hi, I'm trying to understand the CD Index in the CFWack book. If I wish to learn more about looping over lists (which I am), I look it up in the CD index and it directs me to CD-71. Does anyone know what this is? I mean, I'm looking on the CD for anything regarding a 71st page/chapter/file/folder but no luck. Thanks! Andrew __ 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: CFWACK's CD Index
What is CFWACK? Thanks, Dave Bosky -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 10:06 AM To: CF-Talk Subject: Re: CFWACK's CD Index Just a guess, but is it Chapter 7, example 1? Which version of the WACK book are you looking at? Look for an About the CD' section in the index. I bet that would help. At 08:22 AM 5/6/2002 -0500, you wrote: Hi, I'm trying to understand the CD Index in the CFWack book. If I wish to learn more about looping over lists (which I am), I look it up in the CD index and it directs me to CD-71. Does anyone know what this is? I mean, I'm looking on the CD for anything regarding a 71st page/chapter/file/folder but no luck. Thanks! Andrew __ 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
Getting FLash through a CF security model.
Take the following example of a security proggie: In application.cfm... cfif not session.login cfif form Authenticate, set session.login. /cfif Login Form. /cfif This is a simple login program and works like a charm. I run into problems when I try to use a Flash movie that talks to one of the ColdFusion templates using loadvariables(). Though the user is logged in, the Flash movie gets the login screen... i.e. ColdFusion doesn't recognize the Flash plugin as part of the user session. Is there a good way to allow the player to get this data without circumventing security? Thanks :) Eric __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: MySQL OLE DB
http://mysql.com/downloads/contrib.html Scroll down a little bit on that page. Adam. -Original Message- From: chad [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 8:06 AM To: CF-Talk Subject: MySQL OLE DB I cant find a OLE DB driver for MySQL. Does one exists? Thanks __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFWACK's CD Index
ColdFusion Web Application Construction Kit. At 10:18 AM 5/6/2002 -0400, you wrote: What is CFWACK? Thanks, Dave Bosky -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 10:06 AM To: CF-Talk Subject: Re: CFWACK's CD Index Just a guess, but is it Chapter 7, example 1? Which version of the WACK book are you looking at? Look for an About the CD' section in the index. I bet that would help. At 08:22 AM 5/6/2002 -0500, you wrote: Hi, I'm trying to understand the CD Index in the CFWack book. If I wish to learn more about looping over lists (which I am), I look it up in the CD index and it directs me to CD-71. Does anyone know what this is? I mean, I'm looking on the CD for anything regarding a 71st page/chapter/file/folder but no luck. Thanks! Andrew __ 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
objExcel functions
I found some code to allow me to write to an Excel spreadsheet from CF in CFTipsPlus but it doesn't give all the functions (such as how to write to the chart title, etc.) Does any one know where I can find a list of these functions? T __ 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: objExcel functions
You'll do better with a book on the Office Object Model (yes, there are complete books on this subject). You'll have to do some cludging to get cfscript to work with some Object calls, some things just don't work. You've probably seen cfcomet.com, but if not, stop over there first - plenty of black magic to be had from that site. MSDN usually has some starter info to at least point you where to go: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/modcore/htm l/deovrUnderstandingExcelApplicationObject.asp Adam. -Original Message- From: Thane Sherrington [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 9:31 AM To: CF-Talk Subject: objExcel functions I found some code to allow me to write to an Excel spreadsheet from CF in CFTipsPlus but it doesn't give all the functions (such as how to write to the chart title, etc.) Does any one know where I can find a list of these functions? T __ 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
Determine if file is there
Is there an easy way, without reading the entire file to determine if a file exsists on the server? __ 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: Determine if file is there
Fileexists function Fileexists(absolute_path) -Original Message- From: Nick McClure [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 9:59 AM To: CF-Talk Subject: Determine if file is there Is there an easy way, without reading the entire file to determine if a file exsists on the server? __ 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: Do I need to lock around queries?
If the name of the query is application.queryname (for example), then yes, it must be locked. But rather than locking the entire query - to save time name the query request.queryname (for example) then after the query move the var into the application scope. Anytime an application, server, or session variable is in code it's either a read or a write, and must be locked. Chris Norloff -- Original Message -- from: Andy Ousterhout [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Sun, 5 May 2002 14:20:09 -0500 Should I put named locks around database queries or should the database engine (Access2000)? I have heard the Access sometimes has indexing issues and I was curious if anyone out their had experience with locks reducing the likelihood of an indexing issue. Thanks, Andy __ 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: Determine if file is there
Use the CFML function: FileExists(absolute_path) HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: Nick McClure [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 06, 2002 10:58 AM Subject: Determine if file is there Is there an easy way, without reading the entire file to determine if a file exsists on the server? __ 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: Determine if file is there
You could use CFdirectory. That only gets the directory listing which you can loop through to find the file or files. -Original Message- From: Nick McClure [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 7:59 AM To: CF-Talk Subject: Determine if file is there Is there an easy way, without reading the entire file to determine if a file exsists on the server? __ 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: Determine if file is there
FileExists() e.g cfif FileExists(c:\inetpub\wwwroot\somefile.cfm) true cfelse false /cfif - Original Message - From: Nick McClure [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 06, 2002 10:58 AM Subject: Determine if file is there Is there an easy way, without reading the entire file to determine if a file exsists on the server? __ 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: Do I need to lock around queries?
Would locking include such things as checking if statements, ie: CFIF NOT IsDefined (SESSION.var) Run some code /CFIF Thanks, Mark -Original Message- From: Chris Norloff [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 11:01 AM To: CF-Talk Subject: Re: Do I need to lock around queries? If the name of the query is application.queryname (for example), then yes, it must be locked. But rather than locking the entire query - to save time name the query request.queryname (for example) then after the query move the var into the application scope. Anytime an application, server, or session variable is in code it's either a read or a write, and must be locked. Chris Norloff -- Original Message -- from: Andy Ousterhout [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Sun, 5 May 2002 14:20:09 -0500 Should I put named locks around database queries or should the database engine (Access2000)? I have heard the Access sometimes has indexing issues and I was curious if anyone out their had experience with locks reducing the likelihood of an indexing issue. Thanks, Andy __ 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: Do I need to lock around queries?
Should I put named locks around database queries or should the database engine (Access2000)? I have heard the Access sometimes has indexing issues and I was curious if anyone out their had experience with locks reducing the likelihood of an indexing issue. You should only lock for updating Application, Session and Server variables If you are putting the query into one of those scopes, load it into a Variables scope query first, then copy it to the other scope - a LOT quicker 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. ** __ 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
Left Outer Join - Lotsa Pain!
This query is being run on MSAccess 2002. I want to do a LEFT OUTER JOIN so that all company names are returned based on a product CATEGORY, even though they may not have a product BRAND associated with them. (I used a joining table, pl_join, because one company may have many brands; the pl_joincatbrand table is used as a joining table because one brand may belong to many categories). The query statement below works properly, but will not bring back company names that do not have a brand. I've tried a number of ways to do a LOJ in the FROM statement, but I can't get it to work where there are more than two tables involved. (ie, FROM pl_companies LEFT OUTER JOIN pl_join ON pl_companies.pl_ID = pl_join.pl_ID) Your help is greatly appreciated, as my head is getting really sore banging it on the desk for the past 7 hours trying to get this to work right. Mark SELECT * FROM pl_category, pl_join, pl_companies, pl_joincatbrand, pl_brands WHERE pl_category.prl_cat_ID = #FORM.prl_cat_ID# AND pl_category.prl_cat_ID = pl_joincatbrand.prl_cat_ID AND pl_Brands.pl_BID = pl_joincatbrand.pl_BID AND pl_Brands.pl_BID = pl_join.pl_BID AND pl_join.pl_ID = pl_companies.pl_ID ORDER BY pl_companies.co_name ASC Thanks, Mark __ 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: All CFM Templates Require Login?
I can't deny that CF began as a Windows only solution. However, CFMX is not based on J2EE, which has long preferred the *nix platform and its respective web servers. -Matt -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 05, 2002 10:26 PM To: CF-Talk Subject: Re: All CFM Templates Require Login? CF has been primarily designed to work with IIS first, Apache and others second. In regards to CF support IIS is superior to Apache. That is a non-subjective fact. That doesn't mean that wont change or I think it is a good thing, but sticking the new Lamborghini's all-wheel drivetrain in an 18 wheeler isn't going to make it drive any better either. jon Matt Liotta wrote: Sure it's subjective; isn't just about every product comparison? -Matt __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: MySQL OLE DB
I have played with that one and i cannot get it to work. The db's hook up in the CFADMIN and they verify, but i get really strange errors when trying to access the databases in CF pages. Anyone got this connector to work? Any tips on how to get it to work? At 09:20 AM 5/6/2002 -0500, you wrote: http://mysql.com/downloads/contrib.html Scroll down a little bit on that page. Adam. -Original Message- From: chad [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 8:06 AM To: CF-Talk Subject: MySQL OLE DB I cant find a OLE DB driver for MySQL. Does one exists? Thanks __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Getting FLash through a CF security model.
oi Eric!! what about if you include the cftoken in the object source? -- Critz Certified Adv. ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion Monday, May 6, 2002, 10:24:11 AM, you wrote: CE Take the following example of a security proggie: CE In application.cfm... CE cfif not session.login CE cfif form CE Authenticate, set session.login. CE /cfif CE Login Form. CE /cfif CE This is a simple login program and works like a charm. I run into problems CE when I try to use a Flash movie that talks to one of the ColdFusion CE templates using loadvariables(). Though the user is logged in, the Flash CE movie gets the login screen... i.e. ColdFusion doesn't recognize the Flash CE plugin as part of the user session. CE Is there a good way to allow the player to get this data without CE circumventing security? CE Thanks :) CE Eric CE __ 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: Do I need to lock around queries?
Yes, that's a read. -- Original Message -- from: Mark Leder [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Mon, 6 May 2002 11:08:45 -0400 Would locking include such things as checking if statements, ie: CFIF NOT IsDefined (SESSION.var) Run some code /CFIF Thanks, Mark -Original Message- From: Chris Norloff [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 11:01 AM To: CF-Talk Subject: Re: Do I need to lock around queries? If the name of the query is application.queryname (for example), then yes, it must be locked. But rather than locking the entire query - to save time name the query request.queryname (for example) then after the query move the var into the application scope. Anytime an application, server, or session variable is in code it's either a read or a write, and must be locked. Chris Norloff -- Original Message -- from: Andy Ousterhout [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Sun, 5 May 2002 14:20:09 -0500 Should I put named locks around database queries or should the database engine (Access2000)? I have heard the Access sometimes has indexing issues and I was curious if anyone out their had experience with locks reducing the likelihood of an indexing issue. Thanks, Andy __ 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: Getting FLash through a CF security model.
oi Critz!! Great idea! Works perfectly! The ColdFusion IRC community strikes again! Thanks :) Eric -Original Message- From: Critz [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 11:22 AM To: CF-Talk Subject: Re: Getting FLash through a CF security model. oi Eric!! what about if you include the cftoken in the object source? -- Critz Certified Adv. ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion Monday, May 6, 2002, 10:24:11 AM, you wrote: CE Take the following example of a security proggie: CE In application.cfm... CE cfif not session.login CE cfif form CE Authenticate, set session.login. CE /cfif CE Login Form. CE /cfif CE This is a simple login program and works like a charm. I run into problems CE when I try to use a Flash movie that talks to one of the ColdFusion CE templates using loadvariables(). Though the user is logged in, the Flash CE movie gets the login screen... i.e. ColdFusion doesn't recognize the Flash CE plugin as part of the user session. CE Is there a good way to allow the player to get this data without CE circumventing security? CE Thanks :) CE Eric CE __ 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: Do I need to lock around queries?
Would locking include such things as checking if statements, ie: CFIF NOT IsDefined (SESSION.var) Run some code /CFIF You only need to lock to update, reading does not need a Lock, unless you're REALLY paranoid about it changing information while your code is running 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. ** __ 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
Moving CF admin?
Sorry, I know this was asked before. How does one move the CF Administrator on a server that already has CF installed? BJ ___ Sent by ePrompter, the premier email notification software. Free download at http://www.ePrompter.com. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Do I need to lock around queries?
Sorry I don't have an answer for you, but I do have another question on the locking issue When you put a variable in your application.cfm (for example, your DSN name), is it automatically an application scope variable requiring application locking whether or not you use application.DSN rather than just DSN? And if it is not an application scope variable, what is its scope? Thanks in advance, Margaret -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 8:44 AM To: CF-Talk Subject: RE: Do I need to lock around queries? Would locking include such things as checking if statements, ie: CFIF NOT IsDefined (SESSION.var) Run some code /CFIF You only need to lock to update, reading does not need a Lock, unless you're REALLY paranoid about it changing information while your code is running 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. ** __ 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
Macromedia Folks: What are you thinking?
Why did you remove basic use of FTP/RDS from Studio and replace it with the Dreamweaver SITE function? That was by far one of the BEST features of the Studio product, and the SITE feature is probably one of the worst features of Dreamweaver. What about those of us who manage more than 1 site, or more than 10 or 50 sites? What about those of us that want to connect to a client's site, make a minor modification to a page and be done with it? Why should you HAVE to setup a site for everything you want to edit on a remote server? I just don't understand why you would remove this feature. I can live without customizable toolbars or the ability to add new ones. I can live (although not as easily) without keyboard shortcuts for snippets. I like a lot of the new features and the new environment is acceptable from a code standpoint. I've always liked Dreamweaver for layout and design - so please don't think I'm trying to slam the new product, it has a lot of nice features and is really a good step in the right direction. I just can't understand why you would take away this simple, elegant and VERY useful feature and replace it with such a cumbersome, jakey process as the Dreamweaver Site management crap. 6 times today alone I've had modifications or bugs to fix on remote sites. I don't WANT a local copy of everything I work on. I don't WANT to index all 1200 pages of someone's site so that I can edit 2 lines of code. I don't WANT to manage resources or colors or stylesheets or flash documents. I just want fast, easy access to remote code. Why is that no longer possible? It takes 3 minutes to load my LOCAL websites directory and it does it every time I switch from DreamweaverMX to another application. When I come back it refreshes the directory for another 3 minutes. All of our developers have had the exact same complaint and are giving me grief wanting to switch to something other than Studio now. Am I just missing something? Please tell me you didn't REALLY remove basic FTP/RDS in favor of this bunch of muck. Honestly, I'd REALLY like to know from the people who made this decision why it was done this way. Maybe I'm just looking at it wrong? Thanks, Joshua Miller Web Development :: Programming Eagle Web Development LLC www.eaglewd.com [EMAIL PROTECTED] (304) 622-5676 (Clarksburg Office) (304) 456-4942 (Home Office) __ 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: Macromedia Folks: What are you thinking?
AMEN! If they removed it compelely i agree ;) I'm too busy heads down in JSp crap to look into the new CF stuff Bill Wheatley Senior Database Developer Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 - Original Message - From: Joshua Miller [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 06, 2002 11:56 AM Subject: Macromedia Folks: What are you thinking? Why did you remove basic use of FTP/RDS from Studio and replace it with the Dreamweaver SITE function? That was by far one of the BEST features of the Studio product, and the SITE feature is probably one of the worst features of Dreamweaver. What about those of us who manage more than 1 site, or more than 10 or 50 sites? What about those of us that want to connect to a client's site, make a minor modification to a page and be done with it? Why should you HAVE to setup a site for everything you want to edit on a remote server? I just don't understand why you would remove this feature. I can live without customizable toolbars or the ability to add new ones. I can live (although not as easily) without keyboard shortcuts for snippets. I like a lot of the new features and the new environment is acceptable from a code standpoint. I've always liked Dreamweaver for layout and design - so please don't think I'm trying to slam the new product, it has a lot of nice features and is really a good step in the right direction. I just can't understand why you would take away this simple, elegant and VERY useful feature and replace it with such a cumbersome, jakey process as the Dreamweaver Site management crap. 6 times today alone I've had modifications or bugs to fix on remote sites. I don't WANT a local copy of everything I work on. I don't WANT to index all 1200 pages of someone's site so that I can edit 2 lines of code. I don't WANT to manage resources or colors or stylesheets or flash documents. I just want fast, easy access to remote code. Why is that no longer possible? It takes 3 minutes to load my LOCAL websites directory and it does it every time I switch from DreamweaverMX to another application. When I come back it refreshes the directory for another 3 minutes. All of our developers have had the exact same complaint and are giving me grief wanting to switch to something other than Studio now. Am I just missing something? Please tell me you didn't REALLY remove basic FTP/RDS in favor of this bunch of muck. Honestly, I'd REALLY like to know from the people who made this decision why it was done this way. Maybe I'm just looking at it wrong? Thanks, Joshua Miller Web Development :: Programming Eagle Web Development LLC www.eaglewd.com [EMAIL PROTECTED] (304) 622-5676 (Clarksburg Office) (304) 456-4942 (Home Office) __ 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: Do I need to lock around queries?
So do you recommend locking all updates, even if no session or application variable is around? If so, do you use named locks versus scoped? Andy -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 10:44 AM To: CF-Talk Subject: RE: Do I need to lock around queries? Would locking include such things as checking if statements, ie: CFIF NOT IsDefined (SESSION.var) Run some code /CFIF You only need to lock to update, reading does not need a Lock, unless you're REALLY paranoid about it changing information while your code is running 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. ** __ 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: Do I need to lock around queries?
No. Default unless fully qualified is type variables, not application Andy -Original Message- From: Margaret Fisk [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 10:55 AM To: CF-Talk Subject: RE: Do I need to lock around queries? Sorry I don't have an answer for you, but I do have another question on the locking issue When you put a variable in your application.cfm (for example, your DSN name), is it automatically an application scope variable requiring application locking whether or not you use application.DSN rather than just DSN? And if it is not an application scope variable, what is its scope? Thanks in advance, Margaret -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 8:44 AM To: CF-Talk Subject: RE: Do I need to lock around queries? Would locking include such things as checking if statements, ie: CFIF NOT IsDefined (SESSION.var) Run some code /CFIF You only need to lock to update, reading does not need a Lock, unless you're REALLY paranoid about it changing information while your code is running 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. ** __ 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: Do I need to lock around queries?
Thanks. I'll look up type variables to figure out how to treat them. -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 9:01 AM To: CF-Talk Subject: RE: Do I need to lock around queries? No. Default unless fully qualified is type variables, not application Andy -Original Message- From: Margaret Fisk [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 10:55 AM To: CF-Talk Subject: RE: Do I need to lock around queries? Sorry I don't have an answer for you, but I do have another question on the locking issue When you put a variable in your application.cfm (for example, your DSN name), is it automatically an application scope variable requiring application locking whether or not you use application.DSN rather than just DSN? And if it is not an application scope variable, what is its scope? Thanks in advance, Margaret -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 8:44 AM To: CF-Talk Subject: RE: Do I need to lock around queries? Would locking include such things as checking if statements, ie: CFIF NOT IsDefined (SESSION.var) Run some code /CFIF You only need to lock to update, reading does not need a Lock, unless you're REALLY paranoid about it changing information while your code is running 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. ** __ 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: Do I need to lock around queries?
And if it is not an application scope variable, what is its scope? Declaring a variable in you application template does NOT create an application scoped var unless you set it like this: cflock timeout= throwontimeout=No type=EXCLUSIVE cfset application.myVar = datasource it is available in the variable scope. /cflock If you set it like this: cfset myVar = datasource it is available in the variable scope. -Craig Thomas __ 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
Vspider, got it working
Just in case anyone has wanted to get this working right, the sites listed below include a new style file so that it maps the fields correctly. This works great if you include a lot of files to make your final outcome look like a decent website, this will be great for us fusebox folks. http://www.daemon.com.au/navitron/display.cfm?objectid=5B7F8B4D-4260-4C46-A5 431EC7DDC5A06E http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=7threadid= 211850 Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire __ 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
Anyone seen this CFtrace error in the Server logs?
We are getting this error repeatedly in the server logs of a client: - CFTrace::logThread(2308) has no entry for thread 2308 Has anyone seen these and does anyone have any comments, is it bad etc? Macromedia seem to think it's a benign error. Mike Brunt, CTO Webapper http://www.webapper.com Tel: 562.243.6255 Instant Messaging AIM: webappermb Webapper, Downey CA Office Webapper - Making the NET Work __ 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: Macromedia Folks: What are you thinking?
I don't work with RDS or FTP, but I've already determined that I'll be sticking with CF Studio 4.5.2 for the web app I'm developing. Simply because I don't like the idea of building a SITE in DWMX so I can work with my files (yes, I know I can edit my files without a site, but you loose some of the functionality of DW if you don't create a site - such as dynamic content - unless you manually code everything.) I don't like the ideas of these extra files floating around my web directories. When I build an app, the files within my app folder(s) are files required by the app. This site file serves no purpose when I deliver my site, and becomes an extra step to remember if I don't want to transfer that file to my live site. That said, I DO like most of the features I see in DWMX, and am likely to use it for future development. But these little quirks make it difficult to switch over an existing, partially constructed app. Shawn Grover -Original Message- From: Joshua Miller [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 9:57 AM To: CF-Talk Subject: Macromedia Folks: What are you thinking? Why did you remove basic use of FTP/RDS from Studio and replace it with the Dreamweaver SITE function? That was by far one of the BEST features of the Studio product, and the SITE feature is probably one of the worst features of Dreamweaver. What about those of us who manage more than 1 site, or more than 10 or 50 sites? What about those of us that want to connect to a client's site, make a minor modification to a page and be done with it? Why should you HAVE to setup a site for everything you want to edit on a remote server? I just don't understand why you would remove this feature. I can live without customizable toolbars or the ability to add new ones. I can live (although not as easily) without keyboard shortcuts for snippets. I like a lot of the new features and the new environment is acceptable from a code standpoint. I've always liked Dreamweaver for layout and design - so please don't think I'm trying to slam the new product, it has a lot of nice features and is really a good step in the right direction. I just can't understand why you would take away this simple, elegant and VERY useful feature and replace it with such a cumbersome, jakey process as the Dreamweaver Site management crap. 6 times today alone I've had modifications or bugs to fix on remote sites. I don't WANT a local copy of everything I work on. I don't WANT to index all 1200 pages of someone's site so that I can edit 2 lines of code. I don't WANT to manage resources or colors or stylesheets or flash documents. I just want fast, easy access to remote code. Why is that no longer possible? It takes 3 minutes to load my LOCAL websites directory and it does it every time I switch from DreamweaverMX to another application. When I come back it refreshes the directory for another 3 minutes. All of our developers have had the exact same complaint and are giving me grief wanting to switch to something other than Studio now. Am I just missing something? Please tell me you didn't REALLY remove basic FTP/RDS in favor of this bunch of muck. Honestly, I'd REALLY like to know from the people who made this decision why it was done this way. Maybe I'm just looking at it wrong? Thanks, Joshua Miller Web Development :: Programming Eagle Web Development LLC www.eaglewd.com [EMAIL PROTECTED] (304) 622-5676 (Clarksburg Office) (304) 456-4942 (Home Office) __ 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: Do I need to lock around queries?
Margaret, Go into help in Studio and search on Variable. There will be one entry that displays all of the variable types and their scopes. Andy -Original Message- From: Margaret Fisk [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 11:03 AM To: CF-Talk Subject: RE: Do I need to lock around queries? Thanks. I'll look up type variables to figure out how to treat them. -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 9:01 AM To: CF-Talk Subject: RE: Do I need to lock around queries? No. Default unless fully qualified is type variables, not application Andy -Original Message- From: Margaret Fisk [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 10:55 AM To: CF-Talk Subject: RE: Do I need to lock around queries? Sorry I don't have an answer for you, but I do have another question on the locking issue When you put a variable in your application.cfm (for example, your DSN name), is it automatically an application scope variable requiring application locking whether or not you use application.DSN rather than just DSN? And if it is not an application scope variable, what is its scope? Thanks in advance, Margaret -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 8:44 AM To: CF-Talk Subject: RE: Do I need to lock around queries? Would locking include such things as checking if statements, ie: CFIF NOT IsDefined (SESSION.var) Run some code /CFIF You only need to lock to update, reading does not need a Lock, unless you're REALLY paranoid about it changing information while your code is running 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. ** __ 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: Left Outer Join - Lotsa Pain!
mark, try using left outer join to join *all* of your tables, starting with pl_companies and ending with pl_brands. ~ dina WHERE pl_category.prl_cat_ID = #FORM.prl_cat_ID# AND pl_category.prl_cat_ID = pl_joincatbrand.prl_cat_ID AND pl_Brands.pl_BID = pl_joincatbrand.pl_BID AND pl_Brands.pl_BID = pl_join.pl_BID AND pl_join.pl_ID = pl_companies.pl_ID ORDER BY pl_companies.co_name ASC - Original Message - From: Mark Leder [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 06, 2002 10:10 AM Subject: Left Outer Join - Lotsa Pain! This query is being run on MSAccess 2002. I want to do a LEFT OUTER JOIN so that all company names are returned based on a product CATEGORY, even though they may not have a product BRAND associated with them. (I used a joining table, pl_join, because one company may have many brands; the pl_joincatbrand table is used as a joining table because one brand may belong to many categories). The query statement below works properly, but will not bring back company names that do not have a brand. I've tried a number of ways to do a LOJ in the FROM statement, but I can't get it to work where there are more than two tables involved. (ie, FROM pl_companies LEFT OUTER JOIN pl_join ON pl_companies.pl_ID = pl_join.pl_ID) Your help is greatly appreciated, as my head is getting really sore banging it on the desk for the past 7 hours trying to get this to work right. Mark SELECT * FROM pl_category, pl_join, pl_companies, pl_joincatbrand, pl_brands WHERE pl_category.prl_cat_ID = #FORM.prl_cat_ID# AND pl_category.prl_cat_ID = pl_joincatbrand.prl_cat_ID AND pl_Brands.pl_BID = pl_joincatbrand.pl_BID AND pl_Brands.pl_BID = pl_join.pl_BID AND pl_join.pl_ID = pl_companies.pl_ID ORDER BY pl_companies.co_name ASC Thanks, Mark __ 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: Do I need to lock around queries?
So do you recommend locking all updates, even if no session or application variable is around? If so, do you use named locks versus scoped? You should Lock all updates to Application, Session and Server variables, but not other scopes - the only thing about Locking is that if you don't do it, the server has to ensure it's the only application/page doing the update, which adds to it's load Personally I'd lock anyways, it lightens the load for a tiny extra few lines... Worth it in my book Oh, and obviously you don't lock every CFSet if you have a block of them - lock the block... I've seen code (inherited from another company) where they put a CFLock around every single CFSet in a block of 30 in a row... 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: Macromedia Folks: What are you thinking?
At 10:17 AM 5/6/2002 -0600, you wrote: I don't work with RDS or FTP, but I've already determined that I'll be sticking with CF Studio 4.5.2 for the web app I'm developing. Simply because I don't like the idea of building a SITE in DWMX so I can work with my files (yes, I know I can edit my files without a site, but you loose some of the functionality of DW if you don't create a site - such as dynamic content - unless you manually code everything.) I don't like the ideas of these extra files floating around my web directories. When I build an app, the files within my app folder(s) are files required by the app. This site file serves no purpose when I deliver my site, and becomes an extra step to remember if I don't want to transfer that file to my live site. I agree with you. That is my biggest bite about Dreamweaver sites. At least they aren't as bad as Frontpage, though, right? Do those extra folders transfer if you the Dreamweaver synchronize functionality? -- Jeffry Houser | mailto:[EMAIL PROTECTED] Need a Web Developer? Contact me! AIM: Reboog711 | Fax / Phone: 860-223-7946 -- My Books: http://www.instantcoldfusion.com My Band: http://www.farcryfly.com -- Will I be on the streets tomorrow, Will I have to beg and Borrow Will I have to go back to the job I left behind? __ 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
Looping to find [brackets]
Hi, I need to loop through a large amount of text - which might contain HTML - to find numbers surrounded by square brackets (i.e. [n]). Once found, I need to alter it into something like this: a href=here.cfm?v=nview/a (where n is a number). There will be about 30 square-bracketed numbers like this. Does anyone have any advice how to tackle this - is this is a time for rereplace? Cheers Will --- Become a Pingographer and share your photos for free: http://www.localbounty.com/pingo __ 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: Determine if file is there
Oh yea, don't mind me, its monday. At 10:01 AM 5/6/2002 -0500, you wrote: Fileexists function Fileexists(absolute_path) -Original Message- From: Nick McClure [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 9:59 AM To: CF-Talk Subject: Determine if file is there Is there an easy way, without reading the entire file to determine if a file exsists on the server? __ 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
PayFlow
I've seen reference to a CFX_PFPRO tag but can't find out how to go about getting it? Is it something you buy from Verisign when you sign up for Payflow? Thanks, - Sean ~~ Sean Daniels Director, Engineering Marketplace Technologies, Inc (T): 207.363.7374 (C): 207.332.6340 (F): 240.269.6319 ~~ http://www.dealforce.com http://www.mergernetwork.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Macromedia Folks: What are you thinking?
Haven't played with the Synchronize functionality of DWMX. But I have used UltraDev. The synch function in UltraDev makes sure the folder/file structure of your target source matches your local source - and the site files were transfered. Again, I think the integration of DW and CF Studio is well on it's way, and MM has done an excellent job at it thus far. But, there's still a few hicups to iron out. However, DWMX is still in release candidate phase - maybe these will be gone when the official release comes out. Shawn Grover -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 10:22 AM To: CF-Talk Subject: RE: Macromedia Folks: What are you thinking? At 10:17 AM 5/6/2002 -0600, you wrote: I don't work with RDS or FTP, but I've already determined that I'll be sticking with CF Studio 4.5.2 for the web app I'm developing. Simply because I don't like the idea of building a SITE in DWMX so I can work with my files (yes, I know I can edit my files without a site, but you loose some of the functionality of DW if you don't create a site - such as dynamic content - unless you manually code everything.) I don't like the ideas of these extra files floating around my web directories. When I build an app, the files within my app folder(s) are files required by the app. This site file serves no purpose when I deliver my site, and becomes an extra step to remember if I don't want to transfer that file to my live site. I agree with you. That is my biggest bite about Dreamweaver sites. At least they aren't as bad as Frontpage, though, right? Do those extra folders transfer if you the Dreamweaver synchronize functionality? -- Jeffry Houser | mailto:[EMAIL PROTECTED] Need a Web Developer? Contact me! AIM: Reboog711 | Fax / Phone: 860-223-7946 -- My Books: http://www.instantcoldfusion.com My Band: http://www.farcryfly.com -- Will I be on the streets tomorrow, Will I have to beg and Borrow Will I have to go back to the job I left behind? __ 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: PayFlow
People who subscribe to the PayFlow Pro service can use this Feature. I think you have to be using PayFlow pro to get it. You can download it from the download section of your verisign manager. At 12:05 PM 5/6/2002 -0400, you wrote: I've seen reference to a CFX_PFPRO tag but can't find out how to go about getting it? Is it something you buy from Verisign when you sign up for Payflow? Thanks, - Sean ~~ Sean Daniels Director, Engineering Marketplace Technologies, Inc (T): 207.363.7374 (C): 207.332.6340 (F): 240.269.6319 ~~ http://www.dealforce.com http://www.mergernetwork.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: Left Outer Join - Lotsa Pain!
So how would I write it for Access? Would I still use the WHERE statement? It's the syntax for Access that really throws me for a loop! FROM pl_companies LEFT OUTER JOIN (pl_category, pl_join, pl_joincatbrand, pl_brands) Thanks, Mark -Original Message- From: Dina Hess [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 12:13 PM To: CF-Talk Subject: Re: Left Outer Join - Lotsa Pain! mark, try using left outer join to join *all* of your tables, starting with pl_companies and ending with pl_brands. ~ dina WHERE pl_category.prl_cat_ID = #FORM.prl_cat_ID# AND pl_category.prl_cat_ID = pl_joincatbrand.prl_cat_ID AND pl_Brands.pl_BID = pl_joincatbrand.pl_BID AND pl_Brands.pl_BID = pl_join.pl_BID AND pl_join.pl_ID = pl_companies.pl_ID ORDER BY pl_companies.co_name ASC - Original Message - From: Mark Leder [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 06, 2002 10:10 AM Subject: Left Outer Join - Lotsa Pain! This query is being run on MSAccess 2002. I want to do a LEFT OUTER JOIN so that all company names are returned based on a product CATEGORY, even though they may not have a product BRAND associated with them. (I used a joining table, pl_join, because one company may have many brands; the pl_joincatbrand table is used as a joining table because one brand may belong to many categories). The query statement below works properly, but will not bring back company names that do not have a brand. I've tried a number of ways to do a LOJ in the FROM statement, but I can't get it to work where there are more than two tables involved. (ie, FROM pl_companies LEFT OUTER JOIN pl_join ON pl_companies.pl_ID = pl_join.pl_ID) Your help is greatly appreciated, as my head is getting really sore banging it on the desk for the past 7 hours trying to get this to work right. Mark SELECT * FROM pl_category, pl_join, pl_companies, pl_joincatbrand, pl_brands WHERE pl_category.prl_cat_ID = #FORM.prl_cat_ID# AND pl_category.prl_cat_ID = pl_joincatbrand.prl_cat_ID AND pl_Brands.pl_BID = pl_joincatbrand.pl_BID AND pl_Brands.pl_BID = pl_join.pl_BID AND pl_join.pl_ID = pl_companies.pl_ID ORDER BY pl_companies.co_name ASC Thanks, Mark __ 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: Left Outer Join - Lotsa Pain!
The easiest way to get the Access SQL is to construct the statement in the Access GUI. Then you can test out your query as well. -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 9:47 AM To: CF-Talk Subject: RE: Left Outer Join - Lotsa Pain! So how would I write it for Access? Would I still use the WHERE statement? It's the syntax for Access that really throws me for a loop! FROM pl_companies LEFT OUTER JOIN (pl_category, pl_join, pl_joincatbrand, pl_brands) Thanks, Mark -Original Message- From: Dina Hess [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 12:13 PM To: CF-Talk Subject: Re: Left Outer Join - Lotsa Pain! mark, try using left outer join to join *all* of your tables, starting with pl_companies and ending with pl_brands. ~ dina WHERE pl_category.prl_cat_ID = #FORM.prl_cat_ID# AND pl_category.prl_cat_ID = pl_joincatbrand.prl_cat_ID AND pl_Brands.pl_BID = pl_joincatbrand.pl_BID AND pl_Brands.pl_BID = pl_join.pl_BID AND pl_join.pl_ID = pl_companies.pl_ID ORDER BY pl_companies.co_name ASC - Original Message - From: Mark Leder [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 06, 2002 10:10 AM Subject: Left Outer Join - Lotsa Pain! This query is being run on MSAccess 2002. I want to do a LEFT OUTER JOIN so that all company names are returned based on a product CATEGORY, even though they may not have a product BRAND associated with them. (I used a joining table, pl_join, because one company may have many brands; the pl_joincatbrand table is used as a joining table because one brand may belong to many categories). The query statement below works properly, but will not bring back company names that do not have a brand. I've tried a number of ways to do a LOJ in the FROM statement, but I can't get it to work where there are more than two tables involved. (ie, FROM pl_companies LEFT OUTER JOIN pl_join ON pl_companies.pl_ID = pl_join.pl_ID) Your help is greatly appreciated, as my head is getting really sore banging it on the desk for the past 7 hours trying to get this to work right. Mark SELECT * FROM pl_category, pl_join, pl_companies, pl_joincatbrand, pl_brands WHERE pl_category.prl_cat_ID = #FORM.prl_cat_ID# AND pl_category.prl_cat_ID = pl_joincatbrand.prl_cat_ID AND pl_Brands.pl_BID = pl_joincatbrand.pl_BID AND pl_Brands.pl_BID = pl_join.pl_BID AND pl_join.pl_ID = pl_companies.pl_ID ORDER BY pl_companies.co_name ASC Thanks, Mark __ 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: Who wants a free Mac?
Unfortunately, no. Only in US and Canada, due to legal restrictions. Here are the eligibility details from: http://www.macromedia.com/desdev/tips_library/rules.html 1. Eligibility: Open to legal residents of the 50 U.S. (including the District of Columbia) and Canada (excluding residents of New York, Florida, the province of Quebec and Puerto Rico and any jurisdiction where this promotion would be prohibited by law) who are 13 years of age or older at time of entry. Employees of Macromedia and their respective agents, affiliates, subsidiary and parent companies, sales representatives, marketing affiliates and partners, distributors, advertising and promotion agencies and members of the immediate families or household of each are not eligible. -Original Message- From: Neil Clark - =TMM= [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 05, 2002 10:23 AM To: CF-Talk Subject: RE: Who wants a free Mac? Is this comp open for Europe? __ 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: Macromedia Folks: What are you thinking?
I certainly hope so ... DWMX has a lot of potential, but removing excellent functionality and replacing it with so-so FrontPage-like features certainly won't win any points with MY team. Macromedia, please don't swallow Studio whole - Dreamweaver isn't THAT good. DreamweaverMX is supposed to be the best of both worlds - coders want non-invasive control of remote content. 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: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 12:43 PM To: CF-Talk Subject: RE: Macromedia Folks: What are you thinking? Haven't played with the Synchronize functionality of DWMX. But I have used UltraDev. The synch function in UltraDev makes sure the folder/file structure of your target source matches your local source - and the site files were transfered. Again, I think the integration of DW and CF Studio is well on it's way, and MM has done an excellent job at it thus far. But, there's still a few hicups to iron out. However, DWMX is still in release candidate phase - maybe these will be gone when the official release comes out. Shawn Grover -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 10:22 AM To: CF-Talk Subject: RE: Macromedia Folks: What are you thinking? At 10:17 AM 5/6/2002 -0600, you wrote: I don't work with RDS or FTP, but I've already determined that I'll be sticking with CF Studio 4.5.2 for the web app I'm developing. Simply because I don't like the idea of building a SITE in DWMX so I can work with my files (yes, I know I can edit my files without a site, but you loose some of the functionality of DW if you don't create a site - such as dynamic content - unless you manually code everything.) I don't like the ideas of these extra files floating around my web directories. When I build an app, the files within my app folder(s) are files required by the app. This site file serves no purpose when I deliver my site, and becomes an extra step to remember if I don't want to transfer that file to my live site. I agree with you. That is my biggest bite about Dreamweaver sites. At least they aren't as bad as Frontpage, though, right? Do those extra folders transfer if you the Dreamweaver synchronize functionality? -- Jeffry Houser | mailto:[EMAIL PROTECTED] Need a Web Developer? Contact me! AIM: Reboog711 | Fax / Phone: 860-223-7946 -- My Books: http://www.instantcoldfusion.com My Band: http://www.farcryfly.com -- Will I be on the streets tomorrow, Will I have to beg and Borrow Will I have to go back to the job I left behind? __ 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: redirect
Hi, I'm passing the following fieldx in my url to another template. #myPath# #FileName# This get passed as: http://test/test.htm Without creating a anchor to execute the above URL in my template file how can I be redirected to the URL using CF or JS and then have the previous window closed? +---+ Philip Humeniuk [EMAIL PROTECTED] [EMAIL PROTECTED] ++ __ 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[2]: Macromedia Folks: What are you thinking?
oi Joshua!! /me thought that's why they included homesite+ *grinz* -- Critz Certified Adv. ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion Monday, May 6, 2002, 12:56:54 PM, you wrote: JM I certainly hope so ... DWMX has a lot of potential, but removing JM excellent functionality and replacing it with so-so FrontPage-like JM features certainly won't win any points with MY team. JM Macromedia, please don't swallow Studio whole - Dreamweaver isn't THAT JM good. DreamweaverMX is supposed to be the best of both worlds - coders JM want non-invasive control of remote content. JM Joshua Miller JM Web Development :: Programming JM Eagle Web Development LLC JM www.eaglewd.com JM [EMAIL PROTECTED] JM (304) 622-5676 (Clarksburg Office) JM (304) 456-4942 (Home Office) JM -Original Message- JM From: Shawn Grover [mailto:[EMAIL PROTECTED]] JM Sent: Monday, May 06, 2002 12:43 PM JM To: CF-Talk JM Subject: RE: Macromedia Folks: What are you thinking? JM Haven't played with the Synchronize functionality of DWMX. But I have JM used UltraDev. The synch function in UltraDev makes sure the JM folder/file structure of your target source matches your local source - JM and the site files were transfered. JM Again, I think the integration of DW and CF Studio is well on it's way, JM and MM has done an excellent job at it thus far. But, there's still a JM few hicups to iron out. However, DWMX is still in release candidate JM phase - maybe these will be gone when the official release comes out. JM Shawn Grover JM -Original Message- JM From: Jeffry Houser [mailto:[EMAIL PROTECTED]] JM Sent: Monday, May 06, 2002 10:22 AM JM To: CF-Talk JM Subject: RE: Macromedia Folks: What are you thinking? JM At 10:17 AM 5/6/2002 -0600, you wrote: I don't work with RDS or FTP, but I've already determined that I'll be sticking with CF Studio 4.5.2 for the web app I'm developing. Simply because I don't like the idea of building a SITE in DWMX so I can work with my files (yes, I know I can edit my files without a site, but you loose JM some of the functionality of DW if you don't create a site - such as dynamic content - unless you manually code everything.) I don't like the ideas of these extra files floating around my web directories. When I build an app, the files within my app folder(s) are files required by the app. This site file serves no purpose when I deliver my site, and becomes an extra step to remember if I don't want to transfer that file to my live site. JM I agree with you. That is my biggest bite about Dreamweaver sites. JM At least they aren't as bad as Frontpage, though, right? JM Do those extra folders transfer if you the Dreamweaver synchronize JM functionality? JM -- JM Jeffry Houser | mailto:[EMAIL PROTECTED] JM Need a Web Developer? Contact me! JM AIM: Reboog711 | Fax / Phone: 860-223-7946 JM -- JM My Books: http://www.instantcoldfusion.com JM My Band: http://www.farcryfly.com JM -- JM Will I be on the streets tomorrow, Will I have to beg and Borrow Will I JM have to go back to the job I left behind? JM __ 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: Macromedia Folks: What are you thinking?
Here.. Here.. | -Original Message- | From: Joshua Miller [mailto:[EMAIL PROTECTED]] | Sent: Monday, May 06, 2002 9:57 AM | To: CF-Talk | Subject: RE: Macromedia Folks: What are you thinking? | | | I certainly hope so ... DWMX has a lot of potential, but | removing excellent functionality and replacing it with so-so | FrontPage-like features certainly won't win any points with MY team. | | Macromedia, please don't swallow Studio whole - Dreamweaver | isn't THAT good. DreamweaverMX is supposed to be the best of | both worlds - coders want non-invasive control of remote content. | | 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: Shawn Grover [mailto:[EMAIL PROTECTED]] | Sent: Monday, May 06, 2002 12:43 PM | To: CF-Talk | Subject: RE: Macromedia Folks: What are you thinking? | | | Haven't played with the Synchronize functionality of DWMX. | But I have used UltraDev. The synch function in UltraDev | makes sure the folder/file structure of your target source | matches your local source - and the site files were transfered. | | Again, I think the integration of DW and CF Studio is well on | it's way, and MM has done an excellent job at it thus far. | But, there's still a few hicups to iron out. However, DWMX | is still in release candidate phase - maybe these will be | gone when the official release comes out. | | Shawn Grover | | -Original Message- | From: Jeffry Houser [mailto:[EMAIL PROTECTED]] | Sent: Monday, May 06, 2002 10:22 AM | To: CF-Talk | Subject: RE: Macromedia Folks: What are you thinking? | | | At 10:17 AM 5/6/2002 -0600, you wrote: | I don't work with RDS or FTP, but I've already determined | that I'll be | sticking with CF Studio 4.5.2 for the web app I'm | developing. Simply | because I don't like the idea of building a SITE in DWMX so | I can work | with my files (yes, I know I can edit my files without a | site, but you | loose | some | of the functionality of DW if you don't create a site - such | as dynamic | | content - unless you manually code everything.) I don't | like the ideas | | of these extra files floating around my web directories. | When I build | an app, the files within my app folder(s) are files required by the | app. This site file serves no purpose when I deliver my site, and | becomes an extra step to remember if I don't want to | transfer that file | | to my live site. | | I agree with you. That is my biggest bite about | Dreamweaver sites. At least they aren't as bad as Frontpage, | though, right? | Do those extra folders transfer if you the Dreamweaver | synchronize functionality? | | | | -- | Jeffry Houser | mailto:[EMAIL PROTECTED] | Need a Web Developer? Contact me! | AIM: Reboog711 | Fax / Phone: 860-223-7946 | -- | My Books: http://www.instantcoldfusion.com | My Band: http://www.farcryfly.com | -- | Will I be on the streets tomorrow, Will I have to beg and | Borrow Will I have to go back to the job I left behind? | | | | __ 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
storing files in DB
Hi guys, has anybody come across writing/reading files to a db? any advice will be much appreciated. WAJ. __ 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 Folks: What are you thinking?
Has anyone posted this to the bug/wish list at MM??? I don't know the details of that routine, so if not, can someone do so? Thanks. Shawn Grover -Original Message- From: Lee Fuller [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 11:16 AM To: CF-Talk Subject: RE: Macromedia Folks: What are you thinking? Here.. Here.. | -Original Message- | From: Joshua Miller [mailto:[EMAIL PROTECTED]] | Sent: Monday, May 06, 2002 9:57 AM | To: CF-Talk | Subject: RE: Macromedia Folks: What are you thinking? | | | I certainly hope so ... DWMX has a lot of potential, but | removing excellent functionality and replacing it with so-so | FrontPage-like features certainly won't win any points with MY team. | | Macromedia, please don't swallow Studio whole - Dreamweaver | isn't THAT good. DreamweaverMX is supposed to be the best of | both worlds - coders want non-invasive control of remote content. | | 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: Shawn Grover [mailto:[EMAIL PROTECTED]] | Sent: Monday, May 06, 2002 12:43 PM | To: CF-Talk | Subject: RE: Macromedia Folks: What are you thinking? | | | Haven't played with the Synchronize functionality of DWMX. | But I have used UltraDev. The synch function in UltraDev | makes sure the folder/file structure of your target source | matches your local source - and the site files were transfered. | | Again, I think the integration of DW and CF Studio is well on | it's way, and MM has done an excellent job at it thus far. | But, there's still a few hicups to iron out. However, DWMX | is still in release candidate phase - maybe these will be | gone when the official release comes out. | | Shawn Grover | | -Original Message- | From: Jeffry Houser [mailto:[EMAIL PROTECTED]] | Sent: Monday, May 06, 2002 10:22 AM | To: CF-Talk | Subject: RE: Macromedia Folks: What are you thinking? | | | At 10:17 AM 5/6/2002 -0600, you wrote: | I don't work with RDS or FTP, but I've already determined | that I'll be | sticking with CF Studio 4.5.2 for the web app I'm | developing. Simply | because I don't like the idea of building a SITE in DWMX so | I can work | with my files (yes, I know I can edit my files without a | site, but you | loose | some | of the functionality of DW if you don't create a site - such | as dynamic | | content - unless you manually code everything.) I don't | like the ideas | | of these extra files floating around my web directories. | When I build | an app, the files within my app folder(s) are files required by the | app. This site file serves no purpose when I deliver my site, and | becomes an extra step to remember if I don't want to | transfer that file | | to my live site. | | I agree with you. That is my biggest bite about | Dreamweaver sites. At least they aren't as bad as Frontpage, | though, right? | Do those extra folders transfer if you the Dreamweaver | synchronize functionality? | | | | -- | Jeffry Houser | mailto:[EMAIL PROTECTED] | Need a Web Developer? Contact me! | AIM: Reboog711 | Fax / Phone: 860-223-7946 | -- | My Books: http://www.instantcoldfusion.com | My Band: http://www.farcryfly.com | -- | Will I be on the streets tomorrow, Will I have to beg and | Borrow Will I have to go back to the job I left behind? | | | | __ 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
Website Error
Over the weekend we got the following email msg generated thousands of times by our CF Server. We have errors that are generated on the CF server (as part of the site error handling) send an email to the webmaster. We have never seen this error before. It makes no sense. We have no clue what the problem is. The code it refers to has been working fine for months and months. Then on a Sat. after noon, out of the blue, it triggers and virtually every visitor to our site generated this error...actually it doesn't appear to be an error. It didn't impede their ability to navigate the site. Just generated emails. It's a simple CFELSEIF Session.someVar conditional that it's tripping on. Earlier that session var is set by default to FALSE if not defined, in a CFPARAM statement. We bounced the CF server this morning and after a few minutes of additional errors, they have now stopped (as if a queue emptied or something). Has anyone else had this happen or have a clue what would cause this? We are running CF Server 5 - Sample Message - Diagnostics: InsideText Cannot convert to boolean.Please, check the ColdFusion manual for the allowed conversions between data typesThe error occurred while processing an element with a general identifier of (CFELSEIF), occupying document position (124:2) to (124:31). Template: /webtest/latticesemi/web/account/login.cfm Query String: Date/Time: Mon May 06 09:19:30 2002 Referer: http://www.latticesemi.com/account/login.cfm Remote Address: 193.135.247.66 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) __ 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
Query Tool Set (was: Left Outer Join - Lotsa Pain!)
I'd love to use a Query tool - but I think the MS Access tool is tough to work with. Drawing lines and connectors is easy enough, but editing row attributes I think is counterintuitive. I can't seem to get rid of a row if I make a mistake unless I start over entirely - can't seem to delete a row. Anyone have any suggestions on other Query Builder tools that they like? I'd like to use the one included with CF 5, but every time I run a query, it crashes my machine and eats all the memory. Thanks, Mark -Original Message- From: Margaret Fisk [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 12:47 PM To: CF-Talk Subject: RE: Left Outer Join - Lotsa Pain! The easiest way to get the Access SQL is to construct the statement in the Access GUI. Then you can test out your query as well. -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 9:47 AM To: CF-Talk Subject: RE: Left Outer Join - Lotsa Pain! So how would I write it for Access? Would I still use the WHERE statement? It's the syntax for Access that really throws me for a loop! FROM pl_companies LEFT OUTER JOIN (pl_category, pl_join, pl_joincatbrand, pl_brands) Thanks, Mark -Original Message- From: Dina Hess [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 12:13 PM To: CF-Talk Subject: Re: Left Outer Join - Lotsa Pain! mark, try using left outer join to join *all* of your tables, starting with pl_companies and ending with pl_brands. ~ dina WHERE pl_category.prl_cat_ID = #FORM.prl_cat_ID# AND pl_category.prl_cat_ID = pl_joincatbrand.prl_cat_ID AND pl_Brands.pl_BID = pl_joincatbrand.pl_BID AND pl_Brands.pl_BID = pl_join.pl_BID AND pl_join.pl_ID = pl_companies.pl_ID ORDER BY pl_companies.co_name ASC - Original Message - From: Mark Leder [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 06, 2002 10:10 AM Subject: Left Outer Join - Lotsa Pain! This query is being run on MSAccess 2002. I want to do a LEFT OUTER JOIN so that all company names are returned based on a product CATEGORY, even though they may not have a product BRAND associated with them. (I used a joining table, pl_join, because one company may have many brands; the pl_joincatbrand table is used as a joining table because one brand may belong to many categories). The query statement below works properly, but will not bring back company names that do not have a brand. I've tried a number of ways to do a LOJ in the FROM statement, but I can't get it to work where there are more than two tables involved. (ie, FROM pl_companies LEFT OUTER JOIN pl_join ON pl_companies.pl_ID = pl_join.pl_ID) Your help is greatly appreciated, as my head is getting really sore banging it on the desk for the past 7 hours trying to get this to work right. Mark SELECT * FROM pl_category, pl_join, pl_companies, pl_joincatbrand, pl_brands WHERE pl_category.prl_cat_ID = #FORM.prl_cat_ID# AND pl_category.prl_cat_ID = pl_joincatbrand.prl_cat_ID AND pl_Brands.pl_BID = pl_joincatbrand.pl_BID AND pl_Brands.pl_BID = pl_join.pl_BID AND pl_join.pl_ID = pl_companies.pl_ID ORDER BY pl_companies.co_name ASC Thanks, Mark __ 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: Query Tool Set (was: Left Outer Join - Lotsa Pain!)
You can use MSQuery. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 12:48 PM To: CF-Talk Subject: Query Tool Set (was: Left Outer Join - Lotsa Pain!) I'd love to use a Query tool - but I think the MS Access tool is tough to work with. Drawing lines and connectors is easy enough, but editing row attributes I think is counterintuitive. I can't seem to get rid of a row if I make a mistake unless I start over entirely - can't seem to delete a row. Anyone have any suggestions on other Query Builder tools that they like? I'd like to use the one included with CF 5, but every time I run a query, it crashes my machine and eats all the memory. Thanks, Mark -Original Message- From: Margaret Fisk [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 12:47 PM To: CF-Talk Subject: RE: Left Outer Join - Lotsa Pain! The easiest way to get the Access SQL is to construct the statement in the Access GUI. Then you can test out your query as well. -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 9:47 AM To: CF-Talk Subject: RE: Left Outer Join - Lotsa Pain! So how would I write it for Access? Would I still use the WHERE statement? It's the syntax for Access that really throws me for a loop! FROM pl_companies LEFT OUTER JOIN (pl_category, pl_join, pl_joincatbrand, pl_brands) Thanks, Mark -Original Message- From: Dina Hess [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 12:13 PM To: CF-Talk Subject: Re: Left Outer Join - Lotsa Pain! mark, try using left outer join to join *all* of your tables, starting with pl_companies and ending with pl_brands. ~ dina WHERE pl_category.prl_cat_ID = #FORM.prl_cat_ID# AND pl_category.prl_cat_ID = pl_joincatbrand.prl_cat_ID AND pl_Brands.pl_BID = pl_joincatbrand.pl_BID AND pl_Brands.pl_BID = pl_join.pl_BID AND pl_join.pl_ID = pl_companies.pl_ID ORDER BY pl_companies.co_name ASC - Original Message - From: Mark Leder [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 06, 2002 10:10 AM Subject: Left Outer Join - Lotsa Pain! This query is being run on MSAccess 2002. I want to do a LEFT OUTER JOIN so that all company names are returned based on a product CATEGORY, even though they may not have a product BRAND associated with them. (I used a joining table, pl_join, because one company may have many brands; the pl_joincatbrand table is used as a joining table because one brand may belong to many categories). The query statement below works properly, but will not bring back company names that do not have a brand. I've tried a number of ways to do a LOJ in the FROM statement, but I can't get it to work where there are more than two tables involved. (ie, FROM pl_companies LEFT OUTER JOIN pl_join ON pl_companies.pl_ID = pl_join.pl_ID) Your help is greatly appreciated, as my head is getting really sore banging it on the desk for the past 7 hours trying to get this to work right. Mark SELECT * FROM pl_category, pl_join, pl_companies, pl_joincatbrand, pl_brands WHERE pl_category.prl_cat_ID = #FORM.prl_cat_ID# AND pl_category.prl_cat_ID = pl_joincatbrand.prl_cat_ID AND pl_Brands.pl_BID = pl_joincatbrand.pl_BID AND pl_Brands.pl_BID = pl_join.pl_BID AND pl_join.pl_ID = pl_companies.pl_ID ORDER BY pl_companies.co_name ASC Thanks, Mark __ 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: Website Error
Is it possible that someone used the name of SESSION.someVar for another variable? If that's the case, it might not evaluate to a boolean. Eric -Original Message- From: Bruce Holm [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 1:48 PM To: CF-Talk Subject: Website Error Over the weekend we got the following email msg generated thousands of times by our CF Server. We have errors that are generated on the CF server (as part of the site error handling) send an email to the webmaster. We have never seen this error before. It makes no sense. We have no clue what the problem is. The code it refers to has been working fine for months and months. Then on a Sat. after noon, out of the blue, it triggers and virtually every visitor to our site generated this error...actually it doesn't appear to be an error. It didn't impede their ability to navigate the site. Just generated emails. It's a simple CFELSEIF Session.someVar conditional that it's tripping on. Earlier that session var is set by default to FALSE if not defined, in a CFPARAM statement. We bounced the CF server this morning and after a few minutes of additional errors, they have now stopped (as if a queue emptied or something). Has anyone else had this happen or have a clue what would cause this? We are running CF Server 5 - Sample Message - Diagnostics: InsideText Cannot convert to boolean.Please, check the ColdFusion manual for the allowed conversions between data typesThe error occurred while processing an element with a general identifier of (CFELSEIF), occupying document position (124:2) to (124:31). Template: /webtest/latticesemi/web/account/login.cfm Query String: Date/Time: Mon May 06 09:19:30 2002 Referer: http://www.latticesemi.com/account/login.cfm Remote Address: 193.135.247.66 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Whats the Deal with XML?
I've read it all, seen it in action, heard how great it is but I don't get it? Why is XML so great? What is it going to enable us to do that we can not now? To be honest, it seems like XML is just a fancy way to send comma delimited data? What can we do with xml that we can't do with CFHTTP and a comma delimited file? What am I missing here? Anything? Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Left Outer Join - Lotsa Pain!
mark the ansi syntax for the left outer join goes like something like this: FROM tablename w LEFT OUTER JOIN tablename e ON w.foreignkey = e.primarykey LEFT OUTER JOIN tablename s ON w.foreignkey = s.primarykey LEFT OUTER JOIN tablename a ON w.primarykey = a.foreignkey and margaret made a good point...best place to learn is in access query builder (design view). once you get in there, switch to sql view to see all. :) ~ dina - Original Message - From: Mark Leder [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 06, 2002 11:46 AM Subject: RE: Left Outer Join - Lotsa Pain! So how would I write it for Access? Would I still use the WHERE statement? It's the syntax for Access that really throws me for a loop! FROM pl_companies LEFT OUTER JOIN (pl_category, pl_join, pl_joincatbrand, pl_brands) Thanks, Mark -Original Message- From: Dina Hess [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 12:13 PM To: CF-Talk Subject: Re: Left Outer Join - Lotsa Pain! mark, try using left outer join to join *all* of your tables, starting with pl_companies and ending with pl_brands. ~ dina WHERE pl_category.prl_cat_ID = #FORM.prl_cat_ID# AND pl_category.prl_cat_ID = pl_joincatbrand.prl_cat_ID AND pl_Brands.pl_BID = pl_joincatbrand.pl_BID AND pl_Brands.pl_BID = pl_join.pl_BID AND pl_join.pl_ID = pl_companies.pl_ID ORDER BY pl_companies.co_name ASC - Original Message - From: Mark Leder [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 06, 2002 10:10 AM Subject: Left Outer Join - Lotsa Pain! This query is being run on MSAccess 2002. I want to do a LEFT OUTER JOIN so that all company names are returned based on a product CATEGORY, even though they may not have a product BRAND associated with them. (I used a joining table, pl_join, because one company may have many brands; the pl_joincatbrand table is used as a joining table because one brand may belong to many categories). The query statement below works properly, but will not bring back company names that do not have a brand. I've tried a number of ways to do a LOJ in the FROM statement, but I can't get it to work where there are more than two tables involved. (ie, FROM pl_companies LEFT OUTER JOIN pl_join ON pl_companies.pl_ID = pl_join.pl_ID) Your help is greatly appreciated, as my head is getting really sore banging it on the desk for the past 7 hours trying to get this to work right. Mark SELECT * FROM pl_category, pl_join, pl_companies, pl_joincatbrand, pl_brands WHERE pl_category.prl_cat_ID = #FORM.prl_cat_ID# AND pl_category.prl_cat_ID = pl_joincatbrand.prl_cat_ID AND pl_Brands.pl_BID = pl_joincatbrand.pl_BID AND pl_Brands.pl_BID = pl_join.pl_BID AND pl_join.pl_ID = pl_companies.pl_ID ORDER BY pl_companies.co_name ASC Thanks, Mark __ 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: Website Error
Bruce: I see this from time to time in similar circumstances and I usually find that the value of the variable that I was attempting to catch with the CFPARAM was set to NULL. I was expecting to trap for an undefined variable, but the variable was defined--as a NULL. For example, in your case the Session.someVar was set as a NULL and the CFPARAM default didn't fire because the var does exist but the value is NULL, which cannot be evaulated as boolean. Try dumping the vars to see what's really there. Just a thought, Chris Lofback Sr. Web Developer TRX Integration 28051 US 19 N., Ste. C Clearwater, FL 33761 www.trxi.com -Original Message- From: Bruce Holm [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 1:48 PM To: CF-Talk Subject: Website Error Over the weekend we got the following email msg generated thousands of times by our CF Server. We have errors that are generated on the CF server (as part of the site error handling) send an email to the webmaster. We have never seen this error before. It makes no sense. We have no clue what the problem is. The code it refers to has been working fine for months and months. Then on a Sat. after noon, out of the blue, it triggers and virtually every visitor to our site generated this error...actually it doesn't appear to be an error. It didn't impede their ability to navigate the site. Just generated emails. It's a simple CFELSEIF Session.someVar conditional that it's tripping on. Earlier that session var is set by default to FALSE if not defined, in a CFPARAM statement. We bounced the CF server this morning and after a few minutes of additional errors, they have now stopped (as if a queue emptied or something). Has anyone else had this happen or have a clue what would cause this? We are running CF Server 5 - Sample Message - Diagnostics: InsideText Cannot convert to boolean.Please, check the ColdFusion manual for the allowed conversions between data typesThe error occurred while processing an element with a general identifier of (CFELSEIF), occupying document position (124:2) to (124:31). Template: /webtest/latticesemi/web/account/login.cfm Query String: Date/Time: Mon May 06 09:19:30 2002 Referer: http://www.latticesemi.com/account/login.cfm Remote Address: 193.135.247.66 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) __ 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: Whats the Deal with XML?
There's tonnes of information in the cf-talk history about this topic... Xml is way more structured than a comma delimited file. It deals with things in a hierarchical view of its properties. Xml is a specification. What you do with it is endless... You can format it using xsl or css. You can use it as a data source between two sites. Using soap, you can use remote objects like they're your own. This should replace complicated RPCs. Using dtd, you can define an unlimited amount of specs such as WML, HDML, VRML, MathML, HRML, XHTML, etc. These languages are all subsets of XML and are defined through DTD or XMLSchema, which ironically XMLSchema is itself an XML based language. DTD is it's own language, and it's the most standard for defining XML documents. This just scratches the surface. Look through the archives for all the different discussions on xml already. There is a plethora of information there... -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 10:53 AM To: CF-Talk Subject: OT: Whats the Deal with XML? I've read it all, seen it in action, heard how great it is but I don't get it? Why is XML so great? What is it going to enable us to do that we can not now? To be honest, it seems like XML is just a fancy way to send comma delimited data? What can we do with xml that we can't do with CFHTTP and a comma delimited file? What am I missing here? Anything? Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] __ 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: Macromedia Folks: What are you thinking?
I hate to be a Me too but, (not bashing, just IMHO) I don't like defining sites, I avoid it whenever possible. I have 79 active sites (more every week) that my Company manages on our local development server. To define each site would take me and each of my staff at least and 1/2 - 1 hour for each person to define the 79 of them. I have other mindless things to do with my time. :-) Mark W. Breneman -Macromedia Certified ColdFusion 5 Developer -Network / Web Server Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 11:22 AM To: CF-Talk Subject: RE: Macromedia Folks: What are you thinking? At 10:17 AM 5/6/2002 -0600, you wrote: I don't work with RDS or FTP, but I've already determined that I'll be sticking with CF Studio 4.5.2 for the web app I'm developing. Simply because I don't like the idea of building a SITE in DWMX so I can work with my files (yes, I know I can edit my files without a site, but you loose some of the functionality of DW if you don't create a site - such as dynamic content - unless you manually code everything.) I don't like the ideas of these extra files floating around my web directories. When I build an app, the files within my app folder(s) are files required by the app. This site file serves no purpose when I deliver my site, and becomes an extra step to remember if I don't want to transfer that file to my live site. I agree with you. That is my biggest bite about Dreamweaver sites. At least they aren't as bad as Frontpage, though, right? Do those extra folders transfer if you the Dreamweaver synchronize functionality? -- Jeffry Houser | mailto:[EMAIL PROTECTED] Need a Web Developer? Contact me! AIM: Reboog711 | Fax / Phone: 860-223-7946 -- My Books: http://www.instantcoldfusion.com My Band: http://www.farcryfly.com -- Will I be on the streets tomorrow, Will I have to beg and Borrow Will I have to go back to the job I left behind? __ 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: PayFlow
IME, Payflow is so easy to use you really don't need a tag! I've been using it for two years now with no problems. - Original Message - From: Sean Daniels [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 06, 2002 12:05 PM Subject: PayFlow I've seen reference to a CFX_PFPRO tag but can't find out how to go about getting it? Is it something you buy from Verisign when you sign up for Payflow? Thanks, - Sean ~~ Sean Daniels Director, Engineering Marketplace Technologies, Inc (T): 207.363.7374 (C): 207.332.6340 (F): 240.269.6319 ~~ http://www.dealforce.com http://www.mergernetwork.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: Query Tool Set (was: Left Outer Join - Lotsa Pain!)
Uh... Sort of... I can't remember, but MS Query seems to put out sql in an ansi-92 style... Joins in the where clause instead of the from clause... It may work with ODBC well, but it looks terrible... Honestly, MS Access has the best query designer out there... You could always write them by hand like most people do... I may sound stupid here, but what on earth is a row attribute in terms of a query? -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 10:51 AM To: CF-Talk Subject: RE: Query Tool Set (was: Left Outer Join - Lotsa Pain!) You can use MSQuery. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 12:48 PM To: CF-Talk Subject: Query Tool Set (was: Left Outer Join - Lotsa Pain!) I'd love to use a Query tool - but I think the MS Access tool is tough to work with. Drawing lines and connectors is easy enough, but editing row attributes I think is counterintuitive. I can't seem to get rid of a row if I make a mistake unless I start over entirely - can't seem to delete a row. Anyone have any suggestions on other Query Builder tools that they like? I'd like to use the one included with CF 5, but every time I run a query, it crashes my machine and eats all the memory. Thanks, Mark -Original Message- From: Margaret Fisk [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 12:47 PM To: CF-Talk Subject: RE: Left Outer Join - Lotsa Pain! The easiest way to get the Access SQL is to construct the statement in the Access GUI. Then you can test out your query as well. -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 9:47 AM To: CF-Talk Subject: RE: Left Outer Join - Lotsa Pain! So how would I write it for Access? Would I still use the WHERE statement? It's the syntax for Access that really throws me for a loop! FROM pl_companies LEFT OUTER JOIN (pl_category, pl_join, pl_joincatbrand, pl_brands) Thanks, Mark -Original Message- From: Dina Hess [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 12:13 PM To: CF-Talk Subject: Re: Left Outer Join - Lotsa Pain! mark, try using left outer join to join *all* of your tables, starting with pl_companies and ending with pl_brands. ~ dina WHERE pl_category.prl_cat_ID = #FORM.prl_cat_ID# AND pl_category.prl_cat_ID = pl_joincatbrand.prl_cat_ID AND pl_Brands.pl_BID = pl_joincatbrand.pl_BID AND pl_Brands.pl_BID = pl_join.pl_BID AND pl_join.pl_ID = pl_companies.pl_ID ORDER BY pl_companies.co_name ASC - Original Message - From: Mark Leder [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 06, 2002 10:10 AM Subject: Left Outer Join - Lotsa Pain! This query is being run on MSAccess 2002. I want to do a LEFT OUTER JOIN so that all company names are returned based on a product CATEGORY, even though they may not have a product BRAND associated with them. (I used a joining table, pl_join, because one company may have many brands; the pl_joincatbrand table is used as a joining table because one brand may belong to many categories). The query statement below works properly, but will not bring back company names that do not have a brand. I've tried a number of ways to do a LOJ in the FROM statement, but I can't get it to work where there are more than two tables involved. (ie, FROM pl_companies LEFT OUTER JOIN pl_join ON pl_companies.pl_ID = pl_join.pl_ID) Your help is greatly appreciated, as my head is getting really sore banging it on the desk for the past 7 hours trying to get this to work right. Mark SELECT * FROM pl_category, pl_join, pl_companies, pl_joincatbrand, pl_brands WHERE pl_category.prl_cat_ID = #FORM.prl_cat_ID# AND pl_category.prl_cat_ID = pl_joincatbrand.prl_cat_ID AND pl_Brands.pl_BID = pl_joincatbrand.pl_BID AND pl_Brands.pl_BID = pl_join.pl_BID AND pl_join.pl_ID = pl_companies.pl_ID ORDER BY pl_companies.co_name ASC Thanks, Mark __ 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: Whats the Deal with XML?
First of all XML is self documenting. That is huge in and of itself. However, comparing XML to CSV shows even more advantages. CSV only supports tabular data where as XML can support tabular data as well as data that is in more of a tree data structure. Generally speaking, objects in the programming world can be better represented as trees. -Matt -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 10:53 AM To: CF-Talk Subject: OT: Whats the Deal with XML? I've read it all, seen it in action, heard how great it is but I don't get it? Why is XML so great? What is it going to enable us to do that we can not now? To be honest, it seems like XML is just a fancy way to send comma delimited data? What can we do with xml that we can't do with CFHTTP and a comma delimited file? What am I missing here? Anything? Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [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
Linkpoint API
Anyone here ever used the Linkpoint API? Any feedback on Linkpoint's services? I have a client who might want to use them but, he would like some feedback first. Any comments/suggestions appreciated. Thank you, Joseph DeVore VeloxWeb Technologies __ 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: Adding MIME types
Hi, Presently I have a .bat file which runs to add mime types into the registry. I have included my .reg file below. Is there a way to have CF add these mimetypes rather than have approximately 50-100 users run this batch file on their PCs? addmimes.bat - @echo off reg import mimetypes.reg mimetypes.reg - Windows Registry Editor Version 5.00 [HKEY_CLASSES_ROOT\.dat] @=UltraEdit.dat Content Type=text/dat Perceived Type=text [HKEY_CLASSES_ROOT\.dat\PersistentHandler] @={eec97550-47a9-11cf-b952-00aa0051fe20} [HKEY_CLASSES_ROOT\MIME\Database\Content Type\text/dat] Extension=.dat [HKEY_CLASSES_ROOT\UltraEdit.dat] @=Text Document Old Default=DatObject [HKEY_CLASSES_ROOT\UltraEdit.dat\shell] [HKEY_CLASSES_ROOT\UltraEdit.dat\shell\open] [HKEY_CLASSES_ROOT\UltraEdit.dat\shell\open\command] @=\C:\\Program Files\\UltraEdit\\UEDIT32.EXE\ \%1\ [HKEY_CLASSES_ROOT\UltraEdit.dat\shell\open\ddeexec] @=[open(\%1\)] [HKEY_CLASSES_ROOT\UltraEdit.dat\shell\open\ddeexec\Application] @=UEDIT32 [HKEY_CLASSES_ROOT\UltraEdit.dat\shell\open\ddeexec\topic] @=System [HKEY_CLASSES_ROOT\UltraEdit.dat\shell\print] [HKEY_CLASSES_ROOT\UltraEdit.dat\shell\print\command] @=\C:\\Program Files\\UltraEdit\\UEDIT32.EXE\ /p \%1\ [HKEY_CLASSES_ROOT\UltraEdit.dat\shell\print\ddeexec] @=[print(\%1\)] [HKEY_CLASSES_ROOT\UltraEdit.dat\shell\print\ddeexec\Application] @=UEDIT32 [HKEY_CLASSES_ROOT\UltraEdit.dat\shell\print\ddeexec\topic] @=System +---+ Philip Humeniuk [EMAIL PROTECTED] [EMAIL PROTECTED] ++ __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Left Outer Join - Lotsa Pain!
Yes, but that's the ansi syntax, but MS Access isn't an ANSI compliant database. Although it's close, AFAIK there are limitations on outer joins in access that aren't there in sql server. If you want more than one, you have to build extra queries and join those in. -Original Message- From: Dina Hess [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 10:52 AM To: CF-Talk Subject: Re: Left Outer Join - Lotsa Pain! mark the ansi syntax for the left outer join goes like something like this: FROM tablename w LEFT OUTER JOIN tablename e ON w.foreignkey = e.primarykey LEFT OUTER JOIN tablename s ON w.foreignkey = s.primarykey LEFT OUTER JOIN tablename a ON w.primarykey = a.foreignkey and margaret made a good point...best place to learn is in access query builder (design view). once you get in there, switch to sql view to see all. :) ~ dina - Original Message - From: Mark Leder [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 06, 2002 11:46 AM Subject: RE: Left Outer Join - Lotsa Pain! So how would I write it for Access? Would I still use the WHERE statement? It's the syntax for Access that really throws me for a loop! FROM pl_companies LEFT OUTER JOIN (pl_category, pl_join, pl_joincatbrand, pl_brands) Thanks, Mark -Original Message- From: Dina Hess [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 12:13 PM To: CF-Talk Subject: Re: Left Outer Join - Lotsa Pain! mark, try using left outer join to join *all* of your tables, starting with pl_companies and ending with pl_brands. ~ dina WHERE pl_category.prl_cat_ID = #FORM.prl_cat_ID# AND pl_category.prl_cat_ID = pl_joincatbrand.prl_cat_ID AND pl_Brands.pl_BID = pl_joincatbrand.pl_BID AND pl_Brands.pl_BID = pl_join.pl_BID AND pl_join.pl_ID = pl_companies.pl_ID ORDER BY pl_companies.co_name ASC - Original Message - From: Mark Leder [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 06, 2002 10:10 AM Subject: Left Outer Join - Lotsa Pain! This query is being run on MSAccess 2002. I want to do a LEFT OUTER JOIN so that all company names are returned based on a product CATEGORY, even though they may not have a product BRAND associated with them. (I used a joining table, pl_join, because one company may have many brands; the pl_joincatbrand table is used as a joining table because one brand may belong to many categories). The query statement below works properly, but will not bring back company names that do not have a brand. I've tried a number of ways to do a LOJ in the FROM statement, but I can't get it to work where there are more than two tables involved. (ie, FROM pl_companies LEFT OUTER JOIN pl_join ON pl_companies.pl_ID = pl_join.pl_ID) Your help is greatly appreciated, as my head is getting really sore banging it on the desk for the past 7 hours trying to get this to work right. Mark SELECT * FROM pl_category, pl_join, pl_companies, pl_joincatbrand, pl_brands WHERE pl_category.prl_cat_ID = #FORM.prl_cat_ID# AND pl_category.prl_cat_ID = pl_joincatbrand.prl_cat_ID AND pl_Brands.pl_BID = pl_joincatbrand.pl_BID AND pl_Brands.pl_BID = pl_join.pl_BID AND pl_join.pl_ID = pl_companies.pl_ID ORDER BY pl_companies.co_name ASC Thanks, Mark __ 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: Looping to find [brackets]
Yes, that is exactly the place to use rereplace. remember that square brackets are special chars in regex, so you need to escape them. Jerry Johnson [EMAIL PROTECTED] 05/06/02 12:30PM Hi, I need to loop through a large amount of text - which might contain HTML - to find numbers surrounded by square brackets (i.e. [n]). Once found, I need to alter it into something like this: a href=here.cfm?v=nview/a (where n is a number). There will be about 30 square-bracketed numbers like this. Does anyone have any advice how to tackle this - is this is a time for rereplace? Cheers Will --- Become a Pingographer and share your photos for free: http://www.localbounty.com/pingo __ 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: Adding MIME types
AFAIK, you'd have to build an ActiveX control to do that. I'd personally be really pissed if I went to a web site that modified my registry without my permission. It'd be a pretty big security hole in IE/Netscape if that was allowed. Imagine the damage you could do... The only other way I could think is to instruct the user to download the reg file and execute it themselves from your site. -Original Message- From: phumes1 [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 11:11 AM To: CF-Talk Subject: Re: Adding MIME types Hi, Presently I have a .bat file which runs to add mime types into the registry. I have included my .reg file below. Is there a way to have CF add these mimetypes rather than have approximately 50-100 users run this batch file on their PCs? addmimes.bat - @echo off reg import mimetypes.reg mimetypes.reg - Windows Registry Editor Version 5.00 [HKEY_CLASSES_ROOT\.dat] @=UltraEdit.dat Content Type=text/dat Perceived Type=text [HKEY_CLASSES_ROOT\.dat\PersistentHandler] @={eec97550-47a9-11cf-b952-00aa0051fe20} [HKEY_CLASSES_ROOT\MIME\Database\Content Type\text/dat] Extension=.dat [HKEY_CLASSES_ROOT\UltraEdit.dat] @=Text Document Old Default=DatObject [HKEY_CLASSES_ROOT\UltraEdit.dat\shell] [HKEY_CLASSES_ROOT\UltraEdit.dat\shell\open] [HKEY_CLASSES_ROOT\UltraEdit.dat\shell\open\command] @=\C:\\Program Files\\UltraEdit\\UEDIT32.EXE\ \%1\ [HKEY_CLASSES_ROOT\UltraEdit.dat\shell\open\ddeexec] @=[open(\%1\)] [HKEY_CLASSES_ROOT\UltraEdit.dat\shell\open\ddeexec\Application] @=UEDIT32 [HKEY_CLASSES_ROOT\UltraEdit.dat\shell\open\ddeexec\topic] @=System [HKEY_CLASSES_ROOT\UltraEdit.dat\shell\print] [HKEY_CLASSES_ROOT\UltraEdit.dat\shell\print\command] @=\C:\\Program Files\\UltraEdit\\UEDIT32.EXE\ /p \%1\ [HKEY_CLASSES_ROOT\UltraEdit.dat\shell\print\ddeexec] @=[print(\%1\)] [HKEY_CLASSES_ROOT\UltraEdit.dat\shell\print\ddeexec\Application] @=UEDIT32 [HKEY_CLASSES_ROOT\UltraEdit.dat\shell\print\ddeexec\topic] @=System +--- + Philip Humeniuk [EMAIL PROTECTED] [EMAIL PROTECTED] +--- -+ __ 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: Linkpoint API
I've used it a bit. Are you going to use the ColdFusion app they've built, or just the simple HTML version? They also have Java and XML code you can use. -Kevin -Original Message- From: Joseph DeVore [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 2:11 PM To: CF-Talk Subject: Linkpoint API Anyone here ever used the Linkpoint API? Any feedback on Linkpoint's services? I have a client who might want to use them but, he would like some feedback first. Any comments/suggestions appreciated. Thank you, Joseph DeVore VeloxWeb Technologies __ 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
CFEXECUTE
Anyone have an idea what this means when using CFEXECUTE? waitpid() returned the error: No child processes (10) Randy Adkins __ 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: Linkpoint API
They would be using the CFX tag. -Original Message- From: Kevin Langevin [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 11:11 AM To: CF-Talk Subject: RE: Linkpoint API I've used it a bit. Are you going to use the ColdFusion app they've built, or just the simple HTML version? They also have Java and XML code you can use. -Kevin -Original Message- From: Joseph DeVore [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 2:11 PM To: CF-Talk Subject: Linkpoint API Anyone here ever used the Linkpoint API? Any feedback on Linkpoint's services? I have a client who might want to use them but, he would like some feedback first. Any comments/suggestions appreciated. Thank you, Joseph DeVore VeloxWeb Technologies __ 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
OT: transact-sql datediff function
hi all, i posted this on the sql list but got no response. i have a test table named employees with the following fields: fname varchar lname varchar hire_date datetime the record i'm querying contains 2001-05-11 00:00:00.000 in the hire_date field. but this query returns 1 rather than the expected 0: select datediff(yy, hire_date, getdate()) as yearsdiff from employees where fname = 'ann' this should give me the number of years between 5/11/2001 and today's date of 5/6/2002, which should be 0 since it's not 5/11 yet. so why am i getting 1??? ~ dina __ 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
Application Variables
Hey all, I want to use application variables for a site, but one question comes to mind. I have all my app variables set in one template. Upon configuring the template, I hit that template to set all variables (makes sense). Now, while my application is in use, I check (in Application.cfm) to see if one of the vars is defined. If not, I cfinclude the config template. If (given the slim chance) the app variables time out, is there anyway to reset them other than having an CFIF statement check on every page hit? I know the overhead is really low, but just based on the ideas of the app vars, i thought maybe there was a better way. Let me know if I'm being wy too picky about this. thanks. - j __ 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: Left Outer Join - Lotsa Pain!
hmmmyou may have a point there. going away to test it :) ~ dina - Original Message - From: Costas Piliotis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 06, 2002 1:09 PM Subject: RE: Left Outer Join - Lotsa Pain! Yes, but that's the ansi syntax, but MS Access isn't an ANSI compliant database. Although it's close, AFAIK there are limitations on outer joins in access that aren't there in sql server. If you want more than one, you have to build extra queries and join those in. -Original Message- From: Dina Hess [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 10:52 AM To: CF-Talk Subject: Re: Left Outer Join - Lotsa Pain! mark the ansi syntax for the left outer join goes like something like this: FROM tablename w LEFT OUTER JOIN tablename e ON w.foreignkey = e.primarykey LEFT OUTER JOIN tablename s ON w.foreignkey = s.primarykey LEFT OUTER JOIN tablename a ON w.primarykey = a.foreignkey and margaret made a good point...best place to learn is in access query builder (design view). once you get in there, switch to sql view to see all. :) ~ dina - Original Message - From: Mark Leder [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 06, 2002 11:46 AM Subject: RE: Left Outer Join - Lotsa Pain! So how would I write it for Access? Would I still use the WHERE statement? It's the syntax for Access that really throws me for a loop! FROM pl_companies LEFT OUTER JOIN (pl_category, pl_join, pl_joincatbrand, pl_brands) Thanks, Mark -Original Message- From: Dina Hess [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 12:13 PM To: CF-Talk Subject: Re: Left Outer Join - Lotsa Pain! mark, try using left outer join to join *all* of your tables, starting with pl_companies and ending with pl_brands. ~ dina WHERE pl_category.prl_cat_ID = #FORM.prl_cat_ID# AND pl_category.prl_cat_ID = pl_joincatbrand.prl_cat_ID AND pl_Brands.pl_BID = pl_joincatbrand.pl_BID AND pl_Brands.pl_BID = pl_join.pl_BID AND pl_join.pl_ID = pl_companies.pl_ID ORDER BY pl_companies.co_name ASC - Original Message - From: Mark Leder [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 06, 2002 10:10 AM Subject: Left Outer Join - Lotsa Pain! This query is being run on MSAccess 2002. I want to do a LEFT OUTER JOIN so that all company names are returned based on a product CATEGORY, even though they may not have a product BRAND associated with them. (I used a joining table, pl_join, because one company may have many brands; the pl_joincatbrand table is used as a joining table because one brand may belong to many categories). The query statement below works properly, but will not bring back company names that do not have a brand. I've tried a number of ways to do a LOJ in the FROM statement, but I can't get it to work where there are more than two tables involved. (ie, FROM pl_companies LEFT OUTER JOIN pl_join ON pl_companies.pl_ID = pl_join.pl_ID) Your help is greatly appreciated, as my head is getting really sore banging it on the desk for the past 7 hours trying to get this to work right. Mark SELECT * FROM pl_category, pl_join, pl_companies, pl_joincatbrand, pl_brands WHERE pl_category.prl_cat_ID = #FORM.prl_cat_ID# AND pl_category.prl_cat_ID = pl_joincatbrand.prl_cat_ID AND pl_Brands.pl_BID = pl_joincatbrand.pl_BID AND pl_Brands.pl_BID = pl_join.pl_BID AND pl_join.pl_ID = pl_companies.pl_ID ORDER BY pl_companies.co_name ASC Thanks, Mark __ 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: Whats the Deal with XML?
I am with you Kris. Yeah, and what can we do with all this new stuff that we can't do with assembly. On Mon, 6 May 2002, Kris Pilles wrote: I've read it all, seen it in action, heard how great it is but I don't get it? Why is XML so great? What is it going to enable us to do that we can not now? To be honest, it seems like XML is just a fancy way to send comma delimited data? What can we do with xml that we can't do with CFHTTP and a comma delimited file? What am I missing here? Anything? Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [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: Linkpoint API
On 5/6/02 2:23 PM Joseph DeVore wrote: They would be using the CFX tag. I've used it for three different clients at this point. The way they have the CF tag set up isn't exactly the way I would do it, but it works fine and service wise I've not had any issues. Seems pretty fast to authorize as well. - Sean ~~ Sean Daniels Director, Engineering Marketplace Technologies, Inc (T): 207.363.7374 (C): 207.332.6340 (F): 240.269.6319 ~~ http://www.dealforce.com http://www.mergernetwork.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: Adding MIME types
At 11:11 AM 5/6/2002 -0700, you wrote: AFAIK, you'd have to build an ActiveX control to do that. I'd personally be really pissed if I went to a web site that modified my registry without my permission. It'd be a pretty big security hole in IE/Netscape if that was allowed. Imagine the damage you could do... Its strickly intranet. The only other way I could think is to instruct the user to download the reg file and execute it themselves from your site. -Original Message- From: phumes1 [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 11:11 AM To: CF-Talk Subject: Re: Adding MIME types Hi, Presently I have a .bat file which runs to add mime types into the registry. I have included my .reg file below. Is there a way to have CF add these mimetypes rather than have approximately 50-100 users run this batch file on their PCs? addmimes.bat - @echo off reg import mimetypes.reg mimetypes.reg - Windows Registry Editor Version 5.00 [HKEY_CLASSES_ROOT\.dat] @=UltraEdit.dat Content Type=text/dat Perceived Type=text [HKEY_CLASSES_ROOT\.dat\PersistentHandler] @={eec97550-47a9-11cf-b952-00aa0051fe20} [HKEY_CLASSES_ROOT\MIME\Database\Content Type\text/dat] Extension=.dat [HKEY_CLASSES_ROOT\UltraEdit.dat] @=Text Document Old Default=DatObject [HKEY_CLASSES_ROOT\UltraEdit.dat\shell] [HKEY_CLASSES_ROOT\UltraEdit.dat\shell\open] [HKEY_CLASSES_ROOT\UltraEdit.dat\shell\open\command] @=\C:\\Program Files\\UltraEdit\\UEDIT32.EXE\ \%1\ [HKEY_CLASSES_ROOT\UltraEdit.dat\shell\open\ddeexec] @=[open(\%1\)] [HKEY_CLASSES_ROOT\UltraEdit.dat\shell\open\ddeexec\Application] @=UEDIT32 [HKEY_CLASSES_ROOT\UltraEdit.dat\shell\open\ddeexec\topic] @=System [HKEY_CLASSES_ROOT\UltraEdit.dat\shell\print] [HKEY_CLASSES_ROOT\UltraEdit.dat\shell\print\command] @=\C:\\Program Files\\UltraEdit\\UEDIT32.EXE\ /p \%1\ [HKEY_CLASSES_ROOT\UltraEdit.dat\shell\print\ddeexec] @=[print(\%1\)] [HKEY_CLASSES_ROOT\UltraEdit.dat\shell\print\ddeexec\Application] @=UEDIT32 [HKEY_CLASSES_ROOT\UltraEdit.dat\shell\print\ddeexec\topic] @=System +--- + Philip Humeniuk [EMAIL PROTECTED] [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: Left Outer Join - Lotsa Pain!
ok, here's what i found in an access db: FROM Suppliers LEFT JOIN (Mfrs LEFT JOIN (Departments LEFT JOIN Products ON Departments.DepartmentID = Products.DepartmentID) ON Mfrs.MfrID = Products.MfrID) ON Suppliers.SupplierID = Products.SupplierID no wonder you're having problems, mark. :) ~ dina - Original Message - From: Costas Piliotis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 06, 2002 1:09 PM Subject: RE: Left Outer Join - Lotsa Pain! Yes, but that's the ansi syntax, but MS Access isn't an ANSI compliant database. Although it's close, AFAIK there are limitations on outer joins in access that aren't there in sql server. If you want more than one, you have to build extra queries and join those in. -Original Message- From: Dina Hess [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 10:52 AM To: CF-Talk Subject: Re: Left Outer Join - Lotsa Pain! mark the ansi syntax for the left outer join goes like something like this: FROM tablename w LEFT OUTER JOIN tablename e ON w.foreignkey = e.primarykey LEFT OUTER JOIN tablename s ON w.foreignkey = s.primarykey LEFT OUTER JOIN tablename a ON w.primarykey = a.foreignkey and margaret made a good point...best place to learn is in access query builder (design view). once you get in there, switch to sql view to see all. :) ~ dina - Original Message - From: Mark Leder [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 06, 2002 11:46 AM Subject: RE: Left Outer Join - Lotsa Pain! So how would I write it for Access? Would I still use the WHERE statement? It's the syntax for Access that really throws me for a loop! FROM pl_companies LEFT OUTER JOIN (pl_category, pl_join, pl_joincatbrand, pl_brands) Thanks, Mark -Original Message- From: Dina Hess [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 12:13 PM To: CF-Talk Subject: Re: Left Outer Join - Lotsa Pain! mark, try using left outer join to join *all* of your tables, starting with pl_companies and ending with pl_brands. ~ dina WHERE pl_category.prl_cat_ID = #FORM.prl_cat_ID# AND pl_category.prl_cat_ID = pl_joincatbrand.prl_cat_ID AND pl_Brands.pl_BID = pl_joincatbrand.pl_BID AND pl_Brands.pl_BID = pl_join.pl_BID AND pl_join.pl_ID = pl_companies.pl_ID ORDER BY pl_companies.co_name ASC - Original Message - From: Mark Leder [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 06, 2002 10:10 AM Subject: Left Outer Join - Lotsa Pain! This query is being run on MSAccess 2002. I want to do a LEFT OUTER JOIN so that all company names are returned based on a product CATEGORY, even though they may not have a product BRAND associated with them. (I used a joining table, pl_join, because one company may have many brands; the pl_joincatbrand table is used as a joining table because one brand may belong to many categories). The query statement below works properly, but will not bring back company names that do not have a brand. I've tried a number of ways to do a LOJ in the FROM statement, but I can't get it to work where there are more than two tables involved. (ie, FROM pl_companies LEFT OUTER JOIN pl_join ON pl_companies.pl_ID = pl_join.pl_ID) Your help is greatly appreciated, as my head is getting really sore banging it on the desk for the past 7 hours trying to get this to work right. Mark SELECT * FROM pl_category, pl_join, pl_companies, pl_joincatbrand, pl_brands WHERE pl_category.prl_cat_ID = #FORM.prl_cat_ID# AND pl_category.prl_cat_ID = pl_joincatbrand.prl_cat_ID AND pl_Brands.pl_BID = pl_joincatbrand.pl_BID AND pl_Brands.pl_BID = pl_join.pl_BID AND pl_join.pl_ID = pl_companies.pl_ID ORDER BY pl_companies.co_name ASC Thanks, Mark __ 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: Looping to find [brackets]
Jerry, I'm really stumped as to where to start - could you give me a starter or clue? Thanks Will - Original Message - From: Jerry Johnson [EMAIL PROTECTED] Newsgroups: cf-talk Sent: Monday, May 06, 2002 7:16 PM Subject: Re: Looping to find [brackets] Yes, that is exactly the place to use rereplace. remember that square brackets are special chars in regex, so you need to escape them. Jerry Johnson [EMAIL PROTECTED] 05/06/02 12:30PM Hi, I need to loop through a large amount of text - which might contain HTML - to find numbers surrounded by square brackets (i.e. [n]). Once found, I need to alter it into something like this: a href=here.cfm?v=nview/a (where n is a number). There will be about 30 square-bracketed numbers like this. Does anyone have any advice how to tackle this - is this is a time for rereplace? Cheers Will --- Become a Pingographer and share your photos for free: http://www.localbounty.com/pingo __ 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: Whats the Deal with XML?
I am with you Kris. Yeah, and what can we do with all this new stuff that we can't do with assembly. Have a life outside of programming. -Matt __ 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: Re[2]: Macromedia Folks: What are you thinking?
/me thought that's why they included homesite+ *grinz* Yeah, it's hilarious alright. The whole Homesite+ thing begs the question: Why roll all that Homesite/Studio functionality into Dreamweaver if we're still going to have to switch applications to do basic, day-to-day, line-to-line tasks? Personally, I'm more likely to launch Homesite[+] and stick with it and only launch Dreamweaver when I'm doing basic inital page layout. And if that's the case, I don't want Dreamweaver to be a huge resource-hogging program that's going to bog things down when I make the switch. I'm not saying Dreamweaver MX isn't a step in the right direction--it looks like a great product, and is a real advance in functionality for anyone accustomed to Dreamweaver Basic. But it's not there yet as a replacement for Studio, and that leaves us Studio-users in 5.0-land in the foreseeable future. -- Owen JM I certainly hope so ... DWMX has a lot of potential, but removing JM excellent functionality and replacing it with so-so FrontPage-like JM features certainly won't win any points with MY team. __ 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: Adding MIME types
If you take a look in the lower left hand corner when the open your intranet, and it shows that you are in the local intranet zone, there may be some extra functionality open to you to be able to do because the security settings in the browser are lower, however I can't see Microsoft leaving that security hole deliberately open. Linux people would have a hayday over that one... They already rant and rave about Microsoft products being insecure. -Original Message- From: phumes1 [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 11:34 AM To: CF-Talk Subject: RE: Adding MIME types At 11:11 AM 5/6/2002 -0700, you wrote: AFAIK, you'd have to build an ActiveX control to do that. I'd personally be really pissed if I went to a web site that modified my registry without my permission. It'd be a pretty big security hole in IE/Netscape if that was allowed. Imagine the damage you could do... Its strickly intranet. The only other way I could think is to instruct the user to download the reg file and execute it themselves from your site. -Original Message- From: phumes1 [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 11:11 AM To: CF-Talk Subject: Re: Adding MIME types Hi, Presently I have a .bat file which runs to add mime types into the registry. I have included my .reg file below. Is there a way to have CF add these mimetypes rather than have approximately 50-100 users run this batch file on their PCs? addmimes.bat - @echo off reg import mimetypes.reg mimetypes.reg - Windows Registry Editor Version 5.00 [HKEY_CLASSES_ROOT\.dat] @=UltraEdit.dat Content Type=text/dat Perceived Type=text [HKEY_CLASSES_ROOT\.dat\PersistentHandler] @={eec97550-47a9-11cf-b952-00aa0051fe20} [HKEY_CLASSES_ROOT\MIME\Database\Content Type\text/dat] Extension=.dat [HKEY_CLASSES_ROOT\UltraEdit.dat] @=Text Document Old Default=DatObject [HKEY_CLASSES_ROOT\UltraEdit.dat\shell] [HKEY_CLASSES_ROOT\UltraEdit.dat\shell\open] [HKEY_CLASSES_ROOT\UltraEdit.dat\shell\open\command] @=\C:\\Program Files\\UltraEdit\\UEDIT32.EXE\ \%1\ [HKEY_CLASSES_ROOT\UltraEdit.dat\shell\open\ddeexec] @=[open(\%1\)] [HKEY_CLASSES_ROOT\UltraEdit.dat\shell\open\ddeexec\Application] @=UEDIT32 [HKEY_CLASSES_ROOT\UltraEdit.dat\shell\open\ddeexec\topic] @=System [HKEY_CLASSES_ROOT\UltraEdit.dat\shell\print] [HKEY_CLASSES_ROOT\UltraEdit.dat\shell\print\command] @=\C:\\Program Files\\UltraEdit\\UEDIT32.EXE\ /p \%1\ [HKEY_CLASSES_ROOT\UltraEdit.dat\shell\print\ddeexec] @=[print(\%1\)] [HKEY_CLASSES_ROOT\UltraEdit.dat\shell\print\ddeexec\Application] @=UEDIT32 [HKEY_CLASSES_ROOT\UltraEdit.dat\shell\print\ddeexec\topic] @=System +-- +- + Philip Humeniuk [EMAIL PROTECTED] [EMAIL PROTECTED] +-- +- -+ __ 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: Whats the Deal with XML?
XML allows you to publish a page on your webiste (in XML instead of HTML) then allows others to grab that page (just like you would using CFHTTP) and use the contents of that page as a query. So, if you are a supplier, your customers can grab your pricing info at their own convenience, and integrate it into their decision making process. Dave - Original Message - From: Costas Piliotis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 06, 2002 2:02 PM Subject: RE: Whats the Deal with XML? There's tonnes of information in the cf-talk history about this topic... Xml is way more structured than a comma delimited file. It deals with things in a hierarchical view of its properties. Xml is a specification. What you do with it is endless... You can format it using xsl or css. You can use it as a data source between two sites. Using soap, you can use remote objects like they're your own. This should replace complicated RPCs. Using dtd, you can define an unlimited amount of specs such as WML, HDML, VRML, MathML, HRML, XHTML, etc. These languages are all subsets of XML and are defined through DTD or XMLSchema, which ironically XMLSchema is itself an XML based language. DTD is it's own language, and it's the most standard for defining XML documents. This just scratches the surface. Look through the archives for all the different discussions on xml already. There is a plethora of information there... -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 10:53 AM To: CF-Talk Subject: OT: Whats the Deal with XML? I've read it all, seen it in action, heard how great it is but I don't get it? Why is XML so great? What is it going to enable us to do that we can not now? To be honest, it seems like XML is just a fancy way to send comma delimited data? What can we do with xml that we can't do with CFHTTP and a comma delimited file? What am I missing here? Anything? Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] __ 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: Redirecting...
Hi again, I've set my MIME type to load the files in Ultraedit on the client from the server. cfset FileName = #ListLast(url.filename, \)# cfset DirPath = #Left(url.filename, Evaluate(Len(url.filename) - len(FileName) - 1))# cfset sr1 = #REReplaceNoCase(DirPath,\\,/,ALL)# cfset sr2 = #REReplaceNoCase(sr1,[A-Z]:,file:\\z:)# cfset myPath = #REReplaceNoCase(sr2,books/,)# Here is the output from the following variables: myPath = file:\\z:/deleteme FileName = test.dat Below is an anchor that when clicking opens the file in UltraEdit no problem. a href=#mypath#/#FileName#Open #FileName#/a How can I make this automatic without having the click on the link? This is a intranet application only. +---+ Philip Humeniuk [EMAIL PROTECTED] [EMAIL PROTECTED] ++ __ 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: storing files in DB
If you mean storing images/text files, etc. in blobs or large text fields; rather tha just storing the file path... it is generally a very bad idea. You gain a little convenience (referencing files) but pay a huge penalty in performance and db overhead. Dick On Monday, May 6, 2002, at 10:00 AM, Wajid Hussain wrote: Hi guys, has anybody come across writing/reading files to a db? any advice will be much appreciated. WAJ. __ 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