CFHTMLHEAD

2014-10-16 Thread Dave Sueltenfuss
I'm working on a migration from CF9 to CF 11, and for some reason CFHTMLHEAD is not working for me. Has anyone else run into this? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp

Scheduled Tasks Running Multiple Threads

2011-11-09 Thread Dave Sueltenfuss
On CF 9.0.1, has anyone run into the issue of the CF server spawning multiple threads for the same scheduled task? To date, we have been unable to find a cause, or even a reason for this happening. The only solutions we have found to resolve it is to either restart the CF service or pause/edit the

cf_sql_timestamp

2011-05-09 Thread Dave Sueltenfuss
I've always used cf_sql_timestamp, in cfqueryparams, when using a value with a date and time. Comparing the online documentation, between CF8 and CF9, it looks like this datatype is now intended to map to the sql timetamp datatype in CF9.is this correct, or just mis-documentation? http://help.ado

Re: CF9 Service Randomly Restarting

2010-12-01 Thread Dave Sueltenfuss
Hi Carl, It was an java.lang.OutOfMemoryError, that we are seeing in the hs_err_pxxx log. We are still looking to see what is causing this -Dave On Tue, Nov 30, 2010 at 4:55 PM, Carl Meyer wrote: > > >Thanks All... looks like our issue is related to running out of swap space > Curious. Did yo

Re: CF9 Service Randomly Restarting

2010-11-30 Thread Dave Sueltenfuss
Thanks All... looks like our issue is related to running out of swap space -Dave On Tue, Nov 30, 2010 at 1:19 AM, Mark A. Kruger wrote: > > That's the right track for this look for log files in the /bin > directory... my guess is you have hot spot errors that are killing the > server. > >

Re: CF9 Service Randomly Restarting

2010-11-29 Thread Dave Sueltenfuss
It appears to be the Service Wrapper thats restarting, based on the Windows Application log On Mon, Nov 29, 2010 at 11:20 AM, Jochem van Dieten wrote: > > On Mon, Nov 29, 2010 at 4:15 PM, Dave Sueltenfuss wrote: > > We have a CF 9.0.1 server 32 bit, in production that randomly re

Re: CF9 Service Randomly Restarting

2010-11-29 Thread Dave Sueltenfuss
7;s Server tab? > > ---- > > From: "Dave Sueltenfuss" > Sent: Monday, November 29, 2010 11:01 AM > To: "cf-talk" > Subject: Re: CF9 Service Randomly Restarting > > Yes, we are recieveing the following error in the Windows Application

Re: CF9 Service Randomly Restarting

2010-11-29 Thread Dave Sueltenfuss
Russ Michaels wrote: > > Are you sure CF has actually restarted or is it just your application > restarting ? > > Russ > > -Original Message- > From: Dave Sueltenfuss [mailto:dsueltenf...@gmail.com] > Sent: 29 November 2010 15:50 > To: cf-talk > Subject: Re: CF9

Re: CF9 Service Randomly Restarting

2010-11-29 Thread Dave Sueltenfuss
must have > something else in the mix. > If this is a windows box then check the service properties and see if it is > set to restart if unresponsive. > Also if you use FusionReactor, the latest version includes options to auto > restart CF. > > > > -----Original Messag

CF9 Service Randomly Restarting

2010-11-29 Thread Dave Sueltenfuss
We have a CF 9.0.1 server 32 bit, in production that randomly restarts the CF service. From what we can tell, this has been happening since we upgraded from CF7 back in April. There is no pattern that we can see to the restarts either, and the logs don't show us any errors either. It seems to happ

Re: Install coldfusion 8 on windows 7 64bit with IIS7 problem HTTP Error 500.0 - Internal Server Error

2010-04-26 Thread Dave Sueltenfuss
I had this exact same issue earleir today. Make sure the ApplicationPool is set to allow 32 Bit Applications in IIS On Mon, Apr 26, 2010 at 5:35 PM, Libo Bian wrote: > > Hi, > > > > I just upgraded to windows 7 professional 64bit OS. trying to install > coldfusion 8 on my PC. It installed fine,

CFDocs

2010-04-07 Thread Dave Sueltenfuss
Does anyone know if the creator of cfdocs.org has plans to update the site to use the latest versions of CF Documentation It's still pointing to CF7'd documents ~| Want to reach the ColdFusion community with something they want?

Re: CFQUERY Question

2010-03-31 Thread Dave Sueltenfuss
.com > > Great advertising can't be either/or. It must be &. > > Plug in to our blog: A&W Unplugged > http://www.austin-williams.com/unplugged > > > -Original Message- > From: Dave Sueltenfuss [mailto:dsueltenf...@gmail.com] > Sent: Wednesday, March

CFQUERY Question

2010-03-31 Thread Dave Sueltenfuss
I'm running into an odd behavior with CFQUERY (at least I think it is odd) I have the following code (example) SELECT blah FROM blah WHERE blah = 1 12345 if the query blahName returns no results, I thought i would still be able to access blahName.recordCount Am I wrong o

Re: Cognos and CF

2010-03-01 Thread Dave Sueltenfuss
Hi Larry, I have done some work with Cognos and CF -Dave On Mon, Mar 1, 2010 at 10:38 AM, Larry Lyons wrote: > > Has anyone integrated CF and Cognos (either the reporting app or the web > services)? I did a quick google search and found very little information on > the topic. > > many thanks,

Re: (ot) SQL query aliases in SQL Management Studio

2009-12-22 Thread Dave Sueltenfuss
Hi Jason, I would recommended creating the view from a query window, and not the design view that SQL Management studio uses Simply add a 'Create View dbo. AS' before the statement that works and run it in the query window Hope this helps -Dave On Tue, Dec 22, 2009 at 11:34 AM, Jason Durha

Re: WSDL vs. ODBC

2009-08-27 Thread Dave Sueltenfuss
I think it would be more like comparing apples to a book On Thu, Aug 27, 2009 at 12:52 PM, Azadi Saryev wrote: > > a quick evaluation showed that apples perform better, while oranges are > more reliable. > :) > > Azadi Saryev > Sabai-dee.com > http://www.sabai-dee.com/ > > > On 28/08/2009 0

Re: cfgrid loading data

2009-08-10 Thread Dave Sueltenfuss
Rama, IMO, 62 MS is not a significant enough difference in time to be worrying about page loading Dave On Mon, Aug 10, 2009 at 7:07 AM, RamaDevi Dobbala wrote: > > Mozilla:Time=7110ms, Records=109 > IE:Time=7172ms, Records=109 > > >HI Rama, > > > >can you please provide more information? H

Re: cfgrid loading data

2009-08-07 Thread Dave Sueltenfuss
HI Rama, can you please provide more information? How many records are you tying to load. What is the time difference? Dave On Fri, Aug 7, 2009 at 11:42 AM, RamaDevi Dobbala wrote: > > hi , > > If i am using cfgrid in IE, while it is loading data it is taking more > time,how can i reduce that,

Re: (ot) Protecting Files

2009-07-28 Thread Dave Sueltenfuss
One thing you could do is write a CF page to retrieve the files for the user. That way, they wouldnt know the actual location of the file on the file system. You would then make sure they were logged in before letting them retrieve the file. Dave On Tue, Jul 28, 2009 at 2:11 PM, Scott Mulholland

Re: format time to local

2009-07-26 Thread Dave Sueltenfuss
There is a DateAdd function in ColdFusion, which you can use to add hours. Inthe example you provided, it would automatically roll the date over to 4 am the next day On Sun, Jul 26, 2009 at 11:18 AM, Richard White wrote: > > hi > > we have a website used in uk. and the server is in usa. > > whe

Re: Converting Year to Integer

2009-07-24 Thread Dave Sueltenfuss
Have you tried outputing your currYear variable, to make sure it is what you expect? On Fri, Jul 24, 2009 at 9:47 AM, N K wrote: > > Yes thats a typo in my email.Adding ## sign does not help > > The error coming up is > Attribute validation error for the CFLOOP tag. > The value of the TO

Re: uninstalling JRun4 from failed Coldfusion install.

2009-07-17 Thread Dave Sueltenfuss
Just a thought, did you search for any JRUN registry keys? On Fri, Jul 17, 2009 at 1:54 PM, Ian Skinner wrote: > > > You can simply stop the service, delete the registry keys, and delete > > the JRun4 directory. > > > I deleted every registry key I could find with either "coldfusion" or > "macr

Re: cfgridcolumn

2009-07-17 Thread Dave Sueltenfuss
If I am understanding you, you want data from 2 different tables in your CFGRID. I would recommend doing a join statement in your query to get all the columns you need in one query. On Fri, Jul 17, 2009 at 11:47 AM, RamaDevi Dobbala wrote: > > Hi frnds, > > can we give cfgridcolumn name="not in

Re: cfgrid

2009-07-17 Thread Dave Sueltenfuss
You would want to wrap each column in the query in an IsNull(coulmnName,'') Dave On Fri, Jul 17, 2009 at 8:46 AM, RamaDevi Dobbala wrote: > > if i use like this, if any value is getting null value means all the value > is becoming null, how to avoid this > > > > > concatenate the 3 columns into

Re: monitoring users / access points

2009-07-15 Thread Dave Sueltenfuss
Richard, How i have done this in the past is track access via a database table. Record their CFID, ip, username, etc when they login. Then, when they second person logs in with the same username, you force the original user to log out. Dave On Wed, Jul 15, 2009 at 9:43 AM, Richard White wrote:

Re: Problem installing ColdFusion on my new laptop.

2009-07-13 Thread Dave Sueltenfuss
, Jul 13, 2009 at 1:26 PM, Ian Skinner wrote: > > Dave Sueltenfuss wrote: > > What version of CF are you trying to install? > I downloaded a nice, fresh 8.0.1 Windows 64bit version of ColdFusion > just befor

Re: Problem installing ColdFusion on my new laptop.

2009-07-13 Thread Dave Sueltenfuss
What version of CF are you trying to install? On Mon, Jul 13, 2009 at 1:05 PM, Ian Skinner wrote: > > I am trying to get ColdFusion developer running on my new Windows Vista > 64bit laptop. > > I downloaded and ran the installer and it ran with no errors, except for > the web connector. > > I f

Re: ColdFusion Report Builder and Excel Output

2009-07-09 Thread Dave Sueltenfuss
I have had similar issues with the excel options for ColdFusion Reports. In the end, I wrote code to using CFFILE to create a csv file with a .xls extension instead. Dave > Hello, I've recently been messing around with ColdFusion Report > Builder because of it's ability to easily output the r

CFContent, ReportBuilder, and Batch Printing

2006-04-10 Thread Dave Sueltenfuss
Morning everyone, I am trying to write a batch printing program to accomplish the following: 1)Create a document from data included in a database (Built a CFR using Report Builder, to display in PDF Format) 2)Retrieve a bunch of TIF tiles associated with the generated document, and print thos

RE: SOT: Two functions in OnSubmit

2006-03-03 Thread Dave Sueltenfuss
I'd suggest building 1 function that references both functions -Original Message- From:Orlini, Robert [EMAIL PROTECTED] To: "CF-Talk" ; Sent: Mar 3, 2006 03:32:09 PM Subject: SOT: Two functions in OnSubmit Is there any way to include two return functions in an OnSubmit?

RE: using WHERE with ValueList?

2006-03-03 Thread Dave Sueltenfuss
Try the following SELECT c.clientID, c.regionID, c.clientName, c.clientSSN, c.clientCity, FROM clients_tb c WHERE c.regionID IN (#valuelist(getRegions.regionID)# ) -Original Message- From:Roberto Perez [EMAIL PROTECTED] To: "CF-Talk" ; Sent: Mar 3, 2006 02:21:35 PM Subject: u

RE: GMail manipulation remotely

2006-03-03 Thread Dave Sueltenfuss
Just to state the obvious, I would think the email would have to come from a gmail address. I doubt gmail would handle mail for any other address. -Original Message- From:Munson, Jacob [EMAIL PROTECTED] To: "CF-Talk" ; Sent: Mar 3, 2006 11:21:43 AM Subject: RE: GMail manipulation remot

RE: OTish: Killing a session on a closed browser

2004-02-20 Thread Dave Sueltenfuss
I use the following code in my Application.cfm This way,once the browser is closed, they can no longer access that specific session         Dave -Original Message- From: cf coder [mailto:[EMAIL PROTECTED] Sent: Friday, February 20, 2004 6:31 AM To: CF-Talk Subject:

RE: How to do that?

2004-01-26 Thread Dave Sueltenfuss
One would think they have multiple entries in the database, with 2 primary keys, article id, and page id. Dave -Original Message- From: Spectrum WebDesign [mailto:[EMAIL PROTECTED] Sent: Monday, January 26, 2004 2:10 PM To: CF-Talk Subject: How to do that? Hi please see th

ColdFusion Training

2003-12-04 Thread Dave Sueltenfuss
Hey Everyone, Has anyone taken the ColdFusion Boot Camp Training from CED Solution www.cedsolutions.com ? If so, is it worth it or is there a better program out there Thanks Dave Sueltenfuss Application Developer Certified ColdFusion MX Developer Arch Wireless Phone: 508-870-6711 Fax: 508

RE: CF Certification

2003-11-26 Thread Dave Sueltenfuss
Dominic, I recommend Certified Macromedia ColdFusion MX Developer Study Guide by Ben Forta. Also, CFExam Buster offers a good practice test for the exams Dave -Original Message- From: Dominic J. Doucet-Lorang [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 26, 2003 1:41 PM To

RE: Spell checkers

2003-11-21 Thread Dave Sueltenfuss
My company uses ActiveSpell. Its about $300, but it works well, and allows for complete page checking -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED] Sent: Thursday, November 20, 2003 2:23 PM To: CF-Talk Subject: Spell checkers My company is looking for a decent spell chec

RE: Data Model Design question

2003-11-10 Thread Dave Sueltenfuss
Michael, As long as you have proper indexing setup on the table, there shouldn't be an issue with querying it. You can also run a Trace on the table, once it is use, to see if any additional indexes can be created, based on the actual usage stats of the table Dave -Original Message-

RE: sql server + cf 5.0

2003-10-07 Thread Dave Sueltenfuss
Won, IS the SQL Server configured for Mixed Authentication or for Windows Authentication? If the SQL Server is configured to only use Windows Authentication, you will not be able to use a SQL Server login,until you reconfigure it. Dave -Original Message- From: Won Lee [mailto:[EMAI

RE: [Stats] Cold Fusion Talk List Stats; September 2003

2003-10-02 Thread Dave Sueltenfuss
Still now seeing any stats Dave -Original Message- From: Bill Doerrfeld [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 8:29 AM To: CF-Talk Subject: Fwd: [Stats] Cold Fusion Talk List Stats; September 2003 Looks like there might be a line monster somewhere. Here

OT:Date Comparison using JavaScript

2003-09-29 Thread Dave Sueltenfuss
Sorry for the Off Topic post, but I am hoping someone on the list will be able to help me out. Does anyone have a script for comparing two dates within _javascript_? I have a date input field, and the date needs to be within two months either way of today. Any help is appreciated. Thanks Dave

RE: CFERROR

2003-09-14 Thread Dave Sueltenfuss
Yes, it is. Dave -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Sunday, September 14, 2003 4:45 PM To: CF-Talk Subject: RE: CFERROR > I have setup my application.cfm, with a type of > REQUEST that calls a local CF page. For some reason, when > a syntax error occ

RE: CFERROR

2003-09-12 Thread Dave Sueltenfuss
probably have an error page defined in the administrator. -Oorspronkelijk bericht- Van: Dave Sueltenfuss [mailto:[EMAIL PROTECTED] Verzonden: vr 12/09/2003 15:48 Aan: CF-Talk CC: Onderwerp: CFERROR I have setup

CFERROR

2003-09-12 Thread Dave Sueltenfuss
Template:#error.template# Thanks Dave Sueltenfuss Application Developer Certified ColdFusion MX Developer Arch Wireless Phone: 508-870-6711 Fax: 508-836-2760 Email: [EMAIL PROTECTED] ~| Archives: http://www.houseoff

CFTry/CFCatch

2003-09-11 Thread Dave Sueltenfuss
add something to it, I can just change it in one spot Any help is appreciated Thanks Dave Sueltenfuss Application Developer Certified ColdFusion MX Developer Arch Wireless Phone: 508-870-6711 Fax: 508-836-2760 Email: [EMAIL PROTECTED

RE: SQL Limitations

2003-08-27 Thread Dave Sueltenfuss
No. The only issue I could foresee is if you were trying to connect to a large number all at once,. Dave -Original Message- From: Matthew Friedman [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 8:43 AM To: CF-Talk Subject: SQL Limitations Is there a maximum number of indi

RE: OT:Advanced SQL Query

2003-08-14 Thread Dave Sueltenfuss
Mark Richards Application Developer BioLab, Inc. >From: "Dave Sueltenfuss" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: OT:Advanced SQL Query >Date: Tue, 12 Aug 2003 10:06:12 -0400 > >Good Morning, > &g

OT: SQL Competency Test

2003-08-14 Thread Dave Sueltenfuss
> Good Afternoon, > > Does anyone know of a free SQL Competency test available? I am looking > for one to give to job applicants, to determine their level of > knowledge > > Thanks in advance > > Dave Sueltenfuss > Application Developer > Certified ColdFus

OT:Advanced SQL Query

2003-08-14 Thread Dave Sueltenfuss
being the column data I know I can do this by hard coding the action values into a view, but I am wondering is there is a way to dynamically create this, so I do not need to modify it when additional actions are added to the process Any help is appreciated Thanks in advance Dave Sueltenfuss

RE: Session timeouts too early

2003-07-29 Thread Dave Sueltenfuss
Peter, I have found that If the user accesses another Application of the same server, they get logged out of the current application they are in. I'm not sure if this helps or not Dave -Original Message- From: Peter Theobald [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 12:46

RE: Does CFMX install require restart?

2003-07-28 Thread Dave Sueltenfuss
I'm not sure about the CFMX install, but I know the updates only require a service restart. Of course, after a major software installation like CFMX, it is a good idea to restart anyways, just in case Dave -Original Message- From: Ryan Kime [mailto:[EMAIL PROTECTED] Sent: Monday, July 2

RE: NULL Madness

2003-07-23 Thread Dave Sueltenfuss
You need to use this for null SELECT * FROM tblCustomers WHERE orderCount is NULL And this for records that are not null SELECT * FROM tblCustomers WHERE orderCount is not NULL Dave -Original Message- From: David K [mailto:[EMAIL PROTECTED] Sent: Wednesday, Ju

SOT: Reporting Software

2003-07-11 Thread Dave Sueltenfuss
info is appreciated Thanks Dave Sueltenfuss Application Developer Certified ColdFusion MX Developer Arch Wireless Phone: 508-870-6711 Fax: 508-870-8011 Email: [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com

RE: How many tables a datasource can handle?

2003-07-08 Thread Dave Sueltenfuss
Jochem, The 2GB limit is an internal Access DB limit, not a FAT limit. On Access 97, I believe it is as low as 1GB, but I could be wrong Dave -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 08, 2003 11:53 AM To: CF-Talk Subject: Re: How many tab

RE: How many tables a datasource can handle?

2003-07-08 Thread Dave Sueltenfuss
o [mailto:[EMAIL PROTECTED] >>Sent: 08 July 2003 02:10 >>To: CF-Talk >>Subject: Re: How many tables a datasource can handle? >> >> >>Hi Dave, yes, i mean split one datasource with 100 tables in two > > datasources > >>with 50 tables each. >>

RE: How many tables a datasource can handle?

2003-07-07 Thread Dave Sueltenfuss
The actually number of objects allowed are 2,147,483,647. Database objects include all tables, views, stored procedures, extended stored procedures, triggers, rules, defaults, and constraints. You can only have 4,096 columns per a select statement, and 1024 columns per an insert statement. Also, a

RE: How many tables a datasource can handle?

2003-07-07 Thread Dave Sueltenfuss
Leonardo, Do you mean spilt the database itself up or just have two datasources pointing to the same database? There should be no performance issue based on the number of tables within a database, unless you are trying to call data from all at once(then again, that really wouldn't work unless you

RE: Non-SysAdmins and DTS

2003-06-23 Thread Dave Sueltenfuss
Never mind, I found the solution. It is under the Job System Tab of the SQL Server Agent Properties Dave -Original Message- From: Dave Sueltenfuss Sent: Monday, June 23, 2003 11:43 AM To: CF-Talk Subject: OT: Non-SysAdmins and DTS > Morning everyone, > > I am trying to

OT: Non-SysAdmins and DTS

2003-06-23 Thread Dave Sueltenfuss
run CmdExec job steps. The step failed. > > Thanks in advance > > Dave Sueltenfuss > Application Developer > Certified ColdFusion MX Developer > Arch Wireless > Phone: 508-870-6711 > Fax: 508-870-8011 > Email: [EMAIL PROTECTED] > ~~~

RE: Custom tag moved to MX custom tag path

2003-06-06 Thread Dave Sueltenfuss
Stan, Do you have a web file in that subdirectory with the same name? Or is it possible you didn't remove the original? If the original was still in the subdirectory, that would be the first place CFMX would pull it from Dave -Original Message- From: Stan Winchester [mailto:[EMAIL PROTE

RE: CFMX Installation Question

2003-06-04 Thread Dave Sueltenfuss
Greg, When I setup my CFMX server, I had a similar issue. I ended up changing all of the ODBC connections to SQL Server authentication, and creating accounts on the SQL Server to connect with. Dave -Original Message- From: Greg Luce [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 200

CFMX Upgrade Issue and Solution

2003-03-24 Thread Dave Sueltenfuss
not care about this, but CF MX was returning an error, even though the page compiled fine. Once the else statement was added, the problem went away. I just wanted to share this issue and solution with the group, in case anyone else comes across a similar issue Any questions, please let me know

RE: Clearing Cached Pages

2003-03-17 Thread Dave Sueltenfuss
548.2337 -Original Message- From: Dave Sueltenfuss [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 11:15 AM To: CF-Talk Subject: Clearing Cached Pages Good Morning, I encountered a problem on Friday where a user continued to see an old page, even after I had updated it. I realize

Clearing Cached Pages

2003-03-17 Thread Dave Sueltenfuss
Thanks Dave Sueltenfuss Application Developer Arch Wireless Phone: 508-870-6711 Fax: 508-870-8011 Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?for

RE: Microsoft to aquire Macromedia

2003-02-12 Thread Dave Sueltenfuss
Its just that, another rumor. There is no truth to it Dave -Original Message- From: Fregas [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 12, 2003 10:12 AM To: CF-Talk Subject: Microsoft to aquire Macromedia Ok, that's a little inflammatory, but has anyone heard this rumor that

RE: end.cfm?

2003-02-11 Thread Dave Sueltenfuss
OnRequestEnd.cfm Thanks Dave Sueltenfuss Application Developer Arch Wireless Phone: 508-870-6711 Fax: 508-870-8011 Email: [EMAIL PROTECTED] -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 11, 2003 3:11 PM To: CF-Talk Subject: end.cfm? What