having to specify the mail server in
your
app.
=
Douglas White
group Manager
mailto:[EMAIL PROTECTED]
http://www.samcfug.org
=
- Original Message -
From: Jim McAtee [EMAIL PROTECTED]
To: CF-Talk [EMAIL
Does anyone publish a good, searchable, ColdFusion developer directory. We were
contacted recently by a potential client, but are too busy to handle their needs
at the moment. He's looking for a local developer, and I could only think of a
couple of other shops that he might try.
Thanks,
Jim
What good would it do you if the indexing robot sees exactly the same page
content on every page it retrieves?
If you just want to keep googlebot from spidering the entire site, including the
root level, use the following in your robots.txt:
User-agent: googlebot
Disallow: /
But I'd find out
I've looked around, but haven't been able to find a means to use an ALTER TABLE
SQL statement to create (or change) a column in Access with the Allow Zero
Length property set to TRUE. Does anyone know of a means to do this? Maybe a
custom tag instead?
Jim
is empty.
-Original Message-
From: Jim McAtee [mailto:jmcatee;mediaodyssey.com]
Sent: Wednesday, 23 October 2002 9:30 a.m.
To: CF-Talk
Subject: Access 2000 - ALTER TABLE - Allow Zero Length
I've looked around, but haven't been able to find a means to
use an ALTER TABLE
SQL
Can an IP address be safely manipulated as a CF numeric variable? I want to be
able to apply network masks using the BitAND() function to determine if a given
address is on a particular subnet. My concern is that IP addresses are 32 bit
unsigned numbers, but if I'm not mistaken, CF numeric
PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, September 25, 2002 9:07 AM
Subject: RE: IP Address as CF Number
they are effectively just lists with a period delimiter AFAIK
-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]]
Sent: 25 September 2002 15:38
To: CF-Talk
on 32 bit
systems) or does it revert to using strings? If it uses strings, that's got to
be one hell of a performance hit when numbers get that large.
Jim
- Original Message -
From: Jim McAtee [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, September 25, 2002 8:38 AM
I'm looking for an IIS ISAPI authentication .dll that can use an ODBC database.
Ideally, one where someone may have already written a simple CF interface for
adding/removing users, so I can get this up as quickly as possible. Any
recommendations?
Thanks,
Jim
Which web server and version of CF are running on this server? On my CF5/IIS5
server, I always have the exact same set of CGI variable (including
CGI.HTTP_REFERER), but some of them will sometimes have a zero length string
as there value. A firewall would have to _strip_ the referer header from
I've got a stats package (DeepMetrix LiveStats 6.2) that's capable of
tracking visitors based on cookies recorded in the web logs, rather than by
IP address. Can I accomplish this using CF client management and cookies?
I turned on cookie logging in IIS and created a simple application.cfm
I've got a client that wants a simple web-accessible file store where
employees can download files. The simplest approach is just to enable
directory browsing and to allow administrators to FTP to the web site to
upload the files. Now they want to password protect the directory. I don't
want
are storing the files.
Jim McAtee [EMAIL PROTECTED] 07/23/02 04:18PM
I've got a client that wants a simple web-accessible file store where
employees can download files. The simplest approach is just to enable
directory browsing and to allow administrators to FTP to the web site to
upload
Is this just a PayPal clone?
- Original Message -
From: Stacy Young [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, July 18, 2002 9:28 AM
Subject: RE: Card Processors
We're also in the mix...no merchant account required, easy CF integration:
http://www.firepay.com
Set up a rack? If you're going to be installing and managing the servers,
I suggest some place local to you. Makes those 2AM emergency runs a lot
easier.
Jim
- Original Message -
From: Ian Lurie [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, July 18, 2002 1:51 PM
What's a good approach for online sales for sites that do _very_ little in
sales volume? I've got a couple of clients interested in a simple shopping
cart to sell a few products, but the monthly costs of a merchant cc
processing account makes the usual approach too expensive. Use PayPal? A
Yeah, the credibility factor of using PayPal isn't great, but when you're
selling just one or two items, I think it's understandable. Biggest problem
may be that not everyone has a PayPal account, so you eliminate quite a
number of potential customers.
I just looked up the Yahoo store thing. I
..
I have used both and both tie into CF very easily, I could probably give
you some code too.
www.merchantanywhere.com
www.echo-inc.com
they look a little cheesey but they are good companies. merchantanywhere
has great customer service too..
mike
-Original Message-
From: Jim McAtee
Thawte recently announced a substantial price increase, although it's not yet
reflected on their web site. I'm also hearing a lot of horror stories on the
ISP lists regarding turnaround times at Thawte for new certs. What used to
take two or three days is now taking as long as four weeks.
How has locking changed in CFMX so that it's no longer required in this
situation? I haven't been following many of the CFMX discussions since we
have no immediate plans to move to that platform.
Jim
- Original Message -
From: Raymond Camden [EMAIL PROTECTED]
To: CF-Talk [EMAIL
- Original Message -
From: Raymond Camden [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, July 08, 2002 12:21 PM
Subject: RE: nuther lockin Q?
Locking in CF5 (and earlier) was used for 2 reasons - to prevent the
server from getting... err... confused (and crashing) and
What are the advantages of storing articles and archived list messages in
individual text files? Even without the CFINCLDE caching issues, that's a lot
of disk files.
Jim
- Original Message -
From: Michael Dinowitz [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, July 07,
Yes, but you don't have to reload the master list page after every edit.
Personally, I use popups only for minor editing and read-only information that
can reasonably be displayed in a small window, and I always specify a window
size, so that it (usually) won't block the parent window. This
If it doesn't work, create a new date/time field and run a CF template that
loops through every record in the table, reads each text field, creates an
ODBC date and then inserts it into the new field. Insert NULL if the date is
blank or otherwise invalid. After you're done, delete (or rename)
Use the DateFormat() function.
#DateFormat(myquery.dob, mm/dd/)#
or another format of your choosing.
Jim
- Original Message -
From: Brian Simpson [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, June 02, 2002 4:01 PM
Subject: Re: Date query help
All my Date of
- Original Message -
From: Brad Roberts [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, May 28, 2002 11:18 AM
Subject: Scheduled Tasks
When I schedule a task to run weekly or monthly, it reverts back to daily.
Is there a fix for this? I couldn't find one on MM's site.
- Original Message -
From: Erika L Walker-Arnold [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, May 27, 2002 5:45 AM
Subject: RE: [style] usernames
We have this discussion, all the time ... And we've come down to what we
think is the best of both worlds ...
We allow
I let people choose their own usernames, with some small restrictions, such as
a minimal length and no spaces. It's easy enough to do a lookup on existing
usernames to avoid duplicates and display a message if already in use.
Usually, you're doing some other error checking anyway, such as
- Original Message -
From: Bud [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, May 25, 2002 4:22 AM
Subject: RE: Emergency: Authorize. net woos
On 5/25/02, Mark A. Kruger - CFG penned:
If you are using ADC Direct Response (not relay - direct), the type of
- Original Message -
From: Jochem van Dieten [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, May 11, 2002 9:41 AM
Subject: Re: CFHTTP truncating data?
My experience with cfhttp is that it will not choke on getting an ASCII
0 back in the stream. But CF will chocke on
That sounds very well, but what's the course of action if one or more
servers/networks is offline? It can't scuttle the transaction, can it? If
so, you end up with a system that is actually N times more vulnerable to
downtime.
Jim
- Original Message -
From: Matt Liotta [EMAIL
When using cfmail type=html, is it best to include a full set of html tags
(html/html, head/head, body/body), as you'd use within a web
page, or is it better to omit them? I'm thinking of what works best with
html-capable email clients, as I only have Outlook and OE to test with.
Jim
I need to display a column of percentages, formatted with 2 digits following
the decimal place and one, two, or three to the left. I need numbers less
than 1 formatted with a leading zero. I'm having a time finding an
appropriate NumberFormat() mask to do this. I'm assuming there is one,
which
Thanks, Dave. Dunno why I couldn't find it. It ended up being either
___.__ or ___.00. For some reason __0.00 pads the left hand side with
up to three zeroes. Go figure.
Jim
- Original Message -
From: Dave Watts [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, April
Why not offer both options to the purchaser of the files? If they only
purchase a couple of files, there's not much to be gained, but if they
purchase a lot of files, it would certainly be more convenient to download
them all in one shot.
Jim
- Original Message -
From: Owens, Howard
I'm developing a discussion application where logins are required, but I'd
like to recognize returning members without a login. So, I'll use a cookie.
A little bit simpler is to use CF client variables (cookie based).
My question is whether it will be possible to have a person automatically
not thoroughly understanding how
cookies are implemented. With CF client variables, can a 1:many (one set of
client variables to many computers/cookies) relationship exist, or must it
be 1:1?
Jim
- Original Message -
From: Jim McAtee [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent
. #client.userid#
on machine a and b are separate variables, but they can both contain
mrbill
---
Billy Cravens
-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 23, 2002 4:28 PM
To: CF-Talk
Subject: Re: Can I do this with CF client variables?
I'm
Memory issues? MS SQL 2000 will use a lot more memory. When working with
small tables and datasets you may be staying within the bounds of physical
memory on the machine and never notice a difference. If you force the
system to use virtual memory, though, the slowdown could be the effects of
It sounds like you want to make sure the password only consists of letters
and numbers. I think the following would be what you're looking for:
REFind(^[[:alnum:]]+$, #Form.Password#)
^ matches the beginning of the string
$ matches the end of the string
+ translates to 1 or more
The ^ and $
In my experience a forums application (threaded or not) works better than
mailing lists for exchanging project information. Most forums already have
extensive search capabilities built in. If you need this-second
notification of new posts, many offer e-mail notification for participants
in a
cfhttp url=http://www.somewhere.com/cgi-bin/whatever
method=post
cfhttpparam ...
/cfhttp
Jim
- Original Message -
From: Diana Nichols [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, April 15, 2002 9:58 AM
Subject: automatically submit form
I am generating a
- Original Message -
From: Mark Leder [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, April 14, 2002 11:54 AM
Subject: Simple Application.cfm Question
In the application.cfm I write the following:
CFSET APPLICATION.webroot = http://www.mysite.com;
Then I call this on
Use = NULL in your SQL statement.
UPDATE thetable
SET this = 'that',
thedate = NULL
WHERE something = #somethingelse#
Jim
- Original Message -
From: Mario Martinez R. [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, April 13, 2002 1:04 PM
Subject: Re: null DateTime
If the second application.cfm has a cfapplication tag with a new
application name, then CF will see a different session structure. It
sounds like you're passing all validated users into the admin area, so why
not just have the admin login page in the admin section of the site?
Jim
-
'H' ?
- Original Message -
From: chris.alvarado [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, April 08, 2002 3:12 PM
Subject: Results where value starts with A thru G
What is the best way to get all of the records where a specific column is
LIKE 'A%'
Have you tried rebooting the machine? And of course, the $64,000
question: What did you change on the server between when it worked and
when it stopped working?
Jim
- Original Message -
From: Gordon Burns [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, April 06, 2002
Restarting the IIS service alone should clear any memory cache. If that
didn't do the trick, I would think the problem has to be client-side.
Jim
- Original Message -
From: Jeff Brown [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, April 04, 2002 11:40 AM
Subject: OT:
I'd like to only permit the running of a certain template through the CF
scheduler. I know this is easily done by simply placing the source
directory outside of the web space, but for a couple of reasons this
particular template needs to be in a web-accessible directory. I'm guessing
that there
that the cgi.REMOTE_ADDR is the IP of the computer the CF
scheduler is running on.
- j
-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 6:13 PM
To: CF-Talk
Subject: Only permit execution from CF scheduler
I'd like to only permit the running
: Only permit execution from CF scheduler
Test it, have teh scheduler run and in the template , cfmail yourself
the
cgi.REMOTE_ADDR var and then use that. OTTOMH, It should be one of the
bound IP's, but which one it chooses seems to be random.
- j
-Original Message-
From: Jim McAtee
It's not absolutely clear how the CF scheduler handles weekly or monthly
scheduled events. In the CF Administrator, it requires a time of day, but
doesn't ask for a day of month, or a day of week. I assume then that
monthly scheduled task must go off on the day of month that coincides with
the
for the first of every
month all wrong. I would need to schedule the task to run daily and then
have the template check the date to see if it's the first.
Jim
- Original Message -
From: Jim McAtee [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, April 03, 2002 5:21 PM
Interesting article today on News.com. Looks like it's going take some
serious marketing to sell the concept.
http://news.com.com/2100-1001-872136.html
Jim
- Original Message -
From: Douglas Brown [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, April 01, 2002 10:35 AM
I'm looking for a JavaScript means of moving items from one set into
another. This particular application would add people into groups. I've
seen a number of Java apps that do this, but I'm not sure if I've seen it in
JavaScript.
I'm thinking the on-screan containters would be two textareas
Years ago we used WebTrends and they included an ISAPI filter that sent
users a cookie solely for tracking purposes. The cookie contents were
logged in the IIS logs. This is the only way to really identify unique
visitors. If you don't see Webtrends cookies in your log files, then you're
If you use the text file datasource that CF sets up for itself, that
shouldn't be anything more than a cfquery, a loop over the results to
create the email body, and a cfmail - about 25 lines of code.
Jim
- Original Message -
From: Ian Lurie [EMAIL PROTECTED]
To: CF-Talk [EMAIL
What are you looking at? The file's date/time, or the message's headers?
Post a set of headers from a message that you're receiving in your email
client.
Jim
- Original Message -
From: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, March 25, 2002 4:23 PM
Subject: Re:
In exporting data to Excel by using HTML, is there any way to force Excel
to diplay gridlines by default? I can set a border on the HTML table
created, but it only applies to the data area, not the whole worksheet.
Thanks,
Jim
Don't user session or client variables to maintain state. Forget for a
moment the multiple application problem - what happens if your user opens
two browser windows in the same application? You can't maintain
individual states in each of them.
Jim
- Original Message -
From: S R
Do users ever hava a valid need to access two companies at the same time in
two different browser windows? If not, just use session variables to store
the company information and drop the url token altogether.
Jim
- Original Message -
From: Shawn Grover [EMAIL PROTECTED]
To: CF-Talk
You need to do both. Create the entries your hosts file, and also configure
it correctly in IIS. In IIS you'll need to create multiple web sites to do
this.
So if your hosts file had:
127.0.0.1 WebSite1
127.0.0.1 WebSite2
and you wanted the names to resolve to two different web sites
I never really noticed this until now, but ReplaceList() doesn't accept an
optional delimiters argument, as do the list functions. (Alright, so
technically it's not a list function since it doesn't operate on a list).
In my lists I need to have strings that may contain commas. Is there a
clever
Either call the incHeader.cfm as a CF tag with an optional parameter, or
else set a variable before the cfinclude. Within the body tag in that file,
look for the variable. The variable could contain text to be inserted into
the body tag, or it could define the entire tag.
cfset bodytagtext =
If you mean the difference in value: Enterprise manager is rounding the
number off slightly, while CF displays the number with a larger number of
significant digits. Computer floating point numbers almost always have some
sort of 'inexactness', or rounding error, whatever you'd like to call it.
This will check or clear all of the checkboxes within a form. If you had
multiple groups of checkboxes in the form (and only wanted to check/clear a
single set), you'd need to add logic to also test the form field names.
script language=JavaScript
function SelectAll() {
for (var i=0; i
- Original Message -
From: Dave Watts [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, March 06, 2002 11:48 AM
Subject: RE: Adult CF hosts
Sounds like a custom tag in the making cf_Porn type=
I don't think you'd want to rely on custom tags much in that environment,
Yes, it's OK to delete them. CF just creates new ones. If you need to read
a very large log, you might want to rename it first, then try opening it in
notepad, or a text editor that can handle large files.
I don't believe there's any mechanism within CF to more intelligently manage
the logs.
As far as I'm concerned DeepMetrix needs to go back to the drawing board
with LiveStats. I've got LiveStats 6 installed using MySQL on a dual
processor 1.26 MHz PIII with 2 MB ram. I've done what I can to tune MySQL,
throwing almost a GB of ram at it and it still constantly pegs both
processors
Larry,
When was the 6.2 version released? We were supposed to be notified, but
haven't heard anything yet.
What dbms and version are you using and how many web sites are you tracking?
Please email me off-list, as this isn't particularly CF related, and I'd
like to pick your brain about
If you've got a cflock with throwontimeout=no, does it skip over the block
of code within the cflock, or does it enter it if the timeout expires?
Jim
__
Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB
You could roll your own, which lets you eliminate the need for DE(). It's
about 45% faster in my tests using CF5. Without the DE() functions used in
the IIf(), the difference is a lot less.
The way this function operates is less flexible that CF's built-in IIf(),
since you couldn't do
Make sure IUSR_machine_name has the necessary privileges within the
physical directory that the IIS virtual directory points to. If it contains
only static content such as html or graphics, I believe Read permission is
all you need.
Jim
- Original Message -
From: John Kivus [EMAIL
Can CF Server be configured to use SMTP authorization to relay mail through
a remote server that requires SMTP Auth? There doesn't appear to be
anywhere in the Administrator for configuring this. The CFMAIL tag doesn't
appear to have attributes for supplying a username or password either.
Jim
If you really wanted to give yourself an ulcer, you could use CF to modify
the templates containing your CF array statements. You wouldn't really be
able to use CF's array processing functions to do things like DeleteAt().
Overall, this could get seriously ugly in a multiuser environment.
If
I'm investigating moving a couple of small web sites that use Access 97 and
Access 2000 databases to MSDE. Much as I've read about MSDE, I've still got
a slew of question. Here are just a couple:
1. Migration. Is it necessary to 'upsize' an Access database to MSDE to be
able to use MSDE? Is
No native functions, but you could easily create one.
cfscript
function ArrayJoin(a, b) {
var i = 1;
for (; i lte ArrayLen(b); i=i+1) ArrayAppend(a, b[i]);
return a;
}
/cfscript
cfset a = ArrayNew(1)
cfset ArrayAppend(a, A)
cfset ArrayAppend(a, B)
cfset ArrayAppend(a, C)
cfset b =
They're just using a bit of script to control what appears in the browser's
status bar, triggered by the mouseover. This is from a google link:
a href=/url?q=http://www.gamblehouse.com
onMouseOver=window.status='go to www.GambleHouse.com';return true
onMouseOut=window.status='';return true
Jason,
So, you're saying that your code, when you get to the final location, you
see the url in your browser's address bar as something like this?
http://www.mydomain/redirect.cfm?url=http://www.anotherdomain.com
I don't see that behavior here (IE 5.5) if I use cflocate in a redirection
I need to quickly lookup items in a struct, in which there's a 10% chance
that the key will not exist. Offhand, does anyone have an idea which would
be faster: Using StructKeyExists() first, then using StructFind() (or an
associative-array style construct) if the first function is true, or just
- Original Message -
From: Kay Smoljak [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, February 21, 2002 8:15 PM
Subject: CFFILE vs database for logging
I'm working on a site where a number of protected pages will be served
up using CFCONTENT from outside the web root.
CSS is by far the simplest obstacle to overcome. Detect the browser and use
the appropriate sub/superset of CSS that makes the site palatable.
JavaScript and simple HTML, on the other hand can be a freaking nightmare.
I balance it on development costs vs. the cost of telling N% of visitors
that
A site for which we develop wanted all kinds of whiz-bang neato DHMTL and
all kinds of extraneous crap and enhancements extraordinaire. We gave it to
them, only supporting IE 5+. In the last 4 months their traffic is up 40%
to 50%. Did the Opera and Netscape and AOL 2 users fall away as a
One correction. Use GetToken() instead of CF's list functions, otherwise it
blows up on a whole number. GetToken() doesn't care if there's a second
list element.
cfset m = GetToken(n, 1, .) . Left(GetToken(n, 2, .), 2)
If I knew something about the numbers being manipulated, I might use a
Depends a little on the BIOS... usually you reboot the computer and watch
the screen immediately following the computer's POST routine. Hold down the
Delete key (either one) when the little prompt says something to the
affect of Press DEL to enter setup. Sometimes it's the F2 key.
You won't be
I've got an application where I'd like, after drilling down a few levels, to
be able to return to the results of a search query. When the user clicks
'return to search results', the form would be resubmitted, a new search
takes place and they're 'back' to where they were. The idea of
I've been handed an Access table which has columns for Month and Year, but
no actual date or date/time columns. Is there any way that I can construct
a query that pulls records for a range of months? For example, from
10/2001 to 02/2002?
Could it be done somehow by using a database function to
the data in the struct ---
form name=returntolist action=list.cfm method=post
cfloop item=f collection=#x#
input type=hidden name=#f# value=#Evaluate('x.#f#')#
/cfloop
/form
Jim
- Original Message -
From: Jim McAtee [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, February
What do you mean hack it out using CGI variables? This is usually how
it's done. The CF processor doesn't really know what the URL is, in that it
is just passed a template file to process by the web server. CF mostly
knows files and file systems. Except through what it knows through CGI
Nathan,
You can override the server's default session timeout value by using
cfapplication and the tag's sessiontimeout attribute. Besides the server
default timeout, there's also a maximum timeout value set at the server
level. If you want to set it much higher than 20 minutes, you probably
This is why it's a very bad idea to track application state using session or
client variables. A user opening two browser windows and performing
different tasks in each will usually screw up your logic. You need to know
what kind of information you can and cannot safely keep in the client and
Probably something more along the lines of:
cfif Refind(^[A-Za-z0-9]+$, FORM.field) EQ 0
!--- didn't match, send them back ---
/cfif
Jim
- Original Message -
From: Steve Oliver [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, February 14, 2002 12:30 PM
Subject: RE:
In an app I'm developing, I'm using a simple system of using session
variables for access control:
cfif not IsDefined(session.userid)
Hey, you gotta login.
cfelse
..
Is it possible to detect if a user session has _expired_?
cfif *expired*
Your login session has expired. You must login
- Original Message -
From: Carlisle, Eric [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, February 13, 2002 2:47 PM
Subject: RE: MySQL Cold Fusion Question?
Would you want to convert so you can easily view table data? If so, it
may
be better to have Access link to
If your counter isn't being executed, it could easily be a caching issue.
Many large ISPs run caching proxy servers for dialup and broadband users.
If you don't specifically try keep pages from being cached, you could be
seeing the results of this.
You may also want to record date information so
In the IIS management console, under the properties for each IIS virtual
site, there's an IP address (at least one) that is to be bound to the site.
Click the 'Advanced' button and you'll see the option to bind to a different
port, as well as the option to set up additional
Taking Ian's query, and assuming you've defined a date range with a begin
and end date, something like this should work:
SELECT First(scipt_name) AS page, Count(script_name) AS pageviews
FROM log
WHERE date BETWEEN #CreateODBCDate(begindate)#
AND #CreateODBCDate(enddate)#
GROUP BY
You could schedule the template to run every two minutes, beginning at a
certain time and ending at a certain time. Unless you have a highly
variable number of records, divide by 500 to figure out approximately how
many times it needs to run. If you have 10,000 records, it needs to run 20
You can escape them, or you can switch the type of quotes you use to
delineate the string within a CF function.
Replace(x, table width=640, table width=720, all)
Replace(x, 'table width=640', 'table width=720', all)
Jim
- Original Message -
From: Jim Vosika [EMAIL PROTECTED]
To:
itself if there are none.
Duane
-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 11, 2002 12:32 AM
To: CF-Talk
Subject: Re: Scheduled Events
You could schedule the template to run every two minutes, beginning at a
certain time and ending
501 - 600 of 1058 matches
Mail list logo
