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
>
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
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
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
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
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
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
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
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
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!
> 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
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:
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
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
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]
>
>
>
tle,
> > from newsletter_series
> >
> > left join
> >
> > newsletter_subscriptions,
> newsletter_subscribers
> > on (newsletter_subscriptions.Subscriber_ID <>
> > '#CurrentSubscriber.Subscriber_ID#'
> > and newsl
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
;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
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
>
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,
>
>
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
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
#
> #ceiling(arraymax(request.times_switch))#
> #ceiling(arrayavg(request.times_switch))#
> #ceiling(arraysum(request.times_switch))#
>
> try
> #ceiling(arraymin(
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
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
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
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
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
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
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
> 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.
> >
>
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
>
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
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
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
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
>
> 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
>
> "
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.
>
&
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
---
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.
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
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
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
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
_
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
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
62 matches
Mail list logo