Access 2000 - ALTER TABLE - Allow Zero Length

2002-10-22 Thread Jim McAtee
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 ~

Re: Access 2000 - ALTER TABLE - Allow Zero Length

2002-10-22 Thread Jim McAtee
is too some time back and come up with no answers. > >An easier solution I've found is to use to insert nulls > >if the field is empty. > > > >> -Original Message- > >> From: Jim McAtee [mailto:jmcatee@;mediaodyssey.com] > >> Sent: Wednesday, 23 October

Re: GoogleBot Robot.txt

2002-11-26 Thread Jim McAtee
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 _wh

IIS ISAPI authentication filter with CF Interface

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

IP Address as CF Number

2002-09-25 Thread Jim McAtee
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 varia

Re: IP Address as CF Number

2002-09-25 Thread Jim McAtee
nal Message - From: "Robertson-Ravo, Neil (REC)" <[EMAIL 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 > > --

Re: IP Address as CF Number

2002-09-25 Thread Jim McAtee
(at least 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 PROTE

Re: i shall ask 1 more time (works for me)

2003-02-17 Thread Jim McAtee
I suspect the code you posted may not reflect what you're using. In any case, I wouldn't recommend doing all the comparisons of days, hours, minutes and seconds to tell if an auction has ended. You've got the end date/time ("deadline") and you know what the current date/time are (Now()). Just co

Re: Updating Multiple Records

2003-02-22 Thread Jim McAtee
I don't think I'd trust that approach. It's too dependant on the way the browser submits the form. There's no guarantee that the 1st item in the list #form.a# will correspond to the first item in list #form.b#, etc. Probably most browsers _do_ work like this, but it's nearly as easy to name the f

Re: Allowing specific HTML tags to be displayed

2003-02-24 Thread Jim McAtee
- Original Message - From: "Russ" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, February 24, 2003 12:16 PM Subject: Allowing specific HTML tags to be displayed > I've still not had any luck trying to get Replace or ReReplace to allow > a set of specific codes when di

Re: text parsing tool

2003-02-27 Thread Jim McAtee
Then use CF and its regex capability (maybe just ReReplace()). It's unlikely to be anywhere near as fast as Perl, but if you're not processing hundreds or thousands of files, big deal. CF shouldn't have much of a problem with 5MB files. If they were 100MB I'd look elsewhere. If you wan't to do

Re: Multiple Web Servers

2003-02-27 Thread Jim McAtee
- Original Message - From: "Dave Watts" <[EMAIL PROTECTED]> > > You might also want multiple web servers if you have scripts > > or other non-CF stuff on your site that puts load on the > > web servers. > > Why wouldn't I just put that stuff on a web server that's not using CF? If you'v

Re: calculating date recurrence

2003-02-27 Thread Jim McAtee
Do you actually need to populate an array with all the possible dates? You can test if any given day is one of the recurring days using the mod operator and DateDiff() function. How about the following to generate an array. I've added an end date, which wouldn't necessarily have to fall on one o

Re: win 2000 professional for web server?

2003-03-04 Thread Jim McAtee
You don't need CALs for anonymous connections to either a CF web site or a non-CF web site. You only need CALs for connections that use Windows authentication, such as IIS' FTP users. Also, shop around - you should be able to find Windows 2000 w/5 cals for under $700. Jim - Original Messag

Re: win 2000 professional for web server?

2003-03-04 Thread Jim McAtee
- Original Message - From: "dan martin" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, March 04, 2003 12:46 PM Subject: win 2000 professional for web server? > I called MS and was told that I need three sets of licenses with separate part numbers: > 1. for win2k serv

Re: CFDirectory overhead?

2003-03-05 Thread Jim McAtee
I think CF just does an operating system function call to retrieve the directory listing, as would any other language. Performance should be fine unless you've got thousands of files in the directory. If you anticipate having quite a few files, use some type of convention for creating directories

OT: DHTML/Javascript question

2003-03-07 Thread Jim McAtee
I've got an intranet site that uses a simple frame construct for navigation. It has a 60 pixel tall navigation frame across the top of the screen that uses icons and text links, while the working application pages are displayed below. I'd like to convert this to using DHTML drop-down menus within

Re: CF and MySQL

2003-03-08 Thread Jim McAtee
- Original Message - From: "samcfug" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, March 08, 2003 11:11 AM Subject: Re: CF and MySQL > Also uncheck the "keep connection alive" Why? I remember quite a few problems with CF memory leaks and earlier MS ODBC drivers.

Re: Changing from HTTPS to HTTP for normal pages

2003-03-10 Thread Jim McAtee
- Original Message - From: "Issac Rosa" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, March 10, 2003 11:59 AM Subject: Changing from HTTPS to HTTP for normal pages > What's the best way to setup the page links so that when you go to a secure page > via https and then

Re: Easy Len ?

2003-03-12 Thread Jim McAtee
The following should count non-whitespace characaters in a string: Jim - Original Message - From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, March 12, 2003 2:31 PM Subject: Easy Len ? > What is the best way to actually count the number of characters enter

OT: NTLM Authentication

2003-03-12 Thread Jim McAtee
If I enable Basic Authentication for an IIS 5 web site protected by NTFS ACLs, will Internet Explorer still use NTLM to authenticate if its able to? In other words, does enabling Basic Authentication keep IIS from using NTLM, or does it only enable Basic Authentication as fallback method? Jim ~~

Re: NTLM Authentication

2003-03-13 Thread Jim McAtee
- Original Message - From: "Dave Watts" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, March 12, 2003 7:23 PM Subject: RE: NTLM Authentication > > If I enable Basic Authentication for an IIS 5 web site > > protected by NTFS ACLs, will Internet Explorer still > > us

Re: Replace function

2003-03-26 Thread Jim McAtee
#ReplaceList(co1005, "<,>", ",")# Robert Orlini wrote: > I am using the Replace function to clear a "<" character in a > column. > > The line I use to display between is: #replace(col005, > "<", "", "all")#. > > This is probably simple, but the column data contains another > character I w

Re: appropriate SQL 7 licensing for CF website

2000-08-01 Thread Jim McAtee
Good point. MS SQL Server is pretty cheap compared to comparably performing alternatives. If you're putting up a web site for "Joe's Bait & Tackle" and absolutely must have the security of MS SQL Server then you have to be willing to pay for it. For those advocating the purchase of CALs instead

Re: [OT] IE 5.5 and CSS

2000-08-02 Thread Jim McAtee
I noticed similar in IE 5.5. I haven't had time to investigate it yet, but I've heard two things about IE 5.5. One, the implementation of CSS is more compliant with established standards. Two, it's much buggier that IE 5. So, either the CSS that used to work, doesn't anymore because it's been

Re: Hosting Solutions???

2000-08-04 Thread Jim McAtee
Jon, Man, you nailed it. I suspect most of the "good" shared server CF hosting that exists right now is done by development companies for their clients, for exactly the reasons you've mentioned. Fairly safe if you're writing all the code running on the box. In a "blind" shared environment you

Re: Forwarding mail which is sent to unknown postboxes ?

2000-08-05 Thread Jim McAtee
First off, I'm assuming that you can control the mail server configuration at 'domain.com', correct? Usually, you'd set this up in the mail server's alias table for the domain. Depending on the mail server, you probably have the ability to use wildcards in the aliases, which can make managing th

Re: How to pipe CF code to a file?

2000-08-07 Thread Jim McAtee
Use CFHTTP, which can save directly to a file. Jim -Original Message- From: Ryan <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Monday, August 07, 2000 4:18 PM Subject: How to pipe CF code to a file? >Hello. I need to be able to execute a set of CF tags but >send

Re: CFMAIL and exchange server

2000-08-08 Thread Jim McAtee
Really? What is the one minute delay? I've always gotten mail almost instantly from templates using CFMAIL. (CF 3.x and 4.0.x) Jim -Original Message- From: Howie Hamlin <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Tuesday, August 08, 2000 4:00 PM Subject: Re: CF

Re: cffile

2000-08-08 Thread Jim McAtee
Use the FileExists() function or the CFDIRECTORY tag to see if the file exists after doing the delete. Jim -Original Message- From: Phim <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Tuesday, August 08, 2000 11:39 PM Subject: cffile >Hi Everyone, > > >I use CFFIL

SQL: Using LIKE with and without a wildcard

2000-08-14 Thread Jim McAtee
As a rule, will their be a performance penalty using LIKE instead of = in SQL queries if there's NOT a wildcard in the expression? That is, if my users have the option of using wildcards in their searches (on multiple fields), is it better to detect the presence/absence of a wildcard and adjust t

Re: CFMAIL and exchange server

2000-08-15 Thread Jim McAtee
o a minimum of 15 >seconds. > >Regards, > >Howie > >- Original Message - >From: Jim McAtee <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Tuesday, August 08, 2000 8:39 PM >Subject: Re: CFMAIL and exchange server > > >> Really? Wh

Re: SQL Trigger vs. Stored Procdure

2000-08-16 Thread Jim McAtee
To the original question of whether a cached CF query will be more efficient than reading and looping over the contents of a .csv file. Definitely, since the cached query will be kept in memory. I suppose what you could do (and I have no idea how to accomplish this) is have a SQL trigger that som

Re: CF's Redheaded Stepchild

2000-08-18 Thread Jim McAtee
-Original Message- From: Chris <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Friday, August 18, 2000 11:28 AM Subject: Re: CF's Redheaded Stepchild >At 01:15 PM 8/18/2000 -0400, you wrote: >>Good explanation, Benjamin. >> >>Rey... > >Another problem with ToysRUs was

Re: Mailing List

2000-08-18 Thread Jim McAtee
First you want to use a list server. Most NT mail servers include a list server, although more efficient, dedicated list servers can be had, especially under the Unix OS variations. If the list server has an API that CF can talk to, and you keep your addresses in some type of database that can b

Re: Help with CFFTP

2000-08-19 Thread Jim McAtee
Are you sure you're making the connection? Does it work when everything is valid? If not, the very first thing I'd do is test by using an FTP client and see if you can connect and log in. Then, I'd hard code the server address, username, password, etc. to see if you can do it from CF. Dependin

Re: "portable" logon scheme

2000-08-20 Thread Jim McAtee
Try something like this within application.cfm. This should work, since the include will be relative to application.cfm, not the base template. Redirect to session.attemptedpage upon a successful login. Jim -Original Message- From: Chris Lott <[EMAIL PROTECTED]> To: [EMAIL

Re: Help with CFFTP

2000-08-20 Thread Jim McAtee
Try connecting manually to the same server via an FTP client and see how long it takes to respond if you send it an invalid login. Could just be the way the FTP server (mis)behaves. Jim -Original Message- From: Matt Lewis <[EMAIL PROTECTED]> To: Jim McAtee <[EMAIL PROTECTED]

Re: Let's Brag...

2000-08-21 Thread Jim McAtee
-Original Message- From: Steve Bernard <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Monday, August 21, 2000 5:05 PM Subject: RE: Let's Brag... >Stephen, > >IPSec is one means to control/secure traffic to and from the server. The box >is behind a proxy/firewall that

Stored Procedure BLOCKFACTOR

2000-08-22 Thread Jim McAtee
Could someone explain how the BLOCKFACTOR parameter of CFSTOREDPROCEDURE is used. It's not clear to me how the maximum number of rows returned by a result set can be limited to 100 (according to the CF 4 documentation). What am I missing? Thanks, Jim -

Re: Stored Procedure BLOCKFACTOR

2000-08-22 Thread Jim McAtee
ificial to any givent SP call. Jim -Original Message- From: Bud <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Tuesday, August 22, 2000 7:48 PM Subject: Re: Stored Procedure BLOCKFACTOR >On 8/22/00, Jim McAtee penned: >>Could someone explain h

Re: Basic Authentication: Logging off

2000-08-26 Thread Jim McAtee
Sounds as though you're saying that once a browser receives a 401 response, it will no longer send the previously used credentials. Now, say the user "logs off", but fails to log in as someone else. Would the browser send the original, valid credentials if the user goes back (in the same browser

Re: Basic Authentication: Logging off

2000-08-26 Thread Jim McAtee
als until it is restarted >or receives an "Unauthorized" response from the server. > >Regards, > >Howie > >- Original Message - >From: "Jim McAtee" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Saturday, August 26, 2000 12

Re: Blank pages

2000-08-28 Thread Jim McAtee
This looks like some generic page thrown out by the web server. I'd suspect that the CF/Website Pro communication somehow failed. I've seen IIS do something similar. Jim -Original Message- From: Howie Hamlin <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Monday, A

Re: CF and WebTrends

2000-08-28 Thread Jim McAtee
-Original Message- From: Zachary Bedell <[EMAIL PROTECTED]> To: '[EMAIL PROTECTED]' <[EMAIL PROTECTED]> Date: Monday, August 28, 2000 11:41 AM Subject: RE: CF and WebTrends >-BEGIN PGP SIGNED MESSAGE- >Hash: SHA1 > >> Is there any problem with using WebTrends on a CF site? Can >

Query Help - Using 'GROUP'

2000-08-29 Thread Jim McAtee
I've got a one to many relationship linking tables A -> B -> C. For each item in A (sales reps), I've got multiple records in B (linking reps to territories) and C contains the territories - say North, South, East and West. I want to output a table something like Reps Territories - -

Re: Query Help - Using 'GROUP'

2000-08-29 Thread Jim McAtee
p (so I don't append a comma)? Here's what I have: Agent Territories #r.firstname# #r.lastname# #r.territory#, Jim -Original Message- From: Jim McAtee <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Tuesd

CFLOCK with CFPARAM

2000-08-30 Thread Jim McAtee
Should one use CFLOCK around statements that access session variables? Jim -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=list

CFLOCK on Session Variables

2000-08-30 Thread Jim McAtee
A couple of general questions regarding locking session variables (CF 4.0.1): Does a CFLOCK with name="#session.sesionid#" only lock the variables in memory for that particular session, or does it lock all session variables for the application? The CF 4.0.1 documentation for CFLOCK has the follo

Re: IIS "Locking" Files

2000-08-31 Thread Jim McAtee
Dave, You might also try a different approach to naming the uploaded files. If possible, have your webcam upload the images with a unique filename. For example, instead of uploading as "thispic.jpg", append a timestamp, as in "thispic1405.jpg". Your CF template that displays the image could do a

Re: CFLOCK on Session Variables

2000-08-31 Thread Jim McAtee
-Original Message- From: Zachary Bedell <[EMAIL PROTECTED]> To: '[EMAIL PROTECTED]' <[EMAIL PROTECTED]> Date: Thursday, August 31, 2000 11:28 AM Subject: RE: CFLOCK on Session Variables >Okay... >Last time now... >This is your server [holds up egg]. >This is your server with out locking

Re: IIS "Locking" Files

2000-08-31 Thread Jim McAtee
wford <[EMAIL PROTECTED]> To: Jim McAtee <[EMAIL PROTECTED]>; [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Thursday, August 31, 2000 11:22 AM Subject: RE: IIS "Locking" Files >Re: IIS "Locking" FilesWell, I would, except that I am using the FTP client >

Re: CFLOCK on Session Variables

2000-09-01 Thread Jim McAtee
-Original Message- From: Kevin Miller <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>; [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Thursday, August 31, 2000 6:57 PM Subject: RE: CFLOCK on Session Variables >I love Cold Fusion, but this is a really rotten basket that screams

Re: Which one will take?

2000-09-01 Thread Jim McAtee
The original question is just an example of the many questions raised in migrating CF, an application server so rooted in NT, to a UNIX environment. Regardless of whether it's a good idea or not, there must be very cut and dried (read 'predictable') behaviors in situations like this, and they sho

Re: CFDIRECTORY Filtering?

2000-09-07 Thread Jim McAtee
You can't do this in the filter. Two workarounds: 1) Use a within a loop over your query results. 2) rename the file before and after the call to . Jim -Original Message- From: Claremont, Timothy S <[EMAIL PROTECTED]> To: '[EMAIL PROTECTED]' <[EMAIL PROTECTED]> Date: Thursday, Septembe

Re: Is CF a "high risk application"?

2000-09-07 Thread Jim McAtee
You don't say if this is to be run on a dedicated ("managed"?) server or on a shared host? If the the hosting provider has such extreme reservations about hosting and supporting CF applications, then someone definitely picked the wrong host and you may be in for quite a nightmare if you run into

CFOBJECT Problem

2000-09-11 Thread Jim McAtee
This is my first use of CFOBJECT. What does the "dll was not loaded" error message below mean? The dll is registered on the server and the --- Error Occurred While Processing Request Error Diagnostic Information The

CFOBJECT Help

2000-09-12 Thread Jim McAtee
Sorry to post this again, but someone must have an idea what this error message indicates. Looking at it again, I realize it's a CF error, not a COM error. Any ideas? This is my first use of CFOBJECT. What does the "dll was not loaded" error message below mean? The dll is registered on the se

Re: CFOBJECT Help

2000-09-12 Thread Jim McAtee
A... Very good point. The COM object is essentially a wrapper for the GoldMine API dll. That must be the dll that isn't loaded (and it's not, since GM is actually running on a separate machine, along with MS SQL). I think I'll try calling the COM object on the other machine using context="R

Re: what happens after browser STOPS

2000-09-13 Thread Jim McAtee
Does a STOP send any type of explicit 'request' to the web server? Jim -Original Message- From: Aaron Johnson <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Wednesday, September 13, 2000 12:44 AM Subject: RE: what happens after browser STOPS >Adrian, > >The query

SQL Varchar

2000-09-14 Thread Jim McAtee
I've got a MS SQL 7 table with some fields defined as Varchar(510). When I retrieve them in CF Pro 4.01 via ODBC, they get truncated to 255 characters. Is there a reason for this? How about a workaround? Jim -- Archive

MS SQL 7 Varchar

2000-09-15 Thread Jim McAtee
I've got a MS SQL 7 table with some fields defined as Varchar(510). When I retrieve them in CF Pro 4.01 via ODBC, they get truncated to 255 characters. Is there a reason for this? How about a workaround? Jim -- Archive

Application Variables in DB?

2000-09-15 Thread Jim McAtee
Can application variables be stored in a database (by CF, not by me) like client variables? This would be handy for persistence between application runs should the server be rebooted. Jim -- Archives: http://www.mail-ar

Re: Null values within lists

2000-09-16 Thread Jim McAtee
Replace all the delimiters in the list with . Then use Trim() to get rid of the extra spaces. Original List: #List# Item ## #i#: #Trim(ListGetAt(List, i))# Jim -Original Message- From: Aidan Whitehall <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Saturday

Re: WOT: Allaire stock price

2000-09-16 Thread Jim McAtee
-Original Message- From: Adrian Cooper <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Saturday, September 16, 2000 1:00 PM Subject: Re: WOT: Allaire stock price > >- Original Message - >From: "Len Conrad" <[EMAIL PROTECTED]> >Sent: Saturday, September 16, 200

Re: MS SQL 7 Varchar

2000-09-17 Thread Jim McAtee
t (255). > >-Original Message- >From: Jim McAtee [mailto:[EMAIL PROTECTED]] >Sent: Friday, September 15, 2000 10:19 AM >To: [EMAIL PROTECTED] >Subject: MS SQL 7 Varchar > > >I've got a MS SQL 7 table with some fields defined as Varchar(510). >When I retrieve

CFPOP's MessageNumber

2000-09-17 Thread Jim McAtee
If I do a CFPOP with ACTION="GetAll" and then later do an ACTION="Delete", how does CF keep track of which message I'm referring to? What if in the meantime another process had deleted one or more of the messages returned in the original call to CFPOP - will message #10 still be the message I tho

Re: [CF-Talk] Incorrect use of CFPARAM?

2000-09-18 Thread Jim McAtee
That's the way it should work. You shouldn't really need to set default values passed in from a select box, since a value will always be passed. By default, the browser will preselect the first one, unless told otherwise, and that value will be passed if the user doesn't change it. I'd guess tha

Destroying a Query [CF-Talk]

2000-09-20 Thread Jim McAtee
Can I release a query that has been created within a template and is no longer needed? (CF 4.0.1) A couple of other questions: Are queries in the variables scope or do they have their own scope? If I can release, delete, undefine, redefine, or otherwise get rid of the query, does CF actually r

Associative Array Indexing [CF-Talk]

2000-09-20 Thread Jim McAtee
Are the following ways of addressing an associate array key equivalent? The numeric values are what I'm unsure of. Does CF simply convert them to strings for use as the key? -- Archives: http://www.mail-archive.

Re: [CF-Talk] Random Images-Resources for Information?

2000-09-20 Thread Jim McAtee
Depends what you're thinking when you say random. If you mean calling the function 7 times always pulls up 7 different numbers, then that is NOT a random sequence. By chance (err... 'randomness') you could conceivably pull up the same number 7 times in a row (or a hundred times in a row). You'd

CFPOP Problems

2000-09-21 Thread Jim McAtee
I'm having two problems using CFPOP under CF 4.5.1 SP1: First, I sometimes receive an error when deleting messages. I do a CFPOP, retrieve multiple messages, loop through them and do my thing. Then when I try to use CFPOP to delete a message (I delete each one inside the loop), I'll get this err

Re: CFPOP Problems

2000-09-21 Thread Jim McAtee
ber five becomes what was previoulsy as number 6. The best thing to >do is to remove the messages in reverse order, so using the cfloop >from=Total to=1 step=-1 will do the trick:-) > >regards > >Andrew Scott >ANZ eCommerce Centre >* Ph 9273 0693 >* [EMAIL PROTECTED] > &

Re: Flushing mech..in CF

2000-09-24 Thread Jim McAtee
You need to jiggle the handle. Jim -Original Message- From: Venkata Ramakrishna <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Date: Saturday, September 23, 2000 11:56 PM Subject: Flushing mech..in CF >Hi, > >Can somebody please enlighten me on the flushing >mechanisms available

No Subject

2000-09-24 Thread Jim McAtee
Can't figure out why the following query behaves like it does, but I'm guessing there must be something fundamental about how SQL operates that I'm not comprehending. I've got a one:many relationship between table A and table B. Table B records represent "new for year" for a given record in

Re: Newbie" CFIF for range of data

2000-09-24 Thread Jim McAtee
If you're not worried about the number being negative: Jim -Original Message- From: Olson, Kelly <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Date: Sunday, September 24, 2000 1:50 PM Subject: Newbie" CFIF for range of data >How would you write a conditional statem

SQL Help

2000-09-24 Thread Jim McAtee
Try it again, with a subject this time... Can't figure out why the following query behaves like it does, but I'm guessing there must be something fundamental about how SQL operates that I'm not comprehending. I've got a one:many relationship between table A and table B. Table B records represen

Re: SQL Help

2000-09-24 Thread Jim McAtee
Yep. Left, right and inner joins all produce the same result. Jim -Original Message- From: Mark Warrick <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Date: Sunday, September 24, 2000 4:15 PM Subject: RE: SQL Help Silly question but have you tried a right outer join? SELECT A.*

Re: Discussing Rates in a Public Forum -- was National Radio Commercial

2000-09-24 Thread Jim McAtee
Thanks for the advice, Steve. I'm raising my fees. (Now your in for it). ;-) Jim -Original Message- From: Steve Pierce <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Date: Sunday, September 24, 2000 6:13 PM Subject: RE: Discussing Rates in a Public Forum -- was National Radio Co

Re: access to SQL server woes

2000-09-24 Thread Jim McAtee
I recently got this error when I failed to change the default database during the ODBC setup. If you do the ODBC setup from the control panel, and within the setup wizard you fail to notice this step, then you're likely pointing your ODBC datasource at the 'master' database. I believe the wizard

Re: access to SQL server woes

2000-09-25 Thread Jim McAtee
I've only set up a SQL datasource a few times and haven't yet had any luck doing it from the CF Administrator. On the Administrator's 'Edit ODBC Datasource' page (in CF 4.0.1 anyway), under 'Login Info' there's form field where you can fill in the database. One other thing that tripped me up rec

Re: encrypting password

2003-04-02 Thread Jim McAtee
One small disadvantage, depending on your application (and your user base): If you want to implement an "I forgot my password" page and email the _current_ password to the user, you can't do it. You've got to generate a new password first and email it out before hashing it into the db. I've seen

Re: encrypting password

2003-04-02 Thread Jim McAtee
Tony Schreiber wrote: > I want to be sure that I never, ever, ever, send a user's password to them > in clear text email. This is important because as many websites as people > log into they do not always a different password to each one. Their > password on my site could be the same as their pass

Re: How can I "ORDER BY RANDOM" ?

2003-04-03 Thread Jim McAtee
Tom, In Access, something like the following works for us, where 'PrimaryKey' is a unique key in the table: SELECT * FROM CompanyTbl WHERE CompanyWantsMiniSite = 'Yes' AND MakeMiniSitePublic = 'Yes' ORDER BY ClassOfService, rnd(PrimaryKey) If you're not seeing the expected number of records, I'd

Run CF Studio 4 and 4.5 on same machine?

2003-04-04 Thread Jim McAtee
I've been running CF Studio 4 for just about forever. I recall trying 4.5 quite a while ago and not particularly liking it, but I'd like to try it out again. Can I run both on the same machine, so that I could uninstall one or the other if I choose? It would be easier than installing, uninstalli

Re: Time Format Question

2003-04-04 Thread Jim McAtee
I've seen similar things implemented elsewhere. It should begin with a default and have a very brief explanation, or else a help link. Sure, the user can screw up the look of the output, but so long as you control it to the point of not allowing them to create errors when the code executes, it sh

(Photo) Gallery for Cold Fusion?

2003-04-05 Thread Jim McAtee
Is there anything similar to the PHP open source project "Gallery" available for Cold Fusion? I've been playing with some php open source projects such as Post Nuke, phpBB2 and Gallery for the past week and they are some impressive pieces of work. The Gallery project on SourceForge can be found a

Re: (Photo) Gallery for Cold Fusion?

2003-04-05 Thread Jim McAtee
e custom tag for creating image thumbnails > automatically? > > > Cheers, > Michael Kear > Windsor, NSW, Australia > AFP Webworks. > > > > > > -Original Message- > From: Jim McAtee [mailto:[EMAIL PROTECTED] > Sent: Sunday, 6 April 2003 12:

Stepping through months

2003-06-10 Thread Jim McAtee
Say you have a begin date and an end date. For instance 7/12/03 and 2/23/04. I want to create calendars for each month in the date range, so I want to construct a loop to step through each month in the date range. From July 2003 through February 2004 in the above example it should iterate 8 time

Web-based telnet client?

2003-06-17 Thread Jim McAtee
Has anyone here implemented or heard of a telnet client written in CF (v5 or earlier)? I've got some telnet controlled devices that I'd like to create a web-based interface for. I'm thinking of perhaps emulating a telnet client, with text screen output and throw in a few buttons and controls for

Re: Web-based telnet client?

2003-06-17 Thread Jim McAtee
e's more info on it: > http://javassh.org/wiki-view?oid=408180808080808080808080808084neotis > > -Original Message- > From: Jim McAtee [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 17, 2003 10:04 AM > To: CF-Talk > Subject: Web-based telnet client? > > > Has any

Re: CF and MySQL

2003-06-18 Thread Jim McAtee
Has anyone made the necessary mods to the CF5 Administrator that they'd care to share? We're thinking of using MySQL and MyODBC for some new projects and it would certainly be handy if we could create/edit the ODBC DSNs from the CF Administrator. Thanks, Jim - Original Message - From: "

Re: CF and MySQL

2003-06-18 Thread Jim McAtee
gt; --- > > > -- Original Message -- > From: "Jim McAtee" <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > Date: Wed, 18 Jun 2003 16:49:05 -0600 > > >Has anyone made the necessary mods to the CF5

Parsing a text file with blank lines intact

2003-06-18 Thread Jim McAtee
I need to read in and parse text files with cr, lf, or cf/lf delimiting the lines. I could use CF's list processing except that I must be able to see blank lines, which the following will skip over: #theline# Thanks, Jim

Re: CF and MySQL

2003-06-19 Thread Jim McAtee
Jochem van Dieten wrote: > > I've got developers that I give admin access to CF for creating DSNs and > > scheduled tasks, as well as viewing CF's logs. But they don't have the ability > > to use Terminal Services into the machine to get to the control panel. > > It is just a bunch of registry ke

Re: Database Availability

2003-06-24 Thread Jim McAtee
Assuming you're using an ODBC datasource... How about an external application this is constantly checking the availability of the databases in question, and modifies the ODBC DSN to point at a working one? - Original Message - From: "admin" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTE

Re: WAY OT - Setting Mail Server to block relaying

2003-06-25 Thread Jim McAtee
- Original Message - From: "Rafael Alan Bleiweiss" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, June 25, 2003 5:20 PM Subject: WAY OT - Setting Mail Server to block relaying > If anyone can point me in a direction or to a mailing list on topic, I > would greatly

Re: WAY OT - Setting Mail Server to block relaying

2003-06-25 Thread Jim McAtee
Michael Dinowitz wrote: > Post.Office is officially abandonware and is close to impossible to secure. I > highly suggest getting a different mail server. Any mail server will do at this > point as long as it allows for security. I'd be amazed if it can't be locked down to deny unwanted relaying.

CF Email Parsing Tag/Function

2003-06-26 Thread Jim McAtee
Has anyone got a CF tag or function that can take a raw email message (including all headers and potentially multiple attachments) and parse it into standard headers (To, From, CC, Subject, Reply-To), plus body, plus peal off the attached files? Ideally, able to function with HTML formatted messag

Re: Windows Update

2003-06-29 Thread Jim McAtee
[EMAIL PROTECTED] wrote: > I'm not too sure how many people out there know about this problem but I > just experienced it for the first time and had never heard of it before. > Hopefully this will save someone else the frustration I just went though: > > I was setting up a new server today with W

  1   2   3   4   5   6   7   8   9   10   >