Re: Is there another way to write this???

2003-06-30 Thread Jim McAtee
temp = #temp# - Original Message - From: "Che Vilnonis" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, June 30, 2003 3:26 PM Subject: Is there another way to write this??? > > temp = #Evaluate(temp)# > > so that the result is .875 vs. 7/8 ??? ~~~

Re: best practice for building a large text file?

2003-07-01 Thread Jim McAtee
For a very large file, something in between. If you build a big file within memory (in an array or text variable) then you risk bringing the machine to a standstill or even crashing it. If you append to a file line by line a couple of million times you'll also tax the system and won't be doing yo

Re: best practice for building a large text file?

2003-07-01 Thread Jim McAtee
I didn't know the looping condition for your particular application. You'd just loop over your query. To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, July 01, 2003 11:37 AM Subject: Re: best practice for building a large text file? > Can you please just explain this line below. I'm building t

Re: Regex question

2003-07-01 Thread Jim McAtee
If you just want to replace all occurences of ~AA (caps only), anywhere in the file and you have the entire file contents in a single variable, the following should work: If you need to discern this character sequence only when it's the only thing on a line, you'll need to step through the file

Re: OT: Regex question

2003-07-01 Thread Jim McAtee
Do you have CF Studio or HomeSite+? They both permit the use of re's in the Extended Find and Extend Replace dialogs. The regex syntax should be pretty much identical to CF Server's syntax. Hard to say what TextPad's abilities or quirk's are when working with regular expressions. >From your ori

Re: Correct way to match a record with a list in one field?

2003-07-01 Thread Jim McAtee
Can you put leading and trailing commas into the field? ,1,3,9,12,2,51, SELECT EmailAddr, RecipientID FROM SupportEmailRecipient WHERE SubjectID LIKE '%,#FORM.SubjectID#,%' Better would be to normalize the data into two tables. - Original Message - From: "Lee Fuller" <[EMAIL PROTECT

MySQL ODBC Problem

2003-07-01 Thread Jim McAtee
Han anyone run into this? I've got a W2k server running MySQL. I set up a MySQL database with a couple of tables and a MySQL user with password and access to that database. On another server running CF5 I install MyODBC 3.51 and create a System DSN pointing at the MySQL database. I enter the us

Re: MySQL ODBC Problem

2003-07-01 Thread Jim McAtee
Just reread this. Should read: >From CF, though, I can't connect to the database unless I supply a username and password. - Original Message - From: "Jim McAtee" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, July 01,

Re: MySQL ODBC Problem

2003-07-01 Thread Jim McAtee
> --- > Matt Robertson, [EMAIL PROTECTED] > MSB Designs, Inc. http://mysecretbase.com > --- > > > -- Original Message -- > From: "Jim McAtee"

Re: MySQL ODBC Problem

2003-07-01 Thread Jim McAtee
Thanks, that did it. I was somehow under that impression that the CFAdmin wouldn't even see the datasource, so never looked at it there. It can't edit any aspect of the System DSN, but it does let you specify a username and password to be used by CF. Thanks, Jim - Original Message - Fr

Re: Anti-Spam Email harvesting

2003-07-08 Thread Jim McAtee
Use forms AND non-standard role addresses. A form doesn't do you any good if you've still got valid webmaster@ or info@ or admin@ addresses. - Original Message - From: "Owens, Howard" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, July 08, 2003 12:48 PM Subject: RE

Re: Anti-Spam Email harvesting

2003-07-08 Thread Jim McAtee
To what end? It's not doing you any good and I doubt if you're saturating anything. Those addresses will be used and sold and resold and even though the connections will be refused, they hit real mail servers and use up real resources. We've retired hundreds of email addresses over the years and

CF5 to MySQL without ODBC

2003-07-08 Thread Jim McAtee
We've begun moving a number of application databases from Access97 and Access2000 to MySQL 3 and we're currently using the MyODBC 3.51 driver to work with them from CF5. While I'm guessing that MySQL will behave much better than Access under load, under light loads it's pretty easy to see that MyS

Re: CF5 to MySQL without ODBC

2003-07-08 Thread Jim McAtee
robably* using mySQL 3.23. I suggest using the > older mySQL ODBC drivers (2.50) which were current for the older db. > > > Matt Robertson [EMAIL PROTECTED] > MSB Designs, Inc. http://mysecretbase.com > ------

Re: CF5 to MySQL without ODBC

2003-07-09 Thread Jim McAtee
Maybe I'm missing something, but if we're talking about CF5 access only through the MyODBC driver (maybe we're not) then why not just use ODBC formatted dates & date/times? - Original Message - From: "Barney Boisvert" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday,

Re: CF5 to MySQL without ODBC

2003-07-09 Thread Jim McAtee
So CFMX has a native driver for MySQL? I assume that if you had been using the MyODBC driver with CF5, you could continue to use it with CFMX? Of course, my original post in this thread was about how I could get away from using MyODBC with CF5. :-) I've never used any of the native drivers for M

Re: CF5 to MySQL without ODBC

2003-07-09 Thread Jim McAtee
- Original Message - From: "Matt Robertson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, July 09, 2003 11:30 PM Subject: RE: CF5 to MySQL without ODBC > Jim wrote, perplexed: > >So CFMX has a native driver for MySQL? > > Sorta kinda. It's the 'native' jdbc driv

Re: Php in cf help...

2003-07-12 Thread Jim McAtee
Show the code that is generating the error. - Original Message - From: "Ryan Mitchell" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, July 12, 2003 11:38 AM Subject: Php in cf help... > Hello > > Im trying to include a php file within a cold fusion page, and in

CF Developer Directory?

2002-12-09 Thread Jim McAtee
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 ~~

CF5 CFMail Bug?

2003-01-15 Thread Jim McAtee
Just wondering if any else has noticed this bug. It's somewhat inconsequential, but I'm righting an email log analyzer where it's proving a problem. My email server's SMTP process logs a short summary of messages that it receives for relaying. From these logs, it appears that in the SMTP EHLO co

Re: CF5 CFMail Bug?

2003-01-15 Thread Jim McAtee
for the SMTP mail server in CF > Administrator which should negate your having to specify the mail server in your > app. > > = > Douglas White > group Manager > mailto:[EMAIL PROTECTED] > http://www.samcfug.org > ====

Query How-To

2003-01-22 Thread Jim McAtee
How can I go about ordering the following query by first name? SELECT DISTINCT(t.employeeid), e.firstname + e.lastname AS name FROM transactions t LEFT JOIN employees e ON t.employeeid = e.employeeid The following query throws an error about a conflict between the ORDER BY and DISTI

Re: Query How-To

2003-01-22 Thread Jim McAtee
Tried that first, but same error (Access DB). Matthew's suggestion of adding e.firstname as a selected field did the trick, though. Thanks all! - Original Message - From: "Bryan Love" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, January 22, 2003 6:34 PM Subject

OT: Problem with DISTINCT()

2003-01-27 Thread Jim McAtee
Any ideas why I might be seeing duplicate email addresses in the dataset returned by this simple query (Access 97 via ODBC)? SELECT DISTINCT(email), name FROM table1 WHERE status = 'A' AND email <> '' In the output, I'm seeing stuff like: [EMAIL PROTECTED]Bob Smith [EMAIL PROTECTED]

Re: OT: Problem with DISTINCT()

2003-01-27 Thread Jim McAtee
gt; To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, January 27, 2003 6:24 PM Subject: Re: OT: Problem with DISTINCT() > That happened to me too - then I found out it was trailing white > spaces.. try trimming the white spaces > > > > Jim McAtee wrote: > > >A

Re: Problem with DISTINCT()

2003-01-27 Thread Jim McAtee
Thanks. I understand what you're saying. I couldn't get the suggested query to complete until I indexed the email field, but now it's pretty quick. Jim - Original Message - From: "Matthew Walker" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, January 27, 2003 3:24

Moving a custom tag (CF5)

2003-01-27 Thread Jim McAtee
I'd like to move a custom tag from a web site's local directory tree to one designated in the CF Server Administrator's 'Custom Tag Paths'. This is so that it can be used by another web site and so I don't have to maintain multiple copies of the tag. How do I get CF to recognize the new location

Re: SSL

2002-07-09 Thread 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. Anoth

OT: Very small volume web sales

2002-07-16 Thread Jim McAtee
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 Yaho

Re: OT: Very small volume web sales

2002-07-16 Thread Jim McAtee
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

Re: Very small volume web sales

2002-07-16 Thread Jim McAtee
w.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 [mailto:[EMAIL PROTECTED]] > Sent: Tue 7/16/2002 6:35 PM >

Re: Card Processors

2002-07-18 Thread Jim McAtee
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.fir

Re: Hosting providers

2002-07-18 Thread Jim McAtee
"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:5

Password protecting browsable web directories

2002-07-23 Thread Jim McAtee
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 to

Re: Password protecting browsable web directories

2002-07-23 Thread Jim McAtee
t points to that directory below the web root where you 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 s

IIS Cookie Logging

2002-07-24 Thread Jim McAtee
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 consis

Re: CGI.HTTP_REFERER

2002-07-27 Thread Jim McAtee
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

Re:

2002-03-11 Thread Jim McAtee
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 tag, or it could define the entire tag. In incHeader.cfm: #b

Re: sql data type wierdness

2002-03-11 Thread Jim McAtee
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. T

ReplaceList() with a different delimiter?

2002-03-12 Thread Jim McAtee
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 w

Re: (OT) IIS Question for Local Server and Host file

2002-03-18 Thread Jim McAtee
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 (mappe

Re: Need Suggestions - Multiple instances of application.

2002-03-20 Thread Jim McAtee
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-Tal

Re: moving from application to application

2002-03-22 Thread Jim McAtee
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" <[EM

Excel Export

2002-03-23 Thread Jim McAtee
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

Re: Time Issue

2002-03-25 Thread Jim McAtee
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: R

Re: Before I write it myself...

2002-03-30 Thread Jim McAtee
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 P

Re: What is MX

2002-04-01 Thread Jim McAtee
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

OT: JavaScript

2002-04-01 Thread Jim McAtee
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 (or

Re: WebTrends "uniqe visitors" stat

2002-04-01 Thread Jim McAtee
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 correc

Only permit execution from CF scheduler

2002-04-03 Thread Jim McAtee
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

Re: Only permit execution from CF scheduler

2002-04-03 Thread Jim McAtee
on from CF scheduler > You can check 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 > Subj

Re: Only permit execution from CF scheduler

2002-04-03 Thread Jim McAtee
gt; > > > You can check 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 >

CF Scheduler - Weekly and Monthly events?

2002-04-03 Thread 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 S

Re: CF Scheduler - Weekly and Monthly events?

2002-04-03 Thread Jim McAtee
1st day of each month. --- If so, I'm obviously going about scheduling something 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

Re: IIS 5.0 and server-side RAM cache?

2002-04-04 Thread Jim McAtee
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

Re: CF Will Not Start

2002-04-06 Thread Jim McAtee
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,

Re: Results where value starts with A thru G

2002-04-08 Thread Jim McAtee
< '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 >

Re: Security Access

2002-04-11 Thread Jim McAtee
If the second application.cfm has a 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 - Original Message ---

Re: null DateTime value

2002-04-13 Thread Jim McAtee
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

Re: Simple Application.cfm Question

2002-04-14 Thread Jim McAtee
- 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: > > http://www.mysite.com";> > > Then I call this on certain pages

Re: automatically submit form

2002-04-15 Thread Jim McAtee
http://www.somewhere.com/cgi-bin/whatever method="post"> 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 form to submit to a r

Re: Threaded list integration

2002-04-17 Thread Jim McAtee
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 giv

Re: Access /SQL Server

2002-04-22 Thread Jim McAtee
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 sw

Re: RegEx for alpha num

2002-04-22 Thread Jim McAtee
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 ^ an

Can I do this with CF client variables?

2002-04-23 Thread Jim McAtee
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 reco

Re: Can I do this with CF client variables?

2002-04-23 Thread Jim McAtee
s from 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

Re: Can I do this with CF client variables?

2002-04-23 Thread Jim McAtee
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 clien

Re: 2 Zip or Not 2 Zip

2002-04-24 Thread Jim McAtee
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" <

NumberFormat() Mask

2002-04-29 Thread Jim McAtee
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

Re: NumberFormat() Mask

2002-04-29 Thread Jim McAtee
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: Mon

HTML cfmail question

2002-05-01 Thread Jim McAtee
When using cfmail type="html", is it best to include a full set of html tags (, , ), 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 ___

Re: [OT] Mail Delay ?

2000-05-20 Thread Jim McAtee
Michael, "route through the server and send badly formatted email headers" Could you clarify this? I'd like to know if there's something I'm doing wrong, as I'm commonly seeing delays of six or more hours on week days. Needless to say, twelve hour turnaround times seriously decrease the usefuln

Re: DBASE

2000-05-25 Thread Jim McAtee
Access works exactly the same. You need to perform a "Compact Database" operation to free up the space occupied by deleted records. Jim -Original Message- From: Michael O Reilly <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Thursday, May 25, 2000 11:20 AM Subject:

Re: DBASE

2000-05-25 Thread Jim McAtee
Actually the latest versions of the Microsoft drivers (MDAC 2.0+, I believe) have removed all database update capability for DBase files. So, unless you only need read access, or can live with the older ODBC drivers (many security problems), then DBase isn't really an option on NT. I'd be intere

Re: Replacement for CFHTTP

2000-05-26 Thread Jim McAtee
Does Express support custom tags? If so, there are a couple (cfx_delimtoquery is one) that do this from a local file. Cfx_delimtoquery can't pull files from remote servers via http, however. Jim -Original Message- From: [EMAIL PROTECTED] <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAI

Re: CFFILE question

2000-05-26 Thread Jim McAtee
You're pretty much on your own. CFFILE provides just simple means of modifying and working with files within the file system. For fixed width columns, I usually use the LeftJustify() function, something like: If the file is relatively small, construct the whole file in m

Re: Cold Fusion and Julian Dates

2000-05-26 Thread Jim McAtee
Try using #Int(Now()# to get a numeric value for the current date. I don't think it's the actual "Julian" date, but the number of days elapsed since Dec 30, 1899. Jim -Original Message- From: Jeff Honken <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Friday, May 26

Re: Listing Items That Expire Today? Help!

2000-05-26 Thread Jim McAtee
Why are you testing the date against two different date/time values in the where clause? Try it with just a single test, with < instead of <= and use the function CreateODBCDate() instead of CreateODBCDateTime(). This should find all records with an ExpiryDate before today. WHERE Coupons.Expiry

Re: Listing Items That Expire Today? Help!

2000-05-28 Thread Jim McAtee
Ahh, in that case: WHERE ( Coupons.ExpiryDate BETWEEN #CreateODBCDateTime(Int(Now()))# AND #CreateODBCDateTime(Int(Now()+1))# ) AND ... Jim -Original Message- From: Jennifer L <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Saturday, May 27

Re: Tricky sorting riddle.

2000-05-29 Thread Jim McAtee
Not too sure what date functions are valid in Access, but you couldn't use an CF functions within the expression if you expect it to be executed by the database. How about just: SELECT ID, Since, Rate, Lease_length, sq_ft_leased, Name, DateAdd(MONTH,lease_length,Since) AS sortable_date FR

Studio Question

2000-05-31 Thread Jim McAtee
When using Studio's Extended Replace with regular expressions, how do you do backreferencing so that you can reference matched text in your replacement expression? For example: Find -- value=""> Replace ? -- Jim --

Re: I want my #$# on the first of the month.

2000-05-31 Thread Jim McAtee
Find the current month, create a date for the first of this month, then add one month to that date. #CreateODBCDate(DateAdd("m", 1, CreateDate(Year(Now()), DatePart("m", Now()), 1)))# Jim -Original Message- From: Timothy C. Hill <[EMAIL PROTECTED]> To: [EMAIL PROTECTED]

Re: Querying a recordset ...

2000-06-04 Thread Jim McAtee
I don't think you have any choice. _Something_ has to loop through all the rows of the query and make a decision on what to include/exclude. If you find (or write) another custom tag to do this, it may actually end up being less effecient (even if cleaner looking in your CF templates). You've g

Dynamic CFPARAM Statements

2000-06-04 Thread Jim McAtee
I've got a form with a series of form fields whose names are dynamically generated in an indexed loop. i.e. form.unit1_name form.unit1_listed form.unit2_name form.unit2_listed etc. One of these form fields is a checkbox and in the action template I want to default the value to "0" using CFPAR

Re: Dynamic CFPARAM Statements

2000-06-04 Thread Jim McAtee
Thanks John. Actually, I had it right the first time. I had "cfparam" misspelled and didn't notice. I need to take start taking weekends off. :-) Jim -Original Message- From: John Quarto-vonTivadar <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Sunday, June 04

Re:

2000-06-17 Thread Jim McAtee
If I'm not mistaken, CFLOCATION alters the http headers, which in turn redirect the browser to the new page. Therefore, the Javascript on the page containing the CFLOCATION will never be executed. Have youe tried to do it purely by using javascript in the onLoad() handler and doing: (in sequence

Re: Question: Where Is Cold Fusion 404 Page?

2000-06-17 Thread Jim McAtee
Windows native Find Files works just as well. It's just an ascii string sitting in the middle of the executable. It doesn't get encoded or compressed in any way. Jim -Original Message- From: Dave Watts <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Cc: [EMAIL PROTECTED]

Re: REGEX validating email

2000-06-18 Thread Jim McAtee
Seth, Corrected RE is below. Toward the end, I added a \ at *\.[[:alpha:]]{2,}$ "^([[:alnum:]][-a-Sa-Z0-9_%\.]*)?[[:alnum:]]@[[:alnum:]] [-a-Sa-Z0-9%\> .]*\.[[:alpha:]]{2,}$" Everything else looks correct, except that it accepts spaces and the ">" character within the host name. Are those act

Re: How to stop an infinite CF loop?

2000-06-19 Thread Jim McAtee
I can't believe you didn't immediately shut down the CF server if you suspected there was a template running amok. I'm aware of only two things that would cause a working template to terminate prematurely. The first is if the request timeout is met. You have a default template timeout set for t

Re: need a non-greedy RegEx

2000-06-19 Thread Jim McAtee
If the headline text doesn't contain any HTML, then you could probably use: "[^<]*" Replacing the .* with [^<]* matches zero or more of any character _except_ for a <, so that section only matches up to the start of the next tag. Jim -Original Message- From: Owens, Howard <[EMAIL PROT

Re: REGEX validating email

2000-06-19 Thread Jim McAtee
Yep, something got munged in the copying. Thanks for catching it. Jim -Original Message- From: Seth Petry-Johnson <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Monday, June 19, 2000 8:08 PM Subject: Re: REGEX validating email >> Corrected RE is below. Toward th

Re: using at rather than cfschedule

2000-06-23 Thread Jim McAtee
Create a batch file and schedule the batch file using AT. In the batch file you need to set an environment variable indicating the location of the cf template. Optionally, you can set whatever values you'd want in your CGI query string (url parameters). Example: @echo off set "QUERY_STRING=Req

Re: Slightly OT: MS SQL 6.5 -> 7 upgrade

2000-06-24 Thread Jim McAtee
http://www.us.buy.com/soft/product.asp?sku=2863 -Original Message- From: Howie Hamlin <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Saturday, June 24, 2000 4:23 PM Subject: Slightly OT: MS SQL 6.5 -> 7 upgrade >Does anyone know where I can purchase MS SQL Serv

Re: Decimal points

2000-06-25 Thread Jim McAtee
Yes. Using JavaScript and onKey(). Jim -Original Message- From: Parker, Kevin <[EMAIL PROTECTED]> To: CF Talk (E-mail) <[EMAIL PROTECTED]> Date: Sunday, June 25, 2000 8:22 PM Subject: Decimal points >Is it possible to limit the number of places an end user can enter in a >decimal valu

Re: Why won't my work with this??

2000-06-30 Thread Jim McAtee
Jeff, CF won't see ViewField6 as being from the query GetRecord. CF will see it as a simple variable. This has to do with the concept of scoping of variables. Check the online help for more information. To address the field from the query, use: One other bit of advice is to not use Paramet

Re: copy all files in a directory?

2000-07-03 Thread Jim McAtee
Not sure why you don't want to use a custom tag, but if you change your mind, look into CF_AutoCopy in the Allaire tag gallery. If you want to do it yourself, you'll need to get directory listings, copy individual files, traverse subdirectories, create subdirectories at the destination. You'll h

Re: What am I doing wrong?-solved

2000-07-03 Thread Jim McAtee
That's correct. A WHERE clause is illegal in an insert. If by wrapping the insert in a cfif statement you mean to do either an insert or an update, that's correct. You'll have some criteria to determine if you're doing an insert or an update (often this will be if a record id is passed to the t

What kind of CF Server bug is this?

2000-07-04 Thread Jim McAtee
I was debugging a template and set a url paramater for RequestTimeout=60. Turns out the template only needs 2 or 3 seconds to run. Now, when I run the template without any url parameters, I get the following error: Error Occurred While Processing Request -

Re: Hundreds of messages left undelivered ... why?

2000-07-06 Thread Jim McAtee
I'm not sure I undestand this. Doesn't CF merely pass off the messages to the SMTP server for relaying? Same as if they had come from an email client such as Outlook Express? Is it the mass-assault on the SMTP server that causes messages to be immediately sent to the undeliv folder? In my expe

Re: Why does blank dates default to 1899-12-30?

2000-07-07 Thread Jim McAtee
-Original Message- From: Paige Chandler <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Friday, July 07, 2000 9:10 AM Subject: Re: Why does blank dates default to 1899-12-30? >Hi Michael, > >Thanks for the suggestion. This is very bad news. My app displays the status

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