Re: cfform input w/rollover
cfform does not inhibit a standard submit rollover javascript. Check out Mikodocs tutorial on the subject. http://www.mikodocs.com/tags/forms/index_famsupp_107.html jon - Original Message - From: "Alan Koenig" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 10, 2001 2:58 PM Subject: cfform input w/rollover Is there a way to do a cfform and have the submit button with rollover properties? TIA Alan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Win2K File Associations Not Working
Perhaps someone who has run into this may be able to help you more, but I'll give it a shot... In IIS is the cfm extensions being processed through C:\CFusion\bin\iscf.dll ? I have a hunch something is not right with IIS though...you say this is a fresh install of Win2k? Did you install any patches or remove any extensions? Because +.htr is not working, and the htr extensions are installed with a clean install... jon - Original Message - From: "John McKown" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, April 11, 2001 10:19 AM Subject: Win2K File Associations Not Working I just installed 4.5.1 SP2 on a Fresh install of Win 2K. Under the file associations in IIS 5, the .cfm file extensions are listed, but they are not being served properly as web site files. When I try to get to the administrator: http://204.253.96.198/cfide/administrator/login.cfm You can see for yourself what happens. John McKown, VP Business Services Delaware.Net, Inc. 30 Old Rudnick Lane, Suite 200 Dover, DE 19901 email: [EMAIL PROTECTED] phone: 302-736-5515 fax: 302-736-5945 icq: 1812513 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: IsDefined('') v. cfset
cfparam will be more expensive than cfset, just because it tests forthe
existence of a variable before setting it.
However it's like comparing apples to oranges. They are used for different
reasons.
If you have a page that may or may not have a variable passed to it, but you
have code on
the page that expects the variable, you dont want to overwrite a legitimate
value from your program with cfset.
In this case, cfparam would be the best choice.
There is also a difference between a variable initialized in the
application.cfm and a true application variable. You wouldn't want to
cfparam a true application variable, since it;s in memory, and you could run
into a situation where multiple people are setting it at the same time.
Initializing variables in the application.cfm is very easy, but if you are
really worried about performace. Putting all of your
constant varaibles in a structure then scoping the structure in the
application scope, will be faster than reinitializing the variable on every
page, at the cost of a little bit of memory.
If you only have a handful of variables that you actually need throughout
the application, the performace his to just cfset them on every page is
minimal, and probably not worth the time it will take to code them better
though. You also have to think about locking with the in memory scopes, like
the application scope.
Lets say you have 30 variables and a high traffic site though, it may then
pay off to optimize, rather than let Moore take care of it ;-)
Here is an example...
In your application.cfm test for the existence of the structure, because
application variables time out.
cflock type="EXCLUSIVE" timeout="5"
cfif NOT isDefined("application.globalVars")
cfset globalVars = structNew()
Then you set all yourvariables here...
cfset globalVars.dsn = "myDSN"
cfset globalVars.password = "password"
...
Then application scope the structure.
cfset application.globalVars = ""
cfset application.globalVars = globalVars
/cfif
/cflock
You can then reference the individual variables throughout your application
with #application.globalVars.dsn#.
This can be made even faster with the use of cfscript too.
jon
- Original Message -
From: "Bill Davies" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Wednesday, April 11, 2001 5:17 PM
Subject: RE: IsDefined('') v. cfset
So would cfparam be cheaper than just doing a cfset anyway - say for
an
Application variable whose value is constant?
-Original Message-
From: Will Swain [mailto:[EMAIL PROTECTED]]
Sent: 11 April 2001 17:27
To: CF-Talk
Subject: RE: IsDefined('') v. cfset
Yup, CFPARAMs in your application.cfm file will 'set' empty variables,
which
you can fill later.
That way, you don't need to check for their existence, just see what they
are.
Cheers
Will
-Original Message-
From: Bob Silverberg [mailto:[EMAIL PROTECTED]]
Sent: 11 April 2001 15:29
To: CF-Talk
Subject: RE: IsDefined('') v. cfset
This doesn't answer your question directly, but if you are really going to
test for the existence of a variable, and create it if it doesn't exist,
I'd
suggest using cfparam which will accomplish both of those things in one
step. I only used IsDefined if I want to check for the existence of a
variable, and I'm NOT going to create it if it doesn't exist.
Bob
-Original Message-
From: Bill Davies [mailto:[EMAIL PROTECTED]]
Sent: April 11, 2001 10:12 AM
To: CF-Talk
Subject: IsDefined('') v. cfset
Anyone have any idea whether an IsDefined('') 'costs' more than a cfset?
i.e. Which is more work for the server - to test for the existence of a
variable (and create it if it doesn't exist) or create or overwrite it
anyhow?
Thanks.
Bill Davies
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Is WDDX alive well ?
Funny you ask...supposedly Macromedia has contracted to have the site totally updated and redone. Someone mentioned the new site should be up very soon as work has already begun. jon - Original Message - From: "Tracy Bost" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, April 12, 2001 9:00 AM Subject: Is WDDX alive well ? Before I jump into Allaire's WDDX SDK, I'm wondering if this is still a platform that is being progressed. The web site www.wddx.org doesn't look like its been updated in 2 or 3 years. Thanks for any feedback and would love to hear from anyone that's using it to syndicate content to perl asp sites. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Is WDDX alive well ?
I specifically asked an Allaire consultant if wddx would work with Neo, and he said yes. So unless they have changed their mind in the last couple of months, I'd say if anything Macromedia would add another technology and try to migrate us... Not to mention they are investing in wddx right now... jon - Original Message - From: "Dick Applebaum" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, April 12, 2001 11:37 AM Subject: Re: Is WDDX alive well ? I haven't done any new development in it lately, but I regularly use programs I wrote some time ago. The pluses: it works well, as advertised. the minuses: It is pretty verbose. As I recall, Dave Weiner (Frontier, Userland, Manilla, EditThisPage, etc.) was put off with allaire for creating/choosing/promoting WDDX instead od Dave's technology. I think that Marc Cantor was the original founder of MM and is good friend of Dave likes his technology. Just visited the MM site... the investors page uses Java for animation... curious? Don't know if any of this means anything, but it may stir the pot a little. Dick At 8:00 AM -0500 4/12/01, Tracy Bost wrote: Before I jump into Allaire's WDDX SDK, I'm wondering if this is still a platform that is being progressed. The web site www.wddx.org doesn't look like its been updated in 2 or 3 years. Thanks for any feedback and would love to hear from anyone that's using it to syndicate content to perl asp sites. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Insert query?
I know it's possible to Insert a Select statement if the tables are exactly the same, however is it possible to insert a CF queryset? Something like... cfquery INSERT INTO Table(Columns,...) #GeneratedQuery# /cfquery jon ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Insert query? - nevermind
I just remembered I asked this question some time ago, and the answer was no. I would really love to be able do this though... cfinsert enhancement perhaps? Any technical reasons why this could not be done? jon - Original Message - From: "Jon Hall" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 12, 2001 4:30 PM Subject: Insert query? I know it's possible to Insert a Select statement if the tables are exactly the same, however is it possible to insert a CF queryset? Something like... cfquery INSERT INTO Table(Columns,...) #GeneratedQuery# /cfquery jon ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Insert query? - nevermind
That is why I said cfinsert enhancement not cfquery enhancement... jon - Original Message - From: "Hayes, David" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, April 12, 2001 5:57 PM Subject: RE: Insert query? - nevermind This is analogous to the periodic "can I use javascript to set my cf variables?" post - your CF object and your database are in different "places". The CF Query Object isn't going to be recognized by your database application. The tables don't have to be the same to use an INSERT...SELECT statement; you specify which fields you want to use, and transform the data as needed in the select statement. You'll have to create multiple insert statements, whether you do it in CF or do it in a stored procedure; if you have a large number of records to insert, you could output your Query Object to a formatted text file and import directly into your db using a manual or automated process. -----Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 12, 2001 3:35 PM To: CF-Talk Subject: Re: Insert query? - nevermind I just remembered I asked this question some time ago, and the answer was no. I would really love to be able do this though... cfinsert enhancement perhaps? Any technical reasons why this could not be done? jon - Original Message - From: "Jon Hall" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 12, 2001 4:30 PM Subject: Insert query? I know it's possible to Insert a Select statement if the tables are exactly the same, however is it possible to insert a CF queryset? Something like... cfquery INSERT INTO Table(Columns,...) #GeneratedQuery# /cfquery jon ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Transferring 1-3Kb data
With a couple of hundred users simultaneously, I dont think this is a job for CF, unless it's just processing the files after they have been uploaded. I think this functionality needs to be built into your application. The application needs to open a connection to the host which is listening for your clients Upload the file, then disconnect. Easier than writing an mp3 decoder... At least in java it would be... jon - Original Message - From: "Michael Lugassy" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 11:24 AM Subject: Re: Transferring 1-3Kb data Yes. we anticipate hunderds of users simulatniosly. - Original Message - From: "Dave f" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 4:04 PM Subject: Re: Transferring 1-3Kb data Just a thought; why not send log data to the server (formfields/database) to begin with. amount of data is so trivial scalability shouldn't be a problem. (Unless I've totally misunderstood the problem, and you have hundreds of concurrent users) Dave - Original Message - From: "Michael Lugassy" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 10:29 AM Subject: Re: Transferring 1-3Kb data I don't know.. CFFILE? If there is no other way... :( - Original Message - From: "JustinMacCarthy" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 3:06 PM Subject: RE: Transferring 1-3Kb data 2. send the file in http (using WDDX/URL/FORMFIELD) and create a copy of the file locally on the server. the two solutions are not scalable enough, any help would be appriciated! Why is this not scalable ? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Transferring 1-3Kb data
Not necessarily either although there are tons of ftp libraries out there that could be implemented into the program very easily. A raw tcp or udp connect on whatever port you want would work. You would have to write the server side app that received the file, then write it to the hard drive. I think if I was doing this, I'd code the ftp capabilities into the client and just make the program upload it's log file, if only in the interest of time savings, and programming an industrial size server side daemon in java is not something a can do yet ;-) jon - Original Message - From: "Michael Lugassy" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 12:57 PM Subject: Re: Transferring 1-3Kb data I'm glad you checked out our product. :) But what is exactly this connection to the host? is it via FTP or HTTP? How is this done with visual c++? - Original Message ----- From: "Jon Hall" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 5:34 PM Subject: Re: Transferring 1-3Kb data With a couple of hundred users simultaneously, I dont think this is a job for CF, unless it's just processing the files after they have been uploaded. I think this functionality needs to be built into your application. The application needs to open a connection to the host which is listening for your clients Upload the file, then disconnect. Easier than writing an mp3 decoder... At least in java it would be... jon - Original Message - From: "Michael Lugassy" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 11:24 AM Subject: Re: Transferring 1-3Kb data Yes. we anticipate hunderds of users simulatniosly. - Original Message - From: "Dave f" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 4:04 PM Subject: Re: Transferring 1-3Kb data Just a thought; why not send log data to the server (formfields/database) to begin with. amount of data is so trivial scalability shouldn't be a problem. (Unless I've totally misunderstood the problem, and you have hundreds of concurrent users) Dave - Original Message - From: "Michael Lugassy" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 10:29 AM Subject: Re: Transferring 1-3Kb data I don't know.. CFFILE? If there is no other way... :( - Original Message - From: "JustinMacCarthy" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 3:06 PM Subject: RE: Transferring 1-3Kb data 2. send the file in http (using WDDX/URL/FORMFIELD) and create a copy of the file locally on the server. the two solutions are not scalable enough, any help would be appriciated! Why is this not scalable ? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Setting up Access Datasources
Hmm, I recenly had an app where I had an Access db on another server on the network. I the remote folder to a drive on my server and it verified fine. The problem I ran into is that the file chooser java applet only seems to see physical drives. If I put in the path manually it verified fine. jon - Original Message - From: "Dave f" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 2:51 PM Subject: Re: Setting up Access Datasources Actually, I don't think that you can have CF verify Access db on a different machine. Doesn't CF admin only show local drives if you pick "Access database" ??? It was a long time ago in a distant galaxy, but I seem to remember having to switch to SQL or something D. - Original Message - From: "Curtis C. Layton" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 11:10 AM Subject: Setting up Access Datasources Here's an interesting question: We recently set up a server cluster that is configured in this fashion: Web1/Web2 Boxes: Win 2K Advanced Server SP1, CF Enterprise 4.5, MDAC 2.5 SQL Box: Win 2K Advanced Server SP1, SQL Server 7.0 NowI can get SQL Server databases to verify on both Web boxes with no problem. I've mapped a drive onto the Web boxes to add Access databases but I cannot get them to verify. Any help with be appreciated. Curtis C. Layton Senior Web Applications Developer Words In Progress Inc. [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: The Best Clustering Solution
The cheapest way to do this would be setting up a round robin dns system, and then using win2k's File Replication Service. http://www.labmice.net/FileMgmt/FRS.htm A step up for replication would be Microsoft's new Application Server 2000, which I must say is tres' slick. http://www.microsoft.com/applicationcenter/ Win2k Advanced Server also offers load balancing which is not as easy as a round robin system, but is probably more efficient, at least that is what MS says ;-) I've done both, and not had a problem with either. jon - Original Message - From: "Paul's Mail" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, April 18, 2001 6:18 PM Subject: The Best Clustering Solution we have 2 Win2000 servers running CF applications and wish to cluster them so that they both are duplicates of each other. The clustering solution must include replication. Cluster Cats supplied with CF Enterprise does not include replication and I cannot find this software in its full version including replication anywhere. Which is the best solution for clustering just two servers? Is the solotion supplied by Microsoft any good? Any help would be appreciated as the subject is new to me. Kind regards Paul ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How secure are cgi variables
Are you working on some kind of IP based security? While cgi.remote_addr is generated by the server, ip address spoofing is not hard, so any ip based security will not keep out a resourcful hacker. jon - Original Message - From: "Robert Everland III" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, April 18, 2001 7:10 PM Subject: How secure are cgi variables I am playing around with cgi variables to see how secure they are. What I want to know is there anyway to change say the remote_addr or is that getting the ip address from somewhere else. I tried changing it to see how good my security is on a site I am coding and it wouldn't not change the remote_addr at all (I am using HTTP and httpparam to do this). Anyone have any insight into this? Bob Everland ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: WDDX.org is now OpenWDDX.org
You know what I really want? More examples of wddx integrated with other languages, maybe some actual working programs, and a kitchen sick if it's ok.. ;-) jon - Original Message - From: "Rey Bango" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, April 18, 2001 8:05 PM Subject: Re: WDDX.org is now OpenWDDX.org I hear ya but this is what they've given us to work with. Hopefully, there'll still be support from the community. Rey... - Original Message - From: "David E. Crawford" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, April 18, 2001 7:15 PM Subject: Re: WDDX.org is now OpenWDDX.org I think they need to put it out GPL instead of this "hyrbrid" license. It would be much more likely to be accepted by the "open source" crowd and others in that case. DC - Original Message - From: "Rey Bango" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, April 18, 2001 18:05 Subject: Re: WDDX.org is now OpenWDDX.org Dain, What do you see that makes it "non-open"? I can always forward your comments accordingly. Rey... OpenWddx.org - Original Message - From: "Dain Anderson" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, April 18, 2001 4:31 PM Subject: Re: WDDX.org is now OpenWDDX.org Gee, with all this talk about "open", one might look at the following URL and begin to question it's openness. http://www.openwddx.org/downloads/ Dain Anderson Caretaker, CF Comet http://www.cfcomet.com/ - Original Message - From: [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, April 18, 2001 2:33 PM Subject: WDDX.org is now OpenWDDX.org Effective today, Macromedia has formally transitioned responsibility for the Web Distributed Data Exchange (WDDX) Web site to a third party. All information that has been posted to the WDDX Web site, wddx.org, can now be found at http://www.openwddx.org. WDDX is an XML-based technology that enables the exchange of complex data between applications, creating what some refer to as 'Web syndicate networks' and enabling Web Services. Allaire created WDDX in order to solve key problems in exchanging data between Web applications. In particular, Simeon Simeonov, Allaire's chief architect, created WDDX to support problems of distributed computing within ColdFusion. This work was generalized into a cross-language framework, and resulted in the creation of the WDDX SDK and WDDX.org. Nate Weiss, an independent Web developer, with the support of Allaire and a number of other third parties, created the WDDX SDK. Transferring responsibility for this Web site is consistent with our overall goal of supporting this technology within the public domain. As creator of the technology, Allaire Corp. was at times perceived as the owner and formal supporter of the technology, and that WDDX was a proprietary technology. The establishment of OpenWDDX.org is intended to rekindle enthusiasm and acceptance of WDDX in the developer community, and confirm its role as an independent and enabling technology. For more information, and a complete FAQ about the WDDX initiative, please visit http://www.openwddx.org. Best, -Sam Samuel Coe Sr. Manager, Developer Programs Macromedia, Inc. 617-219-2133 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Manual Lock row?
OK, here is my problem, I have two program running on different servers that query and update the same field in the same database. I am running into concurrency problems where users happen to be running the same program at the same time and end up updating the field with the wrong info. What I need to do is lock the query so that only one client can query the value of the field at once, so that when they do the update, the right info is entered. I know if I change the query to a stored procedure, SQL Server will take care of this for me, however the query is so dynamic that I really dont want to do that. I may have to end up doing that though, unless anyone can help me here... So is there a way to manually lock a row for the duration of a select statement with a cfquery statement? jon ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Send Cookie in custom tag?
Dont know if that would work, but if you dont mind relying on javascript, something like this will work. cfcookie name="test" value="1" script self.location='myPage.cfm'; /script The cooke will get set fine... jon - Original Message - From: "Willy Ray" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, April 19, 2001 2:08 PM Subject: Send Cookie in custom tag? I know I can't use CFCOOKIE above CFLOCATION on a template, but what if I had a custom tag that dropped a cookie above a CFLOCATION? Like this: cf_cookiedropper cflocation url="mypath" Would the cookie go? Willy ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL update not executing?
OK, no response on the question earlier, but maybe someone has seen this or can help me figure out where to look... I have a page which every once in a while will execute fully, but there is an update statement that does not update the database even though I see the query in my debug. Here is a snip from the debug: (Records=0, Time=100ms) SQL = UPDATE banners WITH (ROWLOCK) SET views = views + 1, next_rotation = next_rotation + 16 WHERE adid = 2 The debug says it happened , however when I go look at the db right after this statement and the next_rotation field hasn't budged! This does not happen every time, however it always does happen eventually. It only happens however, when I am stressing the application (which is a banner app...) with a simple 8 frame meta refresh page i did up. Some background info, this app is running on my local machines CF Server(5b3), the SQL Server is on my local machine (v7). The same thing happens though on a CF 4.5 production machine also though... jon ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL update not executing?
Well I seem to have beaten the problem, I spent a couple of hours taking a lot of the logic into sql server, dynamic SP's and all...whew. I still dont know why the problem happened in the first place though Thanks /me wishes I had a dba... ;-) jon - Original Message - From: "Todd Ashworth" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, April 19, 2001 11:03 PM Subject: Re: SQL update not executing? This has nothing to do with your current question, but as to your earlier question, our DBA says it can't be done on the application level (in a web based environment, due to its stateless nature) and is dubious as a Stored Procedure. I'll bug him more about it tomorrow and see if he can't come up with a 'different' solution. Todd Ashworth - Original Message ----- From: "Jon Hall" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, April 19, 2001 9:48 PM Subject: SQL update not executing? OK, no response on the question earlier, but maybe someone has seen this or can help me figure out where to look... I have a page which every once in a while will execute fully, but there is an update statement that does not update the database even though I see the query in my debug. Here is a snip from the debug: (Records=0, Time=100ms) SQL = UPDATE banners WITH (ROWLOCK) SET views = views + 1, next_rotation = next_rotation + 16 WHERE adid = 2 The debug says it happened , however when I go look at the db right after this statement and the next_rotation field hasn't budged! This does not happen every time, however it always does happen eventually. It only happens however, when I am stressing the application (which is a banner app...) with a simple 8 frame meta refresh page i did up. Some background info, this app is running on my local machines CF Server(5b3), the SQL Server is on my local machine (v7). The same thing happens though on a CF 4.5 production machine also though... jon ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: studio upgrade
The new VTM's will be released with CF Server 5 though. jon - Original Message - From: "Patricia Lee" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, April 20, 2001 10:50 AM Subject: RE: studio upgrade I've heard that Studio 5 won't be released until about 6 months after CF 5. Which makes it somewhere around December I believe. | |Does anyone know if CFStudio will be released in a 5.0 |version? If so, does |anyone know what features will added, changed, etc? | |Thanks. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Is CF still relevant?
I dont have a problem parsing XML with CF, although no server side scripting language like cf or asp and so on is ever going to be the best tool for that. Any programming language can be object oriented, it's whether or not the language designer forces the situation as in Java's case. I can make a kick ass OOP Basic program with goto's, who cares? You want OO on CF, check Fusebox or cfObjects. Lastly, Linux used to have a real tiny community too. That does not seem to negatively affect the success of Linux today. The only thing that can be said about a programming environment with a small community, is that is has a small community. Why do I use it? It works. jon - Original Message - From: "Joseph Grossberg" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, April 20, 2001 3:27 PM Subject: Is CF still relevant? Now, before you dismiss this as a troll, please let me elaborate. This isn't so much an instigation or a whine as it is a call for us to take a step back and reevalutate things periodically. Over the course of my career as a web programmer/developer, I have worked with a variety of sever-side languages and technologies: ColdFusion, ASP, JSP, PHP, Perl and Python. I like some more than others, but I'm not an evangelist for any; they each have their uses. And I recognize some of CF's strengths: easy to learn for people who know only tag-based HTML or don't have significant programming experience; built-in admin tool; specialized editor; comes with pre-built tags and web-based administrator. There are also major flaws: broken/sketchy tags; no XML parsing; not OOP; relatively small community; etc. Right now, I work at a web development firm that is primarily "a CF house" (besides me). Our more senior programmers are looking at honing their CF skills, while our less experienced webmasters are trying to learn ColdFusion. But, I can't help but wonder whether they are wasting their time. Would they be better off spending their time learning ASP, Java or another non-CF solution? Why or why not? And how would we tell if and when it was time to give up CF and try something else, as all but the most stubborn experts in also-ran languages (Ada, SmallTalk), applications (Netscape, Lotus Notes) and Operating Systems (Amiga) have resignedly done? Lastly, why do *you* still use CF? Is it because it's what you're best at, and you don't want to try something new (where, temporarily, you'd be a novice again)? Is it because your ccompany's legacy code is all in CF? Is it because you genuinely think that ColdFusion is, generally speaking, the best solution for web application development in 2001? Joe ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How do i set up a Java CFX tag.
Go here and download the jvm. Install is painless. http://java.sun.com/j2se/1.3/jre/download-windows.html jon - Original Message - From: Rick Lamb [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 23, 2001 1:11 PM Subject: How do i set up a Java CFX tag. I need to use a cfx tag written in java and am not sure how to set it up. Do I need to install a Java Virtual Machine on the server? Any thing else required? The error I get now is asking me to set up a JVM on the server. How do I do this. Can someone help me get started? Thanks, Rick ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How do i set up a Java CFX tag.
Nope, Java is Java, it needs an interpreter to do anything. All Java programs are compiled into bytecode, that's why theorhetically you can take that cfx that you have and install it on a *nix machine as long as the jvm is installed. jon - Original Message - From: Jeffry Houser [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 23, 2001 8:35 PM Subject: Re: How do i set up a Java CFX tag. Well, by definition a CFX tag is a DLL, correct? (I thought CFXs were binaries) You should only need a JVM to run a Java Applet. Java Applications are compiled down to assembler (or whatever) for the underlying operating system, not bit code for a Java Virtual Machine. When you have a CFX it doesn't matter what language it was coded in, unless you want to change the source code. At 03:44 PM 04/23/2001 -0400, you wrote: Go here and download the jvm. Install is painless. http://java.sun.com/j2se/1.3/jre/download-windows.html jon - Original Message - From: Rick Lamb [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 23, 2001 1:11 PM Subject: How do i set up a Java CFX tag. I need to use a cfx tag written in java and am not sure how to set it up. Do I need to install a Java Virtual Machine on the server? Any thing else required? The error I get now is asking me to set up a JVM on the server. How do I do this. Can someone help me get started? Thanks, Rick ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: 100s of FTP Accounts
Dont bog down Windows with all these users. If you use IIS ftp, plan carefully by assigning your users to groups. The IHTK @ www.intrafoundation.com is a set of custom tags that will let you programatically set up IIS ftp accounts, directories, and so on. You might want to think about using an ftp server other than IIS, there are many others out there that are scriptable and have their own databases of users, and not relying on the user having a windows account. jon - Original Message - From: Michael Lugassy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, April 24, 2001 11:21 AM Subject: 100s of FTP Accounts We're about to offer all of our users and client complete ftp access to 10mb of storage. Every user will have his own directory on our NT machine and ftp account that will log him automaticlly to HIS special directory. What is the best way to seperate directories and accounts without the need to create 1000s of FTP accounts under NT? I've heard somewhere that by logging onto FTP with a username that is the same as on of the directories, the user automaticlly logs inside it. but I don't want to assign NT account to every user... :( - is it somehow possible with Anonymous FTP? Thanks, Michael Lugassy Interactive Music Ltd. I don't live in fantasy; I just work there... http://www.imvamp.com [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: slightly OT: html formatted e-mails
I've got to disagree stongly with this. If you have 1000 users, 20% = 200 users who are going to give you a call or send an email. Not only that, these are the users you want to speak to the least, because they still dont know how to upgrade their browser or email client. I am currently finishing up rewriting a program for a customer basically from the ground up, because it was TOO powerful for the end user to understand. Every screen had context sensitive help too. However all of the words on the screen, and all those little input and select boxes confused the @(#$%%ing moron ;-) Never underestimate the power of stupidity, dont give the end user any choices, and never ever leave the slightest possible chance that one of them might have to contact you about their Netscape 2.0 running on Windows 3.1. A little extra time taking into consideration compatibility, will save the most time in the long run. my .02 jon - Original Message - From: Michael Lugassy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, April 24, 2001 7:09 PM Subject: Re: slightly OT: html formatted e-mails Writing for non-html-support email programs are like writing html for netscape the war is over my friends.. Michael. - Original Message - From: John Fix 3rd [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, April 24, 2001 10:45 PM Subject: RE: slightly OT: html formatted e-mails LOL! So true. -Original Message- From: zac [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 24, 2001 3:03 PM To: CF-Talk Subject: RE: slightly OT: html formatted e-mails Note that 80%+ of the e-mail programs are supporting HTML! Note that 0% of the internet standards for mail support it. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ODBC Error
I'm getting this error when executing a stored procedure occasionally under load. Error Diagnostic Information ODBC Error Code = 01000 (General warning) [Microsoft][ODBC SQL Server Driver][SQL Server]rotation Anyone know what a general warning means? jon ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: New CF5 Partner Hosting License
It really depends upon the price, if it's not to expensive, priced similar to a CAL for Win2k or thereabouts, this wont be a problem. However if the price goes higher than a couple hundred dollars per site it no longer is profitable to charge somone a competitive price for a simple CF shoppingcart or message forum on a shared server. What is the definition of a ColdFusion site? Any site that uses CF? What if they have a simple cfmail program and that's it? If the price becomes prohibitive, it makes sense to check out php or asp+. If the price is too high, we will probably be sticking with 4.5 on all of our servers, and not doing a wholesale upgrade like we were planning. and I was just starting to like Macromedia... jon - Original Message - From: Chris Colón [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 26, 2001 1:39 PM Subject: New CF5 Partner Hosting License Allaire's Partners just received an email announcing ColdFusion Server 5 Hosting Service Provider Edition, which consists of a new End-User License for commercial hosting service providers. The gist of it is that Hosting Providers will now be charged extra for the privilege of running multiple CF sites on a shared server. As far as I can tell, all the new features of CF5 will be in the Enterprise edition, so the only difference between Enterprise and Hosting is that the latter will cost more. Some value. I sent Allaire an email registering my strong disapproval of this new hosting partner penalty fee, pointing out that GoTech is already subjected to marketplace pressures due to the free nature of Microsoft's Active Server Page (ASP) technology, and Allaire/Macromedia's continual ratcheting up of ColdFusion's price is potentially debilitating to our efforts to deploy your product. Perhaps they see their only competition in the BEA/WebLogic/IBM/Oracle application server space. This may be the case for Enterprise, but there's no way this is the case with hosting providers. We're competing in the trenches with ASP, which is free on NT/2000, and at some point the benefits of the CF environment will be outweighed by its cost Maybe I'm just jumping to conclusions, and this is actually (somehow) a benfit to hosting partners. Thoughts? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: New CF5 Partner Hosting License
$200 would take a long time. However if we need to purchase site licenses for each web site AND it is possible to reuse them, it then becomes more palatable to me. I really hope Macromedia thinks this through thoroughly. Don't get me wrong, I think the whole idea is heading in the wrong direction. However it depends on the price and if Macromedia is going to do this we need some benefits. Maybe including more Generator components? Some of the security benefits from Enterprise? Around here, the word php and asp have even been mentioned by a couple of guys who not a week ago would have snarled fiercely if you asked them what they thought about either... jon - Original Message - From: Jim McAtee [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 26, 2001 5:33 PM Subject: Re: New CF5 Partner Hosting License - Original Message - From: Jon Hall [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 26, 2001 1:54 PM Subject: Re: New CF5 Partner Hosting License It really depends upon the price, if it's not to expensive, priced similar to a CAL for Win2k or thereabouts, this wont be a problem. However if the price goes higher than a couple hundred dollars per site it no longer is profitable to charge somone a competitive price for a simple CF shoppingcart or message forum on a shared server. Couple hundred dollars per site!!? If hosting providers lose the ability to offer CF hosting at prices comparable to ASP hosting, CF will see a DRAMATIC loss of users. How long a time period at $20-$30 per month would it take to recoup such an investment? A _long_ damned time. Many (probably MOST) CF hosts currently can't afford the luxury of CF Enterprise on all of their shared servers. They run CF Pro and restrict what tags can be run on the server. If we can't even host more than one of our _own_ sites off a CF Pro license, we'll be sticking at CF 4.x for the time being, while looking at moving to another technology. Jim ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
More locking confusion...
Ok I got the devcenter mailinglist today like a lot of us, and I was checking out the article titled ColdFusion Methodologies for Content Management at http://www.allaire.com/handlers/index.cfm?ID=20750. The author writes: An easy answer to this problem is to dump the entire SESSION or APPLICATION scope into the REQUEST scope. ColdFusion does not 'share' the REQUEST scope between threads and it does not need to be locked. So by dumping all the shared variables to this scope, we can lock our variables once and then forget about it. Well I thought that cfsetting a session or application variable to a request scoped variable only set a pointer to the original variable so these request variables need to be locked too. I thought this is what the duplicate() is supposed to do (when it's fixed :-)). Am I incorrect? jon ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Newbie: Trouble With Browser Loading Old Page
Put the below code on the page in question. CFHEADER NAME=Expires VALUE=Mon, 06 Jan 1990 00:00:01 GMT CFHEADER NAME=Pragma VALUE=no-cache CFHEADER NAME=cache-control VALUE=no-cache jon - Original Message - From: Petro Rondiak (Rev3) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 26, 2001 11:25 PM Subject: Newbie: Trouble With Browser Loading Old Page Hello! I have a page that cfoutputs text from a database and allows a user to update the text content. The user simply fills in a form field and clicks update. I use an update template that updates the database with the new text the user typed in. At the end of the update template I use CFLOCATION to go back to the page in question. Unfortunately, the browser keeps showing a local copy and not the updated version, unless I hit refresh on the browser. I searched the CF resources for an answer and thought I found it at houseoffusion (excerpt at bottom ) with: CFLOCATION URL=index.cfm?norefresh=#Rand()# Unfortunately, the browser still loads a local copy even though the URL is always different. Any help would be greatly appreciated! Petro [EMAIL PROTECTED] -from Aiden Whithall's FAQ --- The key to creating a workaround for this situation is to know that browsers identify a page by its URL--if the URL is the same as the one it just cached locally, it uses the local copy. Accordingly, you can simply append a dynamically created variable name to the URL, thereby producing a new URL and forcing the browser to make a subsequent call to the server to retrieve the new, and up-to-date, page. Here is an example of the code you can use to do this: CFLOCATION URL=index.cfm?norefresh=#Rand()# Rand() returns a random number in the range of 0 to 1, including fractions, so the URL will be different each time you call it, which forces the browser to request the page again from the server. That, in turn, ensures the most current information will be displayed. -- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: New CF5 Partner Hosting License
Probably not until the 30th, or it wouldn't answer the most important question...price. That's Monday for you Yahoo's. jon - Original Message - From: Ken Wilson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, April 27, 2001 3:25 PM Subject: Re: New CF5 Partner Hosting License Don't panic yet. I believe a FAQ is in the works that will explain all this. Stay tuned. Ahh, but will the FAQ arrive before we all spend the weekend planning our alternatives? :) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Hosting Service Provider Edition Clarification
Ok, what this means for my company and for Macromedia is... According to the FAQ, we can purchase Pro or Enterprise to host our own applications and be within the license. So our companies bottom line is not really affected as far as development goes. However, I do not see us continuing to offer CF as a standard feature of our hosting packages. At least for version 5. I predict there will be quite a few hosts that provide CF 4.5 as part of a hosting package for a long time, and if they offer CF5 shared hosting at all it will be at a premium. We will upgrade to CF5, but not for all of our servers, and probably never will upgrade a couple past 4.5. The costs are astronomical to offer CF as a standard feature anymore. Who got hurt? The little guy looking for CF5 shared hosting. The development companies are safe. Perhaps the bigger hosters are safe too, with volume discounts and all. I got started in CF because my web host offered it as a standard feature, so I played around with it, and a couple of years later here I am a CF developer. It seems sad to me that a lot of new guys wont get the chance I did. As a web host puts up new servers, CF will be slowly phased out. Either we buy a license for 4.5 or pay through the nose for CF5. Why bother? Maybe 1 out of every 20 of our current sites use CF. Most people cant even figure out FrontPage ;-) Macromedia in one fell swoop, just cut a whole lot of little guys out. Perhaps what Macromedia is really trying to do is sell more copies of pro and enterprise. It is now more cost effective to rent a server or colocate and put CF on it yourself. Still cutting out the new guys though :-( jon - Original Message - From: Jeff Whatcott [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, April 27, 2001 6:10 PM Subject: Hosting Service Provider Edition Clarification Yesterday we sent an email to Macromedia ColdFusion hosting partners regarding the new Hosting Service Provider Edition of ColdFusion Server 5 that was cross-posted to this list. The information in the email was unclear, which caused some confusion about ColdFusion Server 5 pricing and licensing policies in general. On behalf of the team, first I want to apologize for any confusion caused by the email. ColdFusion Server 5 is a very exciting release. The focus has been on building features that developers have been requesting for years. You'll find support for user defined functions, incremental page output, charting, a new administrator, and major performance increases among other cool features. At the same time that we've been building enhancements, we've been very focused on quality, and so far, the feedback in the beta program has been very positive. With the exception of the Hosting Service Provider Edition, we're not changing the basic licensing policies or pricing. As a merged company, we're focused on the needs of ColdFusion developers more than ever. Macromedia is deeply committed to the ColdFusion community and the vision behind ColdFusion Server, and we're making a significant investment in the product. We understand that having high quality hosting options is important to developers, and one of our focuses for this release is to expand the number of service providers participating in our hosting partner program. When we announce formally on Monday, there will be a lot more information available about the new release on our Web site. To help clarify the Hosting Service Provider Edition policies, we've posted an FAQ about the new edition at: http://www.allaire.com/products/coldfusion/cf5hostingfaq.html If you have more questions or concerns about this new edition, please feel free to drop me a note. I'm looking forward to your feedback on ColdFusion Server 5! Jeff Whatcott Director, ColdFusion Product Marketing Macromedia [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: FAQ POSTED: New CF5 Partner Hosting License
Ok, to raise the reliability of hosting providers you think that raising the price will help? . So theorhetically now hosters with smaller budgets who have less expensive / reliable servers wont offer CF Hosting and all of the sudden CF Servers dont crash? As a smaller hoster whos web servers have excellent uptime, 5 hours total in 2000! We get calls all the time from people talking about the unreliability of some of the larger hosters servers. Got two seperate calls in the last two days about a certain CF host who advertises in CFDev Journal as a matter of fact...I bet they are gonna offer CF5 shared hosting too. We wont. Macromedia pricing out the little guys does nothing to increase the reliability of hosting, it only decreases competition, which lowers overall quality in the long run. Improving reliability out of the box...jesus, even the damn phrase is getting me pissed off. It's an arrogant cocky ignorant thing to say to a server admin who gets up at 3am to check why the smtp server all of the sudden stopped responding for 3 minutes. Only to find out it fixed itself by the time I bump myself to the computer. Woohoo! Macromedia raised their prices, my servers wont talk to me anymore like in those MS commercials! What a load of bs. jon - Original Message - From: C. Hatton Humphrey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, April 27, 2001 11:10 PM Subject: FAQ POSTED: New CF5 Partner Hosting License There is now an official definition of the Cold Fusion 5.0 Hosting Service Provider edition available at: http://www.allaire.com/products/coldfusion/cf5hostingfaq.html. It was posted on one of the other lists I'm on and I'm suprised it didn't make it here. I'm glad I waited to chime in... this is actually looking to me to read like an improvement rather than a money grab. Anything to improve the reliability out of the box for any of the hosting providers is a big plus. I've dealt with two, one that didn't care beyond the collections department and another that bent over backwards to help. In both instances the server hit periods of problematic operation. Now I'm hoping this version will stabilize things a bit. (*resubmits his purchase request for the CF Developers Cert Study Guide*) Enjoy the weekend! Hatton Humphrey -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Friday, April 27, 2001 6:50 PM To: CF-Talk Subject: Re: New CF5 Partner Hosting License A/MM just posted to the list a nice rundown on what's happening. Close enough for the weekend. Don't panic yet. I believe a FAQ is in the works that will explain all this. Stay tuned. Ahh, but will the FAQ arrive before we all spend the weekend planning our alternatives? :) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: FAQ POSTED: New CF5 Partner Hosting License
I meant 5 hours downtime...doh! jon - Original Message - From: Jon Hall [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, April 27, 2001 11:44 PM Subject: Re: FAQ POSTED: New CF5 Partner Hosting License As a smaller hoster whos web servers have excellent uptime, 5 hours total in 2000! We get calls all the time from people talking about the unreliability ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Continue processing form based on user input
There is more than one way to do this, and the question is rather broad, but on the action page do a routine that checks checks to see if there is a duplicate value first. If there is, stop processing and ask the user if they want to continue. The page that asks the user if they want to continue, should have hidden input fields with all of the values from the form. If they choose to continue, submit the form to your action page and process the form. If they choose not to continue, you have all of the form fields there to show whatever info you need. hth jon - Original Message - From: Richard Colman [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, April 29, 2001 12:24 AM Subject: Continue processing form based on user input Can someone suggest the best approach to cancel or continue with form processing based on user input? The scenario is: -form submitted -possible duplicate record detected in action poage -ask user whether to proceed with processing --if user says yes then continue processing form variables in the action page --if user says no cancel form processing and throw up an information screen. I have been playing around with several Javascript approaches to doing this, but I don't now JS all that well. Is there a CF way to do it, keeping in mind that I need to maintain my form variables if the user wishes to proceed. Can someone suggest a good approach, CF or otherwise, to this problem? TNX. Rick Colman. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF-Partners List
31,403... ;-) jon - Original Message - From: Stephen Kellogg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 30, 2001 11:06 AM Subject: RE: CF-Partners List Only 6000? Your post made me take a look at my CF-Talk folder. I've got over 12,000 and that's after archiving almost 5000 to a local DB. Guess you're right, it's time to archive again. Thx Stephen -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Monday, April 30, 2001 10:27 AM To: CF-Talk Subject: RE: CF-Partners List I agree, my CF-Talk folder has over 6000 messages in it. I think its time to clean up. Rich -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Monday, April 30, 2001 12:43 PM To: CF-Talk Subject: Re: CF-Partners List Only if you set up a filter to do it... Personally, I don't think I could survive on a daily basis without e-mail filtering. At 09:20 AM 04/30/2001 -0400, you wrote: Doesn't email filtering accomplish the same task? Howie - Original Message - From: Aidan Whitehall [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 30, 2001 5:05 AM Subject: RE: CF-Partners List Great idea. I was getting sick of opening up e-mails (in Outlook) just to see if an e-mail came from a macromedia.com address. Any chance of doing the same for e-mails from allaire.com? -- Aidan Whitehall [EMAIL PROTECTED] Netshopperuk Telephone +44 (01744) 648650 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Help me! My brain won't start
There is no reason to use the caller scope unless you are referencing the calling page from _within_ a custom tag. So, if you want to pass an array to a custom tag, your first example will work fine. jon - Original Message - From: Russel Madere [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 30, 2001 11:41 AM Subject: RE: Help me! My brain won't start I knew that. We are using CFMODULE because the files reside in a centralized CodeResources directory. What I need help with is passing the array. Russel Madere, Jr. Senior Web Developer ICQ: 5446158 http://www.TurboSquid.com Some days you eat the bear; some days the bear eats you. -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Monday, April 30, 2001 10:11 To: CF-Talk Subject: RE: Help me! My brain won't start you can use CF_Whatever and as long as whatever.cfm is in the same directory OR in the custom tags directory you should be fine. -Original Message- From: Russel Madere [mailto:[EMAIL PROTECTED]] Sent: Monday, April 30, 2001 8:00 AM To: CF-Talk Subject: Help me! My brain won't start I'm getting ready to implement a custom tag that needs to have an array passed. Can I just do: CFMODULE template=whatever.cfm arrWhatever=#VARIABLES.arrWhatever# Or should I do: CFMODULE template=whatever.cfm arrWhatever=CALLER.VARIABLES.arrWhatever My brain is so fried this morning, I just can't even conceptualize an answer. I must remember to skip the Jazz and Heritage Festival next Sunday. Russel Russel Madere, Jr. Senior Web Developer ICQ: 5446158 http://www.TurboSquid.com Some days you eat the bear; some days the bear eats you. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT but VIQ: Denial of Service Attacks
PoisonBox is a rather infamous group of hackers...if they want in, they can get in. I believe they where the group that bragged of hacking 200+ Chinese websites recently, and got mentioned in Wired... Take a look at the time the files were altered, look in your log files around those times. See if you can find out what urls where requested, or see of any other abnormal activity was going on. Make sure all of the below holes are patched or taken care of too. http://www.wittys.com/files/mab/iis-hacking.html jon - Original Message - From: Erika L Walker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 30, 2001 12:49 PM Subject: OT but VIQ: Denial of Service Attacks A client of mine got hacked over the weekend. The hacker was PoisonBOx or someone posing as PoisonBOx. They only infected default.asp, index.asp and default.htm, index.htm pages. Thankfully, on this particular box, we don't use any of them. Obviously there are vulnerabilities lurking around in IIS4/SP6 that need to be addressed and the client is now in the process of making sure each and every patch/hot fix that exists is in place and that permissions are set up as they should be. My question is, has anybody else been affected by this particular hacker, and if so, did you ever find out how exactly they got in? A search on PoisonBOx turned up 74 results, with news articles from websites being hacked, etc. But I can't find anything on whether or not they figured out how the *^%#@ got in! Ahh, Monday morning. how sweet it is. Thanks for any feedback..., Erika Whatever you can do, or dream you can, begin it. Boldness has genius, power, and magic in it. - Goethe ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Creating a Dynamic Menu
I believe MSNBC uses some sort of custom ActiveX control. You can get the same look and feel though. with a Javascript/DHTML script that others have mentioned. Just dynamically generate the Javascript with CF. If you are worried about performance, you could get real slick, and generate your menu as a wddx packet in cf, pass the wddx to a javascript wddx parser and do all the hard work in javascript, this also lets the browser cache the menu since it's javascript now. jon - Original Message - From: Steven A. del Sol [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 30, 2001 5:20 PM Subject: RE: Creating a Dynamic Menu My request is not generic. I gave a specific URL. I am trying to make the same look and fell as the one at MSNBC. It is content driven and as you can tell from the source code created with something like generator. I give respect where due. I admit that I have seen some real lame answers on this board to some real lame questions. I appreciate all help I receive. Now, I can create a flash driven menu but then I must require the user to have one more piece of technology. I am a minimalist. Flash is great on a gaming site or even on a portfolio but if you look at the top ecommerce and content driven sites Flash is virtually unseen. Why? Its a waste of time, and prevents a good number of users from a smooth web experience. I believe that I can create the Menu options in DHTML for 4.0 browsers and up. Since, I intend to serve the pages dynamically, I was thinking about the workload to the server. This board has alot of top notch talent. I was hoping that someone might give me a hint or idea that might push me in the right direction. Not the cynical answer. my point is this: your request is about as generic as hey i want to make a web page, any ideas? well, do you want to make a DHTML menu? will it be only for IE or do you want it for IE and NN? do you want it to work on macs or just PCs? how many levels of menus should it have? i just built a very lean menu that is actually quite powerful that works in IE 5.0 and above and netscape 4.x and above. works on PCs and macs. most everything i looked at on the net didn't work for what i wanted to do. in the end i just wrote my own. so before you start casting smart ass in your subject, maybe you should learn something. which is exactly what i meant by view source. -Original Message- From: Steven A. del Sol [mailto:[EMAIL PROTECTED]] Sent: Monday, April 30, 2001 12:21 PM To: CF-Talk Subject: RE: Creating a Dynamic Menu - SMART @SS Wow, now why didn't I think about that Any Real Help? At 10:37 AM 4/30/2001 -0700, you wrote: view source. -Original Message- From: Steven A. del Sol [mailto:[EMAIL PROTECTED]] Sent: Monday, April 30, 2001 9:32 AM To: CF-Talk Subject: Creating a Dynamic Menu I would like to create a Dynamic Menu like the one on MSNBC.COM using CF. Does anybody have any ideas? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF-Talk-list V1 #306 - Viewing PDF
Just make a standard link to the pdf, Acrobat Reader installs itself as a browser plugin by default, so it should always open in a browser window. jon - Original Message - From: Mark Smeets [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 01, 2001 2:06 PM Subject: Re: CF-Talk-list V1 #306 Any idea how you can turn a certain area of a webpage into a viewing pdf area? I want a certain area on my webpage to open up to a pdf file, not an entirely brand new window (or take up the current one) (and not necessarily use frames either...which I guess could be a cfinclude) Mark Smeets/stranger0/ICQ #1062196 Mr. West, not every situation requires your patented approach of shoot first, shoot later, shoot some more and then when everybody's dead try to ask a question or two - Wild Wild West A Stranger's Domain (Redesigned and New) http://24.113.34.178/stranger Official Splitting Adam Homepage http://www.splittingadam.com/ Over the Wall Productions and Web Designs http://www.solarcourt.com/ ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: JOIN queries from two datasources
You dont need CF5 for this...still have not found a good use for the query a query feature ;-) This is from a previous message to the list. You can access all SQL Server databases fully as long as you have at least one odbc connection to the database server on the web server. I have not fully tested to see if there could be a security problem, but this works for me. From: Costas Piliotis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 26, 2001 1:03 PM Subject: RE: SQL Joins with multiple databases Use the fully qualified table name: database Name.owner.tablename For example: use hr Select * from dbo.tblEmployees INNER JOIN hrdatabase2.dbo.EmployeeInfo ON dbo.tblEmployees.EmployeeID = hrdatabase2.dbo.EmployeeInfo.EmployeeID jon - Original Message - From: Duane Boudreau [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 01, 2001 2:41 PM Subject: RE: JOIN queries from two datasources You need CF5's Query a query feature for this -Original Message- From: Diana Nichols [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 1:52 PM To: CF-Talk Subject: JOIN queries from two datasources Sorry if this has been asked before Can I join two queries from two different datasources (SQL 2000)? I need to relate the username/userID from source 1 to userID from source 2. (If it's too difficult, I'll just copy the username into source 2). TIA! D * Diana Nichols Webmistress http://www.lavenderthreads.com 770.434.7374 One man's magic is another man's engineering. ---Lazarus Long ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Client Variables
Ok, I upgraded my local machine to SQL Server 2000 today, and I didn't move over the cfvar db where I keep my client vars, because it's my dev machine and it's not really important anyway. I went into the administrator one, and tried to delete the cfvar listing in the administrator and got an error stating: Invalid client variable storage specified. The name you specified, 'CFVAR', has not been enabled as client variable storage Now whenever I even try to get into the administrator it throws the same error. So I went into the registry and changed the HKEY_LOCAL_MACHINE\SOFTWARE\Allaire\ColdFusion\CurrentVersion\ClientStores\D efaultStore key to null, registry, another datasource...nothing affects the error, it stays the same. This is with CF 5b3 so it might be a beta issue, if it is i'll ask this there. Any ideas though? jon ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: pass form.variable by URL
Since the variable part of the url in the popup, the variable is now in the
url scope and is called msg. Try referencing the variable without a scope
with #msg# or with the correct scope #url.msg#. Both should work.
jon
- Original Message -
From: FARRAH NG [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, May 01, 2001 10:42 PM
Subject: pass form.variable by URL
I am trying to pass a form.variable to another cfm page but with no
success. I have a form variable call INFO and my code of trying to
pass the variable through window.open using URL is like :
input type=button value=go onclick=window.open('cfoutput
myaction.cfm?msg=#form.info#/cfoutput\,'','height=300,width=300');
and CF server returns an error since it does not recognize #form.info#
within the window.open. I tried to replace #form.info# with
info.value but it makes no different.
If there is anyone have any idea please give me a hand.
thanks
--
Global Internet phone calls, voicemail, fax, e-mail and instant messaging.
Sign-up today at http://www.hotvoice.com
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT - Good list for HTML questions
You need not go further than http://www.evolt.org The general web design list out there imo. jon - Original Message - From: Perez, Bismark [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 02, 2001 11:16 AM Subject: OT - Good list for HTML questions Hello there, Can somebody recommend a good list to ask HTML questions, I have this page which looks good under IE, but some how it looks terribly wrong under NS, or if there is a site that will shed light on how to do things so they'll be cross-browser... TIA Bismarck Perez ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: custom tag for a progress meter
Which means they are using makeunique. It's not a bug, it's a feature... Warn me if you ever make a custom tags that use cffile. jon - Original Message - From: Peter Tilbrook [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 02, 2001 6:58 PM Subject: RE: custom tag for a progress meter NOTE: There is a problem with the DevExchange and it changes the fielname to ACsomethign or the other.zip They are just using the MAKEUNIQUE attribute for filenames. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: IE 6 (whistler)
To put it all in one email. WindowsXP = Finally moving the consumer Windows to the NT codebase, replacement for WinME/98 WinXP Pro = Like 2000 Professional except it shares the UI with the regualr XP (ugh) Win 2002 Server Win 2002 Adv Server I do not know what the UI's for 2002 will look like, I am really really hoping they are similar to Win2k. The .Net components will not come with any of the operating systems, they have been delayed. If I remember correctly .Net will be an addon released later. jon - Original Message - From: Howie Hamlin [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 03, 2001 9:39 AM Subject: Re: IE 6 (whistler) The next version of Windows will be Windows 2002 BTW... Howie - Original Message - From: Dave Watts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 03, 2001 9:27 AM Subject: RE: IE 6 (whistler) What is the difference between Windows Whistler and Windows XP? If I understand correctly, Whistler was the code name for the beta of the next version of Windows, which is based largely on Windows 2000. Windows XP is the actual name for the next consumer version of Windows. Neither of these things have much to do with IE 6, specifically. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Access ldb files w/a twist
The cfusion_disable_dbconnections() works fine, however, just call your host, and tell them to uncheck the box that says 'Maintain database connections'. Then curse at them because they are not following SOP for Access databases ;-) ldb's will not be a problem if this box is unchecked. jon - Original Message - From: Mark Smeets [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 03, 2001 12:53 PM Subject: Access ldb files w/a twist So, here is my question and basically it's a problem. Now when you open any Access file you get that little annoying ldb file with it, it closes no problem if you're working with Access directly however what if the Access file is on a server and you don't have access to it directly? What if I need to replace that database with a new one (and that stupid ldb file won't go away)? Any ideas would greatly help. Mark Smeets/stranger0/ICQ #1062196 Mr. West, not every situation requires your patented approach of shoot first, shoot later, shoot some more and then when everybody's dead try to ask a question or two - Wild Wild West A Stranger's Domain (Redesigned and New) http://24.113.34.178/stranger Official Splitting Adam Homepage http://www.splittingadam.com/ Over the Wall Productions and Web Designs http://www.solarcourt.com/ ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Problem with login page
So what is the name of the password field on your login page? Is it UserPassword? jon - Original Message - From: Hubert Earl [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 03, 2001 7:15 PM Subject: Problem with login page hi. when i submit my login page i get this error message: Error Diagnostic Information An error occurred while evaluating the expression: #Form.UserPassword# Error near line 8, column 15. -- -- Error resolving parameter FORM.USERPASSWORD The specified form field cannot be found. This problem is very likely due to the fact that you have misspelled the form field name. The error occurred while processing an element with a general identifier of (#Form.UserPassword#), occupying document position (8:14) to (8:32). This is the code I'm submitting, but darned if I could find anything wrong with it: CFQUERY NAME='CHECK' DATASOURCE='Clico' SELECT * FROM User WHERE UserName = '#Form.UserName#' AND Password = '#Form.UserPassword#' /CFQUERY I've checked datasource name etc. Could anyone suggest what I may be overlooking? Thanks. --- Hubert Earl ICQ#: 16199853 AIM: hubertfme My Jamaican Art, Craft More Online Store: http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Inline HTML Editor
ezEdit Free IE only http://www.siteobjects.com/ eWebEditPro Little Expensive NS IE http://www.ektron.com/ jon - Original Message - From: David Cummins [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 03, 2001 5:55 PM Subject: Inline HTML Editor I know this question has been asked a lot, but when I went back to the old emails a lot of the links were broken. Could anyone recommend a cheap/free inline HTML editor which looks like Word, and preferably uses DHTML or Java, but other solutions would be nice too. David Cummins ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Credit Card DB Encryption Methodology
Sounds very secure, of course you might add that the database in question should never be on a web server. The database should only be accessible from behind a firewall which permits only the web server's ip to access the database server. jon - Original Message - From: Tony Schreiber [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 03, 2001 3:52 PM Subject: Credit Card DB Encryption Methodology Ok, I've been reading the last few threads on this and pondering the best way to approach this scenario (storing CC in DB) and I've come up with the following idea: 1) The User's password is stored as a one-way HASH. 2) The Credit Card info (list of cc number,exp date and verification number) is stored as an ENCRYPTED string with the User's raw password as the key. Interface-wise, this requires that: a) the user type in their password when Adding or Updating a credit card record in the db (so it can be encrypted) b) the user type in their password when finalizing an order (so the cc info can be decrypted to be processed) c) When a user changes their password, all cc records in the database must be updated using the old and new passwords But this way, neither the users password, the encryption key nor the cc info is stored unencrypted anywhere on the server. Comments? Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion http://www.is300.net ___The Enthusiast's Home of the Lexus IS300 http://www.digitacamera.com __DigitA Camera Scripts and Tips http://www.linklabexchange.com _Miata Link ECU Data Exchange ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Credit Card DB Encryption Methodology
I just use encrypt/base64 to encrypt cards as sop. Here is my snippet, the key I choose randomly for each site. cfset secret_word_encrypted= ToBase64(encrypt(#string2beEncrypted#,#key#)) cfset secret_word_decrypted= decrypt(tostring(tobinary(#secret_word_encrypted#)),#key#) jon - Original Message - From: Tony Schreiber [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 04, 2001 11:43 AM Subject: Re: Credit Card DB Encryption Methodology Yes, but that's a physical architecture issue. I'm just trying to address the software side. I'm surprised there haven't been more comments on this, seems to have been a pretty hot topic. Also, I've realized no site I've been to seems to store cc info this way (because I'm not prompted for my password) so I wonder what other schemes they are using Sounds very secure, of course you might add that the database in question should never be on a web server. The database should only be accessible from behind a firewall which permits only the web server's ip to access the database server. jon - Original Message - From: Tony Schreiber [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 03, 2001 3:52 PM Subject: Credit Card DB Encryption Methodology Ok, I've been reading the last few threads on this and pondering the best way to approach this scenario (storing CC in DB) and I've come up with the following idea: 1) The User's password is stored as a one-way HASH. 2) The Credit Card info (list of cc number,exp date and verification number) is stored as an ENCRYPTED string with the User's raw password as the key. Interface-wise, this requires that: a) the user type in their password when Adding or Updating a credit card record in the db (so it can be encrypted) b) the user type in their password when finalizing an order (so the cc info can be decrypted to be processed) c) When a user changes their password, all cc records in the database must be updated using the old and new passwords But this way, neither the users password, the encryption key nor the cc info is stored unencrypted anywhere on the server. Comments? Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion http://www.is300.net ___The Enthusiast's Home of the Lexus IS300 http://www.digitacamera.com __DigitA Camera Scripts and Tips http://www.linklabexchange.com _Miata Link ECU Data Exchange ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Access ldb files w/a twist
I did not noticed any performance problem in testing I did a while back, besides, using Access is a performance hit in and of itself. Access cant have too many simultaneous users without serious performance problems of it's own. jon - Original Message - From: Zachary S. Bedell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 04, 2001 11:18 AM Subject: RE: Access ldb files w/a twist The cfusion_disable_dbconnections() works fine, however, just call your host, and tell them to uncheck the box that says 'Maintain database connections'. Then curse at them because they are not following SOP for Access databases ;-) ldb's will not be a problem if this box is unchecked. Not to be ignorant, but... Isn't that a performance hit? I thought keeping the DB open eliminated the extra processing of opening closing it every time it's needed? Am I completely off? Thanks, Zac ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Credit Card DB Encryption Methodology
Yes, I agree your method is much more secure, just harder to snippetize ;-) jon - Original Message - From: Tony Schreiber [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 04, 2001 4:25 PM Subject: Re: Credit Card DB Encryption Methodology That's what I'm doing, but the problem with that is that you have to store the key, unencrypted, somewhere on the server. And one key decrypts your whole slew of credit cards. This way, there's one key for each credit card and it's not store unencrypted on the server... I just use encrypt/base64 to encrypt cards as sop. Here is my snippet, the key I choose randomly for each site. cfset secret_word_encrypted= ToBase64(encrypt(#string2beEncrypted#,#key#)) cfset secret_word_decrypted= decrypt(tostring(tobinary(#secret_word_encrypted#)),#key#) jon - Original Message - From: Tony Schreiber [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 04, 2001 11:43 AM Subject: Re: Credit Card DB Encryption Methodology Yes, but that's a physical architecture issue. I'm just trying to address the software side. I'm surprised there haven't been more comments on this, seems to have been a pretty hot topic. Also, I've realized no site I've been to seems to store cc info this way (because I'm not prompted for my password) so I wonder what other schemes they are using Sounds very secure, of course you might add that the database in question should never be on a web server. The database should only be accessible from behind a firewall which permits only the web server's ip to access the database server. jon - Original Message - From: Tony Schreiber [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 03, 2001 3:52 PM Subject: Credit Card DB Encryption Methodology Ok, I've been reading the last few threads on this and pondering the best way to approach this scenario (storing CC in DB) and I've come up with the following idea: 1) The User's password is stored as a one-way HASH. 2) The Credit Card info (list of cc number,exp date and verification number) is stored as an ENCRYPTED string with the User's raw password as the key. Interface-wise, this requires that: a) the user type in their password when Adding or Updating a credit card record in the db (so it can be encrypted) b) the user type in their password when finalizing an order (so the cc info can be decrypted to be processed) c) When a user changes their password, all cc records in the database must be updated using the old and new passwords But this way, neither the users password, the encryption key nor the cc info is stored unencrypted anywhere on the server. Comments? Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion http://www.is300.net ___The Enthusiast's Home of the Lexus IS300 http://www.digitacamera.com __DigitA Camera Scripts and Tips http://www.linklabexchange.com _Miata Link ECU Data Exchange ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: BANNER AD PROGRAM
One problem you are going to run into with ANY CF banner program is performance first off, secondly is concurrency issues once you move to more than one server. If all you need is a counter, positions, and a random ad then you are safe with just about anything, however once you move to weighted ads concurrency becomes a huge problem. I has to rewrite an entire CF banner program as a stored procedure for those exact reasons. It's smooth as butter now, serving up ~300,000+ weighted banners a day on a load balanced web site. Unfortunately it's not for sale, but keep these issues in mind as you look for a banner program. jon - Original Message - From: William J Wheatley [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 04, 2001 5:01 PM Subject: BANNER AD PROGRAM ok i want a banner ad program that runs in CF what we have now is this www.centralad.com SELL ME =0) i would prefer the source and i would prefer it to be robust =) Bill Wheatley Director of Development AEPS INC Allaire ColdFusion Consulting Partner Allaire Certified ColdFusion Developer http://www.aeps.com ICQ: 417645 954-472-6684 X303 IMPORTANT NOTICE: This e-mail and any attachment to it is intended only to be read or used by the named addressee. It is confidential and may contain legally privileged information. No confidentiality or privilege is waived or lost by any mistaken transmission to you. If you receive this e-mail in error, please immediately delete it from your system and notify the sender. You must not disclose, copy or use any part of this e-mail if you are not the intended recipient. The RTA is not responsible for any unauthorized alterations to this e-mail or attachment to it ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: BANNER AD PROGRAM
None if you dont need to worry about weighted ads or targeted ads. As long as the program does not need to make decisions based upon how many views an ad has had, or which ad it should show now it does not matter. As soon as you need to know which ad to show next, rather than random ads, you have to be updating a counter and selecting it again on the next ad view, if you have two different servers, where you cant cflock the entire program you then have a situation where concurrent users on different servers are being shown the same ad then updating the counter +1 each time, and you just lost a rotation...or you get each rotation but you lose an adview, depending on how you do your math. Since single threading a banner program by making the entire set of queries a transaction is not an option even under moderate load, it can get a little complex. I just personally dont think CF is the best solution for a high transaction banner system... Even SQL Server has problems with concurrency that make it not ideal either. From what I have seen, at least one of the big banner companies uses Oracle not SQL Server... I've been thinking about rewriting the banner program in Java because of the whole concurrency issue. When it comes down to it, CF and SQL SP's are essentially stateless, so the program has to make all it's decisions and updates all at once. That's a whole lot of database traffic. But then again, my statements only really apply for complex, high transaction banner systems, not the majority of sites out there... There is a guy from DoubleClick that occasionally posts here that has a real nice banner program though, wonder how much. ;-) jon - Original Message - From: Jim McAtee [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 04, 2001 5:56 PM Subject: Re: BANNER AD PROGRAM I can understand the potential performance problems, but what kind of concurrency issues do you have if you're storing all ad campaign data in a central database? Jim - Original Message - From: Jon Hall [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 04, 2001 3:45 PM Subject: Re: BANNER AD PROGRAM One problem you are going to run into with ANY CF banner program is performance first off, secondly is concurrency issues once you move to more than one server. If all you need is a counter, positions, and a random ad then you are safe with just about anything, however once you move to weighted ads concurrency becomes a huge problem. I has to rewrite an entire CF banner program as a stored procedure for those exact reasons. It's smooth as butter now, serving up ~300,000+ weighted banners a day on a load balanced web site. Unfortunately it's not for sale, but keep these issues in mind as you look for a banner program. jon ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: What's the best way to deal with inexplicable error messages?
I choose A, which usually ends up leading to C which then ends up with me doing B. ;-) jon - Original Message - From: Hubert Earl [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 04, 2001 4:56 PM Subject: What's the best way to deal with inexplicable error messages? Hi, What's the best way to deal with inexplicable error messages? Is it: a. to slog away at the problem until the solution is found? b. to do something else, then come back after a while? c. to redo the code from scratch? I'd appreciate words of wisdom from cooler, more experienced heads, since there *must* be a way to avoid the enormous frustration I often feel while coding! :-) Hubert --- Hubert Earl ICQ#: 16199853 AIM: hubertfme My Jamaican Art, Craft More Online Store: http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF Studio and UltraDev Merging
Set Studio as your external code editor and press ctrl-e jon - Original Message - From: Jon Dunn [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, May 05, 2001 6:56 PM Subject: Re: CF Studio and UltraDev Merging! ABSOLUTELY jd From: Al Musella, DPM [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Sat, 05 May 2001 18:48:53 -0400 To: CF-Talk [EMAIL PROTECTED] Subject: RE: CF Studio and UltraDev Merging! I would love to see them combined. Add studio's code editor to the UD WYSIWYG editor - how can you beat that combination. Make it seemless to switch back and forth! I never could get Studios design mode to work right - just replace it with UD! Al At 03:02 PM 5/5/2001 -0700, you wrote: Have to drop my viewpoint in on this as well just in Case MM is reading this. I have both UD and Studio available to me and I use Studio Edit Mode exclusively. So PLEASE PLEASE don't screw up Studio by trying to make it a Wizzy wig. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cflock?? dead brain, Help!
Why are you selecting all of the records to get a recordcount? Selecting that many records is going to kill CF. That part should be gotten rid of. This is what is causing your server to crash. CFLock will not stop other people from writing to the database on other parts of the site. It would only keep multiple users from executing the code on that one page. If you really really need the recordcount, use a stored procedure to return it back to CF. jon - Original Message - From: Art Broussard [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 07, 2001 11:12 AM Subject: cflock?? dead brain, Help! Ever had one of those weekends that are so great that it makes you forget everything come monday morning. I did and now I cant read/understand anything about locking. So this is the deal. I need to delete all the records from 3 tables. They can have anywhere from 24,000 to 100,000 records in them depending on how long its been since they have been cleaned out. This is what Im doing. i do a select all to get a total record count (not my idea). Next I do a delete all from table. I do this for each of the 3 tables so this can be a real hog and has a problem with killing the server. With all this said, I think I want to use a cflock around each of the table cleaning queries to keep the users from writing to the tables. What would be the best way to do this? Art ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Realtime Background Task
This makes me wonder if Neo will allow us to use Java's inherent threading capabilities easily. I would just love the ability to cfspawn process.cfm or process.class... and have this process have access to all of the CF properties, variables, and whatnot. jon - Original Message - From: Raymond B. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 07, 2001 7:16 PM Subject: RE: Realtime Background Task You could also cfexecute a batch file (w/ 0 timeout) to generate the output. This is done by calling the shell CF interpretter... cfml.exe on NT? (*nix person myself). There's no user wait w/ a 0 timeout but the process will run until completion. Or if you could wait 15min you could use cfschedule to create a run once task. -Original Message- From: Calvin Moree [mailto:[EMAIL PROTECTED]] Sent: May 7, 2001 15:41 To: CF-Talk Subject: Realtime Background Task We are currently using CF 4.5.1 on NT. I have an application where a user inputs data into a form and submits the form to another page that enters the data into the database. What I want to do is at the same time as the data to going into the database, I also want the data to be sent to a totally separate page in the background. If I use CFHTTP the user can't continue until the CFHTTP is complete. I don't want the user to wait because they don't need a response from the background page. I just want to send the data and not retrieve anything back. Is there a tag or code I can use to perform this function? TIA Calvin P.S. The background page is performing several queries. The query results are then used to create a text file. We don't want the user to have to wait for the text file to be created. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Automatic File synchronization between clustered servers.
How are you handling synchronization now? Win2k FRS does this pretty well, and I haven't run into the problems you are seeing. If you are actually running into network contention on the link between the two servers. You may be able to put another NIC in each machine and specify 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 have an issue with a client who has a shared server environment and due to the set up of the site and affiliate sites the client requires image files on both server boxes. The problem is that the images that are uploaded often don't copy to both places because of network contention etc. I 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 ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Log files of a web attack.
A little more info is starting to go around. This attack is a scripted attack from a worm that infects Solaris machines, which then attack up to 2000 IIS servers before putting up the f*ck usa pages on the Solaris machine. Mostly harmless, but you gotta admire the mind that came up with that. Script kiddies who are to lazy to run their own scripts! ;-) I am getting more and more annoyed at Microsoft's poor excuse for a web server every day though. jon - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 08, 2001 9:52 PM Subject: OT: Log files of a web attack. Hi, I thought the group would like to see the techniques of a recent attack on our web servers. They've been doing this a couple times a day for a week. UUNet (their ISP) is slow in doing stopping them. To secure IIS we've removed all extensions except cfm. We've taken out all the iis folders and files like /mdac, /scripts and /printers. We've secured cfide folder with passwords including locking out the user after a couple failed attempts and log the failures. Lastly, we've remove all permissions from cmd.exe. This has kept them out to date. Any additional ideas are welcomed. Non of this is top secret info, the hackers already know it, but do you and are you protected? HTH, Rick Moon 2001-05-08 12:36:44 209.183.204.251 - myIP 80 GET /scripts/../../winnt/system32/cmd.exe /c+dir 404 - 2001-05-08 12:36:44 209.183.204.251 - myIP 80 GET /scripts/..Á%pc../winnt/system32/cmd.exe /c+dir 404 - 2001-05-08 12:36:45 209.183.204.251 - myIP 80 GET /scripts/..À%9v../winnt/system32/cmd.exe /c+dir 404 - 2001-05-08 12:36:56 209.183.204.251 - myIP 80 GET /scripts/..À%qf../winnt/system32/cmd.exe /c+dir 404 - 2001-05-08 12:37:00 209.183.204.251 - myIP 80 GET /scripts/..Á%8s../winnt/system32/cmd.exe /c+dir 404 - 2001-05-08 12:37:00 209.183.204.251 - myIP 80 GET /scripts/..Á.../winnt/system32/cmd.exe /c+dir 404 - 2001-05-08 12:37:04 209.183.204.251 - myIP 80 GET /scripts/..o../winnt/system32/cmd.exe /c+dir 404 - 2001-05-08 12:37:08 209.183.204.251 - myIP 80 GET /scripts/..ð??¯../winnt/system32/cmd.exe /c+dir 404 - 2001-05-08 12:37:08 209.183.204.251 - myIP 80 GET /scripts/..ø???¯../winnt/system32/cmd.exe /c+dir 404 - 2001-05-08 12:38:17 209.183.204.251 - myIP 80 GET /msadc/../../../../../../winnt/system32/cmd.exe /c+dir 404 - 2001-05-03 01:26:07 200.245.48.155 - myIP GET /scripts..\../winnt/system32/cmd.exe /c+dir 404 - 2001-05-03 17:57:58 200.230.112.153 - myIP 80 GET /iisadmpwd/../../../../../../winnt/system32/cmd.exe /c+dir 404 - 2001-05-03 17:58:00 200.230.112.153 - myIP 80 GET /msadc/../../../../../../winnt/system32/cmd.exe /c+dir 404 - 2001-05-03 17:58:14 200.230.112.153 - myIP 80 GET /cgi-bin/../../../../../../winnt/system32/cmd.exe /c+dir 404 - 2001-05-03 17:58:22 200.230.112.153 - myIP 80 GET /samples/../../../../../../winnt/system32/cmd.exe /c+dir 404 - 2001-05-03 17:58:29 200.230.112.153 - myIP 80 GET /_vti_cnf/../../../../../../winnt/system32/cmd.exe /c+dir 404 - 2001-05-03 17:58:36 200.230.112.153 - myIP 80 GET /_vti_bin/../../../../../../winnt/system32/cmd.exe /c+dir 404 - 2001-05-03 17:58:42 200.230.112.153 - myIP 80 GET /adsamples/../../../../../../winnt/system32/cmd.exe /c+dir 404 - 2001-05-05 02:43:02 200.245.48.132 - myIP 80 HEAD /aaa - 404 - 2001-05-05 02:43:04 200.245.48.132 - myIP 80 HEAD /carbo.dll - 404 - 2001-05-05 02:43:04 200.245.48.132 - myIP 80 HEAD /cgi-win/uploader.exe - 404 - 2001-05-05 02:43:06 200.245.48.132 - myIP 80 HEAD /search97.vts - 404 - 2001-05-05 02:43:08 200.245.48.132 - myIP 80 HEAD /_vti_inf.html - 200 - 2001-05-05 02:43:10 200.245.48.132 - myIP 80 HEAD /_vti_pvt/service.pwd - 404 - 2001-05-05 02:43:12 200.245.48.132 - myIP 80 HEAD /_vti_pvt/users.pwd - 404 - 2001-05-05 02:43:13 200.245.48.132 - myIP 80 HEAD /_vti_pvt/authors.pwd - 404 - 2001-05-05 02:43:17 200.245.48.132 - myIP 80 HEAD /../autoexec.bat - 404 - 2001-05-05 02:43:17 200.245.48.132 - myIP 80 HEAD //config.sys - 404 - 2001-05-05 02:43:20 200.245.48.132 - myIP 80 HEAD /iisadmpwd/achg.htr - 404 - 2001-05-05 02:43:20 200.245.48.132 - myIP 80 HEAD /iisadmpwd/aexp.htr - 404 - 2001-05-05 02:43:21 200.245.48.132 - myIP 80 HEAD /iisadmpwd/aexp2.htr - 404 - 2001-05-05 02:43:21 200.245.48.132 - myIP 80 HEAD /iisadmpwd/aexp2b.htr - 404 - 2001-05-05 02:43:24 200.245.48.132 - myIP 80 HEAD /iisadmpwd/aexp3.htr - 404 - 2001-05-05 02:43:24 200.245.48.132 - myIP 80 HEAD /iisadmpwd/aexp4.htr - 404 - 2001-05-05 02:43:25 200.245.48.132 - myIP 80 HEAD /iisadmpwd/aexp4b.htr - 404 - 2001-05-05 02:43:25 200.245.48.132 - myIP 80 HEAD /iisadmpwd/anot.htr - 404 - 2001-05-05 02:43:27 200.245.48.132 - myIP 80 HEAD /iisadmpwd/anot3.htr - 404 - 2001-05-05 02:43:27 200.245.48.132 - myIP 80 HEAD /cgi-bin/visadmin.exe - 404 - 2001-05-05 02:43:29 200.245.48.132 - myIP 80 HEAD /scripts/no-such-file.pl - 404 - 2001-05-05 02:43:29 200.245.48.132 -
Re: cfloop vs cfoutput
And now to inject a little more uncertainty... Just a couple of months ago an Allaire consultant told me that cfloop was the second slowest tag after cfmail. Always use cfoutput to output queries. I imagine he was speaking relatively though. I can think of some really slow tags. jon - Original Message - From: Critter [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 09, 2001 1:37 PM Subject: Re: cfloop vs cfoutput Hello Kola, This is from the Certified ColdFusion Developer Study Guide: pg 37 Tip #1 crit_quote The function of the query loop is the same as using cfoutput with a query attribute. For performance reasons, use a Query loop rather than a CFOUTPUT query=qAny loop. Before ColdFusion 4.x, the CFoutput query=qAny query loop performed better. Generally speaking you should use a cfloop with a query attribute when doing all, or mostly, processing in the loop. If there is nothing in the loop but display, use cfoutput /crit_quote So what's right? -- Best regards, Critter --- Wednesday, May 09, 2001, 11:50:56 S2k, you wrote: KO Sorry for the crosspost (had conflicting answers from other lists) KO but is there a consensus on which method of looping over a query is fastest? KO cfloop or cfoutput.. KO Cheers KO KOLa KO ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfloop vs cfoutput
I think that has made it into Hals Helms worst practices list. Learn to use SQL joins and this is never necessary. jon - Original Message - From: Adkins, Randy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 09, 2001 1:08 PM Subject: RE: cfloop vs cfoutput You can have a CFQUERY tag between CFOUTPUT/CFOUTPUT Tags I have done that many times Example: CFOUTPUT QUERY=MINE CFQUERY NAME=YOURS This that and the other thing /CFQUERY Back to Square One /CFOUTPUT -Original Message- From: Gregory Harris [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 12:33 PM To: CF-Talk Subject: Re: cfloop vs cfoutput No question on that one, CFOUTPUT beats CFLOOP by a long shot, however sometimes you have to use CFLOOP for things, like if you wish to have a CFQUERY tag in your CFOUTPUT statement which wouldn't be possible, you'd have to use CFLOOP Gregory Harris Web Developer The Stirling Bridge Group, LLC *We Engineer Internet Business Solutions* TEL: (949) 707-1534 FAX: (949) 707-1535 - Original Message - From: Kola Oyedeji [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 09, 2001 8:50 AM Subject: cfloop vs cfoutput Sorry for the crosspost (had conflicting answers from other lists) but is there a consensus on which method of looping over a query is fastest? cfloop or cfoutput.. Cheers KOLa ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL 7 Question
The dbms needs to support it, but yeah it's known. I guess the only limit would be the amount of time you want that connection open to the database server. It is not the equivalent to a transaction. I thought so also until Dave Watts corrected me a little while ago ;-) Each different command between the cfquery tags is it's own seperate transaction. Same as in a stored procedure. You have (I'm almost sure) three transactions in the below statement. In order to make all of the below statements a single transaction, put BEGIN TRANSACTION at the beginning, and COMMIT TRANSACTION at the end. As you have it now, two concurrent users could execute the cfquery at the same time, and potentially get unpredictable results. What happens if they both hit it at the same time and the two updates run before either of the selects? @max is probabaly going to be off... jon - Original Message - From: Paul Smith [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 09, 2001 9:36 PM Subject: SQL 7 Question I've been putting one SQL statement after another like the following inside a CFQUERY for a while. Seems to work fine. UPDATE MAX_ID_Clients SET MAX_ID_Client = MAX_ID_Client + 1 DECLARE @MAX INT SELECT @MAX = MAX_ID_Client FROM MAX_ID_Clients INSERT INTO ClientData(CFID,CFTOKEN) VALUES(@MAX,#CFT#) Is this a known feature? Is there a limit to how many SQL statements can be combined this way? I assume the above is equivalent to a CFTRANSACTION. Is this so? best, paul ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: XML and Java training?
Sun does training. http://suned.sun.com/HQ/developers/ jon - Original Message - From: Braver, Ben [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 10, 2001 12:47 PM Subject: OT: XML and Java training? My boss and I are being asked by hq to get training in XML and Java. Can anybody in this multi-disciplinary group of wizards recommend a training source? (We're in the San Francisco Bay Area.) Thanks! Ben Braver Information Technology Ultramar Inc. Golden Eagle Refinery 150 Solano Way Martinez, CA 94553-1487 (925) 370-3673 voice (925) 370-3393 fax (510) 716-2557 pager [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Harpoon Release is Final Available
Out of curiosity, how is data transferred now? Is it still xml? jon - Original Message - From: Steve Drucker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 14, 2001 1:06 PM Subject: RE: Harpoon Release is Final Available It's gone...the Harpoon documentation details various best practices for transferring information from ColdFusion to Flash. Using WDDX at this time, regrettably, is NOT a best practice. Regards, Steve Drucker CEO Fig Leaf Software -Original Message- From: Evan Lavidor [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 12:30 PM To: CF-Talk Subject: RE: Harpoon Release is Final Available I seem to remember that in some of the early betas for Harpoon there was an actionscript file for reading WDDX packets in Flash. Did this disappear? Or did it simply become subsumed into some of the FLA's. If the latter is true, could someone point me to the right place to find it? If it's gone, is there a reason? Thanks, Evan -Original Message- From: Sam Coe [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 10:29 AM To: CF-Talk Subject: Harpoon Release is Final Available We are happy to announce the availability of The Macromedia Flash Component Kit for ColdFusion. The kit, first announced in November 2000 under the code name 'Harpoon', is now available for download from the ColdFusion Developers Exchange. The Macromedia Flash Component Kit for ColdFusion is a resource for ColdFusion developers to quickly and easily add Macromedia Flash elements to their Web applications. ColdFusion developers can immediately take advantage of the design and delivery benefits of Macromedia Flash and Macromedia Flash Player without learning a new authoring product. For more advanced developers, the Component Kit provides guidelines and documentation for creating and customizing new Macromedia Flash components for ColdFusion that can be shared with other developers. The Component Kit includes 4 prebuilt Macromedia Flash sample components, guidelines detailing how to use and customize components and ColdFusion custom tags that control the behavior of those components. The four Macromedia Flash sample components included with the kit are: *Calendar *Calculator *Horizontal Menu *Cascading Menu (for Microsoft Internet Explorer) The Component Kit is available for free download from the Allaire Developers Exchange for the Windows and UNIX platforms. To access the components, type Macromedia Flash into the Developers Exchange Search window (http://devex.allaire.com/developer/gallery/index.cfm) or visit the following page to link directly to the kit: http://www.allaire.com/handlers/index.cfm?ID=20983 The FAQ and license agreements are also available on this page. Best, -Sam ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL Server 7 book(s) recommendation
I bought Lan Times Guide to SQL, and it was a good book to get my feet wet. It doesn't get into anything SQL Server specific though, and sticks to the standards. I also got the black Using SQL Server 7 from Que. I was totally underwhelmed, stay away from it. I now have 2 of the SQL Server 2000 Complete Reference books from Osborne which are great but 2000 specific so they wont help you. I'm not much help, but more info never hurts... jon - Original Message - From: Aidan Whitehall [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 15, 2001 8:28 AM Subject: OT: SQL Server 7 book(s) recommendation My SQL is a bit ropey and I want a decent book or two to plough through. I'm going to be working with SQL Server 7, so it would be great if anyone can recommend a book that covers both standard SQL (not necessarily from ground zero) and T-SQL as well. If not, are there two separate books you can recommend? I've bought SAMS Teach Yourself SQL in 21 days and am not all that impressed... Any thoughts? Thanks -- Aidan Whitehall [EMAIL PROTECTED] Netshopperuk Telephone +44 (01744) 648650 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: blank cfm page in Netscape
You are missing your /html tag If a page is coming up blank in Netscape, 95% of the time it's because there is either an extra tag or a missing tag. For me putting the html in a validator usually shows the problem right away. http://www.htmlhelp.com/tools/validator/ jon - Original Message - From: Robert Orlini [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 15, 2001 4:40 PM Subject: blank cfm page in Netscape I have a search page using Cold Fusion's Verity engine. In IE the page displays fine. In Netscape 4.04 it displays a blank page. I had this happen once before with form fields, but forgot how I licked it. Is this a Netscape problem? Any ideas? Thanks. Robert Orlini HWW FYI---Here is the page source when it displays blank... HTML HEAD TITLESEARCH/title /head body bgcolor=#FF background=images/newhome/bg.gif topmargin=0 leftmargin=0 rightmargin=0 marginwidth=0 marginheight=0 link=#00 vlink=#00 alink=#3D5F9C div align=center table border=0 cellpadding=0 cellspacing=0 width=100% center tr td background=images/newhome/bg_nav.gif height=41 width=100% div align=center table border=0 cellpadding=0 cellspacing=0 width=663 height=41 tr td background=images/newhome/bg_nav.gifmap name=FPMap0 area href=default.cfm shape=rect coords=8, 1, 138, 40 area href=default.cfm shape=rect coords=609, 17, 662, 40/mapimg border=0 src=images/newhome/top_nav.gif usemap=#FPMap0 width=662 height=41/td /tr /table /div /td /tr /centertrtd width=100% div align=center table border=0 cellpadding=0 cellspacing=0 width=663 height=20 tr center td width=663 valign=middle height=30 p align=right /td /center /tr /table /div /td /tr tr td width=100% div align=center FORM METHOD=post ACTION=SEARCH2.CFM p align=left font face=Arial size=2 INPUT NAME=searchstring SIZE=25 input type=image border=0 src=http://www.hwwilson.com/images/botbuttons/bsearch2.gif; alt=Click To Search HW Wilson name=I1 Value=search width=74 height=18 /font /form ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: .cfm extension and URLs
I remember reading this a long time ago. The article said that search engine spiders could get lost in dynamic sites, because as we know potentially a site could have thousands of links, so they didn't index anything with query strings or non html sites. However I think if it was ever true, it certainly isn't today. A quick search for .cfm returned 9.5 million hits even fuseaction which according to his theory wouldn't return any results since every single page on a Fusbox site has a query string returned 690,000 hits. I'd be willing to bet that out of the top 20% of sites on the internet (since they get the majority of the hits) well over half are dynamic these days. I hope he isn't paying this search engine guy a lot of money. jon - Original Message - From: Bud [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 15, 2001 3:20 PM Subject: .cfm extension and URLs Hi all. I'm having an argument with a client about the cfm extension. He's got a guy doing his search engine optimization that is insisting that search engines won't follow any extension other than .htm and ..html. I'm telling him the search engines don't care as long as they don't end in .cgi or have a query string in the URL. Am I wrong? Any documentation you can point me to one way or the other? Thanks a bunch! -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: the big export...ColdFusion.NET?
Michael, before you go and learn VB, realize that vb is morphing into vb.net. Although the syntax is similar, the changes/improvements are quite drastic. You may want to skip picking up a book on the old VB and concentrate on learning the new stuff. Microsofts site is a great place to start though. bigfatsegue The whole dotNet thing is very interesting... Microsofts try at interpreted code, like java. Which leads me to think back to Macromedia's repeatedly saying dotNet in the press release that they were commited to dotNet. It isn't too far of a stretch to say that Neo may be ported to dotNet, and specifically C#, which is basically java anyway. The more I think about it, the more I think it's a no brainer for Macromedia to do a C# port. It will probably run much faster on Windows. The only risk would be confusing the users as to which is better. That's my random Friday thought. Anyone have any comments? /bigfatsegue jon - Original Message - From: Michael Lugassy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 18, 2001 10:57 AM Subject: Re: the big export thanks for the tip, paul! I keep seeing this learn VB tips and I was wondering - are there any good and quick resources on learning VB on the net? something you know about?? Michael. - Original Message - From: Paul Mone [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 18, 2001 12:49 AM Subject: RE: the big export This is definately something I would consider off-line processing. In most cases, CF is not suitable for these types of tasks, espcially if it's a task that you'll have to repeat on scheduled basis. If this is a one-time event (are you sure? :) ) then you can way the time for development vs. time of processing. one time operation? Developing it in CF is probably the quickest solution. Won't be the quickest app in the world. recurring task? Do it in C, or even better, VB. It would be quicker to develop this in VB than C, and the performance increase that C would give you is probably negligible. Writing an offline recurring task like this in CF would be a mis-use of your CFServer's resources. --- Paul Mone Ninthlink Consulting Group [EMAIL PROTECTED] 619.222.7082 -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 9:49 AM To: CF-Talk Subject: the big export I need the fastest way to export 100s of 1000s of text files into a database. I need each file in a a new row like this: file1name, file1content file2name, file2content CF is too slow for this, what can I use? Thanks, -=Michael. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: File Maker
Filemaker 5 has a limited ODBC driver. It sorta works, but expect problems. Your best bet is to schedule a FMP script to export a delimited text file on a schedule. Then import that into the database on the web site. I have a project coming up where the clients internal database runs filemaker. The current plan is to export the tracking data from fmp twice daily, which will be picked up by a java app (which btw I am developing right now, on my own time so I can release it for free...) which will translate to wddx and post to the web site. There is a white paper on filemaker.com that explains how they implemented an online store with fmp as a backend database. It may help you out. jon - Original Message - From: Brian Thornton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 18, 2001 10:03 PM Subject: File Maker Has anyone connected FileMaker to CF? Is It CF Compliant? Thanks, Brian ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: What a task!
How many thumbnails are there going to be? It might be more cost effective to train a peon (no offense to any peons out there;-)) to use a screenshot program jon - Original Message - From: Michael Lugassy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 18, 2001 8:03 PM Subject: What a task! I got this assignment recently: I need to create a thumbnail view of the front/home page of a given site. that should be done automaticlly, ofcourse. for example: I run this: CF_THUMBSITE site=http://www.imvamp.com;; somehow I need to grab all of the site content and PICTURE IT as it were on a browser. this gots you thinking, ha? I know http://www.girafa.com does something similiar. if anyone can solve this, I'm hearing! :) Thanks, -=Michael ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [Re: Automatic File synchronization between clustered servers.]
Windows 2000 File Replication System. It's built into Win2k. http://www.labmice.net/FileMgmt/FRS.htm jon - Original Message - From: Julia Phu [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 18, 2001 11:14 PM Subject: Re: [Re: Automatic File synchronization between clustered servers.] We have a home-grown application to compare files and synchronization from our servers to our business partners' sites. It is written in C++. In term of network connectivity, you can implement using VPN. BTW, what is 'FRS' stand for? Who is the vendor? Where can I look it up? Jon Hall [EMAIL PROTECTED] wrote: How are you handling synchronization now? Win2k FRS does this pretty well, and I haven't run into the problems you are seeing. If you are actually running into network contention on the link between the two servers. You may be able to put another NIC in each machine and specify 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 have an issue with a client who has a shared server environment and due to the set up of the site and affiliate sites the client requires image files on both server boxes. The problem is that the images that are uploaded often don't copy to both places because of network contention etc. I 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 ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: the big export...ColdFusion.NET?
C# is really more along the lines of Java than C, actually a lot closer. If you look at the syntax, it's almost exactly java with a few MS specific things thrown in, that look to make the language a little more approachable. Not to mention it runs on what Microsoft calls a Common Language Runtime. Which is basically just like java's JRE. This is the essence of dotNet. All five of Microsofts major languages( C#, C++, JScript, VB, ASP) will be able to take advantage of it. All of them have seperate compilers except asp of course, but still run on top of the runtime. There are already existing programs that convert C# programs into Java and back again...What makes this really interesting to me is that if Macromedia extends CF to C#, the possibilities for easy access to the dotNet runtime with CF would be very powerful. Actually now that I think about it, as the MS world migrate to XP, dotNet and beyond, it almost seems to be a necessity... MS seems to be trying the same strategy against Sun, that they so successfully used against Netscape. I dont know where I stand, but I'll develop in Java for now. I do know one thing though. Microsoft knows how to write documentation better than anyone around. Their sdk docs blow away the ancient looking docs that come with Sun's JDK. jon - Original Message - From: John McKown [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, May 20, 2001 8:12 PM Subject: RE: the big export...ColdFusion.NET? Pronounced C Sharp, I think it is the successor to C++. John McKown, Owner Delaware.Net, Inc. 30 Old Rudnick Lane, Suite 200 Dover, DE 19901 phone: 302-736-5515 toll free: 888-432-7965 fax: 302-736-5945 e-mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] icq: 1812513 -Original Message- From: Paul Mone [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 7:01 PM To: CF-Talk Subject: RE: the big export...ColdFusion.NET? What is C#? -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 7:36 AM To: CF-Talk Subject: Re: the big export...ColdFusion.NET? Michael, before you go and learn VB, realize that vb is morphing into vb.net. Although the syntax is similar, the changes/improvements are quite drastic. You may want to skip picking up a book on the old VB and concentrate on learning the new stuff. Microsofts site is a great place to start though. bigfatsegue The whole dotNet thing is very interesting... Microsofts try at interpreted code, like java. Which leads me to think back to Macromedia's repeatedly saying dotNet in the press release that they were commited to dotNet. It isn't too far of a stretch to say that Neo may be ported to dotNet, and specifically C#, which is basically java anyway. The more I think about it, the more I think it's a no brainer for Macromedia to do a C# port. It will probably run much faster on Windows. The only risk would be confusing the users as to which is better. That's my random Friday thought. Anyone have any comments? /bigfatsegue jon - Original Message - From: Michael Lugassy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 18, 2001 10:57 AM Subject: Re: the big export thanks for the tip, paul! I keep seeing this learn VB tips and I was wondering - are there any good and quick resources on learning VB on the net? something you know about?? Michael. - Original Message - From: Paul Mone [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 18, 2001 12:49 AM Subject: RE: the big export This is definately something I would consider off-line processing. In most cases, CF is not suitable for these types of tasks, espcially if it's a task that you'll have to repeat on scheduled basis. If this is a one-time event (are you sure? :) ) then you can way the time for development vs. time of processing. one time operation? Developing it in CF is probably the quickest solution. Won't be the quickest app in the world. recurring task? Do it in C, or even better, VB. It would be quicker to develop this in VB than C, and the performance increase that C would give you is probably negligible. Writing an offline recurring task like this in CF would be a mis-use of your CFServer's resources. --- Paul Mone Ninthlink Consulting Group [EMAIL PROTECTED] 619.222.7082 -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 9:49 AM To: CF-Talk Subject: the big export I need the fastest way to export 100s of 1000s of text files into a database. I need each file in a a new row like this: file1name, file1content file2name, file2content CF is too slow for this, what can I use? Thanks, -=Michael. ~~ Structure your ColdFusion code
Re: Setting Dynamic Variables
This is not guaranteed to work with future versions of CF. Look into the setVariable() function. jon - Original Message - From: Bob Silverberg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 21, 2001 9:46 AM Subject: RE: Setting Dynamic Variables You've got the right idea, just the wrong syntax. Try: cfset Type#GetInfo.CurrentRow# = Type Bob -Original Message- From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 9:27 AM To: CF-Talk Subject: Setting Dynamic Variables Trying to create a set of variables dynamically but cannot think of how to do it. Here is what I am trying to do: cfset Evaluate(form.Type GetInfo.CurrentRow) = Type It won't let me use the Evaluate() function on the left side though, does someone know of a way to do this? I can't think of anything. = Bernd VanSkiver [EMAIL PROTECTED] ColdFusion Developer ICQ UIN: 916324 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Setting Dynamic Variables
I'm just going by what I've seen posted here. I've never seen any documentation saying dynamic variables should be named this way, and there is a function to do specifically this. A little deduction leads me to believe that this is an unintended way to go about it. So if it goes away because the underlying way cfset works, kinda like the old 4.0 bad query of and access odbc datasource thing. You probably know better than me though...I'm doing a lot of assuming when it comes down to it ;-) jon - Original Message - From: Raymond Camden [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 21, 2001 10:01 AM Subject: RE: Setting Dynamic Variables Eh? Is it marked for deprecation? If so, it's news to me. (Not saying your wrong, just wondering why you think this.) === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] ICQ UIN : 3679482 My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 9:56 AM To: CF-Talk Subject: Re: Setting Dynamic Variables This is not guaranteed to work with future versions of CF. Look into the setVariable() function. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Tertiary Domain Creation
Two ways I can think of to handle this. First tertiary domains are just subdomains, so there needs to be a dns entry for the subdomain. You can create dns files with coldfusion or anything else, they are plaintext. There may be something like this already built in the dev exchange. A second option if you dont plan on actually using any of the subdomains for anything other than the web site. Add an A record of * to the domain and point it to your web sites ip. Then you could parse the cgi.http_host to get the subdomain. cfset myDomain = .test.com cfset subStr = replace(cgi.http_host, myDomain ,,ONE) Here subStr will be your subdomain and now that you have it, you can do whatever you want... jon - Original Message - From: Karl Simanonok [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 22, 2001 6:00 AM Subject: Tertiary Domain Creation Some of you who subscribe to Shanje.com's inexpensive web hosting may have noticed how the Web Control Panel allows you to create tertiary domains on domains that you have installed there (for example the tertiary domain karl.simanonok.com is one of the domains under simanonok.com). One nice thing about tertiary domains is that they don't cost anything extra, but they also can make cleaner URLs (karl.simanonok.com is much better than simanonok.com/karl in my opinion). Does anyone know how to create tertiary domains in code so that their generation can be done remotely as in Shanje.com's web control panel? Please don't bother suggesting that I ask the owner of Shanje.com, I've already tried that and he doesn't want to share that knowledge. I'm thinking it might require some kind of Java crapplet or maybe a COM object that ColdFusion can control. Or maybe they reside in the registry and CFREGISTRY is used? Has anyone done this before? Regards, Karl Simanonok Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Create-edit-delete in Access - TAG
Man, so many responses so few valid answers... ;-) In Studio: File/New/Data Entry Wizard jon - Original Message - From: CF Crazy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 21, 2001 1:54 PM Subject: Create-edit-delete in Access - TAG Does anyone know have a good tag that gives control to create, edit and delete rows and fields using an access database. Steph ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: dynamic looping
The script below is not really suitable for that many pictures. It is
preloads all the pictures you tell it to, so it would be really fast after
the first page, but that first ones a bear! ;-)
You best would be to do what Michael did with the cf community pictures.
Which was to store the path to the pictures in the database and use Stuido's
built in data entry wizard. File/New/Data Entry Wizard.
http://www.houseoffusion.com/users/index.cfm
jon
- Original Message -
From: Jones, Becky [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, May 23, 2001 12:43 PM
Subject: dynamic looping
is there anyway to make this javascript code more dynamic? i dont want to
have to type in each individual picture name. i want to go thru my
employee
directory and that is over 400 people! plus if someone leaves, i will
have
to maintain this. instead i have all these peoples pics in a database. i
want to incorporate a little bit of javascript with my cf. is this
possible
and how would i start. here is the javascript below that i found at
dynamic
drive:
html
head
script language=JavaScript1.2
/*
Blending Image Slide Show Script-
© Dynamic Drive (www.dynamicdrive.com)
For full source code, 100's more DHTML scripts, and Terms Of Use, visit
dynamicdrive.com
*/
function reapply(){
setTimeout(slideit(),2000)
return true
}
window.onerror=reapply
/script
script language=JavaScript1.1
!--
var image1=new Image()
image1.src=firstimage.gif
var image2=new Image()
image2.src=second.gif
var image3=new Image()
image3.src=third.gif
//--
/script
/head
!---If you want more than three images, add the below code to the above:
var image4=new Image()
image4.src=fourthimage.gif
where 4 represents the fourth image. If you have a fifth image, add even
more of those two lines, with 4 changed to 5.
Step 2: Insert the below into the body section of your page ---
body onLoad=slideit()
a href=javascript:slidelink() onMouseover=window.status='Click on the
image to learn more about it!';return true
onMouseout=window.status=''img src=firstimage.gif name=slide
border=0 style=filter:blendTrans(duration=3)/a
script
!--
change number of images below
var number_of_images=3
//change speed below (in seconds)
var speed=3
var step=1
var whichimage=1
function slideit(){
if (!document.images)
return
if (document.all)
slide.filters.blendTrans.apply()
document.images.slide.src=eval(image+step+.src)
if (document.all)
slide.filters.blendTrans.play()
whichimage=step
if (stepnumber_of_images)
step++
else
step=1
if (document.all)
setTimeout(slideit(),speed*1000+3000)
else
setTimeout(slideit(),speed*1000)
}
function slidelink(){
if (whichimage==1)
window.location=link1.htm
else if (whichimage==2)
window.location=link2.htm
else if (whichimage==3)
window.location=link3.htm
}
//--
/script
*
This e-mail, including any attachments, is intended for the
receipt and use by the intended addressee(s), and may contain
confidential and privileged information. If you are not an intended
recipient of this e-mail, you are hereby notified that any unauthorized
use or distribution of this e-mail is strictly prohibited.
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Good resource on CF/XML integration?
Yes. There are some good examples that come with the tag that will answer your questions. jon - Original Message - From: Dave Hannum [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 23, 2001 1:53 PM Subject: Re: Good resource on CF/XML integration? Yea, but how do you grab a .xml page and parse it out into your HTML? I have a company that wants to feed us info, and they have given me a url to a ..xml page. I want to group the info and format the output. Can CF_SOXML do this? Dave - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 23, 2001 11:44 AM Subject: RE: Good resource on CF/XML integration? Yeah, CF_SOXML is an absolutely fantastic tag, I use it all the time for all sorts of things. Well worth downloading and getting into. You should also read up on WDDX - start by looking in the CF Studio help for CFWDDX. Good luck! Alistair Davidson Senior Web Developer Rocom New Media www.rocomx.net -Original Message- From: Dan Phillips [mailto:[EMAIL PROTECTED]] Sent: 23 May 2001 15:53 To: CF-Talk Subject: RE: Good resource on CF/XML integration? I did a quick search on Yahoo and found this. http://www.siteobjects.com/index.cfm?fuseAction=showProducts cf_SOXML version 1.5[r. 01/09/2001] SOXML provides ColdFusion programmers with an easy to use interface for integration of XML with CF. This custom tag is open-source (of course), free, and action based. These actions include: XML2CF (Converts a XML document into a complex CF structure) XML2DOM (Loads the XML document into a valid XML DOM object accessed via CF) XML2HTML (Displays the XML document as IE does but INLINE! very cool for debugging) CF2XML (Transforms any CF variable into a valid XML document) CF2XMLDOM (Transforms any CF variable into a valid XML DOM object accessible with CFML) Transform (Transforms any XML document based on a specified XSL document) I'm sure forta.com and CFDJ would have some info too. Hope that helps! Dan Phillips www.cfxhosting.com -Original Message- From: river [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 23, 2001 10:22 AM To: CF-Talk Subject: Good resource on CF/XML integration? Is there any good resources on CF/XML integration? Any good web sites?? Thanks ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Regular Expressions in CF Studio
It exists already, however there is no documentation that I could find. The closest I was able to find was the the docs for WizML in studio. However there was no documentation of exact syntax. I tried using some of the functions like putting chr(32) in the find window and putting some random text in the replace window and it found no matches. So it didn't execute my simple function call, just search for that text even though the Regular Expressions checkbox was checked. I am missing something... I have wondered about that checkbox...anybody know what's up with it? jon - Original Message - From: Brad Roberts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 25, 2001 12:39 AM Subject: RE: Regular Expressions in CF Studio Sorry. I haven't heard of it, but that would be cool! -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 24, 2001 9:21 PM To: CF-Talk Subject: RE: Regular Expressions in CF Studio I am talking about using regular expressions with the find and replace options in cfstudio, I already read Michaels help file. Bob Everland -Original Message- From: Brad Roberts [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 24, 2001 8:04 PM To: CF-Talk Subject: RE: Regular Expressions in CF Studio I don't think Studio covers it in the docs, but it does provide an expression builder: right click -- Insert Expression. Check out the Power Point tutorial from Micheal Dinowitz on houseoffusion.com http://www.houseoffusion.com/RegEx.ppt Also, http://www.houseoffusion.com/httpagent.ppt HTH, Brad -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 24, 2001 7:43 PM To: CF-Talk Subject: Regular Expressions in CF Studio I can't find how to use Regular Expressions in CF Studio. can anyone proveide an example or a webpage on how to do it. Bob Everland ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFQUERY Update......
I have seen this behavior before under heavy load without using transactions, but it did not happen every time like you are seeing. An update will of course execute but not change the data if the where clause does not match anything. If you can copy the same query into Query Analyzer that shows in the debug and it updates where the cfquery did not, you might want to try moving the query into a stored procedure. Since it works in sql server, might as well keep it there ;-) jon - Original Message - From: JL [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 25, 2001 9:46 AM Subject: CFQUERY Update.. Hi all, I am trying to update a table using CFQUERY. I do not see any error when the query is excuted in CF and I can see the query is correct in the debug mode. But somehow the data is not updated. When I run the same query in SQL Server, the data is updated. Does anybody know why? I am using CF 4.5 and SQL Server 7.0 The query is like this.. UPDATE User SET newpassword = 'arenofun' WHERE ID = 1614 Thanks in advance J ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: bulk updating database from txt file
With 30,000 records it would definitely be to your advantage to think about upsizing to a mere robust dbms. I bet the speed of SQL Servers BCP would cut down that import to less than 30 minutes, if that. jon - Original Message - From: Seamus Campbell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, May 26, 2001 10:26 PM Subject: bulk updating database from txt file Hi I have a largish access database (30,000 records) which needs to be updated from a comma delimited text file. There will be some updated records and some new records. I am not sure how to begin with this My worries are how do I do an update loop when some records will have to be inserted and some updated. Also this would presumably take a long time to do - how do I handle this Any suggestions welcome (assume I am a bear with very little brain) or any tutorials on this sort of thing. many thanks Seamus ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: HTML question
First pick up a good html book. You need to know the basics of html...Osborne's HTML The Complete Reference is the best imo. To answer your questions though. 1. There is no correct way. Do what works with the design. I generally totally rebuild the html mockup from the designer, after the client has given approval. It's not worth the headache of trying to discuss proper table layout's with an artist! ;-) 2. A table will always grow to fit the size of an image. The designer needs to know that there will be an image in a certain place so he can design around it. He is the design guys after all... The way I generally approach a site design it to split it into two files, the top/left and the right/bottom parts. The last tag in the header is a td and the first tag in the footer file is a /td. In the default/index page I cfinclude both, if there is an image or content for the middle of the page I include that as a file in the default page. eg. cfinclude template=head.cfm img src=logo.gif or cfinclude template=frontpage.cfm cfinclude template=foot.cfm Since the center is always in a td/td, you can start another table or just start your content without worrying about invalid html and you dont have a million copies of your navigation to edit if you need to change something. jon - Original Message - From: Heidi Belal [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, June 01, 2001 1:37 AM Subject: HTML question Hi all, I'm a bit confused on a point in html and would very much appreciate it if you could help! I've taken graphics from a graphics designer in html format. Meaning he had designed the whole page in photoshop and then cut it up using fireworks and saved it as html. Therefore what i got from him was a table with all the graphics layed out correctly. The question is: the table i got from him was very complex and not very clear in rows and columns. So it was hard for me to find out where i should stick in my code etc...We worked together after the first version was very complex and managed to get a more simple table in the end, but i was wondering if i should just take the images after they are cut up and create the table myself and insert the images. So which way is it supposed to be done? or does it matter? my second question is: Now that i have the graphics in a table etc...how do i limit the size of the table so that if i put another image in the middle and it's too big the images don't all go separating all over the place? (i hope you understand what i'm trying to say) Your ideas and suggestions would be great! thanks! Heidi = Heidi Belal ICQ# 32127109 A bus stops at a bus station. A train stops at a train station. On my desk I have a work station... ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Updating multiple rows!
Use the IN keyword. Update BiosPart SET VGA_Rom = 'PCI' WHERE Part_ID IN (751,752) I cant remember off the top of my head if there needs to be single quotes around the values in the parentheses. jon - Original Message - From: Ben Densmore [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, June 01, 2001 11:24 AM Subject: Updating multiple rows! I am trying to update multiple rows at once and I don't seem to get any errors but when I try to get the info I just updated nothing is there. Can someone tell me if this Query should work? CFQUERY NAME=engineeringinfo DATASOURCE=Biosreference DBTYPE=ODBC Update BiosPart SET VGA_Rom = 'PCI' WHERE Part_ID = 751 AND PART_ID = 752 etc... Thanks, Ben /CFQUERY ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: REFindnocase - Parsing URL's
Wow, now this is too much of a coincidence. I just opened up my email program to post a message saying I had just successfully written a program that parses url's out of a document, and was just wondering if anyone had a better way to do it. Well here is how I did it. If anyone knows of a faster way I am definately interested. I imagine regular expressions would be much faster... Cfscripting this would most likely make it faster too, but for readability I am leaving it in regular cfml for now. jon **Read html file, you can replace h with your variable cffile action=READ file=c:\www\test\html.htm variable=h **Stick the entire file in an array cfset arrString = ArrayNew(1) cfset rs = ArrayResize(arrString,len(h)) cfloop from=1 to=#len(h)# index=i cfset arrString[i] = mid (h,i,1) /cfloop **Loop through array looking for tags, and mark their positions cfset markArray = ArrayNew(1) cfloop from=1 to=#arrayLen(arrString)# index=i cfif arrString[i] EQ cfset rs = ArrayAppend(markArray,i) /cfif cfif arrString[i] EQ cfset rs = ArrayAppend(markArray,i) /cfif /cfloop **Loop through the array of marks looking for links. **I replace the with lt; just so I can display it. cfloop index=i from=1 to=#arrayLen(markArray)# step=2 cfset linklen = markArray[i + 1] - markArray[i] cfif mid(h,markArray[i],2) EQ a cfoutput #replace(mid(h,markArray[i],linklen),,lt;,ALL)#br /cfoutput /cfif /cfloop - Original Message - From: W Luke [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, June 02, 2001 4:38 PM Subject: REFindnocase Hi, I need to search for any URLs that exist in #tbody# and if so, dump the whole URL into a new variable called #user_URL# I've done a basic REfindnocase to check if there is a URL in the string, but that only finds the position(s). Hw can I then grab the whole of the URL? Cfset z = #REfindnocase(www., #tbody#)# If z returns greater then 0 then continue to get the rest of the URL, otherwise ignore. Any guidance would be appreciated. Will -- Will Free Advertising-=- www.localbounty.com e: [EMAIL PROTECTED] icq: 31099745 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: REFindnocase - Parsing URL's
Simple, just delete the the first line and change the name of your variable to 'h'. This program only parses out the whole a href ... tag though. In order to get just the actual url, I'd probably just stick all of the parsed href tags in another array then parse for href=. I am actually going to extend this program to do this anyway. So I'll make a follow up post with the modified source. I really just needed to do this for a one off program, and it has kinda morphed into something a little more, simply since it's a challenge ;-) If you have access to irc, I will be idling in #coldfusion on efnet. /nick flux0 jon - Original Message - From: W Luke [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, June 02, 2001 5:22 PM Subject: Re: REFindnocase - Parsing URL's Jon, How might I change this to searching inside a variable that contains the text, and not a file as you have done? Will -- Will Free Advertising-=- www.localbounty.com e: [EMAIL PROTECTED] icq: 31099745 - Original Message - From: Jon Hall [EMAIL PROTECTED] Newsgroups: cf-talk Sent: Saturday, June 02, 2001 9:57 PM Subject: Re: REFindnocase - Parsing URL's Wow, now this is too much of a coincidence. I just opened up my email program to post a message saying I had just successfully written a program that parses url's out of a document, and was just wondering if anyone had a better way to do it. Well here is how I did it. If anyone knows of a faster way I am definately interested. I imagine regular expressions would be much faster... Cfscripting this would most likely make it faster too, but for readability I am leaving it in regular cfml for now. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: REFindnocase - Parsing URL's - final code
For anyone else that is interested here is the final code. This program will parse out url's out of any file. Still think there is a better way to do this though... jon cffile action=READ file=c:\www\test\html.htm variable=h cfset arrString = ArrayNew(1) cfset rs = ArrayResize(arrString,len(h)) cfloop from=1 to=#len(h)# index=i cfset arrString[i] = mid (h,i,1) /cfloop cfset markStart = 0 cfset markEnd = 0 cfset markArray = ArrayNew(1) cfloop from=1 to=#arrayLen(arrString)# index=i cfif arrString[i] EQ cfset rs = ArrayAppend(markArray,i) /cfif cfif arrString[i] EQ cfset rs = ArrayAppend(markArray,i) /cfif /cfloop cfset hrefArray = ArrayNew(1) cfloop index=i from=1 to=#arrayLen(markArray)# step=2 cfset linklen = markArray[i + 1] - markArray[i] cfif mid(h,markArray[i],2) EQ a cfset rs = arrayAppend(hrefArray,replace(mid(h,markArray[i],linklen),,lt;,ALL)) !---cfoutput #replace(mid(h,markArray[i],linklen),,lt;,ALL)#br /cfoutput --- /cfif /cfloop cfloop from=1 to=#arrayLen(hrefArray)# index=i cfset starthrefPos = find(http,hrefArray[i],1) cfif starthrefPos NEQ 0 cfset endhrefPos = find(#chr(34)#,hrefArray[i],starthrefPos) cfset urlLength = endhrefPos - starthrefPos cfset url = mid(hrefArray[i],starthrefPos, urlLength) cfoutput#url#/cfoutputbr /cfif /cfloop - Original Message - From: Jon Hall [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, June 02, 2001 6:16 PM Subject: Re: REFindnocase - Parsing URL's Simple, just delete the the first line and change the name of your variable to 'h'. This program only parses out the whole a href ... tag though. In order to get just the actual url, I'd probably just stick all of the parsed href tags in another array then parse for href=. I am actually going to extend this program to do this anyway. So I'll make a follow up post with the modified source. I really just needed to do this for a one off program, and it has kinda morphed into something a little more, simply since it's a challenge ;-) If you have access to irc, I will be idling in #coldfusion on efnet. /nick flux0 jon - Original Message - From: W Luke [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, June 02, 2001 5:22 PM Subject: Re: REFindnocase - Parsing URL's Jon, How might I change this to searching inside a variable that contains the text, and not a file as you have done? Will -- Will Free Advertising-=- www.localbounty.com e: [EMAIL PROTECTED] icq: 31099745 - Original Message - From: Jon Hall [EMAIL PROTECTED] Newsgroups: cf-talk Sent: Saturday, June 02, 2001 9:57 PM Subject: Re: REFindnocase - Parsing URL's Wow, now this is too much of a coincidence. I just opened up my email program to post a message saying I had just successfully written a program that parses url's out of a document, and was just wondering if anyone had a better way to do it. Well here is how I did it. If anyone knows of a faster way I am definately interested. I imagine regular expressions would be much faster... Cfscripting this would most likely make it faster too, but for readability I am leaving it in regular cfml for now. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Resubmit: cfgraph problem
There was a problem with the documentation being incorrect for cfgraph during the betas. If you are still working with a beta, that may be the problem... I dont think the majority of us have CF5 final yet though. IIRC it is supposed to be shipping this week? You will probably get more responses then... jon - Original Message - From: Jim Watkins [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, June 03, 2001 6:47 PM Subject: Resubmit: cfgraph problem Know one responded to this so am resending. Sure would appreciate some help here. Jim - Original Message - From: Jim Watkins [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, June 02, 2001 11:43 AM Subject: cfgraph problem I have tried creating a sample graph in CF 5 using the cfgraph tag but the browser just keeps on churning and never gives me data or error. What am I doing wrong or do I neeed to set up something on the server? Code I used is from documentation and is: cfgraph type=pie title=Income by Department cfgraphdata item=New Vehicle Sales value=50 cfgraphdata item=Used Vehicle Sales value=25 cfgraphdata item=Leasing value=30 cfgraphdata item=Service value=40 /cfgraph Any help would be appreciated! Jim Watkins http://www.ngtcollege.org ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Slightly OT: Javascript Error - Confirmation Box
This will work
function checksure() {
return confirm('Are you sure you want to DELETE the Page you selected? This
will also delete any SUB articles of this item!!');
}
/script
with the onsubmit=return checksure();
confirm() returns a boolean true or false already, no need to recreate it.
jon
- Original Message -
From: Rosa, Issac [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, June 04, 2001 5:32 PM
Subject: Slightly OT: Javascript Error - Confirmation Box
I have the following javascript and form. Can anyone see why I am not
getting the confirm box? No error messages, just processes the form
without
the confirm. Any help would be greatly appreciated.
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Radiant Communications
Most likely Verio does not have their own location in New Orleans. In most cities, Verio just co-locates with someone else. If the building power goes out, or some #$!%ing contstruction workers spray insulation into the ducts causing the AC to shutdown, or the moron on the rack next to you trips and falls on top of your server, or someone forgot to fill the generators with gasoline...there are so many variables... It's usually not Verio's fault is what I'm trying to say ;-) I dont know anyone at Verio, or care, I do know that they do their best though. We are colocated next to them down here, and they are crazy redundant for no reason. They have 2 redundant Cisco 7500's with redundant backbones for 2 stinking managed Sun RAQ's, with a ton of batteries to backup the generators... jon - Original Message - From: Russel Madere [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 04, 2001 5:54 PM Subject: RE: Radiant Communications Verio in New Orleans was worse. A little over a week ago, they lost power for ALMOST 4 hours. Thier power failover failed apparently. Russel Madere, Jr. Senior Web Developer ICQ: 5446158 http://www.TurboSquid.com Some days you eat the bear; some days the bear eats you. -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 16:46 To: CF-Talk Subject: Radiant Communications I host my 4 CF servers at RADIANT COMMUNICATIONS. Vancouver BC Canada... Man, It is so frustrating when the facility we use for co-locating 4 of our servers all of a sudden becomes unavailable and we can not access any of our sites. Going on 10 minutes now, all four of our servers are down. last time (last month) our connection was down for 70 minutes Another time they decided to update the software on our leased fire wall without notifying us effecting disabling our https and smtp services for close to an hour. What's the point in investing time and money in fail over when your bloody ISP can't keep their redundant service running!!! And to add insult to injury, their stinking site (www.radiant.net) is still running just fine. Maybe they out source...grr ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Forcing a refresh
To fix the problem with the form, put the form tags outside the table tags. form... td.../td /form That will remove the line break. To refresh the opening window, you have to use the javascript window.open() to open the new popup (no target=new...). Then in the popup, execute the window.opener.location.reload(). jon - Original Message - From: rkern - Prolynx [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, June 07, 2001 11:48 AM Subject: Forcing a refresh To all, I have a general question that has me stumped for the moment. I have a form with a form button to process a change to a database. That works fine and after submitting the form updates with the new value. However, the form takes up a lot of space when confined to a TD element (it seems to have a line break included). The result is a table using a large amount of space. To reduce the space I made the update a link to another page in a floating window. The update works well as a new javascript window, after the SQL update I close the window but the orginal page does not show the new data until manually refreshed. This is the problem, I need to refresh the original page with the new DB data. I've tried meta refresh on the original page, but results in constant flicker and other non desireable behavior. Adding a CFLocation on the window.close() page does not close the window and shows the update in the window. Any suggestions? Thanks Richard Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Next-N Design
The way I handled this in my next-n tag is to take all form variables and turn them into url parameters. The tag takes all the existing url parameters and form vars with their values, and builds one query string that I append to all of the links the tag generates for the next, previous, and numbered pages... If you want to do it like I did, you will either need to unscope the form.info, change it to url.info, or use cfparam to set the form variable to the url variable's value, if that makes sense... If you want, email me off list and I'll send the source. jon - Original Message - From: Denton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, June 07, 2001 1:13 PM Subject: Next-N Design Hello All, I am trying to get a next-n style list working with my database display and have it almost working perfectly. If I select the columns manually from the database it works fine but if the selections are made based on a form then only the first next-n page works and the following ones show an error based on not know what form.info is. Is there a way I can have the form pass the information on to all my next-n pages? Thanks Very Much! -Denton ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Dynamic Variable Names
The problem you are having is because of the database structure. Those
materials fields need to be in a different table with another field that
relates to the project. Any time you have a 1 to Many relationship like
these 20 materials to 1 project, it cries out for two tables.
Here is some example sql, on how you would get the records, if the table was
split into the two parts.
SELECT Projects.ProjectID, Projects.Description, Materials.Material
FROM Projects, Materials
WHERE Projects.ProjectID = #projectID#
AND Projects.ProjectID = Materials.ProjectID
This way all you have to do is insert into the Materials table a new entry
with the projectid and the material, that's it.
I hope that makes sense...
If it's too late to redesign the database, why not just cfparam all of the
form variables on the action page?
jon
- Original Message -
From: Jen R [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, June 07, 2001 3:16 PM
Subject: Dynamic Variable Names
Ok...I was recently sitting in a meeting with some people in my department
about an application I'm developing. Seeing as I am *the* developer I could
really use some help. It's an estimating/billing application. There is a
possibility of twenty different lines for materials used and twenty slots
for it to go in the database. Pretty simple. I was just going to put in
twenty different drop down boxes for this, which is the way they wanted it
done. Well, not every project will use 20 different materials. Some might
use 2, some might use 10, and some might use 20. My supervisor (who has
enough CF experience to make him dangerous sometimes) thought it looked
cluttered like that so he said we'll let you choose how many lines you want
for materials. we can do that, no problem! he says. So I'm left to figure
out how we are going to do it.
I have the form where they enter in how many lines they want, and I have
the form with that number of lines and corresponding fields. Not a problem
yet, but now here's where I find my difficulty... When I submit this form
to the database I now have to figure out how to do the SQL submit statement
where the number of variables is dynamic. In my database I have the fields
material1, material2, material3, material4,material20 and can build
the first part of the insert statement using a CFLOOP, but when I come to
the Values() part of the insert...how do I dynamically create that.
For example: The user wanted 5 lines for materials. On the form the user
fills out the boxes for material1, material2, material3, material4,
material5. How do I dynamically create the Values('#form.material1#',
'#form.material2#', '#form.material3#', '#form.material4#',
'#form.material5#')? I have tried the Evaluate function before and didn't
have too much luck.
Suggestions? It seems like the whole project hinges on this dynamic
variables problem.
Thank you...thank youthank you!
-
Do You Yahoo!?
Yahoo! Mail Personal Address - Get email at your own domain with Yahoo!
Mail.
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT BUT URGENT: IIS stability
Bite the bullet and reinstall Win2k. I have seen the problem with extremely slow transfers on my home machine. I thought it was a problem with my isp for a long time. Then I reinstalled Win2k and it worked wonderfully again... Patrick Norton of The Screensavers had the same problem too, fixed by a reinstall ;-) We have had win2k/IIS machines running without any rebuilds for over a year now though... SP2 might help too, if you have not upgraded yet... jon - Original Message - From: Alistair Davidson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, June 08, 2001 1:02 PM Subject: OT BUT URGENT: IIS stability Hi guys ( gals) Sorry for the OT post, but I REALLY need help on this one, people's jobs are on the line. We have a serious problem with stability on IIS 5, Win 2K, CF 4.5.2. IIS has suddenly started to die. Symptoms include - - Existing virtual directories get lost. VDir's that have been working fine for 6 months suddenly return This page cannot be displayed IIS errors. If you delete the VDir and recreate it, it works again. - CF pages take forever to return. Flat HTML pages are responding reasonably well, but all the images now take forever to download. Restarting the CF service seems to help, but only for about half an hour, then it returns. - FTP transfer rates have gone down from over 200K / second to about 5 BYTES / second. My first thought was a runaway CF process somewhere, but when we look at performance monitor on the CF/IIS server, CPU usage is only at 5% and memory usage is minimal. Then we thought it might be persistent database locks, but we've eliminated that. Performance monitor on the DB server shows only minimal CPU / memory usage too. We have CF and IIS on one server (Dual PIII 800, 1.3GB RAM) and SQL running on another. The SQL server is set up as the domain controller. CFSTAT shows that the database response time is fine, it's just taking ages for requests to get to from the server. I know that at my last job, IIS was rebuilt as a regular maintenance task every two or three months. This installation of IIS has been for the last five or six months until this last week. And no code has changed in the last three weeks. Has anyone else had similar problems? How often do you all have to rebuild / re-install IIS ? I need some figures to give to the management ASAP, as they're starting to growl for blood. Mail me directly if you like Cheers, Alistair Davidson Senior Web Developer Rocom New Media www.rocomx.net ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: NETSCAPE IS GOING AWAY! A Web Developer's Dream Come True!
No it is not. jon - Original Message - From: John McKown [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, June 08, 2001 1:24 PM Subject: NETSCAPE IS GOING AWAY! A Web Developer's Dream Come True! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: NETSCAPE IS GOING AWAY! A Web Developer's Dream Come True !
This is just too much. Netscape 4.x is old and dying thank god, but NS6 is different and it is not going away. Netscape was arguably superior until around the 4.0's (96-97?) when MS started throwing tons of money into IE. Netscape as a company started to stagnate as many of their top developers flew the coop, and incompetent management took over, then AOL took over totally killing innovation. Then someone decided to pour tons of money updating the 4.5 code when Mozilla was first starting out, which delayed the transition to the Mozilla codebase. While Netscape was busy stagnating, Microsoft has been busy building a pile of non-standard garbage, that only runs on Windows and the Mac. There is nothing at all exceptional about IE, except that MS has continued to invest in it, and it lets lazy html developers eek by without knowing why their code sucks. What many people dont realize is that all of this IE specific code floating around is be a major pita when Microsoft decides that it's time for the world to change and they release a whole new browser. Microsoft has actively ignored most standards, and tried to corrupt the ones that exist. NS6/Mozilla supports many more of the standards that the web needs to develop for the future. IE's support of CSS1/DOM1 is laughable and buggy with many features not implemented, while Mozilla is supporting up to DOM2 and CSS2. Mozilla has even incorporated an irc chat client, which means easy chat room building for us. It is now IE's turn to stagnate, since v4 there has not been much innovation at all. I am currently running IE6 Beta and there is nothing new that really matters. Mozilla also has the advantage of being open source. So guess what every single internet appliance manufacturer is going to integrate? Most people agree that appliances will be the majority of web clients in the future.Red Hat and the rest of the Linux vendors should be moving over to Mozilla within the next couple of months too. I haven't written any more NS4.x code in a long time, and only make a passing effort at compatibility these days. However the more I develop with the standards in mind, the more I realize how bad IE is. I actually spend more time working around IE bugs, and compatibility issues now, wishing people would just go download Mozilla ;-) and Opera sucks, but it is superior IE as far as standards support goes. I'll give it that. jon - Original Message - From: Stevens, Jason [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, June 08, 2001 8:19 PM Subject: RE: OT: NETSCAPE IS GOING AWAY! A Web Developer's Dream Come True ! While I'm no fan of monopolies, I have been nothing but happy with Microsoft's browser. Netscape was a substandard product that limited web development and it's getting what it deserves if you ask me. It did a great job of being picky about the code it worked with, which kept me in check MANY of times, but restrained us in many other areas. So here's a pat on the back to those Netscape guys, go help Opera out, they're workin on a heckuva browser there. Jason -Original Message- From: Steve Bernard [mailto:[EMAIL PROTECTED]] Sent: Friday, June 08, 2001 3:15 PM To: CF-Talk Subject: RE: OT: NETSCAPE IS GOING AWAY! A Web Developer's Dream Come True! bandwidth saving snip of wonderful comments ;-) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: NETSCAPE IS GOING AWAY! A Web Developer's Dream Come True!
Lets not forget Smart Tags... http://www.evolt.org/article/Microsoft_implementing_Smart_Tags_in_IE_release /1/11252/index.html jon - Original Message - From: Zac [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, June 09, 2001 12:33 AM Subject: Re: OT: NETSCAPE IS GOING AWAY! A Web Developer's Dream Come True! On Friday, June 8, 2001, at 08:53 PM, John Wilker wrote: But Zac is right, what happens when IE stops supporting jpg, or gif, or png and only supports msg (Microsoft Graphics format)? However unlikely you may think it, it's a possibility that is out there. As an example of this there is an article at The register that discusses the difficulty (impossibility) of playing MP3 audio under the latest Windows XP build http://www.theregister.co.uk/content/4/19573.html -- It is dangerous to be right when the government is wrong. Voltaire ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFSTOREDPROC and performance question
How about using BCP? cfquery name=InsertInitial DATASOURCE=#DSN# USERNAME=#user# PASSWORD=#pass# BULK INSERT Table FROM 'D:\FR\FileResource\101-200.csv' WITH ( FIELDTERMINATOR=',', ROWTERMINATOR=' ' ) /cfquery http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/sql/ts_ba-bz_4fec.htm jon Marc Garrett wrote: To the group: I need to walk through about 11,000 records with 25 columns in a text file and insert them daily into a SQL Server database. Since I'm on a shared server, my templates need to execute in 180 seconds or less. If I use CFQUERY to insert row by row into the database, the query takes about 160 to 200 seconds to complete. In an effort to boost performance, I wrote a stored procedure in SQL Server and called it via CFSTOREDPROC from CF. But the sp takes about 183 to 185 seconds to execute. Is this expected? Am I better off trying a query that simply calls the sp instead of using CFSTOREDPROC? Thanks for any assistance. Regards, Marc Garrett ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT db update problem
This is a multi-part message in MIME format. --=_NextPart_000_029A_01C039D5.90425F20 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable This is really off topic but.. this code works in SQL = server, but does not work in Access which this POS db is unfortunately = in. All I want to do is import a new column into an existing db. I could = definately do this in CF, but there are around 11000 records... Update Products Set ProductCat =3D (Select ProductCat FROM pricecat where partnumber1 = =3D a.partnumber) FROM products a=20 I get this error: Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) = in query expression ''(Select ProductCat FROM pricecat where = 'partnumber1' =3D 'partnumber')'' I get the same error when putting this directly into Access. What am I doing wrong? This should be a simple thing jon --=_NextPart_000_029A_01C039D5.90425F20 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.3018.900" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2This is really off topic = but.. this=20 code works in SQL server, but does not work in Access which = thisnbsp;POS db is=20 unfortunately in. All I want to do is import a new column into an = existing db. I=20 could definately do this in CF, but there are around 11000=20 records.../FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Update ProductsBRSet ProductCat =3D = (Select=20 ProductCat FROM pricecat where partnumber1 =3D a.partnumber)BRFROM = products a=20 BR/FONT/DIV DIVFONT face=3DArial size=3D2I get this error:/FONT/DIV DIVFONT face=3DArial size=3D2Microsoft][ODBC Microsoft Access = Driver] Syntax=20 error (missing operator) in query expression ''(Select ProductCat FROM = pricecat=20 where 'partnumber1' =3D 'partnumber')''/FONT/DIV DIVFONT face=3DArial size=3D2I get the same error when putting this = directly=20 into Access./FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2What am I doing wrong? This should be a = simple=20 thing/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2jon/FONT/DIV/BODY/HTML --=_NextPart_000_029A_01C039D5.90425F20-- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Working with FedEx API?
Let me warn you now. This program does NOT like Windows 2000, and machines with multiple IP addresses (so dont install it on any modern web server). We have to keep the stupid program on a standalone box on the network. Fedex is really dragging their feet on fixing this. jon - Original Message - From: "Will Ryan" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, October 19, 2000 5:39 PM Subject: Working with FedEx API? Hi All, Has any one out in never never land worked with the FedEx API? I have read nearly all the documentation and have yet to find a way to reference the DLL in HTML or CF. Any one have any thoughts? Thanks, Will -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
