Dropping Authentication

We currently have an application in place that Authenticates users against our NT domain. We use the CFAUTHENTICATE tags for the authentication process. Every once in a while we lose that mapping or ability and users are unable to authenticate. A Reboot of the web server fixes this problem. I do

RE: Quick SQL Question...

Try dropping the second Group By Variable. Thank you. Steve Burcham Webmaster RDO Equipment Co. Phone (701) 526-9838 Fax (701) 526-9839 mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] _ From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Friday, March 12, 2004 1:28 PM To: CF-Talk Subject:

Strange Query Problem

I have a query that returns one character that is used for classing our customer. The query runs fine in query analyzer, but returns zero records when I try to run it from a ColdFusion page. Any ideas? CFQUERY name=Test datasource=#ds# DECLARE @cf_units int SET @cf_units = #fleetsizece#

RE: Strange Query Problem

: RE: Strange Query Problem cfset cf_units = #fleetsizece# CFQUERY name=Test datasource=#ds# SELECT CF_CLASS FROM CALL_FREQUENCY_MATRIX WHERE cf_units BETWEEN CFM_PARAM1 AND CFM_PARAM2 AND CF_LOC_ID = '77' AND CF_EXISTCONQ = 'E' AND PF_ID = 'CE' AND CF_GROUP = 'CE' /CFQUERY From: Burcham, Steve

RE: (cross post) SQL row numbering

You can set the column as the Identity in the Design of the SQL Table. This will automatically increment your row number. Thank you. Steve Burcham Webmaster - Field Support Team RDO Equipment Co. Phone (701) 239-8755 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message-

RE: Deleting session variables

To delete the session vars use cfset StructDelete(Session, VarName) Steve Burcham -Original Message- From: Thane Sherrington [mailto:[EMAIL PROTECTED]] Sent: Friday, January 31, 2003 9:32 AM To: CF-Talk Subject: Deleting session variables Using CF5. I setup two session variables on

Query Caching

I have a 'Telemarketing' application, don't worry we only call existing customers to update there profile information for the new sales process, that caches a list of the first 50 customers based on the search criteria. This works great for now, but we are adding a second person to make calls at

RE: Query Caching

So as long as the Telemarketers are not searching with the same criteria I should be OK. Thanks for the input, I think I might have to add in some type of check in/out process for the possibility of the Telemarketers choosing the same search criteria. Thank you. Steve Burcham Webmaster -

RE: Help

I get a page cannot be displayed message. Thank you. Steve Burcham Webmaster - Field Support Team RDO Equipment Co. Phone (701) 239-8755 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 8:37 AM

Killing a cached query

What is the best way to 'kill' a cached query on a logout sequence? Thank you. Steve Burcham Webmaster - Field Support Team RDO Equipment Co. Phone (701) 239-8755 mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] __ Signup for

RE: Back button-refresh

You could try this: cfheader name=EXPIRES value=#NOW()# Thank you. Steve Burcham Webmaster - Field Support Team RDO Equipment Co. Phone (701) 239-8755 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent:

Phone Number Format

I have a column in a SQL database called COMP_PHONE, it is a char data type. Right now the phone number is in the database as 1234567890. I want to output this as (123) 456-7980 in my application. I have tried using NumberFormat to no avail. I get an error message when I run the code stating

RE: Phone Number Format

(School.TELEPHONE,7,4)# -Original Message- From: Burcham, Steve [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 3:27 PM To: CF-Talk Subject: Phone Number Format I have a column in a SQL database called COMP_PHONE, it is a char data type. Right now the phone number is in the database

RE: RecordNum =0

You could do it with cf. cfif queryname.recordcount eq '0' Then do what you need to do. Thank you. Steve Burcham Webmaster RDO Equipment Co. Phone (701) 239-8755 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: Mario Martinez R. [mailto:[EMAIL PROTECTED]]

Using Structures with Arrays, Please Help

Can anyone see anything wrong with this code? I am trying to loop through data to find the Sales Persons login id and for each sales person return the activities, dates, contacts, etc. for them to see. The error is listed below. There are two pages to this. The first page goes out and

Use of Style Sheets

Has anyone used CSS to display the search text in a different color or font weight, within a description field? I want my search text to be clearly displayed, kind of like the way Google displays all of the words you search on in bold in the description of the linked website. Or does anyone

RE: Use of Style Sheets

/productdetail.cfm?id=1018 Greg Alton CFDev - Original Message - From: Burcham, Steve [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, February 22, 2002 12:19 PM Subject: Use of Style Sheets Has anyone used CSS to display the search text in a different color or font weight

CFLDAP Help

How can I query my LDAP server for two values (Username and Password)? I need to verify that the the values inserted into a form match what is in Site Server and then continue processing the form. __ Get Your Own Dedicated