RE: Fusebox pros and cons

2002-03-14 Thread Bill Killillay
As does everyone, I'd guess. I prefer using stored procedures for that. Once you place your database access logic in the database itself, there's little to be gained from saving a three-line CF file in a separate location. Unless you have to make changes to that stored procedure and now you

RE: simple cfloop

2002-03-05 Thread Bill Killillay
try this for your query select, this, that, theotherthing from tblName where id IN (#form.ids#) -Original Message- From: Sorgatz, Rex [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 03, 2002 8:33 PM To: CF-Talk Subject: simple cfloop Beginner CFer with an easy question. The situation:

RE: cfscript vs markup...

2002-02-06 Thread Bill Killillay
Hey Michael, what do you mean by dataset? In experimenting with the cfscript code it seems that the count break statement like I use in regular cf markup is getting ignored. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 05, 2002 11:07 AM

cfscript vs markup...

2002-02-05 Thread Bill Killillay
Hello list, I have two pieces of code and I can't figure out why one works and the other does not. The regular markup works perfect, so I thought I would move it to CFSCRIPT, which is normally not a problem, but on barely 3 hours of sleep it's one today... anyway here they both are followed by

RE: CF and Hit Counter

2002-01-30 Thread Bill Killillay
The only problem is that companies like home.com and aol.com use roving IP's so the same visitor could trigger several counts if they stay on your site long enough. -Original Message- From: Steve Oliver [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 27, 2002 8:40 PM To: CF-Talk

RE: cf sites go poof

2002-01-22 Thread Bill Killillay
They all come up fine for me... -Original Message- From: Lewis Sellers [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 6:23 PM To: CF-Talk Subject: Re: cf sites go poof On Mon, 21 Jan 2002 17:24:51 -0500, Jon Hall [EMAIL PROTECTED] wrote: Well, obviously your ISP was having

RE: Does anyone see a problem with this query?

2001-12-13 Thread Bill Killillay
Old: SELECT topc.id, topc.topics, subt.id, subt.topic_id, subt.s_topics FROM topics AS topc INNER JOIN sub_topics AS subt ON topc.id =

CF / JS question

2001-12-03 Thread Bill Killillay
Ok let me setup what I am trying to do here: I have been testing/playing with this and almost have it, but yet I am a million miles away too. If I do: script language=JavaScript src=library/validatesearch.js/script like normal all works fine. I can rename the .js file to .txt and then make the

RE: word wrap in text area

2001-11-29 Thread Bill Killillay
You need to do a replace on #chr(10)##chr(13)# and turn them in to br that will give you the breaks your looking for. I can send some sample code if this is not enough to get you going in the right direction. -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent:

Studio/FB question

2001-11-19 Thread Bill Killillay
I use Fusebox for just about everything and I often find myself reusing a qry, or act files, etc. I was wondering if there was a way to change ColdFusion Studio so that when you drag a file out to a page like fbx_switch that instead of it creating a hyperlink it creates a cfinclude? Can this be

RE: Fusebox - opinions?

2001-11-19 Thread Bill Killillay
I use fusebox and have for some time. Once you dive in and really start understanding it you will see what all the hype is about. Fusebox 3 is even better and makes code much more reusable at an application level much more so then Fusebox 2 was. Also once you get the hang of it you can code up

Strange error in CF 5

2001-10-30 Thread Bill Killillay
-2147417848 (0x80010108) Of late I have started getting that on one or two sites. Never at the same time, only one site, but it takes a reboot to clear it. Any ideas what's causing it and how to fix it? Thanks, Bill K. ~~ Your ad could be here.

RE: Subdomain of a domain

2001-10-29 Thread Bill Killillay
My question is, do these people have two IP's associated with this domain or is this an entry in DNS that I am missing somewhere on how to set up? You can do it either way, with or with out two IP's, but the easiest way is to just create a DNS record that points to the same IP address, and

RE: DNS Question

2001-09-04 Thread Bill Killillay
What server are you using? It's a combo of DNS and Webserver settings. -Original Message- From: ChristianWatt [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 1:52 PM To: CF-Talk Subject: DNS Question A little off topic, but can anyone please tell me how in the world you

Changing the name of a file...

2001-08-28 Thread Bill Killillay
I am using CFContent to grab a file and serve it up to the end user which works great, except that if I go after a file called setup.exe for example and serve it to the user when they choose to save it to their system it tries to save it as index.cfm in this case or what ever file name I happen

RE: Changing the name of a file...

2001-08-28 Thread Bill Killillay
- From: Bill Killillay [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 28, 2001 3:45 PM To: CF-Talk Subject: Changing the name of a file... I am using CFContent to grab a file and serve it up to the end user which works great, except that if I go after a file called setup.exe for example

RE: dynamic populate select box question

2001-08-16 Thread Bill Killillay
Try something like this Can I somehow get the selected option value to not show up in the second query? cfoutput query=GetRecord select name=guidepicture option value=#guidepicture# selected#guidepicture#/option /CFOUTPUT cfoutput

RE: Session vs. Cookies

2001-08-15 Thread Bill Killillay
If your going to be doing a site that has a lot of load you need to look at either Client vars, or cookies. If it's going to be scaling and going into a clustered environment you can't use session var's and have them stick. In that case you will need to use Client var's and a DB. I personally

RE: cftransaction

2001-08-14 Thread Bill Killillay
Depends on what that query is doing, if it's inserting, or updating, yes, if it's just doing a select no. That's my understanding on the matter. -Original Message- From: John Barleycorn [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 14, 2001 12:51 PM To: CF-Talk Subject: cftransaction

RE: Hacking CF Web Sites and Applications

2001-08-13 Thread Bill Killillay
In your select statement if you wrapped you where whatever = 23 in single quotes, or in a val() statement either of those would keep that from happening. Which is a good thing. -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Monday, August 13, 2001 9:02 AM To:

Our very own Dave Watts in Print

2001-08-13 Thread Bill Killillay
Check it out... http://webtechniques.com/archives/2001/09/infrrevu/ ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives:

RE: CFIF Confusion

2001-07-30 Thread Bill Killillay
down below is Boolean comparisons. Hope that makes sense, please let me know if you need me to explain more. -Bill Killillay -Original Message- From: Ken Monroe [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 10:07 AM To: CF-Talk Subject: CFIF Confusion Hello! I'm working

RE: COUNT(*)

2001-07-18 Thread Bill Killillay
Count(fileId) will be faster, but don't take my word for it, run the query in Query Analyzer and check it out. The count(*) has to first figure out what columns it needs to count on, then do the count, the count(fileId) your telling it which one to count on and it saves time, which on a large

RE: Whitespace

2001-07-09 Thread Bill Killillay
Being and interpreted language it will return it basically how it parses it. If it where a compiled language, i.e. Java, etc you would not see the spaces, or at least not as prevalent, there are also some settings in the CF Server Admin that allow you to strip down some of the white space. It

RE: Correctly using CFOUTPUT

2001-05-31 Thread Bill Killillay
Since when is CFLOOP faster then CFOUTPUT? I have seen on this list many, many times that CFLOOP is one of the slowest tags in CF... I see your point about not wanting to execute more code then is needed, but a lot of it depends on what your doing. But in a show down between CFOUTPUT and

RE: File/Image Security

2001-03-17 Thread Bill Killillay
To get around the direct linking problem us a CFCONTENT approach, then build your links dynamically to pull your content. That way should somebody try and you have error checking built it would check the URL realize that they don't have what ever is needed and bounce the user back to where ever

RE: loop and # sign as a part of form object

2001-01-28 Thread Bill Killillay
cfloop index="x" from=1 to=10 cfoutput#form.qty##x#/cfoutput /cfloop Try that. -Original Message- From: Roozbeh Hashemiha [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 28, 2001 9:53 PM To: CF-Talk Subject: loop and # sign as a part of form object Basic problem ...

RE: How to Convert currency to numeric value

2001-01-21 Thread Bill Killillay
Take a look at the replace functions, then on your incoming string do a search and replace on the common things like $ and . and replace them with "" that will leave you with just raw numbers and you can then number format them later on output. So look at replace() functions and numberformat()

RE: Running a MS SQL Server DTS Package from ColdFusion

2001-01-16 Thread Bill Killillay
This link does not work. What can a person search on to get there? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 16, 2001 6:25 PM To: CF-Talk Subject: Re: Running a MS SQL Server DTS Package from ColdFusion See my detailed howto

RE: HTMl:Border Around Tables

2000-12-15 Thread Bill Killillay
Norman, here is some code that I put into a file and then name it what ever the color of box that I want around the item that I want boxed. This one is called redbox.cfm for example. to use it I just call cf_redbox where I want my box to begin and then I put /cf_redbox where I want my box to

AOL and Session Var's

2000-12-01 Thread Bill Killillay
Hey Gang, A friend of mine just asked me to post this question. Would anybody know why, only on AOL 5 a site would be "loosing" it's session var's. They use a session var to track when a user logs in. On AOL 4 and AOL 6 they tell me that it works just fine. IE, Netscape, and even both Mac

RE: ? - /

2000-11-29 Thread Bill Killillay
Michel Take a good long look at Fusebox. We have some tags that we use with fusebox that just EXACTLY what you want, and in my opinion Fusebox is a great way to develop as well. IT does allow good reuse of code if done correctly. It is not the holy grail, but it's gaining speed every day and

RE: WHOIS tag?

2000-11-25 Thread Bill Killillay
Do a search on WHOIS at the Allaire developer center. There are 4 or 5 of them up there. -Original Message- From: Adrian Cooper [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 25, 2000 9:37 AM To: CF-Talk Subject: WHOIS tag? Can anyone tell me where I can find a WHOIS tag

RE: Structures: Where is data kept

2000-11-25 Thread Bill Killillay
Session variables are stored in client side cookies and/or server memory. They DO NOT get stored in the registry. The variables that get stored in the registry are Client variables. There is a BIG difference in the two. For example you cant story a structure in a Client variable with out

RE: Structures: Where is data kept

2000-11-25 Thread Bill Killillay
Then how would the persist across the reboots? -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 25, 2000 1:34 PM To: CF-Talk Cc: '[EMAIL PROTECTED]' Subject: RE: Structures: Where is data kept Session variables are stored in client side

RE: Deleting Session Variables

2000-11-19 Thread Bill Killillay
Scott, Here is the method that I use. Hope it helps some. cfset sessionvars = "" cfloop collection="#session#" item=key cfset sessionvars = listappend(sessionvars, key) /cfloop cfloop list="sessionvars" index="deletekey" delimiters="," cfset StructDelete(session,"#deletekey#")

RE: Deleting Session Variables

2000-11-19 Thread Bill Killillay
Rob, Seems to me that if you do it this way, your not only expiring the session var's for the intended user, but also for everybody else using that "application" at that time. Just expire the session in Application.cfm: cfif isdefined("logout") cfapplication name="myapp"

RE: Back Button on Dynamic pages

2000-11-15 Thread Bill Killillay
Is the page in SSL mode when you submit it? If so you will need to use a back button like a form button and pass the info back via hidden form fields or through the URL or something like that and repopulate the page via that type of thing. Bill -Original Message- From: Nathan Focht

RE: fusebox

2000-11-10 Thread Bill Killillay
LOL What is it that Forta says... CF is not the answer for everything... something like that. Have you taken a gander at CFObjects? What is your take on that framework? Yikes! That's even worse. When I want to do OO programming, I'll use Java, not CF. Dave Watts, CTO, Fig Leaf

RE: Null Values

2000-11-08 Thread Bill Killillay
Think about it, if I pass a value of " " that is not a null value. That is a value that has a space in it. By checking it to see if it has length first, then trimming any leading and trailing spaces off of it your checking to make sure that it truly is a null value and not a blank space. Try

Default Error page look...

2000-11-08 Thread Bill Killillay
When using the method of formfield_required in a hidden form field and then passing that on if that form field is not filled in it gives a default error page saying these required fields are not filled in please hit back, etc, etc. Anybody know of a way to change the look of that page. This is

RE: fusebox

2000-11-08 Thread Bill Killillay
Lee, Thanks, I was getting ready to do the same thing. I wish people would try Fusebox before they just bash it. There is a GREAT network of some of the BEST CF developers in the world that are on the Fusebox email list. If you have questions, concerns, or what ever join that list and learn

RE: Login and Clustering

2000-11-07 Thread Bill Killillay
Sandra, I set two client var's one is a client.user_id of some sort, the other is a client.expires, then I run a time difference check on the client.expires if the time is not with in the set time they have expired, I delete both client vars and send them back to the login page. If the

RE: fusebox

2000-11-03 Thread Bill Killillay
Chris, There are a lot of us out there using Fusebox and more everyday. I can only say good things about it. It's great for taking a great product like ColdFusion and making the way that we code it better. There is a small learning curve, but once you get the hang of it, you can really turn

RE: Calling custom tags from within CFSCRIPT?

2000-10-26 Thread Bill Killillay
As of right now I don't believe there is any support for calling Custom tags in a CFSCRIPT block. It's one of the draw backs to using CFSCRIPT. I don't know if Allaire is going to address doing that in one of the upcoming releases or not, but I sure wish that they would add that feature to

RE: Custom Tag w/JS functions

2000-10-26 Thread Bill Killillay
bear in mind that no cfcode within script/script tags will get processed. Sure it will. Example one: Will most likely blow up cfoutput script some JS here.#somevar.foo# /script /cfoutput Example two: Will most likely work just fine cfoutput script some JS

RE: Security Concerns Question regarding Cfquery reguried username and password in sql environment

2000-10-26 Thread Bill Killillay
You really shouldn't make a habit out of storing client vars in the registry either. While it does work, and Cold Fusion DOES NOT crash, it is much better to store the client vars in a database. Cold Fusion may not crash, but the server it's running on will eventually, and that is even

RE: Working with FedEx API?

2000-10-20 Thread Bill Killillay
We have integrated both the shipping rate calc and the tracking into a site that is not yet live and it works great. The custom tag is written, I believe, by Michael Sheldon at Desert Raven, it's pretty good. Did everything we needed it to with no problems. It uses CFHTTP so it's kind of slow

Client Storage

2000-10-17 Thread Bill Killillay
If the default client storage is set to registry and in the application.cfm or application tag you enable client management and then enable setclientcookies to yes, will client info be stored in the cookies, or will it go with the setting in CFAS and store that info in the registry? Bill

RE: What's with all the space?

2000-10-17 Thread Bill Killillay
Take a look at CFENABLEOUTPUTONLY, and there are a bunch of Custom tags on Allaires web site for stripping out the white space also. -Original Message- From: Peter Benoit [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 17, 2000 1:04 PM To: CF-Talk Subject: What's with all the

RE: Running A CF Site Via CD Rom

2000-10-14 Thread Bill Killillay
Very true. Thanks for pointing that out. -Original Message- From: pan [mailto:[EMAIL PROTECTED]] Sent: Saturday, October 14, 2000 10:14 PM To: CF-Talk Subject: Re: Running A CF Site Via CD Rom From: "Bill Killillay" [EMAIL PROTECTED] In last months CFDJ or the mo

CFFTP - - weird error

2000-10-14 Thread Bill Killillay
Here is the code !--- Login --- CFFTP CONNECTION="myserver" USERNAME="username" PASSWORD="password" SERVER="ftp.myserver.com" ACTION="Open" STOPONERROR="Yes" port="21" PDid login succeed? CFOUTPUT#CFFTP.Succeeded#/CFOUTPUT !--- Change dir first

RE: Access Clarification...

2000-10-13 Thread Bill Killillay
If and when CF gets to requests like you suggest below it will queue one and process which ever one got there first. Think about it like a printer with a print queue On a large network the persons print job that reaches the queue first prints, but the other jobs are not lost. Same thing with

RE: Access Clarification...

2000-10-13 Thread Bill Killillay
AM To: CF-Talk Subject: Re: Access Clarification... Seems like it...I wasn't aware of that feature though...learn something new everyday. - Original Message - From: "Bill Killillay" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, October 13, 2

RE: Wierd CFLOCATION error

2000-10-13 Thread Bill Killillay
Sure ya can, the cookie just won't be set *grin* You cannot use cfcookie in the same template as cflocation .. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit

RE: Using MS Access with Cold Fusion (no no)

2000-10-12 Thread Bill Killillay
HUH??? Ok there is something to be said for SQL or Oracle servers, but I can speak from experience when I say that if the CF code is tight that Access can be used just fine for some pretty busy sites. I did a site that does a million plus users a month and it's all powered by two Access

RE: Using MS Access with Cold Fusion (no no)

2000-10-12 Thread Bill Killillay
There is a box in the Cold Fusion server admin that you can set to 1 connection at a time and it will only allow ONE user at a time to hit the database. Then you can let CF worry about not hitting the database with more then one user at a time. Check the Data Source setup area and then look for

RE: Anyone know how to stay awake after overnighters??

2000-10-10 Thread Bill Killillay
http://www.thinkgeek.com/stuff/caffeine.html or GO HOME! SLEEP After a very long night we got a product out the door? Now another work day. Anyone have any pointers -- Archives:

RE: Death to .ldb !!!

2000-10-05 Thread Bill Killillay
That .ldb file is created when Access is running, if your not running it then CF Server may have it open. There is a check box in the CF Server Admin that when unchecked will not maintain a connection to that db. If you uncheck that and you don't have Access running you should be able to do it

Stored Procedures??

2000-10-03 Thread Bill Killillay
Can anybody see what I am doing wrong here? I am not getting any errors, but it's not updating either. On the SQL server I have the permissions execute box checked for the dbo user (the only user in there). This same exact task works just fine if I use a standard CFQUERY instead of the method

RE: Stored Procedures??

2000-10-03 Thread Bill Killillay
uot; CF is not happy with nvarchar and ntext. Jeff Craig - Original Message - From: "Bill Killillay" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, October 03, 2000 7:46 PM Subject: Stored Procedures?? Can anybody see what I am doing wrong here?

RE: query caching?

2000-10-02 Thread Bill Killillay
Well, er, yes. That's what I mean by a cached query. In there another way to cache a query? Well you could scope it into a session, or application scope and then wrap your query in an isdefined statement, and then you could control when that query is refreshed a little better. At 08:09 AM

RE: ASP or Coldfusion?

2000-09-22 Thread Bill Killillay
A large site is a few thousand hits a week??? What is a few thousand an hour then? -Original Message- From: Peter Theobald [mailto:[EMAIL PROTECTED]] Sent: Friday, September 22, 2000 11:08 AM To: CF-Talk Subject: Re: ASP or Coldfusion? This is flame-bait if I ever saw it. I

RE: Reason for Alliare Stocks

2000-09-22 Thread Bill Killillay
Bill you and I must be talking to the EXACT same sales guy. I have been through this several times. Then they give you the guilt trip about not buying this or that and that their supervisor will be upset. Well. I don't care. Treat me right and maybe when the time comes I will buy it, but

RE: CF hangs

2000-08-30 Thread Bill Killillay
Can you try changing from ODBC to OLE DB? I have heard that it might make things a little more stable. We used that method on one site and we are not having any problems with it like what your describing below. There was an article about it in the July issue of the CFDJ. Just a thought. Bill

RE: IsDefined help

2000-08-29 Thread Bill Killillay
If the first one is in your action page it should work fine. if you have a form element named foo in page one and you hit submit to page 2 (action page) you test should work just fine. form.name needs to be the name of the form field your passing. example cfif isdefined("form.foo")do

RE: AuthentiX CF cookies

2000-08-22 Thread Bill Killillay
Because this is a COLD FUSION list, we talk about ways to do things with ColdFusion here. NOt to knock CF but why not use ASP all around?? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To

RE: ie 5.5 and history.back

2000-08-22 Thread Bill Killillay
Try this onClick="history.back(-1) -Original Message- From: jamesa {James Alexander} [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 22, 2000 4:59 PM To: Cftalk (E-mail) Subject: ie 5.5 and history.back I haven't seen any discussion of this: form input

RE: dynamically serving images

2000-08-21 Thread Bill Killillay
Here is how I do it !--- First check for a count in a special dir and return it as a record count --- CFIF NOT IsDefined("Session.RandNum") CFSET PATH = ExpandPath("images\life_care_rand") CFDIRECTORY ACTION="LIST" DIRECTORY="#PATH#" NAME="rand_dir" CFSET Session.RandNum =

RE: good way to login/track users?

2000-08-16 Thread Bill Killillay
One way is to check for the existence of a client or session variable. For example, when the user logs in you set a client or user variable, and the value of that variable is that users ID or unique key value from the database. Then anywhere else you need that information you can just run a

COM Objects?

2000-08-10 Thread Bill Killillay
How does one go about calling a com object from ColdFusion? Bill -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit

RE: COM Objects?

2000-08-10 Thread Bill Killillay
Never mind, I figured it out. Pretty slick stuff actually. Thanks again Ben Forta and his books. -Original Message- From: Bill Killillay [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 10, 2000 11:29 AM To: Cf-Talk Subject: COM Objects? How does one go about calling a com

RE: CFX Wizard and header files

2000-08-10 Thread Bill Killillay
Ditto! Thanks Bill -Original Message- From: Jeremy Allen [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 10, 2000 2:17 PM To: [EMAIL PROTECTED] Subject: RE: CFX Wizard and header files :-) Could you mail those to me as well.. Please :) Jeremy Allen [EMAIL PROTECTED]

CFOBJECT

2000-08-09 Thread Bill Killillay
I am getting ready to do a new project where we are going to be needing to call an Active X object and then using the ADODB.Recordset that it returns. I have never done this before, but I am assuming that it can be done. Can anybody give me an pointers or places to go and read up on it. Thanks.

RE: How to check a password is only alpha characters?

2000-08-08 Thread Bill Killillay
And if the user turns off JavaScript, what then? -Original Message- From: Deanna L. Schneider [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 9:23 AM To: [EMAIL PROTECTED] Subject: Re: How to check a password is only alpha characters? Michael, There's a nifty custom

Access to SQL

2000-07-31 Thread Bill Killillay
Hello fellow CF'ers We have upsized several of our Access databases to SQL 7 and they work great. While we are building the forms to update the database directly does anybody see any problems with running our updates from the Access to the SQL via standard SQL statements. For the time that's

RAM Costs (was: $1,000 servers (was: High-Powered Scaling))

2000-07-28 Thread Bill Killillay
I know that, my question was to somebody that was saying they where getting 512 for around $200. I don't care who's memory it is, if they are getting that amount for that money, I want some. I can put it in any machine with in reason at that point. That is just the best price that I have heard

RE: $1,000 servers (was: High-Powered Scaling)

2000-07-27 Thread Bill Killillay
Where are you buying your Ram at? -Original Message- From: Steve Pierce [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 27, 2000 1:24 PM To: [EMAIL PROTECTED] Subject: RE: $1,000 servers (was: High-Powered Scaling) We pay less than $200 per 256MB of RAM. It is pretty easy to

RE: Another newbie w/a database query questiomn

2000-07-27 Thread Bill Killillay
Oriole, First of all you don't need the CFOUTPUT's around your cfset and your cfcookie. Secondly, your error is coming from that fact that your Database requires you to login to it and your not supplying a User ID and Password in your CFQUERY, at least that's the way the error reads. Thirdly

RE: CFMAIL and recordsets

2000-07-18 Thread Bill Killillay
Wait, the body has variables that are coming from a form - not a query? There's your problem. You can't reference both a query and a form in the cfmail tag. I've done workarounds where you create local variables instead. Sure you can if you fully qualify the scope of the variable. Example

RE: searching for key words using cf

2000-07-15 Thread Bill Killillay
Claude, In your sql statement you just need to do it something like so: Select Hotel, City, Phone From YourDatabase Where Hotel Like '%search_string%' Order By Hotel That where statement is the key, it would return anything with the word Hotel in it. You can set it up to search anything. Let

RE: Increase timeout from FORM

2000-07-11 Thread Bill Killillay
I do this on some forms that I was getting error messages on before. Once I added the time out, I stopped getting the problems. I don't notice any difference between Netscape or IE in the way that they handle a form action with a requesttimeout in it. Just my .02 Bill -Original

RE: Using Select Tags in optional Form Submissions

2000-07-06 Thread Bill Killillay
Gel, Any time a form is submitted it sends all of the form elements to the next page or script. What I have done in the past is set a bogus value for a Please Select statement in the first option of my select. That way if they leave it alone and just choose to enter an ID the only real data

OT: JavaScript Tree

2000-06-27 Thread Bill Killillay
Hey, I found this on Allaire's web site and I have been poking around in CF Studio and I can't seem to find it. "Note: HomeSite and ColdFusion Studio users can add the JavaScript Tree to one of their toolbars -- the tree provides a dropdown view of the built-in object hierarchy with object

RE: Cheap, reliable ColdFusion ISP Host??

2000-06-26 Thread Bill Killillay
If there is not one, I would be willing to put one up. I don't want to do it unless there is not one though. Does Allaire have a good one? Can you enter feed back, or is only for their partners? Any ideas where to look for one? TIA! -Original Message- From: Chris Montgomery

RE: Numberformat

2000-06-26 Thread Bill Killillay
Take a look at the RJustify tag. It will do what you want it to. If you need some code samples please let me know. Bill -Original Message- From: LM [mailto:[EMAIL PROTECTED]] Sent: Monday, June 26, 2000 1:22 PM To: [EMAIL PROTECTED] Subject: Numberformat I need help with the

RE: Nesting cfswitch possible?

2000-06-21 Thread Bill Killillay
Message- From: Bill Killillay [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 11, 2000 1:01 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: Nesting cfswitch possible? Yes! -Original Message- From: Cyrill Vatomsky [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 08, 2000

RE: MS Access 97 vs. 2000

2000-06-17 Thread Bill Killillay
I believe this may be what you need. http://www.microsoft.com/data/download.htm?RLD=377 HTH Bill CF_Warrior -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 15, 2000 5:27 PM To: talk-cf; CF-Talk Subject: MS Access 97 vs. 2000 Hello, I have

RE: Data Entry Form Number Formatting

2000-06-17 Thread Bill Killillay
Tim, That's a change you need to make in your database side. It's in the type of field you have defined in Access. Look at that and play with it. I have no clue when you sent this message as the server is buggy so I am going to stop at that. If you need help email me off list and I will do

RE: Easy way to get a random record

2000-06-11 Thread Bill Killillay
I would first run the query and get the total record count. cfquery name="myQuery" datasource="myData" SELECT ID FROM MyTable /cfquery I would then do a cfset myVar = RandRang(1, myQuery.recordcount) Then I would run another query this time I would use my select as with the myVar from the above

RE: Nesting cfswitch possible?

2000-06-11 Thread Bill Killillay
Yes! -Original Message- From: Cyrill Vatomsky [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 08, 2000 1:06 PM To: Cf-Talk@Houseoffusion. Com Subject: Nesting cfswitch possible? Is it possible to nest cfswitch tags? Cyrill Vatomsky LinguaCom

RE: CFCONTENT... set the filename?

2000-06-11 Thread Bill Killillay
Mike, I don't know if you got an answer to this or not, per David Watts, there are two ways, and they both do work. I can tell you that from experience. The first is just to name the processingFile.cfm what you want the downloaded file name to be. The second is to pass it to it like so. In

RE: Sending an attachment vie email (CF Newbie)

2000-06-07 Thread Bill Killillay
Look at CFFILE for the uploading of the file, then look at CFMAIL for the sending of the file. If you have studio use the help in there and look at both of those tags, CFFILE will let you upload and work with the file, i.e.. rename it or what ever, then CFMAIL will allow you to setup the email

RE: Sum

2000-05-22 Thread Bill Killillay
Yes, if you post some code of what your trying to do, there are many people on this list that can help you out. There are so many different ways that it would really be helpful to see what your doing and then help you with that. It may aid in the learning curve rather then just throwing a bunch

RE: [OT] This Mailing List (WAS [OT] Mail Delay ?)

2000-05-21 Thread Bill Killillay
Jeff, Very well said! I am in 100% agreement with you. My hat is off to you and to Michael and Judith! THANKS FOR A GREAT RESOURCE GUYS! Bill -Original Message- From: Jeff Beer [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 21, 2000 12:33 PM To: [EMAIL PROTECTED] Subject: [OT]

RE: Dynamic Multiple Choice Box

2000-05-16 Thread Bill Killillay
I think that HP uses something of that sort on their driver wizards. They have some select boxes. You make one selection and based on that it gives you another selection box with info and you keep drilling down until you have your printer make and model. All the JS is in the page, I have been

Large CFSwitch or Switch in CFSCRIPT

2000-05-15 Thread Bill Killillay
be great. Please respond off list also as it seems to reach faster then does the list sometimes. Thanks. Bill Killillay ICQ @ 8425781 *~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~* "An investment in Knowledge always pays the best interest." -Benjami

RE: Slightly OT: Lighten things up a little

2000-05-15 Thread Bill Killillay
Could really help on the diet if it was to Lock up on you... for some of us that is =) Get M$ involved, it could be a good thing, America would have there Fridge's locking up and we would all be getting smaller... or CF_Call_For_Pizza would get used a lot more. -Original Message-

RE: (WOT) Writers, Content Creators

2000-05-15 Thread Bill Killillay
Advertising Agencies that do Web Related stuff. They are always needing good copy writers. -Original Message- From: Eric Dawson [mailto:[EMAIL PROTECTED]] Sent: Monday, May 15, 2000 12:21 PM To: [EMAIL PROTECTED] Subject: (WOT) Writers, Content Creators Sorry for the WOT post.

RE: OT: School Days - (was: Lighten things up a little)

2000-05-15 Thread Bill Killillay
Ya, they also should list how many of their staff are veterans, and of those if any of them are disabled in one way or another. The Gov. awards contracts based on points and both of those will score as many or more points then just a degree alone. Through in a degree and a veteran and your

  1   2   >