RE: Cache trouble or something

2003-08-21 Thread douglas . kronenberger
shifts happen. Any help would be appreciated. Thanks Douglas Kronenberger OI National Training Education Office 440-526-3030 x7776 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http

RE: Cache trouble or something

2003-08-21 Thread douglas . kronenberger
in the Wide Wide world of Sports is going on here? I thought it was some sort of funky caching thing so I've turned off the server and restarted it. Same thing. I hate when these little space time continuum shifts happen. Any help would be appreciated. Thanks Douglas Kronenberger OI National Training

Cache trouble or something

2003-08-20 Thread douglas . kronenberger
it was some sort of funky caching thing so I've turned off the server and restarted it. Same thing. I hate when these little space time continuum shifts happen. Any help would be appreciated. Thanks Douglas Kronenberger OI National Training Education Office 440-526-3030 x7776

OT: Exchange Site can't get in

2003-06-06 Thread douglas . kronenberger
I can't get into the exchange site. Says I don't have the right version of the player. I have it a atrudted site . I have enabled actix installs. But it won't install. I do an IE warning Your current security settings prohibit running ActiveX controls on this page. As a result, the page may not

Formatting a Date in CFGRID

2003-03-14 Thread douglas . kronenberger
I'm having trouble get the date formatted in a CFGRID column (mm/dd/yy). I tried doing this: cfgridcolumn header=Date name=#DateFormat(CourseDate,'mm/dd/yy')# And of course it won't let me get away with that. What do I need to do? Do I need to just format up in the SQL statement? could use a

RE: SQL: How do I a get list of everybody that doesn't meet a cer tain criteria

2003-02-25 Thread douglas . kronenberger
Thank you gentlemen, I think this is just what I need. It was my mistake I think I do need single quotes. Access does seem to care. Any recommendations on a good SQL book. Right now I'm using Access to help build SQL statements but they sure are messy and I would have never found you solution by

RE: Access SQL Question - Round 2

2003-01-17 Thread douglas . kronenberger
I'm not sure but try puting the left(issues.owner, inStr(issues.owner, ',')-1) up in the select as left(issues.owner, inStr(issues.owner, ',')-1) as LastName. That should get rid of the error. -Original Message- From: Jeff Chastain [mailto:[EMAIL PROTECTED]] Sent: Friday, January 17,

RE: DWMX - Brainfart..

2002-11-15 Thread douglas . kronenberger
Click on the file/folder icon to the right of the link property. You set it in the dialog that comes up. -Original Message- From: Lee Fuller [mailto:leelistnew;primedna.net] Sent: Wednesday, November 13, 2002 5:34 PM To: CF-Talk Subject: OT: DWMX - Brainfart.. Sorry.. Having a.. well

CF5: Query A Query migration trouble

2002-08-15 Thread douglas . kronenberger
I'm trying to migrate over to CFMX and I'm having some trouble. I'm using this Query Statement: CFQUERY name=GetUsers datasource=GetAllUsers dbtype=query SELECT EmpID, FirstName, LastName, OfficeAbrv, SubOfficeAbrv, ArchiveStatus FROMGetAllUsers CFIF

RE: CF5: Query A Query migration trouble

2002-08-15 Thread douglas . kronenberger
Thanxs, that was it. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:57 AM To: CF-Talk Subject: RE: CF5: Query A Query migration trouble When doing a QofQ, you do not pass datasource= Remove that part from your cfquery tag.

Populating the body of an outlook message

2002-05-28 Thread douglas . kronenberger
Is it possible to pass a string to the body of an outlook e-mail message launched though the mailto: or some other message. Doug Kronenberger OI National Training and Education Office Department of Veterans Affairs 440-526-3030 x7776 [EMAIL PROTECTED]

Need Help w/CFMail its running a muck

2002-05-21 Thread douglas . kronenberger
I'm having trouble with CFMAIL on my server, it's not delevering any mail and it's generated +95,000 undeliverable pieces in the UnDelvr folder and it looks like its still go'in. How do I make it stop? Doug Kronenberger OI National Training and Education Office Department of Veterans Affairs

Trouble with Access and Single Numbers

2002-05-16 Thread douglas . kronenberger
I'm having some trouble with pulling some values out of Access. The field is defined as a number with a field size as single. The problem is CF is retrieving some decimal values all funny. 2.6 is retrieved as 2.599 1.7 is 1.7 1.9 is 1.9 2.9 is 2.901 9.99 is 9.988 Crazy stuff. They

RE: Trouble with Access and Single Numbers

2002-05-16 Thread douglas . kronenberger
It's set to auto. After hours of stumbling around try'n sql functions and CF formatting I finally tried the left function in the SELECT statement. cfquery name=CourseDetail datasource=OITracker dbtype=OLEDB SELECT CourseName, CourseDate, LEFT(CourseHours, 6) As CourseHours FROM Course WHERE

CFREPORT

2001-12-06 Thread douglas . kronenberger
The documantation is kind of sparse on this subject. Can any one tell me what I need on the server as far as Crystal Reports goes and maybe point me in the direction of some more docs on this. Thanks in advance Doug Kronenberger OI National Training and Education Office Department of

RE: Trouble with Dates

2001-11-26 Thread douglas . kronenberger
-Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Friday, November 23, 2001 2:49 PM To: CF-Talk Subject: Re: Trouble with Dates grrr.my posts aren't coming through.. use #CreateODBCDate(Form.Date)# instead of that annoying Access ###DateFormat()### crud then

RE: Session Variables - I don't get it

2001-05-11 Thread douglas . kronenberger
Got it. So... it's a runs the application.cfm before every page thing. Hey, that could be useful. I have had an epiphany. I understand it all now (even why they have brail on drive up teller machines). Thank you all. -Original Message- From: Per Kleven [mailto:[EMAIL PROTECTED]] Sent:

RE: MS Access JOIN Error

2001-05-10 Thread douglas . kronenberger
Wow, that did it. I thought I had tried every combination of brackets, prens, quotes and double quotes. Thanks, this is the first time I've used a join so I wasn't really sure Access supported it or even if that exactly what I wanted (It is). Another strange thing if I change OLE DB

MS Access JOIN Error

2001-05-09 Thread douglas . kronenberger
I'm getting the following error when trying to do a left join from an Access database from CF. I really don't know what I'm doing. Any clues would be appreciated Error Diagnostic Information ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver]

RE: MS Access JOIN Error

2001-05-09 Thread douglas . kronenberger
Rats, that did not do it Thanks all the same. -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 7:32 AM To: CF-Talk Subject: RE: MS Access JOIN Error Not sure about Access but in SQL you have to specify the fact that it's an outer join so

RE: Screen Shot on Win 2K

2001-04-17 Thread douglas . kronenberger
Works for me. Sounds like maybe you have some video driver software that uses that combination as a hotkey to change display. If so you should be able to change or disable it some where under the display driver. -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Monday,

RE: CF and Authorware

2001-03-20 Thread douglas . kronenberger
I haven't yet but I do use Authorware. I believe there are examples around. I think it's a matter of using the posturl function in AW to a CF page. Let me look around. Have you posted to the AWARE list? Doug Kronenberger Department of Veterans Affairs [EMAIL PROTECTED] -Original

RE: CF and Authorware

2001-03-20 Thread douglas . kronenberger
There is some good information on the MacroMedia site: http://www.macromedia.com/support/authorware/tracking/AW5DATA/ http://www.macromedia.com/support/authorware/ts/documents/post_url.htm Doug Kronenberger Department of Veterans Affairs [EMAIL PROTECTED] -Original Message- From: