Re: i need help stripping :)

2004-07-23 Thread dave
i have gotten it written to a file and read and here is the output using listLast not really giving me the last, maybe cause im writing tot a txt andnot a csv? http://www.rockymtanglers.com/flows/try.cfm code !--- retrieve info from USGS website --- cfhttp url="" method=get /cfhttp !--- place

Re: i need help stripping :)

2004-07-23 Thread dave
i cant find anything grr -- Original Message -- From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Thu, 22 Jul 2004 22:31:44 -0500 i have talked to them and really have no friggin clue where are the feeds at? maybe i missed them but that

RE: Caching CFC's

2004-07-23 Thread Micha Schopman
Is the constructor in a CFC always called in CFMX when you call a method in that CFC? That's seems a bit odd to me. In my imagination, I only call the init method once, when I create the object in the application scope. After that the init is not directly invoked by me. The second example

RE: Caching CFC's

2004-07-23 Thread Micha Schopman
Nevermind, I see what you mean, it was a bug in the second part. That line should only call init on the IOFactory in the variables scope. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo

Re: i need help stripping :)

2004-07-23 Thread dave
k now i have changed this line cfset line = listLast(data, chr(13)) to cfset line = listLast(data, USGS) and works to this point http://www.rockymtanglers.com/flows/try3.cfm but now im having troubles sereating them out -- Original Message -- From: dave

Re: i need help stripping :)

2004-07-23 Thread Dick Applebaum
no need to write read a file. Just use the CFHTTP.FileContent prolly the reason listlast doesn't work is the new lines are 2 chars CR LF 1) rereplace all chr(13) with nothing 2) specify chr(10) as a delimiter in the listlast (last paraneter) HTH Dick The nice thing about standards is that

Re: OO Coding Relational Databases

2004-07-23 Thread Nick de Voil
1: I think they call it brute force, where data access is in the business objects themselves (queries right in the classes). This is generally frowned upon. It's correct to say that many OO-pattern-bandwagon-jumpers frown on this. IMO it's also correct to say that for the majority

RE: checking if variables are defined within invoke

2004-07-23 Thread Michael Kear
Another way, not always appropriate but depending on your logic, you can give the argument a default in the CFC.That way if the variable isn't passed to the CFC, it wont cause an error.Mind you, if you use it in the wrong place you wont throw an error, you'll have wrong values in your function, so

RE: A script to Prevent SQL Injection: feedback/suggestions?

2004-07-23 Thread Tim Blair
AFAIK, it actually does more than validation and escaping Yup, that's right -- I was just simplifying things a bit...:) Tim. -- --- Badpen Tech - CF and web-tech: http://tech.badpen.com/ ---

Re: i need help stripping :)

2004-07-23 Thread dave
thanks 4 helping dick really this line does most of what i need cfset last = listLast(data, USGS) takes me right to the last entry without messing with the rest heres the code to get there cfhttp url="" method=get /cfhttp cfset data = ""> cfset last = listLast(data, USGS) which gives me an

Re: Urgent help needed Please

2004-07-23 Thread Greg Stewart
What is the error that is being returned? G On Thu, 22 Jul 2004 21:40:33 -0400, Sangeeta Karmokar [EMAIL PROTECTED] wrote: I am posting this question and no one is responding... Can anyone please respond. I think I am sounding dum in your world... Sangeeta Can anyone help me I am

Re: i need help stripping :)

2004-07-23 Thread dave
ok i think i found the problem here the code on the page im pulling in is wrapped with a pre/pre tag and quick thoughts on stripping that out? thats why chr(10) chr(13) arent working [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and

Re: session var problems with Mac uses?

2004-07-23 Thread Mike Chabot
At 09:26 PM 7/22/2004, you wrote: Craps out on a Mac.I've had a couple of Mac users try it, all see the same problem, I would be surprised if this was a Mac issue. Rather, it is probably IE on Mac, or Safari, or Firefox. The Mac OS itself does not have any typical settings which would affect a

Re: Urgent help needed Please

2004-07-23 Thread powell
If you can see the CFxxx markup tags when you view source, then that means that CF is not running on the server, or that it has associated .CFM file types with something other than CF.Here's a quick test: In your CF action page, enter this code before the CFQUERY tag: Hello! cfabort Hello Again!

Re: session var problems with Mac uses?

2004-07-23 Thread powell
Thanks for the ideas, here are some answers to them: Session vars are already created before getting to the form processing page (where the CFLOCATION is used).They are created on the FORM page itself (actually the application.cfm will get them created via CFPARM). The versions of software on

RE: Urgent help needed Please

2004-07-23 Thread Ken Ferguson
Sangeeta, Please provide more detail. Is the form sending this data a .cfm file? What's the name of the file with the SQL statement on it? In what scope are the variables name and email (url/form...)? --Ferg _ On Thu, 22 Jul 2004 21:40:33 -0400, Sangeeta Karmokar [EMAIL PROTECTED] wrote:

RE: CFC Design for Multiple Person Roles

2004-07-23 Thread Dawson, Michael
This is starting to make sense now.I can imagine how I would create the CFCs. A couple questions, though; would there actually be anything in the base Roles CFC that would not already be in the main User CFC? If I wanted to know if a user was, for example, a student, would it be so simple as

CFC for dynamic menu?

2004-07-23 Thread Michael Kear
I'm building a new site, and wanting to completely separate logic from database access from presentation code, and so I am building a CFC that (amongst other things) builds menus.(There wont be more than 3 levels of menu)It'll do all the queries on the database, looping over query objects to

RE: CFC Design for Multiple Person Roles

2004-07-23 Thread Dawson, Michael
On Thu, 22 Jul 2004 18:28:56 -0400, Joe Rinehart [EMAIL PROTECTED] wrote: I've used this approach, but I've liked using structures of roles more than arrays.It lets me do a userIsInRole(string rolename) method that just returns structKeyExists(variables.instance.roles, employee).I was

sql question

2004-07-23 Thread Tony Weeg
sql gurus...got a question. lets say i have a table, and in that table there could be 2 rows for one order coming from crm system.. the first row, has a status of 1, meaning new, and process it now.the second row, would match on a order number column, but a status of 0...meaning cancelled.i want

Re: sql question

2004-07-23 Thread Thomas Chiverton
On Friday 23 Jul 2004 14:30 pm, Tony Weeg wrote: is this possible in 1 query? If you can do sub querys in your DB: select * from table a where status=1 and not exists ( select id from table b where a.id=b.id and status is 0 ) -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749

Re: sql question

2004-07-23 Thread Stephen Moretti (cfmaster)
Tony, I think you may over thinking this...It is as simple as you think you should be ;) select * from orderlines where orderno = 'xyz123' and status 0 I'm assuming here that you don't have an order status with negative numbers. Regards Stephen Tony Weeg wrote: sql gurus...got a

Re: sql question

2004-07-23 Thread Tony Weeg
my first stab... select * from stgCRM_orders where (status = 1 and status 0) group by id, crmuuid, salesOrderId, status, adminTouch, masTouch, status having crmUUID = crmUUID -- tony Tony Weeg human. email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ Check

RE: sql question

2004-07-23 Thread Dawson, Michael
Let me get this straight.You want to process only new orders that do not have an associated cancelled record, right? If so, you could use a self-join.A self-join is where you a table to itself.To do so, you must specify different table aliases (T1 and T2 in the code below). It would look

Re: sql question

2004-07-23 Thread Joe Rinehart
Hey Tony, Here's one approach: SELECT * FROM table t1 WHERE status = 1 AND NOT EXISTS ( SELECT 1 FROM table t2 WHERE t2.status = 0 AND t1.orderNumber = t2.orderNumber ) -joe - Original Message - From: Tony Weeg [EMAIL PROTECTED] Date: Fri, 23 Jul 2004 09:30:32 -0400 Subject: sql

RE: sql question

2004-07-23 Thread Ken Ferguson
Select * from table where ordereid not in (select ordereid from table where status = 0) Is the absolute first thing that comes to mind. I'm sure some better and more efficient ideas will come through though. Ken Ferguson Fitz and Floyd http://www.fitzandfloyd.com

Re: sql question

2004-07-23 Thread Deanna Schneider
Youmean like this?: SELECT * FROM table WHERE status = 1 ANDorderid NOT IN (select orderid from table where status = 0) - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, July 23, 2004 8:30 AM Subject: sql question sql gurus...got a

Re: sql question

2004-07-23 Thread Tony Weeg
if i already knew the order number, that would be easy, like you said, but its a blind look, im looking for every row, keyed off of the orderNo that doesnt have a matching row wiht the same orderNo, and a status of 0 make sense? i think thomas' idea will work...brb tw On Fri, 23 Jul 2004

Re: sql question

2004-07-23 Thread Tony Weeg
thomas aquinas something or other, you are a GEM! thanks select * from stgCRM_Orders a where status = 1 and not exists ( select crmUUID from stgCRM_orders b where a.crmUUID=b.crmUUID and status = 0 ) was what i am finally using, and it works like a charm! thanks tony -- tony Tony Weeg

Re: sql question

2004-07-23 Thread Tony Weeg
thanks for the ideas all, thomas, and joe had the same thing, thomas was quick on the draw, thanks!all good. got it working. later, and btw, HAVE A GREAT! FRIDAY On Fri, 23 Jul 2004 09:47:28 -0400, Tony Weeg [EMAIL PROTECTED] wrote: thomas aquinas something or other, you are a GEM! thanks

Re: sql question

2004-07-23 Thread S . Isaac Dealey
Umm... Unless I'm mistaken select * from mytable where status 0 will automatically remove all the items with 0 as the status... where status = 1 will get you all the items with status 1, and so will also disclude status 0 (and any other non-1 status)... sql gurus...got a question. lets say

OT: js pop-up

2004-07-23 Thread Robert Orlini
I get an error on a _javascript_ pop-up code. Something about Expected ) Its either a ) or } I'm not sure. I'm not that good with _javascript_. Any ideas on the code below please? Thx. script LANGUAGE=_javascript_ var newWindow; var firsttime=0; function PopWindow(url) { if (firsttime==0) {

Re: sql question

2004-07-23 Thread S . Isaac Dealey
Ohh... you only want records for orders that don't have any cancelled items in the order? ... yea, Tom's where not exists (...) syntax works nicely for SQL Server and Oracle -- don't know about access or mysql offhand. On Friday 23 Jul 2004 14:30 pm, Tony Weeg wrote: is this possible in 1

RE: sql question

2004-07-23 Thread S . Isaac Dealey
Let me get this straight.You want to process only new orders that do not have an associated cancelled record, right? If so, you could use a self-join.A self-join is where you a table to itself.To do so, you must specify different table aliases (T1 and T2 in the code below). It would

RE: sql question

2004-07-23 Thread S . Isaac Dealey
Select * from table where ordereid not in (select ordereid from table where status = 0) Is the absolute first thing that comes to mind. I'm sure some better and more efficient ideas will come through though. Now that you mention it, this is a good point Ken. Yea, this works similarly to

CFX and CFMX 6.1?

2004-07-23 Thread Adkins, Randy
Can anyone enlighten me on how in the world will a CFX Tag still process when the name of the JAR file has been renamed, the the directory has been changed as far as Case-Sensitivity is concerned. There are no other CFX_JSpellCheck.jar files located on the server. Not on the C, D or F Drives.

Re: OT: js pop-up

2004-07-23 Thread Ben Doom
I could be wrong, but I don't think spaces are legal between a function name and the parameters. ie window.open (bob) is wrong window.open(bob) is right. --Ben Robert Orlini wrote: I get an error on a _javascript_ pop-up code. Something about Expected ) Its either a ) or } I'm not sure.

Re: OT: js pop-up

2004-07-23 Thread Greg Stewart
Works just fine in FireFox and IE... On Fri, 23 Jul 2004 09:56:59 -0400, Robert Orlini [EMAIL PROTECTED] wrote: I get an error on a _javascript_ pop-up code. Something about Expected ) Its either a ) or } I'm not sure. I'm not that good with _javascript_. Any ideas on the code below please?

Re: sql question

2004-07-23 Thread Tony Weeg
ur right ike.and thanks for the xplanation tek it easy mon! -- tony Tony Weeg human. email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ Check out http://www.antiwrap.com to send websites to your friends. [Todays Threads] [This Message] [Subscription]

RE: OT: js pop-up

2004-07-23 Thread Robert Orlini
Seems to work now. Thx. RO -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Friday, July 23, 2004 10:47 AM To: CF-Talk Subject: Re: OT: js pop-up I could be wrong, but I don't think spaces are legal between a function name and the parameters. ie window.open (bob)

Re: CFC for dynamic menu?

2004-07-23 Thread Jeff Small
What's the best method of passing this object back from the CFC?Should I create an xml object?Or a struct containing all the menu data and submenu data?Does it matter? I can't speak for everyone here, but I love structs. I pass structs in and out of my CFCs all the freakin' time and they work

Re: CFMX Losing CFID/CFTOKEN From Session...

2004-07-23 Thread Mary Jo Sminkey
Have you found anything out about this Dan? My clients on Crystaltech servers seem to have the same issue, session.cfid does not exist, even though sessions are turned on. Does it have something to do with J2EE sessions? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe]

Oracle PL/SQL and CLOBS

2004-07-23 Thread djones
This is somewhat off topic I guess...But if someone can help me out, I would be grateful. I have a stored procedure that exports data from a series of tables to a specific format. The file is fixed with and there is data layout for the mapping.Anyway.My question is... Each row contains about

Re: CFMX Losing CFID/CFTOKEN From Session...

2004-07-23 Thread Mary Jo Sminkey
Have you found anything more out with this? I am seeing the same thing with clients running on Crystaltech servers, session.cfid does not exist, even though sessions are turned on. Would this have anything to do with J2EE sessions being turned on? [Todays Threads] [This Message]

Re: i need help stripping :)

2004-07-23 Thread Claude Schneegans
i cant find anything grr If you are tired horsing around with Regular expressions, just try CF_REextract here: http://localhost/CustomTags/REextract/testingREextract.cfm - Select http for input mode, - enter RE1=[[:cntrl:]]+USGS[[:space:]]+ - enter RE2=USGS[[:space:]]+|$ - output mode =

CF Jukebox redux

2004-07-23 Thread Dick Applebaum
Yesterday I posted a URL for my cf based A/V Jukebox. http://67.124.145.42/cfusion/mymedia/ I got several comments that while it looked good, they couldn't get it to play. My bad!I didn't get the object embed tags right, so it wouldn't work on many (mostly win) browsers. Sorry if I wasted

Re: sql question

2004-07-23 Thread Tony Weeg
its all good, thomas' was perfect, and im using it now in production :) thanks! tw On Fri, 23 Jul 2004 10:02:00 -0400, S. Isaac Dealey [EMAIL PROTECTED] wrote: Ohh... you only want records for orders that don't have any cancelled items in the order? ... yea, Tom's where not exists (...)

RE: i need help stripping :)

2004-07-23 Thread Burns, John D
Ummm, your link is to localhost and that won't work for anyone but you. John -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Friday, July 23, 2004 11:48 AM To: CF-Talk Subject: Re: i need help stripping :) i cant find anything grr If you are tired

Re: CFMX Losing CFID/CFTOKEN From Session...

2004-07-23 Thread Mary Jo Sminkey
Have you found anything more out with this? I am seeing the same thing with clients running on Crystaltech servers, session.cfid does not exist, even though sessions are turned on. Would this have anything to do with J2EE sessions being turned on? Never mind, I figured it out. Now I just

RE: CFMX Losing CFID/CFTOKEN From Session...

2004-07-23 Thread Dave Watts
Have you found anything more out with this? I am seeing the same thing with clients running on Crystaltech servers, session.cfid does not exist, even though sessions are turned on. Would this have anything to do with J2EE sessions being turned on? If you have J2EE sessions enabled, you

Re: CFC for dynamic menu?

2004-07-23 Thread Barney Boisvert
What's the best method of passing this object back from the CFC?Should I create an xml object?Or a struct containing all the menu data and submenu data?Does it matter? Depends on what you're looking to do.Structs are probably going to be slighly faster, and they'll be more familiar as well

OT: SQL Create Table w/ Escaped Column Name

2004-07-23 Thread S . Isaac Dealey
I'm going to lose my hair... create table dbo.t_migrate ( [apid] [int] NULL , [artgroup] [nvarchar](10) NULL , [triggertype] [nvarchar](1) NULL , [trigger] [real] NULL , [span] [int] NULL , [increasetype] [nvarchar](1) NULL , [increaseamt] [real] NULL , [increasepercent] [real] NULL ,

Re: CFC for dynamic menu?

2004-07-23 Thread Jeff Small
Depends on what you're looking to do.Structs are probably going to be slighly faster, and they'll be more familiar as well (since you use them all the time).XML, on the other hand, will let you build the navigation with XSL, which can be very advantageous in certiain situations.In addition,

Re: CF Jukebox redux

2004-07-23 Thread Robert Munn
Yesterday I posted a URL for my cf based A/V Jukebox. http://67.124.145.42/cfusion/mymedia/ Any feedback on the site will be greatly appreciated. I can't get the popup window to open on Windows/IE 5.5 using the Open Popup Window link. I get a JS error, line 1, char 2 Control.cfm Object doesn't

Re: Oracle PL/SQL and CLOBS

2004-07-23 Thread I-Lin Kuo
Hi David, You've explained what you're trying to implement but not enough of why you've chosen to implement things this way. CLOBS are slow so you should try to avoid them unless necessary, but I don't have enough of an understanding of what problem you're trying to solve to say whether or not

RE: SQL Create Table w/ Escaped Column Name

2004-07-23 Thread Tangorre, Michael
Not that this should make a whole lot of difference I the context of your issue, but I try and steer clear of using reserved words (trigger,description) for column names. I doubt it has anything to do with your problem but just thought I would throw that in there. Mike I'm going to lose my

Re: CF Jukebox redux - what browsers to support.

2004-07-23 Thread Dick Applebaum
Thanks, Robert I didn't test on IE 5.5 You should hear some songs and see a brief slide show with Play Smil playlist. If you click on a song name the playlist will start at that song -- skipping any unchecked songs. Brings up a good question -- What browsers should I support especially on

Re: CFC for dynamic menu?

2004-07-23 Thread Barney Boisvert
My approach in this situation would be to create a CFC that queries the Database, then another CFC to wrap the Query results in XML. Would that be a proper MVC approach? Couldn't you view the WrapInXML() CFC as a proper controller method? If I needed multiple formats, I'd probably make a

Re: i need help stripping :)

2004-07-23 Thread Claude Schneegans
Ummm, your link is to localhost and that won't work for anyone but you. Ooops, I cut'n paste the link from the wrong window :-( It is http://www.contentbox.com/claude/customtags/REextract/testingREextract.cfm Sorry about that. - Select http for input mode, - enter

Recurring scheduler-originating error from unscheduled task

2004-07-23 Thread Scott Weikert
Hey all, I've got an server issue that I can't seem to puzzle out. On one of my servers (I've got two, behind a load balancer), I've lately been getting a bunch of unacceptable email address type errors, at the top of the hour, every hour. The exception log labels them as from scheduler-1.

Re: CFC for dynamic menu?

2004-07-23 Thread Jeff Small
If I needed multiple formats, I'd probably make a single CFC that has three methods, one to pull the raw menu query (probably delegatin gto a dedicated DAO), one to pull the menu as a structure, and one to pull the menu as XML.That's really a single job, so it makes sense to have it all in

RE: SQL Create Table w/ Escaped Column Name

2004-07-23 Thread S . Isaac Dealey
well so do I, but I didn't develop this app or these db's unfortunately... of all the things that are wrong with this app, keywords is the least significant... of course, until I have to create a table with cf... Not that this should make a whole lot of difference I the context of your issue,

RE: SQL Create Table w/ Escaped Column Name

2004-07-23 Thread Ken Ferguson
We all know Ike wouldn't do this of his own choosing. At least any of us who have worked with him do. What happens if, as a test, you try to do something likened to this: cfquery Create table dbo.t_testing([trigger] int NULL) /cfquery What's that give you??? -Ferg _ From: Tangorre,

Re: sql question

2004-07-23 Thread S . Isaac Dealey
urvirulelkomein ur right ike.and thanks for the xplanation tek it easy mon! -- tony Tony Weeg human. email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ s. isaac dealey954.927.5117 new epoch : isn't it time for a change? add features without fixtures

RE: SQL Create Table w/ Escaped Column Name

2004-07-23 Thread Ken Ferguson
We all know Ike wouldn't do this of his own choosing. At least any of us who have worked with him do. What happens if, as a test, you try to do something likened to this: cfquery Create table dbo.t_testing([trigger] int NULL) /cfquery What's that give you??? -Ferg _ I'm going to lose

Re: Oracle PL/SQL and CLOBS

2004-07-23 Thread djones
I tried not to go into too much detail because the application is complicated and I was afraid that I would spend too much time explaining the application.I'm not looking for syntax, just an Idea. I have a string of data that can be more that 40,000 chars long and I am using a CLOB while

RE: SQL Create Table w/ Escaped Column Name

2004-07-23 Thread Ken Ferguson
OK, try this as a test. It worked on Oracle, but who knows... !--- I guess you'll need to put the brackets back in place of the double quotes. --- cfquery name=ts datasource=#application.dsn# create table testing(apid int NULL , artgroup int NULL , triggertype int NULL , trigger int NULL , span

RE: Oracle PL/SQL and CLOBS

2004-07-23 Thread Steven Erat
David, Assuming this is Oracle, if you're using the Macromedia drivers with a stored procedure that has an output parameter type of varchar2, then even though the varchar2 datatype can hold up to 32k the Macromedia Oracle driver will only return the first 4k.If you use the Oracle Thin Client

Session-Based CFC Usage Across Clusters

2004-07-23 Thread Dawson, Michael
I have read that session-based CFCs cannot be clustered (according to a livedoc comment). Because of this, how many people have decided to stick with using session-based CFCs rather than deal with the issues related to clustering? If you decided to focus on clustering and not use

Re: RE: Oracle PL/SQL and CLOBS

2004-07-23 Thread djones
I am using the Oracle 9i driver. Not sure if it's the thin client or not. Funny you should, say that.I think I am using varchar2 as the out parameter and not CLOB but only because I was using varchar2 before the CLOB and just never changed it.Thanks for the heads up. David -Original

CFMX memory usage on specific page request

2004-07-23 Thread Brook Davies
I run a web application that handles many form submissions through the same 'form handler' series of templates. My application quickly grows to 850 megs memory usage and I have been trying to figure out where that memory is being used. Yesterday, I put my form submission handler template in a

Re: CFMX memory usage on specific page request

2004-07-23 Thread Bryan Stevenson
Well Brook...as I've said before ;-) I've seen that happen where 1 page causes JRun to eat up memory.The difference is that it wouldn't stop and an error would eventually be thrown. This was due to really stupid parsing errors like: cfset MyVar = blah or cfinclude template=blah.cfm or cflocation

RE: CFMX memory usage on specific page request

2004-07-23 Thread Burns, John D
Any chance of taking portions out of the form handler one at a time? Does debugging clue you in on anything? John -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED] Sent: Friday, July 23, 2004 3:09 PM To: CF-Talk Subject: CFMX memory usage on specific page request I run a

Bypassing wsconfig

2004-07-23 Thread Mike Chabot
I wanted to set up CFMX 6.1 to run along side CF5 on a production server, without disrupting the CF5 sites. CFMX 6.1 will respond to a single directory on the server and CF5 will respond to everything else. I could not easily use wsconfig for this because that would knock out the CF5 server

Re: Session-Based CFC Usage Across Clusters

2004-07-23 Thread Mike Chabot
At 02:42 PM 7/23/2004, you wrote: I have read that session-based CFCs cannot be clustered (according to a livedoc comment). It depends on how you do the clustering. Our clustering is done by IP block, I believe just using the clustering ability built into Windows 2000 Advanced Server. One block

Any Oracle ODBC driver that makes sense?

2004-07-23 Thread Claude Schneegans
Hi, Is there anywhere an Oracle ODBC driver that makes sense? I mean, i'm testing 3 of them, and none will return reliable information about the same datasource: - Oracle ODBC driver version 10.01.0002 which comes with the last version 10g of the Oracle server: it returns only 20 Schema names and

RE: CFMX memory usage on specific page request

2004-07-23 Thread Brook Davies
Yeah, I'm gonna have to go through template by template and add cfaborts. Test run the loop, check the ram usage and continue until I find the problem I guess.I'm just wondering if this is normal or not? Should memory usage increase like this when no new data is being stored in the application

RE: Session-Based CFC Usage Across Clusters

2004-07-23 Thread Matt Liotta
Currently, BlueDragon supports CFCs shared across clusters in the session scope. My understanding is that Blackstone will support this as well. -Matt -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dawson, Michael Sent: Friday, July 23, 2004 2:42 PM

Dynamically Add Form Fields

2004-07-23 Thread Jillian Carroll
Hey... I have a need to dynamically (using a button/link) add additional fields to a form.Does anybody have/know of a solution for this? (purchased or otherwise) -- Jillian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: Session-Based CFC Usage Across Clusters

2004-07-23 Thread Barney Boisvert
We skipped session variables in favor of custom client variables and traded session-scoped CFCs for something akin to a flyweight pattern implementation.Our client variables setup is almost identical to what CF provides, except that it allows complex values (because it's serialized using WDDX,

RE: CFMX memory usage on specific page request

2004-07-23 Thread Stacy Young
Is it possible that each request is adding additional objects into application scope? (rather than invoking once and re-using that same instance) Aside form that it's tough to say without digging into the code... Cheers, Stace _ From: Brook Davies [mailto:[EMAIL PROTECTED] Sent: Friday,

RE: CFMX memory usage on specific page request

2004-07-23 Thread Jim Gurfein
Have you considered using the code analyzer in the administrator? At 01:04 PM 7/23/2004 -0700, you wrote: Yeah, I'm gonna have to go through template by template and add cfaborts. Test run the loop, check the ram usage and continue until I find the problem I guess.I'm just wondering if this is

RE: CFMX memory usage on specific page request

2004-07-23 Thread Burns, John D
Well, that's the million dollar question.It sounds like from the experience of other users that bad coding could cause that.Or maybe there is some weird thing you're doing that is storing something in RAM that you're not thinking of.Going piece by piece seems like the best chance of figuring it

RE: CFMX memory usage on specific page request

2004-07-23 Thread Brook Davies
I'll go through it this weekend, template by template and see where the RAM spikes. Thanks guys! Brook At 01:32 PM 7/23/2004, you wrote: Well, that's the million dollar question.It sounds like from the experience of other users that bad coding could cause that.Or maybe there is some weird thing

Re: Dynamically Add Form Fields

2004-07-23 Thread Barney Boisvert
I've seen solutions where the a placeholder div is insert into the original page content, and then you use _javascript_ to dynamically write new form fields into the div, as needed. Don't know where I saw it, but that's probably the first avenue I'd try. cheers, barneyb On Fri, 23 Jul 2004

Re: Session-Based CFC Usage Across Clusters

2004-07-23 Thread Robert Munn
If you decided to focus on clustering and not use session-bases CFCs, how did you implement your processes? The general strategy for implementing across a cluster is to move data from the session scope to the client scope. There are limitations, one of which is that the client scope can't easily

RE: Dynamically Add Form Fields

2004-07-23 Thread Tangorre, Michael
Jillian, Go to www.pengoworks.com and check out qForms. It is a _javascript_ API that has some methods you are looking for. There is also a mailing list to ask qForms questions on, its over at yahoo. Anyway, check it out and good luck! Mike Hey... I have a need to dynamically (using a

Re: i need help stripping :)

2004-07-23 Thread dave
it still gets me the same results as i had before 09085000 2004-07-23 12:30 800 59.9 which i cant seem to break into individual pieces to send to an array -- Original Message -- From: Claude Schneegans [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED]

Re: Session-Based CFC Usage Across Clusters

2004-07-23 Thread Sean Corfield
On Fri, 23 Jul 2004 13:42:18 -0500, Dawson, Michael [EMAIL PROTECTED] wrote: I have read that session-based CFCs cannot be clustered (according to a livedoc comment). Session-based CFCs cannot be replicated in CFMX 6.1 but you do not require session replication in order to build a cluster.

RE: Session-Based CFC Usage Across Clusters

2004-07-23 Thread Dawson, Michael
Where you'd call a method on your session-scoped CFC, we call a method on a shared CFC instance, passing in the client variable structure, which represents the state that your session CFC would have in instance variables. Can you clarify what you mean by shared CFC instance?Do you mean in

Re: i need help stripping :)

2004-07-23 Thread Claude Schneegans
it still gets me the same results as i had before 09085000 2004-07-23 12:30 800 59.9 which i cant seem to break into individual pieces to send to an array Ok, but now that you have the string, you can break it easily by treating it as a space delimited list, ie: CFQUERY... INSERT INTO myTable...

Re: i need help stripping :)

2004-07-23 Thread Dick Applebaum
This is a tab-separated list so, use listgetat with a chr(9) delimiter. HTH Dick The nice thing about standards is that there are so many of them to choose from. - Andrew S. Tanenbaum - On Jul 23, 2004, at 2:04 PM, dave wrote: it still gets me the same results as i had before 09085000

Re: Dynamically Add Form Fields

2004-07-23 Thread Dick Applebaum
_javascript_ can do this, have a look at: document.open document.write document.close HTH Dick The nice thing about standards is that there are so many of them to choose from. - Andrew S. Tanenbaum - On Jul 23, 2004, at 1:15 PM, Jillian Carroll wrote: Hey... I have a need to dynamically

RE: Session-Based CFC Usage Across Clusters

2004-07-23 Thread Dawson, Michael
So to keep from having to re-write my applications, I would need to ensure that Win2k3 NLB supports sticky sessions and that the feature enabled?I'm new to NLB, but I'll dig around this weekend. I would rather stay with session-based CFCs and take the small chance that the network connection or

RE: Session-Based CFC Usage Across Clusters

2004-07-23 Thread Dave Watts
So to keep from having to re-write my applications, I would need to ensure that Win2k3 NLB supports sticky sessions and that the feature enabled?I'm new to NLB, but I'll dig around this weekend. NLB in Windows Server 2003 supports sticky sessions, they're called single affinity within the

cf_multirelatedselects

2004-07-23 Thread Greg.Morphis
Has anyone been able to get the ONCLICK1 event to work with this tag? Absolutely nothing is happening when I change the first select box. I even tried alert('hi'); on the onclick2, nothing happened there. CF_MultiRelatedSelects SELECTBOXES = 2 QUERY=location_facility FORMNAME = laforma

RE: cf_multirelatedselects

2004-07-23 Thread Dave Watts
Has anyone been able to get the ONCLICK1 event to work with this tag? ... this.options[this.options.selectedIndex].text,'newWin'); I don't know what that custom tag is doing exactly, but you probably don't want to use _javascript_: within an event handler. That's only for invoking

Re: A script to Prevent SQL Injection: feedback/suggestions?

2004-07-23 Thread Andrew Grosset
Hi Matt, I think it might have been me! no aplogies needed :) (just trying to keep this excellent thread alive) regards, Andrew. and CodeCleaner: http://www.antiwrap.com/?140 I use this in Application.cfm to scrub the url.Takes about 10ms. Got it from a thread here.Apologies to the author

RE: cf_multirelatedselects

2004-07-23 Thread Douglas Knudsen
i suspect teh use of JAVASCTIPT:its not use in events, rather in none even instances such as HREF. Doug -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, July 23, 2004 7:20 PM To: CF-Talk Subject: cf_multirelatedselects Has anyone been able to get the

RE: Dynamically Add Form Fields

2004-07-23 Thread Douglas Knudsen
make use of the browsers DOM.Check out brainjar.com for examples.You can create any HTML element, tweak its attributes then append it to any other part of your document all on the fly. Doug -Original Message- From: Jillian Carroll [mailto:[EMAIL PROTECTED] Sent: Friday, July 23, 2004

  1   2   >