More problems with hourly digests?

2006-08-22 Thread RADEMAKERS Tanguy
Hello, Here below the latest hourly digest received from CF-Talk in its entirety. As you can see, some information would seem to have been left out ;) This has been happening every once in a while over the last week or two, bust usually there's *some* information in the digest. -Original

FW: More problems with hourly digests?

2006-08-22 Thread RADEMAKERS Tanguy
oops, looks like the quoted text was stripped out. What i *meant* to say was: Hello, Here below the latest hourly digest received from CF-Talk in its entirety. As you can see, some information would seem to have been left out ;) This has been happening every once in a while over the last

OT: what if the next CF...

2006-08-04 Thread RADEMAKERS Tanguy
Hello, Apologies in advance for the long and OT post. Don't worry, this isn't yet another cf wish list (or is it?). This really is long and rambling, so you will need coffee, and you might not want to read this at your desk... maybe print it and take it home for the weekend? Unless you've been

Hourly Digests down again?

2006-08-01 Thread RADEMAKERS Tanguy
Hello, I haven't received an hourly digest for cf-talk since... last thursday morning. I have verified my subscription settings on houseoffusion.com and all seems well. Is the problem on my side? Or yours? Regs, /t ~|

RE: mimic a pivot table query

2006-07-19 Thread RADEMAKERS Tanguy
Hello Martin, select user_name, snip cfif fldCount LT listLen(fldList),/cfif!--- there must be a better way to do this --- There is - move the user_name column to the end of the select list - that way you always include a , character... Happy to help, /t

RE: CF Studio Edits Not Being Saved?

2006-07-12 Thread RADEMAKERS Tanguy
Last person to have this problem, it was due to a bug with firewall software (Zone Alarm?) blocking a change to the file update timestamp: the file was changed, but since the update time wasn't changed, the server didn't reload it. /t -Original Message- Subject: CF Studio Edits Not

RE: CF Studio Edits Not Being Saved?

2006-07-12 Thread RADEMAKERS Tanguy
, 12 Jul 2006 08:53:07 -0500 Thread: http://www.houseoffusion.com/cf_lists/messages.cfm/forumid:4thr eadid:46748#246260 RADEMAKERS Tanguy said the following on 7/12/2006 4:55 AM: Last person to have this problem, it was due to a bug with firewall software (Zone Alarm?) blocking a change to the file

HTML and digests

2006-07-05 Thread RADEMAKERS Tanguy
Hello, For the past couple of days, the digests have been coming through kinda weird: - angle brackets used to indicate a previous poster's text are being translated into html entities: gt; have searched their Site and cannot find any step by step - links are showing up as a full html a tag:

RE: mail server connection verification

2006-06-30 Thread RADEMAKERS Tanguy
In the same office behind the same router on my laptop (Win XP Pro with CFMX 7.01 Developer Edition), the connection verifies as expected. Hello Bryan, Try to connect using telnet from both your laptop and the server - just type telnet [mail server ip] [mail server port - usually 25] in the

RE: AJAX

2006-06-21 Thread RADEMAKERS Tanguy
A really good resource for Prototype is the book Head Rush Ajax. It is, IMO, one of the best books on Ajax at the moment because it really does provide the content in a distinct way that truly helps you capture the ideas in the book. At first I was skeptical but now I'm sold. Rey... Sadly, i

List address has changed?

2006-06-19 Thread RADEMAKERS Tanguy
Hello, I am receiving the digests from the address test@houseoffusion.com, which means they are all dropping into my inbox... Is this the new address for the list or will this be changed (fixed?) soon? Regards, /t ~| Message:

RE: BEA licenses BlueDragon for WebLogic

2006-04-19 Thread RADEMAKERS Tanguy
-Original Message- We already run MX on Weblogic. This is a supported configuration and works great. You must be luckier than us then - we run MX 6.1 in weblogic and so far, great is most certainly not the word i'd use to describe it. /t

RE: BEA licenses BlueDragon for WebLogicr

2006-04-19 Thread RADEMAKERS Tanguy
-Original Message- *Really* ? What's up ? Number one peeve: Can't pass java objects you created yourself to an EJB in a different application on the same server: MX uses the classloader of the various objects/parameters to figure out which method to call, so it claims that no such method

RE: BEA licenses BlueDragon for WebLogicr

2006-04-19 Thread RADEMAKERS Tanguy
, RADEMAKERS Tanguy wrote: Number one peeve: Can't pass java objects you created yourself to an EJB in a different application on the same server: MX uses the classloader You couldn't do that even if it was two JSP apps, if they were in different J2EE application contexts, could you ? Actually, you

RE: Asp calling ColdFusion

2006-04-06 Thread RADEMAKERS Tanguy
CF can use the getPageContext.include() to cause an asp page to be processed inside the CF context. I'm pretty certain that this is incorrect. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ As far as i know, that will only work to execute a jsp or servlet - ie some (other) java

Hourly digests down again?

2006-03-06 Thread RADEMAKERS Tanguy
Hello, Haven't received an hourly digest since 7:12 am my time (seven hours ago...). Are they down or has it suddenly gone deathly quiet in here? Regs, /t ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234234

RE: Stored Procedures and when to use them

2006-03-02 Thread RADEMAKERS Tanguy
One of the nice things about stored procedures wv. inline sql is that your database can tell you which procs are invalidated by a change to your schema, which can be a big time saver in development. /t ~| Message:

RE: Digital Signing a SOAP Request

2006-02-28 Thread RADEMAKERS Tanguy
-Original Message- Subject: Digital Signing a SOAP Request From: John Wilker [EMAIL PROTECTED] Date: Mon, 27 Feb 2006 15:48:07 -0700 snip I've printed out just about every PDF Paypal has on the topic. All I could figure out was that unless you have your own server you're SOL If you have

RE: Annoyances with cfencode

2006-02-21 Thread RADEMAKERS Tanguy
Hmmm. So I gather that this behavior is what you see too? You work around it by not asking it to do more than one file at once? A bit odd that after all these years, basic functionality of this tool is so broken. Thanks, Dave Merrill Actually i've never used it, it was just an off the cuff

RE: Annoyances with cfencode

2006-02-20 Thread RADEMAKERS Tanguy
No matter what I do, cfencode gives a failure alert when encrypting more than one file at once. use a shell command with some kind of looping structure: dos: for /R %i in (*.cfm) do cfencode %i [opts] *nix: find . -name *.cfm -exec cfencode [opts] {} \; /t

RE: OT: Compiling java source code

2006-02-17 Thread RADEMAKERS Tanguy
If you're going to compile java code and you don't want to go all the way and install some kind of IDE, then you should really really really look into using Ant. In fact, some linux distros already come with a version of ant installed (but since your distro shipped without a JDK i guess that's

RE: CFMX errs on Java class .isAuthenticated() method

2006-01-19 Thread RADEMAKERS Tanguy
-Original Message- Folks--- How do I get around this one? In my CFMX6.1 template I instantiate userObj from a Java User class used for authentication. I want to determine if authentication was successful so I use the Java class's .isAuthenticated() method which fails because MX

RE: SVN/CFEclipse question

2006-01-11 Thread RADEMAKERS Tanguy
I'm using that plugin with Eclipse 3.1.1 and CFEclipse 1.2 - works great: much better than the one from Rational software. /t Subject: SVN/CFEclipse question From: Angus Johnson [EMAIL PROTECTED] Date: Wed, 11 Jan 2006 10:11:11 +1000 Thread:

RE: CF-Talk: Digest every hour

2005-12-21 Thread RADEMAKERS Tanguy
-Original Message- The point is this their PHP site, using free PHP took two of them two years to do. Multiply that out by an hourly rate, and compare that to my building almost the same site (from a programming standpoint) in 74 hours. Even if you add the cost of the server,

digests down again?

2005-12-12 Thread RADEMAKERS Tanguy
Hello, Are digests down again? Haven't received anything since 7 am my time (i'm posting this at a quarter to six pm...) /t ~| Find out how CFTicket can increase your company's customer support efficiency by 100%

RE: Calling Oracle Stored Procedures from CF

2005-12-08 Thread RADEMAKERS Tanguy
I am having troubles getting even basic Oracle sp's to call from my coldfusion pages. Heres the procedure: CREATE OR REPLACE PROCEDURE selRandomQuestionIDs() AS IS BEGIN SELECT quizQuestionID, RANDOM_ORDER FROM random_number WHERE rownum = 20 END; Heres the call: cfquery

Calling Oracle Stored Procedures from CF

2005-12-08 Thread RADEMAKERS Tanguy
i tried answering this a few hours ago, but HOF seems to have eaten my mail, so here goes again: Michael, 1) Your proc is incorrect (that's what the error message is complaining about). You need to fix a few things: - don't use both AS and IS in the same declaration (just AS) -

RE: MX7 CFHTTP : connection failure with Proxy

2005-12-05 Thread RADEMAKERS Tanguy
Hello Yves, 1) Just thinking out loud, but are you sure that you can connect to the proxy url (http://myproxy/cgi-bin/mro/perlFile.pl, in your example) from the ColdFusion MX7 server? Have you tried using cfexec to ping the proxy from within a cf page? Have you tried using cfexec and wget to see

RE: SQL

2005-11-29 Thread RADEMAKERS Tanguy
1) given that you have to list all the columns in your create temporary table as select... statement, you might as well just do insert into customers (select myNewID, pkCUST, CUST_Fname, CUST_LName, CUST_ZIPCode from customers where pkCUST = 37); 2) myNewID is most probably a sequence, so it

hourly digests down?

2005-11-21 Thread RADEMAKERS Tanguy
Hello, I haven't received an hourly digest since 4.01 am my time (almost twelve hours ago). Are they down or is the problem on my side? /t ~| Logware (www.logware.us): a new and convenient web-based time tracking application.

RE: cfimport and application.cfm

2005-11-17 Thread RADEMAKERS Tanguy
Anyone have a way that I can enable the custom prefix of a tag library within every page of my site, including includes? find . -name *.cfm | xargs grep -L cfimport prefix=\ui\ taglib=\/system/ui\ | xargs sed -i.bak -e 1icfimport prefix=\ui\ taglib=\/system/ui\ Execute from the root of your cf

RE: Form: user not going back

2005-11-15 Thread RADEMAKERS Tanguy
What is a standard way of preventing the user from accessing a form just submitted? I inserted a page with a redirect code between my action page and my thank you page, but when I hit the Back button, both the refresh and the action pages are bypassed and the form (with completed fields) is

silent install problems: CFMX7 enterprise on Solaris

2005-10-07 Thread RADEMAKERS Tanguy
Hello, I am trying to perform a silent installation on Solaris, and i keep winding up with the developer version, not the enterprise version. I have checked that i am using a valid enterprise serial number (if i enter this in the admin after installation and deployment it works just fine, if i

hourly digests down?

2005-10-05 Thread RADEMAKERS Tanguy
Hello, I haven't received any hourly digests since tem pm my time last night (CET). Is there a problem or is something wrong on my side? /t ~| Find out how CFTicket can increase your company's customer support efficiency by

RE: Content-Type

2005-10-04 Thread RADEMAKERS Tanguy
IIRC, you need to look into the content-disposition header, iso the content-type one cfheader name=Content-Disposition value=attachment;filename=whatever_you_want.pdf /t -Original Message- Subject: Content-Type From: Matt Robertson [EMAIL PROTECTED] Date: Tue, 4 Oct 2005 12:19:48

Questions regarding using CFMX7 with EJBs

2005-09-27 Thread RADEMAKERS Tanguy
Hello List, I'm running into a problem using CFMX7 enterprise on weblogic to call an EJB deployed in the same instance of weblogic (so it's running in the same JVM), but in a different application (so it's loaded by a different classloader). The basic problem is that i can't pass objects that i

RE: OT: hit tracking service

2005-09-26 Thread RADEMAKERS Tanguy
DeepMetrix has all the eye candy anyone could need... it's exactly what you want. Kevin Thank you Kevin, that does look rather promising. /t ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket

OT: hit tracking service

2005-09-23 Thread RADEMAKERS Tanguy
Hello, My company is looking for some form of hit tracking service - something that would allow us to tag pages with an identifier and then consult reports of visits, visitors, etc by tag. Basically something like those annoying hit counters, but more professionally done and with the ability to

Element FILTERS is undefined in STCURRENTSEARCH when trying to view log files in CFMX7 admin

2005-09-21 Thread RADEMAKERS Tanguy
Hello, I'm trying to view the mailsent.log file in my cfadmin (Debugging Logging - Log Files - mailsent.log). That works just fine, but there are two checkboxes above the log output: View Raw Data and Compact View. Checking either of these gives me an error message Element FILTERS is undefined

RE: form validation utilizing database field types/sizes/etc

2005-09-14 Thread RADEMAKERS Tanguy
I was wondering if there is a way to pull column information from oracle to help with form validation. It would be really nice if I could set up my database and then have coldfusion read the setup of my tables and perform its form validation based on that. Oracle stores this kind of info in

RE: form validation utilizing database field types/sizes/etc

2005-09-14 Thread RADEMAKERS Tanguy
apologies for the redundancy - hourly digests... so, euh, yeah: ME TOO!! /t -Original Message- Subject: form validation utilizing database field types/sizes/etc From: RADEMAKERS Tanguy [EMAIL PROTECTED] Date: Wed, 14 Sep 2005 19:16:44 +0200 Thread: http://www.houseoffusion.com/cf_lists

RE: CF-Talk: Digest almost every hour

2005-09-13 Thread RADEMAKERS Tanguy
Hello, Are hourly digests down? Don't seem to be getting any from the list this afernoon... /t ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent

RE: CFMX6.1 on WebLogic 7, weird web services call error

2005-09-09 Thread RADEMAKERS Tanguy
: Thomas Chiverton [EMAIL PROTECTED] Date: Fri, 9 Sep 2005 10:03:45 +0100 Thread: http://www.houseoffusion.com/cf_lists/index.cfm/method=messages threadid=42115forumid=4#217730 On Thursday 08 September 2005 17:13, RADEMAKERS Tanguy wrote: Tom, I think you might be running into a limitation

RE: CFMX6.1 on WebLogic 7, weird web services call error

2005-09-08 Thread RADEMAKERS Tanguy
Hello Tom, Is this on a development (unlicensed) copy of weblogic server? /t -Original Message- Subject: CFMX6.1 on WebLogic 7, weird web services call error (java.security.PrivilegedActionException) From: Thomas Chiverton [EMAIL PROTECTED] Date: Thu, 8 Sep 2005 15:23:01 +0100 Thread:

RE: CFMX6.1 on WebLogic 7, weird web services call error

2005-09-08 Thread RADEMAKERS Tanguy
+0100 Thread: http://www.houseoffusion.com/cf_lists/index.cfm/method=messages threadid=42115forumid=4#217631 On Thursday 08 September 2005 16:11, RADEMAKERS Tanguy wrote: Is this on a development (unlicensed) copy of weblogic server? Dev, yeah. Development != unlicensed though. I haven't

RE: Full server/database/schema/table name syntax for Oracle.

2005-09-01 Thread RADEMAKERS Tanguy
-Original Message- Subject: Full server/database/schema/table name syntax for Oracle. From: Ian Skinner [EMAIL PROTECTED] Date: Thu, 1 Sep 2005 09:51:56 -0700 Thread: http://www.houseoffusion.com/cf_lists/index.cfm/method=messages threadid=42032forumid=4#217099 I am in an position where

anyone here from nmha.org?

2005-09-01 Thread RADEMAKERS Tanguy
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, September 01, 2005 9:18 PM To: RADEMAKERS Tanguy Subject: Symantec Mail Security detected prohibited content in a message sent from your address (SYM:02178018114101170846) Subject of the message: RE

RE: [SOT] Finding which files in a site aren't used anymore

2005-08-31 Thread RADEMAKERS Tanguy
the first obvious gotcha i can see here is including files dynamically: cfloop index=afileName list=#aListOfFileNames# cfinclude template=#afileName#.cfm /cfloop other than that, i don't know of any tools, but i did once see a perl script that searched out unused images...

RE: Using JavaMail to send/fetch emails via SSL

2005-08-30 Thread RADEMAKERS Tanguy
Hello Hua, Have you tried using JavaMail to fetch email from a different (non gmail) ssl mail server? I.E. is the problem gmail specific? BTW: your debug output (DEBUG POP3: connecting to host pop.gmail.com, port 995, isSSL false) seems to indicate that you are *not* connecting over SSL... You

RE: SQL Count Question...

2005-08-26 Thread RADEMAKERS Tanguy
I don't know about sql server specifically, but you could try syntax like select count(distinct(mycolumn)) from mytable or else you should be able to do select count(*) from (select distinct(mycolumn) from mytable) /t -Original Message- Subject: SQL Count Question... From: [EMAIL

hourly digests down?

2005-08-25 Thread RADEMAKERS Tanguy
or has nobody said anything since 11 am this morning (my time)? it's... so... quiet... /t ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent

RE: Get fields in an Access table

2005-08-24 Thread RADEMAKERS Tanguy
you can get the column names by querying the table and then looking at yourqueryname.columnList, but i don't know how you can get datatypes... there was an article a way back in CFDJ (leveraging JDBC or just fetching coffee?) that talked about using the underlying JDBC api from cf, but they

RE: creating war ear files programatically

2005-08-23 Thread RADEMAKERS Tanguy
Hello, WAR/EAR files are just zip archives with special layout (like the have a META-INF directory with some xml files, etc). I'd suggest dissecting an existing one and then trial... and error... and trial... ;) best of luck! /t -Original Message- Subject: creating war ear files

RE: webservices and XML

2005-08-22 Thread RADEMAKERS Tanguy
If you are creating and consuming these web services from CF, then it probably magically turns the query xml back into a CF query. Have you tried accessing this web service with a non-CF technology? /t -Original Message- Subject: webservices and XML From: Bryan Stevenson [EMAIL

RE: WDDX Replacement Attempt - Take a Look!

2005-08-19 Thread RADEMAKERS Tanguy
I think I've hit upon an appropriate name... get ready... here it comes... YODEL It stand for Yet another Open Data Exchange Language. Also Yodeling began as a method for passing messaged from mountain peak to mountain peak using only simple modulations of voice... all told it seems

RE: Cfhttp vs web services

2005-08-10 Thread RADEMAKERS Tanguy
Russ, You have to compare apples with apples: not all web services work the same way. CFMX web services built using cfcomponents with access=remote are heavy duty web services that use SOAP to pass messages, publish a WSDL file to document their interface and check things like parameter

RE: CF-Talk: Digest every hour

2005-08-09 Thread RADEMAKERS Tanguy
Hello, I'll second Barney's post with a big +1. For simple data passing, you don't even need to use XML, let alone SOAP based web services - you can get simple text strings and inject them directly in your layout. Google XHConn for a nice little(43 lines) .js file that wraps the XMLHttpRequest

RE: retrieve ID from db insert

2005-07-13 Thread RADEMAKERS Tanguy
Two other good resources: http://www.jlcomp.demon.co.uk/ Jonathan Lewis' site -check out the oracle FAQs http://www.psoug.org/reference which has some great examples for more advanced db features and, of course, the oracle docco, esp. the Concepts guide, Application Developer's Guide -

RE: clearing connection pool/expiring connections

2005-07-13 Thread RADEMAKERS Tanguy
It must be possible because you can do it in the admin (Disable Connections checkbox in the datasource advanced settings page. All this stuff is accessible from the undocumented coldfusion.server.ServiceFactory object... which contains a DataSourceService object... which declares a

RE: retrieve ID from db insert

2005-07-12 Thread RADEMAKERS Tanguy
As i see it, the benefit of this approach is that it will be more portable across different databases (as long as they understand transactions). The down side is that if you want this to work you will have to use cftransaction isolation=serializable - repeatable_read won't cut it if another

RE: retrieve ID from db insert

2005-07-12 Thread RADEMAKERS Tanguy
-Original Message- Subject: retrieve ID from db insert From: Aaron Rouse [EMAIL PROTECTED] Date: Tue, 12 Jul 2005 14:40:27 -0500 [snip] I often wonder how many CFM developers that work with Oracle use and understand all the features that all that money was spent on. And if they do not

RE: Poor performing Oracle Query

2005-07-11 Thread RADEMAKERS Tanguy
Hello, I've never heard of oracle restarting a query because the underlying data had changed. Oracle uses a multi-version view of data to show you results consistent with what the database looked like at the start of the query (at the very least - it can also do consistent with the start of the

RE: CF-Talk: Digest every hour

2005-07-11 Thread RADEMAKERS Tanguy
Hello, 1) Do two queries in a CFTRANSACTION (not CFLOCK) - one to insert and one to get the value of the new ID. 2) Write a stored procedure that returns the value of the inserted id (see the SQL guide for the syntax of RETURNING INTO clause) start with this: CREATE OR REPLACE PROCEDURE

FW: CF-Talk: Digest every hour

2005-07-11 Thread RADEMAKERS Tanguy
first ooops: RETURNING ID INTO newid; should be RETURNING GI_ID INTO newid; (obviously) /t -Original Message- From: RADEMAKERS Tanguy Sent: Monday, July 11, 2005 5:19 PM To: 'cf-talk@houseoffusion.com' Subject: RE: CF-Talk: Digest every hour Hello, 1

RE: reverse compliment a sequence

2005-06-15 Thread RADEMAKERS Tanguy
(ACTG, A,T,Z,G,C,Z, Z,A,T,Z,G,C) should work cheers, barneyb On 6/14/05, RADEMAKERS Tanguy [EMAIL PROTECTED] wrote: Well, i was going to suggest using cfoutput#ReplaceList(ACTG,C,G,A,T,G,C,T,A)#/cfoutput but on my system that replaces ACTG with ACAC i'm confused? -- Barney Boisvert [EMAIL

reverse compliment a sequence

2005-06-14 Thread RADEMAKERS Tanguy
Well, i was going to suggest using cfoutput#ReplaceList(ACTG,C,G,A,T,G,C,T,A)#/cfoutput but on my system that replaces ACTG with ACAC i'm confused? -Original Message- Subject: reverse compliment a sequence From: Barney Boisvert [EMAIL PROTECTED] Date: Tue, 14 Jun 2005 11:53:40 -0700

RE: Get New Record ID in ORACLE

2005-06-09 Thread RADEMAKERS Tanguy
-Original Message- Subject: Get New Record ID in ORACLE From: Douglas Knudsen [EMAIL PROTECTED] Date: Wed, 8 Jun 2005 22:46:41 -0400 Thread: http://www.houseoffusion.com/cf_lists/index.cfm/method=messages threadid=40571forumid=4#209060 quote So here is a completely random question. How

RE: Get New Record ID in ORACLE

2005-06-09 Thread RADEMAKERS Tanguy
-Original Message- Subject: Get New Record ID in ORACLE From: James Holmes [EMAIL PROTECTED] Date: Thu, 9 Jun 2005 19:59:22 +0800 Thread: http://www.houseoffusion.com/cf_lists/index.cfm/method=messages threadid=40571forumid=4#209077 I should also have mentioned that there is an

RE: session variables or multiple pages

2005-06-08 Thread RADEMAKERS Tanguy
By default, CF uses cookies to hold the session key, so you are running into the same basic problem. Solution is to use cfapplication ... setclientcookies=No and then pass CFID and CFToken by url or hidden form field on every page. Depending on the size of your app, you might have your work cut

RE: Get New Record ID in ORACLE

2005-06-08 Thread RADEMAKERS Tanguy
Adam, 1) Even with the same username/password, oracle treats it as two sessions. If you have TOAD you can verify this with the session browser. 2) stored procs don't change the transaction handling of oracle (unless, or course, you manually commit within the body of the proc) - ie cf handles

RE: Get New Record ID in ORACLE

2005-06-08 Thread RADEMAKERS Tanguy
no need to do that in cf: either call a single proc by itself and cf will commit afterwards or call several procs in a cftransaction and cf will commit after the transaction: cf manages the unit of work for you. /t -Adam On 6/8/05, RADEMAKERS Tanguy [EMAIL PROTECTED] wrote: Adam, 1) Even

RE: Get New Record ID in ORACLE

2005-06-08 Thread RADEMAKERS Tanguy
Hello Doug, as ever... inline ;) -Original Message- Subject: Get New Record ID in ORACLE From: Douglas Knudsen [EMAIL PROTECTED] Date: Wed, 8 Jun 2005 15:15:06 -0400 Thread: http://www.houseoffusion.com/cf_lists/index.cfm/method=messages threadid=40571forumid=4#209017 1) huh? each

RE: Get New Record ID in ORACLE

2005-06-07 Thread RADEMAKERS Tanguy
Jochem, I tried to make an example using the INSERT .. RETURNING syntax directly in a cfquery to make the example clearer, but i couldn't get it to work with straight SQL (didn't try things like anon pl/sql block). Do you have such an example you could share with us? Aaron, What type of

RE: CF Google desktop search

2005-06-07 Thread RADEMAKERS Tanguy
there's an existing plugin (Larry's Any Text File Indexer) that allows you to easily configure the extensions of any text based files you want GDS to index... most handy. /t -Original Message- Subject: CF Google desktop search From: Rob [EMAIL PROTECTED] Date: Fri, 3 Jun 2005 10:28:29

RE: Get New Record ID in ORACLE

2005-06-07 Thread RADEMAKERS Tanguy
what problem? I use this select mysequence.nextval into newid from dual insert into foo (a,b,c,pk) values (A,B,C, newid) do whatever else you want with newidcarry on. Yes, but how do you retrieve the value of the just inserted id? I can't get the select ... into... syntax to work in a

RE: Get New Record ID in ORACLE

2005-06-07 Thread RADEMAKERS Tanguy
-Original Message- Subject: Get New Record ID in ORACLE From: Douglas Knudsen [EMAIL PROTECTED] Date: Tue, 7 Jun 2005 10:41:52 -0400 Thread: http://www.houseoffusion.com/cf_lists/index.cfm/method=messages threadid=40571forumid=4#208799 select mysequence.nextval into newid from dual You

RE: Get New Record ID in ORACLE

2005-06-07 Thread RADEMAKERS Tanguy
Aaron, Read the concepts guide in the oracle docco, then check out the two books by Tom Kyte - expert one on one oracle (get it secondhand, it was written for 8i and the new edition will come out soon for 10g) and effective oracle by design. There are plenty of big companies looking for any

FW: Get New Record ID in ORACLE

2005-06-07 Thread RADEMAKERS Tanguy
aaargh - sorry, keep forgetting to turn off my digital signature. i think the server kicks the mail in that case? otherwise... sorry ;)) -Original Message- From: RADEMAKERS Tanguy Sent: Tuesday, June 07, 2005 6:33 PM To: 'cf-talk@houseoffusion.com' Subject: RE: Get New Record ID

RE: Get New Record ID in ORACLE

2005-06-07 Thread RADEMAKERS Tanguy
-Original Message- Subject: FW: Get New Record ID in ORACLE From: Adrocknaphobia [EMAIL PROTECTED] Date: Tue, 7 Jun 2005 13:57:35 -0400 Thread: http://www.houseoffusion.com/cf_lists/index.cfm/method=messages threadid=40594forumid=4#208851 Well there are more (minor) speed benefits. Where

RE: Get New Record ID in ORACLE

2005-06-06 Thread RADEMAKERS Tanguy
You don't need to use triggers at all if you use stored procedures: --setup.sql--- CREATE TABLE t ( IDINTEGER NOT NULL, NAME VARCHAR2(50) ); CREATE SEQUENCE s; CREATE OR REPLACE PROCEDURE t_insert (newname IN VARCHAR2, newid OUT

RE: [OT] Free ftp/sftp server

2005-05-19 Thread RADEMAKERS Tanguy
Dave, Check out the FileZilla project on sourceforge. Their main product is an ftp/sftp client, but they also have a server product. I haven't used it, but i've been *real* impressed with the client in terms of how often they release, fix bugs, patch security problems, etc - so i'd say the server

interesting problem with function isNumeric and NaN

2005-05-17 Thread RADEMAKERS Tanguy
Hello, I've come across an interesting problem during some form validation involving the function isNumeric() and the value NaN (Not a Number - it's what js gives you when you try to use strings in math). I've done a very quick search on Google and in the MM knowledgebase but didn't find

RE: Little OT but know one else to ask...

2005-05-03 Thread RADEMAKERS Tanguy
the CDONTS send mail program included with windows 2000 server. I tried copying it to windows 2003 but cant get it to run. It tells me access is denied. Thanks, David -Original Message- From: RADEMAKERS Tanguy [mailto:[EMAIL PROTECTED] Sent: Monday, May 02, 2005 4:29 PM To: CF-Talk

RE: CF Error weirdness

2005-05-03 Thread RADEMAKERS Tanguy
Mike, Do they perchance have a site wide eror handler defined in the Settings section? /t -Original Message- From: Michael Bramwell [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 03, 2005 11:25 AM To: CF-Talk Subject: CF Error weirdness This is a strange and frustrating problem, I have

RE: detecting back button for page refresh

2005-05-03 Thread RADEMAKERS Tanguy
There is no way to do this from the server side, as no page request is made (it is loaded from cache), so you will have to use javascript - here's an example from the web: -start--- HTML BODY ONLOAD=handleBackButton() FORM NAME=backtrack INPUT TYPE=HIDDEN NAME=isBack VALUE=No /FORM SCRIPT

RE: Little OT but know one else to ask...

2005-05-02 Thread RADEMAKERS Tanguy
tried answering this from the HOF website, but no joy... check out a product called Badboy (badboy.com.au) - it allows you to record website visits and then script them for testing. It can also export these scripts to Apache JMeter (jakarta.apache.org) which supports extra scripting and

RE: Microsoft sponsoring CFUNITED-05

2005-04-29 Thread RADEMAKERS Tanguy
half-ish -Original Message- From: Rob [mailto:[EMAIL PROTECTED] Sent: Friday, April 29, 2005 5:04 PM To: CF-Talk Subject: Re: Microsoft sponsoring CFUNITED-05 That was the new American Math btw: 61 / x = 37 x = like half :-/ On 4/29/05, Rob [EMAIL PROTECTED] wrote: They *used* to

RE: CFMX interrupting javascript - MORE

2005-04-28 Thread RADEMAKERS Tanguy
you have two calls to function urlencodedformat: #urlencodedformat(main_jpeg)# #urlencodedformat(tempPopTitle)# could that have something to do with it? /t -Original Message- From: Jacob [mailto:[EMAIL PROTECTED] Sent: Thursday, April 28, 2005 5:46 PM To: CF-Talk Subject: RE: CFMX

RE: CFMX interrupting javascript - MORE

2005-04-28 Thread RADEMAKERS Tanguy
over 1 second. -Original Message- From: RADEMAKERS Tanguy [mailto:[EMAIL PROTECTED] Sent: Thursday, April 28, 2005 9:06 AM To: CF-Talk Subject: RE: CFMX interrupting javascript - MORE you have two calls to function urlencodedformat: #urlencodedformat(main_jpeg)# #urlencodedformat

RE: CFMX interrupting javascript - MORE

2005-04-28 Thread RADEMAKERS Tanguy
javascript - MORE I removed the urlencodedformat and I was still over 1 second. -Original Message- From: RADEMAKERS Tanguy [mailto:[EMAIL PROTECTED] Sent: Thursday, April 28, 2005 9:06 AM To: CF-Talk Subject: RE: CFMX interrupting javascript - MORE you have two calls to function

RE: CFMX interrupting javascript - MORE

2005-04-28 Thread RADEMAKERS Tanguy
. -Original Message- From: RADEMAKERS Tanguy [mailto:[EMAIL PROTECTED] Sent: Thursday, April 28, 2005 9:06 AM To: CF-Talk Subject: RE: CFMX interrupting javascript - MORE you have two calls to function urlencodedformat: #urlencodedformat(main_jpeg)# #urlencodedformat(tempPopTitle)# could that have

RE: CFMX interrupting javascript - MORE

2005-04-28 Thread RADEMAKERS Tanguy
oh, smells like a learning experience ;) anybody else out there got a windows 2003 machine to try this on? -Original Message- From: Jacob [mailto:[EMAIL PROTECTED] Sent: Thursday, April 28, 2005 7:11 PM To: CF-Talk Subject: RE: CFMX interrupting javascript - MORE On my

RE: CFMX interrupting javascript - MORE

2005-04-28 Thread RADEMAKERS Tanguy
and it runs fine. 1 development server (where I run this script) it blows... Go figure. -Original Message- From: RADEMAKERS Tanguy [mailto:[EMAIL PROTECTED] Sent: Thursday, April 28, 2005 10:15 AM To: CF-Talk Subject: RE: CFMX interrupting javascript - MORE oh, smells like a learning

RE: Get file size on UNIX?

2005-04-28 Thread RADEMAKERS Tanguy
something like this? ls -alh ./ | grep -v .* \. | awk {'print $5| $9'} or wc -c /t ~| Find out how CFTicket can increase your company's customer support efficiency by 100%

RE: Get file size on UNIX?

2005-04-28 Thread RADEMAKERS Tanguy
of course i meant wc -c [your_filename_here] i'll just get my coat... /t -Original Message- From: RADEMAKERS Tanguy Sent: Thursday, April 28, 2005 7:59 PM To: 'cf-talk@houseoffusion.com' Subject: RE: Get file size on UNIX? something like this? ls -alh ./ | grep -v .* \. | awk

RE: Using Java Classes rather than CFC's?

2005-04-26 Thread RADEMAKERS Tanguy
, RADEMAKERS Tanguy [EMAIL PROTECTED] wrote: Can you tell us if you have any extra jars in your server classpath? I'm especially interested in third party stuff rather than in house utilities or suchlike. I don't know off the top of my head what's installed on our production app servers... I

RE: Script timing?

2005-04-25 Thread RADEMAKERS Tanguy
Hello Damien, I use the following custom tag to time code blocks: -start- !--- timer custom tags to calculate the elapsed time --- cfswitch expression=#thistag.executionmode# cfcase value=start cfparam name=request.timingArray

RE: Auto-login for trusted users

2005-04-25 Thread RADEMAKERS Tanguy
If it's an intranet and everybody is on windows and using IE, then authenticate against NT login. If it's an intranet and you have the time/money/infrastructure to handle certificate management, then certs are a possibility. Warn the helpdesk. Otherwise cookies are your best bet, but: - make them

RE: Using Java Classes rather than CFC's?

2005-04-25 Thread RADEMAKERS Tanguy
Hello Sean, This thread has raised a couple of questions in my mind which i'd appreciate your thoughts on. Can you tell us if you have any extra jars in your server classpath? I'm especially interested in third party stuff rather than in house utilities or suchlike. Last year i worked on a

RE: cfrethrow question

2005-04-20 Thread RADEMAKERS Tanguy
can you post your cftry/cfcatch block so we can have a look? -Original Message- From: Ken Dunnington [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 20, 2005 5:24 PM To: CF-Talk Subject: cfrethrow question I'm trying to update some error reporting on a site I did awhile ago. It's a

  1   2   >