Re: optimal cfadmin settings

2006-10-18 Thread Dave Lyons
be fairly light load, just using it for my own sites and a few smaller low traffic (2-400 visitors a day) client sites. Most all will be running the sites via model-glue (god damn good frickin job Joe!!), and all sharing the modelglue, coldspring & reactor files in main webroot. None of the si

Re: Who do i write this JAVA in CF?

2006-10-18 Thread Dan Plesse
This GetTaxResult getTaxResult = port.getTax(getTaxRequest); Looks like this in CF ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to y

ANNOUNCE: CFFM 1.14 Released

2006-10-18 Thread Rick Root
CFFM - the Coldfusion File Manager Version 1.14 has been released. Here is the changelog: - added code to cffm.cfc to IGNORE allowed or disallowed file extensions on directory creation. - added readOnly property - added allowCreateDirectory property - added allowUnzip property - added allowMu

Re: WiFi available at MAX?

2006-10-18 Thread John C. Bland II
Microsoft had Mix at the Venetian in March. Wifi was great then. Hopefully Adobe has a similar setup. I say that to say, the Venetian is read for solid wifi. lol. On 10/18/06, Dave Watts <[EMAIL PROTECTED]> wrote: > > > Anyone know if WiFi will be available at the Adobe MAX conference? > > I don

Re: How to adjust recorded update to users timezone

2006-10-18 Thread Paul Hastings
Michael E. Carluen wrote: > Thank you Paul. Your cfc is it! > > Btw, when I try to execute icu4jTB.cfm, it errors out as: > > Object Instantiation Exception. > Class not found: com.ibm.icu.util.TimeZone do you have icu4j installed? ~~

Re: optimal cfadmin settings

2006-10-18 Thread Nicholas M Tunney
Really depends on the type of applications it is running. Apps with many arduous requests should have different settings then apps with many quick requests. What type of load do you expect? nic Dave Lyons wrote: > I think awhile back someone had a nice sheet on setting up cfm server for > op

Changed CGI.REQUEST_URI behaviour with CF7/Apache - A Solution

2006-10-18 Thread James Holmes
Those who have upgraded their Apache 2 CF servers to CF7 may have noticed that CGI.REQUEST_URI no longer contains the original request URL and query string when Apache does a 404 redirect to a CF page. For example, we just found this the hard way. In 6.1, the var would contain the original URL and

RE: Coldfusion Portal application

2006-10-18 Thread Snake
There is also one called dynaportal -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: 18 October 2006 20:22 To: CF-Talk Subject: RE: Coldfusion Portal application Courage... Also why the hotentots are so hot... -Original Message- From: Dan Plesse [mailto

optimal cfadmin settings

2006-10-18 Thread Dave Lyons
I think awhile back someone had a nice sheet on setting up cfm server for optimal performance, anyone remember who that was or anyone know of one. cfmx 7 standard windows 2003 server (puke) vps hosting plan ~| Introducing the Fu

RE: equivalent of isDefined in ASP?

2006-10-18 Thread Dawson, Michael
Perhaps it has been set in the Global.asa file or something like that. Global.asa is similar to application.cfm. I'm just guessing, too. M!ke -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 1:45 PM To: CF-Talk Subject: RE: equivalent o

Re: VPS & Coldfusion Lic

2006-10-18 Thread Rick Root
Joel wrote: > > Do I need CF lic for each VPS instance or do I only need one CF Lic for the > server since the lic is based on physical CPU. I'm not a lawyer, but as far as i know, Coldfusion is licensed per physical CPU on a single piece of hardware. So if you've got 10 VPS on one machine with

VPS & Coldfusion Lic

2006-10-18 Thread Joel
Hi Guys, Quick question.. Do I need CF lic for each VPS instance or do I only need one CF Lic for the server since the lic is based on physical CPU. Open for correction. :-) Thanks in advance Joel ~| Introducing

Re: CFEclipse and CFCs

2006-10-18 Thread Bryan Stevenson
Thanks Nathan/Jacob, Yeah one of my staff had solved his issues by adjusting his local McAfee VirusScan settings, and now both of you have mentioned virus scanners. So I'll dig into that one (crappy to have to lessen the auto-scanning thus reducing protection). As far as UNC vs. mapped drive.

RE: Clustered servers and CF MX Install

2006-10-18 Thread Dave Watts
> I'm trying to find out if it is possible to have a server > cluster (5 physical boxes running Apache) to share 1 common > coldfusion mx install, that is on its own separate server. > > This way I could avoid xtra licenses, and xtra maintenance. You haven't found anything about this configur

RE: WiFi available at MAX?

2006-10-18 Thread Dave Watts
> Anyone know if WiFi will be available at the Adobe MAX conference? I don't know for sure, but it's been available at every prior Macromedia conference I've attended. However, it tends to be within a limited area, and has been somewhat unreliable in my experience. Dave Watts, CTO, Fig Leaf Softw

RE: CFEclipse and CFCs

2006-10-18 Thread Munson, Jacob
I've heard of this problem when people are using Norton antivirus, and they have it set to scan network drives. Might that be the problem? > -Original Message- > From: Bryan Stevenson [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 18, 2006 3:48 PM > > In CFEclipse, almost every t

Re: CFEclipse and CFCs

2006-10-18 Thread Nathan Strutz
Bryan, I'm not sure why you would only see that problem with CFCs. It used to happen to me all the time -- i could save once, but when i try to save a file the 2nd time, it would give the "file has changed" error. I don't completely remember the final solution (finding a new job worked for me). I

RE: Who do i write this JAVA in CF?

2006-10-18 Thread Ben Nadel
Jonese, You don't have to type objects in CF... You can just call stuff directly: getTaxResult = port.getTax(getTaxRequest); Assuming that "port" already exists and getTagRequest already exists. .. Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com

Re: WiFi available at MAX?

2006-10-18 Thread John C. Bland II
There typically is and I wouldn't expect less this time. On 10/18/06, Ryan Stille <[EMAIL PROTECTED]> wrote: > > Anyone know if WiFi will be available at the Adobe MAX conference? > > -Ryan > > > > ~| Introducing the Fusion Auth

RE: Who do i write this JAVA in CF?

2006-10-18 Thread Doug Bezona
If you aren't sure what properties or methods the object contains, you can use cfdump to examine it. -Original Message- From: "jonese" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: 10/18/06 5:26 PM Subject: Who do i write this JAVA in CF? Ok I've got an object called port and I've done all th

Mone on "missing session variables". XmlHTTP involved ...

2006-10-18 Thread Walter Conti
The following code works correctly if call directly, but if it is called remotely (XMLHTTP, Spry) the two values are passed ok but the session.variables are nowhere else to be seen after refreshing the page. #session.userId# #session.userRealName# All session variables in other pages ar

CFEclipse and CFCs

2006-10-18 Thread Bryan Stevenson
Hey All, In CFEclipse, almost every time I try and save a CFC that is part of a remote project (files hosted remotelyproject defined locally), I get a "file has changed" error when I try and save. I know for a fact that nobody else is touching the file(s) in question. The same thing DOES

RE: How to adjust recorded update to users timezone

2006-10-18 Thread Michael E. Carluen
Nevermind Paul, I think I got it. > -Original Message- > From: Michael E. Carluen [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 18, 2006 1:48 PM > To: CF-Talk > Subject: RE: How to adjust recorded update to users timezone > > Thank you Paul. Your cfc is it! > > Btw, when I try to

WiFi available at MAX?

2006-10-18 Thread Ryan Stille
Anyone know if WiFi will be available at the Adobe MAX conference? -Ryan ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door fo

Re: Coldfusion Portal application

2006-10-18 Thread Cutter (CFRelated)
Not an Oz reference?!? (as spoken by the Cowardly Lion, for those who don't know) Cutter __ http://blog.cutterscrossing.com Mark A Kruger wrote: > Courage... Also why the hotentots are so hot... ~| Introducing

Who do i write this JAVA in CF?

2006-10-18 Thread jonese
Ok I've got an object called port and I've done all the stuff i need to it and now i need to call a function inside my port object called getTax and pass it another object i created call getTaxRequest. All of these object are java object created using the CreateObject method in CF. but i'm a bit b

Re: OT: flash / xml photo galleries?

2006-10-18 Thread Dave Lyons
http://www.afcomponents.com/ > Anyone have a good free/opensource flash or ajax based photo gallery > which takes its list of photos from a XML or other config file? > > I'm looking to implement on a site with HTML only capabilities (no cf, > jsp, asp, php etc) > > Thanks in advance Dov

RE: Form Fields - storing unsaved values with a Page refresh

2006-10-18 Thread Ian Skinner
Some code I played with demonstrating the idea. Index.cfm - http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";> http://www.w3.org/1999/xhtml";> Basic Form

RE: Form Fields - storing unsaved values with a Page refresh

2006-10-18 Thread Derek
Ok, Thanks for all your help. I have it working now. Thank you. Have a great day -Derek -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 1:08 PM To: CF-Talk Subject: RE: Form Fields - storing unsaved values with a Page refresh A couple o

RE: How to adjust recorded update to users timezone

2006-10-18 Thread Michael E. Carluen
Thank you Paul. Your cfc is it! Btw, when I try to execute icu4jTB.cfm, it errors out as: Object Instantiation Exception. Class not found: com.ibm.icu.util.TimeZone > -Original Message- > From: Paul Hastings [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 18, 2006 11:13 AM > To:

Clustered servers and CF MX Install

2006-10-18 Thread Vincent Farina
Hi, I'm sorry but I've searched long and hard for an answer to this, so I'm putting it to the group of experts. I'm trying to find out if it is possible to have a server cluster (5 physical boxes running Apache) to share 1 common coldfusion mx install, that is on its own separate server.

RE: Form Fields - storing unsaved values with a Page refresh

2006-10-18 Thread Ian Skinner
Any ideas? I just have very broad ideas without knowing your requirements in more detail. In your filter function that is called from the select's onChange event, change the action property of the form to a page that handles the ID logic, restores the current state of the form, and returns to

RE: Form Fields - storing unsaved values with a Page refresh

2006-10-18 Thread Derek
The second idea looks great. How can I make it actually submit the form the right place when they are ready? The user has the ability to change markets (ids) multiple times which populates submarkets based on this choice before submitting the actual form. Any ideas? Thanks again for your time and

Re: flash / xml photo galleries?

2006-10-18 Thread Massimo Foti
> It's not free but SlideShowPro.net is awesome. It's only $20 and it's well > worth it. I second that, but I have to admit I don't follow Flash's market, so maybe I am just not aware of better alternatives :-) As for Ajax, Spry's gallery is pretty cool: http://labs.adobe.com/technologies/spry/

Re: CFINCLUDE not including: FB3/Linux

2006-10-18 Thread Josh Nathanson
> Have you checked the permissions on the files after you upload them. > The ftp server could be changing them on upload not allowing CF/ > Apache to read them. > Dave > Permissions seem to be fine. -- Josh ~| Introducing t

Re: CFINCLUDE not including: FB3/Linux

2006-10-18 Thread Josh Nathanson
> What version of CF? > > You may need to clear out the cached classes? > It's 7.0.2 -- Do I need to restart to clear the cached classes? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to

RE: flash / xml photo galleries?

2006-10-18 Thread Andy Matthews
It's not free but SlideShowPro.net is awesome. It's only $20 and it's well worth it. -Original Message- From: Dov Katz [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 2:28 PM To: CF-Talk Subject: OT: flash / xml photo galleries? Anyone have a good free/opensource flash or a

RE: CFINCLUDE not including: FB3/Linux

2006-10-18 Thread Brad Wood
If you upload the file and then hit refresh immediately, I wonder if your server hard disk is lagging behind writing the file and it is being accessed after being flushed, but before the new content is saved. Just an unlikely thought. I know I have refreshed right as I was saving and caught the f

Re: Mac OSX, Coldfusion 7, Intel Chips, OH MY!!!

2006-10-18 Thread J W
Now that its running for me, its actually pretty fast too... Thanks for the link.. Jeff On 10/18/06, Jon Clausen <[EMAIL PROTECTED]> wrote: > > Yeah, it's pretty much a PIA to get going, but once you set it up and > get it integrated with Apache, it's a very nice development environment. > > I u

Re: CFINCLUDE not including: FB3/Linux

2006-10-18 Thread David Livingston
Have you checked the permissions on the files after you upload them. The ftp server could be changing them on upload not allowing CF/ Apache to read them. Dave On Oct 18, 2006, at 2:36 PM, Josh Nathanson wrote: > Thanks Sandra, > > The cases all match up, and the file is definitely there. > >

RE: CFINCLUDE not including: FB3/Linux

2006-10-18 Thread loathe
What version of CF? You may need to clear out the cached classes? > -Original Message- > From: Josh Nathanson [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 18, 2006 3:37 PM > To: CF-Talk > Subject: Re: CFINCLUDE not including: FB3/Linux > > Thanks Sandra, > > The cases all match

Re: Mac OSX, Coldfusion 7, Intel Chips, OH MY!!!

2006-10-18 Thread J W
That is good news Ben. I was aware that CFMX7 came out first, but I just didn't realize (or even gave it a second thought) when I bought the Macbook Pro. Just grabbed the installed off adobe and installed it, thats when I realized it wasn't going to work that way. Thanks for the update, good news e

Re: CFINCLUDE not including: FB3/Linux

2006-10-18 Thread Josh Nathanson
Thanks Sandra, The cases all match up, and the file is definitely there. In FB3 it will throw the "could not find included template" error if the file is not found, so that is not the issue. It's really weird - it only does this skipping occasionally, and there doesn't seem to be any pattern t

OT: flash / xml photo galleries?

2006-10-18 Thread Dov Katz
Anyone have a good free/opensource flash or ajax based photo gallery which takes its list of photos from a XML or other config file? I'm looking to implement on a site with HTML only capabilities (no cf, jsp, asp, php etc) Thanks in advance Dov ~~

Re: Avalara Tax Web Service

2006-10-18 Thread jonese
Jon, We signed up for the AvaTax API service and have been trying to get the service to work via object instantiation etc but have failed to make a successful connection. We keep getting errors about the certificate. We are trying to get this service to work for a jewelry retailer which is based

RE: one year behind

2006-10-18 Thread Brad Wood
And it could be done even simpler with the year() function. ~Brad -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 2:25 PM To: CF-Talk Subject: RE: one year behind First thing, remember to try and avoid using a function name as a variabl

RE: one year behind

2006-10-18 Thread Sandra Clark
Mea Culpa. I guess I should stick to CSS questions huh? Sandra Clark == http://www.shayna.com Training in Cascading Style Sheets and Accessibility -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 3:21 PM To:

RE: one year behind

2006-10-18 Thread Andy Matthews
First thing, remember to try and avoid using a function name as a variable name. Second, remember that don't need the pound sign on the right side (unless you're inside quotes). Also, this could be done simpler like so: -Original Message- From: Orlini, Robert [mailto:[EMAIL PROTECT

RE: Coldfusion Portal application

2006-10-18 Thread Mark A Kruger
Courage... Also why the hotentots are so hot... -Original Message- From: Dan Plesse [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 12:53 PM To: CF-Talk Subject: Re: Coldfusion Portal application What makes a portal a portal? On 10/18/06, Teddy Payne <[EMAIL PROTECTED]> wro

RE: CFINCLUDE not including: FB3/Linux

2006-10-18 Thread Sandra Clark
The only thing that comes to my mind is that Linux is case sensitive while Windows is not. Is the file name in the cfinclude exactly like it is in the file system? I know that Fusebox 4 will ignore a if the file is not there unless an attribute is set in the in the circuit.xml. Possibly there i

RE: one year behind

2006-10-18 Thread Ian Skinner
Doesn't account for leap years. Sandra Clark Close Sandra. 'Y' if for Day of Year, '' is for year. So it should be: -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - "C code. C c

RE: one year behind

2006-10-18 Thread Orlini, Robert
Thanks Agha and Greg -Original Message- From: Mehdi, Agha [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 2:53 PM To: CF-Talk Subject:RE: one year behind Option 1: Option 2: Agha Mehdi IDT - eBusiness Program Manager -Original Message- From: Orl

Re: one year behind

2006-10-18 Thread Aaron Rouse
Spaces are not allowed in variable names. :) On 10/18/06, Sandra Clark <[EMAIL PROTECTED]> wrote: > > Doesn't account for leap years. > > > > > Sandra Clark > == > http://www.shayna.com > Training in Cascading Style Sheets and Accessibility > > -- Aaron Rouse http:

RE: one year behind

2006-10-18 Thread Sandra Clark
Doesn't account for leap years. Sandra Clark == http://www.shayna.com Training in Cascading Style Sheets and Accessibility -Original Message- From: Mehdi, Agha [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 2:53 PM To: CF-Talk Subject: RE: on

Re: fused: CFPROCPARAM Error ORA-06502

2006-10-18 Thread Jack Shepard
No size. This is stored procedure out parameter. Oracle will not allow you declare the size of a stored procedure parameter. See the stored procedure below. Stored Procedure Code: procedure GetSysDate( QFromDateOU

Email Routing and Management

2006-10-18 Thread Mehdi, Agha
Hi All, I need some recommendations for Customer Support Email routing and management tools with built-in workflow. Thanks Agha Mehdi IDT - eBusiness Program Manager Work: 408.284.8239 Cell : 510.493.0491 Fax : 408.284.2766 ~~

RE: one year behind

2006-10-18 Thread Mehdi, Agha
Option 1: Option 2: Agha Mehdi IDT - eBusiness Program Manager -Original Message- From: Orlini, Robert [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 11:45 AM To: CF-Talk Subject: one year behind How can I set this to be one year behind? Right now it displays 2006; I wo

Re: one year behind

2006-10-18 Thread Greg Morphis
try using dateadd() it asks for a part, like year, and then the offset, so you could do -1.. Should work for you On 10/18/06, Orlini, Robert <[EMAIL PROTECTED]> wrote: > How can I set this to be one year behind? Right now it displays 2006; I would > like it to display 2005 > > > > Thanks. > > Ro

RE: equivalent of isDefined in ASP?

2006-10-18 Thread Dawson, Michael
Hell, no. He was more of a free-spirit ASP programmer. ;-) He always said I was going to too much trouble when I used option explicit. -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 1:23 PM To: CF-Talk Subject: RE: equivalent of isDefine

one year behind

2006-10-18 Thread Orlini, Robert
How can I set this to be one year behind? Right now it displays 2006; I would like it to display 2005 Thanks. Robert O. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion in

CFINCLUDE not including: FB3/Linux

2006-10-18 Thread Josh Nathanson
Hey all, I am running a FuseBox 3 app on Linux. Sometimes, when I make a change to a .cfm file and upload it, the application will start skipping over the cfinclude which references the uploaded file as though it's not even there. No error or anything, it just skips right over it. When I look

RE: equivalent of isDefined in ASP?

2006-10-18 Thread Ray Champagne
Yea, I've been reading about this Option Explicit thing, and even though I never have put <% Option Explicit %> anywhere in the script(s), it's acting like it is in there somewhere. Like doing this: <% Response.write(boo)%> throws an error saying "Name 'boo' is not declared". Weird. > -Ori

RE: Form Fields - storing unsaved values with a Page refresh

2006-10-18 Thread Ian Skinner
A couple of ideas: 1) Use Ajax, I can't help you here, but I'm pretty sure it could be used for this kind of thing. 2) Use the form.submit() function to submit the form, rather then self.location. Then your action logic will have access to all the data currently in the form. It could repopul

Re: SQL compare software

2006-10-18 Thread Mary Jo Sminkey
>Remember that the database is the most important part of the Web site, >and you don't want to use any tool that may have some bug that could >result in data loss. Very true. I only mention the product that I use because it is considerably cheaper for what it does and because the issues I have h

RE: Problems with duplicate() in MX 6.1???

2006-10-18 Thread Brad Wood
Are you setting throwontimeout="true"? If you don't, and the lock times out, then the page will continue to execute, and stuff won't exist. You might want to pay careful attention to how much code is inside of your exclusive locks. Leaving a lock open around database calls, or file I/O could l

Re: Form Fields - storing unsaved values with a Page refresh

2006-10-18 Thread Josh Nathanson
How about submitting the form, and cfparam'ing all the form fields, then make the value of each field "#form.whatever#". That will save any changed data. You'll probably need to set up some logic to determine if you only want to change the ID, or you really are submitting the whole form. -- J

RE: equivalent of isDefined in ASP?

2006-10-18 Thread Andy Matthews
So just the act of testing a variable caused it to exist? Interesting. -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 1:10 PM To: CF-Talk Subject: RE: equivalent of isDefined in ASP? I'm not an ASP guy, but the previous guy was. >F

Re: To object or not to object

2006-10-18 Thread Nathan Strutz
Charles, I have a couple things to point out that may help you... 1: Your CMS - why not do the processing every time the page is changed and save a static file, like HTML or a semi-dynamic cfm page? That should keep the processing down a lot. You may be doing that, I couldn't really tell from wha

Re: Problems with duplicate() in MX 6.1???

2006-10-18 Thread Dave Phillips
Well, apparently, this is not an issue with the duplicate() function. We took it out completely and just did a simple assignment. Apparently, there is an assumption that our above the assignment is timing out, and all variables are not getting set properly. This is why they aren't all duplic

RE: equivalent of isDefined in ASP?

2006-10-18 Thread Brad Wood
Did the previous guy use "option explicit"? ~Brad -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 1:10 PM To: CF-Talk Subject: RE: equivalent of isDefined in ASP? I'm not an ASP guy, but the previous guy was. >From what I can tell, i

Re: Action Query

2006-10-18 Thread Jim Wright
Terry Troxel wrote: > My bad. > > I obviously stated my problem wrong. > > I have a make table query defined already in access as > MakeAR1 that takes a link to an existing table(Mas90 ODBC > source named AR1_CustomerMaster) and creates a new Access > table(AR1). > > I would like to somehow run

Re: How to adjust recorded update to users timezone

2006-10-18 Thread Paul Hastings
first off read this: http://www.sustainablegis.com/blog/cfg11n/index.cfm?mode=entry&entry=77223B6A-20ED-7DEE-2AB7FBB1F37ABD77 > has a preferred utc timezone on file. Unfortunately I am not using it. Any if you don't mind occasionally falling into "timezone hell", then: - store all the datetimes

RE: equivalent of isDefined in ASP?

2006-10-18 Thread Dawson, Michael
I'm not an ASP guy, but the previous guy was. >From what I can tell, in ASP, "all" variables exist. If they were not assigned a value, then they will be an empty string (or whatever equivalent for complex variables). He just tested for x <> "" or x = "" and then did what he had to do. M!ke --

Re: SQL compare software

2006-10-18 Thread Robertson-Ravo, Neil (RX)
I have evaluated both ApexSQL and the RedGate Suite, I have found them both to be fast, reliable and easy to use. It just comes down to personal choice. "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed B

Form Fields - storing unsaved values with a Page refresh

2006-10-18 Thread Derek
Can anyone help me with this? I have an onChange function that refreshes my coldfusion page and puts the new ID in the URL and then the SQL uses this ID to get certain information from the database. But when it refreshes with the new ID I lose any changed data in the form... any suggestions? My c

Re: How to adjust recorded update to users timezone

2006-10-18 Thread Terry Schmitt
Use TimeZone.cfc at http://www.cfczone.org/cfcs/index.cfm >I am looking for the best way to display a "last update date" based on the >users preferred timezone. The datetime record is entered on the db using >#now()# timestamp, which is of course, that is the server time. Every user >has a pref

Re: How to adjust recorded update to users timezone

2006-10-18 Thread Will Tomlinson
I've wanted to make a post like this as well. need the same kinda solution. Will ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to you

Re: equivalent of isDefined in ASP?

2006-10-18 Thread Will Tomlinson
Says alot about asp don't it? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.

Re: Coldfusion Portal application

2006-10-18 Thread Dan Plesse
What makes a portal a portal? On 10/18/06, Teddy Payne <[EMAIL PROTECTED]> wrote: > > Ray Camden started a CF portal: > > http://www.coldfusionportal.org/ > > Teddy > > On 10/18/06, David Low <[EMAIL PROTECTED]> wrote: > > > > The beauty of CF has always been that you could do this very quickly >

RE: equivalent of isDefined in ASP?

2006-10-18 Thread Ray Champagne
Yea, that won't quite work, and what you're doing really isn't like cfparam, is it? Your suggestion is more like cfset. Here is my loose logic: If the variable is passed into the page, then use it's value, if not, set it to a default (like cfparam). If I explicitly set it to "", then it will ov

Re: equivalent of isDefined in ASP?

2006-10-18 Thread Jake Churchill
Do the equivalent of cfparam and set it to "" at the top. Then, just test to see what it's value is. variable <> "" Ray Champagne wrote: > Anybody got an idea? Google isn't helping me out right now. (VB) > > > > Ray > > > > ~

RE: Action Query

2006-10-18 Thread Terry Troxel
My bad. I obviously stated my problem wrong. I have a make table query defined already in access as MakeAR1 that takes a link to an existing table(Mas90 ODBC source named AR1_CustomerMaster) and creates a new Access table(AR1). I would like to somehow run that MakeAR1 query in Coldfusion rather

equivalent of isDefined in ASP?

2006-10-18 Thread Ray Champagne
Anybody got an idea? Google isn't helping me out right now. (VB) Ray ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door f

Re: Action Query

2006-10-18 Thread Jim Wright
Terry Troxel wrote: > Has anyone run a MS Access action query using a cfquery > statement or any other way in CF? > > I need to somehow do a "Make Table" query in Access and > would appreciate any > Input to help figure this out if it is possible. > > Terry Troxel > This may help you... http://

How to adjust recorded update to users timezone

2006-10-18 Thread Michael E. Carluen
I am looking for the best way to display a "last update date" based on the users preferred timezone. The datetime record is entered on the db using #now()# timestamp, which is of course, that is the server time. Every user has a preferred utc timezone on file. Unfortunately I am not using it. A

Re: SQL compare software

2006-10-18 Thread Jim Wright
Mike Chabot wrote: > Remember that the database is the most important part of the Web site, > and you don't want to use any tool that may have some bug that could > result in data loss. I believe that RedGate does a good job with QA > testing and they have been supporting their software for a long

Re: SQL compare software

2006-10-18 Thread Mike Chabot
Remember that the database is the most important part of the Web site, and you don't want to use any tool that may have some bug that could result in data loss. I believe that RedGate does a good job with QA testing and they have been supporting their software for a long time. That said, if anyone

Re: cfadmin 404 with apache

2006-10-18 Thread Josh Nathanson
Doug - make sure you have the following in your httpd.conf file (in the conf directory of your apache directory): DirectoryIndex index.html index.shtml index.cfm You have to have that "index.cfm" on the end -- sometimes it gets stripped when you do a reinstall of CF. Don't know if that is what

Action Query

2006-10-18 Thread Terry Troxel
Has anyone run a MS Access action query using a cfquery statement or any other way in CF? I need to somehow do a "Make Table" query in Access and would appreciate any Input to help figure this out if it is possible. Terry Troxel ~~

Re: Mac OSX, Coldfusion 7, Intel Chips, OH MY!!!

2006-10-18 Thread Jon Clausen
Yeah, it's pretty much a PIA to get going, but once you set it up and get it integrated with Apache, it's a very nice development environment. I used this reference and it made my life much easier: http:// webmages.com/cfmxIntelOSXguide.html If you want to run your development environment on

RE: Select/combine two years

2006-10-18 Thread Andy Matthews
You really shouldn't be looping over a query like this. Given the code provided by the other user, your final SQL might look like this: SELECT * FROM purchases WHERE year IN (2001,2004,2006) ORDER BY orderid desc That's what you're looking to accomplish. Now you just need to determine where the y

Re: Strange URL pointing to CFM page

2006-10-18 Thread Dave Hoff
> All, > > I've never seen this type of hyperlink before. It resolves to a cfm > page. > > Is it pointing to a directory or a file? > > http://www.domainname. > com/coupons?subscriberemail=Y29sZGZ1c2lvbi5kZXZlbG9wZXJAYXR0Lm5ldA== It is possible to have IIS forward all 404 not found pages to a

Re: Select distinct on multiple columns

2006-10-18 Thread Gareth Hughes
That's so simple compared to the things I'd been trying! It works perfectly and as Brad suggested I can easily get counts as well which is a major bonus. Many thanks Jim. Mike, I tried your suggestion but it didn't seem to produce the desired result. I'll tinker with it though to see what I ca

RE: Announce: RIAForge

2006-10-18 Thread Priest, James \(NIH/NIEHS\) [C]
> -Original Message- > From: CF-Talk [mailto:[EMAIL PROTECTED] > Announce: RIAForge > sorting/grouping mechanism, and will figure that out when we have more > projects (enough to warrant it). This seems like a good use for tags... > Do you have any plans to release the forge itself as

Re: onRequestStart

2006-10-18 Thread Teddy Payne
How often does the variable need to be updated? OnRequestStart will execute prior to every page request. If it less frequent than that, I would recommend putting it in the application start. You can use onRequestStart to check to see if the variable needs to be updated in the application scope.

RE: onRequestStart

2006-10-18 Thread loathe
Request is not a scope that is available across multiple requests, it has to be recreated for each page request. Your looking for session or client. > -Original Message- > From: Brian Peddle [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 18, 2006 11:37 AM > To: CF-Talk > Subject: on

RE: onRequestStart

2006-10-18 Thread Ben Nadel
You are correct, REQUEST is a single-page persisting object. In only lasts for the duration of the page request and then is destroyed. SESSION and APPLICATION are cross-page persisting scopes. You might want to try setting it into SESSION. .. Ben Nadel Certified Advanced ColdF

Re: Mac OSX, Coldfusion 7, Intel Chips, OH MY!!!

2006-10-18 Thread Teddy Payne
Jeff, Adobe offers a toll free service to assist any CF user with installation of CF on servers and laptops. They can instruct you on how to isntall J2EE on Windows and Mac. I have called them in the past and they are very knowledgeable and eager to help. I forgot the number, but it was not diff

RE: Select/combine two years

2006-10-18 Thread Orlini, Robert
Worked real god Mike. Thanks! I'm going to make note of this for future use. That's how to learn this at times. Robert O. -Original Message- From: Mike Tangorre [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 11:14 AM To: CF-Talk Subject:Re: Select/com

RE: Opening PDF issue

2006-10-18 Thread Scott Mulholland
Problem solved, turned out to be a dns caching issue on their network. -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 17, 2006 9:44 AM To: CF-Talk Subject: Re: Opening PDF issue On Tuesday 17 October 2006 13:40, Scott Mulholland wrote: > Anyone ha

  1   2   >