RE: PostgreSQL database size

2004-11-30 Thread Hugo Ahlenius
Mike, Check out the ColdFusion + ArcIMS blog for more information: http://www.mariposa.com.au/arcims/ Cheers, Hugo (we are using CFMX + ArcSDE + ArcIMS ) -- Hugo Ahlenius - Hugo Ahlenius E-Mail: [EMAIL PROTECTED]

RE: OT: Flashpaper

2004-11-30 Thread Robertson-Ravo, Neil (RX)
Hey, Well I am having some good success with Flashpaper and calling it via ColdFusion BUT the problem I have is this: when you convert an HTM or HTML page it always comes up with the damn printing dialog box which the user has to select - which makes no sense as when you convert a .doc it does it

RE: Best way to access CFC's?

2004-11-30 Thread Andy Mcshane
Thanks Dave, I will take a look. Andy McShane Head of Development Scout7 Ltd, 324a Lichfield Road, Mere Green, Sutton Coldfield West Midlands United Kingdom B74 2UW Telephone: +44 (0)121 323 2640 Mobile : 07866 430783 Fax: +44 (0)121 323 2010 Email: mailto:[EMAIL PROTECTED] Website:

RE: Best way to access CFC's?

2004-11-30 Thread Andy Mcshane
Are there any benefits of one over the other? Are there any performance issues to consider? Andy McShane Head of Development Scout7 Ltd, 324a Lichfield Road, Mere Green, Sutton Coldfield West Midlands United Kingdom B74 2UW Telephone: +44 (0)121 323 2640 Mobile : 07866 430783 Fax: +44

Re: CF and Databases

2004-11-30 Thread Stephen Moretti (cfmaster)
Jason Smith wrote: I have a client that has access backend for his cf application, when trying to run a query for a report that checks for item status the page always times out never will load. The query works on other reports with no problem. There are about 1500 products in the field and the

RE: Best way to access CFC's?

2004-11-30 Thread Andy Mcshane
Thanks, that makes it a little clearer. Now for the newbie dumb question, how does the code know where to find the components? i.e. !--- Instantiate a component that adds two numbers --- cfset myAdder = createObject(component, addsTwoNumbers) / Do you have to create a mapping to a directory

RE: Slideshow like on news.bbc.co.uk

2004-11-30 Thread Stuart Kidd
Dave, I looked into Flash Remoting for Coldfusion. There is an article at: http://www.macromedia.com/devnet/mx/coldfusion/articles/slideshow/slideshow.html I managed to get the first example to work but where it really counted, the one that also had descriptions could not for some bizarre

CFEclipse - Database Viewer (MS Access)

2004-11-30 Thread Dwayne Cole
Just start using cfeclipse and I'm loving it. Most of our Databases are MS Access Database and I am looking for a good Eclipse plugin that would allow me to view and work with MS Access. I've tried dbViewer and it only seems to accept jdbc connection and from my understanding MS Access

Re: Slideshow like on news.bbc.co.uk

2004-11-30 Thread Marco Antonio C. Santos
Stuart please look this site: http://www.renatoimoveis.com/venda_detalhes.cfm?imovID=E117DE64-3472-FB8F-9FBE84A746D5F0D1 in the footer you could see a very nice slide show built with js and populate from CF. Click in iniciar to start the slide show. parar will stop, avançar and so on... If you

RE: CFEclipse - Database Viewer (MS Access)

2004-11-30 Thread Robertson-Ravo, Neil (RX)
Hmm, I would say that this is possible...have a look at http://eclipse-plugins.2y.net/eclipse/plugins.jsp?category=Database, you get what you want here. -Original Message- From: Dwayne Cole [mailto:[EMAIL PROTECTED] Sent: 30 November 2004 11:32 To: CF-Talk Subject: CFEclipse -

RE: CFEclipse - Database Viewer (MS Access)

2004-11-30 Thread Dwayne Cole
Thanks. I looked at many of these and I had a difficult time finding something that works with MS Access. In fact tried DBEdit and dbViewer and no luck.I can certainly try a few of the other but I was hoping to avoid the hassel of installing things that don't work. Or maybe they do and

RE: Incremental CFCONTENT?

2004-11-30 Thread Katz, Dov B (IT)
Thanks to all. This is great, and works well. I keep forgetting that cfmx now has jsp/servlet support. Not quite sure if it improves performance all that much, but it makes me feel comfortable that I'm not needlessly CFFILE-reading cached sections of pages into memory before dumping them to the

Error establishing socket

2004-11-30 Thread Katz, Dov B (IT)
I'm running MSSQL2k and CFMX 6.1 on the same box. I just bounced the cf box b/c the JRun Protocol Error page was showing (Cannot connect to JRun)... on some, but not all requests. Then, I got this error after bouncing CF,... Error Executing Database Query. [Macromedia][SQLServer JDBC

Possible Connection Leak?

2004-11-30 Thread Katz, Dov B (IT)
After doing some debugging, my JVM_BIND issue seems like CF's java process ran out of file handles (however you describe them on windows sockets, etc)... I suspect there is a leak in error handling of CFMail which can forget to close socket resources obtained in the mail thread If I

RE: Slideshow like on news.bbc.co.uk

2004-11-30 Thread dave
no its not hard but im not sure that u need to go all the way to remoting look at this http://www.jamwerx.com/slides/1.htm if that works for you just save the page and use that swf, u can resize it if u need to then there are 2 embeds the 1st one uses images i manually entered, the 2nd i

Re: Best way to access CFC's?

2004-11-30 Thread Deanna Schneider
In that example, it will look in the directory of the calling template. The component part of the call tells it that you're creating an object of type component. You can also have a mapping to a directory for components, and you can also use dot notation. For example: cfset myAdder =

RE: Best way to access CFC's?

2004-11-30 Thread Andy Mcshane
Great, got it. Many thanks for your help. Andy McShane Head of Development Scout7 Ltd, 324a Lichfield Road, Mere Green, Sutton Coldfield West Midlands United Kingdom B74 2UW Telephone: +44 (0)121 323 2640 Mobile : 07866 430783 Fax: +44 (0)121 323 2010 Email: mailto:[EMAIL PROTECTED]

RE: CFEclipse - Database Viewer (MS Access)

2004-11-30 Thread Ben Rogers
My guess would be that DBEdit would work if you can find a JDBC driver for Access: http://servlet.java.sun.com/products/jdbc/drivers/search_results.jsp?jdbc_ve rsion=0vendor_name=cert_mode=andjdbc_driver_type_mode=anddbms=6dbms_mod e=andfeatures_mode=andresults_per_page=20submit=Search dbViewer

RE: CFEclipse - Database Viewer (MS Access)

2004-11-30 Thread Dwayne Cole
dbViewer seems to work using ODBC. Did you try setting up an ODBC data source and pointing it at your Access database? Huh? Sorry I'm a Newbie at least when in comes to working with ODBC / JDBC drivers. ~| Special thanks to

RE: CFEclipse - Database Viewer (MS Access)

2004-11-30 Thread Dwayne Cole
dbViewer seems to work using ODBC. Did you try setting up an ODBC data source and pointing it at your Access database? Just discover that my databasess are referenced in the System ODBC area. Now it dbViewer it ask for a directory path to the driver. How do you find that?

RE: Licensing a CF app

2004-11-30 Thread Vince Bonfanti
I'm not sure that re-writing a tonne of code is what would be required. We've converted a number of fairly large applications (thousands of pages) to BlueDragon; the time doing so is usually measured in hours or days. Often it's only one or two tweaks that have to be made to get everything

Re: CFMX 6.1 - java.lang.NullPointerException

2004-11-30 Thread Matthew Drayer
The stack trace does seem to report an issue with casting a particular variable as a double datatype, and which is somehow related to the update of data in the client scope. In my experience, however, NullPointerException errors are triggered by invalid custom tag references. ie, the filename

Calendar Apps?

2004-11-30 Thread Eric Creese
Old subject but thought I would aask again is there any free calendar apps out there anyone is willing to part with I am looking for something that someone can check there own as well of the rest of the groups events. ~|

Re: Calendar Apps?

2004-11-30 Thread Jordan Michaels
http://calendar.viviotech.net/ Sooo close to being done... -Jordan Eric Creese wrote: Old subject but thought I would aask again is there any free calendar apps out there anyone is willing to part with I am looking for something that someone can check there own as well of the rest of

Re: MX Methodologies (Mach2?? Fusebox??)

2004-11-30 Thread Claude Schneegans
It is a big deal if it made your job easier and your project more successful. My point is that it DOES NOT make my job easy. Apparently, at least for the product I'm thinking of, it made easier for the programmers to make an inefficient system that repeats 5 times the same query in the same

Re: MX Methodologies (Mach2?? Fusebox??)

2004-11-30 Thread Claude Schneegans
Don't you mean a web page.. when.. someone talks to me about a web application.. i'm more thinking in terms of web services.. There is no difference, a Web application is nothing but a set of Web pages working on some set of data. Hmm.. how about RemoteScripting (JSRS), Flash.. These is on the

Re: MX Methodologies (Mach2?? Fusebox??)

2004-11-30 Thread Brian Kotek
I'm not sure how many times it must be stated in this thread that using a framework will not prevent a bad developer from writing bad code any more than using an OO language like Java can prevent bad code. If this application that you worked on made an inefficient system that duplicates queries

RE: Calendar Apps?

2004-11-30 Thread Mark A Kruger
Jordan, Hey - how about a sample -Original Message- From: Jordan Michaels [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 30, 2004 7:32 AM To: CF-Talk Subject: Re: Calendar Apps? http://calendar.viviotech.net/ Sooo close to being done... -Jordan Eric Creese wrote: Old

Re: Calendar Apps?

2004-11-30 Thread Simon Horwith
I was in the middle of creating one if you ping me about it from time to time (or check my blog periodically), I'll gladly give it away. ~Simon Simon Horwith Chief Information Officer, AboutWeb http://www.aboutweb.com Member of Team Macromedia Macromedia Certified Master Instructor

Re: Slideshow like on news.bbc.co.uk

2004-11-30 Thread Doug James
Here is a little slide show I did that uses JavaScript and CF. It pulls the name of all the pictures in a specific directory and then builds the slide show from there allowing me to add or remove pictures just by putting pictures in the directory. If you are interested I can send you the CF

Re: Slideshow like on news.bbc.co.uk

2004-11-30 Thread Doug James
Sorry, forgot the link: http://www.dragonboatcharleston.org/index.cfm?show=photos.main Doug Doug James wrote: Here is a little slide show I did that uses JavaScript and CF. It pulls the name of all the pictures in a specific directory and then builds the slide show from there allowing me

Re: CFEclipse - Database Viewer (MS Access)

2004-11-30 Thread Rob
I don't use windows or access so this is mostly just bits of information... What you have to do is setup a system (or user I guess) odbc data source (using control panel) - which should be basic for a windows savy sort... then for the jdbc driver you use the jdbc odbc bridge. The driver name is:

unix user cfexecute

2004-11-30 Thread gijs meirmans
In the documentation of cfexecute the effective user is mentioned. I like to know how to find out the user who executes the executable fired by cfexecute. I think this is the effective user, but when i try to found out about it on the web I could not find a thing about it. Can anybodie help me

Re: MX Methodologies (Mach2?? Fusebox??)

2004-11-30 Thread Aaron Rouse
Claude, My question was worded that way due to the way his statement was worded. I was simply curious what he felt was, I was not hinting towards anything with the question just being curious since his statement to me implied that he thought there was a general better solution. I always find

RE: Slideshow like on news.bbc.co.uk

2004-11-30 Thread Eric Creese
I would like the code cause I use a js slide show now and would like to populate it dynamically -Original Message- From: Doug James [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 30, 2004 9:58 AM To: CF-Talk Subject: Re: Slideshow like on news.bbc.co.uk Here is a little slide show I

Re: MX Methodologies (Mach2?? Fusebox??)

2004-11-30 Thread Stephen Moretti (cfmaster)
Claude Schneegans wrote: It is a big deal if it made your job easier and your project more successful. My point is that it DOES NOT make my job easy. Apparently, at least for the product I'm thinking of, it made easier for the programmers to make an inefficient system that repeats 5

cfstoredproc and cfdump

2004-11-30 Thread Ian Littlefair
I'm using the following stored procedure and using cfdump to see the output. This is the stored procedure:- cfstoredproc procedure=mysp dataSource=mydsn username=myusername password=mypassword cfprocparam value=#Form.username# cfsqltype=CF_SQL_INTEGER type=In cfprocparam

Anyone see this error before?

2004-11-30 Thread Phill B
I got this out of the blue on CFMX 6.1 unable to create new native thread If you know what would cause it, could you explain it to me? -- Phillip B. ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby

RE: Anyone see this error before?

2004-11-30 Thread Greg Landers
I have seen it thrown on a CFFILE action upload ... ended up being an incorrect destination path being plugged into the tag. Greg Landers -Original Message- From: Phill B [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 30, 2004 10:33 AM To: CF-Talk Subject: Anyone see this error

Re: cfstoredproc and cfdump

2004-11-30 Thread Adrocknaphobia
queryName.columnList ? -Adam On Tue, 30 Nov 2004 11:18:03 -0400, Ian Littlefair [EMAIL PROTECTED] wrote: I'm using the following stored procedure and using cfdump to see the output. This is the stored procedure:- cfstoredproc procedure=mysp dataSource=mydsn username=myusername

RE: MX Methodologies (Mach2?? Fusebox??)

2004-11-30 Thread Steve Brownlee
Other than for code re-use, I still don't quite understand why OO is being forced onto a concept that is inherently procedural. Forced is a strong word, but probably accurate given the current environment in development today. As people have said, there are situations where it is useful and

Re: MX Methodologies (Mach2?? Fusebox??)

2004-11-30 Thread Alex Sherwood
Look, this is all very simple. The best frameworks/methodologies ranked in order are: 1) Mach-II 2) JSF-CF (Java Server Faces for CF) 3) CFOBJECKTS 4) FuseBox 4 5) FuseBox 3 6) MVC-QT (The most RAD environment for making MVC apps) The new MX-XCEL framework and wireframing system should be out

just a test: ignore

2004-11-30 Thread Patti Lee
just testing ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185678 Archives:

RE: MX Methodologies (Mach2?? Fusebox??)

2004-11-30 Thread Damien McKenna
Care to provide links for some of those, namely JSF-CF, MVC-QT and MX-XCEL? I couldn't find anything on Google for them. Thanks. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 Why are you wearing that stupid man suit? -

Re: unix user cfexecute

2004-11-30 Thread Dave Carabetta
On Tue, 30 Nov 2004 11:13:04 -0400, gijs meirmans [EMAIL PROTECTED] wrote: In the documentation of cfexecute the effective user is mentioned. I like to know how to find out the user who executes the executable fired by cfexecute. I think this is the effective user, but when i try to found out

SQL Query question. Please help...

2004-11-30 Thread Che Vilnonis
Say I have two simple queries: cfquery name=getCustsFromCusts datasource=#DSN# SELECT CustID FROMCustomers /cfquery [and that query returns 700 records.] cfquery name=getCustsFromOrders datasource=#DSN# SELECT CustID FROMOrders /cfquery [and that query returns 500 records.] The first

Re: cfstoredproc and cfdump

2004-11-30 Thread Ian Littlefair
queryName.columnList ? -Adam On Tue, 30 Nov 2004 11:18:03 -0400, Ian Littlefair [EMAIL PROTECTED] wrote: ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message:

Re: cfstoredproc and cfdump

2004-11-30 Thread Ian Littlefair
Thanks Adam. Could you be a bit more specific please? Ian ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185683 Archives:

Re: SQL Query question. Please help...

2004-11-30 Thread Adam Haskell
Multiple ways heres one: SELECT CustID FROMCustomers WHERE CustID NOT IN (Select CustID From Orders) Adam On Tue, 30 Nov 2004 12:01:30 -0500, Che Vilnonis [EMAIL PROTECTED] wrote: Say I have two simple queries: cfquery name=getCustsFromCusts datasource=#DSN# SELECT CustID FROM

RE: SQL Query question. Please help...

2004-11-30 Thread Katz, Dov B (IT)
How about this? Select CustID from customers where custID not in (select custid from orders) -dov -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 30, 2004 12:01 PM To: CF-Talk Subject: SQL Query question. Please help... Say I have two simple

RE: SQL Query question. Please help...

2004-11-30 Thread Eric Creese
Sometimes using NOT can have performance issues You can also do: SELECT a.CustID FROMCustomers a,Orders b WHERE a.CustID = b.CustID -Original Message- From: Adam Haskell [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 30, 2004 11:06 AM To: CF-Talk Subject: Re: SQL Query question.

RE: SQL Query question. Please help...

2004-11-30 Thread Eric Creese
Lookingat this more you will probably only want unique customers so it some opne places multiple orders you may want to throw a distinct in there SELECT DISTINCT a.CustID FROMCustomers a,Orders b WHERE a.CustID = b.CustID -Original Message- From: Eric Creese Sent: Tuesday,

Re: SQL Query question. Please help...

2004-11-30 Thread Greg Morphis
select custid from customers minus select custid from orders On Tue, 30 Nov 2004 11:05:11 -0600, Eric Creese [EMAIL PROTECTED] wrote: Sometimes using NOT can have performance issues You can also do: SELECT a.CustID FROMCustomers a,Orders b WHERE a.CustID = b.CustID

Re: SQL Query question. Please help...

2004-11-30 Thread Adam Haskell
Sometimes not join in the from clause can have performance issues too plus that will only return customers that are in both tables. If you prefer ther other route youi can do this: Select Distinct cust.CustId From Customers cust LEFT JOIN orders ON cust.custID = orders.CustId Where Orders.CustId

RE: SQL Query question. Please help...

2004-11-30 Thread Che Vilnonis
Adam/Dov Using your query my recordcount is off. Actual # of customer ids from my customers table = 865. Actual # of customer ids from my orders table = 596. Using your query, the difference = 335. 865 - 596 should = 269. What am I missing? Debug info is below.

Re: SQL Query question. Please help...

2004-11-30 Thread Adam Haskell
Under your math you are assuming a 1 to 1 relationship between orders and Custromers. Unless you are running a scam, where no customer would ever by from you twice, that is not case, the whole reason you have 2 seperate tables. Hope thats makes sense. Adam H On Tue, 30 Nov 2004 12:18:23 -0500,

RE: CFScheduler and java mail exceptions....

2004-11-30 Thread rob.stokes
Sorry for bumping this, but *any help it appreciated! Thanks Rob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 29 November 2004 10:45 am To: CF-Talk Subject: CFScheduler and java mail exceptions Morning all I've got a scheduled task that distributes

RE: SQL Query question. Please help...

2004-11-30 Thread Dave Francis
You have multiple Orders for some customers. What is count for: SELECT DISTINCT Custid from Orders -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 30, 2004 12:18 PM To: CF-Talk Subject: RE: SQL Query question. Please help... Adam/Dov

RE: SQL Query question. Please help...

2004-11-30 Thread Che Vilnonis
I see. Haven't had my lunch yet. Thanks for your help. Che -Original Message- From: Adam Haskell [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 30, 2004 12:23 PM To: CF-Talk Subject: Re: SQL Query question. Please help... Under your math you are assuming a 1 to 1 relationship

Re: SQL Query question. Please help... HA!

2004-11-30 Thread Anders Green
At 12:22 PM 11/30/2004, Adam Haskell wrote: Under your math you are assuming a 1 to 1 relationship between orders and Custromers. Unless you are running a scam, where no customer would ever by from you twice, that is not case, the whole reason you have 2 seperate tables. Hope thats makes sense.

Re: cfstoredproc and cfdump

2004-11-30 Thread Stephen Moretti (cfmaster)
Ian Littlefair wrote: Thanks Adam. Could you be a bit more specific please? If you output searchResults.columnlist after you've called your stored procedure it should give you the list of columns returned. However, from your cfdump I would hazard that the column names will be :B1 and

SQL Question

2004-11-30 Thread Andy Ousterhout
In MS SQL, why does this work: CASE YEAR(tabInvoices.InvoiceDate) but this throw and error that InvoiceDate is not in group: CASE YEAR(tabInvoices.InvoiceDate) -1 I can't add InvoiceDate to GROUP BY because then the results are wrong Andy

Re: cfstoredproc and cfdump

2004-11-30 Thread Stephen Moretti (cfmaster)
Stephen Moretti (cfmaster) wrote: Ian Littlefair wrote: Thanks Adam. Could you be a bit more specific please? If you output searchResults.columnlist after you've called your stored procedure it should give you the list of columns returned. However, from your cfdump I would hazard

CFMODULE vs. CFINCLUDE

2004-11-30 Thread Michael Dinowitz
I'm rewriting Raymond's Lighthouse Bugtracker (not my idea) and one piece bought up an old question I had. Is there any performance difference between a CFMODULE acting as a layout wrapper or 2 CFINCLUDE templates with layout? In the first case, your code is: cfmodule template=layout.cfm Display

RE: CFMODULE vs. CFINCLUDE

2004-11-30 Thread Katz, Dov B (IT)
CFModule encapsulates the layout nicer than 2 isolated CFINCLUDES... You have a single layout.cfm which detects if #thistag.executionmode# is start and shows the header or footer. It makes for an easier read if the module is CF_TAGNAME'd.. Example... You have layout.cfm, so you can do this:

Re: CFMODULE vs. CFINCLUDE

2004-11-30 Thread Stephen Moretti (cfmaster)
Michael Dinowitz wrote: I'm rewriting Raymond's Lighthouse Bugtracker (not my idea) and one piece bought up an old question I had. Is there any performance difference between a CFMODULE acting as a layout wrapper or 2 CFINCLUDE templates with layout? In the first case, your code is: cfmodule

Re: MX Methodologies (Mach2?? Fusebox??)

2004-11-30 Thread Alex Sherwood
Damien McKenna wrote: Care to provide links for some of those, namely JSF-CF, MVC-QT and MX-XCEL? I couldn't find anything on Google for them. Thanks. Please forgive me. I couldn't resist throwing a bunch of made up frameworks into the mix to fan the flames. The names are pretty good,

Re: CFEclipse - Database Viewer (MS Access)

2004-11-30 Thread Dwayne Cole
This almost worked. It seems to referring to the named datasource, which in my case is a ms accesss file, as a database server and all the registered ODBC datasources are showing up as database on the server. The schema information was correctly queryed but details about the columns etc. did

Re: MX Methodologies (Mach2?? Fusebox??)

2004-11-30 Thread Brian Kotek
That is so hilarious and I'm being serious not sarcastic at all. Great input as always Alex. On Tue, 30 Nov 2004 11:39:46 -0500, Alex Sherwood [EMAIL PROTECTED] wrote: Look, this is all very simple. The best frameworks/methodologies ranked in order are: 1) Mach-II 2) JSF-CF (Java

RE: SQL Question

2004-11-30 Thread Mark A Kruger
Andy, Try: YEAR(dateadd(year,-1,tabInvoices.InvoiceDate) -mk -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 30, 2004 11:37 AM To: CF-Talk Subject: SQL Question In MS SQL, why does this work: CASE YEAR(tabInvoices.InvoiceDate) but this

Embedding Images in Excel

2004-11-30 Thread Scott Brady
We have a series of reports which include graphs (via cfchart in .jpg format). We provide the ability to export those reports to Excel. However, if a user saves that excel spreadsheet and opens it later (after CF has cleared the cache), the image has expired. Primarily, this is because,

Re: MX Methodologies (Mach2?? Fusebox??)

2004-11-30 Thread Brian Kotek
If you're serious I'm sure numerous people would be interested in looking at it! On Tue, 30 Nov 2004 13:05:40 -0500, Alex Sherwood [EMAIL PROTECTED] wrote: Damien McKenna wrote: Care to provide links for some of those, namely JSF-CF, MVC-QT and MX-XCEL? I couldn't find anything on Google

Re: MX Methodologies (Mach2?? Fusebox??)

2004-11-30 Thread Alex Sherwood
Brian Kotek wrote: If you're serious I'm sure numerous people would be interested in looking at it! Unfortunately, it removes much of the proper restrictions in Mach-II (like peeking into the eventQueue, prepeding events, extending the framework iteself) that create the uniformity of the

RE: CFMODULE vs. CFINCLUDE

2004-11-30 Thread Michael Dinowitz
If I remember correctly, doesn't cfmodule create a whole new memory block for every call, where as the cfinclude will only use the existing memory space and be part of the normal page cache? You are correct, even in CFMX. Even if this isn't true for CFMX any more, personally, I'd probably

Re: CFMODULE vs. CFINCLUDE

2004-11-30 Thread Simon Horwith
Not that it's a huge deal, but don't forget that cfmodule also requires a single file compilatation as opossed to two file compilations, as well ;) ~Simon Simon Horwith Chief Information Officer, AboutWeb http://www.aboutweb.com Member of Team Macromedia Macromedia Certified Master Instructor

Re: Calendar Apps?

2004-11-30 Thread Barney Boisvert
I'm in the process of creating a simple calendaring app as a proof-of-concept for a backend framework I'm working on. Both the framework and the app will be free (as in speech and beer) when I'm done. cheers, barneyb On Tue, 30 Nov 2004 08:40:08 -0600, Eric Creese [EMAIL PROTECTED] wrote: Old

RE: Embedding Images in Excel

2004-11-30 Thread Burns, John D
Try inserting a simple image into a blank excel sheet and then save it and open the excel sheet in a text editor. See what the actual code looks like and how they embed an image in there. John -Original Message- From: Scott Brady [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 30,

Re: MX Methodologies (Mach2?? Fusebox??)

2004-11-30 Thread Kwang Suh
I've worked on precisely zero web apps that didn't have to have functionality added to it. I've worked on precisely zero web apps that didn't have to have maintenance done to it. This is over the course of 7 years. Everything a developer writes can benefit from OO. Does it make apps more

Best Practice: Import Delimited List to Database

2004-11-30 Thread Les Mizzell
Client is looking for an application to import a delimited list of names and email addresses directly into a database for further manipulation. While I can think of a number of ways to pull this off, what's the opinion on the most efficient way to doing it? Thanks, -- Les Mizzell

Re: CFMODULE vs. CFINCLUDE

2004-11-30 Thread Raymond Camden
I'd agree with Simon, specifically the not that it's a huge big deal. I'll go out on a limb here and say if your site will not work when using cf_foo/cf_foo versus an include, then you have other problems. Yes, cf_foo (or cfmodule) is slower than cfinclue. But don't worry about it. Unless you

Re: Best Practice: Import Delimited List to Database

2004-11-30 Thread Bryan Stevenson
Depends on the database and the source ;-) SQL Server...use DTS (data transformation service) to import the list (CSV file...Excel file...other DB) Any tab or comma delimited file should be super easy to parse and insert into the DB...client could upload file and that would fire off the

Re: Best Practice: Import Delimited List to Database

2004-11-30 Thread Jerry Johnson
You could: Use a DTS package for the import. Treat the file like a cf datasource using the txt driver. Read the file using cf_file and step through each record tucking it into the db. I'd want a little more detail on what database, how long the list is and how often this happens before deciding.

Re: Best Practice: Import Delimited List to Database

2004-11-30 Thread Les Mizzell
SQL Server...use DTS (data transformation service) to import the list (CSV file...Excel file...other DB) This will have to be done from an administration form from a web page. The client isn't going to have access to the SQL Admin, nor do we want him too!! -- Les Mizzell

RE: Best Practice: Import Delimited List to Database

2004-11-30 Thread Burns, John D
Do they want you to build a web-based app or could they access the DB server directly? MS SQL Server has built-in capabilities for this with the import wizard. I've done a web-based app to do this sort of thing as well and can lend some advice if that's what you're looking for. Just let me know.

RE: Best Practice: Import Delimited List to Database

2004-11-30 Thread Michael Dinowitz
What is the source of this list? If it's a file, what is the size. Raymond wrote a nice UDF wrapper for a java call that imports and loops over a file that works better than CFFILE/CFLOOP. I've used it (modified) to import a few hundred thousand line file into a DB. Once you have the data and

Re: Best Practice: Import Delimited List to Database

2004-11-30 Thread Anders Green
At 02:01 PM 11/30/2004, Bryan Stevenson wrote: Depends on the database and the source ;-) And how often it needs to be done. Once? Once a day? And who is going to do it. SQL Programmer? Secretary? No one will be able to advise you on efficiency until you specify who you're trying to make it

Re: Best Practice: Import Delimited List to Database

2004-11-30 Thread Jerry Johnson
Cold fusion can execute DTS packages from the server. A cfm page can gather the data, set up the database, then trigger the DTS package to run the import without the user even being aware of what is happening. Jerry Jerry Johnson Web Developer Dolan Media Company [EMAIL PROTECTED] 11/30/04

Re: Best Practice: Import Delimited List to Database

2004-11-30 Thread Bryan Stevenson
Yep...but you can fire DTS on the fly ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com - Original Message - From: Les

Re: Best Practice: Import Delimited List to Database

2004-11-30 Thread Aaron Rouse
What was the name of that UDF? I would not mind looking into it since I have the need to import some excel data via a web form into an Oracle database. They would be saving their spreadsheets as CSV files then uploading them via a web form. -- Aaron Rouse http://www.happyhacker.com/ On Tue,

RE: Best Practice: Import Delimited List to Database

2004-11-30 Thread Michael Dinowitz
FileRead http://cflib.org/udf.cfm?ID=417 What was the name of that UDF? I would not mind looking into it since I have the need to import some excel data via a web form into an Oracle database. They would be saving their spreadsheets as CSV files then uploading them via a web form. --

RE: Best Practice: Import Delimited List to Database

2004-11-30 Thread Burns, John D
Ok, well, if you can GUARANTEE that the data will be in the proper order everytime than it's pretty easy. Obviously, you'll have to do some data-checking and stuff but if they're smart enough to give it in the correct format, that makes things much easier. In generic terms, what I've done is

Re: Best Practice: Import Delimited List to Database

2004-11-30 Thread Adam Haskell
If you're running SQL server check out BULK INSERT. Adam On Tue, 30 Nov 2004 13:12:57 -0600, Aaron Rouse [EMAIL PROTECTED] wrote: What was the name of that UDF? I would not mind looking into it since I have the need to import some excel data via a web form into an Oracle database. They

jsessionid cookies

2004-11-30 Thread Nick Cabell
I am running CFMX on my development XP machine and have turned OFF Use j2ee session variables i.e. it is NOT checked but a session cookie called jsessionid is still written (twice!) everytime I enter the site from my browser. I have cleared out all cookies and can see it being written as I enter

Re: Best Practice: Import Delimited List to Database

2004-11-30 Thread Aaron Rouse
I am using Oracle, was stated in my quoted msg you included. I could use SQLLDR, this import need is down low on the todo list so I have just randomly been looking into different avenues. -- Aaron Rouse http://www.happyhacker.com/ On Tue, 30 Nov 2004 14:19:04 -0500, Adam Haskell [EMAIL

Re: Embedding Images in Excel

2004-11-30 Thread Scott Brady
Well, since I can't view a binary file in a text editor (at least, not meaningfully so that I know of), all I can do is save it in some other format. Saving it as HTML doesn't help too much, because it ends up being the same (linking to an image). I may have to find some other way to do it. They

Re: Incremental CFCONTENT?

2004-11-30 Thread Kwang Suh
It wouldn't register in the log. It's not an http call. Thanks to all. This is great, and works well. I keep forgetting that cfmx now has jsp/servlet support. Not quite sure if it improves performance all that much, but it makes me feel comfortable that I'm not needlessly CFFILE-reading

Clustercat replacement?

2004-11-30 Thread Michael Dinowitz
Mothernature.com has a cluster using open director and cluster cats. Cluster cats is buggy for us and we'd like to replace it. Is there a good replacement for it? Can MX talk directly to open director? Can MX gather IIS status info? We're just looking for options. Thanks

Re: Anyone see this error before?

2004-11-30 Thread Phill B
I've been getting it about once a week. The problem I have is that the logs don't tell me what caused it. Just that it happened. On Tue, 30 Nov 2004 10:37:58 -0600, Greg Landers [EMAIL PROTECTED] wrote: I have seen it thrown on a CFFILE action upload ... ended up being an incorrect destination

Re: Best Practice: Import Delimited List to Database

2004-11-30 Thread Adam Haskell
Sorry quoted the wrong person was directed toward Les. Your post was the last post and I hit reply, case of me being lazy :) Adam On Tue, 30 Nov 2004 13:31:40 -0600, Aaron Rouse [EMAIL PROTECTED] wrote: I am using Oracle, was stated in my quoted msg you included. I could use SQLLDR, this

RE: jsessionid cookies

2004-11-30 Thread Chris Norloff
CFMX doesn't set the jsessionid cookie itself, it's set by the J2EE application server. Setting CMFX to use J2EE session management means CFMX session variables are stored in the J2EE HTTP session object (and can thus be accessed through Java calls). Setting CFMX for J2EE session management on

  1   2   >