CFMX7 for OS X

2009-10-13 Thread Rob Barthle
I need to install CFMX7 on OS X. We still use this at work, soon to upgrade to either CF8 or CF9. I read that with 7.01 there is a Mac OS X full installer, but Adobe points to the trial page which now is all CF9. Does anyone know where I can grab a copy of this still?

Re: cannot insert record with ##createodbcdatetime(now())##

2009-10-13 Thread Matt Quackenbush
Heh. Damn. I thought I had spotted something important. ;-) On Tue, Oct 13, 2009 at 6:12 PM, Rick Root wrote: > > The original thread is here, and that was not the case: > > http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:60230 > >

Re: cannot insert record with ##createodbcdatetime(now())##

2009-10-13 Thread Rick Root
The original thread is here, and that was not the case: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:60230 On Tue, Oct 13, 2009 at 7:06 PM, Matt Quackenbush wrote: > > I didn't see the original code, but if the title is accurate, that is why it > is not "working". > > ##creat

Re: Randomize Query results?

2009-10-13 Thread Rick Root
What about adding a blank column to your query results select '' as foo, othercols from table and then select * from qry order by foo Maybe something like that would work. Rick ~| Want to reach the ColdFusion communit

Re: cannot insert record with ##createodbcdatetime(now())##

2009-10-13 Thread Matt Quackenbush
I didn't see the original code, but if the title is accurate, that is why it is not "working". ##createodbcdatetime(now())## The double hash on each side will result in the literal string #createodbcdatetime(now())# being passed to the database.

Re: cannot insert record with ##createodbcdatetime(now())##

2009-10-13 Thread Rick Root
Also would've expected it to work too Of course, the real question is why is he using the UDBC Socket to the SQL Server ODBC driver, instead of just using the native SQL Server JDBC Driver? "[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver]Invalid precision valu

Re: cannot insert record with ##createodbcdatetime(now())##

2009-10-13 Thread Leigh
> But *THIS* would work: > > cfsqltype="cf_sql_timestamp"> That sounds more likely. I would have expected both what you posted and his original code to work. ie: > cfsqltype="CF_SQL_TIMESTAMP"> Granted the createodbcdatetime() is a bit redunant. But it should still work. I thought it mig

RE: Randomize Query results?

2009-10-13 Thread Paul Vernon
> Also brainstorming for other alternatives. It's a simple round robin > load balancer. I'd rather not have the first unit just by database > index order selected all the time. This is what I did... VacancyID is a primary key... SELECT VacancyID, FROM q WHERE Vac

Re: Randomize Query results?

2009-10-13 Thread Barney Boisvert
If you're picking one item from a query, you can just do: myQuery.myColumn[randRange(1, myQuery.recordCount)] That'll be way more efficient than reordering the whole query. cheers, barneyb On Tue, Oct 13, 2009 at 2:53 PM, Yuliang Ruan wrote: > > I have a Query of Query right now that I'd like

Re: Randomize Query results?

2009-10-13 Thread Dave Watts
> I have a Query of Query right now that I'd like to have the results sort > order randomized.  Any ideas?   I've seen examples > dependent on the dbms for producing a random randomization, but is there any > way to do that within QofQ?   The base query that > my QoQ is operating on is a cached

Randomize Query results?

2009-10-13 Thread Yuliang Ruan
I have a Query of Query right now that I'd like to have the results sort order randomized. Any ideas? I've seen examples dependent on the dbms for producing a random randomization, but is there any way to do that within QofQ? The base query that my QoQ is operating on is a cached Oracle qu

Re: cannot insert record with ##createodbcdatetime(now())##

2009-10-13 Thread Rick Root
I'll bet he used Now() outside of cfqueryparam, which of course would not work because Now() is a cf function, and getDate() is a transact-sql function. But *THIS* would work: Rick On Tue, Oct 13, 2009 at 5:39 PM, Leigh wrote: > >> Now() didn't work, but getdate() did.  Thank you. > > Weird.

Re: Looking for jQuery Form Help...

2009-10-13 Thread Rick Root
Since the original question was cross-posted to the jquery list, I might as well cross-post my answer: Are you using the "disabled" attribute on the inputs that you want to "turn off"? If so, you can add/remove it. http://www.it.dev.duke.edu/public/disabled.html http://www.it.dev.duke.edu/publi

Re: cannot insert record with ##createodbcdatetime(now())##

2009-10-13 Thread Leigh
> Now() didn't work, but getdate() did.  Thank you. Weird. While I would not expect an issue, maybe it was related the cf_sql_timestamp? I do not use odbc socket connections. So I am not sure how that type is handled.. -Leigh

Re: Looking for jQuery Form Help...

2009-10-13 Thread Tony Bentley
You just need to point to each form element that you want to disable. For instance, if you setup a parent container then you can command each matching element to disable: function disableForm(bool){ $("#DivWithInputs input,#DivWithInputs textarea").each(function(){ $(this).attr("disabled",boo

Re: Display web page and download a file

2009-10-13 Thread Rick Root
On Tue, Oct 13, 2009 at 12:49 PM, John Pullam wrote: > > I have an app in CF8 that needs to show a web page and then download a file > that my user requested. Nothing too difficult. The page essentially tells > them some stats on the file and acknowledges the request. I can't find any > way to

Re: ColdFusion Server keeps falling down!

2009-10-13 Thread Rick Root
> I then try and restart the service and it errors stating CF cannot be stopped That's pretty normal for an overloaded server.. takes a while to shut down. Since you're running fusion reactor... tell us how busy the server is. Look at the request activity graph.. what's the "average"? Maybe t

RE: Looking for jQuery Form Help...

2009-10-13 Thread Che Vilnonis
Hello again Tony. How would I take your below example and use it to "disable" select boxes, textareas, radio buttons and checkboxes? Thanks, Che -Original Message- From: Tony Bentley [mailto:t...@tonybentley.com] Sent: Tuesday, October 13, 2009 11:32 AM To: cf-talk Subject: Re: Looking f

Re: cannot insert record with ##createodbcdatetime(now())##

2009-10-13 Thread Matthew Smith
>Try the SQL Server function "GETDATE()" instead of a queryparam > >On Tue, Oct 13, 2009 at 3:01 PM, Matthew Smith wrote: > >> Now() didn't work, but getdate() did. Thank you. ~| Want to reach the ColdFusion community with som

re: cannot insert record with #createodbcdatetime(now())#

2009-10-13 Thread Jason Fisher
you don't need to use createODBCDateTime() with CFQUERYPARAM. just that should do it ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://

Re: cannot insert record with #createodbcdatetime(now())#

2009-10-13 Thread Jake Churchill
Try the SQL Server function "GETDATE()" instead of a queryparam On Tue, Oct 13, 2009 at 3:01 PM, Matthew Smith wrote: > > I get this error: > Error Executing Database Query. > [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server > Driver]Invalid precision value > > With th

cannot insert record with #createodbcdatetime(now())#

2009-10-13 Thread Matthew Smith
I get this error: Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver]Invalid precision value With this query: INSERT INTO contest ( name,email,phon

Re: Display web page and download a file

2009-10-13 Thread Tony Bentley
Usually just creating a link to the cfheader content page will push the download without changing the current page location. Basically this allows the calling page to be downloaded but you could modify it to however you want. Instead of using the application.cfc, just include it as your downloa

Re: Whitespace markers in CF Builder

2009-10-13 Thread David Mineer
Beauty. That was it. Thank you! On Tue, Oct 13, 2009 at 12:39 PM, Rob Parkhill wrote: > > it is CTRL+. on Windows - Show Whitespace and CTRL+. removes it > HTH > > Rob > > On Tue, Oct 13, 2009 at 2:29 PM, David Mineer wrote: > > > > > I pressed some key combination that added some whitespace

Re: Whitespace markers in CF Builder

2009-10-13 Thread Peter Boughton
Try going to Windows>Preferences and in the filter box at the top type "whitespace" or "hidden" or similar terms, and look for the appropriate setting. I'd guess that one of the "Editor" sections/subsections has it, but I don't actually use CFBuilder so I'm just stabbing in the murky light of a

Re: Whitespace markers in CF Builder

2009-10-13 Thread Rob Parkhill
it is CTRL+. on Windows - Show Whitespace and CTRL+. removes it HTH Rob On Tue, Oct 13, 2009 at 2:29 PM, David Mineer wrote: > > I pressed some key combination that added some whitespace markers. ">>" for > tabs (although smaller) and "\r\n" at the end of each line. > > Anyone know where the s

Whitespace markers in CF Builder

2009-10-13 Thread David Mineer
I pressed some key combination that added some whitespace markers. ">>" for tabs (although smaller) and "\r\n" at the end of each line. Anyone know where the setting to turn this off is located? Little annoying. Thanks, -- David Mineer Jr - The critical ingredient is getti

Re: ColdFusion Server keeps falling down!

2009-10-13 Thread Eric Roberts
Did you try putting it on a more stable desk? *grin* Eric -- From: "Glyn Jackson" Sent: Monday, October 12, 2009 2:25 PM To: "cf-talk" Subject: ColdFusion Server keeps falling down! > > We have recently moved to a new virtual server, since the m

Re: Listserves vs. Message Boards

2009-10-13 Thread Peter Boughton
>I don't see why anyone would have a problem using listserves... And that's part of the reason why there's such a significant divide. Technical people are fine with mailing lists; they understand them and can generally setup their email client in a suitable way, and they don't get what's wrong

Re: Display web page and download a file

2009-10-13 Thread John Pullam
I assume that I can simulate it by reading the file and calculating the stats, then redoing the entire cfquery on another page from a cflocation. In one of my attempts, I split the current page up by moving the cfcontent and cfheader only to a new page but that didn't work (acted as though it w

Re: Display web page and download a file

2009-10-13 Thread Mahcsig
Try creating your stats page then cflocation to another page that pushes the file out. ~Mahcsig On Tue, Oct 13, 2009 at 9:49 AM, John Pullam wrote: > > I have an app in CF8 that needs to show a web page and then download a file > that my user requested. Nothing too difficult. The page essentia

Display web page and download a file

2009-10-13 Thread John Pullam
I have an app in CF8 that needs to show a web page and then download a file that my user requested. Nothing too difficult. The page essentially tells them some stats on the file and acknowledges the request. I can't find any way to do both though. As soon as I insert the following, it no longe

Re: Looking for jQuery Form Help...

2009-10-13 Thread Tony Bentley
Tested: Disable Enable function showHide(bool){ if(bool) { $("input[name=shippingaddress]").attr("disabled",true); } else{ $("input[name=shippingaddress]").attr("disabled",false);

RE: Browser not recognizing CFM tags

2009-10-13 Thread Dave Phillips
It's possible if you associated .CFM files with an editor on your local machine and you did File/open in your browser and you selected a .CFM that was local on your machine that your browser might 'appear' to open the file, when, in reality, the associated program you associated with the .cfm file

Re: Browser not recognizing CFM tags

2009-10-13 Thread Ian Skinner
Alan Rother wrote: > The way CF is processed is through a call to IIS. Or Apache or ColdFusion's built-in web server. IIS is not the only one that works! ;-) ~| Want to reach the ColdFusion community with something they want?

Re: Browser not recognizing CFM tags

2009-10-13 Thread Timothy Laureska
Thanks Alan - its coming back to me now :-) >>> Alan Rother 10/13/2009 11:31 AM >>> Just for clarification for anyone else who reads this thread... The way CF is processed is through a call to IIS. When you request a file from IIS, it checks a library of file types, CFM, CFC and others are regi

RE: Looking for jQuery Form Help...

2009-10-13 Thread Che Vilnonis
Tony, thanks so much! Tested EQ What I needed! -Original Message- From: Tony Bentley [mailto:t...@tonybentley.com] Sent: Tuesday, October 13, 2009 11:32 AM To: cf-talk Subject: Re: Looking for jQuery Form Help... Tested: Disable Enable function showHide(bool){ if(bo

Re: Browser not recognizing CFM tags

2009-10-13 Thread Alan Rother
Just for clarification for anyone else who reads this thread... The way CF is processed is through a call to IIS. When you request a file from IIS, it checks a library of file types, CFM, CFC and others are registered as needing to be processed by the CF server, so IIS hands over the file to CF, i

Re: Looking for jQuery Form Help...

2009-10-13 Thread Tony Bentley
In your function if the radio is checked (or unchecked depending on the ready state), enable the collection of form elements by using $("input[name=formelement]").attr("disabled",true); ~| Want to reach the ColdFusion communit

Re: Looking for jQuery Form Help...

2009-10-13 Thread Mahcsig
this is using disabled to keep them visible: function showHide(){ if($(this).is(":checked")){ $("input, select, textarea", "#DifferentShippingAddress").attr("disabled","disabled"); } else{ $("input, select, textarea", "#DifferentShippingAddress").removeAttr("disabled"); } } ~Mahcsig On T

Re: Browser not recognizing CFM tags

2009-10-13 Thread Timothy Laureska
yes, that works... its been a while since I worked in CF - I really seem to remember it working with just a file/open as well... maybe my feeble mind is failing me And thanks to all that helped >>> Alan Rother 10/13/2009 11:18 AM >>> Uggh.. sorry it's early and no caffeine yet.. http://l

Re: Looking for jQuery Form Help...

2009-10-13 Thread Tony Bentley
Sure: function showHide(){ if($(this).is(":checked")){ $("#DifferentShippingAddress").show(); } else{ $("#DifferentShippingAddress").hide(); } } This is untested but basically the div uses a showhide function that toggles the form to be visible using the radio controller. You'll need to h

Re: Browser not recognizing CFM tags

2009-10-13 Thread Alan Rother
Uggh.. sorry it's early and no caffeine yet.. http://localhost/oig_2 =} On Tue, Oct 13, 2009 at 8:17 AM, Alan Rother wrote: > Just as a comparison try this: > http:\\localhost\oig_2\ > > > =] > -- > Alan Rother > Adobe Certified Advanced ColdFusion MX 7 Developer > Manager, Phoenix Cold Fus

Re: Browser not recognizing CFM tags

2009-10-13 Thread James Holmes
No it hasn't. You need to use the webserver or the CF server to view the files; you will see the raw contents of the file in any version of CF if you simply open the file from the filesystem. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/10/13 Timothy Laur

Re: Browser not recognizing CFM tags

2009-10-13 Thread Alan Rother
Just as a comparison try this: http:\\localhost\oig_2\ =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| Want to reach the ColdFusion community with so

Re: Browser not recognizing CFM tags

2009-10-13 Thread Timothy Laureska
files are in c:\inetpub\wwwroot\oig_2 I'm just doing a file/open from the browser window - Which has always worked in the past with older CF versions >>> Alan Rother 10/13/2009 11:09 AM >>> What directory on your computer are the CFM files in and what url are you using to hit those files?

RE: Looking for jQuery Form Help...

2009-10-13 Thread Che Vilnonis
I should add that by default, the bottom form fields in my example screen shot are "off". That is, they are visible, but you can't enter any data. When turned "on", only then can data be entered. Thanks in advance to anyone that can help. -Original Message- From: Che Vilnonis [mailto:ch..

Re: Browser not recognizing CFM tags

2009-10-13 Thread Alan Rother
What directory on your computer are the CFM files in and what url are you using to hit those files? -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| Want

Re: Browser not recognizing CFM tags

2009-10-13 Thread Timothy Laureska
yes, the server is started - the Administrator page comes up fine >>> Brian McCairn 10/13/2009 10:37 AM >>> If you look in Services is ColdFusion 8 Application Server started? Assuming windows what do you get when you open the Administrator page from the Start menu. ~~

Re: Browser not recognizing CFM tags

2009-10-13 Thread Brian McCairn
If you look in Services is ColdFusion 8 Application Server started? Assuming windows what do you get when you open the Administrator page from the Start menu. ~| Want to reach the ColdFusion community with something they want?

Browser not recognizing CFM tags

2009-10-13 Thread Timothy Laureska
I've got CF 8 newly installed on a desktop and a laptop but neither will recognize CFM tags... I can see the html code fine in the browser (tried in both IE and Firefox) using IIS, which looks fine Any points on this would be greatly appreciated... rapidly losing my hair Tim ~~

RE: Listserves vs. Message Boards

2009-10-13 Thread Rick Faircloth
I don't see why anyone would have a problem using listserves in terms of email received. I use Outlook 2007 and I have my email viewed by thread, which allows me to quick delete any thread I in which I'm uninterested. And, if I wanted to, I could set up a folder for messages from a particular li

Re: Splitting a list...

2009-10-13 Thread Claude Schneegans
>>i need to have the values of each sublist in variables How about hving them in a list of lists? Then you could get each sublist pretty easily. Try this: Now you have a "|" delimited list of 100 elements "," delimited sublists Use listGetAt(theList, n, "|") to get each nth sublist. ~~

Looking for jQuery Form Help...

2009-10-13 Thread Che Vilnonis
Take a look at the link below. It's a screen shot of a form where the "Shipping" form fields can be toggled on/off. I haven't been able to find (or search properly) for jQuery code that does something similar. Can anyone point me in the right direction? Thanks, Che http://www.asitv.com/images/jqu

Re: Listserves vs. Message Boards

2009-10-13 Thread Peter Boughton
> The client doesn't know...they want the pros/cons. >From what you've said, I'm inferring that they will mostly have 'normal' >people using their systems. The main pro of mailing lists is that they're convenient for busy techies. Some cons of mailing lists is that they're limited and inflexi

Re: Listserves vs. Message Boards

2009-10-13 Thread Michael Dinowitz
Randy, House of Fusion uses a custom system that has evolved over the years. It would be rather easy for someone to write their own but as others have said, there are pre-built systems that have the same basic features which would cost less than writing something from scratch or even from already

Re: Listserves vs. Message Boards

2009-10-13 Thread Randy Zeitman
Rick Faircloth says: "A combo system (like we have here) does both and should be the way to go." (ok, what system/software is it?) ~| Want to reach the ColdFusion community with something they want? Let them know on the House