Re: Randomizing Query Results

David Jones wrote: > What is the best way to randomize the results of a CF query? Offload it to the database: SELECT * FROMtable ORDER BYRandom() Jochem ~| Archives: http://www.houseoffusion.com/cf_

Re: CF execute HELP

Terry Troxel wrote: > > The reason I am doing this is my financial package (MAS90) uses > illegal characters in its database table naming that Access can handle, > but not CF. How about: SELECT [illegal ##$@* name] AS allowed_fieldname FROM [illegal ##$@* name] allowed_tablename Jochem ~~~

Re: CFMX - I've never seen anything so unstable in my life

Rob Rohan wrote: > > We are having issues with the JDBC Drivers as well. We have several messages > into smack-romedia, and we will post when we hear. Why not ask Microsoft? Macromedia has made sure that CF MX can use JDBC, so now it is up to the database vendors to provide working JDBC drivers

RE: CFMX - I've never seen anything so unstable in my life

Quoting Dave Wilson <[EMAIL PROTECTED]>: > > The datasource is set up correctly as it was working fine for a few > days and nothing has changed. I can no longer access the CF > Administrator and don't know of any other way of editing JDBC > settings on my win2k machine. Use the coldfusion.server

RE: CFMX - I've never seen anything so unstable in my life

Quoting Dave Wilson <[EMAIL PROTECTED]>: > > However I'm getting a Runtime Exception from that link Oeps. The database is running on an experimental machine and I was upgrading it. Try again. Jochem ~| Archives: http://www.hou

Re: LONG time CF Supporter - About ready to dump CF!

Lee Fuller wrote: > Yup... And (per my post) they've asked for support $ to figure it out. Don't worry about that too much. You will only be charged if it is your problem (and even then the amount is fairly reasonable), not if it is a bug. I have opened my share of incidents, but I have never h

Re: Randomizing Query Results

David Jones wrote: > What database does this work on? At least on PostgreSQL. > I should have specified what database I am > using. I am developing for Oracle 8i. I presume you mean it doesn't work ;) You could try; SELECT * FROM ( SELECT *, Random() AS sortfield F

Re: SQL question

Thane Sherrington wrote: > Is there a way to use a Select query to get just the month out of a date in > a SQL query? I have a database that has a date field in it (so 04-10-02) > and I want to select all the records from a specific month. To get a different month, change the number: SELECT *

Re: More Aggravation RE: Very unsatisfied with Macromedia's support attention ...

Ezine wrote: > > Macromedia is doing beta testing now of the next updater.. Code named Red > Sky. I'm looking forward to see if it will fix my issue. Why not join the beta? Then you can make sure it is fixed. Jochem ~| Archiv

Re: Very unsatisfied with Macromedia's support attention ...

Dave Lyons wrote: > > I understand its not your fault either but just seeing how the server only > had an ancient video card would lead me to believe that the host is > seriously cutting corners and if I was you I'd be very concerned about that. Not installing any video drivers except for the def

Re: Very unsatisfied with Macromedia's support attention ...

Doug White wrote: > > If a software author can add that error trap into his installer package for > software selling for less that $100.00 US, then why cannot MM do exactly the > same with the InstallShield package for CFMX which sells for many thousands of > US dollars?? CF MX U3 uses InstallAny

Re: Where DO you put beta software?

Mike Kear wrote: > "Never put Beta software on production machines" > > "Never put beta software on critical machines" > > "Never put beta software on machines doing live projects". > > Well that covers all the machines in my business.Where do the rest of > you put beta software? Surely yo

Re: Very unsatisfied with Macromedia's support attention ...

Jerry Johnson wrote: [EMAIL PROTECTED] 06/06/03 05:16PM >>> >> >>they didn't tell anyone you had to have more than 16 colours on the graphic card to >>install >>UD3 and now it is broken. > > > If you were writing software, would it even occur to you to test on a 16 color > graphics card?

Re: Very unsatisfied with Macromedia's support attention ...

Dave Lyons wrote: > hard to disagree with what you say jochem cause ur always right. Thank you for the compliment. But you know, in investment this would be the time to start doing the opposite from what I am saying, because you should never go with the herd :-) > But it brings up two points (

Re: Very unsatisfied with Macromedia's support attention ...

Doug White wrote: > > I am not proud. I will give someone remote access to my box with full admin > privileges and let them try to install the updater. If you run 16 colors, it is not going to work. If you run 256 colors, you can set up pcAnywhere to allow connections from 145.94.154.26 You mig

Re: remote installation - WAS Very unsatisfied with Macromedia's support attention ...

Ken Wilson wrote: > So all this time the OS that Mike's folks were having trouble installing to > was Windows 2003? Mike was not the only one having install problems, Doug has had his share too. Jochem ~| Archives: http://www.

Re: Limit datasouce connections?

Blood Python wrote: > I'm using CFMX updater 3, iis5, 512mb ram and mysql 4.0.13. > > Should i limit the connections to the datasource in CFMX? Yes, but it does not work in currently released versions of CF MX. I don't know if it is fixed in the RedSky beta, but you should be able to test that

Re: math question (is a matrix possible?)

Tony Weeg wrote: > > if any of the payments need to be ammended, removed for bad check > reasons, chargeback on a card, operator error, then i need to be able to > go back in the payment history, and make a change that follows the > payment application rules. what i am trying to stay away from are

Re: getRunTime()

jon hall wrote: > Is there a way to shut off the new restrictions, or perhaps work > around it? It will work if you are logged in to the CF Administrator. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?foru

Re: OT: Control Panel for hosting?

Troy Montour wrote: > > was wondering if anyone has written or knows of a good Control panel for IIS web > server > as I want to allow users to change some of there own settings when hosting there > site > with me but I haven't been able to find one that is already written. Which settings wou

Re: getRunTime()

Josh Trefethen wrote: > Yep, I can access it with Updater 2. Any chance you can send me (offlist) a dump of the SecurityService from your CF MX install? I am seeing several entries on a machine with Updater 3 it that I don't remember from when I worked with it before, and which appear to contr

Re: getRunTime()

jon hall wrote: > Ahah! Now to figure out the mechanism Create a subdirectory under /cfide/administrator and don't put in an Application.cfm. Not recommended for production use :-) Jochem ~| Archives: http://www.houseoffus

New/revised security bulletins: MS03-007, MS03-013, MS03-018 and MS03-019

FYI and have fun. Jochem > === > Title: Unchecked Buffer In Windows Component Could Cause > Server Compromise (815021) > Released: 17 Mar 2003 > Revised:28 May 2003 (version 3.0) > Software: Micr

Re: all records deleted from table

[EMAIL PROTECTED] wrote: > Does variable and CFQueryParam checking also apply to Access databases? Is it > needed when using MS Access 2000 as a backend? Yes. I am not sure whether you get the performance improvements with Access, but cfqueryparam is still a protection against SQL Injection A

Re: CFFILE Problem

Venable, John wrote: > as i was saying... > I have a template that allows one of our folks to upload a word .doc to a > given directory. I have been experiencing a strange error lately. > > i get this error when it's run by this person: > > The MIME type of the uploaded file (application/octet-s

Re: CFMX and local SQL Server

Brad Peloquin wrote: > Hi, so I select "data sources" from the "Data & Services" in order to define > a MS SQL server database that is running on my PC, and I get the following > error: > > = > Element SQLEXECUTIVE is undefined in REQ

Re: OT: SQL--Recursive Query Question

Terry Hogan wrote: > > CategoryID ParentIDLevel CategoryName > -- - > 1 0 1 Animals > 2 1 2 Dogs > 3 2 3 GermanShepard > 4 1

Re: Custom times/dates for mailout

W Luke wrote: > > I have a custom-made mailing list which sends out alerts to subscribers. > I need to allow subscribers to choose which days, and times, they wish > to receive their emails. i.e. Monday-Friday between 9am and 6pm. > > I was thinking about having Sun-Sat columns in the member's t

Re: Insert woes...

Ryan Mitchell wrote: > > > INSERT INTO SavedItems (Item, Quantity, AccountID, Option) > VALUES ( > value="#Session.Cart[i].Item#">, > value="#Session.Cart[i].Quantity#">, > , > value="#Session.Cart[i].Option#"> > ) > Are all fields varcha

Re: Custom times/dates for mailout

[EMAIL PROTECTED] wrote: >>I'm not sure how efficient MySQL is with booleans (especially since it >>doesn't have real booleans but uses integers), so before going of to >>create 168 (7 * 24) separate boolean fields in the table, it might be >>worth investigating if you can't store the informati

Re: OT: SQL--Recursive Query Question

Terry Hogan wrote: > > > SELECT > a.categoryID, > a.CategoryID catID3, a.categoryname cat3, a.level level3, > b.categoryID catID2, b.categoryname cat2, b.level level2, > c.CategoryID catID1, c.categoryname cat1, c.level level1 > FROM > tblCategory a LEFT JOIN >

Re: OT: SQL--Recursive Query Question

Terry Hogan wrote: > Here's the output: > > animals/ > animals/Cats/ > animals/Cats/Tabby/ > animals/Dogs/ > animals/Dogs/Beagle/ > animals/Dogs/German Shepard/ > Beagle/ > Beagle// > Beagle/// > Cats/ > Cats/Tabby/ > Cats/Tabby// > Dogs/ > Dogs/Beagle/ > Dogs/Beagle// > Dogs/German Shepard/ > Dog

Re: OT: SQL--Recursive Query Question

Terry Hogan wrote: > Getting closer... > > Was perfect with the original data, but I added a new subcategory (Horses) > and a new main category (Colors). I presumed they were all fully filled (3 levels deep). But if they are not, you need to test for empty values in the output then: #

Re: OT: SQL--Recursive Query Question

Ian Skinner wrote: > Any suggestions if you where doing something like this, but did not know the > number of levels before hand? The presented model (adjacency list model) can be easily extended as deep as you want by adding more left joins, but performance will suffer if you add too many. And

Re: Generating HTML

Brook Davies wrote: > > I am trying to generate some HTML via CF and I want the HTML to come out > clean. But I end up with lots of whitespace and for the life of me, I can > not get proper indentation due to all the CFIFS and related CF code. I have > tried using CFSETTING ENABLECFOUTPUTONLY="

Re: MX install woes

Charlie Griefer wrote: > > I just installed MX Professional on my computer. It's running (co-existing) > with CF 5 and IIS. > So MX is on it's own web server, on port 8500. > > Yet, I can only access .cfm pages thru localhost (127.0.0.1). This is *not* > a developer's edition. My serial # is i

Re: Datediff query

W Luke wrote: > > Now that I'm on MySQL, I don't understand how createtime() works. The > field (TheDate) is DATETIME, and I would need to grab all records > created in the past 24 hours. WHERE TheDate > > I also need similar queries, to find records submitted in the past 30 > minutes and 60

Release_date_for_coldfusion_mx_II/changes/fixes

Peter Mayer wrote: > > Has there already been set a deadline when the new version of ColdFusion > will be relased? Will there be any important changes (except the very > important bug fixes for several bugs and configuration issues)? > > What JVM will be the default one? I think that everybody

Re: quick query param question

Matthew Walker wrote: >>When using cfqueryparam, you leave off the single quotes. The tag will >>format the value in the appropriate way based on the cfsqltype attribute >>set. > > Actually I don't think it decides whether or not to insert the quotes -- it > uses another mechanism for passing the

Re: Adding SQL MS 2000 data source question

Brad Peloquin wrote: > > I'm hoping other people have run into this...I'm running CFMX and that local > version of MS SQL Server 2000. I have a database that I successfully > converted from Access to MS SQL 2000 and the query analyzer works just dandy > on it. However, when I When I go and try t

Re: quick query param question

Matthew Walker wrote: > http://www.houseoffusion.com/cf_lists/index.cfm?method=messages&threadid > =16005&forumid=4 > > Great explanation thanks Jochem. Interested to hear about the dbms > hashing the query and checking if the hash exists as a key to execution > plans. That was an example, differ

Re: CFLOCATION mechanism..?

David K wrote: > > While we're at it here, what's the response header that gets returned with > ? Refresh: 0; URL=foo.cfm Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www

Re: "Red Sky" Preview, Known Issues Update, and Installation Support

Angel Stewart wrote: > > Can we get a list of some of the customer defined issues that are being > dealt with? > (The presentation mentioned over 400) If you join the beta, you can see the list grow :-) Jochem ~| Archives:

Re: "Red Sky" Preview, Known Issues Update, and Installation Support

Doug White wrote: > > One submitted by me is the installation and configuration for different > platforms issues. It is a PITA to have to jump through hoops after running the > install, doing things like starting/stopping services, editing config files, > manually running multiple batch files, an

Re: Before you rush to tell me what to do ... (was: Quick note from the CF Team....) --- UPDATE ON MIKE'S ISSUE...

Damon Cooper wrote: > FYI: (if anyone's keeping track), it looks a lot like the issue Mike's ISP guy was > having was due to running the Updater installer under 16 colors (256 or higher > required, or you can use the "silent installer" with pre-loaded options). What's happening is the updater i

Re: OT - Smart Cards, Credit Cards / Storage Limits

[EMAIL PROTECTED] wrote: > My apologies for the OT post, I am hoping maybe someone has some > experience or knowledge in the following: > I am trying to find out how much data can be stored on the magnetic stripe > on a credit card. IIRC 3 tracks, 79, 40 and 107 characters, but characters are onl

Re: "Red Sky" Preview, Known Issues Update, and Installation Support

Mike Kear wrote: > Does anyone think it would be a good idea for me to try installing this > version? After you have made a disk image, yes. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscri

Re: Quick note from the CF Team....

Mike Kear wrote: > > Hands up anyone who would have thought not having enough > colours on the server's display settings would have killed an installation?? > Who's going to be brave enough to say they would have picked that? /me waves hands Issue #51673, bagged and tagged on May 20 (which is ex

Re: "Red Sky" Preview, Known Issues Update, and Installation Supp ort

Tony Weeg wrote: > where do I sign up for the red sky beta prog? See the presentation: http://www.macromedia.com/software/coldfusion/presentation/redsky/ Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forum

Re: Troubleshooting Performance - CFMX

B G wrote: > > I monitor Task Manager and CFSTAT at the same time. When CPU usage stays in > the 75%-100% range, requests running NEVER goes below 1. Frequently it > rises until the 25 limit where they go to queue. > > At this point I turn off IIS and the CPU stays the same, roughly 50%-75% a

Re: RegEx Expert challenge

Dennis Powers wrote: > > I can use some help. I need a RegEx to determine if there are three or more > invalid HTML tags on a page. Is this just too complex for a RegEx? It might be a better idea to automate the process of uploading a file to http://validator.w3.org/ and extracting the number

Re: Proprietary rights

Kris Pilles wrote: > Anyone on the list have experience with granting of proprietary rights > to a client? > > How to determine its worth Whatever they are willing to pay for it. You might give them a discount if you are sure that you can (and are allowed to) sell the code to other people as we

Re: Very unsatisfied with Macromedia's support attention ...

Dana Tierney wrote: > well yeah, except that it appears that there is a problem with a specific > KIND of installation, on shared servers. There is no technical difference between a shared server and a dedicated server. Only after you have installed CF you create the difference by configuring i

Re: 0ut 0f 0ffice Dates

Mike Townend wrote: > > Sorry for the x-post x-posted to what? > I was wondering if anyone has an idea as to how I can do this. Currently I > have a task system whereby you can allocate jobs to users, we have a table > that can record that you are 0ut of the 0ffice for a specified time, I need

Re: 0ut 0f 0ffice Dates

Mike Townend wrote: > > We're using SQLServer 2K If it support OVERLAPS (check the manual) it would be something like: WHERE UserID = 6 AND (0ut0f0fficeFrom,0ut0f0fficeTo) OVERLAPS ('2003-06-06','2003-06-10') Else, how about: SELECT * FROM 0ut0f0ffice WHERE UserID = 6 AND 0ut0f0fficeFrom BETW

Re: 0ut 0f 0ffice Dates

Mike Townend wrote: > > SELECT * > FROM OutOfOffice > WHERE UserID = @UserID > AND ( > (OutOfOfficeTo BETWEEN @Now AND @DeadLine) > OR > (OutOfOfficeFrom BETWEEN @Now AND @DeadLine) > ) > > > Which gets me all

Re: 0ut 0f 0ffice Dates

Mike Townend wrote: > Like the sound of the logic, however the code doesn't run on SQL2K as the > Max (and therefore Min) functions only take the one parameter and so is not > running :( Use CASE. Jochem ~| Archives: http://ww

Re: cfpop appended

Michael Tangorre wrote: > Sorry for the last post that was incomplete.. it was sent before I finished typing. > > At anyrate, here is what I nticed when viewing the header information from the email > I retrieve: > > Content-Type: multipart/mixed; boundary="PART.BOUNDARY.1055181506" > > Howeve

Re: Is there SQL equivalent to CF's ListGetAt function??? Please help!

Che Vilnonis wrote: > I have a column in a db that stores data with a pipe [|] delimiter. > I would like to write a SQL query that filters data based on a segment > of data within a pipe delimited variable. > > Basically, is there SQL code that is equivalent to the psuedo CF code > below? A SQL ve

Re: Is there SQL equivalent to CF's ListGetAt function??? Please help!

Che Vilnonis wrote: > hmmm...this could be the EASIEST way to do this. > thanks Jochem, I'll check it out! Actually, it gets easier: WHERE FinalShipTo LIKE '%|%|%|%|Amsterdam|%|%|%' I would expect MS SQL Server (just saw your message) to support regular expressions, in which case you could mat

Re: Red Sky Beta 2

Che Vilnonis wrote: > Is it against the NDA to tell me what Red Sky is??? > I've been away for a while...and I am clueless. http://www.macromedia.com/software/coldfusion/presentation/redsky/ This is the official information. Everything else should be regarded as gossip and would best be forgotte

Re: Generating HTML

Brook Davies wrote: > > I just saw this now for some reason, but thats a great idea. Thanks! BTW, > does Tidy correct mistakes in the HTML also? No idea. But I would be interested in seeing what you come up with :-) Jochem ~|

Re: Generating HTML

David Collie (itndac) wrote: > >>You could try to take the value of the buffer in OnRequestEnd, pass it >>to a cleanup script (such as the Java version of the HTML Tidy engine) >>and return the result from that instead of the original value. YMMV > Could this sort of method be used to auto add h

Re: CFMX and Chinese

Matt Robertson wrote: > > Whats the Big5 charset and > is it relevant/better than GB2312? Utf-8? Or are they all > interchangeable? They are not interchangeable and UTF-8 is the most versatile one. > I would want to run this on mySQL and CFMX if possible. Apart from the other issues, unicode

Re: OT~ but a good laugh:)

Dave Lyons wrote: > Microsoft announce FrontPage 2003 "We've really focused on generating > clean, industry-standard HTML code." they claim. That would be quite a change. IIRC, during the anti-trust trials Bill Gates himself has delivered sworn testimony that Frontpage is designed to only work w

Re: SQL conversion question for SQL Guru

Eric Creese wrote: > I have a query I am trying to run to get a particular record out of the database. > The problem is that one of the fields is > a varchar 255 field that houses a date. Only a date, or other information as well? > I want to convert the date so I can find out if it is greater

Re: Force download of file

Shawn Regan wrote: > Instead of: value="attachment;#variables.filename#"> > > shouldn't it be value="attachment;#variables.fullpath #"> Neither, it should be: value="attachment; filename=""#file#""" See RFC 2616, section 19.5.1 Since user agents are explicitly forbidden to use the supplied path,

Re: numbers too big

[sorry if you get this twice, but it doesn't show up here] Michael Tangorre wrote: > > The numbers are of the following size: > > range start > 00 > > range end > 99 > > That was one generic example. Basically the number represents a phon

Re: numbers too big

Michael Tangorre wrote: > > The numbers are of the following size: > > range start > 00 > > range end > 99 > > That was one generic example. Basically the number represents a phone number range > and I have a range for each country in the

Re: security and browser cached pages

sebastian palmigiani wrote: > Access to a browser cached page from a password protected site can be > accessed by anyone using the same machine using the back button on the > browser and see those pages even if they're not logged into the site. > > Is there some code that will expire the browser c

Re: phone numbers - update on previous problem

Michael Tangorre wrote: > Basically I just wanted to re-open my issue and it is bigger than I first imagined... > > anyways, has anyone tried to calculate using any language, what country a phone > number relates to? Basically I thought I had it until I realized that some country > codes overlap

Re: security and browser cached pages

Gabriel Robichaud wrote: > I'm new to this list, what is RFC 2616 ? It is the standard for HTTP 1.1: http://www.google.com/search?q=rfc%202616 Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subsc

Re: OT: Win2K Server

Michael Tangorre wrote: > Does anyone have a default list of windows services (on windows 2k server) installed > and what they do.. we are trying to turn off and disable any services we do not need > on our test servers Check out the NSA documentation for securing Win2K: http://www.nsa.gov

Re: CFMX datasource question

Owens, Howard wrote: > > Connection verification failed for data source: encore > []java.sql.SQLException: SQLException occurred in JDBCPool while attempting > to connect, please check your username, password, URL, and other > connectivity info. > The root cause was that: java.sql.SQLException: SQ

Re: OT: Big problem with CF product page on MM's website

Earl, George wrote: > I'm having a problem with the ColdFusion product page at MM's website. > > If I have the Flash Player installed I cannot see the list of links that > goes down the right side of this page: > > http://www.macromedia.com/software/coldfusion/ >

Re: What database to use???

Dana Tierney wrote: > Anyone with normal access can crash an Access database That's about all > I need to hear in Mysql vs Access Why? Do you give other people normal access to databases? Or do you predefine queries where they only get to fill out the parameters? Besides, crashing goes

Re: What database to use???

Dana Tierney wrote: > I am going by Doug's resource, that is what it says about the MS abd IBM > products. And that would be something I would have to account for, ya, > utterly illiterate clients. Unfortunately, Doug's resource seems to have been made using the crash-me utility, which is far f

Re: What database to use???

Dana Tierney wrote: > So you are saying his resource is wrong about that? I am convinced they can all be crashed by people with sufficient priviledges and destructive tendencies. > They all can be crashed? Sure. Just do the math on the following query for a 100 row table: SELECT * FROM table

Re: Money Datatype Problem

Venable, John wrote: > Maybe someone can tell me what I'm doing wrong. I have a field in SQL Server > 2K that is money datatype. I am building a submission form to populate that > field and I keep getting errors about type. This is what my field insert > looks like: > > len(trim(form.HourlyWage)

Re: What database to use???

Dana Tierney wrote: > Well, I have a couple of different situations going on. In the one case I > will probably keep sole access, alhough gee, I can envision cases where it > would be nice to have a volunteer doing data entry, so I would like to > idiotproof it and make this possible. But then

Re: What database to use???

Doug White wrote: > Please detail the inaccuracies. The Crashme authors want to know. It reports MySQL has a SQL 92 VARCHAR type. Since VARCHAR fields are not allowed to loose trailing spaces, this is not accurate. It reports PostgreSQL does not have circular foreign keys or an ANSI SQL iden

Re: OT: which version of MDAC and C++ runtimes do I have?

Mike Kear wrote: > I'm about to install some software, and the install notes tell me I have to > have MDAC2.6 SP2 installed, and Visual C++ 6.0 runtimes. > > The notes also refer to MS Knowledgebase articles about them but I can't > make head or tail of them. I don't know if I have these componen

Re: CFMX,BD... the question on many minds...

Rafael Alan Bleiweiss wrote: > > OK - so after all that I've read, I still sit here with a fifty fifty > issue, EXCEPT - Did I read correctly? BD's CFQUERY does NOT natively allow > escaping single-quotes? Yes. This is about as bad as it can get for developers. CF MX breaks with cfqueryparam

Re: CFMX,BD... the question on many minds...

Damon Cooper wrote: > What's the issue you're seeing with CFQUERYPARAM in CFMX? All 4 queries below should return the same value, but the last one returns a string with 2 quotes. SELECT '#string#' AS test SELECT '#trim(string)#' AS test SELECT AS test SELECT AS test

Re: Array or Struct...which would be more 'do-able' for something like this...

Jeff wrote: > I'm doing a fairly complex join, and the recordcount of that join is a > different number than I actually need because I group the output. For > instance, I might have a recordcount of 13, but since the output is grouped > around, say, PropertyID, what you really see, are 2 propertie

Re: CF Compatability

Joe Eugene wrote: > >>But..I suppose I was wrong. Is it not possible to 'copyright' a >>programming language itself? > > > Can you copyright some tags you wrote in ColdFusion.. Yes i think so.. even > some developers sell their tags Developer Exchange etc.. Copyright protects against verbatim c

Re: OT: printer friendly page break?

Janine Jakim wrote: > Is there an easy way to force a page break at certain sections? Use the CSS page-break-before and page-break-after options. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4

Re: OT: Whoa, what's with MACR Stock?

[EMAIL PROTECTED] wrote: > A couple of months ago MACR stock was selling in the $12.50 range. > > Yesterday it closed at it opened for $20.25 and the latest is $21.57 up > $1.32 or 6.52% > > Is there some good news that I haven't heard? There is plenty of good news on cf-community. Jochem ~

Re: Getting IE to accept XML from ColdFusion

Ian Skinner wrote: > I'm generating XML with Cold Fusion's tag and then sending to the > client with a tag. This works just great in Netscape, but IE > will not recognize the XML. Any suggestions on how to get it to do so? If > I view the source of IE's non-XML page save it with an XML file e

Re: Getting IE to accept XML from ColdFusion

Ian Skinner wrote: > And you want to add some weirdness, I changed it back to see the difference > and now IE is behaving as I would expect it to either way. It is > recognizing the xml with either text/xml or application/xml! Maybe the difference is in the reset attribute. Jochem ~

Re: OT: SQL problem

Hugo Ahlenius wrote: > > I want to have a SELECT that gives me the highest values in a table > > The table looks like this: > CountryName, Value, Year Aren't value and year reserved words in SQL? > And the data something like: > Sweden, 80, 1970 > Sweden, 20, 1999 > Denmark, 10, 1962 > Denmark

Re: OT: SQL problem

Hugo Ahlenius wrote: > The columns are (of course) named something else. Perhaps I should have > used something else? > > Jochem, your suggestion looks cleaner than mine, but SQL Server 2k chokes > on your (CountryName, Year) in the WHERE clause. I am actually not sure > what that does... ? It is

Re: OT: SQL problem

S. Isaac Dealey wrote: >>SELECTCountryName, Value, Year >>FROM table >>WHERE >> (CountryName, Year) IN ( >> SELECT CountryName, MAX(Year) >> FROM table >> GROUP BY CountryName >> ) > > > Is that a sql92 standard IN clause?... I gu

Re: CFMX Server Errors :(

Critz wrote: > > os.name: Windows 2000 > os.version: 5.0 > os.arch: x86 > platform: intel-win > web server: IIS > File C:\CFusionMX\runtime\lib\wsconfig\jrunwin32.dll newer than JAR file C:\CFus > ionMX\runtime\lib\wsconfig.jar so not extracted > findServers(): attempting connect to port 2901 on h

Re: How many tables per datasource?

Blood Python wrote: > > I never thought about it until today, when i was asked about it while > explaing a bit if mysql for a friend. Is there a rule or best pratice to > know when it's time to create another datasource? Maybe spliting 1 > datasource with many tables on 2 or 3 increases perform

Re: OT: printer friendly page break?

Mark A. Kruger - CFG wrote: > > How about a short example? http://www.google.com/search?q=page-break-before%20example :-) Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www

Re: SOT: Worthwhile blogging?

Oliver Cookson wrote: > > Just wondering if anyone can share any good blogs for me to read and add > to my morning necessitates, of course CFMX\Internet related. One Blog to Blog them all: http://www.fullasagoog.com/ Jochem ~|

Re: Problem SQL & CF 5

Jodie A wrote: > We have a web frontend (W2k+sp3, CF 5.0, IIS 5.0) with a bbdd backend > (Solaris + Oracle 8.1.7.4) and our web application uses CF [Oracle80] native > drivers to connect to our database. > > When the web application (our cfm's) makes a problematic sql sentence (For > example :

Re: Is Siteminder used when loading CF5 w/o Advanced Security?

Horne, Jeff wrote: > When loading CF 5.0, it appears that even when Advanced Security is not > selected, Siteminder is loaded. Also, all the bat files on Macromedia's > site for tasks such as stopping and starting the services include > Siteminder. Is Siteminder used in any way for Basic Securi

Re: SQL

Michael Tangorre wrote: > > does anyone have any links or references that will shed some light on breaking an > appliction data structure (sql server database) down into transactional and > reporting/lookup databases to enhance performance. I am looking for some advantages > and disadvantages i

<    5   6   7   8   9   10   11   12   13   14   >