Re: Macromedia.Com (The new site?)

2003-03-14 Thread Jochem van Dieten
Adrocknaphobia Jones wrote: > Totally different systems. Emails are sent to a server before being > pushed onto the client. At the server we can analyze the email, check > for macros, and run virus protection on all attachments. Flash > applications can be requested by any user and there is no serv

Re: Macromedia.Com (The new site?)

2003-03-14 Thread Jochem van Dieten
Adrocknaphobia Jones wrote: > 1. It's not a desktop application if it needs a network and server, > hence the term 'desktop' application. You can indeed access CFCs from > Flash, but exactly how does that get around needing HTML to make an API > call to the browser to get local disk access? Why wo

Re: Macromedia.Com (The new site?)

2003-03-14 Thread Jochem van Dieten
Adrocknaphobia Jones wrote: > Ok stop me if I'm wrong but this is my rationale. > > The browser, which is a trusted application, cannot access the file > system without direct command of the client. Sure it can. It won't, but it can. > The user has to actually > click the button to initiate. Be

Re: Macromedia.Com (The new site?)

2003-03-14 Thread Jochem van Dieten
Miller, Kevin wrote: > Actually, this one of the things that pure HTML can do rather well. Yes and no. With clean-cut HTML and stylesheets you can get pretty far with displaying content. But typically those are not what I would call applications, they are more websites as for instance email clie

Re: Macromedia.Com (The new site?)

2003-03-14 Thread Jochem van Dieten
Adrocknaphobia Jones wrote: > Right on, but I think you put my concerns into a better language. Where > an HTML document is open source data You think so? You haven't been in news.admin.net-abuse.sightings lately I presume :( > a SWF is executable code. It seems > much more threatening to give t

Re: occlude custom tag file ?

2003-03-15 Thread Jochem van Dieten
Jim Watkins wrote: > Is the following warning in my CF 5 Application log something to be > concerned about? > > "In a CF_TagName construct custom tag file > 'D:\cfusion\customtags\uicascadingmenu.cfm' will occlude custom tag file > 'D:\cfusion\customtags\componentkittags\uicascadingmenu.cfm'. " Y

Re: Newbe SQL question

2003-03-17 Thread Jochem van Dieten
Howie Hamlin wrote: > I have a basic MSSQL7 question - we have a table with no unique identifier (don't > ask - I didn't design it) where, on an insert, we want to update a record if it > exists and insert it if it doesn't. The record can be identified only by a > combination of columns. For e

Re: fetching the field type ?

2003-03-18 Thread Jochem van Dieten
paris lundis wrote: > Working with any database in CF is easy and most of us know where we can find the > field names of a fetched query - programmatically... > > Does anyone know off hand if it is possible to retrieve or otherwise determine the > field types that match the field names? (ie: te

Re: CFMX Updater 3 Released

2003-03-20 Thread Jochem van Dieten
Erika L. Walker-Arnold wrote: > > Seriously though, why antagonize us all day? > How hard can it possible be, that all day today, you guys couldn't > release a non-flash link to the updator? IIRC it has been documented somewhere on the site that Macromedia finds it important to know who download

Re: CFMX Updater 3 Released

2003-03-20 Thread Jochem van Dieten
Erika L. Walker-Arnold wrote: > Well that's a reasonable answer, thank you Jochem. ;) You work for them > now? ;) Work? I'll have to graduate first. >>>| > > > What does mean? http://www.antionline.com/jargon/AOL!.php Jochem

Re: Unique random number?

2003-03-23 Thread Jochem van Dieten
Philip Arnold wrote: >>CFTRANSACTION is one of ColdFusion's slickest features. >>Much easier than database-level transaction handling. > > Let's not forget that in a Clustered environment that CFTRANSACTION > won't stop transactions from the other servers... They do (if the transaction isolation

Re: Unique random number?

2003-03-23 Thread Jochem van Dieten
Philip Arnold wrote: >>They do (if the transaction isolation level warrants stopping >>other transactions). > > In other words, stops all other traffic of that type on the database > server... Now THAT's a way to kill a site That can be desired behaviour if the alternative is inconsistent data.

Re: Unique random number?

2003-03-23 Thread Jochem van Dieten
Philip Arnold wrote: > > My problem with it is that if you put 3-4 queries inside a CFTRANSACTION > instead of using one TSQL transaction, then it'll have to "deadlock" the > DB Server for it to handle the transaction properly Maybe for MS SQL Server, but databases that do "better than row level

Re: CFMX cannot handle charset for URL variables

2003-03-23 Thread Jochem van Dieten
Murat Demirci wrote: > I'm working on IIS. WFM http://cfmx.oli.tudelft.nl/url.cfm Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?met

Re: OT: css, dhtml question

2003-03-24 Thread Jochem van Dieten
Barney Boisvert wrote: > > +---+ > | | > +---+---+---+ > | | | | > | | | | > | | | | > | | | | > | | | | > +---+---+---+ > | | > +---+ > > The top 4 content areas all have variable conten

Re: CFMX cannot handle charset for URL variables

2003-03-24 Thread Jochem van Dieten
Murat Demirci wrote: > When I type a unicode string in the form field and submit the form, there is > no problem. However when I type the same unicode string in the address bar > the problem occurs. Similarly when I use > in a page the problem repeats. Most likely you are not using unicode in the

Re: Request for Review: "Variables in CFML

2003-03-25 Thread Jochem van Dieten
Jim Davis wrote: > Personally I use the Application scope for session data and roll my own > timeout simply to gain the ability for "end of session event" > processing. If you use J2EE sessions you can create a listener in Java that listens for end of session events and acts on them. Although I a

Re: CFMX cannot handle charset for URL variables

2003-03-25 Thread Jochem van Dieten
Murat Demirci wrote: > I'm IE 6 with SP 1 and the option "Send URL strings as unicode" is checked. What do the URLEncoded query_strings look like? Both in the case it works and the case it doesn't work. Jochem ~| Archives: http

Re: Page break in report

2003-03-25 Thread Jochem van Dieten
Candace Cottrell wrote: > Put this at the top of the page in your > > > P.pageEnd {page-break-before: always} > May I recommend: p.pageEnd {page-break-before: always} The default media-type for CSS is "screen", so without specification it should not work for printed media. Also, in xhtml

Re: CFMX cannot handle charset for URL variables

2003-03-25 Thread Jochem van Dieten
Murat Demirci wrote: > If you ask what query_string causes the problem, the answer "a??g?". > (Cf-talk list server doesn't allow non-ASCII characters) It does allow them, it just doesn't preserve the charset in the email headers (any progress on that Michael?). But how does the URLEncoded string

Re: OT: Flash detector

2003-03-27 Thread Jochem van Dieten
Phillip B wrote: > A friend wanted me to see if anyone here had a bullet proof flash detection script. There is no such thing as bulletproof, but I like the technique explained at http://alistapart.com/stories/flashsatay/ Jochem ~~

Re: DB Driven Collapsable Tree

2003-03-27 Thread Jochem van Dieten
Cedric Villat wrote: > It has to work on IE and NS4. Any ideas? Talk yourt boss out of supporting NS4, it is obsolete. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.house

Re: SOT: Flash Communication Server MX 1.5 now available

2003-03-28 Thread Jochem van Dieten
Tilbrook, Peter wrote: > > No word on an upgrade for users of version 1.0 (which we only received last > week!). http://www.macromedia.com/software/flashcom/productinfo/faq/#1_17 Jochem ~| Archives: http://www.houseoffusion.com

Re: Address standardization

2003-03-29 Thread Jochem van Dieten
Andres wrote: > > Has anyone ever had to do any type of address standardization for data entry in > their web sites? You might want to check your national standards body, they might have an official standard. Else, try your national postal service. Jochem ~

Re: DevCon 2003

2003-03-29 Thread Jochem van Dieten
Paul Kenney wrote: > I too have heard that San Diego is no longer going to happen. Too bad. It > might be nice for a change to ackowledge us on the west coast. What are you complaining about? At least for you it is still on the same continent. Jochem ~~

Re: white space

2003-03-30 Thread Jochem van Dieten
Michael T. Tangorre wrote: > when viewing the source of the pages within some of my cf apps, i notice > there is a lot of white space at the top of the page, etc... is there a way > to clean this up? Many people use or something just before their doctype/XML declaration. If you do so, adding re

Re: white space

2003-03-30 Thread Jochem van Dieten
S. Isaac Dealey wrote: > >>Many people use or something >>just before their doctype/XML declaration. If you do so, >>adding >>reset="yes" makes sure that everything before that tag is >>discarded. > > I'd be wary of using this approach ... I'd be suspect of possible issues if > you need to use

Re: white space

2003-03-30 Thread Jochem van Dieten
S. Isaac Dealey wrote: > > Oh okay, good to know ... hmmm... I guess you have to move to another file / > directory if you want to push something other than text content with > cfcontent tho... ?? Jochem ~| Archives: http://www

Re: white space

2003-03-31 Thread Jochem van Dieten
S. Isaac Dealey wrote: > > You were recommending using before the doctype declaration to > eliminate white space before the beginning of the content. Doesn't that > preclude using further down the page to deliver another kind of > file or document like a zip archive? No. Jochem ~~

Re: CF Temp files in \WINNT?

2003-03-31 Thread Jochem van Dieten
Reed Powell wrote: > Hello all - I've noticed that there is a ton (about 300mb worth) of files in > the WINNT directory with names of the format CFI*.tmp. Can these be from > Cold Fusion? This particular system is running CF 4.5. Check the ownership (you are running CF under its own account righ

Re: CF based blogging software

2003-04-01 Thread Jochem van Dieten
Michael Dinowitz wrote: > Has there been any movement on this front? I found Fuseblog but can't see any > > way to download it. I'd rather use a CF based blogging system than not and if I > > wait to write my own it'll take almost forever. BlogMX, http://www.benorama.com/ Jochem ~~

Re: SOT: Microsoft Windows Server 2003 has been released

2003-04-01 Thread Jochem van Dieten
Tilbrook, Peter wrote: > > NB: no update on whether MM supports W2003 yet. Is there a certified JRE already then? Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffu

Re: Learned something today (Oracle)

2003-04-03 Thread Jochem van Dieten
Buckland, Ramon wrote: > > My guess is that there is an index on the orderno field > but it is a 'varchar' index (as it should be) > > because the string you are comparing to is an int, it's > probably converting each orderno to int and comparing that way. > (I would think the opposite though) >

Re: How can I "ORDER BY RANDOM" ?

2003-04-04 Thread Jochem van Dieten
Tom Forbes wrote: > > I need to modify the below query so that my results are still ordered by > "ClassOfService" (a number between 1 and 4) - BUT, the "CompanyName" needs > to be displayed in a RANDOM ORDER each time the query is run, rather than > its current alphabetical order. This will giv

Re: CF Community recommendations?

2003-04-04 Thread Jochem van Dieten
Paul Campano wrote: > I am looking to build a community website for my apartment building of almost 200 > units. I would like to have a members area with forums, the ability to add "news" > stories and other community functions. Could someone recommend a free or low cost > solution? I am doi

Re: Hiding JavaScript codes

2003-04-04 Thread Jochem van Dieten
Costas Piliotis wrote: > > The only way for one to do this is if they know how to pass their own http > headers. And then they need to know that you're looking at that particular > cgi variable, and they need to know what you're comparing to as well. Too > much trouble for a little piece of java

Re: CF Community recommendations?

2003-04-04 Thread Jochem van Dieten
Matt Robertson wrote: > If his use doesn't qualify for their free personal edition, then that > will cost at least US$995. The way I read the license and his requirements he qualifies. > My CMPro cms is US$350. One of my customers > is a private dormitory at UC Berkeley Berkeley? As in BSD? A

Re: Looped Error (Or Something Like That)

2003-04-05 Thread Jochem van Dieten
Jamie Jackson wrote: > I've got two replicated databases that I'm doing app-side failover for > in my CFMX app. The gist of my problem is: I've got some catch blocks > which send failure notices to the DB admins. However, when I'm testing > (stopping the DBs), for a single page request in which th

Re: Back with more looping

2003-04-05 Thread Jochem van Dieten
Don't make the explicit distiction between a multiform and a singleform, the singleform *is* the multiform with i=1. Some more comments are inline. Form page: Action page:

Re: Back with more looping

2003-04-05 Thread Jochem van Dieten
Jochem van Dieten wrote: I missed part of the rewrite: > Action page: > > > > > > #form.??# > >

Re: Back with more looping ~~SOLVED~~thanks list

2003-04-05 Thread Jochem van Dieten
Candace Cottrell wrote: > > __ On the action page, you have > > > > What are you checking for? That there is a length? I am checking that the form field is not empty or just has spaces. It is pretty much equivalent to the code below, I just prefer the syntax. > __ > > I tried this, bu

Re: CF not committing transactions?

2003-06-05 Thread Jochem van Dieten
Dave Jones wrote: > > All of our inserts and updates to this database are wrapped in > tags (due to multiple tables > involved in the transactions). We are not explicitly issuing any > commits or rollbacks. > > My questions are: > 1) Given our use of , is it possible that CF is > leaving tra

Re: xml parsing

2003-06-05 Thread Jochem van Dieten
Critz wrote: > > using cfmx, I am trying to parse this feed: > http://www.bmezine.com/newsfeed/bmenews.rss > > but i keep getting errors. Anyone mind having a quick gander? Download Mozilla (http://www.mozilla.org/), install the Checky toolbar (http://checky.mozdev.org/) and you have a fe

Re: java.io error - infozip

2003-06-05 Thread Jochem van Dieten
Scott Mulholland wrote: > I am using the infozip command line utilities (zip.exe, unzip.exe) to do > some zipping and unzipping of files. The zip.exe does not seem to run > when trying to zip files in certain directories and throws the following > error: > > java.io.IOException: CreateProcess:

Re: xml parsing

2003-06-05 Thread Jochem van Dieten
Sean A Corfield wrote: > Shannon's put an RSS feed on his site? That's awesome - I must > subscribe to it! (Once he's fixed those darn & links!!! :) > > It's interesting to see how RSS is cropping up on non-IT / non-news > sites. Anyone got other interesting examples? University library here h

Re: force a download [was: SQL concat]

2003-06-05 Thread Jochem van Dieten
Fetter, Brad wrote: > > I have video, and image library on our intranet and we want to have a > hyperlink that will allow the > user to download the file to their hard drive without having right click and > select file save as. Is there an easy way to do this? Use cfcontent with the mime type "ap

Re: DateDiff Question (James Blaha)

2003-06-06 Thread Jochem van Dieten
James Blaha wrote: > > Is below the best and only way to easily find out how many days are > between 2 dates? Im writing a template for a file backup where files > that are older then 5 day will be deleted and Im not sure what the > easiest best practice approach would be for the days check.

Re: DateDiff Question (James Blaha)

2003-06-06 Thread Jochem van Dieten
James Blaha wrote: > > Thanks a million! Does the date format have to be in the -mm-dd format? It doesn't have to be. But you wrote "6/3/03", and I wouldn't know what date that is. I presume the "03" means 2003, but how about the rest? Is that March 6 or June 3? Do you know? Does the next d

Re: Stored Proc Question Help Please

2003-06-06 Thread Jochem van Dieten
Eric Creese wrote: > This is a very simple question. > > I need to do this in SQL Server from a job not a CF page. > > I have a table where I store customer IDs. I want to pull the individual IDs and > loop each ID out of the table and run it against another query and write that output > of th

Re: Using

2003-06-06 Thread Jochem van Dieten
Bushy wrote: > > If I run this command on the server at a command prompt it works just fine. > > C:\>net print \\SERVERNAME\TESTPRN > > > Name Job # SizeStatus > > --- > testprn

Re: force a download

2003-06-06 Thread Jochem van Dieten
Fetter, Brad wrote: > Hmmm, I tryed to force a download of a jpg file with the following code and > browser tried to open the cfm page in Coldfusion Studio... Is there another > way to force a download? Maybe through a Metatage or Javascript? You need to add a header for the filename: Jochem

Re: Using

2003-06-06 Thread Jochem van Dieten
Jochem van Dieten wrote: > > > > > arguments="testprn" >outputFile ="prn.log" >timeOut="60"> > > > > #queue# Sorry, that should be without the outputFile argument. Jochem ~

Re: Using

2003-06-06 Thread Jochem van Dieten
Bushy wrote: > Where do I put the "print" and \\SERVERNAME\PRINTERNAME\ for > > c:\winnt\system32\net.exe print \\SERVERNAME\PRINTERNAME If servername is not the local server, you need to make sure CF runs under a domain account, not the localsystem account. Then use: #queue# Jo

Re: CF not committing transactions?

2003-06-06 Thread Jochem van Dieten
Dave Jones wrote: > > Thanks for the reply. Can I assume that if the isolation level is > not explicitly stated in the tag, the isolation > level defaults to the default setting of the SQL Server (i.e. CF > does not automatically impose a default isolation level)? I always assume so :-) Joch

Re: file conversion

2003-06-06 Thread Jochem van Dieten
Dana Tierney wrote: > Is there a relatively low tech way of converting flat files delimited with > | into a mysql database? I am on a different host now and have cold fusion > asp perl and maybe php available. http://www.mysql.com/doc/en/LOAD_DATA.html Jochem

Re: OT: Mozilla Firebird

2003-06-06 Thread Jochem van Dieten
David Collie (itndac) wrote: > > As usual checking out what the guru's are talking about... downloaded > Mozilla Firebird guess what. doesn't work on our internal > network...(altho works on all our pages before the proxy/firewall) What is the error message? > Not very good does

Re: GET/POST, forms and query strings...

2003-06-06 Thread Jochem van Dieten
Calvin Ward wrote: > > What are the advantages and/or disadvantages of using mixed methods when > submitting a form? > > In otherwords, would doing the following be considered good, bad, or > indifferent, and if not indifferent, why? > > > > > It can be good, bad or indifferent, depend

Re: OT: IE has now reached 96 percent market share

2002-08-29 Thread Jochem van Dieten
Sean A Corfield wrote: > > AOL currently uses an IE clone (and has been since IE3.2 I believe, which > replaced the dreadful IWENG-16 16-bit browser). But AOL will change to use > NS in due course - which will definitely shift the statistics away from IE. AOL for Mac OS X has already switched

Re: Need to purchase CF5 Upgrade License

2002-08-29 Thread Jochem van Dieten
Tracy Bost wrote: > Anyone aware of any the re-sellers still sell/have in stock any CF 5 > upgrades ? > > Would rather purchase from an authorized re-seller than buy from ebay. > > > p.s. if anyone would recommend a direct upgrade from 4.0 to mx on for a well > used live production box, i m

Re: find mdb

2002-08-29 Thread Jochem van Dieten
Jeremy Ball wrote: > How would I find the path to an Access mdb file? I know the datasource name but I >can't find that *&$*#& file! Registry. HKLM\Software\ODBC I think. Jochem __ Your ad could be here. Monies from ads go to

Re: Question: Where is the area on MM comparable to the Allaire Knowledgebase?? looking for cfcontent reference

2002-08-29 Thread Jochem van Dieten
Bonnie E. Betts wrote: > > I'm trying to search for some details on using CFCONTENT. Where's the >knowledgebase!??? Integrated with the rest of the site I presume. That means it is no longer available as a collection, but if you search for specific articles they will show up. > I went to

Re: Cold Fusion MX & Flash MX Applications

2002-08-29 Thread Jochem van Dieten
Haggerty, Mike wrote: > I would hate to be visually impared and try to find anything on the site you > are describing... That is something I have always wondered about. Why does everybody associate Flash with being difficult for the visually impaired? Isn't it just a matter of adding the spoken

Re: Question: Where is the area on MM comparable to the Allaire Knowledgebase?? looking for cfcontent reference

2002-08-30 Thread Jochem van Dieten
Bonnie E. Betts wrote: > Thanks Todd. Still can't seem to find the details though. I'm wondering if > there is a generic file type for say images that will cover all jpgs or gifs > or will I have to do a test for both. I'm really dreading the video and > audio formats if there's no generic vide

Re: find mdb

2002-08-30 Thread Jochem van Dieten
Jeremy Ball wrote: > I left out a couple of key bits of information: > > 1) I don't have access to CF Admin > 2) I can't RDS in; only FTP > 3) I don't have access to the registry You could try to query MSysObjects, get all the tables from there and then dump all the tables, but that would truly

Re: Help with cfcontent

2002-08-30 Thread Jochem van Dieten
Bonnie E. Betts wrote: > > I don't see a filetype for an MS Access file or for a PowerPoint file. Folder options, File types has a nice list. Registry has a nice list too. (More details are in the archives.) I know that the one for Access is application/msaccess, but you will have to look up t

Re: Question about url's in emails

2002-08-30 Thread Jochem van Dieten
Everett, Al wrote: > Many mail clients will handle long URLs if you put them in angle brackets: > > user&black=white&abc=123> Receiving email clients will, as long as the sending email client doesn't wrap them. Yours

Re: Standard SQL to get a Table List ?

2002-08-30 Thread Jochem van Dieten
Stacy Young wrote: > Is this specific to each vendor? (accessing system tables or what not) > Anyway to do this with standard SQL ? No. The SQL standard only specifies this should be possible, not how it should be possible. You might get somewhere with the schema properties that a JDBC driver i

Re: (Admin) OT Threads

2002-08-30 Thread Jochem van Dieten
Mark W. Breneman wrote: > >First off, thanks for all of the time and work you put into this list. > >Second, what about a "vote OT" link at the bottom of each message? After >about 20 or so votes a message would moved to CF-Community? Sort of a way >that we can help you manage this list. That w

Re: Nth Record Subset

2002-09-01 Thread Jochem van Dieten
Jim Gurfein wrote: > Hi List, > > All you gurus out there... I'm trying to find a way to select every nth > record from a database that has 200,000 records. How would I go about > setting up the SQL to select every 15th record ? If you have some consecutive number use the MOD operator in your

Re: Security test for shared server environments

2002-09-01 Thread Jochem van Dieten
Gyrus wrote: > We've just set up as resellers with a new host, and we're on a 30-day trial > period, during which we hope to fully guage the stability and security of > the environment. > > Do any of you have a standard set of CF test for checking out the security > of a shared hosting environmen

Re: Nth Record Subset

2002-09-01 Thread Jochem van Dieten
S. Isaac Dealey wrote: > >>If you have some consecutive number use the MOD operator >>in your WHERE. > > This might work provided there's never a problem inserting a record with an > autonumber field in at least MS SQL Server ( a failed insert still chews up > a record number ), and have never d

Re: Nth Record Selection Set

2002-09-01 Thread Jochem van Dieten
Jesse Houwing wrote: > > In MySQL, PostgreSQL and such: > > SELECT * FROM table LIMIT startrow, numberofrows > > so the 15000th item en the 15 following it would be: > > SELECT * FROM table LIMIT 15000, 15 Deprecated syntax for PostgreSQL. Use LIMIT ... OFFSET ... instead. SELECT * FROM tabl

Re: Nth Record Selection Set

2002-09-01 Thread Jochem van Dieten
Matthew Friedman wrote: > is there a limit function ins SQL Server 2000? No/yes. Look up TOP, but in order to create an offset you need to use it twice. Pseudo SQL: SELECT TOP 15 * FROM ( SELECT TOP 15015 * FROM table1 ORDER BY id DESC ) table2 ORDER BY id ASC J

Re: CFMX q's.......

2002-09-02 Thread Jochem van Dieten
Andy Ewings wrote: > 2 questions: > > 1. Can you store query resultsets in session vars? > 1. Do you have to lock session vars in CFMX? > > I am pretty sure the answer to 1. is yes but cannot remember the answer to > 2. I don't see a question 2 :) Yes, you can store queries in session varia

Re: CFC theory

2002-09-02 Thread Jochem van Dieten
Pete Freitag wrote: > > I think the this scope was a poor name choice, I would expect the this > keyword to point to, or reference my object as it does in C++ or Java. I'm > not saying that CFC's should be exactly like Java or C++ classes, but it > would have led to less confusion if "this" was n

Re: cfqueryparam and scrubbing form inputs

2002-09-03 Thread Jochem van Dieten
Matt Robertson wrote: > In the past I've used the CodeCleaner custom tag to scrub form inputs. > Recently I've expanded my use of CFQUERYPARAM to include values in SQL > UPDATE and INSERT statements, rather than just for the WHERE clause. > > Does cfqueryparam eliminate the need to scrub the code

Re: Why use cfqueryparam on data inputs? WAS: cfqueryparam and scrubbing form inputs

2002-09-03 Thread Jochem van Dieten
Matt Robertson wrote: > Dave, > > The results seen in the previous thread bring up a question: why use > cfqueryparam at all on form inputs that are not used in a WHERE clause, > especially when a good input scrubber is already in use? > > I can already see one answer: cfsqltype=cf_sql_numeric w

cfqueryparam, prepared statements, SQL injection and execution time

2002-09-03 Thread Jochem van Dieten
Since there appears to be some debate on what cfqueryparam exactly does, how it does that and what that means I prepared some example. Let's consider the following: CREATE TABLE tbl_test (testID INT, testText VARCHAR(100)); string = "normal string" INSERT INTO tbl_test (testID, testText) VALUES

Re: Page cannot be displayed

2002-09-03 Thread Jochem van Dieten
Bryan Stevenson wrote: > Matt, > > Thanks for that security change info. It was set to Medium (pooled) which > is the default setting. > > Do any IIS gurus care to comment on this anomaly? Is it bad to set it to > "Low (IIS process)"? Compared to getting a HTTP 500 you mean? :) Since CF only

Re: problem

2002-09-03 Thread Jochem van Dieten
Web Master wrote: > Well, it's pretty straightforward: > > arguments="-run client_file.lis"> > First try: If that fails: If that fails: is d: a mapped drive or is it local? Jochem __ This list and all House of

Re: Securing CF Server

2002-09-05 Thread Jochem van Dieten
Jas Panesar wrote: > Hi, > > I am currently moving from custom hosting a few trusted and specialized > sites on my servers. I am contemplating opening things up to allow some > more hosting to occur on the boxes, but the issue I have come up with, > and very little time to research is: Very

Re: Dreamweaver MX opinions

2002-09-05 Thread Jochem van Dieten
Bryan Stevenson wrote: > For me the one glaring issue with DW MX is it's slw. So even > after the learning curve it slows me down..SLS (still lovin studio) ;-) Disable your virus scanner for the DW MX install dir (if you dare). It is all those pesky little files that really make

Re: CF-Postgresql experiences

2002-09-06 Thread Jochem van Dieten
YC Nyon wrote: > I'm wondering if anyone mind sharing their experiences in connecting CF and > Postgresql(cygwin) on Windows platform. > Stability, speed and connectivity issues are the focus. Due to the Cygwin compatibilty layer the performance is clearly less as under the *nix of your choice.

Disturbing trends

2002-09-06 Thread Jochem van Dieten
When browsing through my cf-community folder I discovered a disturbing trend: more and more messages appear to be off-topic. People with Oracle, ASP vs. CF, cfregistry, CF and Java problems seem to believe this list is the appropriate channel to ask for help. With all these messages, the signa

Re: Disturbing trends

2002-09-06 Thread Jochem van Dieten
Sorry, sorry, sorry, this was supposed to got to cf-community. Jochem __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfus

Re: Forcing Output to a specified amount of space

2002-09-06 Thread Jochem van Dieten
Quoting Les Mizzell <[EMAIL PROTECTED]>: > I'm trying to force output to contain a specific number of > characters, or be > padded with spaces to equal the number of needed characters. I was > under the > impression that the following (from a previous response to this > question): > > > 1

Re: CF + DATABASE + Unicode?

2002-09-06 Thread Jochem van Dieten
Roberts Freimuts wrote: > > Does anyone out there use CF to pass Unicode to HTML? > How do you do it? > What database do you use? CF5: forget it. CF MX: - the big iron databases work. - free open source category: - PostgreSQL works (use it myself) - SAPdb works, - FireBird should

Re: CF + DATABASE + Unicode?

2002-09-06 Thread Jochem van Dieten
DmitryM wrote: > I've been looking for a long time to solve the same problem and I found > official statement of MM oficial that Microsoft Acceess doesn't have UNICODE > support. Access suports unicode (as of version 2000 I think). It is just that MS does not want to make JDBC drivers for it. Mu

Re: Interesting: Macromedia Resource Kit

2002-09-06 Thread Jochem van Dieten
Mike Chambers wrote: > matt, > > would you be willing to download 650 megs? Not being sarcastic, but that > is the main reason we did not make it downloadable. The other way around. There are no books so I don't see why one would even bother making a CD before it arrives at the customer. Of cou

Re: CF + DATABASE + Unicode?

2002-09-06 Thread Jochem van Dieten
Paul Hastings wrote: >> - PostgreSQL works (use it myself) > > and the native windows version? Native windows is beta. Use *nix. Jochem __ Signup for the Fusion Authority news alert and keep up with the latest news in Col

Re: CFObject in CFMX (Connection String)

2002-09-08 Thread Jochem van Dieten
Joe Eugene wrote: > It looks like "connectstring" and some other params of query are > deprecated in CFMX.. so how do you go about doing a DNS-less connection in > CFMX? Depends what you want. I'm not sure if you can get it as dynamic as with CF 5. But in many cases it is sufficient to just be a

RE: CFMX - relationship between IIS and JRun

2002-09-09 Thread Jochem van Dieten
Quoting Dave Watts <[EMAIL PROTECTED]>: > > Also, CF MX for JRun hasn't been released yet, It has:http://www.macromedia.com/macromedia/proom/pr/2002/cfmx_j2ee.html > I don't think. You should try it once, it is fun :) Jochem ___

Re: ODBC and CFMX

2002-09-09 Thread Jochem van Dieten
Quoting Frank Mamone <[EMAIL PROTECTED]>: > Hi, > > Everytime I re-start CF services the DSN's no longer work. I need to > go into edit mode with each one and re-submit to make them work. > Recreating doesn't help either. I'm thinking there's something wrong > with the datasource xml file and ma

Re: cflocation vs. server side redirect.

2002-09-09 Thread Jochem van Dieten
Bryan Love wrote: > server side redirects allow the use of cookies since the page is processed > by the browser. Cflocations are faster since the relocation happens at the > server and does not have to go to the browser and back again (which is why > cookies don't work with cflocation by the way)

Re: cflocation vs. server side redirect.

2002-09-09 Thread Jochem van Dieten
Bryan Love wrote: > > This is my understanding: > Of course something is sent to the browser, but AFTER the cflocation > happens. Say for example you have page1, page2, and page3. Page1 is a > form, page2 processes the form, and page3 is a thank you page. > > Server side (cflocation): > - user

Re: cflocation vs. server side redirect.

2002-09-09 Thread Jochem van Dieten
Dave Watts wrote: > > When you use the CFLOCATION tag, the server sends back a Location header. > The browser doesn't display the page which contains the Location header, but > it does receive it. It then requests the URL specified in the Location > header. So, using your step-by-step approach, h

Re: question for MM: CFMX sandboxing security holes?

2002-09-10 Thread Jochem van Dieten
Gyrus wrote: > Could I get an official line from Macromedia on this? Probably not here. > We're being told by a potential host that they are only offering CF 5 with > CFFILE etc. enabled in a shared environment, secured through sandboxing, > because they've been advised that the sandboxing secu

Re: CFMX unicode problem

2002-09-10 Thread Jochem van Dieten
Marius Milosav wrote: > > I really hope that somebody can shed some light with this issue (Hint, hint > Macromedia) I doubt you will see something from Macromedia here. Maybe from Macromedia employees, but that is not the same. > We have one application that was fully translated in Korean (us

Re: Developer Platform suggestions was Re: Nice

2002-09-10 Thread Jochem van Dieten
Dick Applebaum wrote: > Ya' know, it gets pretty old... I am beginning to accept the fact that > as a Mac/CF developer, I will always be a second-class citizen, and not > have equal resources with the competition. > > So, I am open to suggestions: > > If you could chose a platform today, with

Re: CF encrypt() and SQL

2002-09-10 Thread Jochem van Dieten
Willy Ray wrote: > Ok here's what's going on: > > I'm using the encrypt() function to encrypt data as it goes into my > database. > > Like this: > > > UPDATE mytable > SET myvalue= '#encrypt("#FORM.myvalue#","mykey")#' > WHERE id = #FORM.id" > > > Some of you probably already know what my pr

<    3   4   5   6   7   8   9   10   11   12   >