Re: Writing to text file

2001-12-11 Thread Bill King
I thought CFFILE had an APPEND type. - BILL - - Original Message - From: BILLY CRAVENS [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 11, 2001 12:50 PM Subject: Re: Writing to text file add a line break using #chr(10)#: output=CFOUTPUT

RE: alternatives to MS SQL

2001-12-06 Thread Bill King
In my experience it is best to try to stick with some main-stream options. In order to give your client the best service and room for expansion it would (in my opinion) be best to start with something like Access 2000 and upsize to MS SQL when the budget allows. We have supported very high

Re: form fields

2001-12-04 Thread Bill King
Not sure what you are needing to do with this data, but you could put it into a WDDX packet to store in the database like this: cfwddx input=#form# output=wddx_formfields type=cfml2wddx then just put it into a blob field in your database with a field like customer to key off of. Just some

Re: Why aren't there more CF programmers out there?

2001-11-27 Thread Bill King
If ColdFusion was so easy Why... Front Page is not an application development platform. There are several simple tags that will allow you to do anything your boss wants to do on the web. You may just have to educate him/her on the virtues of CFQUERY/CFOUTPUT/CFMAIL. These tags are so simple

RE: cf4.0 structures

2001-11-19 Thread Bill King
YES you can loop over the collection in 4.0. - BILL - -Original Message- From: Joseph Thompson [mailto:[EMAIL PROTECTED]] Sent: Monday, November 19, 2001 10:16 AM To: CF-Talk Subject: cf4.0 structures Thinking I was helping a guy out I re-did a page for him using structures BUT There

RE: Studio/FB question

2001-11-19 Thread Bill King
I agree, I often wish I could do that. - BILL - -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Monday, November 19, 2001 9:59 AM To: CF-Talk Subject: RE: Studio/FB question it would be really nice if you could right click on a cfml template in the file

RE: Session and Client Variables

2001-11-15 Thread Bill King
ALSO: Client variables are the only way to go when you are in a clustered environment. Client variables are stored in a central database and can be accessed from multiple machines, while a session variable would be lost if a shared server architecture controls the user traffic on multiple

RE: CFX_HTTP

2001-10-31 Thread Bill King
Hey Aidan: For the rest of us...where did you get it? - BILL - -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 31, 2001 8:42 AM To: CF-Talk Subject: RE: CFX_HTTP Got one now... thanks. -- Aidan Whitehall [EMAIL PROTECTED] Macromedia

RE: User Login

2001-10-26 Thread Bill King
Personally, I learned by creating an application to design and build a bookstore online. If you could find a hobby or other fun site (family tree) to work on I think you will learn quickly. Having the books on hand is great, but staying up all night and watching your code work is the best way

Re: Access Question

2001-10-24 Thread Bill King
USE #CreateODBCDate(attributes.datebox)# - Original Message - From: Bryan Love [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, October 22, 2001 4:40 PM Subject: RE: Access Question It's doing the math. It thinks 10/18/2001 is 10 divided by 18 divided by 2001. Use

Slow File Uploads For Netscape/Mac user

2001-10-23 Thread Bill King
Hello all, Has anyone experienced the following problem: While using the Mac a user of ours has experienced significantly increased file upload times as compared to their uploading of similar files on a pc. If anyone has found a resolution or other info about this please respond. - Bill -

RE: Simple Verity Database Search

2001-09-12 Thread Bill King
Hello Angel. I have had a lot of -fun- with verity as well. I usually resort to creating a new collection using the administrator and run the CFINDEX again (on the new collection.) Then it will usually work. Sorry so technical :) (sarcasm is my forte') - BILL - -Original Message-

IIS Session information

2001-09-04 Thread Bill King
ideas or tools if you know of any thing good. (I am using url vars for section and page IDs.) Signed, Bill King ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http

RE: Alternating BG colors on a TD

2001-08-21 Thread Bill King
I don't know about performance but this method is easiest to create, remember, and maintain: cfoutput query=queryname cfif currentrow MOD 2 cfset bgcolor=ff cfelse cfset bgcolor=ee /cfif td bgcolor=###bgcolor#

RE: Cf in Select Stmt help

2001-08-21 Thread Bill King
Sounds like a LEFT Join is in order. - BILL - -Original Message- From: Amanda Stern [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 21, 2001 1:16 PM To: CF-Talk Subject: Cf in Select Stmt help Hello, I am trying to get this query to work and not sure how...anyone have any ideas?

RE: selecting top n records

2001-07-31 Thread Bill King
First thought would be something like: SELECT TOP 10 COUNT(PRODUCTID) AS COUNTER, PRODUCTID FROMORDERDETAIL GROUP BYPRODUCTID ORDER BYCOUNTER DESC There may be something faster, but this works... - BILL - -Original Message- From: Mark Warrick

RE: Verity and META tags...

2001-07-06 Thread Bill King
What would be cool would be a CFHTTP call to the page in question and then parse out _only_ the META data and write a record to a database table. This would allow much more control, you could forget verity and do a full text serach, you could also come up with a dynamic keyword list...etc,etc,

RE: CF-Talk-list V1 #38

2001-06-27 Thread Bill King
Yeah same here. Unlikely that it is due to slow down in activity. I wonder what is up. - Bill King - -Original Message- From: Cameron [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 21, 2001 2:56 PM To: CF-Talk Subject: Re: CF-Talk-list V1 #38 Hmmm, is something up with the list

Re: Database Design Help

2001-06-11 Thread Bill King
Cody, I think you should still design the system so that it can have more than three levels. Your site structure is very common in sites I have been working with and most stay within those three levels, but sometimes there can be a small change that the client wants that messes everything and

RE: SELECT

2001-06-05 Thread Bill King
I am not sure if I understand 100% but you will not be able to submit a query to the database on the same form as a select box. There are two ways, though, that you can handle what (I believe) you are trying to attempt: 1. On change of the select form you can simply re-load the same form with

RE: Brain isn't working yet...

2001-06-01 Thread Bill King
I use: cfif cgi.remote_addr contains '192.168.5.' Allow action /cfif Quite a bit easier I think. - BILL - -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED]] Sent: Friday, June 01, 2001 10:00 AM To: CF-Talk Subject: Re: Brain isn't working yet... or the

RE: Compromising Security

2001-05-22 Thread Bill King
A big one: If the users can get this information. They may be able to send CFTAGS in your form fields and cause trouble. Be sure to validate all form entries to abort any cftags being sent into form fields. Signed, Bill King HostWorks INC http://www.hostworks.com -Original Message

RE: CFTRANSACTION

2001-05-18 Thread Bill King
of the problems we've had with this tag stem from misuse as opposed to reliability of the tag. Are there problems with this tag that I am not familiar with Brian - Original Message - From: Bill King [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 17, 2001 11:47 AM Subject: RE

RE: CFTRANSACTION

2001-05-17 Thread Bill King
Speaking of purpose-free the CFTRANSACTION is not even reliable for multiple queries. I had a problem with users on a high-volume site having OrderIDs duplicated and caused major problems. I fixed it by getting the ID within my order query with that lovely SET NO COUNT option in SQL 7. I

RE: CFSToredProcedures

2001-05-17 Thread Bill King
Try this: cfquery name=qSearchProc CACHEWITHIN=blah datasourse=#request.datasource# exec spSearchStoredProc #value1#, #value2# /cfquery Signed, Bill King HostWorks INC http://www.hostworks.com -Original Message- From: Darren Nickerson [mailto:[EMAIL PROTECTED]] Sent

Re: Forced logout

2001-05-14 Thread Bill King
I bet you could spawn a new window that calls template to log them out and closes onload. - BILL - - Original Message - From: Jim McAtee [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, May 13, 2001 3:48 PM Subject: Re: Forced logout You can't. Well, maybe you could be

Re: SQL 2000 Database List.

2001-05-14 Thread Bill King
this would save me about 15 minute a day. (significant enough) Signed, Bill King Developer HostWorks, Inc. - Original Message - From: Neil H. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 14, 2001 2:59 PM Subject: SQL 2000 Database List. Just trying to get a feel

Re: cookie form url -less sessions

2001-05-14 Thread Bill King
. Signed, Bill King Developer HostWorks, Inc. - Original Message - From: Christopher Porter [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 14, 2001 10:17 AM Subject: cookie form url -less sessions hey hey everyone.. here's a dilemma for you. i've been task

Re: [Session Variables - I don't get it]

2001-05-14 Thread Bill King
It appears that you are spitting out the variable before you change it to blue. - Bill - - Original Message - From: Alex [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 11, 2001 7:47 AM Subject: Re: [Session Variables - I don't get it] because you are setting it to

RE: Array String Concatenation

2001-05-09 Thread Bill King
; /cfscript Then you can spit out your clickable link as follows: A HREF=TeamPlayers.cfm?TeamID=#Standings[1][TeamID]##Standings[1][TeamName]# /A Hope this helps. Signed, Bill King HostWorks INC http://www.hostworks.com -Original Message- From: Jeffrey R. Thomas [mailto:[EMAIL PROTECTED

OT: Automatic File synchronization between clustered servers.

2001-05-08 Thread Bill King
have been looking for something that will do an automatic file compare and copy to maintain uniformity between two directories. Has anyone run into this and found a solution?? Signed, Bill King HostWorks INC http://www.hostworks.com ~~ Structure your

RE: Automatic File synchronization between clustered servers.

2001-05-08 Thread Bill King
the content duplication to occur over this new link. If you are talking *nix I dont have a clue... jon - Original Message - From: Bill King [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 08, 2001 12:09 PM Subject: OT: Automatic File synchronization between clustered servers. I

RE: Limit on SQL passed via CFQuery to SQL Server?

2001-05-08 Thread Bill King
It seems to me that there is a database setting (long text buffer size) that only allows 65,000 characters by default... In CF 4.5+ you can adjust this setting...do a character count of your insert in the database and I'll bet it is 65,000 characters. Let me know (if anyone knows) what this

RE: Automatic File synchronization between clustered servers.

2001-05-08 Thread Bill King
the content duplication to occur over this new link. If you are talking *nix I dont have a clue... jon - Original Message - From: Bill King [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 08, 2001 12:09 PM Subject: OT: Automatic File synchronization between clustered servers