Re: CFMX Hosting Providers
Looking to change shared hostswho do you recommend and why? Any one using a reseller package they are happy with? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFFILE and NFS
Having issues uploading or moving files using the CFFILE tag. Works great on a local directory, but when trying to write to an NFS mount, it will work fine sometimes, work slow others, or completly die later. Permissions are fine. Have tried uploading to a local and then moving to NFS. It uploads great, but hangs on the move. It will create the file in the NFS directory at zero bytes, then hang there for 10 minutes before it completes. trying small files -- under 10k. Any Ideas/work arounds? Jeff Britts Senior Software Engineer 781-372-1979 [EMAIL PROTECTED] __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFFILE and NFS
Zactly...Unix box Wont work with a direct post to the NFS directory. Posts to a local directory fine, but then hangs when moving it to the NFS share. -Original Message- From: Jesse Noller [mailto:[EMAIL PROTECTED]] Sent: Friday, August 16, 2002 10:32 AM To: CF-Talk Subject: RE: CFFILE and NFS Hmm, CFFILE on a Unix/Linux box posting to an NFS share? Jesse Noller [EMAIL PROTECTED] Macromedia Server Development Unix/Linux special guy -Original Message- From: Jeff Britts [mailto:[EMAIL PROTECTED]] Sent: Friday, August 16, 2002 10:27 AM To: CF-Talk Subject: CFFILE and NFS Having issues uploading or moving files using the CFFILE tag. Works great on a local directory, but when trying to write to an NFS mount, it will work fine sometimes, work slow others, or completly die later. Permissions are fine. Have tried uploading to a local and then moving to NFS. It uploads great, but hangs on the move. It will create the file in the NFS directory at zero bytes, then hang there for 10 minutes before it completes. trying small files -- under 10k. Any Ideas/work arounds? Jeff Britts Senior Software Engineer 781-372-1979 [EMAIL PROTECTED] __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFFILE and NFS
(from my IT guys)Same subnet. Mounted via dns. CF 4.5xyes I know ;) -Original Message- From: Jesse Noller [mailto:[EMAIL PROTECTED]] Sent: Friday, August 16, 2002 10:53 AM To: CF-Talk Subject: RE: CFFILE and NFS You running NFS through a firewall, or trying to do NFS mounts via DNS instead of IP/Etc? CFMX or CF5? Jesse Noller [EMAIL PROTECTED] Macromedia Server Development Unix/Linux special guy -Original Message- From: Jeff Britts [mailto:[EMAIL PROTECTED]] Sent: Friday, August 16, 2002 10:49 AM To: CF-Talk Subject: RE: CFFILE and NFS Zactly...Unix box Wont work with a direct post to the NFS directory. Posts to a local directory fine, but then hangs when moving it to the NFS share. -Original Message- From: Jesse Noller [mailto:[EMAIL PROTECTED]] Sent: Friday, August 16, 2002 10:32 AM To: CF-Talk Subject: RE: CFFILE and NFS Hmm, CFFILE on a Unix/Linux box posting to an NFS share? Jesse Noller [EMAIL PROTECTED] Macromedia Server Development Unix/Linux special guy -Original Message- From: Jeff Britts [mailto:[EMAIL PROTECTED]] Sent: Friday, August 16, 2002 10:27 AM To: CF-Talk Subject: CFFILE and NFS Having issues uploading or moving files using the CFFILE tag. Works great on a local directory, but when trying to write to an NFS mount, it will work fine sometimes, work slow others, or completly die later. Permissions are fine. Have tried uploading to a local and then moving to NFS. It uploads great, but hangs on the move. It will create the file in the NFS directory at zero bytes, then hang there for 10 minutes before it completes. trying small files -- under 10k. Any Ideas/work arounds? Jeff Britts Senior Software Engineer 781-372-1979 [EMAIL PROTECTED] __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFFILE and NFS
sp2. Tried it via IP and it was actually worse. Before at least some would process quickly, now they all hang. Acutally did get an error this time: Error processing CFFILE Error attempting to save uploaded file to path '/webcontent/graphics/cbimages/demo/ereports_off.gif.' Deadlock situation detected/avoided -Original Message- From: Jesse Noller [mailto:[EMAIL PROTECTED]] Sent: Friday, August 16, 2002 11:01 AM To: CF-Talk Subject: RE: CFFILE and NFS 4.5... Sp2? Try changing it to IP rather than DNS Jesse Noller [EMAIL PROTECTED] Macromedia Server Development Unix/Linux special guy -Original Message- From: Jeff Britts [mailto:[EMAIL PROTECTED]] Sent: Friday, August 16, 2002 10:58 AM To: CF-Talk Subject: RE: CFFILE and NFS (from my IT guys)Same subnet. Mounted via dns. CF 4.5xyes I know ;) -Original Message- From: Jesse Noller [mailto:[EMAIL PROTECTED]] Sent: Friday, August 16, 2002 10:53 AM To: CF-Talk Subject: RE: CFFILE and NFS You running NFS through a firewall, or trying to do NFS mounts via DNS instead of IP/Etc? CFMX or CF5? Jesse Noller [EMAIL PROTECTED] Macromedia Server Development Unix/Linux special guy -Original Message- From: Jeff Britts [mailto:[EMAIL PROTECTED]] Sent: Friday, August 16, 2002 10:49 AM To: CF-Talk Subject: RE: CFFILE and NFS Zactly...Unix box Wont work with a direct post to the NFS directory. Posts to a local directory fine, but then hangs when moving it to the NFS share. -Original Message- From: Jesse Noller [mailto:[EMAIL PROTECTED]] Sent: Friday, August 16, 2002 10:32 AM To: CF-Talk Subject: RE: CFFILE and NFS Hmm, CFFILE on a Unix/Linux box posting to an NFS share? Jesse Noller [EMAIL PROTECTED] Macromedia Server Development Unix/Linux special guy -Original Message- From: Jeff Britts [mailto:[EMAIL PROTECTED]] Sent: Friday, August 16, 2002 10:27 AM To: CF-Talk Subject: CFFILE and NFS Having issues uploading or moving files using the CFFILE tag. Works great on a local directory, but when trying to write to an NFS mount, it will work fine sometimes, work slow others, or completly die later. Permissions are fine. Have tried uploading to a local and then moving to NFS. It uploads great, but hangs on the move. It will create the file in the NFS directory at zero bytes, then hang there for 10 minutes before it completes. trying small files -- under 10k. Any Ideas/work arounds? Jeff Britts Senior Software Engineer 781-372-1979 [EMAIL PROTECTED] __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
WDDX parsing error on MX
The setup...CFMX, Oracle 8, Solaris. The problem...retrieving WDDX packets created in CF 4.5 Code is attached. It takes a CF structure, CFML2WDDX packets it, inserts it into a CLOB column, retrieves it and WDDX2CFMLs it. If I run this on CFMX its fine. But, if I create the WDDX on CF 4.5 and then attempt to retrieve it on MX I get the following error: WDDX packet parse error at line 1, column -1. Illegal XML character: #x0;.. It will work on a varchar2 column type, but not on long or Clob. Is this a bug? Code is below for your reference cfwddx action=CFML2WDDX input=#prefs# output=dbprefs cfquery datasource=blah name=get_seq select temp.seq_temo.nextval as id from dual /cfquery cfquery datasource=blah name=insert insert into temp.t_clob (clob_id,clob_data) values (#get_seq.id#, cfqueryparam cfsqltype=CF_SQL_CLOB value=#dbprefs#) /cfquery cfquery datasource=blah name=get select clob_data from temp.t_clob where clob_id = #get_seq.id# /cfquery cfwddx action=WDDX2CFML input=#get.clob_data# output=foo Jeff Britts Senior Software Engineer 781-372-1979 [EMAIL PROTECTED] __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF mail client
Anyone know of a freeware CF based mail client (before I go ahead and write it myself) __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: WDDX
Done up to 70k with no issues -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 12:34 PM To: CF-Talk Subject: WDDX Is there any limit to the length that a string can be inside a wddx packet? TIA, ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Question about retrieving Oracle CLOBs into a CF variable
We had the same issue with getting gibberish. What we found was that if you insert a record into a table with a clob, you need to set the value of the clob on insert, even if its an empty string. If you insert a record without including a value for the clob, your select against that row will seem to draw data from the fourth dimension. We're using clobs with native drivers all the time. -Original Message- From: Rosa, Issac [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 10:16 AM To: CF-Talk Subject: RE: Question about retrieving Oracle CLOBs into a CF variable You should be able to just do select clob_column from table [where]. We had a problems using clob and retrieving erroneous data or gibberish. Not sure if it was related to Native drivers or what the issue was exactly. So we changed to Long datatype and everything works great. Good luck. LOL Issac Rosa IT - National Sales Marketing Web Developer Ofc: 407-658-3111 Cell: 407-342-0644 Fax: 407-971-2374 [EMAIL PROTECTED] -Original Message- From: Tim Dempsey [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 11:02 PM To: CF-Talk Subject: Question about retrieving Oracle CLOBs into a CF variable Folks, In one CF template I insert a very long string (e.g. 1 bytes) into a CLOB column of a new row in an Oracle table. (Actually the CLOB is the string resulting from a CFWDDX tage that converts a CF structure of structures to a string.). I do this insert by using the CFQUERYPARAM tag to force CF to generate a bind variable like Oracle wants for CLOBs. Now, in another CF template I need to retrieve it. My question is, how Can I simply say select clob_column from table wherecondition is true? Can I then refer to QueryName.clob_column and get the whole humoungous string? Or do I need to force CF to use bind variables again? If so how do I do that in a select statement? Can I say select clob_column into cfqueryparam value=#local_cf_variable# from table where condition is true Does that work? Can anyone advise? I will be most appreciative of any help. Thanks, -- Tim Dempsey ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFSTOREDPROC and Oracle CLOBS
Trying to get a stored proc on to run that will retrieve a CLOB. Oracle 8, CF 4.5.1 service pack 2. CLOBS work with insert, update, select but when I try to call a stored procedure using this param cfprocparam type = Out cfsqltype = CF_SQL_CLOB variable = copy dbvarname = o_copy I throws the non helpful -- The error occurred while processing an element with a general identifier of (CFPROCPARAM) Tried changing it to LONGVARCHAR and I get an Oracle error wrong number or types of arguments blah blah. Any suggestions? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help: I need to insert long strings into an Oracle table
change your column type to CLOB -Original Message- From: Tim Dempsey [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 14, 2001 11:45 AM To: CF-Talk Subject: Help: I need to insert long strings into an Oracle table Hi, all. I am working on a CF application that administers a survey to its clients. The surveys span a number of web pages. On each page there are 2 buttons: 1 for the user to save the page's answers and continue to the next, and 1 to save the current session and exit. Each page presented to the user is described in a CF structure and there is a CF array of those structures to represent the current survey session. This approach was originally taken to be able to keep track of things if the user pressed the browser's Back button. Now I want to save that array of pages as part of implementing the Save Session and Exit button. I convert it to a CF string using the CFWDDX tag and then save the string in an Oracle table along with identifying info so it can be retrieved to resume the session. The problem is that the variable will exceed Oracle's limit of 4000 characters for a literal string variable. Is there a way for my to insert my arbitrarily long string into my Oracle table from CF? Oracle's error message suggest to use bind variables. Can they be used in CF? Has anyone every tried to insert very long strings into Oracle? Please help... Thanks, -- Tim Dempsey ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Win IE5 vs Mac IE5
Can anyone point me to a resource that lists the differences between IE5 for Mac and PC. I've got a site that works fine on IE5 for Windows, but will lock the computer up tight using IE5 on Mac. It's probably some JavaScript thing, but I'd like to know what I'm looking for. TIA ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Updating multiple rows!
Shouldn't it be WHERE Part_ID = 751 OR PART_ID = 752 (Im assuming that each part can only have one Part_id) -Original Message- From: Ben Densmore [mailto:[EMAIL PROTECTED]] Sent: Friday, June 01, 2001 11:25 AM To: CF-Talk Subject: Updating multiple rows! I am trying to update multiple rows at once and I don't seem to get any errors but when I try to get the info I just updated nothing is there. Can someone tell me if this Query should work? CFQUERY NAME=engineeringinfo DATASOURCE=Biosreference DBTYPE=ODBC Update BiosPart SET VGA_Rom = 'PCI' WHERE Part_ID = 751 AND PART_ID = 752 etc... Thanks, Ben /CFQUERY ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF on Linux
I've used Cold Fusion on NT and Solaris, now thinking about using the Linux version. Anyone have any issues with the Linux version, or have experience converting? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cookies not being set
You cant set cookies on a page with CFLOCATION. The page is redirected before it is rendered by the browser, therefore, before your cookies are set. -Original Message- From: Mike Sprague [mailto:[EMAIL PROTECTED]] Sent: Monday, April 16, 2001 1:26 PM To: CF-Talk Subject: cookies not being set I have a login page that checks my db to validate user info and if valid uses cflocation to redirect to the appropriate page. I need cookies to work because people with AOL have been having problems keeing the session variables alive. My code is below, any help would be greatly appreciated. Mike cfif CheckLogin.RecordCount Is 0 Or CheckLogin.RecordCount GT 1 cfset Session.error_message="Your Login Information Is Incorrect. Please Try Again." cflocation url="/login.cfm" addtoken="No" cfelseif CheckLogin.RecordCount Is 1 cfcookie name="UserLevel" value="#int(CheckLogin.UserLevel)#" expires="1" cfcookie name="LoggedIn" value="true" expires="1" cfcookie name="Username" value="#CheckLogin.Username#" expires="1" cfcookie name="UserID" value="#int(CheckLogin.UserID)#" expires="1" cflocation url="/members/index.cfm" addtoken="Yes" cfelse cflocation url="/login.cfm" addtoken="No" /cfif ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Regular expression help
Help for a regular expression idiot. I'm looking to remove all the characters between two tags: example from: table asldfj lskdf jaskldf jklasdf jlaskdfj lasdkf /table to: table/table (removing the tags themselves would be a plus) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMail Question
Has anyone done a comparison between using the CFMAIL tag vs. writing the file directly to the spool directory? -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 14, 2001 3:38 PM To: CF-Talk Subject: Re: CFMail Question Yup, CFMail is The slowest ColdFusion tag. jon - Original Message - From: "Bryan Love" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, March 14, 2001 2:32 PM Subject: RE: CFMail Question You will need a VERY powerful cf server and a hefty mail server. Have you ever looked at the CF server's processor during a CFMAIL call? It hits 100% for what seems like a long time. CFMAIL is very processor intensive and should not be used heavily on a production machine. If you plan on sending more than, say... 300 mails a day you should seriously consider getting a dedicated machine solely for using CFMAIL. Bryan Love ACP Internet Application Developer [EMAIL PROTECTED] -Original Message- From: Chris Dodson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 14, 2001 11:14 AM To: CF-Talk Subject: CFMail Question I am creating an online notification board for my Intranet and am wondering what guidelines need to be followed when using cfmail. I could be sending up to 1 emails at a time. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Updating CLOBs
Been having an issue with updating clobs. Solaris 4.5.latest, Oracle 8i.latest, native datasource Inserting a record with a CLOB works fine, but when you go to update it, it throws a "Missing Expression Error". There is no missing expression. If you change the cfsqltype to CF_SQL_LONGVARCHAR the update will work, however I think that's what's causing our Oracle replication to fail. Anybody run into this? (code below) Jeff Britts Senior Software Engineer e-Dialog [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] CFQUERY NAME= "article_event_update" DATASOURCE= "ds" UPDATE article_event SET title='#form.title#', event_date='#dateformat(form.event_date,"DD-MMM-")#', update_date=sysdate, update_by='#user_id#', content=cfqueryparam value="#form.content#" cfsqltype="CF_SQL_CLOB" WHERE article_id=#form.article_id# AND article_event_id=#form.article_event_id# /cfquery ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help, help, help Pleasssssse: migration from NT4 to Solaris
We're using both. Just started using Solaris 6 months ago. Both have been reliable. It's hard for me to compare the two. The Solaris runs about twice as fast, BUT, we've got a pretty hefty Sun box and a pretty basic NT box. -Original Message- From: Capolinea [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 07, 2001 10:39 AM To: CF-Talk Subject: Help, help, help Pleasse: migration from NT4 to Solaris Hello to all CF Guru, I was asked by my boss to look for informations in order to migrate a web site from NT4 to Solaris We are running CF 451 US Enterprise on 2 front server and a database Oracle 8i running on another server. Is it worth doing that (NT Solaris) ? What the pro and cons ? Any ideas, experience or advice would be GREATLY appreciate... Regards, Rémi van der Deure ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Migrating from Windows NT to Solaris
In our environment we're developing on NT and deploying on Solaris. (until we can get another Solaris box for development) The only issues we've found are case sensitivity in filenames and a different path structure if you're going to be doing things with cffile. Usually we just copy everything over, maybe fix an image name or include filename and it runs fine. -Original Message- From: David Schmidt [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 07, 2001 2:10 PM To: CF-Talk Subject: Migrating from Windows NT to Solaris Hi all, I have a customer that wants to switch from NT to Solaris. They use CF 4.5.1, SP2 on each. Their datasource will still run on an NT box using SQL 7 or 6.5 (not sure which yet). What I need to know is, since Solaris is case sensitive, what tags are affected? Are all tags that have href, filename, or datasource parameters affected? I am interested in only the coding aspects of the migration, not install, admin and such. Thank You, David Schmidt, ACP DevTech,Inc. http://www.dev-tech.com/ ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Freeing .ldb lock on remote server.
If you send a query to that database that will throw an error, eg. a select from a non-existant table, I've found that will unlock the the database. -Original Message- From: Angél Stewart [mailto:[EMAIL PROTECTED]] Sent: Monday, March 05, 2001 8:47 AM To: CF-Talk Subject: Freeing .ldb lock on remote server. Hello, I am using a shared hosting system, and I want to copy and update a database stored on the server that is locked (MSACCESS .ldb). I need to increase a field in the Users table from 50 to 255 characters. Do any of you recall the command or method to break the .ldb lock and so enable me to copy/transfer the .mdb file, do my compacting and updates and then send it back up to the server again? -Gel ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfmail multipart/alternative
Is there a way to send out a CFMAIL in Content-Type: multipart/alternative ? Jeff Britts Senior Software Engineer e-Dialog [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Advanced Security in CF 4.5
It's there...IF you specify that you want to use advanced security when you install -Original Message- From: Gregory Harris [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 31, 2001 1:08 PM To: CF-Talk Subject: Advanced Security in CF 4.5 Hello, I was in the process of moving a development effort using CF 4.0's advanced security to a CF 4.5 server, however I noticed that there is no way to set up Advanced security in the CF 4.5 admin, any ideas ppl, thanks! Gregory Harris Web Developer Stirling Bridge LLC ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT (slightly)--Graphing with CF
Does anyone have any comments/experience with either tags or commercial packages that build graphs from CF? Jeff Britts Senior Software Engineer e-Dialog [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
2nd try---CFMAIL time issue
We have an issue with the sent time of mail going out through CFMAIL. A check of the CF servers and the mail servers reveal those times correct. However, this is what the header looks like. Received: from fusion-prod1.blah.com ([10.200.5.95]) by corp-exc1.blak.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2650.21) id CGJBY6MY; Fri, 5 Jan 2001 09:49:48 -0500 ** This is right* Received: from 127.0.0.1 (localhost [127.0.0.1]) by fusion-prod1.blah.com (8.9.3+Sun/8.9.1) with ESMTP id JAA05563 for me mailto:[EMAIL PROTECTED] @blah.com; Fri, 5 Jan 2001 09:49:47 -0500 (EST) *This is right* X-Sybari-Space: From: test mailto:[EMAIL PROTECTED] @blah.com Message-Id: [EMAIL PROTECTED] Content-type: multipart/alternative; boundary="===---===---===---===---===_mailer" Date: Fri, 05 Jan 2001 09:49:06 + * This is wrong,(notice the correct time, but + instead of -5000) so the sent time is displayed as 5 hours off Any idea where it's getting that last time? Jeff Britts ColdFusion Engineer e-Dialog ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFMAIL time issue
We have an issue with the sent time of mail going out through CFMAIL. A check of the CF servers and the mail servers reveal those times correct. However, this is what the header looks like. Received: from fusion-prod1.blah.com ([10.200.5.95]) by corp-exc1.blak.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2650.21) id CGJBY6MY; Fri, 5 Jan 2001 09:49:48 -0500 ** This is right* Received: from 127.0.0.1 (localhost [127.0.0.1]) by fusion-prod1.blah.com (8.9.3+Sun/8.9.1) with ESMTP id JAA05563 for me mailto:[EMAIL PROTECTED] @blah.com; Fri, 5 Jan 2001 09:49:47 -0500 (EST) *This is right* X-Sybari-Space: From: test mailto:[EMAIL PROTECTED] @blah.com Message-Id: [EMAIL PROTECTED] Content-type: multipart/alternative; boundary="===---===---===---===---===_mailer" Date: Fri, 05 Jan 2001 09:49:06 + * This is wrong,(notice the correct time, but + instead of -5000) so the sent time is displayed as 5 hours off Any idea where it's getting that last time? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfif : Okay within cfinput tag?
It Will work if you use a regular form instead of the cfform -Original Message- From: Brendan Avery [mailto:[EMAIL PROTECTED]] Sent: Friday, January 05, 2001 5:31 PM To: CF-Talk Subject: Re: cfif : Okay within cfinput tag? not okay. you can't nest tag brackets within CFML, ever. At 05:20 PM 1/5/2001 -0500, you wrote: I've got a cfform with a couple cfinput type = "Radio" tags in it. I'm trying to put a cfif statement within the cfinput type = "Radio" tag but I keep getting an error. I'm not sure if my syntax is wrong or whether this is just not allowed. The code is along the lines of: cfinput type = "Radio" name = "language" cfif variablefromdb is 'english' checked = "Yes"/cfif The error always references the opening left caret ( ) that begins the cfif statement. It seems like you should certainly be able to use cfif conditions inside cfinput tags but I can't get it working. When I take out the cfif statements, it works fine. Thanks for help. Paul Sinclair ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: List w/ delims
You CAN use multiple characters as list delimiters...eg. "|*|". I do it frequently to cut down on the chances that one of my list items contains a delimiter. Jeff Britts ColdFusion Engineer e-Dialog -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 07, 2000 2:21 PM To: CF-Talk Subject: Re: List w/" " delims Keep in mind that list delimiters can only be 1 character. -- Billy Cravens [EMAIL PROTECTED] Eric Fickes wrote: Got a List question for you. I've got a text file that I need to parse and it's " delimited list, in a way. The list format is this. "Full Name" "Email Address" "Group List" "Login Name" "Demo user for startup" "" " 1;" "Demo" I was hoping to somehow use " " as a delimeter, but that's not working. When I do that it takes out the spaces in the column names. I'd like to take "Full Name" "Email Address" "Group List" "Login Name" and turn it into Full Name,Email Address,Group List,Login Name Any ideas? E ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: PL/SQL
Basically, we're working on a tool to generate the pl/sql script on the fly so we cant use a stored proc. Any ideas? -Original Message- From: C Frederic Valone [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 9:54 AM To: CF-Talk Subject: Re: PL/SQL We use cf and pl/sql stored procs extensively. What exactly are you trying to do? Jeff Britts wrote: Anyone have any luck running PL/SQL through ColdFusion? The simple stuff seems to work ok, but if you throw it something complex it chokes. Jeff Britts ColdFusion Engineer e-Dialog ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: List w/ delims
Maybe the "*" character is throwing it off. Sorry, I might have given you a bad example. This is some code I have that works. I set up an array and then convert it to a list... cfset stuff_list = #arraytolist(stuff_new,"||Q||")# I can then pick items from that list, using a #location# index. cfset stuff1 = #listGetAt(stuff_list,location + 1,"||Q||")# cfset stuff2 = #listGetAt(stuff_list,location + 2,"||Q||")# cfset stuff3 = #listGetAt(stuff_list,location + 3,"||Q||")# cfset stuff4 = #listGetAt(stuff_list,location + 4,"||Q||")# Jeff Britts ColdFusion Engineer e-Dialog -Original Message- From: Robyn Follen [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 9:58 AM To: CF-Talk Subject: RE: List w/" " delims I've tried to user multiple characters as a list delimiter, but whenever I then try to iterate through the list, specifying my delimiter, it doesn't work. E.g., When I have the following code, CFSET myList = "o|ne |*| t*wo |*| th|*ree" CFLOOP Index="listElement" List="#myList#" Delimiters="|*|" CFOUTPUT #listElement#BR /CFOUTPUT /CFLOOP I get: o ne t wo th ree because it takes each item in the list of delimiters and checks for them individually. Has anyone any insight on how to loop through something with a particular combination of characters for a delimiter? Any help would be appreciated, Robyn -Original Message- From: Jeff Britts [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 8:29 AM To: CF-Talk Subject: RE: List w/" " delims You CAN use multiple characters as list delimiters...eg. "|*|". I do it frequently to cut down on the chances that one of my list items contains a delimiter. Jeff Britts ColdFusion Engineer e-Dialog -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 07, 2000 2:21 PM To: CF-Talk Subject: Re: List w/" " delims Keep in mind that list delimiters can only be 1 character. -- Billy Cravens [EMAIL PROTECTED] Eric Fickes wrote: Got a List question for you. I've got a text file that I need to parse and it's " delimited list, in a way. The list format is this. "Full Name" "Email Address" "Group List" "Login Name" "Demo user for startup" "" " 1;" "Demo" I was hoping to somehow use " " as a delimeter, but that's not working. When I do that it takes out the spaces in the column names. I'd like to take "Full Name" "Email Address" "Group List" "Login Name" and turn it into Full Name,Email Address,Group List,Login Name Any ideas? E ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Encryption problem when passed in URL?
use the urlencodedformat function to escape any of the url unfriendly characters, then urldecode it before decrypt. Jeff Britts ColdFusion Engineer e-Dialog -Original Message- From: Phill Gibson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 05, 2000 1:46 PM To: CF-Talk Subject: Encryption problem when passed in URL? Hi Everyone, Try this: htmlhead/headbodycfoutput cfset date= "27-FEB-02:28:07:18" cfset key = "aabbcc" Before encryption, date is #date#br cfset date2=Encrypt(date, #key#) Encrypted, date2 is #date2#br cfset date=Decrypt(date2, #key#) After encryption, date is #date#br /cfoutput/body/html With that given key and string, it gives the following output: Before encryption, date is 27-FEB-02:28:07:18 Encrypted, date2 is 2#1 276*NP/W/WWV.Y\,1]4OG After decryption, date is 27-FEB-02:28:07:18 Notice there is a space in the encryped string in position 4! If I pass this using, say, cfmail as an encrypted variable in the URL it bombs out as in: a href="www.domain.com/process.cfm?var1=2#1 276*NP/W/WWV.Y\,1]4OGclick here to proceed/a See that space still there? Some dates do this, but by far, most don't. I came up with a second one with a white space in it by tweaking the date after about 20 random tries. Does anyone have any suggestions? (I suppose I could just apologize to every ~20th customer for choosing the wrong time of day! ;-) Phill Gibson Velawebs Web Designs www.Velawebs.com [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: HTML help???
#htmleditformat(your_variable)# -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 26, 2000 8:37 AM To: CF-Talk Subject: HTML help??? I'm still looking for a solution to the html question I posed yesterday. I built a form page that spits out a webpage, I would like to be able to extract the html that is generated without having to use the IE source button. I know that there is a way to have the html code displayed in a table but can't figure it out. Thanks for your help, Rich Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Custom Tag w/JS functions
What I've done is enclose the cftag in script tags script cf_whatever /script I guess it depends on what your tag does, but give it a shot -Original Message- From: David Shadovitz [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 25, 2000 1:55 AM To: CF-Talk Subject: Custom Tag w/JS functions I'm writing a plain CF Custom Tag which also contains some JavaScript functions. I'm thinking of using CFHTMLHEAD to write the JS functions into the calling document's head. Any opinions as to where to write the JS functions? * At whatever point the tag is called * In the head via CFHTMLHEAD * Other? Thanks. -David 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]