Re: retrieve ID from db insert

2005-07-12 Thread Aaron Rouse
+ 1 as newid FROM tblname, then you would have to worry about this > issue and use a transaction or lock orsomething. But with Oracle's > sequence, > no need to worry. > > DK > > On 7/12/05, Aaron Rouse <[EMAIL PROTECTED]> wrote: > > > > Yes, but isn&#x

Re: retrieve ID from db insert

2005-07-12 Thread Aaron Rouse
Yes, but isn't the point in doing the CFTRANSACTION in the way I am describing to ensure that you get the ID of what you just inserted in order to pass it back to the website? More than likely to pass it back with a URL for telling the user hey this is where you go to view status or to edit what

Re: retrieve ID from db insert

2005-07-11 Thread Aaron Rouse
On 7/11/05, Douglas Knudsen <[EMAIL PROTECTED]> wrote: > > On 7/11/05, Aaron Rouse <[EMAIL PROTECTED]> wrote: > > > > How many times would it really matter if it did? I have seen sometimes > > where > > a "new app" would start off at say ID val

Re: retrieve ID from db insert

2005-07-11 Thread Aaron Rouse
How many times would it really matter if it did? I have seen sometimes where a "new app" would start off at say ID value of 143 just because of all the testing and not resetting the sequence never seemed to be an issue though. Guess I just look at it differently, because the way I look at it is

Re: retrieve ID from db insert

2005-07-11 Thread Aaron Rouse
Is there a reason to want to avoid using cftransaction? On 7/11/05, Douglas Knudsen <[EMAIL PROTECTED]> wrote: > > and you do not need cftansaction either. once query 1 executes, you have > the > id in hand. if another request came in it would get a differnt id. simply > based on the uniqueness

Re: retrieve ID from db insert

2005-07-11 Thread Aaron Rouse
I always just use triggers for when inserting, but it seemed like the worry here was to know the ID after the insert to I'd guess display to the user. How would a trigger help for that need? On 7/11/05, Eddie Awad <[EMAIL PROTECTED]> wrote: > > > Of course, you could also just create a "when-

Re: retrieve ID from db insert

2005-07-11 Thread Aaron Rouse
That syntax is invalid for Oracle. As far as SQL Server, I believe it is fine but I have watched a couple of debates on it via this mailing list so as with all things best to just research over taking someones word. :) On 7/11/05, Russ <[EMAIL PROTECTED]> wrote: > > This does work properly i

Re: retrieve ID from db insert

2005-07-11 Thread Aaron Rouse
I have yet to see a way of doing this in Oracle/CFQUERY that works in all situations. Actually I have yet to see it work, but have heard of it working which is why I put "situations" On 7/11/05, Russ <[EMAIL PROTECTED]> wrote: > > Why not just do something like this (sql server) > > Insert in

Re: retrieve ID from db insert

2005-07-11 Thread Aaron Rouse
Or if you wanted to do it all in one "tag" you could just put it into a SP and run it that way. There are of course various views as to the added advantage of doing this, you can swearch through the list archives for all of those. :) On 7/11/05, daniel kessler <[EMAIL PROTECTED]> wrote: > > o

Re: retrieve ID from db insert

2005-07-11 Thread Aaron Rouse
In reference to the first email, you would do a CFTRANSACTION and not a CFLOCK. On 7/11/05, Douglas Knudsen <[EMAIL PROTECTED]> wrote: > > search the archives, this has been discussed several times here. In short, > do two queries. query 1, get the next val in your sequence. now you have > your

Re: Poor performing Oracle Query

2005-07-08 Thread Aaron Rouse
Does it run slow from SQLPlus when executed from the web server itself? For perhaps a "quick" fix I'd probably try throwing it into an SP and calling that to see if the delay in executing goes away. On 7/8/05, Ian Skinner <[EMAIL PROTECTED]> wrote: > > I'm told about 10, but those ten are sum

Re: Web Services over HTTPS

2005-07-07 Thread Aaron Rouse
d definately talk with MM about this... and definately post the > results. =] > > Kevin > > - Original Message - > From: "Aaron Rouse" <[EMAIL PROTECTED]> > To: "CF-Talk" > Sent: Thursday, July 07, 2005 11:09 AM > Subject: Re: Web Servic

Re: Web Services over HTTPS

2005-07-07 Thread Aaron Rouse
t a valid certificate (we use > www.thawte.com<http://www.thawte.com>), > your problems should > disappear. In fact, this was the only issue we ran into during the whole > process. > > Kevin > > - Original Message - > From: "Aaron Rouse" <[EMAI

Re: Web Services over HTTPS

2005-07-07 Thread Aaron Rouse
> the > > same error. > > The error we get and steps we have tried are very similar to what is > > listed > > on this link: > > > > > http://groups-beta.google.com/group/macromedia.coldfusion.component_development/browse_thread/thread/1f44ebc4b830e50a/f1b338a3de949825

Web Services over HTTPS

2005-07-07 Thread Aaron Rouse
had to apply a different solution that was is detailed on that link. -- Aaron Rouse http://www.happyhacker.com/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and

Re: Proper way to refer to form objects

2005-07-05 Thread Aaron Rouse
If it could possibly come in through some other scope then probably best to always copy it in from where it could come from and then reference that. For instance we have some pages that can refer to variables from the Form or URL scope. So we do something like this: http://Form.ID>" default="0

Re: Calling .net service with CF

2005-07-01 Thread Aaron Rouse
Yeah, I just fed in a simple array and it worked, just slowly learning how to use these fansy smanshie tools in DWMX On 7/1/05, Dave Watts <[EMAIL PROTECTED]> wrote: > > > When connecting with DWMX to a web service(Java one to be > > exact), what does it mean when it lists "String[][] blah" I

Re: Calling .net service with CF

2005-07-01 Thread Aaron Rouse
When connecting with DWMX to a web service(Java one to be exact), what does it mean when it lists "String[][] blah" I was just looking at one and have 4 different ones that are "String uniquename" but then that one that has the double brackets. On 7/1/05, Dave Watts <[EMAIL PROTECTED]> wrote:

Re: cachedwithin issues

2005-06-30 Thread Aaron Rouse
I believe that cachedwithin will cach the query by its name assignment regardless of any SQL changes you might do to it. Or are you saying you have the same query name on multiple pages that is cached on all pages but the SQL is different between those? I have never tested to see if that would

Re: Server names

2005-06-28 Thread Aaron Rouse
I once worked somewhere that named theirs after old arcade games. On 6/28/05, Kay Smoljak <[EMAIL PROTECTED]> wrote: > > On 6/29/05, Dave Watts <[EMAIL PROTECTED]> wrote: > > It's worth pointing out that listing your internal server names - or, > better > > yet, describing how you name them - is

Re: Dump CFCATCH

2005-06-28 Thread Aaron Rouse
thanks, now to just see if I can get them to apply it On 6/28/05, Chris Norloff <[EMAIL PROTECTED]> wrote: > > ColdFusion MX 6.1 Updater: Hot fix for cfdump throwing unknown type error > for cfcatch structure > http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=1a9c83c > > --

Re: Dump CFCATCH

2005-06-28 Thread Aaron Rouse
o. just don't have > > the convenience of dumping 'em all out in one swell foop. > > > > > > On 6/28/05, Aaron Rouse <[EMAIL PROTECTED]> wrote: > > > >>What version of CF are you using? I have some code that pretty certain > did > >>

Re: Dump CFCATCH

2005-06-28 Thread Aaron Rouse
What version of CF are you using? I have some code that pretty certain did this on CF5 and worked fine but now on our 6.1 server it does the same thing, does not on our 7 server. Was told it is a known bug but I did not look to verify that word of mouth information. On 6/28/05, Trevor Orr <[EMA

Re: cfqueryparam

2005-06-27 Thread Aaron Rouse
me the values are injected, the SQL engine has already done > everything, so there's no way for any SQL in a value to be executed. > > With literal values, you don't have either of those problems, so using > CFQUERYPARAM is entirely superfluous. > > cheers, > barne

Re: cfqueryparam

2005-06-27 Thread Aaron Rouse
But then you might forget to use them when you key in some literals, such as: SELECT ID, BLAH FROM MYTABLE WHERE MYSTATUS = On 6/27/05, Barney Boisvert <[EMAIL PROTECTED]> wrote: > > Much simpler (but the same) meaning, is just that you should NEVER > have hashes inside CFQUERY tags, unless

Re: _Returntype_=_""void'._What's_it_mean?

2005-06-26 Thread Aaron Rouse
For INSERT/DELETE/UPDATE statements I usually return booleans even though really if an error ever happened I would not see false but instead be dealing with error trapping/catching. Now for INSERT SQL methods I do sometimes return the new ID, just depends on the design of that system. On 6/26/0

Re: OT: Anyone ever heard of not allowing FTP?

2005-06-24 Thread Aaron Rouse
Sounds reasonable to me well except the thumb drive part. However here we are not a lot better. We have to put out tickets to our data center to tell them which files(can be all) to copy from the Dev server to the Prod server. Same goes for any database changes except those we have to provide SQ

Re: CFINSERT Question

2005-06-23 Thread Aaron Rouse
I used which is simply a wrapper more or less for a CFC On 6/23/05, S. Isaac Dealey <[EMAIL PROTECTED]> wrote: > > Which is just one of the many reasons you should always use request.tapi.sql.update("db_table")> instead of :P > > ~~~

Re: CFINSERT Question

2005-06-23 Thread Aaron Rouse
Yeah, just with cfinsert it does not display the "key" like we get with cfqueryparam. The "key" being the portion of the debug information that lists the datatype and the value. On 6/23/05, Ian Skinner <[EMAIL PROTECTED]> wrote: > > Don't know if this applies to cfinsert, but the question mark

Re: CFINSERT Question

2005-06-23 Thread Aaron Rouse
Check your database, the values should be inserted still. To know what each ? equates to you just have to scroll down more to where the Form fields are listed in the rest of the debug information. On 6/23/05, Smith, Daron [PA] <[EMAIL PROTECTED]> wrote: > I have a form and I want to use CFINSE

Re: query help

2005-06-22 Thread Aaron Rouse
That is an interesting requirement although when I look back I think almost every system I ever worked with had a column named ID in each table. Here at work the inhouse framework they make use us, pretty much requires the PK of a table be just ID and numeric. There are ways around it but they a

Re: Open Cursors

2005-06-21 Thread Aaron Rouse
I still think you should look into JDBC drivers, when we addressed that it fixed the issue. The reason we even looked into it was because the Oracle admins here fight with every ounce they have against changing one setting in their environment. What we noticed is the issue did not happen in CF5

Re: Open Cursors

2005-06-20 Thread Aaron Rouse
We ran into this with CFMX 6.1 and most solutions we found online said to increase the setting in Oracle. What we found however was that it was JDBC version related. It does not happen at all when using CFMX 7.1 and whatever drivers it has. On 6/20/05, Dustin Tinney <[EMAIL PROTECTED]> wrote:

Re: Who's using CF recommendations anyone

2005-06-13 Thread Aaron Rouse
Here is one, what it does not show is that their intranet is almost all CFM http://www.slb.com/ On 6/13/05, Steve Kahn <[EMAIL PROTECTED]> wrote: > > Anyone have a good recommendation of companies using cf for their sites. I > know I saw a Dell site recently but cant remember the link. Also d

Re: Get New Record ID in ORACLE

2005-06-09 Thread Aaron Rouse
I did not try it in a CFC and did not try it all within one line so guessing that is why it failed for me. I actually have no real need for it, just always been something I have wondered how to get working. On 6/9/05, RADEMAKERS Tanguy <[EMAIL PROTECTED]> wrote: > > > i see the bug outside a

Re: Get New Record ID in ORACLE

2005-06-09 Thread Aaron Rouse
re you using? > > We are on 9i and we use the native CF/Oracle JDBC driver (i.e. > DataDirect) that comes with Enterprise. It may not work in the thin > driver or other flavours. > > -Original Message- > From: Aaron Rouse [mailto:[EMAIL PROTECTED] > Sent: Wednesday, 8 Jun

Re: nevermind -- asynch cfml gateway - working example

2005-06-08 Thread Aaron Rouse
I know, I was merely speculating as to what Issac was referring to. On 6/8/05, Sean Corfield <[EMAIL PROTECTED]> wrote: > > On 6/8/05, Aaron Rouse <[EMAIL PROTECTED]> wrote: > > I just tried to open it up in Notepad, it is all bunched together in > there > >

Re: Get New Record ID in ORACLE

2005-06-08 Thread Aaron Rouse
Nice, I had a nice upward battle to get Toad on my machine. Now if I could just learn half of the things within it, then my life would probably be even better. ;) On 6/8/05, Douglas Knudsen <[EMAIL PROTECTED]> wrote: > > yup, good thread, tasty too. I'm not an Oracle DBA, but I did stay at a >

Re: nevermind -- asynch cfml gateway - working example

2005-06-08 Thread Aaron Rouse
I just tried to open it up in Notepad, it is all bunched together in there so makes it rather hard to follow. On 6/8/05, Sean Corfield <[EMAIL PROTECTED]> wrote: > > On 6/8/05, S. Isaac Dealey <[EMAIL PROTECTED]> wrote: > > >> Frustratingly the readme is virtually illegible under > > >> Windows.

Re: Get New Record ID in ORACLE

2005-06-07 Thread Aaron Rouse
I will have to add it to my list of books to one day read. I have a pretty big stack right now that I am slowly going through. Think I still have one or two Oracle related books in that stack actually. We actually have been running Oracle for many years now here, just not many people here do muc

Re: Get New Record ID in ORACLE

2005-06-07 Thread Aaron Rouse
Syntax like that throws an error for me when tried in a cfquery. On 6/7/05, James Holmes <[EMAIL PROTECTED]> wrote: > > This would work in a cfquery: > > DECLARE newid NUMBER; > BEGIN > select s.nextval into newid from dual; > etc > END; > > but I don't know why you would bother. Since yo

Re: Get New Record ID in ORACLE

2005-06-07 Thread Aaron Rouse
Because this is a big oilfield company that spent way too much money with Oracle and is looking for any excuse to just use it. They appear to not care if it is used "right" or not. The web applications do not do much more than simple queries, other groups might very well be doing things much mor

Re: Get New Record ID in ORACLE

2005-06-07 Thread Aaron Rouse
I guess we just run too simple of insert/update queries to see how performance could ever need to be better or an issue. Although of the few ones that effect a lot of records they are sitting in SPs, but those statements are not what I would label "basic" either. I thought if a cftransaction wa

Re: Get New Record ID in ORACLE

2005-06-06 Thread Aaron Rouse
What type of advantages does an SP in oracle(or whatever) have over queries for basic DB inserts? On 6/6/05, James Holmes <[EMAIL PROTECTED]> wrote: > > I agree here too - I've been writing stored procs (and other PL/SQL) for > a few things and I'm eventually going to convert everything I have

Re: Get New Record ID in mySQL

2005-06-04 Thread Aaron Rouse
I am not familar with MySQL but what would be the advantage of using that function over just using INSERT INTO myTABLE (myCOLUMNS) VALUES (myVALUES) SELECT MAX(ID) AS NewID FROM myTABLE NewID = #Get.NewID# On 6/4/05, Barney Boisvert <[EMAIL PROTECTED]> wrote: > > Check out the LAST_INSE

Re: CF vs LAMP

2005-05-31 Thread Aaron Rouse
Doesn't their Action Pack come with MSSQL Server as well? I think I pay like $200/year for that which has never seemed like a ton of money for what all it provides. On 5/31/05, John Paul Ashenfelter <[EMAIL PROTECTED]> wrote: > > > I find MS licensing documents to be a bear to read through --

Re: CF vs LAMP

2005-05-31 Thread Aaron Rouse
Interesting, I rarely ever need the need to do this so never looked for a better approach. I see you can rename the column, table, and constraints. http://www.oracle-base.com/articles/9i/RenamingColumnsAndConstraints9i.php On 5/31/05, Bryan Stevenson <[EMAIL PROTECTED]> wrote: > > Yep..after

Re: CF vs LAMP

2005-05-31 Thread Aaron Rouse
It became easier post 8i? Now I am wondering how it is done post 8i because just been using the same old method for years more out of habbit than anything else. On 5/31/05, Bryan Stevenson <[EMAIL PROTECTED]> wrote: > > try renaming a column in 8i...wholly > crap

Re: CF vs LAMP

2005-05-31 Thread Aaron Rouse
I always thought you could have Ent Manager at no cost, what type of licensing issues prevent you from having it on your home computer? I am not much of a MSSQL person so do not keep up with all that. On 5/31/05, Richard Crawford <[EMAIL PROTECTED]> wrote: > > On Tuesday 31 May 2005 12:42, Ru

Re: DB Design, Engineering & Re-Engineering Software

2005-05-20 Thread Aaron Rouse
That one sounds nice, the only bad thing about it is all of our data models need triggers here so would have to get the more expensive one for that. Not really a terrible thing since would want to do the views and SPs from time to time anyway. On 5/20/05, Dave Merrill <[EMAIL PROTECTED]> wrote:

Re: DB Design, Engineering & Re-Engineering Software

2005-05-20 Thread Aaron Rouse
Will Visio build all the SQL scripts needed to build the DB? If so, will it do it for databases other than MSSQL? On 5/20/05, Michael T. Tangorre <[EMAIL PROTECTED]> wrote: > > Visio > > > > > Michael T. Tangorre > > > > ~

Re: DB Design, Engineering & Re-Engineering Software

2005-05-20 Thread Aaron Rouse
I have been using a program called DeZign with pretty good success. If you want to import an existing database model you have to buy their importing tool as well. Both put together in cost are not a huge amount of money though. On 5/20/05, Andy Ousterhout <[EMAIL PROTECTED]> wrote: > > Any r

Re: I truly hate Ben Forta

2005-05-11 Thread Aaron Rouse
Having books around for others to reference here at work has been one of the better things I have done. Since we work a lot with CF5 still here, I have a wrox CF5 book, CFWACK 5, O'Reilly's CF 5 book and then an O'Reilly HTML and Javascript books sitting here. Do not think I have ever referenced

Re: I truly hate Ben Forta

2005-05-11 Thread Aaron Rouse
What color was the 3.0 one? I have a bright yellow CFWACK and always assumed it was for version 3. I have the 4.0 one and a 5.0 one as well. Heck I still have the docs for CF 1 sitting on my desk, maybe I should clean up that desk one of these days. On 5/11/05, Jim Davis <[EMAIL PROTECTED]> wro

Re: Books on OOP & CFML (6.1 or 7)

2005-05-11 Thread Aaron Rouse
When I looked into learning OOP everyone told me to read up on design patterns and work from there. I have a few books at home, one of which I read when I head to the gym but their names are eluding me. Neither are CF related at all though and I think there are none specific to OOP+CFML or were

Re: longer than a varchar2

2005-04-29 Thread Aaron Rouse
Yes, just type it in and if you want it to be in the drop down refer to this quote from Greg Morphis who posted it on this list earlier today: "To add CF_SQL_CLOB to the dropdown in Homesite and Dreamweaver, do the following.. -- I've noticed that CF_SQL_CLOB

Re: SQL =>Oracle equivalents

2005-04-29 Thread Aaron Rouse
SELECT * FROM FOO WHERE ROWNUM <= 5 but I think TOP 5 returns the top 5 in the table? Probably need to do a sub-select to get the ordering in there. SELECT BLAH FROM (SELECT BLAH FROM FOO ORDER BY SORTORDER) WHERE ROWNUM <= 5 Hopefully I did not mess that up, I am frying my brain right now over

Re: longer than a varchar2

2005-04-29 Thread Aaron Rouse
Did these guys make it for you? http://www.sea-code.com/ On 4/29/05, Dawson, Michael <[EMAIL PROTECTED]> wrote: > > >Are they downsizing you while they're at it or giving you other things > to do? > > Oh, no. I'm still here. *Someone* has to push the "Create Web Site > Wizard" button. I'm more

Re: longer than a varchar2

2005-04-29 Thread Aaron Rouse
They turn their nose up to it here. The only reason I have figured out is they like to copy/paste queries into SQL Plus. On 4/29/05, Deanna Schneider <[EMAIL PROTECTED]> wrote: > > > At my current 9-5 job my boss (the technical one) isn't sold on > > cfqueryparam, although he doesn't berate any

Re: longer than a varchar2

2005-04-29 Thread Aaron Rouse
>From what I recall, If using CF5 there is no cfqueryparam type for the clobs. I seem to recall appending data into clobs when using CF5. Just thought I would note that in case someone is doing this on a older version of CF. I ran into it maybe 3-4 months ago when working on one of our older bo

Re: what is the proper way to code the following

2005-04-27 Thread Aaron Rouse
No idea if this helps but I have noticed in 6.1 that if you run a bunch of things on one page it seems like CF just keeps using resources and never releasing what was used until the page finishes loading. For example we have this "ugly" page that connects to one datasource, grabs 70k records, lo

Re: cfqueryparam and null values

2005-04-27 Thread Aaron Rouse
heh ... it was probably CFSCRIPT, was curious how in the world JS could be used for this, now THAT would be over-complicated I am sure. On 4/27/05, Bryan Stevenson <[EMAIL PROTECTED]> wrote: > > All the posts not from Barney/Dave/myselfnot sure who specifically...I > just saw the "solution"

Re: cfqueryparam and null values

2005-04-27 Thread Aaron Rouse
Who suggested a method using JS? On 4/27/05, Bryan Stevenson <[EMAIL PROTECTED]> wrote: > > arrrgg...listen to Barney (and me and Dave W)...just do it in the null > attributeno silly JS neededyou're making it WAY too complicated > and > it will be a monster to maintain. > > sorry f

Re: ListGetAt in a SQL Select Statement... is this possible?

2005-04-27 Thread Aaron Rouse
I was once told that dealing with a list of data in MSSQL was easier than in Oracle. Perhaps someone well versed in MSSQL could chime in with a solution. It probably is not as hard as you think it will be to get done. On 4/27/05, Che Vilnonis <[EMAIL PROTECTED]> wrote: > > Aaron/Greg... I have

Re: ListGetAt in a SQL Select Statement... is this possible?

2005-04-27 Thread Aaron Rouse
f course you need to plug that into a function you call from within the database. On 4/27/05, Che Vilnonis <[EMAIL PROTECTED]> wrote: > > ugh, I knew this would be hard to do withbasic SQL... > > -Original Message- > From: Aaron Rouse [mailto:[EMAIL PROTECTED] >

Re: ListGetAt in a SQL Select Statement... is this possible?

2005-04-27 Thread Aaron Rouse
I do it in Oracle through a couple of different ways but almost always narrows down to a UDF in Oracle. Comes down to use of the SUBSTR and INSTR functions to find positionings to pull out the data. On 4/27/05, Che Vilnonis <[EMAIL PROTECTED]> wrote: > > Is something like this possible in SQL?

Re: cfqueryparam and null values

2005-04-26 Thread Aaron Rouse
This is the method I use and I find I only need to use it when dealing with dates. Probably because I tend to default numerics to zero. On 4/26/05, Pete Ruckelshaus <[EMAIL PROTECTED]> wrote: > > Here's what I'm doing: > > QUERY > > > if (isNumeric(getDataCards.dcardid)) { > dcardid_null="no

Re: SPAM-LOW: Re: SPAM-LOW: Re: wtf are those advertizing links in the text?

2005-04-21 Thread Aaron Rouse
How much have you donated to be on this list over the entire time you have been on it? I randomly get on this list to help people with quick questions more than anything else. I rarely post questions to it. Clearly it is not 100% centralized or I would not maintain a presense in multiple othe

Re: SPAM-LOW: Re: wtf are those advertizing links in the text?

2005-04-21 Thread Aaron Rouse
Did you not see the word "enough" Perhaps you are reading a little too far into the words I pick. Or perhaps you can not understand that I feel I would need to gain a certain amount out of something that normally can be found free to then justify paying for it. Anything offered on this list ca

Re: SPAM-LOW: Re: wtf are those advertizing links in the text?

2005-04-21 Thread Aaron Rouse
Is your unwillingness to pay a subscription based on the fact that > you feel like you don't benefit from the list? Or that you give more > to the list than you take? I do not feel I benifit enough from this list to warrant paying to be on it. Matter of fact I am not 100% sure I have benifited

Re: wtf are those advertizing links in the text?

2005-04-21 Thread Aaron Rouse
There are plenty of "free" sources of information out there that this very list offers. There is no way I'd pay to subscribe to a mailing list. Now if I were to find that I was greatly benifiting from it, I would make a donation to whoever maintained it. I have done donations in the past to thi

Re: Best Practices - Large Data Load

2005-04-13 Thread Aaron Rouse
Sometimes, in our situations at least, db to db connections are not allowed. For instance one of ours that does this type of "copying" of data the other side of the fense will only grant us ODBC access. On 4/13/05, Adrocknaphobia <[EMAIL PROTECTED]> wrote: > > Yes, remove CF from the equatio

Re: Best Practices - Large Data Load

2005-04-13 Thread Aaron Rouse
We have some interfaces here that take the same amount of records then just flat out loop over it and insert them. Takes for ever to run. I have been able to replace one so far with a dblink in Oracle so now I just run a stored proc and it inserts the data when selected. On 4/13/05, C. Hatton H

Re: Create Excel file??

2005-04-12 Thread Aaron Rouse
I found this rather helpful in showing how to use it. Although somethings I never got to work as I expected them to. http://www.d-ross.org/index.cfm?objectid=9C65ECEC-508B-E116-6F8A9F878188D7CA On Apr 12, 2005 2:00 PM, Neelima Kaja <[EMAIL PROTECTED]> wrote: > > Hi, > Could you explain a li

Re: What's your setup for multiple developers

2005-04-12 Thread Aaron Rouse
gs all the place. > > D > > On Apr 12, 2005 9:17 AM, Aaron Rouse <[EMAIL PROTECTED]> wrote: > > > > We have a seperate license for a Dev server that all developers use and > > the > > clients have access to as well. I often do development on my own mac

Re: What's your setup for multiple developers

2005-04-12 Thread Aaron Rouse
We have a seperate license for a Dev server that all developers use and the clients have access to as well. I often do development on my own machine though and push it up manually. I do this just because of random glitches on the network that sometimes cause files to disappear when working on th

Re: Event Gateway's and runaway threads...

2005-04-11 Thread Aaron Rouse
What happens if it runs much longer than you want. Only thing I could think of as a simple example would be something that created an endless loop. Although perhaps unexexpected lag from connecting the the database could cause something to run for "too long" On Apr 11, 2005 2:05 PM, Sean Corfie

Re: Create 1 CFSELECT from two sources

2005-04-11 Thread Aaron Rouse
In Oracle you could setup a dblink. On Apr 11, 2005 11:18 AM, Damien McKenna <[EMAIL PROTECTED]> wrote: > > How would it be done if Access wasn't used? > > -- > Damien McKenna - Web Developer - [EMAIL PROTECTED] > The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 > #include >

Re: CFForm - include actionscript library

2005-04-06 Thread Aaron Rouse
Add it to a variable and put that variable in the onsubmit? Could include it in a file that essentially puts it in a variable as well. On Apr 6, 2005 10:54 AM, Jason Rogoz <[EMAIL PROTECTED]> wrote: > > I've got numerous line of actionscript code on the onsubmit of a cfform > tag. Is it possib

Re: Anything wrong with this statement?

2005-04-04 Thread Aaron Rouse
I'd think "importance" would be subjective as to who was looking at it. I personally try to always do it like this: But I got into the habbit of putting in Variables due to working with inherited code that lacks much of any scoping. So I'd maybe come across a page with references to Photos but

Re: Conditional Select Boxes

2005-04-04 Thread Aaron Rouse
The example of flash forms or the example of XSL? I have messed with the flash one, saw no flakeyness but honestly do not think I tried it in something other than IE. On Apr 4, 2005 11:34 AM, Bob Clingan <[EMAIL PROTECTED]> wrote: > Yeah, there is one example, but > > 1. Its IE only > 2. Its a l

Re: Conditional Select Boxes

2005-04-04 Thread Aaron Rouse
I saw on a blog not too long ago that someone was working on a XSL file to integrate qForms which maybe could lead to an interesting approach to doing n-selects. If you are using the flash forms feature there are a few examples floating around on the net on how to do "two selects related" boxes, I

Re: CFLDAP under load?

2005-03-31 Thread Aaron Rouse
y at the moment to me :( > > D > > > On Thu, 31 Mar 2005 12:40:35 -0600, Aaron Rouse <[EMAIL PROTECTED]> wrote: > > We have always had an issue with authenticating against LDAP when > > under a load. Ours however is not just about it taking longer, it > > a

Re: CFLDAP under load?

2005-03-31 Thread Aaron Rouse
We have always had an issue with authenticating against LDAP when under a load. Ours however is not just about it taking longer, it actually fails and required us to put in some custom error trapping. I'd be really curious if there is a way outside of CFLDAP to authenticate against an LDAP server

Re: ooa, ood, oop and design patterns

2005-03-31 Thread Aaron Rouse
I do not reall see why the CFCDev list could not have both on it, it is "CFCDev is a listserv for the discussion of all things CFC" after all which to me means it is not even solely about OO and so on. Just a matter of people being on it and posting about the none bleeding edge. I am on it but te

Re: this scope

2005-03-30 Thread Aaron Rouse
Actually those are not the only examples that refer to it from MACR. I was reading through some of the docs a couple weeks back in regards to CFCs and it was used quite a bit in there. On Wed, 30 Mar 2005 13:28:43 -0700, Paul <[EMAIL PROTECTED]> wrote: > I've been avoiding the "this" scope in my

Re: MAX 2005 [USA] City?

2005-03-29 Thread Aaron Rouse
ld. > > i could walk the course. but i dont. its not about exercise. its > about the game. > > exercise is for the gym. conferences are for the experience. not the walk. > > :) > > > On Tue, 29 Mar 2005 11:00:53 -0600, Aaron Rouse <[EMAIL PROTECTED]> wrote:

Re: MAX 2005 [USA] City?

2005-03-29 Thread Aaron Rouse
If a 1/2 mile walk is hard for you, I'd suggest some daily exercise :) On Tue, 29 Mar 2005 11:55:38 -0500, Tony Weeg <[EMAIL PROTECTED]> wrote: > sure did! > > prolly more cause i was sick as a dog, but come on... a 1/2 mile walk > to get to the thing... yeah i know there was a shuttle but for pe

Re: MAX 2005 [USA] City?

2005-03-29 Thread Aaron Rouse
I had a company that was supposed to pay me back for it but never did. I actually ended up not going because could not float the extra money I would have needed to make the entire trip possible. On Tue, 29 Mar 2005 11:45:14 -0500, Tony Weeg <[EMAIL PROTECTED]> wrote: > my company has sent me to

Re: MAX 2005 [USA] City?

2005-03-29 Thread Aaron Rouse
:25 -0700, Connie DeCinko <[EMAIL PROTECTED]> wrote: > > Makes it very hard to budget and plan without plenty of advance notice. > > I think typically you get about six months notice for MAX. Is that not > enough? (genuine question) > -- Aaron

Re: how to check CF version

2005-03-29 Thread Aaron Rouse
That is for bluedragon though On Tue, 29 Mar 2005 11:25:47 -0400, Doug Strickland <[EMAIL PROTECTED]> wrote: > I haven't tried this out myself, but check this site out...it has some code > that you can copy and paste, and then run on the server to tell you the info > you want: > > http://www.a

Re: how to check CF version

2005-03-29 Thread Aaron Rouse
I just do and if it fails then it is too dang old ;) On Tue, 29 Mar 2005 11:17:38 -0400, daniel kessler <[EMAIL PROTECTED]> wrote: > I searched the archives but I can't figure out how to check the version of CF > that's on our server. I have to do some pdf work and wanted to find out my cf >

Re: Ordering WACK from Amazon

2005-03-25 Thread Aaron Rouse
Seriously, there are always exceptions...I'm sure we could > find somebody out there who gets headaches from reading > printed literature, but find LCD reading relieving...no where > we might find them, I don't know... :o) > > Rick > > -Original Message---

Re: Ordering WACK from Amazon

2005-03-25 Thread Aaron Rouse
n't this what the Desktop Search craze is all about? >We just need to integrate purchased digital books into that mix.. > > Rick > > -Original Message- > From: Aaron Rouse [mailto:[EMAIL PROTECTED] > Sent: Friday, March 25, 2005 11:48 AM > To: CF-Talk >

Re: Ordering WACK from Amazon

2005-03-25 Thread Aaron Rouse
Perhaps I am wrong on this, but I really think you people spend way too much time in the bathroom if you are worried about being able to run the code samples from the WACK in there on your "mini computer" On Fri, 25 Mar 2005 12:27:49 -0500, Dave Watts <[EMAIL PROTECTED]> wrote: > > And you don't

Re: Ordering WACK from Amazon

2005-03-25 Thread Aaron Rouse
The searching is the only thing I would like about an eBook. I am just one of those people that when reading something I prefer it not be on a monitor screen but on paper and printing out hundreds of pages on my own printer does not sound like "fun". On Fri, 25 Mar 2005 09:41:31 -0700, Connie De

Re: Ordering WACK from Amazon

2005-03-25 Thread Aaron Rouse
Yeah, I still have the v3 and v4 books ... anyone wanna buy them? :) On Fri, 25 Mar 2005 11:42:31 -0500, Ray Champagne <[EMAIL PROTECTED]> wrote: > How dare you resell Ben's books? Blasphemy! :) > > Ray > > At 11:33 AM 3/25/2005, you wrote: > >And Ben's books have great re-sale value too. >

Re: CF_TwoSelectsRelatedMulti in a CF7 Flash form?

2005-03-25 Thread Aaron Rouse
I believe this is what you are looking for: http://www.happyhacker.com/includes/Example_CF7_TwoSelects.txt I did not get around to messing with the ActionScript to get the required to actually work, I found out in CF7 that if you have an option with a blank value then that is good enough to not m

Re: Ordering WACK from Amazon

2005-03-25 Thread Aaron Rouse
Plus they make a good defense weapon if ever in a bind :) You know, cube farms can get violant at times. On Fri, 25 Mar 2005 10:23:19 -0500, Ray Champagne <[EMAIL PROTECTED]> wrote: > I dunno, I am not 100% on board on that e-book/pdf thing. Personally, I > like having Ben's lineup of books all

Re: Ordering WACK from Amazon

2005-03-25 Thread Aaron Rouse
I know of someone who did and still makes a pretty penny from it. Wrote some books on cisco, some of which are used in colleges. However he does make far more off the training he does, but the books were a great help in getting him in that position in life. On Fri, 25 Mar 2005 10:09:04 -0500, Be

<    3   4   5   6   7   8   9   10   11   >