SOT: directory protection

2010-02-12 Thread Scott Mulholland
We have an app with a protected area that just using a basic session check in application.cfm. In the protected area there is a directory of PDFs. No one can access them through the app without logging in. If the person knew the url to the pdf though it would serve since application.cfm would

(ot) Protecting Files

2009-07-28 Thread Scott Mulholland
I imagine this is a common issue : Let's say you have bunch of PDFs in a directory: /pdfs and the links to the files in the site are behind a login so non-registered users cannot access them. If a users knew the link to the file: http://www.mysite.com/pdfs/sample.pdf they could still get to

RE: (ot) Hacked by Fatal Error

2009-05-28 Thread Scott Mulholland
It's a demo server we use to show clients works in progress, its behind our firewall but is open on 80 for this purpose. -Original Message- From: Tom Chiverton [mailto:tom.chiver...@halliwells.com] Sent: Thursday, May 28, 2009 4:24 AM To: cf-talk Subject: Re: (ot) Hacked by Fatal Error

RE: (ot) Hacked by Fatal Error

2009-05-28 Thread Scott Mulholland
[mailto:bayous...@gmail.com] Sent: Thursday, May 28, 2009 10:12 AM To: cf-talk Subject: Re: (ot) Hacked by Fatal Error How difficult was your ftp user/password? -- Ryan On Thu, May 28, 2009 at 8:47 AM, Scott Mulholland smulholl...@aimg.comwrote: It's a demo server we use to show clients works

(ot) Hacked by Fatal Error

2009-05-27 Thread Scott Mulholland
Has anyone seen this or had this occur - Basically they replace the default docs in the wwwroot (index.htm, html, asp, default.htm, html, asp, etc.) with a file with only html and css in it that shows a picture of Homer Simpson and the massage Hacked By Fatal Error and something along the lines

RE: (ot) Hacked by Fatal Error

2009-05-27 Thread Scott Mulholland
Yeah, that is my concern. While nothing seems to be done to the server except the defacing I want to make sure whoever got in this time can't get back in. The server had a couple of win2k security updates waiting to be applied that were applied after the fact. Yeah im figuring its IIS as well.

(ot) AIR question

2009-02-23 Thread Scott Mulholland
Looked at the air list and it doesn't seem to get much in the way of posts so I figured I would throw it out here. I am just getting started with AIR and wanted to see anyone's thoughts on which road to go down in regards to air for the following. I wanted to make a simple app that would

RE: Strange Datasource error

2009-02-05 Thread Scott Mulholland
behavior was changed there - As I understand it, CF will use the default transaction settings (eg dirty read, committed read ...) 2009/1/28 Scott Mulholland smulholl...@aimg.com Out of nowhere today I had two different applications that utilize the same datasource begin throwing the error

Strange Datasource error

2009-01-27 Thread Scott Mulholland
Out of nowhere today I had two different applications that utilize the same datasource begin throwing the error: Data source DATASOURCENAME verification failed. The root cause was that: java.sql.SQLException: Datasource names for all the database tags within CFTRANSACTION must be the same.

RE: Datasource Issue - CF7

2008-07-02 Thread Scott Mulholland
Yeah, both are running. -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 02, 2008 3:00 AM To: CF-Talk Subject: Re: Datasource Issue - CF7 Scott Mulholland wrote: We had a test server recently run low on space and neo-query.xml became corrupt

Datasource Issue - CF7

2008-07-01 Thread Scott Mulholland
We had a test server recently run low on space and neo-query.xml became corrupt. We replaced it with a backup but since them any Access datasources and ODBC Socket datasources always say they are not found. If we try to update them in the cf admin we get: TCP/IP error, connection refused.

RE: cfhttp stopped working, anyone experienced this

2008-04-17 Thread Scott Mulholland
this are you happy with the URL being used, if it is being generated dynamically it may be malformed or incorrect. Is it in a cf try? Also, try dumping CFHTTP after the call - it will have a status code and other info that my help On Wed, Apr 16, 2008 at 9:03 PM, Scott Mulholland [EMAIL PROTECTED] wrote

iMIS Coldfusion integration

2008-04-17 Thread Scott Mulholland
Anyone out there worked with iMIS IBO's and CF before? If so please contact me off list if you'd be willing to answer a few questions and possibly entertain a small integration project. Thanks, Scott ~| Adobe® ColdFusion®

RE: cfhttp stopped working, anyone experienced this

2008-04-16 Thread Scott Mulholland
, can you browse to the URL? Can you ping the domain? Have firewall settings changed? On Wed, Apr 16, 2008 at 7:05 AM, Scott Mulholland [EMAIL PROTECTED] wrote: I have a piece of code that has always worked that does a cfhttp to create a static file. The file it calls is on the same server

cfhttp stopped working, anyone experienced this

2008-04-15 Thread Scott Mulholland
I have a piece of code that has always worked that does a cfhttp to create a static file. The file it calls is on the same server/domain. Today the cfhttp just keeps timing out. cfhttp calls to other urls not on the server work without issue though. Anyone else experience anything like this?

Daylight Savings JVM question

2007-03-09 Thread Scott Mulholland
I was using the step by step guide found here: http://labs.fusionlink.com/katapult/index.cfm?page=articles/daylightsavings to update my JVM. The quick question*: Do you need to install the development tools option? What makes me unsure is the statement: **Remember the full SDK, the JRE

RE: Daylight Savings JVM question

2007-03-09 Thread Scott Mulholland
Thanks Damon. I had actually visited your blog this morning, among countless others, before posting. I could not seem to find any clarity on the two questions I had though. Thanks, Scott -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent:

OT: Everest E-Commerce Solution

2007-03-05 Thread Scott Mulholland
Does anyone out there have any experience in working with this? If so please contact me off list, I have a few questions regarding it. Thanks, Scott ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving

RE: Opening PDF issue

2006-10-18 Thread Scott Mulholland
Problem solved, turned out to be a dns caching issue on their network. -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 17, 2006 9:44 AM To: CF-Talk Subject: Re: Opening PDF issue On Tuesday 17 October 2006 13:40, Scott Mulholland wrote: Anyone

Opening PDF issue

2006-10-17 Thread Scott Mulholland
I have a page that has links to pdf files which open in a new window. Works fine for 6 users (all in different locations) but 2 users (in same location) can only open some of them. The ones that won't open give them the following error: HTTP Error 404.1 - File or directory not found: Web

Ortiz-Shamrock 3

2006-10-11 Thread Scott Mulholland
..looked pretty much like Ortiz-Shamrock 2 without complaints on the stoppage. Tito was just too strong for him I think. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion

RE: Ortiz-Shamrock 3

2006-10-11 Thread Scott Mulholland
Wrong list sorry :( Meant for community...i must be punch drunk. -Original Message- From: Scott Mulholland [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 11, 2006 8:40 AM To: CF-Talk Subject: Ortiz-Shamrock 3 ...looked pretty much like Ortiz-Shamrock 2 without complaints

RE: Odd Query issue

2006-07-26 Thread Scott Mulholland
. Ben Nadel www.bennadel.com -Original Message- From: Scott Mulholland [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 1:23 PM To: CF-Talk Subject: Odd Query issue I have a query today that stopped working with an invalid column error. The database did not change

RE: Odd Query issue

2006-07-26 Thread Scott Mulholland
return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Scott Mulholland [EMAIL PROTECTED

RE: Odd Query issue

2006-07-26 Thread Scott Mulholland
Yeah, its ms-sql, and yes, does seem silly that I hadn't done that yet ;) Query analyzer gave me the same result for the update but with a better error message, Invalid column job_id, Procedure jobs_UTrig. Looks like it's an issue with one of my relationships/constraints. Thanks, Scott

RE: Odd Query issue - SOLVED

2006-07-26 Thread Scott Mulholland
Thanks for all help all, turns out a trigger on the table was referencing the job_id field in a different table that was recently changed. All the queries work now. -Original Message- From: Brian Rinaldi [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 26, 2006 1:34 PM To: CF-Talk

Odd Query issue

2006-07-25 Thread Scott Mulholland
I have a query today that stopped working with an invalid column error. The database did not change. Select statements work on it but not updates. Select * from jobs where job_id = 1 - works fine Update jobs set status = 0 where job_id = 1 - results in Invalid column name 'job_id'.

RE: Odd Query issue

2006-07-25 Thread Scott Mulholland
Subject: Re: Odd Query issue Maybe someone changed your datasource configuration. -- Joseph Lamoree On 25 Jul 2006, at 10:22, Scott Mulholland wrote: I have a query today that stopped working with an invalid column error. The database did not change. Select statements work

SEO, CF and URLs oh my

2006-06-21 Thread Scott Mulholland
Looking for an answer or some thoughts on a theoretical question: Will a search engine respond more favorably in indexing a html file over a cfm file (keywords, content, etc aside)? For example would one of these urls jump out as being better in terms of SEO:

RE: SEO, CF and URLs oh my

2006-06-21 Thread Scott Mulholland
Bryan, Thanks for the input. We are doing the url rewriting currently, we were just wondering if that was enough in terms of the url/filename for the SEO side of things. Thanks, Scott -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 21, 2006 2:35

RE: ColdFusion and Model-Glue eseminar

2006-06-16 Thread Scott Mulholland
I know during it the icon in breeze was red showing the session was being recorded. The adobe site also says the sessions will be available in the future but nothing was said about it during the presentation. -Original Message- From: Nick Tong - TalkWebSolutions.co.uk [mailto:[EMAIL

RE: Mail Spool stopped sending

2006-03-20 Thread Scott Mulholland
-Original Message- From: Scott Mulholland [mailto:[EMAIL PROTECTED] Sent: Friday, March 17, 2006 4:15 PM To: CF-Talk Subject: Mail Spool stopped sending An application of ours just stopped sending mail today. We do not manage the server. The server was moved behind a firewall this morning

Mail Spool stopped sending

2006-03-17 Thread Scott Mulholland
An application of ours just stopped sending mail today. We do not manage the server. The server was moved behind a firewall this morning and mail had been sent after that without issue. It uses the local smtp setting to send and the connection verifies through the cfadmin. The mail.log

RE: Accessing Network Drives

2006-01-11 Thread Scott Mulholland
I would second this setup, we have used it in a few applications with great success. -Original Message- From: Justin D. Scott [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 11, 2006 9:48 AM To: CF-Talk Subject: RE: Accessing Network Drives 1) Is it possible to run CFFILE Exists on

RE: executing a DTS from coldfusion

2005-11-07 Thread Scott Mulholland
Russ, I have had great success running a DTS from CF in the past using the info in this article: http://www.pengoworks.com/index.cfm?action=articles:spExecuteDTS Scott -Original Message- From: Russ [mailto:[EMAIL PROTECTED] Sent: Monday, November 07, 2005 1:52 PM To: CF-Talk Subject:

SQL help

2005-10-18 Thread Scott Mulholland
I've recently inherited an access database that I am trying to do some reporting on. One of the tables has the following structure: Att_ID Type Values 410 ColorBlue 410 ColorOrange 410 ColorBlack 410 ColorOlive Drab (green) 410 Size

RE: Shopping Cart solution - any others to look at?

2005-10-11 Thread Scott Mulholland
and all is only $200 and it will give you, I bet, everything you need. I agree with the others that building your own cart is the way to go, but if time is an issue you can get x-cart up and running and loaded with products in just a couple of days. --Ferg Scott Mulholland wrote: Our plan

Shopping Cart solution - any others to look at?

2005-10-10 Thread Scott Mulholland
I'm currently evaluating some e-commerce solutions for an upcoming project. Past postings have pointed me to look at cartweaver, cfwebstore and ablecommerce. I have also looked at a couple of non-cf based solutions. Are there any others that I should be looking at or dos anyone have any

RE: Shopping Cart solution - any others to look at?

2005-10-10 Thread Scott Mulholland
Our plan is to roll our own out in the future, the creation of it is not a factor for us on this one, the timeframe is so we are looking to go off the shelf this time around. -Original Message- From: Larry Lyons [mailto:[EMAIL PROTECTED] Sent: Monday, October 10, 2005 10:04 AM To:

RE: Shopping Cart solution - any others to look at?

2005-10-10 Thread Scott Mulholland
at? One of the sample apps that came with CF is a shopping cart, why not use that as a base. -Original Message- From: Scott Mulholland [mailto:[EMAIL PROTECTED] Sent: 10 October 2005 22:13 To: CF-Talk Subject: RE: Shopping Cart solution - any others to look at? Our plan is to roll our own

Congressional Contact Info

2005-06-30 Thread Scott Mulholland
Anyone know of any existing public resources for congressional contact information (preferably email addresses)? Ideally some sort of feed or export. Thanks, Scott --- [This E-mail scanned for viruses by Declude Virus. Service provided by Accurate Imaging, Inc.]

CF linux questions

2005-06-22 Thread Scott Mulholland
I was involved in a discussion earlier today about the feasibility of building a control panel like solution to allow for users to maintain items like domains, emails, etc. (think cpanel) on the linux platform. Not being a linux person myself I was trying to find resources speaking to the

RE: CF linux questions

2005-06-22 Thread Scott Mulholland
-Original Message- From: Jordan Michaels [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 22, 2005 4:08 PM To: CF-Talk Subject: Re: CF linux questions Scott Mulholland wrote: I was involved in a discussion earlier today about the feasibility of building a control panel like solution to allow

UNC vs Mapped Drive

2005-06-13 Thread Scott Mulholland
Is there any difference in performance when accessing files on another server between these two methods? The access would be in terms of cffile and some zipping using a java based zip util. Thanks, Scott --- [This E-mail scanned for viruses by Declude Virus. Service provided by Accurate

Test

2005-05-13 Thread Scott Mulholland
Is the list up? --- [This E-mail scanned for viruses by Declude Virus. Service provided by Accurate Imaging, Inc.] ~| Find out how CFTicket can increase your company's customer support efficiency by 100%

RE: Cached query - Any way to tell when it was cached?

2005-05-11 Thread Scott Mulholland
Options are always appreciated! Thanks again. -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 11, 2005 10:03 AM To: CF-Talk Subject: RE: Cached query - Any way to tell when it was cached? I don't blame you. :) I'm just a big fan of options, so I

Cached query - Any way to tell when it was cached?

2005-05-10 Thread Scott Mulholland
Is there a way, possibly as easy as an undocumented query variable (query_name.CachedSince - one can dream no?), to return the timestamp of when a query was last cached? Was looking for an easy way to have a This report last generated on: X display an a page with a large recordset that we

RE: Mailserver verification failing

2005-05-10 Thread Scott Mulholland
Thanks Justin, that did it. The dns was flushed yesterday but it seems CF was not restarted. Restarted it and now it's fine. Scott -Original Message- From: Justin D. Scott [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 10, 2005 12:09 PM To: CF-Talk Subject: RE: Mailserver verification

Mailserver verification failing

2005-05-10 Thread Scott Mulholland
We recently moved our mailserver from one datacenter to another. Since the move the mailserver won't verify in the cf admin on our dev and production server when referenced by name (i.e. myserver.mydomain.com) but verifies fine by IP. We have dropped the firewall to test and it still fails,

RE: Cached query - Any way to tell when it was cached?

2005-05-10 Thread Scott Mulholland
I think Ian's may be the way to go. I am using cachedwithin as the data changes frequently so we cache it for 6 hours. I don't think cachedafter will work. -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 10, 2005 4:31 PM To: CF-Talk Subject: Re:

RE: Cached query - Any way to tell when it was cached?

2005-05-10 Thread Scott Mulholland
Yeah, for simplicities sake I'll go with the other one, heh. Thanks for the help guys. -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 10, 2005 7:19 PM To: CF-Talk Subject: RE: Cached query - Any way to tell when it was cached? I think Ian's may

Oracle thin driver in MX Standard

2005-04-06 Thread Scott Mulholland
Can the Oracle thin drivers be used to connect to Oracle Db's from MX Standard? I would imagine they could since the datasource type is other and not Oracle. If not are there other/better alternatives? I have an Oracle database I will need to connect to every so often from a test server that

RE: Oracle thin driver in MX Standard

2005-04-06 Thread Scott Mulholland
a bridge to the Oracle DB? -Original Message- From: Scott Mulholland [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 06, 2005 7:17 AM To: CF-Talk Subject: Oracle thin driver in MX Standard Can the Oracle thin drivers be used to connect to Oracle Db's from MX Standard? I would imagine

SQL delete statement question

2005-03-21 Thread Scott Mulholland
Is there an easy way to do a mass delete with 2 pieces of criteria in the where clause? With one clause we are just using a subquery i.e delete from contracts where accountno IN (select distinct accounts from cancels). I'm having trouble seeing a way to do in a sql statement if we needed to

RE: SQL delete statement question

2005-03-21 Thread Scott Mulholland
I might be having one actually...would that hold the pairings? I believe it would as contractno's are unique to the accountnoyep, think I'm having a Monday. Well, thanks for opening my eyes to the obvious ;) -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent:

OT: SQL licensing question

2005-03-17 Thread Scott Mulholland
I was asked this question today by someone who received conflicting answers on this and not knowing the answer I figured someone on here probably would: What is the general practice in terms of licensing SQL server for use in a web app? Is it the standard or the only option to go with the

RE: SQL licensing question

2005-03-17 Thread Scott Mulholland
Thanks Dave, I'll pass that along. Ironically they were told the opposite by whoever answered the phone at MS ;) -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, March 17, 2005 5:55 PM To: CF-Talk Subject: RE: SQL licensing question What is the general

Developer edition install question

2005-03-07 Thread Scott Mulholland
I have a new machine that has xp pro on it. I'm installing cf 6.1 dev and was wondering if there was any benefit to running it through IIS instead of the self contained web server you can install with mx? Does running cfmx on its own server and not IIS make it easier to also run a .net

RE: Developer edition install question

2005-03-07 Thread Scott Mulholland
Yeah, it runs on 8500 -Original Message- From: Connie DeCinko [mailto:[EMAIL PROTECTED] Sent: Monday, March 07, 2005 12:00 PM To: CF-Talk Subject: RE: Developer edition install question I believe you will also have to use an alternative port with the stand alone server, instead of port

RE: Developer edition install question

2005-03-07 Thread Scott Mulholland
, Fireworks, and CuteFTP all open at the same time. Gets nasty, actually. Sorry that got long, but it's not so simple a question. Laterz, J On Mon, 7 Mar 2005 11:21:57 -0500, Scott Mulholland [EMAIL PROTECTED] wrote: I have a new machine that has xp pro on it. I'm installing cf 6.1 dev

RE: Error Oddity

2005-02-23 Thread Scott Mulholland
No, win2000, cfmx6.1. -Original Message- From: Jehiah Czebotar [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 22, 2005 8:06 PM To: CF-Talk Subject: Re: Error Oddity for a template that does exist? are you running on a linux machine where filenames are case sensitive ? -- [EMAIL

Error Oddity

2005-02-22 Thread Scott Mulholland
Anyone encounter this error in the exception log: Error,jrpp-256,02/20/05,14:12:55,,File not found: etc... for a template that does exist? I noticed it in our logs this weekend. We apparently also had an issue where the cfmx service just stopped running, was trying to see if it could be

Closing Oracle Cursors

2005-01-27 Thread Scott Mulholland
I am connecting to a new database run by another company and have been experiencing an intermittent error: [Oracle]ORA-00604: error occurred at recursive SQL level 1 ORA-01000: maximum open cursors exceeded When I talked to the DBA's who maintain the database they told me: If your app is

RE: Closing Oracle Cursors

2005-01-27 Thread Scott Mulholland
Inline via cfquery -Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: Thursday, January 27, 2005 7:35 PM To: CF-Talk Subject: Re: Closing Oracle Cursors Are you executing stored procedures or inline via cfquery? -Adam On Thu, 27 Jan 2005 17:44:12 -0500, Scott

RE: cfcontent and Norton firewall?

2004-12-09 Thread Scott Mulholland
I think its your use of cgi.referer. I have seen cases of Norton Internet Security stripping that variable. -Original Message- From: Emmet McGovern [mailto:[EMAIL PROTECTED] Sent: Thursday, December 09, 2004 12:38 PM To: CF-Talk Subject: cfcontent and Norton firewall? I'm using

RE: sql LIKE question

2004-12-07 Thread Scott Mulholland
-Original Message- From: Scott Mulholland [mailto:[EMAIL PROTECTED] Sent: Monday, December 06, 2004 6:11 PM To: CF-Talk Subject: sql LIKE question Is there any way to force LIKE to match on leading zeros? If I have a query along the lines of: select accountkey from companies where

RE: sql LIKE question

2004-12-07 Thread Scott Mulholland
?? How is it defined? Pascal -Original Message- From: Scott Mulholland [mailto:[EMAIL PROTECTED] Sent: 07 December 2004 00:11 To: CF-Talk Subject: sql LIKE question Is there any way to force LIKE to match on leading zeros? If I have a query along the lines of: select

sql LIKE question

2004-12-06 Thread Scott Mulholland
Is there any way to force LIKE to match on leading zeros? If I have a query along the lines of: select accountkey from companies where accountno LIKE '%#searchString#%' and I search with a string of: 0059 I am getting results like: 05976574 12343459 59748311 It treats it as if I

cfftp/6.1

2004-11-24 Thread Scott Mulholland
Recently upgraded a dev box to 6.1 and now I am experiencing these types of errors: Diagnostics: An exception occurred when establishing a FTP connection. The cause of this exception was that: java.net.NoRouteToHostException: No route to host: connect. Diagnostics: An exception occurred when

RE: cfftp/6.1

2004-11-24 Thread Scott Mulholland
Turns out that I can. Looking further it seems the ftp server sent back a confirmation from their IP but not on port 21 so the firewall deemed it an attack and blocked traffic from them so our connections were dropping. Thanks. -Original Message- From: Dave Watts [mailto:[EMAIL

Database design question

2004-11-19 Thread Scott Mulholland
In theory is there any downside to joining cross database. I'm using sql server and was considering having my user data in one database and my content data in an other. In some cases I would need to do something like this as an example: 2 databases (MS SQL Server for arguments sake): USERS and

Blank Screen - Anyone else experience this

2004-11-19 Thread Scott Mulholland
We have an application running on CFMX, SQL Server 2000, all MS Windows 2000 boxes. A few times (3 times in 1.5 yrs actually) we have experienced the application just randomly returning a blank white screen to the browser intermittently. It starts with one page, then others start coming back the

RE: Database design question

2004-11-19 Thread Scott Mulholland
:-) On Fri, 19 Nov 2004 10:02:45 -0500, Scott Mulholland [EMAIL PROTECTED] wrote: In theory is there any downside to joining cross database. I'm using sql server and was considering having my user data in one database and my content data in an other. In some cases I would need to do

RE: Database design question

2004-11-19 Thread Scott Mulholland
, 19 Nov 2004 10:38:27 -0500, Scott Mulholland [EMAIL PROTECTED] wrote: Well some user data would be stored in session vars, like the account_id and such, but my example was more along the lines of if you wanted to pull a list of articles to display the article and name of the person who

Scheduler running 1 hr early since daylight savings?

2004-11-05 Thread Scott Mulholland
Anyone else have this issue: This task is set to execute at 6:15 each morning but as shown by the log when the clocks went back the scheduler seems to have gone back an hour with it?? The time still shows 6:15 in the scheduler but it has been running at 5:15 all this week.

RE: Oracle stored procedure returning a cursor

2004-10-20 Thread Scott Mulholland
Make sure your driver is DataDirect 3.3...I was using 3.1 and it would not work, upgraded them and everything was fine. -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 20, 2004 10:58 AM To: CF-Talk Subject: RE: Oracle stored procedure returning a

RE: Reliable SEO company recommendations?

2004-09-23 Thread Scott Mulholland
Rachel, The company I work for offers this, would it be ok to contact you off list? Thanks, Scott -Original Message- From: Rachel Maxim [mailto:[EMAIL PROTECTED] Sent: Thursday, September 23, 2004 8:37 AM To: CF-Talk Subject: OT: Reliable SEO company recommendations? My company is

RE: Oracle Stored Procedure - another shot, now with procedure code

2004-09-17 Thread Scott Mulholland
Janet, Thanks for your help.I just upgraded one of our servers to 6.1 (the box I was using was just MX) and it worked with no issue now.Looks like it was a driver version issue. Thanks again for all your help with this, it is greatly appreciated! Scott -Original Message- From: Janet

RE: SOLVED: Oracle Stored Procedure - another shot, now with procedure code

2004-09-17 Thread Scott Mulholland
[mailto:[EMAIL PROTECTED] Sent: Friday, September 17, 2004 10:33 AM To: CF-Talk Subject: SOLVED: Oracle Stored Procedure - another shot, now with procedure code Nice. So this was a 6.0 issue... good to know. -Adam - Original Message - From: Scott Mulholland [EMAIL PROTECTED] Date: Fri, 17

RE: Oracle Stored Procedures

2004-09-16 Thread Scott Mulholland
Janet, That makes sense.I was able to get it to run in sql*plus now by doing: VARIABLE rs REFCURSOR execute :rs := test01.testpckg(:rs); print rs Thanks, Scott -Original Message- From: Janet Schmitt [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 15, 2004 9:36 AM To:

Oracle Stored Procedure - another shot, now with procedure code

2004-09-16 Thread Scott Mulholland
Thanks to all who have offered advice thus far.I have since been able to get this running in SQL plus, but still get the same error in CF. (MX, Enterprise edition, using default Oracle driver) Error received: [Macromedia][Oracle JDBC Driver][Oracle]ORA-06550: line 1, column 7: PLS-00306: wrong

RE: Oracle Stored Procedure - another shot, now with procedure code

2004-09-16 Thread Scott Mulholland
Thanks to all who have offered advice thus far.I have since been able to get this running in SQL plus, but still get the same error in CF. (MX, Enterprise edition, using default Oracle driver) Error received: [Macromedia][Oracle JDBC Driver][Oracle]ORA-06550: line 1, column 7: PLS-00306: wrong

RE: Oracle Stored Procedures

2004-09-14 Thread Scott Mulholland
-Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: Monday, September 13, 2004 10:18 AM To: CF-Talk Subject: Re: Oracle Stored Procedures That cursor return needs to be set to IN OUT, not just OUT. -Adam - Original Message - From: Scott Mulholland [EMAIL PROTECTED

RE: Oracle Stored Procedures

2004-09-14 Thread Scott Mulholland
logging in as the schema owner? -Adam - Original Message - From: Scott Mulholland [EMAIL PROTECTED] Date: Tue, 14 Sep 2004 10:57:27 -0400 Subject: RE: Oracle Stored Procedures To: CF-Talk [EMAIL PROTECTED] Thanks Adam.The change has been made but I'm still getting the same error. Here

RE: Oracle Stored Procedures

2004-09-14 Thread Scott Mulholland
We are using the Oracle drivers that ship with MX Enterprise so according to that technote we should be ok with ref cursors. Thanks for the info Janet, I'm currently looking into having the cursor defined along the lines of your last post. Scott -Original Message- From: Janet

RE: Oracle Stored Procedures

2004-09-14 Thread Scott Mulholland
Janet, I have the snippet now from them.This is how it's currently defined (which looks like it's in line with what you posted aside from In Out): Type ReturnSet is ref cursor; Procedure testpckg(curReturnSet Out Returnset); They had switched it before to be In Out for me and I still had

RE: Oracle Stored Procedures

2004-09-14 Thread Scott Mulholland
Janet/Adam, First off thank you guys for all your help thus far, it is greatly appreciated.They did switch it to IN OUT this morning for me and I had the same results. I checked the permissions using the queries Janet supplied: For roles my user has CONNECT and CTXAPP. For table

RE: Oracle Stored Procedures

2004-09-14 Thread Scott Mulholland
Deanna, It is not one of my DBA's, it's an outside vendor so I do not want to post the code.I have actually been changing the package name as well for that reason in my posts.They can run it on their side with no issue using pl/sql developer.I can also run the qry that the procedure executes using

RE: Oracle Stored Procedures

2004-09-14 Thread Scott Mulholland
Adam, I am thinking you may be right based on my last post regarding the EXECUTE privilege. Running it from SQL*PLUS has the same results: SQL exec test01.testpckg; BEGIN test01.testpckg; END; * ERROR at line 1: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in

RE: Setting up Oracle datasource in MX

2004-09-14 Thread Scott Mulholland
Bob, Just use the value that you would find in the tnsnames.ora file if you had one on the machine.Make sense? Scott -Original Message- From: Bob Flynn [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 14, 2004 5:37 PM To: CF-Talk Subject: Setting up Oracle datasource in MX I

RE: Oracle Stored Procedures

2004-09-13 Thread Scott Mulholland
Janet, Thanks for the tip! PROCEDURE TESTPCKG Argument NameTypeIN/OUT Default? CURRETURNSETREF CURSOROUT -Original Message- From: Janet Schmitt [mailto:[EMAIL PROTECTED] Sent: Monday, September 13, 2004 9:23

Oracle Stored Procedures

2004-09-10 Thread Scott Mulholland
Trying to call a stored procedure from Oracle that takes no parameters and returns a cursor. [Macromedia][Oracle JDBC Driver][Oracle]ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'TESTPROC' ORA-06550: line 1, column 7: PL/SQL: Statement ignored I have

RE: Oracle Stored Procedures

2004-09-10 Thread Scott Mulholland
I do not have the package unfortunately. -Original Message- From: Janet Schmitt [mailto:[EMAIL PROTECTED] Sent: Friday, September 10, 2004 12:49 PM To: CF-Talk Subject: Re: Oracle Stored Procedures What does the package specification for TESTPCKG look like? At 01:10 PM 9/10/2004 -0400,

RE: Oracle Stored Procedures

2004-09-10 Thread Scott Mulholland
seen this error (usually when deploying an application with a new schema) it comes back to privs. Check the roles and grants you've given to the user you specified in the datasource connection. -Adam On Fri, 10 Sep 2004 13:10:42 -0400, Scott Mulholland [EMAIL PROTECTED] wrote

OT: SQL Server admin/tuning

2004-08-16 Thread Scott Mulholland
I was looking for a recommendation on a book that would give one a basis or better understanding of SQL server admin/performance tuning. I'm looking for a book that would be useful to someone with a working knowledge of SQL server from the queries/stored procedures/DTS package/table/db design

RE: CGI.HTTP_REFERER is blank!

2004-07-12 Thread Scott Mulholland
Norton Internet Security and similar products will strip it. -Original Message- From: Donnie Carvajal [mailto:[EMAIL PROTECTED] Sent: Monday, July 12, 2004 10:41 AM To: CF-Talk Subject: CGI.HTTP_REFERER is blank! I am trying to check the CGI.HTTP_REFERER variable to keep outside sites

OT: Fireworks MX/data-driven graphics

2004-04-20 Thread Scott Mulholland
I inherited a project today in which someone that used to work here created a batch of images using the Fireworks MX data driven graphics wizard and some xml generated using cold fusion. I was wondering if anyone knew if it was at all possible to call the functionality of that wizard via

RE: check DSL availability

2004-03-22 Thread Scott Mulholland
I used to work for a DSL provider and we had to show availability from Covad, Northpoint and Rhythms.All 3 offered XML interchanges that would let you send the address and phone number and receive the availabilty back for use in your system.Best to contact Sprint and see if they offer something

Cached Queries/Cf Admin

2004-03-04 Thread Scott Mulholland
Is there any rule of thumb or method for figuring out how to optimize the number of queries to cache setting in Administrator? Thanks, Scott [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: EXECUTING EXTERNAL PROGRAM

2003-10-23 Thread Scott Mulholland
Have you tried calling it with cfexecute? -Original Message- From: Gunny [mailto:[EMAIL PROTECTED] Sent: Thursday, October 23, 2003 11:35 AM To: CF-Talk Subject: EXECUTING EXTERNAL PROGRAM Really trying day, today.Will someone please think for me. I think I've lost my mind. I need to

  1   2   >