How to remove dynamic content from search engines?

2005-02-03 Thread Jim McAtee
What are some strategies for removing references to old dynamically generated pages from search engine indexes? The problem I run into is that the CFM page will exist, it will execute, but the referenced data is often expired. A typical URL might look like:

Re: How to remove dynamic content from search engines?

2005-02-03 Thread Jim McAtee
- From: Jim McAtee [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, February 03, 2005 11:26 AM Subject: How to remove dynamic content from search engines? What are some strategies for removing references to old dynamically generated pages from search engine indexes

Re: How to remove dynamic content from search engines?

2005-02-03 Thread Jim McAtee
They won't generate CF 404 errors. A request for http://www.mysite.com/validpage.cfm?id=invalidrecordnumber will successfully pull up validpage.cfm and generate an HTTP 200 status code. It would take a reference to http://www.mysite.com/invalidpage.cfm to launch the CF 404 error handler.

SQL: ORDER BY when using DISTINCT

2005-02-02 Thread Jim McAtee
What can I do to sort this query by skiareas.name? I get an error that the ORDER BY conflicts with the DISTINCT when I add ORDER BY a.name. SELECT DISTINCT c.areacode FROM snowconditions c INNER JOIN skiareas a ON a.areacode = c.areacode WHERE a.state = '#attributes.state#'

Re: SQL: ORDER BY when using DISTINCT

2005-02-02 Thread Jim McAtee
database? I ran into that issue before where you had to have anything in order by stated in the select statement. The same SQL statement did however work with MS SQL. I ended up having to rewrite my query using aggregate functions and a group by. On Wed, 2 Feb 2005 10:22:32 -0700, Jim McAtee

Re: SQL Q

2005-02-02 Thread Jim McAtee
What if the error thrown is due to some other reason? If your app is like many applications where you're doing many more updates than inserts, then this approach is at best only a fraction more efficient than the standard query for key if (keyexists) then update record else insert record

Re: SQL Q

2005-02-02 Thread Jim McAtee
This has always been one of those there's got to be a way to do this things with me. I asked about it on another list and someone showed me that in MySQL 4.1 you can do the following: INSERT INTO dailycounters (trackingdate, itemid, count) VALUES (today, somerecordid, 1) ON DUPLICATE KEY

Re: EASY: grabbing the id of a newly created item..

2005-01-31 Thread Jim McAtee
For a low volume site it works alright, as efficiency probably isn't your biggest concern. If you're using Access it can probably be assumed that the application is fairly low volume. There are some added considerations, though, that make this approach less than foolproof: - You have to make

Re: redirect opinions

2005-01-29 Thread Jim McAtee
Why would anyone do this? Just to save hosting costs? - Original Message - From: Les Mizzell [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Saturday, January 29, 2005 10:58 AM Subject: redirect opinions I've got a client that's decided to host a bunch of different

Re: redirect opinions

2005-01-29 Thread Jim McAtee
Subject: Re: redirect opinions Jim McAtee wrote: Why would anyone do this? Just to save hosting costs? Seems so... So what I end up with is basically: MAIN ACCOUNT ROOT DIRECTORY SUB SITE 1 SUB SITE 2 SUB SITE 3 Don't ask me! I questionsed the client about

Re: Desperately Seeking John Malkovich

2005-01-19 Thread Jim McAtee
Maybe it's the powdered wig that throws 'em off. - Original Message - From: Mark A Kruger [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, January 19, 2005 11:54 AM Subject: RE: Desperately Seeking John Malkovich Hmmm I always think of you as Sir Isaac

Re: Firewall for CF server

2005-01-12 Thread Jim McAtee
The PIX doesn't block port scans??? My take on the buffer overflow blocking is that it sounds like a marketing angle more than anything. It can only work as well as some database is being kept current by the firewall vendor. If you stay on top of SW updates you'll probably be protected as

Suggestion for looping over months within a time period

2005-01-10 Thread Jim McAtee
What is a good way to loop over the months within a time period? For example, given a starting date of 11/17/2003 and an end date of 2/19/2003, I'd need to loop through Nov03, Dec03, Jan04, Feb04. Within the loop I'll be doing queries with a where clause like: WHERE somedate BETWEEN

Re: Suggestion for looping over months within a time period

2005-01-10 Thread Jim McAtee
(baseDate) / Year(baseDate) CFOUTPUTStartDate = #baseDAte# ||| EndDate = #baseEndDate#BR/CFOUTPUT /CFLOOP Hope this helps... Jeff Garza - Original Message - From: Jim McAtee [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, January 10, 2005 3:02 PM Subject

Re: How'd www.firstnight.org do over new years?

2005-01-04 Thread Jim McAtee
- Original Message - From: Jim Davis [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, January 03, 2005 9:23 PM Subject: RE: How'd www.firstnight.org do over new years? Anything else you'd like to know? That was certainly fascinating, but why the particular

Access SQL - Strip Spaces?

2005-01-03 Thread Jim McAtee
I have a small app in Access and I need to remove spaces from a field from within the SQL. What is the appropriate function call? ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net

Re: Access SQL - Strip Spaces?

2005-01-03 Thread Jim McAtee
records. If you need to filter, add a WHERE clause. -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED] Sent: Monday, January 03, 2005 3:48 PM To: CF-Talk Subject: Access SQL - Strip Spaces? I have a small app in Access and I need to remove spaces from a field from within

Re: Access SQL - Strip Spaces?

2005-01-03 Thread Jim McAtee
From a little more research I found that Access 2000 only supports a subset of the ODBC scalar functions, and REPLACE() isn't supported. So, unless someone knows of another way, I guess I'll just do it in CF after the query is executed. - Original Message - From: Jim McAtee [EMAIL

Re: Slow (sorta) site issues - Ideas?

2004-12-28 Thread Jim McAtee
In a shared environment you have to ask yourself to what degree optimizing the performance of your site's code is ultimately going to improve your web site's performance. Even if you were to increase performance 10-fold it's unlikely you'll see anywhere near that performance gain if there are

Re: Slow (sorta) site issues - Ideas?

2004-12-27 Thread Jim McAtee
- Original Message - From: Jim Davis [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, December 27, 2004 12:18 PM Subject: Slow (sorta) site issues - Ideas? I've a site that while not slow, is most likely not going to take the traffic it's facing. The site is

HomeSite+ Binary Files?

2004-12-18 Thread Jim McAtee
Where are binary file extensions defined for HomeSite+'s Extended Find? I'd like to do a server-wide search and the extended find is looking through binary files with extensions that are probably undefined anywhere in HomeSite.

Re: lcd monitors

2004-12-18 Thread Jim McAtee
How about a 19? I can't recommend the Samsung 910T highly enough. Beautiful monitor with a 1000:1 contrast ratio. It's amazing how fast LCD prices are falling; I paid over $100 more for the same monitor just four months ago.

Re: HomeSite+ Binary Files?

2004-12-18 Thread Jim McAtee
Thanks Tom. I'm running HomeSite+ v5.2. HomeSite already skips over EXE files, but that extension isn't listed anywhere in the Extension Manager. In the extension manager I can mark files Editable, Image, and In Filter. Is anything in the list that is not marked Editable considered binary?

Re: Mail Server Software

2004-12-14 Thread Jim McAtee
- Original Message - From: Matt Robertson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 14, 2004 4:16 PM Subject: Re: Mail Server Software Does anyone have any performance comparisons between SM and Imail? There was a lot of anecdotal reporting going on among

Re: Blackstone Beta

2004-12-10 Thread Jim McAtee
I implore you. NOW! But I can't tell you why. Pass. Is there a really good reason that people seem so eager to become beta testers for someone else's product? I can see it perhaps if support tells you it addresses a problem you're having with the current generation. Or if you develop

Re: Blackstone Beta

2004-12-10 Thread Jim McAtee
bunch. -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED] Sent: Friday, December 10, 2004 12:17 PM To: CF-Talk Subject: Re: Blackstone Beta I implore you. NOW! But I can't tell you why. Pass. Is there a really good reason that people seem so eager to become beta

Which browsers do you support for -public- web sites?

2004-12-08 Thread Jim McAtee
I'm guessing that some good comments on my question are buried somewhere in that 500 post thread on Browser Stats, but I really don't have the energy to sort through all the OT and all the bickering. My feeling is that you can't test _everything_ so you gauge the use of the more popular

Re: Hiding an action statement

2004-12-07 Thread Jim McAtee
What's their server setup like? If they can use a centrally available CF tag then they could accomplish the same thing by having an action page on each site that just runs the shared cfml tag. If they can do a server-level cf mapping of a common directory then they could post to a cf page in

Re: Strict email validation

2004-11-24 Thread Jim McAtee
CFMAIL in which version of CF? My experience has been that CFMAIL in CF5 accepts pretty much anything. It's the SMTP relay that accepts only certain formats, and I've seen differences among SMTP servers. I've also seen differences between the accepted formats for the FROM and TO addresses.

Re: Force use of HTTPS

2004-11-23 Thread Jim McAtee
You'll probably also want to append the query_string (url variables). cfif cgi.server_port neq 443 cfset redir = https://; cgi.http_host cgi.path_info cfif Len(cgi.query_string) cfset redir = redir ? cgi.query_string /cfif cflocation url=#redir# /cfif - Original Message

Serve gif or jpeg for users without FLASH?

2004-11-08 Thread Jim McAtee
How do you serve a gif or jpeg image in place of FLASH content for users without FLASH installed? ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message:

Re: Serve gif or jpeg for users without FLASH?

2004-11-08 Thread Jim McAtee
for users without FLASH? Jim McAtee wrote: How do you serve a gif or jpeg image in place of FLASH content for users without FLASH installed? object ... title=I'm shown if flash is available. img ... alt=Blah title=I'm shown if it's not. / /object K. -- Keith Gaughan, Developer

CFLocation Referer

2004-11-08 Thread Jim McAtee
When you direct a client browser to another page through the use of CFLOCATION, does it not set a referer page? That seems to be what I'm seeing in testing. Can I set a referer? We've got a click-tracking CF page that is referenced on site 'A', with the tracking CF page on site 'B' and let's

Inexpensive Hosted Webstore?

2004-11-04 Thread Jim McAtee
We have a client that wants to set up an online store to sell a handful of products. They can't spend much for software licensing, site development or a merchant account. They do already have the ability already to run credit cards at their business. Is there a decent, inexpensive means for

Re: mod command to alter row color

2004-11-02 Thread Jim McAtee
I generally start by setting up two CSS classes, with similar names ending in 0/1. style type=text/css tr.rowstyle1 { background-color: #ff; } tr.rowstyle0 { background-color: #e0e0e0; } /style cfoutput cfloop query=somequery tr class=rowstyle#Evaluate('somequery.currentrow mod

Re: mod command to alter row color

2004-11-02 Thread Jim McAtee
-color: #fff; } tr.alt0 { background-color: #ffc; } /style cfoutput table cfloop query=myQuery tr class=alt#currentRow MOD 2# ... /tr /cfloop /table /cfoutput On Tue, 2 Nov 2004 11:42:55 -0700, Jim McAtee [EMAIL PROTECTED] wrote: I generally start by setting up two CSS classes

Re: Can someone Explain this code

2004-11-01 Thread Jim McAtee
CBA never equals 4 (1,3,5,7...) so the CFEXIT tag is never executed. This means that the inner loop always executes fully. An indexed loop will execute until its index value is = to the TO value. In this case TIMEX never equals exactly 30 (2,12,22...), so goes to 32 before the inner loop is

Re: cfsqltype question with Access database

2004-10-26 Thread Jim McAtee
- Original Message - From: Dave Watts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, October 25, 2004 12:45 PM Subject: RE: cfsqltype question with Access database I have a tag input that needs cfsqltype for a given field. Would be CF_SQL_VARCHAR or CF_SQL_NUMERIC but

Cached Query and CFQUERYPARAM

2004-10-19 Thread Jim McAtee
If I've got a query using a CFQUERYPARAM in the WHERE clause and then attempt to cache that query, will the query remain in CF's cache when called with different values for the queryparam? For example, the table 'mytable' is a very small table with just 5 rows: cfquery datasource=#dsn#

Re: Cached Query and CFQUERYPARAM

2004-10-19 Thread Jim McAtee
Whoops. Brain fart. I had removed the cfqueryparam from the WHERE clause... Makes sense now. - Original Message - From: Jim McAtee [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 19, 2004 1:36 PM Subject: Cached Query and CFQUERYPARAM If I've got a query

Re: (admin) Please test Fusion Authority

2004-10-17 Thread Jim McAtee
- Original Message - From: Michael Dinowitz [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, October 17, 2004 3:11 AM Subject: Re: (admin) Please test Fusion Authority I do some very special things with my CF code Don't we all... [Todays Threads] [This Message]

Re: Rounding up dollar figures

2004-10-14 Thread Jim McAtee
Add 50 cents then truncate, or just use the Round() CF function. cfset retail = 82 cfset discount_rate = 0.0525 cfset final_price = Int(retail * (1 - discount_rate) + 0.50) or cfset final_price = Round(retail * (1 - discount_rate) - Original Message - From: Jordan Michaels [EMAIL

CFQueryParam Questions

2004-10-12 Thread Jim McAtee
Does the maxlength attribute truncate or throw an error if an excessively long string is passed. Is ODBC driver behavior any different when using cfqueryparam?For instance, Access will automatically truncate a too long string, while MS SQL will throw an error. What cfsqltype is best to use

OT: DB Design - Bad Case of the Mondays

2004-10-11 Thread Jim McAtee
I've got a db that includes the following tables: Accounts -- AccountID PK Name AccountRepID FK Users -- UserID PK Name Username Password AccountID FK UserType The Users table will be used for logins to the system.In the Users table will be SysAdminssystem

Re: free web design?

2004-10-03 Thread Jim McAtee
You still see plenty of Mom and Pop static sites out there done by some junior high school kid or by someone with Front Page.$500 from a starving graphic arts student can buy you a hell of a lot over those other options. - Original Message - From: Dwayne Cole [EMAIL PROTECTED] To:

Re: Turn relative links to absolute links

2004-09-14 Thread Jim McAtee
; j=j+1) rpath = rpath IIf(j neq i, DE('/'), DE('')) ta[j]; return rpath; } /cfscript - Original Message - From: Jim McAtee [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, September 13, 2004 1:17 PM Subject: Turn relative links to absolute links I'm in the process

Turn relative links to absolute links

2004-09-13 Thread Jim McAtee
I'm in the process of restructuring a fairly complex Intranet site - moving applications, directories, content, and menus around to give the site a bit more of a logical organization. The CF files and tags which use relative addressing are causing the most work, especially if I decide

OT: Webmaster Resources

2004-09-10 Thread Jim McAtee
Being primarily a programmer and network administrator for the last few years, I've gotten a little behind in more general areas such as web site design and management.I'm looking for some good resources for web site development and management discussions.Email lists, forums, news groups -

cfcookie

2004-09-08 Thread Jim McAtee
Can a cookie be shared between domains?That is, if I have a family of web sites, can they share a given cookie? I want to have user polls posted on several different web sites and wish to limit visitors to one vote per poll, even if they come across the poll on a different web site in the

Re: cfcookie

2004-09-08 Thread Jim McAtee
- Original Message - From: Dave Watts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 08, 2004 11:49 AM Subject: RE: cfcookie Can a cookie be shared between domains?That is, if I have a family of web sites, can they share a given cookie? No, cookies are

Re: cfcookie

2004-09-08 Thread Jim McAtee
- Original Message - From: Dave Watts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 08, 2004 12:57 PM Subject: RE: cfcookie So then you can _read_ cookies from other domains, but you can't write them? No, you can't read or write them. The browser will

OT: Flash Banner Ads

2004-09-02 Thread Jim McAtee
I'm in the middle of rewriting our ad server in CF.One thing we'll be doing is moving to use Flash banners.The question I have is can I dynamically create the link to which a click on the Flash banner would go or does it need to be hardcoded into the Flash ad itelf? Example: If I have a banner

Re: OT: Flash Banner Ads

2004-09-02 Thread Jim McAtee
- Original Message - From: John Dowdell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 02, 2004 5:34 PM Subject: Re: OT: Flash Banner Ads At 4:01 PM 9/2/4, Jim McAtee wrote: Mostly I'm wondering about the reusibility of the Flash banner - whether it could

Doubling of single quotes in query when using a CF function

2004-08-25 Thread Jim McAtee
I've got a simple UPDATE query operating in CF5 on an Access 2000 db via ODBC.If a CF function call is used within the query statement for a string value, then any single quotes get doubled.Without the function call this doesn't happen. UPDATE mytable SET somefield =

Re: Doubling of single quotes in query when using a CF function

2004-08-25 Thread Jim McAtee
- Original Message - From: Jim McAtee [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, August 25, 2004 2:03 PM Subject: Doubling of single quotes in query when using a CF function I've got a simple UPDATE query operating in CF5 on an Access 2000 db via ODBC.If a CF

Re: Calculating Sales Tax within the US

2004-08-25 Thread Jim McAtee
I thought that Internet _services_ were non-taxable under the Internet Tax Freedom Act.That's something your client needs to have their lawyers look into. - Original Message - From: Brook Davies [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, August 25, 2004 2:32 PM

Re: Photo Album Modification

2004-08-25 Thread Jim McAtee
Not quite following your logic.Why are you taking your CFDIRECTORY output, which is a query and turning it into a list?If you leave it as a qeury then you start with the same sort of data structure as your querysim code, just with different column names. BTW, I'd reconsider moving to using

Re: Photo Album Modification

2004-08-25 Thread Jim McAtee
- Original Message - From: Les Mizzell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, August 25, 2004 8:26 PM Subject: Re: Photo Album Modification BTW, I'd reconsider moving to using directory listings.With querying a database, you can have a lot more control over

Re: OT:Gmail invites

2004-08-25 Thread Jim McAtee
Hi Kevin, If you still have an invite available, I'd very much appreciate one. Thank you, Jim - Original Message - From: Kevin [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, August 25, 2004 8:44 PM Subject: OT:Gmail invites Hi all, Since someone was nice enough

Latest version of HomeSite+?

2004-08-23 Thread Jim McAtee
What's the latest version that Macromedia sells/gives away/includes/whatever these days? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: Latest version of HomeSite+?

2004-08-23 Thread Jim McAtee
version of HomeSite+? I believe the current version is 5.5, it comes with Dreamweaver and you can supposedly buy it as a individual product on macromedia.com Justin Hansen Project Manager Uhlig LLC _ From: Jim McAtee [mailto:[EMAIL PROTECTED] Sent: Monday, August 23, 2004 2:01 PM

Re: Retrieving old CFMAIL messages

2004-08-19 Thread Jim McAtee
Gone.Whose email server were you using to relay the messages?Sometimes a company will configure their mail server to take a copy of all relayed messages, usually for liability or employee monitoring purposes. - Original Message - From: Richard Crawford [EMAIL PROTECTED] To: CF-Talk

Best way to redirect .htm pages to .cfm?

2004-08-16 Thread Jim McAtee
I'm taking a small site previously done entirely in html and converting it to CF.Much of the site's page structure will remain the same.What's the most search engine friendly way to redirect pages so that previously indexed pages won't be dead?For instance, I'd like to redirect /contact.htm to

Re: Best way to redirect .htm pages to .cfm?

2004-08-16 Thread Jim McAtee
- Original Message - From: Bob Haroche [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, August 16, 2004 6:40 PM Subject: Re: Best way to redirect .htm pages to .cfm? Adrian Lynch wrote: Meta redirect or JS, not sure which is better for search engines though, I'd guess

Re: cf_sql_date

2004-07-30 Thread Jim McAtee
= cfqueryparam cfsqltype=cf_sql_date value=#somedatevariable# instead of mycolumn = #CreateODBCDate(somedatevariable)# make the code somewhat universal? - Original Message - From: Jim McAtee [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, July 29, 2004 5:39 PM Subject

cf_sql_date

2004-07-29 Thread Jim McAtee
Will the following create a value with or without a 'time' portion? cfqueryparam cfsqltype=cf_sql_date value=#Now()# [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

cfsilent how to...

2004-07-28 Thread Jim McAtee
ColdFusion 5.0.If I've got a cfsilent block and wish to cfinclude another template that generates output to the browser, is there a means of turning off cfsilent from within the included template? cfsilent [do stuff] cfif error_condition cfinclude template=error_message.cfm cfabort /cfif [do

Re: CFFile upload problem

2004-07-26 Thread Jim McAtee
those file input fields then I get the expected results. - Original Message - From: Jim McAtee [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 20, 2004 1:06 PM Subject: CFFile upload problem CF5.I'm having a bit of a time using cffile action="" used it i

CFFile upload problem

2004-07-20 Thread Jim McAtee
CF5.I'm having a bit of a time using cffile action="" used it in the past with no problems, but for some reason... I've got a large form containing an input field of type=file. form name=myform action="" method=post enctype=multipart/form-data input type=file name=premphoto size=50 maxlength=100

Re: CFFile upload problem

2004-07-20 Thread Jim McAtee
PM Subject: Re: CFFile upload problem could the maxlength attribute be truncating the file path?? Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Original Message - From: Jim McAtee To: CF-Talk

Re: CFFile upload problem

2004-07-20 Thread Jim McAtee
- Original Message - From: Dave Watts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 20, 2004 1:23 PM Subject: RE: CFFile upload problem input type=file name=premphoto size=50 maxlength=100 ... Are MAXLENGTH and SIZE valid attributes for a file upload field?

Re: CFFile upload problem

2004-07-20 Thread Jim McAtee
- Original Message - From: Dave Watts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 20, 2004 2:16 PM Subject: RE: CFFile upload problem What I'm finding is that the form field contains a temp file name cfif Len(form.premphoto) cfoutput#form.premphoto#/coufput

Re: Manipulation Excel files

2004-07-06 Thread Jim McAtee
It's been a while since I've done it, but it's pretty simple using the Excel ODBC drive.If I recall correctly, the worksheet names are treated as table names and then the first non-blank row in the Excel spreadsheet is treated as containing the field names (in Excel they would generall be column

Re: ColdFusion Blogging Tool

2004-06-20 Thread Jim McAtee
Maybe it's because most blogs are operated on personal web sites.How much does anyone want (or need) to pay per month so that they can have little more than email, a personal web site, blog and maybe some photo hosting? You can get a web site on a shared *nix server with Apache, php4, MySQL,

Re: Message Board

2004-06-11 Thread Jim McAtee
- Original Message - From: Rick Root [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, June 11, 2004 11:13 AM Subject: Re: Message Board Tim Laureska wrote: Rick... any links to where you can get these php message boards ... I know it's tough.. but.. phpbb =

Re: Is this a DateDiff() bug?

2004-06-06 Thread Jim McAtee
PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, June 05, 2004 4:06 PM Subject: RE: Is this a DateDiff() bug? Yeah, I wrote it to help someone out with a specific problem. Glad it can give you something to start with. Pascal -Original Message- From: Jim McAtee [mailto:[EMAIL

Re: Is this a DateDiff() bug?

2004-06-05 Thread Jim McAtee
,date2); if(DayOfWeek(date2) LT DayOfWeek(date1)) out = out - 2; out = out - (out\7)*2; return out; } Pascal -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED] Sent: zaterdag 5 juni 2004 2:52 To: CF-Talk Subject: Is this a DateDiff() bug? ColdFusion 5

Is this a DateDiff() bug?

2004-06-04 Thread Jim McAtee
ColdFusion 5: cfoutput pre DateDiff(d, 5/1/2004, 5/31/2004)= #DateDiff(d, 5/1/2004, 5/31/2004)# DateDiff(w, 5/1/2004, 5/31/2004)= #DateDiff(w, 5/1/2004, 5/31/2004)# DateDiff(ww, 5/1/2004, 5/31/2004) = #DateDiff(ww, 5/1/2004, 5/31/2004)# /pre /cfoutput Gives: DateDiff(d, 5/1/2004, 5/31/2004)= 30

Working with very large numbers

2004-05-29 Thread Jim McAtee
Does CF (v5) have a means of doing math with very large numbers?Example: cfset a = 57104432845826048260 cfset b = a + 1 cfoutput pre a= #a# b= #b# b= #NumberFormat(b, )# /pre /cfoutput Output: a= 57104432845826048260 b= 5.71044328458E+019 b= 57104432845826048000 [Todays

UDF Problem

2004-05-25 Thread Jim McAtee
Using CF5. I pull two float columns (prices) from a table and then pass the values to a CF function, shown below: function PriceRangeFormat(pricelo, pricehi) { return DollarFormat(pricelo) - DollarFormat(pricehi); } I receive the following error, no matter the values passed: Parameter 1 of

Re: UDF Problem

2004-05-25 Thread Jim McAtee
- Original Message - From: Scott Brady [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 25, 2004 3:37 PM Subject: re: UDF Problem Original Message: From: Jim McAtee But I can call DollarFormat() directly on the values without error. It's only when I pass them

Re: Hosting statement questioned

2004-05-22 Thread Jim McAtee
Do they permit the use of cfobject on the server? http://www.infinitehost.com/manual/guide12.asp http://www.infinitehost.com/manual/aspimagecoldfusn.txt - Original Message - From: C. Hatton Humphrey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 21, 2004 9:01 PM

Re: ad weights

2004-05-19 Thread Jim McAtee
- Original Message - From: Michael Dinowitz [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 19, 2004 1:03 AM Subject: Re: ad weights Your first solution would run into the problem of having a huge amount of low ads and few high ones. Lets say a banner system has 8

Re: ad weights

2004-05-18 Thread Jim McAtee
- Original Message - From: Michael Dinowitz [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 18, 2004 3:08 PM Subject: ad weights Here's a fun task. I'm building pay per click ads for HoF (in place of banner ads and yes, the list ads are coming off). One thing is that

Re: Strip multiple words from string

2004-05-16 Thread Jim McAtee
If, as you said, you're just putting together a keyword list, then take Claude's last suggestion.However, distinguishing between a 'word' and a 'phrase', without knowing what constitutes a phrase (that is, wihout already having a dictionary of what you want to consider to be phrases) is going to

Re: Strip multiple words from string

2004-05-16 Thread Jim McAtee
- Original Message - From: DougF [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, May 16, 2004 2:52 PM Subject: Re: Strip multiple words from string Part of the difficulty is describing the problem... sometimes the description evolves as unanticipated results materialize.

Cached query names

2004-05-14 Thread Jim McAtee
Cached queries are named and tracked by CF on a server-wide basis, correct?Say I cache a query with the name myquery, will an unrelated query (different SQL statement) with the same queryname cause the first query to be flushed, or will it have no effect on the caching? [Todays Threads] [This

Re: How would you handle this...

2004-05-13 Thread Jim McAtee
- Original Message - From: Tangorre, Michael [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 13, 2004 8:10 AM Subject: How would you handle this... I am working on an internal application and a lot of users want everything on one page despite my voiced concerns

Re: CFHTMLHEAD data

2004-05-13 Thread Jim McAtee
I'm in the same situation (CF 5) and need to be able to have several tags used in the course of generating a single page alter the contents. If I can't get access to the data, what I'm thinking of doing is keeping any data destined for the HTML headers in my own request scope variable and then

Re: Help setting up DNS MX Record.

2004-05-12 Thread Jim McAtee
This doesn't quite make sense.If, as you say, They have the DNS for the URL pointing at my server, then it implies that the customer (or their ISP or someone else) is doing DNS for the domain.So you shouldn't have to set up DNS records locally.Whoever is doing DNS for the domain should set up the

Access Question

2004-05-11 Thread Jim McAtee
Off topic:When a table is opened in Access in the spreadsheet-like view, sometimes a boolean Yes/No field appears as -1/0 and sometimes as checkboxes.What controls this, and is it indicative in any way of how the data field itself is defined? On topic:Is it always safe to do a query on an Access

Re: sending fax with coldfusion

2004-05-08 Thread Jim McAtee
If an email-to-fax solution is acceptable then you also have the option of doing the faxing yourself.GFI's FaxMaker is reasonably priced. http://www.gfi.com/ffn/ - Original Message - From: C. Hatton Humphrey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, May 08, 2004

cfscript question

2004-05-07 Thread Jim McAtee
If the declaration of variables using var within cfscript isn't necessary, what kind of variables are being created?Are they in the variables scope? For example, the variables 'sdatefmt' and 'edatefmt' in the cf function shown below: function DateRangeFormat(sdate, edate, mask, divider) { if

Re: cfscript question

2004-05-07 Thread Jim McAtee
- Original Message - From: Raymond Camden [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 07, 2004 11:49 AM Subject: RE: cfscript question What makes you think it is isn't necessary? Because it isn't.Period. Any variable created inside a cfscript based function, or

Billing System Query Help

2004-04-22 Thread Jim McAtee
The following is a simplification of an invoice/payment tracking database: Invoices - InvoiceIDINT CustomerName VARCHAR InvoiceItems - InvoiceItemID INT ItemAmountCURRENCY InvoicePayments - InvoicePaymentID INT

Re: Billing System Query Help

2004-04-22 Thread Jim McAtee
- Original Message - From: Heald, Tim [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 22, 2004 3:47 PM Subject: RE: Billing System Query Help Do you have link (foreign key) columns? With what you have here I am not sure how you would write a join. Also what

Re: best CF host for 20 dollars a month

2004-04-21 Thread Jim McAtee
I thought MS SQL was licensed per processor.No reason you can't grossly over-subscribe a SQL server, just like some web hosts badly overload shared web servers. You're right though, that's a lot to ask for $20/month.Although in the php/MySQL world it's easily found.If you look hard enough you can

Re: Http to https redirect

2004-04-20 Thread Jim McAtee
- Original Message - From: Westin, Ken [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 19, 2004 5:14 PM Subject: Http to https redirect OK so I have an application which I only want people to connect to using SSL, so I want to have it so that if anyone comes to a

Re: Recommend a threaded forum application

2004-04-18 Thread Jim McAtee
://www.vbulletin.com Maybe you missed this part From: Jim McAtee Must support CF5 and would prefer ODBC support for MySQL, but Access via ODBC is probably sufficient for this application. We ended up writing our own as the ones we looked at didn't do everything we needed Tieing it in to existing

Re: Recommend a threaded forum application

2004-04-18 Thread Jim McAtee
- Original Message - From: Doug White [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, April 17, 2004 6:43 PM Subject: Re: Recommend a threaded forum application Fuse Talk at http://www.fusetalk.com supports, MySQL, SQL2K, Access, one on one java chat, etc PHPBB by the

<    1   2   3   4   5   6   7   8   9   10   >