Multiple Form Submitters?
I have a multipart form that has to become multi-multi-part. ;-( Right now when I go from Step 1 to Step 2 with a submit button I do db stuff and then go to step 2. I'm implimenting "paging" links, and I need them to submit the form also, do db stuff and post back to the original fuseaction. (FB 3) And also need a button to submit the form and go to Step 3. What I'm trying to do is have a variable "done", and the paging links would have "done=N" and the submit button "done=Y". I'm not a javascripter, but here's what I've got: Here's my Paging link: And Here's my Submit button: My form's not even submitting. Help? ***Sterling Financial Investment Group, Inc. (SFIG) is a member of NASD/MSRB/NFA/SIPC. Email transmissions may be monitored. SFIG cannot accept orders to buy or sell via email. Please visit www.mysterling.com for more information.*** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Multiple Form Submitters?
Yeah, I have a hidden form field called "done". And I'm only worried about IE. I'm using 6.0 -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED]] Sent: Monday, November 18, 2002 12:29 PM To: CF-Talk Subject: RE: Multiple Form Submitters? Is it safe to assume that your form name is 'profile2' and you have a input type=hidden named 'done'? Also, what browsers are you testing this in, and is it failing in all of them, or just one (I've noticed differences in how Mozilla and IE6 treat names vs. ids). --Ben Doom Programmer & General Lackey Moonbow Software : -Original Message- : From: Luce, Greg [mailto:[EMAIL PROTECTED]] : Sent: Monday, November 18, 2002 12:11 PM : To: CF-Talk : Subject: Multiple Form Submitters? : : : I have a multipart form that has to become multi-multi-part. ;-( Right now : when I go from Step 1 to Step 2 with a submit button I do db : stuff and then : go to step 2. I'm implimenting "paging" links, and I need them to : submit the : form also, do db stuff and post back to the original fuseaction. : (FB 3) And : also need a button to submit the form and go to Step 3. : What I'm trying to do is have a variable "done", and the paging : links would : have "done=N" and the submit button "done=Y". I'm not a javascripter, but : here's what I've got: : : : <!-- : function done ( selecteddone ) : { : document.profile2.done.value = selecteddone ; : document.profile2.submit() ; : } : --> : : : Here's my Paging link: : : : And Here's my Submit button: : : : : My form's not even submitting. Help? : ***Sterling Financial Investment Group, Inc. (SFIG) is a member of : NASD/MSRB/NFA/SIPC. Email transmissions may be monitored. SFIG cannot : accept orders to buy or sell via email. Please visit www.mysterling.com for more information.*** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: CF SQL problem
Is this from a form where you select a new "status" for each of the employees? Maybe something like this: UPDATE Muster SET Emp_Status = #listgetat(form.Emp_Status,counter)# WHERE EmpID_Muster = #i# -Original Message- From: Kennerly, Rick H CIV [mailto:[EMAIL PROTECTED]] Sent: Monday, November 18, 2002 4:51 PM To: CF-Talk Subject: RE: CF SQL problem Thanks for the suggestion. I switched to a straight SQL statement, but still have two different lists coming in instead of a updating each record sequentially. I'm pretty new at CF but I think I've got a handle on doing these one at a time, but doing multiple record updates is apparently beyond me. I can't find a good example to puzzle through. The idea is to update employee status by departments (one button updates all the daily attendance records for a department--say, 25 or 30 people (records) per Update button.) According to CF Debug, the proper values (only 2 numbers per record) pass successfully from the form page to the action page. But they're passed as two separate lists instead of in pairs. The two values from the form are EmpID_Muster (which is the key, some people think this is a problem) and Emp_Status, which are also the names of the SQL db columns. On the Action Form I want to match records against EmpID_Muster and then UPDATE Emp_Status (a value between 1 and 9). I've tried several iterations of this code, but I'm just not getting it. Am I on the wrong track? Is there an easier way? a better way? here's the code I'm working with now: UPDATE Muster SET Emp_Status = #form.Emp_Status# WHERE EmpID_Muster = #form.EmpID_Muster# -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Monday, 18 November, 2002 09:29 To: CF-Talk Subject: RE: CF SQL problem cfupdate is passing the entire value form.empid_muster, not one value at a time. Simply dump the cfupdate and switch to a real SQL insert. === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] WWW : www.camdenfamily.com/morpheus Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -Original Message- > From: Kennerly, Rick H CIV [mailto:[EMAIL PROTECTED]] > Sent: Monday, November 18, 2002 9:22 AM > To: CF-Talk > Subject: CF SQL problem > > > I've never seen this message before. Any ideas would be appreciated. > > Here's the code from the Action page: > > > formfields="empID_muster, emp_status"> > > > And here's the info I get back from CF Debug > > Error Executing Database Query. Invalid data > 1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1 for CFSQLTYPE > CF_SQL_NUMERIC. > > > > Rick > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Frames Craziness.
I'm inside a frameset and I'd like to cflocation to a template that would break me out of the frameset, but still be in the same window. I have a multipart form in a frameset that has paging also. The paging buttons submit the form to itself, do some processing and repost the frame. When done I want it to repost to itself do some processing, then cflocation to the next form that isn't in the frameset. Right now when I cflocation I do the processing and of course it runs the next form inside the frame. :-( Any ideas? ***Sterling Financial Investment Group, Inc. (SFIG) is a member of NASD/MSRB/NFA/SIPC. Email transmissions may be monitored. SFIG cannot accept orders to buy or sell via email. Please visit www.mysterling.com for more information.*** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Frames Craziness.
Hmm. I put this in place of my cflocation: parent.location.href="#request.root_url#/index.cfm?fuseaction=profile.profil e8" and it gets out of the frameset, but isn't going to the new url. It's actually going to the frame that we were in, but outside the frameset. -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 19, 2002 3:52 PM To: CF-Talk Subject: Re: Frames Craziness. does not accept the target attribute. You can do the redirect with inline JS like this: parent.location.href="#myurl#" You could replace parent with the name of the target frame. Does this help? Brook At 03:43 PM 19/11/02 -0500, you wrote: >I'm inside a frameset and I'd like to cflocation to a template that would >break me out of the frameset, but still be in the same window. > >I have a multipart form in a frameset that has paging also. The paging >buttons submit the form to itself, do some processing and repost the frame. >When done I want it to repost to itself do some processing, then cflocation >to the next form that isn't in the frameset. > >Right now when I cflocation I do the processing and of course it runs the >next form inside the frame. :-( > >Any ideas? >***Sterling Financial Investment Group, Inc. (SFIG) is a member of >NASD/MSRB/NFA/SIPC. Email transmissions may be monitored. SFIG cannot >accept orders to buy or sell via email. Please visit www.mysterling.com for >more information.*** > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Frames Craziness.
I have this in my page: top.myframe.location.replace("#request.root_url#/index.cfm?fuseaction=profil e.profile8"); And I put this after just to see where I am: Abort It's just hitting the abort. I must be doing something wrong. Greg -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 19, 2002 4:43 PM To: CF-Talk Subject: Re: Frames Craziness. > does not accept the target attribute. You can do the redirect > with inline JS like this: > > parent.location.href="#myurl#" > > You could replace parent with the name of the target frame. Does this > help? or top.myframe.location.replace("#myurl#"); which will replace the current location of that frame in the browser's history stack ( the same as cflocation ) and is viable all the way back to NS 3 and equivalent version of IE. S. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Frames Craziness.
D'oh! I shoulda figured that. :-) When I remove the abort the page just processes on though. The javascript doesn't seem to be doing anything. Is the syntax screwy? top.myframe.location.replace("#request.root_url#/index.cfm?fuseaction=profil e.profile8"); Greg -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 20, 2002 9:15 AM To: CF-Talk Subject: RE: Frames Craziness. Your abort is happening before your javascript is being run because the abort is server side and happens before your javascript. HTH Clint -Original Message----- From: Luce, Greg [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 20, 2002 8:06 AM To: CF-Talk Subject: RE: Frames Craziness. I have this in my page: top.myframe.location.replace("#request.root_url#/index.cfm?fuseaction=pr ofil e.profile8"); And I put this after just to see where I am: Abort It's just hitting the abort. I must be doing something wrong. Greg -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 19, 2002 4:43 PM To: CF-Talk Subject: Re: Frames Craziness. > does not accept the target attribute. You can do the > redirect with inline JS like this: > > parent.location.href="#myurl#" > > You could replace parent with the name of the target frame. Does this > help? or top.myframe.location.replace("#myurl#"); which will replace the current location of that frame in the browser's history stack ( the same as cflocation ) and is viable all the way back to NS 3 and equivalent version of IE. S. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Frames Craziness.
Isaac, When I remove the abort the page just processes on though. The javascript doesn't seem to be doing anything. Is the syntax screwy? top.myframe.location.replace("#request.root_url#/index.cfm?fuseaction=profil e.profile8"); Greg -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 19, 2002 4:43 PM To: CF-Talk Subject: Re: Frames Craziness. > does not accept the target attribute. You can do the redirect > with inline JS like this: > > parent.location.href="#myurl#" > > You could replace parent with the name of the target frame. Does this > help? or top.myframe.location.replace("#myurl#"); which will replace the current location of that frame in the browser's history stack ( the same as cflocation ) and is viable all the way back to NS 3 and equivalent version of IE. S. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Can't create ODBC connection in CFADMIN
Paul, For some crazy reason I always do better using windows to create an access ODBC connection. Then I test it in cf admin. I'm sure it's just something I do wrong. I have no trouble with SQL connections though. :-) Greg -Original Message- From: Paul Wilson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 20, 2002 10:35 AM To: CF-Talk Subject: Can't create ODBC connection in CFADMIN I am trying to create an ODBC Socket DSN in the CFMX Administrator but i get the following error. Could not import the tag library specified by ../cftags/. The following error was encountered: C:\CFusionMX\wwwroot\CFIDE\administrator\datasources\..\cftags The CFML compiler was processing: a cfimport tag beginning on line 2, column 2. If i try to create an Access DSN then I can't browse the server and I get the error... Server Error! IO error on server communication. How can I fix this? Thanks ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: cfquery - subquerie>
How's this work? SELECT employee_number,emp_last_name, emp_preferred_name, sup_short_name, email_id FROM tbl_Employee WHERE emp_short_name = '#Trim(qEmployeeList.sup_short_name)#' AND employee_number = #FORM.EmployeeName# -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 21, 2002 2:39 PM To: CF-Talk Subject: cfquery - subquerie> How would I go about combining these 2 queries into a single query? Or would it be best to leave it seperated into 2. Thx, Dave SELECT employee_number,emp_last_name, emp_preferred_name, sup_short_name, email_id FROM tbl_Employee WHERE employee_number = #FORM.EmployeeName# SELECT email_id FROM tbl_Employee WHERE emp_short_name = '#Trim(qEmployeeList.sup_short_name)#' HTC Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: cfquery - subquerie>
D'oh! SELECT employee_number,emp_last_name, emp_preferred_name, sup_short_name, email_id FROM tbl_Employee WHERE employee_number = #FORM.EmployeeName# -Original Message- From: Luce, Greg Sent: Thursday, November 21, 2002 2:43 PM To: CF-Talk Subject: RE: cfquery - subquerie> How's this work? SELECT employee_number,emp_last_name, emp_preferred_name, sup_short_name, email_id FROM tbl_Employee WHERE emp_short_name = '#Trim(qEmployeeList.sup_short_name)#' AND employee_number = #FORM.EmployeeName# -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 21, 2002 2:39 PM To: CF-Talk Subject: cfquery - subquerie> How would I go about combining these 2 queries into a single query? Or would it be best to leave it seperated into 2. Thx, Dave SELECT employee_number,emp_last_name, emp_preferred_name, sup_short_name, email_id FROM tbl_Employee WHERE employee_number = #FORM.EmployeeName# SELECT email_id FROM tbl_Employee WHERE emp_short_name = '#Trim(qEmployeeList.sup_short_name)#' HTC Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Limiting functionality to individual PC's
Can you set session vars denoting if they're accessing from an "approved" PC? -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 23, 2002 2:09 PM To: CF-Talk Subject: OT: Limiting functionality to individual PC's I am looking to lock down certain types of access to particular machines. I was thinking about using cookies to tag the approved PC's. How easy is it for a User to copy a cookie from 1 PC to another? Anyone have alternative methods that they've used? Thanks, Andy -Original Message- From: Harkins,Patrick [mailto:[EMAIL PROTECTED]] Sent: Friday, November 22, 2002 11:52 AM To: CF-Community Subject: RE: OT cookie question Tie it in with NT authentication instead > -Original Message- > From: William H. Bowen [mailto:[EMAIL PROTECTED]] > Sent: Friday, November 22, 2002 12:48 PM > To: CF-Community > Subject: OT cookie question > > > I have a situation developing with an intranet site I'm working on. > > I need to add password protection to the site. no problem > there, I already > have a solution built that I should be able to plug in. It > works extremely > well on our external site and is very easy to implement. > > Now the problem... the way our firewall system is set up. > > In a nutshell: > > My business unit is in a particular subnet and we access the > site via a > given IP address (111.222.333.444) that is then translated and routed > correctly. > > The other units that access this site are on a different > subnet and access > the site via DNS name (iww.eai.tde.alstom.com - no worries handing the > domain out, you shouldn't be able to access it unless you're > on the ALSTOM > WAN). > > In order to make the password protection scheme work I need > to set a cookie > (well a couple actually) > > How can I do this given the domain restrictions of cookies? > > TIA!! > will > > > William H. Bowen > Webmaster > > ALSTOM's T&D Energy Automation & Information Business > > "Your friendly neighborhood Webmaster!" > > [EMAIL PROTECTED] > http://www.esca.com/ > > 425.739.3629 Voice > 425.466.7016 Cell > 425.739.3690 FAX > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
SQL Question
OK, I tried asking this on SQL Team and nobody understood. I want to populate a new column in my tblBusiness called companyid. If there are 5 records for "Publix" I want all 5 to have the same companyid. I could do it using CF very easily like this: SELECTdistinct company AS company FROM tblBusiness UPDATE tblBusiness SET companyid = #currentrow# WHERE company = '#company#' My question is how ccan I do this in query analyzer. I'm sure you can create loops and variables in an SQL script, I just don't know how. ***Sterling Financial Investment Group, Inc. (SFIG) is a member of NASD/MSRB/NFA/SIPC. Email transmissions may be monitored. SFIG cannot accept orders to buy or sell via email. Please visit www.mysterling.com for more information.*** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: SQL Question
Yeah, that's the ticket! I'll look in Books Online for the close and deallocate cursor syntax. (It took 5 hours for this post to go up!) Thanks Mark. DECLARE @company varchar(20) -- or whatever DECLARE myCursor FOR (select distinct company from tblBusiness where listnum = 1) open myCursor Fetch Next from myCursor INTO @company UPDATE tblBusiness SET companyid = (select max(companyid) from tblBusiness where listnum = 1) + 1 WHERE company = '@company' close and deallocate the cursor... -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 26, 2002 4:06 PM To: CF-Talk Subject: RE: SQL Question If you are trying to increment - an int for each company, then you can do it like this: UPDATE tblBusiness SET companyid = (select max(companyid) from tblBusiness) + 1 WHERE company = 'blah' If you must loop through all the companies you will have to open a cursor... There are lots of examples in sql books on-line... If you need a simple example I will send you one, but the basic idea is: DECLARE @company varchar(20) -- or whatever DECLARE myCursor FOR (select distinct company from tblBusiness) open myCursor Fetch Next from myCursor INTO @company Run your update code close and deallocate the cursor... there's a lot more code to it - looping in SQL is a bit more verbose, but it's not hard to get a handle on it if you want to. Very useful too. -Mark -----Original Message- From: Luce, Greg [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 26, 2002 9:30 AM To: CF-Talk Subject: SQL Question OK, I tried asking this on SQL Team and nobody understood. I want to populate a new column in my tblBusiness called companyid. If there are 5 records for "Publix" I want all 5 to have the same companyid. I could do it using CF very easily like this: SELECTdistinct company AS company FROM tblBusiness UPDATE tblBusiness SET companyid = #currentrow# WHERE company = '#company#' My question is how ccan I do this in query analyzer. I'm sure you can create loops and variables in an SQL script, I just don't know how. ***Sterling Financial Investment Group, Inc. (SFIG) is a member of NASD/MSRB/NFA/SIPC. Email transmissions may be monitored. SFIG cannot accept orders to buy or sell via email. Please visit www.mysterling.com for more information.*** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: SQL Question
Yeah, I know. It's not the primary key. It's going to be a foreign key to a "tblCompany". -Original Message- From: Randell B Adkins [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 26, 2002 3:51 PM To: CF-Talk Subject: Re: SQL Question If CompanyID is a unique Field in this table, then you can not update it by using the same number multiple times. if it is a number field or text field which the table does not have a primary key to disallow multiples then you are ok. >>> [EMAIL PROTECTED] 11/26/02 10:29AM >>> OK, I tried asking this on SQL Team and nobody understood. I want to populate a new column in my tblBusiness called companyid. If there are 5 records for "Publix" I want all 5 to have the same companyid. I could do it using CF very easily like this: SELECTdistinct company AS company FROM tblBusiness UPDATE tblBusiness SET companyid = #currentrow# WHERE company = '#company#' My question is how ccan I do this in query analyzer. I'm sure you can create loops and variables in an SQL script, I just don't know how. ***Sterling Financial Investment Group, Inc. (SFIG) is a member of NASD/MSRB/NFA/SIPC. Email transmissions may be monitored. SFIG cannot accept orders to buy or sell via email. Please visit www.mysterling.com for more information.*** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
OT: T-SQL
I'm trying to learn to run T-SQL scripts in Query Analyzer like I can with Oracle in SQL Plus. In the Books Online I found a nice example of a cursor loop running a report against the pubs db. I paste this script into Query Analyzer and hit go and get 5 different errors. Here's the script, you can find it in books online with keyword "cursors, Transact-SQL": SET NOCOUNT ON DECLARE @au_id varchar(11), @au_fname varchar(20), @au_lname varchar(40), @message varchar(80), @title varchar(80) PRINT " Utah Authors report " DECLARE authors_cursor CURSOR FOR SELECT au_id, au_fname, au_lname FROM authors WHERE state = "UT" ORDER BY au_id OPEN authors_cursor FETCH NEXT FROM authors_cursor INTO @au_id, @au_fname, @au_lname WHILE @@FETCH_STATUS = 0 BEGIN PRINT " " SELECT @message = "- Books by Author: " + @au_fname + " " + @au_lname PRINT @message -- Declare an inner cursor based -- on au_id from the outer cursor. DECLARE titles_cursor CURSOR FOR SELECT t.title FROM titleauthor ta, titles t WHERE ta.title_id = t.title_id AND ta.au_id = @au_id -- Variable value from the outer cursor OPEN titles_cursor FETCH NEXT FROM titles_cursor INTO @title IF @@FETCH_STATUS <> 0 PRINT " <>" WHILE @@FETCH_STATUS = 0 BEGIN SELECT @message = " " + @title PRINT @message FETCH NEXT FROM titles_cursor INTO @title END CLOSE titles_cursor DEALLOCATE titles_cursor -- Get the next author. FETCH NEXT FROM authors_cursor INTO @au_id, @au_fname, @au_lname END CLOSE authors_cursor DEALLOCATE authors_cursor GO Why is it not possible to run this in Query Analyzer against the pubs db? ***Sterling Financial Investment Group, Inc. (SFIG) is a member of NASD/MSRB/NFA/SIPC. Email transmissions may be monitored. SFIG cannot accept orders to buy or sell via email. Please visit www.mysterling.com for more information.*** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: T-SQL
Gracias! That was the lynch-pin. Then I found the problem with my script. I had "DECLARE co_cursor FOR..." instead of "DECLARE co_cursor CURSOR FOR..." -Original Message- From: webguy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 27, 2002 9:53 AM To: CF-Talk Subject: RE: T-SQL Change all the double-quotes to single quotes.. Silly books on line WG > -Original Message- > From: Luce, Greg [mailto:[EMAIL PROTECTED]] > Sent: 27 November 2002 14:39 > To: CF-Talk > Subject: OT: T-SQL > > > I'm trying to learn to run T-SQL scripts in Query Analyzer like I can with > Oracle in SQL Plus. In the Books Online I found a nice example of a cursor > loop running a report against the pubs db. I paste this script into Query > Analyzer and hit go and get 5 different errors. Here's the script, you can > find it in books online with keyword "cursors, Transact-SQL": http://www.fusionauthority.com/ads.cfm ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
PHP Contract Work
I need some help with some PHP work. I have a client that needs some work done ASAP and I'm in the process of moving my home-office/servers to a new house. Any PHP'ers with time on they're hands today or tomorrow? Greg ***Sterling Financial Investment Group, Inc. (SFIG) is a member of NASD/MSRB/NFA/SIPC. Email transmissions may be monitored. SFIG cannot accept orders to buy or sell via email. Please visit www.mysterling.com for more information.*** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: who on here did the death clock?
What is the "Death Clock"? -Original Message- From: Dave Lyons [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 12:57 AM To: CF-Talk Subject: who on here did the death clock? i know someone here did the death clock anyone know who it is? Dave -- .::. - ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
PHP versus CF Development Speed?
Anyone have any good case studies or articles explaining development time coparisons between CF and PHP? I've statistics stating ASP takes 60% more dev time than CF. Anyone have any numbers comparing CF to PHP? ***Sterling Financial Investment Group, Inc. (SFIG) is a member ofNASD/MSRB/NFA/SIPC. Email transmissions may be monitored. SFIG cannotaccept orders to buy or sell via email. Please visit www.mysterling.com formore information.*** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
2 Selects Related
Does someone have a copy of the 2 Selects Related Custom Tag? I finally found it on the new MM site after having to install another Flash player and reboot and the download page is broken! Anyone like the new MM site? ***Sterling Financial Investment Group, Inc. (SFIG) is a member ofNASD/MSRB/NFA/SIPC. Email transmissions may be monitored. SFIG cannotaccept orders to buy or sell via email. Please visit www.mysterling.com formore information.*** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Another Newbie Problem
Rick, Can you explain your situation a little more in depth? There are datepart() functions that allow us to compare parts of dates. Greg -Original Message- From: Kennerly, Rick H CIV [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 11, 2002 8:41 AM To: CF-Talk Subject: RE: Another Newbie Problem Thanks for the response and nice product, but we're dealing with a legacy db with thousands of records. Besides, while what you propose is certainly a work around, is this the most "elegant" or programmerly solution? Are there other ways of doing this? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Another Newbie Problem
If you have a search form with a month select and a year selectbox. And you're searching for records with call_date newer than the selected values. SELECT * FROM tblTable WHERE call_date > '#compare_date#' -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 11, 2002 8:57 AM To: CF-Talk Subject: RE: Another Newbie Problem Rick, Can you explain your situation a little more in depth? There are datepart() functions that allow us to compare parts of dates. Greg Sure, thanks for the interest. We have several thousand records in a db with a standard odbc datetime stamp column. We want to be able to filter out end of month statistics (all trouble calls in November, 2002, for instance) by using a set of drop down menus (month, year, type of call). This is the kind of product one sees everywhere on the internet, but I just can't find a reference piece to get my head in the right place about how to go about it. Plus, as I've learned, there are always several approaches to the same problem. Any ideas are appreciated. Rick ***Sterling Financial Investment Group, Inc. (SFIG) is a member of NASD/MSRB/NFA/SIPC. Email transmissions may be monitored. SFIG cannot accept orders to buy or sell via email. Please visit www.mysterling.com for more information.*** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Naming Help tblShoutOuts ?
What's another word for "contact". We have a table called tblContact that refers to people. I want a table to keep track of phone calls or emails to the contacts. tblCommunication seems a little long. ***Sterling Financial Investment Group, Inc. (SFIG) is a member of NASD/MSRB/NFA/SIPC. Email transmissions may be monitored. SFIG cannot accept orders to buy or sell via email. Please visit www.mysterling.com for more information.*** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Naming Help tblShoutOuts ?
I'm just going to keep records of email and phone calls to contacts. Anyone know what they use in ACT or Goldmine? -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 4:14 PM To: CF-Talk Subject: Re: Naming Help tblShoutOuts ? acquaintance connection friend link associate - Original Message - From: "Luce, Greg" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, December 12, 2002 3:06 PM Subject: Naming Help tblShoutOuts ? > What's another word for "contact". We have a table called tblContact that > refers to people. I want a table to keep track of phone calls or emails to > the contacts. > tblCommunication seems a little long. > ***Sterling Financial Investment Group, Inc. (SFIG) is a member of > NASD/MSRB/NFA/SIPC. Email transmissions may be monitored. SFIG cannot > accept orders to buy or sell via email. Please visit www.mysterling.com for > more information.*** > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Naming Help tblShoutOuts ?
That's it! Thanks Jeff. -Original Message- From: Jeff Beer [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 4:44 PM To: CF-Talk Subject: RE: Naming Help tblShoutOuts ? Looks like you want a contact history or contact log. How about tblContact_Log? -Original Message- From: Luce, Greg [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 4:06 PM To: CF-Talk Subject: Naming Help tblShoutOuts ? What's another word for "contact". We have a table called tblContact that refers to people. I want a table to keep track of phone calls or emails to the contacts. tblCommunication seems a little long. ***Sterling Financial Investment Group, Inc. (SFIG) is a member of NASD/MSRB/NFA/SIPC. Email transmissions may be monitored. SFIG cannot accept orders to buy or sell via email. Please visit www.mysterling.com for more information.*** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: REReplace
-Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 12:29 PM To: CF-Talk Subject: REReplace For some reason I can't to a replace on the following: dir = D:\\ --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Announcement: CFMX Exam Buster Released
Awesome Brian! Right on time. I was going to take the CF5 test today. (I thought the CFMX test would be alot different since I've never used CFMX). I just took the demo test and got 78%. I had a couple lucky guesses on the UDF stuff, but I think I'll buy the app, wait a week and take the CFMX test. Any certified CFMXers taken the demo test? What're your opinions of it. Greg -Original Message- From: Brian Simmons [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 17, 2002 11:27 PM To: CF-Talk Subject: Announcement: CFMX Exam Buster Released CFMX Exam Buster from CentraSoft (http://www.centrasoft.com) CFMX Exam Buster is the ultimate testing tool specifically designed to help ColdFusion MX developers earn their ColdFusion MX Certification through the Macromedia Certified Professional Program. CFMX Exam Buster has over 750 questions designed to help you prepare for all aspects of the actual ColdFusion MX Certification exam. CFMX Exam Buster allows you to take eleven different tests, topic tests for your weak areas, and the ability to create random tests. During your test you can save your test in progress, submit comments, bookmark questions, pause your test, and much more. You can control the look and feel of the CFMX Exam Buster application, by controling the fonts, colors, and appearance of many controls, to create a studying environment with which you are comfortable. After your test is scored, you will be shown a comprehensive breakdown of your test results. There is a DEMO version on the Centrasoft website (http://www.centrasoft.com), which allows you to check out all the features of the program, plus one whole test. I'm always asked whether CFMX Exam Buster works, and I'm proud to say that I obtained my Advanced ColdFusion MX Developer Certification today (12/17/02) and the ONLY study aid I used was my own CFMX Exam Buster. Worked like a charm. Check out CFMX Exam Buster today! Thanks, Brian Simmons [EMAIL PROTECTED] The ultimate ColdFusion MX Certification Exam testing tool: Check out CFMX Exam Buster at: http://www.centrasoft.com ColdFusion MX, and Macromedia are registered trademarks of Macromedia Corporation. Macromedia Corporation in no way endorses or is affiliated with Centrasoft Corporation. ***Sterling Financial Investment Group, Inc. (SFIG) is a member of NASD/MSRB/NFA/SIPC. Email transmissions may be monitored. SFIG cannot accept orders to buy or sell via email. Please visit www.mysterling.com for more information.*** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: MS CF?
Yeah, we all know Microsoft isn't profitable right? ;-) Greg -Original Message- From: Rob Rohan [mailto:[EMAIL PROTECTED]] Sent: Monday, December 23, 2002 12:32 PM To: CF-Talk Subject: RE: MS CF? Ha, from the Robertson-Ravo news source :) Guess now I *don't* have to sell my Macromedia stock, whew! Rob -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 23, 2002 9:04 AM To: CF-Talk Subject: RE: MS CF? its not -Original Message- From: Rob Rohan [mailto:[EMAIL PROTECTED]] Sent: 23 December 2002 17:07 To: CF-Talk Subject: RE: MS CF? Please tell me this isn't true. Rob http://treebeard.sourceforge.net http://ruinworld.sourceforge.net Scientia Est Potentia -Original Message- From: Len Conrad [mailto:[EMAIL PROTECTED]] Sent: Monday, December 23, 2002 2:07 AM To: CF-Talk Subject: MS CF? http://theregister.co.uk/content/4/28667.html ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: MS CF?
The Stock Market is all about money. That's the first rule of investing. Buying or selling stocks based on any other ideas is just silly. Good luck with that. Greg -Original Message- From: Rob Rohan [mailto:[EMAIL PROTECTED]] Sent: Monday, December 23, 2002 12:58 PM To: CF-Talk Subject: RE: MS CF? Well, welcome to America where you vote means nothing unless there is an amount of money tied to it. I buy stocks in companies where I like their business practices, think they have good products, and approve of how they treat their staff. Sometimes I loose money, often I make money. Because in the end how you run your business is how you wind up being treated - in this world or the next. I disapprove of a lot of Microsoft's business practices, and I think they are an ethically bad company. They make money - yes - but that is all they do. Plus I sleep *really* well. ALL IMHO as it is my funny green pieces of paper that we have put value on. (If you think it's all about the money - I pity you) Rob -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] Sent: Monday, December 23, 2002 9:39 AM To: CF-Talk Subject: RE: MS CF? Why would you sell it? I'm no Wall St. slickster, but wouldn't you make out well if you were suddenly in possession of $54 MS stock in exchange for your $11 MM shares? > -Original Message- > From: Rob Rohan [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 23, 2002 11:32 AM > To: CF-Talk > Subject: RE: MS CF? > > > Ha, from the Robertson-Ravo news source :) > > Guess now I *don't* have to sell my Macromedia stock, whew! > > Rob > > -Original Message- > From: Robertson-Ravo, Neil (RX) > [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 23, 2002 9:04 AM > To: CF-Talk > Subject: RE: MS CF? > > > its not > > -Original Message- > From: Rob Rohan [mailto:[EMAIL PROTECTED]] > Sent: 23 December 2002 17:07 > To: CF-Talk > Subject: RE: MS CF? > > > Please tell me this isn't true. > > Rob > > http://treebeard.sourceforge.net > http://ruinworld.sourceforge.net > Scientia Est Potentia > > -Original Message- > From: Len Conrad [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 23, 2002 2:07 AM > To: CF-Talk > Subject: MS CF? > > > http://theregister.co.uk/content/4/28667.html > > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: MS CF? (getting OT)
I could ask the guys on the trading floor for their opinion, but I don't think I have to. I guess I should have specified "Investing in the stock market to make money" as opposed to just "The stock market". I didn't know there was a different way to look at it though. Perhaps that explains some things. Throughout the 90s I wondered how "everyone" was winning. Now I see there is a whole other segment. I wondered who was losing. Greg -Original Message- From: Rob Rohan [mailto:[EMAIL PROTECTED]] Sent: Monday, December 23, 2002 1:33 PM To: CF-Talk Subject: RE: MS CF? (getting OT) Funny, I was under the impression the stock market was about stock. If I am not mistaken when you buy stock you are buying a piece of the company - therefore, you are saying "I like what this company is doing I am going to give them money so they can do what they are doing some more." - weather you mean to or not. It has become a Las Vegas type institution where most don't care where their "vote" is going, but it goes none-the-less. Thank you for your good luck wishes, but from the tone of your reply, I think you will need the luck more then I will. Rob -Original Message- From: Luce, Greg [mailto:[EMAIL PROTECTED]] Sent: Monday, December 23, 2002 10:14 AM To: CF-Talk Subject: RE: MS CF? The Stock Market is all about money. That's the first rule of investing. Buying or selling stocks based on any other ideas is just silly. Good luck with that. Greg -Original Message- From: Rob Rohan [mailto:[EMAIL PROTECTED]] Sent: Monday, December 23, 2002 12:58 PM To: CF-Talk Subject: RE: MS CF? Well, welcome to America where you vote means nothing unless there is an amount of money tied to it. I buy stocks in companies where I like their business practices, think they have good products, and approve of how they treat their staff. Sometimes I loose money, often I make money. Because in the end how you run your business is how you wind up being treated - in this world or the next. I disapprove of a lot of Microsoft's business practices, and I think they are an ethically bad company. They make money - yes - but that is all they do. Plus I sleep *really* well. ALL IMHO as it is my funny green pieces of paper that we have put value on. (If you think it's all about the money - I pity you) Rob -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] Sent: Monday, December 23, 2002 9:39 AM To: CF-Talk Subject: RE: MS CF? Why would you sell it? I'm no Wall St. slickster, but wouldn't you make out well if you were suddenly in possession of $54 MS stock in exchange for your $11 MM shares? > -Original Message- > From: Rob Rohan [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 23, 2002 11:32 AM > To: CF-Talk > Subject: RE: MS CF? > > > Ha, from the Robertson-Ravo news source :) > > Guess now I *don't* have to sell my Macromedia stock, whew! > > Rob > > -Original Message- > From: Robertson-Ravo, Neil (RX) > [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 23, 2002 9:04 AM > To: CF-Talk > Subject: RE: MS CF? > > > its not > > -Original Message- > From: Rob Rohan [mailto:[EMAIL PROTECTED]] > Sent: 23 December 2002 17:07 > To: CF-Talk > Subject: RE: MS CF? > > > Please tell me this isn't true. > > Rob > > http://treebeard.sourceforge.net > http://ruinworld.sourceforge.net > Scientia Est Potentia > > -Original Message- > From: Len Conrad [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 23, 2002 2:07 AM > To: CF-Talk > Subject: MS CF? > > > http://theregister.co.uk/content/4/28667.html > > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Array Troubles
I have an array I created by looping over a query. At this point I can test arraylen() and get a value '73'. I can loop output the whole array like this: #order_array[i][1]# #order_array[i][2]# The data in the array all looks proper, but I want to order it by the [2] element. I've tried this and get an error: An error occurred while evaluating the expression: temp = arraysort(order_array, 'numeric', 'desc') Error near line 43, column 7. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Nested Tree DHTML
I have a nested tree built with Steve Nelson's model. I'm also presenting it with the tigra tree DHTML package. It's gotten so large it takes 215 seconds to resolve even with the query cached! The package takes one long character string and parses it out into tables and such. Any ideas on how to speed this up? I had thought originally that caching the query and possibly even running it in the background as a task would make it workable, but no. Queries application.tree (Records=6917, Time=Cached Query) SQL = SELECTChild.Category_ID, Child.Category_Name, Count(Child.StartBranch) AS lvl, Child.StartBranch, Child.EndBranch FROM category_tree AS Parent, category_tree AS Child WHERE Child.StartBranch BETWEEN Parent.StartBranch AND Parent.EndBranch GROUP BY Child.StartBranch, Child.Category_ID, Child.Category_Name, Child.EndBranch ORDER BY Child.StartBranch ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Adding All to cfselect
You can just put an ALL between the and the tags. -Original Message- From: Luis Lebron [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 10:43 AM To: CF-Talk Subject: Adding All to cfselect I want to use cfselect to dynamically generate select boxes, however I also need to have an "All" option as part of the select. Is there any easy way to do this other than adding "All" to the database field? thanks, Luis R. Lebron Project Manager Sigmatech, Inc ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Checkbox problems, need help
Eric, I must've missed a post. Explain your problem a little. -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED]] Sent: Friday, January 10, 2003 2:39 PM To: CF-Talk Subject: Checkbox problems, need help I am a little confused on this. Where do I set the CFPARAM? Is it in the action page. Also when I check the box and pass to the action page the form outputs a 0 for the value when I was expecting a 1 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Database Results
Scott, You don't HAVE to put the query results into an array. Here's a simple example: SELECT * FROM users Name: #name# If the query didn't have any results it just wouldn't run any output loops. You can check by saying: See? Much simpler than that goofy ASP. :-) Greg -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 3:56 PM To: CF-Talk Subject: Database Results When I used to work with ASP, I would run my SQL statement, check to see if the recordset is empty or not, if it wasn't, I'd roll it up into an array, and the loop through the array. I know how to do the SQL statement, and how to loop through it, but how would I check to see if the result of the query contained results or not, and how would I put the results in an array, and then how would I loop through that array? I'm sorry for asking so many questions...I'm in a new job which is also a new developing environment...and I have very little time to learn all this... Any & all help is greatly appreciated, as I know everyone in here is strapped for time as well. Thanks, Scott ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Fusebox was RE: Design Pattern Question
The Fusebox methodology is created/modified/evolved by hundreds of people in the FB community. Throw your hat into the ring if you like! Greg -Original Message- From: Adrocknaphobia Jones [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 4:17 PM To: CF-Talk Subject: RE: Fusebox was RE: Design Pattern Question " Fusebox is the most widely distributed Framework/Methodology for developing ColdFusion Applications" What other Framework/Methodologies exist for Cold Fusion? Is the fuseBox framework/methodology decided by a consortium? Or by a few elite people? Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Mike Brunt [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 3:09 PM To: CF-Talk Subject: Fusebox was RE: Design Pattern Question As far as I understand it Hal Helms is no longer on the Fusebox committee, he was a founding member. I can tell you that he is still very much involved with Fusebox and at the forefront of the Fusebox iteration for ColdFusion MX just repeating here, you can see some of his work in that regard here http://www.halhelms.com/webresources/fuseboxmxpreso/page1.htm. Fusebox is the most widely distributed Framework/Methodology for developing ColdFusion Applications and as stated here is also being looked at for ASP, JSP and PHP development. There are rumblings that CFC's obviate the need for Fusebox, my feelings are that CFC's as of themselves do not answer all the application needs that Fusebox including Fusedocs (a documentation capability) and FLiP (an application lifecycle methodology) answered. Many people are waiting to see what Fusebox for ColdFusion MX looks like and I also know that there is a lot of interest among Flash developers about Fusebox as a methodology/framework for Flash Application development. Kind Regards - Mike Brunt, CTO Webapper Blog http://www.webapper.net Web site http://www.webapper.com Downey CA Office 562.243.6255 AIM - webappermb Web Application Specialists -Original Message- From: charlie griefer [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 11:48 AM To: CF-Talk Subject: Re: Design Pattern Question Scott Wilhelm writes: > This might be a stupid question, but what's Fusebox? (Sorry, I'm a > newbie in the CF world) http://www.fusebox.org. it's a fairly popular design methodology (started with CF, and i believe has been ported to PHP). Altho I understand that CFC's, now available in CFMX, kind of render fusebox moot (disclaimer: i do not know fusebox...i do not know for certain that fusebox is no longer 'worthwhile'...this is only something that i have heard in certain circles) :) charlie > > SW > > -Original Message- > From: Adrocknaphobia Jones > Sent: Mon 01/13/2003 02:22 PM > To: CF-Talk > Cc: > Subject: RE: Design Pattern Question > > > > Not one to start gossip, but I was under the influence that Hal > Helms > left the fusebox group. Is this true? If so why did he leave, if > not, > why is this rumor floating around? > > Adam Wayne Lehman > Web Systems Developer > Johns Hopkins Bloomberg School of Public Health > Distance Education Division > > > -Original Message- > From: Mike Brunt [mailto:[EMAIL PROTECTED]] > Sent: Sunday, January 12, 2003 12:13 PM > To: CF-Talk > Subject: RE: Design Pattern Question > > Yes this is a good methodology to consider as we all move out of > procedural > methodologies to more 'OO' based concepts. Yet in my opinion > there is a > further dimension that Fusebox achieves, or has done for us, > that I have > not > yet seen expounded in CFMX tutorials etc. > > Using Fusebox in conjunction with FLIP we have a complete > application > design > and development environment from concept-discussion through > coding-ongoing > maintenance. In addition by using Fusebox we have found it easy > to > bring in > developers who had never coded on CF before but who had a good > grasp of > HTML, JavaScript and/or ASP-JSP. Further by abstracting the > actual > Fuseaction values till run-time Fusebox truly affords the > capability at > another layer of separation, that of separating design from > development; > when combined with the very descriptive capabilities afforded by > the use > of > Fusedocs. Finally, the logicality of using Circuits as a > mapping/pathing > mechanism addresses to physical layout questions of developing a > web > application. > > There is one last very important point here, there have been > many > previous > methodologies/frameworks applied to ColdFusion development. > What is > different in Fusebox is it has become the most widely used of > all of > them >
RE: SecretAgents.com Tutorials
SQL For Smarties I hear covers the nested tree thing well, but I'd like to know if we can still use the tutorials. I got a subscription through work also. Greg -Original Message- From: Cutter (CF_Talk) [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 16, 2003 4:26 PM To: CF-Talk Subject: SecretAgents.com Tutorials So, I started these tutorials to teach me how to do a hierarchy menu using nested data sets. I really wanted to learn this so that I could begin creating my HM_Array.js files dynamically. The first 3 tutorials were free, the last 3 (which give you the important details) required a subscription. So I go to my company to get a subscription. They finally approve it and it is sitting on the CFO's desk waiting to be processed. So I go to the site to review the 1st 3 tutorials... But now the site is not the same site. Oh, it has the same logo, the same URL, but now it's a site to submit jobs to be done, or for a developer to "take a fuse." Anybody know how I can get what I need? Cutter ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: (admin) test
Mike, they're spamming the yahoo cf-Howto group also. Give em hell! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 22, 2003 11:43 AM To: CF-Talk Subject: (admin) test People on CF-Community are getting bouncebacks from experthost.com and I'm trying to trackdown what address is throwing the problem. Please ignore this message. Michael Dinowitz Master of the House of Fusion http://www.houseoffusion.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4