[cfaussie] Connecting to Novell Groupwise

2006-02-06 Thread Scott Thornton
Hi, Does anyone know if cf 6.1 can connect to and read a Novell Groupwise email server\account? Specifically read an email, grabs its attachment and foward it elsewhere? Cheers?

[cfaussie] Re: cfdocument fonts

2006-02-27 Thread Scott Thornton
crytal reports. [EMAIL PROTECTED] 28/02/2006 12:45:43 pm I have to generate a lot of reports and was looking at CFDOCUMENT as a solution, until I discovered that CFDOCUMENT does not handle all types of fonts. What else can I use or can I get CFDOCUMENT to use the fonts I require? Steve

[cfaussie] Site-wide Error Handler

2006-03-13 Thread Scott Thornton
, for which I would like to present 'nicer' error messages for. I appreaciate any thoughts\experiences offered Thanks heaps. Scott Thornton, Programmer Application Development Information Services and Telecommunications Hunter-New England Area Health Service p: +61 2 49813589 m

[cfaussie] Datasource to Oracle

2006-03-16 Thread Scott Thornton
Hi, Running CFMX 6.1. I notice that there is no option to add a datasource to connect to Oracle. A colleague reckons we need to get Enterprise. Is this indeed the case? Cheers, Scott Thornton, Programmer Application Development Information Services and Telecommunications Hunter-New England

[cfaussie] Datasource to Oracle

2006-03-16 Thread Scott Thornton
Thanks for all replies. We may give the below a go, or just splurge on Enterprise (like I wanted to do in the first place... and go to version 7). [EMAIL PROTECTED] 17/03/2006 10:48 am Scott, That is totally the case. However you can hook up to Oracle using JDBC and/or ODBC drivers

[cfaussie] Re: Dealing with a random number of images

2006-03-21 Thread Scott Thornton
Hello, If you wish to use one query only, and have to deal with 0-n images, then you will have to left outer join your Image table. eg select * from re_property prop left outer join re_image image on prop.propid = image.propid [EMAIL PROTECTED] 22/03/2006 10:22:22 am Hi guys, Putting

[cfaussie] Dealing with a random number of images

2006-03-21 Thread Scott Thornton
Hi, maybe you could ask over at macromedia exchange, there is a forum there exclusive to flash-forms within the coldfusion topic. http://www.macromedia.com/cfusion/webforums/forum/categories.cfm?forumid=1catid=22entercat=y I guess you need a sort of multiple detail section to display all of

[cfaussie] Dealing with a random number of images

2006-03-22 Thread Scott Thornton
ON i1.propid = p.propid and i1.image_order = 1 LEFT OUTER JOIN re_image i2 ON i2.propid = p.propid and i2.image_order = 2 LEFT OUTER JOIN re_image i3 ON i3.propid = p.propid and i3.image_order = 3 etc etc etc Scott Thornton, Programmer Application Development Information Services

[cfaussie] RAM sizing on production servers

2006-03-28 Thread Scott Thornton
Hi, What is the average amount of RAM do you guys have on your production coldfusion servers? How much do you allocate to coldfusion (I think I mean allocated to jrun?) ? I assume the machine has nothing on it except for coldfusion and an OS like windows 2003. Cheers, Scott Thornton

[cfaussie] RAM sizing on production servers

2006-03-28 Thread Scott Thornton
not like to run a windows server with less than 2GB total RAM on the server so that you have the flexibility to go to the full 1GB JVM memory if required. Grant -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Scott Thornton Sent: Wednesday, March

[cfaussie] Site Wide Error Template - SQL?

2006-03-29 Thread Scott Thornton
Hi, The default coldfusion error page includes the SQL of a query if the error is query related. Using the site site wide error template, is it possible to get hold of and display this sql? Using cfdump var=#error# label=error structure, there is no sql displayed, and only the

[cfaussie] Site Wide Error Template - SQL?

2006-03-30 Thread Scott Thornton
: #error.rootCause.tagContext[1].SQL#br /cfif You may not need to use the whole thing. The template has been made to run on a few different versions of CF since 4.5 :) Joel -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] Behalf Of Scott Thornton Sent: Thursday

[cfaussie] Site Wide Error Template - SQL?

2006-03-30 Thread Scott Thornton
].SQL#br /cfif You may not need to use the whole thing. The template has been made to run on a few different versions of CF since 4.5 :) Joel -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] Behalf Of Scott Thornton Sent: Thursday, 30 March 2006 1:30 PM

[cfaussie] sql injection was: tvguide.com.au

2006-03-30 Thread Scott Thornton
not debugging, more 'Enable Robust Exception Information' is checked. [EMAIL PROTECTED] 31/03/2006 3:01:00 pm Yes, You are correct, but there will be other queries on the page, I'm sure. What you need for SQL injection, a table name: users.dbo.person So the error gives all that and more,

[cfaussie] Re: OT: XML vs database

2006-04-02 Thread Scott Thornton
Use a database! Use a database!! Use a database!!! Use a database [EMAIL PROTECTED] 3/04/2006 10:50 am I was all set to create a new database for an application that is basically a contact list for doctors when I thought Would this be better as an XML file?. I've never used an XML

[cfaussie] Re: CF and Acrobat...

2006-04-04 Thread Scott Thornton
Could the word document be locked by another process? Can you try a different doc? [EMAIL PROTECTED] 4/04/2006 4:41 pm Hi, Has anybody had a go at using Acrobat as a COM object to convert MS Word files to pdf? I've been through a variety of tools with varying degrees of success. All seem

[cfaussie] Re: comparing two queries - which records are different

2006-04-19 Thread Scott Thornton
can you left outer joins in query-of-queries? I don't know if you can, but if so, that would be a good palce to start. otherwise, order the fields the same, paste the results into excel, and run your eye over it. :-0 [EMAIL PROTECTED] 20/04/2006 11:37 am hi all I have 2 multi-tabled

[cfaussie] Database Locking and Coldfusion Server stopping

2006-04-27 Thread Scott Thornton
Hi, I am getting locks on my database, and when this happens, coldfusionserver seems to stop serving requests until the locks are released. Any ideas on how to stop this happening? (besides stoppping the locking.. which I am working on that already) Scott Thornton, Programmer Application

[cfaussie] Re: CF aptitude test

2006-05-14 Thread Scott Thornton
Hello, If you have a copy, some of the questions out of Ben Forta's CF MX Exam guide would be good. [EMAIL PROTECTED] 15/05/2006 11:32 am Hey all, On the subject of recruitement, which has been a hot topic lately, just wondering if anyone out there has a set of ColdFusion technical

[cfaussie] Re: Dates

2006-05-16 Thread Scott Thornton
Hi, when I wish to do crazy stuff like this, I add to the database a table I created a few years back, each row contains (from about 1995 to 2015) the date, week, the finiancial year, the financial quarter and so on. I simply join on this table and output the required cell, sorted by the

[cfaussie] OT: Intellisense for MS Query Analyzer

2006-05-24 Thread Scott Thornton
Hi, Users of MS Query Analyser may like using the following which I have just installed for getting intellisense display-as-you-type database objects within QA: http://www.red-gate.com/products/SQL_Prompt/ Cheers, --~--~-~--~~~---~--~~ You received this

[cfaussie] Re: OT: Virus protection software

2006-06-07 Thread Scott Thornton
Hello, At hunter health we use Trend Micro... I guess its acorporate edition as updates are regularly updated. [EMAIL PROTECTED] 08/06/2006 10:00 am Hey all, Just a quick poll to find out which Virus / Spyware protection software people are using these days (no Linux is not an answer :).

[cfaussie] Re: cfqueryparam and SELECT TOP *

2006-06-08 Thread Scott Thornton
Ok, I will bite, what is the strange error? [EMAIL PROTECTED] 09/06/2006 11:22 am Hi, All I got a very strange error when i use cfqueryparam in cfquery. the code is the following: cfquery name=getClient datasource=#dsn# SELECT TOP 1 * FROM clients WHERE client_id =

[cfaussie] Saving Images into Database

2006-06-20 Thread Scott Thornton
Hello, I use CFX_PUTIMAGE to save images into my database. I find it very slow. Is there any alternatives? Scott Thornton, Programmer Application Development Information Services and Telecommunications Hunter-New England Area Health Service p: +61 02 49213589 m: 0413800242

[cfaussie] Saving Images into Database

2006-06-20 Thread Scott Thornton
Are you alluding to an alternative to CFX_PUTIMAGE ? :-) [EMAIL PROTECTED] 21/06/2006 11:41 am Does doing it in plain CF make any difference? Blair On 6/21/06, Scott Thornton [EMAIL PROTECTED] wrote: Hello, I use CFX_PUTIMAGE to save images into my database. I find it very slow

[cfaussie] Saving Images into Database

2006-06-20 Thread Scott Thornton
: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] Behalf Of Mark Mandel Sent: Wednesday, 21 June 2006 11:28 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Saving Images into Database Save them to disk? Or does that sound too simple? :D Mark On 6/21/06, Scott Thornton [EMAIL PROTECTED

[cfaussie] Saving Images into Database

2006-06-20 Thread Scott Thornton
On 6/21/06, Scott Thornton [EMAIL PROTECTED] wrote: Crystal Reports require the image to be in a database. If only it were that simple. [EMAIL PROTECTED] 21/06/2006 11:28 am Save them to disk? Or does that sound too simple? :D Mark On 6/21/06, Scott Thornton [EMAIL PROTECTED] wrote

[cfaussie] Path to the site root directory

2006-06-21 Thread Scott Thornton
this location is stored in the database... but I don't think this is the best method Scott Thornton, Programmer Application Development Information Services and Telecommunications Hunter-New England Area Health Service p: +61 02 49213589 m: 0413800242

[cfaussie] Path to the site root directory

2006-06-22 Thread Scott Thornton
=GetDirectoryFromPath(thisPath) or am I missing something? - Original Message - From: Scott Thornton [EMAIL PROTECTED] To: cfaussie@googlegroups.com Sent: Thursday, June 22, 2006 12:17 PM Subject: [cfaussie] Path to the site root directory Hello, Is there a programmatical way of returning

[cfaussie] Path to the site root directory

2006-06-22 Thread Scott Thornton
=GetDirectoryFromPath(thisPath) or am I missing something? - Original Message - From: Scott Thornton [EMAIL PROTECTED] To: cfaussie@googlegroups.com Sent: Thursday, June 22, 2006 12:17 PM Subject: [cfaussie] Path to the site root directory Hello, Is there a programmatical way of returning

[cfaussie] OT: Dreamweaver - Managing Sites

2006-06-27 Thread Scott Thornton
Hi, The 'site' I am working with in the moment is insisting on saving around 20-30 related files when I save a single document. These other documents have not changed. Does any know of a setting I may turn off to stop the behaviour? Scott Thornton, Programmer Application Development

[cfaussie] OT: Dreamweaver - Managing Sites

2006-06-27 Thread Scott Thornton
. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Scott Thornton Sent: Wednesday, 28 June 2006 12:17 PM To: cfaussie@googlegroups.com Subject: [cfaussie] OT: Dreamweaver - Managing Sites Hi

[cfaussie] Re: Automatic FTP to back up SQL server

2006-06-29 Thread Scott Thornton
Hi, MS SQL 2000 Data Transformation Services (DTS) has a FTP task.. Why not use that? [EMAIL PROTECTED] 30/06/2006 12:22 pm Has any one heard of or used any good automatic FTP backup solutions for SQL database (2000 and 2005)? we're looking for a program to install that backs up MS SQL

[cfaussie] Re: ot: db architecture question

2006-07-06 Thread Scott Thornton
Hi, Sounds like a post for http://thedailywtf.com/ BUT, Do you need the extra layer of abstraction so you are not running queries against a live server? You could set up some replication of the database.. I think I saw you mention a second SQL server. [EMAIL PROTECTED] 06/07/2006 3:23:10

[cfaussie] Re: CFLOCATION Issue

2006-07-26 Thread Scott Thornton
does CFFLUSH appear any where on the page? [EMAIL PROTECTED] 26/07/2006 4:45:13 pm I have never seen this issue before so I am putting it out there to see if anyone knows what might be happening.. It seems to be an issue with the cflocation tag. One computer follows it and the other does

[cfaussie] OT

2006-08-04 Thread Scott Thornton
Hi, anyone know of a software program that would take one large text file, and chop it into chunks, of say 1000 lines of code per file, where each line delimited by carriage returns. on windows. Scott Thornton, Programmer Application Development Information Services

[cfaussie] OT

2006-08-06 Thread Scott Thornton
Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] Behalf Of Scott Thornton Sent: Friday, 4 August 2006 4:24 PM To: cfaussie@googlegroups.com Subject: [cfaussie] OT Hi, anyone know of a software program that would take one large text file, and chop it into chunks, of say

[cfaussie] OT

2006-08-06 Thread Scott Thornton
Hi, I have a work colleague looking after it for me now... Using EVE on VMS. Cheers, [EMAIL PROTECTED] 07/08/2006 10:19 am Hi Scott, you wrote: Hi, anyone know of a software program that would take one large text file, and chop it into chunks, of say 1000 lines of code per file, where

[cfaussie] OT

2006-08-06 Thread Scott Thornton
cfflush /cffunction HTH, David Scott Thornton wrote: Hi, anyone know of a software program that would take one large text file, and chop it into chunks, of say 1000 lines of code per file, where each line delimited by carriage returns. on windows. Scott Thornton, Programmer

[cfaussie] Re: Financial Year and Leap Year

2006-08-09 Thread Scott Thornton
nevermind. [EMAIL PROTECTED] 09/08/2006 4:17:44 pm Hi, Does anyone have a function (hopefully sql) that would return true if a date in a financial year (01/07/xx to 31/06/yy) and there happened to be a leap year in that period? (Hope I explained myself okay). Scott Thornton

[cfaussie] Re: CF Memory Usage

2006-08-13 Thread Scott Thornton
you could try obtaining and running a copy of fusionreactor http://www.fusion-reactor.com/ PS. They released the eclipse plugin today for de-bugging CF apps. [EMAIL PROTECTED] 14/08/2006 3:35 pm Anyone know of any way to run a script and see how much memory was used to run it? Am having an

[cfaussie] Fullasagoog a waste of time.

2006-08-17 Thread Scott Thornton
Thunderbird by mozilla for mail and rss. [EMAIL PROTECTED] 18/08/2006 11:24 am I actually use www.live.com and although I have an RSS reader added, I don't use it for RSS feeds as I use IE7.0 for that, firefox has a few too but haven't used them so I can't comment on them either. I also did

[cfaussie] Re: CFECLIPSE search

2006-08-17 Thread Scott Thornton
I was wondering the same thing myself today. I gave up after a few minutes though and fired up dreamweaver again. [EMAIL PROTECTED] 18/08/2006 3:14 pm Hey Guys, Just a simple one, does anyone know how to do a find and replace on an entire project in cfeclipse? I found the search portion and

[cfaussie] CFECLIPSE search

2006-08-18 Thread Scott Thornton
What is required is, to use Dreamweaver terminology: Entire Current Local Site search. I have the search on a single page down pat. :-) [EMAIL PROTECTED] 18/08/2006 3:47 pm I just hold down CTRL-SHIFT-F and then enter in a string to replace ..Or am I just having another blond moment?

[cfaussie] CF Administrator - Whitespace Management

2006-08-18 Thread Scott Thornton
Hi, I experience swsoc.exe using 99% cpu and lots of ram and my local machine.. no Informix in sight. Jsut MS SQL and jdbc drivers. [EMAIL PROTECTED] 18/08/2006 4:17 pm This means you have some dodgy code somewhere not freeing up memory. You should have a look at fusion reactor. Regards

[cfaussie] Access Lock File

2006-08-20 Thread Scott Thornton
could you program a CFFILE delete of the lock file immedialty after the population of the database? [EMAIL PROTECTED] 21/08/2006 10:55 am Hi Chad, Im using access to dump very small sections of data from a much larger SQL database so users can download the access db and run ad hoc reports

[cfaussie] Session variable strangeness

2006-08-22 Thread Scott Thornton
no longer seem to contain a value. I am emailed an error of a CFDUMP of the session structure when errors like this occur, and the variable episode contains (in the dump ) [empty string] . Am I doing something wrong? Or are session variables playing up? Scott Thornton, Programmer Application

[cfaussie] Session variable strangeness

2006-08-22 Thread Scott Thornton
...show an error /cfif ... CFQUERYPARAM cfsqltype=cf_sql_numeric value=#episode# -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] Behalf Of Scott Thornton Sent: Tuesday, 22 August 2006 4:41 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Session

[cfaussie] Session variable strangeness

2006-08-23 Thread Scott Thornton
Of darryl lyons Sent: Wednesday, 23 August 2006 9:50 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Session variable strangeness I'm guessing its in reference to the days prior to CFMX, where you had to lock reads to SESSION scoped variables. On 23/08/06, Scott Thornton [EMAIL PROTECTED

[cfaussie] Decrypt all cfm pages for a site

2006-08-29 Thread Scott Thornton
Hmm, I downloaded a version of grep from somewhere that runs fine on windows... Scott Thornton, Programmer Application Development Information Services and Telecommunications Hunter-New England Area Health Service p: +61 02 49213589 m: 0413800242 [EMAIL PROTECTED] 30/08/2006 12:40:49 pm

[cfaussie] Multiple calls of the same page

2006-08-30 Thread Scott Thornton
template=sbmt215_act.cfm Completed #SECTOR.SB_SECTOR_DESC# br cfflush /cfoutput The error is Element SB_SECTOR_ID is undefined in SECTOR. There are only 6 records in the sector query, so I could, hard code it all, but I would prefer not to. Any advice? Scott Thornton, Programmer

[cfaussie] Multiple calls of the same page

2006-08-31 Thread Scott Thornton
Nope, that does not work. The value of the attribute query, which is currently SESSION.SECTOR, is invalid. [EMAIL PROTECTED] 31/08/2006 3:52:02 pm CFQUERY datasource=#DSN# name=SESSION.SECTOR ?? - Original Message - From: Scott Thornton [EMAIL PROTECTED] To: cfaussie

[cfaussie] Multiple calls of the same page

2006-08-31 Thread Scott Thornton
with cookie's, cflocation, etc but I didn't think there was a problem with cfoutput ...?? - Original Message - From: Scott Thornton [EMAIL PROTECTED] To: cfaussie@googlegroups.com Sent: Thursday, August 31, 2006 4:08 PM Subject: [cfaussie] Multiple calls of the same page Nope, that does

[cfaussie] Re: Someone help with this bit of code?

2006-09-04 Thread Scott Thornton
The orginal use of cfoutput query=BookingInfo group=BO_ID without ordering by BO_ID in the query is incorrect as the you would get three groups rather than two if the ids came out of the query as 1 2 1 which is three groups rather than 1 1 2 which is two groups. [EMAIL PROTECTED]

[cfaussie] OT: Best development laptop?

2006-09-08 Thread Scott Thornton
Scott: which gov't dpt do you work in? [EMAIL PROTECTED] 08/09/2006 4:14 pm Yeah, Govt work has its moments (where we actually do work).. ;) heh On 9/8/06, Dmitry Yakhnov [EMAIL PROTECTED] wrote: Do you have time to play games? J Lucky boy! Best regards, *Dmitry Yakhnov* Web

[cfaussie] Coldfusion Server problems

2006-09-12 Thread Scott Thornton
services are running. machine has been rebooted a couple of times. [EMAIL PROTECTED] 12/09/2006 3:56 pm Check the services running on the machine and make sure that the ColdFusion ones have restarted. Blair On 9/12/06, Scott Thornton [EMAIL PROTECTED] wrote: A colleague of mine writes

[cfaussie] Coldfusion Server problems

2006-09-12 Thread Scott Thornton
thanks, do you think that is different from an ordinary reboot, which has been performed? [EMAIL PROTECTED] 12/09/2006 4:28 pm Try stopping all of the ColdFusion Services, then reboot. On 9/12/06, Scott Thornton [EMAIL PROTECTED] wrote: Hmm, In Firefox the page tries to download (like

[cfaussie] Coldfusion Server problems

2006-09-12 Thread Scott Thornton
naturally. [EMAIL PROTECTED] 12/09/2006 7:27 pm Or certain crucial files have been corrupted meaning a re-install is a possibility. Of course you have backed up crucial data? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the

[cfaussie] Re: Querying across multiple databases

2006-09-12 Thread Scott Thornton
Hi, The query you have posted shows the correct syntax for using a table from a different database. (i think I would add the server name too). you could always create a view with the table inside of it. [EMAIL PROTECTED] 13/09/2006 10:52 am Hi all I think I remember a post on this before

[cfaussie] Re: Coldfusion Server problems

2006-09-13 Thread scott . thornton
My colleague says: Hi Scott, This turned out to be a corruption of the $CF_HOME/lib/license.properties file. When replaced with a valid file, the server started processing CF pages again. Thanks for you help , and can you please thank all on CF Aussie who offerred assistance. Cheers, Phil.

[cfaussie] Re: SQL Error message explanation - whats this really mean ?

2006-09-15 Thread Scott Thornton
what see queries are hitting the db, specifically the parameters being passed to the prepared sql of your query. Scott Thornton, Programmer Application Development Information Services and Telecommunications Hunter-New England Area Health Service p: +61 02 49213589 m: 0413800242 [EMAIL

[cfaussie] Query picking up an odd value from somewhere

2006-09-26 Thread Scott Thornton
regarding your vaguley related question: can you UNION yor queries together? (assuming all the fields are in the same order and of the same data type) [EMAIL PROTECTED] 27/09/2006 11:11 am On 26/09/06, Greg Misdom [EMAIL PROTECTED] wrote: I'm not much of a sql person, but I'd say that each

[cfaussie] Help with a Oracle issue

2006-09-26 Thread Scott Thornton
does arguments.object.getTable() return something that the cfqueryparam might think is something more complicated than an actual varchar\string? [EMAIL PROTECTED] 27/09/2006 11:53 am How is this for bizarre - If I remove the binding - i.e. change SELECT

[cfaussie] Maximum number of simultaneous requests

2006-10-17 Thread Scott Thornton
at the moment. Is this correct? Scott Thornton, Programmer Application Development Information Services and Telecommunications Hunter-New England Area Health Service p: +61 02 49213589 m: 0413800242 --~--~-~--~~~---~--~~ You received this message because you

[cfaussie] Re: Using cfqueryparam

2006-10-19 Thread Scott Thornton
Not sure about the speed issue, but may I say that you may wish to think about using SCOPE_IDENTITY() rather than @@IDENTITY. [EMAIL PROTECTED] 20/10/2006 9:36 am Hello all, Are there any issues with CFqueryparam using insert statements that I should know about? # MyTable has about 4.5

[cfaussie] OT: Javascript equivalent to PreserveSingleQuotes?

2006-10-19 Thread Scott Thornton
House Scott Thornton, Programmer Application Development Information Services and Telecommunications Hunter-New England Area Health Service p: +61 02 49213589 m: 0413800242 --~--~-~--~~~---~--~~ You received this message because you are subscribed

[cfaussie] Using cfqueryparam

2006-10-19 Thread Scott Thornton
Books online says it better, but in short: Say your table has a trigger on it, and that trigger inserts something into a different table, @@identity returns the ID from the insert caused by the trigger, rather than the ID you actually want. scope_identity() knows what 'scope' you are working

[cfaussie] OT: Javascript equivalent to PreserveSingleQuotes?

2006-10-19 Thread Scott Thornton
awesome, thanks. [EMAIL PROTECTED] 20/10/2006 11:33 am JSStringFormat() Will escape everything you need -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Scott Thornton Sent: Friday, 20 October 2006 11:28 AM To: cfaussie@googlegroups.com

[cfaussie] Re: How to create a popup window after some Cf processing

2006-10-22 Thread Scott Thornton
Can you use URL vars instead of forms vars in your preview function? function openPopupScreen() { // opens popup window without all the toolbars menu etc var window; var uniquename = Math.floor(Math.random()*100); uniquename = uniquename.toString(); loginwindow =

[cfaussie] Re: Database deadlocks

2006-10-24 Thread Scott Thornton
Hi, I get this error ALL too often. Its very difficult tracking down the problem on the database end... identifying what query is blocking the query that is terminated. It is not as simple as using the cftransaction tag. It 'can' help, but you will need to select the isolation level

[cfaussie] Re: Accessing a specific row of a query?

2006-10-24 Thread Scott Thornton
cfoutput startrow=2 maxrows=1 query=queryname /cfoutput [EMAIL PROTECTED] 25/10/2006 1:13 pm Is there a way to acess a specific row in a query? For example i know the record i want is record number 2 in a query, so other than doing a select in a queryofqueries, is there a simple way to

[cfaussie] Re: (shakes fist at) adobe.com

2006-12-06 Thread Scott Thornton
Download the CFML reference in pdf format and never go back. I believe its called cfmx61_cfml_reference.zip Suppose there may be one for actionscript... [EMAIL PROTECTED] 07/12/2006 10:53:00 am For a company that sells web application server software... they sure have a slow site. I dread

[cfaussie] Re: Development Options

2006-12-20 Thread Scott Thornton
SQl Server backend MS Access front end. [EMAIL PROTECTED] 21/12/2006 7:51 am Hey all, I am two careers removed from my legit coding days, but I still tinker along the edges. As such, I typically find one or two projects each year to keep my fingers in the pie. I am weighing up another

[cfaussie] Re: pdf embedding

2007-01-02 Thread Scott Thornton
Hi, I load uploaded images into a database, and display them within Crystal Reports 9. The Report I then display in pdf format. works great. Scott Thornton, Programmer Application Development Information Services and Telecommunications Hunter-New England Area Health Service p: +61 02 49213589

[cfaussie] Coldfusion and RAM

2007-01-29 Thread Scott Thornton
Hi, Is it possible to make CF MX 6.1 standard use more than approx 500meg RAM? (fusion reactor reports 505 meg.. I suspect it uses 512) Is it wise to do so? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie

[cfaussie] Coldfusion and RAM

2007-02-04 Thread Scott Thornton
a clean block of RAM that nothing else is using. If something is (and you've used the xmx=xms rule), CF will not start and you will need to modify the JVM config manally. Looking up coldfusion jvm xmx xms in [your favourite search engine] should return some useful results. Cheers Joel Scott Thornton

[cfaussie] OT: Javascript: Enter key form submit

2007-02-04 Thread Scott Thornton
Hi, User presses enter key, I want the form to submit with the correct button focused. My attempt does not seem to properly focus so on the action page, the button BTN_FIND is not defined. script language=javascript function trapEnterKey() { Key = window.event.keyCode; if

[cfaussie] Re: OT: Translation services

2007-02-04 Thread Scott Thornton
SBS tv is always advertising what you are after.. Angus Johnson [EMAIL PROTECTED] 05/02/2007 11:18 am Hi Guys, Has anyone had any dealings with a company that specialises in translation services? I need to to translate some content and UI resource bundles into a bunch of European languages

[cfaussie] OT: Javascript: Enter key form submit

2007-02-04 Thread Scott Thornton
as if the user used the mouse instead of the keyboard. Blair On 2/5/07, Adam Chapman [EMAIL PROTECTED] wrote: Hi Scott, How about giving your button an id attribute.. then: document.getElementById(BTN_FIND).focus(); Cheers, Adam PS.. untested.. -Original Message- From: Scott

[cfaussie] Dreamweaver regular expressions

2007-02-12 Thread Scott Thornton
Hi, I need to look through my code for the INSERT INTO * WITH (NOLOCK) where the * can be any table name. Can anyone advise what the correct syntax may be? ta, Scott Thornton, Programmer Application Development Information Services and Telecommunications Hunter-New England Area Health

[cfaussie] Dreamweaver regular expressions

2007-02-12 Thread Scott Thornton
then: /INSERT\s*INTO\s*[^\s]*\s*WITH\s*(NOLOCK)/ Blair On 2/13/07, Scott Thornton [EMAIL PROTECTED] wrote: Hi, I need to look through my code for the INSERT INTO * WITH (NOLOCK) where the * can be any table name. Can anyone advise what the correct syntax may be? ta, Scott Thornton, Programmer

[cfaussie] Dreamweaver regular expressions

2007-02-13 Thread Scott Thornton
thanks for all advice. I will look into agent ransack, and agree its about time I tried Eclipse again ( it was my inability to use the search in the first place that stopped me using). cheers, --~--~-~--~~~---~--~~ You received this message because you are

[cfaussie] Dreamweaver regular expressions

2007-02-14 Thread Scott Thornton
Hmm, The regular expression below does not work for me. Using Agent ransack there is a Test option. It doesn't work with the test phrase: INSERT INTO MY_TABLE_NAME WITH (NOLOCK) Oh well. Scott Thornton, Programmer Application Development Information Services and Telecommunications Hunter

[cfaussie] Using a MS SQL 2000 64bit datasource

2007-02-14 Thread Scott Thornton
Hi, A database I connect to is being migrated to the above. I've connected to and tested my stored procedures etc, but wondered if anyone has encountered any problems \ gotchas when connection to a 64 bit edition of MS SQL? I imagine that there should not be anything, and I can't seem to find

[cfaussie] Query Parameter List in the Error Structure

2007-02-20 Thread Scott Thornton
Hi, I use a site wide error template that emails the text of the query that caused a problem. When the query uses cfqueryparam tags the parameters passed are in the form (param 1) etc in the text of the query. Is it possible to find out what these params are? To get the SQL I use:

[cfaussie] Query Parameter List in the Error Structure

2007-02-20 Thread Scott Thornton
Hi Charlie, Using CF MX 6.1. Damn. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to

[cfaussie] Query Parameter List in the Error Structure

2007-02-22 Thread Scott Thornton
I will give that a go on the weekend. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to

[cfaussie] @#$!! queryparam

2007-03-01 Thread Scott Thornton
Andrew, I disagree. Although cfqueryparam performs vailidation, it is not the reason you should be using it. cfqueryparam makes the database engine use parameter binding on your queries. For example your query below would look different to the db engine every time it is run eg: Select *

[cfaussie] FineNoCase Problem

2007-03-01 Thread Scott Thornton
Hi, I have been using FindNoCase(x,'OPPO,OPSNC,OPVAN,OPGEN,INP') gt 0 for a while but only noticed today that if the value of x is OPVA it would match on the value OPVAN. Not what I was expecting. I have changed the statement to use multiple comparison eg x=oppo or x=opsnc and so on, but

[cfaussie] FineNoCase Problem

2007-03-01 Thread Scott Thornton
oops. I have used both in the application. ta. Adam Chapman [EMAIL PROTECTED] 02/03/2007 3:03 pm ListFindNoCase('OPPO,OPSNC,OPVAN,OPGEN,INP', x) gt 0 Cheers, Adam -Original Message- From: Scott Thornton [mailto:[EMAIL PROTECTED] Sent: Friday, 2 March 2007 2:48 PM To: cfaussie

[cfaussie] FineNoCase Problem

2007-03-01 Thread Scott Thornton
thanks. Andrew Scott [EMAIL PROTECTED] 02/03/2007 3:01 pm Scott, Well that is a doosy, but maybe you should be looking at contains and not FindNoCase. Because x = opva will always return true as will x=op I suggest using cfif StringToCompareAgainst contains 'OPPO,OPSNC,OPVAN,OPGEN,INP' Of

[cfaussie] FineNoCase Problem

2007-03-01 Thread Scott Thornton
thanks. Andrew Scott [EMAIL PROTECTED] 02/03/2007 3:01 pm Scott, Well that is a doosy, but maybe you should be looking at contains and not FindNoCase. Because x = opva will always return true as will x=op I suggest using cfif StringToCompareAgainst contains 'OPPO,OPSNC,OPVAN,OPGEN,INP' Of

[cfaussie] CFQUERYPARAM was RE: [cfaussie] Re: @#$!! queryparam

2007-03-04 Thread Scott Thornton
I think CF would only cache the queries if cachedafter= or cachedwithin= was used. Andrew Scott [EMAIL PROTECTED] 05/03/2007 10:38 am Duncan, But the Admin says Cached Queries so I am going to guess its CF, just wanted to make sure I was right on my assumption. And if you read my post, hey

[cfaussie] Web Version Control

2007-03-29 Thread Scott Thornton
Hi, A colleague and I work at two different locations.. his user-created version control is a bit clunky but it gets us by (well not really, it is shite and does not work at all when he is off site), but what I really want is a version control system that we can use over the web to check

[cfaussie] Web Version Control

2007-03-29 Thread Scott Thornton
that's what I mean. Haikal Saadh [EMAIL PROTECTED] 30/03/2007 4:16 pm Subversion works over http, if that's what you mean. Scott Thornton wrote: Hi, A colleague and I work at two different locations.. his user-created version control is a bit clunky but it gets us by (well

[cfaussie] outputting recordset

2007-04-05 Thread Scott Thornton
Hi, You probably don't want to calculate the length of the array within every iteration of the loop if it does not change. cfset arraylength = arrayLen(data) Dale Fraser [EMAIL PROTECTED] 05/04/2007 3:29 pm Working example. cfset data = listToArray('1,2,3,4,5,6,7,8,9,10,11,12,13') /

[cfaussie] CFMX 7 New Install - Error Occurred While Processing Request

2007-04-23 Thread Scott Thornton
Hi, new install of cf mx 7 on a new DELL PC. getting the above error when attempting to browse http://localhost/CFIDE/administrator/index.cfm IIS is started. CF services are started. I have run the IIS_connector.bat in the bin\connector directory. rebooted a couple of times. The IIS

[cfaussie] CFMX 7 New Install - Error Occurred While Processing Request

2007-04-24 Thread Scott Thornton
provider installed... at javax.crypto.Cipher.getInstance([DashoPro-V1.2-120198]) is your clue... try getting rid of that provider or using a clean JDK install. On Apr 24, 3:19 pm, Scott Thornton [EMAIL PROTECTED] wrote: Hi, new install of cf mx 7 on a new DELL PC. getting the above error when

[cfaussie] Reading CSV Files - Carriage Returns

2007-05-03 Thread Scott Thornton
Hi, Attempting to read a .csv file. Unfortunately some of the records have a carriage return in one of the fields so it seems I cannot use the carriage return line feed characters as a line delimiter. ( Chr(13) Chr(10) ). Has anyone got any ideas for working around this? The file is

[cfaussie] Re: Oracle9i how to count statuses?

2007-05-07 Thread Scott Thornton
Hi, This is how I might do it in SQL Server: SELECT SUM(CASE WHEN deliverymethod = 'F' THEN 1 ELSE 0 END) AS FAXES, SUM(CASE WHEN deliverymethod = 'E' THEN 1 ELSE 0 END) AS EMAILS

  1   2   3   >