Re: CF and Hungarian Notation - a better solution

2005-05-14 Thread I-Lin Kuo
CFEclipse yet but abck in the day I > did a lot of work > on code analyzers that tracked variable assignments > and could > dynamically deduce types. Maybe it's time to dust > down that knowledge > and start trying to figure out how to apply it on > top of CFEclipse's >

CF and Hungarian Notation - a better solution

2005-05-14 Thread I-Lin Kuo
variable type. If CF were to add some kind of JavaDoc-like annotation feature, then I don't think there would be any more arguments about CF and Hungarian notation (excluding notepad and emacs users :) .... I-Lin Kuo Macromedia CF5 Advanced Developer Sun Certified Java 2 Programmer

Re: Well - I feel like an idiot.

2004-12-31 Thread I-Lin Kuo
quest will try to obtain a lock. By the way, this is a familiar idiom in java called "double-checked locking". I'm glad it works in CF, because it may fail in java. See http://www.cs.umd.edu/~pugh/java/memoryModel/DoubleCheckedLocking.html = I-Lin Kuo Macromedia CF5 Advance

RE: Document Version Comparison

2004-08-17 Thread I-Lin Kuo
Another approach would be just to run diff on the files and use CF to parse the resulting diff file and apply formatting to the originals based on the diff. --- Micha Schopman <[EMAIL PROTECTED]> wrote: > I came up with the algorithm because I have some > experience with this > subject, I haven't

Re: Fiel Field style : )

2004-08-15 Thread I-Lin Kuo
Why do you need to click the submit button twice? From your posted code, only the Browse... button affects the file field. Do you really need to disable the file field button? I haven't tried this, but you might try to trap the onclick event of the file button instead of disabling it? --- Ewok <[E

Re: CFMX Oracle and SQL Server Fun

2004-08-10 Thread I-Lin Kuo
DTS can run stored procedures as well. The two options aren't exclusive. If you're really worried about speed, then you should definitely cut CF out of the loop and have SQL Server pull the data directly from Oracle. If you have SQL Server talk to Oracle directly, then you will probably need to se

Re: UNIX linefeeds... why?

2004-08-09 Thread I-Lin Kuo
It might not be Sean's reason, but if you do processing on text files with something with regular expressions that match across multiple lines, not having to deal with that [optional] extra character makes a big big difference in your regular _expression_. --- Charlie Griefer <[EMAIL PROTECTED]> w

Re: Referencing a query column while still in the query

2004-08-04 Thread I-Lin Kuo
SELECT   d.ItemID, d.Title, d.MediaType,  (avg(i.BuyersPrice/i.Quantity) -avg(q.Cost)*1.175 -avg(i.BuyersPrice/i.Quantity)*0.15 + CASE mediatype  WHEN 1 then 1.1  when 2 then 1  ...    END AS AvgMargin FROM SomeTables --- James Smith <[EMAIL PROTE

Re: CF/SQL Help Needed

2004-08-03 Thread I-Lin Kuo
fileskeep from table1) will do the job. P.S. you might want to rethink your database design. = I-Lin Kuo Macromedia CF5 Advanced Developer Sun Certified Java 2 Programmer __ Do you Yahoo!? New and Improved Yahoo! Mail - Send 10MB messages! http

Re: CF/SQL Help Needed

2004-08-03 Thread I-Lin Kuo
ru and set the flag but I > can't seem to wrap my brain around it this morning. > > TIA, > Donna > = I-Lin Kuo Macromedia CF5 Advanced Developer Sun Certified Java 2 Programmer ___ Do you Yahoo!? Express yourself with Y! Messenger!

Re: need sql guru help

2004-08-03 Thread I-Lin Kuo
> Server: Msg 207, Level 16, State 3, Line 1 > Invalid column name 'ignitionGroup'. > > using MS SQL server 7.0 = I-Lin Kuo Macromedia CF5 Advanced Developer Sun Certified Java 2 Programmer __ Do you Yahoo!? New and Improved Y

Re: need sql guru help

2004-08-03 Thread I-Lin Kuo
Try this: select (select count(*) from inbound as t1 where nsew='IGNITION ON' and t1.dt < t2.dt and t1.vehicleid = t2.vehicleid ) as ignitionGroup, vehicleid, count(*) from inbound as t2 where t2.nsew='IDLE' group by vehicleid, ignitionGroup --- John mccosker <[EMAIL PROTECTED]> wrote:

Re: Oracle PL/SQL and CLOBS

2004-07-23 Thread I-Lin Kuo
tiple rows > and bring that together in the end. > > The clobs work fine when exporting just a few rows > but when I try to export a few hundred; The program > takes about an hour and temp table space grows by > 768 megs. > > Thanks, > > David = I-Lin Ku

Re: Query of a query inconsistancies

2004-07-08 Thread I-Lin Kuo
Logically, they're different. You shouldn't get any results by moving the orderdate condition to the bottom query, because qryGetRepeatSales doesn't have a date column --- Todd <[EMAIL PROTECTED]> wrote: > I have these 2 queries: > > > name="qryGetRepeatSales"> > SELECT *, COUNT(*) AS totalc

RE: How to do this join? (MySQL 4.0 can't do subqueries...)

2004-07-01 Thread I-Lin Kuo
to the join.  I use joins very seldom, so they give > me fits every time I > have > to use one... > > But that's enough rambling! > Thanks for the solution! > > Rick >   -Original Message- >   From: I-Lin Kuo [mailto:[EMAIL PROTECTED] > > >   

Re: How to do this join? (MySQL 4.0 can't do subqueries...)

2004-07-01 Thread I-Lin Kuo
tle, > >    from newsletter_series > > > > left join > > > >  newsletter_subscriptions, > newsletter_subscribers > >     on (newsletter_subscriptions.Subscriber_ID <> > > '#CurrentSubscriber.Subscriber_ID#' > >  and newsl

Re: advanced search

2004-06-16 Thread I-Lin Kuo
Look into text indexing in SQL Server, Oracle text in Oracle, and ?(I've forgotten)? in mysql. "LIKE '%#form.words#%'" queries are best avoided, for speed and feature reasons. In general, text indexing allows ranked searches, stemming, thesauri, and other nice featuers. --- Frank Dewey <[EMAIL PRO

Re: Out of Memory Error Transforming large XML file.

2004-06-15 Thread I-Lin Kuo
While I love XSLT, I have encountered similar problems using XSLT on large xml files (~25meg). The problem is that all the XSLT engines I know load the entire document into memory before performing the transformation. At first I cut up the large files by hand into two or three pieces so they could

Re: Oracle CLOBS SQL

2003-11-14 Thread I-Lin Kuo
Thanks for alerting me to this. According to documentation, it's a new feature in 10g. Two words of warning on searching CLOBs:   - CLOBs aren't made to be searched or manipulated or concatenated, but Oracle usually converts a CLOB to a string to allow this.   - the CLOB-string conversion usually o

Re: Better method for counting records?

2003-11-14 Thread I-Lin Kuo
try this:    select count(case_id) As ThisCount1 from table1 left outer join tablemain on tablemain.sectionname = table1.x    group by sectionname    order by sectionname    select count(case_id) As ThisCount2 from table2 left outer join tablemain on tablemain.sectionname = table1.x    group by

Re: Import/Export - Excel to/from Access/SQL Server

2003-11-13 Thread I-Lin Kuo
Sorry, responding a bit late. Excel has a built-in limit of 64K records, so if his 43K record is going to double, he can't use Excel. --- Stan Winchester <[EMAIL PROTECTED]> wrote: > I have a client who is running an ecommerce site > with an Access database > backend, which will hopefully be upgr

Re: OT : SQL List Comparison

2003-09-26 Thread I-Lin Kuo
Depending on your database and exactly what you wantedto do with the list, You could try something likeupdate yourTable set selected=0where primKey in (select primKey from yourTable where primKey in(#List1#) MINUSselect primKey from yourTable where primKey in(#List2#))Clever combinations of the bas

RE: OT- RE: XML Best Practices - Resources

2003-08-14 Thread I-Lin Kuo
xsl-fo is for the formatting part. For general xsl questions, the list is XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list --- Tony Weeg <[EMAIL PROTECTED]> wrote: > there is one in the yahoo groups...xsl-fo I think? > > tony weeg > uncertified advanced cold fusion developer

Re: XML Best Practices - Resources

2003-08-14 Thread I-Lin Kuo
sed to an > attribute approach. > > > mobile > 555-555-5555 > 1234 > > > > Mike > = I-Lin Kuo Macromedia CF5 Advanced Developer Sun Certified Java 2 Programmer __ Do you Yahoo!? Yahoo! SiteBuilder - Free, ea

Re: XML & xsl

2003-07-10 Thread I-Lin Kuo
I ran your stylesheet and it worked for me, but I had to close your entity tag and change your xpath from "Entity/department/employee" to "entity/department/employee". But I can't see anything that would cause it to work only for the first employees, unless you changed something when you posted to

Re: OT: disable flash temporarily

2003-06-06 Thread I-Lin Kuo
Thanks for the tips, everyone --- Chris Montgomery <[EMAIL PROTECTED]> wrote: > Howdy I-Lin, > > Thursday, June 5, 2003, 5:06:46 PM, I-Lin Kuo wrote: > > > I'm pretty sure these are flash. It's not a new > window > > that pops up, it's an animat

Re: OT: disable flash temporarily

2003-06-06 Thread I-Lin Kuo
popups playing flash ads, like Yahoo News has. --- Thomas Chiverton <[EMAIL PROTECTED]> wrote: > On Thursday 05 Jun 2003 13:11 pm, I-Lin Kuo wrote: > > conferencing software, but I really hate the > popups. > > What pop-ups ? > > -- = I-Lin Kuo Macrome

Re: OT: disable flash temporarily

2003-06-06 Thread I-Lin Kuo
uter before I installed Flash. Pre-flash, I'd get prompted every time to download flash. = I-Lin Kuo Macromedia CF5 Advanced Developer Sun Certified Java 2 Programmer __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outl

OT: disable flash temporarily

2003-06-05 Thread I-Lin Kuo
d flash pop-ups. = I-Lin Kuo Macromedia CF5 Advanced Developer Sun Certified Java 2 Programmer __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com

RE: XPath in CFMX

2003-03-12 Thread I-Lin Kuo
ion. I haven't worked with xml inside of CFMX to know, but I would suspect that XMLSearch isn't returning it at all. I'm currently developing using the Cocoon publishing framework built on top of xerces and xalan and liking it very much. = I-Lin Kuo Macr

RE: XPath in CFMX

2003-03-12 Thread I-Lin Kuo
th and the parser found 4 valid elements, how > would it be returned to > > > you? In an array or some other "collection" like > data type (struct, hash > > > table, etc.). > > > > > > BUT, when you are using XMLSearch() to grab one > element&#x

Re: OT: Scripting Internet Explorer

2003-03-07 Thread I-Lin Kuo
1.script IE to open a web page 2.save locally as .mht 3.repeat I've done 1 and 3and I have an idea on how to do 2. First, you need to have permissions to do this. One way is to sign your javascript/vbscript. The other, easier way is to make your web page an .hta (HTML Application) simply by chang

Re: OT: Oracle Foreign Key Constraint

2003-02-17 Thread I-Lin Kuo
ship_location (locationid), > constraint (fk_tship_price) foreign key > references tship_pricerange (priceid) > > > > which produces this error from the Oracle server: > ORA-00902: invalid datatype = I-Lin Kuo Macromedia CF5 Advanced Developer Sun Certified Java 2 Programm

RE: DB Strategy

2003-02-05 Thread I-Lin Kuo
;Perhaps I missed it in your earlier post, but if > you're using SQL Server > >(and I'm sure other DB servers can do the same), > why not simply reference > >the foreign db/table in your queries? > > > >For example, say you have db/table WebApp/customers

Re: IDE was RE: CFML Forever!

2003-02-05 Thread I-Lin Kuo
JRockit is not recommended for Client-side Java Apps. It's designed for Server-side. --- [EMAIL PROTECTED] wrote: > Wednesday, February 5, 2003, 2:40:28 AM, you wrote: > > DB> On Wed, 5 Feb 2003 01:04:02 -0500 > DB> [EMAIL PROTECTED] typed: > > >> Honestly though, it's still very sluggish. Much >

Re: OT: Book Recomendations on UI

2003-01-20 Thread I-Lin Kuo
t serious about this. I feel that if I > can get the UI part down, and I have the back-end > programming experience, it will make me a more well > rounded developer overall (not to mention the money > I will save for not having to outsource the UI > work). > > TIA, > >

Re: Visual Fusion - Thoughts?

2003-01-14 Thread I-Lin Kuo
nimal HTML-rendering component in Java, or something else? If not, then there's going to be some learning curve for the display widgets, or are you duplicating WinForms in Java? ===== I-Lin Kuo Macromedia CF5 Advanced Developer Sun Certified Java 2

Re: Visual Fusion - Thoughts?

2003-01-14 Thread I-Lin Kuo
Not that I know what I'm talking about, but it seems like a better approach would be to build this on top of .NET's CLR rather than Java... --- Pablo Varando <[EMAIL PROTECTED]> wrote: > Hello CF-Talk community: > > For the last year or so I've been working on an > application called > "Visua

re: try-catch was re: cfswtich et al...

2002-10-15 Thread I-Lin Kuo
# > #ceiling(arraymax(request.times_switch))# > #ceiling(arrayavg(request.times_switch))# > #ceiling(arraysum(request.times_switch))# > > try > #ceiling(arraymin(

Re: SOT: RegEx

2002-10-13 Thread I-Lin Kuo
Willy, It seems like you're using a different dialect of RegExp than CF uses. Try [0-9]+x[0-9]+ as your regexp --- Patric Stumpe <[EMAIL PROTECTED]> wrote: > Hi Willy, > > if it's always the same structure you could get use > ListGet(myString, 3, ' ') With space as delimiter. > > Just a thou

Re: Reverse PDF tools

2002-09-30 Thread I-Lin Kuo
http://pdftohtml.sourceforge.net/ I haven't had a chance to try it, though. --- "Mark A. Kruger - CFG" <[EMAIL PROTECTED]> wrote: > Ok... I know I can take HTML or other doc formats > and automate the process > of converting them into PDF format. Does anyone > know of a tool that can do > the r

Re: RegEx - POSIX

2002-09-26 Thread I-Lin Kuo
t; and further distribution > of it is strictly prohibited without our authority. > If you are not the > intended recipient, you are not authorised to > disclose, copy, distribute, or > retain this message. Please notify us on +44 (0) 20 > 7387 8890 = I-Lin Kuo Macromedi

Re: Advanced Statistical Analysis

2002-09-26 Thread I-Lin Kuo
t would belong to > the campus computing.) > > -d > > > > Deanna Schneider > Interactive Media Developer > [EMAIL PROTECTED] > = I-Lin Kuo Macromedia CF5 Advanced Developer Sun Certified Java 2 Programmer

OT: pruning logic branches

2002-09-24 Thread I-Lin Kuo
pping conditions are redundant. But how would I do this programmically and what's the approach? (I assume that optimizing compilers might do something like this to prune unused program branches). I know a little about compilers, lexers, parsers, symbol tables, etc. but not too much Refere

RE: Regex help, again

2002-09-23 Thread I-Lin Kuo
Try <(h[0-9])>(([^<]|<[^/]| --- Ian Lurie <[EMAIL PROTECTED]> wrote: > Yep, that's the problem. > > This works great if all I have to do is grab the > first element: > > ]*> > > But I actually need what's between the and > and it DOES > include HTML. > > Sigh... > > -Original Messag

Re: OT: Oracle 9i

2002-09-21 Thread I-Lin Kuo
I'm working on a project using XML and Oracle 9i right now. The XML handling capabilities have improved so much since Oracle 8i, I'm absolutely amazed. You'll need to give a little more information about what you're doing -- for example, how are you storing XML within the database? Are you s

Re: SQL Server advice

2002-09-21 Thread I-Lin Kuo
> then use DTS to ship > > it up to the server. This works, but we'd like to > automate the process. > > What's the best and/or easiest way? We're > obviously not SQL server gurus > > but would like to learn more. > > >

Re: OT: ecommerce live chat case study

2002-09-06 Thread I-Lin Kuo
Thanks. That's definitely something good to know. --- Sean A Corfield <[EMAIL PROTECTED]> wrote: > On Friday, September 6, 2002, at 05:37 , I-Lin Kuo > wrote: > > Has anybody every implemented a live chat? I'm > > thinking of adding chat capability to an >

OT: ecommerce live chat case study

2002-09-06 Thread I-Lin Kuo
Has anybody every implemented a live chat? I'm thinking of adding chat capability to an e-commerce site so customers can ask questions as they shop without picking up a phone. How difficult is it? Did you develop it yourself or use some commercial software? Thanks in Advance, I-Li

RE: Slightly OT: CFQuery, Oracle and Limiting rows

2002-08-28 Thread I-Lin Kuo
or counter on the rows so I cannot do a > select where rowid between > 1 and 100 or 101 and 200 and so on. Each row has a > unique value in it, and > can be added to or deleted from at any time. Also, > the data needs to be > real-time so caching a query is out of the question > as

How does CF cache queries?

2002-08-18 Thread I-Lin Kuo
Can someone tell me how CF determines whether a query is the same as a previously cached query? Does it require an exact match on both the queryName and the SQL (including whitespace)? Is this matching criteria DB independent? Is this version dependent (MX, 5, 4.5)? = I-Lin Kuo

Re: Survey Launching

2002-08-15 Thread I-Lin Kuo
n - i.e. > clicks some where else. > 2) activate when the user closes the site down. > > How easy is this to achieve? Obviously the onClose > is pretty > straightforward but what about the domain etc.... > Any ideas/thoughts. > > How long would it take to impleme

Re: Beware of inheritance (was: cfreturn session.records ?

2002-08-04 Thread I-Lin Kuo
> > A > B extends A > C extends A > D extends A > > is better implemented as: > > A > X (contains A instance) > B extends X > C extends X > D extends X > > "

Re: Table Locking Problems

2002-07-26 Thread I-Lin Kuo
Here's a good summary of SQL Server Locking http://www.swynk.com/friends/achigrik/SQL70Locks.asp --- Colin Murphy <[EMAIL PROTECTED]> wrote: > Thanks for your help. > I think I will dig out the SQL books and write a > couple of stored procedures > todo this. > &

Re: OT: SQL Query

2002-07-26 Thread I-Lin Kuo
SELECT c.id, c.description FROM choiceTable c WHERE c.id = '#url.productid#' AND NOT EXISTS ( SELECT pc.id FROM ProductChoiceTable pc WHERE pc.productid='#url.productid#' ) --- Paul Giesenhagen <[EMAIL PROTECTED]> wrote: > I have a query that I am trying to get all my > descriptions from my

Survey on CF scalability

2001-08-09 Thread I-Lin Kuo
--- I-Lin Kuo Macromedia Certified ColdFusion 5.0 Developer Sun Certified Java 2 Programmer Ann Arbor, MI ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.

Re: GENEALOGY SEARCH CODING CONTEST

2001-07-22 Thread I-Lin Kuo
Pardon me, but this just seems like a blatant method to get some cheap code. I-Lin Kuo Macromedia Certified ColdFusion 5.0 Developer Ann Arbor, MI >Date: Sat, 21 Jul 2001 18:30:10 -0700 >From: Karl Simanonok <[EMAIL PROTECTED]> >Subject: GENEALOGY SEARCH CODING CONTEST >If

RE: OT: HTML Question with Netscape 4 and 6

2001-07-11 Thread I-Lin Kuo
I didn't have any problem viewing it with Netscape 4.7 >From: Robert Everland [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, July 10, 2001 12:17 PM >Subject: OT: HTML Question with Netscape 4 and 6 >Can someone please tell me why these pages completely mess up in Netscape 4 >and 6 besides the obvio

Re: CF-Talk-list V1 #16

2001-07-04 Thread I-Lin Kuo
In my experience I've found two reasons for this, but somehow I'm sure there are more ... 1. CF is attempting to send mail messages but does not succeed and continues to attempt to resend them. check in the folders related to mail. If you select these mails and try to delete them but fail, tha

dll to correct 100%CPU due to messages in /mail/spool/

2001-04-26 Thread I-Lin Kuo
I recall a while ago there was a .dll which was supposed to correct a problem with undelivered messages in C:\CFUSION\\mail\spool\ causing CFServer to use use 100% of the CPU time. Can someone point me to it? I tried searching the archives to no avail _

RE: Email Questions

2001-04-12 Thread I-Lin Kuo
If the code inside of your tags are going to be run 70,000 times, I'd put a lot of effort into optimizing it. 1. The BCC idea is great. 2. Make sure you're not running any unnecessary queries inside of your CFMAIL 3. Take all the text in the body and place it into a variable such as #MailText

RE: CF Server parsing .js files...

2001-04-07 Thread I-Lin Kuo
Don't change your .js files to .cfm files or mess with your server extensions or them. That's not how the browser uses the .js files. If you want to include CF variables in your .js files, do this. In a separate WriteJSOutput.cfm file, process the CF variables, and then use CFFILE to write t