Any MM people here?

2004-05-28 Thread Don
Hi, MM site does not seem to have a clear link that would accept my following request. My client needs to upgrade his CF5.0 Professional Edition on Japanese OS to CF5.0 Enterprise Edition for Japanese OS.  How do we go about this?  Please advise asap. No CFMX, there's a third party tool tied to t

CF Help System and/or FAQ system

2004-05-28 Thread Jake
Does anyone know of any good (hopefully free) CF applications or tags for handling a Web site's help functions? Could be as simple as a FAQ tag or as robust as a full blown help app. Thanks in advance for any suggestions/recommendations! Jake -- BlogFusion - www.countersinkdg.com [Todays Thre

CFLogin & AD

2004-05-28 Thread Eric Hoffman
Ok, I have followed several tutorials for CFLogin against active directory, and no matter what it just goes to (*(* on me. I always get this: Invalid CFML construct found on line 10 at column 1. on /hzc/manage.cfm DIAGNOSTIC: Invalid CFML construct found on line 10 at column 1. ColdFusion was lo

Re: CF-Mail merge application

2004-05-28 Thread Karl Simanonok
Your problem is similar to one that I've tried to solve before: storing CF code in a database that gets executed at runtime from query output without ever having the code written to a file.  Wouldn't that be great?  But if that's possible, I sure haven't figured out how to do it yet. A slightly

Lookup senators and representatives

2004-05-28 Thread Al Musella, DPM
I have to program a letter writing campaign to senators and representatives.  What is the best way to look up the names and addresses of the senators and representatives?  Is there a web service that can help?    There is a way to look it up at http://www.senate.gov/general/contact_information/s

Re: calling on Flash to create a file

2004-05-28 Thread John Dowdell
At 3:22 PM 5/28/4, Frank Dewey wrote: >I am using Flash (although I should be going home!) to talk to >ColdFusion that connects to a database. All works well as far as updates >and inserts, ...). However I would like for my application to also be >able to create a file. Think about where the thing

calling on Flash to create a file

2004-05-28 Thread Frank Dewey
Hello, I am using Flash (although I should be going home!) to talk to ColdFusion that connects to a database. All works well as far as updates and inserts, ...). However I would like for my application to also be able to create a file. I've created a tree and when you click on a menuItem, then a

Re: Mach-II

2004-05-28 Thread Claude Schneegans
>>The statement merely illustrates a capability of OO ... A particularity, otherwise one would not talk of it. If you can do it with any language, which is the case, why mention it ? Do you see advertised "At Hilton Hotels, one can rent rooms for night" ? ;-)) If this is the way people read, no

RE: Adding a timestamp to images

2004-05-28 Thread Marlon Moyer
Well, just in case anyone else needs to figure this out.  I read an article by our own esteemed Matt Liotta and another article that showed a Java command line program that explained drawing text on images using Java.  With this info in hand, I created the following class: import java.awt.*; impor

RE: CFMAIL... won't.

2004-05-28 Thread Ian Skinner
Is it not getting sent, or is it not getting received?  I am not an expert, but I've read several threads on this list that e-mail from CF Servers is tagged as spam by many filter systems.  Could this be a possibility?  The message is getting blocked/re-routed by some kind of spam filter? Confiden

RE: CFMAIL... won't.

2004-05-28 Thread Dave Watts
> Using CFMX under JRun 4 on Solaris 9. > > I've got a Cold Fusion script which uses the CFMAIL function > to send the results of a quiz to an instructor.   > Unfortunately, no matter what I do, I can't get the mail to > go through.  I've checked that I'm using the proper syntax > for CFMAIL, t

CFMX: Insert CDATA via the XML DOM...

2004-05-28 Thread Dan Switzer
Using CFMX, how can you insert CDATA into an element using CFMX's "DOM". The following does not work: oNode.xmlChildren[1] = xmlElemNew(oXml, "description"); oNode.description.xmlValue = ""; The xmlValue property does nothing at all. If you use the xmlText property, it escapes the text. Is there

CFMAIL... won't.

2004-05-28 Thread Richard Crawford
Using CFMX under JRun 4 on Solaris 9. I've got a Cold Fusion script which uses the CFMAIL function to send the results of a quiz to an instructor.  Unfortunately, no matter what I do, I can't get the mail to go through.  I've checked that I'm using the proper syntax for CFMAIL, that my mail ser

Re: Strange error with NULLS

2004-05-28 Thread Jochem van Dieten
Ian Skinner wrote: >   > My question is will a value be a date object if it is a form field passed to a CFC method as an argument that is specified as a date? It is not really a date object (CF is a typeless language :-) but the specification as date will make sure it can be interpreted as one.

Re: DUPLICATES (MIKE DINOWITZ PLEASE READ)

2004-05-28 Thread Michael Dinowitz
I'll check it out. As a side note, you can always email me directly or call me at home (718) 951-3235 if there's a problem that you think needs my immediate attention. That being said, please move all comments, well wishes, etc. over to CF-Community or personal email. Thanks > mike, > > it appear

Re: Strange error with NULLS

2004-05-28 Thread Deanna Schneider
Hm... Typically, I use varchar params for my dates with Oracle, nulls seem to work for them. Only caveat is  you have to format the date correctly for your db. -d - Original Message - From: "Ian Skinner" >> I was just wondering if anybody knew any details about this apparent bug involvin

RE: Strange error with NULLS

2004-05-28 Thread Ian Skinner
If arguments.KCC_OCCUR_DTE is a date object it is not needed anyway: I am off to give the suggestion of removing the createODBCdate a try, I hadn't noticed that part (that was not the most easily readable error message). My question is will a value be a date object if it is a form field pas

Re: Strange error with NULLS

2004-05-28 Thread Jochem van Dieten
Ian Skinner wrote: > Anybody have experience with something like this throwing an error. > > > > Creates the following error: > java.lang.NullPointerException at coldfusion.runtime.OleDateTime.(OleDateTime.java:23) at coldfusion.runtime.OleDate.(OleDate.java:14) at coldfusion.runtime.CFPage.Crea

Re: DUPLICATES (MIKE DINOWITZ PLEASE READ)

2004-05-28 Thread Charlie Griefer
my wife works for a bank and doesnt have Monday off (she's in phone banking... 24/7/365).  but she does get time-and-a-half :) - Original Message - From: "Ian Skinner" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, May 28, 2004 12:49 PM Subject: RE: DUPLICATES (MIKE D

RE: DUPLICATES (MIKE DINOWITZ PLEASE READ)

2004-05-28 Thread Michael Haggerty
This message is severely off topic. Please move to CF-COMMUNITY. M This message is severely off topic. Please move to CF-COMMUNITY. M Ian Skinner <[EMAIL PROTECTED]> wrote: who in the us doesn't have off Monday? even govt has off that day?  right? outta here... Government and Banks are the

RE: DUPLICATES (MIKE DINOWITZ PLEASE READ)

2004-05-28 Thread Tony Weeg
ur correct, but isnt it also a day to honor all those who serve and have served as well? I KNOW OT, sorry. im done. later. tw -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Friday, May 28, 2004 3:50 PM To: CF-Talk Subject: RE: DUPLICATES (MIKE DINOWITZ PLEASE

RE: DUPLICATES (MIKE DINOWITZ PLEASE READ)

2004-05-28 Thread Barney Boisvert
> cya, have a great weekend, tim heald if your reading this > good luck, you are > why > we have Monday off! Actually, Memorial Day is to honor those who died for our country. Hopefully Tim will never need to be honored on this day. Cheers, barneyb > -Original Message- > From: Tony We

RE: DUPLICATES (MIKE DINOWITZ PLEASE READ)

2004-05-28 Thread Ian Skinner
who in the us doesn't have off Monday? even govt has off that day?  right? outta here... Government and Banks are the types that are guaranteed to have Monday off.  I don't know about members of this list.  But people who my not have Monday off are Hospital/Emergency workers, restaurant, hotel, s

RE: DUPLICATES (MIKE DINOWITZ PLEASE READ)

2004-05-28 Thread Tony Weeg
h another person on here was getting dupes too...guess they were a fluke? who in the us doesn't have off Monday? even govt has off that day?  right? outta here... cya, have a great weekend, tim heald if your reading this good luck, you are why we have Monday off! tw -Original Message-

RE: DUPLICATES (MIKE DINOWITZ PLEASE READ)

2004-05-28 Thread Philip Arnold
> From: Tony Weeg > > it appears that there are duplicates going out to the list > today. some people are getting duplicates, others are not, > from what I have gathered so far. > > or am I just crazy, and its Friday, and I should just go home? I'm not seeing double posts double posts [Today

RE: DUPLICATES (MIKE DINOWITZ PLEASE READ)

2004-05-28 Thread Ian Skinner
or am I just crazy, and its Friday, and I should just go home? ...tony Go Home!  ;-)  If you can. You are crazy, everybody is to some extent IMO.  It is a Friday before a three day weekend, assuming you live in the United States and work for a company that gives Memorial Day off.  I do, so YEA

RE: More on Invoices

2004-05-28 Thread Sandy Clark
I have had problems with IE on the following: page-break:avoid. widows: orphans: @page{} page:   _   From: Barney Boisvert Page breaks work happily in IE.  I don't know what else falls into "whole part of CSS 2", but at least that piece will work. Cheers, barneyb > -Original Messa

Re: Adding a timestamp to images

2004-05-28 Thread George Abraham
Hold on, after re-reading your post, my reply is assuming you already have the image on hand. If not, ignore my post. George At 03:28 PM 5/28/2004, George Abraham wrote: >Try ImageMagick http://www.imagemagick.org/. Really simple and there is >also somewhere a CF tag for manipulating it. > >Geor

DUPLICATES (MIKE DINOWITZ PLEASE READ)

2004-05-28 Thread Tony Weeg
mike, it appears that there are duplicates going out to the list today. some people are getting duplicates, others are not, from what I have gathered so far. or am I just crazy, and its Friday, and I should just go home? ...tony tony weeg senior web applications architect navtrak, inc. www.navt

Re: Adding a timestamp to images

2004-05-28 Thread George Abraham
Try ImageMagick http://www.imagemagick.org/. Really simple and there is also somewhere a CF tag for manipulating it. George At 03:16 PM 5/28/2004, Marlon Moyer wrote: >I trying to create a task that will download an image from a webcam and >then put the current timestamp the image.  So far I can

RE: Strange error with NULLS

2004-05-28 Thread Ian Skinner
I knew somebody was going to get that after I saw what I had sent.  Yes, I am always sending NULLS in the code I provided, I was testing to see if I could send a NULL at all.  The problem is whether I conditionally or implicitly try to send a null through the , I get the error enclosed in my origin

Adding a timestamp to images

2004-05-28 Thread Marlon Moyer
I trying to create a task that will download an image from a webcam and then put the current timestamp the image.  So far I can download the image :-)  I'm not real knowledgeable about Java, but that seems to be the direction I need to go.  Has anybody already figured out how to do this?  Thanks -

SUM/Convert string numeric data

2004-05-28 Thread hammerin hankster
I'm doing a DATEDIFF on a range of times and then displaying the result wiht a VAL function to convert the minutes to hour increments: DATEDIFF('n', confhrsfrom, confhrsto) AS no_of_minute #Val(no_of_minute) / 60# However, I need to total the column of minutes but since it's not a numeric value,

Re: SUM column data

2004-05-28 Thread hammerin hankster
>You may find this useful: > >http://www.macromedia.com/devnet/mx/coldfusion/articles/cfqueryparam.html Dave, Thanks for the pointer.  Very good article. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: More on Invoices

2004-05-28 Thread Barney Boisvert
Page breaks work happily in IE.  I don't know what else falls into "whole part of CSS 2", but at least that piece will work. Cheers, barneyb > -Original Message- > From: Sandy Clark [mailto:[EMAIL PROTECTED] > Sent: Friday, May 28, 2004 11:49 AM > To: CF-Talk > Subject: RE: More on Invoi

RE: More on Invoices

2004-05-28 Thread Sandy Clark
Theres a whole part of CSS 2 that deals with paged displays (ergo printing to the printer).  Unfortunately IE doesn't support it at all, NS/Moz supports some and the one with the best (but not full support is Opera) If you can use NS/Opera, then you can use page-break-after/page-break-before in a p

RE: Bank of America estores, cfhttp, http_referer, troubles

2004-05-28 Thread Dave Watts
> So, Dave, along this line of thinking to overcome https > protocol problem with cf5, I'll try adding > name="header" type="CGI" value="?"> Could you be more > specific as to "HTTP request headers" that would trick > receiving httpd with SSL to accept data? Using HTTPS doesn't have anything t

Re: Mach-II

2004-05-28 Thread Howard Fore
My apologies. In my venting I did blow your statement out of proportion. However, "OO allows code reuse" does not say "OO does code reuse better than anything else" or "OO is the only way to accomplish code reuse." The statement merely illustrates a capability of OO. If someone made the second

RE: SUM column data

2004-05-28 Thread Dave Watts
> I read the description of but I'm unsure > how to apply it here.  Please enlighten me! You may find this useful: http://www.macromedia.com/devnet/mx/coldfusion/articles/cfqueryparam.html Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays

Re: SUM column data

2004-05-28 Thread hammerin hankster
>And you should really use !!! I read the description of but I'm unsure how to apply it here.  Please enlighten me! Thanks for all the help! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

More on Invoices

2004-05-28 Thread Andy Ousterhout
Ok, bloated form, but looks nice.  How would I catch if I need to start a second page?  Do I need to count lines and characters in each line's descriptions to determine if time for new page or is there another way?  CSS? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [Us

RE: Query Functions - i.e. QueryNEW() etc

2004-05-28 Thread Philip Arnold
> From: Trevor Holm-Laursen > > Were the query functions, QueryNew(), QueryAddRow() ETC. > functions available in CF 4.5.  I have a client running on a > 4.5 host who refuses to switch hosting, and I need to build a > new query from a larger one but with no Query of a query is's > a pain in m

RE: Invoice Template

2004-05-28 Thread Andy Ousterhout
Simple! Thanks.   -Original Message-   From: Tangorre, Michael [mailto:[EMAIL PROTECTED]   Sent: Friday, May 28, 2004 12:47 PM   To: CF-Talk   Subject: RE: Invoice Template   Go to the Microsoft website.   Go to the Office System area.   Go to the downloads are.   Go to the  templates sec

Query Functions - i.e. QueryNEW() etc

2004-05-28 Thread Trevor Holm-Laursen
Were the query functions, QueryNew(), QueryAddRow() ETC. functions available in CF 4.5.  I have a client running on a 4.5 host who refuses to switch hosting, and I need to build a new query from a larger one but with no Query of a query is's a pain in my behind.  Before I spend the time writing the

Re: Invoice Template

2004-05-28 Thread Charlie Griefer
see my reply to your first message :D - Original Message - From: "Tony Weeg" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, May 28, 2004 10:44 AM Subject: RE: Invoice Template > is anyone else getting duplicate messages? or is it just me? > > thanks. > > -Origina

Duplicates (was RE: Invoice Template)

2004-05-28 Thread Andy Ousterhout
No, I just got one.   -Original Message-   From: Tony Weeg [mailto:[EMAIL PROTECTED]   Sent: Friday, May 28, 2004 12:44 PM   To: CF-Talk   Subject: RE: Invoice Template   is anyone else getting duplicate messages? or is it just me?   thanks.   -Original Message-   From: Tangorre,

Re: Strange error with NULLS

2004-05-28 Thread Deanna Schneider
Well, the think I see right off is that you're always going to be sending null (null=yes means the value attribute is ignore). You need something like the following: function reverseboolean(num) { var newbool = ''; if (num) newbool = '0'; else newbool = '1'; return newbool; } null="#yesnofor

Re: Mach-II

2004-05-28 Thread Michael Haggerty
Actually, this is an exact quote of what you said: 'But when everybody says "OOP allows or enables, or whatever, re-using the code", it promotes the idea that no code was re-used before, and THIS is just not true. OPP makes re-using code just a bit more systematic, no more, and good programers w

Re: functions

2004-05-28 Thread Ben Doom
Yes.  Yes I did. :-) --Ben Raymond Camden wrote: > Um... no. Val() is a CF function. I think you mean var. And it must be at > the beginning of a UDF. Ie > > function foo(x,y) { > var z = 1; > z = x*y+9; > return z; > } > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe]

Re: Mach-II

2004-05-28 Thread Claude Schneegans
>>as it is was Claude's choice to read "OO allows code reuse" as "OO allows code reuse for the first time in the history of mankind." C'mon, please be honest, this is NOT either what I said. But when some one says "OO allows code reuse" it is AT LEAST presented as an advantage, either because it d

RE: Invoice Template

2004-05-28 Thread Tony Weeg
is anyone else getting duplicate messages? or is it just me? thanks. -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Friday, May 28, 2004 1:47 PM To: CF-Talk Subject: RE: Invoice Template Go to the Microsoft website. Go to the Office System area. Go to the

RE: Invoice Template

2004-05-28 Thread Tangorre, Michael
Go to the Microsoft website. Go to the Office System area. Go to the downloads are. Go to the  templates section. Search for "invoice". Download one you like. Save as HTML. Voila!!! The worlds largest, most bloated code ever. But they do look nice. :-) Mike > -Original Message- > From:

Re: Sending a disconnect to Oracle through CF code...

2004-05-28 Thread Janet Schmitt
Brian - One more thought on this I would recommend, if it is possible in your environment, to let Oracle handle the login restrictions and session killing. Here is what you would do via Oracle: -  If you want Oracle to limit the sessions for you rather than via CF code, a profile can be s

Strange error with NULLS

2004-05-28 Thread Ian Skinner
Anybody have experience with something like this throwing an error. Creates the following error: java.lang.NullPointerException at coldfusion.runtime.OleDateTime.(OleDateTime.java:23) at coldfusion.runtime.OleDate.(OleDate.java:14) at coldfusion.runtime.CFPage.CreateODBCDate(CFPage.java:783) at

Invoice Template

2004-05-28 Thread Andy Ousterhout
Does anyone have an invoice template for printing that they can share with me? CSS or table-based are all fine with me. Thanks, Andy [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

CFAnywhere was: CF (BD) on CD with DB Success!

2004-05-28 Thread Dick Applebaum
On May 27, 2004, at 1:34 PM, Dick Applebaum wrote: > On May 27, 2004, at 1:11 PM, Adrocknaphobia wrote: > >  > But you still have to get the client to install eveything locally > off >  > the disk for any database interation. So it's not just oing to >  > automatically run. In essense the exact s

Re: functions

2004-05-28 Thread daniel kessler
Thanks everyone for helping out.  I have it pretty well now. >I have a set of code in CF that I use four times in a script.  It >could easily be a function with an in/out but I've yet to see >functions in CF, mostly scripts.  I don't want to do anything special >by making it external or making

Re: Sending a disconnect to Oracle through CF code...

2004-05-28 Thread Janet Schmitt
Brian - You can determine sessions using Oracle's data dictionary tables.  I think the one you would want to look at is V$SESSION.  It contains current session information.  You would need special privileges to the view. You may need to work with someone with DBA privileges in Oracle to set thi

RE: Help executing PL/SQL

2004-05-28 Thread Semrau Steven Ctr SAF/IE
Hehe, that's okay I appreciate all the help you've given - These are scripts for our development so that drop/recreate tables - pre-populate information - and so on can be done by us without having to go through these 'higher-up' DBAs every time we need to mess with the data. I just wish I c

RE: Help executing PL/SQL

2004-05-28 Thread Whittingham, P
we have native driver with no problems...we don't use ODBC. Pat -Original Message- From: Semrau Steven Ctr SAF/IE [mailto:[EMAIL PROTECTED] Sent: Friday, May 28, 2004 12:36 PM To: CF-Talk Subject: RE: Help executing PL/SQL Deanna, I'm sorry I overlooked your statement before: It does

Re: How do you *manage* time? (Add it, Subtract it, Track it)

2004-05-28 Thread Ian Sheridan
Jeff, Think of it this way you want to keep the duration of how long a person worked separate from when they opened and closed the "task". The reason being if the person opened the "task" this morning at 9:00am and closed it tomorrow evening at 5:00pm but only spent a total of 2.25 hrs actuall

RE: Looping a returned query to insert into another table

2004-05-28 Thread Mark Leder
Thanks Ian, there's really only 4-5 records at a transaction, so it should run OK. Thanks, Mark   _   From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Friday, May 28, 2004 12:42 PM To: CF-Talk Subject: RE: Looping a returned query to insert into another table Simply put a query loop arou

RE: Looping a returned query to insert into another table

2004-05-28 Thread Mark Leder
Great suggestions Nick and Hua.  I've give it a shot. Thanks, Mark   _   From: Nick Han [mailto:[EMAIL PROTECTED] Sent: Friday, May 28, 2004 12:39 PM To: CF-Talk Subject: Re: Looping a returned query to insert into another table I am using Oracle and this works nicely in a single statem

RE: download cf5

2004-05-28 Thread Kola Oyedeji
Ah, that's the one I was looking for, I'll bookmark it this time, Thanks Simon Kola -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 28 May 2004 17:17 To: CF-Talk Subject: Re: download cf5 http://www.macromedia.com/support/coldfusion/downloads.html 3rd

RE: Bank of America estores, cfhttp, http_referer, troubles

2004-05-28 Thread Matt Robertson
The *source* url.  if your url is http://foo.com/bar.cfm (or whatever) put that in the cfhttp referer value. I can't say if this will overcome any bug, but it's the correct way to reference a referrer to the target system.  I know of others who have used cf5 and made secure cfhttp calls.  But that

RE: Looping a returned query to insert into another table

2004-05-28 Thread Ian Skinner
Simply put a query loop around the insert block.     INSERT INTO     Now this is where CF may become not the best choice for a feature.  If one needs to thousand and thousands of records this way, the template will easily become very slow running and may timeout or have ot

Re: Looping a returned query to insert into another table

2004-05-28 Thread Nick Han
I am using Oracle and this works nicely in a single statement. You don't need the second query. insert into tableB (fieldnameA, fieldnameB, fieldnameC) select field1, field2, field3 from tableA  WHERE T.userID = value="#FORM.userID#"> Nick Han >>> [EMAIL PROTECTED] 05/28/04 09:15AM >>> Hi al

RE: Looping a returned query to insert into another table

2004-05-28 Thread Hua Wei
Mark, Since tableA and tableB use the same REQUEST.dsn1, you can try this: Insert into INTO tableB (fieldnameA, fieldnameB, fieldnameC) SELECT T.field1, T.field2, T.field3 FROM tableA T WHERE T.userID = value="#FORM.userID#"> Hua -Original Message- From: Mark Leder [mailto:[EMAIL PR

RE: Help executing PL/SQL

2004-05-28 Thread Semrau Steven Ctr SAF/IE
Deanna, I'm sorry I overlooked your statement before: It does work if it's all on one line, not set as a variable first? (I can't test it, as we don't have ODBC datasources set up.) I am trying to do this with the Oracle Native drivers not the ODBC. -Original Message- From: Deanna S

Re: Bank of America estores, cfhttp, http_referer, troubles

2004-05-28 Thread Don
Matt, Are you suggesting that    type="CGI" name="referer" value="https://foo.com/bar.cfm"> ... in other words, target url is the value for the CGI type, as a way to overcome cf5's bug with SSL protocol? Thanks. Don >Don wrote: >>my client's app is not to talk to BofA's site > >Ah ok.  

Re: functions

2004-05-28 Thread Charlie Griefer
http://www.houseoffusion.com/docs/cfscript.htm http://tutorial84.easycfm.com/ - Original Message - From: "Ben Doom" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, May 28, 2004 9:22 AM Subject: Re: functions > There's a mediocre chapter on script in the Designing Appl

Re: Help executing PL/SQL

2004-05-28 Thread Deanna Schneider
Hm. Then I don't know what to tell ya. - Original Message - From: "Semrau Steven Ctr SAF/IE" > Same results. > > > BEGIN UPDATE SYSTEMINFO SET LOGINPAGEMESSAGE = 'Welcome to here' WHERE DATACALL = 2; END; > > > #plsql# > > > results in: > ORA-06550: line 1, column 50: PL/SQL: ORA-009

RE: download cf5

2004-05-28 Thread Kola Oyedeji
Howard I remembered and tried searching but couldn't find it! Koal -Original Message- From: Howard Fore [mailto:[EMAIL PROTECTED] Sent: 28 May 2004 17:15 To: CF-Talk Subject: Re: download cf5 Kola, If you search the list archives at houseoffusion.com you'll find this was ans

RE: functions

2004-05-28 Thread Ian Skinner
Yes, the val() used in the function is there because CF is type less.  Thus your function could receive a string just has happily has an integer or a float as a parameter.  The val() function prevents the math from blowing up if it receives a string instead of a numeric value.  It would cause all n

Re: functions

2004-05-28 Thread daniel kessler
>Um... no. Val() is a CF function. I think you mean var. And it must be at >the beginning of a UDF. Ie thanks.  yeah it complains about that and missing semi-colons.  I guess I'm kinda used to flash and being lazy on all that. This is pretty cool and it makes me very happy that I can use function

Re: functions

2004-05-28 Thread Ben Doom
There's a mediocre chapter on script in the Designing Applicaitons book and section in the livedocs. I vaguely recall Michael Dinowitz putting up a tutorial on it for CF5, but vague memories are often wrong.  :-)  I also seem to recall tutorials on CFLIB.org, and there are plenty of samples to

Re: functions

2004-05-28 Thread Ben Doom
You surround the function declaration (in the script version) with cfscript tags.  The call doesn't have to be in a cfscript block. There are small differences in loops in the script version vs the tag version, but (afaik) that's all. --Ben Doom daniel kessler wrote: > huh. so I don't have to

RE: CFLOCK

2004-05-28 Thread Alistair Davidson
The advantage is that you only create them when they're needed. OK, so in that trivial example, there's virtually no difference, but you may have to do some more complicated stuff on application startup. For instance, reading, parsing and initializing language files and variables, if your applica

Re: download cf5

2004-05-28 Thread simon
http://www.macromedia.com/support/coldfusion/downloads.html 3rd link from the bottom. ~Simon > > This is a multi-part message in MIME format. > > > > > Anyone have the link to the CF5 download? I can't find it on the MM > site. > > Thanks > > Kola Oyedeji > Certified Advanced Coldfusion De

Re: download cf5

2004-05-28 Thread Howard Fore
Kola, If you search the list archives at houseoffusion.com you'll find this was answered not too long ago. Sorry, don't remember the answer off the top of my head. -- Howard Fore, [EMAIL PROTECTED] On May 28, 2004, at 12:02 PM, Kola Oyedeji wrote: > Anyone have the link to the CF5 download? I

RE: functions

2004-05-28 Thread Raymond Camden
Um... no. Val() is a CF function. I think you mean var. And it must be at the beginning of a UDF. Ie function foo(x,y) { var z = 1; z = x*y+9; return z; } [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: functions

2004-05-28 Thread daniel kessler
ok I see,  thanks. > Dain's example was a function and could either be in a CFC or a UDF > > Bryan Stevenson B.Comm. > VP & Director of E-Commerce Development > Electric Edge Systems Group Inc. > t. 250.920.8830 > e. [EMAIL PROTECTED] > > -

Looping a returned query to insert into another table

2004-05-28 Thread Mark Leder
Hi all, I've never done this before, but how do you loop a query of, say 6 records, and rewrite the output into another table? 1) Retrieve the records: SELECT T.field1, T.field2, T.field3 FROM tableA T WHERE T.userID = value="#FORM.userID#"> 3) Here's the table to insert the records to:

Re: functions

2004-05-28 Thread daniel kessler
ah locals, nice. That's a boon. Sure would've been nice to have a course in all this instead of ad-hoc and relying on my historical knowledge ("who's buried in grant's tomb" and the like :). >If you use "val" to declare a variable, it is local to the function. >this is a good idea, since otherwi

Re: functions

2004-05-28 Thread Bryan Stevenson
Dain's example was a function and could either be in a CFC or a UDF Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macr

Re: functions

2004-05-28 Thread daniel kessler
huh. so I don't have to surround it with cfscript?  How is this different from CFFunction, other than by structure. >It's very much like an ECMA language.  The biggest difference (off the >top of my head) is that you use CF comparison operators instead of ECMA >ones.  That is you use "is" or "eq

Re: functions

2004-05-28 Thread daniel kessler
huh. so I don't have to surround it with cfscript?  How is this different from CFFunction? >It's very much like an ECMA language.  The biggest difference (off the >top of my head) is that you use CF comparison operators instead of ECMA >ones.  That is you use "is" or "eq" instead of "==" and so

download cf5

2004-05-28 Thread Kola Oyedeji
Anyone have the link to the CF5 download? I can't find it on the MM site. Thanks Kola Oyedeji Certified Advanced Coldfusion Developer, ICLP London DDI: +44 (0) 208 256 9034 (Ex.2204) www.iclployalty.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: functions

2004-05-28 Thread Ben Doom
> Also, why did you val the pv? If you use "val" to declare a variable, it is local to the function. this is a good idea, since otherwise you might accidentally overwrite something in the variable scope. --Ben Doom [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User

Re: functions

2004-05-28 Thread Ben Doom
> pascal, that just looks like ECMA (JS, AS), can you elaborate? > do I just put that at the top and call it from cfset? > do I precede it with anything? It's very much like an ECMA language.  The biggest difference (off the top of my head) is that you use CF comparison operators instead of ECMA

RE: Question about datagrid

2004-05-28 Thread Douglas.Knudsen
honestly cfgrid sucks, to use the hi-tech-computer-nerd vernacular.  check out something like http://mysecretbase.com/GridMonger_Home.cfm No Java Applet needed. Doug -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Friday, May 28, 2004 11:47 AM To: CF-Talk Subj

Re: functions

2004-05-28 Thread daniel kessler
which one would be the one Dain displayed? I'm hoping to not make a component since it's really just specific to this page.  I'm just used to fuctioning duplicate programming. > Your Options: > -make a custom tag > -make a UDF (user defined function) - see www.cflib.org for info > -if on CF MX mak

Re: functions

2004-05-28 Thread daniel kessler
though it's kinda wordy, it seems to be what I want. so in cfset, I do: ? Also, why did you val the pv? thanks for replyin. > >  >  >  >  > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: functions

2004-05-28 Thread daniel kessler
pascal, that just looks like ECMA (JS, AS), can you elaborate? do I just put that at the top and call it from cfset? do I precede it with anything? >function myFunction(some_passed_var){ > var pv = some_passed_var; > pv = pv+10; > return pv; >} [Todays Threads] [This Message] [Subscription]

Re: Question about datagrid

2004-05-28 Thread Thomas Chiverton
On Friday 28 May 2004 14:48 pm, Mickey Manganelli wrote: > Can you point me to some detailed examples of using the cfgrid in the > following way? I'm not sure you can - the cfgrid isn't really a control in the VB/.Net sense. It should be easy enough to use onClick events on table cells to run a q

Re: SUM column data

2004-05-28 Thread Charlie Griefer
and, at the very least, maybe put the date1 and date2 vars into createODBCDate() functions (are they date/time datatypes in the database? if so, they don't get single quotes around the values). but like Pascal said... would be much, much better WHERE     cd.dailiesDate between cfsqltype="cf_sql_

Re: OT - SMTP settings security

2004-05-28 Thread mavinson
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 fi

RE: Help executing PL/SQL

2004-05-28 Thread Semrau Steven Ctr SAF/IE
Same results. BEGIN UPDATE SYSTEMINFO SET LOGINPAGEMESSAGE = 'Welcome to here' WHERE DATACALL = 2; END; #plsql# results in: ORA-06550: line 1, column 50: PL/SQL: ORA-00933: SQL command not properly ended ORA-06550: line 1, column 7: PL/SQL: SQL Statement ignored SQL = "BEGIN UPDATE SYSTEM

RE: SUM column data

2004-05-28 Thread Paul Vernon
You are mixing up your shorthand table references with full table references so the query should read something like this SELECT SUM(postageCost) as totalPostage FROM tblClientDailes cd inner join tblClients C on c.clientName = cd.clientName WHERE cd.dailliesDate between '#date1#' and '#date2#

RE: SUM column data

2004-05-28 Thread Pascal Peters
select sum(postageCost) as totalPostage from tblClientDailes cd inner join tblClients c on c.clientName = cd.clientName where  cd.dailliesDate between '#date1#' and '#date2#' and c.acctStatus = 'A' and cd.clientName like '%marsh%' group by c.clientName And you should really use !!! > -O

  1   2   >