RE: Hackers and Painters - Applied to Cold Fusion
Here's a link to a great (programming Lisp) textbook that gives meaning to the old adage 'standing on the shoulders of giants' http://mitpress.mit.edu/sicp/full-text/book/book.html Have fun building something great! -mike "Spike" <[EMAIL PROTECTED]> 07/26/2004 02:36 PM Please respond to cf-talk To: CF-Talk <[EMAIL PROTECTED]> cc: Subject:RE: Hackers and Painters - Applied to Cold Fusion One thing to realize about Lisp is that one of it's main design goals was to be an elegant mathematical solution to a number of computational problems. The origins of it's design came first from a desire to work with artificial intellingence, and as a result to create a language to allow the processing of imperative and declarative sentences so that the computer could deduce what the programmer wanted it to do. While John McCarthy was designing the language, he used mathematical notation to describe what it should do and how it should work. Steve Russell happened to notice that the eval function could act as an interpereter for the language itself, wrote the code for it, and the language ended up with it's odd parentheses loaded syntax. It is completely different to any other language I have worked with and I'm sure I don't understand even a tiny fraction of the implications of the way it works, but I find that using it from time to time gives me a much better perspective from which to approach difficult problems in other languages. It is generally regarded as the first language to support if/else constructs and several other ideas (http://www.paulgraham.com/diff.html). It is also approaching it's 50th birthday and is still widely regarded as one of the most if not the most powerful programming languages around. Definitely worth having in your programming toolbox if for nothing other than to give you an alternative way to look at problems. My 2 cents Spike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SOT: Is this possible? was mediaPlayer
Dick Applebaum <[EMAIL PROTECTED]> 07/20/2004 11:06 AM Please respond to cf-talk To: CF-Talk <[EMAIL PROTECTED]> cc: Subject:SOT: Is this possible? was mediaPlayer Is this possible with _javascript_? -- probably Is it possible with a Java applet? -- certainly If not possible with a plugin, could _javascript_ invoke a desktop player (WMP or QT) and pass it the song. -- methinks the 'security model' says no way If none of the above, is there any other way? -- Director &/or Flash (separately or in concert) both will give you complete control over both the streaming & user interface components. -- hope this helps, -mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: WOT but important[ENCRYPTED]
Bruce, May you a safe and secure round-trip. I'll try to do my part and push for regime-change here at home -- and hopefully the 'gates of hell' will close as our belligerent country moves towards an exit strategy. Peace, Mike "Bruce Sorge" <[EMAIL PROTECTED]> 07/15/2004 10:24 AM Please respond to cf-talk To: CF-Talk <[EMAIL PROTECTED]> cc: Subject:WOT but important Although I have not been a big contributor to this list, I have learned a lot from it. I will have to unsubscribe though for a while since I have just been told that I am going to Iraq with my national guard unit. I am heading out next month for training and then should be in country around January. Thanks to everyone who has helped answer my questions and I look forward to returning and getting more great tips and tricks from this list. Bruce Sorge [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: query problems from blank form entries
I think I understand a bit better -- you want to 1st check if the record exists & then, if not, insert a new one, eh? Do you know what fields are required and what is optional. You probably need to run your query against only the mandatory fields to determine what constitutes a 'unique' record (some would call this the definition of a primary key). Anyhow, you may be having issues with NULLS which are different than '' (empty). So you may need to try something like /* write qry statement here */ ... WHERE form.address EQ '' OR form.address EQ NULL (this would cover both types of 'null-ness') btw, Oracle supports a sql command known as UPSERT (combo of insert & update) which may be of use if that is your environment. good luck, -mike Daniel Kessler <[EMAIL PROTECTED]> 07/15/2004 04:39 PM Please respond to cf-talk To: CF-Talk <[EMAIL PROTECTED]> cc: Subject:query problems from blank form entries I posted this before, but I have new info so I'd like to present it more accurately (I hope). I'm having problems in the WHERE statement of a query and if any of my form variables are blank then it doesn't find the correct record. I have a form with firstname,middlename,lastname,address. To determine whether there's already a record with that info BEFORE I insert the information, I do a query: SELECT firstname,middlename,lastname,address FROM alumni_contacts WHERE firstname = '#Form.firstname#' AND middlename = '#Form.middlename#' AND lastname = '#Form.lastname#' AND address='#the_address#' If any of the form variables are left blank, the WHERE in the query fails to find the record that already exists. So, I thought well if it doesn't like blank fields, then check for that and maybe set it to empty quotes ''. But that doesn't seem to help. I do: I really need help here and have wasted so much time on this. thanks. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 301-405-2545 Phone www.phi.umd.edu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: WOT but important
Sorry Ken, but I simply abhor violence... especially when the violence is unjustified, unwarranted and inexcusable. Those words are not mine (nor is the simple phrase 'gates of hell' for that matter). Those words were chosen by the Warren commission in decrying the Kent State Massacre in 1970, which, for the record, was the slaughter of innocents for exercising their 1st amendment rights.. I too served in the military (army ohio national guard) as a private/2nd/ & finally 1st lieutenant and believe me, I earned a lot more respect from my soldiers (especially the many 'nam era sergeants that I worked with) by being honest about my beliefs. Oh yeah, then there were those who simply thought I was an idiot :) Email me directly if you need to. I won't continue this thread in this forum. Mike "You can't repeat the past -- of course you can" b.dylan "Ken Ferguson" <[EMAIL PROTECTED]> 07/15/2004 02:43 PM Please respond to cf-talk To: CF-Talk <[EMAIL PROTECTED]> cc: Subject:RE: WOT but important Strong work Bruce - Thank you! Mike, And speaking as a serviceman who's spent time in the red zone in Haiti, Bosnia and Southwest Asia, I hope you somehow realize how poor a statement that is to make. Bruce volunteered for this duty as many of us have done. I love the way you oversimplify the issue as is so often done by the idiots making these kinds of statements. I'm quite sure this list isn't the place for this argument, but while we're off-topic and I'm replying to wish Bruce the best... Man, that's like saying: "I wish you luck supporting our country that I don't like very much". What's a guy going to say to that? The phrase "thanks, but keep your f-ing negative comments to yourself" sure comes to mind. People never seem to be able to grasp what kind of an insult this actually is to the people in the services and that pisses me off. I don't take issue with your belief that we should or shouldn't be over there, but you and others making similar statements need to understand that this isn't an acceptable comment to make to someone who thinks enough about this country and his comrades to volunteer to fight for and protect them. Currently sick on the server room floor, Ferg _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, July 15, 2004 9:40 AM To: CF-Talk Subject: Re: WOT but important Bruce, May you a safe and secure round-trip. I'll try to do my part and push for regime-change here at home -- and hopefully the 'gates of hell' will close as our belligerent country moves towards an exit strategy. Peace, Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: repeat record in query
Hi Daniel, Do you mean "I want to be sure that there are _NO_ duplicates" ?? If so, then your statement ought to read add_check.recordcount GT _1_ (not 0) Of course you may want to know if your form fields yield 0 results. A quick-n-dirty way to see if there are dupes would be to run 2 queries (qry 1: select * and qry 2: select distinct *) and check the 'myquery.recordcount' for each (if the recordcounts are equal, then you may assume that there are no dupes. hth, -mike Daniel Kessler <[EMAIL PROTECTED]> 07/15/2004 02:00 PM Please respond to cf-talk To: CF-Talk <[EMAIL PROTECTED]> cc: Subject:repeat record in query I have an alumni database and I want to be sure that there are duplicate people. I have alot of information to do a compare, but I don't want to limit it to first name/last name. Also, the query that I've been doing seems say there's a duplicate when there isn't so I wanted to be sure I was doing this correct. SELECT firstname,middlename,lastname,address FROM alumni_contacts WHERE firstname = '#Form.firstname#' AND middlename = '#Form.middlename#' AND lastname = '#Form.lastname#' AND address='#Form.address#' -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 301-405-2545 Phone www.phi.umd.edu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: WOT but important
Bruce, May you a safe and secure round-trip. I'll try to do my part and push for regime-change here at home -- and hopefully the 'gates of hell' will close as our belligerent country moves towards an exit strategy. Peace, Mike "Bruce Sorge" <[EMAIL PROTECTED]> 07/15/2004 10:24 AM Please respond to cf-talk To: CF-Talk <[EMAIL PROTECTED]> cc: Subject:WOT but important Although I have not been a big contributor to this list, I have learned a lot from it. I will have to unsubscribe though for a while since I have just been told that I am going to Iraq with my national guard unit. I am heading out next month for training and then should be in country around January. Thanks to everyone who has helped answer my questions and I look forward to returning and getting more great tips and tricks from this list. Bruce Sorge [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: attribute value...
What is the name of your query? Is it "market"? e.g. select marketStuff ... -mike <[EMAIL PROTECTED]> 07/14/2004 12:44 PM Please respond to cf-talk To: CF-Talk <[EMAIL PROTECTED]> cc: Subject:attribute value... I've got a piece of code... 195 : 196 : market.market >selected>#market.market# 197 : this is generating the CF error.. The value of the attribute query, which is currently "market", is invalid. the query SELECT market, c_marketid, isactive, actionuser, actiondate FROM C_MARKET ORDER BY market returns ALBANY 2 1 0070236 7/13/2004 1:41:15 PM LITTLEROCK 11 0070236 7/13/2004 1:41:00 PM I'm not entirely understanding this error, can someone explain? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: decimal addition
note to self: "Tack on a zero". Thank you! "Barney Boisvert" <[EMAIL PROTECTED]> 07/12/2004 05:27 PM Please respond to cf-talk To: CF-Talk <[EMAIL PROTECTED]> cc: Subject:RE: decimal addition Tack on a zero: 99 + 0.1 Cheers, barneyb [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
decimal addition
I rather sheepishly ask: How does one (anyone!) accomplish this trivial task w/o error: = 99 + .1> Is there a function that I'm missing? - e.g. Thanks in advance, -mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
tree-view tools
Hi all, I'm looking for ideas and experiences about client-side (any 'modern' browser) tree-views with all the bells and whistles. Here's some specifics: The data is organized like... language - business - track - category - group - lesson - objective (its all technical customer training outlines and materials at the ends of the nodes) To start with, we have about 1500 lessons and 7000 objectives (all neatly categorized, grouped, etc.) The goal is to allow anyone within the enterprise (about 20,000 employees with at least a dozen groups doing tech training) to 'borrow' our outlines and content. Likewise, as these groups develop their material they will be able to share their material with others (hopefully adhering to our anal educational standards ;). The business goal is to allow diverse groups to borrow/share training plans (hierarchical outlines) along with training materials (learning objects -- ppt's, flash, sims, sample files,...) that are (for the most part) industry-standard (scorm-compliant). >From a functional point of view, would like to emulate a windows explorer type interface with split-panes and allow drag and drop functionality while enforcing (common sense) business rules and filters (e.g. for all materials available in French Canadian that supports a particular industry or product-specific technology). Or on a more basic level, enforcing business rules that state that you cannot copy a block of lessons and dump then into your 'folder/view/node/...' at the business-level. Lessons can only exist under a category or group. >From an application development perspective, we hope to maximize re-use and thus are interested in a robust, scalable solution. The implementation is open to 'company-standard' technologies which include Java (client & server), Flash, XML, XHTML, DHTML, _javascript_ and, of course, CF 6.1 (planning an upgrade from 5.0 by mid-August). It's also a make vs. buy type of requirement. (or buy a toolkit and go from there...) The end-user goals are pretty simple: ease of use & great performance Finally, (if the corporate-funding stars aligh properly), I will have at least one other developer and a DBA on the project (along with a design team of 4 or 5 -- hey, it's how we develop everything around here). Any ideas or input will be greatly appreciated. Regards, -mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: GMAIL Invite - First request gets it
hullo, your email address is rastafari and you're out [of something that grows on god's green earth] and you will have more in a day or so [more what, pray tell?] 'twas a little joke ;) ;) -mike (ok, i'll stop wondering and get back to work!) [EMAIL PROTECTED] 06/30/2004 03:44 PM Please respond to cf-talk To: CF-Talk <[EMAIL PROTECTED]> cc: Subject:RE: GMAIL Invite - First request gets it Tony Weeg makes me wonder just a little bit [EMAIL PROTECTED] are mine... im out for today, but should havemore in a day or so. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Absolute positioning in word (WAS: CSS layer positioning)
And to add 3 letters that also work for server-side office doc generation ... RTF (rich text format) -mike "Samuel Neff" <[EMAIL PROTECTED]> 06/30/2004 03:28 PM Please respond to cf-talk To: CF-Talk <[EMAIL PROTECTED]> cc: Subject:RE: Absolute positioning in word (WAS: CSS layer positioning) Save it as HTML then you'll see all the HTML needed to generate the same word doc. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: GMAIL Invite - First request gets it
Tony Weeg makes me wonder just a little bit [EMAIL PROTECTED] are mine... im out for today, but should havemore in a day or so. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Absolute positioning in word (WAS: CSS layer positioning)
Hi John, afaik, the native format for a .doc file has always been binary. Coming full-circle here (and now trimming longish threads :) Sandy pointed out the html method, which works better than ever (just looked at a word-2002 doc and it uses style sheets now). I recall some very ugly word generated html in the past. And I re-visited Sam Neff's site (link below) where he covers the pros/cons of the various tools and techniques very nicely! -mike "Burns, John D" <[EMAIL PROTECTED]> 06/30/2004 03:14 PM Please respond to cf-talk To: CF-Talk <[EMAIL PROTECTED]> cc: Subject:RE: Absolute positioning in word (WAS: CSS layer positioning) Hmm, is that new in 2k3? I thought it used to be doable? What about saving a word doc to html and use the code that way? Then the positioning should still be the same. That's very interesting. John > > "Sandy Clark" <[EMAIL PROTECTED]> > > > Easiest way I have seen it done, > > Create your basic template in word. Make sure it works correctly. > > Save to HTML > > Add a to the end sending it back to word. > > Then start making it dynamic with cfloop, etc. > Check out Sam Neff's articles, presentations and demos on his blog > http://www.rewindlife.com > > Hope this helps. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Absolute positioning in word (WAS: CSS layer positioning)
John, when you open a *binary* word doc in notepad, you will stand witness
to a mountain of gibberish or am I missing something here?
-mike
"Burns, John D" <[EMAIL PROTECTED]>
06/30/2004 02:39 PM
Please respond to cf-talk
To: CF-Talk <[EMAIL PROTECTED]>
cc:
Subject:RE: Absolute positioning in word (WAS: CSS layer positioning)
The other option for creating word formatted docs (if it's the same type
of doc over and over...ie. Labels) is to create the doc in word the way
you want it, open the doc in a text editor so you can see all the
formatting and make a cf page that creates something with the exact same
formatting and save it to a file with the extension .doc.
John
-Original Message-
From: Marlon Moyer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 30, 2004 2:32 PM
To: CF-Talk
Subject: Re: Absolute positioning in word (WAS: CSS layer positioning)
Be aware though that this is not something you'd want to have on a
production server. The office products were meant has single user
windowed apps, therefore if you spark an error, the error is usually
displayed on the server screen and focus isn't given back until the "OK"
button is clicked.
YMMV
Marlon
On Wed, 30 Jun 2004 12:20:31 -0400, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
> Or you could use COM to automate the creation of your word docs from
> scratch. You need to have a copy of word loaded on your app (web)
> server & then you can do stuff like this:
>
>
>
NAME="objWord"
> TYPE="COM">
>
>
> NAME="objWord" TYPE="COM">
>
>
>
> then, start cf-scripting stuff like this:
>
> function appendText(instring, alignment, inches, fontname, fontsize,
> fontbold, fontitalic, fontunderline) {
> /* CONVERT INCHES TO POINTS */
> tmpPoints = inches * 72;
> /* GET THE LENGTH OF THE INPUT STRING */
> tmpLen = len(#instring#);
>
> /* GET THE TOTAL NUMBER OF CHARS IN THE DOC */
> tmpDocChars = newDoc.Characters;
> tmpNumChars = tmpDocChars.Count;
> tmpStartRange = tmpNumChars;
> tmpEndRange = tmpNumChars;
> if (tmpStartRange lte 0) { tmpStartRange = 1; }
> if (tmpEndRange lte 0) { tmpEndRange = 1; }
> tmpDocRange = newDoc.Range(tmpStartRange-1,tmpEndRange-1);
>
> /* INSERT THE COPY */
> tmpDocRange.InsertBefore("#instring#");
>
> }
>
> When I worked on this a while ago, www.cfcomet.com was active (they've
> apparently had some ups/downs). Anyhow they were (are?) a great
resource.
> I also used an O'Reilly book (Word Macros by Steven Roman) which
> proved indespensible when trying to figure out the object model.
>
> Hope this helps,
>
> -mike
>
> "Sandy Clark" <[EMAIL PROTECTED]>
> 06/30/2004 11:57 AM
> Please respond to cf-talk
>
> To: CF-Talk <[EMAIL PROTECTED]>
> cc:
> Subject:RE: Absolute positioning in word (WAS: CSS
layer positioning)
>
>
> Easiest way I have seen it done,
>
> Create your basic template in word. Make sure it works correctly.
>
> Save to HTML
>
> Add a to the end sending it back to word.
>
> Then start making it dynamic with cfloop, etc.
> Check out Sam Neff's articles, presentations and demos on his blog
> http://www.rewindlife.com
>
> Hope this helps.
>
> _
>
> From: James Smith
>
> ok, new problem then. Now resigned to using word and having to make
> sure all client machines have it installed.
>
> Now how do I do absolute positioning in word? I have played with
>
> mso-table-anchor-horizontal: 0.7cm;
> mso-table-anchor-vertical: 23cm
>
> On tables but with no success, has anyone done this?
>
> --
> Jay
>
>
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Re: Absolute positioning in word (WAS: CSS layer positioning)
Marlon,
Good point. However, after 2 years and about 1000 (20 page +/-) proposals,
I have only had 1 crash (and although the word-doc generator was running I
attributed the crash to and odbc-access-timeout issue). Shame on me for
running both access and word in a (very light) production environment. I'm
in the process of changing my evil ways and porting to Oracle and...
re-writing the *.doc generator using 'lightweight' methods:
http://codeproject.com/vb/net/Wordyna.asp
http://msdn.microsoft.com/library/default.asp?url="">
(if only I had that Blackstone *.pdf feature!!!)
-mike
Marlon Moyer <[EMAIL PROTECTED]>
06/30/2004 02:31 PM
Please respond to cf-talk
To: CF-Talk <[EMAIL PROTECTED]>
cc:
Subject:Re: Absolute positioning in word (WAS: CSS layer positioning)
Be aware though that this is not something you'd want to have on a
production server. The office products were meant has single user
windowed apps, therefore if you spark an error, the error is usually
displayed on the server screen and focus isn't given back until the
"OK" button is clicked.
YMMV
Marlon
On Wed, 30 Jun 2004 12:20:31 -0400, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
> Or you could use COM to automate the creation of your word docs from
> scratch. You need to have a copy of word loaded on your app (web) server
&
> then you can do stuff like this:
>
>
>
NAME="objWord"
> TYPE="COM">
>
>
> NAME="objWord" TYPE="COM">
>
>
>
> then, start cf-scripting stuff like this:
>
> function appendText(instring, alignment, inches, fontname, fontsize,
> fontbold, fontitalic, fontunderline)
> {
> /* CONVERT INCHES TO POINTS */
> tmpPoints = inches * 72;
> /* GET THE LENGTH OF THE INPUT STRING */
> tmpLen = len(#instring#);
>
> /* GET THE TOTAL NUMBER OF CHARS IN THE DOC */
> tmpDocChars = newDoc.Characters;
> tmpNumChars = tmpDocChars.Count;
> tmpStartRange = tmpNumChars;
> tmpEndRange = tmpNumChars;
> if (tmpStartRange lte 0) { tmpStartRange = 1; }
> if (tmpEndRange lte 0) { tmpEndRange = 1; }
> tmpDocRange = newDoc.Range(tmpStartRange-1,tmpEndRange-1);
>
> /* INSERT THE COPY */
> tmpDocRange.InsertBefore("#instring#");
>
> }
>
> When I worked on this a while ago, www.cfcomet.com was active (they've
> apparently had some ups/downs). Anyhow they were (are?) a great
resource.
> I also used an O'Reilly book (Word Macros by Steven Roman) which proved
> indespensible when trying to figure out the object model.
>
> Hope this helps,
>
> -mike
>
> "Sandy Clark" <[EMAIL PROTECTED]>
> 06/30/2004 11:57 AM
> Please respond to cf-talk
>
> To: CF-Talk <[EMAIL PROTECTED]>
> cc:
> Subject:RE: Absolute positioning in word (WAS: CSS layer
positioning)
>
>
> Easiest way I have seen it done,
>
> Create your basic template in word. Make sure it works correctly.
>
> Save to HTML
>
> Add a to the end sending it back to word.
>
> Then start making it dynamic with cfloop, etc.
> Check out Sam Neff's articles, presentations and demos on his blog
> http://www.rewindlife.com
>
> Hope this helps.
>
> _
>
> From: James Smith
>
> ok, new problem then. Now resigned to using word and having to make
sure
> all client machines have it installed.
>
> Now how do I do absolute positioning in word? I have played with
>
> mso-table-anchor-horizontal: 0.7cm;
> mso-table-anchor-vertical: 23cm
>
> On tables but with no success, has anyone done this?
>
> --
> Jay
>
>
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
RE: Absolute positioning in word (WAS: CSS layer positioning)
Or you could use COM to automate the creation of your word docs from
scratch. You need to have a copy of word loaded on your app (web) server &
then you can do stuff like this:
TYPE="COM">
NAME="objWord" TYPE="COM">
then, start cf-scripting stuff like this:
function appendText(instring, alignment, inches, fontname, fontsize,
fontbold, fontitalic, fontunderline)
{
/* CONVERT INCHES TO POINTS */
tmpPoints = inches * 72;
/* GET THE LENGTH OF THE INPUT STRING */
tmpLen = len(#instring#);
/* GET THE TOTAL NUMBER OF CHARS IN THE DOC */
tmpDocChars = newDoc.Characters;
tmpNumChars = tmpDocChars.Count;
tmpStartRange = tmpNumChars;
tmpEndRange = tmpNumChars;
if (tmpStartRange lte 0) { tmpStartRange = 1; }
if (tmpEndRange lte 0) { tmpEndRange = 1; }
tmpDocRange = newDoc.Range(tmpStartRange-1,tmpEndRange-1);
/* INSERT THE COPY */
tmpDocRange.InsertBefore("#instring#");
}
When I worked on this a while ago, www.cfcomet.com was active (they've
apparently had some ups/downs). Anyhow they were (are?) a great resource.
I also used an O'Reilly book (Word Macros by Steven Roman) which proved
indespensible when trying to figure out the object model.
Hope this helps,
-mike
"Sandy Clark" <[EMAIL PROTECTED]>
06/30/2004 11:57 AM
Please respond to cf-talk
To: CF-Talk <[EMAIL PROTECTED]>
cc:
Subject:RE: Absolute positioning in word (WAS: CSS layer positioning)
Easiest way I have seen it done,
Create your basic template in word. Make sure it works correctly.
Save to HTML
Add a to the end sending it back to word.
Then start making it dynamic with cfloop, etc.
Check out Sam Neff's articles, presentations and demos on his blog
http://www.rewindlife.com
Hope this helps.
_
From: James Smith
ok, new problem then. Now resigned to using word and having to make sure
all client machines have it installed.
Now how do I do absolute positioning in word? I have played with
mso-table-anchor-horizontal: 0.7cm;
mso-table-anchor-vertical: 23cm
On tables but with no success, has anyone done this?
--
Jay
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Re: Blackstone @ CF-FUN '04
Dick, with all due respect, in 1985 my data-comm instructor was all hyped up about this thing on the arpa-net called electronic-mail. Hell she even expected us to wrap our heads around tcp/ip. I sat through her classes and found these limitations: the university wasn't handing out accounts to students [and even if they were] I didn't own a pc [and thus] I didn't have a modem I was happy 'programming' stuff in dBaseIII+ on a 4.77 MHz Zenith Fact is that (as Dave is questioning) there's nothing you've mentioned within the context of this thread (multiple media types, xml, rich user interface, web-connections, etc.) that Director cannot do with aplomb. Yes I'm biased because I made a decent living for nearly 10 years doing many things Director. Hell, thanks to a (formerly) supportive boss & some tech-transfer managers, I have a patent-pending (knowledge-base / whiteboard / app generator thingy) coded (ok - prototyped) in 100% Director. Director is a killer tool that's worthy of more than a reference to a demo from 20 years ago. [jumping off high-horse] So, if you want to learn more, just ask or point your browser to http://www.macromedia.com/software/director/ Best of luck, -mike Dick Applebaum <[EMAIL PROTECTED]> 06/30/2004 10:47 AM Please respond to cf-talk To: CF-Talk <[EMAIL PROTECTED]> cc: Subject:Re: Blackstone @ CF-FUN '04 On Jun 30, 2004, at 6:29 AM, Dave Watts wrote: > Out of curiosity, what can't you do with Director that you need to do > for > your application? > Why, that's Marc Cantor's old program -- saw him demo that years ago at the SF Computer Faire (circa 1985) I sat through the preso and found these limitations 1) Mac and Win only 2) no real good native DB capability 3) orientation wrong for what I want to do It seems that director would be very good to publish a CD/DVD with the results of some of the apps I want to write -- rather than use director to write the apps themselves Dick "You don't get anything clean without getting something else dirty." - Cecil Baxter - [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Duplicate inserts
got code? Joshua OConnor-Rose <[EMAIL PROTECTED]> 06/29/2004 01:07 PM Please respond to cf-talk To: CF-Talk <[EMAIL PROTECTED]> cc: Subject:Duplicate inserts I'm having an issue with duplicate records being created on a single insert (at least on the debugging side) does anybody know of any issues regarding this. Its not the first time I've seen it. I thought I posted this before but it didn't come up on a search. -Joshua O'Connor-Rose -all is Good [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Blackstone @ CF-FUN '04
"Ben Forta" <[EMAIL PROTECTED]> 06/28/2004 11:12 PM Please respond to cf-talk To: CF-Talk <[EMAIL PROTECTED]> cc: Subject:RE: Blackstone @ CF-FUN '04 Flash applications that run on the desktop instead of in a web browser? That's Macromedia Central. -- ** cough cough ** (must be contagious) -- how about a little Macromedia product called Director! :) -- (plays real nice on the desktop, supports nearly everything flash, has XML, ODBC support, and the list goes on.) --mike _ From: Matt Woodward [mailto:[EMAIL PROTECTED] Sent: Monday, June 28, 2004 11:11 PM To: CF-Talk Subject: Re: Blackstone @ CF-FUN '04 >On Jun 28, 2004, at 6:58 PM, Rick Root wrote: > >Oops! > >Spoke too soon -- I was originally talking about non-browser-based GUIs. > >Is there a standalone Flash UI. > >Maybe there should be??? > >RDIAs? > >Rich Desktop Interface Applications You never know--something like this might be in the works. I've heard rumblings at least ... _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: JAVASCRIPT help
function checkForm()
{
var title= document.myForm.title.value;
var story= document.myForm.story.value;
var link= document.myForm.link.value;
var target= document.myForm.target.value;
var fbString = '';
if (title == '')
fbString = fbString + "You must enter a title\n";
if (story == '')
fbString = fbString + "You must enter a story\n";
if (link != '' && target == '')
fbString = fbString + "You must enter a target for your
link\n";
if (fbString != '')
{
alert(fbString);
return false;
}
else
{ return true; }
}
...and in your form
checkForm();">
-mike
Asim Manzur <[EMAIL PROTECTED]>
06/28/2004 03:30 PM
Please respond to cf-talk
To: CF-Talk <[EMAIL PROTECTED]>
cc:
Subject:_javascript_ help
Can someone give me a hand on _javascript_ validation?
I have a form with the following fields
title
story
link
target with the value of "_self" "_blank" and ""
What I want that
"TITLE and STORY should not be empty and if something in the link then
target sould not be empty"
Will appriciate that
Regards,
Asim Manzur
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Re: how to open an attached file in its own application (ms-word, excel etc).. please read
As this issue is ultimately a client-thing, here's what we do (part of a help doc): - right click My Computer - click Explore - click Tools - click Folder Options - click File Types tab - scroll down to .DOC - click Advanced button - make sure Browse in Same Window checkbox is de-selected. hth, -mike cf coder <[EMAIL PROTECTED]> 06/28/2004 05:39 AM Please respond to cf-talk To: CF-Talk <[EMAIL PROTECTED]> cc: Subject:Re: how to open an attached file in its own application (ms-word, excel etc).. please read Hi Guys, I posted this thread on Friday. Can someone please answer my last query. Best regards, cfcoder [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Chr() for a tab?
chr(9) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: JS Issue submit() to CF Form
James, Put POST = #form.fieldnames# NO POST in your action page ... and you will find that it's all good. As my friend/pipefitter told me numerous times this weekend as we were wrangling gas-lines: "I'd rather answer your stupid questions now than fix your stupid mistakes later!" ;) -mike James Blaha <[EMAIL PROTECTED]> 06/21/2004 01:30 PM Please respond to cf-talk To: CF-Talk <[EMAIL PROTECTED]> cc: Subject:JS Issue submit() to CF Form Hello All, I have a really stupid question. Can anyone please send me a html template that auto submits to a cf page that will have the form variable show up properly on the CF template that recieves the POST. Regards, -JB Example:
function login()
{
document.LoginForm.submit();
}
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: About Scoping mostly url and form
Ben Doom wrote: > What do you folks do when you want a variable that can be passed over > form or url? -- make a decision (which does what) & then make 'em mutually exclusive [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Jet 4 ODBC SQL reference?
Claude, You can find a used copy of the m$ jet db engine programmers guide for about $15 http://www.amazon.com/exec/obidos/tg/detail/-/1572313420/qid=1087419761/sr=8-1/ref=sr_8_xs_ap_i1_xgl14/002-2193191-2954402?v=glance&s=books&n=507846 The version I have covers jet 3.5 but the DDL oughtta be much the same. -mike ps - if you do find the 'truth', please share :) Claude Schneegans <[EMAIL PROTECTED]> 06/16/2004 04:44 PM Please respond to cf-talk To: CF-Talk <[EMAIL PROTECTED]> cc: Subject:Jet 4 ODBC SQL reference? Hi, Can some one tell me where I could find an official and complete reference about the SQL syntax used in the Access ODBC driver? For instance, this Microsoft's page: http://msdn.microsoft.com/library/en-us/dnacc2k/html/acintsql.asp Claims the the CREATE TABLE ant ALTER TABLE statement accept DEFAULT values for columns, but the examples given won't work in a query under CF on an Access 2000 database driver... :-( So, where is the truth? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: help for the speed of this query?
Thanks! Jochem van Dieten wrote: http://www.postgresql.org/docs/7.4/static/overview.html -mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: popup from image
Robert Orlini wrote:
...
alt="edit" border="0">
function getArgs() {
var args = new Object();
var query = location.search.substring(1);
var pairs = query.split("&");
for (var i = 0; i < pairs.length; i++) {
var pos = pairs[i].indexOf('=');
if (pos == -1) continue;
var argname = pairs[i].substring(0,pos);
var value = pairs[i].substring(pos+1);
args[argname] = unescape(value);
}
return args;
}
-mike
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: help for the speed of this query?
Jochem van Dieten wrote: "...the query execution plan..." What's a query execution plan? -mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: help for the speed of this query?
John Ho <[EMAIL PROTECTED]> 06/07/2004 11:11 AM Please respond to cf-talk To: CF-Talk <[EMAIL PROTECTED]> cc: Subject:Re: help for the speed of this query? Dov Katz wrote: size(a) x size(b) x size(C) x size(D) x size(E) and only then does it start restricting the results using the WHERE clause I was reading Joe Celko's chapters on trees/hierarchies last week and one small point stuck -- Celko states that performance diminishes when querying 5 or more tables ... now I have a better understanding why (cartesian product). btw, the Celko books are well worth the time/money! http://www.celko.com/books.htm) Also, I just ran a test against a 'normalized' table (setup like 1-1-1-1-1-1-many...) SELECT ObjectivesMaster.Objective, ObjectivesXref.LangId, ObjectivesXref.TrackId, ObjectivesXref.CategoryId, ObjectivesXref.GroupId, ObjectivesXref.TaskId, ObjectivesXref.ObjectiveId, ObjectivesXref.ListOrder, ObjectivesXref.Notes FROM ObjectivesMaster, ObjectivesXref WHERE ObjectivesXref.LangId = #t# AND ObjectivesXref.TrackId = #u# AND ObjectivesXref.CategoryId = #v# AND ObjectivesXref.GroupId = #w# AND ObjectivesXref.TaskId = #x# This took about 200 milliseconds on my 'average' laptop (1 ghz/256mb) running ms access. Currently there are about 7000 records in this ...Xref table and when it goes into production, this particular table will grow to 20K records (or more... and hopefully leveling off before it hits 6 figures!). The target DB is to be Oracle 9i once we fill out more paperwork than a pentagon lawyer (and undergo the interrogation of the IT security analysts ;) I've had the opportunity to rebuild this structure from scratch and have tried to embrace 'normalization' concepts for 2 basic reasons: 1) tighter/easier code and 2) SPEED! I hope some of this is helpful, -mike John Ho wrote: yeah I use either join or innter join like you. And both has same speed 6second. >try this: > >select distinct myFields from >(((A inner join B on B.ID=A.ID) >inner join C on C.ID=A.ID) >inner JOIN D on D.ID=A.ID) >inner join E on E.ID=A.ID > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Get Database Tables, etc
you could use select * from myTable -mike "Robert Shaw" <[EMAIL PROTECTED]> 06/04/2004 11:47 AM Please respond to cf-talk To: CF-Talk <[EMAIL PROTECTED]> cc: Subject:Get Database Tables, etc I know I have seen this on the list before but I can't find the exact code. Does anyone have the code for querying a database and returning a list of tables and/or column info? TIA, Robbie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT - SMTP settings security
Eric, Go to your windows management console, click services/IIS, bring up properties for default SMTP, click the Access tab, click Connection Control (Connection... button) -- choose the "allow only these addresses..." enter the IP addr of your server. -mike I noticed that my Event Log was filling up. Looking at the loggs it appeared someone was trying to use my SMTP to send emails. Naturally I do not want this, however I need to use SMTP to send emails using CFMAIL in some of my web apps. Does anyone know what I need to do set this properly? I am running Windows 2000 server with IIS 5+. I am simply using the default SMTP. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: custom tags on-the-fly
...but the browser is ignoring it as unknown tag -- exactly. (view source confirmed your suspicion as well as mine) ...You want the CFML parser to see that tag and it is not. -- right again. ... I don't know if there is a way to do what you want, -- ah, cfmodule will allow me to effectively (and efficiently enough) allow me to gather up the state of my app and fire off the next template. ...sound a bit off kilter to me. -- Hey, I resemble that statement ;) Take care, Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: custom tags on-the-fly
Thanks Philip, JE & Barney: I love a one-word answer . cfmodule. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
custom tags on-the-fly
Hi, I'm trying to build, evaluate & execute custom tags on the fly by creating a string ( e.g. "" ). After toying with the concept, I'm wondering if a) There's something I simply do not grasp and/or b) This is generally a silly idea and I need to get on with the business of writing some case statements. Here's a few tests & results (using CF 5.0): templateString = #templateString# #templateString# This returns an empty string and doesn't run assign.cfm. As CF doesn't have escape characters, my guess is that CF is "blowing off" a tag that doesn't exist (failsafe thingy?). So then I break out evaluate() whose inner workings I best comprehend through monkey motion (trial and error): evaluate(#templateString#) This evaluates to nothing, null, nada... So I change the hash-marks: #evaluate(templateString)# And CF returns an error (evaluating the _expression_: ) ... at least this is the string that I intended - but not the result. Any input appreciated, Thanks, Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: MS Access as a backend database
Hi David, It depends on many factors: budget, size, infrastructure, security, concurrent users, etc. We've been using Access as a backend db for an internal app for 2 years without a hitch... That is, until 2 weeks ago, after a migration meeting (oracle) with my boss (approved :) -- when we stepped out of the conference room, a user was standing in the hall to show me an error: [S1001 (mem alloc err) ODBC Access driver, bla bla] -- Yes, Access had failed us (and given the timing, I couldn't have been more pleased ;) The site met its goals (helping others make money) and now it's time to move to a *real* database management system. http://www.macromedia.com/support/coldfusion/ts/documents/tn17034.htm http://www.clearform.com/microsoft_access.htm -mike Is this good idea? If not; is there an article I can referance for my managment? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: simple form field question
Try changing '#trim(form.ponumber)#' to '#trim(form.vendor)#'. Watch out! without a WHERE clause your query will change every ponumber to the form value and some poor vendor may get rich quick ;) -mike "Robert Orlini" <[EMAIL PROTECTED]> 05/25/2004 11:11 AM Please respond to cf-talk To: CF-Talk <[EMAIL PROTECTED]> cc: Subject:simple form field question This may be a simple one, but I'm a bit slow this morning...and stumped. I have a form that is populated with a cfquery so a field looks like this: maxlength="30"> How is this then set to another form where an update (cfquery with the SET command) can be done? I try it with the code below but get an error of course because I'm not sending "form.ponumber". Update purchaseorders SET ponumber = '#trim(form.ponumber)#' Thanks. Roberto O. HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Statistics Help
Here's a start... compares non-ms scripting langusges: php, cf & jsp (cf is tops but php is gaining). http://news.netcraft.com/archives/2003/08/30/php_growing_surprisingly_strongly_on_windows.html regards, Mike I am trying to find some stats without any luck. Here are the things I am trying to find out. 1) Number of ISPs using Cold Fusion in their hosting solutions 2) Number of ISPs using ASP.NET in their hosting solutions 3) Number of Small-Medium Ecommerce businesses online 4) General statistics on the web, type of businesses, growth etc.. Does anyone know of a place to find this information, I can't seem to locate it. Thank you Paul Giesenhagen QuillDesign [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Need help with MS Word Automation
Hi Shawn, I have had a .doc generator running under CF5.0 & Word 2000 for more than 1.5 years without a crash. Before settling on a server-side solution, I messed with .dot files on the client side but the potential mess was frightening (getting users to load and manage macros, etc.) The volume has been very low -- 2 or 3 15-page proposals per day & the processing time takes about a minute (w/ nearly 100% cpu utilization). But nonetheless, we successfully pulled this off. I will add that it did take me weeks to get it right -- primarily due to the some pretty tight formatting requirements, self-doubt, etc. It's true that if your script bombs you will end up with multiple copies of winword.exe active. If I recall correctly, you may need to stop the Cold Fusion Application service to release some kind of lock & then kill the multiple instances of winword. I relied heavily on http://www.cfcomet.com (gratefully, they are back online thanks to Mike Dinowitz). Contact me directly and I can provide some samples if you decide to build .doc files on the server from scratch. Best of luck, Mike Shawn Grover <[EMAIL PROTECTED]> 01/09/2004 01:06 PM Please respond to cf-talk To: CF-Talk <[EMAIL PROTECTED]> cc: Subject:Need help with MS Word Automation I am having problems finding information on using Word Automation. What I am trying to do is use CFMX (6.0) to open a MS Word template (.dot file), find the bookmarks in the file, insert data from our database at the bookmark locations, and then save the document as a new file on the server. Once the file has been saved, I need to push it to the client browser (via a UNC path). I think I have the information I need to work with the bookmarks, and know how to push the resulting file to the client. But I'm having problems reliably opening the word.application object. I'm sure this has been done before but am finding very little references i how to do it. Am I just misreading what I have found? Is there some trick that I don't know about? Thanks for any tips. Shawn [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
