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 [EMAIL PROTECTED]   _   From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Friday, March 12, 2004 1:28 PM To: CF-Talk Subject: Quick SQL Question...

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 no

RE: Strange Query Problem

Problem 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' >From: "Burcham, Steve" <[EMAIL PROTECTED]> >Reply-T

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? DECLARE @cf_units int SET @cf_units = #fleetsizece# SELECT CF_CLASS FROM CALL_FREQUENCY

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] -Original Message- Fr

RE: Deleting session variables

To delete the session vars use 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 one page, and on the next, I check t

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 - Fiel

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 th

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] -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 8:37 A

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 [EMAIL PROTECTED] __ Signup for

RE: Back button-refresh

You could try this: Thank you. Steve Burcham Webmaster - Field Support Team RDO Equipment Co. Phone (701) 239-8755 [EMAIL PROTECTED] -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 7:17 AM To: CF-Tal

RE: Phone Number Format

Friday, May 17, 2002 2:26 PM To: CF-Talk Subject: RE: Phone Number Format in sql ('(' + SUBSTRING(AS.TELEPHONE, 1,3) + ') ' + SUBSTRING(AS.TELEPHONE,4,3) + '-' + SUBSTRING(AS.TELEPHONE,7,4)) AS TELEPHONE or as a cfset -Original Message- From: Burcham, S

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 th

RE: RecordNum =0

You could do it with cf. Then do what you need to do. Thank you. Steve Burcham Webmaster RDO Equipment Co. Phone (701) 239-8755 [EMAIL PROTECTED] -Original Message- From: Mario Martinez R. [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 2:33

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 retrieve

RE: Use of Style Sheets

ducts/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 s

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 know

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 Window