Re: coldfusion service stop rsponding or CPU goes up tp 100%

2011-03-24 Thread Jochem van Dieten
On Mon, Mar 21, 2011 at 7:11 PM, tom vallee wrote: Sometimes the CPU goes up to 100% and I need to restart the coldfusion service and everything goes back normal Sometimes, coldfusion stop responding, if i type my website in internet explorer, it's not responsing but IIS is responding i

RE: The vagaries of QueryNew

2011-03-24 Thread Kevin Parker
Doh! Yes showing code is good and here's the offender... This was inside the loop and myvar was getting incremented by 1 each loop - as there were three rows and therefore three loops the last instruction was to add 3 rows :-) cfset Temp = QueryAddRow(qNews,#myvar#) Thanks guys for your

Adding more than 1 row in CFGRID

2011-03-24 Thread Chad Baloga
I am having a problem with CFGRID where I get Multiple row insert is not supported when a user clicks the insert row button more than once. Is there a way to disable the Add Row button after it is clicked, or does anyone know how to get CFGRID to insert more than 1 row at a time? Thanks

Converting regular date to a Spectra formatted database date?

2011-03-24 Thread Gabriel Ortiz
Working with some legacy spectra data and I'm trying to do a sql search based on the spectra date. A. If I run the code below, I get 03/24/2011 08:58:48 AM cfset spectraData = 40626.374166700 cfdump var=#dateFormat(spectraData,MM/DD/)# cfdump var=#timeFormat(spectraData,HH:MM:SS TT)# B.

Re: Converting regular date to a Spectra formatted database date?

2011-03-24 Thread Dorioo
Well, I've found that the code below will give me the first part before the period (40626). Assuming the second part is the time, I still have to figure out the calculation it's using. cfdump var=#datediff(d,12/30/1899,{ts '2011-03-24 00:00:00'})# - Gabriel On Thu, Mar 24, 2011 at 10:06 AM,

Re: Converting regular date to a Spectra formatted database date?

2011-03-24 Thread Kym Kovan
On 25/03/2011 2:11 AM, Dorioo wrote: Well, I've found that the code below will give me the first part before the period (40626). Assuming the second part is the time, I still have to figure out the calculation it's using. cfdump var=#datediff(d,12/30/1899,{ts '2011-03-24 00:00:00'})#

Re: Converting regular date to a Spectra formatted database date?

2011-03-24 Thread Raymond Camden
Don't forget - Spectra is just CFML. You should be able to find the function that is doing the conversion. On Thu, Mar 24, 2011 at 10:19 AM, Kym Kovan dev-li...@mbcomms.net.au wrote: On 25/03/2011 2:11 AM, Dorioo wrote: Well, I've found that the code below will give me the first part before

Re: Converting regular date to a Spectra formatted database date?

2011-03-24 Thread morgan l
cfset readableDate = '03/24/2011 08:58:48 AM' cfdump var=#NumberFormat(readableDAte,.00)# ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion

Re: Converting regular date to a Spectra formatted database date?

2011-03-24 Thread Bryan Stevenson
I don't think this is a Spectra specific date, but it may be an atomic date (sorrynot up to speed on all the odd formats). So the first thing you need to sort out is the type of date format that number represents. Then it should be easy to find the function you need to take a normal date

Re: Converting regular date to a Spectra formatted database date?

2011-03-24 Thread Dorioo
Thank you all. @Bryan: True. I'm sure it's not specific to spectra, but I knew anyone that has worked with a date from spectra would recognize what I meant by the example. Didn't know what else to call it. @Ray: No access to spectra code. Just the legacy data. @Kym: Good catch, it does seem to

Verity collection

2011-03-24 Thread Keith McGee
I'm using cold fusion 8 enterprise, I have 34 collections and a couple of them are will not return correctly. here are two collection rmlicgpdsenglish 345 1,637 Mar 24 2011 1:55 PM english No rmlicgpdsfrench 174 1,163 Mar 24 2011 1:55 PM french No if you run this query; it will return

Is saving a query in the session passed by reference or by value?

2011-03-24 Thread Eric Cobb
I know that complex data types (structs, CFCs, queries, COM/JavaObjects, etc...) are passed by reference, not by value. But I'm wondering how that works when storing them in the session scope. For example, let's say I have a query that returns a really large result set, and after that query

Re: Is saving a query in the session passed by reference or by value?

2011-03-24 Thread Greg Morphis
I don't know for sure but since CF is built on Java and Java is strictly pass by value, I would assume that CF is too. Maybe someone more knowledgeable will ring in On Thu, Mar 24, 2011 at 2:49 PM, Eric Cobb cft...@ecartech.com wrote: I know that complex data types (structs, CFCs, queries,

Re: Is saving a query in the session passed by reference or by value?

2011-03-24 Thread Brian Kotek
All complex data types are always passed by reference. Where you set them makes no difference. (Except arrays, which are passed by value due to a staggeringly poor decision eons ago.) On Thu, Mar 24, 2011 at 3:49 PM, Eric Cobb cft...@ecartech.com wrote: I know that complex data types

Re: Is saving a query in the session passed by reference or by value?

2011-03-24 Thread Carl Von Stetten
I'm trying to wrap my head around this, so please excuse me for jumping in. If I understand this correctly, the query result is an object placed in memory when execution is complete, and variables.qry is merely a pointer to that object. When the cfset session.myQry = variables.qry is

Re: Is saving a query in the session passed by reference or by value?

2011-03-24 Thread Brian Kotek
That's correct. On Thu, Mar 24, 2011 at 4:18 PM, Carl Von Stetten vonner.li...@vonner.netwrote: I'm trying to wrap my head around this, so please excuse me for jumping in. If I understand this correctly, the query result is an object placed in memory when execution is complete, and

Re: Is saving a query in the session passed by reference or by value?

2011-03-24 Thread Carl Von Stetten
Wow, I finally got it!!! :-) Thanks, Carl On 3/24/2011 1:27 PM, Brian Kotek wrote: That's correct. On Thu, Mar 24, 2011 at 4:18 PM, Carl Von Stetten vonner.li...@vonner.netwrote: I'm trying to wrap my head around this, so please excuse me for jumping in. If I understand this correctly,

Re: Is saving a query in the session passed by reference or by value?

2011-03-24 Thread Russ Michaels
the easy solution is to create the query in the session scope to begin with cfquery name=session.myquery however storing complex vars such as queries in sessions for every single user can consume a lot of memory. If the contents of the query are not unique to each user, you could just cache one

SOT - Members only app

2011-03-24 Thread cfcom
Can anyone recommend a good app for creating a simple and secure members section Thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive:

Re: SOT - Members only app

2011-03-24 Thread Russ Michaels
if you are simply asking about the security side of things, then the best way is to use .htaccess which will secure EVERYTHING, not use cf files. You should already have this or something equivalent available by default, ask your host. On Thu, Mar 24, 2011 at 10:35 PM, cfcom

Re: SOT - Members only app

2011-03-24 Thread Jake Churchill
Farcry On Mar 24, 2011 5:36 PM, cfcom cf...@aceligent.com wrote: Can anyone recommend a good app for creating a simple and secure members section Thanks ~| Order the Adobe Coldfusion Anthology now!

RE: SOT - Members only app

2011-03-24 Thread cfcom
Need to make login feature that unlocks site pages for specific visitors -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: 2011-03-24 18:44 To: cf-talk Subject: Re: SOT - Members only app if you are simply asking about the security side of things, then the best

Re: SOT - Members only app

2011-03-24 Thread Gerald Guido
http://tutorial355.easycfm.com/ On Thu, Mar 24, 2011 at 6:56 PM, cfcom cf...@aceligent.com wrote: Need to make login feature that unlocks site pages for specific visitors -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: 2011-03-24 18:44 To: cf-talk