Re: charset issue
running CFMX 6.1 on winblows with the almighty oracle.We are
grabbing some data from another server running CFMX 6.1 on Unix with
MySql via a webservice.Seems the data we get is not displaying
correctly.Things like the - char display as a wierd backward E among
other things.Is there a way to mod the returned data?Or does the
source have to be cleaned up?
Wild guess - the source contains characters from the Windows 1252 character
set which are not included in ISO-Latin1 or Unicode. Seems a bit odd seeing
as the source is a Unix machine (usually UTF-8 encoded Unicode characters),
but I suppose it's possible.
Can you determine what character code the weird backward E is? This can be
done using JS btw (String.charCodeAt()). It may be code position 150, which
is used by Windows 1252 for en dash. In CFMX, which as far as I know uses
the Unicode character set (UTF-8 encoding) by default and does not support
Windows 1252, the character at code position 150 cannot be printed because
code positions 128-159 are reserved for control characters in Unicode
(note: Unicode is a superset of ISO-Latin1 so the same applies to Latin1).
Warning: I'm actually running CF5, so I might have made a mistake here - no
doubt somebody will point it out if that's the case.
Here's a code snippet from the Html property in Speck CMS which will
convert these Windows 1252 characters into their nearest counterpart in
Latin1 or a html entity. You could alternatively convert them to their
Unicode equivalents, but you'll need to figure out that mapping yourself ;)
if ( convertWin1252 ) {
// convert windows 1252 chars to nearest latin1 or html entity
lFind =
#chr(128)#,#chr(130)#,#chr(131)#,#chr(132)#,#chr(133)#,#chr(134)#,#chr(135)#,#chr(136)#,#chr(137)#,#chr(138)#,#chr(139)#,#chr(140)#,#chr(142)#,#chr(145)#,#chr(146)#,#chr(147)#,#chr(148)#,#chr(149)#,#chr(150)#,#chr(151)#,#chr(152)#,#chr(153)#,#chr(154)#,#chr(155)#,#chr(156)#,#chr(158)#,#chr(159)#;
lReplace =
euro;,sbquo;,fnof;,bdquo;,hellip;,dagger;,Dagger;,circ;,permil;,Scaron;,lsaquo;,OElig;,##381;,lsquo;,rsquo;,ldquo;,rdquo;,bull;,ndash;,mdash;,#chr(126)#,trade;,scaron;,rsaquo;,oelig;,##382;,Yuml;;
inHTML = replaceList(inHTML, lFind, lReplace);
}
Mark
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Re: charset issue
At 16:46 10/09/2004, you wrote:
thanks for the input Mark.
hmm, the webservice is built in CF pulling from a MySQL DB all on SunOS 5.8.
I'm not a MySQL user, but it's very possible that if MySQL is told to store
a character with code position 150, it will store it. It has no idea what
the visual representation of code position 150 is. So, a Windows user,
submitting a web form for example, could post a string of characters, one
of which might be chr(150), i.e. en dash in Win1252 and it would be stored
by MySQL (CFMX will do similar btw, there's nothing stopping you creating a
string containing chr(150) - it's only when you go to print it that you
don't see what you expect because as far as CFMX is concerned, it's not
printable). I might be on the wrong track here, I'm just guessing because
you refer to the - sign being a problem that it may be an issue with
Win1252 chars (I think word's auto-mangle feature converts minus to en dash
in certain circumstances btw).
I was wondering, the DSN setup in CFAdmin has a ckbox for 'Enable
Unicode...' wondering if this might cure it.Thoughts?
Adding useUnicode=truecharacterEncoding=UTF-8 to the connection string
for your DSN will tell the JDBC driver to use Unicode with UTF-8 encoding.
Might do the trick.
using some stupid replacing like this function at the moment, but its
not exhaustive.
function cleantext(text) {
text = Replace(text, Chr(65426), ', All);
text = Replace(text, Chr(65425), ', All);
text = Replace(text, Chr(65427), ', All);
text = Replace(text, Chr(65428), ', All);
text = Replace(text, Chr(65430), -, All);
Return text;
}
That's basically the same approach I take tbh, if I'm dealing with
character sets using the same code positions to represent different characters.
Mark
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
SpeckCMS
Hi, I noticed that during a recent thread regarding Farcry and SpeckCMS, not many people had heard of SpeckCMS (www.speckcms.com). So, I thought I'd provide a wee bit more info... Speck is an object-based open-source content management framework that was initially developed by Robin Hilliard (www.builderau.com.au/askexperts/macromedia/). I got involved in the development almost immediately after he released a rough alpha version in May 2002. Speck has been designed to be OS, web server and database independent and has been tested on both Windows and Linux, with IIS and Apache and Access, SQL Server, Oracle, PostgreSQL, Firebird and MySQL (4.1 required). It can also be used with CF5, as it is built using custom tags rather than CFCs. It is a stable solution, which has been used in production for about 2 years. Geoff Bowers mentioned that Speck is more of a toolkit than Farcry, and that is true - Speck was conceived as a framework. However, it is distributed with an example CMS (SpeckCMS) that provides a set of out-of-the-box content management capabilities. Farcry definitely does provide more for the end user out-of-the-box, but from my limited experience with it and vast experience with Speck (read: I'm biased ;), I'd have to say that I think Speck is simpler to extend to provide custom functionality. Our development team is not made up of highly experienced software engineers and is probably typical of many CF development teams, yet everyone in the team is confident using and extending Speck and they have even learnt something about OO development in the process (ok, I did have to give a few slaps to get the copy 'n' paste merchants to use inheritance, but corporal punishment is sometimes necessary ;). I also know that Speck has been used by non-programmers for content management requirements (apparently www.fashion.ie was built in a weekend by someone who didn't know any CF when he started). For the end user, we have found SpeckCMS to be a great success. We deal with business people and medial professionals who tbh just see technology as a necessary evil (and fair enough, they're probably right). SpeckCMS allows content to be edited in-context, i.e. the user just browses to the page they want to edit and clicks on the relevant edit link embedded into the content. I'm not sure if Farcry also allows this, but I know many other systems don't and we've found it to be a huge benefit that not only saves us a small fortune on training and support but really impresses the customers (ok, they are easily impressed, but perception is important). Well, I've rattled on for long enough - hope this has been informative Mark [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SpeckCMS
I also know that Speck has been used by non-programmers for content management requirements (apparently www.fashion.ie was built in a weekend by someone who didn't know any CF when he started). ... www.fashion.ie looks like built in with fuseaction and static content An CF newbie don't have all that know how to do any site like that. in a weekend... What's happened? Apologies, I know the guy who built fashion.ie and he told me he did it in a weekend, but I forgot that he had already built a site with CF, Speck and Fusebox - www.zozea.com. Still, he's not a programmer, just a decent HTMLer, competent enough to hack into and copy/paste other people's _javascript_, PHP and now CF, code and he's managed to build a couple of sites with Speck. He's done this almost without any assistance - but I did install Speck on the shared host he uses and helped him clean up the whitespace created through using Speck and Fusebox together. My memory is fried at the moment, too much work and study on the go. Again, apologies for the misrepresentation. BTW, the pages on fashion.ie aren't static, they're just search engine safe URLs. Mark [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Strange ODBC Error
change your default Network protocol to TCP/IP in the SQL Server Client Config The named-pipes protocol does more than just shift data from A to B, it has some security mechanisms too. Any breaks in the network traffic between your web server and database can cause errors like this. Mark ~~ 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
Fantasy Football tag/app
I've been asked to estimate the development time for a web-based fantasy football league, but I don't know anything about football (in this case, soccer) so I was hoping to find a ready-made app (either free or pretty cheap). No luck on the developers exchange though. Has anyone got a Fantasy Football League application or tag, which they'd be willing to let me use? Thanks Mark ~~ 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: Grabbing image size values
the CF_ImageSize tag in the tag gallery doesn't work correctly with some jpeg images saved in Photoshop 5.5 (possibly other versions too, haven't tested them though). Mark ~~ 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
running RDS service as non-system account (forgot to say...)
I'm running CF Pro, not Enterprise so don't have the Advanced Security options in the administrator, though I've just seen a comparison matrix at: http://www.macromedia.com/software/coldfusion/productinfo/matrix/cf5_matrix.pdf which lists cf4.5 pro as having the advanced security options - whassastory? ~~ 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: Protect CF from SQL/Oracle errors?
wild guess... are you using CFERROR TYPE=Exception in the Application.cfm? If you are, check the error handling template for CFML errors. If there are any, CFERROR will keep calling itself indefinitely when an error is encountered. All assuming of course, you are not using try/catch blocks (very possible seeing as it's a development server). Mark ~~ 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
Brainbench certification
http://www.brainbench.com Anyone know how well respected certification from this lot is around the world. I know there are loads of US and some UK and Australian users on the list - any of you heard of them? A friend of mine has just moved back to South Africa and she is apparently being asked for Brainbench certification for her CF skills, rather than the Allaire certification which I thought was very odd. I'm planning to move away from Ireland again soon and have been thinking that although I have a lot of proven experience, some certification wouldn't go amiss. Brainbench is cheap and they have certification covering pretty much all the areas in which I work. Mark ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF_GOINGNUTS
Maybe it's just a problem with the looping condition or code within the loop, but if you're sure it's not... AFAIK CFHTTP on windows uses the wininet.dll, which has various 'issues' (MS speak for 'bugs'). One of these is a limited number of concurrent connections per server. Check these articles: http://support.microsoft.com/support/kb/articles/Q183/1/10.ASP http://support.microsoft.com/support/kb/articles/Q238/4/25.ASP I'm gonna send cfx_http files in a direct email in case you want to use it, but it's limited in what it can do - great for spidering, but no POST support and it also uses the wininet.dll. I'd recommend the ASPHTTP component available from ServerObjects.com, if you find the problem is really a CFHTTP one, especially if it's related to wininet.dll (ASPHTTP doesn't use it). Mark At 02:09 PM 5/30/2001, you wrote: I'm having problems with cfhttp ! let me know if you can help with this: I'm trying to loop over 30 cfhttp tags, the problem is that coldfusion first goes ok, and then for some reason the next CFHTTP or the 3rd/4th/5th CFHTTP fails, and the rest (till 30) fails, with the SAME status CODE and SAME mimetype. something like - it's ain't running at all after a specific number of THREADS!!! anyone know also where can I find cfx_http and how good is it? help, please ~~ 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: Instantiate environment?????? Whats that?
Instantiate normally refers to the creation of an instance of a class (ie an object) when dealing with object orientated programming (going back to ye olde telephone example from college - the object 'telephone' is an instance of the class 'telephones'). Ok, there's a little more to it than that, but you get the picture. I'm not 100% sure of what this error means, having never seen it before, but I'm sure it's something to do with a failure to create an ODBC instance. You say the sites have an identical setup, if they do, something has gone haywire on one (windows voodoo), but I'd guess you have different versions of the MS Data Access Components installed on both machines (ODBC is one of the components included) - get the latest copy of MDAC and fingers crossed the problem will be resolved. Mark What does this error message mean? I'm using an access database as an interim measure with this project. The CFQUERY mentioned hasn't got anything special in it .. this page is copied from another site that works fine with identical setup - only the data itself is different. So I don't think it's a code error. (but then again I've been known to be wrong before. 1975 I think it was) Here's the error message: [quote] Error Diagnostic Information ODBC Error Code = () Unable to instantiate environment for 'ODBC.' The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (1:2) to (1:49). Date/Time: 05/17/01 00:08:46 Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows 98; DigExt) [end quote] And who thought up that word instantiate??? Do they really mean initiate? Initialise? Cheers, Mike Kear AFP Webworks Windsor, NSW, Australia Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: store SQL time only
108 06:32 PM 5/8/2001, you wrote: I need to store in the SQL time only (as: 21:05:32) can someone please tell me the function for date/time display/formatting in SQL? I only know that this: (convert(char(10),getdate(),101)) will give me this: 30-01-2000 (display code 101), but what is the code for time only? help. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT - synch files automatically
store all the images on one server and map drives to it from the other servers or use file replication service At 05:28 PM 5/2/2001, you wrote: I am having problems replicating images across to load balanced servers. We have users that are upload images to one server and need to have an automated way to check the other server for this file and if it doesn't exist we need to transfer a copy over. Has anyone came across any solutions for this. Thanks for any help! Rick ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Using 90-100% of processor time (911!)
and in case you haven't already done so, make sure you have the latest service pack for your version of CF installed. At 02:42 PM 5/3/2001, you wrote: Would any of the log files give you a hint as to which pages were accessed when the server started using up resources? Not necessarily, although there is a log slow pages option which can be enabled in CF Administrator. Often, the slow pages will be the ones causing trouble! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How to Force https vs http
check CGI.SERVER_NAME variable and take whatever action is required within your CF script. I can't think of any security issues with this. Mark At 02:56 PM 5/3/2001, you wrote: Howdy all, Quick questionis it possible to have a URL redirect to a secure URL? For example, someone enters http://www.xxxblahxxx.com/secure/securepage.cfm instead of https://www.xxxblahxxx.com/secure/securepage.cfm. How do you force a redirect to the secure URL? Is that a server function, or can it be done programmatically? TIA, Chris Montgomery [EMAIL PROTECTED] Web Development Consulting http://www.astutia.com Allaire Sales Consulting Partner 210-490-3249/888-745-7603Fax 210-490-4692 Instant Messaging: AIM: astutiaweb; ICQ: 7381282; MSN: [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: Hosting
try www.servervault.com At 09:01 PM 5/1/2001, you wrote: Anyone know of a hosting company who will provide the CF/SQL server and manage it? I just need monthly cost for a year contract. Maybe setup too. Steph ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: FW: cfx_http
the company which provided it are at: http://www.fsc.follett.com/ but the CF tags seem to have gone missing. It doesn't support POST method, only HEAD and GET AFAIK (it was written to run as a spider). If you still want to get a copy, email me off list. Regards Mark At 09:28 AM 5/2/2001, you wrote: -Original Message- From: DDE [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 02, 2001 11:06 To: HouseOfFusion CF-Server Subject: cfx_http Hi, Cfx_http is mentioned in Allaire's Tags Gallery, but is not downloadable. The author's e-mail is not even accessible. Does anyody of you know where this tag can be downloaded and how it behaves compared to cf_http. Or would you have any other alternative to cf_http that would better handle POST requests. Thanks Dominique ~~ 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: autonumbering in oracle
You don't need to reproduce SQL server's autoincrement feature, as Oracle already has its own Sequence functionality, CREATE SEQUENCE. And you don't need a trigger, Oracle sequences work on normal insert statements. Just creating a sequence will not 'auto-increment' an integer column when new rows are inserted. I have had to reproduce/emulate SQL server's auto-increment feature a number of times when moving apps from SQL Server to Oracle. If you want the same SQL code embedded in the CFML to work on both DBMSs, what other way is there to achieve this without using a combination of sequence and trigger? Much simpler... depends on what your requirements are Mark Ben -Original Message- From: Mark Woods [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 24, 2001 10:42 AM To: CF-Talk Subject: Re: autonumbering in oracle standard way is to create a sequence and then use a trigger when inserting a row into the table, rather than explain any further, here's some code... /* dummy table */ CREATE TABLE test ( ID integer NOT NULL , sometext varchar2(50) NOT NULL , PRIMARY KEY (ID) ); /* Sequence and trigger to reproduce SQL server autoincrement feature */ CREATE SEQUENCE testID NOCACHE; CREATE OR REPLACE TRIGGER test_AutoID BEFORE INSERT ON test FOR EACH ROW BEGIN SELECT testID.NextVal INTO :new.ID FROM dual; END test_AutoID; Mark At 05:34 PM 4/24/2001, you wrote: I tried to use the download custom CF_max_id to do the autonumbering for inserting a new row into a oracle database table but the custom tag failed. I am wondering if anyone knows oracle have idea how to do it. I have the first column in the table named ContentId defined with datatype number. I would like to have the contentid incremented by 1 for each now row inserted. Someone works with oracle please let me know how to do this. thanks -- Global Internet phone calls, voicemail, fax, e-mail and instant messaging. Sign-up today at http://www.hotvoice.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Another regular expression question
REFind([^[:alnum:]],attributes.usuario) will find any non-alphanumeric
characters
The cf 4.0 docs have a decent intro chapter on regular expressions in the
advanced book:
http://www.allaire.com/documents/cf4/dochome.htm
At 11:23 AM 4/24/2001, you wrote:
Hi,
Yes, I'm a newbie :) but it's a short question:
How can I check if an string contains alpha-numeric characters only?
I'm trying to check if a login name (given by the user) is valid or not.
I'm using something like:
#REFindNoCase('[[:alpha]]*|[[:digit]]*',attributes.usuario)# but it doesn't
work.
BTW, some links of POSIX regular expression are welcome.
thanks in advance
~JAAV
~~
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: autonumbering in oracle
standard way is to create a sequence and then use a trigger when inserting a row into the table, rather than explain any further, here's some code... /* dummy table */ CREATE TABLE test ( ID integer NOT NULL , sometext varchar2(50) NOT NULL , PRIMARY KEY (ID) ); /* Sequence and trigger to reproduce SQL server autoincrement feature */ CREATE SEQUENCE testID NOCACHE; CREATE OR REPLACE TRIGGER test_AutoID BEFORE INSERT ON test FOR EACH ROW BEGIN SELECT testID.NextVal INTO :new.ID FROM dual; END test_AutoID; Mark At 05:34 PM 4/24/2001, you wrote: I tried to use the download custom CF_max_id to do the autonumbering for inserting a new row into a oracle database table but the custom tag failed. I am wondering if anyone knows oracle have idea how to do it. I have the first column in the table named ContentId defined with datatype number. I would like to have the contentid incremented by 1 for each now row inserted. Someone works with oracle please let me know how to do this. thanks -- Global Internet phone calls, voicemail, fax, e-mail and instant messaging. Sign-up today at http://www.hotvoice.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfdirectory
watch out for permissions problems, CF runs under the local system account by default, which will not have access to do anything on another machine. You'll need to run CF under another account which has the required permissions. Mark At 03:32 PM 4/23/2001, you wrote: Cold Fusion doesn't know that you have a virtual directory in IIS - that only works via HTTP requests (AFAIK). You either have to map the drive, or use the full unc path \\server\share\directory\files (though I think CFDirectory can have problems with that too) I am having an issue with CFDirectory. The issue is that I have all my ..cfm files one server, on the same server I have a virtual directory set up in IIS that links over to files on a different server on the same network. All the files that I want to list using thecfdirectory tag is on this other server. However, it is not a webserver nor does it have Cold Fusion Server. I was wondering if there is anyway to list the contents of virtual directories and/or the contents of a directory on another server (on the same network). Has anyone encountered this issue? If so, how did you handle it? I appreciate any help you may give Thanks, Brian ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL SERVER and IIS on the same machine?
one of the sites I'm involved in serves about 8 million pages a month, well over half of them requiring a database connection (most of these will have more than one query) and the site runs on a dual processor pentium III with win2000 and SQL Server 7 - no problems. Just make sure you spend a lot of time optimizing the server for performance and most importantly, stick a load of RAM into it, at least 1 GB. Nobody would recommend a single server config for a high traffic web site if the company had money to burn, but who has these days? Mark At 10:40 AM 22/04/2001, you wrote: Our hosting company told me they don't support SQL SERVER and IIS on the same NT machine. "Even Microsoft doesn't recommened it", they claim. What do you think? Money is always an issue... Thanks, -Michael. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: syntax for cli execution of a cfm page?
At 08:32 PM 18/04/2001, you wrote: Thanks for the info guys. In case anyone was wondering: cfml.exe c:\path\template.cfm does actually work. ;p cool, anyone know if this is new to cf 4.5? I don't know if I ever actually tried just running cfml.exe with the path as a parameter before, I'm gonna be kicking myself if this functionality has always been available. Mark ~~ 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 1000s of records
you could add a SQL server scheduled task to bulk insert (see BULK INSERT command in SQL server docs) into a temporary table from your text file and then use the data in the temp table to update the user info. Just moves the processing from CF onto SQL server, which will definitely improve performance. Even if you run both the BULK INSERT and UPDATE commands from a CF template, it'll still improve your performance considerably (only two database connections and queries now). Mark At 12:10 PM 22/04/2001, you wrote: SQL 7 - Original Message - From: "Brian Thornton" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, April 22, 2001 11:41 AM Subject: Re: Updating 1000s of records Access or SQL? - Original Message - From: "Michael Lugassy" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, April 22, 2001 3:17 AM Subject: Updating 1000s of records Our application is built like that so I'm reciving a daily .txt file with 1000s of lines. each line with a unique number that is userID. userID that is on this text file means he visited our site in the last 24 hours (complex, I know.. bear with me) I'm trying to find the best way to update 1000s rows of SQL 7 DB Table: USERS. with this information so that Colum LASTVISITEDDATE will have now() value for each person that was on that list. Any brighter ideas then loop list UPDATE WHERE userID='x end loop OR UPDATE WHERE userID='x' OR userID='y' OR userID='n...' Thanks, Michael Lugassy Interactive Music Ltd. ~~ 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: uploaded files
Or would the sub dir inherent its parents settings? providing all the files go into sub-directories of the physical directory set as the root of your virtual directory, yes (oh, assuming none of these sub-dirs are used as the physical root of some other virtual directory) Mark At 05:17 PM 22/04/01 -0400, you wrote: If you're using IIS then save the file to a folder that does not allow any execution or scripting. HTH, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - the World's most configurable mail server - Original Message - From: "Brook Davies" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, April 22, 2001 5:11 PM Subject: uploaded files I have an application which allows clients to upload various files which can later me accessed via the web. My concern is that if the uploaded file has a .cfm extension, when it is reviewed post upload, it could actually execute malicious code on the server. I guess the same would hole true with a .exe file (except that execute privileges are disabled). I need to allow a wide range of acceptable upload types, so I can't restrict it at the upload stage. What would be the best way to allow some one to access these files post upload while not posing a security threat? How would I enable a download of a .cfm file or a .js or whatever without having it execute on the server as opposed to promoting for a download? Brook Davies ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Friendly e-mail addresses
If you enter the email addresses inside angle brackets, the server should interpret anything else as a comment. So... CFMAIL FROM="""John Smith""[EMAIL PROTECTED]" etc. should do it (BTW, that should is there for a reason - no guarantee this will always work) Mark At 01:29 PM 4/20/2001, you wrote: ColdFusion Server Version 4, 0, 1, 0 Professional and Outlook 2000 as an e-mail client. === http://www.thenetprofits.co.uk/coldfusion/faq/index.cfm#answer55 How do I make a CFMAIL display "friendly" e-mail addresses? CFMAIL FROM="[EMAIL PROTECTED] (John Smith)" TO="[EMAIL PROTECTED] (List Members)" SUBJECT="List Mailing"Your e-mail here/CFMAIL === I'm doing what's described above not getting the "friendly" e-mail address I was expecting... just the full FROM and TO e-mail addresses. Anyone got an idea what I'm doing wrong? Thanks -- Aidan Whitehall [EMAIL PROTECTED] Netshopperuk Telephone +44 (01744) 648650 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Tunneling, Firwall?
If IE is permitted, then it seems the restriction is based solely on the user agent header. Get you vc++ app to send a user agent header which is the same as an IE one. At 10:58 AM 4/19/2001, you wrote: We're sending HTTP request to a CF server from within a client that is not a browser (It's our own Visual C++ application). We're having a problem with firewalls. Personal/Enterprise firewalls just don't seem to let us throgh (only IE is permitted). Can someone suggest a technical way to Tunnel from within a Firewall? I would like to research this subject. Thanks, -Michael. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Quick Question
have you checked that you can using the YALLA datasource you can see the
PeopleDirectory table? Just a simple select will confirm. It may be that
the table was created by a different user to the one used by the
datasource. If this is the case, you may need to refer to the table as
something like dbo.PeopleDirectory
At 12:27 PM 18/04/2001, you wrote:
Hi All,
I'm having a bit of a problem here. I'm trying to add
stuff entered into a form into a database table, but i
get this error:
Error Diagnostic Information
ODBC Error Code = S0002 (Base table not found)
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid
object name 'PeopleDirectory'.
SQL = "INSERT into PeopleDirectory (FirstName,
LastName, HomeAddress, HomePhone, Mobile,
JobDescription, Department) VALUES ('Heidi', 'Belal',
'whatever', 23232, 23232, 'whatever', 'whatever')"
Data Source = "YALLA"
The error occurred while processing an element with a
general identifier of (CFQUERY), occupying document
position (8:1) to (8:27) in the template file
C:\INETPUB\WWWROOT\YALLANESA3ED\ADMIN\SQL_ADDPERSON.CFM.
Date/Time: 04/18/01 13:02:47
Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows
NT 5.0)
Remote Address: 217.52.80.114
HTTP Referer:
http://217.52.80.114/yallanesa3ed/admin/index.cfm?method=PeopleDirectory
Query String: method=AddPerson
Could someone please tell me what this means? Or
what's wrong and what i should do to fix it?
Thanks!
=
Heidi Belal
ICQ# 32127109
http://m3.easyspace.com/hmbelal
A bus stops at a bus station.
A train stops at a train station. On my desk
I have a work station...
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: syntax for cli execution of a cfm page?
The cfml.exe executes the template specified in the CF_TEMPLATE_PATH environment variable. So first set this to the physical path to the CFML template you want to execute. e.g. set CF_TEMPLATE_PATH=c:\inetpub\wwwroot\temp\test.cfm then run cfml.exe c:\cfusion\cfml.exe You can also pass query strings using the environment variable QUERY_STRING. BTW, tis a good idea to always set this to something (even a blank string) to make sure you are not passing a query string set for one template into another. More info: http://www.allaire.com/Handlers/index.cfm?ID=3328Method=Full Mark At 06:04 PM 18/04/2001, you wrote: What is the syntax to use to execute a cfm page directly from the commmand line? Something like cfml.exe /path/to/template.cfm? (Win2000, CF4.5) Also, where does the output go of the page when you do this? And, does RequestTimeout have any use here, or will the process run as long as it takes...? Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion http://www.is300.net ___The Enthusiast's Home of the Lexus IS300 http://www.digitacamera.com __DigitA Camera Scripts and Tips http://www.linklabexchange.com _Miata Link ECU Data Exchange ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Delimiters
unprintable US-ASCII control characters, chr(30) for example At 01:54 PM 4/17/2001, you wrote: Besides commas and pipes, what are the next best choices for delimiting lists? thanks, Dave === David R Hannum Ohio University Web Analyst/Programmer (740) 597-2524 [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: Delimiters
At 03:11 PM 4/17/2001, you wrote: use a series of hard to find types. something like: "~%~" I think a sequence of characters is interpreted as a sequence of different possible delimiters, rather than a single delimiter comprising of a sequence of characters. Might be wrong, but I'm sure I ran into this a few years ago this will guarntee NO ONE will type it. - Original Message - From: "Dave Hannum" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 2:54 PM Subject: Delimiters Besides commas and pipes, what are the next best choices for delimiting lists? thanks, Dave === David R Hannum Ohio University Web Analyst/Programmer (740) 597-2524 [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: Reveral of a field
trim(listLast(field)) " " trim(listFirst(field)) At 12:47 PM 4/12/2001, you wrote: Hi, I have a field with Smith, John as the contents. I want to display John Smith... I'm think I get the total length(a), then the charlength of the comma(b). Take contents b + 1 and subtract that from a equals (c) Then display the difference of c to a (d) and then output c after d to the total of the field Any other ideas? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Cftransaction on linux
AFAIK, the latest version of MySQL does offer transaction support, though I couldn't tell you whether the ODBC drivers do or not. At 01:14 PM 4/11/01, you wrote: I believe that MySQL does not support transactions at all. I understand that this is a feature that the MySQL developers are looking, or in the process of developoing though. I imagine that when the database software supports transactions, the ODBC driver will be updated to support it. Dian Oktosoma wrote: Is there any MySQL odbc driver that support cftransaction for use with CF on linux version ? The included driver (MERANT ODBC) doesn't support it. thanks ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Using an Object for ASP in CF
should be able too, see the cfobject tag in the CF docs. At 02:41 PM 4/10/01, you wrote: I have an object called ASPHttp by ServerObjects, inc. for GET/POST/HEAD documents using http protocol and was wondering if I could use this dll with ColdFusion pretty much the same way the ASP does. Thanks for any help. ~~ 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: compare files??
there is also a file compare program included with windows which can be run and the command prompt fc.exe At 03:48 PM 4/4/2001, you wrote: Visual Source Safe can be used to compare files and show the differences. It integrates pretty well with CF. IMHO, it's a good idea to use some version control system anyway. Russell Conway HallofSports.com, Inc. 351 West 22nd Street New York, NY 10011 P (646) 638-2500 F (646) 638-3444 http://www.hallofsports.com .. . . where the legends live on -Original Message- From: Akbar Pasha [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 04, 2001 10:45 AM To: CF-Talk Subject: compare files?? hi, i was just wondering whether CF studio has any facility to compare 2 ..cfm files and list out the differences. coz i need it very much in my work and if its not there, is there any other way i can do the compare? TIA akbar ~~ 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: using cfhttp for ASP?
you need to output the cfhttp.filecontent variable Is this the problem? At 05:07 PM 4/4/2001, you wrote: Sure did. ;) I created a page named "test.asp" and within the body I have %response.write "This is a test..." % In my cfm page I have in the body: CFHTTP URL="http://collections.sbc.com:800/test.asp" METHOD="GET" However, when I pull up the cfm page the asp text is not being shown. ?? Thanks, Dayv -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 04, 2001 8:44 AM To: CF-Talk Subject: RE: using cfhttp for ASP? you want to grab the content of an ASP page with CFHTTP? sure. CFHTTP URL="http://domain/path/file.asp" METHOD="GET" did you *try* it? -Original Message- From: SHEETS, DAYV (PB) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 04, 2001 8:31 AM To: CF-Talk Subject: using cfhttp for ASP? Can anyone tell me if it is possible to perform a cfhttp with ASP as the template? If it is possible please also provide an example of how this is accomplished. Thanks, Dayv ~~ 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: Weird page timeouts with Oracle
Sounds like CF is timing out before the query is returned from the database, but this is not canceling the database transaction. CF still receives the query result set back from the database and is then caching it, making the second load of the page a lot faster. Very smart behaviour if this is what is happening. Mark At 05:15 PM 4/4/2001, you wrote: Hi, We have been getting a series of very weird error messages with CF lately. We have got two servers, one with CF and another with the Oracle database. The CF server page request timeout is set to 30 seconds. When we request a page for the first time, it always goes beyond this threshold for some reason (it should not take that long anyway) and we get the CF page timeout error message. However if we request the page again, chances are that everything will go ok. Another scenario: 1. We request a page for the first time with a browser, and it is starting to take too long to deliver... 2. If in that time (within the 30 seconds threshold) we request that very same page with another browser (on another machine) the page in browser the first browser gets finally delivered while the one in the second one starts taking a long time to deliver. It looks like if Oracle is not passing control back to CF unless this is forced somehow by another request done by someone else. We are trying to work out why are we still getting this erratic behaviour. We are using: Solaris 5.8, Apache 1.3.9, Oracle client 8.1.6.3 Any ideas or comments about what could be going wrong would be greatly appreciated. Francisco Montes Spain on Line ~~ 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: Caching Query vs. Setting Application Var
both methods put the data in memory so from an efficiency point of view, both should be pretty much the same. Query caching is a much simpler method of achieving the required result. If you store the query structure as an application variable, when does it get updated?? At least with Query caching you can specify a time span or an absolute time for the expiration of the cache. If you were to use an application variable you'd have to come up with some way of determining when the database should be re-queried and the new result set assigned to the application variable (maybe at the start of a new user session). Of course, this would give you more explicit control over the cache, but is it worth the hassle? Mark At 01:04 PM 4/3/2001, you wrote: Hello, I have an application that generates Faculty Class Lists here at the university. When the faculty or administrator first comes in, it queries our Data Warehouse for a list of active instructors. The list is about 1400 names. The SQL for this query never changes. Related, our Data Warehouse is in Oracle on the IBM mainframe. SO, as a result, queries on larger tables (well, about any query for that matter) is very slow. My question is, would it be more effecient to do a QUERY CACHEDAFTER or put the results into an application variable? Thanks, Dave === David R Hannum Ohio University Web Analyst/Programmer (740) 597-2524 [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: CFUSION\MAIL\UNDELIVR
I'm sure there is something available in the dev exchange that does this (and more). At 02:08 PM 4/3/2001, you wrote: Hope someone can respond to me off list, this is pretty urgent. Something in C:\CFUSION\MAIL\UNDELIVR is really bunging up my developing station. Something about too many files named index, yet all files in this directory have numeric names. There are some 1,000 or so files in this directory. Anybody know anything about this? Can I delete these files and move on? Help... *whimper* There's one thing I would do with this directory Have a scheduled template that runs hourly/bi-hourly and checks for files in the directory - if it find any files it should do one of 2 things 1) if the file is more than 1 day old, delete it (it's a rubbish email address) 2) otherwise move it back to the spool directory If you move every file to the spool directory, then rubbish emails will be continually attempted all of the time - this will eventually become a complete waste of time... Philip Arnold Director Certified ColdFusion Developer 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. ** ~~ 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: support for unicode in CF5?
I wish the chr() function would barf when passed a code it didn't understand then. At 06:42 AM 4/2/2001, Ben Forta wrote: Kay, Nope, that's in CF6. --- Ben -Original Message- From: Kay Smoljak [mailto:[EMAIL PROTECTED]] Sent: Monday, April 02, 2001 1:32 AM To: CF-Talk Subject: support for unicode in CF5? Hi all, Can anyone comment on whether CF5 will have full unicode support? I can't seem to find it on the site or in the beta release notes. Thanks, Kay. ~~ 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: Oracle drivers and 8bit (or multibyte) characters
Thanks for replying, have already added NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1 to the ColdFusion startup script, but think I need to add it to the ENV_LIST instead. Will get the administrator to do so ASAP. Fingers crossed this should fix it then. Thanks again Mark At 02:43 PM 3/30/2001, you wrote: Hi, Looks like you have two different problems...: Your ALTER SESSION command is not correct, first you do not need commas in this command, second and worse ALTER SESSION doe not support to set NLS_CHARSET which is an environment only variable. You should try to use the NLS_LANG env variable which works at the client as well as the server level. The syntax is NLS_LANG = language_territory.charset So on you Linux box this should be something like: setenv NLS_LANG AMERICAN_AMERICA.WE8ISO8859P1 Here under a part of Oracle manual about that: snip This feature implicitly determines the language environment of the database for each session. An ALTER SESSION statement is automatically executed when a session connects to a database to set the values of the database parameters NLS_LANGUAGE and NLS_TERRITORY to those specified by the language and territory arguments of NLS_LANG. If NLS_LANG is not defined, no ALTER SESSION statement is executed. When NLS_LANG is defined, the implicit ALTER SESSION is executed for all instances to which the session connects, for both direct and indirect connections. If the values of NLS parameters are changed explicitly with ALTER SESSION during a session, the changes are propagated to all instances to which that user session is connected. /snip Dominique -Original Message- From: Mark Woods [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 3:38 PM To: CF-Talk Subject: Oracle drivers and 8bit (or multibyte) characters Hi, I've been having some trouble with a simple content management system written in CF, running on RedHat Linux with Apache and connecting to an Oracle 8i database. When an 8bit character (character with code between 128 and 255 inclusive) is added using one of the web forms, it's gets dropped to the 7bit ASCII range. The Merant ODBC driver and the Oracle 80 Native driver both drop 128 from the 8bit character codes, e.g. chr(233), eacute, becomes chr(105), i. I have worked around this through a combination of using HTMLEditFormat and having some custom character code translations, but it is not ideal as this database may be used to publish to print again in the future (ok, I can un-escape characters, but why should I need to?). I have tried using the Oracle ALTER SESSION statement at the start of transactions to try and change the NLS_LANGUAGE, NLS_TERRITORY and NLS_CHARSET environment variables for the connection, but I think I may have the syntax wrong as I'm getting a "missing or invalid option" error. I've included my statement below, if anyone knows what's wrong, please let me know. Has anyone else experienced this? Is there a workaround? Can I force the drivers to send a correct ALTER SESSION statement when opening a connection? Should this be necessary, i.e. is there something amiss with the Oracle DBMS config that connecting clients are using the default Oracle charset of 7bit ASCII rather than the charset which has been set on the server, ISO-8859-1 (AFAIK using the NLS_LANG environment variable). Thanks Mark now, that alter session statement: --- ALTER SESSION SET NLS_LANGUAGE = 'AMERICAN', NLS_TERRITORY = 'AMERICA', NLS_CHARSET = 'WE8ISO8859P1' ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: Automate FTP
type at /? at the command prompt to find out Alternatively, in Windows2000 use the scheduled tasks control panel Mark At 01:21 AM 3/29/2001, you wrote: I've created a FTP batch file, ftpcmd.bat: %windir%\ftp.exe -s:%f0 goto done open financialcontent.com (user name omitted) (password omitted) lcd d:\website\htdocs\stockgolf\htdocs\data ascii get eod.txt bye :done @echo off cls exit So how do I schedule this with AT? best, paul ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Oracle drivers and 8bit (or multibyte) characters
Hi, I've been having some trouble with a simple content management system written in CF, running on RedHat Linux with Apache and connecting to an Oracle 8i database. When an 8bit character (character with code between 128 and 255 inclusive) is added using one of the web forms, it's gets dropped to the 7bit ASCII range. The Merant ODBC driver and the Oracle 80 Native driver both drop 128 from the 8bit character codes, e.g. chr(233), eacute, becomes chr(105), i. I have worked around this through a combination of using HTMLEditFormat and having some custom character code translations, but it is not ideal as this database may be used to publish to print again in the future (ok, I can un-escape characters, but why should I need to?). I have tried using the Oracle ALTER SESSION statement at the start of transactions to try and change the NLS_LANGUAGE, NLS_TERRITORY and NLS_CHARSET environment variables for the connection, but I think I may have the syntax wrong as I'm getting a "missing or invalid option" error. I've included my statement below, if anyone knows what's wrong, please let me know. Has anyone else experienced this? Is there a workaround? Can I force the drivers to send a correct ALTER SESSION statement when opening a connection? Should this be necessary, i.e. is there something amiss with the Oracle DBMS config that connecting clients are using the default Oracle charset of 7bit ASCII rather than the charset which has been set on the server, ISO-8859-1 (AFAIK using the NLS_LANG environment variable). Thanks Mark now, that alter session statement: --- ALTER SESSION SET NLS_LANGUAGE = 'AMERICAN', NLS_TERRITORY = 'AMERICA', NLS_CHARSET = 'WE8ISO8859P1' ~~ 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: Special cahracters in replacelist
use #chr(13)##chr(10)# This corresponds to Carriage-return line-feed, which is the new line sequence for SMTP At 12:51 PM 3/28/2001, you wrote: I'm trying to carry our a replace of li and /li in a CFMAIL message so the web content is split by line breaks at the li and /li. I can carry out a replace using replacelist with normal characters such as a - but can't find a way to place a replacement of a newline character in the list. Is there a reference source for this type of information? Ed Brown www.go-britain.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: CFMAIL - twofold
once you enclose your email address inside angle brackets, you should be fine. The mail server should ignore the rest of the command as a comment (note the word 'should', I didn't say 'will'). At 03:45 PM 3/27/2001, you wrote: you CAN have FROM="Jay Patton[EMAIL PROTECTED]". i use that format all the time. so you *can* have spaces in the FROM attribute. -Original Message- From: Jay Patton [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 1:43 PM To: CF-Talk Subject: Re: CFMAIL - twofold someone correct me if im wrong but doesn't the "From= " line have to have a valid email address such as: FROM="[EMAIL PROTECTED]" and cant have a name like: FROM="JAY PATTON"? i think i ran into a problem like this a while ago.?!?. Jay Patton Web Design / Application Design Web Pro USA p. 406.549.3337 ext. 203 p. 1.888.5WEBPRO ext. 203 e. [EMAIL PROTECTED] url. www.webpro-usa.com - Original Message - From: "Mark Lapole" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, March 26, 2001 2:06 PM Subject: CFMAIL - twofold i may be a complete fool (some may argue), but if i'm trying to achieve 2 emails being sent off after a submitted form... what to do? 1) verification email sent back to the submitter (given they supply a valid email address) with registration and seminar information and 2) email to internal events person responsible for these registrations No db involved -- should just be simple CFMAILs right? Can't have 2 CFMAIL tags on same action page? Using the following: -- CFMAIL TO="[EMAIL PROTECTED]" FROM="Online_Registration" SUBJECT="Seminar Registration" TYPE="HTML" Name: #Form.FirstName# #Form.LastName#BR Company: #Form.CompanyName#BR Address1: #Form.Address1#BR Address2: #Form.Address2#BR Email: #Form.EmailAddress#BR Phone: #Form.Phone#BR Fax: #Form.Fax#BR /CFMAIL CFMAIL TO="#Form.EmailAddress#" FROM="Online_Registration" SUBJECT="Seminar Registration" TYPE="HTML" Thank you for signing up to attend blahblahblah!BRBR The following registration information has been submitted:BRBR BName:/B #Form.FirstName# #Form.LastName#BR BCompany:/B #Form.CompanyName#BR BAddress1:/B #Form.Address1#BR BAddress2:/B #Form.Address2#BR BEmail:/B #Form.EmailAddress#BR BPhone:/B #Form.Phone#BR BFax:/B #Form.Fax#BRBR If this is not correct or you need to make changes contact A HREF="mailto:[EMAIL PROTECTED]"Event Planner/A /CFMAIL Your registration for blahblahblah has been received -- we look forward to meeting you! -- First snippet processes fine and even makes it to the "Your reg has been received..." line. Any suggestions? -Mark Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Re. image sizes
There is a simple CF tag called CF_imagesize in the tag gallery which will return dimensions for GIFs and JPGs. Can't remember if it'll work for progressive JPGs though. Anyway, thought I'd mention it 'cos it's probably faster that a CFX if all you want to do is get the image size. Mark At 01:07 PM 3/25/2001, you wrote: Re. image sizes Thats a fair point Kay - we only use it for gifs. Think I'll try your tag out for jpgs. Are you sure CFX_Image came after CFX_GIFGD? Bill Davies www.web21st.net -Original Message- From: CF-Talk [mailto:[EMAIL PROTECTED]] Sent: 25 March 2001 12:25 To: [EMAIL PROTECTED] Subject: CF-Talk-list V1 #232 CF-Talk-list Sun, 25 Mar 2001 Volume 1 : Number 232 In this issue: cfx directory Re: cfx directory Re: Allaire Developers Conference? RE: cfx directory Re: image sizes RE: Reseller recomendations cfx_http tag available? Re: cfx directory Re: cfx directory Re: cfx_http tag available? Re: cfx_http tag available? munchkinlan -- Date: Sun, 25 Mar 2001 11:29:09 -0800 From: "nizam" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: cfx directory Message-ID: 005601c0b561$f2d6ea40$62c497ca@h9c3m9 Hi everybody, I'm using win98 and cf4.5.1...can I know where is the directory for cfx custom tags. I get error that say my cfx_http is not in my database. Why it's happen Thanks ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfscheduler weird thing...
Maybe I read the Allaire article wrong, but I assumed that if you want to use the method they suggest (calling the executable and passing it parameters), you would have to reference the physical path to the template you wanted to run, ie D:\Inetpub\wwwroot\directory\file.cfm. Yes, you would. With several servers and a range of sites on each, I assumed you'd have to set up the scheduling software on each machine that had a site for which you wanted to run a scheduled event (...if that made any sense whatsoever!). I dunno what you need to achieve, and maybe I'm not thinking straight (hey, it's now Monday morning and it's been a rough weekend), but I think you should be able to have all you scheduled tasks on one server and have those tasks make changes on the other servers. Scripts executed from a HTTP request should be able to make any changes to a server that are necessary, so a scheduled tasks running on one server should be able to remotely manage/update/whatever other servers. For example, I've just set up something to monitor the CF and SQL Server services on server A from server B. If server B finds a failure on A it runs an ASP script on A to stop and start the necessary services. And ditto about that Friday-feeling *uggh* I think I'm a midweek kinda person, Monday mornings are worse. At least on Fridays there's a weekend to look forward to. ;- Mark ~~ 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: cfscheduler weird thing...
coldfusion scheduling is notoriuosly unreliable. I've recreating these symptoms over and over, and followed various threads in the allaire forums about it, but never seen a straight answer. I suspect it's nothing to do with CF per se, that it's something set in windows somewhere which causes the cfscheduler not to work on some servers - but I've no idea where/what that setting is. (never tried using CFSCHEDULE on linux) If you want to be sure you're code will work, use the scheduling service built into the OS (NT 'at' or Linux 'cron'). There are some custom tags available to make using these as easy as using CFSCHEDULE. I think there is actually a CFX_SCHEDULE. Mark At 12:03 AM 3/23/2001, you wrote: I got a scheduler website where users can set some meeting and having a feature to be notified by email at a specific time. What i've do, is creating a new task with cfschedule to be executed one time at a specific date. Everything work fine except one thing : the cf server doesn't see my new task untill i edit/update it via cf panel. (so it's manually) Someone know why? My interval refresh is set to 5 minutes.. i've made some tests and was checking the schedule log files, and that's how i explain this trouble : i think there is something more under the cf automated task panel when editing a task that i doesn't have when using cfschedule tag.. any ideas? Daive [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: cfscheduler weird thing...
I've *never* managed to get a scheduled event to work and have to resort to other applications which trigger batch files to open a browser and pass it a URL as a parameter... pain! err, there's no need to do that. There is an executable you can use to process CFML templates via the command line. Have a look at: http://www.allaire.com/Handlers/index.cfm?ID=3328Method=Full Mark ~~ 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: template and thread...
I'm pretty sure it is in order, so variables you set in 1 are available in 2. Try that and see. At 01:17 PM 3/23/2001, you wrote: Hi, does anyone know that how template behavior? My question is: when I have a bunch of CFInclude template="../includes/1.cfm" CFInclude template="../includes/2.cfm" CFInclude template="../includes/3.cfm" .. .. CFInclude template="../includes/N.cfm" are the CF process in the 1/2/3 order? or they process everything ( 1/2/ ... N ) at the same time ? according to what I understand, it should be in order, but my page behavior funny, e.g. 3.cfm depends on the result of 1.cfm, sometimes it works, sometimes it tells me that the result is empty... Please confirm with me for that. Thank you. Mei ~~ 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: cfscheduler weird thing...
Are you sure this is the case, this seems very, very strange. I don't think I've ever needed to schedule a http request on Windows that connected to a port other than 80, but I have on linux without any difficulty. The problems I have experienced with CF scheduling are generally with the CFSCHEDULE tag, not ColdFusion scheduling in general. Scheduled tasks added using the administrator run fine while tasks added/updated using the tag simply don't run (though you can run scheduled tasks using CFSCHEDULE). Behaviour is not consistent, or I haven't done enough testing to determine a definite pattern, though if I recall correctly, restarting the server did result in the scheduled tasks set using CFSCHEUDLE running fine. I can't remember whether restarting the CF Executive or CF App Server services had the same result. To be honest I don't have time to beta test allaire's software. There have been complaints about CFSCHEDULE since v3, and it still doesn't work reliably, so I just don't use it. Mark At 01:04 PM 3/23/2001, you wrote: From past experience with CFSchedule, make sure the website/template that is being called (ie, http://mywebsite.com/check_this.cfm ) is not located on an non-standard port. Meaning the template should be able to be called from a normal HTTP Request. If it is behind an obscure port such as: http://mywebsite.com:8088/check_this.cfm This will not work. Hopefully this is addressed in CF 5.0 but not the case in 4.01 or 4.5 Hope this helps. Randy -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 7:31 AM To: CF-Talk Subject: RE: cfscheduler weird thing... coldfusion scheduling is notoriuosly unreliable. Does anyone know if this is going to be addressed in ColdFusion 5.0? I've *never* managed to get a scheduled event to work and have to resort to other applications which trigger batch files to open a browser and pass it a URL as a parameter... pain! -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 ~~ 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: cfscheduler weird thing...
At 03:22 PM 3/23/2001, you wrote: err, there's no need to do that. There is an executable you can use to process CFML templates via the command line. Have a look at: http://www.allaire.com/Handlers/index.cfm?ID=3328Method=Full Thanks. I don't want to sound ungrateful, but with several ColdFusion servers, presumably what they suggest would mean setting up an instance of the scheduled event software on each. Well, that depends on what your scheduled task does. To be honest I can't think of a situation where a scheduled task would do something which affects multiple servers which could not be achieved by running tasks on one server. Then again, it is Friday afternoon and my brain is concentrating on coming up with the fastest route to the pub through Dublin's nasty traffic jams. The way it is at the moment, there's a load of open IE windows when I get into work but at least all the scheduled events are managed from one place. -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 ~~ 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: Finding host from IP
you should be able to do this with the cfobject tag
At 11:13 AM 3/21/2001, you wrote:
Hi all
A question for the ASP-literate among you. We have some ASP code that looks
like this:
Set DNS = CreateObject("TCPIP.DNS")
Host = DNS.gethostbyip(request.servervariables("remote_addr"))
It seems to be doing a DNS lookup. Our production server does not run ASP.
Is there a way of doing the above but with ColdFusion?
TIA
Paul
---
Any opinions expressed in this message are those of the individual and not
necessarily the company. This message and any files transmitted with it
are confidential and solely for the use of the intended recipient. If you
are not the intended recipient or the person responsible for delivering to
the intended recipient, be advised that you have received this message in
error and that any use is strictly prohibited.
Sapphire Technologies Ltd
http://www.sapphire.net
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Text area question
I think this is what you are looking for (ideally, stick it in a custom tag for future use). cfset string = Replace(string, Chr(13) Chr(10) Chr(13) Chr(10), "p", "all") cfset string = Replace(string, Chr(13) Chr(10), "br", "all") cfset string = Replace(string, Chr(10) Chr(10), "p", "all") cfset string = Replace(string, Chr(10), "br", "all") cfset string = Replace(string, Chr(13) Chr(13), "p", "all") cfset string = Replace(string, Chr(13), "br", "all") cfoutput#string#/cfoutput At 10:10 AM 3/22/2001, you wrote: use paragraphformat() on the output, might get close to what you are after, it only does quite basic formatting, cr's and lf's only. -Original Message- From: Javed Mushtaq [mailto:[EMAIL PROTECTED]] Sent: 22 March 2001 09:18 To: CF-Talk Subject: Text area question Hi all, I have a text area on a page and need to save to a database and then output the information exactly as it appeared on the text area. How do i do this, could anyone send me the code as got to get this up and running by 10am today. Thanks in advance. ~~ 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: Can I tell if a browser is 128 bit with CF
ColdFusion won't do this for you, but you could make use of the Browserhawk COM component within your CFML. www.browserhawk.com At 12:30 PM 3/22/2001, you wrote: Hi all, Is it possible to determine if a clients browser is 128 or 40 bit with CF? Thanks James Milks Noncubicle Corporation www.noncubicle.com [EMAIL PROTECTED] (613) 560-9855 ~~ 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: maxlength of Tag.GeneratedContent?
I've never used this tag, nor have I ever required the use of the GeneratedContent property, but I suspect in this case it may be something to do with the retrieval of long text from a database using an ODBC datasource. The long text buffer size default to 65000 characters. Mark At 01:45 PM 3/22/2001, you wrote: I'm taking a look Xing Li's CacheThis custom tag which is really cool and works great. My problem isn't with the tag but with the .GeneratedContent property of all custom tags. It seems like this property has a maximum character length of 65k. Is this correct? Is there any way of getting around this limit? A setting in the administrator maybe? Thanks. Ric Smith ~~ 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: Locale
there is a setLocale() function, more info in the documentation. Mind you, I've never had to use it - I've just come across similar problems with VBScript ASP and SQL Server. Mark At 02:18 PM 3/20/2001, you wrote: I wasn't aware CF server has a Locale? u mean the box or the actual software? N ~~ 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: Using Session Variable
At 01:38 AM 3/21/2001, you wrote: Hallo, I want to use session variable in my coldfusion application. If my browser not support Cookie(disable cookie), can I use session variable without passing session variable in URL/form parameter? you need to make sure that every script on the server which requires the use of session variables can retrieve the CFID and CFToken variables which uniquely identifies the client. The easiest way is to use cookies, though you can pass the CFID and CFToken variables in the querystring or I guess form fields (though I've never tried the form fields method). ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Win2k
we have had CF problems on our win2000 server, which appear to be related to CFHTTP. ColdFusion service has hung on numerous occasions (i.e. service not actually stopped, just failing to reply to requests - though sometimes continuing to log). There seems to be two possibilities, which I will be looking into... CFHTTP is memory hungry and CF4.5 does not release memory once acquired, so it's possible that CF is simply running out of memory. I doubt very much that this is the case as the server has 1GB or RAM and the CF app server is not heavily used (the site is primarily developed in ASP), so peak memory requirements should not be too high (and therefore the max memory reserved by CF for it's own use should not be too high either). I've added performance counter logging anyway to see if this is causing the problems. The other possibility is that CF has some problem using the wininet.dll provided with 2000. I've never had these problems on NT4, on which CF copied a version of the wininet.dll into the coldfusion\bin directory, and the problems only started on the win2000 machine when a new application which heavily uses CFHTTP was installed. Since adding timeouts to all CFHTTP calls and tweaking some settings in the CF administrator (request timeouts, restart after blah failed requests etc.) and the services control panel it does seem to be pretty stable. I've also started logging every processed .cfm request (simple cffile operation in the sites application.cfm) and have adding monitoring from another server with notification via email and SMS, so I'm relatively happy to leave it alone until I have time to look into it in detail again. At least next time it falls over I'll know about it and I'll have some more logs to check to see if I can find out what the problem is. BTW, it is CF Pro that we are running. Mark At 03:31 PM 3/21/2001, you wrote: Anyone had any experience of Coldfusion (proffesional) running on a 2K server ? We're thinking of moving to that from NT4, and was wundering if there were any issues (speed, lag etc.) that would make this a Good Thing, or weather it all just gets rosy and faster ? Regards, Thomas Chiverton, Intranet Architect and Desktop Analyst Office: 01565 757 909 As a GUI, reality in useless... ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: [RE: To ASP or not to ASP]
what??? If you parse a script containing both ASP and CF code using the CF app server, you'll be able to see the ASP code in the HTML source - 'cos as far as CF is concerned, that's what it is. Same applies in reverse. At 03:40 PM 3/21/2001, you wrote: Why not take the best of both worlds and cerate templates that use CF and ASP!! Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Angél Stewart [mailto:[EMAIL PROTECTED]] Sent: 21 March 2001 15:24 To: CF-Talk Subject: RE: [RE: To ASP or not to ASP] Especially if they live in Trinidad where most IT firms don't even know what COld Fusion is :) -Gel www.carigamer.com -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Anyone who relies solely on CF for marketability is in trouble already. ~~ 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: passwrord protecting a page and hipping off to another
there are lots of ways of achieving this, but they depend on your setup. Where is the other page? Is it on the same server? If not, is it on a server which would be able to read a domain cookie set on the first page? Are both pages ColdFusion scripts? Where are the usernames and passwords stored (DB, file, WinNT users), or is there just one username and password? Mark At 12:20 PM 3/20/2001, you wrote: Hi all, I set up a page http://www.portcityportlandmaine.com/hobnobber/ where an id and password must be entered. The password and id are checked at a cfm page called by the form action. The issue is if the password and id are correct how can I ship them off to the appropriate page without the security being "compromised." I'm use to establishing some type of link to get a person to a page. In this instance I just want someone shipped off to the correct page if the password and id are correct. Are there any tutorials for this? Thanks, Greg ~~ 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: passwrord protecting a page Got it..THANKS!
if I understand you correctly, this leaves the URL you are getting with CFHTTP un-protected. At 12:49 PM 3/20/2001, you wrote: Thanks I think I'm all set. I'm using cfhttp METHOD=GET resolveurl="Yes" URL="http://www.blahblahblah"#CFHTTP.FileContent#/cfhttp inside and if then else. If the password and id (checked from an access database) are correct then the above tag is executed. This book I'm using "Mastering Cold Fusion 4.5" seems to answer all my questions but it's an issue of finding the correct sections. From the newbies, Greg -----Original Message- From: Mark Woods [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 7:38 AM To: CF-Talk Subject: Re: passwrord protecting a page and hipping off to another there are lots of ways of achieving this, but they depend on your setup. Where is the other page? Is it on the same server? If not, is it on a server which would be able to read a domain cookie set on the first page? Are both pages ColdFusion scripts? Where are the usernames and passwords stored (DB, file, WinNT users), or is there just one username and password? Mark At 12:20 PM 3/20/2001, you wrote: Hi all, I set up a page http://www.portcityportlandmaine.com/hobnobber/ where an id and password must be entered. The password and id are checked at a cfm page called by the form action. The issue is if the password and id are correct how can I ship them off to the appropriate page without the security being "compromised." I'm use to establishing some type of link to get a person to a page. In this instance I just want someone shipped off to the correct page if the password and id are correct. Are there any tutorials for this? Thanks, Greg ~~ 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: Locale
Have you set both CF and SQL server to use the same locale? At 12:24 PM 3/20/2001, you wrote: Anyone had any problems with settting a Locale? I am using SQL server and Although I have explicitly set it as UK it seems to be stuff in US? What other params so I need to check? ~~ 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
