RE: What is the best variable scope?

2002-06-29 Thread Andrew Scott
Exactly my point, and as the user is not reading these emails then why make that a point when you and I both know otherwise :-) -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Saturday, 29 June 2002 8:44 AM To: CF-Talk Subject: RE: What is the best variable

CF5 and MySQL

2002-06-29 Thread Peter Tilbrook
Why would I not be able to select MySQL as a data provider under CF Admin (version 5 - MX was even worse)? I'm running Windows 2000 Advanced Server with IIS (fully patched - Broadband is a godsend for that) and CF5 Professional. Thanks! == Peter Tilbrook Macromedia ColdFusion Applications

Re: CF5 and MySQL

2002-06-29 Thread Jochem van Dieten
Peter Tilbrook wrote: Why would I not be able to select MySQL as a data provider under CF Admin (version 5 - MX was even worse)? Because nobody ever bothered to write a plugin to add that option. Jochem __ This list and all

Re: CF5 and MySQL

2002-06-29 Thread Paul Hastings
Why would I not be able to select MySQL as a data provider under CF Admin (version 5 - MX was even worse)? last time i looked cfmx had native mySQL. i don't imagine thats worse. __ Your ad could be here. Monies from ads go

RE: CF5 and MySQL

2002-06-29 Thread Peter Tilbrook
I've used it in the past so I'm mind boggled as to why it isn't available now. I can use MSSQL which I have a licence for but wanted to write a freeware application. Looks like I'll be developing under SQL Server. == Peter Tilbrook Macromedia ColdFusion Applications Developer 4/73 Tharwa Road

RE: CF5 and MySQL

2002-06-29 Thread Peter Tilbrook
Can't affor MX as yet - I did try the trial version - not impressed enough yet for the upgrade. The MM staff at the recent Australian launch were arrogant also. Much more so than anyone else I've met from Microsoft, Novell, Oracle and even Allaire. == Peter Tilbrook Macromedia ColdFusion

RE: CF5 and MySQL

2002-06-29 Thread Peter Tilbrook
It seems the belief at MM is that everyone who has used CF since, say like myself, version 1 are commited by default to upgrade to the MX family of products. ColdFusion MX has problems and in my opinion the decision to discontinue development of HomeSite/ColdFusion Studio in its current form is

Re: CF5 and MySQL

2002-06-29 Thread Paul Hastings
Can't affor MX as yet - I did try the trial version - not impressed enough well from my i18n standpoint, this is the greatest thing since sliced bread. what it doesn't do, with a few measly lines of newbie java i can get the rest. yet for the upgrade. The MM staff at the recent Australian

RE: CF5 and MySQL

2002-06-29 Thread Douglas Williams
Have you downloaded and installed myODBC drivers from mySQL.com? I have a similar setup as you and have no problems setting up mySQL as a datasource. -Original Message- From: Peter Tilbrook [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 29, 2002 4:18 AM To: CF-Talk Subject: CF5 and

SKU Forecasting Formula's

2002-06-29 Thread Andy Ousterhout
Has anyone written any sku forecasting code? If so, can you point me to some information that I can use to create my algorthyms? I'm currently trying to create a process in Excel which I'll then port to Coldfusion. Goal is to provide wholesale customers with recommended buy based off of

RE: trouble passing variables

2002-06-29 Thread Larry Juncker
Doug- If I am not mistaken, you do not need a value statement on your edit form for the checkboxes. Just the if statement, that will set the value of the checkbox. Try removing the value statement of your checkboxes and try again. -Original Message- From: Douglas Brown [mailto:[EMAIL

Dynamic Checkboxes

2002-06-29 Thread David Jones
I am having some trouble with dynamically named checkboxes. This is what I am trying to do On a form I have some dynamically named form variables. like Cfloop from = 1 to = #vLoopNUm# index=x input type=text name=pvAnswer_ID#x# value= input type=text

RE: Dynamic Checkboxes

2002-06-29 Thread Dave Watts
I am having some trouble with dynamically named checkboxes. On a form I have some dynamically named form variables. like Cfloop from = 1 to = #vLoopNUm# index=x ... input type=checkbox name=chkRemove#x# value= /Cfloop I submit to Cfloop from = 1 to = #vLoopNUm#

Re: Dynamic Checkboxes

2002-06-29 Thread David Schmidt
Well, the isDefined statement would be a good thing to use here. cfif isDefined(form.chkRemove#X#) cfset remove=true cfelse cfset remove=false /cfif and then test for remove for processing (assuming you are processing it inside the loop). By the way, I typically use conditional looping

RE: breaking a loop... need help

2002-06-29 Thread Paul Ihrig
Bud --- i pasted your code here http://www.columbus.nbbj.com/IS/internalsupport/InteEmpGrid05.cfm at the bottom of the page... still no luck.. -paul __ This list and all House of Fusion resources hosted by CFHosting.com. The

RE: CF5 and MySQL

2002-06-29 Thread Mike Alberts
CF 5 and MySQL work fine together (and beats the heck out of using Access IMO) as long as you have installed MyODBC that is. You have to set up the DSN with the Windows Control Panel (not CF administrator). HTH Mike _ Join

Monitor active requests on CF Linux?

2002-06-29 Thread Lawrence B. Afrin, M.D.
Howdy -- Does anybody know of a method within CF, or a third-party tool, whereby I can monitor or otherwise determine which Linux process (or which Windows process, for that matter) is handling which active CF request? Some of my developers occasionally write code which runs away, hangs, or

RE: What is the best variable scope?

2002-06-29 Thread S . Isaac Dealey
Exactly my point, and as the user is not reading these emails then why make that a point when you and I both know otherwise :-) Because it's important for us to think about the work that we do from the perspective of our users -- as entertaining as our tech-centric ways of thinking may be,

Re: CF5 and MySQL

2002-06-29 Thread Jochem van Dieten
Peter Tilbrook wrote: I've used it in the past so I'm mind boggled as to why it isn't available now. I can use MSSQL which I have a licence for but wanted to write a freeware application. Looks like I'll be developing under SQL Server. There isn't one available for PostgreSQL either so I just

RE: Help Displaying results that loop

2002-06-29 Thread Paul Ihrig
ok came into the office to try it out... mucked about a bit... and wasn't able to float it... Isaac you can see a your modified example here... http://www.columbus.nbbj.com/IS/internalsupport/InteEmpGrid06.cfm im going home now.. bringing my laptop to hopefully get this working this weekend..

CFMX / CFC / FLASH Books.

2002-06-29 Thread Neil H.
I would like to see a programmers guide to the subject. Is there anything available now? I know Kevin Towes is involved in a Flash MX book but how technical does that get?' Thanks, Neil Heuer [EMAIL PROTECTED] __ Get the

Re: CFMX / CFC / FLASH Books.

2002-06-29 Thread Neil H.
Also is there a way to print or download the livedocs for CFMX in PDF form so I can print it instead of going to each individual link which is a real pain? Neil - Original Message - From: Neil H. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, June 29, 2002 12:28 PM

RE: breaking a loop... need help

2002-06-29 Thread Paul Ihrig
this is as close as i can get... http://www.columbus.nbbj.com/IS/internalsupport/InteEmpGrid07.cfm not quiet there.. i know it has to be something relatively simple! any more help would be fantastic! -paul cfquery name=rsEmployee datasource=ISresource dbtype=ODBC SELECT EmployeeID, LastName,

Re: trouble passing variables

2002-06-29 Thread Douglas Brown
Well the first time through, it populates the checkboxes from the DB and then it posts back to itself for the update. The person may add another option and I would prefer thaat they do not have to enter all the options over again by leaving the valur blank Douglas Brown Email: [EMAIL

RE: trouble passing variables

2002-06-29 Thread Kwang Suh
Checkbox fields only exist upon submission if they are checked. I always create cfparams for checkbox fields on the action page. -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Friday, June 28, 2002 3:46 PM To: CF-Talk Subject: trouble passing variables

RE: CFMX / CFC / FLASH Books.

2002-06-29 Thread Mike Chambers
a little birdy has told me that O'Reilly is working on a Flash Remoting book that, among other things, will cover working with CFMX. not eta though. mike chambers [EMAIL PROTECTED] -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 29, 2002 12:29 PM

Re: CFMX / CFC / FLASH Books.

2002-06-29 Thread Jason Miller
I have embarkeed on finding some stuff on Flash Remoting and CFMX - some resources definately need to be done. THis would be great if O'Reilly is.. If you do a search on DataProviderClass() on MACRs site - you will come up with a few flash remoting tutorials - one in particular seems to lay

Re: CFMX / CFC / FLASH Books.

2002-06-29 Thread Dick Applebaum
I think I know that birdy too -- and know of the Author(s) -- and that at least one on them is developing the content on A Mac running CFMX under Mac OS X.%^) Dick On Saturday, June 29, 2002, at 12:12 PM, Mike Chambers wrote: a little birdy has told me that O'Reilly is working

Re: trouble passing variables

2002-06-29 Thread Douglas Brown
Kwang, Thanks for the reply, but the form post back to itself and the param tags are still there. It just is not seeing them or something. I am lost!!! Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: Kwang Suh [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent:

RE: CFMX / CFC / FLASH Books.

2002-06-29 Thread Mike Chambers
i think we are talking to different birdies. mike chambers [EMAIL PROTECTED] -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 29, 2002 3:24 PM To: CF-Talk Subject: Re: CFMX / CFC / FLASH Books. I think I know that birdy too -- and know

Re: CFMX / CFC / FLASH Books.

2002-06-29 Thread Dick Applebaum
Nah, same birdy... I could cc them, if you like! Dick On Saturday, June 29, 2002, at 12:44 PM, Mike Chambers wrote: i think we are talking to different birdies. mike chambers [EMAIL PROTECTED] -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: Saturday,

RE: CFMX / CFC / FLASH Books.

2002-06-29 Thread Mike Chambers
oops, i read your message wrong. same birdy. btw, there should more more information on this at flash forward in a week and a half in nyc. mike chambers [EMAIL PROTECTED] -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 29, 2002 3:58 PM

Deleting CFMX Files?

2002-06-29 Thread Ken Wilson
It's my first chance to play around with the release version of CFMX and I'm puzzled. Here's what I did: - created a test page, all works fine. - mapped a custom file extension to the service - delete the first test page - created a new test page with the custom file extension, all works fine

refresh parent after query update

2002-06-29 Thread Douglas Brown
I am looking for some JS that will refresh the parent from a child after an update and not before. I have a little snippet to do the refresh, but it always reloads the parent before the update is complete on the child window. Any help would be great... Douglas Brown Email: [EMAIL PROTECTED]

INNER JOIN

2002-06-29 Thread Paul Ihrig
can you see whats wrong with this query? error below thanks -paul cfquery name=rsServices datasource=ISresource SELECT tblRelations.Relation_ID, tblService.Service_ID, tblService.Service, tblEmployee.EmployeeID,

Re: refresh parent after query update

2002-06-29 Thread Marius Milosav
After the update is completed you can run the following code: script language=JavaScript opener.location.reload(true); close (); /script This will also close the child window. Marius Milosav www.scorpiosoft.com It's not about technology, it's about people. Virtual Company (VICO) Application

Re: refresh parent after query update

2002-06-29 Thread Douglas Brown
ThanksPerfect. Dont know why I did not think of that Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: Marius Milosav [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, June 29, 2002 3:12 PM Subject: Re: refresh parent after query update After

RE: Deleting CFMX Files?

2002-06-29 Thread Stacy Young
I believe all the compiled classes are under WEB-INF/cfclasses Stace -Original Message- From: Ken Wilson [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 29, 2002 5:53 PM To: CF-Talk Subject: Deleting CFMX Files? It's my first chance to play around with the release version of CFMX and

RE: Deleting CFMX Files?

2002-06-29 Thread Ken Wilson
Thanks Stace, that got me where I needed to be. Ken -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 29, 2002 6:50 PM To: CF-Talk Subject: RE: Deleting CFMX Files? I believe all the compiled classes are under WEB-INF/cfclasses Stace

OT: SQL Server Indexes

2002-06-29 Thread Bud
Hi all. I've noticed when upsizing an Access database, I'll get duplicate indexes on the primary keys. For instance, if I have a Category_ID field which is the primary key and indexed in Access, after upsizing, I'll get an index named aCategory_ID_PK and also one named Category_ID in the

Re: INNER JOIN

2002-06-29 Thread Matthew Walker
What's the deal with ( tblEmployee.EmployeeID IS NOT NULL ) ? Shouldn't your ON clause be relating one row in one table to a row in another table? - Original Message - From: Paul Ihrig [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, June 30, 2002 9:57 AM Subject: INNER

Re: INNER JOIN

2002-06-29 Thread S . Isaac Dealey
What's the deal with ( tblEmployee.EmployeeID IS NOT NULL ) ? Shouldn't your ON clause be relating one row in one table to a row in another table? It depends on what you're trying to accomplish with the query -- and it turns out it doesn't work for him I _think_ because he's using Access ...

RE: trouble passing variables

2002-06-29 Thread Kwang Suh
Well, you didn't scope the cfparam tags. Try scoping them to form. and see if that works. -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 29, 2002 1:37 PM To: CF-Talk Subject: Re: trouble passing variables Kwang, Thanks for the reply, but

RE: SQL Server Indexes

2002-06-29 Thread Kwang Suh
Yes. Duplicate indexes are not needed. -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 29, 2002 5:55 PM To: CF-Talk Subject: OT: SQL Server Indexes Hi all. I've noticed when upsizing an Access database, I'll get duplicate indexes on the primary

Re: SQL Server Indexes

2002-06-29 Thread Douglas Brown
Bud, It depends on if the category_id is a field that is searched alot. If that is the case, you might as well leave that index as it will help performance. If not, then deleting it will harm nothing... Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: Bud [EMAIL

Re: SQL Server Indexes

2002-06-29 Thread Douglas Brown
Never mind...I was not thinking, just delete it. Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: Bud [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, June 29, 2002 4:54 PM Subject: OT: SQL Server Indexes Hi all. I've noticed when upsizing an Access

RE: CFMX / CFC / FLASH Books.

2002-06-29 Thread Dave Watts
Also is there a way to print or download the livedocs for CFMX in PDF form so I can print it instead of going to each individual link which is a real pain? You can download the CF MX documentation in PDF format here: http://www.macromedia.com/support/coldfusion/documentation.html Dave

RE: trouble passing variables

2002-06-29 Thread Sheila Handler
Try scoping the variables in the cfparam tags to attributes.x since that's what you use in your update statement. Date: Sat, 29 Jun 2002 18:57:17 -0600 From: Kwang Suh [EMAIL PROTECTED] Subject: RE: trouble passing variables Message-ID: [EMAIL PROTECTED] Well, you didn't scope the cfparam

RE: Firewall configuration for CF and SQL (sort of OT)

2002-06-29 Thread Dave Watts
1) Should the SQL Server be behind the firewall? The answer seems to me to be yes - if so, what port do I have to open to allow communication between the Web/CF Server and the SQL Server so that they can still talk to each other. Our intranet (LAN users) and website (WAN) users need to

RE: Firewall configuration for CF and SQL (sort of OT)

2002-06-29 Thread Mark A. Kruger - CFG
Dave, Can you speak to the possible vulnerabilities involved with setting up a separate web resource domain for the hosts in the DMZ and using trust relationships to specify access to internal resources? I have a client set up this way. I thought the arrangement was fairly elegant with good

RE: What is the best variable scope?

2002-06-29 Thread Andrew Scott
Nice wording, but still what does that have to do with the original thread? -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Sunday, 30 June 2002 12:52 AM To: CF-Talk Subject: RE: What is the best variable scope? Exactly my point, and as the user is not

RE: breaking a loop... need help

2002-06-29 Thread Paul Ihrig
still need help! thx -paul __ 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: