RE: Debug output - OnRequestEnd.cfm
Don't quite see how you can make this claim, I always use it. Every application I've ever written makes use of it. I may be in the minority, but you have no real way of knowing that, so it is not quite accurate nor fair to say it's rarely used. At 10:25 AM 7/11/01 -0700, you wrote: To the original poster, OnRequestEnd is documented, but rarely used. At 08:41 AM 07/11/2001 -0500, you wrote: Mike, OnRequestEnd.cfm works just like Application.cfm. As we all know Applicaion.cfm gets run before every page. OnRequestEnd.cfm runs at the end of every page. Your OnRequestEnd.cfm should reside in the same folder as Application.cfm. ~~ 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
file uploads without using CFFILE
If hosted at an outside hosting provider, and that provider has CFFILE turned off, what other alternatives are there for uploading files from the client to the server. CFFTP won't work because it's expected to work via FTP server to server. This is for CF 4.5. Is there perhaps a free COM object that could be accessed via CF to profide this functionality? I found a free one, but all the examples give ASP code, and relies on the REQUEST and FORM collections available in ASP. Ideas? Suggestions? ~~ 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
history of CF
How long has CF been available? ~~ 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: Note passing system?
As strange as this may sound in light of normal developmental thought processes... I like to re-invent the wheel... each time I do, I get a better, more efficient, and sometimes a much better looking wheel... of course I don't do this all the time, and I may use a function or two that somebody else wrote, but I've always written my own applications. It's why I'm a developer... I love developing... At 02:37 AM 4/17/01 -0400, you wrote: :o) Hi Peter. I certainly understand where you're coming from. After 3 years of doing some solid CF work, I'm very capable of building most of the stuff that I need. I'm just an advocate of code reuse. If there's something out there that helps me reduce my coding time, I'd like to take advantage of it. I really hate reinventing the wheel. Thanks for the feedback... Rey... Certified Allaire Instructor Member of Team Allaire "A browser's beauty, at its heart, is its usefulness as a *TOOL*." - Original Message - From: "Peter Tilbrook" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 1:59 AM Subject: RE: Note passing system? As a side note - if you have an idea for your application - do it! Do not expect someone else to have already written the code for you. CF makes coding easy. If you are worried about the code have trusted people try and break it. Spend at least 3 weeks with beta testers on trusted code. You would be amazed at how the feedback either picks up problems or points out, even unobtrusively, better ways to accomplish a task. -Original Message- From: Peter Tilbrook [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 17 April 2001 15:33 To: CF-Talk Subject: RE: Note passing system? I implemented the same thing for the new Friends Plus site. The beauty of the system is that nobpdys email address is released. We could be draconian and introduce full auditing but it has not been necessary yet. The user remain anonymous and their email address is never released unless they give it out. -Original Message- From: Rey Bango [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 17 April 2001 14:57 To: CF-Talk Subject: Re: Note passing system? Not really, Paul. Its more like an internal messaging system. One where I can write a message to another user or perhaps a group of users and have them correspnd back. Again, its not a true email system but one that would allow me to be able to communicate within the scope of my own application. Rey... Certified Allaire Instructor Member of Team Allaire "A browser's beauty, at its heart, is its usefulness as a *TOOL*." - Original Message - From: "Paul Begovich" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, April 16, 2001 7:35 PM Subject: Re: Note passing system? Sounds like you want a project management tool. We have an internal system here we use to parse out work. Basically the client/project manager submits an item to a form and it appears on the necessary persons desktop based on who they select. They see the item, do the work, mark their time, and reply via the form. It's a great project management tool and it keeps track of correspondence. Building a system like your describing isn't too difficult, it's just time consuming. We have looked into outside utilities to do this, but we've found them lacking. As a development shop we have found that when we need some additional functionality we build it on. The current system we have now has grown out of several developers efforts in the past two years to incompass project managment, billing, contacts, work requests, logging, and a host of other things. A third party too may save you time in the short run, but in the long run, it'll probably lacks the additional functionality you want. I recommend buiding your own system, keeping in mind you want to be able to add additionally functionality in the future. - Paul - Original Message - From: "Rey Bango" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, April 16, 2001 1:07 PM Subject: Note passing system? Anyone know of a good CF-based note/messaging system? I'm not talking about an email server but more of a db driven messaging software that will allow me to post a message to a specific suer. When that user comes in, they can check for their own messages and reply accordingly. Again, its not an email system per se. Thanks, Rey Bango... Certified Allaire Instructor Member of Team Allaire "A browser's beauty, at its heart, is its usefulness as a *TOOL*." ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives:
RE: Hosting recommendations
When I used to run CF sites, I had good luck with Media3 (http://www.media3.net).. Now that I only personally run PHP on Linux systems, I use JTL Networks (http://www.jtlnet.com) and they do have a CF offering as well. They've had good support and reliability, but I don't know if their NT and CF boxes are as good as the linux boxes are... So you're moving away from Onvia, formerly Zanova, formerly iTOOL? At 10:09 PM 4/5/01 -0600, you wrote: -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 5:57 PM To: CF-Talk Subject: Hosting recommendations I am looking for hosting recommendations for multiple client sites. Requirements include CF 4.x SQL Server 7.0 MS Access Cybercash ASP Particularly interest in hosts with a good availability track record and excellent support... so I won't be be spending all my time performing support duties. TIA Dick ~~ 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: update
There was an interesting answer to this type of question in Mid-March... I hadn't tried it myself, and would be curious if anyone else has... CFQUERY ... cfquery parameters ... SET NOCOUNT ON INSERT INTO SomeTable( SomeField ) VALUES( 'SomeValue' ) SELECT nNewID = @@IDENTITY SET NOCOUNT OFF /CFQUERY CFOUTPUT#qQueryVariable.nNewID#/CFOUTPUT At 03:09 PM 4/5/01 +0100, Bill Davies wrote: Becky see http://www.allaire.com/Handlers/index.cfm?ID=1463Method=Full -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: 05 April 2001 15:02 To: CF-Talk Subject: update is there anyway to output the last primary key number in a table after an insert statement? i need to capture that number on the same action page so i can pass it to another table. in other words, on my insertApp.cfm i have the query to update my apps table. but on this same page at the bottom, i have another form...a form to update the licensing. when i submit this form, i need that primary key from my apps table to pass thru to my licensing table. so i need a way to capture that value. any ideas? * 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: CFHEADER questions
Could you do a CFEXIT or CFABORT? At 03:46 PM 4/5/01 -0400, you wrote: That is a pain. As I said, I generally put everything into a variable and then send that, but you still have to be careful about whitespace. There's no magic way to say "CFCONTENT only up to this point" that I know of. -Original Message- From: tom muck [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 1:30 PM To: CF-Talk Subject: Re: CFHEADER questions Thanks for that link. Very informative. As to the other question: I was mainly interested in it from a practical point of view. When I insert the code on the page from a snippet, I always have to make sure that there isn't any whitespace, closing /body or /html tags, or any other tags after it, or they end up in the file. I just want to make sure the output gets cut off immediately. tom [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I'm not sure what you mean by stopping the output. Do you mean that you might start working through a query (or something) and then find that you don't want to send the data to the user after all? If so, you could first put all the data to download into a variable, then only do the CFCONTENT if you've decided the data are ok. I've used this sort of approach to create RTF files to download to the browser before; I wouldn't call it easy but it's certainly possible. More info here: http://forums.allaire.com/devconf/Index.cfm?Message_ID=172003 -Original Message- From: tom muck [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 10:21 AM To: CF-Talk Subject: CFHEADER questions I have some code on my page using CFHEADER and CFCONTENT that allows the download of a CFOUTPUT to a text file. Is there anything I can use on that page, aside from a CFLOCATION or CFABORT to stop the output of the server to the text file? Also, is there an easy way to create an RTF or Word doc on the fly using this method? tom ~~ 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
Updatable Views
Is it possible using a view to do an INSERT or UPDATE? Joseph E. Sheble [EMAIL PROTECTED] PHP/mySQL | ColdFusion/SQL Server Canvas, Cinema 4D XL, and more... Wizaerd's Realm http://www.wizaerd.com The Canvas Expert http://www.TheCanvasExpert.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: Looping through a Query in CFSCRIPT
Here's an example: CFQUERY NAME="qTest" DATASOURCE="#DSN_Name#" USERNAME="#DSN_Username#" PASSWORD="#DSN_Password#" SELECT ID, Option_Desc FROM Forecast.dbo.Options ORDER BY ID /CFQUERY CFSCRIPT for( x = 1; x LTE qTest.RecordCount; x=x+1 ) { WriteOutput( qTest.ID[x] " - " qTest.Option_Desc[x] "br" ); } /CFSCRIPT At 03:54 PM 4/3/01 +0100, Jason Lees (National Express) wrote: Hi all, Is it possible to loop through the results of a CFQuery structure? and Has anybody got an example of how its done TIA. Jason Lees National Express Email : [EMAIL PROTECTED] ### This document is intended for, and should only be read by, those persons to whom it is addressed. Its contents are confidential and if you have received this message in error, please notify us immediately by telephone on 0121 609 6301 and delete all records of the message from your computer. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without our prior written consent is strictly prohibited. Neither the author of this message nor their employers accept legal responsibility for the contents of the message. Any views or opinions presented are solely those of the author. If you have any queries please contact [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
Single ODBC Datasource
Isn't there a way to create a singular ODBC Datasource that could access any database on a SQL Server? In the past we've always created a sperate ODBC Datasource for every database, and while this isn't necessarily a bad thing, I'd like to be able to access any database... Joseph E. Sheble [EMAIL PROTECTED] Wizaerd's Realm http://www.wizaerd.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: To ASP or not to ASP
anti-trust verdict aside, there are whisperings of AOL and Sun pushing more anti-trust action onto Microsoft due to the whole .NET thing... see http://www.thestandard.com/article/display/0,1151,22965,00.html At 09:16 AM 3/21/01 -0500, Nick McClure wrote: 1. ASP is much powerful for people who comes from programming background, you can have much flexibility for customizing your web application, but CF will be more friendly for people who does not want to do much by themselves instead using tags..., This is not true, while yes they are tags but you can still structure your code and do almost everything you can do with VBScript. The only thing you cannot do is use functions, which has now been added to CF5 and it is now in Beta 2, and they are nice. If Alliare disappear one day ( e.g. no more support for the marketing reason ), where else you can find a job? However, if ASP disappear, e.g. C# is coming up... then, you can still use your VBScript and JavaScript to find yourself very marketable in the job market... So you would rather put your faith in a company about to be broken up by the justice department? ~~ 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: no-cache
I use CFHEADER name="Expires" VALUE="0" has worked for me so far... At 11:55 AM 3/20/01 -0500, Kevin Gilchrist wrote: Changed it and it didn't seem to make a difference -Original Message- From: Savan Thongvanh [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 11:34 AM To: CF-Talk Subject: no-cache woopsie, http-equiv="pragma" content="no-cache" ~~ 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: @@identity
Dave, this is a good explanation as to why you would want to use it, but do you have anything to offer in regards to the performance difference? At 04:02 PM 3/20/01 -0500, you wrote: I am curious, I replaced the SELECT newID = @@identity with SELECT max(id) as myVar and max(id) is faster than your example in my application. Is there a reason that @@identity is "better" than max(id), other than the stated SQL Server issues? Using @@IDENTITY in this case makes it less likely that you'll have a concurrency issue. If you simply insert the new record, then query for the highest identity value, it's possible that someone else will have inserted a record between your insert and your SELECT MAX query. If that happens, then you'll get the wrong identity value. Using @@IDENTITY ensures that you get the identity value from your insert. 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
Regular Expression Help
I have some text, and in this text there may or may not be URLs. Some of these URLs may already be inside of an A HREF tag while others may not. I need a regular expression that will find all the URLs (starting with http:// or www. or email addresses) that are not already inside of HREF tags and make them into valid HREF tags while leaving the URLs already inside a HREF tag alone... Can anybody give some suggestions about this? Joseph E. Sheble [EMAIL PROTECTED] Wizaerd's Realm http://www.wizaerd.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
Authenticating NT Users
I've downloaded and installed the CFX_USER custom tag from Allaire, but it doesn't seem to want to work. I've emailed the author of that tag, but I've not heard any response. If I have my CF Server running as a user (an administrator user) the verify action of the tag fails with the following error: Unexpected Windows NT error occurred while calling LogonUser function: [ A required privilege is not held by the client. (1314 0x522)] Here is the line of code generating the error: CFX_USER ACTION="verify" USERNAME="#ATTRIBUTES.txtUser#" PASSWORD="#ATTRIBUTES.txtPassword#" SERVER="speedfam" If I set the CF Server to run as SYSTEM, then I do not get this error, but then I cannot upload files using CFFILE... Any suggestions... please! Joseph E. Sheble [EMAIL PROTECTED] Wizaerd's Realm http://www.wizaerd.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: Somewhat OT???Escaping Hexidecimal
escape it with another # ##FF this is only necessary between a set of CFOUTPUT /CFOUTPUT tags At 08:31 AM 2/5/01 -0500, you wrote: Hey everone: Does anyone know a way to escape hex values, ie stuff like #FF CF throws an error when I do this The only work around I have found to date is to leave off the # from hex values it seems to work ok. but creates odd looking code. Any ideas 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: Statistics on Toy R Us
I've never done Perl or Mason, but I can say without a doubt this is not true about PHP and ASP. They do not leave whitespace around at all... I've seen some real bad examples of both, and nope, there just ain't lines after lines of whitespace. Perl (if badly written), PHP (if badly written), ASP (if badly written), CF (if badly written), Mason (if badly written), and everything else under the sun (if it's badly written). CF, however is a bit more interesting... ~~ 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 NULL Values in SQLSERVER.
How about: CFIF trim(ListGetAt(Phone,x)) contains "n/a" Phone = NULL, CFELSE Phone = '#ListGetAt(Phone,x)#', /CFIF At 01:56 PM 1/29/01 -0500, you wrote: I was trying to insert a blank or null value into the table, if the current list item contains 'n/a'. Not having much success this afternoon. CFIF trim(ListGetAt(Phone,x)) contains "n/a" Phone = ' ', CFELSE Phone = '#ListGetAt(Phone,x)#', /CFIF Thanks, Dave ~~ 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: SQL Server Query Designer
I don't know about running it on W2K, but I have seen that exact message over and over again, and everytime I've gotten it, I re-installed the MDAC from MS, and all was well... At 09:04 AM 1/25/01 -0500, you wrote: I'm running SQL7 on W2K Professional. When I try to use the query designer (right-click on table -- open table) I get an error message stating, "The query cannot be executed because some files or either missing or not register". I have re-installed SQL Server a number of times. I do have administrator rights on the machine. Anyone have any suggestions for me? Tim ~~ 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: chmod
Strangely enough, I've always had problems with figuring this stuff out, but this little demonstration suddenly makes sense. I've never seen it put this way, and yet it makes it appear so simple. Thanx! At 08:35 AM 1/22/01 -0600, you wrote: Just remember binary numbers: (rwx)(rwx)(rwx) = (111)(111)(111) = 777 Similar r-- = 100 = 4 r-x = 101 = 5 rw- = 110 = 6 You can always reconstruct what you need... Brian -Original Message- From: Jay Patton [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 18, 2001 7:29 PM To: CF-Talk Subject: chmod does anyone remember or know the chmod number to make a file readable writeable and executable by everyone? i cant remember it thanks, Jay Patton Web Pro USA 406.549.3337 ext. 203 1.888.5WEBPRO www.webpro-usa.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
didn't it have a backup before
Didn't CF Studio have an option to create a backup file automatically when it saved a file? In 4.5.2, I've looked all through the different options, and I'm either missing it or it's not there. I've got to find it, because after attempting to close studio several times, it has given me an access error, forcing me to kill it out of the NT Task List, thus resulting in a completely wasted (read empty) file... It doesn't appear to happen if I close the file in the editor before attempting to close studio itself, but when one is in a hurry it's easy to skip that. SO I'd rather have that backup... just in case... Joseph E. Sheble [EMAIL PROTECTED] Wizaerd's Realm http://www.wizaerd.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: Studio and PHP?
I guess it depends on your definition of support. I use PHP all the time in Studio. It doesn't have template expansion, but it does recogize PHP keywords in the syntax color hilighting. At 05:56 PM 1/18/01 +, you wrote: Hi, A friend tells me that Allaire's Studio might be supporting PHP in the future - is this true, or complete rubbish? Will -- [EMAIL PROTECTED] -=- www.lukrative.com Classifieds -=- www.localbounty.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: Studio and PHP?
There is a whole lot of support for PHP in the form of mailing lists, websites, books (of which there is more than one... closer to three or four) It is for a whole lot more than accessing databases, and while this may likely get me flamed, it a lot more powerful in functionality than CF is. But it's a lot more strict than CF is as well in it's syntax and code placement. I prefer working in PHP, but alas, there's not a lot of jobs out there for PHP developers. At least not yet At 06:11 AM 1/19/01 -0800, you wrote: I asked a friend of mine last night at a CFUG meeting what the PHP was all about and he informed me it was like the earlier version of database handling, in the earlier stages of the CF development, IT was not CF, but a freeware program, that didn't have much support if any, all I know is it must be something of value, because Prima publishing has a book out on it, that was very informative, but there was a lot of talk of MYSQL, and Linux, throughout the whole book. "W Luke" [EMAIL PROTECTED] wrote in message 003b01c08178$09ed7730$8d00a8c0@ekul">news:003b01c08178$09ed7730$8d00a8c0@ekul... Hi, A friend tells me that Allaire's Studio might be supporting PHP in the future - is this true, or complete rubbish? Will -- [EMAIL PROTECTED] -=- www.lukrative.com Classifieds -=- www.localbounty.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: Macromedia and Allaire to Merge
This intrigues me a bit... how can you get the CF server piece to interact with that flash form without submitting it? You'd still have to perform an HTTP post in order to get the filled in data to the CF server, which would in fact force a new page to load or a refresh of the current page. Unless you were using Generator, right? At 12:13 AM 1/17/01 -0700, you wrote: Ah, but You can use Flash without all the fancy things. You can create a simple page with a simple form that: looks exactly the same regardless of the browser, fonts, styles, etc. has antialiased characters in both the labels and in the fields, themselves improves the user interface outperforms a standard form (less bandwidth, faster response) The latter is very important for a "nice but fast presentation of useful data". Here's a simple example of what I mean: With CF you display a simple blank form to retrieve/edit an employee record: Employee_ID _ [Submit] Last_Name _ First_Name _ Phone _ . . . Now you enter an employee ID and hit submit. what normally happens is this: 1) the form fields are submitted to your CF program in Name/Value Pairs (e.g. Employee_ID=12345) 2) Your CF program gets the info from the form and does a query and retrieves the data. 3) Your CF program formats am entirely new copy of the form with the data fields filled in 4) You send this back to the browser 5) The browser's screen goes blank 6) The entire form and contents are redrawn Now, let's do the same thing with Flash. The blank form looks the same, except it is defined in flash and is probably smaller than the equivalent html form. When you enter an ID and submit, steps 1 and 2 are exactly the same But here is where things get a little different: The Flash file which submitted the data is looking for a response in the format of Name/Value pairs 3) Your program only formats the Name/Value pairs, not the entire form 4) The Name/Value pairs (only) are sent back to the browser Flash plugin 5) the screen does *not* go blank 6) The Values in the Name/Value pairs replace the contents of the form fields (the entire form is *not* redrawn) The reduction in bandwidth is significant. Response time is greatly improved. The visitor doesn't stare at a blank or partially redrawn screen Dick At 8:16 PM -0800 1/16/01, Allan Pichler wrote: Flash is all good for fancy presentations. But that's not where the majority of inet use is. It's still about making nice but fast presentation of useful data. ~~ 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: Cross Browser DHTML Menu
HierMenus is a good script http://www.webreference.com/dhtml/ At 01:21 PM 1/17/01 -0500, you wrote: Check out this site http://www.ivanpeters.com/ Joust is a pretty cool content outliner -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 17, 2001 11:31 AM To: CF-Talk Subject: OT: Cross Browser DHTML Menu Guys, I need a cross browser DHTML menu asap that can do drop down, and slide menus. Menu |-Item1 |-Item2 |-Item3--|-Item5 |-Item4 |-Item6 Does anyone know of a good simple API or generator, that has been tested (the important part of the question) on NN4+ and IE4+, that they would recommend? Please don't suggest CF_DHTMLMenu as it specifically states that it's not for NN. Thanks 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: skipping INPUT when tabbing
instead of burring the input field, force the focus to the field you do want it to go to... onFocus="form.otherfield.focus()" At 09:30 AM 1/16/01 -0800, you wrote: Reposting, didn't seem to make it thru the first round... Within an INPUT tag Im using a onFocus="this.blur()" so the user cannot change the input, its being calculated by JavaScript. The problem is the user need to be able to tab beyond this field, tabbing halts when it hits this field. Ya I know big deal, but it is with my customer. Ive tried DISABLED and it works great but then the tag does not pass the value so i cant use that. Is there some method to bypass this INPUT when tabbing. Ive tried TABINDEX but cant seem to get it working properly, part of the problem is the columns that are being totaled are dynamically created so there could be one or several. Basically I need to bypass this sucker when tabbing, any thoughts? can CFINPUT help me here? -Adrian ~~ 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
CFOBJECT and JAVA
I've been experimenting with calling Java classes using CFOBJECT, and so far all my tests have run successfully. However, there is one quirk about this whole process that irks me, and I was hoping somebody here would have a solution. If I call the class, find something wrong with it, go back to the java class and modify the source and re-compile, and make sure the new class file is in the correct directory and then re-call the class, it appears the old one is still loaded. New events and variables are not visible throwing an error. CF will only call up the new one after restarting the CF server. This leads me to guess that once a java class is loaded via CFOBJECT, it never unloads. Couldn't this eventually cause a problem? It sure makes development and testing a real bear having to stop and restart the server Joseph E. Sheble [EMAIL PROTECTED] Wizaerd's Realm http://www.wizaerd.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: CFOBJECT and JAVA
This is not an option when using CFOBJECT with Java... At 02:08 PM 1/12/01 +, you wrote: Are you using RELOAD="Always" ??? Justin -Original Message----- From: Joe Sheble aka Wizaerd [mailto:[EMAIL PROTECTED]] Sent: Friday, January 12, 2001 1:39 PM To: CF-Talk Subject: CFOBJECT and JAVA I've been experimenting with calling Java classes using CFOBJECT, and so far all my tests have run successfully. However, there is one quirk about this whole process that irks me, and I was hoping somebody here would have a solution. If I call the class, find something wrong with it, go back to the java class and modify the source and re-compile, and make sure the new class file is in the correct directory and then re-call the class, it appears the old one is still loaded. New events and variables are not visible throwing an error. CF will only call up the new one after restarting the CF server. This leads me to guess that once a java class is loaded via CFOBJECT, it never unloads. Couldn't this eventually cause a problem? It sure makes development and testing a real bear having to stop and restart the server Joseph E. Sheble [EMAIL PROTECTED] Wizaerd's Realm http://www.wizaerd.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: CFerror and its
Actually starting with 4.5 you can execute CF code in a template specified by the CFERROR tag, but only if you use the TYPE="Exception" and EXCEPTION="Any" in your tag. Such as: CFERROR TYPE="EXCEPTION" EXCEPTION="Any" TEMPLATE="/cf_error_handler.cfm" MAILTO="[EMAIL PROTECTED]" Or you can specify in your CF Administrator default templates for this for a site wide error trap, and still be able to use CF code in your error handling template. At 10:14 AM 1/12/01 -0500, you wrote: you can't execute cf code on error pages. what i do is put all the cfcode in hidden form variables, and onload submit the form to another page that executes the cold fusion and emails me the error code. - Original Message - From: "Andres" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, January 12, 2001 9:56 AM Subject: CFerror and its Hello all, i have an application.cfm that calls a cf error tag like this: cfapplication name="myapp" clientmanagement="Yes" sessionmanagement="Yes" setclientcookies="Yes" sessiontimeout="#CreateTimeSpan(0, 0, mins_until_timeout, 0)#" cferror type="VALIDATION" template="site_errors.cfm" mailto="[EMAIL PROTECTED]" cfinclude template="variables.cfm" The problem is that when a validation error occurs, the error page appears fine, but the CF inside the error template is not executed... it shown as if it was a regular html page with all the cf showing. can someone tell me why this is happening and how i can correct the problem?? thanks andres ~~ 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
unloading java classes after cfobject call
I've been experimenting with calling Java classes using CFOBJECT, and so far all my tests have run successfully. However, there is one quirk about this whole process that irks me, and I was hoping somebody here would have a solution. If I call the class, find something wrong with it, go back to the java class and modify the source and re-compile, then re-call the class, it appears the old one never unloads. CF will only call up the new one after restarting the CF server. This leads me to guess that once a java class is loaded via CFOBJECT, it never unloads. Couldn't this eventually cause a problem? It sure makes development and testing a real bear having to stop and restart the server Joseph E. Sheble [EMAIL PROTECTED] Wizaerd's Realm http://www.wizaerd.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
Different Stored Proc Help
I ahve a stored procedure that checks to see if any records exisit, and if not creates a default one. The it polls the database and creates basically an empty query. The problem is if this new default record gets created, my main resultset variable does not contain a valid query. Whereas if the default record doesn't get created, my query variable is populated appropriately. Any ideas? Here's the cfstoredproc call: CFSTOREDPROC PROCEDURE="zp_GetDCPs" DATASOURCE="#DSN_Name#" USERNAME="#DSN_Username#" PASSWORD="#DSN_Password#" CFPROCPARAM TYPE="In" CFSQLTYPE="CF_SQL_VARCHAR" DBVARNAME="@IDNumber" VALUE="#SESSION.CurUser.IDNumber#" CFPROCRESULT NAME = "qMain" RESULTSET="2" /CFSTOREDPROC and here's the stored proc itself: CREATE PROCEDURE zp_GetDCPs ( @IDNumber varchar(20) ) AS DECLARE @cHold varchar(1) SET @cHold = '0' IF NOT EXISTS( SELECT DCPNumber FROM dcp_Header WHERE IDNumber = @IDNumber ) BEGIN SET @cHold = '1' INSERT INTO dcp_Header( IDNumber, DCPDate, BeenApproved ) VALUES( @IDNumber, getdate(), 0 ) END IF @cHold = '0' BEGIN -- merely a resultset placeholder SELECT IDNumber FROM dcp_Header WHERE IDNumber = @IDNumber END -- current employees DCP's SELECT dcp_Employees.IDNumber, dcp_Employees.FirstName, dcp_Employees.LastName, dcp_Header.DCPNumber, dcp_Header.CurPosition, dcp_Header.DCPDate, dcp_Header.BeenApproved FROM dcp_Employees LEFT JOIN dcp_Header ON dcp_Employees.IDNumber = dcp_Header.IDNumber WHERE dcp_Employees.IDNumber = @IDNumber ORDER BY dcp_Employees.LastName, dcp_Header.DCPDate DESC Joseph E. Sheble [EMAIL PROTECTED] Wizaerd's Realm http://www.wizaerd.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: DELPHI - where does it fit in the scheme of things?
For those that are using Delphi, what role does it play in the internet? Is it being used strictly for COM access with CF, or are there hidden web abilities some of us may be unaware of? At 07:45 AM 1/9/01 -0600, you wrote: We use Delphi and CF here. The main reason for that is most of our products have some standard application interfaces as well as web interfaces. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 1:48 AM To: CF-Talk Subject: RE: DELPHI - where does it fit in the scheme of things? What is Delphi? Is it a peer to ASP and ColdFusion or is it more a peer to VisualBasic and used for making COM Objects? Is it any good? Would you other webmasters live with ASP, ColdFusion AND Delphi in your sites? Never used it, but I keep bumping into Delphi shops that also use CF. There's at least a couple of those folks on the mailing list somewhere. Delphi is basically the child of Pascal, like C++ was to C. Think of it as Pascal++. Somewhere between Java and C++ in power/complexity. You can make COM's with it. You can also make CFX's with it. Yes, it's roughly in the same league as VisualBasic, Java and C++. --min ~~ 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
Hierarchial Display
I am able to retrieve hierarchial data just fine using a nested custom tag, and this tag populates a query for me with the data. However, I'm having a real problem with trying to figure out how to display it. Here's an example of the data: 0325 - Thomas - Graf - 0645 - Robert - Nudo - 0325 1392 - Joseph - Sheble - 0325 0937 - Kimberly - Walters - 1392 0674 - Lisa - Perez - 0937 1450 - Jerome - Horowitz - 0325 And I'd like it displayed thus: 0325 - Thomas - Graf - - 0645 - Robert - Nudo - 0325 - 1392 - Joseph - Sheble - 0325 0937 - Kimberly - Walters - 1392 0674 - Lisa - Perez - 0937 - 1450 - Jerome - Horowitz - 0325 However, there's no limit to the hierachy depth... any ideas? Joseph E. Sheble [EMAIL PROTECTED] Wizaerd's Realm http://www.wizaerd.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: Hierarchial Display
Wat do you mean by a tree structure? At 05:51 PM 1/8/01 +, you wrote: Why not get the custom tag to populate a tree structure instead of a query? Then you can write another recursive custom tag to display the data much more easily. -Original Message- From: Joe Sheble aka Wizaerd [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 5:41 PM To: CF-Talk Subject: Hierarchial Display I am able to retrieve hierarchial data just fine using a nested custom tag, and this tag populates a query for me with the data. However, I'm having a real problem with trying to figure out how to display it. Here's an example of the data: 0325 - Thomas - Graf - 0645 - Robert - Nudo - 0325 1392 - Joseph - Sheble - 0325 0937 - Kimberly - Walters - 1392 0674 - Lisa - Perez - 0937 1450 - Jerome - Horowitz - 0325 And I'd like it displayed thus: 0325 - Thomas - Graf - - 0645 - Robert - Nudo - 0325 - 1392 - Joseph - Sheble - 0325 0937 - Kimberly - Walters - 1392 0674 - Lisa - Perez - 0937 - 1450 - Jerome - Horowitz - 0325 However, there's no limit to the hierachy depth... any ideas? Joseph E. Sheble [EMAIL PROTECTED] Wizaerd's Realm http://www.wizaerd.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: Hierarchial Display
I am using IE, but it should be cross browser compatible. If it can't be, then I'll just explain to the powers that be that it can't be... Would you have any examples of building such a control? At 01:15 PM 1/8/01 -0500, you wrote: What web browsers does you support? If you use IE, you can easily build an XML based tree control to contain your information... -Original Message- From: Joe Sheble aka Wizaerd [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 12:41 PM To: CF-Talk Subject: Hierarchial Display I am able to retrieve hierarchial data just fine using a nested custom tag, and this tag populates a query for me with the data. However, I'm having a real problem with trying to figure out how to display it. Here's an example of the data: 0325 - Thomas - Graf - 0645 - Robert - Nudo - 0325 1392 - Joseph - Sheble - 0325 0937 - Kimberly - Walters - 1392 0674 - Lisa - Perez - 0937 1450 - Jerome - Horowitz - 0325 And I'd like it displayed thus: 0325 - Thomas - Graf - - 0645 - Robert - Nudo - 0325 - 1392 - Joseph - Sheble - 0325 0937 - Kimberly - Walters - 1392 0674 - Lisa - Perez - 0937 - 1450 - Jerome - Horowitz - 0325 However, there's no limit to the hierachy depth... any ideas? Joseph E. Sheble [EMAIL PROTECTED] Wizaerd's Realm http://www.wizaerd.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: record sets... arrays or structures?
I've never had any difficulties in using this.. CFQUERY NAME="qQuery" SELECT BLAH BLAH BLAH /CFQUERY CFOUTPUT#qQuery.SomeField[10]#/CFOUTPUT At 09:02 AM 1/4/01 -0500, you wrote: subject says it all let's say a have a record set of users and wanted to get the first name of row #13. could i use something like: User.FirstName[13] ??? (except for the fact that this example doesnt seem to work) -- Mike Amburn, Development [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: record sets... arrays or structures?
This sytnax will not work with recordsets... the index of the array must come after the fieldname... At 03:13 PM 1/4/01 +0100, you wrote: Try User[13].FullName, u can use that with recordsets. Structures work the same, and you have a tool called QueryToStruct, which converts your query to a structure. Regards, Johan Coens -Original Message- From: Mike Amburn [mailto:[EMAIL PROTECTED]] Sent: donderdag 4 januari 2001 15:03 To: CF-Talk Subject: record sets... arrays or structures? subject says it all let's say a have a record set of users and wanted to get the first name of row #13. could i use something like: User.FirstName[13] ??? (except for the fact that this example doesnt seem to work) -- Mike Amburn, Development [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: a cry out for help
If I'm understanding the lack of information or the omitted information, this is not an on-line application, accessible through the web browser, correct? At 10:53 AM 1/4/01 -0500, you wrote: As opposed to starting from scratch, check out DocuShare by Xerox Corporation. It will do what you want right out of the box, and you can download free trials, etc. You can have it up and running in a matter of an hour. http://www2.xerox.com/go/xrx/event/Promotions.jsp?page=DocuShare+Promotionx pro=hp2120100 Tim Claremont -Original Message- From: Nick Call [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 04, 2001 10:35 AM To: CF-Talk Subject: a cry out for help Hi: I have a good one for you. Upper management has given me 6 hours to come up with (basically) a CF version of Source Safe. They want to be able to publish important company docs, like the strategic business plan for 2001 (in MS Word), and allow certain members of management to check it out, download it, revise it, and re-upload it without overwriting old versions. It has to track revision dates, author, etc. And it has to be idiot-proof, becuase they admit that they are Internet idiots. Has anyone built this system before in CF? If so, how much? Help. Nick [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: line breaks in cfmail
If you have the TYPE attribute to HTML, you'll beed to specify a break tag: lt;BRgt; At 09:22 AM 1/4/01 -0600, you wrote: Hey all, I have this ongoing problem with line breaks not being respecting when formatting my email bodies using the cfmail tag. For example something like this: cfmail Email Address: #form.email# Business Name: #form.businessname# /cfmail Is showing up like this when sent: Email Address: #form.email# Business Name: #form.businessname# Any suggestions? Thx! 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
OT: Alternative To SQL Server Enterprise Manager
I'm wondering if any CF'ers here has found an affordable alternative to SQL Server's Enterprise Manager? I had found SQL Navigator from http://www.quest.com/sql_navigator_ss/index.asp, but have found it lacking in a lot of areas, as well as buggy as h*ll... Enterprise Manager gives a lot of functionality, but mostly operates as an SDI application where multiple windows would be tremendously useful, plus a way to filter the system objects out of the view? Plus provide a data browser, a way to change the properties of a table, build indexes, build stored procedures, change/add/delete data, etc... Does anyone know of such a critter? ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Alternative To SQL Server Enterprise Manager
that is exactly what the doctor ordered... thanx... It remains as an SDI application, but I've lived with it this long, guess I can take it a bit longer... At 10:41 AM 1/2/01 -0600, you wrote: You can filter out system tables in Enterprise Manager by right clicking on the server name and then selecting "Edit SQL Server Registration Properties". Uncheck "Show system databases and system objects." Chris - Original Message ----- From: "Joe Sheble aka Wizaerd" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, January 02, 2001 10:18 AM Subject: OT: Alternative To SQL Server Enterprise Manager I'm wondering if any CF'ers here has found an affordable alternative to SQL Server's Enterprise Manager? I had found SQL Navigator from http://www.quest.com/sql_navigator_ss/index.asp, but have found it lacking in a lot of areas, as well as buggy as h*ll... Enterprise Manager gives a lot of functionality, but mostly operates as an SDI application where multiple windows would be tremendously useful, plus a way to filter the system objects out of the view? Plus provide a data browser, a way to change the properties of a table, build indexes, build stored procedures, change/add/delete data, etc... Does anyone know of such a critter? ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Verity Alternatives
What's the best way to create a search function for one's website, one that would search HTM, HTML,CFM,DOC,XLS,PPT,SQL? We currently use Site Server for our server indexing and searching, but as I pull more and more into SQL Server and CFM templates, I want to maintain full searchability on the site. The Site Server Search routine is written in ASP, and I'm trying to use CF for everything if possible... CF Verity is not an option since it's a large site (intranet) and the full blown Verity isn't an option due to price. I don't know much about Site Server itself, anyone have some good advice in using it with CF or another alternative to Verity? Thanx ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Verity Alternatives
Thanx, I appreciate the response, but the link you provide is very specific to Index Server, and not Site Server. It may not sound like a big deal, but it is... I could include the ASP code that's uses to do the search in a Site Server catalog file, but it's overly complex, obfuscated, and cludgy... But there are differences between searching with Index Server as opposed to Site Server... At 12:38 PM 12/28/00 -0500, you wrote: Funny you should ask. Dain wrote an article on Index Server on some code I provided him on connecting to index server. Make sure all the updates are on index server, you'll be surprised by the speed. http://www.cfcomet.com/cfcomet/index_server/index.cfm?ArticleID=0306FEED-E87 3-4D21-881655F4EFB68127 Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Joe Sheble aka Wizaerd [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 28, 2000 12:17 PM To: CF-Talk Subject: Verity Alternatives What's the best way to create a search function for one's website, one that would search HTM, HTML,CFM,DOC,XLS,PPT,SQL? We currently use Site Server for our server indexing and searching, but as I pull more and more into SQL Server and CFM templates, I want to maintain full searchability on the site. The Site Server Search routine is written in ASP, and I'm trying to use CF for everything if possible... CF Verity is not an option since it's a large site (intranet) and the full blown Verity isn't an option due to price. I don't know much about Site Server itself, anyone have some good advice in using it with CF or another alternative to Verity? Thanx ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: ActiveX and Netscape - OT
Check out NCompass at http://www.ncompasslabs.com Here's where I found it (after a quick 10 second search...) http://browserwatch.internet.com/news/story/plugin46.html At 09:06 AM 12/27/00 -0500, you wrote: Can anyone tell me if a Netscape plugin exists that will allow you to run ActiveX controls in Netscape? I have been searching for three days and cannot find anything that works. Any help GREATLY appreciated!!! Gina ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Fusebox
Fusebox methodologies are analogous to an event handler in any sort of Windows programming. The event model is not new to developers, and is a tried and true practice. Moving that methodology to CF apps makes more than enough sense to me. I use FB methodologies in my CF apps, and they're easier to maintain not only by myself, but other developers here, beginners to pros. They're easier to enhance, modify, and remove functionality. IMO of course... At 06:38 AM 12/20/00 -0800, you wrote: Some like it, some don't. I find it very helpful in an app I'm developing. For example, when I add a new functionality, the list of CFINCLUDed files is the same as similar functions, except for the one of two that are different. This is a WHOLE lot easier than cutting and pasting the right parts of a similar function coded in a single CFAS template. If you like it, use it, if you don't, don't. best, paul At 02:22 PM 12/20/00 +, you wrote: Whats the whole point of Fusebox? ~~ 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: Multiple submits
there are a couple of tags in Allaire's tag gallery that handle this, but it relies all on java script. On the onclick or onsubmit events, I set a variable and then if the user clicks the button a second time, I evaluate that variable, and if it's set I return false from the javascript function that the onsubmit calls... form name="frm" action="index.cfm" onSubmit="return SomeFunc()" /form script language="JavaScript" var lSet = false; function SomeFunc() { if( !lSet ) { lSet = true; return true; } else { return false; } } /script At 10:01 AM 12/19/00 -0500, you wrote: Add this to the input tag: onclick="return confirm('You better not dare click that button a second time, OK?')" ;-) I'm interested in an answer to this question as well. Matthieu -Original Message- From: Jon Gage [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 19, 2000 9:57 AM To: CF-Talk Subject: Multiple submits Does anybody have any suggestions for preventing users from hitting a submit button multiple times? Thanks, 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: Aliases in where clauses.
The original question was field aliases, not necessarily table aliases I just opened up my SQL Server, and ran this on the Northwind sample database, and the message I get is 'Invalid Column Name', because the alias fullname isn't a table column SELECT firstname + ' ' + lastname AS fullname FROM Employees WHERE fullname = 'Margaret Peacock' Same thing with this field alias maxID SELECT MAX(employeeID) AS maxid FROM employees WHERE maxid 4 Joseph E. Sheble a.k.a. Wizaerd Wizaerd's Realm Canvas, 3D, Graphics, ColdFusion, PHP, and mySQL http://www.wizaerd.com = -Original Message- From: Michael Thomas [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 16, 2000 2:11 AM To: CF-Talk Subject: RE: SQL: Aliases in where clauses. I saw you had an aggregate function within your example but you said nothing about using a TABLE ALIAS inside an aggregate function. Your question asked if you could use an ALIAS in a WHERE clause. You can use an ALIAS in a WHERE clause but Ive never been able to use an ALIAS inside an aggregate function before. In that case the answer is no, you cant do it you might have to like you said code out 2 seperate queries. From: "Joe Sheble aka Wizaerd" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: SQL: Aliases in where clauses. Date: Fri, 15 Dec 2000 23:15:29 -0700 COuld you give an example... I've been using RDMS's for over 6 years, and haven't found one yet that'll let you use an alias (for an aggregrate function) in a WHERE cause yet. It's possible to use them in a HAVING clause, but not a WHERE clause... Joseph E. Sheble a.k.a. Wizaerd Wizaerd's Realm Canvas, 3D, Graphics, ColdFusion, PHP, and mySQL http://www.wizaerd.com = -Original Message- From: Michael Thomas [mailto:[EMAIL PROTECTED]] Sent: Friday, December 15, 2000 6:30 PM To: CF-Talk Subject: Re: SQL: Aliases in where clauses. They've worked for me numerous times. From: Joe Sheble aka Wizaerd [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: SQL: Aliases in where clauses. Date: Fri, 15 Dec 2000 13:19:54 -0700 Unfortunately, aliases are not available in a WHERE clause.. I've asked this before in various different places, and the response has always been the same. At 01:17 PM 12/15/00 -0500, you wrote: Hi all. I was wondering, is it possible to use aliases in an sql where clause? We recently reorganized a bunch of data into new tables, and I am having to go back and update the templates that get data from the old tables, so that they get data from the new tables. Example: cfquery name=qcfdefaultSearch datASource="FSLibrary" SELECT events.EventID AS EVENT_ID_NUMBER, events.EventTitle AS EVENT_NAME, MIN(dates.EventDate) AS EventBeginDate,MAX(dates.EventDate) AS EventEndDate, contacts.ContactPhone_AC AS mainContactAreaCode, contacts.ContactPhone AS mainContactPhone, contacts.ContactEmail AS mainContactEmail, contacts.ContactFax_AC AS mainContactFaxAreaCode, contacts.ContactFax AS mainContactFax, venues.VenueName AS EventVenueName, venues.VenueCity AS EventVenueCity, venues.VenueState AS EventVenueState FROMdbo.tbl_EP_Events AS events, dbo.tbl_EP_EventDateTime AS dates, dbo.tbl_EP_Venues AS venues, dbo.tbl_EP_EventContacts AS contacts WHERE (EventBeginDate #dateCompare# #searchDate# and events.EventScopeID = #eventScopeVariable#) and contacts.ContactID = events.EventMainContactID and venues.EventVenueID = events.EventVenueID and dates.EventID = events.EventID ORDER BY EventBeginDate #SortOrder# /cfquery the problem is that the template chokes when I try to use WHERE (EventBeginDate #dateCompare# #searchDate# and events.EventScopeID = #eventScopeVariable#) it seems that it doesn't like the alias in the where clause. I tried using MIN(dates.EventDate), but that doesn't work either. Is it possible to use aliases in the WHERE statement, or am I going to have to do this as two separate tables? Thanks, Chris Martin ~~ 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: Aliases in where clauses.
Unfortunately, aliases are not available in a WHERE clause.. I've asked this before in various different places, and the response has always been the same. At 01:17 PM 12/15/00 -0500, you wrote: Hi all. I was wondering, is it possible to use aliases in an sql where clause? We recently reorganized a bunch of data into new tables, and I am having to go back and update the templates that get data from the old tables, so that they get data from the new tables. Example: cfquery name=qcfdefaultSearch datASource="FSLibrary" SELECT events.EventID AS EVENT_ID_NUMBER, events.EventTitle AS EVENT_NAME, MIN(dates.EventDate) AS EventBeginDate,MAX(dates.EventDate) AS EventEndDate, contacts.ContactPhone_AC AS mainContactAreaCode, contacts.ContactPhone AS mainContactPhone, contacts.ContactEmail AS mainContactEmail, contacts.ContactFax_AC AS mainContactFaxAreaCode, contacts.ContactFax AS mainContactFax, venues.VenueName AS EventVenueName, venues.VenueCity AS EventVenueCity, venues.VenueState AS EventVenueState FROMdbo.tbl_EP_Events AS events, dbo.tbl_EP_EventDateTime AS dates, dbo.tbl_EP_Venues AS venues, dbo.tbl_EP_EventContacts AS contacts WHERE (EventBeginDate #dateCompare# #searchDate# and events.EventScopeID = #eventScopeVariable#) and contacts.ContactID = events.EventMainContactID and venues.EventVenueID = events.EventVenueID and dates.EventID = events.EventID ORDER BY EventBeginDate #SortOrder# /cfquery the problem is that the template chokes when I try to use WHERE (EventBeginDate #dateCompare# #searchDate# and events.EventScopeID = #eventScopeVariable#) it seems that it doesn't like the alias in the where clause. I tried using MIN(dates.EventDate), but that doesn't work either. Is it possible to use aliases in the WHERE statement, or am I going to have to do this as two separate tables? Thanks, Chris Martin ~~ 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: Aliases in where clauses.
COuld you give an example... I've been using RDMS's for over 6 years, and haven't found one yet that'll let you use an alias (for an aggregrate function) in a WHERE cause yet. It's possible to use them in a HAVING clause, but not a WHERE clause... Joseph E. Sheble a.k.a. Wizaerd Wizaerd's Realm Canvas, 3D, Graphics, ColdFusion, PHP, and mySQL http://www.wizaerd.com = -Original Message- From: Michael Thomas [mailto:[EMAIL PROTECTED]] Sent: Friday, December 15, 2000 6:30 PM To: CF-Talk Subject: Re: SQL: Aliases in where clauses. They've worked for me numerous times. From: Joe Sheble aka Wizaerd [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: SQL: Aliases in where clauses. Date: Fri, 15 Dec 2000 13:19:54 -0700 Unfortunately, aliases are not available in a WHERE clause.. I've asked this before in various different places, and the response has always been the same. At 01:17 PM 12/15/00 -0500, you wrote: Hi all. I was wondering, is it possible to use aliases in an sql where clause? We recently reorganized a bunch of data into new tables, and I am having to go back and update the templates that get data from the old tables, so that they get data from the new tables. Example: cfquery name=qcfdefaultSearch datASource="FSLibrary" SELECT events.EventID AS EVENT_ID_NUMBER, events.EventTitle AS EVENT_NAME, MIN(dates.EventDate) AS EventBeginDate,MAX(dates.EventDate) AS EventEndDate, contacts.ContactPhone_AC AS mainContactAreaCode, contacts.ContactPhone AS mainContactPhone, contacts.ContactEmail AS mainContactEmail, contacts.ContactFax_AC AS mainContactFaxAreaCode, contacts.ContactFax AS mainContactFax, venues.VenueName AS EventVenueName, venues.VenueCity AS EventVenueCity, venues.VenueState AS EventVenueState FROMdbo.tbl_EP_Events AS events, dbo.tbl_EP_EventDateTime AS dates, dbo.tbl_EP_Venues AS venues, dbo.tbl_EP_EventContacts AS contacts WHERE (EventBeginDate #dateCompare# #searchDate# and events.EventScopeID = #eventScopeVariable#) and contacts.ContactID = events.EventMainContactID and venues.EventVenueID = events.EventVenueID and dates.EventID = events.EventID ORDER BY EventBeginDate #SortOrder# /cfquery the problem is that the template chokes when I try to use WHERE (EventBeginDate #dateCompare# #searchDate# and events.EventScopeID = #eventScopeVariable#) it seems that it doesn't like the alias in the where clause. I tried using MIN(dates.EventDate), but that doesn't work either. Is it possible to use aliases in the WHERE statement, or am I going to have to do this as two separate tables? Thanks, Chris Martin ~~ 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: Another debate
All of this boils down to opinion and personal choice. You say CF is a great technology and PHP is a good technology, while I say PHP is a great technology and CF is only a good technology... either way, we could argue this for hours, days, weeks, years and neither one of us (not you specifically, the general 'us' associated with mailing lists) would change the others mind... PHP has many advantages over CF, but they would only be advantages to somebody would could take advantage of them. Original Message - From: "DeVoil, Nick" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, December 14, 2000 2:19 AM Subject: RE: Another debate For a developer, PHP has *one* big advantage over CF - user-defined functions. With CF5 that advantage just disappeared. BTW, you *can* write DBMS-independent code with PHP, if you use PHPLIB. But you don't have all of CF's cacheing features built in. PHP is a good technology. CF is a great technology. $0.02 Nick. ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ 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: Another debate
I'm currently going through the same thing, except my new IT director's pushing for ASP and Java... ick... If he'd suggest PHP, I'd be all for it since I know PHP intimately, (and personally prefer it over CF, but that's strictly my opinion) - Original Message - From: "Michael Dinowitz" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, December 13, 2000 10:29 AM Subject: Re: Another debate As long as you write good code and follow all the security notes from the Allaire security zone, there is no security problem. From the tone and message of the email, he doesn't really care to hear the truth about it. To be honest, PHP has its strengths, but its still a script based language rather than a tag based one which means its slower to write than CF when integrating into HTML and doing output. Its DB work isn't all to good and the error handling is almost non-existent. If you look on the PHP site, there's actually a rather informative comparison of the two on some features. If the boss wants to listen and add PHP to your companies skill set, then I'd agree with him. If he just wants to dump all of the CF stuff for PHP, then argue with him about it. Bring your proofs and back it up with the fact that CF is accepted by the corporate industry while PHP isn't (yet). The new boss has arrived in my department and of course he wants everyone to switch from the awesome and all mighty cold fusion to PHP. We do need some other strengths in our department for those clients who don't want us to host their application or don't have cf on their server, but, he wants a complete switch. Here is a glimpse into his last email: "It could be argued that both technologies have their strengths and weaknesses. However, in the corporate IT department, CF is usually not an option due to cost and security problems. I realize that changing perceptions and old habits are sometimes difficult, but necessary. Especially in our industry (high-tech). The need to deliberate the issue further is a mute point." Does anyone have any opinions on his security problems comment? It seems that alliare is pretty good about getting patches up - or we have just been lucky and not had any problems. And, would you agree that in the corporate IT department cf is "usually" not an option? Thanks in advance for any input. ~~ 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: queries vs arrays
Yup, you can access queries like they're arrays... here's an example: CFQUERY NAME="qGraph" DATASOURCE="#DSN_Name#" USERNAME="#DSN_Username#" PASSWORD="#DSN_Password#" SELECT COUNT(FilePath) AS pathCount, FilePath FROM MasterFPPList GROUP BY FilePath /CFQUERY CFLOOP INDEX="x" FROM="1" TO="10" CFOUTPUT#qGraph.Filepath[x]#/CFOUTPUTBR /CFLOOP Joseph E. Sheble a.k.a. Wizaerd Wizaerd's Realm Canvas, 3D, Graphics, ColdFusion, PHP, and mySQL http://www.wizaerd.com = -Original Message- From: Kevin Willyerd [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 13, 2000 3:17 PM To: CF-Talk Subject: queries vs arrays In Ben Fortas he says "ColdFusion queries are essentially arrays with named collumns. You may therefore use any of the array functions with queries" Does this mean ther is a way to address queries in the form Query [row] [collumname]? I have tried and can not get it to work. Kevin ~~ 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: Replace
I'm no means an expert in regular expressions, but wouldn't it be easier and quicker to use ReReplace() with a regular expression to remove letters? Especially if it was a rather long text string, looping through it and concatenating the string would be inefficient... - Original Message - From: "Lee Moore" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, December 11, 2000 7:05 AM Subject: Re: Replace I'm not sure if this is the best solution but it should work. cfset strIn = "k2i5dows38293fd7u0c2wdslk65jsf9" cfset strOut = "" cfloop index="i" from="1" to="#len(strIn)#" cfset char = mid(StrIn,i,1) cfset strOut = strOut iif(IsNumeric(char),DE(char),DE("")) /cfloop cfoutput#strOut#/cfoutput Lee Moore Senior Project Manager WarpDrive Networks 201 825-4600 x 320 ~~ 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: Assembler.....
C++ was only efficient before MS developed the bloated MFC... Remember OWL? Now there was efficiency - Original Message - From: "DeVoil, Nick" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, December 05, 2000 4:02 AM Subject: RE: Assembler. Mike, Yes, you could write COM objects in assembler. COM is a language-independent binary standard. But I wouldn't do that if I were you. C++ is pretty efficient too you know. Nick -Original Message- From: Michael Thomas [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 05, 2000 8:26 AM To: CF-Talk Subject: Assembler. Lately I wuz thinking of picking up an extra language to add to my long list of the ones I currently know ;) As most people know you can develop custom COM, CORBA, CFX other types of add-ons using alot of different languages like C++, VB, Java etc. etc. What I am wondering is if anyone out there knows if I can create COM or CFX extensions through assembly/assembler language. I know its a pretty old language but its also pretty efficient. If anyone has anything to comment about this, please do ;) I will be one extremely greatful person. TIA, Mike ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ 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: Big companies using CF
having worked for onvia.com (their newly aquired phoenix office) I wouldn't offer them as being a good or even efficient example of CF usage... - Original Message - From: "Michael She" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, December 05, 2000 5:59 AM Subject: Re: Big companies using CF onvia.com and even Hewlett Packard uses it for their site. At 07:18 PM 12/04/00 -0700, Joe Sheble aka Wizaerd you wrote: I know this is probably one of those discussions that turn up all the time on a mailing list such as this, and I apologize for bringing it up. I have a new IT Director starting at my company in the very near future who's a big Microsoft fan, and thinks there's nothing better than ASP and/or C# (which I believe hasn't even been released yet, no?). When I told him that CF has been around for a long time, and some really big companies use it, he doubted it. I told him Amazon.com was using it (was I right about this?). So anyway, I've agreed to compile a list of some of the bigger well known internet comapnies using it, and would like some assistance. What big time comapnies are using CF for their pages? thanx... Joseph E. Sheble a.k.a. Wizaerd Wizaerd's Realm Canvas, 3D, Graphics, ColdFusion, PHP, and mySQL http://www.wizaerd.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: Big companies using CF
I've been assured (yeah, like I'll blindly accept it) that this won't happen. They've invested too much for a sudden change in direction... but I'm keeping my fingers crosses nonetheless... - Original Message - From: [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, December 05, 2000 9:09 AM Subject: Re: Big companies using CF Joe, You did say "new IT Director". My suggestion is to learn to "LOVE" ASP or find a new job. Pointing out to your new boss the errors in his thinking will will be about as logical as the current presidential political arguments. :o)) Jeff Craig - Original Message - From: "Joe Sheble aka Wizaerd" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, December 05, 2000 8:00 AM Subject: Re: Big companies using CF having worked for onvia.com (their newly aquired phoenix office) I wouldn't offer them as being a good or even efficient example of CF usage... - Original Message - From: "Michael She" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, December 05, 2000 5:59 AM Subject: Re: Big companies using CF onvia.com and even Hewlett Packard uses it for their site. At 07:18 PM 12/04/00 -0700, Joe Sheble aka Wizaerd you wrote: I know this is probably one of those discussions that turn up all the time on a mailing list such as this, and I apologize for bringing it up. I have a new IT Director starting at my company in the very near future who's a big Microsoft fan, and thinks there's nothing better than ASP and/or C# (which I believe hasn't even been released yet, no?). When I told him that CF has been around for a long time, and some really big companies use it, he doubted it. I told him Amazon.com was using it (was I right about this?). So anyway, I've agreed to compile a list of some of the bigger well known internet comapnies using it, and would like some assistance. What big time comapnies are using CF for their pages? thanx... Joseph E. Sheble a.k.a. Wizaerd Wizaerd's Realm Canvas, 3D, Graphics, ColdFusion, PHP, and mySQL http://www.wizaerd.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: cfstored procedure problem
CFSTOREDPROC DATASOURCE="#application.datasource#" DBNAME="userpreferences" PROCEDURE="GetUserID" CFPROCPARAM CFSQLTYPE="CF_SQL_VARCHAR" DBVARNAME="@SAMAccountName" VALUE="#GetUser.SAMAccountName#" TYPE="In" !--- CFPROCPARAM TYPE="Out" DBVARNAME="@UserID" VARIABLE="UserID" CFSQLTYPE="CF_SQL_INTEGER" --- CFPROCRESULT NAME="UserID /CFSTOREDPROC Your second call to CFPROCPARAM is specifying that your procedure accepts two arguments. You only have one listed in your example, so I'm assuing that you were calling the procedure in-correctly. Joseph E. Sheble a.k.a. Wizaerd Wizaerd's Realm Canvas, 3D, Graphics, ColdFusion, PHP, and mySQL http://www.wizaerd.com = -Original Message- From: S R [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 05, 2000 2:46 PM To: CF-Talk Subject: cfstored procedure problem Hi everyone, I can't figure this one out. I'm using SQL Server 7.0 and CF 4.5 This is my stored procedure in SQL: @SAMAccountName varchar AS SELECT UserID FROM PasUsers WHERE SAMAccountName = '@SAMAccountName' Here is my CF Code: CFLDAP NAME="GetUser" SERVER="LDAPSERVER.COM" ACTION="QUERY" ATTRIBUTES="SAMAccountName" SCOPE="subtree" FILTER="SAMAccountName=#cgi.auth_user#" START="" USERNAME="mydomain\sal.rosales" PASSWORD="password" PORT="" TIMEOUT="30" CFSTOREDPROC DATASOURCE="#application.datasource#" DBNAME="userpreferences" PROCEDURE="GetUserID" CFPROCPARAM CFSQLTYPE="CF_SQL_VARCHAR" DBVARNAME="@SAMAccountName" VALUE="#GetUser.SAMAccountName#" TYPE="In" CFPROCPARAM TYPE="Out" DBVARNAME="@UserID" VARIABLE="UserID" CFSQLTYPE="CF_SQL_INTEGER" /CFSTOREDPROC cfoutput#UserID#/cfoutput I keep getting a 'Data Access Error Unknown data' Sal ~~ 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
Big companies using CF
I know this is probably one of those discussions that turn up all the time on a mailing list such as this, and I apologize for bringing it up. I have a new IT Director starting at my company in the very near future who's a big Microsoft fan, and thinks there's nothing better than ASP and/or C# (which I believe hasn't even been released yet, no?). When I told him that CF has been around for a long time, and some really big companies use it, he doubted it. I told him Amazon.com was using it (was I right about this?). So anyway, I've agreed to compile a list of some of the bigger well known internet comapnies using it, and would like some assistance. What big time comapnies are using CF for their pages? thanx... Joseph E. Sheble a.k.a. Wizaerd Wizaerd's Realm Canvas, 3D, Graphics, ColdFusion, PHP, and mySQL http://www.wizaerd.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