MSSQL decimal issue

2008-01-30 Thread Dan
select (15 / 11.24) returns 1.334519 - Fine select (13/15) returns 0 ( not 0.8 ... ) How can I get sql server to return the decimal information? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release

Server Instances

2008-01-30 Thread Dan
In regards to multiple installations of CF is there an inherent limit to the number of installations? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclic

Re: MSSQL decimal issue

2008-01-30 Thread Dan
select (cast(13 AS DECIMAL) / cast(15 AS DECIMAL)) Thanks Brother! ~| 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 Arc

Missing Template Handler problems.

2008-02-05 Thread Dan
Added the template to Settings 'Missing template handler' -- It does call up my template but also still includes the default Coldfusion. "Error Occurred While Processing Request File not found:" Message. Also made the following changes to IIS as described here: http://kb.adobe.com/selfservice

Re: Where do i find CFGRID Code?

2010-04-21 Thread Dan Blickensderfer
Mike, Make sure you have the virtual directory "cfide" setup on your sub domain website. That virtual directory needs to be pointing to your cfide directory of your server. I've ran into that as well but just not cfgrid. it was all cfide components. Thanks, Dan - O

Solr versus Verity

2010-04-26 Thread Dan Baughman
seem to basically scramble themselves every so often despite my liberal use of locking. The inputs appreciated, Dan ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion

Re: Using two submit buttons to control form action

2010-04-28 Thread Dan Baughman
I'm using cf9 on iis7 and when I put what you've provided into a form, form.choose is either equal to change, or full, depending on which button was clicked. On Wed, Apr 28, 2010 at 6:24 PM, John Pullam wrote: > > I have seen several examples of using multiple form buttons on a single > form. Th

CF9 Local scope issues

2010-04-29 Thread Dan Crouch
We are having all kinds of issues with the local scope in converting our application over to CF9. I have a few variables in the local scope named Filter_1, Filter_2, etc.. So I am looping through a counter to see if they exist like this (loop excluded). The problem is that it never finds th

Re: CF9 Local scope issues

2010-04-29 Thread Dan Crouch
That didn't work either. This also works fine, but I still don't get the changes to Local that make it so different now. Not to mention the code that needs to be changed to get this to work on CF9. >Use array notation: > >On Thu, Apr 29, 2010 at 2:08 PM

Mail Server Software

2010-05-10 Thread Dan Pacitti
Does anybody know of a good mail server with some sort of SQL or CF integration? A few years back we were looking at IMS mail server. Thanks DanP ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldf

Re: Mail Server Software

2010-05-10 Thread Dan Blickensderfer
Dan P, I use hmailserver it has a MySQL database back end and it's free. It's windows only and you can download it from www.hmailserver.com I have some cf apps that I wrote and use that database to make changes. It works quite well. Dan B - Original Message - From: "D

Select List: in edit mode, multiple selections - Stumped!

2010-05-11 Thread Dan Sullivan
I'm in edit mode in my form, passing and URL.id value which is a product id. I'm trying to get the atribId values: 17, 19, 22, 61, 74 to populate my multiple select box as selected, but it's only working for the first value 17. select name, id from giftAttributes select gftIdatribId

Re: Select List: in edit mode, multiple selections - Stumped!

2010-05-11 Thread Dan Sullivan
It worked! Thank you. >This is like outputting url_sizes.attributeId outside a cfoutput tag, it >only gets the first item. You need to set the attributeId column into a >list: > > > >On Tue, May 11, 2010 at 12:04 PM, Dan Sullivan < >coldfusiondevelope...@gmai

Re: Cfdebug and CFCs with $.get

2010-05-17 Thread Dan Vega
In your url you can pass the cf_nodebug attribute cfc/foo.cfc?method=getFoo&returnformat=json&_cf_nodebug=true Thank You Dan Vega danv...@gmail.com http://www.danvega.org/ On Mon, May 17, 2010 at 8:05 AM, Chad Baloga wrote: > > I am using some jQuery $.get's with CFCs

Re: ColdFusion and .NET Web Services running WSE 3.0

2010-06-04 Thread Dan O'Keefe
Philip, Did you authorization require WS-Security? Dan -- Dan O'Keefe On Thu, Apr 29, 2010 at 12:13 PM, Phillip Duba wrote: > > Dave, thanks for the response. I've gone to executing the request using > CFHTTP, creating the soap:Header tag and building it as I

Re: ColdFusion and .NET Web Services running WSE 3.0

2010-06-06 Thread Dan O'Keefe
James, I would be interested in participating on this as well as I have a current need for the WS-Security piece with ExactTarget API. Dan On Sat, Jun 5, 2010 at 7:13 AM, James Holmes wrote: > > OK, I'll finish up the webservice wrapper CFC on which I'm working and then

Programmatic manipulation of DSN settings

2010-06-07 Thread Dan Baughman
Can you update, add, and delete datasources via code in ColdFusion? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http:/

Re: Programmatic manipulation of DSN settings

2010-06-07 Thread Dan Baughman
Nice is that new to coldfusion 9? On Mon, Jun 7, 2010 at 12:33 PM, Dave Watts wrote: > > > Can you update, add, and delete datasources via code in ColdFusion? > > Yes, through the Admin API: > > http://help.adobe.com/en_US/ColdFusion/9.0/Admin/WSc3ff6d0ea77859461172e0811cbf364104-7fcf.html > >

Re: CF901 Released

2010-07-13 Thread Dan Crouch
I installed this on our test server and every datasource that is wrapped for SeeFusion is failing now. All of the other datasources are fine. So that may be something to keep in mind for folks using SeeFusion. I haven't found a fix for it yet. java.sql.SQLException: macromedia.jdbc.sqlserver.S

Re: CF901 Released

2010-07-13 Thread Dan Crouch
Oddly enough, it is the other way around. Any datasource that was NOT wrapped by SeeFusion is not working. Anything that is wrapped in the SeeFusion driver works fine. So I go create another SQL datasource and it will break, it gives me that same error. I wrap that datasource for SeeFusion and

Re: CF901 Released

2010-07-13 Thread Dan Crouch
Thanks, I updated that and restarted the CF service and they are working again. > Hey Dan: > Rename the macromedia_drivers.jar file in WEB-INF/cfusion/lib and > replace it with the same file from > /WEB-INF/cfusion/updater_backup/lib > > I don't know what the real prob

Re: Adobe no longer part of the OpenCFML committee

2010-07-23 Thread Dan Baughman
Is there an official adobe announcement that it pulled out? On Thu, Jul 22, 2010 at 5:10 PM, Sean Corfield wrote: > > On Thu, Jul 22, 2010 at 12:20 PM, Gerald Guido > wrote: > >>>Or support for Amazon Web services: S3 (well before Adobe did), > > > > My bad. Before I get a public tongue lashin

Re: Regex Help

2010-07-26 Thread Dan Baughman
kidding? i already spent $15! On Mon, Jul 26, 2010 at 6:52 PM, andy matthews wrote: > > You know I was kidding right? > > -Original Message- > From: Bobby Hartsfield [mailto:bo...@acoderslife.com] > Sent: Monday, July 26, 2010 6:21 PM > To: cf-talk > Subject: RE: Regex He

Re: SQL Server Data Archival - my solution

2010-08-02 Thread Dan O'Keefe
I find this intriguing as well. Almost like a poor mans historical archive system. A generator for the triggers would be cool also based on Illidium PU-36 -- Dan O'Keefe On Fri, Jul 30, 2010 at 9:08 AM, Pete Ruckelshaus wrote: > > Feel free to pass on any enha

Re: Millions of Coldfusion sites need to apply patches

2010-08-12 Thread Dan Baughman
Millions of sites applying one patch is better than Millions of sites applying Millions of patches ^^ http://www.digitaltrends.com/computing/microsoft-issues-record-number-of-patches/ ~| Order the Adobe Coldfusion Anthology n

Re: (ot) CKFinder - anyone know about how licensing works?

2010-09-14 Thread Dan O'Keefe
I have a client having the same issue as far as contacting Fred regarding a new purchase, and no response. Dan On Wed, Aug 25, 2010 at 11:45 PM, Mike Kear wrote: > > G'day Gerald, > > I think you might be right.   There was nothing that I saw telling me > that BEFORE i ma

Really odd problem - cpu utilization at idle

2010-09-15 Thread Dan Baughman
ML files in the ColdFusion install folder. We pulled the server from production and this issue recurs if its just sitting there by itself. Any suggestions on how to figure out what JRUN is doing ?? I've never had this problem

Re: Really odd problem - cpu utilization at idle

2010-09-15 Thread Dan Baughman
15, 2010 at 5:36 PM, Mark A. Kruger wrote: > > Dan, > > What's the setting for client vars? > > -mark > > Mark A. Kruger, MCSE, CFG > (402) 408-3733 ext 105 > Skype: markakruger > www.cfwebtools.com > www.coldfusionmuse.com > www.necfug.com > > &g

Re: Really odd problem - cpu utilization at idle

2010-09-16 Thread Dan Baughman
Ok I switched it to use an empty database for the client vars. Also I do have the option of dropping back to developer mode. I googled and didn't see how to do drop back to developer mode, is this an XML file somewhere? Thanks for suggestions so far, all. On 9/16/10, Mark A. Kruger wrote: > >

Re: Shorter URLs - How?

2010-09-21 Thread Dan Baughman
Well not to get to technical but cf actually sees the rewritten URL. The bots see the seo URL before it is rewritten Dan Baughman On Sep 21, 2010, at 5:06 PM, Jacob Munson wrote: > > They see the rewritten URL. > > Sent with my Android phone > > On Sep 21, 2010 4:2

Re: Really odd problem - cpu utilization at idle

2010-09-22 Thread Dan Baughman
Ok I got this taken care of, it was the registry values! I wasn't using Client variables, but I had client management set to yes in the application.cfm I disabled that, and cleared that reg key that stores the client variables and like magic the server is 100% Clientmanagement=yes is basica

Video analysis

2010-09-22 Thread Dan Baughman
fileformat, video codec, etc. Regards, Dan ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/grou

Re: Really odd problem - cpu utilization at idle

2010-09-22 Thread Dan Baughman
My hesitation on cookie is adding the un-necessary bandwidth to every request. I think the best move is a hybrid. 1) disable client vars using clientmanagement=no in your cfapplication 2) set it to database or cookies. On Wed, Sep 22, 2010 at 2:57 PM, Russ Michaels wrote: > > set the default

Managed Exchange Host

2010-10-02 Thread Dan Crouch
Can anyone recommend a good managed exchange host? We are using Rackspace but are having serious delivery delay issues and need to go somewhere else. We did get a recommendation to try Sherweb, but I don't really know anything about them.

Re: Managed Exchange Host

2010-10-02 Thread Dan Crouch
No, I hadn't considered that. But I am looking at it now. It actually looks very promising for what we need. Thanks, Dan ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Mi

Simple question

2010-10-07 Thread Dan Baughman
Hi All, What is the easiest way in coldfusion to "touch" a file. IE. updates it's modified time to be now. I can think of a few hacks, but was looking for something super easy and graceful. Dan ~| Order the A

Re: Simple question

2010-10-07 Thread Dan Baughman
So if you set the output to blank it doesn't over write the contents of the file? On Thu, Oct 7, 2010 at 1:13 PM, John M Bliss wrote: > > cffile action="write" file="c:\temp\temp.txt" output="" > > On Thu, Oct 7, 2010 at 2:05 PM, Dan Baughman >

Re: Simple question

2010-10-07 Thread Dan Baughman
with courage makes a majority. > -Andrew Jackson > > A fine is a tax for doing wrong. A tax is a fine for doing well. > > On Oct 7, 2010, at 2:29 PM, Dan Baughman wrote: > > > > > So if you set the output to blank it doesn't over write the contents of > the >

Hosted VPS recommendations

2010-11-18 Thread Dan Crouch
remotely? Dan ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339356

Re: Hosted VPS recommendations

2010-11-20 Thread Dan Vega
+1 for KickAssVPS They have just been awesome.. I can't speak to their customer service because quite frankly, I have never needed them in 2 years... GREAT VPS Thank You Dan Vega danv...@gmail.com http://www.danvega.org/ On Thu, Nov 18, 2010 at 2:18 PM, Gerald Guido wrote: > >

Re: Diagnosing DB / CF problem

2010-11-28 Thread Dan Crouch
t seems to temporarily have gotten stuck on stupid. Dan ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/grou

Re: Excel File Parser for ColdFusion

2010-11-29 Thread Dan Baughman
Not off the top of my head, but I recall that you have to close both the resource and the queryobject using a .close function, or the resource handle stays open and you end up having to restart coldfusion every so often. On Mon, Nov 29, 2010 at 10:02 AM, Joel Rivera wrote: > > :):):) > > ~

CFWDDX Serialization and Deserialization

2010-12-06 Thread Dan Baughman
It has recently (and very painfully) come to my attention that cfwddx serialize doesn't encapsulate strings in CDATA markers. This removes your ability to have HTML/XML markup in a string that is part of a struct you are trying to serialize/deserialize with out paying special attention to each st

Re: CFWDDX Serialization and Deserialization

2010-12-06 Thread Dan Baughman
the right one this time. On Mon, Dec 6, 2010 at 4:43 PM, Russ Michaels wrote: > > Could you use CFJSON instead > > http://cfjson.riaforge.org/ > > Russ > > -----Original Message- > From: Dan Baughman [mailto:dan.baugh...@gmail.com] > Sent: 06 December 20

Re: CFWDDX Serialization and Deserialization

2010-12-07 Thread Dan Baughman
I'll throw together a segement code later for those interested. It's really more basic than that. On Tue, Dec 7, 2010 at 7:11 AM, Jason Fisher wrote: > > Sounds like the OP's issue is XML, not HTML, where the CDATA blocks can't > be nested. Not sure there's a solution for that one ... > >

Re: Hosted VPS recommendations

2010-12-07 Thread Dan Crouch
offer fairly beefy VPS hosting, or a suitable replacement for that hosting.com setup? Dan ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive

Re: ProFlashUpload

2010-12-13 Thread Dan O'Keefe
not need it at all with the cffileupload tag. -- Dan O'Keefe On Mon, Nov 29, 2010 at 8:42 AM, M P wrote: > > Anyone familiar with ProFlashUpload? I downloaded it and got it working > yesterday and it was working fine. Today, it only works in IE. Yesterday I > kn

Re: (ot) jQuery Facebook Wall Display

2011-01-05 Thread Dan O'Keefe
Justin, Are you looking for the "Recent Activity" as shown on this site: http://www.campuscircle.com/ Dan On Tue, Jan 4, 2011 at 8:04 AM, Justin Scott wrote: > > Is anyone aware of a jQuery plugin (or script which uses jQuery) to pull a > Facebook feed from their graph AP

Re: What's the best way to investigate a Jrun.exe spike?

2011-01-05 Thread Dan Baughman
Use cfstart to run coldfusion command line, and then do stack dumps using ctrl-pausebreak when it spikes. There is an adobe tech note on how to do that. In addition to that, Process Monitor from Mark Russinovich is also very good ( and free). On Wed, Jan 5, 2011 at 4:31 PM, Philip Kaplan wrote

RE: OT? Macromedia Contribute, is it Content Management or not?

2002-11-11 Thread Dan Phillips
To me, it looks similar to the CMS packages offered by ektron.com -Original Message- From: Sandy Clark [mailto:slLists@;shayna.com] Sent: Monday, November 11, 2002 3:38 PM To: CF-Talk Subject: RE: OT? Macromedia Contribute, is it Content Management or not? It was described to me as (by M

Re: basic question

2002-11-11 Thread Dan Blickensderfer
You need to place an & between your variables and remove your single quotes. Like this: listing page Dan - Original Message - From: "Tim Laureska" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, November 11, 2002 8:09 PM Subject:

RE: CF Administrator

2002-11-12 Thread Dan Phillips
Sounds like maybe your bowser is caching your log on session. Close your browser and open a new or clear out your cache. That should make it prompt you again. Thank you, Dan Phillips Express Technologies, Inc. dba HalfPriceHosting, CFXHosting and Invotion. www.HalfPriceHosting.com

RE: CF Administrator

2002-11-12 Thread Dan Phillips
Have you tried it on another workstation? -Original Message- From: Eric Creese [mailto:ecreese@;popmail.com] Sent: Tuesday, November 12, 2002 4:26 PM To: CF-Talk Subject: CF Administrator This was always checked. I even tried disabling it and saving it. then enable it with a password and

Flash Com and CFUG meeting

2002-11-13 Thread Dan Phillips
, Dan Phillips Express Technologies, Inc. dba HalfPriceHosting, CFXHosting and Invotion. www.HalfPriceHosting.com www.CFXHosting.com www.Invotion.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription

RE: Flash Com and CFUG meeting

2002-11-13 Thread Dan Phillips
a fantastic solution to a lot of communication needs. It could change the world of presentations -- for both the presenters and the audience. Dick On Wednesday, November 13, 2002, at 07:29 AM, Dan Phillips wrote: > I watched the nycfug meeting last night using Flash Com and noticed > tha

RE: SSL Post

2002-11-15 Thread Dan Phillips
Sounds to me like they may be talking about a Payment gateway which allows you do charge credit cards in real time. PayFlow Pro from Verisign has a ColdFusion java tag that will work with your existing pages. -Original Message- From: charlie griefer [mailto:charlie@;griefer.com] Sent: Frid

RE: SSL Certificate usage in Cold Fusion

2002-11-18 Thread Dan Phillips
Matt Conway is who I have worked with and he is very efficient. Thank you, Dan Phillips Express Technologies, Inc. dba HalfPriceHosting, CFXHosting and Invotion. www.HalfPriceHosting.com www.CFXHosting.com www.Invotion.com -Original Message- From: Bartee Lamar [mailto:[EMAIL PROTECTED]]

RE: When CFHTTP fails, use WGET

2002-11-19 Thread Dan Phillips
I've also found that adding domain names to the windows hosts file helps as well. This file is in the c:\winnt\system32\drivers\etc dirctory. Thank you, Dan Phillips Express Technologies, Inc. dba HalfPriceHosting, CFXHosting and Invotion. www.HalfPriceHosting.com www.CFXHostin

Re: Grabbing Stock Quotes

2002-11-21 Thread Dan Blickensderfer
look for the old url: http://quote.yahoo.com/d/quotes.csv?S=#Symbol_List#&f=sl1d1t1c1ohgv&e=.csv"; or you can contact Rob Brooks-Bilson at ([EMAIL PROTECTED]) and he can send you the updated stockgrabber.cfm file. Thanks, Dan - Original Message - From: "Angel Stewa

Re: Grabbing Stock Quotes

2002-11-21 Thread Dan Blickensderfer
Gel, If Rob does care I will send you the update that he sent me. I'll send it to you off line. Thanks, Dan - Original Message - From: "Angel Stewart" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, November 21, 2002 12:37

RE: OPINIONS: PayFlow Pro and CF Integration?

2002-11-22 Thread Dan Phillips
I've assited quite a few people over the last year as well and I have had great results. Easy to install, easy to test, use, troubleshoot, etc. Whenever I get a customer now that wants to enter into real time processing, I always strongly advise that they use this tag. Thank you, Dan Phi

RE: DWMX Sites

2002-12-03 Thread Dan Phillips
I work with actual sites more than just applications. So I always create a new "site". I don't think you can breakup a "site" into smaller pieces. Thank you, Dan Phillips Express Technologies, Inc. dba HalfPriceHosting, CFXHosting and Invotion. www.HalfPriceHosti

RE: DWMX - Moving blocks of code.

2002-12-10 Thread Dan Phillips
doesn't look like he has uploaded them yet. Once I do, I'll grab the DLLs and put them on Sluggo for future use. -Original Message- From: Everett, Al [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 10, 2002 9:59 AM To: CF-Talk Subject: RE: DWMX - Moving blocks of code. Actually, you c

RE: DWMX - Moving blocks of code.

2002-12-10 Thread Dan Phillips
sorry, ignore this. wrong button ;-) -Original Message- From: Dan Phillips [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 10, 2002 10:08 AM To: CF-Talk Subject: RE: DWMX - Moving blocks of code. doesn't look like he has uploaded them yet. Once I do, I'll grab the DLLs an

RE: Anonymous Access to Web Server -- CF 5.0

2002-12-10 Thread Dan Phillips
Add permission for the userID IUSR. This is the anonymous username and Win2k (and XP) use. -Original Message- From: Nick Baker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 10, 2002 5:06 PM To: CF-Talk Subject: Anonymous Access to Web Server -- CF 5.0 First and foremost -- I am a se

RE: Determining if cf is alive and communicative

2002-12-11 Thread Dan Phillips
If you prefer to get something pre-made check out http://www.deepmetrix.com/ipmonitor/ We use this to monitor basic things like ping, and if service are running. I know you can have it monitor an Oracle ODBC connection as well. Thank you, Dan Phillips Express Technologies, Inc. dba

RE: Easy CFFILE ?

2002-12-21 Thread Dan Phillips
Is the server out of disk space? That could be a "hardware problem". -Original Message- From: Eric Hoffman [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 21, 2002 2:06 PM To: CF-Talk Subject: RE: Easy CFFILE ? For real though, it can't be that, can it? (I could imagine it with this

Re: escaping special characters between

2000-06-22 Thread Dan Cameron
Thanks - this is very helpful. BTW - any characters I need to watch out for besides # and "? aloha Dan - Original Message - From: "Jeff" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, June 21, 2000 3:57 PM Subject: Re: escaping special charact

RE: cgi.scriptname?

2000-06-27 Thread Dan Haley
Bryan, There is no checking for the existence of CGI variables in CF . . . anything goes, with no error messages. You are looking for cgi.script_name. Dan -Original Message- From: Bryan Batchelder [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 27, 2000 3:24 PM To: '[EMAIL PROT

RE: Weird Prepend

2000-06-28 Thread Dan Haley
Or an errant application.cfm that was saved with the default Studio template. Dan >>> Somewhere you've probably got an include that has this info in it. It has nothing to do >>> with CF Studio or the server itself. >>> ---mark > All cfm p

RE: Changing default CF error for nonexistent templates

2000-06-28 Thread Dan Haley
Just out of curiosity, where abouts is the mapping in 4.5 for this? I don't see it right off hand in the administrator. As for 4.01 with IIS you can tell IIS to check for the existence of the template first, and then use a custom 404 error message page, which is also defined in IIS.

Re: create a date for table

2000-06-29 Thread Dan Blickensderfer
Ellie, In SQL use the getdate() function. Dan - Original Message - From: "Elaine L" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 29, 2000 1:41 AM Subject: RE: create a date for table > Hi, > > I tried to set up the field in Mi

RE: Archive

2000-06-29 Thread Dan Haley
http://www.pdm-inc.com/mky.htm -Original Message- From: Angél Stewart [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 29, 2000 9:45 AM To: [EMAIL PROTECTED] Subject: Re: Archive Umm..so where is the Searchable list archive =) -Gel - Original Message - From: Sharon DiOrio <[EMA

RE: On storing query results in session variables

2000-06-30 Thread Dan Haley
often your data changes. For displaying 10 rows at a time, use the 'startrow' and 'maxrows' attributes of . . There are other ways to do this, but if this meets your needs it is most likely the simplest. Dan -Original Message- From: Dana Larose [mailto:[EMAIL PRO

RE: reading text files

2000-06-30 Thread Dan Haley
ted before heading for home . . . :) Dan -Original Message- From: Jason Egan [mailto:[EMAIL PROTECTED]] Sent: Friday, June 30, 2000 3:01 PM To: [EMAIL PROTECTED] Subject: RE: reading text files yeah! --- that is exactly what we've had to do in the past, but we need to automate

Re: Optimizing Win 2000 (IIS) for Warp speed with Cold Fusion.

2000-07-03 Thread Dan Blickensderfer
Mark, Could you post your results on NT 4, IIS, CF. Thanks, Dan - Original Message - From: "Mark W. Breneman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 03, 2000 11:47 AM Subject: OT: Optimizing Win 2000 (IIS) for Warp speed with Cold Fusion

memo fields and paragraphs

2000-07-03 Thread Dan Schueler
Does anyone know how to preserve the paragraphs (carriage returns) in text in a memo field? When I copy text from something like a Word document and paste it into a memo field, it seems to smash all the lines together, as though the paragraphs weren't there at all. Looking at the data in the Ac

RE: memo fields and paragraphs

2000-07-03 Thread Dan Schueler
Thanks, Jennifer, that was exactly what I was looking for. Works great! -Original Message- From: Jennifer [mailto:[EMAIL PROTECTED]] Sent: Monday, July 03, 2000 2:51 PM To: [EMAIL PROTECTED] Subject: Re: memo fields and paragraphs At 02:27 PM 7/3/00 -0700, you wrote: >Does anyone know

Oracle queries - 4000 character limit . . . anything new?

2000-07-05 Thread Dan Haley
native drivers. Thanks for any insights . . . . Dan ** Oracle Stored Procedure ** procedure update_state(p_cfid IN varchar2, p_state IN long) as begin insert into app_state (cfid, state, lastwritten) values (p_cfid, p_state, sysdate); exception when dup_va

RE: Oracle queries - 4000 character limit . . . anything new?

2000-07-05 Thread Dan Haley
at the end of the page. Must have been the collective minds of all the west coast people reading my email . . . thanks . . . :) Dan -Original Message- From: Jennifer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 05, 2000 5:19 PM To: [EMAIL PROTECTED] Subject: Re: Oracle queries - 4000

RE: custom tag for calculating business hours

2000-07-06 Thread Dan Haley
decide if it is a weekend or holiday, which you can discard. For all other days, check if they are the start or the end date . . . if not they consist of a full work day . . . if they are, then you only need to work with the time component. Dan -Original Message- From: Tom Dyson [mailto

RE: Rounding of numbers

2000-07-06 Thread Dan Haley
formatting section of the CF functions where you will find decimalformat, dollarformat, numberformat, etc. Dan -Original Message- From: Stewart McGowan [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 06, 2000 9:42 AM To: '[EMAIL PROTECTED]' Subject: Rounding of numbers Sor

RE: lists and variable names

2000-07-07 Thread Dan Haley
Try these changes . . . I changed a couple of other things to "give back" some of what I've learned on this list . . . :) Dan -Original Message- From: Adrian Cesana [mailto:[EMAIL PROTECTED]] Sent: Friday, July 07, 2000 9:49 AM To: [EMAIL PROTECTED] Sub

RE: Why does blank dates default to 1899-12-30?

2000-07-07 Thread Dan Haley
(or return whatever you want to display). If it is not null then it returns the datefield. The alias is required or your column name would be nvl(datefield,'-'). There should be a similar Foxpro SQL function, or something like Access' iif statement. Dan -Original Message---

OT: Webcams . . .

2000-07-07 Thread Dan Haley
ation which would then upload the pictures to the web server? Do webcams come with the software to do the upload? Thanks for any input. Dan -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe

RE: Oracle on Windows?

2000-07-07 Thread Dan Haley
We are running CF4.5.1 on a Windows NT4.0 machine, and the Oracle ODBC drivers and native drivers work fine. The native drivers were included with CF . . . the ODBC drivers may have come from the Oracle client install. Dan -Original Message- From: Dana Larose [mailto:[EMAIL PROTECTED

RE: SQL Question: Select a list of most recent records from a table that stores User Histories,for ALL users.

2000-07-07 Thread Dan Haley
designed, etc., this may or may not slow you down. Two: Sort the query (order by emp_id, effective_date desc) and then use your CF to compare emp_id to the previous row and only output if it is different. output stuff Dan -Original Message- From: Angél Stewart [mailto:[EMAIL

RE: Testing Assignment

2000-07-10 Thread Dan Haley
didn't know any of these existed until now! I found out about it from http://www.nwi.net/~pchelp/obscure.htm. Wonder if the list is down? Or just quiet because everyone is working on this . . . haha. Dan -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Monday,

RE: ColdFusion and clustering

2000-07-10 Thread Dan O'Keefe
Check out the June ColdFusion Developers Journal. There is a pretty good article on how to set up a client var database storage mechanism for clustered servers written by Marc Funaro. Dan -Original Message- From: Gregory Harris [mailto:[EMAIL PROTECTED]] Sent: Monday, July 10, 2000 4:25

RE: Testing Assignment

2000-07-10 Thread Dan Haley
Hmmm, glad I didn't post my response to the list . . . damn glad I don't have to work with hex or I'd definitely have to learn a few things . . . haha -Original Message- From: Mike Sheldon [mailto:[EMAIL PROTECTED]] Sent: Monday, July 10, 2000 3:51 PM To: [EMAIL PROTECTED] Subject: RE: Te

RE: SQL

2000-07-10 Thread Dan Haley
Where Blah NOT IN ('blah1', 'blah2') will work in Oracle . . . Dan -Original Message- From: Adrian Cesana [mailto:[EMAIL PROTECTED]] Sent: Monday, July 10, 2000 5:14 PM To: [EMAIL PROTECTED] Subject: SQL Is there anyway to do the opposite of this...? I need s

Faster way???

2000-07-10 Thread Dan Haley
. . . Would still like thoughts on any faster ways . . . Thanks, Dan -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&

Re: Seeking Text Rollover

2000-07-11 Thread Dan Blickensderfer
Richard, Here is what I use. - Original Message - From: "Dana Larose" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, July 11, 2000 1:59 PM Subject:

RE: SQL UPDATE

2000-07-11 Thread Dan Haley
Something similar to this should work (not sure of the MSSQL syntax): update table1 t1 set t1.date1 = '#currentdate#' where t1.date1 is null and exists (select 'x' from table2 t2 where t2.po = t1.po) Dan -Original Message- From: Adrian Cesana [mailto:[EMAIL PROTE

RE: Increase timeout from FORM

2000-07-11 Thread Dan Haley
I know there have been discussions on this before and whether it is 'legal' HTML or not, but you should be able to include the requesttimeout parameter in the action attribute of your form tag: Dan -Original Message- From: Adrian Cesana [mailto:[EMAIL PROTECTED]] Sent: Tuesda

RE: Form.Fieldnames Missing

2000-07-12 Thread Dan Haley
I can recreate the error if the only form elements that are named are checkboxes and radio buttons, and none of them have been checked or selected. At that point form.fieldnames is not defined in the action page. Any chance your form only has checkboxes and radio buttons? Dan -Original

RE: Queries to Oracle Slow from CFAS (tds)

2000-07-12 Thread Dan Haley
ublish the "source" tnsnames.ora out to the web servers. For some reason this was about a four second lag problem the first hit to the database on each page, even with maintain connections set, but now it is gone! Dan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECT

RE: Form.Fieldnames Missing

2000-07-12 Thread Dan Haley
We'd love to hear the solution . . . I'm sure this will be on Michael's next test . . . -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 12, 2000 10:26 AM To: [EMAIL PROTECTED] Subject: RE: Form.Fieldnames Missing While the form isn't only che

RE: searches failing...help.

2000-07-12 Thread Dan Haley
When you use "like" in a sql statement you will need to use wild-cards. In Oracle it would be "where knowledge like '%#search_string#%'. I believe Access uses the asterisk - '*#search_string#*'. Dan -Original Message- From: miles [mailto:[EMAIL P

RE: saving queries

2000-07-12 Thread Dan Haley
What you've got is close. If you want the variable to persist over time you will need to use a session, application, or server variable. For these keep an eye on the threads, or check out the documentation. select myfield from . . . #myfield# Dan -Ori

  1   2   3   4   5   6   7   8   9   10   >