Re: History list
What about setting cookies? Use five cookies named LocationX and on each page loop through them all and append the current page and remove the oldest. Then loop through the cookies and print the links. Jon - Original Message - From: Parker, Kevin [EMAIL PROTECTED] To: CF Talk (E-mail) [EMAIL PROTECTED] Sent: Friday, August 11, 2000 12:45 AM Subject: History list This may actually be best achieved with a JavaScript solution so I apologise if some regard it as OT. We're deploying one of our large manuals to the web (which is currently distributed as a Win 3.1 help file - those were the days) as HTML. One of its features (the win help version) is that it has a history function and users can back track. I want to try an emulate this for the last 5 or so pages the user was on. I know you can do this by using a href and using history - 1, history -2 etc but rather than have a simple image or bit of static text with a link I want to actually try to produce a small list with the name of the page they were on, linked to that page (the link can use history -1 etc but I want to actually get the name of the page if I can). After all users won't remember what the page was 5 clicks ago but it will help them if they can see the name of the page. The history function in JavaScript doesn't appear to provide this info. Any clue please. Kevin Parker Service and Communication WorkCover Corporation [EMAIL PROTECTED] ph: +61 8 82332548 fax: +61 8 82332000 This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Latest WDDX_COM.DLL
In-Reply-To: 001401c00317$c18f77b0$[EMAIL PROTECTED] Thanks, Dave Terry Riley Riley Varea Associates, London, UK --Original Message-- Can anyone enlighten me as to the latest version of the WDDX COM object? I can't find anything on the Allaire site that shows that anything has been 'issued' since the 4.0.1 upgrade. The one on my machine is version 1,0,0,1 dated 9 April 99. Have you checked http://www.wddx.org/? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: History list
Thanks Jon - didn't consider cookies and haven't used them before. This also assumes that the end user has cookies enabled. Kevin Parker Service and Communication WorkCover Corporation [EMAIL PROTECTED] ph: +61 8 82332548 fax: +61 8 82332000 -Original Message- From: Jonathan Karlen [mailto:[EMAIL PROTECTED]] Sent: Thursday, 10 August 2000 4:43:PM To: [EMAIL PROTECTED] Subject: Re: History list What about setting cookies? Use five cookies named LocationX and on each page loop through them all and append the current page and remove the oldest. Then loop through the cookies and print the links. Jon - Original Message - From: Parker, Kevin [EMAIL PROTECTED] To: CF Talk (E-mail) [EMAIL PROTECTED] Sent: Friday, August 11, 2000 12:45 AM Subject: History list This may actually be best achieved with a JavaScript solution so I apologise if some regard it as OT. We're deploying one of our large manuals to the web (which is currently distributed as a Win 3.1 help file - those were the days) as HTML. One of its features (the win help version) is that it has a history function and users can back track. I want to try an emulate this for the last 5 or so pages the user was on. I know you can do this by using a href and using history - 1, history -2 etc but rather than have a simple image or bit of static text with a link I want to actually try to produce a small list with the name of the page they were on, linked to that page (the link can use history -1 etc but I want to actually get the name of the page if I can). After all users won't remember what the page was 5 clicks ago but it will help them if they can see the name of the page. The history function in JavaScript doesn't appear to provide this info. Any clue please. Kevin Parker Service and Communication WorkCover Corporation [EMAIL PROTECTED] ph: +61 8 82332548 fax: +61 8 82332000 This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Structs contained within the application scope?
Umm, what am I missing here? As I was about to type in the duplicate function, I thought "wait, we use structcopy with structures more than one level deep", so I did some testing and I can't recreate this problem (or expected behavior) in either 4.0.1 or 4.5. I was able to structcopy a structure multiple levels deep, and assign the application structure to a variable. The only problem I ran into is that doing a structcopy on the application variable was the same as a simple assignment - it was still just a pointer. Here is one of the tests I ran - (cf_objectdump is from the developer's exchange): cfset application.one = structnew() cfset application.one.two = structnew() cfset application.one.two.three = structnew() cfset application.one.four = "four" cfset application.one.two.five = "five" cfset application.one.two.three.six = "six" cf_objectdump object="#application.one#" cfset test = application.one cf_objectdump object="#test#" cfset application.one.four = "fourteen" cf_objectdump object="#test#" cfset test2 = structcopy(application.one) cf_objectdump object="#test2#" cfset application.one.four = "twentyfour" cf_objectdump object="#test2#" Am I missing something that will bite me in the rear in the future? Or just totally misunderstanding this e-mail. Thanks, Dan snip I can get around this problem by manually copying the struct like so (but it's a pain in the rear): CFSET App.test = StructCopy(Application.test) So my question is... Shouldn't the StructCopy() function copy the entire struct, and any other structs stored inside it? Has anyone else run into this experience, or is it considered expected behavior when copying structs which contain other structs? This is expected behavior with StructCopy; it only copies "one level deep". If you want to make a complete duplicate, no matter how many nested data containers you have, use the Duplicate function introduced in CF 4.5.1, which makes a "deep copy". Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: (IIS) Customer file uploads - restrictions of file types
One security aspect you need to evaluate is discussed on Bugtraq @: http://www.ntbugtraq.com/default.asp?pid=36sid=1A2=ind9809L=NTBUGTRAQP=R 2454 It deals with the default upload directory being c:\winnt -- Rich Wild Senior Web Designer --- e-mango.com ltd Tel: 01202 587 400 Lansdowne Place Fax: 01202 587 401 17 Holdenhurst Road Bournemouth Mailto:[EMAIL PROTECTED] BH8 8EW, UK http://www.e-mango.com --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of e-mango.com ltd, unless otherwise explicitly and independently indicated by an authorised representative of e-mango.com ltd. --- -Original Message- From: Dan Haley [mailto:[EMAIL PROTECTED]] Sent: 10 August 2000 18:43 To: '[EMAIL PROTECTED]' Subject: (IIS) Customer file uploads - restrictions of file types We are getting requests from our customers to upload files to a password secured area of our site so they can share them with other users from their company, as well as with our internal people. The intent is for files like Excel, Word, and Powerpoint documents. Some of the restrictions we need to do are pretty straightforward, like who can upload, who can delete, total file size, etc., but what pitfalls do I need to watch out for from a server security standpoint? We are on IIS 4.0, Windows NT 4.0 SP5, CF4.5 ENT, with plans to go to Win2000. Is it as simple as restricting certain executable file types? All advice is truly appreciated . . . unless Dave Watts sends me more code from our site . . . whoops . . . :) Thanks, Dan -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
[OT] REQ testimonials from SAG Electronics customers.
Hello, We're thinking about spending $$ with http://www.sagelectronics.com/. 2U rack servers. Testimonials are encouraged, off list if you prefer. Thanks, Rick [EMAIL PROTECTED] __ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: server printing
No, not unless you want to write a COM or you can us can COM from MS Access and you can tell that to print any thing from Access. But it you can only use the default printer setup on that system I am writing a Com object in Delphi that will let me print any Access Report from the ColdFusion to any printer on the network. It will also let me send information to Access to fill the report with the data. E.g. You could design a Report in Access with no data in it and then the ColdFusion would send the info to the COM which get the report from access fill the data in the right places in the forum and send it to any print on that computer you want. From Rif -Original Message- From: Jason Egan [mailto:[EMAIL PROTECTED]] Sent: 10 August 2000 18:23 To: Cf-Talk Subject: server printing Is there a way with cf (or maybe js) to print from a web app to a printer attached to the cf server or the network it is on? Say, I want to print a document from out of town to the printer on the network for someone to look at or whatever... thanks, je -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Is there a variable for a query's name?
umm that was part of the joke. I wish I could take credit for it, but I believe is Daniel Maguire's - Original Message - From: "David Shadovitz" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 10, 2000 6:37 PM Subject: Re: Is there a variable for a query's name? I must be the most unarticulate person on these lists. Yes. It's "inarticulate." -David-who-did-better-on-the-English-part-of-the-SAT-than-on-the-math-par t-but-who-works-as-a-programmer-anyway YOU'RE PAYING TOO MUCH FOR THE INTERNET! Juno now offers FREE Internet Access! Try it today - there's no risk! For your FREE software, visit: http://dl.www.juno.com/get/tagj. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE:
Sorry Adam Reynolds -- From: Chapman, Katrina[SMTP:[EMAIL PROTECTED]] Sent: 10 August 2000 18:00 To: [EMAIL PROTECTED] Subject: RE: Let's not get pissy Adam. Sree, It should work. IT should be exaclty like this CFHTTP URL="http://www.amazon.com" METHOD="GET" RESOLVEURL=YES /CFHTTP CFOUTPUT PYour file was of type: #CFHTTP.MimeType# P#HTMLCodeFormat(CFHTTP.FileContent)# /CFOUTPUT I ran it and it returned everything just fine. What is happening on your end. --K -Original Message- From: Reynolds, Adam [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 10, 2000 6:19 AM To: '[EMAIL PROTECTED]' Subject: RE: Love the lack of subject line...makes it so easy to see what your problem is. Adam Reynolds -- From: Sree@bigbuzz[SMTP:[EMAIL PROTECTED]] Sent: 10 August 2000 15:22 To: [EMAIL PROTECTED] This is a multi-part message in MIME format. --=_NextPart_000_0020_01C002AC.712ABA70 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Any wrong with this? cfhttp url=3D"http://www.amazon.com" method=3D"get" Thanks=20 Sree --=_NextPart_000_0020_01C002AC.712ABA70 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.2314.1000" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2Any wrong with this?/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2lt;cfhttp = url=3D"http://www.amazon.com"=20 method=3D"get"gt;/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Thanks /FONT/DIV DIVFONT face=3DArial size=3D2Sree/FONT/DIV/BODY/HTML --=_NextPart_000_0020_01C002AC.712ABA70-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. ** This email and any attachments are confidential and solely for the use of the intended recipient. They may contain material protected by legal professional or other privilege. If you are not the intended recipient or the person responsible for delivering to the intended recipient, you are not authorised to and must not disclose, copy, distribute or retain this email or its attachments. Although this email and its attachments are believed to be free of any virus or other defect, it is the responsibility of the recipient to ensure that they are virus free and no responsibility is accepted by the company for any loss or damage arising from receipt or use thereof. ** -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. ** This email and any attachments are confidential and solely for the use of the intended recipient. They may contain material protected by legal professional or other privilege. If you are not the intended recipient or the person responsible for delivering to the intended recipient, you are not authorised to and must not disclose, copy, distribute or retain this email or its attachments. Although this email and its attachments are believed to be free of any virus or other defect, it is the responsibility of the recipient to ensure that they are virus free and no responsibility is accepted by the company for any loss or damage arising from receipt or use thereof. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: IE Browser Cache-Help
I have a page in my application which I do not wish to cache. I have put the META tag to prevent caching as follows: META HTTP-EQUIV="Expires" CONTENT="Fri, Jun 12 1981 08:20:00 GMT" META HTTP-EQUIV="Pragma" CONTENT="no-cache" META HTTP-EQUIV="Pragma:no-cache" META HTTP-EQUIV="Cache-Control" CONTENT="no-cache" Also i tried CFHTTP header: CFHEADER NAME="Expires" VALUE="#Now()#" but IE still is able to cache pages. Netscape responds well. Any clues. I wish to programatically control this. I have no control over the Server Configurations. AFAIK, IE4/5 have this lovely ability to over-ride the page settings for expiry. With IE5, when the setting is "Automatic" it takes note of the setting, but that's the only one that seems to - if the user sets it's on "Never" then you won't be able to touch it. It's a real PITA, but that's Micro$oft for you... Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Array Confusion
How do I populate a one dimensional array from a query?? I'm having trouble figuring out how I make the 'Array number' dynamic: cfquery datasource="Tester" name="GetNumbers" SELECT Quantity, ID FROM TestTable /cfquery cfoutput query="GetNumbers" cfset QuantityTotal = ArrayNew(1) cfset QuantityTotal[??]] = #Quantity# /cfoutput Or as an alternative approach to Derek's (which will put the top value into all entries of the array) cfset QuantityTotal=ArrayNew(1) cfloop query="GetNumbers" cfset QuantityTotal[CurrentRow]=Quantity /cfloop Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Can CF be run on a machine which is also running Service Pack 6 Alpha?
The problem is that there is a tag or two that don't work on SP 6. I can't remember which one(s), but you may be able to find it on the Allaire site. That's where I first read about the problem. CFContent apparently has problems, and Allaire recommend going back to SP5 if you use it - I use SP6a quite happily as I (currently) don't use CFContent at all Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Problem carrying over form values.
You can try replacing the " with some string you know the person will not enter, like §, or some other character entity. Then you can get that data from the hidden form field and convert it back before entering it into the database. There's a neater solution that this one - rather than having to re-convert it back later... input type="hidden" name="comments" value="#Replace(form.Comments,,"quot;","All")#" You can use this for all form types, and the HTML is converted when the form passes it along Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Need your help desperately...
I would agree with this, for the simple fact I hold no degrees in anything. But I am a very quick learner, and work hard to achieve what I set out to do. I have 20 years programming experience, and have dabbled in a lot of languages. I have a very impressive resume, and the ability to sell my skills. I did think the CF certificate would make it easier to say you know CF, but what about programming logic this is a lot harder to learn and comes from experience. I see the Allaire Certificate for CF a waste of my time, only because I believe in my ability to do the work and think that my work in the industry will be enough to keep working in it. I have to totally agree with this assessment - I never went to Uni, hold no degrees or real qualifications in programming, but I've been a programmer/developer for the last 10-12 years (in a variety of languages) I cheated on finding a job though, I own a third of my company g I'm actually taking the CF Certification in November (at the Conference) just so that clients are more at ease with the development work - I prove that I can do the work by the sites I've developed, not by a piece of paper Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: in one query refers to 2 different odbc sources
I have 2 databases located on the 2 different NT servers, Is there any way i can write one query that refers to different odbc sources, if yes, how and the syntax, If they are the same database type, then there is usually a way... in SQL Server it's quite easy; cfquery name="myQuery" datasource="myDSN" select t1.column1, t2.column2 from table1 as t1, serverName.databaseName.dbo.table2 as t2 ... /cfquery using Access you can refer to the database by a it's exact location, but I can't remember the code as I haven't worked in Access for over a year now If they are differing database types, as in Access and SQL Server, then no, you can't Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Optimization tips collection
There is a lot of conflicting information on how to properly set up an Access datasource. For me anyway, I've found that Access sites are much more stable when the database connection is NOT persistent, and the max number of connections is set to around 5. I found sites much more stable by not using Access g Remember that Access has the horrid maximum 50 concurrent connections - that counts for multiple uses on the same template, and over any databases as it's the MSJet driver that has the limit, not the database Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Need your help desperately...
The latter sounds good, but no it was a typo and hase been rectified I don't look good in a dress anyway:-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, 11 August 2000 11:35 AM To: [EMAIL PROTECTED] Subject: RE: "Need your help desperately..." "Scott, Andrew" [EMAIL PROTECTED]wrote: Andrea Scott ANZ eCommerce Centre * Ph 9273 0693 * [EMAIL PROTECTED] So which is it? Andrew or Andrea? Or are there multiple personalities all fighting each other? :-) Rob Keniger -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: History list
This may actually be best achieved with a JavaScript solution so I apologise if some regard it as OT. We're deploying one of our large manuals to the web (which is currently distributed as a Win 3.1 help file - those were the days) as HTML. One of its features (the win help version) is that it has a history function and users can back track. I want to try an emulate this for the last 5 or so pages the user was on. I know you can do this by using a href and using history - 1, history -2 etc but rather than have a simple image or bit of static text with a link I want to actually try to produce a small list with the name of the page they were on, linked to that page (the link can use history -1 etc but I want to actually get the name of the page if I can). After all users won't remember what the page was 5 clicks ago but it will help them if they can see the name of the page. The history function in JavaScript doesn't appear to provide this info. Seeing as the history object in JavaScript is an array, you can refer to any of the entries in it - BUT, it calls them all by URL, it's only the browser that calls them by title The only way I can think of getting the titles is to run an (ugly) loop that briefly opens another window for that URL, grabs the title, then closes that window - this would mean loads of windows flicking into existance, then closing immediately. This would work, but it wouldn't be quick if the server connection was slow, oh, and did I mention it would be ugly? Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: History list
I would suggest using an array and the ArrayDeleteAt(array, position) ArrayAppend(array, value) so if you have a var session.history as you add a values use ArrayAppend(session.history, value) and if the array is over 5 entries use ArrayDeleteAt(session.history,1) Justin MacCarthy - Original Message - From: "Parker, Kevin" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 11, 2000 7:30 AM Subject: RE: History list Thanks Jon - didn't consider cookies and haven't used them before. This also assumes that the end user has cookies enabled. Kevin Parker Service and Communication WorkCover Corporation [EMAIL PROTECTED] ph: +61 8 82332548 fax: +61 8 82332000 -Original Message- From: Jonathan Karlen [mailto:[EMAIL PROTECTED]] Sent: Thursday, 10 August 2000 4:43:PM To: [EMAIL PROTECTED] Subject: Re: History list What about setting cookies? Use five cookies named LocationX and on each page loop through them all and append the current page and remove the oldest. Then loop through the cookies and print the links. Jon - Original Message - From: Parker, Kevin [EMAIL PROTECTED] To: CF Talk (E-mail) [EMAIL PROTECTED] Sent: Friday, August 11, 2000 12:45 AM Subject: History list This may actually be best achieved with a JavaScript solution so I apologise if some regard it as OT. We're deploying one of our large manuals to the web (which is currently distributed as a Win 3.1 help file - those were the days) as HTML. One of its features (the win help version) is that it has a history function and users can back track. I want to try an emulate this for the last 5 or so pages the user was on. I know you can do this by using a href and using history - 1, history -2 etc but rather than have a simple image or bit of static text with a link I want to actually try to produce a small list with the name of the page they were on, linked to that page (the link can use history -1 etc but I want to actually get the name of the page if I can). After all users won't remember what the page was 5 clicks ago but it will help them if they can see the name of the page. The history function in JavaScript doesn't appear to provide this info. Any clue please. Kevin Parker Service and Communication WorkCover Corporation [EMAIL PROTECTED] ph: +61 8 82332548 fax: +61 8 82332000 This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies.
OT: file upload problems with IIS
I am having trouble trying to do HTTP file uploads with IIS 4. I have heard there is some sort of update to put on to make it RFC 1867 (or whatever it is) compatible but cannot find it. Any help appreciated. Paul -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF-Talk V1 #134 (Out of office)
I am currently out of the office and will return on Monday, August 21. Any urgent concerns should be forwarded to David McCormick or Mary Prosceno. CF-Talk 08/11/00 06:37 CF-TalkFri, 11 Aug 2000 Volume 1 : Number 134 In this issue: Re: CustomTag /DIRECTORYat a SHARED HOSTING ISP ??? HELP!!! Preventing Browsers Cacheing a .cfm file Re: Preventing Browsers Cacheing a .cfm file RE: Problem carrying over form values. RE: CustomTag /DIRECTORYat a SHARED HOSTING ISP ??? HELP!!! RE: Preventing Browsers Cacheing a .cfm file Re: CustomTag /DIRECTORYat a SHARED HOSTING ISP ??? HELP!!! RE: OT eWebeditPro CFML RE: VERY SAD (was CFGRID onvalidate="???") RE: CF, ODBC and 64k data RE: CustomTag /DIRECTORYat a SHARED HOSTING ISP ??? HELP!!! Re: Certified? History list Re: History list RE: Latest WDDX_COM.DLL RE: History list RE: Structs contained within the application scope? RE: (IIS) Customer file uploads - restrictions of file types RE: VERY SAD (was CFGRID onvalidate="???") [OT] REQ testimonials from SAG Electronics customers. RE: server printing Re: Is there a variable for a query's name? RE: RE: Array Confusion RE: IE Browser Cache-Help RE: Can CF be run on a machine which is also running Service Pack 6 Alpha? RE: Problem carrying over form values. RE: "Need your help desperately..." RE: Optimization tips collection RE: in one query refers to 2 different odbc sources RE: "Need your help desperately..." RE: History list Re: History list OT: file upload problems with IIS -- Date: Fri, 11 Aug 2000 15:03:07 +1200 From: David Cummins [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: CustomTag /DIRECTORYat a SHARED HOSTING ISP ??? HELP!!! Message-ID: [EMAIL PROTECTED] I would actually disagree with that. Someone in our office tried calling a custom tag that alters the generated content with cfmodule, and it did not work correctly, even though it worked when called the standard way. He used /cfmodule at the end too. David Matthew Walker wrote: I just signed up with an ISP that does shared web hosting. i use to a stand alone machine and inserting my custom tags in the /customtags directory under my CF install. How would/should an ISP implement this kind of capability on a shared service where multiple sites are using one install of CF? The ISP will probably have you copy your custom tags directory under your root. You can either copy the custom tag to which ever directory you wish to call the tag from or you can put the tags in one central directory and use cfmodule to call your tags. I'm in the same situation. I place a customtags folder under the root of the site. Annoyingly, I can't use absolute paths (beginning with a /) to point to it (has to be set up on the server) so every time I want to call a custom tags I have to use a relative link with cfmodule. One thing to note is that custom tags that have a closing tag (e.g. cf_bodycontent/) will still work -- you just use /cfmodule instead. I'd really like to see notes in the Fusebox spec about using it in a shared environment like this. The number of CF Web hosting services is only going to grow Regards, Matthew Walker Electric Sheep Web Co. http://www.electricsheep.co.nz/ -- Tel +64-3-374 2137 Fax +64-3-377 7930 Mobile +64-25-605 5747 P O Box 13-907, Armagh Christchurch 8031 New Zealand -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Date: Fri, 11 Aug 2000 13:44:48 +1000 From: "AustralianAccommodation.com Pty. Ltd." [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Preventing Browsers Cacheing a .cfm file Message-ID: 00c701c00346$805015a0$71cbfea9@claudeslaptop This is a multi-part message in MIME format. --=_NextPart_000_00C4_01C0039A.5121F240 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Is the a code that will successfully prevent a .cfm page from being = cached on a users browser that will work effectively across browsers Kind Regards Claude Raiola (Director) AustralianAccommodation.com Pty. Ltd. Website: www.AustralianAccommodation.com Email: [EMAIL PROTECTED] --=_NextPart_000_00C4_01C0039A.5121F240 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
RE: dynamically updating one select list [code example]
This is a multi-part message in MIME format. --=_NextPart_000_00FB_01C00386.96C88AC0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hi Terri, I'm assuming I will have to (ugh) use a javascript for this? Admittedly, I am neither a javascript guru nor a coldfusion guru. Can anyone provide me with some direction on this? I've attached two files which I hope will start you going in the right direction. The first one doesn't specifically answer your question, but does deal with dynamically repopulating a form based on a selection. In the hope that other people will also find it useful. In the first example I'm populating a second drop down select box, based on the selection made in the first drop down box. The second file should give you a better solution to your problem. You'll need to tweek it slightly to suit your needs, but it's all there. I'm sure there are simpler ways to do this, but using the code in the second file may allow you to move forwards to more elaborate code/needs. You'll notice I also have more than one person in a department, where as you'll only be having one person per department, this'll be reflected I assume in your database. Good luck anyway. Oh yeah, the code won't "run straight out of the box" as it depends on two queries in a database, these are easy to build I've commented them in the code. Of course you'll also need to change the datasource. I've put working examples up at... http://www.phink.net/dynamicSelect.cfm http://www.phink.net/dynamicSelect2.cfm Thanks in advance! Terri Hope this helps someone. Dan. This message is intended only for the use of the person(s) ("the intended recipient(s)") to whom it is addressed. It may contain information which is privileged and confidential within the meaning of the applicable law. If you are not the intended recipient, please contact the sender as soon as possible.The views expressed in this communication may not necessarily be the views held by Live Information Systems Limited. --=_NextPart_000_00FB_01C00386.96C88AC0 Content-Type: application/octet-stream; name="dynamicSelect.cfm" Content-Transfer-Encoding: quoted-printable Content-Disposition: attachment; filename="dynamicSelect.cfm" !---=0A= // Title:Dynamic Select Example=0A= // Created: 11th August 2000=0A= // By: Daniel Kemp=0A= ---=0A= =0A= !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"=0A= =0A= html=0A= head=0A= titleUntitled/title=0A= =0A= !--=0A= // Here we get all the info we need from the databases=0A= ---=0A= =0A= !--- These are my two tables, the first one; departments has the = following fields...=0A= // id (int) The unique id of each department.=0A= // title (varchar) The title of each department.=0A= //=0A= // The contents look somewhat like=0A= //=0A= // id | title=0A= // --|-=0A= // 1 | Development=0A= // 2 | Resources=0A= // 3 | Sales=0A= ---=0A= =0A= cfquery name=3D"departments" datasource=3D"yme" dbtype=3D"ODBC"=0A= SELECT *=0A= FROM departments=0A= ORDER BY title=0A= /cfquery=0A= =0A= !--- The second; staff has the following fields...=0A= // id (int) The unique id of each member of staff=0A= // departmentID(int) The department they are in=0A= // title (varchar) The staff members name=0A= //=0A= // The contents look somewhat like=0A= //=0A= // id | departmentID | title=0A= //--|--=0A= // 1 | 1 | Bill=0A= // 2 | 1 | Colin=0A= // 3 | 2 | Dave=0A= // 4 | 3 | Eve=0A= // 5 | 2 | Fiona=0A= // 6 | 3 | George=0A= // 7 | 1 | Helen=0A= // 8 | 3 | Ian=0A= //=0A= // Notice in this case I have more then one member of staff in each = department, this is=0A= // to open up the uses of this JavaScript to more people, in Terri's = case there's only=0A= // one default person in each department.=0A= ---=0A= =0A= cfquery name=3D"staff" datasource=3D"yme" dbtype=3D"ODBC"=0A= SELECT *=0A= FROM staff=0A= ORDER BY title=0A= /cfquery=0A= =0A= !---=0A= // Now onto the funky JavaScript=0A= ---=0A= script language=3D"JavaScript"=0A= =0A= !---=0A= // This function is kinda like creating our own object like thing, = anyway it's an object=0A= // called anyStaff, which has three properties. I can use it as such...=0A= // anyStaff.ID =3D 1=0A= // anyStaff.title =3D 'Tony'=0A= //
Double Dimesion ArraySorting
hi, I was wondering how do I go about sorting a double dimension array ? Consider the second dimension to be ranging from 1-10. myarray[x][1] -- myarray[x][10] Now if I want to sort all the arrays in ascending order by the array[x][5] So that the order of the data myarray[x][1] -- myarray[x][10] would remain intact... ...how do I go about doing something like that ? Thanks vin -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: dynamically updating one select list [code example]
Guess the attachments didn't work too well, Here's the first file dynamicSelect.cfm. Sorry 'bout the wrap. -8-8-8-8-8-8- !--- // Title:Dynamic Select Example // Created: 11th August 2000 // By: Daniel Kemp --- !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" html head titleUntitled/title !-- // Here we get all the info we need from the databases --- !--- These are my two tables, the first one; departments has the following fields... // id (int) The unique id of each department. // title (varchar) The title of each department. // // The contents look somewhat like // //id | title // --|- // 1 | Development // 2 | Resources // 3 | Sales --- cfquery name="departments" datasource="yme" dbtype="ODBC" SELECT * FROM departments ORDER BY title /cfquery !--- The second; staff has the following fields... // id(int) The unique id of each member of staff // departmentID (int) The department they are in // title (varchar) The staff members name // // The contents look somewhat like // // id | departmentID | title //--|-- // 1 | 1 | Bill // 2 | 1 | Colin // 3 | 2 | Dave // 4 | 3 | Eve // 5 | 2 | Fiona // 6 | 3 | George // 7 | 1 | Helen // 8 | 3 | Ian // // Notice in this case I have more then one member of staff in each department, this is // to open up the uses of this JavaScript to more people, in Terri's case there's only // one default person in each department. --- cfquery name="staff" datasource="yme" dbtype="ODBC" SELECT * FROM staff ORDER BY title /cfquery !--- // Now onto the funky JavaScript --- script language="JavaScript" !--- // This function is kinda like creating our own object like thing, anyway it's an object // called anyStaff, which has three properties. I can use it as such... // anyStaff.ID = 1 // anyStaff.title = 'Tony' // anyStaff.departmentID = 6 --- function anyStaff(ID,title,departmentID) { this.ID = ID; this.title = title; this.departmentID = departmentID; } cfoutput !--- // We are now setting myStaff to be an array of the anyStaff object we defined above, // therefore we can now go... // myStaff[0].ID = 1 // myStaff[0].title = 'bengy' // etc. etc. for each member of staff we have --- var maxStaff = #staff.RecordCount#; myStaff = new Array(maxStaff); /cfoutput !--- // And this is the bit that loads up the array, --- cfset counter = 0 cfoutput query="staff" myStaff[#counter#] = new anyStaff('#ID#','#title#','#departmentID#'); cfset counter = counter + 1 /cfoutput !--- // The best way to see what happened is to view the source code created, which should look something like... // myStaff[0] = new anyStaff('1','Bill','1'); // myStaff[1] = new anyStaff('2','Colin','1'); // myStaff[2] = new anyStaff('3','Dave','2'); // myStaff[3] = new anyStaff('4','Eve','3'); // myStaff[4] = new anyStaff('5','Fiona','2'); // myStaff[5] = new anyStaff('6','George','3'); // myStaff[6] = new anyStaff('7','Helen','1'); // myStaff[7] = new anyStaff('8','Ian','3'); --- !--- // This function does all the hard work, when someone changes the selection // in the department box this function is called. To start with it empties // out the staff select box, then it attempts to re-populate it. It starts // with adding two default lines, and then loops though all the myStaff // objects we created above, checking to see if their departmentID matches // the ID given to use from the department select box. --- function changeStaff() { //Empty out the staff list box. document.formName.dropdown2.length = 0; //Get the current department ID value. var departmentID = document.formName.dropdown1.options[document.formName.dropdown1.select edIndex].value; //Add the 2 default lines. document.formName.dropdown2.options[0] = new Option('Select a staff member',-99); document.formName.dropdown2.options[1] = new Option('--',-99); //Set the counter up to add the rest of the recrods. var counter = 2; //Now loop through the staff to find the people who belong in this department. for (var i = 0; i maxStaff;i++) { //If this member of staffs departmentID matches the currently selected department ID //then we add them if (myStaff[i].departmentID ==
RE: dynamically updating one select list [code example]
Here's the second file dynamicSelect.cfm. Sorry 'bout the wrap. -8-8-8-8-8-8- !--- // Title:Dynamic Select Example // Created: 11th August 2000 // By: Daniel Kemp --- !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" html head titleUntitled/title !-- // Here we get all the info we need from the databases --- !--- These are my two tables, the first one; departments has the following fields... // id (int) The unique id of each department. // title (varchar) The title of each department. // // The contents look somewhat like // //id | title // --|- // 1 | Development // 2 | Resources // 3 | Sales --- cfquery name="departments" datasource="yme" dbtype="ODBC" SELECT * FROM departments ORDER BY title /cfquery !--- The second; staff has the following fields... // id(int) The unique id of each member of staff // departmentID (int) The department they are in // title (varchar) The staff members name // // The contents look somewhat like // // id | departmentID | title //--|-- // 1 | 1 | Bill // 2 | 1 | Colin // 3 | 2 | Dave // 4 | 3 | Eve // 5 | 2 | Fiona // 6 | 3 | George // 7 | 1 | Helen // 8 | 3 | Ian // // Notice in this case I have more then one member of staff in each department, this is // to open up the uses of this JavaScript to more people, in Terri's case there's only // one default person in each department. --- cfquery name="staff" datasource="remix" dbtype="ODBC" SELECT * FROM staff ORDER BY title /cfquery !--- // Now onto the funky JavaScript --- script language="JavaScript" !--- // This function is kinda like creating our own object like thing, anyway it's an object // called anyStaff, which has three properties. I can use it as such... // anyStaff.ID = 1 // anyStaff.title = 'Tony' // anyStaff.departmentID = 6 --- function anyStaff(ID,title,departmentID) { this.ID = ID; this.title = title; this.departmentID = departmentID; } cfoutput !--- // We are now setting myStaff to be an array of the anyStaff object we defined above, // therefore we can now go... // myStaff[0].ID = 1 // myStaff[0].title = 'bengy' // etc. etc. for each member of staff we have --- var maxStaff = #staff.RecordCount#; myStaff = new Array(maxStaff); /cfoutput !--- // And this is the bit that loads up the array, --- cfset counter = 0 cfoutput query="staff" myStaff[#counter#] = new anyStaff('#ID#','#title#','#departmentID#'); cfset counter = counter + 1 /cfoutput !--- // The best way to see what happened is to view the source code created, which should look something like... // myStaff[0] = new anyStaff('1','Bill','1'); // myStaff[1] = new anyStaff('2','Colin','1'); // myStaff[2] = new anyStaff('3','Dave','2'); // myStaff[3] = new anyStaff('4','Eve','3'); // myStaff[4] = new anyStaff('5','Fiona','2'); // myStaff[5] = new anyStaff('6','George','3'); // myStaff[6] = new anyStaff('7','Helen','1'); // myStaff[7] = new anyStaff('8','Ian','3'); --- !--- // This function does all the hard work, when someone changes the selection in the department box // this function is called. To start with it deselects all the items in the dropdown2 box, then it // Then it loops though all the list of staff members, finding out if they belong to that department. // Using the myStaff objects we created above, checking to see if their departmentID matches the ID // given to use from the department select box, if so make that item number selected. We use a counter // to keep track of how far we are through the list. --- function changeStaff() { // Deselects all the items for (var i = 0; i maxStaff;i++) { document.formName.dropdown2.options[i].selected = false; } // Get the current department ID value. var departmentID = document.formName.dropdown1.options[document.formName.dropdown1.select edIndex].value; var counter = 0; // Now loop through the staff to find the people who belong in this department. for (var i = 0; i maxStaff;i++) { // If this member of staffs
Framesets and URL variables
I want to pass a URL variable from a non-frame page to a frameset. Can all the different pages or frames in the frameset have access to that URL variable? Sebastian -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
randrange() function
Hi. This one is weird, unless there's something I've missed somewhere. I have this code: cfset pass = randrange(1736483927,9039930393) It returned this number: 1430463369 Shouldn't the number returned always be in the range specified? Is there a limit as to the size of the number this works on or something? Thanks, -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Framesets and URL variables
I want to pass a URL variable from a non-frame page to a frameset. Can all the different pages or frames in the frameset have access to that URL variable? Not by default, but you can pass them straight through the frameset into the individual pages/frames via the FRAME SRC= attribute. 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. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
[ot]Ouch at allaire.com
All of www.allaire.com down C:\ping www.allaire.com Pinging allaire.com [205.181.25.11] with 32 bytes of data: Reply from 4.0.5.74: TTL expired in transit. Request timed out. Request timed out. Request timed out. ~J -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Database problems
I have a strange problem with inserts in an Access table. I can't seem to wrap either a CFINSERT or an SQL insert within a CFTRANSACTION. Either method, without a CFTRANSACTION, will successfully insert a record in my table. But as soon as I try to use CFTRANSACTION, so I can get the ID of the record just inserted and CFLOCATION to the entry form, all I do is increment the database ID, but don't insert any data. Can anyone hazard a guess what's causing this? I've read everything I can get my hands on, and I can't seem to figure it out. Thanks, --John -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Oracle Date Time
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01C0038B.D2275F00 Content-Type: text/plain; charset="iso-8859-1" I found this query to return the date W/ a time value in Oracle in the forums. This seems to be the only way to get it to retrieve a time value for me: cfquery name="Get_DT" datasource="My_DS" select to_char(SYSDATE, 'DD-MM- HH24:MI:SS') LAST_UPDATE from DUAL /cfquery This works as i needed it to, but my problem is now updating that value in another table cfquery name="Get_DT" datasource="My_DS" UPDATE MyTable set LAST_UPDATE = '#Get_DT.LAST_UPDATE#' /cfquery This gives me an error stating it is an invalid date. Any ideas on how to accomplish this?? Thanks, Scott --_=_NextPart_001_01C0038B.D2275F00 Content-Type: text/html; charset="iso-8859-1" !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1" META content="MSHTML 5.50.4134.600" name=GENERATOR/HEAD BODY DIVFONT face=Arial size=2SPAN class=700385911-11082000I found this query to return the date W/ a time value in Oracle in the forums.nbsp; This seems to be the only way to get it to retrieve a time value for me:/SPAN/FONT/DIV DIVFONT face=Arial size=2SPAN class=700385911-11082000/SPAN/FONTnbsp;/DIV DIVFONT face=Arial size=2SPAN class=700385911-11082000lt;cfquery name="Get_DT" datasource="My_DS"gt;/SPAN/FONT/DIV DIVFONT face=Arial size=2SPAN class=700385911-11082000select to_char(SYSDATE, 'DD-MM- HH24:MI:SS') LAST_UPDATE/SPAN/FONT/DIV DIVFONT face=Arial size=2SPAN class=700385911-11082000from DUAL/SPAN/FONT/DIV DIVFONT face=Arial size=2SPAN class=700385911-11082000lt;/cfquerygt;/SPAN/FONT/DIV DIVFONT face=Arial size=2SPAN class=700385911-11082000/SPAN/FONTnbsp;/DIV DIVFONT face=Arial size=2SPAN class=700385911-11082000This works as i needed it to, but my problem is nownbsp;updating that value in another table/SPAN/FONT/DIV DIVFONT face=Arial size=2/FONTnbsp;/DIV DIVFONT face=Arial size=2 DIVFONT face=Arial size=2SPAN class=700385911-11082000lt;cfquery name="Get_DT" datasource="My_DS"gt;/SPAN/FONT/DIV DIVFONT face=Arial size=2SPAN class=700385911-11082000UPDATE MyTable set LAST_UPDATE = '#Get_DT.LAST_UPDATE#'/SPAN/FONT/DIV DIVFONT face=Arial size=2SPAN class=700385911-11082000/SPAN/FONT/DIV DIVFONT face=Arial size=2SPAN class=700385911-11082000lt;/cfquerygt;/SPAN/FONT/DIV DIVFONT face=Arial size=2SPAN class=700385911-11082000/SPAN/FONTnbsp;/DIV DIVFONT face=Arial size=2SPAN class=700385911-11082000This gives me an error stating it is an invalid date.nbsp; Any ideas on how to accomplish this??/SPAN/FONT/DIV DIVFONT face=Arial size=2SPAN class=700385911-11082000/SPAN/FONTnbsp;/DIV DIVFONT face=Arial size=2SPAN class=700385911-11082000Thanks,/SPAN/FONT/DIV/FONT/DIV DIVFONT face=Arial size=2Scott /FONT/DIV/BODY/HTML --_=_NextPart_001_01C0038B.D2275F00-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re:
hee hee hee hee I love this list. =)) -Gel - Original Message - From: Reynolds, Adam [EMAIL PROTECTED] Sorry Adam Reynolds -- From: Chapman, Katrina[SMTP:[EMAIL PROTECTED]] Let's not get pissy Adam. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: [ot]Ouch at allaire.com
Hmmm, wonder if the renewal process went crazy? Registrant: Allaire Corporation (ALLAIRE-DOM) One Alewife Center Cambridge, MA 02140 US Domain Name: ALLAIRE.COM Administrative Contact, Technical Contact, Zone Contact, Billing Contact: Master, Web (MW523-ORG) [EMAIL PROTECTED] Allaire Corporation One Alewife Center Cambridge , MA 02140 US 617-761-2000 Fax- 617-761-2001 Record last updated on 31-Jan-2000. Record expires on 12-Aug-2000. -- Record created on 11-Aug-1994. Database last updated on 10-Aug-2000 23:09:12 EDT. Domain servers in listed order: DNSAUTH1.SYS.GTEI.NET 4.2.49.2 DNSAUTH2.SYS.GTEI.NET 4.2.49.3 DNSAUTH3.SYS.GTEI.NET 4.2.49.4 -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: Friday, August 11, 2000 7:45 AM To: [cftalk] Subject: [ot]Ouch at allaire.com All of www.allaire.com down C:\ping www.allaire.com Pinging allaire.com [205.181.25.11] with 32 bytes of data: Reply from 4.0.5.74: TTL expired in transit. Request timed out. Request timed out. Request timed out. ~J -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Oracle Date Time
I found this query to return the date W/ a time value in Oracle in the forums. This seems to be the only way to get it to retrieve a time value for me: cfquery name="Get_DT" datasource="My_DS" select to_char(SYSDATE, 'DD-MM- HH24:MI:SS') LAST_UPDATE from DUAL /cfquery This works as i needed it to, but my problem is now updating that value in another table cfquery name="Get_DT" datasource="My_DS" UPDATE MyTable set LAST_UPDATE = '#Get_DT.LAST_UPDATE#' /cfquery This gives me an error stating it is an invalid date. Any ideas on how to accomplish this?? Your CF variable #Get_DT.LAST_UPDATE# is a string. You need to convert it back into a date for Oracle using TO_DATE() in your UPDATE statement. 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. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: [ot]Ouch at allaire.com
OY! That's aweful! I've taken the liberty to post a credit card payment to their domain renewal.. :) Gregory --- annex.com, Inc. - http://www.annex.com/ --- - If you EcoBuild it, they will come. - - http://www.ecobuilder.com/ - --- -Original Message- From: Ken Wilson [mailto:[EMAIL PROTECTED]] Sent: Friday, August 11, 2000 5:15 AM To: [EMAIL PROTECTED] Subject: RE: [ot]Ouch at allaire.com Hmmm, wonder if the renewal process went crazy? Registrant: Allaire Corporation (ALLAIRE-DOM) One Alewife Center Cambridge, MA 02140 US Domain Name: ALLAIRE.COM Administrative Contact, Technical Contact, Zone Contact, Billing Contact: Master, Web (MW523-ORG) [EMAIL PROTECTED] Allaire Corporation One Alewife Center Cambridge , MA 02140 US 617-761-2000 Fax- 617-761-2001 Record last updated on 31-Jan-2000. Record expires on 12-Aug-2000. -- Record created on 11-Aug-1994. Database last updated on 10-Aug-2000 23:09:12 EDT. Domain servers in listed order: DNSAUTH1.SYS.GTEI.NET 4.2.49.2 DNSAUTH2.SYS.GTEI.NET 4.2.49.3 DNSAUTH3.SYS.GTEI.NET 4.2.49.4 -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: Friday, August 11, 2000 7:45 AM To: [cftalk] Subject: [ot]Ouch at allaire.com All of www.allaire.com down C:\ping www.allaire.com Pinging allaire.com [205.181.25.11] with 32 bytes of data: Reply from 4.0.5.74: TTL expired in transit. Request timed out. Request timed out. Request timed out. ~J -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=list s/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
HELP: SQL Server Problems!
I am trying to find out where the Enterprise Manager and Query Analyzer is for SQL Server. The company at the moment uses PC Anywhere to log in to the machine and then work from there, but I want to be able to write SP's from here. We have the SQL Servr 7 disks, but I can't find where on those it is. HELP Paul -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Double Dimesion ArraySorting
Build a structure (associative array) where you have the value you are trying to sort (array[x][5]) as the keyname and the array[x] as the keyvalue * untested code ahead *** cfset myStruct = StructNew() cfloop from=1 to=ArrayLen(myarray) index=idx cfset result = StructInsert(myStruct, array[idx][5], array[idx]) /cfloop !--- Sort the array keynames cfset KeyNames = StructKeyArray(myStruct) cfset SortedKeys = ArraySort(KeyNames, "textnocase", "desc") !--- or what ever sort you want --- cfset MySortedArray = ArrayNew(1) cfloop from=1 to=arraylen(SortedKeys) index=idx cfset MySortedArray[idx] = StructFind(myStruct,SortedKeys[idx]) /cfloop or something like that , let me know how you get on ~Justin - Original Message - From: "Vincent" [EMAIL PROTECTED] To: "cftalk" [EMAIL PROTECTED] Sent: Friday, August 11, 2000 11:58 AM Subject: Double Dimesion ArraySorting hi, I was wondering how do I go about sorting a double dimension array ? Consider the second dimension to be ranging from 1-10. -- myarray[x][10] Now if I want to sort all the arrays in ascending order by the array[x][5] So that the order of the data myarray[x][1] -- myarray[x][10] would remain intact... ...how do I go about doing something like that ? Thanks vin -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Framesets and URL variables
Sebastian, I am doing what you want. FRAME.CFM (FILE CONTAINING FRAMESETS) cfoutput query="User" frame name="menu" src="menu.cfm?user=#Trim(user.username)#" frameborder="0" scrolling="no" frame name="contents" src="contents.cfm?user=#Trim(user.username)#" frameborder="0" scrolling="auto" /cfoutput CONTENTS.CFM (ONE OF THE FILES CONTAINING THE PASSED URL VARIABLE) cfquery name="User" datasource="lsars" select * from taavon.users where username= '#url.user#' /cfquery James sebastian palmigiani wrote: I want to pass a URL variable from a non-frame page to a frameset. Can all the different pages or frames in the frameset have access to that URL variable? Sebastian -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: dynamically updating one select list based upon the selection in another
Thanks, Truman! I'll check those out and give them a try... Original Message Follows From: "Truman Esmond III" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: RE: dynamically updating one select list based upon the selection in another Date: Thu, 10 Aug 2000 13:49:16 -0600 I would recommend Nate Weiss' CF_TwoSelectsRelated or CF_ThreeSelectsRelated tags which perform the functions you request; your preselections will be based on their order in the query rather than an absolute selection, but I think they'll do what your looking for. Truman -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 10, 2000 12:27 PM To: [EMAIL PROTECTED] Subject: dynamically updating one select list based upon the selection in another I have an update form in which the the user can choose an option from a select list. When this form is initially displayed, the current info from the database is automatically selected. This field happens to contain the names of various departments in our division. Each department has a default individual assigned to it (meaning that when a department is selected from the list, the information submitted will automatically be routed to the default person for that group). The field below that is a dynamically populated select list of all of the people in our division. If a user so chooses, they can override the default person assigned to a group, and specify someone else from this list. Now, here's what I want to do. When the form is first displayed, I want both the department select list AND the people list to have the current value in the db displayed (i.e. the department it will be routed to and the default contact person's name in that department). If, however, the user changes the name of the department to route to, I would like the list below it to automatically then select the default contact person's name for that department. In a nutshell, the first list will drive what is selected in the second list, but I want the second list to be independent (the first list will not change what is selected if I make a different selection in the second list). I'm assuming I will have to (ugh) use a javascript for this? Admittedly, I am neither a javascript guru nor a coldfusion guru. Can anyone provide me with some direction on this? Thanks in advance! Terri Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Can CF be run on a machine which is also running Service Pack 6 Alpha?
I havem't had any problems with CFCONtent and Sp6a. Maybe it was fixed in 4.5.1. Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Friday, August 11, 2000 4:33 AM To: [EMAIL PROTECTED] Subject: RE: Can CF be run on a machine which is also running Service Pack 6 Alpha? The problem is that there is a tag or two that don't work on SP 6. I can't remember which one(s), but you may be able to find it on the Allaire site. That's where I first read about the problem. CFContent apparently has problems, and Allaire recommend going back to SP5 if you use it - I use SP6a quite happily as I (currently) don't use CFContent at all Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Is there a variable for a query's name?
Sean, I see so much bad grammar (e.g. confusion over its/it's, your/you're) that I assumed this was more of the same. Oops. -David-who-failed-to-see-the-joke On Fri, 11 Aug 2000 01:35:22 -0700 "Sean Renet" [EMAIL PROTECTED] writes: umm that was part of the joke. I wish I could take credit for it, but I believe is Daniel Maguire's - Original Message - From: "David Shadovitz" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 10, 2000 6:37 PM Subject: Re: Is there a variable for a query's name? I must be the most unarticulate person on these lists. Yes. It's "inarticulate." -David-who-did-better-on-the-English-part-of-the-SAT-than-on-the-math-par t-but-who-works-as-a-programmer-anyway YOU'RE PAYING TOO MUCH FOR THE INTERNET! Juno now offers FREE Internet Access! Try it today - there's no risk! For your FREE software, visit: http://dl.www.juno.com/get/tagj. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFX_ONCR_CYBERCASH
This is a multi-part message in MIME format. --=_NextPart_000_0004_01C00374.05646890 Content-Type: multipart/alternative; boundary="=_NextPart_001_0005_01C00374.056775D0" --=_NextPart_001_0005_01C00374.056775D0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit Everybody, I downloaded the new version of CFX_ONCR_CYBERCASH (4.0) yesterday, to evaluate it on Solaris 2.7, CF Server 4.5.1 But after I install it, and try to access the tag by calling it, each time I get the following error: "Unable to load the library associated with the custom tag CFX_ONCR_CYBERCASH (/opt/coldfusion/CustomTags/cfx_oncr_cybercash.so) Error: ld.so.1: /opt/coldfusion/bin/cfserver: fatal: relocation error: file /opt/coldfusion/CustomTags/cfx_oncr_cybercash.so: symbol _pure_error_: referenced symbol not found Please check the LibraryPath entry for this tag in the custom tag database to verify that the library file exists and is accessible by the ColdFusion service." Everything is fine in the CF Service. Exccept maybe for the fact that I specified C++ as the type of CFX. Could it be Java ? Anyone had this problem, or still has it ? Please reply all. Frédéric LeMieux, Chaos Programmer ([EMAIL PROTECTED]) K-OS 5505 blvd. St-Laurent Montréal, Qc. http://www.k-os.com Once the music leaves yr head, it's already compromised. - Jack Brewer --=_NextPart_001_0005_01C00374.056775D0 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.3105.105" name=3DGENERATOR/HEAD BODY DIVFONT size=3D2SPAN = class=3D964511512-11082000Everybody,/SPAN/FONT/DIV DIVFONT size=3D2SPAN = class=3D964511512-11082000/SPAN/FONTnbsp;/DIV DIVFONT size=3D2SPAN class=3D964511512-11082000nbsp;nbsp;nbsp; = I downloaded=20 the new version of CFX_ONCR_CYBERCASH (4.0) yesterday, to evaluate it on = Solaris=20 2.7, CF Server 4.5.1/SPAN/FONT/DIV DIVFONT size=3D2SPAN class=3D964511512-11082000But after I install = it, and try=20 to access the tag by calling it, e/SPAN/FONTFONT size=3D2SPAN=20 class=3D964511512-11082000ach time I get the following = error:/SPAN/FONT/DIV DIVFONT size=3D2SPAN = class=3D964511512-11082000/SPAN/FONTnbsp;/DIV DIVSPAN class=3D964511512-11082000FONT size=3D2"Unable to load the = library=20 associated with the custom tag CFX_ONCR_CYBERCASH=20 (/opt/coldfusion/CustomTags/cfx_oncr_cybercash.so) /FONT PFONT size=3D2Error: ld.so.1: /opt/coldfusion/bin/cfserver: fatal: = relocation=20 error: file /opt/coldfusion/CustomTags/cfx_oncr_cybercash.so: symbol=20 _pure_error_: referenced symbol not found /FONT PFONT size=3D2Please check the LibraryPath entry for this tag in the = custom=20 tag database to verify that the library file exists and is accessible by = the=20 ColdFusion service."/FONT/P P/SPANFONT size=3D2SPAN class=3D964511512-11082000Everything is = fine in the=20 CF Service. Exccept maybe for the fact that I specified C++ as the type = of CFX.=20 Could it be Java ?/SPAN/FONT/P PFONT size=3D2SPAN class=3D964511512-11082000Anyone had this = problem, or still=20 has it ?/SPAN/FONT/P PFONT size=3D2SPAN class=3D964511512-11082000Please reply=20 all./SPAN/FONT/P/DIV DIVFONT size=3D2SPAN class=3D964511512-11082000nbsp;nbsp;nbsp;=20 /SPAN/FONT/DIV DIVFONT size=3D2Fr=E9d=E9ric LeMieux, Chaos Programmer (A=20 href=3D"mailto:[EMAIL PROTECTED]"[EMAIL PROTECTED]/A)/FONT/DIV DIVFONT size=3D2K-OS/FONT/DIV DIVFONT size=3D25505 blvd. St-Laurent/FONT/DIV DIVFONT size=3D2Montr=E9al, Qc./FONT/DIV DIVnbsp;/DIV DIVFONT size=3D2A=20 href=3D"http://www.k-os.com/"http://www.k-os.com/A/FONT/DIV DIVFONT size=3D2/FONT/DIV DIVFONT size=3D2Once the music leaves yr head, it's already=20 compromised./FONT/DIV DIVFONT=20 size=3D2nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbs= p;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;=20 - Jack Brewer/FONT/DIV DIVnbsp;/DIV/BODY/HTML --=_NextPart_001_0005_01C00374.056775D0-- --=_NextPart_000_0004_01C00374.05646890 Content-Type: text/x-vcard; name="=?iso-8859-1?B?RnLpZOlyaWMgTGVNaWV1eC52Y2Y=?=" Content-Transfer-Encoding: quoted-printable Content-Disposition: attachment; filename="=?iso-8859-1?B?RnLpZOlyaWMgTGVNaWV1eC52Y2Y=?=" BEGIN:VCARD VERSION:2.1 N:LeMieux;Fr=E9d=E9ric FN:Fr=E9d=E9ric LeMieux ORG:K-OS;Web development TITLE:Programmer TEL;WORK;VOICE:(514) 495-1122 TEL;HOME;VOICE:(514) 893-7155 TEL;CELL;VOICE:(514) 893-7155 TEL;WORK;FAX:(514) 495-1342 ADR;WORK:;;5505 St-Laurent, #4210;Montr=E9al;Qu=E9bec;H2T 1S6;Canada LABEL;WORK;ENCODING=3DQUOTED-PRINTABLE:5505 St-Laurent, = #4210=3D0D=3D0AMontr=3DE9al, Qu=3DE9bec H2T 1S6=3D0D=3D0ACanada URL: URL:http://www.k-os.com EMAIL;PREF;INTERNET:[EMAIL PROTECTED] REV:2622T125350Z
RE: Error Handling
I looked a bit into that , but I waant a message only for that error, and it doesn't seem like I can tell CFTRY to only catch the cfsearch error. Please tell me if I am wrong. -Original Message- From: Gregory Harris [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 09, 2000 12:59 PM To: [EMAIL PROTECTED] Subject: Re: Error Handling Hello Miriam. While I'm not too familiar with the CFSearch tag, I would imagine that the CFTRY/CFCATCH could pick up any such error and then you have control over how you'd handle it. Look up the CFTRY/CFCATCH statements, use those and tell me how it works out. Gregory Harris Los Angeles ITA Dept. [EMAIL PROTECTED] [EMAIL PROTECTED] 08/09 8:42 AM I am using CFSearch. If the user enters "and","or", "'" then I get a CF error. I would like to catch only this error and display a message to the user telling them that they entered invalid search criteria. Thanks, ---miriam -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=stsbody=sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: VERY SAD (was CFGRID onvalidate=???)
As Dave said, in a controlled environment they work fine, with our B2B apps the major concern is ease of use and the grids add some good functionality with very little overheadif you know who's gonna use em then use em :) The key there is controlled environments. If I have conrtol over the environment, the user has to be using IE 4+ and then I, personally, prefer to use IFRAME's. More flexibility and control over the data presentation and input. Using style sheets and IFRAME you can put together a pretty nice display. Duane Boudreau, eMPower Project Manager Director, Web Technologies Ektron, Inc. http://www.ektron.com 5 Northern Blvd, Suite 6 Amherst, NH 03031 Tel: 603-594-0249 x114 Fax: 603-594-0258 Stew It got to the point that our clients "requested" (AKA ordered) us to remove them from their sites. There customers were complaining quite a bit. We removed them and never looked back. In any instance now where we would consider using a CFGRID - usually in an admin section, we use IFRAME and warn users that IE is required. I am in the process of investigating ways of using flash instead of IFRAME. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: new worried (subquery)
Thanks for your help so far. Anthony Geoghegan was very helpful steering me in the right direction. I am trying to use a subquery in combination with a session variable to keep track of a customer's choices of malas (worry beads) on a web site that I would someday like to put on line. I guess it is a crude shopping cart. Anyway, I'll deal with the session variable stuff later. Right now I'm having trouble with the subquery. I am using two simple tables filled with a bunch of dummy values (maybe that's part of my problem). A file called mqapp_our_select.cfm located at http://www.digitalnature.net/hameed/mqapp_our_select.cfm is supposed to display a selection of wonderful malas. Right now the gifs are colored squares. When you click on one of them, you invoke the next template called mqapp_our_list.cfm. The query looks like this: CFQUERY DATASOURCE="data" NAME="mq_our" SELECT prod_num,bead FROM mq_our WHERE malaID IN (SELECT malaID FROM sessions WHERE session=#session_name#) ORDER BY prod_num /CFQUERY Instead of a session variable for now (to keep things simple) I'm just using a string: abc. In the second table called sessions I have some instances where abc appears in the session column. I want the query to pull the corresponding "malaID's" from the sessions table and use them in the mq_our table. But I get an error: ODBC Error Code = 07001 (Wrong number of parameters) [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. HELP! What am I doing wrong? For completeness the full error code can be viewed at http://www.digitalnature.net/hameed/error.txt. The application file can be viewed at http://www.digitalnature.net/hameed/application.txt. The code for mqapp_our_select.cfm can be viewed at http://www.digitalnature.net/hameed/mqapp_our_select.txt. The code for mqapp_our_list.cfm can be viewed at http://www.digitalnature.net/hameed/mqapp_our_list.txt. The mq_our table can be viewed at http://www.digitalnature.net/hameed/mq_our_1.html. And the sessions table can be viewed at http://www.digitalnature.net/hameed/sessions_1.html. If you see anything else in all that code that needs fixing please let me know! Thank you, kind people of cf-talk for any help you can offer! Megan -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: [ot]Ouch at allaire.com
Provider problems -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: Friday, August 11, 2000 6:45 AM To: [cftalk] Subject: [ot]Ouch at allaire.com All of www.allaire.com down C:\ping www.allaire.com Pinging allaire.com [205.181.25.11] with 32 bytes of data: Reply from 4.0.5.74: TTL expired in transit. Request timed out. Request timed out. Request timed out. ~J -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: [ot]Ouch at allaire.com
back up now -Original Message- From: Ann Harrell [mailto:[EMAIL PROTECTED]] Sent: Friday, August 11, 2000 8:43 AM To: '[EMAIL PROTECTED]' Subject: RE: [ot]Ouch at allaire.com Provider problems -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: Friday, August 11, 2000 6:45 AM To: [cftalk] Subject: [ot]Ouch at allaire.com All of www.allaire.com down C:\ping www.allaire.com Pinging allaire.com [205.181.25.11] with 32 bytes of data: Reply from 4.0.5.74: TTL expired in transit. Request timed out. Request timed out. Request timed out. ~J -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: [OT] REQ testimonials from SAG Electronics customers.
We've had very good experience with SAG. The dual Pentium 90(!) we got from SAG in 1995 is still plugging along. best, paul At 01:13 AM 8/11/00 -0700, you wrote: Hello, We're thinking about spending $$ with http://www.sagelectronics.com/. 2U rack servers. Testimonials are encouraged, off list if you prefer. Thanks, Rick [EMAIL PROTECTED] __ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: new worried (subquery)
CFQUERY DATASOURCE="data" NAME="mq_our" SELECT prod_num,bead FROM mq_our WHERE malaID IN (SELECT malaID FROM sessions WHERE session=#session_name#) ORDER BY prod_num /CFQUERY Megan, You need apostrophes around #session_name#. I don't know if that will solve the problem though! 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. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
From .exe to .dll
I am looking for resources regarding converting a dos based program into a dll that will run well from cold fusion. can anyone point me in the right direction? Thanks Mark Armendariz Righteous Desgin www.sorighteous.com [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFHTTP CFLOCK
Hey, I've got several scripts that grab content from other sites using CFHTTP. I've heard that i should be using CFLOCK around my calls to CFHTTP. What options should i specify? just: cflock timeOut=120 cfhttp ... /cflock Or do i need to specify the scope or something? btw, Using CF4.5.1 NT4 IIS Thanks Dave -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
OT: JavaScript CSS Detector
Sorry for the off topic... I use cf_browser to select browser and load different Style Sheets based on browser (thanks Netscape). I now have to do a co-branded "outside our server farm" web page that I still need to detect and load the different CSS's. I searched javascipts.com (which sadly is no longer CF) and found nothing. Does anyone have a snippets or other placers to check? Robert Forsyth Director of Web Operations Irides, LLC Phone: 202-364-7831 Fax: 202-364-2481 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: From .exe to .dll
Have you got the source code ??? What language was it written in? What does it do? ~Justin - Original Message - From: "Mark Armendariz" [EMAIL PROTECTED] To: "Cf-Talk" [EMAIL PROTECTED] Sent: Friday, August 11, 2000 2:55 PM Subject: From .exe to .dll I am looking for resources regarding converting a dos based program into a dll that will run well from cold fusion. can anyone point me in the right direction? Thanks Mark Armendariz Righteous Desgin www.sorighteous.com [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: VERY SAD (was CFGRID onvalidate=???)
How about.. http://www.dansteinman.com/dynduo/ For one such API :) -Original Message- From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]] Sent: Friday, August 11, 2000 10:03 AM To: [EMAIL PROTECTED] Subject: RE: VERY SAD (was CFGRID onvalidate="???") It got to the point that our clients "requested" (AKA ordered) us to remove them from their sites. There customers were complaining quite a bit. We removed them and never looked back. In any instance now where we would consider using a CFGRID - usually in an admin section, we use IFRAME and warn users that IE is required. Heh, heh, heh. Instead of restricting the browsers that were having problems you restrict everyone not using Internet Explorer. Don't get me wrong, in controlled situations, we only design for Internet Explorer 4 and up, but it seems like you're arguing 6 in one, half a dozen in the other. I still maintain that we've had no problems with the "stability" of the Allaire Java applets. We've used them in quite a few apps, though only in Intranet/Extranet/Administration apps, however, because we didn't feel the common user was comfortable with (or capable of) installing Java classes on their machine. I am in the process of investigating ways of using flash instead of IFRAME. iframe and ilayer are remarkably similar in terms of functionality, although they require completely different attributes and are referenced differently by JavaScript. However, if you developed a relatively simple JavaScript API, you can make alter the control the iframe/ilayer transparently. Take a look at O'Reilly's _DHTML: The Definitive Guide_ for a better explanation and an API from which to get started. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: HELP: SQL Server Problems!
If I remember correctly, you'll want to call up the SQL Server 7 CD. If it doesn't autorun, then you'll have to find the executable that the autorun is trying to launch. Run the installation (choose a "Custom" install if that is an option) and you'll receive a few options with check boxes. Uncheck the SQL Server option and leave the SQL Server client tools option checked. There's a couple other options there as well, but I can't remember what they are and whether or not you'll need them to run the tools. Hope this helps. I'm sorry I can't be more specific, but I don't have the CD in front of me right now. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED]] Sent: Friday, August 11, 2000 8:21 AM To: Cf-Talk Subject: HELP: SQL Server Problems! I am trying to find out where the Enterprise Manager and Query Analyzer is for SQL Server. The company at the moment uses PC Anywhere to log in to the machine and then work from there, but I want to be able to write SP's from here. We have the SQL Servr 7 disks, but I can't find where on those it is. HELP Paul -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: randrange() function
I have this code: cfset pass = randrange(1736483927,9039930393) It returned this number: 1430463369 Shouldn't the number returned always be in the range specified? Is there a limit as to the size of the number this works on or something? Integers in CF are limited to 32 bit numbers (thanks to M. Dinowitz for his FA article on this), which means that the largest integer value that CF understands is 2,147,483,647. This is a bit smaller than 9,039,930,393. My guess is that the large number you're passing to randRange() is causing a bit of internal confusion. I wrote a little test. I ran a loop 1000 times, each iteration generating a random number using the randRange() parameters you mentioned above. On 5 separate page loads, ALL 1000 numbers were less than 1,736,483,927. If I dropped the second parameter to a value within the allowed range, then randRange() performed as expected. Regards, Seth Petry-Johnson Argo Enterprise and Associates 2,147,483,648 and 2,147,483,647 1,736,483,927 9,039,930,393 I remember reading somewhere that CF had -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Error Handling
Miriam, If you put only the CFSEARCH code in the CFTRY block, only errors from that code will activate the error handler. If you need even finer resolution than that, you could check the actual error message (CFCATCH.Details, I think). -David On Fri, 11 Aug 2000 09:20:59 -0400 "Miriam Hirschman" [EMAIL PROTECTED] writes: I looked a bit into that , but I waant a message only for that error, and it doesn't seem like I can tell CFTRY to only catch the cfsearch error. Please tell me if I am wrong. -Original Message- From: Gregory Harris [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 09, 2000 12:59 PM To: [EMAIL PROTECTED] Subject: Re: Error Handling Hello Miriam. While I'm not too familiar with the CFSearch tag, I would imagine that the CFTRY/CFCATCH could pick up any such error and then you have control over how you'd handle it. Look up the CFTRY/CFCATCH statements, use those and tell me how it works out. Gregory Harris YOU'RE PAYING TOO MUCH FOR THE INTERNET! Juno now offers FREE Internet Access! Try it today - there's no risk! For your FREE software, visit: http://dl.www.juno.com/get/tagj. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: JavaScript CSS Detector
Use the Browers Sniffer at http://developer.iplanet.com/docs/examples/javascript/browser_type.html And dynamically write the css sheet document.write("style ") ~JustinMacCarthy - Original Message - From: "Robert Forsyth" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 11, 2000 3:01 PM Subject: OT: JavaScript CSS Detector Sorry for the off topic... I use cf_browser to select browser and load different Style Sheets based on browser (thanks Netscape). I now have to do a co-branded "outside our server farm" web page that I still need to detect and load the different CSS's. I searched javascipts.com (which sadly is no longer CF) and found nothing. Does anyone have a snippets or other placers to check? Robert Forsyth Director of Web Operations Irides, LLC Phone: 202-364-7831 Fax: 202-364-2481 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: From .exe to .dll
YEs, we have the source code. It's actually a proprietary application made by our own programmers to generate a password for our software. I believe it's written in C. The functions of the program are fairly basic. It asks about 10 questions (INPUT), and gives one answer depending on the input (OUTPUT). Our programmers are very capable. I just need to know where to look so i can ask them for this knowledgeably and answer any questions they may have from the get go. Or at least know ehre to send them for the answers they need. I would imagine we just need a means of giving the dll input and then getting the output via a variable. Thanks.. -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: Friday, August 11, 2000 10:01 AM To: [EMAIL PROTECTED] Subject: Re: From .exe to .dll Have you got the source code ??? What language was it written in? What does it do? ~Justin - Original Message - From: "Mark Armendariz" [EMAIL PROTECTED] To: "Cf-Talk" [EMAIL PROTECTED] Sent: Friday, August 11, 2000 2:55 PM Subject: From .exe to .dll I am looking for resources regarding converting a dos based program into a dll that will run well from cold fusion. can anyone point me in the right direction? Thanks Mark Armendariz Righteous Desgin www.sorighteous.com [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: VERY SAD (was CFGRID onvalidate=???)
How about.. http://www.dansteinman.com/dynduo/ For one such API :) And another: http://www.siteexperts.com/dhtmllib/page1.asp Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: From .exe to .dll
If you have the source code I would recommend wrapping the code in a cfx_tag. It's very simple. For example of cfx source code in C/C++ Have a look at the excellent www.intrafoundation.com . There is also some info in Ben's advanced book and plenty of help(!?!!?) on this list :-) If all that fails you chould use cfexecute ( or CFX_consoleCommand @ intrafoundation.com ) to capture the input from the dos program.. ~Justin MacCarthy - Original Message - From: "Mark Armendariz" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 11, 2000 3:23 PM Subject: RE: From .exe to .dll YEs, we have the source code. It's actually a proprietary application made by our own programmers to generate a password for our software. I believe it's written in C. The functions of the program are fairly basic. It asks about 10 questions (INPUT), and gives one answer depending on the input (OUTPUT). Our programmers are very capable. I just need to know where to look so i can ask them for this knowledgeably and answer any questions they may have from the get go. Or at least know ehre to send them for the answers they need. I would imagine we just need a means of giving the dll input and then getting the output via a variable. Thanks.. -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: Friday, August 11, 2000 10:01 AM To: [EMAIL PROTECTED] Subject: Re: From .exe to .dll Have you got the source code ??? What language was it written in? What does it do? ~Justin - Original Message - From: "Mark Armendariz" [EMAIL PROTECTED] To: "Cf-Talk" [EMAIL PROTECTED] Sent: Friday, August 11, 2000 2:55 PM Subject: From .exe to .dll I am looking for resources regarding converting a dos based program into a dll that will run well from cold fusion. can anyone point me in the right direction? Thanks Mark Armendariz Righteous Desgin www.sorighteous.com [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Newbie: JavaScript var and CF
Throws "Cannot evaluate" CF error. How do I pass a JavaScript created variable (in alert) back to CF on the same page. script language="JavaScript" !-- function Overwrite() { var x=window.confirm("Skill levels have been already assigned for this user. By clicking OK, you will *overwrite* all existing skill assignments. Click CANCEL to use an existing profile of this user."); if (x) return 1; else return 0; } // -- /script cfoutput#Overwrite()#/cfoutput !--- Throws an error --- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: [OT] REQ testimonials from SAG Electronics customers.
Have spent many $$ with SAG and have not had any real problems. Their systems are well built with quality components and their support is top notch. The only complaint I do have is that they do not have 24hour support (at least I don't think they do?). I only had to call support one time, 30 second hold time and I had the new hard drive in my hands by 9AM the next day. -- Original Message -- From: "Mooner Ent" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Fri, 11 Aug 2000 01:13:05 -0700 Hello, We're thinking about spending $$ with http://www.sagelectronics.com/. 2U rack servers. Testimonials are encouraged, off list if you prefer. Thanks, Rick [EMAIL PROTECTED] __ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Custom CF_ Tags
Im just starting to read the books about Custom tags, and im wondering if the file in the C:\CFUSION\CustomTags folder has to contain the actual code of the tag? Or is the file there just to name the tag?? Thanks Chad -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Newbie Question - Creating Data Source for CSV text file
Hi John, You could write a few lines of CF to convert the CSV file into a query (using CFHTTP), then cfoutput the query and insert each record into a db table. If there's a way to use a CSV file as a datasource, I'm not aware of it. Even if there is a way, you'd be better off transferring the data to a proper db, with the speed advantages of indexes and other db features. Gene Kraybill LPW Associates John McGown wrote: I have a customer that is a car dealership. They want to put their car inventory online. The company that makes their inventory database tells me that the data store is not ODBC compliant, but that they could output a CSV text file that they will auto-FTP to our servers in the middle of the night. Not exactly the most elegant solution, but it beats entering car data manually. :) Can I create an ODBC connection in the CF Administrator to use a CSV text file as a data source? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Newbie: Sessions
Thanks all for the help! Now if you can help me with this. I turn on session manegment in my application.cfm file and set the ime out for 10 min. I have a person enter username and password. If correct I set the session.login to yes. Now if they don't use the site for longer then 10 min., what happenes. Do I need to do some kind of a check on the session.login and then send them to the login page or what? If so, would I do it in the application.cfm page I just quit drinking caffeine so my brain is a little fuzzy, large, swollen Thanks, Art Hello, Argument for using session variables: We have a company directory with free listings for members of the natural food products industry (very recently released). We will give out login and passwords to companies (upon approval of their company as verifiable) so that they can either change information (address, phone numbers etc) and also so that they may "Upgrade" their listing to incorporate a lot of tools (very similar to the Thomas Register). When a user logs in we cannot be sure they are doing so from their personal home/office computer and since we do not want to leave a variety of differently named cookies that would contain information about the company on machines in public kiosks we decided to manipulate this information using session variables that store database values and some temporary values that a user may change when logged in via a form.. We use the session variables because they maintain state throughout the 15 odd screens that a user may go through (depending on how much they upgrade) in order to pull info user specific data from a database and from forms which then allows the user to update their information. This system has worked well for us. If I had to maintain any other type of variables from page to page in my application I think this project would be a lot less portable (right now adding a component is really easy since it is very fuse box like and the session variables get set in one file which get included in all the pages of the application.' If you had asked me 6 months ago if I would ever use session variables I probably would have said "NO" but this was one place I have found them very useful. Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: From .exe to .dll
I appreciate the quick reply... As for the cfx.h library. Would we just have to compile the code with an inclusion of cfx.h or is there any changes that would actually have to be made to the code itself? I'm waiting for Ben's advanced book in the mail.. hopefull to arrive on Monday. THANKS!! -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: Friday, August 11, 2000 10:39 AM To: [EMAIL PROTECTED] Subject: Re: From .exe to .dll If you have the source code I would recommend wrapping the code in a cfx_tag. It's very simple. For example of cfx source code in C/C++ Have a look at the excellent www.intrafoundation.com . There is also some info in Ben's advanced book and plenty of help(!?!!?) on this list :-) If all that fails you chould use cfexecute ( or CFX_consoleCommand @ intrafoundation.com ) to capture the input from the dos program.. ~Justin MacCarthy - Original Message - From: "Mark Armendariz" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 11, 2000 3:23 PM Subject: RE: From .exe to .dll YEs, we have the source code. It's actually a proprietary application made by our own programmers to generate a password for our software. I believe it's written in C. The functions of the program are fairly basic. It asks about 10 questions (INPUT), and gives one answer depending on the input (OUTPUT). Our programmers are very capable. I just need to know where to look so i can ask them for this knowledgeably and answer any questions they may have from the get go. Or at least know ehre to send them for the answers they need. I would imagine we just need a means of giving the dll input and then getting the output via a variable. Thanks.. -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: Friday, August 11, 2000 10:01 AM To: [EMAIL PROTECTED] Subject: Re: From .exe to .dll Have you got the source code ??? What language was it written in? What does it do? ~Justin - Original Message - From: "Mark Armendariz" [EMAIL PROTECTED] To: "Cf-Talk" [EMAIL PROTECTED] Sent: Friday, August 11, 2000 2:55 PM Subject: From .exe to .dll I am looking for resources regarding converting a dos based program into a dll that will run well from cold fusion. can anyone point me in the right direction? Thanks Mark Armendariz Righteous Desgin www.sorighteous.com [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Newbie Question - Creating Data Source for CSV text file
I think you can treat a csv file as an ODBC datasource, you just need to have the driver for it. RPS -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Newbie: Sessions
The way I've done it is to include a template that on all protected pages that checks for one of the session variables that I know should be set, and if the check returns false, redirect the user to a re-login page. There are probably more efficient ways though... -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Art Broussard [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Friday, August 11, 2000 11:02 AM Subject: Re: Newbie: Sessions Thanks all for the help! Now if you can help me with this. I turn on session manegment in my application.cfm file and set the ime out for 10 min. I have a person enter username and password. If correct I set the session.login to yes. Now if they don't use the site for longer then 10 min., what happenes. Do I need to do some kind of a check on the session.login and then send them to the login page or what? If so, would I do it in the application.cfm page I just quit drinking caffeine so my brain is a little fuzzy, large, swollen Thanks, Art Hello, Argument for using session variables: We have a company directory with free listings for members of the natural food products industry (very recently released). We will give out login and passwords to companies (upon approval of their company as verifiable) so that they can either change information (address, phone numbers etc) and also so that they may "Upgrade" their listing to incorporate a lot of tools (very similar to the Thomas Register). When a user logs in we cannot be sure they are doing so from their personal home/office computer and since we do not want to leave a variety of differently named cookies that would contain information about the company on machines in public kiosks we decided to manipulate this information using session variables that store database values and some temporary values that a user may change when logged in via a form.. We use the session variables because they maintain state throughout the 15 odd screens that a user may go through (depending on how much they upgrade) in order to pull info user specific data from a database and from forms which then allows the user to update their information. This system has worked well for us. If I had to maintain any other type of variables from page to page in my application I think this project would be a lot less portable (right now adding a component is really easy since it is very fuse box like and the session variables get set in one file which get included in all the pages of the application.' If you had asked me 6 months ago if I would ever use session variables I probably would have said "NO" but this was one place I have found them very useful. Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Custom CF_ Tags
Im just starting to read the books about Custom tags, and im wondering if the file in the C:\CFUSION\CustomTags folder has to contain the actual code of the tag? Or is the file there just to name the tag?? The file has to contain the code. You pass data into the tag using the Attribute scope and you return data using the caller scope. Example: sample.cfm -- html headtitle/title/head body cf_mytag attrib1="hello" attrib2="world" br cfoutput#mytag.success#/cfoutput /body /html mytag.cfm -- cfoutput#Attributes.attrib1# #Attributes.attrib2#/cfoutput caller.mytag.success=true Output: -- hello world true HTH, Duane Boudreau, eMPower Project Manager Director, Web Technologies Ektron, Inc. http://www.ektron.com 5 Northern Blvd, Suite 6 Amherst, NH 03031 Tel: 603-594-0249 x114 Fax: 603-594-0258 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Newbie Question - Creating Data Source for CSV text file
I have a customer that is a car dealership. They want to put their car inventory online. The company that makes their inventory database tells me that the data store is not ODBC compliant, but that they could output a CSV text file that they will auto-FTP to our servers in the middle of the night. Not exactly the most elegant solution, but it beats entering car data manually. :) Can I create an ODBC connection in the CF Administrator to use a CSV text file as a data source? I tried but I could not get it to verify the data source. You can use CSV files for ODBC datasource, but don't! The main reason is that ODBC holds onto sources like that once it's got them 2 Solutions; Open the CSV using CFFile - it's just a comma separated list per line Make a link table in Access which talks to the CSV - this is the much preferred solution as you can actually run SQL queries on the data This all assumes that the column list and names stay the same, and only the data itself changes Remember also that quotes screw up CSV files royally - so if they have any in their descriptions (as in 14" wheels) Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: From .exe to .dll
Its a little more complicated then that :-) You need to know how to handle input and ouput params etc... If you are using VisualC++ there is a template to get u started. (I think there is a KB article on how to install it if you haven't got it) Have your programmer look at the source code of some of the freeware cfx on intrafoundations site and you'll see the structure. ~J - Original Message - From: "Mark Armendariz" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 11, 2000 4:07 PM Subject: RE: From .exe to .dll I appreciate the quick reply... As for the cfx.h library. Would we just have to compile the code with an inclusion of cfx.h or is there any changes that would actually have to be made to the code itself? I'm waiting for Ben's advanced book in the mail.. hopefull to arrive on Monday. THANKS!! -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: Friday, August 11, 2000 10:39 AM To: [EMAIL PROTECTED] Subject: Re: From .exe to .dll If you have the source code I would recommend wrapping the code in a cfx_tag. It's very simple. For example of cfx source code in C/C++ Have a look at the excellent www.intrafoundation.com . There is also some info in Ben's advanced book and plenty of help(!?!!?) on this list :-) If all that fails you chould use cfexecute ( or CFX_consoleCommand @ intrafoundation.com ) to capture the input from the dos program.. ~Justin MacCarthy - Original Message - From: "Mark Armendariz" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 11, 2000 3:23 PM Subject: RE: From .exe to .dll YEs, we have the source code. It's actually a proprietary application made by our own programmers to generate a password for our software. I believe it's written in C. The functions of the program are fairly basic. It asks about 10 questions (INPUT), and gives one answer depending on the input (OUTPUT). Our programmers are very capable. I just need to know where to look so i can ask them for this knowledgeably and answer any questions they may have from the get go. Or at least know ehre to send them for the answers they need. I would imagine we just need a means of giving the dll input and then getting the output via a variable. Thanks.. -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: Friday, August 11, 2000 10:01 AM To: [EMAIL PROTECTED] Subject: Re: From .exe to .dll Have you got the source code ??? What language was it written in? What does it do? ~Justin - Original Message - From: "Mark Armendariz" [EMAIL PROTECTED] To: "Cf-Talk" [EMAIL PROTECTED] Sent: Friday, August 11, 2000 2:55 PM Subject: From .exe to .dll I am looking for resources regarding converting a dos based program into a dll that will run well from cold fusion. can anyone point me in the right direction? Thanks Mark Armendariz Righteous Desgin www.sorighteous.com [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the
RE: CF Query Problem with Session Variables
CFQUERY NAME="GetUsers" DATASOURCE="DSN" SELECT User_ID, FullName, Login FROM Users WHERE session.user_ID = #CurrentUser.User_ID# ORDER BY Login /CFQUERY But...is session.user_ID a table in your database. What you probably want is WHERE User_ID = #session.user_ID# Dana Larose Database Monkey Canadian Web Design Consulting Inc. A: 701-281 McDermot Avenue (McDermot King) P: 204-946-5155 C: 204-228-0477 F: 204-946-5156 E: [EMAIL PROTECTED] W: http://www.cdnwebdesign.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF Query Problem with Session Variables
And you could remove the excessive # signs too: cfset session.user_ID = CurrentUser.User_ID Try: cfset session.user_ID = #CurrentUser.User_ID# CFQUERY NAME="GetUsers" DATASOURCE="DSN" SELECT User_ID, FullName, Login FROM Users WHERE User_ID = #session.user_ID# ORDER BY Login /CFQUERY And you'll probably need single quotes around #session.User_ID# if it's a non-numeric field. Ricq Pattay [EMAIL PROTECTED] Univ of MN College of Veterinary Medicine - Original Message - From: Jeremy Toevs [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 11, 2000 10:08 AM Subject: CF Query Problem with Session Variables Hey CF People, I am storing the current users id in a session variable using the following: cfset session.user_ID = #CurrentUser.User_ID# Now I am trying to write a query that uses that. CFQUERY NAME="GetUsers" DATASOURCE="DSN" SELECT User_ID, FullName, Login FROM Users WHERE session.user_ID = #CurrentUser.User_ID# ORDER BY Login /CFQUERY Is it possible to use it, or am I just writing it wrong? Thanks in advance! Jeremy -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=stsbody=sts/cf_tal k or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Newbie Question - Creating Data Source for CSV text file
John; Just let your client download the info as requested and then import the csv file into a table after you get it. Then you can read it very easily. H Larry Juncker L Senior Cold Fusion Programmer I Heartland Communications Group Internet Division -Original Message- From: Ryan [mailto:[EMAIL PROTECTED]] Sent: Friday, August 11, 2000 10:08 AM To: [EMAIL PROTECTED] Subject: Re: Newbie Question - Creating Data Source for CSV text file I think you can treat a csv file as an ODBC datasource, you just need to have the driver for it. RPS -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Newbie Question - Creating Data Source for CSV text file
For SQL7, this works fine inside CF: BULK INSERT Victor FROM 'D:\FR\FileResource\VictorJPGs\CSVs\July212000\101-200.csv' WITH ( FIELDTERMINATOR=',', ROWTERMINATOR=' ' ) best, paul At 10:28 AM 8/11/00 -0400, you wrote: CF Gurus, I have a customer that is a car dealership. They want to put their car inventory online. The company that makes their inventory database tells me that the data store is not ODBC compliant, but that they could output a CSV text file that they will auto-FTP to our servers in the middle of the night. Not exactly the most elegant solution, but it beats entering car data manually. :) Can I create an ODBC connection in the CF Administrator to use a CSV text file as a data source? I tried but I could not get it to verify the data source. Any Tips or place I could go to for more info? John McKown, VP of Business Services Delaware.Net, Inc. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Query Delete?
The permissions are in the database and trying to do it at display time (I understand this as doing it while displaying it on the browser) may not be the best way to do it. Kedar Desai Differential Technologies Fairfax, VA --- "Olive, Christopher M Mr NMR" [EMAIL PROTECTED] wrote: why can't you handle that logic at display time? check to see to what the user has permissions, and display accordingly? Chris Olive, DOEHRS Website Administrator -Original Message- From: Planet CF [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 09, 2000 4:46 PM To: [EMAIL PROTECTED] Subject: RE: Query Delete? The need for a QueryDeleteColumn or QueryDeleteRow arises in situations where one wants to manipulate the query due to various reasons. One of them could something like applying security on the query. This means that the user does not priviledges to view all the rows/columns of the query (which is a join). In such a case you would want to delete data which is secure. One can say that incorporate that in the 'select' itself. However this cannot be done bcoz some users have override security priviledges, meaning that security does not apply for such users. The bottomline is that, if there is a QueryAddColumn then why not a QueryDeleteColumn and also QueryDeleteRow. Kedar Desai Differential Technologies Fairfax, VA -Original Message- From: David E. Crawford [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 08, 2000 10:39 AM To: [EMAIL PROTECTED] Subject: Re: Query Delete? This is a multi-part message in MIME format. --=_NextPart_000_0175_01C00146.6E5DE680 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Query Delete?You could relatively easily do it using the QueryNew() = function and looping over. But what would be the point? Just don't = selec the column in the first place. DC - Original Message -=20 From: Planet CF=20 To: [EMAIL PROTECTED]=20 Sent: Tuesday, August 08, 2000 14:34 Subject: Query Delete? Hi,=20 Is there a custom tag somewhere out there, that=20 deletes a column from a query?=20 Thanks=20 Kedar Desai=20 Differential Technologies=20 Fairfax, VA=20 __=20 Do You Yahoo!?=20 Kick off your party with Yahoo! Invites.=20 http://invites.yahoo.com/=20 = -= -=20 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/=20 To Unsubscribe visit = http://www.houseoffusion.com/index.cfm?sidebar=3Dlistsbody=3Dlists/cf_ta= lk or send a message to [EMAIL PROTECTED] with = 'unsubscribe' in the body. --=_NextPart_000_0175_01C00146.6E5DE680 Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEADTITLEQuery Delete?/TITLE META content=3D"text/html; charset=3Dwindows-1252" = 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=3D2You could relatively easily do it using = the=20 QueryNew() function and looping over. But what would be the point?nbsp; = Just=20 don't selec the column in the first place./FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2DC/FONT/DIV DIVnbsp;/DIV BLOCKQUOTE=20 style=3D"BORDER-LEFT: #00 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: = 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px" DIV style=3D"FONT: 10pt arial"- Original Message - /DIV DIV=20 style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = black"BFrom:/B=20 A href=3D"mailto:[EMAIL PROTECTED]" = [EMAIL PROTECTED]Planet CF/A=20 /DIV DIV style=3D"FONT: 10pt arial"BTo:/B A=20 href=3D"mailto:[EMAIL PROTECTED]"=20 [EMAIL PROTECTED][EMAIL PROTECTED]/A /DIV DIV style=3D"FONT: 10pt arial"BSent:/B Tuesday, August 08, 2000=20 14:34/DIV DIV style=3D"FONT: 10pt arial"BSubject:/B Query Delete?/DIV DIVBR/DIV PFONT size=3D2Hi,/FONT /P PFONT size=3D2Is there a custom tag somewhere out there, = that/FONT=20 BRFONT size=3D2deletes a column fromnbsp; a query?/FONT /P PFONT size=3D2Thanks/FONT BRFONT size=3D2Kedar Desai/FONT = BRFONT=20 size=3D2Differential Technologies/FONT BRFONT size=3D2Fairfax, = VA/FONT=20 /PBR PFONT = size=3D2__/FONT=20 BRFONT size=3D2Do You Yahoo!?/FONT BRFONT size=3D2Kick off = your party=20 with Yahoo! Invites./FONT BRFONT size=3D2A=20 href=3D"http://invites.yahoo.com/"=20 target=3D_blankhttp://invites.yahoo.com//A/FONT BRFONT=20 = size=3D2= --/FONT=20 BRFONT size=3D2Archives: A=20
Re: Newbie Question - Creating Data Source for CSV text file
I've done it. It's tricky, but I had to go into the NTServer control panel and define a DSN there. Once that was done, the CF Administrator could see it and configure it for ColdFusion. (We have a partner site FTP 6 csv files into our server every night so we always have up todate information on our own site.) After that it worked just like any other ODBC database. Not sure about it's speed though, compared to SQLServer7 because it wasn't an application that was subject to high traffic. Perhaps someone else can advise whether it would be faster or slower than the grown-up database? Mike Kear [EMAIL PROTECTED] www.afp.zip.com.au Windsor, NSW, Australia AFP Web Development AFP Electronic Forms AFP Models At 10:28 AM 11-08-00 -0400, you wrote: CF Gurus, I have a customer that is a car dealership. They want to put their car inventory online. The company that makes their inventory database tells me that the data store is not ODBC compliant, but that they could output a CSV text file that they will auto-FTP to our servers in the middle of the night. Not exactly the most elegant solution, but it beats entering car data manually. :) Can I create an ODBC connection in the CF Administrator to use a CSV text file as a data source? I tried but I could not get it to verify the data source. Any Tips or place I could go to for more info? John McKown, VP of Business Services Delaware.Net, Inc. --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
More elegant way of passing URL variables?
Hi, I am dynamically generating a list of customers, on which a user can click to go to a detailed page. To do this, I am putting the customerID into a URL variable in the A HREF path. But the client doesn't want to see the value in the address bar, as they consider it a security risk. What would be a better solution? A hidden FORM field for each item, and have the HREF call Javascript which posts the form? The problem with that us I will get all of the form fields in the detail page, unless the JS passes a value to indicate the field I want, but hen I essentially have the same problem Any input appreciated. James -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: [OT] REQ testimonials from SAG Electronics customers.
Yes, I forgot this in my earlier post. Same here. And they sent a tech to install the new HD (many of their systems come with on-site service). best, paul At 10:45 AM 8/11/00 -0400, you wrote: support (at least I don't think they do?). I only had to call support one time, 30 second hold time and I had the new hard drive in my hands by 9AM the next day. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Newbie Question - Creating Data Source for CSV text file
If your server is NT you can create an ODBC connection using the Microsoft Text Driver (txt and csv). I've experimented with it just a bit and it seems to work on very simple things. I would think that you'd want to weigh how many steps you want to take manipulating and moving data. If the csv driver works consistently, it might make things simpler. On the other hand, if the data is in a database, you have a lot more flexibility. If you don't need that flexibility, having fewer places where a breakdown could occur might be preferable. I know that we have a few processes where we extract information from an Informix database on Unix, have that data FTP'd to an NT Server, then another process runs on the NT server to import the data. Should be fine in a perfect world. But I don't live there! So occasionally some part of that process doesn't automatically run and the update doesn't happen. We're working on getting to the point where the NT application can be updated directly from the Informix database. Less places to break. Another consideration might be the long term plan for the current system. If it's not ODBC, will it be down the road? I would think that the vendor of the product would be moving in that direction. If so, a simple solution might be fine. In that case I'd give the ODBC data source a try. By the way, I usually just create my ODBC data sources right from the control panel. So I'm not sure if you get all of those same options using the CF Administrator. But if you don't, you should be able to just create it from ODBC32 under the Control Panel. Athelene -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Friday, August 11, 2000 10:23 AM To: [EMAIL PROTECTED] Subject: RE: Newbie Question - Creating Data Source for CSV text file I have a customer that is a car dealership. They want to put their car inventory online. The company that makes their inventory database tells me that the data store is not ODBC compliant, but that they could output a CSV text file that they will auto-FTP to our servers in the middle of the night. Not exactly the most elegant solution, but it beats entering car data manually. :) Can I create an ODBC connection in the CF Administrator to use a CSV text file as a data source? I tried but I could not get it to verify the data source. You can use CSV files for ODBC datasource, but don't! The main reason is that ODBC holds onto sources like that once it's got them 2 Solutions; Open the CSV using CFFile - it's just a comma separated list per line Make a link table in Access which talks to the CSV - this is the much preferred solution as you can actually run SQL queries on the data This all assumes that the column list and names stay the same, and only the data itself changes Remember also that quotes screw up CSV files royally - so if they have any in their descriptions (as in 14" wheels) Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Newbie Question - Creating Data Source for CSV text file
From: "Philip Arnold - ASP" [EMAIL PROTECTED] You can use CSV files for ODBC datasource, but don't! The main reason is that ODBC holds onto sources like that once it's got them Make a link table in Access which talks to the CSV - this is the much preferred solution as you can actually run SQL queries on the data I'd be interested in hearing a few more details on this... and info about the advantages of this over using CFHTTP to create a query object and then looping over the query to insert each record into a db... Gene Kraybill -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Newbie Question - Creating Data Source for CSV text file
Thanks for all of the feedback. Keep it coming... Right now I am learning to use CFHTTP... Couldn't I just use that to take their CSV and insert it into a table? Or am I going to have issues when they have strings that contain quotes? Thanks in advance... John McKown, VP of Business Services Delaware.Net, Inc. -Original Message- From: paul smith [mailto:[EMAIL PROTECTED]] Sent: Friday, August 11, 2000 11:47 AM To: [EMAIL PROTECTED] Cc: John McKown Subject: Re: Newbie Question - Creating Data Source for CSV text file For SQL7, this works fine inside CF: BULK INSERT Victor FROM 'D:\FR\FileResource\VictorJPGs\CSVs\July212000\101-200.csv' WITH ( FIELDTERMINATOR=',', ROWTERMINATOR=' ' ) best, paul At 10:28 AM 8/11/00 -0400, you wrote: CF Gurus, I have a customer that is a car dealership. They want to put their car inventory online. The company that makes their inventory database tells me that the data store is not ODBC compliant, but that they could output a CSV text file that they will auto-FTP to our servers in the middle of the night. Not exactly the most elegant solution, but it beats entering car data manually. :) Can I create an ODBC connection in the CF Administrator to use a CSV text file as a data source? I tried but I could not get it to verify the data source. Any Tips or place I could go to for more info? John McKown, VP of Business Services Delaware.Net, Inc. - - Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/c f_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Newbie Question - Creating Data Source for CSV text file
In my app at http://bradford.support.net/ I had my client export their jobs database to CSV using a pipe (|) as a field delimiter to get around the quotes problem. They also upload their CSV using HTTP. best, paul At 04:22 PM 8/11/00 +0100, you wrote: Remember also that quotes screw up CSV files royally - so if they have any in their descriptions (as in 14" wheels) -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Newbie Question - Creating Data Source for CSV text file
parse into a database once received? From: "John McKown" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: "CF_Talk" [EMAIL PROTECTED] Subject: Newbie Question - Creating Data Source for CSV text file Date: Fri, 11 Aug 2000 10:28:04 -0400 CF Gurus, I have a customer that is a car dealership. They want to put their car inventory online. The company that makes their inventory database tells me that the data store is not ODBC compliant, but that they could output a CSV text file that they will auto-FTP to our servers in the middle of the night. Not exactly the most elegant solution, but it beats entering car data manually. :) Can I create an ODBC connection in the CF Administrator to use a CSV text file as a data source? I tried but I could not get it to verify the data source. Any Tips or place I could go to for more info? John McKown, VP of Business Services Delaware.Net, Inc. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Error Diagnostic Information
This is a multi-part message in MIME format. --=_NextPart_000_0046_01C0038B.89E6DDC0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Can somebody help me? This problem occures sporadically. It seem to happens when there's a few user using the system. Sometime, a refesh will execute the template successfully. When a single user use it, it works just find. We use Cold Fusion Server 4 Pro on NT 4 with SP5. The web server is IIS. Openlink v3.0 is also being used as an ODBC driver to our Informix SE 7 Database. Here's the error : Error Diagnostic Information unknown exception condition PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (3:1) to (3:53). Date/Time: 08/11/00 09:53:14 Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt) Remote Address: 172.16.220.101 HTTP Referer: http://devserver.wbn.ca/transac/SearchEmp.cfm Template: G:\cfpages\transac\ExecuteSearchEmp.cfm Claude --=_NextPart_000_0046_01C0038B.89E6DDC0 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.2314.1000" name=3DGENERATOR/HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2Can somebody help me?nbsp; = /FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2This problem occures = sporadically.nbsp; It seem to=20 happens when there's a few user using the system.nbsp; Sometime, a = refesh will=20 execute the template successfully.nbsp; When a single user use it, it = works=20 just find./FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2We use Cold Fusion Server 4 Pro on NT 4 = with=20 SP5.nbsp; The web server is IIS./FONT/DIV DIVFONT face=3DArial size=3D2SPAN = class=3D91125015-11082000Openlink v3.0 is also=20 being used as an ODBC driver to our Informix SE 7 = Database./SPAN/FONT/DIV DIVFONT face=3DArial size=3D2SPAN=20 class=3D91125015-11082000/SPAN/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2Here's the error :/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Error Diagnostic InformationBRunknown = exception=20 condition/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial=20 size=3D2PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag/FONT/DIV= DIVnbsp;/DIV DIVFONT face=3DArial size=3D2The error occurred while processing an = element with=20 a general identifier of (CFQUERY), occupying document position (3:1) to=20 (3:53)./FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2BRDate/Time: 08/11/00 = 09:53:14BRBrowser:=20 Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)BRRemote = Address:=20 172.16.220.101BRHTTP Referer: A=20 href=3D"http://devserver.wbn.ca/transac/SearchEmp.cfm"http://devserver.w= bn.ca/transac/SearchEmp.cfm/ABRTemplate:=20 G:\cfpages\transac\ExecuteSearchEmp.cfm/FONT/DIV DIVnbsp;/DIV DIVFONT color=3D#00 face=3DArial size=3D2Claude = /FONT/DIV/BODY/HTML --=_NextPart_000_0046_01C0038B.89E6DDC0-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Newbie: Sessions
What I do is put all pages that need to be password protected into their own folder. Then I toss an application.cfm into that folder that looks something like this: !--- --- cfinclude template="../application.cfm" cfif not isdefined('Session.login') or Session.login is not "yes" cflocation url="../login.cfm" /cfif !--- --- This application.cfm includes all of the attributes of the root application.cfm, but also checks for your session variable and redirects if it is expired, not created, etc. Todd Ashworth - Original Message - From: "Art Broussard" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 11, 2000 11:02 AM Subject: Re: Newbie: Sessions | Thanks all for the help! | | Now if you can help me with this. I turn on session manegment in my | application.cfm file and set the ime out for 10 min. I have a person enter | username and password. If correct I set the session.login to yes. Now if | they don't use the site for longer then 10 min., what happenes. Do I need to | do some kind of a check on the session.login and then send them to the login | page or what? If so, would I do it in the application.cfm page | | I just quit drinking caffeine so my brain is a little fuzzy, large, swollen -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Error Handling
[EMAIL PROTECTED] wrote: I looked a bit into that , but I waant a message only for that error, and it doesn't seem like I can tell CFTRY to only catch the cfsearch error. Please tell me if I am wrong. I've just started using CFTRY myself, but check out CFTHROW. It's my understanding you can use it along with some conditional code to "throw" any customized error message for any error condition at all...Your customized error will then be "caught" by CFCATCH at the bottom of the CFTRY block. Gene Kraybill -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Flushing cached queries
Hey everyone, If you are caching queries, is there a way to force CF to flush them? When an administrator updates a table, I would like CF to dump any cached queries using that table, so that users aren't viewing old data. Dana Larose Web Developer Canadian Web Design Consulting Inc. A: 701-281 McDermot Avenue (McDermot King) P: 204-946-5155 C: 204-228-0477 F: 204-946-5156 E: [EMAIL PROTECTED] W: http://www.cdnwebdesign.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF Query Problem with Session Variables
P.S. Jeremy, don't forget to cflock those session variables ;) Todd Ashworth - Original Message - From: "Ricq Pattay" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 11, 2000 11:24 AM Subject: Re: CF Query Problem with Session Variables | Try: | | cfset session.user_ID = #CurrentUser.User_ID# | | CFQUERY NAME="GetUsers" DATASOURCE="DSN" | SELECT User_ID, FullName, Login | FROM Users | WHERE User_ID = #session.user_ID# | ORDER BY Login | /CFQUERY | | And you'll probably need single quotes around #session.User_ID# if it's a | non-numeric field. | | | Ricq Pattay [EMAIL PROTECTED] | Univ of MN College of Veterinary Medicine | | | | - Original Message - | From: Jeremy Toevs [EMAIL PROTECTED] | To: [EMAIL PROTECTED] | Sent: Friday, August 11, 2000 10:08 AM | Subject: CF Query Problem with Session Variables | | | Hey CF People, | | I am storing the current users id in a session variable using the following: | | cfset session.user_ID = #CurrentUser.User_ID# | | Now I am trying to write a query that uses that. | | CFQUERY NAME="GetUsers" DATASOURCE="DSN" | SELECT User_ID, FullName, Login | FROM Users | WHERE session.user_ID = #CurrentUser.User_ID# | ORDER BY Login | /CFQUERY | | Is it possible to use it, or am I just writing it wrong? | | Thanks in advance! | | Jeremy -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CSv
what is a csv file? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Error Handling
David's right, just use CFCATCH.Detail in a CFIF statement and you can catch the detail down to the very fine point. Lemme know if ya need anything else. Gregory Harris Los Angeles Information Technology Agency (ITA) [EMAIL PROTECTED] [EMAIL PROTECTED] 08/11 7:21 AM Miriam, If you put only the CFSEARCH code in the CFTRY block, only errors from that code will activate the error handler. If you need even finer resolution than that, you could check the actual error message (CFCATCH.Details, I think). -David On Fri, 11 Aug 2000 09:20:59 -0400 "Miriam Hirschman" [EMAIL PROTECTED] writes: I looked a bit into that , but I waant a message only for that error, and it doesn't seem like I can tell CFTRY to only catch the cfsearch error. Please tell me if I am wrong. -Original Message- From: Gregory Harris [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 09, 2000 12:59 PM To: [EMAIL PROTECTED] Subject: Re: Error Handling Hello Miriam. While I'm not too familiar with the CFSearch tag, I would imagine that the CFTRY/CFCATCH could pick up any such error and then you have control over how you'd handle it. Look up the CFTRY/CFCATCH statements, use those and tell me how it works out. Gregory Harris YOU'RE PAYING TOO MUCH FOR THE INTERNET! Juno now offers FREE Internet Access! Try it today - there's no risk! For your FREE software, visit: http://dl.www.juno.com/get/tagj. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: More elegant way of passing URL variables?
Encrypt the url I wrote a couple of tags that encrypt/ decrypt query_strings so instead of index.cfm?value=6name=jim You get page2.cfm?94946560A4946560B495214551E01031C1D1A. and on page2 you include cf_DeCryptURL and you can still use url.value and url.name etc I don't have it handy at the moment though and it chould do with more testing but I'll end it to you over the weekend if you want ... ~ Justin - Original Message - From: "Milks, Jim" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 11, 2000 4:49 PM Subject: More elegant way of passing URL variables? Hi, I am dynamically generating a list of customers, on which a user can click to go to a detailed page. To do this, I am putting the customerID into a URL variable in the A HREF path. But the client doesn't want to see the value in the address bar, as they consider it a security risk. What would be a better solution? A hidden FORM field for each item, and have the HREF call Javascript which posts the form? The problem with that us I will get all of the form fields in the detail page, unless the JS passes a value to indicate the field I want, but hen I essentially have the same problem Any input appreciated. James -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: More elegant way of passing URL variables?
I'm assuming that you're having some type of summary list to select from that takes you to the details page (or something like that)... I've had the same issue, I have done some weird things to keep this all in a single form and evaluate the numerous form fields passed to come up with the one id that actually was selected. Another way that is a little simpler, is to create a form for each of the rows in your summary list... you would just have the complete form information with the hidden form field assigned the userid in each form. that would make for a lot of forms potentially (I've limited my display to 10 records with a next/previous setup) - a heavier document, but it works. just an idea... later - je -Original Message- From: Milks, Jim [mailto:[EMAIL PROTECTED]] Sent: Friday, August 11, 2000 9:50 AM To: '[EMAIL PROTECTED]' Subject: More elegant way of passing URL variables? Hi, I am dynamically generating a list of customers, on which a user can click to go to a detailed page. To do this, I am putting the customerID into a URL variable in the A HREF path. But the client doesn't want to see the value in the address bar, as they consider it a security risk. What would be a better solution? A hidden FORM field for each item, and have the HREF call Javascript which posts the form? The problem with that us I will get all of the form fields in the detail page, unless the JS passes a value to indicate the field I want, but hen I essentially have the same problem Any input appreciated. James -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Problem carrying over form values.
Thanks! That works perfectly! Cody - Original Message - From: "Philip Arnold - ASP" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 11, 2000 4:02 AM Subject: RE: Problem carrying over form values. You can try replacing the " with some string you know the person will not enter, like §, or some other character entity. Then you can get that data from the hidden form field and convert it back before entering it into the database. There's a neater solution that this one - rather than having to re-convert it back later... input type="hidden" name="comments" value="#Replace(form.Comments,,"quot;","All")#" You can use this for all form types, and the HTML is converted when the form passes it along Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Newbie Question - CSV text file + IE4/5 fun
If you use the pips , ensure that you change your ODBC driver settings, a comma is default. BTW if you looking to play around, check out the IE Databinding stuff with CSV file. 6 Lines of code and you can output the file sort it by columns and allsorts of cool stuff. Handy for a quick csv viewing and backend stuff .IE only though... ~Justin - Original Message - From: "paul smith" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 11, 2000 4:55 PM Subject: RE: Newbie Question - Creating Data Source for CSV text file In my app at http://bradford.support.net/ I had my client export their jobs database to CSV using a pipe (|) as a field delimiter to get around the quotes problem. They also upload their CSV using HTTP. best, paul At 04:22 PM 8/11/00 +0100, you wrote: Remember also that quotes screw up CSV files royally - so if they have any in their descriptions (as in 14" wheels) -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Newbie: Sessions
Art, Keep in mind how session variables work. The variables are stored in the web server's memory and the timeout period tells the server to clear them if there is no activity for THAT session for the specified time. The obvious question here is: "If the web is stateless how can the server know which session is which?" Like anything on the web that needs to maintain state, you need to tell the server which session you are. That is done with either a cookie, set by the cold fusion server, or a URL token sent with each URL request. The CF server sends two ID numbers, CFID and CFTOKEN, as a cookie to your browser when Session or Client management is enabled. Then on each subsequent request, CF reads those variables (CFID and CFTOKEN) and knows which session and which memory (session) variables they are associated with. Keep in mind that if you have cookies turned off in your browser, the server will not know which session you are and will re-assign a new session on each request. You will then lose your session variables between requests. To overcome that situation you can TELL CF which session you are by including the CFID CFTOKEN variables on the URL line. Like so: http://www.domain.com?CFID=#CFIDCFTOKEN=#CFTOKEN#. CF also supports a shortcut variable for those commands: "Session.URLToken" You can append it to each URL like so: http://www.domain.com?#session.URLToken# and CF will expand the variable for you and know which session your are. If you can dictate that your users MUST have cookies enabled then there is no need to pass the URLToken on each URL request, but if you are designing for the public at large, I would recommend passing the URLTOKEN on each URL to be safe. Best Regards, Dennis Powers UXB Internet (203)879-2844 http://www.uxbinfo.com -Original Message- From: Art Broussard [mailto:[EMAIL PROTECTED]] Sent: Friday, August 11, 2000 11:02 AM To: [EMAIL PROTECTED] Subject: Re: Newbie: Sessions Thanks all for the help! Now if you can help me with this. I turn on session manegment in my application.cfm file and set the ime out for 10 min. I have a person enter username and password. If correct I set the session.login to yes. Now if they don't use the site for longer then 10 min., what happenes. Do I need to do some kind of a check on the session.login and then send them to the login page or what? If so, would I do it in the application.cfm page I just quit drinking caffeine so my brain is a little fuzzy, large, swollen Thanks, Art Hello, Argument for using session variables: We have a company directory with free listings for members of the natural food products industry (very recently released). We will give out login and passwords to companies (upon approval of their company as verifiable) so that they can either change information (address, phone numbers etc) and also so that they may "Upgrade" their listing to incorporate a lot of tools (very similar to the Thomas Register). When a user logs in we cannot be sure they are doing so from their personal home/office computer and since we do not want to leave a variety of differently named cookies that would contain information about the company on machines in public kiosks we decided to manipulate this information using session variables that store database values and some temporary values that a user may change when logged in via a form.. We use the session variables because they maintain state throughout the 15 odd screens that a user may go through (depending on how much they upgrade) in order to pull info user specific data from a database and from forms which then allows the user to update their information. This system has worked well for us. If I had to maintain any other type of variables from page to page in my application I think this project would be a lot less portable (right now adding a component is really easy since it is very fuse box like and the session variables get set in one file which get included in all the pages of the application.' If you had asked me 6 months ago if I would ever use session variables I probably would have said "NO" but this was one place I have found them very useful. __ __ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_tal k or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: From .exe to .dll
The wizard and header file can be found here with directions of where to place them on your hard drive with VC++ 6. It requires that CF server is installed on the same box but might be hackable if you manually add the reg keys noted in the instructions. http://members.home.com/hoffmanj/cf/cfx_files.zip Joe Hoffman mailto:[EMAIL PROTECTED] National Institutes of Health Center for Information Technology Division of Computer System Services -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: Friday, August 11, 2000 11:22 AM To: [EMAIL PROTECTED] Subject: Re: From .exe to .dll Its a little more complicated then that :-) You need to know how to handle input and ouput params etc... If you are using VisualC++ there is a template to get u started. (I think there is a KB article on how to install it if you haven't got it) Have your programmer look at the source code of some of the freeware cfx on intrafoundations site and you'll see the structure. ~J - Original Message - From: "Mark Armendariz" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 11, 2000 4:07 PM Subject: RE: From .exe to .dll I appreciate the quick reply... As for the cfx.h library. Would we just have to compile the code with an inclusion of cfx.h or is there any changes that would actually have to be made to the code itself? I'm waiting for Ben's advanced book in the mail.. hopefull to arrive on Monday. THANKS!! -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: Friday, August 11, 2000 10:39 AM To: [EMAIL PROTECTED] Subject: Re: From .exe to .dll If you have the source code I would recommend wrapping the code in a cfx_tag. It's very simple. For example of cfx source code in C/C++ Have a look at the excellent www.intrafoundation.com . There is also some info in Ben's advanced book and plenty of help(!?!!?) on this list :-) If all that fails you chould use cfexecute ( or CFX_consoleCommand @ intrafoundation.com ) to capture the input from the dos program.. ~Justin MacCarthy - Original Message - From: "Mark Armendariz" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 11, 2000 3:23 PM Subject: RE: From .exe to .dll YEs, we have the source code. It's actually a proprietary application made by our own programmers to generate a password for our software. I believe it's written in C. The functions of the program are fairly basic. It asks about 10 questions (INPUT), and gives one answer depending on the input (OUTPUT). Our programmers are very capable. I just need to know where to look so i can ask them for this knowledgeably and answer any questions they may have from the get go. Or at least know ehre to send them for the answers they need. I would imagine we just need a means of giving the dll input and then getting the output via a variable. Thanks.. -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: Friday, August 11, 2000 10:01 AM To: [EMAIL PROTECTED] Subject: Re: From .exe to .dll Have you got the source code ??? What language was it written in? What does it do? ~Justin - Original Message - From: "Mark Armendariz" [EMAIL PROTECTED] To: "Cf-Talk" [EMAIL PROTECTED] Sent: Friday, August 11, 2000 2:55 PM Subject: From .exe to .dll I am looking for resources regarding converting a dos based program into a dll that will run well from cold fusion. can anyone point me in the right direction? Thanks Mark Armendariz Righteous Desgin www.sorighteous.com [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFTHROW
How Do I define my own error in a cfthrow? I would like to say if the error is an invalid search criteria then Thanks, ---miriam -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Database problems
Can we see some code? You may be nesting your tags incorrectly. --K -Original Message- From: John Allred [mailto:[EMAIL PROTECTED]] Sent: Friday, August 11, 2000 5:00 AM To: CF-Talk Subject: Database problems I have a strange problem with inserts in an Access table. I can't seem to wrap either a CFINSERT or an SQL insert within a CFTRANSACTION. Either method, without a CFTRANSACTION, will successfully insert a record in my table. But as soon as I try to use CFTRANSACTION, so I can get the ID of the record just inserted and CFLOCATION to the entry form, all I do is increment the database ID, but don't insert any data. Can anyone hazard a guess what's causing this? I've read everything I can get my hands on, and I can't seem to figure it out. Thanks, --John -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.