RE: Return Most Recent Record PER CLIENT
Could return multiple records per client. 23 1/10/2004 50 23 1/18/2004 60 23 2/11/2004 40 27 2/11/2004 35 27 2/24/2004 31 27 1/19/2004 13 Returns 23 2/11/2004 40 27 2/11/2004 35 27 2/24/2004 31 Mark's solution will work. If your db doesn't alow the syntax, you can try to make a composite column of date and CN and filter on that (convert both to char and append them, or something like that) Pascal -Original Message- From: Andrew Tyrone [mailto:[EMAIL PROTECTED] Sent: vrijdag 28 mei 2004 0:22 To: CF-Talk Subject: RE: Return Most Recent Record PER CLIENT On the right track.This will remove the duplicates and should be ANSI compliant: SELECT DISTINCT cn, date, score FROM table WHERE date IN ( SELECT MAX(date) FROM table GROUP BY cn ) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Remove multiple carriage returns
It really depends on your system. Do you have cr, lf or cr/lf? This should work on all systems (not tested) REReplace(str,(#chr(13)#|#chr(10)#|#chr(13)##chr(10)#)\1+,\1,all); This will not remove them if there is any spaces or tabs after the returns. If you want all blank lines removed, it should be (again not tested): REReplace(str,(#chr(13)#|#chr(10)#|#chr(13)##chr(10)#)[ #chr(9)#]*(\1[ #chr(9)#]*)*\1,\1,all); If you are on cfmx you could use : REReplace(str,(\r|\n|\r\n)[ \t]*(\1[ \t]*)*\1,\1,all); Watch out for wrapping: no spaces in the first regexp, a space before each #chr(9)# in the second, a space before each \t in the third. -Original Message- From: Cedric Villat [mailto:[EMAIL PROTECTED] Sent: donderdag 27 mei 2004 22:20 To: CF-Talk Subject: Remove multiple carriage returns I have some text that I need to remove multiple line breaks from. For example, if my original text is like this: Hello My text goes here I want the text to be replaced with Hello My text goes here Basically I want to clean it up so there are no blank lines. Is there a simple regex or something else to do this? I'm not sure that there will always be a in the front, I just want to remove the blank lines. Cedric [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Regex problem
I don't want to be picky, but this won't work. He has a single quote too in his character set! -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED] Sent: donderdag 27 mei 2004 21:10 To: CF-Talk Subject: RE: Regex problem I have this _expression_ and it works great. REReplaceNoCase(clean, [^a-z0-9.!?'/\- ], , all) Now I need to add a to it with out it causing an error. How do I do that? Couldn't you just do this instead? REReplaceNoCase(clean, '[^a-z0-9.!?'/\- ]', '', 'all') (I just changed your surrounding double quotes to single quotes, which is perfectly valid, and then added the double quote to your expressoin in the []. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Javascript validation
Really depends on what you want to allow. If you want to allow (digits
OR digits.digits OR digits,ditgits) you could do
function isNumber2(inputStr, field){
var pattern_number = /^\d+([,.]\d+)?$/
if(inputStr.length !pattern_number.test(inputStr)){
alert(Please make sure your + field + entry are numbers .,
only);
return false;
}
return true;
}
Pascal
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: donderdag 27 mei 2004 17:36
To: CF-Talk
Subject: OT: _javascript_ validation
I have a function to make sure a user enters a number. How
can I include a number and a comma and period if a user wants
to enter a price such as: 9.90?
The line: if(charVal 0 || charVal 9 charVal != .
charVal != ,) still prevents a comma and period.
function isNumber2(inputStr, field)
{
for(var i=0; iinputStr.length; i++)
{
var charVal = inputStr.substring(i, i+1);
if(charVal 0 || charVal 9 charVal !=
. charVal != ,)
{
alert(Please make sure your + field
+ entry are numbers ., only);
return false;
}
}
return true;
}
Robert O.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: ColdFusion TechNote Notification: ColdFusion MX: Monitoring HTTP and SOAP traffic
On Thursday 27 May 2004 18:28 pm, Debbie Dickerson wrote: Check out the new TechNote at: http://www.macromedia.com/support/coldfusion/ts/documents/tcpmonitor.htm If you are intrested in this, can I suggest http://portswigger.net/proxy/ instead ? It supports HTTP and HTTPS, as well as allowing you to alter the contents of the request and response, if you wish. It's run-anywhere Java too. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: sequence problem in Mx
On Thursday 27 May 2004 17:44 pm, vishnu prasad wrote: error at row 1 if u want i can send the code to u .. Go ahead. The full stack dump would be good. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFLOCK
Connie Personally I've tended to store my global settings in an application-scoped struct, but duplicate them into request scope for unlocked usage, like this: cfset bSetup = false cflock scope=APPLICATION timeout=10 type=ReadOnly cfif not isDefined( application.settings) cfset bSetup = true /cfif /cflock cfif bSetup EQ true cfscript strSettings = structNew(); strSettings.dsn = (whatever); // etc /cfscript cflock scope=APPLICATION timeout=10 type=Exclusive Application.settings = Duplicate( strSettings ); /cflock /cfif !--- duplicate settings into request scope --- cflock scope=APPLICATION timeout=10 type=ReadOnly cfset request.settings = Duplicate( application.settings ) / /cflock You can then read the settings from request scope without having to worry about locking. Hope that helps Alistair Alistair Davidson Senior Technical Developer Headshift.com Smarter, Simpler, Social [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFLOCK
I don't see the advantage over setting them in the request scope directly. I don't think duplicating the structure will be much faster than creating the structure (unless this takes a lot of db interaction or processing. -Original Message- From: Alistair Davidson [mailto:[EMAIL PROTECTED] Sent: vrijdag 28 mei 2004 10:26 To: CF-Talk Subject: RE: CFLOCK Connie Personally I've tended to store my global settings in an application-scoped struct, but duplicate them into request scope for unlocked usage, like this: [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF-Talk: Digest every hour
Hi thomas the problem was solved the problem is first we use odbc withmicrosoft odb driverthen connect ,in this case we are not able to get the nextval for the sequence from the cfquerygetting an error after 99 values it gives error at row one now we chnage the driverto oracle driver it working now anyhow thks forthe response do u have msn so that i can add ur name and msg u ifi get any problem in cfm Thanks and Regards W.R Vishnu Prasad Sr Software Engineer Mobile 98412 77001 4th Floor, KRM Centre Ph: 52118090 - Extn: 415 No.2, Harrington Road, Chetpet, Chennai 600 031 www.scandentgroup.com CF-Talk [EMAIL PROTECTED] To:CF-Talk [EMAIL PROTECTED] usion.comcc: Subject:CF-Talk: Digest every hour 05/28/2004 03:31 PM Please respond to cf-talk CF-Talk 28-May-04 Issue:10737 In this issue: CFLOCK CFLOCK ColdFusion TechNote Notification: ColdFusion MX: Monitoring HTTP and SOAP traffic _javascript_ validation sequence problem in Mx [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: sequence problem in Mx
Hi thomas the problem was solved the problem is first we use odbc withmicrosoft odb driverthen connect,in this case we are not able to get the nextval for the sequence from the cfquerygetting an error after 99 values it gives error at row one now we chnage the driverto oracle driver it working now anyhow thks forthe response On Thursday 27 May 2004 17:44 pm, vishnu prasad wrote: error at row 1 if u want i can send the code to u .. Go ahead. The full stack dump would be good. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: how to output the following code using document.write?
sorry my bad, I'm still getting _javascript_ errors. Pascal if you have some time can you please help me out. Best Regards, cfcoder Thank you guys, it works [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFLOCK
Personally I've tended to store my global settings in an application-scoped struct, but duplicate them into request scope for unlocked usage I arrived at this solution a long time ago when we were using CF4.5 and had locks throughout our code. Performance was totally dead by 200 users and locks were timing out all over the place. By altering the application to duplicate into the request scope we eradicated the need for about 98% of the locks in our code and the performance limits under load testing went up from 200 to over 3000 simultaneous users. In production, we never got anywhere near 3000 simultaneous users and the systems we were serving about 3 million pages a month. We continued this practice in CF5 as it seems that it suffered with the same problems. Since moving to CFMX 6.1 I have become more relaxed about using cflock throughout the applications we write as the entire model just seems to be so much quicker and more reliable. Paul [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: how to output the following code using document.write?
cfoutput
cfsavecontent variable=text
a
href="">
pUp=true' , 740 , 430) class=linkacronym
title=#HTMLEditFormat(Slug)#cfif Comments neq
#HTMLEditFormat(Comments)#cfelseif Find('#Chr(13)#',Slug)cfset
tmp=REReplaceNoCase(Slug,'^[^a-z0-9_]*([a-z0-9_])','\1') cfif
trim(Find('***',tmp)-1) neq 0 and Find('***',tmp) and
trim(Left(tmp,Find('***',tmp)-1)) neq cfset str =
REReplace(Slug,^\s*([*]{3}.*?[*]{3})?\s*,)cfset str =
REReplace(str,^(.*?)\s*[*]{3}.*$,\1)#HTMLEditFormat(str)#cfelseif
trim(Find('#Chr(13)#',tmp)) neq 0 and
trim(Left(tmp,Find('#Chr(13)#',tmp))) neq
#HTMLEditFormat(trim(Left(tmp,Find('#Chr(13)#',tmp#cfelse#HTMLE
ditFormat(tmp)#/cfifcfelse#HTMLEditFormat(Left(Slug,25))#
.../cfif/acronym/a
/cfsavecontent
SCRIPT LANGUAGE=_javascript_ TYPE=text/_javascript_
!--
document.write(#JSStringFormat(text)#);
//--
/SCRIPT
/cfoutput
-Original Message-
From: cf coder [mailto:[EMAIL PROTECTED]
Sent: vrijdag 28 mei 2004 12:43
To: CF-Talk
Subject: Re: how to output the following code using document.write?
sorry my bad, I'm still getting _javascript_ errors. Pascal if
you have some time can you please help me out.
Best Regards,
cfcoder
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: how to output the following code using document.write?
Sheer genius, I bow down to you! Thanks again for the rescue. Best Regards [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: how to output the following code using document.write?
I have a simple Custom tag that does just this. If you send me an email off-list I'll send it to you. -Original Message- From: cf coder [mailto:[EMAIL PROTECTED] Sent: vrijdag 28 mei 2004 13:23 To: CF-Talk Subject: Re: how to output the following code using document.write? Sheer genius, I bow down to you! Thanks again for the rescue. Best Regards [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: how to output the following code using document.write?
I don't have you email, but you can email me at [EMAIL PROTECTED] I have a simple Custom tag that does just this. If you send me an email off-list I'll send it to you. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Mach-II
Then Mach-II is just using a terminology la mode to please those who like new words ;-). Yes, you're absolutely right--its sole purpose is to please people who like buzzwords.It clearly has no other benefits!I'll stop using it immediately. ;-) If you don't like it, don't use it, but I still contend that you don't really get what Mach-II is all about.You think of events in a very limited way, but when I call announceEvent() in Mach-II, stuff happens, so argue against that all you want, but events exist within Mach-II and can be used as such. - Matt [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Help with Mail
Hi there, I am working on an intranet for our office and we need to be able to send email through our Microsoft exchange (MAPI) to users on our network. Can anyone advise as to how to do this? Thank you. John [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Bank of America estores, cfhttp, http_referer, troubles
Don wrote: Since header is new for CFMX while my client uses cf5, with your idea of header parm is critical, I'll try Dave's suggestion of using CGI type. You didn't look at that tag I pointed you to.It already does that. Decides which version of CF is running and for MX+ uses type=header and for others type=cgi.However you will, as I mentioned before, have to misspell the referer header or BofA's programming will not recognize it (unless they fixed the problem since it was discovered a couple of weeks ago). Cheers, Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc.http://mysecretbase.com Sorry, Matt, for I haven't made it clear that my client's app is not to talk to BofA's site.So, the key issue for me to try this technique is, what value to use for the cfhttpparam type='cgi' name='header' value='?' attribute as I indicated in my last response to Dave's posting.My first thought when the https protocol failed was that cf5 failed to translate data to the correct one for SSL link on the remote server, not sure if this technique can overcome it, more like a long shot. Thanks. Don [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Question about datagrid
Hi Stace, After my last attempt to reply to this thread topic I got an email stating ... You are not subscribed to the CF-Talk list with the address [EMAIL PROTECTED] I am sorry for the confusion because I wasn't subscribed to this newsgroup, so here it is again ... I am mainly a seasoned VB programmer (4.0 - .NET) with a year of Delphi and 3 yrs of Java ... all GUI development. I am now doing web development using CF and DWMX 2004 with some _javascript_s. Can you point me to some detailed examples of using the cfgrid in the following way? I have a query that will retrieve info for a grid based on the what row the user clicks on another grid. The grid contains a list of companies and based on the user's selection will populate another grid with other fields. Right now I have it driven by a drop down selection. Where are the list of methods/events/properties that you can interact with this object? Any good sites ... ? I am signed up for the emails but have not seen anything regarding this, and I have also been searching the web for 3 days and came up with nothing. This thread was the closest thing I have found. Any help would be appreciated! Thanks! Mickey Manganelli Well I'm not that much closer to being a designer than Ray but, yes I believe you can do that. (Anyone please correct me if I'm wrong) Normally you can toss a query into the grid with one line of code...for conditional formatting you'd have to loop over the query and use an addItem method that inserts the row on each loop, complete with your formatting. There could very well be a more efficient way...but I'm no guru yet. Cheers, Stace -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Monday, November 04, 2002 2:37 PM To: CF-Talk Subject: RE: Question about datagrid Thats awesome!Can you format each cell and include conditional formatting Warning! Warning! Developer being asked to answer design questions! Proceed with caution!;) Um - I am _kinda_ sure you can do that. The datagrid is _very_ nice - worth the code of the DRK itself I think (yes, I work for the company that makes it, so I'm biased). based on the field's value? For example, check if a value is a date and use a date format if it is. I found cfgrid to be limiting because you do not have great control at the field level. How does the data grid compare? From what I can tell, it's much more configurable. This also raise's a question. A client recently asked us to quote on a inventory/accounting system. The system would need to be used from several remote locations. Are these kind of systems good candidates for FlashMX? That's a very loaded question. ;) For something that was data intensive - I'd much rather use flash for the UI than DHTML - but hey - I work for the company that makes it - so I'm probably just a marketing AI program in disguise. : FYI - I made that session tracker UI after testing the new DRIA class for Macromedia. DRIA = Developing Rich Internet Applications. I _cannot_ recommend this class enough. It's the perfect class for those of us who want to use Flash for _real_ purposes instead of stupid (but pretty) intros. It's a very geeky type introduction to Flash and it focuses on just the kinds of things we would really use in a flash app. (No tweening anywhere. ;) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
How do you *manage* time? (Add it, Subtract it, Track it)
Okay, so let's say you're using SQL Server, and you want to create an application that was going to track time and do things like, eventually multiply hours by currency (hourly rate by 1 hour 45 minutes) and add several rows containing time to accumulate time spent, time remaining, etc, and graphing it with CFChart (time spent vs time allocated), etc... How would you store it and manipulate it in CF? Do you store it as a DateTime object? What if you only add time on the front end in fifteen minute increments (say, an hourdropdown with 1, 2, 3, 4, 5, 6, 7, 8 and a minutes dropdown menu with 00, 15, 30, 45 so you could, say, select 4:45 to insert for your particular time entry) do you use CF to create ODBC Date Time objects and pass those in, stored as a Date Time object? But if you enter 4:45, how does it know you're adding a *quantity* of time, rather than just saying 4:45 this afternoon? So, how *do* you store times if you want to add them and have the math work right? (For example (1:45 + 1:45)$10/hr = $35...like that) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Bank of America estores, cfhttp, http_referer, troubles
Don wrote: my client's app is not to talk to BofA's site Ah ok.Here's a code sample in case you need one. cfhttpparam type=CGI name=referer value=https://foo.com/bar.cfm Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc.http://mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: How do you *manage* time? (Add it, Subtract it, Track it)
I always use seconds, and build up from there. its soo easy to work with them, with dateAdd, and dateDiff. and as always the database is really thin, since your just storing numbers. .02 tw -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: Friday, May 28, 2004 9:49 AM To: CF-Talk Subject: How do you *manage* time? (Add it, Subtract it, Track it) Okay, so let's say you're using SQL Server, and you want to create an application that was going to track time and do things like, eventually multiply hours by currency (hourly rate by 1 hour 45 minutes) and add several rows containing time to accumulate time spent, time remaining, etc, and graphing it with CFChart (time spent vs time allocated), etc... How would you store it and manipulate it in CF? Do you store it as a DateTime object? What if you only add time on the front end in fifteen minute increments (say, an hourdropdown with 1, 2, 3, 4, 5, 6, 7, 8 and a minutes dropdown menu with 00, 15, 30, 45 so you could, say, select 4:45 to insert for your particular time entry) do you use CF to create ODBC Date Time objects and pass those in, stored as a Date Time object? But if you enter 4:45, how does it know you're adding a *quantity* of time, rather than just saying 4:45 this afternoon? So, how *do* you store times if you want to add them and have the math work right? (For example (1:45 + 1:45)$10/hr = $35...like that) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SUM column data
I'm trying to SUM a column of data but I'm missing something obvious in my concept here.Also, I hope this is the right list to post this question to.If not, please let me know and I'll repost to the proper list.Below is my query: CFQUERY NAME=readpostage DATASOURCE=esitest SELECT postagecost, SUM(postagecost) AS totalpostage FROMtblclientdailies, tblclients where tblclients.clientname = tblclientdailies.clientname andtblclients.acctstatus = 'A' and dailiesdate BETWEEN #Date1# AND #Date2# and tblclientdailies.clientname like '%marsh%' GROUP BY postagecost, dailiesdate order by dailiesdate /CFQUERY Here's the first 5 rows of data in the column: .37 .37 .37 .00 .37 And here's what the cfoutput is returning (first five rows): 1.1100 0.3700 0. 1.1100 1.2000 See anything obviously wrong? Thanks! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Regex problem
That last quote within the brackets is a double quote, not a single quote typed twice. From: Pascal Peters [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: Regex problem Date: Fri, 28 May 2004 09:39:54 +0200 I don't want to be picky, but this won't work. He has a single quote too in his character set! -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED] Sent: donderdag 27 mei 2004 21:10 To: CF-Talk Subject: RE: Regex problem I have this _expression_ and it works great. REReplaceNoCase(clean, [^a-z0-9.!?'/\- ], , all) Now I need to add a to it with out it causing an error. How do I do that? Couldn't you just do this instead? REReplaceNoCase(clean, '[^a-z0-9.!?'/\- ]', '', 'all') (I just changed your surrounding double quotes to single quotes, which is perfectly valid, and then added the double quote to your expressoin in the []. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SUM column data
select sun(postageCost) as totalPostage from tblClientDailes cd inner join tblClients c on c.clientName = cd.clientName wherecd.dailliesDate between '#date1#' and '#date2#' and c.acctStatus = 'A' and cd.clientName like '%marsh%' group by c.clientName try that. couple things though in your db design, that I see that I would change. I would use an id back and forth between the two tables, rather than clientName being the join column, very slow to seek on text, vs. an id column. I would have a boolean field for acctStatus, again, faster than text. and you can deduce the same state of the acctStatus, from a 1 or 0.active or non-active. anyway, try that. tw -Original Message- From: hammerin hankster [mailto:[EMAIL PROTECTED] Sent: Friday, May 28, 2004 9:56 AM To: CF-Talk Subject: SUM column data I'm trying to SUM a column of data but I'm missing something obvious in my concept here.Also, I hope this is the right list to post this question to. If not, please let me know and I'll repost to the proper list.Below is my query: CFQUERY NAME=readpostage DATASOURCE=esitest SELECT postagecost, SUM(postagecost) AS totalpostage FROMtblclientdailies, tblclients where tblclients.clientname = tblclientdailies.clientname andtblclients.acctstatus = 'A' and dailiesdate BETWEEN #Date1# AND #Date2# and tblclientdailies.clientname like '%marsh%' GROUP BY postagecost, dailiesdate order by dailiesdate /CFQUERY Here's the first 5 rows of data in the column: .37 .37 .37 .00 .37 And here's what the cfoutput is returning (first five rows): 1.1100 0.3700 0. 1.1100 1.2000 See anything obviously wrong? Thanks! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: How do you *manage* time? (Add it, Subtract it, Track it)
I always use seconds, and build up from there. its soo easy to work with them, with dateAdd, and dateDiff. and as always the database is really thin, since your just storing numbers. .02 tw After I typed this, I had a thought about this more, and thought this: Why do I need to store the hours as a date time object anyway? If I *only* need to build a time in 15 minute increments (.25) would it be bad practice to store the hours spent as integers and control the input of the values on the front end CF page? So the dropdown menu would say, 00, 15, 30, 45 but the value would be .00, .25, .50, .75? The math works that way, right? (same problem...(1.75 + 1.75)$10/hr = $35...right?) It doesn't matter even if someone spends 25 hours on something, it can add 2.5, 2.5, etc 10 times, and get the right total...right? So I guess what I'm saying is, does it work to also just store them as ints and let all my CF on the front end control how the data's input? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: How do you *manage* time? (Add it, Subtract it, Track it)
yes, store as ints.let ur display layer handle what they see. tw -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: Friday, May 28, 2004 10:03 AM To: CF-Talk Subject: Re: How do you *manage* time? (Add it, Subtract it, Track it) I always use seconds, and build up from there. its soo easy to work with them, with dateAdd, and dateDiff. and as always the database is really thin, since your just storing numbers. .02 tw After I typed this, I had a thought about this more, and thought this: Why do I need to store the hours as a date time object anyway? If I *only* need to build a time in 15 minute increments (.25) would it be bad practice to store the hours spent as integers and control the input of the values on the front end CF page? So the dropdown menu would say, 00, 15, 30, 45 but the value would be .00, .25, .50, .75? The math works that way, right? (same problem...(1.75 + 1.75)$10/hr = $35...right?) It doesn't matter even if someone spends 25 hours on something, it can add 2.5, 2.5, etc 10 times, and get the right total...right? So I guess what I'm saying is, does it work to also just store them as ints and let all my CF on the front end control how the data's input? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SUM column data
select sun(postageCost) as totalPostage from tblClientDailes cd inner join tblClients c on c.clientName = cd.clientName wherecd.dailliesDate between '#date1#' and '#date2#' and c.acctStatus = 'A' and cd.clientName like '%marsh%' group by c.clientName Thanks for the quick response!Excuse my ignorance, but what do you mean by cd on the from line? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Sending a disconnect to Oracle through CF code...
Has anyone done this before?I have a task that I must check to see if the user already has an Oracle session active when they log on.If they do, do not allow the logon.If they don't, let them continue.The Oracle session lasts for 15 minutes of inactivity.When the user logs out of the application, I need to log them out of Oracle as well. Thanks in advance Brian Yager [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Mach-II
On May 28, 2004, at 1:10 AM, Andrew Tyrone wrote: What I object to is your implication that if someone doesn't use an approved framework, they are re-inventing the wheel and not trying to solve real-world problems. No, no, no. That's not what I'm implying. That may be what you're interpreting, but that's your choice, 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. However, by definition if one creates a product that accomplishes the same task as another product, they are reinventing that product. Approval is a different matter entirely. My choices are just that. Mine. They are based on my personal experience and they are thus affected by every project I have worked on and will work on. But those choices are necessarily subjective because they are based on my judgement and standards. Perhaps those people who complain about code bloat have tighter standards than I do. Maybe they evaluate the tradeoff of shaving 10 milliseconds from response time versus the 2 hours it may take to reach that point differently. These are personal decisions. There is no Underwriter's Laboratories saying that your application will fail because you wrote your own framework. What I object to is the lack of reasoned answers. Surely these people bright enough to write their own scalable, lightening fast, lean, reusable-to-the-nines frameworks are also bright enough to realize that there are at least two sides to every issue. That few things are truly all black or all white. When someone asks, Hey, I'm new to frameworks. Should I use FB and/or Mach-II? it serves little of the collective good to stand up with a flamethrower and blast everything that is not customized for a specific project. The if you're not with us, you're against us mentality some Fusecattle hold is just ridiculous.Just because someone creates their own framework doesn't mean they are detractors.Let's face it, just because people didn't follow the path you've taken to acheive development Nirvana doesn't mean they went about it the wrong way.I don't like a lot of things; does that mean I detract from them? No, but if all you do is say bad things about the things you don't like then yes, you are detracting from them. Detractor, noun: one who disparages or belittles the worth of something. Also, I don't understand how using OS X and Linux cuts down on your administration time.These things are fallable just like everything else. In my experience, it is skill coupled with patience and the leveraging of specific tools (in some instances) that gets the job done. Yes, everything is fallable. My PowerBook locked up hard last night, to the point I had to power cycle it to recover. I'm sure there are Windows users who can sympathize. I'm dissatisfied with almost every method of software delivery and packaging in Linux with the instances of cascading dependencies. Patience is sometimes not my long suite. My experience in computers has shown that more often than not, I get better results quicker by using OS X (and Macintoshes in general) and Linux than attempting the same with Windows. I'm know there are those with exact opposite experiences. I know that leveraging the tools of OS X, FB, and Linux will the most of the jobs done that I encounter. Perhaps if I had more patience I could swallow spending the extra time developing the skills to accomplish the same thing in Windows. I choose not to. That doesn't mean you can't or shouldn't. Somethings are worth specialization, some things aren't. Again, your choice. One size doesn't fit all, whether it is FB, Mach-II, onTap, JSP, Tapestry, or WebObjects. But each has it's good and bad points. It is counterproductive to present subjective, one-sided answers to those looking for an objective view. -- Howard Fore, [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: How do you *manage* time? (Add it, Subtract it, Track it)
Jeff Small wrote: Okay, so let's say you're using SQL Server So, how *do* you store times if you want to add them and have the math work right? (For example (1:45 + 1:45)$10/hr = $35...like that) Since I generally use databases that understand the interval datatype I prefer to shift everything to the database because it is much easier to deal with than in CF. Just define a field as interval and insert strings like '1 hour 13 minutes' or '5 hours 12 seconds' and it automagically works, including regular math and statistical stuff. Unfortunately MS SQL Server does not have an INTERVAL datatype so for now I would second the suggestion to convert all your values to seconds and store them in an integer field. And of course fill out http://register.microsoft.com/mswish/suggestion.asp :-) Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SUM column data
It's an alias for tblClientDailes (and c for tblClients) Pascal -Original Message- From: hammerin hankster [mailto:[EMAIL PROTECTED] Sent: vrijdag 28 mei 2004 16:12 To: CF-Talk Subject: Re: SUM column data select sun(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 Thanks for the quick response!Excuse my ignorance, but what do you mean by cd on the from line? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
More CF (BD) on CD with DB Success!
Here's an update on the CFAnywhere project. The procedure is now documented to the point of getting the CF (BD), Jetty, McKoi DB self-contained package running on the desktop. http://67.124.145.42:9090/BlueDragon_webapp_61/CFAnywhereDocs/ CFAnywhere.html We're gettin' there! Dick Half of today's High School graduates don't understand basic mathematics -- and the other 55% don't care! -anon [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Regex problem
I know, but there is a single quote between ? and / So for this to work, it should be REReplaceNoCase(clean, '[^a-z0-9.!?''/\- ]', '', 'all') -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED] Sent: vrijdag 28 mei 2004 16:01 To: CF-Talk Subject: RE: Regex problem That last quote within the brackets is a double quote, not a single quote typed twice. REReplaceNoCase(clean, '[^a-z0-9.!?'/\- ]', '', 'all') [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
functions
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 it nice enough to give to others.I
just want a callable/reusable function:
function myFunction(some_passed_var){
cfset pv = some_passed_var
cfset pv = pv+10
return pv
}
Is there something similar in CF?
--
Daniel Kessler
Department of Public and Community Health
University of Maryland
Suite 2387 Valley Drive
College Park, MD20742-2611
301-405-2545 Phone
www.phi.umd.edu
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: functions
function myFunction(some_passed_var){
var pv = some_passed_var;
pv = pv+10;
return pv;
}
-Original Message-
From: Daniel Kessler [mailto:[EMAIL PROTECTED]
Sent: vrijdag 28 mei 2004 16:56
To: CF-Talk
Subject: functions
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 it nice
enough to give to others.I just want a callable/reusable function:
function myFunction(some_passed_var){
cfset pv = some_passed_var
cfset pv = pv+10
return pv
}
Is there something similar in CF?
--
Daniel Kessler
Department of Public and Community Health University of
Maryland Suite 2387 Valley Drive College Park, MD20742-2611
301-405-2545 Phone
www.phi.umd.edu
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
OT - SMTP settings security
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: functions
You can use CFFUNCTION in MX:
CFFUNCTION NAME=myFunction RETURNTYPE=numeric
CFARGUMENT NAME=some_passed_var TYPE=numeric
CFSET pv = Arguments.some_passed_var
CFSET pv = Val(pv + 10)
CFRETURN pv
/CFFUNCTION
-Dain
Daniel Kessler wrote:
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 it nice enough to give to others.I
just want a callable/reusable function:
function myFunction(some_passed_var){
cfset pv = some_passed_var
cfset pv = pv+10
return pv
}
Is there something similar in CF?
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: Sending a disconnect to Oracle through CF code...
Brian Yager wrote: I have a task that I must check to see if the user already has an Oracle session active when they log on.If they do, do not allow the logon. Logon trigger in Oracle? The Oracle session lasts for 15 minutes of inactivity.When the user logs out of the application, I need to log them out of Oracle as well. Don't know. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: functions
Your Options:
-make a custom tag
-make a UDF (user defined function) - see www.cflib.org for info
-if on CF MX make a function in a CFC (ColdFusion Component)
-go dead simple and make the script an included file and include it whereever you need it (set your in var(s) before including the file and the out gets set in the included file)
HTH
Cheers
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.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder Director
www.cfug-vancouverisland.com
- Original Message -
From: Daniel Kessler
To: CF-Talk
Sent: Friday, May 28, 2004 7:55 AM
Subject: functions
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 it nice enough to give to others.I
just want a callable/reusable function:
function myFunction(some_passed_var){
cfset pv = some_passed_var
cfset pv = pv+10
return pv
}
Is there something similar in CF?
--
Daniel Kessler
Department of Public and Community Health
University of Maryland
Suite 2387 Valley Drive
College Park, MD20742-2611
301-405-2545 Phone
www.phi.umd.edu
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: CF (BD) on CD with DB Success!
On May 27, 2004, at 1:31 PM, Roger Benningfield wrote: Guys, don't take this the wrong way. Isn't this going a bit far to circumvent learning a new language? I mean you are basically trying to fit a sqaure server peg into a round PC hole. Adam, Not necessarily. After all, both Userland Radio and Amphetadesk are desktop tools that do essentially the same thing... they launch HTTP servers and scripting languages (Frontier and Perl, respectively) and do all the UI work in HTML. So there's some successful precedent for this sort of thing. Mmm... I hadn't thought of that.I think that Userland is particularly significant -- its designer, Dave Wiener, is very sensitive to UIs -- he developed ThinkTank in the '80s, which a defined a whole new class of desktop apps -- the outliner/organizer (and it was originally implemented in UCSD Pascal on a Apple ][ with 64K RAM). ThinkTank had a very intuitive UI -- one of the best I've ever seen! That Dave chose a browser for his UI, is quite a testament for the UI. Dick -- Roger Benningfield blog: http://admin.support.journurl.com/ MX blog hosting: http://mxblogspace.journurl.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT - SMTP settings security
On Friday 28 May 2004 15:59 pm, Eric Creese wrote: 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. Assuming you need CF to send to anywhere via your server, restrict SMTP to internal/loopback IP address. No idea how to do that on Windows, I wouldn't trust it to relay anything. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Sending a disconnect to Oracle through CF code...
Brian Yager wrote: I have a task that I must check to see if the user already has an Oracle session active when they log on.If they do, do not allow the logon. Logon trigger in Oracle? To log them in, I just use their username and password in a query. The Oracle session lasts for 15 minutes of inactivity.When the user logs out of the application, I need to log them out of Oracle as well. Don't know. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT - SMTP settings security
http://support.microsoft.com/default.aspx?scid=kb;en-us;310356 Eric, http://support.microsoft.com/default.aspx?scid=kb;en-us;310356 This article should be exactly what you need to tighten up security on your SMTP service. Paul [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Regex problem
Ah, good catch. I misread your initial statement. From: Pascal Peters [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: Regex problem Date: Fri, 28 May 2004 16:41:58 +0200 I know, but there is a single quote between ? and / So for this to work, it should be REReplaceNoCase(clean, '[^a-z0-9.!?''/\- ]', '', 'all') -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED] Sent: vrijdag 28 mei 2004 16:01 To: CF-Talk Subject: RE: Regex problem That last quote within the brackets is a double quote, not a single quote typed twice. REReplaceNoCase(clean, '[^a-z0-9.!?'/\- ]', '', 'all') [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SUM column data
Okay, I'm being dense about this.I'm getting a syntax error when I try this code: cfquery name=test datasource=esitest select sum(postageCost) as totalPostage from tblClientDailes, tblclients inner join tblClients on tblclients.clientName = tblclientdailies.clientName wherecd.dailliesDate between '#date1#' and '#date2#' and tblclients.acctStatus = 'A' and tblclientdailies.clientName like '%marsh%' group by c.clientName /cfquery [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SUM column data
cfquery name=test datasource=esitest select sum(postageCost) as totalPostage from tblClientDailes cd inner join tblClients c on c.clientName = cd.clientName wherecd.dailliesDate between '#date1#' and '#date2#' and c.acctStatus = 'A' and cd.clientName like '%marsh%' group by c.clientName /cfquery And you should really use cfqueryparam!!! -Original Message- From: hammerin hankster [mailto:[EMAIL PROTECTED] Sent: vrijdag 28 mei 2004 17:31 To: CF-Talk Subject: Re: SUM column data Okay, I'm being dense about this.I'm getting a syntax error when I try this code: cfquery name=test datasource=esitest select sum(postageCost) as totalPostage from tblClientDailes, tblclients inner join tblClients on tblclients.clientName = tblclientdailies.clientName wherecd.dailliesDate between '#date1#' and '#date2#' and tblclients.acctStatus = 'A' and tblclientdailies.clientName like '%marsh%' group by c.clientName /cfquery [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SUM column data
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#' AND c.acctStatus = 'A' AND cd.clientName like '%marsh%' GROUP BY by c.clientName Or SELECT SUM(postageCost) as totalPostage FROM tblClientDailes inner join tblClients on tblClients.clientName = tblClientDailes.clientName WHERE tblClientDailes.dailliesDate between '#date1#' and '#date2#' AND tblClients.acctStatus = 'A' AND tblClientDailes.clientName like '%marsh%' GROUP BY by tblClients.clientName Paul [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Help executing PL/SQL
Same results. cfsavecontent variable=plsql BEGIN UPDATE SYSTEMINFO SET LOGINPAGEMESSAGE = 'Welcome to here' WHERE DATACALL = 2; END; /cfsavecontent cfquery name=davidTest datasource=#mysession.dcname# #plsql# /cfquery 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 SYSTEMINFO SET LOGINPAGEMESSAGE = ''Welcome to here'' WHERE DATACALL = 2; END; -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Thursday, May 27, 2004 4:55 PM To: CF-Talk Subject: Re: Help executing PL/SQL Okay, what if you take that one (without line breaks) and use cfsavecontent to save it to a variable and try to run it. Does that work? (In other words, I'm trying to figure out if it's a problem with the replace statement, or a problem with the way CF is passing the variable into the cfquery.) - Original Message - From: Semrau Steven Ctr SAF/IE Yes, doing this: cfquery name=davidTest datasource=#mysession.dcname# BEGIN UPDATE SYSTEMINFO SET LOGINPAGEMESSAGE = 'Welcome to here' WHERE DATACALL = 2; END; /cfquery returns: davidTest (Records=0, Time=94ms) SQL = BEGIN UPDATE SYSTEMINFO SET LOGINPAGEMESSAGE = 'Welcome to here' WHERE DATACALL = 2; END; And doing this: cfquery name=davidTest datasource=#mysession.dcname# BEGIN UPDATE SYSTEMINFO SET LOGINPAGEMESSAGE = 'Welcome to here' WHERE DATACALL = 2; END; /cfquery _ [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: SUM column data
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...cfqueryparam would be much, much better WHERE cd.dailiesDate between cfqueryparam value=#date1# cfsqltype=cf_sql_date AND cfqueryparam value=#date2# cfsqltype=cf_sql_date - Original Message - From: Paul Vernon [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 28, 2004 8:37 AM Subject: RE: SUM column data 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#' AND c.acctStatus = 'A' AND cd.clientName like '%marsh%' GROUP BY by c.clientName Or SELECT SUM(postageCost) as totalPostage FROM tblClientDailes inner join tblClients on tblClients.clientName = tblClientDailes.clientName WHERE tblClientDailes.dailliesDate between '#date1#' and '#date2#' AND tblClients.acctStatus = 'A' AND tblClientDailes.clientName like '%marsh%' GROUP BY by tblClients.clientName Paul [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Question about datagrid
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 query through NeuroMancer / pengoworks Gateway (i.e. invoke a server-side function from the web client) and display the results. Unfortunately, if you're just starting out, this can be fairly complex. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: functions
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]
[Fast Unsubscribe]
[User Settings]
Re: functions
though it's kinda wordy, it seems to be what I want. so in cfset, I do: cfset myVar = myFunction(passy_varry) ? Also, why did you val the pv? thanks for replyin. CFFUNCTION NAME=myFunction RETURNTYPE=numeric CFARGUMENT NAME=some_passed_var TYPE=numeric CFSET pv = Arguments.some_passed_var CFSET pv = Val(pv + 10) CFRETURN pv /CFFUNCTION [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: functions
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 make a function in a CFC (ColdFusion Component) -go dead simple and make the script an included file and include it whereever you need it (set your in var(s) before including the file and the out gets set in the included file) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Question about datagrid
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 Subject: Re: Question about datagrid 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 query through NeuroMancer / pengoworks Gateway (i.e. invoke a server-side function from the web client) and display the results. Unfortunately, if you're just starting out, this can be fairly complex. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: functions
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 ones.That is you use is or eq instead of == and so forth. You can call it from a CFSET if you want the results to be put in a variable: cfset value = function_name(arguments) If you just want them displayed, you can do something like cfoutput #function_name(arguments)# /cfoutput --Ben Doom [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: functions
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 Settings]
download cf5
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
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 forth. You can call it from a CFSET if you want the results to be put in a variable: cfset value = function_name(arguments) If you just want them displayed, you can do something like cfoutput #function_name(arguments)# /cfoutput --Ben Doom [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: functions
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 instead of == and so forth. You can call it from a CFSET if you want the results to be put in a variable: cfset value = function_name(arguments) If you just want them displayed, you can do something like cfoutput #function_name(arguments)# /cfoutput --Ben Doom [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: functions
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.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: daniel kessler To: CF-Talk Sent: Friday, May 28, 2004 8:57 AM Subject: Re: functions 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 make a function in a CFC (ColdFusion Component) -go dead simple and make the script an included file and include it whereever you need it (set your in var(s) before including the file and the out gets set in the included file) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: functions
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 otherwise you might accidentally overwrite something in the variable scope. --Ben Doom [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Looping a returned query to insert into another table
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: cfquery name=getRecords datasource=#REQUEST.dsn1# SELECT T.field1, T.field2, T.field3 FROM tableA T WHERE T.userID = cfqueryparam cfsqltype=cf_sql_int value=#FORM.userID# /cfquery 3) Here's the table to insert the records to: cfquery name=putRecords datasource=#REQUEST.dsn1# INSERT INTO tableB (fieldnameA, fieldnameB, fieldnameC) VALUES (#getRecords.field1#, #getRecords.field2#, #getRecords.field3#) /cfquery Thanks, Mark [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: functions
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] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: daniel kessler To: CF-Talk Sent: Friday, May 28, 2004 8:57 AM Subject: Re: functions 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 make a function in a CFC (ColdFusion Component) -go dead simple and make the script an included file and include it whereever you need it (set your in var(s) before including the file and the out gets set in the included file) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: functions
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: download cf5
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 can't find it on the MM site. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: download cf5
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 Developer, ICLP London DDI: +44 (0) 208 256 9034 (Ex.2204) www.iclployalty.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFLOCK
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 application is internationalized. Or performing complicated queries for dynamic site configuration that might take seconds to run - you'd then want to cache the results in application scope and duplicate them out. I've done both of these, and when setting up the variables takes minutes but duplicating them out takes milliseconds, it's a real no-brainer. _ From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: 28 May 2004 09:30 To: CF-Talk Subject: RE: CFLOCK I don't see the advantage over setting them in the request scope directly. I don't think duplicating the structure will be much faster than creating the structure (unless this takes a lot of db interaction or processing. -Original Message- From: Alistair Davidson [mailto:[EMAIL PROTECTED] Sent: vrijdag 28 mei 2004 10:26 To: CF-Talk Subject: RE: CFLOCK Connie Personally I've tended to store my global settings in an application-scoped struct, but duplicate them into request scope for unlocked usage, like this: _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: functions
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 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 instead of == and so forth. You can call it from a CFSET if you want the results to be put in a variable: cfset value = function_name(arguments) If you just want them displayed, you can do something like cfoutput #function_name(arguments)# /cfoutput --Ben Doom [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: functions
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 learn from on there. --Ben Doom daniel kessler wrote: 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 otherwise you might accidentally overwrite something in the variable scope. --Ben Doom [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: functions
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 functions.
function foo(x,y) {
var z = 1;
z = x*y+9;
return z;
}
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: functions
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 non-numeric values to become 0. Confidentiality Notice:This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: download cf5
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 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 can't find it on the MM site. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Help executing PL/SQL
Hm. Then I don't know what to tell ya. - Original Message - From: Semrau Steven Ctr SAF/IE Same results. cfsavecontent variable=plsql BEGIN UPDATE SYSTEMINFO SET LOGINPAGEMESSAGE = 'Welcome to here' WHERE DATACALL = 2; END; /cfsavecontent cfquery name=davidTest datasource=#mysession.dcname# #plsql# /cfquery 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 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: functions
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 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 learn from on there. --Ben Doom daniel kessler wrote: 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 otherwise you might accidentally overwrite something in the variable scope. --Ben Doom [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Bank of America estores, cfhttp, http_referer, troubles
Matt, Are you suggesting that cfhttp url="" ... cfhttpparam type=CGI name=referer value=https://foo.com/bar.cfm ... /cfhttp 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.Here's a code sample in case you need one. cfhttpparam type=CGI name=referer value=https://foo.com/bar.cfm Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc.http://mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Help executing PL/SQL
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 Schneider [mailto:[EMAIL PROTECTED] Sent: Thursday, May 27, 2004 4:55 PM To: CF-Talk Subject: Re: Help executing PL/SQL Okay, what if you take that one (without line breaks) and use cfsavecontent to save it to a variable and try to run it. Does that work? (In other words, I'm trying to figure out if it's a problem with the replace statement, or a problem with the way CF is passing the variable into the cfquery.) - Original Message - From: Semrau Steven Ctr SAF/IE Yes, doing this: cfquery name=davidTest datasource=#mysession.dcname# BEGIN UPDATE SYSTEMINFO SET LOGINPAGEMESSAGE = 'Welcome to here' WHERE DATACALL = 2; END; /cfquery returns: davidTest (Records=0, Time=94ms) SQL = BEGIN UPDATE SYSTEMINFO SET LOGINPAGEMESSAGE = 'Welcome to here' WHERE DATACALL = 2; END; And doing this: cfquery name=davidTest datasource=#mysession.dcname# BEGIN UPDATE SYSTEMINFO SET LOGINPAGEMESSAGE = 'Welcome to here' WHERE DATACALL = 2; END; /cfquery _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Looping a returned query to insert into another table
Mark, Since tableA and tableB use the same REQUEST.dsn1, you can try this: cfquery name=insertRecords datasource=#REQUEST.dsn1# Insert into INTO tableB (fieldnameA, fieldnameB, fieldnameC) SELECT T.field1, T.field2, T.field3 FROM tableA T WHERE T.userID = cfqueryparam cfsqltype=cf_sql_int value=#FORM.userID# /cfquery Hua -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: Friday, May 28, 2004 12:15 PM To: CF-Talk Subject: Looping a returned query to insert into another table 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: cfquery name=getRecords datasource=#REQUEST.dsn1# SELECT T.field1, T.field2, T.field3 FROM tableA T WHERE T.userID = cfqueryparam cfsqltype=cf_sql_int value=#FORM.userID# /cfquery 3) Here's the table to insert the records to: cfquery name=putRecords datasource=#REQUEST.dsn1# INSERT INTO tableB (fieldnameA, fieldnameB, fieldnameC) VALUES (#getRecords.field1#, #getRecords.field2#, #getRecords.field3#) /cfquery Thanks, Mark [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Looping a returned query to insert into another table
I am using Oracle and this works nicely in a single statement. You don't need the second query. cfquery insert into tableB (fieldnameA, fieldnameB, fieldnameC) select field1, field2, field3 from tableAWHERE T.userID = cfqueryparam cfsqltype=cf_sql_int value=#FORM.userID# /cfquery Nick Han [EMAIL PROTECTED] 05/28/04 09:15AM 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: cfquery name=getRecords datasource=#REQUEST.dsn1# SELECT T.field1, T.field2, T.field3 FROM tableA T WHERE T.userID = cfqueryparam cfsqltype=cf_sql_int value=#FORM.userID# /cfquery 3) Here's the table to insert the records to: cfquery name=putRecords datasource=#REQUEST.dsn1# INSERT INTO tableB (fieldnameA, fieldnameB, fieldnameC) VALUES (#getRecords.field1#, #getRecords.field2#, #getRecords.field3#) /cfquery Thanks, Mark [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Looping a returned query to insert into another table
Simply put a query loop around the insert block. cfloop query = resultSet cfquery ... INSERT INTO /cfquery /cfloop 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 other problem. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice:This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Bank of America estores, cfhttp, http_referer, troubles
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's it. If there is a bug in cf5's cfhttp (I don't know one way or the other) try the solution that the folks using the bofa tag found (the misspelling).Maybe its CF that was at fault.Just a thought. Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc.http://mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: download cf5
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 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 Developer, ICLP London DDI: +44 (0) 208 256 9034 (Ex.2204) www.iclployalty.com _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Looping a returned query to insert into another table
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 statement. You don't need the second query. cfquery insert into tableB (fieldnameA, fieldnameB, fieldnameC) select field1, field2, field3 from tableAWHERE T.userID = cfqueryparam cfsqltype=cf_sql_int value=#FORM.userID# /cfquery Nick Han [EMAIL PROTECTED] 05/28/04 09:15AM 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: cfquery name=getRecords datasource=#REQUEST.dsn1# SELECT T.field1, T.field2, T.field3 FROM tableA T WHERE T.userID = cfqueryparam cfsqltype=cf_sql_int value=#FORM.userID# /cfquery 3) Here's the table to insert the records to: cfquery name=putRecords datasource=#REQUEST.dsn1# INSERT INTO tableB (fieldnameA, fieldnameB, fieldnameC) VALUES (#getRecords.field1#, #getRecords.field2#, #getRecords.field3#) /cfquery Thanks, Mark _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Looping a returned query to insert into another table
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 around the insert block. cfloop query = resultSet cfquery ... INSERT INTO /cfquery /cfloop 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 other problem. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice:This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: How do you *manage* time? (Add it, Subtract it, Track it)
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 actually doing the task. This separation lends itself to more flexible reporting. So with this in mind you want to have a floating integer field and two date time fields. This way you will always know if a task is opened if the opened data time field is not NULL and the same goes for closed. I always work with a base of hours and go up and down from there. This is a little more then you asked but I hope it helps. Ian - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Ian Sheridan [EMAIL PROTECTED] http://www.savagevines.com - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - On May 28, 2004, at 9:49 AM, Jeff Small wrote: Okay, so let's say you're using SQL Server, and you want to create an application that was going to track time and do things like, eventually multiply hours by currency (hourly rate by 1 hour 45 minutes) and add several rows containing time to accumulate time spent, time remaining, etc, and graphing it with CFChart (time spent vs time allocated), etc... How would you store it and manipulate it in CF? Do you store it as a DateTime object? What if you only add time on the front end in fifteen minute increments (say, an hourdropdown with 1, 2, 3, 4, 5, 6, 7, 8 and a minutes dropdown menu with 00, 15, 30, 45 so you could, say, select 4:45 to insert for your particular time entry) do you use CF to create ODBC Date Time objects and pass those in, stored as a Date Time object? But if you enter 4:45, how does it know you're adding a *quantity* of time, rather than just saying 4:45 this afternoon? So, how *do* you store times if you want to add them and have the math work right? (For example (1:45 + 1:45)$10/hr = $35...like that) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Help executing PL/SQL
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 could get this figured out so I could tell the dba to just format your scripts like 'this and that' and drop them between the cfquery tags. Steve -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Friday, May 28, 2004 12:29 PM To: CF-Talk Subject: Re: Help executing PL/SQL Hm. Then I don't know what to tell ya. - Original Message - From: Semrau Steven Ctr SAF/IE Same results. cfsavecontent variable=plsql BEGIN UPDATE SYSTEMINFO SET LOGINPAGEMESSAGE = 'Welcome to here' WHERE DATACALL = 2; END; /cfsavecontent cfquery name=davidTest datasource=#mysession.dcname# #plsql# /cfquery 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 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Help executing PL/SQL
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 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 Schneider [mailto:[EMAIL PROTECTED] Sent: Thursday, May 27, 2004 4:55 PM To: CF-Talk Subject: Re: Help executing PL/SQL Okay, what if you take that one (without line breaks) and use cfsavecontent to save it to a variable and try to run it. Does that work? (In other words, I'm trying to figure out if it's a problem with the replace statement, or a problem with the way CF is passing the variable into the cfquery.) - Original Message - From: Semrau Steven Ctr SAF/IE Yes, doing this: cfquery name=davidTest datasource=#mysession.dcname# BEGIN UPDATE SYSTEMINFO SET LOGINPAGEMESSAGE = 'Welcome to here' WHERE DATACALL = 2; END; /cfquery returns: davidTest (Records=0, Time=94ms) SQL = BEGIN UPDATE SYSTEMINFO SET LOGINPAGEMESSAGE = 'Welcome to here' WHERE DATACALL = 2; END; And doing this: cfquery name=davidTest datasource=#mysession.dcname# BEGIN UPDATE SYSTEMINFO SET LOGINPAGEMESSAGE = 'Welcome to here' WHERE DATACALL = 2; END; /cfquery _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Sending a disconnect to Oracle through CF code...
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 this up. HTH. Janet. At 10:23 AM 5/28/2004 -0400, you wrote: Has anyone done this before?I have a task that I must check to see if the user already has an Oracle session active when they log on.If they do, do not allow the logon.If they don't, let them continue.The Oracle session lasts for 15 minutes of inactivity.When the user logs out of the application, I need to log them out of Oracle as well. Thanks in advance Brian Yager [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: functions
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 it nice enough to give to others.I
just want a callable/reusable function:
function myFunction(some_passed_var){
cfset pv = some_passed_var
cfset pv = pv+10
return pv
}
Is there something similar in CF?
--
Daniel Kessler
Department of Public and Community Health
University of Maryland
Suite 2387 Valley Drive
College Park, MD20742-2611
301-405-2545 Phone
www.phi.umd.edu
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
CFAnywhere was: CF (BD) on CD with DB Success!
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 same limitations that don't work well for an application will be applied with a read-only database. I did a little experimenting with cfexecute, and yes you can write a CF program to copy the CD contents to the local hard drive. It took about 3 minutes to copy the entire 60 Meg -- but: --I have a lot of other stuff going on --the CD contains a lot of unneeded stuff (for execution of your app) -- Docs, Source, Examples, etc. There is no install, per se -- just run the CF app that makes the copy, then execute the copy from hard disk. You might even be able to automate the switchover from CD to HD.The Copy app could use cfexecute to: -- setup a chronjob to start CFAnywhere from HD -- shutdown itself running from CD You kind of have to Re-think things -- you are executing on the desktop, not on a server.Your CF apps have access (with the appropriate permissions) to the entire Desktop, file system, underlying CLI, OS Scripting, etc. You can actually write CF apps that talk to Word, Excel, Photoshop, acrobat, iTunes... yadda, yadda, yadda! for example, if you don't like the way CF handles regexps, pass it to Perl --- not that you would, but you could! You could ripple through your iTunes library and retrieve the album covers from the internet. Dick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Invoice Template
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]
Strange error with NULLS
Anybody have experience with something like this throwing an error. cfqueryparam value=#createODBCDate(arguments.KCC_OCCUR_DTE)# null=yes cfsqltype=cf_sql_date Creates the following error: java.lang.NullPointerException at coldfusion.runtime.OleDateTime.init(OleDateTime.java:23) at coldfusion.runtime.OleDate.init(OleDate.java:14) at coldfusion.runtime.CFPage.CreateODBCDate(CFPage.java:783) at cfComplaint2ecfc464783162$funcADDCOMPLAINT.runFunction(C:\WebSites\Development\CPS\CFC\Complaint.cfc:137) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:338) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:286) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:250) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:53) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:203) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:359) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:196) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:139) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1582) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:331) at cfComplaintAction2ecfc748526927$funcPROCESSCOMPLAINT.runFunction(C:\WebSites\Development\CPS\CFC\ComplaintAction.cfc:24) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:338) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:286) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:250) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:53) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:203) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:359) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:196) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:139) at coldfusion.filter.ComponentFilter.invoke(ComponentFilter.java:102) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35) at coldfusion.filter.PathFilter.invoke(PathFilter.java:80) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.xml.rpc.CFCServlet.invoke(CFCServlet.java:62) at coldfusion.xml.rpc.CFCServlet.doPost(CFCServlet.java:138) at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:339) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:348) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:294) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Configuration: CFMX 6.1 Standard Windows 2000 Server Oracle 8i with the Oracle JDBC Thin Clint for the DSN connection Any insights would be great. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice:This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Sending a disconnect to Oracle through CF code...
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 set up with concurrent sessions set to 1 (the init.ora parameter resource_limit must be set to TRUE) which will prevent an Oracle user from logging on more than once. -If you want Oracle to automatically kill a session after so many minutes of inactivity, you can set the idle_time parameter to the desired time in a profile. Profiles are defined by the Oracle DBA and assigned to Oracle accounts when they are created.Profiles can contain information about resource usage and password restrictions. Hope this helps. Janet. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Invoice Template
Go to the Microsoft website. Go to the Office System area. Go to the downloads are. Go to thetemplates 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: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Friday, May 28, 2004 1:27 PM To: CF-Talk Subject: Invoice Template 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]
RE: Invoice Template
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 downloads are. Go to thetemplates 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: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Friday, May 28, 2004 1:27 PM To: CF-Talk Subject: Invoice Template 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]
Re: Mach-II
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 does it better, OR because other solutions don't allow it. What I say, is that in both cases it is just a false statement. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: functions
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]
[User Settings]
Re: Mach-II
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 will still re-use code just as before, and even with OOP, bad programmers may not.' M Claude Schneegans [EMAIL PROTECTED] wrote: 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 does it better, OR because other solutions don't allow it. What I say, is that in both cases it is just a false statement. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. - [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
