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
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 doub
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 chec
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 po
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]
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 [mailt
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 wr
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 co
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 (date
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
m
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
>
>
> P.pageEnd {page-break-befor
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
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
P.pageEnd {page-break-before: always}
Then where you want
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: http://www.hous
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.
SELECT * FROM dbo.PaP WHERE test_date >= #CreateODBCDate (startDate
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,
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
Have you tried a bit of logic like:
checked>
Rick
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http:/
I see said the blind man. Thanks for the assist!
Rick
-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 05 February, 2003 10:38
To: CF-Talk
Subject: RE: Simple Query Help
Yep you are...
>> WHEREDatePart(,EventDate) = AND
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
SELECT
Title,
Details,
EventDate,
StartHour,
StartMi
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:
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: http://www.houseoffusion.com/cf_lists/index.c
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:0
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 s
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 m
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:
http://www.houseoffusion.com/cf_lists/index.c
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:
http://www.houseoff
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, Form.da
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?
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
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:
http:
>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: http://www.houseoffusion.com/cf_lists/index.cfm?foru
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
th
nfamily.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 AM
> To: CF-Talk
> Subject: CF SQL problem
I've never seen this message before. Any ideas would be appreciated.
Here's the code from the Action page:
And here's the info I get back from CF Debug
Error Executing Database Query. Invalid data
1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1 for CFSQLTYPE
CF_SQL_NUMERIC.
Rick
~~
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 t
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
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
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 we're
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
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
~
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,
42 matches
Mail list logo