RE: CFQUERY: All employees who haven't entered data...

2002-09-30 Thread Angel Stewart
Thanks Al! :) That worked nicely Thank you very much *nod* *nod* I was thinking something else though... can't subqueries take the place of all those different joins then, if one wanted to use them for some reason? -Gel -Original Message- From: Everett, Al [mailto:[EMAIL PROTECTE

RE: more cfstoredproc issues ...

2002-09-30 Thread Costas Piliotis
I know... I saw there was another response in this thread that suggested that you should use AS in your var declarations... Just adding to that... Funny thing I've noticed though that if you don't get the var name right in cfprocparam, it just goes by the order of the variables. You could use

RE: COM help

2002-09-30 Thread Dave Wilson
No problem at all Brian :) I too have the code placed at the end of my COM-related code. I've just noticed, however that you are using the cf_excel2csv tag, which should render the code redundant (although there's no harm in leaving it there). I've pasted some code below for you to look at: ___

RE: QofQ and negative numbers

2002-09-30 Thread Stacy Young
Nevermind! Was a "user" problem :-) -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 12:58 PM To: CF-Talk Subject: QofQ and negative numbers I've got a oracle db query that returns a recordset with an amount column which can sometimes be

RE: Flash for data views : WAS Ben's J2EE Book, now new course t o be offered by MACR

2002-09-30 Thread Rick Faircloth
Got any scholarships, for independent developers? ;o) Rick -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 12:59 PM To: CF-Talk Subject: RE: Flash for data views : WAS Ben's J2EE Book, now new course t o be offered by MACR I am wrapping

RE: Flash for data views : WAS Ben's J2EE Book, now new course to be offered by MACR

2002-09-30 Thread Mike Chambers
Rick, well, we have ton of examples (on DesDev and the DRK) but I believe that you said you do not like to learn via examples. We also have a lot of tutorials on examples on desdev: http://www.macromedia.com/desdev/mx/flash/ http://www.macromedia.com/desdev/mx/coldfusion/ here is what i would

RE: Flash for data views : WAS Ben's J2EE Book, now new course t o be offered by MACR

2002-09-30 Thread Rick Faircloth
Hi, Mark. No, I haven't downloaded and viewed that app, yet. I plan to, and will. Hopefully I can learn something from it. At least it'll probably inspire me to keep struggling! Thanks for the tip! Rick -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent:

Re: OT (kinda) Unix/CFFILE ?

2002-09-30 Thread Chris Norloff
CF runs as userid nobody, so any 7xx permissions for the files and the directories would be adequate. If you want people to be able to access the files outside of CF then make them part of a group, and give the group necessary permissions to the files and directories (such as 77x or 75x). E

RE: Slightly OT: Altering access tables in CF...

2002-09-30 Thread Rick Faircloth
OH, I'm sorry, Brian, I misread your statement. I was reading as altering *info* in Access tables, not altering the table itself in the way you're trying to...haven't done that, so I don't know what's possible...sorry. Rick -Original Message- From: Yager, Brian T Contractor/Sverdrup [ma

RE: UDF Vs CFC (was RE: So many problems with CFC scopes...)

2002-09-30 Thread Benoit Hediard
> Don't you mean www.cflib.org? Yes, sorry (why did i say www.udflib.org...? I don't know, at least it is more clear for the explanation ;). > Question: (dunno if anyone has the answer to this) Do CFC's share methods in > memory, or does each new component created have its own instances of all th

RE: Flash for data views : WAS Ben's J2EE Book, now new course to be offered by MACR

2002-09-30 Thread Mike Chambers
i agree. I was thinking more of static views of data. If you need to sort and filter that data, then there are advantages to using flash. mike chambers [EMAIL PROTECTED] > -Original Message- > From: Raymond Camden [mailto:[EMAIL PROTECTED]] > Sent: Monday, September 30, 2002 10:41 AM >

RE: Flash for data views : WAS Ben's J2EE Book, now new course t o be offered by MACR

2002-09-30 Thread Mike Chambers
i think this is where our disconnect is. I don't see Flash as just an animation tool. I also see it as a development tool to create rich user interfaces, which do not necessarily have to include animation. mike chambers [EMAIL PROTECTED] > -Original Message- > From: Robertson-Ravo, Neil

RE: COM help

2002-09-30 Thread Brian Ferrigno
Hi Dave, Sorry about being a pest but where exactly do you have to place the code you described below? I placed it after the call to the custom tag that creates the csv file. Does it need to be before or wrap around the call? > Thank you very much for the help. Brian -Original Message

RE: Flash for data views : WAS Ben's J2EE Book, now new course t o be offered by MACR

2002-09-30 Thread Ben Forta
I am wrapping an article on just this for next months CFDJ. Also, there will be lots of this type of stuff covered at DevCon next month. --- Ben -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 1:06 PM To: CF-Talk Subject: RE: Flash fo

RE: PLEASE REMOVE ME FROM LIST

2002-09-30 Thread Bruce Sorge
At the bottom of the threads is a link called Unsubscribe. http://www.houseoffusion.com/index.cfm?sidebar=lists -Original Message- From: chappy [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 10:58 AM To: CF-Talk Subject: PLEASE REMOVE ME FROM LIST This is a multi-part messa

RE: SQL command - data encryption

2002-09-30 Thread Joshua Tipton
hash -Original Message- From: Casey C Cook [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 12:53 PM To: CF-Talk Subject: SQL command - data encryption Hello - I was just looking for confirmation that a command in SQL does not exist that will encrypt data while inserting or

RE: Flash for data views : WAS Ben's J2EE Book, now new course t o be offered by MACR

2002-09-30 Thread Mark A. Kruger - CFG
Rick, I like that Trio car company ap better than the broadmoor application. Have you seen that one? It does use a little animation for the drill down engine, but it's got a great examples of both the select box component, calendar component and the "tree" component. -mk -Original Message-

QofQ and negative numbers

2002-09-30 Thread Stacy Young
I've got a oracle db query that returns a recordset with an amount column which can sometimes be a negative value. I then have a QofQ to extract a portion of data that uses SUM(amount)...It appears to be ignoring the fact that some amounts are negative and it's giving me a total as if they're all

Browser forgetting form values

2002-09-30 Thread Chad
IE use to remember the values that you would put into a form after submission. It does not do that any more.. or is it the CF MX server? If you enter data into a form and submit it I have a CFTRY/CFCATCH that catches a database error. If you use the browser Back button the data is gone from the

RE: Flash for data views : WAS Ben's J2EE Book, now new course t o be offered by MACR

2002-09-30 Thread Rick Faircloth
Wish I could figure out how to do that... :o( I'm still trying... Rick -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 11:38 AM To: CF-Talk Subject: RE: Flash for data views : WAS Ben's J2EE Book, now new course t o be offered by MACR A

RE: Flash for data views : WAS Ben's J2EE Book, now new course t o be offered by MACR

2002-09-30 Thread Rick Faircloth
Exactly! -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 11:38 AM To: CF-Talk Subject: RE: Flash for data views : WAS Ben's J2EE Book, now new course t o be offered by MACR Actually, I think it makes a lot of sense. I just needed a form w

PLEASE REMOVE ME FROM LIST

2002-09-30 Thread chappy
This is a multi-part message in MIME format. --=_NextPart_000_0145_01C26880.F11CBC10 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable PLEASE REMOVE ME FROM YOUR MAILING LIST THANKS --=_NextPart_000_0145_01C26880.F11CBC10 Content-Type: t

RE: Flash for data views : WAS Ben's J2EE Book, now new course t o be offered by MACR

2002-09-30 Thread Rick Faircloth
Also, I'm trying to say, that in the business world, "funky and cool" *don't* sell many business apps...functionality and "ease of use" sell more apps... and that's what many of us see as the strength of Flash now... Rick -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMA

SQL command - data encryption

2002-09-30 Thread Casey C Cook
Hello - I was just looking for confirmation that a command in SQL does not exist that will encrypt data while inserting or updating into one field. I could not find anything in SQL book online. For example: UPDATE my_tableA SET encrypt(password) FROM my_tableB Thanks, Casey Cook _

RE: Flash for data views : WAS Ben's J2EE Book, now new course t o be offered by MACR

2002-09-30 Thread Rick Faircloth
I wouldn't expect many of the Flash SOTD's to not use animation to get recognized as "cool." But even Pet Market's use of animation is more functional than eye candy. They move the images into different areas of the screen to make room for new info, not so much to make the app attractive. If t

RE: Adding two fields and displaying in a third

2002-09-30 Thread S . Isaac Dealey
> At 11:22 AM 9/30/02 -0400, Mosh Teitelbaum wrote: >> > onchange="window.document.ExpenseForm.TotalAmount#Line#.value=eval >> > (window.document.ExpenseForm.Mileage#Line#)+eval(window.document. >> > ExpenseForm.CostOfMeals#Line#);" >> >>Add ".value" to the end of the 2 fields you're trying to add

RE: Slightly OT: Altering access tables in CF...SOLVED

2002-09-30 Thread Yager, Brian T Contractor/Sverdrup
thank you all. Randell showed me the error of my ways. I was using () around the column and type. It works well without them! Brian -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 11:38 AM To: CF-Talk Subject: Re: Slightly OT: Alter

Re: Slightly OT: Altering access tables in CF...

2002-09-30 Thread S . Isaac Dealey
Back when I worked with Access regularly I used to do it a lot... You might want to forward the particular query and the error to the list. > I am getting an error when I try to alter an Access table in CF. Has > anyone had any success doing this? > Thanks, > Brian Yager > President - North AL

RE: more cfstoredproc issues ...

2002-09-30 Thread S . Isaac Dealey
> Dude... In your cfprocparam tag, you write this: > > You should write: > > AFAIK, you need the "@" symobol. hmmm... I'll try it, but I've got dozens if not hundreds of stored procedure calls in this app, and none of them use the @ in the dbvarname attribute, and all of them are working (afai

RE: Flash for data views : WAS Ben's J2EE Book, now new course t o be offered by MACR

2002-09-30 Thread Rick Faircloth
I'm not sure by what you mean by "see it in your OS", but it would be similar to using, say Excel. Instead of jumping around to different pages to add, update, delete info, you just type directly in the field and it changes, without having to go to an "Action" page for processing. One screen is

Re: changing the default administrator directory

2002-09-30 Thread Critter
oi C.!! just rename the directory. works for me. -- Critz Macromedia Certified Advanced ColdFusion Developer http://blog.ctzc.com";> Monday, September 30, 2002, 12:28:35 PM, you wrote: TCD> Hello, TCD> Could someone tell me what's required to

RE: changing the default administrator directory

2002-09-30 Thread Bruce Sorge
You need to also change it in the IIS Admin (assuming that you are using IIS), or the web server administration program of the OS you are using. -Original Message- From: Teel, C. Doug [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 10:29 AM To: CF-Talk Subject: changing the d

changing the default administrator directory

2002-09-30 Thread Teel, C. Doug
Hello, Could someone tell me what's required to change the default Coldfusion administrator 4.5/5 location besides changing the directory name. http://xxx..com/CFIDE/administrator/index.cfm to something like: http://xxx.xxx

RE: Ben's J2EE Book, now new course to be offered by MACR

2002-09-30 Thread Kevin Graeme
We're very excited about this class and in the past we've brought in Allaire/MM trainers on-site. Can you tell me who I should be in touch with so that I can arrange for this class being brought in as well? Thanks, Kevin Graeme > -Original Message- > From: Raymond Camden [mailto:[EMAIL P

RE: UDF Vs CFC (was RE: So many problems with CFC scopes...)

2002-09-30 Thread S . Isaac Dealey
> But, in some cases CFCs might be more appropriate than UDF to encapsulate > generic logic : when you need to have an object-oriented logic. > Indeed, the advantage of CFCs over UDFs is their ability to have (or > simulate) an 'object-oriented/object-based' behaviour. > For example, CFC are great

RE: Flash for data views : WAS Ben's J2EE Book, now new course t o be offered by MACR

2002-09-30 Thread Ben Forta
Neil, Sure you will, as soon as Microsoft discounts most of the cost of Office and Word considering what percentage of its features that are actually used, and as soon as MM discounts CF considering 90%+ of usage is 5 tags (hey, we DID discount CF, oops! ) ... I don't think anyone here is sayin

RE: CFFILE PDF to Sybase?

2002-09-30 Thread CAROSATI Gerald
And the viewer.cfm page: PT_Attachments 'GET', 'ID', '#url.ID#' Attachments Viewer -Original Message- From: CAROSATI Gerald [SMTP:[EMAIL PROTECTED]] Sent: 30 September 2002 17:59 To: CF-Talk Subj

RE: CFFILE PDF to Sybase?

2002-09-30 Thread CAROSATI Gerald
Sorry here is the AddFile.cfm page: Append File sub window_onload window.close end sub

RE: COM help

2002-09-30 Thread Dave Wilson
Brian, Although I've experienced pretty much what you describe, I've never seen the process actually killing the CF Service itself. To fix the problem of inactivity in the excel part of the process on subsequent attempts, use the following: Which should help to kill any locked connections to

RE: Slightly OT: Altering access tables in CF...

2002-09-30 Thread Yager, Brian T Contractor/Sverdrup
Did you have to do anything special? Here is my SQL Alter table index_tbl add(pic_pos number) I've also tried with number(1) but still doesn't work. Brian -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 11:19 AM To: CF-Talk Subject:

OT Xopus

2002-09-30 Thread Richard Meredith-Hardy
Further to an item on this list about content management a week or two ago, http://xopus.org looks rather clever, but very thin on working examples. Has anyone got a simple working example which saves edited data via CF that I could try? Other comments welcome (this is rather OT so probably of

RE: Slightly OT: Altering access tables in CF...

2002-09-30 Thread Rick Faircloth
No problem here...CF 4.5.2, Access 2000 Rick -Original Message- From: Randell B Adkins [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 11:02 AM To: CF-Talk Subject: Re: Slightly OT: Altering access tables in CF... Yes >>> [EMAIL PROTECTED] 09/30/02 10:57AM >>> I am gettin

RE: Flash for data views

2002-09-30 Thread Haggerty, Mike
Just to add a point about the learning curve... Actionscript and javascript are very close cousins. Many javascript programmers I know have been able to pick up Actionscript with minimal effort - the main conceptual difference is the time itself is an event in Flash, and you need to account for it

Problems with CFGRAPH accuracy

2002-09-30 Thread Rebecca _Becky_ Brewer
Hi all, I'm having this fun problem with a CFGRAPH tag in CF 5 that's driving me a bit crazy this morning. My code is calculating the sales average for the users' state vs. the national sales average for the same time period, and assigning these to local variables named #salesAvg# and #allSalesA

RE: CFFILE PDF to Sybase?

2002-09-30 Thread CAROSATI Gerald
Hi there ... Here is an exemple using sql server ... Save page: <> Viewer Page: <> for the save page, I pass a URL variable (ponumber) which contains the ID of the record to save The SQL syntax will obviously have to be modified since I did it for SQL server ... for the viewer the trick

RE: Flash for data views : WAS Ben's J2EE Book, now new course t o be offered by MACR

2002-09-30 Thread Robertson-Ravo, Neil (REC)
OK then, will I get a super discount on Flash from MM - say 98% as I am only going to use 2% of its features? :-) nah, didnt think so.. N -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: 30 September 2002 16:38 To: CF-Talk Subject: RE: Flash for data views : WA

Re: error with a piece of cfscript code and I can't see what's wrong?

2002-09-30 Thread S . Isaac Dealey
You've either got an extra ( before the 2nd IsDefined("form.residents") or are missing a ) after it... If (NOT IsDefined("Form.business_types") AND (IsDefined("Form.residents")) { session.ResidentsOnly = yes; > ***

Setting a VARIANT_BOOL COM attribute from CF

2002-09-30 Thread Brian Panulla
I'm trying to use a VC++ COM object that has some VARIANT_BOOL attributes from ColdFusion via CFOBJECT. No matter what value I set the attribute to (1, 1.0, -1, -1.0, 0, true), it's always FALSE. Double/Int/Float parameters and methods work just fine. Is this a variable typing/casting issue? A

RE: Flash for data views : WAS Ben's J2EE Book, now new course t o be offered by MACR

2002-09-30 Thread Raymond Camden
> Actually, I think it makes a lot of sense. > > I just needed a form with side by side list boxes, make a selection in > one and the second is populated with selections that change based on > what was selected in the first. Try doing that simply and > easily in HTML > (without screen refreshes)

COM help

2002-09-30 Thread Brian Ferrigno
I need help tracking down an error in using CFOBJECT to create a csv file from an excel spreadsheet. I am using CF to open up an excel spreadsheet and then trying to turn the data into a csv file. The code i'm using works fine the first time the application is launched but on subsequent tries no

RE: Adding two fields and displaying in a third

2002-09-30 Thread Thane Sherrington
At 11:22 AM 9/30/02 -0400, Mosh Teitelbaum wrote: > > onchange="window.document.ExpenseForm.TotalAmount#Line#.value=eval > > (window.document.ExpenseForm.Mileage#Line#)+eval(window.document. > > ExpenseForm.CostOfMeals#Line#);" > >Add ".value" to the end of the 2 fields you're trying to add, as in

RE: Flash for data views

2002-09-30 Thread Ben Johnson
All, I've been doing Flash apps for a while now and I wanted to put in a couple cents to this thread about my experience. I would like to agree with Ray and Mike on a lot of their points. Flash does not necessarily equal more time. It has a learning curve no doubt, but so does HTML/CFML

Problems with CFGRAPH accuracy

2002-09-30 Thread Rebecca _Becky_ Brewer
Hi all, I'm having this fun problem with a CFGRAPH tag in CF 5 that's driving me a bit crazy this morning. My code is calculating the sales average for the users' state vs. the national sales average for the same time period, and assigning these to local variables named #salesAvg# and #allSalesA

RE: CFLOCATION to external sites - failure

2002-09-30 Thread Cornillon, Matthieu
Hi, all. I'm afraid that this isn't the problem. The addresses are indeed fully qualified. I have rewritten the CFLOCATION tag several times from scratch to be sure I have no typos. I have cut and pasted the exact URL string from the CFLOCATION url attribute to a browser's address bar (on the

RE: Flash for data views : WAS Ben's J2EE Book, now new course t o be offered by MACR

2002-09-30 Thread Ben Forta
Actually, I think it makes a lot of sense. I just needed a form with side by side list boxes, make a selection in one and the second is populated with selections that change based on what was selected in the first. Try doing that simply and easily in HTML (without screen refreshes). Flash, ColdF

[no subject]

2002-09-30 Thread Rebecca _Becky_ Brewer
Hi all, I'm having this fun problem with a CFGRAPH tag in CF 5 that's driving me a bit crazy this morning. My code is calculating the sales average for the users' state vs. the national sales average for the same time period, and assigning these to local variables named #salesAvg# and #allSalesA

Re: Flash for data views : WAS Ben's J2EE Book, now new course to be offered by MACR

2002-09-30 Thread S . Isaac Dealey
> If all you are doing is presenting data to the user with no interaction, > then there is not much advantage to using Flash. However, if the users > interacts with that data in any way, then there are advantages. Namely, > the fact that the entire page will not need to be refreshed to update > th

RE: Verity operators - THESAURUS, TYPO, SOUNDEX

2002-09-30 Thread Adam Reynolds
Ray, This is gonna get very verity focused. In principle can I create my own 'locales' for use with my own file sets. In effect I could copy the english locale, then create a new local called 'awkwardcustomer'. Reverse engineer the vdk20.syd (the english thesaurus file) using mksyd -locale -dump

Using the Verity Engine on non-cf apps

2002-09-30 Thread Bruce Sorge
If you have CFMX and .net apps running on the same server, is it possible to use the K2 Verity engine on the .net apps, or does this require one to purchase and install the K2 product? Thanks, Bruce __ Structure your ColdFusio

RE: Locking

2002-09-30 Thread S . Isaac Dealey
Again, I've had good experiences with this technique... Here's an example: Within the mylibrary.cfm file, all my user-defined functions are coppied into the request.udf structure. This allows me to cache them in the application sco

RE: Flash for data views : WAS Ben's J2EE Book, now new course t o be offered by MACR

2002-09-30 Thread Robertson-Ravo, Neil (REC)
Oh and to add...you have a look at all the examples and SOTD etc.. and you see how many are cool, and have aninamation etc (I woudl say 100%) this is where the npower lies, but not everyone has this power.. funky and cool sells apps, there is nothing wrong with that, but on a whole; its beyon

RE: Adding two fields and displaying in a third

2002-09-30 Thread Pascal Peters
You didn't get the value, but the object: -Original Message- From: Thane Sherrington [mailto:[EMAIL PROTECTED]] Sent: maandag 30 september 2002 17:04 To: CF-Talk Subject: Adding two fields and displaying in a third I'm writing a form that allows a person to fill in the mileage and mea

RE: Adding two fields and displaying in a third

2002-09-30 Thread Turetsky, Seth
forgot the .values on the end of each var, that's why it was putting in [object], should work now. -Original Message- From: Turetsky, Seth Sent: Monday, September 30, 2002 11:19 AM To: '[EMAIL PROTECTED]' Subject: RE: Adding two fields and displaying in a third thane, it's trying to c

RE: Adding two fields and displaying in a third

2002-09-30 Thread Mosh Teitelbaum
> onchange="window.document.ExpenseForm.TotalAmount#Line#.value=eval > (window.document.ExpenseForm.Mileage#Line#)+eval(window.document. > ExpenseForm.CostOfMeals#Line#);" Add ".value" to the end of the 2 fields you're trying to add, as in: ...=eval(window.document.ExpenseForm.Mileage#Li

RE: Flash for data views : WAS Ben's J2EE Book, now new course t o be offered by MACR

2002-09-30 Thread Robertson-Ravo, Neil (REC)
It depends, yeah sure its 'cool', but do you really gain from using a flash movie? sure, you get the movie in the browser window and you dont have to reload the page persay - but you still have to load the information into the movie and this effectively is your page load. Multiple Page operation

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: CFMAIL problems

2002-09-30 Thread Gyrus
- Original Message - From: "Everett, Al" <[EMAIL PROTECTED]> > Did you check to see if any of their customers are in the database twice? --- Thanks for the idea, but no, there don't appear to be any duplicate customer accounts in the DB. Still waiting for a peek at

RE: Adding two fields and displaying in a third

2002-09-30 Thread Turetsky, Seth
thane, it's trying to concatenate them instead of adding, try something like this(forcing the values into numbers then adding them): hth -seth -Original Message- From: Thane Sherrington [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 11:04 AM To: CF-Talk Subject: Adding two

RE: error with a piece of cfscript code and I can't see what's wr ong?

2002-09-30 Thread Adams, Stephen
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Thanks Bryan, it's working fine now. -Original Message- From: Bryan F

Re: error with a piece of cfscript code and I can't see what's wrong?

2002-09-30 Thread Jochem van Dieten
Comment inline: If (NOT IsDefined("Form.business_types") AND IsDefined("Form.residents")) { // "(" removed session.ResidentsOnly = yes; // Don't you need quotes around this yes? } Else { If (NOT IsDefined("Form.residents")) AND (IsDefined("Form.business_type")) { // "(" removed se

RE: error with a piece of cfscript code and I can't see what's wrong?

2002-09-30 Thread Mike Townend
It could be that your if's are not using one bracket set for the entire check.. i.e. You haveif () AND () { Try changing them to if (() AND ()) { And see if that helps... HTH -Original Message- From: Adams, Stephen [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 1

RE: more cfstoredproc issues ...

2002-09-30 Thread Costas Piliotis
Dude... In your cfprocparam tag, you write this: mailto:[EMAIL PROTECTED]] Sent: Sunday, September 29, 2002 6:34 PM To: CF-Talk Subject: more cfstoredproc issues ... Argh! I have a stored procedure with parameters as: CREATE PROCEDURE tap_adLibUpdate @LibraryID int, @Ident

RE: Flash for data views : WAS Ben's J2EE Book, now new course t o be offered by MACR

2002-09-30 Thread Rick Faircloth
Neil, do you see any advantage to "one-page" data presentation and maintenance interfaces as opposed to multiple-page interfaces? Rick -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 10:57 AM To: CF-Talk Subject: RE: Flash

RE: error with a piece of cfscript code and I can't see what's wrong?

2002-09-30 Thread Ben Doom
: Can anyone see what's wrong with this: : : : If (NOT IsDefined("Form.business_types") AND : (IsDefined("Form.residents")) { : session.ResidentsOnly = yes; : } On the next line, you're closing the if clause and then tryin

RE: error with a piece of cfscript code and I can't see what's wrong?

2002-09-30 Thread Bryan F. Hogan
P.S. Your if and else if should look like this. if (not isdefined('form.business_types') and isdefined('form.residents')) not like if (NOT IsDefined("Form.business_types") AND (IsDefined("Form.residents")) You where closing your if statement and then trying to continue it, hope that makes sin

Re: CFQUERY: All employees who haven't entered data...

2002-09-30 Thread Alex
use subquery. either NOT IN or WHERE NOT EXISTS On Mon, 30 Sep 2002, Angel Stewart wrote: > Hey all, > > Is there a simple SQL statement that would allow me to select all the > employees...or all the EmpIds that are NOT in the Master table.. > > So I have tblEmployees and tblMaster. > > Basicall

Adding two fields and displaying in a third

2002-09-30 Thread Thane Sherrington
I'm writing a form that allows a person to fill in the mileage and meal expense, and then displays the total in a third field. I'm using this in the meals expense field: But the third field evaluates to [object][object]. How do I get this to add up? T

RE: error with a piece of cfscript code and I can't see what's wrong?

2002-09-30 Thread Bryan F. Hogan
Below is the corrected code, you had a few extra "("s in front of your isdefined If (NOT IsDefined("Form.business_types") AND IsDefined("Form.residents")) { session.ResidentsOnly = yes; } Else If (NOT IsDefined("Form.residents") AND IsDefined("Form.business_type")) { session.Bus

Re: Slightly OT: Altering access tables in CF...

2002-09-30 Thread Randell B Adkins
Yes >>> [EMAIL PROTECTED] 09/30/02 10:57AM >>> I am getting an error when I try to alter an Access table in CF. Has anyone had any success doing this? Thanks, Brian Yager President - North AL Cold Fusion Users Group http://www.nacfug.com Sr. Systems Analyst Sverdrup/CIC [EMAIL PROTECTED] (

RE: error with a piece of cfscript code and I can't see what's wr ong?

2002-09-30 Thread Adams, Stephen
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** It's alright I've seen the error, it's been a very long day. -Original Me

RE: Flash for data views : WAS Ben's J2EE Book, now new course to be offered by MACR

2002-09-30 Thread Rick Faircloth
Hi, Mike. Your work sounds exactly like what I'm trying to make happen. Any resources you would point me to, to get an Intermediate CF coder familiar enough with Flash Remoting, especially ActionScript, to create some "one-page" apps? Rick -Original Message- From: Mike Chambers [mailto

Re: error with a piece of cfscript code and I can't see what's wrong?

2002-09-30 Thread Jerry Johnson
And which line is line 67? >>> [EMAIL PROTECTED] 09/30/02 10:55AM >>> ** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Can any

RE: CFQUERY: All employees who haven't entered data...

2002-09-30 Thread Everett, Al
Use a subquery: SELECT tblEmployees.EmpName, tblEmployees.DeptID FROM tblEmployees WHERE tblEmployees.ID NOT IN ( SELECT tblMaster.empid FROM tblMaster

RE: Reverse PDF tools

2002-09-30 Thread Hugo Ahlenius
Using the ghostscript you should be able to dump each page to a graphical file format (of your choice). To get the text - you can use the xpdf kit (which includes a pdftotext) util. But I don't think you can get to HTML easily though... :( Adobe has such a service though: http://www.adobe.com/p

RE: Ben's J2EE Book, now new course to be offered by MACR

2002-09-30 Thread Kevin Graeme
Let me just say that I'm very excited about this class. My background is interface design, but it's the code side that I want to sit down and learn. A code-centric class will be extremely welcome. I'll be looking forward to the announcement. Animation vs programming is a non-issue. For web sites

Slightly OT: Altering access tables in CF...

2002-09-30 Thread Yager, Brian T Contractor/Sverdrup
I am getting an error when I try to alter an Access table in CF. Has anyone had any success doing this? Thanks, Brian Yager President - North AL Cold Fusion Users Group http://www.nacfug.com Sr. Systems Analyst Sverdrup/CIC [EMAIL PROTECTED] (256) 842-8342 ___

RE: Flash for data views : WAS Ben's J2EE Book, now new course t o be offered by MACR

2002-09-30 Thread Robertson-Ravo, Neil (REC)
so you are using an animation tool and doing no an animation? I may just be a tad blinkered, but its like using IE to browser text files and not HTML doesnt make sense... -Original Message- From: Mike Chambers [mailto:[EMAIL PROTECTED]] Sent: 30 September 2002 15:35 To: CF-Talk Su

error with a piece of cfscript code and I can't see what's wrong?

2002-09-30 Thread Adams, Stephen
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Can anyone see what's wrong with this: If (NOT IsDef

CFQUERY: All employees who haven't entered data...

2002-09-30 Thread Angel Stewart
Hey all, Is there a simple SQL statement that would allow me to select all the employees...or all the EmpIds that are NOT in the Master table.. So I have tblEmployees and tblMaster. Basically I want to display all the bad bad people that did not enter their time for a specific period...an exce

RE: Running ColdFusion MX as specific user

2002-09-30 Thread Dave Watts
> I am trying to get ColdFusion MX to run under a specific > user account. As long as that user is a memeber of the > administrator group, it seems to run fine. In CF5 you had > to set specific access rights on the registry and the file > system as described in KB 11859, however we cannot find

RE: Reverse PDF tools

2002-09-30 Thread Haggerty, Mike
If you are looking to do this manually, I like to use Adobe Illustrator to change the PDF to EPS, save the images and then resize / output them in Photoshop. I have no idea of what tool you would use to automate this process. M -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAI

RE: Verity operators - THESAURUS, TYPO, SOUNDEX

2002-09-30 Thread Will Swain
lovely...thanks Ray w -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: 30 September 2002 15:18 To: CF-Talk Subject: RE: Verity operators - THESAURUS, TYPO, SOUNDEX They were in CF5 as well. ===

RE: Help attaching a dynamic pdf to an email

2002-09-30 Thread Mosh Teitelbaum
It's been a few years since I had to work with FDFs so forgive me if my info is a bit off, but... my understanding is that you don't need to attach the PDF, just the FDF. Note the line in the FDF that begins with "/F." It indicates a URL from where the PDF can be downloaded. What should happen

RE: Flash for data views : WAS Ben's J2EE Book, now new course to be offered by MACR

2002-09-30 Thread Raymond Camden
> > If all you are doing is presenting data to the user with no > interaction, > then there is not much advantage to using Flash. However, if the users > interacts with that data in any way, then there are > advantages. Namely, > the fact that the entire page will not need to be refreshed to up

Reverse PDF tools

2002-09-30 Thread Mark A. Kruger - CFG
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 reverse? I need to unpack a PDF page into source images and text. Anyone? -mk _

Flash for data views : WAS Ben's J2EE Book, now new course to be offered by MACR

2002-09-30 Thread Mike Chambers
> -Original Message- > From: Robertson-Ravo, Neil (REC) > I like Flash, dont get me wrong, but if all you are doing it > linking to a DB > for a static form or grid etc, then you may as well use HTML > and no I am not > anti Flash Remoting - far from it, I just dont see the > business

RE: Verity operators - THESAURUS, TYPO, SOUNDEX

2002-09-30 Thread Raymond Camden
They were in CF5 as well. === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -Original Message- > From: Wil

RE: UDF Vs CFC (was RE: So many problems with CFC scopes...)

2002-09-30 Thread Benoit Hediard
>I can hazard good guesses, but what do you mean by "view, controller and > model" layers? Ooops... sorry. It refers to the MVC pattern : Model View Controller. - View : the presentation layer (there is usually a HTML-based view layer generated by CFML pages), - Controller : the application flow

RE: Ben's J2EE Book, now new course to be offered by MACR

2002-09-30 Thread Rick Faircloth
Personally, I think that once this new paradigm of Flash Remoting is known by the person with enough vision and skills, new interface tools will be created that will do what Flash does in DB connectivity without the baggage that Flash brings from its beginning as a complicated and work-intensive g

RE: Verity operators - THESAURUS, TYPO, SOUNDEX

2002-09-30 Thread Will Swain
Are these available with CF5 too, or are they new to MX? will -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: 30 September 2002 13:29 To: CF-Talk Subject: RE: Verity operators - THESAURUS, TYPO, SOUNDEX They are available - you don't need to do anything special

<    1   2   3   >