RE: Re: (Admin) Behavior

2002-07-25 Thread Dan Haley
Come on ... 'one list under god' just might be a problem ... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 10:52 AM To: CF-Talk Subject: OT: Re: (Admin) Behavior lol that opened a can of worms :) Now all the atheists are gonna be p

RE: Write Acrobat File via CF

2002-07-25 Thread Dan O'Keefe
Are those forward slashes mixed in with the backslashes in the path? Dan -Original Message- From: Whiterod, David (PLNSA) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 11:43 PM To: CF-Talk Subject: RE: Write Acrobat File via CF Speaking of CF_HTML2PDF3. Can anyone shed

RE: 3 column output

2002-07-25 Thread Dan Haley
Not sure how well it will work with true-type fonts and the browsers ... but if you have enough text this might look ok. ** Not tested! ** Dan -Original Message- From: Justin Hansen [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 12:21 PM To: CF-Talk Subject: 3 column

RE: Coldfusion & Hiermenus

2002-07-29 Thread Dan Haley
er, and we couldn't get them to be any faster. Single level menus would have been fine, but that didn't meet our needs. Positioning was never a problem ... probably been two years since we did it, so we didn't have Netscape 6+ to deal with at the time. Dan -Original Message-

RE: anyone having list troubles ?

2002-07-29 Thread Dan Haley
I see that same problem sometimes ... the other day I received 100 list emails at one time, but the threads had continued while I wasn't getting them, so the list server was working fine ... and of course my admin says there's no problem here! Dan -Original Message- From: Cr

RE: anyone having list troubles ?

2002-07-29 Thread Dan Haley
Sorry, didn't answer your question ... yes, there have been quite a few posts since then ... -Original Message- From: Craig Thomas [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 8:52 AM To: CF-Talk Subject: anyone having list troubles ? Sorry for the OT post, but I seem to be

RE: Spaces stripped out of query return values?

2002-07-29 Thread Dan Haley
a non-printable character for the rpad so you don't end up replacing something in your data. Dan -Original Message- From: Yexley Robert D Contr Det 1 AFRL/WSI [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 10:10 AM To: CF-Talk Subject: RE: Spaces stripped out of query return

RE: SQL question

2002-07-29 Thread Dan Haley
You didn't mention database ... In Oracle you could use: decode(instr(part_number, '.'), 0, part_number, substr(part_number, 1, instr(part_number) - 1)) = other_part_number You're idea of loading a master part number may yield better results depending on how big

RE: Multiple User Authorization

2002-07-29 Thread Dan Haley
so in the database. When a page loads we create a structure called request.security and fill it with boolean values for all the roles. Then on any page you can check for request.security.name_of_some_role and if true, they are a member. Dan -Original Message- From: Paul Giesenhagen [mailt

CFusion_VerifyMail()

2002-07-30 Thread Dan O'Keefe
ented CFusion_VerifyMail() function which takes three parameters - the server to be checked (IP address or DNS name), the port, and a timeout interval. CFusion_VerifyMail() returns a string that may be inspected - if it is empty then the verification was successful, otherwise it will contain an error message.

CF and Oracle -- checking for a record lock

2002-07-30 Thread Dan Haley
k! Thanks, Dan __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubsc

RE: Number of times a character is in a string

2002-07-30 Thread Dan Haley
Only problem is if they are talking about AA or AAA ... multiple delimiters in a row don't count as additional list items. Try this - get rid of all the occurrences and see how much the length changes: Dan -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]]

RE: Number of times a character is in a string

2002-07-30 Thread Dan Haley
Whoohoo. Dan Haley Creator of Readable Code -Original Message- From: Chris Lofback [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 30, 2002 1:16 PM To: CF-Talk Subject: RE: Number of times a character is in a string Yes, I threw it together too quickly. But Dan Haley nailed it

OT: PDFWriter

2000-08-23 Thread Dan Haley
proper place don't seem to work. Anyone deal with an issue like this before? Thanks, and sorry for the OT post . . . just not getting much help on the Adobe forums, or from Adobe support, or from some of the other sites dealing with PDFs . . .

RE: Combining Application.cfm with other CFINCLUDE's

2000-08-24 Thread Dan Haley
For the timeout attributes in , use sessiontimeout="#createtimespan(52,0,0,0)#". BTW, this will create a timeout of 52 days. The numbers represent days, hours, minutes, seconds. Dan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, August

RE: weird problem

2000-08-24 Thread Dan Haley
gns a value of zero if it is null and option 2 would be where state is null and quantity is not null But, it looks like you aren't using Oracle, so you'll have to determine how to do this with your database! HTH, Dan -Original Message- From: S R [mailto:[EMAIL PROTE

RE: Blank pages

2000-08-28 Thread Dan Haley
It sounds like this page is the result of submitting a form. Have you validated that the action="" is correct in the form tag? It sounds like an IE error message for a page that doesn't exist. Maybe it isn't ever getting to your server because of the page with the form?

RE: (IIS) Customer file uploads - restrictions of file types

2000-08-30 Thread Dan Haley
e based on the file extension? Or, thinking hard now, someone mentioned an application/unknown mime type? Would that be my answer? Hmmm, off to test this. Better and previously thunk answers accepted gladly. :) Dan -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent:

RE: Oracle Concatenation???

2000-08-31 Thread Dan Haley
Use two pipe symbols. SELECT image_title, 'http://www.hello.com/empower/global/' || filename AS image_location Dan -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 31, 2000 10:58 AM To: CFTalk Subject: Oracle Con

RE: Javascript Question

2000-08-31 Thread Dan Haley
r x = true; function processClick() { if (x) { x = false; . . . do rest of processing . . . } } Dan -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 31, 2000 11:27 AM To: '[EMAIL PROTECTED]' Sub

RE: Netscape and IE difference

2000-09-01 Thread Dan Haley
I'm not sure what the stylesheet attributes are, but in the body tag itself you can use marginheight and marginwidth - works in NN4+. Dan ** courtesy of www.blooberry.com! -Original Message- From: Mike Deane [mailto:[EMAIL PROTECTED]] Sent: Friday, September 01, 2000 7:10

RE: How to display across a row instead of down?

2000-09-01 Thread Dan Haley
#query.field[((variables.i - 1) * variables.num_cols) + variables.j]# Dan -Original Message- From: Michael Kear [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 31, 2000 11:12 PM To: [EMAIL PROTECTED] Subject: How to display across

RE: [RE: How to display across a row instead of down?]

2000-09-03 Thread Dan Haley
Yes, I'm hoping Mike realized he could ignore my answer . . . instead of thinking about how simple it was, I just modified my code that outputs a query in vertical rows. Go with the simplest solution Mike! #myquery.myfield# Dan -Ori

RE: next row in

2000-09-05 Thread Dan Haley
#myquery.myfield[myquery.currentrow + 1]# And don't forget to check for when you are in the last row. ;) Dan -Original Message- From: Tim Bahlke [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 11:53 AM To: [EMAIL PROTECTED] Subject: next row in Hey all, I am lo

RE: Question

2000-09-06 Thread Dan Haley
angedelims(list, "','")#') I think. ;) But it's close. :) Dan -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 9:42 AM To: [EMAIL PROTECTED] Subject: Question This is a multi-part message in MIME format

RE: count() or recordcount

2000-09-06 Thread Dan Haley
your best bet rather than pulling the data across the wire and using CF's recordcount. SQL vs. CF . . . two separate beasts, or was that two separate mutants? Or was that thread on fusebox? I'm confused now! ;) Dan -Original Message- From: Bud [mailto:[EMAIL PROTECTED]]

RE: count() or recordcount

2000-09-06 Thread Dan Haley
Even on small tables the difference is pretty big percentage wise . . . a quick test (10 iterations) on a table with 140 rows shows an average of 50 ms doing select * and recordcount, 11 ms using select count(*). If you have a lot of traffic on that page 40 ms could mean a lot. Dan

Oracle connection lock . . .

2000-09-06 Thread Dan Haley
o this and successfully solve it? We are on CF4.5 Ent on NT4 SP4 with Oracle 8.0.5 using a combination of native drivers and ODBC (moving to the native drivers). Thanks, Dan -- Archives: http://www.mail-archive.com/cf-talk@houseof

RE: Select Form Element in IE vs Netscape?

2000-09-06 Thread Dan Haley
Your closing tag is . Dan -Original Message- From: Greenberg, Lisa [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 06, 2000 12:19 PM To: cftalk (E-mail) Subject: Select Form Element in IE vs Netscape? This message is in MIME format. Since your mail reader does not understand

RE: SQL ORDER BY Problem

2000-09-05 Thread Dan Haley
query with CF. Use SQL statements and functions for manipulating each row of the query. Dan -Original Message- From: Chris Terrebonne [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 9:45 AM To: [EMAIL PROTECTED] Subject: Re: SQL ORDER BY Problem SELECT Date, #DateDiff(date,

RE: simple date problem major brain fart

2000-09-07 Thread Dan Haley
aveat, you may need the datediff if the time component decides to interfere with what you are doing. Dan -Original Message- From: Mark Warrick [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 07, 2000 9:48 AM To: [EMAIL PROTECTED] Subject: RE: simple date problem major brain fart This

Regular expressions . . . a good tutorial somewhere?

2000-09-08 Thread Dan Haley
Anyone have a link to a decent tutorial for regex? Can I look at Perl tutorials for this and not be too far off on what to expect from CF? Thanks, Dan -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com

RE: Regular expressions . . . a good tutorial somewhere?

2000-09-08 Thread Dan Haley
Sheesh, and the first link is to a chapter from a book sitting on my desk . . . *slaps self upside the head with a big CF book* Thanks! Dan -Original Message- From: Correa, Orlando (ITSC) [mailto:[EMAIL PROTECTED]] Sent: Friday, September 08, 2000 3:58 PM To: '[EMAIL PROT

RE: CFOBJECT Help

2000-09-12 Thread Dan O'Keefe
. -- Dan O'Keefe TriPoint Technologies [EMAIL PROTECTED] 954.675.3115 |-Original Message- |From: Jim McAtee [mailto:[EMAIL PROTECTED]] |Sent: Tuesday, September 12, 2000 11:27 AM |To: [EMAIL PROTECTED] |Subject: CFOBJECT Help | | |Sorry to post this again, but so

RE: Hotel Booking Engine up

2000-09-12 Thread Dan O'Keefe
Wayne, An interface that might give you some ideas is http://service.austin360.com, where as a consumer, you can schedule auto repair appointments, exterminating service, maid service, etc. If you have any questions in particular about that site, contact me off list. Dan

RE: OT: Java Script Question

2000-09-12 Thread Dan O'Keefe
What cracking tool are you using out of curiosity and on what OS? I tried L0phtCrack on Win2k, but the 2.5 version does not display the results. They supposedly have a 3.0 version coming that will support Win2K, but no word on when. -- Dan O'Keefe Tri

Re: Ok, What is Fusebox?

2000-09-12 Thread Dan Donnick
It is a coding methodology that produces sound cf code. Fusebox increases efficiency, productivity, and reduce the time it takes to build a web application, it also makes the reuse of code easier. At 11:48 AM 9/12/00 -0700, you wrote: >What is Fusebox? I keep hearing about it. > > > >--

RE: what happens after browser STOPS

2000-09-12 Thread Dan O'Keefe
. -- Dan O'Keefe TriPoint Technologies [EMAIL PROTECTED] 954.675.3115 |-Original Message- |From: Adrian Cesana [mailto:[EMAIL PROTECTED]] |Sent: Tuesday, September 12, 2000 2:07 PM |To: [EMAIL PROTECTED] |Subject: what happens after browser STOPS | | |If a bro

RE: CFOBJECT Help

2000-09-12 Thread Dan O'Keefe
I believe that would have to be a DCOM object. -- Dan O'Keefe TriPoint Technologies [EMAIL PROTECTED] 954.675.3115 |-Original Message- |From: Jim McAtee [mailto:[EMAIL PROTECTED]] |Sent: Tuesday, September 12, 2000 2:24 PM |To: [EMAIL PROT

regex help

2000-09-13 Thread Dan Haley
ns on how to do nested regexes like this? Thanks, Dan -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or s

RE: 2 hours from now -

2000-09-13 Thread Dan Haley
or, if you want the formatting in the variable Dan -Original Message- From: Tim Bahlke [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 13, 2000 1:50 PM To: [EMAIL PROTECTED] Subject: 2 hours from now - I am trying to create a variable that represents two hours from now. I

RE: 2 hours from now -

2000-09-13 Thread Dan Haley
Sorry - timeformat, not dateformat! -Original Message- From: Dan Haley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 13, 2000 1:53 PM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: RE: 2 hours from now - or, if you want the formatting in

RE: transferring SQL server DB to an ISP

2000-09-14 Thread Dan O'Keefe
ch_db @dbname = 'MyDatabase', @filename1 = 'h:\sqldata\MyDatabase_data.mdf', @filename2 = 'h:\sqldata\MyDatabase_log.ldf' -- Dan O'Keefe TriPoint Technologies [EMAIL PROTECTED] 954.675.3115 -

RE: registering Excel COM object

2000-09-14 Thread Dan O'Keefe
dll as well as the correct name for the dll. You should receive a message that it was registered successfully. ------ Dan O'Keefe TriPoint Technologies [EMAIL PROTECTED] 954.675.3115 |-Original Message- |From: Pete [mailto:[EMAIL PROTECTED]] |Sent:

RE: Microsoft Visual SourceSafe

2000-09-15 Thread Dan O'Keefe
It does work with CF Studio just fine, 4.0. 41., 4.5, 4.5.1. I do have 2 docs. One is titled VSS and the Web from Microsoft, and one that I had created for a past employer on how to set it up. Contact me off list and I will send them to you. Dan -- Dan

RE: Microsoft Visual SourceSafe

2000-09-15 Thread Dan O'Keefe
the Web from Microsoft, and one that I had created for a past employer on how to set it up. Contact me off list and I will send them to you. Dan -- Dan O'Keefe TriPoint Technologies [EMAIL PROTECTED] 954.675.3115 |-Original Message- |From:

RE: Microsoft Visual SourceSafe

2000-09-15 Thread Dan O'Keefe
was coming out and they ignored me. So, I am not sure if it works or not, but as a stand alone app it works great. Dan -- Dan O'Keefe TriPoint Technologies [EMAIL PROTECTED] 954.675.3115 |-Original Message- |From: Rice, David [mailto:[

RE: oracle trigger to return newid

2000-09-18 Thread Dan Haley
ct max(id), or using a select sequence.nextval from dual. If you use the latter there is no reason to use a . Dan -Original Message- From: Deanna L. Schneider [mailto:[EMAIL PROTECTED]] Sent: Friday, September 15, 2000 1:45 PM To: [EMAIL PROTECTED] Subject: oracle trigger to return newid

RE: [CF-Talk] OT: Oracle 8i & SQl Server 7 - Can they coexist?

2000-09-19 Thread Dan Haley
Just to make sure you've tried everything . . . have you tried the Access to Oracle migration tool? It is available on Oracle's site - who knows where today - and does things pretty quickly. Only problem is it creates a new user and schema for each database migrated, but that is work

RE: [CF-Talk] OT: Subject lines

2000-09-20 Thread Dan Haley
In Outlook the [cf-talk] works well -- if there is the worry about off-topic messages being filtered, you can include in the rule an "except if sent directly to me". Dan -Original Message- From: pan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 20, 2000 9:38 AM

RE: [CF-Talk] ideas for project management apps

2000-09-20 Thread Dan O'Keefe
There is also http://www.eproject.com. -- Dan O'Keefe TriPoint Technologies [EMAIL PROTECTED] 954.675.3115 |-Original Message- |From: Reynolds, Adam [mailto:[EMAIL PROTECTED]] |Sent: Wednesday, September 20, 2000 5:55 AM |To: '[EMAIL

RE: Template not found. Which template?

2000-09-22 Thread Dan O'Keefe
Has anyone noticed if this option lists the templates in the order they were called? -- Dan O'Keefe TriPoint Technologies [EMAIL PROTECTED] 954.675.3115 |-Original Message- |From: Reynolds, Adam [mailto:[EMAIL PROTECTED]] |Sent: F

RE: Reason for Allaire Stocks

2000-09-22 Thread Dan O'Keefe
ke to hear someone else from Allaire try to defend that type of position, which I am sure they would not want to do. Dan ------ Dan O'Keefe TriPoint Technologies [EMAIL PROTECTED] 954.675.3115 |-Original Message- |From: William J Wheatley [mai

RE: Reason for Alliare Stocks

2000-09-23 Thread Dan O'Keefe
what is this guys name? -- Dan O'Keefe TriPoint Technologies [EMAIL PROTECTED] 954.675.3115 |-Original Message- |From: Bill Killillay [mailto:[EMAIL PROTECTED]] |Sent: Friday, September 22, 2000 11:36 AM |To: CF-Talk |Subject: RE: Reaso

how to nest queries

2000-09-25 Thread Dan Donnick
I have 3 queries, what would the code look like to output HTML in the middle. __ Dan Donnick Cold Fusion Developer Bixler Incorporated 1250 24th Street Suite 250 Washington, DC 20037 Phone: (202) 686-5800 Fax: (202) 686-5801 Email:[EMAIL PROTECTED

RE: how to nest queries

2000-09-25 Thread Dan Donnick
... HTML here ... > > > > > > > > > -Original Message- > > From: Dan Donnick [SMTP:[EMAIL PROTECTED]] > > Sent: 25 September 2000 15:42 > > To: CF-Talk > > Subject: how to nest queries >

RE: how to nest queries

2000-09-25 Thread Dan Donnick
x > ABC >2 > z > ABC > y > ABC > x > ABC > >3 > z > ABC > y > ABC > x > ABC > >Is that reall

Re: Access 2000 Databases with CF4.0

2000-09-26 Thread Dan Blickensderfer
You have to use the latest Microsoft Data Access Components (MDAC) - Original Message - From: "Joshua Miller" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, September 26, 2000 3:23 PM Subject: Access 2000 Databases with CF4.0 > This may have been answered here befo

RE: Relief from redundancy?

2000-09-27 Thread Dan Haley
CFStudio 4.5 it is sort of documented under "Scripting the Visual Tools Object Model". My one feeble attempt resulted in failure and I haven't built my self-confidence up again enough to try again . . . but if anyone else has succeeded, a quick example would be nice. Dan -Original Me

RE: What's wrong with this script?

2000-09-27 Thread Dan Haley
it enough to define it, I just know trial and error will usually come up with a work-around! Dan -Original Message- From: Michael Gagnon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 27, 2000 8:08 AM To: CF-Talk Subject: Re: What's wrong with this script? Yup! Tried th

RE: ColdFusion SP2

2000-09-27 Thread Dan Haley
And as for indenting, in Studio 4.0 the CTRL-SHIFT-, and CTRL-SHIFT-. worked really well for moving blocks of indented code. Now if you move to the left a block of code with multiple levels of indents, it totally screws up the indenting. Dan -Original Message- From: Jackson Moore

conditional where statement

2000-09-28 Thread Dan Donnick
is this correct or am i missing something? select * from tbl where id = #id# or name = #name# __ Dan Donnick Cold Fusion Developer Bixler Incorporated 1250 24th Street Suite 250 Washington, DC 20037 P: (202) 686

RE: INSERT INTO with loop problem

2000-09-29 Thread Dan Haley
The commas inside your loop are going to cause problems. You have ,desc,details,. Going through this loop will give you doubled up commas - ,desc,details,,desc,details,,desc,details, Dan -Original Message- From: Michael Gagnon [mailto:[EMAIL PROTECTED]] Sent: Friday, September 29

cflooping calendar

2000-09-29 Thread Dan Schueler
probably won't be too hard, but I just don't want to reinvent this particular wheel. Thanks, Dan -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoff

RE: Windows 2000??

2000-10-02 Thread Dan Schueler
I'm using a Dell laptop with Win2k pro, works great, stuff actually works. Biggest benefit besides IIS actually working all the time is that the hibernate mode always works. You put it into hibernate, takes about 15 seconds. When you want to use it again it starts up in about 15 seconds. Highly

RE: Brain Buster

2000-10-04 Thread Dan Haley
Not sure if this is exactly what you are looking for or not . . . What you have: form.blocks = a list of ids for checkboxes that are checked form.sideX1, X2, X3, etc. = multiple radio buttons that could be of a value of left or right, or not defined (if the user didn't select eit

RE: NOT A MATH QUESTION, NumberFormat

2000-10-04 Thread Dan Haley
I'm assuming it is 4? val("4,000") does the same thing. Dan -Original Message- From: Chapman, Katrina [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 04, 2000 3:59 PM To: CF-Talk Subject: RE: NOT A MATH QUESTION, NumberFormat Nope. > -Original Message-

RE: NOT A MATH QUESTION, NumberFormat

2000-10-05 Thread Dan Haley
And the result isn't a number! Try this . . . i - #x2# - #evaluate(x2 - x1)# It bombs on the evaluate(x2 - x1) saying that 36,526 is not a number. Hmmm. Like the doctor says to the man who complains "it hurts when I do this", Katrina, don

RE: NOT A MATH QUESTION, NumberFormat

2000-10-05 Thread Dan Haley
Ahhh, I know what it is. :) Take a look at the differences between 4,1 and 5,1. Remind you of anything? Great way to start the morning - get the brain juices flowing again! Dan -Original Message- From: Jaime Garza [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 04, 2000 5:28 PM

RE: Netscape? Code Included

2000-10-05 Thread Dan Haley
t you are using ColdFusion. Dan -Original Message- From: HappyToad.com [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 05, 2000 9:56 AM To: CF-Talk Subject: RE: Netscape? Code Included OK This form works fine in IE 5.5 but gets cut off right below in Netscape: SELECT state_ab FROM sta

RE: NOT A MATH QUESTION, NumberFormat

2000-10-05 Thread Dan Haley
number, in this case putting in a comma. CF does not consider a string with a comma in it a number, but instead thinks it is a list - the same reason Val("4,000") returns "4". Follow that? :) I'm assuming that numberformat("300") will give you a 'number

RE: SQL Question: Selecting and grouping by date

2002-07-30 Thread Dan Haley
In Access datevalue(datefield) does what you are trying to do -- truncate the date. This will allow you to group by the date field. I imagine it is the same in SQL Server. Dan -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 30, 2002 4:24 PM To: CF

RE: SQL Question: Selecting and grouping by date

2002-07-30 Thread Dan Haley
is any better or not ... select cast(floor(cast(datefield as float)) as datetime) as mydate, sum(numberfield) as mysum fromtable group bycast(floor(cast(datefield as float)) as datetime) It converts the date to a number, takes the integer of that (midnight), then converts it back

RE: Can anybody see a problem with this?

2002-08-01 Thread Dan Haley
ab to see other options) 3) Now the URL http://www.mydomain.com/people/billhenderson will be redirected to http://www.mydomain.com/people.cfm?person=/billhenderson. Same basic effect as Apache, just a little more(?) work to set up and a little less flexibility. Dan -Original Message- From: Se

RE: ColdFusion Accessing exhcnage server calendar

2002-08-01 Thread Dan Haley
if you're interested in the Outlook code. Dan -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 01, 2002 10:55 AM To: CF-Talk Subject: ColdFusion Accessing exhcnage server calendar I've already been to cfcomet, anyone ever acces

RE: Can anybody see a problem with this?

2002-08-01 Thread Dan Haley
m not following the question. You want the /BillHenderson to stay in the address bar? I tried the very first one that came up on Dave's Google search and it leaves the original URL in the address bar. I'm on IE 6. Dan -Original Message- From: Bill Henderson [mailto:[EMAIL P

RE: Does Macromedia have some current strong Flash agenda?

2002-08-01 Thread Dan Haley
ations. Then again maybe it's sour grapes on my part because I'm tired of saying "I don't do graphics!" :) Dan -Original Message- From: Todd [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 01, 2002 4:36 PM To: CF-Talk Subject: RE: Does Macromedia have some cur

RE: Does Macromedia have some current strong Flash agenda?

2002-08-02 Thread Dan Haley
Alt-Tab to another window and then Alt-Tab back to Flash, why isn't the cursor still flashing right where I left it? Of course, don't take my rants too seriously ... I'm learning it for one, maybe two projects for a client, then posting the 'no flash allowed' sign on the

CFX_QueryDump

2002-08-02 Thread Dan O'Keefe
Anyone use this tag? I am getting the following error: Error loading CFX custom tag library The library associated with the custom tag CFX_QUERYDUMP (C:\CFusion\cfx\querydump.dll) was not found. Dan - Dan O'Keefe TriPoint Technologies 954.501

RE: CFX_QueryDump

2002-08-02 Thread Dan O'Keefe
Yes, it is registered and confirmed in the directory. I also looked in the registry and it appears to be configured OK in there also. Dan -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Friday, August 02, 2002 2:20 PM To: CF-Talk Subject: Re: CFX_QueryDump Have

RE: Does Macromedia have some current strong Flash agenda?

2002-08-02 Thread Dan Haley
ya better skinny it down. Dan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, August 02, 2002 2:21 PM To: CF-Talk Subject: RE: Does Macromedia have some current strong Flash agenda? > I would think any competent UI person would consider usability

RE: createdatetime(??)

2002-08-02 Thread Dan Haley
Time goes from 00:00:00 to 23:59:59 ... -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: Friday, August 02, 2002 2:56 PM To: CF-Talk Subject: RE: createdatetime(??) The quotes work okay, with any combination other than "24" as the hour. As soon as I put 24 in, it

RE: Urgent: caching problem?

2002-08-02 Thread Dan Haley
s.cfm, etc. ... is your index.cfm on each sharing some type of content management code? Getting confused and a file? Not that CF should think it is the same person from site to site ... Dan -Original Message- From: Al Musella, DPM [mailto:[EMAIL PROTECTED]] Sent: Friday, August 02, 2002

RE: Task/Project Management App

2002-08-08 Thread Dan Haley
How do you get in? -Original Message- From: Parker, Kevin [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 4:57 PM To: CF-Talk Subject: RE: Task/Project Management App Quantum Art advise me: The demo of Q-Project is still available at http://project.quantumart.com.

RE: getdate() in access

2002-08-08 Thread Dan Haley
Try datevalue(eventDate). Depending on the format of the text in evendDate, Access should convert it to a date. At least according to the many, many, many Access tables/queries/macros I've been converting to Oracle over the last two weeks ... ;) Dan -Original Message- From: Gi

RE: CFMX and client variables

2002-08-09 Thread Dan Haley
[char] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [app] [char] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [data] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO Dan -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: Friday, Augu

RE: Long raw and coldfusion

2002-08-09 Thread Dan Haley
ked in the datasource? What kind of error are you getting? Are you using MX, in which case I am no longer of any help? :) Dan -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Friday, August 09, 2002 12:13 PM To: CF-Talk Subject: Long raw and coldfusion Does anyo

RE: Callling Client or Session varibles from a javascript

2002-08-09 Thread Dan Haley
roken ... <cfoutput>#y#</cfoutput> Dan -Original Message- From: Matthew Friedman [mailto:[EMAIL PROTECTED]] Sent: Friday, August 09, 2002 3:01 PM To: CF-Talk Subject: Callling Client or Session varibles from a javascript I have a need to read and set client or sess

RE: Callling Client or Session varibles from a javascript

2002-08-09 Thread Dan Haley
he data it needs? Or the communication frame could call a function in your API frame telling it that it was done? Sorry if I'm totally missing what you are doing and being no help! Dan -Original Message- From: Matthew Friedman [mailto:[EMAIL PROTECTED]] Sent: Friday, August 09, 2002

cf-talk quiz ...

2002-08-09 Thread Dan Haley
27;s one of those days ... had to do it ... hasn't the list been great lately! Dan __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionautho

RE: days between function in Oracle...

2002-08-20 Thread Dan Haley
Use the Oracle trunc function on the dates. Trunc() removes the time portion so both dates are at midnight. trunc(date1) - trunc(date2) Dan > -Original Message- > From: Alex Ninan [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, August 20, 2002 11:32 AM > To: CF-Talk >

RE: days between function in Oracle...

2002-08-20 Thread Dan Haley
select ceil(to_date('28-AUG-2002 23:59:59') - to_date('09-AUG-2002 00:00:01')) fromdual This returns 19 select trunc(to_date('28-AUG-2002 23:59:59')) - trunc(to_date('09-AUG-2002 00:00:01')) fromdual Dan -Original Message---

RE: Can CF talk to a ODBC compliant db via an ISDN line.

2002-08-26 Thread Dan Haley
L DOM object. I'm still working on XL2000, so I haven't had a chance to try out the ability in 2002 to consume web services. Dan -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: Monday, August 26, 2002 1:08 PM To: CF-Talk Subject: Re: Can CF talk to a ODBC c

RE: Way Off Topic - Need help sending email with ASP

2002-08-26 Thread Dan Haley
the way farther, but sometimes the idiosyncrasies of the language are a pain to figure out. Would be nice to ask questions of the CF group with all of its expertise, without being too far OT. Dan -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Monday, August 26,

RE: Creating and Downloading an Excel File

2002-08-27 Thread Dan Haley
tags for no caching ... And then the only content tag I use is ... Comes right up in Excel with all the formatting. Dan __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related

RE: programmer vs. developer

2002-08-28 Thread Dan Haley
of it ... and a developer ... but not a designer (ugh) ... spent some time as an analyst ... could probably ask for an architect title but I don't build houses ... ;) Dan -Original Message- From: Paul Wille [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 11:56 AM To: CF-Tal

RE: programmer vs. developer

2002-08-29 Thread Dan Haley
get that chance some day! Hopefully my lack of a CS degree won't be a problem , 'cuz I really don't want to go back to writing Excel macros to automate accounting procedures! Dan -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 1:1

RE: Intellectual property (was RE: programmer vs. developer)

2002-08-29 Thread Dan Haley
and who should be hourly, and progralopers are borderline according to that definition. Now if I only I had documented all thos off the clock hours when I worked at Albertsons ... Dan -Original Message- From: Jillian Carroll [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 10:

RE: Looping depending on CFIF Statement

2002-08-29 Thread Dan Haley
ner loop do the conditional code, i.e., outputting totals, etc. To reference the information from the service area query use array notation -- query.column[outer loop counter]. Another is to call the inner loop in a cfinclude, then you can have:

RE: Reverse Engineer DayOfYear Function?

2002-09-04 Thread Dan Haley
Standard answer will be: Of course, those of us trying to liberate dates and allow them free access into the numeric arena like the much simpler: Do realize, though, that I am the only member of the DTLA, date-time liberation army ... ;) Dan -Original Message- From

<    1   2   3   4   5   6   7   8   9   10   >