RE: OT: US Sales Tax Question

2003-12-03 Thread Kennerly, Rick H CIV
States localities have been chaffing under the Internet exemption law for years (fueled not only by their desire to raise revenue but also by pressure from brick mortar stores that do have to charge the tax and believe that they are losing business to the internet).The complexity of charging

RE: Creating DSN

2003-11-20 Thread Kennerly, Rick H CIV
looks like a password error for sure. I am concerned to the SA log-in pair being used in production, however. Best practices would be to create a limited SQL account for use in production queries (one that restricted in particular the account's ability to DROP the table).That way you're double

RE: Unblocking Ports

2003-11-19 Thread Kennerly, Rick H CIV
It all depends on the version of your server(s) and your network configuration and what you need to do.Normally anymore, ports in out of your system are opened and closed at the firewall(s), but depending on your equipment, layout, needs there are other places and methods that need to be checked

RE: CFMX woes

2003-11-06 Thread Kennerly, Rick H CIV
Generally, if the services are running the pages work, so the services must not be running. We've had bad installs before, for no apparent reason.If you check these items it still doesn't work, then I'd uninstall and try again, paying particular attention to any directory modifications or

RE: Anybody have an opinion on hostmysite.com?

2003-10-31 Thread Kennerly, Rick H CIV
I've got a site there where I prototype (mostly) intranet / sql server projects.I like their customer service, however, I have found their sql server response at times very slow, dragging down your page speed. Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe]

RE: How can it be done ?

2003-10-28 Thread Kennerly, Rick H CIV
HmmmI'm trying to imagine getting around the reboot.I'd think about either storing the id in a new field in the login database or setting a flag, depending on your design, that would be pulled down after the reboot and re-log-in. Rick -Original Message- From: John Stanley

RE: OT (was Re: Macromedia sinks on sales news)

2003-10-27 Thread Kennerly, Rick H CIV
Or at least implement them within a certain amount of time. Rick -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Monday, 27 October, 2003 07:24 To: CF-Talk Subject: Re: OT (was Re: Macromedia sinks on sales news) On Friday 24 Oct 2003 17:46 pm, Matt Liotta

RE: SQL - Zip Code/Nearest City

2003-10-01 Thread Kennerly, Rick H CIV
zip code + 4? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, 01 October, 2003 16:09 To: CF-Talk Subject: Re: SQL - Zip Code/Nearest City Just curious... why are there 900,000 records in the zip codes table? There's only a little over 42,000 zip

RE: Congressional Data

2003-08-26 Thread Kennerly, Rick H CIV
Well, you can always buy your way out of this: http://www.electiondataservices.com/content/zipdistrict.htm http://www.congressmerge.com/products/data.htm create your own extraction from census bureau data (and then sell it, later) http://www.census.gov/main/www/access.html buy the book

CFCHART help, please

2003-07-14 Thread Kennerly, Rick H CIV
on a bar chart I have scale from 1-6. However, CFCHART persists in dividing the chart scale into 10 equal parts, so if I set the scale from/scale to to 0 6 (or 1 6) I end up with numbers like .667, 1.333, 2, 2.673 etc for the divisions. This is most unsightly. Is there a work around? Am I

Page break in report

2003-03-25 Thread Kennerly, Rick H CIV
I'm creating a composite summary report from a query and need, if the report is later printed, to ensure a page break between individual reports or items. Any idea how I can accomplish this? Rick ~| Archives:

RE: Page break in report

2003-03-25 Thread Kennerly, Rick H CIV
Just what I needed. Thanks. -Original Message- From: Candace Cottrell [mailto:[EMAIL PROTECTED] Sent: Tuesday, 25 March, 2003 09:21 To: CF-Talk Subject: Re: Page break in report Put this at the top of the page in your head STYLE TYPE='text/css' P.pageEnd {page-break-before:

RE: Page break in report

2003-03-25 Thread Kennerly, Rick H CIV
Just what I needed. Thanks. -Original Message- From: Randell B Adkins [mailto:[EMAIL PROTECTED] Sent: Tuesday, 25 March, 2003 09:09 To: CF-Talk Subject: Re: Page break in report You can use page-break-before: always; as a Style. [EMAIL PROTECTED] 03/25/03 09:05AM I'm

RE: Page break in report

2003-03-25 Thread Kennerly, Rick H CIV
Just what I needed. Thanks. -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Tuesday, 25 March, 2003 10:18 To: CF-Talk Subject: Re: Page break in report Candace Cottrell wrote: Put this at the top of the page in your head STYLE TYPE='text/css'

Q_Range of dates

2003-03-19 Thread Kennerly, Rick H CIV
I think I've got a handle on queries for output forms where they are passed a single month/year. However, what would a query for a range (such as JAN 2003 to MAR 2003 or JAN 2003 to DEC 2003) look like? Here's where I am. cfset startDate=CreateDate(Form.startYear, Form.startMonth, 1) cfset

RE: Whats wrong with this code?

2003-02-28 Thread Kennerly, Rick H CIV
Certainly has not been my experience. Rick -Original Message- From: Scott Brady [mailto:[EMAIL PROTECTED] Sent: Thursday, 27 February, 2003 16:22 To: CF-Talk Subject: RE: Whats wrong with this code? -- Original Message -- From: Kennerly, Rick H

RE: Dynamic Insert/Update - Still not working

2003-02-27 Thread Kennerly, Rick H CIV
Have you tried a bit of logic like: input name=MVR type=checkbox value=1 cfif #Recordset1.MVR# EQ '1'checked/cfif Rick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription:

RE: Whats wrong with this code?

2003-02-27 Thread Kennerly, Rick H CIV
It'd help to know what sql error you're getting. But here's my shot in the dark: Unlike update, input requires that the order of the input be the same as the order the columns are found in the database. If you've let DW/CF MX create your input data, that data will be in the order found on the

RE: Simple Query Help

2003-02-06 Thread Kennerly, Rick H CIV
You're one fine CF man. Thanks. Rick -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 05 February, 2003 10:45 To: CF-Talk Subject: Re: Simple Query Help cfquery name=Q_Month datasource=command_calendar SELECT Title, Details,

MS Outlook Calendar - Pulling Data

2003-01-14 Thread Kennerly, Rick H CIV
I'm still trying to find the DB in the exchange server. Anybody have any tips for pulling data from MS Outlook Calendar for use in a scroller? Is it even possible? Rick ~| Archives:

RE: MS Outlook Calendar - Pulling Data

2003-01-14 Thread Kennerly, Rick H CIV
server. -Original Message- From: webguy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 14 January, 2003 09:07 To: CF-Talk Subject: RE: MS Outlook Calendar - Pulling Data Are u querying the server or client? WG -Original Message- From: Kennerly, Rick H CIV [mailto:[EMAIL

What does this mean?

2003-01-09 Thread Kennerly, Rick H CIV
This is the CF log entry from the scheduler. I find it a little ambiguous. Was the Verity reindex successful...or merely rescheduled? Information,scheduler-3,01/09/03,07:12:00,,[Index Instructions] Executing at Thu Jan 09 07:12:00 EST 2003 Information,scheduler-3,01/09/03,07:12:00,,[Index

5 week rotation

2003-01-08 Thread Kennerly, Rick H CIV
Seems like someone did this sometime in the recent past, but I couldn't find it in the archives. I have 5 fixed-text items in a database that need to rotate display on a weekly basis, rotating weekly on Monday (week one: item one; week two, item two). Obviously the purpose of having 5 items is

RE: Got an opinion on MM Contribute?

2003-01-07 Thread Kennerly, Rick H CIV
Thanks for all the replies and insight. I imagine this intranet project I'm working on is like a lot of projects, a mix of static pages and dynamic content. The community is medical (but not real tech savvy, particularly at the lower levels) with lots of committees, minutes and reports (the

Got an opinion on MM Contribute?

2003-01-06 Thread Kennerly, Rick H CIV
a little pricey per seat. How does it work? Wouldn't something like CommonSpot be better/cheaper? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription:

RE: HostMySite.com

2002-12-26 Thread Kennerly, Rick H CIV
I placed 4 of my contract customers and my development account over at HMS haven't had any problems with the CFMS server. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription:

RE: Another Newbie Problem

2002-12-11 Thread Kennerly, Rick H CIV
Thanks for the response and nice product, but we're dealing with a legacy db with thousands of records. Besides, while what you propose is certainly a work around, is this the most elegant or programmerly solution? Are there other ways of doing this?

RE: Another Newbie Problem

2002-12-11 Thread Kennerly, Rick H CIV
Brillant! That did it. Thanks to all who assisted, particular Al. Rick -Original Message- From: Everett, Al [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 11 December, 2002 09:40 To: CF-Talk Subject: RE: Another Newbie Problem Here's how I would do it: Given two form variables,

Need 2 elegant Queries

2002-12-05 Thread Kennerly, Rick H CIV
This is classic me. I've promised myself into a corner and demoed something hard coded without thinking about how to construct an elegant query to feed it in production-mode via a database. Query 1. 5 separate ads that run for a week each and rotate each Monday morning. I need to run ad 1

RE: CF SQL problem Rant

2002-11-19 Thread Kennerly, Rick H CIV
Well, you've certainly earned your title. That did it and it works like a charm. A heartfelt thanks. Time out for a brief, self-indulgent rant: OTOH, while listGetAt is mentioned in several of my CF guides, but not mentioned in the CF class I took a few months ago or illustrated in any of

RE: You People Are AWESOME

2002-11-19 Thread Kennerly, Rick H CIV
sounds like you have server caching on ... its in the CF web admin screens a simple checkbox. If it were only checked. It's not. Still working on it. ~| Archives:

RE: You People Are AWESOME

2002-11-19 Thread Kennerly, Rick H CIV
We're using a fresh install of CFMX on a rebuilt NT2k server. It's not machine specific. We can replicate it on any of our desktops. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription:

CF SQL problem

2002-11-18 Thread Kennerly, Rick H CIV
I've never seen this message before. Any ideas would be appreciated. Here's the code from the Action page: cfloop from=1 to=#ListLen(Form.EmpID_Muster)# index=i cfupdate datasource=MorningMuster dbtype=ODBC tablename=muster formfields=empID_muster, emp_status /cfloop And here's the info I

RE: CF SQL problem

2002-11-18 Thread Kennerly, Rick H CIV
, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] WWW : www.camdenfamily.com/morpheus Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Kennerly, Rick H CIV [mailto:[EMAIL PROTECTED]] Sent: Monday, November 18, 2002 9:22

Verity Searches - bug or bad code?

2002-11-05 Thread Kennerly, Rick H CIV
So far 110 records in the search index. If I set the drop down Max Rows for number of records returned to 200, every record (all 110) are listed on * input If I set it for 100, then 100 are returned and the more button yields but 1other listing. If I set it for 10, I get 10 files returned on

RE: Check Boxes - another NUG question

2002-11-04 Thread Kennerly, Rick H CIV
Worked! Thanks for the advice. What is a bit daunting about CF for newbies is the various valid approaches to accomplish the same task. Rick -Original Message- From: Kreig Zimmerman [mailto:kkz;foureyes.com] Sent: Friday, 01 November, 2002 10:54 To: CF-Talk Subject: Re: Check Boxes

Check Boxes - another NUG question

2002-11-01 Thread Kennerly, Rick H CIV
When querying a db where some original input fields were check boxes and were inserted into the db as a binary (yes/no, 1/0, on/off), is the only way to display a check box on the query page, either checked or unchecked, to create a form and add an insert field? If so, I'm having trouble with the

Multiple updates on a single submit

2002-10-22 Thread Kennerly, Rick H CIV
a bit intimidated by the level of discourse on this list, but here goes. (You should start a CF-Talk_Training_Wheels for guys like me.) Anyway, just getting started with CF and one thing I never see are examples of multiple record updates into a database with a single submit button. What

RE: Flash CFMX - What's this about?

2002-10-13 Thread Kennerly, Rick H CIV
Will Isaac Is header.cfm in a different directory (such as includes/) than your Application.cfm and Index.cfm files? First of all thanks for answering. You've of course hit the nail on the head. The Application (and OnRequestEnd.cfm--little cognitive slip there--thanks, Isaac) are in the

RE: How Good is the Job Market for ColdFusion?

2002-10-12 Thread Kennerly, Rick H CIV
Given the state of the economy in general and the tech industry and start-ups in particular, I'd say that it's not CF that is doing badly. Even the rent-a-programmer-type sites aren't seeing the traffic they used to. I know that Local, State, Federal governments, not to mention non-profits,

CF NT Authentication

2002-10-12 Thread Kennerly, Rick H CIV
I vaguely remember a whitepaper on this somewhere over at Macromedia, but I can't find it anymore (if that's where it was--hell, I'm not even sure where I am this morning). Of course, I can't find much on that site anymore anyway. Any pointers? Rick