Aligning two tables

2008-11-27 Thread Jason Congerton
Hi I am importing a spreadsheet into my database the spreadsheet contains client information and contact information. I need to enter these into two seperate tables one for client and one for contacts. Simplified excel layout is clientid(newid), clientName, oldid, contactname The oldid

OT - Shrinking a .pst file (without losing any emails)

2008-11-27 Thread adrian lynch
Sorry for the OT, just need to see if anyone has had any experience of a .pst file in Outlook 2000 going over 2GB and ways to shrink it. I'm told the deleted items folder contains a load of things that could be deleted so I'm looking for a way to navigate the .pst file to pick and choose which

Re: cfajax broken in CF 8.0.1?

2008-11-27 Thread Tom Chiverton
On Wednesday 26 Nov 2008, Huff, Jerome P. wrote: This is a mapping problem with CF not knowing where to find the CFIDE directory. Wouldn't there be a 404 in the web server logs for that ? -- Tom Chiverton Helping to enormously pursue compelling web-enabled holistic principle-centered

Re: Aligning two tables

2008-11-27 Thread Jason Congerton
Hi Found a solution to this problem now, stripped out the duplicate values i.e multiple contacts, added the non duplicate items to the clients table, created a temp table will all the contacts in and run the following query to get the data into the contacts table cfquery name=insert

Re: lists vs structs

2008-11-27 Thread Dominic Watson
looks to me like a long way around a simple cfset list1 = list2... :) You're not wrong but I think I see there could be good reason for listing what needs deleting and what adding. Personally, I would use Arrays - can been done really simply using underlying java methods of arrays: arr1 =

Re: Use the compiled java class in CFM page

2008-11-27 Thread Jason Fisher
The Java file has to be in a directory which included in the Class Path settings (see CF Admin). ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial

(ot) Canon Developer?

2008-11-27 Thread Rob Parkhill
Good Morning, Does anyone know a Canon Developer with access to their SDKs? According to Canons Developers website, the SDKs are written in C++ 6. and I just want to confirm, as then I won't be able to access them from CF right? Thanks, Rob

Re: (ot) Canon Developer?

2008-11-27 Thread JediHomer
You could possibly wrap all the functionality into a C++6 CFX DLL then access it as a CFX Custom tag? 2008/11/27 Rob Parkhill [EMAIL PROTECTED]: Good Morning, Does anyone know a Canon Developer with access to their SDKs? According to Canons Developers website, the SDKs are written in C++ 6.

Re: (ot) Canon Developer?

2008-11-27 Thread Dave Watts
Does anyone know a Canon Developer with access to their SDKs? According to Canons Developers website, the SDKs are written in C++ 6. and I just want to confirm, as then I won't be able to access them from CF right? Not directly, but you can write C++ custom tags to invoke the API calls.

Re: (ot) Canon Developer?

2008-11-27 Thread Rob Parkhill
could I write a .NET class that referenced the C++ and then access the .NET directly in CF? All I want to do is access their methods for sending faxes to the damn machine, so that i can do it directly. $500 developers fee IF they think my cause is worthy enough just to see the code... kinda

Re: OT - Shrinking a .pst file (without losing any emails)

2008-11-27 Thread Rob Parkhill
Adrian, can you open it with Outlook, and then run the Auto-Archive function. That should move older sent items etc. into a different pst folder for archived items. HTH Rob On Thu, Nov 27, 2008 at 6:39 AM, adrian lynch [EMAIL PROTECTED]wrote: Sorry for the OT, just need to see if anyone has

Re: Need help with CF / Java problem...

2008-11-27 Thread C S
John Skrotzki wrote: I want to use a java class for extracting email sections from .eml file Just curious, what benefits does that jar offer you over plain javamail? http://java.sun.com/products/javamail/ get yourself the latest version of eclipse, make sure you have the same JRE installed on

Re: OT - Shrinking a .pst file (without losing any emails)

2008-11-27 Thread Mike Kear
Also there's a Shrink function that does what you need. After you've run the auto-archive function (moves anything older than x weeks - you specify how old to move it) you run the shrink and it will close everything up and you'll get what you need. It's a while since i saw the Outlook2000 app,

Re: Need help with CF / Java problem...

2008-11-27 Thread denstar
On Wed, Nov 26, 2008 at 9:11 PM, Paul Hastings wrote: John Skrotzki wrote: jre 1.6 instead of the jre 1.4 that CF MX 7 runs on. I don't know how to recompile it and wondering if anybody would be able to do it... get yourself the latest version of eclipse, make sure you have the same JRE

Re: Need help with CF / Java problem...

2008-11-27 Thread C S
You can also use the JDT compiler via JavaLoader, and compile and then load the classes on the fly, within CF. I like that a lot, personally. A fast way to do Java + CF. I've got some code that does it, been meaning to wrap it up into a little project or something. Sounds interesting. Do have