Re: com.allaire.cfx.Query problem

2005-06-23 Thread Marc Campeau
Take a look at Nate Weiss's(or is it someone else?) CSVtoQuery CFX, I used to use it (prior to CFMX) and it worked like a charm. If you can't find it, tell me and I'll email it to you. If you're dealing with XLS files maybe take a look at the ODBC/ADO driver for Excel and create a DSN to your

Re: com.allaire.cfx.Query problem

2005-06-23 Thread Marc Campeau
Thanks Marc , but like you said , none of that solved my problem eheheh I thought so... sorry. Off the top of my head, could it be an index problem where a excel file has N rows indexed from 0 to n-1 and queries have rows indexed from 1 to n, hence query.setData(0, cellname, cellvalue); wouldn't

Re: Need a copy of CF5

2005-06-15 Thread Marc Campeau
Does anyone know where we can purchase a copy and a ball park price. Try Macromedia, tell them you really badly need it and maybe they'll generate a serial number for you. They probably won't like it but it's better than having no sell I guess. Marc

Re: Installing CFMX7 Developer Edition - Multiserver - With Apache on Fedora Core 3

2005-04-12 Thread Marc Campeau
Could it be that SELinux is enabled? http://www.talkingtree.com/blog/index.cfm?mode=aliasalias=CFMXFC3SELinux Thanks for the heads up but that's not it since I disabled SELinux on install... I checked /etc/selinux/config and it states that SELINUX=disabled. Thanks again, Marc

Installing CFMX7 Developer Edition - Multiserver - With Apache on Fedora Core 3

2005-04-11 Thread Marc Campeau
couldn't? Is it a FC3 issue? Thanks a lot for your time, Marc Campeau ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client

Re: Stored Procedures in a CFC

2005-03-03 Thread Marc Campeau
I would do it differently (then returning a struct/array with both recordset). Please give comments/suggestions/whatevers as I'm just thinking out loud. In essence, your SP returns two recordsets which don't hold the same data, they could be related but they are not the same. Why not create two

Re: Stored Procedures in a CFC

2005-03-03 Thread Marc Campeau
The cfstoredproc tag will return both queries regardless, you could construct the function to return one of the callers choosing, but from a simplistic approach returning both in either an array or a structure seems more useful. The point I was making was that you either reference them as:

Re: Can DHTML call a web service directly

2005-02-25 Thread Marc Campeau
I was wondering if you could just call a web service with just two lines of code? Like so ... req = new XMLHttpRequest(); req.open(POST, http://dan:8500/myCFC/cgitest.cfc,true, , ); But I get the component browser page, which is strange. You need to call a method of that CFC (

Re: Can DHTML call a web service directly

2005-02-25 Thread Marc Campeau
req = new XMLHttpRequest(); req.open(POST, http://dan:8500/myCFC/cgitest.cfc,true, , ); But I get the component browser page, which is strange. You need to call a method of that CFC ( cgitest.cfc?method=runTest) Another thing you could do is to call cgitest.cfc?wsdl which returns the

Re: Unexpeceted behavior of the dateDiff function.

2005-01-21 Thread Marc Campeau
Have you applied all the updaters to ColdFusion? Thanks for the tip Michael, I shall see if it's the case! -- Marc ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application

Re: Unexpeceted behavior of the dateDiff function.

2005-01-21 Thread Marc Campeau
On Thu, 20 Jan 2005 22:24:28 -0800, Ian Skinner [EMAIL PROTECTED] wrote: There was a disussion on this topic in one of the Macromedia Forums. The consensus was that dateDiff looks at a 24 hour period, not the difference in the day part of the date object, this makes more sense if you consider

Unexpeceted behavior of the dateDiff function.

2005-01-20 Thread Marc Campeau
Hi to all! Sorry if this has already been answered but I couldn't find a related thread in the archives. I have an application which makes use of the datediff function to figure out length of times in days between to dates. In other words, how many days are there between January 1st and January

Re: OT? Passing comma delimited list to where clause in stored procedure

2004-10-29 Thread Marc Campeau
The stored procedure query looks like the following: select pet_stuff1, pet_stuff2 from mypettable where pet_type in (inTypeOfPets) The problem is even though my input string looks like 'Dogs','Cats','Horses' the ticks are getting stripped out of the variable (Dogs,Cats,Horses), how do

Re: Has anyone done this?

2004-10-25 Thread Marc Campeau
off the token has used. If the token has already been used it returns an error message which triggers a function that sends the user to the login page. Obviously, you will have to add this to every generated page within your app. -- Marc Campeau

Re: Performance

2004-10-14 Thread Marc Campeau
What's the size of the generated document? I've seen some clients complain of slow load times only to find that they were requesting 1 Mb of HTML and that their computers weren't equipped with lots of RAM. If the rendered ouput as lots of tables within tables it wouldn't be a surprise if IE

Re: BlackStone Beta 1

2004-09-09 Thread Marc Campeau
Hey Dick, to keep flying just avoid thinking about it. See the Art of Flying : http://www.bbc.co.uk/dna/h2g2/A305092 Have a nice day and sorry for my OTness. -- Marc P.S.: Don't panic :) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations

Re: Concatenate 2 binary variables

2004-08-31 Thread Marc Campeau
Is there a way to concatenate 2 binary variables (that contain 2 files): cffile action="" file=#ExpandPath('.')#/file2.bin variable=file1 cffile action="" file=#ExpandPath('.')#/file1.bin variable=file2 You'll probably want to use some Java (look at java.io.fileInputStream) to do that since

Re: Concatenate 2 binary variables

2004-08-31 Thread Marc Campeau
That will only work if the first file has a size that is a multiple of 3 bytes. Thanks for the info Jochem! I guess that it's only doable using some CF add-ons like CFOBJECT then? -- Marc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and

Re: Excel Output File

2004-08-27 Thread Marc Campeau
I'm needing to generate a file in CF that can be directly read in to Excel spreadsheet.I thought a tab-delimited file would do it but Excel '97 won't read it.Complains about it not being a valid SYLK file format. I've had problems with SYLK format once and wondered for a while what was

Re: CSV to Query

2004-08-25 Thread Marc Campeau
Anybody have a UDF for this? I need it sharpish, I can write it myself but if someone else has done this.. whooho! I use a Java library (ExcelCSVParser) from www.Ostermiller.com. You can find some other great utils there too. This is the code I use to parse a CSV file... it creates an array

Re: RandRange ain't so Random

2004-08-23 Thread Marc Campeau
Seems weighted towards the numbers in the middle more. How did you test that? Does/would using randomize() before you call randRange() have an impact on your results? -- Marc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: Looking for french cold fusion resources

2004-08-20 Thread Marc Campeau
On Thu, 19 Aug 2004 16:30:57 -0400, Claude Schneegans [EMAIL PROTECTED] wrote: So my question is, does anyone here know of french cold fusion resources? Yes! ME! ;-)) Sans blagues, je suis prt collaborer pour monter qqch en franais. No problem. Salut Claude, Es-tu en France, au Qubec ou

Re: for all you gmail users

2004-08-20 Thread Marc Campeau
Just create a new folder someplace (I've only done this with personal folders, but I see no reason that it wouldn't work with system folders as well) and call it Gmail.Then right click the folder and choose properties.Now select the Home Page tab.Check the Show home page by default for this

Re: Looking for french cold fusion resources

2004-08-20 Thread Marc Campeau
Those developers are well aware of the issues with AMFPHP. This is why they requested my help to find french CF resources. Thanks for all the links, they will be handy when I decide on translating some of the stuff I find usefull to french. Marc [Todays Threads] [This Message] [Subscription]

Looking for french cold fusion resources

2004-08-19 Thread Marc Campeau
which is the official - I think -Montreal MMUG. Checkout the forum. Thanks in advance -- Marc Campeau P.S.: Here's my background, in case it matters: - B.S. Computer science - CF developer since version 3.0 - Certified CF5 Advanced Developer - Mostly active in the CFUGToronto community [Todays

Re: CFCHART 3D Depth

2004-08-19 Thread Marc Campeau
not mistaken those help with the depth... -- Marc Campeau [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: CFCHART 3D Depth

2004-08-19 Thread Marc Campeau
that seems to do some pretty weird (useless) things to a bar graph. Doesn't seem to change the depth or the effect of it at all Maybe I don't understand what you mean then by way too deep?. xOffset and yOffset can be used to set the angle of which the concerned axis is sheared on the Z axis. so

Re: JAVA Script Error

2004-08-06 Thread Marc Campeau
CFMX, why not submit the upload in the popup and use CFFLUSH to display a message and when the upload is done then send a this.close() script statement as the last FLUSH to the popup. -- Marc Campeau Vertabase, project management made easy. - http://www.vertabase.com [Todays Threads

Re: JAVA Script Error

2004-08-06 Thread Marc Campeau
CFMX, why not submit the upload in the popup and use CFFLUSH to display a message and when the upload is done then send a this.close() script statement as the last FLUSH to the popup. -- Marc Campeau Vertabase, project management made easy. - http://www.vertabase.com [Todays Threads

Re: JAVA Script Error

2004-08-06 Thread Marc Campeau
. As for an example, this could amount to a lot of code, which I don't really have the time to produce. I think you can figure it out from what I explained. -- Marc Campeau Vertabase, project management made easy. - http://www.vertabase.com [Todays Threads] [This Message] [Subscription] [Fast

Re: JAVA Script Error

2004-08-06 Thread Marc Campeau
() and assigning it to onLoad, but I'm not sure how well such a script would work. -- Marc Campeau Vertabase, project management made easy. - http://www.vertabase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: Web Team Project Management App

2004-08-06 Thread Marc Campeau
-- Marc Campeau Vertabase, project management made easy. - http://www.vertabase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: Web Team Project Management App

2004-08-06 Thread Marc Campeau
to post! Neither do I. -- Marc Campeau [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: Can't Update more than 13 records - Datatype Mismatch Error - HELP!

2004-08-05 Thread Marc Campeau
Are all the columns of data type string? If not, why are you quoting all the values? -- Marc Campeau Vertabase, project management made easy. - http://www.vertabase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: ColdFusion and MVC model...

2004-07-20 Thread Marc Campeau
of an Enterprise Application using OO techniques. I'd like it to be able to go from requirements through design and up-to implementation, though requirements through design would be great. I know I'm straying off the subject and I'm sorry if this is all in the archive... ;) -- Marc Campeau Vertabase

Re: Free Stuff: Tree, Tab, Accordian Pane Custom Tags

2004-07-16 Thread Marc Campeau
extensions for this type of behaviors to make it even easier to use. Marc Campeau [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

CF 4.5.1 and the CFOUTPUT whitespace undocumented feature

2000-07-25 Thread Marc Campeau
and, as suspected, I got the whitespace problem on the dev server to. Could anyone verify this and if someone from Allaire on the list could check into it, it would be appreciated. Marc Campeau Analyste K-OS Multimedia Inc. 5505, Boul. Saint-Laurent, bureau 4210 Montreal