Re: Update Record by Date then pick Random from Query
Thank you both. The parenthesis around all the ORs worked. Some of my first code had the Date in the Where but I am using the enable/disable so that the Admin knows if the ad contract is up or not. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322150 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Update Record by Date then pick Random from Query
Maybe I mis-understood what you said about this, but you mentioned a complex process for determining which ones are active still. If you have column in the table for each banner that represents the date it expires, then you can use this directly as a filter to prevent it's selection. You don't need to loop over and manually expire each one. Like this: SELECT top 1 * FROM dbo.#request.stationName#_banner_top WHERE date_remove > #CreateODBCDate(Now())# AND status = 0 AND ( page_location = 'Front Page' OR page_location2 = 'Front Page' OR page_location3 = 'Front Page' OR page_location = 'Every Page' OR page_location2 = 'Every Page' OR page_location3 = 'Every Page' ) ORDER BY newID() HTH =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322146 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Update Record by Date then pick Random from Query
Try adding parenthesis around all the ORs, so: SELECT top 1 * FROM dbo.#request.stationName#_banner_top WHERE status = 0 AND ( page_location = 'Front Page' OR page_location2 = 'Front Page' OR page_location3 = 'Front Page' OR page_location = 'Every Page' OR page_location2 = 'Every Page' OR page_location3 = 'Every Page' ) ORDER BY newID() Dominic 2009/5/4 Sin Tec : > SELECT top 1 * > FROM dbo.#request.stationName#_banner_top > WHERE (page_location = 'Front Page') > OR (page_location2 = 'Front Page') > OR (page_location3 = 'Front Page') > OR (page_location = 'Every Page') > OR (page_location2 = 'Every Page') > OR (page_location3 = 'Every ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322144 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Update Panel... Coldfusion?
Wow! I missed that one.. looks like exactly what I need for a project I am working on now Thanks At 11:43 AM 11/4/2008, you wrote: > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314839 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Update Panel... Coldfusion?
Here are some CF AJAX tools . http://ajaxcfc.riaforge.org/ http://www.indiankey.com/cfajax/ http://cfjqajax.riaforge.org/ http://coldext.riaforge.org/ http://cfext.riaforge.org/ On Tue, Nov 4, 2008 at 11:37 AM, Kim Hoopingarner < [EMAIL PROTECTED]> wrote: > I have been in the ASP.NET / AJAX world recently and found one feature > there that is a real asset to a web site... UpdatePanel. Basically it > allows the browser to do partial page post-backs and therefore helps with > response time. > > In Coldfusion - does anyone know if there is something like this? It is an > ajax feature but seems to be associated to ASP.NET right now. I've been > digging to no avail. So I was hoping someone else might have the answer. > > Thanks! > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314815 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Update Panel... Coldfusion?
Thanks! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314813 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Update Panel... Coldfusion?
http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_d-e_04.html Or any of it's Ajax friends. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314812 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Update Query syntax
Thanks much, Charlie! --Ben >WHERE itemno IN (#preserveSingleQuotes(itemnos)#) >or even better: > >WHERE itemno IN (list="true" />) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314317 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Update Query syntax
WHERE itemno IN (#preserveSingleQuotes(itemnos)#)
or even better:
WHERE itemno IN ()
On Thu, Oct 23, 2008 at 12:21 PM, Ben Conner <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have a simple update query that is throwing an error:
>
>update icitem
>set lastchanged = '1/1/2008'
>where itemno in (#itemnos#)
>
>
> The itemnos variable has the value:
> '1A703239', '1A703240', '1A703241', '1A703242', '1A703243'
>
> If I paste that value in between the parens, it works. I've also tried
> using double quotation marks. The error I'm getting is:
>
> Error Executing Database Query.
> [Macromedia][SQLServer JDBC Driver][SQLServer]Line 3: Incorrect syntax near
> '1'.
>
> The error occurred in D:\sites\qcliving.com\htdocs\Admin\kludge.cfm: line
> 23
>
> 21 :update icitem
> 22 :set lastchanged = '1/1/2008'
> 23 :where itemno in (#itemnos#)
> 24 :
>
> SQLupdate icitem set lastchanged = '1/1/2008' where itemno in
> (''1A703239'', ''1A703240'', ''1A703241'', ''1A703242'', ''1A703243'')
> DATASOURCEqcliving
> VENDORERRORCODE 170
> SQLSTATE HY000
>
> What am I missing here?
>
> Thanks!
>
> --Ben
>
>
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314316
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: **UPDATE** JRn 600MB+ shortly after boot up
There was a 100-150MB difference between the Memory Usage reported in CF Admin (which I'm assuming is taping directly into JVM?). Thanks for the tip with the Task Manager. I don't seem to have a PID for VM Size? -Original Message- From: Gaulin, Mark [mailto:[EMAIL PROTECTED] Sent: Monday, May 19, 2008 8:24 AM To: CF-Talk Subject: RE: **UPDATE** JRn 600MB+ shortly after boot up If you are using Task Manager to judge sizes then be sure to notice the difference between "Mem Usage" and "VM Size"... Mem Usage is the amount of physical ram currently in use by a process, but VM Size is, well, different. If you have less physical ram on a machine then you may see less Mem Usage but more VM Size (and probably lots of page faults as memory is swapped in and out, seen in Task Manager as "PF Delta"). I always show both Mem Usage and VM Size in Task Manager to get a better picture of actual memory requirements. Thanks Mark -Original Message- From: Jason Durham [mailto:[EMAIL PROTECTED] Sent: Monday, May 19, 2008 9:11 AM To: CF-Talk Subject: RE: **UPDATE** JRn 600MB+ shortly after boot up It seems odd to me because Jrun uses significantly less memory on both of my other development machines (my 1GB laptop runs at under 75MB on Vista Ultimate). The numbers I've been quoting are from Jrun just after boot (idle, no applications loaded) or after only running CFAdmin. Maybe Jrun needs some time to configure itself and requires extra memory when first installed? Maybe the same can be said for when the machine boots? I don't know, I'm merely asking. The new box is now running at 165MB. The settings are default (as verified earlier). I'm content with 165MB. -Original Message- From: Mark Kruger [mailto:[EMAIL PROTECTED] Sent: Friday, May 16, 2008 5:31 PM To: CF-Talk Subject: RE: **UPDATE** JRn 600MB+ shortly after boot up What makes you think that is not right? If your Max is set to 512 and you load something as an application, the JVM will determine when to recover memory based on it's own timetable and settings. 427 megs could indeed be appropriate depending on the settings. There are some code snippets on this post that you can use to fiddle with the JVM gc operations - although I would not use them in production. http://www.coldfusionmuse.com/index.cfm/2008/2/12/leaky.heap.jvm If forcing a "stop the world" gc brings your memory back down you are probably worried about it for nothing... Since the JVM will eventually run a full gc on it's own. -Original Message- From: Jason Durham [mailto:[EMAIL PROTECTED] Sent: Friday, May 16, 2008 2:03 PM To: CF-Talk Subject: RE: **UPDATE** JRn 600MB+ shortly after boot up I rebuilt my machine again. This time... no Windows updates, no antivirus, nothing... I immediately downloaded the latest installer from Adobe and installed it (Server config with all IIS websites). JRun is running at 427MB. This can't be right?? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305603 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: **UPDATE** JRn 600MB+ shortly after boot up
If you are using Task Manager to judge sizes then be sure to notice the difference between "Mem Usage" and "VM Size"... Mem Usage is the amount of physical ram currently in use by a process, but VM Size is, well, different. If you have less physical ram on a machine then you may see less Mem Usage but more VM Size (and probably lots of page faults as memory is swapped in and out, seen in Task Manager as "PF Delta"). I always show both Mem Usage and VM Size in Task Manager to get a better picture of actual memory requirements. Thanks Mark -Original Message- From: Jason Durham [mailto:[EMAIL PROTECTED] Sent: Monday, May 19, 2008 9:11 AM To: CF-Talk Subject: RE: **UPDATE** JRn 600MB+ shortly after boot up It seems odd to me because Jrun uses significantly less memory on both of my other development machines (my 1GB laptop runs at under 75MB on Vista Ultimate). The numbers I've been quoting are from Jrun just after boot (idle, no applications loaded) or after only running CFAdmin. Maybe Jrun needs some time to configure itself and requires extra memory when first installed? Maybe the same can be said for when the machine boots? I don't know, I'm merely asking. The new box is now running at 165MB. The settings are default (as verified earlier). I'm content with 165MB. -Original Message- From: Mark Kruger [mailto:[EMAIL PROTECTED] Sent: Friday, May 16, 2008 5:31 PM To: CF-Talk Subject: RE: **UPDATE** JRn 600MB+ shortly after boot up What makes you think that is not right? If your Max is set to 512 and you load something as an application, the JVM will determine when to recover memory based on it's own timetable and settings. 427 megs could indeed be appropriate depending on the settings. There are some code snippets on this post that you can use to fiddle with the JVM gc operations - although I would not use them in production. http://www.coldfusionmuse.com/index.cfm/2008/2/12/leaky.heap.jvm If forcing a "stop the world" gc brings your memory back down you are probably worried about it for nothing... Since the JVM will eventually run a full gc on it's own. -Original Message- From: Jason Durham [mailto:[EMAIL PROTECTED] Sent: Friday, May 16, 2008 2:03 PM To: CF-Talk Subject: RE: **UPDATE** JRn 600MB+ shortly after boot up I rebuilt my machine again. This time... no Windows updates, no antivirus, nothing... I immediately downloaded the latest installer from Adobe and installed it (Server config with all IIS websites). JRun is running at 427MB. This can't be right?? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305599 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: **UPDATE** JRn 600MB+ shortly after boot up
It seems odd to me because Jrun uses significantly less memory on both of my other development machines (my 1GB laptop runs at under 75MB on Vista Ultimate). The numbers I've been quoting are from Jrun just after boot (idle, no applications loaded) or after only running CFAdmin. Maybe Jrun needs some time to configure itself and requires extra memory when first installed? Maybe the same can be said for when the machine boots? I don't know, I'm merely asking. The new box is now running at 165MB. The settings are default (as verified earlier). I'm content with 165MB. -Original Message- From: Mark Kruger [mailto:[EMAIL PROTECTED] Sent: Friday, May 16, 2008 5:31 PM To: CF-Talk Subject: RE: **UPDATE** JRn 600MB+ shortly after boot up What makes you think that is not right? If your Max is set to 512 and you load something as an application, the JVM will determine when to recover memory based on it's own timetable and settings. 427 megs could indeed be appropriate depending on the settings. There are some code snippets on this post that you can use to fiddle with the JVM gc operations - although I would not use them in production. http://www.coldfusionmuse.com/index.cfm/2008/2/12/leaky.heap.jvm If forcing a "stop the world" gc brings your memory back down you are probably worried about it for nothing... Since the JVM will eventually run a full gc on it's own. -Original Message- From: Jason Durham [mailto:[EMAIL PROTECTED] Sent: Friday, May 16, 2008 2:03 PM To: CF-Talk Subject: RE: **UPDATE** JRn 600MB+ shortly after boot up I rebuilt my machine again. This time... no Windows updates, no antivirus, nothing... I immediately downloaded the latest installer from Adobe and installed it (Server config with all IIS websites). JRun is running at 427MB. This can't be right?? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305598 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: **UPDATE** JRn 600MB+ shortly after boot up
What makes you think that is not right? If your Max is set to 512 and you load something as an application, the JVM will determine when to recover memory based on it's own timetable and settings. 427 megs could indeed be appropriate depending on the settings. There are some code snippets on this post that you can use to fiddle with the JVM gc operations - although I would not use them in production. http://www.coldfusionmuse.com/index.cfm/2008/2/12/leaky.heap.jvm If forcing a "stop the world" gc brings your memory back down you are probably worried about it for nothing... Since the JVM will eventually run a full gc on it's own. -Original Message- From: Jason Durham [mailto:[EMAIL PROTECTED] Sent: Friday, May 16, 2008 2:03 PM To: CF-Talk Subject: RE: **UPDATE** JRn 600MB+ shortly after boot up I rebuilt my machine again. This time... no Windows updates, no antivirus, nothing... I immediately downloaded the latest installer from Adobe and installed it (Server config with all IIS websites). JRun is running at 427MB. This can't be right?? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305539 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: **UPDATE** JRn 600MB+ shortly after boot up
Yessir. I also tried a copy of 8.0.1 I downloaded on April 24th. -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Friday, May 16, 2008 4:05 PM To: CF-Talk Subject: RE: **UPDATE** JRn 600MB+ shortly after boot up Just curious. Have you tried redownloading ColdFusion on your fresh installs? -Original Message- From: Jason Durham [mailto:[EMAIL PROTECTED] Sent: Friday, May 16, 2008 4:02 PM To: CF-Talk Subject: RE: **UPDATE** JRn 600MB+ shortly after boot up My jvm.config file is unchanged from the initial install (512 max). When the machine was running on Win XP SP2, I constantly received an error from CF saying cfloop or cfoutput was taking too long. In both cases, it was referencing files in the Fusebox 5.1 core. I couldn't load an app that I've been working on nearly 6 months. I first verified it wasn't code related and then rolled back JVM to 1.5_13/14. JRun was still eating a ton of memory and consequently, I couldn't get my app to load. My app loads since the latest rebuild. I'm going to leave it alone as long as I don't experience time out issues again. From: Gaulin, Mark [mailto:[EMAIL PROTECTED] Sent: Fri 5/16/2008 3:39 PM To: CF-Talk Subject: RE: **UPDATE** JRn 600MB+ shortly after boot up I haven't been reading this thread closely, but is there a specific reason that you think that the JVM shouldn't be that big? For instance, I have set jvm.config to start jrun with a good chunk of memory right at start up (using -Xms). Perhaps your's is set that way too? Have you looked at how much memory the *jvm* has free (vs the size of the jrun.exe *process*)? (If you already covered this then I apologize...) Thanks Mark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305535 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: **UPDATE** JRn 600MB+ shortly after boot up
I have viewed the memory usage in the server monitor. It was between 375-400MB and would dip periodically only to climb back up where it was after 20-30 seconds. I'm now running ColdBox samples and my own Fusebox app with JRun cruising at 135MB. I'm not sure what the fix was. *shrugs* I'm on a E6600 2.4ghz Core 2 Duo w/ 2GB of RAM. -Original Message- From: Matthew Williams [mailto:[EMAIL PROTECTED] Sent: Friday, May 16, 2008 4:21 PM To: CF-Talk Subject: Re: **UPDATE** JRn 600MB+ shortly after boot up I don't think what you're seeing is abnormal. I've got the default JVM configs running as well, and my JRun is running at 522 Megs. I'm running a the FarCry framework (lots of objects). I bet if you had a server monitor running, you'd see that used memory is far lower than the memory that it has acquired by the JVM. This is on a Dell AMD 64x2 with 2 Gigs of RAM laptop. However, our production servers also exhibit the same behavior. Right now, my used memory (according to the CF8 monitor) is about 300 megs. Matthew Williams Geodesic GraFX www.geodesicgrafx.com/blog ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305534 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: **UPDATE** JRn 600MB+ shortly after boot up
I don't think what you're seeing is abnormal. I've got the default JVM configs running as well, and my JRun is running at 522 Megs. I'm running a the FarCry framework (lots of objects). I bet if you had a server monitor running, you'd see that used memory is far lower than the memory that it has acquired by the JVM. This is on a Dell AMD 64x2 with 2 Gigs of RAM laptop. However, our production servers also exhibit the same behavior. Right now, my used memory (according to the CF8 monitor) is about 300 megs. Matthew Williams Geodesic GraFX www.geodesicgrafx.com/blog ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305533 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: **UPDATE** JRn 600MB+ shortly after boot up
Just curious. Have you tried redownloading ColdFusion on your fresh installs? -Original Message- From: Jason Durham [mailto:[EMAIL PROTECTED] Sent: Friday, May 16, 2008 4:02 PM To: CF-Talk Subject: RE: **UPDATE** JRn 600MB+ shortly after boot up My jvm.config file is unchanged from the initial install (512 max). When the machine was running on Win XP SP2, I constantly received an error from CF saying cfloop or cfoutput was taking too long. In both cases, it was referencing files in the Fusebox 5.1 core. I couldn't load an app that I've been working on nearly 6 months. I first verified it wasn't code related and then rolled back JVM to 1.5_13/14. JRun was still eating a ton of memory and consequently, I couldn't get my app to load. My app loads since the latest rebuild. I'm going to leave it alone as long as I don't experience time out issues again. From: Gaulin, Mark [mailto:[EMAIL PROTECTED] Sent: Fri 5/16/2008 3:39 PM To: CF-Talk Subject: RE: **UPDATE** JRn 600MB+ shortly after boot up I haven't been reading this thread closely, but is there a specific reason that you think that the JVM shouldn't be that big? For instance, I have set jvm.config to start jrun with a good chunk of memory right at start up (using -Xms). Perhaps your's is set that way too? Have you looked at how much memory the *jvm* has free (vs the size of the jrun.exe *process*)? (If you already covered this then I apologize...) Thanks Mark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305532 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: **UPDATE** JRn 600MB+ shortly after boot up
My jvm.config file is unchanged from the initial install (512 max). When the machine was running on Win XP SP2, I constantly received an error from CF saying cfloop or cfoutput was taking too long. In both cases, it was referencing files in the Fusebox 5.1 core. I couldn't load an app that I've been working on nearly 6 months. I first verified it wasn't code related and then rolled back JVM to 1.5_13/14. JRun was still eating a ton of memory and consequently, I couldn't get my app to load. My app loads since the latest rebuild. I'm going to leave it alone as long as I don't experience time out issues again. From: Gaulin, Mark [mailto:[EMAIL PROTECTED] Sent: Fri 5/16/2008 3:39 PM To: CF-Talk Subject: RE: **UPDATE** JRn 600MB+ shortly after boot up I haven't been reading this thread closely, but is there a specific reason that you think that the JVM shouldn't be that big? For instance, I have set jvm.config to start jrun with a good chunk of memory right at start up (using -Xms). Perhaps your's is set that way too? Have you looked at how much memory the *jvm* has free (vs the size of the jrun.exe *process*)? (If you already covered this then I apologize...) Thanks Mark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305531 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: **UPDATE** JRn 600MB+ shortly after boot up
I haven't been reading this thread closely, but is there a specific reason that you think that the JVM shouldn't be that big? For instance, I have set jvm.config to start jrun with a good chunk of memory right at start up (using -Xms). Perhaps your's is set that way too? Have you looked at how much memory the *jvm* has free (vs the size of the jrun.exe *process*)? (If you already covered this then I apologize...) Thanks Mark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305529 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: **UPDATE** JRun 600MB+ shortly after boot up
I have 2GB. 600MB on JRun equated to about 80% utilization on XP. On Vista, with JRun at 363MB, I'm at 60% utilization. I'm on newegg.com right now ordering two more 1GB sticks. :) From: Russ [mailto:[EMAIL PROTECTED] Sent: Fri 5/16/2008 3:08 PM To: CF-Talk Subject: RE: **UPDATE** JRun 600MB+ shortly after boot up Maybe it has to do with memory utilization in general. How much ram do you have and what's the utilization like? Russ > -Original Message- > From: Jason Durham [mailto:[EMAIL PROTECTED] > Sent: Friday, May 16, 2008 3:40 PM > To: CF-Talk > Subject: RE: **UPDATE** JRun 600MB+ shortly after boot up > > The reason why I rebuilt the machine was because JRun was running at 600MB > on Windows XP SP2. Jrun memory utilization seems on par with my WinXP box > except for... Jrun just dipped to 271MB while the machine sat idle. Upon > logging into CF Admin, it jumped to 295MB. These still seem a little high > to me but it's nearly half of what I was dealing with before. I'm afraid > to try to launch one of my own apps. heh > > > > > From: Russ [mailto:[EMAIL PROTECTED] > Sent: Fri 5/16/2008 2:33 PM > To: CF-Talk > Subject: RE: **UPDATE** JRun 600MB+ shortly after boot up > > > > I noticed a certain thing about Vista. On my machine, while I still have > a > lot of RAM, processes will start using a lot of RAM. Once it hits 100% > utilization, it seems to swap things out to disk, and processes seem to > take > up a lot less ram. > > Right now each of my instances of JRUN is taking up 400-500MB. I am at > 70% > memory utilization. > > I just started a VMWare instance to force the memory utilization over > 100%. > Vista froze for a few minutes (presumably doing some swapping), and now my > JRUN instances are taking up about 10M each. > > I think this is a Vista thing, and has something to do with the memory > that > processes allocate and the memory they actually use. You might not be > hitting 100% RAM utilization, and it's not swapping things out to file > quite > yet, which is why you're seeing such a high memory usage for JRUN. > > These are of course just theories, perhaps someone more informed can shed > more light on the subject? > > Russ > > > -Original Message- > > From: Jason Durham [mailto:[EMAIL PROTECTED] > > Sent: Friday, May 16, 2008 3:12 PM > > To: CF-Talk > > Subject: RE: **UPDATE** JRun 600MB+ shortly after boot up > > > > I just did another fresh install of Vista. I immediately downloaded and > > installed ColdFusion from Adobe's site. I used the stand alone server > > option with all IIS websites. Jrun is at 427MB. > > > > > > > > > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305517 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: **UPDATE** JRun 600MB+ shortly after boot up
Maybe it has to do with memory utilization in general. How much ram do you have and what's the utilization like? Russ > -Original Message- > From: Jason Durham [mailto:[EMAIL PROTECTED] > Sent: Friday, May 16, 2008 3:40 PM > To: CF-Talk > Subject: RE: **UPDATE** JRun 600MB+ shortly after boot up > > The reason why I rebuilt the machine was because JRun was running at 600MB > on Windows XP SP2. Jrun memory utilization seems on par with my WinXP box > except for... Jrun just dipped to 271MB while the machine sat idle. Upon > logging into CF Admin, it jumped to 295MB. These still seem a little high > to me but it's nearly half of what I was dealing with before. I'm afraid > to try to launch one of my own apps. heh > > > > > From: Russ [mailto:[EMAIL PROTECTED] > Sent: Fri 5/16/2008 2:33 PM > To: CF-Talk > Subject: RE: **UPDATE** JRun 600MB+ shortly after boot up > > > > I noticed a certain thing about Vista. On my machine, while I still have > a > lot of RAM, processes will start using a lot of RAM. Once it hits 100% > utilization, it seems to swap things out to disk, and processes seem to > take > up a lot less ram. > > Right now each of my instances of JRUN is taking up 400-500MB. I am at > 70% > memory utilization. > > I just started a VMWare instance to force the memory utilization over > 100%. > Vista froze for a few minutes (presumably doing some swapping), and now my > JRUN instances are taking up about 10M each. > > I think this is a Vista thing, and has something to do with the memory > that > processes allocate and the memory they actually use. You might not be > hitting 100% RAM utilization, and it's not swapping things out to file > quite > yet, which is why you're seeing such a high memory usage for JRUN. > > These are of course just theories, perhaps someone more informed can shed > more light on the subject? > > Russ > > > -Original Message- > > From: Jason Durham [mailto:[EMAIL PROTECTED] > > Sent: Friday, May 16, 2008 3:12 PM > > To: CF-Talk > > Subject: RE: **UPDATE** JRun 600MB+ shortly after boot up > > > > I just did another fresh install of Vista. I immediately downloaded and > > installed ColdFusion from Adobe's site. I used the stand alone server > > option with all IIS websites. Jrun is at 427MB. > > > > > > > > > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305516 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: **UPDATE** JRun 600MB+ shortly after boot up
The reason why I rebuilt the machine was because JRun was running at 600MB on Windows XP SP2. Jrun memory utilization seems on par with my WinXP box except for... Jrun just dipped to 271MB while the machine sat idle. Upon logging into CF Admin, it jumped to 295MB. These still seem a little high to me but it's nearly half of what I was dealing with before. I'm afraid to try to launch one of my own apps. heh From: Russ [mailto:[EMAIL PROTECTED] Sent: Fri 5/16/2008 2:33 PM To: CF-Talk Subject: RE: **UPDATE** JRun 600MB+ shortly after boot up I noticed a certain thing about Vista. On my machine, while I still have a lot of RAM, processes will start using a lot of RAM. Once it hits 100% utilization, it seems to swap things out to disk, and processes seem to take up a lot less ram. Right now each of my instances of JRUN is taking up 400-500MB. I am at 70% memory utilization. I just started a VMWare instance to force the memory utilization over 100%. Vista froze for a few minutes (presumably doing some swapping), and now my JRUN instances are taking up about 10M each. I think this is a Vista thing, and has something to do with the memory that processes allocate and the memory they actually use. You might not be hitting 100% RAM utilization, and it's not swapping things out to file quite yet, which is why you're seeing such a high memory usage for JRUN. These are of course just theories, perhaps someone more informed can shed more light on the subject? Russ > -Original Message- > From: Jason Durham [mailto:[EMAIL PROTECTED] > Sent: Friday, May 16, 2008 3:12 PM > To: CF-Talk > Subject: RE: **UPDATE** JRun 600MB+ shortly after boot up > > I just did another fresh install of Vista. I immediately downloaded and > installed ColdFusion from Adobe's site. I used the stand alone server > option with all IIS websites. Jrun is at 427MB. > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305511 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: **UPDATE** JRun 600MB+ shortly after boot up
I noticed a certain thing about Vista. On my machine, while I still have a lot of RAM, processes will start using a lot of RAM. Once it hits 100% utilization, it seems to swap things out to disk, and processes seem to take up a lot less ram. Right now each of my instances of JRUN is taking up 400-500MB. I am at 70% memory utilization. I just started a VMWare instance to force the memory utilization over 100%. Vista froze for a few minutes (presumably doing some swapping), and now my JRUN instances are taking up about 10M each. I think this is a Vista thing, and has something to do with the memory that processes allocate and the memory they actually use. You might not be hitting 100% RAM utilization, and it's not swapping things out to file quite yet, which is why you're seeing such a high memory usage for JRUN. These are of course just theories, perhaps someone more informed can shed more light on the subject? Russ > -Original Message- > From: Jason Durham [mailto:[EMAIL PROTECTED] > Sent: Friday, May 16, 2008 3:12 PM > To: CF-Talk > Subject: RE: **UPDATE** JRun 600MB+ shortly after boot up > > I just did another fresh install of Vista. I immediately downloaded and > installed ColdFusion from Adobe's site. I used the stand alone server > option with all IIS websites. Jrun is at 427MB. > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305508 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: **UPDATE** JRun 600MB+ shortly after boot up
I just did another fresh install of Vista. I immediately downloaded and installed ColdFusion from Adobe's site. I used the stand alone server option with all IIS websites. Jrun is at 427MB. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305501 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: **UPDATE** JRun 600MB+ shortly after boot up
I rebuilt my machine again. This time... no Windows updates, no antivirus, nothing... I immediately downloaded the latest installer from Adobe and installed it (Server config with all IIS websites). JRun is running at 427MB. This can't be right?? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305499 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: **UPDATE** JRn 600MB+ shortly after boot up
I rebuilt my machine again. This time... no Windows updates, no antivirus, nothing... I immediately downloaded the latest installer from Adobe and installed it (Server config with all IIS websites). JRun is running at 427MB. This can't be right?? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305498 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: **UPDATE** JRun 600MB+ shortly after boot up
I just tried to call SeeFusion but got a voicemail and didn't leave a message. I have SeeFusion.jar and seefusesion.properties but no Tools.jar. I've uninstalled every 3rd party application now and even reinstalled ColdFusion. Frustration is really setting in... :) From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Fri 5/16/2008 10:57 AM To: CF-Talk Subject: RE: **UPDATE** JRun 600MB+ shortly after boot up Actually, SeeFusion doesn't use IIS. It has a small built-in web server that listens on 8999 instead of port 80. Check your server logs to see if there were startup errors. Seefusion.jar and tools.jar should be in your /wwwroot\WEB-INF\lib directory, and seefusion.properties should be in \wwwroot\WEB-INF\classes Then you should be able to do: http://ip.address.here:8999 <http://ip.address.here:8999/> once you restart CF. I've always been able to reach the SeeFusion guys on the phone too if I have problems. ~Brad -Original Message- From: Jason Durham [mailto:[EMAIL PROTECTED] Sent: Friday, May 16, 2008 10:31 AM To: CF-Talk Subject: RE: **UPDATE** JRun 600MB+ shortly after boot up I installed SeeFusion without error but localhost:8999 gets me a 404. Perhaps SeeFusion isn't ready to run on IIS 7? -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Friday, May 16, 2008 10:10 AM To: CF-Talk Subject: RE: **UPDATE** JRun 600MB+ shortly after boot up Jason, have you specified if you have CF Enterprise or Standard? I re-read the thread and didn't see... Can you get some thread dumps from the JVM to see what it is doing during this time? SeeFusion can be trialed for free two hours at a time. Maybe something like that could give you a window into what is going on. ~Brad -Original Message- From: Jason Durham [mailto:[EMAIL PROTECTED] Sent: Friday, May 16, 2008 10:04 AM To: CF-Talk Subject: RE: **UPDATE** JRun 600MB+ shortly after boot up Uninstalled McAfee and still have the same problem. I'll keep uninstalling applications until someone offers another suggestion. :) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305476 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: **UPDATE** JRun 600MB+ shortly after boot up
Actually, SeeFusion doesn't use IIS. It has a small built-in web server that listens on 8999 instead of port 80. Check your server logs to see if there were startup errors. Seefusion.jar and tools.jar should be in your /wwwroot\WEB-INF\lib directory, and seefusion.properties should be in \wwwroot\WEB-INF\classes Then you should be able to do: http://ip.address.here:8999 once you restart CF. I've always been able to reach the SeeFusion guys on the phone too if I have problems. ~Brad -Original Message- From: Jason Durham [mailto:[EMAIL PROTECTED] Sent: Friday, May 16, 2008 10:31 AM To: CF-Talk Subject: RE: **UPDATE** JRun 600MB+ shortly after boot up I installed SeeFusion without error but localhost:8999 gets me a 404. Perhaps SeeFusion isn't ready to run on IIS 7? -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Friday, May 16, 2008 10:10 AM To: CF-Talk Subject: RE: **UPDATE** JRun 600MB+ shortly after boot up Jason, have you specified if you have CF Enterprise or Standard? I re-read the thread and didn't see... Can you get some thread dumps from the JVM to see what it is doing during this time? SeeFusion can be trialed for free two hours at a time. Maybe something like that could give you a window into what is going on. ~Brad -Original Message- From: Jason Durham [mailto:[EMAIL PROTECTED] Sent: Friday, May 16, 2008 10:04 AM To: CF-Talk Subject: RE: **UPDATE** JRun 600MB+ shortly after boot up Uninstalled McAfee and still have the same problem. I'll keep uninstalling applications until someone offers another suggestion. :) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305458 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: **UPDATE** JRun 600MB+ shortly after boot up
I installed SeeFusion without error but localhost:8999 gets me a 404. Perhaps SeeFusion isn't ready to run on IIS 7? -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Friday, May 16, 2008 10:10 AM To: CF-Talk Subject: RE: **UPDATE** JRun 600MB+ shortly after boot up Jason, have you specified if you have CF Enterprise or Standard? I re-read the thread and didn't see... Can you get some thread dumps from the JVM to see what it is doing during this time? SeeFusion can be trialed for free two hours at a time. Maybe something like that could give you a window into what is going on. ~Brad -Original Message- From: Jason Durham [mailto:[EMAIL PROTECTED] Sent: Friday, May 16, 2008 10:04 AM To: CF-Talk Subject: RE: **UPDATE** JRun 600MB+ shortly after boot up Uninstalled McAfee and still have the same problem. I'll keep uninstalling applications until someone offers another suggestion. :) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305444 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: **UPDATE** JRun 600MB+ shortly after boot up
I'm running CF Standard in Developer mode. I'll take a look at SeeFusion. Thank you. BTW, I just uninstalled MS SQL, MySQL, Silverlight, and Trillian without any affect. -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Friday, May 16, 2008 10:10 AM To: CF-Talk Subject: RE: **UPDATE** JRun 600MB+ shortly after boot up Jason, have you specified if you have CF Enterprise or Standard? I re-read the thread and didn't see... Can you get some thread dumps from the JVM to see what it is doing during this time? SeeFusion can be trialed for free two hours at a time. Maybe something like that could give you a window into what is going on. ~Brad -Original Message- From: Jason Durham [mailto:[EMAIL PROTECTED] Sent: Friday, May 16, 2008 10:04 AM To: CF-Talk Subject: RE: **UPDATE** JRun 600MB+ shortly after boot up Uninstalled McAfee and still have the same problem. I'll keep uninstalling applications until someone offers another suggestion. :) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305441 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: **UPDATE** JRun 600MB+ shortly after boot up
Jason, have you specified if you have CF Enterprise or Standard? I re-read the thread and didn't see... Can you get some thread dumps from the JVM to see what it is doing during this time? SeeFusion can be trialed for free two hours at a time. Maybe something like that could give you a window into what is going on. ~Brad -Original Message- From: Jason Durham [mailto:[EMAIL PROTECTED] Sent: Friday, May 16, 2008 10:04 AM To: CF-Talk Subject: RE: **UPDATE** JRun 600MB+ shortly after boot up Uninstalled McAfee and still have the same problem. I'll keep uninstalling applications until someone offers another suggestion. :) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305432 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: **UPDATE** JRun 600MB+ shortly after boot up
Uninstalled McAfee and still have the same problem. I'll keep uninstalling applications until someone offers another suggestion. :) -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Friday, May 16, 2008 9:57 AM To: CF-Talk Subject: RE: **UPDATE** JRun 600MB+ shortly after boot up Might the McAfee software somehow be involved in the problem? Disable it and give it a try? > -Original Message- > From: Jason Durham [mailto:[EMAIL PROTECTED] > Sent: Friday, May 16, 2008 10:42 AM > To: CF-Talk > Subject: RE: **UPDATE** JRun 600MB+ shortly after boot up > > I should also add that Vista has all of its shots (read: updates). The > applications that I've installed on this machine are... > > Adobe CS3 Design Premium > MS Office 2007 Enterprise > MySQL 5.0 w/ MySQL Admin & Query Browser > MS SQL Express w/ Management Studio > McAfee Total Protection for Small Business > Trillian (IM software) > MS Silverlight > Firefox 2.0.14 > Toshiba Net Phone (GUI that works with our phone system) > JDK/JRE 5.0 Update 14 > Flash Player 9 > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305423 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: **UPDATE** JRun 600MB+ shortly after boot up
Might the McAfee software somehow be involved in the problem? Disable it and give it a try? > -Original Message- > From: Jason Durham [mailto:[EMAIL PROTECTED] > Sent: Friday, May 16, 2008 10:42 AM > To: CF-Talk > Subject: RE: **UPDATE** JRun 600MB+ shortly after boot up > > I should also add that Vista has all of its shots (read: updates). The > applications that I've installed on this machine are... > > Adobe CS3 Design Premium > MS Office 2007 Enterprise > MySQL 5.0 w/ MySQL Admin & Query Browser > MS SQL Express w/ Management Studio > McAfee Total Protection for Small Business > Trillian (IM software) > MS Silverlight > Firefox 2.0.14 > Toshiba Net Phone (GUI that works with our phone system) > JDK/JRE 5.0 Update 14 > Flash Player 9 > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305417 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: **UPDATE** JRun 600MB+ shortly after boot up
I should also add that Vista has all of its shots (read: updates). The applications that I've installed on this machine are... Adobe CS3 Design Premium MS Office 2007 Enterprise MySQL 5.0 w/ MySQL Admin & Query Browser MS SQL Express w/ Management Studio McAfee Total Protection for Small Business Trillian (IM software) MS Silverlight Firefox 2.0.14 Toshiba Net Phone (GUI that works with our phone system) JDK/JRE 5.0 Update 14 Flash Player 9 -Original Message- From: Jason Durham Sent: Friday, May 16, 2008 9:35 AM To: 'cf-talk@houseoffusion.com' Subject: RE:**UPDATE** JRun 600MB+ shortly after boot up Completely rebuilt the machine. I'm running Windows *cough*Vista*cough* SP1 32-Bit with, of course, IIS7. IIS7 doesn't know what to do with ..cfm/.cfc file types but after adding some handler mappings, I was off and running into CF Admin. The Task Manager said that Jrun was using about 140 MB. I can't recall if it was at 140MB before/after I first launched CF Admin. I copied a couple of simple CF sites into the web root but didn't open any of them in a browser. I noticed my PC performance gadget was showing a ton of memory being used. Task Manager confirmed that Jrun was running at 518MB. Back to where I started... I moved all of my sites back out of the web root and removed the handler mappings for .cfm/.cfc. Restarted both IIS and CF. Jrun still climbs to 518MB. I installed JDK 1.5.0_14 and edited my jvm.config file to point to the installation path (and restarted CF). Then I recreated the handler mapping in IIS for .cfm and logged into CF Admin. My settings summary indicates I'm running on Java Version 1.5.0_14. JRun is currently running 550MB with only CF Admin in CFIDE, cfdocs and aspnet_client in the web root. I edited my jvm.config file with... -Xms512m -Xmx756m Now Jrun is at 577MB after launching CF Admin. Any help is *greatly* appreciated. Jason ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305414 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE:**UPDATE** JRun 600MB+ shortly after boot up
Completely rebuilt the machine. I'm running Windows *cough*Vista*cough* SP1 32-Bit with, of course, IIS7. IIS7 doesn't know what to do with ..cfm/.cfc file types but after adding some handler mappings, I was off and running into CF Admin. The Task Manager said that Jrun was using about 140 MB. I can't recall if it was at 140MB before/after I first launched CF Admin. I copied a couple of simple CF sites into the web root but didn't open any of them in a browser. I noticed my PC performance gadget was showing a ton of memory being used. Task Manager confirmed that Jrun was running at 518MB. Back to where I started... I moved all of my sites back out of the web root and removed the handler mappings for .cfm/.cfc. Restarted both IIS and CF. Jrun still climbs to 518MB. I installed JDK 1.5.0_14 and edited my jvm.config file to point to the installation path (and restarted CF). Then I recreated the handler mapping in IIS for .cfm and logged into CF Admin. My settings summary indicates I'm running on Java Version 1.5.0_14. JRun is currently running 550MB with only CF Admin in CFIDE, cfdocs and aspnet_client in the web root. I edited my jvm.config file with... -Xms512m -Xmx756m Now Jrun is at 577MB after launching CF Admin. Any help is *greatly* appreciated. Jason -Original Message- From: Mark Kruger [mailto:[EMAIL PROTECTED] Sent: Thursday, May 15, 2008 12:47 PM To: CF-Talk Subject: RE: JRun 600MB+ shortly after boot up Jason, Ok... Maybe your heap size isn't big enough to instantiate the ap... It must be a real whopper :) Try editing your jvm.config file. Add -Xms512m -Xmx756m To the server args and restart... See if increasing the heap will help you bring it up. It's not 64 bit is it? -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Jason Durham [mailto:[EMAIL PROTECTED] Sent: Thursday, May 15, 2008 8:59 AM To: CF-Talk Subject: RE: JRun 600MB+ shortly after boot up Thanks for the suggestion however James Holmes beat you to it. Unfortunately, running on 1.5_13 and 1.5_14 has the same results. Jrun hovers around 400MB until I try to initialize my first app. -Original Message- From: Mark Kruger [mailto:[EMAIL PROTECTED] Sent: Thursday, May 15, 2008 8:27 AM To: CF-Talk Subject: RE: JRun 600MB+ shortly after boot up Jason, Ah... Since it chokes on object creation this looks like it could be the class loader issue that everyone yammers about with JVM 1.6. Try rollling back to 1.5. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Jason Durham [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 14, 2008 8:49 PM To: CF-Talk Subject: RE: JRun 600MB+ shortly after boot up Here is a link to the error I receive when trying to load the index. The fusebox files haven't been altered except for a couple of variable values. http://www.durhamcons.com/error.htm -Original Message- From: Mark Kruger [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 14, 2008 8:34 PM To: CF-Talk Subject: RE: JRun 600MB+ shortly after boot up Yep... That's the default all right. Did you make any changes to the JVM files - upgrade to a new version for example? Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305412 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Update multiple Records
I wrote up a complete tutorial on how to do this over at easyCFM a few years ago. http://tutorial214.easycfm.com/ Don't hate me for using evaluate() :-) -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304683 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Update multiple Records
Or again... just use the same loop that you used to build the fields... to read them. ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Azadi Saryev [mailto:[EMAIL PROTECTED] Sent: Friday, May 02, 2008 2:25 PM To: CF-Talk Subject: Re: Update multiple Records if your fields are named something like newcost_#id#: loop through form.fieldnames => get each field's name if field name matches a pattern (i.e. left(fieldname, 7) eq "newcost_"), treat it as _-delimited list to get the id from it Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Jason Congerton wrote: > Hi All > > Sorry i think i am being a bit thick here!! but how do i get the id from the form name as i can only access the value of the form field in my action page. > > Jason > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304680 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Update multiple Records
if your fields are named something like newcost_#id#: loop through form.fieldnames => get each field's name if field name matches a pattern (i.e. left(fieldname, 7) eq "newcost_"), treat it as _-delimited list to get the id from it Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Jason Congerton wrote: > Hi All > > Sorry i think i am being a bit thick here!! but how do i get the id from the > form name as i can only access the value of the form field in my action page. > > Jason > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304673 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Update multiple Records
> Sorry i think i am being a bit thick here!! but how do i get the id from > the form name as i can only access the value of the form field in my > action page. You can access the form field name by either looping over the form as a collection, or looping over the property FIELDNAMES. Here is what the former might look like: -- Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304672 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Update multiple Records
Hi All Sorry i think i am being a bit thick here!! but how do i get the id from the form name as i can only access the value of the form field in my action page. Jason > Hi > > I need to update the price of multiple products using one form i.e > > Product Price > ShoesUpdateable Text Field > Trainers Updateable Text Field > etc > > I was going to name the text field newCost and loop through the list, > but i obviously need to pass the id as well. Would it be best to name > the text box with the id paramenter so each text box is unique? And > then loop through the form results matching the id before inserting > the form value?? > > Jason ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304671 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Update multiple Records
Excellent thanks for the prompt responses > Hi > > I need to update the price of multiple products using one form i.e > > Product Price > ShoesUpdateable Text Field > Trainers Updateable Text Field > etc > > I was going to name the text field newCost and loop through the list, > but i obviously need to pass the id as well. Would it be best to name > the text box with the id paramenter so each text box is unique? And > then loop through the form results matching the id before inserting > the form value?? > > Jason ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304650 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Update multiple Records
Oops, those cfparams need the values to be #price# ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Friday, May 02, 2008 10:57 AM To: CF-Talk Subject: RE: Update multiple Records You got the idea. Just cfloop the ids into field names Then use the same query and loop to parse them in the action template Update table Set price = This has nothing to do with your problem but I would consider changing the price datatype from text to some kind of numeric or currentcy type. ...:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Jason Congerton [mailto:[EMAIL PROTECTED] Sent: Friday, May 02, 2008 10:34 AM To: CF-Talk Subject: Update multiple Records Hi I need to update the price of multiple products using one form i.e Product Price ShoesUpdateable Text Field Trainers Updateable Text Field etc I was going to name the text field newCost and loop through the list, but i obviously need to pass the id as well. Would it be best to name the text box with the id paramenter so each text box is unique? And then loop through the form results matching the id before inserting the form value?? Jason ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304647 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Update multiple Records
You got the idea. Just cfloop the ids into field names Then use the same query and loop to parse them in the action template Update table Set price = This has nothing to do with your problem but I would consider changing the price datatype from text to some kind of numeric or currentcy type. ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Jason Congerton [mailto:[EMAIL PROTECTED] Sent: Friday, May 02, 2008 10:34 AM To: CF-Talk Subject: Update multiple Records Hi I need to update the price of multiple products using one form i.e Product Price ShoesUpdateable Text Field Trainers Updateable Text Field etc I was going to name the text field newCost and loop through the list, but i obviously need to pass the id as well. Would it be best to name the text box with the id paramenter so each text box is unique? And then loop through the form results matching the id before inserting the form value?? Jason ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304646 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Update multiple Records
i would have the product id in the text field name for sure, like newcost_#prod_id#. Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Jason Congerton wrote: > Hi > > I need to update the price of multiple products using one form i.e > > Product Price > ShoesUpdateable Text Field > Trainers Updateable Text Field > etc > > I was going to name the text field newCost and loop through the list, but i > obviously need to pass the id as well. Would it be best to name the text box > with the id paramenter so each text box is unique? And then loop through the > form results matching the id before inserting the form value?? > > Jason > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304644 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Update multiple Records
Yeah.. that's how I'd do it.. the text field's name would include a _#id# and use the '_' to find the ID.. Good job On Fri, May 2, 2008 at 9:33 AM, Jason Congerton <[EMAIL PROTECTED]> wrote: > Hi > > I need to update the price of multiple products using one form i.e > > Product Price > ShoesUpdateable Text Field > Trainers Updateable Text Field > etc > > I was going to name the text field newCost and loop through the list, but i > obviously need to pass the id as well. Would it be best to name the text box > with the id paramenter so each text box is unique? And then loop through the > form results matching the id before inserting the form value?? > > Jason > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304643 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: update PDF title
We are using 7 right now. Will possible move to 8 shortly. -Lori -Original Message- From: Stone, Lori Sent: Wednesday, April 09, 2008 9:41 AM To: CF-Talk Subject: update PDF title I have a db with a bunch of pdf files and titles stored. Apparently the file titles are wrong in metadata for the files but not the db. I have to look at the db and then update the file metadata to what is in the db. Anyone done this before? -Lori ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303027 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Update a Current 32/64 bit installation?
We actually had an IIS AND Apache parallel web server installation running on this machine for a while. It seemed to work, but made me nervous. I really want to avoid work-arounds, bells and whistles, tricks, etc. We are running a VM under Linux, but I try to avoid them for production use at this time. Want more experience with potential problems. R. -Original Message- From: Russ [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2008 9:36 AM To: CF-Talk Subject: RE: Update a Current 32/64 bit installation? If you're going to have so much trouble with IIS, why not either a. use apache side by side with IIS on a diff ip b. run either the ASP apps or CF in a VM Russ > -Original Message- > From: Richard Colman [mailto:[EMAIL PROTECTED] > Sent: Friday, April 04, 2008 12:23 PM > To: CF-Talk > Subject: Update a Current 32/64 bit installation? > > After a considerable amount of work, we FINALLY got a mixed > installation running successfully; i.e. 64-bit Windows 2003 server > running 32-bit IIS in emulation mode with CF8 running OK * AND * .NET > applications running (3.5) in 32-bit mode. It is FINALLY working. > > So, now the 8.0.1 update comes out. This means that I probably need to: > > * uninstall CF8 32-bit > * turn off 32-bit IIS emulation > * reinstall the .NET runtimes for 64-bit > * recomnpile all the .NET installations > > Etc. etc. > > I am wondering whether I should just leave it as-is and not worry > about the update? It looks like if I do not do the update now, then I > may not be able to do future updates? > > On the other hand, this server is pre-production and just about to be > launched. If I need to do it, I should do it now. > > Any recommendations would be greatly appreciated. > > Rick Colman > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302736 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Update a Current 32/64 bit installation?
If you're going to have so much trouble with IIS, why not either a. use apache side by side with IIS on a diff ip b. run either the ASP apps or CF in a VM Russ > -Original Message- > From: Richard Colman [mailto:[EMAIL PROTECTED] > Sent: Friday, April 04, 2008 12:23 PM > To: CF-Talk > Subject: Update a Current 32/64 bit installation? > > After a considerable amount of work, we FINALLY got a mixed installation > running successfully; i.e. 64-bit Windows 2003 server running 32-bit IIS > in > emulation mode with CF8 running OK * AND * .NET applications running (3.5) > in 32-bit mode. It is FINALLY working. > > So, now the 8.0.1 update comes out. This means that I probably need to: > > * uninstall CF8 32-bit > * turn off 32-bit IIS emulation > * reinstall the .NET runtimes for 64-bit > * recomnpile all the .NET installations > > Etc. etc. > > I am wondering whether I should just leave it as-is and not worry about > the > update? It looks like if I do not do the update now, then I may not be > able > to do future updates? > > On the other hand, this server is pre-production and just about to be > launched. If I need to do it, I should do it now. > > Any recommendations would be greatly appreciated. > > Rick Colman > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302732 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: UPDATE: Installing and running BlazeDS - install walkthrough fails
The process is similar in multiserver:
1) messaging libraries that you need to move will be under
{server.instance}/cfusion.ear/cfusion.war/WEB-INF/cfusion/lib folder.
2) Move the new ones under the same folder.
3) cfgateway.jar and concurrent.jar should be placed under
{server.instance}/cfusion.ear/cfusion.war/WEB-INF/flex/jars
4) config files should be placed
{server.instance}/cfusion.ear/cfusion.war/WEB-INF/flex
5) comment or remove the definitions/mappings/taglib from the
{server.instance}/cfusion.ear/cfusion.war/WEB-INF/web.xml file.
The difference from multiserver compating with standard is that you can
have instances running CF only, CF + LCDS or CF + BlazeDS.
--
João Fernandes
http://www.onflexwithcf.org
http://www.riapt.org
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301571
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Update database by moving selection up and down
As I said that example is rather old, it looks like the second parameter
should be the name of the field to save the values into. Could just delete
it and hard code the name of the field to save to. I do not have my tag
handy from work right now or I'd just send it to you.
On 10/5/07, erik tom <[EMAIL PROTECTED]> wrote:
>
> >Why do you have Form.requirements in your where clause? You would be
> >looping over a LIST of unique IDs and referencing the loop's index in
> your
> >where clause. Change the index name for the loop and reference that in
> the
> >where clause then see what happens.
> >
> >
> >>
> Nothing is happening. Also I noticed that in the JS function once it hits
> to for loop execution is over. And one more thing onsubmit the function
> required 2 parameters and we passing only 1
> function SetFields(lst,lstSave) {
> var t;
> lstSave.value="";
> for (t=0;t<=lst.length-1;t++){
> lstSave.value+=String(lst.options[t].value)+",";
> if (lstSave.value.length>0)
> lstSave.value=lstSave.value.slice(0,-1);
> }
> }
>
>
~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290397
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Update database by moving selection up and down
>Why do you have Form.requirements in your where clause? You would be
>looping over a LIST of unique IDs and referencing the loop's index in your
>where clause. Change the index name for the loop and reference that in the
>where clause then see what happens.
>
>
>>
Nothing is happening. Also I noticed that in the JS function once it hits to
for loop execution is over. And one more thing onsubmit the function required 2
parameters and we passing only 1
function SetFields(lst,lstSave) {
var t;
lstSave.value="";
for (t=0;t<=lst.length-1;t++){
lstSave.value+=String(lst.options[t].value)+",";
if (lstSave.value.length>0)
lstSave.value=lstSave.value.slice(0,-1);
}
}
~|
ColdFusion is delivering applications solutions at at top companies
around the world in government. Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290392
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Update database by moving selection up and down
Why do you have Form.requirements in your where clause? You would be
looping over a LIST of unique IDs and referencing the loop's index in your
where clause. Change the index name for the loop and reference that in the
where clause then see what happens.
On 10/5/07, erik tom <[EMAIL PROTECTED]> wrote:
>
>
> this code does not work for me. Here is what I did. I copied this function
> function SetFields(lst,lstSave) {
> var t;
> lstSave.value=""
> for (t=0;t<=lst.length-1;t++)
> lstSave.value+=String(lst.options[t].value)+",";
> if (lstSave.value.length>0)
> lstSave.value=lstSave.value.slice(0,-1);
> }
> I added onsubmit="SetFields(document.combo_box.requirements);" to my form
> tag
> I added
> And also added this
>
>
>
>
>
> UPDATE trnAcademicProgramsAndRequirementsMapping
> SET SortOrder = #Order#
> WHERE reqid = #form.requirements# and degreeid=#form.program#
>
>
>
>
> However I do not get any errors but nothing get updated
>
>
>
~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290345
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Update database by moving selection up and down
>Here you go, someone apparently asked me a long time ago since the content
>of my site is probably a good 5 years old. Probably a better way to do
>this, but like I said I just keep reusing the same custom tag for it here
>since it works.
>
>http://www.happyhacker.com/WebDev.cfm?Cat=CF&SubCat=Ordering#StartHere
>
>
>>
this code does not work for me. Here is what I did. I copied this function
function SetFields(lst,lstSave) {
var t;
lstSave.value=""
for (t=0;t<=lst.length-1;t++)
lstSave.value+=String(lst.options[t].value)+",";
if (lstSave.value.length>0)
lstSave.value=lstSave.value.slice(0,-1);
}
I added onsubmit="SetFields(document.combo_box.requirements);" to my form tag
I added
And also added this
UPDATE trnAcademicProgramsAndRequirementsMapping
SET SortOrder = #Order#
WHERE reqid = #form.requirements# and degreeid=#form.program#
However I do not get any errors but nothing get updated
~|
Enterprise web applications, build robust, secure
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290325
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Update database by moving selection up and down
erik tom wrote: > Tell me how. I am calling the function like this name="moveUp" onclick="moveUp(-1)"> and the same for movedown . And it works > my question is how can i update the database > With your "moveUp(-1)" call, are you passing just a -1 or are you also passing whatever unique DB identifier of the item you're trying to move up? If not, you're going to need to do that, at the very least. Or, pass in the unique IDs of the two items affected - i.e. move(#currentItemID#, #previous or next itemID#) (previous if you're doing a move up, next if you're doing a move down) That way you know which two items to switch. Pass those values on to your next script, where you do the DB calls to switch the vals - you get the order-by values for the two IDs, and then update both records with each other's order-by values. SELECT ID, OrderBy FROM yourTable WHERE ID IN (#firstIDpassed#, #secondIDpassed#) UPDATE yourTable SET OrderBy = #getOrderBy.OrderBy[2]# WHERE ID = #getOrderBy.ID[1]# UPDATE yourTable SET OrderBy = #getOrderBy.OrderBy[1]# WHERE ID = #getOrderBy.ID[2]# ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290314 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Update database by moving selection up and down
Here you go, someone apparently asked me a long time ago since the content of my site is probably a good 5 years old. Probably a better way to do this, but like I said I just keep reusing the same custom tag for it here since it works. http://www.happyhacker.com/WebDev.cfm?Cat=CF&SubCat=Ordering#StartHere On 10/5/07, erik tom <[EMAIL PROTECTED]> wrote: > > >I think he is asking how to get what is submitted into the database, not > how > >to submit the form itself. > > > >I am guessing this is just a mult-select being submitted. What I have > done > >in the past is when I submit the form I run a JS function that grabs the > >values(which are the PKs for what is displayed) of my options and > >concatenate them into a list that is passed as a hidden form element. I > >then on the processing side loop through that and update the PK to the > >placement in the list. Might be a much better way to do this, I have > just > >reused the same script for this for the past 8 years or so, never had a > need > >to rewrite it. > > > > > >> > can you provide me with the sample of your script > > ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290306 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Update database by moving selection up and down
>I think he is asking how to get what is submitted into the database, not how >to submit the form itself. > >I am guessing this is just a mult-select being submitted. What I have done >in the past is when I submit the form I run a JS function that grabs the >values(which are the PKs for what is displayed) of my options and >concatenate them into a list that is passed as a hidden form element. I >then on the processing side loop through that and update the PK to the >placement in the list. Might be a much better way to do this, I have just >reused the same script for this for the past 8 years or so, never had a need >to rewrite it. > > >> can you provide me with the sample of your script ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290285 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Update database by moving selection up and down
I think he is asking how to get what is submitted into the database, not how to submit the form itself. I am guessing this is just a mult-select being submitted. What I have done in the past is when I submit the form I run a JS function that grabs the values(which are the PKs for what is displayed) of my options and concatenate them into a list that is passed as a hidden form element. I then on the processing side loop through that and update the PK to the placement in the list. Might be a much better way to do this, I have just reused the same script for this for the past 8 years or so, never had a need to rewrite it. On 10/4/07, Brian Kotek <[EMAIL PROTECTED]> wrote: > > I'm afraid you're not making sense. You want to know how to submit a form > to > the server? Use a submit button. Or a JavaScript function that submits the > form ( > > http://www.javascript-coder.com/javascript-form/javascript-form-submit.phtml > ). > > On 10/4/07, erik tom <[EMAIL PROTECTED]> wrote: > > > > >Submit the form or execute an AJAX request. > > > > > > > > >> > > Tell me how. I am calling the function like this > name="moveUp" onclick="moveUp(-1)"> and the same for movedown . And it > works > > my question is how can i update the database > > > > > > ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290253 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Update database by moving selection up and down
I'm afraid you're not making sense. You want to know how to submit a form to the server? Use a submit button. Or a JavaScript function that submits the form ( http://www.javascript-coder.com/javascript-form/javascript-form-submit.phtml ). On 10/4/07, erik tom <[EMAIL PROTECTED]> wrote: > > >Submit the form or execute an AJAX request. > > > > > >> > Tell me how. I am calling the function like this name="moveUp" onclick="moveUp(-1)"> and the same for movedown . And it works > my question is how can i update the database > > ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290251 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Update database by moving selection up and down
>Submit the form or execute an AJAX request. > > >> Tell me how. I am calling the function like this and the same for movedown . And it works my question is how can i update the database ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290250 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Update database by moving selection up and down
Submit the form or execute an AJAX request.
On 10/4/07, erik tom <[EMAIL PROTECTED]> wrote:
>
> I have a drop down menu which does add remove functions from 1 drop down
> to another , and aslo have up and down arrows which do the respective
> movement. Now I need to find a way how to update the sort order in the
> database if I move the item up/down. The application is written IN CF.
> Here is my move script
> function moveUpDown(to) {
> var list2 = document.forms[0].requirements;
> var index = list2.selectedIndex;
> var total = list2.options.length-1;
> if (index == -1) return false;
> if (to == +1 && index == total) return false;
> if (to == -1 && index == 0) return false;
> var items = new Array;
> var values = new Array;
> for (i = total; i >= 0; i--) {
> items[i] = list2.options[i].text;
> values[i] = list2.options[i].value;
> }
> for (i = total; i >= 0; i--) {
> if (index == i) {
> list2.options[i + to] = new Option(items[i],values[i + to], 0,
> 1);
> list2.options[i] = new Option(items[i + to], values[i]);
> i--;
> }
> else {
> list2.options[i] = new Option(items[i], values[i]);
> }
> }
> list2.focus();
> }
>
>
>
~|
ColdFusion is delivering applications solutions at at top companies
around the world in government. Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290232
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Update Flash Form Grid with Javascript
> I have an involved flash form that I update using getURL() and Spry's > loadURL() to update database records without page refreshing. Part of > this form is a datagrid which binds its data to the user form. > > Is there a way, on a javascript callback event from the Spry loadURL(), > to also refresh the datagrid data without page reload? > > BTW, I am using remote cfcs for both the db updating and query. > > Thanks for everyone's help. > > Joel Anybody have any ideas on this? ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287043 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Update cart items without reloading--AJAX?
Megan, If you want the page to be refreshed without a reload, then the easiest way is to use some form of Ajax call. With that said, I would recommend looking into any of the number of top-notch libraries out their that will make this task easier. These include: jQuery - my personal choice (http://jQuery.com) Prototype (http://prototypejs.org) Spry (http://labs.adobe.com/technologies/spry/) Yahoo User Interface Library (http://developer.yahoo.com/yui/) There are other choices out there but these, IMO, offer the best selection of functionality, documentation, and user support. ColdFusion-specific choices include: AjaxCFC (http://www.robgonda.com/blog/projects/ajaxcfc/) MXAjax (http://www.indiankey.com/mxajax/) JSMX (http://www.lalabird.com/) My personal favorite of the 3 is AjaxCFC. Its extremely easy to implement and now uses jQuery under the hood. That in itself adds a ton of functionality to AjaxCFC. Both MXAjax & JSMX, though, are very good libraries. If you want to learn more about Ajax without the use of a library, then checkout the tutorials here: http://www.maxkiesler.com/index.php/weblog/comments/42_recent_ajax_tutorials/ I'm part of the jQuery team and a big advocate for CF users in that project so I hope to see you on the mailing list. Rey... megan cytron wrote: > Hi forum-- > > My client has a pretty complicated product listing and I would like to set > their cart up so that the customer can click on a button and visually add an > item to a list displayed on the same page, without reloading the page. These > items will be put into a database, as well. It's really crucial that the > customer can see his shopping cart and the list of items for sale on the same > screen. > > This is a site that customers have to log in to use, so I have some leeway > technology-wise--in other words, we don't have to support Netscape 4.5--but > I'm basically looking for the simplest implementation for the lowest common > denominator (within reason). I was thinking of dabbling in AJAX (which I know > next to nothing about)? Or is there a simpler way (aside from using frames, > which I refuse to do...). > > muchas gracias, > > Megan Cytron > Alpha 60 Design Shop > Madrid, Spain > > > > > ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273058 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Update: error emails firing for no reason (I still need help)
No offense taken, none of it is my code anyways. :) I'm just trying to fix a very odd bug. There's some good ideas so far for me to pour through, thanks for the pointers. thanks -r ___ Rob Barthle Sr. Web Developer (Dept. of Ed Contractor) Nortel Government Solutions, Inc. 202-245-6484 [EMAIL PROTECTED] -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 23, 2007 3:53 PM To: CF-Talk Subject: RE: Update: error emails firing for no reason (I still need help) I've never seen that happen before but I'm sure it's caused by some bad code (no offense) but without seeing some code, I doubt anyone can help unless they've seen the exact same thing happen. -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.432 / Virus Database: 268.17.2/641 - Release Date: 1/20/2007 10:24 AM ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267454 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Update: error emails firing for no reason (I still need help)
>>But anywhere from 1-3 seconds later, a GET request is sent from the same IP address for the form submission page, and the listed referring page is the forms processing page. Would you have by any chance some onsubmit function that does a submit() on the form? That would cause the form to be submitted twice. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267410 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Update: error emails firing for no reason (I still need help)
Try using httplook and see if the traffic is really coming from your browser. Russ > -Original Message- > From: Richard Cooper [mailto:[EMAIL PROTECTED] > Sent: Tuesday, January 23, 2007 3:48 PM > To: CF-Talk > Subject: Re: Update: error emails firing for no reason (I still need help) > > I seem to remeber a colleague had a similar problem before (not 100% on > this). I believe it was to do with the company proxy. Try a pc at an > offsite location > > ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267409 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Update: error emails firing for no reason (I still need help)
I seem to remeber a colleague had a similar problem before (not 100% on this). I believe it was to do with the company proxy. Try a pc at an offsite location ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267383 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Update: error emails firing for no reason (I still need help)
As was mentioned, try another browser. Also you don't have any weird programs like a web accelerator installed, do you? Russ > -Original Message- > From: Barthle, Robert (Contractor) [mailto:[EMAIL PROTECTED] > Sent: Tuesday, January 23, 2007 3:37 PM > To: CF-Talk > Subject: Update: error emails firing for no reason (I still need help) > > Update: I have the cause for why this is happening. The reason is that the > form processing page is calling itself mere seconds after it is first > called. The second time around, the form field do not exist, and that's > the reason for the error. > > The problem is, there is nothing in the code that would cause that. And > it's all happening in the background. > > The logs show that my computer's IP address makes a POST to the form > submission page, as it should when I submit the form. But anywhere from 1- > 3 seconds later, a GET request is sent from the same IP address for the > form submission page, and the listed referring page is the forms > processing page. > > Here's the log entries. Can anyone help me as to why this might be > happening? On the form processing page there are no CFLOCATION, CFHTTP, > Javascript calls, anything that would cause a page to make an HTTP request > for itself. > > (Sidebar: I have had this happen to me before on a personal site of mine. > I never understood what was happening until now. That code was written > back in CF5, so whatever is happening is something longstanding). > > > 172.16.27.0 - - [23/Jan/2007:15:12:48 -0500] "POST > /Programs/EROD/admin/index.cfm?action=save&CFID=2061637&CFTOKEN=4bc5e5d- > 1002f118-a0ea-49e8-8c36- > e3ff42f85e05&jsessionid=d6302ff0144c6545b1d3&submit=&searchtext=&searchtit > le=&order_by=resource_create_dt&order=ASC HTTP/1.1" 200 40472 > "http://wdchqdcold04.dev.ed.gov/Programs/EROD/admin/index.cfm?action=edit&; > resource_id=47" "Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; > rv:1.8.1.1) Gecko/20061204 Firefox/2.0.0.1" > > 172.16.27.0 - - [23/Jan/2007:15:12:49 -0500] "GET > /Programs/EROD/admin/index.cfm?action=save&CFID=2061637&CFTOKEN=4bc5e5d- > 1002f118-a0ea-49e8-8c36- > e3ff42f85e05&jsessionid=d6302ff0144c6545b1d3&submit=&searchtext=&searchtit > le=&order_by=resource_create_dt&order=ASC HTTP/1.1" 200 34400 > "http://wdchqdcold04.dev.ed.gov/Programs/EROD/admin/index.cfm?action=save&; > CFID=2061637&CFTOKEN=4bc5e5d-1002f118-a0ea-49e8-8c36- > e3ff42f85e05&jsessionid=d6302ff0144c6545b1d3&submit=&searchtext=&searchtit > le=&order_by=resource_create_dt&order=ASC" "Mozilla/5.0 (Windows; U; > Windows NT 5.0; en-US; rv:1.8.1.1) Gecko/20061204 Firefox/2.0.0.1" > > - > > 172.16.27.0 - - [23/Jan/2007:15:13:13 -0500] "POST > /Programs/EROD/admin/index.cfm?action=save&CFID=2061637&CFTOKEN=4bc5e5d- > 1002f118-a0ea-49e8-8c36- > e3ff42f85e05&jsessionid=d6302ff0144c6545b1d3&submit=&searchtext=&searchtit > le=&order_by=resource_create_dt&order=ASC HTTP/1.1" 200 40472 > "http://wdchqdcold04.dev.ed.gov/Programs/EROD/admin/index.cfm?action=edit&; > resource_id=47" "Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; > rv:1.8.1.1) Gecko/20061204 Firefox/2.0.0.1" > > 172.16.27.0 - - [23/Jan/2007:15:13:14 -0500] "GET > /Programs/EROD/admin/index.cfm?action=save&CFID=2061637&CFTOKEN=4bc5e5d- > 1002f118-a0ea-49e8-8c36- > e3ff42f85e05&jsessionid=d6302ff0144c6545b1d3&submit=&searchtext=&searchtit > le=&order_by=resource_create_dt&order=ASC HTTP/1.1" 200 34400 > "http://wdchqdcold04.dev.ed.gov/Programs/EROD/admin/index.cfm?action=save&; > CFID=2061637&CFTOKEN=4bc5e5d-1002f118-a0ea-49e8-8c36- > e3ff42f85e05&jsessionid=d6302ff0144c6545b1d3&submit=&searchtext=&searchtit > le=&order_by=resource_create_dt&order=ASC" "Mozilla/5.0 (Windows; U; > Windows NT 5.0; en-US; rv:1.8.1.1) Gecko/20061204 Firefox/2.0.0.1" > > > > thanks > -r > _ > Rob Barthle > Contractor - Sr. Software Developer > [EMAIL PROTECTED] > 202-245-6484 > > > > -Original Message- > From: Barthle, Robert (Contractor) > Sent: Tuesday, January 23, 2007 11:38 AM > To: CF-Talk > Subject: error emails firing for no reason > > > I have a page that is acting extremely strange. It's a simple form > processing page that runs validation against some of the passed form > fields. If it fails any of the checks, it displays a basic error message > and asks the user to go back to the form to fix the changes (this was not > my work, it's legacy code). In order to do the checks, obviously the form > fields have to exist. > > When I run the page and it finds a validation issue, the warning messages > are put into an array as the checks are done, and if that array is found > to have anything in it, the contents of the array are displayed. If > nothing is found, the database is updated. This processes completely > normally, nothing out of the ordinary. > > But for some weird reason, when the warning messages are displayed, the > error emails that my onError function in Application
RE: Update: error emails firing for no reason (I still need help)
> Update: I have the cause for why this is happening. The > reason is that the form processing page is calling itself > mere seconds after it is first called. The second time > around, the form field do not exist, and that's the reason > for the error. > > The problem is, there is nothing in the code that would cause > that. And it's all happening in the background. > > The logs show that my computer's IP address makes a POST to > the form submission page, as it should when I submit the > form. But anywhere from 1-3 seconds later, a GET request is > sent from the same IP address for the form submission page, > and the listed referring page is the forms processing page. > > Here's the log entries. Can anyone help me as to why this > might be happening? On the form processing page there are no > CFLOCATION, CFHTTP, Javascript calls, anything that would > cause a page to make an HTTP request for itself. > > (Sidebar: I have had this happen to me before on a personal > site of mine. I never understood what was happening until > now. That code was written back in CF5, so whatever is > happening is something longstanding). Just for fun, you might try using a different browser, and/or a different client machine. You might also want to record the HTTP requests and responses, to see what's causing the page to be requested. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267371 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Update: error emails firing for no reason (I still need help)
I've never seen that happen before but I'm sure it's caused by some bad code (no offense) but without seeing some code, I doubt anyone can help unless theyve seen the exact same thing happen. -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.432 / Virus Database: 268.17.2/641 - Release Date: 1/20/2007 10:24 AM ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267370 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Update: error emails firing for no reason (I still need help)
Check your FORM tag along with any JS validation your doing. Sometimes it can happen if you have a form tag that has: OnSubmit:CheckForm() instead of: onSubmit="return CheckForm();" That way if the form validation false it would return false and NOT process the form. Else might be doing it twice. Just a thought. I may be way off base but worth a look. -Original Message- From: Barthle, Robert (Contractor) [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 23, 2007 3:37 PM To: CF-Talk Subject: Update: error emails firing for no reason (I still need help) Update: I have the cause for why this is happening. The reason is that the form processing page is calling itself mere seconds after it is first called. The second time around, the form field do not exist, and that's the reason for the error. The problem is, there is nothing in the code that would cause that. And it's all happening in the background. The logs show that my computer's IP address makes a POST to the form submission page, as it should when I submit the form. But anywhere from 1-3 seconds later, a GET request is sent from the same IP address for the form submission page, and the listed referring page is the forms processing page. Here's the log entries. Can anyone help me as to why this might be happening? On the form processing page there are no CFLOCATION, CFHTTP, Javascript calls, anything that would cause a page to make an HTTP request for itself. (Sidebar: I have had this happen to me before on a personal site of mine. I never understood what was happening until now. That code was written back in CF5, so whatever is happening is something longstanding). 172.16.27.0 - - [23/Jan/2007:15:12:48 -0500] "POST /Programs/EROD/admin/index.cfm?action=save&CFID=2061637&CFTOKEN=4bc5e5d- 1002f118-a0ea-49e8-8c36-e3ff42f85e05&jsessionid=d6302ff0144c6545b1d3&sub mit=&searchtext=&searchtitle=&order_by=resource_create_dt&order=ASC HTTP/1.1" 200 40472 "http://wdchqdcold04.dev.ed.gov/Programs/EROD/admin/index.cfm?action=edi t&resource_id=47" "Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.8.1.1) Gecko/20061204 Firefox/2.0.0.1" 172.16.27.0 - - [23/Jan/2007:15:12:49 -0500] "GET /Programs/EROD/admin/index.cfm?action=save&CFID=2061637&CFTOKEN=4bc5e5d- 1002f118-a0ea-49e8-8c36-e3ff42f85e05&jsessionid=d6302ff0144c6545b1d3&sub mit=&searchtext=&searchtitle=&order_by=resource_create_dt&order=ASC HTTP/1.1" 200 34400 "http://wdchqdcold04.dev.ed.gov/Programs/EROD/admin/index.cfm?action=sav e&CFID=2061637&CFTOKEN=4bc5e5d-1002f118-a0ea-49e8-8c36-e3ff42f85e05&jses sionid=d6302ff0144c6545b1d3&submit=&searchtext=&searchtitle=&order_by=re source_create_dt&order=ASC" "Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.8.1.1) Gecko/20061204 Firefox/2.0.0.1" - 172.16.27.0 - - [23/Jan/2007:15:13:13 -0500] "POST /Programs/EROD/admin/index.cfm?action=save&CFID=2061637&CFTOKEN=4bc5e5d- 1002f118-a0ea-49e8-8c36-e3ff42f85e05&jsessionid=d6302ff0144c6545b1d3&sub mit=&searchtext=&searchtitle=&order_by=resource_create_dt&order=ASC HTTP/1.1" 200 40472 "http://wdchqdcold04.dev.ed.gov/Programs/EROD/admin/index.cfm?action=edi t&resource_id=47" "Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.8.1.1) Gecko/20061204 Firefox/2.0.0.1" 172.16.27.0 - - [23/Jan/2007:15:13:14 -0500] "GET /Programs/EROD/admin/index.cfm?action=save&CFID=2061637&CFTOKEN=4bc5e5d- 1002f118-a0ea-49e8-8c36-e3ff42f85e05&jsessionid=d6302ff0144c6545b1d3&sub mit=&searchtext=&searchtitle=&order_by=resource_create_dt&order=ASC HTTP/1.1" 200 34400 "http://wdchqdcold04.dev.ed.gov/Programs/EROD/admin/index.cfm?action=sav e&CFID=2061637&CFTOKEN=4bc5e5d-1002f118-a0ea-49e8-8c36-e3ff42f85e05&jses sionid=d6302ff0144c6545b1d3&submit=&searchtext=&searchtitle=&order_by=re source_create_dt&order=ASC" "Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.8.1.1) Gecko/20061204 Firefox/2.0.0.1" thanks -r _ Rob Barthle Contractor - Sr. Software Developer [EMAIL PROTECTED] 202-245-6484 -Original Message- From: Barthle, Robert (Contractor) Sent: Tuesday, January 23, 2007 11:38 AM To: CF-Talk Subject: error emails firing for no reason I have a page that is acting extremely strange. It's a simple form processing page that runs validation against some of the passed form fields. If it fails any of the checks, it displays a basic error message and asks the user to go back to the form to fix the changes (this was not my work, it's legacy code). In order to do the checks, obviously the form fields have to exist. When I run the page and it finds a validation issue, the warning messages are put into an array as the checks are done, and if that array is found to have anything in it, the contents of the array are displayed. If nothing is found, the database is updated. This processes completely normally, nothing out of the ordinary. But for some weird reason, when the warning messages are displayed, the error emails that my onError functio
Re: UPDATE: Re: CFDOCUMENT hell
> In my experience, there can be only a single header and footer and the > last one read by the server will be used. I usually use an include file > to build the header and footer and just include it once towards the end. Thanks Jake.so it certainly does appear that there is a few STUPID bugs with the CFDOCUMENT set of tags. Having used iText I wondered how they would have made them worknow I know...they simply didn't!!! g I just can't see how such glaring bugs made it out the door?? Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264318 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: UPDATE: Re: CFDOCUMENT hell
In my experience, there can be only a single header and footer and the last one read by the server will be used. I usually use an include file to build the header and footer and just include it once towards the end. Bryan Stevenson wrote: > Well I upgraded to &.02 with the lates hot fix and still no love. > > Ray said he "thought" it was fixed in one of the updaters.but I'm not > seeing > it. > > So CFDOCUMENTSECTION forces a page break between sections and it shouldn't. > and if you use multuple header/footers, the last one overwrites all > previous > ones (i.e. a header added on line 100 overwrites a header on line 50 AND the > only header shown in the whole doc is the one on line 100). > > Can anyone 100% confirm or deny?? > > TIA > > Cheers > > Bryan Stevenson B.Comm. > VP & Director of E-Commerce Development > Electric Edge Systems Group Inc. > phone: 250.480.0642 > fax: 250.480.1264 > cell: 250.920.8830 > e-mail: [EMAIL PROTECTED] > web: www.electricedgesystems.com > > > > ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264315 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Update Oracle database with NULL value from cold fusion script?
or use cfqueryparam with attribute null as true.
HTH
On 8/17/06, Ian Skinner <[EMAIL PROTECTED]> wrote:
>
> Personally, I put NULL into the table, or do not update the field if it is
> unnecessary in my code.
>
>
> UPDATE aTable
> SET This = 'that',
> Foo = 101,
> BAR = NULL
>
>
> OR
>
>
> INSERT INTO aTable
> (This,Foo,Bar)
> VALUES
> ('That', 101, NULL)
>
>
> I suspect if you showed us your code we could point out where you are
> telling the database to insert empty or whitespace strings into the table.
>
>
>
>
> --
> Ian Skinner
> Web Programmer
> BloodSource
> www.BloodSource.org
> Sacramento, CA
>
> -
> | 1 | |
> - Binary Soduko
> | | |
> -
>
> "C code. C code run. Run code run. Please!"
> - Cynthia Dunning
>
> Confidentiality Notice: This message including any
> attachments is for the sole use of the intended
> recipient(s) and may contain confidential and privileged
> information. Any unauthorized review, use, disclosure or
> distribution is prohibited. If you are not the
> intended recipient, please contact the sender and
> delete any copies of this message.
>
>
>
>
>
~|
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.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250248
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Update Oracle database with NULL value from cold fusion script?
Personally, I put NULL into the table, or do not update the field if it is
unnecessary in my code.
UPDATE aTable
SET This = 'that',
Foo = 101,
BAR = NULL
OR
INSERT INTO aTable
(This,Foo,Bar)
VALUES
('That', 101, NULL)
I suspect if you showed us your code we could point out where you are telling
the database to insert empty or whitespace strings into the table.
--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
-
| 1 | |
- Binary Soduko
| | |
-
"C code. C code run. Run code run. Please!"
- Cynthia Dunning
Confidentiality Notice: This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message.
~|
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.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250233
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Update on eolas/cfform/cfchart fixes
depends how you are displaying the resulting document from a cf document tag; If you are using an object tag... yes. If you follow the advice from the links in the Active Content developer center then no. If you provide a link to a cfm file which contains cfheader, cfcontent, cfdocument.. no worries. The way I understand it is only content directly imbeded in the html will need to be rewritten. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236624 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Update on eolas/cfform/cfchart fixes
I've seen reference to cfdocument in this thread. Is it going to be a problem as well? -Original Message- From: Kevin Aebig [mailto:[EMAIL PROTECTED] Sent: Thursday, March 30, 2006 2:38 PM To: CF-Talk Subject: RE: Update on eolas/cfform/cfchart fixes As mentioned numerous times, the problem isn't regular content, but files generated dynamically like Flex, CFForm or CFChart. !k -Original Message- From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED] Sent: March 30, 2006 1:44 PM To: CF-Talk Subject: Re: Update on eolas/cfform/cfchart fixes At work, we have found this workaround to be highly flexible: http://blog.deconcept.com/flashobject/ Cutter Anthony Prato wrote: >let me start by saying please don't post in this thread about >IE/ActiveX being good or bad. Yes most of us hate it, but this change >is coming in less than 2 weeks. > >I've been to the Active Content Center. >http://www.macromedia.com/devnet/activecontent/ > >Unfortunately it does not provide any fixes for the flash >automatically generated by Coldfusion. Nor does it provide any info on >a forthcoming fix. Can someone from Adobe please respond to this! I'm >amazed I have to say this, but I think Dave is wrong. :p From >everything i have read the change will be included in a security >update on April 11. This means people WILL install it. Most >organizations have become very diligent in installing these security >patches. > >I downloaded the IE update to test myself and all the CF generated >flash loads "inactive." I've already rewritten the code to display my >cfdocuments using the Microsoft workaround example. (document.write() >in included javascript) However, cfdocument is easy because it will >leave the actual flash/pdf binary in its place. When CF processes a >cfform tag it only leaves the html to load the flash in its place. >Because of this I do not know how to use and of the included >JavaScript workarounds for flash forms. Has anyone found a workaround? >Can someone from Adobe comment? > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236608 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Update on eolas/cfform/cfchart fixes
As mentioned numerous times, the problem isn't regular content, but files generated dynamically like Flex, CFForm or CFChart. !k -Original Message- From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED] Sent: March 30, 2006 1:44 PM To: CF-Talk Subject: Re: Update on eolas/cfform/cfchart fixes At work, we have found this workaround to be highly flexible: http://blog.deconcept.com/flashobject/ Cutter Anthony Prato wrote: >let me start by saying please don't post in this thread about >IE/ActiveX being good or bad. Yes most of us hate it, but this change >is coming in less than 2 weeks. > >I've been to the Active Content Center. >http://www.macromedia.com/devnet/activecontent/ > >Unfortunately it does not provide any fixes for the flash >automatically generated by Coldfusion. Nor does it provide any info on >a forthcoming fix. Can someone from Adobe please respond to this! I'm >amazed I have to say this, but I think Dave is wrong. :p From >everything i have read the change will be included in a security >update on April 11. This means people WILL install it. Most >organizations have become very diligent in installing these security >patches. > >I downloaded the IE update to test myself and all the CF generated >flash loads "inactive." I've already rewritten the code to display my >cfdocuments using the Microsoft workaround example. (document.write() >in included javascript) However, cfdocument is easy because it will >leave the actual flash/pdf binary in its place. When CF processes a >cfform tag it only leaves the html to load the flash in its place. >Because of this I do not know how to use and of the included >JavaScript workarounds for flash forms. Has anyone found a workaround? >Can someone from Adobe comment? > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236599 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Update on eolas/cfform/cfchart fixes
At work, we have found this workaround to be highly flexible: http://blog.deconcept.com/flashobject/ Cutter Anthony Prato wrote: >let me start by saying please don't post in this thread about >IE/ActiveX being good or bad. Yes most of us hate it, but this change >is coming in less than 2 weeks. > >I've been to the Active Content Center. >http://www.macromedia.com/devnet/activecontent/ > >Unfortunately it does not provide any fixes for the flash >automatically generated by Coldfusion. Nor does it provide any info on >a forthcoming fix. Can someone from Adobe please respond to this! I'm >amazed I have to say this, but I think Dave is wrong. :p From >everything i have read the change will be included in a security >update on April 11. This means people WILL install it. Most >organizations have become very diligent in installing these security >patches. > >I downloaded the IE update to test myself and all the CF generated >flash loads "inactive." I've already rewritten the code to display my >cfdocuments using the Microsoft workaround example. (document.write() >in included javascript) However, cfdocument is easy because it will >leave the actual flash/pdf binary in its place. When CF processes a >cfform tag it only leaves the html to load the flash in its place. >Because of this I do not know how to use and of the included >JavaScript workarounds for flash forms. Has anyone found a workaround? >Can someone from Adobe comment? > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236586 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Update on eolas/cfform/cfchart fixes
I should have a proof of concept temporary fix right away. !k -Original Message- From: S.Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 29, 2006 6:24 PM To: CF-Talk Subject: RE: Update on eolas/cfform/cfchart fixes >> Unfortunately it does not provide any fixes for the flash >> automatically generated by Coldfusion. Nor does it >> provide >> any info on a forthcoming fix. Can someone from Adobe >> please >> respond to this! I'm amazed I have to say this, but I >> think >> Dave is wrong. :p From everything i have read the change >> will be included in a security update on April 11. This >> means >> people WILL install it. Most organizations have become >> very >> diligent in installing these security patches. > You are correct that it will be included in a rollup on 11 > April. I just > looked it up. In my own defense, I was referring to the > patches that are > available now, not future patches, so I would argue that I > was technically > correct. This is where I'd type a smiley face, if I were > the type of person > who'd do that sort of thing. You're so stolid. Dave is a closet smiler. :) s. isaac dealey 434.293.6201 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236522 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Update on eolas/cfform/cfchart fixes
>> Unfortunately it does not provide any fixes for the flash >> automatically generated by Coldfusion. Nor does it >> provide >> any info on a forthcoming fix. Can someone from Adobe >> please >> respond to this! I'm amazed I have to say this, but I >> think >> Dave is wrong. :p From everything i have read the change >> will be included in a security update on April 11. This >> means >> people WILL install it. Most organizations have become >> very >> diligent in installing these security patches. > You are correct that it will be included in a rollup on 11 > April. I just > looked it up. In my own defense, I was referring to the > patches that are > available now, not future patches, so I would argue that I > was technically > correct. This is where I'd type a smiley face, if I were > the type of person > who'd do that sort of thing. You're so stolid. Dave is a closet smiler. :) s. isaac dealey 434.293.6201 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236497 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Update on eolas/cfform/cfchart fixes
> Unfortunately it does not provide any fixes for the flash > automatically generated by Coldfusion. Nor does it provide > any info on a forthcoming fix. Can someone from Adobe please > respond to this! I'm amazed I have to say this, but I think > Dave is wrong. :p From everything i have read the change > will be included in a security update on April 11. This means > people WILL install it. Most organizations have become very > diligent in installing these security patches. You are correct that it will be included in a rollup on 11 April. I just looked it up. In my own defense, I was referring to the patches that are available now, not future patches, so I would argue that I was technically correct. This is where I'd type a smiley face, if I were the type of person who'd do that sort of thing. But yeah, anyway, this will be a problem, and people will certainly install the patch, if they haven't already. I suspect that most people who self-install patches through Windows Update or Microsoft Update have already installed it. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236495 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Update on eolas/cfform/cfchart fixes
Agreed... especially since there is no date on this page, it may have been posted months ago. I'm glad I didn't expose flash forms to external users... ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236491 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Update on eolas/cfform/cfchart fixes
> Unfortunately it does not provide any fixes for the flash > automatically generated by Coldfusion. Nor does it provide any info on > a forthcoming fix. This line on that page seems to allude to fixes for ColdFusion: "In the coming weeks, Adobe expects to make available alternate solutions to Microsoft's script-based technique to help make it easier for developers who use active content prepare for the expected changes to Internet Explorer." It /would/ be nice to hear something solid from Adobe on this though. [INFO] -- Access Manager: This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A2 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236489 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Update, Delete, Insert recordcount?
Jim Wright wrote: > I have read that not having "set nocount on" can mess up CF's ability in the past (ie pre MX) you needed it to pump multiple t-sql statements into 1 cfquery. the intermediate resultset counts returned to cf would otherwise confuse it. i forget who exactly figured that out but i think it was a team allaire member, maybe around the time of cf3. it's been a good practice since then (even longer in the sql server world, you'll see it recommended for use in sp that deal w/monster thumping tables all the time). ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230218 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Update, Delete, Insert recordcount?
Cheers. I can't say I've ever used it in cfquery, but it's in my SP templates. I could have sworn there was another reason for using it but I can't think what it is right now. Ade -Original Message- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: 23 January 2006 12:21 To: CF-Talk Subject: Re: Update, Delete, Insert recordcount? Mainly, it is a performance thing...when you have multiple statements returning their counts, it takes longer to get to that one statement that actually has the results you want.It may be milliseconds, but in some systems, that can add up...so it's just good practice. Also, I have read that not having "set nocount on" can mess up CF's ability to parse out an error message from the messages that are returned, as it gets confused by the multiple count messages that may precede the errorbut I haven't confirmed that one myself. But there is probably no problem using it on a single statement. On 1/22/06, Adrian Lynch <[EMAIL PROTECTED]> wrote: > Why multiple statements, why not single statements? > > Ade > > -Original Message- > From: Jim Wright [mailto:[EMAIL PROTECTED] > Sent: 22 January 2006 01:08 > To: CF-Talk > Subject: Re: Update, Delete, Insert recordcount? > > > Also always a good idea to use SET NOCOUNT around multiple SQL > statements to suppress informational messages... > > SET NOCOUNT ON > > UPDATE yourTable > SET YourColumn = 'Something' > > SELECT @@ROWCOUNT AS RowsUpdated > > SET NOCOUNT OFF > > > > On 1/21/06, Adrian Lynch <[EMAIL PROTECTED]> wrote: > > My name's not Bobby, but here goes: > > > > > > UPDATE yourTable > > SET YourColumn = 'Something' > > > > SELECT @@ROWCOUNT 'RowsUpdated' > > > > > > > > #yourQuery.RowsUpdated# > > > > > > Untested, and for SQL Server, but might be ok for Access. > > > > Adrian ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230217 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Update, Delete, Insert recordcount?
Mainly, it is a performance thing...when you have multiple statements returning their counts, it takes longer to get to that one statement that actually has the results you want.It may be milliseconds, but in some systems, that can add up...so it's just good practice. Also, I have read that not having "set nocount on" can mess up CF's ability to parse out an error message from the messages that are returned, as it gets confused by the multiple count messages that may precede the errorbut I haven't confirmed that one myself. But there is probably no problem using it on a single statement. On 1/22/06, Adrian Lynch <[EMAIL PROTECTED]> wrote: > Why multiple statements, why not single statements? > > Ade > > -Original Message- > From: Jim Wright [mailto:[EMAIL PROTECTED] > Sent: 22 January 2006 01:08 > To: CF-Talk > Subject: Re: Update, Delete, Insert recordcount? > > > Also always a good idea to use SET NOCOUNT around multiple SQL > statements to suppress informational messages... > > SET NOCOUNT ON > > UPDATE yourTable > SET YourColumn = 'Something' > > SELECT @@ROWCOUNT AS RowsUpdated > > SET NOCOUNT OFF > > > > On 1/21/06, Adrian Lynch <[EMAIL PROTECTED]> wrote: > > My name's not Bobby, but here goes: > > > > > > UPDATE yourTable > > SET YourColumn = 'Something' > > > > SELECT @@ROWCOUNT 'RowsUpdated' > > > > > > > > #yourQuery.RowsUpdated# > > > > > > Untested, and for SQL Server, but might be ok for Access. > > > > Adrian > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230215 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Update, Delete, Insert recordcount?
Why multiple statements, why not single statements? Ade -Original Message- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: 22 January 2006 01:08 To: CF-Talk Subject: Re: Update, Delete, Insert recordcount? Also always a good idea to use SET NOCOUNT around multiple SQL statements to suppress informational messages... SET NOCOUNT ON UPDATE yourTable SET YourColumn = 'Something' SELECT @@ROWCOUNT AS RowsUpdated SET NOCOUNT OFF On 1/21/06, Adrian Lynch <[EMAIL PROTECTED]> wrote: > My name's not Bobby, but here goes: > > > UPDATE yourTable > SET YourColumn = 'Something' > > SELECT @@ROWCOUNT 'RowsUpdated' > > > > #yourQuery.RowsUpdated# > > > Untested, and for SQL Server, but might be ok for Access. > > Adrian ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230188 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Update, Delete, Insert recordcount?
Also always a good idea to use SET NOCOUNT around multiple SQL statements to suppress informational messages... SET NOCOUNT ON UPDATE yourTable SET YourColumn = 'Something' SELECT @@ROWCOUNT AS RowsUpdated SET NOCOUNT OFF On 1/21/06, Adrian Lynch <[EMAIL PROTECTED]> wrote: > My name's not Bobby, but here goes: > > > UPDATE yourTable > SET YourColumn = 'Something' > > SELECT @@ROWCOUNT 'RowsUpdated' > > > > #yourQuery.RowsUpdated# > > > Untested, and for SQL Server, but might be ok for Access. > > Adrian > > -Original Message- > From: Will Tomlinson [mailto:[EMAIL PROTECTED] > Sent: 21 January 2006 18:26 > To: CF-Talk > Subject: Re: Update, Delete, Insert recordcount? > > > >SQL can do it in a coupld of databases I think in sql server its > @@rowcount? > > Bobby, > > Could you offer an example for dave? He mostly uses Access. > > Will > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230185 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Update, Delete, Insert recordcount?
My name's not Bobby, but here goes: UPDATE yourTable SET YourColumn = 'Something' SELECT @@ROWCOUNT 'RowsUpdated' #yourQuery.RowsUpdated# Untested, and for SQL Server, but might be ok for Access. Adrian -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: 21 January 2006 18:26 To: CF-Talk Subject: Re: Update, Delete, Insert recordcount? >SQL can do it in a coupld of databases I think in sql server its @@rowcount? Bobby, Could you offer an example for dave? He mostly uses Access. Will ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230181 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Update, Delete, Insert recordcount?
>SQL can do it in a coupld of databases I think in sql server its @@rowcount? Bobby, Could you offer an example for dave? He mostly uses Access. Will ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230180 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Update, Delete, Insert recordcount?
Hmm, in CFMX 7, the result attribute of cfquery gives the number of records returned. So it is only useful for SELECT statement. It should definitely give the number of records affected insteads so it would be useful for all four insert, select, update and delete statements. I hope they will change it in the next version. Johnny >Hey guys, > >Is there any way that you make coldfusion give you how many rows were >affected from Update Delete and insert statements? Even if its not in >the recordcount variable (which I have to assume would not be >possible)? > >-- >Ryan Guill >BlueEyesDevelopment >[EMAIL PROTECTED] >www.ryanguill.com >(270) 217.2399 >got google talk? Chat me at [EMAIL PROTECTED] > >The Coldfusion Open Application Library - COAL - http://coal.ryanguill.com > >Use CF and SQL? Try qBrowser - http://www.ryanguill.com/docs/ > >www.ryanguill.com/ >The Roman Empire: www.ryanguill.com/blog/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230179 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Update, Delete, Insert recordcount?
there I go with control + enter again... anyway... SQL can do it in a coupld of databases I think in sql server its @@rowcount? Update blah set blah = blah; select @@rowcount as rowsaffected; something like that anyway You could always SELECT just before an update/delete query using the same "WHERE" clause to know how many records are going to be updated or deleted. ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Ryan Guill [mailto:[EMAIL PROTECTED] Sent: Friday, January 20, 2006 11:21 AM To: CF-Talk Subject: Update, Delete, Insert recordcount? Hey guys, Is there any way that you make coldfusion give you how many rows were affected from Update Delete and insert statements? Even if its not in the recordcount variable (which I have to assume would not be possible)? -- Ryan Guill BlueEyesDevelopment [EMAIL PROTECTED] www.ryanguill.com (270) 217.2399 got google talk? Chat me at [EMAIL PROTECTED] The Coldfusion Open Application Library - COAL - http://coal.ryanguill.com Use CF and SQL? Try qBrowser - http://www.ryanguill.com/docs/ www.ryanguill.com/ The Roman Empire: www.ryanguill.com/blog/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230103 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Update, Delete, Insert recordcount?
Well, I was speaking generally, but the main use for it at the moment would be an as/400 iseries database set up through odbc. Although I could definately see use for it using mysql as well. On 1/20/06, Bobby Hartsfield <[EMAIL PROTECTED]> wrote: > What type of database is it? > > ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. > Bobby Hartsfield > http://acoderslife.com > > > > -Original Message- > From: Ryan Guill [mailto:[EMAIL PROTECTED] > Sent: Friday, January 20, 2006 11:21 AM > To: CF-Talk > Subject: Update, Delete, Insert recordcount? > > Hey guys, > > Is there any way that you make coldfusion give you how many rows were > affected from Update Delete and insert statements? Even if its not in > the recordcount variable (which I have to assume would not be > possible)? > > -- > Ryan Guill > BlueEyesDevelopment > [EMAIL PROTECTED] > www.ryanguill.com > (270) 217.2399 > got google talk? Chat me at [EMAIL PROTECTED] > > The Coldfusion Open Application Library - COAL - http://coal.ryanguill.com > > Use CF and SQL? Try qBrowser - http://www.ryanguill.com/docs/ > > www.ryanguill.com/ > The Roman Empire: www.ryanguill.com/blog/ > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230102 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Update, Delete, Insert recordcount?
SQL Server you should be able to use @@rowcount. -Original Message- From: Ryan Guill [mailto:[EMAIL PROTECTED] Sent: 20 January 2006 16:21 To: CF-Talk Subject: Update, Delete, Insert recordcount? Hey guys, Is there any way that you make coldfusion give you how many rows were affected from Update Delete and insert statements? Even if its not in the recordcount variable (which I have to assume would not be possible)? -- Ryan Guill BlueEyesDevelopment [EMAIL PROTECTED] www.ryanguill.com (270) 217.2399 got google talk? Chat me at [EMAIL PROTECTED] The Coldfusion Open Application Library - COAL - http://coal.ryanguill.com Use CF and SQL? Try qBrowser - http://www.ryanguill.com/docs/ www.ryanguill.com/ The Roman Empire: www.ryanguill.com/blog/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230101 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Update, Delete, Insert recordcount?
What type of database is it? ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Ryan Guill [mailto:[EMAIL PROTECTED] Sent: Friday, January 20, 2006 11:21 AM To: CF-Talk Subject: Update, Delete, Insert recordcount? Hey guys, Is there any way that you make coldfusion give you how many rows were affected from Update Delete and insert statements? Even if its not in the recordcount variable (which I have to assume would not be possible)? -- Ryan Guill BlueEyesDevelopment [EMAIL PROTECTED] www.ryanguill.com (270) 217.2399 got google talk? Chat me at [EMAIL PROTECTED] The Coldfusion Open Application Library - COAL - http://coal.ryanguill.com Use CF and SQL? Try qBrowser - http://www.ryanguill.com/docs/ www.ryanguill.com/ The Roman Empire: www.ryanguill.com/blog/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230100 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: UPDATE with subquery
> From: Richard Colman [mailto:[EMAIL PROTECTED] > Does anyone know if this looks right: > update spdinput set sequence = "(select sequence from > spdinput where spdinput_id = 559)" > where spdinput_id = 627 > I am afraid of blowing up my data table in SQL-Server. Copy the table w/ data to a test table. Test the update SQL. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226373 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Update Dilemma
Woops.. didn't mean to hijack. -Original Message- From: Emmet McGovern [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 08, 2005 2:26 PM To: CF-Talk Subject: RE: Update Dilemma What's the best way to move a directory with a ton of folders and files in it? Recursive? Executable? Emmet ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209014 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Update Dilemma
What's the best way to move a directory with a ton of folders and files in it? Recursive? Executable? Emmet ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209011 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Update Dilemma
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 [EMAIL PROTECTED] wrote: > I'm a complete newbie at Coldfusion, and have a pretty basic question. > > I'm trying to get an update page working, and it keeps returning the error: > > Error Executing Database Query. > Syntax error in UPDATE statement. The error occurred in > C:\CFusionMX7\wwwroot\CFIDE\gettingstarted\tutorial\update2.cfm: line 65 > 63 : NULL > 64 : > 65 : WHERE ID=#FORM.hiddenField# > 66 : > 67 : The root of that error was that your query didn't have a name. However, there's other problems with it too. If you're setting values to null in a table, it's much better to use . I've rewritten your code to use it. Also, if you want to check if you're being posted data, use the REQUEST_METHOD CGI variable. Rather than having two different parameters with the same basic meaning (URL.recordID and FORM.hiddenField), just use the one name (recordID). Just use 'recordID', and CF will resolve this to either URL.recordID or FORM.recordID. I've assumed that your values are all VARCHARs, though you should change them to whatever they really should be. Check the docs for a list of them. - CUT HERE UPDATE Sheet1 SET Name= , Surname = , Sex = , Height = , Playing_age = , DOB = , Hair= , Eye = , Image = , Training= WHERE ID = SELECT * FROMSheet1 WHERE ID = http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd";> Untitled Document - CUT HERE K. -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCpypfmSWF0pzlQ04RAoUfAJ43RoZsHU8WB9B+eki5kbzvBtCdTACeIjBh cfgj875TrqKoNOfyJ72fDOs= =Ypde -END PGP SIGNATURE- ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209001 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Update Dilemma
Nope...still no joy It works with one field...but not with all of them... Here are the two codes... THIS ONE WORKS UPDATE Sheet1 SET Name= '#FORM.name#' NULL WHERE ID=#FORM.hiddenField# SELECT * FROM Sheet1 http://www.w3.org/TR/html4/loose.dtd_ (http://www.w3.org/TR/html4/loose.dtd) "> Untitled Document THIS ONE DOESN'T UPDATE Sheet1 SET Name= '#FORM.name#' IS NULL , Surname= '#FORM.Surname#' IS NULL , Sex= '#FORM.Sex#' IS NULL , Height= '#FORM.Height#' IS NULL , Playing_age= '#FORM.Playing_Age#' IS NULL , DOB= '#FORM.DOB#' IS NULL , Hair= '#FORM.Hair#' IS NULL , Eye= '#FORM.Eye#' IS NULL , Image= '#FORM.Image#' IS NULL , Training= '#FORM.Training#' IS NULL WHERE ID=#FORM.hiddenID# SELECT * FROM Sheet1 WHERE ID = #URL.recordID# http://www.w3.org/TR/html4/loose.dtd_ (http://www.w3.org/TR/html4/loose.dtd) "> Untitled Document ARGH! Dan ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208984 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
