Re: Replying after the message

2006-09-06 Thread Robertson-Ravo, Neil (RX)
I think that in is most cases, I am reading on my Blackberry and for long posts, you get a scroll for more, and more just to read a reply... I think it is a preference, got a to love a top v bottom preference! This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond,

Re: Replying after the message

2006-09-06 Thread Robertson-Ravo, Neil (RX)
What lists are these? This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the

Re: Search-function on website

2006-09-06 Thread Auke van Leeuwen
If you used Verity in CF 5, did you use the K2 engine or the VDK engine? The K2 engine is much better in many respects, and if I recall correctly, CFMX 6.x uses K2 instead of VDK. I don't realy recall any specific choice that I made. K2 sounds the most familiar, but that may be because it's used

Re: Replying after the message

2006-09-06 Thread Robertson-Ravo, Neil (RX)
An RFC for posting, lol. Looks like I will have to scroll for more, and more, and more:-) This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains

Re: Search-function on website

2006-09-06 Thread Robertson-Ravo, Neil (RX)
You may have to code/develop something using the Verity SDK but I am not sure what is available with the OEM version which ships with ColdFusion. This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business,

Re: passing arguments into a instantiated java object

2006-09-06 Thread D F
thanks for that Dan, now watch me attempt to absorb your Java knowledge. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four

Cross-Server Joins

2006-09-06 Thread James Smith
I have heard tell that it is possible to perform cross-database and even cross-server joins in MSSQL but I can't find any good info on how it is done. Can someone point me in the right direction, specifically for the cross server stuff? -- Jay

Re: Fusion Reactor issues

2006-09-06 Thread Maureen Barger
Can you: -adjust your jvm memory settings so you have more available memory for CF? -adjust your FR settings so it doesn't kill threads, or at least allow more threads until it starts killing them off? Unfortunately FR is within the CF container, so if CF is unresponsive, FR will be too. :( --

Re: I am soooo pissed

2006-09-06 Thread Neil Middleton
Whats the betting that domain will be available again, in say, 3 days? On 9/5/06, Jim McAtee [EMAIL PROTECTED] wrote: ..com's are s 1999 - Original Message - From: Doug Brown [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, September 05, 2006 2:58 PM

RE: Cross-Server Joins

2006-09-06 Thread James Smith
I have heard tell that it is possible to perform cross-database and even cross-server joins in MSSQL but I can't find any good info on how it is done. Can someone point me in the right direction, specifically for the cross server stuff? Before you reply, my mistake. By cross-server I

Re: Cross-Server Joins

2006-09-06 Thread Jose Diaz
Hi Jay You need to have a look at linked servers, this article has a heap of stuff in it. http://www.databasejournal.com/features/mssql/article.php/3085211 Im sure there is a simpler route by prefixing the table with the db.owner.table or something like that, Neil Ravo Robertson was the chap I

Re: Cross-Server Joins

2006-09-06 Thread Jose Diaz
Ah okay, Linked servers I would say would be the way. Jose On 9/6/06, James Smith [EMAIL PROTECTED] wrote: I have heard tell that it is possible to perform cross-database and even cross-server joins in MSSQL but I can't find any good info on how it is done. Can someone point me in the

Re: Cross-Server Joins

2006-09-06 Thread Jose Diaz
However James Ive never actually done what your requesting myself, if it works I'd love to know heh ;) On 9/6/06, Jose Diaz [EMAIL PROTECTED] wrote: Ah okay, Linked servers I would say would be the way. Jose On 9/6/06, James Smith [EMAIL PROTECTED] wrote: I have heard tell that it is

RE: Cross-Server Joins

2006-09-06 Thread Robertson-Ravo, Neil (RX)
Indeed, Linked Servers is what you want to look for - not sure about the performance though ;-) -Original Message- From: Jose Diaz [mailto:[EMAIL PROTECTED] Sent: 06 September 2006 11:22 To: CF-Talk Subject: Re: Cross-Server Joins Ah okay, Linked servers I would say would be the way.

RE: Cross-Server Joins

2006-09-06 Thread James Smith
There is a good walkthrough at http://developer.infi.nl/index.php?ID=6article=6 but after creating the linked server it fails when I try to access it. Neither server craches the enterprise manager just sits there doing nothing, no processors get 100% used, no memory gets hogged, it just sits

Re: Coldfusion serial number lost

2006-09-06 Thread Massimo Gianadda
Thank you for your help, unfortunately I had no time to register, it was a fresh copy (Murphy docet). But I can't believe there is no solution to this issue. Max -Original Message- From: Rick Root [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Date: Tue, 05 Sep 2006 22:21:41

Re: CFForm Integer Validation Allowing Commas

2006-09-06 Thread Teddy Payne
That was one hell of a rant. I started using Perl as my first web dynamic language back in college. That being said and for everyone who feels the pain of Perl, you will be in regex hell for your stay in Hotel Perl Mod. What I did get from Perl was the positive side of regex, I use regex to

restarting CF via the factory

2006-09-06 Thread D F
Was wondering if it was possible to restart Coldfusion ( and related services ) programmatically.. perhaps through the factory? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date

Re: Replying after the message

2006-09-06 Thread Jochem van Dieten
Robertson-Ravo, Neil (RX) wrote: An RFC for posting, lol. Looks like I will have to scroll for more, and more, and more:-) That isn't very convincing from somebody with a 15 line signature. Jochem ~| Introducing the

RE: restarting CF via the factory

2006-09-06 Thread Snake
Create a batch file to stop then start the services, and call it via cfexecute. You will need to add a wait command between the stop and start as cf can take a few minutes to stop sometimes. Russ -Original Message- From: D F [mailto:[EMAIL PROTECTED] Sent: 06 September 2006 12:56 To:

RE: Coldfusion serial number lost

2006-09-06 Thread Snake
The serial is also on the box and the card that came inside the box. If you have lost ALL of these, then your stuffed, as you have no proof you ever owned it. Russ -Original Message- From: Massimo Gianadda [mailto:[EMAIL PROTECTED] Sent: 06 September 2006 12:12 To: CF-Talk Subject: Re:

Re: restarting CF via the factory

2006-09-06 Thread D F
unfortunatley cannot do this ( already thought of that ) with present server configuration. Either through Bat. or .wsh/vbs/js etc... permissions issue with managed server. Create a batch file to stop then start the services, and call it via cfexecute. You will need to add a wait command

RE: Replying after the message

2006-09-06 Thread Robertson-Ravo, Neil (RX)
LOL, yeah well corporate rules, and besides the sig is at the end ;-p -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: 06 September 2006 13:01 To: CF-Talk Subject: Re: Replying after the message Robertson-Ravo, Neil (RX) wrote: An RFC for posting,

RE: OT: can you resolve this domain?

2006-09-06 Thread Snake
Works from the UK.. -Original Message- From: Arden Weiss [mailto:[EMAIL PROTECTED] Sent: 06 September 2006 04:27 To: CF-Talk Subject: Re: OT: can you resolve this domain? Hey all, We are having some dns issues where some ISP's can resolve our domain and some can't. Something about

Re: restarting CF via the factory

2006-09-06 Thread Teddy Payne
Use ColdFusion to create the text you need to create the batch file. Use cffile to create a file, add the text for commands you need and then change the file extension to .bat or whatever. I doubt the server manager locked down creation of new files in your working web directory. Teddy On

Re: Replying after the message

2006-09-06 Thread Jochem van Dieten
Robertson-Ravo, Neil (RX) wrote: LOL, yeah well corporate rules That's why I don't post from a corporate address: I think it is unprofessional to bombard readers with all that junk. It is a one-time setup issue for me vs. a recurring reading experience for everybody on the list. Jochem

RE: Cross-Server Joins

2006-09-06 Thread Gaulin, Mark
Check out the OPENROWSET function in T-SQL: OPENROWSET Includes all connection information necessary to access remote data from an OLE DB data source. This method is an alternative to accessing tables in a linked server and is a one-time, ad hoc method of connecting and accessing remote data

Re: OT: can you resolve this domain?

2006-09-06 Thread Claude Schneegans
No, @ videotron.ca serving mostly the province of Quebec. Works today. May be it was just a question of letting all DNS in the world to update. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any

Digest mode list problems

2006-09-06 Thread Earl, George
I'm having all kinds of issues with my cf-talk and cf-community digests. Are those of you who get the single message feed having problems too? George ~| Introducing the Fusion Authority Quarterly Update. 80 pages of

RE: I am soooo pissed

2006-09-06 Thread Andy Matthews
Not if the domain was already hosted at Netsol. !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent:

RE: Cross-Server Joins

2006-09-06 Thread Andy Matthews
Using mySQL it's possible (as long as the user you're logged in as has permissions on both tables. Simply prepend the tablename with the database name like so: SELECT d1t1.id, d2t2.id FROM database1.table1 AS d1t1 INNER JOIN database2.table2 AS d2t2 ON d1t1.id = d2.t2.id

CFOpenChat 0.97b Released

2006-09-06 Thread Rick Root
A lot of progress has been made in the last week with regards to the reliability of CFOpenChat. It handles temporary connection failures much better now, and will hopefully no longer just randomly decide to boot everyone out of the chat room at will. CFOpenChat is a coldfusion powered chat

Re: Fusion Reactor issues

2006-09-06 Thread Rick Root
Maureen Barger wrote: Can you: -adjust your jvm memory settings so you have more available memory for CF? -adjust your FR settings so it doesn't kill threads, or at least allow more threads until it starts killing them off? Raise the level of the rivers, and the rocks won't be noticeable.

RE: Cross-Server Joins

2006-09-06 Thread Robertson-Ravo, Neil (RX)
I think he sorted it, that will work for the same DB instance/type but for X-Server joins you will need to use Linked Servers. -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: 06 September 2006 14:19 To: CF-Talk Subject: RE: Cross-Server Joins Using mySQL it's

RE: Cross-Server Joins

2006-09-06 Thread Andy Matthews
Yah... Saw that. Never would have thought you could do a join between two diff databases. I guess you'd have to use ANSI standard functions eh? !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737

RE: Cross-Server Joins

2006-09-06 Thread Brad Wood
However James Ive never actually done what your requesting myself, if it works I'd love to know heh ;) I have used cross server joins before on MSSQL 2000 servers and the performance was so bad I had to take it out. I eventually had to call a proc on the second server to gather data, and then

Re: Peg = Margaret name matching code

2006-09-06 Thread Mike Chabot
I think using a database table, like Pete suggested, is a decent solution. The issues I was hoping to avoid were the tedious data entry, quality assurance testing, and keeping it updated. That is why I was hoping for something open-source or a professional product. There are products that do this

RE: CFOpenChat 0.97b Released

2006-09-06 Thread Paul Vernon
http://www.opensourcecf.com/cfopenchat/ CFOpenChat is free, open source software licensed under the BSD license. Very nice, liked it a lot :) Paul ~| Introducing the Fusion Authority Quarterly Update. 80 pages of

RE: Selenium Testing with CF (?)

2006-09-06 Thread Leon Oosterwijk
Michael, We use Selenium in-house for our testing. It has saved us a lot of time and is a great tool. Highly Reccomended. We plan to wire up a bunch of selenium test cases to run at night on our HEAD code branch. Leon -Original Message- From: Michael E. Carluen [mailto:[EMAIL

RE: can you resolve this domain?

2006-09-06 Thread Kevin Aebig
Works today. !k -Original Message- From: Kevin Aebig [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 05, 2006 4:00 PM To: CF-Talk Subject: RE: can you resolve this domain? No - Sasktel / BigPipe (Canuck ISP) !k -Original Message- From: Bryan Stevenson [mailto:[EMAIL

RE: Cross-Server Joins

2006-09-06 Thread James Smith
OK, sorted. I used the previously mentioned tequnique but changed the connection string to... DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=intranet;UID=;PWD=;OPTION=3 And used the MyODBC 3.51.12 driver, 3.51.11 or earlier didn't work (I was on 11). I now have CF joining

Password access for PDF files

2006-09-06 Thread Andy Matthews
I'm working on a simple access for PDF files and HTML page on my client's website. There's nothing sensitive about them, they just want to start collecting user info. So my thought is to have an intermediate page which checks to see if the user is logged in; stores info about the view in the

Re: Password access for PDF files

2006-09-06 Thread Tom King
Add an Isapi rewrite to redirect all .pdfs to a page like library.cfm? file=filename.ext Then you can log the filename and any other info in a database, and then serve the file via CFHEADER.? T On 6 Sep 2006, at 16:26, Andy Matthews wrote: I'm working on a simple access for PDF files and

RE: Password access for PDF files

2006-09-06 Thread Andy Matthews
Right. I'm planning on some system setups to make sure that people can't link directly to the file. How would this work though with alternate file types? For example, all but 3 or 4 of my newsletters are PDF. The other 3 or 4 are plain Coldfusion pages. !//-- andy matthews web

Re: Password access for PDF files

2006-09-06 Thread Tom King
The ISAPI rewrite would catch ALL instances of .pdf or whatever you script it to: So , www.domain.com/test.pdf would be caught, rewritten to: www.domain.com/library/downloads.cfm?file=test.pdf The file string could then be parsed, checked in a databse, and then served if approved.

Multiserver instances and web server configuration

2006-09-06 Thread Rick Root
Can I configure IIS and coldfusion (in multiserver mode) such that a specific *PART* (read: directory) within a single web site uses a DIFFERENT instance of Coldfusion than the rest of the web site? thanks. rick ~|

RE: Multiserver instances and web server configuration

2006-09-06 Thread Dave Watts
Can I configure IIS and coldfusion (in multiserver mode) such that a specific *PART* (read: directory) within a single web site uses a DIFFERENT instance of Coldfusion than the rest of the web site? Yes. Each CF server will require a unique context root. By default, CF's context root is /.

Re: Multiserver instances and web server configuration

2006-09-06 Thread Rob Wilkerson
No. ColdFusion instances are tied to the web server and, as a result, to the site itself. I don't know any any way to take this to a more granular level. On 9/6/06, Rick Root [EMAIL PROTECTED] wrote: Can I configure IIS and coldfusion (in multiserver mode) such that a specific *PART* (read:

RE: Multiserver instances and web server configuration

2006-09-06 Thread Mark A Kruger
Dave and Rick, If you guys can figure out how to do this I'd love to know - it would make a nice blog entry :) I did not know this was possible in IIS - I always used different site roots instead (www1, www2 ... Etc). -mark -Original Message- From: Dave Watts [mailto:[EMAIL

SOT: IIS 6 Virtual Directories

2006-09-06 Thread Rick Root
Is there a way to configure a virtual directory in IIS that automatically applies to *ALL* web sites? There must be, because when you install coldfusion, cfdocs and cfide are automatically added the new web sites created in IIS (if coldfusion is configured standalone). I'm not sure how it's

Re: Multiserver instances and web server configuration

2006-09-06 Thread Rob Wilkerson
Dave - Do I understand correctly, then, that ColdFusion will allow you to tie multiple CF Servers to a single virtual host using the wsconfig utility? On 9/6/06, Dave Watts [EMAIL PROTECTED] wrote: Can I configure IIS and coldfusion (in multiserver mode) such that a specific *PART* (read:

RE: Multiserver instances and web server configuration

2006-09-06 Thread Dave Watts
Do I understand correctly, then, that ColdFusion will allow you to tie multiple CF Servers to a single virtual host using the wsconfig utility? If they have different context roots, yes, I think so. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the

Re: OT: can you resolve this domain?

2006-09-06 Thread Josh Nathanson
All, thanks for trying my domain. Turns out it was a Plesk 8/Red Hat Linux issue causing the nameserver to crash which has now been rectified. If anyone is running that configuration this link describes the issue.

Re: Multiserver instances and web server configuration

2006-09-06 Thread Rob Wilkerson
Wow. I guess it just seemed so counterintuitive (maybe my intuition is faulty) that I never tried to do that. Or maybe I just never had a business case. :-) I agree with Mark, though, that this would be good blog-fodder. On 9/6/06, Dave Watts [EMAIL PROTECTED] wrote: Do I understand

Re: SOT: IIS 6 Virtual Directories

2006-09-06 Thread Robertson-Ravo, Neil (RX)
Probably several ways. I remember using cfx_IIS for this kind of thing. You probably also have the ability to use the .vbs admin files in the wwwroot. You could also roll your own using a VB app. Jeez, there may even be interfaces for this in IIS 6 which are new since 5. This e-mail is

Re: Multiserver instances and web server configuration

2006-09-06 Thread Rick Root
Rob Wilkerson wrote: Wow. I guess it just seemed so counterintuitive (maybe my intuition is faulty) that I never tried to do that. Or maybe I just never had a business case. :-) I agree with Mark, though, that this would be good blog-fodder. Well there's definately no way to do it in the

Re: SOT: IIS 6 Virtual Directories

2006-09-06 Thread Rick Root
Robertson-Ravo, Neil (RX) wrote: Probably several ways. I remember using cfx_IIS for this kind of thing. You probably also have the ability to use the .vbs admin files in the wwwroot. You could also roll your own using a VB app. Jeez, there may even be interfaces for this in IIS 6 which are

RE: Password access for PDF files

2006-09-06 Thread Bobby Hartsfield
First store the files you want to 'lock' outside of the webroot so no one is going to guess a link to them or share it once they have downloaded it. Next, write a form that asks for all the information you want to store in the database. When the form is submitted, validate your fields and then

Re: SOT: IIS 6 Virtual Directories

2006-09-06 Thread Robertson-Ravo, Neil (RX)
Check out what you can do via COM as well (if anything) This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may

RE: Password access for PDF files

2006-09-06 Thread Bobby Hartsfield
Oops... That will force the user to download the file not open it in their browser. ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 06, 2006 12:39 PM To: CF-Talk

Re: SOT: IIS 6 Virtual Directories

2006-09-06 Thread Rick Root
iisvdir.vbs doesn't do exactly what I want but at least I can copy/paste... anything is easier than creating 24 virtual directories via point and click! Rick ~| Introducing the Fusion Authority Quarterly Update. 80 pages of

RE: SOT: IIS 6 Virtual Directories

2006-09-06 Thread Dave Watts
iisvdir.vbs doesn't do exactly what I want but at least I can copy/paste... anything is easier than creating 24 virtual directories via point and click! This came up on the list a few days ago. I've written scripts to do this before; unfortunately, I don't have them available where I am now.

Re: SOT: IIS 6 Virtual Directories

2006-09-06 Thread Robertson-Ravo, Neil (RX)
You can certainly do this via cfx_IIS tag. Not sure what the support it like though for II6. This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains

RE: Password access for PDF files

2006-09-06 Thread Andy Matthews
I don't mind that actually. !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Wednesday,

Problems with instance manager

2006-09-06 Thread Rick Root
so i've installed CF7.0.2 in multiserver mode and I've logged into the CF Administrator. I am trying to create a new instance in the enterprise manager, and it keeps failing on step 3 [step 3 of 4] Deploying, this may take a few minutes... I get a request timeout error The request has

Re: restarting CF via the factory

2006-09-06 Thread D F
Well the problem is not file creation, the problem is not having admin access to the services to restart them. Hence why I was looking for a backdoor to restarting the CF server. ~| Introducing the Fusion Authority Quarterly

RE: Problems with instance manager

2006-09-06 Thread Dave Watts
so i've installed CF7.0.2 in multiserver mode and I've logged into the CF Administrator. I am trying to create a new instance in the enterprise manager, and it keeps failing on step 3 [step 3 of 4] Deploying, this may take a few minutes... I get a request timeout error The request

Re: Problems with instance manager

2006-09-06 Thread Rick Root
third try's a charm... I had to disable my on-access virus scanning.. that always slows stuff down. Rick Root wrote: so i've installed CF7.0.2 in multiserver mode and I've logged into the CF Administrator. I am trying to create a new instance in the enterprise manager, and it keeps

RE: Password access for PDF files

2006-09-06 Thread Bobby Hartsfield
Then it is most definitely the way I'd go. Give a shout if you have any trouble with it. ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 06, 2006 1:02 PM To: CF-Talk Subject:

RE: Problems with instance manager

2006-09-06 Thread Snake
Have u checked the jrun logs to see what they say. It shouldn't take that long, so something is obviously failing. Snake -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: 06 September 2006 18:38 To: CF-Talk Subject: Problems with instance manager so i've installed

Bulk data loading

2006-09-06 Thread Chris Tilley
Does anyone have a tested method of uploading bulk data to a database? I have a need (annually) for the admin person to be able to take data from an Excel spreadsheet and have it inserted into an Oracle database. Any sample code would be greatly appreciated. I've played with a CFC that makes

RE: Bulk data loading

2006-09-06 Thread Ray Champagne
This is something that the database should do, not CF. Not being an Oracle guy, I can't tell you what that is, but it has been discussed here recently. (Hint. :) ) Anyways, you're looking for whatever Oracle's equivalent is to MSSQL's DTS. That should at least get you on the right track. Ray

Re: Bulk data loading

2006-09-06 Thread Claude Schneegans
Does anyone have a tested method of uploading bulk data to a database? Just set a datasource using the Microsoft Excel ODBC driver and query in the data. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm

Re: Bulk data loading

2006-09-06 Thread Matt Robertson
You're talking about a CSV right? What amounts to a simple list, but with zillions of rows? The trick I found to getting this done (which the good folks here helped with enormously) is to use java to read each line incrementally rather than having cffile try to scarf down the whole file into

RE: Bulk data loading

2006-09-06 Thread Ray Champagne
Well, yea, I guess, depending on the size of this spreadsheet, this would work just as well. Chris, how large is this Excel sheet? -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 06, 2006 2:31 PM To: CF-Talk Subject: Re: Bulk data

Re: Bulk data loading

2006-09-06 Thread Rick Root
Matt Robertson wrote: You're talking about a CSV right? What amounts to a simple list, but with zillions of rows? The trick I found to getting this done (which the good folks here helped with enormously) is to use java to read each line incrementally rather than having cffile try to scarf

Re: Bulk data loading

2006-09-06 Thread Rick Root
Rick Root wrote: I blogged the method at www.opensourcecf.com =) specifically... http://www.opensourcecf.com/1/2006/07/Reading-large-files-with-java-versus-CFFILE.cfm ~| Introducing the Fusion Authority Quarterly Update. 80

Re: Bulk data loading

2006-09-06 Thread Craig Drabik
Does anyone have a tested method of uploading bulk data to a database? I have a need (annually) for the admin person to be able to take data from an Excel spreadsheet and have it inserted into an Oracle database. Any sample code would be greatly appreciated. I've played with a CFC that makes

Re: Bulk data loading

2006-09-06 Thread Chris Tilley
Ray, Approx. 145kb, 1000 rows with 16 columns Matt, I'd love to see your sample code, if you don't mind sharing? Chris On 9/6/06, Ray Champagne [EMAIL PROTECTED] wrote: Well, yea, I guess, depending on the size of this spreadsheet, this would work just as well. Chris, how large is this

dynamic related select box

2006-09-06 Thread Ali Majdzadeh
Hi everybody: I need a solution for dynamic related select box. For example when the user selects the state in the other select box all the cities of the selected state appear. Do you any free/easy way to do that. I use coldfusion/ms access. Thanks Benign

Re: dynamic related select box

2006-09-06 Thread Jake Churchill
CFAjax Ali Majdzadeh wrote: Hi everybody: I need a solution for dynamic related select box. For example when the user selects the state in the other select box all the cities of the selected state appear. Do you any free/easy way to do that. I use coldfusion/ms access. Thanks Benign

Re: Bulk data loading

2006-09-06 Thread Joseph Lamoree
On 6 Sep 2006, at 11:19, Chris Tilley wrote: Does anyone have a tested method of uploading bulk data to a database? I have a need (annually) for the admin person to be able to take data from an Excel spreadsheet and have it inserted into an Oracle database. Any sample code would be

Re: Bulk data loading

2006-09-06 Thread Chris Tilley
I've tried it but getting an error message: 12:52:15.015 - Expression Exception - in D:\Inetpub\cf\WorkingCapitalFund\FileReader.cfc : line 65 Variable RETURNSTRING is undefined. Any ideas why? On 9/6/06, Rick Root [EMAIL PROTECTED] wrote: Rick Root wrote: I blogged the

Re: dynamic related select box

2006-09-06 Thread Larry Lyons
Hi everybody: I need a solution for dynamic related select box. For example when the user selects the state in the other select box all the cities of the selected state appear. Do you any free/easy way to do that. I use coldfusion/ms access. Thanks Benign The most commonly used CF

Re: Bulk data loading

2006-09-06 Thread Rick Root
Chris Tilley wrote: I've tried it but getting an error message: 12:52:15.015 - Expression Exception - in D:\Inetpub\cf\WorkingCapitalFund\FileReader.cfc : line 65 Variable RETURNSTRING is undefined. Any ideas why? Your cfc is referencing a variable that isn't defined? I don't

Re: Bulk data loading

2006-09-06 Thread Rick Root
Joseph Lamoree wrote: You'll probably get the best performance using the Oracle SQL*Plus tools, specifically SQL*Loader: http://www.orafaq.com/faq/sql_loader You are probably right - but for 1000 records, 145KB of data, and it only occurs once per year (I think that's what he said), it's

Application CFC and the URL.

2006-09-06 Thread Ian Skinner
Which events in the application.cfc framework, if any, would have access to URL variables? In more specific terms, if I wanted to have an application.cfc function called based on the existence and|or value of a url variable, how could I do this? -- Ian Skinner Web Programmer

RE: Application CFC and the URL.

2006-09-06 Thread Ben Nadel
I use the CGI and URL values in my OnApplicationStart() method with no problems ( I think ). Although an also initialize outside of on applicationStart method... So not sure. All I know is the site works. ... Ben Nadel www.bennadel.com Certified Advanced ColdFusion Developer

Re: Bulk data loading

2006-09-06 Thread Joseph Lamoree
On 6 Sep 2006, at 12:45, Rick Root wrote: You are probably right - but for 1000 records, 145KB of data, and it only occurs once per year (I think that's what he said), it's probably not worth the effort. True. I thought we were talking about a jazillion rows. I have a similar requirement for

Upload File first within a form, retain form values

2006-09-06 Thread coldfusion . developer
I've never done a upload funtion/submit process as a subset process from within another parent form. Any CF custom tags do this or any direction would be great. I have a form with name, company name, etc. and within the form I have an upload file form field with an upload file only submit

Re: Application CFC and the URL.

2006-09-06 Thread Matt Williams
Depends on when you want the code to execute. If it is a URL variable, you probably want it onRequestStart. On 9/6/06, Ben Nadel [EMAIL PROTECTED] wrote: I use the CGI and URL values in my OnApplicationStart() method with no problems ( I think ). Although an also initialize outside of on

RE: Bulk data loading

2006-09-06 Thread Ben Nadel
Sorry to come in late in the convo... If you can put the file in a public directory, I have found from some simple testing that CFHttp is faster than a buffered file reader... http://bennadel.com/blog/200-ColdFusion-CFHttp-To-Query-Much-Faster-Than-Jav a-Buffered-Reader.htm DISCLAIMER: I am a

Re: CFEclipse - FTP???

2006-09-06 Thread Denny Valliant
I posted a semi-walkthrough to the list for using Eclipse's FTP stuff, that is also an option (and I prefer it to working directly on the server). Search the archives for elcipse ftp and it should pop up. To repeat, it's geared towards working locally and uploading changed files when you're

Re: passing arguments into a instantiated java object

2006-09-06 Thread Dan Plesse
For some reason they both can't handle interfaces very well. No one bothered to use the forName() method. O well So I wrote a small interface viewer. Take that rabbit! So now I know resultSet has 139 methods. On 9/6/06, James Holmes [EMAIL PROTECTED] wrote: The Object Viewer gives [empty

Google maps and Ajax

2006-09-06 Thread Robert Walters
Are there any tools out there to help me connect google maps with my database of locations? I have about 20,000 locations I need to show on the map. I am guess I need Ajax which I have done none of. Any tools to help me would be appreciated. ThanksRob

RE: dynamic related select box

2006-09-06 Thread Bobby Hartsfield
I like to write my own related selects but look for CF_TwoSelectsRelated by Nate Weiss (there are also others that will relate more than 2 selects) ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Ali Majdzadeh [mailto:[EMAIL PROTECTED]

Job Board Application

2006-09-06 Thread Jim Louis
I need a job board application with Resume search ability and the ability in the future to possibly charge employers to post jobs. So we need user and employer accounts. If someone can recommend a good option that would be great. I am looking to buy something not an ASP. Vendor welcome to

Re: dynamic related select box

2006-09-06 Thread Doug Brown
Here is one you could use. It is not a custom tag, but not near as difficult to format your html around it either. Just modify your queries etc... cfif isDefined('form.select_Main_Group') cfset page.select_Main_Group = form.select_Main_Group /cfif cfoutput form name=DropDown method=post

Re: Google maps and Ajax

2006-09-06 Thread Rey Bango
Robert, I've become a big fan of JQuery (www.jquery.com) because of its great syntax and good documentation. They also have a demo that integrates with Google Maps which you can find here: http://olbertz.de/jquery/googlemap.html Unfortunately, its not an official demo so you will have to

RE: Application CFC and the URL.

2006-09-06 Thread Dave Watts
Which events in the application.cfc framework, if any, would have access to URL variables? I would guess: onRequestStart, onRequestEnd, and onRequest. In more specific terms, if I wanted to have an application.cfc function called based on the existence and|or value of a url variable, how

  1   2   >