Re: Cold Fusion and Oracle Unsupported Data Conversion

I think that script is refering to the dataDirect drivers, not actual Oracle drivers. Although I could be wrong, the dataDirect drivers are around version 3.x whereas Oracle drivers follow version of the database (ie 9.2, 10.1) they correspond to. -Adam - Original Message - From: Dave

Database keeps killing our MX Servers

We're having a recurring problem where our MX server keeps hanging. We have a datasource for an SQL database. Two seperate MX servers have datasource connections to this same database. Periodically, the SQL server will start blocking all requests. (This is something else that we are looking

Re: Database keeps killing our MX Servers

Well I can speak from experience that the timeouts you can define on CF's side (datasource, page request, tread) will do nothing if CF is waiting for a database response. CF will just wait forever. -Adam - Original Message - From: Stacey Robertson [EMAIL PROTECTED] Date: Fri, 3 Sep 2004

CFHTTP, Struts and some other stuff...

I apologize in advance if my question isn't detailed.I confess I'm not too familiar with an application I inherited but still must troubleshoot. I have an app written in a combo of CF (CFMX 6.1 on Win2000, IIS) and Java using struts.Most of the work is being done in Java with CF doing the

CFTree and Hyperlink colors

Hello, I think I'm having a brain fart or something, because I can't seem to change the hyperlink colors in my CFTree objects? Thanks, - Charles [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Forcing CF to send a request back to Apache?

Okay, this is complicated, and I apologize for that. First of all, our website runs a mix of Cold Fusion and Perl scripts. This is generally fine, except that Perl scripts don't run if the context-root in included in the path to the script. Is there a way to force the Cold Fusion server to

Re: request scope and grouped output

Hi All, I have a table that I would like to replicate each time the output loops through, based on grouping. However, within the table there are outputs that call to the request scope variables. That in turn throws an error as the request scope variables aren't a part of the grouped

RE: Database keeps killing our MX Servers

What drivers are you using? We have had success with the Microsoft JDBC drivers for SQL Server 2000. HTH Donnie Bachan Phone: (718) 217-2883 ICQ#: 28006783 Nitendo Vinces - By Striving You Shall Conquer [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: Forcing CF to send a request back to Apache?

You can't make CF do it, but you can certainly do that with mod_rewrite.These two rules should be pretty close, though they might not be perfect.(obviously assume your server has mod_rewrite enabled): RewriteEngine On RewriteRule ^/cfmx(.*\.pl)$ /$1.pl [L] The rewrite phase of Apache's request

Create/Manager CF Verity from Java?

I'm helping with a project that is having the majority of the backend done in Java.The end goal is that Java will run nightly and build reports and write files and all the other stuff it needs to do then CF will use verity to index the files and such that are created so users can search for stuff

Re: Database keeps killing our MX Servers

DataDirect3.3 from MM for Oracle. -Adam - Original Message - From: Donnie Bachan [EMAIL PROTECTED] Date: Fri, 03 Sep 2004 16:38:59 -0400 Subject: RE: Database keeps killing our MX Servers To: CF-Talk [EMAIL PROTECTED] What drivers are you using? We have had success with the Microsoft

Parse an uploaded excel spreadsheet?

We have an interesting user requirement to be able to download an excel spreadsheet from one of our systems (a simple data grid-type sheet), make changes to the xls, and upload it back to the web server to have the records automatically added/updated/deleted in one operation. I can envision the

RE: Forcing CF to send a request back to Apache?

Is there a way to force the Cold Fusion server to send an HTTP request back to Apache?Thus, http://mysite.com/cfmx/perl/script.pl would become http://mysite.com/perl/script.pl As it is, if the context-root is included in the URL for the Perl script, the script doesn't run and the

Re: Parse an uploaded excel spreadsheet?

Create and ODBC connection to an excel file. So long as you save the file as the same name all the time it should work out ok. Adam On Fri, 03 Sep 2004 16:51:17 -0400, Mark Murphy [EMAIL PROTECTED] wrote: We have an interesting user requirement to be able to download an excel spreadsheet from

Unable to create Oracle DSN

I just installed a skeletal Oracle database on my development server and am able to connect to it with the Oracle Enterprise manager but am unable to create a working DSN using the instructions for using the Oracle thin client drivers in this technote:

Auto Sorting Problem

I know I've seen this on a list before but couldn't remember where.When displaying or using the cfquery.columnList variable, the columns are automatically sorted in alphanumeric order.Is there any way to retrieve the columnlist in the order it was returned by SQL-Server -- which is the order as it

Re: Auto Sorting Problem

Nope sure isn't, and believe me, you don't want to be able to.Doing so creates a dependancy on the order of the columns in your database and/or SQL statement (depending on if you use SELECT * or not), which is almost guarenteed to cause problems down the road when you add/update/remove a column

Re: Parse an uploaded excel spreadsheet?

Hi If you can't do what you need to do using ODBC you could use Apache Jakarta POI (http://jakarta.apache.org/poi/index.html). You can interface to it using cfobject as it a Java API. As far as I know, with this API you can pretty much create a complete Excel sheet with multiple workbook, etc.

Fusebox

Hi Everyone. We are just about to start a major new project, well actually a complete upgrade from the ground up of an old project, but I have been looking at doing it in a much more structured way and I wanted some opinion about using Fusebox. We have never used it before, but we are all highly

Homesite Quickbar

I have somehow lost the quickbar on my HomeSite+ and now I cannot get it back even if I go to view quickbar. Do someone know how can I restore it? Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: Forcing CF to send a request back to Apache?

Barney Boisvert wrote: You can't make CF do it, but you can certainly do that with mod_rewrite.These two rules should be pretty close, though they might not be perfect.(obviously assume your server has mod_rewrite enabled): RewriteEngine On RewriteRule ^/cfmx(.*\.pl)$ /$1.pl [L] The

Re: Forcing CF to send a request back to Apache?

Whoops, my bad.I bet if you remove the / before the $1 it'll fix the double slash problem too.That's what I get for shooting that off the cuff on a Friday afternoon, immediately before a holiday weekend. Glad it worked enough to get you going though. cheers, barneyb On Fri, 03 Sep 2004 16:00:52

Forcing UserA logout if second user login with same username.

Hey all, I have this dilemma. Real Life situation, you sell 'seats' for an application to a company. You want to limit the number of times that company logs into the system with any given username...one user can log into the system just once. If UserA logs into the system with Username:

Re: Create/Manager CF Verity from Java?

John, Another option would be to use Lucene which is written in java instead of verity.In fact that's the search engine used by Blue Dragon. Details here: http://jakarta.apache.org/lucene/docs/index.html The speed is comparable and Lucene has a few neat features that aren't *yet* in CF and

Re: Forcing UserA logout if second user login with same username.

In your user table, add a new field named sessionID.When a user logs in, set their record's sessionID field to their current sessionID.In Application.cfm, pull the sessionID out of the database for the logged-in user and compare it to the current session's sessionID.If they match, great.If they

Re: Forcing UserA logout if second user login with same username.

Hi Barney, Ok...lemme see if I have the Pseudocode right for this. 1. UserA logs in with username. 2. Sets session.loggedin = True, session.userid, session.username 3. Also updates the tblusers table where tblusers.username = username with values tblusers.session = #session.sessionid# 4.

RE: Parse an uploaded excel spreadsheet?

I create a textarea, and allow the user to cut and paste from Excel any update. the cut and paste is [tab] delimited text - which easy to parse and process. One case I use it to just add new data, in another I use this approach to create or update pricing and inventory totals nightly. Eric

Re: Forcing UserA logout if second user login with same username.

You got it spot-on.Don't cache the query though, or it'll let multiple users on until it refreshes, and you don't want that.You can use userID (assuming you're storing that in the session scope as well), which will speed it up, because that's presumably the primary key, and consequently the

RE: Homesite Quickbar

How about deleting your toolsbars under the UserdData folder within the Homesite folder? From: Qasim Rasheed [mailto:[EMAIL PROTECTED] Sent: Friday, September 03, 2004 5:52 PM To: CF-Talk Subject: Homesite Quickbar I have somehow lost the quickbar on my

SOT: Nix shell script to test if CF is running on port xxxx

I know I have seen this done somewhere! I want to write a 'Nix shell script to see if a cf server instance is running (accepting requests) an a given port - say 8101 This is for OS X but should work on any 'Nix flavor. Any help would be greatly appreciated TIA Dick [Todays Threads] [This

SQLException

I have my CF and MSSQL services off by default. I run a .bat to start them up. However now none of my SQL datasources work. I get thison all of them. Connection verification failed for data source: j_wilkersql []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect,

Re: Fusebox

What I'm really looking for is some explaining of why it is better to use the Fusebox method than just straight forward CF. Also, can anyone point me in the direction of a good online introduction to Fusebox as there doesn't seem to be much on the Fusebox website. The same reasons any

Re: Fusebox

Hey Andrew, I can't believe no one has responded to this.Its typically the flame-bait that starts long threads on this list. I have been developing fusebox apps for about 3 years.Started with fb3, and once I switched companies in december and had access to cfmx, immediatly switched to fb4. Have

Re: Homesite Quickbar

Micheal Thanks for responding. By deleting you mean delete the whole folder? - Original Message - From: Dawson, Michael [EMAIL PROTECTED] Date: Fri, 3 Sep 2004 19:40:34 -0500 Subject: RE: Homesite Quickbar To: CF-Talk [EMAIL PROTECTED] How about deleting your toolsbars under the

<    1   2