[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 > ver

[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 i

[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

[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 Of you could do something like this Notice I thre

[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 Of you could do something like this Notice I thre

[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 PROTE

[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 w

[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 * f

[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 [E

[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 [E

[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: error.root

[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] 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 H

[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 sub

[cfaussie] Dreamweaver regular expressions

2007-02-12 Thread Scott Thornton
you have indenting etc in the sql 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

[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] OT: Javascript: Enter key form submit

2007-02-04 Thread Scott Thornton
the same state 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(); > > C

[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 la

[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. function trapEnterKey() { Key = window.event.keyCode; if (Key == 13) {

[cfaussie] Coldfusion and RAM

2007-02-04 Thread Scott Thornton
should return some useful results. Cheers Joel Scott Thornton wrote: > 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? > > > > > > >

[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] 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] 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: (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

[cfaussie] Find and remove a trailing slash from a path - brain fade time

2006-12-05 Thread Scott Thornton
endsWidth() ??? That is a fucntion that can't be found in my CF MX 6.1 manual. >>> [EMAIL PROTECTED] 06/12/2006 4:24 pm >>> Mike Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 --~--~-~--~~

[cfaussie] Re: csv File Import problem

2006-11-16 Thread Scott Thornton
never mind. I looped over the line using line feed as the break, rather than carriage return line feed. sorry, >>> [EMAIL PROTECTED] 17/11/2006 10:37:38 am >>> Hi, Having a bit of a problem with a csv file import Structure is: j225,28-Sep-06,139145,66515| 65126| 65070,1799459 j225,28-Aug

[cfaussie] csv File Import problem

2006-11-16 Thread Scott Thornton
Hi, Having a bit of a problem with a csv file import Structure is: j225,28-Sep-06,139145,66515| 65126| 65070,1799459 j225,28-Aug-06,139115,73527| 69354| 66515| 65126| 65096| 69333,L1796208 j225,01-Sep-06,139122,66515| 65096,L1796669 List element 5 ( obtained by ListGetAt(CSV_RECORD,5,"," )> sh

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

2006-10-24 Thread Scott Thornton
>>> [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 just refer to rownumber 2? The reason i dont reall

[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 appropiat

[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] 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: cfaussi

[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 w

[cfaussie] OT: Javascript equivalent to PreserveSingleQuotes?

2006-10-19 Thread Scott Thornton
e double quotes, eg "Kirribily 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 bec

[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

[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 are

[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] 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 th

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

2006-09-14 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 >>&g

[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: 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 be

[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 t

[cfaussie] Coldfusion Server problems

2006-09-11 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: > > >

[cfaussie] Coldfusion Server problems

2006-09-11 Thread Scott Thornton
--- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] Behalf Of Scott Thornton Sent: Tuesday, 12 September 2006 3:35 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Coldfusion Server problems A colleague of mine writes: " Hi All, I have an intranet site that went down due to a power outage,

[cfaussie] Coldfusion Server problems

2006-09-11 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]> wro

[cfaussie] Coldfusion Server problems

2006-09-11 Thread Scott Thornton
Any help appreciated. Thanks, " 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 ar

[cfaussie] OT: Best development laptop?

2006-09-07 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 Y

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

2006-09-04 Thread Scott Thornton
The orginal use of 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] 05/09/2006 11:46 am >>> Ok, Help, anyone

[cfaussie] Multiple calls of the same page

2006-08-30 Thread Scott Thornton
# Doesn't work ?? I know cfflush likes to cause problems with cookie's, cflocation, etc but I didn't think there was a problem with cfoutput ...?? - Original Message - From: "Scott Thornton" <[EMAIL PROTECTED]> To: Sent: Thursday, August 31, 2006 4:08

[cfaussie] Multiple calls of the same page

2006-08-30 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 >>> ?? - Original Message - From: "Scott Thornton" <[EMAIL PROTECTED]> To: Sen

[cfaussie] Multiple calls of the same page

2006-08-30 Thread Scott Thornton
it all, but I would prefer not to. Any advice? Scott Thornton, Programmer Application Development Information Services and Telecommunications Hunter-New England Area Health Service p: +61 02 49213589 m: 0413800242 --~--~-~--~~~---~--~~ You received this mes

[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

[cfaussie] Session variable strangeness

2006-08-23 Thread Scott Thornton
aussie@googlegroups.com [mailto:[EMAIL PROTECTED] Behalf 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 s

[cfaussie] Session variable strangeness

2006-08-22 Thread Scott Thornton
tes ambiguity when more than one statement involved: show an error B) Avoid re-using session variables throughout the page: ...show an error ... -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] Behalf Of Scott Thornton Sent:

[cfaussie] Session variable strangeness

2006-08-21 Thread Scott Thornton
episode contains (in the dump ) [empty string] . Am I doing something wrong? Or are session variables playing up? Scott Thornton, Programmer Application Development Information Services and Telecommunications Hunter-New England Area Health Service p: +61 02 49213589 m: 0413800242

[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 rep

[cfaussie] CF Administrator - Whitespace Management

2006-08-17 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. Re

[cfaussie] CFECLIPSE search

2006-08-17 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 mo

[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 portio

[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

[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 havin

[cfaussie] Financial Year and Leap Year

2006-08-08 Thread Scott Thornton
oups.com [mailto:[EMAIL PROTECTED] Behalf Of Brett Payne-Rhodes Sent: Wednesday, August 09, 2006 4:30 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Financial Year and Leap Year datediff("d",date1,date2) eq 366 B) Scott Thornton wrote: > Hi, > > Does anyone have a

[cfaussie] Re: Financial Year and Leap Year

2006-08-08 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).

[cfaussie] Financial Year and Leap Year

2006-08-08 Thread Scott Thornton
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, Programmer Application Development Information Services and

[cfaussie] OT

2006-08-06 Thread Scott Thornton
complete" ) { bFinished = true; break; } } else{ thisThread.sleep(100); //this will break out of the loop if this spins for more then a minute. This way we won't have a thread spinning forever

[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 fi

[cfaussie] OT

2006-08-06 Thread Scott Thornton
ite a little app. Joel -Original 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

[cfaussie] OT

2006-08-03 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 and

[cfaussie] Re: CFLOCATION Issue

2006-07-25 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 tag. One computer follows it and the other does not.

[cfaussie] Re: Help with a SQL Query

2006-07-09 Thread Scott Thornton
Hi, FromBooks Online Using Cross Joins A cross join that does not have a WHERE clause produces the Cartesian product of the tables involved in the join. The size of a Cartesian product result set is the number of rows in the first table multiplied by the number of rows in the second table.

[cfaussie] Re: ot: db architecture question

2006-07-05 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:1

[cfaussie] Re: OT: - .NET sucking the life out of me

2006-07-03 Thread Scott Thornton
The only other CF site in Newcastle.. The University of Newcastle, may be beginning the process of porting all of its CF stuff to dot Net soon I am told. Crazy. >>> [EMAIL PROTECTED] 04/07/2006 12:54 pm >>> Hey, This is just a complaining email. I was given the hint today that we may be conve

[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] OT: Dreamweaver - Managing Sites

2006-06-27 Thread Scott Thornton
> > Senior Coldfusion Developer > Aegeon Pty. Ltd. > 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: Wedn

[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 D

[cfaussie] Path to the site root directory

2006-06-22 Thread Scott Thornton
awesome, exactly what I was after. Thanks heaps. >>> [EMAIL PROTECTED] 22/06/2006 7:25 pm >>> put this in your application.cfm application.path = getDirectoryFromPath( getCurrentTemplatePath() ); On 6/22/06, Scott Thornton <[EMAIL PROTECTED]> wrote: > > > Hel

[cfaussie] Path to the site root directory

2006-06-22 Thread Scott Thornton
actually... is a bit closer to what I am after. but when used from a subdirectory of the site... it returns the subdirectory too. I was hoping to avoid that. >>> [EMAIL PROTECTED] 22/06/2006 5:14 pm >>> or am I missing something? - Original Message ----- Fro

[cfaussie] Path to the site root directory

2006-06-22 Thread Scott Thornton
g something? - Original Message - From: "Scott Thornton" <[EMAIL PROTECTED]> To: Sent: Thursday, June 22, 2006 12:17 PM Subject: [cfaussie] Path to the site root directory Hello, Is there a programmatical way of returning the root directory of the website, regardless of

[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:

[cfaussie] Saving Images into Database

2006-06-20 Thread Scott Thornton
Hi, Unfortunatley I am using Crystal 9. I have never gotten around to looking into the new Business Objects versions of Crytsal. As we have over two hundred reports (taking a guess), its not something I am in a hurry or a postion to look into. >>> [EMAIL PROTECTED] 21/06/2006 12:39 pm >>> I

[cfaussie] Saving Images into Database

2006-06-20 Thread Scott Thornton
on Developer Aegeon Pty. Ltd. 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, 21 June 2006 11:54 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Saving

[cfaussie] Saving Images into Database

2006-06-20 Thread Scott Thornton
=devzone_reporting_main Chad 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 dis

[cfaussie] Saving Images into Database

2006-06-20 Thread Scott Thornton
L 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]> wrote: > > Hello, &g

[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

[cfaussie] Saving Images into Database

2006-06-20 Thread Scott Thornton
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: > > Hello, > &g

[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] Re: 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 in . the code is the following: SELECT TOP 1 * FROM clients WHERE client_id = But the following code will run: SELECT *

[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: CFMX7 still

2006-06-04 Thread Scott Thornton
your mail server has been setup, and verified okay? >>> [EMAIL PROTECTED] 05/06/2006 3:34 pm >>> OK, I emailed about this problem to the list a week ago and still have not found a solution to the problem, had someone else to replicate the problem on a CFMX7 install as well. Which makes me think "

[cfaussie] swsoc.exe coldfusion ODBC process

2006-05-31 Thread Scott Thornton
thanks, why didn't I think of that first? >>> [EMAIL PROTECTED] 1/06/2006 2:59 pm >>> Google is our friend... http://www.timen.com/blog/2004/11/13/coldfusion-swsocexe-service-and-excess-cpu-usage/ B) Scott Thornton wrote: > Hello, > > Is swsoc.exe a

[cfaussie] swsoc.exe coldfusion ODBC process

2006-05-31 Thread Scott Thornton
tory/files/swsoc/index.php Running CF MX 6.1 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 becau

[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 mess

[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 date.

[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 q

[cfaussie] Slightly OT - I hate inherited queries

2006-05-04 Thread Scott Thornton
TECTED] Behalf Of Scott Thornton Sent: Friday, May 05, 2006 11:09 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Slightly OT - I hate inherited queries The name of the column is taken from the first query of union query. This name can be referenced in an order by statement which is quite u

[cfaussie] Slightly OT - I hate inherited queries

2006-05-04 Thread Scott Thornton
The name of the column is taken from the first query of union query. This name can be referenced in an order by statement which is quite useful. >>> [EMAIL PROTECTED] 5/05/2006 10:07 am >>> And the use of unions is not my strong point, but shouldn't all the column names match e.g. you've got c

[cfaussie] Slightly OT - I hate inherited queries

2006-05-04 Thread Scott Thornton
someone has copied and pasted that query from Microsoft Access originally.. it uses brackets.. or maybe Crystal Reports was used to generate it. I have never seen anyone type them themselves. >>> [EMAIL PROTECTED] 5/05/2006 9:58 am >>> get rid of the brackets on the inner join, from what i can

[cfaussie] Re: webservice woes

2006-04-27 Thread Scott Thornton
Hi, I got the same error, if that helps. Could not generate stub objects for web service invocation. Name: http://webservices.amazon.com/AWSECommerceService/AWSECommerceService.wsdl. WSDL: http://webservices.amazon.com/AWSECommerceService/AWSECommerceService.wsdl. java.net.ConnectException

[cfaussie] Database Locking and Coldfusion Server stopping

2006-04-27 Thread Scott Thornton
CTED] On Behalf Of Scott Thornton Sent: Friday, April 28, 2006 12:00 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Database Locking and Coldfusion Server stopping Hi, I am getting locks on my database, and when this happens, coldfusionserver seems to stop serving requests until the locks

[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: 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

<    1   2   3   4   >